//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'); //prints($userData);exit; if ($userData['eUserType'] != '') { $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); }
$secQuestion2 = $secQuestion2['vQuestion_' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG']]; } $defaltLan = $gdbobj->getreqtableinfo(PRJ_DB_PREFIX . "_language", "vLanguageCode='" . $userData['vDefaltLan'] . "'", 'vLanguage'); $defaltLan = $defaltLan[0]; $defaltLan = $defaltLan['vLanguage']; //print_r ($userData); if ($userData['eUserType'] != '') { $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"); if ($userData['eStatus'] == 'Modified' || $userData['eStatus'] == 'Need to Verify' || $userData['eNeedToVerify'] == 'Yes') { $where = 'AND iUserID = ' . $iUserID . ''; $userData = $userToVerifyObj->getDetails('*', $where, ' iVerifiedID DESC', '', ' LIMIT 0,1 '); $userData = $userData[0]; $db_state = $stateObj->getStateDetail("iStateId, vStateCode, vState", "AND eStatus = 'Active' AND vCountryCode = '" . $userData['vCountry'] . "'", "vState"); $where = "AND iOrganizationID = " . $userData['iOrganizationID'] . ""; $organization = $orgObj->getDetails('*', $where); } if ($OuserData['eStatus'] == 'Need to Verify') { switch ($sess_usertype) { case 'securitymanager': if ($OuserData['eCreatedBy'] == 'SM') { if ($OuserData['iCreatedBy'] != $sess_id) { $verify = 'yes'; } } else { $verify = 'no'; }
$sendMail = new SendPHPMail(); } $sess_user_name = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_NAME']; $sess_usertype_short = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; if ($mode == 'status') { $where = "AND iUserID IN ({$val})"; $arr = $UsrObj->getDetails('*', $where); foreach ($arr as $k => $v) { $data = $v; $data['eNeedToVerify'] = 'Yes'; $data['iModifiedByID'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; $data['eModifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $data['dModifiedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); if ($v['eStatus'] == 'Active' && $v['eNeedToVerify'] != 'Yes') { $whr = " AND iUserID=" . $v['iUserID']; $varr = $userToVerifyObj->getDetails('*', $whr, ' iVerifiedID DESC ', '', ' LIMIT 0,1 '); if ($varr[0]['eStatus'] == 'Active' && $varr[0]['eNeedToVerify'] != 'Yes') { $data['eStatus'] = 'Inactive'; //$UsrObj->setAllVar($data); $where = "iUserID = " . $v['iUserID'] . ""; //$res = $UsrObj->updateData($data, $where); $userToVerifyObj->setAllVar($data); $res = $userToVerifyObj->insert(); // $res = $userToVerifyObj->updateData($data, $where); } else { $var_msg = $smarty->get_template_vars('MSG_VERIFY_NEED_TO_VERIFY_OR_MODIFIED'); echo $var_msg; exit; } } elseif ($v['eStatus'] == 'Inactive' && $v['eNeedToVerify'] != 'Yes') { $whr = " AND iUserID=" . $v['iUserID'];
} $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']); } } } if ($res) { $msg = "rus"; } else { $msg = "ruserr"; } unset($_SESSION['from']); $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] = $msg; if ($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'] == 'OA') {
### CHECK MULTIPLE ADMIN AVAILABLE FOR THIS ORGANIZATION OR NOT $chkMulAdmin = $orgObj->ChkMultipleOrgAdmin(); if($chkMulAdmin == '1'){ $eStatus = 'Active'; }else{ $eStatus = $eStatus; }*/ if ($view == 'reject') { $dt['eNeedToVerify'] = $dts['eNeedToVerify'] = 'No'; $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'); $dt['eStatus'] = $dts['eStatus'] = "Active"; $orgusrdtls = $orgUserObj->getDetails('*', " AND iUserID={$iUserID} "); $usrvrfydt = $userToVerifyObj->getDetails('*', " AND iUserID={$iUserID} ", " iVerifiedID DESC ", '', " LIMIT 0,1"); if ($orgusrdtls[0]['eStatus'] == 'Need to Verify') { $dts['tReasonToReject'] = $dt['tReasonToReject']; $dt['eStatus'] = $dts['eStatus'] = "Inactive"; } else { if ($usrvrfydt[0]['eStatus'] == 'Inactive' && $usrvrfydt[0]['eNeedToVerify'] == 'Yes') { $dt['eNeedToVerify'] = $dts['eNeedToVerify'] = "No"; $dt['eStatus'] = $dts['eStatus'] = "Active"; } else { if ($usrvrfydt[0]['eStatus'] == 'Active' && $usrvrfydt[0]['eNeedToVerify'] == 'Yes') { $dt['eNeedToVerify'] = $dts['eNeedToVerify'] = "No"; $dt['eStatus'] = $dts['eStatus'] = "Inactive"; $dts['tReasonToReject'] = $dt['tReasonToReject']; } else { if ($orgusrdtls[0]['eStatus'] == 'Modified') { $dt['eStatus'] = $dts['eStatus'] = "Active";