Source of file AbandonedCartReport.php
Size: 1,113 Bytes - Last Modified: 2021-12-24T06:35:03+00:00
/var/www/docs.ssmods.com/process/src/src/Reports/AbandonedCartReport.php
1234567891011121314151617181920212223242526272829303132333435363738394041424344 | <?php namespace SilverShop\Reports; use SilverShop\Model\Order; /** * Report on the number of abandoned carts. * * @date 09.24.2014 * @package shop * @subpackage reports */ class AbandonedCartReport extends ShopPeriodReport { protected $title = 'Abandoned Carts'; protected $description = 'Monitor abandoned carts for a particular period. Group results by year, month, or day.'; protected $dataClass = Order::class; protected $periodfield = '"SilverShop_Order"."Created"'; protected $grouping = true; public function columns() { $period = isset($_GET['filters']['Grouping']) ? $_GET['filters']['Grouping'] : 'Month'; return array( 'FilterPeriod' => $period, 'Count' => 'Count', 'TotalValue' => 'Total Value', ); } public function query($params) { return parent::query($params) ->selectField('COUNT("SilverShop_Order"."ID")', 'Count') ->selectField('SUM("SilverShop_Order"."Total")', 'TotalValue') ->addWhere(['"Status" = ?' => 'Cart']); } } |