Prev Refresh
ID Rute Rute Kelas Kode Kota Agen at - at Kota Agen Harga Seat c3 Sales cID Menu
select * from daily_price where kode_rute='AM.702' 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
4 AM.702 AM.702 H7863OC BS 04 MA BI Madiun - Bitung (Pariwisata) Pariwisata 2025-04-07 0000-00-00 00:00:00 709760 525,000 45 0 45 23,625,000 100,00 1 91 6734 1 25-04-09 04:45:37 jalurId
4 AM.702 AM.702 H7859OC BS 27 MA BI Madiun - Bitung (Pariwisata) Pariwisata 2025-04-06 0000-00-00 00:00:00 709758 525,000 45 4 41 21,525,000 91,11 91 6734 1 25-05-18 03:08:57 jalurId
4 AM.702 AM.702 H7798OC BS 22 MA BI Madiun - Bitung (Pariwisata) Pariwisata 2025-04-05 0000-00-00 00:00:00 709756 525,000 45 2 43 22,575,000 95,56 91 6734 1 25-08-05 14:30:12 jalurId
4 AM.702 AM.702 W7142UP PP 042 MA BI Madiun - Bitung (Pariwisata) Pariwisata 2025-04-04 0000-00-00 00:00:00 709754 525,000 45 0 45 23,625,000 100,00 1 91 6734 1 25-04-05 06:13:05 jalurId
180 6 174 91,350,000 0,00 2
select * from daily_rute_price where kode_rute='AM.702' order by id limit 280
# cdPergi cdPergi drCity drAgen toCity toAgen Rute Pergi NoPol c3 cdBalik Url Kelas Kls Jum Update time Menu
1354 AM.701 127 1271 320 3151 Madiun-Madiun Pool ke Tangerang-Bitung Madiun - Ngawi - Cikarang - Bekasi - Cikokol - Bitung (Pariwisata) Pariwisata 7 4 250324054508 07:00 Edit uVo Balik
1355 AM.702 127 1271 320 3151 Madiun-Madiun Pool ke Tangerang-Bitung Madiun - Ngawi - Cikarang - Bekasi - Pd. Pinang - Cikokol - Bitung (Pariwisata) Pariwisata 7 4 250324054458 16:00 Edit uVo Balik
select * from trayek where id>0 and `dr_agen`='1271' and `to_agen`='3151' and `kelas_armada`='7'
SELECT * from daily_rute_price where kode_rute='AM.702' and tgl>'2024-01-27' and tgl<'2026-03-02' and kursi_terjual>0 order by tgl
# Tgl jId dr to kelas kode bid time nopol seat open cus omset fl
1 2025-04-04 6734 MA BI 7 AM.702 709754 0000-00-00 00:00:00 W7142UP 45 0 45 23,625,000 1
2 2025-04-05 6734 MA BI 7 AM.702 709756 0000-00-00 00:00:00 H7798OC 45 2 43 22,575,000
3 2025-04-06 6734 MA BI 7 AM.702 709758 0000-00-00 00:00:00 H7859OC 45 4 41 21,525,000
4 2025-04-07 6734 MA BI 7 AM.702 709760 0000-00-00 00:00:00 H7863OC 45 0 45 23,625,000 1
180 6 174 91,350,000 2

Array
(
    [id] => 1355
    [kode_pergi] => AM.702
    [kelas_id] => 7
    [kode_rute_armada] => AM.702
    [kelas_armada] => 7
    [kode_pergi_v0] => 
    [kode_pulang] => 
    [rute_pergi] => Madiun - Ngawi - Cikarang - Bekasi - Pd. Pinang - Cikokol - Bitung (Pariwisata)
    [rute_pulang] => 
    [url] => 
    [info] => 
    [title] => Madiun-Madiun Pool ke Tangerang-Bitung
    [dr_agent] => 
    [to_agent] => 
    [dr_cd] => AM
    [dr_ccd] => MA
    [dr_time] => 16:00
    [to_time] => 
    [hplus] => 0
    [to_cd] => 
    [to_ccd] => BI
    [create_at] => 2025-09-07 09:52:22
    [dr_city] => 127
    [dr_agen] => 1271
    [to_city] => 320
    [to_agen] => 3151
    [price_count] => 0
    [update_at] => 1742769898
    [capacity] => 0
    [price_per_seat] => 525000
    [j2] => 4
    [jalur_id] => 6734
    [cron_at] => 0
    [idklsitem] => 91
    [full] => 3
    [jalan] => 4
    [kursi_terjual] => 176
    [penawaran] => 4
    [omset] => 92400000
    [omset_at] => 20250522
    [id2] => 1355
    [id_old] => 1355
    [kelas_items] => 
    [nopols] => 
    [st] => 0
    [bl] => 0
    [cek_time] => 0
    [to_jak] => 0
)