Job

Difficulty

Spec (updated on Thu Dec 4 15:48:19 2025)

describe("circ/overdues", function () {
    const languages = ['en', 'es-ES', 'fr-FR', 'de-DE', 'el-GR', 'hi', 'zh-Hant-TW'];
    languages.forEach((lang) => {
        describe(`in ${lang}`, () => {
            beforeEach(function(){
                // Skip if 'en' test failed
                if (Cypress.env("EN_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);
        // Set EN_TEST_FAILED if the 'en' test failed
        if (this.currentTest.parent.title.includes('in en') && this.currentTest.state === 'failed') {
            Cypress.env("EN_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

Current

New

New (de)

New (el)

New (es)

New (fr)

New (hi)

New (zh_Hant)

Current

New (updated on Thu Dec 4 21:22:02 2025)

New (de)

New (el)

New (es)

New (fr)

New (hi)

New (zh_Hant)