valueinstance.inc.php
4.79 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php
/**
* $Id$
*
* Describes a behaviour that values in a lookup field can have that
* define how they affect dependent columns in terms of restricting
* the available lookups.
*
* The contents of this file are subject to the KnowledgeTree Public
* License Version 1.1.2 ("License"); You may not use this file except in
* compliance with the License. You may obtain a copy of the License at
* http://www.knowledgetree.com/KPL
*
* Software distributed under the License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied.
* See the License for the specific language governing rights and
* limitations under the License.
*
* All copies of the Covered Code must include on each user interface screen:
* (i) the "Powered by KnowledgeTree" logo and
* (ii) the KnowledgeTree copyright notice
* in the same form as they appear in the distribution. See the License for
* requirements.
*
* The Original Code is: KnowledgeTree Open Source
*
* The Initial Developer of the Original Code is The Jam Warehouse Software
* (Pty) Ltd, trading as KnowledgeTree.
* Portions created by The Jam Warehouse Software (Pty) Ltd are Copyright
* (C) 2007 The Jam Warehouse Software (Pty) Ltd;
* All Rights Reserved.
* Contributor( s): ______________________________________
*/
require_once(KT_LIB_DIR . "/ktentity.inc");
class KTValueInstance extends KTEntity {
var $iId = -1;
var $iFieldId;
var $iFieldValueId;
var $iBehaviourId;
var $_aFieldToSelect = array(
"iId" => "id",
"iFieldId" => "field_id",
"iFieldValueId" => "field_value_id",
"iBehaviourId" => "behaviour_id",
);
var $_bUsePearError = true;
function getId() { return $this->iId; }
function getFieldId() { return $this->iFieldId; }
function getFieldValueId() { return $this->iFieldValueId; }
function getBehaviourId() { return $this->iBehaviourId; }
function setId($iId) { $this->iId = $iId; }
function setFieldId($iFieldId) { $this->iFieldId = $iFieldId; }
function setFieldValueId($iFieldValue) { $this->iFieldValueId = $iFieldValueId; }
function setBehaviourId($iBehaviourId) { $this->iBehaviourId = $iBehaviourId; }
function _table () {
return KTUtil::getTableName('field_value_instances');
}
// STATIC
function &get($iId) {
return KTEntityUtil::get('KTValueInstance', $iId);
}
// STATIC
function &createFromArray($aOptions) {
return KTEntityUtil::createFromArray('KTValueInstance', $aOptions);
}
// STATIC
function &getList($sWhereClause = null) {
global $default;
return KTEntityUtil::getList($default->permissions_table, 'KTValueInstance', $sWhereClause);
}
// STATIC
function &getByField($oField) {
$iFieldId = KTUtil::getId($oField);
return KTEntityUtil::getBy('KTValueInstance', 'fieldid', $iFieldId);
}
function &getByLookupSingle($oLookup) {
$aOptions = array('noneok' => true);
$iLookupId = KTUtil::getId($oLookup);
return KTEntityUtil::getBy('KTValueInstance', 'field_value_id', $iLookupId, $aOptions);
}
function &getByLookup($oLookup) {
$aOptions = array('multi' => true);
$iLookupId = KTUtil::getId($oLookup);
return KTEntityUtil::getBy('KTValueInstance', 'field_value_id', $iLookupId, $aOptions);
}
function &getByLookupAndParentBehaviour($oLookup, $oBehaviour, $aOptions = null) {
$iLookupId = KTUtil::getId($oLookup);
$iBehaviourId = KTUtil::getId($oBehaviour);
$GLOBALS['default']->log->debug('KTValueInstance::getByLookupAndParentBehaviour: lookup id is ' . print_r($iLookupId, true));
$GLOBALS['default']->log->debug('KTValueInstance::getByLookupAndParentBehaviour: behaviour id is ' . $iBehaviourId);
$sInstanceTable = KTUtil::getTableName('field_value_instances');
$sBehaviourOptionsTable = KTUtil::getTableName('field_behaviour_options');
$aQuery = array(
"SELECT instance_id FROM $sBehaviourOptionsTable AS BO INNER JOIN
$sInstanceTable AS I ON BO.instance_id = I.id WHERE
BO.behaviour_id = ? AND I.field_value_id = ?",
array($iBehaviourId, $iLookupId),
);
$iId = DBUtil::getOneResultKey($aQuery, 'instance_id');
if (PEAR::isError($iId)) {
$GLOBALS['default']->log->error('KTValueInstance::getByLookupAndParentBehaviour: error from db is: ' . print_r($iId, true));
return $iId;
}
if (is_null($iId)) {
return null;
}
$GLOBALS['default']->log->debug('KTValueInstance::getByLookupAndParentBehaviour: id of instance is ' . $iId);
if (KTUtil::arrayGet($aOptions, 'ids')) {
return $iId;
}
return KTValueInstance::get($iId);
}
}
?>