From 04c7a8a845fb780c72d412133a4b97056c35301e Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Wed, 30 Dec 2015 18:16:01 +0000
Subject: [PATCH] Bug 15451: Koha::CsvProfiles - Remove GetCsvProfiles

This subroutine did the same job as GetCsvProfilesLoop, so this patch
applies the same changes as the previous patch.

Test plan:
1/ Claim some serials, sql profiles should be listed
2/ Export records using the export tool. MARC profiles should be listed.

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Listed sql & marc profiles
No errors

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

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
---
 C4/Csv.pm         | 17 -----------------
 C4/Record.pm      |  4 ++--
 serials/claims.pl |  8 ++++----
 tools/export.pl   |  3 ++-
 4 files changed, 8 insertions(+), 24 deletions(-)

diff --git a/C4/Csv.pm b/C4/Csv.pm
index 275fb49395..7c8f8249f3 100644
--- a/C4/Csv.pm
+++ b/C4/Csv.pm
@@ -31,29 +31,12 @@ use vars qw(@ISA @EXPORT);
 # only export API methods
 
 @EXPORT = qw(
-  &GetCsvProfiles
   &GetCsvProfile
   &GetCsvProfileId
   &GetMarcFieldsForCsv
 );
 
 
-# Returns all informations about csv profiles
-sub GetCsvProfiles {
-    my ( $type ) = @_;
-    my $dbh = C4::Context->dbh;
-    my $query = "SELECT * FROM export_format";
-    if ( $type ) {
-        $query .= " WHERE type = ?";
-    }
-
-    $sth = $dbh->prepare($query);
-    $sth->execute( $type ? $type : () );
-
-    $sth->fetchall_arrayref({});
-
-}
-
 # Returns all informations about a given csv profile
 sub GetCsvProfile {
     my ($id) = @_;
diff --git a/C4/Record.pm b/C4/Record.pm
index d24d631d66..a3c1e8efdb 100644
--- a/C4/Record.pm
+++ b/C4/Record.pm
@@ -401,7 +401,7 @@ Returns a CSV scalar
 
 C<$biblio> - a list of biblionumbers
 
-C<$csvprofileid> - the id of the CSV profile to use for the export (see export_format.export_format_id and the GetCsvProfiles function in C4::Csv)
+C<$csvprofileid> - the id of the CSV profile to use for the export (see export_format.export_format_id)
 
 C<$itemnumbers> - a list of itemnumbers to export
 
@@ -451,7 +451,7 @@ Returns a CSV scalar
 
 C<$biblio> - a biblionumber
 
-C<$csvprofileid> - the id of the CSV profile to use for the export (see export_format.export_format_id and the GetCsvProfiles function in C4::Csv)
+C<$csvprofileid> - the id of the CSV profile to use for the export (see export_format.export_format_id)
 
 C<$header> - true if the headers are to be printed (typically at first pass)
 
diff --git a/serials/claims.pl b/serials/claims.pl
index 3c5f738f3f..e3a33857b7 100755
--- a/serials/claims.pl
+++ b/serials/claims.pl
@@ -17,8 +17,7 @@
 # You should have received a copy of the GNU General Public License
 # along with Koha; if not, see <http://www.gnu.org/licenses>.
 
-use strict;
-use warnings;
+use Modern::Perl;
 use CGI qw ( -utf8 );
 use C4::Auth;
 use C4::Serials;
@@ -29,7 +28,8 @@ use C4::Letters;
 use C4::Branch;    # GetBranches GetBranchesLoop
 use C4::Koha qw( GetAuthorisedValues );
 use Koha::AdditionalField;
-use C4::Csv qw( GetCsvProfiles );
+use Koha::CsvProfiles;
+use C4::Csv;
 
 my $input = CGI->new;
 
@@ -107,7 +107,7 @@ $template->param(
         claimletter => $claimletter,
         branchloop   => $branchloop,
         additional_fields_for_subscription => $additional_fields,
-        csv_profiles => C4::Csv::GetCsvProfiles( "sql" ),
+        csv_profiles => [ Koha::CsvProfiles->search({ type => 'sql' }) ],
         letters => $letters,
         (uc(C4::Context->preference("marcflavour"))) => 1
         );
diff --git a/tools/export.pl b/tools/export.pl
index 8d80bdd663..f42a70b631 100755
--- a/tools/export.pl
+++ b/tools/export.pl
@@ -28,6 +28,7 @@ use C4::Output;
 
 use Koha::Authority::Types;
 use Koha::Biblioitems;
+use Koha::CsvProfiles;
 use Koha::Database;
 use Koha::DateUtils qw( dt_from_string output_pref );
 use Koha::Exporter::Record;
@@ -309,7 +310,7 @@ else {
         itemtypeloop             => \@itemtypesloop,
         authority_types          => $authority_types,
         export_remove_fields     => C4::Context->preference("ExportRemoveFields"),
-        csv_profiles             => C4::Csv::GetCsvProfiles('marc'),
+        csv_profiles             => [ Koha::CsvProfiles->search({ type => 'marc' }),
     );
 
     output_html_with_http_headers $query, $cookie, $template->output;
-- 
2.39.5