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, $is_excel);

        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'] ?? 0.00,
                    $item['orderProduct'][0]['product_num'] ?? 0,
                    $item['pay_price'], // 订单金额
                    $item['paid'] == 0 ? "未支付" : "已支付", // 支付状态
                    $item['fzone_pay_note'], // 支付方式
                    $item['fzone_pay_jifen'], // 支付方式
                    $item['fzone_pay_price'], // 支付方式
                    $item['fzone_pay_jingdou'], // 支付方式
                    $item['fzone_pay_vr'], // 支付方式
                    $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([
                '订单编号',
                '订单类型',
                '用户昵称',
                '用户手机号',
                '收货人',
                '商户名称',
                '商品图片',
                // '商品名称',
                '商品单价',
                '商品数量',
                '订单金额',
                '支付状态',
                '支付方式',
                '支付积分',
                '支付现金',
                '支付京豆',
                '支付VR',
                '订单状态',
                '下单时间'
            ], $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('操作失败');
    }

    /**
     * 撤回订单,并撤回订单奖励
     */
    public function killOrderRewards(){
        $group_order_id = request()->param('group_order_id');
        $order_id = request()->param('order_id');
        $uid = request()->param('uid');
        if (empty($order_id) || empty($group_order_id) || empty($uid)) {
            return app('json')->fail('参数缺失');
        }
        try {
            Db::startTrans();
            // 删除订单相关表 对应备份还没有创建
            $this->backupAndDelete('store_order', ['group_order_id' => $group_order_id]);
            $this->backupAndDelete('store_group_order', ['group_order_id' => $group_order_id]);
//             取出并删除 pv
                $pv = $this->getValue('user_pv_log', ['order_id' => $order_id, 'status' => 1,], 'pv');
                $this->backupAndDelete('user_pv_log', ['order_id' => $order_id]);
//            取出 vr 消耗
//           $payVr = $this->getValue('user_sign_vr', ['order_id' => $order_id, 'type' => 2,], 'number');
//            取出购买赠送积分 / 支出积分
//                $score = $this->getValue('user_sign_score', ['order_id' => $order_id, 'status' => 1,'source_type' => 3,'uid' => $uid,], 'reward_score');
//                $payScore = $this->getValue('user_sign_score', ['order_id' => $order_id, 'status' => 1,'pm' => 2,'uid' => $uid,], 'reward_score');
//            // 取出推广赠送的积分和推广人的 uid
//            $spreadScore = $this->getValue('user_sign_score', ['order_id' => $order_id, 'status' => 1,'pm' => 2,'source_type' => 3,['mark','like','%推广%'],], 'reward_score');
//            $spreadUid = $this->getValue('user_sign_score', [['order_id' => $order_id], ['status' => 1],['pm' => 2],['source_type' => 3],['mark','like','%推广%'],], 'uid');
//            // 删除所有相关积分记录
//            $this->backupAndDelete('user_sign_score', ['order_id' => $order_id]);
//            // 贡献值
//            $gongXian = $this->getValue('user_sign_gongxian', ['order_id' => $order_id, 'status' => 1,'type' => 1,'uid' => $uid,], 'number');
//            $spreadGongXian = 0;
//            if ($spreadUid) {
//                $spreadGongXian = $this->getValue('user_sign_gongxian', ['order_id' => $order_id, 'status' => 1,'type' => 1,'uid' => $spreadUid,], 'number');
//            }
//            $this->backupAndDelete('user_sign_gongxian', ['order_id' => $order_id]);
//            // 养老金 / 推广养老金 / 推广佣金
//            $yangLaoJin = $this->getValue('user_bill', ['link_id' => $order_id, 'status' => 1,'pm' => 1,'uid' => $uid,], 'number');
//            $spreadYlj = 0;
//            $spreadYongJin = 0;
//            if ($spreadUid) {
//                $spreadYlj = $this->getValue('user_bill', ['link_id' => $order_id, 'commission_type' => 5,'uid' => $spreadUid,], 'number'); //推荐获得养老金
//                $spreadYongJin = $this->getValue('user_bill', ['link_id' => $order_id, 'commission_type' => 3,'uid' => $spreadUid,], 'number');  //推荐获得佣金
//            }
//            $spreadYongJinTwo = $this->getValue('user_bill', ['link_id' => $order_id, 'commission_type'  => 3, ['uid', '<>', $spreadUid],],'number');
//            $spreadYongJinTwoUid = $this->getValue('user_bill', ['link_id' => $order_id, 'commission_type'  => 3, ['uid', '<>', $spreadUid],],'uid');
//            $this->backupAndDelete('user_bill', ['link_id' => $order_id]);
//            $this->backupAndDelete('gz_logs', ['link_id' => $order_id]);
//            //更新对应的user表
//            $user = Db::name('user')->where('uid', $uid)->find();
//            if ($user) {
//                Db::name('backup_user')->insert($user);
//            }
//            Db::name('user')->where('uid', $uid)->dec('pv', $pv)->update();
//            Db::name('user')->where('uid', $uid)->inc('vr', $payVr)->update();
//            Db::name('user')->where('uid', $uid)->inc('score', $payScore)->update();
//            Db::name('user')->where('uid', $uid)->dec('score', $score)->update();
//            Db::name('user')->where('uid', $uid)->dec('contribute', $gongXian)->update();
//            Db::name('user')->where('uid', $uid)->dec('annuity', $yangLaoJin)->update();
//            //推荐人user表
//            $spreadUser = Db::name('user')->where('uid', $spreadUid)->find();
//            if ($spreadUser) {
//                Db::name('backup_user')->insert($spreadUser);
//            }
//            Db::name('user')->where('uid', $spreadUid)->dec('score', $spreadScore)->update();
//            Db::name('user')->where('uid', $spreadUid)->dec('per_contribute', $spreadGongXian)->update();
//            Db::name('user')->where('uid', $spreadUid)->dec('annuity', $spreadYlj)->update();
//            Db::name('user')->where('uid', $spreadUid)->dec('brokerage_price', $spreadYongJin)->update();
//            //第二个推荐人
//            $spreadUserTwo = Db::name('user')->where('uid', $spreadYongJinTwoUid)->find();
//            if ($spreadUserTwo) {
//                Db::name('backup_user')->insert($spreadUserTwo);
//            }
//            Db::name('user')->where('uid', $spreadYongJinTwoUid)->dec('brokerage_price', $spreadYongJinTwo)->update();
            Db::commit();
        } catch (\Exception $e) {
            Db::rollback();
            return app('json')->fail('操作失败');
        }
        return app('json')->success('操作成功');
    }
    private function backupAndDelete($table, array $where)
    {
        $backupTable = 'backup_' . $table;
        $rows = Db::name($table)->where($where)->select()->toArray();
        if ($rows) {
            Db::name($backupTable)->insertAll($rows);
            Db::name($table)->where($where)->delete();
        }
    }
    private function getValue($table, array $where, string $field, $default = 0)
    {
        $value = Db::name($table)->where($where)->value($field);
        return $value ?? $default;
    }
}