--- trunk/tntnet/dynamic/critical.ecpp	2007/11/27 14:28:59	68
+++ trunk/tntnet/dynamic/critical.ecpp	2007/12/08 16:47:03	195
@@ -1,11 +1,103 @@
+<%pre>
+#include <tntdb/connect.h>
+#include <tntdb/connection.h>
+#include <tntdb/result.h>
+#include <tntdb/row.h>
+
+</%pre>
+
 <%config>
 dburl;
 </%config>
 
 <&header title="Critical systems">
 </&header>
+<h2>Critical systems</h2>
+
+<{
+
+reply.setHeader("Refresh", "120");
+
+tntdb::Connection conn = tntdb::connectCached(dburl); 
+
+
+std::string query1;
+query1 += "SELECT c.name, i.description, i.id, i.commerror ";
+query1 += "FROM installation i INNER JOIN customer c ";
+query1 += "ON i.customerid = c.id";
+
+
+tntdb::Result inst_res = conn.select(query1);
+
+
+std::string query2;
+query2 += "SELECT temperature,flamedetector,conveyorerror,powerfailure ";
+query2 += "FROM logtable ";
+query2 += "WHERE installationnr = :v1 ";
+query2 += "ORDER BY messagenr DESC,logtime DESC ";
+query2 += "LIMIT 1";
+
+
+tntdb::Statement st = conn.prepare(query2);
+
+std::ostream& out = reply.out();
+
+bool hasCritical = false;
+
+for (unsigned i=0; i<inst_res.size(); i++)
+{
+	int id = inst_res[i].getInt(2);
+	st.clear();
+
+	st.setInt("v1", id);
+	tntdb::Result res = st.select();
+
+	bool commerror = inst_res[i].getBool(3);
+	int temperature = 50;
+	bool flameDetector = true;
+	bool conveyorError = false;
+	bool powerFailure = false;
+
+	if (res.size() > 0)
+	{
+		temperature = res[0].getInt(0);
+		flameDetector = res[0].getBool(1);
+		conveyorError = res[0].getBool(2);
+		powerFailure = res[0].getBool(3);
+	}
+
+	if (commerror || temperature > 90 || flameDetector == false || conveyorError || powerFailure)
+	{
+		out << "<a href='installationdetails?id=" << id << "'><b>" << inst_res[i].getString(0) << "</b> : " << inst_res[i].getString(1) << "<br></a>\n";
+		out << "<ul>";
+
+		if (temperature > 90)
+			out << "<li>High temperature</li>\n";
+
+		if (commerror)
+			out << "<li>Communication error</li>\n";
+
+		if (flameDetector == false)
+			out << "<li>No flames</li>\n";
+
+		if (conveyorError)
+			out << "<li>Conveyor error</li>\n";
+
+		if (powerFailure)
+			out << "<li>Power failure</li>\n";
+
+		out << "</ul>\n";
+
+		hasCritical = true;
+	}
+}
+
+if (hasCritical == false)
+{
+	out << "<i>No critical installations found</i>\n";
+}
 
-<$ dburl $>
+}>
 
 <&footer>
 </&footer>