$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) . ") "; } }