<?php

namespace App\Vendor\Admin;

use Qs_ViewController;
use Qs\Export\Csv as ExportCsv;

/**
 * Class View
 * @package App\Vendor\Admin
 * @method Obj _getDataObj()
 */
class View extends Qs_ViewController
{
    protected $_hasFilter = true;
    protected $_filterFields = ['DBA Name', 'Federal Id', 'Phone', 'Email', 'Main Contact'];
    protected $_actions = [
        'list', 'cancel', 'new', 'insert', 'edit', 'update', 'delete', 'back', 'renderFormPart', 'exportToCsv',
    ];

    protected function _getFormOptions($type = null)
    {
        $options = parent::_getFormOptions($type);
        if (in_array($type, ['new', 'edit'])) {
            $options['questions'] = $this->_getDataObj()->getQuestions();
        }
        return $options;
    }

    protected function _getDefaultLinks()
    {
        $links = parent::_getDefaultLinks();

        $query = $this->getFilter();
        $query['orderBy'] = $this->_getList()->getOrderBy();
        $query = array_filter($query);

        $links['exportToCsv'] = [
            'title' => 'Export to .csv',
            'url'   => $this->url(array_merge(['action' => 'exportToCsv'], $query)),
        ];

        return $links;
    }

    protected function _doExportToCsv()
    {
        $dataObj = $this->_getDataObj();

        if ($dataObj->hasFilter()) {
            $form = $this->_getFilterForm();
            if ($form->validate()) {
                $dataObj->addFilter($form->getValues());
            }
        }
        $options = ['order' => $this->_getList()->getOrderBy()];
        $dataObj->setSelectOptions($options);
        $stmt = $dataObj->getList4ExportStatement();

        $rowCallback = function () use ($stmt, $dataObj) {
            $row = $stmt->fetch();
            if ($row) {
                $dataObj->prepareExportRow($row);
            }
            return $row;
        };

        $helper = new ExportCsv([
            'fileName'    => $this->getConfig('itemsName') . ' {date}.csv',
            'columns'     => $dataObj->getExportCsvColumns(),
            'rowCallback' => $rowCallback,
        ]);
        $helper->export();
        exit;
    }
}