69 lines
2.3 KiB
PHP
69 lines
2.3 KiB
PHP
<?php
|
|
|
|
namespace App\Services\Parking;
|
|
|
|
use App\Models\TransaksiParkir;
|
|
use Illuminate\Support\Facades\DB;
|
|
use Illuminate\Support\Facades\Log;
|
|
|
|
class geTransaksi
|
|
{
|
|
public function TransaksiParkir($idNopol)
|
|
{
|
|
Log::info("Mencari transaksi : " . $idNopol);
|
|
|
|
if (!$idNopol) {
|
|
return;
|
|
}
|
|
|
|
$getTransaksi = TransaksiParkir::selectRaw(
|
|
'transaksi_parkir.id::VARCHAR as id,
|
|
no_pol,
|
|
id_kendaraan,
|
|
id_pintu_masuk,
|
|
id_pintu_keluar,
|
|
waktu_masuk,
|
|
waktu_keluar,
|
|
bayar_keluar, jm.nama',
|
|
)
|
|
->leftJoin("jenis_mobil as jm", "transaksi_parkir.id_kendaraan", "=", "jm.id")
|
|
->where("no_pol", "LIKE", $idNopol . "%")
|
|
->where("status", 1)
|
|
->orderByDesc("waktu_masuk")
|
|
->first();
|
|
|
|
return $getTransaksi;
|
|
}
|
|
|
|
public function TransaksiMember($nopolCardNumber)
|
|
{
|
|
Log::info("Mencari transaksi member : " . $nopolCardNumber);
|
|
$getMember = DB::table("mergetransaksistikerdetail as mtsd")
|
|
// $getMember = DB::table("transaksi_stiker as ts")
|
|
// ->leftjoin("detail_transaksi_stiker as dts", "dts.notrans", "=", "ts.notrans")
|
|
// ->leftJoin("card_member as cm", "cm.notrans", "=", "ts.no_id")
|
|
// ->leftJoin("jenis_langganan as jl", "jl.id", "=", "ts.jenis_langganan")
|
|
// ->leftJoin("stasiunkerja as sk", "sk.kode", "=", "ts.unit_kerja")
|
|
// ->leftJoin("jenis_mobil as jm", "jm.id", "=", "dts.jenis_mobil")
|
|
->select(
|
|
DB::raw('
|
|
mtsd.notrans, nama , alamat as alamat , telepon as telepon,
|
|
awal , akhir as akhir, nopol, nama vehicle, mtsd.tanggal, cm.no_card as no_card'),
|
|
)
|
|
// ->distinct()
|
|
->leftJoin("card_member as cm", "cm.notrans", "=", "mtsd.no_id")
|
|
->where("nopol", $nopolCardNumber)
|
|
// ->whereRaw("now() between awal and akhir")
|
|
->orderByDesc("tanggal")
|
|
->first();
|
|
|
|
if (!$getMember) {
|
|
Log::info("Member aktif tidak ditemukan");
|
|
return null;
|
|
}
|
|
|
|
Log::info("Member ditemukan : " . json_encode($getMember));
|
|
return $getMember;
|
|
}
|
|
}
|