在管理面板Broadleaf 6中添加订单 [英] Add Order in Admin Panel Broadleaf 6

问题描述

我知道在版本5之前的客户服务面板中有一个订单，并且他们有意隐藏了该订单。我看到了该线程 http://forum.broadleafcommerce.org/viewtopic.php?t= 25329
，但是当我尝试在数据库中添加该行时，出现错误，表明BLC_ADMIN_MODULE表中不存在MODULE_ID值（4000）。有什么建议么？

I know that before version 5, there was an Order in the Customer Care panel, and that they hide it intentionally. I saw this thread http://forum.broadleafcommerce.org/viewtopic.php?t=25329 but when I try to add that row in the database, I get an error that that MODULE_ID value(4000) doesn't exist in the BLC_ADMIN_MODULE table. Any suggestions?

推荐答案

您只需要将记录添加到数据库中。
要对Broadleaf演示站点启用订单或其他实体管理，可以使用以下sql脚本。
这是我的SQL，它在DBeaver上运行，如果您的数据库客户端有错误，则可以手动更改参数：

You only need to add records to database. To enable order or other entity managements to Broadleaf demo site you can use below sql script. Here my sql, it run on DBeaver, if your db-client have errors you can manually change params:

@set SECTION_ID = 80 --check in db to get unique id
@set SECTION_MENU_TITLE = 'Taho Order'
@set SECTION_KEY = 'TahoOrderSection'
@set SECTION_DISPLAY_ORDER = 1

@set MODULE_ID = 80 --check in db to get unique id
@set MODULE_NAME = 'Taho Order Module'
@set MODULE_KEY = 'taho-order-module'
@set MODULE_ICON = 'blc-icon-globe'
@set MODULE_DISPLAY_ORDER = 800

@set PERMISSION_ID = 80 --check in db to get unique id
@set PERMISSION_TYPE = 'ALL'
@set PERMISSION_NAME = 'PERMISSION_ALL_ORDER_CLASS'
@set PERMISSION_KEY = 'PERMISSION_ALL_ORDER_CLASS'
@set ROUTE_PATH = '/taho-order'
@set ENTITY = 'org.broadleafcommerce.core.order.domain.Order'
@set IS_FRIENDLY = false

@set ENTITY_PERMISSION_ID = 80 --check in db to get unique id
@set CHILD_PERMISSION_ID = 80 --check in db to get unique id

--create new module for admin
insert into public.blc_admin_module
(ADMIN_MODULE_ID, "name", MODULE_KEY, ICON, DISPLAY_ORDER)
values
(${MODULE_ID}, ${MODULE_NAME}, ${MODULE_KEY}, ${MODULE_ICON}, ${MODULE_DISPLAY_ORDER});

-- Create Admin permissions and entity permissions for your new entity
insert into public.blc_admin_permission 
(ADMIN_PERMISSION_ID, DESCRIPTION, "name", PERMISSION_TYPE, IS_FRIENDLY)
values 
(${PERMISSION_ID}, ${PERMISSION_NAME}, ${PERMISSION_KEY}, ${PERMISSION_TYPE}, ${IS_FRIENDLY});

insert into public.blc_admin_permission_entity
(ADMIN_PERMISSION_ENTITY_ID, CEILING_ENTITY, ADMIN_PERMISSION_ID)
values
(${ENTITY_PERMISSION_ID}, ${ENTITY}, ${PERMISSION_ID});

-- Add Role Permission XREF to the Permission
INSERT INTO public.BLC_ADMIN_PERMISSION_XREF 
(ADMIN_PERMISSION_ID, CHILD_PERMISSION_ID) 
VALUES 
(${PERMISSION_ID}, ${CHILD_PERMISSION_ID});

INSERT INTO public.BLC_ADMIN_ROLE_PERMISSION_XREF 
(ADMIN_ROLE_ID, ADMIN_PERMISSION_ID) 
VALUES 
(-1,${PERMISSION_ID});

-- Mapping sections and permissions
INSERT INTO public.BLC_ADMIN_SECTION 
(ADMIN_SECTION_ID, DISPLAY_ORDER, ADMIN_MODULE_ID, "name", SECTION_KEY, URL, CEILING_ENTITY) 
VALUES 
(${SECTION_ID}, ${SECTION_DISPLAY_ORDER}, ${MODULE_ID}, 
${SECTION_MENU_TITLE}, ${SECTION_KEY}, ${ROUTE_PATH}, ${ENTITY});

INSERT INTO public.BLC_ADMIN_SEC_PERM_XREF 
(ADMIN_SECTION_ID, ADMIN_PERMISSION_ID) 
VALUES 
(${SECTION_ID}, ${PERMISSION_ID});

这篇关于在管理面板Broadleaf 6中添加订单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！