echo"
    <table class='table table-plan'>
        <thead>
            <tr>
                <th rowspan='2' class='text-center'>NO</th>
                <th class='text-center' rowspan='2'>MESIN / LINE</th>
                <th colspan='4' class='text-center'>MONTHLY PLAN</th>
                <th colspan='3' class='text-center'>DAILY PLAN</th>
                <th rowspan='2' class='text-center'>REMARKS</th>
                </tr>
            <tr>
                <th>PART NAME</th>
                <th>PART NO</th>
                <th>PROCESS</th>
                <th>QTY</th>
                <th>PART NAME</th>
                <th>PART NO</th>
                <th>QTY</th>
            </tr>
        </thead>
        <tbody>";

            $sql    = "SELECT a.Keterangan,
    a.IdBukti,c.LineName,a.LineID,a.Tanggal,b.TypeProduksi AS partnamemonthly,a.PartID AS partidmonthly,a.QtyPlanning AS qtymonthly
FROM
    trans_ppicbdt_dt a
INNER JOIN ms_part b ON b.PartId = a.PartID
INNER JOIN ms_line c ON c.LineID = a.LineID
WHERE
    a.Tanggal = '$tglmulai' AND a.DivisiId='$divisi' AND a.IdLocation LIKE '%$lokasi%'
GROUP BY
    a.LineID,
    a.PartID";
$s      = mysqli_query($conn, $sql);
$result   = mysqli_num_rows($s);
        $no=1;
while($r = mysqli_fetch_assoc($s)){

    $line = $r['LineName'];
    $partnamemonthly = $r['partnamemonthly'];
    $partidmonthly = $r['partidmonthly'];
    $qtymonthly = $r['qtymonthly'];
    $totqtymonthly += $qtymonthly;

    $ket = $r['Keterangan'];

    echo"
    <tr>
    <td class='text-center'>$no</td>
    <td>$line</td>
    <td>$partnamemonthly</td>
    <td>$partidmonthly</td>
    <td class='text-center'>ASSY</td>
    <td class='text-center'>".number_format($qtymonthly,0,'.','.')."</td>
    <td>$partnamemonthly</td>
    <td>$partidmonthly</td>
    <td class='text-center'>".number_format($qtymonthly,0,'.','.')."</td>
    <td contenteditable='true' class='ket2'>$ket</td>
    </tr>";
            $no++;
}
echo "  </tbody>
<tfoot style='font-weight: bold;'>
<tr>
        <th colspan='5' class='text-center'>Total</th>
        <td class='text-center'>".number_format($totqtymonthly,0,'.','.')."</td>
        <th colspan='2' class='text-center'></th>
        <td class='text-center'>".number_format($totqtymonthly,0,'.','.')."</td>
        <td class='text-center'></td>
    </tr>
</tfoot>
</table>";