org.notima.generic.adempiere.factory.IDempiereAptMapper Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of adempiereAdapter Show documentation

Adapter that connects directly to ADempiere database.

The newest version!

package org.notima.generic.adempiere.factory;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Calendar;
import java.sql.Date;

import javax.sql.DataSource;

import org.notima.generic.businessobjects.BusinessPartner;
import org.notima.generic.businessobjects.Location;
import org.notima.generic.businessobjects.TaxSubjectIdentifier;
import org.notima.generic.ifacebusinessobjects.MappingService;

public class IDempiereAptMapper implements MappingService {

	private DataSource ds;
	private int		   orgId;
	
	public IDempiereAptMapper(DataSource ds, int orgId) {
		
		this.ds = ds;
		this.orgId = orgId;
		
	}
	
	@Override
	public TaxSubjectIdentifier mapApartmentNoToTaxSubject(String aptNo) {

		//TODO Lookup country code
		
		String query = "select bp.taxid as taxid from xs_contract_part cp " + 
				"join c_bpartner bp on (cp.c_bpartner_id=bp.c_bpartner_id) " + 
				"join xs_contract c on (cp.xs_contract_id=c.xs_contract_id) " + 
				"join xs_rentalobject ro on (c.xs_rentalobject_id=ro.xs_rentalobject_id) " + 
				"where ro.object_key=? and c.ad_org_id=? and c.isactive='Y' and cp.isactive='Y' " + 
				"AND (c.end_date IS NULL OR c.end_date>=?) " + 
				"AND cp.contract_role = 'B' order by cp.share desc limit 1";
		
		
		Date untilDate = new java.sql.Date(Calendar.getInstance().getTimeInMillis());

		String result = null;
		
		try {
		
			Connection conn = ds.getConnection();
			PreparedStatement ps = conn.prepareStatement(query);
			ps.setString(1, aptNo);
			ps.setInt(2, orgId);
			ps.setDate(3, untilDate);
			ResultSet rs = ps.executeQuery();
			if (rs.next()) {
				result = rs.getString(1);
			}
			rs.close();
			ps.close();
			conn.close();
			
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		return new TaxSubjectIdentifier(result);
		
	}

	@Override
	public BusinessPartner mapLocationToBusinessPartner(Location location, String aptNo) {
		// TODO Auto-generated method stub
		return null;
	}

}