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 64 65 66 67 68 69 70 71 72 73 74 75 76 77
|
</br></br>
<b> FRANCE </b>
<table border="1">
<tr style="text-align: center; background-color:#FFAD5B; font-weight:bold;">
<th> France </th>
<th> Prestataire </th>
<th> V G </th>
<th> Commandes </th>
<th> Tx Conv. </th>
<th> C.A </th>
<th> Mmc </th>
</tr>
<?php
// REQUETE 1 : chercher les prestataires et les regrouper par les 3 premiere lettres et compter le nombre de voyance gratuite
$query = "SELECT (customers_from ) AS Origin,
COUNT(*) AS effectif_vg
FROM customers
WHERE customers_id>='0'
" . $condition . "
GROUP BY Origin ";
$result_vg = mysql_query($query) ;
while ($row = mysql_fetch_array($result_vg))
{
// REQUETE 2 : REQUETE QUI VA RECUPERER LES DONNES DE VG, NB DE COMMANDES, CA, MMC
$query_produit =
" SELECT
COUNT(DISTINCT cu.customers_id) AS effectif, count(co.commandes_status) AS command,
AVG(co.commandes_montant) AS Mmc
FROM customers cu
INNER JOIN commandes co
ON cu.customers_id=co.customers_id
WHERE co.commandes_status='1'
and customers_from LIKE '{$row['Origin']}%' " . $condition . "
";
if ($row['Origin'] == '') {
$query_produit = " SELECT
COUNT(DISTINCT cu.customers_id) AS effectif, count(co.commandes_status) AS command,
AVG(co.commandes_montant) AS Mmc
FROM customers cu
INNER JOIN commandes co
ON cu.customers_id=co.customers_id
WHERE co.commandes_status='1'
and customers_from = '' " . $condition . "
";
}
$result = mysql_query($query_produit) ;
while ($row1 = mysql_fetch_array($result))
{
?>
<tr>
<td style="background-color:#CCCCCC;"> </td>
<td style="text-align:center;"> <?php echo $row['Origin'] ?> </td>
<td style="text-align:center;"> <?php echo $row['effectif_vg'] ?> </td>
<td style="text-align:center;"> <?php echo $row1['command'] ?> </td>
<td style="text-align:center;"><?php echo round(($row1['command'] / $row['effectif_vg']) * 100, 2); ?> % </td>
<td style="text-align:center;"> <?php echo round($row1['command']*$row1['Mmc']) ?> </td>
<td style="text-align:center;"> <?php echo round($row1['Mmc'] ,2) ?> </td>
<?php
}
}
?>
</tr>
</table> |
Partager