#!/bin/sh

#echo "Content-type: text/csv\n"

# set environment variables.
    . /u/catcom/catcom_vars

OPDIRCSVFILE="DOD00opdir.csv"

###################################
# set working dir
cd /u/catcom/t21web/direnq

###################################
# get lock
#LOCKFILE="/tmp/t21websql.lok"
#while true
#do
#	if [ ! -f "$LOCKFILE" ]; then
#		break;
#	fi
#	sleep 2
#done
#touch $LOCKFILE

###########################################################################
tmpfile1="/tmp/webopdirtmp1_$$.unl"
tmpfile2="/tmp/webopdirtmp2_$$.unl"

rm -f "$tmpfile1"
rm -f "$tmpfile2"

runisql <<SQLCMD0
database catcom;
unload to "$tmpfile1" DELIMITER "|"

select dt.recordno,
 dt.general2[1,19] surname, dt.prefname[1,10] firstname,
 dt.mailbox[1,3] initials, dt.telephone[1,7] rank, dt.surname[1,12] telephone,
 dt.firstinit[1,11] location, dt.division[1,10] division,
 dt.pstnindial[1,9] branch,
 dt.department[1,10] directorate, dt.exchangeline[1,10] title,
 dt.general1[1,12] mobile,
 dt.generalmode[1,1] speakeasy, dt.status[1,1] restriction,
 dt.equip_type[1,2] equip_type, dt.fgroup[1,1] print,
 dt.title[1,22] comments,
 "images/TransmitCompfinal1.jpg", "documents/roster1.htm",
 dm.msg1, dm.msg2, dm.msg3, dm.msg4, dm.msg5, dm.msg6, dm.msg7, dm.msg8, dm.msg9
from directtemplate dt, outer dirmesg dm
where dt.recordno = dm.recordno
    and dt.secure_code = "Y"
order by 2, 3, 5
SQLCMD0

(
# csv header

echo "\
RecordNo,\
]10~01Surname____________,\
]10~02First_Name,\
]10~03Initials,\
]10~05!Rank___,\
]10~04!#Phone_Number,\
^1]10~08Location___,\
^1]10~09Division__,\
^1]10~10Branch___,\
^1]10~11Directorate,\
^2]10~06Title_____,\
^2]11~07Mobile_Phone,\
^2]10~13Speakeasy,\
^4]10~14Restriction,\
^4]10~15Equip_Type,\
^4]10~16Print,\
^3]10~12Comments______________,\
Picture,Document,\
Msg1,Msg2,Msg3,Msg4,Msg5,Msg6,Msg7,Msg8,Msg9"

# csv data
#cat $tmpfile1 | sed -e 's/,$//;s/\"/\\\"/g;s/ *\,/\,/g'
cat $tmpfile1 | sed -e 's/\|$//;s/\,/\\\,/g;s/|/\,/g;s/\"/\\\"/g;s/ *\,/\,/g'

) >"$tmpfile2"

cp "$tmpfile2" "$OPDIRCSVFILE"

rm -f "$tmpfile1"
rm -f "$tmpfile2"

###############################
# remove lock
#rm -f $LOCKFILE
###############################

exit 0