ÿØÿà JFIF ÿá Exif MM * ÿÛ C
Server IP : 199.250.214.225 / Your IP : 18.188.143.70 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 CommentDisplayController extends BasefunctionController { public function __construct(Request $request) { //$this->activeMonth = $request->Session()->get('activeMonth'); //$this->activeYear = $request->Session()->get('activeYear'); } public function viewComment($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['contractinfo']=DB::table('tblcontractDetails') ->select('tblcontractDetails.*', 'tblcontractor.contractor') ->where('tblcontractDetails.ID', '=', $contractID ) ->Join('tblcontractor','tblcontractor.id','=','tblcontractDetails.companyID') ->first(); $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(); //dd($data['contractcomments']); $data['fileattach']=$this->ContractAttachment($contractID); //dd($data['fileattach']); return view('Report.comments', $data); } }//End class