Level 1
I want to create a date filter which, when the date and time are selected, appears in the data table that has been created and so does the dropdown list next to it
Aug 19, 2023
3
Level 1
Illegal operator and value combination.
there is an error in illegal code, please help me :)
TablesController.php
public function RekapGarduIndukSearch(Request $request)
{
$start_date = $request->start_date;
$end_date = $request->end_date;
$rekap_garduinduk = GarduInduk::whereDate('waktu_trip', '>=', $start_date)
->whereDate('waktu_trip', '<=', $end_date)
->orWhereDate('waktu_normal', '>=', $start_date)
->orWhereDate('waktu_normal', '<=', $end_date)
->get();
return view('backend.tables.rekap-garduinduk', compact('rekap_garduinduk'));
}
rekap-garduinduk.blade.php
@extends('backend.layouts.app')
@section('content')
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/font/bootstrap-icons.css">
<div class="animated fadeIn">
@if (session('status'))
<div class="alert alert-success">
{{ session('status') }}
</div>
@endif
<div class="content-wrapper">
<div class="card-body">
<div class="col-md-12">
<form method="GET" action="{{ url('/rekap-garduinduk') }}">
<div class="form-row">
<div class="form-group col-md-3">
<label for="start_date">Start Date :</label>
<input type="datetime-local" class="form-control" id="start_date" name="start_date">
</div>
<div class="form-group col-md-3">
<label for="end_date">End Date :</label>
<input type="datetime-local" class="form-control" id="end_date" name="end_date">
</div>
<div class="form-group col-md-3" id="area">
<label for="area">Search Area:</label>
<select class="form-control">
<option value="UP3">-- UP3 / UP2D --</option>
<option value="Up2d">UP2D</option>
<option value="Cilacap">Cilacap</option>
<option value="Demak">Demak</option>
<option value="Klaten">Klaten</option>
<option value="Kudus">Kudus</option>
<option value="Magelang">Magelang</option>
<option value="Pekalongan">Pekalongan</option>
<option value="Purwokerto">Purwokerto</option>
<option value="Salatiga">Salatiga</option>
<option value="Semarang">Semarang</option>
<option value="Sukoharjo">Sukoharjo</option>
<option value="Surakarta">Surakarta</option>
<option value="Tegal">Tegal</option>
<option value="Yogyakarta">Yogyakarta</option>
</select>
</div>
<div class="form-group col-md-3" style="margin-top:29px;">
<button class="btn btn-primary" type="button" id="submit">Submit</button>
</div>
</div>
</form>
<div class="card" style="width:100%;">
<div class="card-header">
<h3 class="card-title" style="font-family: Arial, Helvetica, sans-serif; font-weight: 400px;">
Rekap
Data
Gardu
Induk</h3>
<div class="d-flex justify-content-end">
<a href="{{ url('/rekap-garduinduk-add') }}" class="btn btn-success btn-sm">
<i class="fa fa-plus"></i> Tambah
</a>
</div>
</div>
<div class="card-body table-responsive">
<table class="table table-bordered table-striped">
<thead>
<tr>
<th>Action</th>
<th>No</th>
<th>Area</th>
<th>Gardu Induk</th>
<th>Pmt Recloser</th>
<th>Waktu Trip</th>
<th>Waktu Normal</th>
<th>Alasan Operasi</th>
<th>Indikasi Relay</th>
<th>Jenis Gangguan</th>
<th>Fasa</th>
<th>Ifa</th>
<th>Ifb</th>
<th>Ifc</th>
<th>Ifn</th>
<th>Beban Sebelum</th>
<th>Tegangan Sebelum</th>
<th>Beban Sesudah</th>
<th>Tegangan Sesudah</th>
<th>Kode Gangguan Keterangan</th>
<th>Daya Hilang</th>
<th>Lama Padam</th>
<th>Kwh Hilang</th>
<th>Cuaca</th>
<th>No Pole Tiang</th>
<th>Jarak Gangguan</th>
<th>Lokasi Gangguan</th>
<th>Recovery</th>
<th>Status</th>
<th>User Update</th>
<th>Noted</th>
<th>Last Update</th>
</tr>
</thead>
<tbody>
@foreach ($rekap_garduinduk as $gardu)
<tr>
<td>
<a href="{{ url('/rekap-garduinduk', $gardu->id) }}"
class="btn btn-danger btn-sm">
<i class="bi bi-trash-fill"></i>
</a>
<a href="{{ url('/rekap-garduinduk-edit', $gardu->id) }}"
class="btn btn-primary btn-sm">
<i class="bi bi-pencil-fill"></i>
</a>
<a href="{{ url('/rekap-garduinduk-view', $gardu->id) }}"
class="btn btn-warning btn-sm">
<i class="fa fa-eye" style="color: rgb(246, 233, 233)"></i>
</a>
</td>
<td>{{ $loop->iteration }}</td>
<td>{{ $gardu->apj_id }}</td>
<td>{{ $gardu->gardu_induk }}</td>
<td>{{ $gardu->pmt_recloser }}</td>
<td>{{ $gardu->waktu_trip }}</td>
<td>{{ $gardu->waktu_normal }}</td>
<td>{{ $gardu->alasan_operasi }}</td>
<td>{{ $gardu->indikasi_relay }}</td>
<td>{{ $gardu->jenis_gangguan }}</td>
<td>{{ $gardu->fasa }}</td>
<td>{{ $gardu->ifa }}</td>
<td>{{ $gardu->ifb }}</td>
<td>{{ $gardu->ifc }}</td>
<td>{{ $gardu->ifn }}</td>
<td>{{ $gardu->beban_sebelum }}</td>
<td>{{ $gardu->tegangan_sebelum }}</td>
<td>{{ $gardu->beban_sesudah }}</td>
<td>{{ $gardu->tegangan_sesudah }}</td>
<td>{{ $gardu->kode_gangguan_keterangan }}</td>
<td>{{ $gardu->daya_hilang }}</td>
<td>{{ $gardu->lama_padam }}</td>
<td>{{ $gardu->kwh_hilang }}</td>
<td>{{ $gardu->cuaca }}</td>
<td>{{ $gardu->no_pole_tiang }}</td>
<td>{{ $gardu->jarak_gangguan }}</td>
<td>{{ $gardu->lokasi_gangguan }}</td>
<td>{{ $gardu->recovery }}</td>
<td>{{ $gardu->status }}</td>
<td>{{ $gardu->user_update }}</td>
<td>{{ $gardu->keterangan }}</td>
<td>{{ $gardu->last_update }}</td>
</tr>
@endforeach
</tbody>
</table>
{{ $rekap_garduinduk->links() }}
</div>
</div>
</div>
</div>
</div>
</div>
<style>
.container {
overflow: scroll;
height: 180px;
width: 300px;
}
table {
border-collapse: collapse;
}
table th,
table td {
max-width: 100%;
padding: 8px 16px;
border: 1px solid #ddd;
overflow: hidden;
text-overflow: ellipsis;
white-space: nowrap;
}
table thead {
position: sticky;
inset-block-start: 0;
background-color: #000000;
color: #ffffff;
}
</style>
@endsection
web.php
Route::get('/rekap-garduinduk', [App\Http\Controllers\backend\TablesController::class, 'RekapGarduIndukSearch'])->name('RekapGarduIndukSearch');
Level 50
Why don't you start by saying what error you're getting and where.
Level 1
Oh i'm sorry, this in section have errors "Illegal operator and value combination"
public function RekapGarduIndukSearch(Request $request)
{
$start_date = $request->start_date;
$end_date = $request->end_date;
$rekap_garduinduk = GarduInduk::whereDate('waktu_trip', '>=', $start_date)
->whereDate('waktu_trip', '<=', $end_date)
->orWhereDate('waktu_normal', '>=', $start_date)
->orWhereDate('waktu_normal', '<=', $end_date)
->get();
return view('backend.tables.rekap-garduinduk', compact('rekap_garduinduk'));
}
Please or to participate in this conversation.