zhongshen_project/addon/cashier/shop/controller/Order.php

<?php
/**
 * Niushop商城系统 - 团队十年电商经验汇集巨献!
 * =========================================================
 * Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
 * ----------------------------------------------
 * 官方网址: https://www.niushop.com
 * =========================================================
 */

namespace addon\cashier\shop\controller;

use app\model\order\Config as ConfigModel;
use addon\cashier\model\order\CashierOrder as OrderModel;
use app\model\order\OrderCommon;
use app\model\order\OrderCommon as OrderCommonModel;
use app\model\order\OrderExport;
use app\model\store\Store;
use app\model\store\Store as StoreModel;
use app\model\system\Promotion as PromotionModel;
use app\model\system\UserGroup;
use app\model\web\Config as WebConfig;
use app\shop\controller\BaseShop;

/**
 * 订单
 * Class Order
 * @package app\shop\controller
 */
class Order extends BaseShop
{
    protected $replace = [
        'CASHIER_CSS' => __ROOT__ . '/addon/cashier/shop/view/public/css',
        'CASHIER_JS' => __ROOT__ . '/addon/cashier/shop/view/public/js',
        'CASHIER_IMG' => __ROOT__ . '/addon/cashier/shop/view/public/img',
    ];

    /**
     * 快递订单列表
     */
    public function lists()
    {
        $order_label_list = array (
            'order_no' => '订单号',
            'out_trade_no' => '交易流水号',
            'remark' => '订单备注',
            'name' => '收货人姓名',
            'order_name' => '商品名称',
            'mobile' => '收货人电话',
            'nick_name' => '会员昵称',
            'sku_no' => '商品编码',
        );

        $order_model = new OrderModel();
        $order_status = input('order_status', '');//订单状态
        $order_name = input('order_name', '');
        $pay_type = input('pay_type', '');
        $order_from = input('order_from', '');
        $start_time = input('start_time', '');
        $end_time = input('end_time', '');
        $delivery_start_time = input('delivery_start_time', '');
        $delivery_end_time = input('delivery_end_time', '');
        $order_label = !empty($order_label_list[ input('order_label') ]) ? input('order_label') : '';
        $search_text = input('search', '');
        $promotion_type = input('promotion_type', '');//订单类型
        $order_type = input('order_type', 'all');//营销类型
        $is_verify = input('is_verify', 'all');
        $cashier_order_type = input('cashier_order_type', 'all');
        $store_id = input('store_id', '');
        $field = 'a.*,s.store_name';

        $cashier_order_type_list = $order_model->cashier_order_type;
        $order_common_model = new OrderCommonModel();
        if (request()->isAjax()) {
            $page_index = input('page', 1);
            $page_size = input('page_size', PAGE_LIST_ROWS);
            $alias = 'a';
            $join = null;
            $condition = [
                [ 'a.site_id', '=', $this->site_id ],
                [ 'a.is_delete', '=', 0 ],
                [ 'a.order_scene', '=', 'cashier' ],
//                [ 'a.pay_status', '=', 1 ]
            ];
            //订单状态
            if ($order_status != '') {
                if ($order_status == 'refunding') {
                    $order_goods_list = $order_common_model->getOrderGoodsList([ [ 'refund_status', 'not in', [ 0, 3 ] ] ], 'order_id')[ 'data' ];
                    $order_id_arr = array_unique(array_column($order_goods_list, 'order_id'));
                    $condition[] = [ 'a.order_id', 'in', $order_id_arr ];
                } else {
                    $condition[] = [ 'a.order_status', '=', $order_status ];
                }
            }

            $order = 'a.create_time desc';

            $join[] = [
                'store s',
                's.store_id = a.store_id',
                'left'
            ];
            if ($is_verify != 'all') {
                $join[] = [
                    'verify v',
                    'v.verify_code = a.virtual_code',
                    'left'
                ];
                $condition[] = [ 'v.is_verify', '=', $is_verify ];
            }

            if ($store_id != '') {
                $condition[] = [ 'a.store_id', '=', $store_id ];
            }
            //订单内容 模糊查询
            if ($order_name != '') {
                $condition[] = [ 'a.order_name', 'like', '%' . $order_name . '%' ];
            }
            //订单来源
            if ($order_from != '') {
                $condition[] = [ 'a.order_from', '=', $order_from ];
            }
            //订单支付
            if ($pay_type != '') {
                $condition[] = [ 'a.pay_type', '=', $pay_type ];
            }
            //订单类型
            if ($order_type != 'all') {
                $condition[] = [ 'a.order_type', '=', $order_type ];
            }

            if ($cashier_order_type != 'all') {
                $condition[] = [ 'a.cashier_order_type', '=', $cashier_order_type ];
            }
            //营销类型
            if ($promotion_type != '') {
                if ($promotion_type == 'empty') {
                    $condition[] = [ 'a.promotion_type', '=', '' ];
                } else {
                    $condition[] = [ 'a.promotion_type', '=', $promotion_type ];
                }
            }
            if (!empty($start_time) && empty($end_time)) {
                $condition[] = [ 'a.create_time', '>=', date_to_time($start_time) ];
            } elseif (empty($start_time) && !empty($end_time)) {
                $condition[] = [ 'a.create_time', '<=', date_to_time($end_time) ];
            } elseif (!empty($start_time) && !empty($end_time)) {
                $condition[] = [ 'a.create_time', 'between', [ date_to_time($start_time), date_to_time($end_time) ] ];
            }

            if (!empty($delivery_start_time) && empty($delivery_end_time)) {
                $condition[] = [ 'a.buyer_ask_delivery_time', '>=', date_to_time($delivery_start_time) ];
            } elseif (empty($delivery_start_time) && !empty($delivery_end_time)) {
                $condition[] = [ 'a.buyer_ask_delivery_time', '<=', date_to_time($delivery_end_time) ];
            } elseif (!empty($delivery_start_time) && !empty($delivery_end_time)) {
                $condition[] = [ 'a.buyer_ask_delivery_time', 'between', [ date_to_time($delivery_start_time), date_to_time($delivery_end_time) ] ];
            }

            if ($search_text != '') {
                switch ( $order_label ) {
                    case 'nick_name':
                        $join[] = [
                            'member m',
                            'm.member_id = a.member_id',
                            'left'
                        ];
                        $condition[] = [ 'm.nickname', 'like', '%' . $search_text . '%' ];
                        break;
                    case 'sku_no':
                        $order_goods_list = $order_common_model->getOrderGoodsList([ [ 'sku_no', 'like', '%' . $search_text . '%' ] ], 'order_id')[ 'data' ];
                        $order_id_arr = array_unique(array_column($order_goods_list, 'order_id'));
                        $condition[] = [ 'a.order_id', 'in', $order_id_arr ];
                        break;
                    default:
                        $condition[] = [ 'a.' . $order_label, 'like', '%' . $search_text . '%' ];
                }
            }

            $store_id_arr = [];
            $userGroupModel = new UserGroup();
            $userInfo = $this->user_info;
            $userGroupWhere['uid'] = $userInfo['uid'];
            $userGroupList = $userGroupModel->getUserList($userGroupWhere,'uid,store_id');
            $store_id_arr = array_column($userGroupList['data'],'store_id');
            if(!empty($store_id_arr) &&  !$userInfo['is_admin']){
                $condition[] = [ "a.store_id", "in", $store_id_arr];
            }

            $list = $order_common_model->getOrderPageList($condition, $page_index, $page_size, $order, $field, $alias, $join);
            if (!empty($list[ 'data' ][ 'list' ])) {
                foreach ($list[ 'data' ][ 'list' ] as $k => $v) {
                    $list[ 'data' ][ 'list' ][ $k ][ 'cashier_order_type_name' ] = $cashier_order_type_list[ $v[ 'cashier_order_type' ] ];
                }
            }
            $list[ 'data' ][ 'order_status' ] = $order_status;
            return $list;
        } else {

            $order_type_list = $order_common_model->getOrderTypeStatusList();
            $this->assign('order_type_list', $order_type_list);
            $this->assign('order_label_list', $order_label_list);

            $this->assign('order_status_list', $order_type_list[ 1 ][ 'status' ]);//订单状态
            //订单来源 (支持端口)
            $this->assign('order_from_list', $order_common_model->getOrderFromList());

            $pay_type = $order_common_model->getPayType([ 'order_type' => 5 ]);
            $this->assign('pay_type_list', $pay_type);

            $this->assign('order_status', $order_status);
            $this->assign('cashier_order_type_list', $cashier_order_type_list);
            $this->assign('http_type', get_http_type());

            $config_model = new ConfigModel();
            $order_config = $config_model->getOrderEventTimeConfig($this->site_id, $this->app_module)[ 'data' ][ 'value' ] ?? [];
            $this->assign('order_config', $order_config);

            $config_model = new WebConfig();
            $mp_config = $config_model->getMapConfig($this->site_id);
            $this->assign('tencent_map_key', $mp_config[ 'data' ][ 'value' ][ 'tencent_map_key' ]);

            $store_list = ( new Store() )->getStoreList([ [ 'site_id', '=', $this->site_id ] ], 'store_name,store_id')[ 'data' ];
            $this->assign('store_list', $store_list);

            return $this->fetch('order/lists', [], $this->replace);
        }

    }

    /**
     * 快递订单详情
     */
    public function detail()
    {
        $order_id = input('order_id', 0);
        $order_common_model = new OrderCommonModel();
        $order_detail_result = $order_common_model->getOrderDetail($order_id);
        $order_detail = $order_detail_result[ 'data' ];

        if (empty($order_detail)) $this->error('未获取到订单数据', addon_url('shop/order/lists'));

        $this->assign('order_detail', $order_detail);

        $this->assign('http_type', get_http_type());

        $config_model = new WebConfig();
        $mp_config = $config_model->getMapConfig($this->site_id);
        $this->assign('tencent_map_key', $mp_config[ 'data' ][ 'value' ][ 'tencent_map_key' ]);

        return $this->fetch('order/detail');
    }
    public function exportMoneyOrder2()
    {
        $order_label_list = array (
            'order_no' => '订单号',
            'out_trade_no' => '外部单号',
            'name' => '收货人姓名',
            'mobile' => '收货人手机号',
            'order_name' => '商品名称',
            'nick_name' => '会员昵称'
        );


        $order_status = input('order_status', '');//订单状态
        $order_name = input('order_name', '');
        $pay_type = input('pay_type', '');
        $order_from = input('order_from', '');
        $start_time = input('start_time', '');
        $end_time = input('end_time', '');
        $order_label = !empty($order_label_list[ input('order_label') ]) ? input('order_label') : '';
        $search_text = input('search', '');
        $promotion_type = input('promotion_type', '');
        $order_type = input('order_type', 'all');
        $is_verify = input('is_verify', 'all');
        $order_ids = input('order_ids', '');
        $store_id = input('store_id', 0);
        $condition_desc = [];

        $order_common_model = new OrderCommon();
        $condition = [
            [ 'o.site_id', '=', $this->site_id ],
            [ 'o.is_delete', '=', 0 ],
            [ 'o.order_scene', '=', 'cashier' ]
        ];

        if (!empty($order_ids)) {
            $condition[] = [ 'o.order_id', 'in', $order_ids ];
            $condition_desc[] = [ 'name' => 'order_id', 'value' => $order_ids ];
        }

        //订单类型
        $order_type_name = '全部';
        if ($order_type != 'all') {
            $condition[] = [ 'o.order_type', '=', $order_type ];

            $order_type_list = $order_common_model->getOrderTypeStatusList();
            $order_type_list = array_column($order_type_list, 'name', 'type');
            $order_type_name = $order_type_list[ $order_type ];
        }
        $condition_desc[] = [ 'name' => '订单类型', 'value' => $order_type_name ];

        //订单状态
        $order_status_name = '全部';
        if ($order_status != '') {
            if ($order_status != 'refunding') {
                $condition[] = [ 'o.order_status', '=', $order_status ];
                $order_status_list = $order_common_model->order_status;
                $order_status_name = $order_status_list[ $order_status ][ 'name' ] ?? '';
            } else {
                $join = [
                    [
                        'order_goods og',
                        'og.order_id = o.order_id',
                        'left'
                    ]
                ];
                $condition[] = [ 'og.refund_status', 'not in', [ 0, 3 ] ];
                $order_status_name = '维权中';
            }

        }
        $condition_desc[] = [ 'name' => '订单状态', 'value' => $order_status_name ];

        //订单内容 模糊查询
        if ($order_name != '') {
            $condition[] = [ 'o.order_name', 'like', '%' . $order_name . '%' ];
        }

        if ($is_verify != 'all') {
            $condition[] = [ 'v.is_verify', '=', $is_verify ];
        }

        //订单来源
        $order_from_name = '全部';
        if ($order_from != '') {
            $condition[] = [ 'o.order_from', '=', $order_from ];
            //订单来源 (支持端口)
            $order_from_list = $order_common_model->getOrderFromList();
            $order_from_name = $order_from_list[ $order_from ][ 'name' ] ?? '';
        }
        $condition_desc[] = [ 'name' => '订单来源', 'value' => $order_from_name ];

        //订单支付
        $pay_type_name = '全部';
        if ($pay_type != '') {
            $condition[] = [ 'o.pay_type', '=', $pay_type ];
            $pay_type_list = $order_common_model->getPayType();
            $pay_type_name = $pay_type_list[ $pay_type ] ?? '';
        }
        $condition_desc[] = [ 'name' => '支付方式', 'value' => $pay_type_name ];

        //营销类型
        $promotion_type_name = '全部';
        if ($promotion_type != '') {
            if ($promotion_type == 'empty') {
                $condition[] = [ 'o.promotion_type', '=', '' ];
            } else {
                $condition[] = [ 'o.promotion_type', '=', $promotion_type ];
            }
            //营销活动类型
            $promotion_model = new PromotionModel();
            $promotion_type_list = $promotion_model->getPromotionType();
            $promotion_type_list = array_column($promotion_type_list, 'name', 'type');
            $promotion_type_name = $promotion_type_list[ $promotion_type ] ?? '';
        }
        $condition_desc[] = [ 'name' => '营销活动', 'value' => $promotion_type_name ];
        $time_name = '';
        if (!empty($start_time) && empty($end_time)) {
            $condition[] = [ 'o.create_time', '>=', date_to_time($start_time) ];
            $time_name = $start_time . '起';
        } elseif (empty($start_time) && !empty($end_time)) {
            $condition[] = [ 'o.create_time', '<=', date_to_time($end_time) ];
            $time_name = '至' . $end_time;
        } elseif (!empty($start_time) && !empty($end_time)) {
            $condition[] = [ 'o.create_time', 'between', [ date_to_time($start_time), date_to_time($end_time) ] ];
            $time_name = $start_time . ' 至 ' . $end_time;
        }
        $condition_desc[] = [ 'name' => '下单时间', 'value' => $time_name ];

        if ($order_label != 'nick_name') {
            if ($search_text != '') {
                $condition[] = [ 'o.' . $order_label, 'like', '%' . $search_text . '%' ];
            }
            foreach ($order_label_list as $k => $v) {
                $order_label_name = $v;
                if ($k == $order_label) {
                    $condition_desc[] = [ 'name' => $order_label_name, 'value' => $search_text ];
                } else {
                    $condition_desc[] = [ 'name' => $order_label_name, 'value' => '' ];
                }
            }
        } else {
            $condition[] = [ 'm.nickname', 'like', '%' . $search_text . '%' ];
        }

        if (addon_is_exit('store') == 1 && !empty($store_id)) {
            $store_model = new StoreModel();
            $store_info = $store_model->getStoreInfo([ [ 'store_id', '=', $store_id ] ], 'store_name')[ 'data' ];

            $condition[] = [ 'o.store_id', '=', $store_id ];
            $condition_desc[] = [ 'name' => '来源门店', 'value' => $store_info[ 'store_name' ] ];
        }

        $order_export_model = new OrderExport();
        outFileLog($order_label,'order','$order_label');
        $result = $order_export_model->orderExport($condition, $condition_desc, $this->site_id, $join ?? null, $is_verify, $order_label);
        return $result;
    }
}