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::Members;
  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
  42 if ($input->param('newflags')) {
  43     my $dbh=C4::Context->dbh();
  44     my $flags=0;
  45     foreach ($input->param) {
  46         if (/flag-(\d+)/) {
  47             my $flag=$1;
  48             $flags=$flags+2**$flag;
  49         }
  50     }
  51     my $sth=$dbh->prepare("update borrowers set flags=? where borrowernumber=?");
  52     $sth->execute($flags, $member);
  53     print $input->redirect("/cgi-bin/koha/members/moremember.pl?borrowernumber=$member");
  54 } else {
  55 #     my ($bor,$flags,$accessflags)=GetMemberDetails($member,'');
  56     my $bor = GetMemberDetails( $member,'');
  57     my $flags = $bor->{'flags'};
  58     my $accessflags = $bor->{'authflags'};
  59     my $dbh=C4::Context->dbh();
  60     my $sth=$dbh->prepare("select bit,flag,flagdesc from userflags order by bit");
  61     $sth->execute;
  62     my @loop;
  63     while (my ($bit, $flag, $flagdesc) = $sth->fetchrow) {
  64         my $checked='';
  65         if ($accessflags->{$flag}) {
  66             $checked='checked';
  67         }
  68         my %row = ( bit => $bit,
  69                  flag => $flag,
  70                  checked => $checked,
  71                  flagdesc => $flagdesc );
  72         push @loop, \%row;
  73     }
  74
  75     $template->param(member => $member,
  76                         surname => $bor->{'surname'},
  77                         firstname => $bor->{'firstname'},
  78                         loop => \@loop,
  79                         intranetcolorstylesheet => C4::Context->preference("intranetcolorstylesheet"),
  80                 intranetstylesheet => C4::Context->preference("intranetstylesheet"),
  81                 IntranetNav => C4::Context->preference("IntranetNav"),
  82                         );
  83
  84     output_html_with_http_headers $input, $cookie, $template->output;
  85
  86 }