details: https://code.openbravo.com/erp/devel/main/rev/927030652194 changeset: 23056:927030652194 user: Atul Gaware <atul.gaware <at> openbravo.com> date: Mon May 12 22:19:01 2014 +0530 summary: Fixes Issue 26242: Avoid reactivating orders with payment awaiting execution. Modulescript to create alerts for orders having wrong payment plan info.
details: https://code.openbravo.com/erp/devel/main/rev/c60e27530619 changeset: 23057:c60e27530619 user: Rafa Roda Palacios <rafa.roda <at> ubiquads.com> date: Wed May 14 10:32:46 2014 +0200 summary: Fixes Issue 26148 Modified ReportGeneralLedgerJournal JRXML file so entry numbers > 9999 are displayed details: https://code.openbravo.com/erp/devel/main/rev/e9d8dcaed86a changeset: 23058:e9d8dcaed86a user: Guillermo Gil <guillermo.gil <at> openbravo.com> date: Mon May 19 12:43:51 2014 +0200 summary: Fixed issue 26552: email sent when the role should not receive it Alert's messages are now created taking into account if the record can be shown by the recipient role. details: https://code.openbravo.com/erp/devel/main/rev/80167ec6695d changeset: 23059:80167ec6695d user: RM packaging bot <staff.rm <at> openbravo.com> date: Mon May 19 15:38:10 2014 +0000 summary: CI: merge back from main details: https://code.openbravo.com/erp/devel/main/rev/d9ce373c75da changeset: 23060:d9ce373c75da user: Guillermo Gil <guillermo.gil <at> openbravo.com> date: Tue May 20 09:38:17 2014 +0200 summary: Fixed issue 26305:starts with operator is not supported for numbers starts with is not a supported operator for numbers. Look for validOperators and if the operator is not a valid operator, remove it. details: https://code.openbravo.com/erp/devel/main/rev/8d555b8cf67e changeset: 23061:8d555b8cf67e user: RM packaging bot <staff.rm <at> openbravo.com> date: Tue May 20 15:36:45 2014 +0000 summary: CI: update AD_MODULE to version 23060 diffstat: modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrders.class | 0 modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrdersData.class | 0 modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_ORD.xml | 12 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 4 +- modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrders.java | 80 + modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrders_data.xsql | 137 +++ modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrdersData.java | 427 ++++++++++ modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 8 +- modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-number.js | 7 + modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 6 +- modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 4 +- modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.reports.ordersawaitingdelivery/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.reports.ordersawaitingdelivery/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 10 +- modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 4 +- modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 12 +- modules/org.openbravo.userinterface.skin.250to300Comp/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.userinterface.skin.250to300Comp/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 2 +- modules/org.openbravo.userinterface.smartclient/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.userinterface.smartclient/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 6 +- modules/org.openbravo.v3.datasets/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.v3.datasets/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 6 +- modules/org.openbravo.v3.framework/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.v3.framework/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 24 +- modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE.xml | 2 +- modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml | 18 +- src-db/database/sourcedata/AD_MODULE.xml | 4 +- src/org/openbravo/erpCommon/ad_process/AlertProcess.java | 37 +- src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.jrxml | 34 +- 50 files changed, 797 insertions(+), 101 deletions(-) diffs (truncated from 1823 to 300 lines): diff -r 3e03b90c27d7 -r 8d555b8cf67e modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrders.class Binary file modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrders.class has changed diff -r 3e03b90c27d7 -r 8d555b8cf67e modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrdersData.class Binary file modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrdersData.class has changed diff -r 3e03b90c27d7 -r 8d555b8cf67e modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_ORD.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_ORD.xml Mon May 19 09:53:59 2014 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_ORD.xml Tue May 20 15:36:45 2014 +0000 @@ -39,6 +39,7 @@ v_docSubType c_doctype.docsubtypeso%TYPE; v_PaymentPriority VARCHAR(32); v_count NUMBER; +v_Documentno Fin_Payment.DocumentNo%TYPE; TYPE RECORD IS REF CURSOR; Cur_Params RECORD; @@ -192,6 +193,17 @@ IF (v_count <> 0) THEN RAISE_APPLICATION_ERROR(-20000, '@APRM_OrderWithPayments@'); END IF; + SELECT count(*), max(p.DocumentNo) + INTO v_count, v_DocumentNo + FROM fin_payment_schedule ps, fin_payment_scheduledetail psd, + fin_payment_detail pd, fin_payment p + WHERE ps.fin_payment_schedule_id = psd.fin_payment_schedule_order + AND ps.c_order_id = p_record_id + AND psd.fin_payment_detail_id = pd.fin_payment_detail_id + AND pd.fin_payment_id = p.fin_payment_id; + IF (v_count <> 0) THEN + RAISE_APPLICATION_ERROR(-20000, '@APRM_OrderWithPayments@'||v_DocumentNo); + END IF; v_resultstr:='Update/Delete scheduled payments details'; FOR Cur_PaymentScheduleDetail IN ( SELECT psd.* diff -r 3e03b90c27d7 -r 8d555b8cf67e modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml Mon May 19 09:53:59 2014 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml Tue May 20 15:36:45 2014 +0000 @@ -6,7 +6,7 @@ <!--A918E3331C404B889D69AA9BFAFB23AC--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> <!--A918E3331C404B889D69AA9BFAFB23AC--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--A918E3331C404B889D69AA9BFAFB23AC--> <NAME><![CDATA[Advanced Payables and Receivables Mngmt]]></NAME> -<!--A918E3331C404B889D69AA9BFAFB23AC--> <VERSION><![CDATA[3.0.23049]]></VERSION> +<!--A918E3331C404B889D69AA9BFAFB23AC--> <VERSION><![CDATA[3.0.23060]]></VERSION> <!--A918E3331C404B889D69AA9BFAFB23AC--> <DESCRIPTION><![CDATA[Managing your finances with an ERP does not have to be difficult. Enjoy a radically improved user experience that combines the power of an enterprise grade financial application with the simplicity and ease of a web 2.0 personal accounting service.]]></DESCRIPTION> <!--A918E3331C404B889D69AA9BFAFB23AC--> <HELP><![CDATA[Advanced Payables and Receivables Management simplifies and automates the business processes around the management of financial accounts, from the receipt and issue of payment, to the reconciliation of those events with bank statements. If you would like to help shape this module you are welcome to take part in the forum discussions or register feature requests or issues in the corresponding (Forum and Bug Tracking) sections in the Advanced Payables and Receivable project in the OB Forge.]]></HELP> diff -r 3e03b90c27d7 -r 8d555b8cf67e modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml Mon May 19 09:53:59 2014 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml Tue May 20 15:36:45 2014 +0000 @@ -7,7 +7,7 @@ <!--89326AE95DAD449D85DFAB2C5B1C6683--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--89326AE95DAD449D85DFAB2C5B1C6683--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> <!--89326AE95DAD449D85DFAB2C5B1C6683--> <AD_DEPENDENT_MODULE_ID><![CDATA[5EB4F15C80684ACA904756BDC12ADBE5]]></AD_DEPENDENT_MODULE_ID> -<!--89326AE95DAD449D85DFAB2C5B1C6683--> <STARTVERSION><![CDATA[2.1.23049]]></STARTVERSION> +<!--89326AE95DAD449D85DFAB2C5B1C6683--> <STARTVERSION><![CDATA[2.1.23060]]></STARTVERSION> <!--89326AE95DAD449D85DFAB2C5B1C6683--> <ISINCLUDED><![CDATA[N]]></ISINCLUDED> <!--89326AE95DAD449D85DFAB2C5B1C6683--> <DEPENDANT_MODULE_NAME><![CDATA[User Interface Selector]]></DEPENDANT_MODULE_NAME> <!--89326AE95DAD449D85DFAB2C5B1C6683--> <DEPENDENCY_ENFORCEMENT><![CDATA[MAJOR]]></DEPENDENCY_ENFORCEMENT> @@ -21,7 +21,7 @@ <!--B97FC854C6DD41E692161585645A900F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--B97FC854C6DD41E692161585645A900F--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> <!--B97FC854C6DD41E692161585645A900F--> <AD_DEPENDENT_MODULE_ID><![CDATA[0]]></AD_DEPENDENT_MODULE_ID> -<!--B97FC854C6DD41E692161585645A900F--> <STARTVERSION><![CDATA[3.0.23049]]></STARTVERSION> +<!--B97FC854C6DD41E692161585645A900F--> <STARTVERSION><![CDATA[3.0.23060]]></STARTVERSION> <!--B97FC854C6DD41E692161585645A900F--> <ISINCLUDED><![CDATA[N]]></ISINCLUDED> <!--B97FC854C6DD41E692161585645A900F--> <DEPENDANT_MODULE_NAME><![CDATA[core]]></DEPENDANT_MODULE_NAME> <!--B97FC854C6DD41E692161585645A900F--> <DEPENDENCY_ENFORCEMENT><![CDATA[MAJOR]]></DEPENDENCY_ENFORCEMENT> diff -r 3e03b90c27d7 -r 8d555b8cf67e modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrders.java --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrders.java Tue May 20 15:36:45 2014 +0000 @@ -0,0 +1,80 @@ +/* + ************************************************************************* + * The contents of this file are subject to the Openbravo Public License + * Version 1.0 (the "License"), being the Mozilla Public License + * Version 1.1 with a permitted attribution clause; you may not use this + * file except in compliance with the License. You may obtain a copy of + * the License at http://www.openbravo.com/legal/license.html + * Software distributed under the License is distributed on an "AS IS" + * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the + * License for the specific language governing rights and limitations + * under the License. + * The Original Code is Openbravo ERP. + * The Initial Developer of the Original Code is Openbravo SLU + * All portions are Copyright (C) 2014 Openbravo SLU + * All Rights Reserved. + * Contributor(s): ______________________________________. + ************************************************************************* + */ +package org.openbravo.advpaymentmngt.modulescript; + +import javax.servlet.ServletException; + +import org.openbravo.database.ConnectionProvider; +import org.openbravo.modulescript.ModuleScript; + +public class AlertsForWrongOrders extends ModuleScript { + + final static private String ALERT_RULE_SQL = "select distinct ad_column_identifier('C_Order', fin_payment_schedule.c_order_id, 'en_US') as record_id, fin_payment_schedule.c_order_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This order needs to be checked due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_order and fin_payment_scheduledetail.iscanceled = 'N' and fin_payment_scheduledetail.fin_payment_detail_id IS NOT NULL group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_order_id, fin_payment_schedule.paidamt having fin_payment_schedule.paidamt <> sum(fin_payment_scheduledetail. amount + coalesce(fin_payment_scheduledetail.writeoffamt,0)) order by 1"; + + @Override + // Inserting Alerts for orders which needs to be recalculated/processed + public void execute() { + try { + ConnectionProvider cp = getConnectionProvider(); + AlertsForWrongOrdersData[] data = AlertsForWrongOrdersData.select(cp); + for (AlertsForWrongOrdersData wrongOrder : data) { + createAlert(cp, wrongOrder); + } + } catch (Exception e) { + handleError(e); + } + } + + private void createAlert(ConnectionProvider cp, AlertsForWrongOrdersData wrongOrder) + throws ServletException { + final String SALES_ORDER_WINDOW = "143"; + final String PURCHASE_ORDER_WINDOW = "181"; + final String SALES_ORDER_TAB = "186"; + final String PURCHASE_ORDER_TAB = "294"; + String WindowOrderId = PURCHASE_ORDER_WINDOW; + String strTabId = PURCHASE_ORDER_TAB; + String ALERT_RULE = "Wrong Purchase Order Payment Plan"; + if ("Y".equals(wrongOrder.issotrx)) { + strTabId = SALES_ORDER_TAB; + WindowOrderId = SALES_ORDER_WINDOW; + ALERT_RULE = "Wrong Sales Order Payment Plan"; + } + String strName = "Order: '" + wrongOrder.orderinfo + + "' needs to be checked due to wrong payment info."; + String oldAlertRuleId = AlertsForWrongOrdersData.getAlertRuleId(cp, ALERT_RULE, + wrongOrder.adClientId); + if (!AlertsForWrongOrdersData.existsAlert(cp, oldAlertRuleId, wrongOrder.cOrderId)) { + if (!AlertsForWrongOrdersData.existsAlertRule(cp, ALERT_RULE, wrongOrder.adClientId)) { + AlertsForWrongOrdersData.insertAlertRule(cp, wrongOrder.adClientId, ALERT_RULE, strTabId, ALERT_RULE_SQL); + AlertsForWrongOrdersData[] roles = AlertsForWrongOrdersData.getRoleId(cp, + WindowOrderId, wrongOrder.adClientId); + for (AlertsForWrongOrdersData role : roles) { + AlertsForWrongOrdersData.insertAlertRecipient(cp, wrongOrder.adClientId, + wrongOrder.adOrgId, + AlertsForWrongOrdersData.getAlertRuleId(cp, ALERT_RULE, wrongOrder.adClientId), + role.adRoleId); + } + } + String alertRuleId = AlertsForWrongOrdersData.getAlertRuleId(cp, ALERT_RULE, + wrongOrder.adClientId); + AlertsForWrongOrdersData.insertAlert(cp, wrongOrder.adClientId, wrongOrder.adOrgId, + strName, alertRuleId, wrongOrder.orderinfo, wrongOrder.cOrderId); + } + } +} diff -r 3e03b90c27d7 -r 8d555b8cf67e modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrders_data.xsql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrders_data.xsql Tue May 20 15:36:45 2014 +0000 @@ -0,0 +1,137 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!-- + ************************************************************************************ + * Copyright (C) 2014 Openbravo S.L.U. + * Licensed under the Openbravo Commercial License version 1.0 + * You may obtain a copy of the License at http://www.openbravo.com/legal/obcl.html + * or in the legal folder of this module distribution. + ************************************************************************************ +--> +<SqlClass name="AlertsForWrongOrdersData" package="org.openbravo.advpaymentmngt.modulescript"> + <SqlClassComment></SqlClassComment> + <SqlMethod name="select" type="preparedStatement" return="multiple"> + <SqlMethodComment></SqlMethodComment> + <Sql> + <![CDATA[ + select distinct fin_payment_schedule.ad_client_id, ad_column_identifier('C_Order', fin_payment_schedule.c_order_id, 'en_US') as orderinfo, + fin_payment_schedule.c_order_id, fin_payment_schedule.ad_org_id, c_order.issotrx, '' as ad_role_id, '' as ad_alertrule_id, '' as ad_alert_id + from c_order, fin_payment_schedule, fin_payment_scheduledetail + where c_order.c_order_id = fin_payment_schedule.c_order_id + and fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_order + and fin_payment_scheduledetail.iscanceled = 'N' + and fin_payment_scheduledetail.fin_payment_detail_id IS NOT NULL + group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, c_order.issotrx, fin_payment_schedule.fin_payment_schedule_id, + fin_payment_schedule.c_order_id, fin_payment_schedule.paidamt + having fin_payment_schedule.paidamt <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt,0)) + order by 1, 2 + ]]> + </Sql> + </SqlMethod> + <SqlMethod name="existsAlertRule" type="preparedStatement" return="boolean"> + <SqlMethodComment></SqlMethodComment> + <Sql><![CDATA[ + SELECT COUNT(*) AS EXISTING + FROM AD_ALERTRULE + WHERE NAME = ? + AND ISACTIVE = 'Y' + AND AD_CLIENT_ID = ? + ]]> + </Sql> + <Parameter name="alertRule"/> + <Parameter name="client"/> + </SqlMethod> + <SqlMethod name="existsAlert" type="preparedStatement" return="boolean"> + <SqlMethodComment></SqlMethodComment> + <Sql><![CDATA[ + SELECT COUNT(*) AS EXISTING + FROM AD_ALERT + WHERE AD_ALERTRULE_ID = ? + AND REFERENCEKEY_ID = ? + AND ISFIXED = 'N' + ]]> + </Sql> + <Parameter name="alertRule"/> + <Parameter name="order"/> + </SqlMethod> + <SqlMethod name="getAlertRuleId" type="preparedStatement" return="string"> + <SqlMethodComment></SqlMethodComment> + <Sql><![CDATA[ + SELECT MAX(ad_alertrule_id) AS name + FROM AD_ALERTRULE + WHERE NAME LIKE ? + AND ISACTIVE = 'Y' + AND AD_CLIENT_ID = ? + ]]></Sql> + <Parameter name="name"/> + <Parameter name="client"/> + </SqlMethod> + <SqlMethod name="getRoleId" type="preparedStatement" return="multiple"> + <SqlMethodComment></SqlMethodComment> + <Sql><![CDATA[ + SELECT distinct ad_role_id + FROM ad_window_access + WHERE ad_window_id = ? + AND AD_CLIENT_ID = ? + AND ISACTIVE = 'Y' + ]]></Sql> + <Parameter name="window"/> + <Parameter name="clientId"/> + </SqlMethod> + <SqlMethod name="insertAlertRule" type="preparedStatement" return="rowcount"> + <SqlMethodComment></SqlMethodComment> + <Sql><![CDATA[ + INSERT INTO AD_ALERTRULE ( + AD_ALERTRULE_ID, AD_CLIENT_ID, AD_ORG_ID,ISACTIVE, + CREATED, CREATEDBY, UPDATED, UPDATEDBY, + NAME, AD_TAB_ID, FILTERCLAUSE, TYPE, + SQL + ) VALUES ( + get_uuid(), ?, '0', 'Y', + now(), '100', now(), '100', + ?, ?, '', 'D', + ? + ) + ]]></Sql> + <Parameter name="clientId"/> + <Parameter name="name"/> + <Parameter name="tabId"/> + <Parameter name="sql"/> + </SqlMethod> + <SqlMethod name="insertAlert" type="preparedStatement" return="rowcount"> + <SqlMethodComment></SqlMethodComment> + <Sql><![CDATA[ + INSERT INTO AD_Alert ( + AD_Alert_ID, AD_Client_ID, AD_Org_ID, IsActive, + Created, CreatedBy, Updated, UpdatedBy, + Description, AD_AlertRule_ID, Record_Id, Referencekey_ID + ) VALUES ( + get_uuid(), ?, ?, 'Y', + NOW(), '0', NOW(), '0', + ?, ?, ?, ?) + ]]> + </Sql> + <Parameter name="client"/> + <Parameter name="org"/> + <Parameter name="description" /> + <Parameter name="adAlertRuleId" /> + <Parameter name="recordId" /> + <Parameter name="referencekey_id" /> + </SqlMethod> + <SqlMethod name="insertAlertRecipient" type="preparedStatement" return="rowcount"> + <SqlMethodComment></SqlMethodComment> + <Sql><![CDATA[ + INSERT INTO ad_alertrecipient( + ad_user_id, ad_client_id, ad_org_id, isactive, created, createdby, + updated, updatedby, ad_alertrecipient_id, ad_alertrule_id, ad_role_id, + sendemail) + VALUES (null, ?, ?, 'Y', now(), '100', + now(), '100', get_uuid(), ?, ?, + 'N') + ]]> + </Sql> + <Parameter name="client"/> + <Parameter name="org"/> + <Parameter name="adAlertRuleId" /> + <Parameter name="role" /> + </SqlMethod> +</SqlClass> diff -r 3e03b90c27d7 -r 8d555b8cf67e modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrdersData.java --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongOrdersData.java Tue May 20 15:36:45 2014 +0000 @@ -0,0 +1,427 @@ +//Sqlc generated V1.O00-1 +package org.openbravo.advpaymentmngt.modulescript; + +import java.sql.*; + ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
