51 lines
1.2 KiB
PHP
51 lines
1.2 KiB
PHP
<?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);
|
|
}
|
|
} |