| Server IP : 199.250.214.225 / Your IP : 18.119.116.184 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 App\Http\Controllers;
use Auth;
use Carbon\Carbon;
use Entrust;
use Session;
use Excel;
use Input;
use DB;
use QrCode;
class VoteChangeController extends functionController
{
public function __construct(Request $request)
{
$this->activeMonth = $request->session()->get('activeMonth');
$this->activeYear = $request->session()->get('activeYear');
}
public function ecoChange(Request $request, $contractID = null)
{
Session::forget('contractID');
//Session::forget('currentDivisionID');
if(!DB::table('tblcontractDetails')->where('ID', '=', $contractID )->first()){
return redirect('voucherDisplay/displayVoucher')->with('err', 'Voucher not found !!!');
}
$data['economicsource'] = trim($request['economicsource']);
$data['economicdest'] = trim($request['economicdest']);
$data['economicGroup'] = trim($request['economicGroup']);
if($data['economicGroup']=='') {$data['economicGroup']=session('economicGroup');}
$data['contractinfo']=DB::table('tblcontractDetails')
->select('tblcontractDetails.*', 'tblcontractor.contractor','tbleconomicCode.economicCode','tbleconomicCode.description')
->where('tblcontractDetails.ID', '=', $contractID )
->Join('tblcontractor','tblcontractor.id','=','tblcontractDetails.companyID')
->leftJoin('tbleconomicCode','tbleconomicCode.ID','=','tblcontractDetails.economicVoult')
->first();
//dd($data['contractinfo']);
$data['contractcomments']=DB::table('tblcomments')
->select('tblcomments.*', 'users.name')
->Join('users','users.username','=','tblcomments.username')->where('affectedID', '=', $contractID )->get();
$data['precontractcomments']=DB::table('contract_comment')
->select('contract_comment.*', 'users.name')
->Join('users','users.id','=','contract_comment.userID')->where('fileNoID', '=', $data['contractinfo']->fileNo)
->where('fileNoID', '<>', '')->get();
$data['fileattach']=$this->ContractAttachment($contractID);
if ( isset( $_POST['update'] ) ) {
$this->validate($request, [
'economicsource' => 'required'
]);
if( DB::table('tblpaymentTransaction')->where('contractID',$contractID)->where('vstage',1)->update([
'economicCodeID' => $data['economicsource'],
'allocationType' => $data['economicGroup'],
]))
{
DB::table('tblcontractDetails')->where('ID',$contractID)->update([
'economicVoult' => $data['economicsource'],
'contract_Type' => $data['economicGroup'],
]);
}
return back()->with('message','record successfully updated.' );
}
$data['EconomicCode'] = $this->EconomicCode2('5',$data['economicGroup']);
$data['EconomicGroup'] = $this->BudgetType();
return view('Report.changeecoid', $data);
}
}//End class