# get translations
$form->{language_values} = "";
- $query = qq|SELECT language_id, translation FROM translation WHERE parts_id = ?|;
+ $query = qq|SELECT language_id, translation, longdescription
+ FROM translation
+ WHERE parts_id = ?|;
my $trq = prepare_execute_query($form, $dbh, $query, conv_i($form->{id}));
- while ($tr = $trq->fetchrow_hashref(NAME_lc)) {
- $form->{language_values} .= "---+++---".$tr->{language_id}."--++--".$tr->{translation};
+ while (my $tr = $trq->fetchrow_hashref(NAME_lc)) {
+ $form->{language_values} .= "---+++---" . join('--++--', @{$tr}{qw(language_id translation longdescription)});
}
$trq->finish;
$form->{parts} = \@assemblies;
}
- $dbh->disconnect;
$main::lxdebug->leave_sub();
}
my $info = selectall_hashref_query($form, $dbh, $query, map { conv_i($_) } @ids);
- if ($params{vendor_id}) {
- $query = qq|SELECT * FROM parts_vendor WHERE (parts_id = ?) AND (vendor_id = ?)|;
- my $sth = prepare_query($form, $dbh, $query);
-
- foreach my $part (@{ $info }) {
- do_statement($form, $sth, $query, $part->{id}, conv_i($params{vendor_id}));
- $part->{vendor_info} = $sth->fetchrow_hashref();
- }
-
- $sth->finish();
- }
-
if ('' eq ref $params{id}) {
$info = $info->[0] || { };