Prev Refresh

Rute pergi

# ID Rute dr to Menu
KA.1703 7750 Palur - Solo - Semarang - Bekasi - Bitung - BSD - Balaraja - Cikande - Serang - Ciujung - Serang - Cilegon -Merak (Lantai 2) 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='KA.1703' 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='KA.1703' 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
3 KA.1703 AD7476OA 109 Executive Plus DD 2026-03-31 840886 0 25 0 25 0 100,00 1 103 7750 1 26-04-27 14:57:29 jalurId
25 0 25 0 0,00 1
select * from daily_rute_price where kode_rute='KA.1703' order by id limit 280
SELECT * from daily_rute_price where kode_rute='KA.1703' and tgl>'2024-01-27' and tgl<'2026-04-27' and kursi_terjual>0 order by tgl
# Tgl jId dr to kelas kode bid time nopol seat open cus omset fl
1 2026-03-31 7750 15 KA.1703 840886 AD7476OA 25 0 25 0 1
25 0 25 0 1

Array
(
    [id] => 1836
    [kode_pergi] => KA.1703
    [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] => KA
    [dr_ccd] => 
    [dr_time] => 
    [to_time] => 
    [hplus] => 0
    [to_cd] => 
    [to_ccd] => 
    [create_at] => 2026-04-16 08:03:47
    [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] => 1
    [jalur_id] => 0
    [cron_at] => 0
    [idklsitem] => 0
    [full] => 0
    [jalan] => 0
    [kursi_terjual] => 0
    [penawaran] => 0
    [omset] => 0
    [omset_at] => 0
    [id2] => 1836
    [id_old] => 1836
    [kelas_items] => 
    [nopols] => 
    [st] => 0
    [bl] => 0
    [cek_time] => 0
    [to_jak] => 0
)