<?php

namespace User\Model;

use Zend\Db\TableGateway\TableGateway;
use Zend\Db\Adapter\Adapter;
use Zend\Db\ResultSet\ResultSet;
use Zend\Db\TableGateway\AbstractTableGateway;
use Zend\Db\Sql\Expression;
use Zend\Db\Sql\Select;
use Zend\Db\Sql\Sql;
use Zend\Db\Adapter\ZendDbAdapterAdapter;
use Zend\Db\TableGateway\Feature;
use \Exception;

class FormaTable{

    protected $tableGateway;

    public function __construct(TableGateway $tableGateway, $sm){
        $this->tableGateway = $tableGateway;
        $this->sm = $sm;
    }


    public function getAll(){
        $resultSet = $this->tableGateway->select();
        return $resultSet;
    }

    public function getItemById($id)
    {
        $id = (int)$id;

        $rowset = $this->tableGateway->select(array("id" => $id));
        $row = $rowset->current();
        return $row;
    }

    public function save($data){
        $rowset = $this->tableGateway->insert($data);
    }

     public function getItems($id){
        $select = new Select;
        $resultSet = $this->tableGateway->select(function($select) use($id){
            $select->where(array('structure_id' => $id));
            $select->order('name ASC');
        });
        $result = array();
        foreach ($resultSet as $projectRow) {
            $result[$projectRow->id] = $projectRow->name;
        }
        return $result;
    }

}