#!/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/.*\(..
TMP_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/.*\(...



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

if [ "`date -d "$TMP_DATE" +%s`" -gt "`date -d "$LAST_DATE" +%s`" ]; then
    echo "$TMP_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.t
    mailx -s "$(echo -e "The last entry in the \042LOG OF TIME\042\nContent-Type: text/html")" test@mail.ru < result.txt

else
    echo "$TMP_DATE меньше даты $LAST_DATE"
fi

exit 0