MVS výstupy

auth-val.txt

ověřená hodnota v kategorii WITHDRAWN:
11 = Zrušená MVS

mvs-ctenarum.sql

SELECT 
    CONCAT('<a href=\"/cgi-bin/koha/circ/circulation.pl?borrowernumber=',s.borrowernumber, '\">',b.firstname, ' ', b.surname, '</a>') AS "Ctenar",
    s.issuedate AS "Datum pujceni",
    s.date_due AS "Termin vraceni",
    CONCAT_WS('','<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',i.biblionumber,'\">', l.title, " od ", l.author, '</a>') as Dokument,
    i.itemnotes_nonpublic AS "Poznamka"

FROM 
    items i
    JOIN biblio l ON l.biblionumber = i.biblionumber
    JOIN issues s ON i.itemnumber = s.itemnumber
    JOIN borrowers b ON s.borrowernumber = b.borrowernumber

WHERE i.itype = "MVS"

ORDER BY s.date_due

mvs-knihovnam.sql

SELECT 
    CONCAT_WS('','<a href=\"/cgi-bin/koha/circ/circulation.pl?borrowernumber=',s.borrowernumber, '\">',b.firstname, ' ', b.surname, '</a>') as "Knihovna",
    s.issuedate as "Vypujceno dne", 
    s.date_due as "Pujceno do",
    CONCAT_WS('','<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',i.biblionumber,'\">', l.title, " od ", l.author, '</a>') as Dokument

FROM 
    issues s 
    JOIN items i ON s.itemnumber = i.itemnumber 
    JOIN borrowers b ON s.borrowernumber = b.borrowernumber
    JOIN biblio l ON l.biblionumber = i.biblionumber

WHERE b.categorycode = "K"

objednane-mvs.sql

SELECT 
    CONCAT('<a href=\"/cgi-bin/koha/circ/circulation.pl?borrowernumber=',s.borrowernumber, '\">',b.firstname, ' ', b.surname, '</a>') AS "Ctenar",
    i.dateaccessioned AS "Objednano dne",
    CONCAT_WS('','<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',i.biblionumber,'\">', l.title, " od ", l.author, '</a>') as Dokument,
    i.itemnotes_nonpublic AS "Poznamka",
    CONCAT_WS('', '<a href="/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=', i.biblionumber, '&itemnumber=', i.itemnumber, '#edititem" class="btn btn-default btn-xs"><i class="fa fa-pencil"></i> Upravit jednotku</a>') as Akce

FROM 
    items i
    JOIN biblio l ON l.biblionumber = i.biblionumber
    JOIN reserves s ON l.biblionumber = s.biblionumber
    JOIN borrowers b ON s.borrowernumber = b.borrowernumber

WHERE i.itype = "MVS"
    AND (i.issues IS NULL OR i.issues = 0) AND s.priority != "W"
    AND i.withdrawn != 11

ORDER BY i.dateaccessioned

zrusene-mvs.sql

SELECT 
    CONCAT('<a href=\"/cgi-bin/koha/circ/circulation.pl?borrowernumber=',s.borrowernumber, '\">',b.firstname, ' ', b.surname, '</a>') AS "Ctenar",
    i.dateaccessioned AS "Objednano dne",
    CONCAT_WS('','<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',i.biblionumber,'\">', l.title, " od ", l.author, '</a>') as Dokument,
    i.itemnotes_nonpublic AS "Poznamka",
    CONCAT_WS('', '<a href="/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=', i.biblionumber, '&itemnumber=', i.itemnumber, '#edititem" class="btn btn-default btn-xs"><i class="fa fa-pencil"></i> Upravit jednotku</a>') as Akce

FROM 
    items i
    JOIN biblio l ON l.biblionumber = i.biblionumber
    LEFT JOIN old_reserves s ON l.biblionumber = s.biblionumber
    LEFT JOIN borrowers b ON s.borrowernumber = b.borrowernumber

WHERE i.itype = "MVS"
    AND (i.issues IS NULL OR i.issues = 0)
    AND i.withdrawn = 11

ORDER BY i.dateaccessioned