<?php
namespace App\Http\Controllers;
use App\Job;
use Illuminate\Http\Request;
class AppController extends Controller
{
public function index() {
return view('app');
}
public function show() {
$jobs = Job::select('jobs.id', 'jobs.job_title', 'jobs.job_type', 'jobs.department', 'jobs.num', 'companies.bts', 'companies.mrt', 'companies.arl', 'companies.imageCompany', 'companies.company_name', 'companies.amphoe', 'companies.province','jobs.created_at')
->join('companies', 'jobs.user_id', 'companies.user_id')
->orderBy('jobs.created_at', 'desc')
->get();
return response()->json(['jobs' => $jobs]);
}
public function detail($id) {
$job = Job::join('companies', 'jobs.user_id', 'companies.user_id')
->where('jobs.id', $id)
->first();
return response()->json(['job' => $job]);
}
}
-
Kittisak Maneewong authored74fad557