Eksport PDF berdasarkan dua tanggal di Laravel 8


Controller

public function periodeee (Request $request)

    {

        $tgl_mulai = date('Y-m-d',strtotime($request->tgl_mulai));

        $tgl_selesai = date('Y-m-d',strtotime($request->tgl_selesai));

        $bm = BMarketing::whereBetween('tanggal',[$tgl_mulai,$tgl_selesai])->get();

        $ak = akun::all();

        return view('bmarketing',compact('bm','ak'));

    }

Models

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class BMarketing extends Model

{

    // use HasFactory;

    protected $table = "bmarketings";

    protected $guarded = [

    ];

    public function akun()

    {

        return $this->hasMany(Akun::class,'kode_akun', 'kode_akun');

    }

}

View

<div class="container mt-1">

        @if (auth()->user()->role=="Admin")

        <a href="/tambahdatabm" class="btn btn-primary mb-3 mt-3">Tambah Data</a>

        @endif

        <a href="/exporttpdf" target="_blank" class="btn btn-info mb-3 mt-3">Export PDF </a>

        <a href="/cetakform" class="btn btn-info mb-3 mt-3">Export PDF Per Tgl </a>

        <a href="/exporttexcel" target="_blank" class="btn btn-info mb-3 mt-3">Export Excel </a>

        <a href="/bmarketing" class="btn btn-info mb-3 mt-3">Refresh</a>

        <div class="container row col-lg-6 md-4 ms-auto">

            <form action="/periodeee" method="get" class="d-flex">

                <input type="date" name="tgl_mulai" id="tgl_mulai" class="form-control datpicker mb-2 ">

                <input type="date" name="tgl_selesai" id="tgl_selesai" class="form-control datpicker ms-2 mb-2 ">

                <button type="submit" name="filter_tgl" class="btn btn-success datpicker ms-2 mb-2 ">Filter</button>

            </form>

        </div>

</div>

Route

//Filter Tanggal

    Route::get('/periodeee', [BmarketingController::class, 'periodeee'])->name('periodeee')->middleware('auth');

avatar miftahulhidayat
@miftahulhidayat

2 Kontribusi 0 Poin

Diperbarui 2 tahun yang lalu

Tanggapan

Pertanyaan kamu tidak jelas, coba dijelaskan lebih baik

  1. rapikan kode kamu, coba lihat di atas
  2. Apa pertanyaannya

Belum ada Jawaban. Jadi yang pertama Jawaban

Login untuk ikut Jawaban