Exemplo n.º 1
0
 /**
  * 经销商上传下属机构信息
  */
 public function actionSubdealerupload()
 {
     //文件模板为product
     $template = "subdealer";
     $dealerID = Commonmodel::getOrganID();
     //上传文件
     if ($_POST['leadExcel'] == "true") {
         $filename = iconv("utf-8", "gb2312", $_FILES['inputExcel']['name']);
         $tmp_name = $_FILES['inputExcel']['tmp_name'];
         //$filePath = dirname(Yii::app()->BasePath) . "\\themes\\default\\uploadsfile\\dealer\\execl\\";
         $filePath = Yii::app()->params['uploadPath'] . '/dealer/execl/';
         $upload_result = UploadsFile::uploadFile($filename, $tmp_name, $filePath);
         //var_dump($upload_result);
         //如果上传成,则解析Excel文件
         if ($upload_result['success']) {
             //解析Excel文件,返回结果为错误消息,如果不为空则表明发生错误
             $uploadfile = $upload_result['uploadfile'];
             $dataImport = new DataImport();
             $endtime = time() + 24 * 60 * 60 * 2 * 7;
             $data = array('flag' => '1', 'UserID' => $dealerID);
             $result = $dataImport->parse($uploadfile, $template, $data);
             //如果不成功则返回错误结果
             if (!$result['success']) {
                 $message = $result['error'];
                 //var_dump($message);
                 $this->render('batchimport', array('message' => $message));
                 exit;
             }
             //var_dump($result);
             $insert_sql = $result['sql'];
             $sql_result = DbUtil::execute($insert_sql);
             //如果SQL执行不成功则返回错误结果
             if ($sql_result && !$sql_result['result']) {
                 $this->render('batchimport', array('message' => $sql_result['error']));
                 exit;
             }
             //查询上传成功的产品信息
             $message = "文件上传成功!";
             $this->redirect('subdealer');
         } else {
             $message = $upload_result['error'];
             $this->render('batchimport', array('message' => $message));
         }
     }
 }