batch center it is great reporting tool

[nana]

this is a great contribution i just installed it on ms2 and it seems to work.it gives you a list of all orders in PDF it gives a lots of functionality and it could be one of the greatest tool for a shop owner if some one can modify it so the shop owner can choose the field to look in

$orders_query = tep_db_query("select o.orders_id,h.comments,MIN(h.date_added) from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_STATUS_HISTORY . " h where o.date_purchased like '" . tep_db_input($date) . "%' and h.orders_id = o.orders_id" . $pull_w_status . $get_customer_comments . ' group by o.orders_id');

this is where it matches the date. it should be easy to create a drop down of the TABLE_ORDERS

so the shop owner decides which field to search.

// CHECK DATE ENTERED, GRAB ALL ORDERS FROM THAT DATE, AND CREATE PDF FOR ORDERS
if (!isset($HTTP_POST_VARS['date'])) { message_handler(); }
if ((strlen($HTTP_POST_VARS['date']) != 10) || verify_date($HTTP_POST_VARS['date'])) { message_handler('ERROR_BAD_DATE'); }
if (!is_writeable(BATCH_PDF_DIR)) { message_handler('SET_PERMISSIONS'); }
$time0   = time();
$date = tep_db_prepare_input($HTTP_POST_VARS['date']);

this is where the date is entered and has to be modified and there is a little bit more at the end of the file. i have already tried changing the field in the file and it works now it would be nice if one of the more knowledgeable people on the forum to give a hand if they have a few minutes.