Question

Currently am working with magento project.. in which i have stucked on the point .. that is when admin add any subcategory/category by

管理类别——>定制设计

这里有两个选择:

Active from and Active to.. can anyone, who know about magento database, tell me where or in which table this two value store

感谢任何建议或帮助!

Answer 1

我现列出以下各组别的属性。由于这些类别属于EAV类,因此,你需要寻找一种特殊的子,以获得你的价值观。在这种情况下,custom_ Design_from and custom_ Design_to为时值,贵实体的名称为catalog_ category_entity,因此,您的表格是catalog_ category_entity_datetime。

你发现的下一个问题是获得正确的身份证明。自他们重新承担改变责任以来,这里摆着“宝库”号,以 gr:

select attribute_id, attribute_code from eav_attribute where entity_type_id = 3 and attribute_code in ( custom_design_from ,  custom_design_to );

我有52和53岁,但YMWV。希望帮助!

Thanks, Joe

+----------------------+--------------+
| attribute_code       | backend_type |
+----------------------+--------------+
| name                 | varchar      |
| is_active            | int          |
| url_key              | varchar      |
| description          | text         |
| image                | varchar      |
| meta_title           | varchar      |
| meta_keywords        | text         |
| meta_description     | text         |
| display_mode         | varchar      |
| landing_page         | int          |
| is_anchor            | int          |
| path                 | static       |
| position             | static       |
| all_children         | text         |
| path_in_store        | text         |
| children             | text         |
| url_path             | varchar      |
| custom_design        | varchar      |
| custom_design_apply  | int          |
| custom_design_from   | datetime     |
| custom_design_to     | datetime     |
| page_layout          | varchar      |
| custom_layout_update | text         |
| level                | static       |
| children_count       | static       |
| available_sort_by    | text         |
| default_sort_by      | varchar      |
| include_in_menu      | int          |
+----------------------+--------------+

Answer 2

Active from is an attribute whose attribute_code is custom_design_from(attribute_id 57) and Active To is an attribute whose attribute_code(attribute_id 58) is custom_design_to.
This both attributes value are stored in database table `catalog_category_entity_datetime`.

下表按实体价值列出: 背景背景

友情链接