<?php
$tglmulai='2018-01-09';
$tglselesai='2018-01-16';

//header
$tglmulai_header=date_create($tglmulai);
$tglselesai_header=date_create($tglselesai);

$interval=date_diff($tglmulai_header,$tglselesai_header)->format('%a')+1;
$add=date_interval_create_from_date_string('1 day');
date_sub($tglmulai_header,$add);




echo '<table class="table table-plan">';
echo '<thead>';
echo '<tr>';
echo '<th rowspan="2"><p align="center">NO</p></th>';
echo '<th rowspan="2"><p align="center">PART NAME</p></th>';
echo '<th rowspan="2"><p align="center"></p></th>';
echo '<th colspan="'.($interval*2).'" class="text-center">PERIODE</th>';
echo '</tr>';
echo '<tr>';
for($i=0;$i < $interval;$i++) {
  date_add($tglmulai_header,$add);
  echo '<th>'.date_format($tglmulai_header,'j').'</th><th>Mesin</th>';
}
echo '</tr>';
echo '</thead>';
//tabel data
echo '<tbody>';
$stl    = mysqli_query($conn, " SELECT a.Tanggal,a.IdMesin,a.PartID,b.PartName,
    SUM(a.QtyPlanning) AS Plan,SUM(IF (a.HasilProduksi <> 'Good', a.QtyProduksi, 0)) AS NG,
    SUM(IF (a.HasilProduksi = 'Good', a.QtyProduksi, 0)) AS OK
FROM
    trans_lhpdthp a
    INNER JOIN ms_partcategory b on b.PartID=a.PartID
WHERE a.Tanggal BETWEEN '2018-01-09' AND '2018-01-16'
GROUP BY a.PartID,a.IdMesin, a.Tanggal
ORDER BY b.PartName");
$no=1;
        while($r = mysqli_fetch_assoc($stl)){

$tglmulai_data=date_create($tglmulai);
$tglselesai_data=date_create($tglselesai);

date_sub($tglmulai_data,$add);

            echo '<td>'.$no.'</td>';
            echo '<td>'.$r['PartName'].'</td>';
            echo '<tr><td>OK</td></tr>';
            echo '<tr><td>NG</td></tr>';
$OK='<tr>';
$NG='<tr>';
for($i=0;$i < $interval;$i++) {
  date_add($tglmulai_data,$add);
  $OK.='<td>'.($r['Tanggal']==date_format($tglmulai_data,'Y-m-d')?$r['OK']:'').'</td><td></td>';
  $NG.='<td>'.($r['Tanggal']==date_format($tglmulai_data,'Y-m-d')?$r['NG']:'').'</td><td></td>';
}
$OK.='</tr>';
$NG.='</tr>';

echo $OK;
echo $NG;
$no++;
}
echo '</tbody>';
echo '</table>';
    ?>