cso_7

if(!empty($get_layanan['id_layanan_sub'])){
		 $id_layanan = (!empty($get_layanan['id_layanan_sub']) ? $get_layanan['id_layanan_sub'] : '');
		 $data_ly= $db->Execute("select ly_lk.loket,ly.nama_sub_layanan,ly.prefix_suara,(select dt.no_urut from data_antrian as dt where dt.id_layanan=ly.nama_sub_layanan and dt.status_panggilan='0' and dt.tanggal like '".date('Y-m-d')."%'  and dt.loket=ly_lk.loket  order by dt.no_urut asc limit 0,1) as antrian from ms_layanan_sub as ly
			      inner join  tr_layanan_loket  as ly_lk
			         on ly_lk.id_layanan_sub=ly.id_layanan_sub
			    where ly.id_layanan_sub='".$id_layanan."'
			 order by -antrian desc,ly_lk.loket asc  ");

		}
		else {
		$id_layanan = (!empty($get_layanan['id_layanan']) ? $get_layanan['id_layanan'] : '');
		$data_ly= $db->Execute("select ly_lk.loket,ly.id_layanan,ly.prefix_suara,(select dt.no_urut from data_antrian as dt where dt.id_layanan=ly.id_layanan and dt.status_panggilan='0' and dt.tanggal like '".date('Y-m-d')."%'  and dt.loket=ly_lk.loket  order by dt.no_urut asc limit 0,1) as antrian from ms_layanan as ly
			      inner join  tr_layanan_loket  as ly_lk
			        on ly_lk.id_layanan=ly.id_layanan
			    where ly.id_layanan='".$id_layanan."'
			 order by -antrian desc,ly_lk.loket asc  ");
		}