function print_purchases_cost()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$destination = $_POST['PARAM_2'];
$orientation = $_POST['PARAM_3'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$dec = user_price_dec();
if ($category == ALL_NUMERIC) {
$category = 0;
}
if ($category == 0) {
$cat = _('All');
} else {
$cat = get_category_name($category);
}
$cols = array(0, 20, 55, 85, 125, 200, 230, 260, 290, 325, 350, 375, 425, 475);
//14 headers + 1 lagi dapat for cols
//todo: format date paid to 2 digits representation only i.e. 12/12/12
$headers = array(_('CV#'), _('Date Paid'), _('OR #'), _('Supplier'), _('Title of Book'), _('Quantity'), _('Unit Cost'), _('Amount'), _('With Tax'), _('Net'), _('PO #'), _('Stock Supplied'), _('Stock Amount'), _('Total Amount'));
//todo: Date Paid, OR(official receipt number) Amount, w/tax, net, Stock supplied, stock amount and total amount
// Possible tables to read on: grn_batch and grn_items
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left');
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Category'), 'from' => $cat, 'to' => ''));
$rep = new FrontReport(_('Summary of Purchases at Cost Report'), "SummaryPurchasesCostReport", user_pagesize(), 8, 'L');
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($from, $to);
$total = $grandtotal = 0.0;
$total1 = $grandtotal1 = 0.0;
$total2 = $grandtotal2 = 0.0;
$catt = '';
while ($trans = db_fetch($res)) {
$rep->NewLine();
$rep->fontSize -= 2;
$rep->TextCol(3, 4, $trans['supp_name']);
$rep->TextCol(4, 5, $trans['description']);
$rep->AmountCol(5, 6, $trans['quantity_ordered']);
$rep->AmountCol(6, 7, $trans['unit_price']);
$rep->AmountCol(10, 11, $trans['order_no']);
}
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, _('Total'));
$rep->AmountCol(4, 5, $total, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine(2, 1);
$rep->TextCol(0, 4, _('Grand Total'));
$rep->AmountCol(4, 5, $grandtotal, $dec);
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
function print_work_order_listing()
{
global $path_to_root, $wo_types_array;
$item = $_POST['PARAM_0'];
$location = $_POST['PARAM_1'];
$open_only = $_POST['PARAM_2'];
$comments = $_POST['PARAM_3'];
$orientation = $_POST['PARAM_4'];
$destination = $_POST['PARAM_5'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
if ($item == '') {
$items = _('All');
} else {
$row = get_item($item);
$items = $row['description'];
}
if ($location == '') {
$loc = _('All');
} else {
$loc = get_location_name($location);
}
$open = $open_only == 1 ? _('Yes') : _('No');
$cols = array(0, 100, 120, 165, 210, 275, 315, 375, 385, 440, 495, 555);
$headers = array(_('Type'), '#', 'Reference', _('Location'), _('Item'), _('Required'), _('Manufactured'), ' ', _('Date'), _('Required By'), _('Closed'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right', 'left', 'left', 'left', 'left');
$params = array(0 => $comments, 1 => array('text' => _('Items'), 'from' => $items, 'to' => ''), 2 => array('text' => _('Location'), 'from' => $loc, 'to' => ''), 3 => array('text' => _('Open Only'), 'from' => $open, 'to' => ''));
$rep = new FrontReport(_('Work Order Listing'), "WorkOrderListing", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($item, $open_only, $location);
while ($trans = db_fetch($res)) {
$rep->TextCol(0, 1, $wo_types_array[$trans['type']]);
$rep->TextCol(1, 2, $trans['id'], -1);
$rep->TextCol(2, 3, $trans['wo_ref'], -1);
$rep->TextCol(3, 4, $trans['location_name'], -1);
$rep->TextCol(4, 5, $trans['description'], -1);
$dec = get_qty_dec($trans['stock_id']);
$rep->AmountCol(5, 6, $trans['units_reqd'], $dec);
$rep->AmountCol(6, 7, $trans['units_issued'], $dec);
$rep->TextCol(7, 8, '', -1);
$rep->TextCol(8, 9, sql2date($trans['date_']), -1);
$rep->TextCol(9, 10, sql2date($trans['required_by']), -1);
$rep->TextCol(10, 11, $trans['closed'] ? ' ' : _('No'), -1);
$rep->NewLine();
}
$rep->Line($rep->row);
$rep->End();
}
function print_audit_trail()
{
global $path_to_root, $systypes_array;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$systype = $_POST['PARAM_2'];
$user = $_POST['PARAM_3'];
$comments = $_POST['PARAM_4'];
$orientation = $_POST['PARAM_5'];
$destination = $_POST['PARAM_6'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$cols = array(0, 60, 120, 180, 240, 340, 400, 460, 520);
$headers = array(_('Date'), _('Time'), _('User'), _('Trans Date'), _('Type'), _('#'), _('Action'), _('Amount'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'left', 'right');
$usr = get_user($user);
$user_id = $usr['user_id'];
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Type'), 'from' => $systype != -1 ? $systypes_array[$systype] : _('All'), 'to' => ''), 3 => array('text' => _('User'), 'from' => $user != -1 ? $user_id : _('All'), 'to' => ''));
$rep = new FrontReport(_('Audit Trail'), "AuditTrail", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$trans = getTransactions($from, $to, $systype, $user);
while ($myrow = db_fetch($trans)) {
$rep->TextCol(0, 1, sql2date(date("Y-m-d", $myrow['unix_stamp'])));
if (user_date_format() == 0) {
$rep->TextCol(1, 2, date("h:i:s a", $myrow['unix_stamp']));
} else {
$rep->TextCol(1, 2, date("H:i:s", $myrow['unix_stamp']));
}
$rep->TextCol(2, 3, $myrow['user_id']);
$rep->TextCol(3, 4, sql2date($myrow['gl_date']));
$rep->TextCol(4, 5, $systypes_array[$myrow['type']]);
$rep->TextCol(5, 6, $myrow['trans_no']);
if ($myrow['gl_seq'] == null) {
$action = _('Changed');
} else {
$action = _('Closed');
}
$rep->TextCol(6, 7, $action);
if ($myrow['amount'] != null) {
$rep->AmountCol(7, 8, $myrow['amount'], $dec);
}
$rep->NewLine(1, 2);
}
$rep->Line($rep->row + 4);
$rep->End();
}
function print_bill_of_material()
{
global $path_to_root;
$frompart = $_POST['PARAM_0'];
$topart = $_POST['PARAM_1'];
$comments = $_POST['PARAM_2'];
$orientation = $_POST['PARAM_3'];
$destination = $_POST['PARAM_4'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$cols = array(0, 50, 305, 375, 445, 515);
$headers = array(_('Component'), _('Description'), _('Loc'), _('Wrk Ctr'), _('Quantity'));
$aligns = array('left', 'left', 'left', 'left', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Component'), 'from' => $frompart, 'to' => $topart));
$rep = new FrontReport(_('Bill of Material Listing'), "BillOfMaterial", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($frompart, $topart);
$parent = '';
while ($trans = db_fetch($res)) {
if ($parent != $trans['parent']) {
if ($parent != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 1, $trans['parent']);
$desc = get_item($trans['parent']);
$rep->TextCol(1, 2, $desc['description']);
$parent = $trans['parent'];
$rep->NewLine();
}
$rep->NewLine();
$dec = get_qty_dec($trans['component']);
$rep->TextCol(0, 1, $trans['component']);
$rep->TextCol(1, 2, $trans['CompDescription']);
//$rep->TextCol(2, 3, $trans['loc_code']);
//$rep->TextCol(3, 4, $trans['workcentre_added']);
$wc = get_work_centre($trans['workcentre_added']);
$rep->TextCol(2, 3, get_location_name($trans['loc_code']));
$rep->TextCol(3, 4, $wc['name']);
$rep->AmountCol(4, 5, $trans['quantity'], $dec);
}
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
function print_dimension_summary()
{
global $path_to_root;
$fromdim = $_POST['PARAM_0'];
$todim = $_POST['PARAM_1'];
$showbal = $_POST['PARAM_2'];
$comments = $_POST['PARAM_3'];
$orientation = $_POST['PARAM_4'];
$destination = $_POST['PARAM_5'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$cols = array(0, 50, 210, 250, 320, 395, 465, 515);
$headers = array(_('Reference'), _('Name'), _('Type'), _('Date'), _('Due Date'), _('Closed'), _('YTD'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Dimension'), 'from' => get_dimension_string($fromdim), 'to' => get_dimension_string($todim)));
$rep = new FrontReport(_('Dimension Summary'), "DimensionSummary", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($fromdim, $todim);
while ($trans = db_fetch($res)) {
$rep->TextCol(0, 1, $trans['reference']);
$rep->TextCol(1, 2, $trans['name']);
$rep->TextCol(2, 3, $trans['type_']);
$rep->DateCol(3, 4, $trans['date_'], true);
$rep->DateCol(4, 5, $trans['due_date'], true);
if ($trans['closed']) {
$str = _('Yes');
} else {
$str = _('No');
}
$rep->TextCol(5, 6, $str);
if ($showbal) {
$balance = getYTD($trans['id']);
$rep->AmountCol(6, 7, $balance, 0);
}
$rep->NewLine(1, 2);
}
$rep->Line($rep->row);
$rep->End();
}
function print_assets_list()
{
global $path_to_root;
$frompart = $_POST['PARAM_0'];
$topart = $_POST['PARAM_1'];
$comments = $_POST['PARAM_2'];
$destination = $_POST['PARAM_3'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$cols = array(0, 50, 305, 375, 445, 515);
$headers = array(_('Asset Type'), _('Asset name'), _('Serial Number'), _('Purchase Date'), _('Purchase Value'));
$aligns = array('left', 'left', 'left', 'left', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Component'), 'from' => $frompart, 'to' => $topart));
$rep = new FrontReport(_('Assets Listing'), "AssetList", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($frompart, $topart);
$parent = '';
while ($trans = db_fetch($res)) {
if ($parent != $trans['asset_type_name']) {
if ($parent != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 2, $trans['asset_type_name']);
$desc = get_item($trans['asset_type_name']);
$parent = $trans['asset_type_name'];
$rep->NewLine();
}
$rep->NewLine();
$dec = get_qty_dec($trans['asset_id']);
$rep->TextCol(0, 1, $trans['asset_type_name']);
$rep->TextCol(1, 2, $trans['asset_name']);
$rep->TextCol(2, 3, $trans['asset_serial']);
$rep->TextCol(3, 4, $trans['purchase_date']);
$rep->AmountCol(4, 5, $trans['purchase_value'], $dec);
}
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
function print_bill_of_material()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$frompart = $_REQUEST['PARAM_0'];
$topart = $_REQUEST['PARAM_1'];
$comments = $_REQUEST['PARAM_2'];
$dec = user_qty_dec();
$cols = array(0, 50, 305, 375, 445, 515);
$headers = array(tr('Component'), tr('Description'), tr('Loc'), tr('Wrk Ctr'), tr('Quantity'));
$aligns = array('left', 'left', 'left', 'left', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Component'), 'from' => $frompart, 'to' => $topart));
$rep = new FrontReport(tr('Bill of Material Listing'), "BillOfMaterial.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
$res = getTransactions($frompart, $topart);
$parent = '';
while ($trans = db_fetch($res)) {
if ($parent != $trans['parent']) {
if ($parent != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 1, $trans['parent']);
$desc = get_item($trans['parent']);
$rep->TextCol(1, 2, $desc['description']);
$parent = $trans['parent'];
$rep->NewLine();
}
$rep->NewLine();
$rep->TextCol(0, 1, $trans['component']);
$rep->TextCol(1, 2, $trans['CompDescription']);
$rep->TextCol(2, 3, $trans['loc_code']);
$rep->TextCol(3, 4, $trans['workcentre_added']);
$rep->TextCol(4, 5, number_format2($trans['quantity'], $dec));
}
$rep->Line($rep->row - 4);
$rep->End();
}
function print_dimension_summary()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$fromdim = $_REQUEST['PARAM_0'];
$todim = $_REQUEST['PARAM_1'];
$showbal = $_REQUEST['PARAM_2'];
$comments = $_REQUEST['PARAM_3'];
$cols = array(0, 50, 210, 250, 320, 395, 465, 515);
$headers = array(tr('Reference'), tr('Name'), tr('Type'), tr('Date'), tr('Due Date'), tr('Closed'), tr('YTD'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Dimension'), 'from' => $fromdim, 'to' => $todim));
$rep = new FrontReport(tr('Dimension Summary'), "DimensionSummary.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
$res = getTransactions($fromdim, $todim);
while ($trans = db_fetch($res)) {
$rep->TextCol(0, 1, $trans['reference']);
$rep->TextCol(1, 2, $trans['name']);
$rep->TextCol(2, 3, $trans['type_']);
$rep->TextCol(3, 4, $trans['date_']);
$rep->TextCol(4, 5, $trans['due_date']);
if ($trans['closed']) {
$str = tr('Yes');
} else {
$str = tr('No');
}
$rep->TextCol(5, 6, $str);
if ($showbal) {
$balance = getYTD($trans['id']);
$rep->TextCol(6, 7, number_format2($balance, 0));
}
$rep->NewLine(1, 2);
}
$rep->Line($rep->row);
$rep->End();
}
function showTransactions()
{
// Global Fun!
global $DB;
global $MySelf;
// Are we allowed to do this?
if (!$MySelf->isAccountant()) {
makeNotice("You are not an accountant to your corporation. Access denied.", "error", "Access denied");
}
if (isset($_GET['auth'])) {
$auth = true;
} else {
$auth = false;
}
// Sanity check.
numericCheck($_GET['id'], 0);
$username = idToUsername($_GET['id']);
$id = $_GET['id'];
// Load the transaction log.
$account = $auth ? "'s TEST Auth" : "";
$page = "<h2>Transaction log for " . ucfirst($username) . "{$account}</h2>";
$users = $DB->query("select id, username from users where ((authID in (select authID from users where id = '{$id}') and '{$auth}' = 1) or id = '{$id}')");
while ($user = $users->fetchRow()) {
$userid = $user['id'];
$username = $user['username'];
$trans = getTransactions($userid);
if (!$trans) {
$page .= "<b>There are no transactions for {$username}.</b>";
} else {
$page .= $trans;
}
$page .= "<br>";
}
// Add the backlink.
$page .= "<br><a href=\"index.php?action=payout\">Back to Payouts</a>";
// Return the page.
return $page;
}
function manageWallet()
{
// Globals
global $MySelf;
global $DB;
$MyCredits = getCredits($MySelf->getID());
// Get (recent?) transactions
$html = getTransactions($MySelf->getID());
if ($MyCredits > 0) {
// Create the dropdown menu with all pilots.
$NamesDS = $DB->query("SELECT DISTINCT username, id FROM users WHERE deleted='0' ORDER BY username");
$ddm = "<select name=\"to\">";
while ($name = $NamesDS->fetchRow()) {
// Lets not allow transfers to self.
if ($name[id] != $MySelf->getID()) {
$ddm .= "<option value=\"" . $name[id] . "\">" . ucfirst($name[username]) . "</option>";
}
}
$ddm .= "</select>";
$tt = new table(2, true);
$tt->addHeader(">> Transfer ISK");
$tt->addRow("#060622");
$tt->addCol("You can transfer ISK into another Pilots wallet by using this form.", array("colspan" => 2));
$tt->addRow();
$tt->addCol("Transfer from:");
$tt->addCol(ucfirst($MySelf->getUsername()));
$tt->addRow();
$tt->addCol("Transfer to:");
$tt->addCol($ddm);
$tt->addRow();
$tt->addCol("Amount:");
$tt->addCol("<input type=\"text\" name=\"amount\">");
$tt->addRow();
$tt->addCol("Reason:");
$tt->addCol("<input type=\"text\" name=\"reason\">");
$tt->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"Transfer money\">");
// Create form stuff, and embed the table within.
$transfer = "<form action=\"index.php\" method=\"POST\">";
$transfer .= $tt->flush();
$transfer .= "<input type=\"hidden\" name=\"check\" value=\"true\">";
$transfer .= "<input type=\"hidden\" name=\"action\" value=\"transferMoney\">";
$transfer .= "</form>";
// Create the payout form.
$payout = new table(2, true);
$payout->addHeader(">> Request payout");
$payout->addRow("#060622");
$payout->addCol("Fill out this form to request payout of ISK. An accountant will honor your request soon.", array("colspan" => 2));
$payout->addRow();
$payout->addCol("Payout amount:");
$payout->addCol("<input type=\"text\" name=\"amount\" value=\"" . $MyCredits . "\"> ISK");
$payout->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"request payout\">");
// Create form stuff, and embed the table within.
$requestPayout = "<form action=\"index.php\" method=\"POST\">";
$requestPayout .= $payout->flush();
$requestPayout .= "<input type=\"hidden\" name=\"check\" value=\"true\">";
$requestPayout .= "<input type=\"hidden\" name=\"action\" value=\"requestPayout\">";
$requestPayout .= "</form>";
}
/*
* Show current requests
*/
$requests = $DB->query("SELECT * FROM payoutRequests WHERE payoutTime IS NULL AND applicant='" . $MySelf->getID() . "' ORDER BY time");
$table = new table(4, true);
$table->addHeader(">> Pending payout requests");
$table->addRow("#060622");
$table->addCol("request");
$table->addCol("time");
$table->addCol("amount");
$table->addCol("Cancel");
while ($request = $requests->fetchRow()) {
$table->addRow();
$table->addCol("#" . str_pad($request[request], "5", "0", STR_PAD_LEFT));
$table->addCol(date("d.m.y H:i:s", $request[time]));
$table->addCol(number_format($request[amount], 2) . " ISK");
$table->addCol("<input type=\"checkbox\" name=\"" . $request[request] . "\" value=\"true\">");
$haveRequest = true;
}
$table->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"cancel marked requests\">");
$takeBack = "<form action=\"index.php\" method=\"POST\">";
$takeBack .= "<input type=\"hidden\" name=\"check\" value=\"true\">";
$takeBack .= "<input type=\"hidden\" name=\"action\" value=\"deleteRequest\">";
$takeBack .= $table->flush();
$rakeBack .= "</form>";
/*
* Show fulfilled requests
*/
$requests = $DB->query("SELECT * FROM payoutRequests WHERE payoutTime IS NOT NULL AND applicant='" . $MySelf->getID() . "' ORDER BY time");
$table_done = new table(5, true);
$table_done->addHeader(">> Fulfilled payout requests");
$table_done->addRow("#060622");
$table_done->addCol("request");
$table_done->addCol("time");
$table_done->addCol("amount");
$table_done->addCol("Payout time");
$table_done->addCol("Paid by");
while ($request = $requests->fetchRow()) {
$table_done->addRow();
$table_done->addCol("#" . str_pad($request[request], "5", "0", STR_PAD_LEFT));
$table_done->addCol(date("d.m.y H:i:s", $request[time]));
$table_done->addCol(number_format($request[amount], 2) . " ISK");
$table_done->addCol(date("d.m.y H:i:s", $request[payoutTime]));
$table_done->addCol(ucfirst(idToUsername($request[banker])));
$haveOldRequests = true;
}
if ($html) {
$html = "<h2>Your Wallet</h2>" . $html . "<br>" . $requestPayout . $transfer;
if ($haveRequest) {
$html .= $takeBack . "<br>";
}
if ($haveOldRequests) {
$html .= $table_done->flush();
}
} else {
$html = "<h2>Your Wallet</h2>Once your wallet has any transactions you can view the details here. And once you obtained a positive balance you can transfer money and request payouts.<br>";
}
return $html;
}
function print_inventory_planning()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$category = $_REQUEST['PARAM_0'];
$location = $_REQUEST['PARAM_1'];
$comments = $_REQUEST['PARAM_2'];
$dec = user_qty_dec();
if ($category == reserved_words::get_all_numeric()) {
$category = 0;
}
if ($category == 0) {
$cat = tr('All');
} else {
$cat = get_category_name($category);
}
if ($location == reserved_words::get_all()) {
$location = 'all';
}
if ($location == 'all') {
$loc = tr('All');
} else {
$loc = $location;
}
$cols = array(0, 50, 150, 180, 210, 240, 270, 300, 330, 390, 435, 480, 525);
$per0 = strftime('%b', mktime(0, 0, 0, date('m'), date('d'), date('Y')));
$per1 = strftime('%b', mktime(0, 0, 0, date('m') - 1, date('d'), date('Y')));
$per2 = strftime('%b', mktime(0, 0, 0, date('m') - 2, date('d'), date('Y')));
$per3 = strftime('%b', mktime(0, 0, 0, date('m') - 3, date('d'), date('Y')));
$per4 = strftime('%b', mktime(0, 0, 0, date('m') - 4, date('d'), date('Y')));
$headers = array(tr('Category'), '', $per4, $per3, $per2, $per1, $per0, '3*M', tr('QOH'), tr('Cust Ord'), tr('Supp Ord'), tr('Sugg Ord'));
$aligns = array('left', 'left', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Category'), 'from' => $cat, 'to' => ''), 2 => array('text' => tr('Location'), 'from' => $loc, 'to' => ''));
$rep = new FrontReport(tr('Inventory Planning Report'), "InventoryPlanning.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
$res = getTransactions($category, $location);
$catt = '';
while ($trans = db_fetch($res)) {
if ($catt != $trans['cat_description']) {
if ($catt != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 2, $trans['cat_description']);
$catt = $trans['cat_description'];
$rep->NewLine();
}
$custqty = getCustQty($trans['stock_id'], $trans['loc_code']);
$custqty += getCustAsmQty($trans['stock_id'], $trans['loc_code']);
$suppqty = getSuppQty($trans['stock_id'], $trans['loc_code']);
$period = getPeriods($trans['stock_id'], $trans['loc_code']);
$rep->NewLine();
$rep->TextCol(0, 1, $trans['stock_id']);
$rep->TextCol(1, 2, $trans['description']);
$rep->TextCol(2, 3, number_format2($period['prd0'], $dec));
$rep->TextCol(3, 4, number_format2($period['prd1'], $dec));
$rep->TextCol(4, 5, number_format2($period['prd2'], $dec));
$rep->TextCol(5, 6, number_format2($period['prd3'], $dec));
$rep->TextCol(6, 7, number_format2($period['prd4'], $dec));
$MaxMthSales = Max($period['prd0'], $period['prd1'], $period['prd2'], $period['prd3']);
$IdealStockHolding = $MaxMthSales * 3;
$rep->TextCol(7, 8, number_format2($IdealStockHolding, $dec));
$rep->TextCol(8, 9, number_format2($trans['qty_on_hand'], $dec));
$rep->TextCol(9, 10, number_format2($custqty, $dec));
$rep->TextCol(10, 11, number_format2($suppqty, $dec));
$SuggestedTopUpOrder = $IdealStockHolding - $trans['qty_on_hand'] + $custqty - $suppqty;
if ($SuggestedTopUpOrder < 0.0) {
$SuggestedTopUpOrder = 0.0;
}
$rep->TextCol(11, 12, number_format2($SuggestedTopUpOrder, $dec));
}
$rep->Line($rep->row - 4);
$rep->End();
}
$filter = (isset($_GET['filter']) and $_GET['filter']) ? $_GET['filter'] : 'all';
$today = time();
$day_start = date('Y-m-d ') . '00:00:00';
$day_end = date('Y-m-d ') . "23:59:59";
foreach ($temp as $ag) {
$sched_from = $ag['g_schedFrom'];
$sched_to = $ag['g_schedTo'];
if (!$ag['g_isClosed'] and !$ag['g_isCancelled'] and !$ag['g_isDeleted'] or $today >= $sched_from and $today <= $sched_to or $ag['g_isClosed'] and $ag['g_lastUpdated'] >= $day_start and $ag['g_lastUpdated'] <= $day_end or $ag['g_isCancelled'] and $ag['g_lastUpdated'] >= $day_start and $ag['g_lastUpdated'] <= $day_end) {
// cancelled today
$all_games[$ag['g_id']] = $ag;
//$all_bets = getAllBets($ag['g_id']);
//$info_per_bet_item = getInfoPerBetItem($all_bets);
//$all_games[$ag['g_id']]['info_per_bet_item'] = $info_per_bet_item;
}
}
$transactions_today = getTransactions(strtotime($day_start), strtotime($day_end));
// get today's sales
foreach ($transactions_today as $td) {
$sales_today += $td['tr_amount'];
}
$user_registrations = getUserRegistrations($day_start, $day_end);
$total_registrations = count($user_registrations);
// get today's house commission
$house_commissions = getHouseCommissions(strtotime($day_start), strtotime($day_end));
foreach ($house_commissions as $hc) {
$total_house_commission += $hc['cd_amount'];
// coins
}
$total_house_commission = $total_house_commission ? $total_house_commission / $config['currency_unit'] : 0;
?>
<!DOCTYPE html>
<?php
session_start();
if (!(isset($_SESSION['wojiaonixue_internal_login_status']) and $_SESSION['wojiaonixue_internal_login_status'] == 'active')) {
header("Location:login.html");
exit;
}
header('Access-Control-Allow-Origin:*');
require_once "config.php";
require_once "processUtil.php";
require_once "globalData.php";
$codeParser = new CodeParser();
$conn = new mysqli($host, $user, $password, $database);
if ($_GET && $_GET["requestMethod"]) {
$requestMethod = trim($_GET["requestMethod"]);
if ($requestMethod == "getTransactions") {
echo getTransactions($conn);
} else {
if ($requestMethod == "getTransactionsByStatus") {
getTransactionsByStatus($conn);
} else {
if ($requestMethod == "myRecord") {
getMyRecord($conn);
} else {
if ($requestMethod == "updateFollowStatus") {
updateFollowStatus($conn, $appid, $secret);
} else {
if ($requestMethod == "manualCreateTransaction") {
manualCreateTransaction();
}
}
}
function print_statements()
{
global $path_to_root, $systypes_array;
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
$customer = $_POST['PARAM_0'];
$currency = $_POST['PARAM_1'];
$show_also_allocated = $_POST['PARAM_2'];
$email = $_POST['PARAM_3'];
$comments = $_POST['PARAM_4'];
$orientation = $_POST['PARAM_5'];
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$cols = array(4, 100, 130, 190, 250, 320, 385, 450, 515);
//$headers in doctext.inc
$aligns = array('left', 'left', 'left', 'left', 'right', 'right', 'right', 'right');
$params = array('comments' => $comments);
$cur = get_company_pref('curr_default');
$PastDueDays1 = get_company_pref('past_due_days');
$PastDueDays2 = 2 * $PastDueDays1;
if ($email == 0) {
$rep = new FrontReport(_('STATEMENT'), "StatementBulk", user_pagesize(), 9, $orientation);
}
if ($orientation == 'L') {
recalculate_cols($cols);
}
$sql = "SELECT debtor_no, name AS DebtorName, address, tax_id, curr_code, curdate() AS tran_date FROM " . TB_PREF . "debtors_master";
if ($customer != ALL_TEXT) {
$sql .= " WHERE debtor_no = " . db_escape($customer);
} else {
$sql .= " ORDER by name";
}
$result = db_query($sql, "The customers could not be retrieved");
while ($myrow = db_fetch($result)) {
$date = date('Y-m-d');
$myrow['order_'] = "";
$TransResult = getTransactions($myrow['debtor_no'], $date, $show_also_allocated);
$baccount = get_default_bank_account($myrow['curr_code']);
$params['bankaccount'] = $baccount['id'];
if (db_num_rows($TransResult) == 0) {
continue;
}
if ($email == 1) {
$rep = new FrontReport("", "", user_pagesize(), 9, $orientation);
$rep->title = _('STATEMENT');
$rep->filename = "Statement" . $myrow['debtor_no'] . ".pdf";
$rep->Info($params, $cols, null, $aligns);
}
$contacts = get_customer_contacts($myrow['debtor_no'], 'invoice');
$rep->SetHeaderType('Header2');
$rep->currency = $cur;
$rep->Font();
$rep->Info($params, $cols, null, $aligns);
//= get_branch_contacts($branch['branch_code'], 'invoice', $branch['debtor_no']);
$rep->SetCommonData($myrow, null, null, $baccount, ST_STATEMENT, $contacts);
$rep->NewPage();
$rep->NewLine();
$doctype = ST_STATEMENT;
$rep->fontSize += 2;
$rep->TextCol(0, 8, _("Outstanding Transactions"));
$rep->fontSize -= 2;
$rep->NewLine(2);
while ($myrow2 = db_fetch($TransResult)) {
$DisplayTotal = number_format2(Abs($myrow2["TotalAmount"]), $dec);
$DisplayAlloc = number_format2($myrow2["Allocated"], $dec);
$DisplayNet = number_format2($myrow2["TotalAmount"] - $myrow2["Allocated"], $dec);
$rep->TextCol(0, 1, $systypes_array[$myrow2['type']], -2);
$rep->TextCol(1, 2, $myrow2['reference'], -2);
$rep->TextCol(2, 3, sql2date($myrow2['tran_date']), -2);
if ($myrow2['type'] == ST_SALESINVOICE) {
$rep->TextCol(3, 4, sql2date($myrow2['due_date']), -2);
}
if ($myrow2['type'] == ST_SALESINVOICE || $myrow2['type'] == ST_BANKPAYMENT) {
$rep->TextCol(4, 5, $DisplayTotal, -2);
} else {
$rep->TextCol(5, 6, $DisplayTotal, -2);
}
$rep->TextCol(6, 7, $DisplayAlloc, -2);
$rep->TextCol(7, 8, $DisplayNet, -2);
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + 10 * $rep->lineHeight) {
$rep->NewPage();
}
}
$nowdue = "1-" . $PastDueDays1 . " " . _("Days");
$pastdue1 = $PastDueDays1 + 1 . "-" . $PastDueDays2 . " " . _("Days");
$pastdue2 = _("Over") . " " . $PastDueDays2 . " " . _("Days");
$CustomerRecord = get_customer_details($myrow['debtor_no'], null, $show_also_allocated);
$str = array(_("Current"), $nowdue, $pastdue1, $pastdue2, _("Total Balance"));
$str2 = array(number_format2($CustomerRecord["Balance"] - $CustomerRecord["Due"], $dec), number_format2($CustomerRecord["Due"] - $CustomerRecord["Overdue1"], $dec), number_format2($CustomerRecord["Overdue1"] - $CustomerRecord["Overdue2"], $dec), number_format2($CustomerRecord["Overdue2"], $dec), number_format2($CustomerRecord["Balance"], $dec));
$col = array($rep->cols[0], $rep->cols[0] + 110, $rep->cols[0] + 210, $rep->cols[0] + 310, $rep->cols[0] + 410, $rep->cols[0] + 510);
$rep->row = $rep->bottomMargin + (10 * $rep->lineHeight - 6);
for ($i = 0; $i < 5; $i++) {
$rep->TextWrap($col[$i], $rep->row, $col[$i + 1] - $col[$i], $str[$i], 'right');
}
$rep->NewLine();
for ($i = 0; $i < 5; $i++) {
$rep->TextWrap($col[$i], $rep->row, $col[$i + 1] - $col[$i], $str2[$i], 'right');
}
if ($email == 1) {
$rep->End($email, _("Statement") . " " . _("as of") . " " . sql2date($date));
}
}
if ($email == 0) {
$rep->End();
}
}
function print_inventory_valuation_report()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$category = $_REQUEST['PARAM_0'];
$location = $_REQUEST['PARAM_1'];
$detail = $_REQUEST['PARAM_2'];
$comments = $_REQUEST['PARAM_3'];
$dec = user_price_dec();
if ($category == reserved_words::get_all_numeric()) {
$category = 0;
}
if ($category == 0) {
$cat = tr('All');
} else {
$cat = get_category_name($category);
}
if ($location == reserved_words::get_all()) {
$location = 'all';
}
if ($location == 'all') {
$loc = tr('All');
} else {
$loc = $location;
}
$cols = array(0, 100, 250, 350, 450, 515);
$headers = array(tr('Category'), '', tr('Quantity'), tr('Unit Cost'), tr('Value'));
$aligns = array('left', 'left', 'right', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Category'), 'from' => $cat, 'to' => ''), 2 => array('text' => tr('Location'), 'from' => $loc, 'to' => ''));
$rep = new FrontReport(tr('Inventory Valuation Report'), "InventoryValReport.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
$res = getTransactions($category, $location);
$total = $grandtotal = 0.0;
$catt = '';
while ($trans = db_fetch($res)) {
if ($catt != $trans['cat_description']) {
if ($catt != '') {
if ($detail) {
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, tr('Total'));
}
$rep->Textcol(4, 5, number_format2($total, $dec));
if ($detail) {
$rep->Line($rep->row - 2);
$rep->NewLine();
}
$rep->NewLine();
$total = 0.0;
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 2, $trans['cat_description']);
$catt = $trans['cat_description'];
if ($detail) {
$rep->NewLine();
}
}
if ($detail) {
$rep->NewLine();
$rep->fontsize -= 2;
$rep->TextCol(0, 1, $trans['stock_id']);
$rep->TextCol(1, 2, $trans['description']);
$rep->TextCol(2, 3, number_format2($trans['QtyOnHand'], user_qty_dec()));
$rep->TextCol(3, 4, number_format2($trans['UnitCost'], $dec));
$rep->TextCol(4, 5, number_format2($trans['ItemTotal'], $dec));
$rep->fontsize += 2;
}
$total += $trans['ItemTotal'];
$grandtotal += $trans['ItemTotal'];
}
if ($detail) {
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, tr('Total'));
}
$rep->Textcol(4, 5, number_format2($total, $dec));
if ($detail) {
$rep->Line($rep->row - 2);
$rep->NewLine();
}
$rep->NewLine(2, 1);
$rep->TextCol(0, 4, tr('Grand Total'));
$rep->TextCol(4, 5, number_format2($grandtotal, $dec));
$rep->Line($rep->row - 4);
$rep->End();
}
function print_purchases_cost()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$destination = $_POST['PARAM_1'];
$orientation = $_POST['PARAM_2'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$dec = user_price_dec();
if ($category == ALL_NUMERIC) {
$category = 0;
}
if ($category == 0) {
$cat = _('All');
} else {
$cat = get_category_name($category);
}
$cols = array(0, 50, 100, 150, 200, 250, 300, 350);
$headers = array(_('Invoice'), _('Client Name'), _('IMC'), _('Charge'), _('Sales'), _('Date of'));
//$header2 = array(_('Date'), '', '', _('Invoice'), _('Amount'), _('Credit Memo'), _('Memo No.'), _(' Return'), _('%'), _('%'), _('Sales'), _('Provisional Receipt'), _('Receipt No.'), _('Payment'), _('Remittance'), _('Commission'), _('Percentage'), '', _('W/holding Tax'), _('Commission'));
$aligns = array('left', 'left', 'left', 'left');
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Category'), 'from' => $cat, 'to' => ''));
$rep = new FrontReport(_('Summary of Purchases at Cost Report'), "SummaryPurchasesCostReport", user_pagesize(), 8, 'L');
$rep->Font();
$rep->Info($params, $cols, $header2, $aligns);
$rep->NewPage();
$res = getTransactions($category, $from, $to);
$total = $grandtotal = 0.0;
$total1 = $grandtotal1 = 0.0;
$total2 = $grandtotal2 = 0.0;
$catt = '';
while ($trans = db_fetch($res)) {
if ($catt != $trans['cat_description']) {
if ($catt != '') {
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, _('Total'));
$rep->AmountCol(4, 5, $total, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine();
$total = $total1 = $total2 = 0.0;
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 7, $trans['cat_description']);
$catt = $trans['cat_description'];
$rep->NewLine();
}
$rep->NewLine();
$rep->fontSize -= 2;
$rep->TextCol(0, 1, $trans['stock_id']);
$rep->TextCol(1, 2, $trans['description']);
$rep->AmountCol(2, 3, $trans['quantity'], get_qty_dec($trans['stock_id']));
$rep->AmountCol(3, 4, $trans['unit_price'], $dec);
$rep->AmountCol(4, 5, $trans['quantity'] * $trans['unit_price'], $dec);
if ($trans['unit_price'] == 0) {
$rep->TextCol(6, 7, _('Gift'));
}
$rep->fontSize += 2;
$total += $trans['quantity'] * $trans['unit_price'];
$grandtotal += $trans['quantity'] * $trans['unit_price'];
}
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, _('Total'));
$rep->AmountCol(4, 5, $total, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine(2, 1);
$rep->TextCol(0, 4, _('Grand Total'));
$rep->AmountCol(4, 5, $grandtotal, $dec);
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
function print_stock_check()
{
global $path_to_root, $pic_height;
$category = $_POST['PARAM_0'];
$location = $_POST['PARAM_1'];
$pictures = $_POST['PARAM_2'];
$check = $_POST['PARAM_3'];
$shortage = $_POST['PARAM_4'];
$no_zeros = $_POST['PARAM_5'];
$like = $_POST['PARAM_6'];
$comments = $_POST['PARAM_7'];
$orientation = $_POST['PARAM_8'];
$destination = $_POST['PARAM_9'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
if ($category == ALL_NUMERIC) {
$category = 0;
}
if ($category == 0) {
$cat = _('All');
} else {
$cat = get_category_name($category);
}
if ($location == ALL_TEXT) {
$location = 'all';
}
if ($location == 'all') {
$loc = _('All');
} else {
$loc = get_location_name($location);
}
if ($shortage) {
$short = _('Yes');
$available = _('Shortage');
} else {
$short = _('No');
$available = _('Available');
}
if ($no_zeros) {
$nozeros = _('Yes');
} else {
$nozeros = _('No');
}
if ($check) {
$cols = array(0, 75, 225, 250, 295, 345, 390, 445, 515);
$headers = array(_('Stock ID'), _('Description'), _('UOM'), _('Quantity'), _('Check'), _('Demand'), $available, _('On Order'));
$aligns = array('left', 'left', 'left', 'right', 'right', 'right', 'right', 'right');
} else {
$cols = array(0, 75, 225, 250, 315, 380, 445, 515);
$headers = array(_('Stock ID'), _('Description'), _('UOM'), _('Quantity'), _('Demand'), $available, _('On Order'));
$aligns = array('left', 'left', 'left', 'right', 'right', 'right', 'right');
}
$params = array(0 => $comments, 1 => array('text' => _('Category'), 'from' => $cat, 'to' => ''), 2 => array('text' => _('Location'), 'from' => $loc, 'to' => ''), 3 => array('text' => _('Only Shortage'), 'from' => $short, 'to' => ''), 4 => array('text' => _('Suppress Zeros'), 'from' => $nozeros, 'to' => ''));
if ($pictures) {
$user_comp = user_company();
} else {
$user_comp = "";
}
$rep = new FrontReport(_('Stock Check Sheets'), "StockCheckSheet", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($category, $location, $like);
$catt = '';
while ($trans = db_fetch($res)) {
if ($location == 'all') {
$loc_code = "";
} else {
$loc_code = $location;
}
$demandqty = get_demand_qty($trans['stock_id'], $loc_code);
$demandqty += get_demand_asm_qty($trans['stock_id'], $loc_code);
$onorder = get_on_porder_qty($trans['stock_id'], $loc_code);
$flag = get_mb_flag($trans['stock_id']);
if ($flag == 'M') {
$onorder += get_on_worder_qty($trans['stock_id'], $loc_code);
}
if ($no_zeros && $trans['QtyOnHand'] == 0 && $demandqty == 0 && $onorder == 0) {
continue;
}
if ($shortage && $trans['QtyOnHand'] - $demandqty >= 0) {
continue;
}
if ($catt != $trans['cat_description']) {
if ($catt != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 2, $trans['cat_description']);
$catt = $trans['cat_description'];
$rep->NewLine();
}
$rep->NewLine();
$dec = get_qty_dec($trans['stock_id']);
$rep->TextCol(0, 1, $trans['stock_id']);
$rep->TextCol(1, 2, $trans['description'] . ($trans['inactive'] == 1 ? " (" . _("Inactive") . ")" : ""), -1);
$rep->TextCol(2, 3, $trans['units']);
$rep->AmountCol(3, 4, $trans['QtyOnHand'], $dec);
if ($check) {
$rep->TextCol(4, 5, "_________");
$rep->AmountCol(5, 6, $demandqty, $dec);
$rep->AmountCol(6, 7, $trans['QtyOnHand'] - $demandqty, $dec);
$rep->AmountCol(7, 8, $onorder, $dec);
} else {
$rep->AmountCol(4, 5, $demandqty, $dec);
$rep->AmountCol(5, 6, $trans['QtyOnHand'] - $demandqty, $dec);
$rep->AmountCol(6, 7, $onorder, $dec);
}
if ($pictures) {
$image = company_path() . '/images/' . item_img_name($trans['stock_id']) . '.jpg';
if (file_exists($image)) {
$rep->NewLine();
if ($rep->row - $pic_height < $rep->bottomMargin) {
$rep->NewPage();
}
$rep->AddImage($image, $rep->cols[1], $rep->row - $pic_height, 0, $pic_height);
$rep->row -= $pic_height;
$rep->NewLine();
}
}
}
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
function print_inventory_sales()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$destination = $_POST['PARAM_1'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$dec = user_price_dec();
if ($category == ALL_NUMERIC) {
$category = 0;
}
if ($category == 0) {
$cat = _('All');
} else {
$cat = get_category_name($category);
}
$cols = array(0, 50, 100, 150, 200, 250, 300, 350, 400, 450, 500, 550, 600, 650, 700, 750, 800, 850, 900, 950, 1000, 1050, 1100, 1150, 1200);
$headers = array(_('Date'), _('Client Name'), _('IMC'), _('Charge'), _('Sales'), _('Date'), _('CM#'), _('Returns'), _(''), _('Discount'), _('Balance'), _('Date'), _('PR/OR#'), _('Date'), _('OR #'), _('Partial'), _('Net'), _('Balance'), _('Date'), _(''), _('Commission'), _('w/tax'), _('Net Commission'));
$header2 = array(_(''), '', '', _('Invoice'), _('Amount'), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), '', _(''), _(''));
$aligns = array('left', 'center', 'center', 'center', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Category'), 'from' => $cat, 'to' => ''));
$rep = new FrontReport(_('Series Report'), "Series Report", user_pagesize(), 8, 'L');
$rep->Font();
$rep->Info($params, $cols, $header2, $aligns, $cols, $headers, $aligns);
$rep->NewPage();
$total = $grandtotal = 0.0;
$total1 = $grandtotal1 = 0.0;
$total2 = $grandtotal2 = 0.0;
$catt = '';
$res = getTransactions($imc, $from);
while ($myrow = db_fetch($res)) {
$company_data = get_company_prefs();
$branch = get_branch($myrow["branch_code"]);
$branch_data = get_branch_accounts($myrow['branch_code']);
$dt = get_discount($branch_data['sales_discount_account'], $myrow['type'], $myrow['trans_no']);
$salesman = get_imc_code($myrow['branch_code']);
$res2 = get_return_details($myrow['order_']);
$returns = 0;
$rtn_dt = 0;
while ($myrow2 = db_fetch($res2)) {
$returns += $myrow2['ov_amount'];
$credit_num = $myrow2['customized_no'];
$cm_date = $myrow2['tran_date'];
$res2 = get_return_discount($branch_data['sales_discount_account'], $myrow2['type'], $myrow2['trans_no']);
while ($myrow3 = db_fetch($res2)) {
$rtn_dt += abs($myrow3['amount']);
}
}
$total_returns = $returns + $rtn_dt;
$return_discount = $rtn_dt / $total_returns * 100;
$discount = $myrow['discount'];
$invoicetot = $myrow['ov_amount'] + $dt;
$sales_discount = ($invoicetot - $total_returns) * ($return_discount / 100);
$net_sales = $invoicetot - $total_returns - $sales_discount;
$gross_commission = ($invoicetot - $total_returns) * ($myrow['commission'] / 100);
$rep->TextCol(0, 1, $myrow['tran_date']);
$rep->TextCol(1, 2, $myrow['br_name']);
$rep->TextCol(2, 3, $salesman);
$rep->TextCol(3, 4, $myrow['customized_no']);
$rep->AmountCol(4, 5, $invoicetot, 2);
$rep->TextCol(5, 6, $cm_date);
$rep->TextCol(6, 7, $credit_num);
$rep->AmountCol(7, 8, $total_returns, 2);
$rep->TextCol(8, 9, $return_discount . "%");
$rep->AmountCol(9, 10, $sales_discount, 2);
$rep->AmountCol(10, 11, $net_sales, 2);
$rep->TextCol(18, 19, $myrow['date']);
$rep->TextCol(19, 20, $myrow['commission'] . "%");
$rep->AmountCol(20, 21, $gross_commission, 2);
$rep->AmountCol(21, 22, $myrow['with_tax'], 2);
$rep->AmountCol(22, 23, $myrow['net_commission'], 2);
$or = get_pr_details($myrow['type'], $myrow['trans_no']);
while ($pr = db_fetch($or)) {
$net_remittance = $net_sales - $pr['amt'];
$rep->TextCol(11, 12, $pr['date_alloc']);
$rep->TextCol(12, 13, $pr['customized_no']);
$rep->TextCol(13, 14, _("DATE"));
$rep->TextCol(14, 15, _("OR#"));
$rep->TextCol(15, 16, "");
$rep->AmountCol(17, 18, '', 2);
}
$rep->NewLine();
//
}
$rep->NewLine();
$rep->End();
}
<b><?php
echo $_SESSION['fullname'];
?>
</b><br/>
<?php
echo $accountInfo['sort_code'];
?>
</div>
</div>
</div>
<div class="row">
<div class="col-sm-12">
<?php
// get transactions
require_once 'transactions.php';
$transactions = getTransactions($_SESSION['accesstoken'], $_SESSION['account_number'], false, $api_root, $d_start->format('Y-m-d'), $d_end->format('Y-m-d'), false);
// init statistical variables
$totalspent = 0;
$totalin = 0;
$totalnet = 0;
// loop through the transactions
foreach ($transactions as $transaction) {
if ($transaction['amount'] < 0) {
$totalspent = $totalspent + $transaction['amount'];
} else {
$totalin = $totalin + $transaction['amount'];
}
$totalnet = $totalnet + $transaction['amount'];
}
?>
<h3>Balance Summary</h3>
function print_customer_details_listing()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$area = $_POST['PARAM_1'];
$folk = $_POST['PARAM_2'];
$more = $_POST['PARAM_3'];
$less = $_POST['PARAM_4'];
$comments = $_POST['PARAM_5'];
$orientation = $_POST['PARAM_6'];
$destination = $_POST['PARAM_7'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$dec = 0;
if ($area == ALL_NUMERIC) {
$area = 0;
}
if ($folk == ALL_NUMERIC) {
$folk = 0;
}
if ($area == 0) {
$sarea = _('All Areas');
} else {
$sarea = get_area_name($area);
}
if ($folk == 0) {
$salesfolk = _('All Sales Folk');
} else {
$salesfolk = get_salesman_name($folk);
}
if ($more != '') {
$morestr = _('Greater than ') . number_format2($more, $dec);
} else {
$morestr = '';
}
if ($less != '') {
$lessstr = _('Less than ') . number_format2($less, $dec);
} else {
$lessstr = '';
}
$more = (double) $more;
$less = (double) $less;
$cols = array(0, 150, 300, 425, 550);
$headers = array(_('Customer Postal Address'), _('Price/Turnover'), _('Branch Contact Information'), _('Branch Delivery Address'));
$aligns = array('left', 'left', 'left', 'left');
$params = array(0 => $comments, 1 => array('text' => _('Activity Since'), 'from' => $from, 'to' => ''), 2 => array('text' => _('Sales Areas'), 'from' => $sarea, 'to' => ''), 3 => array('text' => _('Sales Folk'), 'from' => $salesfolk, 'to' => ''), 4 => array('text' => _('Activity'), 'from' => $morestr, 'to' => $lessstr . " " . get_company_pref("curr_default")));
$rep = new FrontReport(_('Customer Details Listing'), "CustomerDetailsListing", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$result = get_customer_details_for_report($area, $folk);
$carea = '';
$sman = '';
while ($myrow = db_fetch($result)) {
$printcustomer = true;
if ($more != '' || $less != '') {
$turnover = getTransactions($myrow['debtor_no'], $myrow['branch_code'], $from);
if ($more != 0.0 && $turnover <= (double) $more) {
$printcustomer = false;
}
if ($less != 0.0 && $turnover >= (double) $less) {
$printcustomer = false;
}
}
if ($printcustomer) {
if ($carea != $myrow['description']) {
$rep->fontSize += 2;
$rep->NewLine(2, 7);
$rep->Font('bold');
$rep->TextCol(0, 3, _('Customers in') . " " . $myrow['description']);
$carea = $myrow['description'];
$rep->fontSize -= 2;
$rep->Font();
$rep->NewLine();
}
if ($sman != $myrow['salesman_name']) {
$rep->fontSize += 2;
$rep->NewLine(1, 7);
$rep->Font('bold');
$rep->TextCol(0, 3, $myrow['salesman_name']);
$sman = $myrow['salesman_name'];
$rep->fontSize -= 2;
$rep->Font();
$rep->NewLine();
}
$rep->NewLine();
// Here starts the new report lines 2010-11-02 Joe Hunt
$contacts = get_contacts_for_branch($myrow['branch_code']);
$rep->TextCol(0, 1, $myrow['name']);
$rep->TextCol(1, 2, _('Price List') . ": " . $myrow['sales_type']);
$rep->TextCol(2, 3, $myrow['br_name']);
$rep->NewLine();
$adr = Explode("\n", $myrow['address']);
if ($myrow['br_post_address'] == '') {
$adr2 = Explode("\n", $myrow['br_address']);
} else {
$adr2 = Explode("\n", $myrow['br_post_address']);
}
$count1 = count($adr);
$count2 = count($adr2);
$count1 = max($count1, $count2);
$count1 = max($count1, 4);
if (isset($adr[0])) {
$rep->TextCol(0, 1, $adr[0]);
}
$rep->TextCol(1, 2, _('Currency') . ": " . $myrow['curr_code']);
if (isset($contacts[0])) {
$rep->TextCol(2, 3, $contacts[0]['name'] . " " . $contacts[0]['name2']);
}
if (isset($adr2[0])) {
$rep->TextCol(3, 4, $adr2[0]);
}
$rep->NewLine();
if (isset($adr[1])) {
$rep->TextCol(0, 1, $adr[1]);
}
if ($myrow['dimension_id'] != 0) {
$dim = get_dimension($myrow['dimension_id']);
$rep->TextCol(1, 2, _('Dimension') . ": " . $dim['name']);
}
if (isset($contacts[0])) {
$rep->TextCol(2, 3, _('Ph') . ": " . $contacts[0]['phone']);
}
if (isset($adr2[1])) {
$rep->TextCol(3, 4, $adr2[1]);
}
$rep->NewLine();
if (isset($adr[2])) {
$rep->TextCol(0, 1, $adr[2]);
}
if ($myrow['dimension2_id'] != 0) {
$dim = get_dimension($myrow['dimension2_id']);
$rep->TextCol(1, 2, _('Dimension') . " 2: " . $dim['name']);
}
if (isset($contacts[0])) {
$rep->TextCol(2, 3, _('Fax') . ": " . $contacts[0]['fax']);
}
if (isset($adr2[2])) {
$rep->TextCol(3, 4, $adr2[2]);
}
if ($more != 0.0 || $less != 0.0) {
$rep->TextCol(1, 2, _('Turnover') . ": " . number_format2($turnover, $dec));
}
for ($i = 3; $i < $count1; $i++) {
$rep->NewLine();
if (isset($adr[$i])) {
$rep->TextCol(0, 1, $adr[$i]);
}
if ($i == 3 && isset($contacts[0]) && isset($contacts[0]['email'])) {
$rep->TextCol(2, 3, _('Email') . ": " . $contacts[0]['email']);
}
if (isset($adr2[$i])) {
$rep->TextCol(3, 4, $adr2[$i]);
}
}
$rep->NewLine();
/*
$rep->TextCol(0, 1, $myrow['name']);
$adr = Explode("\n", $myrow['address']);
$count1 = count($adr);
for ($i = 0; $i < $count1; $i++)
$rep->TextCol(0, 1, $adr[$i], 0, ($i + 1) * $rep->lineHeight);
$count1++;
$rep->TextCol(1, 2, _('Price List') . ": " . $myrow['sales_type']);
if ($more != 0.0 || $less != 0.0)
$rep->TextCol(1, 2, _('Turnover') . ": " . number_format2($turnover, $dec), 0, $rep->lineHeight);
$rep->TextCol(2, 3, $myrow['br_name']);
$contacts = get_branch_contacts($myrow['branch_code']);
if (isset($contacts[0]))
{
$rep->TextCol(2, 3, $contacts[0]['name'], 0, $rep->lineHeight);
$rep->TextCol(2, 3, _('Ph') . ": " . $contacts[0]['phone'], 0, 2 * $rep->lineHeight);
$rep->TextCol(2, 3, _('Fax') . ": " . $contacts[0]['fax'], 0, 3 * $rep->lineHeight);
}
$adr = Explode("\n", $myrow['br_address']);
$count2 = count($adr);
for ($i = 0; $i < $count2; $i++)
$rep->TextCol(3, 4, $adr[$i], 0, ($i + 1) * $rep->lineHeight);
//$rep->TextCol(3, 4, $myrow['email'], 0, ($count2 + 1) * $rep->lineHeight);
$count2++;
$count1 = Max($count1, $count2);
$count1 = Max($count1, 4);
$rep->NewLine($count3);
*/
$rep->Line($rep->row + 8);
$rep->NewLine(0, 3);
}
}
$rep->End();
}
function print_inventory_sales()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$category = $_POST['PARAM_2'];
$comments = $_POST['PARAM_3'];
$orientation = $_POST['PARAM_4'];
$destination = $_POST['PARAM_5'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
if ($category == ALL_NUMERIC) {
$category = 0;
}
if ($category == 0) {
$cat = _('All');
} else {
$cat = get_category_name($category);
}
$cols = array(0, 100, 260, 300, 350, 425, 430, 515);
$headers = array(_('Item/Category'), _('Description'), _('Qty'), _('Unit Price'), _('Sales'), '', _('Remark'));
$aligns = array('left', 'left', 'right', 'right', 'right', 'right', 'left');
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Category'), 'from' => $cat, 'to' => ''));
$rep = new FrontReport(_('Item Sales Summary Report'), "ItemSalesSummaryReport", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($category, $from, $to);
$total = $grandtotal = 0.0;
$total1 = $grandtotal1 = 0.0;
$total2 = $grandtotal2 = 0.0;
$catt = '';
while ($trans = db_fetch($res)) {
if ($catt != $trans['cat_description']) {
if ($catt != '') {
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, _('Total'));
$rep->AmountCol(4, 5, $total, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine();
$total = $total1 = $total2 = 0.0;
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 7, $trans['cat_description']);
$catt = $trans['cat_description'];
$rep->NewLine();
}
$rep->NewLine();
$rep->fontSize -= 2;
$rep->TextCol(0, 1, $trans['stock_id']);
$rep->TextCol(1, 2, $trans['description']);
$rep->AmountCol(2, 3, $trans['quantity'], get_qty_dec($trans['stock_id']));
$rep->AmountCol(3, 4, $trans['unit_price'], $dec);
$rep->AmountCol(4, 5, $trans['quantity'] * $trans['unit_price'], $dec);
if ($trans['unit_price'] == 0) {
$rep->TextCol(6, 7, _('Gift'));
}
$rep->fontSize += 2;
$total += $trans['quantity'] * $trans['unit_price'];
$grandtotal += $trans['quantity'] * $trans['unit_price'];
}
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, _('Total'));
$rep->AmountCol(4, 5, $total, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine(2, 1);
$rep->TextCol(0, 4, _('Grand Total'));
$rep->AmountCol(4, 5, $grandtotal, $dec);
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
function print_statements()
{
global $path_to_root, $systypes_array;
include_once $path_to_root . "/reporting/includes/pdf_report2.inc";
$from = date2sql($_POST['PARAM_0']);
$to = date2sql($_POST['PARAM_1']);
$customer = $_POST['PARAM_2'];
$currency = $_POST['PARAM_3'];
$email = $_POST['PARAM_4'];
$comments = $_POST['PARAM_5'];
$orientation = $_POST['PARAM_6'];
$orientation = $orientation ? 'L' : 'P';
$dec = 2;
$cols = array(4, 64, 180, 250, 300, 350, 400, 480);
//$headers in doctext.inc
$aligns = array('left', 'left', 'left', 'right', 'right', 'right', 'right', 'right');
$params = array('comments' => $comments);
$cur = get_company_pref('curr_default');
$PastDueDays1 = get_company_pref('past_due_days');
$PastDueDays2 = 2 * $PastDueDays1;
if ($email == 0) {
$rep = new FrontReport(_('CUSTOMER ACCOUNT STATEMENT'), "StatementBulk", user_pagesize(), 9, $orientation);
}
if ($orientation == 'L') {
recalculate_cols($cols);
}
$sql = "SELECT b.debtor_no, b.name AS DebtorName, b.address, b.tax_id, b.curr_code, cust.salesman, \n\tcurdate() AS tran_date, CONCAT (d.name, d.name2) AS contactPerson, d.phone, d.phone2 \n\tFROM " . TB_PREF . "debtors_master b INNER JOIN\n" . TB_PREF . "crm_contacts c on b.debtor_no=c.entity_id INNER JOIN " . TB_PREF . "crm_persons d on c.person_id=d.id\nINNER JOIN " . TB_PREF . "cust_branch cust on b.debtor_no=cust.debtor_no";
if ($customer != ALL_TEXT) {
$sql .= " WHERE c.type='customer' and cust.salesman = " . db_escape($customer);
} else {
$sql .= " where c.type='customer' and cust.salesman = " . db_escape($customer) . " ORDER by b.name";
}
$result = db_query($sql, "The customers could not be retrieved");
while ($debtor_row = db_fetch($result)) {
$date = date('Y-m-d');
if ($from != $to) {
// find the latest point where the balance was null
$start = findLatestNullDate($debtor_row['debtor_no'], $from);
// but not earlier than the $to date.
if (date1_greater_date2(sql2date($start), sql2date($to))) {
$start = $to;
}
if (date1_greater_date2(sql2date($from), sql2date($start))) {
$start = $from;
}
} else {
$start = $from;
}
$debtor_row['order_'] = "";
$TransResult = getTransactions($debtor_row['debtor_no'], $start, $date);
$baccount = get_default_bank_account($debtor_row['curr_code']);
$params['bankaccount'] = $baccount['id'];
if (db_num_rows($TransResult) == 0) {
continue;
}
if ($email == 1) {
$rep = new FrontReport("CUSTOMER ACCOUNT STATEMENT", "", user_pagesize(), 9, $orientation);
$rep->title = _('STATEMENT OF ACCOUNT');
$rep->filename = "Statement" . $debtor_row['debtor_no'] . ".pdf";
$rep->Info($params, $cols, null, $aligns);
}
$rep->filename = "ST-" . strtr($debtor_row['DebtorName'], " '", "__") . "--" . strtr(Today(), "/", "-") . ".pdf";
$contacts = get_customer_contacts($debtor_row['debtor_no'], 'invoice');
$rep->SetHeaderType('customheader');
$rep->currency = $cur;
$rep->Font();
$rep->Info(null, $cols, null, $aligns);
$rep->SetCommonData($debtor_row, null, null, $baccount, ST_STATEMENT, $contacts);
$rep->NewPage();
$doctype = ST_STATEMENT;
//$rep->TextCol(0,4,"yeah");
$current = false;
$balance = getInitialBalance($debtor_row['debtor_no'], $start);
if (true || Abs($balance) > 1.0E-6) {
if (Abs($balance) < 1.0E-6) {
$rep->SetTextColor(190, 190, 190);
} else {
if ($balance > 0) {
$rep->SetTextColor(190, 0, 0);
}
}
$rep->SetTextColor(0, 0, 0);
}
$overdue = 0;
$prev = '';
$gross_amount = 0;
$gross_amount2 = 0;
$payment_tot = 0;
$tots = 0;
$discount_amount = 0;
$percent = 0;
while ($transaction_row = db_fetch($TransResult)) {
if ($myrow['IsVoid'] == '') {
$company_data = get_company_prefs();
$branch = get_branch($transaction_row["branch_code"]);
$branch_data = get_branch_accounts($transaction_row['branch_code']);
$dt = get_discount($branch_data['sales_discount_account'], $transaction_row['type'], $transaction_row['trans_no']);
$DisplayTotal = number_format2(Abs($transaction_row["TotalAmount"] + $dt), $dec);
$DisplayAlloc = number_format2($transaction_row["Allocated"], $dec);
$DisplayNet = number_format2($transaction_row["TotalAmount"] - $transaction_row["Allocated"], $dec);
/*if ($dt != 0 && $transaction_row['type'] == ST_SALESINVOICE || $transaction_row['type'] == ST_CUSTCREDIT)
{
$discount_amount += $dt;
$ctr = $transaction_row['bulk_discount'];
}*/
$amount = $transaction_row["TotalAmount"] + $dt;
$balance += $transaction_row["TotalAmount"];
$invoice_no = get_custom_no($transaction_row['trans_no'], $transaction_row['type']);
$enter1 = 0;
if ($systypes_array[$transaction_row['type']] == "Customer Payment") {
$open_pay = get_payment_invoice_details($transaction_row["trans_no"], ST_CUSTPAYMENT);
if ($open_pay) {
$stat2 = false;
} else {
$stat2 = true;
$payment_tot += $amount;
$text = "pr#";
}
}
if ($systypes_array[$transaction_row['type']] == "Sales Invoice") {
if ($transaction_row['ov_amount'] > $transaction_row['alloc'] || $transaction_row['alloc'] == 0) {
$discount_amount += $dt;
$ctr = $transaction_row['bulk_discount'];
$gross_amount += $amount;
$text = '';
$stat3 = true;
} else {
$stat3 = false;
}
}
if ($systypes_array[$transaction_row['type']] == "Customer Credit Note") {
$open = get_sales_invoice_details($transaction_row['order_'], ST_SALESINVOICE);
if ($open) {
$stat = false;
} else {
$discount_amount += $dt;
$ctr = $transaction_row['bulk_discount'];
$gross_amount2 += $amount;
$stat = true;
}
$text = "cm#";
}
$current = $text;
$tot = $gross_amount + $gross_amount2 - $discount_amount;
if ($current != '') {
if ($prev == $current) {
} else {
if ($prev == "" && $text == "cm#" && $stat) {
$rep->NewLine();
$rep->TextCol(1, 2, "Less Returns");
$rep->NewLine();
}
if ($text == 'pr#' && $prev == "cm#" && $stat2) {
$rep->AmountCol(6, 7, $tot, 2);
$rep->NewLine(2);
$rep->TextCol(1, 2, "Less Payments:");
$rep->NewLine();
}
if ($prev == '' && $text == 'pr#' && $stat2) {
$rep->TextCol(1, 2, "Less Payments:");
$rep->NewLine();
}
}
$prev = $current;
}
if ($transaction_row['type'] == ST_SALESINVOICE && $stat3) {
$rep->TextCol(1, 2, $text . $invoice_no, -2);
$rep->TextCol(0, 3, sql2date($transaction_row['tran_date']), -2);
$rep->TextCol(3, 4, $DisplayTotal, -2);
$rep->NewLine();
}
if ($transaction_row['type'] == ST_CUSTCREDIT && $stat) {
$rep->TextCol(1, 2, $text . $invoice_no, -2);
$rep->TextCol(0, 3, sql2date($transaction_row['tran_date']), -2);
$rep->TextCol(3, 4, $DisplayTotal, -2);
$rep->NewLine();
}
if ($transaction_row['type'] == ST_CUSTPAYMENT && $stat2) {
if ($invoice_no == "") {
$rep->TextCol(1, 2, $text . $transaction_row['reference'], -2);
} else {
$rep->TextCol(1, 2, $text . $invoice_no, -2);
}
$rep->TextCol(0, 3, sql2date($transaction_row['tran_date']), -2);
$rep->TextCol(5, 6, $DisplayTotal, -2);
$rep->NewLine();
}
$rep->SetTextColor(0, 0, 0);
//$rep->NewLine();
if ($rep->row < $rep->bottomMargin + 10 * $rep->lineHeight) {
$rep->NewPage();
}
}
}
if (!$current) {
$overdue = $balance;
$balance = 0;
}
$rep->NewLine();
$net = $gross_amount - abs($gross_amount2);
$percent = $ctr / $net * 100;
$per = number_format2($percent, 2);
if ($per != 0) {
$rep->TextCol(1, 2, "Less " . $ctr . "% discount");
$rep->AmountCol(5, 6, $discount_amount, 2);
}
$rep->SetTextColor(0, 0, 0);
$rep->fontSize += 2;
$rep->NewLine(5);
$rep->TextCol(1, 2, 'Amount Due');
//$rep->TextCol(6,7, " ____________", -2);
if ($payment_tot != 0) {
$rep->TextCol(6, 7, number_format2($tot - abs($payment_tot), $dec));
} else {
$rep->AmountCol(6, 7, $tot, 2);
}
$rep->NewLine(5);
$rep->TextCol(2, 4, "Verified & Checked by:");
$rep->TextCol(4, 6, "___________________");
$rep->NewLine();
$rep->TextCol(4, 6, "Credit & Collection");
$rep->fontSize -= 2;
}
//$rep->NewPage();
if ($email == 0) {
$rep->End();
}
}
function print_inventory_purchase()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$category = $_POST['PARAM_2'];
$location = $_POST['PARAM_3'];
$fromsupp = $_POST['PARAM_4'];
$item = $_POST['PARAM_5'];
$comments = $_POST['PARAM_6'];
$orientation = $_POST['PARAM_7'];
$destination = $_POST['PARAM_8'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
if ($category == ALL_NUMERIC) {
$category = 0;
}
if ($category == 0) {
$cat = _('All');
} else {
$cat = get_category_name($category);
}
if ($location == '') {
$loc = _('All');
} else {
$loc = get_location_name($location);
}
if ($fromsupp == '') {
$froms = _('All');
} else {
$froms = get_supplier_name($fromsupp);
}
if ($item == '') {
$itm = _('All');
} else {
$itm = $item;
}
$cols = array(0, 60, 180, 225, 275, 400, 420, 465, 520);
$headers = array(_('Category'), _('Description'), _('Date'), _('#'), _('Supplier'), _('Qty'), _('Unit Price'), _('Total'));
if ($fromsupp != '') {
$headers[4] = '';
}
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Category'), 'from' => $cat, 'to' => ''), 3 => array('text' => _('Location'), 'from' => $loc, 'to' => ''), 4 => array('text' => _('Supplier'), 'from' => $froms, 'to' => ''), 5 => array('text' => _('Item'), 'from' => $itm, 'to' => ''));
$rep = new FrontReport(_('Inventory Purchasing Report'), "InventoryPurchasingReport", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($category, $location, $fromsupp, $item, $from, $to);
$total = $total_supp = $grandtotal = 0.0;
$total_qty = 0.0;
$catt = $stock_description = $stock_id = $supplier_name = '';
while ($trans = db_fetch($res)) {
if ($stock_description != $trans['description']) {
if ($stock_description != '') {
if ($supplier_name != '') {
$rep->NewLine(2, 3);
$rep->TextCol(0, 1, _('Total'));
$rep->TextCol(1, 4, $stock_description);
$rep->TextCol(4, 5, $supplier_name);
$rep->AmountCol(5, 7, $total_qty, get_qty_dec($stock_id));
$rep->AmountCol(7, 8, $total_supp, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$total_supp = $total_qty = 0.0;
$supplier_name = $trans['supplier_name'];
}
}
$stock_id = $trans['stock_id'];
$stock_description = $trans['description'];
}
if ($supplier_name != $trans['supplier_name']) {
if ($supplier_name != '') {
$rep->NewLine(2, 3);
$rep->TextCol(0, 1, _('Total'));
$rep->TextCol(1, 4, $stock_description);
$rep->TextCol(4, 5, $supplier_name);
$rep->AmountCol(5, 7, $total_qty, get_qty_dec($stock_id));
$rep->AmountCol(7, 8, $total_supp, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$total_supp = $total_qty = 0.0;
}
$supplier_name = $trans['supplier_name'];
}
if ($catt != $trans['cat_description']) {
if ($catt != '') {
$rep->NewLine(2, 3);
$rep->TextCol(0, 1, _('Total'));
$rep->TextCol(1, 7, $catt);
$rep->AmountCol(7, 8, $total, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine();
$total = 0.0;
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 6, $trans['cat_description']);
$catt = $trans['cat_description'];
$rep->NewLine();
}
$curr = get_supplier_currency($trans['supplier_id']);
$rate = get_exchange_rate_from_home_currency($curr, sql2date($trans['tran_date']));
$trans['price'] *= $rate;
$rep->NewLine();
$trans['supp_reference'] = get_supp_inv_reference($trans['supplier_id'], $trans['stock_id'], $trans['tran_date']);
$rep->fontSize -= 2;
$rep->TextCol(0, 1, $trans['stock_id']);
if ($fromsupp == ALL_TEXT) {
$rep->TextCol(1, 2, $trans['description'] . ($trans['inactive'] == 1 ? " (" . _("Inactive") . ")" : ""), -1);
$rep->TextCol(2, 3, sql2date($trans['tran_date']));
$rep->TextCol(3, 4, $trans['supp_reference']);
$rep->TextCol(4, 5, $trans['supplier_name']);
} else {
$rep->TextCol(1, 2, $trans['description'] . ($trans['inactive'] == 1 ? " (" . _("Inactive") . ")" : ""), -1);
$rep->TextCol(2, 3, sql2date($trans['tran_date']));
$rep->TextCol(3, 4, $trans['supp_reference']);
}
$rep->AmountCol(5, 6, $trans['qty'], get_qty_dec($trans['stock_id']));
$rep->AmountCol(6, 7, $trans['price'], $dec);
$amt = $trans['qty'] * $trans['price'];
$rep->AmountCol(7, 8, $amt, $dec);
$rep->fontSize += 2;
$total += $amt;
$total_supp += $amt;
$grandtotal += $amt;
$total_qty += $trans['qty'];
}
if ($stock_description != '') {
if ($supplier_name != '') {
$rep->NewLine(2, 3);
$rep->TextCol(0, 1, _('Total'));
$rep->TextCol(1, 4, $stock_description);
$rep->TextCol(4, 5, $supplier_name);
$rep->AmountCol(5, 7, $total_qty, get_qty_dec($stock_id));
$rep->AmountCol(7, 8, $total_supp, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine();
$total_supp = $total_qty = 0.0;
$supplier_name = $trans['supplier_name'];
}
}
if ($supplier_name != '') {
$rep->NewLine(2, 3);
$rep->TextCol(0, 1, _('Total'));
$rep->TextCol(1, 4, $stock_description);
$rep->TextCol(4, 5, $supplier_name);
$rep->AmountCol(5, 7, $total_qty, get_qty_dec($stock_id));
$rep->AmountCol(7, 8, $total_supp, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine();
}
$rep->NewLine(2, 3);
$rep->TextCol(0, 1, _('Total'));
$rep->TextCol(1, 7, $catt);
$rep->AmountCol(7, 8, $total, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine(2, 1);
$rep->TextCol(0, 7, _('Grand Total'));
$rep->AmountCol(7, 8, $grandtotal, $dec);
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
function print_grn_valuation()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$comments = $_POST['PARAM_2'];
$orientation = $_POST['PARAM_3'];
$destination = $_POST['PARAM_4'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$cols = array(0, 75, 225, 260, 295, 330, 370, 410, 455, 515);
$headers = array(_('Stock ID'), _('Description'), _('PO No'), _('GRN') . "#", _('Inv') . "#", _('Qty'), _('Inv Price'), _('PO Price'), _('Total'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to));
$rep = new FrontReport(_('GRN Valuation Report'), "GRNValuationReport", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($from, $to);
$total = $qtotal = $grandtotal = 0.0;
$stock_id = '';
while ($trans = db_fetch($res)) {
if ($stock_id != $trans['item_code']) {
if ($stock_id != '') {
$rep->Line($rep->row - 4);
$rep->NewLine(2);
$rep->TextCol(0, 3, _('Total'));
$rep->AmountCol(5, 6, $qtotal, $qdec);
$rep->AmountCol(8, 9, $total, $dec);
$rep->NewLine();
$total = $qtotal = 0;
}
$stock_id = $trans['item_code'];
}
$curr = get_supplier_currency($trans['supplier_id']);
$rate = get_exchange_rate_from_home_currency($curr, sql2date($trans['delivery_date']));
$trans['std_cost_unit'] *= $rate;
$rep->NewLine();
$rep->TextCol(0, 1, $trans['item_code']);
$rep->TextCol(1, 2, $trans['description']);
$rep->TextCol(2, 3, $trans['order_no']);
$qdec = get_qty_dec($trans['item_code']);
$rep->TextCol(3, 4, $trans['batch_no']);
if ($trans['quantity_inv']) {
$suppinv = getSuppInvDetails($trans['grn_item_id']);
while ($inv = db_fetch($suppinv)) {
$inv['inv_price'] *= $rate;
$rep->TextCol(4, 5, $inv['inv_no']);
$rep->AmountCol(5, 6, $inv['inv_qty'], $qdec);
$rep->AmountCol(6, 7, $inv['inv_price'], $dec);
$rep->AmountCol(7, 8, $trans['std_cost_unit'], $dec);
$amt = round2($inv['inv_qty'] * $inv['inv_price'], $dec);
$rep->AmountCol(8, 9, $amt, $dec);
$rep->NewLine();
$total += $amt;
$qtotal += $inv['inv_qty'];
$grandtotal += $amt;
}
}
if ($trans['qty_recd'] - $trans['quantity_inv'] != 0) {
$rep->TextCol(4, 5, "--");
$rep->AmountCol(5, 6, $trans['qty_recd'] - $trans['quantity_inv'], $qdec);
$rep->AmountCol(7, 8, $trans['unit_price'], $dec);
$amt = round2(($trans['qty_recd'] - $trans['quantity_inv']) * $trans['unit_price'], $dec);
$rep->AmountCol(8, 9, $amt, $dec);
$total += $amt;
$qtotal += $trans['qty_recd'] - $trans['quantity_inv'];
$grandtotal += $amt;
} else {
$rep->NewLine(-1);
}
}
if ($stock_id != '') {
$rep->Line($rep->row - 4);
$rep->NewLine(2);
$rep->TextCol(0, 3, _('Total'));
$rep->AmountCol(5, 6, $qtotal, $qdec);
$rep->AmountCol(8, 9, $total, $dec);
$rep->Line($rep->row - 4);
$rep->NewLine(2);
$rep->TextCol(0, 7, _('Grand Total'));
$rep->AmountCol(8, 9, $grandtotal, $dec);
}
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
function print_inventory_planning()
{
global $path_to_root;
$category = $_POST['PARAM_0'];
$location = $_POST['PARAM_1'];
$comments = $_POST['PARAM_2'];
$orientation = $_POST['PARAM_3'];
$destination = $_POST['PARAM_4'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
if ($category == ALL_NUMERIC) {
$category = 0;
}
if ($category == 0) {
$cat = _('All');
} else {
$cat = get_category_name($category);
}
if ($location == ALL_TEXT) {
$location = 'all';
}
if ($location == 'all') {
$loc = _('All');
} else {
$loc = get_location_name($location);
}
$cols = array(0, 50, 150, 180, 210, 240, 270, 300, 330, 390, 435, 480, 525);
$per0 = strftime('%b', mktime(0, 0, 0, date('m'), 1, date('Y')));
$per1 = strftime('%b', mktime(0, 0, 0, date('m') - 1, 1, date('Y')));
$per2 = strftime('%b', mktime(0, 0, 0, date('m') - 2, 1, date('Y')));
$per3 = strftime('%b', mktime(0, 0, 0, date('m') - 3, 1, date('Y')));
$per4 = strftime('%b', mktime(0, 0, 0, date('m') - 4, 1, date('Y')));
$headers = array(_('Category'), '', $per4, $per3, $per2, $per1, $per0, '3*M', _('QOH'), _('Cust Ord'), _('Supp Ord'), _('Sugg Ord'));
$aligns = array('left', 'left', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Category'), 'from' => $cat, 'to' => ''), 2 => array('text' => _('Location'), 'from' => $loc, 'to' => ''));
$rep = new FrontReport(_('Inventory Planning Report'), "InventoryPlanning", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($category, $location);
$catt = '';
while ($trans = db_fetch($res)) {
if ($catt != $trans['cat_description']) {
if ($catt != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 2, $trans['cat_description']);
$catt = $trans['cat_description'];
$rep->NewLine();
}
if ($location == 'all') {
$loc_code = "";
} else {
$loc_code = $location;
}
$custqty = get_demand_qty($trans['stock_id'], $loc_code);
$custqty += get_demand_asm_qty($trans['stock_id'], $loc_code);
$suppqty = get_on_porder_qty($trans['stock_id'], $loc_code);
$suppqty += get_on_worder_qty($trans['stock_id'], $loc_code);
$period = getPeriods($trans['stock_id'], $trans['loc_code']);
$rep->NewLine();
$dec = get_qty_dec($trans['stock_id']);
$rep->TextCol(0, 1, $trans['stock_id']);
$rep->TextCol(1, 2, $trans['description'] . ($trans['inactive'] == 1 ? " (" . _("Inactive") . ")" : ""), -1);
$rep->AmountCol(2, 3, $period['prd0'], $dec);
$rep->AmountCol(3, 4, $period['prd1'], $dec);
$rep->AmountCol(4, 5, $period['prd2'], $dec);
$rep->AmountCol(5, 6, $period['prd3'], $dec);
$rep->AmountCol(6, 7, $period['prd4'], $dec);
$MaxMthSales = Max($period['prd0'], $period['prd1'], $period['prd2'], $period['prd3']);
$IdealStockHolding = $MaxMthSales * 3;
$rep->AmountCol(7, 8, $IdealStockHolding, $dec);
$rep->AmountCol(8, 9, $trans['qty_on_hand'], $dec);
$rep->AmountCol(9, 10, $custqty, $dec);
$rep->AmountCol(10, 11, $suppqty, $dec);
$SuggestedTopUpOrder = $IdealStockHolding - $trans['qty_on_hand'] + $custqty - $suppqty;
if ($SuggestedTopUpOrder < 0.0) {
$SuggestedTopUpOrder = 0.0;
}
$rep->AmountCol(11, 12, $SuggestedTopUpOrder, $dec);
}
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
function print_inventory_sales()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$category = $_POST['PARAM_2'];
$location = $_POST['PARAM_3'];
$fromcust = $_POST['PARAM_4'];
$comments = $_POST['PARAM_5'];
$orientation = $_POST['PARAM_6'];
$destination = $_POST['PARAM_7'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
if ($category == ALL_NUMERIC) {
$category = 0;
}
if ($category == 0) {
$cat = _('All');
} else {
$cat = get_category_name($category);
}
if ($location == '') {
$loc = _('All');
} else {
$loc = get_location_name($location);
}
if ($fromcust == '') {
$fromc = _('All');
} else {
$fromc = get_customer_name($fromcust);
}
$cols = array(0, 75, 175, 250, 300, 375, 450, 515);
$headers = array(_('Category'), _('Description'), _('Customer'), _('Qty'), _('Sales'), _('Cost'), _('Contribution'));
if ($fromcust != '') {
$headers[2] = '';
}
$aligns = array('left', 'left', 'left', 'right', 'right', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Category'), 'from' => $cat, 'to' => ''), 3 => array('text' => _('Location'), 'from' => $loc, 'to' => ''), 4 => array('text' => _('Customer'), 'from' => $fromc, 'to' => ''));
$rep = new FrontReport(_('Inventory Sales Report'), "InventorySalesReport", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($category, $location, $fromcust, $from, $to);
$total = $grandtotal = 0.0;
$total1 = $grandtotal1 = 0.0;
$total2 = $grandtotal2 = 0.0;
$catt = '';
while ($trans = db_fetch($res)) {
if ($catt != $trans['cat_description']) {
if ($catt != '') {
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, _('Total'));
$rep->AmountCol(4, 5, $total, $dec);
$rep->AmountCol(5, 6, $total1, $dec);
$rep->AmountCol(6, 7, $total2, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine();
$total = $total1 = $total2 = 0.0;
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 6, $trans['cat_description']);
$catt = $trans['cat_description'];
$rep->NewLine();
}
$curr = get_customer_currency($trans['debtor_no']);
$rate = get_exchange_rate_from_home_currency($curr, sql2date($trans['tran_date']));
$trans['amt'] *= $rate;
$cb = $trans['amt'] - $trans['cost'];
$rep->NewLine();
$rep->fontSize -= 2;
$rep->TextCol(0, 1, $trans['stock_id']);
if ($fromcust == ALL_TEXT) {
$rep->TextCol(1, 2, $trans['description'] . ($trans['inactive'] == 1 ? " (" . _("Inactive") . ")" : ""), -1);
$rep->TextCol(2, 3, $trans['debtor_name']);
} else {
$rep->TextCol(1, 3, $trans['description'] . ($trans['inactive'] == 1 ? " (" . _("Inactive") . ")" : ""), -1);
}
$rep->AmountCol(3, 4, $trans['qty'], get_qty_dec($trans['stock_id']));
$rep->AmountCol(4, 5, $trans['amt'], $dec);
$rep->AmountCol(5, 6, $trans['cost'], $dec);
$rep->AmountCol(6, 7, $cb, $dec);
$rep->fontSize += 2;
$total += $trans['amt'];
$total1 += $trans['cost'];
$total2 += $cb;
$grandtotal += $trans['amt'];
$grandtotal1 += $trans['cost'];
$grandtotal2 += $cb;
}
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, _('Total'));
$rep->AmountCol(4, 5, $total, $dec);
$rep->AmountCol(5, 6, $total1, $dec);
$rep->AmountCol(6, 7, $total2, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine(2, 1);
$rep->TextCol(0, 4, _('Grand Total'));
$rep->AmountCol(4, 5, $grandtotal, $dec);
$rep->AmountCol(5, 6, $grandtotal1, $dec);
$rep->AmountCol(6, 7, $grandtotal2, $dec);
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
function print_inventory_sales()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$destination = $_POST['PARAM_1'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$dec = user_price_dec();
if ($category == ALL_NUMERIC) {
$category = 0;
}
if ($category == 0) {
$cat = _('All');
} else {
$cat = get_category_name($category);
}
$cols = array(0, 50, 100, 150, 200, 250, 300, 350, 400, 450, 500, 550, 600, 650, 700, 750, 800, 850, 900, 950, 1000, 1050, 1100, 1150, 1200);
$headers = array(_('Date'), _('Client Name'), _('IMC'), _('Charge'), _('Sales'), _('Date'), _('CM#'), _('Returns'), _(''), _('Discount'), _('Balance'), _('Date'), _('PR/OR#'), _('Date'), _('OR #'), _('Amount'), _('Partial'), _('Balance'), _('Date'), _(''), _('Commission'), _('w/tax'), _('Net Commission'));
$header2 = array(_(''), '', '', _('Invoice'), _('Amount'), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), _(''), '', _(''), _(''));
$aligns = array('left', 'center', 'center', 'center', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Category'), 'from' => $cat, 'to' => ''));
$rep = new FrontReport(_('Series Report'), "SeriesReport", user_pagesize(), 8, 'L');
$rep->Font();
$rep->Info($params, $cols, $header2, $aligns, $cols, $headers, $aligns);
$rep->NewPage();
$total = $grandtotal = 0.0;
$total1 = $grandtotal1 = 0.0;
$total2 = $grandtotal2 = 0.0;
$catt = '';
$res = getTransactions($imc, $from);
while ($myrow = db_fetch($res)) {
$company_data = get_company_prefs();
$branch = get_branch($myrow["branch_code"]);
$branch_data = get_branch_accounts($myrow['branch_code']);
$dt = get_discount($branch_data['sales_discount_account'], $myrow['type'], $myrow['trans_no']);
$salesman = get_imc_code($myrow['branch_code']);
$res2 = get_return_details($myrow['order_']);
$returns = 0;
$rtn_dt = 0;
$credit_num = "";
$cm_date = "";
$num = db_num_rows($res2);
$var = array();
while ($myrow2 = db_fetch($res2)) {
$returns += $myrow2['ov_amount'];
if ($num > 1) {
$credit_num .= $myrow2['customized_no'] . "/";
$cm_date = $myrow2['tran_date'] . "/";
} else {
$credit_num .= $myrow2['customized_no'];
$cm_date = $myrow2['tran_date'];
}
$var = array($myrow2['trans_no']);
//$res2 = get_return_discount($branch_data['sales_discount_account'], $myrow2['type'], $myrow2['trans_no']);
// while ($myrow3 = db_fetch($res2)){
// $rtn_dt += abs($myrow3['amount']);
// }
}
foreach ($var as $vars) {
$res2 = get_return_discount($branch_data['sales_discount_account'], ST_CUSTCREDIT, $vars);
while ($myrow3 = db_fetch($res2)) {
$rtn_dt += abs($myrow3['amount']);
}
}
$total_returns = $returns + $rtn_dt;
$return_discount = $rtn_dt / $total_returns * 100;
//$discount = $myrow['discount'];
$invoicetot = $myrow['ov_amount'] + $dt;
$invoice_discount = $dt / $invoicetot * 100;
$sales_discount = ($invoicetot - $total_returns) * ($invoice_discount / 100);
$net_sales = $invoicetot - $total_returns - $sales_discount;
$gross_commission = ($invoicetot - $total_returns) * ($myrow['commission'] / 100);
$tot_invoice = $invoicetot - $invoicetot * ($invoice_discount / 100);
$sample = $invoicetot - $total_returns;
$rep->TextCol(0, 1, $myrow['tranDate']);
$rep->TextCol(1, 2, $myrow['br_name']);
$rep->TextCol(2, 3, $salesman);
$rep->TextCol(3, 4, $myrow['customized_no']);
if ($myrow['IsVoid'] == '') {
$rep->AmountCol(4, 5, $invoicetot, 2);
$rep->TextCol(5, 6, $cm_date);
$rep->TextCol(6, 7, $credit_num);
if ($total_returns != 0) {
$rep->AmountCol(7, 8, $total_returns, 2);
}
if ($invoice_discount < 0) {
$rep->TextCol(8, 9, "CLIENT SALES/SALES DISCOUNT NOT DEFINED.");
} else {
$rep->TextCol(8, 9, $invoice_discount . "%");
}
if ($sales_discount < 0) {
$rep->TextCol(9, 10, "ERROR.");
} else {
if ($sales_discount != 0) {
$rep->AmountCol(9, 10, $sales_discount, 2);
}
}
if ($net_sales != 0) {
$rep->AmountCol(10, 11, $net_sales, 2);
}
$partial_payment = 0;
$or = get_pr_details($myrow['type'], $myrow['trans_no']);
$ref = '';
$num2 = db_num_rows($or);
$date_alloc = '';
while ($pr = db_fetch($or)) {
$partial_payment += $pr['amt'];
$date_alloc = $pr['prDate'] . " ";
$pr_number = $pr['customized_no'] . " ";
if ($num2 > 1) {
$ref .= $pr['reference'] . "/";
} else {
$ref = $pr['reference'];
}
}
$net_remittance = $net_sales - $partial_payment;
$rep->TextCol(11, 12, $date_alloc);
$rep->TextCol(12, 13, $ref);
$rep->TextCol(13, 14, $date_alloc);
$rep->TextCol(14, 15, _(""));
if ($partial_payment == $tot_invoice) {
$rep->AmountCol(15, 16, $partial_payment, 2);
}
if ($partial_payment != 0) {
if ($partial_payment < $tot_invoice) {
$bal = $tot_invoice - $partial_payment;
$rep->AmountCol(16, 17, $partial_payment, 2);
$rep->AmountCol(17, 18, $bal, 2);
}
}
//$rep->AmountCol(15,16, $partial_payment, 2);
//$rep->AmountCol(17,18, $net_remittance, 2);
$myrow4 = db_fetch(get_commission_details($myrow['type'], $myrow['trans_no']));
$comm = ($invoicetot - $total_returns) * ($myrow4['commission'] / 100);
$rep->TextCol(18, 19, $myrow4['tranDate']);
if ($myrow4['commission'] != 0) {
$rep->TextCol(19, 20, $myrow4['commission'] . "%");
}
if ($comm != 0) {
$rep->AmountCol(20, 21, $comm, 2);
}
if ($myrow4['with_tax'] != 0) {
$rep->AmountCol(21, 22, $myrow4['with_tax'], 2);
}
if ($myrow4['net_commission'] != 0) {
$rep->AmountCol(22, 23, $myrow4['net_commission'], 2);
}
$net_invoice += $invoicetot;
$net_discount += $sales_discount;
$net_returns += $total_returns;
$sale_amount += $net_sales;
$net_partial += $partial_payment;
$net_rem += $net_remittance;
$net_bal += $bal;
$net_balance = $net_rem + $net_bal;
$net_comm += $comm;
$net_tax += $myrow4['with_tax'];
$net_net_comm += $myrow4['net_commission'];
} else {
$rep->TextCol(4, 5, "Voided");
}
$rep->NewLine();
}
$rep->Font('bold');
$rep->NewLine();
$rep->TextCol(1, 2, "TOTAL");
$rep->AmountCol(4, 5, $net_invoice, 2);
$rep->AmountCol(7, 8, $net_returns, 2);
$rep->AmountCol(9, 10, $net_discount, 2);
$rep->AmountCol(10, 11, $sale_amount, 2);
$rep->AmountCol(16, 17, $net_partial, 2);
//$rep->AmountCol(17,18, $net_balance, 2);
$rep->AmountCol(20, 21, $net_comm, 2);
$rep->AmountCol(21, 22, $net_tax, 2);
$rep->AmountCol(22, 23, $net_net_comm, 2);
$rep->NewLine();
$rep->End();
}
function print_outstanding_GRN()
{
global $path_to_root;
$fromsupp = $_POST['PARAM_0'];
$comments = $_POST['PARAM_1'];
$orientation = $_POST['PARAM_2'];
$destination = $_POST['PARAM_3'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
if ($fromsupp == ALL_TEXT) {
$from = _('All');
} else {
$from = get_supplier_name($fromsupp);
}
$dec = user_price_dec();
$cols = array(0, 40, 80, 190, 250, 320, 385, 450, 515);
$headers = array(_('GRN'), _('Order'), _('Item') . '/' . _('Description'), _('Qty Recd'), _('qty Inv'), _('Balance'), _('Act Price'), _('Value'));
$aligns = array('left', 'left', 'left', 'right', 'right', 'right', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Supplier'), 'from' => $from, 'to' => ''));
$rep = new FrontReport(_('Outstanding GRNs Report'), "OutstandingGRN", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$Tot_Val = 0;
$Supplier = '';
$SuppTot_Val = 0;
$res = getTransactions($fromsupp);
while ($GRNs = db_fetch($res)) {
$dec2 = get_qty_dec($GRNs['item_code']);
if ($Supplier != $GRNs['supplier_id']) {
if ($Supplier != '') {
$rep->NewLine(2);
$rep->TextCol(0, 7, _('Total'));
$rep->AmountCol(7, 8, $SuppTot_Val, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine(3);
$SuppTot_Val = 0;
}
$rep->TextCol(0, 6, $GRNs['supp_name']);
$Supplier = $GRNs['supplier_id'];
}
$rep->NewLine();
$rep->TextCol(0, 1, $GRNs['id']);
$rep->TextCol(1, 2, $GRNs['order_no']);
$rep->TextCol(2, 3, $GRNs['item_code'] . '-' . $GRNs['description']);
$rep->AmountCol(3, 4, $GRNs['qty_recd'], $dec2);
$rep->AmountCol(4, 5, $GRNs['quantity_inv'], $dec2);
$QtyOstg = $GRNs['qty_recd'] - $GRNs['quantity_inv'];
$Value = ($GRNs['qty_recd'] - $GRNs['quantity_inv']) * $GRNs['act_price'];
$rep->AmountCol(5, 6, $QtyOstg, $dec2);
$rep->AmountCol(6, 7, $GRNs['act_price'], $dec);
$rep->AmountCol(7, 8, $Value, $dec);
$Tot_Val += $Value;
$SuppTot_Val += $Value;
$rep->NewLine(0, 1);
}
if ($Supplier != '') {
$rep->NewLine();
$rep->TextCol(0, 7, _('Total'));
$rep->AmountCol(7, 8, $SuppTot_Val, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine(3);
$SuppTot_Val = 0;
}
$rep->NewLine(2);
$rep->TextCol(0, 7, _('Grand Total'));
$rep->AmountCol(7, 8, $Tot_Val, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->End();
}
clearCSRFToken();
//generatePDF(8);
$showDownload = "";
// if the logged in user is not an employee
if (getAuthUser()->usertype === 'C') {
$accountId = getAccountByUserId(getAuthUser()->userid)->ID;
$transactions = getTransactionsByAccountId($accountId);
$showDownload = "?download=1";
} else {
//4.8.1
if (isset($_GET['id']) && is_numeric((int) $_GET['id']) && (int) $_GET['id'] > 0) {
$accountId = getAccountByUserId((int) $_GET['id'])->ID;
$transactions = getTransactionsByAccountId($accountId);
$showDownload = "?id=" . $_GET['id'] . "&download=1";
} else {
$transactions = getTransactions();
}
}
if (isset($_GET['download'])) {
$download = $_GET['download'];
$pdf = generatePDF($accountId);
}
$users = getUsers();
// include header
$pageTitle = "View Transactions";
include "header.php";
?>
<div class="pull-left">
<a class="pure-button pure-button-primary" href="create_transaction.php">New Transaction</a>
<?php
<?php
session_start();
if (empty($_SESSION['accesstoken'])) {
exit(header('location: /login.php'));
}
// check the access token is still ive
require_once 'inc/settings.php';
require_once 'scripts/checkAccessToken.php';
if (tokenExpired($_SESSION['accesstoken'], $api_root)) {
// make them re-auth, their token has expired.
exit(header('location: /login.php?expired'));
}
require_once 'scripts/transactions.php';
$transactions = getTransactions($_SESSION['accesstoken'], $_SESSION['account_number'], false, $api_root);
// open the output stream
$f = fopen('php://output', 'w');
// Start output buffering (to capture stream contents)
ob_start();
// set the headers
$column_headers = array('ID', 'Time', 'Description', 'Amount', 'Currency', 'Merchant Info', 'Notes', 'Balance', 'Category', 'Local Amount', 'Local Currency');
fputcsv($f, $column_headers);
foreach ($transactions as $transaction) {
unset($transaction['metadata']);
unset($transaction['attachments']);
unset($transaction['is_load']);
unset($transaction['settled']);
unset($transaction['metadata']);
unset($transaction['decline_reason']);
fputcsv($f, $transaction);
}
