?> </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) {
/** * 根据车型获取车系 * Enter description here ... */ public function actionGetcar() { echo CHtml::tag("option", array("value" => ''), '请选择车系', true); if ($_GET["make"]) { $data = TransportCar::model()->findAll("Make=:Make", array(":Make" => $_GET["make"])); $data = CHtml::listData($data, "Code", "Car"); foreach ($data as $value => $name) { echo CHtml::tag("option", array("value" => $value), CHtml::encode($name), true); } } }
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); }
<?php echo CHtml::dropDownList('city', $search['city'], $city_update, array('class' => 'width118 select', 'empty' => '请选择市')); ?> </p> <p class='form-row'> <label class="label">适用车型:</label> <?php $brand_data = TransportMake::model()->findAll(); $brand = CHtml::listData($brand_data, "Code", "Make"); ?> <?php echo CHtml::dropDownList('vehicleMake', $search['vehicleMake'], $brand, array('class' => 'width118 select', 'empty' => '请选择品牌', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->request->baseUrl . '/common/getcar', 'update' => '#vehicleModel', 'data' => 'js:"make="+jQuery(this).val()'))); ?> <?php if ($search['vehicleMake']) { $vehicleModel_data = TransportCar::model()->findAll("Make=:parent", array(":parent" => $search['vehicleMake'])); $vehicleModel = CHtml::listData($vehicleModel_data, "Code", "Car"); } ?> <?php $vehicleModel_update = $search['vehicleMake'] ? $vehicleModel : array(); ?> <?php echo CHtml::dropDownList('vehicleModel', $search['vehicleModel'], $vehicleModel_update, array('class' => 'width118 select', 'empty' => '请选择车系')); ?> <label class="label"> 嘉配号: </label> <?php echo CHtml::textField('jiapartID', $search['jiapartID'], array('class' => "width231 input")); ?> </label>
} ?> > <span id="zyxl" class='checkbox-add tags repair <?php if ($search['repair'] == "全车系") { ?> bg-green <?php } ?> '>全车系</span> <span class="checkbox-add">|</span> <?php echo CHtml::dropDownList('repair-make', $search['repair-make'], $brand, array('class' => 'width118 select', 'empty' => '请选择品牌', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->request->baseUrl . '/common/getcarbyid', 'update' => '#repair-car', 'data' => 'js:"make="+jQuery(this).val()'))); ?> <?php $repair_data = TransportCar::model()->findAll("Make=:Make", array(":Make" => $search['repair-make'])); $repair = CHtml::listData($repair_data, "Code", "Car"); ?> <?php echo CHtml::dropDownList('repair-car', $search['repair-car'], $repair, array('class' => 'width118 select', 'empty' => '请选择车系')); ?> </span> <span id="insuranceService" <?php if ($search['category'] != "车险服务") { ?> style="display: none;" <?php } ?> >
<label class='label'></label> <span id='tag1' class="width451 slide display-n"> <a class='tag'>轮胎</a> </span> </p> <p class="form-row" id="showVehicle"><!-- 显示车系车型 --> <label class=label></label> <?php foreach ($showvehicles as $showvehicle) { ?> <span class='checkbox-add bg-green tag-close catespan'><span><?php TransportMake::showMake($showvehicle['businessCar']); ?> </span>-<span><?php TransportCar::showCar($showvehicle['businessCarModel']); ?> </span><span onclick='xxVehicle(this)' key="<?php echo $showvehicle['id']; ?> " class='close icon-close-green xx'></span></span> <?php } ?> </p> <p class="form-row"> <label class='label'><?php echo $form->labelEx($model, 'businessCar'); ?> </label>