Revision 97eb33aa901a4f11c2e8a690f016d0f7fca7dbaa (click the page title to view the current version)
# e.g. source script.sh ; docgen 1 5 22
export PGPASSWORD=`cat /golem/production/psql_password` # zaklad pro command line
function timeperiod()
{
FROMM=$1
TOM=$2
YEAR=$3
for MONTH in `seq $FROMM $TOM`; do psqlgen $MONTH $YEAR;done
}
function psqlgen()
{
MONTH=$1
YEAR=$2
psql -c "
DROP TABLE IF EXISTS public.temp_db;
SELECT start_timestamp, start_shot_no, start_chamber_pressure,session_mission, session_setup, staff_list, onstage_wave INTO public.temp_db FROM public.sessions WHERE EXTRACT(MONTH from to_timestamp(start_timestamp, 'YYYY-MM-DD HH24:MI' ))=$MONTH AND EXTRACT(YEAR from to_timestamp(start_timestamp, 'YYYY-MM-DD HH24:MI' ))=$YEAR ORDER BY start_shot_no ASC LIMIT 50;
SELECT to_char(to_timestamp(d.start_timestamp, 'YYYY-MM-DD HH24:MI' ),'DD.MM, Dy'),to_char(to_timestamp(d.start_timestamp, 'YYYY-MM-DD HH24:MI' ),'HH:MI'),start_shot_no, start_chamber_pressure,d.session_mission, d.session_setup, staff_list, onstage_wave, shot_no,d.\"D_integral_dose\" FROM public.temp_db s,public.shots d WHERE to_number(d.session_id,'99999')=s.start_shot_no AND (to_number(d.session_id,'99999')=shot_no OR d.\"D_integral_dose\" > 0)" -qAt -U golem golem_database|tee tables/"$MONTH""$YEAR"sqltable|sort -u -t '|' -k1,1 -k5,5 -k10,10|sort -t '|' -k3,3|sed 's/&/\\&/g;s/\_/\\_/g'|awk -F '|' '{printf $1 " & " $2 " & " $3 " & %3.1e & " $5 " & " $6 " & " $7 " & " "\\\pbox{\\boxwidth}{"$8"}" " & ",$4; if ($10 > 0) print $10"@\\#"$9 ; print "\\\\ \\\hline\n " }'|sed 's/ Diagnostics\//\\newline /g;s/{Diagnostics\/BasicDiagnostics\/StandardDAS/{/g'|sed 's/&\\newline/\& /g;s/{\\newline/\{/g;s/{ \\newline/\{/g'|tee tables/"$MONTH""$YEAR"tabletobeincl2latex
}
function docgen()
{
docum=document.tex
FROMM=$1
TOM=$2
YEAR=$3
timeperiod $FROMM $TOM $YEAR
echo '\documentclass[11pt,pdftex]{article}\usepackage[legalpaper, landscape, margin=2in]{geometry}
\usepackage{graphicx}\usepackage[utf8]{inputenc}\usepackage{longtable}\usepackage{pbox}\topmargin -3cm\oddsidemargin -2cm\textwidth 20cm\textheight 20cm\begin{document}' >$docum
for MONTH in `seq $FROMM $TOM`; do
echo "GOLEM Logbook for month:$MONTH \& year:20$YEAR" >>$docum
echo '
{\def\boxwidth{9cm}\small \begin{longtable}{ |p{19mm}|p{8mm}|p{8mm}|p{13mm}|p{45mm}|p{25mm}|p{8cm}|p{\boxwidth}|p{18mm}| } \hline
{\bf Date }&{\bf Time } & {\bf Session ID } & {\bf Vacuum } & {\bf Mission } & {\bf Setup } & {\bf Staff } & {\bf On stage wave} & {\bf Dose}\\ \hline
\input{'tables/"$MONTH""$YEAR"tabletobeincl2latex'} \end{longtable}}\'>>$docum
done
echo '\end{document}'>>$docum
pdflatex $docum
}
