| 1 |
8 |
ahitrov@rambler.ru |
<& "/contenido/components/header.msn" &> |
| 2 |
|
|
<& "/contenido/components/naviline.msn", sect_id => $owner->id &> |
| 3 |
|
|
|
| 4 |
17 |
ahitrov@rambler.ru |
<script type="text/javascript"> |
| 5 |
|
|
<!-- |
| 6 |
|
|
function set_create_button( oSelect, sBtnID ) { |
| 7 |
|
|
if ( oSelect.value == '' ) { |
| 8 |
|
|
$('#'+sBtnID).attr('disabled','disabled'); |
| 9 |
|
|
} else { |
| 10 |
|
|
$('#'+sBtnID).removeAttr('disabled'); |
| 11 |
|
|
} |
| 12 |
|
|
} |
| 13 |
|
|
//--> |
| 14 |
|
|
</script> |
| 15 |
|
|
|
| 16 |
8 |
ahitrov@rambler.ru |
<table width="100%" cellspacing="0" cellpadding="0" border="0"> |
| 17 |
|
|
<tr valign="top"> |
| 18 |
|
|
<td width="35%"> |
| 19 |
|
|
|
| 20 |
|
|
<& "/contenido/components/subsection.msn", section => $owner &> |
| 21 |
|
|
<& "/contenido/components/class_filter.msn", class=> $class, section => $owner &> |
| 22 |
|
|
|
| 23 |
|
|
% if (( $owner->id ) && ($owner->id > 0) ) |
| 24 |
|
|
% { |
| 25 |
|
|
<& "/contenido/components/section_info.msn", section => $owner &> |
| 26 |
|
|
% } |
| 27 |
|
|
|
| 28 |
|
|
% my @LEFT = $m->comp('components/tasks.msn'); |
| 29 |
|
|
% my %LEFTh = map { $_->{attr} => $_ } (@LEFT); |
| 30 |
|
|
% if (ref($request->{tab}->{lefts})) |
| 31 |
|
|
% { |
| 32 |
|
|
% for my $left (@{ $request->{tab}->{lefts} }) |
| 33 |
|
|
% { |
| 34 |
|
|
% next if (! exists($LEFTh{$left})); |
| 35 |
|
|
<& '/contenido/components/'.$LEFTh{$left}->{component}, %ARGS &> |
| 36 |
|
|
% } |
| 37 |
|
|
% } |
| 38 |
|
|
|
| 39 |
|
|
<!-- Примечания --> |
| 40 |
|
|
<fieldset> |
| 41 |
|
|
<legend>Примечания</legend> |
| 42 |
|
|
<table width="100%" cellspacing="5" cellpadding="0" class="tform"> |
| 43 |
|
|
|
| 44 |
|
|
<tr> |
| 45 |
|
|
<th valign=top>1)</th> |
| 46 |
|
|
<td width="100%"> |
| 47 |
|
|
Дата и время документа - поле, которое Вы можете редактировать.<br><br> |
| 48 |
|
|
Кроме этого у каждого документа существует еще две временные отметки - дата создания (ctime) и дата модификации (mtime). |
| 49 |
|
|
Это служебные поля и Вы не можете их изменять (они доступны только для чтения). |
| 50 |
|
|
</td> |
| 51 |
|
|
</tr> |
| 52 |
|
|
|
| 53 |
|
|
</table> |
| 54 |
|
|
</fieldset> |
| 55 |
|
|
|
| 56 |
|
|
</td> |
| 57 |
|
|
<td width="2%"> </td> |
| 58 |
|
|
<td width="65%"> |
| 59 |
|
|
|
| 60 |
|
|
% if($owner->id) { |
| 61 |
|
|
|
| 62 |
|
|
<fieldset> |
| 63 |
|
|
<legend>Документы\ |
| 64 |
|
|
% if ($class) { |
| 65 |
|
|
класса <% $class %>\ |
| 66 |
|
|
% if ($use_section) { |
| 67 |
|
|
c учетом текущей секции\ |
| 68 |
|
|
% } |
| 69 |
|
|
% } else { |
| 70 |
|
|
в разделе\ |
| 71 |
|
|
% } |
| 72 |
118 |
ahitrov |
% if (!$owner->no_count && $total > 0) { |
| 73 |
8 |
ahitrov@rambler.ru |
(всего: <% $total %>, показано с <% $first + 1 %> по <% ($first + $n > $total) ? $total : $first + $n %>) |
| 74 |
118 |
ahitrov |
% } elsif ( $owner->no_count ) { |
| 75 |
|
|
(<span style="color:yellow">без пересчета</span>, показано с <% $first + 1 %> по <% $first + scalar @documents %>) |
| 76 |
8 |
ahitrov@rambler.ru |
% } |
| 77 |
|
|
</legend> |
| 78 |
|
|
|
| 79 |
118 |
ahitrov |
% if ($total || scalar @documents || defined($alpha) || defined($search) ) { |
| 80 |
8 |
ahitrov@rambler.ru |
% if ($section_access == 2) { |
| 81 |
|
|
<& "/contenido/components/new_objects_form.msn", proto => 'documents', |
| 82 |
450 |
ahitrov |
sect_id => $owner->id, section => $owner, |
| 83 |
8 |
ahitrov@rambler.ru |
default => ($owner->default_document_class ? $owner->default_document_class : undef) &> |
| 84 |
|
|
% } |
| 85 |
117 |
ahitrov |
<div style="font-size:12px; font-family:Arial;"> |
| 86 |
8 |
ahitrov@rambler.ru |
<table border="0" cellspacing="0" cellpadding="2" width="100%" style="margin:4px 0 0; border:1px solid gray;"> |
| 87 |
|
|
<tr bgcolor="#e0e0e0"><th colspan="4">Поиск по букве: [<a href="?id=<% $id %>" style="font-weight:normal;">сброс фильтра</a>]</th></tr> |
| 88 |
117 |
ahitrov |
<tr><td style="font-size:12px; font-family:Arial; padding:2px 4px;"> |
| 89 |
8 |
ahitrov@rambler.ru |
<& /inc/alpha.msn, alpha=>$alpha, params=>\%ARGS, &> |
| 90 |
|
|
</td></tr></table> |
| 91 |
|
|
% ## Форма поиска. Работает при включенном фильтре класса |
| 92 |
|
|
% ## и описанной для класса функции search_fields |
| 93 |
|
|
% ######################################################## |
| 94 |
450 |
ahitrov |
% if ( $filter{class} || $filter{table} ) { |
| 95 |
459 |
ahitrov |
% my ($document) = $filter{class} ? ($filter{class}->new( $keeper )) : map { $_->new( $keeper ) } grep { $_->new( $keeper )->class_table eq $owner->default_table_class } @{ $user->get_available_classes }; |
| 96 |
8 |
ahitrov@rambler.ru |
% my @fields = $document->search_fields; |
| 97 |
|
|
% if ( @fields ) { |
| 98 |
|
|
% my @props = $document->required_properties; |
| 99 |
|
|
<form action="sections.html"> |
| 100 |
|
|
<table border="0" cellspacing="0" cellpadding="2" width="100%" style="margin:4px 0; border:1px solid gray;"> |
| 101 |
|
|
<tr bgcolor="#e0e0e0"><th colspan="4">Поиск по полю: [<a href="?id=<% $id %>" style="font-weight:normal;">сброс фильтра</a>]</th></tr><tr> |
| 102 |
|
|
<td width="1%" nowrap style="padding:2px 0 2px 4px;"><select name="search_by"> |
| 103 |
|
|
% foreach my $field ( @fields ) { |
| 104 |
|
|
% my ($prop) = grep { $_->{'attr'} eq $field } @props; |
| 105 |
|
|
% my $selected = $field eq $search_by ? ' selected' : ''; |
| 106 |
|
|
<option value="<% $field %>"<% $selected %>><% ref $prop ? $prop->{'shortname'} || $prop->{'rusname'} : $field %> |
| 107 |
|
|
% } |
| 108 |
|
|
</td><td width="0">:</td> |
| 109 |
|
|
<td width="98%"><input type="text" name="search" value="<% $search %>" style="width:100%"></td> |
| 110 |
|
|
<td width="1%" style="padding:2px 4px 2px 0;"><input type="submit" value=" » " style="border:1px solid gray;"></td> |
| 111 |
|
|
</tr></table> |
| 112 |
|
|
% if ( $id ) { |
| 113 |
|
|
<input type="hidden" name="id" value="<% $id %>"> |
| 114 |
|
|
% } |
| 115 |
|
|
% if ( $class ) { |
| 116 |
|
|
<input type="hidden" name="class" value="<% $class %>"> |
| 117 |
|
|
% } |
| 118 |
|
|
% if ( $use_section ) { |
| 119 |
|
|
<input type="hidden" name="use_section" value="<% $use_section %>"> |
| 120 |
|
|
% } |
| 121 |
|
|
</form> |
| 122 |
|
|
% } |
| 123 |
|
|
% } |
| 124 |
|
|
|
| 125 |
|
|
<div style="height:5px"><spacer type="block" height="5"></div> |
| 126 |
118 |
ahitrov |
% if ( $owner->no_count ) { |
| 127 |
|
|
<& /inc/pages_nocount.msn, p=>$p, n=>$n, found=> scalar @documents, href=>'sections.html', params=>\%ARGS, size => 15 &> |
| 128 |
|
|
% } else { |
| 129 |
8 |
ahitrov@rambler.ru |
<& /inc/pages_.msn, p=>$p, n=>$n, total=>$total, href=>'sections.html', params=>\%ARGS, &> |
| 130 |
118 |
ahitrov |
% } |
| 131 |
8 |
ahitrov@rambler.ru |
</div> |
| 132 |
|
|
|
| 133 |
|
|
<& /contenido/components/section_browse.msn, documents => \@documents, columns => \@columns, section => $owner, filter => \%filter_params, %ARGS &> |
| 134 |
|
|
|
| 135 |
117 |
ahitrov |
<div style="font-size:12px; font-family:Arial;"> |
| 136 |
118 |
ahitrov |
% if ( $owner->no_count ) { |
| 137 |
|
|
<& /inc/pages_nocount.msn, p=>$p, n=>$n, found=> scalar @documents, href=>'sections.html', params=>\%ARGS, size => 15 &> |
| 138 |
|
|
% } else { |
| 139 |
8 |
ahitrov@rambler.ru |
<& /inc/pages_.msn, p=>$p, n=>$n, total=>$total, href=>'sections.html', params=>\%ARGS, &> |
| 140 |
118 |
ahitrov |
% } |
| 141 |
8 |
ahitrov@rambler.ru |
<div style="height:5px"><spacer type="block" height="5"></div> |
| 142 |
|
|
</div> |
| 143 |
|
|
|
| 144 |
|
|
% } else { |
| 145 |
|
|
<h4 align="center"><i>---- Нет документов -----</i></h4> |
| 146 |
|
|
% } |
| 147 |
|
|
% |
| 148 |
|
|
% if ($section_access == 2) { |
| 149 |
|
|
<& "/contenido/components/new_objects_form.msn", proto => 'documents', |
| 150 |
|
|
sect_id => $owner->id, |
| 151 |
|
|
default => ($owner->default_document_class ? $owner->default_document_class : undef) &> |
| 152 |
|
|
% } |
| 153 |
|
|
|
| 154 |
|
|
</fieldset> |
| 155 |
|
|
</td> |
| 156 |
|
|
</tr> |
| 157 |
|
|
</table> |
| 158 |
|
|
|
| 159 |
|
|
% } |
| 160 |
|
|
|
| 161 |
|
|
</body> |
| 162 |
|
|
</html> |
| 163 |
|
|
<%args> |
| 164 |
|
|
|
| 165 |
|
|
$id => undef |
| 166 |
|
|
$p => 1 |
| 167 |
|
|
$class => undef |
| 168 |
|
|
$use_section => undef |
| 169 |
|
|
$alpha => undef |
| 170 |
|
|
$alpha_search => undef |
| 171 |
|
|
$search_by => undef |
| 172 |
|
|
$search => undef |
| 173 |
|
|
$update => undef |
| 174 |
|
|
$delete => undef |
| 175 |
|
|
|
| 176 |
|
|
</%args> |
| 177 |
|
|
<%init> |
| 178 |
|
|
|
| 179 |
|
|
$id = 0 if $id =~ /\D/; |
| 180 |
|
|
my $owner; |
| 181 |
|
|
|
| 182 |
|
|
# Операции... |
| 183 |
|
|
if ($id && ($id > 0)) |
| 184 |
|
|
{ |
| 185 |
|
|
$owner = $keeper->get_section_by_id($id); |
| 186 |
|
|
} |
| 187 |
|
|
if (! ref($owner)) |
| 188 |
|
|
{ |
| 189 |
|
|
return undef; |
| 190 |
|
|
} |
| 191 |
|
|
|
| 192 |
|
|
my %filter_params; |
| 193 |
|
|
$filter_params{use_section} = $use_section if $use_section; |
| 194 |
|
|
$filter_params{class} = $class if $class; |
| 195 |
|
|
$filter_params{alpha} = $alpha if $alpha; |
| 196 |
|
|
$filter_params{alpha_search} = $alpha_search if $alpha_search; |
| 197 |
|
|
$filter_params{search_by} = $search_by if $search_by; |
| 198 |
|
|
$filter_params{search} = $search if $search; |
| 199 |
|
|
$filter_params{p} = $p if $p > 1; |
| 200 |
|
|
$filter_params{s} = $id if $id; |
| 201 |
|
|
|
| 202 |
16 |
ahitrov@rambler.ru |
# Фильтры работают в любом случае... |
| 203 |
8 |
ahitrov@rambler.ru |
my $filter = $m->comp('/contenido/components/context.msn', name => 'filter'); |
| 204 |
|
|
my $profile = $m->comp('/contenido/components/context.msn', name => 'profile'); |
| 205 |
|
|
|
| 206 |
|
|
unless (defined $request->{section_accesses}->{$id}) |
| 207 |
|
|
{ |
| 208 |
|
|
$request->{section_accesses}->{$id} = $user->get_section_access($id); |
| 209 |
|
|
} |
| 210 |
|
|
my $section_access = $request->{section_accesses}->{$id}; |
| 211 |
|
|
|
| 212 |
|
|
my (@documents, $total); |
| 213 |
|
|
|
| 214 |
|
|
my $s = $owner->id; |
| 215 |
|
|
my $sorted = $owner->_sorted(); |
| 216 |
|
|
$s .= ",$filter" if ($filter > 0); |
| 217 |
|
|
|
| 218 |
|
|
if ($update) { |
| 219 |
|
|
my $return_params = join ('&', map { $_.'='.$filter_params{$_} } grep { $_ ne 's' } keys %filter_params ); |
| 220 |
|
|
my %updated; |
| 221 |
|
|
while ( my ($field, $value) = each %ARGS ) { |
| 222 |
|
|
if ( $field =~ /^update_(\d+)_(\w+)$/ ) { |
| 223 |
|
|
my $oid = $1; |
| 224 |
|
|
my $attr = $2; |
| 225 |
|
|
$updated{$oid}{$attr} = $value; |
| 226 |
|
|
} |
| 227 |
|
|
} |
| 228 |
|
|
my %classes = map { $_->{class} => 1 } values %updated; |
| 229 |
|
|
foreach my $update_class ( keys %classes ) { |
| 230 |
|
|
my @ids; |
| 231 |
|
|
while ( my ($oid, $attr) = each %updated) { |
| 232 |
|
|
push @ids, $oid if $attr->{class} eq $update_class; |
| 233 |
|
|
} |
| 234 |
|
|
my @objects = $keeper->get_documents ( |
| 235 |
|
|
id => \@ids, |
| 236 |
|
|
class => $update_class |
| 237 |
|
|
) if @ids; |
| 238 |
|
|
foreach my $object ( @objects ) { |
| 239 |
|
|
my $document_access = $user->section_accesses($user, $object->section); |
| 240 |
|
|
next unless $document_access == 2; |
| 241 |
|
|
my $fields = $updated{$object->id}; |
| 242 |
|
|
my @props = grep { exists $_->{inline} && $_->{inline} } $object->structure; |
| 243 |
|
|
if ( ref $fields eq 'HASH' ) { |
| 244 |
|
|
foreach my $prop ( @props ) { |
| 245 |
|
|
my $attr = $prop->{attr}; |
| 246 |
|
|
my $value = ref $fields && exists $fields->{$attr} ? $fields->{$attr} : undef; |
| 247 |
395 |
ahitrov |
if ( $prop->{type} eq 'checkbox' ) { |
| 248 |
|
|
$value = $value ? 1 : undef; |
| 249 |
|
|
} |
| 250 |
386 |
ahitrov |
if ( exists $prop->{db_type} ) { |
| 251 |
|
|
if ( $prop->{db_type} eq 'float' ) { |
| 252 |
|
|
for ( $value ) { |
| 253 |
|
|
s/\,/\./; |
| 254 |
|
|
s/^\s+//; |
| 255 |
|
|
s/\s+$//; |
| 256 |
|
|
} |
| 257 |
|
|
if ( $value eq '' ) { |
| 258 |
|
|
$value = undef; |
| 259 |
|
|
} |
| 260 |
|
|
} elsif ( $prop->{db_type} eq 'integer' || $prop->{db_type} eq 'smallint' ) { |
| 261 |
|
|
$value =~ s/\D//sg if $value; |
| 262 |
|
|
if ( $value eq '' ) { |
| 263 |
|
|
$value = undef; |
| 264 |
|
|
} |
| 265 |
8 |
ahitrov@rambler.ru |
} |
| 266 |
|
|
} |
| 267 |
|
|
|
| 268 |
|
|
$object->$attr($value); |
| 269 |
|
|
} |
| 270 |
|
|
$object->store; |
| 271 |
|
|
} |
| 272 |
|
|
} |
| 273 |
|
|
} |
| 274 |
|
|
$m->redirect("sections.html?id=".$id.($return_params ? '&'.$return_params : '')); |
| 275 |
|
|
} |
| 276 |
|
|
if ( $delete ) { |
| 277 |
|
|
my $return_params = join ('&', map { $_.'='.$filter_params{$_} } grep { $_ ne 's' } keys %filter_params ); |
| 278 |
|
|
my %deleted; |
| 279 |
|
|
while ( my ($field, $value) = each %ARGS ) { |
| 280 |
|
|
if ( $field =~ /^delete_(\d+)_(\w+)$/ ) { |
| 281 |
|
|
my $oid = $1; |
| 282 |
|
|
my $attr = $2; |
| 283 |
|
|
$deleted{$oid}{$attr} = $value; |
| 284 |
|
|
} |
| 285 |
|
|
} |
| 286 |
|
|
my %classes = map { $_->{class} => 1 } values %deleted; |
| 287 |
|
|
foreach my $delete_class ( keys %classes ) { |
| 288 |
|
|
my @ids; |
| 289 |
|
|
while ( my ($oid, $attr) = each %deleted) { |
| 290 |
|
|
push @ids, $oid if exists $attr->{id} && $attr->{id} && ($attr->{class} eq $delete_class); |
| 291 |
|
|
} |
| 292 |
|
|
my @objects = $keeper->get_documents ( |
| 293 |
|
|
id => \@ids, |
| 294 |
|
|
class => $delete_class |
| 295 |
|
|
) if @ids; |
| 296 |
|
|
foreach my $object ( @objects ) { |
| 297 |
|
|
my $document_access = $user->section_accesses($user, $object->section); |
| 298 |
|
|
next unless $document_access == 2; |
| 299 |
|
|
$object->delete; |
| 300 |
|
|
} |
| 301 |
|
|
} |
| 302 |
|
|
$m->redirect("sections.html?id=".$id.($return_params ? '&'.$return_params : '')); |
| 303 |
|
|
} |
| 304 |
386 |
ahitrov |
if ( $ARGS{move} || $ARGS{link} ) { |
| 305 |
|
|
my $return_params = join ('&', map { $_.'='.$filter_params{$_} } grep { $_ ne 's' } keys %filter_params ); |
| 306 |
|
|
if ( exists $ARGS{tree} && $ARGS{tree} && $ARGS{tree} != $owner->id ) { |
| 307 |
|
|
my %updated; |
| 308 |
|
|
while ( my ($field, $value) = each %ARGS ) { |
| 309 |
388 |
ahitrov |
if ( $field =~ /^delete_(\d+)_(\w+)$/ ) { |
| 310 |
386 |
ahitrov |
my $oid = $1; |
| 311 |
|
|
my $attr = $2; |
| 312 |
|
|
$updated{$oid}{$attr} = $value; |
| 313 |
|
|
} |
| 314 |
|
|
} |
| 315 |
388 |
ahitrov |
warn Dumper \%updated; |
| 316 |
386 |
ahitrov |
my %classes = map { $_->{class} => 1 } values %updated; |
| 317 |
|
|
my $parent_new = $keeper->get_section_by_id( $ARGS{tree} ); |
| 318 |
|
|
my $document_access = $user->section_accesses($user, $parent_new->id); |
| 319 |
|
|
if ( $document_access == 2 ) { |
| 320 |
|
|
foreach my $update_class ( keys %classes ) { |
| 321 |
|
|
my @ids; |
| 322 |
|
|
while ( my ($oid, $attr) = each %updated) { |
| 323 |
388 |
ahitrov |
push @ids, $oid if exists $attr->{id} && $attr->{id} && ($attr->{class} eq $update_class); |
| 324 |
386 |
ahitrov |
} |
| 325 |
|
|
my @objects = $keeper->get_documents ( |
| 326 |
|
|
id => \@ids, |
| 327 |
|
|
class => $update_class |
| 328 |
|
|
) if @ids; |
| 329 |
|
|
my ($prop) = grep { $_->{attr} eq 'sections' } $update_class->new( $keeper )->structure; |
| 330 |
|
|
if ( ref $prop && exists $prop->{db_type} && exists $prop->{db_field} ) { |
| 331 |
|
|
foreach my $object ( @objects ) { |
| 332 |
|
|
if ( $prop->{db_type} eq 'integer[]' ) { |
| 333 |
|
|
my @sections = grep { $_ != $parent_new->id } $object->sections; |
| 334 |
|
|
if ( @sections && $sections[0] == $owner->id ) { |
| 335 |
419 |
ahitrov |
if ( $ARGS{move} ) { |
| 336 |
|
|
shift @sections; |
| 337 |
|
|
unshift @sections, $parent_new->id; |
| 338 |
|
|
} else { |
| 339 |
|
|
push @sections, $parent_new->id; |
| 340 |
|
|
} |
| 341 |
|
|
} else { |
| 342 |
|
|
if ( $ARGS{move} ) { |
| 343 |
|
|
@sections = grep { $_ != $owner->id } @sections; |
| 344 |
|
|
} |
| 345 |
386 |
ahitrov |
unshift @sections, $parent_new->id; |
| 346 |
|
|
} |
| 347 |
|
|
$object->sections( @sections ); |
| 348 |
|
|
} else { |
| 349 |
|
|
$object->sections( $parent_new->id ); |
| 350 |
|
|
} |
| 351 |
|
|
$object->store; |
| 352 |
|
|
} |
| 353 |
|
|
} |
| 354 |
|
|
} |
| 355 |
|
|
} |
| 356 |
|
|
} |
| 357 |
|
|
$m->redirect("sections.html?id=".$id.($return_params ? '&'.$return_params : '')); |
| 358 |
|
|
} |
| 359 |
8 |
ahitrov@rambler.ru |
|
| 360 |
|
|
my %filter=(); |
| 361 |
131 |
ahitrov |
my $nothing_found = 0; |
| 362 |
8 |
ahitrov@rambler.ru |
my %order = (not $class and $owner->order_by) ? (order_by => $owner->order_by) : (order => ['date','direct']); |
| 363 |
|
|
if (defined $alpha and $alpha ne '') { |
| 364 |
|
|
$filter{ilike}=1; |
| 365 |
|
|
$filter{ $alpha_search || 'name' }="$alpha%"; |
| 366 |
|
|
$order{order}=['name','reverse']; |
| 367 |
|
|
delete $order{order_by}; |
| 368 |
|
|
} |
| 369 |
|
|
if ( $class ) { |
| 370 |
|
|
$filter{class} = $class; |
| 371 |
|
|
} elsif ( $owner->default_document_class ) { |
| 372 |
|
|
$filter{class} = $owner->default_document_class; |
| 373 |
|
|
} elsif ( $owner->default_table_class ) { |
| 374 |
|
|
$filter{table} = $owner->default_table_class; |
| 375 |
|
|
} |
| 376 |
|
|
$filter{s}=$s unless ($class && !$use_section); |
| 377 |
|
|
if ( $search_by && defined $search ) { |
| 378 |
|
|
my $doc_class = $class || $owner->default_document_class; |
| 379 |
|
|
if ( $doc_class ) { |
| 380 |
|
|
my @props = $doc_class->new( $keeper )->structure(); |
| 381 |
|
|
my ($prop) = grep { $_->{attr} eq $search_by } @props if @props; |
| 382 |
131 |
ahitrov |
if ( ref $prop && ($prop->{type} eq 'integer' || $prop->{type} eq 'checkbox' || |
| 383 |
137 |
ahitrov |
(($prop->{type} eq 'pickup' || $prop->{type} eq 'lookup') && $search =~ /^\d+$/) || |
| 384 |
|
|
(exists $prop->{db_type} && $prop->{db_type} =~ /integer\[\]/) )) { |
| 385 |
8 |
ahitrov@rambler.ru |
$filter{$search_by} = int($search); |
| 386 |
131 |
ahitrov |
} elsif ( ref $prop && ($prop->{type} eq 'pickup' || $prop->{type} eq 'lookup') && $search =~ /\D/ ) { |
| 387 |
|
|
my $lookup_opts = $prop->{lookup_opts}; |
| 388 |
386 |
ahitrov |
if ( ref $lookup_opts && (exists $lookup_opts->{class} || exists $lookup_opts->{table}) ) { |
| 389 |
131 |
ahitrov |
my $search_field = exists $lookup_opts->{search_by} ? $lookup_opts->{search_by} : 'name'; |
| 390 |
|
|
my @ids = $keeper->get_documents ( |
| 391 |
|
|
ids => 1, |
| 392 |
386 |
ahitrov |
exists $lookup_opts->{class} ? (class => $lookup_opts->{class}) : (table => $lookup_opts->{table}), |
| 393 |
131 |
ahitrov |
ilike => 1, |
| 394 |
|
|
$search_field => '%'.$search.'%', |
| 395 |
|
|
); |
| 396 |
|
|
if ( @ids ) { |
| 397 |
|
|
$filter{$search_by} = \@ids; |
| 398 |
|
|
} else { |
| 399 |
|
|
$nothing_found = 1; |
| 400 |
|
|
} |
| 401 |
|
|
} |
| 402 |
8 |
ahitrov@rambler.ru |
} else { |
| 403 |
|
|
$filter{$search_by}='%'.$search.'%'; |
| 404 |
|
|
$filter{ilike} = 1; |
| 405 |
|
|
} |
| 406 |
|
|
} else { |
| 407 |
|
|
$filter{$search_by}='%'.$search.'%'; |
| 408 |
|
|
$filter{ilike} = 1; |
| 409 |
|
|
} |
| 410 |
|
|
} |
| 411 |
|
|
|
| 412 |
131 |
ahitrov |
# Дополнительные фильтры раздела |
| 413 |
|
|
if ($owner->filters) { |
| 414 |
|
|
no strict 'vars'; |
| 415 |
|
|
my $filters = eval($owner->filters); |
| 416 |
|
|
if ($@) { |
| 417 |
|
|
warn "Bad filter: " . $owner->filters . " in section " . $owner->id; |
| 418 |
|
|
} elsif (ref $filters eq 'HASH') { |
| 419 |
|
|
while ( my ($key, $val) = each %$filters ) { |
| 420 |
|
|
$filter{$key} = $val; |
| 421 |
|
|
} |
| 422 |
|
|
} |
| 423 |
|
|
} |
| 424 |
8 |
ahitrov@rambler.ru |
|
| 425 |
118 |
ahitrov |
$total = $keeper->get_documents(%filter, count=>1) unless $owner->no_count; |
| 426 |
8 |
ahitrov@rambler.ru |
|
| 427 |
|
|
my $n = 40; |
| 428 |
|
|
my $first = $n * ($p - 1); |
| 429 |
118 |
ahitrov |
($first,$p)=(0,0) if (!$owner->no_count && $first>$total); |
| 430 |
8 |
ahitrov@rambler.ru |
|
| 431 |
131 |
ahitrov |
unless ( $nothing_found ) { |
| 432 |
|
|
if ($class && !$use_section) { |
| 433 |
|
|
@documents = $keeper->get_documents(%filter, %order, limit=>$n, offset=>$first); |
| 434 |
|
|
} elsif ($sorted) { |
| 435 |
|
|
@documents = $keeper->get_sorted_documents(%filter, limit=>$n, offset=>$first); |
| 436 |
|
|
} else { |
| 437 |
|
|
@documents = $keeper->get_documents(%filter, %order, limit=>$n, offset=>$first); |
| 438 |
|
|
} |
| 439 |
8 |
ahitrov@rambler.ru |
} |
| 440 |
|
|
# набор колонок таблицы документов... |
| 441 |
131 |
ahitrov |
my @columns = $sorted ? ({attr => '_sort_', name => 'N'}) : (); |
| 442 |
8 |
ahitrov@rambler.ru |
|
| 443 |
131 |
ahitrov |
# пытаемся найти колонки, которые документ сам пожелал показать (required_properties -> column)... |
| 444 |
|
|
if ($filter{class} or @documents and $documents[0]) { |
| 445 |
|
|
push @columns, |
| 446 |
|
|
sort {$a->{column} <=> $b->{column}} |
| 447 |
|
|
grep {$_->{column}} ($filter{class} ? $filter{class}->new($keeper)->structure : $documents[0]->structure); |
| 448 |
|
|
} |
| 449 |
8 |
ahitrov@rambler.ru |
|
| 450 |
131 |
ahitrov |
# стандартная жопка таблицы... |
| 451 |
|
|
@columns = (@columns, |
| 452 |
|
|
{attr => '_act_', rusname => 'Действия'}, |
| 453 |
|
|
); |
| 454 |
|
|
|
| 455 |
8 |
ahitrov@rambler.ru |
</%init> |