function current_countries_array($first_option = false)
{
global $db;
$countries_array = array();
if ($first_option) {
$countries_array[] = array('id' => '', 'text' => $first_option);
}
$countries_array[] = array('id' => get_store_country_name(), 'text' => get_store_country_name());
$countries_array[] = array('id' => 'International', 'text' => 'International');
$countries = $db->Execute("SELECT DISTINCT customers_country\n FROM " . TABLE_ORDERS . "\n WHERE customers_country <> '" . get_store_country_name() . "'\n ORDER BY customers_country");
while (!$countries->EOF) {
$countries_array[] = array('id' => $countries->fields['customers_country'], 'text' => $countries->fields['customers_country']);
$countries->MoveNext();
}
return $countries_array;
}
/* BEGIN addition added seach by OrderID Range */
if (isset($_GET['oid_range_first']) && zen_not_null($_GET['oid_range_first']) && isset($_GET['oid_range_last']) && zen_not_null($_GET['oid_range_last'])) {
$orders_query_raw .= " AND o.orders_id BETWEEN " . (int) $_GET['oid_range_first'] . " AND " . (int) $_GET['oid_range_last'];
} else {
if (isset($_GET['oid_range_first']) && zen_not_null($_GET['oid_range_first'])) {
$orders_query_raw .= " AND o.orders_id >= " . (int) $_GET['oid_range_first'] . " ";
} else {
if (isset($_GET['oid_range_last']) && zen_not_null($_GET['oid_range_last'])) {
$orders_query_raw .= " AND o.orders_id <= " . (int) $_GET['oid_range_last'] . " ";
}
}
}
/* added seach by country */
if (isset($_GET['countries']) && zen_not_null($_GET['countries'])) {
if ($_GET['countries'] == 'International') {
$orders_query_raw .= " AND o.customers_country <> '" . get_store_country_name() . "' ";
} else {
$orders_query_raw .= " AND o.customers_country = '" . $_GET['countries'] . "' ";
}
}
/* END addition */
$orders_query_raw .= " ORDER BY o.orders_id DESC";
$orders = $db->Execute($orders_query_raw);
if ($orders->RecordCount() > 0) {
/* BEGIN modification updated form to include pdf forms */
/* show forms based on configuration preference */
/* 0 - standard form
1 - pdf form
2 - both forms
*/
echo zen_draw_form('batch_print', FILENAME_SUPER_BATCH_FORMS, 'action=batch_forms', 'post', 'target="_blank"');