$usrprmtdtls = $orgUserPermObj->getDetails('*', " AND iPermissionID={$iPermissionID} ");
if ($usrprmtdtls[0]['eStatus'] == 'Need to Verify') {
$dt['eStatus'] = $dts['eStatus'] = "Inactive";
} else {
if ($usrprmtdtls[0]['eStatus'] == 'Modified') {
$dt['eStatus'] = $dts['eStatus'] = "Active";
$dts['iModifiedByID'] = "";
$dts['eModifiedBy'] = "";
}
}
$dt['tReasonToReject'] = $_POST['tReasonToReject'];
$dt['iRejectedById'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$dt['eRejectedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$dt['dRejectedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
$res = $orgUserPermObj->updateData($dts, " iPermissionID={$iPermissionID} ");
$iVerifiedID = $orgUserPermVerifyObj->getDetails('*', " AND iPermissionID={$iPermissionID} ", " iVerifiedID DESC ", '', " LIMIT 0,1");
if (is_array($iVerifiedID) && count($iVerifiedID) > 0) {
$iVerifiedID = $iVerifiedID[0]['iVerifiedID'];
$rs = $orgUserPermVerifyObj->updateData($dt, " iVerifiedID={$iVerifiedID} ");
}
if ($res) {
$updtl = $orgUserPermObj->select($iPermissionID);
$iUserID = $updtl[0]['iUserID'];
$usrprmtdtls = $orgUsrObj->getDetails('*', " AND iUserID={$iUserID} ");
$vudtl = $userToVerifyObj->getDetails('*', " AND iUserID={$iUserID} ", " iVerifiedID DESC ", '', " LIMIT 0,1");
if ($usrprmtdtls[0]['eStatus'] == 'Need to Verify' || $usrprmtdtls[0]['eStatus'] == 'Modified' || $usrprmtdtls[0]['eStatus'] == 'Delete' || $usrprmtdtls[0]['eNeedToVerify'] == 'Yes') {
$rs = $orgUsrObj->updateData($dts, " iUserID={$iUserID} ");
if ($vudtl[0]['iVerifiedID'] > 0) {
$rs = $userToVerifyObj->updateData($dt, " iVerifiedID=" . $vudtl[0]['iVerifiedID']);
}
}
}
$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");
$where = " AND iOrganizationID=" . $OuserData['iOrganizationID'] . "";
$organization = $orgObj->getDetails('*', $where);
// prints($organization); exit;
$msg = $smarty->get_template_vars('MSG_NEED_VERIFY');
$dts['iModifiedByID'] = "";
$dts['eModifiedBy'] = "";
}
}
}
}
}
$res = $orgUserObj->updateData($dts, " iUserID={$iUserID} ");
$iVerifiedID = $userToVerifyObj->getDetails('*', " AND iUserID={$iUserID} ", " iVerifiedID DESC ", '', " LIMIT 0,1");
if (is_array($iVerifiedID) && count($iVerifiedID) > 0) {
$iVerifiedID = $iVerifiedID[0]['iVerifiedID'];
$rs = $userToVerifyObj->updateData($dt, " iVerifiedID={$iVerifiedID} ");
}
if ($res) {
$usrprmtdtls = $orgUserPermObj->getDetails('*', " AND iUserID={$iUserID} ");
$vudtl = $orgUserPermVerifyObj->getDetails('*', " AND iUserID={$iUserID} ", " iVerifiedID DESC ", '', " LIMIT 0,1");
if ($usrprmtdtls[0]['eStatus'] == 'Need to Verify' || $usrprmtdtls[0]['eStatus'] == 'Modified' || $usrprmtdtls[0]['eStatus'] == 'Delete' || $usrprmtdtls[0]['eNeedToVerify'] == 'Yes') {
$rs = $orgUserPermObj->updateData($dts, " iUserID={$iUserID} ");
if ($vudtl[0]['iVerifiedID'] > 0) {
$rs = $orgUserPermVerifyObj->updateData($dt, " iVerifiedID=" . $vudtl[0]['iVerifiedID']);
}
}
}
// $res = $orgUserPermObj->updateData($dts," iUserID=$iUserID ");
// $pVerifiedID = $orgUserPermVerifyObj->getDetails('iVerifiedID'," AND iUserID=$iUserID ",' iVerifiedID DESC','',' LIMIT 0,1 ');
// $pVerifiedID = $pVerifiedID[0]['iVerifiedID'];
// $rs = $userToVerifyObj->updateData($dt," iVerifiedID=$pVerifiedID ");
if ($res) {
$msg = "rus";
} else {
$msg = "ruserr";
