View | Details | Raw Unified | Return to bug 9000
Collapse All | Expand All

(-)a/misc/cronjobs/rss/README (-2 / +2 lines)
Lines 51-57 title=Koha, the worlds best Open Source Library System Link Here
51
url=http://www.koha-community.org/images/foo.jpg
51
url=http://www.koha-community.org/images/foo.jpg
52
link=http://www.koha-community.org
52
link=http://www.koha-community.org
53
config
53
config
54
tmpl=lastAcquired.tt
54
template=lastAcquired.tt
55
output=lastAcquired.xml
55
output=lastAcquired.xml
56
query=select biblioitems.isbn as isbn, biblio.title as title, biblio.author as author from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.dateaccessioned is not NULL order by items.dateaccessioned desc
56
query=select biblioitems.isbn as isbn, biblio.title as title, biblio.author as author from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.dateaccessioned is not NULL order by items.dateaccessioned desc
57
57
Lines 61-67 in the template. Most of the template is boilerplate and should not Link Here
61
be edited.  The section within the [% FOREACH i IN ITEMS %] ... [% END %]
61
be edited.  The section within the [% FOREACH i IN ITEMS %] ... [% END %]
62
is the part which can be modified to create your own RSS content.
62
is the part which can be modified to create your own RSS content.
63
63
64
Here's the lastAcquired.tmpl file:
64
Here's the lastAcquired.tt file:
65
65
66
<?xml version="1.0" encoding="UTF-8"?>
66
<?xml version="1.0" encoding="UTF-8"?>
67
67
(-)a/misc/cronjobs/rss/lastAcquired-1.0.conf (-1 / +1 lines)
Lines 9-14 url=http://www.koha-community.org/images/foo.jpg Link Here
9
link=http://www.koha-community.org
9
link=http://www.koha-community.org
10
description=Koha, the worlds best Open Source Library System
10
description=Koha, the worlds best Open Source Library System
11
config
11
config
12
tmpl=lastAcquired-1.0.tt
12
template=lastAcquired-1.0.tt
13
output=lastAcquired-1.0.xml
13
output=lastAcquired-1.0.xml
14
query=select biblio.title as title, biblio.author as author, biblio.biblionumber, biblio.notes as notes, biblioitems.place as place, biblioitems.publishercode as publishercode, biblioitems.publicationyear as publicationyear, biblioitems.pages as pages, biblioitems.illus as illus, biblioitems.size as size from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.dateaccessioned is not NULL order by items.dateaccessioned desc
14
query=select biblio.title as title, biblio.author as author, biblio.biblionumber, biblio.notes as notes, biblioitems.place as place, biblioitems.publishercode as publishercode, biblioitems.publicationyear as publicationyear, biblioitems.pages as pages, biblioitems.illus as illus, biblioitems.size as size from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.dateaccessioned is not NULL order by items.dateaccessioned desc
(-)a/misc/cronjobs/rss/lastAcquired-2.0.conf (-1 / +1 lines)
Lines 11-16 description=Koha, the worlds best Open Source Library System Link Here
11
width=88
11
width=88
12
height=31
12
height=31
13
config
13
config
14
tmpl=lastAcquired-2.0.tt
14
template=lastAcquired-2.0.tt
15
output=lastAcquired-2.0.xml
15
output=lastAcquired-2.0.xml
16
query=select biblio.title as title, biblio.author as author, biblio.biblionumber, biblio.notes as notes, biblioitems.place as place, biblioitems.publishercode as publishercode, biblioitems.publicationyear as publicationyear, biblioitems.pages as pages, biblioitems.illus as illus, biblioitems.size as size from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.dateaccessioned is not NULL order by items.dateaccessioned desc
16
query=select biblio.title as title, biblio.author as author, biblio.biblionumber, biblio.notes as notes, biblioitems.place as place, biblioitems.publishercode as publishercode, biblioitems.publicationyear as publicationyear, biblioitems.pages as pages, biblioitems.illus as illus, biblioitems.size as size from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.dateaccessioned is not NULL order by items.dateaccessioned desc
(-)a/misc/cronjobs/rss/lastAcquired.conf (-1 / +1 lines)
Lines 9-15 title=Koha, the world's best Open Source Library System Link Here
9
url=http://www.koha-community.org/images/foo.jpg
9
url=http://www.koha-community.org/images/foo.jpg
10
link=http://www.koha-community.org
10
link=http://www.koha-community.org
11
config
11
config
12
tmpl=lastAcquired.tt
12
template=lastAcquired.tt
13
output=lastAcquired.xml
13
output=lastAcquired.xml
14
query=select biblio.title as title, biblio.author as author, biblio.biblionumber from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.dateaccessioned is not NULL order by items.dateaccessioned desc
14
query=select biblio.title as title, biblio.author as author, biblio.biblionumber from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.dateaccessioned is not NULL order by items.dateaccessioned desc
15
15
(-)a/misc/cronjobs/rss/longestUnseen.conf (-1 / +1 lines)
Lines 8-14 title=Koha, the worlds best Open Source Library System Link Here
8
url=http://www.koha-community.org/images/foo.jpg
8
url=http://www.koha-community.org/images/foo.jpg
9
link=http://www.koha-community.org
9
link=http://www.koha-community.org
10
config
10
config
11
tmpl=longestUnseen.tt
11
template=longestUnseen.tt
12
output=longestUnseen.xml
12
output=longestUnseen.xml
13
query=select biblioitems.isbn as isbn, biblio.title as title, biblio.author as author from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.datelastseen is not NULL and items.datelastseen != items.datelastborrowed order by items.datelastseen
13
query=select biblioitems.isbn as isbn, biblio.title as title, biblio.author as author from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.datelastseen is not NULL and items.datelastseen != items.datelastborrowed order by items.datelastseen
14
14
(-)a/misc/cronjobs/rss/mostReserved.conf (-1 / +1 lines)
Lines 8-14 title=Koha, the worlds best Open Source Library System Link Here
8
url=http://www.koha-community.org/images/foo.jpg
8
url=http://www.koha-community.org/images/foo.jpg
9
link=http://www.koha-community.org
9
link=http://www.koha-community.org
10
config
10
config
11
tmpl=mostReserved.tt
11
template=mostReserved.tt
12
output=mostReserved.xml
12
output=mostReserved.xml
13
query=select biblioitems.isbn as isbn, biblio.title as title, biblio.author as author from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.reserves is not NULL order by items.reserves desc
13
query=select biblioitems.isbn as isbn, biblio.title as title, biblio.author as author from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.reserves is not NULL order by items.reserves desc
14
14
(-)a/misc/cronjobs/rss/rss.pl (-2 / +1 lines)
Lines 57-63 my $vars = { Link Here
57
    ITEMS => getItems( $config{'query'} )
57
    ITEMS => getItems( $config{'query'} )
58
};
58
};
59
59
60
my $template_path = $config{"tmpl"};
60
my $template_path = $config{"template"};
61
open( my $fh, "<", $template_path ) or die "cannot open $template_path : $!";
61
open( my $fh, "<", $template_path ) or die "cannot open $template_path : $!";
62
$feed->process( $fh, $vars, $outFile );
62
$feed->process( $fh, $vars, $outFile );
63
63
64
- 

Return to bug 9000