[Phpgroupware-cvs] [20910] New feature : preferences for notifications

[Pascal Vilarem]

Revision: 20910
          
http://svn.sv.gnu.org/viewvc/?view=rev&root=phpgroupware&revision=20910
Author:   maat
Date:     2010-01-05 17:36:55 +0000 (Tue, 05 Jan 2010)
Log Message:
-----------
New feature : preferences for notifications

Modified Paths:
--------------
    modules/ged/trunk/inc/class.ged_dm.inc.php

Modified: modules/ged/trunk/inc/class.ged_dm.inc.php
===================================================================
--- modules/ged/trunk/inc/class.ged_dm.inc.php  2010-01-05 17:24:12 UTC (rev 
20909)
+++ modules/ged/trunk/inc/class.ged_dm.inc.php  2010-01-05 17:36:55 UTC (rev 
20910)
@@ -3683,9 +3683,130 @@
                
                return ($out);
        }
-       
+
        function get_project_status($project_root)
        {
                
        }
+
+       /**
+       * Get GED Preference
+       *
+       * @return array of preference
+       */
+       function get_ged_preference ()
+       {
+               
+               
+               //TODO : limiter en fonction des droits
+               $sql="select preference_value from phpgw_preferences where 
preference_app = 'ged' and preference_owner = 
".$GLOBALS['phpgw_info']['user']['account_id'];
+               $this->db->query($sql, __LINE__, __FILE__);
+
+               $this->db->next_record();
+               $array = unserialize($this->db->f('preference_value'));
+               
+               $this->db->unlock();
+               
+               return $array;
+       }
+       
+       function add_reject($project,$action)
+       {
+               $new_reject=array('project' => $project,'action' => $action);
+               $sql="select * from phpgw_preferences where preference_app = 
'flow_mail_ged' and preference_owner = 
".$GLOBALS['phpgw_info']['user']['account_id'];
+               $this->db->query($sql, __LINE__, __FILE__);
+
+               
+               if($this->db->next_record())
+               {
+                       $value = unserialize($this->db->f('preference_value'));
+                       $value[count($value)]=$new_reject;
+                       
+                       $sql2="UPDATE phpgw_preferences SET 
preference_value='".serialize($value)."' where preference_app = 'flow_mail_ged' 
and preference_owner = ".$GLOBALS['phpgw_info']['user']['account_id'];
+               }
+               else
+               {
+                       $value=array(0 => $new_reject);
+                       $sql2="INSERT INTO phpgw_preferences 
(preference_value,preference_app,preference_owner) values 
('".serialize($value)."','flow_mail_ged',".$GLOBALS['phpgw_info']['user']['account_id'].")";
+               }
+               
+               $this->db->query($sql2);
+       
+               $this->db->unlock();
+               
+       }
+       
+       function list_ged_reject ($user='')
+       {
+               
+               if($user =='')
+                       $user=$GLOBALS['phpgw_info']['user']['account_id'];
+               //TODO : limiter en fonction des droits
+               $sql="select preference_value from phpgw_preferences where 
preference_app = 'flow_mail_ged' and preference_owner = ".$user;
+               $this->db->query($sql, __LINE__, __FILE__);
+
+               $this->db->next_record();
+               $array = unserialize($this->db->f('preference_value'));
+               
+               $this->db->unlock();
+               
+               return $array;
+       }
+       
+       function remove_reject($i)
+       {
+               
+               $sql="select * from phpgw_preferences where preference_app = 
'flow_mail_ged' and preference_owner = 
".$GLOBALS['phpgw_info']['user']['account_id'];
+               $this->db->query($sql, __LINE__, __FILE__);
+               $new_tab=array();
+               $cpt=0;
+               if($this->db->next_record())
+               {
+                       $values = unserialize($this->db->f('preference_value'));
+                       foreach($values as $key => $value)
+                       {
+                               
+                               if($key != $i)
+                                       $new_tab[$cpt++]=$value;
+                       }
+                       
+                       
+                       $sql2="UPDATE phpgw_preferences SET 
preference_value='".serialize($new_tab)."' where preference_app = 
'flow_mail_ged' and preference_owner = 
".$GLOBALS['phpgw_info']['user']['account_id'];
+               }
+               else
+               {
+                       return false;
+               }
+               
+               $this->db->query($sql2);
+       
+               $this->db->unlock();
+               
+       }
+       
+       function notification_filter($user,$project,$action)
+       {
+               
+               $user_pref      = createObject('phpgwapi.preferences');
+               $user_pref->preferences($user);
+       
+               $data = $user_pref->read();
+               if(!isset($data['email']['address']))
+                       return false;
+               $list_project = $data['ged']['show_projects'];
+               $list_reject = $data['flow_mail_ged'];
+               if(!isset($list_project[$project]))
+                       return false;
+               foreach($list_reject as $reject)
+               {
+                       if($reject['project'] == 0 && $reject['action'] == 
$action) 
+                               return false;
+                       if($reject['project'] == $project && $reject['action'] 
== $action)
+                               return false;
+               }
+               
+               return $data['email']['address'];
+       
+       }
+       
 }