PHP app Penjualan::whereMonth Examples

Example #1

File: PenjualanController.php Project: adit33/cobaan

 public function getdata(Request $request)
 {
     $bln = $request->input('bulan');
     $thn = $request->input('tahun');
     $penjualan = Penjualan::whereMonth('tanggal', '=', $bln)->whereYear('tanggal', '=', $thn)->get();
     $jumlah = Penjualan::whereMonth('tanggal', '=', $bln)->whereYear('tanggal', '=', $thn)->sum('total');
     $kode = $this->kodeJual();
     $data['penjualan'] = $penjualan;
     $data['kode'] = $kode;
     $data['jumlah'] = $jumlah;
     $data['bln'] = $bln;
     $data['thn'] = $thn;
     $pdf = PDF::loadView('penjualan.laporan', $data);
     return $pdf->stream();
 }