| Server IP : 199.250.214.225 / Your IP : 13.59.79.32 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\Http\Request;
//use Auth;
use App\Http\Requests;
use DB;
use Auth;
use Session;
class VoteManagement extends functionController
{
public function __construct()
{
$this->middleware('auth');
$this->username = Session::get('userName');
}//
public function LendingBorrow(Request $request)
{
$data['error'] = "";
$data['warning'] = "";
$data['success'] = "";
$data['economicsource'] = trim($request['economicsource']);
$data['economicdest'] = trim($request['economicdest']);
$data['amount'] = trim($request['amount']);
$data['remarks'] = trim($request['remarks']);
//if($this->AccessNotGranted("allocation/totalmonthly")){return redirect('/')->with('message','Sorry! You do not have permission to access this page!!');}
//$data['period'] =$request->input('period');//$request['period'];
//if($data['period']=='') {$data['period']=session('period');}
$data['economicGroup'] = trim($request['economicGroup']);
if($data['economicGroup']=='') {$data['economicGroup']=session('economicGroup');}
$data['amount'] =$request['amount'];
if ( isset( $_POST['update'] ) ) {
$this->validate($request, [
'economicsource' => 'required'
,'economicdest' => 'required'
,'remarks' => 'required'
,'amount' => 'required|numeric|between:0,9999999999999999.99'
]);
$period=$this->ActivePeriod();
$ecoid=$data['economicdest'];
$thisyearbudget= DB::Select("SELECT IFNULL(sum(`allocationValue`),0) as allocationValue FROM `tblbudget` WHERE `Period`='$period' and `economicCodeID`='$ecoid' and `AllocationStatus`=1")[0]->allocationValue;
// if(floor($this->AvailableBal($data['economicsource']))+floor($data['amount'])>floor($thisyearbudget)){$data['warning'] = "Record Not Updated! The target vote will exceed the year budget if allowed to borrow this amount";
// $data['EconomicCode'] = $this->EconomicCode2('5',$data['economicGroup']);
// $data['EconomicGroup'] = $this->BudgetType();
// return view('allocation.lendingborrow', $data);
// }
if(floor($this->AvailableBal($data['economicsource'])) < floor($data['amount']))
{$data['warning'] = "Insufficient Vote Balance!!! The Source vote does not have enough balance to fund the Target vote";
$data['EconomicCode'] = $this->EconomicCode2('5',$data['economicGroup']);
$data['EconomicGroup'] = $this->BudgetType();
return view('allocation.lendingborrow', $data);
}else{
DB::table('tbllendborrow')
->insert([
'eco_source' => $data['economicsource'],
'eco_destination' => $data['economicdest'],
'amount' => $data['amount'],
'remarks' => $data['remarks'],
'updated_by' => Auth::user()->id,
'period' => $this->ActivePeriod(),
]);
$data['success'] = "successfully updated";
Session::put('economicGroup', $data['economicGroup']);
return redirect()->back()->with('message', $data['success']);
}
}
$data['EconomicCode'] = $this->EconomicCode2('5',$data['economicGroup']);
$data['EconomicGroup'] = $this->BudgetType();
return view('allocation.lendingborrow', $data);
}
public function LendingBorrowReport(Request $request)
{
$data['error'] = "";
$data['warning'] = "";
$data['success'] = "";
$data['economicsource'] = trim($request['economicsource']);
$data['economicdest'] = trim($request['economicdest']);
$data['amount'] = trim($request['amount']);
//if($this->AccessNotGranted("allocation/totalmonthly")){return redirect('/')->with('message','Sorry! You do not have permission to access this page!!');}
//$data['period'] =$request->input('period');//$request['period'];
//if($data['period']=='') {$data['period']=session('period');}
$data['economicGroup'] = trim($request['economicGroup']);
if($data['economicGroup']=='') {$data['economicGroup']=session('economicGroup');}
$data['LendBorrowReport'] = $this->LendBorrowReport($data['economicsource']);
//dd($data['LendBorrowReport']);
$data['EconomicCode'] = $this->EconomicCode2('5',$data['economicGroup']);
$data['EconomicGroup'] = $this->BudgetType();
return view('allocation.lendingborrow_report', $data);
}
public function UnsettledLendingBorrowReport(Request $request)
{
$data['error'] = "";
$data['warning'] = "";
$data['success'] = "";
//$UnsettleFund=$this->UnsettleFund("1");
$data['status'] = trim($request['status']);
$data['creditid'] = trim($request['creditid']);
$data['debitid'] = trim($request['debitid']);
$data['amount'] = trim($request['amount']);
$data['economicGroup'] = trim($request['economicGroup']);
if($data['economicGroup']=='') {$data['economicGroup']=session('economicGroup');}
if ( isset( $_POST['save'] ) ) {
$this->validate($request, [
'debitid' => 'required'
,'creditid' => 'required'
//,'remarks' => 'required'
,'amount' => 'required|numeric|between:0,9999999999999999.99'
]);
$period=$this->ActivePeriod();
$ecoid=$data['debitid'];
$thisyearbudget= DB::Select("SELECT IFNULL(sum(`allocationValue`),0) as allocationValue FROM `tblbudget` WHERE `Period`='$period' and `economicCodeID`='$ecoid' and `AllocationStatus`=1")[0]->allocationValue;
if(floor($this->AvailableBal($data['debitid'])) < floor($data['amount']))
{$data['warning'] = "Insufficient Vote Balance!!! The Source vote does not have enough balance to fund the Target vote";
return redirect()->back()->with('message', $data['warning']);
}else{
//dd('Ready to go');
DB::table('tbllendborrow')
->insert([
'eco_source' => $data['debitid'],
'eco_destination' => $data['creditid'],
'amount' => $data['amount'],
'remarks' => "Refunds",
'updated_by' => Auth::user()->id,
'period' => $this->ActivePeriod(),
]);
$data['success'] = "successfully updated";
Session::put('economicGroup', $data['economicGroup']);
return redirect()->back()->with('message', $data['success']);
}
}
$data['EconomicGroup'] = $this->BudgetType();
$data['UnsettleFund'] =$this->UnsettleFund($data['economicGroup']);
//dd($data['UnsettleFund']);
return view('allocation.unsettledlendingborrow_report', $data);
}
}