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

Showing 1 to 10 of 105 entries

# ID Order no Order date Customer name Order amount Order status Actions
1 80 74040 2016-09-10 52 Completed
2 82 84334 2016-09-08 Xenos Clarke 7 Completed
3 83 91414 2016-09-08 Xenos Clarke 91 Completed
4 85 71212 2016-09-08 33 Completed
5 86 14459 2016-09-08 43 Completed
6 87 22844 2016-09-08 17 Completed
7 88 43892 2016-09-08 55 Completed
8 89 72412 2016-09-08 22 Completed
9 90 64889 2016-09-08 Xenos Clarke 46 Completed
10 91 5518 2016-09-08 Cooper Jensen 64 Completed
# ID Order no Order date Customer name Order amount Order status Actions