<label class="label">配件品类：</label>
<?php
$father_data = MakePartsGroupFather::model()->findAll();
$father = CHtml::listData($father_data, "code", "category_father");
?>
<?php
echo CHtml::dropDownList('category_father', '', $father, array('class' => 'width118 select', 'empty' => '请选择主组', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->request->baseUrl . '/common/getchildren', 'update' => '#category_children', 'data' => 'js:"father="+jQuery(this).val()')));
?>
<?php
echo CHtml::dropDownList('category_children', '', array(), array('class' => 'width118 select', 'empty' => '请选择子组'));
?>
<label class="label">适用车型：</label>
<?php
$make_data = TransportMake::model()->findAll();
$make = CHtml::listData($make_data, "Code", "Make");
?>
<?php
echo CHtml::dropDownList('make', 'businessCar', $make, array('class' => 'width118 select', 'empty' => '请选择品牌', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->request->baseUrl . '/common/getcar', 'update' => '#car', 'data' => 'js:"make="+jQuery(this).val()')));
?>
<?php
echo CHtml::dropDownList('car', 'businessCarModel', array(), array('class' => 'width118 select', 'empty' => '请选择车系'));
?>
</p>
<p class='form-row'>
<label class="label">嘉配号： </label>
<select name="jiapartID" class="width118 select">
<option value='0'>选择嘉配号</option>
</select>
public function actionService()
{
$this->pageTitle = Yii::app()->name . ' - 修理厂查询';
$userId = Commonmodel::getOrganID();
if ($_GET) {
$search['keyword'] = $_GET['keyWord'] == "机构名称或关键词" ? '' : $_GET['keyWord'];
$search['province'] = $_GET['province'];
$search['city'] = $_GET['city'];
$search['area'] = $_GET['area'];
$search['category'] = $_GET['category'];
$search['deep'] = $_GET['deep'];
$search['vehicle'] = $_GET['vehicle'];
$search['maintenance'] = $_GET['maintenance'];
$search['maintenance-make'] = $_GET['maintenance-make'];
$search['maintenance-car'] = $_GET['maintenance-car'];
$search['diagnosis'] = $_GET['diagnosis'];
$search['diagnosis-make'] = $_GET['diagnosis-make'];
$search['diagnosis-car'] = $_GET['diagnosis-car'];
$search['parts'] = $_GET['parts'];
$search['repair'] = $_GET['repair'];
$search['repair-make'] = $_GET['repair-make'];
$search['repair-car'] = $_GET['repair-car'];
$search['insurer'] = $_GET['insurer'];
}
$conditions = " 1 = 1 ";
$join = "";
$inner = " INNER JOIN {{service_mainbusiness}} AS main ON main.userId = ser.userId";
if ($search) {
if ($search['keyword']) {
$join .= " AND (ser.serviceName like '%{$search['keyword']}%' or main.keyWord like '%{$search['keyword']}%')";
}
if ($search['province']) {
$conditions .= " AND serviceProvince = {$search['province']}";
}
if ($search['city']) {
$conditions .= " AND serviceCity = {$search['city']}";
}
if ($search['area']) {
$conditions .= " AND serviceArea = {$search['area']}";
}
if ($search['category']) {
switch ($search['category']) {
case "深度清洁":
$join .= " AND main.deepCleaning = '{$search['deep']}'";
break;
case "车辆美容":
$join .= " AND main.vehiclesBeauty = '{$search['vehicle']}'";
break;
case "日常保养":
if ($search['maintenance'] == "全车系") {
$join .= " AND main.routineMaintenance = '{$search['maintenance']}'";
} else {
$join .= " INNER JOIN {{service_mainbusiness_routine}} AS rou ON ser.userId = rou.userId\n\t\t\t\t\t\t\t\t\tAND rou.make = '{$search['maintenance-make']}' AND rou.car = '{$search['maintenance-car']}'";
}
break;
case "检查诊断":
if ($search['diagnosis'] == "全车系") {
$join .= " AND main.diagnosis = '{$search['diagnosis']}'";
} else {
$join .= " INNER JOIN {{service_mainbusiness_diagnosis}} AS diag ON ser.userId = diag.userId\n\t\t\t\t\t\t\t\t\tAND diag.make = '{$search['diagnosis-make']}' AND diag.car = '{$search['diagnosis-car']}'";
}
break;
case "易损件更换":
$join .= " AND main.wearingParts like '%{$search['parts']}%'";
break;
case "专业修理":
if ($search['repair'] == "全车系") {
$join .= " AND main.professionalRepair = '{$search['repair']}'";
} else {
$join .= " INNER JOIN {{service_mainbusiness_repair}} AS rep ON ser.userId = rep.userId\n\t\t\t\t\t\t\t\t\tAND rep.make = '{$search['repair-make']}' AND rep.car = '{$search['repair-car']}'";
}
break;
case "车险服务":
foreach ($search['insurer'] as $key => $value) {
$join .= " AND main.insuranceService like '%{$value}%'";
}
break;
}
}
}
$sql = "SELECT * FROM {{service}} AS ser {$inner} {$join} where {$conditions}";
//获取修理厂数量(在常态下及在查询状态下的判断)
$csql = "SELECT * FROM {{service}}";
if ($search) {
$count = DBUtil::queryAll($sql);
} else {
$count = DBUtil::queryAll($csql);
}
$pagesize = 3;
$page = !empty($_GET['page']) ? $_GET['page'] : 1;
$page = $pagesize * ($page - 1);
$result = DBUtil::queryAll($sql);
$count = count($result);
$limit = " limit {$page}, {$pagesize} ";
$service = DBUtil::queryAll($sql . $limit);
$pageData = array('total_rows' => $count, 'parameter' => '', 'list_rows' => $pagesize, 'page_name' => 'page', 'ajax_func_name' => '', 'method' => '');
$page = new Pagination($pageData);
$page = $page->show(1);
$make = TransportMake::model()->findAll();
$parts = WearingParts::model()->findAll();
$insur = Insurance::model()->findAll();
foreach ($service as $res) {
$major = ServiceMainbusiness::model()->findAll(array("condition" => "userId = {$res['userId']}"));
foreach ($major as $val) {
$type[] = ServiceMainbusiness::model()->find(array("condition" => "userId = {$val['userId']}"));
$insurance[] = ServiceMainbusiness::model()->find(array("condition" => "userId = {$val['userId']}"));
}
}
$this->render('service', array('service' => $service, 'search' => $search, 'page' => $page, 'make' => $make, 'parts' => $parts, 'insur' => $insur, 'count' => $count, 'type' => $type, 'insurance' => $insurance));
}
