NN2021052501/app/Services/EnshrineService.php

<?php
// +----------------------------------------------------------------------
// | Laravel框架 [ Laravel ]
// +----------------------------------------------------------------------
// | 版权所有 2017~2021 Laravel研发中心
// +----------------------------------------------------------------------
// | 官方网站: http://www.laravel.cn
// +----------------------------------------------------------------------
// | Author: wesmiler <12345678@qq.com>
// +----------------------------------------------------------------------

namespace App\Services;

use App\Models\DynamicNoticeModel;
use App\Models\EnshrineActionModel;
use App\Models\EnshrineOrdersModel;
use App\Models\EnshrineRecordModel;
use App\Models\FoxiangModel;
use App\Models\MemberModel;
use App\Models\OfferingsModel;
use App\Models\TradeModel;

/**
 * 供奉管理-服务类
 * @author wesmiler
 * @since 2020/11/11
 * Class EnshrineService
 * @package App\Services
 */
class EnshrineService extends BaseService
{

    protected static $instance = null;
    /**
     * 构造函数
     * @author wesmiler
     * @since 2020/11/11
     * EnshrineOrdersService constructor.
     */
    public function __construct()
    {
        $this->model = new EnshrineRecordModel();
    }

    /**
     * 静态入口
     * @return EnshrineOrdersService|null
     */
    public static function make(){
        if(!self::$instance){
            self::$instance = new EnshrineOrdersService();
        }
        return self::$instance;
    }

    /**
     * 供奉记录
     * @return array
     */
    public  function getDataList($userId){
        $params = request()->all();
        $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE;
        $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE;
        $size = ConfigService::make()->getConfigByCode('qifu_limit');
        $pageSize = $size? $size : $pageSize;

        $dataList = $this->model::from('enshrine_records as a')
            ->leftJoin('foxiang as f', 'f.id', '=', 'a.fo_id')
            ->leftJoin('foxiang_cates as c', 'c.id', '=', 'f.cate_id')
            ->where(['a.user_id'=> $userId])
            ->where(function ($query) use ($params) {
                $query->where(['a.mark'=>1,'a.status'=> 1]);
                $type = isset($params['type'])? $params['type'] : 0;
                if($type){
                    $query->where('a.type', $type);
                }

            })
            ->select(['a.*', 'f.name','f.thumb','f.image', 'f.file_url','c.name as cate_name'])
            ->orderBy('a.create_time', 'desc')
            ->paginate($pageSize);

        $dataList = $dataList ? $dataList->toArray() : [];
        if ($dataList) {
            foreach ($dataList['data'] as &$item) {
                $item['thumb'] = $item['thumb'] ? get_image_url($item['thumb']) : '';
                $item['image'] = $item['image'] ? get_image_url($item['image']) : '';
                $item['file_url'] = $item['file_url'] ? get_image_url($item['file_url']) : '';
                $item['bg_music_url'] = get_image_url('/file/music/bg_'.$item['type'].'.mp3');
                $item['create_time'] = $item['create_time'] ? datetime($item['create_time'],'Y-m-d H:i:s') : '';
                $item['time_close'] = 0;
                if($item['create_time'] <= date('Y-m-d H:i:s', time()-24*3600)){
                    $item['time_close'] = 1;
                }
                $guibai = EnshrineActionModel::where(['source_id'=> $item['id'],'user_id'=> $userId,'type'=> 1,'mark'=>1 ,'status'=> 1])
                    ->where('create_time','>=', time()-3600)
                    ->value('id');
                $item['guibai'] = 0;
                $item['guibai_check'] = $guibai? $guibai : 0;
                $wash = EnshrineActionModel::where(['source_id'=> $item['id'],'user_id'=> $userId,'type'=> 2,'mark'=>1 ,'status'=> 1])
                    ->where('create_time','>=', time()-3600)
                    ->value('id');
                $item['wash'] = 0;
                $item['guibai_check'] = $wash? $wash : 0;

                // 花
                $item['hua'] = ['id'=> 0,'icon'=> '','icon_real'=> ''];
                $hua = $this->getOrderGoodsInfo($item['id'], $userId, $item['type'], 2);
                if($hua){
                    $item['hua'] = $hua;
                }
                // 水果
                $item['guo'] = ['id'=> 0,'icon'=> '','icon_real'=> ''];
                $guo = $this->getOrderGoodsInfo($item['id'], $userId, $item['type'], 3);
                if($guo){
                    $item['guo'] = $guo;
                }
                // 香烛
                $item['xiang'] = ['id'=> 0,'icon'=> '','icon_real'=> ''];
                $xiang = $this->getOrderGoodsInfo($item['id'], $userId, $item['type'], 4);
                if($xiang){
                    $item['xiang'] = $xiang;
                }
            }
            unset($item);
        }

        return [
            'code' => 0,
            'success'=> true,
            'msg' => '操作成功',
            'count' => isset($dataList['total']) ? $dataList['total'] : 0,
            'data' => isset($dataList['data']) ? $dataList['data'] : 0,
        ];
    }

    /**
     * 获取已经购买供奉物品信息
     * @param $sid
     * @param $userId
     * @param $type
     * @param $goodsType
     * @return array|mixed
     */
    public function getOrderGoodsInfo($sid, $userId, $type, $goodsType){
        $cacheKey = "caches:enshrine:orders_goods:u{$userId}_s{$sid}_{$type}_{$goodsType}";
        $info = RedisService::get($cacheKey);
        if($info){
            return $info;
        }
        $expireTime = ConfigService::make()->getConfigByCode('enshrine_expire_time');
        $expireTime = $expireTime? $expireTime : 0;
        $info = EnshrineOrdersModel::from('enshrine_orders as eo')
            ->leftJoin('offerings as g','g.id','=','eo.goods_id')
            ->where(['eo.source_id'=> $sid,'eo.user_id'=> $userId,'eo.type'=> $type,'g.goods_type'=> $goodsType])
            ->where(function($query) use($expireTime){
                if($expireTime>0){
                    $query->where('eo.create_time','>=', time()- $expireTime*3600);
                }
            })
            ->select(['g.id','g.name','g.goods_type','g.code','g.icon','g.icon_real','eo.source_id','eo.status','eo.create_time'])
            ->orderBy('eo.create_time','desc')
            ->first();
        $info = $info? $info->toArray() : [];
        if($info){
            $info['icon'] = $info['icon']? get_image_url($info['icon']) : '';
            $info['create_time_text'] = $info['create_time']? datetime($info['create_time'],'Y-m-d H:i:s') : '';
            $info['create_time'] = $info['create_time']? strtotime(datetime($info['create_time'],'Y-m-d H:i:s')) : time();
            $info['icon_real'] = $info['icon_real']? get_image_url($info['icon_real']) : '';
            RedisService::set($cacheKey, $info, rand(3, 5));
        }
        return $info;
    }

    /**
     * 物品
     * @return array
     */
    public function goods(){
        $params = request()->all();
        $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE;
        $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE;
        $size = ConfigService::make()->getConfigByCode('qifu_limit');
        $pageSize = $size? $size : $pageSize;

        $dataList = $this->model::from('offerings as a')
            ->where(function ($query) use ($params) {
                $query->where(['a.mark'=>1,'a.status'=> 1]);
                $type = isset($params['type'])? $params['type'] : 0;
                if($type){
                    $query->where('a.type', $type);
                }
                $goodsType = isset($params['goods_type'])? $params['goods_type'] : 0;
                if($goodsType){
                    $query->where('a.goods_type', $goodsType);
                }
            })
            ->select(['a.*'])
            ->orderBy('a.sort', 'asc')
            ->orderBy('a.create_time', 'desc')
            ->paginate($pageSize);

        $dataList = $dataList ? $dataList->toArray() : [];
        if ($dataList) {
            foreach ($dataList['data'] as &$item) {
                $item['icon'] = $item['icon'] ? get_image_url($item['icon']) : '';
                $item['icon_real'] = $item['icon_real'] ? get_image_url($item['icon_real']) : '';
                $item['create_time'] = $item['create_time'] ? datetime($item['create_time'],'Y-m-d H:i:s') : '';

            }
            unset($item);
        }

        return [
            'code' => 0,
            'success'=> true,
            'msg' => '操作成功',
            'count' => isset($dataList['total']) ? $dataList['total'] : 0,
            'data' => isset($dataList['data']) ? $dataList['data'] : 0,
        ];
    }

    /**
     * 请佛
     * @param $userId
     * @return array
     */
    public function select($userId){
        $id = request()->get('id', 0);
        if($id <=0){
            return message('参数错误', false);
        }

        $foInfo = FoxiangModel::where(['id'=> $id,'mark'=> 1,'status'=> 1])
            ->select(['id','name'])
            ->first();
        if(!$foInfo){
            return message('佛像不存在，请选择其他佛像', false);
        }

        $memberInfo = MemberModel::where(['id'=> $userId,'mark'=> 1,'status'=> 1])
            ->select(['id','nickname'])
            ->first();
        if(!$memberInfo){
            return message('您的账号不可操作或已冻结，请联系客服', false);
        }

        // 验证是否正在供奉该佛像
        $type = request()->get('type', 1);
        $params = request()->all();
        switch($type){
            case 1: // 祈福
                $limitNum = ConfigService::make()->getConfigByCode('qifu_limit');
                if($limitNum) {
                    $num = $this->model::where(['user_id'=> $userId,'mark'=> 1,'status'=> 1])
                        ->count('id');
                    if($num >= $limitNum){
                        return message("最多只能同时供奉{$limitNum}尊佛像，请送圣后再操作", false);
                    }
                }

                $record = $this->model::where(['fo_id'=> $id,'user_id'=> $userId,'mark'=> 1,'status'=> 1])
                    ->select(['id','fo_id','user_id'])
                    ->first();
                if($record){
                    return message('抱歉该佛像您正在供奉中，请24小时后再继续供奉或选择其他佛像', false);
                }
                break;
            case 2: // 超度
                break;
            case 3: // 放生
                break;
        }

        $data = [
            'fo_id'=> $id,
            'type'=> $type,
            'user_id'=> $userId,
            'used_name'=> isset($params['used_name'])? trim($params['used_name']) : '',
            'user_name'=> isset($params['user_name'])? trim($params['user_name']) : '',
            'relation'=> isset($params['relation'])? trim($params['relation']) : '',
            'description'=> isset($params['description'])? trim($params['description']) : '',
            'image'=> isset($params['image'])? trim($params['image']) : '',
            'create_time'=> time(),
            'update_time'=> time(),
            'mark'=> 1,
            'status'=> 1,
        ];

        if($this->model::insertGetId($data)){
            return message('请佛成功',true);
        }else{
            return message('请佛失败',true);
        }
    }


    /**
     * 送圣
     * @param $userId
     * @return array
     */
    public function packoff($userId){
        $id = request()->get('id', 0);
        $type = request()->get('type', 0);

        if(!$id || !$type){
            return message('参数错误', false);
        }


        $enshrine = $this->model::where(['fo_id'=> $id, 'user_id'=> $userId,'type'=> $type,'mark'=> 1,'status'=> 1])
            ->select(['id','fo_id','user_id','status'])
            ->first();
        if(!$enshrine){
            return message('佛像信息不存在', false);
        }

        $enshrine->status = 2;
        if($enshrine->save()){
            return message('送圣成功', true);
        }else{
            return message('送圣失败', false);
        }

    }

    /**
     * 供奉操作记录
     * @param $userId
     * @return array
     */
    public function actionRecord($userId){
        $params = request()->all();
        $id = isset($params['id'])? $params['id'] : 0;
        $type = isset($params['type'])? $params['type'] : 0;
        if($id<=0 || $type <=0){
            return message('参数错误', false);
        }

        $enshrine = $this->model::where(['id'=> $id,'user_id'=> $userId,'mark'=> 1,'status'=> 1])
            ->select(['id','fo_id','user_id'])
            ->first();
        if(!$enshrine){
            return message('供奉记录信息不存在，无法操作', false);
        }

        $memberInfo = MemberModel::where(['id'=> $userId,'mark'=> 1,'status'=> 1])
            ->select(['id','nickname','merits_num'])
            ->first();
        if(!$memberInfo){
            return message('您的账号不可操作或已冻结，请联系客服', false);
        }

        \DB::beginTransaction();
        $data = [
            'source_id'=> $id,
            'user_id'=> $userId,
            'type'=> $type,
            'description'=> isset($params['description'])? $params['description'] : '',
            'create_time'=> time(),
            'update_time'=> time(),
            'status'=> 1
        ];
        if(!EnshrineActionModel::insertGetId($data)) {
            \DB::rollBack();
            return message('操作失败', false);
        }

        $giveGd = 0;
        $fields = ['1'=> 'qifu_guibai_give_gd','2'=> 'qifu_wash_give_gd','3'=>'qifu_xuyuan_give_gd'];
        $field = isset($fields[$type])? $fields[$type] : '';
        if($field){
            $giveGd = ConfigService::make()->getConfigByCode($field);
        }

        // 功德值
        if($giveGd>0){

            if(!MemberModel::where(['id'=> $userId, 'mark'=> 1])->increment('merits_num', $giveGd)){
                \DB::rollBack();
                return message("更新功德账户失败", false);
            }

            $data = [
                'user_id'=> $userId,
                'source_uid'=> 0,
                'type'=> 3,
                'coin_type'=> 4,
                'pay_type'=> 4,
                'money'=> $giveGd,
                'change_type'=> 1,
                'balance'=> $memberInfo->merits_num,
                'create_time'=> time(),
                'remark'=> $type==1? "跪拜祈福":'洗手祈福',
                'status'=> 1,
            ];
            if(!TradeModel::insertGetId($data)){
                \DB::rollBack();
                return message("处理功德奖励失败", false);
            }

            \DB::commit();
            return message("获得功德值{$giveGd}", true);
        }


        \DB::commit();
        return message("操作成功", true);
    }

    /**
     * 购买物品
     * @param $userId
     * @return array
     */
    public function buy($userId){
        $params = request()->all();
        $id = isset($params['id'])? $params['id'] : 0;
        $enshrineId = isset($params['enshrine_id'])? $params['enshrine_id'] : 0;
        $type = isset($params['type'])? $params['type'] : 0;
        if($id<=0 || $type <=0 || $enshrineId<=0){
            return message('参数错误', false);
        }

        $enshrine = $this->model::where(['id'=> $enshrineId,'user_id'=> $userId,'mark'=> 1,'status'=> 1])
            ->select(['id','fo_id','user_id'])
            ->first();
        if(!$enshrine){
            return message('供奉记录信息不存在，无法操作', false);
        }

        $memberInfo = MemberModel::where(['id'=> $userId,'mark'=> 1,'status'=> 1])
            ->select(['id','nickname','merits_num','coupon'])
            ->first();
        if(!$memberInfo){
            return message('您的账号不可操作或已冻结，请联系客服', false);
        }

        // 物品
        $goodsInfo = OfferingsModel::where(['id'=> $id,'mark'=> 1,'status'=> 1])
            ->select(['id','type','goods_type','name','price'])
            ->first();
        if(!$goodsInfo){
            return message('物品不存在或已下架，请刷新重试', false);
        }

        // 是否未到期
        $expireTime = ConfigService::make()->getConfigByCode('enshrine_expire_time');
        $expireTime = $expireTime? $expireTime : 0;
        $info = $this->getOrderGoodsInfo($enshrineId, $userId, $type, $goodsInfo->goods_type);
        if($info){
            $createTime = isset($info['create_time'])? intval($info['create_time']) : time();
            $enshrineTime = time() - $createTime;
            $hour = intval($enshrineTime/3600);
            $minute = ceil(($enshrineTime%3600)/60);

            $enshrineTime1 = ($createTime+$expireTime*3600 - time());
            $hour1 = intval($enshrineTime1/3600);
            $minute1 = intval(($enshrineTime1%3600)/60);
            $time = date('H点i分', $createTime+$expireTime*3600);
            $msg = "您已经恭请{$goodsInfo->name}供佛{$hour}小时{$minute}分，还有{$hour1}小时{$minute1}分($time)到期，每天更换贡品代表恭敬佛菩萨，阿弥陀佛";
            return message($msg, false, ['show'=> true,'time'=> $enshrineTime,'hour'=> $hour,'minute'=> $minute]);
        }

        \DB::beginTransaction();
        $data = [
            'source_id'=> $enshrineId,
            'goods_id'=> $id,
            'user_id'=> $userId,
            'type'=> $type,
            'order_sn'=> get_order_num('F'),
            'num'=> 1,
            'price'=> $goodsInfo->price,
            'total'=> $goodsInfo->price,
            'gd_name'=> isset($params['gd_name'])? $params['gd_name'] : '',
            'pay_at'=> date('Y-m-d H:i:s'),
            'remark'=> isset($params['remark'])? $params['remark'] : '',
            'create_time'=> time(),
            'update_time'=> time(),
            'status'=> 2
        ];
        if(!EnshrineOrdersModel::insertGetId($data)) {
            \DB::rollBack();
            return message('供奉物品失败', false);
        }

        // 扣款奖励处理
        if($goodsInfo->price>0){

            if($memberInfo->coupon < $goodsInfo->price){
                return message("账户花灯券不足，请先充值", false, [],10003);
            }

            if(!MemberModel::where(['id'=> $userId, 'mark'=> 1])->decrement('coupon', $goodsInfo->price)){
                \DB::rollBack();
                return message("更新花灯券账户失败", false);
            }

            $data = [
                'user_id'=> $userId,
                'source_uid'=> 0,
                'type'=> 1,
                'coin_type'=> 1,
                'pay_type'=> 1,
                'money'=> $goodsInfo->price,
                'change_type'=> 2,
                'balance'=> $memberInfo->coupon,
                'create_time'=> time(),
                'remark'=> $type == 1? "祈福供奉{$goodsInfo->name}" : ($type == 3? "放生{$goodsInfo->name}" : '超度普渡众生'),
                'status'=> 1,
            ];
            if(!TradeModel::insertGetId($data)){
                \DB::rollBack();
                return message("处理账户明细失败", false);
            }
        }

        // 奖励
        $giveGd = ConfigService::make()->getConfigByCode('enshrine_give_gd');
        $giveGd = $giveGd? $giveGd : 0;
        if($giveGd>0){
            if(!MemberModel::where(['id'=> $userId, 'mark'=> 1])->increment('merits_num', $giveGd)){
                \DB::rollBack();
                return message("更新功德账户失败", false);
            }

            $data = [
                'user_id'=> $userId,
                'source_uid'=> 0,
                'type'=> 3,
                'coin_type'=> 4,
                'pay_type'=> 4,
                'money'=> $giveGd,
                'change_type'=> 1,
                'balance'=> $memberInfo->merits_num,
                'create_time'=> time(),
                'remark'=> $type==1? "跪拜祈福":'洗手祈福',
                'status'=> 1,
            ];
            if(!TradeModel::insertGetId($data)){
                \DB::rollBack();
                return message("处理功德奖励失败", false);
            }

        }

        \DB::commit();

        // 动态
        $data = [
            'type'=> $type+1,
            'user_id'=> $userId,
            'remark'=> $type == 1? "供奉{$goodsInfo->name}" : ($type == 3? "放生{$goodsInfo->name}" : '超度普渡众生'),
            'update_time'=> time(),
            'create_time'=> time(),
            'status'=> 1
        ];
        DynamicNoticeModel::insertGetId($data);


        if($giveGd>0){
            return message("获得功德值{$giveGd}", true, ['num'=> $giveGd]);
        }else{
            return message("操作成功", true);
        }
    }
}