tntnet/dynamic/adm_user_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;
bool isAdmin;
</%session>

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

<&header title="User administration">
</&header>
<h2>User administration</h2>

<a href="adm_user_edit?id=-1">Create new user</a><br>


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

std::string query = "SELECT id, realname, username FROM users ORDER BY username 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 realname = res[i].getString(1);
                std::string username = res[i].getString(2);
                out << "<li>";
                out << "<a href='adm_user_edit?id=" << id << "'>" << username << "</a> - " << realname;
                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	bool isAdmin;
15	</%session>
16
17	<{
18	if (userName.size() == 0)
19	{
20	reply.setHeader("Location", "index");
21	return HTTP_MOVED_TEMPORARILY;
22	}
23	if (!isAdmin)
24	{
25	reply.setHeader("Location", "index");
26	return HTTP_MOVED_TEMPORARILY;
27	}
28	}>
29
30	<&header title="User administration">
31	</&header>
32	<h2>User administration</h2>
33
34	<a href="adm_user_edit?id=-1">Create new user</a><br>
35
36
37	<{
38	tntdb::Connection conn = tntdb::connect(dburl);
39
40	std::string query = "SELECT id, realname, username FROM users ORDER BY username ASC";
41
42	tntdb::Result res = conn.select(query);
43
44	std::ostream& out = reply.out();
45	if (res.size() > 0)
46	{
47	out << "<ul>";
48	for (int i=0; i<res.size(); ++i)
49	{
50	int id = res[i].getInt(0);
51	std::string realname = res[i].getString(1);
52	std::string username = res[i].getString(2);
53	out << "<li>";
54	out << "<a href='adm_user_edit?id=" << id << "'>" << username << "</a> - " << realname;
55	out << "</li>";
56	}
57	out << "</ul>";
58	}
59	else
60	{
61	out << "<i>No customers found!</i>";
62	}
63	}>
64
65	<&footer>
66	</&footer>