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.903 | BS.903 | AD7292OF | 3008 | SB | BO | Surabaya - Bogor | Executive Plus SHD | 2024-04-13 | 0000-00-00 00:00:00 | 590662 | 755,000 | 31 | 0 | 31 | 23,405,000 | 100,00 | 1 | 55 | 5706 | 1 | 26-05-06 06:04:57 | jalurId | ||
| 2 | BS.903 | BS.903 | AD7288OF | 3013 | SB | BO | Surabaya - Bogor | Executive Plus SHD | 2024-04-12 | 0000-00-00 00:00:00 | 590658 | 755,000 | 30 | 9 | 21 | 15,855,000 | 70,00 | 3 | 5706 | 1 | 25-03-24 03:43:57 | jalurId | |||
| 5 | BS.903 | BS.903 | AD7404OH | 3146 | SB | BO | Surabaya - Bogor | Executive Plus SHD | 2024-04-19 | 0000-00-00 00:00:00 | 590686 | 755,000 | 32 | 2 | 30 | 22,650,000 | 93,75 | 55 | 5706 | 1 | 25-03-24 21:31:29 | jalurId | |||
| 5 | BS.903 | BS.903 | AD7292OF | 3008 | SB | BO | Surabaya - Bogor | Executive Plus SHD | 2024-04-20 | 0000-00-00 00:00:00 | 590690 | 755,000 | 30 | 0 | 30 | 22,650,000 | 100,00 | 1 | 55 | 5706 | 1 | 26-05-05 17:02:58 | jalurId | ||
| 4 | BS.903 | BS.903 | AD7288OF | 3013 | SB | BO | Surabaya - Bogor | Executive Plus SHD | 2024-04-14 | 0000-00-00 00:00:00 | 590666 | 755,000 | 30 | 1 | 29 | 21,895,000 | 96,67 | 55 | 5706 | 1 | 26-04-22 07:03:47 | jalurId | |||
| 2 | BS.903 | BS.903 | AD7292OF | 3008 | SB | BO | Surabaya - Bogor | Executive Plus SHD | 2024-04-15 | 0000-00-00 00:00:00 | 590670 | 755,000 | 30 | 0 | 30 | 22,650,000 | 100,00 | 1 | 55 | 5706 | 1 | 25-05-04 01:55:15 | jalurId | ||
| 5 | BS.903 | BS.903 | AD7404OH | 3146 | SB | BO | Surabaya - Bogor | Executive Plus SHD | 2024-04-21 | 0000-00-00 00:00:00 | 590694 | 555,000 | 34 | 0 | 34 | 18,870,000 | 100,00 | 1 | 88 | 5706 | 1 | 26-05-04 00:11:18 | jalurId | ||
| 4 | BS.903 | BS.903 | AD7292OF | 3008 | SB | BO | Surabaya - Bogor | Executive Plus SHD | 2024-04-22 | 0000-00-00 00:00:00 | 590698 | 555,000 | 30 | 0 | 30 | 16,650,000 | 100,00 | 1 | 55 | 5706 | 1 | 26-05-04 07:32:40 | jalurId | ||
| 1 | BS.903 | BS.903 | AD7288OF | 3013 | SB | BO | Surabaya - Bogor | Executive Plus SHD | 2024-04-16 | 0000-00-00 00:00:00 | 590674 | 755,000 | 30 | 0 | 30 | 22,650,000 | 100,00 | 1 | 55 | 5706 | 1 | 24-11-25 08:55:24 | jalurId | ||
| 5 | BS.903 | BS.903 | AD7287OF | 3012 | SB | BO | Surabaya - Bogor | Executive Plus SHD | 2024-04-17 | 0000-00-00 00:00:00 | 590678 | 755,000 | 31 | 0 | 31 | 23,405,000 | 100,00 | 1 | 55 | 5706 | 1 | 26-03-04 04:16:09 | jalurId | ||
| 1 | BS.903 | BS.903 | AD7410OH | 3153 | SB | BO | Surabaya - Bogor | Executive Plus SHD | 2024-04-18 | 0000-00-00 00:00:00 | 590682 | 755,000 | 32 | 2 | 30 | 22,650,000 | 93,75 | 55 | 5706 | 1 | 24-12-22 10:26:27 | jalurId | |||
| 340 | 14 | 326 | 233,330,000 | 0,00 | 7 | ||||||||||||||||||||
SELECT * from daily_rute_price where kode_rute='BS.903' and tgl>'2024-01-27' and tgl<'2026-06-13' 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 | 5706 | SB | BO | 9 | BS.903 | 590658 | 0000-00-00 00:00:00 | AD7288OF | 30 | 9 | 21 | 15,855,000 | |
| 2 | 2024-04-13 | 5706 | SB | BO | 9 | BS.903 | 590662 | 0000-00-00 00:00:00 | AD7292OF | 31 | 0 | 31 | 23,405,000 | 1 |
| 3 | 2024-04-14 | 5706 | SB | BO | 9 | BS.903 | 590666 | 0000-00-00 00:00:00 | AD7288OF | 30 | 1 | 29 | 21,895,000 | |
| 4 | 2024-04-15 | 5706 | SB | BO | 9 | BS.903 | 590670 | 0000-00-00 00:00:00 | AD7292OF | 30 | 0 | 30 | 22,650,000 | 1 |
| 5 | 2024-04-16 | 5706 | SB | BO | 9 | BS.903 | 590674 | 0000-00-00 00:00:00 | AD7288OF | 30 | 0 | 30 | 22,650,000 | 1 |
| 6 | 2024-04-17 | 5706 | SB | BO | 9 | BS.903 | 590678 | 0000-00-00 00:00:00 | AD7287OF | 31 | 0 | 31 | 23,405,000 | 1 |
| 7 | 2024-04-18 | 5706 | SB | BO | 9 | BS.903 | 590682 | 0000-00-00 00:00:00 | AD7410OH | 32 | 2 | 30 | 22,650,000 | |
| 8 | 2024-04-19 | 5706 | SB | BO | 9 | BS.903 | 590686 | 0000-00-00 00:00:00 | AD7404OH | 32 | 2 | 30 | 22,650,000 | |
| 9 | 2024-04-20 | 5706 | SB | BO | 9 | BS.903 | 590690 | 0000-00-00 00:00:00 | AD7292OF | 30 | 0 | 30 | 22,650,000 | 1 |
| 10 | 2024-04-21 | 5706 | SB | BO | 9 | BS.903 | 590694 | 0000-00-00 00:00:00 | AD7404OH | 34 | 0 | 34 | 18,870,000 | 1 |
| 11 | 2024-04-22 | 5706 | SB | BO | 9 | BS.903 | 590698 | 0000-00-00 00:00:00 | AD7292OF | 30 | 0 | 30 | 16,650,000 | 1 |
| 340 | 14 | 326 | 233,330,000 | 7 | ||||||||||
Array
(
[id] => 602
[kode_pergi] => BS.903
[kelas_id] => 9
[kode_rute_armada] => BS.903
[kelas_armada] => 9
[kode_pergi_v0] => SB.903
[kode_pulang] =>
[rute_pergi] => Surabaya - Cibitung - Bekasi - Jati Asih - Pasar Rebo - Cisalak - Depok - Cibinong - Bogor
[rute_pulang] =>
[url] =>
[info] =>
[title] => Surabaya-Sub Bungurasih ke Bogor-Bogor/tajur
[dr_agent] =>
[to_agent] =>
[dr_cd] => BS
[dr_ccd] => SB
[dr_time] => 12:35
[to_time] =>
[hplus] => 0
[to_cd] =>
[to_ccd] => BO
[create_at] => 2025-09-07 09:52:22
[dr_city] => 115
[dr_agen] => 1151
[to_city] => 313
[to_agen] => 3131
[price_count] => 0
[update_at] => 1710983407
[capacity] => 0
[price_per_seat] => 755000
[j2] => 11
[jalur_id] => 5706
[cron_at] => 1713863882
[idklsitem] => 3
[full] => 7
[jalan] => 11
[kursi_terjual] => 326
[penawaran] => 11
[omset] => 233330000
[omset_at] => 20250522
[id2] => 602
[id_old] => 602
[kelas_items] => 3,4
[nopols] => AD7287OF, AD7292OF, AD7404OH, AD7410OH
[st] => 0
[bl] => 0
[cek_time] => 0
[to_jak] => 0
)