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.901 | RG.901 | AD1458CU | 3063 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2024-04-15 | 0000-00-00 00:00:00 | 591253 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5599 | 1 | 25-08-21 04:48:14 | jalurId | ||
| 5 | RG.901 | RG.901 | AD1451CU | 3065 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2024-04-12 | 0000-00-00 00:00:00 | 591280 | 755,000 | 28 | 16 | 12 | 9,060,000 | 42,86 | 4 | 5599 | 1 | 25-07-23 02:55:45 | jalurId | |||
| 1 | RG.901 | RG.901 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2024-04-16 | 0000-00-00 00:00:00 | 591244 | 755,000 | 32 | 4 | 28 | 21,140,000 | 87,50 | 4 | 5599 | 1 | 25-06-15 02:30:14 | jalurId | |||||
| 5 | RG.901 | RG.901 | AD1458CU | 3063 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2024-04-17 | 0000-00-00 00:00:00 | 591235 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5599 | 1 | 25-01-05 19:01:50 | jalurId | ||
| 2 | RG.901 | RG.901 | AD1451CU | 3065 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2024-04-18 | 0000-00-00 00:00:00 | 591226 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5599 | 1 | 25-03-30 05:12:34 | jalurId | ||
| 1 | RG.901 | RG.901 | AD1458CU | 3063 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2024-04-19 | 0000-00-00 00:00:00 | 591217 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5599 | 1 | 24-11-25 11:30:20 | jalurId | ||
| 1 | RG.901 | RG.901 | AD1451CU | 3065 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2024-04-20 | 0000-00-00 00:00:00 | 591208 | 755,000 | 28 | 6 | 22 | 16,610,000 | 78,57 | 4 | 5599 | 1 | 24-04-21 05:06:57 | jalurId | |||
| 2 | RG.901 | RG.901 | AD1451CU | 3065 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2024-04-22 | 0000-00-00 00:00:00 | 591190 | 750,000 | 28 | 0 | 28 | 21,000,000 | 100,00 | 1 | 4 | 5599 | 1 | 25-10-06 11:27:56 | jalurId | ||
| 1 | RG.901 | RG.901 | AD1458CU | 3063 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2024-04-21 | 0000-00-00 00:00:00 | 591199 | 555,000 | 28 | 0 | 28 | 15,540,000 | 100,00 | 1 | 4 | 5599 | 1 | 24-07-16 12:08:50 | jalurId | ||
| 3 | RG.901 | RG.901 | AD1458CU | 3063 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2024-04-13 | 0000-00-00 00:00:00 | 591271 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5599 | 1 | 24-07-10 20:54:45 | jalurId | ||
| 5 | RG.901 | RG.901 | AD1451CU | 3065 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2024-04-14 | 0000-00-00 00:00:00 | 591262 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5599 | 1 | 25-01-05 23:01:59 | jalurId | ||
| 1 | RG.901 | RG.901 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-02 | 0000-00-00 00:00:00 | 707613 | 805,000 | 14 | 14 | 0 | 0 | 0,00 | 4 | 6482 | 1 | 25-04-03 06:58:50 | jalurId | |||||
| 3 | RG.901 | RG.901 | AD7439OA | 3063 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-03 | 0000-00-00 00:00:00 | 707623 | 805,000 | 28 | 14 | 14 | 11,270,000 | 50,00 | 4 | 6482 | 1 | 25-05-25 10:52:17 | jalurId | |||
| 4 | RG.901 | RG.901 | AD7437OA | 3065 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-04 | 0000-00-00 00:00:00 | 707633 | 805,000 | 28 | 1 | 27 | 21,735,000 | 96,43 | 4 | 6482 | 1 | 25-05-11 02:21:47 | jalurId | |||
| 3 | RG.901 | RG.901 | AD7439OA | 3063 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-05 | 0000-00-00 00:00:00 | 707643 | 805,000 | 28 | 0 | 28 | 22,540,000 | 100,00 | 1 | 4 | 6482 | 1 | 25-04-06 06:19:03 | jalurId | ||
| 3 | RG.901 | RG.901 | AD7437OA | 3065 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-06 | 0000-00-00 00:00:00 | 707653 | 805,000 | 28 | 0 | 28 | 22,540,000 | 100,00 | 1 | 4 | 6482 | 1 | 25-04-07 05:53:54 | jalurId | ||
| 2 | RG.901 | RG.901 | AD7439OA | 3063 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-07 | 0000-00-00 00:00:00 | 707663 | 805,000 | 29 | 0 | 29 | 23,345,000 | 100,00 | 1 | 4 | 6482 | 1 | 25-04-09 04:45:32 | jalurId | ||
| 2 | RG.901 | RG.901 | AD7437OA | 3065 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-08 | 0000-00-00 00:00:00 | 707673 | 495,000 | 28 | 0 | 28 | 13,860,000 | 100,00 | 1 | 4 | 6482 | 1 | 25-08-25 10:45:12 | jalurId | ||
| 5 | RG.901 | RG.901 | AD7439OA | 3063 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-09 | 0000-00-00 00:00:00 | 707683 | 495,000 | 29 | 0 | 29 | 14,355,000 | 100,00 | 1 | 4 | 6482 | 1 | 25-04-15 04:45:25 | jalurId | ||
| 3 | RG.901 | RG.901 | AD7437OA | 3065 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-10 | 0000-00-00 00:00:00 | 707693 | 495,000 | 29 | 0 | 29 | 14,355,000 | 100,00 | 1 | 4 | 6482 | 1 | 25-04-15 04:48:23 | jalurId | ||
| 3 | RG.901 | RG.901 | AD7439OA | 3063 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-11 | 0000-00-00 00:00:00 | 707703 | 420,000 | 29 | 0 | 29 | 12,180,000 | 100,00 | 1 | 4 | 6482 | 1 | 25-06-10 06:38:29 | jalurId | ||
| 3 | RG.901 | RG.901 | AD7437OA | 3065 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-12 | 0000-00-00 00:00:00 | 707713 | 420,000 | 28 | 0 | 28 | 11,760,000 | 100,00 | 1 | 4 | 6482 | 1 | 25-04-14 06:53:15 | jalurId | ||
| 3 | RG.901 | RG.901 | AD7439OA | 3063 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-13 | 0000-00-00 00:00:00 | 707723 | 420,000 | 28 | 0 | 28 | 11,760,000 | 100,00 | 1 | 4 | 6482 | 1 | 25-05-17 09:33:30 | jalurId | ||
| 3 | RG.901 | RG.901 | AD7437OA | 3065 | TR | BO | Trenggalek - Bogor | Executive Plus SHD | 2025-04-14 | 0000-00-00 00:00:00 | 707733 | 420,000 | 28 | 0 | 28 | 11,760,000 | 100,00 | 1 | 4 | 6482 | 1 | 25-04-20 02:24:26 | jalurId | ||
| 666 | 55 | 611 | 401,650,000 | 0,00 | 18 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='RG.901' 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-12 | 5599 | TR | BO | 9 | RG.901 | 591280 | 0000-00-00 00:00:00 | AD1451CU | 28 | 16 | 12 | 9,060,000 | |
| 2 | 2024-04-13 | 5599 | TR | BO | 9 | RG.901 | 591271 | 0000-00-00 00:00:00 | AD1458CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 3 | 2024-04-14 | 5599 | TR | BO | 9 | RG.901 | 591262 | 0000-00-00 00:00:00 | AD1451CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 4 | 2024-04-15 | 5599 | TR | BO | 9 | RG.901 | 591253 | 0000-00-00 00:00:00 | AD1458CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 5 | 2024-04-16 | 5599 | TR | BO | 9 | RG.901 | 591244 | 0000-00-00 00:00:00 | 32 | 4 | 28 | 21,140,000 | ||
| 6 | 2024-04-17 | 5599 | TR | BO | 9 | RG.901 | 591235 | 0000-00-00 00:00:00 | AD1458CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 7 | 2024-04-18 | 5599 | TR | BO | 9 | RG.901 | 591226 | 0000-00-00 00:00:00 | AD1451CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 8 | 2024-04-19 | 5599 | TR | BO | 9 | RG.901 | 591217 | 0000-00-00 00:00:00 | AD1458CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 9 | 2024-04-20 | 5599 | TR | BO | 9 | RG.901 | 591208 | 0000-00-00 00:00:00 | AD1451CU | 28 | 6 | 22 | 16,610,000 | |
| 10 | 2024-04-21 | 5599 | TR | BO | 9 | RG.901 | 591199 | 0000-00-00 00:00:00 | AD1458CU | 28 | 0 | 28 | 15,540,000 | 1 |
| 11 | 2024-04-22 | 5599 | TR | BO | 9 | RG.901 | 591190 | 0000-00-00 00:00:00 | AD1451CU | 28 | 0 | 28 | 21,000,000 | 1 |
| 12 | 2025-04-03 | 6482 | TR | BO | 9 | RG.901 | 707623 | 0000-00-00 00:00:00 | AD7439OA | 28 | 14 | 14 | 11,270,000 | |
| 13 | 2025-04-04 | 6482 | TR | BO | 9 | RG.901 | 707633 | 0000-00-00 00:00:00 | AD7437OA | 28 | 1 | 27 | 21,735,000 | |
| 14 | 2025-04-05 | 6482 | TR | BO | 9 | RG.901 | 707643 | 0000-00-00 00:00:00 | AD7439OA | 28 | 0 | 28 | 22,540,000 | 1 |
| 15 | 2025-04-06 | 6482 | TR | BO | 9 | RG.901 | 707653 | 0000-00-00 00:00:00 | AD7437OA | 28 | 0 | 28 | 22,540,000 | 1 |
| 16 | 2025-04-07 | 6482 | TR | BO | 9 | RG.901 | 707663 | 0000-00-00 00:00:00 | AD7439OA | 29 | 0 | 29 | 23,345,000 | 1 |
| 17 | 2025-04-08 | 6482 | TR | BO | 9 | RG.901 | 707673 | 0000-00-00 00:00:00 | AD7437OA | 28 | 0 | 28 | 13,860,000 | 1 |
| 18 | 2025-04-09 | 6482 | TR | BO | 9 | RG.901 | 707683 | 0000-00-00 00:00:00 | AD7439OA | 29 | 0 | 29 | 14,355,000 | 1 |
| 19 | 2025-04-10 | 6482 | TR | BO | 9 | RG.901 | 707693 | 0000-00-00 00:00:00 | AD7437OA | 29 | 0 | 29 | 14,355,000 | 1 |
| 20 | 2025-04-11 | 6482 | TR | BO | 9 | RG.901 | 707703 | 0000-00-00 00:00:00 | AD7439OA | 29 | 0 | 29 | 12,180,000 | 1 |
| 21 | 2025-04-12 | 6482 | TR | BO | 9 | RG.901 | 707713 | 0000-00-00 00:00:00 | AD7437OA | 28 | 0 | 28 | 11,760,000 | 1 |
| 22 | 2025-04-13 | 6482 | TR | BO | 9 | RG.901 | 707723 | 0000-00-00 00:00:00 | AD7439OA | 28 | 0 | 28 | 11,760,000 | 1 |
| 23 | 2025-04-14 | 6482 | TR | BO | 9 | RG.901 | 707733 | 0000-00-00 00:00:00 | AD7437OA | 28 | 0 | 28 | 11,760,000 | 1 |
| 652 | 41 | 611 | 401,650,000 | 18 | ||||||||||
Array
(
[id] => 655
[kode_pergi] => RG.901
[kelas_id] => 9
[kode_rute_armada] => RG.901
[kelas_armada] => 9
[kode_pergi_v0] => PO.901
[kode_pulang] =>
[rute_pergi] => Trenggalek - Ponorogo - Pulo Gebang - Pasar Rebo - Jatijajar - Depok - Cibinong - Bogor
[rute_pulang] =>
[url] =>
[info] =>
[title] => TRENGGALEK-TERMINAL TRENGGALEK ke BOGOR-BOGOR/TAJUR
[dr_agent] =>
[to_agent] =>
[dr_cd] => RG
[dr_ccd] => TR
[dr_time] => 13:45
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => BO
[create_at] => 2025-09-07 09:52:22
[dr_city] => 423
[dr_agen] => 40664
[to_city] => 313
[to_agen] => 3131
[price_count] => 0
[update_at] => 1710989232
[capacity] => 0
[price_per_seat] => 725000
[j2] => 24
[jalur_id] => 6482
[cron_at] => 1729728593
[idklsitem] => 4
[full] => 18
[jalan] => 23
[kursi_terjual] => 611
[penawaran] => 24
[omset] => 401650000
[omset_at] => 20250522
[id2] => 655
[id_old] => 655
[kelas_items] => 4
[nopols] => AD1451CU, AD1458CU
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)