Changeset 273

Timestamp:

01/02/11 18:20:04 (13 years ago)

Author:

nanardon

Message:

• allow to filter rpm list in distrib/

Location:

server/trunk/web

Files:

• lib/Sophie/Controller/Distrib.pm (modified) (3 diffs)
• lib/Sophie/Controller/Search/Rpms.pm (modified) (2 diffs)
• root/templates/html/distrib/list_rpms.html (modified) (1 diff)
• root/templates/html/distrib/list_srpms.html (modified) (1 diff)
• root/templates/html/distrib/media_list_rpms.html (modified) (1 diff)

server/trunk/web/lib/Sophie/Controller/Distrib.pm

@@ -321 +321 @@
     }
 
-    @{$c->stash->{rpm}} = map {
-            { 
-              pkgid => $_->pkgid,
-              filename => $_->filename,
-            }
-        }
-        $c->forward('distrib_rs', [ $distribution ])
-        ->search_related('MediasPaths')
-        ->search_related('Paths')
-        ->search_related('Rpmfiles', {}, { order_by => qw(filename) })
-        ->all;
+    $c->stash->{rpm} = [ map {
+        {
+        pkgid => $_->pkgid,
+        filename => $_->filename,
+        }
+        } $c->forward('/search/rpms/rpms_rs', [ $distribution ])
+        ->search(
+            {
+                $c->req->param('fl')
+                    ? ( filename => { ILIKE => $c->req->param('fl') . '%' } )
+                    : (),
+            }, { order_by => [ qw(filename) ] })
+        ->all ];
 
     $c->stash->{xmlrpc} = $c->stash->{rpm};
@@ -371 +373 @@
     }
 
+    $distribution->{src} = 0;
+
     $c->stash->{rpm} = [ map {
-            { 
-              pkgid => $_->pkgid,
-              filename => $_->filename,
-            }
-        }
-        $c->forward('distrib_rs', [ $distribution ])
-        ->search_related('MediasPaths')
-        ->search_related('Paths')
-        ->search_related('Rpmfiles', {
-            pkgid => {
-                IN => $c->model('Base')->resultset('Rpms')
-                ->search({ issrc => 'false' })->get_column('pkgid') ->as_query }
-        },
-        { order_by => [ qw(filename) ] }
-        )->all ];
+        {
+        pkgid => $_->pkgid,
+        filename => $_->filename,
+        }
+        } $c->forward('/search/rpms/rpms_rs', [ $distribution ])
+        ->search(
+            {
+                $c->req->param('fl')
+                    ? ( filename => { ILIKE => $c->req->param('fl') . '%' } )
+                    : (),
+            }, { order_by => [ qw(filename) ] })
+        ->all ];
 
     $c->stash->{xmlrpc} = $c->stash->{rpm};
@@ -426 +427 @@
     }
 
-    @{$c->stash->{rpm}} = map {
-            { 
-              pkgid => $_->pkgid,
-              filename => $_->filename,
-            }
-        }
-        $c->forward('distrib_rs', [ $distribution ])
-        ->search_related('MediasPaths')
-        ->search_related('Paths')
-        ->search_related('Rpmfiles', {
-            pkgid => {
-                IN => $c->model('Base')->resultset('Rpms')
-                ->search({ issrc => 'true' })->get_column('pkgid') ->as_query }
-        },
-        { order_by => [ qw(filename) ] }
-        )->all;
+    $distribution->{src} = 1;
+
+    $c->stash->{rpm} = [ map {
+        {
+        pkgid => $_->pkgid,
+        filename => $_->filename,
+        }
+        } $c->forward('/search/rpms/rpms_rs', [ $distribution ])
+        ->search(
+            {
+                $c->req->param('fl')
+                    ? ( filename => { ILIKE => $c->req->param('fl') . '%' } )
+                    : (),
+            }, { order_by => [ qw(filename) ] })
+        ->all ];
 
     $c->stash->{xmlrpc} = $c->stash->{rpm};

server/trunk/web/lib/Sophie/Controller/Search/Rpms.pm

@@ -55 +55 @@
                 select => [qw(filename pkgid name shortname version arch label) ],
                 as => [qw(filename pkgid distribution dist release arch media) ],
-                rows => $searchspec->{rows} || 10000,
+                rows => $searchspec->{rows} || 30000,
                 order_by => [ 'Rpmfiles.added desc' ],
             },
@@ -173 +173 @@
 
     $c->stash->{rs} =
-        $c->forward('rpms_rs')->search(
+        $c->forward('rpms_rs', [ $searchspec ])->search(
         {
             filename => { LIKE => $file },

server/trunk/web/root/templates/html/distrib/list_rpms.html

@@ -1 +1 @@
 <!-- $Id$ -->
 
+<div Id="sophie_body_main">
+<form action="[% c.uri_for('/', c.req.path) %]" method="POST">
+    <label for="fl">Filter to filename starting by:</label>
+    <input type="text" id="fl" name="fl" value="[% c.req.param('fl') | html %]">
+</form>
+[% c.prototype.observe_field(
+    'fl',
+    {
+    url => c.uri_for('/', c.req.path, { ajax => 1 }),
+    frequency => 2,
+    update => 'rpms_list',
+    with => '"ajax=1&fl=" + value',
+    }
+) %]
+
+<div id="rpms_list">
 [% INCLUDE 'distrib/list_rpms.tt' %]
+</div>
+</div>

server/trunk/web/root/templates/html/distrib/list_srpms.html

@@ -1 +1 @@
 <!-- $Id$ -->
 
+<div Id="sophie_body_main">
+<form action="[% c.uri_for('/', c.req.path) %]" method="POST">
+    <label for="fl">Filter to filename starting by:</label>
+    <input type="text" id="fl" name="fl" value="[% c.req.param('fl') | html %]">
+</form>
+[% c.prototype.observe_field(
+    'fl',
+    {
+    url => c.uri_for('/', c.req.path, { ajax => 1 }),
+    frequency => 2,
+    update => 'rpms_list',
+    with => '"ajax=1&fl=" + value',
+    }
+) %]
+
+<div id="rpms_list">
 [% INCLUDE 'distrib/list_srpms.tt' %]
+</div>
+</div>

server/trunk/web/root/templates/html/distrib/media_list_rpms.html

@@ -1 +1 @@
 <!-- $Id$ -->
+
 <div Id="sophie_body_main">
+<form action="[% c.uri_for('/', c.req.path) %]" method="POST">
+    <label for="fl">Filter to filename starting by:</label>
+    <input type="text" id="fl" name="fl" value="[% c.req.param('fl') | html %]">
+</form>
+[% c.prototype.observe_field(
+    'fl',
+    {
+    url => c.uri_for('/', c.req.path, { ajax => 1 }),
+    frequency => 2,
+    update => 'rpms_list',
+    with => '"ajax=1&fl=" + value',
+    }
+) %]
+
+<div id="rpms_list">
 [% INCLUDE 'distrib/media_list_rpms.tt' %]
+</div>
 </div>