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 | RG.304 | RG.304 | AD7187OA | 3052 | TR | MR | Trenggalek - Merak | Executive Plus | 2024-04-14 | 0000-00-00 00:00:00 | 592662 | 800,000 | 28 | 0 | 28 | 22,400,000 | 100,00 | 1 | 86 | 5779 | 1 | 24-04-15 05:29:16 | jalurId | ||
| 5 | RG.304 | RG.304 | AD7187OA | 3052 | TR | MR | Trenggalek - Merak | Executive Plus | 2024-04-13 | 0000-00-00 00:00:00 | 592660 | 800,000 | 30 | 2 | 28 | 22,400,000 | 93,33 | 86 | 5779 | 1 | 24-12-22 16:48:37 | jalurId | |||
| 3 | RG.304 | RG.304 | TR | MR | Trenggalek - Merak | Executive Plus | 2024-04-16 | 0000-00-00 00:00:00 | 592666 | 800,000 | 30 | 2 | 28 | 22,400,000 | 93,33 | 86 | 5779 | 1 | 24-07-03 13:23:07 | jalurId | |||||
| 3 | RG.304 | RG.304 | AD7563OF | 3042 | TR | MR | Trenggalek - Merak | Executive Plus | 2024-04-15 | 0000-00-00 00:00:00 | 592664 | 800,000 | 30 | 0 | 30 | 24,000,000 | 100,00 | 1 | 86 | 5779 | 1 | 25-01-22 13:42:11 | jalurId | ||
| 0 | RG.304 | RG.304 | AD7429OA | 3189 | TR | MR | Trenggalek - Merak | Executive Plus | 2025-04-08 | 0000-00-00 00:00:00 | 710741 | 460,000 | 28 | 0 | 28 | 12,880,000 | 100,00 | 1 | 5 | 6840 | 1 | 25-05-19 23:24:01 | jalurId | ||
| 146 | 4 | 142 | 104,080,000 | 0,00 | 3 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='RG.304' 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-13 | 5779 | TR | MR | 3 | RG.304 | 592660 | 0000-00-00 00:00:00 | AD7187OA | 30 | 2 | 28 | 22,400,000 | |
| 2 | 2024-04-14 | 5779 | TR | MR | 3 | RG.304 | 592662 | 0000-00-00 00:00:00 | AD7187OA | 28 | 0 | 28 | 22,400,000 | 1 |
| 3 | 2024-04-15 | 5779 | TR | MR | 3 | RG.304 | 592664 | 0000-00-00 00:00:00 | AD7563OF | 30 | 0 | 30 | 24,000,000 | 1 |
| 4 | 2024-04-16 | 5779 | TR | MR | 3 | RG.304 | 592666 | 0000-00-00 00:00:00 | 30 | 2 | 28 | 22,400,000 | ||
| 5 | 2025-04-08 | 6840 | TR | MR | 3 | RG.304 | 710741 | 0000-00-00 00:00:00 | AD7429OA | 28 | 0 | 28 | 12,880,000 | 1 |
| 146 | 4 | 142 | 104,080,000 | 3 | ||||||||||
Array
(
[id] => 690
[kode_pergi] => RG.304
[kelas_id] => 3
[kode_rute_armada] => RG.304
[kelas_armada] => 3
[kode_pergi_v0] => PO.308
[kode_pulang] =>
[rute_pergi] => Trenggalek - Ponorogo - Bekasi - Cikokol - BSD - Bitung - Balaraja - Cikande - Serang - Cilegon - Merak
[rute_pulang] =>
[url] =>
[info] =>
[title] => TRENGGALEK-TERMINAL TRENGGALEK ke MERAK-MERAK LAMA
[dr_agent] =>
[to_agent] =>
[dr_cd] => RG
[dr_ccd] => TR
[dr_time] => 14:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => MR
[create_at] => 2025-09-07 09:52:22
[dr_city] => 423
[dr_agen] => 40664
[to_city] => 323
[to_agen] => 3111
[price_count] => 0
[update_at] => 1711491380
[capacity] => 0
[price_per_seat] => 710000
[j2] => 5
[jalur_id] => 6840
[cron_at] => 1729728597
[idklsitem] => 61
[full] => 3
[jalan] => 5
[kursi_terjual] => 142
[penawaran] => 5
[omset] => 104080000
[omset_at] => 20250522
[id2] => 690
[id_old] => 690
[kelas_items] => 61,86
[nopols] =>
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)