Attachment #159323 for bug #35418

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





use Modern::Perl;

use Test::More tests => 18;

use Koha::ERM::EUsage::SushiCounter;
use Koha::Database;
use JSON           qw( decode_json );
use File::Basename qw( dirname );
use File::Slurp;


    is( $report_body[8][10], '2002',                        '1st title, 2nd yop has 6 metric types' );

    # The data is in the correct column
    is( $report_body[2][0],  'Insect Cell Culture: Fundamental and Applied Aspects', '1st column is title' );
    is( $report_body[2][1],  'Test Publisher',                                       '2nd column is publisher' );
    is( $report_body[2][2],  '',                          '3rd column heading is publisher ID' );
    is( $report_body[2][3],  'Test Platform',             '4th column is platform' );
    is( $report_body[2][4],  '10.1007/0-306-46850-6',     '5th column is DOI' );

        'Reporting period total matches the sum of all the monthly usage statistics'
    );
};

my $sushi_response_file_TR_B2      = dirname(__FILE__) . "/../../../data/erm/eusage/TR_B2.json";
my $sushi_counter_5_response_TR_B2 = decode_json( read_file($sushi_response_file_TR_B2) );
my $sushi_counter_TR_B2 = Koha::ERM::EUsage::SushiCounter->new( { response => $sushi_counter_5_response_TR_B2 } );

subtest 'TR_B2 _COUNTER_report_header' => sub {

    plan tests => 37;

    my @report_header = $sushi_counter_TR_B2->_COUNTER_report_header;

    # Header row #1 - Report_Name
    is( $report_header[0][0], 'Report_Name',        '1st row is report name' );
    is( $report_header[0][1], 'Book Access Denied', '1st row is report name' );
    is( $report_header[0][2], undef,                '1st row is report name' );

    # Header row #2 - Report_ID
    is( $report_header[1][0], 'Report_ID', '2nd row is report name' );
    is( $report_header[1][1], 'TR_B2',     '2nd row is report name' );
    is( $report_header[1][2], undef,       '2nd row is report name' );

    # Header row #3 - Release
    is( $report_header[2][0], 'Release', '3rd row is counter release' );
    is( $report_header[2][1], '5',       '3rd row is counter release' );
    is( $report_header[2][2], undef,     '3rd row is counter release' );

    # Header row #4 - Institution_Name
    is( $report_header[3][0], 'Institution_Name', '4th row is institution name' );
    is( $report_header[3][1], 'Test Institution', '4th row is institution name' );
    is( $report_header[3][2], undef,              '4th row is institution name' );

    # Header row #5 - Institution_ID
    is( $report_header[4][0], 'Institution_ID',                  '5th row is institution id' );
    is( $report_header[4][1], 'Proprietary:SN:TEST_CUSTOMER_ID', '5th row is institution id' );
    is( $report_header[4][2], undef,                             '5th row is institution id' );

    # Header row #6 - Metric_Types
    is( $report_header[5][0], 'Metric_Types', '6th row is metric types' );
    is(
        $report_header[5][1],
        'Limit_Exceeded; No_License',
        '6th row is metric types'
    );
    is( $report_header[5][2], undef, '6th row is metric types' );

    # Header row #7 - Report_Filters
    is( $report_header[6][0], 'Report_Filters', '7th row is report filters' );
    is(
        $report_header[6][1],
        'Data_Type:Book; Access_Method:Regular; Metric_Type:Limit_Exceeded|No_License; Begin_Date:2022-11-01; End_Date:2022-12-31',
        '7th row is report filters'
    );
    is( $report_header[6][2], undef, '7th row is report filters' );

    # Header row #8 - Report_Attributes
    is( $report_header[7][0], 'Report_Attributes', '8th row is report attributes' );
    is( $report_header[7][1], '',                  '8th row is report attributes' );
    is( $report_header[7][2], undef,               '8th row is report attributes' );

    # Header row #9 - Exceptions
    is( $report_header[8][0], 'Exceptions', '9th row is exceptions' );
    is( $report_header[8][1], '',           '9th row is exceptions' );
    is( $report_header[8][2], undef,        '9th row is exceptions' );

    # Header row #10 - Reporting_Period
    is( $report_header[9][0], 'Reporting_Period',                           '10th row is reporting period' );
    is( $report_header[9][1], 'Begin_Date=2022-11-01; End_Date=2022-12-31', '10th row is reporting period' );
    is( $report_header[9][2], undef,                                        '10th row is reporting period' );

    # Header row #11 - Created
    is( $report_header[10][0], 'Created',              '11th row is created' );
    is( $report_header[10][1], '2023-11-28T12:53:04Z', '11th row is created' );
    is( $report_header[10][2], undef,                  '11th row is created' );

    # Header row #12 - Created
    is( $report_header[11][0], 'Created_By',        '12th row is created by' );
    is( $report_header[11][1], 'Test Systems Inc.', '12th row is created by' );
    is( $report_header[11][2], undef,               '12th row is created by' );

    # Header row #13 - This needs to be empty
    is( $report_header[12][0], '', '13th row is empty' );
};

subtest 'TR_B2 _COUNTER_report_column_headings' => sub {

    plan tests => 16;

    my @report_column_headings = $sushi_counter_TR_B2->_COUNTER_report_column_headings;

    # Standard TR_J4 column headings
    is( $report_column_headings[0][0],  'Title',                  '1st column heading is title' );
    is( $report_column_headings[0][1],  'Publisher',              '2nd column heading is publisher' );
    is( $report_column_headings[0][2],  'Publisher_ID',           '3rd column heading is publisher ID' );
    is( $report_column_headings[0][3],  'Platform',               '4th column heading is platform' );
    is( $report_column_headings[0][4],  'DOI',                    '5th column heading is DOI' );
    is( $report_column_headings[0][5],  'Proprietary_ID',         '6th column heading is proprietary ID' );
    is( $report_column_headings[0][6],  'ISBN',                   '7th column heading is ISBN' );
    is( $report_column_headings[0][7],  'Print_ISSN',             '8th column heading is print ISSN' );
    is( $report_column_headings[0][8],  'Online_ISSN',            '9th column heading is online ISSN' );
    is( $report_column_headings[0][9],  'URI',                    '10th column heading is URI' );
    is( $report_column_headings[0][10], 'YOP',                    '11th column heading is yop' );
    is( $report_column_headings[0][11], 'Metric_Type',            '12th column heading is metric type' );
    is( $report_column_headings[0][12], 'Reporting_Period_Total', '13th column heading is reporting period total' );

    # Months column headings
    is( $report_column_headings[0][13], 'Nov 2022', '14th column is month column heading' );
    is( $report_column_headings[0][14], 'Dec 2022', '15th column is the last month column heading' );
    is( $report_column_headings[0][15], undef,      '16th column is empty, no more months' );
};

subtest 'TR_B2 _COUNTER_report_body' => sub {

    plan tests => 18;

    my @report_body = $sushi_counter_TR_B2->_COUNTER_report_body;

    # The same title is sequential but for different metric types
    is(
        $report_body[0][0], 'Handbook of Nuclear Engineering',
        'different title, only one metric type'
    );
    is(
        $report_body[1][0], 'Human Resource Management in International Firms',
        'different title, only one metric type'
    );
    is( $report_body[0][11], 'No_License', '1 rows for 1st title, metric type' );
    is( $report_body[1][11], 'No_License', '1 rows for 2nd title, metric type' );

    # The data is in the correct column
    is( $report_body[2][0],  'Understanding Disability',  '1st column is title' );
    is( $report_body[2][1],  'Test Publisher E',          '2nd column is publisher' );
    is( $report_body[2][2],  '',                          '3rd column heading is publisher ID' );
    is( $report_body[2][3],  'Test Platform',             '4th column is platform' );
    is( $report_body[2][4],  '10.1007/978-1-349-24269-6', '5th column is DOI' );
    is( $report_body[2][5],  'SN:TEST/978-1-349-24269-6', '6th column is proprietary ID' );
    is( $report_body[2][6],  '978-1-349-24269-6',         '7th column is ISBN' );
    is( $report_body[2][7],  '',                          '8th column is print ISSN' );
    is( $report_body[2][8],  '',                          '9th column is online ISSN' );
    is( $report_body[2][9],  '',                          '10th column is URI' );
    is( $report_body[2][10], '1996',                      '11th column is yop' );
    is( $report_body[2][11], 'No_License',                '12th column is access type' );
    is( $report_body[2][12], 1,                           '13th column is reporting period total' );

    # The period total is the sum of all the month columns
    my $stats_total = 0;
    for ( my $i = 13 ; $i < 15 ; $i++ ) {
        $stats_total += $report_body[0][$i];
    }
    is(
        $report_body[0][13], $stats_total,
        'Reporting period total matches the sum of all the monthly usage statistics'
    );
};




{
  "Report_Header": {
    "Created": "2023-11-28T12:53:04Z",
    "Created_By": "Test Systems Inc.",
    "Customer_ID": "TEST_CUSTOMER_ID",
    "Report_ID": "TR_B2",
    "Release": "5",
    "Report_Name": "Book Access Denied",
    "Institution_Name": "Test Institution",
    "Institution_ID": [{ "Type": "Proprietary", "Value": "SN:TEST_CUSTOMER_ID" }],
    "Report_Filters": [
      { "Name": "Data_Type", "Value": "Book" },
      { "Name": "Access_Method", "Value": "Regular" },
      { "Name": "Metric_Type", "Value": "Limit_Exceeded|No_License" },
      { "Name": "Begin_Date", "Value": "2022-11-01" },
      { "Name": "End_Date", "Value": "2022-12-31" }
    ]
  },
  "Report_Items": [
    {
      "Title": "Handbook of Nuclear Engineering",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-0-387-98149-9" },
        { "Type": "ISBN", "Value": "978-0-387-98149-9" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-0-387-98149-9" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher",
      "YOP": "2010",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 3 }]
        }
      ]
    },
    {
      "Title": "Human Resource Management in International Firms",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-1-349-11255-5" },
        { "Type": "ISBN", "Value": "978-1-349-11255-5" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-1-349-11255-5" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher D",
      "YOP": "1990",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Understanding Disability",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-1-349-24269-6" },
        { "Type": "ISBN", "Value": "978-1-349-24269-6" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-1-349-24269-6" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher E",
      "YOP": "1996",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Learning from Disasters: A Management Approach",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-1-349-27902-9" },
        { "Type": "ISBN", "Value": "978-1-349-27902-9" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-1-349-27902-9" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher E",
      "YOP": "2005",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Handbook of Nuclear Chemistry",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-1-4419-0720-2" },
        { "Type": "ISBN", "Value": "978-1-4419-0720-2" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-1-4419-0720-2" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher",
      "YOP": "2011",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Compound Semiconductor Device Modelling",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-1-4471-2048-3" },
        { "Type": "ISBN", "Value": "978-1-4471-2048-3" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-1-4471-2048-3" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher F",
      "YOP": "1993",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Essentials of Carbohydrate Chemistry",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-1-4612-1622-3" },
        { "Type": "ISBN", "Value": "978-1-4612-1622-3" },
        { "Type": "Print_ISSN", "Value": "0172-6323" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-1-4612-1622-3" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher G",
      "YOP": "1998",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 6 }]
        }
      ]
    },
    {
      "Title": "Elements of Statistical Disclosure Control",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-1-4613-0121-9" },
        { "Type": "ISBN", "Value": "978-1-4613-0121-9" },
        { "Type": "Print_ISSN", "Value": "0930-0325" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-1-4613-0121-9" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher G",
      "YOP": "2001",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Seamless R and C++ Integration with Rcpp",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-1-4614-6868-4" },
        { "Type": "ISBN", "Value": "978-1-4614-6868-4" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-1-4614-6868-4" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher G",
      "YOP": "2013",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Developing Applications with Azure Active Directory",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-1-4842-5040-2" },
        { "Type": "ISBN", "Value": "978-1-4842-5040-2" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-1-4842-5040-2" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher H",
      "YOP": "2019",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Introduction to X-Ray Spectrometric Analysis",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-1-4899-2204-5" },
        { "Type": "ISBN", "Value": "978-1-4899-2204-5" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-1-4899-2204-5" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher",
      "YOP": "1978",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Gypsy and Traveller Girls",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-030-03703-1" },
        { "Type": "ISBN", "Value": "978-3-030-03703-1" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-030-03703-1" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2019",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 2 }]
        }
      ]
    },
    {
      "Title": "Ernst Mach – Life, Work, Influence",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-030-04378-0" },
        { "Type": "ISBN", "Value": "978-3-030-04378-0" },
        { "Type": "Print_ISSN", "Value": "0929-6328" },
        { "Type": "Online_ISSN", "Value": "2215-1818" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-030-04378-0" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2019",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "The Palgrave Handbook of Male Psychology and Mental Health",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-030-04384-1" },
        { "Type": "ISBN", "Value": "978-3-030-04384-1" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-030-04384-1" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2019",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Handbook of Population",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-030-10910-3" },
        { "Type": "ISBN", "Value": "978-3-030-10910-3" },
        { "Type": "Print_ISSN", "Value": "1389-6903" },
        { "Type": "Online_ISSN", "Value": "2542-839X" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-030-10910-3" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2019",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Socioeconomic Inequality and Educational Outcomes",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-030-11991-1" },
        { "Type": "ISBN", "Value": "978-3-030-11991-1" },
        { "Type": "Print_ISSN", "Value": "2366-1631" },
        { "Type": "Online_ISSN", "Value": "2366-164X" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-030-11991-1" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2019",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Feng Shui: Teaching About Science and Pseudoscience",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-030-18822-1" },
        { "Type": "ISBN", "Value": "978-3-030-18822-1" },
        { "Type": "Print_ISSN", "Value": "2520-8594" },
        { "Type": "Online_ISSN", "Value": "2520-8608" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-030-18822-1" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2019",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 2 }]
        }
      ]
    },
    {
      "Title": "Human Aspects of IT for the Aged Population. Healthy and Active Aging",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-030-50249-2" },
        { "Type": "ISBN", "Value": "978-3-030-50249-2" },
        { "Type": "Print_ISSN", "Value": "0302-9743" },
        { "Type": "Online_ISSN", "Value": "1611-3349" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-030-50249-2" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2020",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 6 }]
        }
      ]
    },
    {
      "Title": "Bayesian Compendium",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-030-55897-0" },
        { "Type": "ISBN", "Value": "978-3-030-55897-0" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-030-55897-0" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2020",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "The Science of Citizen Science",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-030-58278-4" },
        { "Type": "ISBN", "Value": "978-3-030-58278-4" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-030-58278-4" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2021",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Accessible Housing for South Asia",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-030-88881-7" },
        { "Type": "ISBN", "Value": "978-3-030-88881-7" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-030-88881-7" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2022",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Advanced Informatics for Computing Research",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-031-09469-9" },
        { "Type": "ISBN", "Value": "978-3-031-09469-9" },
        { "Type": "Print_ISSN", "Value": "1865-0929" },
        { "Type": "Online_ISSN", "Value": "1865-0937" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-031-09469-9" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2022",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 2 }]
        }
      ]
    },
    {
      "Title": "SDG 14: Life Below Water",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-031-19467-2" },
        { "Type": "ISBN", "Value": "978-3-031-19467-2" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-031-19467-2" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2023",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    },
    {
      "Title": "Transforming Rural Communities in China and Beyond",
      "Item_ID": [
        { "Type": "DOI", "Value": "10.1007/978-3-319-11319-7" },
        { "Type": "ISBN", "Value": "978-3-319-11319-7" },
        { "Type": "Proprietary", "Value": "SN:TEST/978-3-319-11319-7" }
      ],
      "Platform": "Test Platform",
      "Publisher": "Test Publisher A",
      "YOP": "2015",
      "Performance": [
        {
          "Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
          "Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
        }
      ]
    }
  ]
}

Return to bug 35418

Lines 17-27 Link Here

(-)a/t/db_dependent/Koha/ERM/EUsage/SushiCounter.t (-4 / +157 lines)
17		17
18	use Modern::Perl;	18	use Modern::Perl;
19		19
20	use Test::More tests => 15;	20	use Test::More tests => 18;
21		21
22	use Koha::ERM::EUsage::SushiCounter;	22	use Koha::ERM::EUsage::SushiCounter;
23	use Koha::Database;	23	use Koha::Database;
24	use JSON qw( decode_json );	24	use JSON qw( decode_json );
25	use File::Basename qw( dirname );	25	use File::Basename qw( dirname );
26	use File::Slurp;	26	use File::Slurp;
27		27
Lines 803-810 subtest 'TR_B3 _COUNTER_report_body' => sub { Link Here
803	is( $report_body[8][10], '2002', '1st title, 2nd yop has 6 metric types' );	803	is( $report_body[8][10], '2002', '1st title, 2nd yop has 6 metric types' );
804		804
805	# The data is in the correct column	805	# The data is in the correct column
806	is( $report_body[2][0], 'Insect Cell Culture: Fundamental and Applied Aspects', '1st column is title' );	806	is( $report_body[2][0], 'Insect Cell Culture: Fundamental and Applied Aspects', '1st column is title' );
807	is( $report_body[2][1], 'Test Publisher', '2nd column is publisher' );	807	is( $report_body[2][1], 'Test Publisher', '2nd column is publisher' );
808	is( $report_body[2][2], '', '3rd column heading is publisher ID' );	808	is( $report_body[2][2], '', '3rd column heading is publisher ID' );
809	is( $report_body[2][3], 'Test Platform', '4th column is platform' );	809	is( $report_body[2][3], 'Test Platform', '4th column is platform' );
810	is( $report_body[2][4], '10.1007/0-306-46850-6', '5th column is DOI' );	810	is( $report_body[2][4], '10.1007/0-306-46850-6', '5th column is DOI' );
Lines 828-830 subtest 'TR_B3 _COUNTER_report_body' => sub { Link Here
828	'Reporting period total matches the sum of all the monthly usage statistics'	828	'Reporting period total matches the sum of all the monthly usage statistics'
829	);	829	);
830	};	830	};
		831
		832	my $sushi_response_file_TR_B2 = dirname(__FILE__) . "/../../../data/erm/eusage/TR_B2.json";
		833	my $sushi_counter_5_response_TR_B2 = decode_json( read_file($sushi_response_file_TR_B2) );
		834	my $sushi_counter_TR_B2 = Koha::ERM::EUsage::SushiCounter->new( { response => $sushi_counter_5_response_TR_B2 } );
		835
		836	subtest 'TR_B2 _COUNTER_report_header' => sub {
		837
		838	plan tests => 37;
		839
		840	my @report_header = $sushi_counter_TR_B2->_COUNTER_report_header;
		841
		842	# Header row #1 - Report_Name
		843	is( $report_header[0][0], 'Report_Name', '1st row is report name' );
		844	is( $report_header[0][1], 'Book Access Denied', '1st row is report name' );
		845	is( $report_header[0][2], undef, '1st row is report name' );
		846
		847	# Header row #2 - Report_ID
		848	is( $report_header[1][0], 'Report_ID', '2nd row is report name' );
		849	is( $report_header[1][1], 'TR_B2', '2nd row is report name' );
		850	is( $report_header[1][2], undef, '2nd row is report name' );
		851
		852	# Header row #3 - Release
		853	is( $report_header[2][0], 'Release', '3rd row is counter release' );
		854	is( $report_header[2][1], '5', '3rd row is counter release' );
		855	is( $report_header[2][2], undef, '3rd row is counter release' );
		856
		857	# Header row #4 - Institution_Name
		858	is( $report_header[3][0], 'Institution_Name', '4th row is institution name' );
		859	is( $report_header[3][1], 'Test Institution', '4th row is institution name' );
		860	is( $report_header[3][2], undef, '4th row is institution name' );
		861
		862	# Header row #5 - Institution_ID
		863	is( $report_header[4][0], 'Institution_ID', '5th row is institution id' );
		864	is( $report_header[4][1], 'Proprietary:SN:TEST_CUSTOMER_ID', '5th row is institution id' );
		865	is( $report_header[4][2], undef, '5th row is institution id' );
		866
		867	# Header row #6 - Metric_Types
		868	is( $report_header[5][0], 'Metric_Types', '6th row is metric types' );
		869	is(
		870	$report_header[5][1],
		871	'Limit_Exceeded; No_License',
		872	'6th row is metric types'
		873	);
		874	is( $report_header[5][2], undef, '6th row is metric types' );
		875
		876	# Header row #7 - Report_Filters
		877	is( $report_header[6][0], 'Report_Filters', '7th row is report filters' );
		878	is(
		879	$report_header[6][1],
		880	'Data_Type:Book; Access_Method:Regular; Metric_Type:Limit_Exceeded\|No_License; Begin_Date:2022-11-01; End_Date:2022-12-31',
		881	'7th row is report filters'
		882	);
		883	is( $report_header[6][2], undef, '7th row is report filters' );
		884
		885	# Header row #8 - Report_Attributes
		886	is( $report_header[7][0], 'Report_Attributes', '8th row is report attributes' );
		887	is( $report_header[7][1], '', '8th row is report attributes' );
		888	is( $report_header[7][2], undef, '8th row is report attributes' );
		889
		890	# Header row #9 - Exceptions
		891	is( $report_header[8][0], 'Exceptions', '9th row is exceptions' );
		892	is( $report_header[8][1], '', '9th row is exceptions' );
		893	is( $report_header[8][2], undef, '9th row is exceptions' );
		894
895	# Header row #10 - Reporting_Period
896	is( $report_header[9][0], 'Reporting_Period', '10th row is reporting period' );
897	is( $report_header[9][1], 'Begin_Date=2022-11-01; End_Date=2022-12-31', '10th row is reporting period' );
898	is( $report_header[9][2], undef, '10th row is reporting period' );
899
900	# Header row #11 - Created
901	is( $report_header[10][0], 'Created', '11th row is created' );
902	is( $report_header[10][1], '2023-11-28T12:53:04Z', '11th row is created' );
903	is( $report_header[10][2], undef, '11th row is created' );
904
905	# Header row #12 - Created
906	is( $report_header[11][0], 'Created_By', '12th row is created by' );
907	is( $report_header[11][1], 'Test Systems Inc.', '12th row is created by' );
908	is( $report_header[11][2], undef, '12th row is created by' );
909
910	# Header row #13 - This needs to be empty
911	is( $report_header[12][0], '', '13th row is empty' );
912	};
913
914	subtest 'TR_B2 _COUNTER_report_column_headings' => sub {
915
916	plan tests => 16;
917
918	my @report_column_headings = $sushi_counter_TR_B2->_COUNTER_report_column_headings;
919
920	# Standard TR_J4 column headings
921	is( $report_column_headings[0][0], 'Title', '1st column heading is title' );
922	is( $report_column_headings[0][1], 'Publisher', '2nd column heading is publisher' );
923	is( $report_column_headings[0][2], 'Publisher_ID', '3rd column heading is publisher ID' );
924	is( $report_column_headings[0][3], 'Platform', '4th column heading is platform' );
925	is( $report_column_headings[0][4], 'DOI', '5th column heading is DOI' );
926	is( $report_column_headings[0][5], 'Proprietary_ID', '6th column heading is proprietary ID' );
927	is( $report_column_headings[0][6], 'ISBN', '7th column heading is ISBN' );
928	is( $report_column_headings[0][7], 'Print_ISSN', '8th column heading is print ISSN' );
929	is( $report_column_headings[0][8], 'Online_ISSN', '9th column heading is online ISSN' );
930	is( $report_column_headings[0][9], 'URI', '10th column heading is URI' );
931	is( $report_column_headings[0][10], 'YOP', '11th column heading is yop' );
932	is( $report_column_headings[0][11], 'Metric_Type', '12th column heading is metric type' );
933	is( $report_column_headings[0][12], 'Reporting_Period_Total', '13th column heading is reporting period total' );
934
935	# Months column headings
936	is( $report_column_headings[0][13], 'Nov 2022', '14th column is month column heading' );
937	is( $report_column_headings[0][14], 'Dec 2022', '15th column is the last month column heading' );
938	is( $report_column_headings[0][15], undef, '16th column is empty, no more months' );
939	};
940
941	subtest 'TR_B2 _COUNTER_report_body' => sub {
942
943	plan tests => 18;
944
945	my @report_body = $sushi_counter_TR_B2->_COUNTER_report_body;
946
947	# The same title is sequential but for different metric types
948	is(
949	$report_body[0][0], 'Handbook of Nuclear Engineering',
950	'different title, only one metric type'
951	);
952	is(
953	$report_body[1][0], 'Human Resource Management in International Firms',
954	'different title, only one metric type'
955	);
956	is( $report_body[0][11], 'No_License', '1 rows for 1st title, metric type' );
957	is( $report_body[1][11], 'No_License', '1 rows for 2nd title, metric type' );
958
959	# The data is in the correct column
960	is( $report_body[2][0], 'Understanding Disability', '1st column is title' );
961	is( $report_body[2][1], 'Test Publisher E', '2nd column is publisher' );
962	is( $report_body[2][2], '', '3rd column heading is publisher ID' );
963	is( $report_body[2][3], 'Test Platform', '4th column is platform' );
964	is( $report_body[2][4], '10.1007/978-1-349-24269-6', '5th column is DOI' );
965	is( $report_body[2][5], 'SN:TEST/978-1-349-24269-6', '6th column is proprietary ID' );
966	is( $report_body[2][6], '978-1-349-24269-6', '7th column is ISBN' );
967	is( $report_body[2][7], '', '8th column is print ISSN' );
968	is( $report_body[2][8], '', '9th column is online ISSN' );
969	is( $report_body[2][9], '', '10th column is URI' );
970	is( $report_body[2][10], '1996', '11th column is yop' );
971	is( $report_body[2][11], 'No_License', '12th column is access type' );
972	is( $report_body[2][12], 1, '13th column is reporting period total' );
973
974	# The period total is the sum of all the month columns
975	my $stats_total = 0;
976	for ( my $i = 13 ; $i < 15 ; $i++ ) {
977	$stats_total += $report_body[0][$i];
978	}
979	is(
980	$report_body[0][13], $stats_total,
981	'Reporting period total matches the sum of all the monthly usage statistics'
982	);
983	};

Line 0 Link Here

(-)a/t/db_dependent/data/erm/eusage/TR_B2.json (-1 / +443 lines)
0	-	1	{
		2	"Report_Header": {
		3	"Created": "2023-11-28T12:53:04Z",
		4	"Created_By": "Test Systems Inc.",
		5	"Customer_ID": "TEST_CUSTOMER_ID",
		6	"Report_ID": "TR_B2",
		7	"Release": "5",
		8	"Report_Name": "Book Access Denied",
		9	"Institution_Name": "Test Institution",
		10	"Institution_ID": [{ "Type": "Proprietary", "Value": "SN:TEST_CUSTOMER_ID" }],
		11	"Report_Filters": [
		12	{ "Name": "Data_Type", "Value": "Book" },
		13	{ "Name": "Access_Method", "Value": "Regular" },
		14	{ "Name": "Metric_Type", "Value": "Limit_Exceeded\|No_License" },
		15	{ "Name": "Begin_Date", "Value": "2022-11-01" },
		16	{ "Name": "End_Date", "Value": "2022-12-31" }
		17	]
		18	},
		19	"Report_Items": [
		20	{
		21	"Title": "Handbook of Nuclear Engineering",
		22	"Item_ID": [
		23	{ "Type": "DOI", "Value": "10.1007/978-0-387-98149-9" },
		24	{ "Type": "ISBN", "Value": "978-0-387-98149-9" },
		25	{ "Type": "Proprietary", "Value": "SN:TEST/978-0-387-98149-9" }
		26	],
		27	"Platform": "Test Platform",
		28	"Publisher": "Test Publisher",
		29	"YOP": "2010",
		30	"Performance": [
		31	{
		32	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
		33	"Instance": [{ "Metric_Type": "No_License", "Count": 3 }]
		34	}
		35	]
		36	},
		37	{
		38	"Title": "Human Resource Management in International Firms",
		39	"Item_ID": [
		40	{ "Type": "DOI", "Value": "10.1007/978-1-349-11255-5" },
		41	{ "Type": "ISBN", "Value": "978-1-349-11255-5" },
		42	{ "Type": "Proprietary", "Value": "SN:TEST/978-1-349-11255-5" }
		43	],
		44	"Platform": "Test Platform",
		45	"Publisher": "Test Publisher D",
		46	"YOP": "1990",
		47	"Performance": [
		48	{
		49	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
		50	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
		51	}
		52	]
		53	},
		54	{
		55	"Title": "Understanding Disability",
		56	"Item_ID": [
		57	{ "Type": "DOI", "Value": "10.1007/978-1-349-24269-6" },
		58	{ "Type": "ISBN", "Value": "978-1-349-24269-6" },
		59	{ "Type": "Proprietary", "Value": "SN:TEST/978-1-349-24269-6" }
		60	],
		61	"Platform": "Test Platform",
		62	"Publisher": "Test Publisher E",
		63	"YOP": "1996",
		64	"Performance": [
		65	{
66	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
67	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
68	}
69	]
70	},
71	{
72	"Title": "Learning from Disasters: A Management Approach",
73	"Item_ID": [
74	{ "Type": "DOI", "Value": "10.1007/978-1-349-27902-9" },
75	{ "Type": "ISBN", "Value": "978-1-349-27902-9" },
76	{ "Type": "Proprietary", "Value": "SN:TEST/978-1-349-27902-9" }
77	],
78	"Platform": "Test Platform",
79	"Publisher": "Test Publisher E",
80	"YOP": "2005",
81	"Performance": [
82	{
83	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
84	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
85	}
86	]
87	},
88	{
89	"Title": "Handbook of Nuclear Chemistry",
90	"Item_ID": [
91	{ "Type": "DOI", "Value": "10.1007/978-1-4419-0720-2" },
92	{ "Type": "ISBN", "Value": "978-1-4419-0720-2" },
93	{ "Type": "Proprietary", "Value": "SN:TEST/978-1-4419-0720-2" }
94	],
95	"Platform": "Test Platform",
96	"Publisher": "Test Publisher",
97	"YOP": "2011",
98	"Performance": [
99	{
100	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
101	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
102	}
103	]
104	},
105	{
106	"Title": "Compound Semiconductor Device Modelling",
107	"Item_ID": [
108	{ "Type": "DOI", "Value": "10.1007/978-1-4471-2048-3" },
109	{ "Type": "ISBN", "Value": "978-1-4471-2048-3" },
110	{ "Type": "Proprietary", "Value": "SN:TEST/978-1-4471-2048-3" }
111	],
112	"Platform": "Test Platform",
113	"Publisher": "Test Publisher F",
114	"YOP": "1993",
115	"Performance": [
116	{
117	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
118	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
119	}
120	]
121	},
122	{
123	"Title": "Essentials of Carbohydrate Chemistry",
124	"Item_ID": [
125	{ "Type": "DOI", "Value": "10.1007/978-1-4612-1622-3" },
126	{ "Type": "ISBN", "Value": "978-1-4612-1622-3" },
127	{ "Type": "Print_ISSN", "Value": "0172-6323" },
128	{ "Type": "Proprietary", "Value": "SN:TEST/978-1-4612-1622-3" }
129	],
130	"Platform": "Test Platform",
131	"Publisher": "Test Publisher G",
132	"YOP": "1998",
133	"Performance": [
134	{
135	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
136	"Instance": [{ "Metric_Type": "No_License", "Count": 6 }]
137	}
138	]
139	},
140	{
141	"Title": "Elements of Statistical Disclosure Control",
142	"Item_ID": [
143	{ "Type": "DOI", "Value": "10.1007/978-1-4613-0121-9" },
144	{ "Type": "ISBN", "Value": "978-1-4613-0121-9" },
145	{ "Type": "Print_ISSN", "Value": "0930-0325" },
146	{ "Type": "Proprietary", "Value": "SN:TEST/978-1-4613-0121-9" }
147	],
148	"Platform": "Test Platform",
149	"Publisher": "Test Publisher G",
150	"YOP": "2001",
151	"Performance": [
152	{
153	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
154	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
155	}
156	]
157	},
158	{
159	"Title": "Seamless R and C++ Integration with Rcpp",
160	"Item_ID": [
161	{ "Type": "DOI", "Value": "10.1007/978-1-4614-6868-4" },
162	{ "Type": "ISBN", "Value": "978-1-4614-6868-4" },
163	{ "Type": "Proprietary", "Value": "SN:TEST/978-1-4614-6868-4" }
164	],
165	"Platform": "Test Platform",
166	"Publisher": "Test Publisher G",
167	"YOP": "2013",
168	"Performance": [
169	{
170	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
171	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
172	}
173	]
174	},
175	{
176	"Title": "Developing Applications with Azure Active Directory",
177	"Item_ID": [
178	{ "Type": "DOI", "Value": "10.1007/978-1-4842-5040-2" },
179	{ "Type": "ISBN", "Value": "978-1-4842-5040-2" },
180	{ "Type": "Proprietary", "Value": "SN:TEST/978-1-4842-5040-2" }
181	],
182	"Platform": "Test Platform",
183	"Publisher": "Test Publisher H",
184	"YOP": "2019",
185	"Performance": [
186	{
187	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
188	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
189	}
190	]
191	},
192	{
193	"Title": "Introduction to X-Ray Spectrometric Analysis",
194	"Item_ID": [
195	{ "Type": "DOI", "Value": "10.1007/978-1-4899-2204-5" },
196	{ "Type": "ISBN", "Value": "978-1-4899-2204-5" },
197	{ "Type": "Proprietary", "Value": "SN:TEST/978-1-4899-2204-5" }
198	],
199	"Platform": "Test Platform",
200	"Publisher": "Test Publisher",
201	"YOP": "1978",
202	"Performance": [
203	{
204	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
205	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
206	}
207	]
208	},
209	{
210	"Title": "Gypsy and Traveller Girls",
211	"Item_ID": [
212	{ "Type": "DOI", "Value": "10.1007/978-3-030-03703-1" },
213	{ "Type": "ISBN", "Value": "978-3-030-03703-1" },
214	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-030-03703-1" }
215	],
216	"Platform": "Test Platform",
217	"Publisher": "Test Publisher A",
218	"YOP": "2019",
219	"Performance": [
220	{
221	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
222	"Instance": [{ "Metric_Type": "No_License", "Count": 2 }]
223	}
224	]
225	},
226	{
227	"Title": "Ernst Mach – Life, Work, Influence",
228	"Item_ID": [
229	{ "Type": "DOI", "Value": "10.1007/978-3-030-04378-0" },
230	{ "Type": "ISBN", "Value": "978-3-030-04378-0" },
231	{ "Type": "Print_ISSN", "Value": "0929-6328" },
232	{ "Type": "Online_ISSN", "Value": "2215-1818" },
233	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-030-04378-0" }
234	],
235	"Platform": "Test Platform",
236	"Publisher": "Test Publisher A",
237	"YOP": "2019",
238	"Performance": [
239	{
240	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
241	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
242	}
243	]
244	},
245	{
246	"Title": "The Palgrave Handbook of Male Psychology and Mental Health",
247	"Item_ID": [
248	{ "Type": "DOI", "Value": "10.1007/978-3-030-04384-1" },
249	{ "Type": "ISBN", "Value": "978-3-030-04384-1" },
250	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-030-04384-1" }
251	],
252	"Platform": "Test Platform",
253	"Publisher": "Test Publisher A",
254	"YOP": "2019",
255	"Performance": [
256	{
257	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
258	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
259	}
260	]
261	},
262	{
263	"Title": "Handbook of Population",
264	"Item_ID": [
265	{ "Type": "DOI", "Value": "10.1007/978-3-030-10910-3" },
266	{ "Type": "ISBN", "Value": "978-3-030-10910-3" },
267	{ "Type": "Print_ISSN", "Value": "1389-6903" },
268	{ "Type": "Online_ISSN", "Value": "2542-839X" },
269	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-030-10910-3" }
270	],
271	"Platform": "Test Platform",
272	"Publisher": "Test Publisher A",
273	"YOP": "2019",
274	"Performance": [
275	{
276	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
277	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
278	}
279	]
280	},
281	{
282	"Title": "Socioeconomic Inequality and Educational Outcomes",
283	"Item_ID": [
284	{ "Type": "DOI", "Value": "10.1007/978-3-030-11991-1" },
285	{ "Type": "ISBN", "Value": "978-3-030-11991-1" },
286	{ "Type": "Print_ISSN", "Value": "2366-1631" },
287	{ "Type": "Online_ISSN", "Value": "2366-164X" },
288	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-030-11991-1" }
289	],
290	"Platform": "Test Platform",
291	"Publisher": "Test Publisher A",
292	"YOP": "2019",
293	"Performance": [
294	{
295	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
296	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
297	}
298	]
299	},
300	{
301	"Title": "Feng Shui: Teaching About Science and Pseudoscience",
302	"Item_ID": [
303	{ "Type": "DOI", "Value": "10.1007/978-3-030-18822-1" },
304	{ "Type": "ISBN", "Value": "978-3-030-18822-1" },
305	{ "Type": "Print_ISSN", "Value": "2520-8594" },
306	{ "Type": "Online_ISSN", "Value": "2520-8608" },
307	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-030-18822-1" }
308	],
309	"Platform": "Test Platform",
310	"Publisher": "Test Publisher A",
311	"YOP": "2019",
312	"Performance": [
313	{
314	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
315	"Instance": [{ "Metric_Type": "No_License", "Count": 2 }]
316	}
317	]
318	},
319	{
320	"Title": "Human Aspects of IT for the Aged Population. Healthy and Active Aging",
321	"Item_ID": [
322	{ "Type": "DOI", "Value": "10.1007/978-3-030-50249-2" },
323	{ "Type": "ISBN", "Value": "978-3-030-50249-2" },
324	{ "Type": "Print_ISSN", "Value": "0302-9743" },
325	{ "Type": "Online_ISSN", "Value": "1611-3349" },
326	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-030-50249-2" }
327	],
328	"Platform": "Test Platform",
329	"Publisher": "Test Publisher A",
330	"YOP": "2020",
331	"Performance": [
332	{
333	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
334	"Instance": [{ "Metric_Type": "No_License", "Count": 6 }]
335	}
336	]
337	},
338	{
339	"Title": "Bayesian Compendium",
340	"Item_ID": [
341	{ "Type": "DOI", "Value": "10.1007/978-3-030-55897-0" },
342	{ "Type": "ISBN", "Value": "978-3-030-55897-0" },
343	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-030-55897-0" }
344	],
345	"Platform": "Test Platform",
346	"Publisher": "Test Publisher A",
347	"YOP": "2020",
348	"Performance": [
349	{
350	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
351	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
352	}
353	]
354	},
355	{
356	"Title": "The Science of Citizen Science",
357	"Item_ID": [
358	{ "Type": "DOI", "Value": "10.1007/978-3-030-58278-4" },
359	{ "Type": "ISBN", "Value": "978-3-030-58278-4" },
360	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-030-58278-4" }
361	],
362	"Platform": "Test Platform",
363	"Publisher": "Test Publisher A",
364	"YOP": "2021",
365	"Performance": [
366	{
367	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
368	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
369	}
370	]
371	},
372	{
373	"Title": "Accessible Housing for South Asia",
374	"Item_ID": [
375	{ "Type": "DOI", "Value": "10.1007/978-3-030-88881-7" },
376	{ "Type": "ISBN", "Value": "978-3-030-88881-7" },
377	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-030-88881-7" }
378	],
379	"Platform": "Test Platform",
380	"Publisher": "Test Publisher A",
381	"YOP": "2022",
382	"Performance": [
383	{
384	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
385	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
386	}
387	]
388	},
389	{
390	"Title": "Advanced Informatics for Computing Research",
391	"Item_ID": [
392	{ "Type": "DOI", "Value": "10.1007/978-3-031-09469-9" },
393	{ "Type": "ISBN", "Value": "978-3-031-09469-9" },
394	{ "Type": "Print_ISSN", "Value": "1865-0929" },
395	{ "Type": "Online_ISSN", "Value": "1865-0937" },
396	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-031-09469-9" }
397	],
398	"Platform": "Test Platform",
399	"Publisher": "Test Publisher A",
400	"YOP": "2022",
401	"Performance": [
402	{
403	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
404	"Instance": [{ "Metric_Type": "No_License", "Count": 2 }]
405	}
406	]
407	},
408	{
409	"Title": "SDG 14: Life Below Water",
410	"Item_ID": [
411	{ "Type": "DOI", "Value": "10.1007/978-3-031-19467-2" },
412	{ "Type": "ISBN", "Value": "978-3-031-19467-2" },
413	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-031-19467-2" }
414	],
415	"Platform": "Test Platform",
416	"Publisher": "Test Publisher A",
417	"YOP": "2023",
418	"Performance": [
419	{
420	"Period": { "Begin_Date": "2022-11-01", "End_Date": "2022-11-31" },
421	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
422	}
423	]
424	},
425	{
426	"Title": "Transforming Rural Communities in China and Beyond",
427	"Item_ID": [
428	{ "Type": "DOI", "Value": "10.1007/978-3-319-11319-7" },
429	{ "Type": "ISBN", "Value": "978-3-319-11319-7" },
430	{ "Type": "Proprietary", "Value": "SN:TEST/978-3-319-11319-7" }
431	],
432	"Platform": "Test Platform",
433	"Publisher": "Test Publisher A",
434	"YOP": "2015",
435	"Performance": [
436	{
437	"Period": { "Begin_Date": "2022-12-01", "End_Date": "2022-12-31" },
438	"Instance": [{ "Metric_Type": "No_License", "Count": 1 }]
439	}
440	]
441	}
442	]
443	}