WEBWMS
/
order.php

<?php
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	if(!isset($_SESSION)){
		session_start();
	}

	$sql="SELECT * FROM  `order_doc_header`
		  ORDER BY  `order_doc_header`.`id` DESC ";
	$result=mysql_query($sql,$dbc);

?>
<html>
<head>
<title>订单列表</title>
<script src="utils.js" type="text/javascript"></script>
<script src="order.js" type="text/javascript"></script>
<link rel="stylesheet" href="./themes/base/jquery.ui.all.css">
<script src="jquery-1.9.1.js"></script>
<script src="./ui/jquery.ui.core.js"></script>
<script src="./ui/jquery.ui.widget.js"></script>
<script src="./ui/jquery.ui.mouse.js"></script>
<script src="./ui/jquery.ui.draggable.js"></script>
<script src="./ui/jquery.ui.position.js"></script>
<script src="./ui/jquery.ui.resizable.js"></script>
<script src="./ui/jquery.ui.button.js"></script>
<script src="./ui/jquery.ui.dialog.js"></script>
<link rel="stylesheet" href="demos.css">
<style type="text/css">
<!--
body {
	#background-color: #00FFF1;
	background:url(yh3.gif);
}
table {
	border-collapse : collapse;
	background-color: #FFFFF0;
}
.STYLE2 {
	background-color: #FFFFFF;
}
table#border{
#border-top:#000 1px solid;
#border-left:#000 1px solid;
}
table#border td{
#border-bottom:#000 1px solid;
#border-right:#000 1px solid;
}
-->
</style>
</head>
<body align="center">
<p>
<div id="showDetail" title="Order Detail"></div>
<br>
<div id="alldata">
<table align="center" border="1" cellpadding="3" cellspacing="3">
	<tr>
		<td>id</td>
		<td>OrderID 订单ID</td>
		<td>createDate 创建日期	</td>
		<td>customerID 用户ID</td>
		<td>sendAddress 送货地址</td>
		<td>totalPrice 订单总价格</td>
		<td>SOID 对应的SOID</td>
		<td>orderStatus 订单状态 </td>
		<td>a6</td>
		<td>a7</td>
		<td>
		操作 接单
		</td>
	</tr>
	<?php while($row_Rec=mysql_fetch_assoc($result)){ ?>
	<tr>
		<td><?php echo $row_Rec['id']?></td>
		<td><?php echo $row_Rec['OrderID']?></td>
		<td><?php echo $row_Rec['createDate']?></td>
		<td><?php echo $row_Rec['customerID']?></td>
		<td><?php echo $row_Rec['sendAddress']?></td>
		<td><?php echo $row_Rec['totalPrice']?></td>
		<td id="<?php echo $row_Rec['id']?>"><?php echo $row_Rec['SOID']?></td>
		<td><?php echo $row_Rec['orderStatus']?></td>
		<td><?php echo $row_Rec['a6']?></td>
		<td><?php echo $row_Rec['a7']?></td>
		<td>
			<a href="#" id="<?php echo $row_Rec['id']?>">OK</a>
			|
			<a href="#" id="<?php echo $row_Rec['id']?>">SHOW</a>
		</td>
	</tr>
	<?php } ?>
</table>
</div>
</body>
</html>