AjaxStoFilterController.php
2.72 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
<?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');
print $text. ' '.$name.' '. $phone.' '. $email;
}
public function actionFilter(){
if(!empty(Yii::app()->request->getParam('StoFilter'))){
$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( Yii::app()->request->getParam('StoFilter')['model']) && !empty( Yii::app()->request->getParam('StoFilter')['engine']) && !empty( Yii::app()->request->getParam('StoFilter')['drive_unit']) && !empty( Yii::app()->request->getParam('StoFilter')['transmission'])&& !empty( Yii::app()->request->getParam('StoFilter')['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(){
if(!empty(Yii::app()->request->getParam('id')) && !empty(Yii::app()->request->getParam('dist'))){
$id = Yii::app()->request->getParam('id');
$dist = Yii::app()->request->getParam('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
));
}
}
}