--- trunk/tntnet/dynamic/installationdetails.ecpp	2007/11/30 16:05:11	111
+++ trunk/tntnet/dynamic/installationdetails.ecpp	2007/12/05 14:39:35	159
@@ -35,7 +35,7 @@
 conn = tntdb::connect(dburl);
 
 std::stringstream query;
-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 ";
 query << "FROM installation i INNER JOIN customer c ON c.id = i.customerid ";
 query << "WHERE i.id = " << id;
 
@@ -72,26 +72,30 @@
 		<td>Update rate: </td>
 		<td><$ res[0].getInt(5) $></td>
 	</tr>
+	<tr>
+		<td>Comm. status: </td>
+		<td><img src="bullet?rgb=<$ (res[0].getBool(6) ? "ff0000" : "00ff00") $>" alt="Status Indicator"></td>
+	</tr>
 
 
 	</table>
 
 
-	<p align="center"><img src="temperaturegraph?id=<$id$>"></p>
+	<p align="center"><img src="temperaturegraph?id=<$id$>" alt="Temperature graph"></p>
 
 	<{
 	query.str(""); //reset stringstream
 	query << "SELECT messagenr, date_trunc('second', logtime) AS logtime, temperature, flamedetector, solidfuelempty, conveyorerror,powerfailure ";
 	query << "FROM logtable ";
 	query << "WHERE installationnr = " << id;
-	query << "ORDER BY messagenr DESC";
+	query << "ORDER BY messagenr DESC, logtime DESC ";
 	res = conn.select(query.str());	
 
 
 	out << "<table border=1 cellspacing=0 align='center'>\n";
 	out << "<tr><th>&nbsp;Message#&nbsp;</th><th>&nbsp;Logtime&nbsp;</th><th>&nbsp;Temperature&nbsp;</th><th>&nbsp;Flamedetector&nbsp;</th><th>&nbsp;Solidfuel empty&nbsp;</th><th>&nbsp;Conveyor error&nbsp;</th><th>&nbsp;Power failure&nbsp;</th></tr>\n";
 
-	for (int i=0; i<res.size(); ++i)
+	for (unsigned int i=0; i<res.size(); ++i)
 	{
 		int messagenr = res[i].getInt(0);
 		std::string logtime = res[i].getString(1);
@@ -115,6 +119,7 @@
 				
 		out << "</tr>";
 	}
+	out << "</table>\n";
 
 
 	}>