View | Details | Raw Unified | Return to bug 30144
Collapse All | Expand All

(-)a/installer/data/mysql/en/mandatory/auth_values.yml (+171 lines)
Lines 5739-5741 tables: Link Here
5739
          authorised_value: "770"
5739
          authorised_value: "770"
5740
          lib: "Writer of accompanying material"
5740
          lib: "Writer of accompanying material"
5741
          lib_opac: "Writer of accompanying material"
5741
          lib_opac: "Writer of accompanying material"
5742
5743
        # EDItEUR List 3B - Servicing instruction codes for EDIFACT
5744
        - category: "EDIFACT_SI"
5745
          authorised_value: "BB"
5746
          lib: "Barcode labelling"
5747
          lib_opac: "Barcode labelling"
5748
5749
        - category: "EDIFACT_SI"
5750
          authorised_value: "BBN"
5751
          lib: "Do not apply barcode labels"
5752
          lib_opac: "Do not apply barcode labels"
5753
5754
        - category: "EDIFACT_SI"
5755
          authorised_value: "BC"
5756
          lib: "Classification"
5757
          lib_opac: "Classification"
5758
5759
        - category: "EDIFACT_SI"
5760
          authorised_value: "BCN"
5761
          lib: "Do not classify"
5762
          lib_opac: "Do not classify"
5763
5764
        - category: "EDIFACT_SI"
5765
          authorised_value: "BI"
5766
          lib: "Binding: binding, reinforcing, laminating"
5767
          lib_opac: "Binding: binding, reinforcing, laminating"
5768
5769
        - category: "EDIFACT_SI"
5770
          authorised_value: "BIN"
5771
          lib: "Do not apply normal binding"
5772
          lib_opac: "Do not apply normal binding"
5773
5774
        - category: "EDIFACT_SI"
5775
          authorised_value: "BJ"
5776
          lib: "Sleeving: jackets, sleeves, wallets"
5777
          lib_opac: "Sleeving: jackets, sleeves, wallets"
5778
5779
        - category: "EDIFACT_SI"
5780
          authorised_value: "BJN"
5781
          lib: "Do not supply normal sleeving"
5782
          lib_opac: "Do not supply normal sleeving"
5783
5784
        - category: "EDIFACT_SI"
5785
          authorised_value: "BP"
5786
          lib: "Audio/CD-ROM packaging: special pouches"
5787
          lib_opac: "Audio/CD-ROM packaging: special pouches"
5788
5789
        - category: "EDIFACT_SI"
5790
          authorised_value: "BPN"
5791
          lib: "Do not supply normal audio/CD-ROM packaging"
5792
          lib_opac: "Do not supply normal audio/CD-ROM packaging"
5793
5794
        - category: "EDIFACT_SI"
5795
          authorised_value: "BS"
5796
          lib: "Security fitting: triggers, Knogo labels"
5797
          lib_opac: "Security fitting: triggers, Knogo labels"
5798
5799
        - category: "EDIFACT_SI"
5800
          authorised_value: "BSN"
5801
          lib: "Do not apply usual security fitting"
5802
          lib_opac: "Do not apply usual security fitting"
5803
5804
        - category: "EDIFACT_SI"
5805
          authorised_value: "CA"
5806
          lib: "Cataloguing: catalogue record supply"
5807
          lib_opac: "Cataloguing: catalogue record supply"
5808
5809
        - category: "EDIFACT_SI"
5810
          authorised_value: "CAN"
5811
          lib: "Do not supply catalogue record"
5812
          lib_opac: "Do not supply catalogue record"
5813
5814
        - category: "EDIFACT_SI"
5815
          authorised_value: "JK"
5816
          lib: "Plastic wallet on paperback"
5817
          lib_opac: "Plastic wallet on paperback"
5818
5819
        - category: "EDIFACT_SI"
5820
          authorised_value: "JKN"
5821
          lib: "Do not supply plastic wallet"
5822
          lib_opac: "Do not supply plastic wallet"
5823
5824
        - category: "EDIFACT_SI"
5825
          authorised_value: "KA"
5826
          lib: "Kapco: thick laminate film on paperback"
5827
          lib_opac: "Kapco: thick laminate film on paperback"
5828
5829
        - category: "EDIFACT_SI"
5830
          authorised_value: "KAN"
5831
          lib: "Do not apply Kapco"
5832
          lib_opac: "Do not apply Kapco"
5833
5834
        - category: "EDIFACT_SI"
5835
          authorised_value: "LA"
5836
          lib: "Thin laminate film on paperback"
5837
          lib_opac: "Thin laminate film on paperback"
5838
5839
        - category: "EDIFACT_SI"
5840
          authorised_value: "LAN"
5841
          lib: "Do not laminate"
5842
          lib_opac: "Do not laminate"
5843
5844
        - category: "EDIFACT_SI"
5845
          authorised_value: "RE"
5846
          lib: "Reinforcement of hardback"
5847
          lib_opac: "Reinforcement of hardback"
5848
5849
        - category: "EDIFACT_SI"
5850
          authorised_value: "REN"
5851
          lib: "Do not reinforce hardback"
5852
          lib_opac: "Do not reinforce hardback"
5853
5854
        - category: "EDIFACT_SI"
5855
          authorised_value: "RP"
5856
          lib: "Reinforcement of paperback"
5857
          lib_opac: "Reinforcement of paperback"
5858
5859
        - category: "EDIFACT_SI"
5860
          authorised_value: "RPN"
5861
          lib: "Do not reinforce paperback"
5862
          lib_opac: "Do not reinforce paperback"
5863
5864
        - category: "EDIFACT_SI"
5865
          authorised_value: "SF"
5866
          lib: "Sewn flexi"
5867
          lib_opac: "Sewn flexi"
5868
5869
        - category: "EDIFACT_SI"
5870
          authorised_value: "SFN"
5871
          lib: "Do not sew"
5872
          lib_opac: "Do not sew"
5873
5874
        - category: "EDIFACT_SI"
5875
          authorised_value: "SL"
5876
          lib: "Plastic sleeve on hardback"
5877
          lib_opac: "Plastic sleeve on hardback"
5878
5879
        - category: "EDIFACT_SI"
5880
          authorised_value: "SLN"
5881
          lib: "Do not sleeve plastic on hardback"
5882
          lib_opac: "Do not sleeve plastic on hardback"
5883
5884
        - category: "EDIFACT_SI"
5885
          authorised_value: "TR"
5886
          lib: "Traditional case binding of paperback"
5887
          lib_opac: "Traditional case binding of paperback"
5888
5889
        - category: "EDIFACT_SI"
5890
          authorised_value: "TRN"
5891
          lib: "Do not case bind paperback"
5892
          lib_opac: "Do not case bind paperback"
5893
5894
        - category: "EDIFACT_SI"
5895
          authorised_value: "NF"
5896
          lib: "Non-standard servicing: see free text"
5897
          lib_opac: "Non-standard servicing: see free text"
5898
5899
        - category: "EDIFACT_SI"
5900
          authorised_value: "NS"
5901
          lib: "No servicing"
5902
          lib_opac: "No servicing"
5903
5904
        - category: "EDIFACT_SI"
5905
          authorised_value: "NX"
5906
          lib: "Non-standard servicing: see instructions sent outside EDI"
5907
          lib_opac: "Non-standard servicing: see instructions sent outside EDI"
5908
5909
        - category: "EDIFACT_SI"
5910
          authorised_value: "PF"
5911
          lib: "Binding as supplied by publisher"
5912
          lib_opac: "Binding as supplied by publisher"
(-)a/installer/data/mysql/mandatory/auth_val_cat.sql (+5 lines)
Lines 114-116 VALUES Link Here
114
INSERT IGNORE INTO authorised_value_categories (category_name, is_system)
114
INSERT IGNORE INTO authorised_value_categories (category_name, is_system)
115
VALUES
115
VALUES
116
    ('BOOKING_CANCELLATION', 1);
116
    ('BOOKING_CANCELLATION', 1);
117
118
-- For EDIFACT
119
INSERT IGNORE INTO authorised_value_categories (category_name, is_system)
120
VALUES
121
    ('EDIFACT_SI', 0);
(-)a/t/db_dependent/Koha/EDI.t (-14 / +1 lines)
Lines 1990-2008 subtest 'servicing_instructions_quote_processing' => sub { Link Here
1990
        );
1990
        );
1991
    }
1991
    }
1992
1992
1993
    # Add EDIFACT_SI authorized values for servicing instruction codes
1993
    # EDIFACT_SI authorized values are expected to exist from database defaults
1994
    for my $code ( [ 'BB', 'Barcode labelling' ], [ 'BI', 'Binding' ], [ 'BJ', 'Sleeving' ] ) {
1995
        $builder->build(
1996
            {
1997
                source => 'AuthorisedValue',
1998
                value  => {
1999
                    category         => 'EDIFACT_SI',
2000
                    authorised_value => $code->[0],
2001
                    lib              => $code->[1]
2002
                }
2003
            }
2004
        );
2005
    }
2006
1994
2007
    my $filename = 'QUOTES_SERVICING.CEQ';
1995
    my $filename = 'QUOTES_SERVICING.CEQ';
2008
    ok( -e $dirname . $filename, 'File QUOTES_SERVICING.CEQ found' );
1996
    ok( -e $dirname . $filename, 'File QUOTES_SERVICING.CEQ found' );
2009
- 

Return to bug 30144