Bug 8612: Use CSV profile for exporting basket
authorBlou <philippe.blouin@inlibro.com>
Thu, 26 Mar 2015 20:07:44 +0000 (16:07 -0400)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 5 Jun 2017 15:02:08 +0000 (12:02 -0300)
commit3c83e117869e501275fffc88ac10c9e1aee92160
treeb8bea2c4be5d2ebf45a3b3cab24b42156b53dc10
parentfbade9e587b349449a50e6d6ba78309533268e51
Bug 8612: Use CSV profile for exporting basket

This patch allows the user to use a CSV export profile to create the fields to export the basket as CSV in a basket page.

Test plan:
1) Apply the patch
2) Go to Tools › CSV export profiles and create a profile of type "SQL for basket export in acquisition"
  example:
  biblionumber=biblio.biblionumber|auteur=biblio.author|titre=biblio.title|date=biblioitems.copyrightdate|editeur=biblioitems.publishercode|isbn=biblioitems.isbn|quantite=aqorders.quantity|prix=aqorders.rrp|panier=aqorders.basketno
3) In acquisition module, create a new basket and add an order to the basket
4) On basket detail page, there should be the split button labelled "Export to CSV"
5) Try to use the button and export CSV with your CSV profile you defined in step 2
6) Validate the CSV file.
7) Repeat 4-6 with a closed basket.
    a) close the basket
    b) View the basket
    c) validate that there is an export button
    d) test it with an export
8) prove t/db_dependent/Acquisition/GetBasketAsCSV.t t/db_dependent/Koha/CsvProfiles.t

Initial work:

Sponsored by: CCSR

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: mehdi <mehdi.hamidi@inlibro.com>

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
C4/Acquisition.pm
acqui/basket.pl
installer/data/mysql/atomicupdate/bug_8612.sql [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/modules/acqui/basket.tt
koha-tmpl/intranet-tmpl/prog/en/modules/tools/csv-profiles.tt
serials/claims.pl
t/db_dependent/Acquisition/GetBasketAsCSV.t [new file with mode: 0644]
t/db_dependent/Koha/CsvProfiles.t