MicroArm MINI2440 Manual de usuario descargar pdf (Pagina 71)

}

else{

/*Proetoimasia query 10 teleutaia*/

error = sqlite3_prepare_v2(conn,"select time, heat, humidity

from envstore order by rowid desc limit 10",1000, &res, &tail);

sprintf(sqliq,"select avg(x.heat) from (select t.heat from

envstore t order by rowid desc limit 10) x");

average_heat = Qtoi(sqliq,conn);

sprintf(sqliq,"select max(x.heat) from (select t.heat from

envstore t order by rowid desc limit 10) x");

max_heat = Qtoi(sqliq,conn);

sprintf(sqliq,"select min(x.heat) from (select t.heat from

envstore t order by rowid desc limit 10) x");

min_heat = Qtoi(sqliq,conn);

sprintf(sqliq,"select avg(x.humidity) from (select t.humidity

from envstore t order by rowid desc limit 10) x");

average_hym = Qtoi(sqliq,conn);

sprintf(sqliq,"select max(x.humidity) from (select t.humidity

from envstore t order by rowid desc limit 10) x");

max_hym = Qtoi(sqliq,conn);

sprintf(sqliq,"select min(x.humidity) from (select t.humidity

from envstore t order by rowid desc limit 10) x");

min_hym = Qtoi(sqliq,conn);

}

/*Elegxos gia lathos me ti sqlite*/

if (error != SQLITE_OK) {

system("date >> /my/sel_log.txt");

system("echo We did not get any data! >> /my/sel_log.txt");

}

/*Sunoptikos pinakas*/

puts("<div class=\"flo\"><table>");

printf("<tr><td>Μέσος όρος θερμοκρασίας</td><td>%d

C</td></tr>\n",average_heat);

printf("<tr><td>Μέγιστη θερμοκρασία</td><td>%d

C</td></tr>\n",max_heat);

printf("<tr><td>Ελάχιστη θερμοκρασία</td><td>%d

C</td></tr>\n",min_heat);

printf("<tr><td>Μέσος όρος υγρασίας</td><td>%d \

%</td></tr>\n",average_hym);

printf("<tr><td>Μέγιστη υγρασία</td><td>%d \%</td></tr>\n",max_hym);

printf("<tr><td>Ελάχιστη υγρασία</td><td>%d \

%</td></tr>\n",min_hym);

puts("</table></div>");

/*Ektupwsi pinaka apotelesmatwn*/

puts("<div><table class=\"result\">");

puts("<tr><td>Χρόνος</td><td>Θερμοκρασία</td><td>Υγρασία</tr>");

while (sqlite3_step(res) == SQLITE_ROW) {

strncpy(ttime,sqlite3_column_text(res, 0),20);

Σελίδα 64

1 2 ... 66 67 68 69 70 71 72 73 74 75 76 ... 79 80

Comentarios a estos manuales

Sin comentarios

MicroArm MINI2440 Manual de usuario Pagina 71

Comentarios a estos manuales