<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">
								<a href="index.php?page=formUMKM&act=add" class="mb-xs mt-xs mr-xs btn btn-primary"><i class="fa fa-plus-square"></i> Tambah Data Baru</a>
								<hr class="dotted short">
								<table class="table table-bordered table-striped mb-none" id="datatable-default">
									<thead>
										<tr>
											<th width="10px" >No</th>
											<th>Nama UMKM</th>
											<th>Nama Pemilik</th>
											<th>No. HP/WA</th>
											<th>Jenis Usaha</th>
											<th>NIB</th>																						
											<th>Alamat UMKM</th>
											<th>Modal</th>
											<th>Video</th>
											<th width="150px">Act</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;
									//debug($data);
									foreach($data as $v){
									echo '
									    <tr>										
                                        	<td>'.$x.'</td>
                                        	<td>'.$v['umkmNama'].'</td>
                                        	<td>'.$v['umkmPemilik'].'</td>
                                        	<td>'.$v['umkmHP'].'</td>
                                        	<td>'.$v['umkmJenis'].'</td>
                                        	<td>'.$v['umkmNIB'].'</td>																																
                                        	<td>'.$v['umkmAlamat'].'</td>
                                        	<td>'.$v['umkmModal'].'</td>
                                        	<td>'.$v['umkmVideo'].'</td>
                                        	<td align="center">
												<a href="index.php?page=formUMKM&act=edit&id='.$v['umkmID'].'" class="mb-xs mt-xs mr-xs btn btn-default" role="button"><i class="fa fa-pencil"></i></a>
												<a href="#modalHeaderColorPrimary'.$v['umkmID'].'" class="mb-xs mt-xs mr-xs btn btn-default modal-basic" role="button"  ><i class="fa fa-trash-o"></i></a>												
											</td>											
										</tr>';											
									$x++;
									}
									?>										
									</tbody>
								</table>
							</div>						
						</section>
						<?php
						foreach($data as $v){
						?>
						<div id="modalHeaderColorPrimary<?php echo $v['umkmID'];?>" class="modal-block modal-header-color modal-block-primary mfp-hide">
							<section class="panel">
								<header class="panel-heading">
									<h2 class="panel-title">Are you sure?</h2>
								</header>
								<div class="panel-body">
									<div class="modal-wrapper">
										<div class="modal-icon">
											<i class="fa fa-trash-o"></i>
										</div>
										<div class="modal-text">
											<h4>Hapus</h4>
											<p>Apakah Anda Ingin menghapus Data "<?php echo $v['umkmNama'];?>" ?</p>
										</div>
									</div>
								</div>
								<footer class="panel-footer">
									<div class="row">
										<div class="col-md-12 text-right">
											<a href="index.php?act=deleteUMKM&id=<?php echo $v['umkmID'];?>" class="btn btn-primary">Ya</a>
											<button class="btn btn-default modal-dismiss">Tidak</button>
										</div>
									</div>
								</footer>
							</section>
						</div>
						<?php
						}
						?>						
<?php
}elseif(($_GET['tipe']=='pma')){
?>	
						<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 PENANAMAN MODAL ASING (PMA)</h2>
							</header>
							<div class="panel-body">
								<a href="index.php?page=formPMA&act=add" class="mb-xs mt-xs mr-xs btn btn-primary"><i class="fa fa-plus-square"></i> Tambah Data Baru</a>
								<hr class="dotted short">
								<table class="table table-bordered table-striped mb-none" id="datatable-default">
									<thead>
										<tr>
											<th width="10px" >No</th>
											<th>Sektor</th>
											<th>Sub Sektor</th>
											<th>Nama Usaha</th>
											<th>Negara</th>
											<th>Alamat</th>
											<th>email</th>																						
											<th>Bidang Usaha</th>
											<th>Investasi</th>
											<th>Video</th>
											<th width="150px">Act</th>
										</tr>										
									</thead>
									<tbody>
									<?php
									$stmt = $conn->prepare("SELECT * FROM tbl_ub WHERE ubTipe='PMA' ORDER BY ubID DESC"); 
									$stmt->execute();
									$data = $stmt->fetchAll();
									$stmt->closeCursor();
									$x=1;
									//debug($data);
									foreach($data as $v){
									echo '
									    <tr>										
                                        	<td>'.$x.'</td>
                                        	<td>'.$v['ubSektor'].'</td>
                                        	<td>'.$v['ubSubSektor'].'</td>
                                        	<td>'.$v['ubNama'].'</td>
                                        	<td>'.$v['ubNegara'].'</td>
                                        	<td>'.$v['ubAlamat'].'</td>																																
                                        	<td>'.$v['ubEmail'].'</td>
                                        	<td>'.$v['ubBidangUsaha'].'</td>
                                        	<td>'.$v['ubInvestasi'].'</td>
                                        	<td>'.$v['umkmVideo'].'</td>
                                        	<td align="center">
												<a href="index.php?page=formPMA&act=edit&id='.$v['ubID'].'" class="mb-xs mt-xs mr-xs btn btn-default" role="button"><i class="fa fa-pencil"></i></a>
												<a href="#modalHeaderColorPrimary'.$v['ubID'].'" class="mb-xs mt-xs mr-xs btn btn-default modal-basic" role="button"  ><i class="fa fa-trash-o"></i></a>												
											</td>											
										</tr>';											
									$x++;
									}
									?>										
									</tbody>
								</table>
							</div>						
						</section>
						<?php
						foreach($data as $v){
						?>
						<div id="modalHeaderColorPrimary<?php echo $v['ubID'];?>" class="modal-block modal-header-color modal-block-primary mfp-hide">
							<section class="panel">
								<header class="panel-heading">
									<h2 class="panel-title">Are you sure?</h2>
								</header>
								<div class="panel-body">
									<div class="modal-wrapper">
										<div class="modal-icon">
											<i class="fa fa-trash-o"></i>
										</div>
										<div class="modal-text">
											<h4>Hapus</h4>
											<p>Apakah Anda Ingin menghapus Data "<?php echo $v['ubNama'];?>" ?</p>
										</div>
									</div>
								</div>
								<footer class="panel-footer">
									<div class="row">
										<div class="col-md-12 text-right">
											<a href="index.php?act=deleteUB&id=<?php echo $v['ubID'];?>&tipe=pma" class="btn btn-primary">Ya</a>
											<button class="btn btn-default modal-dismiss">Tidak</button>
										</div>
									</div>
								</footer>
							</section>
						</div>
						<?php
						}
						?>						

<?php	
}elseif(($_GET['tipe']=='pmdn')){
?>	
						<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 PENANAMAN MODAL DALAM NEGERI (PMDN)</h2>
							</header>
							<div class="panel-body">
								<a href="index.php?page=formPMDN&act=add" class="mb-xs mt-xs mr-xs btn btn-primary"><i class="fa fa-plus-square"></i> Tambah Data Baru</a>
								<hr class="dotted short">
								<table class="table table-bordered table-striped mb-none" id="datatable-default">
									<thead>
										<tr>
											<th width="10px" >No</th>
											<th>Sektor</th>
											<th>Sub Sektor</th>
											<th>Nama Usaha</th>
											<th>Alamat</th>
											<th>email</th>																						
											<th>Bidang Usaha</th>
											<th>Investasi</th>
											<th>Video</th>
											<th width="150px">Act</th>
										</tr>										
									</thead>
									<tbody>
									<?php
									$stmt = $conn->prepare("SELECT * FROM tbl_ub WHERE ubTipe='PMDN' ORDER BY ubID DESC"); 
									$stmt->execute();
									$data = $stmt->fetchAll();
									$stmt->closeCursor();
									$x=1;
									//debug($data);
									foreach($data as $v){
									echo '
									    <tr>										
                                        	<td>'.$x.'</td>
                                        	<td>'.$v['ubSektor'].'</td>
                                        	<td>'.$v['ubSubSektor'].'</td>
                                        	<td>'.$v['ubNama'].'</td>
                                        	<td>'.$v['ubAlamat'].'</td>																																
                                        	<td>'.$v['ubEmail'].'</td>
                                        	<td>'.$v['ubBidangUsaha'].'</td>
                                        	<td>'.$v['ubInvestasi'].'</td>
                                        	<td>'.$v['umkmVideo'].'</td>
                                        	<td align="center">
												<a href="index.php?page=formPMDN&act=edit&id='.$v['ubID'].'" class="mb-xs mt-xs mr-xs btn btn-default" role="button"><i class="fa fa-pencil"></i></a>
												<a href="#modalHeaderColorPrimary'.$v['ubID'].'" class="mb-xs mt-xs mr-xs btn btn-default modal-basic" role="button"  ><i class="fa fa-trash-o"></i></a>												
											</td>											
										</tr>';											
									$x++;
									}
									?>										
									</tbody>
								</table>
							</div>						
						</section>
						<?php
						foreach($data as $v){
						?>
						<div id="modalHeaderColorPrimary<?php echo $v['ubID'];?>" class="modal-block modal-header-color modal-block-primary mfp-hide">
							<section class="panel">
								<header class="panel-heading">
									<h2 class="panel-title">Are you sure?</h2>
								</header>
								<div class="panel-body">
									<div class="modal-wrapper">
										<div class="modal-icon">
											<i class="fa fa-trash-o"></i>
										</div>
										<div class="modal-text">
											<h4>Hapus</h4>
											<p>Apakah Anda Ingin menghapus Data "<?php echo $v['ubNama'];?>" ?</p>
										</div>
									</div>
								</div>
								<footer class="panel-footer">
									<div class="row">
										<div class="col-md-12 text-right">
											<a href="index.php?act=deleteUB&id=<?php echo $v['ubID'];?>&tipe=pmdn" class="btn btn-primary">Ya</a>
											<button class="btn btn-default modal-dismiss">Tidak</button>
										</div>
									</div>
								</footer>
							</section>
						</div>
						<?php
						}
						?>						

<?php	
}
?>

</section>