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.103 | AM.103 | AD1454CU | 3188 | MA | CI | Madiun - Ciputat | SuperTop SHD | 2024-04-15 | 0000-00-00 00:00:00 | 591019 | 880,000 | 22 | 0 | 22 | 19,360,000 | 100,00 | 1 | 1 | 5607 | 1 | 24-12-10 21:49:05 | jalurId | ||
| 5 | AM.103 | AM.103 | MA | CI | Madiun - Ciputat | SuperTop SHD | 2024-04-16 | 0000-00-00 00:00:00 | 591037 | 880,000 | 21 | 0 | 21 | 18,480,000 | 100,00 | 1 | 47 | 5607 | 1 | 25-06-08 03:27:53 | jalurId | ||||
| 3 | AM.103 | AM.103 | AD1454CU | 3188 | MA | CI | Madiun - Ciputat | SuperTop SHD | 2024-04-17 | 0000-00-00 00:00:00 | 591055 | 810,000 | 21 | 0 | 21 | 17,010,000 | 100,00 | 1 | 47 | 5607 | 1 | 24-12-09 03:12:08 | jalurId | ||
| 4 | AM.103 | AM.103 | AD1454CU | 3188 | MA | CI | Madiun - Ciputat | SuperTop SHD | 2024-04-19 | 0000-00-00 00:00:00 | 591091 | 810,000 | 21 | 0 | 21 | 17,010,000 | 100,00 | 1 | 47 | 5607 | 1 | 24-11-28 13:42:21 | jalurId | ||
| 4 | AM.103 | AM.103 | AD1454CU | 3188 | MA | CI | Madiun - Ciputat | SuperTop SHD | 2024-04-21 | 0000-00-00 00:00:00 | 591127 | 855,000 | 21 | 0 | 21 | 17,955,000 | 100,00 | 1 | 47 | 5607 | 1 | 26-03-04 05:30:00 | jalurId | ||
| 5 | AM.103 | AM.103 | AD1453CU | MA | CI | Madiun - Ciputat | SuperTop SHD | 2024-04-22 | 0000-00-00 00:00:00 | 591145 | 855,000 | 21 | 8 | 13 | 11,115,000 | 61,90 | 58 | 5607 | 1 | 24-07-01 05:37:29 | jalurId | ||||
| 2 | AM.103 | AM.103 | AD1454CU | 3188 | MA | CI | Madiun - Ciputat | SuperTop SHD | 2024-04-13 | 0000-00-00 00:00:00 | 590983 | 880,000 | 21 | 0 | 21 | 18,480,000 | 100,00 | 1 | 47 | 5607 | 1 | 25-02-03 14:39:42 | jalurId | ||
| 3 | AM.103 | AM.103 | AD1453CU | MA | CI | Madiun - Ciputat | SuperTop SHD | 2024-04-20 | 0000-00-00 00:00:00 | 591109 | 810,000 | 21 | 4 | 17 | 13,770,000 | 80,95 | 47 | 5607 | 1 | 24-07-11 21:24:43 | jalurId | ||||
| 1 | AM.103 | AM.103 | AD1453CU | MA | CI | Madiun - Ciputat | SuperTop SHD | 2024-04-12 | 0000-00-00 00:00:00 | 590965 | 880,000 | 21 | 5 | 16 | 14,080,000 | 76,19 | 47 | 5607 | 1 | 26-03-04 05:30:46 | jalurId | ||||
| 4 | AM.103 | AM.103 | AD1453CU | MA | CI | Madiun - Ciputat | SuperTop SHD | 2024-04-14 | 0000-00-00 00:00:00 | 591001 | 880,000 | 21 | 0 | 21 | 18,480,000 | 100,00 | 1 | 47 | 5607 | 1 | 24-04-15 05:29:25 | jalurId | |||
| 4 | AM.103 | AM.103 | AD1453CU | MA | CI | Madiun - Ciputat | SuperTop SHD | 2024-04-18 | 0000-00-00 00:00:00 | 591073 | 810,000 | 21 | 0 | 21 | 17,010,000 | 100,00 | 1 | 47 | 5607 | 1 | 26-02-26 09:41:24 | jalurId | |||
| 232 | 17 | 215 | 182,750,000 | 0,00 | 8 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='AM.103' and tgl>'2024-01-27' and tgl<'2026-08-09' 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 | 5607 | MA | CI | 1 | AM.103 | 590965 | 0000-00-00 00:00:00 | AD1453CU | 21 | 5 | 16 | 14,080,000 | |
| 2 | 2024-04-13 | 5607 | MA | CI | 1 | AM.103 | 590983 | 0000-00-00 00:00:00 | AD1454CU | 21 | 0 | 21 | 18,480,000 | 1 |
| 3 | 2024-04-14 | 5607 | MA | CI | 1 | AM.103 | 591001 | 0000-00-00 00:00:00 | AD1453CU | 21 | 0 | 21 | 18,480,000 | 1 |
| 4 | 2024-04-15 | 5607 | MA | CI | 1 | AM.103 | 591019 | 0000-00-00 00:00:00 | AD1454CU | 22 | 0 | 22 | 19,360,000 | 1 |
| 5 | 2024-04-16 | 5607 | MA | CI | 1 | AM.103 | 591037 | 0000-00-00 00:00:00 | 21 | 0 | 21 | 18,480,000 | 1 | |
| 6 | 2024-04-17 | 5607 | MA | CI | 1 | AM.103 | 591055 | 0000-00-00 00:00:00 | AD1454CU | 21 | 0 | 21 | 17,010,000 | 1 |
| 7 | 2024-04-18 | 5607 | MA | CI | 1 | AM.103 | 591073 | 0000-00-00 00:00:00 | AD1453CU | 21 | 0 | 21 | 17,010,000 | 1 |
| 8 | 2024-04-19 | 5607 | MA | CI | 1 | AM.103 | 591091 | 0000-00-00 00:00:00 | AD1454CU | 21 | 0 | 21 | 17,010,000 | 1 |
| 9 | 2024-04-20 | 5607 | MA | CI | 1 | AM.103 | 591109 | 0000-00-00 00:00:00 | AD1453CU | 21 | 4 | 17 | 13,770,000 | |
| 10 | 2024-04-21 | 5607 | MA | CI | 1 | AM.103 | 591127 | 0000-00-00 00:00:00 | AD1454CU | 21 | 0 | 21 | 17,955,000 | 1 |
| 11 | 2024-04-22 | 5607 | MA | CI | 1 | AM.103 | 591145 | 0000-00-00 00:00:00 | AD1453CU | 21 | 8 | 13 | 11,115,000 | |
| 232 | 17 | 215 | 182,750,000 | 8 | ||||||||||
Array
(
[id] => 639
[kode_pergi] => AM.103
[kelas_id] => 1
[kode_rute_armada] => AM.103
[kelas_armada] => 1
[kode_pergi_v0] => MA.104
[kode_pulang] =>
[rute_pergi] => Madiun - Cikarang - Kp. Rambutan - Pasar Rebo - Ciputat
[rute_pulang] =>
[url] =>
[info] =>
[title] => Madiun-Madiun Pool ke Tangerang Selatan-Ciputat Baru
[dr_agent] =>
[to_agent] =>
[dr_cd] => AM
[dr_ccd] => MA
[dr_time] => 14:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => CI
[create_at] => 2026-06-29 15:23:00
[dr_city] => 127
[dr_agen] => 1271
[to_city] => 319
[to_agen] => 3191
[price_count] => 0
[update_at] => 1710990011
[capacity] => 0
[price_per_seat] => 765000
[j2] => 11
[jalur_id] => 5607
[cron_at] => 1713863796
[idklsitem] => 58
[full] => 8
[jalan] => 11
[kursi_terjual] => 215
[penawaran] => 11
[omset] => 182750000
[omset_at] => 20260630
[id2] => 639
[id_old] => 639
[kelas_items] => 1,47,58
[nopols] => AD1453CU, AD1454CU
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)