| Server IP : 199.250.214.225 / Your IP : 18.221.238.234 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 App\Http\Requests;
use DB;
use Session;
class CPOController extends BasefunctionController
{
public function index()
{
//
}
Public function NewBatchNo(){
$myData= DB::Select("SELECT max(`batch`) as BTN FROM `tblepayment`");
//return $myData[0]->BTN;
if($myData[0]->BTN ==''){
return 'BTN00000001';
}
$BTN1 =$myData[0]->BTN;
$arr = explode("BTN", $BTN1);
$newcode=$arr[1]+1;
while(strlen($newcode)<8)
{
$newcode="0".$newcode;
}
return 'BTN'.$newcode;
}
public function batchNo()
{
$row = DB::table('tblepayment')->orderBy('batch', 'desc')->first();
$clent=5;
if($row){
$data = $row->batch;
$intc=strlen($data);
$data=substr($data, $clent, ($intc-$clent));
$count=$data+1;
}
else{$count=1;}
$tempdata="EP";
$newcode=$tempdata.$count;
$totalLength = 7;
while(strlen($newcode)<$totalLength)
{$tempdata=$tempdata."0";
$newcode=$tempdata.$count;}
return $newcode;
}
public function auditVouchers()
{
$data['company'] = DB::table('tblcompany')->first();
$data['audited'] = DB::table('tblpaymentTransaction')
->join('tblcontractor','tblcontractor.id','=','tblpaymentTransaction.companyID')
->join('tblcontractType','tblcontractType.id','=','tblpaymentTransaction.contractTypeID')
->leftJoin('tblbanklist','tblcontractor.Banker','=','tblbanklist.bankID')
->where('tblpaymentTransaction.auditStatus', '=',1)
->where('tblpaymentTransaction.cpo_payment', '=',0)
->select('*', 'tblpaymentTransaction.ID as transID')
->get();
//dd($data['audited']);
return view('cpo/displayReport',$data);
}
public function updateSelected(Request $request)
{
$ch = $request['checkname'];
$id = $request['id'];
if($ch == '')
{
return back()->with('err','Please, Select at least one item');
}
foreach ($ch as $key=>$value) {
DB::table('tblpaymentTransaction')
->where('ID','=',$ch[$key])
->update(array(
'cpo_payment' =>1,
'cpo_payment_date' => date('Y-m-d'),
));
}
return redirect('/cpo/generated');
}
public function payGenerated(Request $request)
{
$data['company'] = DB::table('tblcompany')->first();
$data['audited'] = DB::table('tblpaymentTransaction')
->join('tblcontractor','tblcontractor.id','=','tblpaymentTransaction.companyID')
->leftJoin('tblbanklist','tblcontractor.Banker','=','tblbanklist.bankID')
->where('auditStatus', '=',1)
->where('cpo_payment', '=',1)
->where('pay_confirmation', '=',0)
->select('*', 'tblpaymentTransaction.ID as transID')
->get();
return view('cpo/payGenerated',$data);
}
public function payRestore()
{
$data['company'] = DB::table('tblcompany')->first();
$data['audited'] = DB::table('tblpaymentTransaction')
->join('tblcontractor','tblcontractor.id','=','tblpaymentTransaction.companyID')
->join('tblbanklist','tblcontractor.Banker','=','tblbanklist.bankID')
->where('tblpaymentTransaction.auditStatus', '=',1)
->where('tblpaymentTransaction.cpo_payment', '=',1)
->where('tblpaymentTransaction.mandate_status', '=',0)
//->where('tblpaymentTransaction.pay_confirmation', '=',0)
->where(function ($query) {
$query->where('tblpaymentTransaction.pay_confirmation', '=', 0)
->orWhere('tblpaymentTransaction.pay_confirmation', '=', 1);
})
//->orWhere('tblpaymentTransaction.pay_confirmation', '=',1)
->select('*', 'tblpaymentTransaction.ID as transID')
->get();
return view('cpo/payRestore',$data);
}
public function postRestore(Request $request)
{
$btn = $request['submit'];
if($btn == 'Restore')
{
$ch = $request['checkname'];
if($ch == '')
{
return back()->with('err','Please, Select at least one item');
}
foreach ($ch as $key=>$value) {
DB::table('tblpaymentTransaction')
->where('ID','=',$ch[$key])
->update(array(
'cpo_payment' =>0,
'cpo_payment_date' => date('Y-m-d'),
));
}
return redirect('/cpo/restore');
}
elseif ($btn == 'Confirm') {
$ch = $request['checkname'];
if($ch == '')
{
return back()->with('err','Please, Select at least one item');
}
foreach ($ch as $key=>$value) {
DB::table('tblpaymentTransaction')
->where('ID','=',$ch[$key])
->update(array(
'pay_confirmation' => 1,
));
}
$batch1=$this->NewBatchNo();
foreach ($ch as $key=>$value) {
$count = DB::table('tblvoucherBeneficiary')
->join('tblbanklist','tblbanklist.bankID','=','tblvoucherBeneficiary.bankID')
->where('voucherID', '=',$ch[$key])
->count();
if($count >=1)
{
$staff = DB::table('tblvoucherBeneficiary')
->join('tblbanklist','tblbanklist.bankID','=','tblvoucherBeneficiary.bankID')
->where('voucherID', '=',$ch[$key])
->get();
foreach ($staff as $list) {
DB::table('tblepayment')
->insert(array(
'transactionID' => $list->voucherID,
'contractor' => $list->beneficiaryDetails,
'amount' => $list->amount,
'accountNo' => $list->accountNo,
'bank' => $list->bank,
'date' => date('Y-m-d'),
'batch' => $batch1,
));
}
}
else
{
DB::table('tblepayment')
->insert(array(
'transactionID' => $ch[$key],
'contractor' => $request['contractor'][$key],
'amount' => $request['amount'][$key],
'accountNo' => $request['accountNo'][$key],
'bank' => $request['bank'][$key],
'date' => date('Y-m-d'),
'batch' => $batch1,
));
}
}
Session::put('batchNo', $batch1);
return redirect('/cpo/epayment');
}
}
public function staffVoucherList($id)
{
$data['staff'] = DB::table('tblvoucherBeneficiary')
->join('tblbanklist','tblbanklist.bankID','=','tblvoucherBeneficiary.bankID')
->where('voucherID', '=',$id)
->get();
return view('cpo/staffList', $data);
}
public function confirm(Request $request)
{
$ch = $request['checkname'];
$this->validate($request,
[
'vatSortCode' => 'required',
'whtSortCode' => 'required',
],
[
'vatSortCode.required' => 'VAT Payee Sort Code is Required. Please, set it up First',
'whtSortCode.required' => 'Tax Payee Sort Code is Required. Please, set it up First',
]
);
if($ch == '')
{
return back()->with('err','Please, Select at least one item');
}
foreach ($ch as $key=>$value) {
DB::table('tblpaymentTransaction')
->where('ID','=',$ch[$key])
->update(array(
'pay_confirmation' => 1,
'status' => 6,
));
}
$batch1=$this->NewBatchNo();
foreach ($ch as $key=>$value) {
$count = DB::table('tblvoucherBeneficiary')
->join('tblbanklist','tblbanklist.bankID','=','tblvoucherBeneficiary.bankID')
->where('voucherID', '=',$ch[$key])
->count();
if($count >=1)
{
$staff = DB::table('tblvoucherBeneficiary')
->join('tblbanklist','tblbanklist.bankID','=','tblvoucherBeneficiary.bankID')
->where('voucherID', '=',$ch[$key])
->get();
foreach ($staff as $list) {
DB::table('tblepayment')
->insert(array(
'transactionID' => $list->voucherID,
'contractor' => $list->beneficiaryDetails,
'amount' => $list->amount,
'accountNo' => $list->accountNo,
'bank' => $list->bank,
'date' => date('Y-m-d'),
'batch' => $batch1,
));
}
}
else
{
DB::table('tblepayment')
->insert(array(
'transactionID' => $ch[$key],
'contractor' => $request['contractor'][$key],
'amount' => $request['amount'][$key],
'accountNo' => $request['accountNo'][$key],
'bank' => $request['bank'][$key],
'date' => date('Y-m-d'),
'batch' => $batch1,
'VATValue' => $request['vatAmount'][$key],
'WHTValue' => $request['whtAmount'][$key],
'vat_bank' => $request['vatBank'][$key],
'vat_bank_branch' => $request['vatBranch'][$key],
'vat_accountNo' => $request['vatAccount'][$key],
'wht_bank' => $request['whtBank'][$key],
'wht_bank_branch' => $request['whtBranch'][$key],
'wht_accountNo' => $request['whtAccount'][$key],
'purpose' => $request['purpose'][$key],
'vat_payee' => $request['vatPayee'][$key],
'wht_payee' => $request['whtPayee'][$key],
'bank_branch' => $request['bankBranch'][$key],
));
}
}
Session::put('batchNo', $batch1);
return redirect('/cpo/epayment');
}
public function epayment()
{
$data['company'] = DB::table('tblcompany')->first();
$data['batch'] = DB::table('tblepayment')->groupBy('batch')->get();
if(session('batchNo') != '')
{
$data['mandate'] = DB::table('tblepayment')
->where('batch','=',session('batchNo'))
->get();
$data['sum'] = DB::table('tblepayment')
->where('batch', session('batchNo'))
->groupBy('batch')
->sum('amount');
$data['vatsum'] = DB::table('tblepayment')
->where('batch', session('batchNo'))
->groupBy('batch')
->sum('VATValue');
$data['whtsum'] = DB::table('tblepayment')
->where('batch', session('batchNo'))
->groupBy('batch')
->sum('WHTValue');
$data['trans'] = DB::table('tblpaymentTransaction')
->join('tblepayment','tblepayment.transactionID','=','tblpaymentTransaction.ID')
->where('tblepayment.batch','=',session('batchNo'))
->where('tblpaymentTransaction.pay_confirmation','=',1)
//->where('tblepayment.mandate_status','=',3)
->get();
$data['status'] = DB::table('tblepayment')
->where('batch','=', session('batchNo'))
->first();
//dd($data['status']);
return view('/cpo/mandate',$data);
}
else
{
$data['mandate'] = DB::select('select * from tblepayment where `date` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) group by batch');
$v= 0;
$w= 0;
$a = 0;
foreach ($data['mandate'] as $list)
{
$a += $list->amount;
$v += $list->VATValue;
$w += $list->WHTValue;
}
$data['sum'] = $a;
$data['vatsum'] = $v;
$data['whtsum'] = $w;
return view('/cpo/mandate',$data);
}
}
public function batch()
{
$data['company'] = DB::table('tblcompany')->first();
$data['audited'] = DB::select('select *, sum(`amount`) as sum,sum(`VATValue`) as vsum,sum(`WHTValue`) as wsum from tblepayment where `date` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) group by batch');
return view('/cpo/batch',$data);
}
public function postBatch(Request $request)
{
//$fromdate = date('Y-m-d', strtotime(trim($request['dateFrom'])));
//$todate = date('Y-m-d', strtotime(trim($request['dateTo'])));
$fromdate = $request['dateFrom'];
$todate = $request['dateTo'];
$batch = $request['batch'];
$data['batch'] = DB::table('tblepayment')->groupBy('batch')->get();
/*$data['audited'] = DB::table('tblepayment')
->where('batch','=',$batch)
->get();*/
if($fromdate !='')
{
Session::put('from', $fromdate);
}
Session::put('to', $todate);
if($fromdate == '')
{
$data['audited'] = DB::table('tblepayment')
->where('date', $todate)
->groupBy('batch')
->selectRaw('*, sum(amount) as sum')
->get();
return view('/cpo/batch',$data);
}
else
{
$data['audited'] = DB::table('tblepayment')
->whereBetween('date', [$fromdate, $todate])
->groupBy('batch')
->selectRaw('*, sum(amount) as sum')
->get();
return view('/cpo/batch',$data);
}
}
public function viewBatch($id)
{
$data['current_batch'] = $id;
$data['company'] = DB::table('tblcompany')->first();
$data['mandate'] = DB::table('tblepayment')
->where('batch', $id)
//->selectRaw('*,sum(amount) as amt,sum(VATValue) as vat,sum(WHTValue) as wht')
->get();
$data['status'] = DB::table('tblepayment')
->where('batch', $id)
->first();
$data['sum'] = DB::table('tblepayment')
->where('batch', $id)
->groupBy('batch')
->sum('amount');
$data['vatsum'] = DB::table('tblepayment')
->where('batch', $id)
->groupBy('batch')
->sum('VATValue');
$data['whtsum'] = DB::table('tblepayment')
->where('batch', $id)
->groupBy('batch')
->sum('WHTValue');
return view('cpo/mandate', $data);
}
public function cpoReject(Request $request)
{
$transid = $request['transid'];
$remark = $request['remark'];
$returnTo = $request['attension'];
$date = date('Y-m-d');
if($returnTo == 1)
{
$value = "liabilityStatus";
}
elseif($returnTo == 2)
{
$value = "checkStatus";
}
elseif($returnTo == 3)
{
$value = "auditStatus";
}
$id = DB::table('tblpaymentTransaction')->where('ID', '=',$transid )->first();
if($returnTo == 1 || $returnTo ==0)
{
$this->VotebookUpdate($id->economicCodeID,$transid,$remark,$id->totalPayment,$date,5,$id->period);
DB::table('tblpaymentTransaction')
->where('ID', '=',$transid )
->update(array(
'vstage' => $returnTo,
'returnstatus' => 1,
'liabilityStatus' => 0,
'checkbyStatus' => 0,
'auditStatus' => 0,
));
return redirect('/cpo/report')->with('msg','Successfully Reject');
}
else
{
if($returnTo == 2)
{
DB::table('tblpaymentTransaction')
->where('ID', '=',$transid )
->update(array(
'vstage' => $returnTo,
'returnstatus' => 1,
'checkbyStatus' => 0,
'auditStatus' => 0,
));
}
if($returnTo == 3)
{
DB::table('tblpaymentTransaction')
->where('ID', '=',$transid )
->update(array(
'vstage' => $returnTo,
'returnstatus' => 1,
'checkbyStatus' => 0,
));
}
return redirect('/cpo/report')->with('msg','Successfully Reject');
}
}
}