public function buscaPadrao($filter = array())
{
$City = new Model_City();
$Neighborhood = new Model_Neighborhood();
$request = $this->view->request();
$this->view->controller = $request->getControllerName();
$this->view->action = $request->getActionName();
$this->view->filter = $filter;
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']);
}
return $this->setModuleScriptPath('default')->render('busca-padrao/form.phtml');
}
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();
}
