tntnet/dynamic/adm_installation_list.ecpp

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

<%config>
dburl;
</%config>

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

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

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

<&header title="Installation administration">
</&header>
<h2>Installation administration for <$ name $></h2>


<a href="adm_customer_list">&lt;&lt;Back to customer list</a>
<a href="adm_installation_edit?id=-1&customerid=<$customerid$>&name=<$name$>">Create new installation</a><br>


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

std::stringstream query;
query << "SELECT id,description FROM installation WHERE customerid=" << customerid << " ORDER BY description ASC";

tntdb::Result res = conn.select(query.str());

std::ostream& out = reply.out();
if (res.size() > 0)
{
        out << "<ol>";
        for (int i=0; i<res.size(); ++i)
        {
                int id = res[i].getInt(0);
                std::string desc = res[i].getString(1);
                out << "<li>";
                out << "<a href='adm_installation_edit?id=" << id << "&customerid=" << customerid << "&name=" << name <<"'>" << desc << "</a>";
                out << "</li>";
        }
        out << "</ol>";
}
else
{
        out << "<i>No installations found!</i>";
}
}>

<&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	</%pre>
7
8	<%config>
9	dburl;
10	</%config>
11
12	<%session scope="global">
13	std::string userName;
14	</%session>
15
16	<%args>
17	int customerid;
18	std::string name;
19	</%args>
20
21	<{
22	if (userName.size() == 0)
23	{
24	reply.setHeader("Location", "index");
25	return HTTP_MOVED_TEMPORARILY;
26	}
27	}>
28
29	<&header title="Installation administration">
30	</&header>
31	<h2>Installation administration for <$ name $></h2>
32
33
34	<a href="adm_customer_list"><<Back to customer list</a>
35	<a href="adm_installation_edit?id=-1&customerid=<$customerid$>&name=<$name$>">Create new installation</a><br>
36
37
38	<{
39	tntdb::Connection conn = tntdb::connect(dburl);
40
41	std::stringstream query;
42	query << "SELECT id,description FROM installation WHERE customerid=" << customerid << " ORDER BY description ASC";
43
44	tntdb::Result res = conn.select(query.str());
45
46	std::ostream& out = reply.out();
47	if (res.size() > 0)
48	{
49	out << "<ol>";
50	for (int i=0; i<res.size(); ++i)
51	{
52	int id = res[i].getInt(0);
53	std::string desc = res[i].getString(1);
54	out << "<li>";
55	out << "<a href='adm_installation_edit?id=" << id << "&customerid=" << customerid << "&name=" << name <<"'>" << desc << "</a>";
56	out << "</li>";
57	}
58	out << "</ol>";
59	}
60	else
61	{
62	out << "<i>No installations found!</i>";
63	}
64	}>
65
66	<&footer>
67	</&footer>