dis val

#!/bin/bash
MYDB=3access
MYUSER=imasdetres
MYPASS=imasdetres
COMPANY="$1"
COMPANY_NO_WHITESPACE="$(echo -e "${COMPANY}" | tr -d '[:space:]')"
DATE=`date +%Y-%m-%d`
OUTPUTFILE1=descuentosDiaCantidad.csv
OUTPUTFILE2=descuentosDiaPorcentaje.csv

if [ -z "$1" ]
  then
    echo "Error: falta el nombre de la compañía asociada a los descuentos"
    exit -1
fi
OUTPUTFILE1=$COMPANY_NO_WHITESPACE-$DATE-$OUTPUTFILE1
OUTPUTFILE2=$COMPANY_NO_WHITESPACE-$OUTPUTFILE2
echo "Buscando descuentos generados hoy ($DATE) asociados a la compañía \"$COMPANY\""
mysql -D$MYDB -u$MYUSER -p$MYPASS -se "select dt_ticketNumber from discountTicket join client on client.cl_id = discountTicket.dt_id_company where date(dt_registrationDate) = date(now()) and dt_type = 1 and client.cl_name='$COMPANY' and discountTicket.dt_printed != 1;" > "$OUTPUTFILE1"
echo "Guardados descuentos de cantidad en $OUTPUTFILE1"
mysql -D$MYDB -u$MYUSER -p$MYPASS -se "update discountTicket join client on client.cl_id = discountTicket.dt_id_company set discountTicket.dt_printed = 1 where date(dt_registrationDate) = date(now()) and dt_type = 1 and client.cl_name='$COMPANY';"
echo "Activados tickets de cantidad"
#mysql -D$MYDB -u$MYUSER -p$MYPASS -se "select dt_ticketNumber from discountTicket join client on client.cl_id = discountTicket.dt_id_company where date(dt_registrationDate) = date(now()) and dt_type  in (2,4) and client.cl_name='$COMPANY' and discountTicket.dt_printed != 1;" > "$OUTPUTFILE2"
#echo "Guardados descuentos de porcentaje en $OUTPUTFILE2"
#mysql -D$MYDB -u$MYUSER -p$MYPASS -se "update discountTicket join client on client.cl_id = discountTicket.dt_id_company set discountTicket.dt_printed = 1 where date(dt_registrationDate) = date(now()) and dt_type  in (2,4) and client.cl_name='$COMPANY';"
#echo "Activados tickets de porcentaje"