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><br>
<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 (unsigned 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	torben	101	<%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	torben	104	<a href="adm_customer_list"><<Back to customer list</a><br>
35	torben	101	<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	torben	126	for (unsigned i=0; i<res.size(); ++i)
51	torben	101	{
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>