details: https://code.openbravo.com/erp/devel/pi/rev/c389a2ee19ab changeset: 32248:c389a2ee19ab user: Ander Iraceburu <ander.iraceburu <at> openbravo.com> date: Tue May 30 17:40:13 2017 +0200 summary: Fixes issue 33035: Purchase Order Report Refactor
details: https://code.openbravo.com/erp/devel/pi/rev/bd4e27a4cef5 changeset: 32249:bd4e27a4cef5 user: Ander Iraceburu <ander.iraceburu <at> openbravo.com> date: Wed May 31 17:00:14 2017 +0200 summary: Related to issue 33035: Improved GrantAccessToProcessDefinition modulescript diffstat: modules/org.openbravo.v3.datasets/referencedata/standard/V3_Roles.xml | 995 ++++++--- modules/org.openbravo.v3.datasets/src-db/database/sourcedata/AD_DATASET.xml | 2 +- modules/org.openbravo.v3.datasets/src-db/database/sourcedata/AD_DATASET_TABLE.xml | 14 + referencedata/sampledata/F_B_International_Group/AD_PROCESS_ACCESS.xml | 168 - referencedata/sampledata/F_B_International_Group/OBUIAPP_PROCESS_ACCESS.xml | 168 + referencedata/sampledata/QA_Testing/AD_PROCESS_ACCESS.xml | 42 - referencedata/sampledata/QA_Testing/OBUIAPP_PROCESS_ACCESS.xml | 42 + src-db/database/sourcedata/AD_MENU.xml | 4 +- src-db/database/sourcedata/AD_PROCESS.xml | 5 +- src-db/database/sourcedata/AD_REFERENCE.xml | 40 + src-db/database/sourcedata/AD_REF_LIST.xml | 37 + src-db/database/sourcedata/AD_TEXTINTERFACES.xml | 209 +- src-db/database/sourcedata/OBUIAPP_PARAMETER.xml | 208 ++ src-db/database/sourcedata/OBUIAPP_PROCESS.xml | 20 + src-db/database/sourcedata/OBUIAPP_REPORT.xml | 12 + src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 33 + src-util/modulescript/build/classes/org/openbravo/modulescript/GrantAccessToProcessDefinition.class | 0 src-util/modulescript/build/classes/org/openbravo/modulescript/GrantAccessToProcessDefinitionData.class | 0 src-util/modulescript/src/org/openbravo/modulescript/GrantAccessToProcessDefinition.java | 76 + src-util/modulescript/src/org/openbravo/modulescript/GrantAccessToProcessDefinition_data.xsql | 73 + src/org/openbravo/erpCommon/ad_reports/ReportPurchaseOrder.jrxml | 145 +- src/org/openbravo/erpCommon/ad_reports/ReportPurchaseOrderXLS.jrxml | 526 +++++ 22 files changed, 2119 insertions(+), 700 deletions(-) diffs (truncated from 5087 to 300 lines): diff -r 79776d2f41ce -r bd4e27a4cef5 modules/org.openbravo.v3.datasets/referencedata/standard/V3_Roles.xml --- a/modules/org.openbravo.v3.datasets/referencedata/standard/V3_Roles.xml Wed May 31 13:22:49 2017 +0000 +++ b/modules/org.openbravo.v3.datasets/referencedata/standard/V3_Roles.xml Wed May 31 17:00:14 2017 +0200 @@ -1,1903 +1,2074 @@ -<?xml version="1.0" encoding="UTF-8"?> -<ob:Openbravo xmlns:ob="http://www.openbravo.com"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> +<?xml version="1.0" encoding="UTF-8"?><ob:Openbravo xmlns:ob="http://www.openbravo.com"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> <ADFormAccess id="03C10D4B5CF24B34AF9453550C32736A" identifier="About - Employee"> <id>03C10D4B5CF24B34AF9453550C32736A</id> <specialForm id="800015" entity-name="ADForm" identifier="About"/> <role id="CA5B7FB2C95740E499C0F102343D51AD" entity-name="ADRole" identifier="Employee"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.201Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.367Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.201Z</updated> + <updated transient="true">2017-05-30T11:47:04.367Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="207015D47EF449BA89229EAC2A8A97B4" identifier="About - Company Executive"> <id>207015D47EF449BA89229EAC2A8A97B4</id> <specialForm id="800015" entity-name="ADForm" identifier="About"/> <role id="FF808181259DADEB01259DDDA4C201E6" entity-name="ADRole" identifier="Company Executive"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.201Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.367Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.201Z</updated> + <updated transient="true">2017-05-30T11:47:04.367Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="2423622E375A40C29924DBE8AD4B7539" identifier="Requisition To Order - Procurement"> <id>2423622E375A40C29924DBE8AD4B7539</id> <specialForm id="1004400000" entity-name="ADForm" identifier="Requisition To Order"/> <role id="D7D7D228E4594ACE8D00FD0E08B333DE" entity-name="ADRole" identifier="Procurement"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.201Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.367Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.201Z</updated> + <updated transient="true">2017-05-30T11:47:04.367Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="2E16347CD9544BE99044907B9EC27E31" identifier="AccountTransactions - Finance"> <id>2E16347CD9544BE99044907B9EC27E31</id> <specialForm id="4201E189318E443297F6B23F03CABB9D" entity-name="ADForm" identifier="AccountTransactions"/> <role id="FF8081812250326E012250353BDE0005" entity-name="ADRole" identifier="Finance"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.200Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.367Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.200Z</updated> + <updated transient="true">2017-05-30T11:47:04.367Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="4EB3829FE09245A48872504BDBE90244" identifier="Payment Execution - Finance"> <id>4EB3829FE09245A48872504BDBE90244</id> <specialForm id="FE9623C32FE749DD803ED7C64CCD7405" entity-name="ADForm" identifier="Payment Execution"/> <role id="FF8081812250326E012250353BDE0005" entity-name="ADRole" identifier="Finance"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.200Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.366Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.200Z</updated> + <updated transient="true">2017-05-30T11:47:04.366Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="874AA2F3CBF44F68B997E14061AA4EA5" identifier="About - Finance"> <id>874AA2F3CBF44F68B997E14061AA4EA5</id> <specialForm id="800015" entity-name="ADForm" identifier="About"/> <role id="FF8081812250326E012250353BDE0005" entity-name="ADRole" identifier="Finance"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.199Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.366Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.199Z</updated> + <updated transient="true">2017-05-30T11:47:04.366Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="880AF9D29D804E3A88BF356872E5A064" identifier="About - Company Admin"> <id>880AF9D29D804E3A88BF356872E5A064</id> <specialForm id="800015" entity-name="ADForm" identifier="About"/> <role id="FF808181259DADEB01259DDDA4BB01E5" entity-name="ADRole" identifier="Company Admin"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.199Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.366Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.199Z</updated> + <updated transient="true">2017-05-30T11:47:04.366Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="E1FB2FF7692542BEAF95900E75598FA9" identifier="About - Warehouse"> <id>E1FB2FF7692542BEAF95900E75598FA9</id> <specialForm id="800015" entity-name="ADForm" identifier="About"/> <role id="FF808181259DADEB01259DDDA4C201E7" entity-name="ADRole" identifier="Warehouse"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.199Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.366Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.199Z</updated> + <updated transient="true">2017-05-30T11:47:04.366Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="ED6E4BC8B7CB4E4E84EEC7602A3F0254" identifier="About - Procurement"> <id>ED6E4BC8B7CB4E4E84EEC7602A3F0254</id> <specialForm id="800015" entity-name="ADForm" identifier="About"/> <role id="D7D7D228E4594ACE8D00FD0E08B333DE" entity-name="ADRole" identifier="Procurement"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.198Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.366Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.198Z</updated> + <updated transient="true">2017-05-30T11:47:04.366Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="EF86D2E94549468F942E9BEE01BCA249" identifier="About - Sales"> <id>EF86D2E94549468F942E9BEE01BCA249</id> <specialForm id="800015" entity-name="ADForm" identifier="About"/> <role id="FF8081812250326E012250353BDE0006" entity-name="ADRole" identifier="Sales"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.198Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.365Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.198Z</updated> + <updated transient="true">2017-05-30T11:47:04.365Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="FF808181259DADEB01259DDDA4C201E8" identifier="Alert Management - Company Admin"> <id>FF808181259DADEB01259DDDA4C201E8</id> <specialForm id="800016" entity-name="ADForm" identifier="Alert Management"/> <role id="FF808181259DADEB01259DDDA4BB01E5" entity-name="ADRole" identifier="Company Admin"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.198Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.365Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.198Z</updated> + <updated transient="true">2017-05-30T11:47:04.365Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="FF808181259DADEB01259DDDA4C301E9" identifier="Alert Management - Sales"> <id>FF808181259DADEB01259DDDA4C301E9</id> <specialForm id="800016" entity-name="ADForm" identifier="Alert Management"/> <role id="FF8081812250326E012250353BDE0006" entity-name="ADRole" identifier="Sales"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.197Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.365Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.197Z</updated> + <updated transient="true">2017-05-30T11:47:04.365Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="FF808181259DADEB01259DDDA4C301EA" identifier="Alert Management - Finance"> <id>FF808181259DADEB01259DDDA4C301EA</id> <specialForm id="800016" entity-name="ADForm" identifier="Alert Management"/> <role id="FF8081812250326E012250353BDE0005" entity-name="ADRole" identifier="Finance"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.197Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.365Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.197Z</updated> + <updated transient="true">2017-05-30T11:47:04.365Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="FF808181259DADEB01259DDDA4C301EC" identifier="GL Posting by DB Tables - Finance"> <id>FF808181259DADEB01259DDDA4C301EC</id> <specialForm id="800003" entity-name="ADForm" identifier="GL Posting by DB Tables"/> <role id="FF8081812250326E012250353BDE0005" entity-name="ADRole" identifier="Finance"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.197Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.365Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.197Z</updated> + <updated transient="true">2017-05-30T11:47:04.365Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="FF808181259DADEB01259DDDA4C301ED" identifier="Create Invoices from Orders - Finance"> <id>FF808181259DADEB01259DDDA4C301ED</id> <specialForm id="100" entity-name="ADForm" identifier="Create Invoices from Orders"/> <role id="FF8081812250326E012250353BDE0005" entity-name="ADRole" identifier="Finance"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.196Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.364Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.196Z</updated> + <updated transient="true">2017-05-30T11:47:04.364Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="FF808181259DADEB01259DDDA4C401EE" identifier="Alert Management - Company Executive"> <id>FF808181259DADEB01259DDDA4C401EE</id> <specialForm id="800016" entity-name="ADForm" identifier="Alert Management"/> <role id="FF808181259DADEB01259DDDA4C201E6" entity-name="ADRole" identifier="Company Executive"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.196Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.364Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.196Z</updated> + <updated transient="true">2017-05-30T11:47:04.364Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="FF808181259DADEB01259DDDA4C401EF" identifier="Alert Management - Warehouse"> <id>FF808181259DADEB01259DDDA4C401EF</id> <specialForm id="800016" entity-name="ADForm" identifier="Alert Management"/> <role id="FF808181259DADEB01259DDDA4C201E7" entity-name="ADRole" identifier="Warehouse"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.195Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.364Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.195Z</updated> + <updated transient="true">2017-05-30T11:47:04.364Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="FF808181259DADEB01259DDDA4C401F0" identifier="Create Shipments from Orders - Warehouse"> <id>FF808181259DADEB01259DDDA4C401F0</id> <specialForm id="110" entity-name="ADForm" identifier="Create Shipments from Orders"/> <role id="FF808181259DADEB01259DDDA4C201E7" entity-name="ADRole" identifier="Warehouse"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.195Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.364Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.195Z</updated> + <updated transient="true">2017-05-30T11:47:04.364Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADFormAccess id="FF808181259DADEB01259DDDA4C401F1" identifier="Pending Goods Receipts - Warehouse"> <id>FF808181259DADEB01259DDDA4C401F1</id> <specialForm id="800009" entity-name="ADForm" identifier="Pending Goods Receipts"/> <role id="FF808181259DADEB01259DDDA4C201E7" entity-name="ADRole" identifier="Warehouse"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.195Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.364Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.195Z</updated> + <updated transient="true">2017-05-30T11:47:04.364Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADFormAccess> <ADWindowAccess id="024DBCC13FEF447F8057128973499A6F" identifier="Requisition - Procurement"> <id>024DBCC13FEF447F8057128973499A6F</id> <window id="800092" entity-name="ADWindow" identifier="Requisition"/> <role id="D7D7D228E4594ACE8D00FD0E08B333DE" entity-name="ADRole" identifier="Procurement"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.194Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.364Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.194Z</updated> + <updated transient="true">2017-05-30T11:47:04.364Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>true</editableField> + <inheritedFrom xsi:nil="true"/> </ADWindowAccess> <ADWindowAccess id="03125C94CDCE49A6B2DFC7A7684A2DA3" identifier="Bank File Format - Finance"> <id>03125C94CDCE49A6B2DFC7A7684A2DA3</id> <window id="557A0AA1D0D745F9A61557C05483072C" entity-name="ADWindow" identifier="Bank File Format"/> <role id="FF8081812250326E012250353BDE0005" entity-name="ADRole" identifier="Finance"/> <active>true</active> - <creationDate transient="true">2011-12-13T10:35:14.194Z</creationDate> + <creationDate transient="true">2017-05-30T11:47:04.363Z</creationDate> <createdBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> - <updated transient="true">2011-12-13T10:35:14.194Z</updated> + <updated transient="true">2017-05-30T11:47:04.363Z</updated> <updatedBy transient="true" id="100" entity-name="ADUser" identifier="Openbravo"/> <editableField>false</editableField> + <inheritedFrom xsi:nil="true"/> ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
