C4/Csv.pm

   1 package C4::Csv;
   2
   3 # Copyright 2008 BibLibre
   4 #
   5 # This file is part of Koha.
   6 #
   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
  10 # version.
  11 #
  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.
  15 #
  16 # You should have received a copy of the GNU General Public License along
  17 # with Koha; if not, write to the Free Software Foundation, Inc.,
  18 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
  19 #
  20 #
  21
  22 #use strict;
  23 #use warnings; FIXME - Bug 2505
  24
  25 use C4::Context;
  26 use vars qw($VERSION @ISA @EXPORT);
  27
  28 # set the version for version checking
  29 $VERSION = 3.07.00.049;
  30
  31 @ISA = qw(Exporter);
  32
  33 # only export API methods
  34
  35 @EXPORT = qw(
  36   &GetCsvProfiles
  37   &GetCsvProfile
  38   &GetCsvProfileId
  39   &GetCsvProfilesLoop
  40   &GetMarcFieldsForCsv
  41 );
  42
  43
  44 # Returns all informations about csv profiles
  45 sub GetCsvProfiles {
  46     my ( $type ) = @_;
  47     my $dbh = C4::Context->dbh;
  48     my $query = "SELECT * FROM export_format";
  49     if ( $type ) {
  50         $query .= " WHERE type = ?";
  51     }
  52
  53     $sth = $dbh->prepare($query);
  54     $sth->execute( $type ? $type : () );
  55
  56     $sth->fetchall_arrayref({});
  57
  58 }
  59
  60 # Returns all informations about a given csv profile
  61 sub GetCsvProfile {
  62     my ($id) = @_;
  63     my $dbh = C4::Context->dbh;
  64     my $query = "SELECT * FROM export_format WHERE export_format_id=?";
  65
  66     $sth = $dbh->prepare($query);
  67     $sth->execute($id);
  68
  69     return ($sth->fetchrow_hashref);
  70 }
  71
  72 # Returns id of csv profile about a given csv profile name
  73 sub GetCsvProfileId {
  74     my ($name)  = @_;
  75     my $dbh   = C4::Context->dbh;
  76     my $query = "SELECT export_format_id FROM export_format WHERE profile=?";
  77
  78     $sth = $dbh->prepare($query);
  79     $sth->execute($name);
  80
  81     return ( $sth->fetchrow );
  82 }
  83
  84 # Returns fields to extract for the given csv profile
  85 sub GetMarcFieldsForCsv {
  86
  87     my ($id) = @_;
  88     my $dbh = C4::Context->dbh;
  89     my $query = "SELECT content FROM export_format WHERE export_format_id=?";
  90
  91     $sth = $dbh->prepare($query);
  92     $sth->execute($id);
  93
  94     return ($sth->fetchrow_hashref)->{content};
  95
  96
  97 }
  98
  99 # Returns informations aboout csv profiles suitable for html templates
 100 sub GetCsvProfilesLoop {
 101     my ( $type ) = @_;
 102     # List of existing profiles
 103     my $dbh = C4::Context->dbh;
 104     my $sth;
 105     my $query = "SELECT export_format_id, profile FROM export_format";
 106     if ( $type ) {
 107         $query .= " WHERE type = ?";
 108     }
 109
 110     $sth = $dbh->prepare($query);
 111     $sth->execute( $type ? $type : () );
 112     return $sth->fetchall_arrayref({});
 113
 114 }
 115
 116
 117
 118 1;