[Fmsystem-commits] [8146]

[Erik Holm-Larsen]

Revision: 8146
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8146
Author:   erikhl
Date:     2011-11-21 11:52:58 +0000 (Mon, 21 Nov 2011)
Log Message:
-----------


Modified Paths:
--------------
    trunk/activitycalendar/inc/class.socontactperson.inc.php

Modified: trunk/activitycalendar/inc/class.socontactperson.inc.php
===================================================================
--- trunk/activitycalendar/inc/class.socontactperson.inc.php    2011-11-21 
11:52:28 UTC (rev 8145)
+++ trunk/activitycalendar/inc/class.socontactperson.inc.php    2011-11-21 
11:52:58 UTC (rev 8146)
@@ -339,6 +339,37 @@
                return $result;
        }
        
+       function get_booking_contact_persons($id, $group=false)
+       {
+               $result = array();
+       if(isset($id)){
+               $columns[] = 'group_contact.id';
+                               $columns[] = 'group_contact.name';
+                               $columns[] = 'group_contact.phone';
+                               $columns[] = 'group_contact.email';
+                               $columns[] = 'group_contact.group_id';
+               if($group)
+               {
+                       $q1="SELECT id, group_id, name, phone, email FROM 
bb_group_contact WHERE group_id='{$id}'";
+               }
+               else
+               {
+                       $q1="SELECT id, organization_id, name, phone, email, 
ssn FROM bb_organization_contact WHERE organization_id='{$id}'";
+               }
+                       $this->db->query($q1, __LINE__, __FILE__);
+                       while($this->db->next_record()){
+                               $contact_person = new 
activitycalendar_contact_person($this->db->f('id'), 'int');
+                               
$contact_person->set_organization_id($this->unmarshal($this->db->f('organization_id'),
 'int'));
+                               
$contact_person->set_group_id($this->unmarshal($this->db->f('group_id'), 
'int'));
+                               
$contact_person->set_name($this->unmarshal($this->db->f('name'), 'string'));
+                               
$contact_person->set_phone($this->unmarshal($this->db->f('phone'), 'string'));
+                               
$contact_person->set_email($this->unmarshal($this->db->f('email'), 'string'));
+                               $result[] = $contact_person;
+                       }
+       }
+               return $result;
+       }
+       
        function update_local_contact_person($contact)
        {
                $id = $contact['id'];