Attachment 33990 Details for Bug 11814 – Bug 11814 - Use constants to describe statuses

[patch] Bug 11814 - Use constants to describe statuses

0001-Bug-11814-Use-constants-to-describe-statuses.patch (text/plain), 3.50 KB, created by Paola Rossi on 2014-11-27 11:19:48 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Paola Rossi

Created: 2014-11-27 11:19:48 UTC

Size: 3.50 KB

patch

obsolete

>From 16bfd54f9d41383108fddc6e5e35790bf1443c24 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Fri, 21 Feb 2014 09:19:09 -0500
>Subject: [PATCH 1/3] Bug 11814 - Use constants to describe statuses
>
>Make the code a bit more understandable by using constants to define
>the status values and reference those. Adds self-documentation.
>
>Signed-off-by: Paola Rossi <paola.rossi@cineca.it>
>---
> C4/Serials.pm |   33 +++++++++++++++++++++++++++++----
> 1 file changed, 29 insertions(+), 4 deletions(-)
>
>diff --git a/C4/Serials.pm b/C4/Serials.pm
>index d127066..9c21897 100644
>--- a/C4/Serials.pm
>+++ b/C4/Serials.pm
>@@ -34,6 +34,29 @@ use C4::Serials::Numberpattern;
> 
> use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
> 
>+# Define statuses
>+use constant {
>+    EXPECTED               => 1,
>+    ARRIVED                => 2,
>+    LATE                   => 3,
>+    MISSING                => 4,
>+    MISSING_NEVER_RECIEVED => 41,
>+    MISSING_SOLD_OUT       => 42,
>+    MISSING_DAMAGED        => 43,
>+    MISSING_LOST           => 44,
>+    NOT_ISSUED             => 5,
>+    DELETED                => 6,
>+    CLAIMED                => 7,
>+    STOPPED                => 8,
>+};
>+
>+use constant MISSING_STATUSES => (
>+    MISSING,          MISSING_NEVER_RECIEVED,
>+    MISSING_SOLD_OUT, MISSING_DAMAGED,
>+    MISSING_LOST
>+);
>+
>+
> BEGIN {
>     $VERSION = 3.07.00.049;    # set version for version checking
>     require Exporter;
>@@ -95,6 +118,7 @@ the array is in name order
> 
> sub GetSuppliersWithLateIssues {
>     my $dbh   = C4::Context->dbh;
>+    my $statuses = join(',', ( LATE, MISSING_STATUSES, CLAIMED ) );
>     my $query = qq|
>     SELECT DISTINCT id, name
>     FROM            subscription
>@@ -103,7 +127,7 @@ sub GetSuppliersWithLateIssues {
>     WHERE id > 0
>         AND (
>             (planneddate < now() AND serial.status=1)
>-            OR serial.STATUS IN (3, 4, 41, 42, 43, 44, 7)
>+            OR serial.STATUS IN ( $statuses )
>         )
>         AND subscription.closed = 0
>     ORDER BY name|;
>@@ -430,7 +454,7 @@ sub PrepareSerialsData {
>             }
>         }
>         $subs->{ "status" . $subs->{'status'} } = 1;
>-        if ( grep { $_ == $subs->{status} } qw( 1 3 4 41 42 43 44 7 ) ) {
>+        if ( grep { $_ == $subs->{status} } ( EXPECTED, LATE, MISSING_STATUSES, CLAIMED ) ) {
>             $subs->{"checked"} = 1;
>         }
> 
>@@ -772,9 +796,10 @@ sub GetSerials {
>     my $counter = 0;
>     $count = 5 unless ($count);
>     my @serials;
>+    my $statuses = join( ',', ( ARRIVED, MISSING_STATUSES, NOT_ISSUED ) );
>     my $query = "SELECT serialid,serialseq, status, publisheddate, planneddate,notes, routingnotes
>                         FROM   serial
>-                        WHERE  subscriptionid = ? AND status NOT IN (2, 4, 41, 42, 43, 44, 5)
>+                        WHERE  subscriptionid = ? AND status NOT IN ( $statuses )
>                         ORDER BY IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC";
>     my $sth = $dbh->prepare($query);
>     $sth->execute($subscriptionid);
>@@ -795,7 +820,7 @@ sub GetSerials {
>     $query = "SELECT   serialid,serialseq, status, planneddate, publisheddate,notes, routingnotes
>        FROM     serial
>        WHERE    subscriptionid = ?
>-       AND      (status in (2, 4, 41, 42, 43, 44, 5))
>+       AND      status IN ( $statuses )
>        ORDER BY IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC
>       ";
>     $sth = $dbh->prepare($query);
>-- 
>1.7.10.4
>

Actions: View | Diff | Splinter Review

Attachments on bug 11814: 25541 | 25542 | 27605 | 33512 | 33513 | 33514 | 33552 | 33890 | 33990 | 33991 | 33992 | 34550 | 34563 | 34564 | 34565 | 34566 | 34567 | 34568 | 34569 | 34570