function getProjects()
{
global $AppUI;
$st_projects = array(0 => '');
$q = new w2p_Database_Query();
$q->addTable('projects');
$q->addQuery('project_id, project_name, project_parent');
$q->addOrder('project_name');
$st_projects = $q->loadHashList('project_id');
reset_project_parents($st_projects);
return $st_projects;
}
/**
* Tests resetting project parents.
*/
public function testResetProjectParents()
{
global $AppUI;
$st_projects = array(0 => '');
$q = new w2p_Database_Query();
$q->addTable('projects');
$q->addQuery('project_id, project_name, project_parent');
$q->addOrder('project_name');
$st_projects = $q->loadHashList('project_id');
reset_project_parents($st_projects);
$this->assertEquals(4, count($st_projects));
$this->assertEquals(1, $st_projects[1]['project_id']);
$this->assertEquals('Test Project', $st_projects[1]['project_name']);
$this->assertEquals(1, $st_projects[1]['project_parent']);
$this->assertEquals(1, $st_projects[1][0]);
$this->assertEquals('Test Project', $st_projects[1][1]);
$this->assertEquals('', $st_projects[1][2]);
$this->assertEquals(2, $st_projects[2]['project_id']);
$this->assertEquals('Test Project 2', $st_projects[2]['project_name']);
$this->assertEquals(1, $st_projects[2]['project_parent']);
$this->assertEquals(2, $st_projects[2][0]);
$this->assertEquals('Test Project 2', $st_projects[2][1]);
$this->assertEquals(1, $st_projects[2][2]);
$this->assertEquals(3, $st_projects[3]['project_id']);
$this->assertEquals('Test Project 3', $st_projects[3]['project_name']);
$this->assertEquals(1, $st_projects[3]['project_parent']);
$this->assertEquals(3, $st_projects[3][0]);
$this->assertEquals('Test Project 3', $st_projects[3][1]);
$this->assertEquals(1, $st_projects[3][2]);
$this->assertEquals(4, $st_projects[4]['project_id']);
$this->assertEquals('Test Project 4', $st_projects[4]['project_name']);
$this->assertEquals(1, $st_projects[4]['project_parent']);
$this->assertEquals(4, $st_projects[4][0]);
$this->assertEquals('Test Project 4', $st_projects[4][1]);
$this->assertEquals(1, $st_projects[4][2]);
}
