all(); $model = new VideoLook(); $limit = $param['limit'] ?? 10; $user_name = $param['user_name']; $user_id = $param['user_id']; $video_title = $param['video_title']; $where = []; if (!empty($user_name)) { $where[] = ['user_name', 'like', '%' . $user_name . '%']; } if (!empty($user_id)) { $where[] = ['user_id', 'like', '%' . $user_id . '%']; } if (!empty($video_title)) { $where[] = ['video_title', 'like', '%' . $video_title . '%']; } $list = $model->where($where)->orderBy('id', 'desc')->get(); return sparkSuccess(dataReturn(0, '查询成功', $list)); } /** * 编辑用户观看信息 * @param $param */ public function update(Request $request) { $param = $request->all(); $id = $param['id']; $model = new VideoLook(); if (!empty($param['password'])) { $param['password'] = makePassword($param['password']); $param['salt'] = config('shop.salt'); } else { unset($param['password']); } $where[] = ['name', '=', $param['name']]; $where[] = ['id', '<>', $param['id']]; $has = $model->checkUnique($where); if (!empty($has)) { return sparkSuccess(dataReturn(1, '该人员已经存在')); } $model->updateById($param, $id); return sparkSuccess(dataReturn(0, '编辑成功')); } /** * 删除测评用户 */ public function destroy(Request $request) { $param = $request->all(); $id = $param['id']; $model = new VideoLook(); $model->where('id', '=', $id)->delete(); return sparkSuccess(dataReturn(0, '删除成功')); } public function addUserLookVideo() { try { $params = request()->get(); checkEmpty($params, [ 'id' => '视频编号', 'video_url' => '视频地址', 'video_title' => '视频标题', 'video_header_url' => '视频图', 'duration' => '总时长', 'currentTime' => '观看时长', ]); $adminId = \Tinywan\Jwt\JwtToken::getCurrentId(); $info = (new AdminUser)->select()->where("id", '=', $adminId)->first(); $data = [ 'video_id' => $params['id'], 'video_url' => $params['video_url'], 'video_title' => $params['video_title'], 'video_header_url' => $params['video_header_url'], 'duration' => $params['duration'], 'currentTime' => $params['currentTime'], 'last_look_time' => now(), 'user_id' => $info['id'], 'user_name' => $info['nickname'] ]; $data['is_look_completed'] = isset($params['is_look_completed']) ? $params['is_look_completed'] : 0; #是否已存在视频信息 有则修改 反之插入 (new VideoLook)->updateOrCreate(['video_id' => $data['video_id'], 'user_id' => $data['user_id']], $data); // update_time return sparkSuccess(dataReturn(0, '添加成功')); } catch (\Exception $e) { return sparkSuccess(dataReturn(-1, $e->getMessage())); } } public function getAllCurrentTime() { $params = request()->all(); // $where[]=['','',''] $adminId = \Tinywan\Jwt\JwtToken::getCurrentId(); $data = (new VideoLook) ->select('video_id', 'last_look_time', 'is_look_completed', 'duration', 'currentTime') ->where('user_id', '=', $adminId) ->whereIn('video_id', $params['videoIdList']) ->get(); return sparkSuccess(dataReturn(0, '查询成功', $data)); } }