SHARE
TWEET

Untitled

a guest Apr 11th, 2018 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. echo"
  2.    <table class='table table-plan'>
  3.        <thead>
  4.            <tr>
  5.                <th rowspan='2' class='text-center'>NO</th>
  6.                <th class='text-center' rowspan='2'>MESIN / LINE</th>
  7.                <th colspan='4' class='text-center'>MONTHLY PLAN</th>
  8.                <th colspan='3' class='text-center'>DAILY PLAN</th>
  9.                <th rowspan='2' class='text-center'>REMARKS</th>
  10.                </tr>
  11.            <tr>
  12.                <th>PART NAME</th>
  13.                <th>PART NO</th>
  14.                <th>PROCESS</th>
  15.                <th>QTY</th>
  16.                <th>PART NAME</th>
  17.                <th>PART NO</th>
  18.                <th>QTY</th>
  19.            </tr>
  20.        </thead>
  21.        <tbody>";
  22.  
  23.             $sql    = "SELECT a.Keterangan,
  24.    a.IdBukti,c.LineName,a.LineID,a.Tanggal,b.TypeProduksi AS partnamemonthly,a.PartID AS partidmonthly,a.QtyPlanning AS qtymonthly
  25. FROM
  26.    trans_ppicbdt_dt a
  27. INNER JOIN ms_part b ON b.PartId = a.PartID
  28. INNER JOIN ms_line c ON c.LineID = a.LineID
  29. WHERE
  30.    a.Tanggal = '$tglmulai' AND a.DivisiId='$divisi' AND a.IdLocation LIKE '%$lokasi%'
  31. GROUP BY
  32.    a.LineID,
  33.    a.PartID";
  34. $s      = mysqli_query($conn, $sql);
  35. $result   = mysqli_num_rows($s);
  36.         $no=1;
  37. while($r = mysqli_fetch_assoc($s)){
  38.  
  39.     $line = $r['LineName'];
  40.     $partnamemonthly = $r['partnamemonthly'];
  41.     $partidmonthly = $r['partidmonthly'];
  42.     $qtymonthly = $r['qtymonthly'];
  43.     $totqtymonthly += $qtymonthly;
  44.  
  45.     $ket = $r['Keterangan'];
  46.    
  47.     echo"
  48.    <tr>
  49.    <td class='text-center'>$no</td>
  50.    <td>$line</td>
  51.    <td>$partnamemonthly</td>
  52.    <td>$partidmonthly</td>
  53.    <td class='text-center'>ASSY</td>
  54.    <td class='text-center'>".number_format($qtymonthly,0,'.','.')."</td>
  55.    <td>$partnamemonthly</td>
  56.    <td>$partidmonthly</td>
  57.    <td class='text-center'>".number_format($qtymonthly,0,'.','.')."</td>
  58.    <td contenteditable='true' class='ket2'>$ket</td>        
  59.    </tr>";
  60.             $no++;
  61. }
  62. echo "  </tbody>
  63. <tfoot style='font-weight: bold;'>
  64. <tr>                                                    
  65.        <th colspan='5' class='text-center'>Total</th>
  66.        <td class='text-center'>".number_format($totqtymonthly,0,'.','.')."</td>
  67.        <th colspan='2' class='text-center'></th>
  68.        <td class='text-center'>".number_format($totqtymonthly,0,'.','.')."</td>
  69.        <td class='text-center'></td>
  70.    </tr>
  71. </tfoot>
  72. </table>";
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top