<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Sales;

use DB;
use Datatables;

class Sales_controller extends Controller
{
    public function index(){
        $title = 'History Transaksi POS';
        $data = Sales::withCount('lines')->orderBy('created_at','desc')->get();

        $awal = date('Y-m-d',strtotime('-1 days'));
        $akhir = date('Y-m-d');
        $yajra = url('sales/yajra');

        return view('sales.index',compact('title','data','awal','akhir','yajra'));
    }

    public function detail($id){
        $dt = Sales::find($id);
        $lines = \DB::select("SELECT sl.produk,sum(sl.qty) as total_qty,sum(sl.grand_total) as grand_total,sl.buy,sl.harga,mp.nama from sales_line sl join m_produk mp on mp.id=sl.produk where sl.sales='".$id."' group by sl.produk,sl.buy,sl.harga,mp.nama");
        // dd($lines);
        $title = "Detail Transaksi ".$dt->no_struk;

        return view('sales.detail',compact('title','dt','lines'));
    }

    public function filter(Request $request){
        $awal = date('Y-m-d',strtotime($request->awal));
        $akhir = date('Y-m-d',strtotime($request->akhir));

        $title = "History Transaksi POS $awal s/d $akhir";
        // $data = Sales::whereDate('created_at','>=',$awal)->whereDate('created_at','<=',$akhir)->orderBy('created_at','desc')->get();
        $yajra = url('sales/filter/yajra/'.$awal.'/'.$akhir);
        // dd($data);
        return view('sales.index',compact('title','awal','akhir','yajra'));
    }

    public function pelunasan(Request $request,$id){
        try {
            $dt = Sales::find($id);
            $nominal = $request->nominal;
            $deposit = $dt->nominal_deposit;
            Sales::where('id',$id)->update([
                'is_lunas'=>1,
                'jumlah_bayar'=>$nominal+$deposit
            ]);
            \Session::flash('sukses','Pelunasan berhasil dilakukan');
        } catch (\Exception $e) {
            \Session::flash('gagal',$e->getMessage());
        }
        return redirect()->back();
    }

    public function yajra(Request $request){
        $users = Sales::withCount('lines')->with([
            'customers'
        ])->select('*')->orderBy('created_at','desc')->get();

        return Datatables::of($users)->addColumn('action',function($e){
            // $edit = url('produk/'.$e->id);
            $url = url('sales/'.$e->id);
            $struck = url('pos/struck/'.$e->id);

            return '<a href="'.$url.'" class="btn btn-xs btn-primary">Detail</a> <a href="'.$struck.'" target="_blank" class="btn btn-xs btn-success"><i class="fa fa-print"></i></a>';
        })->editColumn('jumlah_bayar',function($e){
            return number_format($e->jumlah_bayar,0);
        })->editColumn('diskon',function($e){
            return number_format($e->diskon,0);
        })->editColumn('kembalian',function($e){
            return number_format($e->kembalian,0);
        })->editColumn('grand_total',function($e){
            return number_format($e->grand_total,0);
        })->editColumn('bersih',function($e){
            return number_format($e->bersih,0);
        })->make();
    }

    public function yajra_filter(Request $request,$awal,$akhir){
        $users = Sales::withCount('lines')->with([
            'customers'
        ])->select('*')->whereDate('created_at','>=',$awal)->whereDate('created_at','<=',$akhir)->get();

        return Datatables::of($users)->addColumn('action',function($e){
            // $edit = url('produk/'.$e->id);
            $url = url('sales/'.$e->id);
            $struck = url('pos/struck/'.$e->id);

            return '<a href="'.$url.'" class="btn btn-xs btn-primary">Detail</a> <a href="'.$struck.'" target="_blank" class="btn btn-xs btn-success"><i class="fa fa-print"></i></a>';
        })->editColumn('jumlah_bayar',function($e){
            return number_format($e->jumlah_bayar,0);
        })->editColumn('diskon',function($e){
            return number_format($e->diskon,0);
        })->editColumn('kembalian',function($e){
            return number_format($e->kembalian,0);
        })->editColumn('grand_total',function($e){
            return number_format($e->grand_total,0);
        })->editColumn('bersih',function($e){
            return number_format($e->bersih,0);
        })->make();
    }
}