product.qg.php

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

		}
		if($pagelist)
		{
			HtmlEchoMsg("<table width='100%'><tr><td align='right'>".$pagelist."</td></tr></table>");
		}
	}
}
elseif($act == "view_addok")
{
	if($_SESSION["admin"]["typer"] != "system" && $_SESSION["admin"]["typer"] != "manager")
	{
		Error("只有一般管理员或系统管理员才有此权限！","admin.php?file=index");
	}
	if(empty($id))
	{
		Error("操作非法","admin.php?file=product&act=list");
	}
	#[获取相关信息]
	$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE id='".$id."'");
	$pcount = intval($pcount);
	$price = SafeHtml($price);
	settype($price,"float");
	$enterdate = SafeHtml($enterdate);
	$enterdate = strtotime($enterdate);
	#[入库]
	$DB->qgQuery("INSERT INTO ".$prefix."i(proid,subject,pinming,number,pcount,price,enterdate,adminer) VALUES('".$id."','".$rs["subject"]."','".$rs["pinming"]."','".$rs["number"]."','".$pcount."','".$price."','".$enterdate."','".$_SESSION["admin"]["user"]."')");
	#[更新产品总数]
	$DB->qgQuery("UPDATE ".$prefix."product SET procount=procount+".$pcount." WHERE id='".$id."'");
	Error("产品：".$rs["subject"]." 入库成功！","admin.php?file=product&act=view&id=".$id);
}
elseif($act == "modify")
{
	if($_SESSION["admin"]["typer"] != "system" && $_SESSION["admin"]["typer"] != "manager")
	{
		Error("只有一般管理员或系统管理员才有此权限！","admin.php?file=index");
	}
	if(empty($id))
	{
		Error("操作非法","admin.php?file=product&act=list");
	}
	$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE id='".$id."'");
	HtmlCheckNumberJs("admin.php?file=product&act=chknumber&id=".$id,"regnumber","number");#[验证编码的JS信息]
	HtmlStartForm("admin.php?file=product&act=modifyok&id=".$id,true);
	HtmlEchoMsg("*产品分类：",SelectCate($rs["cateid"],"cateid")." [请选择一个分类]");
	HtmlEchoMsg("*产品编号：","<input type='text' name='regnumber' value='".$rs["number"]."'> ".HtmlCheckNumberButton("检查编号是否存在"));
	HtmlEchoMsg("*产品名称：","<input type='text' name='pinming' class='long_input' value='".$rs["pinming"]."'>");
	HtmlEchoMsg("*产品型号：","<input type='text' name='subject' class='long_input' value='".$rs["subject"]."'>");
	HtmlEchoMsg("*产品售价：","<input type='text' name='price' class='short_input' value='".$rs["price"]."'> 元");
	$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 = "qgOpen('admin.php?file=open.product&act=viewpic&pic=".$rs["picture"]."','id','".$width."','".$height."')";
		$pic = "[<a href=\"#\" onclick=\"".$javascriptUrl."\">已存在图片，要更新请直接覆盖</a>] [<a href='admin.php?file=product&act=deletepic&id=".$id."'>点此删除图片</a>]";
	}
	HtmlEchoMsg("产品图片：","<input type='file' name='picture'> ".$pic);
	$rsContent = $DB->qgGetOne("SELECT * FROM ".$prefix."content WHERE id='".$id."'");
	$content = $rsContent["content"];
	HtmlEchoMsg("产品简介：","<textarea name='content' style='width:400px;height:80px;'>".$content."</textarea>");
	HtmlEchoMsg("",HtmlButton("编 辑").HtmlButton("返 回","admin.php?file=product&act=list"));
	HtmlEndForm();
}
elseif($act == "modifyok")
{
	if($_SESSION["admin"]["typer"] != "system" && $_SESSION["admin"]["typer"] != "manager")
	{
		Error("只有一般管理员或系统管理员才有此权限！","admin.php?file=index");
	}
	if(empty($id))
	{
		Error("操作非法","admin.php?file=product&act=list");
	}
	$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE id='".$id."'");
	$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=modify&id=".$id);
	}
	#[检测编号是否存在]
	$check_number = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE number='".$number."' AND id !='".$id."'");
	if($check_number)
	{
		Error("产品编号已经存在了！","admin.php?file=product&act=modify&id=".$id);
	}
	#[判断图片是否存在]
	if($picture)
	{
		if($rs["picture"])
		{
			$FS->qgDelete("./upfiles/".$rs["picture"]);
		}
	}
	else
	{
		$picture = $rs["picture"];
	}
	#[更新库信息]
	$DB->qgQuery("UPDATE ".$prefix."product SET cateid='".$cateid."',number='".$number."',pinming='".$pinming."',subject='".$subject."',price='".$price."',picture='".$picture."' WHERE id='".$id."'");
	#[判断是否有内容]
	if($content)
	{
		$chkContent = $DB->qgGetOne("SELECT * FROM ".$prefix."content WHERE id='".$id."'");
		if($chkContent)
		{
			$DB->qgQuery("UPDATE ".$prefix."content SET content='".$content."' WHERE id='".$id."'");
		}
		else
		{
			$DB->qgQuery("INSERT INTO ".$prefix."content(id,content) VALUES('".$id."','".$content."')");
		}
	}
	Error("产品信息更新成功！","admin.php?file=product&act=list&cateid=".$cateid);
}
elseif($act == "deletepic")
{
	if(empty($id))
	{
		Error("操作非法","admin.php?file=product&act=list");
	}
	$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE id='".$id."'");
	if($rs["picture"])
	{
		$DB->qgQuery("UPDATE ".$prefix."product SET picture='' WHERE id='".$id."'");
		$FS->qgDelete("./upfiles/".$rs["picture"]);
		Error("图片删除成功！");
	}
	Error("该产品没有图片！","admin.php?file=product&act=modify&id=".$id);
}
elseif($act == "delete")
{
	if($_SESSION["admin"]["typer"] != "system" && $_SESSION["admin"]["typer"] != "manager")
	{
		Error("只有一般管理员或系统管理员才有此权限！","admin.php?file=index");
	}
	if(empty($id))
	{
		Error("操作非法","admin.php?file=product&act=list");
	}
	$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE id='".$id."'");
	if($rs["picture"])
	{
		$FS->qgDelete("./upfiles/".$rs["picture"]);
	}
	$DB->qgQuery("DELETE FROM ".$prefix."product WHERE id='".$id."'");
	$DB->qgQuery("DELETE FROM ".$prefix."conent WHERE id='".$id."'");
	Error("产品成功删除！","admin.php?file=product&act=list");
}
elseif($act == "chknumber")
{
	if(empty($number))
	{
		echo "<script language=\"JavaScript1.2\">parent.retmsg('2');</script>";
		exit();
	}
	if($id)
	{
		$condition = " AND id!='".$id."'";
	}
	else
	{
		$condition = "";
	}
	$rs = $DB->qgGetOne("SELECT id FROM ".$prefix."product WHERE number='".$number."'".$condition." LIMIT 0,1");
	if($rs["id"])
	{
		echo "<script language=\"JavaScript1.2\">parent.retmsg('0');</script>";
		exit();
	}
	else
	{
		echo "<script language=\"JavaScript1.2\">parent.retmsg('1');</script>";
		exit();
	}
}
elseif($act == "layin")
{
	if($_SESSION["admin"]["typer"] != "system" && $_SESSION["admin"]["typer"] != "manager")
	{
		Error("只有一般管理员或系统管理员才有此权限！","admin.php?file=index");
	}
	#[获取编号]
	$id = intval($id);
	if($id)
	{
		$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE id='".$id."'");
		$number = $rs["number"];
	}
	else
	{
		$number = $number ? SafeHtml($number) : "";
	}
	HtmlEchoMsg("<b>添加新产品进货入库</b>");
	HtmlStartForm("admin.php?file=product&act=layinok");
	HtmlEchoMsg("*产品编号：","<input type='text' name='number' value='".$number."'> <img src='./admin/images/update.gif' align='absmiddle' style='cursor: pointer;cursor: hand;' onclick=\"qgOpen('admin.php?file=open.product&act=list&form=form&input=number','form','500','600')\"> <img src='./admin/images/cleanup.gif' border='0' align='absmiddle' title='清空编号' onclick=\"qinggan_cleanup('number')\" style='cursor: pointer;cursor: hand;'>");
	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($act == "layinok")
{
	if($_SESSION["admin"]["typer"] != "system" && $_SESSION["admin"]["typer"] != "manager")
	{
		Error("只有一般管理员或系统管理员才有此权限！","admin.php?file=index");
	}
	#[判断编号]
	$number = SafeHtml($number);
	if(empty($number))
	{
		Error("编号不能为空！","admin.php?file=product&act=layin");
	}
	$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE number='".$number."'");
	if(!$rs)
	{
		Error("不存在该编号！请检查！","admin.php?file=product&act=layin");
	}
	$id = $rs["id"];
	#[获取相关信息]
	#$rs = $DB->qgGetOne("SELECT * FROM ".$prefix."product WHERE id='".$id."'");
	$pcount = intval($pcount);
	$price = SafeHtml($price);
	settype($price,"float");
	$enterdate = SafeHtml($enterdate);
	$enterdate = strtotime($enterdate);
	#[入库]
	$DB->qgQuery("INSERT INTO ".$prefix."i(proid,subject,pinming,number,pcount,price,enterdate,adminer) VALUES('".$id."','".$rs["subject"]."','".$rs["pinming"]."','".$rs["number"]."','".$pcount."','".$price."','".$enterdate."','".$_SESSION["admin"]["user"]."')");
	#[统计产品库存]
	$DB->qgQuery("UPDATE ".$prefix."product SET procount=procount+".$pcount." WHERE id='".$id."'");
	Error("产品：".$rs["subject"]." 入库成功！","admin.php?file=product&act=list");
}
?>