koha.git
22 years agoAdded some more tables to the database updater. Modified barcode to be
tonnesen [Mon, 19 Nov 2001 20:29:46 +0000 (20:29 +0000)]
Added some more tables to the database updater.  Modified barcode to be
20 characters long instead of 9.

22 years agoScript that will update existing databases, creating any new tables,
tonnesen [Mon, 19 Nov 2001 18:26:50 +0000 (18:26 +0000)]
Script that will update existing databases, creating any new tables,
adding, modifying or removing any fields from existing tables.

This is in very early stages.  Need to go through and ascertain which
tables and fields need to be added/modified.  Also need to add a "backup"
before any modifications are made.  Thoughts on this are welcome.

22 years agoMinor changes
tonnesen [Tue, 6 Nov 2001 18:25:30 +0000 (18:25 +0000)]
Minor changes

22 years agoScript that I'm using to check MARC record support.
tonnesen [Tue, 6 Nov 2001 18:24:54 +0000 (18:24 +0000)]
Script that I'm using to check MARC record support.

22 years agoWorking out problems with MARC record support.
tonnesen [Tue, 6 Nov 2001 18:15:34 +0000 (18:15 +0000)]
Working out problems with MARC record support.

22 years agoModified version of addbooks.pl that uses LCCN as base identifier instead
tonnesen [Tue, 6 Nov 2001 18:15:00 +0000 (18:15 +0000)]
Modified version of addbooks.pl that uses LCCN as base identifier instead
of ISBN.  Should probably be merged with addbooks.pl so that the user can
enter either and ISBN _or_ and LCCN from the same form.

22 years agoContinuing work on Z39.50 search tool. Daemon now forks up to 12 processes
tonnesen [Tue, 6 Nov 2001 18:13:59 +0000 (18:13 +0000)]
Continuing work on Z39.50 search tool.  Daemon now forks up to 12 processes
to do Z39.50 searches.  Daemon will also wait to see if the user looks
beyond the first couple of pages of results, and will download more results
if necessary.

22 years agoMinor cleanups. Needs testing. Starting to think about modifying
tonnesen [Sat, 3 Nov 2001 07:29:36 +0000 (07:29 +0000)]
Minor cleanups.  Needs testing.  Starting to think about modifying
updatebiblio.pl to use this API.

22 years agoZ39.50 now stores list of servers to query in a database table.
tonnesen [Sat, 3 Nov 2001 07:28:20 +0000 (07:28 +0000)]
Z39.50 now stores list of servers to query in a database table.

22 years agoDaemon to process the queue of pending Z39.50 searches. I still need
tonnesen [Fri, 2 Nov 2001 21:40:01 +0000 (21:40 +0000)]
Daemon to process the queue of pending Z39.50 searches.  I still need
to come up with a way for this process to get launched.  Looks like Koha
might need its first init script.  :)

22 years agoAdded Z39.50 searching capability, and MARC file uploading from workstation
tonnesen [Fri, 2 Nov 2001 21:21:25 +0000 (21:21 +0000)]
Added Z39.50 searching capability, and MARC file uploading from workstation
using HTML forms.   Z39.50 functionality requires the YAZ toolkit.

22 years agoUse MARC controlnumber as a unique identifier for MARC records, in addition
tonnesen [Thu, 1 Nov 2001 05:00:41 +0000 (05:00 +0000)]
Use MARC controlnumber as a unique identifier for MARC records, in addition
to ISBN, ISSN, and LCCN.

22 years agoTypo in printf format string was causing all issues to appear in the
tonnesen [Wed, 10 Oct 2001 19:28:05 +0000 (19:28 +0000)]
Typo in printf format string was causing all issues to appear in the
Previous issues box and not in today's issues.

22 years agoFixed bug where a biblioitem with a subclass but no dewey would get the
tonnesen [Wed, 10 Oct 2001 19:27:00 +0000 (19:27 +0000)]
Fixed bug where a biblioitem with a subclass but no dewey would get the
subclass erased when editing the biblioitem.

22 years agoused CGI.pm's textfield function to create the notes text input box. Notes
tonnesen [Wed, 10 Oct 2001 19:26:14 +0000 (19:26 +0000)]
used CGI.pm's textfield function to create the notes text input box.  Notes
with question marks '"' in them were getting deleted when an item was
modified.

22 years agoAdded rudimentary marc importing tool. Just takes a marc record and
tonnesen [Fri, 5 Oct 2001 21:27:46 +0000 (21:27 +0000)]
Added rudimentary marc importing tool.  Just takes a marc record and
converts to koha database.  Does not keep data in marc format.

22 years agoRemoved duplicate viewmarc.pl from acqui.simple directory
tonnesen [Fri, 5 Oct 2001 21:23:22 +0000 (21:23 +0000)]
Removed duplicate viewmarc.pl from acqui.simple directory

22 years agoAdded simple acquisitions script
tonnesen [Fri, 5 Oct 2001 21:19:29 +0000 (21:19 +0000)]
Added simple acquisitions script

22 years agoChanged search interface to allow searches on Illustrator. This is
tonnesen [Fri, 5 Oct 2001 20:13:20 +0000 (20:13 +0000)]
Changed search interface to allow searches on Illustrator.  This is
apparently a common search in elementary school libraries.

22 years agoTested updateItem subroutine, made some better checks for Subfield_IDs and
tonnesen [Thu, 27 Sep 2001 20:39:59 +0000 (20:39 +0000)]
Tested updateItem subroutine, made some better checks for Subfield_IDs and
Subfield_Keys when modifying MARC data based on changes to Koha data.

22 years agoStarted on updateItem subroutine.
tonnesen [Thu, 27 Sep 2001 19:24:18 +0000 (19:24 +0000)]
Started on updateItem subroutine.

22 years agoFixing member deletion, so that it checks fines, issues and guarantees
rangi [Tue, 11 Sep 2001 02:03:26 +0000 (02:03 +0000)]
Fixing member deletion, so that it checks fines, issues and guarantees
before deleting

22 years agoFixing a glitch that was showing the biblio notes field where the
rangi [Mon, 10 Sep 2001 23:37:09 +0000 (23:37 +0000)]
Fixing a glitch that was showing the biblio notes field where the
biblioitems notes should have been displaying

22 years agoChanged the sorting of the hash of items on issue. To sort numerically, (so
rangi [Fri, 17 Aug 2001 07:54:38 +0000 (07:54 +0000)]
Changed the sorting of the hash of items on issue. To sort numerically, (so
10 comes after 2) Just a quick fix to get the items showing in date_due order

22 years agoSpelling and english language corrections.
pawelzc [Thu, 12 Jul 2001 11:12:11 +0000 (11:12 +0000)]
Spelling and english language corrections.

22 years agoScript to delete a member/patron
rangi [Thu, 5 Jul 2001 21:37:59 +0000 (21:37 +0000)]
Script to delete a member/patron

22 years agoFix to handle the delete call, redirects to deletemem.pl
rangi [Thu, 5 Jul 2001 21:37:15 +0000 (21:37 +0000)]
Fix to handle the delete call, redirects to deletemem.pl

22 years agoModified so that the first available language is chosen if none is specified
rangi [Wed, 27 Jun 2001 21:53:05 +0000 (21:53 +0000)]
Modified so that the first available language is chosen if none is specified

22 years agoFinished updateBiblioItem subroutine
tonnesen [Tue, 26 Jun 2001 22:27:12 +0000 (22:27 +0000)]
Finished updateBiblioItem subroutine

22 years agoScripts to permit koha webpages to display in different natural languages
rangi [Tue, 26 Jun 2001 22:13:50 +0000 (22:13 +0000)]
Scripts to permit koha webpages to display in different natural languages
Courtesy of Pawel Skuza

22 years agonewBiblio subroutine completed.
tonnesen [Tue, 26 Jun 2001 21:13:01 +0000 (21:13 +0000)]
newBiblio subroutine completed.

22 years agoAdded biblioitems table update when newBiblioItem() routine is called.
tonnesen [Tue, 26 Jun 2001 20:17:35 +0000 (20:17 +0000)]
Added biblioitems table update when newBiblioItem() routine is called.

22 years agoBeginning updateBiblio routine.
tonnesen [Tue, 26 Jun 2001 17:15:13 +0000 (17:15 +0000)]
Beginning updateBiblio routine.

22 years agoPrototype marc record viewer and editor.
tonnesen [Mon, 25 Jun 2001 20:15:44 +0000 (20:15 +0000)]
Prototype marc record viewer and editor.

22 years agoA TODO file for MARC support
tonnesen [Mon, 25 Jun 2001 20:12:02 +0000 (20:12 +0000)]
A TODO file for MARC support

22 years agoAdded skeletons of update routines.
tonnesen [Mon, 25 Jun 2001 19:43:59 +0000 (19:43 +0000)]
Added skeletons of update routines.

22 years agoMinor documentation changes.
tonnesen [Mon, 25 Jun 2001 19:07:20 +0000 (19:07 +0000)]
Minor documentation changes.

22 years agoPerl script to convert existing Koha tables to the new MARC tables.
tonnesen [Mon, 25 Jun 2001 18:55:28 +0000 (18:55 +0000)]
Perl script to convert existing Koha tables to the new MARC tables.

22 years agoSQL commands to clear all of the MARC tables. This is terribly dangerous,
tonnesen [Mon, 25 Jun 2001 18:54:12 +0000 (18:54 +0000)]
SQL commands to clear all of the MARC tables.  This is terribly dangerous,
but I find it useful during the development work.  :)

22 years agoSchema for MARC storage tables. Blatantly stolen from www.pytheas.org.
tonnesen [Mon, 25 Jun 2001 18:52:33 +0000 (18:52 +0000)]
Schema for MARC storage tables.  Blatantly stolen from pytheas.org.
I also added the 0XX tables.

22 years agoCataloguing API. Very early draft at this point.
tonnesen [Mon, 25 Jun 2001 18:49:34 +0000 (18:49 +0000)]
Cataloguing API.  Very early draft at this point.

22 years agoMade a little change to allow the reading record to be sorted, and now
rangi [Wed, 20 Jun 2001 03:36:01 +0000 (03:36 +0000)]
Made a little change to allow the reading record to be sorted, and now
defaults to the last 50 items borrowed

23 years agoChanged the interim field in the items table, to be paidfor
rangi [Thu, 17 May 2001 22:36:07 +0000 (22:36 +0000)]
Changed the interim field in the items table, to be paidfor
The horowhenua librarians wanted a place to store information when a lost
item was paid for. The information is removed if the item is ever returned.
The interim field was a hangover from the previous system and wasnt be used
so I stole it :-)

23 years agoMore little bug fixes in the manual credits section
rangi [Tue, 15 May 2001 23:05:43 +0000 (23:05 +0000)]
More little bug fixes in the manual credits section

23 years agoChanged the way a lost book being returned is handled.
rangi [Wed, 9 May 2001 23:29:00 +0000 (23:29 +0000)]
Changed the way a lost book being returned is handled.
If the book has already been paid for a credit is added to their account.
And offset against any current charges

23 years agoSet up so marking a item lost, adds a charge for the replacement price to a
rangi [Wed, 9 May 2001 23:26:11 +0000 (23:26 +0000)]
Set up so marking a item lost, adds a charge for the replacement price to a
borrowers record (if it is on issue)

23 years agoFixed so renewing a rental item adds a charge
rangi [Wed, 9 May 2001 23:23:52 +0000 (23:23 +0000)]
Fixed so renewing a rental item adds a charge

23 years agoAdded facility to do a cash refund.
rangi [Wed, 9 May 2001 23:22:10 +0000 (23:22 +0000)]
Added facility to do a cash refund.
Also HLT allows ppl to work off their bill,so added a facility to do manual
credit for that

23 years agoRenewing a rental or pay item from the borrowers record screen
rangi [Wed, 9 May 2001 00:05:57 +0000 (00:05 +0000)]
Renewing a rental or pay item from the borrowers record screen
Now adds a charge to the borrowers account

23 years agoSteve Tonnesen's K12Admin-specific (for the time-being) group based
tonnesen [Wed, 2 May 2001 23:06:44 +0000 (23:06 +0000)]
Steve Tonnesen's K12Admin-specific (for the time-being) group based
overdue reports.

23 years agoAdded an overdue variable to the itemdata returned by the currentissues
tonnesen [Wed, 2 May 2001 22:38:26 +0000 (22:38 +0000)]
Added an overdue variable to the itemdata returned by the currentissues
subroutine.  This makes it easier to pick out overdue items in other
modules (ie circulation, reports, etc.)

23 years agoFixed the code that adds a credit or wipes a lost book charge from a
rangi [Wed, 2 May 2001 21:15:22 +0000 (21:15 +0000)]
Fixed the code that adds a credit or wipes a lost book charge from a
borrowers account if said book is returned

23 years agoAdded functions to add credits and invoices to borrowers account
rangi [Wed, 2 May 2001 21:13:15 +0000 (21:13 +0000)]
Added functions to add credits and invoices to borrowers account

23 years agoTurned off the tidy accounts feature in the view accounts screen
rangi [Wed, 2 May 2001 21:11:41 +0000 (21:11 +0000)]
Turned off the tidy accounts feature in the view accounts screen
(boraccount.pl)
And got it so outstanding credits are shown on the moremember.pl (view
member screen)

23 years agoScripts to add manual invoices, or credits to a borrower/member/patron's
rangi [Wed, 2 May 2001 21:08:56 +0000 (21:08 +0000)]
Scripts to add manual invoices, or credits to a borrower/member/patron's
account.
Called from boraccount.pl (ie the view account screen)

23 years agoFixed a bug in the return lost routine (when a payment is made on a lost item)
rangi [Tue, 1 May 2001 23:24:50 +0000 (23:24 +0000)]
Fixed a bug in the return lost routine (when a payment is made on a lost item)
So that the correct date was being recorded

23 years agoQuick bodge to restrict the number of returned books showing to 8.
rangi [Fri, 20 Apr 2001 00:31:02 +0000 (00:31 +0000)]
Quick bodge to restrict the number of returned books showing to 8.
(Request from the librarians here to speed up the screen reload)
Needs to be tidied up

23 years agoAdd functionality so that when the replacement cost of a lost item is paid
rangi [Wed, 18 Apr 2001 02:51:18 +0000 (02:51 +0000)]
Add functionality so that when the replacement cost of a lost item is paid
Its returned off the members/patrons card. And a note is placed on the item
saying that its been paid for.
The item stays marked as lost. But the patron does not accrue more fines

23 years agoMaking a change to the way charges are handled, the system originally worked such...
rangi [Tue, 3 Apr 2001 21:32:37 +0000 (21:32 +0000)]
Making a change to the way charges are handled, the system originally worked such that if a borrower owed more than $5 issues werent allowed. This worked fine except that often borrowers wish to borrows say 3 pay videos at $2 each, then 2 books say. The three pay videos rack up charges of $6 and then they cant issue the books until that is paid.
Reworked so that it cares about previous charges, not the ones accrued during current issue process.

23 years agoReworking statistics for payments and writeoffs
rangi [Mon, 2 Apr 2001 22:51:26 +0000 (22:51 +0000)]
Reworking statistics for payments and writeoffs

23 years agoCommenting out the code that doesnt allow renewals if a renewal has already occured
rangi [Thu, 29 Mar 2001 02:11:36 +0000 (02:11 +0000)]
Commenting out the code that doesnt allow renewals if a renewal has already occured

23 years agoAdding in javscript code to open a new window for payments
rangi [Wed, 28 Mar 2001 03:00:56 +0000 (03:00 +0000)]
Adding in javscript code to open a new window for payments

23 years agoReworked layout of issues section.
rangi [Wed, 28 Mar 2001 02:23:03 +0000 (02:23 +0000)]
Reworked layout of issues section.

23 years agoGetting writeoff stats being stored as well
rangi [Tue, 27 Mar 2001 21:45:50 +0000 (21:45 +0000)]
Getting writeoff stats being stored as well

23 years agoModified the update stats routine to store borrowernumbers also
rangi [Tue, 27 Mar 2001 21:43:37 +0000 (21:43 +0000)]
Modified the update stats routine to store borrowernumbers also
Passing borrowernumbers to update stats from Account routines

23 years agoChanges made by Glen to allow the circulation module to work with a
rangi [Thu, 22 Mar 2001 22:20:29 +0000 (22:20 +0000)]
Changes made by Glen to allow the circulation module to work with a
ASCII-wand, or CueCat (weird encoded) input equally well.

Do not bother installing the CueCat driver or any other software - it's not
needed.

23 years agoScript to list overdue books under the headings
rangi [Sun, 18 Mar 2001 22:06:39 +0000 (22:06 +0000)]
Script to list overdue books under the headings
Due-Date Patron Phone Title Author

The patron can be email by clicking on the name (if the database contains an
email address for them)

Courtesy of Glen Stewart

23 years agoAdded code to allow searches to be used by catalogue maintenance
rangi [Thu, 15 Mar 2001 10:17:33 +0000 (10:17 +0000)]
Added code to allow searches to be used by catalogue maintenance

23 years agoAdded functionality to allow invalid itemtype to be fixed
rangi [Thu, 15 Mar 2001 10:15:51 +0000 (10:15 +0000)]
Added functionality to allow invalid itemtype to be fixed

23 years agoScript to shift a group to another biblio, called as part of catalogue maintenance
rangi [Thu, 15 Mar 2001 10:11:33 +0000 (10:11 +0000)]
Script to shift a group to another biblio, called as part of catalogue maintenance

23 years agoShifted catmaintain.pl to a dir that can be easily passowrd protected
rangi [Tue, 13 Mar 2001 22:41:21 +0000 (22:41 +0000)]
Shifted catmaintain.pl to a dir that can be easily passowrd protected

23 years agoGot undeleting biblios going (catalogue maintenance should probably be in a
rangi [Tue, 13 Mar 2001 22:04:04 +0000 (22:04 +0000)]
Got undeleting biblios going (catalogue maintenance should probably be in a
password protected super librarian area or the like)

23 years agoJust realised this is supposed to be in the acqui/ dir (doh)
rangi [Mon, 12 Mar 2001 23:33:25 +0000 (23:33 +0000)]
Just realised this is supposed to be in the acqui/ dir (doh)

23 years agoGlens updates to automatically increment barcode, and to remove hardcoded itemtypes...
rangi [Mon, 12 Mar 2001 23:32:47 +0000 (23:32 +0000)]
Glens updates to automatically increment barcode, and to remove hardcoded itemtypes in scripts

23 years agoModified to include Glen Stewarts automatic member/patron cardnumber incrementation
rangi [Mon, 12 Mar 2001 23:29:44 +0000 (23:29 +0000)]
Modified to include Glen Stewarts automatic member/patron cardnumber incrementation

23 years agoScript from Glen Stewart, i think to do with simplified acqusitions module?
rangi [Mon, 12 Mar 2001 23:15:09 +0000 (23:15 +0000)]
Script from Glen Stewart, i think to do with simplified acqusitions module?
(correct me if im wrong glen)

23 years agoDatabase definition file, checked into cvs to make keeping database current easier
rangi [Mon, 12 Mar 2001 22:43:47 +0000 (22:43 +0000)]
Database definition file, checked into cvs to make keeping database current easier

23 years agoFixing stupid bug that was causing the sql insert command to break if a person had a '
rangi [Wed, 7 Mar 2001 21:12:47 +0000 (21:12 +0000)]
Fixing stupid bug that was causing the sql insert command to break if a person had a '
in their name

23 years agoChanging the form so it passes through a modify value to tell the script to show...
rangi [Wed, 7 Mar 2001 21:02:48 +0000 (21:02 +0000)]
Changing the form so it passes through a modify value to tell the script to show the flags

23 years agoAdded the functionality to allow librarians to manipulate the flag status on borrowers
rangi [Wed, 7 Mar 2001 01:48:48 +0000 (01:48 +0000)]
Added the functionality to allow librarians to manipulate the flag status on borrowers
ie lost, debarred, and gone no address

23 years agoFixing " glitch in titles
rangi [Tue, 6 Mar 2001 21:16:10 +0000 (21:16 +0000)]
Fixing " glitch in titles

23 years agoFixing a bug in the opac search that meant that titles that contained " were
rangi [Tue, 6 Mar 2001 21:13:00 +0000 (21:13 +0000)]
Fixing a bug in the opac search that meant that titles that contained " were
caused the detail page to error

23 years agoQuick fix to stop ppl from being able to delete biblios that have items attached
rangi [Tue, 27 Feb 2001 22:08:57 +0000 (22:08 +0000)]
Quick fix to stop ppl from being able to delete biblios that have items attached

23 years agoRejigged printing issues, to print out everything on issue to the borrower
rangi [Wed, 21 Feb 2001 22:33:48 +0000 (22:33 +0000)]
Rejigged printing issues, to print out everything on issue to the borrower

23 years agoFixed a little glitch in the daily stats script that meant it wasnt counting renewals
rangi [Wed, 21 Feb 2001 22:27:59 +0000 (22:27 +0000)]
Fixed a little glitch in the daily stats script that meant it wasnt counting renewals

23 years agoGot a link from items on issue thru to item details (like in the circ module)
rangi [Wed, 21 Feb 2001 22:17:58 +0000 (22:17 +0000)]
Got a link from items on issue thru to item details (like in the circ module)
And also stopped already renewed books from being renewable in the issues list

23 years agoLittle fix to the returnbook routine so the correct branchcode is passed to the updat...
rangi [Sun, 18 Feb 2001 22:13:26 +0000 (22:13 +0000)]
Little fix to the returnbook routine so the correct branchcode is passed to the updatestats routine

23 years agoA bodgy hack so that hitting enter in issues (with no barcode) prints out the borrowe...
rangi [Wed, 14 Feb 2001 02:41:43 +0000 (02:41 +0000)]
A bodgy hack so that hitting enter in issues (with no barcode) prints out the borrowers issue slip and starts a new borrower

23 years agoThe Horowhenua libraries wanted less patron and item information displaying at returns
rangi [Wed, 14 Feb 2001 00:29:17 +0000 (00:29 +0000)]
The Horowhenua libraries wanted less patron and item information displaying at returns
So Added some if statements to not display patron addresses, and to only display the title of the item
These presumably would be changed to suit individual libraries wants

23 years agoMade some changes to checkreserve and find_reserves, so that items are always display...
rangi [Wed, 14 Feb 2001 00:27:36 +0000 (00:27 +0000)]
Made some changes to checkreserve and find_reserves, so that items are always displayed as reserved when returned, not just once

23 years agoLittle fix so that if the item has no author information, empty () dont disply
rangi [Sun, 11 Feb 2001 22:44:34 +0000 (22:44 +0000)]
Little fix so that if the item has no author information, empty () dont disply

23 years agoChanging the front page search of the intranet site to just be a keyword search
rangi [Sun, 11 Feb 2001 22:38:17 +0000 (22:38 +0000)]
Changing the front page search of the intranet site to just be a keyword search

23 years agoAdded header and log substition variables
tonnesen [Wed, 7 Feb 2001 23:47:43 +0000 (23:47 +0000)]
Added header and log substition variables

23 years agoStart of code to implement virtual bookshelves in Koha.
tonnesen [Wed, 7 Feb 2001 20:27:16 +0000 (20:27 +0000)]
Start of code to implement virtual bookshelves in Koha.

23 years agoloadmodules.pl allows redirection to different modules based on systemprefs
tonnesen [Mon, 5 Feb 2001 18:48:15 +0000 (18:48 +0000)]
loadmodules.pl allows redirection to different modules based on systemprefs
Added subroutine in Search.pm load systemprefs from new systempreferences
table in database.  Initial use is to allow using my simplified acquisitions
module in place of vendor-based acquisitions module.  Default is vendor-based
module.

23 years agoAdded a couple of missing $dbh->disconnect lines that were logging errors
tonnesen [Mon, 5 Feb 2001 17:47:58 +0000 (17:47 +0000)]
Added a couple of missing $dbh->disconnect lines that were logging errors
in apache log files.

23 years agoFixed backgroundimage in circulation module. Background image now displays
tonnesen [Mon, 5 Feb 2001 17:24:13 +0000 (17:24 +0000)]
Fixed backgroundimage in circulation module.  Background image now displays
only in header lines.

23 years agoFixing printing error, now is printing all of the days issues for borrower
rangi [Sun, 4 Feb 2001 22:25:42 +0000 (22:25 +0000)]
Fixing printing error, now is printing all of the days issues for borrower

23 years agoMade sure the printer queue value was being set before calling print
rangi [Thu, 1 Feb 2001 04:09:11 +0000 (04:09 +0000)]
Made sure the printer queue value was being set before calling print

23 years agoAttempting to get issues slip to print when borrower is finished with
rangi [Thu, 1 Feb 2001 02:08:34 +0000 (02:08 +0000)]
Attempting to get issues slip to print when borrower is finished with