<div class="row"> <div class="col-md-3"></div> <div class="col-md-6"> <div class="panel panel-default"> <div class="panel-heading "> <div class="table-responsive"> <div class="form-group"> <!--<span class="col-md-0"> </span>--> <label for="search_shipment_period">เลือกรอบการส่ง</label> <span class="col-md-offset-5"> </span> <div class="form-group input-group"> <span class="input-group-addon"><i class="fa fa-calendar-o" ></i></span> <select id="idshipment" class="form-control" onchange="show_factory_table_period()" > <?php $getShipment = getShipment(); $num = sizeof($getShipment) + 1; foreach ($getShipment as $value) { $num--; $idshipment = $value['idshipment_period']; $date_start = $value['date_start']; $date_end = $value['date_end']; echo "<option value = {$idshipment}> รอบที่{$num} : {$date_start} ถึง {$date_end} </option>"; } ?> </select> </div> </div> </div> </div>
$query = "SELECT OrderID, PreferredDate, PreferredTime, Address, Status,DeliveryDate FROM Shipment NATURAL JOIN SalesOrder WHERE CustID=" . $_SESSION['ID'] . ";"; } ?> <div class="post"> <h2 class="title"><a href="#">Update Shipment Details </a></h2> <div style="clear: both;"> </div> <script type='text/javascript' src='./js/jquery.min.js'></script> <br><br><br><br> <div class="entry"> <form method="POST" action="dbentry.php"> <table id="ticketDetails" class="item-table"> <tr> <td>OrderID</td> <td>Preferred Date</td> <td>Preferred Time</td> <td>Address</td> <td>Status</td> <td>Delivery Date</td> <td>New Status</td> </tr> <?php echo getShipment($query); ?> </table> <input type="Submit" value="Apply"> </form> </div> </div> <?php include_once 'footer.php';