Revision 97eb33aa901a4f11c2e8a690f016d0f7fca7dbaa (click the page title to view the current version)
# e.g. bash script.sh 4 22
export PGPASSWORD=`cat /golem/production/psql_password` # zaklad pro command line
MONTH=$1
YEAR=$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 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;" -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{\\boxwidth}{"$8"}" " \\\\ \\\hline\n ",$4 }'|sed 's/ Diagnostics\//\\newline /g;s/{Diagnostics\/BasicDiagnostics\/StandardDAS/{/g'|sed 's/&\\newline/\& /g;s/{\\newline/\{/g;s/{ \\newline/\{/g'|tee tables/"$MONTH""$YEAR"tabletobeincl
echo '\documentclass[12pt,pdftex]{article}\usepackage[legalpaper, landscape, margin=2in]{geometry}
\usepackage{graphicx}\usepackage[utf8]{inputenc}\usepackage{longtable}\usepackage{pbox}\topmargin -3cm\oddsidemargin -1.5cm\textwidth 20cm\textheight 20cm\begin{document}' >$docum
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{5cm}|p{3cm}|p{8cm}|p{\boxwidth}| } \hline
{\bf Date }&{\bf Time } & {\bf Shot\# } & {\bf Vakuum } & {\bf Mission } & {\bf Setup } & {\bf Staff } & {\bf On stage wave}\\ \hline
\input{'tables/"$MONTH""$YEAR"tabletobeincl'} \end{longtable}} \newpage\'>>$docum
echo '\end{document}'>>$docum
pdflatex $docum
