Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function feed(){
- if (request()->has('page')) {
- $pagesize = 20;
- $query = Posts::join('clase_user', function ($join) {
- $user = JWTAuth::parseToken()->authenticate();
- $join->on('clase_user.clase_id', '=', 'posts.clase_id')
- ->where('clase_user.user_id', '=', $user->id);
- })
- ->with('user')
- ->skip(((int)request()->get('page') - 1) * $pagesize)
- ->take($pagesize)->get();
- return $query;
- }else{
- return response()->json(['error' => 'Page not specified'], 500);
- }
- }
- {
- "posts": [
- {
- "id": 3,
- "user_id": 1,
- "clase_id": 1,
- "thumbNail": null,
- "text": "Hola Chicos",
- "archivo": null,
- "created_at": "2017-07-20 00:00:00",
- "updated_at": "2017-07-20 00:00:00",
- "user": {
- "id": 1,
- "name": "Juan Carlos",
- "about": "Hola me llamo Juan Carlos",
- "handler": "Juantvz50",
- "pp": null,
- "verify": 1,
- "email": "jc_estevezr@hotmail.com",
- "deleted_at": null,
- "LoginId": null,
- "created_at": "2017-07-20 23:52:28",
- "updated_at": "2017-07-20 23:52:28"
- }
- },
- {
- "id": 1,
- "user_id": 1,
- "clase_id": 2,
- "thumbNail": null,
- "text": "Que pex Prrrro",
- "archivo": null,
- "created_at": "2017-07-20 00:00:00",
- "updated_at": "2017-07-20 00:00:00",
- "user": {
- "id": 1,
- "name": "Juan Carlos",
- "about": "Hola me llamo Juan Carlos",
- "handler": "Juantvz50",
- "pp": null,
- "verify": 1,
- "email": "jc_estevezr@hotmail.com",
- "deleted_at": null,
- "LoginId": null,
- "created_at": "2017-07-20 23:52:28",
- "updated_at": "2017-07-20 23:52:28"
- }
- },
- {
- "id": 3,
- "user_id": 1,
- "clase_id": 1,
- "thumbNail": null,
- "text": "Que Onda Chicos",
- "archivo": null,
- "created_at": "2017-07-20 00:00:00",
- "updated_at": "2017-07-20 00:00:00",
- "user": {
- "id": 1,
- "name": "Juan Carlos",
- "about": "Hola me llamo Juan Carlos",
- "handler": "Juantvz50",
- "pp": null,
- "verify": 1,
- "email": "jc_estevezr@hotmail.com",
- "deleted_at": null,
- "LoginId": null,
- "created_at": "2017-07-20 23:52:28",
- "updated_at": "2017-07-20 23:52:28"
- }
- }
- ]
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement