[Phpcompta-dev] r287 - trunk/coprop/include

[phpcompta-dev]

Author: danydb
Date: 2012-01-13 12:01:38 +0100 (Fri, 13 Jan 2012)
New Revision: 287

Modified:
   trunk/coprop/include/lot.inc.php
Log:
?\195?\169cran lot : montre aussi lot avec immeuble ou coprop inexistant

Modified: trunk/coprop/include/lot.inc.php
===================================================================
--- trunk/coprop/include/lot.inc.php    2012-01-12 16:12:17 UTC (rev 286)
+++ trunk/coprop/include/lot.inc.php    2012-01-13 11:01:38 UTC (rev 287)
@@ -86,6 +86,8 @@
        coprop.summary as s join vw_fiche_attr on (lot_id::numeric=f_id)
        where
        coalesce(s.building_id,'')='' or coalesce(s.coprop_id,'')=''
+        or coalesce(s.building_id,'') not in (select building_id from 
coprop.summary) 
+        or coalesce(s.coprop_id,'') not in (select coprop_id from 
coprop.summary) 
        ");
 
 echo $f_add_button->input();