Fiche_Attr Class Reference

Manage the table attr_def. More...

Inheritance diagram for Fiche_Attr:

Collaboration diagram for Fiche_Attr:

Public Member Functions
	__construct ($p_cn, $p_id=0)
	delete ()
	get_parameter ($p_string)
	save ()
	Insert or update : if the row already exists, update otherwise insert. More...
	set_parameter ($p_string, $p_value)
	to_array ($prefix="")
	Turn an object (row) into an array, and the key could be prefixed with $prefix. More...
	update ()
	verify ()
Public Member Functions inherited from Attr_def_SQL
	__construct (DatabaseCore $p_cn, $p_id=-1)
Public Member Functions inherited from Table_Data_SQL
	build_query ()
	Build the SQL select statement for querying the object and returns it. More...
	count ($p_where="", $p_array=null)
	return the number of count in the table corresponding to the where condition More...
	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 ()
	seek ($cond='', $p_array=null)
	retrieve array of object thanks a condition More...
Public Member Functions inherited from Data_SQL
	collect_objects ($cond='', $p_array=null)
	return an array of objects. 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...
	next ($ret, $i)
	get_seek return the next object, the return of the query must have all the column of the object 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...

Static Public Member Functions
static	sort_by_id ($o1, $o2)

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...
	$type
	Column name of the primary key. More...

Detailed Description

Manage the table attr_def.

Definition at line 13 of file fiche_attr.class.php.

Constructor & Destructor Documentation

__construct()

Fiche_Attr::__construct	(		$p_cn,
			$p_id = 0
	)

Reimplemented from Table_Data_SQL.

Definition at line 17 of file fiche_attr.class.php.

    {
        parent::__construct($p_cn, $p_id);
    }

References $p_id.

Member Function Documentation

delete()

Fiche_Attr::delete

(

)

Reimplemented from Table_Data_SQL.

Definition at line 107 of file fiche_attr.class.php.

    {
        if ($this->ad_id<9000)
            return;
        $sql=$this->cn->exec_sql("delete from fiche_detail  where ad_id=$1 ", array($this->ad_id));
 
        $sql="delete from jnt_fic_attr where ad_id=$1";
        $res=$this->cn->exec_sql($sql, array($this->ad_id));
 
        $sql="delete from attr_def where ad_id=$1";
        $res=$this->cn->exec_sql($sql, array($this->ad_id));
    }

References $res, $sql, and cn.

get_parameter()

Fiche_Attr::get_parameter

(

$p_string

)

Definition at line 22 of file fiche_attr.class.php.

    {
        return $this->getp($p_string);
    }

References Data_SQL\getp().

Here is the call graph for this function:

save()

Fiche_Attr::save

(

)

Insert or update : if the row already exists, update otherwise insert.

Reimplemented from Data_SQL.

Definition at line 133 of file fiche_attr.class.php.

    {
 
        /* please adapt */
        if ($this->ad_id < 1)
        {
            $this->ad_id=-1;
            $this->insert();
        }
        else
            $this->update();
    }

References Table_Data_SQL\insert(), and update().

Here is the call graph for this function:

set_parameter()

Fiche_Attr::set_parameter	(		$p_string,
			$p_value
	)

Definition at line 27 of file fiche_attr.class.php.

    {
        $this->setp($p_string, $p_value);
    }

References Data_SQL\setp().

Here is the call graph for this function:

sort_by_id()

static Fiche_Attr::sort_by_id (   $o1,   $o2  )

static

Definition at line 124 of file fiche_attr.class.php.

    {
        if ($o1->ad_id>$o2->ad_id)
            return 1;
        if ($o1->ad_id==$o2->ad_id)
            return 0;
        return -1;
    }

to_array()

Fiche_Attr::to_array

(

$prefix = ""

)

Turn an object (row) into an array, and the key could be prefixed with $prefix.

Parameters

string

$prefix

before the key

Returns

array

Reimplemented from Data_SQL.

Definition at line 145 of file fiche_attr.class.php.

    {
        
        $array=array();
        foreach ($this->name as $key=> $value)
        {
            $nkey=$prefix.$value;
            $array[$nkey]=$this->$value;
//            $nkey=$prefix.$key;
//            $array[$nkey]=$this->$value;
//            
        }
        tracedebug("card_attribute.log",$array);
        return $array;
    }

References $array, $prefix, $value, and name.

update()

Fiche_Attr::update

(

)

Reimplemented from Table_Data_SQL.

Definition at line 90 of file fiche_attr.class.php.

    {
        try
        {
            $this->verify();
            if ($this->ad_id<9000)
                return;
            /*   please adapt */
            parent::update();
        }
        catch (Exception $e)
        {
            record_log($e);
            throw $e;
        }
    }

References $e, record_log(), and verify().

Referenced by save().

Here is the call graph for this function:

verify()

Fiche_Attr::verify

(

)

Todo:

ajout vérification type (date, text ou numeric)

Returns

int

Reimplemented from Data_SQL.

Definition at line 32 of file fiche_attr.class.php.

    {
        // Verify that the elt we want to add is correct
        /* verify only the datatype */
        if (strlen(trim($this->ad_text))==0)
            throw new Exception('La description ne peut pas être vide', 1);
        if (strlen(trim($this->ad_type))==0)
            throw new Exception('Le type ne peut pas être vide', 1);
        $this->ad_type=strtolower($this->ad_type);
        if (in_array($this->ad_type, array('date', 'text', 'numeric', 'zone', 'poste', 'card', 'select','check'))==false)
            throw new Exception('Le type doit être text, numeric,poste, card, select ou date', 1);
        if (trim($this->ad_size)==''||isNumber($this->ad_size)==0||$this->ad_size>22)
        {
            switch ($this->ad_type)
            {
                case 'text':
                    $this->ad_size=22;
                    break;
                case 'numeric':
                    $this->ad_size=9;
                    break;
                case 'date':
                    $this->ad_size=8;
                    break;
                case 'zone':
                    $this->ad_size=22;
                    break;
 
                default:
                    $this->ad_size=22;
            }
        }
        if ($this->ad_type=='numeric')
        {
            $this->ad_extra=(trim($this->ad_extra)=='')?'2':$this->ad_extra;
            if (isNumber($this->ad_extra)==0)
                throw new Exception("La précision doit être un chiffre");
        }
        if ($this->ad_type=='select')
        {
            if (trim($this->ad_extra)=="")
                throw new Exception("La requête SQL est vide ");
            if (preg_match('/^\h*select/i', $this->ad_extra)==0)
                throw new Exception("La requête SQL doit commencer par SELECT ");
            try
            {
 
                $this->cn->exec_sql($this->ad_extra);
            }
            catch (Exception $e)
            {
                record_log($e);
                throw new Exception("La requête SQL ".h($this->ad_extra)." est invalide ");
            }
        }
    }

References $e, cn, h, isNumber(), and record_log().

Referenced by update().

Here is the call graph for this function:

---

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

• include/class/fiche_attr.class.php