| Server IP : 199.250.214.225 / Your IP : 3.144.116.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 App\Http\Controllers;
use DB;
class SearchUserController extends Controller
{
public function create()
{
return View('UserSearch.create');
}
public function autocomplete(Request $request)
{
$query = $request->input('query');
$search = DB::table('tblper')->where('surname', 'LIKE', '%'.$query.'%')->
orWhere('first_name', 'LIKE', '%'.$query.'%')->orWhere('fileNo', 'LIKE','%'.$query.'%')->take(15)->get();
$return_array = null;
foreach($search as $s)
{
$return_array[] = ["value"=>$s->surname.' '.$s->first_name.' - '.$s->fileNo, "data"=>$s->fileNo];
}
return response()->json(array("suggestions"=>$return_array));
}
public function retrieve(Request $request)
{
$term=$request->input('nameID');
$data = DB::table('tblper')
->where('tblper.fileNo', '=', $term)
->select('tblper.fileNo', 'tblper.surname', 'tblper.first_name', 'tblper.othernames', 'tblper.title', 'tblper.Designation', 'tblper.rank', 'tblper.grade', 'tblper.step', 'tblbanklist.bank','tblper.bankGroup', 'tblper.bank_branch', 'tblper.AccNo', 'tblper.section', 'tblper.appointment_date', 'tblper.dob', 'tblper.home_address', 'tblper.government_qtr', 'tblper.employee_type',
'tblper.gender', 'tbldivision.division', 'tblper.current_state', 'tblper.incremental_date', 'nhfNo')
->join('tbldivision', 'tblper.divisionID', '=', 'tbldivision.divisionID')
->join('tblbanklist', 'tblper.bankID', '=', 'tblbanklist.bankID')
->first();
return response()->json($data);
}
}