$iVerifiedID = $dt[0]['iVerifiedID']; unset($dt[0]['iVerifiedID']); if (count($dt) == 0) { $dt['eStatus'] = "Active"; } $res = $orgprefObj->updateData($dt, "iOrganizationID={$iOrganizationID}"); $rs = $orgObj->updateData($dt, " iOrganizationID={$iOrganizationID} "); $verified = $orgvrfObj->getDetails('iVerifiedID', " AND iOrganizationID={$iOrganizationID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 '); $ivid = $verified[0]['iVerifiedID']; $rs = $orgvrfObj->updateData($dt, " iVerifiedID={$ivid} "); $where = " iVerifiedID={$iVerifiedID} "; $dtls['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $dtls['iVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; $dtls['dVerifyDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $dtls['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR']; $rs = $userActionObj->updateData($dtls, $where); if ($res) { $orgdtls = $orgObj->select($iOrganizationID); /*if($orgdtls[0]['eOrganizationType'] == 'Supplier'){ $opdt['vOrderStatusLevel'] = ''; $rs = $orgprefObj->updateData($opdt,"iOrganizationID=$iOrganizationID"); } else if($orgdtls[0]['eOrganizationType'] == 'Buyer'){ $opdt['vInvoiceStatusLevel'] = ''; $rs = $orgprefObj->updateData($opdt,"iOrganizationID=$iOrganizationID"); }*/ $rs = $orgUserPermObj->clearExtraPermits($iOrganizationID, $orgdtls[0]['eOrganizationType']); // $rs = $orgUserPermObj->clearExPermits($iOrganizationID,$orgdtls[0]['eOrganizationType'],$Data1); } // $orgObj->setAllVar($Data); // $res = $orgvrfObj->insert(); // CHANGE STATUS IN ORGANIZATION MASTER
$nsts = $dt['iStatusID']; if (isset($_POST['Data']['fAcceptedAmount']) && $dt['iaStatusID'] > 0) { $dt['fAcceptedAmount'] = $_POST['Data']['fAcceptedAmount']; $dt['dAcceptedVat'] = $_POST['Data']['dAcceptedVat']; $dt['dAcceptedOtherTax'] = $_POST['Data']['dAcceptedOtherTax']; $dt['dAcceptedWHTax'] = $_POST['Data']['dAcceptedWHTax']; $dt['dAcceptedNetPaymentDate'] = $_POST['Data']['dAcceptedNetPaymentDate']; } // pr($_POST); // pr($dt); exit; $id = $invOrdObj->updateData($dt, " iInvoiceID={$iInvoiceID} "); $vrfydt['iVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; $vrfydt['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $vrfydt['dVerifyDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $vrfydt['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR']; $res = $userActionObj->updateData($vrfydt, "iItemID={$iInvoiceID} AND eSubject='Invoice'"); // prints($act); exit; if ($id) { $act = $act[0]['vStatus_en']; if ($dt['iaStatusID'] == $cstsdtl[0]['iStatusID']) { $sub1 = "New Invoice Created"; $type = "Create"; $actn = "Create"; $sub2 = "New Invoice"; $vorgid = $invdtl[0]['iBuyerOrganizationID']; } else { $sub1 = "Invoice Status Changed"; $type = "Modified"; $actn = $act; $sub2 = "Invoice Status Changed"; }
$acptsts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' "); $dt['iStatusID'] = $acptsts[0]['iStatusID']; } else { // $stsdtls = $statusmasterObj->getDetails('*'," AND eFor='PO' AND vStatus_en='Issued' "); $dt['iStatusID'] = $isusts; } } $dt['iModifiedByID'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; // prints($dt); exit; $id = $pohObj->updateData($dt, " iPurchaseOrderID={$iPurchaseOrderID} "); $vrfydt['iVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; $vrfydt['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; // $vrfydt['eCreatedType'] = $_SESSION['SESS_'.PRJ_CONST_PREFIX.'_USER_TYPE_SHORT']; $vrfydt['dVerifyDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $vrfydt['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR']; $res = $userActionObj->updateData($vrfydt, "iItemID={$id} AND eSubject='PO'"); if ($id) { $isusts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' "); if ($nstatus == $isusts[0]['iStatusID'] && ($podtl[0]['iInvoiceID'] == '' || $podtl[0]['iInvoiceID'] < 1)) { // $vInvoiceCode = $generalobj->getUniqueCode(PRJ_DB_PREFIX."_inovice_order_heading","vInvoiceCode"); $povdt = $pohObj->select($iPurchaseOrderID); $splrorg = $orgObj->select($povdt[0]['iSupplierOrganizationID']); // New PO Acceptance $acptsts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' "); $tusrs = $orgUsrObj->getPermittedUsers($povdt[0]['iSupplierOrganizationID'], $acptsts[0]['iStatusID'], 'po', 'acpt'); $where = "AND vType='New PO Acceptance' AND eSection='Member'"; $db_email = $emailObj->getDetails('*', $where); $link = SITE_URL_DUM . "purchaseorderview/" . $iPurchaseOrderID; $body = array("#POCODE#", "#SUPPLIERORG#", "#SUPORGCODE#", "#BUYERORG#", "#BUYORGCODE#", "#LINK#"); $post = array($povdt[0]['vInvoiceCode'], $povdt[0]['vSupplierName'], $splrorg[0]['vOrganizationCode'], $povdt[0]['vBuyerCompanyName'], $povdt[0]['vBuyerCode'], $link); $rplarr = array("Hello #NAME#,", "background-color: rgb(239, 239, 239);", "Regards,", "#MAIL_FOOTER#", "#SITE_URL#");
unset($updtdata[0]['iAsociationID']); $vdt = $updtdata[0]; //prints($where); // prints($vdt); exit; $res = $orgAssocObj->updateData($vdt, $where); // echo "<br/>".$where; exit; //echo $where; exit; $udt['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $udt['iVerifiedBy'] = $sess_id; $udt['dVerifyDate'] = date('Y-m-d H:i:s'); $udt['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR']; // $udt['eNeedToVerify']='No'; $userActionObj->setAllVar($udt); $where = " iItemID='" . $iVerifiedID . "' AND eSubject = 'Association'"; // echo $where; exit; $res = $userActionObj->updateData($udt, $where); $where = ""; unset($udt); //unset($vdt); //unset($dt); // } // } if ($res) { $msg = "rvs"; } else { $msg = "rvserr"; } } } else { //$where = "iAsociationID='".$updt[$ln]['iAsociationID']."'"; //$orgAssocVerifyObj->updateData(array('eStatus'=>"Inactive"), $where);
$updt['eStatus'] = $r2bdObj->chkAuctionBidStatus($iBidId); // pr($updt); exit; $res = $r2bdObj->updateData($updt, " iBidId={$iBidId} "); if ($res) { if ((!isset($dt[0]['eDelete']) || $dt[0]['eDelete'] != 'Yes') && $updt['eStatus'] == 'current') { $sub = 'New Bid For RFQ2'; } $vrfydt['iVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; $vrfydt['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $vrfydt['dVerifyDate'] = calcGTzTime(date("Y-m-d H:i:s"), 'Y-m-d H:i:s'); $vrfydt['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR']; $vrfydt['vAction'] = 'Verify'; $ivid = $userActionObj->getDetails('iVerifiedID', " AND iItemID={$iBidId} AND eSubject='RFQ2 Bid' ", " iVerifiedID DESC "); if (isset($ivid[0]['iVerifiedID']) && trim($ivid[0]['iVerifiedID']) != '' && $ivid[0]['iVerifiedID'] > 0) { $ivid = $ivid[0]['iVerifiedID']; $rs = $userActionObj->updateData($vrfydt, " iVerifiedID={$ivid} "); } $msg = "rvs"; } else { $msg = "rver"; } } else { $msg = "rver"; } } else { if ($view == 'reject' && trim($iBidId) != '' && $iBidId > 0) { $dtls = $r2bdObj->select($iBidId); $id = $iBidId; if (is_array($dtls) && count($dtls) > 0) { $updt['iRejectedBy'] = $sess_id; if (isset($dtls[0]['eDelete']) && $dtls[0]['eDelete'] == 'Yes') {