gaoyixia/application/operate/controller/ActivityApplyItem.php

<?php
namespace app\operate\controller;
use app\common\model\StoreOrderRefund;
use app\common\model\UserMessage;
use app\common\service\OrderCallback;
use app\common\service\UserSynth;
use library\Controller;
use think\Db;
/**
 * 活动
 * Class ActivityApplyItem
 * @package app\operate\controller
 */
class ActivityApplyItem extends Controller
{
    protected $table = 'ActivityApplyItem';

    /**
     * 列表
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function index()
    {
        $this->status_list = [0=>'待审核',1=>'审核通过',2=>'审核拒绝'];
        $this->sh_status = $this->request->get('sh_status',-1);
        $id = $this->request->get('act_id');
        $name = $this->request->get('name');
        $phone = $this->request->get('phone');
        $qr_content = $this->request->get('qr_content');
        $sh_status = $this->request->get('sh_status',-1);
        $this->title = '报名记录';
        $where = [];
        $where[]= ['a.act_id','=' ,$id];
        $where[]= ['a.is_deleted','=' ,0];
        $where[]= ['o.pay_state','=' ,1];
        if($name)  $where[]= ['a.name','like' ,'%'.$name.'%'];
        if($phone)  $where[]= ['a.phone','like' ,'%'.$phone.'%'];
        if($qr_content)  $where[]= ['a.qr_content','like' ,'%'.$phone.'%'];
        if(in_array($sh_status,[0,1,2]))  $where[]= ['a.sh_status','=' ,$sh_status];
        $query = $this->_query('activity_apply_item')
            ->alias('a')
            ->field('a.*,u.headimg,o.order_no')
            ->where($where)
            ->leftJoin('store_member u','u.id = a.user_id')
            ->leftJoin('activity_apply o','o.id = a.apply_id')
            ->order('a.id desc')->page();
    }


    protected function _index_page_filter(array &$data)
    {
        foreach ($data as &$vo) {
            $vo['refund_status'] = StoreOrderRefund::where('order_type',1)->where('order_id',$vo['apply_id'])->where('item_id',$vo['id'])->value('status');
        }

    }

    /**
     * 编辑
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function edit()
    {
        $this->title = '编辑';
        $this->_form($this->table, 'form');
    }

    /**
     * 删除
     * @auth true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function del()
    {
        $this->_save($this->table, ['is_deleted' => '1']);
    }

    /**
     * 批量删除
     * @auth true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function remove()
    {
        $this->_save($this->table, ['is_deleted' => '1']);
    }

    /**
     * 表单数据处理
     * @auth true
     * @menu true
     * @param array $data
     */
    protected function _form_filter(&$data)
    {
        if($this->request->isGet() && $this->request->action() == 'edit')
        {
            if(isset($data['extend'])) $data['extend']  = json_decode($data['extend'],true);
        }
        if($this->request->isPost() && $this->request->action() == 'edit')
        {
            $ticket_info = \app\common\model\ActivityApplyItem::where('id',$data['id'])->find()->toArray();
            // 审核成功
            if($data['sh_status'] == 1)
            {
                if($data['sh_status'] == 1 && $ticket_info['sh_status'] !=1)
                {
                    if(!$ticket_info['qr_code']) {
                        $qrCode = new \Endroid\QrCode\QrCode();
                        // 生成核销码
                        $qr_content = $ticket_info['act_id'].'-'.$ticket_info['apply_id'].'-'.$ticket_info['id'];
                        $qrCode->setText($qr_content);
                        $qrCode->setSize(200);
                        $dir = dirname(realpath(dirname($_SERVER['SCRIPT_FILENAME']))) . '/public/code';
                        $filename = $dir.'/'.$ticket_info['id'].'.png';
                        $qrCode->writeFile($filename);
                        $url='http://'.$_SERVER['SERVER_NAME']."/code/".$ticket_info['id'].'.png';
                        \app\common\model\ActivityApplyItem::where('id',$ticket_info['id'])->update(['qr_code'=>$url,'qr_content'=>$qr_content]);
                    }
                    $act_title = \app\common\model\Activity::where('id',$ticket_info['act_id'])->value('title');
                    $message = '您已成功报名"'.$act_title.'"';//点击<a href=\"$info_url\">查看详情及点子门票</a>";
                    UserMessage::sendUserMessage($ticket_info['user_id'],'activity',1,1,0,$ticket_info['id'],$message,$ticket_info['id']);
                    UserSynth::ticketSend($ticket_info['id']);
                }

                if($ticket_info['sh_status'] != 1 && $ticket_info['phone'] && $ticket_info['phone_pre'] == '86') {
                    $act_info  = \app\common\model\Activity::where('id',$ticket_info['act_id'])->find()->toArray();
                    UserSynth::phoneMessageSend($ticket_info['phone'],1, [
                           'ActivityName'=>$act_info['title'],
                            'url'=>'dist/#/activity_ticket_info?id='.$ticket_info['id'],
                        ]);
                    $info_url = 'https://'.$_SERVER['HTTP_HOST'].'/dist/#/activity_ticket_info?id='.$ticket_info['id'];
                }
            }

            // 审核拒绝
            if($data['sh_status'] == 2) {
                $order_id = \app\common\model\ActivityApplyItem::where('id',$data['id'])->value('apply_id');
                $res =  \app\common\service\Activity:: orderApplyRefund($order_id,$data['id'],2,1);
                $info_url = 'https://'.$_SERVER['HTTP_HOST'].'/dist/#/activity-detail?id='.$ticket_info['act_id'];
                $act_title = \app\common\model\Activity::where('id',$ticket_info['act_id'])->value('title');
                $message = '很抱歉，您报名的"'.$act_title.'"审核未通过';//，点击<a href=\"$info_url\">重新报名</a>";
                UserMessage::sendUserMessage($ticket_info['user_id'],'activity',1,1,0,$ticket_info['id'],$message,$ticket_info['id']);
            }
        }

    }


    /**
     * 确认收款
     * @auth true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function confirm()
    {
        $order_info = \app\common\model\ActivityApply::where('id',input('id'))->find()->toArray();
        $back_res = OrderCallback::activityOrderCallBack($order_info);// 支付完成后回调
        if(!$back_res['ret_val']) $this->error($back_res['msg']);
        $this->success('操作成功');
    }

    /**
     * 退款
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function refund()
    {
        $ticket_info = \app\common\model\ActivityApplyItem::where('id',input('id'))->find()->toArray();
        $refund_id =  StoreOrderRefund::where('order_type',1)->where('order_id',$ticket_info['apply_id'])->where('item_id',$ticket_info['id'])->value('id');
        $back_res = \app\common\service\Activity:: orderRefund($refund_id);// 支付完成后回调
        if($back_res['code'] != 200) $this->error($back_res['msg']);
        $this->success('操作成功');
    }



    /**
     * 核销
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function hx()
    {
        if($this->request->isPost()) {
            $qr_content = input('post.qr_content');
            if(!$qr_content) $this->error('没有核销内容');
            $item_info = \app\common\model\ActivityApplyItem::where(['i.qr_content'=>$qr_content,'is_hx'=>0])
                ->alias('i')->field('i.is_hx,i.status,i.apply_id,i.is_deleted,a.status,a.cancel_state,a.pay_state,a.refund_state')
                ->leftJoin("ActivityApply a",'a.id = i.apply_id')->find();
            if(!$item_info) $this->error('没有找到核销记录');
            if($item_info->pay_state)$this->error('订单已取消');
            $refund_info = StoreOrderRefund::getRefundInfo($item_info['apply_id'],$item_info['id'],1);
            if(!empty($refund_info && in_array($refund_info['status'],[0,1,3,5])))$this->error('已申请退款');
            //if(!in_array($item_info->refund_state,[0,3]))$this->error('订单已申请退款');
            if(!in_array($item_info->status,[1]))$this->error('票状态异常');
            \app\common\model\ActivityApplyItem::where('id',$item_info['id'])->update(['is_hx'=>1,'ticket_status'=>1]);
            $this->success('核销成功');
        }
        $this->_form($this->table, 'hx');
    }


}