<?php

namespace App\User\Admin;

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

/**
 * @method Obj _getDataObj()
 */
class View extends Qs_ViewController
{
    protected $_hasLog = true;
    protected $_hasFilter = true;
    protected $_actions = ['list', 'cancel', 'new', 'insert', 'edit', 'update', 'delete', 'changeOption','exportCsv'];
    protected $_filterFields = ['Name', 'Login', 'Email'];

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

        $linkOptions = $this->_getDataObj()->getFilter();
        $linkOptions['action'] = 'exportCsv';
        $links['exportCsv'] = ['title' => 'Export to CSV', 'url' => $this->url($linkOptions)];

        return $links;
    }

    protected function _initFromForm(\Qs_Form $form)
    {
        $data = $form->getValues();

        $data['bought'] = 'y';

        $this->_getDataObj()->initFromForm($data);

        return $this;
    }

    protected function _doExportCsv()
    {
        $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->getExportColumns(),
            'rowCallback' => $rowCallback,
        ]);
        $helper->export();

        $this->_postExportCsv();

        exit;
    }

    protected function _postExportCsv()
    {
        $this->_log();
        return $this;
    }
}