?? ????? Joomla ??? ?? ?? ??? ??? ?? ???? CRON? ??? ??? ??? ???? ? ??? ?? ???????. ?? ????? ?? ??? ??? ?????.

??? ??

???? ??? ???? ?? ?? ??? ????? ??? ? ?? ??? ???????. Joomla 4 / Joomla 5? ?? ????? ?? ???? ?? ?/?? ????? ????? ??? ??? ????. ???? ??? ?? ??? ???? ????? ???? ????? ??? ??? ?? ????? ??? ??? ?????. Joomla? ??:

• ??? ?? ???? ??? - ?? Joomla ??. Joomla 3? ?? ???? ???? ??? Joomla 4 / Joomla 5? ?????
• ??? ?? ???? ?? 2012? Joomla Community Magazine ??.
• Joomla ??? ?? Nicholas Dionysopoulos? Joomla Extensions Development ?! Joomla ?? 4 ? 5? ?? ??.
• ??? ?? ?? manual.joomla.org? ?????? ?? - Joomla 4 ? Joomla 5?. ## ???? ?????. Joomla 5 ??? ?? ???? ?? ??? ?? ?? ??? ??? ??? ????? ?? ?????. ?? ??? ???? ???? ???? ?? ?? ??? ???? ????. ??? ??? ???? ??? ??? ????? ?? ???? ??????. ? ????? ??? ???? ??? ???? ???? ????? ?????. CLI? ??? ????? ???? ??? ?????.

??? ???? ?? ?? ????? JoomlaComponentFinderAdministratorIndexerAdapter ???? ???? ??? ??? administrator/comComponents/com_finder/src/Indexer/Adapter.php? ????. ???? ??? ??? ??? ????. ?? ??? plugins/finder ???? ??, ????, ???, ?? ?? ?? Joomla ?? ??? ?? ????? ??? ? ????. ?? JoomShopping(Joomla ????? ?? ??) ? SW JProjects(???? ??? ??? ?? Joomla ?? ???? ?? ??) ?? ??? ?? ??? ?? ???? ??? ?????? ??? ??? ?? ???? ??? ?????. JoomShopping? ?? ???? ???? ?? ??????. ??? ??? ?? ???? SW JProjects? ??? ???? ???.

??? ?? ????? ?? ??

Joomshopping? ??? ?? ????? ?? ??? ???? ?? ??? ????.

Joomla 5 ??? ?? ???? ?? ??

?? ???/provider.php

provider.php ??? ???? Joomla DI ????? ????? ??? ? ?? MVCFactory? ???? ???? ???? ???? ???? ? ????.

<?php

/**
 * @package     Joomla.Plugin
 * @subpackage  Finder.Wtjoomshoppingfinder
 *
 * @copyright   (C) 2023 Open Source Matters, Inc. <https://www.joomla.org>
 * @license     GNU General Public License version 2 or later; see LICENSE.txt
 */

\defined('_JEXEC') or die;

use Joomla\CMS\Extension\PluginInterface;
use Joomla\CMS\Factory;
use Joomla\CMS\Plugin\PluginHelper;
use Joomla\Database\DatabaseInterface;
use Joomla\DI\Container;
use Joomla\DI\ServiceProviderInterface;
use Joomla\Event\DispatcherInterface;
use Joomla\Plugin\Finder\Wtjoomshoppingfinder\Extension\Wtjoomshoppingfinder;

return new class () implements ServiceProviderInterface {
    /**
     * Registers the service provider with a DI container.
     *
     * @param   Container  $container  The DI container.
     *
     * @return  void
     *
     * @since   4.3.0
     */
    public function register(Container $container)
    {
        $container->set(
            PluginInterface::class,
            function (Container $container) {
                $plugin     = new Wtjoomshoppingfinder(
                    $container->get(DispatcherInterface::class),
                    (array) PluginHelper::getPlugin('finder', 'wtjoomshoppingfinder')
                );
                $plugin->setApplication(Factory::getApplication());

                // Our plugin uses DatabaseTrait, so the setDatabase() method appeared 
                // If it is not present, then we use only setApplication().
                $plugin->setDatabase($container->get(DatabaseInterface::class));

                return $plugin;
            }
        );
    }
};

???? ??? ??

????? ?? ?? ??? ??? ?????. src/Extension ??? ???? ???. ? ???? JoomlaPluginFinderWtjoomshoppingfinderExtensionWtjoomshoppingfinder ???? ???? plugins/finder/wtjoomshoppingfinder/src/Extension/Wtjoomshoppingfinder.php ??? ????. ????? ??????? JoomlaPluginFinderWtjoomshoppingfinderExtension???.

??? ??? ???? ??? ?? ? ??? ??? ????(?? Adapter ???? ???? ????).

???? ?? ?? ??

• $extension - ??? ??? ???? ?? ??? ?????. ?? ?? com_content???. ? ???? com_jshopping???.
• $context - ????? ?? ????, ????? ???? ??? ????? ?????. ??? ?? ???? ???(??)? ?????. ?? ??? Wtjoomshoppingfinder???.
• $layout - ?? ?? ??? ?? ???? ?????. ? ????? ?? ??? ??? ? ?????. ?? ??, $layout ????? ??? ??? ?? ? ??? ?? ??? ???? ? ? ?? ?? ??? default_article.php?? ???? ??? ?????. ?? ??? ?? ? ??? default_result.php?? ??? ???? ??? ?? ?????. HTML ????? ??? ?? ????? comComponents/com_finder/tmpl/search? ????. ??? ????? html ??? ??? templates/YOUR_TEMPLATE/html/com_finder/search? ????? ???? ???. ? ???? ???? ?? ??? ???? ?? ??? default_product.php???.
• $table - ???? ???? ?? ????? ??????? ??? ?????(?: #__content). ? ???? JoomShopping ??? ?? ?? ???? #__jshopping_products ???.
• $state_field - ??? ??? ?? ??? ???? ?????? ???? ?? ?????. ????? ? ??? ???? ???. ??? JoomShopping? ?? ? ??? product_publish?? ???.

<?php

/**
 * @package     Joomla.Plugin
 * @subpackage  Finder.Wtjoomshoppingfinder
 *
 * @copyright   (C) 2023 Open Source Matters, Inc. <https://www.joomla.org>
 * @license     GNU General Public License version 2 or later; see LICENSE.txt
 */

\defined('_JEXEC') or die;

use Joomla\CMS\Extension\PluginInterface;
use Joomla\CMS\Factory;
use Joomla\CMS\Plugin\PluginHelper;
use Joomla\Database\DatabaseInterface;
use Joomla\DI\Container;
use Joomla\DI\ServiceProviderInterface;
use Joomla\Event\DispatcherInterface;
use Joomla\Plugin\Finder\Wtjoomshoppingfinder\Extension\Wtjoomshoppingfinder;

return new class () implements ServiceProviderInterface {
    /**
     * Registers the service provider with a DI container.
     *
     * @param   Container  $container  The DI container.
     *
     * @return  void
     *
     * @since   4.3.0
     */
    public function register(Container $container)
    {
        $container->set(
            PluginInterface::class,
            function (Container $container) {
                $plugin     = new Wtjoomshoppingfinder(
                    $container->get(DispatcherInterface::class),
                    (array) PluginHelper::getPlugin('finder', 'wtjoomshoppingfinder')
                );
                $plugin->setApplication(Factory::getApplication());

                // Our plugin uses DatabaseTrait, so the setDatabase() method appeared 
                // If it is not present, then we use only setApplication().
                $plugin->setDatabase($container->get(DatabaseInterface::class));

                return $plugin;
            }
        );
    }
};

???? ??? ?? ???

• setup() : bool - ???? ?? ??, ????? ?? ?? ?? ??????. ? ???? onBeforeIndex ????? ????(reindex() ???) ?? ?????. ???? true? ???? ???. ??? ??? ?? ??? ?????.
• index() : void - ??? ??? ???? ?????. ?? SQL ?? ????? ??? ??? ??? ??? ?? ???? ?? JoomlaComponentFinderAdministratorIndexerIndexer ???? ?????. ???? ???? ? ??? ?? ?????. ??? ??? $item???. ??????? ?? ?? ???? JoomlaComponentFinderAdministratorIndexerResult ???? ??? ?????.
• getListQuery() : JoomlaDatabaseDatabaseQuery - ??? ?? ??? ???? ??????…

... ??? ???? ???? ?? ?? ????? ???? ???? getListQuery() ???? ??? ??? ??? ??? ??? ?? ??? ???? ?????.

"??? ??" ??? ?? ?? ??? ??? ?????.

?? ??? ??? ?????. ???? ??? ??? ?????.

?? ??? ????? ??? ??? ???? ???? ?? ?? ??? ???? ??? ??? ??? ?????! 1?? ??? ?? ??? ?? ?? ??? ??? ???? ???, ???? ??? ??? ??? ??? ?????.

Joomla? ???? ?? ???? Joomla? ?? ??? Joomla? ??? ?? ???? ??? ????? ??? ?? ???? ????(??? ??? ?????). ?????? ??? ?? ??? ?????. Joomla ??? ???? ?? ??? ???????. ?? ? ??? ???? ??? ???? ???(?? SELECT ??? ???? ??? ? ??), ??? ???? ??? ?? ??? ??? ???? ???????.

• id - ?? ??
• ?? ID - ??, ??, ??, ??, ???? ? ?? ?? ??? ?? ???? ? ??? ?? ?? ? ???? ??? ??? ???? #__assets ??? ??? ID???. Joomla? ACL(??? ?? ??) ??? ?????.
• title - ?? ??
• ?? - ?? ??
• ?? ??? - ??? ?? ?? ??? ?? ??? ??? ??
• fulltext - ??? ?? ???, ??? ?? ?? ?? ?
• state - ?? ??? ???? ?? ???: ??? ?????? ??.
• catid - ?? ????? ID???. Joomla?? ?? CMS?? "??? ???"? ?? ?? ????. ?? ????? ??? ?? ??? ??(??, ???, ?? ?)? ????.
• ??- ??? ??? ?????.
• ?? - ???? ??ID (??? ??? ???(???), ??, ?? ?)
• Metakey - ??? ?? ??????. ?, 2009???? Google?? ???? ????. ??? Joomla??? ??? ???? ???? ??? ??? ??? ???? ?? ??? ?? ???? ? ??? ???? ??? ????? ?? ????.
• Metadesc - ?? ?? ??
• ??_? ? ??_?? - ?? ?? ? ?? ?? ?? ?????. ?? ??? ???? ?? ?? ???? ?????.

#__content(Joomla ??), #__contact_details(??? ?? ??), #__tags(Joomla ??), #__categories(Joomla ???? ?? ??) ???? ???? ??? ??? ??? ?? ?? ??? ?? ? ????.

??? ?? ????? ???? ?? ??? "Joomla ??"? ??? ?? ????? ???? ?? ???? ????? ???? ???? ??? ? ????. ???? ?? ?? ?? ?? ??? ?? ??? ????? Adapter ???? ?? ?? ???? ????? ??? ?? ?? ? ????.

getListQuery() ???

? ???? 3?? ??? ?????.

1. Adapter ???? getContentCount() ???? ??? ??? ?? ?(? ?? ?, ? ?? ? ?)? ???? ????. Joomla ??? ?? ?? ?? ???? ??? ???? ???? ?? ?? ??? ? ????.
2. Adapter ???? getItem($id) ???? ?? ID? ?? ?? ??? ???? ????. getItem() ???? ?? ??? ???? ?? reindex($id) ????? ?????.
3. Adapter ???? getItems($offset, $limit, $query = null) ???? ??? ??? ??? ???? ??????. ???? ??? ?? ?? ??("??"? ????? ?? ?? ???? ?)? ?? ?????. Joomla 5 ??? ?? ?? ??? ?? ??

Joomla ?? ????? ?? ?? ???????.

<?php

/**
 * @package     Joomla.Plugin
 * @subpackage  Finder.Wtjoomshoppingfinder
 *
 * @copyright   (C) 2023 Open Source Matters, Inc. <https://www.joomla.org>
 * @license     GNU General Public License version 2 or later; see LICENSE.txt
 */

\defined('_JEXEC') or die;

use Joomla\CMS\Extension\PluginInterface;
use Joomla\CMS\Factory;
use Joomla\CMS\Plugin\PluginHelper;
use Joomla\Database\DatabaseInterface;
use Joomla\DI\Container;
use Joomla\DI\ServiceProviderInterface;
use Joomla\Event\DispatcherInterface;
use Joomla\Plugin\Finder\Wtjoomshoppingfinder\Extension\Wtjoomshoppingfinder;

return new class () implements ServiceProviderInterface {
    /**
     * Registers the service provider with a DI container.
     *
     * @param   Container  $container  The DI container.
     *
     * @return  void
     *
     * @since   4.3.0
     */
    public function register(Container $container)
    {
        $container->set(
            PluginInterface::class,
            function (Container $container) {
                $plugin     = new Wtjoomshoppingfinder(
                    $container->get(DispatcherInterface::class),
                    (array) PluginHelper::getPlugin('finder', 'wtjoomshoppingfinder')
                );
                $plugin->setApplication(Factory::getApplication());

                // Our plugin uses DatabaseTrait, so the setDatabase() method appeared 
                // If it is not present, then we use only setApplication().
                $plugin->setDatabase($container->get(DatabaseInterface::class));

                return $plugin;
            }
        );
    }
};

getListQuery() ???? ?? ???? ??? DatabaseQuery ??? ?????. ??? ??? ??? ?? ??? ?? ???? ????. ?? ???? ????? ??? ?????.

DatabaseQuery $query ??? getContentCount()?? getListQuery()? ???? select? ??? ?? COUNT(*)? ?????.

getItem($id)?? getListQuery()? ???? $query->where('a.id = ' . (int) $id) ??? ???? ?? ??? ?????. ??? ?? ???? ?? Adapter ???? ??? ??? ??? a.*? ???? ??? ? ? ????. ?? getListQuery() ??? ????? ??? ???? ???? ?? ?????.

getItems()?? getListQuery()? ???? ?? ???? ?? ??? ???? ?? ??? ??? $offset ? $limit? ?????.
??: getListQuery() - ? ?? ?? SQL ??? ?? "?? ??"? ???? ???. ??? Joomla? ???? ? ??? ??? ?? ????. ??? ??? ?? getListQuery()? ???? ?? 3?? ???? ?? ??? ?? ????.

? ?? ??: JoomShopping? ?? ??? ?? ????? ?? ? ??? ????? ??? ???? ID(catid) ?? ??? ??? ???? ???? ??? ??? ??????. ???, ?? ?? ??? ?? ????? ???? ?? ???????. ?? ????? ???? ????? ??? ???? ??? ???????. ??? ? ?? ?? ??? ???? ?? ???? ID? ???? ??????(?: ????). ??? ??? ? ????? ?????, ?? ?? ????? ID ??? ?? ????????. ?? ???? ??? URL? ?????? ??? ? ?????? ?? ????? ??? ? ????.

??? ?? 2? ?? ? JoomShopping ??? ???????. ? ?? ??? ?? ??? ?? ?? ???? ??? ?? ???? ???? ??? ? ?? ??? ?? ??? ?? ???? ???????. ??? ?? ????? ???? ??? ?? ?? ???? ?????? ???. ??? ???? main_category_id? ???? ?????.

??? ? ??? ????? ?????? ????. ??? ??? ?? ?????? JoomShopping ?? ??? ????? ???? ?? ?? ????? ???? ??? ????? ??? ???? ???. ??? ?????? ? ??? ?? ??? ?? ????? ???? ?????. ??? ??? ????...) ???? ????? ???? ??? ???? SQL ??? ?????. main_category_id ?? ?? ??? ??? ???? ???? ID? ???? ?? JOIN ?????.

? ???? ??? ??? ???? ?? ?????. Joomla ??? ??? ???? ? ??? ?? ??? ??? ???? ?? ??? ??? ?????. ??? ????? ?? ??? ?????. ?? ?? ??? ??? ???? ????. ?? ?? ?? ??? ???? ?? ???? Joomla ??????? ??? ???? ? ???? ?? ??? ???????.

JoomShopping??? ??? ???? ??? ????. ?? ??? ???? ??? ?? ??? ???? ?????(Ok). ?? ??? ?? ??? ??? ?? ??? ???(?...)? ??? ?? ???? ?????. ?, ???????? ???? ?? ??? ?? ?? ????. ??? name_ru-RU, name_en-GB ?? ??? ????.

Joomla JoomShopping ?? ??? ?? ??
??? ?? ??? CLI ???? ???? ? ??? ?? SQL ??? ???? ???. ??? CRON? ???? CLI? ??? ? ??? ??? ???? ?? ?????. ?? ? ?? ?? ???? ? ??? ?? ???? ???? ??? ??? ??? ?? ?????. ??? JoomShopping ?????? ?? ??? ????? ???? ?? ??? ???? ?? getLangTag() ???? ???? ?????. ?, ???? ? ???? ?? ?? ????? ?????. ?? ???? ??? ?? ???? ????.

??? 3?? ?? ? ??? ??????. ??? ?? SW JProjects ?? ??? ??? ?? ????? ????. ?? ??? ?? ??? ????????.

??? JoomShopping? ?? ?? ????? ???????

<?php

/**
 * @package     Joomla.Plugin
 * @subpackage  Finder.Wtjoomshoppingfinder
 *
 * @copyright   (C) 2023 Open Source Matters, Inc. <https://www.joomla.org>
 * @license     GNU General Public License version 2 or later; see LICENSE.txt
 */

\defined('_JEXEC') or die;

use Joomla\CMS\Extension\PluginInterface;
use Joomla\CMS\Factory;
use Joomla\CMS\Plugin\PluginHelper;
use Joomla\Database\DatabaseInterface;
use Joomla\DI\Container;
use Joomla\DI\ServiceProviderInterface;
use Joomla\Event\DispatcherInterface;
use Joomla\Plugin\Finder\Wtjoomshoppingfinder\Extension\Wtjoomshoppingfinder;

return new class () implements ServiceProviderInterface {
    /**
     * Registers the service provider with a DI container.
     *
     * @param   Container  $container  The DI container.
     *
     * @return  void
     *
     * @since   4.3.0
     */
    public function register(Container $container)
    {
        $container->set(
            PluginInterface::class,
            function (Container $container) {
                $plugin     = new Wtjoomshoppingfinder(
                    $container->get(DispatcherInterface::class),
                    (array) PluginHelper::getPlugin('finder', 'wtjoomshoppingfinder')
                );
                $plugin->setApplication(Factory::getApplication());

                // Our plugin uses DatabaseTrait, so the setDatabase() method appeared 
                // If it is not present, then we use only setApplication().
                $plugin->setDatabase($container->get(DatabaseInterface::class));

                return $plugin;
            }
        );
    }
};

?????

Joomla?? ??????? ???? ??? ???? ??? ?? ????? ?? ??? ?? ?? ?? ?????.

?? ???? ??? ?? ?? ??? ??? ???? ??? ???????. ?? ???? ??? ??????? ???? ??? ?? ???? ??? ? ???? ???? ???? ??? ??? ?? ??? ?? ??? ??? ??? ??? ?????.

Joomla ???? ???

• https://joomla.org/
• Joomla ???? ???? ?? ? ??
• Mattermost? Joomla ???? ??(??? ??)

? ??? Joomla ??? ??? ?? ?? ???? ??? I.? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!