/**
*
* @param int $id
* @return Zend_Db_Table_Rowset
*/
public function listEnterprise($id)
{
$mapperEnterprise = new Register_Model_Mapper_Enterprise();
$select = $mapperEnterprise->getSelectEnterprise();
$dbGroupContact = App_Model_DbTable_Factory::get('SmsGroupContact');
$select->join(array('gc' => $dbGroupContact), 'gc.fk_id_fefpenterprise = e.id_fefpenterprise', array())->where('gc.fk_id_sms_group = ?', $id);
return $dbGroupContact->fetchAll($select);
}
/**
*
* @return Zend_Db_Table_Rowset
*/
public function listEnterprises()
{
$mapperEnterprises = new Register_Model_Mapper_Enterprise();
$select = $mapperEnterprises->getSelectEnterprise();
$dbFeContract = App_Model_DbTable_Factory::get('FEContract');
$select->join(array('fec' => $dbFeContract), 'fec.fk_id_fefpenterprise = e.id_fefpenterprise', array());
return $dbFeContract->fetchAll($select);
}
/**
*
* @param int $id
* @return Zend_Db_Table_Rowset
*/
public function listEntities($id)
{
$dbRegistratonEntity = App_Model_DbTable_Factory::get('FERegistrationEntity');
$mapperEduInstitute = new Register_Model_Mapper_EducationInstitute();
$selectEduInstitute = $mapperEduInstitute->getSelectEducationInstitute();
$mapperEnterprise = new Register_Model_Mapper_Enterprise();
$selectEnterprise = $mapperEnterprise->getSelectEnterprise();
$select = $dbRegistratonEntity->select()->from(array('re' => $dbRegistratonEntity))->setIntegrityCheck(false)->joinLeft(array('ee' => new Zend_Db_Expr('(' . $selectEnterprise . ')')), 'ee.id_fefpenterprise = re.fk_id_fefpenterprise', array())->joinLeft(array('ei' => new Zend_Db_Expr('(' . $selectEduInstitute . ')')), 'ei.id_fefpeduinstitution = re.fk_id_fefpeduinstitution', array('type' => "IF(re.fk_id_fefpenterprise, 'enterprise', 'institute')", 'id' => 'IFNULL(re.fk_id_fefpenterprise, re.fk_id_fefpeduinstitution)', 'name' => 'IFNULL(ee.enterprise_name, ei.institution)'))->where('re.fk_id_fe_registration = ?', $id)->where('IFNULL(re.fk_id_fefpenterprise, re.fk_id_fefpeduinstitution) IS NOT NULL');
return $dbRegistratonEntity->fetchAll($select);
}
