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();
                                

Deprecated: Optional parameter $op declared before required parameter $task is implicitly treated as a required parameter in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOCrud.php on line 924

Deprecated: Creation of dynamic property PDOCrud::$langData is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOCrud.php on line 2075

Deprecated: Optional parameter $page declared before required parameter $totalrecords is implicitly treated as a required parameter in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOCrudHelper.php on line 191

Deprecated: Creation of dynamic property PDOModel::$characterSet is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOModel.php on line 117

Deprecated: strtoupper(): Passing null to parameter #1 ($string) of type string is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOModel.php on line 964

Deprecated: strtoupper(): Passing null to parameter #1 ($string) of type string is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOModel.php on line 964

Deprecated: Creation of dynamic property PDOModel::$characterSet is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOModel.php on line 117

Deprecated: strtoupper(): Passing null to parameter #1 ($string) of type string is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOModel.php on line 964

Deprecated: Creation of dynamic property PDOCrud::$dataHTML is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOCrud.php on line 2139

Deprecated: Creation of dynamic property PDOCrud::$fieldList is deprecated in /home/javad/domains/javadfk.ir/public_html/pdocrud/script/classes/PDOCrud.php on line 2140

Orders

Showing 1 to 5 of 63 entries

# ID Order no Order date Customer name Order amount Order status Actions
1 46 30771 2016-09-08 Gillian Kirk 461 Completed
2 48 72881 2016-09-08 Risa Ayers 18 Completed
3 49 36914444 2016-09-08 Callum Solomon 75 Completed
4 50 77099 2016-09-08 Nola Rojas 20 Completed
5 51 37429 2016-09-08 Talon Rowland 77 Completed
# ID Order no Order date Customer name Order amount Order status Actions