Citation:
<?php
//ajout des cotisations dans le tableau
$date_deb = $an_deb.'-'.$mois_deb.'-'.$jour_deb;
$date_fin = $an_fin.'-'.$mois_fin.'-'.$jour_fin;
$debut = inverse($an_deb.'-'.$mois_deb.'-'.$jour_deb);
$fin = inverse($an_fin.'-'.$mois_fin.'-'.$jour_fin);
//recuperation des paiement
$query = "SELECT id_type_paiement, id_cotisation, prix, banque, cheque, tireur, commentaire, date, heure
FROM paiement
WHERE date BETWEEN '".$date_deb."' AND '".$date_fin."'";
$result = requete_prin($query);
while($data = mysql_fetch_array($result)){
$id_type_paiement = $data['id_type_paiement'];
$id_cotisation = $data['id_cotisation'];
$prix = $data['prix'];
$banque = $data['banque'];
$cheque = $data['cheque'];
$commentaire = $data['commentaire'];
$date = $data['date'];
$heure = $data['heure'];
$tireur = $data['tireur'];
//recuperation de l'année de la cotisation et de l'id_client
$query2 = "SELECT id_client, annee
FROM cotisation
WHERE id_cotisation = '".$id_cotisation."'";
$result2 = requete_prin($query2);
while($data2 = mysql_fetch_array($result2)){
$id_client = $data2['id_client'];
$annee = $data2['annee'];
}//fin du while($data2 = mysql_fetch_array($result2))
//recuperation des informations sur le client
$query3 = "SELECT nom, prenom, id_collectivite
FROM client
WHERE id_client = '".$id_client."'";
$result3 = requete_prin($query3);
while($data3 = mysql_fetch_array($result3)){
$nom_client = $data3['nom'];
$prenom_client = $data3['prenom'];
$collectivite = $data3['id_collectivite'];
}//fin du while($data3 = mysql_fetch_array($result3))
if($collectivite == 1){
$statut = 'Collectivite';
}
else{
$statut = 'Particulier';
}
//recuperation du type de paiement
$query4 = "SELECT nom
FROM type_paiement
WHERE id_type_paiement = '".$id_type_paiement."'";
$result4 = requete_prin($query4);
while($data4 = mysql_fetch_array($result4)){
$type_paiement = $data4['nom'];
}//fin du while($data4 = mysql_fetch_array($result4))
//remplissage du tableau
$tableau[] .= array(
'date_paiement' => inverse($date).' '.$heure,
'date' => inverse($date),
'remise' => 'Cotisation',
'client' => $nom_client.' '.$prenom_client,
'statut' => $statut,
'prix' => number_format($prix,2),
'paiement' => $type_paiement,
'banque' => ucfirst(strtolower($banque)),
'cheque' => $cheque,
'tireur' => $tireur,
'dossier' => '',
'lieu' => '',
'dates' => $annee,
'commentaire' => $commentaire
);
}
//ajout des sejours dans le tableau
$date_deb = $an_deb.'-'.$mois_deb.'-'.$jour_deb;
$date_fin = $an_fin.'-'.$mois_fin.'-'.$jour_fin;
$debut = inverse($an_deb.'-'.$mois_deb.'-'.$jour_deb);
$fin = inverse($an_fin.'-'.$mois_fin.'-'.$jour_fin);
//recuperation des paiements
$query = "
SELECT
lrp.id_dossier, lrp.prix, lrp.banque, lrp.cheque, lrp.tireur, lrp.commentaire, lrp.date, lrp.heure, lrp.id_type_paiement,
lrh.date_deb, lrh.date_fin,
lrd.id_client,
ll.nom as nom_lieu,
lr.nom as nom_region
FROM loc_resa_paiement lrp, loc_resa_dossier lrd, loc_resa_hbgt lrh, loc_type lt, loc_lieu ll, loc_region lr
WHERE lrp.id_dossier = lrd.id_dossier
AND lrd.id_dossier = lrh.id_dossier
AND lrh.type_id = lt.id_type
AND lt.id_lieu = ll.id_lieu
AND ll.id_region = lr.id_region
AND lrp.date between '".$date_deb."' AND '".$date_fin."'";
$result = requete_second($query);
while($data = mysql_fetch_array($result)){
$z++;
$id_dossier = $data['id_dossier'];
$prix = $data['prix'];
$banque = $data['banque'];
$cheque = $data['cheque'];
$tireur = $data['tireur'];
$date_paiement = inverse($data['date']).' '.$data['heure'];
$date = inverse($data['date']);
$id_type_paiement = $data['id_type_paiement'];
$dates = 'Du '.date('d/m/Y',$data['date_deb']).' au '.date('d/m/Y',$data['date_fin']);
$id_client = $data['id_client'];
$lieu = stripslashes($data['nom_lieu'].' <i>'.$data['nom_region'].'</i>');
$commentaire = $data['commentaire'];
//recuperation des informations sur le client
$query = "SELECT nom, prenom, id_collectivite
FROM client
WHERE id_client = '".$id_client."'";
$result1 = requete_prin($query);
