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>

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

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

<{

if (userName.size() == 0)
{
        reply.setHeader("Refresh", "0; url=login");
        return HTTP_OK;
}

tntdb::Connection conn;

conn = tntdb::connect(dburl); //letting exceptions flow up and to tntnet and let it display an error message

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?id=" << id << "&name=" << name << "'>manage installations</a>";
                out << "</li>";
        }
        out << "</ul>";
}
else
{
        out << "<i>No customers 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	<&header title="Customer administration">
17	</&header>
18	<h2>Customers administration</h2>
19
20	<a href="adm_customer_edit?id=-1">Create new customer</a><br>
21
22	<{
23
24	if (userName.size() == 0)
25	{
26	reply.setHeader("Refresh", "0; url=login");
27	return HTTP_OK;
28	}
29
30	tntdb::Connection conn;
31
32	conn = tntdb::connect(dburl); //letting exceptions flow up and to tntnet and let it display an error message
33
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	out << " - <a href='adm_installation_list?id=" << id << "&name=" << name << "'>manage installations</a>";
49	out << "</li>";
50	}
51	out << "</ul>";
52	}
53	else
54	{
55	out << "<i>No customers found!</i>";
56	}
57	}>
58
59	<&footer>
60	</&footer>