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 ORDER BY name,description");
        
        out << "<select name='installation'>\n";

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