1 2 3 4 5 6 7 8 9 10 11 12 13
|
if(isset($_POST['preleve']))
{
foreach($_POST['preleve'] as $num_preleve)
{
$req_edit_paiements = 'UPDATE paiements SET etat_paiements="1" WHERE id_paiements="'.$num_preleve.'"';
$res_edit_paiements = mysql_query($req_edit_paiements);
$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 WHERE id_paiements="'.$num_preleve.'"';
$res_creer_bordereaux = mysql_query($req_creer_bordereaux);
}
} |
Partager