CRM-20312 Add indices to DAO classes
[civicrm-core.git] / CRM / Contact / DAO / SavedSearch.php
CommitLineData
e501603b
TO
1<?php
2/*
3+--------------------------------------------------------------------+
4| CiviCRM version 4.7 |
5+--------------------------------------------------------------------+
0f03f337 6| Copyright CiviCRM LLC (c) 2004-2017 |
e501603b
TO
7+--------------------------------------------------------------------+
8| This file is a part of CiviCRM. |
9| |
10| CiviCRM is free software; you can copy, modify, and distribute it |
11| under the terms of the GNU Affero General Public License |
12| Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
13| |
14| CiviCRM is distributed in the hope that it will be useful, but |
15| WITHOUT ANY WARRANTY; without even the implied warranty of |
16| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17| See the GNU Affero General Public License for more details. |
18| |
19| You should have received a copy of the GNU Affero General Public |
20| License and the CiviCRM Licensing Exception along |
21| with this program; if not, contact CiviCRM LLC |
22| at info[AT]civicrm[DOT]org. If you have questions about the |
23| GNU Affero General Public License or the licensing of CiviCRM, |
24| see the CiviCRM license FAQ at http://civicrm.org/licensing |
25+--------------------------------------------------------------------+
26*/
27/**
28 * @package CRM
0f03f337 29 * @copyright CiviCRM LLC (c) 2004-2017
e501603b
TO
30 *
31 * Generated from xml/schema/CRM/Contact/SavedSearch.xml
32 * DO NOT EDIT. Generated by CRM_Core_CodeGen
022785d8 33 * (GenCodeChecksum:8e799b35db1b6a38deee5a757d4183c0)
e501603b
TO
34 */
35require_once 'CRM/Core/DAO.php';
36require_once 'CRM/Utils/Type.php';
f41f0342 37/**
38 * CRM_Contact_DAO_SavedSearch constructor.
39 */
e501603b
TO
40class CRM_Contact_DAO_SavedSearch extends CRM_Core_DAO {
41 /**
f41f0342 42 * Static instance to hold the table name.
e501603b
TO
43 *
44 * @var string
45 */
46 static $_tableName = 'civicrm_saved_search';
e501603b 47 /**
f41f0342 48 * Should CiviCRM log any modifications to this table in the civicrm_log table.
e501603b
TO
49 *
50 * @var boolean
51 */
52 static $_log = false;
53 /**
54 * Saved Search ID
55 *
56 * @var int unsigned
57 */
58 public $id;
59 /**
60 * Submitted form values for this search
61 *
62 * @var text
63 */
64 public $form_values;
65 /**
66 * Foreign key to civicrm_mapping used for saved search-builder searches.
67 *
68 * @var int unsigned
69 */
70 public $mapping_id;
71 /**
72 * Foreign key to civicrm_option value table used for saved custom searches.
73 *
74 * @var int unsigned
75 */
76 public $search_custom_id;
77 /**
78 * the sql where clause if a saved search acl
79 *
80 * @var text
81 */
82 public $where_clause;
83 /**
84 * the tables to be included in a select data
85 *
86 * @var text
87 */
88 public $select_tables;
89 /**
90 * the tables to be included in the count statement
91 *
92 * @var text
93 */
94 public $where_tables;
95 /**
f41f0342 96 * Class constructor.
e501603b
TO
97 */
98 function __construct() {
99 $this->__table = 'civicrm_saved_search';
100 parent::__construct();
101 }
102 /**
f41f0342 103 * Returns foreign keys and entity references.
e501603b
TO
104 *
105 * @return array
106 * [CRM_Core_Reference_Interface]
107 */
108 static function getReferenceColumns() {
346aaaba
TO
109 if (!isset(Civi::$statics[__CLASS__]['links'])) {
110 Civi::$statics[__CLASS__]['links'] = static ::createReferenceColumns(__CLASS__);
111 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName() , 'mapping_id', 'civicrm_mapping', 'id');
112 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'links_callback', Civi::$statics[__CLASS__]['links']);
e501603b 113 }
346aaaba 114 return Civi::$statics[__CLASS__]['links'];
e501603b
TO
115 }
116 /**
117 * Returns all the column names of this table
118 *
119 * @return array
120 */
121 static function &fields() {
346aaaba
TO
122 if (!isset(Civi::$statics[__CLASS__]['fields'])) {
123 Civi::$statics[__CLASS__]['fields'] = array(
e501603b
TO
124 'id' => array(
125 'name' => 'id',
126 'type' => CRM_Utils_Type::T_INT,
127 'title' => ts('Saved Search ID') ,
128 'description' => 'Saved Search ID',
129 'required' => true,
522a26c9 130 'table_name' => 'civicrm_saved_search',
131 'entity' => 'SavedSearch',
132 'bao' => 'CRM_Contact_BAO_SavedSearch',
6a7e5e5d 133 'localizable' => 0,
e501603b
TO
134 ) ,
135 'form_values' => array(
136 'name' => 'form_values',
137 'type' => CRM_Utils_Type::T_TEXT,
138 'title' => ts('Submitted Form Values') ,
139 'description' => 'Submitted form values for this search',
140 'import' => true,
141 'where' => 'civicrm_saved_search.form_values',
142 'headerPattern' => '',
143 'dataPattern' => '',
144 'export' => true,
522a26c9 145 'table_name' => 'civicrm_saved_search',
146 'entity' => 'SavedSearch',
147 'bao' => 'CRM_Contact_BAO_SavedSearch',
6a7e5e5d 148 'localizable' => 0,
e501603b
TO
149 ) ,
150 'mapping_id' => array(
151 'name' => 'mapping_id',
152 'type' => CRM_Utils_Type::T_INT,
153 'title' => ts('Mapping ID') ,
154 'description' => 'Foreign key to civicrm_mapping used for saved search-builder searches.',
522a26c9 155 'table_name' => 'civicrm_saved_search',
156 'entity' => 'SavedSearch',
157 'bao' => 'CRM_Contact_BAO_SavedSearch',
6a7e5e5d 158 'localizable' => 0,
e501603b
TO
159 'FKClassName' => 'CRM_Core_DAO_Mapping',
160 ) ,
161 'search_custom_id' => array(
162 'name' => 'search_custom_id',
163 'type' => CRM_Utils_Type::T_INT,
164 'title' => ts('Option Value ID') ,
165 'description' => 'Foreign key to civicrm_option value table used for saved custom searches.',
522a26c9 166 'table_name' => 'civicrm_saved_search',
167 'entity' => 'SavedSearch',
168 'bao' => 'CRM_Contact_BAO_SavedSearch',
6a7e5e5d 169 'localizable' => 0,
e501603b
TO
170 ) ,
171 'where_clause' => array(
172 'name' => 'where_clause',
173 'type' => CRM_Utils_Type::T_TEXT,
174 'title' => ts('Where Clause') ,
175 'description' => 'the sql where clause if a saved search acl',
522a26c9 176 'table_name' => 'civicrm_saved_search',
177 'entity' => 'SavedSearch',
178 'bao' => 'CRM_Contact_BAO_SavedSearch',
6a7e5e5d 179 'localizable' => 0,
e501603b
TO
180 ) ,
181 'select_tables' => array(
182 'name' => 'select_tables',
183 'type' => CRM_Utils_Type::T_TEXT,
184 'title' => ts('Select Tables') ,
185 'description' => 'the tables to be included in a select data',
522a26c9 186 'table_name' => 'civicrm_saved_search',
187 'entity' => 'SavedSearch',
188 'bao' => 'CRM_Contact_BAO_SavedSearch',
6a7e5e5d 189 'localizable' => 0,
e501603b
TO
190 ) ,
191 'where_tables' => array(
192 'name' => 'where_tables',
193 'type' => CRM_Utils_Type::T_TEXT,
194 'title' => ts('Where Tables') ,
195 'description' => 'the tables to be included in the count statement',
522a26c9 196 'table_name' => 'civicrm_saved_search',
197 'entity' => 'SavedSearch',
198 'bao' => 'CRM_Contact_BAO_SavedSearch',
6a7e5e5d 199 'localizable' => 0,
e501603b
TO
200 ) ,
201 );
346aaaba 202 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
e501603b 203 }
346aaaba 204 return Civi::$statics[__CLASS__]['fields'];
e501603b
TO
205 }
206 /**
bd8e0b14 207 * Return a mapping from field-name to the corresponding key (as used in fields()).
e501603b
TO
208 *
209 * @return array
bd8e0b14 210 * Array(string $name => string $uniqueName).
e501603b
TO
211 */
212 static function &fieldKeys() {
bd8e0b14
TO
213 if (!isset(Civi::$statics[__CLASS__]['fieldKeys'])) {
214 Civi::$statics[__CLASS__]['fieldKeys'] = array_flip(CRM_Utils_Array::collect('name', self::fields()));
e501603b 215 }
bd8e0b14 216 return Civi::$statics[__CLASS__]['fieldKeys'];
e501603b
TO
217 }
218 /**
219 * Returns the names of this table
220 *
221 * @return string
222 */
223 static function getTableName() {
224 return self::$_tableName;
225 }
226 /**
227 * Returns if this table needs to be logged
228 *
229 * @return boolean
230 */
231 function getLog() {
232 return self::$_log;
233 }
234 /**
235 * Returns the list of fields that can be imported
236 *
237 * @param bool $prefix
238 *
239 * @return array
240 */
241 static function &import($prefix = false) {
60808919
TO
242 $r = CRM_Core_DAO_AllCoreTables::getImports(__CLASS__, 'saved_search', $prefix, array());
243 return $r;
e501603b
TO
244 }
245 /**
246 * Returns the list of fields that can be exported
247 *
248 * @param bool $prefix
249 *
250 * @return array
251 */
252 static function &export($prefix = false) {
60808919
TO
253 $r = CRM_Core_DAO_AllCoreTables::getExports(__CLASS__, 'saved_search', $prefix, array());
254 return $r;
e501603b
TO
255 }
256}