Prev Refresh

Rute pergi

# ID Rute dr to Menu
KL.901 7184 Klaten - Yogyakarta - Magelang - Semarang - BSD - Bitung - Serang - Cilegon - Merak Rute Pergi
select a.*,b.nama as nama_jalur,b.dr_ccd as dr_ccd, b.to_ccd as to_ccd from daily_rute_price a JOIN jalur b ON a.jalur_id=b.id where kode_rute='KL.901' group by a.jalur_id
ID Rute Rute Kelas Kode Kota Agen at - at Kota Agen Harga Seat c3 Sales cID Menu
select * from daily_price where kode_rute='KL.901' order by id desc limit 200
# Kode Kode2 NoPol NL dr to Trayek Kelas Tgl Start c2 Price Seat Open Sales Rp % ful c3 jId # Update Menu
1 KL.901 Executive Plus SHD 2026-02-06 0000-00-00 00:00:00 817602 0 0 36 -36 0 0,00 67 7184 0 26-01-18 20:42:18 jalurId
0 KL.901 Executive Plus SHD 2026-02-05 0000-00-00 00:00:00 817601 0 0 36 -36 0 0,00 67 7184 0 26-01-18 13:46:53 jalurId
4 KL.901 Executive Plus SHD 2026-02-04 0000-00-00 00:00:00 817600 0 0 36 -36 0 0,00 67 7184 0 26-01-18 20:50:18 jalurId
5 KL.901 Executive Plus SHD 2026-02-03 817599 0 0 36 -36 0 0,00 67 7184 0 26-01-18 20:54:18 jalurId
4 KL.901 Executive Plus SHD 2026-02-02 0000-00-00 00:00:00 817598 0 0 35 -35 0 0,00 67 7184 0 26-01-18 20:58:18 jalurId
3 KL.901 Executive Plus SHD 2026-02-01 0000-00-00 00:00:00 817597 0 0 36 -36 0 0,00 67 7184 0 26-01-18 21:02:17 jalurId
0 215 -215 0 0,00 0
select * from daily_rute_price where kode_rute='KL.901' order by id limit 280
SELECT * from daily_rute_price where kode_rute='KL.901' and tgl>'2024-01-27' and tgl<'2026-04-27' and kursi_terjual>0 order by tgl
Array
(
    [id] => 1640
    [kode_pergi] => KL.901
    [kelas_id] => 0
    [kode_rute_armada] => 
    [kelas_armada] => 0
    [kode_pergi_v0] => 
    [kode_pulang] => 
    [rute_pergi] => 
    [rute_pulang] => 
    [url] => 
    [info] => 
    [title] => 
    [dr_agent] => 
    [to_agent] => 
    [dr_cd] => KL
    [dr_ccd] => 
    [dr_time] => 
    [to_time] => 
    [hplus] => 0
    [to_cd] => 
    [to_ccd] => 
    [create_at] => 2026-02-17 08:04:42
    [dr_city] => 0
    [dr_agen] => 0
    [to_city] => 0
    [to_agen] => 0
    [price_count] => 0
    [update_at] => 0
    [capacity] => 0
    [price_per_seat] => 0
    [j2] => 6
    [jalur_id] => 0
    [cron_at] => 0
    [idklsitem] => 0
    [full] => 0
    [jalan] => 0
    [kursi_terjual] => 0
    [penawaran] => 0
    [omset] => 0
    [omset_at] => 0
    [id2] => 1640
    [id_old] => 1640
    [kelas_items] => 
    [nopols] => 
    [st] => 0
    [bl] => 0
    [cek_time] => 0
    [to_jak] => 0
)