Order search

[JohnDoeh]

does anyone know where to start in order to create a search for the order.php page ?

 

I would like to be able to search for any kind information like ordered products, names, email address, ...

 

any help is welcome

 

jguirim karim jguirim karim

[wheeloftime]

does anyone know where to start in order to create a search for the order.php page ?

 

I would like to be able to search for any kind information like ordered products, names, email address, ...

 

any help is welcome

 

jguirim karim jguirim karim

You will have to venture through the admin/orders.php file.

If you search the file you will find:

<?php echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('oID', '', 'size="12"') . tep_draw_hidden_field('action', 'edit'); ?>

which is the little searchbox you find in the upper right corner of your screen. Out of the box it is only meant for searches on the orderid because of this related part:

  if (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {
$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

$orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");
$order_exists = true;
if (!tep_db_num_rows($orders_query)) {
  $order_exists = false;
  $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');
}
 }

You'll have to adjust these two parts to get some more flexible search options here.

 

HTH