<script>
$(document).ready(function() {
$("#chonhet").click(function(){
	var status=this.checked;
	$("input[name='chon']").each(function(){this.checked=status;})
});

$("#xoahet").click(function(){
	var listid="";
	$("input[name='chon']").each(function(){
		if (this.checked) listid = listid+","+this.value;
    	})
	listid=listid.substr(1);	 //alert(listid);
	if (listid=="") { alert("Bạn chưa chọn mục nào"); return false;}
	hoi= confirm("Bạn có chắc chắn muốn xóa?");
	if (hoi==true) document.location = "index.php?com=sanpham&act=delete&listid=" + listid;
});
});
</script>

<h3><a href="index.php?com=sanpham&act=add">Thêm dự án</a></h3>
Danh mục cấp 1&nbsp;
<?=get_main_category()?>
Danh mục cấp 2&nbsp;
<?=get_main_item();?>
<!--Danh mục cấp 3&nbsp;
<?=get_main_item2();?>-->
</h3>
<script language="javascript">	
	function select_onchange()
	{	
		var b=document.getElementById("id_cat");
		window.location ="index.php?com=sanpham&act=man&id_cat="+b.value;	
		return true;
	}
	
	function select_onchange1()
	{
		var b=document.getElementById("id_cat");
		var c=document.getElementById("id_list");
		window.location ="index.php?com=sanpham&act=man&id_cat="+b.value+"&id_list="+c.value;	
		return true;
	}
		function select_onchange2()
	{	
		var b=document.getElementById("id_cat");
		var c=document.getElementById("id_list");
		var a=document.getElementById("id_item");
		window.location ="index.php?com=sanpham&act=man&id_cat="+b.value+"&id_list="+c.value+"&id_item="+a.value;	
		return true;
	}


</script>
<?php
	
	function get_main_category()
	{
		$sql="select * from table_product_cat order by stt asc,id desc";
		$stmt=mysql_query($sql);
		$str='
			<select id="id_cat" name="id_cat" onchange="select_onchange()" class="main_font">
			<option>Chọn danh mục</option>			
			';
		$id_cat = (int) isset($_REQUEST['id_cat']) ? $_REQUEST['id_cat'] : 0;
		while ($row=@mysql_fetch_array($stmt)) 
		{
			if($row["id"]==@$id_cat)
				$selected="selected";
			else 
				$selected="";
			$str.='<option value='.$row["id"].' '.$selected.'>'.$row["ten"].'</option>';			
		}
		$str.='</select>';
		return $str;
	}	
	
	function get_main_item()
	{
		$id_cat = (int) isset($_REQUEST['id_cat']) ? $_REQUEST['id_cat'] : 0;
		$id_list =  isset($_REQUEST['id_list']) ? $_REQUEST['id_list'] : 0;
		
		$sql_huyen="select * from table_product_list where id_cat='".$id_cat."'  order by stt desc ";
		$result=mysql_query($sql_huyen);
		$str='
			<select id="id_list" name="id_list" onchange="select_onchange1()" class="main_font">
			<option>Chọn danh mục</option>	
			';
		$id_list = (int) isset($_REQUEST['id_list']) ? $_REQUEST['id_list'] : '';
		while ($row_huyen=@mysql_fetch_array($result)) 
		{
			if($row_huyen["id"] == $id_list)
				$selected="selected";
			else 
				$selected="";
			$str.='<option value='.$row_huyen["id"].' '.$selected.'>'.$row_huyen["ten"].'</option>';			
		}
		$str.='</select>';
		return $str;
	}
	function get_main_item2()
	{
		$id_cat = (int) isset($_REQUEST['id_cat']) ? $_REQUEST['id_cat'] : 0;
		$id_list =  isset($_REQUEST['id_list']) ? $_REQUEST['id_list'] : 0;
		$id_item =  isset($_REQUEST['id_item']) ? $_REQUEST['id_item'] : 0;
		
		$sql_huyen="select * from table_product_item where id_cat='".$id_cat."' and id_list='".$id_list."' order by stt desc ";
		$result2=mysql_query($sql_huyen);
		$str='
			<select id="id_item" name="id_item" onchange="select_onchange2()" class="main_font">
			<option>Chọn danh mục</option>	
			';
		while ($row_huyen2=@mysql_fetch_array($result2)) 
		{
			if($row_huyen2["id"]== $id_item)
				$selected="selected";
			else 
				$selected="";
			$str.='<option value='.$row_huyen2["id"].' '.$selected.'>'.$row_huyen2["ten"].'</option>';			
		}
		$str.='</select>';
		return $str;
	}
	
	$id_cat = (int) isset($_REQUEST['id_cat']) ? $_REQUEST['id_cat'] : 0;
	$id_list =  isset($_REQUEST['id_list']) ? $_REQUEST['id_list'] : 0;
	$id_item =  isset($_REQUEST['id_item']) ? $_REQUEST['id_item'] : 0;
?>
<table class="blue_table">
    <tr>
        <th style="width:3%" align="center"><input type="checkbox" name="chonhet" id="chonhet" /></th>
        <th style="width:4%;">Stt</th>
        <th style="width:4%;">Hình ảnh</th>
        <th style="width:12%;">Danh mục cấp 1</th>
        <!--  <th style="width:12%;">Danh mục cấp 2</th>
       <th style="width:12%;">Danh mục cấp 3</th> -->
        <th style="width:20%;">Tên </th>
        <th style="width:8%;">Thêm dữ liệu</th>
        <th style="width:4%;">Hot</th>
        <th style="width:4%;">Hiển thị</th>
        <th style="width:4%;">Sửa</th>
        <th style="width:4%;">Xóa</th>
    </tr>
    <?php 
	for($i=0, $count=count($items); $i<$count; $i++)
	{
		$ur=""; 
		if(isset($_REQUEST['id_cat']) && $_REQUEST['id_cat']!='')
		{
			$ur="&id_cat=".$id_cat;
			$ur.="&id_list=".$id_list;
		}
		$curPage = (isset($_REQUEST['curPage']) && $_REQUEST['curPage']!='')? '&curPage='.$_REQUEST['curPage'] : '';
		$id_list = (isset($_REQUEST['id_list']) && ($_REQUEST['id_list']!='')) ? "&id_list=".$_REQUEST['id_list'] : '' ;
		$id_item = (isset($_REQUEST['id_item']) && ($_REQUEST['id_item']!='')) ? "&id_item=".$_REQUEST['id_item'] : '' ;
	?>
    <tr>
        <td style="width:3%;" align="center"><input type="checkbox" name="chon" id="chon" value="<?=$items[$i]['id']?>" class="chon" /></td>
        <td style="width:4%;"><?=$items[$i]['stt']?></td>
        <td style="width:4%;"><img src="<?=_upload_sanpham.$items[$i]['photo']?>" width="100" /></td>
        <td style="width:12%;">
		<?php
			$sql_danhmuc="select ten from table_product_cat where id='".$items[$i]['id_cat']."'";
			$result=mysql_query($sql_danhmuc);
			$item_danhmuc =mysql_fetch_array($result);
			echo @$item_danhmuc['ten']
		?></td>
        <!--     <td style="width:12%;">
		<?php
			/*$sql_danhmuc="select ten from table_product_list where id='".$items[$i]['id_list']."'";
			$result=mysql_query($sql_danhmuc);
			$item_danhmuc =mysql_fetch_array($result);
			echo @$item_danhmuc['ten'];*/
		?>
        </td>
        <td style="width:12%;">
    	  <?php
				/*$sql_danhmuc="select ten from table_product_item where id='".$items[$i]['id_item']."'";
				$result=mysql_query($sql_danhmuc);
				$item_danhmuc =mysql_fetch_array($result);
				echo @$item_danhmuc['ten']*/
			?>    
        </td>  -->
        
        <td style="width:12%; text-align:left"><a href="index.php?com=sanpham&act=edit&id_cat=<?=$items[$i]['id_cat']?>&id_list=<?=$items[$i]['id_list']?>&id=<?=$items[$i]['id']?>">
            <?=$items[$i]['ten']?></a></td>
        <td style="width:8%;"><a href="index.php?com=baivietsp&act=default&amp;id_product=<?=$items[$i]['id']?>&id_cat=<?=$id_cat?>&id_list=<?=$id_list?>&id_item=<?=$id_item?>" style="text-decoration:none;" class="view-pic"> <?php echo "Thêm bài viết";?> </a> <br>
            <a href="index.php?com=mausac&act=default&amp;id_product=<?=$items[$i]['id']?>&id_cat=<?=$id_cat?>&id_list=<?=$id_list?>&id_item=<?=$id_item?>" style="text-decoration:none;" class="view-pic"> <?php echo "Thêm hình";?> </a> <br>
            <a href="index.php?com=vdsp&act=default&amp;id_product=<?=$items[$i]['id']?>&id_cat=<?=$id_cat?>&id_list=<?=$id_list?>&id_item=<?=$id_item?>" style="text-decoration:none;" class="view-pic"> <?php echo "Thêm video";?> </a></td>
        <td align="center" style="width:4%;"><?php if($items[$i]['hot']>0){?>
            <a href="index.php?com=sanpham&act=man<?=$ur?>&hot=<?=$items[$i]['id']?><?=$curPage?>"><img src="media/images/ok.gif" border="0" /></a>
            <?php }else{?>
            <a href="index.php?com=sanpham&act=man<?=$ur?>&hot=<?=$items[$i]['id']?><?=$curPage?>"><img src="media/images/no.png" border="0" /></a>
            <?php } ?></td>
        <td style="width:4%;">
		<?php 
		if(@$items[$i]['hienthi']==1)
		{
		?>
            <a href="index.php?com=sanpham&act=man<?=$ur;?>&hienthi=<?=$items[$i]['id']?><?=$curPage?>"><img src="media/images/active_1.png" border="0" /></a>
		<? 
		}
		else
		{
		?>
            <a href="index.php?com=sanpham&act=man<?=$ur;?>&hienthi=<?=$items[$i]['id']?><?=$curPage?>"><img src="media/images/active_0.png"  border="0"/></a>
		<?php }?></td>
        <td style="width:4%;"><a href="index.php?com=sanpham&act=edit&id_cat=<?=$items[$i]['id_cat']?>&id_list=<?=$items[$i]['id_list']?>&id_item=<?=$items[$i]['id_item']?>&id=<?=$items[$i]['id']?>"><img src="media/images/edit.png" /></a></td>
        <td style="width:4%;"><a href="index.php?com=sanpham&act=delete&id=<?=$items[$i]['id']?>" onClick="if(!confirm('Xác nhận xóa')) return false;"><img src="media/images/delete.png" /></a></td>
    </tr>
    <?php }?>
</table>
    <a href="index.php?com=sanpham&act=add=<?=$id_cat?><?=$id_list?><?=$id_item?>"><img src="media/images/add.jpg" border="0"  /></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
    <a href="#" id="xoahet"><img src="media/images/delete.jpg" border="0" /></a>
    <div class="paging"><?=$paging['paging']?></div>