mall/utils/ExportList.php

<?php
/**
 * 重庆赤晓店信息科技有限公司
 * https://www.chixiaodian.com
 * Copyright (c) 2023 赤店商城 All rights reserved.
 */
namespace app\utils;


use app\models\Goods;
use app\models\Order;
use app\models\OrderDetail;
use app\models\OrderRefund;
use app\models\OrderStateFlow;
use yii\helpers\Json;
use app\modules\admin\models\ShareOrderForm;

class ExportList
{
    public $order_type = 0; // 0--商城 1--秒杀 2--拼团 3--预约 4--积分商城 5--分销

    public $is_offline; // 0--非自提 1--自提
    public $is_delivery;
    public $fields;
    public $type; // 0--非售后 1--售后


    public function getList()
    {
        $list = [
            [
                'key' => 'order_no',
                'value' => '订单编号',
                'hidden' => false,
                'selected' => 0,
                'type' => [0, 1],
            ],
            [
                'key' => 'nickname',
                'value' => '下单用户',
                'hidden' => false,
                'selected' => 0,
                'type' => [0, 1],
            ],
            [
                'key' => 'good_name',
                'value' => '商品名称',
                'hidden' => false,
                'selected' => 0,
                'type' => [0, 1],
            ],
            [
                'key' => 'attr',
                'value' => '商品规格',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [0, 1],
            ],
            [
                'key' => 'good_num',
                'value' => '商品数量',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [0, 1],
            ],
            [
                'key' => 'good_no',
                'value' => '商品货号',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4],
                'type' => [0, 1],
            ],
            [
                'key' => 'name',
                'value' => '收件人',
                'selected' => 0,
                'hidden' => false,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [0, 1],
            ],
            [
                'key' => 'mobile',
                'value' => '收件电话',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [0, 1],
            ],
            [
                'key' => 'address',
                'value' => '收件地址',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [0, 1],
            ],
            [
                'key' => 'cost_price',
                'value' => '成本价',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0],
                'type' => [0],
            ],
            [
                'key' => 'total_price',
                'value' => '总金额',
                'hidden' => false,
                'selected' => 0,
                'type' => [0],
            ],
            [
                'key' => 'pay_price',
                'value' => '实际付款',
                'hidden' => false,
                'selected' => 0,
                'type' => [0],
            ],
            [
                'key' => 'integral',
                'value' => '积分',
                'hidden' => false,
                'selected' => 0,
                'type' => [4],
            ],
            [
                'key' => 'express_price',
                'value' => '运费',
                'hidden' => true,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [0],
            ],
            [
                'key' => 'express_no',
                'value' => '快递单号',
                'hidden' => true,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [0],
            ],
            [
                'key' => 'express',
                'value' => '快递公司',
                'hidden' => true,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [0],
            ],
            [
                'key' => 'clerk_name',
                'value' => '核销人',
                'hidden' => true,
                'selected' => 0,
                'type' => [0],
            ],
            [
                'key' => 'shop_name',
                'value' => '核销门店',
                'hidden' => true,
                'selected' => 0,
                'type' => [0],
            ],
            [
                'key' => 'created_at',
                'value' => '下单时间',
                'hidden' => false,
                'selected' => 0,
                'type' => [0],
            ],
            [
                'key' => 'pay_type',
                'value' => '支付方式',
                'hidden' => false,
                'selected' => 0,
                'type' => [0],
            ],
            [
                'key' => 'order_status',
                'value' => '订单状态',
                'hidden' => true,
                'selected' => 0,
                'type' => [0],
            ],
            [
                'key' => 'apply_delete',
                'value' => '申请状态',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4],
                'type' => [0],
            ],
            [
                'key' => 'trade_status',
                'value' => '订单流转状态',
                'hidden' => false,
                'selected' => 0,
                'type' => [0],
            ],
            [
                'key' => 'status',
                'value' => '拼团状态',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [2],
                'type' => [0],
            ],
            [
                'key' => 'is_pay',
                'value' => '付款状态',
                'hidden' => false,
                'selected' => 0,
                'type' => [0],
            ],
            [
                'key' => 'pay_time',
                'value' => '付款时间',
                'hidden' => false,
                'selected' => 0,
                'type' => [0],
            ],
            [
                'key' => 'send_time',
                'value' => '发货时间',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4],
                'type' => [0],
            ],
            [
                'key' => 'confirm_time',
                'value' => '收货时间',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4],
                'type' => [0],
            ],
            [
                'key' => 'content',
                'value' => '备注/表单',
                'hidden' => false,
                'selected' => 0,
                'type' => [0],
            ],
            [
                'key' => 'words',
                'value' => '买家留言',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [0],
            ],
            [
                'key' => 'is_use',
                'value' => '使用状态',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [3],
                'type' => [0],
            ],
            [
                'key' => 'use_time',
                'value' => '使用时间',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [3],
                'type' => [0],
            ],
            [
                'key' => 'refund_type',
                'value' => '售后类型',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4],
                'type' => [1],
            ],
            [
                'key' => 'refund_price',
                'value' => '退款金额',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4],
                'type' => [1],
            ],
            [
                'key' => 'refund_desc',
                'value' => '申请理由',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4],
                'type' => [1],
            ],
            [
                'key' => 'refund_status',
                'value' => '状态',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [1],
            ],
            [
                'key' => 'refund_refuse_desc',
                'value' => '售后拒绝理由',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4],
                'type' => [1],
            ],
            [
                'key' => 'refund_time',
                'value' => '售后申请时间',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4],
                'type' => [1],
            ],
            [
                'key' => 'user_send_express',
                'value' => '用户发货快递公司',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [1],
            ],
            [
                'key' => 'user_send_express_no',
                'value' => '用户发货快递单号',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 4, 5],
                'type' => [1],
            ],
            [
                'key' => 'rebate',
                'value' => '自购返利',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [5],
                'type' => [0, 1],
            ],
            [
                'key' => 'share_commission_first',
                'value' => '一级分销商',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [5],
                'type' => [0, 1],
            ],
            [
                'key' => 'share_commission_second',
                'value' => '二级分销商',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [5],
                'type' => [0, 1],
            ],
            [
                'key' => 'share_commission_third',
                'value' => '三级分销商',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [5],
                'type' => [0, 1],
            ],
            [
                'key' => 'merchant_remark',
                'value' => '商家备注',
                'hidden' => false,
                'selected' => 0,
                'order_type' => [0, 1, 2, 3],
                'type' => [0, 1],
            ],

        ];
        foreach ($list as $i => $item) {
            if (isset($item['order_type']) && !in_array($this->order_type, $item['order_type'])) {
                unset($list[$i]);
                continue;
            }
            if (isset($item['type']) && !in_array($this->type, $item['type'])) {
                unset($list[$i]);
                continue;
            }
        }

        return $list;
    }

    /**
     * @param $data array 需要处理的数据
     */
    public function dataTransform($data)
    {
        $newFields = [];
        $pay_type_list = ['微信支付', '微信支付', '货到付款', '余额支付'];
        foreach ($this->fields as &$item) {
            if ($this->is_offline == 1) {
                if (in_array($item['key'], ['clerk_name', 'shop_name'])) {
                    $item['selected'] = 1;
                }
            } else {
                if (in_array($item['key'], ['express_price', 'express_no', 'express'])) {
                    $item['selected'] = 1;
                }
            }
            if (isset($item['selected']) && $item['selected'] == 1) {
                $newFields[$item['key']] = $item['value'];
            }
        }

        $newList = [];
        foreach ($data as $datum) {
            $newItem = [];
            $newItem['order_no'] = $datum->order_no;
            $newItem['nickname'] = $datum->user->nickname;
            $newItem['platform'] = $datum->user->platform ? '支付宝' : '微信';
            $newItem['total_price'] = $datum->total_price;
            $newItem['pay_price'] = $datum->pay_price;
            $newItem['pay_type'] = $pay_type_list[$datum->pay_type];
            $newItem['is_pay'] = $datum['is_pay'] == 1 ? "已付款" : "未付款";
            $newItem['created_at'] = date('Y-m-d H:i', $datum['created_at']);
            $newItem['pay_time'] = $datum->pay_time ? date('Y-m-d H:i', $datum->pay_time) : '';

            //是否到店自提 0--否 1--是
            if ((isset($datum['is_offline']) && $datum['is_offline']) || (isset($datum['offline']) && $datum['offline'] == 2) || $this->order_type == 3) {
                $newItem['clerk_name'] = $datum->clerk ? $datum->clerk->nickname : '';
                $newItem['shop_name'] = $datum->shop ? $datum->shop->name : '';
            } else {
                $newItem['express_price'] = $datum->express_price;
                $newItem['express_no'] = $datum->express_no;
                $newItem['express'] = $datum->express;
            }

            $newItem['name'] = $datum->name;
            $newItem['mobile'] = $datum->mobile;
            $newItem['address'] = $datum->address;
            $newItem['apply_delete'] = ($datum['apply_delete'] == Order::ORDER_APPLY_DELETE) ? ($datum['trade_status'] == Order::ORDER_FLOW_CANCEL || $datum['is_delete'] == Order::IS_DELETE_TRUE ? '取消成功' : '取消中') : "无";
            $newItem['trade_status'] = OrderStateFlow::getFlowWords($datum['trade_status']);
            $newItem['send_time'] = $datum->send_time ? date('Y-m-d H:i', $datum->send_time) : '';
            $newItem['confirm_time'] = $datum->confirm_time ? date('Y-m-d H:i', $datum->confirm_time) : '';
            $newItem['words'] = isset($datum->words) ? $datum->words : '';
            $newItem['goods_list'] = $this->getOrderGoodsList($datum->id);
            if ($datum->orderForm) {
                $str = '';
                foreach ($datum->orderForm as $key => $item) {
                    $str .= $item['key'] . ':' . $item['value'] . ',';
                }
                $newItem['content'] = rtrim($str, ',');
            } else {
                $newItem['content'] = $datum->content;
            }

            $newList[] = $newItem;
        }
        Export::order_3($newList, $newFields);
    }


    // 商城订单详情
    private function getOrderGoodsList($order_id)
    {
        $orderDetailList = OrderDetail::find()->alias('od')
            ->leftJoin(['g' => Goods::tableName()], 'od.goods_id=g.id')
            ->where([
                'od.is_delete' => 0,
                'od.order_id' => $order_id,
            ])->select(['od.*', 'g.name', 'g.unit', 'g.attr goods_attr'])->asArray()->all();
        foreach ($orderDetailList as $i => &$item) {
            $item['attr_list'] = Json::decode($item['attr']);
            $item['good_no'] = $this->getGoodNo($item['attr_list'], $item['goods_attr']);
        }
        return $orderDetailList;
    }

    public function shareExportData($data, $field)
    {
        $newData = [];
        foreach ($data as $item) {
            $d = [];
            $d['order_no'] = $item['order_no'];
            $d['nickname'] = $item['nickname'];
            $d['price'] = $item['price'];
            $d['created_at'] = date('Y-m-d H:i:s', $item['created_at']);
            $d['bank_name'] = $item['bank_name'];
            $d['name'] = $item['name'];
            $d['pay_type'] = $item['pay_type'];
            $d['platform'] = $item['platform'] ? '支付宝' : '微信';
            $d['bank_card'] = $item['mobile'];
            $d['pay_time'] = isset($item['pay_time']) ? date('Y-m-d H:i:s', $item['pay_time']) : '';
            switch ($item['pay_type']) {
                case 0:
                    $d['pay_type'] = '待打款';
                    break;
                case 1:
                    $d['pay_type'] = '微信自动打款';
                    break;
                case 2:
                    $d['pay_type'] = '手动打款';
                    break;
                default:
                    $d['pay_type'] = '未知';
                    break;
            }
            switch ($item['type']) {
                case 0:
                    $d['type'] = '微信支付';
                    break;
                case 1:
                    $d['type'] = '支付宝支付';
                    break;
                case 2:
                    $d['type'] = '银行卡';
                    break;
                case 3:
                    $d['type'] = '余额';
                    break;
                default:
                    $d['type'] = '未知';
                    break;
            }
            $newData[] = $d;
        }

        $newFields = [];
        foreach ($field as $item) {
            if ($item['selected']) {
                $newFields[$item['key']] = $item['value'];
            }
        }

        Export::order_3($newData, $newFields);
    }

    /**
     * 分销订单导出
     */
    public function shareOrderExportData($sql)
    {
        $handle = fopen('php://temp', 'rwb');
        $newFields = [];
        foreach ((array)$this->fields as $item) {
            if (isset($item['selected']) && $item['selected'] == 1) {
                $newFields[$item['key']] = $item['value'];
            }
        }
        $EXCEL_OUT = Export::order_title($newFields);
        fwrite($handle, $EXCEL_OUT);

        $limit = 1000;
        $count = \Yii::$app->db->createCommand("select count(*) " . $sql)->queryScalar();
        $select = "SELECT `al`.*,u.nickname,u.platform ";
        for ($i = 0; $i < $count; $i += $limit) {
            $list = \Yii::$app->db->createCommand($select . $sql . " ORDER BY created_at DESC LIMIT {$limit} OFFSET {$i}")->queryAll();

            $shareOrderForm = new ShareOrderForm();
            $shareOrderForm->store_id = get_store_id();
            $data = $shareOrderForm->transform($list);

            $pay_type_list = ['微信支付', '微信支付', '货到付款', '余额支付'];
            foreach ((array)$this->fields as &$item) {
                if ($this->is_offline == 1) {
                    if (in_array($item['key'], ['clerk_name', 'shop_name'])) {
                        $item['selected'] = 1;
                    }
                } else {
                    if (in_array($item['key'], ['express_price', 'express_no', 'express'])) {
                        $item['selected'] = 1;
                    }
                }
                if (isset($item['selected']) && $item['selected'] == 1) {
                    $newFields[$item['key']] = $item['value'];
                }
            }

            $newList = [];
            foreach ($data as $datum) {
                $newItem = [];
                $newItem['order_no'] = $datum['order_no'];
                $newItem['nickname'] = $datum['nickname'];
                $newItem['platform'] = $datum['platform'] ? '支付宝' : '微信';
                $newItem['total_price'] = $datum['total_price'];
                $newItem['pay_price'] = $datum['pay_price'];
                $newItem['pay_type'] = $pay_type_list[$datum['pay_type']];
                $newItem['is_pay'] = $datum['is_pay'] == 1 ? "已付款" : "未付款";
                $newItem['created_at'] = $datum['created_at'];
                $newItem['pay_time'] = $datum['pay_time'] > 0 ? date('Y-m-d H:i:s', $datum['pay_time']) : '';
                $newItem['platform'] = $datum['platform'] ? '支付宝' : '微信';
                $newItem['express_price'] = $datum['express_price'];
                $newItem['name'] = $datum['name'];
                $newItem['mobile'] = $datum['mobile'];
                $newItem['address'] = $datum['address'];
                $newItem['express_no'] = $datum['express_no'];
                $newItem['express'] = $datum['express'];
                $newItem['goods_list'] = $datum['goods_list'];
                $newItem['words'] = $datum['words'];
                $newItem['remark'] = $datum['remark'];

                $newItem['rebate'] = $datum['rebate'];
                $share = isset($datum['share']) ? '昵称:' . $datum['share']['nickname'] . '，姓名:' . $datum['share']['name'] . '，手机号:' . $datum['share']['mobile'] . '，佣金:' . floatval($datum['first_price']) . '|' : '';
                if ($share) {
                    $newItem['share_commission_first'] = $share;
                }
                $share1 = isset($datum['share_1']) ? '昵称:' . $datum['share_1']['nickname'] . '，姓名:' . $datum['share_1']['name'] . '，手机号:' . $datum['share_1']['mobile'] . '，佣金:' . floatval($datum['second_price']) . '|' : '';
                if ($share1) {
                    $newItem['share_commission_second'] = $share1;
                }
                $share2 = isset($datum['share_2']) ? '昵称:' . $datum['share_2']['nickname'] . '，姓名:' . $datum['share_2']['name'] . '，手机号:' . $datum['share_2']['mobile'] . '，佣金:' . floatval($datum['third_price']) . '|' : '';
                if ($share2) {
                    $newItem['share_commission_third'] = $share2;
                }

                $newList[] = $newItem;
            }

            $EXCEL_OUT = Export::order_new($newList, $newFields);
            fwrite($handle, $EXCEL_OUT);
        }

        $name = date('YmdHis', time()) . rand(1000, 9999); //导出文件名称
        \Yii::$app->response->sendStreamAsFile($handle, $name . '.csv');

    }

    /**
     * 用户信息导出
     */
    public function UserExportData($list)
    {
        $handle = fopen('php://temp', 'rwb');
        $newFields = $this->dataFields();
        $newFields['platform'] = '所属平台';
        $fieldVals = implode(',', array_values($newFields)) . "\n";
        $EXCEL_OUT = mb_convert_encoding($fieldVals, 'GBK', 'UTF-8');

        fwrite($handle, $EXCEL_OUT);

        foreach ($list as $item) {
            $arr = [];
            $arr['id'] = $item['id'];
            $arr['open_id'] = trim("\"\t" . $item['wechat_open_id'] . "\"");
            $arr['nickname'] = $item['nickname'];
            $arr['binding'] = $item['binding'];
            $arr['contact_way'] = $item['contact_way'];
            $arr['comments'] = $item['comments'];
            $arr['created_at'] = trim("\"\t" . date('Y-m-d H:i:s', $item['created_at']) . "\"");

            $clerk = $item['is_clerk'] ? '核销员|' : '';
            $level = isset($item['l_name']) ? $item['l_name'] : '普通会员';
            $arr['identity'] = $clerk . $level;

            $arr['order_count'] = $item['order_count'] ? $item['order_count'] : 0;

            $order = empty($item['orderConsume']) ? 0 : floatval($item['orderConsume']);
            $pt = empty($item['ptOrderConsume']) ? 0 : floatval($item['ptOrderConsume']);
            $yy = empty($item['yyOrderConsume']) ? 0 : floatval($item['yyOrderConsume']);
            $ms = empty($item['msOrderConsume']) ? 0 : floatval($item['msOrderConsume']);
            $integral = empty($item['integralOrderConsume']) ? 0 : floatval($item['integralOrderConsume']);
            $arr['consume_count'] = $order + $pt + $yy + $ms + $integral;
            $arr['coupon_count'] = $item['coupon_count'] ? $item['coupon_count'] : 0;
            $arr['card_count'] = $item['card_count'] ? $item['card_count'] : 0;
            $arr['integral'] = $item['integral'];
            $arr['money'] = $item['money'];
            $arr['platform'] = $item['platform'] ? '支付宝' : '微信';

            $fieldVals = implode(',', array_values($arr)) . "\n";
            $EXCEL_OUT = mb_convert_encoding($fieldVals, 'GBK', 'UTF-8');

            fwrite($handle, $EXCEL_OUT);
        }

        $name = date('YmdHis', time()) . rand(1000, 9999); //导出文件名称
        \Yii::$app->response->sendStreamAsFile($handle, $name . '.csv');

//        Export::order_3($newList, $newFields);
    }

    /**
     * 分销信息导出
     */
    public function ShareInfoExportData($list)
    {
        $newFields = $this->dataFields();

        $newList = [];
        foreach ($list as $item) {
            $arr = [];
            $arr['id'] = $item['id'];
            $arr['nickname'] = $item['nickname'];
            $arr['created_at'] = date('Y-m-d H:i:s', $item['created_at']);
            $arr['time'] = date('Y-m-d H:i:s', $item['time']);
            $arr['name'] = $item['name'];
            $arr['mobile'] = $item['mobile'];
            $arr['platform'] = $item['platform'] ? '支付宝' : '微信';
            $arr['total_price'] = $item['total_price'];
            $arr['price'] = $item['price'];
            $arr['parent_nickname'] = $item['parent_nickname'] ? $item['parent_nickname'] : '总店';
            $arr['seller_comments'] = $item['seller_comments'];

            switch ($item['status']) {
                case 0:
                    $arr['status'] = '待审核';
                    break;
                case 1:
                    $arr['status'] = '审核通过';
                    break;
                case 2:
                    $arr['status'] = '审核未通过';
                    break;
                default:
                    $arr['status'] = '未知';
                    break;
            }

            $arr['lower_user'] = '一级：' . $item['first'] . '| 二级：' . $item['second'] . '| 三级：' . $item['third'];

            $order = $item['order_count'] ? $item['order_count'] : 0;
            $ms = $item['ms_order_count'] ? $item['ms_order_count'] : 0;
            $pt = $item['pt_order_count'] ? $item['pt_order_count'] : 0;
            $yy = $item['yy_order_count'] ? $item['yy_order_count'] : 0;
            $arr['order'] = '商城订单：' . $order . '| 秒杀订单：' . $ms . '| 拼团订单：' . $pt . '| 预约订单：' . $yy;

            $newList[] = $arr;
        }

        Export::order_3($newList, $newFields);
    }

    /**
     * 分销信息导出
     */
    public function MchReportFormsExportData($list)
    {
        $newFields = $this->dataFields();

        $newList = [];
        foreach ($list as $item) {
            $arr = [];
            $arr['id'] = $item['id'];
            $arr['name'] = $item['name'];
            $arr['good_name'] = $item['good_name'];
            $arr['sales_volume'] = $item['sales_volume'];
            $arr['sales_price'] = $item['sales_price'];

            $newList[] = $arr;
        }

        Export::dataNew($newList, $newFields);
    }

    /**
     * 售后订单导出 数据处理
     */
    public function refundForm($data)
    {
        $newFields = [];
        foreach ($this->fields as $item) {
            if (isset($item['selected']) && $item['selected'] == 1) {
                $newFields[$item['key']] = $item['value'];
            }
        }

        $newList = [];
        foreach ($data as $item) {
            $newItem = $item;
            $goods_no = $this->getGoodNo(Json::decode($item['attr']), $item['goods_attr']);
            $newItem['goods_list'] = [
                [
                    'name' => $item['goods_name'],
                    'attr' => $item['attr'],
                    'good_num' => $item['num'],
                    'good_no' => $goods_no,
                ]
            ];
            switch ($item['refund_type']) {
                case 1:
                    $newItem['refund_type'] = "退货退款";
                    break;
                case 2:
                    $newItem['refund_type'] = "换货";
                    break;
                default:
                    $newItem['refund_type'] = "";
                    break;
            }

            switch ($item['refund_status']) {
                case 0:
                    $newItem['refund_status'] = "待处理";
                    break;
                case 1:
                    $newItem['refund_status'] = "已同意退款退货";
                    break;
                case 2:
                    $newItem['refund_status'] = "已同意换";
                    break;
                case 3:
                    $newItem['refund_status'] = "已拒绝";
                    break;
                default:
                    $newItem['refund_status'] = "";
                    break;
            }
            $newItem['refund_time'] = date('Y-m-d H:i', $item['created_at']);

            $newList[] = $newItem;
        }

        Export::order_3($newList, $newFields);
    }

    private function getGoodNo($attr, $goods_attr)
    {
        $good_no = '';
        if (!$goods_attr) {
            return $good_no;
        }
        $ok = false;
        $attr_id_list = [];
        foreach ($attr as $item) {
            $attr_id_list[] = intval($item['attr_id']);
            if (isset($item['no'])) {
                $good_no = $item['no'];
                $ok = true;
                break;
            }
        }
        if (!$ok) {
            sort($attr_id_list);
            $attr_rows = json_decode($goods_attr, true);
            if (empty($attr_rows)) {
                $good_no = '';
            }

            foreach ($attr_rows as $i => $attr_row) {
                $key = [];
                foreach ($attr_row['attr_list'] as $j => $attr) {
                    $key[] = $attr['attr_id'];
                }
                sort($key);
                if (!array_diff($attr_id_list, $key)) {
                    if ($attr_row['no']) {
                        $good_no = $attr_row['no'];
                    }
                }
            }
        }

        return $good_no;
    }

    public function dataTransform_new($query)
    {
        $handle = fopen('php://temp', 'rwb');
        $newFields = $this->dataFields();
        $EXCEL_OUT = Export::order_title($newFields);
        fwrite($handle, $EXCEL_OUT);
        $limit = 100;
        $count = $query->count();
        for ($i = 0; $i < $count; $i += $limit) {
            $query->select('o.*');
            $query->with(['user', 'clerk', 'shop', 'orderDetail', 'orderForm']);
            $data = $query->limit($limit)->offset($i)->orderBy('o.created_at DESC')->asArray()->all();
            $data = $this->data_new($data);
            $EXCEL_OUT = Export::order_new($data, $newFields);
            fwrite($handle, $EXCEL_OUT);
        }
        $name = date('YmdHis', time()) . rand(1000, 9999); //导出文件名称
        \Yii::$app->response->sendStreamAsFile($handle, $name . '.csv');
    }

    // 获取需要导出的字段
    private function dataFields()
    {
        $newFields = [];
        foreach ($this->fields as &$item) {
            if ($this->is_offline == 1) {
                if (in_array($item['key'], ['clerk_name', 'shop_name'])) {
                    $item['selected'] = 1;
                }
            } else {
                if (in_array($item['key'], ['express_price', 'express_no', 'express'])) {
                    $item['selected'] = 1;
                }
            }
            if (isset($item['selected']) && $item['selected'] == 1) {
                $newFields[$item['key']] = $item['value'];
            }
        }
        return $newFields;
    }

    /**
     * @param $data array 需要处理的数据 临时处理
     */
    private function data_new(&$data)
    {
        $pay_type_list = ['微信支付', '微信支付', '货到付款', '余额支付'];
        $newList = [];
        foreach ($data as &$datum) {
            $newItem = [];
            $newItem['order_no'] = $datum['order_no'];
            $newItem['nickname'] = $datum['user']['nickname'];
            // $newItem['platform'] = $datum->user['platform'] ? '支付宝' : '微信';

            $costPriceCount = 0;
            if ($datum['orderDetail']) {
                foreach ($datum['orderDetail'] as $item) {
                    $costPriceCount += isset($item['cost_price']) ? $item['cost_price'] * $item['num'] : 0;
                }
            }

            $newItem['cost_price'] = $costPriceCount;
            $newItem['total_price'] = $datum['total_price'];
            $newItem['pay_price'] = $datum['pay_price'];
            $newItem['pay_type'] = $pay_type_list[$datum['pay_type']];
            $newItem['is_pay'] = $datum['is_pay'] == 1 ? "已付款" : "未付款";
            $newItem['created_at'] = date('Y-m-d H:i', $datum['created_at']);
            $newItem['pay_time'] = $datum['pay_time'] ? date('Y-m-d H:i', $datum['pay_time']) : '';
            $newItem['merchant_remark'] = $datum['seller_comments'];

            //是否到店自提 0--否 1--是
            if ((isset($datum['is_offline']) && $datum['is_offline']) || (isset($datum['offline']) && $datum['offline'] == 2) || $this->order_type == 3) {
                $newItem['clerk_name'] = $datum['clerk'] ? $datum['clerk']['nickname'] : '';
                $newItem['shop_name'] = $datum['shop'] ? $datum['shop']['name'] : '';
            } else {
                $newItem['express_price'] = $datum['express_price'];
                $newItem['express_no'] = $datum['express_no'];
                $newItem['express'] = $datum['express'];
            }

            if ($datum['trade_status'] == Order::ORDER_FLOW_CANCEL) {
                $newItem['order_status'] = '订单已取消';
            } else {
                $orderRefund = OrderRefund::find()->where(['order_id' => $datum['id']])
                    ->select('status')->one();
                if ($orderRefund) {
                    switch ($orderRefund->status) {
                        case 0:
                            $newItem['order_status'] = '待商家处理';
                            break;
                        case 1:
                            $newItem['order_status'] = '同意并已退款';
                            break;
                        case 2:
                            $newItem['order_status'] = '已同意换货';
                            break;
                        case 3:
                            $newItem['order_status'] = '已拒绝换货';
                            break;
                        default:
                            $newItem['order_status'] = '待处理';
                            break;

                    }
                } else {
//                    $newItem['order_status'] = '订单已完成';
                    $newItem['order_status'] = $datum['trade_status'] == Order::ORDER_FLOW_CONFIRM ? '已完成' : '进行中';
                }
            }

            $newItem['name'] = $datum['name'];
            $newItem['mobile'] = $datum['mobile'];
            $newItem['address'] = $datum['address'];
            $newItem['send_time'] = $datum['send_time'] ? date('Y-m-d H:i', $datum['send_time']) : '';
            $newItem['confirm_time'] = $datum['confirm_time'] ? date('Y-m-d H:i', $datum['confirm_time']) : '';
            $newItem['words'] = isset($datum['words']) ? $datum['words'] : '';
            $newItem['apply_delete'] = ($datum['apply_delete'] == Order::ORDER_APPLY_DELETE) ? ($datum['trade_status'] == Order::ORDER_FLOW_CANCEL || $datum['is_delete'] == Order::IS_DELETE_TRUE ? '取消成功' : '取消中') : "无";
            $newItem['trade_status'] = OrderStateFlow::getFlowWords($datum['trade_status']);
            $newItem['goods_list'] = $this->getOrderGoodsListNew($datum['orderDetail']);

            if ($datum['orderForm']) {
                $str = '';
                foreach ($datum['orderForm'] as $key => $item) {
                    $str .= $item['key'] . ':' . $item['value'] . ',';
                }
                $newItem['content'] = rtrim($str, ',');
            } else {
                $newItem['content'] = $datum['content'];
            }
            $newList[] = $newItem;
        }

        return $newList;
    }

    /**
     * 拼团订单详情
     */
    private function getOrderGoodsListNew($list)
    {
        foreach ($list as $i => $order_detail) {
            $list[$i]['attr_list'] = Json::decode($order_detail['attr']);
            $list[$i]['good_no'] = $this->getGoodNo($list[$i]['attr_list'], $order_detail['goods_attr']);
        }
        return $list;
    }
}