Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php while($rec=mysqli_fetch_assoc($qry)) {
- $daily = explode('#$#',$rec['daily']);
- $monthly = explode('#$#',$rec['monthly']);
- $remark = explode('#$#',$rec['remark']);
- $rowspan = count($daily)>count($monthly) ? count($daily) : count($monthly);
- echo '<tr>';
- echo '<td'.($rowspan>1?' rowspan='.$rowspan:'').' align=center>'.$no.'</td>';
- echo '<td'.($rowspan>1?' rowspan='.$rowspan:'').' align=center>'.$rec['LineOther'].'</td>';
- $TypeProduksi = $PartID = $QtyPlanning = array();
- foreach($monthly as $idx => $val) {
- list($TypeProduksi[],$PartID[],$QtyPlanning[]) = explode('#&#',$val);
- $totmonthlyplan+=implode('', $QtyPlanning); //totalmonthlyplan
- }
- echo '<td'.($rowspan>1?' rowspan='.$rowspan:'').' >'.implode('<div class="tbcellspacing"></div>',$TypeProduksi).'</td>';
- echo '<td'.($rowspan>1?' rowspan='.$rowspan:'').' >'.implode('<div class="tbcellspacing"></div>',$PartID).'</td>';
- echo '<td'.($rowspan>1?' rowspan='.$rowspan:'').' align=center>'.implode('<div class="tbcellspacing"></div>')."ASSY".'</td>';
- echo '<td'.($rowspan>1?' rowspan='.$rowspan:'').' align=center>'.implode('<div class="tbcellspacing"></div>',$QtyPlanning).'</td>';
- $TypeProduksi = $PartID = $QtyPlanning = array();
- foreach($daily as $idx => $val) {
- list($TypeProduksi[],$PartID[],$QtyPlanning[]) = explode('#&#',$val);
- $totdailyplan+=implode('', $QtyPlanning); //totaldailyplan
- }
- echo '<td'.($rowspan>1?' rowspan='.$rowspan:'').'>'.implode('<div class="tbcellspacing"></div>',$TypeProduksi).'</td>';
- echo '<td'.($rowspan>1?' rowspan='.$rowspan:'').'>'.implode('<div class="tbcellspacing"></div>',$PartID).'</td>';
- echo '<td'.($rowspan>1?' rowspan='.$rowspan:'').' align=center>'.implode('<div class="tbcellspacing"></div>',$QtyPlanning).'</td>';
- $PartID = '';$Remark = array();
- foreach($remark as $idx => $val) {
- list($PartID,$Remark[]) = explode('#&#',$val);
- }
- echo '<td'.($rowspan>1?' rowspan='.$rowspan:'').' style="width:450px" contenteditable="true">'.implode('<div class="tbcellspacing"></div>',$Remark).'</td>'; // hasilnya Remark 1
- echo '</tr>';
- for($i=1;$i<count($Remark);$i++) { // hasilnya sisa record Remark 2 ...
- echo '<tr></tr>';
- }
- $no++;
- }
- echo '</tbody>
- <tfoot style="font-weight: bold;"">
- <tr>
- <th colspan="5" class="text-center">Total</th>
- <td class="text-center">'.number_format($totmonthlyplan,0,'.','.').'</td>
- <th colspan="2" class="text-center"></th>
- <td class="text-center">'.number_format($totdailyplan,0,'.','.').'</td>
- <td class="text-center"></td>
- </tr>
- </tfoot>
- </table>';
- } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement