product.qg.php

PHP+IIS+MySQL开发物流管理系统

<?php
#[产品管理]
include_once("./class/upload.class.php");
$UP = new UPLOAD("./upfiles/","jpg,gif,png");
if($act == "add")
{
	if($_SESSION["admin"]["typer"] != "system" && $_SESSION["admin"]["typer"] != "manager")
	{
		Error("只有一般管理员或系统管理员才有此权限！","admin.php?file=index");
	}
	$cateid = intval($cateid);
	HtmlCheckNumberJs("admin.php?file=product&act=chknumber","regnumber","number");#[验证编码的JS信息]
	HtmlStartForm("admin.php?file=product&act=addok",true);
	HtmlEchoMsg("*产品分类：",SelectCate($cateid,"cateid")." [请选择一个分类]");
	HtmlEchoMsg("*产品编号：","<input type='text' name='regnumber'> ".HtmlCheckNumberButton("检查编号是否存在"));
	HtmlEchoMsg("*产品名称：","<input type='text' name='pinming' class='long_input'>");
	HtmlEchoMsg("*产品型号：","<input type='text' name='subject' class='long_input'>");
	HtmlEchoMsg("*产品售价：","<input type='text' name='price' class='short_input'> 元");
	HtmlEchoMsg("产品图片：","<input type='file' name='picture'>");
	HtmlEchoMsg("产品简介：","<textarea name='content' style='width:400px;height:80px;'></textarea>");
	HtmlEchoMsg("",HtmlButton("添 加"));
	HtmlEndForm();
}
elseif($act == "addok")
{
	if($_SESSION["admin"]["typer"] != "system" && $_SESSION["admin"]["typer"] != "manager")
	{
		Error("只有一般管理员或系统管理员才有此权限！","admin.php?file=index");
	}
	$cateid = intval($cateid);
	$number = SafeHtml($regnumber);
	$pinming = SafeHtml($pinming);
	$subject = SafeHtml($subject);
	$price = SafeHtml($price);
	$picture = $UP->up("picture",$system_time);
	$content = SafeHtml($content);
	#[将产品价格设为浮点类型]
	settype($price,"float");
	#[判断如果产品名称或产品编号为空时，自动跳回去]
	if(empty($number) || empty($subject))
	{
		Error("产品编号或产品名称不允许为空！","admin.php?file=product&act=add&cateid=".$cateid);
	}
	#[检测编号是否存在]
	$check_number = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE number='".$number."'");
	if($check_number)
	{
		Error("产品编号已经存在了！","admin.php?file=product&act=add&cateid=".$cateid);
	}
	#[入库]
	$DB->qgQuery("INSERT INTO ".$prefix."product(cateid,number,pinming,subject,price,picture) VALUES('".$cateid."','".$number."','".$pinming."','".$subject."','".$price."','".$picture."')");
	$id = $DB->qgInsertID();
	if($content)
	{
		$DB->qgQuery("INSERT INTO ".$prefix."content(id,content) VALUES('".$id."','".$content."')");
	}
	Error("产品已经添加成功！","admin.php?file=product&act=add&cateid=".$cateid);
}
elseif($act == "list")
{
	DeleteJs("admin.php?file=product&act=delete&id=","确实要删除该产品吗？删除后所有相关信息将会被删除！");
	$cateid = intval($cateid);
	$keywords = $keywords ? rawurldecode($keywords) : "";
	if($keywords)
	{
		$keywords = SafeHtml($keywords);
	}
	HtmlStartForm("admin.php?file=product&act=list");
	HtmlEchoMsg(SelectCate($cateid,"cateid","",true)." <input type='text' name='keywords' value='".$keywords."'>".HtmlButton("搜 索")." [可以输入编号或产品名称关键字进行搜索]");
	HtmlEndForm();
	$condition = "WHERE 1";
	if($cateid)
	{
		$condition .= " AND p.cateid='".$cateid."'";
	}
	if($keywords)
	{
		$condition .= " AND (p.number LIKE '%".$keywords."%' OR p.subject LIKE '%".$keywords."%')";
	}
	$count = $DB->qgCount("SELECT * FROM ".$prefix."product AS p ".$condition);
	$url = "admin.php?file=product&act=list&cateid=".$cateid."&keywords=".rawurlencode($keywords);
	$psize = 30;
	$pageid = intval($pageid);
	$pagelist = page($url,$count,$psize,$pageid);
	$offset = $pageid > 0 ? (($pageid-1)*$psize) : 0;
	$rs = $DB->qgGetAll("SELECT p.*,c.name FROM ".$prefix."product AS p,".$prefix."cate AS c ".$condition." AND p.cateid=c.id 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='9%' align='center' height='25px' style='color:#FFFFFF;'>产品编号</td>";
	echo "<td align='center' style='color:#FFFFFF;'>产品型号</td>";
	echo "<td align='center' style='color:#FFFFFF;' width='7%'>销售</td>";
	echo "<td width='11%' align='center' style='color:#FFFFFF;'>产品分类</td>";
	echo "<td width='9%' align='center' style='color:#FFFFFF;'>售价</td>";
	echo "<td align='center' style='color:#FFFFFF;' width='7%'>库存</td>";
	echo "<td width='22%' align='center' style='color:#FFFFFF;'>操 作</td>";
	echo "<td align='center' style='color:#FFFFFF;' width='7%'>总数</td>";
	echo "</tr>\n";
	foreach($rs AS $key=>$value)
	{
		$bgcolor = ($value["procount"]-$value["sellcount"]) < 1 ? "#FFA851" : "#FFFFFF";
		echo "<tr bgcolor='".$bgcolor."' onMouseOver=\"this.style.backgroundColor='#FFFFB9'\" onMouseOut=\"this.style.backgroundColor='".$bgcolor."'\">";
		echo "<td align='center' height='25px'><a href='admin.php?file=product&act=view&id=".$value["id"]."'>".$value["number"]."</a></td>";
		echo "<td align='left' title='".$value["subject"]."'>&nbsp;<a href='admin.php?file=product&act=view&id=".$value["id"]."' title='".$value["subject"]."'>".CutString($value["subject"],29)."</a></td>";
		echo "<td align='center'>".$value["sellcount"]."</td>";
		echo "<td align='center'><a href='admin.php?file=product&act=list&cateid=".$value["cateid"]."'>".$value["name"]."</a></td>";
		echo "<td align='center'>".$value["price"]." 元</td>";
		echo "<td align='center'>".($value["procount"]-$value["sellcount"])."</td>";
		$cz = "[<a href='admin.php?file=sell&act=sell&id=".$value["id"]."'>出售</a>]";
		$cz.= "[<a href='admin.php?file=product&act=layin&id=".$value["id"]."'>入库</a>]";
		$cz.= "[<a href='admin.php?file=product&act=modify&id=".$value["id"]."'>编辑</a>]";
		$cz.= "[<a href='#' onclick='delete_confirm(".$value["id"].")'>删除</a>]";
		echo "<td align='center'>".$cz."</td>";
		echo "<td align='center'>".$value["procount"]."</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 == "view")
{
	if($qnumber)
	{
		$rs = $DB->qgGetOne("SELECT id FROM ".$prefix."product WHERE number='".$qnumber."'");
		if($rs)
		{
			$id = $rs["id"];
		}
		else
		{
			Error("不存在该编号！","admin.php?file=product&act=list");
		}
	}
	#[获取产品详细信息]
	if(empty($id))
	{
		Error("操作非法","admin.php?file=product&act=list");
	}
	$rs = $DB->qgGetOne("SELECT p.*,c.name FROM ".$prefix."product AS p,".$prefix."cate AS c WHERE p.id='".$id."' AND p.cateid=c.id");
	$rsContent = $DB->qgGetOne("SELECT * FROM ".$prefix."content WHERE id='".$id."'");
	$rs["content"] = $rsContent["content"];
	unset($rsContent);
	echo "<table width='100%' cellspacing='0' cellpadding='0'><tr><td bgcolor='#2467D7'>";
	echo "<table width='100%' cellspacing='1'>";
	echo "<tr><td colspan='4' style='background:#FFFFFF;height:30px;'>&nbsp;产品编号：".$rs["number"]." 的详细信息 &nbsp; </td></tr>\n";
	echo "<tr bgcolor='#215dc6'>";
	echo "<td width='13%' align='center' height='25px' style='color:#FFFFFF;'>产品1名称</td>";
	echo "<td width='52%' align='left' style='background:#FFFFFF;'>&nbsp;".$rs["pinming"]."</td>";
	echo "<td width='13%' align='center' height='25px' style='color:#FFFFFF;'>产品型号</td>";
	echo "<td width='52%' align='left' style='background:#FFFFFF;'>&nbsp;".$rs["subject"]."</td>";
	echo "<td width='15%' align='center' style='color:#FFFFFF;'>产品价格</td>";
	echo "<td width='20%' align='center' style='background:#FFFFFF;'>".$rs["price"]." 元</td>";
	echo "</tr>\n";
	echo "<tr bgcolor='#215dc6'>";
	echo "<td align='center' height='25px' style='color:#FFFFFF;'>产品分类</td>";
	echo "<td align='left' style='background:#FFFFFF;'>&nbsp;".$rs["name"]."</td>";
	echo "<td align='center' style='color:#FFFFFF;'>产品图片</td>";
	$pic = "暂无图片";
	if($rs["picture"])
	{
		$picInfo = @getimagesize("./upfiles/".$rs["picture"]);
		$width = $picInfo[0] ? ($picInfo[0] + 30) : 800;
		$height = $picInfo[1] ? ($picInfo[0] + 100) : 600;
		if($width > 800)
		{
			$width = 800;
		}
		$javascriptUrl = "javascript:qgOpen('admin.php?file=open.product&act=viewpic&pic=".$rs["picture"]."','id','".$width."','".$height."')";
		$pic = "[<a href=\"".$javascriptUrl."\">点击查看</a>] [<a href='admin.php?file=product&act=deletepic&id=".$id."'>点此删除</a>]";
	}
	echo "<td align='center' style='background:#FFFFFF;'>".$pic."</td>";
	echo "</tr>\n";
	if($rs["content"])
	{
		echo "<tr bgcolor='#215dc6'>";
		echo "<td align='center' height='25px' style='color:#FFFFFF;'>产品介绍</td>";
		echo "<td align='left' style='background:#FFFFFF;padding:10px;' colspan='3'>".$rs["content"]."</td>";
		echo "</tr>";
	}
	echo "<tr><td colspan='4' style='background:#FFFFFF;height:30px;'>&nbsp;".HtmlButton("产品入库","admin.php?file=product&act=view&action=add&id=".$id).HtmlButton("进货日志","admin.php?file=product&act=view&action=log&id=".$id).HtmlButton("产品销售","admin.php?file=sell&act=sell&id=".$id).HtmlButton("销售日志","admin.php?file=product&act=view&action=sell_log&id=".$id).HtmlButton("产品编辑","admin.php?file=product&act=modify&id=".$id).HtmlButton("返回列表","admin.php?file=product&act=list")."</td></tr>\n";
	echo "</table>";
	echo "</td></tr></table>\n";
	if($action == "add")
	{
		if($_SESSION["admin"]["typer"] != "system" && $_SESSION["admin"]["typer"] == "manager")
		{
			HtmlEchoMsg("","只有系统管理员或一般管理员才有此权限...");
			Foot();
			die();
		}
		HtmlEchoMsg("<b>添加新产品进货入库</b>");
		HtmlStartForm("admin.php?file=product&act=view_addok&id=".$id);
		HtmlEchoMsg("*产品数量：","<input type='text' name='pcount' class='short_input'>");
		HtmlEchoMsg("*进货价格：","<input type='text' name='price' class='short_input'> [只能输入产品的<span style='color:red;'>单价</span>即可，系统会自动计算总价]");
		HtmlEchoMsg("*进货时间：","<input type='text' name='enterdate' value='".date("Y-m-d H:i:s",$system_time)."'>");
		HtmlEchoMsg("",HtmlButton("入 库"));
		HtmlEndForm();
	}
	elseif($action == "log")
	{
		if($_SESSION["admin"]["typer"] != "system")
		{
			HtmlEchoMsg("","只有系统管理员才有查看的权限");
			Foot();
			die();
		}
		#[计算总数]
		$count = $DB->qgCount("SELECT * FROM ".$prefix."i WHERE 1 AND proid='".$id."'");
		$psize = 30;#[每页显示30条日志]
		$pageid = intval($pageid);
		$url = "admin.php?file=product&act=view&action=log&id=".$id;
		$pagelist = page($url,$count,$psize,$pageid);
		$offset = $pageid>0 ? ($pageid-1)*$psize : 0;
		$rs = $DB->qgGetAll("SELECT * FROM ".$prefix."i WHERE 1 AND proid='".$id."' ORDER BY enterdate DESC,id DESC LIMIT ".$offset.",".$psize);
		HtmlEchoMsg("<b>该产品入库日志</b>");
		foreach($rs AS $key=>$value)
		{
			HtmlEchoMsg(date("Y-m-d H:i:s",$value["enterdate"]),"&nbsp; [进货价格：".$value["price"]." 元] [数量：".$value["pcount"]."]",true);
		}
		if($pagelist)
		{
			HtmlEchoMsg("<table width='100%'><tr><td align='right'>".$pagelist."</td></tr></table>");
		}
	}
	elseif($action == "sell_log")
	{
		if($_SESSION["admin"]["typer"] != "system")
		{
			HtmlEchoMsg("","只有系统管理员才有查看的权限");
			Foot();
			die();
		}
		$count = $DB->qgCount("SELECT * FROM ".$prefix."o WHERE 1 AND proid='".$id."'");
		$psize = 30;
		$pageid = intval($pageid);
		$url = "admin.php?file=product&act=view&action=sell_log&id=".$id;
		$pagelist = page($url,$count,$psize,$pageid);
		$offset = $pageid>0 ? ($pageid-1)*$psize : 0;
		$rs = $DB->qgGetAll("SELECT * FROM ".$prefix."o WHERE 1 AND proid='".$id."' ORDER BY selldate DESC,id DESC LIMIT ".$offset.",".$psize);
		HtmlEchoMsg("<b>该产品销售日志</b>");
		foreach($rs AS $key=>$value)
		{
			HtmlEchoMsg(date("Y-m-d H:i:s",$value["selldate"]),"&nbsp; [销售价格：".$value["price"]." 元] [销售数量：".$value["pcount"]."]",true);