-
Notifications
You must be signed in to change notification settings - Fork 170
/
LineItemExport.php
94 lines (88 loc) · 3.42 KB
/
LineItemExport.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
<?php
/**
* @link https://craftcms.com/
* @copyright Copyright (c) Pixel & Tonic, Inc.
* @license https://craftcms.github.io/license/
*/
namespace craft\commerce\exports;
use Craft;
use craft\base\ElementExporter;
use craft\commerce\adjusters\Discount;
use craft\commerce\adjusters\Shipping;
use craft\commerce\adjusters\Tax;
use craft\commerce\db\Table;
use craft\db\Query as CraftQuery;
use craft\elements\db\ElementQueryInterface;
class LineItemExport extends ElementExporter
{
/**
* @inheritDoc
*/
public static function displayName(): string
{
return Craft::t('commerce', 'Line Items');
}
/**
* @inheritDoc
*/
public function export(ElementQueryInterface $query): mixed
{
$orderIds = $query->ids();
$columns = [
'lineitems.id',
'lineitems.orderId',
'lineitems.purchasableId',
'lineitems.description',
'lineitems.sku',
'lineitems.taxCategoryId',
'lineitems.lineItemStatusId',
'lineitems.shippingCategoryId',
'lineitems.options',
'lineitems.optionsSignature',
'lineitems.price',
'lineitems.promotionalAmount',
'lineitems.salePrice',
'lineitems.qty',
'lineitems.subtotal',
'totalTax' => (new CraftQuery())
->select('SUM([[amount]])')
->from(Table::ORDERADJUSTMENTS . ' adjustments')
->where(['and', '[[adjustments.orderId]] = [[lineitems.orderId]]', '[[adjustments.lineItemId]] = [[lineitems.id]]'])
->andWhere(['type' => Tax::ADJUSTMENT_TYPE])
->andWhere(['included' => 0]),
'totalTaxIncluded' => (new CraftQuery())
->select('SUM([[amount]])')
->from(Table::ORDERADJUSTMENTS . ' adjustments')
->where(['and', '[[adjustments.orderId]] = [[lineitems.orderId]]', '[[lineItemId]] = [[lineitems.id]]'])
->andWhere(['type' => Tax::ADJUSTMENT_TYPE])
->andWhere(['included' => 1]),
'totalShipping' => (new CraftQuery())
->select('SUM([[amount]])')
->from(Table::ORDERADJUSTMENTS . ' adjustments')
->where(['and', '[[adjustments.orderId]] = [[lineitems.orderId]]', '[[lineItemId]] = [[lineitems.id]]'])
->andWhere(['type' => Shipping::ADJUSTMENT_TYPE]),
'totalDiscount' => (new CraftQuery())
->select('SUM([[amount]])')
->from(Table::ORDERADJUSTMENTS . ' adjustments')
->where(['and', '[[adjustments.orderId]] = [[lineitems.orderId]]', '[[adjustments.lineItemId]] = [[lineitems.id]]'])
->andWhere(['type' => Discount::ADJUSTMENT_TYPE]),
'lineitems.total',
'lineitems.weight',
'lineitems.height',
'lineitems.length',
'lineitems.width',
'lineitems.note',
'lineitems.privateNote',
'lineitems.snapshot',
'lineitems.dateCreated',
'lineitems.dateUpdated',
'lineitems.uid',
];
return (new CraftQuery())
->select($columns)
->from(Table::LINEITEMS . ' lineitems')
->leftJoin(Table::ORDERS . ' orders', '[[lineitems.orderId]] = [[orders.id]]')
->where(['[[lineitems.orderId]]' => $orderIds])
->all();
}
}