Job

Difficulty

Spec (updated on Fri Aug 1 20:25:09 2025)

describe("circ/overdues", function () {
    const languages = ['en', 'es-ES', 'fr-FR', 'de-DE', 'el-GR', 'zh-Hant-TW'];
    languages.forEach((lang) => {
        describe(`in ${lang}`, () => {
            beforeEach(function(){
                // If previous test failed, skip this one
                if (Cypress.env("TEST_FAILED")) {
                    this.skip();
                }
                cy.query("INSERT INTO issues (`borrowernumber`,`itemnumber`,`date_due`,`branchcode`,`issuedate`) VALUES ('45','47', CONCAT(DATE_SUB(CURDATE(), INTERVAL 5 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 15 DAY)), ('5','630', CONCAT(DATE_SUB(CURDATE(), INTERVAL 7 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 17 DAY)), ('5','279', CONCAT(DATE_SUB(CURDATE(), INTERVAL 7 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 17 DAY)), ('23','153', CONCAT(DATE_SUB(CURDATE(), INTERVAL 3 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 13 DAY)), ('28','34', CONCAT(DATE_SUB(CURDATE(), INTERVAL 18 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 28 DAY)), ('28','65', CONCAT(DATE_SUB(CURDATE(), INTERVAL 18 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 28 DAY)), ('31','562', CONCAT(DATE_SUB(CURDATE(), INTERVAL 19 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 29 DAY)), ('31','262', CONCAT(DATE_SUB(CURDATE(), INTERVAL 19 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 29 DAY)), ('31','35', CONCAT(DATE_SUB(CURDATE(), INTERVAL 19 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 29 DAY));")
                cy.login();
                /* No specific padding defined */
                cy.set_cookie_lang(lang);
            });

            it("overdues", function () {
                cy.visit("/cgi-bin/koha/circ/overdue.pl");
                cy.waitForPageLoad();
                cy.get(".main").should('be.visible').screenshot("overdues");
            });
        });
    });
    afterEach(function () {
        cy.query("DELETE FROM issues;")
        Cypress.env('PADDING_BEFORE_SCREENSHOT', undefined);
        if (this.currentTest.state === 'failed') {
            Cypress.env("TEST_FAILED", true);
        }
    });
});

Spec data

sql INSERT INTO issues (`borrowernumber`,`itemnumber`,`date_due`,`branchcode`,`issuedate`) VALUES ('45','47', CONCAT(DATE_SUB(CURDATE(), INTERVAL 5 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 15 DAY)), ('5','630', CONCAT(DATE_SUB(CURDATE(), INTERVAL 7 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 17 DAY)), ('5','279', CONCAT(DATE_SUB(CURDATE(), INTERVAL 7 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 17 DAY)), ('23','153', CONCAT(DATE_SUB(CURDATE(), INTERVAL 3 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 13 DAY)), ('28','34', CONCAT(DATE_SUB(CURDATE(), INTERVAL 18 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 28 DAY)), ('28','65', CONCAT(DATE_SUB(CURDATE(), INTERVAL 18 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 28 DAY)), ('31','562', CONCAT(DATE_SUB(CURDATE(), INTERVAL 19 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 29 DAY)), ('31','262', CONCAT(DATE_SUB(CURDATE(), INTERVAL 19 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 29 DAY)), ('31','35', CONCAT(DATE_SUB(CURDATE(), INTERVAL 19 DAY), ' 23:59:00'),'MPL', DATE_SUB(NOW(), INTERVAL 29 DAY));

sql DELETE FROM issues;

Notes

Original had the return claims columns, but I'm not sure it was necessary. CCLR

Additional KTD data

Thumbnails

Old

New

New (de)

New (el)

New (es)

New (fr)

New (zh_Hant)

Old

New (updated on Fri Aug 1 20:26:57 2025)

New (de)

New (el)

New (es)

New (fr)

New (zh_Hant)