def _get_liaisons(self,code,numero):
"""renvoie la liste des demandes sources d'une commande ou des commandes issues d'une demande"""
- liaisons = []
cursor = self.cursor()
if code[:3] == 'DEM':
request = "select code,numero from auf_v_acces_dtls_demcom where source_code = '%s' and source_numero = '%s' group by code,numero"
else:
- request = "select source_code,source_numero from auf_v_acces_dtls_demcom where code = '%s' and numero = '%s' group by source_code,source_numero"
+ request = "select source_code as code, source_numero as numero from auf_v_acces_dtls_demcom where code = '%s' and numero = '%s' group by source_code,source_numero"
cursor.execute( request % (code, numero ) )
+ liaisons = []
while 1:
liaison = dict_fetchone(cursor)
if liaison == None: break
+ if liaison['code'] == None: break # cas d'un document sans liaison
+ liaison['code_rest'] = coda2rest(liaison['code'])
liaisons.append(liaison)
return liaisons