BoxsetCtrl.php

<?php

namespace App\Http\Controllers;

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


class BoxsetController extends Controller
{

    public function index($offset)
    {
        $Sesries = DB::table('tblseries')->select('seriesid', 'seriesname', 'imagepath', 'views', 'scenes')->where('active', '=', 'y')->whereIn('site', [1, 3])->skip($offset)->take(6)->get();
        return response()->json($Sesries);
    }

    public function getByMostRecent($offset)
    {
        $Sesries = DB::table('tblseries')->select('seriesid', 'seriesname', 'imagepath', 'views', 'scenes')->where('active', '=', 'y')->whereIn('site', [1, 3])->orderBy('lastupdated', 'desc')->skip($offset)->take(6)->get();
        return response()->json($Sesries);
    }

    public function getByPopularity($offset)
    {
        $Sesries = DB::table('tblseries')->select('seriesid', 'seriesname', 'imagepath', 'views', 'scenes')->where('active', '=', 'y')->whereIn('site', [1, 3])->orderBy('views', 'desc')->skip($offset)->take(6)->get();
        return response()->json($Sesries);
    }
   
}