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;
</%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><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)
{
}>


<script type="text/javascript" language="JavaScript" src="/md5.js"></script>
<script type="text/javascript" language="JavaScript" src="/trim.js"></script>
<script type="text/javascript">

function validateInstallationForm()
{
        var form = document.installationform;
        form.description.value = trim(form.description.value);
        form.phonenr.value = trim(form.phonenr.value);
        form.imei.value = trim(form.imei.value);
        form.updaterate.value = trim(form.updaterate.value);

        if (form.description.value.length < 3)
        {
                alert("Description must be at least 3 characters.");
                return false;
        }

        if (isNaN(form.phonenr.value))
        {
                alert("Phonenr may only contain digits");
                return false;
        }

        if (form.phonenr.value.length < 8)
        {
                if (!confirm("Phonenr seems rather short, are you sure this is correct"))
                {
                        return false;
                }
        }

        if (isNaN(form.imei.value))
        {
                alert("IMEI may only contain digits");
                return false;
        }

        if (form.imei.value.length != 15)
        {
                alert("IMEI must be exactly 15 digits");
                return false;
        }

        if (isNaN(form.updaterate.value))
        {
                alert("Update rate may only contain digits");
                return false;
        }

        var updaterate = parseInt(form.updaterate.value);

        if (form.updaterate.value == "" || updaterate <5 || updaterate > 250)
        {
                alert("Update rate must be between 5 and 250\\n(Both inclusive)");
                return false;
        }
        

        return true;
}

</script>

<form method="post" action="adm_installation_edit" name="installationform" onsubmit="return validateInstallationForm();">
<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>

<p>*: Update rate is in minutes.</p>

<{
if (id != -1)
{
}>
  <br>
  <form method="post" action="adm_installation_delete" onsubmit="return confirm('Are you sure ?\\nThis will delete all loggings related to this installation','Delete installation');">
  <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 this installation">
  </form>
 

<{
} //fi (id != -1)
} //fi (showForm)
}>

<&footer>
</&footer>
1	<%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	</%session>
19
20	<%args>
21	int id;
22	int customerid;
23	std::string name;
24	</%args>
25
26	<{
27	if (userName.size() == 0)
28	{
29	reply.setHeader("Location", "index");
30	return HTTP_MOVED_TEMPORARILY;
31	}
32	}>
33
34
35	<&header title="Installation Administration">
36	</&header>
37
38
39	<{
40
41	if (id == -1)
42	reply.out() << "<h2>New installation</h2>\n";
43	else
44	reply.out() << "<h2>Modify installation</h2>\n";
45
46	reply.out() << "<a href='adm_installation_list?customerid=" << customerid<< "&name=" << name << "'>";
47	reply.sout() << "<< back to installation list";
48	reply.out() << "</a><br><br>";
49
50	tntdb::Connection conn = tntdb::connect(dburl);
51
52
53	std::string submit = qparam.param("submit");
54	if (submit == "1")
55	{
56	std::string form_description = trim(qparam.param("description"));
57	std::string form_address = trim(qparam.param("address"));
58	std::string form_furnacetype = trim(qparam.param("furnacetype"));
59	std::string form_phonenr = trim(qparam.param("phonenr"));
60	std::string form_imei = trim(qparam.param("imei"));
61	int form_updaterate = atoi(trim(qparam.param("updaterate")).c_str());
62
63	if (id == -1)
64	{
65	tntdb::Statement st = conn.prepare(
66	"INSERT INTO installation (customerid,description,address,furnacetype, installationphonenr,imei,updaterate ) values (:v1,:v2,:v3,:v4,:v5,:v6,:v7)");
67	st.setInt("v1", customerid).setString("v2", form_description).setString("v3", form_address).setString("v4", form_furnacetype);
68	st.setString("v5", form_phonenr).setString("v6",form_imei).setInt("v7", form_updaterate);
69	st.execute();
70
71	std::stringstream url;
72	url << "adm_installation_list?customerid=" << customerid << "&name=" << name;
73
74	reply.setHeader("Location", url.str());
75	return HTTP_MOVED_TEMPORARILY;
76	}
77	else
78	{
79	tntdb::Statement st = conn.prepare(
80	"UPDATE installation SET description=:v1, address=:v2, furnacetype=:v3, installationphonenr=:v4, imei=:v5, updaterate=:v6 WHERE id=:v7");
81	st.setString("v1", form_description).setString("v2", form_address).setString("v3", form_furnacetype).setString("v4", form_phonenr);
82	st.setString("v5", form_imei); st.setInt("v6", form_updaterate).setInt("v7", id);
83	st.execute();
84
85	reply.out() << "<i>Installation updated</i><br>\n";
86	}
87
88	}
89
90
91	std::string description;
92	std::string address;
93	std::string furnacetype;
94	std::string phonenr;
95	std::string imei;
96	std::string updaterate;
97
98	bool showForm = true;
99
100	if (id != -1)
101	{
102	std::stringstream query;
103	query << "SELECT description,address, furnacetype,installationphonenr,imei,updaterate FROM installation WHERE id = " << id;
104	tntdb::Result res = conn.select(query.str());
105
106	if (res.size() > 0)
107	{
108	description = res[0].getString(0);
109	address = res[0].getString(1);
110	furnacetype = res[0].getString(2);
111	phonenr = res[0].getString(3);
112	imei = res[0].getString(4);
113	updaterate = res[0].getString(5);
114	}
115
116	else
117	{
118	reply.out() << "<p><i>Invalid installation ID !</i></p>\n";
119	showForm = false;
120	}
121	}
122
123	if (showForm)
124	{
125	}>
126
127
128	<script type="text/javascript" language="JavaScript" src="/md5.js"></script>
129	<script type="text/javascript" language="JavaScript" src="/trim.js"></script>
130	<script type="text/javascript">
131
132	function validateInstallationForm()
133	{
134	var form = document.installationform;
135	form.description.value = trim(form.description.value);
136	form.phonenr.value = trim(form.phonenr.value);
137	form.imei.value = trim(form.imei.value);
138	form.updaterate.value = trim(form.updaterate.value);
139
140	if (form.description.value.length < 3)
141	{
142	alert("Description must be at least 3 characters.");
143	return false;
144	}
145
146	if (isNaN(form.phonenr.value))
147	{
148	alert("Phonenr may only contain digits");
149	return false;
150	}
151
152	if (form.phonenr.value.length < 8)
153	{
154	if (!confirm("Phonenr seems rather short, are you sure this is correct"))
155	{
156	return false;
157	}
158	}
159
160	if (isNaN(form.imei.value))
161	{
162	alert("IMEI may only contain digits");
163	return false;
164	}
165
166	if (form.imei.value.length != 15)
167	{
168	alert("IMEI must be exactly 15 digits");
169	return false;
170	}
171
172	if (isNaN(form.updaterate.value))
173	{
174	alert("Update rate may only contain digits");
175	return false;
176	}
177
178	var updaterate = parseInt(form.updaterate.value);
179
180	if (form.updaterate.value == "" \|\| updaterate <5 \|\| updaterate > 250)
181	{
182	alert("Update rate must be between 5 and 250\\n(Both inclusive)");
183	return false;
184	}
185
186
187	return true;
188	}
189
190	</script>
191
192	<form method="post" action="adm_installation_edit" name="installationform" onsubmit="return validateInstallationForm();">
193	<table border="0">
194	<tr>
195	<td>Description:</td>
196	<td><input type="text" name="description" size="40" value="<$description$>"></td>
197	</tr>
198	<tr>
199	<td>Address:</td>
200	<td><textarea cols="30" rows="4" name="address"><$address$></textarea></td>
201	</tr>
202	<tr>
203	<td>Furnace type:</td>
204	<td><input type="text" name="furnacetype" size="40" value="<$furnacetype$>"></td>
205	</tr>
206	<tr>
207	<td>Phone nr:</td>
208	<td><input type="text" name="phonenr" size="40" value="<$phonenr$>"></td>
209	</tr>
210	<tr>
211	<td>IMEI nr</td>
212	<td><input type="text" name="imei" size="40" maxlength="16" value="<$imei$>"></td>
213	</tr>
214	<tr>
215	<td>Update rate*</td>
216	<td><input type="text" name="updaterate" size="40" value="<$updaterate$>"></td>
217	</tr>
218	<tr>
219	<td> </td>
220	<td><input type="submit"><input type="reset"></td>
221	</tr>
222	</table>
223	<input type="hidden" name="id" value="<$ id $>">
224	<input type="hidden" name="customerid" value="<$ customerid $>">
225	<input type="hidden" name="name" value="<$name$>">
226	<input type="hidden" name="submit" value="1">
227	</form>
228
229	<p>*: Update rate is in minutes.</p>
230
231	<{
232	if (id != -1)
233	{
234	}>
235	<br>
236	<form method="post" action="adm_installation_delete" onsubmit="return confirm('Are you sure ?\\nThis will delete all loggings related to this installation','Delete installation');">
237	<input type="hidden" name="id" value="<$id$>">
238	<input type="hidden" name="customerid" value="<$customerid$>">
239	<input type="hidden" name="name" value="<$name$>">
240	<input type="submit" value="Delete this installation">
241	</form>
242
243
244	<{
245	} //fi (id != -1)
246	} //fi (showForm)
247	}>
248
249	<&footer>
250	</&footer>