List of clients who ordered a product with payed - not payed indication

[corine57]

Hi,

we are currently still on 1.2_10 (still on joomla 1.0.15) so I noticed your announcement for version 2.x, I assume that means switching to joomla 1.5.x as well?

anyway, what I need for my customer is to create a list of clients who have ordered a specific product. Now that I can do under the order menu, by using the product filter and set the time-frame.

BUT, I also want that list marked with which clients have paid and which have not (yet), as we have manual payments involved, and sometimes people abort their electronic banking thing as well. So the invoice is still set to not paid, but how do I cross reference and generate that needed list?

kind regards,
Corine

[netshine]

nBill 2 runs ok on Joomla 1.0 - I have no plans to drop support for Joomla 1.0, as I use it myself! nBill is written in a platform agnostic way, so there is no problem - it could potentially be adapted to suit any content management system fairly easily.

I'm afraid the only way to achieve what you want is by accessing the database directly. For example, if you use phpMyAdmin, you could enter an SQL query like this to retrieve the order details for October 2010:

SELECT jos_inv_orders.*, jos_inv_invoice.paid_in_full, jos_inv_invoice.partial_payment FROM jos_inv_orders LEFT JOIN jos_inv_orders_invoice ON jos_inv_orders.id = jos_inv_orders_invoice.order_id INNER JOIN jos_inv_invoice ON jos_inv_orders_invoice.invoice_id = jos_inv_invoice.id WHERE jos_inv_orders.start_date BETWEEN UNIX_TIMESTAMP('2010-10-01') AND UNIX_TIMESTAMP('2010-10-31')

The above will only work in nBill 1 as the table names have changed in nBill 2.

[corine57]

Hi,

thanks for your reply. Glad we can continue under joomla 1.0.15, but how about this newer version of nBill, do we have to upgrade tot that? Do we have to pay for that?

and your sql statement works, as far as i can tell, and I can now adjust it to our needs, so thank you very much!!!

kind regards
Corine

[netshine]

Version 2.1 of nBill will still work with Joomla 1.0.15. There is a fee to upgrade from nBill 1 to nBill 2 (see FAQ no. 15: http://www.nbill.co.uk/about/frequently-asked-questions.html and the upgrade form: http://www.nbill.co.uk/component/option,com_nbill/Itemid,0/action,orders/task,order/cid,3/).