1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78
| $fk_ecriture_rubrique_id, $fk_user_id_creat, $fk_association_id, $fk_compte_id)
{
// Appel de l'objet bdd
global $bdd;
// Initialisation des variables
$sql_insert_ecriture = '';
$bool_insert_ecriture = FALSE;
// On prépare la requête
$sql_insert_ecriture = $bdd->prepare('
INSERT INTO
dat_ecriture
(
ecriture_numero,
ecriture_libelle,
ecriture_montant,
ecriture_date,
ecriture_type,
ecriture_rapproche,
ecriture_num_cheque,
ecriture_dt_creation,
fk_paiement_type_id,
fk_ecriture_rubrique_id,
fk_user_id_creat,
fk_association_id,
fk_compte_id
)
VALUES
(
:ecriture_numero,
:ecriture_libelle,
:ecriture_montant,
:ecriture_date,
:ecriture_type,
:ecriture_rapproche,
:ecriture_num_cheque,
NOW(),
:fk_paiement_type_id,
:fk_ecriture_rubrique_id,
:fk_user_id_creat,
:fk_association_id,
:fk_compte_id
)
');
// On execute la requête
try
{
$sql_insert_ecriture->execute(array(
'ecriture_numero' => $new_ecriture_numero,
'ecriture_libelle' => $new_ecriture_libelle,
'ecriture_montant' => $new_ecriture_montant,
'ecriture_date' => $new_ecriture_date,
'ecriture_type' => $new_ecriture_type,
'ecriture_rapproche' => $new_ecriture_rapproche,
'ecriture_num_cheque' => $new_ecriture_num_cheque,
'fk_paiement_type_id' => $fk_paiement_type_id,
'fk_ecriture_rubrique_id' => $fk_ecriture_rubrique_id,
'fk_user_id_creat' => $fk_user_id_creat,
'fk_association_id' => $fk_association_id,
'fk_compte_id' => $fk_compte_id
));
$_SESSION['nb_requete']++;
// echo "OK<br />";
$bool_insert_ecriture = TRUE;
}
catch (Exception $e)
{
//echo "KO - 1<br />";
fn_insert_log_error($e->getMessage(), "fn_insert_ecriture", $_SESSION['user_id']);
//echo "KO - 2<br />";
}
// On renvoi le résultat
return $bool_insert_ecriture;
} |
Partager