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/M2MRelationship.php");
42 * Represents a one to many relationship that is table based.
44 class One2MRelationship extends M2MRelationship
47 public function __construct($def)
52 $this->name = $def['name'];
54 $this->selfReferencing = $def['lhs_module'] == $def['rhs_module'];
55 $lhsModule = $def['lhs_module'];
56 $rhsModule = $def['rhs_module'];
58 if ($this->selfReferencing)
60 $links = VardefManager::getLinkFieldForRelationship(
61 $lhsModule, BeanFactory::getObjectName($lhsModule), $this->name
65 $GLOBALS['log']->fatal("No Links found for relationship {$this->name}");
68 if (!is_array($links)) //Only one link for a self referencing relationship, this is BAAAD
70 $this->lhsLinkDef = $this->rhsLinkDef = $links;
72 else if (!empty($links[0]) && !empty($links[1]))
75 if ((!empty($links[0]['side']) && $links[0]['side'] == "right")
76 || (!empty($links[0]['link_type']) && $links[0]['link_type'] == "one"))
78 //$links[0] is the RHS
79 $this->lhsLinkDef = $links[1];
80 $this->rhsLinkDef = $links[0];
83 //$links[0] is the LHS
84 $this->lhsLinkDef = $links[0];
85 $this->rhsLinkDef = $links[1];
91 $this->lhsLinkDef = VardefManager::getLinkFieldForRelationship(
92 $lhsModule, BeanFactory::getObjectName($lhsModule), $this->name
94 $this->rhsLinkDef = VardefManager::getLinkFieldForRelationship(
95 $rhsModule, BeanFactory::getObjectName($rhsModule), $this->name
97 if (!isset($this->lhsLinkDef['name']) && isset($this->lhsLinkDef[0]))
99 $this->lhsLinkDef = $this->lhsLinkDef[0];
101 if (!isset($this->rhsLinkDef['name']) && isset($this->rhsLinkDef[0])) {
102 $this->rhsLinkDef = $this->rhsLinkDef[0];
105 $this->lhsLink = $this->lhsLinkDef['name'];
106 $this->rhsLink = $this->rhsLinkDef['name'];
109 public function getQuery($link, $params = array())
111 //Self referenceing one to many relationships use one link for subpanels and normal views.
112 //This mean we have to reverse it for normal views
113 if (($link->getSide() == REL_LHS && !$this->selfReferencing)
114 || $link->getSide() == REL_RHS && $this->selfReferencing
116 $knownKey = $this->def['join_key_lhs'];
117 $targetKey = $this->def['join_key_rhs'];
121 $knownKey = $this->def['join_key_rhs'];
122 $targetKey = $this->def['join_key_lhs'];
124 $rel_table = $this->getRelationshipTable();
126 $where = "$rel_table.$knownKey = '{$link->getFocus()->id}'" . $this->getRoleWhere();
128 if (empty($params['return_as_array'])) {
129 return "SELECT $targetKey id FROM $rel_table WHERE $where AND deleted=0";
134 'select' => "SELECT $targetKey id",
135 'from' => "FROM $rel_table",
136 'where' => "WHERE $where AND $rel_table.deleted=0",
142 * @param $lhs SugarBean left side bean to add to the relationship.
143 * @param $rhs SugarBean right side bean to add to the relationship.
144 * @param $additionalFields key=>value pairs of fields to save on the relationship
145 * @return boolean true if successful
147 public function add($lhs, $rhs, $additionalFields = array())
149 $dataToInsert = $this->getRowToInsert($lhs, $rhs, $additionalFields);
150 //If the current data matches the existing data, don't do anything
151 if (!$this->checkExisting($dataToInsert))
153 $rhsLinkName = $this->rhsLink;
154 //In a one to many, any existing links from the many (right) side must be removed first
155 $rhs->load_relationship($rhsLinkName);
156 $this->removeAll($rhs->$rhsLinkName);
157 parent::add($lhs, $rhs, $additionalFields);
162 * Just overriding the function from M2M to prevent it from occuring
164 protected function addSelfReferencing($lhs, $rhs, $additionalFields = array())
170 * Just overriding the function from M2M to prevent it from occuring
172 protected function removeSelfReferencing($lhs, $rhs, $additionalFields = array())