include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreferenceToverify.php";
$orgPrefVrfObj = new OrganizationPreferenceToverify();
}
$activationcode = GetVar('msg');
if (trim($activationcode) == '') {
header("Location: " . SITE_URL_DUM . "home");
exit;
}
//$id = $orgObj->getid($activationcode);
$where = " vActivationCode='{$activationcode}' ";
$data['eStatus'] = 'Active';
$data['vActivationCode'] = '';
$dtls = $orgObj->getDetails('*', ' AND ' . $where);
if (is_array($dtls) && count($dtls) > 0 && isset($dtls[0]['iOrganizationID']) && $dtls[0]['iOrganizationID'] > 0) {
$rs = $orgObj->updateData($data, $where);
$r = $orgUsrObj->updateData($data, $where);
// unset($data['vActivationCode']);
$s = $orgvrfObj->updateData($data, $where);
$s = $userToVerifyObj->updateData($data, $where);
unset($data['vActivationCode']);
$where = " iOrganizationID = " . $dtls[0]['iOrganizationID'] . "";
$s = $orgprefObj->updateData($data, $where);
$opdtls = $orgprefObj->getDetails('*', ' AND ' . $where);
if (isset($opdtls[0]['iAdditionalInfoID']) && $opdtls[0]['iAdditionalInfoID'] > 0) {
$where = " iAdditionalInfoID = " . $opdtls[0]['iAdditionalInfoID'] . "";
$s = $orgPrefVrfObj->updateData($data, $where);
}
} else {
header("Location: " . SITE_URL_DUM . "home");
exit;
}
$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";
$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']);
$data['iModifiedByID'] = "";
$data['eModifiedBy'] = "";
}
}
}
}
}
$res = $orgObj->updateData($data, " iOrganizationID={$iOrganizationID} ");
$vrfydtls = $orgvrfObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} ", " iVerifiedID DESC", '', " LIMIT 0,1");
if (is_array($vrfydtls) && count($vrfydtls) > 0) {
$ivrfId = $vrfydtls[0]['iVerifiedID'];
$rs = $orgvrfObj->updateData($dt, " iVerifiedID={$ivrfId} ");
}
if ($res) {
if (is_array($opf) && count($opf) > 0) {
$rs = $orgprefObj->updateData($data, "iOrganizationID={$iOrganizationID}");
$iVerifiedID = $orgPrefVrfObj->getDetails('iVerifiedID', " AND iOrganizationID={$iOrganizationID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 ');
if (is_array($iVerifiedID) && count($iVerifiedID) > 0) {
$iVerifiedID = $iVerifiedID[0]['iVerifiedID'];
$rs = $orgPrefVrfObj->updateData($dt, "iVerifiedID={$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') {
