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

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

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

revision 104 by torben, Thu Nov 29 17:06:38 2007 UTC revision 129 by torben, Mon Dec 3 07:56:35 2007 UTC
# Line 4  Line 4 
4  #include <tntdb/result.h>  #include <tntdb/result.h>
5  #include <tntdb/row.h>  #include <tntdb/row.h>
6    
 #include <vector>  
   
   
   
 class CriticalInstallation  
 {  
 public:  
         CriticalInstallation() {}  
         CriticalInstallation(int i, std::string m) : id(i), message(m) {}  
         int id;  
         std::string message;  
 };  
   
7  </%pre>  </%pre>
8    
9  <%config>  <%config>
# Line 29  dburl; Line 16  dburl;
16    
17  <{  <{
18    
19    tntdb::Connection conn = tntdb::connect(dburl);
20    
 std::vector<CriticalInstallation> criticals;  
21    
22  tntdb::Connection conn = tntdb::connect(dburl);  std::string query1;
23    query1 += "SELECT c.name, i.description, i.id ";
24    query1 += "FROM installation i INNER JOIN customer c ";
25    query1 += "ON i.customerid = c.id";
26    
27    
28    tntdb::Result inst_res = conn.select(query1);
29    
30    
31    std::string query2;
32    query2 += "SELECT commerror,temperature,flamedetector,conveyorerror,powerfailure ";
33    query2 += "FROM logtable ";
34    query2 += "INNER JOIN installation ";
35    query2 += "ON logtable.installationnr = installation.id ";
36    query2 += "WHERE installationnr = :v1 ";
37    query2 += "ORDER BY messagenr DESC ";
38    query2 += "LIMIT 1";
39    
40    tntdb::Statement st = conn.prepare(query2);
41    
42    std::ostream& out = reply.out();
43    
44    bool hasCritical = false;
45    
46    for (unsigned i=0; i<inst_res.size(); i++)
47    {
48            int id = inst_res[i].getInt(2);
49            st.clear();
50    
51            st.setInt("v1", id);
52            tntdb::Result res = st.select();
53    
54            if (res.size() > 0)
55            {
56                    bool commerror = res[0].getBool(0);
57                    int temperature = res[0].getInt(1);
58                    bool flameDetector = res[0].getBool(2);
59                    bool conveyorError = res[0].getBool(3);
60                    bool powerFailure = res[0].getBool(4);
61    
62                    if (commerror || temperature > 90 || flameDetector == false || conveyorError || powerFailure)
63                    {
64                            out << "<a href='installationdetails?id=" << id << "'><b>" << inst_res[i].getString(0) << "</b> : " << inst_res[i].getString(1) << "<br></a>\n";
65                            out << "<ul>";
66    
67                            if (temperature > 90)
68                                    out << "<li>High temperature</li>\n";
69    
70                            if (commerror)
71                                    out << "<li>Communication error</li>\n";
72    
73                            if (flameDetector == false)
74                                    out << "<li>No flames</li>\n";
75    
76                            if (conveyorError)
77                                    out << "<li>Conveyor error</li>\n";
78    
79                            if (powerFailure)
80                                    out << "<li>Power failure</li>\n";
81    
82                            out << "</ul>\n";
83    
84                            hasCritical = true;
85                    }
86            }
87    }
88    
89  tntdb::Result res = conn.select("SELECT id FROM installation WHERE commerror = true");  if (hasCritical == false)
 for (int i=0; i<res.size(); ++i)  
90  {  {
91          criticals.push_back(CriticalInstallation(res[i].getInt(0), std::string("Communication Error")));          out << "<i>No critical installations found</i>\n";
92  }  }
93    
94  }>  }>
Legend:
Removed from v.104  
changed lines
  Added in v.129
  ViewVC Help
Powered by ViewVC 1.1.20