<?php
|
|
//* Title of the form
|
$form["title"] = "Support Message";
|
|
//* Description of the form (optional)
|
$form["description"] = "";
|
|
//* Name of the form. The name shall not contain spaces or foreign characters
|
$form["name"] = "support_message";
|
|
//* The file that is used to call the form in the browser
|
$form["action"] = "support_message_edit.php";
|
|
//* The name of the database table that shall be used to store the data
|
$form["db_table"] = "support_message";
|
|
//* The name of the database table index field, this field must be a numeric auto increment column
|
$form["db_table_idx"] = "support_message_id";
|
|
//* Shall changes to this table be stored in the database history (sys_datalog) table.
|
//* This should be set to "yes" for all tables that store configuration information.
|
$form["db_history"] = "no"; // yes / no
|
|
//* The name of the tab that is shown when the form is opened
|
$form["tab_default"] = "message";
|
|
//* The name of the default list file of this form
|
$form["list_default"] = "support_message_list.php";
|
|
//* Use the internal authentication system for this table. This should
|
//* be set to yes in most cases
|
$form["auth"] = 'yes'; // yes / no
|
|
//* Authentication presets. The defaults below does not need to be changed in most cases.
|
$form["auth_preset"]["userid"] = 0; // 0 = id of the user, > 0 id must match with id of current user
|
$form["auth_preset"]["groupid"] = 0; // 0 = default groupid of the user, > 0 id must match with groupid of current user
|
$form["auth_preset"]["perm_user"] = 'riud'; //r = read, i = insert, u = update, d = delete
|
$form["auth_preset"]["perm_group"] = 'riud'; //r = read, i = insert, u = update, d = delete
|
$form["auth_preset"]["perm_other"] = ''; //r = read, i = insert, u = update, d = delete
|
|
|
//* Maybe we're writing in a response to another message
|
$sm_default_recipient_id = '';
|
$sm_default_subject = '';
|
if(isset($_GET['reply']))
|
{
|
$sm_msg_id = preg_replace("/[^0-9]/", "", $_GET['reply']);
|
$res = $app->db->queryOneRecord("SELECT sender_id, subject FROM support_message WHERE support_message_id=?", $sm_msg_id);
|
if($res['sender_id'])
|
{
|
$sm_default_recipient_id = $res['sender_id'];
|
$sm_default_subject = (preg_match("/^Re:/", $res['subject'])?"":"Re: ") . $res['subject'];
|
}
|
}
|
|
$authsql = $app->tform->getAuthSQL('r', 'client');
|
|
//* Begin of the form definition of the first tab. The name of the tab is called "message". We refer
|
//* to this name in the $form["tab_default"] setting above.
|
$form["tabs"]['message'] = array (
|
'title' => "Message", // Title of the Tab
|
'width' => 100, // Tab width
|
'template' => "templates/support_message_edit.htm", // Template file name
|
'fields' => array (
|
//#################################
|
// Begin Datatable fields
|
//#################################
|
'recipient_id' => array (
|
'datatype' => 'INTEGER',
|
'formtype' => 'SELECT',
|
'default' => $sm_default_recipient_id,
|
'datasource' => array ( 'type' => 'SQL',
|
'querystring' => "SELECT sys_user.userid, CONCAT(IF(client.company_name != '', CONCAT(client.company_name, ' :: '), ''), client.contact_name, ' (', client.username, IF(client.customer_no != '', CONCAT(', ', client.customer_no), ''), ')') as contactname FROM sys_user, client WHERE sys_user.userid != 1 AND sys_user.client_id = client.client_id AND $authsql ORDER BY sys_user.username",
|
'keyfield' => 'userid',
|
'valuefield' => 'contactname'
|
),
|
'validators' => array ( 0 => array ( 'type' => 'ISINT',
|
'errmsg'=> 'recipient_id_is_not_integer'),
|
),
|
'value' => ($_SESSION['s']['user']['typ'] != 'admin')?array(1 => 'Administrator'):''
|
),
|
'sender_id' => array (
|
'datatype' => 'INTEGER',
|
'formtype' => 'SELECT',
|
'default' => '',
|
'datasource' => array ( 'type' => 'SQL',
|
'querystring' => 'SELECT userid,username FROM sys_user WHERE {AUTHSQL} ORDER BY username',
|
'keyfield' => 'userid',
|
'valuefield' => 'username'
|
),
|
'validators' => array ( 0 => array ( 'type' => 'ISINT',
|
'errmsg'=> 'recipient_id_is_not_integer'),
|
),
|
'value' => ''
|
),
|
'subject' => array (
|
'datatype' => 'VARCHAR',
|
'formtype' => 'TEXT',
|
'validators' => array ( 0 => array ( 'type' => 'NOTEMPTY',
|
'errmsg'=> 'subject_is_empty'),
|
),
|
'default' => $sm_default_subject,
|
'value' => '',
|
'width' => '30',
|
'maxlength' => '255'
|
),
|
'message' => array (
|
'datatype' => 'VARCHAR',
|
'formtype' => 'TEXTAREA',
|
'validators' => array ( 0 => array ( 'type' => 'NOTEMPTY',
|
'errmsg'=> 'message_is_empty'),
|
),
|
'default' => '',
|
'value' => '',
|
'cols' => '30',
|
'rows' => '10',
|
'maxlength' => '255'
|
),
|
'tstamp' => array (
|
'datatype' => 'INTEGER',
|
'formtype' => 'TEXT',
|
'default' => time(),
|
'value' => '',
|
'width' => '30',
|
'maxlength' => '30'
|
),
|
//#################################
|
// ENDE Datatable fields
|
//#################################
|
)
|
);
|
|
|
|
?>
|
