Hallo Schreinermeister,
das Modul kann nicht nur nach den Artikelnamen, sondern auch nach den Artikelnummern suchen.
Dazu diese Abfrage
//BOF - Spegeli - 2011-15-08 added for ADMIN SEARCH BAR
if ($action == 'search' && $_GET['aoID']) {
$aoID = xtc_db_prepare_input($_GET['aoID']);
$orders_query_raw = "select o.orders_id, o.afterbuy_success, o.afterbuy_id, o.customers_name, o.customers_cid, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, op.orders_id, op.products_name from ".TABLE_ORDERS." o left join ".TABLE_ORDERS_TOTAL." ot on (o.orders_id = ot.orders_id) left join ".TABLE_ORDERS_PRODUCTS." op on (o.orders_id = op.orders_id), ".TABLE_ORDERS_STATUS." s where o.orders_status = s.orders_status_id and s.language_id = '".$_SESSION['languages_id']."' and op.products_name LIKE '%".xtc_db_input($aoID)."%' and ot.class = 'ot_total' order by o.orders_id DESC";
$orders_query = xtc_db_query($orders_query_raw);
$order_exists = false;
if (xtc_db_num_rows($orders_query) == 1) {
$order_exists = true;
$oID_array = xtc_db_fetch_array($orders_query);
$oID = $oID_array['orders_id'];
$_GET['action'] = 'edit';
$action = 'edit';
$_GET['oID'] = $oID;
//$messageStack->add('1 Treffer: ' . $aoID, 'notice');
}
}
//EOF - Spegeli - 2011-15-08 added for ADMIN SEARCH BAR
mit dieser Ersetzen
if ($action == 'search' && $_GET['aoID']) {
$aoID = xtc_db_prepare_input($_GET['aoID']);
$orders_query_raw = "select o.orders_id,
o.afterbuy_success,
o.afterbuy_id,
o.customers_name,
o.customers_cid,
o.payment_method,
o.date_purchased,
o.last_modified,
o.currency,
o.currency_value,
s.orders_status_name,
ot.text as order_total,
op.orders_id,
op.products_name,
op.products_model
from ".TABLE_ORDERS." o
left join ".TABLE_ORDERS_TOTAL." ot
on (o.orders_id = ot.orders_id)
left join ".TABLE_ORDERS_PRODUCTS." op
on (o.orders_id = op.orders_id), ".TABLE_ORDERS_STATUS." s
where o.orders_status = s.orders_status_id
and s.language_id = '".$_SESSION['languages_id']."'
and (op.products_name LIKE '%".xtc_db_input($aoID)."%' or op.products_model LIKE '%".xtc_db_input($aoID)."%')
and ot.class = 'ot_total'
order by o.orders_id DESC";
$orders_query = xtc_db_query($orders_query_raw);
$order_exists = false;
if (xtc_db_num_rows($orders_query) == 1) {
$order_exists = true;
$oID_array = xtc_db_fetch_array($orders_query);
$oID = $oID_array['orders_id'];
$_GET['action'] = 'edit';
$action = 'edit';
$_GET['oID'] = $oID;
//$messageStack->add('1 Treffer: ' . $aoID, 'notice');
}
}
Mit dieser Änderung kann es beides.
Und wenn man dann noch in der admin/includes/admin_search_bar.php nach
$search_ord = '';
folgendes einfügt
$search_pord = '';
sowie satt
<li>
<form action="<?php echo xtc_href_link('orders.php'); ?>" method="get">
<?php echo ASB_QUICK_SEARCH_ORDER_ARTICLE; ?>
<input name="aoID" type="text" value="<?php echo $search_pord;?>" size="15" />
<input type="hidden" name="action" value="search" />
</form>
</li>
das
<li>
<form action="<?php echo xtc_href_link('orders.php'); ?>" method="get">
<?php echo ASB_QUICK_SEARCH_ORDER_ARTICLE; ?>
<input name="aoID" type="text" value="<?php echo $search_pord;?>" size="20" />
<input type="hidden" name="action" value="search" />
<input name="<?php echo xtc_session_name(); ?>" type="hidden" value="<?php echo xtc_session_id(); ?>" />
</form>
</li>
einfügt, wird es langsam rund.
Gruß Thomas