📄 sell.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 product_change(){
// alert(document.form1.showpro.value);
form1.submit();
}
</script>
<html>
<body>
<?php
// 如果是提交前
if ($sell=="") { ?>
<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">
<select name="showpro" onChange="product_change()">
<option value="" selected>选择存货产品</option>
<?php
$sqlp="SELECT * FROM stock ";
$resultp = mysql_query($sqlp,$conn) or die("数据库操作错误");
while ($userrowp=mysql_fetch_Array($resultp)){
// 显示该产品信息
// 获得该产品的详细信息
$psql="select * from product where productid='$userrowp[productid]'";
$presult=mysql_query($psql,$conn);
$prow=mysql_fetch_array($presult);
if ($showpro==$userrowp[productid]){
$productid=$userrowp[productid];
$amount=$userrowp[amount];
$sellprice=$userrowp[sellprice];
$buyprice=$userrowp[buyprice];
$buytime=$userrowp[buytime];
$name=$prow[name];
$brand=$prow[brand];
$type=$prow[type];
$intro=$prow[introduction];
// 获得该产品的厂商名称
$cresult=mysql_query("select * from company where id='$prow[companyid]'",$conn);
$crow=mysql_fetch_array($cresult);
$companyid=$crow[id];
$companyname=$crow[name];
echo "<option value=$userrowp[productid] selected>$userrowp[productid]:$prow[name]</option>";
}
else {
echo "<option value=$userrowp[productid]>$userrowp[productid]:$prow[name]</option>";
}
}
?>
</select>
</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 ($showpro!=""){
echo "<td width='72%'>$companyid:$companyname</td>";
}
// 没有选择存货
else {
echo "<td width='72%'>请选择存货</td>";
// 设置产品信息变量为空
$name="";
$brand="";
$type="";
$intro="";
$showpro="";
$amount="";
$sellprice="";
$companyid="";
$companyname="";
}
?>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">产品ID：</td>
<?
// 选择了存货
if ($showpro!=""){
echo "<td width='72%'>$productid</td>";
echo "<input type=hidden name='productid' 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;
echo "<input type=hidden name='name' value=".$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%">
<?
if ($showpro!=""){
echo $amount;
echo "<input type=hidden name='amount' value=".$amount.">";
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">欲售单价：</td>
<td width="72%">
<?
if ($showpro!=""){
echo $sellprice."元";
echo "<input type=hidden name='sellprice' value=".$sellprice.">";
echo "<input type=hidden name='buyprice' value=".$buyprice.">";
echo "<input type=hidden name='buytime' value=".$buytime.">";
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">出售数量：</td>
<td width="72%">
<input type="text" name="sellamount" 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=sell value='销 售'>";
}
?>
</td>
</tr>
</table>
</form>
<?
}
// 如果是提交后处理
else {
// 查看信息是否填写完整
if ($sellamount==""){
echo "<div align=center><font color=red>没有选择产品或信息没有填写完整！</font></div>";
exit();
}
// 出售数量不能多于存货数量
if ($sellamount > $amount){
echo "sellamount:$sellamount;amount=$amount";
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*$sellamount;
$sellmoney=$sellprice*$sellamount;
// 记录这次购买活动
$sellsql="insert into selllog(user, productid, amount, buyprice, sellprice, cost, sellmoney, ip, buytime, selltime, other) values('$person', '$productid', '$sellamount', '$buyprice','$sellprice', '$cost', '$sellmoney', '$ip', '$buytime', '$now', '$other')";
mysql_query($sellsql,$conn) or die("购买产品失败: ".mysql_error());
// 检查是该存货是否还有
if ($amount==$sellamount){
// 全部买完，则删除存货
mysql_query("delete from stock where productid='$productid' and buyprice='$buyprice'",$conn) or die("出售操作失败: ".mysql_error());
}
else{
// 还有存货，则减量
$leftamount=$amount-$sellamount;
$leftcost=$buyprice*$leftamount;
$sql="update stock set amount=$leftamount, cost=$leftcost where productid='$productid' 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 + -