<?php

namespace App\Http\Controllers;

use DB;
use Illuminate\Http\Request;
use Auth;

class TempatController extends Controller
{

    public function showAll()
    {
        return response()->json(DB::table('TMLogReference')->get());
    }

    public function showBy($jenis)
    {
        if($jenis == 1)
        {
            return response()->json(DB::table('TMOrgTL')->join('TMOrgJL as j','TMOrgTL.KodeJL','=','j.Kode')->where('TMOrgTL.Aktif',1)->select(DB::raw('TMOrgTL.Kode,TMOrgTL.KodeJL,j.Nama as NamaJL,TMOrgTL.Nama,TMOrgTL.StInap'))->get());
        }
        elseif($jenis == 2){
            return response()->json(DB::table('TMOrgJL')->where('Aktif',1)->get());
        }
        else {
            return response(500);
        }
    }

    public function create(Request $request)
    {
        $author = Reference::create($request->all());

        return response()->json($author, 201);
    }

    public function update($id, Request $request)
    {
        $author = Reference::findOrFail($id);
        $author->update($request->all());

        return response()->json($author, 200);
    }

    public function delete($id)
    {
        Reference::findOrFail($id)->delete();
        return response('Deleted Successfully', 200);
    }
}