]> src.bluestatic.org Git - bugdar.git/blob - admin/product.php
r1522: Adding a PHP4 constructor to the Authentication class
[bugdar.git] / admin / product.php
1 <?php
2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Blue Static
6 || #
7 || # This program is free software; you can redistribute it and/or modify
8 || # it under the terms of the GNU General Public License as published by
9 || # the Free Software Foundation; version [#]gpl[#] of the License.
10 || #
11 || # This program is distributed in the hope that it will be useful, but
12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
14 || # more details.
15 || #
16 || # You should have received a copy of the GNU General Public License along
17 || # with this program; if not, write to the Free Software Foundation, Inc.,
18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
19 || ###################################################################
20 \*=====================================================================*/
21
22 // TODO - add API for product.php
23
24 require_once('./global.php');
25 require_once('./includes/functions_datastore.php');
26
27 NavLinks::productsAdd();
28 $navigator->set_focus('tab', 'products', null);
29
30 if (!can_perform('canadminversions'))
31 {
32 admin_login();
33 }
34
35 function construct_option_list($type_display, $type, $id, $edit, $addcomponent, $addversion, $delete, $displayorder)
36 {
37 global $bugsys;
38
39 $type = ($type == 'component' ? 'product' : $type);
40 $type_action = (($type == 'version') ? 'versionid' : 'productid');
41
42 if ($edit)
43 {
44 $opt .= '<option value="product.php?do=edit' . $type . '&' . $type_action . '=' . $id . '">' . sprintf(_('Edit %1$s'), $type_display) . '</option>';
45 }
46
47 if ($delete)
48 {
49 $opt .= '<option value="product.php?do=delete' . $type . '&' . $type_action . '=' . $id . '">' . sprintf(_('Delete %1$s'), $type_display) . '</option>';
50 }
51
52 if ($addcomponent)
53 {
54 $opt .= '<option value="product.php?do=addproduct&productid=' . $id . '">' . _('Add Component') . '</option>';
55 }
56
57 if ($addversion)
58 {
59 $opt .= '<option value="product.php?do=addversion&productid=' . $id . '">' . _('Add Version') . '</option>';
60 }
61
62 $type = strtolower($type);
63
64 $name = $type . '_' . $id;
65
66 $displayorder = (($displayorder != -1) ? '<input type="text" name="displayorder[' . $name . ']" value="' . $displayorder . '" size="4" class="input" /> ' : '');
67
68 return $displayorder . '<select id="' . $name . '" name="' . $name . '" onchange="exec_action(\'' . $name . '\')" class="input">' . $opt . '</select> <input type="button" class="button" name="gobutton" value=" ' . _('Go') . ' " onclick="exec_action(\'' . $name . '\')" />';
69 }
70
71 // ###################################################################
72
73 if (empty($_REQUEST['do']))
74 {
75 $_REQUEST['do'] = 'modify';
76 }
77
78 // ###################################################################
79
80 if ($_REQUEST['do'] == 'killversion')
81 {
82 $bugsys->input_clean('versionid', TYPE_UINT);
83 $db->query("DELETE FROM " . TABLE_PREFIX . "version WHERE versionid = " . $bugsys->in['versionid']);
84 $db->query("DELETE FROM " . TABLE_PREFIX . "bug WHERE version = " . $bugsys->in['versionid']);
85
86 build_versions();
87
88 $admin->redirect('product.php?do=modify');
89 }
90
91 // ###################################################################
92
93 if ($_REQUEST['do'] == 'deleteversion')
94 {
95 $admin->page_confirm(_('Are you sure you want to delete this version? Doing so will do <strong>delete all the bugs with this version</strong>.'), 'product.php', 'killversion', array('versionid' => $bugsys->input_clean('versionid', TYPE_UINT)));
96 }
97
98 // ###################################################################
99
100 if ($_REQUEST['do'] == 'insertversion')
101 {
102 $db->query("INSERT INTO " . TABLE_PREFIX . "version (productid, version, displayorder, obsolete) VALUES (" . $bugsys->input_clean('productid', TYPE_UINT) . ", '" . $bugsys->input_escape('version') . "', " . $bugsys->input_clean('displayorder', TYPE_UINT) . ", " . $bugsys->input_clean('obsolete', TYPE_UINT) . ")");
103 build_versions();
104 $admin->redirect('product.php?do=modify');
105 }
106
107 // ###################################################################
108
109 if ($_REQUEST['do'] == 'addversion')
110 {
111 NavLinks::productsEdit($bugsys->input_clean('productid', TYPE_UINT));
112 $navigator->set_focus('link', 'products-edit-version', 'products-edit');
113
114 if ($bugsys->in['productid'] != -1)
115 {
116 $product = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "product WHERE productid = " . $bugsys->in['productid']);
117 if (!is_array($product))
118 {
119 $admin->error(L_INVALID_ID);
120 }
121 }
122 else
123 {
124 $bugsys->in['productid'] = 0;
125 }
126
127 $admin->page_start(_('Add Version'));
128
129 $admin->form_start('product.php', 'insertversion');
130 $admin->form_hidden_field('productid', $bugsys->in['productid']);
131 $admin->table_start();
132 $admin->table_head(_('Add New Version'));
133 $admin->row_input(_('Version Number<div><dfn>This is the version string for this product.</dfn></div>'), 'version');
134 $admin->row_input(_('Display Order<div><dfn>The order in which the versions are displayed.</dfn></div>'), 'displayorder');
135 $admin->row_yesno(_('Obsolete<div><dfn>An obsolete version cannot have new bugs filed against it, but existing ones can be set to it.</dfn></div>'), 'obsolete', false);
136 $admin->row_submit();
137 $admin->table_end();
138 $admin->form_end();
139
140 $admin->page_end();
141 }
142
143 // ###################################################################
144
145 if ($_REQUEST['do'] == 'updateversion')
146 {
147 if (empty($bugsys->in['version']))
148 {
149 $admin->error(_('Please fill in a version number.'));
150 }
151
152 $db->query("UPDATE " . TABLE_PREFIX . "version SET version = '" . $bugsys->input_escape('version') . "', displayorder = " . $bugsys->input_clean('displayorder', TYPE_UINT) . ", obsolete = " . $bugsys->input_clean('obsolete', TYPE_UINT) . " WHERE versionid = " . $bugsys->input_clean('versionid', TYPE_UINT));
153 build_versions();
154
155 $admin->redirect('product.php?do=modify');
156 }
157
158 // ###################################################################
159
160 if ($_REQUEST['do'] == 'editversion')
161 {
162 $admin->page_start(_('Edit Version'));
163
164 $version = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "version WHERE versionid = " . $bugsys->input_clean('versionid', TYPE_UINT));
165 if (!is_array($version))
166 {
167 $admin->error(L_INVALID_ID);
168 }
169
170 $admin->form_start('product.php', 'updateversion');
171 $admin->form_hidden_field('versionid', $version['versionid']);
172 $admin->table_start();
173 $admin->table_head(sprintf(_('Edit Version - %1$s'), $version['version']));
174 $admin->row_input(_('Version Number<div><dfn>This is the version string for this product.</dfn></div>'), 'version', $version['version']);
175 $admin->row_input(_('Display Order<div><dfn>The order in which the versions are displayed.</dfn></div>'), 'displayorder', $version['displayorder']);
176 $admin->row_yesno(_('Obsolete<div><dfn>An obsolete version cannot have new bugs filed against it, but existing ones can be set to it.</dfn></div>'), 'obsolete', $version['obsolete']);
177 $admin->row_submit();
178 $admin->table_end();
179 $admin->form_end();
180
181 $admin->page_end();
182 }
183
184 // ###################################################################
185
186 if ($_REQUEST['do'] == 'killproduct')
187 {
188 $bugsys->input_clean('productid', TYPE_UINT);
189 $allprods = $db->query("SELECT * FROM " . TABLE_PREFIX . "product WHERE productid = " . $bugsys->in['productid'] . " OR parentid = " . $bugsys->in['productid']);
190 while ($prod = $db->fetch_array($allprods))
191 {
192 $list[] = $prod['productid'];
193 }
194
195 $db->query("DELETE FROM " . TABLE_PREFIX . "product WHERE productid IN (" . implode(', ', $list) . ")");
196 $db->query("DELETE FROM " . TABLE_PREFIX . "version WHERE productid IN (" . implode(', ', $list) . ")");
197 $db->query("DELETE FROM " . TABLE_PREFIX . "bug WHERE product IN (" . implode(', ', $list) . ")");
198
199 build_products();
200
201 $admin->redirect('product.php?do=modify');
202 }
203
204 // ###################################################################
205
206 if ($_REQUEST['do'] == 'deleteproduct')
207 {
208 $admin->page_confirm(_('Are you sure you want to delete this product and all of it\'s versions and components <strong>and any bugs that have been assigned those products or components</strong>?'), 'product.php', 'killproduct', array('productid' => $bugsys->input_clean('productid', TYPE_UINT)));
209 }
210
211 // ###################################################################
212
213 if ($_REQUEST['do'] == 'insertproduct')
214 {
215 if (empty($bugsys->in['title']))
216 {
217 $admin->error(_('Please go back and fill in the title field.'));
218 }
219
220 $db->query("
221 INSERT INTO " . TABLE_PREFIX . "product
222 (title, parentid, description, displayorder)
223 VALUES
224 ('" . $bugsys->input_escape('title') . "', " . $bugsys->input_clean('parentid', TYPE_UINT) . ",
225 '" . $bugsys->input_escape('description') . "', " . $bugsys->input_clean('displayorder', TYPE_UINT) . "
226 )"
227 );
228 build_products();
229
230 $admin->redirect('product.php?do=modify');
231 }
232
233 // ###################################################################
234
235 if ($_REQUEST['do'] == 'addproduct')
236 {
237 if ($bugsys->input_clean('productid', TYPE_UINT))
238 {
239 NavLinks::productsEdit($bugsys->in['productid']);
240 }
241 else
242 {
243 NavLinks::productsAdd();
244 }
245 $navigator->set_focus('link', 'products-add', 'products');
246
247 $admin->page_start(_('Add New Product'));
248
249 $admin->form_start('product.php', 'insertproduct');
250 $admin->form_hidden_field('parentid', $bugsys->in['productid']);
251 $admin->table_start();
252 $admin->table_head(_('Add Product'));
253 $admin->row_input(_('Title'), 'title');
254 $admin->row_textarea(_('Description<div><dfn>A short description of this product.</dfn></div>'), 'description');
255 $admin->row_input(_('Display Order<div><dfn>The order in which the products are displayed.</dfn></div>'), 'displayorder');
256 $admin->row_submit();
257 $admin->table_end();
258 $admin->form_end();
259
260 $admin->page_end();
261 }
262
263 // ###################################################################
264
265 if ($_REQUEST['do'] == 'updateproduct')
266 {
267 if (empty($bugsys->in['title']))
268 {
269 $admin->error(_('Please go back and fill in the title field.'));
270 }
271
272 if (empty($bugsys->in['productid']))
273 {
274 $admin->error(L_INVALID_ID);
275 }
276
277 $db->query("UPDATE " . TABLE_PREFIX . "product SET title = '" . $bugsys->input_escape('title') . "', description = '" . $bugsys->input_escape('description') . "', displayorder = " . $bugsys->input_clean('displayorder', TYPE_UINT) . " WHERE productid = " . $bugsys->input_clean('productid', TYPE_UINT));
278 build_products();
279
280 $admin->redirect('product.php?do=modify');
281 }
282
283 // ###################################################################
284
285 if ($_REQUEST['do'] == 'editproduct')
286 {
287 NavLinks::productsEdit($bugsys->input_clean('productid', TYPE_UINT));
288 $navigator->set_focus('link', 'products-edit', 'products-edit');
289
290 $admin->page_start(_('Edit Product'));
291
292 $product = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "product WHERE productid = " . $bugsys->in['productid']);
293 if (!is_array($product))
294 {
295 $admin->error(L_INVALID_ID);
296 }
297
298 $admin->form_start('product.php', 'updateproduct');
299 $admin->form_hidden_field('productid', $product['productid']);
300 $admin->table_start();
301 $admin->table_head(sprintf(_('Edit Product - %1$s'), $product['title']));
302 $admin->row_input(_('Title'), 'title', $product['title']);
303 $admin->row_textarea(_('Description<div><dfn>A short description of this product.</dfn></div>'), 'description', $product['description']);
304 $admin->row_input(_('Display Order<div><dfn>The order in which the products are displayed.</dfn></div>'), 'displayorder', $product['displayorder']);
305 $admin->row_submit();
306 $admin->table_end();
307 $admin->form_end();
308
309 $admin->page_end();
310 }
311
312 // ###################################################################
313
314 if ($_POST['do'] == 'displayorder')
315 {
316 $bugsys->input_clean('displayorder', TYPE_UINT);
317 if (is_array($bugsys->in['displayorder']))
318 {
319 foreach ($bugsys->in['displayorder'] AS $namebit => $displayorder)
320 {
321 $name = explode('_', $namebit);
322 if ($name[0] == 'product' OR $name[0] == 'version')
323 {
324 $id = $bugsys->clean($name[1], TYPE_UINT);
325 $order = $displayorder;
326 $db->query("UPDATE " . TABLE_PREFIX . "$name[0] SET displayorder = $order WHERE $name[0]id = $id");
327 }
328 }
329 build_products();
330 build_versions();
331 }
332 $admin->redirect('product.php?do=modify');
333 }
334
335 // ###################################################################
336
337 if ($_REQUEST['do'] == 'modify')
338 {
339 $navigator->set_focus('link', 'products-manage', 'products');
340
341 $admin->page_start(_('Products and Versions'));
342
343 $javascript = <<<EOF
344 <script type="text/javascript">
345 <!--
346 function exec_action(name)
347 {
348 window.location = document.getElementById(name).value;
349 }
350 //-->
351 </script>
352 EOF;
353
354 $admin->page_code($javascript);
355
356 $admin->form_start('product.php', 'displayorder');
357
358 $products_get = $db->query("SELECT * FROM " . TABLE_PREFIX . "product ORDER BY displayorder ASC");
359 $products = array();
360 while ($prod = $db->fetch_array($products_get))
361 {
362 if (!$prod['parentid'])
363 {
364 $products["$prod[productid]"] = $prod;
365 }
366 else
367 {
368 $components["$prod[parentid]"][] = $prod;
369 }
370 $version["$prod[productid]"] = array();
371 }
372
373 $versions_get = $db->query("SELECT * FROM " . TABLE_PREFIX . "version ORDER BY displayorder ASC");
374 $versions = array();
375 while ($vers = $db->fetch_array($versions_get))
376 {
377 $versions["$vers[productid]"]["$vers[versionid]"] = $vers;
378 }
379
380 $admin->table_start();
381 $admin->table_head(_('Products / Versions'));
382
383 // Handle our global versions
384 if (is_array($versions['0']))
385 {
386 $admin->row_text(_('Global Versions'), construct_option_list(_('Product'), 'product', -1, 0, 0, 1, 0, -1), 'middle', 2, 'alt3');
387 foreach ($versions['0'] AS $version)
388 {
389 $admin->row_text('-- ' . $version['version'], construct_option_list(_('Version'), 'version', $version['versionid'], 1, 0, 0, 1, $version['displayorder']), 'middle', 2, 'alt2');
390 }
391 }
392
393 // Now let's do the rest of the versions
394 foreach ($products AS $product)
395 {
396 // Product
397 $admin->row_text("<a href=\"product.php?do=editproduct&amp;productid=$product[productid]\">$product[title]</a>", construct_option_list(_('Product'), 'product', $product['productid'], 1, 1, 1, 1, $product['displayorder']), 'middle', 2, 'alt3');
398
399 // Versions
400 if (is_array($versions["$product[productid]"]))
401 {
402 foreach ($versions["$product[productid]"] AS $version)
403 {
404 $admin->row_text('-- ' . $version['version'], construct_option_list(_('Version'), 'version', $version['versionid'], 1, 0, 0, 1, $version['displayorder']), 'middle', 2, 'alt2');
405 }
406 }
407
408 // Components
409 if (is_array($components["$product[productid]"]))
410 {
411 foreach ($components["$product[productid]"] AS $comp)
412 {
413 $admin->row_text("-- <a href=\"product.php?do=editproduct&amp;productid=$comp[productid]\">$comp[title]</a>", construct_option_list(_('Component'), 'component', $comp['productid'], 1, 0, 1, 1, $comp['displayorder']), 'middle', 2, 'alt1');
414
415 // Component versions
416 if (is_array($versions["$comp[productid]"]))
417 {
418 foreach ($versions["$comp[productid]"] AS $version)
419 {
420 $admin->row_text('---- ' . $version['version'], construct_option_list(_('Version'), 'version', $version['versionid'], 1, 0, 0, 1, $version['displayorder']), 'middle', 2, 'alt2');
421 }
422 }
423 }
424 }
425 }
426
427 $admin->row_submit(null, _('Save Display Order'), null);
428
429 $admin->table_end();
430
431 $admin->form_end();
432
433 $admin->page_end();
434 }
435
436 /*=====================================================================*\
437 || ###################################################################
438 || # $HeadURL$
439 || # $Id$
440 || ###################################################################
441 \*=====================================================================*/
442 ?>