8072159c
Alex Savenko
create proj
|
1
|
<?php
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
2
3
4
|
namespace frontend\models;
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
5
6
|
use common\modules\product\helpers\ProductHelper;
use common\modules\product\models\Category;
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
7
|
use yii\base\Model;
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
8
9
10
11
12
13
|
use yii\data\ArrayDataProvider;
use yii\db\ActiveQuery;
use common\modules\product\models\Product;
use common\modules\product\models\ProductVariant;
use yii\db\Query;
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
14
15
|
class ProductFrontendSearch extends Product
|
8072159c
Alex Savenko
create proj
|
16
|
{
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
public $price_interval;
public $brands;
/**
* @inheritdoc
*/
public function rules()
{
return [
[
[
'price_interval',
'brands',
|
8072159c
Alex Savenko
create proj
|
31
|
],
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
32
|
'safe',
|
8072159c
Alex Savenko
create proj
|
33
|
],
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
34
|
];
|
8072159c
Alex Savenko
create proj
|
35
|
}
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
/**
* @inheritdoc
*/
public function scenarios()
{
// bypass scenarios() implementation in the parent class
return Model::scenarios();
}
/**
* Creates data provider instance with search query applied for frontend
*
* @param array $params
*
|
5d972c58
Alexey Boroda
-Changed excluded...
|
51
|
* @return ArrayDataProvider
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
52
|
*/
|
04eb9f67
Alexey Boroda
-Search with sale...
|
53
|
public function search($category = null, $params = [], $in_stock = true, $without_sale = true)
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
54
55
56
57
|
{
$dataProvider = new ArrayDataProvider(
[
|
04eb9f67
Alexey Boroda
-Search with sale...
|
58
|
'allModels' => $this->getSearchQuery($category, $params, $in_stock, $without_sale)
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
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
|
->with(
[
'images',
'events',
'variant',
'variant.image',
'comments',
'averageRating',
]
)
->all(),
'pagination' => [
'pageSize' => 15,
],
'sort' => [
'attributes' => [
'name' => [
'asc' => [ 'name' => SORT_ASC ],
'desc' => [ 'name' => SORT_DESC ],
'default' => SORT_DESC,
'label' => 'имени',
],
'price' => [
'asc' => [ 'price' => SORT_ASC ],
'desc' => [ 'price' => SORT_DESC ],
'default' => SORT_DESC,
'label' => 'по цене',
],
],
],
]
);
return $dataProvider;
}
|
04eb9f67
Alexey Boroda
-Search with sale...
|
95
|
public function getSearchQuery($category = null, $params = [], $in_stock = true, $without_sale = true)
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
|
{
if (!empty($category)) {
/** @var ActiveQuery $query */
/**@var Category $category * */
$query = $category->getProducts();
} else {
$query = Product::find();
}
$query->select([ 'product.*' ]);
$query->joinWith(
[
'enabledVariants',
'brand',
'options',
'category',
]
);
// $query->groupBy(['product.product_id', 'product_variant.price', 'product_variant.stock']);
|
599302f3
Alexey Boroda
-Made sort by brand
|
118
119
120
121
|
$query->orderBy([
'brand.sort' => SORT_ASC,
'product_variant.stock' => SORT_DESC,
]);
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
122
123
124
125
126
127
128
129
130
131
132
133
134
135
|
ProductHelper::_setQueryParams($query, $params);
if ($in_stock) {
$query->andWhere(
[
'!=',
ProductVariant::tableName() . '.status',
1,
]
);
}
/**
* Removing products that currently in events
*/
|
04eb9f67
Alexey Boroda
-Search with sale...
|
136
137
|
if ($without_sale) {
$query->andWhere(
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
138
|
[
|
04eb9f67
Alexey Boroda
-Search with sale...
|
139
140
141
142
143
144
145
146
147
148
149
150
|
'not',
[
'product.product_id' => ( new Query() )->select('events_to_products.product_id')
->from('events_to_products')
->innerJoin(
'event',
'event.event_id=events_to_products.event_id'
)->where(['event.sale' => true]),
],
]
);
}
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
151
152
|
return $query;
|
8072159c
Alex Savenko
create proj
|
153
|
}
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
|
/**
* @param Category|null $category
*
* @return array
*/
public function priceLimits($category = null, $params = [])
{
if (!empty($category)) {
/** @var ActiveQuery $query */
// $query = $category->getRelations('product_categories');
$query = $category->getProducts();
} else {
$query = Product::find();
}
$query->joinWith('variant');
// Price filter fix
unset($params[ 'prices' ]);
ProductHelper::_setQueryParams($query, $params);
$query->andWhere(
[
'>=',
ProductVariant::tableName() . '.stock',
1,
]
);
return [
'min' => $query->min(ProductVariant::tableName() . '.price'),
'max' => $query->max(ProductVariant::tableName() . '.price'),
];
|
8072159c
Alex Savenko
create proj
|
187
|
}
|
886cf4d7
Alexey Boroda
-Sitemap started ...
|
188
|
}
|