Echeance |
Date |
Mensualité |
Capital Remboursé |
Interêts |
Cumul Remboursements |
Capital restant dû |
while($cpt <=$A){
if($cpt==1){
?>
echo $cpt; ?> |
echo $dtremb1jj."/".$dtremb1mma."/".$dtremb1aa; ?> |
echo formnbr($Mensual); ?> |
echo formnbr($capremb); ?> |
echo formnbr($interet); ?> |
echo formnbr($cumulrb1); ?> |
echo formnbr($caprestdu1); ?> |
$enrg = $cpt.";".$dtremb1jj."/".$dtremb1mma."/".$dtremb1aa.";".formnbr($Mensual).";".formnbr($capremb).";".formnbr($interet).";".formnbr($cumulrb1).";".formnbr($caprestdu1);
fwrite($inF,$enrg."\r\n");
$totinteret=$totinteret+$interet;
$totcapremb=$totcapremb+$capremb;
$totrebmens=$totrebmens + $Mensual;
$dtremb1mma = $dtremb1mma + 1;
$cpt=$cpt+1;
}
else {
//echo " --- CAPITAL REMBOURSE : ".$cpt." : ".($ech1*(pow((1+$B),($cpt-1))));
//$caprembn=$ech1*(pow((1+$B),($cpt-1)));
$caprembn=$ech1*(pow((1+$B),($cpt-1)));
//$ech1*(pow(($B),($cpt-1)));
//echo " --- INTERET : ".$cpt." : ".($Mensual - $ech1*(pow((1+$B),($cpt-1))));
//$interetn=$Mensual - $ech1*(pow((1+$B),($cpt-1)));
$interetn=$Mensual - $ech1*(pow((1+$B),($cpt-1)));
//$Mensual - $ech1*(pow(($B),($cpt-1)));
$totinteret=$totinteret+$interetn;
//echo " --- CUMUL REMBOURSEMENT : ".$cpt." : ".($cumulrb + ($ech1*(pow((1+$B),($cpt-1)))));
//if($cpt==$A) echo " --- CAPITAL RESTANT DU : ".$totcaprestd=0;
//else echo " --- CAPITAL RESTANT DU : ".$cpt." : ".($E - ($cumulrb + $ech1*(pow((1+$B),($cpt-1)))));
//$totcaprestdua = $E - ($cumulrb + $ech1*(pow((1+$B),($cpt-1))));
$totcaprestdua = $E - ($cumulrb + $ech1*(pow((1+$B),($cpt-1))));
// $E - ($cumulrb + $ech1*(pow(($B),($cpt-1))));
//$totcaprestd=$totcaprestd+($E - ($cumulrb + $ech1*(pow((1+$B),($cpt-1)))));
$totcaprestd=$totcaprestd+($E - ($cumulrb + $ech1*(pow((1+$B),($cpt-1)))));
//$totcaprestd+($E - ($cumulrb + $ech1*(pow(($B),($cpt-1)))));
//$cumulrb = $cumulrb + ($ech1*(pow((1+$B),($cpt-1))));
$cumulrb = $cumulrb + ($ech1*(pow((1+$B),($cpt-1))));
// $cumulrb + ($ech1*(pow(($B),($cpt-1))));
?>
echo $cpt; ?> |
echo $dtremb1jj."/".$dtremb1mma."/".$dtremb1aa; ?> |
echo formnbr($Mensual); ?> |
echo formnbr($caprembn); ?> |
echo formnbr($interetn); ?> |
echo formnbr($cumulrb); ?> |
if($cpt==$A){ ?> echo 0 ?> |
}else { ?> echo formnbr($totcaprestdua); ?> | } ?>
if($cpt==$A) $totcaprestdua=0;
$enrg = $cpt.";".$dtremb1jj."/".$dtremb1mma."/".$dtremb1aa.";".formnbr($Mensual).";".formnbr($caprembn).";".formnbr($interetn).";".formnbr($cumulrb).";".formnbr($totcaprestdua);
fwrite($inF,$enrg."\r\n");
//$totinteret=totinteret+$interet;
//$totcapremb=totcapremb+$capremb;
$totcapremb=$totcapremb+$caprembn;
$totrebmens=$totrebmens + $Mensual;
$dtremb1mma = $dtremb1mma + 1;
if($dtremb1mma > 12){
$dtremb1mma = 1;
$dtremb1aa = $dtremb1aa + 1;
}
$cpt=$cpt+1;
}
}
/*
$police = $_POST["police"];
//01;
$prenom= $_POST["prenom"];
$dtremb1jj = $_POST["dtremb1jj"];
//01;
$dtremb1mm = $_POST["dtremb1mm"];
//01;
$dtremb1mma = $dtremb1mm;
$dtremb1aa = $_POST["dtremb1aa"];
//2009;
//echo "EMPRUNT: ".$E=100000;
$E=$_POST["mttemprunt"];
//100000;
//echo " --- DUREE: ".$N=1;
$N=1;
//echo " --- TAUX INTERET: ".$txint=0.06;
$txint=$_POST["txinteret"]/100;
//0.06;
//echo " --- A: ".(12 * $N);
$A=$_POST["dureemp"];
*/
if($_POST["valider"]){
$datepret = $datepretaa."-".$datepretmm."-".$datepretjj;
$txintenrg = $txint * 100;
$datenrg = $aa."-".$mm."-".$jj;
$datedebremb = $dtremb1aa."-".$dtremb1mm."-".$dtremb1jj;
$qryins = "INSERT INTO prets (numpolice, prenom, mttemprunt, dureemp, txinteret, datepret, datedebremb, nb, datenrg) values('$police', '$prenom', '$E', '$A', '$txintenrg', '$datepret', '$datedebremb', '$cpt', '$datenrg')";
$resins = mysql_query($qryins);
}
$enrg = "TOTAL".";".";".formnbr($totrebmens).";".formnbr($totcapremb).";".formnbr($totinteret).";".";";
fwrite($inF,$enrg."\r\n");
?>
|
|
echo formnbr($totrebmens); ?> |
echo formnbr($totcapremb); ?> |
echo formnbr($totinteret); ?> |
|
|