3f2bc3d0
Administrator
first commit
|
1
|
<?php
|
3f2bc3d0
Administrator
first commit
|
2
3
4
|
namespace common\models;
use Yii;
|
90a6ed1a
Administrator
basket
|
5
6
7
|
use yii\web\Session;
use common\modules\product\models\ProductVariant;
|
3f2bc3d0
Administrator
first commit
|
8
9
10
|
class Orders extends \yii\db\ActiveRecord
{
|
3f2bc3d0
Administrator
first commit
|
11
12
13
14
15
|
public static function tableName()
{
return 'orders';
}
|
3f2bc3d0
Administrator
first commit
|
16
17
18
|
public function rules()
{
return [
|
90a6ed1a
Administrator
basket
|
19
20
21
22
|
[['name', 'phone'], 'required','whenClient' => true],
//['email', 'email'],
[['total','body','patronymic','surname','email','phone2','delivery','payment'], 'safe'],
[['email'],'email'],
|
3f2bc3d0
Administrator
first commit
|
23
24
25
|
];
}
|
90a6ed1a
Administrator
basket
|
26
|
public function attributeLabels()
|
3f2bc3d0
Administrator
first commit
|
27
28
|
{
return [
|
90a6ed1a
Administrator
basket
|
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
'name' => 'Имя',
'phone'=>'Телефон',
'phone2'=>'Дополнительный телефон',
'body'=>'Сообщение',
'adress'=>'Адрес',
'city'=>'Город',
'patronymic'=>'Отчество',
'surname'=>'Фамилия',
'email'=>'E-mail',
'date_time'=>'Дата',
'total'=>'Сума',
'status'=>'Статус',
'delivery'=>'Вариант доставки',
'payment'=>'Способы оплаты',
|
3f2bc3d0
Administrator
first commit
|
43
44
45
|
];
}
|
90a6ed1a
Administrator
basket
|
46
47
48
49
50
|
public function beforeSave($insert) {
$this->user_id = Yii::$app->user->id;
$this->date_time = new \yii\db\Expression('NOW()');
return parent::beforeSave($insert);
}
|
3f2bc3d0
Administrator
first commit
|
51
|
|
90a6ed1a
Administrator
basket
|
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
|
public function beforeDelete() {
return parent::beforeDelete();
}
public function contact($email,$body)
{
if ($this->validate()) {
$body .= 'Вся сумма: '.$this->total;
$body .= "\n\r";
$body .= 'Имя: '.$this->name;
$body .= "\n\r";
$body .= 'Фамилия: '.$this->surname;
$body .= "\n\r";
$body .= 'Отчество: '.$this->patronymic;
$body .= "\n\r";
$body .= 'E-mail: '.$this->email;
$body .= "\n\r";
$body .= 'Телефон: '.$this->phone;
$body .= "\n\r";
$body .= 'Адрес: '.$this->adress;
$body .= "\n\r";
$body .= 'Сообщение: '.$this->body;
$body .= "\n\r";
Yii::$app->mailer->compose()
->setTo($email)
->setFrom(['send@artweb.ua' => 'send'])
->setSubject('Заказ на сайте Рюкзаки')
->setTextBody($body)
->send();
return true;
|
3f2bc3d0
Administrator
first commit
|
83
|
} else {
|
90a6ed1a
Administrator
basket
|
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
return false;
}
}
public function addBasket ($mod_id, $count)
{
$session = new Session;
$session->open ();
$data = $session['basket'];
$i = 0;
if (isset($session['basket']))
{
foreach ($session['basket'] as $key => $basket)
{
if ($mod_id == $basket['id'])
{
$data[$key]['count'] += $count;
$session['basket'] = $data;
$i++;
}
}
}
if ($i == 0)
{
$data[] = ['id' => $mod_id, 'count' => $count];
$session['basket'] = $data;
|
3f2bc3d0
Administrator
first commit
|
109
110
111
112
|
}
}
|
90a6ed1a
Administrator
basket
|
113
114
115
116
117
118
119
120
121
122
123
124
|
public function rowBasket ()
{
$session = new Session;
$session->open ();
$cost = 0;
$count = 0;
if (isset($session['basket']) && count ($session['basket']))
{
foreach ($session['basket'] as $product)
{
$count += $product['count'];
}
|
3f2bc3d0
Administrator
first commit
|
125
|
}
|
90a6ed1a
Administrator
basket
|
126
127
|
return (object)['cost' => $cost, 'count' => $count];
|
3f2bc3d0
Administrator
first commit
|
128
129
|
}
|
90a6ed1a
Administrator
basket
|
130
131
|
public function deleteBasketMod ($id)
|
3f2bc3d0
Administrator
first commit
|
132
|
{
|
90a6ed1a
Administrator
basket
|
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
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
187
188
189
190
191
192
|
$session = new Session;
$session->open ();
$basket = $session['basket'];
foreach ($basket as $key => $product)
{
if ($id == $product['id']) unset($basket[$key]);
}
$session['basket'] = $basket;
}
public function updateBasket ($row)
{
$session = new Session;
$session->open ();
//$data = array();
if ($row['count'] > 0) $this->data[] = ['id' => $row['id'], 'count' => $row['count']];
$session['basket'] = $this->data;
}
public function getBasketMods ()
{
$session = new Session;
$session->open ();
$products = [];
if (empty($session['basket'])) return [];
foreach ($session['basket'] as $product)
{
$row = ProductVariant::find ()->select (['product_variant.*', 'product.name as product_name', 'product.alias'])
->where (['product_variant.product_variant_id' => $product['id']])
->leftJoin ('product', 'product.product_id = product_variant.product_id')
->one ();
$row->count = $product['count'];
$row->sum_cost = $product['count'] * $row->price;
$products[] = $row;
}
return $products;
}
public function getSumCost ()
{
$session = new Session;
$session->open ();
$cost = 0;
if (empty($session['basket'])) return false;
foreach ($session['basket'] as $product)
{
$cost += ($this->getModCost ($product['id']) * $product['count']);
}
return $cost;
}
private function getModCost ($mod_id)
{
$mod = ProductVariant::find ()->where (['product_variant_id' => $mod_id])->one ();
return $mod->price;
}
|
8df8067a
Administrator
basket
|
193
194
195
196
197
198
|
public function clearBasket ()
{
$session = new Session;
$session->open ();
$session['basket'] = null;
}
|
90a6ed1a
Administrator
basket
|
199
200
201
|
public function getUser()
{
return $this->hasOne(User::className(), ['id' => 'user_id']);
|
3f2bc3d0
Administrator
first commit
|
202
203
|
}
|
90a6ed1a
Administrator
basket
|
204
|
public function getProducts()
|
3f2bc3d0
Administrator
first commit
|
205
|
{
|
90a6ed1a
Administrator
basket
|
206
|
return $this->hasMany(OrdersProducts::className(), ['order_id' => 'id']);
|
3f2bc3d0
Administrator
first commit
|
207
|
}
|
90a6ed1a
Administrator
basket
|
208
|
}
|