Script Cek Container Belum Gate Out

Cek container Delivery belum Gate Out
SELECT cont_no, no_ppkb, job_slip, date_in, status
FROM
    service_gate_delivery
WHERE date_out IS NULL AND status='N'
ORDER BY date_in


Cek container Receiving belum Gate Out
SELECT sgr.cont_no, sgr.no_ppkb, sgr.job_slip, sgr.date_in
FROM
    service_gate_receiving sgr
        LEFT JOIN service_receiving sr ON (sgr.cont_no = sr.cont_no AND sgr.no_ppkb = sr.no_ppkb)
WHERE sgr.date_out IS NULL AND sr.cont_no IS NULL
ORDER BY sgr.date_in;