tntnet/dynamic/adm_send_config.ecpp

<%pre>
#include <tntdb/connect.h>
#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>
dburl;
</%config>

<%session scope="global">
std::string userName;
bool isAdmin;
</%session>

<{
if (userName.size() == 0)
{
        reply.setHeader("Location", "index");
        return HTTP_MOVED_TEMPORARILY;
}
}>


<&header title="Send configuration">
</&header>

<{

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>
1	torben	104	<%pre>
2			#include <tntdb/connect.h>
3			#include <tntdb/connection.h>
4			#include <tntdb/result.h>
5			#include <tntdb/row.h>
6	torben	124
7
8			std::string createInstallationSelector(tntdb::Connection& conn)
9			{
10			std::stringstream out;
11			tntdb::Result res = conn.select("SELECT c.name, i.id, i.description FROM customer c INNER JOIN installation i ON c.id = i.customerid");
12
13			out << "<select name='installation'>\n";
14
15			for (int i=0; i<res.size(); ++i)
16			{
17			out << " <option value='" << res[i].getInt(1) << "'>" << res[i].getString(0) << " :: " << res[i].getString(2) << "</option>\n";
18			}
19			out << "</select>\n";
20
21
22			return out.str();
23			}
24
25
26	torben	104	</%pre>
27
28			<%config>
29			dburl;
30			</%config>
31
32			<%session scope="global">
33			std::string userName;
34			bool isAdmin;
35			</%session>
36
37			<{
38			if (userName.size() == 0)
39			{
40			reply.setHeader("Location", "index");
41			return HTTP_MOVED_TEMPORARILY;
42			}
43			}>
44
45
46			<&header title="Send configuration">
47			</&header>
48
49			<{
50
51			tntdb::Connection conn = tntdb::connect(dburl);
52
53	torben	124	std::ostream& out = reply.out();
54
55
56			if (qparam.param("command").size() > 0)
57			{
58			std::string command = qparam.param("command");
59			std::string installation = (command == "2" ? qparam.param("installation") : "null");
60			std::stringstream sql;
61			sql << "INSERT INTO command (created,commandid, installationid) ";
62			sql << "VALUES (now(), " << command << ", " << installation << ")";
63			conn.execute( sql.str() );
64			}
65
66	torben	104	}>
67
68	torben	124	<h2>Send configuration</h2>
69
70			<table border=1 align='center' cellspacing=0 cellpadding=5>
71			<tr>
72			<th colspan='2'>
73			Send Commands
74			</th>
75			</tr>
76			<tr>
77			<td>
78			<form method='post' action='adm_send_config'>
79			<input type='hidden' name='command' value='1'>
80			<input type='submit' value='Send configuration to all'>
81			</form>
82			</td>
83			<td>
84			<form method='post' action='adm_send_config'>
85			<input type='hidden' name='command' value='2'>
86			<$$ createInstallationSelector( conn ) $><br>
87			<input type='submit' value='Send configuration to selected'>
88			</form>
89			</td>
90			</tr>
91			</table>
92
93
94			<{
95
96
97			//////////////////////////////////////////////////////////////////////////////////////
98			// Command Log
99
100			/* commandid 1 -> Send to all
101			* commandid 2 -> Send to one
102			*/
103			std::string query;
104			query += "SELECT name,description,date_trunc('second',created) AS created, date_trunc('second', executed) AS executed,commandid,installationid ";
105			query += "FROM command ";
106			query += "LEFT JOIN installation ON command.installationid = installation.id ";
107			query += "LEFT JOIN customer ON installation.customerid = customer.id ";
108			query += "ORDER BY created DESC ";
109
110			tntdb::Result res = conn.select(query);
111
112			out << "<p align='center'><b>Command history</b></p>\n";
113			out << "<table cellspacing='0' align='center' border='1'>";
114			out << "<tr><th> Created </th><th> Executed </th><th>Command</th></tr>\n";
115
116			for (int i=0; i<res.size(); ++i)
117			{
118			out << "<tr><td>" << res[i].getString(2) << "</td>";
119			out << "<td>" << res[i].getString(3) << "</td>";
120
121			out << "<td>";
122
123			switch ( res[i].getInt(4) )
124			{
125			case 1:
126			out << "Send configuration to All";
127			break;
128			case 2:
129			out << "Send configuration to <i>" << res[i].getString(0) << " :: " << res[i].getString(1) << "</i>";
130			break;
131			default:
132			out << "Unknown command";
133			break;
134			}
135			out << "</td>\n";
136
137			out << "</tr>\n";
138			}
139
140
141			}>
142
143			</table>
144
145	torben	104	<&footer>
146			</&footer>