		<?php
		include "../koneksi.php";
				$data2 = mysqli_query ($koneksi, "SELECT stpj.NoLot,
			stpj.PlanID,
			stpj.Shift,
			stpj.NoLot,
			coa.COA_ID,
			product.Jenis
		FROM stpj 
		INNER JOIN coa
		ON stpj.PlanID=coa.PlanID AND stpj.Shift=coa.Shift
		INNER JOIN plan
		ON stpj.PlanID=plan.PlanID
		INNER JOIN product
		ON plan.ProductID=product.ProductID
		where stpj.Del_ID=$_POST[id]
		GROUP BY stpj.NoLot");

while($row2 = mysqli_fetch_array ($data2)): ?>
		<?php if($row2['Jenis']=='color'){ ?>
		<a class='btn btn-primary btn-block' href="../laporan/coa.php?coa_id=<?php echo $row2['COA_ID']; ?>"><?php echo $row2['NoLot']; ?></a>
		<?php } else if($row2['Jenis']=='btl') { ?>
		<a class='btn btn-primary btn-block' href="../laporan/coa-bot.php?coa_id=<?php echo $row2['COA_ID']; ?>"><?php echo $row2['NoLot']; ?></a>
		<?php } else if($row2['Jenis']=='clear') { ?>
		<a class='btn btn-primary btn-block' href="../laporan/coa_clear.php?coa_id=<?php echo $row2['COA_ID']; ?>"><?php echo $row2['NoLot']; ?></a>
		<?php } else if($row2['Jenis']=='csd') { ?>
		<a class='btn btn-primary btn-block' href="../laporan/coa_csd.php?coa_id=<?php echo $row2['COA_ID']; ?>"><?php echo $row2['NoLot']; ?></a>
		<?php } ?>
		<?php endwhile; ?>
		