accounttype => { -in => [ 'L', 'Rep', 'W' ] },
},
{
- order_by => { -desc => [ 'date' ] }
+ order_by => { -desc => [ 'date', 'accountlines_id' ] }
}
);
}
my $sql =
- "DELETE FROM accountlines WHERE accountlines_id = ? LIMIT 1";
+ "DELETE FROM accountlines WHERE accountlines_id = ?";
$dbh->do( $sql, undef, $f->{'accountlines_id'} );
}
if ($has_changed) {
my $sql =
- "UPDATE accountlines SET amountoutstanding = ? WHERE accountlines_id = ? LIMIT 1";
+ "UPDATE accountlines SET amountoutstanding = ? WHERE accountlines_id = ?";
$dbh->do(
$sql, undef,
$keeper->{'amountoutstanding'}, $keeper->{'accountlines_id'}
use C4::Stats;
use Koha::Database;
-use Test::More tests => 18;
+use Test::More tests => 19;
BEGIN {
use_ok('C4::Stats');
is ($params->{itemtype}, $line->{itemtype}, "UpdateStats save itemtype param in itemtype field of statistics table");
is ($params->{location}, $line->{location}, "UpdateStats save location param in location field of statistics table");
is ($params->{ccode}, $line->{ccode}, "UpdateStats save ccode param in ccode field of statistics table");
+is (undef, $line->{proccode}, "UpdateStats save no proccode param in proccode field of statistics table");
$dbh->do(q|DELETE FROM statistics|);
$params = {