[Fmsystem-commits] [16605] more on integration

[sigurdne]

Revision: 16605
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=16605
Author:   sigurdne
Date:     2017-04-20 13:43:54 -0400 (Thu, 20 Apr 2017)
Log Message:
-----------
more on integration

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

Modified: trunk/property/inc/class.sodimb_role_user.inc.php
===================================================================
--- trunk/property/inc/class.sodimb_role_user.inc.php   2017-04-20 14:53:00 UTC 
(rev 16604)
+++ trunk/property/inc/class.sodimb_role_user.inc.php   2017-04-20 17:43:54 UTC 
(rev 16605)
@@ -306,12 +306,20 @@
 
                public function update_substitute( $user_id, 
$substitute_user_id )
                {
-                       return true;
+                       $this->db->transaction_begin();
+                       $this->db->query('DELETE FROM 
fm_ecodimb_role_user_substitute WHERE user_id = ' . (int)$user_id, __LINE__, 
__FILE__);
+                       $this->db->query('INSERT INTO 
fm_ecodimb_role_user_substitute (user_id, substitute_user_id ) VALUES (' . 
(int)$user_id . ',' . (int) $substitute_user_id . ')', __LINE__, __FILE__);
+                       if($this->db->transaction_commit())
+                       {
+                               phpgwapi_cache::message_set(lang('substitute') 
.': ' . $GLOBALS['phpgw']->accounts->get($substitute_user_id)->__toString(), 
'message');
+                               return true;
+                       }
                }
 
                public function get_substitute( $user_id)
                {
-                       return 6;
+                       $this->db->query('SELECT substitute_user_id FROM 
fm_ecodimb_role_user_substitute WHERE user_id = ' . (int)$user_id, __LINE__, 
__FILE__);
+                       $this->db->next_record();
+                       return (int)$this->db->f('substitute_user_id');
                }
-
        }
\ No newline at end of file