CategoryCtrl.php

<?php

namespace App\Http\Controllers;

use DB;
use App\Http\Controllers\Controller;
use Illuminate\Http\Request;


class CategoryController extends Controller
{

    public function index($offset)
    {
        $Categories = DB::table('tblgenre')->select('genreid', 'genrename', 'imagepath', 'views', 'scenes')->where('active', '=', 'y')->whereIn('site', [1, 3])->skip($offset)->take(8)->get();
        return response()->json($Categories);
    }

    public function getByMostRecent($offset)
    {
//        $Categories = DB::table('tblgenre')->select('genreid', 'genrename', 'imagepath', 'views', 'scenes')->where('active', '=', 'y')->whereIn('site', [1, 3])->orderBy('lastupdated', 'desc')->skip($offset)->take(8)->get();
        $Categories = DB::select('select g.genreid,g.genrename,g.lastupdated,g.genredesc,g.imagepath,g.views,vw.scenes,g.likes,g.dislikes from tblgenre g,vwgenrescenes vw where g.genreid = vw.genreid and upper(g.active) = \'Y\' and vw.scenes >0 and (g.site = 1 or g.site=3) and vw.site = 1 order by g.lastupdated desc limit 8 offset :offset', ['offset' => $offset]);
        return response()->json($Categories);
    }

    public function getByPopularity($offset)
    {
//        $Categories = DB::table('tblgenre')->select('genreid', 'genrename', 'imagepath', 'views', 'scenes')->where('active', '=', 'y')->whereIn('site', [1, 3])->orderBy('views', 'desc')->skip($offset)->take(8)->get();
        $Categories = DB::select('select g.genreid,g.genrename,g.lastupdated,g.genredesc,g.imagepath,g.views,vw.scenes,g.likes,g.dislikes from tblgenre g,vwgenrescenes vw where g.genreid = vw.genreid and upper(g.active) = \'Y\' and vw.scenes >0 and (g.site = 1 or g.site=3) and vw.site = 1 order by g.views desc limit 8 offset :offset', ['offset' => $offset]);
        return response()->json($Categories);
    }

}