projekt kivitendo

    itime         => { type => 'timestamp', default => 'now()' },

    mtime         => { type => 'timestamp' },

    active        => { type => 'boolean', default => 'true' },

  ],

  primary_key_columns => [ 'id' ],

  unique_key => [ 'projectnumber' ],

  allow_inline_column_values => 1,

);

1;

    push @filters, 'NOT COALESCE(p.active, FALSE)';

  }

  my ($cvar_where, @cvar_values) = CVar->build_filter_query('module'         => 'Projects',

                                                            'trans_id_field' => 'p.id',

                                                            'filter'         => $form);

  my $sortorder =  $params{sort} ? $params{sort} : "projectnumber";

  $sortorder    =~ s/[^a-z_]//g;

                     FROM project p

                     $where

                     ORDER BY $sortorder|;

    $params{active} = 1;

  }

  do_query($form, $dbh, $query, @values);

  CVar->save_custom_variables('dbh'       => $dbh,

}

1;

  my $report       = SL::ReportGenerator->new(\%myconfig, $form);

  my @includeable_custom_variables = grep { $_->{includeable} } @{ $cvar_configs };

  my @searchable_custom_variables  = grep { $_->{searchable} }  @{ $cvar_configs };

  my %column_defs  = (

    'projectnumber'            => { 'text' => $locale->text('Number'), },

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

    'active'                   => { 'text' => $locale->text('Active'), 'visible' => 'both' eq $filter->{active}, },

    %column_defs_cvars,

    );

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

    $column_defs{$_}->{visible} = 1;

  }

  push @options, $locale->text('All')                                            if ($filter->{all});

  push @options, $locale->text('Orphaned')                                       if ($filter->{orphaned});

  push @options, $locale->text('Project Number') . " : $filter->{projectnumber}" if ($filter->{projectnumber});

  push @options, $locale->text('Active')                                         if ($filter->{active} eq 'active');

  push @options, $locale->text('Inactive')                                       if ($filter->{active} eq 'inactive');

  push @options, $locale->text('Orphaned')                                       if ($filter->{status} eq 'orphaned');

  foreach my $project (@{ $form->{project_list} }) {

    $project->{active} = $project->{active} ? $locale->text('Yes')  : $locale->text('No');

    my $row = { map { $_ => { 'data' => $project->{$_} } } keys %{ $project } };

  $form->{title}     = $form->{project}->{id} ? $locale->text("Edit Project") : $locale->text("Add Project");

  $form->{CUSTOM_VARIABLES} = CVar->get_custom_variables('module' => 'Projects', 'trans_id' => $form->{project}->{id});

#  $main::lxdebug->dump(0, "cv", $form->{CUSTOM_VARIABLES});

  CVar->render_inputs('variables' => $form->{CUSTOM_VARIABLES}) if (scalar @{ $form->{CUSTOM_VARIABLES} });

  'Client Configuration saved!' => 'Mandantenkonfiguration gespeichert!',

  'Close'                       => 'Übernehmen',

  'Close Books up to'           => 'Die Bücher abschließen bis zum',

  'Close Flash'                 => 'Schließen',

  'Close SEPA exports'          => 'SEPA-Export abschließen',

  'Close Window'                => 'Fenster Schließen',

  'Introduction of Buchungsgruppen' => 'Einführung von Buchungsgruppen',

  'Introduction of units'       => 'Einführung von Einheiten',

  'Inv. Duedate'                => 'Rg. Fälligkeit',

  'Invalid follow-up ID.'       => 'Ungültige Wiedervorlage-ID.',

  'Invalid quantity.'           => 'Die Mengenangabe ist ungültig.',

  'Invdate'                     => 'Rechnungsdatum',

  'Please select the source bank account for the transfers:' => 'Bitte wählen Sie das Bankkonto als Quelle für die Überweisungen aus:',

  'Please seletct the dataset you want to delete:' => 'Bitte wählen Sie die zu löschende Datenbank aus:',

  'Please specify a description for the warehouse designated for these goods.' => 'Bitte geben Sie den Namen des Ziellagers für die übernommenen Daten ein.',

  'Plural'                      => 'Plural',

  'Port'                        => 'Port',

  'Portrait'                    => 'Hochformat',

  'Username'                    => 'Benutzername',

  'Users in this group'         => 'BenutzerInnen in dieser Gruppe',

  'Ust-IDNr'                    => 'USt-IdNr.',

  'Valid from'                  => 'Gültig ab',

  'Valid until'                 => 'gültig bis',

  'Value'                       => 'Wert',

  'list_of_payments'            => 'zahlungsausgaenge',

  'list_of_receipts'            => 'zahlungseingaenge',

  'list_of_transactions'        => 'buchungsliste',

  'logout'                      => 'abmelden',

  'male'                        => 'männlich',

  'mark as paid'                => 'als bezahlt markieren',

    <table>

     <tr>

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

     </tr>

     <tr>

      </td>

     </tr>

     [%- IF project.id %]

     <tr>

     </tr>

     [%- END %]

    </table>

     <td><input name="filter.description" size="60"></td>

    </tr>

    [% CUSTOM_VARIABLES_FILTER_CODE %]

    <tr>

        </td>

       </tr>

       <tr>

        <td>

         <input type="radio" name="filter.status" id="status_all" value="all" checked>

   <input class="submit" type="submit" name="action" value="[% 'Continue' | $T8 %]">

  </p>

 </form>