#! /bin/bash

case $DEBUG in
  1) set -x
     ;;
  *)
     ;;
esac

today=`date '+%Y%m%d'`
today_human=`date '+%d/%m/%Y'`

error() {
    echo "ERROR:$0:$date: $1" 1>&2
    echo "ERROR:$0:$date: $1" >> $LOGFILE
}

exec_sql() {
    exec-sql -H ${DBHOST} -d ${DBNAME} -u "${DBUSER}" -p "${DBPWD}" -l $LOGFILE -F ';' -c "$1" | dos2unix --
    if [ $? -ne 0 ]
    then
	error "cannot execute $1 on ${DBNAME}@${DBHOST}"
    fi
}

test=0

TMPDIR=/tmp/`whoami`
mkdir -p ${TMPDIR}
if [ $? -ne 0 ]
then
    error "cannot mkdir -p ${TMPDIR}"
    exit 1
fi

LOCKFILE=${TMPDIR}/`basename $0 .sh`_${APPLICATION}.lock


if [ -f ${LOCKFILE} ]
then
	rm ${LOCKFILE}
fi

if [ -f ${LOCKFILE} ]
then
    error "$0 already running ..."
    exit 1
fi

# BEGIN
touch ${LOCKFILE}

cc=""

while true
do
    case $1 in
	-t)
	    to="$2"
	    shift 2
	    ;;
	-c)
	    cc=" -c $2"
	    shift 2
	    ;;
	*)
	    break
	    ;;
    esac
done

cd ${TMPDIR}

XPORT_FILE=mails.csv

exec_sql "SELECT DISTINCT e.code, s.raison, con.ztitle, con.email, s.email FROM contact con, cible c, travaille_pour tp, societe s, employe e, prospection p WHERE ((con.email IS NOT NULL and con.email != '') or (s.email is not null and s.email != '')) AND c.ref_contact = con.uid AND c.ref_statut=0 AND con.ref_statut=0 AND (c.refus_mail is null or c.refus_mail = false) AND tp.ref_personne_physique = con.uid AND tp.ref_societe = s.uid AND s.ref_statut=0 AND tp.fin IS NULL AND tp.ref_statut = 0 and p.ref_cible = c.uid and p.ref_statut = 0 and p.ref_employe = e.uid AND e.ref_statut=0 AND p.fin is null;" > ${XPORT_FILE}

metasend -S 2500000 -b -f ${XPORT_FILE} -m application/xls\;name=\"${XPORT_FILE}\" -s "export ${XPORT_FILE}" -t $to $cc

cd - > /dev/null 2>&1

# END										
rm -f ${LOCKFILE}
exit $err