diff options
| author | matthew <matthew> | 2007-05-09 15:13:27 +0000 |
|---|---|---|
| committer | matthew <matthew> | 2007-05-09 15:13:27 +0000 |
| commit | 1c75223efecb7cb867e320deb4d49b9f7c9000ad (patch) | |
| tree | 40fab9ad5912ebf25cbbb6202e810288219f7328 /bin/send-reports | |
| parent | 401900b0ea449c993cc8956bc296cf994c6bd94a (diff) | |
Update laststatechange upon sending to council (okay, it's a state change
from confirmed->confirmed, but it'll do).
Diffstat (limited to 'bin/send-reports')
| -rwxr-xr-x | bin/send-reports | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/bin/send-reports b/bin/send-reports index 255872317..cdfbc4616 100755 --- a/bin/send-reports +++ b/bin/send-reports @@ -6,7 +6,7 @@ # Copyright (c) 2007 UK Citizens Online Democracy. All rights reserved. # Email: matthew@mysociety.org. WWW: http://www.mysociety.org # -# $Id: send-reports,v 1.35 2007-04-29 18:06:18 matthew Exp $ +# $Id: send-reports,v 1.36 2007-05-09 15:13:27 matthew Exp $ use strict; require 5.8.0; @@ -129,7 +129,8 @@ If you know of an appropriate contact address, please do get in touch. ]\n\n"; $result = mySociety::Util::send_email($email, mySociety::Config::get('CONTACT_EMAIL'), @recips); } if ($result == mySociety::Util::EMAIL_SUCCESS) { - dbh()->do('UPDATE problem SET whensent=ms_current_timestamp() WHERE id=?', {}, $row->{id}); + dbh()->do('UPDATE problem SET whensent=ms_current_timestamp(), + laststatechange=ms_current_timestamp() WHERE id=?', {}, $row->{id}); dbh()->commit(); } else { dbh()->rollback(); |