Credit Card Bath Report

[newtech]

I am using the Credit Card Bath Report Contrib:

http://www.oscommerce.com/community/contri...rd+batch+report

 

Here is a problem I am having with this contrib when using with ot dicounts contrib

http://www.oscommerce.com/community/contributions,4269

 

The credit card batch report is adding the subtotals of both credit cards and cash orders properly if there is no discount. However, if there is a discount, it is showing the discount amount (the 10% discount) instead of the subtoal of the order.

 

All my other reports show the subtotals properly, so it is not an ot discount contrib problem. It has to be a problem with credit card batch report contrib.

 

Any idea of how to fix this? I have added the code where I think it is gathering the subtotal data.

 

ALSO:

There is an inherent flaw with this contrib anyways. Why is it grabbing subtotals anyways? It should be gathering Grand Totals. If you are going to compare credit card totals (and cash totals) from oscommerce with actual credit card transactions and deposits made by store owner, then you would want grand totals.

 

Anyone know how to change the code in credit card batch report contrib to grab grand totals instead of subtotals?

 

 

QUOTE

 

<?php

if (isset($_GET['month']) or isset($_GET['status']) ) {

$batch_query_raw = "select o.customers_id, ot.value, ot.title, ot.class, o.date_purchased, o.orders_id, o.cc_type, o.payment_method from ". TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot where " . $os . " o.orders_id = ot.orders_id and o.date_purchased between '" . $date1 . "' and '" . $date2 . "' GROUP BY o.orders_id ORDER BY o.date_purchased DESC ";

} else {

$batch_query_raw = "select o.customers_id, ot.value, ot.title, ot.class, o.date_purchased, o.orders_id, o.cc_type, o.payment_method from ". TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot where " . $os . " o.orders_id = ot.orders_id GROUP BY o.orders_id ORDER BY o.date_purchased DESC ";

}