#!/bin/sh

dir=/home/dpavlin/zc/gnuplot/

echo "Content-type: image/svg+xml"
echo

pn=$( basename $0 | sed 's/.cgi//' )
offset=$( grep "^$pn" $dir/offset.txt )
offset_x=$( echo $offset | cut -d' ' -f2 )
offset_y=$( echo $offset | cut -d' ' -f3 )

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.gnuplot | sed -e "s,axes.txt,/dev/shm/$pn.txt," -e "s,^set terminal.*$,set terminal svg," -e "s,^set output.*$,set output," > /dev/shm/$pn.gnuplot
gnuplot /dev/shm/$pn.gnuplot

#rm /dev/shm/axes.txt.$$ /dev/shm/axes.gnuplot.$$