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 | BS.901 | BS.901 | AD7295OF | 3011 | SB | BI | Surabaya - Bitung | Executive Plus SHD | 2024-04-18 | 0000-00-00 00:00:00 | 590680 | 755,000 | 30 | 0 | 30 | 22,650,000 | 100,00 | 1 | 55 | 5578 | 1 | 25-02-08 17:26:08 | jalurId | ||
| 2 | BS.901 | BS.901 | AD7287OF | 3012 | SB | BI | Surabaya - Bitung | Executive Plus SHD | 2024-04-17 | 0000-00-00 00:00:00 | 590676 | 755,000 | 30 | 30 | 0 | 0 | 0,00 | 55 | 5578 | 1 | 25-02-24 19:42:46 | jalurId | |||
| 3 | BS.901 | BS.901 | AD7295OF | 3011 | SB | BI | Surabaya - Bitung | Executive Plus SHD | 2024-04-16 | 0000-00-00 00:00:00 | 590672 | 755,000 | 30 | 0 | 30 | 22,650,000 | 100,00 | 1 | 55 | 5578 | 1 | 24-12-10 02:30:02 | jalurId | ||
| 2 | BS.901 | BS.901 | AD7287OF | 3012 | SB | BI | Surabaya - Bitung | Executive Plus SHD | 2024-04-15 | 0000-00-00 00:00:00 | 590668 | 755,000 | 30 | 0 | 30 | 22,650,000 | 100,00 | 1 | 55 | 5578 | 1 | 24-07-15 06:26:09 | jalurId | ||
| 2 | BS.901 | BS.901 | AD7375OA | 3018 | SB | BI | Surabaya - Bitung | Executive Plus SHD | 2024-04-19 | 0000-00-00 00:00:00 | 590684 | 755,000 | 30 | 0 | 30 | 22,650,000 | 100,00 | 1 | 55 | 5578 | 1 | 24-07-01 13:08:53 | jalurId | ||
| 1 | BS.901 | BS.901 | AD7295OF | 3011 | SB | BI | Surabaya - Bitung | Executive Plus SHD | 2024-04-20 | 0000-00-00 00:00:00 | 590688 | 755,000 | 30 | 0 | 30 | 22,650,000 | 100,00 | 1 | 55 | 5578 | 1 | 24-07-15 03:17:49 | jalurId | ||
| 2 | BS.901 | BS.901 | AD7375OA | 3018 | SB | BI | Surabaya - Bitung | Executive Plus SHD | 2024-04-21 | 0000-00-00 00:00:00 | 590692 | 555,000 | 30 | 0 | 30 | 16,650,000 | 100,00 | 1 | 55 | 5578 | 1 | 24-07-01 10:36:08 | jalurId | ||
| 5 | BS.901 | BS.901 | AD7295OF | 3011 | SB | BI | Surabaya - Bitung | Executive Plus SHD | 2024-04-22 | 0000-00-00 00:00:00 | 590696 | 555,000 | 30 | 1 | 29 | 16,095,000 | 96,67 | 55 | 5578 | 1 | 25-01-21 06:49:10 | jalurId | |||
| 4 | BS.901 | BS.901 | AD7295OF | 3011 | SB | BI | Surabaya - Bitung | Executive Plus SHD | 2024-04-12 | 0000-00-00 00:00:00 | 590656 | 755,000 | 30 | 15 | 15 | 11,325,000 | 50,00 | 3 | 5578 | 1 | 24-12-10 02:33:06 | jalurId | |||
| 1 | BS.901 | BS.901 | AD7287OF | 3012 | SB | BI | Surabaya - Bitung | Executive Plus SHD | 2024-04-13 | 0000-00-00 00:00:00 | 590660 | 755,000 | 0 | 0 | 0 | 0 | 0,00 | 55 | 5578 | 1 | 24-10-31 10:24:09 | jalurId | |||
| 5 | BS.901 | BS.901 | AD7295OF | 3011 | SB | BI | Surabaya - Bitung | Executive Plus SHD | 2024-04-14 | 0000-00-00 00:00:00 | 590664 | 755,000 | 30 | 0 | 30 | 22,650,000 | 100,00 | 1 | 55 | 5578 | 1 | 25-07-11 16:14:37 | jalurId | ||
| 300 | 46 | 254 | 179,970,000 | 0,00 | 7 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='BS.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 | 5578 | SB | BI | 9 | BS.901 | 590656 | 0000-00-00 00:00:00 | AD7295OF | 30 | 15 | 15 | 11,325,000 | |
| 2 | 2024-04-14 | 5578 | SB | BI | 9 | BS.901 | 590664 | 0000-00-00 00:00:00 | AD7295OF | 30 | 0 | 30 | 22,650,000 | 1 |
| 3 | 2024-04-15 | 5578 | SB | BI | 9 | BS.901 | 590668 | 0000-00-00 00:00:00 | AD7287OF | 30 | 0 | 30 | 22,650,000 | 1 |
| 4 | 2024-04-16 | 5578 | SB | BI | 9 | BS.901 | 590672 | 0000-00-00 00:00:00 | AD7295OF | 30 | 0 | 30 | 22,650,000 | 1 |
| 5 | 2024-04-18 | 5578 | SB | BI | 9 | BS.901 | 590680 | 0000-00-00 00:00:00 | AD7295OF | 30 | 0 | 30 | 22,650,000 | 1 |
| 6 | 2024-04-19 | 5578 | SB | BI | 9 | BS.901 | 590684 | 0000-00-00 00:00:00 | AD7375OA | 30 | 0 | 30 | 22,650,000 | 1 |
| 7 | 2024-04-20 | 5578 | SB | BI | 9 | BS.901 | 590688 | 0000-00-00 00:00:00 | AD7295OF | 30 | 0 | 30 | 22,650,000 | 1 |
| 8 | 2024-04-21 | 5578 | SB | BI | 9 | BS.901 | 590692 | 0000-00-00 00:00:00 | AD7375OA | 30 | 0 | 30 | 16,650,000 | 1 |
| 9 | 2024-04-22 | 5578 | SB | BI | 9 | BS.901 | 590696 | 0000-00-00 00:00:00 | AD7295OF | 30 | 1 | 29 | 16,095,000 | |
| 270 | 16 | 254 | 179,970,000 | 7 | ||||||||||
Array
(
[id] => 604
[kode_pergi] => BS.901
[kelas_id] => 9
[kode_rute_armada] => BS.901
[kelas_armada] => 9
[kode_pergi_v0] => SB.901
[kode_pulang] =>
[rute_pergi] => Surabaya - Terminal Grogol - Kalideres - Cikokol - Bitung
[rute_pulang] =>
[url] =>
[info] =>
[title] => Surabaya-Sub Bungurasih ke Tangerang-Bitung
[dr_agent] =>
[to_agent] =>
[dr_cd] => BS
[dr_ccd] => SB
[dr_time] => 12:30
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => BI
[create_at] => 2025-08-21 23:54:24
[dr_city] => 115
[dr_agen] => 1151
[to_city] => 320
[to_agen] => 3151
[price_count] => 0
[update_at] => 1710983364
[capacity] => 0
[price_per_seat] => 755000
[j2] => 11
[jalur_id] => 5578
[cron_at] => 1713863871
[idklsitem] => 3
[full] => 8
[jalan] => 9
[kursi_terjual] => 254
[penawaran] => 11
[omset] => 179970000
[omset_at] => 20250522
[id2] => 604
[id_old] => 604
[kelas_items] => 3,4
[nopols] => AD7287OF, AD7295OF, AD7375OA
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)