$cursorttype = $_POST['cursorttype'];
if ($cursort != '') {
if ($cursorttype == '1') {
$cursort_type = 'ASC';
} else {
$cursort_type = 'DESC';
}
$orderBy = " {$cursort} {$cursort_type}";
} else {
$orderBy = " ou.dLastAccessDate DESC ";
}
## ENDS HERE ###
$limit = " LIMIT " . ($page - 1) * $REC_LIMIT_FRONT . ", " . $REC_LIMIT_FRONT . " ";
// echo $where; exit;
$jtbl = " INNER JOIN " . PRJ_DB_PREFIX . "_organization_user_permission up on ou.iUserID=up.iUserID\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_country_master cm on BINARY ou.vCountry=cm.vCountryCode\r\n \t\tLEFT JOIN " . PRJ_DB_PREFIX . "_organization_master org on org.iOrganizationID=ou.iOrganizationID";
$userlist = $orgUserObj->getJoinTableInfo($jtbl, "ou.iUserID,ou.vFirstName,ou.vLastName,ou.vEmail,ou.eUserType,ou.eStatus,cm.vCountry,org.vCompanyName as OrgName", $where, $orderBy, '', $limit, 'yes');
//$userlist = $orgUserObj->getDetails_PG('',$where,$orderBy,'',$limit);
//prints($userlist);exit;
$count = $userlist['tot'];
unset($userlist['tot']);
if (!isset($pgajxobj)) {
require_once SITE_CLASS_GEN . "class.paging-ajax.php";
$pgajxobj = new Paging($count, $page, "listusers", $REC_LIMIT_FRONT);
}
$paging = $pgajxobj->getListPG($page);
//print $paging;
$pgmsg = $pgajxobj->setMessage("Records");
//echo $paging; exit;
$smarty->assign('count', $count);
$smarty->assign('userlist', $userlist);
$smarty->assign('paging', $paging);
}
if (!isset($orgUserPermVerifyObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermissionToVerify.php";
$orgUserPermVerifyObj = new OrganizationUserPermissionToVerify();
}
$uprmts = array();
if ($iUserID != '') {
$view = 'verify';
$OuserData = $userData = $orgUserObj->select($iUserID);
if ($sess_usertype_short == 'OA' && $userData[0]['iOrganizationID'] != $curORGID) {
header("Location: " . SITE_URL_DUM . "organizationuserlist");
exit;
}
$fields = " *, grp.vGroupName ";
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_organization_group grp on ou.iGroupID=grp.iGroupID ";
$OuserData = $orgUserObj->getJoinTableInfo($jtbl, $fields, " AND ou.iUserID={$iUserID} ");
// $iUserID
$OuserData = $userData = $userData[0];
$uprmts = $orgUserPerObj->getDetails('*', " AND iUserID={$iUserID} ");
$vuprmts = $orgUserPermVerifyObj->getDetails('*', " AND iUserID={$iUserID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 ');
}
$state = $cntstObj->getgeneralArr(PRJ_DB_PREFIX . "_state_master", " AND eStatus='Active'", "vStateCode", "vState", "vCountryCode", "vStateCode,vState,vCountryCode");
$stateArr = $state[0];
//$stateArr = array($stateArr);
//echo $stateArr[0][2];
//prints($stateArr);exit;
$groupArr = $cntstObj->getgeneralArr(PRJ_DB_PREFIX . "_organization_group", " AND eStatus='Active' ", "iGroupID", "vGroupName", "iOrganizationID", "iGroupID,vGroupName,iOrganizationID");
$groupArr = $groupArr[0];
$db_country = $countryObj->getCountryDetail("iCountryId,vCountry,vCountryCode", "AND eStatus = 'Active'");
//prints($db_country);exit;
$db_state = $stateObj->getStateDetail("iStateId, vStateCode, vState", "AND eStatus = 'Active' AND vCountryCode = '" . $userData['vCountry'] . "'", "vState");
// AND eViewed=\'Yes\'
$orderBy = " ORDER BY iVerifiedID DESC";
$limit = ' LIMIT 0,5';
$sql_res = 'CALL GetInbox("SM"," ' . $where . '","","' . $orderBy . '","' . $limit . '")';
$res = $dbobj->Onlyquery($sql_res);
$smarty->assign("res", $res);
//Prints($res);exit;
// --- Users -----------------------------------------------------------------------------------------
$auth1sts = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Auth1' ");
$auth1sts = $auth1sts[0]['iStatusID'];
$auth2sts = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Auth2' ");
$auth2sts = $auth2sts[0]['iStatusID'];
$auth3sts = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Auth3' ");
$auth3sts = $auth3sts[0]['iStatusID'];
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_organization_user_permission per on ou.iUserID=per.iUserID\r\n\t\t\t\t LEFT JOIN " . PRJ_DB_PREFIX . "_country_master cm on ou.vCountry=cm.vCountryCode ";
$orgbyusrvrfy = $orgUserObj->getJoinTableInfo($jtbl, " ou.*, cm.vCountry as vCountryName ", " AND (per.tPermission LIKE '%po:%{$auth1sts}%' || per.tPermission LIKE '%po:%{$auth2sts}%' || per.tPermission LIKE '%po:%{$auth3sts}%') AND (ou.eStatus='Need to Verify' OR ou.eStatus='Modified' OR ou.eNeedToVerify='Yes') AND ou.iOrganizationID={$curORGID} ", " ou.iUserID DESC ", ' ou.iUserID ', " LIMIT 0,2 ", 'yes');
// OR (Select eOrganizationType from ".PRJ_DB_PREFIX."_organization_master where iOrganization=$curORGID)!='Supplier')
$tot_orgbyusrvrfy = $orgbyusrvrfy['tot'];
unset($orgbyusrvrfy['tot']);
// prints($orgbyusrvrfy); exit;
$bid = '';
for ($l = 0; $l < count($orgbyusrvrfy); $l++) {
$bid[] = $orgbyusrvrfy[$l]['iUserID'];
}
$bw = '';
if (is_array($bid)) {
$bid = @implode(',', $bid);
$bw = " AND ou.iUserID NOT IN ({$bid})";
}
$auth1sts = $statusmasterObj->getDetails('iStatusID', " AND eFor='Invoice' AND vStatus_en='Auth1' ");
$auth1sts = $auth1sts[0]['iStatusID'];
