black23

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:marc="http://www.loc.gov/MARC21/slim"
  version="1.0">

 <xsl:output method="xml" indent="yes" encoding="UTF-8"/>
 <xsl:strip-space elements="*"/>

 <xsl:template match="@* | node()">
 <xsl:copy>

black23

format:
  marcxml:
    metadataPrefix: marcxml
    metadataNamespace: http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim
    schema: http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd
    xsl_file: /home/koha/xslt/ModifyMARC.xsl
  marc21:
    metadataPrefix: marc21
    metadataNamespace: http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim
    schema: http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd

black23

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:marc="http://www.loc.gov/MARC21/slim"
  version="2.0">

 <xsl:output method="xml" indent="yes" encoding="UTF-8"/>
 <xsl:strip-space elements="*"/>

 <xsl:template match="@* | node()">
 <xsl:copy>

black23

# Flush the tables to apply changes
iptables -F

# Allow established connections (the responses to our outgoing traffic)
iptables -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT

# SSH from anywhere
iptables -A INPUT -m state --state NEW -p tcp --dport 22 -j ACCEPT

black23

/* Obálky */
var obalky = obalky || {};

obalky.protocol =
(document.location.protocol == 'https:') ? 'https://':'http://';
obalky.url = obalky.protocol+"www.obalkyknih.cz";

obalky.books = obalky.books || [];
obalky.version = "0.2.0";
obalky.id = 0;

black23

SELECT CONCAT_WS("", "<a href='/cgi-bin/koha/members/moremember.pl?borrowernumber=", bor.borrowernumber, "'>", bor.firstname, " ", bor.surname, "</a>") AS "Ctenar",
oldr.reservedate AS "Datum rezervace", br.branchname AS "Knihovna",
IF(ISNULL(cancellationdate), IF(found = "F", "<span style='color:green;font-weight:bold'>Vyřízeno</span>", found), CONCAT("<span style='color:red;'>Zrušeno ", cancellationdate, "</span>")) AS "Stav",
b.author AS "Autor", 
CONCAT("<a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber=", b.biblionumber, "'>", b.title, "</a>") AS "Nazev", 
i.stocknumber AS "P. cislo", i.barcode AS "Carovy kod", it.description AS "Typ jednotky"
FROM old_reserves oldr
JOIN borrowers bor ON oldr.borrowernumber = bor.borrowernumber
JOIN biblio b ON oldr.biblionumber = b.biblionumber
LEFT OUTER JOIN items i ON oldr.itemnumber = i.itemnumber

black23

SELECT concat('<a href="/cgi-bin/koha/members/readingrec.pl?borrowernumber=', `old_issues`.`borrowernumber`, '">', firstname, ' ', surname, '</a>') as 'Čtenář', 
concat('<a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=', items.biblionumber, '">', items.barcode, '</a>') as 'Jednotka',
date_format(old_issues.timestamp, "%e.%c.%Y %H:%i:%s") as 'Zpracováno'
FROM old_issues 
JOIN borrowers on old_issues.borrowernumber = borrowers.borrowernumber
JOIN items ON old_issues.itemnumber = items.itemnumber
WHERE `old_issues`.`timestamp` != `old_issues`.`returndate`
AND DATE(old_issues .timestamp) = CURDATE()
ORDER BY old_issues.timestamp

black23

SELECT count(*) as 'Počet vrácení'
FROM old_issues 
JOIN borrowers on old_issues.borrowernumber = borrowers.borrowernumber
JOIN items ON old_issues.itemnumber = items.itemnumber
WHERE `old_issues`.`timestamp` != `old_issues`.`returndate`
AND DATE(old_issues .timestamp) BETWEEN <<Od|date>> AND <<Do|date>>
ORDER BY old_issues.timestamp

black23

#!/bin/bash

INSTANCE="nazev_instance_kohy"
SIGLA="sigla_knihovny"
USERNAME="vypdilia"
PASSWORD="heslo"

YEAR=$(date "+%Y")
QUARTAL=$(echo "(`date +%m` - 1)/3" | bc)
if [ "$QUARTAL" == "0" ] ; then

black23

Using a raspberry pi to display Google Calendars

This explains the set up of our very basic status screen to displays Google calendars here at booncon.

Install the raspberry pi

Download and put the most current https://www.raspberrypi.org/downloads/raspbian/ image to an SD Card. On OSX that works great with http://www.tweaking4all.com/hardware/raspberry-pi/macosx-apple-pi-baker/, just use the restore option and select the unzipped image file.

Set up the operation system basics

After the first boot, the raspi-config utility should load up.