Label.php
4.15 KB
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
95
96
97
98
99
100
101
102
103
104
105
106
107
<?php
namespace artweb\artbox\ecommerce\models;
use artweb\artbox\language\behaviors\LanguageBehavior;
use yii\db\ActiveQuery;
use yii\db\ActiveRecord;
use yii\db\Query;
use yii\helpers\VarDumper;
use yii\web\Request;
/**
* Class Label
*
* @property int $id
* @property string $label
* * From language behavior *
* @property orderLabelLang $lang
* @property orderLabelLang[] $langs
* @property orderLabelLang $objectLang
* @property string $ownerKey
* @property string $langKey
* @property orderLabelLang[] $modelLangs
* @property bool $transactionStatus
* @method string getOwnerKey()
* @method void setOwnerKey( string $value )
* @method string getLangKey()
* @method void setLangKey( string $value )
* @method ActiveQuery getLangs()
* @method ActiveQuery getLang( integer $language_id )
* @method OrderLabelLang[] generateLangs()
* @method void loadLangs( Request $request )
* @method bool linkLangs()
* @method bool saveLangs()
* @method bool getTransactionStatus()
* * End language behavior
*/
class Label extends ActiveRecord
{
public function rules()
{
return [
[
[ 'label' ],
'string',
],
];
}
public static function tableName()
{
return 'order_label';
}
public function behaviors()
{
return [
'language' => [
'class' => LanguageBehavior::className(),
'objectLang' => OrderLabelLang::className(),
'ownerKey' => 'id',
'langKey' => 'order_label_id',
],
];
}
public function getStatistics(array $date = [], array $manager = [])
{
$query = ( new Query() )->select(
[
'sum' => 'SUM(total)',
'count' => 'COUNT(*)',
'unique' => ( new Query() )->select('COUNT(*)')
->from('order')
->leftJoin(
'order_product',
'"order"."id"="order_product"."order_id"'
)
->where([ 'order.label' => $this->id ])
->andFilterWhere(
$date
)
->andFilterWhere($manager),
'products' => ( new Query() )->select('SUM(count)')
->from('order')
->leftJoin(
'order_product',
'"order"."id"="order_product"."order_id"'
)
->where([ 'order.label' => $this->id ])
->andFilterWhere(
$date
)
->andFilterWhere($manager),
]
)
->from('order')
->where([ 'label' => $this->id ])
->andFilterWhere(
$date
)
->andFilterWhere($manager);
return $query->one();
}
}