details: https://code.openbravo.com/erp/devel/pi/rev/e8bebe16d4bf
changeset: 26618:e8bebe16d4bf
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Tue May 12 14:03:06 2015 +0530
summary: Fixes Issue 29042:Should not be possible to delete a summary node in
User
Defined Accounting Report Setup
After Delete part is added in AD_Accountingrpt_Element_Trg which checks
that whether there exists childs for the element being deleted.
diffstat:
src-db/database/model/triggers/AD_ACCOUNTINGRPT_ELEMENT_TRG.xml | 27
+++++++++-
src-db/database/sourcedata/AD_MESSAGE.xml | 12 ++++
2 files changed, 37 insertions(+), 2 deletions(-)
diffs (77 lines):
diff -r e3204358c953 -r e8bebe16d4bf
src-db/database/model/triggers/AD_ACCOUNTINGRPT_ELEMENT_TRG.xml
--- a/src-db/database/model/triggers/AD_ACCOUNTINGRPT_ELEMENT_TRG.xml Tue May
12 21:56:47 2015 +0000
+++ b/src-db/database/model/triggers/AD_ACCOUNTINGRPT_ELEMENT_TRG.xml Tue May
12 14:03:06 2015 +0530
@@ -1,6 +1,6 @@
<?xml version="1.0"?>
<database name="TRIGGER AD_ACCOUNTINGRPT_ELEMENT_TRG">
- <trigger name="AD_ACCOUNTINGRPT_ELEMENT_TRG"
table="AD_ACCOUNTINGRPT_ELEMENT" fires="after" insert="true" update="true"
delete="false" foreach="row">
+ <trigger name="AD_ACCOUNTINGRPT_ELEMENT_TRG"
table="AD_ACCOUNTINGRPT_ELEMENT" fires="after" insert="true" update="true"
delete="true" foreach="row">
<body><![CDATA[
@@ -18,12 +18,13 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
-* All portions are Copyright (C) 2001-2012 Openbravo SLU
+* All portions are Copyright (C) 2001-2015 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************/
v_xTree_ID VARCHAR2(32);
v_xParent_ID VARCHAR2(32);
+ v_count NUMBER;
BEGIN
@@ -90,6 +91,28 @@
WHEN NO_DATA_FOUND THEN
RAISE_APPLICATION_ERROR(-20000, '@20002@') ;
*/
+ IF (DELETING) THEN
+ -- Delete TreeNode --
+ -- get AD_Tree_ID
+ SELECT t.AD_Tree_ID
+ INTO v_xTree_ID
+ FROM AD_Tree t
+ WHERE t.AD_Client_ID=:old.AD_Client_ID
+ AND t.treetype = 'AR';
+ select COUNT(*) INTO v_count
+ from AD_TREENODE
+ INNER JOIN AD_Accountingrpt_Element ON
AD_Accountingrpt_Element.AD_Accountingrpt_Element_ID = AD_TREENODE.NODE_ID
+ where parent_id=:old.AD_Accountingrpt_Element_ID
+ and AD_TREE_ID=v_xTree_ID;
+ IF(v_count>0) THEN
+ RAISE_APPLICATION_ERROR(-20000, '@ChildAccountingRptElementCheck@') ;
+ END IF;
+ DELETE
+ FROM AD_TREENODE
+ WHERE AD_CLIENT_ID=:old.AD_Client_ID
+ AND AD_Tree_ID=v_xTree_ID
+ AND Node_ID=:old.AD_Accountingrpt_Element_ID;
+ END IF;
END AD_ACCOUNTINGRPT_ELEMENT_TRG
]]></body>
</trigger>
diff -r e3204358c953 -r e8bebe16d4bf src-db/database/sourcedata/AD_MESSAGE.xml
--- a/src-db/database/sourcedata/AD_MESSAGE.xml Tue May 12 21:56:47 2015 +0000
+++ b/src-db/database/sourcedata/AD_MESSAGE.xml Tue May 12 14:03:06 2015 +0530
@@ -26239,6 +26239,18 @@
<!--F977FE65113F43B0ADD5D6BF3E4819A1-->
<ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N>
<!--F977FE65113F43B0ADD5D6BF3E4819A1--></AD_MESSAGE>
+<!--F9BFC7160B3645CA95941E5276BAD3C0--><AD_MESSAGE>
+<!--F9BFC7160B3645CA95941E5276BAD3C0-->
<AD_MESSAGE_ID><![CDATA[F9BFC7160B3645CA95941E5276BAD3C0]]></AD_MESSAGE_ID>
+<!--F9BFC7160B3645CA95941E5276BAD3C0-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F9BFC7160B3645CA95941E5276BAD3C0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F9BFC7160B3645CA95941E5276BAD3C0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F9BFC7160B3645CA95941E5276BAD3C0-->
<VALUE><![CDATA[ChildAccountingRptElementCheck]]></VALUE>
+<!--F9BFC7160B3645CA95941E5276BAD3C0--> <MSGTEXT><![CDATA[This accounting
report element cannot be deleted because it has child accounting elements.
Please, delete the child element first.]]></MSGTEXT>
+<!--F9BFC7160B3645CA95941E5276BAD3C0--> <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--F9BFC7160B3645CA95941E5276BAD3C0-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--F9BFC7160B3645CA95941E5276BAD3C0-->
<ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N>
+<!--F9BFC7160B3645CA95941E5276BAD3C0--></AD_MESSAGE>
+
<!--FA5C4E4CAED74DEFA58E298F8771E547--><AD_MESSAGE>
<!--FA5C4E4CAED74DEFA58E298F8771E547-->
<AD_MESSAGE_ID><![CDATA[FA5C4E4CAED74DEFA58E298F8771E547]]></AD_MESSAGE_ID>
<!--FA5C4E4CAED74DEFA58E298F8771E547-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
