/**
* [findSegmentByTypeSegment description]
* @param ServiceLocator $sm
* @param int $typeSegment (ID du type de segment)
* @return array (Array de Segment)
*/
public function findSegmentByTypeSegment($sm, $typeSegment)
{
$idType = (int) $typeSegment;
$query = "SELECT id, intitule_segment \n FROM segment\n WHERE ref_type_segment = {$idType}";
$statement = $sm->get('Zend\\Db\\Adapter\\Adapter')->query($query);
$results = $statement->execute();
if ($results->isQueryResult()) {
$resultSet = new ResultSet();
$resultSet->initialize($results);
return $resultSet->toArray();
}
return array();
}
public function testOffsetSet()
{
$resultSet = new ResultSet(array('a' => array('_id' => 'a', 'field' => 'value1'), 'b' => array('_id' => 'b', 'field' => 'value2'), 'c' => array('_id' => 'c', 'field' => 'value3')));
$resultSet['d'] = array('_id' => 'd', 'field' => 'value4');
$this->assertEquals(array('a' => array('_id' => 'a', 'field' => 'value1'), 'b' => array('_id' => 'b', 'field' => 'value2'), 'c' => array('_id' => 'c', 'field' => 'value3'), 'd' => array('_id' => 'd', 'field' => 'value4')), $resultSet->toArray());
}
