var DataNav=StructNew(); DataNav.navRoutes=navRoutes(); DataNav.navRouteConditions=navRouteConditions(); DataNav.navRoutesByLevel=navRoutesByLevel(); return DataNav; var sGetNav=StructNew(); sGetNav=Instance.DataNav; return sGetNav; //scope vars var i=0; var qLvl=0; var LvlArray=[]; var Lvl1Array=ArrayNew(1); var Lvl2Array=ArrayNew(1); var Lvl3Array=ArrayNew(1); var Lvl4Array=ArrayNew(1); var Lvl1Struct=StructNew(); var Lvl2Struct=StructNew(); var Lvl3Struct=StructNew(); var Lvl4Struct=StructNew(); //scope base query var qNavRoutesByLevel=queryNew("LevelID,NavID,NavParentID,NavOrder","integer,varchar,varchar,varchar"); var qNavRoutesByLevelOut=[]; //get current permissions var qPermissions=Instance.Permissions.qUserLevels(HasMenu=1); /* Each level that has a menu flag set in the user levels permissions query should have a corresponding scoped array and base structure that it will use to setup the specific menu items and order. outlined below is an example navRoutesByLevel template: Lvl1Struct=StructNew(); -> base struct Lvl1Struct.NavID=55; -> route id from navroutes Lvl1Struct.NavParentID=53; -> 0 or navroute id of the parent id it is associated to Lvl1Struct.NavOrder=2; -> order of menu item, order is reflected in the parents and children items ArrayAppend(Lvl1Array,Lvl1Struct); */ //Administrator -------------------------------------------------------------------------------------------------------------- Lvl1Array=ArrayNew(1); Lvl1Struct=StructNew(); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=2; Lvl1Struct.NavParentID=0; Lvl1Struct.NavOrder=1; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=16; Lvl1Struct.NavParentID=2; Lvl1Struct.NavOrder=1; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=17; Lvl1Struct.NavParentID=2; Lvl1Struct.NavOrder=2; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=18; Lvl1Struct.NavParentID=2; Lvl1Struct.NavOrder=3; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=19; Lvl1Struct.NavParentID=0; Lvl1Struct.NavOrder=2; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=20; Lvl1Struct.NavParentID=19; Lvl1Struct.NavOrder=1; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=21; Lvl1Struct.NavParentID=19; Lvl1Struct.NavOrder=2; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=22; Lvl1Struct.NavParentID=0; Lvl1Struct.NavOrder=3; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=23; Lvl1Struct.NavParentID=22; Lvl1Struct.NavOrder=1; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=24; Lvl1Struct.NavParentID=22; Lvl1Struct.NavOrder=2; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=25; Lvl1Struct.NavParentID=22; Lvl1Struct.NavOrder=3; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=26; Lvl1Struct.NavParentID=22; Lvl1Struct.NavOrder=4; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=27; Lvl1Struct.NavParentID=22; Lvl1Struct.NavOrder=5; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=28; Lvl1Struct.NavParentID=22; Lvl1Struct.NavOrder=6; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=29; Lvl1Struct.NavParentID=22; Lvl1Struct.NavOrder=7; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=30; Lvl1Struct.NavParentID=0; Lvl1Struct.NavOrder=4; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=31; Lvl1Struct.NavParentID=0; Lvl1Struct.NavOrder=5; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=35; Lvl1Struct.NavParentID=31; Lvl1Struct.NavOrder=1; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=32; Lvl1Struct.NavParentID=0; Lvl1Struct.NavOrder=6; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=33; Lvl1Struct.NavParentID=0; Lvl1Struct.NavOrder=7; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=34; Lvl1Struct.NavParentID=0; Lvl1Struct.NavOrder=8; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=36; Lvl1Struct.NavParentID=0; Lvl1Struct.NavOrder=9; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=37; Lvl1Struct.NavParentID=36; Lvl1Struct.NavOrder=1; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=38; Lvl1Struct.NavParentID=36; Lvl1Struct.NavOrder=2; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=39; Lvl1Struct.NavParentID=36; Lvl1Struct.NavOrder=3; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=40; Lvl1Struct.NavParentID=36; Lvl1Struct.NavOrder=4; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=41; Lvl1Struct.NavParentID=36; Lvl1Struct.NavOrder=5; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=42; Lvl1Struct.NavParentID=36; Lvl1Struct.NavOrder=6; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=43; Lvl1Struct.NavParentID=36; Lvl1Struct.NavOrder=7; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=44; Lvl1Struct.NavParentID=36; Lvl1Struct.NavOrder=8; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=45; Lvl1Struct.NavParentID=0; Lvl1Struct.NavOrder=10; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=46; Lvl1Struct.NavParentID=45; Lvl1Struct.NavOrder=1; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=47; Lvl1Struct.NavParentID=45; Lvl1Struct.NavOrder=2; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=48; Lvl1Struct.NavParentID=45; Lvl1Struct.NavOrder=3; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=50; Lvl1Struct.NavParentID=45; Lvl1Struct.NavOrder=4; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=51; Lvl1Struct.NavParentID=45; Lvl1Struct.NavOrder=5; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=52; Lvl1Struct.NavParentID=45; Lvl1Struct.NavOrder=6; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=53; Lvl1Struct.NavParentID=0; Lvl1Struct.NavOrder=11; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=54; Lvl1Struct.NavParentID=53; Lvl1Struct.NavOrder=1; ArrayAppend(Lvl1Array,Lvl1Struct); //--------------------------------------- Lvl1Struct=StructNew(); Lvl1Struct.NavID=55; Lvl1Struct.NavParentID=53; Lvl1Struct.NavOrder=2; ArrayAppend(Lvl1Array,Lvl1Struct); //Mall ----------------------------------------------------------------------------------------------------------------------- Lvl2Array=ArrayNew(1); Lvl2Struct=StructNew(); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=2; Lvl2Struct.NavParentID=0; Lvl2Struct.NavOrder=1; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=16; Lvl2Struct.NavParentID=2; Lvl2Struct.NavOrder=1; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=17; Lvl2Struct.NavParentID=2; Lvl2Struct.NavOrder=2; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=18; Lvl2Struct.NavParentID=2; Lvl2Struct.NavOrder=3; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=22; Lvl2Struct.NavParentID=0; Lvl2Struct.NavOrder=2; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=23; Lvl2Struct.NavParentID=22; Lvl2Struct.NavOrder=1; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=24; Lvl2Struct.NavParentID=22; Lvl2Struct.NavOrder=2; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=25; Lvl2Struct.NavParentID=22; Lvl2Struct.NavOrder=3; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=26; Lvl2Struct.NavParentID=22; Lvl2Struct.NavOrder=4; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=27; Lvl2Struct.NavParentID=22; Lvl2Struct.NavOrder=5; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=28; Lvl2Struct.NavParentID=22; Lvl2Struct.NavOrder=6; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=29; Lvl2Struct.NavParentID=22; Lvl2Struct.NavOrder=7; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=30; Lvl2Struct.NavParentID=0; Lvl2Struct.NavOrder=3; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=31; Lvl2Struct.NavParentID=0; Lvl2Struct.NavOrder=4; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=32; Lvl2Struct.NavParentID=0; Lvl2Struct.NavOrder=5; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=33; Lvl2Struct.NavParentID=0; Lvl2Struct.NavOrder=6; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=34; Lvl2Struct.NavParentID=0; Lvl2Struct.NavOrder=7; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=36; Lvl2Struct.NavParentID=0; Lvl2Struct.NavOrder=8; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=37; Lvl2Struct.NavParentID=36; Lvl2Struct.NavOrder=1; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=38; Lvl2Struct.NavParentID=36; Lvl2Struct.NavOrder=2; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=39; Lvl2Struct.NavParentID=36; Lvl2Struct.NavOrder=3; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=40; Lvl2Struct.NavParentID=36; Lvl2Struct.NavOrder=4; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=41; Lvl2Struct.NavParentID=36; Lvl2Struct.NavOrder=5; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=42; Lvl2Struct.NavParentID=36; Lvl2Struct.NavOrder=6; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=43; Lvl2Struct.NavParentID=36; Lvl2Struct.NavOrder=7; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=44; Lvl2Struct.NavParentID=36; Lvl2Struct.NavOrder=8; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=45; Lvl2Struct.NavParentID=0; Lvl2Struct.NavOrder=9; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=47; Lvl2Struct.NavParentID=45; Lvl2Struct.NavOrder=1; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=48; Lvl2Struct.NavParentID=45; Lvl2Struct.NavOrder=2; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=50; Lvl2Struct.NavParentID=45; Lvl2Struct.NavOrder=3; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=51; Lvl2Struct.NavParentID=45; Lvl2Struct.NavOrder=4; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=52; Lvl2Struct.NavParentID=45; Lvl2Struct.NavOrder=5; ArrayAppend(Lvl2Array,Lvl2Struct); //--------------------------------------- Lvl2Struct=StructNew(); Lvl2Struct.NavID=53; Lvl2Struct.NavParentID=0; Lvl2Struct.NavOrder=10; ArrayAppend(Lvl2Array,Lvl2Struct); //Store ---------------------------------------------------------------------------------------------------------------------- Lvl3Struct=StructNew(); Lvl3Struct.NavID=3; Lvl3Struct.NavParentID=0; Lvl3Struct.NavOrder=1; ArrayAppend(Lvl3Array,Lvl3Struct); //--------------------------------------- Lvl3Struct=StructNew(); Lvl3Struct.NavID=5; Lvl3Struct.NavParentID=0; Lvl3Struct.NavOrder=2; ArrayAppend(Lvl3Array,Lvl3Struct); //--------------------------------------- Lvl3Struct=StructNew(); Lvl3Struct.NavID=4; Lvl3Struct.NavParentID=0; Lvl3Struct.NavOrder=3; ArrayAppend(Lvl3Array,Lvl3Struct); //--------------------------------------- Lvl3Struct=StructNew(); Lvl3Struct.NavID=6; Lvl3Struct.NavParentID=0; Lvl3Struct.NavOrder=4; ArrayAppend(Lvl3Array,Lvl3Struct); //--------------------------------------- Lvl3Struct=StructNew(); Lvl3Struct.NavID=8; Lvl3Struct.NavParentID=0; Lvl3Struct.NavOrder=5; ArrayAppend(Lvl3Array,Lvl3Struct); //--------------------------------------- Lvl3Struct=StructNew(); Lvl3Struct.NavID=7; Lvl3Struct.NavParentID=0; Lvl3Struct.NavOrder=6; ArrayAppend(Lvl3Array,Lvl3Struct); //--------------------------------------- Lvl3Struct=StructNew(); Lvl3Struct.NavID=9; Lvl3Struct.NavParentID=0; Lvl3Struct.NavOrder=7; ArrayAppend(Lvl3Array,Lvl3Struct); //--------------------------------------- Lvl3Struct=StructNew(); Lvl3Struct.NavID=11; Lvl3Struct.NavParentID=0; Lvl3Struct.NavOrder=8; ArrayAppend(Lvl3Array,Lvl3Struct); //--------------------------------------- Lvl3Struct=StructNew(); Lvl3Struct.NavID=10; Lvl3Struct.NavParentID=0; Lvl3Struct.NavOrder=9; ArrayAppend(Lvl3Array,Lvl3Struct); //Instance ------------------------------------------------------------------------------------------------------------------- Lvl4Struct=StructNew(); Lvl4Struct.NavID=3; Lvl4Struct.NavParentID=0; Lvl4Struct.NavOrder=1; ArrayAppend(Lvl4Array,Lvl4Struct); //--------------------------------------- Lvl4Struct=StructNew(); Lvl4Struct.NavID=4; Lvl4Struct.NavParentID=0; Lvl4Struct.NavOrder=2; ArrayAppend(Lvl4Array,Lvl4Struct); //--------------------------------------- Lvl4Struct=StructNew(); Lvl4Struct.NavID=6; Lvl4Struct.NavParentID=0; Lvl4Struct.NavOrder=3; ArrayAppend(Lvl4Array,Lvl4Struct); //--------------------------------------- Lvl4Struct=StructNew(); Lvl4Struct.NavID=7; Lvl4Struct.NavParentID=0; Lvl4Struct.NavOrder=4; ArrayAppend(Lvl4Array,Lvl4Struct); //--------------------------------------- Lvl4Struct=StructNew(); Lvl4Struct.NavID=9; Lvl4Struct.NavParentID=0; Lvl4Struct.NavOrder=5; ArrayAppend(Lvl4Array,Lvl4Struct); //--------------------------------------- Lvl4Struct=StructNew(); Lvl4Struct.NavID=10; Lvl4Struct.NavParentID=0; Lvl4Struct.NavOrder=6; ArrayAppend(Lvl4Array,Lvl4Struct); //--------------------------------------- Lvl4Struct=StructNew(); Lvl4Struct.NavID=12; Lvl4Struct.NavParentID=0; Lvl4Struct.NavOrder=7; ArrayAppend(Lvl4Array,Lvl4Struct); //--------------------------------------- Lvl4Struct=StructNew(); Lvl4Struct.NavID=11; Lvl4Struct.NavParentID=0; Lvl4Struct.NavOrder=8; ArrayAppend(Lvl4Array,Lvl4Struct); //---------------------------------------------------------------------------------------------------------------------------- for(qLvl=1;qLvl<=qPermissions.recordCount;qLvl++){ LvlArray="Lvl" & qPermissions["LevelID"][qLvl] & "Array"; if(isdefined("#LvlArray#")){ for(i=1;i<=ArrayLen(Evaluate(LvlArray));i++){ QueryAddRow(qNavRoutesByLevel,1); QuerySetCell(qNavRoutesByLevel,"LevelID",qPermissions["LevelID"][qLvl]); QuerySetCell(qNavRoutesByLevel,"NavID",Evaluate("#LvlArray#[i].NavID")); QuerySetCell(qNavRoutesByLevel,"NavParentID",Evaluate("#LvlArray#[i].NavParentID")); QuerySetCell(qNavRoutesByLevel,"NavOrder",Evaluate("#LvlArray#[i].NavOrder")); } } } select LevelID,NavID,NavParentID,NavOrder from qNavRoutesByLevel order by LevelID Asc, NavOrder Asc return qNavRoutesByLevelOut; var NavArray=ArrayNew(1); var qRoutes=queryNew("ID,Route,Version,LinkTarget,LinkTitle,TextDesc","integer,varchar,varchar,varchar,varchar,varchar"); var i=0; /* NavData.ID=used for permissions, simluates an autopopulated db column NavData.Route=traditional link for legacy or coldbox event NavData.Version=this can be CB for coldbox edition, L for legacy, X for External Link NavData.LinkTarget=relates to anchor target value NavData.LinkTitle=anchor tag title NavData.TextDesc=text description All Legacy URLS Will have the current mallid and storeid sent with the url if populated in mymall/mystore //----------------------------------------------------------------------------------------------------- Template: NavData=StructNew(); NavData.ID=; NavData.Route=""; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle=""; NavData.TextDesc=""; ArrayAppend(NavArray,NavData); */ NavData=StructNew(); NavData.ID=1; NavData.Route="User.Home.dspHome"; NavData.Version="CB"; NavData.LinkTarget="_self"; NavData.LinkTitle="Home"; NavData.TextDesc="Home"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=2; NavData.Route="/admin2/mall/mallinfo.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Mall Info"; NavData.TextDesc="Mall Info"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=3; NavData.Route="/admin2/start.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Home"; NavData.TextDesc="Home"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=4; NavData.Route="/store/editStoreContact.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Contact Information"; NavData.TextDesc="Contact Information"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=5; NavData.Route="/store/modStore.cfm?mode=manage"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Manage Locations"; NavData.TextDesc="Manage Locations"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=6; NavData.Route="/store/editStore1.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Web Site Information"; NavData.TextDesc="Web Site Information"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=7; NavData.Route="/admin2/store/modStore.cfm?mode=sales"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Sales and Events"; NavData.TextDesc="Sales and Events"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=8; NavData.Route="/Gift/GiftSheet.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Merchandise Information"; NavData.TextDesc="Merchandise Information"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=9; NavData.Route="/Fusebox/index.cfm?fuseaction=Jobs.Home"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Job Listings"; NavData.TextDesc="Job Listings"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=10; NavData.Route="/workflow/workflow_feedback.cfm?Msg=StoreLogo&SetHeader=StoreLogo"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Store Logo"; NavData.TextDesc="Store Logo"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=11; NavData.Route="/store/brandkey.cfm?Type=Keywords"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Keywords"; NavData.TextDesc="Keywords"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=12; NavData.Route="/workflow/workflow_feedback.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Contact Us"; NavData.TextDesc="Contact Us"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=16; NavData.Route="/admin2/mallTextFiles.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Modify Info Pages"; NavData.TextDesc="Modify Info Pages"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=17; NavData.Route="/sidefeature"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Side Features"; NavData.TextDesc="Side Features"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=18; NavData.Route="/admin2/misc/lakeElsinore/homepage.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Edit Homepage"; NavData.TextDesc="Edit Homepage"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=19; NavData.Route="SMS.SMSBroadCast.demoSMSbroadcast"; NavData.Version="CB"; NavData.LinkTarget="_self"; NavData.LinkTitle="Send sms text messages to your groups"; NavData.TextDesc="SMS"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=20; NavData.Route="/sms/instantWinCampaignRequest.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Campaign"; NavData.TextDesc="Campaign"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=21; NavData.Route="/sms/broadcastForm.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Broadcast"; NavData.TextDesc="Broadcast"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=22; NavData.Route="/events/index.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Events"; NavData.TextDesc="Events"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=23; NavData.Route="/admin2/bDayClub/index.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Birthday Club"; NavData.TextDesc="Birthday Club"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=24; NavData.Route="/admin2/misc/12days.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="12 Days Points"; NavData.TextDesc="12 Days Points"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=25; NavData.Route="/admin2/darkSite/dsForm.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Emergency Info"; NavData.TextDesc="Emergency Info"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=26; NavData.Route="/admin2/mnog/mnog.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="MNOG"; NavData.TextDesc="MNOG"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=27; NavData.Route="/admin2/mnog/eforl.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Earning for Learning"; NavData.TextDesc="Earning for Learning"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=28; NavData.Route="/admin2/partners/partners.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Partners"; NavData.TextDesc="Partners"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=29; NavData.Route="/admin2/events/raceForReceipts.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Race for Receipts"; NavData.TextDesc="Race for Receipts"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=30; NavData.Route="/admin2/mall/MallHours.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Hours"; NavData.TextDesc="Hours"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=31; NavData.Route="/admin2/mall/dir/"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Directory"; NavData.TextDesc="Directory"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=32; NavData.Route="https://www.google.com/accounts/login"; NavData.Version="X"; NavData.LinkTarget="_self"; NavData.LinkTitle="Google Analytics"; NavData.TextDesc="Google Analytics"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=33; NavData.Route="/admin2/mall/fpurl/poolb.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="I-Features"; NavData.TextDesc="I-Features"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=34; NavData.Route="/admin2/Mall/FPURL/PressReleaseUrban.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Press Releases"; NavData.TextDesc="Press Releases"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=35; NavData.Route="Mall.Directory.dspAdd"; NavData.Version="CB"; NavData.LinkTarget="_self"; NavData.LinkTitle="Add New"; NavData.TextDesc="Add New"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=36; NavData.Route="/admin2/store/retailerNav.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Retail"; NavData.TextDesc="Retail"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=37; NavData.Route="/admin2/coupons/coupondirect.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Coupons"; NavData.TextDesc="Coupons"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=38; NavData.Route="/storeOffers/"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="License To Shop"; NavData.TextDesc="License To Shop"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=39; NavData.Route="/admin2/Jobs-old/old/jobAdmin.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Jobs"; NavData.TextDesc="Jobs"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=40; NavData.Route="/admin2/store/modStore.cfm?mode=sales"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Sales and Events"; NavData.TextDesc="Sales and Events"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=41; NavData.Route="/admin2/MDB/"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="MDB Data"; NavData.TextDesc="MDB Data"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=42; NavData.Route="http://mdb2.mallfinder.com/retail%20hub/"; NavData.Version="X"; NavData.LinkTarget="_self"; NavData.LinkTitle="MDB Application"; NavData.TextDesc="MDB Application"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=43; NavData.Route="/admin2/MDB/Reports/index.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Swipe Reports"; NavData.TextDesc="Swipe Reports"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=44; NavData.Route="/admin2/mallSlideShows.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Slide Shows"; NavData.TextDesc="Slide Shows"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=45; NavData.Route="/email/epostCard.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Email"; NavData.TextDesc="Email"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=46; NavData.Route="/email/admEmail.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="AdmEmail"; NavData.TextDesc="AdmEmail"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=47; NavData.Route="/email/ddrEPostCard.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="DDR Email"; NavData.TextDesc="DDR Email"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=48; NavData.Route="/email/epnew.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="New Email"; NavData.TextDesc="New Email"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=50; NavData.Route="/email/emailReport.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Email Report"; NavData.TextDesc="Email Report"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=51; NavData.Route="/directMail/index.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Direct Mail"; NavData.TextDesc="Direct Mail"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=52; NavData.Route="/workflow/workflow_Entryform.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Change Orders"; NavData.TextDesc="Change Orders"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=53; NavData.Route="/contactus.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="Contacts"; NavData.TextDesc="Contacts"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=54; NavData.Route="http://vendor1.retailhub.com/index.cfm"; NavData.Version="X"; NavData.LinkTarget="_self"; NavData.LinkTitle="Ven"; NavData.TextDesc="Ven"; ArrayAppend(NavArray,NavData); //--------------------------------------- NavData=StructNew(); NavData.ID=55; NavData.Route="/SponsorShip/spEvents.cfm"; NavData.Version="L"; NavData.LinkTarget="_self"; NavData.LinkTitle="SponsorShip"; NavData.TextDesc="SponsorShip"; ArrayAppend(NavArray,NavData); //----------------------------------------------------------------------------------------------------- //----------------------------------------------------------------------------------------------------- for(i=1;i<=ArrayLen(NavArray);i++){ QueryAddRow(qRoutes,1); QuerySetCell(qRoutes,"ID",NavArray[i].ID); QuerySetCell(qRoutes,"Route",NavArray[i].Route); QuerySetCell(qRoutes,"Version",NavArray[i].Version); QuerySetCell(qRoutes,"LinkTarget",NavArray[i].LinkTarget); QuerySetCell(qRoutes,"LinkTitle",NavArray[i].LinkTitle); QuerySetCell(qRoutes,"TextDesc",NavArray[i].TextDesc); } return qRoutes; var NavOverridesPermArray=ArrayNew(1); var NavOverridesPermStruct=StructNew(); var qRouteConditions=queryNew("Type,ID,IDLevel,MenuID,Display","varchar,varchar,varchar,integer,varchar"); var qRouteConditionsOut=[]; var i=0; /* Types of Restrictions: MallId = MallID (should be numeric, the mallid) CompanyID = CompanyID (should be numeric, the mallid) qUsr = User Table Restrictions: Specific Column Flags tied to other systems, currently admin supports the "InfoEditor, rmdRights" Column. In this case the ID should equal the name of the Column in the DB to compare qMall = Mall Query Table Restrictions: Specific Column Flags tied to other sytems, currently "qBDayMall, q12DaysMall, qShowLFE" Display = if false do not show (exclusive), true (inclusive) only show for these flagged ids */ //TYPE = MallId //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=2; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=16; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=19; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=20; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=21; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=22; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="M"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=23; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=24; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=25; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=26; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=27; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=28; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=1074; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=17; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=789; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=18; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=717; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=26; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=717; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=27; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=717; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=28; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=717; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=29; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=719; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=29; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=941; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=43; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=862; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=44; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=801; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=51; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=77; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=52; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=45; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=46; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=47; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=48; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=51; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=51; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="MallId"; NavOverridesPermStruct.ID=213; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=52; NavOverridesPermStruct.Display=False; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //TYPE = CompanyID //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="CompanyID"; NavOverridesPermStruct.ID=56; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=26; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="CompanyID"; NavOverridesPermStruct.ID=56; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=27; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="CompanyID"; NavOverridesPermStruct.ID=56; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=28; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="CompanyID"; NavOverridesPermStruct.ID=56; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=38; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="CompanyID"; NavOverridesPermStruct.ID=119; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=47; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="CompanyID"; NavOverridesPermStruct.ID=119; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=48; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //TYPE = qUsr //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="qUsr"; NavOverridesPermStruct.ID="InfoEditor"; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=16; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="qUsr"; NavOverridesPermStruct.ID="rmdRights"; NavOverridesPermStruct.IDLevel=2; NavOverridesPermStruct.MenuID=41; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="qUsr"; NavOverridesPermStruct.ID="rmdRights"; NavOverridesPermStruct.IDLevel=2; NavOverridesPermStruct.MenuID=42; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="qUsr"; NavOverridesPermStruct.ID="rmdRights"; NavOverridesPermStruct.IDLevel=2; NavOverridesPermStruct.MenuID=43; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //TYPE = qMall //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="qMall"; NavOverridesPermStruct.ID="qBDayMall"; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=23; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="qMall"; NavOverridesPermStruct.ID="q12DaysMall"; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=24; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="qMall"; NavOverridesPermStruct.ID="qShowLFE"; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=27; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //--------------------------------------- NavOverridesPermStruct=StructNew(); NavOverridesPermStruct.Type="qMall"; NavOverridesPermStruct.ID="NoEmploymentSection"; NavOverridesPermStruct.IDLevel=0; NavOverridesPermStruct.MenuID=39; NavOverridesPermStruct.Display=True; ArrayAppend(NavOverridesPermArray,NavOverridesPermStruct); //----------------------------------------------------------------------------------------------------- for(i=1;i<=ArrayLen(NavOverridesPermArray);i++){ QueryAddRow(qRouteConditions,1); QuerySetCell(qRouteConditions,"Type",NavOverridesPermArray[i].Type); QuerySetCell(qRouteConditions,"ID",NavOverridesPermArray[i].ID); QuerySetCell(qRouteConditions,"IDLevel",NavOverridesPermArray[i].IDLevel); QuerySetCell(qRouteConditions,"MenuID",NavOverridesPermArray[i].MenuID); QuerySetCell(qRouteConditions,"Display",NavOverridesPermArray[i].Display); } select Type,ID,IDLevel,MenuID,Display from qRouteConditions order by Type Desc return qRouteConditionsOut;