Copro_key Class Reference

Collaboration diagram for Copro_key:

Public Member Functions
	verify ($p_array, $b_dupl=true)
	insert ($p_array)
	update ($p_array)
	load ()
	get_detail ()

Detailed Description

Definition at line 29 of file class_copro_key.php.

Member Function Documentation

Copro_key::get_detail

(

)

Definition at line 110 of file class_copro_key.php.

References $array, and $cn.

        {
            global $cn;
            $array=$cn->get_array("select * from coprop.clef_repartition_detail
                where cr_id=$1",array($this->cr_id));
            return $array;
        }

Copro_key::insert

(

$p_array

)

Definition at line 46 of file class_copro_key.php.

References $cn, and verify().

    {
        global $cn;
        extract($p_array);
        try
        {
                    $this->verify($p_array);
            $cn->start();
            $this->cr_id = $cn->get_value("insert into coprop.clef_repartition(cr_note,cr_name,cr_tantieme)
                values($1,$2,$3) returning cr_id", array( strip_tags($cr_note), strip_tags($cr_name),$cr_tantieme));
            for ($i = 0; $i < count($f_id); $i++)
            {
                if (${"part" . $f_id[$i]} == '')
                    ${"part" . $f_id[$i]} = 0;
                $cn->exec_sql("insert into coprop.clef_repartition_detail(lot_fk,crd_amount,cr_id) values($1,$2,$3)", array($f_id[$i], ${"part" . $f_id[$i]}, $this->cr_id));
            }
            $cn->commit();
        }
        catch (Exception $exc)
        {
            $cn->rollback();
            echo $exc->getTraceAsString();
        }
    }

Copro_key::load

(

)

Definition at line 98 of file class_copro_key.php.

References $array, and $cn.

        {
            global $cn;
            $array=$cn->get_array("select * from coprop.clef_repartition where
                cr_id=$1",array($this->cr_id));
            if ( $cn->count() == 1 )
            {
                foreach ( array("cr_id","cr_name","cr_note","cr_tantieme") as $k=>$e) {
                    $this->$e=$array[0][$e];
                }
            }
        }

Copro_key::update

(

$p_array

)

Definition at line 71 of file class_copro_key.php.

References $cn, and verify().

    {
        global $cn;
        extract($p_array);
        try
        {
                    $this->verify($p_array,false);
            $cn->start();
            $cn->exec_sql("update coprop.clef_repartition set
                cr_note=$1,cr_name=$2,cr_tantieme=$3
                where cr_id=$4",
                    array( strip_tags($cr_note), strip_tags($cr_name),$cr_tantieme,$this->cr_id));
            $cn->exec_sql("delete from coprop.clef_repartition_detail where cr_id=$1",array($this->cr_id));
            for ($i = 0; $i < count($f_id); $i++)
            {
                if (${"part" . $f_id[$i]} == '')
                    ${"part" . $f_id[$i]} = 0;
                $cn->exec_sql("insert into coprop.clef_repartition_detail(lot_fk,crd_amount,cr_id) values($1,$2,$3)", array($f_id[$i], ${"part" . $f_id[$i]}, $this->cr_id));
            }
            $cn->commit();
        }
        catch (Exception $exc)
        {
            $cn->rollback();
            echo $exc->getTraceAsString();
        }
    }

Copro_key::verify	(		$p_array,
			$b_dupl = true
	)

Definition at line 31 of file class_copro_key.php.

References $cn.

Referenced by insert(), and update().

    {
        global $cn;
        extract ($p_array);
        if (strlen(trim ($cr_name))==0)
            throw new Exception("Le nom est vide");
        if ($b_dupl )
        {
            $dupl=$cn->count_sql("select * from coprop.clef_repartition where cr_name=$1",array($cr_name));
            if ( $dupl >0 )
                throw new Exception("Une clef avec ce nom existe déja");
        }

    }

---

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

• coprop/include/class_copro_key.php