[jira] [Comment Edited] (OFBIZ-6919) Birt Report Builder: an enhancement of the Birt component. Easier user possibility of report creation.

2017-01-21 Thread Jacques Le Roux (JIRA)

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

Jacques Le Roux edited comment on OFBIZ-6919 at 1/21/17 12:02 PM:
--

This new birt.zip archive replaces flexibleBirt.tar.gz, small not functional 
change, same usage (delete the birt component, replace it with the content of 
the birt.zip archive)


was (Author: jacques.le.roux):
This new birt.zip archive replaces flexibleBirt.tar.gz, small not functional 
change, same usage

> Birt Report Builder: an enhancement of the Birt component. Easier user 
> possibility of report creation.
> --
>
> Key: OFBIZ-6919
> URL: https://issues.apache.org/jira/browse/OFBIZ-6919
> Project: OFBiz
>  Issue Type: New Feature
>  Components: specialpurpose/birt
>Affects Versions: Trunk
>Reporter: François Wurmser
>Assignee: Jacques Le Roux
>Priority: Minor
> Fix For: Upcoming Release
>
> Attachments: birt.zip, flexibleBirt.tar.gz
>
>
> This is a new implementation of Birt. It allows the creation of "report 
> masters" by the developer, which will in turn let the user create its own 
> reports. Data connection of report is fully generated by OFBiz based on 
> report master. Design is user made.
> Filtering is made via content forms stored in the database ("FORM_COMBINED") 
> data_resource.
> The patch should be available in a few days.
> *Credits:* this feature has been designed by Nicolas Malin, Pierre Gaudin and 
> François Wurmser. It has been implemented by François Wurmser as a Neogia 
> addon and ported by Jacques Le Roux to a custom OFBiz R13 version and then to 
> the OFBiz trunk with simple changes in the framework where it was secured 
> using OWASP security policies.
> *Note:* the BIRT_REPORT_BUILDER_USAGE_POLICY still needs to be completed. For 
> now it's bypassed on "FLEXIBLE_REPORT" contentTypeId, a FIXME exists in Java 
> code



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (OFBIZ-6919) Birt Report Builder: an enhancement of the Birt component. Easier user possibility of report creation.

2017-01-21 Thread Jacques Le Roux (JIRA)

 [ 
https://issues.apache.org/jira/browse/OFBIZ-6919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux updated OFBIZ-6919:
---
Attachment: birt.zip

This new birt.zip archive replaces flexibleBirt.tar.gz, small not functional 
change, same usage

> Birt Report Builder: an enhancement of the Birt component. Easier user 
> possibility of report creation.
> --
>
> Key: OFBIZ-6919
> URL: https://issues.apache.org/jira/browse/OFBIZ-6919
> Project: OFBiz
>  Issue Type: New Feature
>  Components: specialpurpose/birt
>Affects Versions: Trunk
>Reporter: François Wurmser
>Assignee: Jacques Le Roux
>Priority: Minor
> Fix For: Upcoming Release
>
> Attachments: birt.zip, flexibleBirt.tar.gz
>
>
> This is a new implementation of Birt. It allows the creation of "report 
> masters" by the developer, which will in turn let the user create its own 
> reports. Data connection of report is fully generated by OFBiz based on 
> report master. Design is user made.
> Filtering is made via content forms stored in the database ("FORM_COMBINED") 
> data_resource.
> The patch should be available in a few days.
> *Credits:* this feature has been designed by Nicolas Malin, Pierre Gaudin and 
> François Wurmser. It has been implemented by François Wurmser as a Neogia 
> addon and ported by Jacques Le Roux to a custom OFBiz R13 version and then to 
> the OFBiz trunk with simple changes in the framework where it was secured 
> using OWASP security policies.
> *Note:* the BIRT_REPORT_BUILDER_USAGE_POLICY still needs to be completed. For 
> now it's bypassed on "FLEXIBLE_REPORT" contentTypeId, a FIXME exists in Java 
> code



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (OFBIZ-9157) "View Order" throws exception in getReturnableQuantity

2017-01-21 Thread Leonard Lin (JIRA)

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

Leonard Lin commented on OFBIZ-9157:


Thanks!

> "View Order" throws exception in getReturnableQuantity
> --
>
> Key: OFBIZ-9157
> URL: https://issues.apache.org/jira/browse/OFBIZ-9157
> Project: OFBiz
>  Issue Type: Bug
>  Components: order
>Affects Versions: Release Branch 15.12, Release Branch 16.11
> Environment: Encountered this in 15.x and 16.x Trunk versions
>Reporter: Leonard Lin
>Assignee: Jacques Le Roux
>Priority: Minor
> Fix For: Release Branch 14.12, Release Branch 15.12, Upcoming 
> Release, 16.11.02
>
> Attachments: services_return.xml.patch
>
>
> Steps to Reproduce:
> - Create a sales order
> - Add 1 orderitem with no unitPrice set (unitPrice = null) for the product
> - set the status of the order to completed
> - go to order-management and try to open the order for display like:
> https://localhost:8443/ordermgr/control/orderview?orderId=X
> Expected:
> - the order is displayed with status completed
> Actual:
> - A groovy exception is displayed.
> Analysis:
> The service "getReturnableQuantity" throws an exception because it returns 
> the returnablePrice = null, because the unitPrice of the orderItem was null.
> The OUT field returnablePrice is mandatory according to the 
> service-definition. The return parameter is set but the value is null, hence 
> the exception.
> Attached is a patch that will adjust the service-deinition to allow for 
> "null" value of the OUT parameter.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Closed] (OFBIZ-9157) "View Order" throws exception in getReturnableQuantity

2017-01-21 Thread Jacques Le Roux (JIRA)

 [ 
https://issues.apache.org/jira/browse/OFBIZ-9157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux closed OFBIZ-9157.
--
   Resolution: Fixed
 Assignee: Jacques Le Roux
Fix Version/s: Release Branch 14.12
   Release Branch 15.12
   16.11.02
   Upcoming Release

Leonard,

Your solution is committed in
trunk r1779724
R16.11 r1779725
R15.12 r1779726
R14.12 r1779727
R13.07 r1779728



> "View Order" throws exception in getReturnableQuantity
> --
>
> Key: OFBIZ-9157
> URL: https://issues.apache.org/jira/browse/OFBIZ-9157
> Project: OFBiz
>  Issue Type: Bug
>  Components: order
>Affects Versions: Release Branch 15.12, Release Branch 16.11
> Environment: Encountered this in 15.x and 16.x Trunk versions
>Reporter: Leonard Lin
>Assignee: Jacques Le Roux
>Priority: Minor
> Fix For: Upcoming Release, 16.11.02, Release Branch 15.12, 
> Release Branch 14.12
>
> Attachments: services_return.xml.patch
>
>
> Steps to Reproduce:
> - Create a sales order
> - Add 1 orderitem with no unitPrice set (unitPrice = null) for the product
> - set the status of the order to completed
> - go to order-management and try to open the order for display like:
> https://localhost:8443/ordermgr/control/orderview?orderId=X
> Expected:
> - the order is displayed with status completed
> Actual:
> - A groovy exception is displayed.
> Analysis:
> The service "getReturnableQuantity" throws an exception because it returns 
> the returnablePrice = null, because the unitPrice of the orderItem was null.
> The OUT field returnablePrice is mandatory according to the 
> service-definition. The return parameter is set but the value is null, hence 
> the exception.
> Attached is a patch that will adjust the service-deinition to allow for 
> "null" value of the OUT parameter.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (OFBIZ-9157) "View Order" throws exception in getReturnableQuantity

2017-01-21 Thread Jacques Le Roux (JIRA)

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

Jacques Le Roux commented on OFBIZ-9157:


OK thanks, makes sense. I'll apply your solution

> "View Order" throws exception in getReturnableQuantity
> --
>
> Key: OFBIZ-9157
> URL: https://issues.apache.org/jira/browse/OFBIZ-9157
> Project: OFBiz
>  Issue Type: Bug
>  Components: order
>Affects Versions: Release Branch 15.12, Release Branch 16.11
> Environment: Encountered this in 15.x and 16.x Trunk versions
>Reporter: Leonard Lin
>Priority: Minor
> Attachments: services_return.xml.patch
>
>
> Steps to Reproduce:
> - Create a sales order
> - Add 1 orderitem with no unitPrice set (unitPrice = null) for the product
> - set the status of the order to completed
> - go to order-management and try to open the order for display like:
> https://localhost:8443/ordermgr/control/orderview?orderId=X
> Expected:
> - the order is displayed with status completed
> Actual:
> - A groovy exception is displayed.
> Analysis:
> The service "getReturnableQuantity" throws an exception because it returns 
> the returnablePrice = null, because the unitPrice of the orderItem was null.
> The OUT field returnablePrice is mandatory according to the 
> service-definition. The return parameter is set but the value is null, hence 
> the exception.
> Attached is a patch that will adjust the service-deinition to allow for 
> "null" value of the OUT parameter.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (OFBIZ-8316) Update Apache Solr/Lucene to release 6.2.1

2017-01-21 Thread Shi Jinghai (JIRA)

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

Shi Jinghai commented on OFBIZ-8316:


Yesterday, I played indexProduct method of ProductDocument.java for several 
hours with
clean build loadDefault :ofbiz.

The problem that products index cannot be loaded turns out to be caused by 
LongPoint and DoublePoint fields, comment out the fields related to these two 
methods used in indexProduct, everything will be ok.

Today, I'll check further why the LongPoint and DoublePoint fields cannot work 
in our project environment (they are correct in solr test cases i.e. 
TestFieldCacheSort.java).


> Update Apache Solr/Lucene to release 6.2.1
> --
>
> Key: OFBIZ-8316
> URL: https://issues.apache.org/jira/browse/OFBIZ-8316
> Project: OFBiz
>  Issue Type: Improvement
>  Components: specialpurpose/lucene, specialpurpose/solr
>Affects Versions: Trunk
>Reporter: Michael Brohl
>Assignee: Shi Jinghai
>Priority: Minor
> Attachments: OFBIZ-8316_corrected.patch, 
> ofbiz-truck-lucene-6.2.1.patch, ofbiz-truck-solr-6.2.1.patch, 
> solr6.2.1_1.patch
>
>
> According to the announcements in 
> https://lists.apache.org/thread.html/5d2cb1ecbe04c6c40b8eeba3b7f8da586d1271af98c9b07ceee8ada2@%3Cannounce.apache.org%3E
>  and 
> https://lists.apache.org/thread.html/c1269b52229f6bce68399e813b7c6b79eb3f6283ae21bde11c82fc7c@%3Cannounce.apache.org%3E
>  there is a new Solr/Lucene release available.
> This issue takes care of the update.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (OFBIZ-9157) "View Order" throws exception in getReturnableQuantity

2017-01-21 Thread Leonard Lin (JIRA)

 [ 
https://issues.apache.org/jira/browse/OFBIZ-9157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Leonard Lin updated OFBIZ-9157:
---
Environment: Encountered this in 15.x and 16.x Trunk versions  (was: 
Encountered this but in 15.x and 16.x Trunk versions)

> "View Order" throws exception in getReturnableQuantity
> --
>
> Key: OFBIZ-9157
> URL: https://issues.apache.org/jira/browse/OFBIZ-9157
> Project: OFBiz
>  Issue Type: Bug
>  Components: order
>Affects Versions: Release Branch 15.12, Release Branch 16.11
> Environment: Encountered this in 15.x and 16.x Trunk versions
>Reporter: Leonard Lin
>Priority: Minor
> Attachments: services_return.xml.patch
>
>
> Steps to Reproduce:
> - Create a sales order
> - Add 1 orderitem with no unitPrice set (unitPrice = null) for the product
> - set the status of the order to completed
> - go to order-management and try to open the order for display like:
> https://localhost:8443/ordermgr/control/orderview?orderId=X
> Expected:
> - the order is displayed with status completed
> Actual:
> - A groovy exception is displayed.
> Analysis:
> The service "getReturnableQuantity" throws an exception because it returns 
> the returnablePrice = null, because the unitPrice of the orderItem was null.
> The OUT field returnablePrice is mandatory according to the 
> service-definition. The return parameter is set but the value is null, hence 
> the exception.
> Attached is a patch that will adjust the service-deinition to allow for 
> "null" value of the OUT parameter.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (OFBIZ-9157) "View Order" throws exception in getReturnableQuantity

2017-01-21 Thread Leonard Lin (JIRA)

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

Leonard Lin commented on OFBIZ-9157:


Hi [~jacques.le.roux],

Yes, the order and orderItem is created programmatically.

I import orders from an external Webshop into OFBiz for fulfillment processing.
In this project I'm not using OFBiz accounting / pricing, that's why no prices 
are set.

Best,
Leonard

> "View Order" throws exception in getReturnableQuantity
> --
>
> Key: OFBIZ-9157
> URL: https://issues.apache.org/jira/browse/OFBIZ-9157
> Project: OFBiz
>  Issue Type: Bug
>  Components: order
>Affects Versions: Release Branch 15.12, Release Branch 16.11
> Environment: Encountered this but in 15.x and 16.x Trunk versions
>Reporter: Leonard Lin
>Priority: Minor
> Attachments: services_return.xml.patch
>
>
> Steps to Reproduce:
> - Create a sales order
> - Add 1 orderitem with no unitPrice set (unitPrice = null) for the product
> - set the status of the order to completed
> - go to order-management and try to open the order for display like:
> https://localhost:8443/ordermgr/control/orderview?orderId=X
> Expected:
> - the order is displayed with status completed
> Actual:
> - A groovy exception is displayed.
> Analysis:
> The service "getReturnableQuantity" throws an exception because it returns 
> the returnablePrice = null, because the unitPrice of the orderItem was null.
> The OUT field returnablePrice is mandatory according to the 
> service-definition. The return parameter is set but the value is null, hence 
> the exception.
> Attached is a patch that will adjust the service-deinition to allow for 
> "null" value of the OUT parameter.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Closed] (OFBIZ-9128) Document current possiblities of the EntityAutoEngine

2017-01-21 Thread Jacques Le Roux (JIRA)

 [ 
https://issues.apache.org/jira/browse/OFBIZ-9128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Le Roux closed OFBIZ-9128.
--
Resolution: Works for Me
  Assignee: Paul Foxworthy

Thanks Paul, works for me :)

> Document current possiblities of the EntityAutoEngine
> -
>
> Key: OFBIZ-9128
> URL: https://issues.apache.org/jira/browse/OFBIZ-9128
> Project: OFBiz
>  Issue Type: Sub-task
>  Components: Confluence, framework
>Affects Versions: Trunk
>Reporter: Jacques Le Roux
>Assignee: Paul Foxworthy
>Priority: Minor
> Fix For: Upcoming Release
>
>
> As explained [~paul_foxworthy] [in this 
> comment|https://issues.apache.org/jira/browse/OFBIZ-9117?focusedCommentId=15672946=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-15672946]
> {quote}
> I don't expect entity-auto to handle every possible situation. I'd suggest we 
> keep it simple and 80-20 rather than fiddle with it forever.
> There's an error message if you try to push it too hard which lists what it 
> can do:
> "1. a single OUT pk for primary auto-sequencing, " +
> "2. a single INOUT pk for primary auto-sequencing with optional override, " +
> "3. a 2-part pk with one part IN (existing primary pk) and one part OUT (the 
> secondary pk to sub-sequence), " +
> "4. a N-part pk with N-1 part IN and one party OUT only (missing pk is a 
> sub-sequence mainly for entity assoc), " +
> "5. all pk fields are IN for a manually specified primary key");
> So it can deliver one new id in an out parameter, but not more than one. I 
> can live with that. For more complex situations, we can write a service 
> rather than use entity auto.
> {quote}
> I suggest we document it in services.xsd and the [Service Engine 
> Guide|https://cwiki.apache.org/confluence/display/OFBIZ/Service+Engine+Guide],
>  explaining what the possiblities are based on the message above. BTW I had a 
> look at services.xsd and it's not yet documented enough.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (OFBIZ-9157) "View Order" throws exception in getReturnableQuantity

2017-01-21 Thread Jacques Le Roux (JIRA)

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

Jacques Le Roux commented on OFBIZ-9157:


Hi Leonard, 

About
bq. - Add 1 orderitem with no unitPrice set (unitPrice = null) for the product
I know no product with a null price. So you do that programatically, right? 

> "View Order" throws exception in getReturnableQuantity
> --
>
> Key: OFBIZ-9157
> URL: https://issues.apache.org/jira/browse/OFBIZ-9157
> Project: OFBiz
>  Issue Type: Bug
>  Components: order
>Affects Versions: Release Branch 15.12, Release Branch 16.11
> Environment: Encountered this but in 15.x and 16.x Trunk versions
>Reporter: Leonard Lin
>Priority: Minor
> Attachments: services_return.xml.patch
>
>
> Steps to Reproduce:
> - Create a sales order
> - Add 1 orderitem with no unitPrice set (unitPrice = null) for the product
> - set the status of the order to completed
> - go to order-management and try to open the order for display like:
> https://localhost:8443/ordermgr/control/orderview?orderId=X
> Expected:
> - the order is displayed with status completed
> Actual:
> - A groovy exception is displayed.
> Analysis:
> The service "getReturnableQuantity" throws an exception because it returns 
> the returnablePrice = null, because the unitPrice of the orderItem was null.
> The OUT field returnablePrice is mandatory according to the 
> service-definition. The return parameter is set but the value is null, hence 
> the exception.
> Attached is a patch that will adjust the service-deinition to allow for 
> "null" value of the OUT parameter.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)