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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | AM.102 | AM.102 | AD7289OF | 203 | MA | BO | Madiun - Bogor | SuperTop SHD | 2024-04-15 | 0000-00-00 00:00:00 | 591018 | 880,000 | 21 | 0 | 21 | 18,480,000 | 100,00 | 1 | 1 | 5606 | 1 | 25-05-04 10:53:40 | jalurId | ||
| 5 | AM.102 | AM.102 | MA | BO | Madiun - Bogor | SuperTop SHD | 2024-04-16 | 0000-00-00 00:00:00 | 591036 | 880,000 | 21 | 0 | 21 | 18,480,000 | 100,00 | 1 | 1 | 5606 | 1 | 24-04-17 07:59:12 | jalurId | ||||
| 4 | AM.102 | AM.102 | AD7289OF | 203 | MA | BO | Madiun - Bogor | SuperTop SHD | 2024-04-17 | 0000-00-00 00:00:00 | 591054 | 810,000 | 21 | 0 | 21 | 17,010,000 | 100,00 | 1 | 1 | 5606 | 1 | 24-12-19 08:11:25 | jalurId | ||
| 1 | AM.102 | AM.102 | AD7290OF | 204 | MA | BO | Madiun - Bogor | SuperTop SHD | 2024-04-18 | 0000-00-00 00:00:00 | 591072 | 810,000 | 21 | 0 | 21 | 17,010,000 | 100,00 | 1 | 1 | 5606 | 1 | 25-04-12 05:51:19 | jalurId | ||
| 5 | AM.102 | AM.102 | AD7289OF | 203 | MA | BO | Madiun - Bogor | SuperTop SHD | 2024-04-19 | 0000-00-00 00:00:00 | 591090 | 810,000 | 21 | 1 | 20 | 16,200,000 | 95,24 | 1 | 5606 | 1 | 24-07-25 14:16:28 | jalurId | |||
| 5 | AM.102 | AM.102 | AD7290OF | 204 | MA | BO | Madiun - Bogor | SuperTop SHD | 2024-04-20 | 0000-00-00 00:00:00 | 591108 | 810,000 | 21 | 2 | 19 | 15,390,000 | 90,48 | 58 | 5606 | 1 | 24-07-20 21:17:11 | jalurId | |||
| 1 | AM.102 | AM.102 | AD7290OF | 204 | MA | BO | Madiun - Bogor | SuperTop SHD | 2024-04-22 | 0000-00-00 00:00:00 | 591144 | 855,000 | 21 | 8 | 13 | 11,115,000 | 61,90 | 58 | 5606 | 1 | 24-12-13 14:22:04 | jalurId | |||
| 5 | AM.102 | AM.102 | AD7289OF | 203 | MA | BO | Madiun - Bogor | SuperTop SHD | 2024-04-21 | 0000-00-00 00:00:00 | 591126 | 855,000 | 21 | 0 | 21 | 17,955,000 | 100,00 | 1 | 1 | 5606 | 1 | 24-04-22 05:44:22 | jalurId | ||
| 5 | AM.102 | AM.102 | AD7290OF | 204 | MA | BO | Madiun - Bogor | SuperTop SHD | 2024-04-12 | 0000-00-00 00:00:00 | 590964 | 880,000 | 21 | 10 | 11 | 9,680,000 | 52,38 | 1 | 5606 | 1 | 25-10-01 15:45:11 | jalurId | |||
| 4 | AM.102 | AM.102 | AD7289OF | 203 | MA | BO | Madiun - Bogor | SuperTop SHD | 2024-04-13 | 0000-00-00 00:00:00 | 590982 | 880,000 | 21 | 0 | 21 | 18,480,000 | 100,00 | 1 | 1 | 5606 | 1 | 26-03-01 03:35:37 | jalurId | ||
| 3 | AM.102 | AM.102 | AD7290OF | 204 | MA | BO | Madiun - Bogor | SuperTop SHD | 2024-04-14 | 0000-00-00 00:00:00 | 591000 | 880,000 | 21 | 0 | 21 | 18,480,000 | 100,00 | 1 | 47 | 5606 | 1 | 24-12-07 15:44:44 | jalurId | ||
| 231 | 21 | 210 | 178,280,000 | 0,00 | 7 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='AM.102' and tgl>'2024-01-27' and tgl<'2026-03-07' 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 | 5606 | MA | BO | 1 | AM.102 | 590964 | 0000-00-00 00:00:00 | AD7290OF | 21 | 10 | 11 | 9,680,000 | |
| 2 | 2024-04-13 | 5606 | MA | BO | 1 | AM.102 | 590982 | 0000-00-00 00:00:00 | AD7289OF | 21 | 0 | 21 | 18,480,000 | 1 |
| 3 | 2024-04-14 | 5606 | MA | BO | 1 | AM.102 | 591000 | 0000-00-00 00:00:00 | AD7290OF | 21 | 0 | 21 | 18,480,000 | 1 |
| 4 | 2024-04-15 | 5606 | MA | BO | 1 | AM.102 | 591018 | 0000-00-00 00:00:00 | AD7289OF | 21 | 0 | 21 | 18,480,000 | 1 |
| 5 | 2024-04-16 | 5606 | MA | BO | 1 | AM.102 | 591036 | 0000-00-00 00:00:00 | 21 | 0 | 21 | 18,480,000 | 1 | |
| 6 | 2024-04-17 | 5606 | MA | BO | 1 | AM.102 | 591054 | 0000-00-00 00:00:00 | AD7289OF | 21 | 0 | 21 | 17,010,000 | 1 |
| 7 | 2024-04-18 | 5606 | MA | BO | 1 | AM.102 | 591072 | 0000-00-00 00:00:00 | AD7290OF | 21 | 0 | 21 | 17,010,000 | 1 |
| 8 | 2024-04-19 | 5606 | MA | BO | 1 | AM.102 | 591090 | 0000-00-00 00:00:00 | AD7289OF | 21 | 1 | 20 | 16,200,000 | |
| 9 | 2024-04-20 | 5606 | MA | BO | 1 | AM.102 | 591108 | 0000-00-00 00:00:00 | AD7290OF | 21 | 2 | 19 | 15,390,000 | |
| 10 | 2024-04-21 | 5606 | MA | BO | 1 | AM.102 | 591126 | 0000-00-00 00:00:00 | AD7289OF | 21 | 0 | 21 | 17,955,000 | 1 |
| 11 | 2024-04-22 | 5606 | MA | BO | 1 | AM.102 | 591144 | 0000-00-00 00:00:00 | AD7290OF | 21 | 8 | 13 | 11,115,000 | |
| 231 | 21 | 210 | 178,280,000 | 7 | ||||||||||
Array
(
[id] => 636
[kode_pergi] => AM.102
[kelas_id] => 1
[kode_rute_armada] => AM.102
[kelas_armada] => 1
[kode_pergi_v0] => MA.103
[kode_pulang] =>
[rute_pergi] => Madiun - Jati Asih - Kp.Rambutan - Cijantung - Pall - S. Depok - Cibinong - Bogor
[rute_pulang] =>
[url] =>
[info] =>
[title] => Madiun-Madiun Pool ke Bogor-Bogor/tajur
[dr_agent] =>
[to_agent] =>
[dr_cd] => AM
[dr_ccd] => MA
[dr_time] => 14:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => BO
[create_at] => 2025-09-07 09:52:22
[dr_city] => 127
[dr_agen] => 1271
[to_city] => 313
[to_agen] => 3131
[price_count] => 0
[update_at] => 1710990101
[capacity] => 0
[price_per_seat] => 765000
[j2] => 11
[jalur_id] => 5606
[cron_at] => 1713863788
[idklsitem] => 58
[full] => 7
[jalan] => 11
[kursi_terjual] => 210
[penawaran] => 11
[omset] => 178280000
[omset_at] => 20250522
[id2] => 636
[id_old] => 636
[kelas_items] => 47,58
[nopols] => AD7289OF, AD7290OF
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)