projekt kivitendo

use SL::Webdav::File;

use Rose::Object::MakeMethods::Generic (

);

__PACKAGE__->run_before('check_auth_edit');

  subject               => t8('Subject'),

  letternumber          => t8('Letternumber'),

  customer_id           => t8('Customer'),

  contact               => t8('Contact'),

);

sub action_add {

  my ($self, %params) = @_;

  return $self->action_add

    unless $::form->{letter} || $::form->{draft};

  $self->_display(

    title  => t8('Edit Letter'),

  my $letter = $self->letter;

    return $self->js

      ->replaceWith(

        '#letter_cp_id',

      ->render;

  }

  my $default;

  if (   $letter->contact

      && $letter->contact->cp_cv_id

    $default = $letter->contact->cp_id;

  } else {

    $default = '';

  );

}

sub _display {

  my ($self, %params) = @_;

 $params{title} ||= t8('Edit Letter');

  $::form->{type}             = 'letter';   # needed for print_options

  $::request->layout->add_javascripts('customer_or_vendor_selection.js');

  $::request->layout->add_javascripts('edit_part_window.js');

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

  $self->{report} = $report;

  my %column_defs = (

    date                  => { text => t8('Date'),         sub => sub { $_[0]->date_as_date } },

                               obj_link => sub { $self->url_for(action => 'edit', 'letter.id' => $_[0]->id, callback => $self->models->get_callback) }  },

    letternumber          => { text => t8('Letternumber'), sub => sub { $_[0]->letternumber },

                               obj_link => sub { $self->url_for(action => 'edit', 'letter.id' => $_[0]->id, callback => $self->models->get_callback) }  },

    contact               => { text => t8('Contact'),       sub => sub { $_[0]->contact ? $_[0]->contact->full_name : '' } },

  );

  $report->set_columns(%column_defs);

  $report->set_column_order(@columns);

  $report->set_options_from_form;

  $self->models->disable_plugin('paginated') if $report->{options}{output_format} =~ /^(pdf|csv)$/i;

  $self->models->finalize;

  $self->models->set_report_generator_sort_options(report => $report, sortable_columns => \@sortable);

  return 0 if $params{skip_drafts};

  return unless @$letter_drafts;

                                           ->assign_attributes(%{ $::form->{letter} });

  if ($letter->cp_id) {

      # contacts don't have language_id yet

#     $letter->greeting(GenericTranslations->get(

#       translation_type => 'greetings::' . ($letter->contact->cp_gender eq 'f' ? 'female' : 'male'),

#     ));

  }

  $letter;

}

  SL::Controller::Helper::GetModels->new(

    controller   => $self,

    model        => 'Letter',

    sorted       => \%sort_columns,

    with_objects => [ 'contact', 'salesman', 'employee' ],

  );

  } @all_objects ];

}

sub check_auth_edit {

  $::auth->assert('sales_letter_edit');

}

Simple letter CRUD controller with drafting capabilities.

copy to webdav is crap

=head1 AUTHOR

Sven Schöling E<lt>s.schoeling@linet-services.deE<gt>

  $self;

}

1;

sub object_class { 'SL::DB::Letter' }

__PACKAGE__->make_manager_methods;

sub _sort_spec {

  return ( columns => { SIMPLE    => 'ALL',

__PACKAGE__->meta->columns(

  body         => { type => 'text' },

  cp_id        => { type => 'integer' },

  date         => { type => 'date' },

  employee_id  => { type => 'integer' },

  greeting     => { type => 'text' },

  reference    => { type => 'text' },

  salesman_id  => { type => 'integer' },

  subject      => { type => 'text' },

);

__PACKAGE__->meta->primary_key_columns([ 'id' ]);

    class       => 'SL::DB::Employee',

    key_columns => { salesman_id => 'id' },

  },

);

1;

__PACKAGE__->meta->columns(

  body         => { type => 'text' },

  cp_id        => { type => 'integer' },

  date         => { type => 'date' },

  employee_id  => { type => 'integer' },

  greeting     => { type => 'text' },

  reference    => { type => 'text' },

  salesman_id  => { type => 'integer' },

  subject      => { type => 'text' },

);

__PACKAGE__->meta->primary_key_columns([ 'id' ]);

    class       => 'SL::DB::Employee',

    key_columns => { salesman_id => 'id' },

  },

);

1;

  das auf dem Zielsystem absolut nicht möglich ist, muss das Upgradescript

  sql/Pg-Upgrade2/trigram_indices.sql deaktiviert oder entfernt werden.

Upgrade auf v3.4.1

==================

  - Neues Recht "Verknüpfte Belege", standardmäßig erlaubt. Betrifft alle

    Belege und die Projektstammdaten

Administrative Änderungen

  - Diverse Textsuchen werden jetzt durch eine neue Klasse Indizes

  'Edit project link'           => 'Projektverknüpfung bearbeiten',

  'Edit project status'         => 'Projektstatus bearbeiten',

  'Edit project type'           => 'Projekttypen bearbeiten',

  'Edit purchase price rule'    => 'Einkaufspreisregel bearbeiten',

  'Edit requirement spec'       => 'Pflichtenheft bearbeiten',

  'Edit requirement spec status' => 'Pflichtenheftstatus bearbeiten',

  'Show overdue sales quotations and requests for quotations...' => 'Überfällige Angebote und Preisanfragen anzeigen...',

  'Show parts'                  => 'Artikel anzeigen',

  'Show parts longdescription (notes) in select list' => 'Langtext in Auswahlliste bei mehreren Treffern im Stammdaten-Bestand anzeigen',

  'Show requirement spec'       => 'Pflichtenheft anzeigen',

  'Show requirement spec template' => 'Pflichtenheftvorlage anzeigen',

  'Show sales letters report'   => 'Verkaufsbrief anzeigen',

  access: sales_letter_edit

  params:

    action: Letter/add

- parent: ar

  id: ar_invoices

  name: Invoices

  access: sales_letter_report

  params:

    action: Letter/list

- id: ap

  name: AP

  icon: ap

  params:

    action: add

    type: invoice

- parent: ap

  id: ap_reports

  name: Reports

  params:

    action: DeliveryValueReport/list

    vc: vendor

- id: warehouse

  name: Warehouse

  icon: warehouse

% config: tag-style=$( )$

$( USE KiviLatex )$

$( USE P )$

\input{inheaders.tex}

$( KiviLatex.required_packages_for_html )$

  <input type="hidden" name="letter.id" value="[% letter.id | html %]">

  <input type="hidden" name="draft.id" value="[% draft.id | html %]">

  <input type="hidden" name="type" value="[% type | html %]">

  [%- INCLUDE 'common/flash.html' %]

 <td width=50%>

  <!-- upper left block -->

   <table width=90%>

    <tr>

     <th align='right'>[% 'Customer' | $T8 %]:</th>

     <td>[% P.customer_vendor_picker('letter.customer_id', letter.customer_id, type='customer') %]

[%- END %]

     </td>

    </tr>

    <tr>

     <th align='right'>[% 'Contact Person' | $T8 %]</th>

    </tr>

    <tr>

     <th align='right'>[% 'Your Reference' | $T8 %]:</th>

      var data = $('form').serializeArray();

      data.push({ name: 'action_update_contacts', value: 1 });

      $.post('controller.pl', data, kivi.eval_json_result);

    })

  })

</script>

       <th class="listheading">&nbsp;</th>

       <th class="listheading">[% 'Date' | $T8 %]</th>

       <th class="listheading">[% 'Subject' | $T8 %]</th>

       <th class="listheading">[% 'Customer' | $T8 %]</th>

      </tr>

      [% FOREACH row = LETTER_DRAFTS %]

        <td>[% L.checkbox_tag("ids[+]", value=row.id) %]</td>

        <td>[% row.date.to_kivitendo | html %]</td>

        <td><a href="[% SELF.url_for(action='edit', 'draft.id'=row.id) %]">[% row.subject | html %]</a></td>

        <td>[% row.customer.displayable_name | html %]</td>

       </tr>

      [% END %]

     </table>

   <tr>

    <td>

     <input type="hidden" name="action" value="Letter/dispatch">

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

     <input type="submit" class="submit" name="action_delete_drafts" value="[% 'Delete drafts' | $T8 %]">

   </td>

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

   <td>[% L.input_tag('filter.letternumber:substr::ilike', filter.letternumber_substr__ilike, style='width:250px') %]</th>

  </tr>

  <tr>

   <td align="right">[% 'Customer' | $T8 %]</td>

   <td>[% L.customer_vendor_picker('filter.customer_id', filter.customer_id, type='customer', style='width:250px') %]</td>

  </tr>

  <tr>

   <td align="right">[% 'Contact' | $T8 %]</td>

   <td>[% L.input_tag('filter.contact.cp_name:substr::ilike', filter.contact.cp_name_substr__ilike, style='width:250px') %]</th>

  </tr>

 </table>

 [% L.hidden_tag('sort_by', FORM.sort_by) %]

 [% L.hidden_tag('sort_dir', FORM.sort_dir) %]

 [% L.hidden_tag('page', FORM.page) %]