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 101 entries

# ID Order no Order date Customer name Order amount Order status Actions
1 43 62940 2016-09-08 someone 20 Completed
2 44 22241 2016-09-08 29 Completed
3 48 72881 2016-09-08 Cooper Jensen 18 Completed
4 50 77099 2016-09-08 Nola Rojas 20 Completed
5 52 44144 2016-09-08 Cheryl Bowers 26 Completed
6 54 54999 2016-09-08 Lacota Bonner 5 Completed
7 55 83323 2016-09-08 Bradley Freeman 37 Completed
8 57 50683 2016-09-08 Hilary Conner 28 Completed
9 58 931435 2016-09-08 Zena Fox 37 Completed
10 59 48121 2016-09-08 Britanni Schmidt 1 Completed
# ID Order no Order date Customer name Order amount Order status Actions