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']);
        $productKeywords = $this->request->param('product_keywords');//商品关键字
        $where['reconciliation_type'] = $this->request->param('status', 1);
        $where['mer_id'] = $id;
        $where['product_keywords'] = $productKeywords;
        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');
        $adminId = $this->request->adminId();
        if (empty($order_id) || empty($group_order_id) || empty($uid)) {
            return app('json')->fail('参数缺失');
        }
        if (!in_array($adminId, [1,28,29])) {//超级管理员,财务,老总
            return app('json')->fail('后台权限不足');
        }
        $ok = $this->repository->useKillOrderRewards($group_order_id, $order_id, $uid,$adminId);
        if (!$ok) {
            return app('json')->fail('操作失败');
        }
        return app('json')->success('操作成功');
//        try {
//            Db::startTrans();
//            //查找是否有推荐人
//            $spreadUid = Db::name('user')->where('uid', $uid)->value('spread_uid');
//            //取出pv
//            $pv = $this->getValue('user_pv_log', [['order_id', '=', $order_id], ['status', '=', 1],], 'pv');
//            //取出 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], ['pm', '=', 1],], 'reward_socre');
//            $payScore = $this->getValue('user_sign_score', [['order_id', '=', $order_id], ['status', '=', 1], ['pm', '=', 2], ['uid', '=', $uid],], 'reward_socre');
//            // 贡献值
//            $gongXian = $this->getValue('user_sign_gongxian', [['order_id', '=', $order_id], ['status', '=', 1], ['type', '=', 1], ['uid', '=', $uid],], 'number');
//            // 养老金
//            $yangLaoJin = $this->getValue('user_bill', [['link_id', '=', $order_id], ['status', '=', 1], ['pm', '=', 1], ['uid', '=', $uid],], 'number');
//            if($spreadUid){  //如果有推荐人就执行
//                $spreadScore = 0;
//                $spreadGongXian = 0;
//                $spreadYlj = 0;
//                $spreadYongJin = 0;
//                $spreadScore = $this->getValue('user_sign_score', [['order_id', '=', $order_id], ['uid', '=', $spreadUid], ['status', '=', 1],], 'reward_socre');
//                $spreadGongXian = $this->getValue('user_sign_gongxian', [['order_id', '=', $order_id], ['status', '=', 1], ['type', '=', 1], ['uid', '=', $spreadUid],], 'number');
//                $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');  //推荐获得佣金
//                $spreadUser = Db::name('user')->where('uid', $spreadUid)->find();
//                Db::name('backup_user')->insert($spreadUser);  //插入备份表
//                Db::name('user')->where('uid', $spreadUid)   //更新数据
//                    ->update([
//                        'score' => Db::raw("score - {$spreadScore}"),
//                        'per_contribute' => Db::raw("per_contribute - {$spreadGongXian}"),
//                        'brokerage_price' => Db::raw("brokerage_price - {$spreadYongJin}"),
//                        'annuity' => Db::raw("annuity - {$spreadYlj}"),
//                    ]);
//                $userhjm1 =[
//                    'uid' => $spreadUid,
//                    'order_id' => $order_id,
//                    'score' => $spreadScore??0,
//                    'per_contribute' => $spreadGongXian??0,
//                    'brokerage_price' => $spreadYongJin??0,
//                    'user' => 2,
//                ];
//                Db::name('backup_user_change')->insert($userhjm1);   //插入更新数据记录表
//            }
//            //扫吗消费
//            $smSpreadUid = $this->getValue('user_sign_score', [['order_id', '=', $order_id], ['mark','like','%扫码%'], ['status', '=', 1],], 'uid');
//            $smSpreadScore = $this->getValue('user_sign_score', [['order_id', '=', $order_id], ['uid','=',$smSpreadUid], ['status', '=', 1],], 'reward_socre');
//            //第二推荐
//            $spreadYongJinTwoUid = $this->getValue('user_bill', [['link_id', '=', $order_id], ['commission_type', '=', 3], ['uid', 'not in', [$uid, $spreadUid]],], 'uid');
//            $spreadYongJinTwo = $this->getValue('user_bill', [['link_id', '=', $order_id], ['commission_type', '=', 3], ['uid', '=', $spreadYongJinTwoUid],], 'number');
//            //更新购买用户的user表
//            $uscore = $payScore - $score;
//            $user = Db::name('user')->where('uid', $uid)->find();
//            Db::name('backup_user')->insert($user);
//            Db::name('user')->where('uid', $uid)
//                ->update([
//                    'pv'         => Db::raw("pv - {$pv}"),
//                    'vr'         => Db::raw("vr + {$payVr}"),
//                    'score'      => Db::raw("score + {$uscore}"),
//                    'contribute' => Db::raw("contribute - {$gongXian}"),
//                    'annuity'    => Db::raw("annuity - {$yangLaoJin}"),
//                ]);
//            $userhjm =[
//                'uid' => $uid,
//                'order_id' => $order_id,
//                'pv' => $pv??0,
//                'vr' => $payVr??0,
//                'score' => $uscore??0,
//                'contribute' => $gongXian??0,
//                'annuity' => $yangLaoJin??0,
//                'user' => 1,
//            ];
//            Db::name('backup_user_change')->insert($userhjm);//具体修改插入对应表
//            //第二推荐
//            if($spreadYongJinTwoUid) {
//                $spreadUserTwo = Db::name('user')->where('uid', $spreadYongJinTwoUid)->find();
//                Db::name('backup_user')->insert($spreadUserTwo);
//                Db::name('user')->where('uid', $spreadYongJinTwoUid)->dec('brokerage_price', $spreadYongJinTwo)->update();
//                $userhjm2 =[
//                    'uid' => $spreadYongJinTwoUid,
//                    'order_id' => $order_id,
//                    'brokerage_price' => $spreadYongJinTwo??0,
//                    'user' => 3,
//                ];
//                Db::name('backup_user_change')->insert($userhjm2);
//            }//扫码消费
//            if($smSpreadUid){
//                $smUserTwo = Db::name('user')->where('uid', $smSpreadUid)->find();
//                Db::name('backup_user')->insert($smUserTwo);
//                Db::name('user')->where('uid', $smSpreadUid)->dec('score', $smSpreadScore)->update();
//                $userhjm3 =[
//                    'uid' => $smSpreadUid,
//                    'order_id' => $order_id,
//                    'score' => $smSpreadScore??0,
//                    'user' => 4,
//                ];
//                Db::name('backup_user_change')->insert($userhjm3);
//            }
//            // 删除订单相关表p;
//            $this->backupAndDelete('store_order', ['group_order_id' => $group_order_id]);
//            $this->backupAndDelete('store_group_order', ['group_order_id' => $group_order_id]);
//            $this->backupAndDelete('user_pv_log', ['order_id' => $order_id]);
//            $this->backupAndDelete('user_sign_vr', ['order_id' => $order_id]);
//            $this->backupAndDelete('user_sign_score', ['order_id' => $order_id]);
//            $this->backupAndDelete('user_sign_gongxian', ['order_id' => $order_id]);
//            $this->backupAndDelete('user_bill', ['link_id' => $order_id]);
//            $this->backupAndDelete('gzc_logs', ['link_id' => $order_id]);
//            Db::commit();
//        } catch (\Exception $e) {
//            Db::rollback();
//            return app('json')->fail('操作失败'. $e->getMessage());
//        }
//        Db::name("user_order_kill_records")->insert([//记录哪位管理员撤销的订单
//            'operation_id' => $adminId,
//            'uid' => $uid,
//            'order_id' => $order_id,
//            'mark' => '后台管理员撤销订单记录'
//        ]);
//        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;
//    }
    /**
     * 展示撤回订单列表,恢复订单
     */
    public function killOrderLst()  //撤回订单的列表
    {
//        $query = Db::name('backup_store_order')->paginate(20)->toArray();
//        return app('json')->success($query, '获取成功');
        $list = $this->repository->getKillOrderList();
        return app('json')->success($list, '获取成功');
    }
    public function easterKillOrder(){   //恢复订单
        $group_order_id = request()->param('group_order_id');
        $order_id = request()->param('order_id');
        if (empty($order_id) || empty($group_order_id)) {
            return app('json')->fail('参数缺失');
        }
        $ok = $this->repository->recoverOrderByAdmin($group_order_id, $order_id);
        if (!$ok) {
            return app('json')->fail('操作失败');
        }
        return app('json')->success('操作成功');
//        try {
//            Db::startTrans();
//            // 恢复订单相关表
//            $this->easterOrder('store_order', ['group_order_id' => $group_order_id]);
//            $this->easterOrder('store_group_order', ['group_order_id' => $group_order_id]);
//            // 恢复 pv
//            $this->easterOrder('user_pv_log', ['order_id' => $order_id]);
//            // 恢复 vr
//            $this->easterOrder('user_sign_vr', ['order_id' => $order_id]);
//            // 恢复 积分
//            $this->easterOrder('user_sign_score', ['order_id' => $order_id]);
//            // 恢复 贡献值
//            $this->easterOrder('user_sign_gongxian', ['order_id' => $order_id]);
//            // 恢复 佣金/养老金等
//            $this->easterOrder('user_bill', ['link_id' => $order_id]);
//            // 恢复 公证处
//            $this->easterOrder('gzc_logs', ['link_id' => $order_id]);
//            //恢复用户奖励
//            $this->easterUserAward(['order_id' => $order_id]);
//            Db::commit();
//        } catch (\Exception $e) {
//            Db::rollback();
//            return app('json')->fail('撤回失败: '.$e->getMessage());
//        }
//        Db::name("user_order_recover_records")->insert([//记录恢复的订单
//            'operation_id' => $adminId,
//            'order_id' => $order_id,
//            'mark' => '恢复订单记录'
//        ]);
//        return app('json')->success('撤回成功');
    }
//    private function easterOrder($table, array $where)  //恢复表数据
//    {
//        $backupTable = 'backup_' . $table;
//        $rows = Db::name($backupTable)->where($where)->select()->toArray();
//
//        if ($rows) {
//            foreach ($rows as &$row) {
//                if (isset($row['del_time'])) unset($row['del_time']);
//            }
//            unset($row);
//            Db::name($table)->insertAll($rows);
//            Db::name($backupTable)->where($where)->delete();
//        }
//    }
//    private function easterUserAward(array $where){  //恢复奖励
//        $row = Db::name('backup_user_change')->where($where)->where('user', 1)->field('pv, vr, score, contribute, annuity,uid')->find();
//        $uid = $row['uid'];
//        $pv   = $row['pv'];
//        $vr   = $row['vr'];
//        $score= $row['score'];
//        $contribute = $row['contribute'];
//        $annuity = $row['annuity'];
//        Db::name('user') //更新订单用户
//            ->where('uid', $uid)
//            ->update([
//                'pv'         => Db::raw("pv + {$pv}"),
//                'vr'         => Db::raw("vr - {$vr}"),
//                'score'      => Db::raw("score - {$score}"),
//                'contribute' => Db::raw("contribute + {$contribute}"),
//                'annuity'    => Db::raw("annuity + {$annuity}"),
//            ]);
//        $row2 = Db::name('backup_user_change')->where($where)->where('user', 2)->field('brokerage_price, score, per_contribute, annuity,uid')->find();
//        if ($row2) {
//            $spreadUid = $row2['uid'];
//            $spreadScore = $row2['score'];
//            $per_contribute = $row2['per_contribute'];
//            $spreadAnnuity = $row2['annuity'];
//            $spreadYongJin = $row2['brokerage_price'];
//            Db::name('user')     //更新推荐人
//            ->where('uid', $spreadUid)
//                ->update([
//                    'score' => Db::raw("score + {$spreadScore}"),
//                    'contribute' => Db::raw("contribute + {$per_contribute}"),
//                    'annuity' => Db::raw("annuity + {$spreadAnnuity}"),
//                    'brokerage_price' => Db::raw("brokerage_price + {$spreadYongJin}"),
//                    'per_contribute'=> Db::raw("per_contribute + {$per_contribute}"),
//                ]);
//        }
//        $row3 = Db::name('backup_user_change')->where($where)->where('user', 3)->field('brokerage_price,uid')->find();
//        if ($row3) {
//            $spreadUidTwo = $row3['uid']; //第二推荐人
//            $spreadYongJin2 = $row3['brokerage_price'];
//            Db::name('user')
//                ->where('uid', $spreadUidTwo)
//                ->update([
//                    'brokerage_price' => Db::raw("brokerage_price + {$spreadYongJin2}"),
//                ]);
//        }
//        $row4 = Db::name('backup_user_change')->where($where)->where('user', 4)->field('score,uid')->find();
//        if ($row4) {
//            $spreadUidThree = $row4['uid'];   //扫码
//            $spreadScore3 = $row4['score'];
//            Db::name('user')
//                ->where('uid', $spreadUidThree)
//                ->update([
//                    'score' => Db::raw("score + {$spreadScore3}"),
//                ]);
//        }
//    }
}