# 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;
use C4::Output;
use C4::Auth;
use CGI;
script_name => $script_name,
else => 1
); # we show only the TMPL_VAR names $op
+ $op = q{};
}
my $dbh = C4::Context->dbh;
my $data;
my $sth =
$dbh->prepare(
-"select tagfield,tagsubfield,liblibrarian as lib,tab from marc_subfield_structure where kohafield=?"
+"select tagfield,tagsubfield,liblibrarian as lib,tab from marc_subfield_structure where kohafield=? AND frameworkcode=''"
);
$sth->execute( $tablename . "." . $kohafield );
my ( $defaulttagfield, $defaulttagsubfield, $defaultliblibrarian ) =
for ( my $i = 0 ; $i <= 9 ; $i++ ) {
my $sth2 =
$dbh->prepare(
-"select tagfield,tagsubfield,liblibrarian as lib,tab from marc_subfield_structure where tagfield like ?"
+"select tagfield,tagsubfield,liblibrarian as lib,tab from marc_subfield_structure where tagfield like ? AND frameworkcode=''"
);
$sth2->execute("$i%");
my @marcarray;
push @marcarray, "$field $tagsubfield - $liblibrarian";
}
my $marclist = CGI::scrolling_list(
- -name => "marc",
- -values => \@marcarray,
+ -name => 'marc',
+ -values => \@marcarray,
-default =>
"$defaulttagfield $defaulttagsubfield - $defaultliblibrarian",
-size => 1,
- -tabindex => '',
-multiple => 0,
);
$template->param( "marclist$i" => $marclist );
else { # DEFAULT
my $sth =
$dbh->prepare(
-"Select tagfield,tagsubfield,liblibrarian,kohafield from marc_subfield_structure"
+q|select tagfield,tagsubfield,liblibrarian,kohafield from marc_subfield_structure where kohafield is not NULL and kohafield != ''|
);
$sth->execute;
my %fields;
while ( ( my $tagfield, my $tagsubfield, my $liblibrarian, my $kohafield ) =
- $sth->fetchrow )
- {
+ $sth->fetchrow ) {
$fields{$kohafield}->{tagfield} = $tagfield;
$fields{$kohafield}->{tagsubfield} = $tagsubfield;
$fields{$kohafield}->{liblibrarian} = $liblibrarian;
my $sth2 = $dbh->prepare("SHOW COLUMNS from $tablename");
$sth2->execute;
- my $toggle = "white";
my @loop_data = ();
while ( ( my $field ) = $sth2->fetchrow_array ) {
- if ( $toggle eq 'white' ) {
- $toggle = "#ffffcc";
- }
- else {
- $toggle = "white";
- }
my %row_data; # get a fresh hash for the row data
$row_data{tagfield} = $fields{ $tablename . "." . $field }->{tagfield};
$row_data{tagsubfield} =
$row_data{liblibrarian} =
$fields{ $tablename . "." . $field }->{liblibrarian};
$row_data{kohafield} = $field;
- $row_data{edit} =
+ $row_data{edit} =
"$script_name?op=add_form&tablename=$tablename&kohafield=$field";
- $row_data{bgcolor} = $toggle;
push( @loop_data, \%row_data );
}
$template->param(
],
-default => $tablename,
-size => 1,
- -tabindex => '',
-multiple => 0
)
);
} #---- END $OP eq DEFAULT
-$template->param(
- intranetcolorstylesheet =>
- C4::Context->preference("intranetcolorstylesheet"),
- intranetstylesheet => C4::Context->preference("intranetstylesheet"),
- IntranetNav => C4::Context->preference("IntranetNav"),
-);
output_html_with_http_headers $input, $cookie, $template->output;