| 品名 | 單位 | 數量 | 單價 | 運費 | 小計 | 刪除 | 修改 |
if ($_SESSION["TmoID"]=='')
{
if(trim($_SESSION["Account"])=='')
{
$arr=range(1,9); //先生出一個包含1~20數字的陣列
shuffle($arr); //使此陣列亂數排列一遍
$arr=array_slice($arr,0,5); //取出陣列的前九個出來即可
for ($i=0;$i<5;$i++)
{
$TmoID=$TmoID.$arr["$i"];
}
// echo chr($TmoID);
$TmoID="$TmoID";
$_SESSION["TmoID"]=$TmoID;
}
else
{
$_SESSION["TmoID"]=trim($_SESSION["Account"]);
}
//echo $_SESSION["TmoID"];
}
$result = mysql_query("select * from sd_product where ProductID =".$_GET["ProductID"]."");
$RS= mysql_fetch_array($result,MYSQL_ASSOC);
$Title=$RS['Title'];
$Unit=$RS['Unit'];
$Price=$RS['Price'];
$PostPrice=$RS['PostPrice'];
$Cost=$RS['Cost'];
$VenderID=$RS['VenderID'];
//將訂購資料加入tmporder中
//先判斷裡面有沒有一樣的品項
$sql="Select Amount from sd_ordertmp where ProductID=".$_GET["ProductID"]." and Account='".$_SESSION["TmoID"]."'";
$result = mysql_query($sql);
$RS= mysql_fetch_array($result,MYSQL_ASSOC);
if (($RS['Amount'])=='')
{
$sql = "insert into sd_ordertmp (Account,Title,ProductID,Amount,Unit,Price,PostPrice,Cost,VenderID) values ('".$_SESSION["TmoID"]."','".$Title."','".$ProductID."',1,'".$Unit."',".$Price.",".$PostPrice.",".$Cost.",".$VenderID.")";
$result = mysql_query($sql);
}
else
{
$sql = "update sd_ordertmp Set Amount=Amount+1 where ProductID=".$_GET["ProductID"]." and Account='".$_SESSION["TmoID"]."'";
$result = mysql_query($sql);
}
//再將此Uesr的訂購明細列出
$sql ="Select * from sd_ordertmp where Account='".$_SESSION["TmoID"]."'";
//echo $sql;
$result = mysql_query($sql);
$TotalPrice=0;
$TotalPost=0;
$TotalNetPrice=0;
$VenderIDStr='';
while ($RS= mysql_fetch_array($result,MYSQL_ASSOC))
{
$TotalNetPrice=$TotalNetPrice+($RS['Price']*$RS['Amount']);
$ComBe="*".$RS['VenderID']."*";
//$TotalPost=$TotalPost+$RS['PostPrice'];
// echo "| ".$RS['Title']." | ".$RS['Unit']." | ".$RS['Amount']." | ".$RS['Price']." | ".$RS['PostPrice']." | ".(($RS['Price']*$RS['Amount'])+$RS['PostPrice'])." | 刪 | 修 | ";
if ($VenderIDStr=='')//判斷有沒有同一家的運費,沒有資料
{
echo "| ".$RS['Title']." | ".$RS['Unit']." | ".$RS['Amount']." | ".$RS['Price']." | ".$RS['PostPrice']." | ".(($RS['Price']*$RS['Amount'])+$RS['PostPrice'])." | 刪 | 修 | ";
$TotalPost=$RS['PostPrice'];
$VenderIDStr="*".$RS['VenderID']."*";
}
else
{
if (strchr($VenderIDStr,$ComBe)<>"")//有找到同一家廠商的話運費就不加
{
echo "| ".$RS['Title']." | ".$RS['Unit']." | ".$RS['Amount']." | ".$RS['Price']." | 0 | ".(($RS['Price']*$RS['Amount']))." | 刪 | 修 | ";
}
else
{
echo "| ".$RS['Title']." | ".$RS['Unit']." | ".$RS['Amount']." | ".$RS['Price']." | ".$RS['PostPrice']." | ".(($RS['Price']*$RS['Amount'])+$RS['PostPrice'])." | 刪 | 修 | ";
$TotalPost=$TotalPost+$RS['PostPrice'];
$VenderIDStr=$VenderIDStr.$RS['VenderID']."*";
}
}
// echo $TotalPost." ";
}
if (($TotalNetPrice)>=1800)
{
$TotalPost=0;
}
$TotalPrice=$TotalNetPrice+$TotalPost;
mysql_free_result($RS);
?>
| 小計(不含運費) | |
| 運費 | |
| 總價(含運費) | |
|