public function index(){
        $title = 'Master Golongan Obat';
        // $kota = \DB::table('indoregion_regencies')->orderBy('name','asc')->get();
        $yajra = route('golongan-obat/yajra');

        return view('admin.golongan_obat.index',compact('title','yajra'));
    }

    public function add(){
        $title = 'Tambah golongan obat';
        // $kota = \DB::table('indoregion_regencies')->get();

        return view('admin.golongan_obat.add',compact('title'));
    }

    public function store(Request $request){
        try {
            $a = $request->except(['_token','_method']);
            $a['created_at'] = date('Y-m-d H:i:s');
            $a['updated_at'] = date('Y-m-d H:i:s');
            $a['id'] = \Uuid::generate(4);

            \DB::table('m_golongan_obat')->insert($a);

            \Session::flash('sukses','Data berhasil ditambah');
        } catch (\Exception $e) {
            \Session::flash('gagal',$e->getMessage());
        }
        return redirect('admin/master/golongan-obat');
    }

    public function edit($id){
        $title = 'Edit Golongan Obat';
        // $kota = \DB::table('indoregion_regencies')->get();
        // $yajra = route('pabrik/yajra');
        $dt = \DB::table('m_golongan_obat')->where('id',$id)->first();

        return view('admin.golongan_obat.edit',compact('title','dt'));
    }

    public function update(Request $request,$id){
        try {
            $a = $request->except(['_token','_method']);
            $a['updated_at'] = date('Y-m-d H:i:s');

            \DB::table('m_golongan_obat')->where('id',$id)->update($a);
            \Session::flash('sukses','Data berhasil di update');
        } catch (\Exception $e) {
            \Session::flash('gagal',$e->getMessage());
        }
        return redirect('admin/master/golongan-obat');
    }

    public function delete($id){
        try {
            \DB::table('m_golongan_obat')->where('id',$id)->delete();
            \Session::flash('sukses','Data berhasil dihapus');
        } catch (\Exception $e) {
            \Session::flash('gagal',$e->getMessage());
        }
        return redirect('admin/master/golongan-obat');
    }

    public function yajra(Request $request)
    {
        DB::statement(DB::raw('set @rownum=0'));
        $users = \DB::table('m_golongan_obat')->select([
            DB::raw('@rownum  := @rownum  + 1 AS rownum'),
            '*'
        ]);
        $datatables = Datatables::of($users)->addColumn('action',function($e){
            $url = url('admin/master/golongan-obat/'.$e->id);

            $data = '<div style="width:60px"><a href="'.$url.'" class="btn btn-warning btn-xs btn-edit" id="edit"><i class="fa fa-pencil-square-o"></i></a> <button href="'.$url.'" class="btn btn-danger btn-xs btn-hapus" id="delete"><i class="fa fa-trash-o"></i></button></div>';

            return $data;
        });

        if ($keyword = $request->get('search')['value']) {
            $datatables->filterColumn('rownum', 'whereRaw', '@rownum  + 1 like ?', ["%{$keyword}%"]);
        }

        return $datatables->make(true);
    }