<?php
class display{
	var $db='';
	function display ()	{
		global $CLASS,$PAGE,$SID;
		$this->db = $CLASS["db"];
		$this->page = $PAGE;
		if (empty($this->page)){
		              $this->page=1;
	           }
	}// End Function

	function ddw_list_selected($sql_str,$f_name,$f_value,$select_value){  
		 $query= $this->db->query($sql_str);
		 while ($row=$this->db->fetch_array($query)){
			  if ($row[$f_value] == $select_value)
				   $str_selected = "selected";
			  else
				   $str_selected = ""; 
			  print "<option value='".$row[$f_value]."'".$str_selected.">".$row[$f_name]."</option>";
		 }//while
	}

	function ctrl_page_design_limit_show ($sql,$page_show,$page_size,$txt_colr,$link_colr,$char_sub,$link_value) {
		global $startPage,$endPage;
		$totalpage= $this->find_totalpage ($sql,$page_size);
		if($page_show >= $totalpage)
		    $page_show=$totalpage;
		   if ($this->page==1){
                 $startPage = 1;
			    $endPage = $page_show;
		   }else if ($this->page == $endPage && $this->page != $totalpage)  {
               $startPage = $this->page;
			   $endPage  +=($page_show-1); 
			  if ($endPage > $totalpage)
				    $endPage = $totalpage;
			}else if ($this->page < $startPage) {
				 $endPage = $startPage;
				$startPage = ($endPage-$page_show)+1;
			}else if($this->page == $totalpage){
				$endPage = $totalpage;
				 $startPage=$totalpage-$page_show+1;
				if($startPage< '0' ){
				$endPage ="" ;
				$startPage="";
				}
			}

			$link_value .="&startPage=$startPage&endPage=$endPage";
			if ($this->page != 1){ // Prvious
				$prev_page = $this->page-1;
				$ctrlPage.= "<a href='$PHP_SELF?page_size=$page_size&PAGE=1$link_value'><font color='$link_colr'>|&lt;  </font></a>&nbsp;";
				$ctrlPage.= "<a href='$PHP_SELF?page_size=$page_size&PAGE=$prev_page$link_value'><font color='$link_colr'>&lt;&lt;  </font></a>&nbsp;";
			}
			if ($totalpage > 1) {
				for($i=$startPage ; $i<$this->page ; $i++) 
				{
					$ctrlPage.= "<a href='$PHP_SELF?page_size=$page_size&PAGE=$i$link_value'><font color=$link_colr>$i</font></a> $char_sub ";
				}
				$ctrlPage.= "<font color=$txt_colr><b>".$this->page."</b></font> $char_sub ";
				for($i=$this->page+1 ; $i<=$endPage ; $i++) 
				{
					$ctrlPage.= "<a href='$PHP_SELF?page_size=$page_size&PAGE=$i$link_value'><font color=$link_colr>$i</font></a> $char_sub ";
				} 
				if (($this->page != $totalpage) && ($totalpage !=0)){
					$next_page = $this->page+1;
					$ctrlPage.= "<a href='$PHP_SELF?page_size=$page_size&PAGE=$next_page$link_value'><font color='$link_colr'>&gt;&gt;</font></a>";
					$ctrlPage.= "&nbsp;<a href='$PHP_SELF?page_size=$page_size&PAGE=$totalpage$link_value'><font color='$link_colr'>&gt;|</font></a>";
				}
			}else{
				$ctrlPage =1;
			}
			return " ".$ctrlPage;
	}
	function find_totalpage ($sql_str,$page_size) {
	  $rows = $this->db->num_rows($this->db->query($sql_str));
	  $rt = $rows%$page_size;	// �Ҩӹǹ˹�ҷ�����
	  if($rt!=0){ 
		$totalpage = floor($rows/$page_size)+1; 
	  }
	  else 
	  {
		$totalpage = floor($rows/$page_size); 
	  }
	  return $totalpage;
	}
	function get_data($sql,$data){
	$query=$this->db->query($sql);
	$rec=$this->db->fetch_array($query);
	 return $rec[$data]; 		
	}
	
	//--------------------------------BP-------------------------------//
	function display_roomname($id){ //  
		$query_roomname = $this->db->query("select tb_room_name from tb_rooms where tb_room_id='".$id."'");
		$rec_roomname  = $this->db->fetch_array($query_roomname);
		 return $rec_roomname['tb_room_name']; 
	}
	function display_teachername($id){ // teachername
		$query_teachername = $this->db->query("select tb_teacher_name from tb_teachers where tb_teacher_id='".$id."'");
		$rec_teachername  = $this->db->fetch_array($query_teachername);
		 return $rec_teachername['tb_teacher_name']; 
	}
	function display_teachercode($id){ // teachername
		$query_teachername = $this->db->query("select tb_teacher_number from tb_teachers where tb_teacher_id='".$id."'");
		$rec_teachername  = $this->db->fetch_array($query_teachername);
		 return $rec_teachername['tb_teacher_number']; 
	}
	function display_studentall($id){ //  �����Źѡ���¹
		$query_studentall = $this->db->query("select tb_student_code,tb_student_tname,tb_student_name,tb_student_sname from tb_students where tb_student_id='".$id."'");
		$rec_studentall  = $this->db->fetch_array($query_studentall);
		 return display_nametype($rec_studentall['tb_student_tname']).$rec_studentall['tb_student_name'].'  '.$rec_studentall['tb_student_sname']; 
	}
	function display_studentallcode($id){ //  �����Źѡ���¹
		$query_studentall = $this->db->query("select tb_student_code,tb_student_tname,tb_student_name,tb_student_sname from tb_students where tb_student_code='".$id."'");
		$rec_studentall  = $this->db->fetch_array($query_studentall);
		 return display_nametype($rec_studentall['tb_student_tname']).$rec_studentall['tb_student_name'].'  '.$rec_studentall['tb_student_sname']; 
	}
	function display_studentallcode_show($id){ //  �����Źѡ���¹
		$query_studentall = $this->db->query("select tb_student_code,tb_student_tname,tb_student_name,tb_student_sname from tb_students where tb_student_code='".$id."'");
		$rec_studentall  = $this->db->fetch_array($query_studentall);
		 return $rec_studentall['tb_student_name'].'  '.$rec_studentall['tb_student_sname']; 
	}
	function display_studentcode($id){ // display_studentcode
		$query_studentall = $this->db->query("select tb_student_code  from tb_students where tb_student_id='".$id."'");
		$rec_studentall  = $this->db->fetch_array($query_studentall);
		 return $rec_studentall['tb_student_code']; 
	}
	function display_studentid($id){ //  ���ʹѡ���¹
		$query_studentall = $this->db->query("select tb_student_id  from tb_students where tb_student_code='".$id."'");
		$rec_studentall  = $this->db->fetch_array($query_studentall);
		 return $rec_studentall['tb_student_id']; 
	}
	function display_studentphone($id){ //  ���ʹѡ���¹
		$query_studentall = $this->db->query("select tb_student_phone  from tb_students where tb_student_code='".$id."'");
		$rec_studentall  = $this->db->fetch_array($query_studentall);
		 return $rec_studentall['tb_student_phone']; 
	}
	function display_studentdegree($id){ //  ���ʹѡ���¹
		$query_studentdegree = $this->db->query("select tb_room_name,tb_room_id  from tb_rooms where tb_room_id='".$id."'");
		$rec_studentdegree  = $this->db->fetch_array($query_studentdegree);
		 return $rec_studentdegree['tb_room_name']; 
	}
	function display_ruletype($id){ //  ����;ĵԡ���
		$query_ruletype = $this->db->query("select tb_ruletype_name  from tb_ruletypes where tb_ruletype_id='".$id."'");
		$rec_ruletype  = $this->db->fetch_array($query_ruletype);
		 return $rec_ruletype['tb_ruletype_name']; 
	}
	function display_rulescore($id){ //  ����;ĵԡ���
		$query_rulescore = $this->db->query("select tb_ruletype_score  from tb_ruletypes where tb_ruletype_id='".$id."'");
		$rec_rulescore  = $this->db->fetch_array($query_rulescore);
		 return $rec_rulescore['tb_ruletype_score']; 
	}
	function display_actname($id){ //  ����ͪ�����
		$query_actname = $this->db->query("select tb_act_name  from tb_acts where tb_act_id='".$id."'");
		$rec_actname  = $this->db->fetch_array($query_actname);
		 return $rec_actname['tb_act_name']; 
	}
	function display_knowname($id){ //  knowname
		$query_actname = $this->db->query("select tb_knowledge_name  from tb_knowledges where tb_knowledge_id='".$id."'");
		$rec_actname  = $this->db->fetch_array($query_actname);
		 return $rec_actname['tb_knowledge_name']; 
	}
	function display_knowteacherid($id){ //  knowname
		$query_actname = $this->db->query("select tb_teacher_id  from tb_knowledges where tb_knowledge_id='".$id."'");
		$rec_actname  = $this->db->fetch_array($query_actname);
		 return $rec_actname['tb_teacher_id']; 
	}
	function display_actteachername($id){ //  ����ͪ�����
		$query_actname = $this->db->query("select tb_teacher_id  from tb_acts where tb_act_id='".$id."'");
		$rec_actname  = $this->db->fetch_array($query_actname);
		 return $rec_actname['tb_teacher_id']; 
	}
	function display_adminall($id){ //  �������ʹ�Թ
		$query_studentall = $this->db->query("select tb_admin_name,tb_admin_sername from tb_admin where tb_admin_id='".$id."'");
		$rec_studentall  = $this->db->fetch_array($query_studentall);
		 return  $rec_studentall['tb_admin_name'].'  '.$rec_studentall['tb_admin_sername']; 
	}
	function display_performancename($id){ //  performancename
		$query_performancename = $this->db->query("select tb_performance_name  from tb_performances where tb_performance_id='".$id."'");
		$rec_performancename  = $this->db->fetch_array($query_performancename);
		return $rec_performancename['tb_performance_name']; 
	}
	function display_performancegroupname($id){ //  performancegroupname
		$query_performancegroupname = $this->db->query("select tb_performance_group_name  from tb_performance_groups where tb_performance_group_id='".$id."'");
		$rec_performancegroupname  = $this->db->fetch_array($query_performancegroupname);
		return $rec_performancegroupname['tb_performance_group_name']; 
	}
	function display_performancedetailname($id){ //  display_performancedetailname
		$query_performancegroupname = $this->db->query("select tb_performance_detail_name  from tb_performance_details where tb_performance_detail_id='".$id."'");
		$rec_performancegroupname  = $this->db->fetch_array($query_performancegroupname);
		return $rec_performancegroupname['tb_performance_detail_name']; 
	}
	function display_positionname($id){ //  positionname
		$query_positionname = $this->db->query("select tb_position_name  from tb_positions where tb_position_id='".$id."'");
		$rec_positionname  = $this->db->fetch_array($query_positionname);
		return $rec_positionname['tb_position_name']; 
	}
	function display_departmentname($id){ //  department_name
		$query_positionname = $this->db->query("select tb_department_name  from tb_departments where tb_department_id='".$id."'");
		$rec_positionname  = $this->db->fetch_array($query_positionname);
		return $rec_positionname['tb_department_name']; 
	}
	function display_academicname($id){ //  academic_name
		$query_positionname = $this->db->query("select tb_academic_name  from tb_academics where tb_academic_id='".$id."'");
		$rec_positionname  = $this->db->fetch_array($query_positionname);
		return $rec_positionname['tb_academic_name']; 
	}
	function display_teachertimename($id){ //  ���� ���
		$query_teachername = $this->db->query("select tb_teacher_name from tb_teachers where tb_teacher_number='".$id."'");
		$rec_teachername  = $this->db->fetch_array($query_teachername);
		 return $rec_teachername['tb_teacher_name']; 
	}
	function display_teachertimepic($id){ //  ���� ���
		$query_teachername = $this->db->query("select tb_teacher_picture from tb_teachers where tb_teacher_number='".$id."'");
		$rec_teachername  = $this->db->fetch_array($query_teachername);
		 return $rec_teachername['tb_teacher_picture']; 
	}
	function display_teacherroomname($id){ //  ���� ���
		$query_teachername = $this->db->query("select tb_teacher_name from tb_teachers where tb_teacher_degree='".$id."'");
		$rec_teachername  = $this->db->fetch_array($query_teachername);
		 return $rec_teachername['tb_teacher_name']; 
	}
	//
	//-------------------------------------------------------------------//
}// Class
?>