if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $crsts = $statusmasterObj->getDetails('*', " AND vForAuction LIKE 'RFQ2,%' AND vStatus_en='Create' "); $crsts = $crsts[0]['iStatusID']; if (($dtls[0]['vStatus'] == 'Create' || $dtls[0]['vStatus'] == 'Verify' || $dtls[0]['eDelete'] == 'Yes') && $dtls[0]['eSaved'] != 'Yes') { // && $orgprf[0]['eRFQ2VerifyReq']=='Yes' header("Location: " . SITE_URL_DUM . "rfq2view/{$irfq2id}"); exit; } $orgprf = $orgprefObj->getDetails('*', " AND iOrganizationID=" . $dtls[0]['iOrganizationID']); $rfq2files = $rfq2Obj->getRfq2Files($irfq2id); $rfq2prdt = $rfq2Obj->getRfq2Product($irfq2id); $rfq2pb2asoc = $rfq2Obj->getRfq2PB2Asoc($irfq2id); $rfq2b2 = $rfq2Obj->getRfq2B2($irfq2id); $orgas = ""; if ($dtls[0]['iBuyerID'] == $curORGID) { $orgas = "Buyer"; } else { if ($dtls[0]['iSupplierID'] == $curORGID) { $orgas = "Supplier"; } } // $acptsts = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Accepted' "); $acptsts = $acptsts[0]['iStatusID']; $dtls[0]['iInvoiceID'] = isset($dtls[0]['iInvoiceID']) ? $dtls[0]['iInvoiceID'] : '0'; $invsc = ""; if (trim($dtls[0]['iInvoiceID']) != '' && $dtls[0]['iInvoiceID'] > 0) { $invsc = " OR iInvoiceID=" . $dtls[0]['iInvoiceID'] . " ";
} else { if ($eFrom == 'PO') { $jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on rfq2.iStatusID=sm.iStatusID\r\n\t\t\t\t LEFT JOIN " . PRJ_DB_PREFIX . "_purchase_order_heading ioh on rfq2.iPurchaseOrderID=ioh.iPurchaseOrderID "; } } $where .= " AND rfq2.iRFQ2ID={$iRFQ2Id} "; $fields = " rfq2.*, ioh.*, sm.vStatus_en as vStatus, rfq2.eSaved "; $dtls = $rfq2Obj->getJoinTableInfo($jtbl, $fields, $where, '', '', '', ''); if ($eFrom == 'PO') { $dtls[0]['vInvoiceCode'] = $dtls[0]['vPOCode']; } // pr($dtls); exit; // $orgdtls = $orgObj->select($dtls[0]['iOrganizationID']); if (is_array($dtls) && count($dtls) > 0 && is_array($orgdtls) && count($orgdtls) > 0) { $rfq2b2 = $rfq2Obj->getRfq2B2($iRFQ2Id); if (is_array($rfq2b2) && count($rfq2b2) > 0) { for ($l = 0; $l < count($rfq2b2); $l++) { if ($rfq2b2[0]['iOrganizationID'] > 0) { // $db_email = $emailObj->getDetails('*', " AND vType='New RFQ2' AND eSection='Member' "); $link = SITE_URL . "rfq2view/" . $iRFQ2Id; $body = array("#CREATED_BY#", "#RFQ2CODE#", "#INVOICECODE#", "#STARTDATE#", "#ENDDATE#", "#TYPE#", "#LINK#"); $post = array($orgdtls[0]['vCompanyName'] . '(' . $orgdtls[0]['vOrganizationCode'] . ')', $dtls[0]['vRFQ2Code'], $dtls[0]['vInvoiceCode'], $dtls[0]['dStartDate'], $dtls[0]['dEndDate'], $dtls[0]['eBidCriteria'], $link); $rplarr = array("Hello #USER#,", "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['iItemID'] = $iRFQ2Id; // $id