private function _addElementPerson()
{
$translate = Zend_Registry::get("Zend_Translate");
$url = new Zend_View_Helper_Url();
$urlSearch = $url->url(array('module' => 'persons', 'controller' => 'person', 'action' => 'search-form'), null, true);
$urlNew = $url->url(array('module' => 'persons', 'controller' => 'person', 'action' => 'create'), null, true);
$append = '';
$this->addElement('text', 'person_name', array('label' => 'Person', 'value' => $this->_model ? $this->_model->getPerson()->getName() : '', 'dimension' => 6, 'disabled' => true, 'placeholder' => $translate->_('Use the links aside to search a person or create a new one'), 'append' => $append . ' | ' . '<a class="hide" id="btnPersonDetails" href="#" rel="colorbox-details">' . $translate->_("Details") . '</a>' . ' | ' . '<a class="hide" id="btnPersonCreate" href="' . $urlNew . '" rel="colorbox">' . '<i class="icon-plus-sign" rel="tooltip" data-original-title="' . $translate->_("Add new") . ' ' . $translate->_("person") . '"></i>' . '</a>'));
}
/**
*
* @param integer $id The person helped id
* @return array Persons_Model_PersonHelpedSocialProject
*/
public function getSocialProjectsByPerson($id)
{
$db = $this->getDefaultAdapter();
$sql = $db->select('numero, nome, sigla, pfs_id, person.id')->from('person_programa_federal_social')->joinInner('person', 'person_programa_federal_social.person_id = person.id')->joinInner('programa_federal_social', 'person_programa_federal_social.pfs_id = programa_federal_social.id')->where('person_id = ?', $id)->order('programa_federal_social.nome');
$db->setFetchMode(Zend_DB::FETCH_ASSOC);
$r = $db->fetchAll($sql);
$socialProjects = array();
foreach ($r as $person_sprj) {
$p = new Persons_Model_PersonHelpedSocialProject();
$p->setPerson_id($id);
$p->setPfs_id($person_sprj['pfs_id']);
$p->setNome($person_sprj['nome']);
$p->setSigla($person_sprj['sigla']);
$p->setNumero($person_sprj['numero']);
$socialProjects[] = $p;
}
return $socialProjects;
}
