<?php
|
|
namespace app\admin\controller;
|
|
use think\Exception;
|
use think\facade\Config;
|
use think\facade\Db;
|
use think\facade\View;
|
use think\facade\Request;
|
use \app\admin\validate\SalesPlatform as SalesPlatformValidate;
|
|
class SalesPlatform extends Common {
|
|
private $tableName = 'sales_platform';
|
private $viewPath = 'salesPlatform';
|
/**
|
* 销售平台列表
|
* @return string
|
*/
|
public function index() {
|
////////
|
if (!Request::isPost()) {
|
View::assign('viewPath', $this->viewPath);
|
return View::fetch();
|
} else {
|
try {
|
$kw = input('kw');
|
if (!empty($kw)) {
|
$condition[] = array('platform_name', 'like', "%$kw%");
|
}
|
$p = input('p', 1);
|
$other['page_size'] = input('page_size', 20);
|
$order = 'order_id asc,id asc';
|
$count = Db::name($this->tableName)->where($condition)->count();
|
$list = Db::name($this->tableName)->field("*")->where($condition)->withAttr('platform_region_id', function ($value) {
|
// $info['goods_purpose'] = json_decode($info['goods_purpose'], TRUE);
|
return json_decode($value, TRUE);
|
})->order($order)->page($p, $other['page_size'])->select()->toArray();
|
$other['count'] = $count;
|
if (!$list) {
|
$list = [];
|
}
|
$result['other'] = $other;
|
$result['list'] = $list;
|
return $this->successResponse($result);
|
} catch (Exception $exc) {
|
return $this->errorResponse($exc->getMessage());
|
}
|
}
|
}
|
|
/**
|
*保存销售平台
|
*/
|
public function save() {
|
if (!Request::isPost()) {
|
return $this->errorResponse(lang('request_method_incorrect'));
|
}
|
//开始事务
|
Db::startTrans();
|
try {
|
$data = Request::post();
|
$validate = new SalesPlatformValidate();
|
$check_result = $validate->check($data);
|
if (!$check_result) {
|
throw new Exception($validate->getError());
|
}
|
if ($data['platform_region_id']) {
|
$data['platform_region_id'] = json_encode(array_map('intval', $data['platform_region_id']));////将数组中的值转为数字类型/////
|
}
|
$id = input('post.id');
|
if (is_numeric($id)) {
|
//更新数据
|
$update_result = Db::name($this->tableName)->where('id', $id)->withoutField('id')->save($data);
|
if ($update_result === FALSE) {
|
return $this->errorResponse(lang('editing_failed'));
|
}
|
//提交事务
|
Db::commit();
|
return $this->successResponse('修改成功！');
|
} else {
|
//添加数据
|
unset($data['id']);
|
$add_result = Db::name($this->tableName)->insertGetId($data);
|
if (!$add_result) {
|
return $this->errorResponse('添加失败！');
|
}
|
Db::name($this->tableName)->where('id', $add_result)->save(['order_id' => $add_result]);
|
//提交事务
|
Db::commit();
|
return $this->successResponse('添加成功！');
|
}
|
} catch (Exception $exc) {
|
// 回滚事务
|
Db::rollback();
|
return $this->errorResponse($exc->getMessage());
|
}
|
}
|
|
function updateExt() {
|
try {
|
if (!Request::isPost()) {
|
throw new Exception(lang('request_method_incorrect'));
|
}
|
$postField = 'id,is_show';
|
$data = Request::only(explode(',', $postField), 'post');
|
if (!$data['id']) {
|
throw new Exception(lang('parameter_error'));
|
}
|
Db::name($this->tableName)->update($data);
|
$result['message'] = '操作成功';
|
return $this->successResponse($result);
|
} catch (\Exception $exc) {
|
return $this->errorResponse($exc->getMessage());
|
}
|
}
|
|
public function uploadLogo() {
|
|
$logo = input('logo');
|
$id = input('id');
|
|
$ext_arr = array(
|
'image' => array('jpg', 'jpeg', 'png'),
|
);
|
$maxSizeArr = array(
|
'image' => 1024 * 1024 * 10,
|
);
|
$bannersize = Config::get('app.BANNER_SIZE');
|
$width = $bannersize['suolue']['w'];
|
$height = $bannersize['suolue']['h'];
|
$ratio = $bannersize['suolue']['r'];
|
|
$upload = new \common\UploadFile(); // 实例化上传类
|
$upload->uploadReplace = TRUE; //同名文件自动覆盖
|
$upload->autoSub = TRUE; // 启用子目录保存文件
|
$upload->subType = 'date'; // 子目录创建方式 可以使用hash date custom
|
$upload->dateFormat = 'Y/m/d'; //定义 subType=date 后，才需要定义dateFormat
|
$upload->maxSize = 1024 * 1024 * 0; // 设置附件上传大小 10M
|
$upload->maxSizeArr = $maxSizeArr; // 设置附件上传大小 10M
|
$upload->allowExts = $ext_arr; // 设置附件上传类型
|
$upload->savePath = './static/upload/'; // 设置附件上传目录
|
$upload->ratio = $ratio; //1:按比例缩放，2：裁切固定值大小
|
|
$upload->thumb = FALSE; // 使用对上传图片进行缩略图处理
|
//$upload->imageClassPath='LIB.Util.Image'; // 图库类包路径 用于生成缩略图
|
$upload->thumbMaxWidth = $width; // 缩略图最大宽度
|
$upload->thumbMaxHeight = $height; // 缩略图最大高度
|
$upload->thumbRemoveOrigin = FALSE; // 是否移除原图 移除原图时，必须给 thumbPrefix指定一个前缀,否则会将原图误删除
|
|
|
$backinfo = $upload->uploadmore();
|
if (!$backinfo) {// 上传错误提示错误信息
|
return $this->errorResponse($upload->getErrorMsg());
|
} else {
|
$update_info = $upload->getUploadFileInfo();
|
$photo = $update_info['savename'];
|
if (is_numeric($id) && $id > 0) {
|
$info = Db::name($this->tableName)->field('logo')->where('id', $id)->find();
|
if($info){
|
if($info['logo']){
|
delpic($info['logo']);
|
}
|
$update_data['logo'] = $photo;
|
Db::name($this->tableName)->where('id', $id)->update($update_data);//更新数据
|
$this->uploadFileToCos($photo);//上传到cos
|
}
|
else{
|
//数据不存在视为新增数据，删除旧图片
|
if ($logo) {
|
delpic($logo);
|
$this->deleteFileFromCos($logo);//从cos删除文件
|
}
|
}
|
} else {
|
//新增数据，删除旧图片
|
if ($logo) {
|
delpic($logo);
|
$this->deleteFileFromCos($logo);//从cos删除文件
|
}
|
}
|
// 上传成功 获取上传文件信息
|
//上传可同时上传多个,上传方式为一次上传多个
|
$result['logo'] = $photo;
|
$result['message'] = lang('successfully_uploaded');
|
return $this->successResponse($result);
|
}
|
}
|
|
/**
|
* 删除销售平台
|
* @return array|int[]
|
*/
|
public function delete() {
|
if (!Request::isPost()) {
|
return $this->errorResponse(lang('request_method_incorrect'));
|
}
|
//开始事务
|
Db::startTrans();
|
try {
|
$id = input('id');
|
if (!is_numeric($id)) {
|
return $this->errorResponse(lang('parameter_error'));
|
}
|
$condition['id'] = $id;
|
$info = Db::name($this->tableName)->field('id')->where($condition)->find();
|
if (!$info) {
|
return $this->errorResponse(lang('parameter_error'));
|
}
|
Db::name($this->tableName)->where('id', $id)->delete();
|
//提交事务
|
Db::commit();
|
return $this->successResponse('删除成功！');
|
} catch (Exception $exc) {
|
// 回滚事务
|
Db::rollback();
|
return $this->errorResponse($exc->getMessage());
|
}
|
}
|
|
|
public function getPlatformRegion() {
|
////////
|
try {
|
if(!Request::isPost()){
|
throw new Exception(lang('request_method_incorrect'));
|
}
|
$list = Db::name('platform_region')->field("*")->order('order_id,id')->select()->toArray();
|
if (!$list) {
|
$list = [];
|
}
|
$result['list'] = $list;
|
return $this->successResponse($result);
|
} catch (Exception $exc) {
|
return $this->errorResponse($exc->getMessage());
|
}
|
|
}
|
|
}
|
