Dashboard.inc
4.19 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
138
139
140
141
142
<?php
require_once(KT_LIB_DIR . "/subscriptions/SubscriptionManager.inc");
require_once(KT_LIB_DIR . "/web/WebDocument.inc");
require_once(KT_LIB_DIR . "/links/Link.inc");
require_once(KT_LIB_DIR . "/archiving/ArchiveRestorationRequest.inc");
/**
* $Id$
*
* Contains dashboard helper functions.
*
* Copyright (c) 2003 Jam Warehouse http://www.jamwarehouse.com
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*
* @version $Revision$
* @author Michael Joseph <michael@jamwarehouse.com>, Jam Warehouse (Pty) Ltd, South Africa
* @package lib.dashboard
*/
class Dashboard {
/**
* The user id of the user viewing the dashboard
*/
var $iUserID;
/**
* Constructs a new instance of the Dashboard
* @param integer the user id of the current user
*/
function Dashboard($iUserID){
$this->iUserID = $iUserID;
}
/**
* Retrieves the web documents that the current user has pending
*/
function getPendingWebDocuments(){
global $default;
$sQuery = "SELECT wd.id FROM web_documents wd " . /*ok*/
"INNER JOIN web_sites ws ON wd.web_site_id = ws.id " .
"WHERE ws.web_master_id = ? AND wd.status_id = 1" .
"ORDER BY ws.datetime DESC";
$aParams = array($this->iUserID);
$aDocumentList = array();
$sql = $default->db;
if ($sql->query(array($sQuery, $aParams))) {
while ($sql->next_record()) {
$aDocumentList[] = & WebDocument::get($sql->f("id"));
}
}
return $aDocumentList;
}
/**
* Retrieves details of supporting documents that the current user must create
*/
function getArchiveRestorationRequestDocuments() {
return ArchiveRestorationRequest::getList(array("admin_user_id = ?", $this->iUserID));/*ok*/
}
/**
* Retrieve checked out documents for this user
*
* @return array of documents
*/
function getCheckedOutDocuments(){
return Document::getList(array("checked_out_user_id = ?", $this->iUserID));/*ok*/
}
/**
* Retrieve subscription alerts for this user.
*
* @return array of subscription alerts
*/
function getSubscriptionAlerts(){
return SubscriptionManager::listSubscriptionAlerts($this->iUserID);
}
/**
* Retrieve quicklinks
*
* @return array of link objects
*/
function getQuickLinks(){
return Link::getList("ORDER BY rank");/*ok*/
}
/**
* Retrieves Public Folders
*/
function getPublicFolders() {
global $default;
$sQuery = array("SELECT id FROM $default->folders_table WHERE is_public = ?", array(true));
$aFolderList = array();
$sql = $default->db;
$sql->query($sQuery);
while ($sql->next_record()) {
$aFolderList[] = & Folder::get($sql->f("id"));
}
return $aFolderList;
}
/**
* Retrieves Browseable Folders for this user
*/
function getBrowseableFolders() {
return;
/*
global $default;
$sQuery = array("SELECT DISTINCT F.id as folderid, F.parent_id as parentfolderid " .
"FROM $default->folders_table F, $default->groups_folders_table GFL, $default->users_groups_table UGL " .
"WHERE UGL.user_id=? AND UGL.group_id=GFL.group_id AND GFL.folder_id = F.id AND " .
"F.id=F.permission_folder_id AND F.id \!= 1 ORDER BY F.id", $this->iUserID);
$aBrowseableList = array();
$aShowedFolderList = array();
$sql = $default->db;
$sql->query($sQuery);
while ($sql->next_record()) {
if (!$aShowedFolderList[$sql->f("parentfolderid")]) {
$aBrowseableList[] = & Folder::get($sql->f("folderid"));
}
$aShowedFolderList[$sql->f("folderid")] = 1; // check the showed folder
}
return $aBrowseableList;
*/
}
}