--- trunk/tntnet/dynamic/installationdetails.ecpp	2007/11/30 16:03:46	110
+++ trunk/tntnet/dynamic/installationdetails.ecpp	2007/11/30 16:05:11	111
@@ -3,6 +3,16 @@
 #include <tntdb/connection.h>
 #include <tntdb/result.h>
 #include <tntdb/row.h>
+
+#include <sstream>
+#include "common.h"
+
+
+inline std::string convert_bool(bool input)
+{
+	return input ? "on" : "off";
+}
+
 </%pre>
 
 <%config>
@@ -12,12 +22,111 @@
 <&header title="Installation details">
 </&header>
 
+<%args>
+int id;
+</%args>
+
 <h2>Installation details</h2>
 
+
 <{
 tntdb::Connection conn;
 
-conn = tntdb::connect(dburl); //letting exceptions flow up and to tntnet and let it display an error message
+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 << "FROM installation i INNER JOIN customer c ON c.id = i.customerid ";
+query << "WHERE i.id = " << id;
+
+std::ostream& out = reply.out();
+
+tntdb::Result res = conn.select(query.str());
+
+if (res.size() >0 )
+{
+}>
+
+	<table border=1 cellspacing=0 align='center'>
+	<tr>
+		<td><b>Customer</b>: </td>
+		<td><b><$ res[0].getString(0) $></b></td>
+	</tr>
+	<tr>
+		<td>Customer address: &nbsp;</td>
+		<td><$$ nl2br(res[0].getString(1)) $></td>
+	</tr>
+	<tr>
+		<td><b>Installation: </b></td>
+		<td><b><$ res[0].getString(2) $></b></td>
+	</tr>
+	<tr>
+		<td>Location: </td>
+		<td><$$ nl2br(res[0].getString(3)) $></td>
+	</tr>
+	<tr>
+		<td>Furnace type: </td>
+		<td><$ res[0].getString(4) $></td>
+	</tr>
+	<tr>
+		<td>Update rate: </td>
+		<td><$ res[0].getInt(5) $></td>
+	</tr>
+
+
+	</table>
+
+
+	<p align="center"><img src="temperaturegraph?id=<$id$>"></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";
+	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)
+	{
+		int messagenr = res[i].getInt(0);
+		std::string logtime = res[i].getString(1);
+		int temperature = res[i].getInt(2);
+		bool flamedetector = res[i].getBool(3);
+		bool solidfuelempty = res[i].getBool(4);
+		bool conveyorerror = res[i].getBool(5);
+		bool powerfailure = res[i].getBool(6);
+
+		std::string critical = " class='critical'";
+
+		out << "<tr>";
+
+		out << "<td align='center'>" << messagenr << "</td>\n"; 
+		out << "<td align='center'>" << logtime << "</td>\n"; 
+		out << "<td align='center'" << (temperature >90 ? critical : "" ) << ">" << temperature << "</td>\n"; 
+		out << "<td align='center'" << (flamedetector==false ? critical : "") << ">" << convert_bool(flamedetector) << "</td>\n";  
+		out << "<td align='center'>" << convert_bool(solidfuelempty) << "</td>\n"; 
+		out << "<td align='center'" << (conveyorerror==true ? critical : "") << ">" << convert_bool(conveyorerror) << "</td>\n"; 
+		out << "<td align='center'" << (powerfailure==true ? critical : "") << ">" << convert_bool(powerfailure) << "</td>\n"; 
+				
+		out << "</tr>";
+	}
+
+
+	}>
+
+
+
+<{
+} 
+else 
+{
+	reply.out() << "<i>No installation with this ID</i>";
+}
 
 }>