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

kode_pergi

kode_rute_armada

kode_pergi v0

drCity

dr_agen

kode pulang

City

to_agen

rute_pergi

jalur

dr_ccd

to_ccd

url

kelas_id

kelas_armada

dr_time

idklsitem

capacity

price_per_seat

Prev Refresh

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

select * from daily_price where kode_rute='LM.1306' 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
2	LM.1306	LM.DD06	AD7440OA	0	ML	BI	Malang - Bitung (Lantai 1)	SuperTop DD	2025-04-09	0000-00-00 00:00:00	711722	630,000	6	0	6	3,780,000	100,00	1	63	6861	1	25-08-25 12:26:35	jalurId
														6	0	6	3,780,000	0,00	1

select * from daily_rute_price where kode_rute='LM.1306' order by id limit 280

#	cdPergi	cdPergi	drCity	drAgen	toCity	toAgen	Rute	Pergi	c3	cdBalik	Kelas	Kls	Jum	Update	time	Menu
73	ML.1201		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang, Surabaya, Grogol, Kalideres, Poris, Cikokol, Bitung	62	BI.1202	12	12	736	260302062617	06:15	Edit uVo Balik
74	ML.1301		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang, Surabaya, Cikarang, Bekasi, Pondok Pinang, Cikokol, Bitung	63	BI.1302	12	12	736	260302062621	06:15	Edit uVo Balik
75	ML.1401		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang, Surabaya, Cikarang, Bekasi, Pondok Pinang, Cikokol, Bitung	13	BI.1402	12	12	736	260302062623	06:15	Edit uVo Balik
315	ML.1209		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang, Surabaya, Cikarang, Bekasi, Pondok Pinang, Cikokol, Bitung		BI.1216	12	12	18	231120095259	11:30	Edit uVo Balik
325	ML.1409		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang, Surabaya, Cikarang, Bekasi, Pondok Pinang, Cikokol, Bitung		BI.1416	12	12	18	231120095323	11:30	Edit uVo Balik
326	ML.1309		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang, Surabaya, Cikarang, Bekasi, Pondok Pinang, Cikokol, Bitung		BI.1316	12	12	18	231120095350	11:30	Edit uVo Balik
610	LM.1403	ML.1401	124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Solo - Bekasi - Kp. Rambutan - Ps. Rebo - Pd. Pinang - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 2)	13		12	12	24	240321053348	06:30	Edit uVo Balik
613	LM.1203	ML.1201	124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Solo - Bekasi - Kp. Rambutan - Ps. Rebo - Pd. Pinang - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 1)	62		12	12	24	240321053006	06:30	Edit uVo Balik
616	LM.1303	ML.1301	124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Solo - Bekasi - Kp. Rambutan - Ps. Rebo - Pd. Pinang - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 1)	63		12	12	24	240321052747	06:30	Edit uVo Balik
1020	ML.1313		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Solo - Bekasi - Kp. Rambutan - Ps. Rebo - Pd. Pinang - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 1)			12	12	26	241112054202	06:30	Edit uVo Balik
1022	ML.1413		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Solo - Bekasi - Kp. Rambutan - Ps. Rebo - Pd. Pinang - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 2)			12	12	26	241112054119	06:30	Edit uVo Balik
1027	ML.1213		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Bekasi - Kp. Rambutan - Ps. Rebo - Pd. Pinang - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 1)			12	12	26	241112053904	06:30	Edit uVo Balik
1177	ML.1417		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Terminal Grogol - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 2)			12	12	2	250126214841	12:30	Edit uVo Balik
1178	ML.1317		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Terminal Grogol - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 1)			12	12	2	250126214908	12:30	Edit uVo Balik
1179	ML.1217		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Terminal Grogol - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 1)			12	12	2	250126214930	12:30	Edit uVo Balik
1260	LM.1301		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Bekasi - Pd. Pinang - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 1)			12	12	13	250314110738	06:30	Edit uVo Balik
1263	LM.1201		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Bekasi - Pd. Pinang - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 1)			12	12	13	250314110613	06:30	Edit uVo Balik
1264	LM.1401		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Solo - Bekasi - Pd. Pinang - Kalideres - Poris Plawad - Cikokol - Bitung (Lantai 2)			12	12	13	250314110602	06:30	Edit uVo Balik
1420	LM.1306		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Cikarang - Bekasi - Cikokol - Bitung (Lantai 1)			12	12	1	250409062857	13:30	Edit uVo Balik
1421	LM.1406		124	1241	320	3151	Malang-Malang Pool ke Tangerang-Bitung	Malang - Surabaya - Cikarang - Bekasi - Cikokol - Bitung (Lantai 2)			12	12	1	250409062827	13:30	Edit uVo Balik

select * from trayek where id>0 and `dr_agen`='1241' and `to_agen`='3151' and `kelas_armada`='12'
SELECT * from daily_rute_price where kode_rute='LM.1306' 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-04-09	6861	ML	BI	14	LM.1306	711722	0000-00-00 00:00:00	AD7440OA	6	0	6	3,780,000	1
										6	0	6	3,780,000	1

Array
(
    [id] => 1420
    [kode_pergi] => LM.1306
    [kelas_id] => 14
    [kode_rute_armada] => LM.DD06
    [kelas_armada] => 12
    [kode_pergi_v0] => 
    [kode_pulang] => 
    [rute_pergi] => Malang - Surabaya - Cikarang - Bekasi - Cikokol - Bitung (Lantai 1)
    [rute_pulang] => 
    [url] => 
    [info] => 
    [title] => Malang-Malang Pool ke Tangerang-Bitung
    [dr_agent] => 
    [to_agent] => 
    [dr_cd] => LM
    [dr_ccd] => ML
    [dr_time] => 13:30
    [to_time] => 
    [hplus] => 0
    [to_cd] => 
    [to_ccd] => BI
    [create_at] => 2025-09-07 09:52:22
    [dr_city] => 124
    [dr_agen] => 1241
    [to_city] => 320
    [to_agen] => 3151
    [price_count] => 0
    [update_at] => 1744154937
    [capacity] => 0
    [price_per_seat] => 630000
    [j2] => 1
    [jalur_id] => 6861
    [cron_at] => 0
    [idklsitem] => 63
    [full] => 1
    [jalan] => 1
    [kursi_terjual] => 6
    [penawaran] => 1
    [omset] => 3780000
    [omset_at] => 20250522
    [id2] => 1420
    [id_old] => 1420
    [kelas_items] => 
    [nopols] => 
    [st] => 0
    [bl] => 0
    [cek_time] => 0
    [to_jak] => 0
)

Hiace Micro Bus Patas Pariwisata Executive Executive Plus Executive Plus SHD SuperTop SHD Executive Plus DD SuperTop DD FirstClass DD 5 SuperTopCombi ExecutivePlusCombi Tool Seq #0 Tool Seq #1 Tool Seq #2