<section role="main" class="content-body">
<?php
if($_GET['tipe']=='umkm') {	
?>	
					<!-- start: page -->
						<section class="panel panel-featured panel-featured-primary" style="margin-top:-60px;">
							<header class="panel-heading">
								<div class="panel-actions">
									<a href="#" class="fa fa-caret-down"></a>
								</div>
								<h2 class="panel-title"><i class="fa fa-list"></i> DATA UMKM</h2>
							</header>
							<div class="panel-body">

								<table class="table table-bordered table-striped mb-none" id="datatable-default">
									<thead>
										<tr>
											<th width="10px" rowspan="2">No</th>
											<th rowspan="2">Tgl. Daftar</th>											
											<th rowspan="2">Nama UMKM</th>
											<th rowspan="2">Nama Pemilik</th>
											<th rowspan="2">No. HP/WA</th>
											<th rowspan="2">Jenis Usaha</th>
											<th rowspan="2">Alamat UMKM</th>
											<th rowspan="2">Kekayaan Bersih</th>
											<th rowspan="2">Omset Tahunan</th>											
											<th colspan="5" style="text-align:center">Media Sosial</th>
											<th rowspan="2">Perizinan</th>
											<th rowspan="2">Foto</th>
										</tr>
										<tr>
											<th>Instagram</th>
											<th>Youtube</th>	
											<th>Facebook</th>
											<th>Website</th>
											<th>Lainnya</th>
										</tr>										
									</thead>
									<tbody>
									<?php
									$stmt = $conn->prepare("SELECT * FROM tbl_UMKM ORDER BY umkmID DESC"); 
									$stmt->execute();
									$data = $stmt->fetchAll();
									$stmt->closeCursor();
									$x=1;
									foreach($data as $v){
										$medsos = explode(';',$v['umkmMediaSosial']);
									echo '
									    <tr>										
                                        	<td>'.$x.'</td>
                                        	<td>'.tglNormal($v['umkmTglDaftar'],'/').'</td>
                                        	<td>'.$v['umkmNama'].'</td>
                                        	<td>'.$v['umkmPemilik'].'</td>
                                        	<td>'.$v['umkmHP'].'</td>
                                        	<td>'.$v['umkmJenis'].'</td>
                                        	<td>'.$v['umkmAlamat'].'</td>
                                        	<td>'.$v['umkmModal'].'</td>
                                        	<td>'.$v['umkmOmset'].'</td>
                                        	<td>'.$medsos[0].'</td>
                                        	<td>'.$medsos[1].'</td>
                                        	<td>'.$medsos[2].'</td>
                                        	<td>'.$medsos[3].'</td>
                                        	<td>'.$medsos[4].'</td>
                                        	<td align="center">
												<a class="mb-xs mt-xs mr-xs btn btn-default" role="button" href="https://dpmptsp.pekanbaru.go.id/promosi/assets/upload/'.$v['umkmPerizinan'].'" target="_blank"><i class="fa fa-file"></i></a>
											</td>
                                        	<td align="center">
												<a class="mb-xs mt-xs mr-xs btn btn-default" role="button" href="https://dpmptsp.pekanbaru.go.id/promosi/assets/upload/'.$v['umkmFoto'].'"  target="_blank"><i class="fa fa-image"></i></a>
											</td>											
											
											</tr>';											
									$x++;
									}
									?>										
									</tbody>
								</table>
							</div>						
						</section>
<?php
}elseif(($_GET['tipe']=='ub')){
?>	
						<section class="panel panel-featured panel-featured-primary" style="margin-top:-60px;">
							<header class="panel-heading">
								<div class="panel-actions">
									<a href="#" class="fa fa-caret-down"></a>
								</div>
								<h2 class="panel-title"><i class="fa fa-list"></i> DATA USAHA BESAR</h2>
							</header>
							<div class="panel-body">

								<table class="table table-bordered table-striped mb-none" id="datatable-default">
									<thead>
										<tr>
											<th width="10px" rowspan="2">No</th>
											<th rowspan="2">Tgl. Daftar</th>											
											<th rowspan="2">Nama</th>
											<th rowspan="2">Jabatan</th>
											<th rowspan="2">No. HP</th>
											<th rowspan="2">Email</th>
											<th rowspan="2">Jenis Usaha</th>
											<th colspan="5" style="text-align:center">Media Sosial</th>
											<th rowspan="2">Perizinan</th>
											<th rowspan="2">Foto</th>
										</tr>
										<tr>
											<th>Instagram</th>
											<th>Youtube</th>	
											<th>Facebook</th>
											<th>Website</th>
											<th>Lainnya</th>
										</tr>										
									</thead>
									<tbody>
									<?php
									$stmt = $conn->prepare("SELECT *  FROM tbl_UB ORDER BY ubID DESC"); 
									$stmt->execute();
									$data = $stmt->fetchAll();
									$stmt->closeCursor();
									$x=1;
									foreach($data as $v){
										$medsos = explode(';',$v['ubMediaSosial']);
									echo '
									    <tr>										
                                        	<td>'.$x.'</td>
                                        	<td>'.tglNormal($v['ubTglDaftar'],'/').'</td>
                                        	<td>'.$v['ubNama'].'</td>
                                        	<td>'.$v['ubJabatan'].'</td>
                                        	<td>'.$v['ubHP'].'</td>
                                        	<td>'.$v['ubEmail'].'</td>
                                        	<td>'.$v['ubJenis_usaha'].'</td>
                                        	<td>'.$medsos[0].'</td>
                                        	<td>'.$medsos[1].'</td>
                                        	<td>'.$medsos[2].'</td>
                                        	<td>'.$medsos[3].'</td>
                                        	<td>'.$medsos[4].'</td>
                                        	<td align="center">
												<a class="mb-xs mt-xs mr-xs btn btn-default" role="button" href="https://dpmptsp.pekanbaru.go.id/promosi/assets/upload/'.$v['ubPerizinan'].'" target="_blank"><i class="fa fa-file"></i></a>
											</td>
                                        	<td align="center">
												<a class="mb-xs mt-xs mr-xs btn btn-default" role="button" href="https://dpmptsp.pekanbaru.go.id/promosi/assets/upload/'.$v['ubFoto'].'"  target="_blank"><i class="fa fa-image"></i></a>
											</td>											
											
											</tr>';											
									$x++;
									}
									?>										
									</tbody>
								</table>
							</div>						
						</section>

<?php	
}
?>

</section>