コード例 #1
0
ファイル: index.php プロジェクト: zwq/unpei
        ?>
</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) {
コード例 #2
0
ファイル: empowerdealer.php プロジェクト: zwq/unpei
				<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">嘉配号:&nbsp;&nbsp;</label>
					<select name="jiapartID" class="width118 select">
					<option value='0'>选择嘉配号</option>
				 	</select>
コード例 #3
0
ファイル: ProImport.php プロジェクト: zwq/unpei
 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);
 }
コード例 #4
0
ファイル: ServicequeryController.php プロジェクト: zwq/unpei
 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));
 }