1 2 3 4 5 6 7 8 9 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
| class Patient:
def __init__(self):
self._id = ''
self._ipp = ''
self._nom = ''
self._nom_naissance = ''
self._prenom = ''
self._date_naissance = ''
self._sexe = ''
self._adresse = ''
self._code_postal = ''
self._ville = ''
self._tel_domicile = ''
self._tel_portable = ''
self._tel_professionnel = ''
self._numero_secu = ''
def getPatient(IPP):
sql = """SELECT id, sexe, nom, nom_naissance, prenom, date_naissance, adresse, telephone_fixe, telephone_portable , telephone_bureau,
cp, ville, numero_ss, cle_ss
FROM patient
WHERE ipppatient = %s""" %( db.quote( IPP ) )
info_patient = db.fetch( sql )
liste_patient = list()
if len(info_patient) > 0:
for ip in info_patient:
( patient_id, sexe, nom, nom_naissance, prenom, date_naissance, adresse, telephone_fixe, telephone_portable, telephone_bureau,
cp, ville, numero_ss, cle_ss ) = ip
p = Patient()
p.id = patient_id
p.ipp = IPP
p.nom = nom
p.nom_naissance = nom_naissance
p.prenom = prenom
p.date_naissance = date_naissance
if sexe == None:
sexe = ""
p.sexe = sexe
if adresse == None:
adresse = ""
p.adresse = adresse
p.code_postal = cp
p.ville = ville
if telephone_fixe == None:
telephone_fixe = ""
p.tel_domicile =telephone_fixe
if telephone_fixe == None:
telephone_fixe = ""
p.tel_domicile = telephone_fixe
if telephone_portable == None:
telephone_portable = ""
p.tel_portable = telephone_portable
if telephone_bureau == None:
telephone_bureau = ""
p.tel_professionnel = telephone_bureau
if numero_ss == None or cle_ss == None:
numero_secu = ""
else:
numero_secu = "%s%s" % (numero_ss, cle_ss)
p.numero_secu = numero_secu
liste_patient.append(p)
return liste_patient |
Partager