update bakaceva 3 to use views for graph

[zc] / www / cgi-bin / template.cgi

diff --git a/www/cgi-bin/template.cgi b/www/cgi-bin/template.cgi
index 5c3e6c3..a349194 100755 (executable)
--- a/www/cgi-bin/template.cgi
+++ b/www/cgi-bin/template.cgi
@@ -22,9 +22,11 @@ voltage=0
 echo $HTTP_REFERER | grep -q voltage && voltage=1
 echo $QUERY_STRING | grep -q voltage && voltage=1
 
+time=$( grep "^$pn" $dir/time.txt | cut -d' ' -f2- )
+
 set > /dev/shm/$pn.env
 
-cat $dir/template.sql | sed -e "s/2008050087/$pn/" -e "s/x_axis_angle/x_axis_angle + $offset_x/" -e "s/y_axis_angle/y_axis_angle + $offset_y/" | psql --username=dpavlin -A -F "," -t zc > /dev/shm/$pn.txt
+cat $dir/template.sql | sed -e "s/2008050087/$pn $time/" -e "s/x_axis_angle/x_axis_angle + $offset_x/" -e "s/y_axis_angle/y_axis_angle + $offset_y/" | psql --username=dpavlin -A -F "," -t zc > /dev/shm/$pn.txt
 if [ -s /dev/shm/$pn.txt ] ; then
 cat $dir/template.gnuplot | sed -e "s,axes.txt,/dev/shm/$pn.txt," -e "s,^set terminal.*$,set terminal svg," -e "s,^set output.*$,set output," -e "s,-0.3 : 0.3,-$yrange : $yrange," -e "s,< 0.3,< $yrange," > /dev/shm/$pn.gnuplot
 gnuplot -e "voltage=$voltage" /dev/shm/$pn.gnuplot