<?php

declare(strict_types=1);

namespace App\Model;

use Mosaico\Model\BaseModel;

class MigrateMagentoCategoryModel extends BaseModel
{
	public function getParentCategories(): bool|object
	{
	    $query = $this->connectMagento()->query("
	    		 SELECT 
	    		 A.entity_id,
	    		 B.value as name_0,
	    		 C.value as name_1,
	    		 D.value as status_0,
	    		 E.value as status_1
	    		 FROM catalog_category_entity A
	    		 LEFT JOIN catalog_category_entity_varchar B
	    		 ON A.entity_id = B.row_id
	    		 AND B.attribute_id = 133
	    		 AND B.store_id = 0
	    		 LEFT JOIN catalog_category_entity_varchar C
	    		 ON A.entity_id = C.row_id
	    		 AND C.attribute_id = 133
	    		 AND C.store_id = 1
	    		 LEFT JOIN catalog_category_entity_int D
	    		 ON A.entity_id = D.row_id
	    		 AND D.attribute_id = 136
	    		 AND D.store_id = 0
	    		 LEFT JOIN catalog_category_entity_int E
	    		 ON A.entity_id = E.row_id
	    		 AND E.attribute_id = 136
	    		 AND E.store_id = 1
	    		 WHERE parent_id = 2
	    	");
	    return $query;
	}

	public function getChildCategories(int $parent_id): bool|object
	{
	    $query = $this->connectMagento()->query("
	    		 SELECT 
	    		 A.entity_id,
	    		 B.value as name_0,
	    		 C.value as name_1,
	    		 D.value as status_0,
	    		 E.value as status_1
	    		 FROM catalog_category_entity A
	    		 LEFT JOIN catalog_category_entity_varchar B
	    		 ON A.entity_id = B.row_id
	    		 AND B.attribute_id = 133
	    		 AND B.store_id = 0
	    		 LEFT JOIN catalog_category_entity_varchar C
	    		 ON A.entity_id = C.row_id
	    		 AND C.attribute_id = 133
	    		 AND C.store_id = 1
	    		 LEFT JOIN catalog_category_entity_int D
	    		 ON A.entity_id = D.row_id
	    		 AND D.attribute_id = 136
	    		 AND D.store_id = 0
	    		 LEFT JOIN catalog_category_entity_int E
	    		 ON A.entity_id = E.row_id
	    		 AND E.attribute_id = 136
	    		 AND E.store_id = 1
	    		 WHERE parent_id = " . $parent_id . "
	    	");
	    return $query;
	}

	public function insertCategoria(array $category, int $parent_id): void
	{
	    $query = $this->connect()->query("
	            INSERT IGNORE INTO catalogo_categorias SET
	            id_magento = " . $category['entity_id'] . ",
	            parent_id = " . $parent_id . ",
	            nombre_categoria = '" . $category['name'] . "'
	        ");
	}

}