Trayek

PB ME BR TB LA | MR BI BO CB CG CI PG BK BD | PW WO JO SL KL BJ SM KS KP SR MT PL GM PA | MG MA PO TR BL SB ML JB
weekly_rute_web daily_rute_web Cek Rute Trayek List ByOmset List ByCustomer List ByJalan gen ar kd_armada 7-DailyOmset
PB ME BR TB LA | MR BI BO CB CG CI PG BK BD | PW WO JO SL KL BJ SM KS KP SR MT PL GM PA | MG MA PO TR BL SB ML JB
Prev Refresh

Rute pergi

# ID Rute dr to Menu
MR.111 7628 Merak - Solo - Ngawi - Madiun - Ponorogo - Trenggalek 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='MR.111' 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='MR.111' 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 MR.111 AD7433OA 210 SuperTop SHD 2026-03-04 834972 0 0 1 -1 0 0,00 47 7628 0 26-03-04 14:58:18 jalurId
0 1 -1 0 0,00 0
select * from daily_rute_price where kode_rute='MR.111' order by id limit 280
SELECT * from daily_rute_price where kode_rute='MR.111' and tgl>'2024-01-27' and tgl<'2026-04-27' and kursi_terjual>0 order by tgl
Array
(
    [id] => 1739
    [kode_pergi] => MR.111
    [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] => MR
    [dr_ccd] => 
    [dr_time] => 
    [to_time] => 
    [hplus] => 0
    [to_cd] => 
    [to_ccd] => 
    [create_at] => 2026-03-08 16:59:20
    [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] => 1739
    [id_old] => 1739
    [kelas_items] => 
    [nopols] => 
    [st] => 0
    [bl] => 0
    [cek_time] => 0
    [to_jak] => 0
)
Hiace Micro Bus Patas Pariwisata Executive Executive Plus Executive Plus SHD SuperTop SHD Executive Plus DD SuperTop DD FirstClass DD 5 SuperTopCombi ExecutivePlusCombi Tool Seq #0 Tool Seq #1 Tool Seq #2