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.701' 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 AM.701 AM.701 W7233UP PP 033 MA BI Madiun - Bitung (Pariwisata) Pariwisata 2025-04-07 0000-00-00 00:00:00 709759 525,000 45 0 45 23,625,000 100,00 1 91 6733 1 26-03-06 15:08:05 jalurId
3 AM.701 AM.701 W7052UZ PP 052 MA BI Madiun - Bitung (Pariwisata) Pariwisata 2025-04-06 0000-00-00 00:00:00 709757 525,000 45 5 40 21,000,000 88,89 91 6733 1 26-03-06 15:08:04 jalurId
3 AM.701 AM.701 H7789OC BS 15 MA BI Madiun - Bitung (Pariwisata) Pariwisata 2025-04-05 0000-00-00 00:00:00 709755 525,000 45 2 43 22,575,000 95,56 91 6733 1 26-03-06 15:08:22 jalurId
3 AM.701 AM.701 W7319UZ PP 019 MA BI Madiun - Bitung (Pariwisata) Pariwisata 2025-04-04 0000-00-00 00:00:00 709753 525,000 45 5 40 21,000,000 88,89 91 6733 1 26-03-06 15:08:36 jalurId
180 12 168 88,200,000 0,00 1
select * from daily_rute_price where kode_rute='AM.701' 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.701' and tgl>'2024-01-27' and tgl<'2026-04-17' 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 6733 MA BI 7 AM.701 709753 0000-00-00 00:00:00 W7319UZ 45 5 40 21,000,000
2 2025-04-05 6733 MA BI 7 AM.701 709755 0000-00-00 00:00:00 H7789OC 45 2 43 22,575,000
3 2025-04-06 6733 MA BI 7 AM.701 709757 0000-00-00 00:00:00 W7052UZ 45 5 40 21,000,000
4 2025-04-07 6733 MA BI 7 AM.701 709759 0000-00-00 00:00:00 W7233UP 45 0 45 23,625,000 1
180 12 168 88,200,000 1

Array
(
    [id] => 1354
    [kode_pergi] => AM.701
    [kelas_id] => 7
    [kode_rute_armada] => AM.701
    [kelas_armada] => 7
    [kode_pergi_v0] => 
    [kode_pulang] => 
    [rute_pergi] => Madiun - Ngawi - Cikarang - Bekasi - 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] => 07: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] => 1742769908
    [capacity] => 0
    [price_per_seat] => 525000
    [j2] => 4
    [jalur_id] => 6733
    [cron_at] => 0
    [idklsitem] => 91
    [full] => 2
    [jalan] => 4
    [kursi_terjual] => 174
    [penawaran] => 4
    [omset] => 91350000
    [omset_at] => 20250522
    [id2] => 1354
    [id_old] => 1354
    [kelas_items] => 
    [nopols] => 
    [st] => 0
    [bl] => 0
    [cek_time] => 0
    [to_jak] => 0
)