churen/service/agent/lib/Dhorder.php

<?php

namespace Agent\Lib;

use Dever;

class Dhorder
{
    # 获取配置
    public $config = array();
    # table
    public $table = 'agent/dh_order';

    public function __construct()
    {
        $this->config = Dever::db($this->table)->config;
    }

    # 设置订单的类型
    public function set($type, $view)
    {

        return $this;
    }

    # 获取公共的where
    public function where($id)
    {
        $where = array();
        $where['mid'] = $id;
        if (!$where) {
            Dever::alert('参数错误');
        }

        return $where;
    }

    # 获取订单列表
    public function getList($id)
    {
        $result = array();
        $where = $this->where($id);
        $mobile = Dever::input('mobile');
        if ($mobile) {
            $where['mobile'] = $mobile;
        }
        $status = Dever::input('status');
        if ($status) {
            $where['status'] = $status;
        }

        $result['order'] = Dever::db($this->table)->getAll($where);

        if ($result['order']) {
            foreach ($result['order'] as $k => $v) {
                $result['order'][$k] = $this->getInfo($v, false);
            }
        }

        return $result;
    }

    # 查看详情
    public function getView($id, $order_id, $show = true)
    {
        $where = $this->where($id);
        $where['id'] = $order_id;

        $result = Dever::db($this->table)->find($where);

        if (!$result) {
            Dever::alert('订单不存在');
        }

        if ($show) {
            $result = $this->getInfo($result);
        }

        return $result;
    }

    # 获取订单详细信息
    public function getInfo($info, $view = true)
    {
        $info['status_name'] = Dever::status($this->config['status'], $info['status']);

        $info['cdate'] = date('Y-m-d H:i', $info['cdate']);

        if ($info['operdate']) {
            $info['operdate'] = date('Y-m-d H:i', $info['operdate']);
        } else {
            $info['operdate'] = '';
        }

        if ($info['fdate']) {
            $info['fdate'] = date('Y-m-d H:i', $info['fdate']);
        } else {
            $info['fdate'] = '';
        }


        if ($view && $info['type'] == 1) {
        	$info['ps_info'] = Dever::db('agent/dh_order_ps')->find(array('order_id' => $info['id']));
	        if ($info['ps_info']) {
	            $info['ps_info']['service'] = Dever::array_decode($info['ps_info']['service']);
	            $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
	            if ($info['ps_info']['qu_date']) {
	                $info['ps_info']['qu_date'] = date('Y-m-d H:i', $info['ps_info']['qu_date']);
	            }
	            if ($info['ps_info']['qs_date']) {
	                $info['ps_info']['qs_date'] = date('Y-m-d H:i', $info['ps_info']['qs_date']);
	            }

	            $status = Dever::db('agent/dh_order_ps')->config['status'];
	            $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
	            if ($info['ps_info']['service']) {
	                foreach ($info['ps_info']['service'] as $k => $v) {
	                	if (isset($v['order_num']) && $v['order_num']) {
	                		$info['ps_info']['service'][$k]['service_name'] = '商家自送';
		                    if ($v['service_id'] > 0) {
		                        $service = Dever::db('shop/service')->find($v['service_id']);
		                        $info['ps_info']['service'][$k]['service_name'] = $service['name'];
		                    }
	                	} else {
	                		unset($info['ps_info']['service'][$k]);
	                	}
	                }
	            }
	        }

        	$goods_status = Dever::db('agent/dh_order_goods')->config['status'];
	        if ($info['address_id']) {
	            $info['address'] = Dever::db('agent/member_address')->find($info['address_id']);
	        }

	        $info['goods'] = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id']));
	        foreach ($info['goods'] as $k => $v) {
	        	$goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
                if (isset($goods_info['sku'])) {
                    $sku = $goods_info['sku']['string'];
                } else {
                    $sku = '';
                }
                $info['goods'][$k] += array
                (
                    'pic' => $goods_info['cover'],
                    'name' => $goods_info['name'],
                    'sku' => $sku,
                    'price' => $goods_info['price'],
                );
	        }
        }
        if ($info['type'] == 2) {
            $info['card'] = Dever::db('card/info')->find($info['type_id']);
        }
        if ($info['type'] == 3) {
            $info['prize'] = Dever::db('setting/prize')->find($info['type_id']);
        }

        return $info;
    }

    # 取消订单
    public function cancel($id, $order_id)
    {
        $data = $this->getView($id, $order_id, false);
        if ($data['status'] == 1) {
            $state = Dever::db('agent/dh_order')->update(array('where_id' => $data['id'], 'status' => 7, 'operdate' => time()));
            if ($state) {
                $this->updateSell($data, 2);
            }

            return 'ok';
        } else {
            Dever::alert('当前订单状态不允许取消');
        }
    }

    # 得到商品和总价
    public function goods($mid)
    {
        $goods_id = Dever::input('goods_id');
        if (!$goods_id) {
            Dever::alert('请传入商品');
        }
        $goods_id = explode(',', $goods_id);
        
        $num = Dever::input('num');
        if (!$num) {
            Dever::alert('请传入商品数量');
        }
        $num = explode(',', $num);

        $data['price'] = 0;
        $data['num'] = 0;
        $data['name'] = array();
        $count = count($goods_id);
        $data['list'] = array();
        $i = 0;
        foreach ($goods_id as $k => $v) {
            $n = isset($num[$k]) ? $num[$k] : 1;

            $data['list'][$i] = Dever::db('agent/member_goods')->find(array('mid' => $mid, 'id' => $v));

            if ($data['list'][$i]) {
            	$data['list'][$i]['num'] = $n;

	            # 2是库存不足
	            $data['list'][$i]['ku_state'] = 1;

            	$total = $data['list'][$i]['total_num'] - $data['list'][$i]['sell_num'];
            	if ($total >= $n) {
            		$data['list'][$i]['buy_num'] = $n;
            	} else {
            		$data['list'][$i]['buy_num'] = $total;
            	}

            	if ($data['list'][$i]['buy_num'] <= 0) {
	                $data['list'][$i]['ku_state'] = 2;
	                $data['list'][$i]['buy_num'] = 0;
	            }

            	$goods_info = Dever::load('goods/lib/info')->getInfoBySku($data['list'][$i]['type_id'], $data['list'][$i]['sku_id']);
                if (isset($goods_info['sku'])) {
                    $sku = $goods_info['sku']['string'];
                } else {
                    $sku = '';
                }
                $data['list'][$i] += array
                (
                    'pic' => $goods_info['cover'],
                    'name' => $goods_info['name'],
                    'sku' => $sku,
                    'price' => $goods_info['price'],
                );

                if ($data['list'][$i]['ku_state'] == 1) {
	                $data['num'] += $data['list'][$i]['buy_num'];
	                $data['price'] += $goods_info['price'] * $data['list'][$i]['buy_num'];
	                $data['name'] = '兑换商品';
	            }

                $i++;
            }
        }

        if ($data['num'] <= 0) {
            Dever::alert('没有商品可以兑换');
        }
        return $data;
    }

    # 确认兑换
	public function action($user, $name, $num, $price, $goods, $address_id, $dh_type, $type, $type_id, $info, $refer = '')
    {
    	# 获取平台店
    	$shop = Dever::db('shop/info')->find(array('type' => 10));
    	if (!$shop) {
    		Dever::alert('没有平台店');
    	}
        $order_data['shop_id'] = $shop['id'];
        $order_data['mid'] = $user['id'];
        $order_data['mobile'] = $user['mobile'];
        $order_data['address_id'] = $address_id;
        $order_data['name'] = $name;
        $order_data['num'] = $num;
        $order_data['info'] = $info;
        $order_data['price'] = $price;
        $order_data['dh_type'] = $dh_type;
        $order_data['type'] = $type;
        if ($type_id) {
            $order_data['type_id'] = $type_id;
        }
        if ($dh_type == 2) {
            $order_data['status'] = 5;
        } else {
            $order_data['status'] = 2;
        }
        
        $order_data['refund_cash'] = 0;
        $order_data['audit'] = 2;

        $order_data['order_num'] = $this->getOrderId();
        $id = Dever::db('agent/dh_order')->insert($order_data);

        if (!$id) {
            Dever::alert('兑换失败');
        }

        if ($goods) {
            foreach($goods as $k => $v) {
                if ($v['ku_state'] == 1) {
                    $data['mid'] = $user['id'];
                    $data['order_id'] = $id;
                    $data['shop_id'] = $shop['id'];
                    $data['goods_id'] = $v['type_id'];
                    $data['sku_id'] = $v['sku_id'];
                    $data['price'] = $v['price'];
                    $data['num'] = $v['buy_num'];

                    Dever::db('agent/dh_order_goods')->insert($data);
                }
            }
        }

        # 减少库存 增加销量
        $order_data['id'] = $id;
        $this->updateSell($order_data);
    	return array
        (
            'order_num' => $order_data['order_num'],
            'order_id' => $id,
            'type' => 'dh',
        );
    }

    # 添加配送信息
    public function updatePs($order, $status = 1, $service_id = -1, $order_num = '')
    {
        $where['order_id'] = $order['id'];
        $where['clear'] = true;
        $data = Dever::db('agent/dh_order_ps')->find($where);

        $service = array();
        if ($service_id) {
            $service['service_id'] = $service_id;
        }
        if ($order_num) {
            $service['order_num'] = $order_num;
        }
        if (!$data) {
            $insert = $where;
            if ($service) {
                $insert['service'][] = $service;
                $insert['service'] = Dever::array_encode($insert['service']);
            }
            $insert['status'] = $status;
            if ($status == 2) {
                $insert['qu_date'] = time();
            }
        
            Dever::db('agent/dh_order_ps')->insert($insert);
        } else {
            $update = $where;
            $update['where_id'] = $data['id'];
            $update['status'] = $status;
            if ($status == 2) {
                $update['qu_date'] = time();
            }
            if ($status == 3) {
                $update['qs_date'] = time();
            }
            if ($service) {
                $data['service'] = Dever::array_decode($data['service']);
                $update['service'] = $data['service'];
                $update['service'][] = $service;

                $insert['service'] = Dever::array_encode($update['service']);
            }
            Dever::db('agent/dh_order_ps')->update($update);
        }
    }

    # 减少库存，增加销量
    public function updateSell($order, $type = 1)
    {
        $method = 'incSell';
        $name = '兑换商品';
        $name_3 = '兑换名额';
        if ($type == 2) {
            $method = 'decSell';
            $name = '退回商品';
            $name_3 = '退回名额';
        }
        if ($order['type'] == 1) {
            $where['order_id'] = $order['id'];
            //$where['status'] = 3;
            $data = Dever::db('agent/dh_order_goods')->select($where);
            if ($data) {

                foreach ($data as $k => $v) {
                    $up = array();
                    $up['where_mid'] = $order['mid'];
                    $up['where_type'] = $order['type'];
                    $up['where_type_id'] = $v['goods_id'];
                    $up['where_sku_id'] = $v['sku_id'];
                    $up['clear'] = true;

                    $info = Dever::db('agent/member_goods')->findData($up);

                    $up['set_sell_num'] = $v['num'];
                    Dever::db('agent/member_goods')->$method($up);

                    if ($type == 2) {
                        Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']+$up['set_sell_num'], $info['name'], $name);
                    } else {
                        Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']-$up['set_sell_num'], $info['name'], $name);
                    }
                    
                }
            }
        } elseif ($order['type'] == 3) {
            $up['where_mid'] = $order['mid'];
            $up['where_type'] = $order['type'];
            $up['where_type_id'] = $order['type_id'];
            $up['where_sku_id'] = -1;
            $info = Dever::db('agent/member_goods')->findData($up);
            $up['set_sell_num'] = $order['num'];
            Dever::db('agent/member_goods')->$method($up);

            if ($type == 2) {
                Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']+$up['set_sell_num'], $info['name'], $name_3);
            } else {
                Dever::load('agent/lib/member_set')->log($up['where_mid'], '', $up['where_type'], $up['where_type_id'], $up['where_sku_id'], $up['set_sell_num'], $info['num'], $info['num']-$up['set_sell_num'], $info['name'], $name_3);
            }
            
        }
    }

    # 完成
    public function finish($info, $shop_id)
    {
        if ($info && $info['shop_id'] == $shop_id && $info['status'] <= 4) {

            $status = 5;
            $state = Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'status' => $status, 'fdate' => time()));

            $this->updatePs($info, 3);

            $w['parent_type'] = 3;
            $w['parent_order_id'] = $info['id'];
            $w['status'] = 4;
            $buy_order = Dever::db('shop/buy_order')->select($w);
            if ($buy_order) {
                foreach ($buy_order as $k => $v) {
                    Dever::load('mshop/lib/buy')->set(1,1)->finish($shop_id, $v['id']);
                }
            }
            return 'ok';
        } else {
            Dever::alert('您没有权限核销');
        }
    }

    # 平台订单已收货
    public function yes_api()
    {
        $shop_id = Dever::input('shop_id');
        $order_id = Dever::input('order_id');

        $info = Dever::db('agent/dh_order')->find(array('id' => $order_id));

        if ($info && $info['type'] == 10) {
            $this->finish($info, $shop_id);
        } else {
            Dever::alert('您没有权限核销');
        }

        return 'reload';
    }

    # 生成订单号
    public function getOrderId()
    {
        $where['order_num'] = Dever::order('DH');
        $state = Dever::db('agent/dh_order')->one($where);
        if (!$state) {
            return $where['order_num'];
        } else {
            return $this->getOrderId();
        }
    }

    # 展示订单详情
    public function show()
    {
        $id = Dever::input('order_id');

        $config = Dever::db('agent/dh_order')->config;

        $info = Dever::db('agent/dh_order')->one($id);

        if ($info['type'] > 1) {
            return;
        }

        $tk_status = Dever::db('agent/dh_order_refund')->config['status'];
        $tk_process = Dever::db('agent/dh_order_refund')->config['process'];

        $status = $config['status'][$info['status']];

        $tk = Dever::db('agent/dh_order_refund')->find(array('order_id' => $info['id'], 'type' => 1));

        $shop = Dever::db('shop/info')->find($info['shop_id']);

        $user = Dever::db('agent/member')->find($info['mid']);

        $cdate = date('Y-m-d H:i', $info['cdate']);
        if ($info['operdate']) {
            $opertime = date('Y-m-d H:i', $info['operdate']);
        } else {
            $opertime = '';
        }

        if ($info['fdate']) {
            $fdate = date('Y-m-d H:i', $info['fdate']);
        } else {
            $fdate = '';
        }

        if (!$user) {
            $user['username'] = '无';
        }
        if (!isset($user['name'])) {
            $user['truename'] = $user['name'];
        }

        if ($tk && $tk['process'] == 1) {
            $status = '申请' . $tk_status[$tk['status']];
            $process = $tk_process[$tk['process']];
            $process = '';
        }

        $time = array();
        $time[] = array('下单时间', $cdate);

        if ($opertime) {
            if ($info['status'] == 2) {
                $time[] = array('通知时间', $opertime);
            }
            if ($info['status'] == 7) {
                $time[] = array('取消时间', $opertime);
            }
        }

        if ($fdate) {
            $time[] = array('完成时间', $fdate);
        }

        $time[] = array('审核备注', $info['audit_desc']);

        $result = array();

        $result[$info['order_num']] = array
        (
            'type' => 'info',
            'content' => array
            (
                array
                (
                    array('订单状态', $status),
                    array('代理商姓名', $user['name']),
                    array('联系电话', $info['mobile']),
                ),

                $time,
            )
        );

        if ($info['address_id'] > 0) {
            $address = Dever::load('agent/address')->getOne($info['mid'], $info['address_id']);

            if ($address) {

                $result['收货地址'] = array
                (
                    'type' => 'info',
                    'content' => array
                    (
                        array
                        (
                            array('联系人', $address['contact']),
                            array('联系电话', $address['mobile']),
                        ),

                        array
                        (
                            array('收货地址', $address['address_info']),
                            array('门牌号', $address['house_number']),
                        ),
                    ),
                );
            }
        }

        $info['ps_info'] = Dever::db('agent/dh_order_ps')->find(array('order_id' => $info['id']));
        if ($info['ps_info']) {
            $info['ps_info']['service'] = Dever::array_decode($info['ps_info']['service']);
            $info['ps_info']['cdate'] = date('Y-m-d H:i', $info['ps_info']['cdate']);
            if ($info['ps_info']['qs_date']) {
                $info['ps_info']['qs_date'] = date('Y-m-d H:i', $info['ps_info']['qs_date']);
            } else {
                $info['ps_info']['qs_date'] = '无';
            }

            $status = Dever::db('agent/dh_order_ps')->config['status'];
            $info['ps_info']['status_name'] = $status[$info['ps_info']['status']];
            
            $service = array();
            if ($info['ps_info']['service']) {
                foreach ($info['ps_info']['service'] as $k => $v) {
                	if (isset($v['order_num']) && $v['order_num']) {
                		$info['ps_info']['service'][$k]['service_name'] = '商家自送';
	                    if ($v['service_id'] > 0) {
	                        $service_info = Dever::db('shop/service')->find($v['service_id']);
	                        $info['ps_info']['service'][$k]['service_name'] = $service_info['name'];
	                    }

	                    $service[] = array
	                    (
	                        array('名称', $info['ps_info']['service'][$k]['service_name']),
	                        array('单号', isset($v['order_num']) ? $v['order_num'] : ''),
	                    );
                	}
                }
            }

            $result['物流信息'] = array
            (
                'type' => 'info',
                'content' => array
                (
                    array
                    (
                        array('发货时间', $info['ps_info']['cdate']),
                        array('收货时间', $info['ps_info']['qs_date']),
                        array('查单', '<a href="https://www.kuaidi100.com/?from=openv" target="_blank">点此手动查单</a>'),
                    ),
                ),
            );
            $result['物流信息']['content'] = array_merge($result['物流信息']['content'], $service);
        }


        if (!$info['refund_cash']) {
            $info['refund_cash'] = 0;
        }

        if ($info['refund_cash'] > 0 && $tk) {
            $process = $tk_process[$tk['process']];
            $tk['cdate'] = date('Y-m-d H:i', $tk['cdate']);
            $result['退款信息'] = array
            (
                'type' => 'info',
                'content' => array
                (
                    array
                    (
                        array('退款金额', $info['refund_cash']),
                        array('数量', $info['num']),
                        array('退款进度', $process),
                    ),

                    array
                    (
                        array('申请时间', $tk['cdate']),
                        array('退款原因', $tk['desc']),
                    ),
                ),
            );
        }

        $body = $refund_body = array();
        $body_total = array();
        $body_total['price'] = 0;
        $body_total['num'] = 0;

        $refund_body_total = array();
        $refund_body_total['price'] = 0;
        $refund_body_total['num'] = 0;

        $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id']));
        $goods_status = Dever::db('agent/dh_order_goods')->config['status'];

        foreach ($goods as $k => $v) {
            $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
            $status = Dever::status($goods_status, $v['status']);
            $tk = Dever::db('agent/dh_order_refund')->find(array('order_id' => $info['id'], 'order_goods_id' => $v['id'], 'type' => 2));
            if ($tk && $tk['process'] == 1) {
                $status = '申请' . $tk_status[$tk['status']];
                //$status .= '&nbsp;&nbsp;[' . $tk_process[$tk['process']] . ']';
            }
            if (isset($goods_info['sku'])) {
                $sku = $goods_info['sku']['string'];
            } else {
                $sku = '无';
            }

            if ($info['status'] > 1 && $info['status'] < 7) {
                $tui = Dever::url('buy_order_tui?shop_id='.$v['shop_id'].'&order_goods_id=' . $v['id'] . '&order_id=' . $info['id'] . '&cash=' . $v['price'], 'shop');

                $status = '<a href="javascript:;" onclick="fastEdit($(this), \''.$tui.'\', \'退款\', \'\', 1)" class="layui-btn">退款</a>';
                $status = '';
            }

            $d = array
            (
                'pic' => $goods_info['cover'],
                'name' => $goods_info['name'],
                'sku' => $sku,
                'price' => $v['price'],
                'num' => $v['num'],
                'status' => $status,
            );

            if ($tk && $v['status'] == 3) {
                $d['status'] = $tk_status[$tk['status']];
                $refund_body[] = $d;
                $price = $v['price']*$v['num'];
                $refund_body_total['price'] += $price;
                $refund_body_total['num'] += $v['num'];
            } else {
                $body[] = $d;
                $price = $v['price']*$v['num'];
                $body_total['price'] += $price;
                $body_total['num'] += $v['num'];
            }
        }

        if ($body) {
            if ($refund_body_total['price']) {
                $body_total['set_price'] = $body_total['price'] - $refund_body_total['price'];
            }
            if ($refund_body_total['num']) {
                $body_total['set_num'] = $body_total['num'] - $refund_body_total['num'];
            }

            $result['商品清单'] = array
            (
                'type' => 'list',
                'content' => $body,
                'total' => $body_total,
            );
        }

        if ($refund_body) {
            $result['退款商品'] = array
            (
                'type' => 'list',
                'content' => $refund_body,
                'total' => $refund_body_total,
            );
        }

        # 平台门店采购单
        $buy_order = Dever::db('shop/buy_order')->getDataToId(array('type' => 1, 'type_id' => $info['shop_id'], 'parent_type' => 3, 'parent_order_id' => $info['id']));
        $source_order_id = array();
        if ($buy_order) {
            $source_order_id = array_keys($buy_order);
        }

        # 平台门店结算单
        if ($source_order_id) {
            $cash_order = Dever::db('cash/order')->getDataByOrderId(array('source_order_id' => $source_order_id));

            $col = 'cash';
        }

        if (isset($cash_order) && $cash_order) {
            $head = array('序号', '结算单号', '数量', '金额', '结算类型', '入账状态', '审核状态', '结算时间', '审核备注', '管理');

            $body = array();
            $config = Dever::db('cash/order')->config;
            foreach ($cash_order as $k => $v) {
                $cdate = date('Y-m-d H:i', $v['cdate']);
                $fdate = $v['fdate'] ? date('Y-m-d H:i', $v['fdate']) : '';
                $operdate = $v['operdate'] ? date('Y-m-d H:i', $v['operdate']) : '';
                $cash = $v[$col];

                $url = Dever::url('project/database/list?project=shop&table=buy_order_goods&order_id='.$v['source_order_id'].'&page_type=1', 'manage');
                $v['source_order_num'] = '<a href="'.$url.'" style="color:blue">'.$v['source_order_num'].'</a>';

                $m = '';
                if ($v['audit'] == 1 && $v['audit_type'] == 2) {
                    $url = Dever::url('project/database/update?project=cash&table=order&where_id='.$v['id'].'&col=audit,desc', 'manage');
                    $m = '<a href="javascript:;" onclick="fastEdit($(this), \''.$url.'\', \'审核\', \'\', 1)" class="layui-btn">审核</a>';
                }

                $d = array
                (
                    $k+1,
                    $v['order_num'],
                    $v['num'],
                    $cash,
                    $config['config_jstype'][$v['jstype']],
                    $config['config_status'][$v['status']],
                    $config['config_audit'][$v['audit']],
                    $operdate,
                    $v['desc'],
                    $m,
                );

                $body[] = $d;
            }

            $result['对账清单'] = array
            (
                'type' => 'table',
                'content' => array
                (
                    'head' => $head,
                    'body' => $body,
                )
            );
                
        }
        $head_btn[] = array
        (
            'type' => 'link',
            'link' => Dever::url('project/database/list?project=agent&table=dh_order&menu=agent&search_option_state=1', 'manage'),
            'name' => '返回上一页',
        );
        $audit = Dever::input('audit');
        if($audit==1){
            # 审核信息
            $this->show_audit($info, $result);
        }

        $head = array
        (
            'name' => '基本信息',
            'btn' => $head_btn,
        );
        $html = Dever::show($head, $result);

        return $html;
    }
     private function show_audit($info, &$result)
    {
        $info['type'] = 3;

        $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $info['id'], 'status' => 1));

        $shop = Dever::db('shop/info')->find($info['shop_id']);

        list($data, $source) = Dever::load('mshop/lib/buy')->assign($goods, $info, $shop, true);
        // print_R($data);die;
        if ($info) {

            $head = array('序号', '商品编号', '商品名称', '供货商', '订货总数量', '商品计量单位', '订货单总金额');
            $body = array();
            $i = 0;
            if ($data) {
                foreach ($data as $k => $v) {
                    foreach ($v as $v1) {
                        $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
                        if (isset($goods_info['sku'])) {
                            $sku = '[' . $goods_info['sku']['string'] . ']';
                        } else {
                            $sku = '';
                        }
                        $d = array
                        (
                            $i+1,
                            $goods_info['code'],
                            $goods_info['name'] . $sku,
                            Dever::load('mshop/lib/buy')->getSelect($source, $v1['source_id'], $v1['order_goods_id']),
                            $v1['num'],
                            $goods_info['unit'],
                            $v1['price'] * $v1['num'],
                        );

                        $body[] = $d;

                        $i++;
                    }
                }
            }
            
            if ($goods) {
                foreach ($goods as $k => $v) {
                    $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
                    if (isset($goods_info['sku'])) {
                        $sku = '[' . $goods_info['sku']['string'] . ']';
                    } else {
                        $sku = '';
                    }
                    $d = array
                    (
                        $i+1,
                        $goods_info['code'],
                        $goods_info['name'] . $sku,
                        Dever::load('mshop/lib/buy')->getSelect($source, false, $v['id']),
                        $v['num'],
                        $goods_info['unit'],
                        $v['price'] * $v['num'],
                    );

                    $body[] = $d;

                    $i++;
                }
            }

            $btn = array();
            $btn[] = array(
                'type' => 'click',
                'content' => 'setAudit()',
                'name' => '全部调整<script>function setAudit(){layer.confirm(\'确定进行此项操作吗？\', function(){var audit = $(\'.audit_set\').val();$(\'.audit\').each(function(){$(this).val(audit);layui.form.render();layer.closeAll()})})}</script>'
            );
            $result['商品拆单'] = array
            (
                'type' => 'table',
                'head' => array('name' => '供货商：' . Dever::load('mshop/lib/buy')->getSelect($source, false, false), 'btn' => $btn),
                'content' => array
                (
                    'head' => $head,
                    'body' => $body,
                )
            );

            $url = Dever::url('lib/dhorder.audit_set_commit?json=1&order_id=' . $info['id'], 'agent');
            // print_R($url);die;
            $result['审核结果'] = array
            (
                'type' => 'html',
                'content' => '<script>function saveAudit(){var goods = [];var audit = 1; var audit_text = $(".update_audit_text").val();$(".update_audit").each(function(){if ($(this).get(0).checked){audit = $(this).val()}});$(\'.audit\').each(function(){var v = $(this).val();var id = $(this).attr("id");goods.push(v + "_" + id);});layer.confirm(\'确定进行此项操作吗？\', function(){layui.form.render();var send = {};send.goods = goods.join(",");send.audit = audit;send.audit_text = audit_text;console.info(send);$.post("'.$url.'", send, function(t){t = JSON.parse(t);showYes(t)})})}</script><style>.layui-form-radio{padding-right: 0px;margin: 0px 0px 0 0;margin-left:40px}</style><div class="layui-form-item  show_input"><div classs="layui-col-lg6"><div><label style="font-size:14px;font-weight:bold;" class="">审核状态</label><div style="display:inline" class="am-btn-group"><input update_type="checked" class="checkbox-checkall-0_update_audit update_audit update_value validate[required]" type="radio" name="update_audit[]" value="2" checked="" show_id="audit" autocomplete="off" id="form-validation-field-1"> 审核通过 &nbsp;&nbsp;<input update_type="checked" class="autoload checkbox-checkall-0_update_audit update_audit update_value validate[required]" type="radio" name="update_audit[]" value="3" autocomplete="off" id="form-validation-field-0"> 审核未通过 &nbsp;&nbsp;</div></div></div></div><div class="layui-form-item" style="display: block;"><div classs="layui-col-lg6"><div><label style="font-size:14px;font-weight:bold;" class="">审核备注</label></div><div><textarea style="height:100px;" update_type="value" class="update_value update_audit_text form-control layui-input validate[required]" name="update_desc"></textarea></div></div></div> <div style="text-align:left" class="layui-layer-btn layui-layer-btn-"><a class="layui-btn layui-btn-primary" onclick="saveAudit()">保存</a><a class="layui-layer-btn1" style="display:none">取消</a></div>',
            );
        }
    }
     # 采购订单审核 手动拆单
    public function audit_set_commit_api()
    {
        Dever::config('base')->hook = true;
        //{goods: "2_4_audit_615,2_4_audit_614,-1_-1_audit_617,-1_-1_audit_616,-1_-1_audit_613", audit: "1", audit_text: "1231"}

        $id = Dever::input('order_id');
        $goods = Dever::input('goods');
        $audit = Dever::input('audit');
        $audit_text = Dever::input('audit_text');

        $info = Dever::db('agent/dh_order')->one($id);
        if ($audit > 1 && $info && $info['status'] == 2) {

            $shop = Dever::db('shop/info')->find($info['shop_id']);

            if ($audit == 2) {
                Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text));
                # 成功
                if (strstr($info['order_num'], '_')) {
                    $temp = explode('_', $info['order_num']);
                    $info['order_num'] = $temp[0];
                    $info['order_index'] = $temp[1];
                } else {
                    $info['order_index'] = 0;
                }
                $goods = explode(',', $goods);
                $data = $other = array();
                foreach ($goods as $k => $v) {
                    list($source_type, $source_id, $name, $goods_id) = explode('_', $v);
                    $gv = Dever::db('agent/dh_order_goods')->find($goods_id);
                    if ($source_id > 0) {
                        $key = $source_type . '_' . $source_id;
                        $data[$key][] = array
                        (
                            'area' => $shop['area'],
                            'order_id' => $info['id'],
                            'order_type' => 3,
                            'order_num' => $info['order_num'],
                            'order_index' => $info['order_index'],
                            'type' => 1,
                            'type_id' => $shop['id'],
                            'source_type' => $source_type,
                            'source_id' => $source_id,
                            'order_goods_id' => $gv['id'],
                            'goods_id' => $gv['goods_id'],
                            'sku_id' => $gv['sku_id'],
                            'price' => $gv['price'],
                            'p_price' => $gv['price'],
                            'num' => $gv['num'],
                        );
                    } else {
                        $other[] = $gv;
                    }
                }

                $this->audit_action($data, $other, $info, $shop, 1);
            } else {
                Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'audit' => $audit, 'audit_desc' => $audit_text, 'status' => 7));

                Dever::load('agent/lib/dhorder')->updateSell($info, 2);

                if (Dever::project('sms')) {
                    $member = Dever::db('agent/member')->find($info['mid']);
                    Dever::load('sms/api')->send('daili_goods_no', $member['mobile'], array('name' => $member['name'], 'content' => $audit_text));
                }
            }
        }

        return Dever::url('project/database/list&project=agent&table=dh_order&menu=agent&search_option_state=1&search_option_shop_type=2&menu_id=218', 'manage');
    }

    # 采购订单审核 拆单
    public function audit_commit()
    {
        $order_id = Dever::input('order_id');
        $order = Dever::db('agent/dh_order')->find($order_id);

        if (!$order || ($order && $order['status'] != 2)) {
            Dever::alert('当前订单状态无法拆单');
        }

        // if ($order['shop_type'] != 2) {
        //     Dever::alert('这不是平台店的订单');
        // }

        $order['type'] = 3;

        $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));

        $shop = Dever::db('shop/info')->find($order['shop_id']);

        $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);

        $this->audit_action($data, $goods, $order, $shop);

        return 'ok';
    }
    private function audit_action($data, $goods, $order, $shop, $state = 2)
    {
        $send = array();

        if (!$goods && $data) {
            # 开始生成订单
            $i = $order['order_index'];
            foreach ($data as $k => $v) {
                foreach ($v as $k1 => $v1) {
                    $v1['order_num'] .= '_' . $i;

                    $state = Dever::load('mshop/lib/buy')->createOrder($v1);
                    $send[$state] = $v1;
                }
                $i++;
            }

            Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
        } else {
            Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
            if ($goods) {
                $string = array();
                foreach ($goods as $k => $v) {
                    $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
                    
                    if ($info['sku_name']) {
                        $info['name'] .= '（'.$info['sku_name'].'）';
                    }
                    $string[] = $info['name'];
                }
                $string = implode('、', $string);
                if ($state == 1) {
                    Dever::alert('商品：'.$string.'未选择供货商');
                } else {
                    Dever::alert('商品：'.$string.'库存不足或厂家未生产，请联系供货商备货，该订单进入重新审核状态');
                }
                Dever::alert('商品：'.$string.'库存不足或厂家未生产，请联系供货商备货，该订单进入重新审核状态');
            } else {
                if ($state == 1) {
                    Dever::alert('未选择供货商，该订单进入重新审核状态');
                } else {
                    Dever::alert('供货商库存不足，请联系供货商备货，该订单进入重新审核状态');
                }
                
            }
        }

        if ($send) {
            foreach ($send as $k => $v) {
                Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);

                $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
                Dever::load('cash/lib/order')->up($order_info, 1, 1);
            }
        }
    }
    # 第三方确认
    public function tixian()
    {
        $param = array();

        ksort($param);
        $string = array();
        foreach ($param as $k => $v) {
            if (strstr($v, '&') || strstr($v, '@')) {
                $v = urlencode($v);
            }
            $string[] = $k . '=' . $v;
        }
    }
    
    # 发货
    public function notice($info)
    {
        $config = Dever::db('agent/dh_order')->config;
        $state = Dever::db('agent/dh_order')->update(array('where_id' => $info['id'], 'status' => 3, 'operdate' => time()));
    }

    # 采购订单审核 拆单
    /*
    public function audit_commit()
    {
        $order_id = Dever::input('order_id');
        $order = Dever::db('agent/dh_order')->find($order_id);

        if (!$order || ($order && $order['status'] != 2)) {
            Dever::alert('当前订单状态无法拆单');
        }

        $order['type'] = 3;

        $goods = Dever::db('agent/dh_order_goods')->select(array('order_id' => $order_id));

        $shop = Dever::db('shop/info')->find($order['shop_id']);

        $data = Dever::load('mshop/lib/buy')->assign($goods, $order, $shop);

        $send = array();

        if (!$goods && $data) {
            # 开始生成订单
            $i = $order['order_index'];
            foreach ($data as $k => $v) {
                foreach ($v as $k1 => $v1) {
                    $v1['order_num'] .= '_' . $i;

                    $state = Dever::load('mshop/lib/buy')->createOrder($v1);
                    $send[$state] = $v1;
                }
                $i++;
            }

            Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'status' => 3));
        } else {
            Dever::db('agent/dh_order')->update(array('where_id' => $order['id'], 'audit' => 1));
            if ($goods) {
                $string = array();
                foreach ($goods as $k => $v) {
                    $info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
                    
                    if ($info['sku_name']) {
                        $info['name'] .= '（'.$info['sku_name'].'）';
                    }
                    $string[] = $info['name'];
                }
                $string = implode('、', $string);
                Dever::alert('商品：'.$string.'库存不足或厂家未生产，请联系供货商备货，该订单进入重新审核状态');
            } else {
                Dever::alert('供货商库存不足，请联系供货商备货，该订单进入重新审核状态');
            }
        }

        if ($send) {
            foreach ($send as $k => $v) {
                Dever::load('mshop/lib/buy')->sendMsg($v['source_type'], $v['source_id'], $k);

                $order_info = Dever::db('shop/buy_order')->find(array('id' => $k, 'clear' => true));
                Dever::load('cash/lib/order')->up($order_info, 1, 1);
            }
        }

        return 'ok';
    }
    */
   public function goodsd_api($id){
        $name = '';
        $goods = Dever::db('agent/dh_order_goods')->state(array('order_id'=>$id));
        foreach($goods as $k1 => $v1){
            $goods_info[] = Dever::load('goods/lib/info')->getInfoBySku($v1['goods_id'], $v1['sku_id']);
        }
        
        if(isset($goods_info)){
            foreach($goods_info as $v2){
                $goods_name[] = $v2['name'];
                
            }
            $name = implode(',',$goods_name);
        }
        return $name;
   }
   #权益订单导出
    public function out_dhorder_api($data){
        $header = array('订单编号', '会员姓名', '会员等级', '会员手机号', '收货姓名(或自提人)', '联系电话', '收货地址', '商品名称', '商品数量', '商品原价','订单状态','下单时间', '付款时间', '发货时间','完成时间','卖家订单备注','权益发放时间','代理商终审时间');
        $body = array();
        foreach($data as $k => $v){
            $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
            $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
            $address = $res = array();
            if ($v['address_id'] && $v['address_id'] > 0) {
                $address = Dever::db('agent/member_address')->find(array('id'=>$v['address_id']));
                if ($address) {
                    $res=Dever::load('agent/address')->getOne($address['mid'],$address['id']);
                }
            }

            $fhdate = '';
            $buy_order = Dever::db('shop/buy_order')->find(array('parent_id' => 3, 'parent_order_id' => $v['id']));
            if ($buy_order) {
                $ps = Dever::db('shop/sell_order_ps')->find(array('order_id' => $buy_order['id']));
                $fhdate = ($ps && $ps['cdate']) ? date('Y-m-d H:i', $ps['cdate']) : '-';
            }
            
            $fdate = '';
            if($v['fdate']){
                $fdate = date('Y-m-d H:i',$v['fdate']);
            }
            $quanyi = '';
            $member_goods = Dever::db('agent/member_goods')->getQone(array('type'=>$v['type'],'type_id'=>$v['type_id']));
            if($member_goods && $member_goods['cdate']){
                $quanyi = date('Y-m-d H:i',$member_goods['cdate']);
            }
            $order = Dever::db('agent/order')->find(array('mid'=>$member['id']));
            $zhongshen = '';
            $process = Dever::db('agent/order_process')->state(array('order_id'=>$order['id']));
            foreach($process as $k1 => $v1){
                if($v1['status'] == 2){
                    $zhongshen = date('Y-m-d H:i',$v1['cdate']);
                }
            }
            $name = '';
            if($v['type'] == 1){
                $name = $this->goodsd_api($v['id']);
            }elseif($v['type'] == 2){
                $goods = Dever::db('card/info')->find(array('id'=>$v['type_id']));
                if($goods){
                    $name = $goods['name'];
                }
            }elseif($v['type'] == 3){
                $goods = Dever::db('setting/prize')->find(array('id'=>$v['type_id']));
                if($goods){
                    $name = $goods['name'];
                }
            }

            $goods_status = Dever::db('agent/dh_order')->config['status'];
            $status = Dever::status($goods_status, $v['status']);
            $d = array
            (
                $v['order_num'],
                $member['name'],
                $role['name'],
                $member['mobile'],
                isset($address['contact']) ? $address['contact'] : '',
                isset($address['mobile']) ? $address['mobile'] : '',
                (isset($res['address_info']) ? $res['address_info'] : '').(isset($address['house_number']) ? $address['house_number'] : ''),
                $name,
                $v['num'],
                $v['price'],
                $status,
                date('Y-m-d H:i',$v['cdate']),
                date('Y-m-d H:i',$v['cdate']),
                $fhdate,
                $fdate,
                $v['audit_desc'],
                $quanyi,
                $zhongshen,

            );
            $body[] = $d;
        }
        $file = Dever::input('excel_name');
        return Dever::excelExport($body, $header, $file);
    }
    #权益管理导出
    public function out_member_goods_api($data){
        $header = array('权益名称', '会员等级', '姓名', '手机号', '卡号','剩余数量', '总数量', '单件价值', '未兑换价值', '已用面值','5月已用面值','备注','获取方式', '获取时间','代理商注册时间');
        $body = array();
        foreach($data as $k => $v){
            $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
            $member_cdate = '-';
            if($member && $member['cdate']){
                $member_cdate = date('Y-m-d H:i',$member['cdate']);
            }
            $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
            $wd = ($v['total_num'] - $v['sell_num'])*$v['price'];
            $card = '-';
            $mianzhi = '-';
            $money = '-';
            if($v['type'] == 2){
                $code = Dever::db('card/code')->find($v['sku_id']);
                $start = '1651334400';
                $end = '1654012799';
                if($code){
                    $sell_order = Dever::db('shop/sell_order')->getSumCdate(array('start'=>$start,'end'=>$end,'card_code_id'=>$code['id'],'state'=>1));
                    if($sell_order && $sell_order['total']){
                        $money = $sell_order['total'];
                    }
                }
                
                $card = $code['card']."\t";
                $mianzhi = $code['total_cash'] - $code['use_cash'];                
            }
            $desc = '';
            $member_goods_log = Dever::db('agent/member_goods_log')->getOne(array('type'=>$v['type'],'type_id'=>$v['type_id'],'sku_id'=>$v['sku_id'],'state'=>1));
            if($member_goods_log && $member_goods_log['desc']){
                $desc = $member_goods_log['desc'];
            }
            $d = array
            (
                $v['name'],
                $role['name'],
                $member['name'],
                $member['mobile'],
                $card,
                $v['total_num']-$v['sell_num'],
                $v['total_num'],
                $v['price'],
                $wd,
                $mianzhi,
                $money,
                $desc,
                '',
                date('Y-m-d H:i',$v['cdate']),
                $member_cdate,
                
            );
            $body[] = $d;
        }
        $file = Dever::input('excel_name');
        return Dever::excelExport($body, $header, $file);
    }
    public function head($type=false){
        $data = Dever::db('agent/member_goods')->getProduct(array('type'=>'1,2','state'=>1));
        $res = array();
        foreach($data as $k => $v){
            
            if($v['name'] && $v['total_num']>0 && $v['type_id']!=8){
                $key = $v['type'] . '_' . $v['type_id'];
                if ($v['type'] == 1) {
                    $res[0][$key] = array($v['name'], '价值');
                } else {
                    $res[0][$key] = array($v['name'], '');
                    $res[2][$key] = $v['name'];
                }
                $res[1][$key] = $v['name'];
            }
        }
        
        return $res;
    }
    public function out_equity_api($data){
        $start = Dever::input('search_option_start_rdate');
        $end = Dever::input('search_option_end_rdate');
        if($start && $end){
            $where['start'] = $start;
            $where['end'] = $end;
        }else{
            $where['start']=Dever::maketime(date('Y-m-01') . ' 00:00:00');
            $where['end'] = strtotime(date('Y-m-d 23:59:59',
                strtotime(date('Y-m-01')."+1 month - 1 day")));
        }
        $where['type'] = '1,2';
        $res = $this->head(1);
        $header = array('基础信息', '', '', '', '','', '', '', '', '');
        $body = array();
        $pg = Dever::input('pg');
        if ($pg == 1) {
            $body[] = array('代理商姓名', '角色', '电话', '区域','应收合计', '月份', '代理费', '产品费（商品）', '产品费（电器卡）','产品费（菜卡）');
        }
        
        $i = 0;
        foreach ($res[0] as $k => $v) {
            if ($i == 0) {
                $header[] = '发放权益';
            } else {
                $header[] = '';
            }
            
            isset($body[0]) && $body[0][] = $v[0];
            if ($v[1]) {
                isset($body[0]) && $body[0][] = $v[1];
                $header[] = '';
            }
            $i++;
        }
        $i = 0;
        foreach ($res[1] as $k => $v) {
            isset($body[0]) && $body[0][] = $v;
            if ($i == 0) {
                $header[] = '兑换权益';
            } else {
                $header[] = '';
            }
            $i++;
        }
        $i = 0;
        foreach ($res[2] as $k => $v) {
            isset($body[0]) && $body[0][] = $v;
            if ($i == 0) {
                $header[] = '使用金额';
            } else {
                $header[] = '';
            }
            $i++;
        }
        
        $body_member = array();
        // $data = Dever::db('agent/member_goods')->getSearchAll($where);
        foreach ($data as $k => $v) {
            $member_goods[] = Dever::db('agent/member_goods')->getTOne(array('mid'=>$v['id'],'type'=>'1,2'));
        }
        foreach($member_goods as $k => $v){
            if($v){
                $body_member[] = $v;
            }
        }
        foreach ($body_member as $k => $v) {
            $month = date('Y-m',$v['cdate']);
            $member = Dever::db('agent/member')->find($v['mid']);
            $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
            $area = '';
            if($member['area']){
                $area = Dever::load("area/api.string", $member['area']);
            }
            $order = Dever::db('agent/order')->find(array('mid'=>$v['mid']));
            $heji = 0;
            $product_cash = 0;
            $dianqi_cash = 0;
            $caipin_cash = 0;
            
            $d = array
            (
                $member['name'],
                $role['name'],
                $member['mobile'],
                $area,
                $order['agent_cash'],
                $month,
                0,
                0,
                0,
                0,

            );
            $i = count($d);
            $goods = array();
            foreach ($res[0] as $k1 => $v1) {
                list($type, $type_id) = explode('_', $k1);
                $goods[$k1] = Dever::db('agent/member_goods')->getTotal(array('start'=>$where['start'],'end'=>$where['end'],'mid'=>$v['mid'],'type'=>$type, 'type_id' => $type_id));
                $d[$i] = 0;
                if ($goods[$k1]) {
                    if(strstr($v1[0],'卡')){
                        $d[$i] = $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
                    }else{
                        $d[$i] = $goods[$k1]['total_num'] ? $goods[$k1]['total_num'] : 0;
                    }
                }
                if ($v1[1]) {
                    $i++;
                    $d[$i] = 0;
                    if ($goods[$k1]) {
                        $d[$i] = $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
                    }
                }

                if ($type == 1) {
                    $product_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
                }
                if ($type == 2 ) {
                   if(strstr($v1[0], '器具')){
                        $dianqi_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
                   } else {
                        $caipin_cash += $goods[$k1]['cash'] ? $goods[$k1]['cash'] : 0;
                   }
                    // if ($v)
                    
                }
                
                $i++;
            }
            // $heji = $order['agent_cash'] + $product_cash + $dianqi_cash + $caipin_cash;
            $d[6] = $order['agent_cash'] - $product_cash - $dianqi_cash - $caipin_cash;
            $d[7] = $product_cash;
            $d[8] = $dianqi_cash;
            $d[9] = $caipin_cash;

            foreach ($res[1] as $k1 => $v1) {
                $d[$i] = 0;
                if ($goods[$k1]) {
                    if (strstr($v1,'卡')) {
                        $d[$i] = $goods[$k1]['cash']*$goods[$k1]['sell_num'] ? $goods[$k1]['cash']*$goods[$k1]['sell_num'] : 0;
                    } else {
                        $d[$i] = $goods[$k1]['sell_num'] ? $goods[$k1]['sell_num'] : 0;
                    }
                }
                $i++;
            }
           
            foreach ($res[2] as $k1 => $v1) {
                list($type, $type_id) = explode('_', $k1);
                $sku = Dever::db('agent/member_goods')->getCardAll(array('start'=>$where['start'],'end'=>$where['end'],'type_id'=>$type_id,'type'=>$type,'mid'=>$v['mid']));
                $array = array_column($sku, 'sku_id');
                $sku_id = implode(",",$array);

                if($sku_id){
                    $sell_order[$k1] = Dever::db('shop/sell_order')->getCardAll(array('start'=>$where['start'],'end'=>$where['end'],'card_code_id'=>$sku_id));
                }else{
                    $sell_order[$k1]['total'] = 0;
                }
                if($sell_order[$k1]){
                    $d[$i] = $sell_order[$k1]['total'] ? $sell_order[$k1]['total'] : 0 ;
                }
                $i++;
            }
            
            $body[] = $d;
        }
        $file = Dever::input('excel_name');
        return Dever::excelExport($body, $header, $file);
    }
   
}