{include file="header.tpl.html" extra_title="Stalled Issues Report"}
<br />
<form method="post" action="{$smarty.server.PHP_SELF}" name="recent_activity">
<input type="hidden" name="cat" value="generate">
<table bgcolor="{$cell_color}" border="0" cellspacing="0" cellpadding="1" align="center" width="400">
  <tr>
    <td>
      <table bgcolor="#FFFFFF" width="100%" cellspacing="1" cellpadding="2" border="0">
        <tr>
          <td bgcolor="{$cell_color}" colspan="4" class="default_white">
            <b>Stalled Issues Report</b>
          </td>
        </tr>
        <tr id="start_row">
          <td width="40%" class="default" align="center" nowrap colspan="2">
            <b>Show Issues with no Response Between</b>
          </td>
        </tr>
        <tr id="start_row">
          <td width="600%" nowrap colspan="2" align="center">
            {html_select_date time=$after_date prefix="" field_array="after" start_year="-2" end_year="+1" field_order="YMD" month_format="%b" all_extra="class='default'"}
             <span class="default"> and </span>
            {html_select_date time=$before_date prefix="" field_array="before" start_year="-2" end_year="+1" field_order="YMD" month_format="%b" all_extra="class='default'"}
          </td>
        </tr>
        <tr>
          <td width="30%" class="default" align="center">
            <b>Developers:</b>
          </td>
          <td width="70%">
            <select class="default" name="developers[]" multiple size="5" style="width: 100%">
                {html_options options=$users selected=$developers}
            </select>
          </td>
        </tr>
        <tr>
          <td width="30%" class="default" align="center">
            <b>Status:</b>
          </td>
          <td width="70%">
            <select class="default" name="status[]" multiple size="5" style="width: 100%">
                {html_options options=$status_list selected=$status}
            </select>
          </td>
        </tr>
        <tr>
          <td class="default" align="center">
            <b>Sort Order:</b>
          </td>
          <td>
            <select class="default" name="sort_order" style="width: 100%">
                <option value="ASC" label="Ascending" {if $smarty.request.sort_order != 'DESC'}selected{/if}>Ascending</option>
                <option value="DESC" label="Descending" {if $smarty.request.sort_order == 'DESC'}selected{/if}>Descending</option>
            </select>
          </td>
        </tr>
        <tr>
          <td align="center" colspan="2">
            <input type="submit" value="Generate" class="shortcut">
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</form>

{foreach key=user_full_name item=assigned_issues from=$data}
<h4>{$user_full_name|escape:"html"}</h4>
<table width="100%" bgcolor="{$cell_color}" border="0" cellspacing="0" cellpadding="1" align="center">
  <tr>
    <td>
      <table bgcolor="#FFFFFF" width="100%" cellspacing="1" cellpadding="2" border="0">
        <tr bgcolor="{$cell_color}">
          <td rowspan="2" align="center" class="default_white">Issue ID</td>
          <td rowspan="2" align="center" class="default_white">Summary</td>
          <td rowspan="2" align="center" class="default_white">Status</td>
          <td rowspan="2" align="center" class="default_white">Time Spent</td>
          <td rowspan="2" align="center" class="default_white">Created</td>
          <td rowspan="2" align="center" class="default_white">Last Response</td>
          <td colspan="2" align="center" class="default_white">Days and Hours Since</td>
        </tr>
        <tr bgcolor="{$cell_color}">
          <td align="center" class="default_white">Last Update</td>
          <td align="center" class="default_white">Last Outgoing Msg</td>
        </tr>
        {foreach key=issue_id item=issue from=$assigned_issues}
        <tr>
          <td bgcolor="{$issue.status_color}" class="default" align="center"><a target="_top" href="{$rel_url}view.php?id={$issue_id}" class="link" title="view issue details">{$issue_id}</a></td>
          <td bgcolor="{$issue.status_color}" class="default"><a target="_top" href="{$rel_url}view.php?id={$issue_id}" class="link" title="view issue details">{$issue.iss_summary|escape:"html"}</a></td>
          <td bgcolor="{$issue.status_color}" class="default" align="center">{$issue.sta_title|escape:"html"}</td>
          <td bgcolor="{$issue.status_color}" class="default" align="center">{$issue.time_spent}</td>
          <td bgcolor="{$issue.status_color}" class="default" align="center">{$issue.iss_created_date}</td>
          <td bgcolor="{$issue.status_color}" class="default" align="center">{$issue.iss_last_response_date}</td>
          <td bgcolor="{$issue.status_color}" class="default" align="center">{$issue.last_update}</td>
          <td bgcolor="{$issue.status_color}" class="default" align="center">{$issue.last_email_response}</td>
        </tr>
        {/foreach}
      </table>
    </td>
  </tr>
</table>
<br />
{/foreach}

{include file="footer.tpl.html"}