/[H9]/trunk/tntnet/dynamic/installationdetails.ecpp
ViewVC logotype

Diff of /trunk/tntnet/dynamic/installationdetails.ecpp

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 127 by torben, Mon Dec 3 07:34:21 2007 UTC revision 206 by torben, Sun Dec 9 21:08:55 2007 UTC
# Line 32  int id; Line 32  int id;
32  <{  <{
33  tntdb::Connection conn;  tntdb::Connection conn;
34    
35  conn = tntdb::connect(dburl);  conn = tntdb::connectCached(dburl);
36    
37  std::stringstream query;  std::stringstream query;
38  query << "SELECT c.name, c.address AS caddress, i.description, i.address AS iadress, i.furnacetype, i.updaterate, i.commerror ";  query << "SELECT c.name, c.address AS caddress, i.description, i.address AS iadress, i.furnacetype, i.updaterate, i.commerror ";
# Line 80  if (res.size() >0 ) Line 80  if (res.size() >0 )
80    
81          </table>          </table>
82    
83        <br>
84          <p align="center"><img src="temperaturegraph?id=<$id$>" alt="Temperature graph"></p>          <p align="center"><img src="temperaturegraph?id=<$id$>" alt="Temperature graph"></p>
85    
86        <br>
87          <{          <{
88          query.str(""); //reset stringstream          query.str(""); //reset stringstream
89          query << "SELECT messagenr, date_trunc('second', logtime) AS logtime, temperature, flamedetector, solidfuelempty, conveyorerror,powerfailure ";          query << "SELECT messagenr, date_trunc('second', logtime) AS logtime, temperature, flamedetector, solidfuelempty, conveyorerror,powerfailure ";
90          query << "FROM logtable ";          query << "FROM logtable ";
91          query << "WHERE installationnr = " << id;          query << "WHERE installationnr = " << id;
92          query << "ORDER BY messagenr DESC";          query << "ORDER BY messagenr DESC, logtime DESC ";
93          res = conn.select(query.str());          res = conn.select(query.str());
94    
95    
# Line 110  if (res.size() >0 ) Line 111  if (res.size() >0 )
111                  out << "<tr>";                  out << "<tr>";
112    
113                  out << "<td align='center'>" << messagenr << "</td>\n";                  out << "<td align='center'>" << messagenr << "</td>\n";
114                  out << "<td align='center'>" << logtime << "</td>\n";                  out << "<td align='center'>&nbsp;" << logtime << "&nbsp;</td>\n";
115                  out << "<td align='center'" << (temperature >90 ? critical : "" ) << ">" << temperature << "</td>\n";                  out << "<td align='center'" << (temperature >90 ? critical : "" ) << ">" << temperature << "</td>\n";
116                  out << "<td align='center'" << (flamedetector==false ? critical : "") << ">" << convert_bool(flamedetector) << "</td>\n";                    out << "<td align='center'" << (flamedetector==false ? critical : "") << ">" << convert_bool(flamedetector) << "</td>\n";  
117                  out << "<td align='center'>" << convert_bool(solidfuelempty) << "</td>\n";                  out << "<td align='center'>" << convert_bool(solidfuelempty) << "</td>\n";
Legend:
Removed from v.127  
changed lines
  Added in v.206
  ViewVC Help
Powered by ViewVC 1.1.20