| Server IP : 199.250.214.225 / Your IP : 18.221.86.138 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;
class NextOfKinController extends ParentController
{
public function __construct(Request $request)
{
$this->division = $request->session()->get('division');
$this->divisionID = $request->session()->get('divisionID');
}
public function index($fileNo = Null, $kinID = Null)
{
//check if parameters are Null
if(is_null($fileNo)){
return redirect('/profile/details/'.$fileNo);
}
//not exist, Add new
if(!(DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->first())){
//set session
Session::put('fileNo', $fileNo); //put
$fileNo = Session::get('fileNo'); //get
$getStaff = DB::table('tblper')->where('fileNo', '=', $fileNo)->first();
$data['nextOfKin'] = '';
$data['KinList'] = '';
$data['fileNoCallBack'] = Session::get('fileNo');
$data['getStaff'] = $getStaff;
return view('nextOfKin.update', $data);
}else{
//set session
Session::put('fileNo', $fileNo);
$fileNo = Session::get('fileNo');
$getStaff = DB::table('tblper')->where('fileNo', '=', $fileNo)->first();
if(is_null($kinID)){
$data['nextOfKin'] = "";
}else{
//check if kinID parameters exist in DB
if(!(DB::table('tblnextofkin')->where('kinID', '=', $kinID)->first())){
return redirect('/profile/details/'.$fileNo);
}
$data['nextOfKin'] = DB::table('tblnextofkin')->where('fileNo','=',$fileNo)->where('kinID','=',$kinID)->first();
}
$data['KinList'] = DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->get();
$data['fileNoCallBack'] = Session::get('fileNo');
$data['getStaff'] = $getStaff;
return view('nextOfKin.update', $data);
}
}
public function view($kinID = Null)
{
$fileNo = Session::get('fileNo'); //get
$getStaff = DB::table('tblper')->where('fileNo', '=', $fileNo)->first();
if(!(DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->where('kinID', '=', $kinID)->first())){
$data['nextOfKin'] = '';
$data['KinList'] = '';
$data['fileNoCallBack'] = Session::get('fileNo');
$data['getStaff'] = $getStaff;
return view('nextOfKin.update', $data);
}else{
$data['nextOfKin'] = DB::table('tblnextofkin')->where('fileNo', $fileNo)->where('kinID', $kinID)->first();
$data['KinList'] = DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->get();
$data['fileNoCallBack'] = Session::get('fileNo');
$data['getStaff'] = $getStaff;
return view('nextOfKin.update', $data);
}
}
public function delete($fileNo = Null, $kinID = Null)
{
$fileNo = Session::get('fileNo');
$getStaff = DB::table('tblper')->where('fileNo', '=', $fileNo)->first();
if(is_null($fileNo) || is_null($kinID)){
$data['nextOfKin'] = DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->first();
$data['KinList'] = DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->get();
$data['fileNoCallBack'] = Session::get('fileNo');
$data['getStaff'] = $getStaff;
return view('nextOfKin.update', $data);
}
//delete
DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->where('kinID', '=', $kinID)->delete();
$this->addLog('Next of Kin deleted and division: ' . $this->division);
//check if parameters exist in DB
if(!(DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->first())){
return redirect('/profile/details/'.$fileNo);
}
//populate return view('main.userArea');
//$data['nextOfKin'] = DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->first();
$data['KinList'] = DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->get();
$data['nextOfKin'] = "";
$data['fileNoCallBack'] = Session::get('fileNo');
$data['getStaff'] = $getStaff;
return view('nextOfKin.update', $data)->with('msg', 'Operation was done successfully.');;
}
public function store(Request $request)
{
$fileNo = Session::get('fileNo');
$this->validate($request,
[
'fullName' => 'required|regex:/^[A-Za-z0-9\-! ,\'\"\/@\.:\(\)]+$/|unique:tblnextofkin,fullname',
'relationship' => 'required|regex:/^[\pL\s\-]+$/u',
'address' => 'required|string',
'phoneNumber' => 'numeric',
]);
$fullName = trim($request['fullName']);
$relationship = trim($request['relationship']);
$address = trim($request['address']);
$phoneNumber = trim($request['phoneNumber']);
$date = date("Y-m-d");
DB::table('tblnextofkin')->insert(array(
'fileNo' => $fileNo,
'fullname' => $fullName,
'relationship' => $relationship,
'address' => $address,
'phoneno' => $phoneNumber,
'updated_at' => $date
));
$this->addLog('New Next of Kin was added and division: ' . $this->division);
$data['nextOfKin'] = DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->first();
$data['KinList'] = DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->get();
$data['fileNoCallBack'] = Session::get('fileNo');
$data['getStaff'] = $getStaff;
return view('nextOfKin.update', $data);
}
public function update(Request $request)
{
$fileNo = Session::get('fileNo');
if(is_null($fileNo)){
return redirect('/profile/details/'.$fileNo);
}
$this->validate($request,
[
'fullName' => 'required|regex:/^[A-Za-z0-9\-! ,\'\"\/@\.:\(\)]+$/',
'relationship' => 'required|regex:/^[\pL\s\-]+$/u',
'address' => 'required|string',
'phoneNumber' => 'numeric',
]);
$fullName = trim($request['fullName']);
$relationship = trim($request['relationship']);
$address = trim($request['address']);
$phoneNumber = trim($request['phoneNumber']);
$kinID = trim($request['kinID']);
$hiddenName = trim($request['hiddenName']);
$date = date("Y-m-d");
//dd($hiddenName);
//check if user can still add more next of kin to list and return with list
$KinList = DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->get();
if((count($KinList) >= 2) && ($hiddenName == "")){
return redirect('/update/next-of-kin/'.$fileNo)->with('err', 'You are allow to add only two (2) next of kin details to your profile.');
}
//Update if hidden Name not empty
if($hiddenName <> ""){
DB::table('tblnextofkin')->where('kinID', '=', $kinID)->where('fileNo', '=', $fileNo)->update(array(
//'fileNo' => $fileNo,
'fullname' => $fullName,
'relationship' => $relationship,
'address' => $address,
'phoneno' => $phoneNumber,
'updated_at' => $date
));
$this->addLog('Next of Kin was updated with ID: '.$kinID .' and division: ' . $this->division);
}else{
//insert if hidden Name is empty
DB::table('tblnextofkin')->insert(array(
'fileNo' => $fileNo,
'fullname' => $fullName,
'relationship' => $relationship,
'address' => $address,
'phoneno' => $phoneNumber,
'updated_at' => $date
));
$this->addLog('New Next of Kin was added and division: ' . $this->division);
}
//$data['nextOfKin'] = DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->first();
$data['nextOfKin'] = "";
$data['KinList'] = DB::table('tblnextofkin')->where('fileNo', '=', $fileNo)->get();
$data['fileNoCallBack'] = Session::get('fileNo');
return redirect('/update/next-of-kin/'.$fileNo)->with('msg', 'Operation was done successfully.');
}
//Next of Kin 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['staffFullDetailsNextKin'] = DB::table('tblnextofkin')
->where('fileNo', '=', $fileNo)
->orderBy('kinID', '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.NextKinReport', $data);
}
}