projekt kivitendo

    $self->{note} = SL::DB::Note->new(id => $::form->{note}->{id})->load();

    $self->{note_followup} = $self->{note}->follow_up;

    $self->{note_followup_link} = $self->{note_followup}->follow_up_link;

  } else {

    $self->{note} = SL::DB::Note->new();

    $self->{note_followup} = SL::DB::FollowUp->new();

  $self->{note_followup}->note($self->{note});

  $self->{note_followup}->created_by($curr_employee->id);

  $self->{note_followup_link}->trans_type($self->is_vendor() ? 'vendor' : 'customer');

  $self->{note_followup_link}->trans_info($self->{cv}->name);

  if (!$params{id}) {

    ($params{id}) = selectrow_query($form, $dbh, qq|SELECT nextval('follow_up_id')|);

    push @values, $::myconfig{login};

  } else {

  }

  $params{note_id} = Notes->save('id'           => $params{note_id},

                                 'body'         => $params{body},

                                 'dbh'          => $dbh,);

  do_query($form, $dbh, qq|DELETE FROM follow_up_links WHERE follow_up_id = ?|, conv_i($params{id}));

  my $myconfig = \%main::myconfig;

  my $form     = $main::form;

  $main::lxdebug->leave_sub();

}

  my ($query, @values);

  my ($employee_id) = selectrow_query($form, $dbh, qq|SELECT id FROM employee WHERE login = ?|, $::myconfig{login});

                         FROM follow_ups fu

                         LEFT JOIN notes n ON (fu.note_id = n.id)

                         LEFT JOIN follow_up_created_for_employees ON (follow_up_created_for_employees.follow_up_id = fu.id)

                         WHERE (fu.id = ?)

                           AND (   (fu.created_by = ?) OR (follow_up_created_for_employees.employee_id = ?)

                                OR (fu.created_by IN (SELECT DISTINCT what FROM follow_up_access WHERE who = ?)))|;

  if ($params{done} ne $params{not_done}) {

    my $not  = $params{not_done} ? 'NOT' : '';

  }

  if ($params{not_id}) {

  $query  = qq|SELECT DISTINCT fu.*, n.subject, n.body, n.created_by,

                 fu.follow_up_date <= current_date AS due,

                 fu.itime::DATE                    AS created_on,

               FROM follow_ups fu

               LEFT JOIN notes    n    ON (fu.note_id          = n.id)

               LEFT JOIN employee eby  ON (n.created_by        = eby.id)

               LEFT JOIN follow_up_created_for_employees ON (follow_up_created_for_employees.follow_up_id = fu.id)

               WHERE ((fu.created_by = ?) OR (follow_up_created_for_employees.employee_id = ?)

                      $where_user)

                 $where

.thumbnail {

  cursor: pointer;

}

  'Financial controlling report for open sales orders' => 'Finanzcontrollingbericht für offene Verkaufsaufträge',

  'Financial overview for #1'   => 'Finanzübersicht für #1',

  'Finish'                      => 'Abschließen',

  'First 20 Lines'              => 'Nur erste 20 Datensätze',

  'Firstname'                   => 'Vorname',

  'Fix transaction'             => 'Buchung korrigieren',

  'assembled'                   => 'Gefertigt',

  'assembly'                    => 'Erzeugnis',

  'assembly_list'               => 'erzeugnisliste',

  'averaged values, in invoice mode only useful when filtered by a part' => 'gemittelte Werte, im Rechnungsmodus nur sinnvoll wenn nach Artikel gefiltert wird',

  'averconsumed_br'             => 'Ø mtl.',

  'back'                        => 'zurück',

  'brutto'                      => 'brutto',

  'building data'               => 'Verarbeite Daten',

  'building report'             => 'Erstelle Bericht',

  'can not allocate #1 units of #2, missing #3 units' => 'Kann keine #1 Einheiten von #2 belegen, es fehlen #3 Einheiten',

  'can not allocate enough resources for production' => 'Kann nicht genug Mengen für die Produktion belegen',

  'can only parse a pdf file'   => 'Kann nur eine gültige PDF-Datei verwenden.',

  'Financial controlling report for open sales orders' => '',

  'Financial overview for #1'   => '',

  'Finish'                      => '',

  'First 20 Lines'              => '',

  'Firstname'                   => '',

  'Fix transaction'             => '',

  'assembled'                   => '',

  'assembly'                    => '',

  'assembly_list'               => '',

  'averaged values, in invoice mode only useful when filtered by a part' => '',

  'averconsumed_br'             => 'Ø monthly',

  'back'                        => '',

  'brutto'                      => '',

  'building data'               => '',

  'building report'             => '',

  'can not allocate #1 units of #2, missing #3 units' => '',

  'can not allocate enough resources for production' => '',

  'can only parse a pdf file'   => '',

  <p>

    <table>

      <tr>

        <td valign="right">[% 'Subject' | $T8 %]</td>

     <td>

     <td valign="top">

      <table>

        [% FOREACH auth_group = SELF.all_auth_groups %]

         <tr onclick="follow_up_do_select(this)" data-ids='[% FOREACH employee = auth_group.get_employees %][% employee.id %][% IF !loop.last %],[% END%][% END%]' class="interactive cursor-pointer">

          <td class="listrow1"><b>←&nbsp;[% auth_group.name %]</b>: [% auth_group.description %]</td>

        <td>&nbsp;</td>

        <td>

          <label for="note_followup_done">[% 'Follow-Up done' | $T8 %]</label>

        </td>

      </tr>

  <input type="hidden" name="POPUP_MODE" value="[% HTML.escape(POPUP_MODE) %]">

  <table>

    <tr>

     <td align="top">[% 'Follow-Up for user' | $T8 %]</td>

     <td valign="top">

     <td>

     <td valign="top">

      <table>

        [% FOREACH auth_group = all_auth_groups %]

         <tr onclick="follow_up_do_select(this)" data-ids='[% FOREACH employee = auth_group.get_employees %][% employee.id %][% IF !loop.last %],[% END%][% END%]' class="interactive cursor-pointer">

          <td class="listrow1"><b>←&nbsp;[% auth_group.name %]</b>: [% auth_group.description %]</td>