Bug 5347: Adds columns claims_count and claimed_date in aqorders
authorJonathan Druart <jonathan.druart@biblibre.com>
Fri, 2 Dec 2011 13:03:50 +0000 (14:03 +0100)
committerPaul Poulain <paul.poulain@biblibre.com>
Fri, 20 Jan 2012 13:12:27 +0000 (14:12 +0100)
commitb8e9829be5a59c84ba699fc015820cd4eb3fbc0a
tree0c855e53178f924c2424a3a827aac73a400e437d
parentb35233acbfb8125f2a2de5bea22f10ab7a6db25a
Bug 5347: Adds columns claims_count and claimed_date in aqorders

This patch adds 2 columns in the aqorders table :
- claims_count : number of claims for an orders
- claimed_date : date of the lastest claim

In the lateorders.pl table, you can not select orders from different
supplier because there is just one letter sent after clicking the "Claim
order" button. So, it's logic that you want to select only orders from
this supplier.

Modification in C4/Letters.pm:
refactoring code for claimacquisition and claimissues letter type.
Now, fields for theses letters check the table name. It's not possible
to chooce aqorders.title, this field doesn't exist !
Furthermore, you can add a <order> tag around your item fields, like
this :

-- Begin example
<<LibrarianFirstname>>
<<LibrarianSurname>>

<<aqbooksellers.contact>>
<<aqbooksellers.address1>>
<<aqbooksellers.phone>>
<<aqbasket.basketno>>
<<aqbooksellers.phone>>
<order>Library : <<items.homebranch>>
In your possesssion : <<biblio.author>>. <<biblio.title>>.
<<biblioitems.publishercode>>, <<biblioitems.publicationyear>>.
Callnumber : <<items.itemcallnumber>>. doc type : <<items.itype>>
Barcode : <<items.barcode>>
Date for the return : <<items.onloan>>.</order>

<<LibrarianSurname>>
-- End example

Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
19 files changed:
C4/Acquisition.pm
C4/Letters.pm
acqui/lateorders.pl
installer/data/mysql/de-DE/mandatory/sample_notices.sql
installer/data/mysql/en/mandatory/sample_notices.sql
installer/data/mysql/es-ES/mandatory/sample_notices.sql
installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
installer/data/mysql/it-IT/necessari/notices.sql
installer/data/mysql/kohastructure.sql
installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
installer/data/mysql/pl-PL/mandatory/sample_notices.sql
installer/data/mysql/ru-RU/mandatory/sample_notices.sql
installer/data/mysql/ru-RU/optional/sample_notices.sql
installer/data/mysql/uk-UA/mandatory/sample_notices.sql
installer/data/mysql/uk-UA/optional/sample_notices.sql
installer/data/mysql/updatedatabase.pl
koha-tmpl/intranet-tmpl/prog/en/css/staff-global.css
koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt
tools/letter.pl