<?php //namespace App\KommaApp\Kms\Core\SearchIndex;
//
//use Illuminate\Database\DatabaseManager;
//use App\KommaApp\Categories\Models\Category;
//use App\KommaApp\Languages\Models\Language;
//use App\KommaApp\Products\ProductRepository;
//use App\KommaApp\Pages\Models\PageTranslation;
//
//
///**
// *
// *
// * @author      Komma <info@komma.pro>
// * @copyright   (c) 2012-2016, Komma
// */
//class SearchIndexService
//{
//    /**
//     * @var DatabaseManager
//     */
//    protected $db;
//
//    /**
//     * @var SearchIndexRepository
//     */
//    protected $searchIndexRepository;
//
//    /**
//     * @var ProductRepository
//     */
//    protected $productRepository;
//
//    function __construct(
//        DatabaseManager $db,
//        SearchIndexRepository $searchIndexRepository,
//        ProductRepository $productRepository
//    )
//    {
//        $this->db = $db;
//        $this->searchIndexRepository = $searchIndexRepository;
//        $this->productRepository = $productRepository;
//    }
//
//    public function reindexAllCategoriesAndProducts()
//    {
//        $this->reindex('all');
//    }
//
//    /***
//     * Rebuild the search index based in what.
//     *
//     * @param string $what , eg.all, products, pages, categories
//     */
//    public function reindex($what = 'all')
//    {
//        /**Empty the current index*/
//
//        $this->what = $what;
//        //If what is all or products index products, remove current index
//        if ($this->what == 'all' || $this->what == 'products') \Search::index('products')->deleteIndex();
//        //If what is all or pages index pages, remove current index
//        if ($this->what == 'all' || $this->what == 'pages') \Search::index('pages')->deleteIndex();
//        //If what is all or categories index catetgories, remove current index
//        if ($this->what == 'all' || $this->what == 'categories') \Search::index('categories')->deleteIndex();
//
//        /** Create new index*/
//
//        //index the categories and his products of what is all, pages or products
//        if ($this->what == 'all' || $this->what == 'categories'||$this->what == 'products') $this->indexCategoriesAndItsProducts();
//
//        //index the pages if what is all or pages
//        if ($this->what == 'all' || $this->what == 'pages') $this->indexPages();
//
//    }
//
//
//    /**
//     * Index categories and the products from a category;
//     */
//    public function indexCategoriesAndItsProducts()
//    {
//        //Load the root categorie (lft =1)
//        $rootCategories = Category::where('lft', '=', '1')->get();
//
//        //Loop trough the rootCategories (equqals sites)
//        foreach ($rootCategories as $category) {
//            $this->addCategoryAndChildren($category);
//        }
//
//    }
//
//    /***
//     * This will remove the index of a specific category
//     * This is called by the categoryRepository on destroy
//     *
//     * @param Category $category
//     */
//    public function removeCategory(Category $category)
//    {
//        // Get the ids of the translations in the category
//        $categoryTranslations = $this->searchIndexRepository
//            ->getCategoryTranslations($category, ['category_translations.id as id']);
//
//        // Remove the selected category from the search index
//        foreach ($categoryTranslations as $categoryTranslation)
//            \Search::index('categories')->delete($categoryTranslation->id);
//
//
//        // Get the ids of all product translations of the category and its children
//        $productTranslations = $this->searchIndexRepository
//            ->getProductTranslationsInCategory($category, ['product_translations.id as id']);
//        // Remove the selected category from the search index
//        foreach ($productTranslations as $productTranslation)
//            \Search::index('products')->delete($productTranslation->id);
//    }
//
//    /***
//     * This will remove the index of a specific category
//     * This is not called because we will reindex all
//     *
//     * @param Category $category
//     */
//    public function removeCategoryAndChildren(Category $category)
//    {
//        // Get the ids of the translations in the category
//        $categoryTranslations = $this->searchIndexRepository
//            ->getCategoryTranslationsHierarchically($category, ['category_translations.id as id']);
//        // Remove the selected categories from the search index
//        foreach ($categoryTranslations as $categoryTranslation)
//            \Search::index('categories')->delete($categoryTranslation->id);
//
//
//        // Get the ids of all product translations of the category and its children
//        $productTranslations = $this->searchIndexRepository
//            ->getProductTranslationsInCategoryHierarchically($category, ['product_translations.id as id']);
//
//        // Remove the selected products from the search index
//        foreach ($productTranslations as $productTranslation)
//            \Search::index('products')->delete($productTranslation->id);
//    }
//
//    /***
//     * Reindex all categories and categorie children
//     * All the products from a categorie will be indexed
//     *
//     * @param Category $category
//     */
//    public function addCategoryAndChildren(Category $category)
//    {
//
//        // Get the categories to insert in the search index
//        $categoryTranslations = $this->searchIndexRepository
//            ->getActiveCategoryTranslationsHierarchically($category, [
//                'categories.id as id',
//                'category_translations.id as translation_id',
//                'category_translations.name as title',
//                'category_translations.description as content',
//                'categories.site_id as site_id',
//                'category_translations.language_id as language_id',
//                'routes.route as route'
//            ]);
//
//        // Put the categories in the search index
//        $count = 0;
//        foreach ($categoryTranslations as $categoryTranslation) {
//            $this->insertCategory($categoryTranslation);
//            $count++;
//            if ($count == 1000) {
//                $count = 0;
//                \Log::info("Indexed 1000 categorie translations");
//            }
//        }
//        \Log::info("Done: " . count($categoryTranslations) . " categorie translations indexed");
//
//        //index the products from the current $category
//        $this->indexCategoryProducts($category);
//    }
//
//    /***
//     * Index the products of the given category
//     *
//     * @param $category
//     */
//    private function indexCategoryProducts($category)
//    {
//        // Get the products to insert in the search index
//        $productTranslations = $this->searchIndexRepository
//            ->getProductTranslationsInActiveCategoriesHierarchically($category, [
//                'products.id as id',
//                'product_translations.id as translation_id',
//                'categories.id as category_id',
//                'product_translations.name as title',
//                'product_translations.description as content',
//                'products_sites.site_id as site_id',
//                'product_translations.language_id as language_id',
//                'products.name as name',
//                'products.brand_name as brand_name',
//                'products.supplier_name as supplier_name',
//                'products.article_number as article_number',
//                'products.internal_article_number as internal_article_number',
//                'products.bypass as bypass',
//                'products.fine_dust_filter as fine_dust_filter',
//                'products.filter_class as filter_class',
//                'products.size as size',
//                'products.is_filter_set as is_filter_set',
//                'product_translations.special_1 as special_1',
//                'product_translations.special_2 as special_2',
//                'product_translations.composition as composition',
//                'products_sites.price as price',
//                'routes.route as route'
//            ]);
//
//        // Put the products in the search index
//        $count = 0;
//        foreach ($productTranslations as $productTranslation) {
//            $this->insertProduct($productTranslation);
//            $count++;
//            if ($count == 1000) {
//                $count = 0;
//                \Log::info("Indexed 1000 product translations");
//            }
//        }
//        \Log::info("Done: " . count($productTranslations) . " product translations indexed");
//    }
//
//    /***
//     * Index all the pages
//     */
//    public function indexPages()
//    {
//        //Load all the pages
//        $pageTranslations = PageTranslation::with('page')->get();
//
//        $count = 0;
//        foreach($pageTranslations as $pageTranslation){
//            $this->insertPage($pageTranslation);
//            if ($count == 1000) {
//                $count = 0;
//                \Log::info("Indexed 1000 pages translations");
//            }
//        }
//        \Log::info("Done: " . count($pageTranslations) . " pages translations indexed");
//
//    }
//
//
//    /***
//     * Insert One category in the index
//     *
//     * @param $category
//     */
//    public function insertCategory($category)
//    {
//        \Search::index('categories')->insert($category->translation_id, [
//            'title' => \Str::ascii($category->title),
//            'content' => \Str::ascii($category->content),
//            'siteId' => $category->site_id,
//            'languageId' => $category->language_id
//        ], [
//            'title' => $category->title,
//            'id' => $category->id,
//            'type' => 'category',
//            'route' => $category->route,
//        ]);
//    }
//
//    /**
//     * Index one given product in the search index
//     * @param $product
//     */
//
//    public function insertProduct($product)
//    {
////        $discounts = $this->productRepository->getProductDiscountsByCategoryId($product->category_id);
//
//        $titleArray = [];
//        if ($product->brand_name) $titleArray[] = $product->brand_name;
//        if ($product->title) $titleArray[] = $product->title;
//        if ($product->special_1) $titleArray[] = $product->special_1;
//        if ($product->special_2) $titleArray[] = $product->special_2;
//        if ($product->is_filter_set) $titleArray[] = \Lang::get('pages/products.is_filter_set_' . $product->is_filter_set, [], Language::find($product->language_id)->first()->iso_2);
//
//        if ($product->filter_class) $titleArray[] = $product->filter_class;
//        if ($product->internal_article_number) $titleArray[] = $product->internal_article_number;
//
//        $fullTitle = implode(' ', $titleArray);
//
//        if ($product->article_number) $titleArray[] = $product->article_number;
//
//        $title = implode(' ', $titleArray);
//
//        \Search::index('products')->insert($product->translation_id, [
//            'title' => $title,
//            'content' => \Str::ascii($product->content),
//            'siteId' => $product->site_id,
//            'languageId' => $product->language_id,
//        ], [
//            'id' => $product->id,
//            'title' => $fullTitle,
//            'type' => 'product',
//            'route' => $product->route
//        ]);
//    }
//
//    /***
//     * Insert One page in the index
//     *
//     * @param $page
//     */
//    public function insertPage($pageTranslation)
//    {
//        \Search::index('pages')->insert($pageTranslation->id, [
//            'title' => $pageTranslation->name,
//            'content' => $pageTranslation->description . ' ' . $pageTranslation->description_two,
//            'siteId' => $pageTranslation->page->site_id,
//            'languageId' => $pageTranslation->language_id,
//        ], [
//            'id' => $pageTranslation->page->id,
//        ]);
//    }
//
//
//
//
//
//}