From 04c7a8a845fb780c72d412133a4b97056c35301e Mon Sep 17 00:00:00 2001 From: Jonathan Druart 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 Listed sql & marc profiles No errors Signed-off-by: Marcel de Rooy Signed-off-by: Kyle M Hall --- 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 . -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