Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- namespace App\Http\Controllers;
- use Illuminate\Http\Request;
- class Buku_controller extends Controller
- {
- public function index(){
- $title = 'List Buku';
- $data = \DB::table('m_buku as b')->join('m_kategori as k','b.kategori','=','k.id')->select('b.gambar','b.judul','k.nama','b.penulis','b.stock','b.created_at','b.id','b.status')->get();
- return view('buku.buku_index',compact('title','data'));
- }
- public function kosong(){
- $title = 'List Buku Stock Habis';
- $data = \DB::table('m_buku as b')->join('m_kategori as k','b.kategori','=','k.id')->select('b.gambar','b.judul','k.nama','b.penulis','b.stock','b.created_at','b.id','b.status')->where('b.stock','<',1)->get();
- // dd($data);
- return view('buku.buku_index',compact('title','data'));
- }
- public function nonaktif(){
- $title = 'List Buku Nonaktif';
- $data = \DB::table('m_buku as b')->join('m_kategori as k','b.kategori','=','k.id')->select('b.gambar','b.judul','k.nama','b.penulis','b.stock','b.created_at','b.id','b.status')->where('b.status','!=',1)->get();
- // dd($data);
- return view('buku.buku_index',compact('title','data'));
- }
- public function add(){
- $title = 'Tambah Buku';
- $kategori = \DB::table('m_kategori')->get();
- return view('buku.buku_add',compact('title','kategori'));
- }
- public function store(Request $request){
- $judul = $request->judul;
- $keterangan = $request->keterangan;
- $stock = $request->stock;
- $kategori = $request->kategori;
- $penulis = $request->penulis;
- $file = $request->file('image');
- //Move Uploaded File
- $destinationPath = 'uploads';
- $file->move($destinationPath,$file->getClientOriginalName());
- \DB::table('m_buku')->insert([
- 'kategori'=>$kategori,
- 'judul'=>$judul,
- 'keterangan'=>$keterangan,
- 'stock'=>$stock,
- 'penulis'=>$penulis,
- 'gambar'=>$file->getClientOriginalName(),
- 'created_at'=>date('Y-m-d H:i:s'),
- 'updated_at'=>date('Y-m-d H:i:s'),
- ]);
- \Session::flash('sukses','Data buku berhasil di tambah');
- return redirect('master/buku');
- }
- public function edit($id){
- $title = 'Edit Buku';
- $dt = \DB::table('m_buku')->where('id',$id)->first();
- $kategori = \DB::table('m_kategori')->get();
- return view('buku.buku_edit',compact('title','dt','kategori'));
- }
- public function update(Request $request,$id){
- $judul = $request->judul;
- $keterangan = $request->keterangan;
- $stock = $request->stock;
- $kategori = $request->kategori;
- $penulis = $request->penulis;
- $file = $request->file('image');
- if($file){
- \DB::table('m_buku')->where('id',$id)->update([
- 'kategori'=>$kategori,
- 'judul'=>$judul,
- 'keterangan'=>$keterangan,
- 'stock'=>$stock,
- 'penulis'=>$penulis,
- 'gambar'=>$file->getClientOriginalName(),
- 'updated_at'=>date('Y-m-d H:i:s')
- ]);
- //Move Uploaded File
- $destinationPath = 'uploads';
- $file->move($destinationPath,$file->getClientOriginalName());
- }else{
- \DB::table('m_buku')->where('id',$id)->update([
- 'kategori'=>$kategori,
- 'judul'=>$judul,
- 'keterangan'=>$keterangan,
- 'stock'=>$stock,
- 'penulis'=>$penulis,
- 'updated_at'=>date('Y-m-d H:i:s')
- ]);
- }
- \Session::flash('sukses','Buku berhasil di update');
- return redirect('master/buku');
- }
- public function delete($id){
- \DB::table('m_buku')->where('id',$id)->delete();
- \Session::flash('sukses','Data buku berhasil dihapus');
- return redirect('master/buku');
- }
- public function status($id){
- $data = \DB::table('m_buku')->where('id',$id)->first();
- $status_sekarang = $data->status;
- if($status_sekarang == 1){
- \DB::table('m_buku')->where('id',$id)->update([
- 'status'=>0
- ]);
- }else{
- \DB::table('m_buku')->where('id',$id)->update([
- 'status'=>1
- ]);
- }
- \Session::flash('sukses','Status berhasil di ubah');
- return redirect('master/buku');
- }
- }
Add Comment
Please, Sign In to add comment