From 6a219146c4c3ca565de02e5a541afdaa1cd63e22 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Mon, 17 Jul 2006 00:19:45 +0000 Subject: [PATCH] r891: Adding and implementing the PriorityAPI --- admin/priority.php | 40 +++++++++++++++-------- includes/api_priority.php | 67 +++++++++++++++++++++++++++++++++++++++ 2 files changed, 94 insertions(+), 13 deletions(-) create mode 100644 includes/api_priority.php diff --git a/admin/priority.php b/admin/priority.php index 3bab50a..5fd883a 100755 --- a/admin/priority.php +++ b/admin/priority.php @@ -21,6 +21,7 @@ require_once('./global.php'); require_once('./includes/functions_datastore.php'); +require_once('./includes/api_priority.php'); if (!can_perform('canadminfields')) { @@ -38,7 +39,11 @@ if (empty($_REQUEST['do'])) if ($_REQUEST['do'] == 'kill') { - $db->query("DELETE FROM " . TABLE_PREFIX . "priority WHERE priorityid = " . $bugsys->input_clean('priorityid', TYPE_UINT)); + $priority = new PriorityAPI($bugsys); + $priority->set('priorityid', $bugsys->in['priorityid']); + $priority->set_condition(); + $priority->delete(); + build_priorities(); $admin->redirect('priority.php?do=modify'); } @@ -54,7 +59,11 @@ if ($_REQUEST['do'] == 'delete') if ($_POST['do'] == 'insert') { - $db->query("INSERT INTO " . TABLE_PREFIX . "priority (priority, displayorder) VALUES ('" . $bugsys->in['priority'] . "'," . $bugsys->input_clean('displayorder', TYPE_UINT) . ")"); + $priority = new PriorityAPI($bugsys); + $priority->set('priority', $bugsys->in['priority']); + $priority->set('displayorder', $bugsys->in['displayorder']); + $priority->insert(); + build_priorities(); $admin->redirect('priority.php?do=modify'); } @@ -81,7 +90,13 @@ if ($_REQUEST['do'] == 'add') if ($_POST['do'] == 'update') { - $db->query("UPDATE " . TABLE_PREFIX . "priority SET priority = '" . $bugsys->in['priority'] . "', displayorder = " . $bugsys->input_clean('displayorder', TYPE_UINT) . " WHERE priorityid = " . $bugsys->input_clean('priorityid', TYPE_UINT)); + $priority = new PriorityAPI($bugsys); + $priority->set('priorityid', $bugsys->in['priorityid']); + $priority->set_condition(); + $priority->set('priority', $bugsys->in['priority']); + $priority->set('displayorder', $bugsys->in['displayorder']); + $priority->update(); + build_priorities(); $admin->redirect('priority.php?do=modify'); } @@ -90,20 +105,19 @@ if ($_POST['do'] == 'update') if ($_REQUEST['do'] == 'edit') { - $priority = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "priority WHERE priorityid = " . $bugsys->input_clean('priorityid', TYPE_UINT)); - if (!is_array($priority)) - { - $admin->error($lang->getlex('error_invalid_id')); - } + $priority = new PriorityAPI($bugsys); + $priority->set('priorityid', $bugsys->in['priorityid']); + $priority->set_condition(); + $priority->fetch(); $admin->page_start($lang->string('Edit Priority'), 2, 'standard_bug_fields'); $admin->form_start('priority.php', 'update'); - $admin->form_hidden_field('priorityid', $priority['priorityid']); + $admin->form_hidden_field('priorityid', $priority->objdata['priorityid']); $admin->table_start(); - $admin->table_head(sprintf($lang->string('Edit Priority `%1$s` (id: %2$s)'), $priority['priority'], $priority['priorityid'])); - $admin->row_input($lang->string('Priority Title
The title of this priority flag (eg: `Slated for Development` or `Address Now`)
'), 'priority', $priority['priority']); - $admin->row_input($lang->string('Display Order
The order in which the priorities are displayed. The higher the number, the lower down in the list it is.
'), 'displayorder', $priority['displayorder']); + $admin->table_head(sprintf($lang->string('Edit Priority `%1$s` (id: %2$s)'), $priority->objdata['priority'], $priority->objdata['priorityid'])); + $admin->row_input($lang->string('Priority Title
The title of this priority flag (eg: `Slated for Development` or `Address Now`)
'), 'priority', $priority->objdata['priority']); + $admin->row_input($lang->string('Display Order
The order in which the priorities are displayed. The higher the number, the lower down in the list it is.
'), 'displayorder', $priority->objdata['displayorder']); $admin->row_submit(); $admin->table_end(); $admin->form_end(); @@ -127,7 +141,7 @@ if ($_REQUEST['do'] == 'modify') { $admin->row_text("$priority[displayorder]: $priority[priority]", "(priorityid: $priority[priorityid]) [" . $lang->string('Edit') . "] [" . $lang->string('Delete') . "]"); } - $db->free_result($priorityes); + $db->free_result($priorities); $admin->row_span('[' . $lang->string('Add New Priority') . ']', 'tfoot', 'center', 3); $admin->table_end(); diff --git a/includes/api_priority.php b/includes/api_priority.php new file mode 100644 index 0000000..e9cdbc2 --- /dev/null +++ b/includes/api_priority.php @@ -0,0 +1,67 @@ +load('api', null); + +/** +* API: Priority +* +* @author Iris Studios, Inc. +* @copyright Copyright ©2002 - [#]year[#], Iris Studios, Inc. +* @version $Revision$ +* @package Bugdar +* +*/ +class PriorityAPI extends API +{ + /** + * Fields + * @var array + * @access private + */ + var $fields = array( + 'priorityid' => array(TYPE_UINT, REQ_AUTO, 'verify_nozero'), + 'priority' => array(TYPE_STR, REQ_YES, 'verify_noempty'), + 'displayorder' => array(TYPE_INT, REQ_NO) + ); + + /** + * Database table + * @var string + * @access private + */ + var $table = 'priority'; + + /** + * Table prefix + * @var string + * @access private + */ + var $prefix = TABLE_PREFIX; +} + +/*=====================================================================*\ +|| ################################################################### +|| # $HeadURL$ +|| # $Id$ +|| ################################################################### +\*=====================================================================*/ +?> \ No newline at end of file -- 2.22.5