<?php


	/*
	 * @(#)PopedomInformation.class.php 1.0 05/05/17
	 *
	 * Copyright 2005 Garfield.Huang
	 */


	/**
	* <b>權(quán)限信息處理程序</b><br>
	* @author	Garfield.Huang
	* @version	1.0 05/05/17
	* @since   	PHP 5.0.3
	*/
	
	
	class PopedomInformation {
	
	/**
	* 傳入的數(shù)據(jù)庫句柄
	*/
	var $db;
	
	/**
	* 得到的結(jié)果集
	*/
	var $resultSet;
	
	
	/**
	* 增加權(quán)限類別
	* @return	boolean	操作成功返回true
	*/
		
	function append ()
	{
		
			$sqlL = "insert into popedom_info (";
			$sqlR = "values (";
						
			//權(quán)限名稱
			$sqlL .= "popedomname,";
			$sqlR .= "'" . trim( $_POST["popedomname"] ) . "',";
			
			
			//權(quán)限代碼
			$sqlL .= "popedomcode)";
			$sqlR .= "'" . $this->getNewPopedomCode() . "')";

			
			$this->db->query( $sqlL . $sqlR );

			return true;
			
	}
	
	
	/**
	* 修改權(quán)限類別
	* @return	boolean	操作成功返回true
	*/
	
	function edit ()
	{
		
			$sql = "update popedom_info set ";
			
			//權(quán)限名稱
			$sql .= "popedomname='". trim( $_POST["popedomname"] ) ."'";
			$sql .= " where popedomcode = '" . trim( $_POST["popedomcode"] ) . "'";
			
			$this->db->query( $sql );
			
			return true;
			
	}
	
	
	/**
	* 刪除權(quán)限類別
	* @return	boolean	操作成功返回true
	*/
	
	function del()
	{
		$sql = "delete from popedom_info where popedomcode='" . $_POST["popedomcode"] . "'";
		$this->db->query( $sql );
			
		return true;
			
	}
	
	
	/**
	* 得到當(dāng)前數(shù)據(jù)庫中的一個新的權(quán)限編碼
	* @return	string	新的權(quán)限編碼
	*/
	
	function getNewPopedomCode ()
	{
		if( "homology" != $_POST["level"] )
		{
			$level = "__";
		}
		
		$sql = "select max(popedomcode) as popedomcode from popedom_info where popedomcode like '";
		$sql .= $_POST["popedomcode"] . $level . "'";
		
		$this->db->query( $sql );
		$this->db->next_record();
		
		//當(dāng)前是新層
		if( empty( $this->db->Record["popedomcode"] ) )
		{
			if( empty( $_POST["popedomcode"] ) )
			{
				return "10";
			}
			else{
				return $_POST["popedomcode"] . "00";
			}
		}
		
		$l_code = substr( $this->db->Record["popedomcode"], 0, strlen( $this->db->Record["popedomcode"] ) - 2 );
		$r_code = substr( $this->db->Record["popedomcode"], strlen( $this->db->Record["popedomcode"] ) - 2, 2 );
		
		if( 99 == intval( $r_code ) )
		{
			return "0";
		}
		
		$r_code = strval( intval( $r_code ) + 1 );
		
		if( strlen( $r_code ) < 2 )
		{
			$r_code = "0" . $r_code;
		}
		
		return $l_code . $r_code;
		
	}
	
	
	/**
	* 得到權(quán)限組菜單列表
	* @return	string	權(quán)限組菜單
	*/
	
	function getPopedomSelectList ()
	{
		$sql = "select * from popedom_info order by popedomcode asc";
		$this->db->query( $sql );
		
		$sl;
		while( $this->db->next_record() )
		{
			$sl .= "<option value=\"" . $this->db->Record["popedomcode"] . "\">";
			$sl .= $this->getIndent ( $this->db->Record["popedomcode"] );
			$sl .= $this->db->Record["popedomname"] . "</option>\n";
		}
		
		return $sl;
		
	}
	
	
	/**
	* 得到縮進長度
	* @return	string	縮進長度的空格
	*/
	
	function getIndent ( $popedomcode )
	{
		$s;
		$i = ( strlen( $popedomcode ) - 2 ) / 2;
			for( $j = 0; $j < $i; $j++ ){
				$s .= "&nbsp;&nbsp;";
			}
		return $s . "├-";
		
	}
	
	
	/**
	* 獲取一個結(jié)果集
	* @param	$table_name	表名
	* @param	$flag_name	字段名
	* @param	$flag_value	字段值
	* @return	boolean		操作成功返回true
	*/
	
	function setResultSet( $table_name, $flag_name, $flag_value )
	{
		$sql = "select * from ". $table_name ." where ". $flag_name ." = '" . $flag_value . "'";

		$this->db->query( $sql );
		$this->db->next_record();
		$this->resultSet = $this->db->Record;
		
		return true;
	}
	
	
	/**
	* 獲取當(dāng)前結(jié)果集中某一字段的值
	* @param	$flag_name	字段名
	* @return	string		字段值
	*/
	
	function getResultSetValue ( $field_name )
	{
		return $this->resultSet[$field_name];
	}
	
	
	/**
	* 設(shè)置數(shù)據(jù)庫句柄
	* @return	boolean	操作成功返回true
	*/
	
	function setDB ( $DB )
	{
		$this->db = $DB;
		
		return true;
	}
}

?>