Get fields form syspref 'StatisticsFields'
Returns list of valid fields, defaults to 'location|itype|ccode'
if syspref is empty or does not contain valid fields
-=cut
+=cut
sub get_fields {
if ( $syspref ) {
my @ret;
my @spfields = split ('\|', $syspref);
- my $dbh=C4::Context->dbh;
- my $sth = $dbh->prepare('SHOW COLUMNS FROM items');
- $sth->execute;
- my $dbfields = $sth->fetchall_hashref('Field');
- $sth->finish();
+ my $schema = Koha::Database->new()->schema();
+ my @columns = $schema->source('Item')->columns;
foreach my $fn ( @spfields ) {
- push ( @ret, $fn ) if ( $dbfields->{ $fn } );
+ push ( @ret, $fn ) if ( grep(/^$fn$/, @columns) );
}
$ret = join( '|', @ret);
}
=head2 construct_query
Build a sql query from a subquery
Adds statistics fields to the select and the group by clause
+
=cut
+
sub construct_query {
my $count = shift;
my $subquery = shift;
=head2 GetTotalIssuesTodayByBorrower
Return total issues for a borrower at this current day
+
=cut
+
sub GetTotalIssuesTodayByBorrower {
my ($borrowernumber) = @_;
my $dbh = C4::Context->dbh;
=head2 GetTotalIssuesReturnedTodayByBorrower
Return total issues returned by a borrower at this current day
+
=cut
+
sub GetTotalIssuesReturnedTodayByBorrower {
my ($borrowernumber) = @_;
my $dbh = C4::Context->dbh;
=head2 GetPrecedentStateByBorrower
Return the precedent state (before today) for a borrower of his checkins and checkouts
+
=cut
+
sub GetPrecedentStateByBorrower {
my ($borrowernumber) = @_;
my $dbh = C4::Context->dbh;