// +---------------------------------------------------------------------- namespace App\Services; use App\Models\MemberModel; use App\Models\MusicCollectModel; use App\Models\MusicPlayedModel; use App\Models\TradeModel; /** * 佛音播放记录管理-服务类 * @author wesmiler * @since 2020/11/11 * Class MusicPlayedService * @package App\Services */ class MusicPlayedService extends BaseService { /** * 构造函数 * @author wesmiler * @since 2020/11/11 * MusicPlayedService constructor. */ public function __construct() { $this->model = new MusicPlayedModel(); } /** * 获取列表 * @return array * @since 2020/11/11 * @author wesmiler */ public function getList() { $params = request()->all(); return parent::getList(); } /** * 获取列表 * @return array * @since 2020/11/11 * @author wesmiler */ public function getDataList($params) { $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE; $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE; $dataList = $this->model::from('music_played as a') ->leftJoin('member as m', 'm.id', '=', 'a.user_id') ->leftJoin('musics as ms', 'ms.id', '=', 'a.source_id') ->where(function ($query) use ($params) { $query->where(['a.mark'=>1,'a.status'=> 1]); $userId = isset($params['user_id']) ? intval($params['user_id']) : 0; if ($userId > 0) { $query->where('a.user_id', $userId); } }) ->select(['a.source_id as id', 'ms.title','ms.file_url','ms.author','ms.play_num', 'a.user_id', 'm.nickname', 'm.avatar', 'ms.thumb', 'a.status', 'a.create_time', 'a.update_time']) ->orderBy('a.create_time', 'desc') ->paginate($pageSize); $dataList = $dataList ? $dataList->toArray() : []; if ($dataList) { $userId = isset($params['user_id']) ? intval($params['user_id']) : 0; foreach ($dataList['data'] as &$item) { $item['thumb'] = $item['thumb'] ? get_image_url($item['thumb']) : ''; $item['file_url'] = $item['file_url'] ? get_file_url($item['file_url']) : ''; $item['create_time'] = $item['create_time'] ? datetime($item['create_time'],'Y-m-d H:i:s') : ''; $isCollect = MusicCollectModel::where(['user_id'=> $userId,'source_id'=> $item['id'],'status'=> 1,'mark'=>1])->value('id'); $item['is_collect'] =$isCollect? 1 : 0; } unset($item); } return [ 'code' => 0, 'success'=> true, 'msg' => '操作成功', 'count' => isset($dataList['total']) ? $dataList['total'] : 0, 'data' => isset($dataList['data']) ? $dataList['data'] : 0, ]; } /** * 添加或编辑 * @return array * @since 2020/11/11 * @author wesmiler */ public function edit() { $data = request()->all(); $data['update_time'] = time(); return parent::edit($data); // TODO: Change the autogenerated stub } /** * 添加或编辑 * @return array * @since 2020/11/11 * @author wesmiler */ public function save($userId) { $params = request()->all(); $id = isset($params['id'])? $params['id'] : 0; $status = isset($params['status'])? $params['status'] : 1; if($id<=0){ return message('参数错误', false); } $info = $this->model::where(['user_id'=> $userId, 'source_id'=> $id])->select(['id','status'])->first(); $count = $this->model::where(['user_id'=> $userId, 'status'=> 1]) ->where('create_time','<=',time() - 7 * 86400) ->count('id'); $this->model::where(['user_id'=> $userId, 'status'=> 3]) ->where('update_time','<=',time() - 3 * 86400) ->delete(); if($count >= 20){ $this->model::where(['user_id'=> $userId, 'status'=> 1]) ->where('create_time','<=',time() - 7 * 86400) ->update(['status'=> 3,'update_time'=>time()]); } // 奖励 $checkInfo = $this->model::where(['user_id'=> $userId, 'status'=> 1]) ->where('update_time','>=',strtotime(date('Y-m-d'))) ->first(); $giveGd = ConfigService::make()->getConfigByCode('foyin_give_gd'); $giveGd = $giveGd ? $giveGd : 0; if ($giveGd > 0 && !$checkInfo) { $memberInfo = MemberModel::where(['id' => $userId, 'mark' => 1, 'status' => 1]) ->select(['id', 'nickname', 'merits_num', 'coupon']) ->first(); if (!$memberInfo) { return message('您的账号不可操作或已冻结,请联系客服', false); } if (!MemberModel::where(['id' => $userId, 'mark' => 1])->increment('merits_num', $giveGd)) { 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' => '完成佛音项目', 'status' => 1, ]; if (!TradeModel::insertGetId($data)) { return message("处理功德奖励失败", false); } } // 完成修行项目 PracticesService::make()->saveLog($userId, 6, '佛音'); // 处理 if($info){ $info->status = $status; $info->create_time = time(); $info->update_time = time(); if($info->save()){ return message("操作成功", true); } }else{ $data = [ 'user_id'=> $userId, 'source_id'=> $id, 'create_time'=> time(), 'status'=> 1, ]; if($this->model::insertGetId($data)){ return message("操作成功", true); } } return message('操作失败', false); } }