| Server IP : 199.250.214.225 / Your IP : 3.145.7.217 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;
use Illuminate\Http\Request;
use App\Http\Requests;
use App\Http\Controllers;
//use Illuminate\Foundation\Validation\ValidatesRequests;
use DB;
use session;
class ControlVariableController extends ParentController
{
public function __construct(Request $request)
{
$this->division = $request->session()->get('division');
$this->divisionID = $request->session()->get('divisionID');
}
public function create()
{
//dd(session('courtDivision'));
//populate
$data['staffList'] = $this->getStaffInfo();
$data['court'] = DB::table('tbl_court')->get();
$data['division'] = DB::table('tbldivision')->where('courtID','=', session('court'))->get();
//dd($data['division']);
return view('payroll.variable.ControlVariable', $data);
}
public function update(Request $request)
{
$this->validate($request, [
'vehicle' => 'required|numeric',
'nicnCoop' => 'required|numeric',
'motor' => 'required|numeric',
'bicycle' => 'required|numeric',
'labour' => 'required|numeric',
'fedsec' => 'required|numeric',
'fedhouse' => 'required|numeric',
'hazard' => 'required|numeric',
'duty' => 'required|numeric',
'allowances' => 'required|numeric',
'phonecharges' => 'required|numeric',
'assistant' => 'required|numeric',
'surcharge' => 'required|numeric',
]);
//Assign validated data to variables
$fileNo = trim($request['fileNo']);
$vehicle = trim($request['vehicle']);
$nicnCoop = trim($request['nicnCoop']);
$motor = trim($request['motor']);
$bicycle = trim($request['bicycle']);
$labour = trim($request['labour']);
$fedsec = trim($request['fedsec']);
$housingLoan = trim($request['fedhouse']);
$hazard = trim($request['hazard']);
$duty = trim($request['duty']);
$allowances = trim($request['allowances']);
$phonecharges = trim($request['phonecharges']);
$assistant = trim($request['assistant']);
$surcharge = trim($request['surcharge']);
DB::table('tblcv')->where('fileNo', $fileNo)->update(array(
'ugv' => $vehicle,
'nicnCoop' => $nicnCoop,
'motorAdv' => $motor,
'bicycleAdv' => $bicycle,
'ctlsLab' => $labour,
'ctlsFed' => $fedsec,
'fedHousing' => $housingLoan,
'hazard' => $hazard,
'callDuty' => $duty,
'shiftAll' => $allowances,
'phonecharges' => $phonecharges,
'pa_deduct' => $assistant,
'surcharge' => $surcharge,
));
$this->addLog('control variable update with fileno = '.$fileNo);
$data['staffList'] = DB::table('tblper')->select('fileNo', 'surname', 'first_name', 'othernames')
->where('divisionID', '=', $this->divisionID)
->orderBy('surname', 'Asc')->get();
return redirect('variable/create')->with('msg', 'Control Variables were successfully updated!');
}
public function findStaff(Request $request)
{
$this->validate($request, [
'staffName' => 'required|numeric',
]);
$fileNo = $request->input('staffName');
$data = DB::table('tblcv')
->where('tblcv.fileNo', '=', $fileNo)
->where('divisionID', '=', $this->divisionID)
->select('tblcv.fileNo', 'tblcv.ugv', 'tblcv.nicnCoop', 'tblcv.motorAdv', 'tblcv.bicycleAdv', 'tblcv.ctlsLab', 'tblcv.ctlsFed', 'tblcv.fedHousing',
'tblcv.hazard', 'tblcv.callDuty', 'tblcv.shiftAll', 'tblcv.phoneCharges', 'tblcv.surcharge', 'tblcv.pa_deduct', 'tblper.surname', 'tblper.first_name', 'tblper.grade', 'tblper.step', 'tblper.employee_type')
->join('tblper', 'tblper.fileNo', '=', 'tblcv.fileNo')
->first();
///->where('tblcv.fileNo', '=', $fileNo)
return response()->json($data);
}
public function view($fileNo = Null)
{
if($fileNo == Null)
return redirect('variable/create')->with('msg', 'No record found for this user!');
else{
$data['staffDetails'] = DB::table('tblpayment')->select('fileNo', 'ugv', 'nicnCoop', 'ctlsLab', 'ctlsFed', 'fedHousing', 'motorAdv', 'bicycleAdv', 'tax', 'nhf',
'unionDues', 'month', 'year', 'step', 'grade')
-> where ('fileNo', '=', $fileNo)
->orderBy('year', 'Desc')->get();
return view('payroll.variable.ViewOthers', $data);
}
}
public function getDivisions(Request $request)
{
$court = $request['courtID'];
$data = DB::table('tbldivision')->where('courtID', '=', $court)->get();
return response()->json($data);
}
public function getDStaffInfo(Request $request)
{
$div = $request['division'];
$court = $request['court'];
Session::put('courtDivision', $div);
Session::put('court', $court);
return redirect('/variable/create');
}
}