Explore

ImportInvoice.java

Index Score
		org.compiere.process
		Compiere

View: Reasons, Metrics, Source Code

These are the metrics that contribute to the Enerjy Score for this file, ranked by impact. So the metrics listed at the top influence the score to a greater extent that the metrics listed at the bottom.

Metric	Description
JAVA0034	JAVA0034 Missing braces in if statement
EXEC_COMMENTS	Comments in executable code
LINE_COMMENT	Number of line comments
EXITS	Procedure exits
SIZE	Size of the file in bytes
OPERANDS	Number of operands
ELOC	Effective lines of code
PROGRAM_LENGTH	Halstead program length
OPERATORS	Number of operators
UNIQUE_OPERANDS	Number of unique operands
LOC	Lines of code
COMPARISONS	Number of comparison operators
LOGICAL_LINES	Number of statements
PROGRAM_VOCAB	Halstead program vocabulary
JAVA0145	JAVA0145 Tab character used in source file
JAVA0119	JAVA0119 Control variable changed within body of for loop
JAVA0144	JAVA0144 Line exceeds maximum M characters
LINES	Number of lines in the source file
CYCLOMATIC	Cyclomatic complexity
JAVA0117	JAVA0117 Missing javadoc: method 'method'
NEST_DEPTH	Maximum nesting depth
PROGRAM_VOLUME	Halstead program volume
JAVA0126	JAVA0126 Method declares unchecked exception in throws
JAVA0285	JAVA0285 Dereference of potentially null variable
JAVA0110	JAVA0110 Incorrect javadoc: no @return tag
UNIQUE_OPERATORS	Number of unique operators
RETURNS	Number of return points from functions
INTERFACE_COMPLEXITY	Interface complexity
JAVA0108	JAVA0108 Incorrect javadoc: no @param tag for 'parameter'
FUNCTIONS	Number of function declarations
JAVA0003	JAVA0003 Minimize use of on-demand (.*) imports
BLOCKS	Number of blocks
PARAMS	Number of formal parameter declarations
WHITESPACE	Number of whitespace lines
JAVA0270	JAVA0270 Use Java 5.0 enhanced for loop construct to iterate over all elements in an array
DOC_COMMENT	Number of javadoc comment lines

/****************************************************************************** * Product: Compiere ERP & CRM Smart Business Solution * * Copyright (C) 1999-2007 ComPiere, Inc. All Rights Reserved. * * This program is free software, you can redistribute it and/or modify it * * under the terms version 2 of the GNU General Public License as published * * by the Free Software Foundation. This program is distributed in the hope * * that it will be useful, but WITHOUT ANY WARRANTY, without even the implied * * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. * * See the GNU General Public License for more details. * * You should have received a copy of the GNU General Public License along * * with this program, if not, write to the Free Software Foundation, Inc., * * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. * * For the text or an alternative of this public license, you may reach us * * ComPiere, Inc., 3600 Bridge Parkway #102, Redwood City, CA 94065, USA * * or via info@compiere.org or http://www.compiere.org/license.html * *****************************************************************************/ package org.compiere.process; import java.math.*; import java.sql.*; import java.util.logging.*; import org.compiere.model.*; import org.compiere.util.*; /** * Import Invoice from I_Invoice * * @author Jorg Janke * @version $Id: ImportInvoice.java,v 1.2 2006/07/30 00:51:01 jjanke Exp $ */ public class ImportInvoice extends SvrProcess { /** Client to be imported to */ private int m_AD_Client_ID = 0; /** Organization to be imported to */ private int m_AD_Org_ID = 0; /** Delete old Imported */ private boolean m_deleteOldImported = false; /** Document Action */ private String m_docAction = X_C_Invoice.DOCACTION_Prepare; /** Effective */ private Timestamp m_DateValue = null; /** * Prepare - e.g., get Parameters. */ protected void prepare() { ProcessInfoParameter[] para = getParameter(); for (int i = 0; i < para.length; i++) { String name = para[i].getParameterName(); if (name.equals("AD_Client_ID")) m_AD_Client_ID = ((BigDecimal)para[i].getParameter()).intValue(); else if (name.equals("AD_Org_ID")) m_AD_Org_ID = ((BigDecimal)para[i].getParameter()).intValue(); else if (name.equals("DeleteOldImported")) m_deleteOldImported = "Y".equals(para[i].getParameter()); else if (name.equals("DocAction")) m_docAction = (String)para[i].getParameter(); else log.log(Level.SEVERE, "Unknown Parameter: " + name); } if (m_DateValue == null) m_DateValue = new Timestamp (System.currentTimeMillis()); } // prepare /** * Perrform process. * @return clear Message * @throws Exception */ protected String doIt() throws java.lang.Exception { StringBuffer sql = null; int no = 0; String clientCheck = " AND AD_Client_ID=" + m_AD_Client_ID; // **** Prepare **** // Delete Old Imported if (m_deleteOldImported) { sql = new StringBuffer ("DELETE FROM I_Invoice " + "WHERE I_IsImported='Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Delete Old Impored =" + no); } // Set Client, Org, IsActive, Created/Updated sql = new StringBuffer ("UPDATE I_Invoice " + "SET AD_Client_ID = COALESCE (AD_Client_ID,").append (m_AD_Client_ID).append (")," + " AD_Org_ID = COALESCE (AD_Org_ID,").append (m_AD_Org_ID).append (")," + " IsActive = COALESCE (IsActive, 'Y')," + " Created = COALESCE (Created, SysDate)," + " CreatedBy = COALESCE (CreatedBy, 0)," + " Updated = COALESCE (Updated, SysDate)," + " UpdatedBy = COALESCE (UpdatedBy, 0)," + " I_ErrorMsg = NULL," + " I_IsImported = 'N' " + "WHERE I_IsImported<>'Y' OR I_IsImported IS NULL"); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.info ("Reset=" + no); String ts = DB.isPostgreSQL()?"COALESCE(I_ErrorMsg,'')":"I_ErrorMsg"; //java bug, it could not be used directly sql = new StringBuffer ("UPDATE I_Invoice o " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=Invalid Org, '" + "WHERE (AD_Org_ID IS NULL OR AD_Org_ID=0" + " OR EXISTS (SELECT * FROM AD_Org oo WHERE o.AD_Org_ID=oo.AD_Org_ID AND (oo.IsSummary='Y' OR oo.IsActive='N')))" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("Invalid Org=" + no); // Document Type - PO - SO sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_DocType_ID=(SELECT C_DocType_ID FROM C_DocType d WHERE d.Name=o.DocTypeName" + " AND d.DocBaseType IN ('API','APC') AND o.AD_Client_ID=d.AD_Client_ID) " + "WHERE C_DocType_ID IS NULL AND IsSOTrx='N' AND DocTypeName IS NOT NULL AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.fine("Set PO DocType=" + no); sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_DocType_ID=(SELECT C_DocType_ID FROM C_DocType d WHERE d.Name=o.DocTypeName" + " AND d.DocBaseType IN ('ARI','ARC') AND o.AD_Client_ID=d.AD_Client_ID) " + "WHERE C_DocType_ID IS NULL AND IsSOTrx='Y' AND DocTypeName IS NOT NULL AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.fine("Set SO DocType=" + no); sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_DocType_ID=(SELECT C_DocType_ID FROM C_DocType d WHERE d.Name=o.DocTypeName" + " AND d.DocBaseType IN ('API','ARI','APC','ARC') AND o.AD_Client_ID=d.AD_Client_ID) " //+ "WHERE C_DocType_ID IS NULL AND IsSOTrx IS NULL AND DocTypeName IS NOT NULL AND I_IsImported<>'Y'").append (clientCheck); + "WHERE C_DocType_ID IS NULL AND DocTypeName IS NOT NULL AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.fine("Set DocType=" + no); sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=Invalid DocTypeName, ' " + "WHERE C_DocType_ID IS NULL AND DocTypeName IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("Invalid DocTypeName=" + no); // DocType Default sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_DocType_ID=(SELECT MAX(C_DocType_ID) FROM C_DocType d WHERE d.IsDefault='Y'" + " AND d.DocBaseType='API' AND o.AD_Client_ID=d.AD_Client_ID) " + "WHERE C_DocType_ID IS NULL AND IsSOTrx='N' AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.fine("Set PO Default DocType=" + no); sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_DocType_ID=(SELECT MAX(C_DocType_ID) FROM C_DocType d WHERE d.IsDefault='Y'" + " AND d.DocBaseType='ARI' AND o.AD_Client_ID=d.AD_Client_ID) " + "WHERE C_DocType_ID IS NULL AND IsSOTrx='Y' AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.fine("Set SO Default DocType=" + no); sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_DocType_ID=(SELECT MAX(C_DocType_ID) FROM C_DocType d WHERE d.IsDefault='Y'" + " AND d.DocBaseType IN('ARI','API') AND o.AD_Client_ID=d.AD_Client_ID) " + "WHERE C_DocType_ID IS NULL AND IsSOTrx IS NULL AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.fine("Set Default DocType=" + no); sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=No DocType, ' " + "WHERE C_DocType_ID IS NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("No DocType=" + no); // Set IsSOTrx sql = new StringBuffer ("UPDATE I_Invoice o SET IsSOTrx='Y' " + "WHERE EXISTS (SELECT * FROM C_DocType d WHERE o.C_DocType_ID=d.C_DocType_ID AND d.DocBaseType='ARI' AND o.AD_Client_ID=d.AD_Client_ID)" + " AND C_DocType_ID IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set IsSOTrx=Y=" + no); sql = new StringBuffer ("UPDATE I_Invoice o SET IsSOTrx='N' " + "WHERE EXISTS (SELECT * FROM C_DocType d WHERE o.C_DocType_ID=d.C_DocType_ID AND d.DocBaseType='API' AND o.AD_Client_ID=d.AD_Client_ID)" + " AND C_DocType_ID IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set IsSOTrx=N=" + no); // Price List sql = new StringBuffer ("UPDATE I_Invoice o " + "SET M_PriceList_ID=(SELECT MAX(M_PriceList_ID) FROM M_PriceList p WHERE p.IsDefault='Y'" + " AND p.C_Currency_ID=o.C_Currency_ID AND p.IsSOPriceList=o.IsSOTrx AND o.AD_Client_ID=p.AD_Client_ID) " + "WHERE M_PriceList_ID IS NULL AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Default Currency PriceList=" + no); sql = new StringBuffer ("UPDATE I_Invoice o " + "SET M_PriceList_ID=(SELECT MAX(M_PriceList_ID) FROM M_PriceList p WHERE p.IsDefault='Y'" + " AND p.IsSOPriceList=o.IsSOTrx AND o.AD_Client_ID=p.AD_Client_ID) " + "WHERE M_PriceList_ID IS NULL AND C_Currency_ID IS NULL AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Default PriceList=" + no); sql = new StringBuffer ("UPDATE I_Invoice o " + "SET M_PriceList_ID=(SELECT MAX(M_PriceList_ID) FROM M_PriceList p " + " WHERE p.C_Currency_ID=o.C_Currency_ID AND p.IsSOPriceList=o.IsSOTrx AND o.AD_Client_ID=p.AD_Client_ID) " + "WHERE M_PriceList_ID IS NULL AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Currency PriceList=" + no); sql = new StringBuffer ("UPDATE I_Invoice o " + "SET M_PriceList_ID=(SELECT MAX(M_PriceList_ID) FROM M_PriceList p " + " WHERE p.IsSOPriceList=o.IsSOTrx AND o.AD_Client_ID=p.AD_Client_ID) " + "WHERE M_PriceList_ID IS NULL AND C_Currency_ID IS NULL AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set PriceList=" + no); // sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=No PriceList, ' " + "WHERE M_PriceList_ID IS NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning("No PriceList=" + no); // Payment Rule // We support Payment Rule being input in the login language Language language = Language.getLoginLanguage(); // Base Language String AD_Language = language.getAD_Language(); sql = new StringBuffer ("UPDATE I_Invoice O " + "SET PaymentRule= " + "(SELECT R.Value "+ " FROM AD_Ref_List R " + " left outer join AD_Ref_List_Trl RT " + " on RT.AD_Ref_List_ID = R.AD_Ref_List_ID and RT.AD_Language = ? " + " WHERE R.AD_Reference_ID = 195 and coalesce( RT.Name, R.Name ) = O.PaymentRuleName ) " + "WHERE PaymentRule is null AND PaymentRuleName IS NOT NULL AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), new Object[]{ AD_Language }, false, get_TrxName()); log.fine("Set PaymentRule=" + no); // do not set a default; if null, the import logic will derive from the business partner // do not error in absence of a default // Payment Term sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_PaymentTerm_ID=(SELECT C_PaymentTerm_ID FROM C_PaymentTerm p" + " WHERE o.PaymentTermValue=p.Value AND o.AD_Client_ID=p.AD_Client_ID) " + "WHERE C_PaymentTerm_ID IS NULL AND PaymentTermValue IS NOT NULL AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set PaymentTerm=" + no); sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_PaymentTerm_ID=(SELECT MAX(C_PaymentTerm_ID) FROM C_PaymentTerm p" + " WHERE p.IsDefault='Y' AND o.AD_Client_ID=p.AD_Client_ID) " + "WHERE C_PaymentTerm_ID IS NULL AND o.PaymentTermValue IS NULL AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Default PaymentTerm=" + no); // sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=No PaymentTerm, ' " + "WHERE C_PaymentTerm_ID IS NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("No PaymentTerm=" + no); // BP from EMail sql = new StringBuffer ("UPDATE I_Invoice o " + "SET (C_BPartner_ID,AD_User_ID)=(SELECT C_BPartner_ID,AD_User_ID FROM AD_User u" + " WHERE o.EMail=u.EMail AND o.AD_Client_ID=u.AD_Client_ID AND u.C_BPartner_ID IS NOT NULL) " + "WHERE C_BPartner_ID IS NULL AND EMail IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set BP from EMail=" + no); // BP from ContactName sql = new StringBuffer ("UPDATE I_Invoice o " + "SET (C_BPartner_ID,AD_User_ID)=(SELECT C_BPartner_ID,AD_User_ID FROM AD_User u" + " WHERE o.ContactName=u.Name AND o.AD_Client_ID=u.AD_Client_ID AND u.C_BPartner_ID IS NOT NULL) " + "WHERE C_BPartner_ID IS NULL AND ContactName IS NOT NULL" + " AND EXISTS (SELECT Name FROM AD_User u WHERE o.ContactName=u.Name AND o.AD_Client_ID=u.AD_Client_ID AND u.C_BPartner_ID IS NOT NULL GROUP BY Name HAVING COUNT(*)=1)" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set BP from ContactName=" + no); // BP from Value sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_BPartner_ID=(SELECT MAX(C_BPartner_ID) FROM C_BPartner bp" + " WHERE o.BPartnerValue=bp.Value AND o.AD_Client_ID=bp.AD_Client_ID) " + "WHERE C_BPartner_ID IS NULL AND BPartnerValue IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set BP from Value=" + no); // Default BP sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_BPartner_ID=(SELECT C_BPartnerCashTrx_ID FROM AD_ClientInfo c" + " WHERE o.AD_Client_ID=c.AD_Client_ID) " + "WHERE C_BPartner_ID IS NULL AND BPartnerValue IS NULL AND Name IS NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Default BP=" + no); // Existing Location ? Exact Match sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_BPartner_Location_ID=(SELECT C_BPartner_Location_ID" + " FROM C_BPartner_Location bpl INNER JOIN C_Location l ON (bpl.C_Location_ID=l.C_Location_ID)" + " WHERE o.C_BPartner_ID=bpl.C_BPartner_ID AND bpl.AD_Client_ID=o.AD_Client_ID" + " AND DUMP(o.Address1)=DUMP(l.Address1) AND DUMP(o.Address2)=DUMP(l.Address2)" + " AND DUMP(o.City)=DUMP(l.City) AND DUMP(o.Postal)=DUMP(l.Postal)" + " AND DUMP(o.C_Region_ID)=DUMP(l.C_Region_ID) AND DUMP(o.C_Country_ID)=DUMP(l.C_Country_ID)) " + "WHERE C_BPartner_ID IS NOT NULL AND C_BPartner_Location_ID IS NULL" + " AND I_IsImported='N'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Found Location=" + no); // Set Location from BPartner sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_BPartner_Location_ID=(SELECT MAX(C_BPartner_Location_ID) FROM C_BPartner_Location l" + " WHERE l.C_BPartner_ID=o.C_BPartner_ID AND o.AD_Client_ID=l.AD_Client_ID" + " AND ((l.IsBillTo='Y' AND o.IsSOTrx='Y') OR o.IsSOTrx='N')" + ") " + "WHERE C_BPartner_ID IS NOT NULL AND C_BPartner_Location_ID IS NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set BP Location from BP=" + no); // sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=No BP Location, ' " + "WHERE C_BPartner_ID IS NOT NULL AND C_BPartner_Location_ID IS NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("No BP Location=" + no); // Check for Duplicate Document Number/BP/Doc Type Combinations sql = new StringBuffer ("UPDATE I_Invoice i " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=Duplicate Document No, ' " + "WHERE EXISTS (SELECT 1 FROM C_Invoice inv WHERE inv.C_BPartner_ID=i.C_BPartner_ID " + " AND inv.C_DocTypeTarget_ID = i.C_DocType_ID" + " AND inv.DocumentNo = i.DocumentNo)" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("Duplicate Document Number=" + no); // Set Country /** sql = new StringBuffer ("UPDATE I_Invoice o " + "SET CountryCode=(SELECT CountryCode FROM C_Country c WHERE c.IsDefault='Y'" + " AND c.AD_Client_ID IN (0, o.AD_Client_ID) AND ROWNUM=1) " + "WHERE C_BPartner_ID IS NULL AND CountryCode IS NULL AND C_Country_ID IS NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Country Default=" + no); **/ sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_Country_ID=(SELECT C_Country_ID FROM C_Country c" + " WHERE o.CountryCode=c.CountryCode AND c.IsSummary='N' AND c.AD_Client_ID IN (0, o.AD_Client_ID)) " + "WHERE C_BPartner_ID IS NULL AND C_Country_ID IS NULL AND CountryCode IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Country=" + no); // sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=Invalid Country, ' " + "WHERE C_BPartner_ID IS NULL AND C_Country_ID IS NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("Invalid Country=" + no); // Set Region sql = new StringBuffer ("UPDATE I_Invoice o " + "Set RegionName=(SELECT MAX(Name) FROM C_Region r" + " WHERE r.IsDefault='Y' AND r.C_Country_ID=o.C_Country_ID" + " AND r.AD_Client_ID IN (0, o.AD_Client_ID)) " + "WHERE C_BPartner_ID IS NULL AND C_Region_ID IS NULL AND RegionName IS NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Region Default=" + no); // sql = new StringBuffer ("UPDATE I_Invoice o " + "Set C_Region_ID=(SELECT C_Region_ID FROM C_Region r" + " WHERE r.Name=o.RegionName AND r.C_Country_ID=o.C_Country_ID" + " AND r.AD_Client_ID IN (0, o.AD_Client_ID)) " + "WHERE C_BPartner_ID IS NULL AND C_Region_ID IS NULL AND RegionName IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Region=" + no); // sql = new StringBuffer ("UPDATE I_Invoice o " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=Invalid Region, ' " + "WHERE C_BPartner_ID IS NULL AND C_Region_ID IS NULL " + " AND EXISTS (SELECT * FROM C_Country c" + " WHERE c.C_Country_ID=o.C_Country_ID AND c.HasRegion='Y')" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("Invalid Region=" + no); // Product sql = new StringBuffer ("UPDATE I_Invoice o " + "SET M_Product_ID=(SELECT MAX(M_Product_ID) FROM M_Product p" + " WHERE o.ProductValue=p.Value AND o.AD_Client_ID=p.AD_Client_ID) " + "WHERE M_Product_ID IS NULL AND ProductValue IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Product from Value=" + no); sql = new StringBuffer ("UPDATE I_Invoice o " + "SET M_Product_ID=(SELECT MAX(M_Product_ID) FROM M_Product p" + " WHERE o.UPC=p.UPC AND o.AD_Client_ID=p.AD_Client_ID) " + "WHERE M_Product_ID IS NULL AND UPC IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Product from UPC=" + no); sql = new StringBuffer ("UPDATE I_Invoice o " + "SET M_Product_ID=(SELECT MAX(M_Product_ID) FROM M_Product p" + " WHERE o.SKU=p.SKU AND o.AD_Client_ID=p.AD_Client_ID) " + "WHERE M_Product_ID IS NULL AND SKU IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Product fom SKU=" + no); sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=Invalid Product, ' " + "WHERE M_Product_ID IS NULL AND (ProductValue IS NOT NULL OR UPC IS NOT NULL OR SKU IS NOT NULL)" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("Invalid Product=" + no); // Charge sql = new StringBuffer ("UPDATE I_Invoice i " + "SET C_Charge_ID=(SELECT MAX(C_Charge_ID) FROM C_Charge c" + " WHERE i.ChargeName=c.Name AND i.AD_Client_ID=c.AD_Client_ID) " + "WHERE C_Charge_ID IS NULL AND ChargeName IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Charge from Name=" + no); sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=Invalid Charge, ' " + "WHERE C_Charge_ID IS NULL AND (ChargeName IS NOT NULL)" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("Invalid Charge=" + no); sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=Both Charge and Product are specified, ' " + "WHERE C_Charge_ID IS NOT NULL AND M_Product_ID IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("Charge and Product are specified=" + no); // Tax sql = new StringBuffer ("UPDATE I_Invoice o " + "SET C_Tax_ID=(SELECT MAX(C_Tax_ID) FROM C_Tax t" + " WHERE o.TaxIndicator=t.TaxIndicator AND o.AD_Client_ID=t.AD_Client_ID) " + "WHERE C_Tax_ID IS NULL AND TaxIndicator IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); log.fine("Set Tax=" + no); sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=Invalid Tax, ' " + "WHERE C_Tax_ID IS NULL AND TaxIndicator IS NOT NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("Invalid Tax=" + no); commit(); // -- New BPartner --------------------------------------------------- // Go through Invoice Records w/o C_BPartner_ID sql = new StringBuffer ("SELECT * FROM I_Invoice " + "WHERE I_IsImported='N' AND C_BPartner_ID IS NULL").append (clientCheck); try { PreparedStatement pstmt = DB.prepareStatement (sql.toString(), get_TrxName()); ResultSet rs = pstmt.executeQuery (); while (rs.next ()) { X_I_Invoice imp = new X_I_Invoice (getCtx(), rs, get_TrxName()); if (imp.getBPartnerValue () == null) { if (imp.getEMail () != null) imp.setBPartnerValue (imp.getEMail ()); else if (imp.getName () != null) imp.setBPartnerValue (imp.getName ()); else continue; } if (imp.getName () == null) { if (imp.getContactName () != null) imp.setName (imp.getContactName ()); else imp.setName (imp.getBPartnerValue ()); } // BPartner MBPartner bp = MBPartner.get (getCtx(), imp.getBPartnerValue()); if (bp == null) { bp = new MBPartner (getCtx (), -1, get_TrxName()); bp.setClientOrg (imp.getAD_Client_ID (), imp.getAD_Org_ID ()); bp.setValue (imp.getBPartnerValue ()); bp.setName (imp.getName ()); if (!bp.save ()) continue; } imp.setC_BPartner_ID (bp.getC_BPartner_ID ()); // BP Location MBPartnerLocation bpl = null; MBPartnerLocation[] bpls = bp.getLocations(true); for (int i = 0; bpl == null && i < bpls.length; i++) { if (imp.getC_BPartner_Location_ID() == bpls[i].getC_BPartner_Location_ID()) bpl = bpls[i]; // Same Location ID else if (imp.getC_Location_ID() == bpls[i].getC_Location_ID()) bpl = bpls[i]; // Same Location Info else if (imp.getC_Location_ID() == 0) { MLocation loc = bpl.getLocation(false); if (loc.equals(imp.getC_Country_ID(), imp.getC_Region_ID(), imp.getPostal(), "", imp.getCity(), imp.getAddress1(), imp.getAddress2())) bpl = bpls[i]; } } if (bpl == null) { // New Location MLocation loc = new MLocation (getCtx (), 0, get_TrxName()); loc.setAddress1 (imp.getAddress1 ()); loc.setAddress2 (imp.getAddress2 ()); loc.setCity (imp.getCity ()); loc.setPostal (imp.getPostal ()); if (imp.getC_Region_ID () != 0) loc.setC_Region_ID (imp.getC_Region_ID ()); loc.setC_Country_ID (imp.getC_Country_ID ()); if (!loc.save ()) continue; // bpl = new MBPartnerLocation (bp); bpl.setC_Location_ID (imp.getC_Location_ID ()); if (!bpl.save ()) continue; } imp.setC_Location_ID (bpl.getC_Location_ID ()); imp.setC_BPartner_Location_ID (bpl.getC_BPartner_Location_ID ()); // User/Contact if (imp.getContactName () != null || imp.getEMail () != null || imp.getPhone () != null) { MUser[] users = bp.getContacts(true); MUser user = null; for (int i = 0; user == null && i < users.length; i++) { String name = users[i].getName(); if (name.equals(imp.getContactName()) || name.equals(imp.getName())) { user = users[i]; imp.setAD_User_ID (user.getAD_User_ID ()); } } if (user == null) { user = new MUser (bp); if (imp.getContactName () == null) user.setName (imp.getName ()); else user.setName (imp.getContactName ()); user.setEMail (imp.getEMail ()); user.setPhone (imp.getPhone ()); if (user.save ()) imp.setAD_User_ID (user.getAD_User_ID ()); } } imp.save (); } // for all new BPartners rs.close (); pstmt.close (); // } catch (SQLException e) { log.log(Level.SEVERE, "CreateBP", e); } sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg="+ts +"||'ERR=No BPartner, ' " + "WHERE C_BPartner_ID IS NULL" + " AND I_IsImported<>'Y'").append (clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); if (no != 0) log.warning ("No BPartner=" + no); commit(); // -- New Invoices ----------------------------------------------------- int noInsert = 0; int noInsertLine = 0; // Go through Invoice Records w/o sql = new StringBuffer ("SELECT * FROM I_Invoice " + "WHERE I_IsImported='N'").append (clientCheck) .append(" ORDER BY C_BPartner_ID, C_BPartner_Location_ID, I_Invoice_ID"); try { PreparedStatement pstmt = DB.prepareStatement (sql.toString(), get_TrxName()); ResultSet rs = pstmt.executeQuery (); // Group Change int oldC_BPartner_ID = 0; int oldC_BPartner_Location_ID = 0; String oldDocumentNo = ""; // MInvoice invoice = null; int lineNo = 0; while (rs.next ()) { X_I_Invoice imp = new X_I_Invoice (getCtx (), rs, null); String cmpDocumentNo = imp.getDocumentNo(); if (cmpDocumentNo == null) cmpDocumentNo = ""; // New Invoice if (oldC_BPartner_ID != imp.getC_BPartner_ID() || oldC_BPartner_Location_ID != imp.getC_BPartner_Location_ID() || !oldDocumentNo.equals(cmpDocumentNo) ) { if (invoice != null) { invoice.processIt(m_docAction); invoice.save(); } // Group Change oldC_BPartner_ID = imp.getC_BPartner_ID(); oldC_BPartner_Location_ID = imp.getC_BPartner_Location_ID(); oldDocumentNo = imp.getDocumentNo(); if (oldDocumentNo == null) oldDocumentNo = ""; // invoice = new MInvoice (getCtx(), 0, null); invoice.setClientOrg (imp.getAD_Client_ID(), imp.getAD_Org_ID()); invoice.setC_DocTypeTarget_ID(imp.getC_DocType_ID(), true); if (imp.getDocumentNo() != null) invoice.setDocumentNo(imp.getDocumentNo()); // invoice.setC_BPartner_ID(imp.getC_BPartner_ID()); invoice.setC_BPartner_Location_ID(imp.getC_BPartner_Location_ID()); if (imp.getAD_User_ID() != 0) invoice.setAD_User_ID(imp.getAD_User_ID()); // if (imp.getDescription() != null) invoice.setDescription(imp.getDescription()); if( imp.getPaymentRule() != null ) invoice.setPaymentRule( imp.getPaymentRule() ); invoice.setC_PaymentTerm_ID(imp.getC_PaymentTerm_ID()); invoice.setM_PriceList_ID(imp.getM_PriceList_ID()); MPriceList pl = MPriceList.get(getCtx(), imp.getM_PriceList_ID(), get_TrxName()); invoice.setIsTaxIncluded(pl.isTaxIncluded()); // SalesRep from Import or the person running the import if (imp.getSalesRep_ID() != 0) invoice.setSalesRep_ID(imp.getSalesRep_ID()); if (invoice.getSalesRep_ID() == 0) invoice.setSalesRep_ID(getAD_User_ID()); // if (imp.getAD_OrgTrx_ID() != 0) invoice.setAD_OrgTrx_ID(imp.getAD_OrgTrx_ID()); if (imp.getC_Activity_ID() != 0) invoice.setC_Activity_ID(imp.getC_Activity_ID()); if (imp.getC_Campaign_ID() != 0) invoice.setC_Campaign_ID(imp.getC_Campaign_ID()); if (imp.getC_Project_ID() != 0) invoice.setC_Project_ID(imp.getC_Project_ID()); // if (imp.getDateInvoiced() != null) invoice.setDateInvoiced(imp.getDateInvoiced()); if (imp.getDateAcct() != null) invoice.setDateAcct(imp.getDateAcct()); // invoice.save(); noInsert++; lineNo = 10; } imp.setC_Invoice_ID (invoice.getC_Invoice_ID()); // New InvoiceLine MInvoiceLine line = new MInvoiceLine (invoice); if (imp.getLineDescription() != null) line.setDescription(imp.getLineDescription()); line.setLine(lineNo); lineNo += 10; if (imp.getM_Product_ID() != 0) line.setM_Product_ID(imp.getM_Product_ID(), true); if (imp.getC_Charge_ID() != 0) line.setC_Charge_ID(imp.getC_Charge_ID()); line.setQty(imp.getQtyOrdered()); line.setPrice(); BigDecimal price = imp.getPriceActual(); if (price != null && Env.ZERO.compareTo(price) != 0) line.setPrice(price); if (imp.getC_Tax_ID() != 0) line.setC_Tax_ID(imp.getC_Tax_ID()); else { line.setTax(); imp.setC_Tax_ID(line.getC_Tax_ID()); } BigDecimal taxAmt = imp.getTaxAmt(); if (taxAmt != null && Env.ZERO.compareTo(taxAmt) != 0) line.setTaxAmt(taxAmt); line.save(); // imp.setC_InvoiceLine_ID(line.getC_InvoiceLine_ID()); imp.setI_IsImported(X_I_Invoice.I_ISIMPORTED_Yes); imp.setProcessed(true); // if (imp.save()) noInsertLine++; } if (invoice != null) { invoice.processIt (m_docAction); invoice.save(); } rs.close(); pstmt.close(); } catch (Exception e) { log.log(Level.SEVERE, "CreateInvoice", e); } // Set Error to indicator to not imported sql = new StringBuffer ("UPDATE I_Invoice " + "SET I_IsImported='N', Updated=SysDate " + "WHERE I_IsImported<>'Y'").append(clientCheck); no = DB.executeUpdate(sql.toString(), get_TrxName()); addLog (0, null, new BigDecimal (no), "@Errors@"); // addLog (0, null, new BigDecimal (noInsert), "@C_Invoice_ID@: @Inserted@"); addLog (0, null, new BigDecimal (noInsertLine), "@C_InvoiceLine_ID@: @Inserted@"); return ""; } // doIt } // ImportInvoice

The table below shows all metrics for ImportInvoice.java.

Metric	Value	Description
BLOCKS	24.00	Number of blocks
BLOCK_COMMENT	0.00	Number of block comment lines
COMMENTS	103.00	Comment lines
COMMENT_DENSITY	0.18	Comment density
COMPARISONS	84.00	Number of comparison operators
CYCLOMATIC	89.00	Cyclomatic complexity
DECL_COMMENTS	9.00	Comments in declarations
DOC_COMMENT	44.00	Number of javadoc comment lines
ELOC	562.00	Effective lines of code
EXEC_COMMENTS	58.00	Comments in executable code
EXITS	137.00	Procedure exits
FUNCTIONS	2.00	Number of function declarations
HALSTEAD_DIFFICULTY	88.11	Halstead difficulty
HALSTEAD_EFFORT	0.00	Halstead effort
INTERFACE_COMPLEXITY	2.00	Interface complexity
JAVA0001	0.00	JAVA0001 Package name does not contain only lower case letters
JAVA0002	0.00	JAVA0002 Package name does not begin with a top level domain name or country code
JAVA0003	1.00	JAVA0003 Minimize use of on-demand (.*) imports
JAVA0004	0.00	JAVA0004 Unnecessary import from java.lang
JAVA0005	0.00	JAVA0005 Imports not in specified order
JAVA0006	0.00	JAVA0006 Empty finally block
JAVA0007	0.00	JAVA0007 Should not declare public field
JAVA0008	0.00	JAVA0008 Empty catch block
JAVA0009	0.00	JAVA0009 Protected member in final class
JAVA0010	0.00	JAVA0010 Non-instantiable class does not contain a non-private static member
JAVA0011	0.00	JAVA0011 Abstract class does not contain an abstract method
JAVA0012	0.00	JAVA0012 Non-constructor method with same name as declaring class
JAVA0013	0.00	JAVA0013 Non-blank final field is not static
JAVA0014	0.00	JAVA0014 Class with only static members has non-private constructor
JAVA0015	0.00	JAVA0015 Package class contains public nested type
JAVA0016	0.00	JAVA0016 Abstract class contains public constructor
JAVA0017	0.00	JAVA0017 Class name does not have required form
JAVA0018	0.00	JAVA0018 Method name does not have required form
JAVA0019	0.00	JAVA0019 Interface name does not have required form
JAVA0020	0.00	JAVA0020 Field name does not have required form
JAVA0021	0.00	JAVA0021 Interface method name does not have required form
JAVA0022	0.00	JAVA0022 Static final field name does not have required form
JAVA0023	0.00	JAVA0023 Empty finalize method
JAVA0024	0.00	JAVA0024 Empty class
JAVA0025	0.00	JAVA0025 Method override is empty
JAVA0026	0.00	JAVA0026 Finalize method with parameters
JAVA0029	0.00	JAVA0029 Private method not used
JAVA0030	0.00	JAVA0030 Private field not used
JAVA0031	0.00	JAVA0031 Case statement not properly closed
JAVA0032	0.00	JAVA0032 Switch statement missing default
JAVA0033	0.00	JAVA0033 default: not last case in switch statement
JAVA0034	62.00	JAVA0034 Missing braces in if statement
JAVA0035	0.00	JAVA0035 Missing braces in for statement
JAVA0036	0.00	JAVA0036 Missing braces in while statement
JAVA0038	0.00	JAVA0038 Non-case label in switch statement
JAVA0039	0.00	JAVA0039 Break statement with label
JAVA0040	0.00	JAVA0040 Switch statement contains N cases (maximum: M)
JAVA0041	0.00	JAVA0041 Nested synchronized block
JAVA0042	0.00	JAVA0042 Empty synchronized statement
JAVA0043	0.00	JAVA0043 Inner class does not use outer class
JAVA0044	0.00	JAVA0044 Serializable class with no instance variables
JAVA0045	0.00	JAVA0045 Serializable class with only transient fields
JAVA0046	0.00	JAVA0046 Name of class not derived from Exception ends with 'Exception'
JAVA0047	0.00	JAVA0047 Serializable class derives from invalid base class
JAVA0048	0.00	JAVA0048 Name of class derived from Exception does not end with 'Exception'
JAVA0049	1.00	JAVA0049 Nested block at depth N (maximum: M)
JAVA0050	0.00	JAVA0050 Class derives from java.lang.Error
JAVA0051	0.00	JAVA0051 Class derives from java.lang.RuntimeException
JAVA0052	0.00	JAVA0052 Class derives from java.lang.Throwable
JAVA0053	0.00	JAVA0053 Unused label
JAVA0054	0.00	JAVA0054 Inheritance depth N exceeds maximum M
JAVA0055	0.00	JAVA0055 Class should be interface
JAVA0056	0.00	JAVA0056 Unnecessary abstract modifier for interface or annotation
JAVA0057	0.00	JAVA0057 Unnecessary default constructor
JAVA0058	0.00	JAVA0058 Constructor calls super()
JAVA0059	0.00	JAVA0059 Method override only calls super()
JAVA0061	0.00	JAVA0061 Inaccessible member in anonymous class
JAVA0062	0.00	JAVA0062 Public class missing public member or protected constructor
JAVA0063	0.00	JAVA0063 Identifier name should not contain '$'
JAVA0064	0.00	JAVA0064 N variations of identifier name (maximum: M)
JAVA0065	0.00	JAVA0065 Unnecessary final modifier for method in final class
JAVA0066	0.00	JAVA0066 Unnecessary modifier for interface nested type
JAVA0067	0.00	JAVA0067 Array descriptor on identifier name
JAVA0068	0.00	JAVA0068 Modifiers not declared in recommended order
JAVA0071	0.00	JAVA0071 Strings compared with ==
JAVA0073	0.00	JAVA0073 Integer division in floating-point context
JAVA0074	0.00	JAVA0074 Use of Object.notify()
JAVA0075	0.00	JAVA0075 Method parameter hides field
JAVA0076	2.00	JAVA0076 Use of magic number
JAVA0077	0.00	JAVA0077 Private field not used in declaring class
JAVA0078	0.00	JAVA0078 Floating point values compared with ==
JAVA0079	0.00	JAVA0079 Use of instance to reference static member
JAVA0080	0.00	JAVA0080 Import declaration not used
JAVA0081	0.00	JAVA0081 Boolean literal in comparison
JAVA0082	0.00	JAVA0082 Unnecessary widening cast
JAVA0083	0.00	JAVA0083 Unnecessary instanceof test
JAVA0084	0.00	JAVA0084 Should use compound assignment operator
JAVA0085	0.00	JAVA0085 Use of sun.* class
JAVA0087	0.00	JAVA0087 Use of Thread.sleep()
JAVA0089	0.00	JAVA0089 Use of restricted package
JAVA0092	0.00	JAVA0092 Use of restricted type
JAVA0093	0.00	JAVA0093 Redundant assignment
JAVA0094	0.00	JAVA0094 Field hides a superclass field
JAVA0095	0.00	JAVA0095 Uninitialized private field
JAVA0096	0.00	JAVA0096 Field in nested class hides outer field
JAVA0098	0.00	JAVA0098 Minimize use of implicit field initializers
JAVA0100	0.00	JAVA0100 Class contains N non-final fields (maximum: M)
JAVA0101	0.00	JAVA0101 Unnecessary modifier for field in interface
JAVA0102	0.00	JAVA0102 Last statement in finalize() not super.finalize()
JAVA0103	0.00	JAVA0103 Explicit call to finalize()
JAVA0104	0.00	JAVA0104 finalize() only calls super.finalize()
JAVA0105	0.00	JAVA0105 Duplicate import declaration
JAVA0106	0.00	JAVA0106 Unnecessary import from current package
JAVA0108	0.00	JAVA0108 Incorrect javadoc: no @param tag for 'parameter'
JAVA0109	0.00	JAVA0109 Incorrect javadoc: no parameter 'parameter'
JAVA0110	0.00	JAVA0110 Incorrect javadoc: no @return tag
JAVA0111	0.00	JAVA0111 Incorrect javadoc: @return tag for void method
JAVA0112	0.00	JAVA0112 Incorrect javadoc: no exception 'exception' in throws
JAVA0113	0.00	JAVA0113 Incorrect javadoc: no @author tag
JAVA0114	0.00	JAVA0114 Incorrect javadoc: no @version tag
JAVA0115	0.00	JAVA0115 Incorrect javadoc: no @throws or @exception tag for 'exception'
JAVA0116	0.00	JAVA0116 Missing javadoc: field 'field'
JAVA0117	0.00	JAVA0117 Missing javadoc: method 'method'
JAVA0118	0.00	JAVA0118 Missing javadoc: type 'type'
JAVA0119	4.00	JAVA0119 Control variable changed within body of for loop
JAVA0123	0.00	JAVA0123 Use all three components of for loop
JAVA0125	0.00	JAVA0125 Continue statement with label
JAVA0126	0.00	JAVA0126 Method declares unchecked exception in throws
JAVA0128	0.00	JAVA0128 Public constructor in non-public class
JAVA0130	0.00	JAVA0130 Non-static method does not use instance fields
JAVA0131	0.00	JAVA0131 Compatible method does not override base
JAVA0132	0.00	JAVA0132 Method overload with compatible signature
JAVA0133	0.00	JAVA0133 Non-synchronized method overrides synchronized method
JAVA0135	0.00	JAVA0135 Only one of Object.equals and Object.hashCode defined: missing 'method'
JAVA0136	0.00	JAVA0136 N methods defined in class (maximum: M)
JAVA0137	0.00	JAVA0137 Non-abstract class missing constructor
JAVA0138	0.00	JAVA0138 N parameters defined for method (maximum: M)
JAVA0139	0.00	JAVA0139 Definition of main other than public static void main(java.lang.String[])
JAVA0141	0.00	JAVA0141 Unnecessary modifier for method in interface
JAVA0143	0.00	JAVA0143 Synchronized method
JAVA0144	6.00	JAVA0144 Line exceeds maximum M characters
JAVA0145	2336.00	JAVA0145 Tab character used in source file
JAVA0150	0.00	JAVA0150 java.lang.Error (or subclass) thrown
JAVA0153	0.00	JAVA0153 Inefficient conversion of integer to string
JAVA0159	0.00	JAVA0159 Inefficient conversion of string to integer
JAVA0160	0.00	JAVA0160 Method does not throw specified exception
JAVA0161	0.00	JAVA0161 Conditional wait() not in loop
JAVA0163	0.00	JAVA0163 Empty statement
JAVA0165	0.00	JAVA0165 Conflicting return statement in finally block
JAVA0166	1.00	JAVA0166 Generic exception caught
JAVA0167	0.00	JAVA0167 ThreadDeath not rethrown
JAVA0169	0.00	JAVA0169 Unnecessary catch block: exception 'exception'
JAVA0170	0.00	JAVA0170 Caught exception not derived from java.lang.Exception
JAVA0171	0.00	JAVA0171 Unused local variable
JAVA0173	0.00	JAVA0173 Unused method parameter
JAVA0174	0.00	JAVA0174 Assigned local variable never used
JAVA0175	0.00	JAVA0175 Successive assignment to variable
JAVA0176	0.00	JAVA0176 Local variable name does not have required form
JAVA0177	0.00	JAVA0177 Variable declaration missing initializer
JAVA0179	0.00	JAVA0179 Local variable hides visible field
JAVA0233	0.00	JAVA0233 Definition of serialVersionUID other than 'private static final long serialVersionUID'
JAVA0234	0.00	JAVA0234 Class is Serializable but does not define serialVersionUID
JAVA0235	0.00	JAVA0235 Class defines serialVersionUID but does not implement Serializable
JAVA0236	0.00	JAVA0236 Attempt to clone an object which does not implement Cloneable
JAVA0237	0.00	JAVA0237 Class implements Cloneable but does not have public clone method
JAVA0238	0.00	JAVA0238 Clone method does not call super.clone()
JAVA0239	0.00	JAVA0239 Class declares 'readObject' or 'writeObject' but does not implement Serializable
JAVA0240	0.00	JAVA0240 Serializable class which declares readObject or writeObject but not both
JAVA0241	0.00	JAVA0241 'readObject' or 'writeObject' should be declared private in Serializable class
JAVA0242	0.00	JAVA0242 Transient field in non-Serializable class
JAVA0243	0.00	JAVA0243 'readResolve' or 'writeReplace' should be declared private or protected
JAVA0244	0.00	JAVA0244 Field or method name in subclass differs only by case from inherited field or method
JAVA0245	0.00	JAVA0245 JUnit TestCase with non-trivial constructor
JAVA0246	0.00	JAVA0246 JUnit assertXXX statement missing message parameter
JAVA0247	0.00	JAVA0247 JUnit 'setUp()' and 'tearDown()' should call super method
JAVA0248	0.00	JAVA0248 JUnit method 'setUp' or 'tearDown' with incorrect signature
JAVA0249	0.00	JAVA0249 JUnit TestCase 'suite()' should be declared static
JAVA0250	0.00	JAVA0250 JUnit TestCase declares testXXX method with incorrect signature
JAVA0251	0.00	JAVA0251 Use '%n' for line breaks in printf/format for platform independence
JAVA0252	0.00	JAVA0252 'enum' is a Java 1.5 reserved word
JAVA0253	0.00	JAVA0253 Not all enum constants consumed in switch statement
JAVA0254	0.00	JAVA0254 Use enhanced for loop construct instead of Iterator
JAVA0255	0.00	JAVA0255 Result of method invocation not used
JAVA0256	0.00	JAVA0256 Assignment of external collection/array to field
JAVA0257	0.00	JAVA0257 Use of 'Constant Interface' anti-pattern
JAVA0258	0.00	JAVA0258 Implement Iterable for foreach compatibility
JAVA0259	0.00	JAVA0259 Return of collection/array field
JAVA0260	0.00	JAVA0260 Use 'enum' instead of Enumerated Type pattern
JAVA0261	0.00	JAVA0261 Use specialized Enum collection types
JAVA0262	0.00	JAVA0262 Use of char in integer context
JAVA0263	0.00	JAVA0263 Long literal ends with 'l' instead of 'L'
JAVA0264	0.00	JAVA0264 Integer math in long context - check for overflow
JAVA0265	0.00	JAVA0265 Use of Throwable.printStackTrace()
JAVA0266	0.00	JAVA0266 Use of System.out
JAVA0267	0.00	JAVA0267 Use of System.err
JAVA0269	0.00	JAVA0269 Contents of StringBuffer never used
JAVA0270	1.00	JAVA0270 Use Java 5.0 enhanced for loop construct to iterate over all elements in an array
JAVA0271	0.00	JAVA0271 Minimize use of on-demand (.*) static imports
JAVA0272	0.00	JAVA0272 Thread.run() called
JAVA0273	0.00	JAVA0273 Non-final derivative of Thread calls start() in constructor
JAVA0274	0.00	JAVA0274 Serializable class has a synchronized readObject()
JAVA0275	0.00	JAVA0275 Serializable class has a synchronized writeObject() and no other synchronized methods
JAVA0276	0.00	JAVA0276 Unnecessary use of String constructor
JAVA0277	0.00	JAVA0277 Iterator.next() implementation does not throw NoSuchElementException
JAVA0278	0.00	JAVA0278 Unnecessary use of Boolean constructor
JAVA0279	0.00	JAVA0279 Serialization method readObject or readObjectNoData calls an overridable method
JAVA0280	0.00	JAVA0280 IllegalMonitorStateException caught
JAVA0281	0.00	JAVA0281 Iterator.next() not called in loop
JAVA0282	0.00	JAVA0282 Call to Iterator.next() in loop which does not test Iterator.hasNext()
JAVA0283	0.00	JAVA0283 Control variable not updated in loop body
JAVA0284	0.00	JAVA0284 Explicit garbage collection
JAVA0285	1.00	JAVA0285 Dereference of potentially null variable
JAVA0286	1.00	JAVA0286 Dereference of null variable
JAVA0287	0.00	JAVA0287 Unnecessary null check
JAVA0288	0.00	JAVA0288 Inconsistent null check
LINES	753.00	Number of lines in the source file
LINE_COMMENT	59.00	Number of line comments
LOC	608.00	Lines of code
LOGICAL_LINES	293.00	Number of statements
LOOPS	5.00	Number of loops
NEST_DEPTH	6.00	Maximum nesting depth
OPERANDS	1655.00	Number of operands
OPERATORS	2846.00	Number of operators
PARAMS	0.00	Number of formal parameter declarations
PROGRAM_LENGTH	4501.00	Halstead program length
PROGRAM_VOCAB	478.00	Halstead program vocabulary
PROGRAM_VOLUME	0.00	Halstead program volume
RETURNS	2.00	Number of return points from functions
SIZE	33440.00	Size of the file in bytes
UNIQUE_OPERANDS	432.00	Number of unique operands
UNIQUE_OPERATORS	46.00	Number of unique operators
WHITESPACE	42.00	Number of whitespace lines

Enerjy

Explore.

ImportInvoice.java