Action_Gestion_SQL Class Reference

ORM public.action_gestion. More...

Inheritance diagram for Action_Gestion_SQL:

Collaboration diagram for Action_Gestion_SQL:

Public Member Functions
	__construct (DatabaseCore $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.
	column_update ($column_expr, $value)
	update the value of a column with an expression for $value for the current record
	count ($p_where="", $p_array=null)
	return the number of count in the table corresponding to the where condition
	delete ()
	exist ()
	Count the number of record with the id ,.
	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.
	insert ()
	load ()
	Load the current row return false if not found.
	seek ($cond='', $p_array=null)
	retrieve array of object thanks a condition
	update ()
Public Member Functions inherited from Data_SQL
	__toString ()
	collect_objects ($cond='', $p_array=null)
	return an array of objects.
	from_array ($p_array)
	Transform an array into object.
	get ($p_string)
	get the value thanks the colum name and not the alias (name).
	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
	next ($ret, $i)
	get_seek return the next object, the return of the query must have all the column of the object
	save ()
	Insert or update : if the row already exists, update otherwise insert.
	set ($p_string, $p_value)
	set the value thanks the colum name and not the alias (name)
	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
	to_array ($prefix="")
	Turn an object (row) into an array, and the key could be prefixed with $prefix.
	to_row ($p_array)
	turns a row fetched from the DB into a SQL object in updating all his attribute
	verify ()

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

Detailed Description

ORM public.action_gestion.

Definition at line 34 of file action_gestion_sql.class.php.

Constructor & Destructor Documentation

__construct()

Action_Gestion_SQL::__construct	(	DatabaseCore	$p_cn,
			$p_id = -1 )

Reimplemented from Data_SQL.

Definition at line 37 of file action_gestion_sql.class.php.

    {
        $this->table="public.action_gestion";
        $this->primary_key="ag_id";
        /*
         * List of columns
         */
        $this->name=array(
            "ag_id"=>"ag_id"
            , "ag_type"=>"ag_type"
            , "f_id_dest"=>"f_id_dest"
            , "ag_title"=>"ag_title"
            , "ag_timestamp"=>"ag_timestamp"
            , "ag_ref"=>"ag_ref"
            , "ag_hour"=>"ag_hour"
            , "ag_priority"=>"ag_priority"
            , "ag_dest"=>"ag_dest"
            , "ag_owner"=>"ag_owner"
            , "ag_contact"=>"ag_contact"
            , "ag_state"=>"ag_state"
            , "ag_remind_date"=>"ag_remind_date"
        );
        /*
         * Type of columns
         */
        $this->type=array(
            "ag_id"=>"numeric"
            , "ag_type"=>"numeric"
            , "f_id_dest"=>"numeric"
            , "ag_title"=>"text"
            , "ag_timestamp"=>"timestamp without time zone"
            , "ag_ref"=>"text"
            , "ag_hour"=>"text"
            , "ag_priority"=>"numeric"
            , "ag_dest"=>"numeric"
            , "ag_owner"=>"text"
            , "ag_contact"=>"numeric"
            , "ag_state"=>"numeric"
            , "ag_remind_date"=>"date"
        );
 
 
        $this->default=array(
            "ag_id"=>"auto",
            "ag_timestamp"=>"auto"
        );
 
        $this->date_format="DD.MM.YYYY";
        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/action_gestion_sql.class.php