Date range wise report Display month wise, day wise, year wise report buttons (Added in version 3.0)

You can directly add month wise, day wise, year wise (calendar as well day duration wise) report buttons to generate the table data based on the date range. Please note it work for the CRUD table not for SQL as sql statement can be of anytype. 

  
                                $pdocrud = new PDOCrud();
                                /**
                                * Add date range report buttons (eg daily ,monthly ,yearly report button)
                                * @param   string   $text                          Name/Text of the button
                                * @param   string   $type                          Type of the report to be generated.
                                * return   object                                  Object of class
                                */
                                $pdocrud->addDateRangeReport("This Year", "calendar_year", "order_date");
                                $pdocrud->addDateRangeReport("This Month", "calendar_month", "order_date");
                                $pdocrud->addDateRangeReport("Last 365 days", "year", "order_date");
                                $pdocrud->addDateRangeReport("Last 30 days", "month", "order_date");
                                $pdocrud->addDateRangeReport("1 Day", "Last 1 day", "order_date");
                                $pdocrud->addDateRangeReport("Today", "today", "order_date");
                                echo $pdocrud->dbTable("orders")->render();

Orders

Add

Showing 1 to 10 of 69 entries

Go
This Year
This Month
Last 365 days
Last 30 days
1 Day
Today
# ID Order no Order date Customer name Order amount Order status Actions
1 39 578 2016-09-30 Xenos Clarke 955 Completed
2 40 93062 2016-09-08 Cooper Jensen 32 Completed
3 41 76778 2016-09-09 Deacon Tyson 77 Pending
4 42 66729 2016-09-08 Cooper Jensen 90 Completed
5 43 62940 2016-09-08 Deacon Tyson 20 Completed
6 44 22241 2016-09-08 Xenos Clarke 30 Completed
7 45 40334 2016-09-08 87 Completed
8 46 30771 2016-09-08 461 Completed
9 47 96349 2016-09-08 71 Completed
10 48 72881 2016-09-08 18 Completed
# ID Order no Order date Customer name Order amount Order status Actions