3 # Copyright 2008 BibLibre
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
23 #use warnings; FIXME - Bug 2505
26 use vars qw(@ISA @EXPORT);
28 # set the version for version checking
32 # only export API methods
43 # Returns all informations about csv profiles
46 my $dbh = C4::Context->dbh;
47 my $query = "SELECT * FROM export_format";
49 $query .= " WHERE type = ?";
52 $sth = $dbh->prepare($query);
53 $sth->execute( $type ? $type : () );
55 $sth->fetchall_arrayref({});
59 # Returns all informations about a given csv profile
62 my $dbh = C4::Context->dbh;
63 my $query = "SELECT * FROM export_format WHERE export_format_id=?";
65 $sth = $dbh->prepare($query);
68 return ($sth->fetchrow_hashref);
71 # Returns id of csv profile about a given csv profile name
74 my $dbh = C4::Context->dbh;
75 my $query = "SELECT export_format_id FROM export_format WHERE profile=?";
77 $sth = $dbh->prepare($query);
80 return ( $sth->fetchrow );
83 # Returns fields to extract for the given csv profile
84 sub GetMarcFieldsForCsv {
87 my $dbh = C4::Context->dbh;
88 my $query = "SELECT content FROM export_format WHERE export_format_id=?";
90 $sth = $dbh->prepare($query);
93 return ($sth->fetchrow_hashref)->{content};
98 # Returns informations aboout csv profiles suitable for html templates
99 sub GetCsvProfilesLoop {
101 # List of existing profiles
102 my $dbh = C4::Context->dbh;
104 my $query = "SELECT export_format_id, profile FROM export_format";
106 $query .= " WHERE type = ?";
109 $sth = $dbh->prepare($query);
110 $sth->execute( $type ? $type : () );
111 return $sth->fetchall_arrayref({});