/home/sharedstore/.trash/modules/cz_servicecmsblock/classes
Edit: /home/sharedstore/.trash/modules/cz_servicecmsblock/classes/MigrateData.php (3000B)
* @copyright Since 2007 PrestaShop SA and Contributors
* @license https://opensource.org/licenses/AFL-3.0 Academic Free License 3.0 (AFL-3.0)
*/
/**
* Database may change between two version of the module, or between the 1.6 and 1.7 modules.
* This class allow the data to be kept during upgrades and migrations.
*/
class MigrateData
{
private $loadedData = [];
/**
* This methods retrieves data from older database models
* - cz_servicecmsblock < v3.0.0
* - blockcmsinfo (1.6 equivalent module)
*
* @return array
*/
public function retrieveOldData()
{
$this->loadedData = [];
$texts = Db::getInstance()->executeS('SELECT i.`id_shop`, il.`id_lang`, il.`text` FROM `' . _DB_PREFIX_ . 'czservicecmsblockinfo` i
INNER JOIN `' . _DB_PREFIX_ . 'czservicecmsblockinfo_lang` il ON il.`id_czservicecmsblockinfo` = i.`id_czservicecmsblockinfo`'
);
if (is_array($texts) && !empty($texts)) {
foreach ($texts as $text) {
$this->loadedData[(int) $text['id_shop']][(int) $text['id_lang']] = $text['text'];
}
}
return $this->loadedData;
}
/**
* Import the old ServiceCmsBlock data in the new structure
*
* @return bool
*/
public function insertData()
{
if (empty($this->loadedData)) {
return true;
}
$return = true;
$shopsIds = Shop::getShops(true, null, true);
$customTexts = array_intersect_key($this->loadedData, $shopsIds);
$czservicecmsblockinfo = new ServiceCmsBlock();
$czservicecmsblockinfo->text = reset($customTexts);
$return &= $czservicecmsblockinfo->add();
if (count($customTexts) > 1) {
foreach ($customTexts as $key => $text) {
Shop::setContext(Shop::CONTEXT_SHOP, (int) $key);
$czservicecmsblockinfo->text = $text;
$return &= $czservicecmsblockinfo->save();
}
}
return (bool) $return;
}
}