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
