File manager - Edit - /home/autoph/public_html/projects/tickets-autohub/app/Http/Controllers/CompanyController.php
Back
<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Models\Company; use Illuminate\Support\Facades\DB; class CompanyController extends Controller { public function importCompanies(){ $url = 'https://autohub.ph/connect/api/v1/asa/api.php'; $parameters = array( 'key'=>"99799116300681217", ); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($parameters)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $op = curl_exec ($ch); $err = curl_error($ch); //if you need curl_close ($ch); $response = json_decode($op,true); foreach($response as $row){ Company::updateOrCreate([ 'id' => $row['comp_id'], 'comp_code' => $row['comp_code'], 'comp_name' => $row['comp_name'], ]); } return response()->json(['message' => "Success"]); } public function getCompanies(Request $request){ $data = []; $term = $request->search; $response = DB::table('companies')->where(function($query) use ($term){ $query->orWhere('comp_code','like','%'.$term.'%') ->orWhere('comp_name','like','%'.$term.'%'); }) ->orderBy('comp_code', 'asc') ->get(); foreach($response as $item){ $data['results'][] = [ 'id' => $item->id, 'text' => $item->comp_code." (".$item->comp_name.") " ]; } return response()->json($data); } }
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings