128 lines
5.2 KiB
PHP
Executable File
128 lines
5.2 KiB
PHP
Executable File
<?php
|
|
if (!defined('sugarEntry') || !sugarEntry) {
|
|
die('Not A Valid Entry Point');
|
|
}
|
|
/**
|
|
*
|
|
* SugarCRM Community Edition is a customer relationship management program developed by
|
|
* SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
|
|
*
|
|
* SuiteCRM is an extension to SugarCRM Community Edition developed by SalesAgility Ltd.
|
|
* Copyright (C) 2011 - 2018 SalesAgility Ltd.
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify it under
|
|
* the terms of the GNU Affero General Public License version 3 as published by the
|
|
* Free Software Foundation with the addition of the following permission added
|
|
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
|
|
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
|
|
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
|
|
*
|
|
* This program is distributed in the hope that it will be useful, but WITHOUT
|
|
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
|
|
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
|
|
* details.
|
|
*
|
|
* You should have received a copy of the GNU Affero General Public License along with
|
|
* this program; if not, see http://www.gnu.org/licenses or write to the Free
|
|
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
|
|
* 02110-1301 USA.
|
|
*
|
|
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
|
|
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
|
|
*
|
|
* The interactive user interfaces in modified source and object code versions
|
|
* of this program must display Appropriate Legal Notices, as required under
|
|
* Section 5 of the GNU Affero General Public License version 3.
|
|
*
|
|
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
|
|
* these Appropriate Legal Notices must retain the display of the "Powered by
|
|
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
|
|
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
|
|
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
|
|
*/
|
|
|
|
|
|
require_once("data/Relationships/One2MBeanRelationship.php");
|
|
|
|
/**
|
|
* 1-1 Bean relationship
|
|
* @api
|
|
*/
|
|
class One2OneBeanRelationship extends One2MBeanRelationship
|
|
{
|
|
public function __construct($def)
|
|
{
|
|
parent::__construct($def);
|
|
}
|
|
/**
|
|
* @param SugarBean $lhs left side bean to add to the relationship.
|
|
* @param SugarBean $rhs right side bean to add to the relationship.
|
|
* @param mixed $additionalFields key=>value pairs of fields to save on the relationship
|
|
* @return boolean true if successful
|
|
*/
|
|
public function add($lhs, $rhs, $additionalFields = array())
|
|
{
|
|
$lhsLinkName = $this->lhsLink;
|
|
//In a one to one, any existing links from both sides must be removed first.
|
|
//one2Many will take care of the right side, so we'll do the left.
|
|
$lhs->load_relationship($lhsLinkName);
|
|
$this->removeAll($lhs->$lhsLinkName);
|
|
|
|
return parent::add($lhs, $rhs, $additionalFields);
|
|
}
|
|
|
|
protected function updateLinks($lhs, $lhsLinkName, $rhs, $rhsLinkName)
|
|
{
|
|
//RHS and LHS only ever have one bean
|
|
if (isset($lhs->$lhsLinkName)) {
|
|
$lhs->$lhsLinkName->beans = array($rhs->id => $rhs);
|
|
}
|
|
|
|
if (isset($rhs->$rhsLinkName)) {
|
|
$rhs->$rhsLinkName->beans = array($lhs->id => $lhs);
|
|
}
|
|
}
|
|
|
|
public function getJoin($link, $params = array(), $return_array = false)
|
|
{
|
|
$linkIsLHS = $link->getSide() == REL_LHS;
|
|
$startingTable = (empty($params['left_join_table_alias']) ? $link->getFocus()->table_name : $params['left_join_table_alias']);
|
|
if (!$linkIsLHS) {
|
|
$startingTable = (empty($params['right_join_table_alias']) ? $link->getFocus()->table_name : $params['right_join_table_alias']);
|
|
}
|
|
$startingKey = $linkIsLHS ? $this->def['lhs_key'] : $this->def['rhs_key'];
|
|
$targetTable = $linkIsLHS ? $this->def['rhs_table'] : $this->def['lhs_table'];
|
|
$targetTableWithAlias = $targetTable;
|
|
$targetKey = $linkIsLHS ? $this->def['rhs_key'] : $this->def['lhs_key'];
|
|
$join_type= isset($params['join_type']) ? $params['join_type'] : ' INNER JOIN ';
|
|
|
|
$join = '';
|
|
|
|
//Set up any table aliases required
|
|
if (! empty($params['join_table_alias'])) {
|
|
$targetTableWithAlias = $targetTable . " ". $params['join_table_alias'];
|
|
$targetTable = $params['join_table_alias'];
|
|
}
|
|
|
|
$deleted = !empty($params['deleted']) ? 1 : 0;
|
|
|
|
//join the related module's table
|
|
$join .= "$join_type $targetTableWithAlias ON $targetTable.$targetKey=$startingTable.$startingKey"
|
|
. " AND $targetTable.deleted=$deleted\n"
|
|
//Next add any role filters
|
|
. $this->getRoleWhere();
|
|
|
|
if ($return_array) {
|
|
return array(
|
|
'join' => $join,
|
|
'type' => $this->type,
|
|
'rel_key' => $targetKey,
|
|
'join_tables' => array($targetTable),
|
|
'where' => "",
|
|
'select' => "$targetTable.id",
|
|
);
|
|
}
|
|
return $join;
|
|
}
|
|
}
|