8 |
std::string createInstallationSelector(tntdb::Connection& conn) |
std::string createInstallationSelector(tntdb::Connection& conn) |
9 |
{ |
{ |
10 |
std::stringstream out; |
std::stringstream out; |
11 |
tntdb::Result res = conn.select("SELECT c.name, i.id, i.description FROM customer c INNER JOIN installation i ON c.id = i.customerid"); |
tntdb::Result res = conn.select("SELECT c.name, i.id, i.description FROM customer c INNER JOIN installation i ON c.id = i.customerid ORDER BY name,description"); |
12 |
|
|
13 |
out << "<select name='installation'>\n"; |
out << "<select name='installation'>\n"; |
14 |
|
|
47 |
|
|
48 |
<{ |
<{ |
49 |
|
|
50 |
tntdb::Connection conn = tntdb::connect(dburl); |
tntdb::Connection conn = tntdb::connectCached(dburl); |
51 |
|
|
52 |
std::ostream& out = reply.out(); |
std::ostream& out = reply.out(); |
53 |
|
|
114 |
|
|
115 |
for (unsigned int i=0; i<res.size(); ++i) |
for (unsigned int i=0; i<res.size(); ++i) |
116 |
{ |
{ |
117 |
out << "<tr><td>" << res[i].getString(2) << "</td>"; |
out << "<tr><td> " << res[i].getString(2) << " </td>"; |
118 |
out << "<td>" << res[i].getString(3) << "</td>"; |
out << "<td> " << res[i].getString(3) << " </td>"; |
119 |
|
|
120 |
out << "<td>"; |
out << "<td> "; |
121 |
|
|
122 |
switch ( res[i].getInt(4) ) |
switch ( res[i].getInt(4) ) |
123 |
{ |
{ |
131 |
out << "Unknown command"; |
out << "Unknown command"; |
132 |
break; |
break; |
133 |
} |
} |
134 |
out << "</td>\n"; |
out << " </td>\n"; |
135 |
|
|
136 |
out << "</tr>\n"; |
out << "</tr>\n"; |
137 |
} |
} |