-
Jared Hancock authored
*This is a major redesign / rework of the osTicket base* This patch drops the concept of static ticket metadata and allows for an admin-configurable arbitrary data that is attachable to tickets The system is architected such that the base osTicket install now comes with a "default" form that has fields for subject, name, email, and phone number. This form is editable to allow for the addition of arbitrary other fields; however, the basic fields must remain in order to be associated with a help-topic and attached to a ticket. This concept can be expanded to allow for arbitrary data associated with registered clients or ticket thread items. Forms are comprised of sections. Sections have a title and instructions properties and a list of fields. Fields have various implementations to represent different data such as text, long answer, phone number, datetime, yes/no, and selections, and are configurable to define the look and feel and interpretation of the respective form field. Dropdown lists are represented as "Dynamic Lists", which are admin-configurable lists of items. Dropdowns can be optionally represented as Bootstrap typeahead fields. This also adds the start of a simple ORM which will hopefully be expanded in the future to support multiple database platforms. Currently, only MySQL is implemented.
9e75169e
dynamic-forms.inc.php 1.31 KiB
<div style="width:700;padding-top:5px; float:left;">
<h2>Dynamic Forms</h2>
</div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;">
<b><a href="dynamic-forms.php?a=add" class="Icon">Add Dynamic Form</a></b></div>
<div class="clear"></div>
<?php
$page = ($_GET['p'] && is_numeric($_GET['p'])) ? $_GET['p'] : 1;
$count = DynamicFormset::objects()->count();
$pageNav = new Pagenate($count, $page, PAGE_LIMIT);
$pageNav->setURL('dynamic-lists.php');
$showing=$pageNav->showing().' dynamic forms';
?>
<table class="list" border="0" cellspacing="1" cellpadding="0" width="940">
<caption><?php echo $showing; ?></caption>
<thead>
<tr>
<th width="7"> </th>
<th>Title</th>
<th>Last Updated</th>
</tr>
</thead>
<tbody>
<?php foreach (DynamicFormset::objects()->order_by('title')
->limit($pageNav->getLimit())
->offset($pageNav->getStart()) as $form) { ?>
<tr>
<td/>
<td><a href="?id=<?php echo $form->get('id'); ?>"><?php echo $form->get('title'); ?></a></td>
<td><?php echo $form->get('updated'); ?></td>
</tr>
<?php }
?>
</tbody>
</table>
<?php
if ($count) //Show options..
echo '<div> Page:'.$pageNav->getPageLinks().' </div>';
?>