<?php
    session_start(); 
	require_once('inc/conn.php');
	require_once('inc/constant.php');
	require_once('inc/ls_syscode.php');
	require_once('inc/check.php');
	$opendb=new mydb();
	require_once('inc/char_set.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="css/admin.css" rel="stylesheet" type="text/css">
<title>无标题文档</title>
</head>
<body>
<?PHP
			
	$ls=$_POST['ls'];
	$id=$_POST['id'];

	$ChangecatePagePic=$_POST['ChangecatePagePic'];
	$ChangecateIconPic=$_POST['ChangecateIconPic'];
	//$cateName=replaceCatesName($_POST['cateName']);
	$cateName=$_POST['cateName'];
	$cateName=str_replace("'","`",$cateName);
	
	$cateFolders_str = $_POST['cateFolders'];
	if(preg_match("/[\x7f-\xff]/", $cateFolders_str)){
		$cateFolders = Pinyin($cateFolders_str,1);
	}else{
		$cateFolders = $cateFolders_str;
	}
	if($cateFolders=="")		//如果没有设目录则截取
	{$cateFolders=$cateName;}
	$cateFolders=trim(clearFolder(strtolower(substr_cut($cateFolders,$FolderLength))));

	$cateTitle=$_POST['cateTitle'];
	$cateKeywords=$_POST['cateKeywords'];
	$cateDescription=$_POST['cateDescription'];
	//$catePagePic = $_POST['catePagePic'];
	$catePagePicWidth=$_POST['width'];
	$catePagePicHeight=$_POST['height'];
	
	$cateBrief=str_replace("\n","<br />",htmlspecialchars($_POST['cateBrief'], ENT_QUOTES));
	$cateDetail=$_POST['cateDetail'];

	$image=$_FILES['catePagePic']['name'];   
 	$size=$_FILES['catePagePic']['size'];   
 	$type=$_FILES['catePagePic']['type'];
	
	$imageicon=$_FILES['cateIconPic']['name'];   

	
	//echo "图像名称：".$image."<br>";
	//echo "图像大小：".$size."<br>";
	//echo "图像类型：".$type."<br>";
	
	switch ($ls)
	{
		case "insert":  ///添加大类 Start
		   
		//开始判断图像类型
		// 开始判断是否有重复的
		$cateName = str_replace("'","''",$cateName);
		$select_sql="select * from ls_products where cateName='".$cateName."' ";
		$select_query=$opendb->query($select_sql);
		$select_rows=mysql_num_rows($select_query);
		if ($select_rows == 0)
		{
	
			
																			
			$path = "../".$cateFolders;
			//调用建立文件夹函数 createFolder
			createFolder($path);
															
			$arr=array(" ",".");   
			//产生文件名   
			$catePagePic=str_replace($arr ,"",$cateFolders."_banner").".".substr($image,-3);
			$BannerPath =$path ."/".$catePagePic;
			//echo $BannerPath;
			//上传文件
			if($_FILES['catePagePic']['tmp_name']!="")
			{
				if ($type == "image/gif" || $type == "image/png" || $type == "image/pjpeg" )
				{
					if($size < $PicSize) //开始判断图像大小
					{
						move_uploaded_file($_FILES['catePagePic']['tmp_name'], $BannerPath);

						//cateIconpic
					}
					else
					{
						echo "	<script>alert('图像最大为".$PicSize."！');history.go(-1);</script>";
					}
				}
				else
				{
					 echo "	<script>alert('请选择图片上传，或者你选择的文件不符合要求!\\n只允许格式 .gif .png .jpeg');history.go(-1);</script>";
				}
			}
			$cateIconPic=str_replace($arr ,"",$cateFolders."_icon").".".substr($imageicon,-3);
			$IconPath =$path ."/".$cateIconPic;
			if($_FILES['cateIconPic']['tmp_name']!="")// 上传了Iconpic
			{
				move_uploaded_file($_FILES['cateIconPic']['tmp_name'], $IconPath);
				list($iconwidth, $iconheight, $icontype, $iconattr)  = getimagesize($IconPath);//获取文件类型

				$toW=$cateIconPicW;			//宽度
				$toH=$cateIconPicH;			//高度
				$toFile=$IconPath;		//目标地址
				$srcFile=$IconPath;	//目标地址
				ImageResize($srcFile,$toW,$toH,$toFile);	//resize the big pic width & height to stand size
			}
			$select_sql2="select * from ls_products where cateName<>'' ";
			$select_query2=$opendb->query($select_sql2);
			$select_rows2=mysql_num_rows($select_query2); //总类数

			$insert_sql=sprintf("insert into ls_products 												(cateName,cateFolders,cateTitle,cateKeywords,cateDescription,catePagePic,catePagePicWidth,catePagePicHeight,cateIconPic,cateBrief,cateDetail,Num,enable) values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s) ",
						GetSQLValueString($cateName, "text"),
						GetSQLValueString($cateFolders, "text"),
						GetSQLValueString($cateTitle, "text"),
						GetSQLValueString($cateKeywords, "text"),
						GetSQLValueString($cateDescription, "text"),
						GetSQLValueString($catePagePic, "text"),
						GetSQLValueString($catePagePicWidth, "text"),
						GetSQLValueString($catePagePicHeight, "text"),
						GetSQLValueString($cateIconPic, "text"),
						GetSQLValueString($cateBrief, "text"),
						GetSQLValueString($cateDetail, "text"),
						GetSQLValueString($select_rows2+1, "int"),
						GetSQLValueString("1", "int")
			);
															//echo $insert_sql;
			$insert_query=$opendb->query($insert_sql);
			echo "<script>alert('数据添加成功！');location='cate.php';</script>";
										
		}
		else
		{
			echo "<script>alert('已存在此大类名！\\n请填写别的大类名！');history.go(-1);</script>";	
		}
										
		writelog($_SERVER['PHP_SELF'],"add category: ".$cateName,"ID: ".$id);

		 break;	 ///添加大类 End
	  case "modi":   ///修改大类 Start
	   	
	  		$select_sql="select * from ls_products where ID=".$id." ";
			$select_query=$opendb->query($select_sql);
			$select_rows=mysql_fetch_assoc($select_query);
	  						
			//获取文件路径
			$pathNew = "../".$cateFolders;
			$pathOld = "../".$select_rows['cateFolders'];
	  		//echo $pathNew."<br>".$pathOld."<br>";
	  		//文件夹换名
	  		if($pathNew!=$pathOld)
			{
  			  rename($pathOld,$pathNew);
	
	  		}
	  		if($ChangecatePagePic=="yes")
	  		{
	  				 		//判断图像格式
	  			if ($type == "image/gif" || $type == "image/png" || $type == "image/pjpeg" )
				{
					if($size < $PicSize) //开始判断图像大小
					{
					  	$arr=array(" ",".");   
											  	//产生文件名   
						$catePagePic=str_replace($arr ,"",$select_rows['cateFolders']."_banner").".".substr($image,-3);
													
						$BannerPath =$pathNew ."/".$catePagePic;
						$delBannerFile=$pathNew ."/".$select_rows['catePagePic'];
						@unlink($delBannerFile) ; //del the old pic
						move_uploaded_file($_FILES['catePagePic']['tmp_name'], $BannerPath);
						$update_sql=sprintf("update ls_products set catePagePic=%s where ID=%s",
						GetSQLValueString($catePagePic, "text"),
						GetSQLValueString($id, "int"));
						$update_query=$opendb->query($update_sql);
					}
					else
					{
						echo "	<script>alert('图像最大为".$PicSize."！');history.go(-1);</script>";
					}
				}
				else
				{
					echo "	<script>alert('请选择图片上传，或者你选择的文件不符合要求!\\n只允许格式 .gif .png .jpeg');history.go(-1);</script>";
				}
	  		}
	  		$update_sql=sprintf("update ls_products set cateName=%s, cateFolders=%s,cateTitle=%s, cateKeywords=%s, cateDescription=%s, catePagePicWidth=%s, catePagePicHeight=%s, cateBrief=%s,cateDetail=%s where ID=%s",
			GetSQLValueString($cateName, "text"),
			GetSQLValueString($cateFolders, "text"),
			GetSQLValueString($cateTitle, "text"),
			GetSQLValueString($cateKeywords, "text"),
			GetSQLValueString($cateDescription, "text"),
			GetSQLValueString($catePagePicWidth, "text"),
			GetSQLValueString($catePagePicHeight, "text"),
			GetSQLValueString($cateBrief, "text"),
			GetSQLValueString($cateDetail, "text"),
			GetSQLValueString($id, "int")
			);
			//echo $update_sql;
			$update_query=$opendb->query($update_sql);
			
			if($ChangecateIconPic=="yes")
	  		{
				
				$cateIconPic=str_replace($arr ,"",$cateFolders."_icon").".".substr($imageicon,-3);
				$IconPath =$pathNew ."/".$cateIconPic;
				//echo $IconPath;
				$delIconFile=$pathNew ."/".$select_rows['cateIconPic'];
				@unlink($delIconFile) ; //del the old pic
				move_uploaded_file($_FILES['cateIconPic']['tmp_name'], $IconPath);
				list($iconwidth, $iconheight, $icontype, $iconattr)  = getimagesize($IconPath);//获取文件类型
				$toW=$cateIconPicW;			//宽度
				$toH=$cateIconPicH;			//高度
				$toFile=$IconPath;			//目标地址
				$srcFile=$IconPath;			//目标地址
				ImageResize($srcFile,$toW,$toH,$toFile);	//resize the big pic width & height to stand size
				$update_sql=sprintf("update ls_products set cateIconPic=%s where ID=%s",
			GetSQLValueString($cateIconPic, "text"),
			GetSQLValueString($id, "int")
			);
			$update_query=$opendb->query($update_sql);
				
	  		}
	  				 	//开始更新数据
			writelog($_SERVER['PHP_SELF'],"modify category: ".$cateName,"ID: ".$id);

			echo "<script>alert('数据更新成功！');location='cate.php';</script>";
			
	   
	   break;  ///修改大类 End
	  
	  }
	 
	  ///删除大类  Start
	 if ($_GET['ls']=="del")
	 {
	 		$id=$_GET['id'];
	   		
	   		$select_sql="select * from ls_products where ID=".$id." ";
			$select_query=$opendb->query($select_sql);
			$select_rows=mysql_fetch_assoc($select_query);
	   		
	   		//echo $select_rows['cateFolders']."<br>".$select_rows['catePagePic']."<br>";
	   		//获得图片路径
	   		$pathFoldersPic="../".$select_rows['cateFolders']."/".$select_rows['catePagePic'];
	   		//获得文件路径
	   		$pathFolders="../".$select_rows['cateFolders'];
	   		//echo $pathFolders.$pathFoldersPic."<br>";
	   		
	   		$pathFoldersIcon="../".$select_rows['cateFolders']."/".$select_rows['cateIconPic'];
	   		//删除图片
	   		@unlink($pathFoldersPic);
	   		//删除Icon
	   		@unlink($pathFoldersIcon);
	   		//删除文件夹
			 @unlink($pathFolders."/indexdetails.html");
			@unlink($pathFolders."/index.html");
	   		@rmdir($pathFolders);

	   		$del_sql="delete from ls_products where ID=".$id."";
	   		//echo $del_sql;
	   		$del_query=$opendb->query($del_sql);
			$num_sql2="update ls_products set Num=Num-1 where Num>".$select_rows['Num']." ";//all order number-1
			$down_query=$opendb->query($num_sql2);
			writelog($_SERVER['PHP_SELF'],"delete category: ".$cateName,"ID: ".$id);

	   		echo "<script>alert('数据删除成功！');location='cate.php';</script>";
	 }
	 ///删除大类  End
?>
</body>
</html>
