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['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') { header('Location:' . SITE_URL_DUM . 'createorganizationuser/' . $usrprmtdtls[0]['iUserID'] . '/' . $var_msg); exit; } else { header("Location:" . SITE_URL_DUM . "organizationuserlist/" . $msg);
$dts['eModifiedBy'] = ""; } else { if ($orgusrdtls[0]['eStatus'] == 'Delete') { $dt['eStatus'] = $dts['eStatus'] = "Active"; $dts['iModifiedByID'] = ""; $dts['eModifiedBy'] = ""; } } } } } $res = $orgUserObj->updateData($dts, " iUserID={$iUserID} "); $iVerifiedID = $userToVerifyObj->getDetails('*', " AND iUserID={$iUserID} ", " iVerifiedID DESC ", '', " LIMIT 0,1"); if (is_array($iVerifiedID) && count($iVerifiedID) > 0) { $iVerifiedID = $iVerifiedID[0]['iVerifiedID']; $rs = $userToVerifyObj->updateData($dt, " iVerifiedID={$iVerifiedID} "); } if ($res) { $usrprmtdtls = $orgUserPermObj->getDetails('*', " AND iUserID={$iUserID} "); $vudtl = $orgUserPermVerifyObj->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 = $orgUserPermObj->updateData($dts, " iUserID={$iUserID} "); if ($vudtl[0]['iVerifiedID'] > 0) { $rs = $orgUserPermVerifyObj->updateData($dt, " iVerifiedID=" . $vudtl[0]['iVerifiedID']); } } } // $res = $orgUserPermObj->updateData($dts," iUserID=$iUserID "); // $pVerifiedID = $orgUserPermVerifyObj->getDetails('iVerifiedID'," AND iUserID=$iUserID ",' iVerifiedID DESC','',' LIMIT 0,1 '); // $pVerifiedID = $pVerifiedID[0]['iVerifiedID']; // $rs = $userToVerifyObj->updateData($dt," iVerifiedID=$pVerifiedID ");