|
|
|
| ';
if($total_incorporelle!=0){
print'20 Imobilisations incorporelles : '.$total_incorporelle.' € '; $table=mysql_query("select * from incorporelle",$connection); $cpt_compte=mysql_num_rows($table); $fichiertxt_incorporelle=fopen("20.txt","r"); while(!feof($fichiertxt_incorporelle)){ $lecture=fgetc($fichiertxt_incorporelle); if($lecture!="/"){ $incorporelle=$incorporelle.$lecture; } else{ $cpt=0; $total_compte=0; while($cpt<$cpt_compte){ if(mysql_result($table,$cpt,Compte)==$incorporelle){ $total_compte+=mysql_result($table,$cpt,Montant); } $cpt++; } if($total_compte>0){ print $incorporelle." : ".$total_compte." € "; } $fin=fgetc($fichiertxt_incorporelle); $incorporelle=""; } } $fermeture_fichier=fclose($fichiertxt_incorporelle); } if($total_corporelle!=0){ print' 21 Imobilisations corporelles : '.$total_corporelle.' € '; $table=mysql_query("select * from corporelle",$connection); $cpt_compte=mysql_num_rows($table); $fichiertxt_corporelle=fopen("21.txt","r"); while(!feof($fichiertxt_corporelle)){ $lecture=fgetc($fichiertxt_corporelle); if($lecture!="/"){ $corporelle=$corporelle.$lecture; } else{ $cpt=0; $total_compte=0; while($cpt<$cpt_compte){ if(mysql_result($table,$cpt,Compte)==$corporelle){ $total_compte+=mysql_result($table,$cpt,Montant); } $cpt++; } if($total_compte>0){ print $corporelle." : ".$total_compte." € "; } $fin=fgetc($fichiertxt_corporelle); $corporelle=""; } } $fermeture_fichier=fclose($fichiertxt_corporelle); } if($fournisseur_debiteur!=0){ print' 40 Fournisseur débiteur : '.$fournisseur_debiteur.' € '; $table=mysql_query("select * from achat",$connection); $cpt_achat=mysql_num_rows($table); if($cpt_achat!=0){ $cpt=0; while($cpt<$cpt_achat){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="non" and mysql_result($table,$cpt,Exercice)=="actuel"){ print '401 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from service",$connection); $cpt_service=mysql_num_rows($table); if($cpt_service!=0){ $cpt=0; while($cpt<$cpt_service){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="non" and mysql_result($table,$cpt,Exercice)=="actuel"){ print '401 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from incorporelle",$connection); $cpt_incorporelle=mysql_num_rows($table); if($cpt_incorporelle!=0){ $cpt=0; while($cpt<$cpt_incorporelle){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="non" and mysql_result($table,$cpt,Exercice)=="actuel"){ print '404 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from corporelle",$connection); $cpt_corporelle=mysql_num_rows($table); if($cpt_corporelle!=0){ $cpt=0; while($cpt<$cpt_corporelle){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="non" and mysql_result($table,$cpt,Exercice)=="actuel"){ print '404 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from achat",$connection); $cpt_achat=mysql_num_rows($table); if($cpt_achat!=0){ $cpt=0; while($cpt<$cpt_achat){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="non" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '401 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from service",$connection); $cpt_service=mysql_num_rows($table); if($cpt_service!=0){ $cpt=0; while($cpt<$cpt_service){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="non" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '401 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from incorporelle",$connection); $cpt_incorporelle=mysql_num_rows($table); if($cpt_incorporelle!=0){ $cpt=0; while($cpt<$cpt_incorporelle){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="non" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '404 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from corporelle",$connection); $cpt_corporelle=mysql_num_rows($table); if($cpt_corporelle!=0){ $cpt=0; while($cpt<$cpt_corporelle){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="non" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '404 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } } if($adherent_debiteur!=0){ print' 41 Adhérent débiteur : '.$adherent_debiteur.' € '; $table=mysql_query("select * from adhesion",$connection); $cpt_adhesion=mysql_num_rows($table); $cpt=0; $cotisation=0; $montant_cotisation=0; while($cpt<$cpt_adhesion){ if(mysql_result($table,$cpt,Mode)=="aucun"){ $cotisation++; $montant_cotisation+=mysql_result($table,$cpt,Montant); } $cpt++; } print '411 '.$cotisation.' cotisation(s) non payée(s) : '.$montant_cotisation.' € '; } if($charge_constate_avance!=0){ print' 48 Comptes de régularisation : '.$charge_constate_avance.' € '; $table=mysql_query("select * from incorporelle",$connection); $cpt_incorporelle=mysql_num_rows($table); if($cpt_incorporelle!=0){ $cpt=0; while($cpt<$cpt_incorporelle){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '481 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from corporelle",$connection); $cpt_corporelle=mysql_num_rows($table); if($cpt_corporelle!=0){ $cpt=0; while($cpt<$cpt_corporelle){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '481 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from incorporelle",$connection); $cpt_incorporelle=mysql_num_rows($table); if($cpt_incorporelle!=0){ $cpt=0; while($cpt<$cpt_incorporelle){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '481 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from corporelle",$connection); $cpt_corporelle=mysql_num_rows($table); if($cpt_corporelle!=0){ $cpt=0; while($cpt<$cpt_corporelle){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '481 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from achat",$connection); $cpt_achat=mysql_num_rows($table); if($cpt_achat!=0){ $cpt=0; while($cpt<$cpt_achat){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '486 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from service",$connection); $cpt_service=mysql_num_rows($table); if($cpt_service!=0){ $cpt=0; while($cpt<$cpt_service){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '486 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from achat",$connection); $cpt_achat=mysql_num_rows($table); if($cpt_achat!=0){ $cpt=0; while($cpt<$cpt_achat){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '486 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from service",$connection); $cpt_service=mysql_num_rows($table); if($cpt_service!=0){ $cpt=0; while($cpt<$cpt_service){ if(mysql_result($table,$cpt,Mode)!="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '486 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } print' '; } if($disponible!=0 or $caisse!=0){ print'50 Disponibles : '.($disponible+$caisse).' € '; } if($disponible!=0){ print'51 Banque : '.$disponible.' € '; } if($caisse!=0){ print'53 Caisse : '.$caisse.' € '; } print' |
';
if($resultat>=0){
print'120 Résultat : ';
}
else{
print'129 Résultat : ';
}
print $resultat.' € '; if($provision_amortissement!=0){ print'142 Provisions relatives aux immobilisations : '.$provision_amortissement.' € '; $table=mysql_query("select * from dotation",$connection); $cpt_dotation=mysql_num_rows($table); $cpt=0; while($cpt<$cpt_dotation){ if(mysql_result($table,$cpt,Compte)=="6811 Dotation aux amortissements"){ print mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } if($provision_risque!=0){ print' 151 Provisions pour risques de charges : '.$provision_risque.' € '; $table=mysql_query("select * from dotation",$connection); $cpt_dotation=mysql_num_rows($table); $cpt=0; while($cpt<$cpt_dotation){ if(mysql_result($table,$cpt,Compte)=="6815 Dotations aux provisions pour risques"){ print mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } if($dette_exploitation_envers_fournisseur!=0){ print' 40 Dettes envers fournisseur : '.$dette_exploitation_envers_fournisseur.' € '; $table=mysql_query("select * from achat",$connection); $cpt_achat=mysql_num_rows($table); if($cpt_achat!=0){ $cpt=0; while($cpt<$cpt_achat){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="actuel"){ print '401 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from service",$connection); $cpt_service=mysql_num_rows($table); if($cpt_service!=0){ $cpt=0; while($cpt<$cpt_service){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="actuel"){ print '401 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from incorporelle",$connection); $cpt_incorporelle=mysql_num_rows($table); if($cpt_incorporelle!=0){ $cpt=0; while($cpt<$cpt_incorporelle){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="actuel"){ print '404 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from corporelle",$connection); $cpt_corporelle=mysql_num_rows($table); if($cpt_corporelle!=0){ $cpt=0; while($cpt<$cpt_corporelle){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="actuel"){ print '404 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from achat",$connection); $cpt_achat=mysql_num_rows($table); if($cpt_achat!=0){ $cpt=0; while($cpt<$cpt_achat){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '401 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from service",$connection); $cpt_service=mysql_num_rows($table); if($cpt_service!=0){ $cpt=0; while($cpt<$cpt_service){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '401 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from incorporelle",$connection); $cpt_incorporelle=mysql_num_rows($table); if($cpt_incorporelle!=0){ $cpt=0; while($cpt<$cpt_incorporelle){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '404 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } $table=mysql_query("select * from corporelle",$connection); $cpt_corporelle=mysql_num_rows($table); if($cpt_corporelle!=0){ $cpt=0; while($cpt<$cpt_corporelle){ if(mysql_result($table,$cpt,Mode)=="aucun" and mysql_result($table,$cpt,Livraison)=="oui" and mysql_result($table,$cpt,Exercice)=="prochain"){ print '404 '.mysql_result($table,$cpt,Motif).' : '.mysql_result($table,$cpt,Montant).' € '; } $cpt++; } } } if($produit_constate_avance!=0){ print' 48 Comptes de régularisation : '.$produit_constate_avance.' € '; $table=mysql_query("select * from adhesion",$connection); $cpt_adhesion=mysql_num_rows($table); $cpt=0; $cotisation=0; $montant_cotisation=0; while($cpt<$cpt_adhesion){ if(mysql_result($table,$cpt,Mode)!="aucun"){ $cotisation++; $prochain+=mysql_result($table,$cpt,Prochain); } $cpt++; } print '487 cotisation(s) payée(s) d'."'".'avance : '.$prochain.' € '; } if($exigible!=0){ print' 51 Exigibles : '.$exigible.' €'; } mysql_close($connection); print' |