[Koha-bugs] [Bug 13707] New: Adding a new column datereceived for items and biblioitems

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13707

            Bug ID: 13707
           Summary: Adding a new column datereceived for items and
                    biblioitems
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Database
          Assignee: gmcharlt at gmail.com
          Reporter: olli-antti.kivilahti at jns.fi
        QA Contact: testopia at bugs.koha-community.org

This column tells when the Item or Biblio has been received for the first time
into a library.
Date-of-acquisition (dateaccessioned) answers, when the Item has been ordered.
Date-of-receival (datereceived) answers, when the Item has arrived to the
library or when the first Item for the Biblio has for the first time arrived to
the library.
This is very useful regarding statistics of acquisitions if they are based on
the date received instead of the date acquired.
Also other cool stuff can be built on top of it, like better searches for new
material.

This patch adds new DB columns items.datereceived, biblioitems.datereceived,
deleteditems.datereceived, deletedbiblioitems.datereceived
and populates those columns from the acorders.datereceived if the Item has been
acquired using the acquisitions module, or from the
items.dateaccessioned-column if no acquisitions module has been used.
Biblioitems.datereceived is always the oldest timestamp from all the Items the
Biblio has.

-- 
You are receiving this mail because:
You are watching all bug changes.