Hi all,
i solved my previous issues and now i need your help again :). I'm trying to add a new select dropdown in the advanced search.
At the moment I added a new dropdown menu, but now i'm finding the piece of code that i need to modify to make the query.
Could you help me?
For now i modified this piece of code (ADDED) in the tickets.inc.php
<div id='advance' style="display:<?=$basic_display?'none':'block'?>">
<form action="tickets.php" method="get">
<input type="hidden" name="a" value="search">
<table>
<tr>
<td>Query: </td><td><input type="text" id="query" name="query" value="<?=Format:($_REQUEST)?>"></td>
<td>Dept:</td>
<td><select name="dept"><option value=0>All Departments</option>
<?
//Showing only departments the user has access to...
$sql='SELECT dept_id,dept_name FROM '.DEPT_TABLE;
if(!$thisuser->isadmin())
$sql.=' WHERE dept_id IN ('.implode(',',$thisuser->getDepts()).')';
$depts= db_query($sql);
while (list($deptId,$deptName) = db_fetch_row($depts)){
$selected = ($_GET==$deptId)?'selected':''; ?>
<option value="<?=$deptId?>"<?=$selected?>><?=$deptName?></option>
<?
}?>
</select>
</td>
----------------------------ADDED--------------------------------
<td>
<select name="subject">
<option value="" selected >seleziona</option>
<option value="Amministrativo" <?=($val_motivi=='Amministrativo')?'selected':''?>>Amministrativo</option>
<option value="Appuntamento" <?=($val_motivi=='Appuntamento')?'selected':''?>>Appuntamento</option>
<option value="Esito appuntamento" <?=($val_motivi=='Esito appuntamento')?'selected':''?>>Esito appuntamento</option>
<option value="Esito nuovo appuntamento" <?=($val_motivi=='Esito nuovo appuntamento')?'selected':''?>>Esito nuovo appuntamento</option>
<option value="Garanzie" <?=($val_motivi=='Garanzie')?'selected':''?>>Garanzie</option>
<option value="Garanzie polizza" <?=($val_motivi=='Garanzie polizza')?'selected':''?>>Garanzie polizza</option>
<option value="Nuovo appuntamento" <?=($val_motivi=='Nuovo appuntamento')?'selected':''?>>Nuovo appuntamento</option>
<option value="Proposta" <?=($val_motivi=='Proposta')?'selected':''?>>Proposta</option>
<option value="Reclami" <?=($val_motivi=='Reclami')?'selected':''?>>Reclami</option>
<option value="Rinnovi/riforme" <?=($val_motivi=='Rinnovi/riforme')?'selected':''?>>Rinnovi/riforme</option>
<option value="Sinistri" <?=($val_motivi=='Sinistri')?'selected':''?>>Sinistri</option>
</select>
</td>
----------------------------ADDED--------------------------------
Many Thanks,
Roberto