Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- if(!isset($_SESSION["operasi"])){
- header("location:login.php");
- }
- include ("../connection.php");
- if(isset($_GET["get_id"])){
- $qe = mysqli_query($con, "SELECT * FROM jabatan WHERE jabatan_id='".mres($con, $_GET["get_id"])."'");
- while($row=mysqli_fetch_array($qe,MYSQLI_ASSOC)){
- $department_id = $row["jabatan_id"];
- $customer_id = $row["customer_id"];
- $department = $row["jabatan"];
- $unit = $row["unit"];
- $dpquota = $row["peruntukan_bulanan"];
- }
- }
- ?>
- <?php include ("header.php"); ?>
- <body>
- <div class="row" style="padding-left: 0px; padding-right: 0px;">
- <div class="col-lg-3 col-md-3 col-sm-3 col-xs-12" style="padding-left: 0px; padding-right: 0px;">
- <div class="col-md-12">
- <?php include ("leftmenu.php"); ?>
- </div>
- </div>
- <div class="col-lg-9 col-md-9 col-sm-9 col-xs-12">
- <div class="col-md-12">
- <div class="panel panel-info">
- <div class="panel-heading">
- <div class="panel-title">PPUKM Delivery Operation</div>
- </div>
- <div class="panel-body">
- <div class="well">
- <h3 style="text-align: center">PPUKM Department Information</h3>
- <div style="margin-bottom: 25px" class="input-group">
- <input type="hidden" name="department_id" value="<?php echo $department_id; ?>">
- <span class="input-group-addon">Customer ID</span>
- <input type="text" class="form-control" name="customer_id" id="customer_id" value="<?php echo $customer_id; ?>" readonly>
- </div>
- <div style="margin-bottom: 25px" class="input-group">
- <span class="input-group-addon">Department Name</span>
- <input type="text" class="form-control" name="department" id="department" value="<?php echo $department; ?>" readonly>
- </div>
- <div style="margin-bottom: 25px" class="input-group">
- <span class="input-group-addon">Department Unit</span>
- <input type="text" class="form-control" name="unit" id="unit" value="<?php echo $unit; ?>" readonly>
- </div>
- <div style="margin-bottom: 25px" class="input-group">
- <span class="input-group-addon">Department Monthly Quota</span>
- <input type="text" class="form-control" name="dpquota" id="dpquota" value="<?php echo $dpquota; ?>" readonly>
- </div>
- </div>
- <div class="col-md-3">
- <select name="month" class="form-control">
- <option value="" selected>-- Select Month --</option>
- <option value="1">January</option>
- <option value="2">February</option>
- <option value="3">March</option>
- <option value="4">April</option>
- <option value="5">May</option>
- <option value="6">June</option>
- <option value="7">July</option>
- <option value="8">August</option>
- <option value="9">September</option>
- <option value="10">October</option>
- <option value="11">November</option>
- <option value="12">December</option>
- </select>
- </div>
- <div class="col-md-3">
- <select name="year" class="form-control">
- <option value="" selected>-- Select Year --</option>
- <option value="2019">2019</option>
- <option value="2020">2020</option>
- <option value="2021">2021</option>
- </select>
- </div>
- <div class="col-md-5">
- <input type="button" name="btn_filter" id="btn_filter" value="Filter" class="btn btn-info" />
- </div>
- <div style="clear:both"></div>
- <br />
- <table class="table table-hover table-bordered" id="table_department">
- <thead>
- <tr>
- <th style="width:10%">Delivered Full Bottle</th>
- <th style="width:10%">Collected Empty Bottle</th>
- <th style="width:10%">Date</th>
- <th style="width:10%; height:10%;">Receipt Image</th>
- <th style="width:10%">Action</th>
- </tr>
- </thead>
- <tbody>
- <?php
- if(isset($_POST["month"], $_POST["year"])) {
- $qry = mysqli_query($con, "SELECT * FROM gallon WHERE customer_id = '".$customer_id."' AND tarikh BETWEEN '".$_POST["month"]."' AND '".$_POST["year"]."' ORDER BY tarikh desc");
- }else{
- $qry = mysqli_query($con, "SELECT * FROM gallon WHERE customer_id='".$customer_id."' ORDER BY tarikh desc");
- }
- while($row=mysqli_fetch_array($qry, MYSQLI_ASSOC)){
- echo '<tr>';
- echo '<td>'.$row["botol_penuh"]."</td><td>".$row["botol_kosong"]."</td><td>".$row["tarikh"]."</td><td><img src='../assests/images/stock/".$row["resit"]."' style='height: 300px;'></td><td><a href='resit.php?get_id=".$row["gallon_id"]."' class='btn btn-primary'> View Receipt</a></td>";
- echo '</tr>';
- }
- ?>
- </tbody>
- </table>
- </div>
- </div>
- </div>
- </div>
- </div>
- <script type="text/javascript" charset="utf8" src="../DataTables/js/dataTables.bootstrap.min.js"></script>
- <script type="text/javascript" src="../DataTables/js/jquery.dataTables.min.js"></script>
- <script>
- $(document).ready(function(){
- $('#table_department').DataTable();
- });
- </script>
- </body>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement