#!/bin/bash

mythfilldatabase --quiet

window=5
fill_str="MythFillSuggestedRunTime"
start_str="DailyWakeupStartPeriod1"
end_str="DailyWakeupEndPeriod1"
mysql_cmd="mysql -u mythtv -pmythtv mythconverg"
get_settab="SELECT value,data FROM settings"

dbfilltime=$($mysql_cmd -e"$get_settab" | /bin/grep $fill_str | /bin/sed -e"s/^$fill_str\t//" -e"s/T/ /" );
runtime=$(/bin/date -d "$dbfilltime" +%s);

# This stuff adjusts the suggested time because Mythwelcome currently
# does not accept wake up periods that cross midnight
suggesttime=$(/bin/date -d "$dbfilltime" +%H%M);
if [ $suggesttime -ge $[2360-$window] ]; then
    runtime=$[runtime-$window*60]
    newtime=$(/bin/date -d "1970-01-01 UTC $runtime sec" +%FT%T);
    set_fill="UPDATE settings SET data='$newtime' WHERE value='$fill_str'"
    $mysql_cmd -e"$set_fill"
elif [ $suggesttime -le $window ]; then
    runtime=$[runtime+$window*60]
    newtime=$(/bin/date -d "1970-01-01 UTC $runtime sec" +%FT%T);
    set_fill="UPDATE settings SET data='$newtime' WHERE value='$fill_str'"
    $mysql_cmd -e"$set_fill"
fi

start1=$(/bin/date -d "1970-01-01 UTC $[runtime-$window*60] sec" +%H:%M);
stop1=$(/bin/date -d "1970-01-01 UTC $[runtime+$window*60] sec" +%H:%M);

set_start="UPDATE settings SET data='$start1' WHERE value='$start_str'"
set_end="UPDATE settings SET data='$stop1' WHERE value='$end_str'"
$mysql_cmd -e"$set_start"
$mysql_cmd -e"$set_end"