?? 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>選擇存貨產(chǎn)品</option>
<?php
$sqlp="SELECT * FROM stock ";
$resultp = mysql_query($sqlp,$conn) or die("數(shù)據(jù)庫操作錯誤");
while ($userrowp=mysql_fetch_Array($resultp)){
// 顯示該產(chǎn)品信息
// 獲得該產(chǎn)品的詳細信息
$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];
// 獲得該產(chǎn)品的廠商名稱
$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>";
// 設置產(chǎn)品信息變量為空
$name="";
$brand="";
$type="";
$intro="";
$showpro="";
$amount="";
$sellprice="";
$companyid="";
$companyname="";
}
?>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">產(chǎn)品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">產(chǎn)品名稱：</td>
<td width="72%">
<?
// 如果選擇了產(chǎn)品，則顯示產(chǎn)品信息
if ($showpro!=""){
echo $name;
echo "<input type=hidden name='name' value=".$name.">";
}
// 如果沒有選擇產(chǎn)品，則不顯示任何信息
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">產(chǎn)品品牌：</td>
<td width="72%">
<?
if ($showpro!=""){
echo $brand;
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">產(chǎn)品類型：</td>
<td width="72%">
<?
if ($showpro!=""){
echo $type;
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">產(chǎn)品介紹：</td>
<td width="72%">
<?
if ($showpro!=""){
echo $intro;
}
else {
echo " ";
}
?>
</td>
</tr>
<tr>
<td width="28%" align="center" bgcolor="#F0F8FF">存貨數(shù)量：</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">出售數(shù)量：</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
// 選擇了產(chǎn)品才可以購買
if ($showpro!=""){
echo "<input type=submit name=sell value='銷 售'>";
}
?>
</td>
</tr>
</table>
</form>
<?
}
// 如果是提交后處理
else {
// 查看信息是否填寫完整
if ($sellamount==""){
echo "<div align=center><font color=red>沒有選擇產(chǎn)品或信息沒有填寫完整！</font></div>";
exit();
}
// 出售數(shù)量不能多于存貨數(shù)量
if ($sellamount > $amount){
echo "sellamount:$sellamount;amount=$amount";
echo "<div align=center><font color=red>出售數(shù)量不能多于存貨數(shù)量！</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("購買產(chǎn)品失敗: ".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 ?>">繼續(xù)添加</a><br>
</p><?php } ?>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -