Hi,
I made MOD by adding basic and advanced search form in ViewTicket page in Staff Panel.
Open \include\staff\viewticket.inc.php, FIND:
<table width="100%" cellpadding="2" cellspacing="0" border="0">
BEFORE, ADD:
<?php
$basic_display=!isset($_REQUEST)?true;
?>
SEARCH FORM START
<div id='basic' style="display:<?php echo $basic_display?'block':'none'?>">
<form name="frmSearchSimple" id="frmSearchSimple" action="tickets.php" method="get">
<input type="hidden" name="a" value="search">
<table>
<tr>
<td><?php echo (I_S_PREM_SEARCH_FOR); ?></td>
<td><input type="text" id="query" name="query" size=30 value="<?php echo Format:($_REQUEST)?>"></td>
<td><input type="submit" name="basic_search" class="button" value="<?php echo (I_S_TK_SEARCH); ?>">
</td>
</tr>
</table>
</form>
</div>
<div id='advance' style="display:<?php echo $basic_display?'none':'block'?>">
<form name="frmSearchSimple2" id="frmSearchSimple2" action="tickets.php" method="get">
<input type="hidden" name="a" value="search">
<table>
<tr>
<td><?php echo (I_S_TK_QUERY2); ?></td><td><input type="text" id="query" name="query" value="<?php echo Format:($_REQUEST)?>"></td>
<td><?php echo (I_S_TK_DEPT); ?></td>
<td><select name="dept"><option value=0><?php echo (I_S_TK_ALL_DEPT); ?></option>
<?php
//Showing only departments the user has access to...
$depts= db_query('SELECT dept_id,dept_name FROM '.DEPT_TABLE.' WHERE dept_id IN ('.implode(',',$thisuser->getDepts()).')');
while (list($deptId,$deptName) = db_fetch_row($depts)){
$selected = ($_GET==$deptId)?'selected':''; ?>
<option value="<?php echo $deptId?>"<?php echo $selected?>><?php echo $deptName?></option>
<?php
}?>
</select>
</td>
<td><?php echo (I_S_TK_STATUS_IS); ?></td><td>
<select name="status">
<option value='any' selected ><?php echo (I_S_TK_ANY_STATUS); ?></option>
<option value="Open" <?php echo $_REQUEST =='Open'?'selected':''?>>Open</option>
<option value="Closed" <?php echo $_REQUEST=='Closed'?'selected':''?>>Closed</option>
</select>
</td>
</tr>
</table>
<div>
<?php echo (I_S_TK_DATE_SPAN); ?>
<?php echo (I_S_TK_FROM); ?> <input name="startDate" onclick="displayDatePicker('startDate');" value="<?php echo Format:($_REQUEST)?>"
autocomplete=OFF >
<img src="../images/cal.gif" id="startPick" style="cursor: pointer;" onclick="displayDatePicker('startDate');" align="absmiddle">
<?php echo (I_S_TK_TO); ?>
<input name="endDate" onclick="displayDatePicker('endDate');" value="<?php echo Format:($_REQUEST)?>" autocomplete=OFF >
<img src="../images/cal.gif" id="endPick" style="cursor: pointer;" onclick="displayDatePicker('endDate');" align="absmiddle">
</div>
<table>
<tr>
<td><?php echo (I_S_TK_SORT_BY); ?></td><td>
<?php
$sort=$_GET?$_GET:'date';
?>
<select name="sort">
<option value="ID" <?php echo $sort== 'ID' ?'selected':''?>><?php echo (I_S_TK_TICKET_NO); ?></option>
<option value="pri" <?php echo $sort == 'pri' ?'selected':''?>><?php echo (I_S_TK_PRIORITY); ?></option>
<option value="date" <?php echo $sort == 'date' ?'selected':''?>><?php echo (I_S_TK_DATE); ?></option>
<option value="dept" <?php echo $sort == 'dept' ?'selected':''?>><?php echo (I_S_TK_DEPT2); ?></option>
</select>
<select name="order">
<option value="DESC"<?php echo $_REQUEST == 'DESC' ?'selected':''?>><?php echo (I_S_TK_DESCENDING); ?></option>
<option value="ASC"<?php echo $_REQUEST == 'ASC'?'selected':''?>><?php echo (I_S_TK_ASCENDING); ?></option>
</select>
</td>
<td>Hasil per Halaman:</td><td>
<select name="limit">
<?php
$sel=$_REQUEST?$_REQUEST;
for ($x = 5; $x <= 25; $x += 5) {?>
<option value="<?php echo $x?>" <?php echo ($sel==$x )?'selected':''?>><?php echo $x?></option>
<?php } ?>
</select>
</td>
<td>
<input type="submit" name="advance_search" class="button" value=" <?php echo (I_S_TK_SEARCH); ?> ">
</td>
</tr>
</table>
</form>
</div>
<script type="text/javascript">
var options = {
script:"ajax.php?api=tickets&f=search&limit=10&",
varname:"input",
shownoresults,
maxresults,
callback: function (obj) {
document.getElementById('query').value = obj.id;
//document.forms.submit();
document.getElementById('frmSearchSimple').submit();
}
};
var autosug = new bsn.AutoSuggest('query', options);
</script>
SEARCH FORM END
Best regards,
Masino Sinaga