if ($totusrs > 1) { $dt['iStatusID'] = $nstatus; } else { $stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' "); $isusts = $stsdtls[0]['iStatusID']; if ($podtl[0]['iSupplierOrganizationID'] == $curORGID && $podtl[0]['iStatusID'] == $isusts) { $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');
$fields = "poh.*,(select org.vCompanyName from b2b_organization_master org where org.iOrganizationID=poh.iSupplierOrganizationID) as vSupplierName"; $arr = $poObj->getJoinTableInfo("", $fields, $where); //prints($arr);exit; $userId = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; $orgId = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGID']; $where = " AND iOrganizationID='{$orgId}'"; $emailArr = $orgUserObj->getDetails('vFirstName,vLastName,vEmail', $where); $where = ""; foreach ($arr as $k => $v) { $data['eDelete'] = 'Yes'; $data['iModifiedByID'] = $userId; // $data['eModifiedBy'] = $_SESSION['SESS_'.PRJ_CONST_PREFIX.'_USER_TYPE_SHORT']; // $data['dModifiedDate'] = date('Y-m-d H:i:s'); $poObj->setAllVar($data); $where = "iPurchaseOrderID IN (" . $v['iPurchaseOrderID'] . ")"; $res = $poObj->updateData($data, $where); $link = SITE_URL_DUM . "purchaseorderview/" . $v['iPurchaseOrderID']; $POCODE = $v['vPOCode']; $PONUMBER = $v['vPONumber']; $SUPPLIER = $v['vSupplierName']; if ($SUPPLIER == '') { $SUPPLIER = "---"; } $BUYER = $v['vBuyerCompanyName']; $where = "AND vType='PO Deleted' AND eSection='Member'"; $db_email = $emailObj->getDetails('*', $where); $body = array("#DELETE_BY#", "#PONUMBER#", "#POCODE#", "#SUPPLIER#", "#BUYER#", "#LINK#"); $post = array($sess_user_name . "({$sess_usertype_short})", $PONUMBER, $POCODE, $SUPPLIER, $BUYER, $link); $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));
} if ($id) { $msg = "rus"; } else { $msg = "ruserr"; } } } } //echo "$subt<br/>$dist<br/>$chgt<br/>$ltl"; //exit; $eSaved = $_POST['eSaved']; if ($eSaved != 'Yes') { $dtl['eSaved'] = $eSaved; $wh_cn = "iPurchaseOrderID={$iPurchaseOrderID}"; $rs = $pohObj->updateData($dtl, $wh_cn); } // prints($ilineItemCode); exit; $lineitmCode = "0"; if (is_array($ilineItemCode) && count($ilineItemCode) > 0) { $lineitmCode = @implode("','", $ilineItemCode); } $d = $poLineObj->del(" AND vItemCode NOT IN ('{$lineitmCode}') AND iPurchaseOrderID={$iPurchaseOrderID} "); $pdt = array(); if ($podt[0]['eLineItemTax'] == 'Yes' || !($podt[0]['fVat'] > 0) && $tvat > 0) { $pdt['fVat'] = $tvat; // $pdt['fOther_tax_1'] = $otax; } if ($podt[0]['eLineItemTax'] == 'Yes' || !($podt[0]['fOther_tax_1'] > 0) && $otax > 0) { // $pdt['fVat'] = $tvat; $pdt['fOther_tax_1'] = $otax;
$redtl = array('iRFQ2Id' => $dtls[0]['iRFQ2Id'], 'iBuyer2Id' => $dtls[0]['iBuyer2Id'], 'iBuyerId' => $dtls[0]['iBuyerOrganizationId'], 'iSupplierId' => $dtls[0]['iSupplierOrganizationId'], 'iInvoiceID' => $dtls[0]['iInvoiceID'], 'iPurchaseOrderID' => $dtls[0]['iPurchaseOrderID'], 'vCurrency' => $dtls[0]['vCurrency'], 'dReviewDate' => date('Y-m-d', strtotime("+5 day", strtotime(date('Y-m-d')))), 'eFrom' => $dtls[0]['eFrom']); $re = $rfq2extractObj->insert($redtl); // set invoice rfq2awarded yes if ($dtls[0]['eFrom'] == 'Invoice') { if (!isset($invOrdObj)) { include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php"; $invOrdObj = new InvoiceOrderHeading(); } $ress = $invOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iInvoiceID=" . $dtls[0]['iInvoiceID']); } else { if ($dtls[0]['eFrom'] == 'PO') { if (!isset($poOrdObj)) { include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php"; $poOrdObj = new PurchaseOrderHeading(); } $ress = $poOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iPurchaseOrderID=" . $dtls[0]['iPurchaseOrderID']); } } //send mail to buyer2 for award. $db_email = $emailObj->getDetails('*', " AND vType='New RFQ2 Award' AND eSection='Member' "); $orgdtls = $orgObj->select($dtls[0]['iOrganizationID']); $link = SITE_URL . "b2rfq2awardview/" . $r2awid; $body = array("#CREATED_BY#", "#RFQ2CODE#", "#BIDNUM#", "#ADVANCE#", "#PRICE#", "#LINK#"); $post = array($orgdtls[0]['vCompanyName'] . '(' . $orgdtls[0]['vOrganizationCode'] . ')', $dtls[0]['vRFQ2Code'], $dtls[0]['vBidNum'], $dtls[0]['fBidAdvanceTotal'], $dtls[0]['fBidPriceTotal'], $link); $rplarr = array("Hello #NAME#,", "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)); $tbody_fr = str_replace($rplarr, " ", $db_email[0]['tBody_fr']); $emailContent_fr = trim(str_replace($body, $post, $tbody_fr)); $dt = array(); $dt['iItemID'] = $r2awid;
$Data['vBuyerCode'] = $buyerOrgDtls[0]['vOrganizationCode']; $Data['vBuyerCompanyName'] = $buyerOrgDtls[0]['vCompanyName']; $Data['vBuyerContactTelephone'] = $buyerOrgDtls[0]['vPhone']; $Data['vBuyerContactEmail'] = $buyerOrgDtls[0]['vEmail']; $vItmCode = $pohObj->getUniqueCode(); $Data['vPOCode'] = $vItmCode; $Data['vPONumber'] = "PO" . $Data['vPOCode'] . "-" . trim($Data['vBuyerCode']); if (trim($Data['eSaved']) == '') { $Data['eSaved'] = 'No'; } // prints($Data); exit; $pohObj->setAllVar($Data); $iPOId = $pohObj->insert(); $vImage = $imgObj->ImageUpload('PO', 'image', $iPOId, $_FILES['importfile'], ''); $Dta['vImage'] = $vImage; $iPOId = $pohObj->updateData($Dta, "iPurchaseOrderID={$iPOId}"); $var_msg = 'poimportsucc'; @unlink($filepath); header("Location:" . SITE_URL . "importpurchaseorders/{$var_msg}"); exit; } $enc = $_POST['enctyp']; // $enc = $encPO; //if($enc == 'y') //{ $opf = $orgprefObj->getDetails('*', " AND iOrganizationID={$curORGID} "); if ($opf[0]['eSecureImportPO'] == 'Yes') { $enc = 'y'; } $encKey = $opf[0]['vEncryptionKey']; $encAlgo = $opf[0]['eCryptAlgo'];
$emailArr = $orgUsrObj->getPermittedUsers($prv_dtls[0]['iOrganizationID'], "{$csts}%", '', 'vRFQ2AwardPermits', " AND ou.eEmailNotification='Yes' AND ou.eStatus='Active' "); $body_arr = array("#NAME#", "#BY#", "#RFQ2CODE#", "#BIDNUM#", "#ADVANCE#", "#PRICE#", "#LINK#", "#MAIL_FOOTER#", "#SITE_URL#"); if (is_array($emailArr) && count($emailArr) > 0) { for ($i = 0; $i < count($emailArr); $i++) { $smname = $emailArr[$i]['vFirstName'] . ' ' . $emailArr[$i]['vLastName']; $email = $emailArr[$i]['vEmail']; $post_arr = array($smname, $oth_org[0]['vCompanyName'] . '(' . $oth_org[0]['vOrganizationCode'] . ')', $prv_dtls[0]['vRFQ2Code'], $prv_dtls[0]['vBidNum'], $prv_dtls[0]['fBidAdvanceTotal'], $prv_dtls[0]['fBidPriceTotal'], $link, $MAIL_FOOTER, SITE_URL); $sendMail->Send("RFQ2 Award Accepted", "Member", $email, $body_arr, $post_arr); } } // if ($prv_dtls[0]['eFrom'] == "Invoice") { $ress = $invOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iInvoiceID=" . $prv_dtls[0]['iInvoiceID'] . " "); } else { if ($prv_dtls[0]['eFrom'] == "PO") { $ress = $purOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iPurchaseOrderID=" . $prv_dtls[0]['iPurchaseOrderID'] . " "); if ($prv_dtls[0]['iPurchaseOrderID'] != "0" && $prv_dtls[0]['iPurchaseOrderID'] != "") { $inv_det = $invOrdObj->getDetails('*', " AND iPurchaseOrderID = '" . $prv_dtls[0]['iPurchaseOrderID'] . "' "); $rfq2_dets = $rfq2Obj->getDetails('*', " AND iInvoiceID = '" . $inv_det[0]['iInvoiceID'] . "' "); if (count($rfq2_dets) > 0) { $rfq2_dtls['fPOAwardAdvace'] = $prv_dtls[0]['fBidAdvanceTotal']; $rfq2_dtls['fPOAwardPrice'] = $prv_dtls[0]['fBidPriceTotal']; $rfq2_dtls['fPOAwardAmount'] = $prv_dtls[0]['fBidAmount']; $ress = $rfq2Obj->updateData($rfq2_dtls, " iRFQ2Id=" . $prv_dtls[0]['iRFQ2Id'] . " "); } } } } } } }