DeployerGuide/AdvancedConfiguration/CustomRegisters: Handler.inc

<?php

/**
 *
 * @author Marcin Król
 * @copyright Copyright (c) eDokumenty Sp. z o.o.
 */
class MyExcelFile extends DAVBasicFile {

    private $fsize = 1;
    

    /**
     *
     * @param string $myPath
     */
    public function __construct($myPath) {
        parent::__construct($myPath);
        
        $data = [];
        $cregid = isset($this->params['cregid']) ? $this->params['cregid'] : NULL;
        $rep_id = isset($this->params['rep_id']) ? $this->params['rep_id'] : NULL;
        if ($cregid) {
            require_once('./classes/Access/services/CRegisterAccessService.inc');

            $accsrv = new CRegisterAccessService($cregid);
            
            $this->isReadable = $accsrv->canReadRegister($cregid, TRUE);
            
            $keyval = isset($this->params['keyval']) ? $this->params['keyval'] : NULL;
            $clsnam = isset($this->params['clsnam']) ? $this->params['clsnam'] : NULL;
            if ($clsnam && $keyval) {

            }
        }
    }

    /**
     * Updates the data
     *
     * @param resource $data
     * @return void
     */
    public function put($data) {
        parent::put($data);
        
        $cregid = isset($this->params['cregid']) ? $this->params['cregid'] : NULL;
        if (!$this->params || !$cregid || !ctype_digit((string)$cregid) || !$this->isReadable) throw new Sabre\DAV\Exception\Forbidden('');

        $fileName = time().'.xlsx';
        $filePath = VarPathService::getTmpPath().$fileName;
        
        file_put_contents($filePath, $data);
        
        require_once('./classes/Access/services/CRegisterAccessService.inc');
        require_once(MOD_PATH.'CRegisters/beans/CRegisterEntry.inc');
        include_once(LIB_PATH.'util/excel/ExcelEditor.inc');

        $accsrv = new CRegisterAccessService($cregid);

        $excel = new ExcelEditor();
        $excel->loadFile($filePath);
        $result = $excel->getAllData();

        foreach ($result as $item) {
            $clsnam = isset($item['clsnam']) ? $item['clsnam'] : NULL;
            $keyval = (isset($item['keyval']) && $item['keyval'] && ctype_digit((string)$item['keyval'])) ? $item['keyval'] : NULL;
            $id____ = (isset($item['id____']) && $item['id____'] && ctype_digit((string)$item['id____'])) ? $item['id____'] : $keyval;
            
            if (($id____ && !$accsrv->canChangeEntry($id____, $cregid)) || ($clsnam && ($clsnam != 'CREGISTER_ENTRY'))) {
                continue;
            }
            if (isset($item['clsnam'])) unset($item['clsnam']);
            if (isset($item['keyval'])) unset($item['keyval']);
            
            $bean = new CRegisterEntry($id____, $cregid);
            $bean->data = array_merge($bean->data, $item);
            
            $bean->save();
        }
    }

    public function get() {
        if (!$this->params || !$this->isReadable) throw new Sabre\DAV\Exception\Forbidden('');
        
        $data = [];
        $cregid = isset($this->params['cregid']) ? $this->params['cregid'] : NULL;
        $rep_id = isset($this->params['rep_id']) ? $this->params['rep_id'] : NULL;
        if ($cregid) {
            $fs = 'cregid = '.$cregid;
            
            $keyval = isset($this->params['keyval']) ? $this->params['keyval'] : NULL;
            $clsnam = isset($this->params['clsnam']) ? $this->params['clsnam'] : NULL;
            if ($clsnam && $keyval) {

            }
            require_once(MOD_PATH.'CRegisters/beans/CRegister.inc');
            require_once('classes/eDokumentyApi/EDokApi.inc');
            
            $register = new CRegister($cregid);

            $api = new EDokApi();
            if ((count($this->params) == 1) && isset($this->params['cregid'])) {
                $params = ['filter_string' => 'cregid = '.$cregid.''];
                
            } else {
                $params = $this->params;
            }
            $data = $api->searchRegisterEntries($cregid, '', 0, 0, $params);
            
            include_once(LIB_PATH.'util/excel/ExcelEditor.inc');

            $excel = new ExcelEditor();
            if ($excel->setData($data)) {
                $fileName = time().'.xlsx';
                $filePath = VarPathService::getTmpPath().$fileName;

                $excel->objPHPExcel->setActiveSheetIndex(0);
                
                $excel->objPHPExcel->getProperties()->setCreator('eDokumenty');
                $excel->objPHPExcel->getProperties()->setLastModifiedBy(SysContext::$usr_info['fullnm']);
                $excel->objPHPExcel->getProperties()->setTitle($register->get('name__'));
                $excel->objPHPExcel->getProperties()->setSubject($register->get('name__'));
                $excel->objPHPExcel->getProperties()->setDescription($register->get('dscrpt'));

                $excel->objPHPExcel->getProperties()->setCustomProperty('eDokumenty_RegisterID', $cregid);

                $excel->save($filePath);
                
                $f = fopen($filePath, 'rb');
                
                fseek($f, 0, SEEK_END);
                $this->fsize = ftell($f);
                
                fseek($f, 0, SEEK_SET);
                
                return $f;
            }
        } else {
            
        }
        if (empty($data)) throw new Sabre\DAV\Exception\Forbidden('Zero file size!');
    }

    public function getSize() {
        return $this->fsize;
    }
    
    /**
     * 
     */
    public function getContentType() {
        $type = 'application/xlsx';
        return $type;
    }

}

DAVBasicDirectory::setFileClass('MyExcelFile');