PHP check_cells函数代码示例

function gl_inquiry_controls()
{
    $dim = get_company_pref('use_dimension');
    start_form();
    start_table(TABLESTYLE_NOBORDER);
    $date = today();
    if (!isset($_POST['TransFromDate'])) {
        $_POST['TransFromDate'] = begin_month($date);
    }
    if (!isset($_POST['TransToDate'])) {
        $_POST['TransToDate'] = end_month($date);
    }
    date_cells(_("From:"), 'TransFromDate');
    date_cells(_("To:"), 'TransToDate');
    if ($dim >= 1) {
        dimensions_list_cells(_("Dimension") . " 1:", 'Dimension', null, true, " ", false, 1);
    }
    if ($dim > 1) {
        dimensions_list_cells(_("Dimension") . " 2:", 'Dimension2', null, true, " ", false, 2);
    }
    check_cells(_("No zero values"), 'NoZero', null);
    check_cells(_("Only balances"), 'Balance', null);
    submit_cells('Show', _("Show"), '', '', 'default');
    end_table();
    end_form();
}

function gl_inquiry_controls()
{
    start_form();
    start_table("class='tablestyle_noborder'");
    date_cells(tr("From:"), 'TransFromDate', null, -30);
    date_cells(tr("To:"), 'TransToDate');
    check_cells(tr("No zero values"), 'NoZero', null);
    submit_cells('Show', tr("Show"));
    end_table();
    end_form();
}

function tax_inquiry_controls()
{
    start_form();
    start_table(TABLESTYLE_NOBORDER);
    start_row();
    date_cells(_("from:"), 'TransFromDate', '', null, -30);
    date_cells(_("to:"), 'TransToDate');
    check_cells(_("Net Output/Input:"), 'NetAmounts', null);
    submit_cells('Show', _("Show"), '', '', 'default');
    end_row();
    end_table();
    end_form();
}

 function render($id, $title)
 {
     global $path_to_root;
     include_once $path_to_root . "/includes/ui.inc";
     $end_date = date2sql(add_days(Today(), $this->days_future));
     $role_id = $_SESSION["wa_current_user"]->access;
     $sql = "SELECT id, description, next_date FROM " . TB_PREF . "dashboard_reminders " . " WHERE next_date < '{$end_date}'" . " AND role_id = '{$role_id}'";
     if ($this->data_filter != '') {
         $sql .= ' AND ' . $this->data_filter;
     }
     $sql .= " ORDER BY next_date";
     $result = db_query($sql);
     br();
     $th = array(_("Actioned"), _("Date"), _("Description"));
     start_table(TABLESTYLE, "id='reminder' width=98%");
     table_header($th);
     $k = 0;
     //row colour counter
     while ($myrow = db_fetch($result)) {
         $nextdate = sql2date($myrow["next_date"]);
         if (date1_greater_date2(Today(), $nextdate)) {
             $extra = "class='reminder_overdue'";
         } elseif (Today() == $nextdate) {
             $extra = "class='reminder_due'";
         } else {
             $extra = "class='reminder'";
         }
         alt_table_row_color($k);
         $js = 'setTimeout(function(){updateToDoData(' . $myrow["id"] . ');}, 0);';
         check_cells(null, null, null, $js);
         label_cell($nextdate, $extra);
         label_cell("<pre>" . $myrow["description"] . "</pre>", $extra);
         end_row();
     }
     end_table(1);
 }

function company_extensions($id)
{
    start_table(TABLESTYLE);
    $th = array(_("Extension"), _("Modules provided"), _("Options provided"), _("Active"));
    $mods = get_company_extensions();
    $exts = get_company_extensions($id);
    foreach ($mods as $key => $ins) {
        foreach ($exts as $ext) {
            if ($ext['name'] == $ins['name']) {
                $mods[$key]['active'] = @$ext['active'];
                continue 2;
            }
        }
    }
    $mods = array_natsort($mods, null, 'name');
    table_header($th);
    $k = 0;
    foreach ($mods as $i => $mod) {
        if ($mod['type'] != 'extension') {
            continue;
        }
        alt_table_row_color($k);
        label_cell($mod['name']);
        $entries = fmt_titles(@$mod['entries']);
        $tabs = fmt_titles(@$mod['tabs']);
        label_cell($tabs);
        label_cell($entries);
        check_cells(null, 'Active' . $i, @$mod['active'] ? 1 : 0, false, false, "align='center'");
        end_row();
    }
    end_table(1);
    submit_center('Refresh', _('Update'), true, false, 'default');
}

page(_($help_context = "Customer Allocation Inquiry"), false, false, "", $js);
if (isset($_GET['customer_id'])) {
    $_POST['customer_id'] = $_GET['customer_id'];
}
//------------------------------------------------------------------------------------------------
if (!isset($_POST['customer_id'])) {
    $_POST['customer_id'] = get_global_customer();
}
start_form();
start_table(TABLESTYLE_NOBORDER);
start_row();
customer_list_cells(_("Select a customer: "), 'customer_id', $_POST['customer_id'], true);
date_cells(_("from:"), 'TransAfterDate', '', null, -30);
date_cells(_("to:"), 'TransToDate', '', null, 1);
cust_allocations_list_cells(_("Type:"), 'filterType', null);
check_cells(" " . _("show settled:"), 'showSettled', null);
submit_cells('RefreshInquiry', _("Search"), '', _('Refresh Inquiry'), 'default');
set_global_customer($_POST['customer_id']);
end_row();
end_table();
//------------------------------------------------------------------------------------------------
function check_overdue($row)
{
    return $row['OverDue'] == 1 && abs($row["TotalAmount"]) - $row["Allocated"] != 0;
}
function order_link($row)
{
    return $row['order_'] > 0 ? get_customer_trans_view_str(ST_SALESORDER, $row['order_']) : "";
}
function systype_name($dummy, $type)
{

    }
    $Ajax->activate('orders_tbl');
}
//--------------------------------------------------------------------------------------
if (isset($_GET["stock_id"])) {
    $_POST['SelectedStockItem'] = $_GET["stock_id"];
}
//--------------------------------------------------------------------------------------
start_form(false, false, $_SERVER['PHP_SELF'] . "?outstanding_only={$outstanding_only}");
start_table(TABLESTYLE_NOBORDER);
start_row();
ref_cells(_("Reference:"), 'OrderNumber', '', null, '', true);
locations_list_cells(_("at Location:"), 'StockLocation', null, true);
check_cells(_("Only Overdue:"), 'OverdueOnly', null);
if ($outstanding_only == 0) {
    check_cells(_("Only Open:"), 'OpenOnly', null);
}
stock_manufactured_items_list_cells(_("for item:"), 'SelectedStockItem', null, true);
submit_cells('SearchOrders', _("Search"), '', _('Select documents'), 'default');
end_row();
end_table();
//-----------------------------------------------------------------------------
function check_overdue($row)
{
    return !$row["closed"] && date_diff2(Today(), sql2date($row["required_by"]), "d") > 0;
}
function view_link($dummy, $order_no)
{
    return get_trans_view_str(ST_WORKORDER, $order_no);
}
function view_stock($row)

        submit_center('submit', _("Add New Customer"), true, '', 'default');
    } else {
        submit_center_first('submit', _("Update Customer"), _('Update customer data'), @$_REQUEST['popup'] ? true : 'default');
        submit_return('select', $selected_id, _("Select this customer and return to document entry."));
        submit_center_last('delete', _("Delete Customer"), _('Delete customer data if have been never used'), true);
    }
    div_end();
}
//--------------------------------------------------------------------------------------------
check_db_has_sales_types(_("There are no sales types defined. Please define at least one sales type before adding a customer."));
start_form();
if (db_has_customers()) {
    start_table(TABLESTYLE_NOBORDER);
    start_row();
    customer_list_cells(_("Select a customer: "), 'customer_id', null, _('New customer'), true, check_value('show_inactive'));
    check_cells(_("Show inactive:"), 'show_inactive', null, true);
    end_row();
    end_table();
    if (get_post('_show_inactive_update')) {
        $Ajax->activate('customer_id');
        set_focus('customer_id');
    }
} else {
    hidden('customer_id');
}
if (!$selected_id) {
    unset($_POST['_tabs_sel']);
}
// force settings tab for new customer
tabbed_content_start('tabs', array('settings' => array(_('&General settings'), $selected_id), 'contacts' => array(_('&Contacts'), $selected_id), 'transactions' => array(_('&Transactions'), $selected_id), 'orders' => array(_('Sales &Orders'), $selected_id)));
switch (get_post('_tabs_sel')) {

    date_cells(_("from:"), 'OrdersAfterDate', '', null, -30);
    date_cells(_("to:"), 'OrdersToDate', '', null, 1);
}
locations_list_cells(_("Location:"), 'StockLocation', null, true);
if ($show_dates) {
    end_row();
    end_table();
    start_table(TABLESTYLE_NOBORDER);
    start_row();
}
stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true);
if (!@$_GET['popup']) {
    customer_list_cells(_("Select a customer: "), 'customer_id', null, true);
}
if ($trans_type == ST_SALESQUOTE) {
    check_cells(_("Show All:"), 'show_all');
}
submit_cells('SearchOrders', _("Search"), '', _('Select documents'), 'default');
hidden('order_view_mode', $_POST['order_view_mode']);
hidden('type', $trans_type);
end_row();
end_table(1);
//---------------------------------------------------------------------------------------------
//	Orders inquiry table
//
$sql = get_sql_for_sales_orders_view($selected_customer, $trans_type, $_POST['OrderNumber'], $_POST['order_view_mode'], @$selected_stock_item, @$_POST['OrdersAfterDate'], @$_POST['OrdersToDate'], @$_POST['OrderReference'], $_POST['StockLocation'], $_POST['customer_id']);
if ($trans_type == ST_SALESORDER) {
    $cols = array(_("Order #") => array('fun' => 'view_link'), _("Ref"), _("Customer"), _("Branch"), _("Cust Order Ref"), _("Order Date") => 'date', _("Required By") => array('type' => 'date', 'ord' => ''), _("Delivery To"), _("Order Total") => array('type' => 'amount', 'ord' => ''), 'Type' => 'skip', _("Currency") => array('align' => 'center'));
} else {
    $cols = array(_("Quote #") => array('fun' => 'view_link'), _("Ref"), _("Customer"), _("Branch"), _("Cust Order Ref"), _("Quote Date") => 'date', _("Valid until") => array('type' => 'date', 'ord' => ''), _("Delivery To"), _("Quote Total") => array('type' => 'amount', 'ord' => ''), 'Type' => 'skip', _("Currency") => array('align' => 'center'));
}

//
if (get_post('Search')) {
    $Ajax->activate('journal_tbl');
}
//--------------------------------------------------------------------------------------
if (!isset($_POST['filterType'])) {
    $_POST['filterType'] = -1;
}
start_form();
start_table(TABLESTYLE_NOBORDER);
start_row();
ref_cells(_("Reference:"), 'Ref', '', null, _('Enter reference fragment or leave empty'));
journal_types_list_cells(_("Type:"), "filterType");
date_cells(_("From:"), 'FromDate', '', null, 0, -1, 0);
date_cells(_("To:"), 'ToDate');
check_cells(_("Show closed:"), 'AlsoClosed', null);
submit_cells('Search', _("Search"), '', '', 'default');
end_row();
start_row();
ref_cells(_("Memo:"), 'Memo', '', null, _('Enter memo fragment or leave empty'));
end_row();
end_table();
function journal_pos($row)
{
    return $row['gl_seq'] ? $row['gl_seq'] : '-';
}
function systype_name($dummy, $type)
{
    global $systypes_array;
    return $systypes_array[$type];
}

        $exemptions = get_item_tax_type_exemptions($selected_id);
        if (db_num_rows($exemptions) > 0) {
            while ($exmp = db_fetch($exemptions)) {
                $_POST['ExemptTax' . $exmp["tax_type_id"]] = 1;
            }
        }
    }
    hidden('selected_id', $selected_id);
}
text_row_ex(_("Description:"), 'name', 50);
yesno_list_row(_("Is Fully Tax-exempt:"), 'exempt', null, "", "", true);
end_table(1);
if (!isset($_POST['exempt']) || $_POST['exempt'] == 0) {
    display_note(_("Select which taxes this item tax type is exempt from."), 0, 1);
    start_table(TABLESTYLE2);
    $th = array(_("Tax Name"), _("Rate"), _("Is exempt"));
    table_header($th);
    $tax_types = get_all_tax_types_simple();
    while ($myrow = db_fetch($tax_types)) {
        alt_table_row_color($k);
        label_cell($myrow["name"]);
        label_cell(percent_format($myrow["rate"]) . " %", "nowrap align=right");
        check_cells("", 'ExemptTax' . $myrow["id"], null);
        end_row();
    }
    end_table(1);
}
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
//------------------------------------------------------------------------------------
end_page();

foreach ($installers as $i => $inst) {
    alt_table_row_color($k);
    start_row();
    label_cell($inst->version);
    label_cell($inst->description);
    label_cell($inst->sql ? $inst->sql : '<i>' . _('None') . '</i>', 'align=center');
    // this is checked only for first (site admin) company,
    // but in fact we should always upgrade all data sets after
    // source upgrade.
    $check = $inst->installed(TB_PREF);
    if ($check === true) {
        label_cell(_("Installed"));
    } else {
        if (!$check) {
            check_cells(null, 'install_' . $i, 0);
        } else {
            label_cell("<span class=redfg>" . sprintf(_("Partially installed (%s)"), $check) . "</span>");
            $partial++;
        }
    }
    check_cells(null, 'force_' . $i, 0);
    end_row();
}
end_table(1);
if ($partial != 0) {
    display_note(_("Database upgrades marked as partially installed cannot be installed automatically.\nYou have to clean database manually to enable them, or try to perform forced upgrade."));
    br();
}
submit_center('Upgrade', _('Upgrade system'), true, _('Save database and perform upgrade'), 'process');
end_form();
end_page();

        continue;
    }
    $newsec = $parms[0] >> 8 & 0xff;
    $newext = $parms[0] >> 16;
    if ($newsec != $sec || $newext != $ext && $newsec > 99) {
        // features set selection
        $ext = $newext;
        $sec = $newsec;
        $m = $parms[0] & ~0xff;
        //			if(!isset($security_sections[$m]))
        //			 display_error(sprintf("Bad section %X:", $m));
        label_row($security_sections[$m] . ':', checkbox(null, 'Section' . $m, null, true, _("On/off set of features")), "class='tableheader2'", "class='tableheader'");
    }
    if (check_value('Section' . $m)) {
        alt_table_row_color($k);
        check_cells($parms[1], 'Area' . $parms[0], null, false, '', "align='center'");
        end_row();
    } else {
        hidden('Area' . $parms[0]);
    }
}
end_table(1);
div_end();
div_start('controls');
if ($new_role) {
    submit_center_first('Update', _("Update view"), '', null);
    submit_center_last('addupdate', _("Insert New Role"), '', 'default');
} else {
    submit_center_first('addupdate', _("Save Role"), '', 'default');
    submit('Update', _("Update view"), true, '', null);
    submit('clone', _("Clone This Role"), true, '', true);

}
if (isset($_GET['ToDate'])) {
    $_POST['TransToDate'] = $_GET['ToDate'];
}
//------------------------------------------------------------------------------------------------
start_form(false, true);
if (!isset($_POST['supplier_id'])) {
    $_POST['supplier_id'] = get_global_supplier();
}
start_table("class='tablestyle_noborder'");
start_row();
supplier_list_cells(tr("Select a supplier: "), 'supplier_id', $_POST['supplier_id'], true);
date_cells(tr("From:"), 'TransAfterDate', null, -30);
date_cells(tr("To:"), 'TransToDate', null, 1);
supp_allocations_list_cells("filterType", null);
check_cells(tr("show settled:"), 'showSettled', null);
submit_cells('Refresh Inquiry', tr("Search"));
set_global_supplier($_POST['supplier_id']);
end_row();
end_table();
end_form();
//------------------------------------------------------------------------------------------------
function get_transactions()
{
    global $db;
    $date_after = date2sql($_POST['TransAfterDate']);
    $date_to = date2sql($_POST['TransToDate']);
    // Sherifoz 22.06.03 Also get the description
    $sql = "SELECT supp_trans.type, supp_trans.trans_no,\n    \tsupp_trans.tran_date, supp_trans.reference, supp_trans.supp_reference,\n    \t(supp_trans.ov_amount + supp_trans.ov_gst  + supp_trans.ov_discount) AS TotalAmount, supp_trans.alloc AS Allocated,\n\t\t((supp_trans.type = 20 OR supp_trans.type = 21) AND supp_trans.due_date < '" . date2sql(Today()) . "') AS OverDue,\n\t\tsuppliers.curr_code, suppliers.supp_name, supp_trans.due_date\n    \tFROM supp_trans, suppliers\n    \tWHERE suppliers.supplier_id = supp_trans.supplier_id\n     \tAND supp_trans.tran_date >= '{$date_after}'\n    \tAND supp_trans.tran_date <= '{$date_to}'";
    if ($_POST['supplier_id'] != reserved_words::get_all()) {
        $sql .= " AND supp_trans.supplier_id = '" . $_POST['supplier_id'] . "'";