www.gusucode.com > 搜一次CMS电影程序 PHP 1.5源码程序 > admin/admin_articleclass.php
<?php /* '************************************************************************************************** ' 软件名称: 搜一次 Content Management System ' 版本编号: Version 5.X ' 官方网站: http://www.syccms.com ' 官方论坛:http://bbs.syccms.com ' 版权所有: 搜一次开发团队 无痕(QQ:512591) ' 法律顾问: 杭州市元茂律师事务所 严飞律师 ' 郑重声明: ' 1、任何个人或组织不得在未经授权的情况下删除、修改、拷贝本软件及其他副本上一切关于版权的信息; ' 2、搜一次网络事业部保留此软件的法律追究权利 '************************************************************************************************** */ include "../include/conn.php"; include "../include/function.php"; include "admin_version.php"; include "admin_loginstate.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=gb2312" /> <link href="images/style.css" rel="stylesheet" type="text/css" /> <title>文章分类</title> <script type="text/javascript" language="javascript">var tentpath='<?php echo S_SitePath?>';</script> <script src="js/jquery.js"></script> <script language="javascript" src="js/alerts.js"></script> <link type="text/css" href="images/alerts.css" rel="stylesheet" media="screen"> <script language="javascript"> $(document).ready(function(){ $("#ChkAll").click(function(){ if($(this).attr("checked")==true){ $("input[id='S_ID']").each(function(){ $(this).attr("checked",true); }) }else{ $("input[id='S_ID']").each(function(){ $(this).attr("checked",false); }) } }) $("#addvc").click(function(){ var S_Name=$("#S_Name").val(); var S_TheOrder=$("#S_TheOrder").val(); var S_AliasName=$("#S_AliasName").val(); var S_Template=$("#S_Template").val(); var re = /^[a-z0-9]*$/gi $("#S_Name").css("border-color","#666 #ccc #ccc #666"); $("#S_TheOrder").css("border-color","#666 #ccc #ccc #666"); $("#S_AliasName").css("border-color","#666 #ccc #ccc #666"); $("#S_Template").css("border-color","#666 #ccc #ccc #666"); $("#tishi").text(""); if (S_Name==""){ $("#S_Name").css("border","1px solid red"); return false;} else if(S_Name.length > 50){ $("#S_Name").css("border","1px solid red"); $("#tishi").text("分类名称不能超过50个字符!").css("color","red"); return false;} else if(S_AliasName==""){ $("#S_AliasName").css("border","1px solid red"); return false;} else if(S_AliasName.length > 50){ $("#S_AliasName").css("border","1px solid red"); $("#tishi").text("别名不能超过50个字符!").css("color","red"); return false;} else if(S_TheOrder==""){ $("#S_TheOrder").css("border","1px solid red"); return false;} else if(S_TheOrder.length > 10){ $("#tishi").text("排序不能超过10个字符!").css("color","red"); return false;} else if(S_Template.length > 30){ $("#S_Template").css("border","1px solid red"); $("#tishi").text("模板不能超过30个字符!").css("color","red"); return false;} else if(re.test(S_AliasName)==false){ $("#S_AliasName").css("border","1px solid red"); $("#tishi").text("英文别名必须是数字或字母组成!").css("color","red"); return false;} }) $("#btn_editall").click(function(){ jConfirm('你确定要修改选中的数据吗?', '操作提示', function(r) { if(r==true){ formclass.action='?action=editall'; formclass.submit(); } }); }) $("#btn_delall").click(function(){ jConfirm('您确定要删除选中的分类吗?', '操作提示', function(r) { if(r==true){ formclass.action='?action=delall'; formclass.submit(); } }); }) }) function del(id){ jConfirm('你确定删除这个分类吗?', '操作提示', function(r) { if(r==true){ window.location='?action=del&S_ID='+id; } }); } function delbind(){ jConfirm('确定取消去资源库绑定的分类吗?', '操作提示', function(r) { if(r==true){ window.location='?action=delbind'; } }); } function changehide(id,hi){ window.location.href='?action=exhide&S_ID='+id+'&S_IsHide='+hi+''; } function SetClass(S_ID,S_FatherID){ $("#ClassShow"+S_ID).css("display",""); $("#Count"+S_ID).css("display","none") } function CloseSetClass(S_ID,S_FatherID){ $("#ClassShow"+S_ID).css("display","none"); $("#Count"+S_ID).css("display","") } function SelectPid(p,i){ if(p!=i){ window.location.href = '?action=savefahterid&S_ID='+i+'&S_FatherID='+p; } } </script> </head> <body> <?php class ui_class{ public function main(){ global $db; $sql="select * from s_class where S_SystemID=2 and S_FatherID=0"; $result=$db->query($sql); $classnum=$db->num_rows($result); ?> <div class="r_main"> <div class="r_content"> <div class="r_content_1"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="tb_style"> <form method="post" name="formclass" action=""> <tr> <td colspan="7" class="td_title" align="left"> 文章分类管理<a href="#" onclick="delbind()"><font color="red">【清空所有绑定的分类】</font></a></td> </tr> <tr> <td width="5%" height="30" bgcolor="#FFFFFF" class="td_border"> 编号</td> <td width="41%" bgcolor="#FFFFFF" class="td_border"> 中文名称</td> <td width="15%" align="center" bgcolor="#FFFFFF" class="td_border">英文别名</td> <td width="15%" align="center" bgcolor="#FFFFFF" class="td_border">频道模板</td> <td width="8%" align="center" bgcolor="#FFFFFF" class="td_border">排序</td> <td width="8%" align="center" bgcolor="#FFFFFF" class="td_border">显示</td> <td width="8%" align="center" bgcolor="#FFFFFF" class="td_border">操作</td> </tr> <?php if($classnum==1) echo " <tr> <td colspan=\"8\" class=\"td_border\" height=\"30\" align=center><b>暂无文章分类,请添加!</b></td> </tr>"; if($result){ while($row=$db->fetch_array($result)){ ?> <tr> <td width="5%" height="30" bgcolor="#FFFFFF" class="td_border"> <input type="checkbox" name="S_ID[]" id="S_ID" value="<?php echo $row['S_ID']?>" class="checkbox"/><?php echo $row['S_ID']?>、</td> <td width="41%" bgcolor="#FFFFFF" class="td_border"><div style="float:left;"> <?php if($row['S_FatherID']==0){echo " ╄ ";}else{echo " ├ ";}?><input type="text" value="<?php echo $row['S_Name']?>" size="10" name="S_Name<?php echo $row['S_ID']?>"> <input type="button" name="SetPart" value="设置上级" class="rb1" onClick="SetClass(<?php echo $row['S_ID']?>,<?php echo $row['S_FatherID']?>)"/></div> <div id="Count<?php echo $row['S_ID']?>" style="float:left; height:25px; line-height:25px; color:red;"> <a href="admin_article.php?action=listbycs&S_ID=<?php echo $row['S_ID']?>">(共<?php $sqlstr="select * from s_article where S_ClassID=".$row['S_ID'].""; $res=$db -> query($sqlstr); $nums= $db -> num_rows($res); echo $nums; ?>条)</a></div> <div id="ClassShow<?php echo $row['S_ID']?>" style=" float:left;display:none; height:25px; margin-top:5px;"> <select id="classsel_<?php echo $row['S_ID']?>" name="classsel_<?php echo $row['S_ID']?>" onChange="SelectPid(this.value,<?php echo $row['S_ID']?>);"> <option value="0">顶级分类</option> <?php $sqlstr2="select * from s_class where S_SystemID=2 and S_FatherID=0"; $re=$db->query($sqlstr2); if($re){ while ($row2=$db->fetch_array($re)){ ?> <option value="<?php echo $row2['S_ID']?>" <?php if($row2['S_ID']==$row['S_ID']){echo "selected";}?>><?php echo $row2['S_Name']?></option> <?php } } ?> </select> <a onclick="CloseSetClass(<?php echo $row['S_ID']?>,<?php echo $row['S_FatherID']?>)"><img src="images/starno.gif" /></a></div> </td> <td width="15%" align="center" bgcolor="#FFFFFF" class="td_border"> <input type="text" value="<?php echo $row['S_AliasName']?>" name="S_AliasName<?php echo $row['S_ID']?>" size="12"></td> <td width="15%" align="center" bgcolor="#FFFFFF" class="td_border"> <input type="text" value="<?php echo $row['S_Template']?>" name="S_Template<?php echo $row['S_ID']?>" size="15"></td> <td width="8%" align="center" bgcolor="#FFFFFF" class="td_border"> <input type="text" value="<?php echo $row['S_TheOrder']?>" name="S_TheOrder<?php echo $row['S_ID']?>" size="4"></td> <td width="8%" align="center" bgcolor="#FFFFFF" class="td_border"> <select name="S_IsHide<?php echo $row['S_ID']?>" onchange="changehide(<?php echo $row['S_ID']?>,this.value)"> <option value="0" <?php if($row['S_IsHide']==0){echo "selected";}?>>显示</option> <option value="1" <?php if($row['S_IsHide']==1){echo "selected";}?>>隐藏</option> </select></td> <td width="8%" align="center" bgcolor="#FFFFFF" class="td_border"> <input type="button" value="删除" onclick="del(<?php echo $row['S_ID']?>)"class="rb1"></td> </tr> <?php //处理此分类下的子分类 $sql2="select * from s_class where S_FatherID=".$row['S_ID'].""; $class2=$db->query($sql2); if($class2){ while($rowclass2=$db->fetch_array($class2)){ ?> <tr> <td width="5%" height="30" bgcolor="#FFFFFF" class="td_border"> <input type="checkbox" name="S_ID[]" id="S_ID" value="<?php echo $rowclass2['S_ID']?>" class="checkbox"/><?php echo $rowclass2['S_ID']?>、</td> <td width="41%" bgcolor="#FFFFFF" class="td_border"><div style="float:left;"> <?php if($rowclass2['S_FatherID']==0){echo " ╄ ";}else{echo " ├ ";}?><input type="text" value="<?php echo $rowclass2['S_Name']?>" size="10" name="S_Name<?php echo $rowclass2['S_ID']?>"> <input type="button" name="SetPart" value="设置上级" class="rb1" onClick="SetClass(<?php echo $rowclass2['S_ID']?>,<?php echo $rowclass2['S_FatherID']?>)"/></div> <div id="Count<?php echo $rowclass2['S_ID']?>" style="float:left; height:25px; line-height:25px; color:red;"> <a href="admin_article.php?action=listbycs&S_ID=<?php echo $rowclass2['S_ID']?>">(共<?php $sqlstr="select * from s_video where S_ClassID=".$rowclass2['S_ID'].""; $res=$db -> query($sqlstr); $nums= $db -> num_rows($res); echo $nums; ?>条)</a></div> <div id="ClassShow<?php echo $rowclass2['S_ID']?>" style=" float:left;display:none; height:25px; margin-top:5px;"> <select id="classsel_<?php echo $rowclass2['S_ID']?>" name="classsel_<?php echo $rowclass2['S_ID']?>" onChange="SelectPid(this.value,<?php echo $rowclass2['S_ID']?>);"> <option value="0">顶级分类</option> <?php $sqlstr2="select * from s_class where S_SystemID=2 and S_FatherID=0"; $re=$db->query($sqlstr2); if($re){ while ($row2=$db->fetch_array($re)){ ?> <option value="<?php echo $row2['S_ID']?>" <?php if($row2['S_ID']==$row['S_ID']){echo "selected";}?>><?php echo $row2['S_Name']?></option> <?php } } ?> </select> [<a onclick="CloseSetClass(<?php echo $row['S_ID']?>,<?php echo $row['S_FatherID']?>)">关闭</a>]</div> </td> <td width="15%" align="center" bgcolor="#FFFFFF" class="td_border"> <input type="text" value="<?php echo $rowclass2['S_AliasName']?>" name="S_AliasName<?php echo $rowclass2['S_ID']?>" size="12"></td> <td width="15%" align="center" bgcolor="#FFFFFF" class="td_border"> <input type="text" value="<?php echo $rowclass2['S_Template']?>" name="S_Template<?php echo $rowclass2['S_ID']?>" size="15"></td> <td width="8%" align="center" bgcolor="#FFFFFF" class="td_border"> <input type="text" value="<?php echo $rowclass2['S_TheOrder']?>" name="S_TheOrder<?php echo $rowclass2['S_ID']?>" size="4"></td> <td width="8%" align="center" bgcolor="#FFFFFF" class="td_border"> <select name="S_IsHide<?php echo $rowclass2['S_ID']?>" onchange="changehide(<?php echo $rowclass2['S_ID']?>,this.value)"> <option value="0" <?php if($rowclass2['S_IsHide']==0){echo "selected";}?>>显示</option> <option value="1" <?php if($rowclass2['S_IsHide']==1){echo "selected";}?>>隐藏</option> </select></td> <td width="8%" align="center" bgcolor="#FFFFFF" class="td_border"> <input type="button" value="删除" onclick="del(<?php echo $rowclass2['S_ID']?>)"class="rb1"></td> </tr> <?php } } } } ?> <tr> <td height="30" colspan="7" align="left" bgcolor="#FFFFFF" class="td_border"> <input type="checkbox" name="ChkAll" id="ChkAll" ids="S_ID" class="checkbox"/>全选 <input type="button" name="editall" value="修改所选分类" class="rb1" id="btn_editall"/> <input type="button" name="delall" value="删除所选分类" class="rb1" id="btn_delall"/></td> </tr> </form> </table> <form id="form1" name="form1" method="post" action="?action=saveadd"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="tb_style"> <tr> <td colspan="7" class="td_title"> 文章分类添加 <label id="tishi"></label></td> </tr> <tr> <td height="30" align="center" bgcolor="#FFFFFF" class="td_border">中文名称</td> <td align="center" bgcolor="#FFFFFF" class="td_border" >英文别名</td> <td align="center" bgcolor="#FFFFFF"class="td_border">所属上级</td> <td align="center" bgcolor="#FFFFFF" class="td_border">频道模板</td> <td align="center" bgcolor="#FFFFFF" class="td_border">排序</td> <td align="center" bgcolor="#FFFFFF" class="td_border">隐藏</td> <td align="center" bgcolor="#FFFFFF" class="td_border"> </td> </tr> <tr> <td height="30" align="center" bgcolor="#FFFFFF" class="td_border"> <input type="text" name="S_Name" id="S_Name" value="" /> </td> <td height="30" align="center" bgcolor="#FFFFFF" class="td_border"> <input type="text" name="S_AliasName" id="S_AliasName" value="" size="15" /> </td> <td height="30" align="center" bgcolor="#FFFFFF" class="td_border"> <select name="S_FatherID" id="S_FatherID"> <option value="0">作为顶级</option> <?php $sqlclass="select * from s_class where S_SystemID=2 and S_FatherID=0"; $results=$db->query($sqlclass); if($results){ while ($row3=$db->fetch_array($results)){ ?> <option value="<?php echo $row3['S_ID']?>" ><?php echo $row3['S_Name']?></option> <?php } } ?> </select> </td> <td height="30" align="center" bgcolor="#FFFFFF" class="td_border"> <input name="S_Template" type="text" id="S_Template" value="vodlist.html" /> </td> <td height="30" align="center" bgcolor="#FFFFFF" class="td_border"><input type="text" name="S_TheOrder" id="S_TheOrder" value="0" size="5" onkeyup="this.value=this.value.replace(/[^\d]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d]/g,''))"/></td> <td height="30" align="center" bgcolor="#FFFFFF" class="td_border"> <select name="S_IsHide"> <option value="0" >显 示</option> <option value="1">隐 藏</option> </select></td> <td align="center" class="td_border"><input type="submit" name="button" id="addvc" value="提 交" class="rb1" /></td> </tr> </table> </form> <form action="?action=movevideo" name="movevideo" id="movevideo" method="post"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="tb_style"> <tr> <td class="td_title"> 转移分类数据</td> </tr> <tr> <td height="30" bgcolor="#FFFFFF" class="td_border"> 将分类: <select size="1" name="Type_1"> <option value="">选择分类</option> <?php $sqlclass="select * from s_class where S_SystemID=2"; $results=$db->query($sqlclass); if($results){ while ($row3=$db->fetch_array($results)){ ?> <option value="<?php echo $row3['S_ID']?>" ><?php echo $row3['S_Name']?></option> <?php } } ?> </select> 的数据转移到 <select size="1" name="Type_2"> <option value="">选择分类</option> <?php $sqlclass="select * from s_class where S_SystemID=2 "; $results=$db->query($sqlclass); if($results){ while ($row3=$db->fetch_array($results)){ ?> <option value="<?php echo $row3['S_ID']?>" ><?php echo $row3['S_Name']?></option> <?php } } ?> </select> <input type="submit" value="确定转移" name="submit" class="rb1" /></td> </tr> <tr> <td height="30" class="td_border"> <strong><font color="#FF0000">注意:操作前请先备份数据库,程序将前面的分类数据合并到后面分类后将不能再恢复原始分类,请一定要慎重操作!</font></strong></td> </tr> </table> </form> </div> </div> </div> <?php } }//end class ?> <?php $ui=new ui_class; $action=SafeRequest("action","get"); switch($action){ case 'main': $ui->main(); break; case 'saveadd': saveadd(); break; case 'del': del(); break; case 'delall': delall(); break; case 'editall': editall(); break; case 'exhide': exhide(); break; case 'savefahterid': savefahterid(); break; case 'movevideo': movevideo(); break; case 'delbind': delbind(); break; default: $ui->main(); break; } function delbind(){ global $db; $sql="select * from s_class"; $result=$db->query($sql); if($result){ while($row=$db->fetch_array($result)){ $db->query("update s_class set S_TieID='' where S_ID=".$row['S_ID'].""); } } die("<script>jAlert('分类绑定取消成功!','操作提示',function(R){window.location='admin_articleclass.php';})</script>"); } function exhide(){ global $db; $S_ID=SafeRequest("S_ID","get"); $S_IsHide=SafeRequest("S_IsHide","get"); $sql="update s_class set S_IsHide=".$S_IsHide." where S_ID=".$S_ID.""; $db->query($sql); echo "<script>window.location='admin_articleclass.php';</script>"; } function movevideo(){ global $db; $classa=SafeRequest("Type_1","post"); $classb=SafeRequest("Type_2","post"); if(!IsNul($classa)|!IsNul($classb) ){ die("<script>jAlert('请选择要转移的分类?','操作提示',function(R){history.back();})</script>"); } $sql="select * from s_video where S_ClassID=".$classa.""; $result=$db->query($sql); if($result){ while($row=$db->fetch_array($result)){ $sqlstr="update s_video set S_ClassID=".$classb." where S_ID=".$row['S_ID'].""; $db->query($sqlstr); } die("<script>jAlert('数据转移成功!','操作提示',function(R){window.location='admin_articleclass.php';})</script>"); } } function savefahterid(){ global $db; $S_ID=SafeRequest("S_ID","get"); $S_FatherID=SafeRequest("S_FatherID","get"); if(IsNum($S_ID)||IsNum($S_FatherID)){ $sql="update s_class set S_FatherID=".$S_FatherID." where S_ID=".$S_ID.""; $db->query($sql); $sqlstr="select * from s_class where S_FatherID=".$S_ID.""; $result=$db->query($sqlstr); if($result){ while($row=$db->fetch_array($result)){ $db->query("update s_class set S_FatherID=".$S_FatherID." where S_ID=".$row['S_ID'].""); } } echo "<script>window.location='admin_articleclass.php';</script>"; } } function editall(){ global $db; $S_ID=RequestBox("S_ID"); if($S_ID=="0"){ die("<script>jAlert('请选择要编辑的分类?','操作提示',function(R){history.back();})</script>"); } else{ $ID=explode(",",$S_ID); for($i=0;$i<count($ID);$i++){ $S_Name=SafeRequest("S_Name".$ID[$i]."","post"); $S_AliasName=SafeRequest("S_AliasName".$ID[$i]."","post"); $S_Template=SafeRequest("S_Template".$ID[$i]."","post"); $S_TheOrder=SafeRequest("S_TheOrder".$ID[$i]."","post"); $S_IsHide=SafeRequest("S_IsHide".$ID[$i]."","post"); if(!IsNul($S_Name)){die("<script>jAlert('分类名称不能为空!','操作提示',function(R){history.back();})</script>");} if(!IsNul($S_AliasName)){die("<script>jAlert('分类别名称不能为空!','操作提示',function(R){history.back();})</script>");} $sql="update s_class set S_Name='".$S_Name."',S_AliasName='".$S_AliasName."',S_TheOrder=".$S_TheOrder.",S_Template='".$S_Template."',S_IsHide=".$S_IsHide." where S_ID=".$ID[$i].""; $db->query($sql); } die("<script>jAlert('恭喜!恭喜分类编辑成功!','操作提示',function(R){window.location='admin_articleclass.php';})</script>"); } } function delall(){ global $db; $S_ID=RequestBox("S_ID"); $sql="delete from s_class where S_ID in ($S_ID)"; if($S_ID=="0"){ die("<script>jAlert('请选择要删除的分类?','操作提示',function(R){history.back();})</script>"); } else{ if($db->query($sql)){ die("<script>jAlert('恭喜你!操作成功了!','成功提示',function(R){window.location='admin_articleclass.php';})</script>"); } } } function del(){ global $db; $S_ID=SafeRequest("S_ID","get"); $sql="delete from s_class where S_ID='".$S_ID."'"; if($db->query($sql)){ echo "<script>window.location='admin_articleclass.php';</script>"; } } function saveadd(){ global $db; $S_Name=SafeRequest("S_Name","post"); $S_AliasName=SafeRequest("S_AliasName","post"); $S_FatherID=SafeRequest("S_FatherID","post"); $S_TheOrder=SafeRequest("S_TheOrder","post"); $S_Template=SafeRequest("S_Template","post"); $S_IsHide=SafeRequest("S_IsHide","post"); $sql="Insert s_class (S_Name,S_AliasName,S_FatherID,S_TheOrder,S_Template,S_IsHide,S_SystemID) values ('".$S_Name."','".$S_AliasName."',".$S_FatherID.",".$S_TheOrder.",'".$S_Template."',".$S_IsHide.",2)"; $db->query($sql); echo "<script>window.location='admin_articleclass.php';</script>"; } ?> <?php include "admin_bottom.php"; ?> </body> </html>