Prev Refresh

Rute pergi

# ID Rute dr to Menu
CI.2003 7666 Ciputat - Pd. Pinang - P.Minggu - Pasar Rebo - Kp.Rambutan - Cikarang - Klari - Semarang - Solo - Batu Jamus 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='CI.2003' 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='CI.2003' 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
0 CI.2003 AD7743OF 2003 SuperTop SHD 2026-03-11 0000-00-00 00:00:00 838397 0 0 0 0 0 0,00 96 7666 0 26-03-11 14:58:18 jalurId
0 0 0 0 0,00 0
select * from daily_rute_price where kode_rute='CI.2003' order by id limit 280
SELECT * from daily_rute_price where kode_rute='CI.2003' and tgl>'2024-01-27' and tgl<'2026-04-27' and kursi_terjual>0 order by tgl
Array
(
    [id] => 1759
    [kode_pergi] => CI.2003
    [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] => CI
    [dr_ccd] => 
    [dr_time] => 
    [to_time] => 
    [hplus] => 0
    [to_cd] => 
    [to_ccd] => 
    [create_at] => 2026-03-12 14:05:12
    [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] => 1759
    [id_old] => 1759
    [kelas_items] => 
    [nopols] => 
    [st] => 0
    [bl] => 0
    [cek_time] => 0
    [to_jak] => 0
)