43 lines
2.0 KiB
PHP
43 lines
2.0 KiB
PHP
<?php
|
|
|
|
$pdo = $database->getConnection();
|
|
|
|
// Get locale
|
|
$locale = 'fr_FR';
|
|
|
|
$sqlGetLocale = "SELECT `locale` FROM `lang` WHERE `by_default` = :by_default";
|
|
$stmtGetLocale = $pdo->prepare($sqlGetLocale);
|
|
$stmtGetLocale->execute([':by_default' => 1]);
|
|
$resultLocales = $stmtGetLocale->fetchAll();
|
|
|
|
foreach ($resultLocales as $defaultLocale) {
|
|
$locale = $defaultLocale['locale'];
|
|
}
|
|
|
|
// Get id, feature_id and free_text_value from feature_product
|
|
$sqlGetFeatureProduct = "SELECT `id`, `feature_id`, `free_text_value` FROM `feature_product` WHERE `feature_av_id` IS NULL";
|
|
$stmtGetFeatureProduct = $pdo->prepare($sqlGetFeatureProduct);
|
|
$stmtGetFeatureProduct->execute([':feature_av_id' => NULL]);
|
|
|
|
while ($featureProduct = $stmtGetFeatureProduct->fetch(PDO::FETCH_ASSOC)) {
|
|
|
|
// Create new feature_av with the feature_id
|
|
$sqlCreateFeatureAv = "INSERT INTO `feature_av` (feature_id, `position`) VALUES (:feature_id, :feature_position)";
|
|
$stmtCreateFeatureAv = $pdo->prepare($sqlCreateFeatureAv);
|
|
$stmtCreateFeatureAv->execute([':feature_id' => $featureProduct['feature_id'], ':feature_position' => 1]);
|
|
|
|
// Get id from created feature_av
|
|
$createdFeatureAvId = $pdo->lastInsertId();
|
|
|
|
// Create new feature_av_i18n
|
|
$sqlCreateFeatureAvI18n = "INSERT INTO `feature_av_i18n` (id, locale, title) VALUES (:id, :locale, :title)";
|
|
$stmtCreateFeatureAvI18n = $pdo->prepare($sqlCreateFeatureAvI18n);
|
|
$stmtCreateFeatureAvI18n->execute([':id' => $createdFeatureAvId, ':locale' => $locale, ':title' => $featureProduct['free_text_value']]);
|
|
|
|
// Update old NULL feature_av_id and textual free_text_value values from feature_product
|
|
$sqlUpdateFeatureProduct = "UPDATE feature_product SET feature_av_id = :feature_av_id, free_text_value = :free_text_value WHERE id = :featureProductId";
|
|
$stmtUpdateFeatureProduct = $pdo->prepare($sqlUpdateFeatureProduct);
|
|
$stmtUpdateFeatureProduct->execute([':feature_av_id' => $createdFeatureAvId, ':free_text_value' => 1, ':featureProductId' => $featureProduct['id']]);
|
|
}
|
|
|