$userTypeVal = $userData['eUserType'];
} else {
$userTypeVal = 'User';
}
$userTypes = $gdbobj->getEnumSelect("" . PRJ_DB_PREFIX . "_organization_user", "eUserType", "Data[eUserType]", "eUserType", "", $userTypeVal, "style='width:200px;' class='drop-down' ", "Select User Type");
//$eStatus = $gdbobj->getEnumSelect("".PRJ_DB_PREFIX."_organization_user", "eStatus","Data[eStatus]", "eStatus","",$statusVal,"style='width:200px;' class='drop-down' ","Select Status");
$where = 'AND iUserID = ' . $iUserID . '';
$udts = $userToVerifyObj->getDetails('*', $where, ' iVerifiedID desc ', '', ' LIMIT 0,1 ');
$udts = $udts[0];
//prints($udts);//exit;
if ($udts['eStatus'] == 'Modified' || $udts['eNeedToVerify'] == 'Yes' || $udts['eStatus'] == 'Delete') {
$where = 'AND iUserID = ' . $iUserID . '';
// $userData = $userToVerifyObj->getDetails('*',$where,' iVerifiedID desc');
$fields = " ou.*, grp.vGroupName";
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_organization_group grp on ou.iGroupID=grp.iGroupID ";
$userData = $userToVerifyObj->getJoinTableInfo($jtbl, $fields, " AND ou.iUserID={$iUserID} ", ' iVerifiedID desc ');
$userData = $userData[0];
//prints($userData);
//exit ;
$db_state = $stateObj->getStateDetail("iStateId, vStateCode, vState", "AND eStatus = 'Active' AND vCountryCode = '" . $userData['vCountry'] . "'", "vState");
$where = " AND iOrganizationID=" . $userData['iOrganizationID'] . "";
$organization = $orgObj->getDetails('*', $where);
}
$secQuestion1 = $gdbobj->getreqtableinfo(PRJ_DB_PREFIX . "_sec_question", "iQuestionID='" . $userData['iSecretQuestion1ID'] . "'", 'vQuestion_' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG']);
$secQuestion1 = $secQuestion1[0];
$secQuestion1 = $secQuestion1['vQuestion_' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG']];
$secQuestion2 = array();
if ($userData['iSecretQuestion2ID'] != '') {
$secQuestion2 = $gdbobj->getreqtableinfo(PRJ_DB_PREFIX . "_sec_question", "iQuestionID='" . $userData['iSecretQuestion2ID'] . "'", 'vQuestion_' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG']);
$secQuestion2 = isset($secQuestion2[0]) ? $secQuestion2[0] : '';
$secQuestion2 = isset($secQuestion2['vQuestion_' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG']]) ? $secQuestion2['vQuestion_' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG']] : '';
$cursorttype = $_POST['cursorttype'];
if ($cursort != '') {
if ($cursorttype == '1') {
$cursort_type = 'ASC';
} else {
$cursort_type = 'DESC';
}
$orderBy = " {$cursort} {$cursort_type}";
} else {
$orderBy = " ou.iVerifiedID DESC ";
}
## ENDS HERE ###
$groupby = "iUserID";
$limit = " LIMIT " . ($page - 1) * $REC_LIMIT_FRONT . ", " . $REC_LIMIT_FRONT . " ";
$jtbl = "INNER JOIN " . PRJ_DB_PREFIX . "_organization_master org on (org.iOrganizationID=ou.iOrganizationID AND NOT (org.eStatus='Delete' AND org.eNeedToVerify='No'))\r\n\t\t\t\t LEFT JOIN " . PRJ_DB_PREFIX . "_country_master cm on BINARY ou.vCountry=cm.vCountryCode";
$userlist = $orgUserObj->getJoinTableInfo($jtbl, "ou.iUserID,ou.vFirstName,ou.vLastName,ou.vEmail,ou.eUserType,ou.eStatus,cm.vCountry,org.vCompanyName as OrgName", $where, $orderBy, ' ou.iUserID ', $limit, 'yes');
//$userlist = $orgUserObj->getDetails_PG('*',$where,$orderBy,$groupby,$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);
