<?php
/**
* Mageplaza
*
* NOTICE OF LICENSE
*
* This source file is subject to the Mageplaza.com license that is
* available through the world-wide-web at this URL:
* https://www.mageplaza.com/LICENSE.txt
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade this extension to newer
* version in the future.
*
* @category Mageplaza
* @package Mageplaza_ImportExportCMS
* @copyright Copyright (c) Mageplaza (https://www.mageplaza.com/)
* @license https://www.mageplaza.com/LICENSE.txt
*/

namespace Mageplaza\ImportExportCMS\Model\ResourceModel;

use Magento\Framework\Model\ResourceModel\Db\AbstractDb;
use Mageplaza\ImportExportCMS\Model\AbstractImport;

/**
* Class Import
* @package Mageplaza\ImportExportCMS\Model\ResourceModel
*/
class Import extends AbstractDb
{
/**
* Initialize resource model
*
* @return void
*/
protected function _construct()
{
$this->_init('cms_page', 'page_id');
}

/**
* @param array $row
* @param string $rowId
* @param string $tableName
* @param string $storeTableName
*
* @return string
*/
public function isUniqueCmsToStores($row, $rowId, $tableName, $storeTableName)
{
$adapter = $this->getConnection();

$select = $adapter->select()
->from($tableName, $tableName . '.' . $rowId)
->joinLeft(
['bs' => $storeTableName],
$tableName . "." . $rowId . " = bs." . $rowId
)
->where('identifier = ?', $row[AbstractImport::COL_IDENTIFIER])
->where('store_id IN (?)', $row[AbstractImport::COL_STORE_ID]);

$binds = [
'identifier' => $row[AbstractImport::COL_IDENTIFIER]
];

return $adapter->fetchOne($select, $binds);
}
}