示例#1
0
$r->add_textbox("s_ed", DATE, END_DATE_MSG);
$r->change_property("s_ed", VALUE_MASK, $date_edit_format);
$r->change_property("s_ed", TRIM, true);
$r->add_checkboxlist("s_os_list", INTEGER, $order_statuses);
array_unshift($order_statuses, array("", ""));
$r->add_select("s_os", INTEGER, $order_statuses);
$r->add_select("s_ci", TEXT, $countries);
$r->add_select("s_category", TEXT, $categories);
//Customization by Vital
$r->add_select("s_si", TEXT, $states);
$r->add_select("s_cct", TEXT, $credit_card_types);
$r->add_select("s_ex", TEXT, $export_options);
if ($sitelist) {
    $r->add_select("s_sti", TEXT, $sites);
}
$r->get_form_parameters();
$r->validate();
$where = "";
$product_search = false;
if (!$r->errors) {
    if (!$r->is_empty("s_on")) {
        $s_on = $r->get_value("s_on");
        if (preg_match("/^(\\d+)(,\\d+)*\$/", $s_on)) {
            $where = " (o.order_id IN (" . $s_on . ") ";
            $where .= " OR o.invoice_number=" . $db->tosql($s_on, TEXT);
            $where .= " OR o.transaction_id=" . $db->tosql($s_on, TEXT) . ") ";
        } else {
            $where .= " (o.invoice_number=" . $db->tosql($s_on, TEXT);
            $where .= " OR o.transaction_id=" . $db->tosql($s_on, TEXT) . ") ";
        }
    }