public static function mergeRelationsFromTemporalTable($temporalTabName, $additinalFlds = array(), $fldMap = array())
{
$dbConnection = Main\HttpApplication::getConnection();
$dbHelper = $dbConnection->getSqlHelper();
$temporalTabName = Assert::expectStringNotNull($temporalTabName, false, 'Name of temporal table must be a non-zero length string');
$temporalTabName = $dbHelper->forSql($temporalTabName);
$entityTableName = static::getTableName();
if (!is_array($additinalFlds)) {
$additinalFlds = array();
}
$additinalFlds = array_merge(array('LEFT_MARGIN', 'RIGHT_MARGIN', 'DEPTH_LEVEL'), $additinalFlds);
$fldReplace = array();
foreach ($additinalFlds as &$fld) {
$fld = $dbHelper->forSql($fld);
$fldReplace[$fld] = is_array($fldMap) && isset($fldMap[$fld]) ? $dbHelper->forSql($fldMap[$fld]) : $fld;
}
$idReplace = is_array($fldMap) && isset($fldMap['ID']) ? $dbHelper->forSql($fldMap['ID']) : 'ID';
if ($dbConnection->getType() == 'mysql') {
$sql = 'update ' . $entityTableName . ', ' . $temporalTabName . ' set ';
$additFldCnt = count($additinalFlds);
for ($i = 0; $i < $additFldCnt; $i++) {
$sql .= $entityTableName . '.' . $additinalFlds[$i] . ' = ' . $temporalTabName . '.' . $fldReplace[$additinalFlds[$i]] . ($i == count($additinalFlds) - 1 ? '' : ', ');
}
$sql .= ' where ' . $entityTableName . '.ID = ' . $temporalTabName . '.' . $idReplace;
} elseif ($dbConnection->getType() == 'mssql') {
$sql = 'update ' . $entityTableName . ' set ';
$additFldCnt = count($additinalFlds);
for ($i = 0; $i < $additFldCnt; $i++) {
$sql .= $additinalFlds[$i] . ' = ' . $temporalTabName . '.' . $fldReplace[$additinalFlds[$i]] . ($i == count($additinalFlds) - 1 ? '' : ', ');
}
$sql .= ' from ' . $entityTableName . ' join ' . $temporalTabName . ' on ' . $entityTableName . '.ID = ' . $temporalTabName . '.' . $idReplace;
} elseif ($dbConnection->getType() == 'oracle') {
// update tab1 set (aa,bb) = (select aa,bb from tab2 where tab2.id = tab1.id)
$sql = 'update ' . $entityTableName . ' set (' . implode(', ', $additinalFlds) . ') = (select ' . implode(', ', $fldReplace) . ' from ' . $temporalTabName . ' where ' . $entityTableName . '.ID = ' . $temporalTabName . '.' . $idReplace . ')';
}
$dbConnection->query($sql);
}
public static function checkNodeIsParentOfNode($primary, $childPrimary, $behaviour = array('ACCEPT_CODE' => false, 'CHECK_DIRECT' => false))
{
if (!$behaviour['ACCEPT_CODE']) {
return static::checkNodeIsParentOfNodeById($primary, $childPrimary, $behaviour);
}
$primary = Assert::expectStringNotNull($primary, false, Loc::getMessage('SALE_LOCATION_LOCATION_ENTITY_BAD_ARGUMENT_CODE_UNSET_EXCEPTION'));
$childPrimary = Assert::expectStringNotNull($childPrimary, false, Loc::getMessage('SALE_LOCATION_LOCATION_ENTITY_BAD_ARGUMENT_CODE_UNSET_EXCEPTION'));
return static::checkNodeIsParentOfNodeByFilters(array('=CODE' => $primary), array('=CODE' => $childPrimary), $behaviour);
}
/**
* Check if there is a link between entity and locations, optionally of a certain type (default: locations)
*
* @param mixed $entityPrimary primary key for an entity
* @param string $linkType link type (G or L (default))
*
* @throws ArgumentNullException
*
* @return boolean
*/
public static function checkLinkUsage($entityPrimary, $linkType = self::DB_LOCATION_FLAG)
{
$entityPrimary = Assert::expectStringNotNull($entityPrimary, Loc::getMessage('SALE_LOCATION_CONNECTOR_ENTITY_PRIMARY_FLD_NAME'));
$linkType = Assert::expectEnumerationMember($linkType, array(self::DB_LOCATION_FLAG, self::DB_GROUP_FLAG), Loc::getMessage('SALE_LOCATION_CONNECTOR_ENTITY_PRIMARY_FLD_NAME'));
if (!static::getUseLinkTracking()) {
return true;
}
// force to true if link tracking is off
$useGroups = static::getUseGroups();
if (!$useGroups && $linkType == self::DB_GROUP_FLAG) {
return false;
}
// we know we dont use groups
$usageFlags = static::getLinkUsageOptionValue();
if (isset($usageFlags[$entityPrimary][$linkType])) {
return $usageFlags[$entityPrimary][$linkType];
}
$strictFilter = array(static::getLinkField() => $entityPrimary);
if ($useGroups) {
$strictFilter['LOCATION_TYPE'] = self::DB_LOCATION_FLAG;
}
$usageFlags[$entityPrimary][self::DB_LOCATION_FLAG] = !!static::getList(array('limit' => 1, 'filter' => $strictFilter))->fetch();
if ($useGroups) {
$usageFlags[$entityPrimary][self::DB_GROUP_FLAG] = !!static::getList(array('limit' => 1, 'filter' => array(static::getLinkField() => $entityPrimary, 'LOCATION_TYPE' => self::DB_GROUP_FLAG)))->fetch();
}
static::setLinkUsageOptionValue($usageFlags);
return $usageFlags[$entityPrimary];
}
private static function checkSiteId($siteId)
{
$siteId = Assert::expectStringNotNull($siteId, Loc::getMessage('SALE_LOCATION_DEFAULTSITE_ENTITY_SITE_ID_NOT_SET_EXCEPTION'));
$res = Main\SiteTable::getList(array('filter' => array('LID' => $siteId)))->fetch();
if (!$res) {
throw new Main\ArgumentOutOfRangeException(Loc::getMessage('SALE_LOCATION_DEFAULTSITE_ENTITY_SITE_ID_UNKNOWN_EXCEPTION'));
}
return $siteId;
}
