当前位置: 首页>>代码示例>>PHP>>正文


PHP new_db_pager函数代码示例

本文整理汇总了PHP中new_db_pager函数的典型用法代码示例。如果您正苦于以下问题:PHP new_db_pager函数的具体用法?PHP new_db_pager怎么用?PHP new_db_pager使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了new_db_pager函数的10个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: trans_view

}
//---------------------------------------------------------------------------------------------
function trans_view($trans)
{
    return get_trans_view_str(ST_PURCHORDER, $trans["order_no"]);
}
function edit_link($row)
{
    if (@$_GET['popup']) {
        return '';
    }
    return pager_link(_("Edit"), "/purchasing/po_entry_items.php?" . SID . "ModifyOrderNumber=" . $row["order_no"], ICON_EDIT);
}
function prt_link($row)
{
    return print_document_link($row['order_no'], _("Print"), true, 18, ICON_PRINT);
}
//---------------------------------------------------------------------------------------------
$sql = get_sql_for_po_search_completed();
$cols = array(_("#") => array('fun' => 'trans_view', 'ord' => ''), _("Reference"), _("Supplier") => array('ord' => ''), _("Location"), _("Supplier's Reference"), _("Order Date") => array('name' => 'ord_date', 'type' => 'date', 'ord' => 'desc'), _("Currency") => array('align' => 'center'), _("Order Total") => 'amount', array('insert' => true, 'fun' => 'edit_link'), array('insert' => true, 'fun' => 'prt_link'));
if (get_post('StockLocation') != $all_items) {
    $cols[_("Location")] = 'skip';
}
//---------------------------------------------------------------------------------------------------
$table =& new_db_pager('orders_tbl', $sql, $cols);
$table->width = "80%";
display_db_pager($table);
if (!@$_GET['popup']) {
    end_form();
    end_page();
}
开发者ID:pthdnq,项目名称:ivalley-svn,代码行数:31,代码来源:po_search_completed.php

示例2: elseif

    } elseif ($row['type'] == ST_BANKPAYMENT) {
        // bank payment printout not defined yet.
        return '';
    } else {
        return print_document_link($row['trans_no'] . "-" . $row['type'], _("Print"), true, $row['type'], ICON_PRINT);
    }
}
function check_overdue($row)
{
    return $row['OverDue'] == 1 && floatcmp($row["TotalAmount"], $row["Allocated"]) != 0;
}
//------------------------------------------------------------------------------------------------
$sql = get_sql_for_customer_inquiry();
//------------------------------------------------------------------------------------------------
db_query("set @bal:=0");
$cols = array(_("Type") => array('fun' => 'systype_name', 'ord' => ''), _("#") => array('fun' => 'trans_view', 'ord' => ''), _("Order") => array('fun' => 'order_view'), _("Reference"), _("Date") => array('name' => 'tran_date', 'type' => 'date', 'ord' => 'desc'), _("Due Date") => array('type' => 'date', 'fun' => 'due_date'), _("Customer") => array('ord' => ''), _("Branch") => array('ord' => ''), _("Currency") => array('align' => 'center'), _("Debit") => array('align' => 'right', 'fun' => 'fmt_debit'), _("Credit") => array('align' => 'right', 'insert' => true, 'fun' => 'fmt_credit'), _("RB") => array('align' => 'right', 'type' => 'amount'), array('insert' => true, 'fun' => 'gl_view'), array('insert' => true, 'fun' => 'credit_link'), array('insert' => true, 'fun' => 'edit_link'), array('insert' => true, 'fun' => 'prt_link'));
if ($_POST['customer_id'] != ALL_TEXT) {
    $cols[_("Customer")] = 'skip';
    $cols[_("Currency")] = 'skip';
}
if ($_POST['filterType'] == ALL_TEXT) {
    $cols[_("RB")] = 'skip';
}
$table =& new_db_pager('trans_tbl', $sql, $cols);
$table->set_marker('check_overdue', _("Marked items are overdue."));
$table->width = "85%";
display_db_pager($table);
if (!@$_GET['popup']) {
    end_form();
    end_page(@$_GET['popup'], false, false);
}
开发者ID:nativebandung,项目名称:frontaccounting,代码行数:31,代码来源:customer_inquiry.php

示例3: elseif

    } elseif ($row["type"] == ST_CUSTPAYMENT && $row['TotalAmount'] <= 0) {
        /*its a negative receipt */
        return '';
    } elseif ($row["type"] == ST_SALESINVOICE && $row['TotalAmount'] - $row['Allocated'] > 0) {
        return pager_link(_("Payment"), "/sales/customer_payments.php?customer_id=" . $row["debtor_no"] . "&SInvoice=" . $row["trans_no"], ICON_MONEY);
    }
}
function fmt_debit($row)
{
    $value = $row['type'] == ST_CUSTCREDIT || $row['type'] == ST_CUSTPAYMENT || $row['type'] == ST_BANKDEPOSIT ? -$row["TotalAmount"] : $row["TotalAmount"];
    return $value >= 0 ? price_format($value) : '';
}
function fmt_credit($row)
{
    $value = !($row['type'] == ST_CUSTCREDIT || $row['type'] == ST_CUSTPAYMENT || $row['type'] == ST_BANKDEPOSIT) ? -$row["TotalAmount"] : $row["TotalAmount"];
    return $value > 0 ? price_format($value) : '';
}
//------------------------------------------------------------------------------------------------
$sql = get_sql_for_customer_allocation_inquiry(get_post('TransAfterDate'), get_post('TransToDate'), get_post('customer_id'), get_post('filterType'), check_value('showSettled'));
//------------------------------------------------------------------------------------------------
$cols = array(_("Type") => array('fun' => 'systype_name'), _("#") => array('fun' => 'view_link'), _("Reference"), _("Order") => array('fun' => 'order_link', 'ord' => ''), _("Date") => array('name' => 'tran_date', 'type' => 'date', 'ord' => 'asc'), _("Due Date") => array('type' => 'date', 'fun' => 'due_date'), _("Customer") => array('name' => 'name', 'ord' => 'asc'), _("Currency") => array('align' => 'center'), _("Debit") => array('align' => 'right', 'fun' => 'fmt_debit'), _("Credit") => array('align' => 'right', 'insert' => true, 'fun' => 'fmt_credit'), _("Allocated") => 'amount', _("Balance") => array('type' => 'amount', 'insert' => true, 'fun' => 'fmt_balance'), array('insert' => true, 'fun' => 'alloc_link'));
if ($_POST['customer_id'] != ALL_TEXT) {
    $cols[_("Customer")] = 'skip';
    $cols[_("Currency")] = 'skip';
}
$table =& new_db_pager('doc_tbl', $sql, $cols);
$table->set_marker('check_overdue', _("Marked items are overdue."));
$table->width = "80%";
display_db_pager($table);
end_form();
end_page();
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:31,代码来源:customer_allocation_inquiry.php

示例4: prt_link

function prt_link($row)
{
    return print_document_link($row['trans_no'], _("Print"), true, ST_CUSTDELIVERY, ICON_PRINT);
}
function invoice_link($row)
{
    return $row["Outstanding"] == 0 ? '' : pager_link(_('Invoice'), "/sales/customer_invoice.php?DeliveryNumber=" . $row['trans_no'], ICON_DOC);
}
function check_overdue($row)
{
    return date1_greater_date2(Today(), sql2date($row["due_date"])) && $row["Outstanding"] != 0;
}
//------------------------------------------------------------------------------------------------
$sql = get_sql_for_sales_deliveries_view($selected_customer, $selected_stock_item, $_POST['customer_id']);
$cols = array(_("Delivery #") => array('fun' => 'trans_view'), _("Customer"), 'branch_code' => 'skip', _("Branch") => array('ord' => ''), _("Contact"), _("Reference"), _("Cust Ref"), _("Delivery Date") => array('type' => 'date', 'ord' => ''), _("Due By") => 'date', _("Delivery Total") => array('type' => 'amount', 'ord' => ''), _("Currency") => array('align' => 'center'), submit('BatchInvoice', _("Batch"), false, _("Batch Invoicing")) => array('insert' => true, 'fun' => 'batch_checkbox', 'align' => 'center'), array('insert' => true, 'fun' => 'edit_link'), array('insert' => true, 'fun' => 'invoice_link'), array('insert' => true, 'fun' => 'prt_link'));
//-----------------------------------------------------------------------------------
if (isset($_SESSION['Batch'])) {
    foreach ($_SESSION['Batch'] as $trans => $del) {
        unset($_SESSION['Batch'][$trans]);
    }
    unset($_SESSION['Batch']);
}
$table =& new_db_pager('deliveries_tbl', $sql, $cols);
$table->set_marker('check_overdue', _("Marked items are overdue."));
//$table->width = "92%";
display_db_pager($table);
end_form();
end_page();
?>

开发者ID:M-Shahbaz,项目名称:FA,代码行数:29,代码来源:sales_deliveries_view.php

示例5: voiding_controls

function voiding_controls()
{
    global $selected_id;
    $not_implemented = array(ST_PURCHORDER, ST_SALESORDER, ST_SALESQUOTE, ST_COSTUPDATE);
    start_form();
    start_table(TABLESTYLE_NOBORDER);
    start_row();
    systypes_list_cells(_("Type:"), 'filterType', null, true, $not_implemented);
    if (list_updated('filterType')) {
        $selected_id = -1;
    }
    if (!isset($_POST['FromTransNo'])) {
        $_POST['FromTransNo'] = "1";
    }
    if (!isset($_POST['ToTransNo'])) {
        $_POST['ToTransNo'] = "999999";
    }
    ref_cells(_("from #:"), 'FromTransNo');
    ref_cells(_("to #:"), 'ToTransNo');
    submit_cells('ProcessSearch', _("Search"), '', '', 'default');
    end_row();
    end_table(1);
    $trans_ref = false;
    $sql = get_sql_for_view_transactions($_POST['filterType'], $_POST['FromTransNo'], $_POST['ToTransNo'], $trans_ref);
    if ($sql == "") {
        return;
    }
    $cols = array(_("#") => array('insert' => true, 'fun' => 'view_link'), _("Reference") => array('fun' => 'ref_view'), _("Date") => array('type' => 'date', 'fun' => 'date_view'), _("GL") => array('insert' => true, 'fun' => 'gl_view'), _("Select") => array('insert' => true, 'fun' => 'select_link'));
    $table =& new_db_pager('transactions', $sql, $cols);
    $table->width = "40%";
    display_db_pager($table);
    start_table(TABLESTYLE2);
    if ($selected_id != -1) {
        hidden('trans_no', $selected_id);
        hidden('selected_id', $selected_id);
    } else {
        hidden('trans_no', '');
        $_POST['memo_'] = '';
    }
    label_row(_("Transaction #:"), $selected_id == -1 ? '' : $selected_id);
    date_row(_("Voiding Date:"), 'date_');
    textarea_row(_("Memo:"), 'memo_', null, 30, 4);
    end_table(1);
    if (!isset($_POST['ProcessVoiding'])) {
        submit_center('ProcessVoiding', _("Void Transaction"), true, '', 'default');
    } else {
        if (!exist_transaction($_POST['filterType'], $_POST['trans_no'])) {
            display_error(_("The entered transaction does not exist or cannot be voided."));
            unset($_POST['trans_no']);
            unset($_POST['memo_']);
            unset($_POST['date_']);
            submit_center('ProcessVoiding', _("Void Transaction"), true, '', 'default');
        } else {
            display_warning(_("Are you sure you want to void this transaction ? This action cannot be undone."), 0, 1);
            br();
            submit_center_first('ConfirmVoiding', _("Proceed"), '', true);
            submit_center_last('CancelVoiding', _("Cancel"), '', 'cancel');
        }
    }
    end_form();
}
开发者ID:blestab,项目名称:frontaccounting,代码行数:61,代码来源:void_transaction.php

示例6: page

<?php

$page_security = 'SA_WORKORDERANALYTIC';
$path_to_root = "../..";
include $path_to_root . "/includes/db_pager.inc";
include $path_to_root . "/includes/session.inc";
page(_($help_context = "Inventory Item Where Used Inquiry"));
include $path_to_root . "/includes/ui.inc";
check_db_has_stock_items(_("There are no items defined in the system."));
start_form(false, true);
if (!isset($_POST['stock_id'])) {
    $_POST['stock_id'] = get_global_stock_item();
}
echo "<center>" . _("Select an item to display its parent item(s).") . "&nbsp;";
echo stock_items_list('stock_id', $_POST['stock_id'], false, true);
echo "<hr></center>";
set_global_stock_item($_POST['stock_id']);
//-----------------------------------------------------------------------------
function select_link($row)
{
    return pager_link($row["parent"] . " - " . $row["description"], "/manufacturing/manage/bom_edit.php?stock_id=" . $row["parent"]);
}
$sql = get_sql_for_where_used();
$cols = array(_("Parent Item") => array('fun' => 'select_link'), _("Work Centre"), _("Location"), _("Quantity Required"));
$table =& new_db_pager('usage_table', $sql, $cols);
$table->width = "80%";
display_db_pager($table);
end_form();
end_page();
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:29,代码来源:where_used_inquiry.php

示例7: handle_search

function handle_search()
{
    if (check_valid_entries() == true) {
        $trans_ref = false;
        $sql = get_sql_for_view_transactions($_POST['filterType'], $_POST['FromTransNo'], $_POST['ToTransNo'], $trans_ref);
        if ($sql == "") {
            return;
        }
        $print_type = $_POST['filterType'];
        $print_out = $print_type == ST_SALESINVOICE || $print_type == ST_CUSTCREDIT || $print_type == ST_CUSTDELIVERY || $print_type == ST_PURCHORDER || $print_type == ST_SALESORDER || $print_type == ST_SALESQUOTE || $print_type == ST_CUSTPAYMENT || $print_type == ST_SUPPAYMENT || $print_type == ST_WORKORDER;
        $cols = array(_("#") => array('insert' => true, 'fun' => 'view_link'), _("Reference") => array('fun' => 'ref_view'), _("Date") => array('type' => 'date', 'fun' => 'date_view'), _("Print") => array('insert' => true, 'fun' => 'prt_link'), _("GL") => array('insert' => true, 'fun' => 'gl_view'));
        if (!$print_out) {
            array_remove($cols, 3);
        }
        if (!$trans_ref) {
            array_remove($cols, 1);
        }
        $table =& new_db_pager('transactions', $sql, $cols);
        $table->width = "40%";
        display_db_pager($table);
    }
}
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:22,代码来源:view_print_transaction.php

示例8: view_link

function view_link($row)
{
    return get_trans_view_str($row["type"], $row["type_no"]);
}
function gl_link($row)
{
    return get_gl_view_str($row["type"], $row["type_no"]);
}
$editors = array(ST_JOURNAL => "/gl/gl_journal.php?ModifyGL=Yes&trans_no=%d&trans_type=%d", ST_BANKPAYMENT => "/gl/gl_bank.php?ModifyPayment=Yes&trans_no=%d&trans_type=%d", ST_BANKDEPOSIT => "/gl/gl_bank.php?ModifyDeposit=Yes&trans_no=%d&trans_type=%d", ST_SALESINVOICE => "/sales/customer_invoice.php?ModifyInvoice=%d", ST_CUSTDELIVERY => "/sales/customer_delivery.php?ModifyDelivery=%d");
function edit_link($row)
{
    global $editors;
    $ok = true;
    if ($row['type'] == ST_SALESINVOICE) {
        $myrow = get_customer_trans($row["type_no"], $row["type"]);
        if ($myrow['alloc'] != 0 || get_voided_entry(ST_SALESINVOICE, $row["type_no"]) !== false) {
            $ok = false;
        }
    }
    return isset($editors[$row["type"]]) && !is_closed_trans($row["type"], $row["type_no"]) && $ok ? pager_link(_("Edit"), sprintf($editors[$row["type"]], $row["type_no"], $row["type"]), ICON_EDIT) : '';
}
$sql = get_sql_for_journal_inquiry(get_post('filterType', -1), get_post('FromDate'), get_post('ToDate'), get_post('Ref'), get_post('Memo'), check_value('AlsoClosed'));
$cols = array(_("#") => array('fun' => 'journal_pos', 'align' => 'center'), _("Date") => array('name' => 'tran_date', 'type' => 'date', 'ord' => 'desc'), _("Type") => array('fun' => 'systype_name'), _("Trans #") => array('fun' => 'view_link'), _("Reference"), _("Amount") => array('type' => 'amount'), _("Memo"), _("User"), _("View") => array('insert' => true, 'fun' => 'gl_link'), array('insert' => true, 'fun' => 'edit_link'));
if (!check_value('AlsoClosed')) {
    $cols[_("#")] = 'skip';
}
$table =& new_db_pager('journal_tbl', $sql, $cols);
$table->width = "80%";
display_db_pager($table);
end_form();
end_page();
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:31,代码来源:journal_inquiry.php

示例9: display_rows

function display_rows($type)
{
    $sql = get_sql_for_attached_documents($type);
    $cols = array(_("#") => array('fun' => 'trans_view', 'ord' => ''), _("Description") => array('name' => 'description'), _("Filename") => array('name' => 'filename'), _("Size") => array('name' => 'filesize'), _("Filetype") => array('name' => 'filetype'), _("Date Uploaded") => array('name' => 'tran_date', 'type' => 'date'), array('insert' => true, 'fun' => 'edit_link'), array('insert' => true, 'fun' => 'view_link'), array('insert' => true, 'fun' => 'download_link'), array('insert' => true, 'fun' => 'delete_link'));
    $table =& new_db_pager('trans_tbl', $sql, $cols);
    $table->width = "60%";
    display_db_pager($table);
}
开发者ID:knjy24,项目名称:FrontAccounting,代码行数:8,代码来源:attachments.php

示例10: end_outer_table

    end_outer_table(1);
    submit_add_or_update_center($selected_id == -1, '', 'both');
}
start_form();
echo "<center>" . _("Select a customer: ") . "&nbsp;&nbsp;";
echo customer_list('customer_id', null, false, true);
echo "</center><br>";
$num_branches = db_customer_has_branches($_POST['customer_id']);
$sql = get_sql_for_customer_branches();
//------------------------------------------------------------------------------------------------
if ($num_branches) {
    $cols = array('branch_code' => 'skip', _("Short Name"), _("Name"), _("Contact"), _("Sales Person"), _("Area"), _("Phone No"), _("Fax No"), _("E-mail") => 'email', _("Tax Group"), _("Inactive") => 'inactive', ' ' => array('insert' => true, 'fun' => 'select_link'), array('insert' => true, 'fun' => 'edit_link'), array('insert' => true, 'fun' => 'del_link'));
    if (!@$_REQUEST['popup']) {
        $cols[' '] = 'skip';
    }
    $table =& new_db_pager('branch_tbl', $sql, $cols, 'cust_branch');
    $table->set_inactive_ctrl('cust_branch', 'branch_code');
    //$table->width = "85%";
    display_db_pager($table);
} else {
    display_note(_("The selected customer does not have any branches. Please create at least one branch."));
}
tabbed_content_start('tabs', array('settings' => array(_('&General settings'), $selected_id != -1), 'contacts' => array(_('&Contacts'), $selected_id != -1)));
switch (get_post('_tabs_sel')) {
    default:
    case 'settings':
        branch_settings($selected_id);
        break;
    case 'contacts':
        $contacts = new contacts('contacts', $selected_id, 'cust_branch');
        $contacts->show();
开发者ID:pthdnq,项目名称:ivalley-svn,代码行数:31,代码来源:customer_branches.php


注:本文中的new_db_pager函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。