| Server IP : 199.250.214.225 / Your IP : 3.145.8.202 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 Illuminate\Support\Facades\Log;
use Illuminate\Http\Request;
use App\Http\Requests;
use DB;
use Session;
class functions22Controller extends Controller{
public function getCourts()
{
$list = DB::table('tbl_court')->get();
return $list;
}
public function getCourtDivision( $courtid )
{
$list = DB::table('tbldivision')->where('courtID', $courtid)->get();
return $list;
}
public function getStaffinDivision( $court, $divisionid )
{
$list = DB::table('tblper')->where('courtID', $court)->where('divisionID', $divisionid)->get();
return $list;
}
public function getDesc()
{
$list = DB::table('tblcvSetup')->where('status', 1)->get();
return $list;
}
public function getTableContent( $fileNo, $court, $division )
{
if($fileNo !== ""){
$list = DB::table('tblstaffCV')
->where('fileNo', $fileNo)
->where('courtID', $court)
->where('divisionID', $division)
->leftjoin('tblcvSetup', 'tblcvSetup.ID', '=', 'tblstaffCV.cvID')
->select('tblcvSetup.description', 'tblstaffCV.*')
->get();
return $list;
} else {
return [];
}
}
public function getStaffInfo($fileNo)
{
$dataval=DB::table('tblper')->where('fileNo', $fileNo)->first();
if($dataval){
return $dataval;
} else {
$val = DB::SELECT("select '' as 'first_name', '' as 'surname', ''as 'othernames'");
return $val[0];
}
}
public function checker($court, $division, $fileno)
{
$res = DB::table('tblper')
->where('courtID', $court)
->where('divisionID', $division)
->where('fileNo', $fileno)
->get();
if($res !== null){
return true;
} else {
return false;
}
}
public function deleteControlVariable( $id ){
return (DB::table('tblstaffCV')->where('ID', '=', $id)->delete());
}
public function editControlVariable( $id, $amount ){
return DB::table('tblstaffCV')->where('ID', '=', $id)->update(['amount' => $amount]);
}
public function getEarningDeductionTableContent($court, $division, $status)
{
if(!empty($court) && !empty($division)){
if($status == 'All'){
$list = DB::table('tblstaffEarningDeduction')
->where('tblstaffEarningDeduction.courtID', $court)
->where('tblstaffEarningDeduction.divisionID', $division)
->leftjoin('tblearningDeductions', 'tblstaffEarningDeduction.earningDeductionID', '=', 'tblearningDeductions.ID')
->leftjoin('tblper', 'tblstaffEarningDeduction.fileNo', '=', 'tblper.fileNo')
->select('tblearningDeductions.description', 'tblstaffEarningDeduction.*', 'tblper.fileNo', 'tblper.surname', 'tblper.first_name', 'tblper.othernames')
->orderBy('status', 'asc')
->get();
//dd($list);
return $list;
} else{
$list = DB::table('tblstaffEarningDeduction')
->where('tblstaffEarningDeduction.courtID', $court)
->where('tblstaffEarningDeduction.divisionID', $division)
->where('tblstaffEarningDeduction.status', '=', $status)
->leftjoin('tblearningDeductions', 'tblstaffEarningDeduction.earningDeductionID', '=', 'tblearningDeductions.ID')
->leftjoin('tblper', 'tblstaffEarningDeduction.fileNo', '=', 'tblper.fileNo')
->select('tblearningDeductions.description', 'tblstaffEarningDeduction.*', 'tblper.fileNo', 'tblper.surname', 'tblper.first_name', 'tblper.othernames')
->orderBy('status', 'asc')
->get();
//dd($list);
return $list;
}
} else {
return [];
}
}
public function updateEarningDeduction($fileno, $status, $user)
{
$timeofaction = date('Y-m-d H:i:s');
DB::UPDATE("UPDATE tblstaffEarningDeduction SET `status` = '$status', `approvedBy` = '$user', `actionDate` = '$timeofaction' WHERE `ID` = '$fileno'");
}
public function getEarningDeductionSum($fileNo, $year, $month)
{
$res = DB::table('tblstaffEarningDeduction')
->where('fileNo', '=', $fileNo)
->where('month', '=', $month)
->where('year', '=', $year)
->where('year', '<>', 0)
->where('year', '<>', '')
->leftjoin('tblearningDeductions', 'tblstaffEarningDeduction.earningDeductionID', '=', 'tblearningDeductions.ID')
->select('tblearningDeductions.description', 'tblearningDeductions.particularID', 'tblstaffEarningDeduction.*')
->get();
return $res;
}
public function getStaffControlVariableSum($fileNo, $year, $month)
{
$res = DB::table('tblotherEarningDeduction')
->where('fileNo', '=', $fileNo)
->where('month', '=', $month)
->where('year', '=', $year)
->where('year', '<>', 0)
->where('year', '<>', '')
->leftjoin('tblcvSetup', 'tblotherEarningDeduction.CVID', '=', 'tblcvSetup.ID')
->select('tblcvSetup.description', 'tblcvSetup.particularID', 'tblotherEarningDeduction.*')
->get();
return $res;
}
public function getEarningDeductionList()
{
$res = DB::table('tblcvSetup')
->where('status', '=', 1)
->get();
return $res;
}
public function MonthlyEarningDeductionReportDetails($court, $division, $type, $year, $month)
{
//dd($court,$division,$type,$year,$month);
$res = DB::table('tblotherEarningDeduction')
->where('tblotherEarningDeduction.courtID', '=', $court)
->where('tblotherEarningDeduction.divisionID', '=', $division)
->where('CVID', '=', $type)
->where('year', '=', $year)
->where('month', '=', $month)
->leftjoin('tblper', 'tblotherEarningDeduction.fileNo', '=', 'tblper.fileNo')
->orderBy('particularID', 'asc')
->select('tblper.fileNo', 'tblper.first_name', 'tblper.surname', 'tblper.othernames', 'tblotherEarningDeduction.*')
->get();
return $res;
}
public function MonthlyEarningDeductionSummary($court, $division, $type, $year, $month)
{
$res = DB::table('tblotherEarningDeduction')
->where('tblotherEarningDeduction.courtID', '=', $court)
->where('tblotherEarningDeduction.divisionID', '=', $division)
->where('tblotherEarningDeduction.particularID', '=', $type)
->where('tblotherEarningDeduction.year', '=', $year)
->where('tblotherEarningDeduction.month', '=', $month)
->leftjoin('tblcvSetup', 'tblotherEarningDeduction.CVID', '=', 'tblcvSetup.ID')
->select('tblotherEarningDeduction.*', 'tblcvSetup.description')
->get();
return $res;
}
public function getInfo($fileno, $clause, $table)
{
$res = DB::table($table)
->where($clause, '=', $fileno)
->first();
return $res;
}
public function getEarningDeductionList2()
{
$res = DB::table('tblearningDeductions')
->where('status', '=', 1)
->get();
return $res;
}
public function OccasionalEarningDeductionReportDetails($court, $division, $type, $year, $month)
{
//dd($court, $division, $type, $year, $month);
$res = DB::table('tblstaffEarningDeduction')
->where('tblstaffEarningDeduction.courtID', '=', $court)
->where('tblstaffEarningDeduction.divisionID', '=', $division)
->where('tblstaffEarningDeduction.earningDeductionID', '=', $type)
->where('year', '=', $year)
->where('month', '=', $month)
->where('tblstaffEarningDeduction.year', '<>', "")
->where('tblstaffEarningDeduction.month', '<>', "")
->leftjoin('tblearningDeductions', 'tblstaffEarningDeduction.earningDeductionID', '=', 'tblearningDeductions.ID')
->leftjoin('tblper', 'tblstaffEarningDeduction.fileNo', '=', 'tblper.fileNo')
->orderBy('particularID', 'asc')
->select('tblper.fileNo', 'tblper.first_name', 'tblper.surname', 'tblper.othernames', 'tblstaffEarningDeduction.*', 'tblearningDeductions.description')
->get();
//dd($res);
return $res;
}
public function OccasionalEarningDeductionSummary($court, $division, $type, $year, $month)
{
//dd($court, $division, $type, $year, $month);
$res = DB::table('tblstaffEarningDeduction')
->where('tblstaffEarningDeduction.courtID', '=', $court)
->where('tblstaffEarningDeduction.divisionID', '=', $division)
->where('tblearningDeductions.particularID', '=', $type)
->where('tblstaffEarningDeduction.year', '=', $year)
->where('tblstaffEarningDeduction.month', '=', $month)
->where('tblstaffEarningDeduction.year', '<>', "")
->where('tblstaffEarningDeduction.month', '<>', "")
->leftjoin('tblearningDeductions', 'tblstaffEarningDeduction.earningDeductionID', '=', 'tblearningDeductions.ID')
->select('tblstaffEarningDeduction.*', 'tblearningDeductions.description')
->get();
return $res;
}
public function checkWeekends($d, $end, $value = 0)
{
if($d != $end){
$date = date("l", $d);
if($date === 'Sunday' || $date === "Saturday"){
return $this->checkWeekends($d+86400, $end, $value);
} else {
$value = $value + 1;
return $this->checkWeekends($d+86400, $end, $value);
}
} else {
return $value;
}
}
public function checkReturnDay($duech, $due)
{
if($duech == "Sunday" || $duech == "Saturday")
{
$due = $due+86400+86400;
$duech = date("l", $due);
return $this->checkReturnDay($duech, $due);
} else {
return $due;
}
}
public function getRealTableContent($fileNo, $type)
{
if($type == ""){
$res = DB::table('tblTourSlashLeave')
->where('fileNo', $fileNo)
->where('fileNo', '<>', "")
->get();
return $res;
} else {
$res = DB::table('tblTourSlashLeave')
->where('fileNo', $fileNo)
->where('fileNo', '<>', "")
->where('type', $type)
->where('type', '<>', "")
->get();
return $res;
}
}
}