1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
| <table align="center" id="tab_jtrav" class="sortie_jrnal_travaux" style="width:100%" >
<tr>
<th style="width:10%;text-align:center">Service</th>
<th style="width:15%;text-align:center">Designation</th>
<th style="width:15%;text-align:center">Quantité</th>
<th style="width:16%;text-align:center">Prix unitaire</th>
<th style="width:8%;text-align:center">Montant</th>
</tr>
<?php
include(dirname(__FILE__).'/../functions.php');
$bdd_MCHNMFT=connect();
$repponseart_bon_sorties = $bdd_MCHNMFT->query('select SV.nom_service,AR.designation_article
, ST.prix_unitaire
, sum(ST.montant) as mt
, sum(ST.quantite_sortie) as qte
from services as SV
inner join bon_travauxservices as BN
on BN.service_id = SV.service_id
inner join sorties_bon as ST
on ST.bontravaux_id = BN.bontravaux_id
inner join articles as AR
on AR.article_id = ST.article_id
group by SV.nom_service
, AR.designation_article
, ST.prix_unitaire
order by SV.nom_service
, AR.designation_article ');
while ($donnees_lesbon_mod = $repponseart_bon_sorties->fetch())
{
$nom_service=$donnees_lesbon_mod['nom_service'];
$designation_article=$donnees_lesbon_mod['designation_article'];
$prix_unitaire=$donnees_lesbon_mod['prix_unitaire'];
$qte=$donnees_lesbon_mod['qte'];
$mt=$donnees_lesbon_mod['mt'];
?>
<tr>
<td><input type="text" value="<?= $nom_service ?>" disabled="disabled" size="12"/></td>
<td><input type="text" value="<?= $designation_article ?>" disabled="disabled" size="12"/></td>
<td><input type="text" value="<?= $prix_unitaire ?>" disabled="disabled" size="12"/></td>
<td><input type="text" value="<?= $qte ?>" disabled="disabled" size="12"/></td>
<td><input type="text" value="<?= $mt ?>" disabled="disabled" size="12"/></td>
</tr>
<?php
}
?>
</table> |
Partager