financial#46 - clean money format at form layer
[civicrm-core.git] / CRM / Contribute / DAO / ContributionSoft.php
CommitLineData
e501603b 1<?php
c3fc2621 2
e501603b
TO
3/**
4 * @package CRM
6b83d5bd 5 * @copyright CiviCRM LLC (c) 2004-2019
e501603b
TO
6 *
7 * Generated from xml/schema/CRM/Contribute/ContributionSoft.xml
8 * DO NOT EDIT. Generated by CRM_Core_CodeGen
e380ee3b 9 * (GenCodeChecksum:b9a4bdee130cdaf934a53e456cd0e3e8)
e501603b 10 */
c3fc2621 11
f41f0342 12/**
c3fc2621 13 * Database access object for the ContributionSoft entity.
f41f0342 14 */
e501603b 15class CRM_Contribute_DAO_ContributionSoft extends CRM_Core_DAO {
c3fc2621 16
e501603b 17 /**
f41f0342 18 * Static instance to hold the table name.
e501603b
TO
19 *
20 * @var string
21 */
22 static $_tableName = 'civicrm_contribution_soft';
c3fc2621 23
e501603b 24 /**
f41f0342 25 * Should CiviCRM log any modifications to this table in the civicrm_log table.
e501603b 26 *
c3fc2621 27 * @var bool
e501603b 28 */
c3fc2621
CW
29 static $_log = TRUE;
30
e501603b
TO
31 /**
32 * Soft Contribution ID
33 *
34 * @var int unsigned
35 */
36 public $id;
c3fc2621 37
e501603b
TO
38 /**
39 * FK to contribution table.
40 *
41 * @var int unsigned
42 */
43 public $contribution_id;
c3fc2621 44
e501603b
TO
45 /**
46 * FK to Contact ID
47 *
48 * @var int unsigned
49 */
50 public $contact_id;
c3fc2621 51
e501603b
TO
52 /**
53 * Amount of this soft contribution.
54 *
55 * @var float
56 */
57 public $amount;
c3fc2621 58
e501603b
TO
59 /**
60 * 3 character string, value from config setting or input via user.
61 *
62 * @var string
63 */
64 public $currency;
c3fc2621 65
e501603b
TO
66 /**
67 * FK to civicrm_pcp.id
68 *
69 * @var int unsigned
70 */
71 public $pcp_id;
c3fc2621 72
e501603b 73 /**
e501603b
TO
74 * @var boolean
75 */
76 public $pcp_display_in_roll;
c3fc2621 77
e501603b 78 /**
e501603b
TO
79 * @var string
80 */
81 public $pcp_roll_nickname;
c3fc2621 82
e501603b 83 /**
e501603b
TO
84 * @var string
85 */
86 public $pcp_personal_note;
c3fc2621 87
e501603b
TO
88 /**
89 * Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.
90 *
91 * @var int unsigned
92 */
93 public $soft_credit_type_id;
c3fc2621 94
e501603b 95 /**
f41f0342 96 * Class constructor.
e501603b 97 */
c3fc2621 98 public function __construct() {
e501603b
TO
99 $this->__table = 'civicrm_contribution_soft';
100 parent::__construct();
101 }
c3fc2621 102
e501603b 103 /**
f41f0342 104 * Returns foreign keys and entity references.
e501603b
TO
105 *
106 * @return array
107 * [CRM_Core_Reference_Interface]
108 */
c3fc2621 109 public static function getReferenceColumns() {
346aaaba
TO
110 if (!isset(Civi::$statics[__CLASS__]['links'])) {
111 Civi::$statics[__CLASS__]['links'] = static ::createReferenceColumns(__CLASS__);
c3fc2621
CW
112 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'contribution_id', 'civicrm_contribution', 'id');
113 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'contact_id', 'civicrm_contact', 'id');
114 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'pcp_id', 'civicrm_pcp', 'id');
346aaaba 115 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'links_callback', Civi::$statics[__CLASS__]['links']);
e501603b 116 }
346aaaba 117 return Civi::$statics[__CLASS__]['links'];
e501603b 118 }
c3fc2621 119
e501603b
TO
120 /**
121 * Returns all the column names of this table
122 *
123 * @return array
124 */
c3fc2621 125 public static function &fields() {
346aaaba 126 if (!isset(Civi::$statics[__CLASS__]['fields'])) {
c3fc2621
CW
127 Civi::$statics[__CLASS__]['fields'] = [
128 'contribution_soft_id' => [
e501603b
TO
129 'name' => 'id',
130 'type' => CRM_Utils_Type::T_INT,
c3fc2621 131 'title' => ts('Soft Contribution ID'),
215b423e 132 'description' => ts('Soft Contribution ID'),
c3fc2621
CW
133 'required' => TRUE,
134 'import' => TRUE,
e501603b
TO
135 'where' => 'civicrm_contribution_soft.id',
136 'headerPattern' => '',
137 'dataPattern' => '',
c3fc2621 138 'export' => TRUE,
522a26c9 139 'table_name' => 'civicrm_contribution_soft',
140 'entity' => 'ContributionSoft',
141 'bao' => 'CRM_Contribute_BAO_ContributionSoft',
6a7e5e5d 142 'localizable' => 0,
c3fc2621
CW
143 ],
144 'contribution_id' => [
e501603b
TO
145 'name' => 'contribution_id',
146 'type' => CRM_Utils_Type::T_INT,
c3fc2621 147 'title' => ts('Soft Contribution - Contribution'),
215b423e 148 'description' => ts('FK to contribution table.'),
c3fc2621 149 'required' => TRUE,
522a26c9 150 'table_name' => 'civicrm_contribution_soft',
151 'entity' => 'ContributionSoft',
152 'bao' => 'CRM_Contribute_BAO_ContributionSoft',
6a7e5e5d 153 'localizable' => 0,
e501603b 154 'FKClassName' => 'CRM_Contribute_DAO_Contribution',
c3fc2621
CW
155 ],
156 'contribution_soft_contact_id' => [
e501603b
TO
157 'name' => 'contact_id',
158 'type' => CRM_Utils_Type::T_INT,
c3fc2621 159 'title' => ts('Contact ID'),
215b423e 160 'description' => ts('FK to Contact ID'),
c3fc2621
CW
161 'required' => TRUE,
162 'import' => TRUE,
e501603b
TO
163 'where' => 'civicrm_contribution_soft.contact_id',
164 'headerPattern' => '/contact(.?id)?/i',
165 'dataPattern' => '/^\d+$/',
c3fc2621 166 'export' => TRUE,
522a26c9 167 'table_name' => 'civicrm_contribution_soft',
168 'entity' => 'ContributionSoft',
169 'bao' => 'CRM_Contribute_BAO_ContributionSoft',
6a7e5e5d 170 'localizable' => 0,
e501603b 171 'FKClassName' => 'CRM_Contact_DAO_Contact',
c3fc2621
CW
172 ],
173 'amount' => [
e501603b
TO
174 'name' => 'amount',
175 'type' => CRM_Utils_Type::T_MONEY,
c3fc2621 176 'title' => ts('Soft Contribution Amount'),
215b423e 177 'description' => ts('Amount of this soft contribution.'),
c3fc2621
CW
178 'required' => TRUE,
179 'precision' => [
e501603b
TO
180 20,
181 2
c3fc2621
CW
182 ],
183 'import' => TRUE,
e501603b
TO
184 'where' => 'civicrm_contribution_soft.amount',
185 'headerPattern' => '/total(.?am(ou)?nt)?/i',
186 'dataPattern' => '/^\d+(\.\d{2})?$/',
c3fc2621 187 'export' => TRUE,
522a26c9 188 'table_name' => 'civicrm_contribution_soft',
189 'entity' => 'ContributionSoft',
190 'bao' => 'CRM_Contribute_BAO_ContributionSoft',
6a7e5e5d 191 'localizable' => 0,
c3fc2621
CW
192 ],
193 'currency' => [
e501603b
TO
194 'name' => 'currency',
195 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 196 'title' => ts('Soft Contribution Currency'),
215b423e 197 'description' => ts('3 character string, value from config setting or input via user.'),
e501603b
TO
198 'maxlength' => 3,
199 'size' => CRM_Utils_Type::FOUR,
200 'default' => 'NULL',
522a26c9 201 'table_name' => 'civicrm_contribution_soft',
202 'entity' => 'ContributionSoft',
203 'bao' => 'CRM_Contribute_BAO_ContributionSoft',
6a7e5e5d 204 'localizable' => 0,
c3fc2621 205 'html' => [
e501603b 206 'type' => 'Select',
c3fc2621
CW
207 ],
208 'pseudoconstant' => [
e501603b
TO
209 'table' => 'civicrm_currency',
210 'keyColumn' => 'name',
211 'labelColumn' => 'full_name',
212 'nameColumn' => 'name',
c3fc2621
CW
213 ]
214 ],
215 'pcp_id' => [
e501603b
TO
216 'name' => 'pcp_id',
217 'type' => CRM_Utils_Type::T_INT,
c3fc2621 218 'title' => ts('Soft Contribution PCP'),
215b423e 219 'description' => ts('FK to civicrm_pcp.id'),
e501603b 220 'default' => 'NULL',
522a26c9 221 'table_name' => 'civicrm_contribution_soft',
222 'entity' => 'ContributionSoft',
223 'bao' => 'CRM_Contribute_BAO_ContributionSoft',
6a7e5e5d 224 'localizable' => 0,
e501603b 225 'FKClassName' => 'CRM_PCP_DAO_PCP',
c3fc2621 226 'pseudoconstant' => [
e501603b
TO
227 'table' => 'civicrm_pcp',
228 'keyColumn' => 'id',
229 'labelColumn' => 'title',
c3fc2621
CW
230 ]
231 ],
232 'pcp_display_in_roll' => [
e501603b
TO
233 'name' => 'pcp_display_in_roll',
234 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 235 'title' => ts('Soft Contribution Display on PCP'),
45a83e42 236 'default' => '0',
522a26c9 237 'table_name' => 'civicrm_contribution_soft',
238 'entity' => 'ContributionSoft',
239 'bao' => 'CRM_Contribute_BAO_ContributionSoft',
6a7e5e5d 240 'localizable' => 0,
c3fc2621
CW
241 ],
242 'pcp_roll_nickname' => [
e501603b
TO
243 'name' => 'pcp_roll_nickname',
244 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 245 'title' => ts('Soft Contribution PCP Nickname'),
e501603b
TO
246 'maxlength' => 255,
247 'size' => CRM_Utils_Type::HUGE,
248 'default' => 'NULL',
522a26c9 249 'table_name' => 'civicrm_contribution_soft',
250 'entity' => 'ContributionSoft',
251 'bao' => 'CRM_Contribute_BAO_ContributionSoft',
6a7e5e5d 252 'localizable' => 0,
c3fc2621
CW
253 ],
254 'pcp_personal_note' => [
e501603b
TO
255 'name' => 'pcp_personal_note',
256 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 257 'title' => ts('Soft Contribution PCP Note'),
e501603b
TO
258 'maxlength' => 255,
259 'size' => CRM_Utils_Type::HUGE,
260 'default' => 'NULL',
522a26c9 261 'table_name' => 'civicrm_contribution_soft',
262 'entity' => 'ContributionSoft',
263 'bao' => 'CRM_Contribute_BAO_ContributionSoft',
6a7e5e5d 264 'localizable' => 0,
bddddc63 265 'html' => [
266 'type' => 'TextArea',
267 ],
c3fc2621
CW
268 ],
269 'soft_credit_type_id' => [
e501603b
TO
270 'name' => 'soft_credit_type_id',
271 'type' => CRM_Utils_Type::T_INT,
c3fc2621 272 'title' => ts('Soft Credit Type'),
215b423e 273 'description' => ts('Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type.'),
e501603b 274 'default' => 'NULL',
522a26c9 275 'table_name' => 'civicrm_contribution_soft',
276 'entity' => 'ContributionSoft',
277 'bao' => 'CRM_Contribute_BAO_ContributionSoft',
6a7e5e5d 278 'localizable' => 0,
c3fc2621 279 'pseudoconstant' => [
e501603b
TO
280 'optionGroupName' => 'soft_credit_type',
281 'optionEditPath' => 'civicrm/admin/options/soft_credit_type',
c3fc2621
CW
282 ]
283 ],
284 ];
346aaaba 285 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
e501603b 286 }
346aaaba 287 return Civi::$statics[__CLASS__]['fields'];
e501603b 288 }
c3fc2621 289
e501603b 290 /**
bd8e0b14 291 * Return a mapping from field-name to the corresponding key (as used in fields()).
e501603b
TO
292 *
293 * @return array
bd8e0b14 294 * Array(string $name => string $uniqueName).
e501603b 295 */
c3fc2621 296 public static function &fieldKeys() {
bd8e0b14
TO
297 if (!isset(Civi::$statics[__CLASS__]['fieldKeys'])) {
298 Civi::$statics[__CLASS__]['fieldKeys'] = array_flip(CRM_Utils_Array::collect('name', self::fields()));
e501603b 299 }
bd8e0b14 300 return Civi::$statics[__CLASS__]['fieldKeys'];
e501603b 301 }
c3fc2621 302
e501603b
TO
303 /**
304 * Returns the names of this table
305 *
306 * @return string
307 */
c3fc2621 308 public static function getTableName() {
e501603b
TO
309 return self::$_tableName;
310 }
c3fc2621 311
e501603b
TO
312 /**
313 * Returns if this table needs to be logged
314 *
c3fc2621 315 * @return bool
e501603b 316 */
c3fc2621 317 public function getLog() {
e501603b
TO
318 return self::$_log;
319 }
c3fc2621 320
e501603b
TO
321 /**
322 * Returns the list of fields that can be imported
323 *
324 * @param bool $prefix
325 *
326 * @return array
327 */
c3fc2621
CW
328 public static function &import($prefix = FALSE) {
329 $r = CRM_Core_DAO_AllCoreTables::getImports(__CLASS__, 'contribution_soft', $prefix, []);
60808919 330 return $r;
e501603b 331 }
c3fc2621 332
e501603b
TO
333 /**
334 * Returns the list of fields that can be exported
335 *
336 * @param bool $prefix
337 *
338 * @return array
339 */
c3fc2621
CW
340 public static function &export($prefix = FALSE) {
341 $r = CRM_Core_DAO_AllCoreTables::getExports(__CLASS__, 'contribution_soft', $prefix, []);
60808919 342 return $r;
e501603b 343 }
c3fc2621 344
e7a6b91a
AS
345 /**
346 * Returns the list of indices
c3fc2621
CW
347 *
348 * @param bool $localize
349 *
350 * @return array
e7a6b91a
AS
351 */
352 public static function indices($localize = TRUE) {
c3fc2621
CW
353 $indices = [
354 'index_id' => [
e7a6b91a 355 'name' => 'index_id',
c3fc2621 356 'field' => [
e7a6b91a 357 0 => 'pcp_id',
c3fc2621
CW
358 ],
359 'localizable' => FALSE,
e7a6b91a 360 'sig' => 'civicrm_contribution_soft::0::pcp_id',
c3fc2621
CW
361 ],
362 ];
e7a6b91a
AS
363 return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables::multilingualize(__CLASS__, $indices) : $indices;
364 }
c3fc2621 365
e501603b 366}