<?
	//include('include/page_header.php') ;
	include('administration/config/value.php') ;
	include('administration/config/language.php') ;
	include('include/template.php') ;
	include('administration/config/define.php') ;
	include('config/config.php');
    include('include/db.php');
	include('include/function.php');
	
	$template = new Template("template") ;
	
	$html_file="plnd.htm";	
	$php_file="plnd.php";	
	
	$template->set_filenames(array("body" => $html_file)) ;
	$template->assign_vars(array(		
						"USERID"   =>$_SESSION['user_id'],   
						));
	$base_left_menu 			= 'left_menu.htm';
	$base_top_menu 				= 'header.htm';
	$template->set_filenames(array(
		'left_menu' 		=> $base_left_menu,
		'top_banner' 		=> $base_top_menu,
	)) ;
	$template->assign_var_from_handle('LEFT_MENU','left_menu');
	$template->assign_var_from_handle('TOP_BANNER','top_banner');
	
	$find[] = "\"";  
	$replace[] = "'";
	
	$datein=date("d/m/y");
	$dateout=date("d/m/y",mktime(0, 0, 0, date("m")+1, date("d"), date("Y")));

	$table_hopdong		='tbl_hopdong';
	$table_kh			='tbl_khachhang';
	$table_nv			='tbl_nhanvien';
	$table_dv			='tbl_dichvu';
	$table_xl			='tbl_xuly';
	$table_gt			='tbl_gtkt';
	$table_giayto		='tbl_giayto';

	//Kiem tra quyen truy cap
	/*if($_SESSION['group_id']!=1)
		Gologin("access.php");*/
	
	if(@isset($_POST['search']))
	{	
		$template->assign_block_vars("searchhopdong", array());
		
		// Lay hop dong
		$sql_hd="select * from ".$table_hopdong." where mahopdong='".$_POST['mahd']."'";
		$result_hd = $db->sql_query($sql_hd) or $db->sql_error("Khong the truy cap data"); 
		$row_hd = $db->sql_fetchrowset($result_hd) ;
		
		if (count($row_hd)>0)
		{
			// so nguoi xem
			$songuoixem=$row_hd[0]['songuoixem']+1;
			$sql="update ".$table_hopdong." set ";
			$sql.=" songuoixem='".$songuoixem."'";
			$sql.=" where mahopdong='".$_POST['mahd']."'";
			$result = $db->sql_query($sql) or $db->sql_error("Loi: Khong the cap nhat so nguoi xem");
			//end cap nhat so nguoi xem
				
			// Ten khach hang
			$sql_kh="select hoten from ".$table_kh." where id_kh='".$row_hd[0]['id_khachhang']."'";
			$result_kh = $db->sql_query($sql_kh) or $db->sql_error("Khong the truy cap data"); 
			$row_kh = $db->sql_fetchrowset($result_kh) ;
			
			// Ten nhan vien
			$sql_nv="select name,phone from ".$table_nv." where id_member='".$row_hd[0]['id_nvthuchien']."'";
			$result_nv = $db->sql_query($sql_nv) or $db->sql_error("Khong the truy cap data"); 
			$row_nv = $db->sql_fetchrowset($result_nv) ;
			
			// Ten dich vu
			$sql_dv="select tendichvu from ".$table_dv." where id_dv='".$row_hd[0]['id_dichvu']."'";
			$result_dv = $db->sql_query($sql_dv) or $db->sql_error("Khong the truy cap data"); 
			$row_dv = $db->sql_fetchrowset($result_dv) ;
			
			//Xu ly : hien trang va thong tin bo sung
			$sql_xl="select * from ".$table_xl." where id_hopdong='".$row_hd[0]['id_hopdong']."' order by id_xuly desc limit 0,1";
			$result_xl = $db->sql_query($sql_xl) or $db->sql_error("Khong the truy cap data"); 
			$row_xl = $db->sql_fetchrowset($result_xl) ;
			
			$sql_xl2="SELECT DATEDIFF(STR_TO_DATE('".$row_hd[0]['ngaybangiao']."','%d/%m/%Y'),STR_TO_DATE('".$datein."','%d/%m/%Y')) as temp" ;
			$result_xl2 = $db->sql_query($sql_xl2) or $db->sql_error("Khong the truy cap data"); 
			$row_xl2 = $db->sql_fetchrowset($result_xl2) ;
			
			$songay = $row_xl2[0]['temp']; 
			
			if($songay<10){ $temp_colour ='text_red';}
			else if($songay>10 && $songay<20){ $temp_colour ='text_yellow';}
			else{ $temp_colour ='text_blue';}
			
			$template->assign_block_vars("view", array(
			"NGAYNHAN"  		=> $row_hd[0]['thoigiannhan'],
			"DATE_HT" 			=> $row_hd[0]['ngaybangiao'],
			"MAHD"  			=> $row_hd[0]['mahopdong'],
			"DIACHI"  			=> $row_hd[0]['diachibds'],
			"LUOTXEM" 			=> $row_hd[0]['songuoixem']+1,
			"SONGAY" 			=> $songay,
			"KHACHHANG" 		=> $row_kh[0]['hoten'],
			"NHANVIEN"  		=> $row_nv[0]['name'].' - '.$row_nv[0]['phone'],
			"DICHVU" 			=> $row_dv[0]['tendichvu'],
			"HIENTRANG"  		=> $row_xl[0]['hientrang'],
			"THONGTIN" 			=> $row_xl[0]['thongtinbosung'],
			"CONTENT" 			=> $row_hd[0]['noidung'],
			"CSS_SN" 			=> $temp_colour,
			));
			
			$sql_cat="select * from ".$table_xl." where id_hopdong='".$row_hd[0]['id_hopdong']."' order by id_xuly asc";
			$result_cat = mysql_query($sql_cat) or die("Khong the truy xuat Tinh/Thanh"); 
			$row_cat = $db->sql_fetchrowset($result_cat) ;
			
			for ($i=0 ; $i<count($row_cat); $i++ )
			{	
				$template->assign_block_vars("view.cat", array(
						"ID"  				=> $row_cat[$i]['id_xuly'],
						"HIENTRANG"  		=> $row_cat[$i]['hientrang'],
						"THONGTIN" 			=> $row_cat[$i]['thongtinbosung'],
						"NGAY" 				=> $row_cat[$i]['ngay'],
						"BGCOLOR" 			=> ($i%2==0)?"#E6F2FF":"#FFFFFF",
							));
			}
			
			// Cac giay to kem theo
			$sql_gt="select id_giayto from ".$table_gt." where id_hopdong='".$row_hd[0]['id_hopdong']."' order by id_giayto desc";
			$result_gt = mysql_query($sql_gt) or die("Khong the truy xuat Tinh/Thanh"); 
			$row_gt = $db->sql_fetchrowset($result_gt) ;
			
			for ($i=0 ; $i<count($row_gt); $i++ )
			{	
				$sql_giayto="select ten from ".$table_giayto." where id_giayto='".$row_gt[$i]['id_giayto']."' order by id_giayto desc";
				$result_giayto = mysql_query($sql_giayto) or die("Khong the truy xuat Tinh/Thanh"); 
				$row_giayto = $db->sql_fetchrowset($result_giayto) ;
				
				for ($j=0 ; $j<count($row_gt); $j++ )
				{
					$template->assign_block_vars("view.giayto", array(
						"GIAYTO" 		=> $row_giayto[$j]['ten'] ? '<img src="images/icon30.gif" alt="">&nbsp; '.$row_giayto[$j]['ten'].'&nbsp; ;<br>' : '',
							));
				}
			}
		}
		else
		{
			$template->assign_block_vars("noview", array());
		}	
	}
	else
	{	
		$template->assign_block_vars("search", array());
	}	
	
		$template->assign_vars(array(		
						"PHP_FILE" => $php_file,
						"QUANLYNOIDUNG" => $admin_quanlynoidung,
						"ID" => $_SESSION['user_id'],
						
						));

/////////////////////////////////////////////////////////////////////////////////////////									
$template->pparse("body") ;
include('include/page_footer.php') ;
?>