kode_pergi

kode_rute_armada

kode_pergi v0

drCity BandungBanjarnegaraBanyumasBaturajaBekasiBlitarBogorBoyolaliBrebesCarubanCibinongCibuburCilacapCilegonDemakDepokGunung KidulIndramayuJakartaJemberJombangKaliandaKaranganyarKarangjatiKebumenKediriKendalKepanjenKlatenKudusLampungLumajangMadiunMagelangMagetanMalangMerakMetroMojokertoMUARA ENIMNganjukNgawiPalembangPasuruanPatiPekalonganPonorogoPring SewuProbolinggoPurbalinggaPurwokertoPurworejoRembangSalatigaSemarangSerangSoloSragenSukoharjoSumedangSurabayaTangerangTangerang SelatanTegalTemanggungTrenggalekTulung AgungUngaranWatesWonogiriWonosoboYogyakarta

dr_agen BalarajaBitungCikokolCiledug BaruCiledug LamaDoyongGelamJatakeJati UwungJayantiKebon BesarKotabumi TgrKreoPasar JumatPasar KemisRajeg - TangerangTerm Poris Plawad

kode pulang

City BandungBanjarnegaraBanyumasBaturajaBekasiBlitarBogorBoyolaliBrebesCarubanCibinongCibuburCilacapCilegonDemakDepokGunung KidulIndramayuJakartaJemberJombangKaliandaKaranganyarKarangjatiKebumenKediriKendalKepanjenKlatenKudusLampungLumajangMadiunMagelangMagetanMalangMerakMetroMojokertoMUARA ENIMNganjukNgawiPalembangPasuruanPatiPekalonganPonorogoPring SewuProbolinggoPurbalinggaPurwokertoPurworejoRembangSalatigaSemarangSerangSoloSragenSukoharjoSumedangSurabayaTangerangTangerang SelatanTegalTemanggungTrenggalekTulung AgungUngaranWatesWonogiriWonosoboYogyakarta

to_agen Exit Toll Klodran - SoloGilinganHalte Depan Gedung Siti Walidah Ums KartasuraHalte Panggung Utara Sekolah Vokasi UnsIndomaret Sutami Perempatan SekarpaceKartasuraMcdonalds Jebres SoloPalur Kantor PusatPalur MandiriResto PalurRitt S. RiyadiRitt. KlecoSlamet Riyadi - SoloSolo BaruSPBU KartasuraSratenTerminal Solo

rute_pergi

jalur

dr_ccd

to_ccd

url

kelas_id SuperTopSHDSuperExecutiveExecutivePlusExecutive5PatasPariwisataMicroBusExecutivePlusSHD10Hiace12FirstClassDDSuperTopDDExecutivePlusDDSuperTopCombiExecutivePlusCombi

kelas_armada HiaceMicroBusPatasPariwisataExecutiveExecutivePlusExecutivePlusSHDCombiSuperTopSHDDoubleDecker5

dr_time

idklsitem

capacity

price_per_seat

Prev Refresh Update

Rute pergi

#	ID	Rute	dr	to	Menu
BI.332	7065	Bitung - Serpong - Cikokol - Tj. Priok - Bekasi - Cikarang - Semarang - Solo - Palur	BI	KP	Rute Pergi

select a.*,b.nama as nama_jalur,b.dr_ccd as dr_ccd, b.to_ccd as to_ccd from daily_rute_price a JOIN jalur b ON a.jalur_id=b.id where kode_rute='BI.332' group by a.jalur_id

ID	Rute	Rute	Kelas	Kode	Kota	Agen	at	-	at	Kota	Agen	Harga	Seat	c3	Sales	cID	Menu

select * from daily_price where kode_rute='BI.332' order by id desc limit 200

---

#	Kode	Kode2	NoPol	NL	dr	to	Trayek	Kelas	Tgl	Start	c2	Price	Seat	Open	Sales	Rp	%	ful	c3	jId	#	Update	Menu
0	BI.332	BI.332	AD7616OF	3137	BI	KP	-	Executive Plus	2025-10-24	0000-00-00 00:00:00	800290	0	0	1	-1	0	0,00		87	7065	0	25-10-25 19:02:22	jalurId
														0	1	-1	0	0,00	0

select * from daily_rute_price where kode_rute='BI.332' order by id limit 280

---

#	cdPergi	cdPergi	drCity	drAgen	toCity	toAgen	Rute	Pergi	NoPol	c3	cdBalik	Url	Kelas	Kls	Jum	Update	time	Menu
474	IB.307		320	3151	211	2111	Tangerang-Bitung ke Solo-Palur Kantor Pusat	Bitung - Serpong - Cikokol - Kalideres - Terminal Grogol - Semarang - Solo - Palur		61			ExecutivePlus	3	12	240318152354	16:25	Edit uVo Balik
594	IB.313		320	3151	211	2111	Tangerang-Bitung ke Solo-Palur Kantor Pusat	Bitung - Semarang - Solo - Palur		61,86			ExecutivePlus	3	7	240320051912	19:00	Edit uVo Balik
597	IB.317		320	3151	211	2111	Tangerang-Bitung ke Solo-Palur Kantor Pusat	Bitung - Semarang - Solo - Palur		86			ExecutivePlus	3	15	240320051759	16:25	Edit uVo Balik
734	IB.311		320	3151	211	2111	Tangerang-Bitung ke Solo-Palur Kantor Pusat	Serpong - Cikokol - Semarang - Solo - Palur		61,86			ExecutivePlus	3	20	240327080612	16:25	Edit uVo Balik
736	IB.312		320	3151	211	2111	Tangerang-Bitung ke Solo-Palur Kantor Pusat	Bitung - Poris Plawad - Kalideres - Terminal Grogol - Semarang - Solo - Palur		61,86			ExecutivePlus	3	16	240327080338	16:25	Edit uVo Balik
1010	BI.341		320	3151	211	2111	Tangerang-Bitung ke Solo-Palur Kantor Pusat	Bitung - Jakarta - Semarang - Solo (Rombongan)	AD7184OF				ExecutivePlus	3	1	241027122010	19:00	Edit uVo Balik
1389	BI.327		320	3151	211	2111	Tangerang-Bitung ke Solo-Palur Kantor Pusat	Bitung - BSD - Cikokol - Semarang - Palur					ExecutivePlus	3	1	250402053941	06:30	Edit uVo Balik
1565	BI.332		320	3151	211	2111							ExecutivePlus	3	1	260210111509	14:00	Edit uVo Balik

select * from trayek where id>0 and `dr_agen`='3151' and `to_agen`='2111' and `kelas_armada`='3'
SELECT * from daily_rute_price where kode_rute='BI.332' 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	2025-10-24	7065	BI	KP	3	BI.332	800290	0000-00-00 00:00:00	AD7616OF	34	1	33	0
										34	1	33	0	0

---

Array
(
    [id] => 1565
    [kode_pergi] => BI.332
    [kelas_id] => 3
    [kode_rute_armada] => BI.332
    [kelas_armada] => 3
    [kode_pergi_v0] => 
    [kode_pulang] => 
    [rute_pergi] => 
    [rute_pulang] => 
    [url] => 
    [info] => 
    [title] => 
    [dr_agent] => 
    [to_agent] => 
    [dr_cd] => BI
    [dr_ccd] => BI
    [dr_time] => 14:00
    [to_time] => 04:00
    [hplus] => 1
    [to_cd] => 
    [to_ccd] => KP
    [create_at] => 2026-02-10 04:15:09
    [dr_city] => 320
    [dr_agen] => 3151
    [to_city] => 211
    [to_agen] => 2111
    [price_count] => 0
    [update_at] => 1770696909
    [capacity] => 0
    [price_per_seat] => 0
    [j2] => 1
    [jalur_id] => 7065
    [cron_at] => 0
    [idklsitem] => 0
    [full] => 0
    [jalan] => 0
    [kursi_terjual] => 0
    [penawaran] => 0
    [omset] => 0
    [omset_at] => 0
    [id2] => 1565
    [id_old] => 1565
    [kelas_items] => 
    [nopols] => 
    [st] => 0
    [bl] => 0
    [cek_time] => 0
    [to_jak] => 0
)