~~META: status = active &relation firstimage = ~~

UzZas is TUI based minimalistic reminder of recurring events.

Main purpose is to periodically urge the user to complete the tasks which have to be done periodically - like biweekly changing the water in home aquarium, monthly payout to local mafia Protectors of the Throne goverment and so on.

uzzas.sh ACTION

ACTION could be one of:

• (add|-a|–add) - Add new entry
• (list|-l|–list) - List all entries sorted by due date
• (delete|-d|–delete) - Delete entry
• (today|-t|–today) - Show entries which are planned for today
• (tomorrow|-T|–tomorrow) - Show entries which are planned for tomorrow
• (ack|-A|–ack) - Mark entry as done and activate next recurrence
• (install|-i|–install) - Install UzZas (create uzzas.db and CRON entry)
• (ping|-p|–ping) - Graphical equivalent of -t
• (help|-h|–help) - help

1. Check if the dependencies are met (bash interpreter, sqlite3). If you want automatic notifications, you need also CRON and zenity.
2. Run “uzzas.sh -i”

$ ./uzzas.sh -i
==== UzZas installed ====
  See brmlab.cz/project/uzzas/start for more info

Run “uzzas.sh -a” and complete few challenging questins, see example below:

$ ./uzzas.sh -a
==== Enter new task ====
  First time planned to (yyyy-mm-dd):
2018-06-16
  Repeat each (days):
7
  Item...:
Aquarium
  ...containing:
Cutteries
  Action/note:
Wipe
ADD? (Y/n)
y
Added!

To get list of events, sorted by due-date proximity (most urgent up), run “uzzas.sh -l”

$ ./uzzas.sh -l
2018-06-16  3           krabice 1   plostenka   dugesia   
2018-06-16  7           Aquarium    Cutteries   Wipe      
2018-06-19  3           krabice 1.  plostenka   dugesia   
2018-06-23  7           Plostenkoi  Dugesie     Vymen vodu

To see what have to be done today, run “uzzas.sh -t” for terminal, or “uzzas.sh -p” for graphical overview:

$ ./uzzas.sh -t
2018-06-16  3           krabice 1   plostenka   dugesia   
2018-06-16  7           Aquarium    Cutteries   Wipe

To see what have to be done tomorrow, run “uzzas.sh -T”. The output is similar to the today's listing.

If the event is completed, it is automatically postponed to the defined reoccurence date. To do so, run “uzzas.sh -A”. In the list are displayed only tasks planned for the current day.

$ ./uzzas.sh -A
Select which task is done
1           krabice 1   plostenka   dugesia   
6           Aquarium    Cutteries   Wipe      
  Done is: (0 = nothing; a = ALL)
0
Nothing done!

If the reoccuring event is no longer valid, run “uzzas.sh -d”

$ ./uzzas.sh -d
==== Pick which action to delete (first column) ====
1           2018-06-16  krabice 1   plostenka   dugesia   
3           2018-06-19  krabice 1.  plostenka   dugesia   
5           2018-06-23  Plostenkoi  Dugesie     Vymen vodu
6           2018-06-16  Aquarium    Cutteries   Wipe      
  Delete: (0 = cancel)
0
Not removed!

uzzas.sh

#!/bin/bash
#
# UzZas - primitive boss behind your shoulder
#
# Dependency: CRON, sqlite3
#
# Usage:
#
#  uzzas.sh
#
 
dir="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
akce="$1"
db="$dir/uzzas.db"
 
case "$akce" in
  "add"|"-a"|"--add"|"new")
    echo "==== Enter new task ===="
    echo "  First time planned to (yyyy-mm-dd):"
    read day
    echo "  Repeat each (days):"
    read incr
    echo "  Item...:"
    read box
    echo "  ...containing:"
    read ins
    echo "  Action/note:"
    read note
    echo "ADD? (Y/n)"
    read ack
 
    if [[ "$ack" != "n" ]]; then
      sqlite3 "$db" "INSERT INTO zas VALUES (date('$day'),$incr,'$box','$ins','$note');"
      echo "Added!"
    else
      echo "Adding cancelled!"
    fi
    ;;
  "list"|"-l"|"--list"|"show"|"--show")
    echo ".mode column^SELECT * FROM zas ORDER BY day ASC;" | tr '^' '\n' | sqlite3 "$db"
    ;;
  "delete"|"del"|"-d"|"--delete")
    echo "==== Pick which action to delete (first column) ===="
    echo ".mode column^SELECT rowid,day,box,inside,note FROM zas ORDER BY rowid ASC;" | tr '^' '\n' | sqlite3 "$db"
    echo "  Delete: (0 = cancel)"
    read del
    if [[ "$del" > "0" ]]; then
      sqlite3 "$db" "DELETE FROM zas WHERE rowid='$del' LIMIT 1;"
      echo "Removed!"
    else
      echo "Not removed!"
    fi
    ;;
  "today"|"-t"|"--today")
    echo ".mode column^SELECT * FROM zas WHERE day=date('now');" | tr '^' '\n' | sqlite3 "$db"
    ;;
  "tomorrow"|"-T"|"--tomorrow")
    echo "==== Tomorrow TODO list ===="
    echo ".mode column^SELECT * FROM zas WHERE day=date('now','+1 day');" | tr '^' '\n' | sqlite3 "$db"
    ;;
  "ack"|"-A"|"--ack"|"done")
    echo "Select which task is done"
    echo ".mode column^SELECT rowid,box,inside,note FROM zas WHERE day=date('now') ORDER BY rowid ASC;" | tr '^' '\n' | sqlite3 "$db"
    echo "  Done is: (0 = nothing; a = ALL)"
    read hot
    if [[ "$hot" == "a" ]]; then
      sqlite3 "$db" "UPDATE zas SET day=date(day,'+'||increment||' day');"
      echo "All today's tasks postponed!"
    else
      if [[ "$hot" =~ ^[0-9]+$ ]] 2> /dev/null
      then
        if [[ "$hot" > "0" ]]; then
          sqlite3 "$db" "UPDATE zas SET day=date(day,'+'||increment||' day') WHERE rowid=$hot LIMIT 1;"
          echo "Task postponed!"
        else
          echo "Nothing done!"
        fi
      else
        echo "Invalid value!"
      fi
    fi
    ;;
  "install"|"-i"|"--install")
    touch "$db"
    sqlite3 "$db" "CREATE TABLE IF NOT EXISTS zas (day TIMESTAMP,increment INTEGER,box TEXT,inside TEXT,note TEXT);"
    (crontab -l 2>/dev/null; echo "0 8-23 * * * DISPLAY=:0 $dir/uzzas.sh ping") | crontab -
    echo "==== UzZas installed ===="
    echo "  See brmlab.cz/project/uzzas/start for more info"
    ;;
  "ping"|"-p"|"--ping") # Invoked via CRON, display graphical
    todo=$(echo ".headers on^.width 20 20 40^.mode column^SELECT box,inside,note FROM zas WHERE day=date('now');" | tr '^' '\n' | sqlite3 "$db")
    zenity --width=600 --info --text="$todo" --title="UzZas"
    ;;
  "help"|"-h"|"--help")
    echo "==== UzZas ===="
    echo "  Minimalistic reminder of recurrent events"
    echo " "
    echo "==== Dependencies ===="
    echo "  - BASH interpreter (b4ckd00r)"
    echo "  - sqlite3 (for storing the events)"
    echo "  - CRON (for recurring invocation)"
    echo "  - zenity (for graphical reminder)"
    echo " "
    echo "==== Usage ===="
    echo "  uzzas.sh ACTION"
    echo " "
    echo "  ACTION could b one of:"
    echo "  (add|-a|--add) - Add new entry"
    echo "  (list|-l|--list) - List all entries sorted by due date"
    echo "  (delete|-d|--delete) - Delete entry"
    echo "  (today|-t|--today) - Show entries which are planned for today"
    echo "  (tomorrow|-T|--tomorrow) - Show entries which are planned for tomorrow"
    echo "  (ack|-A|--ack) - Mark entry as done and activate next recurrence"
    echo "  (install|-i|--install) - Install UzZas (create uzzas.db and CRON entry)"
    echo "  (ping|-p|--ping) - Graphical equivalent of -t"
    echo "  (help|-h|--help) - This help"
    echo " "
    echo "==== See brmlab.cz/project/uzzas/start for more info ===="
    ;;
esac
 
exit