- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
for (Tm_RecipientConstructor recipient: m_Recipients) {
Tm_PHB_Contact m_Contact = recipient.getContact();
if ( m_Contact != null) {
if(m_Contact.getMobile()!=null) {
st.setLong(1,recipient.getEntry().getID());//nWebEntryID
st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
st.setString(3,"mobile");//STRNAME
st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
st.setString(5,m_Contact.getMobile());//STRVALUE
st.addBatch();
index++;
if (index % 5000 == 0){
st.executeBatch();
st.clearBatch();
st = conn.prepareStatement(sql);
}
}
if(m_Contact.getName()!=null) {
st.setLong(1,recipient.getEntry().getID());//nWebEntryID
st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
st.setString(3,"first_name");//STRNAME
st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
st.setString(5,m_Contact.getName());//STRVALUE
st.addBatch();
index++;
if (index % 5000 == 0){
st.executeBatch();
st.clearBatch();
st = conn.prepareStatement(sql);
}
}
if(m_Contact.getSurName()!=null) {
st.setLong(1,recipient.getEntry().getID());//nWebEntryID
st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
st.setString(3,"last_name");//STRNAME
st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
st.setString(5,m_Contact.getSurName());//STRVALUE
st.addBatch();
index++;
if (index % 5000 == 0){
st.executeBatch();
st.clearBatch();
st = conn.prepareStatement(sql);
}
}
if(m_Contact.getPatrName()!=null) {
st.setLong(1,recipient.getEntry().getID());//nWebEntryID
st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
st.setString(3,"second_name");//STRNAME
st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
st.setString(5,m_Contact.getPatrName());//STRVALUE
st.addBatch();
index++;
if (index % 5000 == 0){
st.executeBatch();
st.clearBatch();
st = conn.prepareStatement(sql);
}
}
if(m_Contact.getCompanyName()!=null) {
st.setLong(1,recipient.getEntry().getID());//nWebEntryID
st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
st.setString(3,"company");//STRNAME
st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
st.setString(5,m_Contact.getCompanyName());//STRVALUE
st.addBatch();
index++;
if (index % 5000 == 0){
st.executeBatch();
st.clearBatch();
st = conn.prepareStatement(sql);
}
}
if(m_Contact.getComment()!=null) {
st.setLong(1,recipient.getEntry().getID());//nWebEntryID
st.setLong(2,Tm_Registry.getInstance().getAttachementTypes().getID(En_AttachementType.ARGUMENT));//NTYPE
st.setString(3,"comments");//STRNAME
st.setLong(4,Tm_Registry.getInstance().getAttributeType().getID(En_AttributeType.STRING));//NDATATYPE
st.setString(5,m_Contact.getComment());//STRVALUE
st.addBatch();
index++;
if (index % 5000 == 0){
st.executeBatch();
st.clearBatch();
st = conn.prepareStatement(sql);
}
}
}
}