Toolbox

The XSQL Insert Update Review project aims to review the *.java files of all manual windows (processes) that have methods that insert or update records in the database.

Development evolution can also be tracked at xsql-insert-update-review branch.

Important notes:

The processes are grouped by the module they belong to but their review do not have to be made, necessarily, in the order listed below.
Files to be modified are the ones listed inside File path column (see how to obtain which file corresponds to each report). No other file different from these ones needs to be modified nor committed to the development branch.
Once a task has been accomplished, please change Status cell to complete with the link to the commit to the branch (as explained in Openbravo bug reporting guidelines):

| class="green_cell" | Complete

Application Dictionary

Process name	Application path	File path	Insert/Update methods	Comments	Status
Test In	Application Dictionary >> Automated Test >> Instructions	src/org/openbravo/erpCommon/ad_actionButton/Test_In.java	TestInData.insert() inside OBError processButton() method.	processButton() method type has been changed from string to OBError.	Complete

Master Data Management

Process name	Application path	File path	Insert/Update methods	Comments	Status
Import File Loader	Master Data Management >> Import Data >> Import File Loader	src/org/openbravo/erpCommon/ad_forms/FileImport.java	FileImportData.insert() inside OBError importarFichero() method. FileImportData.update() inside OBError importarFichero() method.		Complete

Procurement Management

Process name	Application path	File path	Insert/Update methods	Comments	Status
Copy Lines - Products From Invoices	Procurement Management >> Transactions >> Purchase Invoice Procurement Management >> Transactions >> Vendor Expense Invoice Procurement Management >> Transactions >> Expense Invoice Sales Management >> Transactions >> Sales Invoice Master Data Management >> Business Partner Setup >> Business Partner Info	src/org/openbravo/erpCommon/ad_actionButton/CopyFromInvoice.java	CopyFromInvoiceData.insert() inside OBError processButton() method.		Complete
Copy Lines - Products From History of Document Type	Procurement Management >> Transactions >> Purchase Order Sales Management >> Transactions >> Simple Sales Order Sales Management >> Transactions >> Sales Order Master Data Management >> Business Partner Setup >> Business Partner Info	src/org/openbravo/erpCommon/ad_actionButton/CopyFromOrder.java	CopyFromOrderData.insertCOrderline() inside OBError processButton() method.		Complete
Copy from Order	Procurement Management >> Transactions >> Purchase Order Sales Management >> Transactions >> Sales Order	src/org/openbravo/erpCommon/ad_actionButton/CopyFromPOOrder.java	CopyFromPOOrderData.insertCOrderline() inside OBError processButton() method.		Complete
Create Lines From	Procurement Management >> Transactions >> Goods Receipt Sales Management >> Transactions >> Goods Shipment Master Data Management >> Business Partner Setup >> Business Partner Info	src/org/openbravo/erpCommon/ad_actionButton/CreateFrom.java	CreateFromBankData.insert() inside OBError saveBank() method. CreateFromInvoiceData.insert() inside OBError saveInvoice() method. CreateFromInvoiceData.deleteC_Order_ID() inside OBError saveInvoice() method. CreateFromInvoiceData.updateC_Order_ID() inside OBError saveInvoice() method. CreateFromShipmentData.insert() inside OBError saveShipment() method. CreateFromShipmentData.updateInvoice() inside OBError saveShipment() method. CreateFromShipmentData.updateInvoiceOrder() inside OBError saveShipment() method. CreateFromShipmentData.deleteC_Order_ID() inside OBError saveShipment() method. CreateFromShipmentData.deleteC_Invoice_ID() inside OBError saveShipment() method. CreateFromShipmentData.updateC_Invoice_ID() inside OBError saveShipment() method. CreateFromSettlementData.update() inside OBError saveSettlement() method. CreateFromDPManagementData.insert() inside OBError saveDPManagement() method. CreateFromCRemittanceData.insert() inside OBError saveCRemittance() method.		Complete
Create From Multiple	Procurement Management >> Transactions >> Goods Receipt Sales Management >> Transactions >> Goods Shipment	src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple.java	CreateFromMultipleReceiptData.insert() inside OBError saveReceipt() method. CreateFromMultipleShipmentData.insert() inside OBError saveShipment() method.	invisible	Complete
Pending Goods Receipts	Procurement Management >> Transactions >> Pending Goods Receipts	src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending.java	MaterialReceiptPendingData.insert() inside OBError processPurchaseOrder() method. MaterialReceiptPendingLinesData.insert() inside OBError processPurchaseOrder method.		Complete
Requisition To Order	Procurement Management >> Transactions >> Matching PO-Receipt-Invoice	src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder.java	RequisitionToOrderData.insertCOrder() inside OBError processPurchaseOrder method. RequisitionToOrderData.insertCOrderline() inside OBError processPurchaseOrder method. RequisitionToOrderData.insertRequisitionOrder inside OBError processPurchaseOrder method.		Complete

Warehouse Management

Production Management

Process name	Application path	File path	Insert/Update methods	Comments	Status
Edit CCP Measured Values	Production Management >> Transactions >> Quality Control Report >> Date and Shift	src/org/openbravo/erpCommon/ad_actionButton/EditCCPMeasureValues.java	EditCCPMeasureValuesData.update() inside OBError updateValues() method.	updateValues() method type has been changed from void to OBError.	Complete
Create from Maintenance Part	Production Management >> Transactions >> Maintenance Order	src/org/openbravo/erpCommon/ad_actionButton/UpdateMaintenanceScheduled.java	UpdateMaintenanceScheduledData.update() inside String updateValues() method.	updateValues() method type has been changed from string to OBError.	Complete

Sales Management

Process name	Application path	File path	Insert/Update methods	Comments	Status
Change Order Organization	Sales Management >> Transactions >> Change Order Organization	src/org/openbravo/erpCommon/ad_process/ChangeOrderOrg.java	ChangeOrderOrgData.updateDocAction() inside OBError processSave() method. ChangeOrderOrgData.updateLines() inside OBError processSave() method. ChangeOrderOrgData.update() inside OBError processSave() method. ChangeOrderOrgData.updateDocAction() inside OBError processSave() method. ChangeOrderOrgData.updateShipment() inside OBError processSave() method. ChangeOrderOrgData.updateShipmentlines() inside OBError processSave() method. ChangeOrderOrgData.updateMtransaction() inside OBError processSave() method.		Complete

Project and Service Management

Process name	Application path	File path	Insert/Update methods	Comments	Status
Create Sales Orders from Expenses	Project & Service Management >> Transactions >> Create Sales Orders from Expenses	src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder.java	ExpenseSOrderData.insertCOrder() inside OBError processButton() method. ExpenseSOrderData.insertCOrderline() inside OBError processButton() method. PInstanceProcessData.insertPInstance() inside String processOrder() method. ExpenseSOrderData.updateTimeExpenseLine() inside OBError processButton() method.	processOrder() method type has been changed from String to OBError.	Complete
Create AP Expense Invoices	Project & Service Management >> Transactions >> Create AP Expense Invoices	src/org/openbravo/erpCommon/ad_process/ExpenseAPInvoice.java	ExpenseAPInvoiceData.insert() inside OBError processExpense() method. ExpenseAPInvoiceData.insertLine() inside OBError processExpense() method. ExpenseAPInvoiceData.insertInvoicelineAcctdimension() inside OBError processExpense() method. ExpenseAPInvoiceData.updateInvoiceline() inside OBError processExpense() method. ExpenseAPInvoiceData.updateAcctdimension() inside OBError processExpense() method. ExpenseAPInvoiceData.updateExpense() inside OBError processExpense() method.	processExpense() method type has been changed from void to OBError.	Complete
Close Project	Project & Service Management >> Transactions >> Multiphase Project Project & Service Management >> Transactions >> Service Project Financial Management >> Accounting >> Setup >> Accounting Dimension >> Project Dimension	src/org/openbravo/erpCommon/ad_actionButton/ProjectClose.java	ProjectCloseData.update() inside OBError processButton() method. ProjectCloseData.updateLines inside OBError processButton() method.	Invisible. ProcessButton() method type has been changed from string to OBError.	Complete
Copy Details From Existing Project	Project & Service Management >> Transactions >> Multiphase Project Project & Service Management >> Transactions >> Service Project Financial Management >> Accounting >> Setup >> Accounting Dimension >> Project Dimension	src/org/openbravo/erpCommon/ad_actionButton/ProjectCopyFrom.java	ProjectCopyFromData.insertProjectTask() inside OBError processButton() method. ProjectCopyFromData.insertProjectLine() inside OBError processButton() method. ProjectSetTypeData.update() inside OBError processButton() method.		Complete
Set Project Type	Project & Service Management >> Transactions >> Multiphase Project Project & Service Management >> Transactions >> Service Project	src/org/openbravo/erpCommon/ad_actionButton/ProjectSetType.java	ProjectSetTypeData.insertProjectTask() inside OBError processButton() method. ProjectSetTypeData.insertProjectLine() inside OBError processButton() method. ProjectSetTypeData.update inside OBError processButton() method.	Invisible.	Complete

Product Management

Financial Management

Process name	Application path	File path	Insert/Update methods	Comments	Status
Copy from Settlement	Financial Management >> Receivables & Payables >> Transactions >> Manual Settlement	src/org/openbravo/erpCommon/ad_actionButton/CopyFromSettlement.java	CopyFromSettlementData.insertDebtPayment() inside OBError processButton() method. CopyFromSettlementData.insert() inside OBError processButton() method.		Complete
Create Reg Fact Acct	Financial Management >> Accounting >> Setup >> Fiscal Calendar >> Calendar >> Year	src/org/openbravo/erpCommon/ad_actionButton/CreateRegFactAcct.java	CreateRegFactAcctData.updatePeriods() inside String processButton() method. CreateRegFactAcctData.updatePeriodsClose() inside String processButton() method. CreateRegFactAcctData.insert() inside String String processButtonReg() method. CreateRegFactAcctData.insertClose() inside String processButtonClose() method.	processButton() method type has been changed from String to OBError.	Complete
Drop Reg Fact Acct	Financial Management >> Accounting >> Setup >> Fiscal Calendar >> Calendar >> Year	src/org/openbravo/erpCommon/ad_actionButton/DropRegFactAcct.java	DropRegFactAcctData.updatePeriods() inside String processButtonReg() method. DropRegFactAcctData.deleteFactAcct() inside String processButtonReg() method. DropRegFactAcctData.updatePeriodsOpen() inside String processButtonClose() method. DropRegFactAcctData.updatePeriodsClose() inside String processButtonClose() method. DropRegFactAcctData.deleteFactAcctClose() inside String processButtonClose() method.		Complete
Create Vat Registers	Financial Management >> Receivables & Payables >> Transactions >> Tax Payment	src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters.java	TaxPayment.deleteRegisterLinesChild() inside OBError CreateRegisters() method. TaxPayment.deleteRegisterChild() inside OBError CreateRegisters() method. TaxRegister.insert() inside OBError CreateRegisters() method. TaxRegister.updateTaxTotalAmt() inside OBError CreateRegisters() method. TaxRegister.updateRegAccumAmt() inside OBError CreateRegisters() method. TaxPayment.updateGeneratePayment() inside OBError CreateRegisters() method.		Complete
Funds Transfer	Financial Management >> Receivables & Payables >> Transactions >> Funds Transfer	src/org/openbravo/erpCommon/ad_process/CashBankOperations.java	CashBankOperationsData.insertSettlement inside void process() method. CashBankOperationsData.insertDebtpayment inside void process() method. CashBankOperationsData.updateSettlement inside void process() method.	process() method type has been changed from void to OBError.	Complete
Copy Details From Journal Batch	Financial Management >> Accounting >> Transactions >> G/L Journal >> Batch	src/org/openbravo/erpCommon/ad_process/CopyFromGLJournal.java	CopyFromGLJournalData.insertGLJournal() inside OBError processButton() method. CopyFromGLJournalData.insertGLJournalLine()' inside OBError processButton() method.		Complete
Create Cash Flow Statement	Financial Management >> Accounting >> Analysis Tools >> Create Cash Flow Statement	src/org/openbravo/erpCommon/ad_process/CreateCashFlowStatement.java	CreateCashFlowStatementData.insertStatements() inside void insertCFS() method. CreateCashFlowStatementData.updateDifference()' inside void insertCFS() method.	added method OBError process()	Complete
Change Payment Status	Financial Management >> Receivables & Payables >> Transactions >> Change Payment Status	src/org/openbravo/erpCommon/ad_forms/DebtPaymentUnapply.java	DebtPaymentUnapplyData.updateGenerate() inside int updateSelection() method. DebtPaymentUnapplyData.updateCancel() inside int updateSelection() method.	updateSelection() method type has been changed from int to OBError.	Complete
Remittance Cancellation/Return	Financial Management >> Receivables & Payables >> Transactions >> Remittance Cancellation/Return	src/org/openbravo/erpCommon/ad_forms/RemittanceCancel.java	RemittanceCancelData.insertDPManagement() inside void processReturn() method. RemittanceCancelData.insertSettlement() inside void processCancel() method.	processReturn() and processCancel() methods type has been changed from void to OBError.	Complete

Retrieved from "http://wiki.openbravo.com/wiki/Projects:XSQL_Insert_Update_Review/Development_Status"

This page has been accessed 5,937 times. This page was last modified on 8 June 2012, at 05:31. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.

Toolbox

PDF Books

Search

Participate

Projects:XSQL Insert Update Review/Development Status

Contents

XSQL Insert Update Review - Development Status

Overview