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
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
|
<?php
/*
* A category class corresponding to the category table.
*
* This file is part of Zoph.
*
* Zoph 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.
*
* Zoph 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 Zoph; if not, write to the Free Software
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
*/
class category extends zoph_tree_table {
var $photo_count;
function category($id = 0) {
parent::zoph_table("categories", array("category_id"), array("category"));
$this->set("category_id", $id);
}
function delete() {
parent::delete(array("photo_categories"));
}
function get_children() {
return parent::get_children(null, "category");
}
function get_branch_ids($user = null) {
return parent::get_branch_ids("category", $user);
}
function get_photo_count($user) {
if ($this->photo_count) { return $photo_count; }
$id = $this->get("category_id");
if ($user && !$user->is_admin()) {
$sql =
"select count(distinct pc.photo_id) from " .
DB_PREFIX . "photo_categories as pc, " .
DB_PREFIX . "photo_albums as pa, " .
DB_PREFIX . "photos as p, " .
DB_PREFIX . "album_permissions as ap " .
"where pc.category_id = '" . escape_string($id) . "'" .
" and ap.user_id = '" . escape_string($user->get("user_id")) . "'" .
" and pc.photo_id = pa.photo_id" .
" and pa.album_id = ap.album_id" .
" and pa.photo_id = p.photo_id" .
" and ap.access_level >= p.level";
}
else {
$sql =
"select count(photo_id) from " .
DB_PREFIX . "photo_categories " .
"where category_id = '" . escape_string($id) . "'";
}
return get_count_from_query($sql);
}
function get_total_photo_count($user = null) {
if ($this->get("parent_category_id")) {
$id_list = $this->get_branch_ids($user);
$id_constraint = "pc.category_id in ($id_list)";
}
else {
$id_constraint = "";
}
if ($user && !$user->is_admin()) {
$sql =
"select count(distinct pc.photo_id) from " .
DB_PREFIX . "photo_categories as pc, " .
DB_PREFIX . "photo_albums as pa, " .
DB_PREFIX . "photos as p, " .
DB_PREFIX . "album_permissions as ap " .
"where ap.user_id = '" . escape_string($user->get("user_id")) . "'" .
" and pc.photo_id = pa.photo_id" .
" and pa.album_id = ap.album_id" .
" and pa.photo_id = p.photo_id" .
" and ap.access_level >= p.level";
if ($id_constraint) {
$sql .= " and $id_constraint";
}
}
else {
$sql =
"select count(distinct pc.photo_id) from " .
DB_PREFIX . "photo_categories as pc";
if ($id_constraint) {
$sql .= " where $id_constraint";
}
}
return get_count_from_query($sql);
}
function get_edit_array() {
return array(
translate("category name") =>
create_text_input("category", $this->get("category")),
translate("parent category") =>
create_pulldown("parent_category_id",
$this->get("parent_category_id"),
get_categories_select_array()),
translate("category description") =>
create_text_input("category_description",
$this->get("category_description"), 40, 128),
translate("category sort order") =>
create_photo_field_pulldown("sortorder", $this->get("sortorder"))
);
}
function get_link() {
if ($this->get("parent_category_id")) {
$name = $this->get("category");
}
else {
$name = translate("Categories");
}
return "<a href=\"categories.php?parent_category_id=" . $this->get("category_id") . "\">$name</a>";
}
}
function get_root_category() {
return new category(1);
}
function get_category_by_name($category = null) {
if (!$category) {
return "";
}
$where =
"lower(category) like '%" . escape_string(strtolower($category))
. "%'";
$query = "select category_id from " . DB_PREFIX . "categories where $where";
return get_records_from_query("category", $query);
}
function get_categories_select_array($user = null, $search = 0) {
return create_tree_select_array("category", $user, null, "", null, $search);
}
function get_categories_search_array($user = null) {
return get_categories_select_array($user, 1);
}
function get_popular_categories($user) {
global $TOP_N;
if ($user && !$user->is_admin()) {
$sql =
"select cat.*, count(distinct ph.photo_id) as count from " .
DB_PREFIX . "categories as cat, " .
DB_PREFIX . "photo_categories as pc, " .
DB_PREFIX . "photos as ph, " .
DB_PREFIX . "photo_albums as pa, " .
DB_PREFIX . "album_permissions as ap " .
"where ap.user_id = '" . escape_string($user->get("user_id")) . "'" .
" and ap.album_id = pa.album_id" .
" and pa.photo_id = pc.photo_id" .
" and pc.category_id = cat.category_id" .
" and pc.photo_id = ph.photo_id" .
" and ap.access_level >= ph.level " .
"group by cat.category_id " .
"order by count desc, cat.category " .
"limit 0, $TOP_N";
}
else {
$sql =
"select cat.*, count(*) as count from " .
DB_PREFIX . "categories as cat, " .
DB_PREFIX . "photo_categories as pc " .
"where pc.category_id = cat.category_id " .
"group by cat.category_id " .
"order by count desc, cat.category " .
"limit 0, $TOP_N";
}
return get_popular_results("category", $sql);
}
?>
|
