BiTel

public Map extractData( Connection con, int cid, DocumentPattern pattern, DocumentType type, DocumentJournal journal, Map<String, String> apiMap )
            throws BGException
    {
        ContractManager cm = new ContractManager(con);
      ContractParameterManager cpm = new ContractParameterManager(con);
        Contract contract = cm.getContractById(cid);
        Map<String, String> result = new HashMap<String, String>();

        //Получение параметров договора
        result.put("contractTitle", contract.getTitle());
        result.put("contractDate", TimeUtils.formatDate(contract.getDateFrom()));
        result.put("contractPassword", contract.getPswd());
      if(contract.getFc() == 0){
         result.put("fio", getContractParameterData(cpm.getStringParam(1)));
        }
      else if(contract.getFc() == 1){
         result.put("fio", getContractParameterData(cpm.getStringParam(2)));
        }
       
        return result;
    }

SELECT B.address FROM `object` A
JOIN `object_param_value_address` B ON A.id = B.object_id
WHERE A.cid = ${cid}
AND A.id = (SELECT val
            FROM `contract_parameter_type_1` P
            WHERE P.cid=A.cid
            AND P.pid=60)

SELECT B.value FROM `object` A
JOIN `object_param_value_date` B ON A.id = B.object_id
WHERE A.cid = ${cid}
AND B.param_id=7
AND A.id = (SELECT val
             FROM `contract_parameter_type_1` P
            WHERE P.cid=A.cid
            AND P.pid=60)

SELECT B.value FROM `object` A
JOIN `object_param_value_text` B ON A.id = B.object_id
WHERE A.cid = ${cid}
AND B.param_id=4
AND A.id = (SELECT val
             FROM `contract_parameter_type_1` P
             WHERE P.cid=A.cid
             AND P.pid=60)