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