2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
3 /*********************************************************************************
4 * SugarCRM Community Edition is a customer relationship management program developed by
5 * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
7 * This program is free software; you can redistribute it and/or modify it under
8 * the terms of the GNU Affero General Public License version 3 as published by the
9 * Free Software Foundation with the addition of the following permission added
10 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
11 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
12 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
14 * This program is distributed in the hope that it will be useful, but WITHOUT
15 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
16 * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
19 * You should have received a copy of the GNU Affero General Public License along with
20 * this program; if not, see http://www.gnu.org/licenses or write to the Free
21 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
24 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
25 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
27 * The interactive user interfaces in modified source and object code versions
28 * of this program must display Appropriate Legal Notices, as required under
29 * Section 5 of the GNU Affero General Public License version 3.
31 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
32 * these Appropriate Legal Notices must retain the display of the "Powered by
33 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
34 * technical reasons, the Appropriate Legal Notices must display the words
35 * "Powered by SugarCRM".
36 ********************************************************************************/
39 require_once("data/Relationships/One2MBeanRelationship.php");
42 * 1-1 Bean relationship
45 class One2OneBeanRelationship extends One2MBeanRelationship
48 public function __construct($def)
50 parent::__construct($def);
53 * @param $lhs SugarBean left side bean to add to the relationship.
54 * @param $rhs SugarBean right side bean to add to the relationship.
55 * @param $additionalFields key=>value pairs of fields to save on the relationship
56 * @return boolean true if successful
58 public function add($lhs, $rhs, $additionalFields = array())
60 $lhsLinkName = $this->lhsLink;
61 //In a one to one, any existing links from boths sides must be removed first.
62 //one2Many will take care of the right side, so we'll do the left.
63 $lhs->load_relationship($lhsLinkName);
64 $this->removeAll($lhs->$lhsLinkName);
66 parent::add($lhs, $rhs, $additionalFields);
69 protected function updateLinks($lhs, $lhsLinkName, $rhs, $rhsLinkName)
71 //RHS and LHS only ever have one bean
72 if (isset($lhs->$lhsLinkName))
73 $lhs->$lhsLinkName->beans = array($rhs->id => $rhs);
75 if (isset($rhs->$rhsLinkName))
76 $rhs->$rhsLinkName->beans = array($lhs->id => $lhs);
79 public function getJoin($link, $params = array(), $return_array = false)
81 $linkIsLHS = $link->getSide() == REL_LHS;
82 $startingTable = $link->getFocus()->table_name;
83 $startingKey = $linkIsLHS ? $this->def['lhs_key'] : $this->def['rhs_key'];
84 $targetTable = $linkIsLHS ? $this->def['rhs_table'] : $this->def['lhs_table'];
85 $targetTableWithAlias = $targetTable;
86 $targetKey = $linkIsLHS ? $this->def['rhs_key'] : $this->def['lhs_key'];
87 $join_type= isset($params['join_type']) ? $params['join_type'] : ' INNER JOIN ';
91 //Set up any table aliases required
92 if ( ! empty($params['join_table_alias']))
94 $targetTableWithAlias = $targetTable . " ". $params['join_table_alias'];
95 $targetTable = $params['join_table_alias'];
98 //join the related module's table
99 $join .= "$join_type $targetTableWithAlias ON $targetTable.$targetKey=$startingTable.$startingKey AND $targetTable.deleted=0\n"
100 //Next add any role filters
101 . $this->getRoleWhere();
106 'type' => $this->type,
107 'rel_key' => $targetKey,
108 'join_tables' => array($targetTable),
110 'select' => "$targetTable.id",