
aureliemerlin
|
fichier de départ :
<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en"
"http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml/lang="fr"
lang="fr"
<head>
<title>modification d'une fiche opération</title>
<META HTTP-equiv="content-type"
content="text/html, charset=utf-8"/>
</head>
<body>
<?php
require_once('../gescompt/includes/templategc.php');
require_once('../gescompt/includes/magicquotes.inc.php');
require_once('../gescompt/includes/bd.inc.php');
$Action ="";
$Num = mysqli_real_escape_string($lien, $_GET['Num']);
$CodeCom = mysqli_real_escape_string($lien, $_GET['CodeCom']);
$TypeClient2 = mysqli_real_escape_string($lien, $_GET['TypeClient2']);
if (isset($_GET['Commercial']))
{
$Commercial = mysqli_real_escape_string($lien, $_GET['Commercial']);
}
$resultat = mysqli_query($lien, "select numoperation, CodeCom, NumCli, Acquisition, PenalitesRbt, Travaux, Terrain, Notaire, Agence, Garantie, FraisCourtage, FraisBanque, Total, Apports, TotalAfinancer, Salaire1, Salaire2, RevenuLocatif, RevenuCompl, AllocFam, AideAulog, RevenuFiscalRef, Banque1, Banque2, Banque3, Banque4, Duree, Mensualites, Signatureprevue, AccordPrevue, AdresseProjet, TauxEndAvecOperation, MontantFinancement, MontantTauxZero from bdoperations where NumCli ='$Num' and CodeCom ='$CodeCom'");
$bdoperations = array();
while ($ligne = mysqli_fetch_array($resultat))
{
$bdoperations[]= array('numoperation' => $ligne ['numoperation'], 'CodeCom' => $ligne['CodeCom'], 'NumCli' => $ligne['NumCli'], 'Acquisition' => $ligne['Acquisition'], 'PenalitesRbt' => $ligne['PenalitesRbt'], 'Travaux' => $ligne['Travaux'], 'Terrain' => $ligne['Terrain'], 'Notaire' => $ligne['Notaire'], 'Agence' => $ligne['Agence'], 'Garantie' => $ligne['Garantie'], 'FraisCourtage' => $ligne['FraisCourtage'], 'FraisBanque' => $ligne['FraisBanque'], 'Total' => $ligne['Total'], 'Apports' => $ligne['Apports'], 'TotalAfinancer' => $ligne['TotalAfinancer'], 'Salaire1' => $ligne['Salaire1'], 'Salaire2' => $ligne['Salaire2'], 'RevenuLocatif' => $ligne['RevenuLocatif'], 'RevenuCompl' => $ligne['RevenuCompl'], 'AllocFam' => $ligne['AllocFam'], 'AideAulog' => $ligne['AideAulog'], 'RevenuFiscalRef' => $ligne['RevenuFiscalRef'], 'Banque1' => $ligne['Banque1'], 'Banque2' => $ligne['Banque2'], 'Banque3' => $ligne['Banque3'], 'Banque4' => $ligne['Banque4'], 'Duree' => $ligne['Duree'], 'Mensualites' => $ligne['Mensualites'], 'Signatureprevue' => $ligne['Signatureprevue'], 'AccordPrevue' => $ligne['AccordPrevue'], 'AdresseProjet' => $ligne['AdresseProjet'], 'TauxEndAvecOperation' => $ligne['TauxEndAvecOperation'], 'MontantFinancement' => $ligne['MontantFinancement'], 'MontantTauxZero' => $ligne['MontantTauxZero']);
}
$resultat1 = mysqli_query($lien, "select Num, NumOp, NumCli, CodeCom, TypeDeBien, Adressebien, ValeurBien, CRD from bdpatrimoine where NumCli ='$Num' and CodeCom ='$CodeCom'");
$bdpatrimoine = array();
while ($ligne = mysqli_fetch_array($resultat1))
{
$bdpatrimoine[]= array('Num' => $ligne ['Num'], 'NumOp' => $ligne['NumOp'], 'NumCli' => $ligne['NumCli'], 'CodeCom' => $ligne['CodeCom'], 'TypeDeBien' => $ligne['TypeDeBien'], 'Adressebien' => $ligne['Adressebien'], 'ValeurBien' => $ligne['ValeurBien'], 'CRD' => $ligne['CRD']);
}
$resultat2 = mysqli_query($lien, "select Num, NumOp, NumCli, CodeCom, Titre, CRD, Ech, Charges from bdpret where NumCli ='$Num' and CodeCom ='$CodeCom'");
$bdpret = array();
while ($ligne = mysqli_fetch_array($resultat2))
{
$bdpret[]= array('Num' => $ligne ['Num'], 'NumOp' => $ligne['NumOp'], 'NumCli' => $ligne['NumCli'], 'CodeCom' => $ligne['CodeCom'], 'Titre' => $ligne['Titre'], 'CRD' => $ligne['CRD'], 'Ech' => $ligne['Ech'], 'Charges' => $ligne['Charges']);
}
?>
<?php foreach ($bdoperations as $operations): ?>
<form action="majoperation.php" method="POST">
<h2>modification fiche opérations</h2>
<div class="wrapper">
<div class="sfright">
<!--debut de rounded box --><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"></b><b class="xb5"></b><b class="xb6"></b><b class="xb7"></b>
<div class="xboxcontent">
<fieldset>
<h3>Revenus</h3>
<div class="ligne">
<span class="libelle"><label for="Salaire1">Salaire 1 :</label></span>
<input class="chiffres" class="chiffres" name="Salaire1" id="Salaire1" size="8" maxlength="80" type="text" value="<?php echo number_format($operations['Salaire1'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="Salaire2">Salaire 2 :</label></span>
<input class="chiffres" class="chiffres" name="Salaire2" id="Salaire2" size="8" maxlength="80" type="text" value="<?php echo number_format($operations['Salaire2'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="RevenuLocatif">Revenu Locatif :</label></span>
<input class="chiffres" class="chiffres" name="RevenuLocatif" id="RevenuLocatif" size="8" maxlength="80" type="text" value="<?php echo number_format($operations['RevenuLocatif'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="RevenuCompl">Revenu Compl :</label></span>
<input class="chiffres" class="chiffres" name="RevenuCompl" id="RevenuCompl" size="8" maxlength="80" type="text" value="<?php echo number_format($operations['RevenuCompl'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="AllocFam">Allocations familiales :</label></span>
<input class="chiffres" class="chiffres" name="AllocFam" id="AllocFam" size="8" maxlength="80" type="text" value="<?php echo number_format($operations['AllocFam'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="AideAulog">Aide au logement :</label></span>
<input class="chiffres" class="chiffres" name="AideAulog" id="AideAulog" size="8" maxlength="80" type="text" value="<?php echo number_format($operations['AideAulog'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="RevenuFiscalRef">Revenu fiscal de référence :</label></span>
<input class="chiffres" class="chiffres" name="RevenuFiscalRef" id="RevenuFiscalRef" size="8" maxlength="80" type="text" value="<?php echo number_format($operations['RevenuFiscalRef'], 2, '.', ' ');?>"/>
</div>
</fieldset>
<!--fin de rounded box--> </div><b class="xb7"></b><b class="xb6"></b><b class="xb5"></b><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"></b>
<br>
<!--debut de rounded box --><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"></b><b class="xb5"></b><b class="xb6"></b><b class="xb7"></b>
<div class="xboxcontent">
<fieldset>
<h3>Endettement avec opération</h3>
<div class="ligne">
<span class="libelle"><label for="TauxEndAvecOperation"></label></span>
<input class="chiffres" class="chiffres" name="TauxEndAvecOperation" id="TauxEndAvecOperation" size="3" maxlength="80" type="text" value="<?php echo number_format($operations['TauxEndAvecOperation'], 2, '.', ' ');?>"/>%
</div>
</fieldset>
<!--fin de rounded box--> </div><b class="xb7"></b><b class="xb6"></b><b class="xb5"></b><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"></b>
<br>
<!--debut de rounded box --><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"></b><b class="xb5"></b><b class="xb6"></b><b class="xb7"></b>
<div class="xboxcontent">
<fieldset>
<h3>Patrimoine</h3>
<?php echo "<table><tr class=\"headline\"><th>Num</th><th>Type de bien</th><th>Adresse du bien</th><th>Valeur du bien</th><th>CRD</th></tr>" ; ?>
<?php foreach ($bdpatrimoine as $patrimoine): ?>
<form action ="majoperation.php" method="POST">
<?php echo "<tr><td>" .htmlspecialchars($patrimoine['Num'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td>" .htmlspecialchars($patrimoine['TypeDeBien'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td>" .htmlspecialchars($patrimoine['Adressebien'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td>" .htmlspecialchars(number_format($patrimoine['ValeurBien'], 2, '.', ' '), ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td>" .htmlspecialchars(number_format($patrimoine['CRD'], 2, '.', ' '), ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<td><a href="majoperation.php?numoperation=<?php echo $operations['numoperation']; ?>&CodeCom=<?php echo $operations['CodeCom']; ?>&TypeClient2=<?php echo $TypeClient2; ?>&Commercial=<?php echo $Commercial; ?>&Num=<?php echo $patrimoine['Num'];?>&Action=patrimoine"> <input class="chiffres" id="AJOUTER" name="AJOUTER" value="AJOUTER" type="image" img src='images/dossier_mini.bmp'></a></td>
<?php endforeach; ?>
</form>
<?php echo "</tr></table>"; ?>
</fieldset>
<!--fin de rounded box--> </div><b class="xb7"></b><b class="xb6"></b><b class="xb5"></b><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"></b>
<br>
<!--debut de rounded box --><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"></b><b class="xb5"></b><b class="xb6"></b><b class="xb7"></b>
<div class="xboxcontent">
<fieldset>
<h3>Emprunt(s)</h3>
<?php echo "<table><tr class=\"headline\"><th>Prêt</th><th>CRD</th><th>Ech</th><th>Prêt conservé</th></tr>" ; ?>
<?php foreach ($bdpret as $pret): ?>
<?php echo "<tr><td>" .htmlspecialchars($pret['Num'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td>" .htmlspecialchars($pret['Titre'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td>" .htmlspecialchars(number_format($pret['Ech'], 2, '.', ' '), ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td>" ?><input class="chiffres" type="checkbox" value="1" <?php if ($pret['Charges']=='1') echo ' checked="checked" ';?>/><?php ".</td>" ?>
<td><a href="majoperation.php?numoperation=<?php echo $operations['numoperation']; ?>&CodeCom=<?php echo $operations['CodeCom']; ?>&TypeClient2=<?php echo $TypeClient2; ?>&Commercial=<?php echo $Commercial; ?>&Num=<?php echo $pret['Num'];?>&Action=emprunt"> <input class="chiffres" id="AJOUTER" name="AJOUTER" value="AJOUTER" type="image" img src='images/dossier_mini.bmp'></a></td>
<?php endforeach; ?>
<?php echo "</tr></table>"; ?>
</fieldset>
<!--fin de rounded box--> </div><b class="xb7"></b><b class="xb6"></b><b class="xb5"></b><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"></b>
</div>
<div class="sfleft">
<!--debut de rounded box --><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"></b><b class="xb5"></b><b class="xb6"></b><b class="xb7"></b><div class="xboxcontent">
<div id="subcoldrte">
<div style="font-weight:bold; font-size:110%">
<span class="libelle2"><label for="MontantFinancement">Mt à Financer :</label></span>
<input class="chiffres" class="chiffres" name="MontantFinancement" id="MontantFinancement" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['MontantFinancement'], 2, '.', ' ');?>"/>
</div>
<div style="font-weight:bold; font-size:110%">
<span class="libelle2"><label for="MontantTauxZero">Mt Tx ZÉRO :</label></span>
<input class="chiffres" class="chiffres" name="MontantTauxZero" id="MontantTauxZero" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['MontantTauxZero'], 2, '.', ' ');?>"/>
</div>
<div style="font-weight:bold; font-size:110%">
<span class="libelle2"><label for="TotalAfinancer">Total à financer :</label></span>
<input class="chiffres" class="chiffres" name="TotalAfinancer" id="TotalAfinancer" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['TotalAfinancer'], 2, '.', ' ');?>"/>
</div>
</div>
<fieldset>
<!--detail des operations-->
<h3>Détails de l'opération</h3>
<div class="ligne">
<span class="libelle">
<label for="numoperation">numoperation :</label></span>
<input class="chiffres" name="numoperation" id="numoperation" size="5" maxlength="80" type="text" value="<?php echo $operations['numoperation'];?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="CodeCom">CodeCom :</label></span>
<input class="chiffres" name="CodeCom" id="CodeCom" size="5" maxlength="80" type="text" value="<?php echo $operations['CodeCom'];?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="Acquisition">Acquisition :</label></span>
<input class="chiffres" name="Acquisition" id="Acquisition" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['Acquisition'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="PenalitesRbt">Pénalités de remboursement :</label></span>
<input class="chiffres" name="PenalitesRbt" id="PenalitesRbt" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['PenalitesRbt'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="Travaux">Travaux :</label></span>
<input class="chiffres" name="Travaux" id="Travaux" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['Travaux'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="Terrain">Terrain :</label></span>
<input class="chiffres" name="Terrain" id="Terrain" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['Terrain'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="Notaire">Notaire :</label></span>
<input class="chiffres" name="Notaire" id="Notaire" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['Notaire'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="Agence">Agence :</label></span>
<input class="chiffres" name="Agence" id="Agence" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['Agence'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="Garantie">Garantie :</label></span>
<input class="chiffres" name="Garantie" id="Garantie" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['Garantie'], 2, '.', ' ');?>"/> </div>
<div class="ligne">
<span class="libelle"><label for="FraisCourtage">Frais de courtage :</label></span>
<input class="chiffres" name="FraisCourtage" id="FraisCourtage" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['FraisCourtage'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="FraisBanque">Frais de banque :</label></span>
<input class="chiffres" name="FraisBanque" id="FraisBanque" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['FraisBanque'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="Total">Total :</label></span>
<input class="chiffres" name="Total" id="Total" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['Total'], 2, '.', ' ');?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="Apports">Apports :</label></span>
<input class="chiffres" name="Apports" id="Apports" size="8" maxlength="30" type="text" value="<?php echo number_format($operations['Apports'], 2, '.', ' ');?>"/>
</div>
</fieldset>
<!--fin de rounded box--> </div><b class="xb7"></b><b class="xb6"></b><b class="xb5"></b><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"></b>
<br />
<!--debut de rounded box --><b class="xb1"></b><b class="xb2"></b><b class="xb3"></b><b class="xb4"></b><b class="xb5"></b><b class="xb6"></b><b class="xb7"></b><div class="xboxcontent">
<fieldset>
<h3>Banque(s) Actuelle(s) :</h3>
<div class="ligne">
<input name="Banque1" id="Banque1" size="8" maxlength="80" type="text" value="<?php echo $operations['Banque1'];?>"/>
<input name="Banque2" id="Banque2" size="8" maxlength="80" type="text" value="<?php echo $operations['Banque2'];?>"/>
<input name="Banque3" id="Banque3" size="8" maxlength="80" type="text" value="<?php echo $operations['Banque3'];?>"/>
<input name="Banque4" id="Banque4" size="8" maxlength="80" type="text" value="<?php echo $operations['Banque4'];?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="Duree">Durée souhaitée (mois) :</label></span>
<input class="chiffres" name="Duree" id="Duree" size="5" maxlength="5" type="text" value="<?php echo $operations['Duree'];?>"/>
</div>
<div class="ligne">
<span class="libelle"><label for="Mensualites">Mensualités :</label></span>
<input name="Mensualites" id="Mensualites" size="5" maxlength="5" type="text" value="<?php echo number_format($operations['Mensualites'], 2, '.', ' ');?>"/>
</div>
<?PHP $Signatureprevue = changedateusfr($operations['Signatureprevue']);?>
<div class="ligne">
<span class="libelle"><label for="Signatureprevue">Signature prévue le :</label></span>
<input name="Signatureprevue" id="Signatureprevue" size="10" maxlength="10" type="text" value="<?php echo $Signatureprevue;?>"/> (jj/mm/aaaa)
</div>
<?PHP $AccordPrevue = changedateusfr($operations['AccordPrevue']);?>
<div class="ligne">
<span class="libelle"><label for="AccordPrevue">Accord prévue le :</label></span>
<input name="AccordPrevue" id="AccordPrevue" size="10" maxlength="10" type="text" value="<?php echo $AccordPrevue;?>"/> (jj/mm/aaaa)
</div>
<div class="ligne"><span class="libelle"><label for="AdresseProjet">Adresse du projet à financer :</label></span>
<textarea name="AdresseProjet" cols="17" rows="2" id="AdresseProjet"><?php echo $operations['AdresseProjet'];?></textarea></div>
</fieldset>
<!--fin de rounded box--> </div><b class="xb7"></b><b class="xb6"></b><b class="xb5"></b><b class="xb4"></b><b class="xb3"></b><b class="xb2"></b><b class="xb1"></b>
</div><!--fin de col gauche-->
<?php endforeach; ?>
<br>
<div id="btns">
<?php
if (isset($_GET['Commercial']))
{
$Commercial = mysqli_real_escape_string($lien, $_GET['Commercial']);
}
?>
<?php /*?>bouton apercu<?php */?>
<a href='majoperation.php?numoperation=<?php echo $operations['numoperation']; ?>&CodeCom=<?php echo $operations['CodeCom']; ?>&Num=<?php echo $operations['NumCli']; ?>&TypeClient2=<?php echo $TypeClient2; ?>&Commercial=<?php echo $Commercial; ?>&Action=apercu' target='_blank' title='Ajouter'><img src='images/loupe.png' alt='Ajouter'/></a>
<?php /*?>bouton imprimer<?php */?>
<a href="majoperation.php?numoperation=<?php echo $operations['numoperation']; ?>&CodeCom=<?php echo $operations['CodeCom']; ?>&Num=<?php echo $operations['NumCli']; ?>&TypeClient2=<?php echo $TypeClient2; ?>&Commercial=<?php echo $Commercial; ?>&Action=imprimer" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Retour','','images/printer-blue-icon.png',1)" TARGET=_BLANK <img src="images/printer-blue-icon.png" alt="apercu fiche client particulier" name="apercu" id="apercu" /></a> <br /><br /><br />
<?php /*?>bouton retour<?php */?>
<a href="majoperation.php?numoperation=<?php echo $operations['numoperation']; ?>&CodeCom=<?php echo $operations['CodeCom']; ?>&TypeClient2=<?php echo $TypeClient2; ?>&Num=<?php echo $operations['NumCli']; ?>&Commercial=<?php echo $Commercial; ?>&Action=retour"> <input id="AJOUTER" name="AJOUTER" value="AJOUTER" type="image" img src="images/btn-back_off.jpg" alt="Retour à la liste clients" name="Retour" id="Retour" /></a>
<?php /*?>bouton valider<?php */?>
<a href="majoperation.php?numoperation=<?php echo $operations['numoperation']; ?>&CodeCom=<?php echo $operations['CodeCom']; ?>&TypeClient2=<?php echo $TypeClient2; ?>&Num=<?php echo $operations['NumCli']; ?>&Commercial=<?php echo $Commercial; ?>&Action=valider"> <input id="AJOUTER" name="AJOUTER" value="AJOUTER" type="image" src="images/btn-validate_off.jpg" /></a>
</div> <!--fin de btns -->
</div> <!--fin de wrapper -->
</form>
<div class="spacer"></div>
<?php
pied();
?>
<?PHP
function changedateusfr($dateus)
{
$datefr=$dateus{8}.$dateus{9}."-".$dateus{5}.$dateus{6}."-".$dateus{0}.$dateus{1}.$dateus{2}.$dateus{3};
return $datefr;
}
?>
<style type="text/css">
<!--
table{
width: 102%;
margin-right: auto;
margin-left: auto;
}
-->
</style>
ensuite lorsque je clique sur la loupe je vais dans ce fichier :
<?php
if (isset($_POST['numoperation']))
{
require_once('../gescompt/includes/bd.inc.php');
require_once('../gescompt/includes/magicquotes.inc.php');
$numoperation = mysqli_real_escape_string($lien, $_POST['numoperation']);
$CodeCom = htmlspecialchars(mysqli_real_escape_string($lien, $_POST['CodeCom']));
$Commercial =htmlspecialchars(mysqli_real_escape_string($lien, $_POST['Commercial']));
$Acquisition = mysqli_real_escape_string($lien, $_POST['Acquisition']);
if(isset($_POST['PenalitesRbt']) && !empty($_POST['PenalitesRbt']))
{
$PenalitesRbt = mysqli_real_escape_string($lien, $_POST['PenalitesRbt']);
}
if(isset($_POST['Travaux']) && !empty($_POST['Travaux']))
{
$Travaux = mysqli_real_escape_string($lien, $_POST['Travaux']);
}
if(isset($_POST['Terrain']) && !empty($_POST['Terrain']))
{
$Terrain = mysqli_real_escape_string($lien, $_POST['Terrain']);
}
if(isset($_POST['Notaire']) && !empty($_POST['Notaire']))
{
$Notaire = mysqli_real_escape_string($lien, $_POST['Notaire']);
}
if(isset($_POST['Agence']) && !empty($_POST['Agence']))
{
$Agence = mysqli_real_escape_string($lien, $_POST['Agence']);
}
if(isset($_POST['Garantie']) && !empty($_POST['Garantie']))
{
$Garantie = mysqli_real_escape_string($lien, $_POST['Garantie']);
}
if(isset($_POST['FraisCourtage']) && !empty($_POST['FraisCourtage']))
{
$FraisCourtage = mysqli_real_escape_string($lien, $_POST['FraisCourtage']);
}
if(isset($_POST['FraisBanque']) && !empty($_POST['FraisBanque']))
{
$FraisBanque = mysqli_real_escape_string($lien, $_POST['FraisBanque']);
}
if(isset($_POST['Total']) && !empty($_POST['Total']))
{
$Total = mysqli_real_escape_string($lien, $_POST['Total']);
}
if(isset($_POST['Apports']) && !empty($_POST['Apports']))
{
$Apports = mysqli_real_escape_string($lien, $_POST['Apports']);
}
if(isset($_POST['TotalAfinancer']) && !empty($_POST['TotalAfinancer']))
{
$TotalAfinancer = mysqli_real_escape_string($lien, $_POST['TotalAfinancer']);
}
if(isset($_POST['Salaire1']) && !empty($_POST['Salaire1']))
{
$Salaire1 = mysqli_real_escape_string($lien, $_POST['Salaire1']);
}
if(isset($_POST['Salaire2']) && !empty($_POST['Salaire2']))
{
$Salaire2 = mysqli_real_escape_string($lien, $_POST['Salaire2']);
}
if(isset($_POST['RevenuLocatif']) && !empty($_POST['RevenuLocatif']))
{
$RevenuLocatif = mysqli_real_escape_string($lien, $_POST['RevenuLocatif']);
}
if(isset($_POST['RevenuCompl']) && !empty($_POST['RevenuCompl']))
{
$RevenuCompl = mysqli_real_escape_string($lien, $_POST['RevenuCompl']);
}
if(isset($_POST['AllocFam']) && !empty($_POST['AllocFam']))
{
$AllocFam = mysqli_real_escape_string($lien, $_POST['AllocFam']);
}
if(isset($_POST['AideAulog']) && !empty($_POST['AideAulog']))
{
$AideAulog = mysqli_real_escape_string($lien, $_POST['AideAulog']);
}
if(isset($_POST['RevenuFiscalRef']) && !empty($_POST['RevenuFiscalRef']))
{
$RevenuFiscalRef = mysqli_real_escape_string($lien, $_POST['RevenuFiscalRef']);
}
if(isset($_POST['Banque1']) && !empty($_POST['Banque1']))
{
$Banque1 = mysqli_real_escape_string($lien, $_POST['Banque1']);
}
if(isset($_POST['Banque2']) && !empty($_POST['Banque2']))
{
$Banque2 = mysqli_real_escape_string($lien, $_POST['Banque2']);
}
if(isset($_POST['Banque3']) && !empty($_POST['Banque3']))
{
$Banque3 = mysqli_real_escape_string($lien, $_POST['Banque3']);
}
if(isset($_POST['Banque4']) && !empty($_POST['Banque4']))
{
$Banque4 = mysqli_real_escape_string($lien, $_POST['Banque4']);
}
if(isset($_POST['Duree']) && !empty($_POST['Duree']))
{
$Duree = mysqli_real_escape_string($lien, $_POST['Duree']);
}
if(isset($_POST['Mensualites']) && !empty($_POST['Mensualites']))
{
$Mensualites = mysqli_real_escape_string($lien, $_POST['Mensualites']);
}
$Signatureprevue = changedatefrus(mysqli_real_escape_string($lien, $_POST['Signatureprevue']));
if (empty($Signatureprevue))
{
$Signatureprevue = NULL;
}
else
{
$Signatureprevue = $Signatureprevue;
}
$AccordPrevue = changedatefrus(mysqli_real_escape_string($lien, $_POST['AccordPrevue']));
if (empty($AccordPrevue))
{
$AccordPrevue = NULL;
}
else
{
$AccordPrevue = $AccordPrevue;
}
if(isset($_POST['AdresseProjet']) && !empty($_POST['AdresseProjet']))
{
$AdresseProjet = htmlspecialchars(mysqli_real_escape_string($lien, $_POST['AdresseProjet']));
}
if(isset($_POST['TauxEndAvecOperation']) && !empty($_POST['TauxEndAvecOperation']))
{
$TauxEndAvecOperation = mysqli_real_escape_string($lien, $_POST['TauxEndAvecOperation']);
}
if(isset($_POST['MontantFinancement']) && !empty($_POST['MontantFinancement']))
{
$MontantFinancement = mysqli_real_escape_string($lien, $_POST['MontantFinancement']);
}
if(isset($_POST['MontantTauxZero']) && !empty($_POST['MontantTauxZero']))
{
$MontantTauxZero = mysqli_real_escape_string($lien, $_POST['MontantTauxZero']);
}
$sql = "UPDATE bdoperations set Acquisition='$Acquisition', PenalitesRbt='$PenalitesRbt', Travaux='$Travaux', Terrain='$Terrain', Notaire='$Notaire', Agence='$Agence', Garantie='$Garantie', FraisCourtage='$FraisCourtage', FraisBanque='$FraisBanque', Total='$Total', Apports='$Apports', TotalAfinancer='$TotalAfinancer', Salaire1='$Salaire1', Salaire2='$Salaire2', RevenuLocatif='$RevenuLocatif', RevenuCompl='$RevenuCompl', AllocFam='$AllocFam', AideAulog='$AideAulog', RevenuFiscalRef='$RevenuFiscalRef', Banque1='$Banque1', Banque2='$Banque2', Banque3='$Banque3', Banque4='$Banque4', Duree='$Duree', Mensualites='$Mensualites', Signatureprevue='$Signatureprevue', AccordPrevue='$AccordPrevue', AdresseProjet='$AdresseProjet', TauxEndAvecOperation='$TauxEndAvecOperation', MontantFinancement='$MontantFinancement', MontantTauxZero='$MontantTauxZero' where numoperation = '$numoperation'";
if (!mysqli_query($lien, $sql))
{
$erreur = "erreur dans la modification de la fiche operation :" .mysqli_error($lien);
include 'erreur.html.php';
exit();
}
}
$url = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
//print_r(parse_url($url));
//echo parse_url($url, PHP_URL_PATH);
$Num = $_GET["Num"];
$CodeCom = $_GET["CodeCom"];
$TypeClient2 = $_GET["TypeClient2"];
$Commercial = $_GET["Commercial"];
$Action= $_GET["Action"];
$numoperation = $_GET["numoperation"];
$NumCli= $_GET["Num"];
//echo $numoperation;
if ($Action == 'patrimoine')
{
header("Location: modifpatrimoine.php?Num=$Num&CodeCom=$CodeCom&TypeClient2=$TypeClient2&Commercial=$Commercial");
}
else
if ($Action == 'emprunt')
{
header("Location: modifpret.php?Num=$Num&CodeCom=$CodeCom&TypeClient2=$TypeClient2&Commercial=$Commercial");
}
else
if ($Action == 'retour')
{
if ($TypeClient2 == 'SOCIETE')
{
header("Location: modifclientsoc.php?Num=$Num&CodeCom=$CodeCom&Commercial=$Commercial");
}
else
{
header("Location: modifclientpart.php?Num=$Num&CodeCom=$CodeCom&Commercial=$Commercial");
}
}
else
if ($Action == 'imprimer' or $Action == 'apercu')
{
header("Location: printoperations.php?numoperation=$numoperation&Num=$NumCli&CodeCom=$CodeCom&Commercial=$Commercial&Action=$Action");
}
else
if ($Action == 'valider')
{
header("Location: modifoperations.php?Num=$Num&CodeCom=$CodeCom&TypeClient2=$TypeClient2&Commercial=$Commercial");
}
?>
<?php
function changedatefrus($datefr)
{
$dateus=$datefr{6}.$datefr{7}.$datefr{8}.$datefr{9}."-".$datefr{3}.$datefr{4}."-".$datefr{0}.$datefr{1};
return $dateus;
}
?>
et voici le fichier qu'il ouvre dans le nouvel onglet :
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" href="images/favicon.ico" type="image/png" />
<link rel="stylesheet" type="text/css" href="style/operation-screen.css" media="screen"/>
<link rel="stylesheet" type="text/css" href="style/operation-print.css" media="print"/>
<title>FICHE DETAIL OPERATION</title>
</head>
<?php
require_once('includes/magicquotes.inc.php');
require_once('includes/bd.inc.php');
$numoperation = mysqli_real_escape_string($lien, $_GET['numoperation']);
$Num = mysqli_real_escape_string($lien, $_GET['Num']);
$CodeCom = mysqli_real_escape_string($lien, $_GET['CodeCom']);
$Action = mysqli_real_escape_string($lien, $_GET['Action']);
$resultat = mysqli_query($lien, "select numoperation, CodeCom, NumCli, Acquisition, PenalitesRbt, Travaux, Terrain, Notaire, Agence, Garantie, FraisCourtage, FraisBanque, Total, Apports, TotalAfinancer, Salaire1, Salaire2, RevenuLocatif, RevenuCompl, AllocFam, AideAulog, RevenuFiscalRef, Banque1, Banque2, Banque3, Banque4, Duree, Mensualites, Signatureprevue, AccordPrevue, AdresseProjet, TauxEndAvecOperation, MontantFinancement, MontantTauxZero from bdoperations where numoperation ='$numoperation'");
$bdoperations = array();
while ($ligne = mysqli_fetch_array($resultat))
{
$bdoperations[]= array('numoperation' => $ligne ['numoperation'], 'CodeCom' => $ligne['CodeCom'], 'NumCli' => $ligne['NumCli'], 'Acquisition' => $ligne['Acquisition'], 'PenalitesRbt' => $ligne['PenalitesRbt'], 'Travaux' => $ligne['Travaux'], 'Terrain' => $ligne['Terrain'], 'Notaire' => $ligne['Notaire'], 'Agence' => $ligne['Agence'], 'Garantie' => $ligne['Garantie'], 'FraisCourtage' => $ligne['FraisCourtage'], 'FraisBanque' => $ligne['FraisBanque'], 'Total' => $ligne['Total'], 'Apports' => $ligne['Apports'], 'TotalAfinancer' => $ligne['TotalAfinancer'], 'Salaire1' => $ligne['Salaire1'], 'Salaire2' => $ligne['Salaire2'], 'RevenuLocatif' => $ligne['RevenuLocatif'], 'RevenuCompl' => $ligne['RevenuCompl'], 'AllocFam' => $ligne['AllocFam'], 'AideAulog' => $ligne['AideAulog'], 'RevenuFiscalRef' => $ligne['RevenuFiscalRef'], 'Banque1' => $ligne['Banque1'], 'Banque2' => $ligne['Banque2'], 'Banque3' => $ligne['Banque3'], 'Banque4' => $ligne['Banque4'], 'Duree' => $ligne['Duree'], 'Mensualites' => $ligne['Mensualites'], 'Signatureprevue' => $ligne['Signatureprevue'], 'AccordPrevue' => $ligne['AccordPrevue'], 'AdresseProjet' => $ligne['AdresseProjet'], 'TauxEndAvecOperation' => $ligne['TauxEndAvecOperation'], 'MontantFinancement' => $ligne['MontantFinancement'], 'MontantTauxZero' => $ligne['MontantTauxZero']);
}
$resultat1 = mysqli_query($lien, "select Num, NumOp, NumCli, CodeCom, TypeDeBien, AdresseBien, ValeurBien, CRD from bdpatrimoine where NumCli ='$Num' and CodeCom ='$CodeCom'");
$bdpatrimoine = array();
while ($ligne = mysqli_fetch_array($resultat1))
{
$bdpatrimoine[]= array('Num' => $ligne ['Num'], 'NumOp' => $ligne['NumOp'], 'NumCli' => $ligne['NumCli'], 'CodeCom' => $ligne['CodeCom'], 'TypeDeBien' => $ligne['TypeDeBien'], 'AdresseBien' => $ligne['AdresseBien'], 'ValeurBien' => $ligne['ValeurBien'], 'CRD' => $ligne['CRD']);
}
$resultat2 = mysqli_query($lien, "select Num, NumOp, NumCli, CodeCom, Titre, CRD, Ech, Charges from bdpret where NumCli ='$Num' and CodeCom ='$CodeCom'");
$bdpret = array();
while ($ligne = mysqli_fetch_array($resultat2))
{
$bdpret[]= array('Num' => $ligne ['Num'], 'NumOp' => $ligne['NumOp'], 'NumCli' => $ligne['NumCli'], 'CodeCom' => $ligne['CodeCom'], 'Titre' => $ligne['Titre'], 'CRD' => $ligne['CRD'], 'Ech' => $ligne['Ech'], 'Charges' => $ligne['Charges']);
}
$resultat3 = mysqli_query($lien, "select Adr1Soc, Adr2Soc, CPSoc, VilleSoc, StatutSoc, CapitalSoc, SiretSoc, RCSSoc, APESoc, TelSoc, FaxSoc, SiteInternetSoc, EmailSoc from bdparametres");
while ($ligne = mysqli_fetch_array($resultat3))
{
$bdparametres [] = array('Adr1Soc' => $ligne ['Adr1Soc'], 'Adr2Soc' => $ligne ['Adr2Soc'],'CPSoc' => $ligne ['CPSoc'], 'VilleSoc' => $ligne ['VilleSoc'], 'StatutSoc' => $ligne ['StatutSoc'], 'CapitalSoc' => $ligne ['CapitalSoc'], 'SiretSoc' => $ligne ['SiretSoc'], 'RCSSoc' => $ligne ['RCSSoc'], 'APESoc' => $ligne ['APESoc'], 'TelSoc' => $ligne ['TelSoc'], 'FaxSoc' => $ligne ['FaxSoc'], 'SiteInternetSoc' => $ligne ['SiteInternetSoc'], 'EmailSoc' => $ligne ['EmailSoc']);
}
?>
<?php foreach ($bdoperations as $operations): ?>
<?php
if ($Action == 'imprimer')
{
?>
<body onload="window.print()">
<?php
}
else
{
?>
<body>
<?php
}
?>
<div id="page">
<div class="wrapper">
<div id="coldrt">
<div class="ligne2"><input name="Duree" id="Duree" size="5" maxlength="5" type="text" value="<?php echo $operations['Duree'];?>"/></div> <br />
<div class="ligne2"><input name="Mensualites" id="Mensualites" size="6" maxlength="6" type="text" value="<?php echo $operations['Mensualites'];?>"/></div>
<?PHP $Signatureprevue = changedateusfr($operations['Signatureprevue']);?><br />
<div class="ligne2"><input name="Signatureprevue" id="Signatureprevue" size="10" maxlength="10" type="text" value="<?php echo $Signatureprevue;?>"/></div>
<?PHP $AccordPrevue = changedateusfr($operations['AccordPrevue']);?>
<div class="ligne2"><input name="AccordPrevue" id="AccordPrevue" size="10" maxlength="10" type="text" value="<?php echo $AccordPrevue;?>"/></div><br />
</div><!--fin col droite-->
<div id="colgche">
<div class="ligne">
<span class="libelle">
<label for="Acquisition">Acquisition :</label>
</span>
<input name="Acquisition" id="Acquisition" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['Acquisition'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle">
<label for="PenalitesRbt">Pénalités remboursement :</label>
</span>
<input name="PenalitesRbt" id="PenalitesRbt" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['PenalitesRbt'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle">
<label for="Travaux">Travaux :</label>
</span>
<input name="Travaux" id="Travaux" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['Travaux'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle">
<label for="Terrain">Terrain :</label>
</span>
<input name="Terrain" id="Terrain" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['Terrain'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle">
<label for="Notaire">Notaire :</label>
</span>
<input name="Notaire" id="Notaire" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['Notaire'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle">
<label for="Agence">Agence :</label>
</span>
<input name="Agence" id="Agence" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['Agence'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle">
<label for="Garantie">Garantie :</label>
</span>
<input name="Garantie" id="Garantie" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['Garantie'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle">
<label for="FraisCourtage">Frais de courtage :</label>
</span>
<input name="FraisCourtage" id="FraisCourtage" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['FraisCourtage'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle">
<label for="FraisBanque">Frais de banque :</label>
</span>
<input name="FraisBanque" id="FraisBanque" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['FraisBanque'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle">
<label for="Total">Total :</label>
</span>
<input name="Total" id="Total" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['Total'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle">
<label for="Apports">Apports :</label> </span>
<input name="Apports" id="Apports" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['Apports'], 2, '.', ' ');?>"/>¤
</div>
</div>
<!--fin col gauche-->
<div id="colmid">
<div class="ligne">
<span class="libelle2">
<label for="Salaire1">Salaire 1 :</label></span>
<input class="numerique" name="Salaire1" id="Salaire1" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['Salaire1'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle2">
<label for="Salaire2">Salaire 2 :</label></span>
<input class="numerique" name="Salaire2" id="Salaire2" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['Salaire2'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle2">
<label for="RevenuLocatif">Revenus locatifs :</label>
</span>
<input class="numerique" name="RevenuLocatif" id="RevenuLocatif" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['RevenuLocatif'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle2">
<label for="RevenuCompl">Revenus Compl. :</label>
</span>
<input class="numerique" name="RevenuCompl" id="RevenuCompl" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['RevenuCompl'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle2">
<label for="AllocFam">Alloc. familiales :</label>
</span>
<input class="numerique" name="AllocFam" id="AllocFam" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['AllocFam'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle2"><label for="AideAulog">Aide au logement :</label></span>
<input class="numerique" name="AideAulog" id="AideAulog" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['AideAulog'], 2, '.', ' ');?>"/>¤
</div>
<div class="ligne">
<span class="libelle2"><label for="RevenuFiscalRef">Rev. fisc. de réf. :</label></span>
<input class="numerique" name="RevenuFiscalRef" id="RevenuFiscalRef" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['RevenuFiscalRef'], 2, '.', ' ');?>"/>¤
</div>
<br> <br /> <br /><br /><br />
<div class="percent">
<input name="TauxEndAvecOperation" id="TauxEndAvecOperation" size="6" maxlength="6" type="text" value="<?php echo number_format($operations['TauxEndAvecOperation'], 2, '.', ' ');?>"/>
</div></div>
<!--fin col mid-->
<div id="coladresseProj">
<textarea name="AdresseProjet" cols="17" rows="2" id="AdresseProjet" class="adressebien"><?php echo $operations['AdresseProjet'];?></textarea>
</div>
<div id="boxdrte">
<div style="font-weight:bold; font-size:110%">
<span class="libelle"><label for="MontantFinancement">Mt à Financer :</label></span>
<input name="MontantFinancement" id="MontantFinancement" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['MontantFinancement'], 2, '.', ' ');?>"/>¤
</div>
<div style="font-weight:bold; font-size:110%">
<span class="libelle"><label for="MontantTauxZero">Mt Tx ZÉRO :</label></span>
<input name="MontantTauxZero" id="MontantTauxZero" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['MontantTauxZero'], 2, '.', ' ');?>"/>¤
</div>
<div style="font-weight:bold; font-size:110%">
<span class="libelle"><label for="TotalAfinancer">Total à financer :</label></span>
<input name="TotalAfinancer" id="TotalAfinancer" size="9" maxlength="9" type="text" value="<?php echo number_format($operations['TotalAfinancer'], 2, '.', ' ');?>"/>¤
</div>
</div><!--fin boxdrte-->
<div class="patrimoine">
<?php echo "<table>" ; ?>
<?php foreach ($bdpatrimoine as $patrimoine): ?>
<?php echo "<tr><td class=\"type\">" .htmlspecialchars($patrimoine['TypeDeBien'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td class=\"type\">" .htmlspecialchars($patrimoine['AdresseBien'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td class=\"crd\">" .htmlspecialchars(number_format($patrimoine['ValeurBien'], 2, '.', ' '), ENT_QUOTES, 'utf-8'). " ¤</td>" ; ?>
<?php echo "<td class=\"crd\">" .htmlspecialchars(number_format($patrimoine['CRD'], 2, '.', ' '), ENT_QUOTES, 'utf-8'). " ¤</td>" ; ?>
<?php endforeach; ?>
<?php echo "</tr></table>"; ?></div> <br />
<div class="bank">
<input name="Banque1" id="Banque1" size="25" maxlength="25" type="text" value="<?php echo $operations['Banque1'];?>" />
<input name="Banque2" id="Banque2" size="25" maxlength="25" type="text" value="<?php echo $operations['Banque2'];?>" />
<input name="Banque3" id="Banque3" size="25" maxlength="25" type="text" value="<?php echo $operations['Banque3'];?>" />
<input name="Banque4" id="Banque4" size="25" maxlength="25" type="text" value="<?php echo $operations['Banque4'];?>" />
</div>
<div class="charges">
<?php echo "<table>" ; ?>
<?php foreach ($bdpret as $pret): ?>
<form action ="CONSULTER" method="POST">
<?php echo "<tr><td class=\"type\">" .htmlspecialchars($pret['Titre'], ENT_QUOTES, 'utf-8'). "</td>" ; ?>
<?php echo "<td class=\"type2\">" .htmlspecialchars(number_format($pret['CRD'], 2, '.', ' '), ENT_QUOTES, 'utf-8'). " ¤</td>" ; ?>
<?php echo "<td class=\"crd\">" .htmlspecialchars(number_format($pret['Ech'], 2, '.', ' '), ENT_QUOTES, 'utf-8'). " ¤</td>" ; ?>
<?php echo "<td class=\"crd\">" ?><input type="checkbox" value="1" <?php if ($pret['Charges']=='1') echo ' checked="checked" ';?>><?php ".</td>" ?>
<?php endforeach; ?>
</form>
<?php echo "</tr></table>"; ?>
<?php endforeach;
?>
</div>
<?PHP
function changedateusfr($dateus)
{
$datefr=$dateus{8}.$dateus{9}."-".$dateus{5}.$dateus{6}."-".$dateus{0}.$dateus{1}.$dateus{2}.$dateus{3};
return $datefr;
}
?>
<? foreach ($bdparametres as $parametre): ?>
<!--div id="infospro">
<label for="Adr1Soc">SM COM - Siège social et agence commerciale :</label></span>
<input name="Adr1Soc" id="Adr1Soc" size="25" maxlength="25" type="text" value="<?php echo $parametre['Adr1Soc'];?>" /> -
<input name="CPSoc" id="CPSoc" size="5" maxlength="5" type="text" value="<?php echo $parametre['CPSoc'];?>" />
<input name="VilleSoc" id="VilleSoc" size="25" maxlength="25" type="text" value="<?php echo $parametre['VilleSoc'];?>" /><br />
<input name="StatutSoc" id="StatutSoc" size="4" maxlength="4" type="text" value="<?php echo $parametre['StatutSoc'];?>" />
<label for="StatutSoc">au capital de </label></span>
<input name="CapitalSoc" id="CapitalSoc" size="5" maxlength="5" type="text" value="<?php echo $parametre['CapitalSoc'];?>" />
<label for="capitalSoc"> ¤ - Siret :</label></span>
<input name="SiretSoc" id="SiretSoc" size="14" maxlength="14" type="text" value="<?php echo $parametre['SiretSoc'];?>" />
<label for="RCSSoc"> - RCS </label></span>
<input name="RCSSoc" id="RCSSoc" size="15" maxlength="15" type="text" value="<?php echo $parametre['RCSSoc'];?>" />
<label for="APESoc"> - APE </label></span>
<input name="APESoc" id="APESoc" size="6" maxlength="6" type="text" value="<?php echo $parametre['APESoc'];?>" /><br />
<label for="TelSoc">Tél. :</label></span>
<input name="TelSoc" id="TelSoc" size="15" maxlength="15" type="text" value="<?php echo $parametre['TelSoc'];?>" />
<label for="FaxSoc">Fax :</label></span>
<input name="FaxSoc" id="FaxSoc" size="15" maxlength="15" type="text" value="<?php echo $parametre['FaxSoc'];?>" /> -
<input name="SiteInternetSoc" id="SiteInternetSoc" size="18" maxlength="18" type="text" value="<?php echo $parametre['SiteInternetSoc'];?>" />
<label for="EmailSoc">- e-mail :</label></span>
<input name="EmailSoc" id="EmailSoc" size="22" maxlength="22" type="text" value="<?php echo $parametre['EmailSoc'];?>" />
</div-->
<? endforeach; ?> <br /><br />
</div> <!--fin de wrapper -->
</div>
</body>
</html>
voila j'éspére que cela t'aidera et que tu pourras m'aider
Aurélie
|