Undefined
By: verlopen | Date: Dec 9 2007 19:52 | Format: PHP | Expires: never | Size: 1.89 KB | Hits: 1406
- <?php
- FROM bestellingen
- LEFT JOIN producten
- ON producten.id = bestellingen.product_id
- LEFT JOIN klanten
- ON klanten.id = bestellingen.klant_id
- ORDER by order_nr DESC");
- if ($row['status'] == 0)
- $orderstatus = '<span class="blauw">ongevalideerd</span>';
- if ($row['status'] == 1)
- $orderstatus = '<span class="oranje">goedgekeurd</span>';
- if ($row['status'] == 2)
- $orderstatus = '<span class="groen">betaald</span>';
- if ($tijd > $row['timestamp'])
- $orderstatus = '<span class="rood">verlopen</span>';
- $oudenr = $nieuwnr;
- $nieuwnr = $row['order_nr'];
- if ($oudenr != $nieuwnr) { // dus een volgende bestelling
- if ($tijd < $row['timestamp']) {
- print ' <tr>
- <td class="s_left">Door:</td>
- <td class="s_right">
- <a href="users.php?id='.$row['klant_id'].'">'.$row['voornaam'].' '.$row['achternaam'].'</a>
- </td>
- </tr>
- <tr>
- <td class="s_left">Factuur:</td>
- <td class="s_right">'.$row['jaar'].''.$row['order_nr'].'</td>
- </tr>
- <tr>
- <td class="s_left">Producten:</td>
- <td class="s_right">'.$row['naam'].'</td>
- </tr>
- <tr>
- <td class="s_left">Tijdstip:</td>
- <td class="s_right">'.timetodate($row['timestamp']).'</td>
- </tr>
- <tr>
- <td class="s_left">Status:</td>
- <td class="s_right">'.$orderstatus.'</td>
- </tr>
- <tr>
- <td colspan="2"> </td>
- </tr>';
- }
- }
- }
- }
- ?>
Latest pastes
1 days ago
1 days ago
2 days ago
4 days ago
5 days ago