35 |
conn = tntdb::connect(dburl); |
conn = tntdb::connect(dburl); |
36 |
|
|
37 |
std::stringstream query; |
std::stringstream query; |
38 |
query << "SELECT c.name, c.address AS caddress, i.description, i.address AS iadress, i.furnacetype, i.updaterate "; |
query << "SELECT c.name, c.address AS caddress, i.description, i.address AS iadress, i.furnacetype, i.updaterate, i.commerror "; |
39 |
query << "FROM installation i INNER JOIN customer c ON c.id = i.customerid "; |
query << "FROM installation i INNER JOIN customer c ON c.id = i.customerid "; |
40 |
query << "WHERE i.id = " << id; |
query << "WHERE i.id = " << id; |
41 |
|
|
72 |
<td>Update rate: </td> |
<td>Update rate: </td> |
73 |
<td><$ res[0].getInt(5) $></td> |
<td><$ res[0].getInt(5) $></td> |
74 |
</tr> |
</tr> |
75 |
|
<tr> |
76 |
|
<td>Comm. status: </td> |
77 |
|
<td><img src="bullet.php?rgb=<$ (res[0].getBool(6) ? "ff0000" : "00ff00") $>"></td> |
78 |
|
</tr> |
79 |
|
|
80 |
|
|
81 |
</table> |
</table> |