def get_partners_huwknd(op_number):
"""
List of partner mentioning of OP in Huwknd table
"""
print("get_partners_huwknd()")
npartners = 0
partners = []
huwknd_qs = get_huwknd(op_number)
if huwknd_qs is None:
print("Huwknd does not contain partners for OP %d", op_number)
else:
nhuwknds = huwknd_qs.count()
print("Huwknd has %d entries for OP %s" % (nhuwknds, op_number))
for huwknd in huwknd_qs:
mar_date = "%02d/%02d/%04d" % (int(huwknd.hdag), int(huwknd.hmaand), int(huwknd.hjaar))
gebsex = huwknd.gebsex
if gebsex == 'm': # OP is man
partnersex = 'v'
familyname = huwknd.anmhv # familyname wife
firstname1 = huwknd.vrn1hv # firstname1 wife
firstname2 = huwknd.vrn2hv # firstname2 wife
firstname3 = huwknd.vrn3hv # firstname3 wife
elif gebsex == 'v': # OP is woman
partnersex = 'm'
familyname = huwknd.anmhm # familyname husband
firstname1 = huwknd.vrn1hm # firstname1 husband
firstname2 = huwknd.vrn2hm # firstname2 husband
firstname3 = huwknd.vrn3hm # firstname3 husband
if familyname is None: familyname = ""
if firstname1 is None: firstname1 = ""
if firstname2 is None: firstname2 = ""
if firstname3 is None: firstname3 = ""
fullname = familyname
fullname += ", "
fullname += firstname1
if firstname2 != "":
fullname += " "
fullname += firstname2
if firstname3 != "":
fullname += " "
fullname += firstname3
if gebsex == 'm' or gebsex == 'v':
partner = {
"mar_date": mar_date,
"sex": partnersex,
"fullname": fullname
}
npartners += 1
print("partner:", partner)
partners.append(partner)
print("Huwknd has %d partner entries for OP %s" % (npartners, op_number))
return partners
def get_marriages_huwknd(op_numstr):
print("hsn_manage/views/get_marriages_huwknd:", op_numstr)
marriages = []
# get marriage info info from Huwknd
huwknd_qs = get_huwknd(op_numstr)
if huwknd_qs is not None:
for huwknd in huwknd_qs:
mar_date = "%02d/%02d/%04d" % (int(huwknd.hdag), int(huwknd.hmaand), int(huwknd.hjaar))
# construct partner info
gebsex = huwknd.gebsex
if gebsex == 'm': # OP is man
partnersex = 'v'
familyname = huwknd.anmhv # familyname wife
firstname1 = huwknd.vrn1hv # firstname1 wife
firstname2 = huwknd.vrn2hv # firstname2 wife
firstname3 = huwknd.vrn3hv # firstname3 wife
elif gebsex == 'v': # OP is woman
partnersex = 'm'
familyname = huwknd.anmhm # familyname husband
firstname1 = huwknd.vrn1hm # firstname1 husband
firstname2 = huwknd.vrn2hm # firstname2 husband
firstname3 = huwknd.vrn3hm # firstname3 husband
if familyname is None: familyname = ""
if firstname1 is None: firstname1 = ""
if firstname2 is None: firstname2 = ""
if firstname3 is None: firstname3 = ""
fullname = familyname
fullname += ", "
fullname += firstname1
if firstname2 != "":
fullname += " "
fullname += firstname2
if firstname3 != "":
fullname += " "
fullname += firstname3
partner = ""
if gebsex == 'm' or gebsex == 'v':
partner = {
"sex": partnersex,
"familyname": familyname,
"firstname1": firstname1,
"firstname2": firstname2,
"firstname3": firstname3,
"fullname": fullname
}
print("partner:", partner)
mar = {"date": mar_date, "place": huwknd.hplts, "comment": "ingevoerd", "partner": partner}
print("marriage:", mar)
marriages.append(mar)
else:
print("Huwknd entry %s does not exist", op_numstr)
return marriages
