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

(-)a/C4/Reports/Guided.pm (-17 / +21 lines)
Lines 834-856 sub get_sql { Link Here
834
}
834
}
835
835
836
sub _get_column_defs {
836
sub _get_column_defs {
837
	my ($cgi) = @_;
837
    my ($cgi) = @_;
838
	my %columns;
838
    my %columns;
839
	my $columns_def_file = "columns.def";
839
    my $columns_def_file = "columns.def";
840
	my $htdocs = C4::Context->config('intrahtdocs');                       
840
    my $htdocs = C4::Context->config('intrahtdocs');
841
	my $section='intranet';
841
    my $section = 'intranet';
842
    my ($theme, $lang, $availablethemes) = C4::Templates::themelanguage($htdocs, $columns_def_file, $section,$cgi);
842
843
843
    # We need the theme and the lang
844
	my $full_path_to_columns_def_file="$htdocs/$theme/$lang/$columns_def_file";    
844
    # Since columns.def is not in the modules directory, we cannot sent it for the $tmpl var
845
	open (COLUMNS,$full_path_to_columns_def_file);
845
    my ($theme, $lang, $availablethemes) = C4::Templates::themelanguage($htdocs, 'about.tt', $section, $cgi);
846
	while (my $input = <COLUMNS>){
846
847
		chomp $input;
847
    my $full_path_to_columns_def_file="$htdocs/$theme/$lang/$columns_def_file";
848
		my @row =split(/\t/,$input);
848
    open (my $fh, $full_path_to_columns_def_file);
849
		$columns{$row[0]}= $row[1];
849
    while ( my $input = <$fh> ){
850
	}
850
        chomp $input;
851
851
        if ( $input =~ m|<field name="(.*)">(.*)</field>| ) {
852
	close COLUMNS;
852
            my ( $field, $translation ) = ( $1, $2 );
853
	return \%columns;
853
            $columns{$field} = $translation;
854
        }
855
    }
856
    close $fh;
857
    return \%columns;
854
}
858
}
855
859
856
=head2 build_authorised_value_list($authorised_value)
860
=head2 build_authorised_value_list($authorised_value)
(-)a/koha-tmpl/intranet-tmpl/prog/en/columns.def (-141 / +141 lines)
Lines 1-141 Link Here
1
borrowers.borrowernumber	Borrower number
1
<field name="borrowers.borrowernumber">Borrower number</field>
2
borrowers.title	Salutation
2
<field name="borrowers.title">Salutation</field>
3
borrowers.surname	Surname
3
<field name="borrowers.surname">Surname</field>
4
borrowers.firstname	First name
4
<field name="borrowers.firstname">First name</field>
5
borrowers.dateofbirth	Date of birth
5
<field name="borrowers.dateofbirth">Date of birth</field>
6
borrowers.initials	Initials
6
<field name="borrowers.initials">Initials</field>
7
borrowers.othernames	Other name
7
<field name="borrowers.othernames">Other name</field>
8
borrowers.sex	Gender
8
<field name="borrowers.sex">Gender</field>
9
borrowers.relationship	Relationship
9
<field name="borrowers.relationship">Relationship</field>
10
borrowers.guarantorid	Guarantor borrower number
10
<field name="borrowers.guarantorid">Guarantor borrower number</field>
11
borrowers.streetnumber	Street number
11
<field name="borrowers.streetnumber">Street number</field>
12
borrowers.streettype	Street type
12
<field name="borrowers.streettype">Street type</field>
13
borrowers.address	Address
13
<field name="borrowers.address">Address</field>
14
borrowers.address2	Address 2
14
<field name="borrowers.address2">Address 2</field>
15
borrowers.city	City
15
<field name="borrowers.city">City</field>
16
borrowers.state	State
16
<field name="borrowers.state">State</field>
17
borrowers.zipcode	Zip/postal code
17
<field name="borrowers.zipcode">Zip/postal code</field>
18
borrowers.country	Country
18
<field name="borrowers.country">Country</field>
19
borrowers.phone	Primary phone
19
<field name="borrowers.phone">Primary phone</field>
20
borrowers.phonepro	Secondary phone
20
<field name="borrowers.phonepro">Secondary phone</field>
21
borrowers.mobile	Other phone
21
<field name="borrowers.mobile">Other phone</field>
22
borrowers.email	Primary email
22
<field name="borrowers.email">Primary email</field>
23
borrowers.emailpro	Secondary email
23
<field name="borrowers.emailpro">Secondary email</field>
24
borrowers.fax	Fax
24
<field name="borrowers.fax">Fax</field>
25
borrowers.B_streetnumber	Alternate address: Street number
25
<field name="borrowers.B_streetnumber">Alternate address: Street number</field>
26
borrowers.B_streettype	Alternate address: Street type
26
<field name="borrowers.B_streettype">Alternate address: Street type</field>
27
borrowers.B_address	Alternate address: Address
27
<field name="borrowers.B_address">Alternate address: Address</field>
28
borrowers.B_address2	Alternate address: Address 2
28
<field name="borrowers.B_address2">Alternate address: Address 2</field>
29
borrowers.B_city	Alternate address: City
29
<field name="borrowers.B_city">Alternate address: City</field>
30
borrowers.B_state	Alternate address: State
30
<field name="borrowers.B_state">Alternate address: State</field>
31
borrowers.B_zipcode	Alternate address: Zip/postal code
31
<field name="borrowers.B_zipcode">Alternate address: Zip/postal code</field>
32
borrowers.B_country	Alternate address: Country
32
<field name="borrowers.B_country">Alternate address: Country</field>
33
borrowers.B_phone	Alternate address: Phone
33
<field name="borrowers.B_phone">Alternate address: Phone</field>
34
borrowers.B_email	Alternate address: Email
34
<field name="borrowers.B_email">Alternate address: Email</field>
35
borrowers.contactnote	Alternate contact: Note
35
<field name="borrowers.contactnote">Alternate contact: Note</field>
36
borrowers.altcontactfirstname	Alternate contact: Last name
36
<field name="borrowers.altcontactfirstname">Alternate contact: Last name</field>
37
borrowers.altcontactsurname	Alternate contact: First name
37
<field name="borrowers.altcontactsurname">Alternate contact: First name</field>
38
borrowers.altcontactaddress1	Alternate contact: Address
38
<field name="borrowers.altcontactaddress1">Alternate contact: Address</field>
39
borrowers.altcontactaddress2	Alternate contact: Address 2
39
<field name="borrowers.altcontactaddress2">Alternate contact: Address 2</field>
40
borrowers.altcontactaddress3	Alternate contact: City
40
<field name="borrowers.altcontactaddress3">Alternate contact: City</field>
41
borrowers.contactname	Alternate contact: Surname
41
<field name="borrowers.contactname">Alternate contact: Surname</field>
42
borrowers.contactfirstname	Alternate contact: First name
42
<field name="borrowers.contactfirstname">Alternate contact: First name</field>
43
borrowers.contacttitle	Alternate contact: Title
43
<field name="borrowers.contacttitle">Alternate contact: Title</field>
44
borrowers.altcontactstate	Alternate contact: State
44
<field name="borrowers.altcontactstate">Alternate contact: State</field>
45
borrowers.altcontactzipcode	Alternate contact: Zip/postal code
45
<field name="borrowers.altcontactzipcode">Alternate contact: Zip/postal code</field>
46
borrowers.altcontactcountry	Alternate contact: Country
46
<field name="borrowers.altcontactcountry">Alternate contact: Country</field>
47
borrowers.altcontactphone	Alternate contact: Phone
47
<field name="borrowers.altcontactphone">Alternate contact: Phone</field>
48
borrowers.cardnumber	Card number
48
<field name="borrowers.cardnumber">Card number</field>
49
borrowers.branchcode	Home library
49
<field name="borrowers.branchcode">Home library</field>
50
borrowers.categorycode	Category
50
<field name="borrowers.categorycode">Category</field>
51
borrowers.sort1	Sort 1
51
<field name="borrowers.sort1">Sort 1</field>
52
borrowers.sort2	Sort 2
52
<field name="borrowers.sort2">Sort 2</field>
53
borrowers.dateenrolled	Registration date
53
<field name="borrowers.dateenrolled">Registration date</field>
54
borrowers.dateexpiry	Expiry date
54
<field name="borrowers.dateexpiry">Expiry date</field>
55
borrowers.opacnote	OPAC note
55
<field name="borrowers.opacnote">OPAC note</field>
56
borrowers.borrowernotes	Circulation note
56
<field name="borrowers.borrowernotes">Circulation note</field>
57
borrowers.userid	Username
57
<field name="borrowers.userid">Username</field>
58
borrowers.password	Password
58
<field name="borrowers.password">Password</field>
59
borrowers.flags	System permissions
59
<field name="borrowers.flags">System permissions</field>
60
borrowers.gonenoaddress	Gone no address flag
60
<field name="borrowers.gonenoaddress">Gone no address flag</field>
61
borrowers.lost	Lost card flag
61
<field name="borrowers.lost">Lost card flag</field>
62
borrowers.debarred	Restricted [until] flag
62
<field name="borrowers.debarred">Restricted [until] flag</field>
63
borrowers.debarredcomment	Comment
63
<field name="borrowers.debarredcomment">Comment</field>
64
borrowers.smsalertnumber	Mobile phone number
64
<field name="borrowers.smsalertnumber">Mobile phone number</field>
65
borrowers.privacy	Privacy settings
65
<field name="borrowers.privacy">Privacy settings</field>
66
items.itemnumber	Item number (internal)
66
<field name="items.itemnumber">Item number (internal)</field>
67
items.biblionumber	Biblio number (internal)
67
<field name="items.biblionumber">Biblio number (internal)</field>
68
items.biblioitemnumber	Biblioitem number (internal)
68
<field name="items.biblioitemnumber">Biblioitem number (internal)</field>
69
items.barcode	Barcode
69
<field name="items.barcode">Barcode</field>
70
items.dateaccessioned	Date acquired
70
<field name="items.dateaccessioned">Date acquired</field>
71
items.booksellerid	Source of acquisition
71
<field name="items.booksellerid">Source of acquisition</field>
72
items.homebranch	Permanent library
72
<field name="items.homebranch">Permanent library</field>
73
items.price	Price
73
<field name="items.price">Price</field>
74
items.replacementprice	Replacement price
74
<field name="items.replacementprice">Replacement price</field>
75
items.replacementpricedate	Price effective from
75
<field name="items.replacementpricedate">Price effective from</field>
76
items.datelastborrowed	Date last checked out
76
<field name="items.datelastborrowed">Date last checked out</field>
77
items.datelastseen	Date last seen
77
<field name="items.datelastseen">Date last seen</field>
78
items.stack	Shelving control number
78
<field name="items.stack">Shelving control number</field>
79
items.onloan	Due date
79
<field name="items.onloan">Due date</field>
80
items.cn_source	Source of classification / shelving scheme
80
<field name="items.cn_source">Source of classification / shelving scheme</field>
81
items.cn_sort	Koha normalized classification for sorting
81
<field name="items.cn_sort">Koha normalized classification for sorting</field>
82
items.notforloan	Not for loan
82
<field name="items.notforloan">Not for loan</field>
83
items.itemlost	Lost status
83
<field name="items.itemlost">Lost status</field>
84
items.withdrawn	Withdrawn status
84
<field name="items.withdrawn">Withdrawn status</field>
85
items.itemcallnumber	Call number
85
<field name="items.itemcallnumber">Call number</field>
86
items.issues	Total checkouts
86
<field name="items.issues">Total checkouts</field>
87
items.renewals	Total renewals
87
<field name="items.renewals">Total renewals</field>
88
items.reserves	Total holds
88
<field name="items.reserves">Total holds</field>
89
items.restricted	Use restrictions
89
<field name="items.restricted">Use restrictions</field>
90
items.itemnotes	Public note
90
<field name="items.itemnotes">Public note</field>
91
items.holdingbranch	Current library
91
<field name="items.holdingbranch">Current library</field>
92
items.paidfor
92
<field name="items.paidfor</field>
93
items.timestamp	Timestamp
93
<field name="items.timestamp">Timestamp</field>
94
items.location	Shelving location
94
<field name="items.location">Shelving location</field>
95
items.ccode	Collection code
95
<field name="items.ccode">Collection code</field>
96
items.itype	Koha itemtype
96
<field name="items.itype">Koha itemtype</field>
97
items.stocknumber	Inventory number
97
<field name="items.stocknumber">Inventory number</field>
98
items.damaged	Damaged status
98
<field name="items.damaged">Damaged status</field>
99
items.materials	Materials specified
99
<field name="items.materials">Materials specified</field>
100
items.uri	Uniform Resource Identifier
100
<field name="items.uri">Uniform Resource Identifier</field>
101
items.more_subfields_xml	Additional subfields (XML)
101
<field name="items.more_subfields_xml">Additional subfields (XML)</field>
102
items.enumchron	Serial enumeraton/chronology
102
<field name="items.enumchron">Serial enumeraton/chronology</field>
103
items.copynumber	Copy number
103
<field name="items.copynumber">Copy number</field>
104
statistics.datetime	Statistics date and time
104
<field name="statistics.datetime">Statistics date and time</field>
105
statistics.branch	Library
105
<field name="statistics.branch">Library</field>
106
statistics.proccode	Type of procedure
106
<field name="statistics.proccode">Type of procedure</field>
107
statistics.value	Value
107
<field name="statistics.value">Value</field>
108
statistics.type	Type
108
<field name="statistics.type">Type</field>
109
statistics.other
109
<field name="statistics.other</field>
110
statistics.usercode	User code
110
<field name="statistics.usercode">User code</field>
111
statistics.itemnumber	Item number
111
<field name="statistics.itemnumber">Item number</field>
112
statistics.itemtype	Itemtype
112
<field name="statistics.itemtype">Itemtype</field>
113
statistics.borrowernumber	Borrower number
113
<field name="statistics.borrowernumber">Borrower number</field>
114
biblio.frameworkcode	Framework code
114
<field name="biblio.frameworkcode">Framework code</field>
115
biblio.author	Author
115
<field name="biblio.author">Author</field>
116
biblio.datecreated	Creation date
116
<field name="biblio.datecreated">Creation date</field>
117
biblio.timestamp	Modification date
117
<field name="biblio.timestamp">Modification date</field>
118
biblioitems.biblioitemnumber	Biblioitem number
118
<field name="biblioitems.biblioitemnumber">Biblioitem number</field>
119
biblioitems.biblionumber	Biblio number
119
<field name="biblioitems.biblionumber">Biblio number</field>
120
biblioitems.volume	Volume number
120
<field name="biblioitems.volume">Volume number</field>
121
biblioitems.number	Number
121
<field name="biblioitems.number">Number</field>
122
biblioitems.classification	Classification
122
<field name="biblioitems.classification">Classification</field>
123
biblioitems.itemtype	Biblio-level item type
123
<field name="biblioitems.itemtype">Biblio-level item type</field>
124
biblioitems.isbn	ISBN
124
<field name="biblioitems.isbn">ISBN</field>
125
biblioitems.issn	ISSN
125
<field name="biblioitems.issn">ISSN</field>
126
biblioitems.dewey	Dewey/classification
126
<field name="biblioitems.dewey">Dewey/classification</field>
127
biblioitems.subclass	Sub classification
127
<field name="biblioitems.subclass">Sub classification</field>
128
biblioitems.publicationyear	Publication date
128
<field name="biblioitems.publicationyear">Publication date</field>
129
biblioitems.publishercode	Publisher
129
<field name="biblioitems.publishercode">Publisher</field>
130
biblioitems.volumedate	Volume date
130
<field name="biblioitems.volumedate">Volume date</field>
131
biblioitems.volumedesc	Volume information
131
<field name="biblioitems.volumedesc">Volume information</field>
132
biblioitems.timestamp	Timestamp
132
<field name="biblioitems.timestamp">Timestamp</field>
133
biblioitems.illus	Illustrator
133
<field name="biblioitems.illus">Illustrator</field>
134
biblioitems.pages	Number of pages
134
<field name="biblioitems.pages">Number of pages</field>
135
biblioitems.notes	Notes
135
<field name="biblioitems.notes">Notes</field>
136
biblioitems.size	Size
136
<field name="biblioitems.size">Size</field>
137
biblioitems.place	Place of publication
137
<field name="biblioitems.place">Place of publication</field>
138
biblioitems.lccn	LCCN
138
<field name="biblioitems.lccn">LCCN</field>
139
biblioitems.marcxml	MARC blob
139
<field name="biblioitems.marcxml">MARC blob</field>
140
biblioitems.url	URL
140
<field name="biblioitems.url">URL</field>
141
biblioitems.title	Title
141
<field name="biblioitems.title">Title</field>
(-)a/misc/translator/tmpl_process3.pl (-2 / +1 lines)
Lines 242-248 usage_error('You must at least specify input and string list filenames.') Link Here
242
    if !$in_dir || !defined $str_file;
242
    if !$in_dir || !defined $str_file;
243
243
244
# Type match defaults to *.tt plus *.inc if not specified
244
# Type match defaults to *.tt plus *.inc if not specified
245
$type = "tt|inc|xsl|xml" if !defined($type);
245
$type = "tt|inc|xsl|xml|def" if !defined($type);
246
246
247
# Check the inputs for being directories
247
# Check the inputs for being directories
248
usage_error("$in_dir: Input must be a directory.\n"
248
usage_error("$in_dir: Input must be a directory.\n"
249
- 

Return to bug 9216