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();
_______________________________________________
Phpcompta-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
