Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0030235
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 09. Financial managementminoralways2015-06-23 15:452016-03-17 10:55
ReportermalsasuaView Statuspublic 
Assigned Tovmromanos 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisiondafbb746f822
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned Tovmromanos
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0030235: Add an Extension point at the end of aprm_gen_paymentschedule_inv procedure

DescriptionAdd an Extension point at the end of aprm_gen_paymentschedule_inv procedure
Steps To Reproducen/a
TagsNo tags attached.
Attached Filespatch file icon aprm_gen_paymentschedule_inv_NEW_EP.patch [^] (3,924 bytes) 2015-10-27 11:53 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0083750)
vmromanos (manager)
2016-01-30 10:17
edited on: 2016-01-30 13:06

Test plan:

1. Create a new db procedure with the following code:

CREATE OR REPLACE FUNCTION aprm_borrar(p_ep_instance character varying)
  RETURNS void AS
$BODY$ DECLARE
 
p_record_id VARCHAR(60);
p_message VARCHAR(2000);
p_docAction VARCHAR(60);
p_user VARCHAR(60);
p_result NUMERIC;
 
--TYPE RECORD IS REFCURSOR;
Cur_Params RECORD;
 
BEGIN
 
  FOR Cur_Params IN (
    SELECT *
    FROM ad_ep_instance_para
    WHERE ad_ep_instance_id = p_ep_instance
    ) LOOP
    IF (cur_params.parametername LIKE 'DocAction') THEN
      p_docaction := Cur_Params.p_string;
    ELSIF (cur_params.parametername LIKE 'Record_ID') THEN
      p_record_id := cur_params.p_string;
    ELSIF (cur_params.parametername LIKE 'User') THEN
      p_user := cur_params.p_string;
    ELSIF (cur_params.parametername LIKE 'Message') THEN
      p_message := cur_params.p_text;
    ELSIF (cur_params.parametername LIKE 'Result') THEN
      p_result := cur_params.p_number;
    END IF;
  END LOOP;
 
-- The code goes here
update ad_org set name = 'Test' where ad_org_id = '19404EAD144C49A0AF37D54377CF452D';
 
END ; $BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;


2. As System Admin, go to Extension Point window and add the new process to the aprm_gen_paymentschedule_inv end extension point.

3. As Openbravo Admin, create a sales invoice with any line.
Complete it

4. Go to Organization window.
Verify "F&B International Group" organization is now called "Test"

(0083751)
hgbot (developer)
2016-01-30 10:29

Repository: erp/devel/pi
Changeset: dafbb746f82205023a0aab2c15728165c5720c8c
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Sat Jan 30 10:26:12 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/dafbb746f82205023a0aab2c15728165c5720c8c [^]

Fixed bug 30235: Extension point at the end of aprm_gen_paymentschedule_inv

Added Extension point at the end of aprm_gen_paymentschedule_inv procedure, so it now has an extension point at the beginning and at the end of the process.

Solution contributed by partner

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
---
(0083752)
vmromanos (manager)
2016-01-30 10:30

Code review + testing OK
(0085093)
hudsonbot (developer)
2016-03-17 10:55

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b22fb0500156 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2015-06-23 15:45 malsasua New Issue
2015-06-23 15:45 malsasua Assigned To => Triage Finance
2015-06-23 15:45 malsasua Modules => Core
2015-06-23 15:45 malsasua Triggers an Emergency Pack => No
2015-10-27 11:53 VictorVillar File Added: aprm_gen_paymentschedule_inv_NEW_EP.patch
2016-01-30 10:15 vmromanos Status new => scheduled
2016-01-30 10:15 vmromanos Assigned To Triage Finance => vmromanos
2016-01-30 10:17 vmromanos Note Added: 0083750
2016-01-30 10:29 hgbot Checkin
2016-01-30 10:29 hgbot Note Added: 0083751
2016-01-30 10:29 hgbot Status scheduled => resolved
2016-01-30 10:29 hgbot Resolution open => fixed
2016-01-30 10:29 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/dafbb746f82205023a0aab2c15728165c5720c8c [^]
2016-01-30 10:30 vmromanos Review Assigned To => vmromanos
2016-01-30 10:30 vmromanos Note Added: 0083752
2016-01-30 10:30 vmromanos Status resolved => closed
2016-01-30 13:06 vmromanos Note Edited: 0083750 View Revisions
2016-03-17 10:55 hudsonbot Checkin
2016-03-17 10:55 hudsonbot Note Added: 0085093


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker