public static function getBestMapping($codeName, $consumerName = null, $personTypeId = null)
{
if (!($codeName && is_string($codeName))) {
throw new ArgumentTypeException('codeName', 'string>""');
}
if (!($consumerName === null || is_string($consumerName) && $consumerName != '')) {
throw new ArgumentTypeException('consumerName', 'string>""|null');
}
if (!($personTypeId === null || is_numeric($personTypeId) && $personTypeId > 0)) {
throw new ArgumentTypeException('personTypeId', 'int>0|null');
}
$personTypeId = (int) $personTypeId;
$result = BusinessValueTable::getList(array('select' => array('ID', 'CODE_NAME', 'CONSUMER_NAME', 'PERSON_TYPE_ID', 'PROVIDER_NAME', 'PROVIDER_FIELD'), 'filter' => array('=CODE_NAME' => $codeName, '=CONSUMER_NAME' => $consumerName ? array($consumerName, null) : null, '=PERSON_TYPE_ID' => $personTypeId ? array($personTypeId, null) : null), 'limit' => $consumerName && $personTypeId ? 4 : ($consumerName || $personTypeId ? 2 : 1)));
$bestRow = null;
$bestWeight = -1;
while ($row = $result->fetch()) {
$weight = 0;
// TODO check weight logic!
if ($row['CONSUMER_NAME'] === $consumerName) {
$weight += 10;
} elseif ($row['CONSUMER_NAME'] === null) {
$weight += 1;
}
if ($row['PERSON_TYPE_ID'] === $personTypeId) {
$weight += 10;
} elseif ($row['PERSON_TYPE_ID'] === null) {
$weight += 1;
}
if ($weight > $bestWeight) {
$bestRow = $row;
$bestWeight = $weight;
}
}
return $bestRow;
}
/**
* @param string $parentName - parent identifier
* @param string $translationSource
* @param array $data - GROUP => ()
* @return bool - true on success or false on failure
* @throws SystemException
*/
static function install($parentName, $translationSource, array $data)
{
$error = false;
// load person types
$persons = array();
$result = PersonTypeTable::getList(array('select' => array('ID')));
while ($row = $result->fetch()) {
$persons[$row['ID']] = true;
}
// load person domains
$personsDomains = array();
$result = BusinessValuePersonDomainTable::getList(array('select' => array('PERSON_TYPE_ID', 'DOMAIN')));
while ($row = $result->fetch()) {
$personsDomains[$row['PERSON_TYPE_ID']] = $row['DOMAIN'];
}
// install person domains
if (is_array($data['PERSON_DOMAIN'])) {
foreach ($data['PERSON_DOMAIN'] as $personId => $domain) {
if (!$persons[$personId]) {
throw new SystemException("invalid person type `{$personId}`", 0, __FILE__, __LINE__);
}
switch ($domain) {
case self::COMMON_DOMAIN:
case self::INDIVIDUAL_DOMAIN:
case self::ENTITY_DOMAIN:
break;
default:
throw new SystemException("invalid domain: {$domain}", 0, __FILE__, __LINE__);
}
if (!$personsDomains[$personId]) {
if (BusinessValuePersonDomainTable::add(array('PERSON_TYPE_ID' => $personId, 'DOMAIN' => $domain))->isSuccess()) {
$personsDomains[$personId] = $domain;
} else {
$error = true;
}
}
}
}
$personsDomainsWithCommon = array(self::COMMON_PERSON_ID => self::COMMON_DOMAIN) + $personsDomains;
// load groups
$groups = array();
$result = BusinessValueGroupTable::getList(array('select' => array('NAME', 'ID')));
while ($row = $result->fetch()) {
$groups[$row['NAME']] = $row['ID'];
}
// install new groups
if (is_array($data['GROUPS'])) {
foreach ($data['GROUPS'] as $groupName => $group) {
if (!$groups[$groupName]) {
if (!is_string($groupName)) {
throw new SystemException("invalid group name", 0, __FILE__, __LINE__);
}
if (!is_array($group)) {
throw new SystemException("invalid group", 0, __FILE__, __LINE__);
}
$result = BusinessValueGroupTable::add(array('NAME' => $groupName, 'SORT' => $group['SORT']));
if ($result->isSuccess()) {
$groups[$groupName] = $result->getId();
} else {
$error = true;
}
}
}
}
// install codes
if (is_array($data['CODES'])) {
// get parent id, install parent if not exists
if ($row = BusinessValueParentTable::getList(array('select' => array('ID'), 'filter' => array('=NAME' => $parentName)))->fetch()) {
$parentId = $row['ID'];
} else {
$result = BusinessValueParentTable::add(array('NAME' => $parentName, 'LANG_SRC' => $translationSource));
if ($result->isSuccess()) {
$parentId = $result->getId();
} else {
return false;
}
}
// load codes
$codes = array();
$result = BusinessValueCodeTable::getList(array('select' => array('ID', 'NAME')));
while ($row = $result->fetch()) {
$codes[$row['NAME']] = $row['ID'];
}
// load value maps
$valueMaps = array();
$result = BusinessValueTable::getList(array('select' => array('CODE_ID', 'PERSON_TYPE_ID')));
while ($row = $result->fetch()) {
$valueMaps[$row['CODE_ID']][$row['PERSON_TYPE_ID']] = true;
}
// load parent codes
$parentCodes = array();
$result = BusinessValueCodeParentTable::getList(array('select' => array('CODE_ID'), 'filter' => array('=PARENT_ID' => $parentId)));
while ($row = $result->fetch()) {
$parentCodes[$row['CODE_ID']] = true;
}
// install: groups, codes, parent codes
foreach ($data['CODES'] as $codeName => $code) {
if (!is_string($codeName)) {
throw new SystemException("invalid code name", 0, __FILE__, __LINE__);
}
if (!is_array($code)) {
throw new SystemException("invalid code", 0, __FILE__, __LINE__);
}
// get group id, install group if not exists
$groupId = null;
if (($groupName = $code['GROUP']) && !($groupId = $groups[$groupName])) {
$result = BusinessValueGroupTable::add(array('NAME' => $groupName));
if ($result->isSuccess()) {
$groups[$groupName] = $groupId = $result->getId();
} else {
$error = true;
}
}
// get code domain
switch ($domain = $code['DOMAIN']) {
case self::COMMON_DOMAIN:
case self::INDIVIDUAL_DOMAIN:
case self::ENTITY_DOMAIN:
break;
default:
throw new SystemException("invalid domain: {$domain}", 0, __FILE__, __LINE__);
}
// get code id, install code if not exists
if (!($codeId = $codes[$codeName])) {
$result = BusinessValueCodeTable::add(array('NAME' => $codeName, 'DOMAIN' => $domain, 'GROUP_ID' => $groupId, 'SORT' => $code['SORT']));
if ($result->isSuccess()) {
$codeId = $result->getId();
$codes[$codeName] = $codeId;
} else {
$error = true;
continue;
}
}
// install value maps if not exist
if (is_array($code['MAP'])) {
foreach ($code['MAP'] as $personId => $map) {
if (!is_array($map) || count($map) != 2) {
throw new SystemException("invalid map: " . print_r($map, true), 0, __FILE__, __LINE__);
}
if ($domain === self::COMMON_DOMAIN) {
if (!$personsDomainsWithCommon[$personId]) {
throw new SystemException("invalid person type id `{$personId}`", 0, __FILE__, __LINE__);
}
} else {
if ($domain !== $personsDomains[$personId]) {
throw new SystemException("invalid person type id `{$personId}`", 0, __FILE__, __LINE__);
}
}
if (!isset($valueMaps[$codeId][$personId])) {
if (BusinessValueTable::add(array('PERSON_TYPE_ID' => $personId, 'CODE_ID' => $codeId, 'ENTITY' => $map[0], 'ITEM' => $map[1]))->isSuccess()) {
$valueMaps[$codeId][$personId] = true;
} else {
$error = true;
}
}
}
}
// install code parent if not exists
if (!$parentCodes[$codeId]) {
if (BusinessValueCodeParentTable::add(array('CODE_ID' => $codeId, 'PARENT_ID' => $parentId))->isSuccess()) {
$parentCodes[$codeId] = true;
} else {
$error = true;
}
}
}
}
return !$error;
}
}
}
unset($postedCode[$personId]);
} else {
$data = array('CODE_ID' => $codeId, 'PERSON_TYPE_ID' => $personId, 'ENTITY' => $postedMap['ENTITY'], 'ITEM' => $postedMap['ITEM']);
if ($mapId = $map['ID']) {
if ($postedMap['ENTITY'] == $map['ENTITY'] && $postedMap['ITEM'] == $map['ITEM']) {
continue;
} else {
$result = BusinessValueTable::update($mapId, $data);
}
} else {
if ($map) {
continue;
} else {
$result = BusinessValueTable::add($data);
}
}
if ($result->isSuccess()) {
$map['ID'] = $result->getId();
$map['ENTITY'] = $postedMap['ENTITY'];
$map['ITEM'] = $postedMap['ITEM'];
} else {
$errors['MAP'][$personId][$codeId]['DATABASE'] = $result->getErrorMessages();
}
}
}
}
unset($postedCode, $code, $postedMap, $map);
}
} else {
