3f2bc3d0
 Administrator
first commit
|
1
2
3
4
5
6
7
|
<?php
namespace common\modules\product\helpers;
use common\modules\product\models\Brand;
use common\modules\product\models\Category;
use common\modules\product\models\Product;
|
d48d8bc0
 Karnovsky A
-
|
8
|
use common\modules\product\models\ProductVariant;
|
|
3f2bc3d0
Administrator
first commit
|
9
10
11
12
|
use yii\base\Object;
use Yii;
class ProductHelper extends Object {
|
|
c7852657
Karnovsky A
-
|
13
14
15
16
17
18
19
|
const PRODUCT_TAX_GROUP_ID_TARGET = 20;
const PRODUCT_TAX_GROUP_ID_YEAR = 21;
const PRODUCT_TAX_GROUP_ID_SEX = 22;
const PRODUCT_VARIANT_TYPE_COLOR = 1;
const PRODUCT_VARIANT_TYPE_SIZE = 2;
|
|
3f2bc3d0
Administrator
first commit
|
20
|
public static function getCategories() {
|
|
c7852657
Karnovsky A
-
|
21
|
return Category::find()->getTree(); // with('categoryName')->
|
|
3f2bc3d0
Administrator
first commit
|
22
23
24
|
}
public static function getBrands() {
|
|
c7852657
Karnovsky A
-
|
25
|
return Brand::find(); // ->with('brandName')
|
|
3f2bc3d0
Administrator
first commit
|
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
|
}
/*
* Return custom filter-option link
* @var array $filter
* @var array $options
* @return array
*/
public static function getFilterForOption($filter, $key, $value, $remove = false) {
$result = $filter;
if (is_array($value)) {
foreach($value as $value_key => $value_items) {
if (!is_array($value_items)) {
$value_items = [$value_items];
}
foreach($value_items as $value_item) {
if ($remove && isset($result[$key]) && ($i = array_search($value_item, $result[$key][$value_key])) !== FALSE) {
unset($result[$key][$value_key][$i]);
if (empty($result[$key][$value_key])) {
unset($result[$key][$value_key]);
}
} else {
if (!isset($result[$key][$value_key]) || array_search($value_item, $result[$key][$value_key]) === FALSE) {
$result[$key][$value_key][] = $value_item;
}
}
}
}
} else {
if ($remove && isset($result[$key]) && ($i = array_search($value, $result[$key])) !== FALSE) {
unset($result[$key][$i]);
if (empty($result[$key])) {
unset($result[$key]);
}
} else {
if (!isset($result[$key]) || array_search($value, $result[$key]) === FALSE) {
$result[$key][] = $value;
}
}
}
return $result;
}
public static function addLastProsucts($product_id) {
$last_products = self::getLastProducts();
if (!in_array($product_id, $last_products)) {
|
|
2848e106
Karnovsky A
Fix last-products...
|
72
73
74
75
|
$last_products[] = intval($product_id);
if (count($last_products) > 16) {
array_shift($last_products);
}
|
|
3f2bc3d0
Administrator
first commit
|
76
77
78
79
80
81
82
|
Yii::$app->session->set('last_products', $last_products);
}
}
public static function getLastProducts($as_object = false) {
$last_products = Yii::$app->session->get('last_products', []);
if ($as_object) {
|
|
b238d463
Karnovsky A
-
|
83
|
$last_products = Product::find()->joinWith(['variant'])->where([Product::tableName() .'.product_id' => $last_products])->andWhere(['!=', ProductVariant::tableName() .'.stock', 0])->all();
|
|
3f2bc3d0
Administrator
first commit
|
84
|
}
|
|
2848e106
Karnovsky A
Fix last-products...
|
85
|
return array_reverse($last_products);
|
|
3f2bc3d0
Administrator
first commit
|
86
|
}
|
|
dc2cd017
Karnovsky A
-
|
87
88
89
90
91
92
93
94
95
96
97
98
99
|
public static function getSpecialProducts($type, $count, $sort = null) {
switch($type) {
case 'top':
$data = ['is_top' => true];
break;
case 'new':
$data = ['is_new' => true];
break;
case 'promo':
$data = ['akciya' => true];
break;
}
|
|
d48d8bc0
Karnovsky A
-
|
100
|
return Product::find()->joinWith('variants')->where($data)->andWhere(['!=', ProductVariant::tableName() .'.stock', 0])->limit($count)/*->orderBy($sort)*/->all();
|
|
dc2cd017
Karnovsky A
-
|
101
|
}
|
|
e9f291a5
Karnovsky A
Similar products ...
|
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
|
public static function getSimilarProducts($product, $count = 10) {
if (!is_object($product)) {
$product = Product::findOne($product);
}
if (!$product->properties) {
return [];
}
$query = Product::find()
->select('product.product_id')
->innerJoinWith('variant')
->where(['!=', 'product_variant.stock', 0]);
// $query->andWhere(['>=', 'product_variant.price', $product->enabledVariant->price * 0.7]);
// $query->andWhere(['<=', 'product_variant.price', $product->enabledVariant->price * 1.3]);
foreach($product->properties as $group) {
$where = [];
foreach ($group->_options as $option) {
$where[] = $option->tax_option_id;
}
if (!$where) {
continue;
}
$query->innerJoin('product_option to'. $group->tax_group_id, 'to'. $group->tax_group_id .'.product_id = product.product_id');
$query->andWhere(['to'. $group->tax_group_id .'.option_id' => $where]);
}
$query->andWhere(['!=', 'product.product_id', $product->product_id]);
$query->groupBy('product.product_id');
$query->limit($count);
$products = $query->asArray()->all();
foreach ($products as &$_product) {
$_product = Product::findOne($_product['product_id']);
}
return $products;
}
|
|
3f2bc3d0
Administrator
first commit
|
137
|
}
|
