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