Lines 7-12
use C4::Utils::DataTables;
Link Here
|
7 |
use Koha::DateUtils; |
7 |
use Koha::DateUtils; |
8 |
use C4::Members::Attributes qw(SearchIdMatchingAttribute ); |
8 |
use C4::Members::Attributes qw(SearchIdMatchingAttribute ); |
9 |
|
9 |
|
|
|
10 |
my $dbh = C4::Context->dbh; |
11 |
|
12 |
my $datatime_type_query = "SELECT DISTINCT column_name FROM information_schema.columns WHERE table_name = 'borrowers' AND data_type in ('date', 'datetime', 'timestamp')"; |
13 |
my @columns_with_datetime_type = @{ $dbh->selectcol_arrayref($datatime_type_query) }; |
14 |
|
10 |
sub search { |
15 |
sub search { |
11 |
my ( $params ) = @_; |
16 |
my ( $params ) = @_; |
12 |
my $searchmember = $params->{searchmember}; |
17 |
my $searchmember = $params->{searchmember}; |
Lines 118-124
sub search {
Link Here
|
118 |
|
123 |
|
119 |
my @where_strs_or; |
124 |
my @where_strs_or; |
120 |
for my $searchfield ( split /,/, $searchfields->{$searchfieldstype} ) { |
125 |
for my $searchfield ( split /,/, $searchfields->{$searchfieldstype} ) { |
121 |
push @where_strs_or, "borrowers." . $dbh->quote_identifier($searchfield) . " LIKE ?"; |
126 |
if ( grep /^$searchfield$/, @columns_with_datetime_type ) { |
|
|
127 |
push @where_strs_or, "DATE_FORMAT(borrowers." . $dbh->quote_identifier($searchfield) . ", '%Y-%m-%d') LIKE ?"; |
128 |
} else { |
129 |
push @where_strs_or, "borrowers." . $dbh->quote_identifier($searchfield) . " LIKE ?"; |
130 |
} |
131 |
|
122 |
push @where_args, $term; |
132 |
push @where_args, $term; |
123 |
} |
133 |
} |
124 |
|
134 |
|
125 |
- |
|
|