/**
Cette fonction modifie un élément de la table facture dans la BDD.
*/
function UPD()
{
$id_facture = is_numeric($this->id_facture) ? $this->id_facture : 0;
$id_pere = is_numeric($this->id_pere) ? $this->id_pere : 0;
$type_pere = $this->type_pere;
$montant_ttc = strtr($this->montant_ttc, ",", ".");
$etat = $this->etat;
$date_facture = Lib_frToEn($this->date_facture);
$num_facture = $this->num_facture;
$message = Lib_prepareTexteStockage($this->message);
$produit = Lib_prepareTexteStockage($this->produit);
$id_mode_reglement = is_numeric($this->id_mode_reglement) ? $this->id_mode_reglement : 0;
$id_delai_reglement = is_numeric($this->id_delai_reglement) ? $this->id_delai_reglement : 0;
$code_client = $this->code_client;
$nom_fact = Lib_prepareTexteStockage($this->nom_fact);
$ligne1_fact = Lib_prepareTexteStockage($this->ligne1_fact);
$ligne2_fact = Lib_prepareTexteStockage($this->ligne2_fact);
$ligne3_fact = Lib_prepareTexteStockage($this->ligne3_fact);
$cp_fact = $this->cp_fact;
$ville_fact = Lib_prepareTexteStockage($this->ville_fact);
$tel1_fact = $this->tel1_fact;
$tel2_fact = $this->tel2_fact;
$fax_fact = $this->fax_fact;
$email_fact = $this->email_fact;
$date_upd = time();
$info_facture = $this->info_facture;
$sql = " UPDATE " . $GLOBALS['prefix'] . "factures\n\t\t\t\tSET id_pere = {$id_pere}, type_pere = '{$type_pere}', montant_ttc = '{$montant_ttc}', etat = '{$etat}', \n\t\t\t\t\tdate_facture = '{$date_facture}', num_facture = '{$num_facture}', message = '{$message}', \n\t\t\t\t\tproduit = '{$produit}', id_mode_reglement = {$id_mode_reglement}, id_delai_reglement = {$id_delai_reglement}, \n\t\t\t\t\tcode_client = '{$code_client}', nom_fact = '{$nom_fact}', ligne1_fact = '{$ligne1_fact}', \n\t\t\t\t\tligne2_fact = '{$ligne2_fact}', ligne3_fact = '{$ligne3_fact}', cp_fact = '{$cp_fact}', \n\t\t\t\t\tville_fact = '{$ville_fact}', tel1_fact = '{$tel1_fact}', tel2_fact = '{$tel2_fact}', \n\t\t\t\t\tfax_fact = '{$fax_fact}', email_fact = '{$email_fact}', date_upd = '{$date_upd}', \n\t\t\t\t\tinfo_facture = '{$info_facture}'\n\t\t\t\tWHERE id_facture = {$id_facture}";
if (!Db_execSql($sql)) {
$this->setError(ERROR);
}
if (!$this->isError()) {
Lib_sqlLog($sql);
}
return;
}
/**
Cette fonction modifie un élément de la table selection dans la BDD.
*/
function UPD()
{
$id_selection = is_numeric($this->id_selection) ? $this->id_selection : 0;
$position = is_numeric($this->position) ? $this->position : 0;
$id_facture = is_numeric($this->id_facture) ? $this->id_facture : 0;
$type_selection = $this->type_selection;
$designation = Lib_prepareTexteStockage($this->designation);
$description = Lib_prepareTexteStockage($this->description);
$pu_ht = strtr($this->pu_ht, ",", ".");
$remise = is_numeric($this->remise) ? $this->remise : 0;
$quantite = is_numeric($this->quantite) ? $this->quantite : 0;
$tva = strtr($this->tva, ",", ".");
$date_upd = time();
$info_selection = $this->info_selection;
$sql = " UPDATE " . $GLOBALS['prefix'] . "facture_selections\n\t\t\t\tSET position = {$position}, id_facture = {$id_facture}, type_selection = '{$type_selection}', \n\t\t\t\t\tdesignation = '{$designation}', description = '{$description}', pu_ht = '{$pu_ht}', \n\t\t\t\t\tremise = '{$remise}', quantite = {$quantite}, tva = '{$tva}', \n\t\t\t\t\tdate_upd = '{$date_upd}', info_selection = '{$info_selection}'\n\t\t\t\tWHERE id_selection = {$id_selection}";
if (!Db_execSql($sql)) {
$this->setError(ERROR);
}
if (!$this->isError()) {
Lib_sqlLog($sql);
}
return;
}
