Expected result:
http://www.site.local/traq/project?p=2&s=3
(3 is just an example, it corresponds to values in my DB)Actual result:
http://www.site.local/traq/project?ticket_status=3
HTML:
Code: Select all
<div class="search-box">
<form id="ticket_status_form" action="{U_FILTER}" method="get"><div>
<label for="ticket_status">
<strong>{L_FILTER_TICKETS}{L_COLON}</strong>
</label>
<select id="ticket_status" name="ticket_status" onchange="document.getElementById('ticket_status_form').submit()">
<option value="-1"<!-- IF STATUS_ID == -1 --> selected="selected"<!-- ENDIF -->>{L_ALL_TICKETS}</option>
<option value="0"<!-- IF STATUS_ID == 0 --> selected="selected"<!-- ENDIF -->>{L_ALL_OPEN}</option>
<option value="-2"<!-- IF STATUS_ID == -2 --> selected="selected"<!-- ENDIF -->>{L_ALL_CLOSED}</option>
<!-- IF .ticket_status -->
<!-- BEGIN ticket_status -->
<option value="{ticket_status.ID}"<!-- IF ticket_status.ID == STATUS_ID --> selected="selected"<!-- ENDIF -->>{ticket_status.NAME}</option>
<!-- END ticket_status -->
<!-- ENDIF -->
</select>
<noscript><div style="display: inline;"><input type="submit" name="submit" value="submit" class="button2" /></div></noscript>
</div></form>
</div>
Code: Select all
$project_id = $this->request->variable('p', 0);
$status_id = $this->request->variable('s', 0);
$sql = 'SELECT project_name, tracker_id
FROM ' . $this->traq_project_table . '
WHERE project_id = ' . (int) $project_id;
$result = $this->db->sql_query($sql);
while ($row = $this->db->sql_fetchrow($result))
{
$project_name = $row['project_name'];
$tracker_id = $row['tracker_id'];
}
$this->db->sql_freeresult($result);
switch ($tracker_id)
{
case '0':
$traq = 'BUG_TRAQ';
break;
case '1':
$traq = 'FEATURE_TRAQ';
break;
case '2':
$traq = 'ISSUE_TRAQ';
break;
}
$sql = 'SELECT *
FROM ' . $this->traq_status_table . '
WHERE tracker_id = ' . (int) $tracker_id;
$result = $this->db->sql_query($sql);
while ($row = $this->db->sql_fetchrow($result))
{
$this->template->assign_block_vars('ticket_status', array(
'ID' => $row['status_id'],
'NAME' => $row['status_name'],
));
}
$this->db->sql_freeresult($result);
$this->template->assign_vars(array(
'PROJECT_NAME' => $project_name,
'STATUS_ID' => $status_id,
'S_DISPLAY_POST_BUTTON' => $this->auth->acl_get('u_traq_post') ? true : false,
'U_FILTER' => $this->helper->route('kinerity_traq_main_controller', array('page' => 'project', 'p' => (int) $project_id, 's' => (int) $status_id)),
'U_POST_NEW_ISSUE' => ($this->auth->acl_get('u_traq_post')) ? $this->helper->route('kinerity_traq_main_controller', array('page' => 'posting', 'mode' => 'post')) : '',
));
return $this->helper->render('project_body.html', $this->user->lang($traq) . ' - ' . $project_name);