use vars qw($VERSION @ISA @EXPORT);
# set the version for version checking
-$VERSION = 0.01;
+$VERSION = 3.07.00.049;
=head1 NAME
$sth = $dbh->prepare("INSERT INTO collections ( colId, colTitle, colDesc )
VALUES ( NULL, ?, ? )");
$sth->execute( $title, $description ) or return ( 0, 3, $sth->errstr() );
- $sth->finish;
return 1;
colTitle = ?, colDesc = ?
WHERE colId = ?");
$sth->execute( $title, $description, $colId ) or return ( 0, 4, $sth->errstr() );
- $sth->finish;
return 1;
$sth = $dbh->prepare("DELETE FROM collections WHERE colId = ?");
$sth->execute( $colId ) or return ( 0, 4, $sth->errstr() );
- $sth->finish;
return 1;
}
push( @results , $row );
}
- $sth->finish;
-
return \@results;
}
push( @results , $row );
}
- $sth->finish;
-
return \@results;
}
my $row = $sth->fetchrow_hashref;
- $sth->finish;
-
return (
$$row{'colId'},
$$row{'colTitle'},
my $dbh = C4::Context->dbh;
my $sth;
- $sth = $dbh->prepare("INSERT INTO collections_tracking ( ctId, colId, itemnumber )
+ $sth = $dbh->prepare("INSERT INTO collections_tracking ( collections_tracking_id, colId, itemnumber )
VALUES ( NULL, ?, ? )");
$sth->execute( $colId, $itemnumber ) or return ( 0, 3, $sth->errstr() );
- $sth->finish;
return 1;
$sth = $dbh->prepare("DELETE FROM collections_tracking
WHERE itemnumber = ?");
$sth->execute( $itemnumber ) or return ( 0, 3, $sth->errstr() );
- $sth->finish;
return 1;
}
colBranchcode = ?
WHERE colId = ?");
$sth->execute( $colBranchcode, $colId ) or return ( 0, 4, $sth->errstr() );
- $sth->finish;
$sth = $dbh->prepare("SELECT barcode FROM items, collections_tracking
WHERE items.itemnumber = collections_tracking.itemnumber
while ( my $item = $sth->fetchrow_hashref ) {
my ( $dotransfer, $messages, $iteminformation ) = transferbook( $colBranchcode, $item->{'barcode'}, my $ignore_reserves = 1);
}
-
-
return 1;
}
my $row = $sth->fetchrow_hashref;
- $sth->finish;
-
return (
$$row{'holdingbranch'},
$$row{'colBranchcode'},
my $row = $sth->fetchrow_hashref;
$itemnumber = $row->{itemnumber};
- $sth->finish;
-
if ( $itemnumber ) {
return 1;
} else {