[Fmsystem-commits] [11545] property:update invoice handling, update notification

[Sigurd Nes]

Revision: 11545
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=11545
Author:   sigurdne
Date:     2013-12-19 15:31:02 +0000 (Thu, 19 Dec 2013)
Log Message:
-----------
property:update invoice handling, update notification

Modified Paths:
--------------
    trunk/property/inc/cron/default/Import_fra_agresso_X205.php

Modified: trunk/property/inc/cron/default/Import_fra_agresso_X205.php
===================================================================
--- trunk/property/inc/cron/default/Import_fra_agresso_X205.php 2013-12-19 
15:10:17 UTC (rev 11544)
+++ trunk/property/inc/cron/default/Import_fra_agresso_X205.php 2013-12-19 
15:31:02 UTC (rev 11545)
@@ -233,13 +233,13 @@
                        if ( (int) 
$GLOBALS['phpgw_info']['server']['invoice_mail_reminder_time'] < (time() - 
(3600 * 24)) )
                        {
                                $toarray = array();
-                               $sql = 'SELECT DISTINCT oppsynsmannid as 
responsible FROM fm_ecobilag WHERE oppsynsigndato IS NULL AND oppsynsmannid IS 
NOT NULL';
+                               $sql = 'SELECT DISTINCT oppsynsmannid as 
responsible FROM fm_ecobilag WHERE oppsynsigndato IS NULL AND oppsynsmannid IS 
NOT NULL AND saksigndato IS NULL';
                                $this->db->query($sql,__LINE__,__FILE__);
                                while($this->db->next_record())
                                {
                                        $toarray[$this->db->f('responsible')] = 
true;
                                }
-                               $sql = 'SELECT DISTINCT saksbehandlerid as 
responsible FROM fm_ecobilag WHERE saksigndato IS NULL AND saksbehandlerid IS 
NOT NULL';
+                               $sql = 'SELECT DISTINCT saksbehandlerid as 
responsible FROM fm_ecobilag WHERE saksigndato IS NULL AND saksbehandlerid IS 
NOT NULL AND oppsynsigndato IS NULL';
                                $this->db->query($sql,__LINE__,__FILE__);
                                while($this->db->next_record())
                                {