| 1 |
<?php |
| 2 |
|
| 3 |
namespace FluentCart\App\Modules\ReportingModule; |
| 4 |
|
| 5 |
use FluentCart\App\App; |
| 6 |
use FluentCart\App\Helpers\Helper; |
| 7 |
use FluentCart\App\Helpers\Status; |
| 8 |
|
| 9 |
class ProductReport |
| 10 |
{ |
| 11 |
public static function getStatByProductIds($productIds = [], $ranges = ['-30 days', 'all_time']) |
| 12 |
{ |
| 13 |
if (!$productIds) { |
| 14 |
return []; |
| 15 |
} |
| 16 |
|
| 17 |
$db = App::getInstance('db'); |
| 18 |
|
| 19 |
$stats = []; |
| 20 |
|
| 21 |
foreach ($ranges as $range) { |
| 22 |
$statsQuery = $db->table('fct_order_items') |
| 23 |
->select([ |
| 24 |
$db->raw('SUM(line_total) as total_amount'), |
| 25 |
$db->raw('SUM(quantity) as total_quantity') |
| 26 |
]) |
| 27 |
->join('fct_orders', 'fct_orders.id', '=', 'fct_order_items.order_id') |
| 28 |
->whereIn('fct_order_items.object_id', $productIds) |
| 29 |
->whereIn('fct_orders.status', Status::getTransactionSuccessStatuses()); |
| 30 |
|
| 31 |
if ($range != 'all_time') { |
| 32 |
$statsQuery = $statsQuery->where('fct_orders.created_at', '>', gmdate('Y-m-d 00:00:00', strtotime($range))); |
| 33 |
} |
| 34 |
|
| 35 |
$stats[$range] = $statsQuery->first(); |
| 36 |
} |
| 37 |
|
| 38 |
return $stats; |
| 39 |
} |
| 40 |
} |
| 41 |
|
