1 2 3 4 5
| $WhereIn = ' WHERE id_paiement IN (' . implode(", ", array_map('intval', $_POST['preleve'])) . ')';
$req_edit_paiements = 'UPDATE paiements SET etat_paiements = 1' . $WhereIn;
$req_creer_bordereaux = 'INSERT INTO bordereaux (numero_bordereaux, date_debut_bordereaux, date_fin_bordereaux, date_bordereaux, date_paiement_bordereaux, montant_paiement_bordereaux, type_bordereaux, id_paiements_bordereaux, id_facture_bordereaux, id_adh_bordereaux) SELECT "'.$numero1.'", STR_TO_DATE("'.$date_debut_bordereaux.'","%d/%m/%Y"), STR_TO_DATE("'.$date_fin_bordereaux.'","%d/%m/%Y"), "'.$date_auj.'", date_paiements, montant_paiements, "'.$type_paiements.'", "'.$num_preleve.'", id_facture_paiements, id_adherent_paiements FROM paiements' . $WhereIn; |
Partager