/**
* 批量上传商品
*/
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;
}
