tntnet/dynamic/temperaturegraph.ecpp

<%pre>
#include <tntdb/connect.h>
#include <tntdb/connection.h>
#include <tntdb/result.h>
#include <tntdb/row.h>


#include "gd-cpp/gdpp.h"
#include <gdfonts.h>
#include <sstream>

</%pre>
<%config>
dburl;
</%config>
<%args>
int id;
</%args>
<{

GD::Image image;
image.CreateTrueColor( GD::Size(600,350));

GD::TrueColor green(45,95,0);
GD::TrueColor text(200,200,200);
GD::TrueColor red(255,0,0);


image.String(gdFontSmall, 250,5, "Temperature graph", text.Int());

for (int i=0; i<11; ++i)
{
        std::stringstream marker;
        marker << (100- (i*10));
        int y = (i*30) + 25;
        image.Line(     30, y, 590, y, green.Int());

        image.String(gdFontSmall, 5, y-7, marker.str().c_str(), text.Int());

}
/////////////////////////////////////////////////


tntdb::Connection conn = tntdb::connect(dburl);

std::stringstream query;
query << "SELECT temperature FROM ( ";
query << "    SELECT messagenr,temperature FROM logtable ";
query << "    WHERE installationnr = " << id << " ";
query << "    ORDER BY messagenr DESC LIMIT 20 ";
query << ") query ";
query << "ORDER BY messagenr ASC";

tntdb::Result res = conn.select(query.str());

GD::Point previous;
for (int i=0; i<res.size(); ++i)
{
        int current = res[i].getInt(0);
        int x = (i*28) + 40;
        int y = ((100-current) * 3) + 25;

        //image.FilledArc( GD::Point(x,y), GD::Size(3,3), 0, 360, red.Int(), gdPie);
        image.FilledRectangle( GD::Point(x-1,y-1), GD::Point(x+1,y+1), red.Int() );

        if (i>0)
        {
                image.Line( GD::Point(x,y), previous, red.Int());
        }

        previous = GD::Point(x,y);

}

//////////////////////////////////////////////////
// echo the image to the browser...
reply.setContentType("image/png");
int size;
unsigned char* ptr = (unsigned char*) image.Png(&size);

for (int i=0; i<size; ++i)
        reply.out() << ptr[i];

gdFree(ptr);

}>
1	<%pre>
2	#include <tntdb/connect.h>
3	#include <tntdb/connection.h>
4	#include <tntdb/result.h>
5	#include <tntdb/row.h>
6
7
8	#include "gd-cpp/gdpp.h"
9	#include <gdfonts.h>
10	#include <sstream>
11
12	</%pre>
13	<%config>
14	dburl;
15	</%config>
16	<%args>
17	int id;
18	</%args>
19	<{
20
21	GD::Image image;
22	image.CreateTrueColor( GD::Size(600,350));
23
24	GD::TrueColor green(45,95,0);
25	GD::TrueColor text(200,200,200);
26	GD::TrueColor red(255,0,0);
27
28
29	image.String(gdFontSmall, 250,5, "Temperature graph", text.Int());
30
31	for (int i=0; i<11; ++i)
32	{
33	std::stringstream marker;
34	marker << (100- (i*10));
35	int y = (i*30) + 25;
36	image.Line( 30, y, 590, y, green.Int());
37
38	image.String(gdFontSmall, 5, y-7, marker.str().c_str(), text.Int());
39
40	}
41	/////////////////////////////////////////////////
42
43
44	tntdb::Connection conn = tntdb::connect(dburl);
45
46	std::stringstream query;
47	query << "SELECT temperature FROM ( ";
48	query << " SELECT messagenr,temperature FROM logtable ";
49	query << " WHERE installationnr = " << id << " ";
50	query << " ORDER BY messagenr DESC LIMIT 20 ";
51	query << ") query ";
52	query << "ORDER BY messagenr ASC";
53
54	tntdb::Result res = conn.select(query.str());
55
56	GD::Point previous;
57	for (int i=0; i<res.size(); ++i)
58	{
59	int current = res[i].getInt(0);
60	int x = (i*28) + 40;
61	int y = ((100-current) * 3) + 25;
62
63	//image.FilledArc( GD::Point(x,y), GD::Size(3,3), 0, 360, red.Int(), gdPie);
64	image.FilledRectangle( GD::Point(x-1,y-1), GD::Point(x+1,y+1), red.Int() );
65
66	if (i>0)
67	{
68	image.Line( GD::Point(x,y), previous, red.Int());
69	}
70
71	previous = GD::Point(x,y);
72
73	}
74
75	//////////////////////////////////////////////////
76	// echo the image to the browser...
77	reply.setContentType("image/png");
78	int size;
79	unsigned char* ptr = (unsigned char*) image.Png(&size);
80
81	for (int i=0; i<size; ++i)
82	reply.out() << ptr[i];
83
84	gdFree(ptr);
85
86	}>