DATEDEBUT=`date "--date=-1 day" +%Y-%m-%d`
DATEFIN=`date +%Y-%m-%d`
DATEFIN_FORMATEE=`date +%y%m%d`

#DATEDEBUT='2012-10-14'
#DATEFIN='2012-10-15'
#DATEFIN_FORMATEE='121015'

CLIENT="edn"
COLLECTE="kalifoo"

cd /var/scripts/export_auto/kalifoo/$CLIENT

cat export.sql.tpl | sed -e"s/##DATEDEBUT##/$DATEDEBUT/" | sed -e"s/##DATEFIN##/$DATEFIN/" > export.sql

mysql --host=87.98.142.231 -uroot -pSQL1281 kalifoo < export.sql | sed -e's/;/ /g' | sed -e's/\t/";"/g' | sed -e's/^/"/' | sed -e's/$/"/' | sed -e's/\\//g' > "/var/scripts/export_auto/kalifoo/"$CLIENT"/collecte_"$CLIENT"_"$COLLECTE"_"$DATEFIN_FORMATEE".csv"

echo "Export hebdo $CLIENT/$COLLECTE du $DATEDEBUT au $DATEFIN exclu
" > corps_mail
echo `wc -l "/var/scripts/export_auto/kalifoo/"$CLIENT"/collecte_"$CLIENT"_"$COLLECTE"_"$DATEFIN_FORMATEE".csv"  | cut -d' ' -f1` lignes >> corps_mail

mutt -s "Export $CLIENT/$COLLECTE $DATEDEBUT au $DATEFIN" -a "/var/scripts/export_auto/kalifoo/"$CLIENT"/collecte_"$CLIENT"_"$COLLECTE"_"$DATEFIN_FORMATEE".csv" -- marine.daniel@flinteractive.fr [-c florent.mazzero@flinteractive.fr production@cdirecte.com v.alessi@cdirecte.com ] < corps_mail

#[-c florent.mazzero@flinteractive.fr d.agostinho@cdirecte.com production@cdirecte.com v.alessi@cdirecte.com ]