public function index(Request $request) { $operatorId = (int) Authorizer::getResourceOwnerId(); $querys = $request->query(); $keyword = isset($querys['keyword']) ? $querys['keyword'] : ''; $apps = App::distinct()->orderBy('id'); if ($keyword) { $keyword = '%' . $keyword . '%'; $apps = $apps->where('name', 'like', $keyword); } if (isset($querys['author_id']) && is_numeric($querys['author_id'])) { $author_id = (int) $querys['author_id']; $apps = $apps->where('author_id', $author_id); } if (isset($querys['status'])) { $apps = $apps->where('status', $querys['status']); } $page = 1; if (isset($querys['page']) && is_numeric($querys['page'])) { $page = (int) $querys['page']; } $pageSize = 20; if (isset($querys['per_page']) && is_numeric($querys['per_page'])) { $pageSize = (int) $querys['per_page']; } $totalCount = count($apps->get()); $skip = $pageSize * ($page - 1); $apps = $apps->skip($skip)->take($pageSize)->get(); foreach ($apps as $app) { $app = $this->unfoldAppInfo($app); } $result = array('page' => $page, 'per_page' => $pageSize, 'total_count' => $totalCount, 'data' => $apps); return response()->json($result); }
/** * appList. * * @param Request $request request object * * @return Array */ public function appList(Request $request) { $apps = App::distinct()->orderBy('created_at', 'desc'); $apps = $apps->get(); return view('applist', ['apps' => $apps]); }