Jordan Morin
239 lines
9.4 KiB
PHP
239 lines
9.4 KiB
PHP
<?php
|
|
/**
|
|
* Venustheme
|
|
*
|
|
* NOTICE OF LICENSE
|
|
*
|
|
* This source file is subject to the Venustheme.com license that is
|
|
* available through the world-wide-web at this URL:
|
|
* http://www.venustheme.com/license-agreement.html
|
|
*
|
|
* DISCLAIMER
|
|
*
|
|
* Do not edit or add to this file if you wish to upgrade this extension to newer
|
|
* version in the future.
|
|
*
|
|
* @category Venustheme
|
|
* @package Ves_Setup
|
|
* @copyright Copyright (c) 2014 Venustheme (http://www.venustheme.com/)
|
|
* @license http://www.venustheme.com/LICENSE-1.0.html
|
|
*/
|
|
namespace Ves\Setup\Helper;
|
|
use Magento\Framework\App\Filesystem\DirectoryList;
|
|
use \Magento\Framework\Module\Dir;
|
|
|
|
class Export extends \Magento\Framework\App\Helper\AbstractHelper
|
|
{
|
|
/** @var \Magento\Framework\Xml\Parser */
|
|
protected $parser;
|
|
|
|
/** @var \Magento\Store\Model\StoreManagerInterface */
|
|
protected $_storeManager;
|
|
|
|
/**
|
|
* DB connection
|
|
*
|
|
* @var \Magento\Framework\DB\Adapter\AdapterInterface
|
|
*/
|
|
protected $_conn;
|
|
|
|
/**
|
|
* @var \Magento\Framework\Module\Dir
|
|
*/
|
|
protected $_moduleDir;
|
|
|
|
/**
|
|
* @param \Magento\Framework\App\Helper\Context $context
|
|
* @param \Magento\Store\Model\StoreManagerInterface $storeManager
|
|
* @param \Magento\Framework\App\Config\ScopeConfigInterface $scopeConfig
|
|
* @param \Magento\Framework\App\ResourceConnection $resource
|
|
* @param Dir $moduleDir
|
|
*/
|
|
public function __construct(
|
|
\Magento\Framework\App\Helper\Context $context,
|
|
\Magento\Store\Model\StoreManagerInterface $storeManager,
|
|
\Magento\Framework\App\ResourceConnection $resource,
|
|
Dir $moduleDir
|
|
) {
|
|
parent::__construct($context);
|
|
$this->_moduleDir = $moduleDir;
|
|
$this->parser = new \Magento\Framework\Xml\Parser();
|
|
$this->_storeManager = $storeManager;
|
|
$this->_resource = $resource;
|
|
}
|
|
|
|
public function exportModules($data){
|
|
$moduleTables = $this->getModuleTables();
|
|
$configs = [];
|
|
if(!empty($data['modules'])){
|
|
$store = $this->_storeManager->getStore($data['store_id']);
|
|
foreach ($data['modules'] as $k => $v) {
|
|
if(isset($moduleTables[$v])){
|
|
$tables = $moduleTables[$v];
|
|
}
|
|
$systemFileDir = $this->_moduleDir->getDir($v,Dir::MODULE_ETC_DIR). DIRECTORY_SEPARATOR . 'adminhtml' . DIRECTORY_SEPARATOR . 'system.xml';
|
|
|
|
if(file_exists($systemFileDir)){
|
|
|
|
$systemConfigs = $this->parser->load($systemFileDir)->xmlToArray();
|
|
if($systemConfigs['config']['_value']['system']['section']){
|
|
foreach ($systemConfigs['config']['_value']['system']['section'] as $_section) {
|
|
$groups = [];
|
|
if(isset($_section['_value']['group'])){
|
|
$groups = $_section['_value']['group'];
|
|
}elseif(isset($_section['group'])){
|
|
$groups = $_section['group'];
|
|
}
|
|
|
|
$_sectionId = '';
|
|
if(isset($_section['_attribute']['id'])){
|
|
$_sectionId = $_section['_attribute']['id'];
|
|
}elseif(isset($systemConfigs['config']['_value']['system']['section']['_attribute']['id'])){
|
|
$_sectionId = $systemConfigs['config']['_value']['system']['section']['_attribute']['id'];
|
|
}
|
|
|
|
if(empty($groups)) continue;
|
|
foreach ($groups as $_group) {
|
|
if(!isset($_group['_value']['field'])) continue;
|
|
foreach ($_group['_value']['field'] as $_field) {
|
|
if(isset($_sectionId) && isset($_group['_attribute']['id']) && isset($_field['_attribute']['id'])){
|
|
$key = $_sectionId . '/' . $_group['_attribute']['id'] . '/' . $_field['_attribute']['id'];
|
|
$result = $this->scopeConfig->getValue(
|
|
$key,
|
|
\Magento\Store\Model\ScopeInterface::SCOPE_STORE,
|
|
$store);
|
|
if($result=='') continue;
|
|
$configs[$v]['system_configs'][] = [
|
|
'key' => $key,
|
|
'value' => $result
|
|
];
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
if(isset($moduleTables[$v]) && is_array($moduleTables[$v])){
|
|
foreach ($moduleTables[$v] as $key => $tableName) {
|
|
$connection = $this->_resource->getConnection();
|
|
$select = 'SELECT * FROM ' . $this->_resource->getTableName($tableName);
|
|
$rows = $connection->fetchAll($select);
|
|
$configs[$v]['tables'][$tableName] = $rows;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
return $configs;
|
|
}
|
|
|
|
public function exportCmsPages($data){
|
|
$configs = [];
|
|
if(!empty($data['cmspages'])){
|
|
$pageIds = implode(',', $data['cmspages']);
|
|
$moduleTables = $this->getModuleTables();
|
|
if(isset($moduleTables["Magento_Cms_Page"])){
|
|
foreach ($moduleTables["Magento_Cms_Page"] as $k => $tableName) {
|
|
$connection = $this->_resource->getConnection();
|
|
$select = 'SELECT * FROM ' . $this->_resource->getTableName($tableName) . ' WHERE page_id IN (' . $pageIds . ') ';
|
|
$rows = $connection->fetchAll($select);
|
|
$configs['Magento_Cms_Page']['tables'][$tableName] = $rows;
|
|
}
|
|
}
|
|
}
|
|
return $configs;
|
|
}
|
|
|
|
public function exportStaticBlocks($data){
|
|
$configs = [];
|
|
if(!empty($data['cmsblocks'])){
|
|
$blockIds = implode(',', $data['cmsblocks']);
|
|
$moduleTables = $this->getModuleTables();
|
|
if(isset($moduleTables["Magento_Cms_Block"])){
|
|
foreach ($moduleTables["Magento_Cms_Block"] as $k => $tableName) {
|
|
$connection = $this->_resource->getConnection();
|
|
$select = 'SELECT * FROM ' . $this->_resource->getTableName($tableName) . ' WHERE block_id IN (' . $blockIds . ') ';
|
|
$rows = $connection->fetchAll($select);
|
|
$configs['Magento_Cms_Block']['tables'][$tableName] = $rows;
|
|
}
|
|
}
|
|
}
|
|
return $configs;
|
|
}
|
|
|
|
public function exportWidgets($data){
|
|
$configs = [];
|
|
if(!empty($data['widgets'])){
|
|
$moduleTables = $this->getModuleTables();
|
|
if(isset($moduleTables["Magento_Widget"])){
|
|
|
|
// Widget Instance
|
|
$connection = $this->_resource->getConnection();
|
|
$select = 'SELECT * FROM ' . $this->_resource->getTableName('widget_instance') . ' WHERE instance_id IN (' . implode(',', $data['widgets']) . ') ';
|
|
$rows = '';
|
|
$configs['Magento_Widget']['tables']['widget_instance'] = $connection->fetchAll($select);
|
|
$widgetInstanceIds = [];
|
|
foreach ($configs['Magento_Widget']['tables']['widget_instance'] as $k => $v) {
|
|
$widgetInstanceIds[] = $v['instance_id'];
|
|
}
|
|
|
|
// Widget Instance Page
|
|
if(!empty($widgetInstanceIds)){
|
|
$connection = $this->_resource->getConnection();
|
|
$select = 'SELECT * FROM ' . $this->_resource->getTableName('widget_instance_page') . ' WHERE instance_id IN (' . implode(',', $widgetInstanceIds) . ') ';
|
|
$rows = '';
|
|
$configs['Magento_Widget']['tables']['widget_instance_page'] = $connection->fetchAll($select);
|
|
$widgetInstancePageIds = [];
|
|
foreach ($configs['Magento_Widget']['tables']['widget_instance_page'] as $k => $v) {
|
|
$widgetInstancePageIds[] = $v['page_id'];
|
|
}
|
|
}
|
|
|
|
// Widget Instance Page Layout
|
|
$widgetInstancePageLayoutIds = [];
|
|
if(!empty($widgetInstancePageIds)){
|
|
$connection = $this->_resource->getConnection();
|
|
$select = 'SELECT * FROM ' . $this->_resource->getTableName('widget_instance_page_layout') . ' WHERE page_id IN (' . implode(',', $widgetInstancePageIds) . ') ';
|
|
$rows = '';
|
|
$configs['Magento_Widget']['tables']['widget_instance_page_layout'] = $connection->fetchAll($select);
|
|
foreach ($configs['Magento_Widget']['tables']['widget_instance_page_layout'] as $k => $v) {
|
|
$widgetInstancePageLayoutIds[] = $v['layout_update_id'];
|
|
}
|
|
}
|
|
|
|
// Widget Core Layout Link
|
|
$widgetLayoutUpdateId = [];
|
|
if(!empty($widgetInstancePageLayoutIds)){
|
|
$connection = $this->_resource->getConnection();
|
|
$select = 'SELECT * FROM ' . $this->_resource->getTableName('layout_link') . ' WHERE layout_link_id IN (' . implode(',', $widgetInstancePageLayoutIds) . ') ';
|
|
$rows = '';
|
|
$configs['Magento_Widget']['tables']['layout_link'] = $connection->fetchAll($select);
|
|
$widgetInstancePageLayoutIds = [];
|
|
foreach ($configs['Magento_Widget']['tables']['layout_link'] as $k => $v) {
|
|
$widgetLayoutUpdateId[] = $v['layout_update_id'];
|
|
}
|
|
}
|
|
|
|
// Widget Core Layout Update
|
|
if(!empty($widgetLayoutUpdateId)){
|
|
$connection = $this->_resource->getConnection();
|
|
$select = 'SELECT * FROM ' . $this->_resource->getTableName('layout_update') . ' WHERE layout_update_id IN (' . implode(',', $widgetLayoutUpdateId) . ') ';
|
|
$configs['Magento_Widget']['tables']['layout_update'] = $connection->fetchAll($select);
|
|
}
|
|
}
|
|
}
|
|
return $configs;
|
|
}
|
|
|
|
public function getModuleTables() {
|
|
$sql_tables = [
|
|
"Ves_Blog" => ["ves_blog_category", "ves_blog_category_store","ves_blog_post", "ves_blog_post_category", "ves_blog_post_tag", "ves_blog_post_related", "ves_blog_post_store", "ves_blog_comment", "ves_blog_comment_store"],
|
|
"Ves_PageBuilder" => ["ves_blockbuilder_block", "ves_blockbuilder_cms","ves_blockbuilder_page"],
|
|
"Ves_Brand" => ["ves_brand_group", "ves_brand","ves_brand_store"],
|
|
"Ves_Megamenu" => ["ves_megamenu_menu", "ves_megamenu_menu_store","ves_megamenu_item"],
|
|
"Magento_Cms_Page" => ["cms_page", "cms_page_store"],
|
|
"Magento_Cms_Block" => ["cms_block", "cms_block_store"],
|
|
"Magento_Widget" => ["widget", "widget_instance", "widget_instance_page", "widget_instance_page_layout", "core_layout_link", "core_layout_update"]
|
|
];
|
|
return $sql_tables;
|
|
}
|
|
} |