Impacc_TVA Class Reference

Collaboration diagram for Impacc_TVA:

Public Member Functions
	display_list ()
	check_exist ($tva_id)
	The TVA ID must exist. More...
	check_valid ($tva_code, $pt_id)
	the TVA Code must be unique More...
	insert ($tva_id, $tva_code)
	update ($id, $tva_id, $tva_code)
	delete ($p_id)
	display_modify ($p_tva)
	display_add ()

Detailed Description

Definition at line 30 of file class_impacc_tva.php.

Member Function Documentation

Impacc_TVA::check_exist

(

$tva_id

)

The TVA ID must exist.

Definition at line 40 of file class_impacc_tva.php.

    {
        
    }

Impacc_TVA::check_valid	(		$tva_code,
			$pt_id
	)

the TVA Code must be unique

Definition at line 45 of file class_impacc_tva.php.

References $cn.

Referenced by insert(), and update().

    {
        $cn=Dossier::connect();
        $count=$cn->get_value(
                "select 
                    count(*) 
                 from 
                    impacc.parameter_tva 
                 where
                    pt_id <> $1
                    and tva_code=$2",
                    array($pt_id,$tva_code)
                );
        return $count;
    }

Impacc_TVA::delete

(

$p_id

)

Definition at line 82 of file class_impacc_tva.php.

References $cn.

    {
        $cn=Dossier::connect();
        $cn->exec_sql("delete from impacc.parameter_tva where pt_id=$1",array($p_id));
    }

Impacc_TVA::display_add

(

)

Definition at line 103 of file class_impacc_tva.php.

References $comment, $id, and $tva_id.

    {
        $tva_id=""; 
        $comment="";
        $tva_code="";
        $id=-1;
        $label="";
        // Display empty Box
        require_once DIR_IMPORT_ACCOUNT."/template/tva_parameter_detail.php";
    }

Impacc_TVA::display_list

(

)

Definition at line 32 of file class_impacc_tva.php.

References $cn, $ret, and $sql.

    {
        $cn=Dossier::connect();
        $sql="select * from impacc.parameter_tva left join public.tva_rate using(tva_id) order by tva_code";
        $ret=$cn->get_array($sql);
        require_once DIR_IMPORT_ACCOUNT."/template/tva_parameter_list.php";
    }

Impacc_TVA::display_modify

(

$p_tva

)

Definition at line 87 of file class_impacc_tva.php.

References $cn, $comment, $id, $ret, $sql, and $tva_id.

    {
        $cn=Dossier::connect();
        
        // Load parameter
        $sql="select * from impacc.parameter_tva left join public.tva_rate using(tva_id) where pt_id=$1";
        $ret=$cn->get_array($sql,array($p_tva));
        $tva_id=$ret[0]["tva_id"]; 
        $comment=h($ret[0]['tva_comment']);
        $tva_code=h($ret[0]['tva_code']);
        $id=$ret[0]['pt_id'];
        $label=$ret[0]['tva_label'];
        
        // Display Box
        require_once DIR_IMPORT_ACCOUNT."/template/tva_parameter_detail.php";
    }

Impacc_TVA::insert	(		$tva_id,
			$tva_code
	)

Definition at line 60 of file class_impacc_tva.php.

References $cn, $tva_id, and check_valid().

    {
        if ( $this->check_valid($tva_code,-1) > 0)
        {
            throw new Exception(_("Duplicate"));
        }
        $cn=Dossier::connect();
        
        $cn->exec_sql("insert into impacc.parameter_tva(tva_id,tva_code) 
                values ($1,$2)
                returning pt_id", array($tva_id,$tva_code));
    }

Impacc_TVA::update	(		$id,
			$tva_id,
			$tva_code
	)

Definition at line 72 of file class_impacc_tva.php.

References $cn, $id, $tva_id, and check_valid().

    {
        if ( $this->check_valid($tva_code,$id) > 0)
        {
            throw new Exception(_("Duplicate"));
        }
        $cn=Dossier::connect();
        $cn->exec_sql("update impacc.parameter_tva set tva_id=$1,tva_code=$2 where pt_id=$3",
                array($tva_id,$tva_code,$id));
    }

---

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

• import_account/include/class_impacc_tva.php