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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | OJ.403 | OJ.403 | AD7672OF | 3143 | JO | BO | Yogya - Bogor | Executive | 2024-04-12 | 0000-00-00 00:00:00 | 592000 | 560,000 | 34 | 0 | 34 | 19,040,000 | 100,00 | 1 | 93 | 5703 | 1 | 24-04-13 05:18:11 | jalurId | ||
| 3 | OJ.403 | OJ.403 | AD7674OF | 3145 | JO | BO | Yogya - Bogor | Executive | 2024-04-13 | 0000-00-00 00:00:00 | 592005 | 560,000 | 34 | 0 | 34 | 19,040,000 | 100,00 | 1 | 93 | 5703 | 1 | 24-04-14 05:34:46 | jalurId | ||
| 2 | OJ.403 | OJ.403 | AD7672OF | 3143 | JO | BO | Yogya - Bogor | Executive | 2024-04-14 | 0000-00-00 00:00:00 | 592010 | 560,000 | 34 | 0 | 34 | 19,040,000 | 100,00 | 1 | 93 | 5703 | 1 | 24-10-26 10:03:43 | jalurId | ||
| 4 | OJ.403 | OJ.403 | AD7674OF | 3145 | JO | BO | Yogya - Bogor | Executive | 2024-04-15 | 0000-00-00 00:00:00 | 592015 | 560,000 | 35 | 0 | 35 | 19,600,000 | 100,00 | 1 | 93 | 5703 | 1 | 24-10-28 21:09:51 | jalurId | ||
| 1 | OJ.403 | OJ.403 | AD7672OF | 3143 | JO | BO | Yogya - Bogor | Executive | 2024-04-16 | 0000-00-00 00:00:00 | 592020 | 560,000 | 34 | 0 | 34 | 19,040,000 | 100,00 | 1 | 93 | 5703 | 1 | 24-10-28 18:15:19 | jalurId | ||
| 4 | OJ.403 | OJ.403 | AD7674OF | 3145 | JO | BO | Yogya - Bogor | Executive | 2024-04-17 | 0000-00-00 00:00:00 | 592025 | 560,000 | 36 | 0 | 36 | 20,160,000 | 100,00 | 1 | 93 | 5703 | 1 | 24-04-18 04:03:27 | jalurId | ||
| 2 | OJ.403 | OJ.403 | AD7672OF | 3143 | JO | BO | Yogya - Bogor | Executive | 2024-04-18 | 0000-00-00 00:00:00 | 592030 | 560,000 | 34 | 0 | 34 | 19,040,000 | 100,00 | 1 | 93 | 5703 | 1 | 24-12-31 02:54:49 | jalurId | ||
| 5 | OJ.403 | OJ.403 | AD7674OF | 3145 | JO | BO | Yogya - Bogor | Executive | 2024-04-19 | 0000-00-00 00:00:00 | 592035 | 560,000 | 34 | 2 | 32 | 17,920,000 | 94,12 | 93 | 5703 | 1 | 25-07-28 03:29:13 | jalurId | |||
| 3 | OJ.403 | OJ.403 | AD7672OF | 3143 | JO | BO | Yogya - Bogor | Executive | 2024-04-20 | 0000-00-00 00:00:00 | 592040 | 560,000 | 35 | 0 | 35 | 19,600,000 | 100,00 | 1 | 93 | 5703 | 1 | 24-04-21 05:06:55 | jalurId | ||
| 5 | OJ.403 | OJ.403 | AD7674OF | 3145 | JO | BO | Yogya - Bogor | Executive | 2024-04-21 | 0000-00-00 00:00:00 | 592045 | 420,000 | 34 | 0 | 34 | 14,280,000 | 100,00 | 1 | 93 | 5703 | 1 | 24-10-29 16:45:47 | jalurId | ||
| 2 | OJ.403 | OJ.403 | AD7672OF | 3143 | JO | BO | Yogya - Bogor | Executive | 2024-04-22 | 0000-00-00 00:00:00 | 592050 | 420,000 | 34 | 4 | 30 | 12,600,000 | 88,24 | 93 | 5703 | 1 | 25-03-31 16:59:13 | jalurId | |||
| 378 | 6 | 372 | 199,360,000 | 0,00 | 9 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='OJ.403' 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-12 | 5703 | JO | BO | 4 | OJ.403 | 592000 | 0000-00-00 00:00:00 | AD7672OF | 34 | 0 | 34 | 19,040,000 | 1 |
| 2 | 2024-04-13 | 5703 | JO | BO | 4 | OJ.403 | 592005 | 0000-00-00 00:00:00 | AD7674OF | 34 | 0 | 34 | 19,040,000 | 1 |
| 3 | 2024-04-14 | 5703 | JO | BO | 4 | OJ.403 | 592010 | 0000-00-00 00:00:00 | AD7672OF | 34 | 0 | 34 | 19,040,000 | 1 |
| 4 | 2024-04-15 | 5703 | JO | BO | 4 | OJ.403 | 592015 | 0000-00-00 00:00:00 | AD7674OF | 35 | 0 | 35 | 19,600,000 | 1 |
| 5 | 2024-04-16 | 5703 | JO | BO | 4 | OJ.403 | 592020 | 0000-00-00 00:00:00 | AD7672OF | 34 | 0 | 34 | 19,040,000 | 1 |
| 6 | 2024-04-17 | 5703 | JO | BO | 4 | OJ.403 | 592025 | 0000-00-00 00:00:00 | AD7674OF | 36 | 0 | 36 | 20,160,000 | 1 |
| 7 | 2024-04-18 | 5703 | JO | BO | 4 | OJ.403 | 592030 | 0000-00-00 00:00:00 | AD7672OF | 34 | 0 | 34 | 19,040,000 | 1 |
| 8 | 2024-04-19 | 5703 | JO | BO | 4 | OJ.403 | 592035 | 0000-00-00 00:00:00 | AD7674OF | 34 | 2 | 32 | 17,920,000 | |
| 9 | 2024-04-20 | 5703 | JO | BO | 4 | OJ.403 | 592040 | 0000-00-00 00:00:00 | AD7672OF | 35 | 0 | 35 | 19,600,000 | 1 |
| 10 | 2024-04-21 | 5703 | JO | BO | 4 | OJ.403 | 592045 | 0000-00-00 00:00:00 | AD7674OF | 34 | 0 | 34 | 14,280,000 | 1 |
| 11 | 2024-04-22 | 5703 | JO | BO | 4 | OJ.403 | 592050 | 0000-00-00 00:00:00 | AD7672OF | 34 | 4 | 30 | 12,600,000 | |
| 378 | 6 | 372 | 199,360,000 | 9 | ||||||||||
Array
(
[id] => 768
[kode_pergi] => OJ.403
[kelas_id] => 4
[kode_rute_armada] => OJ.403
[kelas_armada] => 4
[kode_pergi_v0] => JO.410
[kode_pulang] =>
[rute_pergi] => Yogya - Kebumen - Cikopo - Karawang - Cikarang - Jatijajar - P.Cibinong - Cibubur - Cileungsi - Bogor
[rute_pulang] =>
[url] =>
[info] =>
[title] => Yogyakarta-Rosin Yogya ke Bogor-Bogor/tajur
[dr_agent] =>
[to_agent] =>
[dr_cd] => OJ
[dr_ccd] => JO
[dr_time] => 13:30
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => BO
[create_at] => 2025-08-21 23:54:24
[dr_city] => 225
[dr_agen] => 2254
[to_city] => 313
[to_agen] => 3131
[price_count] => 0
[update_at] => 1711540448
[capacity] => 0
[price_per_seat] => 560000
[j2] => 11
[jalur_id] => 5703
[cron_at] => 1719710287
[idklsitem] => 2
[full] => 9
[jalan] => 11
[kursi_terjual] => 372
[penawaran] => 11
[omset] => 199360000
[omset_at] => 20250522
[id2] => 768
[id_old] => 768
[kelas_items] => 2
[nopols] => AD7672OF, AD7674OF
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)