[Fmsystem-commits] [9638] property: remove duplicates from list

[Sigurd Nes]

Revision: 9638
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=9638
Author:   sigurdne
Date:     2012-06-21 06:58:01 +0000 (Thu, 21 Jun 2012)
Log Message:
-----------
property: remove duplicates from list

Modified Paths:
--------------
    trunk/property/inc/class.soinvoice.inc.php

Modified: trunk/property/inc/class.soinvoice.inc.php
===================================================================
--- trunk/property/inc/class.soinvoice.inc.php  2012-06-20 13:29:40 UTC (rev 
9637)
+++ trunk/property/inc/class.soinvoice.inc.php  2012-06-21 06:58:01 UTC (rev 
9638)
@@ -1298,7 +1298,7 @@
 
                        if(isset($this->config->config_data['invoice_acl']) && 
$this->config->config_data['invoice_acl'] == 'dimb')
                        {
-                               $sql = "SELECT fm_ecodimb.* FROM fm_ecodimb 
{$this->db->join} fm_ecodimb_role_user ON fm_ecodimb.id = 
fm_ecodimb_role_user.ecodimb"
+                               $sql = "SELECT DISTINCT fm_ecodimb.* FROM 
fm_ecodimb {$this->db->join} fm_ecodimb_role_user ON fm_ecodimb.id = 
fm_ecodimb_role_user.ecodimb"
                                . ' WHERE fm_ecodimb_role_user.user_id = ' . 
(int) $this->account_id . ' ORDER BY descr ASC';
                                $include_selected = true;
                        }