public function getAll() { try { $pData = new DateTime($this->getData()); $sql = "SELECT id, cc, total\n FROM hor_aprop\n WHERE cod_prof_funcao = " . $this->getCodProfFuncao() . " AND data = '" . $pData->format("Y-m-d") . "';"; $rs = parent::obterRecordSet($sql); $vAprop = array(); foreach ($rs as $row) { $oAprop = new Apropriacao(); $oAprop->setId($row["id"]); $oAprop->setCc($row["cc"]); $oAprop->setCodProfFuncao($this->getCodProfFuncao()); $oAprop->setData($pData->format("d-m-Y")); $oAprop->setValor($row["total"]); $vAprop[] = $oAprop; unset($oAprop); } return $vAprop; } catch (Exception $e) { throw new Exception($e->getMessage()); } }