public function pdfReport(PdfReportRequest $request)
{
// $filter_output = $request->input('filter_ambil');
// // $list_export= Transaksi::where('stt',$filter)->get();
// return view('admin.report',compact('list_transaksi'))
// $list_export= Transaksi::where('stt',$filter_output)->get();
// dd($filter_output);
//inisialisasi
$filter_output = $request->input('filter_ambil');
$mulai_tgl = $request->input('tgl_awal');
$sampai_tgl = $request->input('tgl_akhir');
//batas inisialisasi
if ($filter_output == "0") {
$list_transaksi = Transaksi::whereBetween('tgl_beli', [$mulai_tgl, $sampai_tgl])->where('stt', '0')->get();
$pdf = PDF::loadView('pdf.ReportFinal', compact('list_transaksi'));
return $pdf->download('FinalExport' . Carbon::now() . '.pdf');
} elseif ($filter_output == "1") {
$list_transaksi = Transaksi::whereBetween('tgl_beli', [$mulai_tgl, $sampai_tgl])->where('stt', '1')->get();
$pdf = PDF::loadView('pdf.ReportFinal', compact('list_transaksi'));
return $pdf->download('FinalExport' . Carbon::now() . '.pdf');
} else {
$list_transaksi = Transaksi::whereBetween('tgl_beli', [$mulai_tgl, $sampai_tgl])->get();
$pdf = PDF::loadView('pdf.ReportFinal', compact('list_transaksi'));
return $pdf->download('FinalExport' . Carbon::now() . '.pdf');
}
}
public function excelApp()
{
$data = Transaksi::where('stt', '1')->get();
Excel::create('ExportExcelTransaksiApproved' . Carbon::now() . '', function ($excel) use($data) {
$excel->sheet('coba1', function ($sheet) use($data) {
$sheet->fromArray($data);
});
})->export('xls');
}
