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
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
| ID | Rute | Rute | Kelas | Kode | Kota | Agen | at | - | at | Kota | Agen | Harga | Seat | c3 | Sales | cID | Menu |
|---|
| # | 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 | ||||||||||||||||||||
| # | 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 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
)