From 1513a53fc6f3f6f37ebf7091b32f1b7b88ccdb52 Mon Sep 17 00:00:00 2001
From: Seamus Lee <seamuslee001@gmail.com>
Date: Thu, 21 Nov 2019 17:29:41 +1100
Subject: [PATCH] Add in unit test of Campaign BAO query voter clause

---
 CRM/Campaign/BAO/Query.php                   |  2 +-
 tests/phpunit/CRM/Campaign/BAO/QueryTest.php | 39 ++++++++++++++++++++
 2 files changed, 40 insertions(+), 1 deletion(-)
 create mode 100644 tests/phpunit/CRM/Campaign/BAO/QueryTest.php

diff --git a/CRM/Campaign/BAO/Query.php b/CRM/Campaign/BAO/Query.php
index 02e251f760..8e3191cbcc 100644
--- a/CRM/Campaign/BAO/Query.php
+++ b/CRM/Campaign/BAO/Query.php
@@ -505,7 +505,7 @@ INNER JOIN  civicrm_custom_group grp on fld.custom_group_id = grp.id
         $tempTable = CRM_Utils_SQL_TempTable::build();
         $tempTableName = $tempTable->getName();
         CRM_Core_DAO::executeQuery("DROP TEMPORARY TABLE IF EXISTS {$tempTableName}");
-        $tempTable->createWithColumns('id int unsigned NOT NULL AUTO_INCREMENT, survey_contact_id int unsigned NOT NULL, PRIMARY KEY ( id )')
+        $tempTable->createWithColumns('id int unsigned NOT NULL AUTO_INCREMENT, survey_contact_id int unsigned NOT NULL, PRIMARY KEY ( id )');
 
         $batch = 100;
         $insertedCount = 0;
diff --git a/tests/phpunit/CRM/Campaign/BAO/QueryTest.php b/tests/phpunit/CRM/Campaign/BAO/QueryTest.php
new file mode 100644
index 0000000000..21ecce3e1a
--- /dev/null
+++ b/tests/phpunit/CRM/Campaign/BAO/QueryTest.php
@@ -0,0 +1,39 @@
+<?php
+/*
+ +--------------------------------------------------------------------+
+ | Copyright CiviCRM LLC. All rights reserved.                        |
+ |                                                                    |
+ | This work is published under the GNU AGPLv3 license with some      |
+ | permitted exceptions and without any warranty. For full license    |
+ | and copyright information, see https://civicrm.org/licensing       |
+ +--------------------------------------------------------------------+
+ */
+
+/**
+ *  Test APIv3 civicrm_contribute_* functions
+ *
+ * @package CiviCRM_APIv3
+ * @subpackage API_Contribution
+ * @group headless
+ */
+class CRM_Campaign_BAO_QueryTest extends CiviUnitTestCase {
+
+  public function testCampaignVoterClause() {
+    $loggedInContact = $this->createLoggedInUser();
+    $contact = $this->individualCreate();
+    $activityType = CRM_Core_PseudoConstant::getKey('CRM_Activity_BAO_Activity', 'activity_type_id', 'survey');
+    $surveyParams = [
+      'title' => 'Test Survey',
+      'activity_type_id' => $activityType,
+      'created_id' => $loggedInContact,
+    ];
+    $survery = CRM_Campaign_BAO_Survey::create($surveyParams);
+    $voterClauseParams = [
+      'campaign_search_voter_for' => 'reserve',
+      'campaign_survey_id' => $survery->id,
+      'survey_interviewer_id' => $loggedInContact,
+    ];
+    CRM_Campaign_BAO_Query::voterClause($voterClauseParams);
+  }
+
+}
-- 
2.25.1