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]); }