PlaygroundGame\Service\PostVote::getGrid()

Complexity

Conditions	10
Paths	4

Size

Total Lines

131

Duplication

Lines	9
Ratio	6.87 %

Importance

Changes

0

<?php
    public function getGrid($game)
    {
        $qb = $this->getEntriesQuery($game);
        // echo $qb->getQuery()->getSQL();
        // die('---');

        /* @var $grid \ZfcDatagrid\Datagrid */
        $grid = $this->serviceLocator->get('ZfcDatagrid\Datagrid');
        $grid->setTitle('Entries');
        $grid->setDataSource($qb);
        $grid->setDefaultItemsPerPage(50);

        $col = new Column\Select('id', 'p');
        $col->setLabel('Id');
        $col->setIdentity(true);
        $grid->addColumn($col);

        $colType = new Type\DateTime(
            'Y-m-d H:i:s',
            \IntlDateFormatter::MEDIUM,
            \IntlDateFormatter::MEDIUM
        );
        $colType->setSourceTimezone('UTC');

        $col = new Column\Select('created_at', 'u');
        $col->setLabel('Created');
        $col->setType($colType);
        $grid->addColumn($col);

        $col = new Column\Select('username', 'u');
        $col->setLabel('Username');
        $grid->addColumn($col);

        $col = new Column\Select('email', 'u');
        $col->setLabel('Email');
        $grid->addColumn($col);

        $col = new Column\Select('firstname', 'u');
        $col->setLabel('Firstname');
        $grid->addColumn($col);

        $col = new Column\Select('lastname', 'u');
        $col->setLabel('Lastname');
        $grid->addColumn($col);

        $col = new Column\Select('winner', 'e');
        $col->setLabel('Status');
        $col->setReplaceValues(
            [
                0 => 'looser',
                1 => 'winner',
            ]
        );
        $grid->addColumn($col);

        $imageFormatter = new Formatter\Image();
        //Set the prefix of the image path and the prefix of the link
        $imageFormatter->setPrefix('/');
        $imageFormatter->setAttribute('width', '120');
        $imageFormatter->setLinkAttribute('class', 'pop');

        if ($game->getForm()) {
            $form = json_decode($game->getForm()->getForm(), true);
            foreach ($form as $element) {
                foreach ($element as $k => $v) {
                    if ($k !== 'form_properties') {
                        $querySelect = new Expr\Select("MAX(CASE WHEN f.name = '".$v[0]['name']."' THEN f.value ELSE '' END)");
                        if ($v[0]['type'] == 'file') {
                            // print_r($v[0]['data']['fileextension']);
                            // die('---');
                            $col = new Column\Select($querySelect, $v[0]['name']);
                            //$col->setType(new Type\Image());
                            if (strpos($v[0]['data']['fileextension'], 'png') !== false) {

This code seems to be duplicated across your project.

                                $col->addFormatter($imageFormatter);
                            }
                            if (strpos($v[0]['data']['fileextension'], 'mp4') !== false) {

This code seems to be duplicated across your project.

                                $col->addFormatter(new Formatter\Link());
                            }
                            if (strpos($v[0]['data']['fileextension'], 'pdf') !== false) {

This code seems to be duplicated across your project.

                                $col->addFormatter(new Formatter\Link());
                            }
                        } else {
                            $col = new Column\Select($querySelect, $v[0]['name']);
                        }
                        $col->setLabel($v[0]['name']);
                        $col->setUserFilterDisabled(true);
                        $grid->addColumn($col);
                    }
                }
            }
        }

        if ($game->getVoteActive()) {
            $querySelect = new Expr\Select("COUNT(vo.id)");
            $col = new Column\Select($querySelect, "votes");
            $col->setLabel("Votes");
            $col->setUserFilterDisabled(true);
            $grid->addColumn($col);
        }

        $querySelect = new Expr\Select("COUNT(v.id)");
        $col = new Column\Select($querySelect, "views");
        $col->setLabel("Views");
        $col->setUserFilterDisabled(true);
        $grid->addColumn($col);

        $querySelect = new Expr\Select("COUNT(s.id)");
        $col = new Column\Select($querySelect, "shares");
        $col->setLabel("Shares");
        $col->setUserFilterDisabled(true);
        $grid->addColumn($col);

        $actions = new Column\Action();
        $actions->setLabel('');

        $viewAction = new Column\Action\Button();
        $viewAction->setLabel('Moderate');
        $rowId = $viewAction->getRowIdPlaceholder();
        $viewAction->setLink('/admin/game/postvote-moderation-edit/'.$rowId);
        $actions->addAction($viewAction);

        $grid->addColumn($actions);

        // $action = new Action\Mass();
        // $action->setTitle('This is incredible');
        // $action->setLink('/admin/game/postvote-mod-list');
        // $action->setConfirm(true);
        // $grid->addMassAction($action);

        return $grid;
    }