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 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | BC.101 | BC.101 | AD1455CU | 210 | CB | ML | Cileungsi - Malang (via Toll Trans Jawa) | SuperTop SHD | 2024-04-01 | 0000-00-00 00:00:00 | 587641 | 645,000 | 16 | 11 | 5 | 3,225,000 | 31,25 | 58 | 5546 | 1 | 25-03-21 09:44:16 | jalurId | |||
| 2 | BC.101 | BC.101 | AD1452CU | 207 | CB | ML | Cileungsi - Malang (via Toll Trans Jawa) | SuperTop SHD | 2024-04-02 | 0000-00-00 00:00:00 | 587651 | 635,000 | 21 | 11 | 10 | 6,350,000 | 47,62 | 47 | 5546 | 1 | 24-04-03 04:33:48 | jalurId | |||
| 2 | BC.101 | BC.101 | AD1455CU | 210 | CB | ML | Cileungsi - Malang (via Toll Trans Jawa) | SuperTop SHD | 2024-04-03 | 0000-00-00 00:00:00 | 587661 | 645,000 | 21 | 1 | 20 | 12,900,000 | 95,24 | 58 | 5546 | 1 | 24-04-04 04:23:59 | jalurId | |||
| 1 | BC.101 | BC.101 | AD1452CU | 207 | CB | ML | Cileungsi - Malang (via Toll Trans Jawa) | SuperTop SHD | 2024-04-04 | 0000-00-00 00:00:00 | 587671 | 645,000 | 21 | 0 | 21 | 13,545,000 | 100,00 | 1 | 58 | 5546 | 1 | 25-11-14 22:55:55 | jalurId | ||
| 3 | BC.101 | BC.101 | AD1455CU | 210 | CB | ML | Cileungsi - Malang (via Toll Trans Jawa) | SuperTop SHD | 2024-04-05 | 0000-00-00 00:00:00 | 587681 | 825,000 | 21 | 1 | 20 | 16,500,000 | 95,24 | 47 | 5546 | 1 | 24-04-06 04:43:40 | jalurId | |||
| 3 | BC.101 | BC.101 | AD1452CU | 207 | CB | ML | Cileungsi - Malang (via Toll Trans Jawa) | SuperTop SHD | 2024-04-06 | 0000-00-00 00:00:00 | 587691 | 825,000 | 21 | 0 | 21 | 17,325,000 | 100,00 | 1 | 58 | 5546 | 1 | 26-01-29 22:13:00 | jalurId | ||
| 2 | BC.101 | BC.101 | AD1455CU | 210 | CB | ML | Cileungsi - Malang (via Toll Trans Jawa) | SuperTop SHD | 2024-04-07 | 0000-00-00 00:00:00 | 587701 | 825,000 | 21 | 0 | 21 | 17,325,000 | 100,00 | 1 | 58 | 5546 | 1 | 24-04-08 05:33:32 | jalurId | ||
| 3 | BC.101 | BC.101 | AD1452CU | 207 | CB | ML | Cileungsi - Malang (via Toll Trans Jawa) | SuperTop SHD | 2024-04-08 | 0000-00-00 00:00:00 | 587711 | 825,000 | 16 | 0 | 16 | 13,200,000 | 100,00 | 1 | 58 | 5546 | 1 | 26-02-10 15:29:57 | jalurId | ||
| 4 | BC.101 | BC.101 | AD1455CU | 210 | CB | ML | Cileungsi - Malang (via Toll Trans Jawa) | SuperTop SHD | 2024-04-09 | 0000-00-00 00:00:00 | 587721 | 825,000 | 21 | 8 | 13 | 10,725,000 | 61,90 | 58 | 5546 | 1 | 24-04-10 05:16:57 | jalurId | |||
| 0 | BC.101 | BC.101 | AD1452CU | 207 | CB | ML | Cileungsi - Malang (via Toll Trans Jawa) | SuperTop SHD | 2024-04-10 | 0000-00-00 00:00:00 | 587731 | 645,000 | 21 | 9 | 12 | 7,740,000 | 57,14 | 47 | 5546 | 1 | 25-07-12 11:10:28 | jalurId | |||
| 0 | BC.101 | BC.101 | AD1455CU | 210 | CB | ML | Cileungsi - Malang (via Toll Trans Jawa) | SuperTop SHD | 2024-04-11 | 0000-00-00 00:00:00 | 587741 | 645,000 | 21 | 12 | 9 | 5,805,000 | 42,86 | 47 | 5546 | 1 | 25-12-16 11:21:00 | jalurId | |||
| 221 | 53 | 168 | 124,640,000 | 0,00 | 4 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='BC.101' 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-01 | 5546 | CB | ML | 1 | BC.101 | 587641 | 0000-00-00 00:00:00 | AD1455CU | 16 | 11 | 5 | 3,225,000 | |
| 2 | 2024-04-02 | 5546 | CB | ML | 1 | BC.101 | 587651 | 0000-00-00 00:00:00 | AD1452CU | 21 | 11 | 10 | 6,350,000 | |
| 3 | 2024-04-03 | 5546 | CB | ML | 1 | BC.101 | 587661 | 0000-00-00 00:00:00 | AD1455CU | 21 | 1 | 20 | 12,900,000 | |
| 4 | 2024-04-04 | 5546 | CB | ML | 1 | BC.101 | 587671 | 0000-00-00 00:00:00 | AD1452CU | 21 | 0 | 21 | 13,545,000 | 1 |
| 5 | 2024-04-05 | 5546 | CB | ML | 1 | BC.101 | 587681 | 0000-00-00 00:00:00 | AD1455CU | 21 | 1 | 20 | 16,500,000 | |
| 6 | 2024-04-06 | 5546 | CB | ML | 1 | BC.101 | 587691 | 0000-00-00 00:00:00 | AD1452CU | 21 | 0 | 21 | 17,325,000 | 1 |
| 7 | 2024-04-07 | 5546 | CB | ML | 1 | BC.101 | 587701 | 0000-00-00 00:00:00 | AD1455CU | 21 | 0 | 21 | 17,325,000 | 1 |
| 8 | 2024-04-08 | 5546 | CB | ML | 1 | BC.101 | 587711 | 0000-00-00 00:00:00 | AD1452CU | 16 | 0 | 16 | 13,200,000 | 1 |
| 9 | 2024-04-09 | 5546 | CB | ML | 1 | BC.101 | 587721 | 0000-00-00 00:00:00 | AD1455CU | 21 | 8 | 13 | 10,725,000 | |
| 10 | 2024-04-10 | 5546 | CB | ML | 1 | BC.101 | 587731 | 0000-00-00 00:00:00 | AD1452CU | 21 | 9 | 12 | 7,740,000 | |
| 11 | 2024-04-11 | 5546 | CB | ML | 1 | BC.101 | 587741 | 0000-00-00 00:00:00 | AD1455CU | 21 | 12 | 9 | 5,805,000 | |
| 221 | 53 | 168 | 124,640,000 | 4 | ||||||||||
Array
(
[id] => 461
[kode_pergi] => BC.101
[kelas_id] => 1
[kode_rute_armada] => BC.101
[kelas_armada] => 1
[kode_pergi_v0] => CB.101
[kode_pulang] =>
[rute_pergi] => Cileungsi - Cibubur - Kp.Rambutan - Jatiasih - Pulo Gebang - Bekasi - Surabaya - Pandaan - Malang (via Toll Trans Jawa)
[rute_pulang] =>
[url] =>
[info] =>
[title] => Cibubur-Cileungsi ke Malang-Malang Pool
[dr_agent] =>
[to_agent] =>
[dr_cd] => BC
[dr_ccd] => CB
[dr_time] => 16:15
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => ML
[create_at] => 2025-09-07 09:52:22
[dr_city] => 317
[dr_agen] => 3134
[to_city] => 124
[to_agen] => 1241
[price_count] => 0
[update_at] => 1710750518
[capacity] => 0
[price_per_seat] => 645000
[j2] => 11
[jalur_id] => 5546
[cron_at] => 1719710019
[idklsitem] => 58
[full] => 4
[jalan] => 11
[kursi_terjual] => 168
[penawaran] => 11
[omset] => 124640000
[omset_at] => 20250522
[id2] => 461
[id_old] => 461
[kelas_items] => 47,58
[nopols] => AD1452CU, AD1455CU
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)