churen/app/mshop/lib/Buy.php

<?php

# 支付

namespace Mshop\Lib;

use Dever;

class Buy
{
    # 获取配置
    public $config = array();
    # table
    public $table = 'shop/buy_order';

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

    # 获取公共的where
    public function where($id)
    {
        $where = array();
        $where['shop_id'] = $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['search_value'] = $where;
        $result['search_value']['day'] = $day = Dever::input('day');
        if ($day) {
            $where['start'] = Dever::maketime($day . ' 00:00:00');
            $where['end'] = Dever::maketime($day . ' 23:59:59');
        }

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

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

        $result['search'] = array();
        $result['search']['status'] = array
        (
            array('value' => 1, 'name' => '待支付'),
            array('value' => 2, 'name' => '待审核'),
            array('value' => 3, 'name' => '待发货'),
            array('value' => 4, 'name' => '待收货确认'),
            array('value' => 5, 'name' => '已完成'),
            array('value' => 6, 'name' => '已完成（有退款）'),
            array('value' => '7,8,9', 'name' => '已取消'),
        );

        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, true);
        }

        return $result;
    }

    # 获取订单详细信息
    public function getInfo($info, $view = false)
    {
        if ($info['status'] == 1) {
            # 15分钟内支付，900秒
            $m = 9000;
            # 支付倒计时
            $info['time'] = time() - $info['cdate'];
            if ($info['time'] >= $m) {
                # 已过期，自动取消
                $info['time'] = -1;
                Dever::db($this->table)->update(array('where_id' => $info['id'], 'status' => 11));
                $info['status'] = 11;
            } else {
                $info['time'] = $m - $info['time'];
            }
        }

        $info['status_name'] = $this->config['status'][$info['status']];

        $info['goods'] = Dever::db('shop/buy_order_goods')->select(array('order_id' => $info['id']));
        $info['shop'] = Dever::db('shop/info')->getOne($info['shop_id']);
        $info['cdate'] = date('Y-m-d H:i', $info['cdate']);

        $goods_status = Dever::db('shop/buy_order_goods')->config['status'];
        if ($view) {
            foreach ($info['goods'] as $k => $v) {
                $info['goods'][$k]['info'] = Dever::load('goods/lib/info')->getPayInfo($v['goods_id'], $v['sku_id']);
                $info['goods'][$k]['status_name'] = $goods_status[$v['status']];
            }
        } else {
            foreach ($info['goods'] as $k => $v) {
                $goods = Dever::db('goods/info')->one($v['goods_id']);
                $info['goods'][$k]['name'] = $goods['name'];
                $info['goods'][$k]['cover'] = $goods['cover'];
                $info['goods'][$k]['status_name'] = $goods_status[$v['status']];
            }
        }

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

        return $info;
    }

    # 发起支付
    public function action($shop, $name, $num, $goods, $price, $info, $refer = '')
    {
        if (!$shop) {
            Dever::alert('错误的门店信息');
        }
        
        $order_data['shop_id'] = $shop['id'];
        $order_data['mobile'] = $shop['mobile'];
        $order_data['name'] = $name;
        $order_data['num'] = $num;
        $order_data['info'] = $info;
        $order_data['price'] = $price;

        $order_data['area'] = $shop['area'];
        $order_data['province'] = $shop['province'];
        $order_data['city'] = $shop['city'];
        $order_data['county'] = $shop['county'];
        $order_data['town'] = $shop['town'];

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

        if (!$id) {
            Dever::alert('支付失败');
        }

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

            Dever::db('shop/buy_order_goods')->insert($data);
        }

        if ($price <= 0) {

            $param['pay_product_id'] = $id;
            $param['pay_order_id'] = $order_data['order_num'];
            $param['pay_status'] = 2;
            $param['pay_cash'] = $price;
            $param['pay_msg'] = '';
            $this->success($param);
            return array
            (
                'order' => '',
                'order_num' => $order_data['order_num'],
                'order_id' => $id,
                'type' => 'pay',
            );
        }

        $param = array
        (
            'project_id' => 2,
            'channel_id' => 1,
            'system_source' => 5,
            'uid' => -1,
            'name' => $order_data['name'],
            'cash' => $price,
            'product_id' => $id,
            'order_id' => $order_data['order_num'],
            'refer' => $refer,
        );

        $receipt = Dever::input('receipt');
        if ($receipt) {
            $param['receipt'] = $receipt;
        }

        $result = Dever::load('pay/api.pay', $param);
        $result['order_num'] = $order_data['order_num'];
        $result['order_id'] = $id;
        return $result;
    }

    # 再次发起支付
    public function raction($id, $refer = '')
    {
        $order = Dever::db('goods/buy_order')->find($id);

        if (!$order) {
            Dever::alert('订单信息错误');
        }

        if ($order['status'] > 1) {
            Dever::alert('订单已支付或已取消');
        }

        $param = array
        (
            'project_id' => 2,
            'channel_id' => 1,
            'system_source' => 5,
            'uid' => -1,
            'name' => $order['name'],
            'cash' => $order['price'],
            'product_id' => $id,
            'order_id' => $order['order_num'],
            'refer' => $refer,
        );

        $receipt = Dever::input('receipt');
        if ($receipt) {
            $param['receipt'] = $receipt;
        }

        $result = Dever::load('pay/api.pay', $param);
        $result['order_num'] = $order['order_num'];
        $result['order_id'] = $id;

        return $result;
    }

    # 支付成功回调 安全加密 设置token
    public function success_secure_api_token()
    {
        $project_id = Dever::input('pay_project_id');
        $info = Dever::db('pay/project')->one($project_id);
        if ($info) {
            return $info['key'];
        }
        return 'shop_buy_dever_2020';
    }

    # 支付成功回调 安全加密
    public function success_secure_api($param = array())
    {
        $this->success($param);
    }

    # 支付成功回调
    public function success($param = array())
    {
        $send = $param ? $param : Dever::preInput('pay_');
        $product_id = $send['pay_product_id'];
        $order_id = $send['pay_order_id'];
        $status = $send['pay_status'];
        $cash = $send['pay_cash'];
        $msg = $send['pay_msg'];

        $order = Dever::db('shop/buy_order')->one(array('id' => $product_id, 'time' => time()));
        if ($order && $order['status'] == 1) {

            if ($status == 2) {
                
            }

            $update['status'] = 2;
            $update['where_id'] = $order['id'];
            Dever::db('shop/buy_order')->update($update);
        }

        return 'ok';
    }

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

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

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

    # 申请退款
    public function tui_action($shop_id, $order_id, $order_goods_id, $status, $price, $num = false, $desc = '', $pic = '')
    {
        $data['shop_id'] = $shop_id;
        $data['order_id'] = $order_id;
        $data['order_goods_id'] = $order_goods_id;
        $info = Dever::db('shop/buy_order_tui')->find($data);

        $data['status'] = $status;
        $data['price'] = $price;
        if ($num) {
            $data['num'] = $num;
        }
        $data['desc'] = $desc;
        $data['pic'] = $pic;
        
        if ($info) {
            $data['where_id'] = $info['id'];
            return Dever::db('shop/buy_order_tui')->update($data);
        } else {
            return Dever::db('shop/buy_order_tui')->insert($data);
        }
    }

    # 全部退款申请
    public function tui($id, $order_id, $status = 1, $desc = '', $pic = '')
    {
        if ($status != 1 && $status != 2) {
            Dever::alert('当前订单状态不允许退货退款');
        }

        $data = $this->getView($id, $order_id, false);
        if ($data['status'] == 2) {

            $state = $this->tui_action($data['shop_id'], $data['id'], -1, $status, $data['price'], false, $desc, $pic);

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

    # 获取部分退款的详情
    public function tui_one_info($id, $order_id, $order_goods_id)
    {
        $data = $this->getView($id, $order_id, false);
        if ($data['status'] == 4) {
            $info = Dever::db('shop/buy_order_goods')->find(array('id' => $order_goods_id, 'order_id' => $data['id'], 'shop_id' => $id));
            if ($info && $info['status'] <= 4) {
                $info['tui_price'] = $info['price'];
                $info['tui_one_price'] = round($info['tui_price'] / $info['num'], 2);
                $info['goods'] = Dever::db('goods/info')->find($info['goods_id']);
            }
            return $info;
        } else {
            Dever::alert('当前订单状态不允许退货退款');
        }
    }

    # 部分退款申请
    public function tui_one($id, $order_id, $order_goods_id, $num = false, $status = 6, $desc = '', $pic = '')
    {
        if ($status != 5 && $status != 6) {
            Dever::alert('当前订单状态不允许退货退款');
        }

        $data = $this->getView($id, $order_id, false);
        if ($data['status'] == 4 || $data['status'] == 5) {
            $info = Dever::db('shop/buy_order_goods')->find(array('id' => $order_goods_id, 'order_id' => $data['id'], 'shop_id' => $id));
            if ($info && $info['status'] <= 4) {
                $info['price'] = $info['price'];
                if ($num > 0 && $info['num'] >= $num) {
                    $price = round($info['price'] / $info['num'], 2);
                    $info['price'] = round($price * $num, 2);
                }

                $state = $this->tui_action($data['shop_id'], $data['id'], $order_goods_id, $status, $info['price'], $num, $desc, $pic);

                /*
                if ($state) {
                    $this->pay_tui($state, $data, $info['price']);

                    # 检查这个订单下的商品是不是都退了
                    $total = Dever::db('shop/buy_order_goods')->total(array('order_id' => $data['id'], 'shop_id' => $id, 'status' => 1));
                    if ($total <= 0) {
                        $status += 3;
                        $state = Dever::db('shop/buy_order')->update(array('where_id' => $data['id'], 'status' => $status, 'tk_desc' => $desc, 'tk_cash' => $info['price'], 'tk_pic' => $pic));
                    }
                }
                */
            } else {
                Dever::alert('当前订单状态不允许退货退款');
            }
            return 'ok';
        } else {
            Dever::alert('当前订单状态不允许退货退款');
        }
    }

    # 退款通知
    public function pay_tui($state, $data, $price)
    {
        return;
        if ($state) {
            $shop = Dever::db('shop/info')->one($data['shop_id']);
            $msg_param['type'] = 1;//消息类型1是订单消息
            $msg_param['id'] = $data['id'];
            $msg_param['name'] = $shop['name'];
            $msg_param = Dever::json_encode($msg_param);
            $msg = '您有一笔订单已退款，退款将在3个工作日内返回原支付账户';
            Dever::load('message/lib/data')->push(-1, $data['uid'], '退款成功通知', $msg, 1, 1, false, $msg_param);

            # 退款到原支付账户 待处理
        }
    }

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

        $config = Dever::db('shop/buy_order')->config;

        $info = Dever::db('shop/buy_order')->one($id);

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

        
        $html = '[基本信息]：<table class="layui-table"><thead><tr><th style="width:20%">项目</th><th style="width:80%">详情</th></tr> </thead><tbody>';

        $html .= '<tr>
          <td>订单号</td>
          <td>'.$this->table(false, array(array($info['order_num']))).'</td>

        </tr>';

        $html .= '<tr>
          <td>门店信息</td>
          <td>'.$this->table(false, array(array('门店名称：' . $shop['name'], '联系人：' . $shop['truename'], '联系电话：' . $shop['mobile']))).'</td>

        </tr>';

        $html .= '<tr>
          <td>订单信息</td>
          <td>'.$this->table(array('订单状态', '金额', '数量'), array(array($config['status'][$info['status']], $info['price'], $info['num']))).'</td>
        </tr>';

        # 增加仓库和工厂信息

        $html .= '</tbody></table>';

        $html .= '[商品清单]：';

        $head = array('商品名称', '商品属性', '商品价格', '商品数量');

        $body = array();
        $goods = Dever::db('shop/buy_order_goods')->select(array('order_id' => $info['id']));
        foreach ($goods as $k => $v) {
            $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['goods_id'], $v['sku_id']);
            $body[$k] = array
            (
                $goods_info['name'],
                $v['price'],
                $v['price'],
                $v['num'],
            );
        }
        $html .= $this->table($head, $body);

        return $html;
    }

    private function table($head, $data)
    {
        $html = '';
        if ($head) {
            $html = '<table class="layui-table">';

            $html .= '<thead><tr>';
            foreach ($head as $k => $v) {
                $html .= '<th>'.$v.'</th>';
            }
            $html .= '</tr></thead>';

            $html .= '<tbody>';
            foreach ($data as $k => $v) {
                $html .= '<tr>';
                foreach ($v as $k1 => $v1) {
                    $html .= '<td>'.$v1.'</td>';
                }
                $html .= '</tr>';
            }

            $html .= '</tbody>';

            $html .= '</table>';
        } else {
            foreach ($data as $k => $v) {
                $html .= '';
                foreach ($v as $k1 => $v1) {
                    $html .= $v1 . '&nbsp;&nbsp;&nbsp;&nbsp;';
                }
                $html .= '';
            }
        }
        return $html;
    }

    # 采购订单审核 拆单
    public function audit()
    {
        $order_id = Dever::input('id');
        $info = Dever::db('shop/buy_order')->find($order_id);

        $goods = Dever::db('shop/buy_order_goods')->select(array('order_id' => $order_id));
        print_r($goods);die;

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

        # 获取门店分配的仓库和工厂
        $shop_store = Dever::db('shop/store')->select(array('shop_id' => $shop['id']));
        $store = array();
        $distance = array();

        # 按照距离排序
        foreach ($shop_store as $k => $v) {
            $info = Dever::db('store/info')->find($v['store_id']);
            if ($info && $info['status'] == 1) {
                $distance[] = $info['distance'] = Dever::distance($shop['lng'], $shop['lat'], $info['lng'], $info['lat']);
                $store[] = $info;
            }
        }

        array_multisort($distance, SORT_ASC, SORT_NUMERIC, $store);

        $shop_factory = Dever::db('shop/factory')->select(array('shop_id' => $shop['id']));
        $factory = array();
        $distance = array();

        # 按照距离排序
        foreach ($shop_factory as $k => $v) {
            $info = Dever::db('factory/info')->find($v['factory_id']);
            if ($info && $info['status'] == 1) {
                $distance[] = $info['distance'] = Dever::distance($shop['lng'], $shop['lat'], $info['lng'], $info['lat']);
                $factory[] = $info;
            }
        }

        array_multisort($distance, SORT_ASC, SORT_NUMERIC, $factory);

        if ($store) {
            $num = 0;
            foreach ($goods as $k => $v) {
                # 开始找仓库
                $find = $this->store($order_id, $shop, $store, $v);
                if (!$find[1]) {
                    # 仓库没有，找厂家
                    if ($factory) {
                        $find = $this->factory($order_id, $shop, $factory, $v);
                    }
                    
                    if (!$find[1]) {
                        # 下单失败 缺货
                        Dever::db('shop/buy_order_goods')->update(array('where_id' => $v['id'], 'status' => 4));
                        # 要退款吧
                    }
                }

                if ($find[1]) {
                    $num++;
                    Dever::db('shop/buy_order_goods')->update(array('where_id' => $v['id'], 'status' => 2, 'type' => $find[0], 'type_id' => implode(',', $find[1])));
                }
            }

            if ($num > 0) {
                Dever::db('shop/buy_order')->update(array('where_id' => $info['id'], 'status' => 3));
            } else {
                Dever::db('shop/buy_order')->update(array('where_id' => $info['id'], 'status' => 7));
            }
        }
    }

    private function store($order_id, $shop, $store, $goods, $state = 2)
    {
        $find = array();
        $id = array();
        foreach ($store as $k => $v) {
            $where['store_id'] = $v['id'];
            $where['goods_id'] = $goods['goods_id'];
            $where['sku_id'] = ($goods['sku_id'] && $goods['sku_id'] > 0) ? $goods['sku_id'] : -1;
            $sku = Dever::db('store/goods_sku')->getOne($where);

            if ($sku) {
                if ($goods['num'] <= $sku['total']) {
                    # 如果库存符合，直接下单即可，生成仓库订单
                    $state = Dever::load('store/lib/order')->pay($order_id, $shop['id'], $where['store_id'], $goods['price'], $goods['num'], $where['goods_id'], $where['sku_id']);
                    if ($state) {
                        $id[] = $where['store_id'];
                        break;
                    }
                } elseif ($state == 1 && $sku['total'] > 0) {
                    # 如果库存不够，从这个仓库扣下一部分，剩余的从另外仓库处理
                    $goods['num'] = $goods['num'] - $sku['total'];
                    # 生成仓库订单
                    $state = Dever::load('store/lib/order')->pay($order_id, $shop['id'], $where['store_id'], $goods['price'], $sku['total'], $where['goods_id'], $where['sku_id']);
                    if (!$state) {
                        $goods['num'] = $goods['num'] + $sku['total'];
                    } else {
                        $id[] = $where['store_id'];
                    }
                    continue;

                } else {
                    # 直接切换到下一个仓库处理
                    continue;
                }
            }
        }

        return array(1, $id);
    }

    private function factory($order_id, $shop, $factory, $goods)
    {
        $find = array();
        $id = array();
        foreach ($factory as $k => $v) {
            $where['factory_id'] = $v['id'];
            $where['goods_id'] = $goods['goods_id'];
            $where['sku_id'] = ($goods['sku_id'] && $goods['sku_id'] > 0) ? $goods['sku_id'] : -1;
            $sku = Dever::db('factory/goods_sku')->getOne($where);

            if ($sku) {
                $state = Dever::load('factory/lib/order')->pay($order_id, $shop['id'], $where['factory_id'], $goods['price'], $goods['num'], $where['goods_id'], $where['sku_id']);
                if ($state) {
                    $id[] = $where['factory_id'];
                    break;
                }
            } else {
                continue;
            }
        }

        return array(2, $id);
    }
}