---

From: "koha-request@lists.katipo.co.nz" <koha-request@lists.katipo.co.nz>
To: koha@lists.katipo.co.nz
Sent: Thursday, 20 October 2011 10:00 AM
Subject: Koha Digest, Vol 72, Issue 42

Send Koha mailing list submissions to
    koha@lists.katipo.co.nz

To subscribe or unsubscribe via the World Wide Web, visit
    http://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
    koha-request@lists.katipo.co.nz

You can reach the person managing the list at
    koha-owner@lists.katipo.co.nz

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha digest..."


Today's Topics:

  1. Re: report help - total amount writeoff (Wagner, Jane)
  2. Re: Additional packages for install_misc/debian.packages
      (Robin Sheat)


----------------------------------------------------------------------

Message: 1
Date: Wed, 19 Oct 2011 15:24:58 -0400
From: "Wagner, Jane" <jwagner@liblime.com>
To: Peel Lisa <lisa.peel@ritz.edu>, koha@lists.katipo.co.nz
Subject: Re: [Koha] report help - total amount writeoff
Message-ID: <3ab247946ba96552813c39184520130a@mail.gmail.com>
Content-Type: text/plain; charset="windows-1252"

Try something like this:



SELECT round(Sum(accountlines.amount),2) AS 'Writeoffs Last 3 Months' FROM
accountlines WHERE accounttype = 'W' and date like
concat(date_format(LAST_DAY(now() - interval 3 month),'%Y-%m-%'))



(haven?t tested this variant, but I run similar reports for 1 month and
payments)



Jane Wagner

Senior Project Manager

LibLime, a division of PTFS

Content Management and Library Solutions

11501 Huff Court

North Bethesda, MD  20895

(301) 654-8088 x 151

jwagner@liblime.com <jwagner@ptfs.com>



*From:* koha-bounces@lists.katipo.co.nz [mailto:
koha-bounces@lists.katipo.co.nz] *On Behalf Of *Peel Lisa
*Sent:* Wednesday, October 19, 2011 3:08 PM
*To:* 'koha@lists.katipo.co.nz'
*Subject:* [Koha] report help - total amount writeoff



Hello



Report help again I am afraid!



Could anyone supply me with the SQL for a report which will show me the
amount of fines being written off at a specific library for a given period
of time (for example the last three months?)



Regards and thanks in advance



Lisa





[image: Description: Description: Description: CR_logo_POS_COULEUR b]**

* *

* *

*LISA PEEL, PGDip, MA.***

Librarian

C?sar Ritz Colleges Switzerland

1897 Le Bouveret - Switzerland

Tel: +41 24 482 82 82 Fax: +41 24 482 82 80

E-mail: *lisa.peel@ritz.edu <hortense.hofer@ritz.edu>*

http://www.ritz.edu - http://www.culinaryarts.ch
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111019/25987bec/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4030 bytes
Desc: not available
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111019/25987bec/attachment-0001.jpg>

------------------------------

Message: 2
Date: Thu, 20 Oct 2011 11:04:42 +1300
From: Robin Sheat <robin@catalyst.net.nz>
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Additional packages for
    install_misc/debian.packages
Message-ID: <1319061882.28975.5.camel@zarathud>
Content-Type: text/plain; charset="utf-8"

Eduardo Tr?pani schreef op wo 19-10-2011 om 10:56 [-0200]:
> Right now libcgi-session-driver-memcached-perl is available on
> testing[1], not on stable.  But you can download it from here[2] and
> install it manually, there are no dependency problems.

You'll also find it (and libgravatar-url-perl, which is too old in
Debian stable, I think) in the Koha debian repository at
http://debian.koha-community.org/

--
Robin Sheat
Catalyst IT Ltd.
? +64 4 803 2204
GPG: 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111020/cdaf8807/attachment-0001.pgp>

------------------------------

_______________________________________________
Koha mailing list
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


End of Koha Digest, Vol 72, Issue 42
************************************