// +---------------------------------------------------------------------- namespace App\Services; use App\Models\DynamicNoticeModel; use App\Models\EnshrineActionModel; use App\Models\EnshrineOrdersModel; use App\Models\EnshrineRecordModel; 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'], 2); if($guo){ $item['guo'] = $guo; } // 香烛 $item['xiang'] = ['id'=> 0,'icon'=> '','icon_real'=> '']; $xiang = $this->getOrderGoodsInfo($item['id'], $userId, $item['type'], 2); 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.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['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 = $this->model::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, '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']; $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){ $enshrineTime = (time() - $info->ceate_time); $hour = intval($enshrineTime/3600); $minute = intval(($expireTime%3600)/60); $hour1 = $expireTime>$hour? $expireTime - $hour : 0; $time = date('H点i分', $info->create_time+$expireTime*3600); $msg = "您已经恭请{$goodsInfo->name}供佛{$hour}小时{$minute}分,还有{$hour1}小时{$minute}分($time)到期,每天更换贡品代表恭敬佛菩萨,阿弥陀佛"; return message($msg, false, ['show'=> true]); } \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(!MemberModel::where(['id'=> $userId, 'mark'=> 1])->increment('coupon', $goodsInfo->price)){ \DB::rollBack(); return message("更新花灯券账户失败", false); } $data = [ 'user_id'=> $userId, 'source_uid'=> 0, 'type'=> 3, 'coin_type'=> 4, 'pay_type'=> 4, 'money'=> $goodsInfo->price, 'change_type'=> 1, '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(); return message("获得功德值{$giveGd}", true, ['num'=> $giveGd]); } } \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); return message("操作成功", true); } }