jenny50 | Bonjour, c'est la première fois que je fais des calculs de données via une bdd. J'aimerai avoir votre avis sur mon code et surtout savoir comment je peux faire un sous total de mes filiales, un total de mes marques.
dans l'ordre concession<filiales<marque
Merci d'avance
Code :
- <?php
- require('fonctions.php');
- $conn = g_connect();
- $sql = " SELECT conc_lib, objcomd_valeur, comd_valvn, comd_vallogan, comd_valpart, comd_valmarch, fil_cle, fil_lib, marq_lib FROM commandes INNER JOIN concessions ON conc_cle = comd_concession INNER JOIN objectifscomd ON objcomd_concession = comd_concession INNER JOIN filiales ON conc_filiale = fil_cle INNER JOIN marques ON fil_marque = marq_cle ";
- $qry = pg_query($conn, $sql);
- ?>
- <table cellpadding="0" cellspacing="0" border="0" align="center" width="90%">
- <tr>
- <td align="center">
- <table align="center" border="0" bordercolor="#333399" cellpadding="0" cellspacing="0" width="100%">
- <tr>
- <td align="center" width="20%"> </td>
- <td align="center" width="10%" class="texte_b">Contrats</td>
- <td align="center" width="35%">
- <table align="center" cellpadding="0" cellspacing="0" border="0" width="100%">
- <tr>
- <td align="center" colspan="3" class="texte_b">Commandes VN</td>
- </tr>
- <tr>
- <td align="center" width="33%" class="texte_b">nombre</td>
- <td align="center" width="33%" class="texte_b">%contrat</td>
- <td align="center" width="33%" class="texte_b">Logan</td>
- </tr>
- </table>
- </td>
- <td align="center" width="35%">
- <table align="center" cellpadding="0" cellspacing="0" border="0" width="100%">
- <tr>
- <td align="center" colspan="3" class="texte_b">Commandes VO</td>
- </tr>
- <tr>
- <td align="center" width="40%" class="texte_b">particuliers</td>
- <td align="center" width="20%" class="texte_b">marchands</td>
- <td align="center" width="20%" class="texte_b">total</td>
- </tr>
- </table>
- </td>
- </tr>
- <?
- while ($result = pg_fetch_assoc($qry))
- {
- $fil = $result['fil_cle'];
- ?>
- <tr>
- <td align="left" width="20%" class="texte"><?=$result['conc_lib']?></td>
- <td align="left" width="10%" class="texte"><?=$result['objcomd_valeur']?></td>
- <td align="center" width="35%">
- <table align="center" cellpadding="0" cellspacing="0" border="0" width="100%">
- <tr>
- <td align="center" width="33%" class="texte"><?=$result['comd_valvn']?></td>
- <td align="center" width="33%" class="texte"><? echo ' '.round(($result['comd_valvn'] * 100)/$result['objcomd_valeur'], 2).' %'?></td>
- <td align="center" width="33%" class="texte"><?=$result['comd_vallogan']?></td>
- </tr>
- </table>
- </td>
- <td align="center" width="35%">
- <table align="center" cellpadding="0" cellspacing="0" border="0" width="100%">
- <tr>
- <td align="center" width="25%" class="texte"><?=$result['comd_valpart']?></td>
- <td align="center" width="25%" class="texte"><? echo ' '.round(($result['comd_valpart'] * 100)/$result['objcomd_valeur'], 2).' %'?></td>
- <td align="center" width="25%" class="texte"><?=$result['comd_valmarch']?></td>
- <td align="center" width="25%" class="texte"><?=$result['comd_valpart'] + $result['comd_valmarch']?></td>
- </tr>
- </table>
- </td>
- </tr>
- <?
- }
- ?>
- </table>
|
|