public static function importTreeItem($field_sid, $imported_row)
{
if (!is_array($imported_row)) {
return false;
}
$parent_sid = 0;
$inserted = false;
foreach ($imported_row as $item_caption) {
if (empty($item_caption)) {
break;
}
$item_sid = SJB_DB::queryValue("SELECT sid FROM listing_field_tree WHERE field_sid = ?n AND parent_sid = ?n AND caption = ?s", $field_sid, $parent_sid, $item_caption);
if (!empty($item_sid)) {
} elseif ($item_sid = SJB_ListingFieldTreeManager::addTreeItemToEndByParentSID($field_sid, $parent_sid, $item_caption)) {
$inserted = true;
} else {
break;
}
$parent_sid = $item_sid;
}
return $inserted;
}
public static function addTreeItemToEndByParentSID($field_sid, $parent_sid, $tree_item_value)
{
return SJB_ListingFieldTreeManager::addTreeItemToEndByParentSID($field_sid, $parent_sid, $tree_item_value);
}
function _createTreeInfo($tree_column_name, $tree_captions)
{
$tree_sid_searcher = new SJB_TreeInfoSearcher($tree_column_name, array($tree_captions[0]), $this->listing_type);
$tree_info = $tree_sid_searcher->getInfo();
$field_info = SJB_ListingFieldDBManager::getListingFieldInfoByID($tree_column_name);
$field_sid = $field_info['sid'];
if ($tree_info == null) {
SJB_ListingFieldTreeManager::addTreeItemToEndByParentSID($field_sid, 0, $tree_captions[0]);
}
$tree_info = $tree_sid_searcher->getInfo();
SJB_ListingFieldTreeManager::addTreeItemToEndByParentSID($field_sid, $tree_info['sid'], $tree_captions[1]);
$tree_sid_searcher = new SJB_TreeInfoSearcher($tree_column_name, $tree_captions, $this->listing_type);
$tree_info = $tree_sid_searcher->getInfo();
return $tree_info;
}
public static function addTreeItemToEndByParentSID($field_sid, $parent_sid, $tree_item_value)
{
SJB_Cache::getInstance()->clean('matchingAnyTag', array(SJB_Cache::TAG_FIELDS));
return SJB_ListingFieldTreeManager::addTreeItemToEndByParentSID($field_sid, $parent_sid, $tree_item_value);
}
