document : ajout de code_rest dans les liaisons

diff --git a/document.py b/document.py
index 93aa565..d9a0492 100644 (file)
--- a/document.py
+++ b/document.py
@@ -63,16 +63,18 @@ class Document(Objet):
 
     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