AppleScript/OmnifocusTaskDoneSetFolderTags.sh at master · jannerchang/AppleScript · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
#!/bin/sh
#
# Rob Trew www.complexpoint.net
# https://github.com/RobTrew/tree-tools
#
# Ver 0.05
# Logs today's OmniFocus DONE items in DAYONE,
# Avoiding duplication if called several times in one day
# ( Maintains a text file list of which items have already been logged today )

# Requires installation of the [DayOne Command Line Interface](http://dayoneapp.com/tools/)
# For more details of the dayone command line tool, try:
# man -t 'dayone' | pstopdf -i -o ~/Desktop/dayone.pdf

# Can be used with [HAZEL](http://www.noodlesoft.com/hazel.php) rules like:
## Watch:   ~/Library/Caches/com.omnigroup.OmniFocus
## or:      ~/Library/Caches/com.omnigroup.OmniFocus.MacAppStore
##  Date Last Modified is after Date last Matched
##  <AND> Date last Modified is not in the last 5 mins

# (The delay reduces the number of log events,
# allowing time for a small set of actions within one project to be marked as done,
# without undue fragmentation into separate DayOne Log events)

# Ver 3 Improves handling of done items from Inbox,
# and makes trailling project colon a live link back to the project in the OmniFocus database
# Ver 4 facilitates choice between plain and bold Project title lines ($PROJECT_PREFIX below)

PROJECT_PREFIX="## " # Edit this to an empty string (see next line) for unbolded Day-One project lines.
#PROJECT_PREFIX=""

DONE_LOG_FOLDER="$HOME"
DONE_TODAY_FILE="$DONE_LOG_FOLDER/DoneToday.txt"
LOGGED_TODAY_FILE="$DONE_LOG_FOLDER/LoggedToday.txt"
LOG_NOW_FILE="$DONE_LOG_FOLDER/JustDone.txt"

# 生成的执行 AS 命令的脚本文件（临时）
AS_SCRIPT_FILE="$DONE_LOG_FOLDER/as.sh"
# Finder
FINDER="\"Finder"
# Finder 里的根目录
FINDER_FOLDER_PREFIX="\"/Users/janner/Dropbox/办案/2015/"

OFOC="com.omnigroup.OmniFocus2"
if [ ! -d "$HOME/Library/Containers/com.omnigroup.OmniFocus2/Data/Library/Caches/$OFOC" ]; then OFOC=$OFOC.MacAppStore; fi
OFQUERY="sqlite3 $HOME/Library/Containers/com.omnigroup.OmniFocus2/Data/Library/Caches/$OFOC/OmniFocusDatabase2"
START_OF_DAY=$(date -v0H -v0M -v0S +%s) #Midnight at the start of today: set the time component to 00:00
TODAY=$(date "+%Y-%m-%d")

# Suggestions welcome here - not sure this simple arithmetic works for New Zealand's DST +1300 UTC
ZONERESET=$(date +%z | awk '
{if (substr($1,1,1)!="+") {printf "+"} else {printf "-"} print substr($1,2,4)}')
YEARZERO=$(date -j -f "%Y-%m-%d %H:%M:%S %z" "2001-01-01 0:0:0 $ZONERESET" "+%s")
DONE="($YEARZERO + t.dateCompleted)";

# This join includes context & folder, to allow for broader queries
JOIN="(((task tt left join projectinfo pi on tt.containingprojectinfo=pi.pk) t
left join task p on t.task=p.persistentIdentifier)
left join context c on t.context = c.persistentIdentifier)
left join folder f on t.folder=f.persistentIdentifier"

MATCHES="$DONE > $START_OF_DAY"
# doneTOTAL=$($OFQUERY "SELECT count(*) FROM $JOIN WHERE $MATCHES;")
# printf "DONE TODAY (%s)\n\n" "$doneTOTAL"

$OFQUERY "
SELECT c.persistentIdentifier, p.persistentIdentifier, t.persistentIdentifier, strftime('%Y-%m-%d|%H:%M',$DONE, 'unixepoch'), p.name, c.name, t.name
FROM $JOIN WHERE $MATCHES ORDER BY t.datecompleted
" > $DONE_TODAY_FILE

echo "done today:"
cat $DONE_TODAY_FILE

# Determine what, if anything needs to be logged
if [ -f $LOGGED_TODAY_FILE ]; then
    if grep -q $TODAY $LOGGED_TODAY_FILE; then # Find items in the full DONE list which have NOT yet been logged
       awk 'FNR==NR{old[$0];next};!($0 in old)' $LOGGED_TODAY_FILE $DONE_TODAY_FILE > $LOG_NOW_FILE
    else # nothing yet logged from today
        cp -f $DONE_TODAY_FILE $LOG_NOW_FILE
        rm $LOGGED_TODAY_FILE  # start a fresh 'LoggedToday.txt'
    fi
else # Log the whole file, then copy done file to logged file
   cp -f $DONE_TODAY_FILE $LOG_NOW_FILE
fi

echo "log new:"
cat $LOG_NOW_FILE

echo "parse:"
# then if the log_now file contains entries, log them, and append the newly logged list to the existing logged list
if [ -s $LOG_NOW_FILE ] ; then
echo "" > "tmp_pretty.txt"
cat $LOG_NOW_FILE | awk -v prj_prfx=$PROJECT_PREFIX -v finder=$FINDER -v finder_folder=$FINDER_FOLDER_PREFIX -v as_file=$AS_SCRIPT_FILE '
BEGIN {FS="\|"; prj=0; str=""}
{
    if ($7=="开庭"){system("tag -s 1待合议 " finder_folder $6 "\"")}
    else if ($7=="合议") {system ("tag -s 2已合议 " finder_folder $6 "\"")}
    else if ($7=="写判决") {system ("tag -s 3待审批 " finder_folder $6 "\"")}
    else if ($7=="审批") {system ("tag -s 4待打印 " finder_folder $6 "\"")}
    else if ($7=="网上报结") {system ("tag -s 5待退卷 " finder_folder $6 "\"")}
    else if ($7=="出判退卷") {system ("tag -s 6已结案 " finder_folder $6 "\"")}
    if (prj!=$6) {prj=$6;
        if (prj!="") {print ("\n" prj_prfx prj "[:](omnifocus:///task/" $2 ")") >> "tmp_pretty.txt" }
        else {print ("\nInbox[:](omnifocus:///task/" $3 ")") >> "tmp_pretty.txt"}
    }
  if ($8!=prj) {print ("- " $8 " @done(" $5 ")") >> "tmp_pretty.txt"  }
  else {{print "- *Project completed* @done(" $5 ")"  >> "tmp_pretty.txt" }}
}'
# cat tmp_pretty.txt
cat tmp_pretty.txt
rm tmp_pretty.txt
cat $LOG_NOW_FILE >> $LOGGED_TODAY_FILE  # Append the list of logged tasks to avoid duplication

#if [ -s $AS_SCRIPT_FILE ]; then
#  echo "as file:"
#  cat $AS_SCRIPT_FILE
#  chmod +x $AS_SCRIPT_FILE
#  sh $AS_SCRIPT_FILE
#  rm $AS_SCRIPT_FILE
#fi

# Optional acoustic feedback on completion... Comment the next line out if it's distracting
afplay /System/Library/Sounds/Pop.aiff
fi