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