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 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95
| <?php
/*
$client = mysql_real_escape_string($client);
$nom = mysql_real_escape_string($nom);
$sql = "SELECT * FROM factures WHERE client='$client' AND nom='$nom' ORDER BY ordre DESC LIMIT 5";
$res = mysql_query($sql) or die ('Erreur : '.mysql_error());
*/
$today = new DateTime('now');
$etat5 = 'fin de durée';
$etat6 = 'actif';
$data = array();
$i = -1;
$res[] = array(
'ordre' => '16',
'numero' => '8774559',
'client' => '94355867',
'nom' => 'lebaron',
'prenom' => 'olivier',
'date' => '05/11/2011',
'date_fin' => '10/11/2011',
'produit' => 'formule_Optimal',
'prix' => '5.40',
'type_achat' => 'allopass',
'duree' => '1',
'etat' => 'actif',
'transaction_id' => 'c12e1aaf-02e1-4770-9e03-0da6d8af1093',
'reglement' => 'micro/vir/ch/cb'
);
$res[] = array(
'ordre' => '15',
'numero' => '22958983',
'client' => '94355867',
'nom' => 'Lebaron',
'prenom' => 'olivier',
'date' => '11/11/2011',
'date_fin' => '11/11/2012',
'produit' => 'rottax2.com',
'prix' => '17.82 ttc',
'type_achat' => 'allopass',
'duree' => '1',
'etat' => 'actif',
'transaction_id' => 'f20e7f5f-a30f-4ea2-a07b-20c944282291',
'reglement' => 'micro/vir/ch/cb'
);
foreach($res as $row) {
//while($row = mysql_fetch_assoc($res)) {
$end = DateTime::createFromFormat('d/m/Y', $row['date_fin']);
$etat = ($today > $end) ? $etat5 : $etat6;
$sql = "UPDATE factures SET etat='$etat' WHERE nom='$nom' AND client='$client';";
//$exec = mysql_query($sql) or die ('Erreur : '.mysql_error());
if ($row['produit'] === 'points recharge') {
$row['renouveler'] = '<font size="1" color="green"><b>Achat points</b></font>';
}
else
if ($row['etat'] === $etat5) {
$row['renouveler'] = '<font size="1" color="red"><b><blink>Renouveler</blink></b></font>';
}
else {
$row['renouveler'] = '<font size="1" color="green"><b>Renouveler</b></font>';
}
$row['tr_class'] = (++$i % 2) ? 'class2' : 'class1';
$data[] = $row;
}
?>
<table width="560" border="0">
<thead>
<tr>
<th class="td1" width="155">Produits</th>
<th class="td1" width="157">Date achat</th>
<th class="td1" width="137">Date de fin</th>
<th class="td1" width="100">Etat</th>
<th class="td1" width="137">Durée</th>
<th class="td1" width="137">Renouveler</th>
</tr>
</thead>
<tbody>
<?php foreach($data as $row): ?>
<tr class="prem <?php echo $row['tr_class']; ?>">
<td width="130"><font size="1"><?php echo $row['produit']; ?></font></td>
<td width="130"><font size="1"><?php echo $row['date']; ?></font></td>
<td width="137"><font size="1"><?php echo $row['date_fin']; ?></font></td>
<td width="100"><font size="1"><?php echo $row['etat']; ?></font></td>
<td width="137"><font size="1"><?php echo $row['duree']; ?></font></td>
<td width="137"><?php echo $row['renouveler']; ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table> |
Partager