/**
* 导入商品csv
* */
function upload_csv()
{
$mark = IReq::get('marked');
$csvType = IReq::get('date_format');
//调用文件上传类
$uploadObj = new IUpload(10240, array('csv'));
$uploadObj->setDir('upload/' . date('Y/m/d'));
$photo = $uploadObj->execute();
if (!isset($photo['attach'][0]['flag']) || $photo['attach'][0]['flag'] == '-1') {
echo "<br /><div align='center'>请选择CSV文件</div>";
exit;
}
//上传路径
$csvfile = $photo['attach'][0]['fileSrc'];
//创建csv对象
$csvObj = new Csv();
$if_sucee = $csvObj->import($csvType, $csvfile, $mark);
if ($if_sucee == '0') {
IFile::unlink($csvfile);
//导入成功，删除csv文件
echo "<br /><div align='center'>商品CSV导入成功</div>";
} else {
IFile::unlink($csvfile);
//导入失败，删除csv文件
echo "<br /><div align='center'>商品CSV导入失败</div>";
}
}
/**
* @brief 开始执行上传
* @return array 包含上传成功信息的数组
* $file = array(
* name 如果上传成功，则返回上传后的文件名称，如果失败，则返回客户端名称
* size 上传附件大小
* fileSrc 上传文件完整路径
* dir 上传目录
* ininame 上传图片名
* flag -1:文件类型不允许; -2:文件大小超出限制; 1:上传成功
* ext 上传附件扩展名
* );
*/
public function execute()
{
//总的文件上传信息
$info = array();
foreach ($_FILES as $field => $file) {
$fileInfo = array();
//不存在上传的文件名
if (!isset($_FILES[$field]['name']) || $_FILES[$field]['name'] == '' || !isset($_FILES[$field]['tmp_name'])) {
continue;
}
//上传控件为数组格式 file[]格式
if (is_array($_FILES[$field]['name'])) {
$keys = array_keys($_FILES[$field]['name']);
foreach ($keys as $key) {
if (!isset($_FILES[$field]['name'][$key]) || $_FILES[$field]['name'][$key] == '') {
continue;
}
//获取扩展名
$fileext = IFile::getFileType($_FILES[$field]['tmp_name'][$key]);
if (is_array($fileext) || $fileext == null) {
$fileext = IFile::getFileSuffix($_FILES[$field]['name'][$key]);
}
/*开始上传文件*/
//(1)上传类型不符合
if (!in_array($fileext, $this->allowType)) {
$fileInfo[$key]['name'] = $_FILES[$field]['name'][$key];
$fileInfo[$key]['flag'] = -1;
} else {
if ($_FILES[$field]['size'][$key] > $this->maxsize) {
$fileInfo[$key]['name'] = $_FILES[$field]['name'][$key];
$fileInfo[$key]['flag'] = -2;
} else {
//修改图片状态值
$fileInfo[$key]['name'] = ITime::getDateTime('Ymdhis') . mt_rand(100, 999) . '.' . $fileext;
$fileInfo[$key]['dir'] = $this->dir;
$fileInfo[$key]['size'] = $_FILES[$field]['size'][$key];
$fileInfo[$key]['ininame'] = $_FILES[$field]['name'][$key];
$fileInfo[$key]['ext'] = $fileext;
$fileInfo[$key]['fileSrc'] = $fileInfo[$key]['dir'] . $fileInfo[$key]['name'];
if (is_uploaded_file($_FILES[$field]['tmp_name'][$key])) {
if (move_uploaded_file($_FILES[$field]['tmp_name'][$key], $this->dir . $fileInfo[$key]['name'])) {
if (file_exists($_FILES[$field]['tmp_name'][$key])) {
IFile::unlink($_FILES[$field]['tmp_name'][$key]);
}
$fileInfo[$key]['flag'] = 1;
}
}
}
}
}
} else {
if ($_FILES[$field]['name'] == '' || $_FILES[$field]['tmp_name'] == '') {
continue;
}
//获取扩展名
$fileext = IFile::getFileType($_FILES[$field]['tmp_name']);
if (is_array($fileext) || $fileext == null) {
$fileext = IFile::getFileSuffix($_FILES[$field]['name']);
}
/*开始上传文件*/
//(1)上传类型不符合
if (!in_array($fileext, $this->allowType)) {
$fileInfo[0]['name'] = $_FILES[$field]['name'];
$fileInfo[0]['flag'] = -1;
} else {
if ($_FILES[$field]['size'] > $this->maxsize) {
$fileInfo[0]['name'] = $_FILES[$field]['name'];
$fileInfo[0]['flag'] = -2;
} else {
//修改图片状态值
$fileInfo[0]['name'] = ITime::getDateTime('Ymdhis') . mt_rand(100, 999) . '.' . $fileext;
$fileInfo[0]['dir'] = $this->dir;
$fileInfo[0]['size'] = $_FILES[$field]['size'];
$fileInfo[0]['ininame'] = $_FILES[$field]['name'];
$fileInfo[0]['ext'] = $fileext;
$fileInfo[0]['fileSrc'] = $fileInfo[0]['dir'] . $fileInfo[0]['name'];
if (is_uploaded_file($_FILES[$field]['tmp_name'])) {
if (move_uploaded_file($_FILES[$field]['tmp_name'], $this->dir . $fileInfo[0]['name'])) {
if (file_exists($_FILES[$field]['tmp_name'])) {
IFile::unlink($_FILES[$field]['tmp_name']);
}
$fileInfo[0]['flag'] = 1;
}
}
}
}
}
$info[$field] = $fileInfo;
}
return $info;
}
function delgoodsimg()
{
$id = intval(IReq::get('id'));
$this->checkshoplogin();
$shopid = ICookie::get('adminshopid');
if (empty($shopid)) {
$this->message('未选择店铺');
}
$goodsinfo = $this->mysql->select_one("select * from " . Mysite::$app->config['tablepre'] . "goods where id ='" . $id . "' and shopid ='" . $shopid . "' ");
if (empty($goodsinfo)) {
$this->message('商品信息获取失败');
}
if (!empty($goodsinfo['img'])) {
IFile::unlink(hopedir . $goodsinfo['img']);
$udata['img'] = '';
$this->mysql->update(Mysite::$app->config['tablepre'] . 'goods', $udata, "id='" . $id . "'");
}
$this->success('操作成功');
}
function ticket_excel_del()
{
$id = IFilter::act(IReq::get('id'));
if ($id) {
if (is_array($id)) {
foreach ($id as $val) {
IFile::unlink($this->ticketDir . '/' . $val);
}
} else {
IFile::unlink($this->ticketDir . '/' . $id);
}
$this->ticket_excel_list();
} else {
$this->ticket_excel_list();
Util::showMessage('请选择要删除的文件');
}
}
/**
* @brief 删除与商品相关表中的数据
*/
public function del($goods_id)
{
$goodsWhere = " id = '{$goods_id}' ";
if ($this->seller_id) {
$goodsWhere .= " and seller_id = " . $this->seller_id;
}
//图片清理
$tb_photo_relation = new IModel('goods_photo_relation');
$photoMD5Data = $tb_photo_relation->query('goods_id = ' . $goods_id);
$tb_photo = new IModel('goods_photo');
foreach ($photoMD5Data as $key => $md5) {
//图片是否被其他商品共享占用
$isUserd = $tb_photo_relation->getObj('photo_id = "' . $md5['photo_id'] . '" and goods_id != ' . $goods_id);
if (!$isUserd) {
$imgData = $tb_photo->getObj('id = "' . $md5['photo_id'] . '"');
isset($imgData['img']) ? IFile::unlink($imgData['img']) : "";
$tb_photo->del('id = "' . $md5['photo_id'] . '"');
}
}
$tb_photo_relation->del('goods_id = ' . $goods_id);
//删除商品表
$tb_goods = new IModel('goods');
$goodsRow = $tb_goods->getObj($goodsWhere, "content");
if (isset($goodsRow['content']) && $goodsRow['content']) {
}
$tb_goods->del($goodsWhere);
}
function delerrlog()
{
$dirname = IReq::get('dirname');
if (empty($dirname)) {
$this->message('文件名为空');
}
IFile::unlink(hopedir . '/log/' . $dirname);
$this->success('操作成功！ ');
}
