#!/bin/bash

USER='root'
PASSWORD='123456'
QUERY="SELECT e.employee, w.time_from, w.time_to, w.description, w.add_date, w.ip FROM employee e INNER JOIN wtime w ON e.id = w.empl_id WHERE e.dept_id = 1 ORDER BY w.add_date DESC LIMIT 30; \q"


LAST_DATE=`mysql --user=$USER --password=$PASSWORD -e "USE timelog;" -e "SELECT e.employee, w.add_date FROM employee e INNER JOIN wtime w ON e.id = w.empl_id WHERE e.dept_id = 1 ORDER BY w.add_date DESC LIMIT 1; \q" -n -s | sed "s/.*\(...................$\)/\1/"`
TEMP_DATE=`mysql --user=$USER --password=$PASSWORD -e "USE timelog;" -e "SELECT e.employee, w.add_date FROM employee e INNER JOIN wtime w ON e.id = w.empl_id WHERE e.dept_id = 1 ORDER BY w.add_date DESC LIMIT 1; \q" -n -s | sed "s/.*\(...................$\)/\1/" > TEMPDATE.TXT`


#LAST_DATE="2017-12-12 12:12:12"
#TMP_DATE="2012-12-12 12:12:12"




GET_TEMP_DATE=`cat TEMPDATE.TXT`


if [ "$GET_TEMP_DATE" \> "$LAST_DATE" ]; then
    echo "$GET_TEMP_DATE больше даты $LAST_DATE"

    mysql --default-character-set=utf8 --user=$USER --password=$PASSWORD -e "USE timelog;" -e "$QUERY" -E -L -n | sed 's/employee/ФИО/;s/add_date/Дата записи/;s/time_from/C/;s/time_to/До/;s/description/Причина/;s/ip/IP Адрес/' > result.txt
    mailx -s "$(echo -e "The last entry in the \042LOG OF TIME\042\nContent-Type: text/html")" test@mail.ru < result.txt

else
    echo "$LAST_DATE" > LASTDATE.txt
    echo "$TEMP_DATE меньше даты $LAST_DATE"
fi

exit 0