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 | GC.404 | GC.404 | AD7185OF | 3134 | CG | JO | Cileduk - Yogya | Executive | 2024-04-01 | 0000-00-00 00:00:00 | 587560 | 370,000 | 28 | 10 | 18 | 6,660,000 | 64,29 | 89 | 5537 | 1 | 25-05-02 12:35:47 | jalurId | |||
| 1 | GC.404 | GC.404 | AD7508OH | 401 | CG | JO | Cileduk - Yogya | Executive | 2024-04-02 | 0000-00-00 00:00:00 | 587568 | 370,000 | 30 | 1 | 29 | 10,730,000 | 96,67 | 7 | 5537 | 1 | 24-11-22 18:31:49 | jalurId | |||
| 5 | GC.404 | GC.404 | AD7114OF | 327 | CG | JO | Cileduk - Yogya | Executive | 2024-04-03 | 0000-00-00 00:00:00 | 587576 | 370,000 | 30 | 0 | 30 | 11,100,000 | 100,00 | 1 | 7 | 5537 | 1 | 25-04-24 01:12:32 | jalurId | ||
| 3 | GC.404 | GC.404 | AD7673OF | 3144 | CG | JO | Cileduk - Yogya | Executive | 2024-04-04 | 0000-00-00 00:00:00 | 587584 | 370,000 | 34 | 5 | 29 | 10,730,000 | 85,29 | 2 | 5537 | 1 | 24-06-30 20:40:32 | jalurId | |||
| 2 | GC.404 | GC.404 | AD7671OF | 3142 | CG | JO | Cileduk - Yogya | Executive | 2024-04-05 | 0000-00-00 00:00:00 | 587592 | 560,000 | 34 | 0 | 34 | 19,040,000 | 100,00 | 1 | 93 | 5537 | 1 | 24-04-06 04:42:37 | jalurId | ||
| 2 | GC.404 | GC.404 | AD7673OF | 3144 | CG | JO | Cileduk - Yogya | Executive | 2024-04-06 | 0000-00-00 00:00:00 | 587600 | 560,000 | 34 | 0 | 34 | 19,040,000 | 100,00 | 1 | 93 | 5537 | 1 | 24-07-02 09:55:06 | jalurId | ||
| 4 | GC.404 | GC.404 | AD7671OF | 3142 | CG | JO | Cileduk - Yogya | Executive | 2024-04-07 | 0000-00-00 00:00:00 | 587608 | 560,000 | 34 | 0 | 34 | 19,040,000 | 100,00 | 1 | 93 | 5537 | 1 | 25-05-01 03:18:34 | jalurId | ||
| 4 | GC.404 | GC.404 | AD7673OF | 3144 | CG | JO | Cileduk - Yogya | Executive | 2024-04-08 | 0000-00-00 00:00:00 | 587616 | 560,000 | 34 | 0 | 34 | 19,040,000 | 100,00 | 1 | 93 | 5537 | 1 | 25-04-18 18:42:30 | jalurId | ||
| 3 | GC.404 | GC.404 | AD7671OF | 3142 | CG | JO | Cileduk - Yogya | Executive | 2024-04-09 | 0000-00-00 00:00:00 | 587624 | 560,000 | 34 | 0 | 34 | 19,040,000 | 100,00 | 1 | 93 | 5537 | 1 | 24-04-10 05:15:59 | jalurId | ||
| 0 | GC.404 | GC.404 | AD7673OF | 3144 | CG | JO | Cileduk - Yogya | Executive | 2024-04-10 | 0000-00-00 00:00:00 | 587632 | 370,000 | 34 | 0 | 34 | 12,580,000 | 100,00 | 1 | 93 | 5537 | 1 | 25-07-02 21:58:47 | jalurId | ||
| 0 | GC.404 | GC.404 | AD7671OF | 3142 | CG | JO | Cileduk - Yogya | Executive | 2024-04-11 | 0000-00-00 00:00:00 | 587640 | 370,000 | 34 | 0 | 34 | 12,580,000 | 100,00 | 1 | 93 | 5537 | 1 | 25-11-28 00:34:03 | jalurId | ||
| 360 | 16 | 344 | 159,580,000 | 0,00 | 8 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='GC.404' 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 | 5537 | CG | JO | 4 | GC.404 | 587560 | 0000-00-00 00:00:00 | AD7185OF | 28 | 10 | 18 | 6,660,000 | |
| 2 | 2024-04-02 | 5537 | CG | JO | 4 | GC.404 | 587568 | 0000-00-00 00:00:00 | AD7508OH | 30 | 1 | 29 | 10,730,000 | |
| 3 | 2024-04-03 | 5537 | CG | JO | 4 | GC.404 | 587576 | 0000-00-00 00:00:00 | AD7114OF | 30 | 0 | 30 | 11,100,000 | 1 |
| 4 | 2024-04-04 | 5537 | CG | JO | 4 | GC.404 | 587584 | 0000-00-00 00:00:00 | AD7673OF | 34 | 5 | 29 | 10,730,000 | |
| 5 | 2024-04-05 | 5537 | CG | JO | 4 | GC.404 | 587592 | 0000-00-00 00:00:00 | AD7671OF | 34 | 0 | 34 | 19,040,000 | 1 |
| 6 | 2024-04-06 | 5537 | CG | JO | 4 | GC.404 | 587600 | 0000-00-00 00:00:00 | AD7673OF | 34 | 0 | 34 | 19,040,000 | 1 |
| 7 | 2024-04-07 | 5537 | CG | JO | 4 | GC.404 | 587608 | 0000-00-00 00:00:00 | AD7671OF | 34 | 0 | 34 | 19,040,000 | 1 |
| 8 | 2024-04-08 | 5537 | CG | JO | 4 | GC.404 | 587616 | 0000-00-00 00:00:00 | AD7673OF | 34 | 0 | 34 | 19,040,000 | 1 |
| 9 | 2024-04-09 | 5537 | CG | JO | 4 | GC.404 | 587624 | 0000-00-00 00:00:00 | AD7671OF | 34 | 0 | 34 | 19,040,000 | 1 |
| 10 | 2024-04-10 | 5537 | CG | JO | 4 | GC.404 | 587632 | 0000-00-00 00:00:00 | AD7673OF | 34 | 0 | 34 | 12,580,000 | 1 |
| 11 | 2024-04-11 | 5537 | CG | JO | 4 | GC.404 | 587640 | 0000-00-00 00:00:00 | AD7671OF | 34 | 0 | 34 | 12,580,000 | 1 |
| 360 | 16 | 344 | 159,580,000 | 8 | ||||||||||
Array
(
[id] => 555
[kode_pergi] => GC.404
[kelas_id] => 4
[kode_rute_armada] => GC.404
[kelas_armada] => 4
[kode_pergi_v0] => CG.405
[kode_pulang] =>
[rute_pergi] => Cileduk - Kreo - P .Pinang - Ps.Minggu - Kp.Rambutan - Cibitung - Cikarang - Ajiabarang - Kebumen - Yogya
[rute_pulang] =>
[url] =>
[info] =>
[title] => Tangerang-Ciledug Baru ke Yogyakarta-Rosin Yogya
[dr_agent] =>
[to_agent] =>
[dr_cd] => GC
[dr_ccd] => CG
[dr_time] => 13:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => JO
[create_at] => 2025-09-07 09:52:22
[dr_city] => 320
[dr_agen] => 13323
[to_city] => 225
[to_agen] => 2254
[price_count] => 0
[update_at] => 1710802093
[capacity] => 0
[price_per_seat] => 370000
[j2] => 11
[jalur_id] => 5537
[cron_at] => 1719709515
[idklsitem] => 2
[full] => 8
[jalan] => 11
[kursi_terjual] => 344
[penawaran] => 11
[omset] => 159580000
[omset_at] => 20250522
[id2] => 555
[id_old] => 555
[kelas_items] => 2,7,89
[nopols] => AD7114OF, AD7185OF, AD7508OH, AD7671OF, AD7673OF
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)