<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Customer;
use App\Models\Paket;
use App\Models\Status_pesanan;
use App\Models\Status_pembayaran;
use App\Models\T_pesanan;

class T_pesanan_controller extends Controller
{
    public function index(){
        $title = 'Transaksi Pesanan';
        $data = T_pesanan::orderBy('created_at','desc')->get();

        return view('t_pesanan.index',compact('title','data'));
    }

    public function add(){
    	$title = 'Tambah Pesanan';
    	$customer = Customer::orderBy('nama','asc')->get();
    	$paket = Paket::orderBy('nama','asc')->get();
    	$status_pesanan = Status_pesanan::orderBy('urutan','asc')->get();
    	$status_pembayaran = Status_pembayaran::orderBy('nama','asc')->get();

    	return view('t_pesanan.add',compact('title','customer','paket','status_pesanan','status_pembayaran'));
    }

    public function store(Request $request){
    	$this->validate($request,[
    		'customer'=>'required',
    		'paket'=>'required',
    		'berat'=>'required',
    		'status_pesanan'=>'required',
    		'status_pembayaran'=>'required'
    	]);

    	$data['id'] = \Uuid::generate(4);
    	$data['customer'] = $request->customer;
    	$data['paket'] = $request->paket;
    	$data['berat'] = $request->berat;
    	$data['status_pembayaran'] = $request->status_pembayaran;
    	$data['status_pesanan'] = $request->status_pesanan;
    	$data['created_at'] = date('Y-m-d H:i:s');
    	$data['updated_at'] = date('Y-m-d H:i:s');

    	$harga = Paket::find($request->paket);
    	$harga_paket = $harga->harga;
    	$berat = $request->berat;

    	$grand_total = $harga_paket * $berat;

    	$data['grand_total'] = $grand_total;

    	T_pesanan::insert($data);

    	\Session::flash('sukses','Transaksi berhasil ditambah');

    	return redirect('transaksi-pesanan/add');
    }

    public function edit($id){
        $dt = T_pesanan::find($id);
        $title = "Edit Transaksi";
        $customer = Customer::orderBy('nama','asc')->get();
        $paket = Paket::orderBy('nama','asc')->get();
        $status_pesanan = Status_pesanan::orderBy('urutan','asc')->get();
        $status_pembayaran = Status_pembayaran::orderBy('nama','asc')->get();

        return view('t_pesanan.edit',compact('title','customer','paket','status_pesanan','status_pembayaran','dt'));
    }

    public function update(Request $request, $id){
        $this->validate($request,[
            'customer'=>'required',
            'paket'=>'required',
            'berat'=>'required',
            'status_pesanan'=>'required',
            'status_pembayaran'=>'required'
        ]);

        // $data['id'] = \Uuid::generate(4);
        $data['customer'] = $request->customer;
        $data['paket'] = $request->paket;
        $data['berat'] = $request->berat;
        $data['status_pembayaran'] = $request->status_pembayaran;
        $data['status_pesanan'] = $request->status_pesanan;
        // $data['created_at'] = date('Y-m-d H:i:s');
        $data['updated_at'] = date('Y-m-d H:i:s');

        $harga = Paket::find($request->paket);
        $harga_paket = $harga->harga;
        $berat = $request->berat;

        $grand_total = $harga_paket * $berat;

        $data['grand_total'] = $grand_total;

        T_pesanan::where('id',$id)->update($data);

        \Session::flash('sukses','Transaksi berhasil diupdate');

        return redirect('transaksi-pesanan');
    }

    public function delete($id){
        T_pesanan::where('id',$id)->delete();

        \Session::flash('sukses','Data berhasil dihapus');
        return redirect('transaksi-pesanan');
    }
}