php/app/controller/admin/order/Order.php

<?php
/**
 * @package merchant
 *
 * @author Qinii
 * @day 2020-06-15
 *
 *
 */

namespace app\controller\admin\order;

use crmeb\basic\BaseController;
use app\common\repositories\store\ExcelRepository;
use app\common\repositories\system\merchant\MerchantRepository;
use app\common\repositories\store\order\StoreOrderRepository as repository;
use crmeb\services\SpreadsheetExcelService;
use think\App;
use think\facade\Db;

class Order extends BaseController
{
    protected $repository;

    public function __construct(App $app, repository $repository)
    {
        parent::__construct($app);
        $this->repository = $repository;
    }


    public function lst($id)
    {
        [$page, $limit] = $this->getPage();
        $where = $this->request->params(['date','order_sn','order_type','keywords','username']);
        $where['reconciliation_type'] = $this->request->param('status', 1);
        $where['mer_id'] = $id;
        return app('json')->success($this->repository->adminGetList($where, $page, $limit));
    }

    public function markForm($id)
    {
        if (!$this->repository->getWhereCount([$this->repository->getPk() => $id]))
            return app('json')->fail('数据不存在');
        return app('json')->success(formToData($this->repository->adminMarkForm($id)));
    }

    public function mark($id)
    {
        if (!$this->repository->getWhereCount([$this->repository->getPk() => $id]))
            return app('json')->fail('数据不存在');
        $data = $this->request->params(['admin_mark']);
        $this->repository->update($id, $data);
        return app('json')->success('备注成功');
    }

    /**
     * TODO
     * @return mixed
     * @author Qinii
     * @day 2020-06-25
     */
    public function getAllList()
    {
        [$page, $limit] = $this->getPage();
        $where = $this->request->params(['type', 'date', 'mer_id','keywords','status','username','order_sn','order_ids','paid', 'zero_line_uid']);

        $pay_type=$this->request->param('pay_type');
        if($pay_type==1 || $pay_type==4){
            $where['pay_type']=$pay_type;
        }
        if($pay_type==6){
            //一壶茶红积分兑换的
            $where['mer_id']=496;
            $where['pay_type']=5;
        }
        // 导出
        $is_excel = request()->param('is_excel', 0);

        $result = $this->repository->merchantGetList($where, $page, $limit);

        if ($is_excel == 1) {
            $data = $result['list'];
            $arr = [];
            foreach ($data as $item) {
                $arr[] = [
                    $item['order_sn'], // 订单编号
                    $item['order_type'] == 0 ? "普通订单" : "核销订单", // 订单类型
                    $item['user']['nickname'] ?? '', // 用户昵称
                    $item['user']['phone'] ?? '', // 用户手机号
                    $item['real_name'], // 收货人
                    $item['merchant']['mer_name'] ?? '', // 商户名称
                    // $item['orderProduct'][0]['cart_info']['product']['image'],
                    $item['orderProduct'][0]['cart_info']['product']['store_name'] . ' | ' . $item['orderProduct'][0]['cart_info']['productAttr']['sku'],
                    $item['orderProduct'][0]['cart_info']['productAttr']['price'],
                    $item['orderProduct'][0]['product_num'],
                    $item['pay_price'], // 订单金额
                    $item['fzone_pay_note'], // 支付方式
                    $item['paid'] == 0 ? "未支付" : "已支付", // 支付状态
                    $item['is_del'] == 0 ? ($item['status'] == 5 ? '待付款' : ($item['status'] == 0 ? '待发货' : ($item['status'] == 1 ? '待收货' : ($item['status'] == 2 ? '待评价' : ($item['status'] == 3 ? '已完成' : ($item['status'] == 4 ? '已申请退款' : ($item['status'] == -1 ? '已退款' : ($item['status'] == 6 ? '已取消' : '')))))))) : '已删除', // 订单状态
                    $item['create_time'], // 下单时间
                ];
            }
            return app('json')->success($this->getStatisticsExcel([
                '订单编号',
                '订单类型',
                '用户昵称',
                '用户手机号',
                '收货人',
                '商户名称',
                '商品图片',
                // '商品名称',
                '商品单价',
                '商品数量',
                '订单金额',
                '支付方式',
                '支付状态',
                '订单状态',
                '下单时间'
            ], $arr, '订单明细'));
        }
        return app('json')->success($result);
    }
    /**
     * 获取统计导出
     */
    public function getStatisticsExcel($header,$arr,$title)
    {
        $filename = $title.'_'.date('YmdHis').'_'.rand(10000,99999);
        $name = $filename;
        $info = '生成时间:' . date('Y-m-d H:i:s',time());
        $suffix='xlsx';
        $path='extract';
        unset($_instance);

        $_instance = SpreadsheetExcelService::instance_xin();

        $_path =$_instance
            ->createOrActive()
            ->setExcelHeader($header)
            ->setExcelTile($title, $name, $info)
            ->setExcelContent($arr)
            ->excelSave($filename, $suffix, $path);

        $domain = request()->domain();
        $data= [
            'name' => $filename.'.'.$suffix,
            'status' => 1,
            'path' => $domain.'/'.$_path
        ];

        return $data;
    }


    /**
     * TODO 自提订单列表
     * @return mixed
     * @author Qinii
     * @day 2020-08-17
     */
    public function getTakeList()
    {
        [$page, $limit] = $this->getPage();
        $where = $this->request->params(['date','order_sn','keywords','username']);
        $where['take_order'] = 1;
        $where['status'] = -1;
        $where['verify_date'] = $where['date'];
        unset($where['date']);
        return app('json')->success($this->repository->merchantGetList($where, $page, $limit));
    }

    /**
     * TODO
     * @return mixed
     * @author Qinii
     * @day 2020-08-17
     */
    public function chart()
    {
        $where = $this->request->params(['type', 'date', 'mer_id','keywords','username','order_sn','order_ids','paid']);
        return app('json')->success($this->repository->adminOrderNumber(-1, $where));
    }

    /**
     * TODO 自提订单头部统计
     * @return mixed
     * @author Qinii
     * @day 2020-08-17
     */
    public function takeChart()
    {
        return app('json')->success($this->repository->adminOrderNumber(1));
    }

    /**
     * TODO 订单类型
     * @return mixed
     * @author Qinii
     * @day 2020-08-15
     */
    public function orderType()
    {
        return app('json')->success($this->repository->orderType([]));
    }

    public function detail($id)
    {
        $data = $this->repository->getOne($id, null);
        if (!$data)
            return app('json')->fail('数据不存在');
        return app('json')->success($data);
    }

    /**
     * TODO 快递查询
     * @param $id
     * @return mixed
     * @author Qinii
     * @day 2020-06-25
     */
    public function express($id)
    {
        if (!$this->repository->getWhereCount(['order_id' => $id, 'delivery_type' => 1]))
            return app('json')->fail('订单信息或状态错误');
        return app('json')->success($this->repository->express($id));
    }

    public function reList($id)
    {
        [$page, $limit] = $this->getPage();
        $where = ['reconciliation_id' => $id, 'type' => 0];
        return app('json')->success($this->repository->reconList($where, $page, $limit));
    }

    /**
     * TODO 导出文件
     * @author Qinii
     * @day 2020-07-30
     */
    public function excel()
    {
        $where = $this->request->params(['type', 'date', 'mer_id','keywords','status','username','order_sn']);
        app()->make(ExcelRepository::class)->create($where, $this->request->adminId(), 'order',0);
        return app('json')->success('开始导出数据');
    }

    /**
     * 养老金打款凭证 列表
     * @return mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function order_red_list()
    {
        [$page, $limit] = $this->getPage();
        $where = $this->request->params(['status', 'date']);
//        $where['mer_id'] = $this->request->merId();
        $query = Db::name('enterprise_red_order_voucher')->when(isset($where['date']) && $where['date'] !== '', function ($query) use ($where) {
            getModelTime($query, $where['date']);
        })->when(isset($where['status']) && $where['status'] !== '', function ($query) use ($where) {
            $query->where('status',$where['status']);
        });
        $data['count'] = $query->count();
        $data['list'] = $query->page($page, $limit)->order('id desc')->select();

        return app('json')->success('ok', $data);

    }

    /**
     * 养老金提交打款凭证 审核
     * @return mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function order_red_status()
    {
        $post= $this->request->params(['id', 'status', 'refund_message']);
        $voucher=Db::name('enterprise_red_order_voucher')->find($post['id']);
        if(!$voucher){
            return app('json')->fail('订单信息错误');
        }
        if($voucher['status']!=0){
            return app('json')->fail('请勿重复操作');
        }
        if($post['status']==2){
            $update['status']=2;
            $update['refund_message']=$post['refund_message'];
            if($post['refund_message']==''){
                return app('json')->fail('请输入不通过原因');
            }
            $is_red_ylj=0;
        }else{
            $update['status']=1;
            $is_red_ylj=2;
        }
        $update['status_time']=date('Y-m-d H:i:s');
        $re=Db::name('enterprise_red_order_voucher')->where('id',$post['id'])->update($update);

        Db::name('store_order')->whereIn('order_id',$voucher['order_ids'])->where('is_red_ylj',1)->update(['is_red_ylj'=>$is_red_ylj]);


        $where['o.paid'] = 1;
//        $where['o.pay_type'] = 5;
        $where['u.commission_type'] = 5;
        $where['u.gzc'] = 3;
        $where['u.status'] = 0;
        $bill_id = Db::name('store_order')
            ->alias('o')
            ->join('user_bill u', 'u.order_sn=o.order_sn')
            ->where($where)
            ->whereIN('o.pay_type',[0,5])
            ->whereIn('o.order_id', $voucher['order_ids'])
            ->column('u.bill_id');
        Db::name('user_bill')->whereIn('bill_id',$bill_id)->update(['status'=>1,'gzc'=>0]);


        if($re){
            return app('json')->success('操作成功');
        }
        return app('json')->fail('操作失败');
    }
}