/[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 111 by torben, Fri Nov 30 16:05:11 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 ";  query << "SELECT c.name, c.address AS caddress, i.description, i.address AS iadress, i.furnacetype, i.updaterate, i.commerror ";
39  query << "FROM installation i INNER JOIN customer c ON c.id = i.customerid ";  query << "FROM installation i INNER JOIN customer c ON c.id = i.customerid ";
40  query << "WHERE i.id = " << id;  query << "WHERE i.id = " << id;
41    
# Line 72  if (res.size() >0 ) Line 72  if (res.size() >0 )
72                  <td>Update rate: </td>                  <td>Update rate: </td>
73                  <td><$ res[0].getInt(5) $></td>                  <td><$ res[0].getInt(5) $></td>
74          </tr>          </tr>
75            <tr>
76                    <td>Comm. status: </td>
77                    <td><img src="bullet?rgb=<$ (res[0].getBool(6) ? "ff0000" : "00ff00") $>" alt="Status Indicator"></td>
78            </tr>
79    
80    
81          </table>          </table>
82    
83        <br>
84            <p align="center"><img src="temperaturegraph?id=<$id$>" alt="Temperature graph"></p>
85    
86          <p align="center"><img src="temperaturegraph?id=<$id$>"></p>      <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    
96          out << "<table border=1 cellspacing=0 align='center'>\n";          out << "<table border=1 cellspacing=0 align='center'>\n";
97          out << "<tr><th>&nbsp;Message#&nbsp;</th><th>&nbsp;Logtime&nbsp;</th><th>&nbsp;Temperature&nbsp;</th><th>&nbsp;Flamedetector&nbsp;</th><th>&nbsp;Solidfuel empty&nbsp;</th><th>&nbsp;Conveyor error&nbsp;</th><th>&nbsp;Power failure&nbsp;</th></tr>\n";          out << "<tr><th>&nbsp;Message#&nbsp;</th><th>&nbsp;Logtime&nbsp;</th><th>&nbsp;Temperature&nbsp;</th><th>&nbsp;Flamedetector&nbsp;</th><th>&nbsp;Solidfuel empty&nbsp;</th><th>&nbsp;Conveyor error&nbsp;</th><th>&nbsp;Power failure&nbsp;</th></tr>\n";
98    
99          for (int i=0; i<res.size(); ++i)          for (unsigned int i=0; i<res.size(); ++i)
100          {          {
101                  int messagenr = res[i].getInt(0);                  int messagenr = res[i].getInt(0);
102                  std::string logtime = res[i].getString(1);                  std::string logtime = res[i].getString(1);
# Line 106  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";
# Line 115  if (res.size() >0 ) Line 120  if (res.size() >0 )
120                                                                    
121                  out << "</tr>";                  out << "</tr>";
122          }          }
123            out << "</table>\n";
124    
125    
126          }>          }>
Legend:
Removed from v.111  
changed lines
  Added in v.206
  ViewVC Help
Powered by ViewVC 1.1.20