ifthd->member['acp']['manage_depart_cfields'] ) { $this->ifthd->skin->error('no_perm'); } $this->ifthd->skin->set_section( 'Ticket Control' ); $this->ifthd->skin->set_description( 'Manage your tickets, departments, custom department fields and canned replies.' ); switch( $this->ifthd->input['code'] ) { case 'list': $this->list_fields(); break; case 'add': $this->add_field(); break; case 'edit': $this->edit_field(); break; case 'doadd': $this->do_add(); break; case 'doedit': $this->do_edit(); break; case 'dodel': $this->do_delete(); break; default: $this->list_fields(); break; } } #======================================= # @ List Fields # Show a list of custom department fields. #======================================= function list_fields($error='', $alert='') { #============================= # Grab Fields #============================= $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'depart_fields', ) ); $this->ifthd->core->db->execute(); $field_rows = ""; // Initialize for Security $row_count = 0; // Initialize for Security if ( $this->ifthd->core->db->get_num_rows() ) { while( $f = $this->ifthd->core->db->fetch_row() ) { $row_count ++; ( $row_count & 1 ) ? $row_class = 'option1-med' : $row_class = 'option2-med'; #============================= # Fix Up Information #============================= if ( $f['required'] ) { $f['required'] = 'Yes'; } else { $f['required'] = 'No'; } if ( $f['type'] == 'textfield' ) { $f['type'] = 'Text Field'; } elseif ( $f['type'] == 'textarea' ) { $f['type'] = 'Text Area'; } elseif ( $f['type'] == 'dropdown' ) { $f['type'] = 'Drop-Down'; } elseif ( $f['type'] == 'checkbox' ) { $f['type'] = 'Checkbox'; } elseif ( $f['type'] == 'radio' ) { $f['type'] = 'Radio'; } $field_rows .= " {$f['id']} {$f['name']} {$f['fkey']} {$f['type']} {$f['required']}

"; } } else { $field_rows .= " There are no fields to display. "; } #============================= # Do Output #============================= if ( $error ) { $error = "

{$error}

"; } elseif ( $alert ) { $error = "

{$alert}

"; } $this->output = " {$error}

Custom Department Fields List

". $field_rows ."

ID	Name	Key	Type	Required	Edit	Delete

Add A New Field

"; $this->ifthd->skin->add_output( $this->output ); $this->nav = array( "Management", "Custom Department Fields", "List Fields", ); $this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Custom Department Fields' ) ); } #======================================= # @ Add Field # Show add custom field form. #======================================= function add_field($error="") { #============================= # Generate Permissions #============================= if ( is_array( $this->ifthd->input['departs'] ) ) { while ( list( , $depart ) = each( $this->ifthd->input['departs'] ) ) { $departs[ $depart ] = 1; } } #============================= # Do Output #============================= if ( $this->ifthd->input['type'] == 'textfield' ) $sel_textfield = " selected='selected'"; if ( $this->ifthd->input['type'] == 'textarea' ) $sel_textarea = " selected='selected'"; if ( $this->ifthd->input['type'] == 'dropdown' ) $sel_dropdown = " selected='selected'"; if ( $this->ifthd->input['type'] == 'checkbox' ) $sel_checkbox = " selected='selected'"; if ( $this->ifthd->input['type'] == 'radio' ) $sel_radio = " selected='selected'"; if ( $error ) { $error = "

{$error}

"; } $this->output = " {$error}

Adding Custom Department Field

"; if ( ACP_HELP ) { $this->output .= ""; } $this->output .= ""; if ( ACP_HELP ) { $this->output .= ""; } $this->output .= ""; if ( ACP_HELP ) { $this->output .= ""; } $this->output .= ""; if ( ACP_HELP ) { $this->output .= ""; } $this->output .= "

Name
Key	(No spaces. Must be alphanumeric & lowercase)
Toggle information The key is a unique identifier for this custom field. It should contain no spaces and it must be alphanumeric plus lowercase.
Type
Extra Use with drop-down list or radios. Put each option on a new line. Format: key=Value	{$this->ifthd->input['extra']}
Toggle information Example for dropdown: yes=Yes no=No maybe=Maybe
Required	". $this->ifthd->skin->yes_no_radio( 'required', $this->ifthd->input['required'] ) ."
Toggle information If required, this field must have a value before a ticket can be submitted.
Departments
Toggle information Select the departments in which this custom field should appear when submitting a ticket. You can select more than one department.

"; $this->ifthd->skin->add_output( $this->output ); $this->nav = array( "Management", "Custom Department Fields", "Add Department", ); $this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Custom Department Fields' ) ); } #======================================= # @ Edit Field # Show edit custom field form. #======================================= function edit_field($error="") { #============================= # Security Checks #============================= $this->ifthd->input['id'] = intval( $this->ifthd->input['id'] ); $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'depart_fields', 'where' => array( 'id', '=', $this->ifthd->input['id'] ), 'limit' => array( 0,1 ), ) ); $this->ifthd->core->db->execute(); if ( ! $this->ifthd->core->db->get_num_rows() ) { $this->ifthd->skin->error('no_dfield'); } $f = $this->ifthd->core->db->fetch_row(); #============================= # Do Output #============================= if ( $error ) { $error = "

{$error}

"; $name = $this->ifthd->input['name']; $fkey = $this->ifthd->input['fkey']; $extra = $this->ifthd->input['fextra']; $required = $this->ifthd->input['required']; if ( $this->ifthd->input['type'] == 'textfield' ) $sel_textfield = " selected='selected'"; if ( $this->ifthd->input['type'] == 'textarea' ) $sel_textarea = " selected='selected'"; if ( $this->ifthd->input['type'] == 'dropdown' ) $sel_dropdown = " selected='selected'"; if ( $this->ifthd->input['type'] == 'checkbox' ) $sel_checkbox = " selected='selected'"; if ( $this->ifthd->input['type'] == 'radio' ) $sel_radio = " selected='selected'"; if ( is_array( $this->ifthd->input['departs'] ) ) { while ( list( , $depart ) = each( $this->ifthd->input['departs'] ) ) { $departs[ $depart ] = 1; } } } else { $name = $f['name']; $fkey = $f['fkey']; $extra = $f['extra']; $required = $f['required']; if ( $f['type'] == 'textfield' ) $sel_textfield = " selected='selected'"; if ( $f['type'] == 'textarea' ) $sel_textarea = " selected='selected'"; if ( $f['type'] == 'dropdown' ) $sel_dropdown = " selected='selected'"; if ( $f['type'] == 'checkbox' ) $sel_checkbox = " selected='selected'"; if ( $f['type'] == 'radio' ) $sel_radio = " selected='selected'"; $departs = unserialize( $f['departs'] ); } $this->output = " {$error}

Editing Custom Department Field: {$f['name']}

Name
Key	(No spaces. Must be alphanumeric & lowercase)
Toggle information The key is a unique identifier for this custom field. It should contain no spaces and it must be alphanumeric plus lowercase.
Type
Extra Use with drop-down list or radios. Put each option on a new line. Format: key=Value	{$extra}
Toggle information Example for dropdown: yes=Yes no=No maybe=Maybe
Required	". $this->ifthd->skin->yes_no_radio( 'required', $required ) ."
Toggle information If required, this field must have a value before a ticket can be submitted.
Departments
Toggle information Select the departments in which this custom field should appear when submitting a ticket. You can select more than one department.

"; $this->ifthd->skin->add_output( $this->output ); $this->nav = array( "Management", "Custom Department Fields", "Edit Department", ); $this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Custom Department Fields' ) ); } #======================================= # @ Do Add # Add a new custom field. #======================================= function do_add() { #============================= # Security Checks #============================= if ( ! $this->ifthd->input['name'] ) { $this->add_field('Please enter a name.'); } if ( strlen( $this->ifthd->input['fkey'] ) < 3 ) { $this->add_field('Please enter a key.'); } if ( ! $this->key_check( $this->ifthd->input['fkey'] ) ) { $this->add_field('Your key must be alphanumeric, lowercase, and contain no spaces.'); } if ( $this->ifthd->input['type'] == 'dropdown' ) { if ( strlen( $this->ifthd->input['fextra'] ) < 3 ) { $this->add_field('Please enter drop-down values in the extra textbox.'); } } if ( $this->ifthd->input['type'] == 'radio' ) { if ( strlen( $this->ifthd->input['fextra'] ) < 3 ) { $this->add_field('Please enter radio values in the extra textbox.'); } } #============================= # Generate Permissions #============================= if ( is_array( $this->ifthd->input['departs'] ) ) { while ( list( , $depart ) = each( $this->ifthd->input['departs'] ) ) { $departs[ $depart ] = 1; } } #============================= # Add Field #============================= $db_array = array( 'fkey' => $this->ifthd->input['fkey'], 'name' => $this->ifthd->input['name'], 'type' => $this->ifthd->input['type'], 'extra' => $this->ifthd->input['fextra'], 'required' => $this->ifthd->input['required'], 'departs' => serialize($departs), ); $this->ifthd->core->db->construct( array( 'insert' => 'depart_fields', 'set' => $db_array, ) ); $this->ifthd->core->db->execute(); $field_id = $this->ifthd->core->db->get_insert_id(); $this->ifthd->log( 'admin', "Department Field Added '". $this->ifthd->input['name'] ."'", 1, $field_id ); #============================= # Rebuild Cache #============================= $this->ifthd->rebuild_dfields_cache(); #============================= # Redirect #============================= #$this->ifthd->skin->redirect( '?section=manage&act=cdfields&code=list', 'add_dfield_success' ); $this->list_fields( '', 'The custom department field has been successfully added.' ); } #======================================= # @ Do Edit # Edit a custom field. #======================================= function do_edit() { #============================= # Security Checks #============================= $this->ifthd->input['id'] = intval( $this->ifthd->input['id'] ); $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'depart_fields', 'where' => array( 'id', '=', $this->ifthd->input['id'] ), 'limit' => array( 0,1 ), ) ); $this->ifthd->core->db->execute(); if ( ! $this->ifthd->core->db->get_num_rows() ) { $this->ifthd->skin->error('no_dfield'); } if ( ! $this->ifthd->input['name'] ) { $this->edit_field('Please enter a name.'); } if ( strlen( $this->ifthd->input['fkey'] ) < 3 ) { $this->edit_field('Please enter a key.'); } if ( ! $this->key_check( $this->ifthd->input['fkey'] ) ) { $this->edit_field('Your key must be alphanumeric, lowercase, and contain no spaces.'); } if ( $this->ifthd->input['type'] == 'dropdown' ) { if ( strlen( $this->ifthd->input['fextra'] ) < 3 ) { $this->edit_field('Please enter drop-down values in the extra textbox.'); } } if ( $this->ifthd->input['type'] == 'radio' ) { if ( strlen( $this->ifthd->input['fextra'] ) < 3 ) { $this->edit_field('Please enter radio values in the extra textbox.'); } } #============================= # Generate Permissions #============================= if ( is_array( $this->ifthd->input['departs'] ) ) { while ( list( , $depart ) = each( $this->ifthd->input['departs'] ) ) { $departs[ $depart ] = 1; } } #============================= # Edit Field #============================= $db_array = array( 'fkey' => $this->ifthd->input['fkey'], 'name' => $this->ifthd->input['name'], 'type' => $this->ifthd->input['type'], 'extra' => $this->ifthd->input['fextra'], 'required' => $this->ifthd->input['required'], 'departs' => serialize($departs), ); $this->ifthd->core->db->construct( array( 'update' => 'depart_fields', 'set' => $db_array, 'where' => array( 'id', '=', $this->ifthd->input['id'] ), ) ); $this->ifthd->core->db->execute(); $this->ifthd->log( 'admin', "Department Field Edited '". $this->ifthd->input['name'] ."'", 1, $this->ifthd->input['id'] ); #============================= # Rebuild Cache #============================= $this->ifthd->rebuild_dfields_cache(); #============================= # Redirect #============================= #$this->ifthd->skin->redirect( '?section=manage&act=cdfields&code=list', 'edit_dfield_success' ); $this->list_fields( '', 'The custom department field has been successfully updated.' ); } #======================================= # @ Do Delete # Delete a custom field. #======================================= function do_delete() { #============================= # Security Checks #============================= $this->ifthd->input['id'] = intval( $this->ifthd->input['id'] ); $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'depart_fields', 'where' => array( 'id', '=', $this->ifthd->input['id'] ), 'limit' => array( 0,1 ), ) ); $this->ifthd->core->db->execute(); if ( ! $this->ifthd->core->db->get_num_rows() ) { $this->ifthd->skin->error('no_dfield'); } $f = $this->ifthd->core->db->fetch_row(); #============================= # Delete Field #============================= $this->ifthd->core->db->construct( array( 'delete' => 'depart_fields', 'where' => array( 'id', '=', $f['id'] ), 'limit' => array( 1 ), ) ); $this->ifthd->core->db->execute(); $this->ifthd->log( 'admin', "Department Field Deleted '". $f['name'] ."'", 2, $f['id'] ); #============================= # Rebuild Cache #============================= $this->ifthd->rebuild_dfields_cache(); #============================= # Redirect #============================= #$this->ifthd->skin->redirect( '?section=manage&act=cdfields&code=list', 'delete_dfield_success' ); $this->list_fields( 'The custom department field has been successfully deleted.' ); } #======================================= # @ Key Check # Checks to see if profile key is valid. #======================================= function key_check($key) { if ( preg_match( '/^[a-z0-9_]*$/', $key ) ) { return TRUE; } return FALSE; } } ?>