ListSQL("SELECT sysSecurityGroup.SecurityGroupID,
sysSecurityGroup.strSecurityGroup as 'Security Group',
sysSecurityGroup.blnActive as 'Active',
sysSecurityGroup.strLastUser as 'Last User',
sysSecurityGroup.dtLastEdit as 'Last Edit'
FROM sysSecurityGroup
GROUP BY sysSecurityGroup.strSecurityGroup,sysSecurityGroup.blnActive,sysSecurityGroup.strLastUser,sysSecurityGroup.dtLastEdit
ORDER BY sysSecurityGroup.strSecurityGroup",0,"","Edit");
return $this->renderTable("User Group List");
}
public static function getSecurityEntities($SecurityGroupID)
{
global $xdb;
$sql = " SELECT
sysMenuLevel2.MenuLevel2ID,
sysMenuLevel1.strMenuLevel1,
sysMenuLevel2.strMenuLevel2,
sysMenuLevel2.strEntity,
sysMenuLevel2.strUrl,
sysMenuLevel2.strNotes,
sysMenuLevel2.intOrder,
sysMenuLevel2.blnMenuItem,
sysMenuLevel2.blnDivider
FROM (sysSecurity
RIGHT JOIN (sysMenuLevel2
LEFT JOIN sysMenuLevel1 ON sysMenuLevel2.MenuLevel1ID = sysMenuLevel1.MenuLevel1ID) ON sysSecurity.refMenulevel2ID = sysMenuLevel2.MenuLevel2ID)
GROUP BY sysMenuLevel2.strMenuLevel2
ORDER BY sysMenuLevel1.intOrder ASC , sysMenuLevel2.intOrder ASC , sysMenuLevel2.strMenuLevel2
";
$rst = $xdb->doQuery($sql);
while($row = $xdb->fetch($rst))
{
$sql = "SELECT blnView,blnDelete,blnSave,blnNew,blnSpecial
FROM sysSecurity WHERE
refSecurityGroupID = '$SecurityGroupID' AND
refMenulevel2ID = '$row->MenuLevel2ID' ";
$rstSecurity = $xdb->doQuery($sql);
$rowSecurity = $xdb->fetch($rstSecurity);
$strList .= "