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); }