?> </td> <td><?php echo F::msubstr(MakeGoodsBrand::getBrands($model['userID'])); ?> </td> <td> <?php //echo $model['userID']; $cars = MakeOrganCarRelation::model()->findAll('userID =' . $model['userID']); $k = 1; foreach ($cars as $car) { if ($k == 1) { $makecar .= TransportMake::getMake($car['makeCode']) . ' ' . TransportCar::getCar($car['carCode']); } else { $makecar .= ',' . TransportMake::getMake($car['makeCode']) . ' ' . TransportCar::getCar($car['carCode']); } $k++; } echo F::msubstr($makecar); $makecar = ''; ?> </td> <td> <?php if (!empty($model['userID'])) { // $cpnames = DealerCpname::model()->findAll("OrganID = " . $dealer['userID']); $cpnames = DealerCpname::model()->findAll("OrganID = " . $model['userID']); //var_dump($cpnames); $k = 1; foreach ($cpnames as $cpname) {
<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>
function parse($excelfile, $template, $data = array()) { try { //获取上传文件的文件名扩展名 $extend = strtolower(strrchr($excelfile, '.')); $readerType = $extend == '.xlsx' ? 'Excel2007' : 'Excel5'; $objReader = new PHPExcel(); $objReader = PHPExcel_IOFactory::createReader($readerType); //use Excel5 for 5fromat ,use excel2007 for 2007 format $objPHPExcel = $objReader->load($excelfile); if (!$objPHPExcel) { $error = '加载Excel出错'; return array('success' => false, 'error' => $error); } $objWorksheet = $objPHPExcel->getActiveSheet(); //取得活动sheet if (!$objWorksheet) { $error = '加载Excel出错'; return array('success' => false, 'error' => $error); } $title = $objWorksheet->getTitle(); //取得sheet名称 $highestRow = $objWorksheet->getHighestRow(); //取得总行数 $highestColumn = $objWorksheet->getHighestColumn(); //取得总列数 $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); //总列数 //执行结果 $error = ""; $first_row = array(); for ($col = 0; $col < $highestColumnIndex; $col++) { $first_row[$col] = $objWorksheet->getCellByColumnAndRow($col, 1)->getValue(); } //验证表结构,表名称和字段列表 if (!$this->validateExcel($template, $first_row)) { $error = "Excel内容与模板不符合"; //$error = $first_row; return array('success' => false, 'error' => $error); } //生成插入语句的头部 $sql_header = $this->generateSqlHeader($template, $first_row); if ($sql_header == "") { $error = "SQL语句头部生成失败"; return array('success' => false, 'error' => $error); } //生成SQL语句 $sql = $sql_header; for ($row = 2; $row <= $highestRow; $row++) { //每行的第一列数据不能为空 $first_value = $objWorksheet->getCellByColumnAndRow(0, $row)->getValue(); if (empty($first_value)) { continue; } $data_new = array(); $sql_data = '('; ////注意highestColumnIndex的列数索引从0开始 for ($col = 0; $col < $highestColumnIndex; $col++) { $data_new[$col] = $objWorksheet->getCellByColumnAndRow($col, $row)->getValue(); if ($col == 6) { // 车品牌 $data_new[$col] = TransportMake::getCode($data_new[$col]); } if ($col == 7) { $data_new[$col] = TransportCar::getCode($data_new[$col]); } $sql_data .= "'" . trim($data_new[$col]) . "',"; } if ($template == "promotion") { //促销商品 $sql_data .= "'" . $data['createtime'] . "','" . $data['userID'] . "'"; } else { if ($template == 'subdealer') { $sql_data .= "'" . $data['flag'] . "','" . $data['UserID'] . "'"; } } $sql_data .= ")"; //var_dump($sql_data);exit; //验证数据是否正确 //$this->validateData($data_new[$col]); $sql .= $sql_data . ','; } $sql = rtrim($sql, ",") . ";"; //返回结果数据 $success = false; if ($error == "" && $sql != "") { $success = true; } } catch (Exception $e) { $success = false; $error = '解析Excel出错' . $e->getMessage(); } return array('success' => $success, 'error' => $error, 'sql' => $sql); }
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)); }