Notification of overdue tasks in Redmine


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
59 views
Could you tell me the plugin, or advise how to configure.
Google for a week, nothing
Thank you!

Environment: Redmine version 2.1.2.stable Ruby version 1.8.7 (x86_64-linux) Rails version 3.2.8 Environment production Database adapter MySQL Redmine plugins: redmine_jquery_file_upload 0.0.1 redmine_lightbox 0.0.1 
by | 59 views

3 Answers

0 like 0 dislike
RAILS_ENV="production" rake redmine:send_reminders days=7 users="1,2,44" 

Send notifications about tasks which are due in 7 days or less (including overdue).
\r
Parameters:
\r
    \r
  • days: number of days to complete (default 7)
  • \r
  • trackerid of tracker (defaults to all)
  • \r
  • project: project id (default all)
  • \r
  • users: list of user IDs which you want to send notifications
  • \r
by
0 like 0 dislike
Ah, so I did, just the task is to send notifications only about overdue tasks. To make it clear that this is overdue, ie, as something to highlight them. Preferably a plugin and preferably free. There is no such option — I'll leave that, thank you.
by
0 like 0 dislike
the script notifies the Director, performer and observers that today is the deadline for the task.

in the first select you need ("1","2","4") replace those IDs under which the task is considered incomplete. view the line id and the name of the status in the database table issue_statuses.

and don't forget to change the variables with the parameters of database access and email account.

#!/bin/bash

mysql_h="db.local"
mysql_l="redmine"
mysql_p="password"
mysql_db="redmine"

mail_h="mail.local"
mail_l="mail_login"
mail_p="mail_pass"

date=`date +%Y-%m-%d`

#the directory in which the script
cd /usr/home/scripts/redmine/
mkdir -p data
rm-rf data/*

/usr/local/bin/mysql -h$mysql_h -u$mysql_l -p$mysql_p -D$mysql_db -e \\
"select id,assigned_to_id,author_id from issues where due_date='$date' and status_id in ("1","2","4")" \\
| grep -v id | while read l
do
issue_id=${l% * *}
mkdir data/$issue_id
echo 'redmine.local/issues/'$issue_id'' > data/$issue_id/body.html

assigned_to_id=${l% *}
assigned_to_id=${assigned_to_id#* }
echo $assigned_to_id >> data/$issue_id/id_list.txt

author_id=${l#* * }
echo $author_id >> data/$issue_id/id_list.txt

/usr/local/bin/mysql -h$mysql_h -u$mysql_l -p$mysql_p -D$mysql_db -e \\
"select user_id from sales where watchable_id='$issue_id'" \\
| grep -v user_id | while read m
do
echo $m >> data/$issue_id/id_list.txt
done

cat data/$issue_id/id_list.txt | sort | uniq | while read n
do
let i++
if [ $i-eq 1 ]
then x=\\"$n\\"
else x=$x\\"$n\\"
fi
echo $x > data/$issue_id/id_tmp.txt
done

/usr/local/bin/mysql -h$mysql_h -u$mysql_l -p$mysql_p -D$mysql_db -e \\
"select mail from users where id in (`cat data/$issue_id/id_tmp.txt`)" \\
| while read mail
do
if [ "$mail" != the "mail" ]
then
/usr/local/bin/smtp-cli \\
--missing-modules-ok --server=$mail_h --port=465 --ssl --ipv4 \\
--user=$mail_l --pass=$mail_p --from="Redmine <$mail_l>" \\
--to "$mail" --subject="Redmine Issue DEADLINE $issue_id" \\
--body-html=data/$issue_id/body.html
fi
done
done
by

Related questions

0 like 0 dislike
4 answers
0 like 0 dislike
2 answers
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked Mar 22, 2019 by qweewq
0 like 0 dislike
1 answer
110,608 questions
257,186 answers
0 comments
28,015 users