|
Apache/2.4.41 (Ubuntu) Linux vmi616275.contaboserver.net 5.4.0-84-generic #94-Ubuntu SMP Thu Aug 26 20:27:37 UTC 2021 x86_64 uid=33(www-data) gid=33(www-data) groups=33(www-data) server ip : 62.171.164.128 | your ip : 127.0.0.1 safemode OFF > / home / a / home / dev2.destoffenstraat.com / app / code / Mirasvit / Report / Controller / Adminhtml / Api / |
Filename | /home/a/home/dev2.destoffenstraat.com/app/code/Mirasvit/Report/Controller/Adminhtml/Api/Export.php |
Size | 3.54 kb |
Permission | rwxrwxrwx |
Owner | root : root |
Create time | 21-Aug-2025 12:26 |
Last modified | 15-Oct-2024 20:30 |
Last accessed | 23-Aug-2025 07:50 |
Actions | edit | rename | delete | download (gzip) |
View | text | code | image |
<?php
/**
* Mirasvit
*
* This source file is subject to the Mirasvit Software License, which is available at https://mirasvit.com/license/.
* Do not edit or add to this file if you wish to upgrade the to newer versions in the future.
* If you wish to customize this module for your needs.
* Please refer to http://www.magentocommerce.com for more information.
*
* @category Mirasvit
* @package mirasvit/module-report
* @version 1.4.38
* @copyright Copyright (C) 2024 Mirasvit (https://mirasvit.com/)
*/
namespace Mirasvit\Report\Controller\Adminhtml\Api;
use Magento\Backend\App\Action\Context;
use Magento\Framework\App\Response\Http\FileFactory;
use Magento\Framework\Filter\FilterManager;
use Mirasvit\Report\Model\Export\ConvertToCsv;
use Mirasvit\Report\Model\Export\ConvertToXml;
use Mirasvit\Report\Repository\ReportRepository;
use Mirasvit\ReportApi\Api\RequestBuilderInterface;
class Export extends AbstractApi
{
const DEFAULT_FILE_NAME = 'export';
private $fileFactory;
private $convertToXml;
private $convertToCsv;
private $requestBuilder;
private $reportRepository;
private $filter;
public function __construct(
FileFactory $fileFactory,
ConvertToXml $convertToXml,
ConvertToCsv $convertToCsv,
RequestBuilderInterface $requestBuilder,
ReportRepository $repository,
FilterManager $filter,
\Magento\Framework\Serialize\Serializer\Json $serializer,
Context $context
) {
$this->fileFactory = $fileFactory;
$this->convertToXml = $convertToXml;
$this->convertToCsv = $convertToCsv;
$this->requestBuilder = $requestBuilder;
$this->reportRepository = $repository;
$this->filter = $filter;
parent::__construct($context, $serializer);
}
public function execute()
{
$type = $this->getRequest()->getParam('type');
$response = $this->processRequest();
if ($type === 'xml') {
$content = $this->convertToXml->getXmlFile($response);
} else {
$content = $this->convertToCsv->getCsvFile($response);
}
$filename = self::DEFAULT_FILE_NAME;
$report = $this->reportRepository->get($this->getRequest()->getParam('identifier'));
if ($report) {
$filename = $this->filter->translitUrl($report->getName()) . '_' . date('Y-m-d_H-i-s');
}
return $this->fileFactory->create($filename . '.' . $type, $content, 'var');
}
/**
* @return \Mirasvit\ReportApi\Api\RequestInterface
*/
private function processRequest()
{
$r = $this->getRequest();
$request = $this->requestBuilder->create();
$request->setTable($r->getParam('table'))
->setDimensions($r->getParam('dimensions'));
foreach ($r->getParam('dimensions', []) as $c) {
$request->addColumn($c);
}
foreach ($r->getParam('columns', []) as $c) {
$request->addColumn($c);
}
foreach ($r->getParam('filters', []) as $filter) {
if ($filter['conditionType'] == 'like') {
$filter['value'] = '%' . $filter['value'] . '%';
}
$request->addFilter($filter['column'], $filter['value'], $filter['conditionType']);
}
$request->setIdentifier($r->getParam('identifier'));
foreach ($r->getParam('sortOrders', []) as $sortOrder) {
$request->addSortOrder($sortOrder['column'], $sortOrder['direction']);
}
return $request;
}
}
/**
* Mirasvit
*
* This source file is subject to the Mirasvit Software License, which is available at https://mirasvit.com/license/.
* Do not edit or add to this file if you wish to upgrade the to newer versions in the future.
* If you wish to customize this module for your needs.
* Please refer to http://www.magentocommerce.com for more information.
*
* @category Mirasvit
* @package mirasvit/module-report
* @version 1.4.38
* @copyright Copyright (C) 2024 Mirasvit (https://mirasvit.com/)
*/
namespace Mirasvit\Report\Controller\Adminhtml\Api;
use Magento\Backend\App\Action\Context;
use Magento\Framework\App\Response\Http\FileFactory;
use Magento\Framework\Filter\FilterManager;
use Mirasvit\Report\Model\Export\ConvertToCsv;
use Mirasvit\Report\Model\Export\ConvertToXml;
use Mirasvit\Report\Repository\ReportRepository;
use Mirasvit\ReportApi\Api\RequestBuilderInterface;
class Export extends AbstractApi
{
const DEFAULT_FILE_NAME = 'export';
private $fileFactory;
private $convertToXml;
private $convertToCsv;
private $requestBuilder;
private $reportRepository;
private $filter;
public function __construct(
FileFactory $fileFactory,
ConvertToXml $convertToXml,
ConvertToCsv $convertToCsv,
RequestBuilderInterface $requestBuilder,
ReportRepository $repository,
FilterManager $filter,
\Magento\Framework\Serialize\Serializer\Json $serializer,
Context $context
) {
$this->fileFactory = $fileFactory;
$this->convertToXml = $convertToXml;
$this->convertToCsv = $convertToCsv;
$this->requestBuilder = $requestBuilder;
$this->reportRepository = $repository;
$this->filter = $filter;
parent::__construct($context, $serializer);
}
public function execute()
{
$type = $this->getRequest()->getParam('type');
$response = $this->processRequest();
if ($type === 'xml') {
$content = $this->convertToXml->getXmlFile($response);
} else {
$content = $this->convertToCsv->getCsvFile($response);
}
$filename = self::DEFAULT_FILE_NAME;
$report = $this->reportRepository->get($this->getRequest()->getParam('identifier'));
if ($report) {
$filename = $this->filter->translitUrl($report->getName()) . '_' . date('Y-m-d_H-i-s');
}
return $this->fileFactory->create($filename . '.' . $type, $content, 'var');
}
/**
* @return \Mirasvit\ReportApi\Api\RequestInterface
*/
private function processRequest()
{
$r = $this->getRequest();
$request = $this->requestBuilder->create();
$request->setTable($r->getParam('table'))
->setDimensions($r->getParam('dimensions'));
foreach ($r->getParam('dimensions', []) as $c) {
$request->addColumn($c);
}
foreach ($r->getParam('columns', []) as $c) {
$request->addColumn($c);
}
foreach ($r->getParam('filters', []) as $filter) {
if ($filter['conditionType'] == 'like') {
$filter['value'] = '%' . $filter['value'] . '%';
}
$request->addFilter($filter['column'], $filter['value'], $filter['conditionType']);
}
$request->setIdentifier($r->getParam('identifier'));
foreach ($r->getParam('sortOrders', []) as $sortOrder) {
$request->addSortOrder($sortOrder['column'], $sortOrder['direction']);
}
return $request;
}
}