OFBIZ 账户与Party PartyRelationship关系分析

PartyAcctgPreference　　账户优先表 默认有个Company的记录：

 INSERT INTO `party_acctg_preference` (`PARTY_ID`, `FISCAL_YEAR_START_MONTH`, `FISCAL_YEAR_START_DAY`, `TAX_FORM_ID`, `COGS_METHOD_ID`, `BASE_CURRENCY_UOM_ID`, `INVOICE_SEQ_CUST_METH_ID`, `INVOICE_ID_PREFIX`, `LAST_INVOICE_NUMBER`, `LAST_INVOICE_RESTART_DATE`, `USE_INVOICE_ID_FOR_RETURNS`, `QUOTE_SEQ_CUST_METH_ID`, `QUOTE_ID_PREFIX`, `LAST_QUOTE_NUMBER`, `ORDER_SEQ_CUST_METH_ID`, `ORDER_ID_PREFIX`, `LAST_ORDER_NUMBER`, `REFUND_PAYMENT_METHOD_ID`, `ERROR_GL_JOURNAL_ID`, `INVOICE_SEQUENCE_ENUM_ID`, `ORDER_SEQUENCE_ENUM_ID`, `QUOTE_SEQUENCE_ENUM_ID`, `LAST_UPDATED_STAMP`, `LAST_UPDATED_TX_STAMP`, `CREATED_STAMP`, `CREATED_TX_STAMP`) VALUES('Company',NULL,NULL,'US_IRS_1120','COGS_LIFO','USD','INV_HOOK_ENF_SEQ','CI',NULL,NULL,NULL,NULL,'CQ',NULL,NULL,'CO',NULL,NULL,'ERROR_JOURNAL',NULL,NULL,NULL,'2012-12-05 15:37:00','2012-12-05 15:37:00','2012-12-05 15:37:00','2012-12-05 15:37:00');

如果仿照上面的记录新增一条进去 页面上将会出现两个账户

ofbiz 偏好 设置 framework/common/config/general.properties

# These values override the _NA_ DEFAULT values in user preferences for the GLOBAL_PREFERENCES userPrefGroupTypeId
# -- the default organizationPartyId for used in dropdowns and reports

ORGANIZATION_PARTY=Company

 

==================================================================================

 

注释掉账户信息，新增商户

1、header.ftl

line 114  add

<li>所属商户：${topLine.groupName}</li>

 

CommonScreens.xml

line 32 add

<set field="line.groupName" value="${partyGroup.groupName}"/>

 

账户信息显示 在 ：

changeOrgPartyId.groovy 文件下

 

INSERT INTO `party_relationship` (`PARTY_ID_FROM`, `PARTY_ID_TO`, `ROLE_TYPE_ID_FROM`, `ROLE_TYPE_ID_TO`, `FROM_DATE`, `THRU_DATE`, `STATUS_ID`, `RELATIONSHIP_NAME`, `SECURITY_GROUP_ID`, `PRIORITY_TYPE_ID`, `PARTY_RELATIONSHIP_TYPE_ID`, `PERMISSIONS_ENUM_ID`, `POSITION_TITLE`, `COMMENTS`, `LAST_UPDATED_STAMP`, `LAST_UPDATED_TX_STAMP`, `CREATED_STAMP`, `CREATED_TX_STAMP`) VALUES('10035','10010','DEPARTMENT','EMPLOYEE','2000-01-01 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2012-12-05 15:36:57','2012-12-05 15:36:57','2012-12-05 15:36:57','2012-12-05 15:36:57');

注：上面的sql，PARTY_ID_FROM : 关联的会员组    PARTY_ID_TO ：关联的会员  一句话定义：从操作员到商户！

 配置 操作员和商户之间关系：

1、创建操作员

2、分配角色   角色：职员 联系

3、创建 会员组 商户 福建恩庭

4、分配角色  角色：部门

5、建立  操作员 到 商户 的关联   创建关系

从 操作员 到 商户 OK!