public function GetAcreditacionHrsByOperationId(Gyuser_Model_Operations $obj) { $arc_hrs = 0; $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('ops' => 'operations'), array('id', 'bank_account_id')); $select->joinInner(array('bks' => 'bank_accounts'), 'ops.bank_account_id = bks.id', array('location_capital')); $select->where('ops.id = ?', $obj->getId()); $row = $table->fetchRow($select); $location_capital = $row->location_capital; $adminMapper = new Gyuser_Model_AdminDataMapper(); $adminObj = new Gyuser_Model_Admin(); $adminObj->setId(1); $adminObj = $adminMapper->find($adminObj); if ($location_capital == 1) { $arc_hrs = $adminObj->getTiempo_ac_capital(); } else { if ($location_capital == 2) { $arc_hrs = $adminObj->getTiempo_ac_interior(); } } return $arc_hrs; }