# e.g. bash script.sh 38600 39000


export PGPASSWORD=`cat /golem/production/psql_password` # zaklad pro command line



FROM_SHOT=$1
TO_SHOT=$2
docum=document.tex

psql -c "SELECT to_char(to_timestamp(start_timestamp, 'YYYY-MM-DD HH24:MI' ),'DD.MM, Dy'),to_char(to_timestamp(start_timestamp, 'YYYY-MM-DD HH24:MI' ),'HH:MI'), start_shot_no, start_chamber_pressure,session_mission, session_setup, staff_list, onstage_wave, '\\ \hline'  FROM public.sessions WHERE (start_shot_no BETWEEN $FROM_SHOT AND $TO_SHOT)  ORDER BY start_shot_no ASC LIMIT 50;" -qAt -U  golem golem_database|sort  -u -t '|' -k1,1 -k5,5 |sort -t '|' -k3,3|sed 's/&/\\&/g;s/\_/\\_/g'|awk -F '|' '{printf $1 " & " $2 " & " $3 " &  %3.1e & "  $5 " & " $6 " & " $7 " & " "\\pbox{10cm}{"$8"}" " \\\\ \\\hline\n ",$4 }'|sed 's/ Diagnostics\//\\newline /g;s/{Diagnostics\//{/g'|sed 's/&\\newline/\& /g'|tee tabletobeincl


echo '\documentclass[12pt,pdftex]{article}\usepackage[legalpaper, landscape, margin=2in]{geometry}
\usepackage{graphicx}\usepackage[utf8]{inputenc}\usepackage{pbox}\topmargin -3cm\oddsidemargin -2.5cm\textwidth 20cm\textheight 27cm\begin{document}' >$docum
echo '\title{Logbook GOLEM}\maketitle' >>$docum
echo '
{\small \begin{tabular}{ |p{19mm}|p{8mm}|p{8mm}|p{13mm}|p{5cm}|p{5cm}|p{5cm}|p{10cm}| } \
\input{'tabletobeincl'} \end{tabular}} \newpage\'>>$docum
echo '\end{document}'>>$docum


pdflatex $docum