/****** Object:  StoredProcedure [dbo].[GetPortalSettings5b]    Script Date: 01/19/2013 20:40:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE  PROCEDURE [dbo].[GetPortalSettings5b]
(
    @PortalId      int,
    @TabId         int,    
	@IsEmarket bit OUTPUT,
    @PortalName    nvarchar(128) OUTPUT,
	@Email  nvarchar(100) OUTPUT,
    @AlwaysShowEditButton bit OUTPUT,
    @TabName       nvarchar (50)  OUTPUT,
    @TabOrder      int OUTPUT,
    @ParentId      int OUTPUT,	--JH return parentId for menu
    @IconURL      nvarchar(50) OUTPUT,	--JH return IconURL for menu
    @MobileTabName nvarchar (50)  OUTPUT,
    @AuthRoles     nvarchar (256) OUTPUT,
    @ShowMobile    bit OUTPUT,
    @ShowMenu    bit OUTPUT,
    @ShowFotterMenu    bit OUTPUT,
    @HeadMenu    bit OUTPUT,
	@Title nvarchar (256) OUTPUT,
	@Description nvarchar (256) OUTPUT,
	@Keywords nvarchar (256) OUTPUT,
	@HasAction bit=0 OUTPUT,
	@Redirect bit OUTPUT,
	@RedirectUrl nvarchar (256) OUTPUT,
	@Url nvarchar (256) OUTPUT,
	@CargoLimit decimal(18,2) OUTPUT,
	@Template  nvarchar(50)='default' OUTPUT ,
@BannerPath		nvarchar(50)='' OUTPUT, 
@BannerWidth	 nvarchar(10)='0' OUTPUT ,
@BannerHeight	  nvarchar(10)='0' OUTPUT ,
@LogoPath		 nvarchar(50)='' OUTPUT ,
@LogoWidth		nvarchar(10)='0' OUTPUT,  
@LogoHeight		 nvarchar(10)='0' OUTPUT ,
@LocalIp		nvarchar(15)='' OUTPUT,
@UserName		 nvarchar(20)='sa' OUTPUT,
@Password		 nvarchar(20)='' OUTPUT,
@LocalDatabase nvarchar(20)='VEGADB' OUTPUT,
@ItegrationType nvarchar(20)='VEGA' OUTPUT,
@Firma nvarchar(20)='100' OUTPUT,
@Donem nvarchar(20)='1' OUTPUT,
@CouponIsActive bit=0 OUTPUT,
@CouponDiscount decimal(18,2)=0 OUTPUT,
@CouponLimit decimal(18,2)=0 OUTPUT,
@CouponStartDate smalldatetime output,
@CouponEndDate smalldatetime output,

@PointsIsActive		bit OUTPUT,
@PointsValue		decimal(18,2) OUTPUT,
@PointsMoneyValue  decimal(18,6) OUTPUT,
@PointsMoneyLimit  decimal(18,2) OUTPUT,
@PointsReviewValue decimal(18,2) OUTPUT,
@PointsAdviceValue decimal(18,2) OUTPUT,
@SmsUserName varchar(20) OUTPUT,
@SmsPwd  varchar(20) OUTPUT,
@SmsCompany varchar(10) OUTPUT,
@SmsAdmin varchar(11) OUTPUT,
@SmsSendToAdmin bit=0 OUTPUT,
@SmsSendToUser bit=0 OUTPUT,
@SmsSendForPassword bit=0 OUTPUT,
@SmsSendNewUser bit=0 OUTPUT,
@CloseDate smalldatetime OUTPUT
)
AS

/* First, get Out Params */
IF @TabId = 0 
    SELECT TOP 1
       
        @PortalName    = Portals.PortalName,
        @Template =Portals.Template,
@BannerPath	=Portals.BannerPath	,		
@BannerWidth=Portals.BannerWidth,		
@BannerHeight=Portals.BannerHeight,
@LogoPath=Portals.LogoPath		,
@LogoWidth=Portals.LogoWidth	,	
@LogoHeight	=Portals.LogoHeight	,	
@LocalIp=Portals.LocalIp		,
@UserName=Portals.UserName		,
@Password=Portals.Password		,
@LocalDatabase=Portals.LocalDatabase,        
@Email=Portals.Email,
@IsEmarket=Portals.IsEmarket,
    @ShowMenu=    Portals.ShowMenu,
    @ShowFotterMenu=Portals.ShowFotterMenu,
    @HeadMenu=    Portals.HeadMenu,
        @AlwaysShowEditButton = Portals.AlwaysShowEditButton,
        @TabId         = Tabs.TabId,
        @TabOrder      = Tabs.TabOrder,
        @ParentId      = isnull(Tabs.ParentId,-1), --JH
        @IconURL      = isnull(Tabs.IconURL,''), --JH
        @TabName       = Tabs.TabName,
        @MobileTabName = Tabs.MobileTabName,
        @AuthRoles     = Tabs.AuthorizedRoles,
        @ShowMobile    = Tabs.ShowMobile,
        @Title	= Tabs.Title,
        @Description = Tabs.Description,
        @Keywords = Tabs.Keywords,
@HasAction=HasAction,
@Redirect=Redirect,
@RedirectUrl=RedirectUrl,
@Url=Url,
@CargoLimit=Portals.CargoLimit,
@ItegrationType =Portals.ItegrationType,
@Firma = Portals.Firma,
@Donem =Portals.Donem,
@CouponIsActive=isnull(Portals.CouponIsActive,0),
@CouponDiscount=isnull(Portals.CouponDiscount,0),
@CouponLimit=isnull(Portals.CouponLimit,0),
@CouponStartDate= CouponStartDate,
@CouponEndDate =CouponEndDate,
@PointsIsActive	=isnull(PointsIsActive,0),
@PointsValue=isnull(PointsValue,0),		
@PointsMoneyValue =isnull(PointsMoneyValue,0),
@PointsMoneyLimit =isnull(PointsMoneyLimit,0),
@PointsReviewValue=isnull(PointsReviewValue,0),
@PointsAdviceValue=isnull(PointsAdviceValue,0),
@SmsUserName=Portals.SmsUserName,
@SmsPwd=Portals.SmsPwd,
@SmsCompany =Portals.SmsCompany,
@SmsAdmin =Portals.SmsAdmin,
@SmsSendToAdmin = Portals.SmsSendToAdmin ,
@SmsSendToUser = Portals.SmsSendToUser,
@SmsSendForPassword = Portals.SmsSendForPassword,
@SmsSendNewUser=Portals.SmsSendNewUser,
@CloseDate=Portals.CloseDate
--,@FotterHtml=Portals.FotterHtml,
--@BannerHtml=Portals.BannerHtml

    FROM
        Tabs
    INNER JOIN
        Portals ON Tabs.PortalId = Portals.PortalId
        
    WHERE
        Portals.PortalId=@PortalId
        
    ORDER BY
        TabOrder

ELSE 
    SELECT
       
        @PortalName    = Portals.PortalName,
           @Template =Portals.Template,
           @BannerPath	=Portals.BannerPath	,		
@BannerWidth=Portals.BannerWidth,		
@BannerHeight=Portals.BannerHeight,
@LogoPath=Portals.LogoPath		,
@LogoWidth=Portals.LogoWidth	,	
@LogoHeight	=Portals.LogoHeight	,	
@LocalIp=Portals.LocalIp		,
@UserName=Portals.UserName		,
@Password=Portals.Password		,
@LocalDatabase=Portals.LocalDatabase,      
@Email=Portals.Email,
        @IsEmarket=Portals.IsEmarket,
    @ShowMenu=    Portals.ShowMenu,
    @ShowFotterMenu=Portals.ShowFotterMenu,
    @HeadMenu=    Portals.HeadMenu,
    @AlwaysShowEditButton = Portals.AlwaysShowEditButton,
        @TabName       = Tabs.TabName,
        @TabOrder      = Tabs.TabOrder,
        @ParentId      = isnull(Tabs.ParentId,-1), --JH
        @IconURL      = isnull(Tabs.IconURL,''), --JH
        @MobileTabName = Tabs.MobileTabName,
        @AuthRoles     = Tabs.AuthorizedRoles,
        @ShowMobile    = Tabs.ShowMobile,
        @Title	= Tabs.Title,
        @Description = Tabs.Description,
        @Keywords = Tabs.Keywords,
@HasAction=HasAction,
@Redirect=Redirect,
@RedirectUrl=RedirectUrl,
@Url=Url,
@CargoLimit=Portals.CargoLimit,
@ItegrationType =Portals.ItegrationType,
@Firma = Portals.Firma,
@Donem =Portals.Donem,
@CouponIsActive=isnull(Portals.CouponIsActive,0),
@CouponDiscount=isnull(Portals.CouponDiscount,0),
@CouponLimit=isnull(Portals.CouponLimit,0),
@CouponStartDate= CouponStartDate,
@CouponEndDate =CouponEndDate,
@PointsIsActive	=isnull(PointsIsActive,0),
@PointsValue=isnull(PointsValue,0),		
@PointsMoneyValue =isnull(PointsMoneyValue,0),
@PointsMoneyLimit =isnull(PointsMoneyLimit,0),
@PointsReviewValue=isnull(PointsReviewValue,0),
@PointsAdviceValue=isnull(PointsAdviceValue,0),
@SmsUserName=Portals.SmsUserName,
@SmsPwd=Portals.SmsPwd,
@SmsCompany =Portals.SmsCompany,
@SmsAdmin =Portals.SmsAdmin,
@SmsSendToAdmin = Portals.SmsSendToAdmin ,
@SmsSendToUser = Portals.SmsSendToUser,
@SmsSendForPassword = Portals.SmsSendForPassword,
@SmsSendNewUser=Portals.SmsSendNewUser,
@CloseDate=Portals.CloseDate
--,@FotterHtml=Portals.FotterHtml,
--@BannerHtml=Portals.BannerHtml
    FROM
        Tabs
    INNER JOIN
        Portals ON Tabs.PortalId = Portals.PortalId
        
    WHERE
        TabId=@TabId

/* Get Tabs list */
SELECT  
    TabName,
    AuthorizedRoles,
    TabId,
    isnull(ParentId, -1) ParentId, --JH
    isnull(IconURL, '') IconURL, --JH
    TabOrder,
HasAction,
Redirect,
RedirectUrl,
Url,
ChildCount
    
FROM    
    Tabs
    
WHERE   
    PortalId = @PortalId
    
ORDER BY
    TabOrder

/* html */
/* First, get Out Params */

    SELECT TOP 1
        FotterHtml,BannerHtml

    FROM
        Portals 
        
    WHERE
        PortalId=@PortalId
         

/* Get Mobile Tabs list */
SELECT  
    MobileTabName,
    AuthorizedRoles,
    TabId,
    isnull(ParentId, -1) ParentId, --JH
    isnull(IconURL, '') IconURL, --JH
    ShowMobile,
    HasAction
FROM    
    Tabs
    
WHERE   
    PortalId = @PortalId
  AND
    ShowMobile = 1
    
ORDER BY
    TabOrder

/* Then, get the DataTable of module info */
SELECT  
    *
    
FROM
    Modules
  INNER JOIN
    ModuleDefinitions ON Modules.ModuleDefId = ModuleDefinitions.ModuleDefId
    
WHERE   
    TabId = @TabId
    
ORDER BY
    ModuleOrder
GO