|
Lines 49-56
use C4::Form::MessagingPreferences;
Link Here
|
| 49 |
sub StringSearch { |
49 |
sub StringSearch { |
| 50 |
my ($searchstring,$type)=@_; |
50 |
my ($searchstring,$type)=@_; |
| 51 |
my $dbh = C4::Context->dbh; |
51 |
my $dbh = C4::Context->dbh; |
|
|
52 |
$searchstring //= ''; |
| 52 |
$searchstring=~ s/\'/\\\'/g; |
53 |
$searchstring=~ s/\'/\\\'/g; |
| 53 |
my @data=split(' ',$searchstring); |
54 |
my @data=split(' ',$searchstring); |
|
|
55 |
push @data,q{} if $#data==-1; |
| 54 |
my $count=@data; |
56 |
my $count=@data; |
| 55 |
my $sth=$dbh->prepare("Select * from categories where (description like ?) order by category_type,description,categorycode"); |
57 |
my $sth=$dbh->prepare("Select * from categories where (description like ?) order by category_type,description,categorycode"); |
| 56 |
$sth->execute("$data[0]%"); |
58 |
$sth->execute("$data[0]%"); |
|
Lines 67-73
my $input = new CGI;
Link Here
|
| 67 |
my $searchfield=$input->param('description'); |
69 |
my $searchfield=$input->param('description'); |
| 68 |
my $script_name="/cgi-bin/koha/admin/categorie.pl"; |
70 |
my $script_name="/cgi-bin/koha/admin/categorie.pl"; |
| 69 |
my $categorycode=$input->param('categorycode'); |
71 |
my $categorycode=$input->param('categorycode'); |
| 70 |
my $op = $input->param('op'); |
72 |
my $op = $input->param('op') // ''; |
| 71 |
|
73 |
|
| 72 |
my ($template, $loggedinuser, $cookie) |
74 |
my ($template, $loggedinuser, $cookie) |
| 73 |
= get_template_and_user({template_name => "admin/categorie.tmpl", |
75 |
= get_template_and_user({template_name => "admin/categorie.tmpl", |
|
Lines 240-250
if ($op eq 'add_form') {
Link Here
|
| 240 |
while ( my $branch = $sth->fetchrow_hashref ) { |
242 |
while ( my $branch = $sth->fetchrow_hashref ) { |
| 241 |
push @selected_branches, $branch; |
243 |
push @selected_branches, $branch; |
| 242 |
} |
244 |
} |
|
|
245 |
my $enrolmentperioddate = $results->[$i]{'enrolmentperioddate'}; |
| 246 |
$enrolmentperioddate = undef if $enrolmentperioddate eq '0000-00-00'; |
| 247 |
$enrolmentperioddate = C4::Dates::format_date($enrolmentperioddate); |
| 243 |
my %row = ( |
248 |
my %row = ( |
| 244 |
categorycode => $results->[$i]{'categorycode'}, |
249 |
categorycode => $results->[$i]{'categorycode'}, |
| 245 |
description => $results->[$i]{'description'}, |
250 |
description => $results->[$i]{'description'}, |
| 246 |
enrolmentperiod => $results->[$i]{'enrolmentperiod'}, |
251 |
enrolmentperiod => $results->[$i]{'enrolmentperiod'}, |
| 247 |
enrolmentperioddate => C4::Dates::format_date($results->[$i]{'enrolmentperioddate'}), |
252 |
enrolmentperioddate => $enrolmentperioddate, |
| 248 |
upperagelimit => $results->[$i]{'upperagelimit'}, |
253 |
upperagelimit => $results->[$i]{'upperagelimit'}, |
| 249 |
dateofbirthrequired => $results->[$i]{'dateofbirthrequired'}, |
254 |
dateofbirthrequired => $results->[$i]{'dateofbirthrequired'}, |
| 250 |
enrolmentfee => sprintf("%.2f",$results->[$i]{'enrolmentfee'}), |
255 |
enrolmentfee => sprintf("%.2f",$results->[$i]{'enrolmentfee'}), |
| 251 |
- |
|
|