| Server IP : 199.250.214.225 / Your IP : 3.15.223.39 Web Server : Apache System : Linux vps64074.inmotionhosting.com 3.10.0-1160.105.1.vz7.214.3 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : nicngo5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /home/nicngo5/funds.upgrade.nicn.gov.ng/funds-upgraded/app/Http/Controllers/payroll/ |
Upload File : |
<?php
namespace App\Http\Controllers;
namespace App\Http\Controllers\payroll;
use App\Http\Requests;
use App\Role;
use App\User;
use Auth;
use Entrust;
use App\Permission;
use Illuminate\Http\Request;
use DB;
use App\Http\Controllers\Controller;
use Illuminate\Pagination\Paginator;
use Illuminate\Pagination\LengthAwarePaginator;
use Illuminate\Support\Collection;
use session;
class SalaryScaleController extends Controller
{
public function __construct()
{
}
public function index(Request $request)
{ $data['count'] = '';
$data['courts'] = DB::table('tbl_court')->get();
return view('payroll.SalaryScale.index', $data);
}
public function getSalary(Request $request)
{
$court = $request['court'];
$data['courts'] = DB::table('tbl_court')->get();
$data['count'] = DB::table('basicsalary')->where('courtID', '=', $court)->count();
Session::put('courtID', $court);
return view('payroll.SalaryScale.index', $data);
}
public function customPaging($type,$court, Request $request){
$tableName = "basicsalary";
$employee_type = $type;
$data['employee_type']=strtoupper($employee_type);
$grade = "";
$grade = $request->get('page');
if(is_null($grade))
{
$grade=1;
}
$data['current_grade'] = $grade;
$data['report'] = DB::table($tableName)->where('employee_type', '=', $employee_type )
->where('courtID', '=', session('courtID') )
->where('grade', '=',$grade )
->orderby('step')->get();
$searchResults = DB::table('basicsalary')
->select('grade')
->distinct()
->get();
//Get current page form url e.g. &page=6
$currentPage = LengthAwarePaginator::resolveCurrentPage();
//Create a new Laravel collection from the array data
$collection = new Collection($searchResults);
//Define how many items we want to be visible in each page
$perPage = 1;
//Slice the collection to get the items to display in current page
$currentPageSearchResults = $collection->slice (($currentPage ) * $perPage, $perPage)->all();
//$currentPageSearchResults = $collection->slice($currentPage * $perPage, $perPage)->all();
//Create our paginator and pass it to the view
$paginatedSearchResults= new LengthAwarePaginator($searchResults, count($collection)+2, $perPage,Paginator::resolveCurrentPage(),['path' => Paginator::resolveCurrentPath()]
);
return view('payroll.SalaryScale.salarySummary', ['results' => $paginatedSearchResults],$data);
}
}