installedApps = StructNew(); navigation = ArrayNew(1); // home navigationItem = StructNew(); navigationItem.name = "Home"; navigationItem.uri = "/welcome.cfm"; navigationItem.permissionRequired="STP"; navigationItem.menuSelectionCode="re:welcome.cfm"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); if(includeBrokerProfile EQ "yes") { navigationItem = StructNew(); navigationItem.name = "Broker Profile"; navigationItem.uri = "/apps/101/index.cfm"; navigationItem.permissionRequired="STP,AdminCenter"; navigationItem.menuSelectionCode="101"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); installedApps["101"] = true; } if(includeDocLibrary EQ "yes") { navigationItem = StructNew(); navigationItem.name = "Document Library"; navigationItem.uri = "/apps/CDA/index.cfm?set=DocumentLibrary"; navigationItem.permissionRequired="STP"; navigationItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=DocumentLibrary"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); installedApps["CDA"] = true; } if(includePOS EQ "yes") { navigationItem = StructNew(); navigationItem.name = "POS Ordering"; navigationItem.uri = "/apps/POS/index.cfm"; navigationItem.permissionRequired="POSOrdering"; navigationItem.menuSelectionCode="POS Ordering"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); installedApps["POS"] = true; } if(includeMKT EQ "yes") { navigationItem = StructNew(); navigationItem.name = "Market Manager"; navigationItem.uri = "/apps/MKT/index.cfm"; navigationItem.permissionRequired="MarketManagementApp"; navigationItem.menuSelectionCode="re:/apps/MKT/"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); installedApps["MKT"] = true; } if(includeImageLibrary EQ "yes") { navigationItem = StructNew(); navigationItem.name = "Images & Logos"; navigationItem.uri = "/apps/CDA/index.cfm?set=ImageLibrary"; navigationItem.permissionRequired="STP"; navigationItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=ImageLibrary"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); installedApps["CDA"] = true; } if(includeCompanyNews EQ "yes") { // company news navigationItem = StructNew(); navigationItem.name = "Company News"; navigationItem.uri = "/apps/CDA/index.cfm?set=CompanyNews"; navigationItem.permissionRequired="STP"; navigationItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=CompanyNews"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); installedApps["CDA"] = true; } if(includeCompanyCalendar EQ "yes") { // company calendar navigationItem = StructNew(); navigationItem.name = "Company Calendar"; navigationItem.uri = "/apps/CDA/index.cfm?set=CompanyCalendar"; navigationItem.permissionRequired="STP"; navigationItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=CompanyCalendar"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); installedApps["CDA"] = true; } if(includeMFRLogin EQ "yes") { // company calendar navigationItem = StructNew(); navigationItem.name = "MFR Logins"; navigationItem.uri = "/apps/CDA/index.cfm?set=MfrLogins"; navigationItem.permissionRequired="STP"; navigationItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=MfrLogins"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); installedApps["CDA"] = true; } if(includeFoodServiceCRM EQ "yes") { // food service crm if( portalOwnerType eq "MFR" ) { fsCRMPermissions = "MarketManagementApp,DistributorManagement,OperatorManagement"; } else if ( portalOwnerType eq "BRO" ){ fsCRMPermissions = "BCRMObjectiveManagement,BCRMMyObjectives,DistributorManagement,OperatorManagement"; } else { fsCRMPermissions = "DistributorManagement,OperatorManagement"; } navigationItem = StructNew(); navigationItem.name = "Food Service CRM"; navigationItem.uri = ""; navigationItem.permissionRequired = fsCRMPermissions; navigationItem.menuSelectionCode=""; navigationItem.subMenu = ArrayNew(1); if( portalOwnerType eq "MFR" ) { subItem = StructNew(); subItem.name = "Market Manager"; subItem.uri = "/apps/MKT/index.cfm"; subItem.permissionRequired="MarketManagementApp"; subItem.menuSelectionCode="re:/apps/MKT/"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["MKT"] = true; installedApps["SPL"] = true; } else { subItem = StructNew(); subItem.name = "Opportunity Pipeline"; subItem.uri = "/apps/SPL/index.cfm?view=list"; subItem.permissionRequired="SalesPipeline"; subItem.menuSelectionCode="re:/SPL/index.cfm"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["SPL"] = true; subItem = StructNew(); subItem.name = "Objective Planning"; subItem.uri = "/apps/BOM/index.cfm?view=list"; subItem.permissionRequired="BCRMObjectiveManagement"; subItem.menuSelectionCode="re:/BOM/index.cfm\?view=(list|detail)"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["BOM"] = true; subItem = StructNew(); subItem.name = "Objective Dashboard"; subItem.uri = "apps/BMYO/index.cfm?view=list "; subItem.permissionRequired="BCRMMyObjectives"; subItem.menuSelectionCode="re:/BMYO/index.cfm\?view=(list|detail)"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["BMYO"] = true; subItem = StructNew(); subItem.name = "Call Tracking"; subItem.uri = "/apps/BCM/index.cfm?view=list"; subItem.permissionRequired="BCRMCallTracking"; subItem.menuSelectionCode="re:/BCM/index.cfm\?view=(list|detail)"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["BCM"] = true; /* subItem.name = "Objective Follow Up"; subItem.uri = "/apps/BMYO/index.cfm?view=list"; subItem.permissionRequired="BCRMMyObjectives"; subItem.menuSelectionCode="re:/BMYO/index.cfm\?view=(list|detail)"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["BMYO"] = true; */ } subItem = StructNew(); subItem.name = "Distributor Portfolio"; subItem.uri = "/apps/102/index.cfm"; subItem.permissionRequired="DistributorManagement"; subItem.menuSelectionCode="Customer ManagementDistributors"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["102"] = true; subItem = StructNew(); subItem.name = "Operator Portfolio"; subItem.uri = "/apps/OPR/index.cfm"; subItem.permissionRequired="OperatorManagement"; subItem.menuSelectionCode="Operator ManagementOperator List"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["OPR"] = true; // Report Center subItem = StructNew(); subItem.name = "Report Center"; subItem.uri = "/apps/RPT/index.cfm"; subItem.permissionRequired="CRMReportCenter"; subItem.menuSelectionCode="re:/apps/RPT/"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["RPT"] = true; ArrayAppend( navigation, navigationItem ); } // product center /* navigationItem = StructNew(); navigationItem.name = "Product Center"; navigationItem.uri = ""; navigationItem.permissionRequired=""; navigationItem.menuSelectionCode=""; navigationItem.subMenu = ArrayNew(1); subItem = StructNew(); subItem.name = "Manufacturers"; subItem.uri = "/apps/CDA/index.cfm?set=Manufacturers"; subItem.permissionRequired="STP"; subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=Manufacturers"; ArrayAppend( navigationItem.subMenu, subItem ); */ /*navigationItem = StructNew(); navigationItem.name = "POS Ordering"; navigationItem.uri = "/apps/CDA/index.cfm?set=POS"; navigationItem.permissionRequired="POSOrdering"; navigationItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=POS"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); */ // subItem = StructNew(); // subItem.name = "POS Ordering"; // subItem.uri = "/apps/CDA/index.cfm?set=POS"; // subItem.permissionRequired="STP"; // subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=POS"; // ArrayAppend( navigationItem.subMenu, subItem ); // ArrayAppend( navigation, navigationItem ); // resources /* navigationItem = StructNew(); navigationItem.name = "Internal Resources"; navigationItem.uri = ""; navigationItem.permissionRequired=""; navigationItem.menuSelectionCode=""; navigationItem.subMenu = ArrayNew(1); */ // MFR Resource Center if(includeMfrResourceCenter EQ "yes") { navigationItem = StructNew(); navigationItem.name = "MFR Resource Center"; navigationItem.uri = ""; navigationItem.permissionRequired=""; navigationItem.menuSelectionCode=""; navigationItem.subMenu = ArrayNew(1); subItem = StructNew(); subItem.name = "Recipes"; subItem.uri = "/apps/CDA/index.cfm?set=Recipes"; subItem.permissionRequired="STP"; subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=Recipes"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["CDA"] = true; subItem = StructNew(); subItem.name = "POS"; subItem.uri = "/apps/CDA/index.cfm?set=POS"; subItem.permissionRequired="STP"; subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=POS"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["CDA"] = true; subItem = StructNew(); subItem.name = "Promotions"; subItem.uri = "/apps/CDA/index.cfm?set=Promos"; subItem.permissionRequired="STP"; subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=Promos"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["CDA"] = true; subItem = StructNew(); subItem.name = "Kosher Letters"; subItem.uri = "/apps/CDA/index.cfm?set=Kosher"; subItem.permissionRequired="STP"; subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=Kosher"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["CDA"] = true; ArrayAppend( navigation, navigationItem ); } if(includeShareGroup EQ "yes") { navigationItem = StructNew(); navigationItem.name = "FSI Share Group"; navigationItem.uri = ""; navigationItem.permissionRequired="ShareGrpHome"; navigationItem.menuSelectionCode=""; navigationItem.subMenu = ArrayNew(1); subItem = StructNew(); subItem.name = "Share Group Home"; subItem.uri = "/apps/CDA/index.cfm?set=ShareGroupHome"; subItem.permissionRequired="ShareGrpHome"; subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=ShareGroupHome"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["CDA"] = true; subItem = StructNew(); subItem.name = "Manufacturer Matrix"; subItem.uri = "/apps/SHR/index.cfm?view=shrmfrs"; subItem.permissionRequired="ShareGrpMfrMatrix"; subItem.menuSelectionCode="re:/SHR/index.cfm\?.*&?view=shrmfrs"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["SHR"] = true; subItem = StructNew(); subItem.name = "Member List Email"; subItem.uri = "/apps/SHR/index.cfm?view=shrmem"; subItem.permissionRequired="ShareGrpMemberList"; subItem.menuSelectionCode="re:/SHR/index.cfm\?.*&?view=shrmem"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["SHR"] = true; subItem = StructNew(); subItem.name = "Ask It Now"; subItem.uri = "/apps/SHR/index.cfm?view=shrask"; subItem.permissionRequired="ShareGrpAskIt"; subItem.menuSelectionCode="re:/SHR/index.cfm\?.*&?view=shrask"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["SHR"] = true; subItem = StructNew(); subItem.name = "Resources & Docs"; subItem.uri = "/apps/CDA/index.cfm?set=ShareGroupDocs"; subItem.permissionRequired="ShareGrpResources"; subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=ShareGroupDocs"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["CDA"] = true; ArrayAppend( navigation, navigationItem ); } if(includeSmartRewards EQ "yes") { navigationItem = StructNew(); navigationItem.name = "$MART Rewards Admin"; navigationItem.uri = ""; navigationItem.permissionRequired="SmartAdminHome"; navigationItem.menuSelectionCode=""; navigationItem.subMenu = ArrayNew(1); subItem = StructNew(); subItem.name = "Dashboard"; subItem.uri = "/apps/INC/index.cfm?view=dash"; subItem.permissionRequired="SmartAdminHome"; subItem.menuSelectionCode="re:/INC/index.cfm\?.*&?view=dash"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["INC"] = true; subItem = StructNew(); subItem.name = "Operator Enrollment"; subItem.uri = "/apps/INC/index.cfm?view=list"; subItem.permissionRequired="SmartAdminHome"; subItem.menuSelectionCode="re:/INC/index.cfm\?.*&?view=list"; installedApps["INC"] = true; ArrayAppend( navigationItem.subMenu, subItem ); subItem = StructNew(); subItem.name = "Program Management"; subItem.uri = "/apps/INC/index.cfm?view=prog"; subItem.permissionRequired="SmartAdminEligibleProducts"; subItem.menuSelectionCode="re:/INC/index.cfm\?.*&?view=prog"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["INC"] = true; ArrayAppend( navigation, navigationItem ); navigationItem = StructNew(); navigationItem.name = "Operator Rewards Site"; navigationItem.uri = "http://jgoodman.smartoperatorrewards.com/home.cfm"; navigationItem.permissionRequired="SmartOprRewardsSite"; navigationItem.menuSelectionCode=""; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); navigationItem = StructNew(); navigationItem.name = "Operator Site"; navigationItem.uri = "/apps/CDA/index.cfm?set=menufocus&loc=menufocus"; navigationItem.permissionRequired="MenuFocusVendorLink"; navigationItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?loc=menufocus"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); installedApps["CDA"] = true; /* subItem = StructNew(); subItem.name = "Program Admin"; subItem.uri = "/apps/CDA/index.cfm?set=SMARTadmin"; subItem.permissionRequired="STP"; subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=SMARTadmin"; ArrayAppend( navigationItem.subMenu, subItem ); */ /* subItem = StructNew(); subItem.name = "Rewards Admin Home"; subItem.uri = "/apps/CDA/index.cfm?set=SMARTadminHome"; subItem.permissionRequired="SmartAdminHome"; subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=SMARTadminHome"; ArrayAppend( navigationItem.subMenu, subItem ); */ /* subItem = StructNew(); subItem.name = "Manufacturer Admin"; subItem.uri = "/apps/CDA/index.cfm?set=SMARTadminManuf"; subItem.permissionRequired="SmartAdminManufacturers"; subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=SMARTadminManuf"; ArrayAppend( navigationItem.subMenu, subItem ); */ /*subItem = StructNew(); subItem.name = "Eligible Product Pgms"; subItem.uri = "/apps/CDA/index.cfm?set=SMARTadminProducts"; subItem.permissionRequired="SmartAdminEligibleProducts"; subItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?set=SMARTadminProducts"; ArrayAppend( navigationItem.subMenu, subItem ); */ /*subItem = StructNew(); subItem.name = "Operator Enrollment"; subItem.uri = "/apps/INC/index.cfm"; subItem.permissionRequired="SmartAdminOprEnroll"; subItem.menuSelectionCode="INC"; ArrayAppend( navigationItem.subMenu, subItem ); ArrayAppend( navigation, navigationItem );*/ /* navigationItem = StructNew(); navigationItem.name = "$MART Rewards"; navigationItem.uri = "http://preview.fsenablers.com/smartrewards/home.cfm"; navigationItem.permissionRequired="SmartOprRewardsSite"; navigationItem.menuSelectionCode=""; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); */ } /* navigationItem = StructNew(); navigationItem.name = "Menu Focus"; navigationItem.uri = "/apps/CDA/index.cfm?set=menufocus&loc=menufocus"; navigationItem.permissionRequired="MenuFocusVendorLink"; navigationItem.menuSelectionCode="re:/CDA/index.cfm\?.*&?loc=menufocus"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); */ // Training if(includeTraining EQ "yes") { navigationItem = StructNew(); navigationItem.name = "Training"; navigationItem.uri = ""; navigationItem.permissionRequired=""; navigationItem.menuSelectionCode=""; navigationItem.subMenu = ArrayNew(1); subItem = StructNew(); subItem.name = "Introduction"; subItem.uri = "/apps/TRN/index.cfm?view=introduction"; subItem.permissionRequired="TrainingCenter"; subItem.menuSelectionCode="Training CenterIntroduction"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["TRN"] = true; subItem = StructNew(); subItem.name = "Course List"; subItem.uri = "/apps/TRN/index.cfm?view=home"; subItem.permissionRequired="TrainingCenter"; subItem.menuSelectionCode="Training CenterCourse List"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["TRN"] = true; subItem = StructNew(); subItem.name = "Status Report"; subItem.uri = "/apps/TRN/index.cfm?view=status"; subItem.permissionRequired="TrainingAdmin"; subItem.menuSelectionCode="Training CenterStatus Report"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["TRN"] = true; ArrayAppend( navigation, navigationItem ); } if(includeContactUs EQ "yes") { navigationItem = StructNew(); navigationItem.name = "Contact Us"; navigationItem.uri = "/apps/ContactUs/index.cfm"; navigationItem.permissionRequired="STP"; navigationItem.menuSelectionCode="ContactUs"; navigationItem.subMenu = ArrayNew(1); ArrayAppend( navigation, navigationItem ); installedApps["ContactUs"] = true; } if(includeProductInfo EQ "yes") { navigationItem = StructNew(); navigationItem.name = "Product Info Center"; navigationItem.uri = ""; navigationItem.permissionRequired="STP,ProductResources"; navigationItem.menuSelectionCode=""; navigationItem.subMenu = ArrayNew(1); subItem = StructNew(); subItem.name = "Product Catalog"; subItem.uri = "/apps/103a/index.cfm"; subItem.permissionRequired="ProductResources"; subItem.menuSelectionCode="103a"; ArrayAppend( navigationItem.subMenu, subItem ); installedApps["103a"] = true; } // ArrayAppend( navigation, navigationItem ); // template /* navigationItem = StructNew(); navigationItem.name = ""; navigationItem.uri = ""; navigationItem.permissionRequired=""; navigationItem.menuSelectionCode=""; navigationItem.subMenu = ArrayNew(1); subItem = StructNew(); subItem.name = ""; subItem.uri = ""; subItem.permissionRequired=""; subItem.menuSelectionCode=""; ArrayAppend( navigationItem.subMenu, subItem ); ArrayAppend( navigation, navigationItem ); */ select websiteId from tbl_CUS_Websites where portal_name = and portal_ownerId = and portal_ownerType =

already exists

select customerId from tbl_CUS_Customers where fsl_tablecode = and fsl_companyid =

no customer id

select * from fslibrary..tbl_SEC_AttributeTypes where attrbtypecode = set nocount on insert into fslibrary..tbl_SEC_Attributes ( ownerId, fsl_tablecode, attrbcode, seqnum, attrbname, attrbtypeid ) values ( , , , , , ) select loginSecureAreaId = @@identity set nocount off StructInsert( permissions, permission, qmd_insPermission.loginSecureAreaId ); set nocount on insert into tbl_CUS_Websites ( customerId, name, ipaddress, auth_clntCd, auth_CustFldr, auth_appname, auth_loginSecureIds, auth_reminderSiteName, auth_reminderFromAddy, auth_LoginHelpAddy, portal_name, portal_type, portal_theme, portal_ownerId, portal_ownerType, portal_corpSiteURL_preview, portal_corpSiteURL_dev, portal_corpSiteURL, portal_datasource, portal_datasource_dev, portal_datasource_preview ) values ( , , , , , , , , , , , , , , , , , , , , ) select websiteId = @@identity set nocount off insert into tbl_CUS_Websitedomains ( websiteid, domainName ) values ( , ) set nocount on insert tbl_CUS_WebSiteSections ( websiteid, name, uri, requiredPermission, menuSelectionCode, displayRank ) values ( , , , , , ) select sectionId = @@identity set nocount off set nocount on insert tbl_CUS_WebSiteSections ( websiteid, name, uri, requiredPermission, menuSelectionCode, displayRank, parentSectionId ) values ( , , , , , , ) select subSectionId = @@identity set nocount off select * from fslibrary..tbl_SEC_attributes where ownerid = and fsl_tablecode= select * from tbl_CUS_websitesections where websiteid = order by displayRank select * from tbl_CUS_websites where websiteid = insert into tbl_APP_Configurations ( applicationCode, applicationInstance, ownerId, ownerType, parameterName, parameterType, parameterValue ) values ( , , , , , , )