| Server IP : 199.250.214.225 / Your IP : 18.117.100.157 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 InactiveStaffController extends ParentController
{
public function __construct(Request $request)
{
$this->divisionID = $request->session()->get('divisionID');
}
public function loadView()
{
return view('inactiveStaff.inactiveStaff');
}
public function loadReport(Request $request)
{
$this->validate($request,
[
'staffStatus' => 'required|string',
]);
$staffStatus = trim($request['staffStatus']);
$data['staffStatus'] = DB::select('select p.fileNo, p.title, p.surname, p.first_name, p.othernames, p.rank, p.grade, p.step, p.bankID, b.bank, p.bankGroup from tblper p join tblbanklist b on b.bankID = p.bankID and p.status_value ="'. $staffStatus .'"
and p.divisionID ="'.$this->divisionID . '" and p.employee_type <> \'CONSOLIDATED\' order by p.bankGroup, p.fileNo ASC');
if(!($data['staffStatus']))
{
return back()->with('message', 'Record not found!');
}
else
{
//total
$totalStatus = 0.0;
foreach ($data['staffStatus'] as $row)
{
$totalStatus += 1;
}//end foreach
$data['totalStatus'] = $totalStatus;
$data['reportHeader'] = $staffStatus;
return view('inactiveStaff.report', $data);
}
return back()->with('message', 'Empty field selected!');
}
}