File: /www/exchange0old/exchange/classes/Model/MCredentials.php
<?php
include_once('admin/classes/Model/trade_actions.php');
class Model_MCredentials extends Trade_actions
{
function getMyCredentials($id)
{
$query = new Bin_Query();
$query->executeQuery("SELECT organisation_reference_id
FROM `organisation_details`
WHERE user_id= '".$id."' ");
$rec_org = $query->records[0];
$query->executeQuery("SELECT api_key, organisation_id
FROM `invoice_api_access`
WHERE organisation_id = '".$rec_org['organisation_reference_id']."' ");
$rec_api = $query->records[0];
return array(
'apiKey'=>$rec_api['api_key'],
'orgId'=>$rec_api['organisation_id']
);
}
function showInvoiceData()
{
$query = new Bin_Query();
$query->executeQuery("SELECT api_data_id, debtorid, invoiceclassification, invoicepdf, invoicevalue, DATE(created_at) as created_at, debtor_reference_id, debtor_name,currency_code
FROM invoice_api_data
LEFT JOIN debtors_detail ON debtors_detail.debtor_id = invoice_api_data.debtorid
LEFT JOIN currencies ON currencies.currency_id = debtors_detail.currency_id
WHERE originatorid = '".$_SESSION['user']['userid']."'");
return Display_DCredentials::showInvoiceData($query->records);
}
function currencySymbol($id)
{
$query= new Bin_Query();
$query->executeQuery("SELECT `currency_code`
FROM `currencies`
WHERE `currency_id`='".$id."'");
return $query->records[0]['currency_code'];
}
function editInvoiceData($Err)
{
$output = array();
$query = new Bin_Query();
$query->executeQuery("SELECT *
FROM invoice_api_data
WHERE api_data_id = '".$_GET['id']."' ");
$records = $query->records;
$query->executeQuery("SELECT *
FROM invoice_api_access
WHERE user_id = '".$_SESSION['user']['userid']."' ");
$params = json_decode($query->records[0]['params']);
foreach($params as $key => $value)
{
$output['params'][$key]= $value;
}
$sales_type=$records[0]['invoiceclassification'];
$query->executeQuery("SELECT type_name
FROM sales_types
WHERE type_id = '".$sales_type."' ");
$invoiceType=$query->records[0]['type_name'];
if (count($Err->values) > 0)
{
$output['invoiceno'] = $Err->values['invoiceno'];
$output['invoicevalue'] = $Err->values['invoicevalue'];
$output['invoicecurrency'] = $Err->values['invoicecurrency'];
$output['paymentterms'] = $Err->values['paymentterms'];
$output['invoicediscount'] = $Err->values['invoicediscount'];
$output['invoiceclassification'] = $invoiceType;
$output['pono'] = $Err->values['pono'];
$output['invoicefile'] = $Err->values['invoicefile'];
$output['invoice_date'] = $Err->values['invoice_date'];
$output['invoice_month'] = $Err->values['invoice_month'];
$output['invoice_year'] = $Err->values['invoice_year'];
$output['pur_date'] = $Err->values['pur_date'];
$output['pur_month'] = $Err->values['pur_month'];
$output['pur_year'] = $Err->values['pur_year'];
$output['payment_date'] = $Err->values['payment_date'];
$output['payment_month'] = $Err->values['payment_month'];
$output['payment_year'] = $Err->values['payment_year'];
$output['invoiceVat'] = $Err->values['invoiceVat'];
$output['invoiceVatCategory'] = $Err->values['invoiceVatCategory'];
$output['invoiceRebate'] = $Err->values['invoiceRebate'];
$output['invoiceCarriage'] = $Err->values['invoiceCarriage'];
$output['orderNo'] = $Err->values['orderNo'];
$output['receiveNo'] = $Err->values['receiveNo'];
$output['dispatchNo'] = $Err->values['dispatchNo'];
$output['trackingNo'] = $Err->values['trackingNo'];
$output['storageNo'] = $Err->values['storageNo'];
$output['outboundNo'] = $Err->values['outboundNo'];
$output['loggedNo'] = $Err->values['loggedNo'];
$output['bookedNo'] = $Err->values['bookedNo'];
$output['approvalNo'] = $Err->values['approvalNo'];
$output['authorisationNo'] = $Err->values['authorisationNo'];
$output['paymentNo'] = $Err->values['paymentNo'];
$output['reconciliationNo'] = $Err->values['reconciliationNo'];
$output['confirmationNo'] = $Err->values['confirmationNo'];
$output['deliveryNo'] = $Err->values['deliveryNo'];
$output['requisitionNo'] = $Err->values['requisitionNo'];
$output['inboundNo'] = $Err->values['inboundNo'];
$output['batchNo'] = $Err->values['batchNo'];
$output['sequenceNo'] = $Err->values['sequenceNo'];
$output['order_date'] = $Err->values['order_date'];
$output['order_month'] = $Err->values['order_month'];
$output['order_year'] = $Err->values['order_year'];
$output['request_date'] = $Err->values['request_date'];
$output['request_month'] = $Err->values['request_month'];
$output['request_year'] = $Err->values['request_year'];
$output['receive_date'] = $Err->values['receive_date'];
$output['receive_month'] = $Err->values['receive_month'];
$output['receive_year'] = $Err->values['receive_year'];
$output['dispatch_date'] = $Err->values['dispatch_date'];
$output['dispatch_month'] = $Err->values['dispatch_month'];
$output['dispatch_year'] = $Err->values['dispatch_year'];
$output['tracking_date'] = $Err->values['tracking_date'];
$output['tracking_month'] = $Err->values['tracking_month'];
$output['tracking_year'] = $Err->values['tracking_year'];
$output['storage_date'] = $Err->values['storage_date'];
$output['storage_month'] = $Err->values['storage_month'];
$output['storage_year'] = $Err->values['storage_year'];
$output['outbound_date'] = $Err->values['outbound_date'];
$output['outbound_month'] = $Err->values['outbound_month'];
$output['outbound_year'] = $Err->values['outbound_year'];
$output['logged_date'] = $Err->values['logged_date'];
$output['logged_month'] = $Err->values['logged_month'];
$output['logged_year'] = $Err->values['logged_year'];
$output['booked_date'] = $Err->values['booked_date'];
$output['booked_month'] = $Err->values['booked_month'];
$output['booked_year'] = $Err->values['booked_year'];
$output['approval_date'] = $Err->values['approval_date'];
$output['approval_month'] = $Err->values['approval_month'];
$output['approval_year'] = $Err->values['approval_year'];
$output['authorisation_date'] = $Err->values['authorisation_date'];
$output['authorisation_month'] = $Err->values['authorisation_month'];
$output['authorisation_year'] = $Err->values['authorisation_year'];
$output['reconciliation_date'] = $Err->values['reconciliation_date'];
$output['reconciliation_month'] = $Err->values['reconciliation_month'];
$output['reconciliation_year'] = $Err->values['reconciliation_year'];
$output['confirmation_date'] = $Err->values['confirmation_date'];
$output['confirmation_month'] = $Err->values['confirmation_month'];
$output['confirmation_year'] = $Err->values['confirmation_year'];
$output['delivery_date'] = $Err->values['delivery_date'];
$output['delivery_month'] = $Err->values['delivery_month'];
$output['delivery_year'] = $Err->values['delivery_year'];
}
else
{
$output['invoiceno'] = $records[0]['invoiceno'];
$output['invoicevalue'] = $records[0]['invoicevalue'];
//$output['invoicecurrency'] = $records[0]['invoicecurrency'];
$output['paymentterms'] = $records[0]['paymentterms'];
$output['invoicediscount'] = $records[0]['invoicediscount'];
$output['invoiceclassification'] = $invoiceType;
$output['pono'] = $records[0]['pono'];
$output['invoicefile'] = $records[0]['invoicepdf'];
$invoicedate = explode('-', $records[0]['invoicedate']);
$output['invoice_date'] = $invoicedate[2];
$output['invoice_month'] = $invoicedate[1];
$output['invoice_year'] = $invoicedate[0];
$purchasedate = explode('-', $records[0]['purchasedate']);
$output['pur_date'] = $purchasedate[2];
$output['pur_month'] = $purchasedate[1];
$output['pur_year'] = $purchasedate[0];
$paymentdate = explode('-', $records[0]['paymentdate']);
$output['payment_date'] = $paymentdate[2];
$output['payment_month'] = $paymentdate[1];
$output['payment_year'] = $paymentdate[0];
$expecteddate = explode('-', $records[0]['expecteddate']);
$output['expected_date'] = $expecteddate[2];
$output['expected_month'] = $expecteddate[1];
$output['expected_year'] = $expecteddate[0];
$attributes = json_decode($records[0]['attributes']);
$output['invoiceVat'] = $attributes->invoiceVat;
$output['invoiceVatCategory'] = $attributes->invoiceVatCategory;
$output['invoiceRebate'] = $attributes->invoiceRebate;
$output['invoiceCarriage'] = $attributes->invoiceCarriage;
$output['orderNo'] = $attributes->orderNo;
$output['receiveNo'] = $attributes->receiveNo;
$output['dispatchNo'] = $attributes->dispatchNo;
$output['trackingNo'] = $attributes->trackingNo;
$output['storageNo'] = $attributes->storageNo;
$output['outboundNo'] = $attributes->outboundNo;
$output['loggedNo'] = $attributes->loggedNo;
$output['bookedNo'] = $attributes->bookedNo;
$output['approvalNo'] = $attributes->approvalNo;
$output['authorisationNo'] = $attributes->authorisationNo;
$output['paymentNo'] = $attributes->paymentNo;
$output['reconciliationNo'] = $attributes->reconciliationNo;
$output['confirmationNo'] = $attributes->confirmationNo;
$output['deliveryNo'] = $attributes->deliveryNo;
$output['requisitionNo'] = $attributes->requisitionNo;
$output['inboundNo'] = $attributes->inboundNo;
$output['batchNo'] = $attributes->batchNo;
$output['sequenceNo'] = $attributes->sequenceNo;
$orderDate = explode('-', $attributes->orderDate);
$output['order_date'] = $orderDate[2];
$output['order_month'] = $orderDate[1];
$output['order_year'] = $orderDate[0];
$requestDate = explode('-', $attributes->requestDate);
$output['request_date'] = $requestDate[2];
$output['request_month'] = $requestDate[1];
$output['request_year'] = $requestDate[0];
$receiveDate = explode('-', $attributes->receiveDate);
$output['receive_date'] = $receiveDate[2];
$output['receive_month'] = $receiveDate[1];
$output['receive_year'] = $receiveDate[0];
$dispatchDate = explode('-', $attributes->dispatchDate);
$output['dispatch_date'] = $dispatchDate[2];
$output['dispatch_month'] = $dispatchDate[1];
$output['dispatch_year'] = $dispatchDate[0];
$trackingDate = explode('-', $attributes->trackingDate);
$output['tracking_date'] = $trackingDate[2];
$output['tracking_month'] = $trackingDate[1];
$output['tracking_year'] = $trackingDate[0];
$storageDate = explode('-', $attributes->storageDate);
$output['storage_date'] = $storageDate[2];
$output['storage_month'] = $storageDate[1];
$output['storage_year'] = $storageDate[0];
$outboundDate = explode('-', $attributes->outboundDate);
$output['outbound_date'] = $outboundDate[2];
$output['outbound_month'] = $outboundDate[1];
$output['outbound_year'] = $outboundDate[0];
$loggedDate = explode('-', $attributes->loggedDate);
$output['logged_date'] = $loggedDate[2];
$output['logged_month'] = $loggedDate[1];
$output['logged_year'] = $loggedDate[0];
$bookedDate = explode('-', $attributes->bookedDate);
$output['booked_date'] = $bookedDate[2];
$output['booked_month'] = $bookedDate[1];
$output['booked_year'] = $bookedDate[0];
$approvalDate = explode('-', $attributes->approvalDate);
$output['approval_date'] = $approvalDate[2];
$output['approval_month'] = $approvalDate[1];
$output['approval_year'] = $approvalDate[0];
$authorisationDate = explode('-', $attributes->authorisationDate);
$output['authorisation_date'] = $authorisationDate[2];
$output['authorisation_month'] = $authorisationDate[1];
$output['authorisation_year'] = $authorisationDate[0];
$reconciliationDate = explode('-', $attributes->reconciliationDate);
$output['reconciliation_date'] = $reconciliationDate[2];
$output['reconciliation_month'] = $reconciliationDate[1];
$output['reconciliation_year'] = $reconciliationDate[0];
$confirmationDate = explode('-', $attributes->confirmationDate);
$output['confirmation_date'] = $confirmationDate[2];
$output['confirmation_month'] = $confirmationDate[1];
$output['confirmation_year'] = $confirmationDate[0];
$deliveryDate = explode('-', $attributes->deliveryDate);
$output['delivery_date'] = $deliveryDate[2];
$output['delivery_month'] = $deliveryDate[1];
$output['delivery_year'] = $deliveryDate[0];
}
return $output;
}
function showDebName($Err)
{
$output=array();
$query= new Bin_Query();
$query->executeQuery("SELECT debtorid
FROM invoice_api_data
WHERE api_data_id = '".$_GET['id']."' ");
$rec= $query->records[0];
$query->executeQuery("SELECT d.debtor_id, d.debtor_name, d.currency_id, currency_code, currency_code
FROM `debtor_relation` as r
LEFT JOIN `debtors_detail` as d ON d.debtor_id = r.debtor_id
LEFT JOIN currencies ON currencies.currency_id = d.currency_id
WHERE r.trader_id ='".$_SESSION['user']['userid']."' AND r.status IN ('1','5','6','7','8') AND d.parent_id != 0
ORDER BY d.debtor_name ASC ");
$debtor= $query->records;
$output['debName']='';
foreach ($debtor as $key => $value)
{
$selected= '';
if ((count($Err->values)>0 AND $value['debtor_id'] == $Err->values['debtor_id']) OR ($value['debtor_id'] == $rec['debtorid']))
{
$selected= 'selected="selected"';
$output['currency_id']= $value['currency_code'];
}
$output['debName'].= '<option '.$selected.' value="'.$value['debtor_id'].'" >'.$value['debtor_name'].'</option> ';
}
return $output;
}
function invoiceCurrency()
{
$query= new Bin_Query();
$query->executeQuery("SELECT currency_id
FROM debtors_detail
WHERE debtor_id = '".$_POST['curr_id']."' ");
$debtor = $query->records[0];
$query->executeQuery("SELECT currency_code
FROM currencies
WHERE currency_id = '".$debtor['currency_id']."' ");
$rec_con= $query->records[0];
exit($rec_con['currency_code']);
}
function updateEditInvoicedata()
{
$debtor_id = $_POST['debtor_id'];
$paymentterms = $_POST['paymentterms'];
$invoicevalue = $_POST['invoicevalue'];
$att['invoiceVat'] = $_POST['invoiceVat'];
$att['invoiceVatCategory'] = $_POST['invoiceVatCategory'];
$att['invoiceRebate'] = $_POST['invoiceRebate'];
$att['invoiceCarriage'] = $_POST['invoiceCarriage'];
$invoicediscount = $_POST['invoicediscount'];
$pono = $_POST['pono'];
$invoiceno = $_POST['invoiceno'];
$invoicefile = $_POST['invoicefile'];
$invoiceflag = $_POST['invoiceflag'];
$invoiceDate = $_POST['invoice_year']."-".$_POST['invoice_month']."-".$_POST['invoice_date'];
$purDate = $_POST['pur_year']."-".$_POST['pur_month']."-".$_POST['pur_date'];
$att['paymentNo'] = $_POST['paymentNo'];
$paymentDate = $_POST['payment_year']."-".$_POST['payment_month']."-".$_POST['payment_date'];
$att['orderNo'] = $_POST['orderNo'];
$att['orderDate'] = $_POST['order_year']."-".$_POST['order_month']."-".$_POST['order_date'];
$att['requisitionNo'] = $_POST['requisitionNo'];
$att['requestDate'] = $_POST['request_year']."-".$_POST['request_month']."-".$_POST['request_date'];
$att['receiveNo'] = $_POST['receiveNo'];
$att['receiveDate'] = $_POST['receive_year']."-".$_POST['receive_month']."-".$_POST['receive_date'];
$att['dispatchNo'] = $_POST['dispatchNo'];
$att['dispatchDate'] = $_POST['dispatch_year']."-".$_POST['dispatch_month']."-".$_POST['dispatch_date'];
$att['trackingNo'] = $_POST['trackingNo'];
$att['trackingDate'] = $_POST['tracking_year']."-".$_POST['tracking_month']."-".$_POST['tracking_date'];
$att['storageNo'] = $_POST['storageNo'];
$att['storageDate'] = $_POST['storage_year']."-".$_POST['storage_month']."-".$_POST['storage_date'];
$att['outboundNo'] = $_POST['outboundNo'];
$att['outboundDate'] = $_POST['outbound_year']."-".$_POST['outbound_month']."-".$_POST['outbound_date'];
$att['loggedNo'] = $_POST['loggedNo'];
$att['loggedDate'] = $_POST['logged_year']."-".$_POST['logged_month']."-".$_POST['logged_date'];
$att['bookedNo'] = $_POST['bookedNo'];
$att['bookedDate'] = $_POST['booked_year']."-".$_POST['booked_month']."-".$_POST['booked_date'];
$att['approvalNo'] = $_POST['approvalNo'];
$att['approvalDate'] = $_POST['approval_year']."-".$_POST['approval_month']."-".$_POST['approval_date'];
$att['authorisationNo'] = $_POST['authorisationNo'];
$att['authorisationDate'] = $_POST['authorisation_year']."-".$_POST['authorisation_month']."-".$_POST['authorisation_date'];
$att['reconciliationNo'] = $_POST['reconciliationNo'];
$att['reconciliationDate'] = $_POST['reconciliation_year']."-".$_POST['reconciliation_month']."-".$_POST['reconciliation_date'];
$att['confirmationNo'] = $_POST['confirmationNo'];
$att['confirmationDate'] = $_POST['confirmation_year']."-".$_POST['confirmation_month']."-".$_POST['confirmation_date'];
$att['deliveryNo'] = $_POST['deliveryNo'];
$att['deliveryDate'] = $_POST['delivery_year']."-".$_POST['delivery_month']."-".$_POST['delivery_date'];
$att['inboundNo'] = $_POST['inboundNo'];
$att['batchNo'] = $_POST['batchNo'];
$att['sequenceNo'] = $_POST['sequenceNo'];
$expectedDate = $_POST['expected_year']."-".$_POST['expected_month']."-".$_POST['expected_date'];
$user_id = $_SESSION['user']['userid'];
$attributes = json_encode($att);
$query= new Bin_Query();
if ($_FILES['file_invoice']['size'] > 0)
{
$invoicesFilePath="invoice/".date('Y').'/'.date('m').'/'.date('d').'/'.$invoiceno.'_'.time().'.pdf';
include_once ROOT_FOLDER.'/classes/Storage.php';
$storage = Storage_Repository::get(Storage_Repository::AUWS);
$storage->setFromUpload($invoicesFilePath,$_FILES['file_invoice']);
$query->updateQuery("UPDATE invoice_api_data
SET invoicepdf = '".$invoicesFilePath."'
WHERE api_data_id = '".(int)$_GET['id']."' ");
}
$query->updateQuery("UPDATE invoice_api_data SET ".
" debtorid = '".$debtor_id."', ".
" invoiceno= '".$invoiceno."', ".
" invoicedate= '".$invoiceDate."', ".
" invoicevalue= '".$invoicevalue."', ".
" paymentterms = '".$paymentterms."', ".
" invoicediscount= '".$invoicediscount."', ".
" pono = '".$pono."', ".
" purchasedate = '".$pur_date."', ".
" expectedDate = '".$expectedDate."', ".
" paymentdate = '".$paymentDate."', ".
" attributes = '".$attributes."' ".
" WHERE api_data_id = '".$_GET['id']."' ");
$_SESSION['success']= 'Updated Successfully!';
header('location:index.php?do=showinvoicedata');
exit;
}
function getFilename($id)
{
$query= new Bin_Query();
$query->executeQuery("SELECT api_data_id,invoicepdf
FROM invoice_api_data
WHERE api_data_id = '".$id."' ");
$result=$query->records;
// require('../include/vars.php');
// $result[0]['full_link']=$data_folder.$result[0]['invoicepdf'];
return $result;
}
function updateInvoice()
{
if (!isset($_POST['apiid']) OR count($_POST['apiid'])==0)
{
return FALSE;
}
include('classes/Model/MTrade.php');
include('classes/Model/MTradeFloor.php');
include('admin/classes/Model/MCOriginator.php');
//require_once ROOT_FOLDER.'/classes/Storage.php';
$c_originator = new Model_MCOriginator($_SESSION['user']['userid']);
$successful_invoices=0;
$query=new Bin_Query();
foreach($_POST['apiid'] as $api_id)
{
$query->executeQuery('SELECT *
FROM invoice_api_data
WHERE api_data_id='.$api_id);
$invoice=$query->records[0];
if (count($invoice)==0)
{
continue;
}
$query->executeQuery('SELECT invoice_id
FROM invoice_master
WHERE debtor_id='.$invoice['debtorid'].' AND revolving=1 AND root_invoice_id=0 AND user_id='.$_SESSION['user']['userid'].'
LIMIT 1');
$debtor=$query->records;
if (count($debtor)==0)
{
continue;
}
$_POST['debtor_id']=$debtor[0]['invoice_id'];
$invoice['expecteddate']=explode('-',$invoice['expecteddate']);
$_POST['ex_year']=$invoice['expecteddate'][0];
$_POST['ex_month']=$invoice['expecteddate'][1];
$_POST['ex_date']=$invoice['expecteddate'][2];
$invoice['invoicedate']=explode('-',$invoice['invoicedate']);
$_POST['invoice_year']=$invoice['invoicedate'][0];
$_POST['invoice_month']=$invoice['invoicedate'][1];
$_POST['invoice_date']=$invoice['invoicedate'][2];
$_POST['face_value']=$invoice['invoicevalue'];
$_POST['invoice_no']=$invoice['invoiceno'];
$_POST['payment']=$invoice['paymentterms'];
$_POST['debx']=0;
$_POST['po']='';
$r = $c_originator->check_limits($invoice['debtorid'], $_POST['face_value'] );
unset($_POST['save']);
if($r == Model_MCOriginator::TL_STOP )
{
$_POST['save'] = 1;
}
include_once ROOT_FOLDER.'/classes/Storage.php';
$auwsStorage = Storage_Repository::get(Storage_Repository::AUWS);
if($auwsStorage->exists($invoice['invoicepdf'])) {
$query->executeQuery(
"SELECT debtor_id, currency_id, debtor_name,contact_address_id,address_id,debtor_contact_first_name,debtor_contact_last_name, `type`
FROM `debtors_detail`
where debtor_id='".$_POST['debtor_id']."'
limit 1"
);
$debtor = $query->records[0];
$invoiceStorage = Storage_Repository::etrByType($debtor['type']);
if ($debtor['type'] == TYPE_CREDITOR) {
$file_name = Model_MTrade::generateAttachmentLocationCreditor(
$_SESSION['user']['org_ref_id'],
'file_invoice',
'pdf',
$_SESSION['user']['userid']
);
} else {
$file_name = Model_MTrade::generateAttachmentLocationDebtor(
$_SESSION['user']['org_ref_id'],
'file_invoice',
'pdf',
$_SESSION['user']['userid']
);
}
//echo $invoice['invoicepdf'].'+';
//echo $file_name;
$tmpFile = tempnam(sys_get_temp_dir(),'invoice');
$auwsStorage->get($invoice['invoicepdf'], $tmpFile);
$invoiceStorage->set($file_name, $tmpFile,true);
unlink($tmpFile);
$auwsStorage->delete($invoice['invoicepdf']);
$_POST['invoicefile'] = trim($file_name);
}
/**
* require('../include/vars.php');
$invoice_file=self::generateAttachmentLocation($_SESSION['user']['org_ref_id'],'file_invoice',pathinfo($invoice['invoicepdf'],PATHINFO_EXTENSION),$_SESSION['user']['userid']);
Storage_Repository::get(Storage_Repository::AUWS)->get($invoice['invoicepdf'],DEBX_LOCATION.$invoice_file);
Storage_Repository::get(Storage_Repository::AUWS)->set($invoice_file,DEBX_LOCATION.$invoice_file,TRUE);
$_POST['invoicefile']=trim($invoice_file,'.');
*/
if (Model_MTrade::saveRevolvingTrade('revolvingtrade', $r))
{
$successful_invoices++;
}
$query->updateQuery('DELETE FROM invoice_api_data WHERE api_data_id='.$api_id);
}
$_SESSION['success']=(count($_POST['apiid'])==$successful_invoices)?'All invoices were successfully processed':'Some of invoices were not successfully processed. Check "Post Saved ETR"';
}
function showInvoicequeue()
{
$query= new Bin_Query();
$query->executeQuery("SELECT api_data_id, debtorid, invoiceclassification, invoicepdf, invoicevalue, DATE(created_at) as created_at , debtor_reference_id, debtor_name,currency_code
FROM invoice_api_data
LEFT JOIN debtors_detail ON debtors_detail.debtor_id = invoice_api_data.debtorid
LEFT JOIN currencies ON currencies.currency_id = debtors_detail.currency_id
WHERE originatorid = '".$_SESSION['user']['userid']."' AND status=1");
return Display_DCredentials::showInvoicequeue($query->records);
}
}
?>