function render($id, $title)
{
global $path_to_root, $systypes_array;
include_once $path_to_root . "/includes/ui.inc";
$start_date = add_days(Today(), -$this->days_past);
$end_date = add_days(Today(), $this->days_future);
$result = get_bank_trans_for_bank_account($this->bank_act, $start_date, $end_date);
start_table(TABLESTYLE, 'width=98%');
$th = array(_("#"), _("Date"), _("Receipt"), _("Payment"), _("Balance"), _("Person/Item"), _("Memo"), "");
table_header($th);
$bfw = get_balance_before_for_bank_account($this->bank_act, $start_date);
$credit = $debit = 0;
start_row("class='inquirybg' style='font-weight:bold'");
label_cell(_("Opening Balance") . " - " . $start_date, "colspan=4");
display_debit_or_credit_cells($bfw);
label_cell("");
label_cell("", "colspan=2");
end_row();
$running_total = $bfw;
if ($bfw > 0) {
$debit += $bfw;
} else {
$credit += $bfw;
}
$j = 1;
$k = 0;
//row colour counter
while ($myrow = db_fetch($result)) {
alt_table_row_color($k);
$running_total += $myrow["amount"];
label_cell(get_trans_view_str($myrow["type"], $myrow["trans_no"]));
$trandate = sql2date($myrow["trans_date"]);
label_cell($trandate);
display_debit_or_credit_cells($myrow["amount"]);
amount_cell($running_total);
label_cell(payment_person_name($myrow["person_type_id"], $myrow["person_id"]));
label_cell(get_comments_string($myrow["type"], $myrow["trans_no"]));
label_cell(get_gl_view_str($myrow["type"], $myrow["trans_no"]));
end_row();
if ($myrow["amount"] > 0) {
$debit += $myrow["amount"];
} else {
$credit += $myrow["amount"];
}
if ($j == 12) {
$j = 1;
table_header($th);
}
$j++;
}
//end of while loop
start_row("class='inquirybg' style='font-weight:bold'");
label_cell(_("Ending Balance") . " - " . $end_date, "colspan=4");
amount_cell($debit + $credit);
label_cell("");
label_cell("", "colspan=2");
end_row();
end_table(2);
}
function display_gl_heading($myrow)
{
global $systypes_array;
$trans_name = $systypes_array[$_GET['type_id']];
start_table(TABLESTYLE, "width='95%'");
$th = array(_("General Ledger Transaction Details"), _("Reference"), _("Date"), _("Person/Item"));
table_header($th);
start_row();
label_cell("{$trans_name} #" . $_GET['trans_no']);
label_cell($myrow["reference"]);
label_cell(sql2date($myrow["tran_date"]));
label_cell(payment_person_name($myrow["person_type_id"], $myrow["person_id"]));
end_row();
comments_display_row($_GET['type_id'], $_GET['trans_no']);
end_table(1);
}
function display_gl_heading($myrow)
{
global $systypes_array;
$title = "";
//moodlearning
if ($myrow['type'] == 55 || $myrow['type'] == 1) {
if ($myrow['type'] == 0) {
$title = "JV No.";
$num = substr($ser['year'], 2);
}
if ($myrow['type'] == 55) {
$voucher_type = "Check Voucher";
$title = "CV No.";
$myDateTime = DateTime::createFromFormat('Y-m-d', $myrow['tran_date']);
$newDateString = $myDateTime->format('d-m-Y');
$year = substr($newDateString, 8) . "-";
}
}
$trans_name = $systypes_array[$_GET['type_id']];
start_table(TABLESTYLE, "width=95%");
if ($myrow['type'] == 0 || $myrow['type'] == 1 || $myrow['type'] == 55) {
$th = array(_("General Ledger Transaction Details"), _("Reference"), _("Date"), _("Person/Item"), $title);
} else {
$th = array(_("General Ledger Transaction Details"), _("Reference"), _("Date"), _("Person/Item"));
}
table_header($th);
start_row();
if ($custom == 0) {
label_cell("{$trans_name} #" . $_GET['type_id']);
} else {
label_cell("{$trans_name} #" . get_customized_no($myrow['type'], $myrow['type_no']));
}
label_cell($myrow["reference"]);
label_cell(sql2date($myrow["tran_date"]));
label_cell(payment_person_name($myrow["person_type_id"], $myrow["person_id"]));
if ($myrow['type'] == 0 || $myrow['type'] == 1 || $myrow['type'] == 55) {
label_cell($year . str_pad(get_customized_no($myrow['type'], $myrow['type_no']), 4, 0, STR_PAD_LEFT));
}
//moodlearning
end_row();
comments_display_row($_GET['type_id'], $_GET['trans_no']);
end_table(1);
}
$colspan1 = 1;
$colspan2 = 7;
} else {
$colspan1 = 3;
$colspan2 = 5;
}
start_row();
label_cells(_("To Bank Account"), $to_trans['bank_account_name'], "class='tableheader2'");
if ($show_currencies) {
label_cells(_("Currency"), $to_trans['bank_curr_code'], "class='tableheader2'");
}
label_cells(_("Amount"), number_format2($to_trans['amount'], user_price_dec()), "class='tableheader2'", "align=right");
label_cells(_("Date"), sql2date($to_trans['trans_date']), "class='tableheader2'");
end_row();
start_row();
label_cells(_("From"), payment_person_name($to_trans['person_type_id'], $to_trans['person_id']), "class='tableheader2'", "colspan={$colspan1}");
if ($show_currencies) {
label_cells(_("Settle currency"), $to_trans['settle_curr'], "class='tableheader2'");
label_cells(_("Settled amount"), number_format2($to_trans['settled_amount'], user_price_dec()), "class='tableheader2'");
}
label_cells(_("Deposit Type"), $bank_transfer_types[$to_trans['account_type']], "class='tableheader2'");
end_row();
start_row();
label_cells(_("Reference"), $to_trans['ref'], "class='tableheader2'", "colspan={$colspan2}");
end_row();
comments_display_row(ST_BANKDEPOSIT, $trans_no);
end_table(1);
is_voided_display(ST_BANKDEPOSIT, $trans_no, _("This deposit has been voided."));
$items = get_gl_trans(ST_BANKDEPOSIT, $trans_no);
if (db_num_rows($items) == 0) {
display_note(_("There are no items for this deposit."));
function print_GL_transactions()
{
global $path_to_root, $systypes_array;
$dim = get_company_pref('use_dimension');
$dimension = $dimension2 = 0;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$fromacc = $_POST['PARAM_2'];
$toacc = $_POST['PARAM_3'];
if ($dim == 2) {
$dimension = $_POST['PARAM_4'];
$dimension2 = $_POST['PARAM_5'];
$comments = $_POST['PARAM_6'];
$orientation = $_POST['PARAM_7'];
$destination = $_POST['PARAM_8'];
} else {
if ($dim == 1) {
$dimension = $_POST['PARAM_4'];
$comments = $_POST['PARAM_5'];
$orientation = $_POST['PARAM_6'];
$destination = $_POST['PARAM_7'];
} else {
$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';
$rep = new FrontReport(_('GL Account Transactions'), "GLAccountTransactions", user_pagesize(), 9, $orientation);
$dec = 2;
//$cols = array(0, 80, 100, 150, 210, 280, 340, 400, 450, 510, 570);
$cols = array(0, 65, 105, 125, 175, 230, 290, 345, 405, 465, 525);
//------------0--1---2---3----4----5----6----7----8----9----10-------
//-----------------------dim1-dim2-----------------------------------
//-----------------------dim1----------------------------------------
//-------------------------------------------------------------------
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'left', 'right', 'right', 'right');
if ($dim == 2) {
$headers = array(_('Type'), _('Ref'), _('#'), _('Date'), _('Dimension') . " 1", _('Dimension') . " 2", _('Person/Item'), _('Debit'), _('Credit'), _('Balance'));
} elseif ($dim == 1) {
$headers = array(_('Type'), _('Ref'), _('#'), _('Date'), _('Dimension'), "", _('Person/Item'), _('Debit'), _('Credit'), _('Balance'));
} else {
$headers = array(_('Type'), _('Ref'), _('#'), _('Date'), "", "", _('Person/Item'), _('Debit'), _('Credit'), _('Balance'));
}
if ($dim == 2) {
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Accounts'), 'from' => $fromacc, 'to' => $toacc), 3 => array('text' => _('Dimension') . " 1", 'from' => get_dimension_string($dimension), 'to' => ''), 4 => array('text' => _('Dimension') . " 2", 'from' => get_dimension_string($dimension2), 'to' => ''));
} else {
if ($dim == 1) {
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Accounts'), 'from' => $fromacc, 'to' => $toacc), 3 => array('text' => _('Dimension'), 'from' => get_dimension_string($dimension), 'to' => ''));
} else {
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Accounts'), 'from' => $fromacc, 'to' => $toacc));
}
}
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$accounts = get_gl_accounts($fromacc, $toacc);
while ($account = db_fetch($accounts)) {
if (is_account_balancesheet($account["account_code"])) {
$begin = "";
} else {
$begin = get_fiscalyear_begin_for_date($from);
if (date1_greater_date2($begin, $from)) {
$begin = $from;
}
$begin = add_days($begin, -1);
}
$prev_balance = get_gl_balance_from_to($begin, $from, $account["account_code"], $dimension, $dimension2);
$trans = get_gl_transactions($from, $to, -1, $account['account_code'], $dimension, $dimension2);
$rows = db_num_rows($trans);
if ($prev_balance == 0.0 && $rows == 0) {
continue;
}
$rep->Font('bold');
$rep->TextCol(0, 4, $account['account_code'] . " " . $account['account_name'], -2);
$rep->TextCol(4, 6, _('Opening Balance'));
if ($prev_balance > 0.0) {
$rep->AmountCol(7, 8, abs($prev_balance), $dec);
} else {
$rep->AmountCol(8, 9, abs($prev_balance), $dec);
}
$rep->Font();
$total = $prev_balance;
$rep->NewLine(2);
if ($rows > 0) {
while ($myrow = db_fetch($trans)) {
$total += $myrow['amount'];
$type_name = $systypes_array[$myrow["type"]];
if ($type_name == "Customer Payment") {
$rep->TextCol(0, 1, "CRB", -2);
}
if ($type_name == "Cash Disbursement/Check Voucher") {
$rep->TextCol(0, 1, "CDB", -2);
}
if ($type_name == "Journal Entry") {
$rep->TextCol(0, 1, "JB", -2);
}
if ($type_name == "Customer Credit Note") {
$type_name = "Credit Memo";
}
if ($type_name == "Sales Invoice") {
$type_name = "Invoice";
} else {
if ($type_name != "Customer Payment" && $type_name != "Cash Disbursement/Check Voucher" && $type_name != "Journal Entry") {
$rep->TextCol(0, 1, $type_name, -2);
}
}
$reference = get_reference($myrow["type"], $myrow["type_no"]);
$rep->TextCol(1, 2, $reference);
$rep->TextCol(2, 3, $myrow['type_no'], -2);
$rep->DateCol(3, 4, $myrow["tran_date"], true);
if ($dim >= 1) {
$rep->TextCol(4, 5, get_dimension_string($myrow['dimension_id']));
}
if ($dim > 1) {
$rep->TextCol(5, 6, get_dimension_string($myrow['dimension2_id']));
}
$txt = payment_person_name($myrow["person_type_id"], $myrow["person_id"], false);
$memo = $myrow['memo_'];
if ($txt != "") {
if ($memo != "") {
$txt = $txt . "/" . $memo;
}
} else {
$txt = $memo;
}
$rep->TextCol(6, 7, $txt, -2);
if ($myrow['amount'] > 0.0) {
$rep->AmountCol(7, 8, abs($myrow['amount']), $dec);
} else {
$rep->AmountCol(8, 9, abs($myrow['amount']), $dec);
}
$rep->TextCol(9, 10, number_format2($total, $dec));
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->NewPage();
}
}
$rep->NewLine();
}
$rep->Font('bold');
$rep->TextCol(4, 6, _("Ending Balance"));
if ($total > 0.0) {
$rep->AmountCol(7, 8, abs($total), $dec);
} else {
$rep->AmountCol(8, 9, abs($total), $dec);
}
$rep->Font();
$rep->Line($rep->row - $rep->lineHeight + 4);
$rep->NewLine(2, 1);
}
$rep->End();
}
function fmt_person($row)
{
return payment_person_name($row["person_type_id"], $row["person_id"]);
}
function show_results()
{
global $path_to_root, $systypes_array;
if (!isset($_POST["account"])) {
$_POST["account"] = null;
}
$act_name = $_POST["account"] ? get_gl_account_name($_POST["account"]) : "";
$dim = get_company_pref('use_dimension');
/*Now get the transactions */
if (!isset($_POST['Dimension'])) {
$_POST['Dimension'] = 0;
}
if (!isset($_POST['Dimension2'])) {
$_POST['Dimension2'] = 0;
}
$result = get_gl_transactions($_POST['TransFromDate'], $_POST['TransToDate'], -1, $_POST["account"], $_POST['Dimension'], $_POST['Dimension2'], null, input_num('amount_min'), input_num('amount_max'));
$colspan = $dim == 2 ? "6" : ($dim == 1 ? "5" : "4");
if ($_POST["account"] != null) {
display_heading($_POST["account"] . " " . $act_name);
}
// Only show balances if an account is specified AND we're not filtering by amounts
$show_balances = $_POST["account"] != null && input_num("amount_min") == 0 && input_num("amount_max") == 0;
start_table(TABLESTYLE);
$first_cols = array(_("Type"), _("#"), _("Date"));
if ($_POST["account"] == null) {
$account_col = array(_("Account"));
} else {
$account_col = array();
}
if ($dim == 2) {
$dim_cols = array(_("Dimension") . " 1", _("Dimension") . " 2");
} else {
if ($dim == 1) {
$dim_cols = array(_("Dimension"));
} else {
$dim_cols = array();
}
}
if ($show_balances) {
$remaining_cols = array(_("Person/Item"), _("Debit"), _("Credit"), _("Balance"), _("Memo"));
} else {
$remaining_cols = array(_("Person/Item"), _("Debit"), _("Credit"), _("Memo"));
}
$th = array_merge($first_cols, $account_col, $dim_cols, $remaining_cols);
table_header($th);
if ($_POST["account"] != null && is_account_balancesheet($_POST["account"])) {
$begin = "";
} else {
$begin = get_fiscalyear_begin_for_date($_POST['TransFromDate']);
if (date1_greater_date2($begin, $_POST['TransFromDate'])) {
$begin = $_POST['TransFromDate'];
}
$begin = add_days($begin, -1);
}
$bfw = 0;
if ($show_balances) {
$bfw = get_gl_balance_from_to($begin, $_POST['TransFromDate'], $_POST["account"], $_POST['Dimension'], $_POST['Dimension2']);
start_row("class='inquirybg'");
label_cell("<b>" . _("Opening Balance") . " - " . $_POST['TransFromDate'] . "</b>", "colspan={$colspan}");
display_debit_or_credit_cells($bfw, true);
label_cell("");
label_cell("");
end_row();
}
$running_total = $bfw;
$j = 1;
$k = 0;
//row colour counter
while ($myrow = db_fetch($result)) {
alt_table_row_color($k);
$running_total += $myrow["amount"];
$trandate = sql2date($myrow["tran_date"]);
label_cell($systypes_array[$myrow["type"]]);
label_cell(get_gl_view_str($myrow["type"], $myrow["type_no"], $myrow["type_no"], true));
label_cell($trandate);
if ($_POST["account"] == null) {
label_cell($myrow["account"] . ' ' . get_gl_account_name($myrow["account"]));
}
if ($dim >= 1) {
label_cell(get_dimension_string($myrow['dimension_id'], true));
}
if ($dim > 1) {
label_cell(get_dimension_string($myrow['dimension2_id'], true));
}
label_cell(payment_person_name($myrow["person_type_id"], $myrow["person_id"]));
display_debit_or_credit_cells($myrow["amount"]);
if ($show_balances) {
amount_cell($running_total);
}
if ($myrow['memo_'] == "") {
$myrow['memo_'] = get_comments_string($myrow['type'], $myrow['type_no']);
}
label_cell($myrow['memo_']);
end_row();
$j++;
if ($j == 12) {
$j = 1;
table_header($th);
}
}
//end of while loop
if ($show_balances) {
start_row("class='inquirybg'");
label_cell("<b>" . _("Ending Balance") . " - " . $_POST['TransToDate'] . "</b>", "colspan={$colspan}");
display_debit_or_credit_cells($running_total, true);
label_cell("");
label_cell("");
end_row();
}
end_table(2);
if (db_num_rows($result) == 0) {
display_note(_("No general ledger transactions have been created for the specified criteria."), 0, 1);
}
}
$result = get_gl_transactions($begin, $end, -1, $account, 0, 0, null);
$j = 0;
$k = 1;
while ($myrow = db_fetch($result)) {
alt_table_row_color($k);
$trandate = sql2date($myrow["tran_date"]);
label_cell($systypes_array[$myrow["type"]]);
$amount = price_format($myrow["amount"]);
$str = "<a href='#' onclick='return WindowClose(\"{$amount}\", \"{$trandate}\");' >" . $myrow['type_no'] . "</a>";
label_cell($str);
label_cell($trandate);
if ($dim >= 1) {
label_cell(get_dimension_string($myrow['dimension_id'], true));
}
if ($dim > 1) {
label_cell(get_dimension_string($myrow['dimension2_id'], true));
}
label_cell(payment_person_name($myrow["person_type_id"], $myrow["person_id"]));
display_debit_or_credit_cells($myrow["amount"]);
label_cell($myrow['memo_']);
end_row();
$j++;
if ($j == 12) {
$j = 1;
table_header($th);
}
}
//end of while loop
//end of while loop
end_table(1);
end_page(true);
function print_bank_transactions()
{
global $path_to_root, $systypes_array;
$acc = $_POST['PARAM_0'];
$from = $_POST['PARAM_1'];
$to = $_POST['PARAM_2'];
$zero = $_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';
$rep = new FrontReport(_('Bank Statement'), "BankStatement", user_pagesize(), 9, $orientation);
$dec = user_price_dec();
$cols = array(0, 90, 110, 170, 225, 350, 400, 460, 520);
$aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right', 'right');
$headers = array(_('Type'), _('#'), _('Reference'), _('Date'), _('Person/Item'), _('Debit'), _('Credit'), _('Balance'));
$account = get_bank_account($acc);
$act = $account['bank_account_name'] . " - " . $account['bank_curr_code'] . " - " . $account['bank_account_number'];
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Bank Account'), 'from' => $act, 'to' => ''));
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$prev_balance = get_bank_balance_to($from, $account["id"]);
$trans = get_bank_transactions($from, $to, $account['id']);
$rows = db_num_rows($trans);
if ($prev_balance != 0.0 || $rows != 0) {
$rep->Font('bold');
$rep->TextCol(0, 3, $act);
$rep->TextCol(3, 5, _('Opening Balance'));
if ($prev_balance > 0.0) {
$rep->AmountCol(5, 6, abs($prev_balance), $dec);
} else {
$rep->AmountCol(6, 7, abs($prev_balance), $dec);
}
$rep->Font();
$total = $prev_balance;
$rep->NewLine(2);
$total_debit = $total_credit = 0;
if ($rows > 0) {
// Keep a running total as we loop through
// the transactions.
while ($myrow = db_fetch($trans)) {
if ($zero == 0 && $myrow['amount'] == 0.0) {
continue;
}
$total += $myrow['amount'];
$rep->TextCol(0, 1, $systypes_array[$myrow["type"]]);
$rep->TextCol(1, 2, $myrow['trans_no']);
$rep->TextCol(2, 3, $myrow['ref']);
$rep->DateCol(3, 4, $myrow["trans_date"], true);
$rep->TextCol(4, 5, payment_person_name($myrow["person_type_id"], $myrow["person_id"], false));
if ($myrow['amount'] > 0.0) {
$rep->AmountCol(5, 6, abs($myrow['amount']), $dec);
$total_debit += abs($myrow['amount']);
} else {
$rep->AmountCol(6, 7, abs($myrow['amount']), $dec);
$total_credit += abs($myrow['amount']);
}
$rep->AmountCol(7, 8, $total, $dec);
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->NewPage();
}
}
$rep->NewLine();
}
// Print totals for the debit and credit columns.
$rep->TextCol(3, 5, _("Total Debit / Credit"));
$rep->AmountCol(5, 6, $total_debit, $dec);
$rep->AmountCol(6, 7, $total_credit, $dec);
$rep->NewLine(2);
$rep->Font('bold');
$rep->TextCol(3, 5, _("Ending Balance"));
if ($total > 0.0) {
$rep->AmountCol(5, 6, abs($total), $dec);
} else {
$rep->AmountCol(6, 7, abs($total), $dec);
}
$rep->Font();
$rep->Line($rep->row - $rep->lineHeight + 4);
$rep->NewLine(2, 1);
// Print the difference between starting and ending balances.
$net_change = $total - $prev_balance;
$rep->TextCol(3, 5, _("Net Change"));
if ($total > 0.0) {
$rep->AmountCol(5, 6, $net_change, $dec, 0, 0, 0, 0, null, 1, True);
} else {
$rep->AmountCol(6, 7, $net_change, $dec, 0, 0, 0, 0, null, 1, True);
}
}
$rep->End();
}
function print_bank_transactions()
{
global $path_to_root, $systypes_array;
$acc = $_POST['PARAM_0'];
$from = $_POST['PARAM_1'];
$to = $_POST['PARAM_2'];
$comments = $_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";
}
$rep = new FrontReport(_('Bank Statement'), "BankStatement", user_pagesize(), 9, "L");
$dec = user_price_dec();
$cols = array(0, 90, 110, 170, 225, 450, 500, 550, 600, 660, 700);
$aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right', 'right', 'center', 'left');
$headers = array(_('Type'), _('#'), _('Reference'), _('Date'), _('Person/Item'), _('Debit'), _('Credit'), _('Balance'), _('Reco Date'), _('Narration'));
$account = get_bank_account($acc);
$act = $account['bank_account_name'] . " - " . $account['bank_curr_code'] . " - " . $account['bank_account_number'];
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Bank Account'), 'from' => $act, 'to' => ''));
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$prev_balance = get_bank_balance_to($from, $account["id"]);
$trans = get_bank_transactions($from, $to, $account['id']);
$rows = db_num_rows($trans);
if ($prev_balance != 0.0 || $rows != 0) {
$rep->Font('bold');
$rep->TextCol(0, 3, $act);
$rep->TextCol(3, 5, _('Opening Balance'));
if ($prev_balance > 0.0) {
$rep->AmountCol(5, 6, abs($prev_balance), $dec);
} else {
$rep->AmountCol(6, 7, abs($prev_balance), $dec);
}
$rep->Font();
$total = $prev_balance;
$rep->NewLine(2);
if ($rows > 0) {
// Keep a running total as we loop through
// the transactions.
$total_debit = $total_credit = 0;
while ($myrow = db_fetch($trans)) {
$total += $myrow['amount'];
$rep->TextCol(0, 1, $systypes_array[$myrow["type"]]);
$rep->TextCol(1, 2, $myrow['trans_no']);
$rep->TextCol(2, 3, $myrow['ref']);
$rep->DateCol(3, 4, $myrow["trans_date"], true);
$rep->TextCol(4, 5, payment_person_name($myrow["person_type_id"], $myrow["person_id"], false));
if ($myrow['amount'] > 0.0) {
$rep->AmountCol(5, 6, abs($myrow['amount']), $dec);
$total_debit += abs($myrow['amount']);
} else {
$rep->AmountCol(6, 7, abs($myrow['amount']), $dec);
$total_credit += abs($myrow['amount']);
}
$rep->AmountCol(7, 8, $total, $dec);
if ($myrow["reconciled"] && $myrow["reconciled"] != '0000-00-00') {
$rep->DateCol(8, 9, $myrow["reconciled"], true);
}
$rep->TextCol(9, 10, $myrow['memo_']);
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->NewPage();
}
}
$rep->NewLine();
}
// Print totals for the debit and credit columns.
$rep->TextCol(3, 5, _("Total Debit / Credit"));
$rep->AmountCol(5, 6, $total_debit, $dec);
$rep->AmountCol(6, 7, $total_credit, $dec);
$rep->NewLine(2);
$rep->Font('bold');
$rep->TextCol(3, 5, _("Ending Balance"));
if ($total > 0.0) {
$rep->AmountCol(5, 6, abs($total), $dec);
} else {
$rep->AmountCol(6, 7, abs($total), $dec);
}
$rep->Font();
$rep->NewLine(2);
// Print the difference between starting and ending balances.
$net_change = $total - $prev_balance;
$rep->TextCol(3, 5, _("Net Change"));
if ($total > 0.0) {
$rep->AmountCol(5, 6, $net_change, $dec, 0, 0, 0, 0, null, 1, True);
} else {
$rep->AmountCol(6, 7, $net_change, $dec, 0, 0, 0, 0, null, 1, True);
}
$rep->Font();
$rep->NewLine(2);
// Calculate Bank Balance as per reco
$date = date2sql($to);
$sql = "SELECT SUM(IF(reconciled<='{$date}' AND reconciled !='0000-00-00', amount, 0)) as reconciled,\n\t\t\t\t SUM(amount) as books_total\n\t\t\tFROM " . TB_PREF . "bank_trans trans\n\t\t\tWHERE bank_act=" . db_escape($account['id']) . "\n\t\t\tAND trans_date <= '{$date}'";
// ." AND trans.reconciled IS NOT NULL";
//display_notification($sql);
$t_result = db_query($sql, "Cannot retrieve reconciliation data");
if ($t_row = db_fetch($t_result)) {
$books_total = $t_row['books_total'];
$reconciled = $t_row['reconciled'];
}
$difference = $books_total - $reconciled;
// Bank Balance (by Reco)
$rep->Font('bold');
$rep->TextCol(3, 5, _("Bank Balance"));
if ($reconciled > 0.0) {
$rep->AmountCol(5, 6, abs($reconciled), $dec);
} else {
$rep->AmountCol(6, 7, abs($reconciled), $dec);
}
$rep->Font();
$rep->NewLine(2);
// Reco Difference
$rep->Font('bold');
$rep->TextCol(3, 5, _("Difference"));
if ($difference > 0.0) {
$rep->AmountCol(5, 6, abs($difference), $dec);
} else {
$rep->AmountCol(6, 7, abs($difference), $dec);
}
$rep->Font();
$rep->NewLine(2);
$rep->Line($rep->row - $rep->lineHeight + 4);
$rep->NewLine(2, 1);
}
$rep->End();
}
function print_inventory_sales()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$destination = $_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, 400, 450, 500, 550, 600, 650, 700, 750, 800, 850, 900, 950, 1000, 1050, 1100, 1150, 1200);
$headers = array(_('DATE'), _('PAYEES'), _('PARTICULARS'), _('GV NO'), _('CHECK NO'), _('CASH IN'), _('PURCHASES'), _('SALARIES &'), _('SUPPLIES'), _('GASOLINE &'), _('LIGHT &'), _('TELECOMS'), _('REPAIRS'), _('REPRESENTATION'), _('TRANSPORTATION'), _('POSTAGE'), _('AD &'), _('PROF.'), _('INSURANCE'), _('CASH'), _('SUNDRY'), _('DEBIT'), _('CREDIT'));
$header2 = array(_(''), '', '', '', _(''), _('BANK'), _(''), _('WAGES'), _(''), _('OIL'), _('WATER'), _(''), _('& MAINT.'), _('EXPENSE'), _('EXPENSE'), _('& COURIER'), _('PROMO'), _('FEES'), _(''), _('ADVANCE'), _('ACCOUNTS'));
$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(_('Cash Disbursement Summary'), "CashDisbursementSummary", user_pagesize(), 8, 'L');
$rep->Font();
$rep->Info($params, $cols, $header2, $aligns, $cols, $headers, $aligns);
$rep->NewPage();
$salary = '6-1010';
$purchase = '5-1010';
$supplies = '6-1175';
$gas_oil = '6-1110';
$light_water = '6-1075';
$tel = '6-1080';
$repair = '6-1085';
$representation = '6-1055';
$transport = '6-1070';
$postage = '6-1155';
$ad_promo = '6-1230';
$prof_fee = '6-1185';
$insurance = '6-1105';
$cash_advance = '1-2045';
$petty_cash = '1-1010';
$res = getTransactions($from, $to);
$previous = '';
$var = array($salary, $purchase, $gas_oil, $light_water, $tel, $repair, $representation, $transport, $postage, $ad_promo, $prof_fee, $insurance, $cash_advance);
$total = 0;
$purchase_total = 0;
$sal_total = 0;
$sup_total = 0;
$gas_total = 0;
$light_total = 0;
$tel_total = 0;
$repair_total = 0;
$rep_total = 0;
$trans_total = 0;
$post_total = 0;
$ad_total = 0;
$prof_total = 0;
$ins_total = 0;
$adv_total = 0;
$dr = 0;
$cr = 0;
$sun_bank_name = '';
$sun_bank_amount = '';
while ($myrow = db_fetch($res)) {
$check = $myrow['customized_no'];
$current = $check;
$name = payment_person_name($myrow["person_type_id"], $myrow["person_id"]);
$comment = get_comments_string($myrow['type'], $myrow['type_no']);
$account_name = get_gl_account_name($myrow['account']);
//$rep->NewLine();
if ($current != '') {
if ($previous == $current) {
if ($myrow['type'] == '') {
if (is_bank_account($myrow['account'])) {
if ($myrow['account'] != $petty_cash) {
$rep->AmountCol(5, 6, abs($myrow['amount']), 2);
$total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $purchase) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(6, 7, abs($myrow['amount']), 2);
$purchase_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $salary) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(7, 8, abs($myrow['amount']), 2);
$sal_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $supplies) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(8, 9, abs($myrow['amount']), 2);
$sup_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $gas_oil) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(9, 10, abs($myrow['amount']), 2);
$gas_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $light_water) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(10, 11, abs($myrow['amount']), 2);
$light_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $tel) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(11, 12, abs($myrow['amount']), 2);
$tel_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $repair) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(12, 13, abs($myrow['amount']), 2);
$repair_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $representation) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(13, 14, abs($myrow['amount']), 2);
$rep_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $transport) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(14, 15, abs($myrow['amount']), 2);
$trans_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $postage) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(15, 16, abs($myrow['amount']), 2);
$post_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $ad_promo) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(16, 17, abs($myrow['amount']), 2);
$ad_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $prof_fee) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(17, 18, abs($myrow['amount']), 2);
$prof_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $insurance) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(18, 19, abs($myrow['amount']), 2);
$ins_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $cash_advance) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(19, 20, abs($myrow['amount']), 2);
$adv_total += abs($myrow['amount']);
}
}
}
} else {
if ($sun_bank_amount != 0 && $sun_bank_name != '') {
$rep->TextCol(20, 21, $account_name);
$rep->AmountCol(21, 22, $myrow['amount'], 2);
$rep->NewLine();
}
$result = get_sundry($previous);
$ctr = 0;
while ($row = db_fetch($result)) {
if ($row['type'] == "") {
if (!is_bank_account($row['account'])) {
$yes = check_account($row['account'], $row['amount']);
if ($yes) {
// $rep->TextCol(22, 23, $check_account($row['account']));
$ctr++;
if ($ctr > 1) {
$rep->NewLine();
}
$account_name2 = get_gl_account_name($row['account']);
$rep->TextCol(20, 21, $account_name2);
if ($row['amount'] > 0) {
$rep->AmountCol(21, 22, $row['amount'], 2);
$dr += abs($myrow['amount']);
} else {
$rep->AmountCol(22, 23, abs($row['amount']), 2);
$cr += abs($myrow['amount']);
}
}
}
}
}
$rep->NewLine();
if ($myrow['type'] == '') {
$rep->TextCol(0, 1, $myrow['tranDate']);
$rep->TextCol(1, 2, $name);
$rep->TextCol(2, 3, $comment);
$rep->TextCol(3, 4, $myrow['customized_no']);
$rep->TextCol(4, 5, $myrow['check_num']);
if (is_bank_account($myrow['account'])) {
if ($myrow['account'] != $petty_cash) {
$rep->AmountCol(5, 6, abs($myrow['amount']), 2);
$total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $purchase) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(6, 7, abs($myrow['amount']), 2);
$purchase_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $salary) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(7, 8, abs($myrow['amount']), 2);
$sal_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $supplies) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(8, 9, abs($myrow['amount']), 2);
$sup_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $gas_oil) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(9, 10, abs($myrow['amount']), 2);
$gas_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $light_water) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(10, 11, abs($myrow['amount']), 2);
$light_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $tel) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(11, 12, abs($myrow['amount']), 2);
$tel_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $repair) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(12, 13, abs($myrow['amount']), 2);
$repair_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $representation) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(13, 14, abs($myrow['amount']), 2);
$rep_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $transport) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(14, 15, abs($myrow['amount']), 2);
$trans_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $postage) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(15, 16, abs($myrow['amount']), 2);
$post_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $ad_promo) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(16, 17, abs($myrow['amount']), 2);
$ad_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $prof_fee) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(17, 18, abs($myrow['amount']), 2);
$prof_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $insurance) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(18, 19, abs($myrow['amount']), 2);
$ins_total += abs($myrow['amount']);
}
}
if ($myrow['account'] == $cash_advance) {
if ($myrow['amount'] > 0) {
$rep->AmountCol(19, 20, abs($myrow['amount']), 2);
$adv_total += abs($myrow['amount']);
}
}
} else {
$rep->TextCol(0, 1, $myrow['tranDate']);
$rep->TextCol(1, 2, "Cancelled");
$rep->TextCol(2, 3, "");
$rep->TextCol(3, 4, $myrow['customized_no']);
$rep->TextCol(4, 5, $myrow['check_num']);
}
}
$previous = $current;
}
}
$rep->NewLine();
$rep->Font('bold');
$rep->AmountCol(5, 6, $total, 2);
$rep->AmountCol(6, 7, $purchase_total, 2);
$rep->AmountCol(7, 8, $sal_total, 2);
$rep->AmountCol(8, 9, $sup_total, 2);
$rep->AmountCol(9, 10, $gas_total, 2);
$rep->AmountCol(10, 11, $light_total, 2);
$rep->AmountCol(11, 12, $tel_total, 2);
$rep->AmountCol(12, 13, $repair_total, 2);
$rep->AmountCol(13, 14, $rep_total, 2);
$rep->AmountCol(14, 15, $trans_total, 2);
$rep->AmountCol(15, 16, $post_total, 2);
$rep->AmountCol(16, 17, $ad_total, 2);
$rep->AmountCol(17, 18, $prof_total, 2);
$rep->AmountCol(18, 19, $ins_total, 2);
$rep->AmountCol(19, 20, $adv_total, 2);
$rep->AmountCol(21, 22, $dr, 2);
$rep->AmountCol(22, 23, $cr, 2);
/* $i = 0;
$k = 1;
foreach($var as $vars)
{
$tots = getTotal($vars);
$rep->AmountCol($i, $k, $tots, 2);
$i++;
$j++;
}*/
$rep->End();
}
function print_tax_details_cash()
{
global $path_to_root, $systypes_array;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$net = $_POST['PARAM_2'];
$comments = $_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";
}
$rep = new FrontReport(_('Tax Details (Cash Basis)'), "TaxDetails", user_pagesize(), 9, "L");
$dec = user_price_dec();
$cols = array(0, 100, 170, 250, 310, 485, 550, 700);
$aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right');
if (!$net) {
$grossAmount = _('Gross');
} else {
$grossAmount = _('Net');
}
$headers = array(_('Type'), _('Ref'), _('#'), _('Date'), _('Payer/Payee'), _('Tax Amount'), $grossAmount . ' ' . _('Output/Input'));
if (!$net) {
$grossAmount = _('Gross Amounts');
} else {
$grossAmount = _('Net Amounts');
}
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Output/input'), 'from' => $grossAmount, 'to' => ''));
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$trans = get_tax_cash_details($from, $to);
$rows = db_num_rows($trans);
$rep->Font();
if ($rows > 0) {
// Keep a running total as we loop through
// the transactions.
$subTotalTax = 0;
$subTotalGross = 0;
$total = 0;
$lastTaxType = '';
$lastOutput = '';
$lastRate = 0;
while ($myrow = db_fetch($trans)) {
$taxType = $myrow["name"];
$output = $myrow["Output"];
if ($taxType != $lastTaxType || $output != $lastOutput) {
if ($lastTaxType != '') {
print_tax_details_cash_subtotals($rep, $lastOutput, $lastTaxType, $lastRate, $subTotalTax, $subTotalGross);
}
$lastOutput = $output;
$lastTaxType = $taxType;
$lastRate = $myrow['rate'];
$subTotalTax = 0;
$subTotalGross = 0;
}
$rep->TextCol(0, 1, $systypes_array[$myrow["type"]], -2);
$reference = get_reference($myrow["type"], $myrow["trans_no"]);
$rep->TextCol(1, 2, $reference);
$rep->TextCol(2, 3, $myrow["trans_no"]);
$rep->DateCol(3, 4, $myrow["trans_date"], true);
$rep->TextCol(4, 5, payment_person_name($myrow["person_type_id"], $myrow["person_id"], false));
if ($output == "Output") {
$payable = $myrow['payable'];
if (!$net) {
$amount = $myrow['gross_output'];
} else {
$amount = $myrow['net_output'];
}
$rep->AmountCol(5, 6, $payable, $dec);
$subTotalTax += $payable;
$total += $payable;
$rep->AmountCol(6, 7, $amount, $dec);
$subTotalGross += $amount;
} else {
$collectible = $myrow['collectible'];
if (!$net) {
$amount = $myrow['gross_input'];
} else {
$amount = $myrow['net_input'];
}
$rep->AmountCol(5, 6, $collectible, $dec);
$subTotalTax += $collectible;
$total += $collectible;
$rep->AmountCol(6, 7, $amount, $dec);
$subTotalGross += $amount;
}
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->NewPage();
}
}
// Print totals
print_tax_details_cash_subtotals($rep, $lastOutput, $lastTaxType, $lastRate, $subTotalTax, $subTotalGross);
$rep->Font('bold');
$rep->TextCol(4, 5, _("Total Payable or Refund"));
$rep->AmountCol(5, 6, $total, $dec);
$rep->NewLine(2);
$rep->Font();
$rep->NewLine(2);
}
$rep->End();
}
function print_list_of_journal_entries()
{
global $path_to_root, $systypes_array;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$systype = $_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();
$cols = array(0, 100, 240, 300, 400, 460, 520, 580);
$headers = array(_('Type/Account'), _('Reference') . '/' . _('Account Name'), _('Date/Dim.'), _('Person/Item/Memo'), _('Debit'), _('Credit'));
$aligns = array('left', 'left', 'left', 'left', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Type'), 'from' => $systype == -1 ? _('All') : $systypes_array[$systype], 'to' => ''));
$rep = new FrontReport(_('List of Journal Entries'), "JournalEntries", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
if ($systype == -1) {
$systype = null;
}
$trans = get_gl_transactions($from, $to, -1, null, 0, 0, $systype);
$typeno = $type = 0;
$debit = $credit = 0.0;
$totdeb = $totcre = 0.0;
while ($myrow = db_fetch($trans)) {
if ($type != $myrow['type'] || $typeno != $myrow['type_no']) {
if ($typeno != 0) {
$rep->Line($rep->row += 6);
$rep->NewLine();
$rep->AmountCol(4, 5, $debit, $dec);
$rep->AmountCol(5, 6, abs($credit), $dec);
$totdeb += $debit;
$totcre += $credit;
$debit = $credit = 0.0;
$rep->Line($rep->row -= 4);
$rep->NewLine();
}
$typeno = $myrow['type_no'];
$type = $myrow['type'];
$TransName = $systypes_array[$myrow['type']];
$rep->TextCol(0, 1, $TransName . " # " . $myrow['type_no']);
$rep->TextCol(1, 2, get_reference($myrow['type'], $myrow['type_no']));
$rep->DateCol(2, 3, $myrow['tran_date'], true);
$coms = payment_person_name($myrow["person_type_id"], $myrow["person_id"]);
$memo = get_comments_string($myrow['type'], $myrow['type_no']);
if ($memo != '') {
if ($coms == "") {
$coms = $memo;
} else {
$coms .= " / " . $memo;
}
}
$rep->TextColLines(3, 6, $coms);
$rep->NewLine();
}
$rep->TextCol(0, 1, $myrow['account']);
$rep->TextCol(1, 2, $myrow['account_name']);
$dim_str = get_dimension_string($myrow['dimension_id']);
$dim_str2 = get_dimension_string($myrow['dimension2_id']);
if ($dim_str2 != "") {
$dim_str .= "/" . $dim_str2;
}
$rep->TextCol(2, 3, $dim_str);
$rep->TextCol(3, 4, $myrow['memo_']);
if ($myrow['amount'] > 0.0) {
$debit += $myrow['amount'];
$rep->AmountCol(4, 5, abs($myrow['amount']), $dec);
} else {
$credit += $myrow['amount'];
$rep->AmountCol(5, 6, abs($myrow['amount']), $dec);
}
$rep->NewLine(1, 2);
}
if ($typeno != 0) {
$rep->Line($rep->row += 6);
$rep->NewLine();
$rep->AmountCol(4, 5, $debit, $dec);
$rep->AmountCol(5, 6, abs($credit), $dec);
$totdeb += $debit;
$totcre += $credit;
$rep->Line($rep->row -= 4);
$rep->NewLine();
$rep->TextCol(0, 4, _("Total"));
$rep->AmountCol(4, 5, $totdeb, $dec);
$rep->AmountCol(5, 6, abs($totcre), $dec);
$rep->Line($rep->row -= 4);
}
$rep->End();
}
function print_subsidiary_ledger()
{
global $path_to_root, $systypes_array;
$dim = get_company_pref('use_dimension');
$dimension = $dimension2 = 0;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$fromacc = $_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_report2.inc";
}
$orientation = $orientation ? 'L' : 'P';
$rep = new FrontReport(_('Subsidiary Ledger Report'), "SubsidiaryLedger", user_pagesize(), 9, $orientation);
$dec = user_price_dec();
//$headers = array(_('Type'), _('Ref'), _('#'), _('Date'), _('Dimension')." 1", _('Dimension')." 2",
// _('Person/Item'), _('Debit'), _('Credit'), _('Balance'));
//$cols = array(0, 80, 100, 150, 210, 280, 340, 400, 450, 510, 570);
$cols = array(0, 65, 105, 125, 175, 230, 290, 345, 405, 465, 525);
//------------0--1---2---3----4----5----6----7----8----9----10-------
//-----------------------dim1-dim2-----------------------------------
//-----------------------dim1----------------------------------------
//-------------------------------------------------------------------
$aligns = array('left', 'left', 'left', 'center', 'left', 'left', 'left', 'right', 'right', 'right', 'right');
$headers = array(_('Account Name'), '', '', '', '', '', _('Debit'), _('Credit'), '', _('Balance'));
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Accounts'), 'from' => $fromacc, 'to' => $fromacc));
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->SetHeaderType('Header_custom');
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$accounts = get_gl_accounts($fromacc, $fromacc);
while ($account = db_fetch($accounts)) {
if (is_account_balancesheet($account["account_code"])) {
$begin = "";
} else {
$begin = get_fiscalyear_begin_for_date($from);
if (date1_greater_date2($begin, $from)) {
$begin = $from;
}
$begin = add_days($begin, -1);
}
$prev_balance = get_gl_balance_from_to($begin, $from, $account["account_code"], $dimension, $dimension2);
$trans = get_gl_transactions($from, $to, -1, $account['account_code'], $dimension, $dimension2);
$rows = db_num_rows($trans);
if ($prev_balance == 0.0 && $rows == 0) {
continue;
}
$rep->Font('bold');
$rep->TextCol(0, 4, $account['account_code'] . " " . $account['account_name'], -2);
$rep->TextCol(4, 6, _('Opening Balance'));
if ($prev_balance > 0.0) {
$rep->AmountCol(7, 8, abs($prev_balance), $dec);
} else {
$rep->AmountCol(8, 9, abs($prev_balance), $dec);
}
$rep->Font();
$total = $prev_balance;
$rep->NewLine(2);
if ($rows > 0) {
$previous = '';
while ($myrow = db_fetch($trans)) {
$total += $myrow['amount'];
$txt = payment_person_name($myrow["person_type_id"], $myrow["person_id"], false);
$current = $txt;
$memo = $myrow['memo_'];
if ($txt != "") {
if ($previous == $current) {
$txt = '';
} else {
$rep->NewLine(1);
$rep->Line($rep->row - $rep->lineHeight + 4);
$rep->NewLine(2, 0);
$rep->TextCol(3, 8, $txt, -2);
$rep->Line($rep->row - $rep->lineHeight + 4);
$rep->NewLine(2, 1);
$rep->NewLine(1);
}
$previous = $current;
}
$rep->TextCol(0, 3, $systypes_array[$myrow["type"]], -2);
$rep->DateCol(4, 6, $myrow["tran_date"], true);
if ($myrow['amount'] > 0.0) {
$rep->AmountCol(6, 7, abs($myrow['amount']), $dec);
} else {
$rep->AmountCol(7, 8, abs($myrow['amount']), $dec);
}
$rep->TextCol(8, 10, number_format2($total, $dec));
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->NewPage();
}
}
$rep->NewLine();
}
$rep->Font('bold');
$rep->TextCol(4, 6, _("Ending Balance"));
if ($total > 0.0) {
$rep->AmountCol(7, 8, abs($total), $dec);
} else {
$rep->AmountCol(8, 9, abs($total), $dec);
}
$rep->Font();
}
$rep->End();
}
function print_check_voucher()
{
global $path_to_root, $systypes_array;
$trans_no = $_POST['PARAM_0'];
$trans_num = $_POST['PARAM_1'];
$cv_no = $_POST['PARAM_2'];
$account = $_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_report2.inc";
}
$orientation = $orientation ? 'L' : 'P';
$rep = new FrontReport(_('CHECK VOUCHER'), "CheckVoucher", user_pagesize(), '', $orientation);
$dec = user_price_dec();
$cols = array(0, 30, 50, 125, 175, 200, 265, 285, 360, 425, 460, 542, 550);
$aligns = array('left', 'left', 'left', 'left', 'right', 'right', 'left', 'left', 'right', 'right', 'right');
$rep->SetHeaderType(0);
$rep->Font();
$rep->Info(null, $cols, null, $aligns);
$rep->NewPage();
$ty = explode("-", $trans_no);
$t_type = $ty[1];
if ($t_type != 0) {
$res = get_transaction($trans_no, $t_type);
$res1 = get_heading($trans_no, $t_type);
} else {
$res = get_transaction($trans_no, ST_DISBURSEMENT);
$res1 = get_heading($trans_no, ST_DISBURSEMENT);
}
$myrow = db_fetch($res);
$myrow1 = db_fetch($res1);
$credit = $debit = 0;
//$transtype = ST_DISBURSEMENT;
if ($t_type != 0 || $t_type != '') {
$res2 = get_gl_trans($t_type, $trans_num);
$res3 = get_gl_trans($t_type, $trans_num);
} else {
$res2 = get_gl_trans(ST_DISBURSEMENT, $trans_num);
$res3 = get_gl_trans(ST_DISBURSEMENT, $trans_num);
}
$new_ret = 0;
$return = 0;
//$fiscal = get_year(); //to be use
// $year_no = substr(sql2date($fiscal['begin']), 8); //to be use
// $ser = db_fetch(get_used_series($year_no, $transtype));
// $num = substr($ser['year'], 2);
/* $rep->Font('bold');
$rep->TextCol(7,11, _("ST. MATTHEW'S PUBLISHING CORPORATION"));
$rep->Font();
$rep->NewLine();
$rep->TextCol(7,11, _("Tel. Nos. 426-5611 * 433-5385 Telefax: 426-1274"));
$rep->NewLine(3);
$rep->Font('bold');
$rep->SetFontSize(14);
$rep->TextCol(5,8, _("CHECK VOUCHER"));*/
$rep->NewLine(7);
$rep->SetFontSize(12);
$num = substr($myrow['yearDate'], 2);
$name = payment_person_name($myrow["person_type_id"], $myrow["person_id"]);
$rep->TextCol(2, 6, $name);
$rep->TextCol(9, 11, $num . "-" . str_pad($myrow1['customized_no'], 4, 0, STR_PAD_LEFT));
$rep->NewLine();
if ($myrow1['customized_field'] != 0 || $myrow1['customized_field'] != '') {
$rep->TextCol(0, 4, $myrow1['customized_field']);
} else {
$rep->TextCol(0, 4, _(""));
}
$rep->NewLine(1);
$rep->TextCol(8, 10, $myrow['sqldate']);
$rep->NewLine(5);
// $rep->Line($rep->row - -10);
// $rep->TextCol(4,6, _("PARTICULARS"));
// $rep->TextCol(9,10, _("AMOUNT"));
// $rep->Line($rep->row - 4);
$var = array();
$pos = array();
$neg = array();
$pos_amt = array();
$neg_amt = array();
$tots = 0;
$comment = get_comments_string($cv_no, $trans_num);
while ($myrow2 = db_fetch($res2)) {
$tots = 0;
if (is_bank_account($myrow2['account'])) {
$var = array($myrow2['account']);
$rep->TextCol(1, 8, $comment);
$tots += abs($myrow2['amount']);
}
}
$rep->AmountCol(9, 11, $tots, 2);
$rep->NewLine(2);
// $rep->Line($rep->row - -10);
// $rep->TextCol(1,3, _("DEBIT"));
// $rep->TextCol(7,8, _("CREDIT"));
// $rep->Line($rep->row - 4);
$rep->NewLine(5);
$rep->SetFontSize(12);
while ($myrow3 = db_fetch($res3)) {
$accounts = get_gl_accounts($myrow3['account']);
$account = db_fetch($accounts);
if ($myrow3['amount'] > 0) {
// $rep->Line($rep->row - -10);
//$rep->TextCol(0,4, $account['account_name']);
// $rep->AmountCol(5,6, $myrow3['amount'],2);
// $rep->NewLine();
// $rep->Line($rep->row + 8);
array_push($pos, $account['account_name']);
array_push($pos_amt, $myrow3['amount']);
$debit += $myrow3['amount'];
} else {
array_push($neg, $account['account_name']);
array_push($neg_amt, $myrow3['amount']);
// $rep->Line($rep->row - 4);
// $rep->TextCol(6,8, $account['account_name']);
// $rep->AmountCol(9,11, abs($myrow3['amount']), 2);
// $rep->NewLine();
// $rep->Line($rep->row - 4);
}
}
$result = array_merge($pos, $neg);
$new = array();
for ($i = 0; $i < count($result); $i++) {
$new[] = $pos[$i];
$new[] = $neg[$i];
}
$result2 = array_merge($pos_amt, $neg_amt);
$new2 = array();
for ($j = 0; $j < count($result2); $j++) {
$new2[] = $pos_amt[$j];
$new2[] = $neg_amt[$j];
}
$final_res = array_merge($new, $new2);
$final_array = array();
$final = array();
for ($k = 0; $k < count($final_res); $k++) {
$final[] = $new[$k];
$final[] = $new2[$k];
}
$enter = 0;
for ($i = 0; $i <= count($final_res); $i++) {
//if ($final[$i] != 0)
//{
$rep->TextCol(0, 4, $pos[$i]);
if ($pos_amt[$i] != 0) {
$rep->AmountCol(4, 6, $pos_amt[$i], 2);
}
$rep->TextCol(7, 9, $neg[$i]);
if ($neg_amt[$i] != 0) {
$rep->AmountCol(9, 11, abs($neg_amt[$i]), 2);
}
if ($pos[$i] != "") {
$rep->NewLine();
$enter++;
}
// }
}
$return = 11 - $enter;
//$rep->Line($rep->row - 4);
$rep->NewLine($return);
//$rep->TextCol(0,2, count($final_res));
//$rep->TextCol(4,5, $enter);
//else
// $rep->NewLine($return);
$rep->SetFontSize(10);
// $rep->TextCol(0,2, _("Cash"));
$words = price_in_words($tots, ST_CHEQUE);
$_word = strlen($words);
$first_word = substr($words, 0, 34);
$second_word = substr($words, 34);
// if ($words != "")
// {
//$rep->TextCol(5,7, _("Received the sum of :"));
// $oldrow = $rep->row;
$rep->TextColLines(8, 11, $first_word . "-", -2);
//$newrow = $rep->row;
// $rep->row = $oldrow;
// }
$rep->SetFontSize(10);
$rep->TextCol(1, 3, $myrow1['check_num']);
$tots_dec = price_format($tots);
$rep->TextCol(3, 7, " " . $tots_dec);
$rep->SetFontSize(10);
$rep->TextCol(7, 11, $second_word);
//$rep->TextCol(7,10, _("as payment of the above particulars."));
$rep->NewLine();
$rep->SetFontSize(10);
//$rep->TextCol(0,10, _("Bank/Branch: "));
foreach ($var as $vars) {
// $bank_name = get_bank_name($vars);
$rep->TextCol(2, 10, get_bank_name($vars) . " ");
}
// $rep->TextCol(1,5, $myrow['bank_address']);
$rep->TextCol(7, 9, " " . $tots_dec);
$rep->End();
}
