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='SJO.101' 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 SJO.101 SJO.101 NC9898AD RC0808N Rute untuk testing - Rute untuk testing Executive 2024-03-13 0000-00-00 00:00:00 592356 730,100 1 0 1 730,100 100,00 1 2 4809 1 26-01-06 23:39:38 jalurId
0 SJO.101 SJO.101 NC9898AD RC0808N Rute untuk testing - Rute untuk testing Executive 2024-03-14 0000-00-00 00:00:00 592364 730,100 1 0 1 730,100 100,00 1 2 4809 1 25-12-21 23:32:36 jalurId
0 SJO.101 SJO.101 NC9898AD RC0808N Rute untuk testing - Rute untuk testing Executive 2024-03-15 0000-00-00 00:00:00 592370 570,000 1 0 1 570,000 100,00 1 2 4809 1 25-01-18 20:50:35 jalurId
5 SJO.101 SJO.101 NC9898AD RC0808N Rute untuk testing - Rute untuk testing Executive 2024-03-18 0000-00-00 00:00:00 592523 570,000 2 0 2 1,140,000 100,00 1 2 4809 1 24-03-19 05:22:25 jalurId
0 SJO.101 SJO.101 NC9898AD RC0808N Rute untuk testing - Rute untuk testing Executive 2024-03-20 0000-00-00 00:00:00 592541 570,000 1 0 1 570,000 100,00 1 2 4809 1 24-03-21 04:40:45 jalurId
6 0 6 3,740,200 0,00 5
select * from daily_rute_price where kode_rute='SJO.101' order by id limit 280
# cdPergi cdPergi drCity drAgen toCity toAgen Rute Pergi NoPol c3 cdBalik Url Kelas Kls Jum Update time Menu
142 BL.301 119 1183 422 4172 BLITAR-BLITAR POOL ke LAMPUNG-KOTABUMI LPX Blitar, Kediri, Nganjuk, Ngawi, Serpong, Cilegon, Merak, Lampung, Kotabumi AD1423CU, AD1424CU, AD1425CU, AD1426CU, AD1523EF, AD7022OF, AD7027OF, AD7077OF, 2,84 LA.301 Executive 4 758 260302062603 09:55 Edit uVo Balik
350 SJO.102 119 1183 422 4172 BLITAR-BLITAR POOL ke LAMPUNG-KOTABUMI LPX Blitar, Kediri, Nganjuk, Ngawi, Serpong, Cilegon, Merak, Lampung, Kotabumi Executive 4 4 231224075217 09:30 Edit uVo Balik
352 SJO.101 119 1183 422 4172 BLITAR-BLITAR POOL ke LAMPUNG-KOTABUMI LPX Blitar, Kediri, Nganjuk, Ngawi, Serpong, Cilegon, Merak, Lampung, Kotabumi NC9898AD 2 Executive 4 5 231224075032 09:30 Edit uVo Balik
600 LB.301 BL.301 119 1183 422 4172 BLITAR-BLITAR POOL ke LAMPUNG-KOTABUMI LPX Blitar - Lampung - Metro - Bandar jaya - Kotabumi AD1423CU, AD1424CU, AD1425CU, AD1426CU 84 Executive 4 24 240321082656 09:55 Edit uVo Balik
select * from trayek where id>0 and `dr_agen`='1183' and `to_agen`='4172' and `kelas_armada`='4'
SELECT * from daily_rute_price where kode_rute='SJO.101' 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 2024-03-13 4809 4 SJO.101 592356 0000-00-00 00:00:00 NC9898AD 1 0 1 730,100 1
2 2024-03-14 4809 4 SJO.101 592364 0000-00-00 00:00:00 NC9898AD 1 0 1 730,100 1
3 2024-03-15 4809 4 SJO.101 592370 0000-00-00 00:00:00 NC9898AD 1 0 1 570,000 1
4 2024-03-18 4809 4 SJO.101 592523 0000-00-00 00:00:00 NC9898AD 2 0 2 1,140,000 1
5 2024-03-20 4809 4 SJO.101 592541 0000-00-00 00:00:00 NC9898AD 1 0 1 570,000 1
6 0 6 3,740,200 5

Array
(
    [id] => 352
    [kode_pergi] => SJO.101
    [kelas_id] => 4
    [kode_rute_armada] => SJO.101
    [kelas_armada] => 4
    [kode_pergi_v0] => 
    [kode_pulang] => 
    [rute_pergi] => Blitar, Kediri, Nganjuk, Ngawi, Serpong, Cilegon, Merak, Lampung, Kotabumi
    [rute_pulang] => Kotabumi, Lampung, Merak, Nganjuk, Kediri, Blitar
    [url] => 
    [info] => 
    [title] => BLITAR-BLITAR POOL ke LAMPUNG-KOTABUMI LPX
    [dr_agent] => 
    [to_agent] => 
    [dr_cd] => SJ
    [dr_ccd] => 
    [dr_time] => 09:30
    [to_time] => 
    [hplus] => 0
    [to_cd] => 
    [to_ccd] => 
    [create_at] => 2025-09-07 09:52:22
    [dr_city] => 119
    [dr_agen] => 1183
    [to_city] => 422
    [to_agen] => 4172
    [price_count] => 0
    [update_at] => 1703379032
    [capacity] => 28
    [price_per_seat] => 430000
    [j2] => 5
    [jalur_id] => 4809
    [cron_at] => 1713863854
    [idklsitem] => 0
    [full] => 5
    [jalan] => 4
    [kursi_terjual] => 5
    [penawaran] => 5
    [omset] => 3010100
    [omset_at] => 20250522
    [id2] => 352
    [id_old] => 352
    [kelas_items] => 2
    [nopols] => NC9898AD
    [st] => 0
    [bl] => 0
    [cek_time] => 0
    [to_jak] => 0
)