📄 buy.php
字号:
<?
//初始化session
session_cache_expire(30);
session_start();
// 如果没有登录，退出
if(!isset($_SESSION['user'])) {
echo "<p align=center>";
echo "<font color=#FF0000 size=5><strong><big>";
echo "您还没有登录,请<a href='login.php'>登录</a>!";
echo "</big></strong></font></p>";
exit();
}
include ('head.php');
require ('dbconnect.php');
?>
<script language="JavaScript">
function company_change(){
form1.submit();
}
function product_change(){
form1.submit();
}
</script>
<html>
<body>
<?php
// 如果是提交前
if ($buy=="") { ?>
<form name="form1" method="post" action="<?php echo $PHP_SELF ?>" >
<table width="60%" border="0" cellspacing="1" cellpadding="3" align="center" bordercolor="#8695AC">
<tr>
<th colspan="2">进 货 登 记</th>
</tr>
<tr align="center">
<td colspan="2"> </td>
</tr>
<tr align="center">
<td colspan="2">
<table width="60%"><tr><td align=center width="50%">
<select name="show" onChange="company_change()">
<option value="" selected>选择产品所属厂商</option>
<?php
$sql="SELECT * FROM company";
$result = mysql_query($sql,$conn) or die("数据库操作错误");
while ($userrow=mysql_fetch_Array($result)){
// 显示该厂商信息
if ($show==$userrow[id]){
// 保存该厂商名字和id用于以后显示
$companyid=$userrow[id];
$companyname=$userrow[name];
echo "<option value=$userrow[id] selected>$userrow[id]:$userrow[name]</option>";
}
else {
echo "<option value=$userrow[id]>$userrow[id]:$userrow[name]</option>";
}
}
?>
</select>
</td>
<td align=center width="50%">
<select name="showpro" onChange="product_change()">
<option value="" selected>选择产品</option>
<?php
$sqlp="SELECT * FROM product where companyid='$companyid'";
$resultp = mysql_query($sqlp,$conn) or die("数据库操作错误");
while ($userrowp=mysql_fetch_Array($resultp)){
// 显示该产品信息
if ($showpro==$userrowp[productid]){
$productid=$userrowp[productid];
$name=$userrowp[name];
$brand=$userrowp[brand];
$type=$userrowp[type];
$intro=$userrowp[introduction];
echo "<option value=$userrowp[productid] selected>$userrowp[productid]:$userrowp[name]</option>";
}
else {
echo "<option value=$userrowp[productid]>$userrowp[productid]:$userrowp[name]</option>";
}
}
?>
</select>
</td></tr></table>
</td>
</tr>
<tr>
<td width="28%" align="center" > </td>
<td width="72%"> </td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">厂商ID：</td>
<?
// 显示原记录
if ($show!=""){
echo "<td width='72%'>$companyid:$companyname</td>";
echo "<input type=hidden name='old_id' value=".$companyid.">";
}
// 添加新记录
else {
echo "<td width='72%'>请选择厂商</td>";
// 设置产品信息变量为空
$name="";
$brand="";
$type="";
$intro="";
$showpro="";
}
?>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品ID：</td>
<?
// 显示原记录
if ($showpro!=""){
echo "<td width='72%'>$productid</td>";
echo "<input type=hidden name='old_pid' value=".$productid.">";
}
// 添加新记录
else {
echo "<td width='72%'>请选择产品</td>";
}
?>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品名称：</td>
<td width="72%">
<?
// 如果选择了产品，则显示产品信息
if ($showpro!=""){
echo $name;
}
// 如果没有选择产品，则不显示任何信息
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品品牌：</td>
<td width="72%">
<?
if ($showpro!=""){
echo $brand;
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品类型：</td>
<td width="72%">
<?
if ($showpro!=""){
echo $type;
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品介绍：</td>
<td width="72%">
<?
if ($showpro!=""){
echo $intro;
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">购买数量：</td>
<td width="72%">
<input type="text" name="amount" size="30" maxlength="50">
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">单 价：</td>
<td width="72%">
<input type="text" name="buyprice" size="30" maxlength="50" >元
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">总花费：</td>
<td width='72%'>自动计算</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">备 注：</td>
<td width="72%">
<textarea name="other" cols="60" rows='5'></textarea>
</td>
</tr>
<tr align="center">
<td colspan="2">
<?php
// 选择了产品才可以购买
if ($showpro!=""){
echo "<input type=submit name=buy value='购 买'>";
}
?>
</td>
</tr>
</table>
</form>
<?
}
// 如果是提交后处理
else {
// 查看信息是否填写完整
if (($amount=="")||($buyprice=="")||($old_pid=="")||($old_id=="")){
echo "<div align=center><font color=red>没有选择产品或信息没有填写完整！</font></div>";
exit();
}
// 可以购买
// 取得当前时间和日前
$now = date("Y-m-d H:i:s");
// 得到登录ip.
$ip=getenv (REMOTE_ADDR);
$person=$_SESSION['user'];
$cost=$buyprice*$amount;
// 记录这次购买活动
$buysql="insert into buylog(user, productid, amount, buyprice, cost, ip, buytime, other) values('$person', '$old_pid', '$amount', '$buyprice', '$cost', '$ip', '$now', '$other')";
mysql_query($buysql,$conn) or die("购买产品失败: ".mysql_error());
// 登记已购买的产品入库
$sellprice=$buyprice*1.20;
// 检查是否已有该产品存货而且进价一样
$result=mysql_query("select * from stock where productid='$old_pid' and buyprice='$buyprice'", $conn);
$row=mysql_fetch_array($result);
// 如果没有存货，登记存货
if (empty($row)){
$sql="insert into stock(productid, amount, buyprice, sellprice, cost, introduction, buytime, other) values('$old_pid', '$amount', '$buyprice', '$sellprice', '$cost', '$intro', '$now', '$other')";
mysql_query($sql,$conn) or die("购买产品失败: ".mysql_error());
}
// 如果已有存货，数量增加
else {
$amount+=$row[amount];
$cost+=$row[cost];
$sql="update stock set amount=$amount, cost=$cost, buytime=$now where productid='$old_pid' and buyprice='$buyprice'";
mysql_query($sql, $conn) or die("购买产品失败: ".mysql_error());
}
?>
<p align="center"> </p>
<p align="center"> </p>
<p align="center"><font color="red">购买成功！</font><br></p>
<p align="center"><a href="<?php echo $PHP_SELF ?>">继续添加</a><br>
</p><?php } ?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -