| Server IP : 199.250.214.225 / Your IP : 3.147.7.248 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 StaffPensionController extends ParentController
{
/**
* Create a new controller instance.
*
* @return void
*/
/**
* Show the application dashboard.
*
* @return \Illuminate\Http\Response
*/
//public $division;
public function __construct(Request $request)
{
$this->middleware('auth');
}
public function index()
{
$data['allbanklist'] = DB::table('tblbanklist')->get();
$data['staffpension']= "";
$data['month'] = "";
$data['year'] = "";
$data['message'] = "";
$data['errormessage'] = "";
return view('staffpension.index',$data);
}
public function Calculate(Request $request)
{
$data['staffpension']= "";
$data['message'] = "";
$data['errormessage'] = "";
$month = trim($request->input('month'));
$year = trim($request->input('year'));
$date = date('Y-m-d');
$data['month'] = $request->input('month');
$data['year'] = $request->input('year');
$this->validate($request,[
'month' => 'required|regex:/^[\pL\s\-]+$/u',
'year' => 'required|integer',
]);
//salary sum
$data['staffpension'] = DB::connection('npaydb')->table('tblpayment')
->where('tblpayment.month', '=', $month)
->where('tblpayment.year', '=', $year)
->leftjoin('tblper','tblper.fileNo','=','tblpayment.fileNo')
->orderby('tblper.fileNo','asc')
->get();
$data['message'] = 'Query successfull';
//$data['errormessage'] = 'Query unsuccessfull';
return view('staffpension.index',$data);
}
}