rangi [Wed, 3 Apr 2002 08:44:23 +0000 (08:44 +0000)]
More work on the addbooks scripts, committing on behalf of Roger
Need testing before use in a production environment
rangi [Sun, 31 Mar 2002 06:50:08 +0000 (06:50 +0000)]
Fixed the holding branch insertion code. It was inserting the correct
homebranch but was still inserting the wrong home branch
rangi [Sun, 31 Mar 2002 02:48:18 +0000 (02:48 +0000)]
Fixing branches
rangi [Sun, 31 Mar 2002 01:18:36 +0000 (01:18 +0000)]
Draws list of branches from the branches table now, when adding an item
rangi [Wed, 27 Mar 2002 00:02:40 +0000 (00:02 +0000)]
Shifting writeoff code back into pay.pl (redirecting to writeoff.pl was
breaking when the borrower owes a lot of fines)
finlayt [Tue, 26 Mar 2002 05:08:52 +0000 (05:08 +0000)]
added database patchs to the updater/updatedatabase script
changes the type of the datesent and datearrived fields in the
branchtransfers table from date to datetime.
completely re-organises the branchcategories table. As this has previously
been unused it shouldnt effect anyone.
rangi [Thu, 21 Mar 2002 21:24:54 +0000 (21:24 +0000)]
Doesnt write to an include anymore
tipaul [Tue, 19 Mar 2002 15:39:31 +0000 (15:39 +0000)]
Script to apply to sample DB only. It makes a few modifications in the DB (indexes creation, some data deletion, and unused tables drop)
Creates a thesaurus table from the bilbiosubject one
tipaul [Tue, 19 Mar 2002 15:37:15 +0000 (15:37 +0000)]
Sample database only for parameters tables
rangi [Sun, 17 Mar 2002 02:58:00 +0000 (02:58 +0000)]
Deals with lost book charges now
rangi [Sun, 17 Mar 2002 02:31:02 +0000 (02:31 +0000)]
tidied up, less hlt specific now
finlayt [Thu, 14 Mar 2002 01:51:16 +0000 (01:51 +0000)]
Changed heading to look like the rest of Koha
finlayt [Thu, 14 Mar 2002 01:50:17 +0000 (01:50 +0000)]
Added a heading to be consistent with rest of Koha
finlayt [Thu, 14 Mar 2002 01:04:00 +0000 (01:04 +0000)]
This is the begining of a process of dividing up circulation.pl
This script deals with the branch and printer selection stuff
finlayt [Wed, 13 Mar 2002 21:13:42 +0000 (21:13 +0000)]
Added a transferbook subroutine that is called from /circ/branchtransfers.pl
It writes a new line in the branchtransfers table and changes the
currentbranch field in items.
finlayt [Wed, 13 Mar 2002 21:07:41 +0000 (21:07 +0000)]
Fixed a small problem in the <form>, not hidden inputs are getting passed
correctly.
rangi [Wed, 13 Mar 2002 07:46:43 +0000 (07:46 +0000)]
Removing reference to the FrontSearch subroutine as its never called
rangi [Wed, 13 Mar 2002 07:36:49 +0000 (07:36 +0000)]
Tidy up, removing deprecated routines
rangi [Wed, 13 Mar 2002 07:14:27 +0000 (07:14 +0000)]
Deprecated searching is all handled by search.pl
rangi [Wed, 13 Mar 2002 03:26:43 +0000 (03:26 +0000)]
Getting Iteminfo in Search to only display correct reserves (mainly used on
detail.pl) and another typo fix in moremember.pl
rangi [Wed, 13 Mar 2002 02:46:07 +0000 (02:46 +0000)]
Typo fix (doh!)
rangi [Wed, 13 Mar 2002 02:03:56 +0000 (02:03 +0000)]
Fix so that reserves are only showing for the biblioitem not the biblio on
the moremembers screen
finlayt [Tue, 12 Mar 2002 21:04:32 +0000 (21:04 +0000)]
Branchtransfers.pl provides a form for entering barcodes and selecting a
destination branch.
New rows are entered into the branchtransfers table for each item
"transfered".
rangi [Mon, 11 Mar 2002 03:36:41 +0000 (03:36 +0000)]
Fix for manual invoices
tipaul [Tue, 5 Mar 2002 20:48:42 +0000 (20:48 +0000)]
scripts to manage parameters tables
rangi [Tue, 26 Feb 2002 09:31:14 +0000 (09:31 +0000)]
Fixed apostrophe ' handling
rangi [Tue, 26 Feb 2002 09:06:19 +0000 (09:06 +0000)]
Fix for displaying prices
rangi [Wed, 20 Feb 2002 21:05:19 +0000 (21:05 +0000)]
Making a "fix" to normal title search
rangi [Wed, 20 Feb 2002 20:53:29 +0000 (20:53 +0000)]
Playing with keyword search trying to speed it up more
rangi [Tue, 12 Feb 2002 21:31:41 +0000 (21:31 +0000)]
Fixing bug in subject searching that was causing subjects with ' to break
the search
rangi [Tue, 12 Feb 2002 21:07:21 +0000 (21:07 +0000)]
Fixing bug that was duplicating additional authors, and a bug that was
breaking the updating classicification field
tonnesen [Fri, 1 Feb 2002 18:00:28 +0000 (18:00 +0000)]
Changes from a long time ago that I don't even remember anymore. :)
rangi [Wed, 12 Dec 2001 02:31:28 +0000 (02:31 +0000)]
Added the facility to restrict a keyword search by dewey number
rangi [Tue, 27 Nov 2001 02:01:39 +0000 (02:01 +0000)]
Fixing error in keyword search (fixing my mistake from yesterday)
rangi [Mon, 26 Nov 2001 04:33:42 +0000 (04:33 +0000)]
Fixing a bug in keyword search was duplicating results
rangi [Mon, 26 Nov 2001 02:03:23 +0000 (02:03 +0000)]
Modify an adult with guarantees now modifies the guarantees also.
IE change of address effects the guarantees record as well
rangi [Mon, 26 Nov 2001 00:41:34 +0000 (00:41 +0000)]
Added a findguarantor routine to search for the guarantor of a given borrower.
Probably it and findgurantees need to moved out to borrowers.pm
rangi [Sun, 25 Nov 2001 22:25:55 +0000 (22:25 +0000)]
Author combined with Title search was not searching the series title field
Fixed now
rangi [Sun, 25 Nov 2001 20:17:53 +0000 (20:17 +0000)]
Fixing reserve handling.
Mulitple copy reserves now handled correctly, and correct charges are being
applied
rangi [Fri, 23 Nov 2001 02:12:48 +0000 (02:12 +0000)]
Adding the facility to search on just dewey and class
tonnesen [Mon, 19 Nov 2001 23:28:59 +0000 (23:28 +0000)]
Added code to determine mysqld version for possibility of converting
databases to MyISAM format
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.
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.
tonnesen [Tue, 6 Nov 2001 18:25:30 +0000 (18:25 +0000)]
Minor changes
tonnesen [Tue, 6 Nov 2001 18:24:54 +0000 (18:24 +0000)]
Script that I'm using to check MARC record support.
tonnesen [Tue, 6 Nov 2001 18:15:34 +0000 (18:15 +0000)]
Working out problems with MARC record support.
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.
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.
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.
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.
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. :)
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.
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.
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.
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.
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.
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.
tonnesen [Fri, 5 Oct 2001 21:23:22 +0000 (21:23 +0000)]
Removed duplicate viewmarc.pl from acqui.simple directory
tonnesen [Fri, 5 Oct 2001 21:19:29 +0000 (21:19 +0000)]
Added simple acquisitions script
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.
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.
tonnesen [Thu, 27 Sep 2001 19:24:18 +0000 (19:24 +0000)]
Started on updateItem subroutine.
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
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
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
pawelzc [Thu, 12 Jul 2001 11:12:11 +0000 (11:12 +0000)]
Spelling and english language corrections.
rangi [Thu, 5 Jul 2001 21:37:59 +0000 (21:37 +0000)]
Script to delete a member/patron
rangi [Thu, 5 Jul 2001 21:37:15 +0000 (21:37 +0000)]
Fix to handle the delete call, redirects to deletemem.pl
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
tonnesen [Tue, 26 Jun 2001 22:27:12 +0000 (22:27 +0000)]
Finished updateBiblioItem subroutine
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
tonnesen [Tue, 26 Jun 2001 21:13:01 +0000 (21:13 +0000)]
newBiblio subroutine completed.
tonnesen [Tue, 26 Jun 2001 20:17:35 +0000 (20:17 +0000)]
Added biblioitems table update when newBiblioItem() routine is called.
tonnesen [Tue, 26 Jun 2001 17:15:13 +0000 (17:15 +0000)]
Beginning updateBiblio routine.
tonnesen [Mon, 25 Jun 2001 20:15:44 +0000 (20:15 +0000)]
Prototype marc record viewer and editor.
tonnesen [Mon, 25 Jun 2001 20:12:02 +0000 (20:12 +0000)]
A TODO file for MARC support
tonnesen [Mon, 25 Jun 2001 19:43:59 +0000 (19:43 +0000)]
Added skeletons of update routines.
tonnesen [Mon, 25 Jun 2001 19:07:20 +0000 (19:07 +0000)]
Minor documentation changes.
tonnesen [Mon, 25 Jun 2001 18:55:28 +0000 (18:55 +0000)]
Perl script to convert existing Koha tables to the new MARC tables.
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. :)
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.
tonnesen [Mon, 25 Jun 2001 18:49:34 +0000 (18:49 +0000)]
Cataloguing API. Very early draft at this point.
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
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 :-)
rangi [Tue, 15 May 2001 23:05:43 +0000 (23:05 +0000)]
More little bug fixes in the manual credits section
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
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)
rangi [Wed, 9 May 2001 23:23:52 +0000 (23:23 +0000)]
Fixed so renewing a rental item adds a charge
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
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
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.
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.)
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
rangi [Wed, 2 May 2001 21:13:15 +0000 (21:13 +0000)]
Added functions to add credits and invoices to borrowers account
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)
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)
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
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
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
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.