2 /*=====================================================================*\
3 || ################################################################### ||
4 || # Renapsus [#]version[#]
5 || # --------------------------------------------------------------- # ||
6 || # All parts of this file are ©2003-[#]year[#] Iris Studios, Inc. No # ||
7 || # part of this file may be reproduced in any way: part or whole. # ||
8 || # --------------------------------------------------------------- # ||
9 || # ©2003 - [#]year[#] Iris Studios, Inc. | http://www.iris-studios.com # ||
10 || ################################################################### ||
11 \*=====================================================================*/
13 require_once('./global.php');
14 require_once('./includes/functions_datastore.php');
16 if (!can_perform('canadminversions'))
21 function construct_option_list($type, $id, $edit, $addcomponent, $addversion, $delete, $displayorder)
23 $type_display = substr_replace($type, strtoupper($type{0}), 0, 1);
24 $type = iff($type == 'component', 'product', $type);
25 $type_action = iff($type == 'version', 'versionid', 'productid');
29 $opt .= '<option value="product.php?do=edit' . $type . '&' . $type_action . '=' . $id . '">Edit ' . $type_display . '</option>';
34 $opt .= '<option value="product.php?do=delete' . $type . '&' . $type_action . '=' . $id . '">Delete ' . $type_display . '</option>';
39 $opt .= '<option value="product.php?do=addproduct&productid=' . $id . '">' . phrase('add_component') . '</option>';
44 $opt .= '<option value="product.php?do=addversion&productid=' . $id . '">' . phrase('add_version') . '</option>';
47 $type = strtolower($type);
49 $name = $type . '_' . $id;
51 $displayorder = iff($displayorder != -1, '<input type="text" name="displayorder[' . $name . ']" value="' . $displayorder . '" size="4" /> ', '');
53 return $displayorder . '<select id="' . $name . '" name="' . $name . '" onchange="exec_action(\'' . $name . '\')">' . $opt . '</select> <input type="button" name="gobutton" value=" ' . phrase('go') . ' " onclick="exec_action(\'' . $name . '\')" />';
56 // ###################################################################
58 if (empty($_REQUEST['do']))
60 $_REQUEST['do'] = 'modify';
63 // ###################################################################
65 if ($_REQUEST['do'] == 'killversion')
67 sanitize(array('versionid' => INT));
69 $DB_sql->query("DELETE FROM " . TABLE_PREFIX
. "version WHERE versionid = $vars[versionid]");
70 // #*# figure out what we do with bugs
74 $admin->redirect('product.php?do=modify');
77 // ###################################################################
79 if ($_REQUEST['do'] == 'deleteversion')
81 sanitize(array('versionid' => INT));
82 $admin->page_confirm(phrase('confirm_delete_version'), 'product.php?do=killversion&versionid=' . $vars['versionid']);
85 // ###################################################################
87 if ($_REQUEST['do'] == 'insertversion')
89 sanitize(array('productid' => INT, 'version' => STR
, 'displayorder' => INT));
90 $DB_sql->query("INSERT INTO " . TABLE_PREFIX
. "version (productid, version, displayorder) VALUES ($vars[productid], '" . addslasheslike($vars['version']) . "', $vars[displayorder])");
92 $admin->redirect('product.php?do=modify');
95 // ###################################################################
97 if ($_REQUEST['do'] == 'addversion')
99 sanitize(array('productid' => INT));
101 $admin->page_start(phrase('add_version'));
103 if ($vars['productid'] != -1)
105 $product = $DB_sql->query_first("SELECT * FROM " . TABLE_PREFIX
. "product WHERE productid = $vars[productid]");
106 if (!is_array($product))
113 $vars['productid'] = 0;
116 $admin->form_start('product.php', 'insertversion');
117 $admin->form_hidden_field('productid', $vars['productid']);
118 $admin->table_start();
119 $admin->table_head(phrase('add_new_version'));
120 $admin->row_input(phrase('version_title'), 'version');
121 $admin->row_input(phrase('version_display_order'), 'displayorder');
122 $admin->row_submit();
129 // ###################################################################
131 if ($_REQUEST['do'] == 'updateversion')
133 sanitize(array('versionid' => INT, 'version' => STR
, 'displayorder' => INT));
135 if (empty($vars['version']))
137 $admin->error(phrase('fill_in_version_number'));
140 $DB_sql->query("UPDATE " . TABLE_PREFIX
. "version SET version = '" . addslasheslike($vars['version']) . "', displayorder = $vars[displayorder] WHERE versionid = $vars[versionid]");
143 $admin->redirect('product.php?do=modify');
146 // ###################################################################
148 if ($_REQUEST['do'] == 'editversion')
150 sanitize(array('versionid' => INT));
152 $admin->page_start(phrase('edit_version'));
154 $version = $DB_sql->query_first("SELECT * FROM " . TABLE_PREFIX
. "version WHERE versionid = $vars[versionid]");
155 if (!is_array($version))
160 $admin->form_start('product.php', 'updateversion');
161 $admin->form_hidden_field('versionid', $version['versionid']);
162 $admin->table_start();
163 $admin->table_head(phrase('edit_version_title', $version['version']));
164 $admin->row_input(phrase('version_title'), 'version', $version['version']);
165 $admin->row_input(phrase('version_display_order'), 'displayorder', $version['displayorder']);
166 $admin->row_submit();
173 // ###################################################################
175 if ($_REQUEST['do'] == 'killproduct')
177 sanitize(array('productid' => INT));
179 $allprods = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX
. "product WHERE productid = $vars[productid] OR componentmother = $vars[productid]");
180 while ($prod = $DB_sql->fetch_array($allprods))
182 $list[] = $prod['productid'];
185 $DB_sql->query("DELETE FROM " . TABLE_PREFIX
. "product WHERE productid IN (" . implode(', ', $list) . ")");
186 $DB_sql->query("DELETE FROM " . TABLE_PREFIX
. "version WHERE productid IN (" . implode(', ', $list) . ")");
187 // #*# do bug kills here
191 $admin->redirect('product.php?do=modify');
194 // ###################################################################
196 if ($_REQUEST['do'] == 'deleteproduct')
198 sanitize(array('productid' => INT));
199 $admin->page_confirm(phrase('confirm_delete_product'), 'product.php?do=killproduct&productid=' . $vars['productid']);
202 // ###################################################################
204 if ($_REQUEST['do'] == 'insertproduct')
206 sanitize(array('shortname' => STR
, 'title' => STR
, 'componentmother' => INT, 'description' => STR
, 'displayorder' => INT));
208 if (empty($vars['shortname']) OR empty($vars['title']))
210 $admin->error(phrase('go_back_and_fill_both_fields'));
214 INSERT INTO " . TABLE_PREFIX
. "product
215 (shortname, title, componentmother, description, displayorder)
217 ('" . addslasheslike($vars['shortname']) . "', '" . addslasheslike($vars['title']) . "',
218 $vars[componentmother], '" . addslasheslike($vars['description']) . "', $vars[displayorder])"
222 $admin->redirect('product.php?do=modify');
225 // ###################################################################
227 if ($_REQUEST['do'] == 'addproduct')
229 sanitize(array('productid' => INT));
231 $admin->page_start(phrase('add_new_product'));
233 $admin->form_start('product.php', 'insertproduct');
234 $admin->form_hidden_field('componentmother', $vars['productid']);
235 $admin->table_start();
236 $admin->table_head(phrase('add_product'));
237 $admin->row_input(phrase('product_shortname'), 'shortname');
238 $admin->row_input(phrase('product_title'), 'title');
239 $admin->row_textarea(phrase('product_description'), 'description');
240 $admin->row_input(phrase('product_display_order'), 'displayorder');
241 $admin->row_submit();
248 // ###################################################################
250 if ($_REQUEST['do'] == 'updateproduct')
252 sanitize(array('productid' => INT, 'title' => STR
, 'shortname' => STR
, 'description' => STR
, 'displayorder' => INT));
254 if (empty($vars['shortname']) OR empty($vars['title']))
256 $admin->error(phrase('go_back_and_fill_both_fields'));
259 if (empty($vars['productid']))
264 $DB_sql->query("UPDATE " . TABLE_PREFIX
. "product SET title = '" . addslasheslike($vars['title']) . "', shortname = '" . addslasheslike($vars['shortname']) . "', description = '" . addslasheslike($vars['description']) . "', displayorder = $vars[displayorder] WHERE productid = $vars[productid]");
267 $admin->redirect('product.php?do=modify');
270 // ###################################################################
272 if ($_REQUEST['do'] == 'editproduct')
274 sanitize(array('productid' => INT));
276 $admin->page_start(phrase('edit_product'));
278 $product = $DB_sql->query_first("SELECT * FROM " . TABLE_PREFIX
. "product WHERE productid = $vars[productid]");
280 if (!is_array($product))
285 $admin->form_start('product.php', 'updateproduct');
286 $admin->form_hidden_field('productid', $product['productid']);
287 $admin->table_start();
288 $admin->table_head(phrase('edit_product_title', $product['title']));
289 $admin->row_input(phrase('product_title'), 'title', $product['title']);
290 $admin->row_input(phrase('product_shortname'), 'shortname', $product['shortname']);
291 $admin->row_textarea(phrase('product_description'), 'description', $product['description']);
292 $admin->row_input(phrase('product_display_order'), 'displayorder', $product['displayorder']);
293 $admin->row_submit();
300 // ###################################################################
302 if ($_POST['do'] == 'displayorder')
304 foreach ((array)$_POST['displayorder'] AS $namebit => $displayorder)
306 $name = explode('_', $namebit);
307 if ($name[0] == 'product' OR $name[0] == 'version')
309 $id = intval($name[1]);
310 $order = intval($displayorder);
311 $DB_sql->query("UPDATE " . TABLE_PREFIX
. "$name[0] SET displayorder = $order WHERE $name[0]id = $id");
316 $admin->redirect('product.php?do=modify');
319 // ###################################################################
321 if ($_REQUEST['do'] == 'modify')
323 $admin->page_start(phrase('products_and_versions'));
326 <script type="text
/javascript
">
328 function exec_action(name)
330 window.location = document.getElementById(name).value;
336 $admin->page_code($javascript);
338 $admin->form_start('product.php', 'displayorder');
340 $products = $DB_sql->query("SELECT
* FROM
" . TABLE_PREFIX . "product ORDER BY displayorder ASC
");
341 while ($prod = $DB_sql->fetch_array($products))
343 if (!$prod['componentmother'])
345 $product["$prod[productid
]"] = $prod;
349 $component["$prod[componentmother
]"][] = $prod;
351 $version["$prod[productid
]"] = array();
353 $products = (array)$product;
355 $versions = $DB_sql->query("SELECT
* FROM
" . TABLE_PREFIX . "version ORDER BY displayorder ASC
");
356 while ($vers = $DB_sql->fetch_array($versions))
358 $version["$vers[productid
]"]["$vers[versionid
]"] = $vers;
360 $versions = (array)$version;
362 $admin->table_start();
363 $admin->table_head(phrase('products_versions'));
365 // Handle our global versions
366 if (is_array($versions['0']))
368 $admin->row_text(phrase('global_versions'), construct_option_list('product', -1, 0, 0, 1, 0, -1), 'middle', 2, 'alt3');
369 foreach ($versions['0'] AS $version)
371 $admin->row_text('-- ' . $version['version'], construct_option_list('version', $version['versionid'], 1, 0, 0, 1, $version['displayorder']), 'middle', 2, 'alt2');
375 // Now let's do the rest of the versions
376 foreach ($products AS $product)
379 $admin->row_text("<a href
=\"product
.php
?do=editproduct
&
;productid
=$product[productid
]\">$product[title
]</a
>", construct_option_list('product', $product['productid'], 1, 1, 1, 1, $product['displayorder']), 'middle', 2, 'alt3');
382 foreach ($versions["$product[productid
]"] AS $version)
384 $admin->row_text('-- ' . $version['version'], construct_option_list('version', $version['versionid'], 1, 0, 0, 1, $version['displayorder']), 'middle', 2, 'alt2');
388 foreach ((array)$component["$product[productid
]"] AS $comp)
390 $admin->row_text("-- <a href
=\"product
.php
?do=editproduct
&
;productid
=$comp[productid
]\">$comp[title
]</a
>", construct_option_list('component', $comp['productid'], 1, 0, 1, 1, $comp['displayorder']), 'middle', 2, 'alt1');
392 // Component versions
393 foreach ($versions["$comp[productid
]"] AS $version)
395 $admin->row_text('---- ' . $version['version'], construct_option_list('version', $version['versionid'], 1, 0, 0, 1, $version['displayorder']), 'middle', 2, 'alt2');
400 $admin->row_span('<input type="submit
" name="button
" value=" ' . phrase('save_display_order
') . ' " accesskey="s
" /> <input type="button
" name="addproduct
" value=" ' . phrase('add_new_product
') . ' " onclick="window
.location
= \'product
.php
?do=addproduct\'
;" />', 'tfoot', 'center');
409 /*=====================================================================*\
410 || ###################################################################
413 || ###################################################################
414 \*=====================================================================*/