koolreport\core\DataStore Object
(
    [sources:protected] => Array
        (
            [0] => koolreport\processes\Limit Object
                (
                    [sources:protected] => Array
                        (
                            [0] => koolreport\processes\Sort Object
                                (
                                    [sources:protected] => Array
                                        (
                                            [0] => koolreport\datasources\PdoDataSource Object
                                                (
                                                    [sources:protected] => Array
                                                        (
                                                        )

                                                    [destinations:protected] => Array
                                                        (
                                                            [0] => koolreport\processes\Sort Object
 *RECURSION*
                                                        )

                                                    [is_ended:protected] => 1
                                                    [metaData:protected] => Array
                                                        (
                                                        )

                                                    [streamingSource:protected] => 
                                                    [params:protected] => Array
                                                        (
                                                            [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                            [username] => vsmartadmin
                                                            [password] => Vsmart%2021#
                                                            [charset] => utf8
                                                        )

                                                    [report:protected] => OnlineColumn_center Object
                                                        (
                                                            [params:protected] => Array
                                                                (
                                                                )

                                                            [dataSources:protected] => Array
                                                                (
                                                                    [0] => koolreport\datasources\PdoDataSource Object
 *RECURSION*
                                                                )

                                                            [dataStores:protected] => Array
                                                                (
                                                                    [sales_by_order_website] => koolreport\core\DataStore Object
 *RECURSION*
                                                                )

                                                            [resourceManager:protected] => koolreport\core\ResourceManager Object
                                                                (
                                                                    [tags:protected] => Array
                                                                        (
                                                                            [899d8a1cc5f716091a7083f2426ab078] => Array
                                                                                (
                                                                                    [at] => begin
                                                                                    [tag] => script
                                                                                    [options] => Array
                                                                                        (
                                                                                            [type] => text/javascript
                                                                                            [src] => /vendor_delete_folder/koolreport/core/src/clients/core/KoolReport.js
                                                                                        )

                                                                                    [content] => 
                                                                                )

                                                                            [5d28898e87fb51bbe88739940495e2e8] => Array
                                                                                (
                                                                                    [at] => begin
                                                                                    [tag] => script
                                                                                    [options] => Array
                                                                                        (
                                                                                            [type] => text/javascript
                                                                                        )

                                                                                    [content] => KoolReport.load.resources({"js":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/jquery\/jquery.min.js",["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/js\/bootstrap.min.js"]],"css":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap.min.css","\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap-theme.min.css"]});
                                                                                )

                                                                        )

                                                                    [report:protected] => OnlineColumn_center Object
 *RECURSION*
                                                                )

                                                            [theme:protected] => 
                                                            [templateEngine:protected] => 
                                                            [events:protected] => Array
                                                                (
                                                                    [OnResourceInit] => Array
                                                                        (
                                                                            [0] => Closure Object
                                                                                (
                                                                                    [this] => OnlineColumn_center Object
 *RECURSION*
                                                                                )

                                                                            [1] => Closure Object
                                                                                (
                                                                                    [this] => OnlineColumn_center Object
 *RECURSION*
                                                                                )

                                                                        )

                                                                )

                                                            [reportSettings:protected] => Array
                                                                (
                                                                    [dataSources] => Array
                                                                        (
                                                                            [sales] => Array
                                                                                (
                                                                                    [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                                                    [username] => vsmartadmin
                                                                                    [password] => Vsmart%2021#
                                                                                    [charset] => utf8
                                                                                )

                                                                        )

                                                                )

                                                        )

                                                    [connection:protected] => PDO Object
                                                        (
                                                        )

                                                    [query:protected] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                                    [sqlParams:protected] => 
                                                    [queryParams:protected] => 
                                                    [countTotal:protected] => 
                                                    [countFilter:protected] => 
                                                    [errorInfo:protected] => 
                                                    [originalQuery] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                                )

                                        )

                                    [destinations:protected] => Array
                                        (
                                            [0] => koolreport\processes\Limit Object
 *RECURSION*
                                        )

                                    [is_ended:protected] => 1
                                    [metaData:protected] => Array
                                        (
                                            [columns] => Array
                                                (
                                                    [fo_date] => Array
                                                        (
                                                            [type] => string
                                                        )

                                                    [odate] => Array
                                                        (
                                                            [type] => number
                                                        )

                                                    [order_date] => Array
                                                        (
                                                            [type] => string
                                                        )

                                                    [PD_count] => Array
                                                        (
                                                            [type] => number
                                                        )

                                                    [BOOK_count] => Array
                                                        (
                                                            [type] => number
                                                        )

                                                )

                                        )

                                    [streamingSource:protected] => koolreport\datasources\PdoDataSource Object
                                        (
                                            [sources:protected] => Array
                                                (
                                                )

                                            [destinations:protected] => Array
                                                (
                                                    [0] => koolreport\processes\Sort Object
 *RECURSION*
                                                )

                                            [is_ended:protected] => 1
                                            [metaData:protected] => Array
                                                (
                                                )

                                            [streamingSource:protected] => 
                                            [params:protected] => Array
                                                (
                                                    [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                    [username] => vsmartadmin
                                                    [password] => Vsmart%2021#
                                                    [charset] => utf8
                                                )

                                            [report:protected] => OnlineColumn_center Object
                                                (
                                                    [params:protected] => Array
                                                        (
                                                        )

                                                    [dataSources:protected] => Array
                                                        (
                                                            [0] => koolreport\datasources\PdoDataSource Object
 *RECURSION*
                                                        )

                                                    [dataStores:protected] => Array
                                                        (
                                                            [sales_by_order_website] => koolreport\core\DataStore Object
 *RECURSION*
                                                        )

                                                    [resourceManager:protected] => koolreport\core\ResourceManager Object
                                                        (
                                                            [tags:protected] => Array
                                                                (
                                                                    [899d8a1cc5f716091a7083f2426ab078] => Array
                                                                        (
                                                                            [at] => begin
                                                                            [tag] => script
                                                                            [options] => Array
                                                                                (
                                                                                    [type] => text/javascript
                                                                                    [src] => /vendor_delete_folder/koolreport/core/src/clients/core/KoolReport.js
                                                                                )

                                                                            [content] => 
                                                                        )

                                                                    [5d28898e87fb51bbe88739940495e2e8] => Array
                                                                        (
                                                                            [at] => begin
                                                                            [tag] => script
                                                                            [options] => Array
                                                                                (
                                                                                    [type] => text/javascript
                                                                                )

                                                                            [content] => KoolReport.load.resources({"js":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/jquery\/jquery.min.js",["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/js\/bootstrap.min.js"]],"css":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap.min.css","\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap-theme.min.css"]});
                                                                        )

                                                                )

                                                            [report:protected] => OnlineColumn_center Object
 *RECURSION*
                                                        )

                                                    [theme:protected] => 
                                                    [templateEngine:protected] => 
                                                    [events:protected] => Array
                                                        (
                                                            [OnResourceInit] => Array
                                                                (
                                                                    [0] => Closure Object
                                                                        (
                                                                            [this] => OnlineColumn_center Object
 *RECURSION*
                                                                        )

                                                                    [1] => Closure Object
                                                                        (
                                                                            [this] => OnlineColumn_center Object
 *RECURSION*
                                                                        )

                                                                )

                                                        )

                                                    [reportSettings:protected] => Array
                                                        (
                                                            [dataSources] => Array
                                                                (
                                                                    [sales] => Array
                                                                        (
                                                                            [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                                            [username] => vsmartadmin
                                                                            [password] => Vsmart%2021#
                                                                            [charset] => utf8
                                                                        )

                                                                )

                                                        )

                                                )

                                            [connection:protected] => PDO Object
                                                (
                                                )

                                            [query:protected] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                            [sqlParams:protected] => 
                                            [queryParams:protected] => 
                                            [countTotal:protected] => 
                                            [countFilter:protected] => 
                                            [errorInfo:protected] => 
                                            [originalQuery] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                        )

                                    [params:protected] => Array
                                        (
                                            [fo_date] => desc
                                        )

                                )

                        )

                    [destinations:protected] => Array
                        (
                            [0] => koolreport\core\DataStore Object
 *RECURSION*
                        )

                    [is_ended:protected] => 1
                    [metaData:protected] => Array
                        (
                            [columns] => Array
                                (
                                    [fo_date] => Array
                                        (
                                            [type] => string
                                        )

                                    [odate] => Array
                                        (
                                            [type] => number
                                        )

                                    [order_date] => Array
                                        (
                                            [type] => string
                                        )

                                    [PD_count] => Array
                                        (
                                            [type] => number
                                        )

                                    [BOOK_count] => Array
                                        (
                                            [type] => number
                                        )

                                )

                        )

                    [streamingSource:protected] => koolreport\processes\Sort Object
                        (
                            [sources:protected] => Array
                                (
                                    [0] => koolreport\datasources\PdoDataSource Object
                                        (
                                            [sources:protected] => Array
                                                (
                                                )

                                            [destinations:protected] => Array
                                                (
                                                    [0] => koolreport\processes\Sort Object
 *RECURSION*
                                                )

                                            [is_ended:protected] => 1
                                            [metaData:protected] => Array
                                                (
                                                )

                                            [streamingSource:protected] => 
                                            [params:protected] => Array
                                                (
                                                    [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                    [username] => vsmartadmin
                                                    [password] => Vsmart%2021#
                                                    [charset] => utf8
                                                )

                                            [report:protected] => OnlineColumn_center Object
                                                (
                                                    [params:protected] => Array
                                                        (
                                                        )

                                                    [dataSources:protected] => Array
                                                        (
                                                            [0] => koolreport\datasources\PdoDataSource Object
 *RECURSION*
                                                        )

                                                    [dataStores:protected] => Array
                                                        (
                                                            [sales_by_order_website] => koolreport\core\DataStore Object
 *RECURSION*
                                                        )

                                                    [resourceManager:protected] => koolreport\core\ResourceManager Object
                                                        (
                                                            [tags:protected] => Array
                                                                (
                                                                    [899d8a1cc5f716091a7083f2426ab078] => Array
                                                                        (
                                                                            [at] => begin
                                                                            [tag] => script
                                                                            [options] => Array
                                                                                (
                                                                                    [type] => text/javascript
                                                                                    [src] => /vendor_delete_folder/koolreport/core/src/clients/core/KoolReport.js
                                                                                )

                                                                            [content] => 
                                                                        )

                                                                    [5d28898e87fb51bbe88739940495e2e8] => Array
                                                                        (
                                                                            [at] => begin
                                                                            [tag] => script
                                                                            [options] => Array
                                                                                (
                                                                                    [type] => text/javascript
                                                                                )

                                                                            [content] => KoolReport.load.resources({"js":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/jquery\/jquery.min.js",["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/js\/bootstrap.min.js"]],"css":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap.min.css","\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap-theme.min.css"]});
                                                                        )

                                                                )

                                                            [report:protected] => OnlineColumn_center Object
 *RECURSION*
                                                        )

                                                    [theme:protected] => 
                                                    [templateEngine:protected] => 
                                                    [events:protected] => Array
                                                        (
                                                            [OnResourceInit] => Array
                                                                (
                                                                    [0] => Closure Object
                                                                        (
                                                                            [this] => OnlineColumn_center Object
 *RECURSION*
                                                                        )

                                                                    [1] => Closure Object
                                                                        (
                                                                            [this] => OnlineColumn_center Object
 *RECURSION*
                                                                        )

                                                                )

                                                        )

                                                    [reportSettings:protected] => Array
                                                        (
                                                            [dataSources] => Array
                                                                (
                                                                    [sales] => Array
                                                                        (
                                                                            [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                                            [username] => vsmartadmin
                                                                            [password] => Vsmart%2021#
                                                                            [charset] => utf8
                                                                        )

                                                                )

                                                        )

                                                )

                                            [connection:protected] => PDO Object
                                                (
                                                )

                                            [query:protected] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                            [sqlParams:protected] => 
                                            [queryParams:protected] => 
                                            [countTotal:protected] => 
                                            [countFilter:protected] => 
                                            [errorInfo:protected] => 
                                            [originalQuery] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                        )

                                )

                            [destinations:protected] => Array
                                (
                                    [0] => koolreport\processes\Limit Object
 *RECURSION*
                                )

                            [is_ended:protected] => 1
                            [metaData:protected] => Array
                                (
                                    [columns] => Array
                                        (
                                            [fo_date] => Array
                                                (
                                                    [type] => string
                                                )

                                            [odate] => Array
                                                (
                                                    [type] => number
                                                )

                                            [order_date] => Array
                                                (
                                                    [type] => string
                                                )

                                            [PD_count] => Array
                                                (
                                                    [type] => number
                                                )

                                            [BOOK_count] => Array
                                                (
                                                    [type] => number
                                                )

                                        )

                                )

                            [streamingSource:protected] => koolreport\datasources\PdoDataSource Object
                                (
                                    [sources:protected] => Array
                                        (
                                        )

                                    [destinations:protected] => Array
                                        (
                                            [0] => koolreport\processes\Sort Object
 *RECURSION*
                                        )

                                    [is_ended:protected] => 1
                                    [metaData:protected] => Array
                                        (
                                        )

                                    [streamingSource:protected] => 
                                    [params:protected] => Array
                                        (
                                            [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                            [username] => vsmartadmin
                                            [password] => Vsmart%2021#
                                            [charset] => utf8
                                        )

                                    [report:protected] => OnlineColumn_center Object
                                        (
                                            [params:protected] => Array
                                                (
                                                )

                                            [dataSources:protected] => Array
                                                (
                                                    [0] => koolreport\datasources\PdoDataSource Object
 *RECURSION*
                                                )

                                            [dataStores:protected] => Array
                                                (
                                                    [sales_by_order_website] => koolreport\core\DataStore Object
 *RECURSION*
                                                )

                                            [resourceManager:protected] => koolreport\core\ResourceManager Object
                                                (
                                                    [tags:protected] => Array
                                                        (
                                                            [899d8a1cc5f716091a7083f2426ab078] => Array
                                                                (
                                                                    [at] => begin
                                                                    [tag] => script
                                                                    [options] => Array
                                                                        (
                                                                            [type] => text/javascript
                                                                            [src] => /vendor_delete_folder/koolreport/core/src/clients/core/KoolReport.js
                                                                        )

                                                                    [content] => 
                                                                )

                                                            [5d28898e87fb51bbe88739940495e2e8] => Array
                                                                (
                                                                    [at] => begin
                                                                    [tag] => script
                                                                    [options] => Array
                                                                        (
                                                                            [type] => text/javascript
                                                                        )

                                                                    [content] => KoolReport.load.resources({"js":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/jquery\/jquery.min.js",["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/js\/bootstrap.min.js"]],"css":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap.min.css","\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap-theme.min.css"]});
                                                                )

                                                        )

                                                    [report:protected] => OnlineColumn_center Object
 *RECURSION*
                                                )

                                            [theme:protected] => 
                                            [templateEngine:protected] => 
                                            [events:protected] => Array
                                                (
                                                    [OnResourceInit] => Array
                                                        (
                                                            [0] => Closure Object
                                                                (
                                                                    [this] => OnlineColumn_center Object
 *RECURSION*
                                                                )

                                                            [1] => Closure Object
                                                                (
                                                                    [this] => OnlineColumn_center Object
 *RECURSION*
                                                                )

                                                        )

                                                )

                                            [reportSettings:protected] => Array
                                                (
                                                    [dataSources] => Array
                                                        (
                                                            [sales] => Array
                                                                (
                                                                    [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                                    [username] => vsmartadmin
                                                                    [password] => Vsmart%2021#
                                                                    [charset] => utf8
                                                                )

                                                        )

                                                )

                                        )

                                    [connection:protected] => PDO Object
                                        (
                                        )

                                    [query:protected] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                    [sqlParams:protected] => 
                                    [queryParams:protected] => 
                                    [countTotal:protected] => 
                                    [countFilter:protected] => 
                                    [errorInfo:protected] => 
                                    [originalQuery] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                )

                            [params:protected] => Array
                                (
                                    [fo_date] => desc
                                )

                        )

                    [params:protected] => Array
                        (
                            [0] => 10
                        )

                    [index:protected] => 1814
                    [limit:protected] => 10
                    [offset:protected] => 0
                )

        )

    [destinations:protected] => Array
        (
        )

    [is_ended:protected] => 1
    [metaData:protected] => Array
        (
            [columns] => Array
                (
                    [fo_date] => Array
                        (
                            [type] => string
                        )

                    [odate] => Array
                        (
                            [type] => number
                        )

                    [order_date] => Array
                        (
                            [type] => string
                        )

                    [PD_count] => Array
                        (
                            [type] => number
                        )

                    [BOOK_count] => Array
                        (
                            [type] => number
                        )

                )

        )

    [streamingSource:protected] => koolreport\processes\Limit Object
        (
            [sources:protected] => Array
                (
                    [0] => koolreport\processes\Sort Object
                        (
                            [sources:protected] => Array
                                (
                                    [0] => koolreport\datasources\PdoDataSource Object
                                        (
                                            [sources:protected] => Array
                                                (
                                                )

                                            [destinations:protected] => Array
                                                (
                                                    [0] => koolreport\processes\Sort Object
 *RECURSION*
                                                )

                                            [is_ended:protected] => 1
                                            [metaData:protected] => Array
                                                (
                                                )

                                            [streamingSource:protected] => 
                                            [params:protected] => Array
                                                (
                                                    [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                    [username] => vsmartadmin
                                                    [password] => Vsmart%2021#
                                                    [charset] => utf8
                                                )

                                            [report:protected] => OnlineColumn_center Object
                                                (
                                                    [params:protected] => Array
                                                        (
                                                        )

                                                    [dataSources:protected] => Array
                                                        (
                                                            [0] => koolreport\datasources\PdoDataSource Object
 *RECURSION*
                                                        )

                                                    [dataStores:protected] => Array
                                                        (
                                                            [sales_by_order_website] => koolreport\core\DataStore Object
 *RECURSION*
                                                        )

                                                    [resourceManager:protected] => koolreport\core\ResourceManager Object
                                                        (
                                                            [tags:protected] => Array
                                                                (
                                                                    [899d8a1cc5f716091a7083f2426ab078] => Array
                                                                        (
                                                                            [at] => begin
                                                                            [tag] => script
                                                                            [options] => Array
                                                                                (
                                                                                    [type] => text/javascript
                                                                                    [src] => /vendor_delete_folder/koolreport/core/src/clients/core/KoolReport.js
                                                                                )

                                                                            [content] => 
                                                                        )

                                                                    [5d28898e87fb51bbe88739940495e2e8] => Array
                                                                        (
                                                                            [at] => begin
                                                                            [tag] => script
                                                                            [options] => Array
                                                                                (
                                                                                    [type] => text/javascript
                                                                                )

                                                                            [content] => KoolReport.load.resources({"js":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/jquery\/jquery.min.js",["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/js\/bootstrap.min.js"]],"css":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap.min.css","\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap-theme.min.css"]});
                                                                        )

                                                                )

                                                            [report:protected] => OnlineColumn_center Object
 *RECURSION*
                                                        )

                                                    [theme:protected] => 
                                                    [templateEngine:protected] => 
                                                    [events:protected] => Array
                                                        (
                                                            [OnResourceInit] => Array
                                                                (
                                                                    [0] => Closure Object
                                                                        (
                                                                            [this] => OnlineColumn_center Object
 *RECURSION*
                                                                        )

                                                                    [1] => Closure Object
                                                                        (
                                                                            [this] => OnlineColumn_center Object
 *RECURSION*
                                                                        )

                                                                )

                                                        )

                                                    [reportSettings:protected] => Array
                                                        (
                                                            [dataSources] => Array
                                                                (
                                                                    [sales] => Array
                                                                        (
                                                                            [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                                            [username] => vsmartadmin
                                                                            [password] => Vsmart%2021#
                                                                            [charset] => utf8
                                                                        )

                                                                )

                                                        )

                                                )

                                            [connection:protected] => PDO Object
                                                (
                                                )

                                            [query:protected] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                            [sqlParams:protected] => 
                                            [queryParams:protected] => 
                                            [countTotal:protected] => 
                                            [countFilter:protected] => 
                                            [errorInfo:protected] => 
                                            [originalQuery] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                        )

                                )

                            [destinations:protected] => Array
                                (
                                    [0] => koolreport\processes\Limit Object
 *RECURSION*
                                )

                            [is_ended:protected] => 1
                            [metaData:protected] => Array
                                (
                                    [columns] => Array
                                        (
                                            [fo_date] => Array
                                                (
                                                    [type] => string
                                                )

                                            [odate] => Array
                                                (
                                                    [type] => number
                                                )

                                            [order_date] => Array
                                                (
                                                    [type] => string
                                                )

                                            [PD_count] => Array
                                                (
                                                    [type] => number
                                                )

                                            [BOOK_count] => Array
                                                (
                                                    [type] => number
                                                )

                                        )

                                )

                            [streamingSource:protected] => koolreport\datasources\PdoDataSource Object
                                (
                                    [sources:protected] => Array
                                        (
                                        )

                                    [destinations:protected] => Array
                                        (
                                            [0] => koolreport\processes\Sort Object
 *RECURSION*
                                        )

                                    [is_ended:protected] => 1
                                    [metaData:protected] => Array
                                        (
                                        )

                                    [streamingSource:protected] => 
                                    [params:protected] => Array
                                        (
                                            [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                            [username] => vsmartadmin
                                            [password] => Vsmart%2021#
                                            [charset] => utf8
                                        )

                                    [report:protected] => OnlineColumn_center Object
                                        (
                                            [params:protected] => Array
                                                (
                                                )

                                            [dataSources:protected] => Array
                                                (
                                                    [0] => koolreport\datasources\PdoDataSource Object
 *RECURSION*
                                                )

                                            [dataStores:protected] => Array
                                                (
                                                    [sales_by_order_website] => koolreport\core\DataStore Object
 *RECURSION*
                                                )

                                            [resourceManager:protected] => koolreport\core\ResourceManager Object
                                                (
                                                    [tags:protected] => Array
                                                        (
                                                            [899d8a1cc5f716091a7083f2426ab078] => Array
                                                                (
                                                                    [at] => begin
                                                                    [tag] => script
                                                                    [options] => Array
                                                                        (
                                                                            [type] => text/javascript
                                                                            [src] => /vendor_delete_folder/koolreport/core/src/clients/core/KoolReport.js
                                                                        )

                                                                    [content] => 
                                                                )

                                                            [5d28898e87fb51bbe88739940495e2e8] => Array
                                                                (
                                                                    [at] => begin
                                                                    [tag] => script
                                                                    [options] => Array
                                                                        (
                                                                            [type] => text/javascript
                                                                        )

                                                                    [content] => KoolReport.load.resources({"js":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/jquery\/jquery.min.js",["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/js\/bootstrap.min.js"]],"css":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap.min.css","\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap-theme.min.css"]});
                                                                )

                                                        )

                                                    [report:protected] => OnlineColumn_center Object
 *RECURSION*
                                                )

                                            [theme:protected] => 
                                            [templateEngine:protected] => 
                                            [events:protected] => Array
                                                (
                                                    [OnResourceInit] => Array
                                                        (
                                                            [0] => Closure Object
                                                                (
                                                                    [this] => OnlineColumn_center Object
 *RECURSION*
                                                                )

                                                            [1] => Closure Object
                                                                (
                                                                    [this] => OnlineColumn_center Object
 *RECURSION*
                                                                )

                                                        )

                                                )

                                            [reportSettings:protected] => Array
                                                (
                                                    [dataSources] => Array
                                                        (
                                                            [sales] => Array
                                                                (
                                                                    [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                                    [username] => vsmartadmin
                                                                    [password] => Vsmart%2021#
                                                                    [charset] => utf8
                                                                )

                                                        )

                                                )

                                        )

                                    [connection:protected] => PDO Object
                                        (
                                        )

                                    [query:protected] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                    [sqlParams:protected] => 
                                    [queryParams:protected] => 
                                    [countTotal:protected] => 
                                    [countFilter:protected] => 
                                    [errorInfo:protected] => 
                                    [originalQuery] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                )

                            [params:protected] => Array
                                (
                                    [fo_date] => desc
                                )

                        )

                )

            [destinations:protected] => Array
                (
                    [0] => koolreport\core\DataStore Object
 *RECURSION*
                )

            [is_ended:protected] => 1
            [metaData:protected] => Array
                (
                    [columns] => Array
                        (
                            [fo_date] => Array
                                (
                                    [type] => string
                                )

                            [odate] => Array
                                (
                                    [type] => number
                                )

                            [order_date] => Array
                                (
                                    [type] => string
                                )

                            [PD_count] => Array
                                (
                                    [type] => number
                                )

                            [BOOK_count] => Array
                                (
                                    [type] => number
                                )

                        )

                )

            [streamingSource:protected] => koolreport\processes\Sort Object
                (
                    [sources:protected] => Array
                        (
                            [0] => koolreport\datasources\PdoDataSource Object
                                (
                                    [sources:protected] => Array
                                        (
                                        )

                                    [destinations:protected] => Array
                                        (
                                            [0] => koolreport\processes\Sort Object
 *RECURSION*
                                        )

                                    [is_ended:protected] => 1
                                    [metaData:protected] => Array
                                        (
                                        )

                                    [streamingSource:protected] => 
                                    [params:protected] => Array
                                        (
                                            [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                            [username] => vsmartadmin
                                            [password] => Vsmart%2021#
                                            [charset] => utf8
                                        )

                                    [report:protected] => OnlineColumn_center Object
                                        (
                                            [params:protected] => Array
                                                (
                                                )

                                            [dataSources:protected] => Array
                                                (
                                                    [0] => koolreport\datasources\PdoDataSource Object
 *RECURSION*
                                                )

                                            [dataStores:protected] => Array
                                                (
                                                    [sales_by_order_website] => koolreport\core\DataStore Object
 *RECURSION*
                                                )

                                            [resourceManager:protected] => koolreport\core\ResourceManager Object
                                                (
                                                    [tags:protected] => Array
                                                        (
                                                            [899d8a1cc5f716091a7083f2426ab078] => Array
                                                                (
                                                                    [at] => begin
                                                                    [tag] => script
                                                                    [options] => Array
                                                                        (
                                                                            [type] => text/javascript
                                                                            [src] => /vendor_delete_folder/koolreport/core/src/clients/core/KoolReport.js
                                                                        )

                                                                    [content] => 
                                                                )

                                                            [5d28898e87fb51bbe88739940495e2e8] => Array
                                                                (
                                                                    [at] => begin
                                                                    [tag] => script
                                                                    [options] => Array
                                                                        (
                                                                            [type] => text/javascript
                                                                        )

                                                                    [content] => KoolReport.load.resources({"js":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/jquery\/jquery.min.js",["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/js\/bootstrap.min.js"]],"css":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap.min.css","\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap-theme.min.css"]});
                                                                )

                                                        )

                                                    [report:protected] => OnlineColumn_center Object
 *RECURSION*
                                                )

                                            [theme:protected] => 
                                            [templateEngine:protected] => 
                                            [events:protected] => Array
                                                (
                                                    [OnResourceInit] => Array
                                                        (
                                                            [0] => Closure Object
                                                                (
                                                                    [this] => OnlineColumn_center Object
 *RECURSION*
                                                                )

                                                            [1] => Closure Object
                                                                (
                                                                    [this] => OnlineColumn_center Object
 *RECURSION*
                                                                )

                                                        )

                                                )

                                            [reportSettings:protected] => Array
                                                (
                                                    [dataSources] => Array
                                                        (
                                                            [sales] => Array
                                                                (
                                                                    [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                                    [username] => vsmartadmin
                                                                    [password] => Vsmart%2021#
                                                                    [charset] => utf8
                                                                )

                                                        )

                                                )

                                        )

                                    [connection:protected] => PDO Object
                                        (
                                        )

                                    [query:protected] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                    [sqlParams:protected] => 
                                    [queryParams:protected] => 
                                    [countTotal:protected] => 
                                    [countFilter:protected] => 
                                    [errorInfo:protected] => 
                                    [originalQuery] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                                )

                        )

                    [destinations:protected] => Array
                        (
                            [0] => koolreport\processes\Limit Object
 *RECURSION*
                        )

                    [is_ended:protected] => 1
                    [metaData:protected] => Array
                        (
                            [columns] => Array
                                (
                                    [fo_date] => Array
                                        (
                                            [type] => string
                                        )

                                    [odate] => Array
                                        (
                                            [type] => number
                                        )

                                    [order_date] => Array
                                        (
                                            [type] => string
                                        )

                                    [PD_count] => Array
                                        (
                                            [type] => number
                                        )

                                    [BOOK_count] => Array
                                        (
                                            [type] => number
                                        )

                                )

                        )

                    [streamingSource:protected] => koolreport\datasources\PdoDataSource Object
                        (
                            [sources:protected] => Array
                                (
                                )

                            [destinations:protected] => Array
                                (
                                    [0] => koolreport\processes\Sort Object
 *RECURSION*
                                )

                            [is_ended:protected] => 1
                            [metaData:protected] => Array
                                (
                                )

                            [streamingSource:protected] => 
                            [params:protected] => Array
                                (
                                    [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                    [username] => vsmartadmin
                                    [password] => Vsmart%2021#
                                    [charset] => utf8
                                )

                            [report:protected] => OnlineColumn_center Object
                                (
                                    [params:protected] => Array
                                        (
                                        )

                                    [dataSources:protected] => Array
                                        (
                                            [0] => koolreport\datasources\PdoDataSource Object
 *RECURSION*
                                        )

                                    [dataStores:protected] => Array
                                        (
                                            [sales_by_order_website] => koolreport\core\DataStore Object
 *RECURSION*
                                        )

                                    [resourceManager:protected] => koolreport\core\ResourceManager Object
                                        (
                                            [tags:protected] => Array
                                                (
                                                    [899d8a1cc5f716091a7083f2426ab078] => Array
                                                        (
                                                            [at] => begin
                                                            [tag] => script
                                                            [options] => Array
                                                                (
                                                                    [type] => text/javascript
                                                                    [src] => /vendor_delete_folder/koolreport/core/src/clients/core/KoolReport.js
                                                                )

                                                            [content] => 
                                                        )

                                                    [5d28898e87fb51bbe88739940495e2e8] => Array
                                                        (
                                                            [at] => begin
                                                            [tag] => script
                                                            [options] => Array
                                                                (
                                                                    [type] => text/javascript
                                                                )

                                                            [content] => KoolReport.load.resources({"js":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/jquery\/jquery.min.js",["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/js\/bootstrap.min.js"]],"css":["\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap.min.css","\/vendor_delete_folder\/koolreport\/core\/src\/clients\/bootstrap\/css\/bootstrap-theme.min.css"]});
                                                        )

                                                )

                                            [report:protected] => OnlineColumn_center Object
 *RECURSION*
                                        )

                                    [theme:protected] => 
                                    [templateEngine:protected] => 
                                    [events:protected] => Array
                                        (
                                            [OnResourceInit] => Array
                                                (
                                                    [0] => Closure Object
                                                        (
                                                            [this] => OnlineColumn_center Object
 *RECURSION*
                                                        )

                                                    [1] => Closure Object
                                                        (
                                                            [this] => OnlineColumn_center Object
 *RECURSION*
                                                        )

                                                )

                                        )

                                    [reportSettings:protected] => Array
                                        (
                                            [dataSources] => Array
                                                (
                                                    [sales] => Array
                                                        (
                                                            [connectionString] => mysql:host=vsmart-sandbox.cdwbw3fz9lvd.ap-south-1.rds.amazonaws.com;dbname=new_onlinewebsite_db
                                                            [username] => vsmartadmin
                                                            [password] => Vsmart%2021#
                                                            [charset] => utf8
                                                        )

                                                )

                                        )

                                )

                            [connection:protected] => PDO Object
                                (
                                )

                            [query:protected] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                            [sqlParams:protected] => 
                            [queryParams:protected] => 
                            [countTotal:protected] => 
                            [countFilter:protected] => 
                            [errorInfo:protected] => 
                            [originalQuery] => SELECT f.fo_date, DAY(o.order_date) as odate,o.order_date,
        sum(case when o.producttype = 'PD SELL' then 1 else 0 end) AS PD_count,
        sum(case when o.producttype = 'BOOK SELL' then 1 else 0 end) AS BOOK_count
        FROM final_order f, online_order_new o Where f.sess_id = o.sess_id and f.transaction_satus = 'Success' group by f.fo_date 
                        )

                    [params:protected] => Array
                        (
                            [fo_date] => desc
                        )

                )

            [params:protected] => Array
                (
                    [0] => 10
                )

            [index:protected] => 1814
            [limit:protected] => 10
            [offset:protected] => 0
        )

    [rows:protected] => Array
        (
            [0] => Array
                (
                    [fo_date] => 2026-01-09
                    [odate] => 
                    [order_date] => 07-January-2026 06:41:49 PM
                    [PD_count] => 3
                    [BOOK_count] => 0
                )

            [1] => Array
                (
                    [fo_date] => 2026-01-08
                    [odate] => 
                    [order_date] => 07-January-2026 04:13:59 PM
                    [PD_count] => 5
                    [BOOK_count] => 1
                )

            [2] => Array
                (
                    [fo_date] => 2026-01-05
                    [odate] => 
                    [order_date] => 02-January-2026 11:46:28 AM
                    [PD_count] => 3
                    [BOOK_count] => 0
                )

            [3] => Array
                (
                    [fo_date] => 2026-01-03
                    [odate] => 
                    [order_date] => 01-January-2026 12:31:24 PM
                    [PD_count] => 1
                    [BOOK_count] => 0
                )

            [4] => Array
                (
                    [fo_date] => 2026-01-02
                    [odate] => 
                    [order_date] => 02-January-2026 12:55:20 PM
                    [PD_count] => 1
                    [BOOK_count] => 0
                )

            [5] => Array
                (
                    [fo_date] => 2026-01-01
                    [odate] => 
                    [order_date] => 31-December-2025 05:49:32 PM
                    [PD_count] => 4
                    [BOOK_count] => 0
                )

            [6] => Array
                (
                    [fo_date] => 2025-12-31
                    [odate] => 
                    [order_date] => 31-December-2025 11:37:59 AM
                    [PD_count] => 3
                    [BOOK_count] => 0
                )

            [7] => Array
                (
                    [fo_date] => 2025-12-27
                    [odate] => 
                    [order_date] => 27-December-2025 07:29:16 PM
                    [PD_count] => 0
                    [BOOK_count] => 1
                )

            [8] => Array
                (
                    [fo_date] => 2025-12-25
                    [odate] => 
                    [order_date] => 25-December-2025 04:05:30 PM
                    [PD_count] => 2
                    [BOOK_count] => 0
                )

            [9] => Array
                (
                    [fo_date] => 2025-12-22
                    [odate] => 
                    [order_date] => 21-December-2025 03:25:44 PM
                    [PD_count] => 2
                    [BOOK_count] => 0
                )

        )

    [index:protected] => -1
)