Acc_Plan_SQL Class Reference

this class is above tmp_pcmn_sql and is a view of tmp_pcmn More...

Inheritance diagram for Acc_Plan_SQL:

Collaboration diagram for Acc_Plan_SQL:

Public Member Functions
	__construct ($p_cn, $p_id=-1)
	count ($p_where="", $p_array=null)
	delete ()
	exist ()
	Count the number of record with the id ,.
	get_limit_fiche_qcode ()
	get_pk_value ()
	insert ()
	load ()
	Load the current row return false if not found.
	seek ($cond='', $p_array=null)
	retrieve array of object thanks a condition
	set_limit_fiche_qcode ($limit_fiche_qcode)
	update ()
Public Member Functions inherited from Data_SQL
	__construct (DatabaseCore $p_cn, $p_id=-1)
	__get ($cols)
	__set ($cols, $p_value)
	__toString ()
	collect_objects ($cond='', $p_array=null)
	return an array of objects.
	from_array ($p_array)
	Transform an array into object.
	get ($cols)
	get the value thanks the colum name and not the alias (name).
	get_a_virtual_col ()
	return array of virtual cols (alias calculated, formatted cols)
	get_cn ()
	get_info ()
	get_name ()
	get_object ($p_ret, $idx)
	get_primary_key ()
	get_type ()
	getp ($cols)
	set the value thanks the alias name instead of the colum name if not found try the column name
	next ($ret, $i)
	get_seek return the next object, the return of the query must have all the column of the object including the virtual columns
	save ()
	Insert or update : if the row already exists, update otherwise insert.
	set ($cols, $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)
	set_virtual_col ($col_name, $sql_expression)
	add a virtual column (formatted column, sum of 2 col, ...)
	setp ($cols, $p_value)
	set the value thanks the alias name instead of the colum name, if not found try the column name
	to_array ($prefix="")
	Turn an object (row) into an array, and the key could be prefixed with $prefix.
	to_row ($p_array)
	update the data member of current object with the value from the array.
	verify ()

Data Fields
	$sql
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.

Private Attributes
	$limit_fiche_qcode

Additional Inherited Members
Protected Attributes inherited from Data_SQL
	$a_virtual_col

Detailed Description

this class is above tmp_pcmn_sql and is a view of tmp_pcmn

See also

Tmp_Pcmn_SQL

Acc_Plan_MTable

Examples

test_manage_table_sql.php.

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

Constructor & Destructor Documentation

__construct()

Acc_Plan_SQL::__construct	(		$p_cn,
			$p_id = -1 )

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

    {
        $this->table = "accounting_card";
        $this->primary_key = "id";
        $this->limit_fiche_qcode=0;
        $this->name = array(
            "id" => "id",
            "pcm_val"=>"pcm_val",
            "parent_accounting"=>"parent_accounting",
            "pcm_lib"=>"pcm_lib",
            "pcm_type"=>"pcm_type",
            "fiche_qcode"=>"fiche_qcode",
            "pcm_direct_use"=>"pcm_direct_use"
        );
 
        $this->type = array(
            "id" => "numeric",
            "pcm_val" => "text",
            "parent_accounting" => "text",
            "pcm_lib" => "text",
            "pcm_type" => "text",
            "fiche_qcode"=>"string",
            "pcm_direct_use"=>"text"
        );
 
        $this->default = array(
            "id" => "auto",
            "fiche_qcode"=>"auto"
        );
        $this->sql="
      SELECT pcm_val,
      pcm_lib, 
      pcm_val_parent as parent_accounting, 
      pcm_type, 
      id,
      pcm_direct_use,
        (select string_agg(m.fiche_qcode,' , ') 
        from (select a.ad_value as fiche_qcode 
            from fiche_detail as a 
            join fiche_detail as b on (a.ad_id=23 and a.f_id=b.f_id and b.ad_id=5) 
            where b.ad_value=pcm_val::text order by a.ad_value %s)as m) as fiche_qcode
      FROM public.tmp_pcmn
            
";
        parent::__construct($p_cn,$p_id);
     }

References $p_id, name, table, and type.

Member Function Documentation

count()

Acc_Plan_SQL::count	(		$p_where = "",
			$p_array = null )

Reimplemented from Data_SQL.

Definition at line 84 of file acc_plan_sql.class.php.

    {
        throw new Exception("not implemented");
    }

References $p_array.

delete()

Acc_Plan_SQL::delete

(

)

Reimplemented from Data_SQL.

Definition at line 89 of file acc_plan_sql.class.php.

    {
        $obj=new Tmp_Pcmn_SQL($this->cn,$this->id);
        if ( $this->cn->get_value("select count(*) from jrnx where j_poste=$1",[$obj->pcm_val]) > 0)
        {
            throw new Exception(_("Impossible d'effacer : ce poste est utilisé"));
        }
        if ( $this->cn->get_value("select count(*) from tmp_pcmn where pcm_val_parent=$1",[$obj->pcm_val]) > 0)
        {
            throw new Exception(_("Impossible d'effacer : ce poste est utilisé"));
        }
        return $obj->delete();
        
    }

References $obj, _, and cn.

exist()

Acc_Plan_SQL::exist

(

)

Count the number of record with the id ,.

Returns

integer 0 doesn't exist , 1 exists

Reimplemented from Data_SQL.

Definition at line 104 of file acc_plan_sql.class.php.

    {
        $obj=new Tmp_Pcmn_SQL($this->cn,$this->id);
        return $obj->exist();
    }

References $obj, and cn.

get_limit_fiche_qcode()

Acc_Plan_SQL::get_limit_fiche_qcode

(

)

Definition at line 173 of file acc_plan_sql.class.php.

    {
        return $this->limit_fiche_qcode;
    }

References $limit_fiche_qcode.

Referenced by load(), and seek().

get_pk_value()

Acc_Plan_SQL::get_pk_value

(

)

Reimplemented from Data_SQL.

Definition at line 121 of file acc_plan_sql.class.php.

    {
        return $this->id;
    }

References $id.

insert()

Acc_Plan_SQL::insert

(

)

Reimplemented from Data_SQL.

Definition at line 110 of file acc_plan_sql.class.php.

    {
        $obj=new Tmp_Pcmn_SQL($this->cn);
        $obj->set("pcm_val",$this->pcm_val);
        $obj->set("pcm_lib",$this->pcm_lib);
        $obj->set("pcm_type",$this->pcm_type);
        $obj->set("pcm_val_parent",$this->parent_accounting);
        $obj->set("pcm_direct_use",$this->pcm_direct_use);
        $obj->insert();
        $this->id=$obj->id;
    }

References $obj, and cn.

load()

Acc_Plan_SQL::load

(

)

Load the current row return false if not found.

$pk=$this->primary_key;
if ( $this->get_limit_fiche_qcode() != 0 )
{
    $sql=sprintf($this->sql," limit ".$this->get_limit_fiche_qcode());
} else
{
    $sql=sprintf($this->sql,"  ");
}
$result=$this->cn->get_array($sql. " where id=$1",array ($this->$pk));
if ($this->cn->count()==0)
{
    $this->$pk=-1;
    return false;
}
 
foreach ($result[0] as $key=> $value)
{
    $this->$key=$value;
}
return true;

Returns

bool

Reimplemented from Data_SQL.

Definition at line 125 of file acc_plan_sql.class.php.

                          :bool
    {
        $pk=$this->primary_key;
        if ( $this->get_limit_fiche_qcode() != 0 ) 
        {
            $sql=sprintf($this->sql," limit ".$this->get_limit_fiche_qcode());
        } else
        {
            $sql=sprintf($this->sql,"  ");
        }
        $result=$this->cn->get_array($sql. " where id=$1",array ($this->$pk));
        if ($this->cn->count()==0)
        {
            $this->$pk=-1;
            return false;
        }
 
        foreach ($result[0] as $key=> $value)
        {
            $this->$key=$value;
        }
        return true;
    }

References Data_SQL\$primary_key, $result, $sql, $value, cn, and get_limit_fiche_qcode().

Here is the call graph for this function:

seek()

Acc_Plan_SQL::seek	(		$cond = '',
			$p_array = null )

retrieve array of object thanks a condition

Parameters

$cond	condition (where clause) (optional by default all the rows are fetched) you can use this parameter for the order or subselect
$p_array	array for the SQL stmt

See also

Database\exec_sql get_object Database\num_row

Returns

the return value of exec_sql

Reimplemented from Data_SQL.

Definition at line 149 of file acc_plan_sql.class.php.

    {
        if ( $this->get_limit_fiche_qcode() != 0 ) 
        {
            $sql=sprintf($this->sql," limit ".$this->get_limit_fiche_qcode());
        } else
        {
            $sql=sprintf($this->sql,"  ");
        }
        $ret=$this->cn->exec_sql($sql." ".$cond,$p_array);
        return $ret;
    }

References $p_array, $ret, $sql, cn, and get_limit_fiche_qcode().

Here is the call graph for this function:

set_limit_fiche_qcode()

Acc_Plan_SQL::set_limit_fiche_qcode

(

$limit_fiche_qcode

)

Definition at line 178 of file acc_plan_sql.class.php.

    {
        $this->limit_fiche_qcode=$limit_fiche_qcode;
    }

References $limit_fiche_qcode.

update()

Acc_Plan_SQL::update

(

)

Reimplemented from Data_SQL.

Definition at line 162 of file acc_plan_sql.class.php.

    {
       $obj=new Tmp_Pcmn_SQL($this->cn,$this->id);
       $obj->set("pcm_val",$this->pcm_val);
       $obj->set("pcm_lib",$this->pcm_lib);
       $obj->set("pcm_type",$this->pcm_type);
       $obj->set("pcm_val_parent",$this->parent_accounting);
       $obj->set("pcm_direct_use",$this->pcm_direct_use);
 
       $obj->update(); 
    }

References $obj, and cn.

Field Documentation

$limit_fiche_qcode

Acc_Plan_SQL::$limit_fiche_qcode

private

Definition at line 35 of file acc_plan_sql.class.php.

Referenced by get_limit_fiche_qcode(), and set_limit_fiche_qcode().

$sql

Acc_Plan_SQL::$sql

Definition at line 36 of file acc_plan_sql.class.php.

Referenced by load(), and seek().

---

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

• include/database/acc_plan_sql.class.php