--- trunk/tntnet/dynamic/adm_send_config.ecpp	2007/12/02 17:12:00	123
+++ trunk/tntnet/dynamic/adm_send_config.ecpp	2007/12/02 19:32:52	124
@@ -3,6 +3,26 @@
 #include <tntdb/connection.h>
 #include <tntdb/result.h>
 #include <tntdb/row.h>
+
+
+std::string createInstallationSelector(tntdb::Connection& conn)
+{
+	std::stringstream out;
+	tntdb::Result res = conn.select("SELECT c.name, i.id, i.description FROM customer c INNER JOIN installation i ON c.id = i.customerid");
+	
+	out << "<select name='installation'>\n";
+
+	for (int i=0; i<res.size(); ++i)
+	{
+		out << " <option value='" << res[i].getInt(1) << "'>" << res[i].getString(0) << " :: " << res[i].getString(2) << "</option>\n";	
+	}
+	out << "</select>\n";
+	
+
+	return out.str();
+}
+
+
 </%pre>
 
 <%config>
@@ -30,7 +50,97 @@
 
 tntdb::Connection conn = tntdb::connect(dburl);
 
+std::ostream& out = reply.out();
+
+
+if (qparam.param("command").size() > 0)
+{
+	std::string command = qparam.param("command");
+	std::string installation = (command == "2" ? qparam.param("installation") : "null");
+	std::stringstream sql;
+	sql << "INSERT INTO command (created,commandid, installationid) ";
+	sql << "VALUES (now(), " << command << ", " << installation << ")";
+	conn.execute( sql.str() );
+}
+
+}>
+
+<h2>Send configuration</h2>
+
+<table border=1 align='center' cellspacing=0 cellpadding=5>
+<tr>
+  <th colspan='2'>
+    Send Commands
+  </th>
+</tr>
+<tr>
+  <td>
+    <form method='post' action='adm_send_config'>
+      <input type='hidden' name='command' value='1'>
+      <input type='submit' value='Send configuration to all'>
+    </form>
+  </td>
+  <td>
+    <form method='post' action='adm_send_config'>
+	  <input type='hidden' name='command' value='2'>
+	  <$$ createInstallationSelector( conn ) $><br>
+	  <input type='submit' value='Send configuration to selected'>
+	</form>
+  </td>
+</tr>
+</table>
+
+
+<{
+
+
+//////////////////////////////////////////////////////////////////////////////////////
+// Command Log
+
+/* commandid 1 -> Send to all
+ * commandid 2 -> Send to one
+ */
+std::string query;
+query += "SELECT name,description,date_trunc('second',created) AS created, date_trunc('second', executed) AS executed,commandid,installationid ";
+query += "FROM command ";
+query += "LEFT JOIN installation ON command.installationid = installation.id ";
+query += "LEFT JOIN customer ON installation.customerid = customer.id ";
+query += "ORDER BY created DESC ";
+
+tntdb::Result res = conn.select(query);
+
+out << "<p align='center'><b>Command history</b></p>\n";
+out << "<table cellspacing='0' align='center' border='1'>";
+out << "<tr><th>&nbsp;Created&nbsp;</th><th>&nbsp;Executed&nbsp;</th><th>Command</th></tr>\n";
+
+for (int i=0; i<res.size(); ++i)
+{
+	out << "<tr><td>" << res[i].getString(2) << "</td>";
+	out << "<td>" << res[i].getString(3) << "</td>";
+
+	out << "<td>";
+
+	switch ( res[i].getInt(4) )
+	{
+		case 1:
+			out << "Send configuration to All";
+			break;
+		case 2:
+			out << "Send configuration to <i>" << res[i].getString(0) << " :: " << res[i].getString(1) << "</i>";
+			break;
+		default:
+			out << "Unknown command";
+			break;
+	}
+	out << "</td>\n";
+
+	out << "</tr>\n";
+}
+
+
 }>
 
+</table>
+
 <&footer>
 </&footer>