function print_check_voucher() { global $path_to_root, $systypes_array; $trans_no = $_POST['PARAM_0']; $trans_num = $_POST['PARAM_1']; $orientation = $_POST['PARAM_2']; $destination = $_POST['PARAM_3']; if ($destination) { include_once $path_to_root . "/reporting/includes/excel_report.inc"; } else { include_once $path_to_root . "/reporting/includes/pdf_report2.inc"; } $orientation = $orientation ? 'L' : 'P'; $rep = new FrontReport(_('JOURNAL VOUCHER'), "JournalVoucher", user_pagesize(), 9, $orientation); $dec = user_price_dec(); $cols = array(0, 65, 105, 125, 175, 210, 250, 300, 360, 370); $aligns = array('left', 'left', 'left', 'center', 'right', 'right', 'right', 'right', 'right'); $rep->SetHeaderType(0); $rep->Font(); $rep->Info(null, $cols, null, $aligns); $rep->NewPage(); $res = get_transaction($trans_no); $myrow = db_fetch($res); $credit = $debit = 0; $res2 = get_gl_trans(0, $trans_num); $res3 = get_gl_trans(0, $trans_num); $fiscal = get_year(); //to be use $year_no = substr(sql2date($fiscal['begin']), 8); //to be use $transtype = ST_JOURNAL; $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(3,8, _("JOURNAL VOUCHER")); $rep->NewLine(5); $rep->SetFontSize(10); $rep->TextCol(0, 2, $myrow['tranDate']); $rep->SetFontSize(12); $rep->TextCol(6, 8, $num . "-" . str_pad($myrow['customized_no'], 4, 0, STR_PAD_LEFT)); $rep->NewLine(2); //$rep->Line($rep->row - -10); // $rep->TextCol(7,8, _("DEBIT")); //$rep->TextCol(9,10, _("CREDIT")); //$rep->TextCol(5,7, _("ACCOUNT CODE")); $rep->SetFontSize(10); $rep->Font(); //$rep->Line($rep->row - 4); $rep->NewLine(2); while ($myrow3 = db_fetch($res3)) { $accounts = get_gl_accounts($myrow3['account']); $account = db_fetch($accounts); if ($myrow3['amount'] > 0) { $rep->TextCol(0, 3, $account['account_name']); $rep->TextCol(4, 5, $account['account_code']); $rep->AmountCol(5, 7, $myrow3['amount'], 2); $rep->NewLine(); $debit += $myrow3['amount']; } else { $rep->TextCol(0, 3, $account['account_name']); $rep->TextCol(4, 5, $account['account_code']); $rep->AmountCol(7, 9, abs($myrow3['amount']), 2); $rep->NewLine(); $credit += abs($myrow3['amount']); } } // $rep->Line($rep->row - -4); $rep->NewLine(17); $rep->Font('bold'); //$rep->TextCol(0,4, _("Total")); $rep->AmountCol(5, 7, $debit, 2); $rep->AmountCol(7, 9, $credit, 2); $rep->NewLine(2); $rep->Font(); $comment = get_comments_string($transtype, $trans_num); $rep->TextCol(0, 9, $comment); // $rep->Line($rep->row - 4); $rep->End(); }
function print_voucher() { global $path_to_root, $systypes_array; $dim = get_company_pref('use_dimension'); $dimension = $dimension2 = 0; $voucher_no = $_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_report2.inc"; } $orientation = $orientation ? 'L' : 'P'; $rep = new FrontReport(_('COMMISSION VOUCHER'), "CommissionVoucherReport", user_pagesize(), 9, $orientation); $dec = user_price_dec(); $cols = array(-15, 20, 40, 60, 90, 150, 200, 225, 220, 465, 525); //------------0--1---2---3----4----5----6----7----8----9----10------- //-----------------------dim1-dim2----------------------------------- //-----------------------dim1---------------------------------------- //------------------------------------------------------------------- $aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right', 'right', 'right', 'right', 'right'); $headers = array('', _('Commission Voucher'), '', '', '', '', ''); if ($orientation == 'L') { recalculate_cols($cols); } $rep->SetHeaderType(0); $rep->Font(); $rep->Info(null, $cols, null, $aligns); $rep->NewPage(); $res = get_transaction($voucher_no); $myrow = db_fetch($res); $salesman = get_salesman_name($myrow['imc']); $client = get_customer_name($myrow['client']); $rep->Font('bold'); // $rep->TextCol(4,8, _("ST. MATTHEW'S PUBLISHING CORPORATION")); $rep->Font(); $rep->NewLine(); // $rep->TextCol(4,8, _("Tel. Nos. 426-5611 * 433-5385 Telefax: 426-1274")); $rep->NewLine(5); $rep->Font('bold'); $rep->SetFontSize(14); //$rep->TextCol(0,3, _("COMMISSION VOUCHER")); $rep->Font(); $rep->SetFontSize(10); $rep->NewLine(4); $netgross = $myrow['gross'] * ($myrow['commission'] / 100); //$rep->TextCol(8,9, _("Date:")); $rep->TextCol(5, 6, $myrow['Dated']); $year = substr($myrow['dateYear'], 2); $rep->TextCol(6, 7, $year); $rep->NewLine(1); $rep->TextCol(1, 4, $salesman); $rep->NewLine(3); //$rep->Line($rep->row - -10); //$rep->TextCol(2,5, _("EXPLANATION")); //$rep->TextCol(8,9, _("AMOUNT")); // $rep->Line($rep->row - 4); $rep->NewLine(2); $rep->SetFontSize('8'); $oldrow = $rep->row; $rep->TextColLines(2, 5, $client); $newrow = $rep->row; $rep->row = $oldrow; $rep->NewLine(3); $rep->SetFontSize('10'); //$rep->TextCol(8,9, _("Gross: ")); $rep->AmountCol(5, 7, $netgross, 2); $rep->NewLine(1); $rep->TextCol(2, 4, $myrow['commission']); $rep->AmountCol(5, 7, $myrow['with_tax'], 2); $rep->NewLine(2); $rep->TextCol(2, 4, $myrow['invoice_no']); $rep->NewLine(4); $rep->Font('bold'); $rep->AmountCol(5, 7, $myrow['net_commission'], 2); $rep->NewLine(); // $rep->Line($rep->row - 4); // $rep->Line($rep->row - 8); $rep->NewLine(3); $rep->Font(); $rep->SetFontSize('9'); //$rep->TextCol(1,4, _("Approved by:")); // $rep->TextCol(5,8, _("Received payment by:")); $rep->NewLine(2); $rep->TextCol(2, 4, _("Checked by:")); $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(); }