# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
#
-# You should have received a copy of the GNU General Public License along with
-# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
-# Suite 330, Boston, MA 02111-1307 USA
+# You should have received a copy of the GNU General Public License along
+# with Koha; if not, write to the Free Software Foundation, Inc.,
+# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
use strict;
use warnings;
my @filters = $input->param("Filter");
my $output = $input->param("output");
my $basename = $input->param("basename") || 'catalogue_out';
-my $mime = $input->param("MIME");
my ($template, $borrowernumber, $cookie) = get_template_and_user({
template_name => "reports/catalogue_out.tmpl",
query => $input,
type => "intranet",
authnotrequired => 0,
- flagsrequired => {reports => 1},
+ flagsrequired => {reports => '*'},
debug => 1,
});
}
print $sep.@$results[0]->{total};
}
- exit(1); # in either case, exit after do_it
+ exit; # in either case, exit after do_it
}
# Displaying choices (i.e., not do_it)
my @values;
my %select;
-my @mime = ( map { +{type =>$_} } (split /[;:]/,C4::Context->preference("MIME")) );
+my @mime = ( map { +{type =>$_} } (split /[;:]/, 'CSV') ); # FIXME translation
my $itemtypes = GetItemTypes;
my @itemtypeloop;
foreach (sort {$itemtypes->{$a}->{description} cmp $itemtypes->{$b}->{description}} keys %$itemtypes) {
# preparing calculation
my @exe_args = ();
my $query = "
- SELECT items.barcode as barcode,
- items.homebranch as branch,
+ SELECT items.barcode as barcode,
+ items.homebranch as branch,
items.itemcallnumber as itemcallnumber,
- biblio.title as title,
+ biblio.title as title,
biblio.biblionumber as biblionumber,
- biblio.author as author";
+ biblio.author as author";
($column) and $query .= ",\n$column as col ";
$query .= "
FROM items
- LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber
- LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber
- LEFT JOIN old_issues ON old_issues.itemnumber = items.itemnumber
- WHERE old_issues.itemnumber IS NULL
+ LEFT JOIN biblio USING (biblionumber)
+ LEFT JOIN issues USING (itemnumber)
+ LEFT JOIN old_issues USING (itemnumber)
+ WHERE issues.itemnumber IS NULL
+ AND old_issues.itemnumber IS NULL
";
if ($filters->[0]) {
$filters->[0]=~ s/\*/%/g;
push @exe_args, $filters->[0];
- $query .= " AND items.homebranch LIKE ?";
+ $query .= " AND items.homebranch LIKE ?";
}
if ($filters->[1]) {
$filters->[1]=~ s/\*/%/g;
push @exe_args, $filters->[1];
- $query .= " AND biblioitems.itemtype LIKE ?";
+ $query .= " AND items.itype LIKE ?";
}
if ($column) {
$query .= " AND $column = ? GROUP BY items.itemnumber, $column "; # placeholder handled below