147 |
my $sql_where = ''; |
my $sql_where = ''; |
148 |
@values = (); |
@values = (); |
149 |
|
|
150 |
foreach my $join_with ( keys %{ $reqData->{'filter'} } ) { |
foreach my $filter ( keys %{ $reqData->{'filter'} } ) { |
151 |
|
|
152 |
warn "## join_with $join_with ", dump( $reqData->{'filter'}->{ $join_with } ), "\n"; |
warn "## filter $filter ", dump( $reqData->{'filter'}->{ $filter } ), "\n"; |
153 |
|
|
154 |
@limits = (); |
@limits = (); |
155 |
|
|
156 |
if ( ref $reqData->{'filter'}->{ $join_with } eq 'ARRAY' ) { |
if ( ref $reqData->{'filter'}->{ $filter } eq 'ARRAY' ) { |
157 |
|
|
158 |
foreach my $filter ( @{ $reqData->{'filter'}->{ $join_with } } ) { |
foreach my $filter ( @{ $reqData->{'filter'}->{ $filter } } ) { |
159 |
warn "### filter ",dump($filter),$/; |
warn "### filter ",dump($filter),$/; |
160 |
foreach my $how ( keys %$filter ) { |
foreach my $how ( keys %$filter ) { |
161 |
if ( $how eq 'or' ) { |
if ( $how eq 'or' ) { |
167 |
} |
} |
168 |
} |
} |
169 |
|
|
170 |
$sql_where .= ' ' . join( " $join_with ", @limits ); |
$sql_where .= ' ' . join( " $filter ", @limits ); |
171 |
|
|
172 |
} else { |
} else { |
173 |
__ldap_search_to_sql( $join_with, $reqData->{'filter'}->{$join_with} ); |
__ldap_search_to_sql( $filter, $reqData->{'filter'}->{$filter} ); |
174 |
} |
} |
175 |
|
|
176 |
} |
} |