process.js

import("system.logging");
import("Relation_lib");
import("Sql_lib");
import("system.db");

/**
 * Methods for adresses.
 * Todo: evtl. übernahme / anpassung der Adresslib aus altem Basic. 1030856
 * 
 * Do not create an instance of this!
 * 
 * @class
 */
function AddressUtils() {}
   
/**
 * Returns the formatted standard address for the relation.
 * 
 * TODO: Dummy method! Übernahme der Adresslib aus altem Basic
 * 
 * @return {String}
 */
AddressUtils.getAddress = function(pRelationId) {
    var address = db.array(db.ROW, SqlCondition.begin().andPrepare("RELATION.RELATIONID", pRelationId).buildSelect('select RELATIONID, ADDRESS, BUILDINGNO, ZIP, CITY, "NAME", FIRSTNAME, LASTNAME, TITLE from' + RelationUtils.getFullRelationFromString(), "1=0"));
    
    // TODO: currently there are some relations without standard address. Use Hardcoded one.
    if (!address[1]) {
        var dummyAddress = db.array(db.ROW, SqlCondition.begin().andPrepare("ADDRESS.ADDRESSID", '97d37aea-d7f8-4436-bb31-875439f5f7f1').buildSelect('select ADDRESS, BUILDINGNO, ZIP, CITY from ADDRESS', "1=0"));
        address[1] = dummyAddress[0];
        address[2] = dummyAddress[1];
        address[3] = dummyAddress[2];
        address[4] = dummyAddress[3];
        
    }
    var type = RelationUtils.getRelationTypeByRelation(pRelationId);
    
    var resultAddr = "";
    // 1 if organisation <br>
    // 2 if privat person <br>
    // 3 if person of an organisation <br>*/
    switch (type) 
    {
        case 1:
            resultAddr = address[5] + "\n" + address[1] + " " + address[2] + "\n" + address[3] + " " + address[4];
            break;
        case 2:
            resultAddr = address[8] + " " + address[6] + " " + address[7] + "\n" + address[1] + " " + address[2] + "\n" + address[3] + " " + address[4];
            break;
        case 3:
            resultAddr = address[5] + "\n" + address[6] + " " + address[7] + "\n" + address[1] + " " + address[2] + "\n" + address[3] + " " + address[4];
            break;
    }
    
    return resultAddr;
}

/**
 * Returns a letter salutation.
 * 
 * TODO: Dummy method! Übernahme der Adresslib aus altem Basic
 * 
 * @return {String}
 */
AddressUtils.getLetterSalutation = function() {
    return "Sehr geehrte Damen und Herren";
}