Unit.inc
3.25 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
<?php
/**
* $Id$
*
* 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 . "/util/sanitize.inc");
class Unit extends KTEntity {
var $_bUsePearError = true;
var $iId;
var $sName;
var $iFolderID;
var $_aFieldToSelect = array(
'iId' => 'id',
'sName' => 'name',
'iFolderId' => 'folder_id',
);
function _table () {
return KTUtil::getTableName('units');
}
function getName() { return sanitizeForSQLtoHTML($this->sName); }
function setName($sNewValue) { $this->sName = sanitizeForSQL($sNewValue); }
function getFolderId() { return $this->iFolderId; }
function setFolderId($iNewValue) { $this->iFolderId = $iNewValue; }
function &get($iId) {
return KTEntityUtil::get('Unit', $iId);
}
function getList($sWhereClause = null) {
return KTEntityUtil::getList2('Unit', $sWhereClause);
}
function &createFromArray($aArray) {
return KTEntityUtil::createFromArray('Unit', $aArray);
}
function &getByFolder($oFolder) {
$iFolderId = KTUtil::getId($oFolder);
return KTEntityUtil::getByDict('Unit', array(
'folder_id' => $iFolderId,
), array(
'noneok' => true,
));
}
function getFolder() {
require_once(KT_LIB_DIR . '/foldermanagement/Folder.inc');
return Folder::get($this->iFolderId);
}
function getUnitsForFolder($oFolder) {
$oFolder =& KTUtil::getObject('Folder', $oFolder);
$sUnitTable = KTUtil::getTableName('units');
if (PEAR::isError($oFolder)) { // can't be admin for a non-existant folder.
return false;
}
$sFolderIds = $oFolder->getParentFolderIds();
$aFolderIds = split(",", $sFolderIds);
$aFolderIds[] = $oFolder->getId();
$sParams = DBUtil::paramArray($aFolderIds);
$aParams = $aFolderIds;
$sQuery = "SELECT id FROM $sUnitTable WHERE folder_id IN ($sParams)";
$aUnitIds = DBUtil::getResultArrayKey(array($sQuery, $aParams), 'id');
$aRet = array();
foreach ($aUnitIds as $iId) {
$aRet[] = Unit::get($iId);
}
return $aRet;
}
}
?>