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 | IC.407 | IC.407 | CI | MA | Ciputat - Madiun | Executive | 2024-04-01 | 0000-00-00 00:00:00 | 587280 | 390,000 | 28 | 28 | 0 | 0 | 0,00 | 2 | 5529 | 1 | 25-04-30 13:54:12 | jalurId | |||||
| 1 | IC.407 | IC.407 | CI | MA | Ciputat - Madiun | Executive | 2024-04-02 | 0000-00-00 00:00:00 | 587307 | 390,000 | 30 | 0 | 30 | 11,700,000 | 100,00 | 1 | 2 | 5529 | 1 | 25-03-07 14:09:16 | jalurId | ||||
| 2 | IC.407 | IC.407 | CI | MA | Ciputat - Madiun | Executive | 2024-04-03 | 0000-00-00 00:00:00 | 587334 | 390,000 | 30 | 0 | 30 | 11,700,000 | 100,00 | 1 | 2 | 5529 | 1 | 25-05-21 00:50:32 | jalurId | ||||
| 5 | IC.407 | IC.407 | CI | MA | Ciputat - Madiun | Executive | 2024-04-04 | 0000-00-00 00:00:00 | 587361 | 390,000 | 34 | 6 | 28 | 10,920,000 | 82,35 | 2 | 5529 | 1 | 24-06-02 17:14:21 | jalurId | |||||
| 1 | IC.407 | IC.407 | CI | MA | Ciputat - Madiun | Executive | 2024-04-05 | 0000-00-00 00:00:00 | 587388 | 630,000 | 28 | 0 | 28 | 17,640,000 | 100,00 | 1 | 2 | 5529 | 1 | 24-04-06 04:43:33 | jalurId | ||||
| 5 | IC.407 | IC.407 | CI | MA | Ciputat - Madiun | Executive | 2024-04-06 | 0000-00-00 00:00:00 | 587415 | 630,000 | 28 | 1 | 27 | 17,010,000 | 96,43 | 2 | 5529 | 1 | 24-06-13 09:48:25 | jalurId | |||||
| 2 | IC.407 | IC.407 | CI | MA | Ciputat - Madiun | Executive | 2024-04-07 | 0000-00-00 00:00:00 | 587442 | 630,000 | 28 | 0 | 28 | 17,640,000 | 100,00 | 1 | 2 | 5529 | 1 | 25-03-08 07:10:37 | jalurId | ||||
| 2 | IC.407 | IC.407 | CI | MA | Ciputat - Madiun | Executive | 2024-04-08 | 0000-00-00 00:00:00 | 587469 | 630,000 | 30 | 3 | 27 | 17,010,000 | 90,00 | 2 | 5529 | 1 | 24-04-09 04:46:02 | jalurId | |||||
| 5 | IC.407 | IC.407 | CI | MA | Ciputat - Madiun | Executive | 2024-04-09 | 0000-00-00 00:00:00 | 587496 | 630,000 | 0 | 0 | 0 | 0 | 0,00 | 2 | 5529 | 1 | 26-07-29 13:53:43 | jalurId | |||||
| 3 | IC.407 | IC.407 | AD7176OF | 395 | CI | MA | Ciputat - Madiun | Executive | 2024-04-10 | 0000-00-00 00:00:00 | 587523 | 390,000 | 30 | 0 | 30 | 11,700,000 | 100,00 | 1 | 7 | 5529 | 1 | 25-03-04 07:16:30 | jalurId | ||
| 0 | IC.407 | IC.407 | CI | MA | Ciputat - Madiun | Executive | 2024-04-11 | 0000-00-00 00:00:00 | 587550 | 390,000 | 28 | 28 | 0 | 0 | 0,00 | 2 | 5529 | 1 | 24-04-12 04:43:30 | jalurId | |||||
| 294 | 66 | 228 | 115,320,000 | 0,00 | 5 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='IC.407' and tgl>'2024-01-27' and tgl<'2026-10-29' 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 | 5529 | CI | MA | 4 | IC.407 | 587307 | 0000-00-00 00:00:00 | 30 | 0 | 30 | 11,700,000 | 1 | |
| 2 | 2024-04-03 | 5529 | CI | MA | 4 | IC.407 | 587334 | 0000-00-00 00:00:00 | 30 | 0 | 30 | 11,700,000 | 1 | |
| 3 | 2024-04-04 | 5529 | CI | MA | 4 | IC.407 | 587361 | 0000-00-00 00:00:00 | 34 | 6 | 28 | 10,920,000 | ||
| 4 | 2024-04-05 | 5529 | CI | MA | 4 | IC.407 | 587388 | 0000-00-00 00:00:00 | 28 | 0 | 28 | 17,640,000 | 1 | |
| 5 | 2024-04-06 | 5529 | CI | MA | 4 | IC.407 | 587415 | 0000-00-00 00:00:00 | 28 | 1 | 27 | 17,010,000 | ||
| 6 | 2024-04-07 | 5529 | CI | MA | 4 | IC.407 | 587442 | 0000-00-00 00:00:00 | 28 | 0 | 28 | 17,640,000 | 1 | |
| 7 | 2024-04-08 | 5529 | CI | MA | 4 | IC.407 | 587469 | 0000-00-00 00:00:00 | 30 | 3 | 27 | 17,010,000 | ||
| 8 | 2024-04-10 | 5529 | CI | MA | 4 | IC.407 | 587523 | 0000-00-00 00:00:00 | AD7176OF | 30 | 0 | 30 | 11,700,000 | 1 |
| 238 | 10 | 228 | 115,320,000 | 5 | ||||||||||
Array
(
[id] => 471
[kode_pergi] => IC.407
[kelas_id] => 4
[kode_rute_armada] => IC.407
[kelas_armada] => 4
[kode_pergi_v0] => CI.404
[kode_pulang] =>
[rute_pergi] => Ciputat - P.Pinang - Pasar Minggu - Kp.Rambutan - Semarang - Solo - Ngawi - Madiun
[rute_pulang] =>
[url] =>
[info] =>
[title] => Tangerang Selatan-Ciputat Baru ke Madiun-Madiun Pool
[dr_agent] =>
[to_agent] =>
[dr_cd] => IC
[dr_ccd] => CI
[dr_time] => 16:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => MA
[create_at] => 2026-10-27 13:36:17
[dr_city] => 319
[dr_agen] => 3191
[to_city] => 127
[to_agen] => 1271
[price_count] => 0
[update_at] => 1710750340
[capacity] => 0
[price_per_seat] => 390000
[j2] => 11
[jalur_id] => 5529
[cron_at] => 1719709719
[idklsitem] => 2
[full] => 6
[jalan] => 8
[kursi_terjual] => 228
[penawaran] => 11
[omset] => 115320000
[omset_at] => 20261028
[id2] => 471
[id_old] => 471
[kelas_items] => 2
[nopols] =>
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)