ifthd->member['acp']['manage_canned'] )
{
$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_canned();
break;
case 'add':
$this->add_canned();
break;
case 'edit':
$this->edit_canned();
break;
case 'get':
$this->get_canned();
break;
case 'doadd':
$this->do_add();
break;
case 'doedit':
$this->do_edit();
break;
case 'dodel':
$this->do_delete();
break;
default:
$this->list_canned();
break;
}
}
#=======================================
# @ List Canned
# Show a list of canned replies.
#=======================================
function list_canned($error='', $alert='')
{
#=============================
# Grab Canned Replies
#=============================
// Filter?
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'canned',
) );
$this->ifthd->core->db->execute();
$canned_rows = ""; // Initialize for Security
$row_count = 0; // Initialize for Security
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $c = $this->ifthd->core->db->fetch_row() )
{
$row_count ++;
( $row_count & 1 ) ? $row_class = 'option1-med' : $row_class = 'option2-med';
#=============================
# Fix Up Information
#=============================
$c['description'] = $this->ifthd->shorten_str( $c['description'], 80, 1 );
$canned_rows .= "
| {$c['id']} |
{$c['name']} |
{$c['description']} |
 |
 |
";
}
}
else
{
$canned_rows .= "
| There are no canned replies to display. |
";
}
#=============================
# Do Output
#=============================
if ( $error )
{
$error = "{$error}
";
}
elseif ( $alert )
{
$error = "{$alert}
";
}
$this->output = "
{$error}
Canned Replies List
| ID |
Name |
Description |
Edit |
Delete |
". $canned_rows ."
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Management",
"Canned Replies",
"List Canned Rplies",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Canned Replies' ) );
}
#=======================================
# @ Add Canned
# Show add canned reply form.
#=======================================
function add_canned($error="")
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['manage_canned_add'] )
{
$this->ifthd->skin->error('no_perm');
}
#=============================
# Do Output
#=============================
if ( $error )
{
$error = "{$error}
";
}
$this->output = "";
if ( $this->ifthd->member['use_rte'] && $this->ifthd->core->cache['config']['enable_ticket_rte'] )
{
$this->output .= "
";
}
$this->output .= "{$error}
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Management",
"Canned Replies",
"Add Canned Reply",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Canned Replies' ) );
}
#=======================================
# @ Edit Canned
# Show edit canned reply form.
#=======================================
function edit_canned($error="")
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['manage_canned_edit'] )
{
$this->ifthd->skin->error('no_perm');
}
#=============================
# Security Checks
#=============================
$this->ifthd->input['id'] = intval( $this->ifthd->input['id'] );
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'canned',
'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_canned');
}
$c = $this->ifthd->core->db->fetch_row();
#=============================
# Do Output
#=============================
if ( $error )
{
$error = "{$error}
";
$name = $this->ifthd->input['name'];
$description = $this->ifthd->input['description'];
$message = $this->ifthd->input['message'];
}
else
{
$name = $c['name'];
$description = $c['description'];
$message = $c['content'];
}
$this->output = "";
if ( $this->ifthd->member['use_rte'] && $this->ifthd->core->cache['config']['enable_ticket_rte'] )
{
$this->output .= "
";
}
$this->output .= "{$error}
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Management",
"Canned Replies",
"Edit Canned Reply",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Canned Replies' ) );
}
#=======================================
# @ Get Canned
# Show get canned reply for AJAX.
#=======================================
function get_canned()
{
#=============================
# Get Canned Reply
#=============================
$this->ifthd->input['id'] = intval( $this->ifthd->input['id'] );
$this->ifthd->core->db->construct( array(
'select' => array( 'content' ),
'from' => 'canned',
'where' => array( 'id', '=', $this->ifthd->input['id'] ),
'limit' => array( 0, 1 ),
) );
$this->ifthd->core->db->execute();
if ( $this->ifthd->core->db->get_num_rows() )
{
$c = $this->ifthd->core->db->fetch_row();
}
if ( $this->ifthd->core->cache['config']['enable_ticket_rte'] )
{
print $this->ifthd->prepare_output( $c['content'], 0, 1 );
}
else
{
print $c['content'];
}
exit();
}
#=======================================
# @ Do Add Canned
# Create a new canned reply.
#=======================================
function do_add()
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['manage_canned_add'] )
{
$this->ifthd->skin->error('no_perm');
}
if ( ! $this->ifthd->input['name'] )
{
$this->add_canned('Please enter a name.');
}
if ( ! $this->ifthd->input['description'] )
{
$this->add_canned('Please enter a description.');
}
$this->ifthd->input['message'] = $this->ifthd->remove_extra_lbs( $this->ifthd->input['message'] );
if ( ! $this->ifthd->input['message'] )
{
$this->add_canned('Please enter a message.');
}
#=============================
# Add Article
#=============================
$db_array = array(
'name' => $this->ifthd->input['name'],
'description' => $this->ifthd->input['description'],
'content' => $this->ifthd->input['message'],
);
$this->ifthd->core->db->construct( array(
'insert' => 'canned',
'set' => $db_array,
) );
$this->ifthd->core->db->execute();
$canned_id = $this->ifthd->core->db->get_insert_id();
$this->ifthd->log( 'admin', "Canned Reply Added '". $this->ifthd->input['name'] ."'", 1, $canned_id );
#=============================
# Rebuild Cache
#=============================
$this->ifthd->rebuild_canned_cache();
#=============================
# Redirect
#=============================
#$this->ifthd->skin->redirect( '?section=manage&act=canned&code=list', 'add_canned_success' );
$this->list_canned( '', 'The canned reply has been successfully added.' );
}
#=======================================
# @ Do Edit Canned
# Edit a canned reply.
#=======================================
function do_edit()
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['manage_canned_edit'] )
{
$this->ifthd->skin->error('no_perm');
}
$this->ifthd->input['id'] = intval( $this->ifthd->input['id'] );
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'canned',
'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_canned');
}
$c = $this->ifthd->core->db->fetch_row();
if ( ! $this->ifthd->input['name'] )
{
$this->edit_canned('Please enter a name.');
}
if ( ! $this->ifthd->input['description'] )
{
$this->edit_canned('Please enter a description.');
}
$this->ifthd->input['message'] = $this->ifthd->remove_extra_lbs( $this->ifthd->input['message'] );
if ( ! $this->ifthd->input['message'] )
{
$this->edit_canned('Please enter a message.}');
}
#=============================
# Edit Canned Reply
#=============================
$db_array = array(
'name' => $this->ifthd->input['name'],
'description' => $this->ifthd->input['description'],
'content' => $this->ifthd->input['message'],
);
$this->ifthd->core->db->construct( array(
'update' => 'canned',
'set' => $db_array,
'where' => array( 'id', '=', $c['id'] ),
) );
$this->ifthd->core->db->execute();
$this->ifthd->log( 'admin', "Canned Reply Updated '". $this->ifthd->input['name'] ."'", 1, $c['id'] );
#=============================
# Rebuild Cache
#=============================
$this->ifthd->rebuild_canned_cache();
#=============================
# Redirect
#=============================
#$this->ifthd->skin->redirect( '?section=manage&act=canned&code=list', 'edit_canned_success' );
$this->list_canned( '', 'The canned reply has been successfully updated.' );
}
#=======================================
# @ Do Delete Canned
# Delete a canned reply.
#=======================================
function do_delete()
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['manage_canned_delete'] )
{
$this->ifthd->skin->error('no_perm');
}
$this->ifthd->input['id'] = intval( $this->ifthd->input['id'] );
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'canned',
'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_canned');
}
$c = $this->ifthd->core->db->fetch_row();
#=============================
# DELETE
#=============================
$this->ifthd->core->db->construct( array(
'delete' => 'canned',
'where' => array( 'id', '=', $c['id'] ),
'limit' => array( 1 ),
) );
$this->ifthd->core->db->execute();
$this->ifthd->log( 'admin', "Canned Reply Deleted '". $c['name'] ."'", 2, $c['id'] );
#=============================
# Rebuild Cache
#=============================
$this->ifthd->rebuild_canned_cache();
#=============================
# Redirect
#=============================
#$this->ifthd->skin->redirect( '?section=manage&act=canned&code=list', 'delete_canned_success' );
$this->list_canned( 'The canned reply has been successfully deleted.' );
}
}
?>