Attachment 13180 Details for Bug 8943 – Bug 8943 - Add table sorting to labels - Followup - Sort pulldowns in batch export.

[patch] Bug 8943 - Add table sorting to labels - Followup - Sort pulldowns in batch export.

Bug-8943---Add-table-sorting-to-labels---Followup-.patch (text/plain), 2.51 KB, created by Kyle M Hall (khall) on 2012-11-01 16:46:31 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2012-11-01 16:46:31 UTC

Size: 2.51 KB

patch

obsolete

>From 7b35e777dce2472b6d44ce22a6e75417ea647879 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Thu, 1 Nov 2012 12:47:13 -0400
>Subject: [PATCH] Bug 8943 - Add table sorting to labels - Followup - Sort pulldowns in batch export.
>Content-Type: text/plain; charset="utf-8"
>
>---
> C4/Creators/Lib.pm    |    6 ++++--
> labels/label-print.pl |    4 ++--
> 2 files changed, 6 insertions(+), 4 deletions(-)
>
>diff --git a/C4/Creators/Lib.pm b/C4/Creators/Lib.pm
>index 0a57b59..d052427 100644
>--- a/C4/Creators/Lib.pm
>+++ b/C4/Creators/Lib.pm
>@@ -155,7 +155,8 @@ sub get_all_templates {
>     my %params = @_;
>     my @templates = ();
>     my $query = "SELECT " . ($params{'field_list'} ? $params{'field_list'} : '*') . " FROM creator_templates";
>-    $query .= ($params{'filter'} ? " WHERE $params{'filter'};" : ';');
>+    $query .= ($params{'filter'} ? " WHERE $params{'filter'} " : '');
>+    $query .= ($params{'orderby'} ? " ORDER BY $params{'orderby'} " : '');
>     my $sth = C4::Context->dbh->prepare($query);
>     $sth->execute();
>     if ($sth->err) {
>@@ -181,7 +182,8 @@ sub get_all_layouts {
>     my %params = @_;
>     my @layouts = ();
>     my $query = "SELECT " . ($params{'field_list'} ? $params{'field_list'} : '*') . " FROM creator_layouts";
>-    $query .= ($params{'filter'} ? " WHERE $params{'filter'};" : ';');
>+    $query .= ($params{'filter'} ? " WHERE $params{'filter'} " : '');
>+    $query .= ($params{'orderby'} ? " ORDER BY $params{'orderby'} " : '');
>     my $sth = C4::Context->dbh->prepare($query);
>     $sth->execute();
>     if ($sth->err) {
>diff --git a/labels/label-print.pl b/labels/label-print.pl
>index b65c7a6..dd895fb 100755
>--- a/labels/label-print.pl
>+++ b/labels/label-print.pl
>@@ -115,8 +115,8 @@ elsif ($op eq 'none') {
>     @batch_ids = map{{batch_id => $_}} @batch_ids;
>     @label_ids = map{{label_id => $_}} @label_ids;
>     @item_numbers = map{{item_number => $_}} @item_numbers;
>-    $templates = get_all_templates(field_list => 'template_id, template_code', filter => 'creator = "Labels"');
>-    $layouts = get_all_layouts(field_list => 'layout_id, layout_name', filter => 'creator = "Labels"');
>+    $templates = get_all_templates(field_list => 'template_id, template_code', filter => 'creator = "Labels"', orderby => 'template_code' );
>+    $layouts = get_all_layouts(field_list => 'layout_id, layout_name', filter => 'creator = "Labels"', orderby => 'layout_name' );
>     $output_formats = get_output_formats();
>     $template->param(
>                     batch_ids                   => \@batch_ids,
>-- 
>1.7.2.5

Actions: View | Diff | Splinter Review

Attachments on bug 8943: 12912 | 13148 | 13180 | 13299 | 15992 | 15993 | 15994 | 17079 | 17080