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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | OB.301 | OB.301 | AD7343OA | 3102 | BO | BL | Bogor - Palembang | Executive Plus | 2024-04-01 | 0000-00-00 00:00:00 | 587013 | 515,000 | 28 | 0 | 28 | 14,420,000 | 100,00 | 1 | 86 | 5493 | 1 | 25-04-30 16:07:16 | jalurId | ||
| 1 | OB.301 | OB.301 | AD7345OA | 3101 | BO | BL | Bogor - Palembang | Executive Plus | 2024-04-02 | 0000-00-00 00:00:00 | 587036 | 515,000 | 29 | 0 | 29 | 14,935,000 | 100,00 | 1 | 86 | 5493 | 1 | 25-12-22 09:17:57 | jalurId | ||
| 4 | OB.301 | OB.301 | AD7343OA | 3102 | BO | BL | Bogor - Palembang | Executive Plus | 2024-04-03 | 0000-00-00 00:00:00 | 587059 | 515,000 | 28 | 0 | 28 | 14,420,000 | 100,00 | 1 | 86 | 5493 | 1 | 25-03-07 06:52:42 | jalurId | ||
| 5 | OB.301 | OB.301 | AD7345OA | 3101 | BO | BL | Bogor - Palembang | Executive Plus | 2024-04-04 | 0000-00-00 00:00:00 | 587082 | 515,000 | 28 | 0 | 28 | 14,420,000 | 100,00 | 1 | 86 | 5493 | 1 | 25-05-14 00:29:21 | jalurId | ||
| 2 | OB.301 | OB.301 | AD7343OA | 3102 | BO | BL | Bogor - Palembang | Executive Plus | 2024-04-05 | 0000-00-00 00:00:00 | 587105 | 625,000 | 28 | 0 | 28 | 17,500,000 | 100,00 | 1 | 86 | 5493 | 1 | 25-05-21 15:06:01 | jalurId | ||
| 2 | OB.301 | OB.301 | AD7345OA | 3101 | BO | BL | Bogor - Palembang | Executive Plus | 2024-04-06 | 0000-00-00 00:00:00 | 587128 | 625,000 | 28 | 0 | 28 | 17,500,000 | 100,00 | 1 | 86 | 5493 | 1 | 25-04-30 18:14:53 | jalurId | ||
| 1 | OB.301 | OB.301 | AD7343OA | 3102 | BO | BL | Bogor - Palembang | Executive Plus | 2024-04-07 | 0000-00-00 00:00:00 | 587151 | 625,000 | 28 | 0 | 28 | 17,500,000 | 100,00 | 1 | 86 | 5493 | 1 | 24-04-08 05:32:54 | jalurId | ||
| 5 | OB.301 | OB.301 | AD7345OA | 3101 | BO | BL | Bogor - Palembang | Executive Plus | 2024-04-08 | 0000-00-00 00:00:00 | 587174 | 625,000 | 28 | 0 | 28 | 17,500,000 | 100,00 | 1 | 86 | 5493 | 1 | 25-02-26 23:36:18 | jalurId | ||
| 4 | OB.301 | OB.301 | AD7343OA | 3102 | BO | BL | Bogor - Palembang | Executive Plus | 2024-04-09 | 0000-00-00 00:00:00 | 587197 | 625,000 | 28 | 0 | 28 | 17,500,000 | 100,00 | 1 | 86 | 5493 | 1 | 25-02-26 21:42:12 | jalurId | ||
| 0 | OB.301 | OB.301 | AD7345OA | 3101 | BO | BL | Bogor - Palembang | Executive Plus | 2024-04-10 | 0000-00-00 00:00:00 | 587220 | 515,000 | 28 | 0 | 28 | 14,420,000 | 100,00 | 1 | 86 | 5493 | 1 | 24-04-11 05:32:05 | jalurId | ||
| 0 | OB.301 | OB.301 | AD7343OA | 3102 | BO | BL | Bogor - Palembang | Executive Plus | 2024-04-11 | 0000-00-00 00:00:00 | 587243 | 515,000 | 28 | 9 | 19 | 9,785,000 | 67,86 | 86 | 5493 | 1 | 24-11-23 16:36:08 | jalurId | |||
| 4 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-03-22 | 0000-00-00 00:00:00 | 704123 | 505,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-07-11 04:37:53 | jalurId | |||||
| 4 | OB.301 | OB.301 | AD7741OF | 2002 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-03-21 | 0000-00-00 00:00:00 | 704101 | 505,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-06-01 21:30:57 | jalurId | |||
| 4 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-03-23 | 0000-00-00 00:00:00 | 704145 | 505,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-04-19 02:05:34 | jalurId | |||||
| 4 | OB.301 | OB.301 | AD7635OF | 2001 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-03-24 | 0000-00-00 00:00:00 | 704167 | 530,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-06-05 01:56:21 | jalurId | |||
| 5 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-03-25 | 0000-00-00 00:00:00 | 704189 | 530,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-07-29 02:30:03 | jalurId | |||||
| 5 | OB.301 | OB.301 | AD7635OF | 2001 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-03-26 | 0000-00-00 00:00:00 | 704211 | 805,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-05-03 09:00:10 | jalurId | |||
| 5 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-03-27 | 0000-00-00 00:00:00 | 704233 | 805,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-05-17 12:37:07 | jalurId | |||||
| 5 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-03-28 | 0000-00-00 00:00:00 | 704255 | 805,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-05-20 14:56:39 | jalurId | |||||
| 5 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-03-29 | 0000-00-00 00:00:00 | 704277 | 805,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-03-30 04:41:15 | jalurId | |||||
| 5 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-03-30 | 0000-00-00 00:00:00 | 704299 | 805,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-03-31 06:32:55 | jalurId | |||||
| 5 | OB.301 | OB.301 | AD7741OF | 2002 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-03-31 | 0000-00-00 00:00:00 | 704321 | 505,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-05-05 22:56:03 | jalurId | |||
| 5 | OB.301 | OB.301 | AD7741OF | 2002 | BO | BL | Bogor - Blitar | Executive Plus SHD | 2025-04-01 | 0000-00-00 00:00:00 | 704343 | 505,000 | 28 | 28 | 0 | 0 | 0,00 | 4 | 6342 | 1 | 25-05-07 12:46:20 | jalurId | |||
| 0 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus | 2026-03-13 | 826601 | 0 | 0 | 16 | -16 | 0 | 0,00 | 5 | 7354 | 0 | 26-03-02 14:14:18 | jalurId | ||||||
| 0 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus | 2026-03-14 | 826630 | 0 | 0 | 15 | -15 | 0 | 0,00 | 5 | 7354 | 0 | 26-03-02 14:10:18 | jalurId | ||||||
| 0 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus | 2026-03-15 | 826659 | 0 | 0 | 19 | -19 | 0 | 0,00 | 5 | 7354 | 0 | 26-03-02 14:06:20 | jalurId | ||||||
| 0 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus | 2026-03-16 | 826688 | 0 | 0 | 21 | -21 | 0 | 0,00 | 5 | 7354 | 0 | 26-03-02 14:02:29 | jalurId | ||||||
| 0 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus | 2026-03-17 | 826717 | 0 | 0 | 0 | 0 | 0 | 0,00 | 5 | 7354 | 0 | 26-03-02 13:58:18 | jalurId | ||||||
| 0 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus | 2026-03-18 | 826746 | 0 | 0 | 0 | 0 | 0 | 0,00 | 5 | 7354 | 0 | 26-03-02 13:54:19 | jalurId | ||||||
| 0 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus | 2026-03-19 | 826775 | 0 | 0 | 3 | -3 | 0 | 0,00 | 5 | 7354 | 0 | 26-03-02 13:50:18 | jalurId | ||||||
| 0 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus | 2026-03-20 | 826804 | 0 | 0 | 7 | -7 | 0 | 0,00 | 5 | 7354 | 0 | 26-03-02 13:46:20 | jalurId | ||||||
| 0 | OB.301 | OB.301 | BO | BL | Bogor - Blitar | Executive Plus | 2026-03-21 | 826833 | 0 | 0 | 23 | -23 | 0 | 0,00 | 5 | 7354 | 0 | 26-03-02 13:42:19 | jalurId | ||||||
| 645 | 449 | 196 | 169,900,000 | 0,00 | 10 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='OB.301' 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 | 5493 | BO | BL | 3 | OB.301 | 587013 | 0000-00-00 00:00:00 | AD7343OA | 28 | 0 | 28 | 14,420,000 | 1 |
| 2 | 2024-04-02 | 5493 | BO | BL | 3 | OB.301 | 587036 | 0000-00-00 00:00:00 | AD7345OA | 29 | 0 | 29 | 14,935,000 | 1 |
| 3 | 2024-04-03 | 5493 | BO | BL | 3 | OB.301 | 587059 | 0000-00-00 00:00:00 | AD7343OA | 28 | 0 | 28 | 14,420,000 | 1 |
| 4 | 2024-04-04 | 5493 | BO | BL | 3 | OB.301 | 587082 | 0000-00-00 00:00:00 | AD7345OA | 28 | 0 | 28 | 14,420,000 | 1 |
| 5 | 2024-04-05 | 5493 | BO | BL | 3 | OB.301 | 587105 | 0000-00-00 00:00:00 | AD7343OA | 28 | 0 | 28 | 17,500,000 | 1 |
| 6 | 2024-04-06 | 5493 | BO | BL | 3 | OB.301 | 587128 | 0000-00-00 00:00:00 | AD7345OA | 28 | 0 | 28 | 17,500,000 | 1 |
| 7 | 2024-04-07 | 5493 | BO | BL | 3 | OB.301 | 587151 | 0000-00-00 00:00:00 | AD7343OA | 28 | 0 | 28 | 17,500,000 | 1 |
| 8 | 2024-04-08 | 5493 | BO | BL | 3 | OB.301 | 587174 | 0000-00-00 00:00:00 | AD7345OA | 28 | 0 | 28 | 17,500,000 | 1 |
| 9 | 2024-04-09 | 5493 | BO | BL | 3 | OB.301 | 587197 | 0000-00-00 00:00:00 | AD7343OA | 28 | 0 | 28 | 17,500,000 | 1 |
| 10 | 2024-04-10 | 5493 | BO | BL | 3 | OB.301 | 587220 | 0000-00-00 00:00:00 | AD7345OA | 28 | 0 | 28 | 14,420,000 | 1 |
| 11 | 2024-04-11 | 5493 | BO | BL | 3 | OB.301 | 587243 | 0000-00-00 00:00:00 | AD7343OA | 28 | 9 | 19 | 9,785,000 | |
| 309 | 9 | 300 | 169,900,000 | 10 | ||||||||||
Array
(
[id] => 501
[kode_pergi] => OB.301
[kelas_id] => 3
[kode_rute_armada] => OB.301
[kelas_armada] => 3
[kode_pergi_v0] => BO.302
[kode_pulang] =>
[rute_pergi] => Bogor - Kp.Rambutan - Pd.Pinang - Bitung - Merak - Lampung - Bandar Jaya - Kayu Agung - Indralaya - Palembang
[rute_pulang] =>
[url] =>
[info] =>
[title] => BOGOR-BOGOR/TAJUR ke PALEMBANG-PALEMBANG
[dr_agent] =>
[to_agent] =>
[dr_cd] => OB
[dr_ccd] => BO
[dr_time] => 14:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => BL
[create_at] => 2026-03-01 01:08:03
[dr_city] => 313
[dr_agen] => 3131
[to_city] => 411
[to_agen] => 4111
[price_count] => 0
[update_at] => 1711076347
[capacity] => 0
[price_per_seat] => 515000
[j2] => 31
[jalur_id] => 6342
[cron_at] => 1719710058
[idklsitem] => 86
[full] => 10
[jalan] => 11
[kursi_terjual] => 300
[penawaran] => 23
[omset] => 169900000
[omset_at] => 20250522
[id2] => 501
[id_old] => 501
[kelas_items] => 86
[nopols] => AD7343OA, AD7345OA
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)