/** * * @param int $id * @return Zend_Db_Table_Rowset */ public function listInstitute($id) { $mapperEducationInstitue = new Register_Model_Mapper_EducationInstitute(); $select = $mapperEducationInstitue->getSelectEducationInstitute(); $dbGroupContact = App_Model_DbTable_Factory::get('SmsGroupContact'); $select->join(array('gc' => $dbGroupContact), 'gc.fk_id_fefpeduinstitution = ei.id_fefpeduinstitution', array())->where('gc.fk_id_sms_group = ?', $id); return $dbGroupContact->fetchAll($select); }
/** * * @return Zend_Db_Table_Rowset */ public function listInstitutes() { $mapperInstitute = new Register_Model_Mapper_EducationInstitute(); $select = $mapperInstitute->getSelectEducationInstitute(); $dbFeContract = App_Model_DbTable_Factory::get('FEContract'); $select->join(array('fec' => $dbFeContract), 'fec.fk_id_fefpeduinstitution = ei.id_fefpeduinstitution', array()); return $dbFeContract->fetchAll($select); }
/** * * @return Zend_Db_Select */ public function getSelect() { $dbAnnualPlanning = App_Model_DbTable_Factory::get('FPAnnualPlanning'); $dbPlanningCourse = App_Model_DbTable_Factory::get('FPPlanningCourse'); $dbPerScholarity = App_Model_DbTable_Factory::get('PerScholarity'); $mapperInstitute = new Register_Model_Mapper_EducationInstitute(); $select = $mapperInstitute->getSelectEducationInstitute(); $select->reset(Zend_Db_Select::GROUP); $select->join(array('ap' => $dbAnnualPlanning), 'ap.fk_id_fefpeduinstitution = ei.id_fefpeduinstitution', array('id_annual_planning', 'year_planning', 'total_students', 'total_cost'))->join(array('pc' => $dbPlanningCourse), 'pc.fk_id_annual_planning = ap.id_annual_planning', array('id_planning_course', 'date_start', 'date_finish', 'total_man', 'total_woman', 'students_course' => 'total_students', 'cost_course' => 'total_cost', 'fk_id_fefpstudentclass'))->join(array('ps' => $dbPerScholarity), 'pc.fk_id_perscholarity = ps.id_perscholarity', array('id_perscholarity', 'scholarity', 'external_code', 'category'))->group(array('pc.id_planning_course'))->order(array('ap.year_planning DESC', 'pc.date_start')); return $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); }