3 # Copyright 2008 BibLibre
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along with
17 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
18 # Suite 330, Boston, MA 02111-1307 USA
23 use vars qw($VERSION @ISA @EXPORT);
25 # set the version for version checking
30 # only export API methods
39 # Returns all informations about csv profiles
41 my $dbh = C4::Context->dbh;
42 my $query = "SELECT * FROM export_format";
44 $sth = $dbh->prepare($query);
47 $sth->fetchall_arrayref({});
51 # Returns fields to extract for the given csv profile
52 sub GetMarcFieldsForCsv {
55 my $dbh = C4::Context->dbh;
56 my $query = "SELECT marcfields FROM export_format WHERE export_format_id=?";
58 $sth = $dbh->prepare($query);
61 return ($sth->fetchrow_hashref)->{marcfields};
66 # Returns informations aboout csv profiles suitable for html templates
67 sub GetCsvProfilesLoop {
68 # List of existing profiles
69 my $dbh = C4::Context->dbh;
71 my $query = "SELECT export_format_id, profile FROM export_format";
72 $sth = $dbh->prepare($query);
74 return $sth->fetchall_arrayref({});