From 6859200d482b72f9dc6483a3c27621d6e945736d Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Sun, 5 Jun 2011 20:50:04 +0200 Subject: [PATCH] Activates geocoding reminder for new geocoding. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- classes/geocoder.php | 14 ++++++++++++++ include/reminder/profile_update.inc.php | 3 ++- 2 files changed, 16 insertions(+), 1 deletion(-) diff --git a/classes/geocoder.php b/classes/geocoder.php index c5ff63e..01d5e3e 100644 --- a/classes/geocoder.php +++ b/classes/geocoder.php @@ -73,6 +73,20 @@ abstract class Geocoder { } return $firstLines; } + + // Returns the number of non geocoded addresses for a profile. + static public function countNonGeocoded($pid) + { + $count = XDB::fetchOneCell('SELECT COUNT(*) + FROM profile_addresses AS pa + WHERE pid = {?} AND type = \'home\' + AND NOT EXISTS (SELECT * + FROM profile_addresses_components AS pc + WHERE pa.pid = pc.pid AND pa.jobid = pc.jobid AND pa.groupid = pc.groupid + AND pa.type = pc.type AND pa.id = pc.id)', + $pid); + return $count; + } } // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: diff --git a/include/reminder/profile_update.inc.php b/include/reminder/profile_update.inc.php index c1ab4df..3785b6d 100644 --- a/include/reminder/profile_update.inc.php +++ b/include/reminder/profile_update.inc.php @@ -103,7 +103,8 @@ class ReminderProfileUpdate extends Reminder return false; } return !$profile->has_photo || $profile->is_old - || !is_null(self::ListMergeIssues($profile)); + || !is_null(self::ListMergeIssues($profile)) + || Geocoder::countNonGeocoded($profile->id()) > 0; } } -- 2.1.4