Prev Refresh

Rute pergi

# ID Rute dr to Menu
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='BO.409' 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='BO.409' 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
select * from daily_rute_price where kode_rute='BO.409' order by id limit 280
# cdPergi cdPergi drCity drAgen toCity toAgen Rute Pergi NoPol c3 cdBalik Url Kelas Kls Jum Update time Menu
232 BO.409 313 3131 212 2123 Bogor-Bogor/tajur ke Sragen-Plupuh GM.403 url Executive 4 0 250322065651 05:00 Edit uVo Balik
1605 BO.403 313 3131 212 2123 Bogor - Nanggewer - Cibinong - Jatijajar - Kp. Rambutan - Citerup - Pasar Rebo - Jati Asih - Pulogebang - Karawang - Klari - Semarang - Karanggede - Gemolong - Plupuh Executive 4 81 260302062720 06:30 Edit uVo Balik
select * from trayek where id>0 and `dr_agen`='3131' and `to_agen`='2123' and `kelas_armada`='4'
SELECT * from daily_rute_price where kode_rute='BO.409' and tgl>'2024-01-27' and tgl<'2026-03-02' and kursi_terjual>0 order by tgl
Array
(
    [id] => 232
    [kode_pergi] => BO.409
    [kelas_id] => 4
    [kode_rute_armada] => BO.409
    [kelas_armada] => 4
    [kode_pergi_v0] => 
    [kode_pulang] => GM.403
    [rute_pergi] => 
    [rute_pulang] => Plupuh - Gemolong - Semarang - Cikarang - Bekasi - Pd. Pinang - Kalideres - Cikokol - Bitung - Merak
    [url] => https://www.instagram.com/p/Cbt711hPW69/
    [info] => 
    [title] => Bogor-Bogor/tajur ke Sragen-Plupuh
    [dr_agent] => 
    [to_agent] => 
    [dr_cd] => BO
    [dr_ccd] => BO
    [dr_time] => 05:00
    [to_time] => 
    [hplus] => 0
    [to_cd] => 
    [to_ccd] => PL
    [create_at] => 2025-08-21 23:54:24
    [dr_city] => 313
    [dr_agen] => 3131
    [to_city] => 212
    [to_agen] => 2123
    [price_count] => 0
    [update_at] => 1742601411
    [capacity] => 28
    [price_per_seat] => 220000
    [j2] => 0
    [jalur_id] => 0
    [cron_at] => 1719710112
    [idklsitem] => 0
    [full] => 0
    [jalan] => 0
    [kursi_terjual] => 0
    [penawaran] => 0
    [omset] => 0
    [omset_at] => 0
    [id2] => 232
    [id_old] => 232
    [kelas_items] => 
    [nopols] => 
    [st] => 0
    [bl] => 1
    [cek_time] => 0
    [to_jak] => 0
)