001.<script type="text/javascript">
002.function MM_jumpMenu(targ,selObj,restore){
003.eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
004.if (restore) selObj.selectedIndex=0;
005.}
006.</script>
007.<body class="hold-transition skin-blue sidebar-mini">
008.<div class="wrapper">
009.<?php include '../admin/partials/header.php'; ?>
010.<?php include '../admin/partials/leftmenu.php'; ?>
011. <div class="content-wrapper">
012. <div id="title-breadcrumb-option-demo" class="page-title-breadcrumb">
013. <!--END-->
014. <!--BEGIN CONTENT-->
015.<?php
016.mysql_select_db('myweb_db',$connection);
017.$query_db = "SELECT * FROM orders ORDER BY OrderID DESC";
018.$link = mysql_query($query_db) or die(mysql_error());
019.$totalRows_db = mysql_num_rows($link);
020.?>
021.
022.<?php
023.mysql_connect("localhost","root","12345678");
024.mysql_select_db("myweb_db");
025. mysql_query("SET character_set_results=utf8");
026. mysql_query("SET character_set_client=utf8");
027. mysql_query("SET character_set_connection=utf8");
028.$strSQL = "SELECT * FROM orders_detail WHERE OrderID = '".$_GET["OrderID"]."'";
029.$objQuery = mysql_query($strSQL) or die(mysql_error());
030.$objResult = mysql_fetch_array($objQuery);
031.
032.?>
033. <div class="page-content">
034. <div class="col-md-12">
035. <div class="panel panel-dark" id="member">
036. <div class="panel-heading"><center><h3>รายการออเดอร์</h3>
037. <form name="form" id="form">
038. <label><font color="#CC0000" size="4">สถานะ : </font></label>
039. <select name="jumpMenu" id="jumpMenu" onchange="">
040. <option>กรุณาเลือก</option>
041. <option value="click1">ชำระแล้ว</option>
042. <option value="click2">ค้างชำระ</option>
043. </select>
044.<div class="panel-body">
045. <table class="table table-hover table-striped">
046. <thead>
047. <tr>
048. <th>รหัสออเดอร์</th>
049. <th>วันที่สั่งออเดอร์</th>
050. <th>ชื่อ</th>
051. <th>ที่อยู่</th>
052. <th>เบอร์โทร</th>
053. <th>E-mail</th>
054. <th>สถานะ</th>
055. <th>ตั้งค่า</th>
056. </tr>
057. </thead>
058. <?php while ($row_db = mysql_fetch_array($link)){ ?>
059. <?php
060. <tbody>
061. <tr>
062. <td><a href="viewfileorder.php?OrderID=<?php echo $row_db['OrderID'];?>"><?php echo $row_db['OrderID'];?> </a></td>
063. <td><?php echo $row_db['OrderDate']; ?></td>
064. <td><?php echo $row_db['Name']; ?></td>
065. <td><?php echo $row_db['Address']; ?></td>
066. <td><?php echo $row_db['Tel']; ?></td>
067. <td><?php echo $row_db['Email']; ?></td>
068. <?php if( $row_db['Status'] == 'ค้างชำระ' ) { ?>
069. <td><div class="alert alert-danger" role="alert"><?php echo $row_db['Status']; ?></div></td>
070. <?php }else{ ?>
071. <td><div class="alert alert-success" role="alert"><?php echo $row_db['Status']; ?></td>
072. <?php } ?>
073.
074.
075.
076. <td>
077.
078. <?php if( $row_db['Status'] == 'ค้างชำระ' ) { ?>
079. <form action="updatestatus.php?OrderID=<?php echo $row_db['OrderID'];?>" method="post">
080. <input type="hidden" value="<?php echo $row_db['OrderID'];?>" name="OrderID" />
081. <input type="hidden" value="ชำระแล้ว" name="status" readonly >
082. <button type="submit" class="btn btn-success">ปรับสถานะเป็นชำระแล้ว</button>
083. </form>
084. <?php }else{ ?>
085.
086. <?php } ?>
087.
088. </td>
089. </tr>
090.
091. </tbody>
092. <?php } ?>
093.
094. </table>
095. </div>
096. </form>
097.
098. </div>
099. <!--END CONTENT-->
100.
101. </div>
102. <!--END PAGE WRAPPER-->
103. </div>
104.</div>
105. </body>
106.<?php
107.mysql_free_result($link);
108.?>
