WebsiteBaker Support (2.8.x) > Bakery Shop
Bakery Reports Add-on
svsanchez:
Hello hillschmidt, are you the developer of the Bakery module? What I meant by Sales and Stock reports is:
SALES REPORT
Being able to generate a report by date for example chose the month and see all orders from that month, that way we easily know how much we sold during that period. Example:
01/10/2013 Customer A Name Order #001 $55
02/10/2013 Customer B Name Order #002 $49
...
31/10/2013 Customer C Name Order #100 $89
--------------------------------------------------------------------------
TOTAL SALES DURING OCTOBER 2013: $5000
If it were possible to set the dates range for the report it would be so much great! And also possibility of exporting to Excel!
STOCK REPORT:
If it were possible to export the Stock to Excel it would be very useful!
hillschmidt:
No, I'm not the developer ...
... but looking into with SQL now ...
... the basis so far are two SELECTs:
select * from wb_mod_bakery_custo mer where order_date >= UNIX_TIMESTAMP('..') and ...< ...
so that in PHP a loop could follow for each entry:
select quantity, shipping, price from wb_mod_bakery_order where order_id=...
but very rudimental in the moment (no time) and probably not in sync with the real invoice ...
Will see what will happen ...
hillschmidt:
got kind of, using a quick and dirty call for the moment:
--- Code: ---http://my_baker_domain/CMS/modules/bakery/test_order_summary.php?page_id=20§ion_id=30&YYYY=2013&MM=11
--- End code ---
So far, I do not use a selection form for YYYY and MM ...
The script bases on view_order.php, so far quick&dirty code but the output (German Shop) looks like this:
where Adresse is only the name of the customer.
Also the total is not correct yet ... some improvements needed of course ... but looks this O.K. for a starting point ?
Changed the script again - now the Sum is correct (problem with the German , as decimal separator and the needed .)
svsanchez:
Hello Hillshmidt, that's looking awesome, I didn't understand what you said about the selection of YYYY and MM, how are you telling Bakery to show you only the November report?
hillschmidt:
--- Quote ---how are you telling Bakery to show you only the November report
--- End quote ---
That's one I will improve (if time remains): currently you could call the script only manual with page_id, section_id you need to know for a Bakery page, and also for the year YYYY and Month MM:
my_baker_domain/CMS/modules/bakery/test_order_summary.php?page_id=20§ion_id=30&YYYY=2013&MM=11
But having a new selection form on the admin page for reports like this, you could select and change this - currently you must type the lengthy URL and change manually to see another month/year, e.g.
my_baker_domain/CMS/modules/bakery/test_order_summary.php?page_id=20§ion_id=30&YYYY=2012&MM=07
for July 2012 e.g.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version