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 | GN.402 | GN.402 | AD1413AU | 413 | MG | BI | Magetan - Kotabumi | Executive | 2024-04-16 | 0000-00-00 00:00:00 | 591170 | 630,000 | 34 | 0 | 34 | 21,420,000 | 100,00 | 1 | 2 | 5622 | 1 | 24-04-17 07:57:45 | jalurId | ||
| 4 | GN.402 | GN.402 | AD7571OF | 404 | MG | BI | Magetan - Kotabumi | Executive | 2024-04-13 | 0000-00-00 00:00:00 | 591164 | 630,000 | 30 | 0 | 30 | 18,900,000 | 100,00 | 1 | 7 | 5622 | 1 | 24-11-03 06:53:59 | jalurId | ||
| 3 | GN.402 | GN.402 | AD7383OA | 3029 | MG | BI | Magetan - Kotabumi | Executive | 2024-04-12 | 0000-00-00 00:00:00 | 591162 | 630,000 | 28 | 4 | 24 | 15,120,000 | 85,71 | 2 | 5622 | 1 | 25-06-27 12:37:45 | jalurId | |||
| 1 | GN.402 | GN.402 | AD7119OF | EX 411 | MG | BI | Magetan - Kotabumi | Executive | 2024-04-15 | 0000-00-00 00:00:00 | 591168 | 630,000 | 36 | 5 | 31 | 19,530,000 | 86,11 | 7 | 5622 | 1 | 25-07-21 00:20:43 | jalurId | |||
| 5 | GN.402 | GN.402 | AD1404AU | 408 | MG | BI | Magetan - Kotabumi | Executive | 2024-04-19 | 0000-00-00 00:00:00 | 591176 | 630,000 | 30 | 7 | 23 | 14,490,000 | 76,67 | 7 | 5622 | 1 | 25-07-02 19:47:24 | jalurId | |||
| 4 | GN.402 | GN.402 | MG | BI | Magetan - Kotabumi | Executive | 2024-04-17 | 0000-00-00 00:00:00 | 591172 | 630,000 | 30 | 0 | 30 | 18,900,000 | 100,00 | 1 | 2 | 5622 | 1 | 24-07-16 03:23:35 | jalurId | ||||
| 5 | GN.402 | GN.402 | AD1428AU | 911 | MG | BI | Magetan - Kotabumi | Executive | 2024-04-18 | 0000-00-00 00:00:00 | 591174 | 630,000 | 30 | 0 | 30 | 18,900,000 | 100,00 | 1 | 7 | 5622 | 1 | 25-05-15 12:56:18 | jalurId | ||
| 1 | GN.402 | GN.402 | AD7187OA | 3052 | MG | BI | Magetan - Kotabumi | Executive | 2024-04-22 | 0000-00-00 00:00:00 | 591182 | 675,000 | 30 | 0 | 30 | 20,250,000 | 100,00 | 1 | 2 | 5622 | 1 | 25-05-03 10:28:02 | jalurId | ||
| 2 | GN.402 | GN.402 | AD7406OA | 359 | MG | BI | Magetan - Kotabumi | Executive | 2024-04-21 | 0000-00-00 00:00:00 | 591180 | 675,000 | 30 | 0 | 30 | 20,250,000 | 100,00 | 1 | 7 | 5622 | 1 | 25-07-24 02:10:48 | jalurId | ||
| 5 | GN.402 | GN.402 | AD1428AU | 911 | MG | BI | Magetan - Kotabumi | Executive | 2024-04-20 | 0000-00-00 00:00:00 | 591178 | 630,000 | 30 | 3 | 27 | 17,010,000 | 90,00 | 7 | 5622 | 1 | 24-04-21 05:06:03 | jalurId | |||
| 1 | GN.402 | GN.402 | AD7184OF | 3127 | MG | BI | Magetan - Kotabumi | Executive | 2024-04-14 | 0000-00-00 00:00:00 | 591166 | 630,000 | 28 | 0 | 28 | 17,640,000 | 100,00 | 1 | 89 | 5622 | 1 | 24-07-17 07:18:35 | jalurId | ||
| 5 | GN.402 | GN.402 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-02 | 0000-00-00 00:00:00 | 706693 | 680,000 | 28 | 28 | 0 | 0 | 0,00 | 2 | 6501 | 1 | 25-08-08 15:06:11 | jalurId | |||||
| 4 | GN.402 | GN.402 | AD1478CU | 3092 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-03 | 0000-00-00 00:00:00 | 706695 | 680,000 | 30 | 1 | 29 | 19,720,000 | 96,67 | 7 | 6501 | 1 | 25-04-04 05:48:00 | jalurId | |||
| 3 | GN.402 | GN.402 | AD7157OF | 365 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-04 | 0000-00-00 00:00:00 | 706697 | 680,000 | 28 | 0 | 28 | 19,040,000 | 100,00 | 1 | 2 | 6501 | 1 | 25-06-20 07:28:48 | jalurId | ||
| 1 | GN.402 | GN.402 | AD7327OF | 3140 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-05 | 0000-00-00 00:00:00 | 706699 | 680,000 | 30 | 0 | 30 | 20,400,000 | 100,00 | 1 | 2 | 6501 | 1 | 25-04-06 06:18:58 | jalurId | ||
| 1 | GN.402 | GN.402 | AD7168OF | 370 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-06 | 0000-00-00 00:00:00 | 706701 | 680,000 | 28 | 0 | 28 | 19,040,000 | 100,00 | 1 | 2 | 6501 | 1 | 25-04-07 05:53:49 | jalurId | ||
| 5 | GN.402 | GN.402 | AD7443OF | 3035 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-07 | 0000-00-00 00:00:00 | 706703 | 680,000 | 28 | 0 | 28 | 19,040,000 | 100,00 | 1 | 2 | 6501 | 1 | 25-07-13 11:05:42 | jalurId | ||
| 5 | GN.402 | GN.402 | AD7462OF | 3126 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-08 | 0000-00-00 00:00:00 | 706705 | 385,000 | 30 | 0 | 30 | 11,550,000 | 100,00 | 1 | 89 | 6501 | 1 | 25-04-10 04:45:31 | jalurId | ||
| 3 | GN.402 | GN.402 | AD7173OF | 383 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-09 | 0000-00-00 00:00:00 | 706707 | 385,000 | 30 | 1 | 29 | 11,165,000 | 96,67 | 2 | 6501 | 1 | 25-04-15 04:45:21 | jalurId | |||
| 5 | GN.402 | GN.402 | AD7161OF | 366 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-10 | 0000-00-00 00:00:00 | 706709 | 385,000 | 30 | 0 | 30 | 11,550,000 | 100,00 | 1 | 2 | 6501 | 1 | 25-05-20 13:30:01 | jalurId | ||
| 5 | GN.402 | GN.402 | AD7182OF | 3128 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-11 | 0000-00-00 00:00:00 | 706711 | 310,000 | 28 | 0 | 28 | 8,680,000 | 100,00 | 1 | 89 | 6501 | 1 | 25-09-16 15:56:01 | jalurId | ||
| 2 | GN.402 | GN.402 | AD7328OF | 3014 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-12 | 0000-00-00 00:00:00 | 706713 | 310,000 | 28 | 0 | 28 | 8,680,000 | 100,00 | 1 | 2 | 6501 | 1 | 25-06-17 05:24:59 | jalurId | ||
| 3 | GN.402 | GN.402 | AD7279OA | 3024 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-13 | 0000-00-00 00:00:00 | 706715 | 310,000 | 28 | 0 | 28 | 8,680,000 | 100,00 | 1 | 2 | 6501 | 1 | 25-04-14 07:21:06 | jalurId | ||
| 3 | GN.402 | GN.402 | AD7184OF | 3127 | MG | BI | Magetan - Kotabumi | Executive | 2025-04-14 | 0000-00-00 00:00:00 | 706717 | 310,000 | 28 | 0 | 28 | 8,680,000 | 100,00 | 1 | 2 | 6501 | 1 | 25-05-31 11:02:34 | jalurId | ||
| 710 | 49 | 661 | 368,635,000 | 0,00 | 17 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='GN.402' 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 | 5622 | MG | BI | 4 | GN.402 | 591162 | 0000-00-00 00:00:00 | AD7383OA | 28 | 4 | 24 | 15,120,000 | |
| 2 | 2024-04-13 | 5622 | MG | BI | 4 | GN.402 | 591164 | 0000-00-00 00:00:00 | AD7571OF | 30 | 0 | 30 | 18,900,000 | 1 |
| 3 | 2024-04-14 | 5622 | MG | BI | 4 | GN.402 | 591166 | 0000-00-00 00:00:00 | AD7184OF | 28 | 0 | 28 | 17,640,000 | 1 |
| 4 | 2024-04-15 | 5622 | MG | BI | 4 | GN.402 | 591168 | 0000-00-00 00:00:00 | AD7119OF | 36 | 5 | 31 | 19,530,000 | |
| 5 | 2024-04-16 | 5622 | MG | BI | 4 | GN.402 | 591170 | 0000-00-00 00:00:00 | AD1413AU | 34 | 0 | 34 | 21,420,000 | 1 |
| 6 | 2024-04-17 | 5622 | MG | BI | 4 | GN.402 | 591172 | 0000-00-00 00:00:00 | 30 | 0 | 30 | 18,900,000 | 1 | |
| 7 | 2024-04-18 | 5622 | MG | BI | 4 | GN.402 | 591174 | 0000-00-00 00:00:00 | AD1428AU | 30 | 0 | 30 | 18,900,000 | 1 |
| 8 | 2024-04-19 | 5622 | MG | BI | 4 | GN.402 | 591176 | 0000-00-00 00:00:00 | AD1404AU | 30 | 7 | 23 | 14,490,000 | |
| 9 | 2024-04-20 | 5622 | MG | BI | 4 | GN.402 | 591178 | 0000-00-00 00:00:00 | AD1428AU | 30 | 3 | 27 | 17,010,000 | |
| 10 | 2024-04-21 | 5622 | MG | BI | 4 | GN.402 | 591180 | 0000-00-00 00:00:00 | AD7406OA | 30 | 0 | 30 | 20,250,000 | 1 |
| 11 | 2024-04-22 | 5622 | MG | BI | 4 | GN.402 | 591182 | 0000-00-00 00:00:00 | AD7187OA | 30 | 0 | 30 | 20,250,000 | 1 |
| 12 | 2025-04-03 | 6501 | MG | BI | 4 | GN.402 | 706695 | 0000-00-00 00:00:00 | AD1478CU | 30 | 1 | 29 | 19,720,000 | |
| 13 | 2025-04-04 | 6501 | MG | BI | 4 | GN.402 | 706697 | 0000-00-00 00:00:00 | AD7157OF | 28 | 0 | 28 | 19,040,000 | 1 |
| 14 | 2025-04-05 | 6501 | MG | BI | 4 | GN.402 | 706699 | 0000-00-00 00:00:00 | AD7327OF | 30 | 0 | 30 | 20,400,000 | 1 |
| 15 | 2025-04-06 | 6501 | MG | BI | 4 | GN.402 | 706701 | 0000-00-00 00:00:00 | AD7168OF | 28 | 0 | 28 | 19,040,000 | 1 |
| 16 | 2025-04-07 | 6501 | MG | BI | 4 | GN.402 | 706703 | 0000-00-00 00:00:00 | AD7443OF | 28 | 0 | 28 | 19,040,000 | 1 |
| 17 | 2025-04-08 | 6501 | MG | BI | 4 | GN.402 | 706705 | 0000-00-00 00:00:00 | AD7462OF | 30 | 0 | 30 | 11,550,000 | 1 |
| 18 | 2025-04-09 | 6501 | MG | BI | 4 | GN.402 | 706707 | 0000-00-00 00:00:00 | AD7173OF | 30 | 1 | 29 | 11,165,000 | |
| 19 | 2025-04-10 | 6501 | MG | BI | 4 | GN.402 | 706709 | 0000-00-00 00:00:00 | AD7161OF | 30 | 0 | 30 | 11,550,000 | 1 |
| 20 | 2025-04-11 | 6501 | MG | BI | 4 | GN.402 | 706711 | 0000-00-00 00:00:00 | AD7182OF | 28 | 0 | 28 | 8,680,000 | 1 |
| 21 | 2025-04-12 | 6501 | MG | BI | 4 | GN.402 | 706713 | 0000-00-00 00:00:00 | AD7328OF | 28 | 0 | 28 | 8,680,000 | 1 |
| 22 | 2025-04-13 | 6501 | MG | BI | 4 | GN.402 | 706715 | 0000-00-00 00:00:00 | AD7279OA | 28 | 0 | 28 | 8,680,000 | 1 |
| 23 | 2025-04-14 | 6501 | MG | BI | 4 | GN.402 | 706717 | 0000-00-00 00:00:00 | AD7184OF | 28 | 0 | 28 | 8,680,000 | 1 |
| 682 | 21 | 661 | 368,635,000 | 17 | ||||||||||
Array
(
[id] => 622
[kode_pergi] => GN.402
[kelas_id] => 4
[kode_rute_armada] => GN.402
[kelas_armada] => 4
[kode_pergi_v0] => MG.402
[kode_pulang] =>
[rute_pergi] => Magetan - Bekasi - Terminal Grogol - Kalideres - Poris Plawad - Cikokol - Bitung - Jatake - Kotabumi
[rute_pulang] =>
[url] =>
[info] =>
[title] => MAGETAN-MAGETAN ke TANGERANG-BITUNG
[dr_agent] =>
[to_agent] =>
[dr_cd] => GN
[dr_ccd] => MG
[dr_time] => 11:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => BI
[create_at] => 2025-09-07 09:52:22
[dr_city] => 129
[dr_agen] => 1292
[to_city] => 320
[to_agen] => 3151
[price_count] => 0
[update_at] => 1710990462
[capacity] => 0
[price_per_seat] => 630000
[j2] => 24
[jalur_id] => 6501
[cron_at] => 1713863780
[idklsitem] => 2
[full] => 17
[jalan] => 23
[kursi_terjual] => 661
[penawaran] => 24
[omset] => 368635000
[omset_at] => 20250522
[id2] => 622
[id_old] => 622
[kelas_items] => 2
[nopols] => AD1404AU, AD1413AU, AD1428AU, AD7119OF, AD7187OA, AD7406OA, AD7571OF
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)