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\Editor;
use Vvveb\Controller\Base;
use Vvveb\Sql\CategorySQL;
class Autocomplete extends Base {
/**
* Returns product autocomplete suggestions as JSON.
*
* @return void
*/
public function products(): void {
$text = $this->request->get['text'];
$options = [
'start' => 0,
'limit' => 10,
'like' => $text,
] + $this->global;
unset($options['admin_id']);
$products = new \Vvveb\Sql\ProductSQL();
$results = $products->getAll($options);
$search = [];
foreach ($results['product'] as $product) {
$search[$product['product_id']] = $product['name'];
}
$this->response->setType('json');
$this->response->output($search);
}
/**
* Returns category autocomplete suggestions as JSON.
*
* @return void
*/
public function categories(): void {
$text = $this->request->get['text'];
$options = [
'start' => 0,
'limit' => 10,
'search' => '%' . $text . '%',
] + $this->global;
$categories = new \Vvveb\Sql\CategorySQL();
$results = $categories->getCategories($options);
$search = [];
foreach ($results['categories'] as $category) {
$search[$category['taxonomy_item_id']] = $category['name'];
}
$this->response->setType('json');
$this->response->output($search);
}
/**
* Returns manufacturer autocomplete suggestions as JSON.
*
* @return void
*/
public function manufacturers(): void {
$text = $this->request->get['text'];
$options = [
'start' => 0,
'limit' => 10,
'search' => '%' . $text . '%',
] + $this->global;
$manufacturers = new \Vvveb\Sql\ManufacturerSQL();
$results = $manufacturers->getAll($options);
$search = [];
foreach ($results['manufacturer'] as $manufacturer) {
$search[$manufacturer['manufacturer_id']] = $manufacturer['name'];
}
$this->response->setType('json');
$this->response->output($search);
}
/**
* Returns post autocomplete suggestions as JSON.
*
* @return void
*/
public function posts(): void {
$text = $this->request->get['text'];
$type = $this->request->get['type'] ?? 'post';
$options = [
'start' => 0,
'limit' => 10,
'type' => $type,
'like' => $text,
//'like' => '%' . $text . '%',
] + $this->global;
unset($options['admin_id']);
$posts = new \Vvveb\Sql\PostSQL();
$results = $posts->getAll($options);
$search = [];
if (isset($results['post'])) {
foreach ($results['post'] as $post) {
$search[$post['post_id']] = substr($post['name'], 0, 50);
}
}
$this->response->setType('json');
$this->response->output($search);
}
/**
* Returns tag autocomplete suggestions as JSON.
*
* @return void
*/
public function tags(): void {
$post_id = $this->request->get['post_id'] ?? false;
$taxonomy_id = $this->request->get['taxonomy_id'];
$taxonomy = $this->request->get['taxonomy'];
$text = $this->request->get['text'];
$taxonomy_itemSQL = new CategorySQL();
$options = [
'post_id' => $post_id,
'language_id' => 1,
'site_id' => 1,
'taxonomy' => $taxonomy,
'start' => 1,
'limit' => 100,
'search' => '%' . $text . '%',
] + $this->global;
$results = $taxonomy_itemSQL->getCategories($options + ['taxonomy_id' => $taxonomy_id]);
$search = [];
foreach ($results['categories'] as $taxonomy_item) {
$search[$taxonomy_item['taxonomy_item_id']] = $taxonomy_item['name'];
}
$this->response->setType('json');
$this->response->output($search);
}
}