projekt kivitendo

  date         => t8('Date'),

    staff_member_id => SL::DB::Manager::Employee->current->id,

    "date:date::ge" => DateTime->today_local->add(weeks => -2)->to_kivitendo,

  my @columns  = qw(date start_time end_time customer part project description staff_member duration booked);

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

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

           nulls   => {

             date       => 'FIRST',

             start_time => 'FIRST',

             end_time   => 'FIRST',

           },

           columns => { SIMPLE     => 'ALL' ,

                        start_time => [ 'date', 'start_time' ],

                        end_time   => [ 'date', 'end_time' ],

                        customer   => [ 'lower(customer.name)', 'date','start_time'],

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

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

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

-- @tag: time_recordings_date_duration

-- @description: Erweiterung Zeiterfassung um Datum und Dauer

-- @depends: time_recordings2

ALTER TABLE time_recordings ADD   COLUMN date     DATE;

ALTER TABLE time_recordings ADD   COLUMN duration INTEGER;

UPDATE time_recordings SET date = start_time::DATE;

ALTER TABLE time_recordings ALTER COLUMN start_time DROP NOT NULL;

ALTER TABLE time_recordings ALTER COLUMN date SET NOT NULL;

UPDATE time_recordings SET duration = EXTRACT(EPOCH FROM (end_time - start_time))/60;

-- trigger to set date from start_time

CREATE OR REPLACE FUNCTION time_recordings_set_date_trigger()

RETURNS TRIGGER AS $$

  BEGIN

    IF NEW.start_time IS NOT NULL THEN

      NEW.date = NEW.start_time::DATE;

    END IF;

    RETURN NEW;

  END;

$$ LANGUAGE plpgsql;

CREATE TRIGGER time_recordings_set_date BEFORE INSERT OR UPDATE ON time_recordings FOR EACH ROW EXECUTE PROCEDURE time_recordings_set_date_trigger();

-- trigger to set duration from start_time and end_time

CREATE OR REPLACE FUNCTION time_recordings_set_duration_trigger()

RETURNS TRIGGER AS $$

  BEGIN

    IF NEW.start_time IS NOT NULL AND NEW.end_time IS NOT NULL THEN

      NEW.duration = EXTRACT(EPOCH FROM (NEW.end_time - NEW.start_time))/60;

    END IF;

    RETURN NEW;

  END;

$$ LANGUAGE plpgsql;

CREATE TRIGGER time_recordings_set_duration BEFORE INSERT OR UPDATE ON time_recordings FOR EACH ROW EXECUTE PROCEDURE time_recordings_set_duration_trigger();

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

   <td>[% L.date_tag('filter.date:date::ge', filter.date_date__ge) %]</td>

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

   <td>[% L.date_tag('filter.date:date::le', filter.date_date__le) %]</td>