Powerful and easy to use cms to build websites, blogs or ecommerce stores.
HTML backendblogblog-engineblog-platformbloggingcmscontent-managementcontent-management-systemecommerceecommerce-platformno-codepage-builderphpphp-cmsphp7php8self-hostedshopping-cartweb-applicationwebsite-builder
<?php
/**
* Vvveb
*
* Copyright (C) 2022 Ziadin Givan
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <https://www.gnu.org/licenses/>.
*
*/
namespace Vvveb\Controller\Product;
use function Vvveb\__;
use Vvveb\Controller\Listing;
use function Vvveb\humanReadable;
use Vvveb\Sql\Product_option_valueSQL;
use Vvveb\Sql\Product_optionSQL;
use Vvveb\Sql\Product_variantSQL;
use Vvveb\Sql\ProductSQL;
use Vvveb\System\Core\View;
use Vvveb\System\Images;
use Vvveb\System\User\Admin;
use function Vvveb\url;
class Products extends Listing {
protected string $type = 'product';
/** @var list<string> Check for other modules permission like post and editor to enable links like save/delete etc */
protected ?array $additionalPermissionCheck = ['product/product/save'];
/**
* Initialize the controller, setting the type from request if present.
*
* @return string|null
*/
public function init(): ?string {
if (isset($this->request->get['type'])) {
$this->type = $this->request->get['type'];
}
return parent::init();
}
/**
* Duplicate a product by its ID.
*
* @return void
*/
public function duplicate(): void {
$product_id = $this->request->post['product_id'] ?? false;
if ($product_id) {
$this->products = new ProductSQL();
$options = ['product_id' => $product_id, 'type' => $this->type] + $this->global;
$editCapability = 'edit_other_products';
if (Admin::hasCapability($editCapability)) {
unset($options['admin_id']);
}
$data = $this->products->get($options);
if (!$data) {
$this->view->errors[] = sprintf(__('%s not found!'), ucfirst($this->type));
$this->index();
return;
}
unset($data['product_id']);
$id = mt_rand(1, 1000);
foreach ($data['product_content'] as &$content) {
unset($content['product_id']);
$content['name'] .= ' [' . __('duplicate') . ']';
$content['slug'] .= '-' . __('duplicate') . "-$id";
}
$taxonomy_item_id = [];
if (isset($data['product_to_taxonomy_item'])) {
foreach ($data['product_to_taxonomy_item'] as &$item) {
$taxonomy_item_id[] = $item['taxonomy_item_id'];
}
}
$site_id = [];
if (isset($data['product_to_site'])) {
foreach ($data['product_to_site'] as &$item) {
$site_id[] = $item['site_id'];
}
}
if ($data) {
$result = $this->products->add([
'product' => $data,
'product_content' => $data['product_content'],
'taxonomy_item_id' => $taxonomy_item_id,
'site_id' => $site_id,
]);
if ($result && isset($result['product'])) {
$product_id = $result['product'];
if ($data['product_image']) {
$product_image = [];
foreach ($data['product_image'] as $image) {
$product_image[] = $image['image'];
}
$this->products->productImage(['product_image' => $product_image, 'product_id' => $product_id]);
}
$optionSQL = new Product_optionSQL();
$productoptionvalueSQL = new Product_option_valueSQL();
$product_option_map = [];
$product_option_value_map = [];
if (isset($data['product_option'])) {
foreach ($data['product_option'] as $i => $opt) {
$opt['product_id'] = $product_id;
$product_option_id = $opt['product_option_id'];
// new option
unset($opt['product_option_id']);
$result = $optionSQL->add(['product_option' => $opt] + $this->global);
if ($result && $result['product_option']) {
//set new id to use for option values
$opt['product_option_id'] = $result['product_option'];
$product_option_map[$product_option_id] = $result['product_option'];
}
if (isset($data['product_option_value'])) {
foreach ($data['product_option_value'] as $j => $value) {
//values only for this option
if ($product_option_id != $value['product_option_id']) {
continue;
}
$product_option_value_id = $value['product_option_value_id'];
//set parent option id
$value['product_option_id'] = $opt['product_option_id'];
$value['option_id'] = $opt['option_id'];
$value['product_id'] = $product_id;
unset($value['product_option_value_id']);
$result = $productoptionvalueSQL->add(['product_option_value' => $value] + $this->global);
if ($result && $result['product_option_value']) {
$product_option_value_map[$product_option_value_id] = $result['product_option_value'];
}
}
}
}
}
$variantSQL = new Product_variantSQL();
if (isset($data['product_variant'])) {
foreach ($data['product_variant'] as $i => $opt) {
$opt['product_id'] = $product_id;
unset($opt['product_variant_id']);
$options = explode(',', $opt['options']);
foreach ($options as &$el) {
$vals = explode(':', $el);
$vals[0] = $product_option_map[$vals[0]];
$vals[1] = $product_option_value_map[$vals[1]];
$el = implode(':', $vals);
}
$opt['options'] = implode(',', $options);
$result = $variantSQL->add(['product_variant' => $opt] + $this->global);
if ($result && $result['product_variant']) {
//set new id to use for variant values
$opt['product_variant_id'] = $result['product_variant'];
}
}
}
$url = url(['module' => 'product/product', 'product_id' => $product_id, 'type' => $this->type]);
$success = ucfirst($this->type) . ' ' . __('duplicated') . '!';
$success .= sprintf(' <a href="%s">%s</a>', $url, __('Edit') . ' ' . $this->type);
$this->view->success[] = $success;
$this->session->set('success', $success);
$this->redirect(['module' => 'product/products'], [], false);
} else {
$this->view->errors[] = sprintf(__('Error duplicating %s!'), $this->type);
}
}
}
$this->index();
}
/**
* Delete one or more products.
*
* @return void
*/
public function delete(): void {
$product_id = $this->request->post['product_id'] ?? [];
if ($product_id) {
if (is_numeric($product_id)) {
$product_id = [$product_id];
}
$products = new ProductSQL();
$options = ['product_id' => $product_id] + $this->global;
$editCapability = 'edit_other_products';
if (Admin::hasCapability($editCapability)) {
unset($options['admin_id']);
}
$result = $products->delete($options);
if ($result && isset($result['product'])) {
$this->view->success[] = __('Product(s) deleted!');
} else {
$this->view->errors[] = __('Error deleting product!');
}
}
$this->index();
}
/**
* Display the products listing page.
*
* @return void
*/
public function index(): void {
$view = View::getInstance();
$products = new ProductSQL();
$this->filter = array_filter($this->request->get['filter'] ?? []);
if (isset($this->filter['vendor_id'])) {
$this->filter['vendor_id'] = [$this->filter['vendor_id']];
}
if (isset($this->filter['manufacturer_id'])) {
$this->filter['manufacturer_id'] = [$this->filter['manufacturer_id']];
}
$options = [
'type' => $this->type,
] + $this->global;
if (Admin::hasCapability('view_other_products')) {
unset($options['admin_id']);
} else {
$options['admin_id'] = $this->global['admin_id'];
}
$options += $this->filter;
if (isset($this->request->get['filter']['site_id'])) {
if ($this->request->get['filter']['site_id']) {
//$options['site_id'] = $this->filter['site_id'];
} else {
unset($options['site_id']);
}
}
$results = $products->getAll($options);
$defaultTemplate = "product/{$this->type}.html";
if ($results && isset($results['product'])) {
foreach ($results['product'] as $id => &$product) {
if (isset($product['images'])) {
$product['images'] = json_decode($product['images'], true);
foreach ($product['images'] as &$image) {
$image = Images::image($image, 'product');
}
} else {
if (isset($product['image'])) {
$product['image'] = Images::image($product['image'], 'product');
}
}
if (!$product['name'] && ($product['language_id'] != $this->global['default_language_id'])) {
$product['name'] = '[' . __('No translation') . ']';
}
$url = ['module' => 'product/product', 'product_id' => $product['product_id'], 'type' => $product['type']];
$template = (isset($product['template']) && $product['template']) ? $product['template'] : $defaultTemplate;
$product['url'] = url($url);
$product['edit-url'] = url(['module' => 'product/product', 'product_id' => $product['product_id'], 'type' => $product['type']]);
$product['delete-url'] = url(['module' => 'product/products', 'action' => 'delete'] + $url); // + ['product_id[]' => $product['product_id']]);
$product['duplicate-url'] = url(['module' => 'product/products', 'action' => 'duplicate'] + $url); // + ['product_id' => $product['product_id']]);
$product['view-url'] = url('product/product/index', $product + $url + ['host' => $this->global['host'], 'path' => $this->global['path'] ? '/' . $this->global['path'] : null]);
$relativeUrl = url('product/product/index', $product + $url);
$product['design-url'] = url(['module' => 'editor/page-builder', 'name' => urlencode($product['name'] ?? ''), 'url' => $relativeUrl, 'template' => $template], false);
}
}
$view->set($results);
$view->status = [0 => __('Disabled'), 1 => __('Enabled')];
$view->filter = $this->filter;
$view->type = $this->type;
$view->limit = $options['limit'];
$view->type = $this->type;
$view->addUrl = url(['module' => 'product/product', 'type' => $this->type]);
$view->type_name = humanReadable(__($this->type));
$view->type_name_plural = humanReadable(__($view->type . 's'));
}
}