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(); }
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_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_invoices() { global $path_to_root, $alternative_tax_include_on_docs, $suppress_tax_rates, $no_zero_lines_amount; include_once $path_to_root . "/reporting/includes/pdf_report.inc"; $from = $_POST['PARAM_0']; $to = $_POST['PARAM_1']; $currency = $_POST['PARAM_2']; $email = $_POST['PARAM_3']; $pay_service = $_POST['PARAM_4']; $comments = $_POST['PARAM_5']; $customer = $_POST['PARAM_6']; $orientation = $_POST['PARAM_7']; if (!$from || !$to) { return; } $orientation = $orientation ? 'L' : 'P'; $dec = user_price_dec(); $fno = explode("-", $from); $tno = explode("-", $to); $from = min($fno[0], $tno[0]); $to = max($fno[0], $tno[0]); $cols = array(4, 40, 60, 100, 200, 250, 300, 320, 400, 450, 500); // $headers in doctext.inc $aligns = array('left', 'left', 'left', 'left', 'right', 'right', 'right', 'right', 'right', 'right', 'right'); //$params = array('comments' => $comments); $cur = get_company_Pref('curr_default'); $company_data = get_company_prefs(); if ($email == 0) { $rep = new FrontReport(_('INVOICE'), "InvoiceBulk", user_pagesize(), 9, $orientation); } if ($orientation == 'L') { recalculate_cols($cols); } for ($i = $from; $i <= $to; $i++) { if (!exists_customer_trans(ST_SALESINVOICE, $i)) { continue; } $sign = 1; $myrow = get_customer_trans($i, ST_SALESINVOICE); if ($customer && $myrow['debtor_no'] != $customer) { continue; } $baccount = get_default_bank_account($myrow['curr_code']); $params['bankaccount'] = $baccount['id']; $branch = get_branch($myrow["branch_code"]); $sales_order = get_sales_order_header($myrow["order_"], ST_SALESORDER); if ($email == 1) { $rep = new FrontReport("", "", user_pagesize(), 9, $orientation); //$rep->title = _('INVOICE'); $rep->filename = "Invoice" . $myrow['reference'] . ".pdf"; } $rep->SetHeaderType(0); $rep->currency = $cur; $rep->Font(); $rep->Info(null, $cols, null, $aligns); //$contacts = get_branch_contacts($branch['branch_code'], 'invoice', $branch['debtor_no'], true); //$baccount['payment_service'] = $pay_service; $salesman = get_imc_code($branch['branch_code']); $pay_term = get_payment_terms($myrow['payment_terms']); $branch_data = get_branch_accounts($myrow['branch_code']); $dt = get_discount($branch_data['sales_discount_account'], $myrow['type'], $myrow['trans_no']); $invoice_no = get_custom_no($myrow['trans_no'], $myrow['type']); $contact = getContactPerson($myrow['salesman'], $myrow['debtor_no'], $branch['branch_code']); $rep->NewPage(); $result = get_customer_trans_details(ST_SALESINVOICE, $i); $SubTotal = 0; $rep->NewLine(8); $rep->TextCol(2, 7, _("CHARGE INVOICE # " . $invoice_no)); $rep->TextCol(8, 9, $myrow['TranDate']); $rep->NewLine(); $rep->TextCol(2, 7, $branch['br_name']); if ($dt != 0) { //$display_bulk_discount = (($sub_total - $myrow['Total']) / $sub_total) * 100; $tot = $myrow['Total'] + $dt; $dscnt = ($tot - $myrow['Total']) / $tot * 100; //$dscnt = ($dt / $myrow['Total']) * 100; $significant = strlen(substr(strrchr($dscnt, "."), 1)); if ($significant > 2) { $rep->TextCol(7, 9, floor($dscnt) . "%"); } else { $rep->TextCol(7, 9, $dscnt . "%"); } } $rep->NewLine(); $rep->TextCol(2, 7, $branch['branch_ref']); $rep->TextCol(8, 9, $salesman); $rep->NewLine(); $rep->TextCol(2, 6, $contact); if ($pay_term['terms'] == 'Cash Only') { $rep->TextCol(8, 9, $pay_term['terms']); } else { $rep->TextCol(7, 10, $pay_term['terms']); } $rep->NewLine(); $oldrow = $rep->row; $newrow = $rep->row; $rep->TextColLines(2, 6, $branch['br_address'], -2); $rep->row = $oldrow; $rep->NewLine(5); $rep->Font('bold'); //$rep->Line($rep->row + 10); //$rep->TextCol(2,5, _("Item Description")); //$rep->TextCol(5,6, _("Quantity")); //$rep->TextCol(7,8, _("Unit Price")); //$rep->TextCol(9,10, _("Total Amount")); //$rep->Line($rep->row - 4); $rep->NewLine(2); $rep->Font(); while ($myrow2 = db_fetch($result)) { if ($myrow2["quantity"] == 0) { continue; } $Net = round2($sign * ((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]), user_price_dec()); $Net2 = round2($sign * ($myrow2["unit_price"] * $myrow2["quantity"]), user_price_dec()); $SubTotal += $Net; $DisplayPrice = number_format2($myrow2["unit_price"], $dec); $DisplayQty = number_format2($sign * $myrow2["quantity"], get_qty_dec($myrow2['stock_id'])); $DisplayNet = number_format2($Net, $dec); $dNet = number_format2($Net2, $dec); /*if ($myrow2["discount_percent"]==0) $DisplayDiscount =""; else $DisplayDiscount = number_format2($myrow2["discount_percent"]*100,user_percent_dec()) . "%";*/ //if ($myrow["ov_discount"]==0) // $DisplayDiscount =""; //else //$DisplayDiscount = number_format2($myrow["ov_discount"]/$myrow["ov_amount"] * 100,user_percent_dec()) . "%"; //$rep->TextCol(0, 3, $myrow2['stock_id'], -2); $oldrow = $rep->row; $rep->TextColLines(0, 5, $myrow2['StockDescription'], -2); $newrow = $rep->row; $rep->row = $oldrow; if ($Net != 0.0 || !is_service($myrow2['mb_flag']) || !isset($no_zero_lines_amount) || $no_zero_lines_amount == 0) { $rep->TextCol(5, 6, $DisplayQty . " " . $myrow2['units']); //$rep->TextCol(5, 6, $myrow2['units'], -2); $rep->TextCol(7, 8, $DisplayPrice, -2); //$rep->TextCol(5, 6, $DisplayDiscount, -2); $rep->TextCol(8, 10, $dNet, -2); } $rep->row = $newrow; //$rep->NewLine(1); if ($rep->row < $rep->bottomMargin + 15 * $rep->lineHeight) { $rep->NewPage(); } } $memo = get_comments_string(ST_SALESINVOICE, $i); if ($memo != "") { $rep->NewLine(); $rep->TextColLines(1, 5, $memo, -2); } $DisplayNet = number_format2($SubTotal, $dec); $DisplaySubTot = number_format2($SubTotal, $dec); $DisplayFreight = number_format2($sign * $myrow["ov_freight"], $dec); $DisplayTots = number_format2($myrow['Total'], $dec); $DisplayDiscount = number_format2($SubTotal - $myrow['Total'], $dec); $rep->row = $rep->bottomMargin + 30 * $rep->lineHeight; $doctype = ST_SALESINVOICE; $rep->NewLine(); $rep->Font('bold'); $rep->TextCol(9, 10, $DisplayNet, -2); $rep->NewLine(); //$rep->TextCol(8, 9, _("Less discount: ")); $rep->TextCol(9, 10, $DisplayDiscount, -2); $rep->NewLine(); //$rep->TextCol(8, 9, _("Net Amount : "), -2); $rep->TextCol(9, 10, $DisplayTots, -2); $rep->NewLine(); /*$tax_items = get_trans_tax_details(ST_SALESINVOICE, $i); $first = true; while ($tax_item = db_fetch($tax_items)) { if ($tax_item['amount'] == 0) continue; $DisplayTax = number_format2($sign*$tax_item['amount'], $dec); if (isset($suppress_tax_rates) && $suppress_tax_rates == 1) $tax_type_name = $tax_item['tax_type_name']; else $tax_type_name = $tax_item['tax_type_name']." (".$tax_item['rate']."%) "; if ($tax_item['included_in_price']) { if (isset($alternative_tax_include_on_docs) && $alternative_tax_include_on_docs == 1) { if ($first) { $rep->TextCol(3, 6, _("Total Tax Excluded"), -2); $rep->TextCol(6, 7, number_format2($sign*$tax_item['net_amount'], $dec), -2); $rep->NewLine(); } $rep->TextCol(3, 6, $tax_type_name, -2); $rep->TextCol(6, 7, $DisplayTax, -2); $first = false; } else $rep->TextCol(3, 7, _("Included") . " " . $tax_type_name . _("Amount") . ": " . $DisplayTax, -2); } else { $rep->TextCol(3, 6, $tax_type_name, -2); $rep->TextCol(6, 7, $DisplayTax, -2); } $rep->NewLine(); } $rep->NewLine(); $DisplayTotal = number_format2($sign*($myrow["ov_freight"] + $myrow["ov_gst"] + $myrow["ov_amount"]+$myrow["ov_freight_tax"]),$dec);*/ //$rep->Font('bold'); //$rep->TextCol(3, 6, _("TOTAL INVOICE"), - 2); //$rep->TextCol(6, 7, $DisplayTotal, -2); //$words = price_in_words($myrow['Total'], ST_SALESINVOICE); //if ($words != "") //{ // $rep->NewLine(1); // $rep->TextCol(1, 7, $myrow['curr_code'] . ": " . $words, - 2); //} //$rep->Font(); if ($email == 1) { $rep->End($email); } } if ($email == 0) { $rep->End(); } }
function print_summary() { global $path_to_root; $sman = $_POST['PARAM_0']; $from = $_POST['PARAM_1']; $to = $_POST['PARAM_2']; $stat = $_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(); $cols = array(0, 50, 100, 150, 200, 250, 300, 350, 400, 450, 520, 550); $headers = array(_('IMC'), _('Gross'), _('Returns'), _('% To Sales'), _('Net Sales'), _('Full Payment'), _('% To Sales'), _('Partial Payments'), _('% To Sales'), _('Accounts Receivables'), _('% To Sales')); $aligns = array('left', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right'); $aligns2 = $aligns; $summary = 1; $rep = new FrontReport(_('Sales Status'), "Sales Status", user_pagesize(), 9, $orientation); if ($orientation == 'L') { recalculate_cols($cols); } $cols2 = $cols; $rep->Font(); $rep->Info(null, $cols, $headers, $aligns); $rep->NewPage(); $total = $grandtotal = 0.0; $total1 = $grandtotal1 = 0.0; $total2 = $grandtotal2 = 0.0; $catt = ''; $slist = array(); if ($sman == "") { $row = get_all_salesman(); while ($r = db_fetch($row)) { array_push($slist, $r['salesman_code']); } foreach ($slist as $slists) { $res = getTransactions($from, $to, $slists, $stat); } } else { $res = getTransactions($from, $to, $sman, $stat); } $prev = ''; while ($myrow = db_fetch($res)) { $current = $myrow['salesman_code']; if ($myrow['salesman_code'] != "") { if ($current == $prev) { } else { } $prev = $current; } $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']); } 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; $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); if ($myrow['IsVoid'] == '') { $myrow4 = db_fetch(get_commission_details($myrow['type'], $myrow['trans_no'])); $comm = ($invoicetot - $total_returns) * ($myrow4['commission'] / 100); $partial_payment = 0; $zero; $or = get_pr_details($myrow['type'], $myrow['trans_no']); $ref = ''; $num2 = db_num_rows($or); $date_alloc = ''; $ctr = 0; $bal = 0; $bal1 = 0; $bal2 = 0; $ppayment = 0; $fpayment = 0; $all_bal = 0; $payment = get_total_payment($myrow['type'], $myrow['trans_no']); while ($pr = db_fetch($or)) { $partial_payment += $pr['amt']; $date_alloc = $pr['prDate'] . " "; $pr_number = $pr['customized_no'] . " "; $ref = $pr['reference']; $net_remittance = $net_sales - $partial_payment; $ctr++; if ($num2 > 1) { $bal = $net_sales - $partial_payment; if (number_format($payment, 2) == number_format($net_sales, 2)) { $fpayment += $pr['amt']; } else { $ppayment += $pr['amt']; $all_bal += $bal; } } else { $bal = $net_sales - $partial_payment; if ($bal == 0) { $bal = number_format($net_sales, 2) - number_format($partial_payment, 2); $fpayment += $partial_payment; $bal1 += $bal; } else { $bal = $net_sales - $pr['amt']; $ppayment += $partial_payment; $bal2 += $bal; } } if ($num2 > 1) { $rep->NewLine(); } } $net_invoice += $invoicetot; $net_discount += $sales_discount; $net_returns += $total_returns; $sale_amount += $net_sales; $net_partial += $ppayment; $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']; $net_full_payment += $fpayment; } } $Percentage1 = $net_returns / $net_invoice * 100; $NetSales = $net_invoice - $net_returns; $Percentage2 = $net_full_payment / $NetSales * 100; $Percentage3 = $net_partial / $NetSales * 100; $ReceivablesTotal = $NetSales - $net_full_payment - $net_partial; $Percentage4 = $ReceivablesTotal / $NetSales * 100; $rep->Font('bold'); $rep->NewLine(); $rep->TextCol(0, 1, $salesman); $rep->AmountCol(1, 2, $net_invoice, 2); $rep->AmountCol(2, 3, $net_returns, 2); $rep->AmountCol(3, 4, $Percentage1, 2); $rep->AmountCol(4, 5, $NetSales, 2); $rep->AmountCol(5, 6, $net_full_payment, 2); $rep->AmountCol(6, 7, $Percentage2, 2); $rep->AmountCol(7, 8, $net_partial, 2); $rep->AmountCol(8, 9, $Percentage3, 2); $rep->AmountCol(9, 10, $ReceivablesTotal, 2); $rep->AmountCol(10, 11, $Percentage4, 2); $rep->NewLine(); $rep->End(); }
function print_invoices() { global $path_to_root, $alternative_tax_include_on_docs, $suppress_tax_rates, $no_zero_lines_amount; include_once $path_to_root . "/reporting/includes/pdf_report.inc"; $from = $_POST['PARAM_0']; $to = $_POST['PARAM_1']; $currency = $_POST['PARAM_2']; $email = $_POST['PARAM_3']; $pay_service = $_POST['PARAM_4']; $comments = $_POST['PARAM_5']; $customer = $_POST['PARAM_6']; $orientation = $_POST['PARAM_7']; if (!$from || !$to) { return; } $orientation = $orientation ? 'L' : 'P'; $dec = user_price_dec(); $fno = explode("-", $from); $tno = explode("-", $to); $from = min($fno[0], $tno[0]); $to = max($fno[0], $tno[0]); $cols = array(-18, 40, 60, 100, 160, 200, 260, 360, 420, 450, 500); // $headers in doctext.inc $aligns = array('left', 'left', 'left', 'left', 'right', 'right', 'right', 'right', 'right', 'right', 'right'); //$params = array('comments' => $comments); $cur = get_company_Pref('curr_default'); $company_data = get_company_prefs(); if ($email == 0) { $rep = new FrontReport(_('INVOICE'), "InvoiceBulk", user_pagesize(), 9, $orientation); } if ($orientation == 'L') { recalculate_cols($cols); } for ($i = $from; $i <= $to; $i++) { if (!exists_customer_trans(ST_SALESINVOICE, $i)) { continue; } $sign = 1; $myrow = get_customer_trans($i, ST_SALESINVOICE); if ($customer && $myrow['debtor_no'] != $customer) { continue; } $baccount = get_default_bank_account($myrow['curr_code']); $params['bankaccount'] = $baccount['id']; $branch = get_branch($myrow["branch_code"]); $sales_order = get_sales_order_header($myrow["order_"], ST_SALESORDER); if ($email == 1) { $rep = new FrontReport("", "", user_pagesize(), 9, $orientation); //$rep->title = _('INVOICE'); $rep->filename = "Invoice" . $myrow['reference'] . ".pdf"; } $rep->SetHeaderType(0); $rep->currency = $cur; $rep->Font(); $rep->Info(null, $cols, null, $aligns); $salesman = get_imc_code($branch['branch_code']); $pay_term = get_payment_terms($myrow['payment_terms']); $branch_data = get_branch_accounts($myrow['branch_code']); $invoice_no = get_custom_no($myrow['trans_no'], $myrow['type']); $contact = getContact($myrow['salesman'], $myrow['debtor_no'], $branch['branch_code']); $cnumber = getContactNumber($myrow['salesman'], $myrow['debtor_no'], $branch['branch_code']); $rep->NewPage(); $result = get_customer_trans_details(ST_SALESINVOICE, $i); $SubTotal = 0; $rep->NewLine(6); $rep->TextCol(2, 7, $invoice_no); $rep->TextCol(6, 8, $myrow['TranDate']); $rep->NewLine(); $rep->TextCol(2, 7, $branch['br_name']); $rep->TextCol(7, 8, $myrow['bulk_discount'] . "%"); $rep->NewLine(); $rep->TextCol(2, 7, $branch['branch_ref']); $rep->TextCol(6, 8, $salesman); $rep->NewLine(); $rep->TextCol(2, 6, $contact . " - " . $cnumber); if ($pay_term['terms'] == 'C.O.D.' || $pay_term['Cash Only']) { $rep->TextCol(7, 8, $pay_term['terms'], -2); } else { $oldrow = $rep->row; $newrow = $rep->row; $rep->TextColLines(7, 9, $pay_term['terms'], -2); $newrow = $rep->row; $rep->row = $oldrow; } $rep->NewLine(); $oldrow = $rep->row; $newrow = $rep->row; $rep->TextColLines(2, 6, $branch['br_address'], -2); $rep->row = $oldrow; $rep->NewLine(4); $rep->Font(); while ($myrow2 = db_fetch($result)) { if ($myrow2["quantity"] == 0) { continue; } $Net = round2($sign * ((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]), user_price_dec()); $Net2 = round2($sign * ($myrow2["unit_price"] * $myrow2["quantity"]), user_price_dec()); $SubTotal += $Net; $DisplayPrice = number_format2($myrow2["unit_price"], 2); $DisplayQty = number_format2($sign * $myrow2["quantity"], get_qty_dec($myrow2['stock_id'])); $DisplayNet = number_format2($Net, 2); $dNet = number_format2($Net2, 2); $oldrow = $rep->row; $rep->TextColLines(-0.75, 4, $myrow2['StockDescription'], -2); $newrow = $rep->row; $rep->row = $oldrow; if ($Net != 0.0 || !is_service($myrow2['mb_flag']) || !isset($no_zero_lines_amount) || $no_zero_lines_amount == 0) { $rep->TextCol(4, 5, $DisplayQty . " " . $myrow2['units']); $rep->TextCol(5, 6, $DisplayPrice, -2); $rep->TextCol(6, 8, $dNet, -2); } $rep->row = $newrow; if ($rep->row < $rep->bottomMargin + 15 * $rep->lineHeight) { $rep->NewPage(); } } $memo = get_comments_string(ST_SALESINVOICE, $i); if ($memo != "") { $rep->NewLine(); $rep->TextColLines(1, 5, $memo, -2); } $DisplayNet = number_format2($SubTotal, 2); $DisplaySubTot = number_format2($SubTotal, 2); $DisplayTots = number_format2($myrow['Total'], 2); $DisplayDiscount = number_format2($SubTotal * ($myrow['bulk_discount'] / 100), 2); $rep->NewLine(3); $doctype = ST_SALESINVOICE; $rep->NewLine(); $rep->Font('bold'); $rep->TextCol(6, 7, "TOTAL AMOUNT :"); $rep->TextCol(6, 8, $DisplayNet, -2); $rep->NewLine(); $rep->TextCol(6, 7, "VOLUME DISCOUNT :"); $rep->TextCol(5, 8, $DisplayDiscount, -2); $rep->NewLine(); $rep->TextCol(6, 7, _("NET AMOUNT : "), -2); $rep->TextCol(5, 8, $DisplayTots, -2); $rep->NewLine(); if ($email == 1) { $rep->End($email); } } if ($email == 0) { $rep->End(); } }
function print_summary() { global $path_to_root; $imc = $_POST['PARAM_0']; $from = $_POST['PARAM_1']; $to = $_POST['PARAM_2']; $status = $_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(); $cols = array(0, 50, 100, 150, 200, 250, 300, 350, 400, 450, 520, 550); $headers = array(_('IMC'), _('Gross'), _('Returns'), _('Discount'), _('% To Sales'), _('Net Sales'), _('Full Payment'), _('% To Sales'), _('Partial Payments'), _('% To Sales'), _('Accounts Receivables'), _('% To Sales')); $aligns = array('left', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right', 'right'); $aligns2 = $aligns; $summary = 1; $rep = new FrontReport(_('Sales Status'), "Sales Status", user_pagesize(), 9, $orientation); if ($orientation == 'L') { recalculate_cols($cols); } $cols2 = $cols; $rep->Font(); $rep->Info(null, $cols, $headers, $aligns); $rep->NewPage(); $result = getTransactions($imc, $from, $to, ST_SALESINVOICE, $status); $InvoiceTotal = 0; $TotalReturn = 0; $DiscountTotal = 0; $NetSales = 0; $FullAlloc = 0; $PartialAlloc = 0; $ReceivablesTotal = 0; $Percentage1 = 0; $Percentage2 = 0; $Percentage3 = 0; $Percentage4 = 0; $TotalInvoice = 0; $TotalReturn_2 = 0; $TotalSales = 0; $TotalFullAlloc = 0; $TotalPartialAlloc = 0; $TotalReceivables = 0; $TotalDiscount = 0; $previous = ''; while ($myrow = db_fetch($result)) { $company_data = get_company_prefs(); $imc = $myrow['imc_code']; $imc_code = $myrow['salesman_code']; $DiscountTotal = getDiscountTotal($imc_code, $from, $to, ST_SALESINVOICE, get_company_pref('default_sales_discount_act'), $status); $ReturnDiscount = getDiscountTotal($imc_code, $from, $to, ST_CUSTCREDIT, get_company_pref('default_sales_discount_act'), $status); $InvoiceTotal = $myrow['InvoiceTotal'] + $DiscountTotal; $TotalDiscount = $ReturnDiscount + $DiscountTotal; $net_partial = 0; $net_full_payment = 0; $TotalReturn = 0; $Transact = getAllocTransact($from, $to, $imc_code, $status); while ($row = db_fetch($Transact)) { $branch = get_branch($row["branch_code"]); $branch_data = get_branch_accounts($row['branch_code']); $dt = get_discount($branch_data['sales_discount_account'], $row['type'], $row['trans_no']); $res2 = get_return_details($row['order_']); $returns = 0; $rtn_dt = 0; $num = db_num_rows($res2); $var = array(); while ($myrow2 = db_fetch($res2)) { $returns += $myrow2['ov_amount']; $var = array($myrow2['trans_no']); } 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; $TotalReturn += $total_returns; $invoicetot = $row['ov_amount'] + $dt; $invoice_discount = $dt / $invoicetot * 100; $sales_discount = ($invoicetot - $total_returns) * ($invoice_discount / 100); $net_sales = $invoicetot - $total_returns - $sales_discount; if ($row['IsVoid'] == '') { $partial_payment = 0; $zero; $or = get_pr_details($row['type'], $row['trans_no']); $num2 = db_num_rows($or); $date_alloc = ''; $ctr = 0; $bal = 0; $bal1 = 0; $bal2 = 0; $ppayment = 0; $fpayment = 0; $all_bal = 0; $payment = get_total_payment($row['type'], $row['trans_no']); while ($pr = db_fetch($or)) { $partial_payment += $pr['amt']; $ctr++; if ($num2 > 1) { $bal = $net_sales - $partial_payment; if (number_format($payment, 2) == number_format($net_sales, 2)) { if ($status == 1 || $status == "" || $status == 0) { $fpayment += $pr['amt']; } } else { if ($status == 2 || $status == "" || $status == 0) { $ppayment += $pr['amt']; $all_bal += $bal; } } } else { $bal = $net_sales - $partial_payment; if ($bal == 0) { $bal = number_format($net_sales, 2) - number_format($partial_payment, 2); if ($status == 1 || $status == "" || $status == 0) { $fpayment += $partial_payment; $bal1 += $bal; } } else { $bal = $net_sales - $pr['amt']; if ($status == 2 || $status == "" || $status == 0) { $ppayment += $partial_payment; $bal2 += $bal; } } } } $net_partial += $ppayment; $net_full_payment += $fpayment; } } $Percentage1 = $TotalReturn / $InvoiceTotal * 100; $NetSales = $InvoiceTotal - $TotalReturn; $Percentage2 = $net_full_payment / $NetSales * 100; $Percentage3 = $net_partial / $NetSales * 100; $ReceivablesTotal = $NetSales - $fpayment - $ppayment; $Percentage4 = $ReceivablesTotal / $NetSales * 100; $rep->TextCol(0, 1, $myrow['imc_code']); $rep->AmountCol(1, 2, $InvoiceTotal, 2); $rep->AmountCol(2, 3, $TotalReturn, 2); $rep->AmountCol(3, 4, $TotalDiscount, 2); $rep->AmountCol(4, 5, $Percentage1, 2); $rep->AmountCol(5, 6, $NetSales, 2); $rep->AmountCol(6, 7, $net_full_payment, 2); $rep->AmountCol(7, 8, $Percentage2, 2); $rep->AmountCol(8, 9, $net_partial, 2); $rep->AmountCol(9, 10, $Percentage3, 2); if ($status != 1) { $rep->AmountCol(10, 11, $ReceivablesTotal, 2); } $rep->AmountCol(11, 12, $Percentage4, 2); $rep->NewLine(); $TotalInvoice += $InvoiceTotal; $TotalReturn_2 += $TotalReturn; $TotalSales += $NetSales; $TotalFullAlloc += $net_full_payment; $TotalPartialAlloc += $net_partial; if ($status != 1) { $TotalReceivables += $ReceivablesTotal; } } $rep->NewLine(); $rep->Font('bold'); $rep->TextCol(0, 1, "TOTAL"); $rep->AmountCol(1, 2, $TotalInvoice, 2); $rep->AmountCol(2, 3, $TotalReturn_2, 2); $rep->AmountCol(5, 6, $TotalSales, 2); $rep->AmountCol(6, 7, $TotalFullAlloc, 2); $rep->AmountCol(8, 9, $TotalPartialAlloc, 2); $rep->AmountCol(10, 11, $TotalReceivables, 2); $rep->NewLine(); $rep->NewLine(); $rep->End(); }
function print_cash_sale() { 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, 250, 350, 400, 450, 500, 550, 600, 700, 750, 800, 850, 900, 950, 1000, 1050, 1100, 1150, 1200); $headers = array(_('DATE'), _('CLIENT NAME'), _('IMC'), _('CASH SALES'), _('INVOICE'), _('CASH'), _('SALES'), _('RETURNS'), _('SALES DISCOUNT'), _('SUNDRIES'), _('DR'), _('CR')); $header2 = array(_(''), '', _('CODE'), _('INVOICE'), _('AMOUNT'), _('DR'), _('CR'), _(' DR'), _('DR'), _(''), _('')); $aligns = array('left', 'left', 'center', 'left', '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(_('Cash Sales Report'), "CashSalesReport", user_pagesize(), 8, 'L'); $rep->Font(); $rep->Info($params, $cols, $header2, $aligns, $cols, $headers, $aligns); $rep->NewPage(); $res = getTransactions($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']); $sales_acct = get_discount($branch_data['sales_account'], $myrow['type'], $myrow['trans_no']); $salesman = get_imc_code($myrow['branch_code']); $invoicetot = $myrow['ov_amount'] + $dt; $invoice_discount = $dt / $invoicetot * 100; $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->AmountCol(5, 6, $myrow['ov_amount'], 2); $rtn_dt = 0; $res2 = get_return_details($myrow['order_']); while ($myrow2 = db_fetch($res2)) { $returns += $myrow2['ov_amount']; $res2 = get_return_discount($branch_data['sales_discount_account'], $myrow2['type'], $myrow2['trans_no']); while ($myrow3 = db_fetch($res2)) { $rtn_dt += abs($myrow3['amount']); } } $net_sales = abs($sales_acct) - $dt - $rtn_dt; $rep->AmountCol(6, 7, $net_sales, 2); if ($rtn_dt != 0) { $rep->AmountCol(7, 8, $rtn_dt, 2); } if ($dt != 0) { $rep->AmountCol(8, 9, $dt, 2); } $rep->NewLine(); } else { $rep->TextCol(4, 5, "Voided"); } $net_invoice += $invoicetot; $net_dr += $myrow['ov_amount']; $net_cr += $net_sales; $net_return += $rtn_dt; $net_ret_dt += $dt; } $rep->NewLine(); $rep->Font('bold'); $rep->TextCol(1, 2, "TOTAL"); $rep->AmountCol(4, 5, $net_invoice, 2); $rep->AmountCol(5, 6, $net_dr, 2); $rep->AmountCol(6, 7, $net_cr, 2); $rep->AmountCol(7, 8, $net_return, 2); $rep->AmountCol(8, 9, $net_ret_dt, 2); $rep->End(); }
end_table(); div_end(); if (get_post('_show_inactive_update')) { $Ajax->activate('imc'); set_focus('imc'); } } else { display_error("Enter some IMC/Salesman."); hidden('imc'); } $edit_id = find_submit("Edit"); if ($edit_id != -1) { $myrow = db_fetch(get_selected_salesman($edit_id)); $company_data = get_company_prefs(); $branch = get_branch($myrow["branch_code"]); $branch_data = get_branch_accounts($myrow['branch_code']); clear_data(); $_POST['sales'] = $myrow['salesman_name']; //get imc name $_POST['invoice_no'] = $myrow['customized_no']; //get invoice number $_POST['client'] = $myrow['br_name']; //get customer name $_POST['br_id'] = $myrow['debtor_no']; $_POST['order_no'] = $myrow['order_']; $dt = get_discount($branch_data['sales_discount_account'], $myrow['type'], $myrow['trans_no']); $res = get_returns($_POST['order_no']); while ($myrow2 = db_fetch($res)) { $rtn += $myrow2['ov_amount']; $res2 = get_return_discount($branch_data['sales_discount_account'], $myrow2['type'], $myrow2['trans_no']); while ($myrow3 = db_fetch($res2)) {