ZfTable\Controller\TableController

Complexity

Total Complexity

56

Size/Duplication

Total Lines	573
Duplicated Lines	25.31 %

Coupling/Cohesion

Components	1
Dependencies	23

Importance

Changes

0

51 Methods

Rating	Name	Duplication	Size	Complexity
A	getEntityManager()	0	7	2
A	changesAction()	0	4	1
A	bootstrapAction()	0	3	1
A	additionalParamsAction()	0	3	1
A	ajaxadditionalParamsAction()	9	9	1
A	javascriptEventsAction()	0	3	1
A	ajaxJavascriptEventsAction()	9	9	1
A	arrayAction()	0	3	1
A	ajaxArrayAction()	0	20	1
A	doctrineAction()	0	3	1
A	ajaxDoctrineAction()	0	32	2
A	callableAction()	0	3	1
A	ajaxCallableAction()	9	9	1
A	columnFilteringAction()	0	3	1
A	ajaxColumnFilteringAction()	9	9	1
A	editableAction()	0	3	1
A	ajaxEditableAction()	9	9	1
A	updateRowAction()	0	9	1
A	csvExportAction()	0	3	1
A	ajaxCsvExportAction()	9	9	1
A	separatableAction()	0	3	1
A	ajaxSeparatableAction()	0	12	1
A	variableAttrRowAction()	0	4	1
A	newPluginConditionAction()	0	4	1
A	ajaxNewPluginConditionAction()	9	9	1
A	baseAction()	0	3	1
A	ajaxBaseAction()	9	9	1
A	mapperAction()	0	4	1
A	ajaxMapperAction()	10	10	1
A	linkAction()	0	4	1
A	ajaxLinkAction()	9	9	1
A	templateAction()	0	4	1
A	ajaxTemplateAction()	9	9	1
A	attrAction()	0	4	1
A	ajaxAttrAction()	9	9	1
A	conditionAction()	0	4	1
A	ajaxConditionAction()	9	9	1
A	mixAction()	0	4	1
A	ajaxMixAction()	9	9	1
A	advanceAction()	0	4	1
A	ajaxAdvanceAction()	10	10	1
A	dataTableAction()	0	13	1
A	ajaxDataTableAction()	0	14	1
A	htmlResponse()	0	7	1
A	jsonResponse()	0	11	2
A	getCustomerTable()	0	8	2
A	institutionRequestsAction()	0	3	1
A	ajaxInstitutionRequestsAction()	8	8	1
A	getInstitutionRequests()	0	4	1
A	getDbAdapter()	0	8	2
A	getSource()	0	4	1

<?php
/**
 * ZfTable ( Module for Zend Framework 2)
 *
 * @copyright Copyright (c) 2013 Piotr Duda dudapiotrek@gmail.com
 * @license   MIT License
 */

namespace ZfTable\Controller;

use Zend\Mvc\Controller\AbstractActionController;
use ZfTable\Example\TableExample;
use Zend\View\Model\ViewModel;
use Zend\Db\ResultSet\ResultSet;
use ZfTable\Params\AdapterDataTables;
use ZfTable\Options\ModuleOptions;
use ZfTable\AbstractTable;
use Doctrine\ORM\EntityManager;

class TableController extends AbstractActionController
{

    /**
     *
     * @var ResultSet
     */
    protected $resultSet;

    /**
     *
     * @var
     */
    protected $customerTable;

    /**
     *
     * @var \Zend\Db\Adapter\Adapter
     */
    protected $dbAdapter;

    /**
     *
     * @var ModuleOptions
     */
    protected $moduleOptions;




     /**
     * @var \Doctrine\ORM\EntityManager
     */
    protected $em;

    /**
     *
     * @return \Doctrine\ORM\EntityManager
     */
    public function getEntityManager()
    {
        if (null === $this->em) {
            $this->em = $this->getServiceLocator()->get('doctrine.entitymanager.zftable_default');
        }
        return $this->em;
    }

    public function changesAction()
    {

    }

    public function bootstrapAction()
    {
    }

    /**
     * ********* Additional Params *******************
     * ***********************************
     */
    public function additionalParamsAction()
    {
    }
    public function ajaxadditionalParamsAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\AdditionalParams();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }

    /**
     * ********* Javascript Events *******************
     * ***********************************
     */
    public function javascriptEventsAction()
    {
    }
    public function ajaxJavascriptEventsAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\JavascriptEvents();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }


    /**
     * ********* Array Adapter *******************
     * *****************************************
     */
    public function arrayAction()
    {
    }

    public function ajaxArrayAction()
    {
        $table = new TableExample\ArrayAdapter();

        $sql = new \Zend\Db\Sql\Sql($this->getDbAdapter());

        $stmt = $sql->prepareStatementForSqlObject($this->getSource());
        $res = $stmt->execute();

        $resultSet = new \Zend\Db\ResultSet\ResultSet();
        $resultSet->initialize($res);

        $source = $resultSet->toArray();

        $table->setAdapter($this->getDbAdapter())
                ->setSource($source)
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }


    /**
     * ********* Doctrine Adapter *******************
     * *****************************************
     */
    public function doctrineAction()
    {
    }
    public function ajaxDoctrineAction()
    {
        $table = new TableExample\Doctrine();
        $form = $table->getForm();

        //I don't know if it necesary to validate that request is POST
        $request = $this->getRequest();

        $filter = $table->getFilter();
        $form->setInputFilter($filter);
        $form->setData($request->getPost());

        //Optional
        if ($form->isValid()) {
            $em = $this->getEntityManager();
            $queryBuilder = $em->createQueryBuilder();
            $queryBuilder->add('select', 'p , q')
                ->add('from', '\ZfTable\Entity\Customer q')
                ->leftJoin('q.product', 'p')
            ;

            $table->setAdapter($this->getDbAdapter())
                ->setSource($queryBuilder)
                ->setParamAdapter($this->getRequest()->getPost())
            ;

            return $this->htmlResponse($table->render());
        } else {
            //Indication the wrong data currently not supported
        }

    }


    /**
     * ********* Callable *******************
     * *****************************************
     */
    public function callableAction()
    {
    }
    public function ajaxCallableAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\CallableTable();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }



    /**
     * ********* Column filtering *******************
     * ***********************************
     */
    public function columnFilteringAction()
    {
    }
    public function ajaxColumnFilteringAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\ColumnFiltering();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }


    /**
     * ********* Editable tabble *******************
     * ***********************************
     */
    public function editableAction()
    {
    }
    public function ajaxEditableAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\Editable();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }

    public function updateRowAction()
    {
        $param = $this->getRequest()->getPost();
        $this->getCustomerTable()->update(
            array($param['column'] => $param['value']),
            array('idcustomer' => $param['row'])
        );
        return $this->jsonResponse(array('success' => 1));
    }


    /**
     * ********* Export To CSV *******************
     * *****************************************
     */
    public function csvExportAction()
    {
    }
    public function ajaxCsvExportAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\CsvExport();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }

    /**
     * ********* SEPARATABLE *******************
     * *****************************************
     */
    public function separatableAction()
    {
    }
    public function ajaxSeparatableAction()
    {
        $source = $this->getSource();
        $source->order('city ASC');

        $table = new TableExample\Separatable();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($source)
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }

    /**
     * ********* Variable Row Attr *******************
     * *****************************************
     */
    public function variableAttrRowAction()
    {

    }

    /**
     * ********* New plugin condition *******************
     * *****************************************
     */
    public function newPluginConditionAction()
    {

    }
    public function ajaxNewPluginConditionAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\NewPluginCondition();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }



    /**
     * ********* Base *******************
     * ***********************************
     */
    public function baseAction()
    {
    }
    public function ajaxBaseAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\Base();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }


    /**
     * ********* Mapper *******************
     * ***********************************
     */
    public function mapperAction()
    {

    }

    public function ajaxMapperAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\Mapper();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());

    }

    /**
     * ********* Link *******************
     * ***********************************
     */
    public function linkAction()
    {

    }

    public function ajaxLinkAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\Link();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }


     /**
     * ********* Template *******************
     * ***********************************
     */
    public function templateAction()
    {

    }

    public function ajaxTemplateAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\Template();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }


     /**
     * ********* Attr *******************
     * ***********************************
     */
    public function attrAction()
    {

    }

    public function ajaxAttrAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\Attr();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }


    /**
     * ********* Condition *******************
     * ***********************************
     */
    public function conditionAction()
    {

    }

    public function ajaxConditionAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\Condition();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }


    /**
     * ********* Mix *******************
     * ***********************************
     */
    public function mixAction()
    {

    }

    public function ajaxMixAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\Mix();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render());
    }

     /**
     * ********* Advance *******************
     * ***********************************
     */
    public function advanceAction()
    {

    }

    public function ajaxAdvanceAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\Advance();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getSource())
                ->setParamAdapter($this->getRequest()->getPost())
        ;
        return $this->htmlResponse($table->render('custom', 'custom-b3'));

    }







    /************************************************ */
    /*************** EXAMPLE DATA TABLE ************* */

    public function dataTableAction()
    {
        $source = $this->getSource();
        $table = new TableExample\DataTable();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($source)
                ->setParamAdapter(new AdapterDataTables($this->getRequest()->getPost()))
        ;

        return new ViewModel(array(
            'tableDataTable' => $table,
        ));
    }

    public function ajaxDataTableAction()
    {
        $source = $this->getSource();
        $table = new TableExample\DataTable();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($source)
                ->setParamAdapter(new AdapterDataTables($this->getRequest()->getPost()))
        ;

        $response = $this->getResponse();
        $response->setStatusCode(200);
        $response->setContent($table->render('dataTableJson'));
        return $response;
    }


    public function htmlResponse($html)
    {
        $response = $this->getResponse();
        $response->setStatusCode(200);
        $response->setContent($html);
        return $response;
    }

    public function jsonResponse($data)
    {
        if (!is_array($data)) {
            throw new \InvalidArgumentException('$data param must be array');
        }

        $response = $this->getResponse();
        $response->setStatusCode(200);
        $response->setContent(json_encode($data));
        return $response;
    }


    /**
     *
     * @return \ZfTable\Example\Model\CustomerTable
     *
     */
    public function getCustomerTable()
    {
        if (!$this->customerTable) {
            $sm = $this->getServiceLocator();
            $this->customerTable = $sm->get('ZfTable\Example\Model\CustomerTable');
        }
        return $this->customerTable;
    }

    /**********************My codes*********************/



    public function institutionRequestsAction()
    {
    }

    public function ajaxInstitutionRequestsAction()

This method seems to be duplicated in your project.

    {
        $table = new TableExample\InstitutionRequests();
        $table->setAdapter($this->getDbAdapter())
                ->setSource($this->getInstitutionRequests())
                ->setParamAdapter($this->getRequest()->getPost());
        return $this->htmlResponse($table->render());
    }

    /**
     * @return \Zend\Db\Sql\Select Type
     */
    private function getInstitutionRequests()
    {
        return $this->getCustomerTable()->fetchAllInstitutionRequests();
    }



    /**
     *
     * @return \Zend\Db\Adapter\Adapter
     */
    public function getDbAdapter()
    {
        if (!$this->dbAdapter) {
            $sm = $this->getServiceLocator();
            $this->dbAdapter = $sm->get('zfdb_adapter');
        }
        return $this->dbAdapter;
    }

    /**
     *
     * @return \Zend\Db\Sql\Select
     */
    private function getSource()
    {
        return $this->getCustomerTable()->fetchAllSelect();
    }
}