Anc_Plan Class Reference

Concerns the Analytic plan (table plan_analytique) More...

Collaboration diagram for Anc_Plan:

Public Member Functions
	__construct ($p_cn, $p_id=0)
	add ()
	count ()
	delete ()
	exist ()
	form ()
	form_new ()
	add a new plan
	get ()
	get_list ($p_order=" order by pa_name")
	get the list of all existing PA
	header ()
	show the header for a table for PA
	isAppend ()
	update ()

Static Public Member Functions
static	hidden ($p_array)
	return an HTML string containing hidden input type to hold the differant PA_ID
static	test_me ()

Data Fields
	$db
	$description
	$id
	$name

Detailed Description

Concerns the Analytic plan (table plan_analytique)

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

Constructor & Destructor Documentation

__construct()

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

Definition at line 39 of file anc_plan.class.php.

    {
        $this->db=$p_cn;
        $this->id=$p_id;
        $this->name="";
        $this->description="";
        $this->get();
    }

References $p_id, db, and name.

Member Function Documentation

add()

Anc_Plan::add

(

)

Definition at line 96 of file anc_plan.class.php.

    {
        $name=sql_string($this->name);
        if ( strlen($name) == 0)
            return;
        if ( $this->isAppend() == false) return;
        $description=sql_string($this->description);
        $this->db->exec_sql("insert into plan_analytique(pa_name,pa_description)".
                            " values ($1,$2 )"
                            ,array($name,$description));
        $this->id=$this->db->get_current_seq('plan_analytique_pa_id_seq');
 
    }

References $description, $name, db, isAppend(), name, and sql_string().

Here is the call graph for this function:

count()

Anc_Plan::count

(

)

Definition at line 180 of file anc_plan.class.php.

    {
        $a=$this->db->count_sql("select pa_id from plan_analytique");
        return $a;
    }

References $a, and db.

Referenced by hidden().

delete()

Anc_Plan::delete

(

)

Definition at line 78 of file anc_plan.class.php.

    {
        if ( $this->id == 0 ) return;
        $this->db->exec_sql("delete from plan_analytique where pa_id=$1",array($this->id));
    }

References db.

exist()

Anc_Plan::exist

(

)

Definition at line 185 of file anc_plan.class.php.

    {
        $a=$this->db->count_sql("select pa_id from plan_analytique where pa_id=$1",
                                array($this->id));
 
        return ($a==0)?false:true;
 
    }

References $a, and db.

form()

Anc_Plan::form

(

)

Definition at line 109 of file anc_plan.class.php.

    {
        $dossier_id=Dossier::id();
        $wName=new IText('pa_name',$this->name,"pa_name");
        $iName=new Inplace_Edit($wName);
        $iName->set_callback("ajax_misc.php");
        $iName->add_json_param("gDossier",$dossier_id);
        $iName->add_json_param("action","anc_updatedescription");
        $iName->add_json_param("op","anc_updatedescription");
        $iName->add_json_param("id",$this->id);
 
 
        $wDescription=new IText('pa_description',$this->description,"pa_description");
        $wDescription->size=50;
        if ( $this->description == "") $wDescription->value=_("Aucune description");
        $iDescription=new Inplace_Edit($wDescription);
        $iDescription->add_json_param("gDossier",$dossier_id);
        $iDescription->add_json_param("op","anc_updatedescription");
        $iDescription->add_json_param("action","anc_updatedescription");
        $iDescription->set_callback("ajax_misc.php");
        $iDescription->add_json_param("id",$this->id);
        
 
        $wId=new IHidden("pa_id",$this->id);
        $ret="<TABLE>";
        $ret.='<tr>'.td(_('Nom')).'<td>'.$iName->input().'</td>'.'</tr>';
        $ret.="<tr>".td(_('Description')).'<td>'.$iDescription->input().'</td>'."</tr>";
        $ret.="</table>";
        $ret.=$wId->input();
        return $ret;
    }

References $dossier_id, $ret, _, and name.

form_new()

Anc_Plan::form_new

(

)

add a new plan

Definition at line 143 of file anc_plan.class.php.

    {
        $wName=new IText("pa_name");
        $wDescription=new IText("pa_description");
        $wDescription->size=80;
        
        $ret="<TABLE>";
        $ret.='<tr>'.td(_('Nom')).'<td>'.$wName->input().'</td>'.'</tr>';
        $ret.="<tr>".td(_('Description')).'<td>'.$wDescription->input().'</td>'."</tr>";
        $ret.="</table>";
        return $ret;
 
        
    }

References $ret, and _.

get()

Anc_Plan::get

(

)

Definition at line 62 of file anc_plan.class.php.

    {
        if ( $this->id==0) return;
 
        $sql="select pa_name,pa_description from plan_analytique where pa_id=$1";
        $ret= $this->db->exec_sql($sql,array($this->id));
        if ( Database::num_row($ret) == 0)
        {
            return;
        }
        $a=  Database::fetch_array($ret,0);
        $this->name=$a['pa_name'];
        $this->description=$a['pa_description'];
 
    }

References $a, $ret, $sql, db, DatabaseCore\fetch_array(), name, and DatabaseCore\num_row().

Here is the call graph for this function:

get_list()

Anc_Plan::get_list

(

$p_order = " order by pa_name"

)

get the list of all existing PA

Returns

an array of PA (not object)

Definition at line 51 of file anc_plan.class.php.

    {
        $array=array();
        $sql="select pa_id as id,pa_name as name,".
             "pa_description as description from plan_analytique $p_order";
        $ret=$this->db->exec_sql($sql);
        $array=Database::fetch_all($ret);
        if ($array == FALSE )            return array();
        return $array;
    }

References $array, $p_order, $ret, $sql, db, and DatabaseCore\fetch_all().

Referenced by header().

Here is the call graph for this function:

header()

Anc_Plan::header

(

)

show the header for a table for PA

Returns

string like

name...

Definition at line 169 of file anc_plan.class.php.

    {
        $res="";
        $a_plan=$this->get_list(" order by pa_id");
        if ( empty($a_plan)) return "";
        foreach ($a_plan as $r_plan)
        {
            $res.="<th>".h($r_plan['name'])."</th>";
        }
        return $res;
    }

References $a_plan, $res, and get_list().

Here is the call graph for this function:

hidden()

static Anc_Plan::hidden ( $p_array )

static

return an HTML string containing hidden input type to hold the differant PA_ID

Parameters

$p_array

array contains a array, it is the result of the fct Anc_Plan\get_list

Returns

html string

See also

Anc_Plan\get_list

Definition at line 201 of file anc_plan.class.php.

    {
        $r='';
        for ($i_anc=0;$i_anc <count($p_array);$i_anc++)
        {
            $r.=HtmlInput::hidden('pa_id[]',$p_array[$i_anc]['id']);
        }
        return $r;
    }

References $p_array, $r, and count().

Referenced by Acc_Ledger\confirm(), Acc_Ledger_Fin\confirm(), Acc_Ledger_Purchase\confirm(), and Acc_Ledger_Sale\confirm().

Here is the call graph for this function:

isAppend()

Anc_Plan::isAppend

(

)

Definition at line 157 of file anc_plan.class.php.

    {
        $count=$this->db->get_value("select count(pa_id) from plan_analytique");
 
        if ( $count > 10 )
            return false;
        else
            return true;
    }

References $count, and db.

Referenced by add().

test_me()

static Anc_Plan::test_me ( )

static

Definition at line 210 of file anc_plan.class.php.

    {
        $cn=Dossier::connect();
        echo "<h1>Plan analytique : test</h1>";
        echo "clean";
        $cn->exec_sql("delete from plan_analytique");
 
        $p=new Anc_Plan($cn);
        echo "<h2>Add</h2>";
        $p->name="Nouveau 1";
        $p->description="C'est un test";
        echo "Add<hr>";
        $p->add();
        $p->name="Nouveau 2";
        $p->add();
        $pa_id=$p->id;
        echo $p->id."/";
        $p->name="Nouveau 3";
        $p->add();
        echo $p->id."/";
 
 
        $p->name="Nouveau 4";
        $p->add();
        echo $p->id;
 
        echo "<h2>get</h2>";
        $p->get();
        var_dump($p);
        echo "<h2>Update</h2> ";
        $p->name="Update ";
        $p->description="c'est change";
        $p->update();
        $p->get();
        var_dump($p);
        echo "<h2>get_list</h2>";
        $a=$p->get_list();
        var_dump($a);
        echo "<h2>delete </h2>";
        $p->delete();
 
 
    }

References $a, $cn, $p, and $pa_id.

update()

Anc_Plan::update

(

)

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

    {
        if ( $this->id==0) return;
        $name=sql_string($this->name);
        if ( strlen($name) == 0)
            return;
 
        $description=sql_string($this->description);
        $this->db->exec_sql("update plan_analytique set pa_name=$1,
                            pa_description=$2 where pa_id=$3",array($name,$description,$this->id));
    }

References $description, $name, db, name, and sql_string().

Here is the call graph for this function:

Field Documentation

$db

Anc_Plan::$db

database connection

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

$description

Anc_Plan::$description

description of the PA plan_analytique.pa_description

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

Referenced by add(), and update().

$id

Anc_Plan::$id

id = plan_analytique.pa_id

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

$name

Anc_Plan::$name

name plan_analytique.pa_name

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

Referenced by add(), and update().

---

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

• include/class/anc_plan.class.php