1 |
<?php |
2 |
require("header.php"); |
3 |
include "inc/mysql.php"; |
4 |
?> |
5 |
|
6 |
|
7 |
<h3>SMS Jobs</h3> |
8 |
|
9 |
<?php |
10 |
|
11 |
$rows = query(" |
12 |
SELECT enheder,individer,besked,antalmodtagere, format(samletpris,2) as samletpris,tidspunkt |
13 |
FROM smsjob |
14 |
ORDER BY tidspunkt desc |
15 |
"); |
16 |
|
17 |
|
18 |
echo "<table border='0'>"; |
19 |
echo "<tr><th width='150'>Enheder</th><th width='250'>Individer</th><th width='400'>Tekst</th><th>Antal Modtagere</th><th>Samlet pris</th><th>Tidspunkt</th></tr>\n"; |
20 |
|
21 |
|
22 |
$i = 0; |
23 |
|
24 |
foreach($rows as $row) { |
25 |
$besked = utf8_decode($row->besked); |
26 |
$style = ($i == 0) ? "even" : "odd"; |
27 |
|
28 |
$individer = utf8_decode($row->individer); |
29 |
$individer = str_replace("|", "| ", $individer); |
30 |
|
31 |
$enheder = utf8_decode($row->enheder); |
32 |
$enheder = str_replace("|", "| ", $enheder); |
33 |
|
34 |
echo "<tr class='{$style}'>"; |
35 |
echo "<td>{$enheder}</td><td>{$individer}</td><td>{$besked}</td><td>{$row->antalmodtagere}</td><td>{$row->samletpris}</td><td>{$row->tidspunkt}</td>"; |
36 |
echo "</tr>\n"; |
37 |
|
38 |
$i = ($i+1)%2; |
39 |
} |
40 |
echo "</table>"; |
41 |
|
42 |
|
43 |
require("footer.php"); |
44 |
?> |