tntnet/dynamic/adm_customer_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>

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

<&header title="Customer administration">
</&header>
<h2>Customers administration</h2>

<a href="adm_customer_edit?id=-1">Create new customer</a><br>


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

std::string query = "SELECT id, name FROM customer ORDER BY name ASC";

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

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

<&footer>
</&footer>
1	torben	83	<%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	torben	94	<{
17			if (userName.size() == 0)
18			{
19			reply.setHeader("Location", "index");
20			return HTTP_MOVED_TEMPORARILY;
21			}
22			}>
23
24	torben	83	<&header title="Customer administration">
25			</&header>
26			<h2>Customers administration</h2>
27
28			<a href="adm_customer_edit?id=-1">Create new customer</a><br>
29
30	torben	94
31	torben	83	<{
32	torben	94	tntdb::Connection conn = tntdb::connect(dburl);
33	torben	83
34			std::string query = "SELECT id, name FROM customer ORDER BY name ASC";
35
36			tntdb::Result res = conn.select(query);
37
38			std::ostream& out = reply.out();
39			if (res.size() > 0)
40			{
41			out << "<ul>";
42			for (int i=0; i<res.size(); ++i)
43			{
44			int id = res[i].getInt(0);
45			std::string name = res[i].getString(1);
46			out << "<li>";
47			out << "<a href='adm_customer_edit?id=" << id << "'>" << name << "</a>";
48	torben	101	out << " - <a href='adm_installation_list?customerid=" << id << "&name=" << name << "'>manage installations</a>";
49	torben	83	out << "</li>";
50			}
51			out << "</ul>";
52			}
53			else
54			{
55			out << "<i>No customers found!</i>";
56			}
57			}>
58
59			<&footer>
60			</&footer>