/** * * @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); }