From 8e6001d91912205a7fbd1dcad55978cb77a98e2d Mon Sep 17 00:00:00 2001
From: varshith89 <vinu@compucorp.co.uk>
Date: Tue, 17 Apr 2018 14:18:37 +0000
Subject: [PATCH] Add New API Call To Get All Unique Fields For Given Entity

---
 api/v3/Generic/Getunique.php | 56 ++++++++++++++++++++++++++++++++++++
 1 file changed, 56 insertions(+)
 create mode 100644 api/v3/Generic/Getunique.php

diff --git a/api/v3/Generic/Getunique.php b/api/v3/Generic/Getunique.php
new file mode 100644
index 0000000000..956474533d
--- /dev/null
+++ b/api/v3/Generic/Getunique.php
@@ -0,0 +1,56 @@
+<?php
+/*
+ +--------------------------------------------------------------------+
+ | CiviCRM version 4.7                                                |
+ +--------------------------------------------------------------------+
+ | Copyright CiviCRM LLC (c) 2004-2017                                |
+ +--------------------------------------------------------------------+
+ | This file is a part of CiviCRM.                                    |
+ |                                                                    |
+ | CiviCRM is free software; you can copy, modify, and distribute it  |
+ | under the terms of the GNU Affero General Public License           |
+ | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
+ |                                                                    |
+ | CiviCRM is distributed in the hope that it will be useful, but     |
+ | WITHOUT ANY WARRANTY; without even the implied warranty of         |
+ | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
+ | See the GNU Affero General Public License for more details.        |
+ |                                                                    |
+ | You should have received a copy of the GNU Affero General Public   |
+ | License and the CiviCRM Licensing Exception along                  |
+ | with this program; if not, contact CiviCRM LLC                     |
+ | at info[AT]civicrm[DOT]org. If you have questions about the        |
+ | GNU Affero General Public License or the licensing of CiviCRM,     |
+ | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
+ +--------------------------------------------------------------------+
+ */
+
+/**
+ * @package CiviCRM_APIv3
+ */
+
+/**
+ * Generic api wrapper used to get all unique fields for a given entity.
+ *
+ * @param array $apiRequest
+ *
+ * @return mixed
+ */
+function civicrm_api3_generic_getUnique($apiRequest) {
+  $entity = _civicrm_api_get_entity_name_from_camel($apiRequest['entity']);
+  $uniqueFields = array();
+
+  $baoName = _civicrm_api3_get_BAO($entity);
+  $bao = new $baoName();
+  $_entityTable = $bao->tableName();
+
+  $sql = 'SHOW INDEX FROM '.$_entityTable.' WHERE Non_unique = 0';
+  $uFields = CRM_Core_DAO::executeQuery($sql)->fetchAll();
+  foreach($uFields as $field) {
+    // group by Key_name to handle combination indexes
+    $uniqueFields[$field['Key_name']][] = $field['Column_name'];
+  }
+
+  return civicrm_api3_create_success($uniqueFields);
+}
+
-- 
2.25.1