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.406 | OB.406 | AD7383OA | 3029 | BO | BL | Bogor - Blitar | Executive | 2024-04-01 | 0000-00-00 00:00:00 | 587021 | 440,000 | 30 | 0 | 30 | 13,200,000 | 100,00 | 1 | 7 | 5501 | 1 | 25-04-19 08:47:06 | jalurId | ||
| 5 | OB.406 | OB.406 | AD7294OF | 3010 | BO | BL | Bogor - Blitar | Executive | 2024-04-02 | 0000-00-00 00:00:00 | 587044 | 390,000 | 30 | 0 | 30 | 11,700,000 | 100,00 | 1 | 2 | 5501 | 1 | 25-06-18 11:19:41 | jalurId | ||
| 5 | OB.406 | OB.406 | AD7198OF | 390 | BO | BL | Bogor - Blitar | Executive | 2024-04-03 | 0000-00-00 00:00:00 | 587067 | 440,000 | 30 | 0 | 30 | 13,200,000 | 100,00 | 1 | 2 | 5501 | 1 | 25-01-07 07:34:35 | jalurId | ||
| 5 | OB.406 | OB.406 | AD7375OA | 3018 | BO | BL | Bogor - Blitar | Executive | 2024-04-04 | 0000-00-00 00:00:00 | 587090 | 440,000 | 30 | 1 | 29 | 12,760,000 | 96,67 | 7 | 5501 | 1 | 24-07-13 01:43:27 | jalurId | |||
| 2 | OB.406 | OB.406 | BO | BL | Bogor - Blitar | Executive | 2024-04-05 | 0000-00-00 00:00:00 | 587113 | 690,000 | 30 | 0 | 30 | 20,700,000 | 100,00 | 1 | 2 | 5501 | 1 | 24-04-06 04:43:20 | jalurId | ||||
| 2 | OB.406 | OB.406 | AD7156OF | 3002 | BO | BL | Bogor - Blitar | Executive | 2024-04-06 | 0000-00-00 00:00:00 | 587136 | 690,000 | 30 | 0 | 30 | 20,700,000 | 100,00 | 1 | 7 | 5501 | 1 | 25-03-11 06:53:48 | jalurId | ||
| 4 | OB.406 | OB.406 | AD7327OF | 3140 | BO | BL | Bogor - Blitar | Executive | 2024-04-07 | 0000-00-00 00:00:00 | 587159 | 690,000 | 30 | 0 | 30 | 20,700,000 | 100,00 | 1 | 7 | 5501 | 1 | 24-07-13 05:49:56 | jalurId | ||
| 5 | OB.406 | OB.406 | BO | BL | Bogor - Blitar | Executive | 2024-04-08 | 0000-00-00 00:00:00 | 587182 | 690,000 | 30 | 0 | 30 | 20,700,000 | 100,00 | 1 | 2 | 5501 | 1 | 25-01-03 13:22:32 | jalurId | ||||
| 3 | OB.406 | OB.406 | BO | BL | Bogor - Blitar | Executive | 2024-04-09 | 0000-00-00 00:00:00 | 587205 | 690,000 | 34 | 6 | 28 | 19,320,000 | 82,35 | 2 | 5501 | 1 | 25-03-10 22:36:03 | jalurId | |||||
| 0 | OB.406 | OB.406 | AD7268OA | 3030 | BO | BL | Bogor - Blitar | Executive | 2024-04-10 | 0000-00-00 00:00:00 | 587228 | 440,000 | 30 | 0 | 30 | 13,200,000 | 100,00 | 1 | 7 | 5501 | 1 | 25-07-17 08:59:45 | jalurId | ||
| 0 | OB.406 | OB.406 | AD7167OA | 3134 | BO | BL | Bogor - Blitar | Executive | 2024-04-11 | 0000-00-00 00:00:00 | 587251 | 440,000 | 30 | 0 | 30 | 13,200,000 | 100,00 | 1 | 7 | 5501 | 1 | 25-02-27 02:04:52 | jalurId | ||
| 334 | 7 | 327 | 179,380,000 | 0,00 | 9 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='OB.406' 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 | 5501 | BO | BL | 4 | OB.406 | 587021 | 0000-00-00 00:00:00 | AD7383OA | 30 | 0 | 30 | 13,200,000 | 1 |
| 2 | 2024-04-02 | 5501 | BO | BL | 4 | OB.406 | 587044 | 0000-00-00 00:00:00 | AD7294OF | 30 | 0 | 30 | 11,700,000 | 1 |
| 3 | 2024-04-03 | 5501 | BO | BL | 4 | OB.406 | 587067 | 0000-00-00 00:00:00 | AD7198OF | 30 | 0 | 30 | 13,200,000 | 1 |
| 4 | 2024-04-04 | 5501 | BO | BL | 4 | OB.406 | 587090 | 0000-00-00 00:00:00 | AD7375OA | 30 | 1 | 29 | 12,760,000 | |
| 5 | 2024-04-05 | 5501 | BO | BL | 4 | OB.406 | 587113 | 0000-00-00 00:00:00 | 30 | 0 | 30 | 20,700,000 | 1 | |
| 6 | 2024-04-06 | 5501 | BO | BL | 4 | OB.406 | 587136 | 0000-00-00 00:00:00 | AD7156OF | 30 | 0 | 30 | 20,700,000 | 1 |
| 7 | 2024-04-07 | 5501 | BO | BL | 4 | OB.406 | 587159 | 0000-00-00 00:00:00 | AD7327OF | 30 | 0 | 30 | 20,700,000 | 1 |
| 8 | 2024-04-08 | 5501 | BO | BL | 4 | OB.406 | 587182 | 0000-00-00 00:00:00 | 30 | 0 | 30 | 20,700,000 | 1 | |
| 9 | 2024-04-09 | 5501 | BO | BL | 4 | OB.406 | 587205 | 0000-00-00 00:00:00 | 34 | 6 | 28 | 19,320,000 | ||
| 10 | 2024-04-10 | 5501 | BO | BL | 4 | OB.406 | 587228 | 0000-00-00 00:00:00 | AD7268OA | 30 | 0 | 30 | 13,200,000 | 1 |
| 11 | 2024-04-11 | 5501 | BO | BL | 4 | OB.406 | 587251 | 0000-00-00 00:00:00 | AD7167OA | 30 | 0 | 30 | 13,200,000 | 1 |
| 334 | 7 | 327 | 179,380,000 | 9 | ||||||||||
Array
(
[id] => 481
[kode_pergi] => OB.406
[kelas_id] => 4
[kode_rute_armada] => OB.406
[kelas_armada] => 4
[kode_pergi_v0] => BO.408
[kode_pulang] =>
[rute_pergi] => Bogor - Nanggewer - P.Cibinong - Jatijajar - Citereup - Jatiasih - Bekasi - Solo - Ngawi - Caruban - Nganjuk - Kediri - Blitar
[rute_pulang] =>
[url] =>
[info] =>
[title] => Bogor-Bogor/tajur ke Blitar-Blitar Pool
[dr_agent] =>
[to_agent] =>
[dr_cd] => OB
[dr_ccd] => BO
[dr_time] => 15:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => BL
[create_at] => 2025-09-07 09:52:22
[dr_city] => 313
[dr_agen] => 3131
[to_city] => 119
[to_agen] => 1183
[price_count] => 0
[update_at] => 1711320659
[capacity] => 0
[price_per_seat] => 440000
[j2] => 11
[jalur_id] => 5501
[cron_at] => 1719710082
[idklsitem] => 2
[full] => 9
[jalan] => 11
[kursi_terjual] => 327
[penawaran] => 11
[omset] => 179380000
[omset_at] => 20250522
[id2] => 481
[id_old] => 481
[kelas_items] => 2,7
[nopols] =>
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)