File Coverage

blib/lib/App/bif/show/task.pm

Criterion	Covered	Total	%
statement	12	32	37.5
branch	0	2	0.0
condition			n/a
subroutine	4	4	100.0
pod	1	1	100.0
total	17	39	43.5

package App::bif::show::task;
use strict;
use warnings;
use Bif::Mo;

our $VERSION = '0.1.5_5';
extends 'App::bif::show';

sub run {
    my $self = shift;
    my $opts = $self->opts;
    my $db   = $self->db;

    $opts->{id} = $self->uuid2id( $opts->{id} );

    my $info = $self->get_node( $opts->{id}, 'task' );
    my $now = $self->now;

    DBIx::ThinSQL->import(qw/sum qv concat coalesce/);

    my $ref = $db->xhashref(
        select => [
            'n.id AS id',
            'n.uuid as uuid',
            'n.path AS path',
            'hn.name AS hub',
            'h.location',
            'substr(n2.uuid,1,8) AS project_uuid',
            'tasks.title AS title',
            'n.ctime AS ctime',
            'n.ctimetz AS ctimetz',
            'n.ctimetzhm AS ctimetzhm',
            "$now - n.ctime AS ctime_age",
            'c2.mtime AS mtime',
            'c2.mtimetz AS mtimetz',
            'c2.mtimetzhm AS mtimetzhm',
            "$now - c2.mtime AS mtime_age",
            'c1.author AS author',
            "c1.author_contact_method || ': ' || c1.author_contact AS contact",
            'c1.message AS message',
            'ts.status AS status',
            'c12.mtime AS smtime',
            'e1.name as creator',
            'e2.name as updator',
        ],
        from       => 'nodes n',
        inner_join => 'changes c1',
        on         => 'c1.id = n.first_change_id',
        inner_join => 'entities e1',
        on         => 'e2.id = c2.identity_id',
        inner_join => 'changes c2',
        on         => 'c2.id = n.last_change_id',
        inner_join => 'entities e2',
        on         => 'e1.id = c1.identity_id',
        inner_join => 'tasks',
        on         => 'tasks.id = n.id',
        inner_join => 'task_status ts',
        on         => 'ts.id = tasks.task_status_id',
        inner_join => 'projects p',
        on         => 'p.id = ts.project_id',
        left_join  => 'nodes hn',
        on         => 'hn.id = p.default_hub_id',
        left_join  => 'hubs h',
        on         => 'h.id = p.default_hub_id',
        inner_join => 'nodes n2',
        on         => 'n2.id = p.id',
        inner_join => 'changes AS c12',
        on         => 'c12.id = tasks.change_id',
        where      => [ 'n.id = ', qv( $info->{id} ) ],
    );

    my @data;
    my ( $t1, $t2 ) = $self->ctime_ago($ref);

    my $yellow = $self->colours('yellow');

    push(
        @data,
        $self->header(
            $yellow . 'Task',
            $yellow . $ref->{id},
            $yellow . $ref->{uuid}
        )
    );

    push( @data, $self->header( ' Title', $ref->{title} ) );

    push(
        @data,
        $self->header(
            '  Status', "$ref->{status} [$ref->{path} ($ref->{id})]"
        )
    );

    if ( $opts->{full} ) {
        require Text::Autoformat;
        push(
            @data,
            $self->header(
                'Description',
                Text::Autoformat::autoformat(
                    $ref->{message},
                    {
                        right => 60,
                        all   => 1
                    }
                )
            ),
        );
    }

    ( $t1, $t2 ) = $self->mtime_ago($ref);

    $self->start_pager;
    print $self->render_table( 'l  l', undef, \@data, 1 );

    print "\n";
    $self->dispatch( 'App::bif::log::task', { opts => { id => $opts->{id} } } );

    $self->ok( 'ShowTask', \@data );

}

1;
__END__