/**
* Save the settings
*/
private function save()
{
// We need to save the options ourselves; settings api does not trigger save for the permalinks page
if (isset($_POST['permalink_structure']) || isset($_POST['category_base']) && isset($_POST['product_permalink'])) {
// Cat and tag bases
$categorySlug = trim(strip_tags($_POST['jigoshop_product_category_slug']));
$tagSlug = trim(strip_tags($_POST['jigoshop_product_tag_slug']));
$permalinks = $this->options->get('permalinks');
$helpers = $this->wp->getHelpers();
$permalinks['category'] = $helpers->untrailingslashit($categorySlug);
$permalinks['tag'] = $helpers->untrailingslashit($tagSlug);
// Product base
$product_permalink = trim(strip_tags($_POST['product_permalink']));
if ($product_permalink == 'custom') {
// Get permalink without slashes
$product_permalink = trim(strip_tags($_POST['product_permalink_structure']), '/');
// This is an invalid base structure and breaks pages
if ('%' . Types::PRODUCT_CATEGORY . '%' == $product_permalink) {
$product_permalink = _x('product', 'slug', 'jigoshop') . '/' . $product_permalink;
}
} elseif (empty($product_permalink)) {
$product_permalink = false;
}
$permalinks['product'] = $helpers->untrailingslashit($product_permalink);
// Shop base may require verbose page rules if nesting pages
$shopPageId = $this->options->getPageId(FrontendPages::SHOP);
$shop_permalink = urldecode($shopPageId > 0 && $this->wp->getPost($shopPageId) ? $this->wp->getPageUri($shopPageId) : _x('shop', 'default-slug', 'jigoshop'));
if ($shopPageId && trim($permalinks['product'], '/') === $shop_permalink) {
$permalinks['verbose'] = true;
}
$this->options->update('permalinks', $permalinks);
$this->options->saveOptions();
$this->wp->getRewrite()->flush_rules();
}
}
private function _createPage($slug, $data)
{
$wpdb = $this->wp->getWPDB();
$slug = esc_sql(_x($slug, 'page_slug', 'jigoshop'));
$page_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM {$wpdb->posts} WHERE post_name = %s AND post_status = 'publish' AND post_status <> 'trash' LIMIT 1", $slug));
if (!$page_id) {
Registry::getInstance(JIGOSHOP_LOGGER)->addDebug(sprintf('Installing page "%s".', $slug));
$data['post_name'] = $slug;
$page_id = $this->wp->wpInsertPost($data);
}
$this->options->setPageId($slug, $page_id);
$this->options->update('advanced.pages.' . $slug, $page_id);
}
/**
* Validates settings for WordPress to save.
*
* @param array $input Input data to validate.
*
* @return array Sanitized output for saving.
*/
public function validate($input)
{
try {
$currentTab = $this->getCurrentTab();
/** @var TabInterface $tab */
$tab = $this->tabs[$currentTab];
$this->options->update($currentTab, $tab->validate($input));
} catch (Admin\Settings\ValidationException $e) {
$this->messages->addError($e->getMessage(), true);
$this->wp->wpSafeRedirect(admin_url(sprintf('admin.php?page=%s&tab=%s', self::NAME, $tab->getSlug())));
exit;
}
return $this->options->getAll();
}
/**
* @param $postId int Email template to add.
* @param $hooks array List of hooks to add to.
*/
public function addTemplate($postId, $hooks)
{
$templates = $this->options->get('emails.templates');
if (is_array($templates)) {
$templates = array_map(function ($template) use($postId) {
return array_filter($template, function ($templatePostId) use($postId) {
return $templatePostId != $postId;
});
}, $templates);
}
foreach ($hooks as $hook) {
$templates[$hook][] = $postId;
}
$this->options->update('emails.templates', $templates);
$this->options->saveOptions();
}
/**
* Migrates data from old format to new one.
* @param array $products
* @return bool migration product status: success or not
*/
public function migrate($products)
{
$wpdb = $this->wp->getWPDB();
// Open transaction for save migration products
$var_autocommit_sql = $wpdb->get_var("SELECT @@AUTOCOMMIT");
try {
$this->checkSql();
$wpdb->query("SET AUTOCOMMIT=0");
$this->checkSql();
$wpdb->query("START TRANSACTION");
$this->checkSql();
// Register product type taxonomy to fetch old product types
$this->wp->registerTaxonomy('product_type', array('product'), array('hierarchical' => false, 'show_ui' => false, 'query_var' => true, 'show_in_nav_menus' => false));
$this->checkSql();
if ($this->wp->getOption('jigoshop_migration_product_first', false) == false) {
// Update product_cat into product_category
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->term_taxonomy} SET taxonomy = %s WHERE taxonomy = %s", array('product_category', 'product_cat')));
$this->checkSql();
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->postmeta} SET meta_value = %s WHERE meta_key = %s AND meta_value = %s", array('product_category', '_menu_item_object', 'product_cat')));
$this->checkSql();
foreach ($wpdb->get_results("SELECT * FROM {$wpdb->prefix}jigoshop_termmeta", ARRAY_A) as $termMeta) {
$wpdb->insert($wpdb->prefix . 'jigoshop_term_meta', $termMeta);
}
$this->wp->updateOption('jigoshop_migration_product_first', true);
}
$productIds = array();
$attributes = array();
$productAttributes = array();
$globalAttributes = array();
foreach ($wpdb->get_results("SELECT * FROM {$wpdb->prefix}jigoshop_attribute_taxonomies") as $attribute) {
$this->checkSql();
$globalAttributes[$this->wp->getHelpers()->sanitizeTitle($attribute->attribute_name)] = $attribute;
}
foreach ($wpdb->get_results("SELECT id AS attribute_id, slug AS attribute_name, label AS attribute_label, type AS attribute_type FROM {$wpdb->prefix}jigoshop_attribute") as $attribute) {
$this->checkSql();
$globalAttributes[$attribute->attribute_name] = $attribute;
}
for ($i = 0, $endI = count($products); $i < $endI;) {
$product = $products[$i];
$productIds[] = $product->ID;
$productAttributes[$product->ID] = array('attributes' => array(), 'variations' => array());
// Add product types
$types = $this->wp->getTheTerms($product->ID, 'product_type');
$this->checkSql();
$productType = Product\Simple::TYPE;
if (is_array($types)) {
if (!in_array($types[0]->slug, array(Product\Simple::TYPE, Product\Virtual::TYPE, Product\Downloadable::TYPE, Product\External::TYPE, Product\Variable::TYPE))) {
Migration::saveLog(sprintf(__('We detected a product <a href="%s" target="_blank">(#%d) %s </a> of type "subscription" - this type is not supported by Jigoshop without an additional plugin. We changed its type to "simple" and set it as private.', 'jigoshop'), get_permalink($product->ID), $product->ID, get_the_title($product->ID), $types[0]->slug));
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->posts} SET post_status = 'private' WHERE ID = %d", $product->ID));
$types[0]->slug = 'simple';
}
$productType = $types[0]->slug;
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} VALUES (NULL, %d, %s, %s)", array($product->ID, 'type', $types[0]->slug)));
$this->checkSql();
}
$regularPrice = 0.0;
$taxClasses = array();
// Update columns
do {
// Sales support
if ($products[$i]->meta_key == 'sale_price' && !empty($products[$i]->meta_value)) {
$wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES (%d, %s, %s)", array($product->ID, 'sales_enabled', true)));
$this->checkSql();
}
// Product attributes support
if ($products[$i]->meta_key == 'product_attributes') {
$attributeData = unserialize($products[$i]->meta_value);
if (is_array($attributeData)) {
foreach ($attributeData as $slug => $source) {
if (empty($source['value'])) {
continue;
}
$changeLocalToGlobal = isset($source['variation']) && $source['variation'] == true && $source['is_taxonomy'] != true && $productType == Product\Variable::TYPE;
$productAttributes[$product->ID]['attributes'][$slug] = array('is_visible' => $source['visible'], 'is_variable' => isset($source['variation']) && $source['variation'] == true, 'values' => $changeLocalToGlobal ? str_replace(',', '|', $source['value']) : $source['value']);
if (!isset($attributes[$slug])) {
$type = isset($globalAttributes[$slug]) ? $this->_getAttributeType($globalAttributes[$slug]) : Text::TYPE;
if ($changeLocalToGlobal) {
$type = Multiselect::TYPE;
}
$label = isset($globalAttributes[$slug]) ? !empty($globalAttributes[$slug]->attribute_label) ? $globalAttributes[$slug]->attribute_label : $globalAttributes[$slug]->attribute_name : $source['name'];
$attribute = $this->productService->createAttribute($type);
$attribute->setSlug($slug);
$attribute->setLabel($label);
$attribute->setLocal($source['is_taxonomy'] != true && $changeLocalToGlobal != true);
if ($changeLocalToGlobal) {
foreach (explode('|', $productAttributes[$product->ID]['attributes'][$slug]['values']) as $attributeOption) {
$option = new Option();
$option->setLabel($attributeOption);
$option->setValue(sanitize_title($attributeOption));
$attribute->addOption($option);
}
$productAttributes[$product->ID]['attributes'][$slug]['values'] = array_map(function ($item) {
return sanitize_title($item);
}, explode('|', $productAttributes[$product->ID]['attributes'][$slug]['values']));
}
$attributes[$slug] = $attribute;
}
}
}
}
// Product variation data
if ($products[$i]->meta_key == 'variation_data') {
$variations = unserialize($products[$i]->meta_value);
foreach ($variations as $variation => $value) {
$productAttributes[$product->ID]['variations'][str_replace('tax_', '', $variation)] = sanitize_title($value);
}
}
$key = $this->_transformKey($products[$i]->meta_key);
if ($key !== null) {
$value = $this->_transform($products[$i]->meta_key, $products[$i]->meta_value);
if ($key == 'regular_price') {
$regularPrice = $value;
}
if ($key == 'tax_classes') {
$taxClasses = $value;
}
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->postmeta} SET meta_value = %s, meta_key = %s WHERE meta_id = %d", array($value, $key, $products[$i]->meta_id)));
$this->checkSql();
}
$i++;
} while ($i < $endI && $products[$i]->ID == $product->ID);
// Update regular price if it includes tax
if (!empty($this->taxes)) {
$taxClasses = maybe_unserialize($taxClasses);
foreach ($taxClasses as $taxClass) {
if (isset($this->taxes['__compound__' . $taxClass])) {
$regularPrice = $regularPrice / (100 + $this->taxes['__compound__' . $taxClass]['rate']) * 100;
}
}
foreach ($taxClasses as $taxClass) {
if (isset($this->taxes[$taxClass])) {
$regularPrice = $regularPrice / (100 + $this->taxes[$taxClass]['rate']) * 100;
}
}
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->postmeta} SET meta_value = %s WHERE meta_key = %s AND post_id = %d", array($regularPrice, 'regular_price', $product->ID)));
$this->checkSql();
}
}
foreach ($globalAttributes as $slug => $attributeData) {
if (isset($attributes[$slug])) {
continue;
}
$type = $this->_getAttributeType($attributeData);
$label = !empty($attributeData->attribute_label) ? $attributeData->attribute_label : $attributeData->attribute_name;
$attribute = $this->productService->createAttribute($type);
$attribute->setSlug($slug);
$attribute->setLabel($label);
$attribute->setLocal(false);
$attributes[$slug] = $attribute;
}
foreach ($attributes as $slug => $attribute) {
/** @var $attribute Product\Attribute */
$antiDuplicateAttributes = unserialize($this->wp->getOption('jigoshop_attributes_anti_duplicate', serialize(array())));
if (!isset($antiDuplicateAttributes[$attribute->getSlug()]) || $attribute->isLocal()) {
if (!$attribute->isLocal()) {
// Fetch options if attribute is a taxonomy
$options = $wpdb->get_results("\n\t\t\t\t\t\tSELECT t.name, t.slug FROM {$wpdb->terms} t\n\t\t\t\t\t\t\tLEFT JOIN {$wpdb->term_taxonomy} tt ON tt.term_id = t.term_id\n\t\t\t\t\t\t WHERE tt.taxonomy = 'pa_{$slug}'\n\t\t\t\t \t ");
$this->checkSql();
$createdOptions = array();
foreach ($options as $source) {
$option = new Option();
$option->setLabel($source->name);
$option->setValue($source->slug);
$attribute->addOption($option);
$createdOptions[] = $source->slug;
}
}
$this->productService->saveAttribute($attribute);
$this->checkSql();
if (!$attribute->isLocal()) {
$antiDuplicateAttributes[$attribute->getSlug()] = $attribute->getId();
$this->wp->updateOption('jigoshop_attributes_anti_duplicate', serialize($antiDuplicateAttributes));
$this->checkSql();
}
} else {
//merge attributes
$attribute = $this->productService->getAttribute($antiDuplicateAttributes[$attribute->getSlug()]);
if ($attribute instanceof Product\Attribute) {
$savedOptions = array_map(function ($item) {
return $item->getValue();
}, $attribute->getOptions());
foreach ($attributes[$slug]->getOptions() as $option) {
if (!in_array($option->getValue(), $savedOptions)) {
$attribute->addOption($option);
}
}
$attributes[$slug] = $attribute;
$this->productService->saveAttribute($attribute);
}
}
// Add attribute to the products
if ($attribute instanceof Product\Attribute) {
foreach ($productIds as $id) {
if (isset($productAttributes[$id]['attributes'][$attribute->getSlug()])) {
$data = $productAttributes[$id]['attributes'][$attribute->getSlug()];
$value = array();
if (is_array($data['values'])) {
foreach ($attribute->getOptions() as $option) {
/** @var $option Option */
if (in_array($option->getValue(), $data['values'])) {
$value[] = $option->getId();
}
}
}
if (empty($value)) {
$value = $data['values'];
}
$wpdb->insert($wpdb->prefix . 'jigoshop_product_attribute', array('product_id' => $id, 'attribute_id' => $attribute->getId(), 'value' => is_array($value) ? join('|', $value) : $value));
$this->checkSql();
$query = array('product_id' => $id, 'attribute_id' => $attribute->getId(), 'meta_key' => 'is_visible', 'meta_value' => $data['is_visible']);
$wpdb->insert($wpdb->prefix . 'jigoshop_product_attribute_meta', $query);
$this->checkSql();
if ($data['is_variable']) {
$query = array('product_id' => $id, 'attribute_id' => $attribute->getId(), 'meta_key' => 'is_variable', 'meta_value' => true);
$wpdb->insert($wpdb->prefix . 'jigoshop_product_attribute_meta', $query);
$this->checkSql();
}
}
}
}
}
foreach ($productIds as $id) {
foreach ($productAttributes[$id]['variations'] as $taxonomy => $value) {
if (!isset($attributes[$taxonomy])) {
continue;
}
$attribute = $attributes[$taxonomy];
$option = $this->_findOption($attribute->getOptions(), $value);
$query = array('variation_id' => $id, 'attribute_id' => $attribute->getId(), 'value' => $option);
$wpdb->insert($wpdb->prefix . 'jigoshop_product_variation_attribute', $query);
$this->checkSql();
}
}
// Add found tax classes
$currentTaxClasses = $this->options->get('tax.classes');
$currentTaxClassesKeys = array_map(function ($item) {
return $item['class'];
}, $currentTaxClasses);
$this->taxClasses = array_filter(array_unique($this->taxClasses), function ($item) use($currentTaxClassesKeys) {
return !in_array($item, $currentTaxClassesKeys);
});
foreach ($this->taxClasses as $class) {
$currentTaxClasses[] = array('label' => ucfirst($class), 'class' => $class);
}
$this->options->update('tax.classes', $currentTaxClasses);
// commit sql transation and restore value of autocommit
$wpdb->query("COMMIT");
$wpdb->query("SET AUTOCOMMIT=" . $var_autocommit_sql);
return true;
} catch (Exception $e) {
// rollback sql transation and restore value of autocommit
if (WP_DEBUG) {
\Monolog\Registry::getInstance(JIGOSHOP_LOGGER)->addDebug($e);
}
$wpdb->query("ROLLBACK");
$wpdb->query("SET AUTOCOMMIT=" . $var_autocommit_sql);
Migration::saveLog(__('Migration products end with error: ', 'jigoshop') . $e);
return false;
}
}
