Hi Folks,

 

Swansea University uses fines for not item related material e.g. Inter Library Loans which do not show up using the standard Voyager driver sql select statement:

 

$sql = "SELECT unique FINE_FEE_TYPE.FINE_FEE_DESC, FINE_FEE.FINE_FEE_AMOUNT, FINE_FEE.FINE_FEE_BALANCE, FINE_FEE.ORIG_CHARGE_DATE, FINE_FEE.DUE_DATE, BIB_ITEM.BIB_ID " .

"FROM (($this->dbName.FINE_FEE INNER JOIN $this->dbName.FINE_FEE_TYPE ON FINE_FEE.FINE_FEE_TYPE = FINE_FEE_TYPE.FINE_FEE_TYPE) INNER JOIN $this->dbName.PATRON ON FINE_FEE.PATRON_ID = PATRON.PATRON_ID) INNER JOIN $this->dbName.BIB_ITEM ON FINE_FEE.ITEM_ID = BIB_ITEM.ITEM_ID ".

"WHERE PATRON.PATRON_ID=:id AND FINE_FEE.FINE_FEE_BALANCE > 0";

 

The problem is that as the FINE_FEE>.ITEM_ID field is ‘0’, no match is made in the BIB_ITEM table and the fine is not selected.

 

Does anyone have any ideas for a work around? I could perform a separate select statement for BIB_IDs (if Fine_fee.item_id == 0) but that seems overkill.

 

Cheers,

 

Luke O'Sullivan
Library Systems Officer - Virtual Academic Library
South West Wales Higher Education Partnership (SWWHEP)
Tel: 01792 602772
Website: www.swwhep.ac.uk

Ffn: 01792 602772
Gwefan: www.swwhep.ac.uk

Check out the new SWWHEP Online GreenGuide at:
www.swwhep.ac.uk/en/projects/sustainability