Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>Baojili</title>
- <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css" />
- <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.11/css/jquery.dataTables.min.css">
- <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.16/css/dataTables.bootstrap.min.css">
- <link href="css/style.css" rel="stylesheet">
- </head>
- <body>
- <?php include_once ("manajer.php"); ?>
- <div class="container">
- <h1 align="center">Daftar Stok</h1>
- <br/>
- <ul class="nav nav-tabs" role="tablist">
- <li role="presentation" class="active"><a href="#example1-tab1" aria-controls="example1-tab1" role="tab" data-toggle="tab">Stok per Item</a></li>
- <li role="presentation"><a href="#example1-tab2" aria-controls="example1-tab2" role="tab" data-toggle="tab">Stok per Lokasi</a></li>
- </ul>
- <div class="tab-content">
- <div role="tabpanel" class="tab-pane fade in active" id="example1-tab1">
- <table id="dataTablesItem" class="table table-bordered table-striped" cellspacing="0" width="100%">
- <thead>
- <tr>
- <th>NO.</th>
- <th>Kode Barang</th>
- <th>Ukuran</th>
- <th>Total Stok</th>
- <th>Nama Lokasi</th>
- <th>Stok</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $conn = new mysqli("localhost", "root", "BiN4iNforMaTIka33", "baojili");
- if ($conn->connect_errno) {
- echo "Failed to connect to MySQL: " . $conn->connect_error;
- }
- $no = 1;
- $res = $conn->query("SELECT t_item.ItemID, t_item.Code, t_item.Size, SUM( Stock ) AS TotalStock, group_concat(t_location.Name) as Name, group_concat(t_stock.Stock) as Stock
- FROM t_stock
- LEFT JOIN t_location ON t_stock.LocationID = t_location.LocationID
- LEFT JOIN t_item ON t_stock.ItemID = t_item.ItemID
- GROUP BY ItemID");
- while($row = $res->fetch_assoc()){
- echo '
- <tr>
- <td>'.$no.'</td>
- <td>'.$row['Code'].'</td>
- <td>'.$row['Size'].'</td>
- <td>'.$row['TotalStock'].'</td>
- <td>'.str_replace(",", "<br>", $row['Name']).'</td>
- <td>'.str_replace(",", "<br>", $row['Stock']).'</td>
- </tr>
- ';
- $no++;
- }
- ?>
- </tbody>
- </table>
- </div>
- <div role="tabpanel" class="tab-pane fade in active" id="example1-tab2">
- <table id="dataTablesLocation" class="table table-bordered table-striped" cellspacing="0" width="100%">
- <thead>
- <tr>
- <th>NO.</th>
- <th>Nama Lokasi</th>
- <th>Total Stok</th>
- <th>Kode Barang</th>
- <th>Ukuran</th>
- <th>Stok</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $conn = new mysqli("localhost", "root", "BiN4iNforMaTIka33", "baojili");
- if ($conn->connect_errno) {
- echo "Failed to connect to MySQL: " . $conn->connect_error;
- }
- $no = 1;
- $res = $conn->query("SELECT t_location.Name, SUM( Stock ) AS TotalStock, t_item.Code, GROUP_CONCAT( t_item.Size ) AS Size, GROUP_CONCAT( t_stock.Stock ) AS Stock
- FROM t_stock
- LEFT JOIN t_location ON t_stock.LocationID = t_location.LocationID
- LEFT JOIN t_item ON t_stock.ItemID = t_item.ItemID
- GROUP BY Name");
- while($row = $res->fetch_assoc()){
- echo '
- <tr>
- <td>'.$no.'</td>
- <td>'.$row['Name'].'</td>
- <td>'.$row['TotalStock'].'</td>
- <td>'.$row['Code'].'</td>
- <td>'.str_replace(",", "<br>", $row['Size']).'</td>
- <td>'.str_replace(",", "<br>", $row['Stock']).'</td>
- </tr>
- ';
- $no++;
- }
- ?>
- </tbody>
- </table>
- </div>
- </div>
- <script src="http://code.jquery.com/jquery-1.12.0.min.js"></script>
- <script src="//cdn.datatables.net/1.10.11/js/jquery.dataTables.min.js"></script>
- <script>
- $(document).ready(function() {
- $('#dataTablesItem').DataTable({
- });
- $('#dataTablesLocation').DataTable({
- });
- $('a[data-toggle="tab"]').on('shown.bs.tab', function(e){
- $($.fn.dataTable.tables(true)).DataTable()
- .columns.adjust();
- });
- } );
- </script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement