1758 行
68 KiB
PHP
可执行文件
1758 行
68 KiB
PHP
可执行文件
<?php
|
||
|
||
namespace Retail\Controller;
|
||
|
||
use Common\Business\DownFile;
|
||
use Common\Business\GoodsClassify;
|
||
use Common\Business\GoodsState;
|
||
use Common\Business\OperateMGoods;
|
||
use Common\Business\Plug;
|
||
use Common\Business\SerialNumberGoods;
|
||
use Common\Business\SkuAttribute;
|
||
use Common\Model\ImageGalleryModel;
|
||
use Common\Model\RetailDaDaCityModel;
|
||
use Common\Model\RetailGoodsClassModel;
|
||
use Common\Model\RetailMgoodsModel;
|
||
use Common\Model\SaleMGoodsModel;
|
||
use Common\Model\SkuMGoodsViewModel;
|
||
use Guzzle\Parser\ParserRegistry;
|
||
use Think\Controller;
|
||
use Common\Business\Goods;
|
||
use Common\Model\RetailGoodsBrandModel;
|
||
|
||
//[1.9.20]
|
||
|
||
/**
|
||
* 商户商品档案
|
||
* Class MgoodsController
|
||
* @package Retail\Controller
|
||
*/
|
||
class MgoodsController extends BaseController
|
||
{
|
||
public function index()
|
||
{
|
||
$this->display();
|
||
}
|
||
|
||
|
||
//获取商户平台类型 1默认系统 2微礼平台
|
||
//德育币插件 true使用 false不使用
|
||
public function getPlatformType()
|
||
{
|
||
$Plug = new Plug();
|
||
$plugData = $Plug->merPlugState([
|
||
'merchant_id' => $this->merchant_id,
|
||
'identification_arr' => ['moraleducationcoin'],
|
||
]);
|
||
$result = [
|
||
'status' => 1,
|
||
'message' => '获取成功',
|
||
'platform_type' => $this->role_info['platform_type'] ? $this->role_info['platform_type'] : 1,
|
||
'moral_education_coin' => $plugData['moraleducationcoin'],
|
||
];
|
||
$this->ajaxReturn($result);
|
||
}
|
||
|
||
/**
|
||
* 获取商品列表
|
||
*/
|
||
public function goodsList()
|
||
{
|
||
$param = array(
|
||
'platform_type' => $this->role_info['platform_type'],
|
||
'merchant_id' => $this->merchant_id,
|
||
'page' => I('post.page') ? I('post.page') : 1, //页
|
||
'limit' => I('post.limit') ? I('post.limit') : 10, //每页数量
|
||
'need_img' => true, //是否需要图片
|
||
'need_goods_num' => true, //是否需要库存
|
||
'need_count' => true, //是否需要总数量
|
||
'keyword' => I('post.keyword'),
|
||
'keyword_type' => I('post.keyword_type'),
|
||
'can_exchange_weigh' => I('post.can_exchange_weigh'),
|
||
'condition_name' => I("post.condition_name"), //排序规则关键词
|
||
'order_type' => I("post.order_type"), //排序规则
|
||
//按照商品类别搜索
|
||
'person1' => I('post.person1'),
|
||
'person2' => I('post.person2'),
|
||
'person3' => I('post.person3'),
|
||
'status' => I('post.status'),//商品状态 0上架 1下架
|
||
'issellonline' => I('post.issellonline'), //商城出售状态
|
||
'attribute_state' => I('post.attribute'), //规格 1无规格 2规格
|
||
'recovery_type' => I('post.recovery_type'), //2回收站
|
||
);
|
||
$SkuGoodsViewModel = new OperateMGoods();
|
||
$ret = $SkuGoodsViewModel->getMerGoodsList($param);
|
||
$this->ajaxReturn($ret);
|
||
}
|
||
|
||
public function goods_cate()
|
||
{
|
||
$user = session('ls_userinfo');
|
||
//根据商户查询处所有有效的一级分类
|
||
$map['pid'] = array('eq', 0);
|
||
$map['status'] = 0;
|
||
$map['merchantid'] = $user['merchantid'];
|
||
$class_name = M('retail_goods_class')->where(array('merchantid' => $user['merchantid'], 'status' => 0, 'type' => 1))->order('code asc')->select();
|
||
$this->assign('class_name', $class_name);
|
||
$this->display();
|
||
}
|
||
|
||
//异步获取数据 渲染layer表格
|
||
public function catesList()
|
||
{
|
||
|
||
//直接根据门店id查询出该门店所有分类
|
||
$user = session('ls_userinfo');
|
||
$where['merchantid'] = $user['merchantid'];
|
||
$where['pid'] = 0;
|
||
$where['status'] = 0;
|
||
//获取查询条件
|
||
if (!empty($_GET['keyword'])) {
|
||
if (is_numeric($_GET['keyword'])) {
|
||
//纯数字直接查询code编码
|
||
$where['code'] = array('like', '%' . $_GET['keyword'] . '%');
|
||
} else {
|
||
$where['class_name'] = array('like', '%' . $_GET['keyword'] . '%');
|
||
}
|
||
$this->assign('code_name', $_GET['keyword']);
|
||
}
|
||
$page = I('get.page');
|
||
$limit = I('get.limit');
|
||
$cates = M('retail_goods_class')->where($where)->page($page, $limit)->order('id asc')->select();
|
||
$cates_count = M('retail_goods_class')->where($where)->count();
|
||
//处理序号
|
||
if (!empty($cates)) {
|
||
foreach ($cates as $key => &$value) {
|
||
$value['key_num'] = $key + 1;
|
||
//统计出有效的二级分类
|
||
$num = M("retail_goods_class")->where(array('pid' => $value['id'], 'status' => 0))->count();
|
||
$cates[$key]['c_num'] = $num ? $num : 0;
|
||
}
|
||
}
|
||
$rt['code'] = 0;
|
||
$rt['msg'] = '';
|
||
$rt['count'] = $cates_count;
|
||
$rt['data'] = $cates;
|
||
$rt['post'] = $user;
|
||
$this->ajaxReturn($rt);
|
||
}
|
||
|
||
/**
|
||
* 添加/编辑类别
|
||
*/
|
||
public function cateSet()
|
||
{
|
||
$user = session('ls_userinfo');
|
||
if (IS_POST) {
|
||
$data = I('post.');
|
||
//判断是否有id传入
|
||
if (!$data['id']) {
|
||
$data['merchantid'] = $user['merchantid'];
|
||
//分类名称不能重复
|
||
$map['class_name'] = I("post.class_name");
|
||
$find = M("retail_goods_class")->where($map)->find();
|
||
if ($find) {
|
||
//存在
|
||
$res['status'] = 0;
|
||
$res['msg'] = '该分类已存在,请更换分类名';
|
||
} else {
|
||
//不存在id 创建新的数据
|
||
$data['addtime'] = time();
|
||
$create = M('retail_goods_class')->add($data);
|
||
if ($create) {
|
||
$res['status'] = 1;
|
||
$res['msg'] = '创建成功';
|
||
$res['data'] = $data;
|
||
}
|
||
}
|
||
$this->ajaxReturn($res);
|
||
} else {
|
||
$map['class_name'] = I("post.class_name");
|
||
$map['id'] = array('neq', I("post.id"));
|
||
$find = M("retail_goods_class")->where($map)->find();
|
||
if ($find) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '该分类已存在,请更换分类名';
|
||
} else {
|
||
$create = M('retail_goods_class')->where(array('id' => $data['id'], 'merchantid' => $user['merchantid']))->save($data);
|
||
if ($create) {
|
||
$res['status'] = 1;
|
||
$res['msg'] = '修改成功';
|
||
}
|
||
}
|
||
$this->ajaxReturn($res);
|
||
}
|
||
}
|
||
}
|
||
|
||
|
||
//+=======================================================================
|
||
//- 上面有二级分类
|
||
//+=======================================================================
|
||
|
||
/* 门店同步过的商品改为未同步 */
|
||
public function sync_two($goods_id)
|
||
{
|
||
$sync_two = M('retail_goods')->where(array('m_goods_id' => $goods_id, 'sync_state' => 1))->find();
|
||
if ($sync_two) {
|
||
M('retail_goods')->where(array('m_goods_id' => $goods_id))->setField('sync_state', 0);
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 自动获取获取货号
|
||
*/
|
||
public function auto_number()
|
||
{
|
||
$user = session('ls_userinfo');
|
||
if (IS_POST) {
|
||
$i = 0;
|
||
while (1) {
|
||
$num = rand(1000, 99999);
|
||
$where['merchantid'] = $user['merchantid'];
|
||
$where['good_number'] = $num;
|
||
$where['status'] = array('in', '0,1');
|
||
$info = M('retail_mgoods')->where($where)->field('id')->find();
|
||
if (empty($info)) {
|
||
$res['status'] = 1;
|
||
$res['info'] = $num;
|
||
$res['msg'] = '获取成功';
|
||
$this->ajaxReturn($res);
|
||
break;
|
||
}
|
||
$i++;
|
||
if ($i > 30) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '获取失败，请重试';
|
||
$this->ajaxReturn($res);
|
||
break;
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 自动获取商品类别编码
|
||
*/
|
||
public function atuoGetCode()
|
||
{
|
||
$user = session('ls_userinfo');
|
||
//根据当前门店id查询当前类别code编码最大的一条数据
|
||
$max_code = M('retail_goods_class')->field('code')->where(array('merchantid' => $user['merchantid']))->order('code desc')->limit('1')->find();
|
||
$code = $max_code['code'];
|
||
if (empty($code)) {
|
||
$new_code = '000001';
|
||
} else {
|
||
$new_code = strval($code + 1);
|
||
if ($new_code >= 10) {
|
||
$new_code = '0000' . $new_code;
|
||
} else {
|
||
$new_code = '00000' . $new_code;
|
||
}
|
||
}
|
||
$res['status'] = 1;
|
||
$res['code'] = $new_code;
|
||
$this->ajaxReturn($res);
|
||
}
|
||
|
||
/**
|
||
* 获取分类旧数据
|
||
*/
|
||
public function getCateOldInfo()
|
||
{
|
||
if (IS_POST) {
|
||
$id = $_POST['id'];
|
||
$info = M('retail_goods_class')->where(array('id' => $id))->find();
|
||
if ($info) {
|
||
$res['status'] = 1;
|
||
$res['msg'] = '获取成功';
|
||
$res['info'] = $info;
|
||
} else {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '暂无数据';
|
||
}
|
||
$this->ajaxReturn($res);
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 批量删除商品
|
||
*/
|
||
public function moreDelete()
|
||
{
|
||
if (IS_POST) {
|
||
$ids = $_POST['id'];
|
||
$new_ids = explode(',', trim($ids, ',')); //去除最后的逗号并转换成数组
|
||
// var_dump($new_ids);exit;
|
||
foreach ($new_ids as $key => $value) {
|
||
//循环删除
|
||
$delete = M('retail_goods')->where(array('id' => $value))->setField('status', '2');
|
||
}
|
||
if ($delete) {
|
||
$res['status'] = 1;
|
||
$res['msg'] = '删除成功';
|
||
} else {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '删除失败';
|
||
}
|
||
$this->ajaxReturn($res);
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 删除单个商品
|
||
*/
|
||
public function singleDelete()
|
||
{
|
||
if (IS_POST) {
|
||
$id = I('post.id');
|
||
$goodsInfo = M('retail_mgoods')->where(array('id' => $id))->find();
|
||
if ($goodsInfo) {
|
||
$delete = M('retail_mgoods')->where(array('id' => $id))->setField('status', 2);
|
||
if ($delete) {
|
||
if ($goodsInfo['attribute'] == 2) {
|
||
//规格商品规格状态修改
|
||
M('retail_sku_mgoods')->where(array('mgoods_id' => $id))->setField('state', 1);
|
||
}
|
||
//删除销售库商品
|
||
$success = $this->updateSaleGoods($id, $sku_id = '', 2);
|
||
if ($success) {
|
||
//操作日志记录
|
||
$source = 0; //请求来源： 0pc系统 1小助手
|
||
$type = 3; //平台：1合伙人端 2代理商端 3商户端 4门店端
|
||
$request_data = json_encode($_POST); //请求参数 json数据
|
||
$desc = '商品档案-删除单商品'; //操作行为描述
|
||
action_log($source, $type, $request_data, $desc);
|
||
|
||
$res['status'] = 1;
|
||
$res['msg'] = '删除成功';
|
||
} else {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '商品库存状态删除失败,请刷新重试';
|
||
}
|
||
} else {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '删除失败';
|
||
}
|
||
} else {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '未找到该商品,请刷新重试';
|
||
}
|
||
$this->ajaxReturn($res);
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 批量删除商品类别
|
||
*/
|
||
public function cateDelete()
|
||
{
|
||
if (IS_POST) {
|
||
$cate = M('retail_goods_class');
|
||
$id = I("post.id");
|
||
$type = I("post.type"); //1:删除一级分类 2：删除二级分类
|
||
if (empty($id) || empty($type)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '参数有误,请刷新后重试';
|
||
} else {
|
||
//根据分类的不同 需要进行不同的删除判断操作
|
||
if ($type == 1) {
|
||
//只需判断是否有二级分类正在使用此分类
|
||
$map['pid'] = $id;
|
||
$map['status'] = 0;
|
||
$find = M('retail_goods_class')->where($map)->find();
|
||
if (!empty($find)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '该分类下存在二级分类,无法删除';
|
||
} else {
|
||
$delete = $cate->where(array('id' => $id))->setField('status', 1);
|
||
if ($delete) {
|
||
$res['status'] = 1;
|
||
$res['msg'] = '删除成功';
|
||
} else {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '删除失败';
|
||
}
|
||
}
|
||
} elseif ($type == 2) {
|
||
$where['goods_class_id'] = $id;
|
||
$where['status'] = 0;
|
||
$find = M('retail_mgoods')->where($where)->find();
|
||
$find1 = M('retail_goods')->where($where)->find();
|
||
// echo M()->_sql();exit;
|
||
if (!empty($find) || !empty($find1)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '删除失败,该类别下还有商品存在！';
|
||
} else {
|
||
$delete = $cate->where(array('id' => $id))->setField('status', 1);
|
||
if ($delete) {
|
||
$res['status'] = 1;
|
||
$res['msg'] = '删除成功';
|
||
} else {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '删除失败';
|
||
}
|
||
}
|
||
}
|
||
}
|
||
$this->ajaxReturn($res);
|
||
}
|
||
}
|
||
|
||
//店内出售状态
|
||
public function changeStoreState()
|
||
{
|
||
$content = I('post.');
|
||
$data['operator_type'] = 1;
|
||
$data['user_type'] = 3;
|
||
$data['merchant_id'] = $this->merchant_id;
|
||
$data['goods_id'] = $content['id'];
|
||
$data['retail_state'] = $content['status'];
|
||
$GoodsStateClass = new GoodsState();
|
||
$result = $GoodsStateClass->changeStoreSale($data);
|
||
$this->ajaxReturn($result);
|
||
}
|
||
|
||
// 编辑商城出售状态
|
||
public function changeOnlineState()
|
||
{
|
||
if (IS_POST) {
|
||
$id = I('post.id');
|
||
$ist = I('post.issellonline');
|
||
$ret = M('retail_mgoods')->where(array('merchantid' => $this->merchant_id, 'id' => $id))->save(array('issellonline' => $ist));
|
||
if ($ret) {
|
||
//操作日志记录
|
||
$source = 0; //请求来源： 0pc系统 1小助手
|
||
$type = 3; //平台：1合伙人端 2代理商端 3商户端 4门店端
|
||
$request_data = json_encode($_POST); //请求参数 json数据
|
||
if ($ist == 1) {
|
||
$desc = '商品档案-开启商城出售'; //操作行为描述
|
||
} elseif ($ist == 0) {
|
||
$desc = '商品档案-关闭商城出售'; //操作行为描述
|
||
}
|
||
action_log($source, $type, $request_data, $desc);
|
||
|
||
M('retail_goods')->where(array('m_goods_id' => $id))->save(array('sync_state' => 0));
|
||
$rt['status'] = 1;
|
||
$rt['msg'] = 'ok';
|
||
} else {
|
||
$rt['status'] = 2;
|
||
$rt['msg'] = 'not ok';
|
||
}
|
||
$this->ajaxReturn($rt);
|
||
}
|
||
}
|
||
|
||
|
||
// 编辑上下架状态
|
||
public function changeStatus()
|
||
{
|
||
if (IS_POST) {
|
||
$id = I('post.id');
|
||
$ist = I('post.status');
|
||
$ret = M('retail_mgoods')->where(array('merchantid' => $this->merchant_id, 'id' => $id))->save(array('status' => $ist));
|
||
if ($ret) {
|
||
//操作日志记录
|
||
$source = 0; //请求来源： 0pc系统 1小助手
|
||
$type = 3; //平台：1合伙人端 2代理商端 3商户端 4门店端
|
||
$request_data = json_encode($_POST); //请求参数 json数据
|
||
if ($ist == 1) {
|
||
$desc = '商品档案-商品下架'; //操作行为描述
|
||
} elseif ($ist == 0) {
|
||
$desc = '商品档案-商品上架'; //操作行为描述
|
||
}
|
||
action_log($source, $type, $request_data, $desc);
|
||
|
||
$this->updateSaleGoods($id, $sku_id = "", $ist);
|
||
M('retail_goods')->where(array('m_goods_id' => $id))->save(array('sync_state' => 0));
|
||
$rt['status'] = 1;
|
||
$rt['msg'] = 'ok';
|
||
} else {
|
||
$rt['status'] = 2;
|
||
$rt['msg'] = 'not ok';
|
||
}
|
||
$this->ajaxReturn($rt);
|
||
}
|
||
}
|
||
|
||
|
||
// 编辑会员线上打折状态
|
||
public function changeVipOnlineState()
|
||
{
|
||
if (IS_POST) {
|
||
$id = I('post.id');
|
||
$ist = I('post.vip_online_state');
|
||
$ret = M('retail_mgoods')->where(array('merchantid' => $this->merchant_id, 'id' => $id))->save(array('vip_online_state' => $ist));
|
||
if ($ret) {
|
||
//操作日志记录
|
||
$source = 0; //请求来源： 0pc系统 1小助手
|
||
$type = 3; //平台：1合伙人端 2代理商端 3商户端 4门店端
|
||
$request_data = json_encode($_POST); //请求参数 json数据
|
||
if ($ist == 1) {
|
||
$desc = '商品档案-开启线上打折'; //操作行为描述
|
||
} elseif ($ist == 0) {
|
||
$desc = '商品档案-关闭线上打折'; //操作行为描述
|
||
}
|
||
action_log($source, $type, $request_data, $desc);
|
||
|
||
M('retail_goods')->where(array('m_goods_id' => $id))->save(array('sync_state' => 0));
|
||
$rt['status'] = 1;
|
||
$rt['msg'] = 'ok';
|
||
} else {
|
||
$rt['status'] = 2;
|
||
$rt['msg'] = 'not ok';
|
||
}
|
||
$this->ajaxReturn($rt);
|
||
}
|
||
}
|
||
|
||
// 编辑会员线下打折状态
|
||
public function changeVipRetailState()
|
||
{
|
||
if (IS_POST) {
|
||
$id = I('post.id');
|
||
$ist = I('post.vip_retail_state');
|
||
$ret = M('retail_mgoods')->where(array('merchantid' => $this->merchant_id, 'id' => $id))->save(array('vip_retail_state' => $ist));
|
||
if ($ret) {
|
||
//操作日志记录
|
||
$source = 0; //请求来源： 0pc系统 1小助手
|
||
$type = 3; //平台：1合伙人端 2代理商端 3商户端 4门店端
|
||
$request_data = json_encode($_POST); //请求参数 json数据
|
||
if ($ist == 1) {
|
||
$desc = '商品档案-开启线下打折'; //操作行为描述
|
||
} elseif ($ist == 0) {
|
||
$desc = '商品档案-关闭线下打折'; //操作行为描述
|
||
}
|
||
action_log($source, $type, $request_data, $desc);
|
||
|
||
M('retail_goods')->where(array('m_goods_id' => $id))->save(array('sync_state' => 0));
|
||
$rt['status'] = 1;
|
||
$rt['msg'] = 'ok';
|
||
} else {
|
||
$rt['status'] = 2;
|
||
$rt['msg'] = 'not ok';
|
||
}
|
||
$this->ajaxReturn($rt);
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 规格或非规格导出
|
||
*/
|
||
public function SkuMGoodsExport()
|
||
{
|
||
ini_set('memory_limit', -1);
|
||
ini_set('max_execution_time', '60');
|
||
$data = I('post.');
|
||
$searchForm = $data['searchForm'];
|
||
unset($data['searchForm']);
|
||
$data['operator_type'] = 1;
|
||
$data['user_type'] = 3;
|
||
$data['merchant_id'] = $this->merchant_id;
|
||
$data['platform_type'] = $this->role_info['platform_type'] ? $this->role_info['platform_type'] : 1;
|
||
$data['searchText'] = $searchForm['keyword'];
|
||
$data['keyword_type'] = $searchForm['keyword_type'];
|
||
$data['pricing_method'] = $searchForm['can_exchange_weigh'];
|
||
$data['condition_name'] = $searchForm['condition_name'];
|
||
$data['order_type'] = $searchForm['order_type'];
|
||
$data['person1'] = $searchForm['person1'];
|
||
$data['person2'] = $searchForm['person2'];
|
||
$data['person3'] = $searchForm['person3'];
|
||
$data['status'] = $searchForm['status'];
|
||
$GoodsClass = new Goods();
|
||
$result = $GoodsClass->exportGoods($data);
|
||
$this->ajaxReturn($result);
|
||
}
|
||
|
||
|
||
//下载文件
|
||
public function exportFile()
|
||
{
|
||
$attribute_state = I('get.attribute_state');
|
||
if ($attribute_state == 2) {
|
||
$file_name = '规格商品导出';
|
||
} else {
|
||
$file_name = '非规格商品导出';
|
||
}
|
||
$DownFileClass = new DownFile();
|
||
$DownFileClass->downFile([
|
||
'file_path' => I('get.file_path'),
|
||
'file_name' => $file_name,
|
||
'file_type' => '.xls'
|
||
]);
|
||
}
|
||
|
||
|
||
//导出方法
|
||
private function getExcel($expTitle, $expCellName, $expTableData, $str = "")
|
||
{
|
||
|
||
$xlsTitle = iconv('utf-8', 'gb2312', $expTitle); //文件名称
|
||
$fileName = $expTitle . date('_YmdHis'); //or $xlsTitle 文件名称可根据自己情况设定
|
||
$cellNum = count($expCellName);
|
||
$dataNum = count($expTableData);
|
||
$common = $str;
|
||
vendor("PHPExcel.PHPExcel");
|
||
ob_clean();
|
||
$objPHPExcel = new \PHPExcel();
|
||
$cellName = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI', 'AJ', 'AK', 'AL', 'AM', 'AN', 'AO', 'AP', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AV', 'AW', 'AX', 'AY', 'AZ');
|
||
|
||
$objPHPExcel->getActiveSheet(0)->mergeCells('A1:' . $cellName[$cellNum - 1] . '1'); //合并单元格
|
||
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $common);
|
||
// $objPHPExcel->setActiveSheetIndex(1)->setCellValue('A1', $str);
|
||
for ($i = 0; $i < $cellNum; $i++) {
|
||
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i] . '2', $expCellName[$i][1]);
|
||
}
|
||
|
||
for ($i = 0; $i < $dataNum; $i++) {
|
||
for ($j = 0; $j < $cellNum; $j++) {
|
||
$objPHPExcel->getActiveSheet(0)->setCellValue($cellName[$j] . ($i + 3), ' ' . $expTableData[$i][$expCellName[$j][0]]);
|
||
}
|
||
}
|
||
foreach ($cellName as $value) {
|
||
$objPHPExcel->getActiveSheet()->getColumnDimension($value)->setWidth(20);
|
||
}
|
||
header('pragma:public');
|
||
header('Content-type:application/vnd.ms-excel;charset=utf-8;name="' . $xlsTitle . '.xls"');
|
||
header("Content-Disposition:attachment;filename=$fileName.xls"); //attachment新窗口打印inline本窗口打印
|
||
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
|
||
$objWriter->save('php://output');
|
||
exit();
|
||
}
|
||
|
||
// 批量删除
|
||
public function batch_del()
|
||
{
|
||
if (IS_POST) {
|
||
$del_data = I('post.del_data');
|
||
if (!empty($del_data)) {
|
||
$Mgoods = M('retail_mgoods');
|
||
foreach ($del_data as $key => &$val) {
|
||
$del_res = $Mgoods->where(array('id' => $val['id']))->setField('status', 2);
|
||
if (empty($del_res)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '有商品删除失败，请重新提交！';
|
||
$this->ajaxReturn($res);
|
||
}
|
||
if ($val['attribute'] == 2) {
|
||
//规格商品状态修改
|
||
M('retail_sku_mgoods')->where(array('mgoods_id' => $val['id']))->setField('state', 1);
|
||
}
|
||
$success = $this->updateSaleGoods($val['id'], $sku_id = "", 2);
|
||
}
|
||
|
||
//操作日志记录
|
||
$source = 0; //请求来源： 0pc系统 1小助手
|
||
$type = 3; //平台：1合伙人端 2代理商端 3商户端 4门店端
|
||
$request_data = json_encode($_POST); //请求参数 json数据
|
||
$desc = '商品档案-批量删除商品'; //操作行为描述
|
||
action_log($source, $type, $request_data, $desc);
|
||
|
||
$res['status'] = 1;
|
||
$res['msg'] = '删除成功！';
|
||
} else {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '无删除数据';
|
||
}
|
||
$this->ajaxReturn($res);
|
||
}
|
||
}
|
||
|
||
/*
|
||
* 批量更换商品分类
|
||
* */
|
||
public function move_class()
|
||
{
|
||
$user = session('ls_userinfo');
|
||
//查询出该门店可用分类
|
||
$merchantid = $user['merchantid'];
|
||
$class_name = M('retail_goods_class')->where(array('merchantid' => $merchantid, 'status' => 0, 'type' => 1))->order('code asc')->select();
|
||
$this->assign('class_name', $class_name);
|
||
$this->display();
|
||
}
|
||
|
||
public function goodsMoveList()
|
||
{
|
||
$user = session('ls_userinfo');
|
||
//接收查询条件
|
||
$keyword = I('get.keyword');
|
||
if (!empty($keyword)) {
|
||
$keyword = trim($keyword, ' ');
|
||
$where['g.goods_name|g.good_number|g.goods_code'] = array('like', '%' . $keyword . '%');
|
||
}
|
||
//按照商品类别搜索
|
||
$person1 = I('get.person1');
|
||
$person2 = I('get.person2');
|
||
$person3 = I('get.person3');
|
||
$flag = 0;
|
||
if (!empty($person3)) {
|
||
$where['g.goods_class_id'] = $person3;
|
||
} else if (!empty($person2)) {
|
||
$class = M('retail_goods_class as c2')
|
||
->join('ls_retail_goods_class as c3 on c2.id=c3.pid')
|
||
->where(array('c2.id' => $person2, 'c3.status' => 0))
|
||
->field('c3.id')->select();
|
||
$flag = 1;
|
||
} else if (!empty($person1)) {
|
||
$class = M('retail_goods_class as c1')
|
||
->join('ls_retail_goods_class as c2 on c1.id=c2.pid')
|
||
->join('ls_retail_goods_class as c3 on c2.id=c3.pid AND c3.status=0', 'LEFT')
|
||
->where(array('c1.id' => $person1, 'c2.status' => 0))
|
||
->field('c2.id,c3.id as c3_id')->select();
|
||
$flag = 1;
|
||
}
|
||
if (!empty($class)) {
|
||
$arr = array();
|
||
foreach ($class as &$val) {
|
||
if (!in_array($val['id'], $arr)) {
|
||
$arr[] = $val['id'];
|
||
}
|
||
if (!empty($val['c3_id'])) {
|
||
if (!in_array($val['c3_id'], $arr)) {
|
||
$arr[] = $val['c3_id'];
|
||
}
|
||
}
|
||
}
|
||
$str = implode(',', $arr);
|
||
$where['g.goods_class_id'] = array('in', $str . ',' . ($person2 ? $person2 : $person1));
|
||
} else if ($flag == 1) {
|
||
$where['g.goods_class_id'] = $person2 ? $person2 : $person1;
|
||
}
|
||
$where['g.merchantid'] = $user['merchantid'];
|
||
$where['g.status'] = array('in', '0,1');
|
||
$goods_count = M('retail_mgoods as g')->where($where)->count();
|
||
$goods = M('retail_mgoods as g')
|
||
->join('ls_retail_goods_class as c on c.id=g.goods_class_id')
|
||
->where($where)->page($_GET['page'], $_GET['limit'])
|
||
->order('g.good_number desc')
|
||
->field('g.goods_name,g.good_number,g.goods_code,g.id,c.class_name,c.id as c_id,c.pid,c.type,c.class_name')
|
||
->select();
|
||
foreach ($goods as &$val) {
|
||
if ($val['type'] == 2) {
|
||
$class1 = M('retail_goods_class')->where(array('id' => $val['pid']))->getField('class_name');
|
||
$val['class_name'] = $class1 . '/' . $val['class_name'];
|
||
} else if ($val['type'] == 3) {
|
||
$class1 = M('retail_goods_class as c1')
|
||
->join('ls_retail_goods_class as c2 on c2.pid=c1.id')
|
||
->where(array('c2.id' => $val['pid']))
|
||
->field('c1.class_name,c2.class_name as c2_class_name')
|
||
->find();
|
||
$val['class_name'] = $class1['class_name'] . '/' . $class1['c2_class_name'] . '/' . $val['class_name'];
|
||
}
|
||
}
|
||
$rt['code'] = 0;
|
||
$rt['msg'] = '';
|
||
$rt['count'] = $goods_count;
|
||
$rt['data'] = $goods;
|
||
$this->ajaxReturn($rt);
|
||
}
|
||
|
||
//批量修改商品分类
|
||
public function moveGoodsClass()
|
||
{
|
||
$user = session('ls_userinfo');
|
||
$goodsIds = I('post.goodsIds');
|
||
$class_id = I('post.class_id');
|
||
if (empty($goodsIds) || empty($class_id)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '缺少参数';
|
||
$this->ajaxReturn($res);
|
||
}
|
||
$class = M('retail_goods_class as c')
|
||
->join('ls_retail_goods_class as c1 on c1.pid=c.id AND c1.status=0', 'LEFT')
|
||
->where(array('c.id' => $class_id, 'c.status' => 0))
|
||
->field('c.*,c1.id as c1_id')
|
||
->select();
|
||
if (empty($class)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '分类不存在';
|
||
} else if (!empty($class['c1_id'])) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '请选择到底级分类';
|
||
} else {
|
||
$update = M('retail_mgoods')->where(array('id' => array('in', $goodsIds), 'merchantid' => $user['merchantid']))->save(array('goods_class_id' => $class_id));
|
||
if ($update) {
|
||
//供给仓分类修改
|
||
$this->moveSaleClass($goodsIds, $class_id);
|
||
}
|
||
$updateGoods = M('retail_goods')->where(array('m_goods_id' => array('in', $goodsIds), 'sync_state' => 1))->save(array('sync_state' => 0));
|
||
if ($update) {
|
||
//操作日志记录
|
||
$source = 0; //请求来源： 0pc系统 1小助手
|
||
$type = 3; //平台：1合伙人端 2代理商端 3商户端 4门店端
|
||
$request_data = json_encode($_POST); //请求参数 json数据
|
||
$desc = '商品档案-批量修改分类'; //操作行为描述
|
||
action_log($source, $type, $request_data, $desc);
|
||
|
||
$res['status'] = 1;
|
||
$res['msg'] = '修改成功';
|
||
} else {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '修改失败请重试';
|
||
}
|
||
}
|
||
$this->ajaxReturn($res);
|
||
}
|
||
|
||
/**
|
||
* 供给仓批量修改分类
|
||
* @param $goodsIds 商品id
|
||
* @param $class_id 分类id
|
||
*
|
||
*/
|
||
protected function moveSaleClass($goodsIds, $class_id)
|
||
{
|
||
$merchant_id = session("merchant_userinfo")['id'];
|
||
if (!empty($goodsIds) && !empty($class_id)) {
|
||
$where = array(
|
||
'merchant_id' => $merchant_id,
|
||
'goods_id' => array('in', $goodsIds),
|
||
);
|
||
$data = array(
|
||
'goods_class_id' => $class_id
|
||
);
|
||
$save = D("SaleMGoods")->updateData($where, $data);
|
||
}
|
||
return $save;
|
||
}
|
||
|
||
/* 批量修改 */
|
||
public function updateMGoods($id)
|
||
{
|
||
$ids = trim($id, ',');
|
||
$this->assign('ids', $ids);
|
||
$this->display();
|
||
}
|
||
|
||
//修改的商品信息
|
||
public function edit_getPrice()
|
||
{
|
||
$ids = I('post.ids');
|
||
$id = explode(",", $ids);
|
||
$data = array();
|
||
foreach ($id as $k => $v) {
|
||
$data[$k] = M("retail_mgoods")
|
||
->where(array('id' => $v))
|
||
->field('id,good_number,goods_name,goods_code,purch_price,retail_price,online_price,goods_num,can_exchange_weigh,shop_mem_status,shop_mem_price')
|
||
->find();
|
||
if (intval($data[$k]['goods_num']) == $data[$k]['goods_num']) { // 非kg商品
|
||
$data[$k]['goods_num'] = intval($data[$k]['goods_num']);
|
||
}
|
||
$data[$k]['shop_mem_price'] = $data[$k]['shop_mem_status'] == 1 ? $data[$k]['shop_mem_price'] : '未开启商城会员价';
|
||
}
|
||
$this->ajaxReturn(array('code' => 0, 'data' => $data));
|
||
}
|
||
|
||
//执行批量修改商品价格
|
||
public function edit_Price()
|
||
{
|
||
$user = session('ls_userinfo');
|
||
$data = I('post.list');
|
||
$good_numbereError = array();
|
||
$goods_codesError = array();
|
||
foreach ($data as $k => $v) {
|
||
//判断货号是否存在
|
||
$good_number = M('retail_mgoods')->where(array('merchantid' => $user['merchantid'], 'good_number' => $v['good_number'], 'id' => array('neq', $v['id'])))->find();
|
||
if (!empty($good_number)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = "第" . ($k + 1) . "条《货号》（" . $v['good_number'] . "）已存在,修改失败；<br/>";
|
||
$this->ajaxReturn($res);
|
||
}
|
||
//判断商品条码是否存在
|
||
if ($v['goods_code'] != '') {
|
||
$goods_code = M('retail_mgoods')->where(array('merchantid' => $user['merchantid'], 'goods_code' => $v['goods_code'], 'id' => array('neq', $v['id'])))->find();
|
||
if (!empty($goods_code)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = "第" . ($k + 1) . "条《商品条码》（" . $v['good_number'] . "）已存在,修改失败；<br/>";
|
||
$this->ajaxReturn($res);
|
||
}
|
||
}
|
||
if ($good_numbereError[$k] == '' && $goods_codesError[$k] == '') {
|
||
$id = $v['id'];
|
||
$list['good_number'] = $v['good_number'];
|
||
$list['goods_name'] = $v['goods_name'];
|
||
$list['goods_code'] = $v['goods_code'];
|
||
$list['purch_price'] = $v['purch_price'];
|
||
$list['retail_price'] = $v['retail_price'];
|
||
$list['online_price'] = $v['online_price'];
|
||
$list['goods_num'] = $v['goods_num'];
|
||
$list['can_exchange_weigh'] = $v['can_exchange_weigh'];
|
||
$list['shop_mem_price'] = $v['shop_mem_status'] == 1 ? $v['shop_mem_price'] : null;
|
||
$mgoods = M('retail_mgoods')->where(array('id' => $id))->find();
|
||
if ($mgoods['good_number'] != $list['good_number'] || $mgoods['goods_name'] != $list['goods_name'] || $mgoods['goods_code'] != $list['goods_code'] || $mgoods['purch_price'] != $list['purch_price'] || $mgoods['online_price'] != $list['online_price'] || $mgoods['retail_price'] != $list['retail_price'] || $mgoods['goods_num'] != $list['goods_num'] || $mgoods['shop_mem_price'] != $list['shop_mem_price'] || $mgoods['can_exchange_weigh'] != $list['can_exchange_weigh']) {
|
||
$edit = M("retail_mgoods")->where(array('id' => $id))->save($list);
|
||
if ($edit) {
|
||
$edit_Success[$k] = "修改成功";
|
||
$mgoods_id[$k] = $id;
|
||
} else {
|
||
$edit_Error[$k] = "第" . ($k + 1) . "条商品信息修改失败；<br/>";
|
||
}
|
||
}
|
||
}
|
||
}
|
||
if (!empty($edit_Success)) {
|
||
$edits = M('retail_goods')->where(array('mgoodsid' => array('in', $mgoods_id)))->save(array('sync_two' => 0));
|
||
}
|
||
if (empty($good_numbereError) && empty($goods_codesError) && empty($edit_Error) || !empty($edit_Success)) {
|
||
$res['status'] = 1;
|
||
$res['msg'] = "修改成功";
|
||
} elseif (!empty($good_numbereError) || !empty($goods_codesError) || !empty($edit_Error)) {
|
||
$numbereError = "";
|
||
foreach ($good_numbereError as $k => $v) {
|
||
$numbereError .= $v;
|
||
}
|
||
$codesError = "";
|
||
foreach ($goods_codesError as $k => $v) {
|
||
$codesError .= $v;
|
||
}
|
||
$priceError = "";
|
||
foreach ($edit_Error as $k => $v) {
|
||
$priceError .= $v;
|
||
}
|
||
$res['status'] = 0;
|
||
$res['msg'] = $numbereError . $codesError . $priceError;
|
||
} else {
|
||
$res['status'] = 2;
|
||
$res['msg'] = "商品信息未修改";
|
||
}
|
||
$this->ajaxReturn($res);
|
||
}
|
||
|
||
//删除轮播图
|
||
public function delMGoodsBanner()
|
||
{
|
||
$user = session('ls_userinfo');
|
||
$id = I('post.id');
|
||
$gid = I('post.gid');
|
||
if (empty($id) || empty($gid) || empty($user)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = "缺少参数";
|
||
$this->ajaxReturn($res);
|
||
}
|
||
$map['merchantid'] = $user['merhcantid'];
|
||
$map['id'] = $id;
|
||
$map['mgoods_id'] = $gid;
|
||
$banner = M('retail_mgoods_banner')->where($map)->find();
|
||
if (empty($banner)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = "轮播图有误";
|
||
} else {
|
||
$del = M('retail_mgoods_banner')->where($map)->delete();
|
||
if ($del) {
|
||
$res['status'] = 1;
|
||
$res['msg'] = "删除成功";
|
||
} else {
|
||
$res['status'] = 0;
|
||
$res['msg'] = "服务器出差了";
|
||
}
|
||
}
|
||
$this->ajaxReturn($res);
|
||
}
|
||
|
||
public function getAutoGoodsCode()
|
||
{
|
||
$merchantid = session('ls_userinfo')['merchantid'];
|
||
$code = '';
|
||
while (1) {
|
||
$code = rand(1000000000, 9999999999);
|
||
$map = array('merhcantid' => $merchantid, 'status' => array('in', '0,1'), 'goods_code' => $code);
|
||
$old1 = M('retail_mgoods')->where($map)->find();
|
||
if (!empty($old1)) {
|
||
continue;
|
||
}
|
||
$map = array('merhcant_id' => $merchantid, 'status' => array('in', '0,1'), 'goods_code' => $code);
|
||
$old2 = M('retail_goods')->where($map)->find();
|
||
if (!empty($old2)) {
|
||
continue;
|
||
}
|
||
$map1 = array('merhcantid' => $merchantid, 'state' => 0, 'sku_code' => $code);
|
||
$old3 = M('retail_sku_mgoods')->where($map1)->find();
|
||
if (!empty($old3)) {
|
||
continue;
|
||
}
|
||
$map1 = array('merhcant_id' => $merchantid, 'state' => 0, 'sku_code' => $code);
|
||
$old4 = M('retail_sku_goods')->where($map1)->find();
|
||
if (!empty($old4)) {
|
||
continue;
|
||
}
|
||
break;
|
||
}
|
||
$res['status'] = 1;
|
||
$res['msg'] = '获取成功';
|
||
$res['code'] = $code;
|
||
$this->ajaxReturn($res);
|
||
}
|
||
|
||
|
||
/* 获取批量修改的商品
|
||
* @ids 商品id
|
||
* @return Array
|
||
* 新版2019-7-15
|
||
* */
|
||
public function get_update_mgoods_list()
|
||
{
|
||
$user = I('session.ls_userinfo');
|
||
$ids = I('post.ids');
|
||
if (!$ids) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '参数缺失';
|
||
$this->ajaxReturn($res);
|
||
}
|
||
$map['id'] = array('in', $ids);
|
||
$map['merchantid'] = $user['merchantid'];
|
||
$mgoods_list = M('retail_mgoods')->field('id,goods_name,good_number,goods_code,purch_price,retail_price,online_price,store_mem_status,store_mem_price,shop_mem_status,shop_mem_price,can_exchange_weigh,attribute,plus_price,plus_mem_status')->where($map)->select();
|
||
if (!$mgoods_list) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '未查询到修改数据';
|
||
$this->ajaxReturn($res);
|
||
}
|
||
foreach ($mgoods_list as &$val) {
|
||
$where = array();
|
||
$where['merchant_id'] = $user['merchantid'];
|
||
$where['goods_id'] = $val['id'];
|
||
$where['status'] = array('in', '0,1');
|
||
if ($val['attribute'] == 2) {
|
||
$val['purch_price'] = "规格成本价";
|
||
$goods_num = D('SaleMGoods')->getSum($where, "goods_num");
|
||
} else {
|
||
$val['purch_price'] = floatval($val['purch_price']);
|
||
$goods_num = D('SaleMGoods')->getFindField($where, "goods_num");
|
||
}
|
||
$goods_num = $goods_num ? $goods_num : 0;
|
||
$val['goods_num'] = round($goods_num, 3);
|
||
$val['retail_price'] = floatval($val['retail_price']);
|
||
$val['online_price'] = floatval($val['online_price']);
|
||
$val['store_mem_price'] = floatval($val['store_mem_price']);
|
||
$val['shop_mem_price'] = floatval($val['shop_mem_price']);
|
||
$val['plus_price'] = floatval($val['plus_price']);
|
||
$val['attribute_name'] = $val['attribute'] == 1 ? '无规格' : '有规格';
|
||
}
|
||
$res['status'] = 1;
|
||
$res['mgoods_list'] = $mgoods_list;
|
||
$this->ajaxReturn($res);
|
||
}
|
||
|
||
/* 批量修改商品数据
|
||
* @goods_list Array
|
||
* @return Array
|
||
* */
|
||
public function batch_save_mgoods()
|
||
{
|
||
$merchant_id = session("merchant_userinfo")['id'];
|
||
$mgoods_list = I('post.mgoods_list');
|
||
if (!$mgoods_list) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '参数缺失';
|
||
$this->ajaxReturn($res);
|
||
}
|
||
$msg = '';
|
||
$msg_code = '';
|
||
$msg_goods_num = '';
|
||
$msg_sku_weigh = '';
|
||
$numberArr = array();
|
||
$codeArr = array();
|
||
$reg1 = "/^\+?[0-9][0-9]*$/";
|
||
$reg2 = "/^[0-9]+(.[0-9]{1,3})?$/";
|
||
foreach ($mgoods_list as $key => &$val) {
|
||
$find = M('retail_mgoods')->where(array('good_number' => $val['good_number'], 'merchantid' => $merchant_id, 'status' => array('neq', 2), 'id' => array('neq', $val['id'])))->find();
|
||
if ($find || in_array($val['good_number'], $numberArr)) {
|
||
$msg .= ($key + 1) . ',';
|
||
} else {
|
||
$numberArr[] = $val['good_number'];
|
||
}
|
||
unset($find);
|
||
if (!empty($val['goods_code'])) {
|
||
$find = M('retail_mgoods')->where(array('goods_code' => $val['goods_code'], 'merchantid' => $merchant_id, 'status' => array('neq', 2), 'id' => array('neq', $val['id'])))->find();
|
||
if ($find || in_array($val['goods_code'], $codeArr)) {
|
||
$msg_code .= ($key + 1) . ',';
|
||
} else {
|
||
$codeArr[] = $val['goods_code'];
|
||
}
|
||
unset($find);
|
||
}
|
||
if ($val['can_exchange_weigh'] == 2 && !preg_match($reg2, abs($val['goods_num']))) {
|
||
$msg_goods_num .= ($key + 1) . ',';
|
||
} else if ($val['can_exchange_weigh'] == 1 && !preg_match($reg1, abs($val['goods_num']))) {
|
||
$msg_goods_num .= ($key + 1) . ',';
|
||
}
|
||
if ($val['attribute'] == 2 && $val['can_exchange_weigh'] == 2) {
|
||
$msg_sku_weigh .= ($key + 1) . ',';
|
||
}
|
||
}
|
||
if (trim($msg, ',')) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '第' . trim($msg, ',') . '条商品货号已存在';
|
||
$this->ajaxReturn($res);
|
||
}
|
||
if (trim($msg_code, ',')) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '第' . trim($msg_code, ',') . '条商品条码已存在';
|
||
$this->ajaxReturn($res);
|
||
}
|
||
if (!empty($msg_goods_num)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '第' . trim($msg_goods_num, ',') . '条商品库存与称重属性不符';
|
||
$this->ajaxReturn($res);
|
||
}
|
||
if (!empty($msg_sku_weigh)) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '第' . trim($msg_sku_weigh, ',') . '条商品规格与称重不能同时开启';
|
||
$this->ajaxReturn($res);
|
||
}
|
||
$result = $this->batch_update_mgoods($mgoods_list);
|
||
if ($result['status'] == 1) {
|
||
//操作日志记录
|
||
$source = 0; //请求来源： 0pc系统 1小助手
|
||
$type = 3; //平台：1合伙人端 2代理商端 3商户端 4门店端
|
||
$request_data = json_encode($_POST); //请求参数 json数据
|
||
$desc = '商品档案-批量修改商品'; //操作行为描述
|
||
action_log($source, $type, $request_data, $desc);
|
||
|
||
$res['status'] = 1;
|
||
$res['msg'] = $result['msg'];
|
||
} else {
|
||
$res['status'] = 0;
|
||
$res['msg'] = $result['msg'];
|
||
}
|
||
$this->ajaxReturn($res);
|
||
}
|
||
|
||
/* 批量修改商品数据7-12
|
||
* @goods_list Array
|
||
* @return Array
|
||
* */
|
||
protected function batch_update_mgoods($mgoods_list)
|
||
{
|
||
$record = 0;
|
||
foreach ($mgoods_list as $key => &$val) {
|
||
$find = M('retail_mgoods')->where(array('id' => $val['id']))->find();
|
||
if (!$find) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '第' . ($key + 1) . '条查询失败';
|
||
return $res;
|
||
}
|
||
if ($val['goods_name'] != $find['goods_name']) {
|
||
$up['goods_name'] = $val['goods_name'];
|
||
$content['goods_name'] = $val['goods_name'];
|
||
}
|
||
if ($val['good_number'] != $find['good_number']) {
|
||
$up['good_number'] = $val['good_number'];
|
||
$content['goods_number'] = $val['good_number'];
|
||
}
|
||
if ($val['goods_code'] != $find['goods_code']) {
|
||
$up['goods_code'] = $val['goods_code'];
|
||
$content['goods_code'] = $val['goods_code'];
|
||
}
|
||
if ($val['can_exchange_weigh'] != $find['can_exchange_weigh']) {
|
||
$up['can_exchange_weigh'] = $val['can_exchange_weigh'];
|
||
$content['pricing_method'] = $val['can_exchange_weigh'];
|
||
}
|
||
if ($val['retail_price'] != $find['retail_price']) {
|
||
$up['retail_price'] = round($val['retail_price'], 2);
|
||
}
|
||
if ($val['online_price'] != $find['online_price']) {
|
||
$up['online_price'] = round($val['online_price'], 2);
|
||
}
|
||
if ($val['store_mem_status'] != $find['store_mem_status']) {
|
||
$up['store_mem_status'] = $val['store_mem_status'];
|
||
}
|
||
if ($val['store_mem_price'] != $find['store_mem_price']) {
|
||
$up['store_mem_price'] = round($val['store_mem_price'], 2);
|
||
}
|
||
if ($val['shop_mem_status'] != $find['shop_mem_status']) {
|
||
$up['shop_mem_status'] = $val['shop_mem_status'];
|
||
}
|
||
if ($val['shop_mem_price'] != $find['shop_mem_price']) {
|
||
$up['shop_mem_price'] = round($val['shop_mem_price'], 2);
|
||
}
|
||
if ($val['plus_mem_status'] != $find['plus_mem_status']) {
|
||
$up['plus_mem_status'] = $val['plus_mem_status'];
|
||
}
|
||
if ($val['plus_price'] != $find['plus_price']) {
|
||
$up['plus_price'] = $val['plus_price'];
|
||
}
|
||
if ($content) {
|
||
$where = array();
|
||
$where['goods_id'] = $val['id'];
|
||
$where['status'] = array('in', '0,1');
|
||
D('SaleMGoods')->updateData($where, $content);
|
||
unset($where['status']);
|
||
$where['type'] = 5; //初始化入库
|
||
D('WarehousingGoods')->updateData($where, $content);
|
||
unset($content);
|
||
}
|
||
if ($up) {
|
||
$record += 1;
|
||
$save = M('retail_mgoods')->where(array('id' => $val['id']))->save($up);
|
||
if (!$save) {
|
||
$res['status'] = 0;
|
||
$res['msg'] = '第' . ($key + 1) . '条修改失败';
|
||
return $res;
|
||
}
|
||
unset($save);
|
||
unset($up);
|
||
}
|
||
$this->sync_two($find['id']);
|
||
unset($find);
|
||
}
|
||
$res['status'] = 1;
|
||
$res['msg'] = $record > 0 ? '修改成功' : '请先修改数据再提交';
|
||
return $res;
|
||
}
|
||
|
||
/*
|
||
* **************************************************库存模块***************************************
|
||
*/
|
||
public function warning()
|
||
{
|
||
$merchantid = session('ls_userinfo')['merchantid'];
|
||
$where['merchantid'] = $merchantid;
|
||
$where['status'] = 0;
|
||
$where['type'] = 1;
|
||
$class_name = M('retail_goods_class')->where($where)->order('code asc')->select();
|
||
$this->assign('class_name', $class_name);
|
||
$this->display();
|
||
}
|
||
|
||
public function warning_list()
|
||
{
|
||
$merchantid = session("ls_userinfo")['merchantid'];
|
||
$p = I('get.page');
|
||
$l = I('get.limit');
|
||
$good_number = I('get.good_number');
|
||
//按照商品类别搜索
|
||
$person1 = I('get.person1');
|
||
$person2 = I('get.person2');
|
||
$person3 = I('get.person3');
|
||
if (!empty($good_number)) {
|
||
$where['m.good_number|m.goods_name'] = $good_number;
|
||
}
|
||
$flag = 0;
|
||
if (!empty($person3)) {
|
||
$where['m.goods_class_id'] = $person3;
|
||
} else if (!empty($person2)) {
|
||
$class = M('retail_goods_class as c2')
|
||
->join('ls_retail_goods_class as c3 on c2.id=c3.pid')
|
||
->where(array('c2.id' => $person2, 'c3.status' => 0))
|
||
->field('c3.id')->select();
|
||
$flag = 1;
|
||
} else if (!empty($person1)) {
|
||
$class = M('retail_goods_class as c1')
|
||
->join('ls_retail_goods_class as c2 on c1.id=c2.pid')
|
||
->join('ls_retail_goods_class as c3 on c2.id=c3.pid AND c3.status=0', 'LEFT')
|
||
->where(array('c1.id' => $person1, 'c2.status' => 0))
|
||
->field('c2.id,c3.id as c3_id')->select();
|
||
$flag = 1;
|
||
}
|
||
if (!empty($class)) {
|
||
$arr = array();
|
||
foreach ($class as &$val) {
|
||
if (!in_array($val['id'], $arr)) {
|
||
$arr[] = $val['id'];
|
||
}
|
||
if (!empty($val['c3_id'])) {
|
||
if (!in_array($val['c3_id'], $arr)) {
|
||
$arr[] = $val['c3_id'];
|
||
}
|
||
}
|
||
}
|
||
$str = implode(',', $arr);
|
||
$where['m.goods_class_id'] = array('in', $str . ',' . ($person2 ? $person2 : $person1));
|
||
} else if ($flag == 1) {
|
||
$where['m.goods_class_id'] = $person2 ? $person2 : $person1;
|
||
}
|
||
$where['m.merchantid'] = $merchantid;
|
||
$where['m.status'] = array('in', '0,1');
|
||
$mgoods_info = M('retail_mgoods as m')
|
||
->join('ls_retail_mgoods as r on r.id=m.id', "LEFT")
|
||
->where($where)
|
||
->where('m.goods_num < m.less_num')
|
||
->page($p, $l)
|
||
->order('m.status asc')
|
||
->select();
|
||
$count = M('retail_mgoods as m')
|
||
->join('ls_retail_mgoods as r on r.id=m.id', "LEFT")
|
||
->where($where)
|
||
->where('m.goods_num < m.less_num')
|
||
->count();
|
||
if ($mgoods_info) {
|
||
foreach ($mgoods_info as $key => &$val) {
|
||
$val['index'] = $key + 1;
|
||
if ($val['status'] == 0) {
|
||
$val['status_name'] = '正常';
|
||
} else if ($val['status'] == 1) {
|
||
$val['status_name'] = '下架';
|
||
}
|
||
if ($val['attribute'] == 2) {
|
||
$val['average_purch_price'] = '规格价';
|
||
$val['purch_price'] = '规格价';
|
||
$val['retail_price'] = '规格价';
|
||
}
|
||
$val['cate_name'] = M('retail_goods_class')->where(array('id' => $val['goods_class_id']))->getField('class_name');
|
||
}
|
||
}
|
||
$res['status'] = 1;
|
||
$res['code'] = 0;
|
||
$res['msg'] = '';
|
||
$res['data'] = $mgoods_info;
|
||
$this->ajaxReturn($res);
|
||
}
|
||
|
||
public function warning_list_export()
|
||
{
|
||
$merchantid = session("ls_userinfo")['merchantid'];
|
||
$good_number = I('get.good_number');
|
||
//按照商品类别搜索
|
||
$person1 = I('get.person1');
|
||
$person2 = I('get.person2');
|
||
$person3 = I('get.person3');
|
||
if (!empty($good_number)) {
|
||
$where['m.good_number|m.goods_name'] = $good_number;
|
||
}
|
||
$flag = 0;
|
||
if (!empty($person3)) {
|
||
$where['m.goods_class_id'] = $person3;
|
||
} else if (!empty($person2)) {
|
||
$class = M('retail_goods_class as c2')
|
||
->join('ls_retail_goods_class as c3 on c2.id=c3.pid')
|
||
->where(array('c2.id' => $person2, 'c3.status' => 0))
|
||
->field('c3.id')->select();
|
||
$flag = 1;
|
||
} else if (!empty($person1)) {
|
||
$class = M('retail_goods_class as c1')
|
||
->join('ls_retail_goods_class as c2 on c1.id=c2.pid')
|
||
->join('ls_retail_goods_class as c3 on c2.id=c3.pid AND c3.status=0', 'LEFT')
|
||
->where(array('c1.id' => $person1, 'c2.status' => 0))
|
||
->field('c2.id,c3.id as c3_id')->select();
|
||
$flag = 1;
|
||
}
|
||
if (!empty($class)) {
|
||
$arr = array();
|
||
foreach ($class as &$val) {
|
||
if (!in_array($val['id'], $arr)) {
|
||
$arr[] = $val['id'];
|
||
}
|
||
if (!empty($val['c3_id'])) {
|
||
if (!in_array($val['c3_id'], $arr)) {
|
||
$arr[] = $val['c3_id'];
|
||
}
|
||
}
|
||
}
|
||
$str = implode(',', $arr);
|
||
$where['m.goods_class_id'] = array('in', $str . ',' . ($person2 ? $person2 : $person1));
|
||
} else if ($flag == 1) {
|
||
$where['m.goods_class_id'] = $person2 ? $person2 : $person1;
|
||
}
|
||
$where['m.merchantid'] = $merchantid;
|
||
$where['m.status'] = array('in', '0,1');
|
||
$mgoods_info = M('retail_mgoods as m')
|
||
->join('ls_retail_mgoods as r on r.id=m.id', "LEFT")
|
||
->where($where)
|
||
->where('m.goods_num < m.less_num')
|
||
->order('m.status asc')
|
||
->select();
|
||
if ($mgoods_info) {
|
||
foreach ($mgoods_info as $key => &$val) {
|
||
$val['index'] = $key + 1;
|
||
if ($val['status'] == 0) {
|
||
$val['status_name'] = '正常';
|
||
} else if ($val['status'] == 1) {
|
||
$val['status_name'] = '下架';
|
||
}
|
||
if ($val['attribute'] == 2) {
|
||
$val['average_purch_price'] = '规格价';
|
||
$val['purch_price'] = '规格价';
|
||
$val['retail_price'] = '规格价';
|
||
}
|
||
$val['cate_name'] = M('retail_goods_class')->where(array('id' => $val['goods_class_id']))->getField('class_name');
|
||
}
|
||
}
|
||
$filename = '预警商品';
|
||
$arr = array(
|
||
array('good_number', '货号'),
|
||
array('goods_name', '品名'),
|
||
array('goods_code', '商品条码'),
|
||
array('average_purch_price', '成本价'),
|
||
array('purch_price', '当前进价(元)'),
|
||
array('retail_price', '零售价(元)'),
|
||
array('online_price', '商城价(元)'),
|
||
array('status_name', '状态'),
|
||
array('cate_name', '类别'),
|
||
array('goods_num', '库存'),
|
||
array('less_num', '预警值'),
|
||
);
|
||
$str = $filename . '导出时间' . date('Y-m-d', time());
|
||
$this->getExcel($filename, $arr, $mgoods_info, $str);
|
||
}
|
||
|
||
//超量
|
||
public function excess()
|
||
{
|
||
$merchantid = session('ls_userinfo')['merchantid'];
|
||
$where['merchantid'] = $merchantid;
|
||
$where['status'] = 0;
|
||
$where['type'] = 1;
|
||
$class_name = M('retail_goods_class')->where($where)->order('code asc')->select();
|
||
$this->assign('class_name', $class_name);
|
||
$this->display();
|
||
}
|
||
|
||
public function excess_list()
|
||
{
|
||
$merchantid = session("ls_userinfo")['merchantid'];
|
||
$good_number = I('get.good_number');
|
||
//按照商品类别搜索
|
||
$person1 = I('get.person1');
|
||
$person2 = I('get.person2');
|
||
$person3 = I('get.person3');
|
||
if (!empty($good_number)) {
|
||
$where['m.good_number|m.goods_name'] = $good_number;
|
||
}
|
||
$flag = 0;
|
||
if (!empty($person3)) {
|
||
$where['m.goods_class_id'] = $person3;
|
||
} else if (!empty($person2)) {
|
||
$class = M('retail_goods_class as c2')
|
||
->join('ls_retail_goods_class as c3 on c2.id=c3.pid')
|
||
->where(array('c2.id' => $person2, 'c3.status' => 0))
|
||
->field('c3.id')->select();
|
||
$flag = 1;
|
||
} else if (!empty($person1)) {
|
||
$class = M('retail_goods_class as c1')
|
||
->join('ls_retail_goods_class as c2 on c1.id=c2.pid')
|
||
->join('ls_retail_goods_class as c3 on c2.id=c3.pid AND c3.status=0', 'LEFT')
|
||
->where(array('c1.id' => $person1, 'c2.status' => 0))
|
||
->field('c2.id,c3.id as c3_id')->select();
|
||
$flag = 1;
|
||
}
|
||
if (!empty($class)) {
|
||
$arr = array();
|
||
foreach ($class as &$val) {
|
||
if (!in_array($val['id'], $arr)) {
|
||
$arr[] = $val['id'];
|
||
}
|
||
if (!empty($val['c3_id'])) {
|
||
if (!in_array($val['c3_id'], $arr)) {
|
||
$arr[] = $val['c3_id'];
|
||
}
|
||
}
|
||
}
|
||
$str = implode(',', $arr);
|
||
$where['m.goods_class_id'] = array('in', $str . ',' . ($person2 ? $person2 : $person1));
|
||
} else if ($flag == 1) {
|
||
$where['m.goods_class_id'] = $person2 ? $person2 : $person1;
|
||
}
|
||
$where['m.merchantid'] = $merchantid;
|
||
$where['m.status'] = array('in', '0,1');
|
||
$mgoods_info = M('retail_mgoods as m')
|
||
->join('ls_retail_mgoods as r on r.id=m.id', "LEFT")
|
||
->where($where)
|
||
->where('m.goods_num > m.more_num')
|
||
->order('m.status asc')
|
||
->select();
|
||
$count = M('retail_mgoods as m')
|
||
->join('ls_retail_mgoods as r on r.id=m.id', "LEFT")
|
||
->where($where)
|
||
->where('m.goods_num > m.more_num')
|
||
->count();
|
||
if ($mgoods_info) {
|
||
foreach ($mgoods_info as $key => &$val) {
|
||
$val['index'] = $key + 1;
|
||
if ($val['status'] == 0) {
|
||
$val['status_name'] = '正常';
|
||
} else if ($val['status'] == 1) {
|
||
$val['status_name'] = '下架';
|
||
}
|
||
if ($val['attribute'] == 2) {
|
||
$val['average_purch_price'] = '规格价';
|
||
$val['purch_price'] = '规格价';
|
||
$val['retail_price'] = '规格价';
|
||
}
|
||
$val['cate_name'] = M('retail_goods_class')->where(array('id' => $val['goods_class_id']))->getField('class_name');
|
||
}
|
||
}
|
||
$res['code'] = 0;
|
||
$res['msg'] = '';
|
||
$res['count'] = $count;
|
||
$res['data'] = $mgoods_info;
|
||
$this->ajaxReturn($res);
|
||
}
|
||
|
||
public function excess_list_export()
|
||
{
|
||
$merchantid = session("ls_userinfo")['merchantid'];
|
||
$good_number = I('get.good_number');
|
||
//按照商品类别搜索
|
||
$person1 = I('get.person1');
|
||
$person2 = I('get.person2');
|
||
$person3 = I('get.person3');
|
||
if (!empty($good_number)) {
|
||
$where['m.good_number|m.goods_name'] = $good_number;
|
||
}
|
||
$flag = 0;
|
||
if (!empty($person3)) {
|
||
$where['m.goods_class_id'] = $person3;
|
||
} else if (!empty($person2)) {
|
||
$class = M('retail_goods_class as c2')
|
||
->join('ls_retail_goods_class as c3 on c2.id=c3.pid')
|
||
->where(array('c2.id' => $person2, 'c3.status' => 0))
|
||
->field('c3.id')->select();
|
||
$flag = 1;
|
||
} else if (!empty($person1)) {
|
||
$class = M('retail_goods_class as c1')
|
||
->join('ls_retail_goods_class as c2 on c1.id=c2.pid')
|
||
->join('ls_retail_goods_class as c3 on c2.id=c3.pid AND c3.status=0', 'LEFT')
|
||
->where(array('c1.id' => $person1, 'c2.status' => 0))
|
||
->field('c2.id,c3.id as c3_id')->select();
|
||
$flag = 1;
|
||
}
|
||
if (!empty($class)) {
|
||
$arr = array();
|
||
foreach ($class as &$val) {
|
||
if (!in_array($val['id'], $arr)) {
|
||
$arr[] = $val['id'];
|
||
}
|
||
if (!empty($val['c3_id'])) {
|
||
if (!in_array($val['c3_id'], $arr)) {
|
||
$arr[] = $val['c3_id'];
|
||
}
|
||
}
|
||
}
|
||
$str = implode(',', $arr);
|
||
$where['m.goods_class_id'] = array('in', $str . ',' . ($person2 ? $person2 : $person1));
|
||
} else if ($flag == 1) {
|
||
$where['m.goods_class_id'] = $person2 ? $person2 : $person1;
|
||
}
|
||
$where['m.merchantid'] = $merchantid;
|
||
$where['m.status'] = array('in', '0,1');
|
||
$mgoods_info = M('retail_mgoods as m')
|
||
->join('ls_retail_mgoods as r on r.id=m.id', "LEFT")
|
||
->where($where)
|
||
->where('m.goods_num > m.more_num')
|
||
->order('m.status asc')
|
||
->select();
|
||
if ($mgoods_info) {
|
||
foreach ($mgoods_info as $key => &$val) {
|
||
$val['index'] = $key + 1;
|
||
if ($val['status'] == 0) {
|
||
$val['status_name'] = '正常';
|
||
} else if ($val['status'] == 1) {
|
||
$val['status_name'] = '下架';
|
||
}
|
||
if ($val['attribute'] == 2) {
|
||
$val['average_purch_price'] = '规格价';
|
||
$val['purch_price'] = '规格价';
|
||
$val['retail_price'] = '规格价';
|
||
}
|
||
$val['cate_name'] = M('retail_goods_class')->where(array('id' => $val['goods_class_id']))->getField('class_name');
|
||
}
|
||
}
|
||
$filename = '超量商品';
|
||
$arr = array(
|
||
array('index', '序号'),
|
||
array('good_number', '货号'),
|
||
array('goods_name', '品名'),
|
||
array('goods_code', '商品条码'),
|
||
array('average_purch_price', '成本价(元)'),
|
||
array('purch_price', '当前进价(元)'),
|
||
array('retail_price', '零售价(元)'),
|
||
array('online_price', '商城价(元)'),
|
||
array('status_name', '状态'),
|
||
array('cate_name', '类别'),
|
||
array('goods_num', '库存'),
|
||
array('more_num', '超量值'),
|
||
);
|
||
$str = $filename . '导出时间' . date('Y-m-d', time());
|
||
$this->getExcel($filename, $arr, $mgoods_info, $str);
|
||
}
|
||
|
||
|
||
/**
|
||
* 新增、编辑商品页面 获取商品详情
|
||
*/
|
||
public function goodsSet()
|
||
{
|
||
if (IS_POST) {
|
||
//获取商品详情
|
||
$OperateMGoodsApi = new OperateMGoods($this->merchant_id);
|
||
$data = $OperateMGoodsApi->getMGoodsDetails(array(
|
||
'goods_id' => I('post.id'),
|
||
));
|
||
$this->ajaxReturn($data);
|
||
} else {
|
||
//展示页面
|
||
$this->display();
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 获取商品积分限制设置
|
||
*/
|
||
public function getEditGoodsBaseSet()
|
||
{
|
||
$OperateMGoodsApi = new OperateMGoods($this->merchant_id);
|
||
$config = $OperateMGoodsApi->getEditGoodsConfig();
|
||
$this->ajaxReturn(array(
|
||
'status' => 1,
|
||
'msg' => '获取成功',
|
||
'data' => $config,
|
||
));
|
||
}
|
||
|
||
/**
|
||
* 获取商品规格信息
|
||
* @throws \think\db\exception\DataNotFoundException
|
||
* @throws \think\db\exception\DbException
|
||
* @throws \think\db\exception\ModelNotFoundException
|
||
* @throws \think\exception\DbException
|
||
*/
|
||
public function getGoodsSkuAttr()
|
||
{
|
||
$id = I('post.id');
|
||
$SkuAttribute = new SkuAttribute();
|
||
$param = array(
|
||
'merchant_id' => $this->merchant_id,
|
||
'goods_id' => $id,
|
||
);
|
||
$data = $SkuAttribute->getMerGoodsSkuInfo($param);
|
||
$this->ajaxReturn($data);
|
||
}
|
||
|
||
/**
|
||
* 保存商品新增、编辑
|
||
*/
|
||
public function doGoodsSet()
|
||
{
|
||
if (IS_POST) {
|
||
$user = session('jurisdiction_user');
|
||
$OperateGoodsApi = new OperateMGoods($this->merchant_id);
|
||
$item = array(
|
||
'merchant_id' => $this->merchant_id,
|
||
'user_type' => $user['login_type'],
|
||
'goodsInfo' => I('post.'),
|
||
'platform_type' => $this->role_info['platform_type']
|
||
);
|
||
$editGoods = $OperateGoodsApi->editMerchantGoods($item);
|
||
$this->ajaxReturn($editGoods);
|
||
}
|
||
}
|
||
|
||
/**
|
||
* 条码检测
|
||
*/
|
||
public function checkgoods()
|
||
{
|
||
if (IS_POST) {
|
||
$merchant = session('merchant_userinfo');
|
||
$code = I('post.code');
|
||
$goods = new Goods();
|
||
$result = $goods->basisCodeGetGoodsInfo($code, $merchant['partnerid']); //获取商品信息 1代表商户获取
|
||
if ($result['status'] == 1) {
|
||
$result = ['status' => 1, 'msg' => '查询成功', 'data' => $result['data']['goods']];
|
||
} else {
|
||
$result = ['status' => 0, 'msg' => '未找到该商品'];
|
||
}
|
||
$this->ajaxReturn($result);
|
||
}
|
||
}
|
||
|
||
/*
|
||
* 商户供给仓商品上架,下架,删除
|
||
* $status 0上架 1下架 2删除
|
||
*/
|
||
public function updateSaleGoods($id, $sku_id, $status)
|
||
{
|
||
$data = array();
|
||
$data['goods_id'] = $id;
|
||
if (!empty($sku_id)) {
|
||
$data['sku_id'] = $sku_id;
|
||
}
|
||
$content['status'] = $status;
|
||
$res = D('SaleMGoods')->updateData($data, $content);
|
||
if ($res['status'] == 0) {
|
||
$res['msg'] = '库存状况状态修改失败';
|
||
$this->ajaxReturn($res);
|
||
}
|
||
return $res;
|
||
}
|
||
|
||
/*商品回收站
|
||
*
|
||
*/
|
||
public function recycle()
|
||
{
|
||
$merchant_id = session("merchant_userinfo")['id'];
|
||
$class_name = M('retail_goods_class')->where(array('merchantid' => $merchant_id, 'status' => 0, 'type' => 1))->order('code asc')->select();
|
||
$this->assign('class_name', json_encode($class_name));
|
||
$this->display();
|
||
}
|
||
|
||
//简拼设置
|
||
public function simple()
|
||
{
|
||
$GoodsClassify = new GoodsClassify();
|
||
$result = $GoodsClassify->getGoodsClassTopLevel($this->merchant_id);
|
||
$this->assign('goodsClass1', json_encode($result['data']['list']));
|
||
$arr = array(
|
||
'updateGoods' => '/index.php/Retail/Mgoods/batchPinYin',
|
||
'generate' => '/index.php/Retail/Mgoods/generatePinYin',
|
||
);
|
||
$authArr = checkFunction($arr);
|
||
$this->assign('authArr', $authArr);
|
||
$this->display();
|
||
}
|
||
|
||
//简拼的商品列表
|
||
public function getSimpleGoods()
|
||
{
|
||
$data = I('post.');
|
||
$data['merchant_id'] = $this->merchant_id;
|
||
$GoodsClass = new Goods();
|
||
$result = $GoodsClass->getMerchantGoodsList($data);
|
||
$this->ajaxReturn($result);
|
||
}
|
||
|
||
//一键生成简拼
|
||
public function generatePinYin()
|
||
{
|
||
$GoodsClass = new Goods();
|
||
$result = $GoodsClass->generateSimpleSpelling([
|
||
'type' => 1,
|
||
'merchant_id' => $this->merchant_id,
|
||
'page' => I('post.page')
|
||
]);
|
||
$this->ajaxReturn($result);
|
||
}
|
||
|
||
//批量修改
|
||
public function batchPinYin()
|
||
{
|
||
$data = I('post.');
|
||
$data['type'] = 1;
|
||
$data['merchant_id'] = $this->merchant_id;
|
||
$GoodsClass = new Goods();
|
||
$result = $GoodsClass->batchSimpleSpelling($data);
|
||
$this->ajaxReturn($result);
|
||
}
|
||
|
||
/**
|
||
* 批量修改商品的一个字段
|
||
*/
|
||
public function batchOperateGoods()
|
||
{
|
||
if (IS_POST) {
|
||
$user = session('jurisdiction_user');
|
||
$OperateGoods = new OperateMGoods();
|
||
$result = $OperateGoods->batchOperateGoods([
|
||
'merchant_id' => $this->merchant_id,
|
||
'user_type' => $user['login_type'],
|
||
'operate_id' => $user['id'],
|
||
'key' => I('post.key'),
|
||
'value' => I('post.value'),
|
||
'goodsIds' => I('post.goodsIds'),
|
||
]);
|
||
$this->ajaxReturn($result);
|
||
}
|
||
}
|
||
}
|