/** * 批量上传商品 */ public function actionRecomupload() { $this->pageTitle = Yii::app()->name . '-' . "商品管理"; //文件模板为product $template = "dealergoods"; $userID = Yii::app()->user->id; $organID = 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); //如果上传成,则解析Excel文件 if ($upload_result['success']) { //解析Excel文件,返回结果为错误消息,如果不为空则表明发生错误 $uploadfile = $upload_result['uploadfile']; $dataImport = new GoodsImport(); $createtime = time(); $data = array('OrganID' => $organID, 'UserID' => $userID, 'CreateTime' => $createtime); $result = $dataImport->parse($uploadfile, $template, $data); //如果不成功则返回错误结果 if (!$result['success']) { $message = $result['error']; $this->render('index', array('message' => $message)); exit; } $insert_sql = $result['sql']; $sql_result = DBUtil::execute($insert_sql); //如果SQL执行不成功则返回错误结果 if ($sql_result && !$sql_result['result']) { $this->render('index', array('message' => $sql_result['error'])); exit; } else { // 上传成功,则把上传成功的数据展示出来 // 把数据分拆出来,添加到其他表 、DealerParts 、DealerPromotionCpname // $message = Yii::app()->db->getLastInsertID(); $lastID = Yii::app()->db->getLastInsertID(); $newsgoods = DealerGoods::model()->findAll("ID >= {$lastID}"); foreach ($newsgoods as $value) { $goodsspec = new DealerGoodsSpec(); $goodsspec->GoodsID = $value['ID']; $goodsspec->save(); $goodspack = new DealerGoodsPack(); $goodspack->GoodsID = $value['ID']; $goodspack->save(); $goodsoe = new DealerGoodsOenoRelation(); $goodsoe->GoodsID = $value['ID']; $goodsoe->OENO = $value['OENO']; $goodsoe->OrganID = $organID; $goodsoe->save(); } $this->redirect(array('index', 'message' => $booc, 'success' => TRUE)); } } else { $message = $upload_result['error']; $this->render('index', array('message' => $message)); } } }
private static function getGoodsImage($goodsID) { $criteria = new CDbCriteria(); $criteria->select = "ImageUrl"; $criteria->condition = "t.GoodsID = " . $goodsID; $model = DealerGoodsSpec::model()->find($criteria); return $model->ImageUrl; }