Examples with MBPartnerLocation org.compiere.model.MBPartnerLocation used on opensource projects

Example 11 with MBPartnerLocation

use of org.compiere.model.MBPartnerLocation in project adempiere by adempiere.

the class CPOS method configureBPartner.

/**
	 * 	Set BPartner, update price list and locations
	 *  Configuration of Business Partner has priority over POS configuration
	 *	@param p_C_BPartner_ID id
	 */
/**
	 * set BPartner and save
	 */
public void configureBPartner(int partnerId) {
    //	Valid if has a Order
    if (isCompleted() || isVoided())
        return;
    log.fine("CPOS.setC_BPartner_ID=" + partnerId);
    boolean isSamePOSPartner = false;
    //	Validate BPartner
    if (partnerId == 0) {
        isSamePOSPartner = true;
        partnerId = entityPOS.getC_BPartnerCashTrx_ID();
    }
    //	Get BPartner
    partner = MBPartner.get(ctx, partnerId);
    if (partner == null || partner.get_ID() == 0) {
        throw new AdempierePOSException("POS.NoBPartnerForOrder");
    } else {
        log.info("CPOS.SetC_BPartner_ID -" + partner);
        currentOrder.setBPartner(partner);
        //	
        MBPartnerLocation[] partnerLocations = partner.getLocations(true);
        if (partnerLocations.length > 0) {
            for (MBPartnerLocation partnerLocation : partnerLocations) {
                if (partnerLocation.isBillTo())
                    currentOrder.setBill_Location_ID(partnerLocation.getC_BPartner_Location_ID());
                if (partnerLocation.isShipTo())
                    currentOrder.setShip_Location_ID(partnerLocation.getC_BPartner_Location_ID());
            }
        }
        //	Validate Same BPartner
        if (isSamePOSPartner) {
            if (currentOrder.getPaymentRule() == null)
                currentOrder.setPaymentRule(MOrder.PAYMENTRULE_Cash);
        }
        //	Set Sales Representative
        currentOrder.setSalesRep_ID(entityPOS.getSalesRep_ID());
        //	Save Header
        currentOrder.saveEx();
        //	Load Price List Version
        MPriceListVersion priceListVersion = loadPriceListVersion(currentOrder.getM_PriceList_ID());
        MProductPrice[] productPrices = priceListVersion.getProductPrice("AND EXISTS(" + "SELECT 1 " + "FROM C_OrderLine ol " + "WHERE ol.C_Order_ID = " + currentOrder.getC_Order_ID() + " " + "AND ol.M_Product_ID = M_ProductPrice.M_Product_ID)");
        //	Update Lines
        MOrderLine[] lines = currentOrder.getLines();
        //	Delete if not exist in price list
        for (MOrderLine line : lines) {
            //	Verify if exist
            if (existInPriceList(line.getM_Product_ID(), productPrices)) {
                line.setC_BPartner_ID(partner.getC_BPartner_ID());
                line.setC_BPartner_Location_ID(currentOrder.getC_BPartner_Location_ID());
                line.setPrice();
                line.setTax();
                line.saveEx();
            } else {
                line.deleteEx(true);
            }
        }
    }
}

Example 12 with MBPartnerLocation

use of org.compiere.model.MBPartnerLocation in project adempiere by adempiere.

the class WBPartner method actionSave.

//	loadBPartner
/**
	 *	Save.
	 *	Checks mandatory fields and saves Partner, Contact and Location
	 * 	@return true if saved
	 */
private boolean actionSave() {
    log.config("");
    //	Check Mandatory fields
    if (fName.getText().equals("")) {
        throw new WrongValueException(fName, Msg.translate(Env.getCtx(), "FillMandatory"));
    }
    if (fAddress.getC_Location_ID() == 0) {
        throw new WrongValueException(fAddress.getComponent(), Msg.translate(Env.getCtx(), "FillMandatory"));
    }
    if (m_partner == null) {
        int AD_Client_ID = Env.getAD_Client_ID(Env.getCtx());
        m_partner = MBPartner.getTemplate(Env.getCtx(), AD_Client_ID);
        // Elaine 2009/07/03
        m_partner.setAD_Org_ID(Env.getAD_Org_ID(Env.getCtx()));
        boolean isSOTrx = !"N".equals(Env.getContext(Env.getCtx(), m_WindowNo, "IsSOTrx"));
        m_partner.setIsCustomer(isSOTrx);
        m_partner.setIsVendor(!isSOTrx);
    }
    //	Check Value
    String value = fValue.getText();
    if (value == null || value.length() == 0) {
        //	get Table Document No
        value = DB.getDocumentNo(Env.getAD_Client_ID(Env.getCtx()), "C_BPartner", null);
        fValue.setText(value);
    }
    m_partner.setValue(fValue.getText());
    m_partner.setName(fName.getText());
    m_partner.setName2(fName2.getText());
    m_partner.setTaxID(fTaxId.getText());
    ListItem listitem = fGreetingBP.getSelectedItem();
    KeyNamePair p = listitem != null ? (KeyNamePair) listitem.getValue() : null;
    if (p != null && p.getKey() > 0)
        m_partner.setC_Greeting_ID(p.getKey());
    else
        m_partner.setC_Greeting_ID(0);
    if (m_partner.save())
        log.fine("C_BPartner_ID=" + m_partner.getC_BPartner_ID());
    else
        FDialog.error(m_WindowNo, this, "BPartnerNotSaved");
    if (m_pLocation == null)
        m_pLocation = new MBPartnerLocation(m_partner);
    m_pLocation.setC_Location_ID(fAddress.getC_Location_ID());
    m_pLocation.setEMail(fEMail.getText());
    m_pLocation.setPhone(fPhone.getText());
    m_pLocation.setPhone2(fPhone2.getText());
    m_pLocation.setFax(fFax.getText());
    if (m_pLocation.save())
        log.fine("C_BPartner_Location_ID=" + m_pLocation.getC_BPartner_Location_ID());
    else
        FDialog.error(m_WindowNo, this, "BPartnerNotSaved", Msg.translate(Env.getCtx(), "C_BPartner_Location_ID"));
    //	***** Business Partner - User *****
    String contact = fContact.getText();
    String email = fEMail.getText();
    if (m_user == null && (contact.length() > 0 || email.length() > 0))
        m_user = new MUser(m_partner);
    if (m_user != null) {
        if (contact.length() == 0)
            contact = fName.getText();
        m_user.setName(contact);
        m_user.setEMail(email);
        m_user.setTitle(fTitle.getText());
        listitem = fGreetingC.getSelectedItem();
        p = listitem != null ? (KeyNamePair) listitem.getValue() : null;
        if (p != null && p.getKey() > 0)
            m_user.setC_Greeting_ID(p.getKey());
        else
            m_user.setC_Greeting_ID(0);
        m_user.setPhone(fPhone.getText());
        m_user.setPhone2(fPhone2.getText());
        m_user.setFax(fFax.getText());
        if (m_user.save())
            log.fine("AD_User_ID=" + m_user.getAD_User_ID());
        else
            FDialog.error(m_WindowNo, this, "BPartnerNotSaved", Msg.translate(Env.getCtx(), "AD_User_ID"));
    }
    return true;
}

Example 13 with MBPartnerLocation

use of org.compiere.model.MBPartnerLocation in project adempiere by adempiere.

the class ImportInvoice method doIt.

//	prepare
/**
	 *  Perform 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;
    //	Delete Old Imported
    if (m_deleteOldImported) {
        sql = new StringBuffer("DELETE 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 = ' '," + " I_IsImported = 'N' " + "WHERE I_IsImported<>'Y' OR I_IsImported IS NULL");
    no = DB.executeUpdate(sql.toString(), get_TrxName());
    log.info("Reset=" + no);
    sql = new StringBuffer("UPDATE I_Invoice o " + "SET I_IsImported='E', I_ErrorMsg=I_ErrorMsg||'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=I_ErrorMsg||'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=I_ErrorMsg||'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=I_ErrorMsg||'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 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=I_ErrorMsg||'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);
    // globalqss - Add project and activity
    //	Project
    sql = new StringBuffer("UPDATE I_Invoice o " + "SET C_Project_ID=(SELECT C_Project_ID FROM C_Project p" + " WHERE o.ProjectValue=p.Value AND o.AD_Client_ID=p.AD_Client_ID) " + "WHERE C_Project_ID IS NULL AND ProjectValue IS NOT NULL AND I_IsImported<>'Y'").append(clientCheck);
    no = DB.executeUpdate(sql.toString(), get_TrxName());
    log.fine("Set Project=" + no);
    sql = new StringBuffer("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg=I_ErrorMsg||'ERR=Invalid Project, ' " + "WHERE C_Project_ID IS NULL AND (ProjectValue IS NOT NULL)" + " AND I_IsImported<>'Y'").append(clientCheck);
    no = DB.executeUpdate(sql.toString(), get_TrxName());
    if (no != 0)
        log.warning("Invalid Project=" + no);
    //	Activity
    sql = new StringBuffer("UPDATE I_Invoice o " + "SET C_Activity_ID=(SELECT C_Activity_ID FROM C_Activity p" + " WHERE o.ActivityValue=p.Value AND o.AD_Client_ID=p.AD_Client_ID) " + "WHERE C_Activity_ID IS NULL AND ActivityValue IS NOT NULL AND I_IsImported<>'Y'").append(clientCheck);
    no = DB.executeUpdate(sql.toString(), get_TrxName());
    log.fine("Set Activity=" + no);
    sql = new StringBuffer("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg=I_ErrorMsg||'ERR=Invalid Activity, ' " + "WHERE C_Activity_ID IS NULL AND (ActivityValue IS NOT NULL)" + " AND I_IsImported<>'Y'").append(clientCheck);
    no = DB.executeUpdate(sql.toString(), get_TrxName());
    if (no != 0)
        log.warning("Invalid Activity=" + no);
    // globalqss - add charge
    //	Charge
    sql = new StringBuffer("UPDATE I_Invoice o " + "SET C_Charge_ID=(SELECT C_Charge_ID FROM C_Charge p" + " WHERE o.ChargeName=p.Name AND o.AD_Client_ID=p.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=" + no);
    sql = new StringBuffer("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg=I_ErrorMsg||'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);
    //
    //	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 o.C_Region_ID=l.C_Region_ID AND o.C_Country_ID=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=I_ErrorMsg||'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);
    //	Set Country
    /**
		sql = new StringBuffer ("UPDATE I_Invoice o "
			  + "SET CountryCode=(SELECT MAX(CountryCode) FROM C_Country c WHERE c.IsDefault='Y'"
			  + " AND c.AD_Client_ID IN (0, o.AD_Client_ID)) "
			  + "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.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=I_ErrorMsg||'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=I_ErrorMsg||'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=I_ErrorMsg||'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);
    // globalqss - charge and product are exclusive
    sql = new StringBuffer("UPDATE I_Invoice " + "SET I_IsImported='E', I_ErrorMsg=I_ErrorMsg||'ERR=Product and Charge, ' " + "WHERE M_Product_ID IS NOT NULL AND C_Charge_ID IS NOT NULL " + " AND I_IsImported<>'Y'").append(clientCheck);
    no = DB.executeUpdate(sql.toString(), get_TrxName());
    if (no != 0)
        log.warning("Invalid Product and Charge exclusive=" + 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=I_ErrorMsg||'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);
    commitEx();
    //	-- 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];
                else //	Same Location ID
                if (imp.getC_Location_ID() == bpls[i].getC_Location_ID())
                    bpl = bpls[i];
                else //	Same Location Info
                if (imp.getC_Location_ID() == 0) {
                    MLocation loc = bpls[i].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() > 0 ? imp.getC_Location_ID() : loc.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=I_ErrorMsg||'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);
    commitEx();
    //	-- 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.saveEx();
                }
                //	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());
                invoice.setIsSOTrx(imp.isSOTrx());
                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());
                invoice.setC_PaymentTerm_ID(imp.getC_PaymentTerm_ID());
                invoice.setM_PriceList_ID(imp.getM_PriceList_ID());
                //	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());
                //ADEMPIERE-84
                if (imp.getInvoiceCollectionType() != null)
                    invoice.setInvoiceCollectionType(imp.getInvoiceCollectionType());
                if (imp.getDunningGrace() != null)
                    invoice.setDunningGrace(imp.getDunningGrace());
                if (imp.getC_DunningLevel_ID() != 0)
                    invoice.setC_DunningLevel_ID(imp.getC_DunningLevel_ID());
                //
                invoice.saveEx();
                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);
            // globalqss - import invoice with charges
            if (imp.getC_Charge_ID() != 0)
                line.setC_Charge_ID(imp.getC_Charge_ID());
            // globalqss - [2855673] - assign dimensions to lines also in case they're different 
            if (imp.getC_Activity_ID() != 0)
                line.setC_Activity_ID(imp.getC_Activity_ID());
            if (imp.getC_Campaign_ID() != 0)
                line.setC_Campaign_ID(imp.getC_Campaign_ID());
            if (imp.getC_Project_ID() != 0)
                line.setC_Project_ID(imp.getC_Project_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.saveEx();
            //
            imp.setC_InvoiceLine_ID(line.getC_InvoiceLine_ID());
            imp.setI_IsImported(true);
            imp.setProcessed(true);
            //
            if (imp.save())
                noInsertLine++;
        }
        if (invoice != null) {
            invoice.processIt(m_docAction);
            invoice.saveEx();
        }
        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 "";
}

Example 14 with MBPartnerLocation

use of org.compiere.model.MBPartnerLocation in project adempiere by adempiere.

the class MBPartnerLocationTest method testCreatePartnerLocation.

public void testCreatePartnerLocation() {
    try {
        location = new MLocation(getCtx(), 0, getTrxName());
        location.setC_Country_ID(getC_Country_ID("United States"));
        location.setC_Region_ID(getC_Region_ID("CA"));
        location.setCity("Windsor");
        location.setAddress1("Happy Lane");
        location.setAddress2("Happy Lane 2");
        String zipcode = ("95492");
        location.setPostal(zipcode);
        location.setPostal_Add(zipcode);
        location.setAD_Org_ID(0);
        location.saveEx();
        m_group = new MBPGroup(getCtx(), 0, getTrxName());
        // N
        m_group.setName("Test Group Name");
        // N
        m_group.setIsConfidentialInfo(false);
        m_group.setIsDefault(false);
        m_group.setPriorityBase(MBPGroup.PRIORITYBASE_Same);
        m_group.saveEx();
        m_partner = new MBPartner(getCtx(), 0, getTrxName());
        m_partner.setValue("");
        m_partner.setName("Test Business Partner Location");
        m_partner.setName2(null);
        m_partner.setDUNS("");
        m_partner.setFirstSale(null);
        //
        m_partner.setSO_CreditLimit(Env.ZERO);
        m_partner.setSO_CreditUsed(Env.ZERO);
        m_partner.setTotalOpenBalance(Env.ZERO);
        //      s_m_partner.setRating(null);
        //
        m_partner.setActualLifeTimeValue(Env.ZERO);
        m_partner.setPotentialLifeTimeValue(Env.ZERO);
        m_partner.setAcqusitionCost(Env.ZERO);
        m_partner.setShareOfCustomer(0);
        m_partner.setSalesVolume(0);
        m_partner.setBPGroup(m_group);
        // Reset Created, Updated to current system time ( teo_sarca )
        if (m_partner.save()) {
            bpl = new MBPartnerLocation(getCtx(), 0, getTrxName());
            bpl.setIsActive(true);
            bpl.setName("Test Business Partner Location");
            bpl.setC_BPartner_ID(m_partner.get_ID());
            bpl.setC_Location_ID(location.get_ID());
            bpl.saveEx();
        }
        commit();
    } catch (Exception e) {
        fail(e.getLocalizedMessage());
    }
}

Example 15 with MBPartnerLocation

use of org.compiere.model.MBPartnerLocation in project adempiere by adempiere.

the class Generator method generateSessionEquiv.

private void generateSessionEquiv(HttpServletCM thisServlet, HttpServletRequest httpRequest, Properties ctx) {
    xmlCode.append("<session>\n");
    HttpSession thisSession = httpRequest.getSession(false);
    if (thisSession != null) {
        if (thisSession.getAttribute(WebInfo.NAME) != null) {
            WebInfo wi = (WebInfo) thisSession.getAttribute(WebInfo.NAME);
            xmlCode.append("<WebInfo>\n");
            xmlCode.append("<Info><![CDATA[" + wi.getInfo() + "]]></Info>\n");
            if (wi.getUser_ID() > 0) {
                MUser thisUser = MUser.get(ctx, wi.getAD_User_ID());
                xmlCode = thisUser.get_xmlString(xmlCode);
                MBPartner thisBPartner = new MBPartner(ctx, wi.getC_BPartner_ID(), null);
                if (thisBPartner != null)
                    xmlCode = thisBPartner.get_xmlString(xmlCode);
                MBPartnerLocation thisBPartnerLocation = thisBPartner.getPrimaryC_BPartner_Location();
                if (thisBPartnerLocation != null)
                    xmlCode = thisBPartnerLocation.get_xmlString(xmlCode);
                MLocation thisLocation = MLocation.getBPLocation(ctx, thisBPartnerLocation.get_ID(), null);
                if (thisLocation != null)
                    xmlCode = thisLocation.get_xmlString(xmlCode);
                MBPBankAccount[] theseBPBankAccount = thisBPartner.getBankAccounts(true);
                if (theseBPBankAccount != null && theseBPBankAccount.length > 0)
                    for (int i = 0; i < theseBPBankAccount.length; i++) xmlCode = theseBPBankAccount[i].get_xmlString(xmlCode);
                if (thisSession.getAttribute("EMail") == null)
                    thisSession.setAttribute("EMail", thisUser.getEMail());
            }
            if (wi.getWebUser().getPasswordMessage() != null) {
                xmlCode.append("<PasswordMessage><![CDATA[" + wi.getWebUser().getPasswordMessage() + "]]></PasswordMessage>\n");
                wi.getWebUser().setPasswordMessage(null);
            }
            if (wi.getWebUser().getSaveErrorMessage() != null) {
                xmlCode.append("<SaveErrorMessage><![CDATA[" + wi.getWebUser().getSaveErrorMessage() + "]]></SaveErrorMessage>\n");
                wi.getWebUser().setSaveErrorMessage(null);
            }
            if (thisSession.getAttribute("hdrMessage") != null) {
                xmlCode.append("<hdrMessage><![CDATA[" + thisSession.getAttribute("hdrMessage") + "]]></hdrMessage>\n");
                thisSession.removeAttribute("hdrMessage");
            }
            xmlCode.append("<WebUser>\n");
            xmlCode.append("<LoggedIn>" + wi.getWebUser().isLoggedIn() + "</LoggedIn>\n");
            xmlCode.append("</WebUser>\n");
            xmlCode.append("</WebInfo>\n");
        }
        if (thisSession.getAttribute("EMail") != null)
            xmlCode.append("<EMail><![CDATA[" + thisSession.getAttribute("EMail") + "]]></EMail>\n");
    }
    xmlCode.append("</session>\n");
}