Bug 22082: ambiguous column in patron stats
[koha.git] / opac / opac-password-recovery.pl
1 #!/usr/bin/perl
2
3 use Modern::Perl;
4 use CGI;
5
6 use C4::Auth;
7 use C4::Koha;
8 use C4::Output;
9 use C4::Context;
10 use Koha::Patron::Password::Recovery
11   qw(SendPasswordRecoveryEmail ValidateBorrowernumber GetValidLinkInfo CompletePasswordRecovery DeleteExpiredPasswordRecovery);
12 use Koha::Patrons;
13 use Koha::AuthUtils qw(hash_password);
14 use Koha::Patrons;
15 my $query = new CGI;
16 use HTML::Entities;
17
18 my ( $template, $dummy, $cookie ) = get_template_and_user(
19     {
20         template_name   => "opac-password-recovery.tt",
21         query           => $query,
22         type            => "opac",
23         authnotrequired => 1,
24         debug           => 1,
25     }
26 );
27
28 my $email          = $query->param('email') // q{};
29 my $password       = $query->param('password');
30 my $repeatPassword = $query->param('repeatPassword');
31 my $id             = $query->param('id');
32 my $uniqueKey      = $query->param('uniqueKey');
33 my $username       = $query->param('username') // q{};
34 my $borrower_number;
35
36 #errors
37 my $hasError;
38
39 #email form error
40 my $errNoBorrowerFound;
41 my $errNoBorrowerEmail;
42 my $errMultipleAccountsForEmail;
43 my $errAlreadyStartRecovery;
44 my $errTooManyEmailFound;
45 my $errBadEmail;
46
47 #new password form error
48 my $errLinkNotValid;
49
50 if ( $query->param('sendEmail') || $query->param('resendEmail') ) {
51
52     #try with the main email
53     my $borrower;
54     my $search_results;
55
56     # Find the borrower by userid, card number, or email
57     if ($username) {
58         $search_results = Koha::Patrons->search( { -or => { userid => $username, cardnumber => $username } } );
59     }
60     elsif ($email) {
61         $search_results = Koha::Patrons->search( { -or => { email => $email, emailpro => $email, B_email  => $email } } );
62     }
63
64     if ( !defined $search_results || $search_results->count < 1) {
65         $hasError           = 1;
66         $errNoBorrowerFound = 1;
67     }
68     elsif ( $username && $search_results->count > 1) { # Multiple accounts for username
69         $hasError           = 1;
70         $errNoBorrowerFound = 1;
71     }
72     elsif ( $email && $search_results->count > 1) { # Muliple accounts for E-Mail
73         $hasError           = 1;
74         $errMultipleAccountsForEmail = 1;
75     }
76     elsif ( $borrower = $search_results->next() ) {    # One matching borrower
77         my @emails = grep { $_ } ( $borrower->email, $borrower->emailpro, $borrower->B_email );
78
79         my $firstNonEmptyEmail;
80         $firstNonEmptyEmail = $emails[0] if @emails;
81
82         # Is the given email one of the borrower's ?
83         if ( $email && !( grep /^$email$/i, @emails ) ) {
84             $hasError    = 1;
85             $errNoBorrowerFound = 1;
86         }
87
88         # If there is no given email, and there is no email on record
89         elsif ( !$email && !$firstNonEmptyEmail ) {
90             $hasError           = 1;
91             $errNoBorrowerEmail = 1;
92         }
93
94 # Check if a password reset already issued for this borrower AND we are not asking for a new email
95         elsif ( not $query->param('resendEmail') ) {
96             if ( ValidateBorrowernumber( $borrower->borrowernumber ) ) {
97                 $hasError                = 1;
98                 $errAlreadyStartRecovery = 1;
99             }
100             else {
101                 DeleteExpiredPasswordRecovery( $borrower->borrowernumber );
102             }
103         }
104         # Set the $email, if we don't have one.
105         if ( !$hasError && !$email ) {
106             $email = $firstNonEmptyEmail;
107         }
108     }
109     else {    # 0 matching borrower
110         $hasError           = 1;
111         $errNoBorrowerFound = 1;
112     }
113     if ($hasError) {
114         $template->param(
115             hasError                => 1,
116             errNoBorrowerFound      => $errNoBorrowerFound,
117             errTooManyEmailFound    => $errTooManyEmailFound,
118             errAlreadyStartRecovery => $errAlreadyStartRecovery,
119             errBadEmail             => $errBadEmail,
120             errNoBorrowerEmail      => $errNoBorrowerEmail,
121             errMultipleAccountsForEmail => $errMultipleAccountsForEmail,
122             password_recovery       => 1,
123             email                   => HTML::Entities::encode($email),
124             username                => $username
125         );
126     }
127     elsif ( SendPasswordRecoveryEmail( $borrower, $email, scalar $query->param('resendEmail') ) ) {    # generate uuid and send recovery email
128         $template->param(
129             mail_sent => 1,
130             email     => $email
131         );
132     }
133     else {    # if it doesn't work....
134         $template->param(
135             hasError          => 1,
136             password_recovery => 1,
137             sendmailError     => 1
138         );
139     }
140 }
141 elsif ( $query->param('passwordReset') ) {
142     ( $borrower_number, $username ) = GetValidLinkInfo($uniqueKey);
143
144     my $error;
145     if ( not $borrower_number ) {
146         $error = 'errLinkNotValid';
147     } elsif ( $password ne $repeatPassword ) {
148         $error = 'errPassNotMatch';
149     } else {
150         my ( $is_valid, $err) = Koha::AuthUtils::is_password_valid( $password );
151         unless ( $is_valid ) {
152             $error = 'password_too_short' if $err eq 'too_short';
153             $error = 'password_too_weak' if $err eq 'too_weak';
154             $error = 'password_has_whitespaces' if $err eq 'has_whitespaces';
155         } else {
156             Koha::Patrons->find($borrower_number)->update_password( $username, hash_password($password) );
157             CompletePasswordRecovery($uniqueKey);
158             $template->param(
159                 password_reset_done => 1,
160                 username            => $username
161             );
162         }
163     }
164     if ( $error ) {
165         $template->param(
166             new_password => 1,
167             email        => $email,
168             uniqueKey    => $uniqueKey,
169             hasError     => 1,
170             $error       => 1,
171         );
172     }
173 }
174 elsif ($uniqueKey) {    #reset password form
175                         #check if the link is valid
176     ( $borrower_number, $username ) = GetValidLinkInfo($uniqueKey);
177
178     if ( !$borrower_number ) {
179         $errLinkNotValid = 1;
180     }
181
182     $template->param(
183         new_password    => 1,
184         email           => $email,
185         uniqueKey       => $uniqueKey,
186         username        => $username,
187         errLinkNotValid => $errLinkNotValid,
188         hasError        => ( $errLinkNotValid ? 1 : 0 ),
189     );
190 }
191 else {    #password recovery form (to send email)
192     $template->param( password_recovery => 1 );
193 }
194
195 output_html_with_http_headers $query, $cookie, $template->output;