| .. | |||||
| images | |||||
| .DS_Store | |||||
| admin.cat.php | |||||
| admin.news.php | |||||
| admin.slide.php | |||||
| admin.zpassword.php | |||||
| admin_style.css | |||||
| index.php | |||||
| login.php |
| Server IP : 104.21.87.198 / Your IP : 172.71.81.77 Web Server : Apache/2.2.15 (CentOS) System : Linux GA 2.6.32-431.1.2.0.1.el6.x86_64 #1 SMP Fri Dec 13 13:06:13 UTC 2013 x86_64 User : apache ( 48) PHP Version : 5.6.38 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/html/daithuanpc/backup/adminxp/ |
Upload File : |
<?php
//@Danh mục
//@10
//@2
defined( '_WTF' ) or die( 'Direct Access to this location is not allowed.' );
$submenu='';
$sub=@$_GET['sub'];
$page_title.=' - Danh mục';
$content=toolbox();
switch ($sub){
case 'addnew':
$content.=newcat();
break;
case 'donewcat':
$content.=donewcat();
break;
case 'delete':
$content.=delete();
break;
case 'edit':
$content.=edit();
break;
case 'doedit':
$content.=doedit();
break;
default:
$content.=showlist();
break;
}
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
function toolbox(){
global $cf;
$nd='
<h2><img src="adminxp/images/button/cpanel.png" width="24" /> Quản lý Danh mục</h2>
<ul id="categoryContainer">
<li>
<div class="category_element">
<a href="?option=cat">
<img src="adminxp/images/button/frontpage.png" /><br />
Quản lý nội dung này
</a>
</div>
</li>
<li>
<div class="category_element">
<a href="?option=cat&sub=addnew">
<img src="adminxp/images/button/stocks.png" /><br />
Thêm mới
</a>
</div>
</li>
</ul>
<br class="clearfloat" />
';
return $nd;
}
function showlist(){
global $cf;
$nd='';
$db=new Kdb($cf);
$sql1="SELECT * FROM {$cf['prefix']}cat WHERE cat_parent=0 ORDER BY cat_order DESC";
$db->query($sql1);
$r = $db->rows;
$nd.='
<center>
<table width="550" border="0" cellpadding="2" cellspacing="2">
<tr bgcolor="#ccccff" height="25" align="center">
<td width="300"><b>Tên danh mục</b></td>
<td><b>Vị trí</b></td>
<td width="100"><b>Hiện trang chủ</b></td>
<td width="50"></td>
</tr>
';
for ($i=0;$i<count($r);$i++){
$row=$r[$i];
$bg='bgcolor="#ededed"';
$showhome='<img src="adminxp/images/button/publish_x.png" />';
$nd.='<tr '.$bg.' height="20">';
$nd.= '<td><b>'.$row["cat_name"].'<b></td>';
$nd.= '<td><b>'.$row["cat_order"].'<b></td>';
if ($row["cat_home"]==1){
$nd.= '<td>Hiện</td>';
} else{
$nd.= '<td>Ẩn</td>';
}
$nd.= '<td align="center">
<a href="?option=cat&sub=edit&id='.$row["cat_id"].'"><img src="adminxp/images/button/edit_f2.png" width="16" /></a>
<a href="#" onclick="askdel(\'?option=cat&sub=delete&id='.$row["cat_id"].'\'); return false;"><img src="adminxp/images/button/cancel_f2.png" width="16" /></a></td>';
$nd.='</tr>';
$nd.=showsubcat($row["cat_id"],$row["cat_name"]);
}
$nd.='</table></center>';
return $nd;
}
function showsubcat($id,$parent_name){
global $cf;
$nd='';
$db=new Kdb($cf);
$sql="SELECT * FROM {$cf['prefix']}cat WHERE cat_parent={$id} ORDER BY cat_order DESC, cat_name";
$db->query($sql);
$r = $db->rows;
for ($i=0;$i<count($r);$i++){
$row=$r[$i];
$bg='bgcolor="#ddddff"';
$nd.='<tr '.$bg.' height="20">';
$nd.= '<td><img src="adminxp/images/button/forward_f2.png" width="16" /> '.$row["cat_name"].'</td>';
$nd.= '<td>'.$row["cat_order"].'</td>';
if ($row["cat_home"]==1){
$nd.= '<td>Hiện</td>';
} else{
$nd.= '<td>Ẩn</td>';
}
$nd.= '<td align="center">
<a href="?option=cat&sub=edit&id='.$row["cat_id"].'"><img src="adminxp/images/button/edit_f2.png" width="16" /></a>
<a href="#" onclick="askdel(\'?option=cat&sub=delete&id='.$row["cat_id"].'\'); return false;"><img src="adminxp/images/button/cancel_f2.png" width="16" /></a></td>';
$nd.='</tr>';
$nd.=showsubcat($row["cat_id"],$row["cat_name"]);
}
return $nd;
}
function newcat(){
global $cf;
$parents='';
$db=new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}cat WHERE cat_parent=0 ORDER BY cat_order DESC");
$r=$db->rows;
$db->disconnect();
for ($i=0;$i<count($r);$i++){
$parents.='<option value="'.$r[$i]['cat_id'].'">'.$r[$i]['cat_name'].'</option>';
}
$nd='<center>
<h4>Thêm Danh mục</h4>
<form action="?option=cat&sub=donewcat" method="post">
<table width="450" border="0" cellpadding="1" cellspacing="2">
<tr>
<td width="150" bgcolor="#efefef"><b>Tên danh mục *</b></td>
<td width="300"><input type="text" name="cat_name" style="width:99%;" value=""></td>
</tr>
<tr>
<td bgcolor="#efefef"><b>Vị trí</b></td>
<td><input type="text" name="cat_order" style="width:99%;" value="0"></td>
</tr>
<tr>
<td bgcolor="#efefef"><b>Hiện trang chủ</b></td>
<td>
<select name="cat_home">
<option value="1">Hiện</option>
<option value="0">Ẩn</option>
</select>
</td>
</tr>
<tr>
<td bgcolor="#efefef"><b>Danh mục cha</b></td>
<td>
<select name="cat_parent">
<option value="0">Danh mục gốc</option>
'.$parents.'
</select>
</td>
</tr>
</table>
<br />
<input type="submit" value="Thêm Danh mục">
</form>
</center>
';
return $nd;
}
function donewcat(){
global $cf;
$nd='';
$cat_name=_s($_POST['cat_name']);
$cat_order=(int) _s($_POST['cat_order']);
$cat_home=$_POST['cat_home'];
$cat_parent=(int) _s($_POST['cat_parent']);
if ($cat_name==""){
$nd='<h2 align="center">Thiếu tên danh mục. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
} else{
$db=new Kdb($cf);
$db->query("SELECT cat_id FROM {$cf['prefix']}cat WHERE cat_name LIKE '$cat_name' ORDER BY cat_order");
$r=$db->rows;
if (count($r)>0){
$nd='<h2 align="center">Tên danh mục đã tồn tại. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
} else{
$sql="INSERT INTO {$cf['prefix']}cat(cat_name, cat_home, cat_parent, cat_order)
VALUES('{$cat_name}',{$cat_home},{$cat_parent}, {$cat_order})";
$db->query($sql);
$nd='<h2 align="center">Thêm thành công. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
}
$db->disconnect();
}
return $nd;
}
function delete(){
global $cf;
$nd='';
$id=(int) @$_GET['id'];
if ($id>0){
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}cat WHERE cat_id={$id}");
$r=$db->rows;
if (count($r)<1){
$nd='<h2 align="center">danh mục không tồn tại. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
} else{
$db->query("SELECT * FROM {$cf['prefix']}cat WHERE cat_parent={$id}");
$r1=$db->rows;
if (count($r1)>0){
$nd='<h2 align="center">Danh mục có chứa danh mục con, không thể xóa. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
} else{
$db->query("SELECT gd_id FROM {$cf['prefix']}goods WHERE gd_cat={$id}");
$r2=$db->rows;
if (count($r2)>0){
$nd='<h2 align="center">danh mục có chứa hàng hóa, không thể xóa. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
} else{
$db->query("DELETE FROM {$cf['prefix']}cat WHERE cat_id={$id}");
$nd='<h2 align="center">Xóa thành công. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
}
}
}
$db->disconnect();
} else{
$nd='<h2 align="center"><a href="javascript:history.go(-1);">Quay lại</a></h2>';
}
return $nd;
}
function edit(){
global $cf;
$id=(int) @$_GET['id'];
$parents='';
$db=new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}cat WHERE cat_id={$id}");
$r=$db->rows;
if (count($r)<1){
$nd='<h2 align="center">Danh mục không tồn tại. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
} else{
$db->query("SELECT * FROM {$cf['prefix']}cat WHERE cat_parent=0 AND cat_id!={$id} ORDER BY cat_order, cat_name");
$r1=$db->rows;
for ($i=0;$i<count($r1);$i++){
if ($r[0]['cat_parent']==$r1[$i]['cat_id']){
$parents.='<option value="'.$r1[$i]['cat_id'].'" selected>'.$r1[$i]['cat_name'].'</option>';
} else{
$parents.='<option value="'.$r1[$i]['cat_id'].'">'.$r1[$i]['cat_name'].'</option>';
}
}
if ($r[0]['cat_home']==1){
$home1='selected';
$home0='';
} else{
$home1='';
$home0='selected';
}
$nd='<center>
<h4>Sửa Danh mục</h4>
<form action="?option=cat&sub=doedit" method="post">
<input type="hidden" name="cat_id" value="'.$r[0]['cat_id'].'">
<table width="450" border="0" cellpadding="1" cellspacing="2">
<tr>
<td width="150" bgcolor="#efefef"><b>Tên danh mục *</b></td>
<td width="300"><input type="text" name="cat_name" style="width:99%;" value="'.$r[0]['cat_name'].'"></td>
</tr>
<tr>
<td bgcolor="#efefef"><b>Vị trí</b></td>
<td><input type="text" name="cat_order" style="width:99%;" value="'.$r[0]['cat_order'].'"></td>
</tr>
<tr>
<td bgcolor="#efefef"><b>Hiện trang chủ</b></td>
<td>
<select name="cat_home">
<option value="1" '.$home1.'>Hiện</option>
<option value="0" '.$home0.'>Ẩn</option>
</select>
</td>
</tr>
<tr>
<td bgcolor="#efefef"><b>Danh mục cha</b></td>
<td>
<select name="cat_parent">
<option value="0">Danh mục gốc</option>
'.$parents.'
</select>
</td>
</tr>
</table>
<br />
<input type="submit" value="Sửa Danh mục">
</form>
</center>
';
}
$db->disconnect();
return $nd;
}
function doedit(){
global $cf;
$nd='';
$cat_id=(int) _s($_POST['cat_id']);
$cat_name=_s($_POST['cat_name']);
$cat_order=(int) _s($_POST['cat_order']);
$cat_home=(int) _s($_POST['cat_home']);
$cat_parent=(int) _s($_POST['cat_parent']);
if ($cat_name==""){
$nd='<h2 align="center">Thiếu tên danh mục. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
} else{
$db=new Kdb($cf);
$db->query("SELECT cat_id FROM {$cf['prefix']}cat WHERE cat_name LIKE '$cat_name' AND cat_id!={$cat_id}");
$r=$db->rows;
if (count($r)>0){
$nd='<h2 align="center">Tên danh mục tồn tại. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
} else{
$db->query("SELECT * FROM {$cf['prefix']}cat WHERE cat_id={$cat_id}");
$r=$db->rows;
if ($r[0]['cat_id']<1){
$nd='<h2 align="center">Danh mục không có thật. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
} else{
$db->query("SELECT * FROM {$cf['prefix']}cat WHERE cat_parent={$cat_id}");
$r1=$db->rows;
if ($cat_parent>0 && count($r1)>0){
$nd='<h2 align="center">Danh mục có chứa danh mục con. Chỉ hỗ trợ 2 cấp danh mục. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
} else{
$db->query("UPDATE {$cf['prefix']}cat SET cat_name='{$cat_name}', cat_home={$cat_home},
cat_parent={$cat_parent},cat_order={$cat_order} WHERE cat_id={$cat_id}");
$nd='<h2 align="center">Sửa thành công. <a href="javascript:history.go(-1);">Quay lại</a></h2>';
}
}
}
$db->disconnect();
}
return $nd;
}
?>| .. | |||||
| images | |||||
| .DS_Store | |||||
| admin.cat.php | |||||
| admin.news.php | |||||
| admin.slide.php | |||||
| admin.zpassword.php | |||||
| admin_style.css | |||||
| index.php | |||||
| login.php |