How to generate monthly reports
Product comparison fixed single, now to calculate each product in the monthly sales, browse, Commission, whether the settlement and other parameters
When I got the demand, I thought that each product generated a monthly data, so no matter where the search is convenient, and each query is basically not calculated.
Workaround one, write a timed scheduled task that is generated at the end of each month, but this also manages the scheduled task,
Workaround two, provide a button in the background, "Generate a Bill", click, calculate the month before the monthly bill,
Do you have any better solutions for this kind of monthly report of Daniel?
Share to:
------Solution--------------------
You can also create a view
------Solution--------------------
PHP calls the database view or stored procedures to implement, monthly report data statistics, and then generate the display format through PHP