if (!isset($rfq2awardObj)) { include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php"; $rfq2awardObj = new Rfq2Award(); } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $sts = $statusmasterObj->getDetails(" DISTINCT iStatusID, vStatus_en, vStatus_fr, vStatus_" . LANG . " as vStatus ", " AND vForAuction LIKE '%RFQ2%'"); $smarty->assign("sts", $sts); // --- Statistics -------------------------------------------------------------------------------------------- $where = " iBuyerOrganizationID={$orgid} "; $assocstats = $orgObj->getOADashboardAssocStats(PRJ_DB_PREFIX . "_organization_association", $where); $where = " iOrganizationID={$orgid} "; $groupstats = $orgObj->getOADashboardGrpStats(PRJ_DB_PREFIX . "_organization_group", $where); $orguserstats = $orgUserObj->getOADashboardUsrStats(PRJ_DB_PREFIX . "_organization_user", $where . " AND eUserType='User' "); $orgadminstats = $orgUserObj->getOADashboardUsrStats(PRJ_DB_PREFIX . "_organization_user", $where . " AND eUserType='Admin' "); $where = " iUserID IN (Select iUserID from " . PRJ_DB_PREFIX . "_organization_user where {$where} AND eUserType='User' ) "; $userrightsstats = $orgUserObj->getOADashboardUsrStats(PRJ_DB_PREFIX . "_organization_user_permission", $where); // prints($userrightsstats); exit; $where = " AND iOrganizationID={$orgid}"; //$where = ""; //prints($assocstats); exit; $smarty->assign("assocstats", $assocstats); $smarty->assign("groupstats", $groupstats); $smarty->assign("orgadminstats", $orgadminstats); $smarty->assign("orguserstats", $orguserstats); $smarty->assign("userrightsstats", $userrightsstats); // ----------------------------------------------------------------------------------------------------------- // --- Last Logins ------------------------------------------------------------------------------------------- if (!isset($lghObj)) {
<?php include S_SECTIONS . "/member/memberaccess.php"; if (!isset($orgUserObj)) { include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php"; $orgUserObj = new OrganizationUser(); } $where = ''; // --- Statistics -------------------------------------------------------------------------------------------- $orgstats = $secManObj->getSMDashboardOrgStats(PRJ_DB_PREFIX . "_organization_master", $where); $assostats = $secManObj->getSMDashboardOrgStats(PRJ_DB_PREFIX . "_organization_association", $where); $orgadminstats = $secManObj->getSMDashboardUsrStats(PRJ_DB_PREFIX . "_organization_user", 'Admin'); $orguserstats = $secManObj->getSMDashboardUsrStats(PRJ_DB_PREFIX . "_organization_user", 'User'); $where_user = "******" . PRJ_DB_PREFIX . "_organization_user where eUserType='User' ) "; $userrightsstats = $orgUserObj->getOADashboardUsrStats(PRJ_DB_PREFIX . "_organization_user_permission", $where_user); $grpstats = $secManObj->getSMDashboardOrgStats(PRJ_DB_PREFIX . "_organization_group", $where); $smarty->assign("orgstats", $orgstats); $smarty->assign("grpstats", $grpstats); $smarty->assign("assostats", $assostats); $smarty->assign("orgadminstats", $orgadminstats); $smarty->assign("orguserstats", $orguserstats); $smarty->assign("userrightsstats", $userrightsstats); // ----------------------------------------------------------------------------------------------------------- // --- Last Logins ------------------------------------------------------------------------------------------- if (!isset($lghObj)) { require_once SITE_CLASS_APPLICATION . "class.LoginHistory.php"; $lghObj = new LoginHistory(); } $lastlogins = $lghObj->getDetails("*", " AND iAdminId={$sess_id} AND eType='SM' ", " dLoginDate DESC ", '', " LIMIT 0,3"); $lastLoginDate = $lastlogins[0]['dLoginDate']; $smarty->assign("lastlogins", $lastlogins);