sell.qg.php

来自「PHP+IIS+MySQL开发物流管理系统」· PHP 代码 · 共 493 行 · 第 1/2 页

				}
				else
				{
					$condition .= " AND o.userid='".$userRS[0]["id"]."'";
				}
			}
			else
			{
				Error("无相关会员编号信息","admin.php?file=sell&act=total&action=user");
			}
			$urlext .= "&knumber=".rawurlencode($knumber);
		}
		if($pnumber)
		{
			$condition .= " AND o.number LIKE '%".$pnumber."%'";
			$urlext.= "&pnumber=".rawurlencode($pnumber);
		}
		if($note == "my")
		{
			$condition .= " AND o.adminer='".$_SESSION["admin"]["user"]."'";
			$urlext .= "&note=".$note;
		}
		if($kuser)
		{
			$condition .= " AND o.adminer='".$kuser."'";
			$urlext .= "&kuser=".rawurlencode($kuser);
		}
		$count = $DB->qgCount("SELECT * FROM ".$prefix."o AS o ".$condition);
		$url = "admin.php?file=sell&act=total&action=list&note=".$note;
		$url .= $urlext;
		$pageid = intval($pageid);
		$psize =30;
		$pagelist = page($url,$count,$psize,$pageid);
		$offset = $pageid>0 ? ($pageid-1)*$psize : 0;
		$rs = $DB->qgGetAll("SELECT o.*,s.name AS shopname,u.postmail AS username FROM ".$prefix."o AS o Left JOIN ".$prefix."user AS u ON o.userid=u.id,".$prefix."shop AS s ".$condition." AND o.shopid=s.id ORDER BY o.selldate DESC,o.id DESC LIMIT ".$offset.",".$psize);
		echo "<table width='100%' cellspacing='0' cellpadding='0'><tr><td bgcolor='#2467D7'>";
		echo "<table width='100%' cellspacing='1'>";
		echo "<tr bgcolor='#215dc6'>";
		echo "<td width='16%' align='center' height='25px' style='color:#FFFFFF;'>产品编号</td>";
		echo "<td align='center' style='color:#FFFFFF;'>产品名称</td>";
		echo "<td width='15%' align='center' style='color:#FFFFFF;'>办事处</td>";
		echo "<td align='center' style='color:#FFFFFF;'>客 户</td>";
		echo "<td width='10%' align='center' style='color:#FFFFFF;'>售价</td>";
		echo "<td width='6%' align='center' style='color:#FFFFFF;'>数量</td>";
		echo "<td width='10%' align='center' style='color:#FFFFFF;'>管理员</td>";
		#[如果是系统管理员，则启用管理]
		if($_SESSION["admin"]["typer"] == "system")
		{
			echo "<td width='12%' align='center' style='color:#FFFFFF;'>操 作</td>";
		}
		echo "</tr>\n";
		foreach($rs AS $key=>$value)
		{
			echo "<tr bgcolor='#FFFFFF' onMouseOver=\"this.style.backgroundColor='#FFFFB9'\" onMouseOut=\"this.style.backgroundColor='#FFFFFF'\">";
			echo "<td align='center' height='25px;' title='销售时间：".date("Y-m-d H:i:s",$value["selldate"])."'>".$value["number"]."</td>";
			echo "<td align='left' title='".$value["note"]."'>&nbsp;".$value["subject"]."</td>";
			echo "<td align='center'>".$value["shopname"]."</td>";
			echo "<td align='center'>".$value["username"]."</td>";
			echo "<td align='center'>".$value["price"]." 元</td>";
			echo "<td align='center'>".$value["pcount"]."</td>";
			echo "<td align='center'>".$value["adminer"]."</td>";
			if($_SESSION["admin"]["typer"] == "system")
			{
				echo "<td align='center'>".HtmlButton("编辑","admin.php?file=sell&act=modify&id=".$value["id"]).HtmlButton("打印","admin.php?file=sell&act=dayin&id=".$value["id"]).HtmlButton("删除","delete_confirm(".$value["id"].")",false)."</td>";
			}
			echo "</tr>\n";
		}
		#[统计总销售信息]
		$rs = $DB->qgGetOne("SELECT sum(o.price) AS totalPrice,sum(o.pcount) AS totalCount FROM ".$prefix."o AS o ".$condition);
		if($rs["totalCount"])
		{
			echo "<tr bgcolor='#FFFFFF'>";
			echo "<td colspan='10' align='center' height='30px'>".$msg."总计销售量：".$rs["totalCount"]." ，销售额：".$rs["totalPrice"]." 元 </td>";
			echo "</tr>\n";
		}
		echo "</table>";
		echo "</td></tr></table>";
		if($pagelist)
		{
			HtmlEchoMsg("<table width='100%'><tr><td align='right'>".$pagelist."</td></tr></table>");
		}
	}
}
elseif($act == "delete")
{
	if($_SESSION["admin"]["typer"] != "system")
	{
		Error("只有系统管理员才有权限删除销售记录","admin.php?file=product&act=total&action=list");
	}
	if(empty($id))
	{
		Error("操作非法","admin.php?file=product&act=total&action=list");
	}
	#[获取旧的销售记录]
	$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."o WHERE id='".$id."'");
	if(!$rs)
	{
		Error("记录不存在！","admin.php?file=sell&act=total&action=list");
	}
	$DB->qgQuery("UPDATE ".$prefix."product SET sellcount=sellcount-".$rs["pcount"]." WHERE id='".$rs["proid"]."'");
	#[删除记录]
	$DB->qgQuery("DELETE FROM ".$prefix."o WHERE id='".$id."'");
	Error("记录成功删除！","admin.php?file=sell&act=total&action=list");
}
elseif($act == "modify")
{
	if($_SESSION["admin"]["typer"] != "system")
	{
		Error("只有系统管理员才有权限删除销售记录","admin.php?file=product&act=total&action=list");
	}
	if(empty($id))
	{
		Error("操作非法","admin.php?file=product&act=total&action=list");
	}
	$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."o WHERE id='".$id."'");
	#[获取产品单价]
	$rsPro = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE id='".$rs["proid"]."'");
	$perPrice = $rsPro["price"];
	#[获取会员信息]
	$userCard = "";
	if($rs["userid"])
	{
		$userRS = $DB->qgGetOne("SELECT * FROM ".$prefix."user WHERE id='".$rs["userid"]."'");
		$userCard = $userRS["number"];
	}
	$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE id='".$id."'");
	HtmlStartForm("admin.php?file=sell&act=modifyok&id=".$id);
	HtmlEchoMsg("产品型号：",$rs["subject"]);
	HtmlEchoMsg("内部型号：",$rs["neibu"]);
	HtmlEchoMsg("产品编号：",$rs["number"]);
	HtmlEchoMsg("产品价格：",$rs["price"]." 元");
	HtmlEchoMsg("*销售部门：",RadioShop("shopid",$rs["shopid"])." [选择销售部门]");
	HtmlEchoMsg("*出售数量：","<input type='text' name='pcount' id='pcount' value='".$rs["pcount"]."' class='short_input' onkeyup='gettotal(this.form)'>");
	HtmlEchoMsg("*总售价：","<input type='text' name='price' id='price' value='".$rs["price"]."' class='short_input'> 元 &nbsp; ".ZheKo("price"));
	echo "\n<script language='javascript' type='text/javascript'>\n";
	echo "function gettotal(form){\n";
	echo "form.price.value = form.pcount.value * ".$perPrice.";\n";
	echo "}\n</script>\n";
	HtmlEchoMsg("*包装规格：",$rs["guige"]." KG/箱");
	HtmlEchoMsg("客户编号：","<input type='text' name='usernumber' id='usernumber' value='".$userCard."'> <img src='./admin/images/friends.gif' align='absmiddle' style='cursor: pointer;cursor: hand;' onclick=\"qgOpen('admin.php?file=open.user&act=list&form=form&input=usernumber','form','500','600')\"> <img src='./admin/images/cleanup.gif' border='0' align='absmiddle' title='清空客户编号' onclick=\"qinggan_cleanup('usernumber')\" style='cursor: pointer;cursor: hand;'> [如有客户编号，请输入客户编号]");
	#[时间]
	HtmlEchoMsg("销售时间：","<input type='text' name='selldate' value='".date("Y-m-d H:i:s",$rs["selldate"])."'>");
    HtmlEchoMsg("运费付款方式：","<input type='text' name='yunfei' value='' class='long_input'> ");
	HtmlEchoMsg("收款方式：","<input type='text' name='shoukuan' value=''  class='long_input'> ");
	HtmlEchoMsg("备注：","<input type='text' name='note' class='long_input' value='".$rs["note"]."'> [不超过80个汉字]");
	HtmlEchoMsg("",HtmlButton("提 交").HtmlButton("返 回","admin.php?file=sell&act=total&action=list"));
}
elseif($act == "dayin")
{
	if($_SESSION["admin"]["typer"] != "system")
	{
		Error("只有系统管理员才有权限删除销售记录","admin.php?file=product&act=total&action=list");
	}
	if(empty($id))
	{
		Error("操作非法","admin.php?file=product&act=total&action=list");
	}
	$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."o WHERE id='".$id."'");
	#[获取产品单价]
	$rsPro = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE id='".$rs["proid"]."'");
	$perPrice = $rsPro["price"];
	#[获取会员信息]
	$userCard = "";
	if($rs["userid"])
	{
		$userRS = $DB->qgGetOne("SELECT * FROM ".$prefix."user WHERE id='".$rs["userid"]."'");
		$userCard = $userRS["number"];
	}
	$userName = "";
	if($rs["userid"])
	{
		$userRSa = $DB->qgGetOne("SELECT * FROM ".$prefix."user WHERE id='".$rs["userid"]."'");
		$userName = $userRSa["user"];
	}
	$userAddress = "";
	if($rs["userid"])
	{
		$userRSb = $DB->qgGetOne("SELECT * FROM ".$prefix."user WHERE id='".$rs["userid"]."'");
		$userAddress = $userRSb["address"];
	}
	$userPostmail = "";
	if($rs["userid"])
	{
		$userRSc = $DB->qgGetOne("SELECT * FROM ".$prefix."user WHERE id='".$rs["userid"]."'");
		$userPostmail = $userRSc["postmail"];
	}
	$userPhone= "";
	if($rs["userid"])
	{
		$userRSd = $DB->qgGetOne("SELECT * FROM ".$prefix."user WHERE id='".$rs["userid"]."'");
		$userPhone = $userRSd["phone"];
	}
	$userMobile = "";
	if($rs["userid"])
	{
		$userRSe = $DB->qgGetOne("SELECT * FROM ".$prefix."user WHERE id='".$rs["userid"]."'");
		$userMobile = $userRSe["mobile"];
	}
	HtmlStartForm("admin.php?file=sell&act=modifyok&id=".$id);
	HtmlEchoMsg(include("admin/huoyun.php"));
	
}
elseif($act == "modifyok")
{
	if($_SESSION["admin"]["typer"] != "system")
	{
		Error("只有系统管理员才有权限删除销售记录","admin.php?file=product&act=total&action=list");
	}
	if(empty($id))
	{
		Error("操作非法","admin.php?file=product&act=total&action=list");
	}
	$shopid = intval($shopid);
	if(empty($shopid))
	{
		$shopRS = $DB->qgGetOne("SELECT * FROM ".$prefix."shop WHERE ifdefault=1");
		if(empty($shopRS))
		{
			Error("请管理员先设置默认店铺！","admin.php?file=shopset&act=list");
		}
		$shopid = $shopRS["id"];
	}
	$pcount = intval($pcount);
	$price = SafeHtml($price);
	settype($price,"float");
	$selldate = strtotime($selldate);
	$note = SafeHtml($note);
	#[判断是否有会员卡号]
	$userid = 0;
	if($usernumber)
	{
		$userRS = $DB->qgGetOne("SELECT id FROM ".$prefix."user WHERE number='".$usernumber."'");
		if($userRS)
		{
			$userid = $userRS["id"];
		}
		else
		{
			Error("该会员卡号不存在！请检查...","admin.php?file=sell&act=modify&id=".$id);
		}
	}
	#[入库]
	$DB->qgQuery("UPDATE ".$prefix."o SET pcount='".$pcount."',price='".$price."',selldate='".$selldate."',note='".$note."',shopid='".$shopid."',userid='".$userid."' WHERE id='".$id."'");
	Error("销售信息编辑成功！","admin.php?file=sell&act=total&action=list");
}
?>