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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | IC.902 | IC.902 | AD1477CU | 3093 | CI | ML | Ciputat - Malang | Executive Plus SHD | 2024-04-01 | 0000-00-00 00:00:00 | 587282 | 555,000 | 34 | 8 | 26 | 14,430,000 | 76,47 | 67 | 5520 | 1 | 26-04-22 20:20:57 | jalurId | |||
| 2 | IC.902 | IC.902 | AD1478CU | 3092 | CI | ML | Ciputat - Malang | Executive Plus SHD | 2024-04-02 | 0000-00-00 00:00:00 | 587309 | 555,000 | 36 | 3 | 33 | 18,315,000 | 91,67 | 67 | 5520 | 1 | 25-04-28 15:27:43 | jalurId | |||
| 5 | IC.902 | IC.902 | CI | ML | Ciputat - Malang | Executive Plus SHD | 2024-04-03 | 0000-00-00 00:00:00 | 587336 | 555,000 | 36 | 0 | 36 | 19,980,000 | 100,00 | 1 | 67 | 5520 | 1 | 24-04-04 04:22:37 | jalurId | ||||
| 2 | IC.902 | IC.902 | AD7406OH | 3148 | CI | ML | Ciputat - Malang | Executive Plus SHD | 2024-04-04 | 0000-00-00 00:00:00 | 587363 | 555,000 | 34 | 0 | 34 | 18,870,000 | 100,00 | 1 | 67 | 5520 | 1 | 24-04-05 03:44:39 | jalurId | ||
| 2 | IC.902 | IC.902 | AD1477CU | 3093 | CI | ML | Ciputat - Malang | Executive Plus SHD | 2024-04-05 | 0000-00-00 00:00:00 | 587390 | 755,000 | 36 | 3 | 33 | 24,915,000 | 91,67 | 67 | 5520 | 1 | 25-09-23 18:15:05 | jalurId | |||
| 5 | IC.902 | IC.902 | AD1478CU | 3092 | CI | ML | Ciputat - Malang | Executive Plus SHD | 2024-04-06 | 0000-00-00 00:00:00 | 587417 | 755,000 | 37 | 0 | 37 | 27,935,000 | 100,00 | 1 | 67 | 5520 | 1 | 26-02-05 00:13:50 | jalurId | ||
| 3 | IC.902 | IC.902 | AD1477CU | 3093 | CI | ML | Ciputat - Malang | Executive Plus SHD | 2024-04-07 | 0000-00-00 00:00:00 | 587444 | 755,000 | 0 | 0 | 0 | 0 | 0,00 | 67 | 5520 | 1 | 26-10-05 10:15:15 | jalurId | |||
| 4 | IC.902 | IC.902 | AD1478CU | 3092 | CI | ML | Ciputat - Malang | Executive Plus SHD | 2024-04-08 | 0000-00-00 00:00:00 | 587471 | 755,000 | 0 | 0 | 0 | 0 | 0,00 | 67 | 5520 | 1 | 26-10-23 05:20:46 | jalurId | |||
| 2 | IC.902 | IC.902 | AD1477CU | 3093 | CI | ML | Ciputat - Malang | Executive Plus SHD | 2024-04-09 | 0000-00-00 00:00:00 | 587498 | 755,000 | 36 | 2 | 34 | 25,670,000 | 94,44 | 67 | 5520 | 1 | 25-06-03 04:19:23 | jalurId | |||
| 3 | IC.902 | IC.902 | AD1478CU | 3092 | CI | ML | Ciputat - Malang | Executive Plus SHD | 2024-04-10 | 0000-00-00 00:00:00 | 587525 | 555,000 | 36 | 1 | 35 | 19,425,000 | 97,22 | 67 | 5520 | 1 | 25-03-05 20:24:29 | jalurId | |||
| 0 | IC.902 | IC.902 | AD1478CU | 3092 | CI | ML | Ciputat - Malang | Executive Plus SHD | 2024-04-11 | 0000-00-00 00:00:00 | 587552 | 555,000 | 36 | 2 | 34 | 18,870,000 | 94,44 | 67 | 5520 | 1 | 25-07-27 00:52:49 | jalurId | |||
| 321 | 19 | 302 | 188,410,000 | 0,00 | 3 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='IC.902' 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-01 | 5520 | CI | ML | 9 | IC.902 | 587282 | 0000-00-00 00:00:00 | AD1477CU | 34 | 8 | 26 | 14,430,000 | |
| 2 | 2024-04-02 | 5520 | CI | ML | 9 | IC.902 | 587309 | 0000-00-00 00:00:00 | AD1478CU | 36 | 3 | 33 | 18,315,000 | |
| 3 | 2024-04-03 | 5520 | CI | ML | 9 | IC.902 | 587336 | 0000-00-00 00:00:00 | 36 | 0 | 36 | 19,980,000 | 1 | |
| 4 | 2024-04-04 | 5520 | CI | ML | 9 | IC.902 | 587363 | 0000-00-00 00:00:00 | AD7406OH | 34 | 0 | 34 | 18,870,000 | 1 |
| 5 | 2024-04-05 | 5520 | CI | ML | 9 | IC.902 | 587390 | 0000-00-00 00:00:00 | AD1477CU | 36 | 3 | 33 | 24,915,000 | |
| 6 | 2024-04-06 | 5520 | CI | ML | 9 | IC.902 | 587417 | 0000-00-00 00:00:00 | AD1478CU | 37 | 0 | 37 | 27,935,000 | 1 |
| 7 | 2024-04-09 | 5520 | CI | ML | 9 | IC.902 | 587498 | 0000-00-00 00:00:00 | AD1477CU | 36 | 2 | 34 | 25,670,000 | |
| 8 | 2024-04-10 | 5520 | CI | ML | 9 | IC.902 | 587525 | 0000-00-00 00:00:00 | AD1478CU | 36 | 1 | 35 | 19,425,000 | |
| 9 | 2024-04-11 | 5520 | CI | ML | 9 | IC.902 | 587552 | 0000-00-00 00:00:00 | AD1478CU | 36 | 2 | 34 | 18,870,000 | |
| 321 | 19 | 302 | 188,410,000 | 3 | ||||||||||
Array
(
[id] => 480
[kode_pergi] => IC.902
[kelas_id] => 9
[kode_rute_armada] => IC.902
[kelas_armada] => 9
[kode_pergi_v0] => CI.905
[kode_pulang] =>
[rute_pergi] => Ciputat - P.Pinang - Ps. Rebo - Kp.Rambutan - Cikarang - Surabaya - Malang
[rute_pulang] =>
[url] =>
[info] =>
[title] => Tangerang Selatan-Ciputat Baru ke Malang-Malang Pool
[dr_agent] =>
[to_agent] =>
[dr_cd] => IC
[dr_ccd] => CI
[dr_time] => 13:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => ML
[create_at] => 2026-10-27 13:36:17
[dr_city] => 319
[dr_agen] => 3191
[to_city] => 124
[to_agen] => 1241
[price_count] => 0
[update_at] => 1711069932
[capacity] => 0
[price_per_seat] => 555000
[j2] => 11
[jalur_id] => 5520
[cron_at] => 1719709714
[idklsitem] => 67
[full] => 5
[jalan] => 9
[kursi_terjual] => 302
[penawaran] => 11
[omset] => 188410000
[omset_at] => 20261028
[id2] => 480
[id_old] => 480
[kelas_items] => 67
[nopols] => AD1477CU, AD1478CU, AD7406OH
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)