From: Fabio M. <man...@gm...> - 2010-09-15 00:53:34
|
Hello guys, I need to send an e-mail (or do other things) when a user is handling an issue for a specific period (4 days, for example). Is it possible to program this behaviour in Mantis or a better aproach is to execute a job every night checking the mantis_bug_history_table? Thanks in advance, -- Fabio M. Manzano |
From: David H. <hic...@op...> - 2010-09-15 00:59:25
|
On Tue, 2010-09-14 at 21:53 -0300, Fabio Manzano wrote: > I need to send an e-mail (or do other things) when a user is handling > an issue for a specific period (4 days, for example). Is it possible > to program this behaviour in Mantis or a better aproach is to execute > a job every night checking the mantis_bug_history_table? It's easiest to just setup a small script/cron job that checks the last handler change entry in mantis_bug_history_table (for each open bug with a handler assigned) to see if it was 4-5 days ago. I imagine you'll want to avoid sending duplicate emails (or only send duplicates once a day) which is something that is very easy to do with a nightly cron job. Regards, David |
From: Fabio M. <man...@gm...> - 2010-09-15 01:10:56
|
Hey David, thank you for the quick reply! Using this aproach, how can i use the PHP engine (or Mantis functions) to read the informations from MySQL and send an e-mail? Thanks, On Tue, Sep 14, 2010 at 9:57 PM, David Hicks <hic...@op...>wrote: > On Tue, 2010-09-14 at 21:53 -0300, Fabio Manzano wrote: > > I need to send an e-mail (or do other things) when a user is handling > > an issue for a specific period (4 days, for example). Is it possible > > to program this behaviour in Mantis or a better aproach is to execute > > a job every night checking the mantis_bug_history_table? > > It's easiest to just setup a small script/cron job that checks the last > handler change entry in mantis_bug_history_table (for each open bug with > a handler assigned) to see if it was 4-5 days ago. > > I imagine you'll want to avoid sending duplicate emails (or only send > duplicates once a day) which is something that is very easy to do with a > nightly cron job. > > Regards, > > David > > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > mantisbt-help mailing list > man...@li... > https://lists.sourceforge.net/lists/listinfo/mantisbt-help > -- Fabio M. Manzano |
From: Fabio M. <man...@gm...> - 2010-09-15 01:45:16
|
Oh, think I got it! My job should call something like "$ php my_script.php" from command line, right? And my_script.php can call Mantis functions. Thanks, On Tue, Sep 14, 2010 at 10:10 PM, Fabio Manzano <man...@gm...>wrote: > Hey David, thank you for the quick reply! > > Using this aproach, how can i use the PHP engine (or Mantis functions) to > read the informations from MySQL and send an e-mail? > > Thanks, > > > On Tue, Sep 14, 2010 at 9:57 PM, David Hicks <hic...@op...>wrote: > >> On Tue, 2010-09-14 at 21:53 -0300, Fabio Manzano wrote: >> > I need to send an e-mail (or do other things) when a user is handling >> > an issue for a specific period (4 days, for example). Is it possible >> > to program this behaviour in Mantis or a better aproach is to execute >> > a job every night checking the mantis_bug_history_table? >> >> It's easiest to just setup a small script/cron job that checks the last >> handler change entry in mantis_bug_history_table (for each open bug with >> a handler assigned) to see if it was 4-5 days ago. >> >> I imagine you'll want to avoid sending duplicate emails (or only send >> duplicates once a day) which is something that is very easy to do with a >> nightly cron job. >> >> Regards, >> >> David >> >> >> >> ------------------------------------------------------------------------------ >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> _______________________________________________ >> mantisbt-help mailing list >> man...@li... >> https://lists.sourceforge.net/lists/listinfo/mantisbt-help >> > > > > -- > Fabio M. Manzano > -- Fabio M. Manzano |
From: David H. <hic...@op...> - 2010-09-15 01:58:18
|
On Tue, 2010-09-14 at 22:45 -0300, Fabio Manzano wrote: > My job should call something like "$ php my_script.php" from command > line, right? And my_script.php can call Mantis functions. This is partially correct. It depends on your distribution of PHP. For instance, Gentoo has a number of different PHP binaries (php-fpm, php-cgi and php-cli) which are all slightly different. The FPM/CGI versions of PHP are designed to work within the context of a web server where HTTP environment variables are set. The CLI version is obviously designed to be run from the command line (and hence the HTTP related functions, $_GET, $_POST, etc won't work). I'm not sure how far you will get with loading the MantisBT API from the command line. It may require us to make some changes to skip over HTTP-specific stuff when we detect that the core is being loaded in a CLI environment. You could of course just write a completely separate script in the programming/scripting language of your choice. At the end of the day you're only going to make a few database queries so it won't be too complex. Regards, David |