$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'] = $data['eStatus'] = "Active"; $orgpfdtls = $orgprefObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} "); if ($orgpfdtls[0]['eStatus'] == 'Need to Verify') { $dt['eStatus'] = $data['eStatus'] = "Inactive"; } else { if ($orgpfdtls[0]['eStatus'] == 'Modified') { $dt['eStatus'] = $data['eStatus'] = "Active"; $data['iModifiedByID'] = ""; $data['eModifiedBy'] = ""; } } $res = $orgprefObj->updateData($data, " iOrganizationID={$iOrganizationID} "); $rs = $orgObj->updateData($data, " iOrganizationID={$iOrganizationID} "); $verified = $orgvrfObj->getDetails('iVerifiedID', " AND iOrganizationID={$iOrganizationID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 '); $iVerifiedID = $verified[0]['iVerifiedID']; $rs = $orgvrfObj->updateData($dt, " iVerifiedID={$iVerifiedID} "); $vrfydtls = $orgPrefVrfObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} ", " AND iVerifiedID DESC", '', " LIMIT 0,1"); $iVerifiedID = $vrfydtls[0]['iVerifiedID']; $rs = $orgPrefVrfObj->updateData($dt, " iVerifiedID={$iVerifiedID} "); if ($res) { $msg = "rus"; } else { $msg = "ruserr"; } $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] = $msg; if ($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'] == 'OA') { unset($_SESSION['from']); header("Location:" . SITE_URL_DUM . "createorganizationpref/" . $iOrganizationID . "/" . $msg); exit;
$sname = $arr[0]['vFirstName'] . ' ' . $arr[0]['vLastName']; $cname = $Data['vCompanyName']; $regno = $Data['vCompanyRegNo']; $code = isset($Data['vOrganizationCode']) ? $Data['vOrganizationCode'] : ''; // echo $view; exit; if ($view == 'reject') { //echo $view; exit; $iOrganizationID = $_POST['iOrgId']; $dt['eNeedToVerify'] = $data['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'] = $data['eStatus'] = "Active"; $orgdtls = $orgObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} "); $orgvrfdt = $orgvrfObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 '); if ($orgdtls[0]['eStatus'] == 'Need to Verify') { $dt['eStatus'] = $data['eStatus'] = "Inactive"; } else { if ($orgvrfdt[0]['eStatus'] == 'Inactive' && $orgvrfdt[0]['eNeedToVerify'] == 'Yes') { $dt['eNeedToVerify'] = $data['eNeedToVerify'] = "No"; $dt['eStatus'] = $data['eStatus'] = "Active"; } else { if ($orgvrfdt[0]['eStatus'] == 'Active' && $orgvrfdt[0]['eNeedToVerify'] == 'Yes') { $dt['eNeedToVerify'] = $data['eNeedToVerify'] = "No"; $dt['eStatus'] = $data['eStatus'] = "Inactive"; } else { if ($orgdtls[0]['eStatus'] == 'Modified') { $dt['eStatus'] = $data['eStatus'] = "Active"; $data['iModifiedByID'] = ""; $data['eModifiedBy'] = "";
$data['eStatus'] = 'Active'; //$orgObj->setAllVar($data); $where = "iOrganizationID = " . $v['iOrganizationID'] . ""; $dtl['eNeedToVerify'] = 'Yes'; $res = $orgObj->updateData($dtl, $where); //$res = $orgObj->updateData($data, $where); $orgvrfObj->setAllVar($data); $res = $orgvrfObj->insert(); } elseif ($v['eStatus'] == 'Modified' || $v['eStatus'] == 'Need to Verify') { $var_msg = $smarty->get_template_vars('MSG_VERIFY_NEED_TO_VERIFY_OR_MODIFIED'); echo $var_msg; exit; } $where = " AND iOrganizationID = " . $v['iOrganizationID'] . ""; $orderby = ' iVerifiedID Desc'; $vrfid = $orgvrfObj->getDetails('iVerifiedID', $where, $orderby); // --------------------- ORGANIZATION DATA FETCHED ------------------------------------------// $cname = $v['vCompanyName']; $regno = $v['vCompanyRegNo']; $code = $v['vOrganizationCode']; $where = 'AND iSMID != ' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'] . ' AND eStatus = "Active"'; $smdtls = $secManObj->getDetails('*', $where); // --------------------- $where = 'AND vType="Organization Status Changed" AND eSection = "Member"'; $db_email = $emailObj->getDetails('*', $where); $link = SITE_URL_DUM . "organizationview/" . $v['iOrganizationID']; $body = array("#SMNAME#", "#CNAME#", "#LINK#", "#MODIFIED_BY#", "#REGNO#", "#ORGCODE#"); $post = array($sname, $cname, $link, $sess_user_name . "({$sess_usertype_short})", $regno, $code); $rplarr = array("Hello #SMNAME#,", "background-color: rgb(239, 239, 239);", "Regards,", "#MAIL_FOOTER#", "#SITE_URL#"); $tbody_en = str_replace($rplarr, " ", $db_email[0]['tBody_en']); $emailContent_en = trim(str_replace($body, $post, $tbody_en));
} $msg = isset($msg) ? $msg : ''; if ($msg == 'rus') { $msg = $smarty->get_template_vars('MSG_UPDATE_SUCC'); } elseif ($msg == 'ruserr') { $msg = $smarty->get_template_vars('MSG_UPDATE_ERR'); } else { $msg = ''; } //echo $iOrganizationID;exit; if ($iOrganizationID != '') { $view = 'edit'; // $msg = $smarty->get_template_vars('MSG_NEED_VERIFY'); if ($pg == 'verify') { $where = 'AND iOrganizationID = ' . $iOrganizationID . ''; $Oarr = $arr = $orgvrfObj->getDetails('*', $where); $where = 'AND iOrganizationID = ' . $arr[0]['iOrganizationID'] . ''; $Oprefarr = $prefarr = $orgprefObj->getDetails('iAdditionalInfoID', $where); $OiAdditionalInfoID = $iAdditionalInfoID = $prefarr[0]['iAdditionalInfoID']; } else { $where = 'AND iOrganizationID = ' . $iOrganizationID . ''; $Oarr = $arr = $orgObj->getDetails('*', $where); $Oprefarr = $prefarr = $orgprefObj->getDetails('iAdditionalInfoID', $where); $OiAdditionalInfoID = $iAdditionalInfoID = isset($prefarr[0]['iAdditionalInfoID']) ? $prefarr[0]['iAdditionalInfoID'] : ''; } // prints($arr);exit; } //prints($arr);exit; //Get State Array $state = $cntstObj->getgeneralArr(PRJ_DB_PREFIX . "_state_master", " AND eStatus='Active'", "vStateCode", "vState", "vCountryCode", "vStateCode,vState,vCountryCode"); $stateArr = $state[0];