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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | MK.407 | MK.407 | AD7286OA | 339 | MR | KP | Merak - Yogyakarta | Executive | 2024-04-01 | 0000-00-00 00:00:00 | 586437 | 390,000 | 30 | 30 | 0 | 0 | 0,00 | 7 | 5446 | 1 | 25-03-26 18:33:40 | jalurId | |||
| 5 | MK.407 | MK.407 | AD1407AU | 912 | MR | KP | Merak - Yogyakarta | Executive | 2024-04-02 | 0000-00-00 00:00:00 | 586457 | 390,000 | 30 | 23 | 7 | 2,730,000 | 23,33 | 7 | 5446 | 1 | 24-07-14 16:12:31 | jalurId | |||
| 5 | MK.407 | MK.407 | AD7286OA | 339 | MR | KP | Merak - Yogyakarta | Executive | 2024-04-03 | 0000-00-00 00:00:00 | 586477 | 390,000 | 30 | 14 | 16 | 6,240,000 | 53,33 | 7 | 5446 | 1 | 26-02-08 14:04:55 | jalurId | |||
| 1 | MK.407 | MK.407 | AD7193OF | 378 | MR | KP | Merak - Yogyakarta | Executive | 2024-04-04 | 0000-00-00 00:00:00 | 586497 | 390,000 | 30 | 0 | 30 | 11,700,000 | 100,00 | 1 | 7 | 5446 | 1 | 25-05-03 10:51:09 | jalurId | ||
| 4 | MK.407 | MK.407 | AD7286OA | 339 | MR | KP | Merak - Yogyakarta | Executive | 2024-04-05 | 0000-00-00 00:00:00 | 586517 | 590,000 | 30 | 2 | 28 | 16,520,000 | 93,33 | 7 | 5446 | 1 | 25-11-16 02:42:44 | jalurId | |||
| 1 | MK.407 | MK.407 | AD7508OH | 401 | MR | KP | Merak - Yogyakarta | Executive | 2024-04-06 | 0000-00-00 00:00:00 | 586537 | 590,000 | 30 | 0 | 30 | 17,700,000 | 100,00 | 1 | 7 | 5446 | 1 | 25-05-20 08:04:05 | jalurId | ||
| 2 | MK.407 | MK.407 | AD7286OA | 339 | MR | KP | Merak - Yogyakarta | Executive | 2024-04-07 | 0000-00-00 00:00:00 | 586557 | 590,000 | 30 | 1 | 29 | 17,110,000 | 96,67 | 7 | 5446 | 1 | 25-05-11 11:32:13 | jalurId | |||
| 4 | MK.407 | MK.407 | AD7260OF | 326 | MR | KP | Merak - Yogyakarta | Executive | 2024-04-08 | 0000-00-00 00:00:00 | 586577 | 590,000 | 30 | 0 | 30 | 17,700,000 | 100,00 | 1 | 7 | 5446 | 1 | 24-12-07 07:26:37 | jalurId | ||
| 4 | MK.407 | MK.407 | AD7286OA | 339 | MR | KP | Merak - Yogyakarta | Executive | 2024-04-09 | 0000-00-00 00:00:00 | 586597 | 590,000 | 31 | 0 | 31 | 18,290,000 | 100,00 | 1 | 7 | 5446 | 1 | 25-06-10 15:26:44 | jalurId | ||
| 0 | MK.407 | MK.407 | AD7260OF | 326 | MR | KP | Merak - Yogyakarta | Executive | 2024-04-10 | 0000-00-00 00:00:00 | 586617 | 390,000 | 27 | 0 | 27 | 10,530,000 | 100,00 | 1 | 7 | 5446 | 1 | 25-05-21 10:26:07 | jalurId | ||
| 0 | MK.407 | MK.407 | AD7286OA | 339 | MR | KP | Merak - Yogyakarta | Executive | 2024-04-11 | 0000-00-00 00:00:00 | 586637 | 390,000 | 30 | 7 | 23 | 8,970,000 | 76,67 | 7 | 5446 | 1 | 25-06-11 03:17:22 | jalurId | |||
| 5 | MK.407 | MK.407 | AD7407OH | 3147 | MR | KP | Merak - Palur | Executive | 2025-03-21 | 0000-00-00 00:00:00 | 709613 | 385,000 | 34 | 34 | 0 | 0 | 0,00 | 93 | 6696 | 1 | 25-05-11 05:17:10 | jalurId | |||
| 362 | 111 | 251 | 127,490,000 | 0,00 | 5 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='MK.407' and tgl>'2024-01-27' and tgl<'2026-04-24' and kursi_terjual>0 order by tgl
| # | Tgl | jId | dr | to | kelas | kode | bid | time | nopol | seat | open | cus | omset | fl |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2024-04-02 | 5446 | MR | KP | 4 | MK.407 | 586457 | 0000-00-00 00:00:00 | AD1407AU | 30 | 23 | 7 | 2,730,000 | |
| 2 | 2024-04-03 | 5446 | MR | KP | 4 | MK.407 | 586477 | 0000-00-00 00:00:00 | AD7286OA | 30 | 14 | 16 | 6,240,000 | |
| 3 | 2024-04-04 | 5446 | MR | KP | 4 | MK.407 | 586497 | 0000-00-00 00:00:00 | AD7193OF | 30 | 0 | 30 | 11,700,000 | 1 |
| 4 | 2024-04-05 | 5446 | MR | KP | 4 | MK.407 | 586517 | 0000-00-00 00:00:00 | AD7286OA | 30 | 2 | 28 | 16,520,000 | |
| 5 | 2024-04-06 | 5446 | MR | KP | 4 | MK.407 | 586537 | 0000-00-00 00:00:00 | AD7508OH | 30 | 0 | 30 | 17,700,000 | 1 |
| 6 | 2024-04-07 | 5446 | MR | KP | 4 | MK.407 | 586557 | 0000-00-00 00:00:00 | AD7286OA | 30 | 1 | 29 | 17,110,000 | |
| 7 | 2024-04-08 | 5446 | MR | KP | 4 | MK.407 | 586577 | 0000-00-00 00:00:00 | AD7260OF | 30 | 0 | 30 | 17,700,000 | 1 |
| 8 | 2024-04-09 | 5446 | MR | KP | 4 | MK.407 | 586597 | 0000-00-00 00:00:00 | AD7286OA | 31 | 0 | 31 | 18,290,000 | 1 |
| 9 | 2024-04-10 | 5446 | MR | KP | 4 | MK.407 | 586617 | 0000-00-00 00:00:00 | AD7260OF | 27 | 0 | 27 | 10,530,000 | 1 |
| 10 | 2024-04-11 | 5446 | MR | KP | 4 | MK.407 | 586637 | 0000-00-00 00:00:00 | AD7286OA | 30 | 7 | 23 | 8,970,000 | |
| 298 | 47 | 251 | 127,490,000 | 5 | ||||||||||
Array
(
[id] => 507
[kode_pergi] => MK.407
[kelas_id] => 4
[kode_rute_armada] => MK.407
[kelas_armada] => 4
[kode_pergi_v0] => MR.413
[kode_pulang] =>
[rute_pergi] => Merak - Cilegon - Serang - Ajibarang - Kebumen - Yogyakarta
[rute_pulang] =>
[url] =>
[info] =>
[title] => Merak-Merak Lama ke Yogyakarta-Rosin Yogya
[dr_agent] =>
[to_agent] =>
[dr_cd] => MK
[dr_ccd] => MR
[dr_time] => 11:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => KP
[create_at] => 2025-09-07 09:52:22
[dr_city] => 323
[dr_agen] => 3111
[to_city] => 225
[to_agen] => 2254
[price_count] => 0
[update_at] => 1711320240
[capacity] => 0
[price_per_seat] => 390000
[j2] => 12
[jalur_id] => 6696
[cron_at] => 1719710127
[idklsitem] => 7
[full] => 5
[jalan] => 10
[kursi_terjual] => 251
[penawaran] => 12
[omset] => 127490000
[omset_at] => 20250522
[id2] => 507
[id_old] => 507
[kelas_items] => 7
[nopols] => AD1407AU, AD7193OF, AD7286OA, AD7508OH
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)