From cce1b8c3c3fdec6ddb5d83e249081f48f71865c2 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Mon, 17 Jul 2006 20:04:06 +0000 Subject: [PATCH] r895: Adding and implementing the SeverityAPI --- admin/severity.php | 38 +++++++++++++++------- includes/api_severity.php | 67 +++++++++++++++++++++++++++++++++++++++ 2 files changed, 93 insertions(+), 12 deletions(-) create mode 100644 includes/api_severity.php diff --git a/admin/severity.php b/admin/severity.php index e8c08e8..f25886f 100755 --- a/admin/severity.php +++ b/admin/severity.php @@ -21,6 +21,7 @@ require_once('./global.php'); require_once('./includes/functions_datastore.php'); +require_once('./includes/api_severity.php'); if (!can_perform('canadminfields')) { @@ -38,7 +39,11 @@ if (empty($_REQUEST['do'])) if ($_REQUEST['do'] == 'kill') { - $db->query("DELETE FROM " . TABLE_PREFIX . "severity WHERE severityid = " . $bugsys->input_clean('serverityid', TYPE_UINT)); + $severity = new SeverityAPI($bugsys); + $severity->set('severityid', $bugsys->in['severityid']); + $severity->set_condition(); + $severity->delete(); + build_severities(); $admin->redirect('severity.php?do=modify'); } @@ -54,7 +59,11 @@ if ($_REQUEST['do'] == 'delete') if ($_POST['do'] == 'insert') { - $db->query("INSERT INTO " . TABLE_PREFIX . "severity (severity, displayorder) VALUES ('" . $bugsys->in['severity'] . "', " . $bugsys->input_clean('displayorder', TYPE_UINT) . ")"); + $severity = new SeverityAPI($bugsys); + $severity->set('severity', $bugsys->in['severity']); + $severity->set('displayorder', $bugsys->in['displayorder']); + $severity->insert(); + build_severities(); $admin->redirect('severity.php?do=modify'); } @@ -81,7 +90,13 @@ if ($_REQUEST['do'] == 'add') if ($_POST['do'] == 'update') { - $db->query("UPDATE " . TABLE_PREFIX . "severity SET severity = '" . $bugsys->in['severity'] . "', displayorder = " . $bugsys->input_clean('displayorder']) . " WHERE severityid = " . intval1($bugsys->in['severityid', TYPE_UINT)); + $severity = new SeverityAPI($bugsys); + $severity->set('severityid', $bugsys->in['severityid']); + $severity->set_condition(); + $severity->set('severity', $bugsys->in['severity']); + $severity->set('displayorder', $bugsys->in['displayorder']); + $severity->update(); + build_severities(); $admin->redirect('severity.php?do=modify'); } @@ -90,20 +105,19 @@ if ($_POST['do'] == 'update') if ($_REQUEST['do'] == 'edit') { - $severity = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "severity WHERE severityid = " . $bugsys->input_clean('severityid', TYPE_UINT)); - if (!is_array($severity)) - { - $admin->error($lang->getlex('error_invalid_id')); - } + $severity = new SeverityAPI($bugsys); + $severity->set('severityid', $bugsys->in['severityid']); + $severity->set_condition(); + $severity->fetch(); $admin->page_start($lang->string('Edit Severity')); $admin->form_start('severity.php', 'update'); - $admin->form_hidden_field('severityid', $severity['severityid']); + $admin->form_hidden_field('severityid', $severity->objdata['severityid']); $admin->table_start(); - $admin->table_head(sprintf($lang->string('Edit Severity - %1$s (id: %2$s)'), $severity['severity'], $severity['severityid']), 2, 'standard_bug_fields'); - $admin->row_input($lang->string('Severity Title
The title of this severity flag (eg: `Major` or `Critical`)
'), 'severity', $severity['severity']); - $admin->row_input($lang->string('Display Order
The order in which the severities are displayed. The higher the number, the lower down in the list it is.
'), 'displayorder', $severity['displayorder']); + $admin->table_head(sprintf($lang->string('Edit Severity - %1$s (id: %2$s)'), $severity->objdata['severity'], $severity->objdata['severityid']), 2, 'standard_bug_fields'); + $admin->row_input($lang->string('Severity Title
The title of this severity flag (eg: `Major` or `Critical`)
'), 'severity', $severity->objdata['severity']); + $admin->row_input($lang->string('Display Order
The order in which the severities are displayed. The higher the number, the lower down in the list it is.
'), 'displayorder', $severity->objdata['displayorder']); $admin->row_submit(); $admin->table_end(); $admin->form_end(); diff --git a/includes/api_severity.php b/includes/api_severity.php new file mode 100644 index 0000000..d917248 --- /dev/null +++ b/includes/api_severity.php @@ -0,0 +1,67 @@ +load('api', null); + +/** +* API: Severity +* +* @author Iris Studios, Inc. +* @copyright Copyright ©2002 - [#]year[#], Iris Studios, Inc. +* @version $Revision$ +* @package Bugdar +* +*/ +class SeverityAPI extends API +{ + /** + * Fields + * @var array + * @access private + */ + var $fields = array( + 'severityid' => array(TYPE_UINT, REQ_AUTO, 'verify_nozero'), + 'severity' => array(TYPE_STR, REQ_YES, 'verify_noempty'), + 'displayorder' => array(TYPE_INT, REQ_NO) + ); + + /** + * Database table + * @var string + * @access private + */ + var $table = 'severity'; + + /** + * Table prefix + * @var string + * @access private + */ + var $prefix = TABLE_PREFIX; +} + +/*=====================================================================*\ +|| ################################################################### +|| # $HeadURL$ +|| # $Id$ +|| ################################################################### +\*=====================================================================*/ +?> \ No newline at end of file -- 2.22.5