/** * 经销商上传下属机构信息 */ 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)); } } }