point_mall_admin/app/common/model/Vrorder.php

<?php

namespace app\common\model;


use think\facade\Db;
use think\facade\Log;

/**
 * ============================================================================
 * DSMall多用户商城
 * ============================================================================
 * 版权所有 2014-2028 长沙德尚网络科技有限公司，并保留所有权利。
 * 网站地址: http://www.csdeshang.com
 * ----------------------------------------------------------------------------
 * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和使用 .
 * 不允许对程序代码以任何形式任何目的的再发布。
 * ============================================================================
 * 数据层模型
 */
class Vrorder extends BaseModel
{
    public $page_info;

    /**
     * 取单条订单信息
     * @access public
     * @author csdeshang
     * @param type $condition 条件
     * @param type $fields 字段
     * @return type
     */
    public function getVrorderInfo($condition = [], $fields = '*')
    {
        $order_info = Db::name('vrorder')->field($fields)->where($condition)->find();
        if (empty($order_info)) {
            return [];
        }
        if (isset($order_info['order_state'])) {
            $state_desc                     = $this->_vrorderState($order_info['order_state']);
            $order_info['state_desc']       = $state_desc[0];
            $order_info['order_state_text'] = $state_desc[1];
        }
        if (isset($order_info['payment_code'])) {
            $order_info['payment_name'] = get_order_payment_name($order_info['payment_code']);
        }
        return $order_info;
    }

    /**
     * 新增订单
     * @access public
     * @author csdeshang
     * @param type $data 参数内容
     * @return type
     */
    public function addVrorder($data)
    {
        return Db::name('vrorder')->insertGetId($data);
    }

    /**
     * 新增订单
     * @access public
     * @author csdeshang
     * @param type $order_info 订单信息
     * @return boolean
     */
    public function addVrorderCode($order_info)
    {
        $vrc_num = Db::name('vrordercode')->where(['order_id' => $order_info['order_id']])->count();
        if (!empty($vrc_num) && intval($vrc_num) >= intval($order_info['goods_num']))
            return false;

        if (empty($order_info))
            return false;
        if ($order_info['goods_num'] == 0) {
            return false;
        }
        //均摊后每个兑换码支付金额
        $each_pay_price = ds_price_format($order_info['order_amount'] / $order_info['goods_num']);

        $code_list = [];
        if (empty($order_info['vr_code'])) {
            //取得店铺兑换码前缀
            $store_info          = model('store')->getStoreInfoByID($order_info['store_id']);
            $virtual_code_perfix = $store_info['store_vrcode_prefix'] ? $store_info['store_vrcode_prefix'] : rand(100, 999);
            $code_list           = $this->_makeVrordercode($virtual_code_perfix, $order_info['store_id'], $order_info['buyer_id'], $order_info['goods_num']);
        } else {
            $checkHost = config('ds_config.do_net_card_url');
            $url       = $checkHost . '/api/coupon.code/load';

            Log::info("绑定虚拟订单卡号：".\think\facade\Request::controller().'-'.\think\facade\Request::action());
            $result = common_curl($url,
                [
                    'userId'    => $order_info['buyer_id'],
                    'coupon_no' => $order_info['vr_code'],
                    "quantity"  => $order_info['goods_num'],
                ]
            );
            if ($result['code']) {
                Log::info('券码获取失败' . json_encode($result) . ' url：' . $url . '参数：' . json_encode([
                        'userId'    => $order_info['buyer_id'],
                        'coupon_no' => $order_info['vr_code'],
                        "quantity"  => $order_info['goods_num'],
                    ]));
                ds_json_encode(10001, $result['msg']);
            }
            $code_list = $result['data'];
            if (empty($code_list)) {
                ds_json_encode(10001, '券码获取失败');
            }
        }
        $code_type = ['no' => 1, 'secret' => 2, 'qrcode' => 3, 'barcode' => 4, 'url' => 5];
        // var_dump($code_list);exit();
        foreach ($code_list as $key => $value) {
            if (!isset($value['type'])) {
                $value['type'] = 'no';
            }
            $order_code[$key]['order_id']     = $order_info['order_id'];
            $order_code[$key]['store_id']     = $order_info['store_id'];
            $order_code[$key]['buyer_id']     = $order_info['buyer_id'];
            $order_code[$key]['coupon_cname'] = $value['cname'] ?? '';
            $vr_code                          = '';
            if (isset($value['code'])) {
                $vr_code = $value['code'];
            } else if (isset($value['no'])) {
                $vr_code = $value['no'];
            }
            $order_code[$key]['vr_code']           = $vr_code;
            $order_code[$key]['vr_secret']         = isset($value['secret']) ? $value['secret'] : '';
            $order_code[$key]['vr_qrcode']         = isset($value['qrcode']) ? $value['qrcode'] : '';
            $order_code[$key]['vr_barcode']        = isset($value['barcode']) ? $value['barcode'] : '';
            $order_code[$key]['vr_url']            = isset($value['url']) ? $value['url'] : '';
            $order_code[$key]['type']              = isset($code_type[$value['type']]) ? $code_type[$value['type']] : 1;
            $order_code[$key]['pay_price']         = $each_pay_price;
            $order_code[$key]['vr_start_time']     = isset($value['start_time']) ? $value['start_time'] : '';
            $order_code[$key]['vr_end_time']       = isset($value['end_time']) ? $value['end_time'] : '';
            $order_code[$key]['vr_indate']         = $order_info['vr_indate'];
            $order_code[$key]['vr_invalid_refund'] = $order_info['vr_invalid_refund'];
        }

        //将因舍出小数部分出现的差值补到最后一个商品的实际成交价中
//         $diff_amount = $order_info['order_amount'] - $each_pay_price * $order_info['goods_num'];
//         $order_code[$i-1]['pay_price'] += $diff_amount;

        return Db::name('vrordercode')->insertAll($order_code);
    }

    /**
     * 更改订单信息
     * @access public
     * @author csdeshang
     * @param array $data 数据
     * @param array $condition 条件
     * @param int $limit 限制
     * @return type
     */
    public function editVrorder($data, $condition, $limit = 0)
    {
        return Db::name('vrorder')->where($condition)->limit($limit)->update($data);
    }

    /**
     * 更新兑换码
     * @access public
     * @author csdeshang
     * @param type $data 数据
     * @param type $condition 条件
     * @return type
     */
    public function editVrorderCode($data, $condition)
    {
        return Db::name('vrordercode')->where($condition)->update($data);
    }

    /**
     * 兑换码列表
     * @access public
     * @author csdeshang
     * @param type $condition 条件
     * @param type $fields 字段
     * @param type $pagesize 分页
     * @param type $order 排序
     * @return type
     */
    public function getVrordercodeList($condition = [], $fields = '*', $pagesize = '', $order = 'rec_id desc')
    {
        if ($pagesize) {
            $res             = Db::name('vrordercode')->field($fields)->where($condition)->order($order)->paginate(['list_rows' => $pagesize, 'query' => request()->param()], false);
            $this->page_info = $res;
            return $res->items();
        } else {
            return Db::name('vrordercode')->field($fields)->where($condition)->order($order)->select()->toArray();
        }

    }

    /**
     * 兑换码列表
     * @access public
     * @author csdeshang
     * @param type $condition 条件
     * @param type $fields 字段
     * @return type
     */
    public function getCodeUnusedList($condition = [], $fields = '*')
    {
        $condition[] = ['vr_state', '=', 0];
        $condition[] = ['refund_lock', '=', 0];
        return $this->getVrordercodeList($condition, $fields);
    }

    /**
     * 根据虚拟订单取没有使用的兑换码列表
     * @access public
     * @author csdeshang
     * @param type $order_list 订单列表
     * @return type
     */
    public function getCodeRefundList($order_list = [])
    {
        if (!empty($order_list) && is_array($order_list)) {
            $order_ids = []; //订单编号数组
            foreach ($order_list as $key => $value) {
                $order_id             = $value['order_id'];
                $order_ids[$order_id] = $key;
            }
            $condition   = [];
            $condition[] = ['order_id', 'in', array_keys($order_ids)];
            $condition[] = ['refund_lock', '=', '0'];//退款锁定状态:0为正常(能退款),1为锁定(待审核),2为同意
            $code_list   = $this->getVrordercodeList($condition);
            if (!empty($code_list) && is_array($code_list)) {
                foreach ($code_list as $key => $value) {
                    $order_id = $value['order_id']; //虚拟订单编号
                    $rec_id   = $value['rec_id']; //兑换码表编号
                    if ($value['vr_state'] != '1') {//使用状态 0:未使用1:已使用2:已过期
                        $order_key                                    = $order_ids[$order_id];
                        $order_list[$order_key]['code_list'][$rec_id] = $value;
                    }
                }
            }
        }
        return $order_list;
    }

    /**
     * 取得兑换码列表
     * @access public
     * @author csdeshang
     * @param type $condition 条件
     * @param type $fields 字段
     * @return array
     */
    public function getShowVrordercodeList($condition = [], $fields = '*')
    {
        $code_list = $this->getVrordercodeList($condition);
        //进一步处理
        if (!empty($code_list)) {
            $i = 0;
            foreach ($code_list as $k => $v) {
                if ($v['vr_state'] == '1') {
                    $content = '已使用，使用时间 ' . date('Y-m-d', $v['vr_usetime']);
                } else if ($v['vr_state'] == '0') {
                    if ($v['vr_indate'] < TIMESTAMP) {
                        $content = '已过期，过期时间 ' . date('Y-m-d', $v['vr_indate']);
                    } else {
                        $content = '未使用，有效期至 ' . date('Y-m-d', $v['vr_indate']);
                    }
                }
                if ($v['refund_lock'] == '1') {
                    $content = '退款审核中';
                } else if ($v['refund_lock'] == '2') {
                    $content = '退款已完成';
                }
                $code_list[$k]['vr_code_desc'] = $content;
                if ($v['vr_state'] == '0')
                    $i++;
            }
            $code_list[0]['vr_code_valid_count'] = $i;
        }
        return $code_list;
    }

    /**
     * 取得兑换码信息
     * @param type $condition 条件
     * @param type $fields 字段
     * @return type
     */
    public function getVrordercodeInfo($condition = [], $fields = '*')
    {
        return Db::name('vrordercode')->field($fields)->where($condition)->find();
    }

    /**
     * 取得兑换码数量
     * @access public
     * @author csdeshang
     * @param type $condition 条件
     * @return type
     */
    public function getVrordercodeCount($condition)
    {
        return Db::name('vrordercode')->where($condition)->count();
    }

    /**
     * 生成兑换码 长度 =3位 + 4位 + 2位 + 3位  + 1位 + 5位随机  = 18位
     * @access public
     * @author csdeshang
     * @param string $perfix 前缀
     * @param type $store_id 店铺id
     * @param type $member_id 会员id
     * @param type $num 数字
     * @return string
     */
    private function _makeVrordercode($perfix, $store_id, $member_id, $num)
    {
        $perfix .= sprintf('%04d', (int)$store_id * $member_id % 10000)
            . sprintf('%02d', (int)$member_id % 100)
            . sprintf('%03d', (float)microtime() * 1000);

        $code_list = [];
        for ($i = 0; $i < $num; $i++) {
            $code_list[$i]['code'] = $perfix . sprintf('%01d', (int)$i % 10) . random(5, 1);
        }
        return $code_list;
    }

    /**
     * 取得订单列表(所有)
     * @access public
     * @author csdeshang
     * @param type $condition 条件
     * @param type $pagesize 分页
     * @param type $field 字段
     * @param type $order 排序
     * @param type $limit 限制
     * @return type
     */
    public function getVrorderList($condition, $pagesize = '', $field = '*', $order = 'order_id desc', $limit = 0)
    {
        if ($pagesize) {
            $list            = Db::name('vrorder')->field($field)->where($condition)->order($order)->limit($limit)->paginate(['list_rows' => $pagesize, 'query' => request()->param()], false);
            $this->page_info = $list;
            $list            = $list->items();
        } else {
            $list = Db::name('vrorder')->field($field)->where($condition)->order($order)->limit($limit)->select()->toArray();
        }


        if (empty($list))
            return [];
        foreach ($list as $key => $order) {
            if (isset($order['order_state'])) {
                list($list[$key]['state_desc'], $list[$key]['order_state_text']) = $this->_vrorderState($order['order_state']);
            }
            if (isset($order['payment_code'])) {
                $list[$key]['payment_name'] = get_order_payment_name($order['payment_code']);
            }
        }

        return $list;
    }

    /**
     * 取得订单状态文字输出形式
     * @access public
     * @author csdeshang
     * @param type $order_state 订单状态
     * @return type
     */
    private function _vrorderState($order_state)
    {
        switch ($order_state) {
            case ORDER_STATE_CANCEL:
                $order_state      = '<span style="color:#999">已取消</span>';
                $order_state_text = '已取消';
                break;
            case ORDER_STATE_NEW:
                $order_state      = '<span style="color:#36C">待付款</span>';
                $order_state_text = '待付款';
                break;
            case ORDER_STATE_PAY:
                $order_state      = '<span style="color:#999">已支付</span>';
                $order_state_text = '已支付';
                break;
            case ORDER_STATE_SUCCESS:
                $order_state      = '<span style="color:#999">已完成</span>';
                $order_state_text = '已完成';
                break;
        }
        return [$order_state, $order_state_text];;
    }

    /**
     * 返回是否允许某些操作
     * @access public
     * @author csdeshang
     * @param type $operate 操作
     * @param type $order_info 订单信息
     * @return boolean
     */
    public function getVrorderOperateState($operate, $order_info)
    {
        $state = false;
        if (!is_array($order_info) || empty($order_info))
            return false;

        switch ($operate) {

            //买家取消订单
            case 'buyer_cancel':
                $state = $order_info['order_state'] == ORDER_STATE_NEW;
                break;

            //商家取消订单
            case 'store_cancel':
                $state = $order_info['order_state'] == ORDER_STATE_NEW;
                break;

            //平台取消订单
            case 'system_cancel':
                $state = $order_info['order_state'] == ORDER_STATE_NEW;
                break;

            //平台收款
            case 'system_receive_pay':
                $state = $order_info['order_state'] == ORDER_STATE_NEW;
                break;

            //支付
            case 'payment':
                $state = $order_info['order_state'] == ORDER_STATE_NEW;
                break;

            //评价
            case 'evaluation':
                $state = !$order_info['refund_state'] && !isset($order_info['lock_state']) && $order_info['evaluation_state'] == '0' && $order_info['use_state'] && $order_info['order_state'] == ORDER_STATE_SUCCESS;
                break;

            //买家退款
            case 'refund':
                $state     = false;
                $code_list = isset($order_info['code_list']) ? $order_info['code_list'] : ''; //没有使用的兑换码列表
                if (!empty($code_list) && is_array($code_list)) {//没结算可以退款
                    if ($order_info['vr_indate'] > TIMESTAMP) {//有效期内的能退款
                        $state = true;
                    }
                    if ($order_info['vr_invalid_refund'] == 1 && ($order_info['vr_indate'] + 60 * 60 * 24 * config('ds_config.code_invalid_refund')) > TIMESTAMP) {//兑换码过期后可退款
                        $state = true;
                    }
                }
                break;
        }
        return $state;
    }

    /**
     * 订单详情页显示进行步骤
     * @access public
     * @author csdeshang
     * @param array $order_info 订单信息
     * @return array
     */
    public function getVrorderStep($order_info)
    {
        if (!is_array($order_info) || empty($order_info))
            return [];
        $step_list = [];
        // 第一步 下单完成
        $step_list['step1'] = true;
        //第二步 付款完成
        $step_list['step2'] = !empty($order_info['payment_time']);
        //第三步 兑换码使用中
        $step_list['step3'] = !empty($order_info['payment_time']);
        //第四步 使用完成或到期结束
        $step_list['step4'] = $order_info['order_state'] == ORDER_STATE_SUCCESS;
        return $step_list;
    }

    /**
     * 取得订单数量
     * @access public
     * @author csdeshang
     * @param array $condition 条件
     * @return int
     */
    public function getVrorderCount($condition)
    {
        return Db::name('vrorder')->where($condition)->count();
    }

    /**
     * 订单销售记录 订单状态为20、30、40时
     * @access public
     * @author csdeshang
     * @param type $condition 条件
     * @param type $field 字段
     * @param type $pagesize 分页
     * @param type $order 排序
     * @return type
     */
    public function getVrorderAndOrderGoodsSalesRecordList($condition, $field = "*", $pagesize = 0, $order = 'order_id desc')
    {
        $condition[] = ['order_state', 'in', [ORDER_STATE_PAY, ORDER_STATE_SUCCESS]];
        return $this->getVrorderList($condition, $pagesize, $field, $order);
    }

}