#!/bin/sh

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

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

OPDIRCSVFILE="TF201opdir.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/webopdirtmp$$.unl"

rm -f $tmpfile1

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

select dt.recordno, dc.surname, dc.firstname, dt.extension, dc.department, dc.division, dc.title, dc.location, dc.telephone, dt.extgroupunique, gg.parentgroupid, dc.faxno, dc.empid, dt.equip_type[1,6], dc.mobile, dt.site[1,4], dc.pager, dc.email, "", "", dm.msg1, dm.msg2, dm.msg3, dm.msg4, dm.msg5, dm.msg6, dm.msg7, dm.msg8, dm.msg9
from directtemplate dt, directcustom dc, outer dirmesg dm, outer gengroup gg
where dt.recordno = dc.recordno
    and dt.recordno = dm.recordno
    and dt.extgroupunique = gg.childgroupid
    and dt.secure_code = "Y"
order by 2, 3, 5
SQLCMD0

(
# csv header
echo "RecordNo,Surname________,Firstname_,#Extn,Department____,DIV,Title_________,Location___,[#Telephone_,[#GroupID_,[#ParentID,[#Fax_Number,[#Emp_ID,[Equip_,[#Mobile____,[Site,[#Access_Pager,Email______________________________,Picture,Document,Msg1,Msg2,Msg3,Msg4,Msg5,Msg6,Msg7,Msg8,Msg9"

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

) >$OPDIRCSVFILE

rm -f $tmpfile1

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

exit 0