<!--Warehouse Administrator Management Interface-->
2 <?php
3 include "inc/check_login.php";
4 include "inc/";
5 $id=mysql_link("storage","storage");//Create storage connection
6
7 $query="select * from admin where admin_id='$workid'";//Locate the warehouse
8 $result=mysql_query($query,$id);
9 $info=mysql_fetch_array($result,MYSQL_ASSOC);
$stoid=$info['storage_id'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http:///TR/1999/REC-html401-19991224/">
<html>
<head>
<LINK href="images/" type=text/css rel=stylesheet>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<title>Warehouse Management</title>
<style type="text/css">
body{
font-family:Arial,Helvetica,sans-serif; /*Set font style*/
font-size:12px;
margin:0px 240px;
height:auto;
width:800px;
border:1px solid #006633;
background-color:rgb(195,245,200);
}
</style>
</head>
<body>
<div ></div>
<ul >
<li><a href="">Note Dismiss</a></li>
<?php
echo "<li><a href=?w>enter the library</a></li>";
echo "<li><a href=?w>out library</a></li>";
?>
</ul>
<div align=center>
<div align=center>
<table width="99%" border="1" align="center" cellpadding="3" cellspacing="1">
<?php
$query="select * from storage where storage_id='$stoid'";//Locate warehouse information
$result=mysql_query($query,$id);
if(mysql_num_rows($result)<1){
echo "No repository".$stoid;
}else{
$info=mysql_fetch_array($result,MYSQL_ASSOC);
echo "Repository number:".$stoid." Total capacity:".$info['storage_cap']." Remaining capacity:".$info['storage_lcap']."
Repository address: ".$info['storage_add']." Repository phone: ".$info['storage_tele'];
if (!mysql_select_db("basicbase",$id)){
die ("Can\'t select_db : " . mysql_error());
}
//Create corresponding warehouse goods view, inlet view and outbound view in basicbase
//Judge whether there is a related view. If not, create a new view
$query="select * from ".$stoid."_inventory";
if(!mysql_query($query,$id)){
//Create inventory view
$query="create view ".$stoid."_inventory as
select inventory.goods_id,name,number from inventory, where storage_ and inventory.goods_id=.goods_id";
if(!mysql_query($query,$id)){
die ("Can\'t create_view_inventory : " . mysql_error());
}
//Create input view
$query="create view ".$stoid."_input as
select input_id,goods_id,number,time from input where admin_Can\'t create_view_input : " . mysql_error());
}
//Create an output view
$query="create view ".$stoid."_output as
select output_id,goods_id,number,time from output where admin_Can\'t create_view_output : " . mysql_error());
}
}
$query="select * from ".$stoid."_inventory";
$result=mysql_query($query,$id);
if(mysql_num_rows($result)<1){
echo "<br>The warehouse is currently empty";
}else{
$totalnum=mysql_num_rows($result);
$pagesize=7;
$page=$_GET["page"];
if(""==$page){
$page=1;
}
$begin=($page-1)*$pagesize;
$totalpage=ceil($totalnum/$pagesize);
echo "<tr>There are a total of ".$totalnum."" in the warehouse."
echo "per page".$pagesize.", total ".$totalpage." pages.</tr>";
for($j=1;$j<=$totalpage;$j++){
echo "<a href=?w&page=".$j.">[".$j."] </a>";
}
echo "<br>";
$query="select *from ".$stoid."_inventory order by goods_id limit $begin,$pagesize";
$result=mysql_query($query,$id);
$datanum=mysql_num_rows($result);
//echo "<tr><td id=table_title >Cargo id</td><td id=table_title >Cargo name</td><td id=table_title >Cargo quantity</td></tr>";
echo "<tr><td >Cargo id</td><td >Cargo name</td><td >Quantity of goods</td></tr>";
for($i=1;$i<=$datanum;$i++){
$info=mysql_fetch_array($result,MYSQL_ASSOC);
//echo "<tr><td id=table_title >".$info['goods_id']."</td><td id=table_title >".$info['name']."</td><td id=table_title >".$info['number']."</td></tr>";
echo "<tr><td >".$info['goods_id']."</td><td >".$info['name']."</td><td >".$info['number']."</td></tr>";
}
}
}
mysql_close($id);
?>
</table>
</div>
</div>
<div >Copyright: Freeze&zhaoL <br>E-mail:zhoujiebin15@</div>
</body>
</html>