Source of file TaxReport.php
Size: 1,459 Bytes - Last Modified: 2021-12-23T10:24:58+00:00
/var/www/docs.ssmods.com/process/src/src/Reports/TaxReport.php
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 | <?php namespace SilverShop\Reports; use SilverShop\Model\Order; /** * Tax report * * @date 09.24.2014 * @package shop * @subpackage reports */ class TaxReport extends ShopPeriodReport { protected $title = 'Tax'; protected $description = 'Report tax charged on orders. Only includes orders that have been paid.'; protected $dataClass = Order::class; protected $periodfield = '"SilverShop_Order"."Paid"'; protected $grouping = true; public function columns() { $period = isset($_GET['filters']['Grouping']) ? $_GET['filters']['Grouping'] : 'Month'; return array( 'FilterPeriod' => $period, 'Count' => 'Order Count', 'Sales' => 'Total Sales', 'Tax' => 'Total Tax', ); } public function query($params) { return parent::query($params) ->addInnerJoin( 'SilverShop_OrderAttribute', '"SilverShop_OrderAttribute"."OrderID" = "SilverShop_Order"."ID" AND "SilverShop_OrderAttribute"."ClassName" LIKE \'%TaxModifier\'' ) ->addInnerJoin('SilverShop_OrderModifier', '"SilverShop_OrderModifier"."ID" = "SilverShop_OrderAttribute"."ID"') ->selectField('COUNT("SilverShop_Order"."ID")', 'Count') ->selectField('SUM("SilverShop_OrderModifier"."Amount")', 'Tax') ->selectField('SUM("SilverShop_Order"."Total")', 'Sales'); } } |