#!/bin/sh


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

CLIENT="s2c"
COLLECTE="kalifoo"

cd /home/admin/export_auto_$COLLECTE/$CLIENT

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

mysql -pSQL1281 kalifoo < export.sql > "/var/www/export/"$CLIENT"/optin_"$CLIENT"_"$COLLECTE"_"$DATEFIN_FORMATEE".csv"


echo "Export hebdo $CLIENT/$COLLECTE du $DATEDEBUT au $DATEFIN exclu
" > corps_mail
echo "$COLLECTE : http://export.flinteractive.fr/"$CLIENT"/optin_"$CLIENT"_"$COLLECTE"_"$DATEFIN_FORMATEE".csv" >> corps_mail

mutt -s "Export $CLIENT/$COLLECTE $DATEDEBUT au $DATEFIN" etienne.tedde@flinteractive.fr -c fg@flinteractive.fr < corps_mail