} else { $fdata['vExt'] = ''; } $fdata['dADate'] = calcGTzTime(date('Y-m-d'), 'Y-m-d'); if (trim($flnm) != '') { $rs = $rfq2flObj->insert($fdata); } } } // $sts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE 'RFQ2,%' AND vStatus_en='Verify' "); if ($Data['iStatusID'] == $sts[0]['iStatusID']) { $vrfy_eml = 'y'; // if ($Data['eAuctionType'] == 'Tender') { $aacptl = $rfq2Obj->chkAutoAcptLimit($iRFQ2Id); } // } if ($Data['eSaved'] != 'Yes' || $vrfy_eml == 'y') { if ($eFrom == 'Invoice') { $jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on rfq2.iStatusID=sm.iStatusID\r\n\t\t\t\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_inovice_order_heading ioh on rfq2.iInvoiceID=ioh.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\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_purchase_order_heading ioh on rfq2.iPurchaseOrderID=ioh.iPurchaseOrderID "; } } $where .= " AND rfq2.iRFQ2ID={$id} "; $fields = " rfq2.*, ioh.*, sm.vStatus_en as vStatus, rfq2.eSaved "; $dtls = $rfq2Obj->getJoinTableInfo($jtbl, $fields, $where, '', '', '', ''); if ($eFrom == 'PO') {