root

      if ($mode == 'le') $mode = '<=';
      if ($mode == 'gt') $mode = '>';
      if ($mode == 'eq') $mode = '=';
      $gemode = '>=';
      $lemode = '<=';
      $spminone = $sp - 1;
	  
      $sql = "SELECT * FROM $tickets_table";
      if ($type == 1) $sql = $sql." where create_date < ".$startdate." and (lastupdate > ".$startdate." OR status != '".$higheststatus."')";
      if ($type == 2) $sql = $sql." where create_date >= ".$startdate." and create_date <= ".$enddate;
      if ($type == 3) $sql = $sql." where status  = '$higheststatus' and  lastupdate >= ".$startdate." and lastupdate <= ".$enddate;
      if ($type == 4) $sql = $sql." where create_date<='$enddate' and (status!='$higheststatus' OR lastupdate >= ".$enddate.")";
      if ($type == 5 && $sp <= 4 && $mode != '>') $sql = $sql." where status='$higheststatus' and lastupdate>'$startdate' and lastupdate<'$enddate' and ((lastupdate-create_date)/$sla_period) $gemode'$spminone' and ((lastupdate-create_date)/$sla_period) $lemode'$sp'";
      if ($type == 5 && $sp <= 4 && $mode == '>') $sql = $sql." where status='$higheststatus' and lastupdate>'$startdate' and lastupdate<'$enddate' and ((lastupdate-create_date)/$sla_period) $gemode'$sp'";
      if ($type == 6 && $sp <= 4 && $mode != '>') $sql = $sql." where create_date < $enddate and (status != '$higheststatus' or lastupdate > $enddate) and (($enddate-create_date)/$sla_period) $gemode'$spminone' and (($enddate-create_date)/$sla_period) $lemode'$sp'"; 
      if ($type == 6 && $sp <= 4 && $mode == '>') $sql = $sql." where create_date < $enddate and (status != '$higheststatus' or lastupdate > $enddate) and (($enddate-create_date)/$sla_period) $gemode'$sp'";
 
      if ($priority != '') $sql = $sql." and priority = '".$priority."' ";
      if ($platform != '') $sql = $sql." and platform = '".$platform."' ";
      if ($category != '') $sql = $sql." and category = '".$category."' ";
      if ($id != '') $sql = $sql." and supporter = '".getlogonname($id)."' ";
      if ($groupid != '') $sql = $sql." and groupid = ".$groupid." ";

        switch($s){
                case ("su"):
                        $sql = $sql." order by supporter asc";
                        break;
                case ("sd"):
                        $sql = $sql." order by short asc";
                        break;
                case ("ds"):
                        $sql = $sql." order by short desc";
                        break;
                case ("ur"):
                        $sql = $sql." order by user asc";
                        break;
                case ("ru"):
                        $sql = $sql." order by user desc";
                        break;
                case ("cr"):
                        $sql = $sql." order by create_date asc";
                        break;
                case ("rc"):
                        $sql = $sql." order by create_date desc";
                        break;
                case ("id"):
                        $sql = $sql." order by id desc";
                        break;
                default:
                        $sql = $sql." order by id asc";
                        break;
        } // case
        $result = $db->query($sql);

      // show the ticket
        displayTicket($result);

} // function