Merge remote-tracking branch 'upstream/4.4' into 4.4-master-2013-11-27-05-47-07
[civicrm-core.git] / bin / deprecated / RespondentProcessor.php
index b8bab74bb86752b8dc16e9cb58c55109ad8651c8..f9efea1652170f405b87a4ad961d5af026a31828 100644 (file)
@@ -1,7 +1,7 @@
 <?php
 /*
  +--------------------------------------------------------------------+
- | CiviCRM version 4.3                                                |
+ | CiviCRM version 4.4                                                |
  +--------------------------------------------------------------------+
  | Copyright CiviCRM LLC (c) 2004-2013                                |
  +--------------------------------------------------------------------+
@@ -28,7 +28,7 @@
 
 /*
  * This file check and update the survey respondents.
- * 
+ *
  */
 
 require_once '../civicrm.config.php';
@@ -59,14 +59,14 @@ class CRM_RespondentProcessor {
     $releasedCount = 0;
     if ($reserveStatusId && !empty($surveyActivityTypesIds)) {
       $query = '
-    SELECT  activity.id as id, 
+    SELECT  activity.id as id,
             activity.activity_date_time as activity_date_time,
             survey.id as surveyId,
             survey.release_frequency as release_frequency
       FROM  civicrm_activity activity
-INNER JOIN  civicrm_survey survey ON ( survey.id = activity.source_record_id ) 
-     WHERE  activity.is_deleted = 0 
-       AND  activity.status_id = %1 
+INNER JOIN  civicrm_survey survey ON ( survey.id = activity.source_record_id )
+     WHERE  activity.is_deleted = 0
+       AND  activity.status_id = %1
        AND  activity.activity_type_id IN ( ' . implode(', ', $surveyActivityTypesIds) . ' )';
       $activity = CRM_Core_DAO::executeQuery($query, array(1 => array($reserveStatusId, 'Positive')));
       $releasedIds = array();