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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | OB.903 | OB.903 | AD7288OF | 3013 | BO | ML | Bogor - Surabaya | Executive Plus SHD | 2024-04-01 | 0000-00-00 00:00:00 | 587025 | 545,000 | 30 | 12 | 18 | 9,810,000 | 60,00 | 55 | 5492 | 1 | 25-06-05 19:15:44 | jalurId | |||
| 5 | OB.903 | OB.903 | AD7292OF | 3008 | BO | ML | Bogor - Surabaya | Executive Plus SHD | 2024-04-02 | 0000-00-00 00:00:00 | 587048 | 545,000 | 30 | 1 | 29 | 15,805,000 | 96,67 | 55 | 5492 | 1 | 24-04-03 04:33:08 | jalurId | |||
| 1 | OB.903 | OB.903 | AD7288OF | 3013 | BO | ML | Bogor - Surabaya | Executive Plus SHD | 2024-04-03 | 0000-00-00 00:00:00 | 587071 | 545,000 | 30 | 0 | 30 | 16,350,000 | 100,00 | 1 | 55 | 5492 | 1 | 25-04-24 02:39:30 | jalurId | ||
| 3 | OB.903 | OB.903 | AD7292OF | 3008 | BO | ML | Bogor - Surabaya | Executive Plus SHD | 2024-04-04 | 0000-00-00 00:00:00 | 587094 | 545,000 | 31 | 1 | 30 | 16,350,000 | 96,77 | 55 | 5492 | 1 | 25-07-28 08:53:17 | jalurId | |||
| 3 | OB.903 | OB.903 | AD7288OF | 3013 | BO | ML | Bogor - Surabaya | Executive Plus SHD | 2024-04-05 | 0000-00-00 00:00:00 | 587117 | 755,000 | 30 | 0 | 30 | 22,650,000 | 100,00 | 1 | 55 | 5492 | 1 | 24-06-30 15:22:39 | jalurId | ||
| 3 | OB.903 | OB.903 | AD7292OF | 3008 | BO | ML | Bogor - Surabaya | Executive Plus SHD | 2024-04-06 | 0000-00-00 00:00:00 | 587140 | 755,000 | 30 | 1 | 29 | 21,895,000 | 96,67 | 55 | 5492 | 1 | 24-07-10 12:37:22 | jalurId | |||
| 2 | OB.903 | OB.903 | AD7288OF | 3013 | BO | ML | Bogor - Surabaya | Executive Plus SHD | 2024-04-07 | 0000-00-00 00:00:00 | 587163 | 755,000 | 30 | 1 | 29 | 21,895,000 | 96,67 | 55 | 5492 | 1 | 24-07-12 21:20:28 | jalurId | |||
| 5 | OB.903 | OB.903 | AD7292OF | 3008 | BO | ML | Bogor - Surabaya | Executive Plus SHD | 2024-04-08 | 0000-00-00 00:00:00 | 587186 | 755,000 | 30 | 0 | 30 | 22,650,000 | 100,00 | 1 | 55 | 5492 | 1 | 25-04-23 08:34:48 | jalurId | ||
| 2 | OB.903 | OB.903 | AD7288OF | 3013 | BO | ML | Bogor - Surabaya | Executive Plus SHD | 2024-04-09 | 0000-00-00 00:00:00 | 587209 | 755,000 | 30 | 9 | 21 | 15,855,000 | 70,00 | 55 | 5492 | 1 | 25-08-20 16:17:18 | jalurId | |||
| 0 | OB.903 | OB.903 | AD7292OF | 3008 | BO | ML | Bogor - Surabaya | Executive Plus SHD | 2024-04-10 | 0000-00-00 00:00:00 | 587232 | 545,000 | 30 | 2 | 28 | 15,260,000 | 93,33 | 55 | 5492 | 1 | 25-03-30 06:45:54 | jalurId | |||
| 0 | OB.903 | OB.903 | AD7288OF | 3013 | BO | ML | Bogor - Surabaya | Executive Plus SHD | 2024-04-11 | 0000-00-00 00:00:00 | 587255 | 545,000 | 30 | 9 | 21 | 11,445,000 | 70,00 | 55 | 5492 | 1 | 25-06-29 18:59:52 | jalurId | |||
| 2 | OB.903 | OB.903 | AD7432OA | 3090 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-03-22 | 0000-00-00 00:00:00 | 704135 | 510,000 | 28 | 0 | 28 | 14,280,000 | 100,00 | 1 | 4 | 6354 | 1 | 25-09-26 19:40:35 | jalurId | ||
| 2 | OB.903 | OB.903 | AD7295OF | 3011 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-03-21 | 0000-00-00 00:00:00 | 704113 | 510,000 | 30 | 1 | 29 | 14,790,000 | 96,67 | 55 | 6354 | 1 | 25-08-13 11:20:59 | jalurId | |||
| 2 | OB.903 | OB.903 | AD7295OF | 3011 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-03-23 | 0000-00-00 00:00:00 | 704157 | 510,000 | 30 | 0 | 30 | 15,300,000 | 100,00 | 1 | 55 | 6354 | 1 | 25-09-17 19:06:07 | jalurId | ||
| 2 | OB.903 | OB.903 | AD7287OF | 3012 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-03-24 | 0000-00-00 00:00:00 | 704179 | 535,000 | 30 | 0 | 30 | 16,050,000 | 100,00 | 1 | 55 | 6354 | 1 | 25-03-25 05:47:38 | jalurId | ||
| 3 | OB.903 | OB.903 | AD7295OF | 3011 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-03-25 | 0000-00-00 00:00:00 | 704201 | 535,000 | 30 | 1 | 29 | 15,515,000 | 96,67 | 55 | 6354 | 1 | 25-03-26 04:35:08 | jalurId | |||
| 3 | OB.903 | OB.903 | AD7287OF | 3012 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-03-26 | 0000-00-00 00:00:00 | 704223 | 805,000 | 30 | 0 | 30 | 24,150,000 | 100,00 | 1 | 55 | 6354 | 1 | 25-03-27 07:46:19 | jalurId | ||
| 3 | OB.903 | OB.903 | AD7295OF | 3011 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-03-27 | 0000-00-00 00:00:00 | 704245 | 805,000 | 30 | 0 | 30 | 24,150,000 | 100,00 | 1 | 55 | 6354 | 1 | 25-03-28 06:14:51 | jalurId | ||
| 3 | OB.903 | OB.903 | AD7287OF | 3012 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-03-28 | 0000-00-00 00:00:00 | 704267 | 805,000 | 30 | 0 | 30 | 24,150,000 | 100,00 | 1 | 55 | 6354 | 1 | 25-03-29 04:47:12 | jalurId | ||
| 3 | OB.903 | OB.903 | AD7295OF | 3011 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-03-29 | 0000-00-00 00:00:00 | 704289 | 805,000 | 31 | 2 | 29 | 23,345,000 | 93,55 | 55 | 6354 | 1 | 25-08-16 18:01:09 | jalurId | |||
| 3 | OB.903 | OB.903 | AD7287OF | 3012 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-03-30 | 0000-00-00 00:00:00 | 704311 | 805,000 | 30 | 7 | 23 | 18,515,000 | 76,67 | 55 | 6354 | 1 | 25-05-30 00:15:35 | jalurId | |||
| 3 | OB.903 | OB.903 | AD7295OF | 3011 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-03-31 | 0000-00-00 00:00:00 | 704333 | 510,000 | 30 | 0 | 30 | 15,300,000 | 100,00 | 1 | 55 | 6354 | 1 | 25-04-01 04:51:29 | jalurId | ||
| 3 | OB.903 | OB.903 | AD7287OF | 3012 | BO | ML | Bogor - Malang | Executive Plus SHD | 2025-04-01 | 0000-00-00 00:00:00 | 704355 | 510,000 | 30 | 1 | 29 | 14,790,000 | 96,67 | 55 | 6354 | 1 | 25-05-30 20:25:41 | jalurId | |||
| 0 | OB.903 | OB.903 | BO | ML | Bogor - Malang | Executive Plus SHD | 2026-03-13 | 826612 | 0 | 0 | 24 | -24 | 0 | 0,00 | 3 | 7365 | 0 | 26-02-26 13:58:18 | jalurId | ||||||
| 0 | OB.903 | OB.903 | BO | ML | Bogor - Malang | Executive Plus SHD | 2026-03-14 | 826641 | 0 | 0 | 21 | -21 | 0 | 0,00 | 3 | 7365 | 0 | 26-03-02 14:10:18 | jalurId | ||||||
| 0 | OB.903 | OB.903 | BO | ML | Bogor - Malang | Executive Plus SHD | 2026-03-15 | 826670 | 0 | 0 | 22 | -22 | 0 | 0,00 | 3 | 7365 | 0 | 26-03-02 14:06:20 | jalurId | ||||||
| 0 | OB.903 | OB.903 | BO | ML | Bogor - Malang | Executive Plus SHD | 2026-03-16 | 826699 | 0 | 0 | 23 | -23 | 0 | 0,00 | 3 | 7365 | 0 | 26-03-02 14:02:29 | jalurId | ||||||
| 0 | OB.903 | OB.903 | BO | ML | Bogor - Malang | Executive Plus SHD | 2026-03-17 | 826728 | 0 | 0 | 2 | -2 | 0 | 0,00 | 3 | 7365 | 0 | 26-03-02 13:58:18 | jalurId | ||||||
| 0 | OB.903 | OB.903 | BO | ML | Bogor - Malang | Executive Plus SHD | 2026-03-18 | 826757 | 0 | 0 | 0 | 0 | 0 | 0,00 | 3 | 7365 | 0 | 26-03-02 13:54:19 | jalurId | ||||||
| 0 | OB.903 | OB.903 | BO | ML | Bogor - Malang | Executive Plus SHD | 2026-03-19 | 826786 | 0 | 0 | 18 | -18 | 0 | 0,00 | 3 | 7365 | 0 | 26-03-02 13:50:18 | jalurId | ||||||
| 0 | OB.903 | OB.903 | BO | ML | Bogor - Malang | Executive Plus SHD | 2026-03-20 | 826815 | 0 | 0 | 13 | -13 | 0 | 0,00 | 3 | 7365 | 0 | 26-03-02 13:46:20 | jalurId | ||||||
| 0 | OB.903 | OB.903 | BO | ML | Bogor - Malang | Executive Plus SHD | 2026-03-21 | 826844 | 0 | 0 | 23 | -23 | 0 | 0,00 | 3 | 7365 | 0 | 26-03-02 13:42:19 | jalurId | ||||||
| 690 | 194 | 496 | 410,300,000 | 0,00 | 10 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='OB.903' 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-04-01 | 5492 | BO | ML | 9 | OB.903 | 587025 | 0000-00-00 00:00:00 | AD7288OF | 30 | 12 | 18 | 9,810,000 | |
| 2 | 2024-04-02 | 5492 | BO | ML | 9 | OB.903 | 587048 | 0000-00-00 00:00:00 | AD7292OF | 30 | 1 | 29 | 15,805,000 | |
| 3 | 2024-04-03 | 5492 | BO | ML | 9 | OB.903 | 587071 | 0000-00-00 00:00:00 | AD7288OF | 30 | 0 | 30 | 16,350,000 | 1 |
| 4 | 2024-04-04 | 5492 | BO | ML | 9 | OB.903 | 587094 | 0000-00-00 00:00:00 | AD7292OF | 31 | 1 | 30 | 16,350,000 | |
| 5 | 2024-04-05 | 5492 | BO | ML | 9 | OB.903 | 587117 | 0000-00-00 00:00:00 | AD7288OF | 30 | 0 | 30 | 22,650,000 | 1 |
| 6 | 2024-04-06 | 5492 | BO | ML | 9 | OB.903 | 587140 | 0000-00-00 00:00:00 | AD7292OF | 30 | 1 | 29 | 21,895,000 | |
| 7 | 2024-04-07 | 5492 | BO | ML | 9 | OB.903 | 587163 | 0000-00-00 00:00:00 | AD7288OF | 30 | 1 | 29 | 21,895,000 | |
| 8 | 2024-04-08 | 5492 | BO | ML | 9 | OB.903 | 587186 | 0000-00-00 00:00:00 | AD7292OF | 30 | 0 | 30 | 22,650,000 | 1 |
| 9 | 2024-04-09 | 5492 | BO | ML | 9 | OB.903 | 587209 | 0000-00-00 00:00:00 | AD7288OF | 30 | 9 | 21 | 15,855,000 | |
| 10 | 2024-04-10 | 5492 | BO | ML | 9 | OB.903 | 587232 | 0000-00-00 00:00:00 | AD7292OF | 30 | 2 | 28 | 15,260,000 | |
| 11 | 2024-04-11 | 5492 | BO | ML | 9 | OB.903 | 587255 | 0000-00-00 00:00:00 | AD7288OF | 30 | 9 | 21 | 11,445,000 | |
| 12 | 2025-03-21 | 6354 | BO | ML | 9 | OB.903 | 704113 | 0000-00-00 00:00:00 | AD7295OF | 30 | 1 | 29 | 14,790,000 | |
| 13 | 2025-03-22 | 6354 | BO | ML | 9 | OB.903 | 704135 | 0000-00-00 00:00:00 | AD7432OA | 28 | 0 | 28 | 14,280,000 | 1 |
| 14 | 2025-03-23 | 6354 | BO | ML | 9 | OB.903 | 704157 | 0000-00-00 00:00:00 | AD7295OF | 30 | 0 | 30 | 15,300,000 | 1 |
| 15 | 2025-03-24 | 6354 | BO | ML | 9 | OB.903 | 704179 | 0000-00-00 00:00:00 | AD7287OF | 30 | 0 | 30 | 16,050,000 | 1 |
| 16 | 2025-03-25 | 6354 | BO | ML | 9 | OB.903 | 704201 | 0000-00-00 00:00:00 | AD7295OF | 30 | 1 | 29 | 15,515,000 | |
| 17 | 2025-03-26 | 6354 | BO | ML | 9 | OB.903 | 704223 | 0000-00-00 00:00:00 | AD7287OF | 30 | 0 | 30 | 24,150,000 | 1 |
| 18 | 2025-03-27 | 6354 | BO | ML | 9 | OB.903 | 704245 | 0000-00-00 00:00:00 | AD7295OF | 30 | 0 | 30 | 24,150,000 | 1 |
| 19 | 2025-03-28 | 6354 | BO | ML | 9 | OB.903 | 704267 | 0000-00-00 00:00:00 | AD7287OF | 30 | 0 | 30 | 24,150,000 | 1 |
| 20 | 2025-03-29 | 6354 | BO | ML | 9 | OB.903 | 704289 | 0000-00-00 00:00:00 | AD7295OF | 31 | 2 | 29 | 23,345,000 | |
| 21 | 2025-03-30 | 6354 | BO | ML | 9 | OB.903 | 704311 | 0000-00-00 00:00:00 | AD7287OF | 30 | 7 | 23 | 18,515,000 | |
| 22 | 2025-03-31 | 6354 | BO | ML | 9 | OB.903 | 704333 | 0000-00-00 00:00:00 | AD7295OF | 30 | 0 | 30 | 15,300,000 | 1 |
| 23 | 2025-04-01 | 6354 | BO | ML | 9 | OB.903 | 704355 | 0000-00-00 00:00:00 | AD7287OF | 30 | 1 | 29 | 14,790,000 | |
| 690 | 48 | 642 | 410,300,000 | 10 | ||||||||||
Array
(
[id] => 508
[kode_pergi] => OB.903
[kelas_id] => 9
[kode_rute_armada] => OB.903
[kelas_armada] => 9
[kode_pergi_v0] => BO.905
[kode_pulang] =>
[rute_pergi] => Bogor - Citereup - Pintuair - S.Depok - Pall - Jati Asih - Cibitung - Nganjuk - Mojokerto - Surabaya
[rute_pulang] =>
[url] =>
[info] =>
[title] => Bogor-Bogor/tajur ke Surabaya-Sub Bungurasih
[dr_agent] =>
[to_agent] =>
[dr_cd] => OB
[dr_ccd] => BO
[dr_time] => 14:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => ML
[create_at] => 2026-03-02 11:08:03
[dr_city] => 313
[dr_agen] => 3131
[to_city] => 115
[to_agen] => 1151
[price_count] => 0
[update_at] => 1711076336
[capacity] => 0
[price_per_seat] => 545000
[j2] => 32
[jalur_id] => 6354
[cron_at] => 1719710074
[idklsitem] => 3
[full] => 10
[jalan] => 23
[kursi_terjual] => 642
[penawaran] => 23
[omset] => 410300000
[omset_at] => 20250522
[id2] => 508
[id_old] => 508
[kelas_items] => 3,4,55
[nopols] =>
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)