| Server IP : 199.250.214.225 / Your IP : 3.143.255.169 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 Session;
use Illuminate\Http\Request;
use App\Http\Requests;
use App\Http\Controllers;
use Auth;
use DB;
use DateTime;
class TourLeaveRecordController extends ParentController
{
public function __construct(Request $request)
{
$this->division = $request->session()->get('division');
$this->divisionID = $request->session()->get('divisionID');
}
public function index($fileNo = Null, $tourLeaveID = Null)
{
if(is_null($fileNo)){
return view('main.userArea');
}
$data['names'] = DB::table('tblper')->where('fileNo', '=', $fileNo)->first();
if(!(DB::table('tourleave_record')->where('fileNo', '=', $fileNo)->first())){
//set session
Session::put('fileNo', $fileNo);
$data['tour'] = '';
$data['tourleaveList'] = '';
return view('tourLeaveRecord.update', $data);
}
else{
//set session
Session::put('fileNo', $fileNo);
if(is_null($tourLeaveID)){
$data['tour'] = "";
}
else{
//check if tour and leave id parameters exist in DB
if(!(DB::table('tourleave_record')->where('tourLeaveID', '=', $tourLeaveID)->first())){
return view('main.userArea');
}
$data['tour'] = DB::table('tourleave_record')->where('fileNo','=',$fileNo)->where('tourLeaveID','=',$tourLeaveID)->first();
}
$data['tourleaveList'] = DB::table('tourleave_record')->where('fileNo', '=', $fileNo)->get();
//
return view('tourLeaveRecord.update', $data);
}
}
public function update(Request $request)
{
$userID = Session::get('fileNo');
if(is_null($userID)){
return view('main.userArea');
}
$this->validate($request,
[
'tourstartdate' => 'required|date',
'tourgazette' => 'regex:/^[A-Za-z0-9\-\s]+$/',
'tourlength' => 'required|regex:/^[A-Za-z0-9\-\s]+$/',
'leaveduedate' => 'date',
'leavedepartdate' => 'date',
'leavegezettenum' => 'regex:/^[A-Za-z0-9\-\s]+$/',
'leavereturndate' => 'required|date',
'dateextgranted' => 'required|date',
'salaryrule' => 'regex:/^[A-Za-z0-9\-! ,\'\"\/@\.:\(\)]+$/',
'fromuk' => 'regex:/^[A-Za-z0-9\-! ,\'\"\/@\.:\(\)]+$/',
'touk' => 'regex:/^[A-Za-z0-9\-! ,\'\"\/@\.:\(\)]+$/',
'residentmonths' => 'numeric',
'residentdays' => 'numeric',
'dateresume' => 'required|date',
]);
$tourstartdate = date('Y-m-d', strtotime(trim($request['tourstartdate'])));
$tourgazette = trim($request['tourgazette']);
$tourlength = trim($request['tourlength']);
$leaveduedate = date('Y-m-d', strtotime(trim($request['leaveduedate'])));
$leavedepartdate = date('Y-m-d', strtotime(trim($request['leavedepartdate'])));
$leavegezettenum = trim($request['leavegezettenum']);
$leavereturndate = date('Y-m-d', strtotime(trim($request['leavereturndate'])));
$dateextgranted = date('Y-m-d', strtotime(trim($request['dateextgranted'])));
$salaryrule = trim($request['salaryrule']);
$fromuk = trim($request['fromuk']);
$touk = trim($request['touk']);
$residentmonths = trim($request['residentmonths']);
$residentdays = trim($request['residentdays']);
$dateresume = date('Y-m-d', strtotime(trim($request['dateresume'])));
//calculate number of months for leave
$startleave1 = new DateTime($leaveduedate);
$startleave2 = new DateTime($leavereturndate);
$interval = $startleave2->diff($startleave1);
$leavemonths = (($interval->format('%y') * 12) + $interval->format('%m'));
//calculate number of days for Leave
$datediff = strtotime($leavereturndate) - strtotime($leaveduedate);
$leavedays = floor($datediff / (60 * 60 * 24));
$date = date("Y-m-d");
$tourLeaveID = trim($request['tourLeaveID']);
$hiddenName = trim($request['hiddenName']);
if($hiddenName <> ""){
DB::table('tourleave_record')->where('tourLeaveID', '=', $tourLeaveID)->where('fileNo', '=', $userID)->update(array(
'fileNo' => $userID,
'dateTourStarted' => $tourstartdate,
'tourGezetteNumber' => $tourgazette,
'lengthOfTour' => $tourlength,
'leaveDueDate' => $leaveduedate,
'leaveDepartDate' => $leavedepartdate,
'leaveGezetteNumber' => $leavegezettenum,
'leaveReturnDate' => $leavereturndate,
'dateExtensionGranted' => $dateextgranted,
'salaryRuleForExt' => $salaryrule,
'toUK' => $touk,
'fromUK' => $fromuk,
'residentMonths' => $residentmonths,
'residentDays' => $residentdays,
'leaveMonths' => $leavemonths,
'leaveDays' => $leavedays,
'dateResumedDuty' => $dateresume,
'updated_at' => $date,
));
$this->addLog('Tour and Leave Record was updated with ID: '.$tourLeaveID .' and division: ' . $this->division);
}
else{
//insert if hidden Name is empty
DB::table('tourleave_record')->insert(array(
'fileNo' => $userID,
'dateTourStarted' => $tourstartdate,
'tourGezetteNumber' => $tourgazette,
'lengthOfTour' => $tourlength,
'leaveDueDate' => $leaveduedate,
'leaveDepartDate' => $leavedepartdate,
'leaveGezetteNumber' => $leavegezettenum,
'leaveReturnDate' => $leavereturndate,
'dateExtensionGranted' => $dateextgranted,
'salaryRuleForExt' => $salaryrule,
'toUK' => $touk,
'fromUK' => $fromuk,
'residentMonths' => $residentmonths,
'residentDays' => $residentdays,
'leaveMonths' => $leavemonths,
'leaveDays' => $leavedays,
'dateResumedDuty' => $dateresume,
'updated_at' => $date,
));
$this->addLog('New Tour and Leave Record was added and division: ' . $this->division);
}
$data['tour'] = "";
$data['tourleaveList'] = DB::table('tourleave_record')->where('fileNo', '=', $userID)->get();
return redirect('/update/tour-leave-record/'.$userID)->with('msg', 'Operation was done successfully.');
}
public function destroy($userId,$tourLeaveID)
{
$userID = Session::get('userId');
if(is_null($userID) || is_null($tourLeaveID)){
$data['tour'] = DB::table('tourleave_record')->where('userId', '=', $userID)->first();
$data['tourleaveList'] = DB::table('tourleave_record')->where('userId', '=', $userID)->get();
return view('tourLeaveRecord.update', $data);
}
//delete
DB::table('tourleave_record')->where('userId', '=', $userID)->where('tourLeaveID', '=', $tourLeaveID)->delete();
$this->addLog('One Language was deleted and division: ' . $this->division);
//check if parameters exist in DB
if(!(DB::table('tourleave_record')->where('userId', '=', $userID)->first())){
return view('main.userArea');
}
//populate return view('main.userArea');
$data['tourleaveList'] = DB::table('tourleave_record')->where('userId', '=', $userID)->get();
$data['tour'] = "";
return view('tourLeaveRecord.update', $data)->with('msg', 'Operation was done successfully.');
}
//Tour and Leave Report
public function report($fileNo = null)
{
if(is_null($fileNo)){
return redirect('profile/details');
}
if( !(DB::table('tblper')->where('fileNo', '=', $fileNo)->first())){
return redirect('profile/details');
}else{
$data['staffFullDetailsTerminationService'] = DB::table('tourleave_record')
->where('fileNo', '=', $fileNo)
->orderBy('tourLeaveID', 'Desc')
->get();
$data['staffFullDetails'] = DB::table('tblper')
->join('tbldivision', 'tbldivision.divisionID', '=', 'tblper.divisionID')
->join('tblbanklist', 'tblbanklist.bankID', '=', 'tblper.bankID')
->where('tblper.fileNo', '=', $fileNo)
->first();
}
return view('Report.TourLeaveReport', $data);
}
}