tntnet/dynamic/adm_installation_edit.ecpp

<%pre>
#include <tntdb/connect.h>
#include <tntdb/connection.h>
#include <tntdb/result.h>
#include <tntdb/row.h>

#include <sstream>

#include "common.h"
</%pre>

<%config>
dburl;
</%config>

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

<%args>
int id;
int customerid;
std::string name;
</%args>

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


<&header title="Installation Administration">
</&header>


<{

if (id == -1)
        reply.out() << "<h2>New installation</h2>\n";
else
        reply.out() << "<h2>Modify installation</h2>\n";

reply.out() << "<a href='adm_installation_list?customerid=" << customerid<< "&name=" << name << "'>";
reply.sout() << "<< back to installation list";
reply.out() << "</a><br>";

tntdb::Connection conn = tntdb::connect(dburl); 


std::string submit = qparam.param("submit");
if (submit == "1")
{
        std::string form_description = trim(qparam.param("description"));
        std::string form_address = trim(qparam.param("address"));
        std::string form_furnacetype = trim(qparam.param("furnacetype"));
        std::string form_phonenr = trim(qparam.param("phonenr"));
        std::string form_imei = trim(qparam.param("imei"));
        int form_updaterate = atoi(trim(qparam.param("updaterate")).c_str());

        if (id == -1)
        {
                tntdb::Statement st = conn.prepare(
                        "INSERT INTO installation (customerid,description,address,furnacetype, installationphonenr,imei,updaterate ) values (:v1,:v2,:v3,:v4,:v5,:v6,:v7)");
                st.setInt("v1", customerid).setString("v2", form_description).setString("v3", form_address).setString("v4", form_furnacetype);
                st.setString("v5", form_phonenr).setString("v6",form_imei).setInt("v7", form_updaterate);
                st.execute();

                std::stringstream url;
                url << "adm_installation_list?customerid=" << customerid << "&name=" << name;

                reply.setHeader("Location", url.str());
                return HTTP_MOVED_TEMPORARILY;
        }
        else
        {
                tntdb::Statement st = conn.prepare(
                        "UPDATE installation SET description=:v1, address=:v2, furnacetype=:v3, installationphonenr=:v4, imei=:v5, updaterate=:v6 WHERE id=:v7");
                st.setString("v1", form_description).setString("v2", form_address).setString("v3", form_furnacetype).setString("v4", form_phonenr);
                st.setString("v5", form_imei); st.setInt("v6", form_updaterate).setInt("v7", id);
                st.execute();

                reply.out() << "<i>Installation updated</i><br>\n";
        }

}


std::string description;
std::string address;
std::string furnacetype;
std::string phonenr;
std::string imei;
std::string updaterate;

bool showForm = true;

if (id != -1)
{
        std::stringstream query;
        query << "SELECT description,address, furnacetype,installationphonenr,imei,updaterate FROM installation WHERE id = " << id;
        tntdb::Result res = conn.select(query.str());

        if (res.size() > 0)
        {
                description = res[0].getString(0);
                address = res[0].getString(1);
                furnacetype = res[0].getString(2);
                phonenr = res[0].getString(3);
                imei = res[0].getString(4);
                updaterate = res[0].getString(5);
        }

        else
        {
                reply.out() << "<p><i>Invalid installation ID !</i></p>\n";
                showForm = false;
        }
}

if (showForm)
{
}>

<form method="post" action="adm_installation_edit">
<table border="0">
<tr>
  <td>Description:</td>
  <td><input type="text" name="description" size="40" value="<$description$>"></td>
</tr>
<tr>
  <td>Address:</td>
  <td><textarea cols="30" rows="4" name="address"><$address$></textarea></td>
</tr>
<tr>
  <td>Furnace type:</td>
  <td><input type="text" name="furnacetype" size="40" value="<$furnacetype$>"></td>
</tr>
<tr>
  <td>Phone nr:</td>
  <td><input type="text" name="phonenr" size="40"  value="<$phonenr$>"></td>
</tr>
<tr>
  <td>IMEI nr</td>
  <td><input type="text" name="imei" size="40" maxlength="16" value="<$imei$>"></td>
</tr>
<tr>
  <td>Update rate</td>
  <td><input type="text" name="updaterate" size="40" value="<$updaterate$>"></td>
</tr>
<tr>
  <td>&nbsp;</td>
  <td><input type="submit"><input type="reset"></td>
</tr>
</table>
<input type="hidden" name="id" value="<$ id $>">
<input type="hidden" name="customerid" value="<$ customerid $>">
<input type="hidden" name="name" value="<$name$>">
<input type="hidden" name="submit" value="1">
</form>

<br>
<form method="post" action="adm_installation_delete">
<input type="hidden" name="id" value="<$id$>">
<input type="hidden" name="customerid" value="<$customerid$>">
<input type="hidden" name="name" value="<$name$>">
<input type="submit" value="Delete">
</form>

<{
}


}>

<&footer>
</&footer>
1	torben	101	<%pre>
2			#include <tntdb/connect.h>
3			#include <tntdb/connection.h>
4			#include <tntdb/result.h>
5			#include <tntdb/row.h>
6
7			#include <sstream>
8
9			#include "common.h"
10			</%pre>
11
12			<%config>
13			dburl;
14			</%config>
15
16			<%session scope="global">
17			std::string userName;
18			bool isAdmin;
19			</%session>
20
21			<%args>
22			int id;
23			int customerid;
24			std::string name;
25			</%args>
26
27			<{
28			if (userName.size() == 0)
29			{
30			reply.setHeader("Location", "index");
31			return HTTP_MOVED_TEMPORARILY;
32			}
33			}>
34
35
36			<&header title="Installation Administration">
37			</&header>
38
39
40			<{
41
42			if (id == -1)
43			reply.out() << "<h2>New installation</h2>\n";
44			else
45			reply.out() << "<h2>Modify installation</h2>\n";
46
47			reply.out() << "<a href='adm_installation_list?customerid=" << customerid<< "&name=" << name << "'>";
48			reply.sout() << "<< back to installation list";
49			reply.out() << "</a><br>";
50
51			tntdb::Connection conn = tntdb::connect(dburl);
52
53
54			std::string submit = qparam.param("submit");
55			if (submit == "1")
56			{
57			std::string form_description = trim(qparam.param("description"));
58			std::string form_address = trim(qparam.param("address"));
59			std::string form_furnacetype = trim(qparam.param("furnacetype"));
60			std::string form_phonenr = trim(qparam.param("phonenr"));
61			std::string form_imei = trim(qparam.param("imei"));
62			int form_updaterate = atoi(trim(qparam.param("updaterate")).c_str());
63
64			if (id == -1)
65			{
66			tntdb::Statement st = conn.prepare(
67			"INSERT INTO installation (customerid,description,address,furnacetype, installationphonenr,imei,updaterate ) values (:v1,:v2,:v3,:v4,:v5,:v6,:v7)");
68			st.setInt("v1", customerid).setString("v2", form_description).setString("v3", form_address).setString("v4", form_furnacetype);
69			st.setString("v5", form_phonenr).setString("v6",form_imei).setInt("v7", form_updaterate);
70			st.execute();
71
72			std::stringstream url;
73			url << "adm_installation_list?customerid=" << customerid << "&name=" << name;
74
75			reply.setHeader("Location", url.str());
76			return HTTP_MOVED_TEMPORARILY;
77			}
78			else
79			{
80			tntdb::Statement st = conn.prepare(
81			"UPDATE installation SET description=:v1, address=:v2, furnacetype=:v3, installationphonenr=:v4, imei=:v5, updaterate=:v6 WHERE id=:v7");
82			st.setString("v1", form_description).setString("v2", form_address).setString("v3", form_furnacetype).setString("v4", form_phonenr);
83			st.setString("v5", form_imei); st.setInt("v6", form_updaterate).setInt("v7", id);
84			st.execute();
85
86			reply.out() << "<i>Installation updated</i><br>\n";
87			}
88
89			}
90
91
92			std::string description;
93			std::string address;
94			std::string furnacetype;
95			std::string phonenr;
96			std::string imei;
97			std::string updaterate;
98
99			bool showForm = true;
100
101			if (id != -1)
102			{
103			std::stringstream query;
104			query << "SELECT description,address, furnacetype,installationphonenr,imei,updaterate FROM installation WHERE id = " << id;
105			tntdb::Result res = conn.select(query.str());
106
107			if (res.size() > 0)
108			{
109			description = res[0].getString(0);
110			address = res[0].getString(1);
111			furnacetype = res[0].getString(2);
112			phonenr = res[0].getString(3);
113			imei = res[0].getString(4);
114			updaterate = res[0].getString(5);
115			}
116
117			else
118			{
119			reply.out() << "<p><i>Invalid installation ID !</i></p>\n";
120			showForm = false;
121			}
122			}
123
124			if (showForm)
125			{
126			}>
127
128			<form method="post" action="adm_installation_edit">
129			<table border="0">
130			<tr>
131			<td>Description:</td>
132			<td><input type="text" name="description" size="40" value="<$description$>"></td>
133			</tr>
134			<tr>
135			<td>Address:</td>
136			<td><textarea cols="30" rows="4" name="address"><$address$></textarea></td>
137			</tr>
138			<tr>
139			<td>Furnace type:</td>
140			<td><input type="text" name="furnacetype" size="40" value="<$furnacetype$>"></td>
141			</tr>
142			<tr>
143			<td>Phone nr:</td>
144			<td><input type="text" name="phonenr" size="40" value="<$phonenr$>"></td>
145			</tr>
146			<tr>
147			<td>IMEI nr</td>
148	torben	104	<td><input type="text" name="imei" size="40" maxlength="16" value="<$imei$>"></td>
149	torben	101	</tr>
150			<tr>
151			<td>Update rate</td>
152			<td><input type="text" name="updaterate" size="40" value="<$updaterate$>"></td>
153			</tr>
154			<tr>
155			<td> </td>
156			<td><input type="submit"><input type="reset"></td>
157			</tr>
158			</table>
159			<input type="hidden" name="id" value="<$ id $>">
160			<input type="hidden" name="customerid" value="<$ customerid $>">
161			<input type="hidden" name="name" value="<$name$>">
162			<input type="hidden" name="submit" value="1">
163			</form>
164
165			<br>
166			<form method="post" action="adm_installation_delete">
167			<input type="hidden" name="id" value="<$id$>">
168			<input type="hidden" name="customerid" value="<$customerid$>">
169			<input type="hidden" name="name" value="<$name$>">
170			<input type="submit" value="Delete">
171			</form>
172
173			<{
174			}
175
176
177			}>
178
179			<&footer>
180			</&footer>