/**
* Creates the list of objects. Sets the parameter $p_hasNextElements to
* true if this list is limited and elements still exist in the original
* list (from which this was truncated) after the last element of this
* list.
*
* @param int $p_start
* @param int $p_limit
* @param array $p_parameters
* @param int &$p_count
* @return array
*/
protected function CreateList($p_start = 0, $p_limit = 0, array $p_parameters, &$p_count)
{
$rootTopicId = $p_parameters['topic_identifier'];
if ($p_start > 0 || $p_limit > 0) {
$sqlOptions = array('LIMIT'=>array('START'=>$p_start,
'MAX_ROWS'=>($p_limit == 0 ? 0 : $p_limit + 1)
)
);
} else {
$sqlOptions = null;
}
if (count($this->m_order) == 0) {
$this->m_order[] = array('field'=>'default', 'dir'=>'asc');
}
$topicsList = Topic::GetTopics(null, $p_parameters['language_id'], null,
$rootTopicId, 1, $sqlOptions, $this->m_order);
$p_count = Topic::GetTopics(null, $p_parameters['language_id'], null,
$rootTopicId, 1, null, null, true);
$metaTopicsList = array();
$index = 0;
foreach ($topicsList as $topic) {
$index++;
if ($p_limit == 0 || ($p_limit > 0 && $index <= $p_limit)) {
$metaTopicsList[] = new MetaTopic($topic->getTopicId());
}
}
return $metaTopicsList;
}
public function testCreate()
{
// test create(), fetch(), getLeft(), getRight(), getName()
$this->createAndTest(1, array('names'=>array(1=>'Sports', 2=>'Sport')), 1, 2);
$this->createAndTest(3, array('names'=>array(1=>'Electronics', 2=>'Electronice')), 1, 2);
$this->createAndTest(2, array('names'=>array(1=>'Education', 2=>'Educație')), 1, 2);
$this->createAndTest(27, array('names'=>array(1=>'Health', 2=>'Sănătate')), 1, 2);
$this->createAndTest(4, array('parent_id'=>3, 'names'=>array(1=>'Televisions', 2=>'Televizoare')), 6, 7);
$this->createAndTest(9, array('parent_id'=>3, 'names'=>array(1=>'Portable Electronics', 2=>'Electronice portabile')), 6, 7);
$this->createAndTest(14, array('parent_id'=>2, 'names'=>array(1=>'Culture', 2=>'Cultură')), 4, 5);
$this->createAndTest(15, array('parent_id'=>2, 'names'=>array(1=>'Science', 2=>'Știință')), 4, 5);
$this->createAndTest(26, array('parent_id'=>2, 'names'=>array(1=>'Religion', 2=>'Religie')), 4, 5);
$this->createAndTest(16, array('parent_id'=>14, 'names'=>array(1=>'Music', 2=>'Muzică')), 9, 10);
$this->createAndTest(19, array('parent_id'=>14, 'names'=>array(1=>'Film', 2=>'Film')), 9, 10);
$this->createAndTest(22, array('parent_id'=>14, 'names'=>array(1=>'Books', 2=>'Cărți')), 9, 10);
$this->createAndTest(17, array('parent_id'=>16, 'names'=>array(1=>'Classical', 2=>'Clasică')), 14, 15);
$this->createAndTest(18, array('parent_id'=>16, 'names'=>array(1=>'Jazz', 2=>'Jazz')), 14, 15);
$this->createAndTest(24, array('parent_id'=>15, 'names'=>array(1=>'Physics', 2=>'Fizică')), 7, 8);
$this->createAndTest(25, array('parent_id'=>15, 'names'=>array(1=>'Mathematics', 2=>'Matematică')), 7, 8);
// test constructor and GetByFullName()
$topic = new Topic('Physics:en');
// test other get methods
$this->assertEquals(24, $topic->getTopicId());
$this->assertEquals(15, $topic->getParentId());
$this->assertEquals(2, $topic->getNumTranslations());
$translations = array(1=>new TopicName(24, 1), 2=>new TopicName(24, 2));
$this->assertEquals($translations, $topic->getTranslations());
$path = array(2=>new Topic(2), 15=>new Topic(15), 24=>new Topic(24));
$pathIds = array(2=>2, 15=>15, 24=>24);
$this->assertEquals($path, $topic->getPath());
$this->assertEquals($pathIds, $topic->getPath(true));
$this->assertFalse($topic->hasSubtopics());
$this->assertFalse($topic->isRoot());
$this->assertEquals(1, $topic->getWidth());
$this->assertEquals(array(), $topic->getSubtopics());
$topic = new Topic('Educație:ro');
$this->assertTrue($topic->isRoot());
$this->assertTrue($topic->hasSubtopics());
$this->assertEquals(21, $topic->getWidth());
$this->assertEquals(null, $topic->getParentId());
$this->assertEquals(array(2=>new Topic(2)), $topic->getPath());
$subtopicsDepth1 = array(new Topic(26), new Topic(15), new Topic(14));
$subtopicsDepth1Ids = array(26, 15, 14);
$this->assertEquals($subtopicsDepth1, $topic->getSubtopics());
$this->assertEquals($subtopicsDepth1Ids, $topic->getSubtopics(true));
$subtopicsDepth2 = array(new Topic(26), new Topic(15), new Topic(25), new Topic(24),
new Topic(14), new Topic(22), new Topic(19), new Topic(16));
$this->assertEquals($subtopicsDepth2, $topic->getSubtopics(false, 2));
$subtopicsAll = array(new Topic(26), new Topic(15), new Topic(25), new Topic(24),
new Topic(14), new Topic(22), new Topic(19), new Topic(16), new Topic(18), new Topic(17));
$this->assertEquals($subtopicsAll, $topic->getSubtopics(false, 0));
$topics = array(new Topic(2));
$this->assertEquals($topics, Topic::GetTopics(2));
$this->assertEquals($topics, Topic::GetTopics(null, 1, 'Education'));
$this->assertEquals($subtopicsDepth1, Topic::GetTopics(null, null, null, 2));
$this->assertEquals($subtopicsAll, Topic::GetTopics(null, null, null, 2, 0));
$subtopicsDepth1Name = array(new Topic(14), new Topic(26), new Topic(15));
$this->assertEquals($subtopicsDepth1Name, Topic::GetTopics(null, 1, null, 2, 1,
null, array(array('field'=>'byname', 'dir'=>'asc'))));
$tree = array(
array(27=>new Topic(27)),
array(2=>new Topic(2)),
array(2=>new Topic(2), 26=>new Topic(26)),
array(2=>new Topic(2), 15=>new Topic(15)),
array(2=>new Topic(2), 15=>new Topic(15), 25=>new Topic(25)),
array(2=>new Topic(2), 15=>new Topic(15), 24=>new Topic(24)),
array(2=>new Topic(2), 14=>new Topic(14)),
array(2=>new Topic(2), 14=>new Topic(14), 22=>new Topic(22)),
array(2=>new Topic(2), 14=>new Topic(14), 19=>new Topic(19)),
array(2=>new Topic(2), 14=>new Topic(14), 16=>new Topic(16)),
array(2=>new Topic(2), 14=>new Topic(14), 16=>new Topic(16), 18=>new Topic(18)),
array(2=>new Topic(2), 14=>new Topic(14), 16=>new Topic(16), 17=>new Topic(17)),
array(3=>new Topic(3)),
array(3=>new Topic(3), 9=>new Topic(9)),
array(3=>new Topic(3), 4=>new Topic(4)),
array(1=>new Topic(1))
);
$this->assertEquals($tree, Topic::GetTree());
$subtree = array(
array(26=>new Topic(26)),
array(15=>new Topic(15)),
array(15=>new Topic(15), 25=>new Topic(25)),
array(15=>new Topic(15), 24=>new Topic(24)),
array(14=>new Topic(14)),
array(14=>new Topic(14), 22=>new Topic(22)),
array(14=>new Topic(14), 19=>new Topic(19)),
array(14=>new Topic(14), 16=>new Topic(16)),
array(14=>new Topic(14), 16=>new Topic(16), 18=>new Topic(18)),
array(14=>new Topic(14), 16=>new Topic(16), 17=>new Topic(17))
);
$this->assertEquals($subtree, Topic::GetTree(2));
$subtree = array(
array(22=>new Topic(22)),
array(19=>new Topic(19)),
array(16=>new Topic(16)),
array(16=>new Topic(16), 18=>new Topic(18)),
array(16=>new Topic(16), 17=>new Topic(17))
);
$this->assertEquals($subtree, Topic::GetTree(14));
Topic::UpdateOrder(array('topic_2'=>array('topic_26', 'topic_14', 'topic_15')));
$topic = new Topic(14);
$this->assertEquals(6, $topic->getLeft());
$this->assertEquals(17, $topic->getRight());
$topic = new Topic(15);
$this->assertEquals(18, $topic->getLeft());
$this->assertEquals(23, $topic->getRight());
$topic = new Topic(16);
$this->assertEquals(11, $topic->getLeft());
$this->assertEquals(16, $topic->getRight());
Topic::UpdateOrder(array('topic_0'=>array('topic_27', 'topic_3', 'topic_2', 'topic_1')));
$topic = new Topic(3);
$this->assertEquals(3, $topic->getLeft());
$this->assertEquals(8, $topic->getRight());
$topic = new Topic(2);
$this->assertEquals(9, $topic->getLeft());
$this->assertEquals(30, $topic->getRight());
$topic = new Topic(16);
$this->assertEquals(17, $topic->getLeft());
$this->assertEquals(22, $topic->getRight());
// test setName()
$topic->setName(1, 'My Music');
$topic = new Topic(16);
$this->assertEquals('My Music', $topic->getName(1));
// test delete()
$topic->delete(2);
$this->assertEquals('My Music', $topic->getName(1));
$this->assertEquals(1, $topic->getNumTranslations());
$topic->delete();
$topic = new Topic(15);
$this->assertEquals(18, $topic->getLeft());
$this->assertEquals(23, $topic->getRight());
$topic = new Topic(1);
$this->assertEquals(25, $topic->getLeft());
$this->assertEquals(26, $topic->getRight());
$topic = new Topic(14);
$subtopics = array(22, 19);
$this->assertEquals($subtopics, $topic->getSubtopics(true));
} // fn testCreate
/**
* Returns a topic object identified by the full name in the
* format topic_name:language_code
*
* @param string $p_fullName
* @return Topic object
*/
public static function GetByFullName($p_fullName)
{
$p_fullName = trim($p_fullName);
$last_colon_pos = strrpos($p_fullName, ':');
if (!$last_colon_pos) {
// both none colon and a single colon as a string start are wrong
return null;
}
$name = substr($p_fullName, 0, $last_colon_pos);
$languageCode = substr($p_fullName, $last_colon_pos + 1);
$languages = Language::GetLanguages(null, $languageCode, null, array(), array(), false);
if (count($languages) < 1) {
return null;
}
$languageObject = $languages[0];
$topics = Topic::GetTopics(null, $languageObject->getLanguageId(), $name);
if (count($topics) < 1) {
return null;
}
return $topics[0];
}
/**
* Returns a topic object identified by the full name in the
* format topic_name:language_code
*
* @param string $p_fullName
* @return Topic object
*/
public static function GetByFullName($p_fullName)
{
$components = preg_split('/:/', trim($p_fullName));
if (count($components) < 2) {
return null;
}
$name = $components[0];
$languageCode = $components[1];
$languages = Language::GetLanguages(null, $languageCode, null, array(), array(), false);
if (count($languages) < 1) {
return null;
}
$languageObject = $languages[0];
$topics = Topic::GetTopics(null, $languageObject->getLanguageId(), $name);
if (count($topics) < 1) {
return null;
}
return $topics[0];
} // fn GetByFullName
public function getTopics()
{
$topics = \Topic::GetTopics(null, null, null, null, 5, null, null, true, false);
return $topics['count'];
}
