AppController.php 918 Bytes
Newer Older
Kittisak Maneewong's avatar
Kittisak Maneewong committed
1 2 3 4
<?php

namespace App\Http\Controllers;

Kittisak Maneewong's avatar
Kittisak Maneewong committed
5
use App\Job;
Kittisak Maneewong's avatar
Kittisak Maneewong committed
6 7 8 9 10 11 12
use Illuminate\Http\Request;

class AppController extends Controller
{
    public function index() {
        return view('app');
    }
Kittisak Maneewong's avatar
Kittisak Maneewong committed
13 14

    public function show() {
Kittisak Maneewong's avatar
Kittisak Maneewong committed
15
        $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')
Kittisak Maneewong's avatar
Kittisak Maneewong committed
16 17 18 19 20
            ->join('companies', 'jobs.user_id', 'companies.user_id')
            ->orderBy('jobs.created_at', 'desc')
            ->get();
        return response()->json(['jobs' => $jobs]);
    }
Kittisak Maneewong's avatar
Kittisak Maneewong committed
21 22 23 24 25 26 27

    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's avatar
Kittisak Maneewong committed
28
}