public function obtenerPosterlabs()
{
$sql = new Sql($this->tableGateway->getAdapter());
$select = $sql->select();
$select->from('posterlabs');
$statement = $sql->prepareStatementForSqlObject($select);
$results = $statement->execute();
$categorias = new \ArrayObject();
foreach ($results as $row) {
$categoria = new PosterlabsAbilitato();
$categoria->exchangeArray($row);
$categorias->append($categoria);
}
// var_dump($categorias);die;
return $categorias;
}
public function listaPosizioni($id)
{
$sql = new Sql($this->tableGateway->getAdapter());
$select = $sql->select();
$select->from('posterlabs');
$select->where(array('id' => $id));
$statement = $sql->prepareStatementForSqlObject($select);
$results = $statement->execute();
$categorias = new \ArrayObject();
foreach ($results as $row) {
$categoria = new PosterlabsAbilitato();
$categoria->exchangeArray($row);
$categorias->append($categoria);
}
foreach ($categorias as $linea) {
$limite = $linea->getSteps();
}
$endb = $this->cercaPerPosterlab($id);
$presentes = array();
foreach ($endb as $sqls) {
$presentes[$sqls->getPosizione()] = $sqls->getPosizione();
}
$lista = array();
for ($i = 1; $i <= $limite; $i++) {
$lista[$i] = $i;
}
$result = array_diff($lista, $presentes);
// print_r($lista);die;//var_dump($categorias);die;
return $result;
}