$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);