--- trunk/tntnet/dynamic/customerlist.ecpp	2007/11/27 17:08:11	71
+++ trunk/tntnet/dynamic/customerlist.ecpp	2007/11/27 22:25:36	74
@@ -5,6 +5,8 @@
 #include <tntdb/row.h>
 
 #include "common.h"
+
+#include <sstream>
 </%pre>
 
 <%config>
@@ -32,11 +34,44 @@
 	for (tntdb::Result::const_iterator it = res.begin(); it != res.end(); ++it)
 	{
 		tntdb::Row row = *it;
-		out << "<table border=1 width=80% cellspacing=0 align=center><tr><td>";
+		int customerid = row.getInt(0);
+		out << "<table border=1 width='80%' cellspacing=0 align=center><tr><td>";
 		out << "<b>" << row.getString(1) << "</b><br>\n\n";
 
 
-		out << nl2br(row.getString(2)) << "<br>\n";
+		out << nl2br(trim(row.getString(2))) << "<br>\n";
+
+		out << "<i>Phone:</i> " << row.getString(3) << "<br>\n";
+		out << "<i>Contact:</i> " << row.getString(4) << "<br>\n";
+
+		out << "<br>\n";
+
+
+		std::stringstream sqlstream;
+		sqlstream << "SELECT id, description FROM installation ";
+		sqlstream << "WHERE customerid = " << customerid;
+
+		tntdb::Result instres = conn.select(sqlstream.str());
+
+		if (instres.size() > 0)
+		{
+			out << "Installations:\n";
+			out << "<ol style='margin-top:0px;'>\n";
+			for (tntdb::Result::const_iterator instit = instres.begin(); instit != instres.end(); ++instit)
+			{
+				tntdb::Row instrow = *instit;
+				out << "<li><a href='installationdetails?id=" << instrow.getString(0) << "'>";
+				out << instrow.getString(1) << "</a></li>";
+			}
+			out << "</ol>\n";
+		}
+		else
+		{
+			out << "<i>No installations !</i>\n";
+		}
+
+
+
 
 
 		out << "</td></tr></table><br>\n";