2303 行
96 KiB
PHP
可执行文件
2303 行
96 KiB
PHP
可执行文件
<?php
|
|
|
|
namespace Retail\Controller;
|
|
|
|
use Common\Business\DownFile;
|
|
use Common\Business\Export;
|
|
use Common\Business\GoodsClassify;
|
|
use Common\Business\PayCoupon;
|
|
use Common\Business\Sell;
|
|
use Common\Business\SerialNumberGoods;
|
|
use Common\Business\Supplier;
|
|
use Common\Model\PayOrderModel;
|
|
use Common\Model\RetailGuideModel;
|
|
use Common\Model\RetailPayOrderModel;
|
|
use Common\Model\RetailStoreModel;
|
|
use Common\Model\SSupplierModel;
|
|
use Common\Model\StoreModel;
|
|
use Common\Order\BillOrder;
|
|
use Common\Order\PayOrder;
|
|
use Think\Controller;
|
|
use Common\Business\Plug;
|
|
|
|
//[1.9.21]
|
|
class SaleController extends BaseController
|
|
{
|
|
public function recebles()
|
|
{
|
|
$this->display();
|
|
}
|
|
|
|
//销售汇总
|
|
public function saleDetails()
|
|
{
|
|
//查出门店名称
|
|
$class_name = M('retail_goods_class')->where(array('merchantid' => $this->merchant_id, 'status' => 0, 'type' => 1))->order('code asc')->select();
|
|
$this->assign('class_name', json_encode($class_name));
|
|
$arr = array(
|
|
'saledetailsexport' => '/index.php/Retail/Sale/saledetailsexport',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$this->display();
|
|
}
|
|
|
|
// 商品销售明细
|
|
public function particulars()
|
|
{
|
|
//获取门店信息
|
|
$supplier_type = session('ls_userinfo')['supplier_type'];
|
|
$this->assign('supplier_type', $supplier_type);
|
|
$this->display();
|
|
}
|
|
|
|
//获取分类
|
|
public function getChildClass()
|
|
{
|
|
$user = session('ls_userinfo');
|
|
if (IS_POST && !empty($user)) {
|
|
$id = I('post.id');
|
|
$type = I('post.type');
|
|
if ($type == 1) {
|
|
$class = M('retail_goods_class')
|
|
->where(array('merchantid' => $this->merchant_id, 'type' => 1, 'status' => 0))
|
|
->field('id,class_name')
|
|
->select();
|
|
} else if ($type == 2) {
|
|
$class = M('retail_goods_class as c1')
|
|
->join('ls_retail_goods_class as c2 on c1.id=c2.pid')
|
|
->where(array('c1.id' => $id, 'c2.status' => 0))
|
|
->field('c2.id,c2.class_name')
|
|
->order('c2.code asc')
|
|
->select();
|
|
} else {
|
|
$class = M('retail_goods_class as c2')
|
|
->join('ls_retail_goods_class as c3 on c2.id=c3.pid')
|
|
->where(array('c2.id' => $id, 'c3.status' => 0))
|
|
->field('c3.id,c3.class_name')
|
|
->order('c3.code asc')
|
|
->select();
|
|
}
|
|
if (!empty($class)) {
|
|
$result['status'] = 1;
|
|
$result['data'] = $class;
|
|
$result['msg'] = '查询成功';
|
|
} else {
|
|
$result['status'] = 2;
|
|
$result['msg'] = '暂无分类';
|
|
}
|
|
} else {
|
|
$result['status'] = 0;
|
|
$result['msg'] = '登录超时';
|
|
}
|
|
|
|
$this->ajaxReturn($result);
|
|
}
|
|
|
|
//滞销商品
|
|
public function deadStock()
|
|
{
|
|
//查出门店名称
|
|
$store_name = M('retail_store')->where(array('id' => $this->store_id))->find();
|
|
$this->assign('store_name', $store_name);
|
|
$arr = array(
|
|
'unsalableexport' => '/index.php/Retail/Sale/unsalableexport',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$this->display();
|
|
}
|
|
|
|
public function deadStockinfo()
|
|
{
|
|
//出售的商品
|
|
$start = strtotime("-1 month");
|
|
$end = time();
|
|
$where['pay_type'] = array('neq', 0);
|
|
$where['store_id'] = $this->store_id;
|
|
$where['add_time'] = array('between', array($start, $end));
|
|
$dead_info = M('retail_sell')->where($where)->group('goods_id')->getField('goods_id', true);
|
|
$dead_info = $dead_info ? $dead_info : array(0);
|
|
//所有商品
|
|
//查询条件货号
|
|
$goodsnum = I('post.name02');
|
|
if (!empty($goodsnum)) {
|
|
$data['goods_number'] = $goodsnum;
|
|
}
|
|
//查询品名
|
|
$product = I('post.name03');
|
|
if (!empty($product)) {
|
|
$data['goods_name'] = array('like', array("%" . $product . "%"));
|
|
}
|
|
$data['store_id'] = $this->store_id;
|
|
$data['status'] = 0;
|
|
$data['id'] = array('not in', $dead_info);
|
|
$good_info = M('retail_goods')->where($data)->page($_POST['page'], $_POST['limit'])->order('id desc')->select();
|
|
$count = M('retail_goods')->where($data)->count();
|
|
if (!$good_info) {
|
|
$rt['code'] = 0;
|
|
$rt['msg'] = '';
|
|
$rt['data'] = $good_info;
|
|
$rt['count'] = $count;
|
|
$this->ajaxReturn($rt);
|
|
exit;
|
|
}
|
|
foreach ($good_info as $key => &$val) {
|
|
$val['key'] = $key + 1;
|
|
//销量
|
|
$volume = M('retail_sell')->where(array('goods_id' => $val['id'], 'pay_type' => array('neq', 0)))->sum('num');
|
|
$val['saleVol'] = $volume ? $volume : 0;
|
|
$val['goods_code'] = $val['goods_code'] ? $val['goods_code'] : '---';
|
|
$val['good_number'] = $val['goods_number'] ? $val['goods_number'] : '---';
|
|
}
|
|
$rt['code'] = 0;
|
|
$rt['msg'] = '';
|
|
$rt['data'] = $good_info;
|
|
$rt['count'] = $count;
|
|
$this->ajaxReturn($rt);
|
|
}
|
|
|
|
//畅销商品
|
|
public function salable()
|
|
{
|
|
//查出门店名称
|
|
$store_name = M('retail_store')->where(array('id' => $this->store_id))->find();
|
|
$this->assign('store_name', $store_name);
|
|
$arr = array(
|
|
'Bestexport' => '/index.php/Retail/Sale/Bestexport',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$GoodsClassify = new GoodsClassify();
|
|
$result = $GoodsClassify->getGoodsClassTopLevel($this->merchant_id);
|
|
$this->assign('goodsClass1', json_encode($result['data']['list']));
|
|
$this->display();
|
|
}
|
|
|
|
public function bestGoodsList()
|
|
{
|
|
ini_set('memory_limit', '64M');
|
|
$merchant_id = $this->merchant_id;
|
|
//搜索条件
|
|
$seek_data = I('post.seek_data') ? I('post.seek_data') : [];
|
|
$seek_data['start_time'] = $seek_data['start_time'] ? $seek_data['start_time'] : date('Y-m-d', strtotime("-1 month"));
|
|
$seek_data['end_time'] = $seek_data['end_time'] ? $seek_data['end_time'] : date('Y-m-d', time());
|
|
//向上向下排序 默认desc =1 asc =2 desc
|
|
$seek_data['sort_type'] = $seek_data['sort_type'] ? $seek_data['sort_type'] : 2;
|
|
$page = I('post.page') ? I('post.page') : 1;
|
|
$limit = I('post.limit') ? I('post.limit') : 10;
|
|
$result = $this->getPrivateInfoData($this->store_id, $merchant_id, $seek_data, $page, $limit);
|
|
if ($result['status'] == 0) {
|
|
$this->ajaxReturn(['status' => 0, 'msg' => '暂无数据']);
|
|
}
|
|
//汇总
|
|
$res = $this->calculateSellSum_2($result['sell_list'], $result['total']);
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
public function salableInfoExcel()
|
|
{
|
|
if (IS_POST) {
|
|
ini_set('memory_limit', '64M');
|
|
$merchant_id = $this->merchant_id;
|
|
//搜索条件
|
|
$seek_data = I('post.seek_data') ? I('post.seek_data') : array();
|
|
$seek_data['start_time'] = $seek_data['start_time'] ? $seek_data['start_time'] : date('Y-m-d', strtotime("-1 month"));
|
|
$seek_data['end_time'] = $seek_data['end_time'] ? $seek_data['end_time'] : date('Y-m-d', time());
|
|
//向上向下排序 默认desc =1 asc =2 desc
|
|
$seek_data['sort_type'] = $seek_data['sort_type'] ? $seek_data['sort_type'] : 2;
|
|
$page = I('post.page') ? I('post.page') : 1;
|
|
$limit = I('post.limit') ? I('post.limit') : 500;
|
|
$data = $this->getPrivateInfoData($this->store_id, $merchant_id, $seek_data, $page, $limit);
|
|
if ($data['status'] == 0) {
|
|
$this->ajaxReturn(['status' => 0, 'msg' => '暂无商品可导出']);
|
|
}
|
|
//汇总
|
|
$res = $this->calculateSellSum_2($data['sell_list'], $data['total']);
|
|
|
|
if (empty($res['sell_sum'])) {
|
|
$this->ajaxReturn(['status' => 0, 'msg' => '暂无商品可导出']);
|
|
}
|
|
$directory_name = I('post.directory_name');
|
|
//导入PHPExcel类库，因为PHPExcel没有用命名空间，只能inport导入
|
|
import("Vendor.PHPExcel.PHPExcel");
|
|
import("Vendor.PHPExcel.Writer.Excel5");
|
|
import("Vendor.PHPExcel.IOFactory.php");
|
|
$filename = "畅销商品导出数据时间为" . date("Y_m_d_H_i_s", strtotime($seek_data['start_time'])) . "至" . date("Y_m_d_H_i_s", strtotime($seek_data['end_time'])) . " 畅销商品导出时间" . date("Y_m_d_H_i_s");
|
|
$headArr = array(
|
|
array('goods_name', '商品名称'),
|
|
array('goods_number', '商品货号'),
|
|
array('goods_code', '商品条码'),
|
|
array('class_name', '商品分类名'),
|
|
array('sell_num', '总销量'),
|
|
);
|
|
$str = $filename;
|
|
if (!$directory_name) {
|
|
$num = createKey();
|
|
$directory_name = "./Uploads/storeGoodsExcel/{$this->store_id}/{$num}";
|
|
}
|
|
$this->setExcel($filename, $headArr, $res['sell_sum'], $str, $directory_name);
|
|
$result = array(
|
|
'status' => 1,
|
|
'type' => 1,
|
|
'directory_name' => $directory_name,
|
|
'msg' => '请继续生成文件'
|
|
);
|
|
if (count($res['sell_sum']) < $limit) {
|
|
$result['type'] = 2;
|
|
$result['msg'] = '数据生成完毕';
|
|
}
|
|
$this->ajaxReturn($result);
|
|
} else if (IS_GET) {
|
|
$directory_name = I('get.directory_name');
|
|
$ExporttalController = new ExporttableController();
|
|
$res = $ExporttalController->fileZipAddToDel($directory_name, '畅销商品导出');
|
|
$this->ajaxReturn($res);
|
|
}
|
|
}
|
|
|
|
//滞销商品导出
|
|
public function unsalableexport()
|
|
{
|
|
//出售的商品
|
|
$start = strtotime("-1 month");
|
|
$end = time();
|
|
$where['pay_type'] = array('neq', 0);
|
|
$where['store_id'] = $this->store_id;
|
|
// $where['status'] = 1;
|
|
// $where['is_refund'] = 1;
|
|
$where['add_time'] = array('between', array($start, $end));
|
|
$dead_info = M('retail_sell')->where($where)->group('goods_id')->getField('goods_id', true);
|
|
$dead_info = $dead_info ? $dead_info : array(0);
|
|
//所有商品
|
|
//查询条件货号
|
|
$goodsnum = I('get.name02');
|
|
if (!empty($goodsnum)) {
|
|
$data['goods_number'] = $goodsnum;
|
|
}
|
|
//查询品名
|
|
$product = I('get.name03');
|
|
if (!empty($product)) {
|
|
$data['goods_name'] = array('like', array("%" . $product . "%"));
|
|
}
|
|
$data['store_id'] = $this->store_id;
|
|
$data['status'] = 0;
|
|
$data['id'] = array('not in', $dead_info);
|
|
$good_info = M('retail_goods')->where($data)->order('id desc')->select();
|
|
$count = M('retail_goods')->where($data)->count();
|
|
if (!empty($good_info)) {
|
|
foreach ($good_info as $key => &$val) {
|
|
$val['key'] = $key + 1;
|
|
//销量
|
|
$volume = M('retail_sell')->where(array('goods_id' => $val['id'], 'pay_type' => array('neq', 0)))->sum('num');
|
|
$val['saleVol'] = $volume ? $volume : 0;
|
|
$val['goods_code'] = $val['goods_code'] ? $val['goods_code'] : '---';
|
|
$val['good_number'] = $val['goods_number'] ? $val['goods_number'] : '---';
|
|
}
|
|
} else {
|
|
$good_info = array();
|
|
}
|
|
$filename = "滞销商品";
|
|
$str = $filename . "导出时间:" . date('Y-m-d H:i:s', time());
|
|
$headArr = array(
|
|
array('key', '序号'),
|
|
array('goods_number', '货号'),
|
|
array('goods_code', '商品条码'),
|
|
array('goods_name', '品名'),
|
|
array('saleVol', '总销量'),
|
|
);
|
|
getExcel($filename, $headArr, $good_info, $str);
|
|
}
|
|
|
|
//畅销导出
|
|
public function Bestexport()
|
|
{
|
|
//按照出售商品销量排序
|
|
//查询条件货号
|
|
$number = I('get.name02');
|
|
if (!empty($number)) {
|
|
$where['g.goods_number'] = $number;
|
|
}
|
|
$product = I('get.name03');
|
|
//查询品名
|
|
if (!empty($product)) {
|
|
$where['s.goods_name'] = array('like', '%' . $product . '%');
|
|
}
|
|
$start = strtotime("-1 month");
|
|
$end = time();
|
|
$where['s.add_time'] = array('between', array($start, $end));
|
|
$where['s.store_id'] = $this->store_id;
|
|
$where['s.pay_type'] = array('neq', 0);
|
|
$count = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on g.id=s.goods_id')
|
|
->where($where)
|
|
->group('goods_id')
|
|
->select();
|
|
$count = count($count);
|
|
$best_sell = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on g.id=s.goods_id')
|
|
->where($where)
|
|
->group('goods_id')
|
|
->order('s.id desc')
|
|
->select();
|
|
if (!empty($best_sell)) {
|
|
foreach ($best_sell as $key => &$val) {
|
|
$val['goods_number'] = M('retail_goods')->where(array('id' => $val['goods_id']))->getField('goods_number');
|
|
$val['goods_number'] = $val['goods_number'] ? $val['goods_number'] : '---';
|
|
$val['key'] = $key + 1;
|
|
$val['goods_code'] = M('retail_goods')->where(array('id' => $val['goods_id']))->getField('goods_code');
|
|
$val['goods_code'] = $val['goods_code'] ? $val['goods_code'] : '---';
|
|
$val['good_name'] = M('retail_goods')->where(array('id' => $val['goods_id']))->getField('goods_name');
|
|
|
|
//30天销量
|
|
$where['goods_id'] = $val['goods_id'];
|
|
$val['ynum'] = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on g.id=s.goods_id')
|
|
->where($where)
|
|
->sum('num');
|
|
|
|
//总销量
|
|
$data['s.store_id'] = $this->store_id;
|
|
$data['s.pay_type'] = array('neq', 0);
|
|
$data['goods_id'] = $val['goods_id'];
|
|
//查询条件货号
|
|
if (!empty($number)) {
|
|
$data['g.goods_number'] = $number;
|
|
}
|
|
//查询品名
|
|
if (!empty($product)) {
|
|
$data['s.goods_name'] = array('like', '%' . $product . '%');
|
|
}
|
|
$val['znum'] = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on g.id=s.goods_id')
|
|
->where($data)
|
|
->sum('num');
|
|
}
|
|
} else {
|
|
$best_sell = array();
|
|
}
|
|
$filename = "畅销商品";
|
|
$str = $filename . "导出时间:" . date('Y-m-d H:i:s', time());
|
|
$headArr = array(
|
|
array('key', '序号'),
|
|
array('goods_number', '货号'),
|
|
array('goods_code', '商品条码'),
|
|
array('good_name', '品名'),
|
|
array('ynum', '近30天销量'),
|
|
array('znum', '总销量'),
|
|
);
|
|
getExcel($filename, $headArr, $best_sell, $str);
|
|
}
|
|
|
|
/* 获取销售数据 */
|
|
public function get_sell_list()
|
|
{
|
|
$global_store_jurisdiction = I('session.global_store_jurisdiction'); // 权限
|
|
$showpurch_price = $global_store_jurisdiction['showpurch_price'] ? $global_store_jurisdiction['showpurch_price'] : 2; // 查看进价权限
|
|
// 商品名称搜索
|
|
$keyword = I('get.keyword');
|
|
if (!empty($keyword)) {
|
|
$keyword = trim($keyword, ' ');
|
|
$map['g.goods_name'] = array('like', '%' . $keyword . '%');
|
|
}
|
|
// 供货商搜索
|
|
$supplier_id = I('get.supplier_id');
|
|
if (!empty($supplier_id)) {
|
|
$map['g.supplier_id'] = trim($supplier_id, '');
|
|
}
|
|
// 品牌搜索
|
|
$goods_brand_id = I('get.goods_brand_id');
|
|
if (!empty($goods_brand_id)) {
|
|
$map['g.goods_brand_id'] = trim($goods_brand_id, '');
|
|
}
|
|
// 时间搜索
|
|
$start_time = I('get.start_time');
|
|
$end_time = I('get.end_time');
|
|
if (!empty($start_time) && !empty($end_time)) {
|
|
$start_time = strtotime($start_time);
|
|
$end_time = strtotime($end_time . '23:59:59');
|
|
$map['s.addtime'] = array('between', array($start_time, $end_time));
|
|
}
|
|
if (!empty($start_time) && empty($end_time)) {
|
|
$start_time = strtotime($start_time);
|
|
$map['s.addtime'] = array('egt', $start_time);
|
|
}
|
|
if (empty($start_time) && !empty($end_time)) {
|
|
$end_time = strtotime(($end_time . '23:59:59'));
|
|
$map['s.addtime'] = array('elt', $end_time);
|
|
}
|
|
// 按照商品分类搜索
|
|
$person1 = I('get.person1');
|
|
$person2 = I('get.person2');
|
|
$person3 = I('get.person3');
|
|
$flag = 0;
|
|
if (!empty($person3)) {
|
|
$map['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);
|
|
$map['g.goods_class_id'] = array('in', $str . ',' . ($person2 ? $person2 : $person1));
|
|
} else if ($flag == 1) {
|
|
$map['g.goods_class_id'] = $person2 ? $person2 : $person1;
|
|
}
|
|
$map['s.paytype'] = array('neq', 0);
|
|
$map['s.merchantid'] = $this->merchant_id;
|
|
$map['s.storeid'] = $this->store_id;
|
|
$sell_list = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on g.id=s.goods_id')
|
|
->field('s.id,s.price,s.num,s.allmoney,s.paytype,s.type,s.purch_price,s.yuan_price,s.discount,s.addtime,s.skuinfo,s.status,s.sku_json_info,g.goods_name,g.supplier_id,goods_brand_id,g.goods_class_id')
|
|
->page($_GET['page'], $_GET['limit'])
|
|
->where($map)
|
|
->order('id desc')
|
|
->select();
|
|
$count = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on g.id=s.goods_id')
|
|
->where($map)
|
|
->count();
|
|
if ($sell_list) {
|
|
foreach ($sell_list as $key => &$val) {
|
|
$val['index'] = ++$key;
|
|
$val['num'] = intval($val['num']) == $val['num'] ? intval($val['num']) : $val['num'];
|
|
$val['addtime'] = date('Y-m-d', $val['addtime']);
|
|
if ($val['sku_json_info']) {
|
|
$sku = json_decode($val['sku_json_info'], true);
|
|
$val['yuan_price'] = $sku['retail_price'] ? $sku['retail_price'] : $sku['actprice'];
|
|
$val['sku_name'] = $sku['name'];
|
|
}
|
|
if ($val['skuinfo']) {
|
|
$sku = json_decode($val['skuinfo'], true);
|
|
$val['yuan_price'] = $sku[0]['retail_price'] ? $sku[0]['retail_price'] : $sku[0]['actprice'];
|
|
$val['sku_name'] = $sku[0]['sku'];
|
|
}
|
|
switch ($val['paytype']) {
|
|
case 1:
|
|
$val['pay_type'] = '现金支付';
|
|
break;
|
|
case 2:
|
|
$val['pay_type'] = '银行卡支付';
|
|
break;
|
|
case 3:
|
|
$val['pay_type'] = '微信支付';
|
|
break;
|
|
case 4:
|
|
$val['pay_type'] = '支付宝支付';
|
|
break;
|
|
case 5:
|
|
$val['pay_type'] = '余额支付';
|
|
break;
|
|
case 6:
|
|
$val['pay_type'] = '微信支付';
|
|
break;
|
|
case 7:
|
|
$val['pay_type'] = '其他支付';
|
|
break;
|
|
}
|
|
if ($showpurch_price == 1) {
|
|
$val['profit'] = round($val['allmoney'] - ($val['purch_price'] * $val['num']), 2);
|
|
$val['profit_margin'] = round(($val['profit'] * 100) / $val['allmoney'], 2) . '%';
|
|
} else {
|
|
$val['purch_price'] = '*';
|
|
$val['profit'] = '*';
|
|
$val['profit_margin'] = '*';
|
|
}
|
|
|
|
$val['discount'] = $val['discount'] == 1 ? '' : $val['discount']; // 折扣
|
|
$val['class'] = M('retail_goods_class')->where(array('id' => $val['goods_class_id'], 'merchantid' => $this->merchant_id, 'status' => 0))->getField('class_name');
|
|
$val['supplier'] = M('retail_supplier')->where(array('id' => $val['supplier_id'], 'merchantid' => $this->merchant_id, 'status' => 1))->getField('supplier_name');
|
|
$val['brand'] = M('retail_goods_brand')->where(array('id' => $val['goods_brand_id'], 'merchantid' => $this->merchant_id, 'state' => 0))->getField('name');
|
|
$val['sell_type'] = $val['type'] == 1 ? '商城' : '店内';
|
|
$val['sell_status'] = $val['status'] == 1 ? '购买' : '退款';
|
|
}
|
|
}
|
|
$res = $this->statistics_sell($map);
|
|
$res['code'] = 0;
|
|
$res['count'] = $count ? $count : 0;
|
|
$res['data'] = $sell_list;
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
/* 统计总金额 总成本 总利润 */
|
|
protected function statistics_sell($map)
|
|
{
|
|
$global_store_jurisdiction = I('session.global_store_jurisdiction'); // 权限
|
|
$showpurch_price = $global_store_jurisdiction['showpurch_price'] ? $global_store_jurisdiction['showpurch_price'] : 2; // 查看进价权限
|
|
$sell_data = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on g.id=s.goods_id')
|
|
->field('s.id,s.num,s.allmoney,s.type,s.purch_price,s.yuan_price,s.discount,s.addtime,s.skuinfo,s.status,s.sku_json_info')
|
|
->where($map)
|
|
->select();
|
|
if ($sell_data) {
|
|
$sell_count = 0;
|
|
$refund_count = 0;
|
|
$all_purch_price = 0; // 总进价
|
|
$all_sell_money = 0; // 总销售金额
|
|
foreach ($sell_data as &$value) {
|
|
if ($value['status'] == 1) {
|
|
$all_purch_price += $value['purch_price'] * $value['num'];
|
|
$all_sell_money += $value['allmoney'];
|
|
++$sell_count;
|
|
} else {
|
|
$all_purch_price -= $value['purch_price'] * $value['num'];
|
|
$all_sell_money -= $value['allmoney'];
|
|
++$refund_count;
|
|
}
|
|
}
|
|
$all_sell_money = $all_sell_money ? round($all_sell_money, 2) : 0;
|
|
if ($showpurch_price == 1) {
|
|
$all_purch_price = $all_purch_price ? round($all_purch_price, 2) : 0;
|
|
$all_profit = round($all_sell_money - $all_purch_price, 2);
|
|
$all_profit_margin = round(($all_profit * 100) / $all_sell_money, 2) . '%';
|
|
} else {
|
|
$all_purch_price = '*';
|
|
$all_profit = '*';
|
|
$all_profit_margin = '*';
|
|
}
|
|
}
|
|
$res['sell_count'] = $sell_count ? $sell_count : 0;
|
|
$res['refund_count'] = $refund_count ? $refund_count : 0;
|
|
$res['all_sell_money'] = $all_sell_money ? $all_sell_money : 0;
|
|
$res['all_purch_price'] = $all_purch_price ? $all_purch_price : 0;
|
|
$res['all_profit'] = $all_profit ? $all_profit : 0;
|
|
$res['all_profit_margin'] = $all_profit_margin ? $all_profit_margin : '0%';
|
|
return $res;
|
|
}
|
|
|
|
public function vip_user()
|
|
{
|
|
$this->display();
|
|
}
|
|
|
|
public function applyFor()
|
|
{
|
|
$order = I('post.order');
|
|
|
|
$res = M('retail_store_settlement')->where(['order_num' => $order])->save([
|
|
'status' => 2
|
|
]);
|
|
|
|
if (!empty($res)) {
|
|
$arr = [
|
|
'code' => 200,
|
|
'msg' => '申请成功,请等待店铺确认。'
|
|
];
|
|
} else {
|
|
$arr = [
|
|
'code' => 400,
|
|
'msg' => '申请失败,请重试。'
|
|
];
|
|
}
|
|
|
|
$this->ajaxReturn($arr);
|
|
}
|
|
|
|
public function applyFor1()
|
|
{
|
|
$storeId = I("post.storeId");
|
|
$timer = I("post.date");
|
|
|
|
$sid = $_SESSION['store_id'];
|
|
|
|
$time_where = "";
|
|
|
|
|
|
if(!empty($timer)){
|
|
|
|
$start_date = strtotime($timer[0]);
|
|
$end_date = strtotime($timer[1]);
|
|
|
|
if(!empty($start_date)){
|
|
|
|
$time_where .= " AND finish_time >= ".$start_date;
|
|
|
|
}
|
|
|
|
if(!empty($end_date)){
|
|
$time_where .= " AND finish_time <= ".$end_date;
|
|
}
|
|
|
|
}
|
|
|
|
$where = " store_id = $sid AND ( pay_store_id = $storeId OR pay_store_id1 = $storeId ) AND pay_state = 1 AND pay_type = 5 AND order_type = 1 AND (pay_store_state = 0 OR pay_store1_state = 0) ".$time_where;
|
|
|
|
|
|
$order_id_list = M("retail_bill_order")->field("id,all_money,pay_store_id,current_balance,current_balance1,pay_store_id1")->where($where)->select();
|
|
|
|
// 生成结算订单
|
|
$money = 0;
|
|
|
|
|
|
|
|
foreach ($order_id_list as $val){
|
|
|
|
if($storeId == $val['pay_store_id']){
|
|
|
|
if($val['current_balance'] >= 0 && $v['pay_store_state'] == 0){
|
|
|
|
$money = $money + $val['all_money'];
|
|
|
|
}else{
|
|
$money = $money + ($val['all_money'] + $val['current_balance']);
|
|
}
|
|
|
|
$r = M("retail_bill_order")->where("id = ".$val['id'])->save(array("pay_store_state" => 1));
|
|
|
|
}
|
|
|
|
if($storeId == $val['pay_store_id1']){
|
|
|
|
if($val['current_balance1'] >= 0 && $v['pay_store1_state'] == 0){
|
|
|
|
$money = $money + $val['all_money'];
|
|
|
|
}else{
|
|
|
|
$money = $money + ($val['all_money'] + $val['current_balance1']);
|
|
|
|
}
|
|
|
|
$r = M("retail_bill_order")->where("id = ".$val['id'])->save(array("pay_store1_state" => 1));
|
|
|
|
}
|
|
|
|
}
|
|
|
|
// var_dump($money);
|
|
// die();
|
|
|
|
$add_arr = array(
|
|
"order_id_list" => json_encode($order_id_list),
|
|
"money" => $money,
|
|
"date" => $timer,
|
|
"add_time" => date("Y-m-d H:i:s"),
|
|
"store_id" => $sid,
|
|
"pay_store_id" => $storeId,
|
|
"state" => 1
|
|
);
|
|
|
|
$r = M("store_cash_out_order")->add($add_arr);
|
|
|
|
$this->ajaxReturn(array("code" => 200,"data" => $r,"msg" => "操作成功"));
|
|
}
|
|
|
|
public function confirmMoney()
|
|
{
|
|
$order = I('post.order');
|
|
|
|
$res = M('retail_store_settlement')->where(['order_num' => $order])->save([
|
|
'status' => 1
|
|
]);
|
|
|
|
if (!empty($res)) {
|
|
$arr = [
|
|
'code' => 200,
|
|
'msg' => '确认结算成功'
|
|
];
|
|
} else {
|
|
$arr = [
|
|
'code' => 400,
|
|
'msg' => '确认结算失败'
|
|
];
|
|
}
|
|
|
|
$this->ajaxReturn($arr);
|
|
}
|
|
|
|
public function getVipUserList()
|
|
{
|
|
|
|
$timer = I('post.time/a');
|
|
$orderNum = I('post.order_no');
|
|
$storeId = $_SESSION['store_id'];
|
|
|
|
$type = 1;
|
|
|
|
$time_where = "";
|
|
|
|
if(!empty($timer)){
|
|
|
|
$start_date = strtotime($timer[0]);
|
|
$end_date = strtotime($timer[1]);
|
|
|
|
if(!empty($start_date)){
|
|
|
|
$time_where .= " AND finish_time >= ".$start_date;
|
|
|
|
}
|
|
|
|
if(!empty($end_date)){
|
|
$time_where .= " AND finish_time <= ".$end_date;
|
|
}
|
|
|
|
}
|
|
|
|
$store_list = M("retail_store")->where(" id != '$storeId' AND store_status = 0 ")->select();
|
|
|
|
$tem = array();
|
|
|
|
foreach ($store_list as $key => $val){
|
|
|
|
$sid = $val['id'];
|
|
|
|
// 在我店里充钱去别的店里消费
|
|
// $where = " store_id = $sid AND (pay_store_id = $storeId OR pay_store_id1 = $storeId )AND pay_state = 1 AND pay_type = 5 AND order_type = 1 AND pay_store_state = 0 ".$time_where;
|
|
|
|
// $r = M("retail_bill_order")->where($where)->select();
|
|
|
|
// $decMoney = 0;
|
|
|
|
// if(!empty($r)){
|
|
|
|
// foreach ($r as $v){
|
|
|
|
// $decMoney = $decMoney + $v['all_money'];
|
|
|
|
// }
|
|
|
|
// }
|
|
|
|
// 在别的店里充值 在我的店里消费
|
|
|
|
$where1 = " store_id = $storeId AND ( pay_store_id = $sid OR pay_store_id1 = $sid ) AND pay_state = 1 AND pay_type = 5 AND order_type = 1 AND ( pay_store_state = 0 OR pay_store1_state = 0 ) ".$time_where;
|
|
|
|
$r1 = M("retail_bill_order")->where($where1)->select();
|
|
|
|
$addMoney = 0;
|
|
|
|
if(!empty($r1)){
|
|
|
|
foreach ($r1 as $v){
|
|
if($sid == $v['pay_store_id'] && $v['pay_store_state'] == 0){
|
|
|
|
if($v['current_balance'] >= 0){
|
|
|
|
$addMoney = $addMoney + $v['all_money'];
|
|
|
|
}else{
|
|
$addMoney = $addMoney + ($v['all_money'] + $v['current_balance']);
|
|
}
|
|
|
|
}
|
|
|
|
if($sid == $v['pay_store_id1'] && $v['pay_store1_state'] == 0){
|
|
|
|
if($v['current_balance1'] >= 0){
|
|
|
|
$addMoney = $addMoney + $v['all_money'];
|
|
|
|
}else{
|
|
|
|
$addMoney = $addMoney + ($v['all_money'] + $v['current_balance1']);
|
|
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
|
|
$val['dec_money'] = $decMoney;
|
|
|
|
$val['add_money'] = $addMoney;
|
|
|
|
array_push($tem,$val);
|
|
}
|
|
|
|
$result['code'] = 0;
|
|
$result['data'] = $tem;
|
|
$result['date'] = $timer;
|
|
$result['total'] = sizeof($tem);
|
|
|
|
$this->ajaxReturn($result);
|
|
}
|
|
|
|
|
|
// 获取结算列表
|
|
public function getCashOutList()
|
|
{
|
|
$timer = I('post.time/a');
|
|
$page = I("post.page");
|
|
$limit = I("post.limit");
|
|
$type = I("post.type");
|
|
|
|
$sid = $_SESSION['store_id'];
|
|
|
|
$pages = ($page - 1) * $limit;
|
|
|
|
if(!$type){
|
|
$where = " ( store_id = $sid OR pay_store_id = $sid ) ";
|
|
}else{
|
|
if($type == 1){
|
|
$where = " store_id = $sid ";
|
|
}else if($type == 2){
|
|
$where = " pay_store_id = $sid ";
|
|
}
|
|
}
|
|
|
|
$res = M("store_cash_out_order")->where($where)->limit($pages,$limit)->order("add_time desc")->select();
|
|
|
|
$count = M("store_cash_out_order")->where($where)->count();
|
|
|
|
$tem = array();
|
|
|
|
foreach ($res as $val){
|
|
$val['order_id_list'] = json_decode($val['order_id_list'],true);
|
|
|
|
$val['pay_store'] = M("retail_store")->field("id,storetag,address")->where("id = ".$val['pay_store_id'])->find();
|
|
|
|
$val['store'] = M("retail_store")->field("id,storetag,address")->where("id = ".$val['store_id'])->find();
|
|
|
|
$val['current_store'] = $sid;
|
|
|
|
array_push($tem,$val);
|
|
}
|
|
|
|
$result['data'] = $tem;
|
|
$result['total'] = $count;
|
|
$result['code'] = 0;
|
|
|
|
$this->ajaxReturn($result);
|
|
}
|
|
|
|
// 通过结算
|
|
public function successCashOut()
|
|
{
|
|
$id = I("post.id");
|
|
$state = I("post.state");
|
|
|
|
$res = M("store_cash_out_order")->where(" id = $id ")->save(array("state" => $state));
|
|
|
|
if($res > 0){
|
|
$r = M("store_cash_out_order")->where("id = $id")->find();
|
|
$order_list = json_decode($r['order_id_list'],true);
|
|
if(!empty($order_list)){
|
|
|
|
foreach ($order_list as $val){
|
|
$id = $val['id'];
|
|
|
|
M("retail_bill_order")->where(" id = $id ")->save(array("state" => $state));
|
|
}
|
|
}
|
|
}
|
|
$result['code'] = 200;
|
|
$result['data'] = $res;
|
|
$result['msg'] = $res > 0 ? "操作成功" : '操作失败';
|
|
|
|
$this->ajaxReturn($result);
|
|
|
|
}
|
|
|
|
public function getVipUserList1()
|
|
{
|
|
$timer = I('post.time/a');
|
|
$orderNum = I('post.order_no');
|
|
$storeId = $_SESSION['store_id'];
|
|
$where = "store_id = {$storeId}";
|
|
$totalMoneyWhere = "store_id = {$storeId} AND use_store_id = {$storeId}";
|
|
if (!empty($timer) && !empty($timer[0])) {
|
|
$where .= ' AND create_time >= ' . strtotime($timer[0]) . ' AND create_time <= ' . strtotime($timer[0]) . ' AND status = 3';
|
|
$totalMoneyWhere .= ' AND create_time >= ' . strtotime($timer[0]) . ' AND create_time <= ' . strtotime($timer[0]) . ' AND status = 3';
|
|
}
|
|
if (!empty($orderNum)) {
|
|
$where .= ' AND order_num = ' . $orderNum;
|
|
$totalMoneyWhere .= ' AND order_num = ' . $orderNum;
|
|
}
|
|
|
|
$list = M('retail_store_settlement')
|
|
->where($where)
|
|
->page((int)I('post.page'), (int)I('post.limit'))
|
|
->select();
|
|
$count = M('retail_store_settlement')->where($where)->count();
|
|
$totalMoney = M('retail_store_settlement')->where($totalMoneyWhere)->sum('money');
|
|
|
|
if (!empty($list)) {
|
|
foreach ($list as &$v) {
|
|
if ($storeId == $v['use_store_id']) {
|
|
// 申请门店
|
|
$oneWhere = "storeid = {$v['recharge_store_id']}";
|
|
$twoWhere = "id = {$v['recharge_store_id']}";
|
|
} else {
|
|
// 结算门店
|
|
$oneWhere = "storeid = {$v['use_store_id']}";
|
|
$twoWhere = "id = {$v['use_store_id']}";
|
|
$v['money'] = "-{$v['money']}";
|
|
}
|
|
|
|
// 店铺信息
|
|
$manage = M('retail_manager')->where($oneWhere)->find();
|
|
$v['name'] = '';
|
|
$v['mobile'] = '';
|
|
if (!empty($manage)) {
|
|
$v['name'] = $manage['name'];
|
|
$v['mobile'] = $manage['mobile'];
|
|
}
|
|
$v['title'] = M('retail_store')->where($twoWhere)->getField('storetag');
|
|
|
|
// 时间戳转换
|
|
$v['create_time'] = date('Y-m-d H:i:s', $v['create_time']);
|
|
if (!empty($v['settlement_time'])) {
|
|
$v['settlement_time'] = date('Y-m-d H:i:s', $v['settlement_time']);
|
|
}
|
|
}
|
|
}
|
|
|
|
$res['code'] = 0;
|
|
$res['data'] = $list;
|
|
$res['count'] = $count;
|
|
$res['store_id'] = $storeId;
|
|
$res['totalMoney'] = !empty($totalMoney) ? $totalMoney : 0;
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
// public function getVipUserList()
|
|
// {
|
|
// $info = $_SESSION['jurisdiction_user'];
|
|
// $type = I('post.type', 1);
|
|
// $where = [];
|
|
//
|
|
// if ($type == 1) {
|
|
// // 申请结算
|
|
// $where['store_id'] = $info['id'];
|
|
// } else {
|
|
// // 确认结算
|
|
// $where['withhold_store_id'] = $info['id'];
|
|
// }
|
|
//
|
|
// $list = M('retail_store_settlement')
|
|
// ->where($where)
|
|
// ->page((int)I('post.page'), (int)I('post.limit'))
|
|
// ->select();
|
|
// $count = M('retail_store_settlement')->where($where)->count();
|
|
//
|
|
// if (!empty($list)) {
|
|
// foreach ($list as &$v) {
|
|
// // 店长信息
|
|
// $where = $type == 1 ? ['store_id' => $v['withhold_store_id']] : ['store_id' => $v['store_id']];
|
|
// $manage = M('retail_manager')->where($where)->find();
|
|
// $v['name'] = '';
|
|
// $v['mobile'] = '';
|
|
// if (!empty($manage)) {
|
|
// $v['name'] = $manage['name'];
|
|
// $v['mobile'] = $manage['mobile'];
|
|
// }
|
|
// // 名称
|
|
// $where = $type == 1 ? ['id' => $v['withhold_store_id']] : ['id' => $v['store_id']];
|
|
// $v['title'] = M('retail_store')->where($where)->getField('storetag');
|
|
// }
|
|
// }
|
|
//
|
|
// $res['code'] = 0;
|
|
// $res['data'] = $list;
|
|
// $res['count'] = $count;
|
|
// $this->ajaxReturn($res);
|
|
// }
|
|
|
|
/* 店内收款明细 */
|
|
public function get_store_sell_list()
|
|
{
|
|
$RetailGuideModel = new RetailGuideModel();
|
|
|
|
/* 时间查询 */
|
|
$user_type = I('post.user_type');
|
|
if (in_array($user_type, ['1', '2', '3'])) {
|
|
switch ($user_type) {
|
|
case '1':
|
|
//零售会员
|
|
$map['b.vid'] = ['gt', 0];
|
|
break;
|
|
case '2':
|
|
//散客
|
|
$map['b.vid'] = [['exp', 'IS NULL'], 0, 'OR'];
|
|
$map['b.third_vip_code'] = ['exp', 'IS NULL'];
|
|
break;
|
|
case '3':
|
|
//德育币会员
|
|
$map['b.third_vip_code'] = ['exp', 'IS NOT NULL'];
|
|
break;
|
|
}
|
|
}
|
|
/* 订单号搜索 */
|
|
if (I('post.order_no')) {
|
|
$map['b.order_no'] = I('post.order_no');
|
|
}
|
|
/* 会员号搜索 */
|
|
if (I('post.member_number')) {
|
|
$map['v.mobile_phone|v.card_key|v.cardnum'] = array('like', '%' . I('post.member_number') . '%');
|
|
}
|
|
/* 德育币会员搜索 */
|
|
if (I('post.mec_vip_key')) {
|
|
$map['b.third_vip_code|b.third_vip_name'] = strval(I('post.mec_vip_key'));
|
|
}
|
|
/* 德育币村镇ID搜索 */
|
|
if (I('post.mec_villages_id')) {
|
|
$StoreModel = new RetailStoreModel();
|
|
$storeIds = $StoreModel->getFindField(['third_code' => strval(I('post.mec_villages_id'))]);
|
|
$storeIds = $storeIds ? $storeIds : '0';
|
|
$map['b.store_id'] = array('in', $storeIds);
|
|
}
|
|
$time = I("post.time");
|
|
if ($time) {
|
|
$start_date = strtotime($time[0]);
|
|
$end_date = strtotime($time[1]);
|
|
$map['b.add_time'] = ['between', [$start_date, $end_date]];
|
|
}
|
|
/* 收银员搜索 */
|
|
if (I('post.cashier_id')) {
|
|
$map['b.cashier_id'] = I('post.cashier_id');
|
|
}
|
|
/* 支付方式搜索 */
|
|
$pay_type = I('post.pay_type');
|
|
if ($pay_type) {
|
|
$map['b. pay_type'] = $pay_type;
|
|
}
|
|
/* 订单类型 */
|
|
if (I('post.order_type')) {
|
|
$map['b.order_type'] = I('post.order_type');
|
|
}
|
|
// 其他支付
|
|
$other_type = I('post.other_type');
|
|
$p_string = 'ls_retail_pay_order as p on p.bill_id=b.id';
|
|
if ($pay_type == 7 && $other_type) {
|
|
$p_string .= ' AND p.other_pay_id=' . $other_type;
|
|
}
|
|
$map['b.pay_state'] = 1;
|
|
$map['b.type'] = 2;
|
|
$map['b.store_id'] = $this->store_id;
|
|
|
|
$sell_list = M('retail_bill_order as b')
|
|
->join($p_string, 'LEFT')
|
|
->join('ls_retail_bill_discount as d on d.bill_id=b.id', 'LEFT')
|
|
->join('ls_retail_cashier as c on c.id=b.cashier_id', 'LEFT')
|
|
->join('ls_retail_vip as v on v.id=b.vid', 'LEFT')
|
|
->field('b.*,v.name as vip_name,v.nickname,v.mobile_phone as vip_mobile,v.card_key,c.name as adminname,d.coupon_money,d.vip_dis_money,d.cashier_dis_money,d.discount,d.small_changes_money,d.vip_less_money,d.use_integral,d.cashier_dis_money,d.cashier_manual_money,d.pay_coupon_fee,d.coupon_type,b.third_vip_code,b.third_vip_name')
|
|
->where($map)
|
|
->group('b.id')
|
|
->order("b.add_time desc")
|
|
->page((int)I('post.page'), (int)I('post.limit'))
|
|
->select();
|
|
$count = M('retail_bill_order as b')
|
|
->join('ls_retail_cashier as c on c.id=b.cashier_id', 'LEFT')
|
|
->join('ls_retail_vip as v on v.id=b.vid', 'LEFT')
|
|
->join('ls_retail_bill_discount as d on d.bill_id=b.id', 'LEFT')
|
|
->where($map)->count();
|
|
$guideIdArr = [];
|
|
$guideList = [];
|
|
//优惠券名称
|
|
$coupon_name = [
|
|
'门店优惠券:',
|
|
'会员优惠券:',
|
|
'微信商家券:',
|
|
];
|
|
$BillOrder = new BillOrder();
|
|
|
|
$StoreModel = new RetailStoreModel();
|
|
$villageId = $StoreModel->getFindField(['id' => $this->store_id], 'third_code');
|
|
$Plug = new Plug();
|
|
$plug_result = $Plug->merPlugState([
|
|
'merchant_id' => $this->merchant_id,
|
|
'identification_arr' => ['moraleducationcoin']
|
|
]);
|
|
foreach ($sell_list as $key => &$val) {
|
|
$val['index'] = $key + 1;
|
|
$val['use_integral'] = round($val['use_integral']);
|
|
$val['add_time'] = date('Y-m-d H:i:s', $val['add_time']);
|
|
$total_discount = round($val['coupon_money'] + $val['cashier_dis_money'] + $val['vip_dis_money'] + $val['small_changes_money'] + $val['vip_less_money'] + $val['cashier_manual_money'], 2); // 总减少金额
|
|
$val['type_name'] = $val['type'] == 1 ? '商城' : '店内';
|
|
$val['all_money'] = floatval($val['all_money']); // 消费金额
|
|
$val['discount'] = $val['discount'] >= 1 ? '无折扣' : floatval($val['discount']) . ' 折'; // 手动折扣
|
|
$val['coupon_money'] = $val['coupon_money'] > 0 ? $coupon_name[$val['coupon_type'] - 1] . floatval($val['coupon_money']) : ''; // 优惠券金额
|
|
$val['pay_coupon_fee'] = $val['pay_coupon_fee'] > 0 ? '微信代金券:' . floatval($val['pay_coupon_fee']) : '';
|
|
if (empty($val['coupon_money']) && empty($val['pay_coupon_fee'])) {
|
|
$val['reduction'] = 1;
|
|
} else {
|
|
$val['reduction'] = 2;
|
|
}
|
|
$val['cashier_dis_money'] = $val['cashier_dis_money'] && $val['cashier_dis_money'] > 0 ? floatval($val['cashier_dis_money']) . '（元）' : '无优惠'; // 手动折扣金额
|
|
$val['cashier_manual_money'] = $val['cashier_manual_money'] && $val['cashier_manual_money'] > 0 ? floatval($val['cashier_manual_money']) . '（元）' : '无优惠'; // 单品折扣金额
|
|
$vip_dis_money = $val['vip_dis_money'] ? $val['vip_dis_money'] : 0;
|
|
$vip_less_money = $val['vip_less_money'] ? $val['vip_less_money'] : 0;
|
|
$val['vip_dis_money'] = round($vip_dis_money + $vip_less_money, 2);
|
|
$val['small_changes_money'] = $val['small_changes_money'] && $val['small_changes_money'] > 0 ? floatval($val['small_changes_money']) . '（元）' : '未抹零'; // 手动折扣金额
|
|
$val['total_discount'] = $total_discount ? $total_discount . '（元）' : '无优惠';
|
|
if ($val['vid']) { // 会员信息
|
|
$val['vip_name'] = $val['vip_name'] ? $val['vip_name'] : ($val['nickname'] ? $val['nickname'] : '会员');
|
|
$val['vip_mobile'] = $val['vip_mobile'] ? $val['vip_mobile'] : '未设置';
|
|
$val['card_key'] = $val['card_keycard_key'] ? $val['card_key'] : '未绑定';
|
|
} else if ($plug_result['moraleducationcoin']) {
|
|
$val['vip_name'] = $val['third_vip_name'];
|
|
$val['villageId'] = $villageId;
|
|
$val['vip_mobile'] = '';
|
|
$val['card_key'] = '';
|
|
} else {
|
|
$val['vip_name'] = '散客';
|
|
$val['vip_mobile'] = '未设置';
|
|
$val['card_key'] = '未绑定';
|
|
}
|
|
|
|
$val['pay_name'] = $BillOrder->getPayType($val['pay_type'], $val['id']);
|
|
|
|
/* 订单类型 */
|
|
if ($val['order_type'] == 2) {
|
|
$val['status_name'] = '退款订单';
|
|
$val['all_money'] = 0 - $val['all_money'];
|
|
} else {
|
|
if ($val['refund_money'] > 0) {
|
|
$val['status_name'] = '有退款';
|
|
} else {
|
|
$val['status_name'] = '购买订单';
|
|
}
|
|
}
|
|
/* 导购员 */
|
|
if ($val['guide_id']) {
|
|
if (in_array($val['guide_id'], $guideIdArr)) {
|
|
$val['guide_name'] = $guideList[$val['guide_id']]['guidename'] ? $guideList[$val['guide_id']]['guidename'] : '自购';
|
|
} else {
|
|
$guideData = $RetailGuideModel->getFind(['id' => $val['guide_id']], 'id,guidename');
|
|
$val['guide_name'] = $guideData['guidename'] ? $guideData['guidename'] : '自购';
|
|
$guideIdArr[] = $guideData['id'];
|
|
$guideList[$val['guide_id']] = $guideData;
|
|
}
|
|
} else {
|
|
$val['guide_name'] = '自购';
|
|
}
|
|
}
|
|
|
|
$plugClass = new Plug();
|
|
//订单获取祝福码，判断该门店是否，有，并且开启
|
|
$storePlugStatusPost = [
|
|
'store_id' => $this->store_id,
|
|
'identification_arr' => ['blessing'],
|
|
];
|
|
$storePlugStatus = $plugClass->plugStoreStatus($storePlugStatusPost);//获取状态
|
|
if ($storePlugStatus === true) {
|
|
//有权限
|
|
$jurisdictionBlessing = 1;
|
|
} else {
|
|
//无权限
|
|
$jurisdictionBlessing = 2;
|
|
}
|
|
|
|
$res['code'] = 0;
|
|
$res['data'] = $sell_list;
|
|
$res['count'] = $count;
|
|
$res['jurisdiction_blessing'] = $jurisdictionBlessing;
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
/*
|
|
* 店内明细统计
|
|
*/
|
|
public function getSellListTotal()
|
|
{
|
|
/* 时间查询 */
|
|
$data = I("post.");
|
|
$time = $data['time'];
|
|
if (!empty($time)) {
|
|
$start_date = strtotime($time[0]);
|
|
$end_date = strtotime($time[1]);
|
|
$map['b.add_time'] = ['between', [$start_date, $end_date]];
|
|
}
|
|
/* 时间查询 */
|
|
$user_type = I('post.user_type');
|
|
if (in_array($user_type, ['1', '2', '3'])) {
|
|
switch ($user_type) {
|
|
case '1':
|
|
//零售会员
|
|
$map['b.vid'] = ['gt', 0];
|
|
break;
|
|
case '2':
|
|
//散客
|
|
$map['b.vid'] = [['exp', 'IS NULL'], 0, 'OR'];
|
|
$map['b.third_vip_code'] = ['exp', 'IS NULL'];
|
|
break;
|
|
case '3':
|
|
//德育币会员
|
|
$map['b.third_vip_code'] = ['exp', 'IS NOT NULL'];
|
|
break;
|
|
}
|
|
}
|
|
/* 订单号搜索 */
|
|
if (I('post.order_no')) {
|
|
$map['b.order_no'] = I('post.order_no');
|
|
}
|
|
/* 会员号搜索 */
|
|
if (I('post.member_number')) {
|
|
$map['v.mobile_phone|v.card_key|v.cardnum'] = array('like', '%' . I('post.member_number') . '%');
|
|
}
|
|
/* 德育币会员搜索 */
|
|
if (I('post.mec_vip_key')) {
|
|
$map['b.third_vip_code|b.third_vip_name'] = strval(I('post.mec_vip_key'));
|
|
}
|
|
/* 德育币村镇ID搜索 */
|
|
if (I('post.mec_villages_id')) {
|
|
$StoreModel = new RetailStoreModel();
|
|
$storeIds = $StoreModel->getFindField(['third_code' => strval(I('post.mec_villages_id'))]);
|
|
$storeIds = $storeIds ? $storeIds : '0';
|
|
$map['b.store_id'] = array('in', $storeIds);
|
|
}
|
|
/* 收银员搜索 */
|
|
if ($data['cashier_id']) {
|
|
$map['b.cashier_id'] = $data['cashier_id'];
|
|
}
|
|
/* 支付方式搜索 */
|
|
if ($data['pay_type']) {
|
|
$map['b. pay_type'] = $data['pay_type'];
|
|
}
|
|
/* 订单类型 */
|
|
if ($data['order_type']) {
|
|
$map['b.order_type'] = $data['order_type'];
|
|
}
|
|
$map['b.pay_state'] = 1;
|
|
$map['b.type'] = 2;
|
|
$map['b.store_id'] = $this->store_id;
|
|
$sell_list = M('retail_bill_order as b')
|
|
->join('ls_retail_cashier as c on c.id=b.cashier_id', 'LEFT')
|
|
->join('ls_retail_vip as v on v.id=b.vid', 'LEFT')
|
|
->join('ls_retail_bill_discount as d on d.bill_id=b.id', 'LEFT')
|
|
->field('b.*,d.coupon_money,d.cashier_manual_money,d.vip_dis_money,d.cashier_dis_money,d.discount,d.small_changes_money,d.pay_coupon_fee')
|
|
->where($map)
|
|
->select();
|
|
$sell_count = 0; // 销售笔数
|
|
$sell_money = 0; //销售总金额
|
|
$refund_count = 0; //退款笔数
|
|
$refund_money = 0; //退款金额
|
|
$sell_dismoney = 0; //购买订单的会员折扣金额
|
|
$refund_dismoney = 0; //退款订单的会员折扣金额
|
|
$sell_cashierdiscountmoney = 0; //购买订单手动折扣金额
|
|
$refund_cashierdiscountmoney = 0; //退款订单手动折扣金额
|
|
$sell_exchange_money = 0; //购买订单优惠金额
|
|
$refund_exchange_money = 0; //退款订单优惠金额
|
|
$sell_small_changes_money = 0; //购买订单抹零金额
|
|
$refund_small_changes_money = 0; //退款订单抹零金额
|
|
$pay_coupon_money = 0; //微信代金券金额
|
|
$cashier_manual_money = 0; //单品折扣金额
|
|
foreach ($sell_list as $key => &$val) {
|
|
if ($val['order_type'] == 1) { //购买订单
|
|
$sell_count += 1;
|
|
$sell_money += $val['all_money'];
|
|
$sell_dismoney += $val['vip_dis_money'];
|
|
$sell_cashierdiscountmoney += $val['cashier_dis_money'];
|
|
$sell_exchange_money += $val['coupon_money'];
|
|
$sell_small_changes_money += $val['small_changes_money'];
|
|
$pay_coupon_money += $val['pay_coupon_fee'];
|
|
$cashier_manual_money += $val['cashier_manual_money'];
|
|
}
|
|
if ($val['order_type'] == 2) { //退款订单
|
|
$refund_count += 1;
|
|
$refund_money += $val['refund_money'];
|
|
$refund_dismoney += $val['vip_dis_money'];
|
|
$refund_cashierdiscountmoney += $val['cashier_dis_money'];
|
|
$refund_exchange_money += $val['coupon_money'];
|
|
$refund_small_changes_money += $val['small_changes_money'];
|
|
$pay_coupon_money -= $val['pay_coupon_fee'];
|
|
$cashier_manual_money -= $val['cashier_manual_money'];
|
|
}
|
|
}
|
|
$money = round($sell_money - $refund_money, 2);
|
|
$dismoney = round($sell_dismoney - $refund_dismoney, 2);
|
|
$cashierdiscountmoney = round($sell_cashierdiscountmoney - $refund_cashierdiscountmoney, 2);
|
|
$exchange_money = round($sell_exchange_money - $refund_exchange_money, 2);
|
|
$small_changes_money = round($sell_small_changes_money - $refund_small_changes_money, 2);
|
|
$res['sell_count'] = $sell_count ? $sell_count . '（笔）' : 0 . '（笔）';
|
|
$res['refund_count'] = $refund_count ? $refund_count . '（笔）' : 0 . '（笔）';
|
|
$res['exchange_money'] = $exchange_money ? $exchange_money . '（元）' : 0 . '（元）';
|
|
$res['dismoney'] = $dismoney ? $dismoney . '（元）' : 0 . '（元）';
|
|
$res['cashierdiscountmoney'] = $cashierdiscountmoney ? $cashierdiscountmoney . '（元）' : 0 . '（元）';
|
|
$res['small_changes_money'] = $small_changes_money ? $small_changes_money . '（元）' : 0 . '（元）';
|
|
$res['sell_money'] = $sell_money ? $sell_money . '（元）' : 0 . '（元）';
|
|
$res['refund_money'] = $refund_money ? $refund_money . '（元）' : 0 . '（元）';
|
|
$res['money'] = $money ? $money . '（元）' : 0 . '（元）';
|
|
$res['pay_coupon_money'] = round($pay_coupon_money, 2) . '（元）';
|
|
$res['cashier_manual_money'] = round($cashier_manual_money, 2) . '（元）';
|
|
$res['status'] = 1;
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
/* 店内收款明细导出 */
|
|
public function export()
|
|
{
|
|
/* 时间查询 */
|
|
$time = json_decode(htmlspecialchars_decode(I("get.time")), true);
|
|
if (!empty($time)) {
|
|
$start_date = strtotime($time[0]);
|
|
$end_date = strtotime($time[1]);
|
|
$map['b.add_time'] = array('between', array($start_date, $end_date));
|
|
} else {
|
|
//本月
|
|
$start_date = strtotime(date("Y-m-01 00:00:00", time()));
|
|
$end_date = time();
|
|
$map['b.add_time'] = array('between', array($start_date, $end_date));
|
|
}
|
|
/* 时间查询 */
|
|
$user_type = I('get.user_type');
|
|
if (in_array($user_type, ['1', '2', '3'])) {
|
|
switch ($user_type) {
|
|
case '1':
|
|
//零售会员
|
|
$map['b.vid'] = ['gt', 0];
|
|
break;
|
|
case '2':
|
|
//散客
|
|
$map['b.vid'] = [['exp', 'IS NULL'], 0, 'OR'];
|
|
$map['b.third_vip_code'] = ['exp', 'IS NULL'];
|
|
break;
|
|
case '3':
|
|
//德育币会员
|
|
$map['b.third_vip_code'] = ['exp', 'IS NOT NULL'];
|
|
break;
|
|
}
|
|
}
|
|
/* 订单号搜索 */
|
|
if (I('get.order_no')) {
|
|
$map['b.order_no'] = I('get.order_no');
|
|
}
|
|
/* 会员号搜索 */
|
|
if (I('get.member_number')) {
|
|
$map['v.mobile_phone|v.card_key|v.cardnum'] = array('like', '%' . I('get.member_number') . '%');
|
|
}
|
|
/* 德育币会员搜索 */
|
|
if (I('get.mec_vip_key')) {
|
|
$map['b.third_vip_code|b.third_vip_name'] = strval(I('get.mec_vip_key'));
|
|
}
|
|
/* 德育币村镇ID搜索 */
|
|
if (I('get.mec_villages_id')) {
|
|
$StoreModel = new RetailStoreModel();
|
|
$storeIds = $StoreModel->getFindField(['third_code' => strval(I('get.mec_villages_id'))]);
|
|
$storeIds = $storeIds ? $storeIds : '0';
|
|
$map['b.store_id'] = array('in', $storeIds);
|
|
}
|
|
/* 收银员搜索 */
|
|
$admin_id = I('get.cashier_id');
|
|
if ($admin_id) {
|
|
$map['b.cashier_id'] = $admin_id;
|
|
}
|
|
/* 支付方式搜索 */
|
|
$pay_type = I('get.pay_type');
|
|
if ($pay_type) {
|
|
$map['b. pay_type'] = $pay_type;
|
|
}
|
|
/* 订单类型 */
|
|
$order_type = I('get.order_type');
|
|
if ($order_type) {
|
|
$map['b.order_type'] = $order_type;
|
|
}
|
|
// 其他支付
|
|
$other_type = I('get.other_type');
|
|
$p_string = 'ls_retail_pay_order as p on p.bill_id=b.id';
|
|
if ($pay_type == 7 && $other_type) {
|
|
$p_string .= ' AND p.other_pay_id=' . $other_type;
|
|
}
|
|
$map['b.pay_state'] = 1;
|
|
$map['b.type'] = 2;
|
|
$map['b.store_id'] = $this->store_id;
|
|
$sell_list = M('retail_bill_order as b')
|
|
->join($p_string)
|
|
->join('ls_retail_bill_discount as d on d.bill_id=b.id', 'LEFT')
|
|
->join('ls_retail_cashier as c on c.id=b.cashier_id', 'LEFT')
|
|
->join('ls_retail_vip as v on v.id=b.vid', 'LEFT')
|
|
->field('b.*,v.name as vip_name,v.nickname,v.mobile_phone as vip_mobile,v.card_key,c.name as adminname,d.coupon_money,d.vip_dis_money,d.cashier_dis_money,d.discount,d.small_changes_money,d.vip_less_money,d.use_integral,d.pay_coupon_fee,d.coupon_type,b.third_vip_code,b.third_vip_name')
|
|
->where($map)
|
|
->group('b.id')
|
|
->order("b.id desc")
|
|
->select();
|
|
$coupon_name = [
|
|
'门店优惠券:',
|
|
'会员优惠券:',
|
|
'微信商家券:',
|
|
];
|
|
$BillOrder = new BillOrder();
|
|
$StoreModel = new StoreModel();
|
|
$villageId = $StoreModel->getFindField(['id' => $this->store_id], 'third_code');
|
|
$Plug = new Plug();
|
|
$plug_result = $Plug->merPlugState([
|
|
'merchant_id' => $this->merchant_id,
|
|
'identification_arr' => ['moraleducationcoin']
|
|
]);
|
|
foreach ($sell_list as $key => &$val) {
|
|
$val['index'] = $key + 1;
|
|
$val['add_time'] = date('Y-m-d H:i:s', $val['add_time']);
|
|
$total_discount = round($val['coupon_money'] + $val['cashier_dis_money'] + $val['vip_dis_money'] + $val['small_changes_money'] + $val['vip_less_money'] + $val['cashier_manual_money'], 2); // 总减少金额
|
|
$val['type_name'] = $val['type'] == 1 ? '商城' : '店内';
|
|
$val['all_money'] = floatval($val['all_money']); // 消费金额
|
|
$val['discount'] = $val['discount'] >= 1 ? '无折扣' : floatval($val['discount']) . ' 折'; // 手动折扣
|
|
$coupon_fee = '';
|
|
if ($val['coupon_money'] > 0) {
|
|
$coupon_fee .= $coupon_name[$val['coupon_type'] - 1] . floatval($val['coupon_money']);
|
|
}
|
|
if ($val['pay_coupon_fee'] > 0) {
|
|
$coupon_fee .= '微信代金券:' . floatval($val['pay_coupon_fee']);
|
|
}
|
|
$val['coupon_money'] = $coupon_fee;
|
|
$val['cashier_dis_money'] = $val['cashier_dis_money'] && $val['cashier_dis_money'] > 0 ? floatval($val['cashier_dis_money']) . '（元）' : '无优惠'; // 手动折扣金额
|
|
$vip_dis_money = $val['vip_dis_money'] ? $val['vip_dis_money'] : 0;
|
|
$vip_less_money = $val['vip_less_money'] ? $val['vip_less_money'] : 0;
|
|
$val['vip_dis_money'] = round($vip_dis_money + $vip_less_money, 2);
|
|
$val['small_changes_money'] = $val['small_changes_money'] && $val['small_changes_money'] > 0 ? floatval($val['small_changes_money']) . '（元）' : '未抹零'; // 手动折扣金额
|
|
$val['total_discount'] = $total_discount ? $total_discount . '（元）' : '无优惠';
|
|
if ($val['vid']) { // 会员信息
|
|
$val['vip_name'] = $val['vip_name'] ? $val['vip_name'] : ($val['nickname'] ? $val['nickname'] : '会员');
|
|
$val['vip_mobile'] = $val['vip_mobile'] ? $val['vip_mobile'] : '未设置';
|
|
$val['card_key'] = $val['card_keycard_key'] ? $val['card_key'] : '未绑定';
|
|
} else if ($plug_result['moraleducationcoin']) {
|
|
$val['vip_name'] = $val['third_vip_name'];
|
|
$val['villageId'] = $villageId;
|
|
$val['vip_mobile'] = '';
|
|
$val['card_key'] = '';
|
|
} else {
|
|
$val['vip_name'] = '散客';
|
|
$val['vip_mobile'] = '未设置';
|
|
$val['card_key'] = '未绑定';
|
|
}
|
|
$val['pay_name'] = $BillOrder->getPayType($val['pay_type'], $val['id']);
|
|
|
|
/* 订单类型 */
|
|
if ($val['order_type'] == 2) {
|
|
$val['status_name'] = '退款订单';
|
|
$val['all_money'] = -$val['all_money'];
|
|
} else {
|
|
if ($val['refund_money'] > 0) {
|
|
$val['status_name'] = '有退款';
|
|
} else {
|
|
$val['status_name'] = '购买订单';
|
|
}
|
|
}
|
|
/* 导购员 */
|
|
if ($val['guide_id']) {
|
|
$guide_name = M('retail_guide')->where(array('id' => $val['guide_id']))->getField('guidename');
|
|
$val['guide_name'] = $guide_name ? $guide_name : '自购';
|
|
} else {
|
|
$val['guide_name'] = '自购';
|
|
}
|
|
$out_trade_no = D("RetailPayOrder")->getFindField(array('bill_id' => $val['id'], 'order_state' => array('in', 'SUCCESS,REFUND')), "out_trade_no", true);
|
|
if (!empty($out_trade_no)) {
|
|
$val['out_trade_no'] = implode(',', $out_trade_no);
|
|
} else {
|
|
$val['out_trade_no'] = '';
|
|
}
|
|
}
|
|
$name = '店内收款明细';
|
|
$headArr = array(
|
|
array('index', '序号'),
|
|
array('order_no', '订单号'),
|
|
array('out_trade_no', '内部订单号'),
|
|
array('vip_name', '消费对象'),
|
|
array('vip_mobile', '会员手机号'),
|
|
array('card_key', '实体卡号'),
|
|
array('all_money', '支付金额'),
|
|
array('use_integral', '使用积分'),
|
|
array('pay_name', '支付类型'),
|
|
array('add_time', '消费时间'),
|
|
array('adminname', '收银员'),
|
|
array('guide_name', '导购员'),
|
|
array('coupon_money', '优惠券减免'),
|
|
array('discount', '手动折扣'),
|
|
array('cashier_dis_money', '手动折扣优惠'),
|
|
array('vip_dis_money', '会员价及会员折扣优惠'),
|
|
array('small_changes_money', '抹零'),
|
|
array('total_discount', '总优惠'),
|
|
array('status_name', '订单类型'),
|
|
array('business_remark', '订单备注'),
|
|
);
|
|
if ($plug_result['moraleducationcoin']) {
|
|
$headArr[] = ['third_vip_code', '德育币会员ID'];
|
|
$headArr[] = ['villageId', '村镇ID'];
|
|
}
|
|
$str = $name . '导出时间' . date('Y-m-d H:i:s', time());
|
|
getExcel($name, $headArr, $sell_list, $str);
|
|
}
|
|
|
|
/**
|
|
* 打印
|
|
*/
|
|
public function storeIdGet()
|
|
{
|
|
$bill_id = I('post.bill_id');
|
|
if (!$bill_id) {
|
|
$res['status'] = 0;
|
|
$res['msg'] = '登录超时,请刷新重试';
|
|
$this->ajaxReturn($res);
|
|
}
|
|
$res = A('PayApi/Printer')->linePrinting_v1($this->store_id, $bill_id, true);
|
|
if ($res['status'] == 0) {
|
|
$this->ajaxReturn($res);
|
|
}
|
|
}
|
|
|
|
/**销售明细、汇总
|
|
* 获取商品分类
|
|
* @return [array] $res
|
|
*/
|
|
public function getClassList()
|
|
{
|
|
/* 商品分类 */
|
|
$class_data = M('retail_goods_class')->field('id,class_name')->where(array('pid' => 0, 'status' => 0, 'merchantid' => $this->merchant_id))->order('id asc')->select();
|
|
if (!$class_data) {
|
|
$res = array('status' => 0, 'msg' => '暂无分类');
|
|
$this->ajaxReturn($res);
|
|
}
|
|
foreach ($class_data as &$val) {
|
|
$children1 = M('retail_goods_class')->field('id,class_name')->where(array('pid' => $val['id'], 'status' => 0, 'merchantid' => $this->merchant_id))->order('id asc')->select();
|
|
if ($children1) {
|
|
foreach ($children1 as &$value) {
|
|
$children2 = M('retail_goods_class')->field('id,class_name')->where(array('pid' => $value['id'], 'status' => 0, 'merchantid' => $this->merchant_id))->order('id asc')->select();
|
|
$value['children'] = $children2;
|
|
}
|
|
}
|
|
$val['children'] = $children1;
|
|
}
|
|
$res = array('status' => 1, 'class_data' => $class_data);
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
/**
|
|
* 获取销售数据
|
|
* @param [array] $seek_data 搜索条件
|
|
* @return [array] $res
|
|
*/
|
|
public function getSellList()
|
|
{
|
|
// 搜索条件
|
|
$seek_data = I('post.seek_data') ? I('post.seek_data') : array();
|
|
$res = $this->getPublicSellData($this->store_id, $this->merchant_id, $seek_data, 1);
|
|
foreach ($res['sell_list'] as &$val) {
|
|
if ($val['sell_type'] != 1) {
|
|
$val['subtotal'] = '-' . $val['subtotal'];
|
|
}
|
|
}
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
/**
|
|
* 销售明细导出
|
|
* @param [array] $seek_data 搜索条件
|
|
*/
|
|
public function sellListExport()
|
|
{
|
|
ini_set('memory_limit', '-1');
|
|
$storeid = I('session.storeid');
|
|
if (!$storeid) {
|
|
$res = array('status' => 0, 'msg' => '登录超时，请重新登录');
|
|
$this->ajaxReturn($res);
|
|
}
|
|
$supplier_type = session('ls_userinfo')['supplier_type'];
|
|
$merchantid = session("ls_userinfo")['merchantid'];
|
|
// 搜索条件
|
|
$seek_data = I('get.seek_data') ? json_decode(htmlspecialchars_decode(I('get.seek_data')), true) : array();
|
|
$res = $this->getPublicSellData($storeid, $merchantid, $seek_data, '');
|
|
if ($res['status'] == 1) {
|
|
$sell_list = $res['sell_list'];
|
|
foreach ($sell_list as &$val) {
|
|
if ($val['sell_type'] != 1) {
|
|
$val['subtotal'] = '-' . $val['subtotal'];
|
|
}
|
|
}
|
|
} else {
|
|
$sell_list = array();
|
|
}
|
|
$file_name = '商品销售明细';
|
|
$headArr = array(
|
|
array('index', '序号'),
|
|
array('type_name', '类型'),
|
|
array('order_no', '订单号'),
|
|
array('goods_name', '商品名称'),
|
|
array('class_name', '商品分类'),
|
|
array('goods_number', '货号'),
|
|
array('goods_code', '条码'),
|
|
array('company', '单位'),
|
|
array('purchase_price', '进价'),
|
|
array('original_price', '原单价'),
|
|
array('num', '数量'),
|
|
array('cashier_dis_money', '收银员打折金额'),
|
|
array('coupon_money', '优惠券优惠金额'),
|
|
array('integral_dis_money', '积分抵扣金额'),
|
|
array('small_changes_money', '抹零优惠金额'),
|
|
array('subtotal', '实售总价'),
|
|
array('sell_mold', '订单类型'),
|
|
array('refund_num', '退货'),
|
|
array('add_time', '交易时间'),
|
|
);
|
|
if ($supplier_type == 2) {
|
|
$headArr[17] = array('supplier_name', '供货商');
|
|
}
|
|
$str = $file_name . '导出时间' . date('Y-m-d H:i:s', time());
|
|
getExcel($file_name, $headArr, $sell_list, $str);
|
|
}
|
|
|
|
|
|
/**
|
|
* 获取数据
|
|
* @param [array] $seek_data 搜索条件
|
|
* @return [array] $res
|
|
*/
|
|
public function getSellSum()
|
|
{
|
|
ini_set('memory_limit', '-1');
|
|
// 搜索条件
|
|
$seek_data = I('post.seek_data') ? I('post.seek_data') : array();
|
|
$seek_data['start_time'] = $seek_data['seek_date'][0] ? $seek_data['seek_date'][0] : date('Y-m-01', strtotime(date("Y-m-d")));
|
|
$seek_data['end_time'] = $seek_data['seek_date'][1] ? $seek_data['seek_date'][1] : date('Y-m-d', time());
|
|
|
|
$result = $this->getPublicSellData($this->store_id, $this->merchant_id, $seek_data, 2);
|
|
if ($result['status'] == 0) {
|
|
$res = array('status' => 0, 'msg' => '暂无数据');
|
|
$this->ajaxReturn($res);
|
|
}
|
|
// 汇总
|
|
$res = $this->calculateSellSum($result['sell_list']);
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
|
|
//销售汇总2021-3-10getSellSummary
|
|
public function getSellSummary()
|
|
{
|
|
ini_set('memory_limit', '-1');
|
|
$data = I('post.');
|
|
$data['merchant_id'] = $this->merchant_id;
|
|
$data['store_id'] = $this->store_id;
|
|
$SellClass = new Sell();
|
|
$result = $SellClass->sellSummary($data);
|
|
$this->ajaxReturn($result);
|
|
}
|
|
|
|
|
|
//汇总串号列表
|
|
public function summaryList()
|
|
{
|
|
$data = I('post.');
|
|
$data['merchant_id'] = $this->merchant_id;
|
|
$data['store_id'] = $this->store_id;
|
|
$SerialClass = new SerialNumberGoods();
|
|
$result = $SerialClass->serialSummaryList($data);
|
|
$this->ajaxReturn($result);
|
|
}
|
|
|
|
|
|
/**
|
|
* 获取商品销售汇总合计
|
|
*/
|
|
public function getStoreSellTotal()
|
|
{
|
|
// 搜索条件
|
|
$seek_data = I('post.');
|
|
$result = $this->getPublicSellData_2($seek_data);
|
|
$this->ajaxReturn($result);
|
|
}
|
|
|
|
/**
|
|
* 销售汇总导出
|
|
* @param [array] $seek_data 搜索条件
|
|
*/
|
|
public function sellSumExport()
|
|
{
|
|
// 搜索条件
|
|
ini_set('memory_limit', '-1');
|
|
$data = I('get.');
|
|
$data['merchant_id'] = $this->merchant_id;
|
|
$data['store_id'] = $this->store_id;
|
|
$SellClass = new Sell();
|
|
$result = $SellClass->sellSummary($data);
|
|
$sell_sum = $result['data']['list'];
|
|
$file_name = '商品销售汇总';
|
|
$headArr = array(
|
|
array('index', '序号'),
|
|
array('goods_name', '商品名称'),
|
|
array('goods_name', '规格名称'),
|
|
array('class_name', '商品分类'),
|
|
array('goods_number', '货号'),
|
|
array('goods_code', '条码'),
|
|
array('company', '单位'),
|
|
array('sell_num', '售出数量'),
|
|
// array('sell_number', '实际数量'),//接口未统计这个字段
|
|
array('subtotal', '售出总额'),
|
|
array('purchase_price', '成本合计'),
|
|
array('profit', '利润合计'),
|
|
);
|
|
$str = $file_name . '导出时间' . date('Y-m-d H:i:s', time());
|
|
getExcel($file_name, $headArr, $sell_sum, $str);
|
|
}
|
|
|
|
/**
|
|
* 获取数据（销售公用）
|
|
* @param [int] $store_id 门店id
|
|
* @param [int] $merchant_id 商户id
|
|
* @param [array] $seek_data 搜索数据
|
|
* @param $type
|
|
* @return [array] $res
|
|
*
|
|
*/
|
|
protected function getPublicSellData($store_id, $merchant_id, $seek_data, $type)
|
|
{
|
|
/* 查看进价权限 */
|
|
$show_purch_price = I('session.global_store_jurisdiction')['showpurch_price'];
|
|
$inventory = I('session.identity');
|
|
$supplier_type = session("ls_userinfo")['supplier_type'];
|
|
// 时间搜索
|
|
if ($seek_data['start_time'] && $seek_data['end_time']) {
|
|
$start_time = strtotime($seek_data['start_time']);
|
|
$end_time = strtotime($seek_data['end_time']); //销售汇总没有时间
|
|
$map['s.add_time'] = array('between', array($start_time, $end_time));
|
|
} else if ($seek_data['start_time'] && !$seek_data['end_time']) {
|
|
$start_time = strtotime($seek_data['start_time']);
|
|
$map['s.add_time'] = array('gt', $start_time);
|
|
} else if (!$seek_data['start_time'] && $seek_data['end_time']) {
|
|
$end_time = strtotime($seek_data['end_time']);
|
|
$map['s.add_time'] = array('lt', $end_time);
|
|
}
|
|
if (!empty($seek_data['keyword'])) {
|
|
$keyword = trim($seek_data['keyword']);
|
|
if (!empty($seek_data['keyword_type'])) {
|
|
//商品销售明细
|
|
switch ($seek_data['keyword_type']) {
|
|
case 1:
|
|
//货号
|
|
$map['g.goods_number'] = ['like', '%' . $keyword . '%'];
|
|
break;
|
|
case 2:
|
|
//条码
|
|
$map['g.goods_code'] = ['like', '%' . $keyword . '%'];
|
|
break;
|
|
case 3:
|
|
//名称
|
|
$map['g.goods_name'] = ['like', '%' . $keyword . '%'];
|
|
break;
|
|
}
|
|
} else {
|
|
//其他地方调用货号、条码 商品名称
|
|
if (trim($seek_data['keyword'])) {
|
|
$map['g.goods_number|g.goods_code'] = ['like', '%' . $keyword . '%'];
|
|
}
|
|
}
|
|
}
|
|
// 分类
|
|
$GoodsClass = new GoodsClassify();
|
|
$map = $GoodsClass->getGoodsClassId($seek_data, $map, 'g.goods_class_id');
|
|
|
|
$map['s.pay_state'] = 1;
|
|
$map['s.merchant_id'] = $merchant_id;
|
|
$map['s.store_id'] = $store_id;
|
|
$field = array(
|
|
'b.order_no',
|
|
's.pay_type',
|
|
's.pay_state',
|
|
's.bill_id',
|
|
's.goods_id',
|
|
's.price',
|
|
's.num',
|
|
's.all_money',
|
|
's.use_integral',
|
|
's.add_time',
|
|
's.pay_type',
|
|
's.type',
|
|
's.purchase_price',
|
|
's.sell_type',
|
|
's.original_price',
|
|
's.refund_num',
|
|
's.goods_type',
|
|
's.sell_number',
|
|
's.cashier_dis_money',
|
|
's.coupon_money',
|
|
's.integral_dis_money',
|
|
's.small_changes_money',
|
|
's.company',
|
|
's.supplier_json',
|
|
's.id',
|
|
's.sku_json_info',
|
|
's.serial_number_state',
|
|
'g.goods_name',
|
|
'g.goods_number',
|
|
'g.goods_code',
|
|
'g.goods_class_id',
|
|
'g.company as goods_company',
|
|
'c.class_name',
|
|
);
|
|
if ($type == 1) { // 分页
|
|
$sell_list = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on s.goods_id=g.id', 'LEFT')
|
|
->join('ls_retail_goods_class as c on c.id=g.goods_class_id', 'LEFT')
|
|
->join('ls_retail_bill_order as b on b.id=s.bill_id', 'LEFT')
|
|
->field($field)
|
|
->where($map)
|
|
->page((int)I('post.page'), (int)I('post.limit'))
|
|
->order('add_time desc')
|
|
->select();
|
|
} else { // 无需分页
|
|
$sell_list = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on s.goods_id=g.id', 'LEFT')
|
|
->join('ls_retail_goods_class as c on c.id=g.goods_class_id', 'LEFT')
|
|
->join('ls_retail_bill_order as b on b.id=s.bill_id', 'LEFT')
|
|
->field($field)
|
|
->where($map)
|
|
->order('add_time desc')
|
|
->select();
|
|
}
|
|
if (!$sell_list) {
|
|
$res = array('status' => 0, 'msg' => '暂无销售数据');
|
|
return $res;
|
|
}
|
|
$total = M('retail_sell as s')->join('ls_retail_goods as g on s.goods_id=g.id', 'LEFT')->where($map)->count();
|
|
$SupplierClass = new Supplier();
|
|
$supplier_list = $SupplierClass->getList([
|
|
'user_type' => 4,
|
|
'merchant_id' => $this->merchant_id,
|
|
'store_id' => $this->store_id,
|
|
'fields' => 'id,supplier_name'
|
|
]);
|
|
$supplier_list = array_column($supplier_list, null, 'id');
|
|
foreach ($sell_list as $key => &$val) {
|
|
$val['index'] = $key + 1;
|
|
$val['goods_name'] = $val['goods_name'] ? $val['goods_name'] : '无码商品';
|
|
if (!empty($val['sku_json_info'])) {
|
|
$val['sku_name'] = json_decode($val['sku_json_info'], true)['name'];
|
|
} else {
|
|
$val['sku_name'] = '';
|
|
}
|
|
$val['goods_number'] = $val['goods_number'] ? $val['goods_number'] : '无';
|
|
$val['goods_code'] = $val['goods_code'] ? $val['goods_code'] : '无';
|
|
$val['type_name'] = $val['type'] == 1 ? '商城' : '店内';
|
|
$val['add_time'] = date('Y-m-d H:i:s', $val['add_time']);
|
|
$val['class_name'] = $val['class_name'] ? $val['class_name'] : '无';
|
|
// 订单类型
|
|
if ($val['sell_type'] == 1) {
|
|
$val['sell_mold'] = '销售订单';
|
|
} else if ($val['sell_type'] == 2) {
|
|
$val['sell_mold'] = '退款订单';
|
|
} else {
|
|
$val['sell_mold'] = '未知订单';
|
|
}
|
|
$val['purch_price'] = strval($val[' purchase_price']);
|
|
$val['yuan_price'] = strval($val['original_price']);
|
|
$val['price'] = strval($val['price']);
|
|
$val['num'] = strval($val['num']);
|
|
$val['cashier_dis_money'] = strval($val['cashier_dis_money']);
|
|
$val['coupon_money'] = strval($val['coupon_money']);
|
|
$val['integral_dis_money'] = strval($val['integral_dis_money']);
|
|
$val['small_changes_money'] = strval($val['small_changes_money']);
|
|
$val['subtotal'] = strval($val['all_money']);
|
|
$val['refund_num'] = $val['refund_num'] && $val['refund_num'] != 0 ? floatval($val['refund_num']) : '无';
|
|
/* 判断权限 */
|
|
if ($inventory == 2 && $show_purch_price == 2) {
|
|
$val['purchase_price'] = '***';
|
|
}
|
|
$val['supplier_name'] = '';
|
|
if ($supplier_type == 2 && !empty($val['supplier_json']) && !empty($supplier_list)) {
|
|
$purchase_id_str = json_decode($val['supplier_json'], true);
|
|
$supplier = array_column($purchase_id_str, "supplier_id");
|
|
array_unique($supplier);
|
|
if (!empty($supplier)) {
|
|
foreach ($supplier as $k => $v) {
|
|
$val['supplier_name'] .= $supplier_list[$v]['supplier_name'] . ',';
|
|
}
|
|
$val['supplier_name'] = trim($val['supplier_name']);
|
|
}
|
|
}
|
|
}
|
|
$res = array('status' => 1, 'sell_list' => $sell_list, 'total' => (int)$total);
|
|
return $res;
|
|
}
|
|
|
|
|
|
//串号列表
|
|
public function sellSerialList()
|
|
{
|
|
$data = I('post.');
|
|
$SerialClass = new SerialNumberGoods();
|
|
$result = $SerialClass->sellSerialList($data);
|
|
$result['sell_sum'] = $result['data'];
|
|
$this->ajaxReturn($result);
|
|
}
|
|
|
|
|
|
/**
|
|
* 获取销售汇总统计数据合计
|
|
* @param [array] $seek_data 搜索数据
|
|
* @return [array] $res
|
|
*
|
|
*/
|
|
protected function getPublicSellData_2($seek_data)
|
|
{
|
|
// 时间搜索
|
|
if (!empty($seek_data['time']) && $seek_data['time'] != 'null') {
|
|
if (!is_array($seek_data['time'])) {
|
|
$time = explode(',', $seek_data['time']);
|
|
} else {
|
|
$time = $seek_data['time'];
|
|
}
|
|
$start_time = strtotime($time[0]);
|
|
$end_time = strtotime($time[1]);
|
|
} else {
|
|
$start_time = strtotime(date('Y-m-01 00:00:00'));
|
|
$end_time = time();
|
|
}
|
|
$map['s.add_time'] = ['between', [$start_time, $end_time]];
|
|
if (!empty($seek_data['keyword'])) {
|
|
$keyword = trim($seek_data['keyword']);
|
|
if (!empty($seek_data['keyword_type'])) {
|
|
//商品销售明细
|
|
switch ($seek_data['keyword_type']) {
|
|
case 1:
|
|
//货号
|
|
$map['g.goods_number'] = ['like', '%' . $keyword . '%'];
|
|
break;
|
|
case 2:
|
|
//条码
|
|
$map['g.goods_code'] = ['like', '%' . $keyword . '%'];
|
|
break;
|
|
case 3:
|
|
//名称
|
|
$map['g.goods_name'] = ['like', '%' . $keyword . '%'];
|
|
break;
|
|
}
|
|
} else {
|
|
//其他地方调用货号、条码 商品名称
|
|
if (trim($seek_data['keyword'])) {
|
|
$map['g.goods_number|g.goods_code'] = ['like', '%' . $keyword . '%'];
|
|
}
|
|
}
|
|
}
|
|
// 分类
|
|
|
|
$class_id = getGoodsClass($seek_data['person1'], $seek_data['person2'], $seek_data['person3']);
|
|
if ($class_id) {
|
|
$map['g.goods_class_id'] = $class_id;
|
|
}
|
|
|
|
$map['s.pay_state'] = 1;
|
|
$map['s.merchant_id'] = $this->merchant_id;
|
|
$map['s.store_id'] = $this->store_id;
|
|
|
|
$field = array(
|
|
's.sell_type',
|
|
's.num',
|
|
's.all_money',
|
|
);
|
|
$sell_list = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on s.goods_id=g.id', 'LEFT')
|
|
->join('ls_retail_goods_class as c on c.id=g.goods_class_id', 'LEFT')
|
|
->join('ls_retail_bill_order as b on b.id=s.bill_id', 'LEFT')
|
|
->field($field)
|
|
->where($map)
|
|
->order('s.add_time desc')
|
|
->select();
|
|
if (empty($sell_list)) {
|
|
$res = ['moneyTotal' => 0, 'numTotal' => 0];
|
|
} else {
|
|
$moneyTotal = 0; // 合计金额
|
|
$numTotal = 0; // 合计数量
|
|
|
|
foreach ($sell_list as $value) {
|
|
if ($value['sell_type'] == 1) {
|
|
$moneyTotal += $value['all_money'];
|
|
$numTotal += $value['num'];
|
|
} else {
|
|
$numTotal -= $value['num'];
|
|
$moneyTotal -= $value['all_money'];
|
|
}
|
|
}
|
|
$res = ['numTotal' => round($numTotal, 2), 'moneyTotal' => round($moneyTotal, 2)];
|
|
}
|
|
return callBack(statusCode()['success'], '获取成功', $res);
|
|
}
|
|
|
|
/**
|
|
* 获取数据（畅销商品私用）
|
|
* @param [int] $store_id 门店id
|
|
* @param [int] $merchant_id 商户id
|
|
* @param [array] $seek_data 搜索数据
|
|
* @param [int] $page 页数
|
|
* @param [int] $limit 条数
|
|
* @return [array] $res
|
|
*
|
|
*/
|
|
private function getPrivateInfoData($store_id, $merchant_id, $seek_data, $page = 0, $limit = 0)
|
|
{
|
|
// 时间搜索
|
|
if ($seek_data['start_time'] && $seek_data['end_time']) {
|
|
$start_time = strtotime($seek_data['start_time'] . "00:00:00");
|
|
$end_time = strtotime($seek_data['end_time'] . "23:59:59"); //销售汇总没有时间
|
|
$start_time = $start_time ? $start_time : strtotime($seek_data['start_time']);
|
|
$end_time = $end_time ? $end_time : strtotime($seek_data['end_time']); //销售明细有时间
|
|
|
|
$map['s.add_time'] = array('between', array($start_time, $end_time));
|
|
} else if ($seek_data['start_time'] && !$seek_data['end_time']) {
|
|
$start_time = strtotime($seek_data['start_time']);
|
|
$map['s.add_time'] = array('gt', $start_time);
|
|
} else if (!$seek_data['start_time'] && $seek_data['end_time']) {
|
|
$end_time = strtotime($seek_data['end_time']);
|
|
$map['s.add_time'] = array('lt', $end_time);
|
|
}
|
|
// 货号、商品名称、条码
|
|
if (trim($seek_data['keyword'])) {
|
|
$map['g.goods_number|g.goods_name|g.goods_code'] = ['like', '%' . trim($seek_data['keyword']) . '%'];
|
|
}
|
|
$map['s.pay_type'] = array('neq', 0);
|
|
$map['s.pay_state'] = 1;
|
|
$map['s.merchant_id'] = $merchant_id;
|
|
$map['s.store_id'] = $store_id;
|
|
$GoodsClassify = new GoodsClassify();
|
|
$map = $GoodsClassify->getGoodsClassId($seek_data, $map, 's.goods_class_id');
|
|
|
|
$field = array(
|
|
's.pay_state',
|
|
's.bill_id',
|
|
's.goods_id',
|
|
's.add_time',
|
|
's.pay_type',
|
|
's.sell_type',
|
|
'sum(CASE WHEN s.sell_type = 1 THEN s.num ELSE 0 END) - sum(CASE WHEN s.sell_type = 2 THEN s.num ELSE 0 END) as num',
|
|
's.supplier_json',
|
|
'g.goods_name',
|
|
'g.goods_number',
|
|
'g.goods_code',
|
|
'g.goods_class_id',
|
|
'g.company as goods_company',
|
|
'c.class_name',
|
|
);
|
|
if ($seek_data['sort_type'] == 1) {
|
|
$order = 'num asc';
|
|
} else {
|
|
$order = 'num desc';
|
|
}
|
|
$sell_list = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on s.goods_id=g.id', 'LEFT')
|
|
->join('ls_retail_goods_class as c on c.id=g.goods_class_id', 'LEFT')
|
|
->group('goods_id')
|
|
->field($field)
|
|
->where($map)
|
|
->page((int)$page, (int)$limit)
|
|
->order($order)
|
|
->select();
|
|
if (!$sell_list) {
|
|
$res = array('status' => 0, 'msg' => '暂无畅销数据');
|
|
return $res;
|
|
}
|
|
$total = M('retail_sell as s')
|
|
->join('ls_retail_goods as g on s.goods_id=g.id', 'LEFT')
|
|
->where($map)
|
|
->count('distinct(goods_id)');
|
|
foreach ($sell_list as &$val) {
|
|
$val['goods_name'] = $val['goods_name'] ? $val['goods_name'] : '无码商品';
|
|
$val['goods_number'] = $val['goods_number'] ? $val['goods_number'] : '无';
|
|
$val['goods_code'] = $val['goods_code'] ? $val['goods_code'] : '无';
|
|
$val['class_name'] = $val['class_name'] ? $val['class_name'] : '无';
|
|
}
|
|
$res = array('status' => 1, 'sell_list' => $sell_list, 'total' => (int)$total);
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 计算汇总
|
|
* @param [array] $sell_list 销售数据
|
|
* @return [array] $res
|
|
*/
|
|
protected function calculateSellSum($sell_list)
|
|
{
|
|
$sell_sum = array();
|
|
$index = 1;
|
|
foreach ($sell_list as &$val) {
|
|
if (!$sell_sum[$val['goods_id']]) {
|
|
$sell_num = 0;
|
|
$sell_number = 0;
|
|
$subtotal = 0;
|
|
if ($val['sell_type'] == 1) {
|
|
$sell_num += $val['num'];
|
|
$sell_number += $val['sell_number'];
|
|
$subtotal += floatval($val['all_money']);
|
|
} else {
|
|
$sell_num -= $val['num'];
|
|
$sell_number -= $val['sell_number'];
|
|
$subtotal -= floatval($val['all_money']);
|
|
}
|
|
$arr = array(
|
|
'index' => $index++,
|
|
'goods_name' => $val['goods_name'],
|
|
'goods_number' => $val['goods_number'],
|
|
'goods_code' => $val['goods_code'],
|
|
'class_name' => $val['class_name'],
|
|
'sell_num' => $sell_num,
|
|
'sell_number' => $sell_number,
|
|
'subtotal' => $subtotal,
|
|
'company' => $val['goods_company']
|
|
);
|
|
$sell_sum[$val['goods_id']] = $arr;
|
|
unset($arr);
|
|
} else {
|
|
if ($val['sell_type'] == 1) { // 销售订单
|
|
$sell_sum[$val['goods_id']]['sell_num'] += $val['num'];
|
|
$sell_sum[$val['goods_id']]['sell_number'] += $val['sell_number'];
|
|
$sell_sum[$val['goods_id']]['subtotal'] += floatval($val['all_money']);
|
|
} else { // 退款订单
|
|
$sell_sum[$val['goods_id']]['sell_num'] -= $val['num'];
|
|
$sell_sum[$val['goods_id']]['sell_number'] -= $val['sell_number'];
|
|
$sell_sum[$val['goods_id']]['subtotal'] -= floatval($val['all_money']);
|
|
}
|
|
}
|
|
}
|
|
$res = array('status' => 1, 'sell_sum' => array_values($sell_sum), 'total' => (int)count($sell_sum));
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 计算汇总
|
|
* @param [array] $sell_list 销售数据
|
|
* @param [int] $total 总计
|
|
* @return [array] $res
|
|
*/
|
|
protected function calculateSellSum_2($sell_list, $total)
|
|
{
|
|
$sell_sum = array();
|
|
foreach ($sell_list as $key => &$val) {
|
|
if (!$sell_sum[$val['goods_id']]) {
|
|
$arr = array(
|
|
'goods_name' => $val['goods_name'],
|
|
'goods_number' => $val['goods_number'],
|
|
'goods_code' => $val['goods_code'],
|
|
'class_name' => $val['class_name'],
|
|
'sell_num' => (float)$val['num'],
|
|
'index' => $key + 1,
|
|
);
|
|
$sell_sum[$val['goods_id']] = $arr;
|
|
unset($arr);
|
|
} else {
|
|
if ($val['sell_type'] == 1) { // 销售订单
|
|
$sell_sum[$val['goods_id']]['sell_num'] += $val['num'];
|
|
} else { // 退款订单
|
|
$sell_sum[$val['goods_id']]['sell_num'] -= $val['num'];
|
|
}
|
|
}
|
|
}
|
|
$res = array('status' => 1, 'sell_sum' => array_values($sell_sum), 'total' => (int)$total);
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 获取其他支付类型
|
|
*/
|
|
public function getOtherPayType()
|
|
{
|
|
// 获取商户id
|
|
$merchant_id = M('retail_store')->where(['id' => $this->store_id])->getField('merchantid');
|
|
if (!$merchant_id) {
|
|
$res = array('status' => 0, 'msg' => '商户查询失败');
|
|
$this->ajaxReturn($res);
|
|
}
|
|
// 查询其他支付
|
|
// 查询其他支付方式
|
|
$OtherPay = D('RetailOtherPay');
|
|
$other_map = array(
|
|
$OtherPay::MERCHANT_ID => $merchant_id,
|
|
$OtherPay::STATUS => 1,
|
|
$OtherPay::STATE => 1
|
|
);
|
|
$other_field = array(
|
|
$OtherPay::ID, $OtherPay::NAME
|
|
);
|
|
$other_pay = $OtherPay->getSelect($other_map, $other_field, $OtherPay::PAY_ORDER . ' asc');
|
|
$other_pay = !empty($other_pay) ? $other_pay : array();
|
|
$res = array(
|
|
'status' => 1,
|
|
'other_pay' => $other_pay
|
|
);
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
/**
|
|
* 写入表格 把表格保存在服务器
|
|
* @param $expTitle
|
|
* @param $expCellName
|
|
* @param $expTableData
|
|
* @param string $common
|
|
* @param string $directory_name
|
|
* @throws \PHPExcel_Exception
|
|
* @throws \PHPExcel_Reader_Exception
|
|
* @throws \PHPExcel_Writer_Exception
|
|
*/
|
|
private function setExcel($expTitle, $expCellName, $expTableData, $common = "", $directory_name = "./Public")
|
|
{
|
|
$fileName = $expTitle; //or $xlsTitle 文件名称可根据自己情况设定
|
|
$cellNum = count($expCellName);
|
|
$dataNum = count($expTableData);
|
|
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);
|
|
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);
|
|
}
|
|
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
|
|
|
|
$this->createDir($directory_name); //生成文件目录
|
|
$path = "{$directory_name}/{$fileName}.xls";
|
|
$objWriter->save($path);
|
|
}
|
|
|
|
/**
|
|
* 生成文件目录
|
|
* @param $directory_name 目录地址
|
|
*/
|
|
private function createDir($directory_name)
|
|
{
|
|
if (!is_dir($directory_name)) {
|
|
$temp = ltrim($directory_name, './');
|
|
$arr = explode('/', $temp);
|
|
$str = './';
|
|
foreach ($arr as $key => $sv) {
|
|
if (!is_dir("{$str}/{$sv}")) {
|
|
mkdir("{$str}/{$sv}", 0777);
|
|
}
|
|
$str = "{$str}/{$sv}";
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
/**
|
|
* 获取订单的支付流水表的数据列表
|
|
*/
|
|
public function getOrderPayDetails()
|
|
{
|
|
$PayOrder = new PayOrder();
|
|
$this->ajaxReturn($PayOrder->getBillPayList([
|
|
'merchant_id' => $this->merchant_id,
|
|
'store_id' => $this->store_id,
|
|
'order_no' => I('post.order_no'),
|
|
]));
|
|
}
|
|
}
|