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;