View | Details | Raw Unified | Return to bug 13795
Collapse All | Expand All

(-)a/installer/data/mysql/backfill_statistics.pl (-2 lines)
Lines 24-32 sub get_counts() { Link Here
24
	(SELECT count(*) FROM statistics WHERE branch="NO_LIBRARY"       ) AS NO_LIBRARY,
24
	(SELECT count(*) FROM statistics WHERE branch="NO_LIBRARY"       ) AS NO_LIBRARY,
25
	(SELECT count(*) FROM statistics WHERE branch             IS NULL) AS NULL_BRANCH,
25
	(SELECT count(*) FROM statistics WHERE branch             IS NULL) AS NULL_BRANCH,
26
	(SELECT count(*) FROM statistics WHERE itemtype           IS NULL AND itemnumber IS NOT NULL) AS NULL_ITEMTYPE,
26
	(SELECT count(*) FROM statistics WHERE itemtype           IS NULL AND itemnumber IS NOT NULL) AS NULL_ITEMTYPE,
27
	(SELECT count(*) FROM statistics WHERE usercode           IS NULL) AS NULL_USERCODE,
28
	(SELECT count(*) FROM statistics WHERE borrowernumber     IS NULL) AS NULL_BORROWERNUMBER,
27
	(SELECT count(*) FROM statistics WHERE borrowernumber     IS NULL) AS NULL_BORROWERNUMBER,
29
	(SELECT count(*) FROM statistics WHERE associatedborrower IS NULL) AS NULL_ASSOCIATEDBORROWER,
30
	(SELECT count(*) FROM statistics                                 ) AS Total
28
	(SELECT count(*) FROM statistics                                 ) AS Total
31
	);
29
	);
32
	my $sth = $dbh->prepare($query);
30
	my $sth = $dbh->prepare($query);
(-)a/koha-tmpl/intranet-tmpl/prog/en/columns.def (-2 lines)
Lines 111-117 Link Here
111
<field name="statistics.value">Value</field>
111
<field name="statistics.value">Value</field>
112
<field name="statistics.type">Type</field>
112
<field name="statistics.type">Type</field>
113
<field name="statistics.other"></field>
113
<field name="statistics.other"></field>
114
<field name="statistics.usercode">User code</field>
115
<field name="statistics.itemnumber">Item number</field>
114
<field name="statistics.itemnumber">Item number</field>
116
<field name="statistics.itemtype">Itemtype</field>
115
<field name="statistics.itemtype">Itemtype</field>
117
<field name="statistics.borrowernumber">Borrower number</field>
116
<field name="statistics.borrowernumber">Borrower number</field>
118
- 

Return to bug 13795