Anc_Key_Detail_SQL Class Reference

manage table key_distribution_detail More...

Inheritance diagram for Anc_Key_Detail_SQL:

Collaboration diagram for Anc_Key_Detail_SQL:

Public Member Functions
	__construct (&$p_cn, $p_id=-1)
Public Member Functions inherited from Table_Data_SQL
	__construct ($p_cn, $p_id=-1)
	build_query ()
	Build the SQL select statement for querying the object and returns it. More...
	column_update ($column_expr, $value)
	update the value of a column with an expression for $value for the current record More...
	count ($p_where="", $p_array=null)
	return the number of count in the table corresponding to the where condition More...
	delete ()
	exist ()
	Count the number of record with the id ,. More...
	get_all_to_array ($p_key_col, $p_cond="", $p_array=NULL)
	Get all the row and use the p_key_code are the key value of array. More...
	insert ()
	load ()
	Load the current row return false if not found. More...
	seek ($cond='', $p_array=null)
	retrieve array of object thanks a condition More...
	update ()
Public Member Functions inherited from Data_SQL
	__construct (DatabaseCore $p_cn, $p_id=-1)
	__toString ()
	collect_objects ($cond='', $p_array=null)
	return an array of objects. More...
	count ($p_where="", $p_array=null)
	delete ()
	exist ()
	Count the number of record with the id ,. More...
	from_array ($p_array)
	Transform an array into object. More...
	get ($p_string)
	get the value thanks the colum name and not the alias (name). More...
	get_cn ()
	get_info ()
	get_name ()
	get_object ($p_ret, $idx)
	get_pk_value ()
	get_primary_key ()
	get_type ()
	getp ($p_string)
	set the value thanks the alias name instead of the colum name More...
	insert ()
	load ()
	Load the current row return false if not found. More...
	next ($ret, $i)
	get_seek return the next object, the return of the query must have all the column of the object More...
	save ()
	Insert or update : if the row already exists, update otherwise insert. More...
	seek ($cond='', $p_array=null)
	retrieve array of object thanks a condition More...
	set ($p_string, $p_value)
	set the value thanks the colum name and not the alias (name) More...
	set_cn ($cn)
	set_name ($name)
	set_pk_value ($p_value)
	set_primary_key ($primary_key)
	set_type ($type)
	setp ($p_string, $p_value)
	set the value thanks the alias name instead of the colum name More...
	to_array ($prefix="")
	Turn an object (row) into an array, and the key could be prefixed with $prefix. More...
	to_row ($p_array)
	turns a row fetched from the DB into a SQL object in updating all his attribute More...
	update ()
	verify ()

Additional Inherited Members
Data Fields inherited from Data_SQL
	$cn
	$date_format
	Type of the data. More...
	$default
	defaullt date format More...
	$name
	Database connection. More...
	$primary_key
	Array of logical and real name. More...
	$table
	$type
	Column name of the primary key. More...

Detailed Description

manage table key_distribution_detail

Definition at line 95 of file anc_key_sql.class.php.

Constructor & Destructor Documentation

__construct()

Anc_Key_Detail_SQL::__construct	(	&	$p_cn,
			$p_id = -1
	)

Definition at line 97 of file anc_key_sql.class.php.

    {
          
        $this->table = "public.key_distribution_detail";
        $this->primary_key = "ke_id";
 
        $this->name = array(
            "id" => "ke_id",
            "key"=>"kd_id",
            "row"=>"ke_row",
            "percent"=>"ke_percent"
        );
 
        $this->type = array(
            "ke_id" => "numeric",
            "kd_id" => "numeric",
            "ke_row" => "numeric",
            "ke_percent" => "numeric"
        );
 
        $this->default = array(
            "ke_id" => "auto"
        );
       // PHPUNIT seems to have a problem with this line
       //global $cn;
       
 
        parent::__construct($p_cn, $p_id);
    } 

References $p_id, name, table, and type.

---

The documentation for this class was generated from the following file:

• include/database/anc_key_sql.class.php