lookup.inc
3.97 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
129
130
131
132
133
134
135
136
137
<?php
/**
* $Id$
*
* Contains database helper functions.
*
* 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): ______________________________________
*/
/**
* Performs an id field lookup on the specified table.
*
* @param string the name of table to perform the id lookup.
* @param string the db field to return.
* @param mixed the value to perform the lookup for
* @return int the id of the row in the db with $fieldName=$fieldValue
*/
function lookupID($tableName, $fieldName, $fieldValue){
return lookupField($tableName, "id", $fieldName, $fieldValue);
}
/**
* Performs an name field lookup on the specified table.
*
* @param string the name of table to perform the id lookup.
* @param integer the id value to perform the lookup with
* @return int the id of the row in the db with $fieldName=$fieldValue
*/
function lookupName($tableName, $idFieldValue){
return lookupField($tableName, "name", "id", $idFieldValue);
}
function lookupStatusID($statusName) {
global $default;
return lookupID($default->status_table, "name", $statusName);
}
/**
* Retrieves the groups that the user is a member of
*
* @param int the user to lookup groups for
* @return array the groupsIDs the user is a member of
*/
function lookupGroupIDs($userID) {
global $default;
$groupIDs = array();
$sql = $default->db;
$sql->query("select group_id from $default->users_groups_table where user_id = '$userID'");
while($sql->next_record()) {
$groupIDs[] = $sql->f("group_id");
}
return $groupIDs;
}
/**
* Performs a generic one field lookup on a table
*
* @param string the name of the table to perform the lookup on
* @param string the field to return
* @param string the field to discriminate against(?!)
* @param string the field value to return rows for
*/
function lookupField($tableName, $selectFieldName, $whereFieldName, $whereFieldValue) {
global $default;
$sql = $default->db;
$query = "select $selectFieldName from $tableName where $whereFieldName = ?" ;
$aParams = array($whereFieldValue);
if ($sql->query(array($query, $aParams))) {
if ($sql->next_record()) {
return $sql->f($selectFieldName);
} else {
return false;
}
} else {
$_SESSION["errorMessage"] = "lookup query failed ($query).";
return false;
}
}
/**
* Converts an array to a string
*
* @param array the array to convert
* @return string stringified array
*/
function arrayToString($array) {
ob_start();
print_r($array);
$arrToStr = ob_get_contents();
ob_end_clean();
return $arrToStr;
}
/**
* Converts an array to a comma separated string
*
* @param array the array to convert
* @return string a comma separated string of the array values
*/
function arrayToCss($array) {
$css = "";
foreach ($array as $key=>$value) {
$css = $css . $value . ",";
}
// trim the last comma
$css = substr("$css", 0, -1);
return $css;
}
?>