projekt kivitendo

    qq|  pr.projectnumber AS globalprojectnumber, | .

    qq|  e.name AS employee, | .

    qq|  v.vendornumber, v.country, v.ustid, | .

    qq|  tz.description AS taxzone, | .

    qq|  pt.description AS payment_terms, | .

    qq|  department.description AS department, | .

    $where .= " AND a.notes ILIKE ?";

    push(@values, like($form->{notes}));

  }

  if ($form->{project_id}) {

    $where .=

      qq| AND ((a.globalproject_id = ?) OR EXISTS | .

  my @columns =

    qw(transdate id type invnumber ordnumber name netamount tax amount paid datepaid

       vendornumber country ustid taxzone payment_terms charts debit_chart direct_debit

       insertdate items);

  my @hidden_variables = map { "l_${_}" } @columns;

                                           transdatefrom transdateto duedatefrom duedateto datepaidfrom datepaidto

                                           parts_partnumber parts_description department_id taxzone_id payment_id

                                           fulltext insertdatefrom insertdateto);

    'duedate'                 => { 'text' => $locale->text('Due Date'), },

    'transaction_description' => { 'text' => $locale->text('Transaction description'), },

    'notes'                   => { 'text' => $locale->text('Notes'), },

    'employee'                => { 'text' => $locale->text('Employee'), },

    'globalprojectnumber'     => { 'text' => $locale->text('Document Project Number'), },

    'department'              => { 'text' => $locale->text('Department'), },

    'items'                   => { 'text' => $locale->text('Positions'), },

  );

    my $sortdir                 = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};

    $column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir";

  }

  push @options, $locale->text('Invoice Number')          . " : $form->{invnumber}"                      if ($form->{invnumber});

  push @options, $locale->text('Order Number')            . " : $form->{ordnumber}"                      if ($form->{ordnumber});

  push @options, $locale->text('Notes')                   . " : $form->{notes}"                          if ($form->{notes});

  push @options, $locale->text('Transaction description') . " : $form->{transaction_description}"        if ($form->{transaction_description});

  push @options, $locale->text('Part Description')        . " : $form->{parts_description}"              if $form->{parts_description};

  push @options, $locale->text('Part Number')             . " : $form->{parts_partnumber}"               if $form->{parts_partnumber};

      <th align="right">[% 'Part Description' | $T8 %]</th>

      <td>[% L.input_tag("parts_description", "", style=style) %]</td>

     </tr>

     <tr>

      <th align="right">[% 'Full Text' | $T8 %]</th>

      <td>[% L.input_tag('fulltext', '', style=style) %]</td>

     <tr>

      <th align="right">[% 'Project Number' | $T8 %]</th>

      <td>[% P.project.picker("project_id", project_id, active="both", valid="both", style=style) %]</td>

     </tr>

     <tr>

      <th align=right nowrap>[% 'Invoice Date' | $T8 %]</th>

          <tr>

           <td align=right><input name="l_notes" class=checkbox type=checkbox value=Y></td>

           <td nowrap>[% 'Notes' | $T8 %]</td>

           <td align=right><input name="l_employee" class=checkbox type=checkbox value=Y></td>

           <td nowrap>[% 'Employee' | $T8 %]</td>

           <td align=right><input name="l_department" class=checkbox type=checkbox value=Y></td>