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 | LB.901 | LB.901 | AD1456CU | 3090 | BL | BO | Blitar - Bogor | Executive Plus SHD | 2024-04-17 | 0000-00-00 00:00:00 | 590897 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5587 | 1 | 25-06-11 13:17:26 | jalurId | ||
| 2 | LB.901 | LB.901 | AD1457CU | 3091 | BL | BO | Blitar - Bogor | Executive Plus SHD | 2024-04-16 | 0000-00-00 00:00:00 | 590884 | 755,000 | 0 | 0 | 0 | 0 | 0,00 | 4 | 5587 | 1 | 26-05-13 16:22:30 | jalurId | |||
| 4 | LB.901 | LB.901 | AD1456CU | 3090 | BL | BO | Blitar - Bogor | Executive Plus SHD | 2024-04-15 | 0000-00-00 00:00:00 | 590871 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5587 | 1 | 25-12-14 02:38:21 | jalurId | ||
| 5 | LB.901 | LB.901 | AD1457CU | 3091 | BL | BO | Blitar - Bogor | Executive Plus SHD | 2024-04-18 | 0000-00-00 00:00:00 | 590910 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5587 | 1 | 25-04-07 09:58:09 | jalurId | ||
| 3 | LB.901 | LB.901 | AD1457CU | 3091 | BL | BO | Blitar - Bogor | Executive Plus SHD | 2024-04-14 | 0000-00-00 00:00:00 | 590858 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5587 | 1 | 24-11-09 17:34:19 | jalurId | ||
| 1 | LB.901 | LB.901 | AD1456CU | 3090 | BL | BO | Blitar - Bogor | Executive Plus SHD | 2024-04-19 | 0000-00-00 00:00:00 | 590923 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5587 | 1 | 25-02-17 22:52:58 | jalurId | ||
| 1 | LB.901 | LB.901 | AD1457CU | 3091 | BL | BO | Blitar - Bogor | Executive Plus SHD | 2024-04-20 | 0000-00-00 00:00:00 | 590936 | 755,000 | 28 | 2 | 26 | 19,630,000 | 92,86 | 4 | 5587 | 1 | 26-03-04 15:16:44 | jalurId | |||
| 1 | LB.901 | LB.901 | AD1456CU | 3090 | BL | BO | Blitar - Bogor | Executive Plus SHD | 2024-04-21 | 0000-00-00 00:00:00 | 590949 | 555,000 | 0 | 0 | 0 | 0 | 0,00 | 4 | 5587 | 1 | 26-05-28 22:42:51 | jalurId | |||
| 5 | LB.901 | LB.901 | AD1457CU | 3091 | BL | BO | Blitar - Bogor | Executive Plus SHD | 2024-04-22 | 0000-00-00 00:00:00 | 590962 | 555,000 | 28 | 0 | 28 | 15,540,000 | 100,00 | 1 | 4 | 5587 | 1 | 25-09-28 09:53:46 | jalurId | ||
| 5 | LB.901 | LB.901 | AD1457CU | 3091 | BL | BO | Blitar - Bogor | Executive Plus SHD | 2024-04-12 | 0000-00-00 00:00:00 | 590832 | 755,000 | 28 | 4 | 24 | 18,120,000 | 85,71 | 4 | 5587 | 1 | 25-04-28 18:12:51 | jalurId | |||
| 1 | LB.901 | LB.901 | AD1456CU | 3090 | BL | BO | Blitar - Bogor | Executive Plus SHD | 2024-04-13 | 0000-00-00 00:00:00 | 590845 | 755,000 | 28 | 0 | 28 | 21,140,000 | 100,00 | 1 | 4 | 5587 | 1 | 24-04-14 05:33:46 | jalurId | ||
| 252 | 6 | 246 | 180,130,000 | 0,00 | 7 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='LB.901' and tgl>'2024-01-27' and tgl<'2026-08-09' 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 | 5587 | BL | BO | 9 | LB.901 | 590832 | 0000-00-00 00:00:00 | AD1457CU | 28 | 4 | 24 | 18,120,000 | |
| 2 | 2024-04-13 | 5587 | BL | BO | 9 | LB.901 | 590845 | 0000-00-00 00:00:00 | AD1456CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 3 | 2024-04-14 | 5587 | BL | BO | 9 | LB.901 | 590858 | 0000-00-00 00:00:00 | AD1457CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 4 | 2024-04-15 | 5587 | BL | BO | 9 | LB.901 | 590871 | 0000-00-00 00:00:00 | AD1456CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 5 | 2024-04-17 | 5587 | BL | BO | 9 | LB.901 | 590897 | 0000-00-00 00:00:00 | AD1456CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 6 | 2024-04-18 | 5587 | BL | BO | 9 | LB.901 | 590910 | 0000-00-00 00:00:00 | AD1457CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 7 | 2024-04-19 | 5587 | BL | BO | 9 | LB.901 | 590923 | 0000-00-00 00:00:00 | AD1456CU | 28 | 0 | 28 | 21,140,000 | 1 |
| 8 | 2024-04-20 | 5587 | BL | BO | 9 | LB.901 | 590936 | 0000-00-00 00:00:00 | AD1457CU | 28 | 2 | 26 | 19,630,000 | |
| 9 | 2024-04-22 | 5587 | BL | BO | 9 | LB.901 | 590962 | 0000-00-00 00:00:00 | AD1457CU | 28 | 0 | 28 | 15,540,000 | 1 |
| 252 | 6 | 246 | 180,130,000 | 7 | ||||||||||
Array
(
[id] => 605
[kode_pergi] => LB.901
[kelas_id] => 9
[kode_rute_armada] => LB.901
[kelas_armada] => 9
[kode_pergi_v0] => BL.304
[kode_pulang] =>
[rute_pergi] => Blitar - Karawang - Cibitung - Pulo Gebang - Cisalak - Cibinong - Bogor
[rute_pulang] =>
[url] =>
[info] =>
[title] => Blitar-Blitar Pool ke Bogor-Bogor/tajur
[dr_agent] =>
[to_agent] =>
[dr_cd] => LB
[dr_ccd] => BL
[dr_time] => 11:00
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => BO
[create_at] => 2026-06-29 15:23:00
[dr_city] => 119
[dr_agen] => 1183
[to_city] => 313
[to_agen] => 3131
[price_count] => 0
[update_at] => 1710983343
[capacity] => 0
[price_per_seat] => 755000
[j2] => 11
[jalur_id] => 5587
[cron_at] => 1713863858
[idklsitem] => 4
[full] => 9
[jalan] => 9
[kursi_terjual] => 246
[penawaran] => 11
[omset] => 180130000
[omset_at] => 20260630
[id2] => 605
[id_old] => 605
[kelas_items] => 3,4
[nopols] => AD1456CU, AD1457CU
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)