<?php
	require_once('_approot.php');

	$functionName=$_GET['functionName'];
	$showfunctionName=  "新闻";
	//$showfunctionName= ($functionName=="新闻分类"?"内容":$functionName);
	$cateName=$_POST['cateName'];
	$oldcateName=$_POST['oldcateName'];
	$suffStr=$_POST['suffStr'];
	$hotLines=$_POST['hotLines'];
	$hotWords=$_POST['hotWords'];
	$suffStrold=$_POST['suffStrold'];
	
	$brief=$_POST['brief'];
	$Num=$_POST['Num'];
	$newsTitle=trim($_POST['newsTitle']);
	$newsKeywords=trim($_POST['newsKeywords']);
	$newsDescription=trim($_POST['newsDescription']);
	 
	$newsTitle=$newsTitle==""?($cateName==""?"":$cateName."_")." - ".$mycompanyName:$newsTitle;
	$newsKeywords=$newsKeywords==""?($cateName==""?"":$cateName.","):$newsKeywords;
	$newsDescription=$newsDescription==""?($brief==""?"":$brief.",").($cateName==""?"":",".$cateName):$newsDescription;
	

	
	if ($_GET['ls_msg']=="")
	{
		//$ls_msg=$showfunctionName."分类管理";
	}	
	else
	{
		$ls_msg=$_GET['ls_msg'];	
	}
		$ls=$_GET['ls'];
		$id=$_GET['id'];
	switch ($ls)
	{
		
	 	case "unenable":
			$unenable_sql="update ls_functioncates set enable=0 where id=".$id." ";
			//echo $unenable_sql;
			$unenable_query=$opendb->query($unenable_sql);
			$ls_msg="不显示成功！";
			break;
		case "enable":
			$enable_sql="update ls_functioncates set enable=1 where id=".$id." ";
			//echo $enable_sql;
			$enable_query=$opendb->query($enable_sql);
			$ls_msg="显示成功！";
			break;
		case "del":
			$in_sql="SELECT * from ls_functioncates where ID=".$id.""; //count the error by searchtype
			$in_query=$opendb->query($in_sql);
			$in_rows=mysqli_fetch_assoc($in_query);

			$del_sql="delete from ls_functioncates where ID=".$id."";
			
	   		//echo $del_sql;
	   		$del_query=$opendb->query($del_sql);
	   		$ls_msg="删除成功！";
			$tpl="../Templates1/news".$in_rows['suffStr'].".html";
			$tpl2="../Templates1/newsshow".$in_rows['suffStr'].".html";
			if(file_exists($tpl) ) 
				if(!unlink($tpl)) $ls_msg.=" 模板".$tpl."删除错误，";  
				else $ls_msg.=" 模板".$tpl."已删除，"; //删除模板
			else $ls_msg.=" 模板".$tpl."未删除，"; //删除模板
			
			if(file_exists($tpl2) ) 
				if(!unlink($tpl2)) $ls_msg.=" 模板".$tpl2."删除错误，";  
				else $ls_msg.=" 模板".$tpl2."已删除，"; //删除模板
			else $ls_msg.=" 模板".$tpl2."未删除，"; //删除模板
			break;
			
		case "insert":
			$select_sql2="select * from ls_functioncates  where cateName='".trim($cateName)."' and functionName='".$functionName."' ";
			$select_query2=$opendb->query($select_sql2);
			$select_rows2_num=mysqli_num_rows($select_query2); //总数
			if($select_rows2_num==0)
			{
				if(preg_match("/[\x7f-\xff]/", $cateName)    ){
					if( $functionName!="常见问题") $suffStr=Pinyin($cateName,1);
				}else{
					if( $functionName!="常见问题")  $suffStr=clearFolder($cateName);
				}
				if($functionName != "博客分类"){
					//$insert_sql="insert into ls_functioncates (cateName,brief,functionName,hotLines,hotWords,Num) values ('".$cateName."','".$brief."','".$functionName."','".$hotLines."','".$hotWords."','".$Num."') ";
					$insert_sql="insert into ls_functioncates (fTitle, fKeywords, fDescription, cateName,brief,functionName,suffStr,hotLines,hotWords,Num,date) values ('".$newsTitle."','".$newsKeywords."','".$newsDescription."','".$cateName."','".$brief."','".$functionName."','".$suffStr."','".$hotLines."','".$hotWords."','".$Num."','".date("Y-m-d H:i:s")."') "; // zhao 17-1-26 不是博客也加标识
				}else{
					$insert_sql="insert into ls_functioncates (fTitle, fKeywords, fDescription, cateName,brief,functionName,suffStr,hotLines,hotWords,Num,date) values ('".$newsTitle."','".$newsKeywords."','".$newsDescription."','".$cateName."','".$brief."','".$functionName."','".$suffStr."','".$hotLines."','".$hotWords."','".$Num."','".date("Y-m-d H:i:s")."') ";
					
				}
				$ls_msg="添加成功！";
				//echo $insert_sql;
				$insert_query=$opendb->query($insert_sql);
				$tpl="news".$suffStr.".html";
				$tpl2="newsshow".$suffStr.".html";
				if(!file_exists("../Templates1/".$tpl)) if(!copy("../Templates1/news.html","../Templates1/".$tpl)) $ls_msg.='复制".$tpl."模板错误！';  //复制模板
				if(!file_exists("../Templates1/".$tpl2)) if(!copy("../Templates1/newsshow.html","../Templates1/".$tpl2)) $ls_msg.='复制".$tpl2."模板错误！';  //复制模板

			}
			else
			{$ls_msg="分类已存在！";}
			break;
			
	case "modi":
			$modiid=$_POST['modiid'];
			$modi_sql="update ls_functioncates set fTitle='".$newsTitle."',fKeywords='".$newsKeywords."',fDescription='".$newsDescription."',cateName='".$cateName."', suffStr='".$suffStr."', Num='".$Num."',hotLines='".$hotLines."',hotWords='".$hotWords."',brief='".$brief."' where id=".$modiid." ";
					//echo $modi_sql;
			$modi_query=$opendb->query($modi_sql);

			//新闻表的分类
			$modi_sql="update ls_news  set cate ='".$cateName."'  where cate='".$oldcateName."' ";
			//	echo $modi_sql_article;
			$modi_query=$opendb->query($modi_sql);
			
			$tpl="news".$suffStr.".html";
			$tpl2="newsshow".$suffStr.".html";
			$oldtpl="news".$suffStrold.".html";
			$oldtp2="newsshow".$suffStrold.".html";
			if(!file_exists("../Templates1/".$tpl)) {
				if(file_exists($oldtpl)) 
					if(!rename($oldtpl,"../Templates1/".$tpl)) echo  $ls_msg.='复制".$tpl."模板错误，类别已更新。' ;  //复制模板
				else
					if(!copy("../Templates1/news.html","../Templates1/".$tpl)) $ls_msg.='复制".$tpl."模板错误，类别已更新。' ;  //复制模板	
			}
			
			if(!file_exists("../Templates1/".$tpl2)) {
				if(file_exists($oldtpl2)) 
					if(!rename($oldtpl2,"../Templates1/".$tpl)) echo  $ls_msg.='复制".$tpl2."模板错误，类别已更新。';  //复制模板
				else
					if(!copy("../Templates1/news.html","../Templates1/".$tpl2)) $ls_msg.='复制".$tpl2."模板错误，类别已更新。';  //复制模板	

			}

			break;
	}
?>

<!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">
                 <link rel="stylesheet" href="css/style2.css" />
		<script language="JavaScript" src="js/ls.js"></script>
		<title><?=$showfunctionName?>分类管理</title>
        <style> 
        input{
	width:80%;
}
        </style>
	</head>

 <body>
	<br />
	<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1">
		  <tr>
              <td height="18" style="border-bottom:2px solid #00c0ef; padding-bottom:5px;"><div align="center"><font color="#3c8dbc" style="font-size:16px;"><?=$showfunctionName?>
              分类管理</font></div>
				</td>
			</tr>
			<tr>
				<td height="336" align="left" valign="top"><br />
				  <?php
					// 获取当前页数
						if( isset($_GET['page']) ){
						   $page = intval( $_GET['page'] );
						}
						else{
						   $page = 1;
						}
						// 每页数量
						$PageSize = $artcatePageNum;
						
						// 获取总数据量
						/********************************************************************************/
						
							$sql = "select * from ls_functioncates where functionName='".$functionName."' order by Num desc";
							$result=$opendb->query($sql);
						
						/********************************************************************************/
						// 获取总数据量
						
						$row = mysqli_num_rows($result);
						$amount = $row;
						
						// 记算总共有多少页
						if( $amount ){
						   if( $amount < $PageSize ){ $page_count = 1; }			   //如果总数据量小于$PageSize，那么只有一页
						   if( $amount % $PageSize ){								  //取总数据量除以每页数的余数
							   $page_count = (int)($amount / $PageSize) + 1;		   //如果有余数，则页数等于总数据量除以每页数的结果取整再加一
						   	}else{
							   $page_count = $amount / $PageSize;					  //如果没有余数，则页数等于总数据量除以每页数的结果
						   }
						}
						else{
						   $page_count = 0;
						}
						
						// 翻页链接
						$page_string = '';
							
						if( $page == 1 ){
						   $page_string .= '首页 | 上一页 |';
						}
						else{
						   $page_string .= '<a href=?page=1><u><font color=\"#0000FF\">首页</font></u></a> | <a href=?functionName='.$functionName.'&page='.($page-1).'><u><font color=\"#0000FF\">上一页</font></u></a> | ';
						}
						if( ($page == $page_count) || ($page_count == 0) ){
						   $page_string .= ' 下一页 | 尾页';
						}
						else{
						   $page_string .= ' <a href=?functionName='.$functionName.'&page='.($page+1).'><u><font color=\"#0000FF\">下一页</font></u></a> | <a href=?functionName='.$functionName.'&page='.$page_count.'><u><font color=\"#0000FF\">尾页</font></u></a>';
						}
							 $page_string .= " &nbsp;&nbsp;页次：<font color='#FF0000'><b>".$page."</b></font>/<b>".$page_count."</b>页";
							 $page_string .= " &nbsp;&nbsp;<b>".$PageSize."</b>个每页";
							 
						$ls_msg2=$showfunctionName."分类管理";
					
					?>
					
				
<table border="0" width="98%" align="center">
						<tr>
							<td width="83%">提示： <?php echo $ls_msg." ".$ls_msg2; ?></td>
							<td width="17%" align="right">共 <b><?php echo $row; ?></b> 个</td>
						</tr>
				  </table>
					 <table width="98%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#f0f0ee">
						<tr bgcolor="#f0f0ee" height="37">
							<td align="center" height="25" width="27">编号</td>
							<td width="185"  align="center" ><?=$showfunctionName?></td>
							<td width="57"  align="center" >日期</td>
							<td width="299"  align="center" >Title, Description, 说明</td>
							<td width="128"  align="center" >标识</td>
							<td width="54"  align="center" >行数</td>
							<td width="54"  align="center" >形式</td>
						   <td align="center" width="54">排序</td>
							<td align="center" width="19">修改</td>
							<td align="center" width="50">删除</td>
							<td align="center" width="84">允许</td>
						</tr>
						<?php
						$functioncates_sql="select * from ls_functioncates where functionName='".$functionName."' order by  Num limit ". ($page-1)*$PageSize .",".$PageSize." ";	
						$functioncates_query=$opendb->query($functioncates_sql);
						
						$i=1;
						while($functioncates_rows=mysqli_fetch_assoc($functioncates_query))
						{ ?>
						 <tbody id='ZH_<?=$functioncates_rows['ID']?>' >	
						   <tr bgcolor='#f9f9f9' height='37'
							onMouseOver=
						 	this.style.backgroundColor='#e5e5e5' 
						onMouseOut=
						 	this.style.backgroundColor='#f9f9f9' 
						>
							<td align='center'>
								<!-- <input name='select_id<?=$i?>' type='checkbox' onclick="unselectall()" id="select_id" value='<?=$functioncates_rows['ID']?>'>  --> <?=$functioncates_rows['ID']?>
							</td>
							<td style='padding-left:10px;'>
						<?=$functioncates_rows['cateName']?>
							</td>
							<td style='padding-left:10px;'><?=substr( $functioncates_rows['date'],2,8)?></td>
							<td style='padding-left:10px;'>
						      <p>-<?= $functioncates_rows['fTitle'] ?>
                                <br/>
-<?= $functioncates_rows['fDescription'] ?>
                              </p>
						      <p>-<?=mb_substr(strip_tags($functioncates_rows['brief']),0,120, 'utf-8')?>
					         </p></td>
							<td style='padding-left:10px;'><?=$functioncates_rows['suffStr']?></td>
							<td style='padding-left:10px;'><?=$functioncates_rows['hotLines']?></td>
							<td style='padding-left:10px;'><?=$functioncates_rows['hotWords']?></td>
							<td style='padding-left:10px;'>
						<?=$functioncates_rows['Num']?>
							</td>
			<td align='center'>
				<a href='javascript:secBoard(<?=$functioncates_rows['ID']?>);' title='编辑'><img src='images/b_edit.png' border='0'></a>
		  </td>
							<td align='center'> 
                            <?php if($functioncates_rows['cateName']!="news"){?>
								<a href='?page=<?=$page?>&id=<?=$functioncates_rows['ID']?>&ls=del&functionName=<?=$functionName?>' onclick='return ConfirmDelSubCate();' title='删除'><img src='images/b_drop.png' border='0'></a>
                                <?php }?>
						  </td>
							<td align='center'>
						<?php 			  
						  if($functioncates_rows['enable']==1)
							{ ?>
								<a href='?page=<?=$page?>&id=<?=$functioncates_rows['ID']?>&ls=unenable&functionName=<?=$functionName?>' title='显示'><img src='images/enable.gif' border='0'></a>
							<?php }
						  if($functioncates_rows['enable']==0)
						  	{ ?>
								<a href='?page=<?=$page?>&id=<?=$functioncates_rows['ID']?>&ls=enable&functionName=<?=$functionName?>' title='不显示'><img src='images/unenable.gif' border='0'></a>
							<?php } ?>
						
							</td>
						</tr>
					   </tbody>
		
		<tbody id='Z_<?=$functioncates_rows['ID']?>' style='display:none;'>
		 <form name='fm_menu' action='?ls=modi&page=<?=$page?>&functionName=<?=$functionName?>' method='post'> 
			<tr>
			<td align='center'> 
			</td>
				<td colspan="3" style='padding-left:20px;'><p> 
				  <?=$showfunctionName?>：
				 <br />
				  <input type='text' value='<?=$functioncates_rows['cateName']?>' name='cateName' size='36'  style="width:488px" <?=$functioncates_rows['cateName']=="news"?"readonly":"" ?>>
			      <input type='hidden' value='<?=$functioncates_rows['cateName']?>' name='oldcateName' />
		      </p></td>
			  <!-- <td style='padding-left:5px;'><input type='text' value='<?=$functioncates_rows['suffStr']?>' name='suffStr' size='6' class='inp'   <?=($_SESSION['adlans']=="adlans"?"":"readonly")?>/></td> -->
          <td style='padding-left:5px;'><input type='text' value='<?=$functioncates_rows['suffStr']?>' name='suffStr' size='3' class='inp'   <?=($_SESSION['adlans']=="adlans"?"":"readonly")?> />
            <input type='hidden' value='<?=$functioncates_rows['suffStr']?>' name='suffStrold' /></td>
				<td style='padding-left:5px;'><input type='text' value='<?=$functioncates_rows['hotLines']?>' name='hotLines' size='3' class='inp'    /></td>
				<td style='padding-left:5px;'><input type='text' value='<?=$functioncates_rows['hotWords']?>' name='hotWords' size='6' class='inp'   /></td>
				<td style='padding-left:5px;'>
					<input type='text' value='<?=$functioncates_rows['Num']?>' name='Num' size='10' class='inp'>
</td>
								<td colspan='3' align='center'>
									<input value='<?=$functioncates_rows['ID']?>' name='modiid' type='hidden'>
									<button type="submit" name="button" id="button"  value='确定'>确定   </button>
									<button  name="button" id="button"   onclick='javascript:secBoard2(<?=$functioncates_rows['ID']?>)' value='放弃'> 放弃</button>
						 		</td>
			</tr>
			<tr>
			  <td align='center'></td>
			  <td colspan="3" style='padding-left:20px;'>说明：<br />
	          <textarea name="brief" cols="78" rows="14" class="" onblur="addcate.newsDescription.value=(addcate.newsDescription.value.length==0) ? this.value : addcate.newsDescription.value"><?=$functioncates_rows['brief']?></textarea></td>
			  <td colspan="7" style='padding-left:5px;'><table border="0" width="100%">
			    <tr>
			      <td width="25%">标题 Title</td>
			      <td width="75%"><input name="newsTitle" id="newsTitle" type="text" value="<?php echo $functioncates_rows['fTitle'];?>" size="30" /></td>
		        </tr>
			    <tr>
			      <td>关键字 Keywords</td>
			      <td><input name="newsKeywords" id="newsKeywords" type="text" value="<?php echo $functioncates_rows['fKeywords'];?>" size="45" /></td>
		        </tr>
			    <tr>
			      <td>描述 Description</td>
			      <td><textarea name="newsDescription" cols="53" rows="8" id="newsDescription" onblur="addcate.brief.value=(addcate.brief.value.length==0) ? this.value : addcate.brief.value"><?php echo $functioncates_rows['fDescription'];?></textarea></td>
		        </tr>
			    <tr>
			      <td align="center"><button type='button' onclick='document.getElementById(&quot;newsTitle&quot;).value=&quot;<?php echo " - ".$companyName;?>&quot; ;document.getElementById(&quot;newsDescription&quot;).value=&quot;<?php echo $functioncates_rows['brief'];?>&quot;;document.getElementById(&quot;newsKeywords&quot;).value=&quot;<?php echo $functioncates_rows['functionName'];?>&quot;;' value='SEO' />SEO</button></td>
			      <td align="center">&nbsp;</td>
		        </tr>
		      </table></td>
		   </tr>

		 </form>
		</tbody>
				<?php                 $i++;
                 }?>
                <tr bgcolor="#f0f0ee"  height="37">
                <td height='62' colspan="11" align='left'>
                  <p><span style="padding-left:360px">  <?=$page_string?> 
                  </span></p></td>
                </tr>
            </table>
            <br />
            <form name="addcate" method="post" action="?ls=insert&functionName=<?=$functionName?>"  onSubmit="return checkSubmitForm('Num,cateName','序号,新闻分类');">
				   
			  <table border="0" width="98%" align="center">
					<tr>
					  <td width="32%" >提示：<font color="#FF0000"><?php echo $showfunctionName."添加"; ?></font></td>
					  <td colspan="6" align="right"  >&nbsp;</td>
					</tr>
			  </table>
                  <table border="0" width="98%" align="center" bgcolor="#f0f0ee">
					<tr bgcolor="#f0f0ee" height="47" align="" >
					  <td style="padding-left:8px">分类</td>
					  <td align="" style="padding-left:25px"><input name="cateName" type="text" id="cateName" size="64"  onKeyUp="addcate.newsTitle.value=addcate.newsKeywords.value=this.value;addcate.suffStr.value='_'+this.value"/></td>
					  <td width="10%" align="" style="padding-left:4px;" >标识：                    
				      <input name="suffStr" type="text" id="suffStr" value="_" size="4" class='inp'/></td>
					  <td width="11%" align=""  ><span style="padding-left:4px;">行数:
                          <input type='text' value='6' name='hotLines' size='2' class='inp' />
                      </span></td>
					  <td width="11%" align="center"  ><span style="padding-left:4px;">形式:
                            <input type='text' value='1' name='hotWords' size='2' class='inp' />
					  </span></td>
					  <td width="12%" align="center"  >序号:
                        <?php                         	$select_sql2="select * from ls_functioncates    ";
							//echo $select_sql2;
							$select_query2=$opendb->query($select_sql2);
							$select_rows2_num=mysqli_num_rows($select_query2); //总数
						?>
                        <input name="Num" id="Num"  type="text" style="width:40px;" value="<?=($select_rows2_num+1)*5?>" size="6" maxlength="6" /></td>
					  <td width="14%" align=""  style="padding-left:28px" ><button type="submit" name="button" id="button" value="添加" />添加</button></td>
					</tr>
					<tr bgcolor="#f0f0ee" height="47" align="center">
					  <td width="4%" height="180" style="padding-left:8px"><div align="left" style="text-align:;">简介</div></td>
					  <td width="38%" align="" style="padding-left:25px" ><span style="text-align:;">
					    <textarea name="brief" cols="70" rows="9" id="brief" onblur="addcate.newsDescription.value=(addcate.newsDescription.value.length==0) ? this.value : addcate.newsDescription.value"></textarea>
					  </span></td>
					  <td colspan="5" align="center"  ><table border="0" width="100%">
					    <tr>
					      <td width="25%" style="padding-left:25px;">标题 Title</td>
					      <td width="75%" style="padding-left:25px;"><input name="newsTitle" id="newsTitle2" type="text"   style="width:80%;" value=""/></td>
				        </tr>
					    <tr>
					      <td style="padding-left:25px;">关键字 Keywords</td>
					      <td style="padding-left:25px;"><input name="newsKeywords" id="newsKeywords" type="text" value="" style="width:80%;" /></td>
				        </tr>
					    <tr>
					      <td style="padding-left:25px;">描述 Description</td>
					      <td style="padding-left:25px;"><textarea name="newsDescription" rows="5" id="newsDescription2" style="width:80%;" onblur="addcate.brief.value=(addcate.brief.value.length==0) ? this.value : addcate.brief.value"></textarea></td>
				        </tr>
				      </table></td>
				    </tr>
				  </table>
				  </form>
				  <p> &nbsp; &nbsp;分类标识自动建立，列表标签用 {ls_news标识}，模板默认是 news标识.html。<br />
				    &nbsp; &nbsp;形式，列表显示方式：默认是1标题列表， 2 图片标题简介，3   图片标题竖排。<br />
		      </p></td>
        </tr>
	</table>
 </body>
</html>