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