Date range filter Service Implementation

[tanvirrajeev]

I want to set a date range filter with Service Implementation

My Datatables as Service is working perfectly. Now i want to set a date range filer to the view. How can i do that?

My Controller

public function orderview(OrderDataTable $dataTable ){
    $from_date = date('2020-01-01 00:00:00');
    $to_date = Carbon::now();
    return $dataTable
        ->with([
            'from' => $from_date,
            'to' => $to_date,
            ])
        ->render('admin.search.order');
    // return $dataTable->render('admin.search.order');
}

Datatable

<?php

namespace App\DataTables;

// use App\App\OrderDataTable;
// use OrderDataTable;
use App\DataTables\OrderDataTable;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Html\Column;
use Yajra\DataTables\Html\Editor\Editor;
use Yajra\DataTables\Html\Editor\Fields;
use Yajra\DataTables\Services\DataTable;
use App\Order;
use Illuminate\Support\Facades\DB;

class OrderDataTable extends DataTable
{

    public function dataTable($query){
        return datatables()
            ->eloquent($query);
    }


    public function query(OrderDataTable $model){
        // $from = date('2020-11-10 00:00:00');
        // $to = date('2020-11-11 23:59:59');
        // $data = Order::where('created_at', '2020-11-11 22:03:13');
        // $data = Order::select();
        $data = Order::query()
            // ->whereBetween('created_at', ['2020-11-10 00:00:00', '2020-11-11 23:59:59'])
            ->whereBetween('created_at', [$this->from, $this->to])
            ->select([
                'orders.id',
                'orders.ecomordid',
                'orders.status_id',
                'orders.awb',
                'orders.created_at'
            ]);
        return $this->applyScopes($data);
    }


    public function html(){
        return $this->builder()
                    ->setTableId('orderdatatable-table')
                    // ->columns($this->getColumns())
                    ->columns([
                        'id' => [ 'title' => 'SHIPPING CODE' ],
                        'ecomordid' => [ 'title' => 'ECOM ORDER' ],
                        'status_id' => [ 'title' => 'STATUS' ],
                        'awb' => [ 'title' => 'AWB' ],
                        'created_at' => [ 'title' => 'DATE' ],
                    ])
                    ->minifiedAjax()
                    ->dom('Bfrtip')
                    ->orderBy(0)
                    ->parameters([
                        'dom'          => 'Bfrtip',
                        'buttons'      => ['excel', 'print', 'reset', 'reload'],
                        'initComplete' => "function () {
                            this.api().columns([0,3]).every(function () {
                                var column = this;
                                var input = document.createElement(\"input\");
                                $(input).appendTo($(column.footer()).empty())
                                .on('change', function () {
                                    column.search($(this).val(), false, false, true).draw();
                                });
                            });
                        }",
                    ]);
    }


    protected function getColumns(){
        return [
            Column::make('id'),
            Column::make('ecomordid'),
            Column::make('status_id'),
            Column::make('awb'),
            Column::make('created_at'),
        ];
    }


    protected function filename(){
        return 'Order_' . date('YmdHis');
    }
}

View

@extends('layouts.master')

@section('content')
<meta name="csrf-token" content="{{ csrf_token() }}" />
<div class="container">
    <div class="row justify-content-center">
        <div class="col-md-12">

            <div class="card">
                <div class="card-header bg-orange"><h3>{{ __('Update By AWB') }}</h3></div>
                <div class="card-body">

                        <div class="form-group">

                            <div class="row">
                                <div class="col-md-5">Total Records - <b><span id="total_records"></span></b></div>
                                <div class="col-md-5">
                                 <div class="input-group input-daterange">
                                     <input type="text" name="from_date" id="from_date"  class="form-control" />
                                     &nbsp;<div class="input-group-addon">To</div>&nbsp;
                                     <input type="text"  name="to_date" id="to_date"  class="form-control" />
                                 </div>
                                </div>
                                <div class="col-md-2">
                                 <button type="button" name="filter" id="filter" class="btn btn-info btn-sm">Filter</button>
                                 <button type="button" name="refresh" id="refresh" class="btn btn-success btn-sm">Refresh</button>
                                </div>
                               </div>

                        </div>


                    <div class="table-responsive">
                        <div class="panel panel-default">
                            <div class="panel-heading"></div>
                            <div class="panel-body">
                                {!! $dataTable->table([], true) !!}
                                {!! $dataTable->scripts() !!}
                            </div>
                        </div>
                    </div>

                </div>
            </div>
        </div>
    </div>
</div>
@endsection

System details

• OS: Windows 10
• Laravel: 7.28.4
• PHP Version 7.2.5
• laravel-datatables-buttons: 4.0
• laravel-datatables-html: 4.0
• laravel-datatables-oracle: 9.14

[RayhanYulanda]

Hope it can help you https://stackoverflow.com/a/61904088/6883282

[yajra]

Or try using the ajax form api ->ajaxWithForm($url, $formSelector).

->ajaxWithForm('', '#form-container-id')

This will automatically include most of the form elements in the request.

[markplus]

Where should it be inserted?

[markplus]

I'm trying to do it but I haven't succeeded yet and I would need to be able to select the year to see the results but I can't make it work by following this post