本文整理汇总了PHP中user_pagesize函数的典型用法代码示例。如果您正苦于以下问题:PHP user_pagesize函数的具体用法?PHP user_pagesize怎么用?PHP user_pagesize使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了user_pagesize函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: print_list_of_journal_entries
function print_list_of_journal_entries()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$from = $_REQUEST['PARAM_0'];
$to = $_REQUEST['PARAM_1'];
$systype = $_REQUEST['PARAM_2'];
$comments = $_REQUEST['PARAM_3'];
$dec = user_price_dec();
$cols = array(0, 100, 240, 300, 400, 460, 520, 580);
$headers = array(tr('Type/Account'), tr('Account Name'), tr('Date/Dim.'), tr('Person/Item/Memo'), tr('Debit'), tr('Credit'));
$aligns = array('left', 'left', 'left', 'left', 'right', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => tr('Type'), 'from' => systypes::name($systype), 'to' => ''));
$rep = new FrontReport(tr('List of Journal Entries'), "JournalEntries.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
if ($systype == -1) {
$systype = null;
}
$trans = get_gl_transactions($from, $to, -1, null, 0, $systype);
$typeno = 0;
while ($myrow = db_fetch($trans)) {
if ($typeno != $myrow['type_no']) {
if ($typeno != 0) {
$rep->Line($rep->row + 4);
$rep->NewLine();
}
$typeno = $myrow['type_no'];
$TransName = systypes::name($myrow['type']);
$rep->TextCol(0, 2, $TransName . " # " . $myrow['type_no']);
$rep->TextCol(2, 3, sql2date($myrow['tran_date']));
$coms = payment_person_types::person_name($myrow["person_type_id"], $myrow["person_id"]);
$memo = get_comments_string($myrow['type'], $myrow['type_no']);
if ($memo != '') {
$coms .= $coms != "" ? "/" : "" . $memo;
}
$rep->TextCol(3, 6, $coms);
$rep->NewLine(2);
}
$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) {
$rep->TextCol(4, 5, number_format2(abs($myrow['amount']), $dec));
} else {
$rep->TextCol(5, 6, number_format2(abs($myrow['amount']), $dec));
}
$rep->NewLine(1, 2);
}
$rep->Line($rep->row + 4);
$rep->End();
}
开发者ID:ravenii,项目名称:guardocs,代码行数:59,代码来源:rep702.php
示例2: print_purchases_cost
function print_purchases_cost()
{
global $path_to_root;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$destination = $_POST['PARAM_2'];
$orientation = $_POST['PARAM_3'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$dec = user_price_dec();
if ($category == ALL_NUMERIC) {
$category = 0;
}
if ($category == 0) {
$cat = _('All');
} else {
$cat = get_category_name($category);
}
$cols = array(0, 20, 55, 85, 125, 200, 230, 260, 290, 325, 350, 375, 425, 475);
//14 headers + 1 lagi dapat for cols
//todo: format date paid to 2 digits representation only i.e. 12/12/12
$headers = array(_('CV#'), _('Date Paid'), _('OR #'), _('Supplier'), _('Title of Book'), _('Quantity'), _('Unit Cost'), _('Amount'), _('With Tax'), _('Net'), _('PO #'), _('Stock Supplied'), _('Stock Amount'), _('Total Amount'));
//todo: Date Paid, OR(official receipt number) Amount, w/tax, net, Stock supplied, stock amount and total amount
// Possible tables to read on: grn_batch and grn_items
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left');
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Category'), 'from' => $cat, 'to' => ''));
$rep = new FrontReport(_('Summary of Purchases at Cost Report'), "SummaryPurchasesCostReport", user_pagesize(), 8, 'L');
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($from, $to);
$total = $grandtotal = 0.0;
$total1 = $grandtotal1 = 0.0;
$total2 = $grandtotal2 = 0.0;
$catt = '';
while ($trans = db_fetch($res)) {
$rep->NewLine();
$rep->fontSize -= 2;
$rep->TextCol(3, 4, $trans['supp_name']);
$rep->TextCol(4, 5, $trans['description']);
$rep->AmountCol(5, 6, $trans['quantity_ordered']);
$rep->AmountCol(6, 7, $trans['unit_price']);
$rep->AmountCol(10, 11, $trans['order_no']);
}
$rep->NewLine(2, 3);
$rep->TextCol(0, 4, _('Total'));
$rep->AmountCol(4, 5, $total, $dec);
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine(2, 1);
$rep->TextCol(0, 4, _('Grand Total'));
$rep->AmountCol(4, 5, $grandtotal, $dec);
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:59,代码来源:rep_purchases_cost_summary.php
示例3: print_work_order_listing
function print_work_order_listing()
{
global $path_to_root, $wo_types_array;
$item = $_POST['PARAM_0'];
$location = $_POST['PARAM_1'];
$open_only = $_POST['PARAM_2'];
$comments = $_POST['PARAM_3'];
$orientation = $_POST['PARAM_4'];
$destination = $_POST['PARAM_5'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
if ($item == '') {
$items = _('All');
} else {
$row = get_item($item);
$items = $row['description'];
}
if ($location == '') {
$loc = _('All');
} else {
$loc = get_location_name($location);
}
$open = $open_only == 1 ? _('Yes') : _('No');
$cols = array(0, 100, 120, 165, 210, 275, 315, 375, 385, 440, 495, 555);
$headers = array(_('Type'), '#', 'Reference', _('Location'), _('Item'), _('Required'), _('Manufactured'), ' ', _('Date'), _('Required By'), _('Closed'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right', 'left', 'left', 'left', 'left');
$params = array(0 => $comments, 1 => array('text' => _('Items'), 'from' => $items, 'to' => ''), 2 => array('text' => _('Location'), 'from' => $loc, 'to' => ''), 3 => array('text' => _('Open Only'), 'from' => $open, 'to' => ''));
$rep = new FrontReport(_('Work Order Listing'), "WorkOrderListing", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($item, $open_only, $location);
while ($trans = db_fetch($res)) {
$rep->TextCol(0, 1, $wo_types_array[$trans['type']]);
$rep->TextCol(1, 2, $trans['id'], -1);
$rep->TextCol(2, 3, $trans['wo_ref'], -1);
$rep->TextCol(3, 4, $trans['location_name'], -1);
$rep->TextCol(4, 5, $trans['description'], -1);
$dec = get_qty_dec($trans['stock_id']);
$rep->AmountCol(5, 6, $trans['units_reqd'], $dec);
$rep->AmountCol(6, 7, $trans['units_issued'], $dec);
$rep->TextCol(7, 8, '', -1);
$rep->TextCol(8, 9, sql2date($trans['date_']), -1);
$rep->TextCol(9, 10, sql2date($trans['required_by']), -1);
$rep->TextCol(10, 11, $trans['closed'] ? ' ' : _('No'), -1);
$rep->NewLine();
}
$rep->Line($rep->row);
$rep->End();
}
开发者ID:M-Shahbaz,项目名称:FA,代码行数:57,代码来源:rep402.php
示例4: print_Chart_of_Accounts
function print_Chart_of_Accounts()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$showbalance = $_REQUEST['PARAM_0'];
$comments = $_REQUEST['PARAM_1'];
$dec = 0;
$cols = array(0, 50, 300, 425, 500);
$headers = array(tr('Account'), tr('Account Name'), tr('Account Code'), tr('Balance'));
$aligns = array('left', 'left', 'left', 'right');
$params = array(0 => $comments);
$rep = new FrontReport(tr('Chart of Accounts'), "ChartOfAccounts.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
$classname = '';
$group = '';
$accounts = get_gl_accounts_all();
while ($account = db_fetch($accounts)) {
if ($showbalance == 1) {
$begin = begin_fiscalyear();
if (is_account_balancesheet($account["account_code"])) {
$begin = "";
}
$balance = get_gl_trans_from_to($begin, ToDay(), $account["account_code"], 0);
}
if ($account['AccountTypeName'] != $group) {
if ($classname != '') {
$rep->row -= 4;
}
if ($account['AccountClassName'] != $classname) {
$rep->Font('bold');
$rep->TextCol(0, 4, $account['AccountClassName']);
$rep->Font();
$rep->row -= $rep->lineHeight + 4;
}
$group = $account['AccountTypeName'];
$rep->TextCol(0, 4, $account['AccountTypeName']);
//$rep->Line($rep->row - 4);
$rep->row -= $rep->lineHeight + 4;
}
$classname = $account['AccountClassName'];
$rep->TextCol(0, 1, $account['account_code']);
$rep->TextCol(1, 2, $account['account_name']);
$rep->TextCol(2, 3, $account['account_code2']);
if ($showbalance == 1) {
$rep->TextCol(3, 4, number_format2($balance, $dec));
}
$rep->NewLine();
if ($rep->row < $rep->bottomMargin + 3 * $rep->lineHeight) {
$rep->Line($rep->row - 2);
$rep->Header();
}
}
$rep->Line($rep->row);
$rep->End();
}
开发者ID:ravenii,项目名称:guardocs,代码行数:57,代码来源:rep701.php
示例5: print_royalty_sales
function print_royalty_sales()
{
$item_id = $_POST['PARAM_0'];
global $path_to_root, $systypes_array;
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$result = fetchRoyalty($item_id);
$name = "";
while ($book = db_fetch($result)) {
$name = $book[1];
}
$params = array(0 => $comments, 1 => array('text' => _('Item'), 'from' => $name));
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$cols = array(0, 150, 250, 350, 450);
$headers = array(_('Name'), _('ID #'), _('Date'), _('Quantity'), _('Status'));
$aligns = array('left', 'left', 'left', 'left', 'left');
$usr = get_user($user);
$user_id = $usr['user_id'];
$rep = new FrontReport(_('Royalty Sales'), "RoyaltySales", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->SetHeaderType('Header');
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$rep->TextCol(0, 1, $item_id);
$rep->TextCol(2, 4, fetchTitle($item_id));
$rep->NewLine();
$rep->NewLine();
$result = fetchRoyalty($item_id);
while ($myrow = db_fetch($result)) {
$rep->TextCol(0, 1, $myrow[0]);
$rep->TextCol(1, 2, ' ' . $myrow[1]);
$rep->TextCol(2, 3, $myrow[2]);
$rep->TextCol(3, 4, $myrow[3]);
$rep->TextCol(4, 5, 'Closed');
$rep->NewLine();
}
$result1 = fetchCreditMemo($item_id);
while ($myrow1 = db_fetch($result1)) {
if ($myrow1[3] > 0) {
$rep->TextCol(0, 1, $myrow1[0]);
$rep->TextCol(1, 2, ' ' . $myrow1[1]);
$rep->TextCol(2, 3, $myrow1[2]);
$rep->TextCol(3, 4, '- ' . $myrow1[3]);
$rep->TextCol(4, 5, 'Closed');
$rep->NewLine();
}
}
$rep->Line($rep->row + 4);
$rep->End();
}
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:57,代码来源:rep802.php
示例6: print_summary
function print_summary()
{
global $path_to_root;
$imc = $_POST['PARAM_0'];
$comments = $_POST['PARAM_1'];
$orientation = $_POST['PARAM_2'];
$destination = $_POST['PARAM_3'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$cols = array(0, 10, 100, 150, 200, 250, 300, 350, 400, 450, 520);
//$headers = array(_('IMC'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left');
//$params = array( 0 => $comments, 1 => array( 'text' => _('Period'), 'from' => $from));
$aligns2 = $aligns;
$summary = 1;
$rep = new FrontReport(_('Client List'), "ClientList", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$cols2 = $cols;
$rep->Font();
$rep->Info(null, $cols, null, $aligns);
$rep->NewPage();
$salesman = 0;
$result = getList($imc);
while ($myrow = db_fetch($result)) {
$previous == '';
$salesman = get_salesman_name($myrow['salesman']);
$current = $salesman;
if ($salesman != "") {
if ($previous == $current) {
$salesman = '';
$rep->TextCol(1, 10, $myrow['br_name']);
$rep->NewLine();
} else {
$rep->Font('bold');
$rep->NewLine(2);
$rep->Line($rep->row + 10);
$rep->TextCol(0, 2, $salesman);
$rep->Line($rep->row - 4);
$rep->NewLine(2);
$rep->Font();
$rep->TextCol(1, 10, $myrow['br_name']);
$rep->NewLine();
}
$previous = $current;
}
}
$rep->NewLine();
$rep->End();
}
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:56,代码来源:rep_client_listing.php
示例7: print_audit_trail
function print_audit_trail()
{
global $path_to_root, $systypes_array;
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$systype = $_POST['PARAM_2'];
$user = $_POST['PARAM_3'];
$comments = $_POST['PARAM_4'];
$orientation = $_POST['PARAM_5'];
$destination = $_POST['PARAM_6'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$cols = array(0, 60, 120, 180, 240, 340, 400, 460, 520);
$headers = array(_('Date'), _('Time'), _('User'), _('Trans Date'), _('Type'), _('#'), _('Action'), _('Amount'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'left', 'right');
$usr = get_user($user);
$user_id = $usr['user_id'];
$params = array(0 => $comments, 1 => array('text' => _('Period'), 'from' => $from, 'to' => $to), 2 => array('text' => _('Type'), 'from' => $systype != -1 ? $systypes_array[$systype] : _('All'), 'to' => ''), 3 => array('text' => _('User'), 'from' => $user != -1 ? $user_id : _('All'), 'to' => ''));
$rep = new FrontReport(_('Audit Trail'), "AuditTrail", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$trans = getTransactions($from, $to, $systype, $user);
while ($myrow = db_fetch($trans)) {
$rep->TextCol(0, 1, sql2date(date("Y-m-d", $myrow['unix_stamp'])));
if (user_date_format() == 0) {
$rep->TextCol(1, 2, date("h:i:s a", $myrow['unix_stamp']));
} else {
$rep->TextCol(1, 2, date("H:i:s", $myrow['unix_stamp']));
}
$rep->TextCol(2, 3, $myrow['user_id']);
$rep->TextCol(3, 4, sql2date($myrow['gl_date']));
$rep->TextCol(4, 5, $systypes_array[$myrow['type']]);
$rep->TextCol(5, 6, $myrow['trans_no']);
if ($myrow['gl_seq'] == null) {
$action = _('Changed');
} else {
$action = _('Closed');
}
$rep->TextCol(6, 7, $action);
if ($myrow['amount'] != null) {
$rep->AmountCol(7, 8, $myrow['amount'], $dec);
}
$rep->NewLine(1, 2);
}
$rep->Line($rep->row + 4);
$rep->End();
}
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:56,代码来源:rep710.php
示例8: print_bill_of_material
function print_bill_of_material()
{
global $path_to_root;
$frompart = $_POST['PARAM_0'];
$topart = $_POST['PARAM_1'];
$comments = $_POST['PARAM_2'];
$orientation = $_POST['PARAM_3'];
$destination = $_POST['PARAM_4'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$cols = array(0, 50, 305, 375, 445, 515);
$headers = array(_('Component'), _('Description'), _('Loc'), _('Wrk Ctr'), _('Quantity'));
$aligns = array('left', 'left', 'left', 'left', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Component'), 'from' => $frompart, 'to' => $topart));
$rep = new FrontReport(_('Bill of Material Listing'), "BillOfMaterial", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($frompart, $topart);
$parent = '';
while ($trans = db_fetch($res)) {
if ($parent != $trans['parent']) {
if ($parent != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 1, $trans['parent']);
$desc = get_item($trans['parent']);
$rep->TextCol(1, 2, $desc['description']);
$parent = $trans['parent'];
$rep->NewLine();
}
$rep->NewLine();
$dec = get_qty_dec($trans['component']);
$rep->TextCol(0, 1, $trans['component']);
$rep->TextCol(1, 2, $trans['CompDescription']);
//$rep->TextCol(2, 3, $trans['loc_code']);
//$rep->TextCol(3, 4, $trans['workcentre_added']);
$wc = get_work_centre($trans['workcentre_added']);
$rep->TextCol(2, 3, get_location_name($trans['loc_code']));
$rep->TextCol(3, 4, $wc['name']);
$rep->AmountCol(4, 5, $trans['quantity'], $dec);
}
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:54,代码来源:rep401.php
示例9: print_dimension_summary
function print_dimension_summary()
{
global $path_to_root;
$fromdim = $_POST['PARAM_0'];
$todim = $_POST['PARAM_1'];
$showbal = $_POST['PARAM_2'];
$comments = $_POST['PARAM_3'];
$orientation = $_POST['PARAM_4'];
$destination = $_POST['PARAM_5'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = $orientation ? 'L' : 'P';
$cols = array(0, 50, 210, 250, 320, 395, 465, 515);
$headers = array(_('Reference'), _('Name'), _('Type'), _('Date'), _('Due Date'), _('Closed'), _('YTD'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Dimension'), 'from' => get_dimension_string($fromdim), 'to' => get_dimension_string($todim)));
$rep = new FrontReport(_('Dimension Summary'), "DimensionSummary", user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($fromdim, $todim);
while ($trans = db_fetch($res)) {
$rep->TextCol(0, 1, $trans['reference']);
$rep->TextCol(1, 2, $trans['name']);
$rep->TextCol(2, 3, $trans['type_']);
$rep->DateCol(3, 4, $trans['date_'], true);
$rep->DateCol(4, 5, $trans['due_date'], true);
if ($trans['closed']) {
$str = _('Yes');
} else {
$str = _('No');
}
$rep->TextCol(5, 6, $str);
if ($showbal) {
$balance = getYTD($trans['id']);
$rep->AmountCol(6, 7, $balance, 0);
}
$rep->NewLine(1, 2);
}
$rep->Line($rep->row);
$rep->End();
}
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:48,代码来源:rep501.php
示例10: print_assets_list
function print_assets_list()
{
global $path_to_root;
$frompart = $_POST['PARAM_0'];
$topart = $_POST['PARAM_1'];
$comments = $_POST['PARAM_2'];
$destination = $_POST['PARAM_3'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$cols = array(0, 50, 305, 375, 445, 515);
$headers = array(_('Asset Type'), _('Asset name'), _('Serial Number'), _('Purchase Date'), _('Purchase Value'));
$aligns = array('left', 'left', 'left', 'left', 'right');
$params = array(0 => $comments, 1 => array('text' => _('Component'), 'from' => $frompart, 'to' => $topart));
$rep = new FrontReport(_('Assets Listing'), "AssetList", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$res = getTransactions($frompart, $topart);
$parent = '';
while ($trans = db_fetch($res)) {
if ($parent != $trans['asset_type_name']) {
if ($parent != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 2, $trans['asset_type_name']);
$desc = get_item($trans['asset_type_name']);
$parent = $trans['asset_type_name'];
$rep->NewLine();
}
$rep->NewLine();
$dec = get_qty_dec($trans['asset_id']);
$rep->TextCol(0, 1, $trans['asset_type_name']);
$rep->TextCol(1, 2, $trans['asset_name']);
$rep->TextCol(2, 3, $trans['asset_serial']);
$rep->TextCol(3, 4, $trans['purchase_date']);
$rep->AmountCol(4, 5, $trans['purchase_value'], $dec);
}
$rep->Line($rep->row - 4);
$rep->NewLine();
$rep->End();
}
开发者ID:blestab,项目名称:frontaccounting,代码行数:45,代码来源:rep_assets_list.php
示例11: print_bill_of_material
function print_bill_of_material()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$frompart = $_REQUEST['PARAM_0'];
$topart = $_REQUEST['PARAM_1'];
$comments = $_REQUEST['PARAM_2'];
$dec = user_qty_dec();
$cols = array(0, 50, 305, 375, 445, 515);
$headers = array(tr('Component'), tr('Description'), tr('Loc'), tr('Wrk Ctr'), tr('Quantity'));
$aligns = array('left', 'left', 'left', 'left', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Component'), 'from' => $frompart, 'to' => $topart));
$rep = new FrontReport(tr('Bill of Material Listing'), "BillOfMaterial.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
$res = getTransactions($frompart, $topart);
$parent = '';
while ($trans = db_fetch($res)) {
if ($parent != $trans['parent']) {
if ($parent != '') {
$rep->Line($rep->row - 2);
$rep->NewLine(2, 3);
}
$rep->TextCol(0, 1, $trans['parent']);
$desc = get_item($trans['parent']);
$rep->TextCol(1, 2, $desc['description']);
$parent = $trans['parent'];
$rep->NewLine();
}
$rep->NewLine();
$rep->TextCol(0, 1, $trans['component']);
$rep->TextCol(1, 2, $trans['CompDescription']);
$rep->TextCol(2, 3, $trans['loc_code']);
$rep->TextCol(3, 4, $trans['workcentre_added']);
$rep->TextCol(4, 5, number_format2($trans['quantity'], $dec));
}
$rep->Line($rep->row - 4);
$rep->End();
}
开发者ID:ravenii,项目名称:guardocs,代码行数:40,代码来源:rep401.php
示例12: print_dimension_summary
function print_dimension_summary()
{
global $path_to_root;
include_once $path_to_root . "reporting/includes/pdf_report.inc";
$fromdim = $_REQUEST['PARAM_0'];
$todim = $_REQUEST['PARAM_1'];
$showbal = $_REQUEST['PARAM_2'];
$comments = $_REQUEST['PARAM_3'];
$cols = array(0, 50, 210, 250, 320, 395, 465, 515);
$headers = array(tr('Reference'), tr('Name'), tr('Type'), tr('Date'), tr('Due Date'), tr('Closed'), tr('YTD'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'right');
$params = array(0 => $comments, 1 => array('text' => tr('Dimension'), 'from' => $fromdim, 'to' => $todim));
$rep = new FrontReport(tr('Dimension Summary'), "DimensionSummary.pdf", user_pagesize());
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->Header();
$res = getTransactions($fromdim, $todim);
while ($trans = db_fetch($res)) {
$rep->TextCol(0, 1, $trans['reference']);
$rep->TextCol(1, 2, $trans['name']);
$rep->TextCol(2, 3, $trans['type_']);
$rep->TextCol(3, 4, $trans['date_']);
$rep->TextCol(4, 5, $trans['due_date']);
if ($trans['closed']) {
$str = tr('Yes');
} else {
$str = tr('No');
}
$rep->TextCol(5, 6, $str);
if ($showbal) {
$balance = getYTD($trans['id']);
$rep->TextCol(6, 7, number_format2($balance, 0));
}
$rep->NewLine(1, 2);
}
$rep->Line($rep->row);
$rep->End();
}
开发者ID:ravenii,项目名称:guardocs,代码行数:38,代码来源:rep501.php
示例13: printYearlyPurch
function printYearlyPurch()
{
global $path_to_root, $systypes_array;
///$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
/*$fromcust = $_POST['PARAM_2'];
$show_balance = $_POST['PARAM_3'];
$currency = $_POST['PARAM_4'];
$no_zeros = $_POST['PARAM_5'];
$comments = $_POST['PARAM_6'];
//$orientation = $_POST['PARAM_7'];*/
$destination = $_POST['PARAM_3'];
if ($destination) {
include_once $path_to_root . "/reporting/includes/excel_report.inc";
} else {
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
}
$orientation = 'L';
//incrementing dapat
$cols = array(0, 20, 55, 85, 125, 200, 230, 260, 290, 325, 350, 375, 425, 475);
//14 headers + 1 lagi dapat for cols
//todo: format date paid to 2 digits representation only i.e. 12/12/12
$headers = array(_('CV#'), _('Date Paid'), _('OR #'), _('Supplier'), _('Title of Book'), _('Quantity'), _('Unit Cost'), _('Amount'), _('With Tax'), _('Net'), _('PO #'), _('Stock Supplied'), _('Stock Amount'), _('Total Amount'));
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'left');
$params = null;
//todo: modify concatenation of $to to include only year, not the whole date
$rep = new FrontReport(_('Purchases for the year ' . $to), "Purchases Year " . $to, user_pagesize(), 9, $orientation);
if ($orientation == 'L') {
recalculate_cols($cols);
}
$rep->Font();
$rep->Info($params, $cols, $headers, $aligns);
$rep->NewPage();
$grandtotal = array(0, 0, 0, 0);
$rep->NewLine();
$rep->End();
}
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:37,代码来源:rep800.php
示例14: print_GL_transactions
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") {
//.........这里部分代码省略.........
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:101,代码来源:rep704.php
示例15: print_inventory_sales
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);
}
}
//.........这里部分代码省略.........
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:101,代码来源:rep_series_report.php
示例16: print_invoices
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'];
$orientation = $_POST['PARAM_6'];
$TotalDiscount = 0;
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, 60, 225, 300, 325, 385, 450, 515);
// $headers in doctext.inc
$aligns = array('left', 'left', 'right', 'left', 'right', 'right', 'right');
$params = array('comments' => $comments);
$cur = get_company_Pref('curr_default');
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);
$transId = get_payment_id($i);
$urrow = get_customer_trans($transId['trans_no_from'], ST_CUSTPAYMENT);
$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('Header2');
$rep->currency = $cur;
$rep->Font();
$rep->Info($params, $cols, null, $aligns);
$contacts = get_branch_contacts($branch['branch_code'], 'invoice', $branch['debtor_no'], true);
$baccount['payment_service'] = $pay_service;
$rep->SetCommonData($myrow, $branch, $sales_order, $baccount, ST_SALESINVOICE, $contacts);
$rep->NewPage();
$result = get_customer_trans_details(ST_SALESINVOICE, $i);
// print_r($result);
$SubTotal = 0;
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());
$SubTotal += $Net;
$DisplayPrice = number_format2($myrow2["u
|
请发表评论