per row inserts
[koha.git] / members / member-flags.pl
1 #!/usr/bin/perl
2
3 # script to edit a member's flags
4 # Written by Steve Tonnesen
5 # July 26, 2002 (my birthday!)
6
7 use strict;
8
9 use CGI;
10 use C4::Output;
11 use C4::Auth;
12 use C4::Context;
13 use C4::Circulation::Circ2;
14 #use C4::Acquisitions;
15
16 use C4::Interface::CGI::Output;
17
18 my $input = new CGI;
19
20 my $flagsrequired;
21 $flagsrequired->{borrowers}=1;
22 $flagsrequired->{permissions}=1;
23
24 my ($template, $loggedinuser, $cookie)
25         = get_template_and_user({template_name => "members/member-flags.tmpl",
26                                 query => $input,
27                                 type => "intranet",
28                                 authnotrequired => 0,
29                                 flagsrequired => {permissions => 1},
30                                 debug => 1,
31                                 });
32
33
34
35
36 my $member=$input->param('member');
37 my %env;
38 $env{'nottodayissues'}=1;
39 my %member2;
40 $member2{'borrowernumber'}=$member;
41 my $issues=currentissues(\%env,\%member2);
42 my $i=0;
43 foreach (sort keys %$issues) {
44     $i++;
45 }
46
47 if ($input->param('newflags')) {
48     my $dbh=C4::Context->dbh();
49     my $flags=0;
50     foreach ($input->param) {
51         if (/flag-(\d+)/) {
52             my $flag=$1;
53             $flags=$flags+2**$flag;
54         }
55     }
56     my $sth=$dbh->prepare("update borrowers set flags=? where borrowernumber=?");
57     $sth->execute($flags, $member);
58     print $input->redirect("/cgi-bin/koha/members/moremember.pl?borrowernumber=$member");
59 } else {
60 #     my ($bor,$flags,$accessflags)=getpatroninformation(\%env, $member,'');
61     my $bor = getpatroninformation(\%env, $member,'');
62     my $flags = $bor->{'flags'};
63     my $accessflags = $bor->{'authflags'};
64     my $dbh=C4::Context->dbh();
65     my $sth=$dbh->prepare("select bit,flag,flagdesc from userflags order by bit");
66     $sth->execute;
67     my @loop;
68     while (my ($bit, $flag, $flagdesc) = $sth->fetchrow) {
69         my $checked='';
70         if ($accessflags->{$flag}) {
71             $checked='checked';
72         }
73         my %row = ( bit => $bit,
74                  flag => $flag,
75                  checked => $checked,
76                  flagdesc => $flagdesc );
77         push @loop, \%row;
78     }
79
80     $template->param(member => $member,
81                         surname => $bor->{'surname'},
82                         firstname => $bor->{'firstname'},
83                         loop => \@loop,
84                         intranetcolorstylesheet => C4::Context->preference("intranetcolorstylesheet"),
85                 intranetstylesheet => C4::Context->preference("intranetstylesheet"),
86                 IntranetNav => C4::Context->preference("IntranetNav"),
87                         );
88
89     output_html_with_http_headers $input, $cookie, $template->output;
90
91 }