/[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 122 by torben, Sun Dec 2 16:56:14 2007 UTC
# Line 35  tntdb::Connection conn; Line 35  tntdb::Connection conn;
35  conn = tntdb::connect(dburl);  conn = tntdb::connect(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.php?rgb=<$ (res[0].getBool(6) ? "ff0000" : "00ff00") $>" alt="Status Indicator"></td>
78            </tr>
79    
80    
81          </table>          </table>
82    
83    
84          <p align="center"><img src="temperaturegraph?id=<$id$>"></p>          <p align="center"><img src="temperaturegraph?id=<$id$>" alt="Temperature graph"></p>
85    
86          <{          <{
87          query.str(""); //reset stringstream          query.str(""); //reset stringstream
# Line 115  if (res.size() >0 ) Line 119  if (res.size() >0 )
119                                                                    
120                  out << "</tr>";                  out << "</tr>";
121          }          }
122            out << "</table>\n";
123    
124    
125          }>          }>

Legend:
Removed from v.111  
changed lines
  Added in v.122

  ViewVC Help
Powered by ViewVC 1.1.20