| Server IP : 199.250.214.225 / Your IP : 3.22.66.236 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/ |
Upload File : |
<?php
namespace App\Http\Controllers;
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 Session;
class PaySlipController extends ParentController
{
public $division;
public function __construct(Request $request)
{
$this->division = $request->session()->get('division');
$this->divisionID = $request->session()->get('divisionID');
}
public function create()
{
$divisionID = $this->divisionID;
$divisionsession = session('divsession');
$data['division'] = DB::table('tbldivision')->where('courtID','=', session('anycourt'))->get();
$data['court'] = DB::table('tbl_court')->get();
$data['users'] = DB::table('tblper')
//->where('tblper.divisionID', '=', $divisionID)
->where('divisionID','=', $divisionsession)
->orderBy('surname', 'Asc')
->get();
return view('payslip.index',$data);
}
public function Retrieve(Request $request)
{
// dd(date('d/m/Y'));
$month = trim($request->input('month'));
$year = trim($request->input('year'));
$fileNo = trim($request->input('fileNo'));
$division = trim($request->input('division'));
$court = trim($request->input('court'));
//dd($month);
//$division = $this->division;
$this->validate
($request,[
'month' => 'required|regex:/^[\pL\s\-]+$/u',
'year' => 'required|integer',
'fileNo' => 'required|string'
]);
$courtName= DB::table('tbl_court')->where('id','=',$court)->first();
$data['courtName'] = $courtName->court_name;
$data['division'] = DB::table('tbldivision')->where('divisionID','=',$division)->first();
$count = DB::table('tblpayment')
->join('tblper', 'tblper.fileNo', '=','tblpayment.fileNo')
->where('tblpayment.fileNo', '=',$fileNo)
->where('tblpayment.year', '=', $year)
->where('tblpayment.month', '=', $month)
->where('tblpayment.courtID', '=', $court)
//->select();
->count();
if($count == 0)
{
return redirect('/payslip/create')->with('message','No Record Found');
}
else{
//dd($bankName);
$data['payslip_detail'] = DB::table('tblpayment')
->join('tblper', 'tblper.fileNo', '=','tblpayment.fileNo')
->where('tblpayment.fileNo', '=',$fileNo)
->where('tblpayment.year', '=', $year)
->where('tblpayment.month', '=', $month)
->where('tblpayment.courtID', '=', $court)
//->select();
->get();
$detail = DB::table('tblpayment')
->join('tblper', 'tblper.fileNo', '=','tblpayment.fileNo')
->where('tblpayment.fileNo', '=',$fileNo)
->where('tblpayment.year', '=', $year)
->where('tblpayment.month', '=', $month)
->where('tblpayment.courtID', '=', $court)
//->select();
->first();
$data['bank'] = DB::table('tblbanklist')->where('bankID','=',$detail->bank)->first();
$data['leave_grant'] = DB::table('basicsalary')
->where('basicsalary.grade', '=',$detail->grade)
->where('basicsalary.step', '=', $detail->step)
->where('basicsalary.courtID', '=', $court)
->where('basicsalary.employee_type', '=', 'JUDICIAL')
->first();
//dd($data);
// Session::put('schmonth', $month." ".$year);
// Session::put('date', date('d/m/Y'));
// Session::put('bank', $bankName ." ".$bankGroup);
//dd($data);
return view('payslip.summary', $data);
}
}
}