AjaxStoFilterController.php
3.08 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
<?php
class AjaxStoFilterController extends Controller
{
public function actionSend(){
$text = Yii::app()->request->getParam('text');
$name = Yii::app()->request->getParam('name');
$phone = Yii::app()->request->getParam('phone');
$email = Yii::app()->request->getParam('email');
Yii::import('application.extensions.phpmailer.JPhpMailer');
$mail = new JPhpMailer;
$mail->IsSMTP();
$mail->Host = 'smtp.gmail.com';
$mail->SMTPAuth = true;
$mail->Username = 'dockdep@gmail.com';
$mail->Password = 'k0l0b04eg';
$mail->SetFrom('dockdep@gmail.com', 'Авто Лайв');
$mail->Subject = 'Расчет стоимости ТО';
$mail->AltBody = $text.'<br>Имя:'.$name.'<br>Телефон:'. $phone.'<br>Email:'. $email;
$mail->MsgHTML('<h1>JUST A TEST!</h1>');
$mail->AddAddress('john.doe@otherdomain.com', 'John Doe');
$mail->Send();
}
public function actionFilter(){
$post = Yii::app()->request->getParam('StoFilter');
if(!empty($post)){
$form = new StoFilter();
$form->attributes = Yii::app()->request->getParam('StoFilter');
$filter['model'] = $form->searchFilter('model');
$filter['engine'] = $form->searchFilter('engine');
$filter['drive_unit'] = $form->searchFilter('drive_unit');
$filter['transmission'] = $form->searchFilter('transmission');
$filter['fuel_type'] = $form->searchFilter('fuel_type');
if(!empty( $post['model']) && !empty( $post['engine']) && !empty( $post['drive_unit']) && !empty( $post['transmission'])&& !empty( $post['fuel_type'])){
foreach($form->searchFilter('id') as $key => $val){
$dist = new StoRequire();
$filter['mileage'] = $dist->searchFilter($key);;
$filter['id'] = $key;
}
}
$json = json_encode($filter);
die($json);
}
}
public function actionRenderPriceList(){
$id = Yii::app()->request->getParam('id');
$dist = Yii::app()->request->getParam('dist');
if(!empty($id) && !empty($dist)){
$names = new StoRequireName();
$items = new StoRequire();
$optionalModel = new StoOptionalItems();
$fields = Yii::app()->db->createCommand()
->select('*')
->from("{$names->tableName()} sn")
->rightJoin("{$items->tableName()} s", 'sn.id=s.sto_require_name_id')
->where('sn.sto_filter_id=:id AND s.dist=:dist', array(':id'=>$id,':dist' => $dist))->queryAll();
$optional = Yii::app()->db->createCommand()
->select('*')
->from("{$optionalModel->tableName()} sn")
->where('sto_filter_id=:id', array(':id'=>$id))->queryAll();
$this->renderPartial('/stoFilter/_priceList', array(
'fields' => $fields,
'optional' => $optional
));
}
}
}