69 |
|
|
70 |
print STDERR "backup: $backup_from - $backup_to files: $files_from - $files_to cond:" . join(" | ",@conditions); |
print STDERR "backup: $backup_from - $backup_to files: $files_from - $files_to cond:" . join(" | ",@conditions); |
71 |
|
|
72 |
push( @conditions, ' backups.hostID = ' . $param->{'search_host'} ) if ($param->{'search_host'}); |
push( @conditions, ' files.shareid = ' . $param->{'search_share'} ) if ($param->{'search_share'}); |
73 |
|
|
74 |
push (@conditions, " upper(files.name) LIKE upper('%".$param->{'search_filename'}."%')") if ($param->{'search_filename'}); |
push (@conditions, " upper(files.path) LIKE upper('%".$param->{'search_filename'}."%')") if ($param->{'search_filename'}); |
75 |
|
|
76 |
return ( |
return ( |
77 |
join(" and ", @conditions), |
join(" and ", @conditions), |
94 |
files.backupNum AS backupNum, |
files.backupNum AS backupNum, |
95 |
files.name AS filename, |
files.name AS filename, |
96 |
files.path AS filepath, |
files.path AS filepath, |
|
shares.share||files.fullpath AS networkPath, |
|
97 |
files.date AS date, |
files.date AS date, |
98 |
files.type AS filetype, |
files.type AS filetype, |
99 |
files.size AS size, |
files.size AS size, |