Skillnad mellan versioner av "Användbara sätt att länka"
(Skapade sidan med '=Länkar till katalogposter= ==Länk till katalogpost== CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\" target="_blank">', biblio.t...') |
|||
| Rad 4: | Rad 4: | ||
CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\" target="_blank">', biblio.title, '</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\" target="_blank">', biblio.title, '</a>' ) | ||
| − | + | ==Redigera katalogpost== | |
CONCAT('<a href=\"/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=', biblionumber, '\">', biblionumber, '</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=', biblionumber, '\">', biblionumber, '</a>' ) | ||
| − | + | ==Redigera katalogpost, öppna flik 9== | |
CONCAT('<a href=\"/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=', biblio_metadata.biblionumber, '#tab9XX', '\" target="_blank">',biblio_metadata.biblionumber, '</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=', biblio_metadata.biblionumber, '#tab9XX', '\" target="_blank">',biblio_metadata.biblionumber, '</a>' ) | ||
| − | + | ==Redigera katalogpost, spara med bibliografiskt ramverk VR== | |
CONCAT('<a href=\"/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=', biblioitems.biblionumber, '&frameworkcode=VR', '\" target="_blank">',biblioitems.biblionumber, '</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=', biblioitems.biblionumber, '&frameworkcode=VR', '\" target="_blank">',biblioitems.biblionumber, '</a>' ) | ||
| − | + | =Länkar till exemplarposter= | |
| − | + | ==Länk till exemplarpost== | |
| − | + | ==Status med mera för exemplar== | |
CONCAT('<a href=\"/cgi-bin/koha/catalogue/moredetail.pl?itemnumber=', items.itemnumber, '&biblionumber=',biblio.biblionumber,'\" target="_blank">', items.barcode, '</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/catalogue/moredetail.pl?itemnumber=', items.itemnumber, '&biblionumber=',biblio.biblionumber,'\" target="_blank">', items.barcode, '</a>' ) | ||
| − | + | ==Flytta exemplar till katalogpost 309518== | |
CONCAT('<a href=\"/cgi-bin/koha/cataloguing/moveitem.pl?biblionumber=309518&&barcode=', items.barcode, '\" target="_blank">flytta</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/cataloguing/moveitem.pl?biblionumber=309518&&barcode=', items.barcode, '\" target="_blank">flytta</a>' ) | ||
| − | + | =Länkar till låntagarposter= | |
| − | + | ==Länk till låntagarpost== | |
| − | |||
CONCAT('<a href=\"/cgi-bin/koha/members/moremember.pl?borrowernumber=', borrowers.borrowernumber,'\" target="_blank">', borrowers.cardnumber, '</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/members/moremember.pl?borrowernumber=', borrowers.borrowernumber,'\" target="_blank">', borrowers.cardnumber, '</a>' ) | ||
| − | + | ==Länk till utlåningssidan för en låntagare== | |
CONCAT('<a href=\"/cgi-bin/koha/circ/circulation.pl?borrowernumber=',borrowernumber,'\" target="_blank">', borrowernumber, '</a>') | CONCAT('<a href=\"/cgi-bin/koha/circ/circulation.pl?borrowernumber=',borrowernumber,'\" target="_blank">', borrowernumber, '</a>') | ||
| − | + | ==Länk till en låntagares skickade meddelanden== | |
CONCAT('<a href=\"/cgi-bin/koha/members/notices.pl?borrowernumber=', borrowernumber, '\" target="_blank">', borrowernumber, '</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/members/notices.pl?borrowernumber=', borrowernumber, '\" target="_blank">', borrowernumber, '</a>' ) | ||
| − | + | ==Länk till en låntagares avgifter== | |
CONCAT('<a href=\"/cgi-bin/koha/members/boraccount.pl?borrowernumber=',borrowernumber,'\">', borrowernumber, '</a>') | CONCAT('<a href=\"/cgi-bin/koha/members/boraccount.pl?borrowernumber=',borrowernumber,'\">', borrowernumber, '</a>') | ||
| − | + | ==Länk till en låntagares lånehistorik== | |
CONCAT('<a href=\"/cgi-bin/koha/members/deletemem.pl?member=',borrowers.borrowernumber,'\" target="_blank">Radera</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/members/deletemem.pl?member=',borrowers.borrowernumber,'\" target="_blank">Radera</a>' ) | ||
| − | + | ==Betala förseningsavgift== | |
CONCAT('<a href=\"/cgi-bin/koha/members/pay.pl?borrowernumber=',borrowers.borrowernumber,'\" target="_blank">Betala</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/members/pay.pl?borrowernumber=',borrowers.borrowernumber,'\" target="_blank">Betala</a>' ) | ||
| − | + | ==Avskriv förseningsavgift== | |
CONCAT('<a href=\"/cgi-bin/koha/members/paycollect.pl?borrowernumber=', accountlines.borrowernumber, '&writeoff_individual=1&accounttype=',accountlines.accounttype, '&amount=',accountlines.amount, '&amountoutstanding=',accountlines.amountoutstanding, '&accountlines_id=',accountlines.accountlines_id,'\" target="_blank">', FLOOR(accountlines.amountoutstanding), '</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/members/paycollect.pl?borrowernumber=', accountlines.borrowernumber, '&writeoff_individual=1&accounttype=',accountlines.accounttype, '&amount=',accountlines.amount, '&amountoutstanding=',accountlines.amountoutstanding, '&accountlines_id=',accountlines.accountlines_id,'\" target="_blank">', FLOOR(accountlines.amountoutstanding), '</a>' ) | ||
| − | + | ==Länk till låntagarpost, fliken begränsningar== | |
CONCAT('<a href=\"/cgi-bin/koha/members/moremember.pl?borrowernumber=', borrowers.borrowernumber, '#reldebarments','\" target="_blank">', borrowers.cardnumber, '</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/members/moremember.pl?borrowernumber=', borrowers.borrowernumber, '#reldebarments','\" target="_blank">', borrowers.cardnumber, '</a>' ) | ||
| − | + | ==Radera låntagare== | |
CONCAT('<a href=\"/cgi-bin/koha/members/deletemem.pl?member=',borrowers.borrowernumber,'\" target="_blank">Radera</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/members/deletemem.pl?member=',borrowers.borrowernumber,'\" target="_blank">Radera</a>' ) | ||
| − | + | =Länkar till reservationer= | |
| − | + | ==Pausa/återuppta reservation== | |
Varannat klick pausas reservationen, varannat klick återupptas den | Varannat klick pausas reservationen, varannat klick återupptas den | ||
CONCAT('<a href=\"/cgi-bin/koha/reserve/request.pl?action=toggleSuspend&reserve_id=', reserve_id, '&borrowernumber=', reserves.borrowernumber, '&biblionumber=', reserves.biblionumber, '\" target="_blank">', reserves.borrowernumber, '</a>' ) | CONCAT('<a href=\"/cgi-bin/koha/reserve/request.pl?action=toggleSuspend&reserve_id=', reserve_id, '&borrowernumber=', reserves.borrowernumber, '&biblionumber=', reserves.biblionumber, '\" target="_blank">', reserves.borrowernumber, '</a>' ) | ||
| − | + | =Länkar till externa sidor= | |
| − | + | ==Länk till Eniro==1 | |
CONCAT('<a href=\"https://personer.eniro.se/resultat/', borrowers.smsalertnumber, '\" target="_blank">', borrowers.smsalertnumber, '</a>' ) | CONCAT('<a href=\"https://personer.eniro.se/resultat/', borrowers.smsalertnumber, '\" target="_blank">', borrowers.smsalertnumber, '</a>' ) | ||
| − | + | ==Länk till Elib admin== | |
CONCAT('<a href=\"https://admin.elib.se/SuperLibrary/superlibrary_borrower_admin.aspx?sl=2128&card=',borrowers.cardnumber,'\" target="_blank">Elib admin</a>') | CONCAT('<a href=\"https://admin.elib.se/SuperLibrary/superlibrary_borrower_admin.aspx?sl=2128&card=',borrowers.cardnumber,'\" target="_blank">Elib admin</a>') | ||
| − | + | ==Länk till Libris webbsök== | |
Funkar om man har LibrisID i 035 | Funkar om man har LibrisID i 035 | ||
CONCAT('<a href=\"https://libris.kb.se/bib/', SUBSTRING(ExtractValue( bm.metadata, '//datafield[@tag=035]/subfield[@code="a" and contains(text(), "LIBRIS")]'), 9,99), '\" target="_blank">', ExtractValue( bm.metadata, '//datafield[@tag=035]/subfield[@code="a" and contains(text(), "LIBRIS")]'), '</a>' ) | CONCAT('<a href=\"https://libris.kb.se/bib/', SUBSTRING(ExtractValue( bm.metadata, '//datafield[@tag=035]/subfield[@code="a" and contains(text(), "LIBRIS")]'), 9,99), '\" target="_blank">', ExtractValue( bm.metadata, '//datafield[@tag=035]/subfield[@code="a" and contains(text(), "LIBRIS")]'), '</a>' ) | ||
Versionen från 16 december 2019 kl. 14.36
Länkar till katalogposter
Länk till katalogpost
CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\" target="_blank">', biblio.title, '</a>' )
Redigera katalogpost
CONCAT('<a href=\"/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=', biblionumber, '\">', biblionumber, '</a>' )
Redigera katalogpost, öppna flik 9
CONCAT('<a href=\"/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=', biblio_metadata.biblionumber, '#tab9XX', '\" target="_blank">',biblio_metadata.biblionumber, '</a>' )
Redigera katalogpost, spara med bibliografiskt ramverk VR
CONCAT('<a href=\"/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=', biblioitems.biblionumber, '&frameworkcode=VR', '\" target="_blank">',biblioitems.biblionumber, '</a>' )
Länkar till exemplarposter
Länk till exemplarpost
Status med mera för exemplar
CONCAT('<a href=\"/cgi-bin/koha/catalogue/moredetail.pl?itemnumber=', items.itemnumber, '&biblionumber=',biblio.biblionumber,'\" target="_blank">', items.barcode, '</a>' )
Flytta exemplar till katalogpost 309518
CONCAT('<a href=\"/cgi-bin/koha/cataloguing/moveitem.pl?biblionumber=309518&&barcode=', items.barcode, '\" target="_blank">flytta</a>' )
Länkar till låntagarposter
Länk till låntagarpost
CONCAT('<a href=\"/cgi-bin/koha/members/moremember.pl?borrowernumber=', borrowers.borrowernumber,'\" target="_blank">', borrowers.cardnumber, '</a>' )
Länk till utlåningssidan för en låntagare
CONCAT('<a href=\"/cgi-bin/koha/circ/circulation.pl?borrowernumber=',borrowernumber,'\" target="_blank">', borrowernumber, '</a>')
Länk till en låntagares skickade meddelanden
CONCAT('<a href=\"/cgi-bin/koha/members/notices.pl?borrowernumber=', borrowernumber, '\" target="_blank">', borrowernumber, '</a>' )
Länk till en låntagares avgifter
CONCAT('<a href=\"/cgi-bin/koha/members/boraccount.pl?borrowernumber=',borrowernumber,'\">', borrowernumber, '</a>')
Länk till en låntagares lånehistorik
CONCAT('<a href=\"/cgi-bin/koha/members/deletemem.pl?member=',borrowers.borrowernumber,'\" target="_blank">Radera</a>' )
Betala förseningsavgift
CONCAT('<a href=\"/cgi-bin/koha/members/pay.pl?borrowernumber=',borrowers.borrowernumber,'\" target="_blank">Betala</a>' )
Avskriv förseningsavgift
CONCAT('<a href=\"/cgi-bin/koha/members/paycollect.pl?borrowernumber=', accountlines.borrowernumber, '&writeoff_individual=1&accounttype=',accountlines.accounttype, '&amount=',accountlines.amount, '&amountoutstanding=',accountlines.amountoutstanding, '&accountlines_id=',accountlines.accountlines_id,'\" target="_blank">', FLOOR(accountlines.amountoutstanding), '</a>' )
Länk till låntagarpost, fliken begränsningar
CONCAT('<a href=\"/cgi-bin/koha/members/moremember.pl?borrowernumber=', borrowers.borrowernumber, '#reldebarments','\" target="_blank">', borrowers.cardnumber, '</a>' )
Radera låntagare
CONCAT('<a href=\"/cgi-bin/koha/members/deletemem.pl?member=',borrowers.borrowernumber,'\" target="_blank">Radera</a>' )
Länkar till reservationer
Pausa/återuppta reservation
Varannat klick pausas reservationen, varannat klick återupptas den CONCAT('<a href=\"/cgi-bin/koha/reserve/request.pl?action=toggleSuspend&reserve_id=', reserve_id, '&borrowernumber=', reserves.borrowernumber, '&biblionumber=', reserves.biblionumber, '\" target="_blank">', reserves.borrowernumber, '</a>' )
Länkar till externa sidor
==Länk till Eniro==1
CONCAT('<a href=\"https://personer.eniro.se/resultat/', borrowers.smsalertnumber, '\" target="_blank">', borrowers.smsalertnumber, '</a>' )
Länk till Elib admin
CONCAT('<a href=\"https://admin.elib.se/SuperLibrary/superlibrary_borrower_admin.aspx?sl=2128&card=',borrowers.cardnumber,'\" target="_blank">Elib admin</a>')
Länk till Libris webbsök
Funkar om man har LibrisID i 035
CONCAT('<a href=\"https://libris.kb.se/bib/', SUBSTRING(ExtractValue( bm.metadata, '//datafield[@tag=035]/subfield[@code="a" and contains(text(), "LIBRIS")]'), 9,99), '\" target="_blank">', ExtractValue( bm.metadata, '//datafield[@tag=035]/subfield[@code="a" and contains(text(), "LIBRIS")]'), '</a>' )