?>
</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>
