/** * encontra gestores de uma determinada UF */ public function gestoresDaUfParaReceberemFaleConosco($uf) { $modelState = new Model_State(); $objState = $modelState->getStateByUf($uf); $stateId = $objState->getId(); //echo "<br>stateId: ".$stateId; $gestoresFetchAll = $this->getGestorPorEstado($stateId, 'all'); //var_dump('gestores',$gestores); return $gestoresFetchAll; }
public function indexAction() { //Listar Regional if ($this->_getParam('listar') == 'ok') { $this->_helper->Regional->regionalModel = $this->regionalModel; $this->_helper->Regional->stateModel = $this->stateModel; $this->_helper->Regional->serviceAreaModel = $this->serviceAreaModel; $this->_helper->Regional->roleRow = $this->roleRow; $this->_helper->Regional->aclModel = $this->aclModel; $this->_helper->Regional->userAuth = $this->userAuth; $this->_helper->Regional->userLocalityModel = $this->userLocalityModel; $this->_helper->Regional->listarEditarRegional($this->_getAllParams(), $this->view); $this->_helper->viewRenderer->setRender('edit'); return; } $State = new Model_State(); $this->view->getAllStates = $State->getAll(); $listAdmin = false; $page = $this->_getParam('page'); $count = $this->_getParam('count', 150); $orderBy = $this->view->orderBy = $this->_getParam('orderBy'); $filter = $this->view->filter = $this->_getParam('filter'); if ($this->roleRow->getIsSystemAdmin() == 1) { $this->view->getAll = $this->regionalModel->getAll(null, $orderBy, $count, $page, $filter); $listAdmin = true; } if ($this->aclModel->isAllowed($this->userAuth->getRole(), 'management:regional', 'list-address-by-regional')) { if (!$listAdmin) { $userLocality = $this->userLocalityModel->getUserLocalityByUserId($this->userAuth->getUserId()); $regionalId = $userLocality->getRegionalId(); $filter['regional_not'] = $regionalId; $filter['filterByStateRegional'] = '1'; $this->view->getAll = $this->regionalModel->getAllRegionalByOneRegionalServiceArea(null, $regionalId, $filter, $orderBy, $count, $page); } } }
public function editAction() { $Acl = Zend_Registry::get('acl'); $auth = Zend_Auth::getInstance(); $State = new Model_State(); $City = new Model_City(); $Neighborhood = new Model_Neighborhood(); $Appraiser = new Model_Appraiser(); $appraiserId = $this->_getParam('id'); $appraiserRow = $this->modelUser->getUserById($appraiserId); if (!$appraiserRow) { throw new Exception('invalid appraiser.'); } $this->view->appraiserRow = $appraiserRow; $listAdmin = false; $userLoggedRow = $this->userAuth; $userLocality = $this->modelUserLocality->getUserLocalityByUserId($userLoggedRow->getUserId()); $roleRow = $this->aclModel->getRoleById($userLoggedRow->getRoleId(), false); $page = $this->_getParam('page', 1); $count = $this->_getParam('count', 10); $this->view->page = $page; $this->view->itensPage = $count; $filter = $this->_getParam('filter', null); $this->view->filter = $filter; $this->view->getAllStates = $State->getAll(); if (isset($filter['state_id']) and !empty($filter['state_id'])) { $this->view->getAllCities = $City->getAllCityByStateId($filter['state_id']); } if (isset($filter['city_id']) and !empty($filter['city_id'])) { $this->view->getAllNeighborhoods = $Neighborhood->getAllNeighborhoodByCityId($filter['city_id']); } // Listagem dos Avaliadores pelo admin if ($roleRow->getIsSystemAdmin() == 1) { // eh admin // lista Empresas $getAllEnterprise = $this->Enterprise->getAllWithRa($this->autoavaliacaoId, $count, $page, $filter); $this->view->getAllEnterpriseByRegionalServiceArea = $getAllEnterprise; //-- $getAllRegional = $this->modelRegional->getAll(); $this->view->getAllRegional = $getAllRegional; $listAdmin = true; } // Listagem dos Avaliadores pelo gestor if ($Acl->isAllowed($auth->getIdentity()->getRole(), 'management:appraiser', 'list-appraiser-by-regional-service-area')) { if (!$listAdmin) { $userLocality = $this->modelUserLocality->getUserLocalityByUserId($userLoggedRow->getUserId()); //$regionalId = ($filter['regional_id'])?$filter['regional_id']:$userLocality->getRegionalId(); $regionalIdUserLogged = $userLocality->getRegionalId(); $this->view->getAllRegional = $this->dbTable_Regional->getAllRegionalByOneRegionalServiceArea($this->roleAppraiserId, $regionalIdUserLogged, 'all', $filter); // Listar Empresas por RegionalSA $getAllEnterpriseByRegionalServiceArea = $this->Enterprise->getAllEnterpriseByRegionalServiceArea($regionalIdUserLogged, $count, $page, $filter); $this->view->getAllEnterpriseByRegionalServiceArea = $getAllEnterpriseByRegionalServiceArea; //-- } } if ($filter) { return; } if (!$this->getRequest()->isPost()) { return; } }
public function indexAction() { if (!isset($this->tipoRelatorio)) { $this->tipoRelatorio = 'inscricoes'; } $State = new Model_State(); $City = new Model_City(); $model_Metier = new Model_Metier(); $dbTable_Regional = new DbTable_Regional(); $modelUserLocality = new Model_UserLocality(); $modelRegional = new Model_Regional(); $Neighborhood = new Model_Neighborhood(); $Regiao = new Model_Regiao(); $Configuration = new Model_Configuration(); $modelEnterpriseCategoryAward = new Model_EnterpriseCategoryAward(); $enterprise = new Model_Enterprise(); $ApeEvaluationVerificador = new Model_ApeEvaluationVerificador(); // Sandra - acessar ciclo atual $currentYearRow = $Configuration->getConfigurationByConfKey('competitionIdKey'); $this->view->ciclo = $currentYearRow->getConfValue(); $this->view->cicloAnt = $this->view->ciclo - 1; $format = $this->_getParam('format'); $this->view->getAllEducations = $this->Education->getAll(); if ($format == 'csv') { //$this->view->getAllPosition = $this->modelPosition->getAll(); $this->_dorelatorio(); $this->incluirJoinPontuacao = '1'; $this->incluirJoinRegional = '1'; } set_time_limit(720); //6 minutos $ns = new Zend_Session_Namespace('respond'); $ns->enterpriseUserId = null; //constroi url para CSV $this->view->urlParaGerarCsv = $this->_construirUrlParaCsv(); $this->view->getAllEnterpriseCategoryAward = $modelEnterpriseCategoryAward->getAll(); //finalistas estaduais $this->view->getAllApeEvaluationVerificador = $ApeEvaluationVerificador->getAll(); //$this->view->getAllAnswerVerificador = $modelAnswerVerificador->getAllScore(); $this->view->getAllRegiao = $Regiao->getAll(); $this->view->getAllMetier = $model_Metier->getAll(); $this->view->isRanking = isset($this->view->isRanking) ? $this->view->isRanking : false; $this->filterAdditional = isset($this->filterAdditional) ? $this->filterAdditional : $this->_getParam('filter'); $filter = $this->filterAdditional; $this->view->filter = $filter; $this->view->hasFilterRegional = true; $this->view->hasFilterStatus = true; $this->view->getAllStates = $State->getAll(); if (isset($filter['state_id']) and !empty($filter['state_id'])) { $this->view->getAllCities = $City->getAllCityByStateId($filter['state_id']); } if (isset($filter['city_id']) and !empty($filter['city_id'])) { $this->view->getAllNeighborhoods = $Neighborhood->getAllNeighborhoodByCityId($filter['city_id']); } $this->view->competitionId = Zend_Registry::get('configDb')->competitionId; $this->view->getAllCompetition = $this->modelCompetition->getAllCompetition(); $userLoggedRow = $this->userAuth; //$roleRow = $this->aclModel->getRoleById($userLoggedRow->getRoleId(), false); $page = $this->_getParam('page'); $count = $this->_getParam('count', 10); $this->orderBy = isset($this->orderBy) ? $this->orderBy : null; $orderBy = $this->view->orderBy = $this->_getParam('orderBy', $this->orderBy); $filter['appraiser_id'] = isset($filter['appraiser_id']) ? $filter['appraiser_id'] : null; $filter['incluir_join_pontuacao'] = isset($this->incluirJoinPontuacao) ? $this->incluirJoinPontuacao : '0'; $filter['incluir_join_regional'] = isset($this->incluirJoinRegionalForce) ? $this->incluirJoinRegionalForce : (isset($this->incluirJoinRegional) ? $this->incluirJoinRegional : '0'); $this->view->regionalOption = 'Minha'; // List Coop by Regional $regionalId = $modelUserLocality->getUserLocalityByUserId($userLoggedRow->getUserId())->getRegionalId(); $this->view->getAllRegional = $getAllRegional = $dbTable_Regional->getAllRegionalByOneRegionalServiceArea(null, $regionalId, 'all', $filter); // $this->roleAppraiserId if (isset($filter['regional_id']) and $filter['regional_id']) { $regionalId = $filter['regional_id']; } if ($this->showAppraisersFilter) { //$filterAp['status'] = 'A'; ,$filterAp $this->view->getAllAppraisers = $this->dbTableUser->getAllAppraiserByRegionalServiceArea(null, $regionalId, array('appraiser_status' => 'able')); } if (!$format) { return; } $groupBy = in_array($this->tipoRelatorio, array('inscricoes', 'ranking', 'classificadas', 'finalistas', 'finalistas-nacional', 'candidatas-nacional', 'classificadas-nacional')) ? 'enterprise_id' : null; $this->regionalId = $regionalId; $this->filter = $filter; $this->paramsBuscaServiceArea = $regionalId ? $modelRegional->getServiceAreaByRegionalId($regionalId) : array(0 => null, 1 => null); $fetchReturn = isset($this->fetchReturnForce) ? $this->fetchReturnForce : (isset($this->fetchReturn) ? $this->fetchReturn : 'paginator'); if ($this->tipoRelatorio != 'inscricoes' || $format == 'csv') { $this->view->getAllEnterprise = $this->Enterprise->getAllByColAE($this->paramsBuscaServiceArea[0], $this->paramsBuscaServiceArea[1], $this->autoavaliacaoId, $count, $page, $filter, $orderBy, $format, $fetchReturn, $this->tipoRelatorio, $groupBy); } else { $loggedUserId = $this->userAuth->getUserId(); $this->view->getAllEnterprise = $this->Enterprise->getPaginatorForSubscriptions($loggedUserId, $filter, $count, $page); } $this->view->modelEntCategoryAward = new Model_EnterpriseCategoryAwardCompetition(); }
public function filterAddressToInsertRegional($data) { $cityModel = new Model_City(); $stateModel = new Model_State(); $dbTable_City = new DbTable_City(); $neighborhoodModel = new Model_Neighborhood(); $filter = array('getAllStates' => null, 'getAllCities' => null, 'getAllNeighborhoods' => null); switch ($data['indice']) { case 'StateId': $filter['allStateId'] = $data['dados']; $filter['getAllStates'] = $stateModel->getAll(); break; case 'CityId': $filter['allCityId'] = $data['dados']; $city = $dbTable_City->getById($data['dados'][0]['CityId']); $stateId = $city->getStateId(); $filter['allStateId'] = array(0 => array('StateId' => $stateId)); $localData['uf'] = $city->getUf(); break; case 'NeighborhoodId': $filter['allNeighborhoodId'] = $data['dados']; $neighborhood = $neighborhoodModel->getNeighborhoodById($data['dados'][0]['NeighborhoodId']); $cityId = $neighborhood->getCityId(); $state = $stateModel->getStateByUf($neighborhood->getUf()); $filter['allCityId'] = array(0 => array('CityId' => $cityId)); $filter['allStateId'] = array(0 => array('StateId' => $state->getId())); $localData['uf'] = $neighborhood->getUf(); $localData['city_id'] = $cityId; break; default: break; } $filter['getAllStates'] = $stateModel->getAll(); if (isset($localData['uf'])) { $filter['getAllCities'] = $cityModel->getAllCityByUf($localData['uf']); } if (isset($localData['city_id'])) { $filter['getAllNeighborhoods'] = $neighborhoodModel->getAllNeighborhoodByCityId($localData['city_id']); } return $filter; }