export GPG_TTY="$(tty)"
export EDITOR="$(which vim)"
export LESS='-RFX'
export HISTCONTROL='ignoredups'
export HISTTIMEFORMAT="<%a %b %d @ %H:%M:%S> "
export HISTSIZE=-1
export HISTFILESIZE=-1

shopt -s checkwinsize

alias ls='ls --color=auto'
alias grep='grep --color=auto'
alias http='http -p HBhb'
alias last='last -w'
alias radlast='radlast -w'
alias checkhours="echo 'SELECT MIN(date) AS date_____, WEEK(date,6) AS week, SEC_TO_TIME(SUM(TIME_TO_SEC(time_out)-TIME_TO_SEC(time_in))) AS time FROM timesheet WHERE user_id = 50 GROUP BY YEARWEEK(date,6);' | mysql"
alias dailyhours="echo 'SELECT date AS date_____, WEEK(date,6) AS week, DAY(date) AS day, RPAD(DAYNAME(date),10,'\"'\"' '\"'\"') AS dayn_____, SEC_TO_TIME(SUM(TIME_TO_SEC(time_out)-TIME_TO_SEC(time_in))) AS time_____, ROUND(SUM(TIME_TO_SEC(time_out)-TIME_TO_SEC(time_in))/60/60,2) AS time2____ FROM timesheet WHERE user_id = 50 AND MONTH(date) = MONTH(NOW()) AND YEAR(date) = YEAR(NOW()) GROUP BY date;' | mysql"

# vim: nosmarttab noexpandtab ts=4