The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
package App::Netdisco::Web::Plugin::Search::Port;

use Dancer ':syntax';
use Dancer::Plugin::DBIC;
use Dancer::Plugin::Auth::Extensible;

use App::Netdisco::Web::Plugin;
use App::Netdisco::Util::Web 'sql_match';

register_search_tab({ tag => 'port', label => 'Port', provides_csv => 1 });

# device ports with a description (er, name) matching
get '/ajax/content/search/port' => require_login sub {
    my $q = param('q');
    send_error('Missing query', 400) unless $q;
    my $set;

    if ($q =~ m/^\d+$/) {
        $set = schema('netdisco')->resultset('DevicePort')
          ->search({vlan => $q});
    }
    else {
        my ($likeval, $likeclause) = sql_match($q);

        $set = schema('netdisco')->resultset('DevicePort')
          ->search({-or => [
                      {name => (param('partial') ? $likeclause : $q)},
                      (length $q == 17 ? {mac => $q}
                                       : \['mac::text ILIKE ?', $likeval]),
                    ]});
    }
    return unless $set->count;

    if (request->is_ajax) {
        template 'ajax/search/port.tt', {results => $set},
          { layout => undef };
    }
    else {
        header( 'Content-Type' => 'text/comma-separated-values' );
        template 'ajax/search/port_csv.tt', {results => $set},
          { layout => undef };
    }
};

true;