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");
41 class One2OneBeanRelationship extends One2MBeanRelationship
44 public function __construct($def)
46 parent::__construct($def);
49 * @param $lhs SugarBean left side bean to add to the relationship.
50 * @param $rhs SugarBean right side bean to add to the relationship.
51 * @param $additionalFields key=>value pairs of fields to save on the relationship
52 * @return boolean true if successful
54 public function add($lhs, $rhs, $additionalFields = array())
56 $lhsLinkName = $this->lhsLink;
57 //In a one to one, any existing links from boths sides must be removed first.
58 //one2Many will take care of the right side, so we'll do the left.
59 $lhs->load_relationship($lhsLinkName);
60 $this->removeAll($lhs->$lhsLinkName);
62 parent::add($lhs, $rhs, $additionalFields);
65 protected function updateLinks($lhs, $lhsLinkName, $rhs, $rhsLinkName)
67 //RHS and LHS only ever have one bean
68 if (isset($lhs->$lhsLinkName))
69 $lhs->$lhsLinkName->beans = array($rhs->id => $rhs);
71 if (isset($rhs->$rhsLinkName))
72 $rhs->$rhsLinkName->beans = array($lhs->id => $lhs);
75 public function getJoin($link, $params = array(), $return_array = false)
77 $linkIsLHS = $link->getSide() == REL_LHS;
78 $startingTable = $link->getFocus()->table_name;
79 $startingKey = $linkIsLHS ? $this->def['lhs_key'] : $this->def['rhs_key'];
80 $targetTable = $linkIsLHS ? $this->def['rhs_table'] : $this->def['lhs_table'];
81 $targetTableWithAlias = $targetTable;
82 $targetKey = $linkIsLHS ? $this->def['rhs_key'] : $this->def['lhs_key'];
83 $join_type= isset($params['join_type']) ? $params['join_type'] : ' INNER JOIN ';
87 //Set up any table aliases required
88 if ( ! empty($params['join_table_alias']))
90 $targetTableWithAlias = $targetTable . " ". $params['join_table_alias'];
91 $targetTable = $params['join_table_alias'];
94 //join the related module's table
95 $join .= "$join_type $targetTableWithAlias ON $targetTable.$targetKey=$startingTable.$startingKey AND $targetTable.deleted=0\n"
96 //Next add any role filters
97 . $this->getRoleWhere();
102 'type' => $this->type,
103 'rel_key' => $targetKey,
104 'join_tables' => array($targetTable),
106 'select' => "$targetTable.id",