use parent qw(Rose::Object);
-use Clone qw(clone);
+use Carp;
use SL::File::Backend;
use SL::File::Object;
+use SL::DB;
use SL::DB::History;
+use SL::DB::ShopImage;
use SL::DB::File;
+use SL::DB::FileVersion;
use SL::Helper::UserPreferences;
+use SL::Controller::Helper::ThumbnailCreator qw(file_probe_type);
use SL::JSON;
use constant RENAME_OK => 0;
sub get {
my ($self, %params) = @_;
- die 'no id' unless $params{id};
- my $dbfile = SL::DB::Manager::File->get_first(query => [id => $params{id}]);
- die 'not found' unless $dbfile;
- $main::lxdebug->message(LXDebug->DEBUG2(), "object_id=".$dbfile->object_id." object_type=".$dbfile->object_type." dbfile=".$dbfile);
- SL::File::Object->new(db_file => $dbfile, id => $dbfile->id, loaded => 1);
+ croak "no id or dbfile or guid" unless $params{id} || $params{dbfile} || $params{guid};
+ croak "dbfile has to be of type SL::DB::File"
+ if defined $params{dbfile} && ref $params{dbfile} ne 'SL::DB::File';
+
+ my $dbfile;
+ my $file_version;
+ if (defined $params{guid}) {
+ $file_version = SL::DB::Manager::FileVersion->get_first(where => [guid => $params{guid}]);
+ die 'file version with guid not found: ' . $params{guid} unless $file_version;
+ $dbfile = $file_version->file;
+ if (defined $params{dbfile}) {
+ croak "dbfile doesn't match guid" if $dbfile->id != $params{dbfile}->id;
+ }
+ if (defined $params{id}) {
+ croak "id doesn't match guid" if $dbfile->id != $params{id};
+ }
+ } elsif (defined $params{dbfile}) {
+ $dbfile = $params{dbfile};
+ if (defined $params{id}) {
+ croak "id doesn't match dbfile id" if $dbfile->_id != $params{id};
+ }
+ } elsif (defined $params{id}) {
+ $dbfile = SL::DB::Manager::File->get_first(query => [id => $params{id}]);
+ die 'file with id not found: ' . $params{id} unless $dbfile;
+ }
+
+ my %object_params = (
+ db_file => $dbfile,
+ id => $dbfile->id,
+ loaded => 1,
+ );
+ $object_params{file_version} = $file_version if $file_version;
+ SL::File::Object->new(%object_params);
}
sub get_version_count {
object_id => $params{object_id},
object_type => $params{object_type}
);
- push @query, (file_name => $params{file_name}) if $params{file_name};
- push @query, (file_type => $params{file_type}) if $params{file_type};
- push @query, (mime_type => $params{mime_type}) if $params{mime_type};
- push @query, (source => $params{source}) if $params{source};
+ push @query, (file_name => $params{file_name}) if $params{file_name};
+ push @query, (file_type => $params{file_type}) if $params{file_type};
+ push @query, (mime_type => $params{mime_type}) if $params{mime_type};
+ push @query, (source => $params{source}) if $params{source};
+ push @query, (print_variant => $params{print_variant}) if $params{print_variant};
+ push @query, (uid => $params{uid}) if $params{uid};
my $sortby = $params{sort_by} || 'itime DESC,file_name ASC';
sub get_all_versions {
my ($self, %params) = @_;
my @versionobjs;
- my @fileobjs = $self->get_all(%params);
+ my @fileobjs;
if ( $params{dbfile} ) {
- push @fileobjs, SL::File::Object->new(dbfile => $params{db_file}, id => $params{dbfile}->id, loaded => 1);
+ push @fileobjs, SL::File::Object->new(db_file => $params{dbfile}, id => $params{dbfile}->id, loaded => 1);
} else {
@fileobjs = $self->get_all(%params);
}
foreach my $fileobj (@fileobjs) {
- $main::lxdebug->message(LXDebug->DEBUG2(), "obj=" . $fileobj . " id=" . $fileobj->id." versions=".$fileobj->version_count);
- my $maxversion = $fileobj->version_count;
+ my @file_versions = reverse @{$fileobj->loaded_db_file->file_versions_sorted};
+ my $latest_file_version = shift @file_versions;
+ $fileobj->version($latest_file_version->version);
+ $fileobj->file_version($latest_file_version);
push @versionobjs, $fileobj;
- if ($maxversion > 1) {
- for my $version (2..$maxversion) {
- $main::lxdebug->message(LXDebug->DEBUG2(), "clone for version=".($maxversion-$version+1));
- eval {
- my $clone = clone($fileobj);
- $clone->version($maxversion-$version+1);
- $clone->newest(0);
- $main::lxdebug->message(LXDebug->DEBUG2(), "clone version=".$clone->version." mtime=". $clone->mtime);
- push @versionobjs, $clone;
- 1;
- }
- }
+ foreach my $file_version (@file_versions) {
+ my $clone = $fileobj->clone;
+ $clone->version($file_version->version);
+ $clone->file_version($file_version);
+ $clone->newest(0);
+ push @versionobjs, $clone;
}
}
return @versionobjs;
object_id => $params{object_id},
object_type => $params{object_type}
);
- push @query, (file_name => $params{file_name}) if $params{file_name};
- push @query, (file_type => $params{file_type}) if $params{file_type};
- push @query, (mime_type => $params{mime_type}) if $params{mime_type};
- push @query, (source => $params{source}) if $params{source};
+ push @query, (file_name => $params{file_name}) if $params{file_name};
+ push @query, (file_type => $params{file_type}) if $params{file_type};
+ push @query, (mime_type => $params{mime_type}) if $params{mime_type};
+ push @query, (source => $params{source}) if $params{source};
+ push @query, (print_variant => $params{print_variant}) if $params{print_variant};
+ push @query, (uid => $params{uid}) if $params{uid};
my $cnt = SL::DB::Manager::File->get_all_count(query => [@query]);
return $cnt;
sub delete {
my ($self, %params) = @_;
- die "no id or dbfile" unless $params{id} || $params{dbfile};
+ die "no id or dbfile in delete" unless $params{id} || $params{dbfile};
my $rc = 0;
- eval {
- $rc = SL::DB->client->with_transaction(\&_delete, $self, %params);
+ SL::DB->client->with_transaction(sub {
+ $rc = $self->_delete(%params);
1;
- } or do { die $@ };
+ }) or do { die SL::DB->client->error };
return $rc;
}
}
if ($backend->delete(%params)) {
my $do_delete = 0;
- if ( $params{last} || $params{all_but_notlast} ) {
- if ( $backend->get_version_count > 0 ) {
+ if ( $params{last} || $params{file_version} || $params{all_but_notlast} ) {
+ if ( $backend->get_version_count(%params) > 0 ) {
$params{dbfile}->mtime(DateTime->now_local);
$params{dbfile}->save;
} else {
my ($self, %params) = @_;
my $obj;
- eval {
- $obj = SL::DB->client->with_transaction(\&_save, $self, %params);
+ SL::DB->client->with_transaction(sub {
+ $obj = $self->_save(%params);
1;
- } or do { die $@ };
+ }) or do { die SL::DB->client->error };
return $obj;
}
mime_type => $params{mime_type},
title => $params{title},
description => $params{description},
+ print_variant => $params{print_variant},
+ uid => $params{uid},
);
+ $file->itime($params{mtime}) if $params{mtime};
+ $params{itime} = $params{mtime} if $params{mtime};
}
} else {
$exists = 1;
# load itime for new file
$file->save->load;
}
- $main::lxdebug->message(LXDebug->DEBUG2(), "backend3=" .$file->backend);
+
+ $file->mtime(DateTime->now_local) unless $params{mtime};
+ $file->mtime($params{mtime} ) if $params{mtime};
+
my $backend = $self->_get_backend($file->backend);
$params{dbfile} = $file;
$backend->save(%params);
- $file->mtime(DateTime->now_local);
$file->save;
+ #ShopImage
+ if($file->object_type eq "shop_image"){
+ my $image_content = $params{file_contents};
+ my $thumbnail = file_probe_type($image_content);
+ my $shopimage = SL::DB::ShopImage->new();
+ $shopimage->assign_attributes(
+ file_id => $file->id,
+ thumbnail_content => $thumbnail->{thumbnail_img_content},
+ org_file_height => $thumbnail->{file_image_height},
+ org_file_width => $thumbnail->{file_image_width},
+ thumbnail_content_type => $thumbnail->{thumbnail_img_content_type},
+ object_id => $file->object_id,
+ );
+ $shopimage->save;
+ }
if ($params{file_type} eq 'document' && $params{source} ne 'created') {
SL::DB::History->new(
addition => 'IMPORT',
mime_type => $file->mime_type,
source => $file->source,
file_type => $file->file_type,
+ uid => $file->uid,
file_name => $params{to}
) > 0;
return unless $params{file_type};
my $file = SL::DB::File->new;
$file->file_type($params{file_type});
- my $backend = $self->_get_backend(dbfile => $file->backend);
+ my $backend = $self->_get_backend($self->_get_backend_by_file_type($file));
return unless $backend;
$backend->sync_from_backend(%params);
}
my ($self, $backend_name) = @_;
my $class = 'SL::File::Backend::' . $backend_name;
my $obj = undef;
+ die $::locale->text('no backend enabled') if $backend_name eq 'None';
eval {
eval "require $class";
$obj = $class->new;
- die 'backend not enabled' unless $obj->enabled;
+ die $::locale->text('backend "#1" not enabled',$backend_name) unless $obj->enabled;
1;
} or do {
- die 'backend class not found';
+ if ( $obj ) {
+ die $@;
+ } else {
+ die $::locale->text('backend "#1" not found',$backend_name);
+ }
};
return $obj;
}
object_id => $self->object_id,
object_type => $self->object_type,
mime_type => 'application/pdf',
- file_type => 'documents',
+ file_type => 'document',
file_contents => 'this is no pdf');
my $file1 = SL::File->get(id => $id);
SL::File->rename(id => $id,to => $newname);
my $files1 = SL::File->get_all(object_id => $object_id,
object_type => $object_type,
- file_type => 'images', # may be optional
+ file_type => 'image', # may be optional
source => 'uploaded' # may be optional
);
=over 2
-=item - documents,
+=item - document,
which can be generated files (for sales), scanned files or uploaded files (for purchase) for an ERP-object.
They can exist in different versions. The versioning is handled implicit. All versions of a file may be
deleted by the user if she/he is allowed to do this.
-=item - attachments,
+=item - attachment,
which have additional information for an ERP-objects. They are uploadable. If a filename still exists
on a ERP-Object the new uploaded file is a new version of this or it must be renamed by user.
combinide/merged with the document-file in the time of printing.
Today only PDF-Attachmnets can be merged with the generated document-PDF.
-=item - images,
+=item - image,
they are like attachments, but they may be have thumbnails for displaying.
So the must have an image format like png,jpg. The versioning is like attachments
=item C<file_type>
-The type may be "documents", "attachments" or "images" for a new file.
+The type may be "document", "attachment" or "image" for a new file.
=item C<source>
=item C<file_type>
-The type may be "documents", "attachments" or "images". This parameter is optional.
+The type may be "document", "attachment" or "image". This parameter is optional.
=item C<file_name>