ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ratnesh Upadhyay (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-9647) Missing Relationship from OrderHeader to WebSite
Date Sat, 26 Aug 2017 14:41:03 GMT

    [ https://issues.apache.org/jira/browse/OFBIZ-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16142831#comment-16142831
] 

Ratnesh Upadhyay commented on OFBIZ-9647:
-----------------------------------------

While working on this, I've noticed few things that needs to be discussed :

1.  We have few order in DemoOrderTestData.xml and OrderTestData.xml that are having webSiteId="OrderEntry"
but we don't have any record in WebSite entity for "OrderEntry" webSiteId.
2. We have "setCustRequestStatus" and "setCustRequestStatus" ecas where we are having following
condition :
<condition field-name="webSiteId" operator="equals" value="OrderEntry"/>
Although we don't have this webSite record in entity then these ecas are no more of use as
system never meet this condition.
3. There is no "webSiteId" is being set for orders placed from ordermgr application, so IMO
we should setup webSiteId parameter in servletConetext of ordermgr app to get it setup. I
can see its usage to get the information of orders placed from store front as well as from
backend application.

To apply FK constraint either we have to add record in WebSite entity or remove the references
of "OrderEntry" webSiteId from order demo data. Also please let me know your thoughts to set
webSiteId for backend apps.

IMO, we should add record in WebSite entity for "OrderEntry".

Discussion going on mailing list for the same.

> Missing Relationship from OrderHeader to WebSite
> ------------------------------------------------
>
>                 Key: OFBIZ-9647
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-9647
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: order
>    Affects Versions: Trunk
>            Reporter: Ratnesh Upadhyay
>
> OrderHeader entity have webSiteId field but there is no relationship defined for it with
WebSite entity. It must have FK constraint from OrderHeader.webSiteId to WebSite.webSiteId.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message