예제 #1
0
 public function execute($context)
 {
     $context['APPLICATION']->AddHeadScript('/js/forms.js');
     $context['APPLICATION']->AddHeadScript('/js/icheck/icheck.min.js');
     $context['APPLICATION']->SetAdditionalCSS('/js/icheck/skins/minimal/eco.css');
     // проверка прав доступа к разделу
     if (!$this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'members', $context['project']['projectID'])) {
         $this->registry->getModel('Auth')->restrict();
     }
     $this->component->arResult['canImport'] = $this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'imports', $context['project']['projectID']);
     $isProjectAdmin = $this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'project_edit', $context['project']['projectID']);
     $this->component->arResult['isProjectAdmin'] = $isProjectAdmin;
     $selectedIDs = array();
     // обнуление заполнения
     $this->component->arResult['isAdmin'] = $_SESSION['accesses']['is_admin'] ? true : false;
     if (isset($_POST['reseted_id'])) {
         $selectedIDs[] = $_POST['reseted_id'];
         $seance = $this->registry->getDbHelper('SeancesHelper')->findSeanceByRespondentAndProject($_POST['reseted_id'], $context['project']['projectID']);
         if ($seance) {
             // деактивируем текущий сеанс
             $this->registry->getDbHelper('SeancesHelper')->editSeance($seance['seanceID'], array('active' => 0, 'private_access_key' => ''));
             $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'seance', $seance['seanceID'], LogsHelper::ACTION_TYPE_DELETE, $seance);
             // создаем новый сеанс
             $BlankDataSource = new \Ecoplay\Model\BlankDataSource($this->registry->getDbConnect(), 0, 0);
             $seanceKey = $BlankDataSource->addSeanceAndCookies($seance['private_access_key']);
             $seance = $this->registry->getDbHelper('SeancesHelper')->findSeanceByKey($seanceKey);
             $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'seance', $seance['seanceID'], LogsHelper::ACTION_TYPE_ADD, null);
             //ставим флаг чтобы данные по отчету для оцениваемого пересчитались
             $respondent = $this->registry->getDbHelper('MembersHelper')->findRespondentById($seance['respondentID']);
             $assessCompetencyData = $this->registry->getDbHelper('CompetencyHelper')->getAssessCompetencyData($respondent['stat1_assessID']);
             if ($assessCompetencyData) {
                 $this->registry->getDbHelper('CompetencyHelper')->editAssessCompetency($assessCompetencyData['ID'], array('need_recount' => 1));
             }
         }
     }
     $availableSessionsIDs = $this->registry->getModel('Auth')->getAvailableSessions($_SESSION['accesses'], $context['project']['projectID']);
     $sessions = $this->registry->getDbHelper('ProjectsHelper')->getUserAvailableSessionsByProjectID($context['project']['projectID'], $availableSessionsIDs);
     $this->component->arResult['jsessions'] = json_encode($sessions);
     $this->component->arResult['sessions'] = $sessions;
     $sorts = array('respondentID' => 'respondentID', 'assess' => 'assess', 'assess_email' => 'assess_email', 'assess_position' => 'assess_position', 'role' => 'role', 'respondent' => 'respondent', 'email' => 'email', 'position' => 'position', 'percent' => 'percent', 'sessionID' => 'sessionID', 'seanceID' => 'seanceID', 'sortby' => 'sortby');
     if (isset($_GET['sort']) && array_key_exists($_GET['sort'], $sorts)) {
         $sort = $_GET['sort'];
     } else {
         $sort = 'respondentID';
     }
     $order = isset($_GET['order']) && in_array($_GET['order'], array('asc', 'desc')) ? $_GET['order'] : 'asc';
     $filterQueryString = DataFilter::getFilterQueryString($_GET);
     $this->component->arResult['filterQueryString'] = $filterQueryString;
     // настройки фильтров для данных
     $filters = array(0 => array('title' => 'Оцениваемый Имя', 'name' => 'assess_name', 'type' => 'text', 'data_type' => 'string', 'field' => 'pma.`name`'), 1 => array('title' => 'Оцениваемый Фамилия', 'name' => 'assess_surname', 'type' => 'text', 'data_type' => 'string', 'field' => 'pma.`surname`'), 2 => array('title' => 'Оцениваемый ID', 'name' => 'assess_id', 'type' => 'text', 'data_type' => 'number', 'field' => 'a.`assessID`'), 3 => array('title' => 'Респондент Имя', 'name' => 'respondent_name', 'type' => 'text', 'data_type' => 'string', 'field' => 'pm.`name`'), 4 => array('title' => 'Респондент Фамилия', 'name' => 'respondent_surname', 'type' => 'text', 'data_type' => 'string', 'field' => 'pm.`surname`'), 5 => array('title' => 'Респондент ID', 'name' => 'respondent_id', 'type' => 'text', 'data_type' => 'number', 'field' => 'r.`respondentID`'), 6 => array('title' => 'Текст', 'name' => 'text', 'type' => 'text', 'data_type' => 'string', 'field' => array('pma.`search_text`', 'pm.`search_text`', 'rt.`name`')), 7 => array('title' => 'Группа ', 'name' => 'session_id', 'type' => 'select', 'data_type' => 'number', 'field' => 's.`sessionID`', 'values' => array(0 => 'Любая') + $sessions));
     $filterData = array('FILTERS' => $filters, 'BASE_URL' => '/projects/' . $context['project']['projectID'] . '/members/scheme360/', 'SORT' => $sort, 'ORDER' => $order);
     // проверяем, введен ли фильтр
     $filterValue = DataFilter::getFilterValue($filters, $_GET, $this->registry->getDbConnect());
     if ($filterValue['valid']) {
         $filterData = array_merge($filterData, $filterValue);
     }
     // компонент отображения фильтра
     $context['APPLICATION']->IncludeComponent('ecoplay:data.filter', '', $filterData);
     $cnt = $this->registry->getDbHelper('MembersHelper')->getRespondentsForScheme360Cnt($context['project']['projectID'], $availableSessionsIDs, $filterValue['filter_strings']);
     $onPage = 100;
     $pagesCnt = ceil($cnt / $onPage);
     $page = $_GET['PAGE'] && $_GET['PAGE'] <= $pagesCnt ? intval($_GET['PAGE']) : 1;
     if ($isProjectAdmin && isset($_POST['deny'])) {
         if (isset($_POST['all']) && $_POST['all']) {
             $selectedIDs = $this->registry->getDbHelper('MembersHelper')->getRespondentsIDsForScheme360($context['project']['projectID'], $availableSessionsIDs, $filterValue['filter_strings']);
         } else {
             $selectedIDs = $_POST['respondents_ids'];
         }
         $this->registry->getDbHelper('MembersHelper')->editRespondents($selectedIDs, array('deny_deletion' => 1));
     }
     $this->component->arResult['selectedIDs'] = $selectedIDs;
     $respondents = $this->registry->getDbHelper('MembersHelper')->getRespondentsForScheme360($context['project']['projectID'], $availableSessionsIDs, $page, $onPage, $sorts[$sort], $order, $filterValue['filter_strings']);
     $this->component->arResult['respondents'] = $respondents;
     if (isset($_GET['checkAll'])) {
         $selectedIDs = array();
         foreach ($respondents as $responent) {
             $selectedIDs[] = $responent['respondentID'];
         }
         $this->component->arResult['selectedIDs'] = $selectedIDs;
     }
     $viewHelper = new \Ecoplay\View\Helper();
     $this->component->arResult['sort'] = $sort;
     $this->component->arResult['order'] = $order;
     $this->component->arResult['cntInfo'] = $pagesCnt == 1 ? $cnt : 0;
     $roles = $this->registry->getDbHelper('ProjectsHelper')->getProjectRoles($context['project']['projectID']);
     $selfRoleID = 0;
     foreach ($roles as $role) {
         if ($role['fixed_role'] == 'self') {
             $selfRoleID = $role['roleID'];
             break;
         }
     }
     $this->component->arResult['selfRoleID'] = $selfRoleID;
     // выводим таблицу с данными
     $this->component->IncludeComponentTemplate('table');
     $navResult = new \CDBResult();
     $navResult->NavPageCount = ceil($cnt / $onPage);
     $navResult->NavPageNomer = $page;
     $navResult->NavNum = 1;
     $navResult->NavPageSize = $onPage;
     $navResult->NavRecordCount = $cnt;
     $navResult->nPageWindow = 11;
     $context['APPLICATION']->IncludeComponent('ecoplay:system.pagenavigation', '', array('NAV_RESULT' => $navResult, 'NAV_URL' => '/projects/' . $context['project']['projectID'] . '/members/scheme360/', 'NAV_QUERY_STRING' => 'sort=' . $sort . '&order=' . $order . ($filterQueryString ? '&' . $filterQueryString : '') . (isset($_GET['checkAll']) ? '&checkAll=1' : '')));
     $context['APPLICATION']->SetPageProperty('pageMainTitle', 'Схема 360&deg;');
     $context['APPLICATION']->SetPageProperty('navigation', $viewHelper->generateNavigation(array(0 => array('link' => '/', 'title' => 'Главная'), 1 => array('link' => '/projects/', 'title' => 'Проекты'), 2 => array('link' => '/projects/' . $context['project']['projectID'] . '/continuing/stat/', 'title' => $context['project']['project_name']), 3 => array('title' => 'Схема 360&deg;'))));
     $this->component->IncludeComponentTemplate();
 }
예제 #2
0
 public function execute($context)
 {
     // проверка прав доступа к разделу
     if (!$this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'members', $context['project']['projectID'])) {
         $this->registry->getModel('Auth')->restrict();
     }
     $context['APPLICATION']->AddHeadScript('/js/forms.js');
     $context['APPLICATION']->AddHeadScript('/js/icheck/icheck.min.js');
     $context['APPLICATION']->SetAdditionalCSS('/js/icheck/skins/minimal/eco.css');
     if (isset($_POST['type'])) {
         if ($_POST['type'] == 'exist') {
             if (isset($_POST['member_id'])) {
                 // проверяем, может уже есть респондент с таким участником
                 $existRespondent = $this->registry->getDbHelper('MembersHelper')->findRespondentByMemberIDAndSessionID($context['project']['projectID'], $_POST['member_id'], $_POST['session_id']);
                 if (!$existRespondent) {
                     // добавляем респондента
                     $respondentID = $this->registry->getDbHelper('MembersHelper')->addRespondent(array('project_memberID' => intval($_POST['member_id']), 'active' => 1, 'projectID' => $context['project']['projectID'], 'sessionID' => intval($_POST['session_id']), 'stat1_assessID' => 0, 'status' => \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_NEW, 'private_access_key' => $this->registry->getModel('Auth')->generateUid('prep_respondents', 'private_access_key'), 'stat1_roleID' => 0, 'last_email' => '0000-00-00 00:00:00', 'langID' => 0, 'last_entrance' => '0000-00-00 00:00:00', 'deny_deletion' => 0, 'addedd_by_assess' => 0, 'need_remind' => 0));
                     $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondentID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                 }
             }
         } else {
             // пробуем добавить участника
             $validations = array('name' => 'anything', 'surname' => 'anything', 'email' => 'email', 'position' => 'anything', 'department' => 'anything', 'language' => 'identifier');
             $required = array('name', 'email', 'language');
             $validator = new \Ecoplay\Form\Validator($validations, $required, array());
             if ($validator->validate($_POST)) {
                 // проверяем чтобы не было уже участника с таким email
                 if (!$this->registry->getDbHelper('MembersHelper')->findByEmailAndProjectId($_POST['email'], $context['project']['projectID'])) {
                     $memberID = $this->registry->getDbHelper('MembersHelper')->addMember(trim($_POST["name"]), trim($_POST["surname"]), trim($_POST["position"]), trim($_POST["email"]), $context['project']['projectID'], $this->registry->getModel('Auth')->generateUid('prep_projects_members', 'private_lk_access_key'), intval($_POST["language"]), 1, 'new', trim($_POST['department']));
                     $eventListener = new EventListener($this->registry, $context['project'], $_SERVER["DOCUMENT_ROOT"] . '/');
                     $eventListener->executeEvent('MemberAdded', array('memberID' => $memberID), true);
                     $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'member', $memberID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                     // добавляем респондента
                     $respondentID = $this->registry->getDbHelper('MembersHelper')->addRespondent(array('project_memberID' => $memberID, 'active' => 1, 'projectID' => $context['project']['projectID'], 'sessionID' => intval($_POST['session_id']), 'stat1_assessID' => 0, 'status' => \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_NEW, 'private_access_key' => $this->registry->getModel('Auth')->generateUid('prep_respondents', 'private_access_key'), 'stat1_roleID' => 0, 'last_email' => '0000-00-00 00:00:00', 'langID' => 0, 'last_entrance' => '0000-00-00 00:00:00', 'deny_deletion' => 0, 'addedd_by_assess' => 0, 'need_remind' => 0));
                     $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondentID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                 } else {
                     $this->component->arResult['statusError'] = 'Участник с таким email (' . $_POST['email'] . ') уже существует';
                 }
             }
         }
     }
     if ($_FILES["filepath"] && !$_FILES['filepath']['error']) {
         $sessionID = (int) $_POST["fgroup"];
         if ($sessionID) {
             $session = $this->registry->getDbHelper('ProjectsHelper')->findSessionById($sessionID);
         }
         // обрабатываем загруженный файл
         $csvImporter = new \Ecoplay\Import\Csv($_FILES["filepath"]["tmp_name"], $_SERVER["DOCUMENT_ROOT"] . "/temp/csv/");
         $data = $csvImporter->parse();
         $sessionIndex = $csvImporter->getColumnIndex('Группа');
         if (!((!$sessionIndex || !$data[0][$sessionIndex]) && (!$sessionID || !$session))) {
             // определяем группу
             if ($sessionIndex && $data[0][$sessionIndex]) {
                 // ищем группу
                 $session = $this->registry->getDbHelper('ProjectsHelper')->findSessionByProjectIDAndName($context['project']['projectID'], $data[0][$sessionIndex]);
                 if ($session) {
                     $sessionID = $session['sessionID'];
                 } else {
                     $session = array('name' => $data[0][$sessionIndex], 'active' => 1, 'status' => 'active', 'projectID' => $context['project']['projectID']);
                     $sessionID = $this->registry->getDbHelper('ProjectsHelper')->addSession($session);
                     $session['sessionID'] = $sessionID;
                 }
             }
             $inserted = $skipped = 0;
             $validations = array(0 => 'anything', 1 => 'anything', 2 => 'email', 3 => 'anything', 4 => 'anything');
             $required = array(2);
             $validator = new \Ecoplay\Form\Validator($validations, $required, array());
             $projectLangID = $this->registry->getModel('Projects')->getDefaultLangID($context['project']);
             $languageIndex = $csvImporter->getColumnIndex('Язык');
             $languagesIDs = array();
             $availableLanguages = $this->registry->getDbHelper('TranslationHelper')->getLanguagesByIDs(json_decode($context['project']['~languages']));
             foreach ($availableLanguages as $language) {
                 $languagesIDs[$language['abbr']] = $language['langID'];
             }
             foreach ($data as $row) {
                 if ($sessionIndex && $row[$sessionIndex] && $row[$sessionIndex] != $session['name']) {
                     // ищем группу
                     $session = $this->registry->getDbHelper('ProjectsHelper')->findSessionByProjectIDAndName($context['project']['projectID'], $row[$sessionIndex]);
                     if ($session) {
                         $sessionID = $session['sessionID'];
                     } else {
                         $session = array('name' => $row[$sessionIndex], 'active' => 1, 'status' => 'active', 'projectID' => $context['project']['projectID']);
                         $sessionID = $this->registry->getDbHelper('ProjectsHelper')->addSession($session);
                         $session['sessionID'] = $sessionID;
                     }
                 }
                 // валидируем исходные данные
                 if (!$validator->validate($row)) {
                     $skipped++;
                 } elseif (!$row[0] && !$row[1]) {
                     // должно быть хотябы или имя, или фамилия
                     $skipped++;
                 } else {
                     // ищем такого участника уже в базе
                     $member = $this->registry->getDbHelper('MembersHelper')->findByEmailAndProjectId($row[2], $context['project']['projectID']);
                     if (!$member) {
                         // добавляем участника
                         // определяем язык по структуре
                         $staff = $this->registry->getDbHelper('MembersHelper')->findStaffByProjectIDAndEmail($context['project']['projectID'], $row[2]);
                         $langID = $languageIndex && $row[$languageIndex] && array_key_exists($row[$languageIndex], $languagesIDs) ? $languagesIDs[$row[$languageIndex]] : $projectLangID;
                         $memberID = $this->registry->getDbHelper('MembersHelper')->addMember($row[0], $row[1], $row[3], $row[2], $context['project']['projectID'], $this->registry->getModel('Auth')->generateUid('prep_projects_members', 'private_lk_access_key', false), $langID, 1, 'new', $row[4]);
                         $eventListener = new EventListener($this->registry, $context['project'], $_SERVER["DOCUMENT_ROOT"] . '/');
                         $eventListener->executeEvent('MemberAdded', array('memberID' => $memberID, 'staff' => $staff), true);
                         $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'member', $memberID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                     } else {
                         $memberID = $member['projects_memberID'];
                     }
                     if ($this->registry->getDbHelper('MembersHelper')->findRespondentByProjectIDAndSessionIDAndMemberID($context['project']['projectID'], $sessionID, $memberID)) {
                         // такой оцениваемый уже есть
                         $skipped++;
                     } else {
                         $respondentID = $this->registry->getDbHelper('MembersHelper')->addRespondent(array('projectID' => $context['project']['projectID'], 'sessionID' => $sessionID, 'project_memberID' => $memberID, 'active' => 1, 'status' => 'new', 'stat1_assessID' => 0, 'private_access_key' => $this->registry->getModel('Auth')->generateUid('prep_respondents', 'private_access_key', false), 'stat1_roleID' => 0));
                         $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondentID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                         $inserted++;
                     }
                 }
             }
             $this->component->arResult['statusSuccess'] = 'Импортировано: ' . $inserted . ', проигнорировано: ' . $skipped;
         }
     }
     $statuses = $this->registry->getDbHelper('MembersHelper')->getLinearRespondentsStatusesNames();
     $this->component->arResult['statuses'] = $statuses;
     $sorts = array('respondentID' => 'respondentID', 'name' => 'name', 'surname' => 'surname', 'email' => 'email', 'position' => 'position', 'status' => 'status', 'private_lk_access_key' => 'private_lk_access_key');
     if (isset($_GET['sort']) && array_key_exists($_GET['sort'], $sorts)) {
         $sort = $_GET['sort'];
     } else {
         $sort = 'respondentID';
     }
     $order = isset($_GET['order']) && in_array($_GET['order'], array('asc', 'desc')) ? $_GET['order'] : 'asc';
     $filterQueryString = DataFilter::getFilterQueryString($_GET);
     $this->component->arResult['filterQueryString'] = $filterQueryString;
     // настройки фильтров для данных
     $filters = array(0 => array('title' => 'Имя', 'name' => 'name', 'type' => 'text', 'data_type' => 'string', 'field' => 'm.`name`'), 1 => array('title' => 'Фамилия', 'name' => 'surname', 'type' => 'text', 'data_type' => 'string', 'field' => 'm.`surname`'), 2 => array('title' => 'ID', 'name' => 'id', 'type' => 'text', 'data_type' => 'number', 'field' => 'r.`respondentID`'), 3 => array('title' => 'Текст', 'name' => 'text', 'type' => 'text', 'data_type' => 'string', 'field' => array('m.`search_text`')), 4 => array('title' => 'Статус ', 'name' => 'status', 'type' => 'select', 'data_type' => 'string', 'field' => 'r.`status`', 'values' => array(0 => 'Любой') + $statuses));
     $filterData = array('FILTERS' => $filters, 'BASE_URL' => '/projects/' . $context['project']['projectID'] . '/groups/' . (isset($_GET['TYPE']) && $_GET['TYPE'] ? $_GET['TYPE'] . '/' : '') . 'respondents/', 'SORT' => $sort, 'ORDER' => $order);
     // проверяем, введен ли фильтр
     $filterValue = DataFilter::getFilterValue($filters, $_GET, $this->registry->getDbConnect());
     if ($filterValue['valid']) {
         $filterData = array_merge($filterData, $filterValue);
     }
     // компонент отображения фильтра
     $context['APPLICATION']->IncludeComponent('ecoplay:data.filter', '', $filterData);
     // выполняем с респондентами действия
     if (isset($_POST['respondents_ids'])) {
         if (isset($_POST['all']) && $_POST['all']) {
             $selectedIDs = $this->registry->getDbHelper('LinearProjectsHelper')->getProjectRespondentsIDs($context['project']['projectID'], $filterValue['filter_strings']);
         } else {
             $selectedIDs = $_POST['respondents_ids'];
         }
         if (isset($_POST['mode'])) {
             if ($_POST['mode'] == 'send_notifications') {
                 $editedRespondents = $this->registry->getDbHelper('LinearProjectsHelper')->getRespondentsByIDs($selectedIDs);
                 $this->registry->getDbHelper('MembersHelper')->editRespondents($selectedIDs, array('need_remind' => 1));
                 foreach ($editedRespondents as $respondent) {
                     $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondent['respondentID'], \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_CHANGE, $respondent);
                 }
             } elseif ($_POST['mode'] == 'reset') {
                 /*$editedRespondents =  $this->registry->getDbHelper('LinearProjectsHelper')->getRespondentsByIDs($selectedIDs);
                   
                   $this->registry->getDbHelper('MembersHelper')->editRespondents($selectedIDs, array(
                     'status'  => \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_ACTIVE,
                   ));
                   
                   foreach ($editedRespondents as $respondent) {
                     $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondent['respondentID'], \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_CHANGE, $respondent);
                   }*/
                 $seances = $this->registry->getDbHelper('SeancesHelper')->findSeanceByProjectAndRespondentsIDs($context['project']['projectID'], $selectedIDs);
                 foreach ($seances as $seance) {
                     // деактивируем текущий сеанс
                     $this->registry->getDbHelper('SeancesHelper')->editSeance($seance['seanceID'], array('active' => 0, 'private_access_key' => ''));
                     $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'seance', $seance['seanceID'], \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_DELETE, $seance);
                     $this->registry->getDbHelper('MembersHelper')->editRespondent($seance['respondentID'], array('status' => 'active'));
                     // создаем новый сеанс
                     $BlankDataSource = new \Ecoplay\Model\BlankDataSource($this->registry->getDbConnect(), 0, 0);
                     $seanceKey = $BlankDataSource->addSeanceAndCookies($seance['private_access_key']);
                     $newSeance = $this->registry->getDbHelper('SeancesHelper')->findSeanceByKey($seanceKey);
                     $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'seance', $newSeance['seanceID'], \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                 }
             } elseif ($_POST['mode'] == 'return') {
                 if ($context['project']['allow_edit_seance_answers']) {
                     $seances = $this->registry->getDbHelper('SeancesHelper')->findSeanceByProjectAndRespondentsIDs($context['project']['projectID'], $selectedIDs);
                     foreach ($seances as $seance) {
                         if ($seance['state'] == \Ecoplay\Helper\Db\BlanksHelper::SEANCE_STATE_COMPLETE) {
                             $respondent = $this->registry->getDbHelper('MembersHelper')->findRespondentById($seance['respondentID']);
                             $this->registry->getDbHelper('MembersHelper')->editRespondent($seance['respondentID'], array('status' => \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_ACTIVE));
                             // обновляем сеанс
                             $lastScreen = $this->registry->getDbHelper('BlanksHelper')->getBlankPrevScreen($seance['blankID'], $seance['last_screenID']);
                             $this->registry->getDbHelper('SeancesHelper')->editSeance($seance['seanceID'], array('state' => \Ecoplay\Helper\Db\BlanksHelper::SEANCE_STATE_PROGRESS, 'last_screenID' => $lastScreen ? $lastScreen['screenID'] : 0));
                         }
                     }
                 }
             } else {
                 $newStatus = false;
                 switch ($_POST['mode']) {
                     case 'to_new':
                         $newStatus = \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_NEW;
                         break;
                     case 'to_active':
                         $newStatus = \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_ACTIVE;
                         break;
                     case 'to_complete':
                         $newStatus = \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_COMPLETE;
                         break;
                     case 'to_archive':
                         $newStatus = \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_ARCHIVE;
                         break;
                 }
                 if ($newStatus) {
                     $editedRespondents = $this->registry->getDbHelper('LinearProjectsHelper')->getRespondentsByIDs($selectedIDs);
                     $this->registry->getDbHelper('MembersHelper')->editRespondents($selectedIDs, array('status' => $newStatus));
                     foreach ($editedRespondents as $respondent) {
                         $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondent['respondentID'], \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_CHANGE, $respondent);
                     }
                 }
             }
         }
     }
     $arResult['selectedIDs'] = $selectedIDs;
     // получаем респондентов проекта
     $cnt = $this->registry->getDbHelper('LinearProjectsHelper')->getProjectRespondentsCount($context['project']['projectID'], $filterValue['filter_strings']);
     $onPage = 100;
     $pagesCnt = ceil($cnt / $onPage);
     $page = $_GET['PAGE'] && $_GET['PAGE'] <= $pagesCnt ? intval($_GET['PAGE']) : 1;
     $respondents = $this->registry->getDbHelper('LinearProjectsHelper')->getProjectRespondents($context['project']['projectID'], $page, $onPage, $sorts[$sort], $order, $filterValue['filter_strings']);
     $this->component->arResult['respondents'] = $respondents;
     $this->component->arResult['sort'] = $sort;
     $this->component->arResult['order'] = $order;
     $this->component->arResult['cntInfo'] = $pagesCnt == 1 ? $cnt : 0;
     $navResult = new \CDBResult();
     $navResult->NavPageCount = ceil($cnt / $onPage);
     $navResult->NavPageNomer = $page;
     $navResult->NavNum = 1;
     $navResult->NavPageSize = $onPage;
     $navResult->NavRecordCount = $cnt;
     $navResult->nPageWindow = 11;
     $context['APPLICATION']->IncludeComponent('ecoplay:system.pagenavigation', '', array('NAV_RESULT' => $navResult, 'NAV_URL' => '/projects/' . $context['project']['projectID'] . '/groups/' . (isset($_GET['TYPE']) && $_GET['TYPE'] ? $_GET['TYPE'] . '/' : '') . 'respondents/', 'NAV_QUERY_STRING' => 'sort=' . $sort . '&order=' . $order . ($filterQueryString ? '&' . $filterQueryString : '') . (isset($_GET['checkAll']) ? '&checkAll=1' : '')));
     $this->component->arResult['sessions'] = $this->registry->getDbHelper('ProjectsHelper')->getSessionsByProjectID($context['project']['projectID']);
     $languagesIDs = json_decode($context['project']['~languages']);
     $languagesSrc = $this->registry->getDbHelper('TranslationHelper')->getLanguagesByIDs($languagesIDs);
     $languages = array();
     foreach ($languagesSrc as $language) {
         $languages[$language['langID']] = $language['name'];
     }
     $this->component->arResult['languages'] = $languages;
     $this->component->arResult['project'] = $context['project'];
     $context['APPLICATION']->SetPageProperty('pageMainTitle', 'Респонденты');
     $viewHelper = new \Ecoplay\View\Helper();
     $context['APPLICATION']->SetPageProperty('navigation', $viewHelper->generateNavigation(array(0 => array('link' => '/', 'title' => 'Главная'), 1 => array('link' => '/projects/', 'title' => 'Проекты'), 2 => array('link' => '/projects/' . $context['project']['projectID'] . '/continuing/stat/', 'title' => $context['project']['project_name']), 3 => array('title' => 'Респонденты'))));
     $this->component->IncludeComponentTemplate("template_linear");
 }
예제 #3
0
 public function execute($context)
 {
     // проверка прав доступа к разделу
     if (!$this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'members', $context['project']['projectID'])) {
         $this->registry->getModel('Auth')->restrict();
     }
     $context['APPLICATION']->AddHeadScript('/js/forms.js');
     $context['APPLICATION']->AddHeadScript('/js/icheck/icheck.min.js');
     $context['APPLICATION']->SetAdditionalCSS('/js/icheck/skins/minimal/eco.css');
     $availableSessionsIDs = $this->registry->getModel('Auth')->getAvailableSessions($_SESSION['accesses'], $context['project']['projectID']);
     $viewHelper = new \Ecoplay\View\Helper();
     if (count($availableSessionsIDs)) {
         $selectedIDs = array();
         $sorts = array('project_memberID' => 'project_memberID', 'name' => 'name', 'surname' => 'surname', 'email' => 'email', 'position' => 'position', 'private_lk_access_key' => 'private_lk_access_key', 'amount' => 'amount', 'seances' => 'seances');
         if (isset($_GET['sort']) && array_key_exists($_GET['sort'], $sorts)) {
             $sort = $_GET['sort'];
         } else {
             $sort = 'project_memberID';
         }
         $order = isset($_GET['order']) && in_array($_GET['order'], array('asc', 'desc')) ? $_GET['order'] : 'asc';
         $filterQueryString = DataFilter::getFilterQueryString($_GET);
         $this->component->arResult['filterQueryString'] = $filterQueryString;
         // настройки фильтров для данных
         $filters = array(0 => array('title' => 'Имя', 'name' => 'name', 'type' => 'text', 'data_type' => 'string', 'field' => 'pm.`name`'), 1 => array('title' => 'Фамилия', 'name' => 'surname', 'type' => 'text', 'data_type' => 'string', 'field' => 'pm.`surname`'), 2 => array('title' => 'ID', 'name' => 'id', 'type' => 'text', 'data_type' => 'number', 'field' => 'r.`respondentID`'), 3 => array('title' => 'Текст', 'name' => 'text', 'type' => 'text', 'data_type' => 'string', 'field' => array('pm.`search_text`')), 4 => array('title' => 'Анкет', 'name' => 'amount', 'type' => 'range', 'data_type' => 'number', 'field' => '`amount`'));
         $filterData = array('FILTERS' => $filters, 'BASE_URL' => '/projects/' . $context['project']['projectID'] . '/groups/' . (isset($_GET['TYPE']) && $_GET['TYPE'] ? $_GET['TYPE'] . '/' : '') . 'respondents/', 'SORT' => $sort, 'ORDER' => $order);
         // проверяем, введен ли фильтр
         $filterValue = DataFilter::getFilterValue($filters, $_GET, $this->registry->getDbConnect());
         if ($filterValue['valid']) {
             $filterData = array_merge($filterData, $filterValue);
         }
         // компонент отображения фильтра
         $context['APPLICATION']->IncludeComponent('ecoplay:data.filter', '', $filterData);
         $cnt = $this->registry->getDbHelper('MembersHelper')->getRespondentsCountByProjectIDAndSessionsIds($context['project']['projectID'], $availableSessionsIDs, $filterValue['filter_strings']);
         $onPage = 100;
         $pagesCnt = ceil($cnt / $onPage);
         $page = $_GET['PAGE'] && $_GET['PAGE'] <= $pagesCnt ? intval($_GET['PAGE']) : 1;
         // отправляем email уведомления
         if (isset($_POST['respondents_ids'])) {
             if (isset($_POST['all']) && $_POST['all']) {
                 $selectedIDs = $this->registry->getDbHelper('MembersHelper')->getRespondentsIDsByProjectIDAndSessionsIds($context['project']['projectID'], $availableSessionsIDs, $filterValue['filter_strings']);
             } else {
                 $selectedIDs = $_POST['respondents_ids'];
             }
             if (isset($_POST['mode']) && $_POST['mode'] == 'send_notifications') {
                 $emailedRespondents = $this->registry->getDbHelper('MembersHelper')->getMembersRespondentsForNotification($context['project']['projectID'], $selectedIDs);
                 $this->registry->getDbHelper('MembersHelper')->editRespondents(array_keys($emailedRespondents), array('need_remind' => 1));
                 $this->registry->getModel('ActionsLogger')->logMultiSimple($context['USER']->GetID(), 'respondent', array_keys($emailedRespondents), \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_NOTIFY);
             }
         }
         $this->component->arResult['selectedIDs'] = $selectedIDs;
         $respondents = $this->registry->getDbHelper('MembersHelper')->getRespondentsByProjectIDAndSessionsIdsPaged($context['project']['projectID'], $availableSessionsIDs, $page, $onPage, $sorts[$sort], $order, $filterValue['filter_strings']);
         $this->component->arResult['respondents'] = $respondents;
         if (isset($_GET['checkAll'])) {
             $selectedIDs = array();
             foreach ($respondents as $responent) {
                 $selectedIDs[] = $responent['project_memberID'];
             }
             $this->component->arResult['selectedIDs'] = $selectedIDs;
         }
         $fillings = array();
         $emailsCnt = array();
         if (count($respondents)) {
             $membersIDs = array();
             foreach ($respondents as $respondent) {
                 $membersIDs[] = $respondent['project_memberID'];
             }
             $fillings = $this->registry->getDbHelper('MembersHelper')->getRespondentsFillingsByMembersIDs($context['project']['projectID'], $availableSessionsIDs, $membersIDs);
             $emailsCnt = $this->registry->getDbHelper('MembersHelper')->getMembersRespondentsAssessForNotificationCnt($context['project']['projectID'], $membersIDs);
         }
         $this->component->arResult['fillings'] = $fillings;
         $this->component->arResult['emailsCnt'] = $emailsCnt;
         $this->component->arResult['sort'] = $sort;
         $this->component->arResult['order'] = $order;
         $this->component->arResult['cntInfo'] = $pagesCnt == 1 ? $cnt : 0;
         // выводим таблицу с данными
         $this->component->IncludeComponentTemplate('table');
         $navResult = new \CDBResult();
         $navResult->NavPageCount = ceil($cnt / $onPage);
         $navResult->NavPageNomer = $page;
         $navResult->NavNum = 1;
         $navResult->NavPageSize = $onPage;
         $navResult->NavRecordCount = $cnt;
         $navResult->nPageWindow = 11;
         $context['APPLICATION']->IncludeComponent('ecoplay:system.pagenavigation', '', array('NAV_RESULT' => $navResult, 'NAV_URL' => '/projects/' . $context['project']['projectID'] . '/groups/' . (isset($_GET['TYPE']) && $_GET['TYPE'] ? $_GET['TYPE'] . '/' : '') . 'respondents/', 'NAV_QUERY_STRING' => 'sort=' . $sort . '&order=' . $order . ($filterQueryString ? '&' . $filterQueryString : '') . (isset($_GET['checkAll']) ? '&checkAll=1' : '')));
         /*$this->component->arResult['cnt'] = count($respondents);
           $this->component->arResult['table_data'] = $viewHelper->prepareJsonDataForTable($respondents, array('respondentID', 'name', 'surname', 'email', 'position', 'private_lk_access_key', 'amount', 'seances'));*/
     } else {
         //$this->component->arResult['table_data'] = null;
         $this->component->arResult['respondents'] = null;
     }
     $context['APPLICATION']->SetPageProperty('pageMainTitle', 'Респонденты');
     $context['APPLICATION']->SetPageProperty('navigation', $viewHelper->generateNavigation(array(0 => array('link' => '/', 'title' => 'Главная'), 1 => array('link' => '/projects/', 'title' => 'Проекты'), 2 => array('link' => '/projects/' . $context['project']['projectID'] . '/continuing/stat/', 'title' => $context['project']['project_name']), 3 => array('title' => 'Респонденты'))));
     $this->component->IncludeComponentTemplate();
 }
예제 #4
0
 public function execute($context)
 {
     $context['APPLICATION']->AddHeadScript('/js/forms.js');
     // проверка прав доступа к разделу
     if (!$this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'members', $context['project']['projectID'])) {
         $this->registry->getModel('Auth')->restrict();
     }
     $this->component->arResult['canImport'] = $this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'imports', $context['project']['projectID']);
     $languagesIDs = json_decode($context['project']['~languages']);
     $languagesSrc = $this->registry->getDbHelper('TranslationHelper')->getLanguagesByIDs($languagesIDs);
     $languages = array();
     foreach ($languagesSrc as $language) {
         $languages[$language['langID']] = $language['name'];
     }
     $this->component->arResult['languages'] = $languages;
     $this->component->arResult['languagesFull'] = $languagesSrc;
     $sorts = array('projects_memberID' => 'projects_memberID', 'FIO' => 'FIO', 'position' => 'position', 'email' => 'email', 'private_lk_access_key' => 'private_lk_access_key', 'assess_count' => 'assess_count', 'respondent_count' => 'respondent_count', 'userID' => 'userID', 'projectID' => 'projectID', 'status' => 'status', 'langID' => 'langID', 'language' => 'language', 'department' => 'department');
     if (isset($_GET['sort']) && array_key_exists($_GET['sort'], $sorts)) {
         $sort = $_GET['sort'];
     } else {
         $sort = 'projects_memberID';
     }
     $order = isset($_GET['order']) && in_array($_GET['order'], array('asc', 'desc')) ? $_GET['order'] : 'asc';
     $filterQueryString = DataFilter::getFilterQueryString($_GET);
     $this->component->arResult['filterQueryString'] = $filterQueryString;
     // настройки фильтров для данных
     $filters = array(0 => array('title' => 'Имя', 'name' => 'name', 'type' => 'text', 'data_type' => 'string', 'field' => '`name`'), 1 => array('title' => 'Фамилия', 'name' => 'surname', 'type' => 'text', 'data_type' => 'string', 'field' => '`surname`'), 2 => array('title' => 'ID', 'name' => 'id', 'type' => 'text', 'data_type' => 'number', 'field' => '`projects_memberID`'), 3 => array('title' => 'Текст', 'name' => 'text', 'type' => 'text', 'data_type' => 'string', 'field' => array('`search_text`')), 4 => array('title' => 'Язык ', 'name' => 'language', 'type' => 'select', 'data_type' => 'number', 'field' => '`langID`', 'values' => array(0 => 'Любой') + $languages), 5 => array('title' => 'Оценивается', 'name' => 'assess', 'type' => 'range', 'data_type' => 'number', 'field' => '`assess_count`', 'sql_type' => 'where'), 6 => array('title' => 'Оценивает ', 'name' => 'respondent', 'type' => 'range', 'data_type' => 'number', 'field' => '`respondent_count`', 'sql_type' => 'where'));
     $filterData = array('FILTERS' => $filters, 'BASE_URL' => '/projects/' . $context['project']['projectID'] . '/settings/members/', 'SORT' => $sort, 'ORDER' => $order);
     // проверяем, введен ли фильтр
     $filterValue = DataFilter::getFilterValue($filters, $_GET, $this->registry->getDbConnect());
     if ($filterValue['valid']) {
         $filterData = array_merge($filterData, $filterValue);
     }
     // компонент отображения фильтра
     $context['APPLICATION']->IncludeComponent('ecoplay:data.filter', '', $filterData);
     $cnt = $this->registry->getDbHelper('MembersHelper')->getProjectsMembersCount($context['project']['projectID'], $filterValue['filter_strings']);
     $onPage = 100;
     $pagesCnt = ceil($cnt / $onPage);
     $page = $_GET['PAGE'] && $_GET['PAGE'] <= $pagesCnt ? intval($_GET['PAGE']) : 1;
     $navResult = new \CDBResult();
     $navResult->NavPageCount = ceil($cnt / $onPage);
     $navResult->NavPageNomer = $page;
     $navResult->NavNum = 1;
     $navResult->NavPageSize = $onPage;
     $navResult->NavRecordCount = $cnt;
     $context['APPLICATION']->IncludeComponent('ecoplay:system.pagenavigation', '', array('NAV_RESULT' => $navResult, 'NAV_URL' => '/projects/' . $context['project']['projectID'] . '/settings/members/', 'NAV_QUERY_STRING' => 'sort=' . $sort . '&order=' . $order . ($filterQueryString ? '&' . $filterQueryString : '')));
     $membersSrc = $this->registry->getDbHelper('MembersHelper')->getProjectsMembersForView($context['project']['projectID'], $page, $onPage, $sorts[$sort], $order, $filterValue['filter_strings']);
     $members = array();
     foreach ($membersSrc as $member) {
         $member['FIO'] = $member['name'] && $member['surname'] ? '<span class="surname">' . $member['surname'] . '</span> <span class="name">' . $member['name'] . '</span>' : '<span class="surname">' . $member['surname'] . '</span><span class="name">' . $member['name'] . '</span>';
         $members[] = $member;
     }
     $viewHelper = new \Ecoplay\View\Helper();
     $this->component->arResult['cnt'] = count($this->component->arResult['members']);
     $tData = str_replace("'", "\\'", $viewHelper->prepareJsonDataForTable($members, array('projects_memberID', 'FIO', 'position', 'email', 'private_lk_access_key', 'assess_count', 'respondent_count', 'userID', 'projectID', 'status', 'langID', 'language', 'department'), array(), array('language' => $languages)));
     $tData = str_replace("\\", "\\\\", $tData);
     $this->component->arResult['table_data'] = $tData;
     $this->component->arResult['projectID'] = $context['project']['projectID'];
     $this->component->arResult['sort'] = $sort;
     $this->component->arResult['order'] = $order;
     $context['APPLICATION']->SetPageProperty('pageMainTitle', 'Все участники');
     $context['APPLICATION']->SetPageProperty('navigation', $viewHelper->generateNavigation(array(0 => array('title' => 'Главная', 'link' => '/'), 1 => array('title' => 'Проекты', 'link' => '/projects/'), 2 => array('link' => '/projects/' . $context['project']['projectID'] . '/continuing/info/', 'title' => $context['project']['project_name']), 3 => array('title' => 'Участники проекта'))));
     $this->component->IncludeComponentTemplate();
 }
예제 #5
0
 public function execute($context)
 {
     // проверка прав доступа к разделу
     if (!$this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'members', $context['project']['projectID'])) {
         $this->registry->getModel('Auth')->restrict();
     }
     $context['APPLICATION']->AddHeadScript('/js/forms.js');
     $context['APPLICATION']->AddHeadScript('/js/icheck/icheck.min.js');
     $context['APPLICATION']->SetAdditionalCSS('/js/icheck/skins/minimal/eco.css');
     $availableSessionsIDs = $this->registry->getModel('Auth')->getAvailableSessions($_SESSION['accesses'], $context['project']['projectID'], $context['project']['project_type']);
     $viewHelper = new \Ecoplay\View\Helper();
     if (count($availableSessionsIDs)) {
         // нормогруппы для генераторов отчетов
         $projectSettings = json_decode($context['project']['~param_roles'], true);
         $haveValuation = false;
         if (array_key_exists('rgenerators', $projectSettings) && $projectSettings['rgenerators']) {
             $generatorsSrc = $this->registry->getDbHelper('ReportsHelper')->getGeneratorsCollectionByIds($projectSettings['rgenerators']);
             foreach ($generatorsSrc as $generator) {
                 if ($generator['use_valuation_group']) {
                     $haveValuation = true;
                     break;
                 }
             }
         }
         if ($haveValuation) {
             //  определяем тип админа (экопси или нет)
             $isEcopsy = false;
             $groups = $this->registry->getDbHelper('UsersHelper')->getUserGroups($context['USER']->GetID());
             if (count($groups) > 1) {
                 $isEcopsy = true;
             } else {
                 $clientID = $this->registry->getDbHelper('UsersHelper')->getUserClient($context['USER']->GetID());
                 if ($clientID == \Ecoplay\Helper\Db\ClientsHelper::ECOPSY_CLIENT_ID) {
                     $isEcopsy = true;
                 }
             }
             $this->component->arResult['valuationGroups'] = $this->registry->getDbHelper('TestsHelper')->getProjectValuationGroups($context['project']['projectID'], $isEcopsy);
         }
         $this->component->arResult['haveValuation'] = $haveValuation;
         if (isset($_POST['type'])) {
             if ($_POST['type'] == 'edit') {
                 // находим респондента
                 $respondent = $this->registry->getDbHelper('MembersHelper')->findRespondentById($_POST['respondentID']);
                 if ($respondent) {
                     // обновляем участника
                     $member = $this->registry->getDbHelper('MembersHelper')->findById($respondent['project_memberID']);
                     if ($member['email'] != $_POST['email'] && $_POST['email']) {
                         $sameEmailMember = $this->registry->getDbHelper('MembersHelper')->findByEmailAndProjectId($_POST['email'], $context['project']['projectID']);
                         $email = $sameEmailMember ? $member['email'] : $_POST['email'];
                     } else {
                         $email = $member['email'];
                     }
                     $this->registry->getDbHelper('MembersHelper')->updateMember($respondent['project_memberID'], $_POST['name'], $_POST['surname'], $_POST['position'], $email, $_POST['language'], $_POST['department']);
                     $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'member', $respondent['project_memberID'], \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_CHANGE, $member);
                     if ($respondent['sessionID'] != $_POST['session_id']) {
                         $seance = $this->registry->getDbHelper('TestsSeancesHelper')->findSeanceByProjectIDAndRespondentID($context['project']['projectID'], $respondent['respondentID']);
                         if (!$seance) {
                             $this->registry->getDbHelper('MembersHelper')->editRespondent($respondent['respondentID'], array('sessionID' => $_POST['session_id']));
                             $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondent['respondentID'], \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_CHANGE, $respondent);
                         }
                     }
                 }
                 echo 'Редактирование<br/>';
             } elseif ($_POST['type'] == 'exist') {
                 if (isset($_POST['member_id'])) {
                     // проверяем, может уже есть респондент с таким участником
                     //$existRespondent = $this->registry->getDbHelper('MembersHelper')->findRespondentByMemberID($context['project']['projectID'], $_POST['member_id']);
                     //if (!$existRespondent) {
                     // добавляем респондента
                     $respondentID = $this->registry->getDbHelper('MembersHelper')->addRespondent(array('project_memberID' => intval($_POST['member_id']), 'active' => 1, 'projectID' => $context['project']['projectID'], 'sessionID' => intval($_POST['session_id']), 'stat1_assessID' => 0, 'status' => \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_NEW, 'private_access_key' => $this->registry->getModel('Auth')->generateUid('prep_respondents', 'private_access_key'), 'stat1_roleID' => 0, 'last_email' => '0000-00-00 00:00:00', 'langID' => 0, 'last_entrance' => '0000-00-00 00:00:00', 'deny_deletion' => 0, 'addedd_by_assess' => 0, 'need_remind' => 0));
                     $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondentID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                 }
                 //}
             } else {
                 // пробуем добавить участника
                 $validations = array('name' => 'anything', 'surname' => 'anything', 'email' => 'email', 'position' => 'anything', 'department' => 'anything', 'language' => 'identifier');
                 $required = array('name', 'email', 'language');
                 $validator = new \Ecoplay\Form\Validator($validations, $required, array());
                 if ($validator->validate($_POST)) {
                     // проверяем чтобы не было уже участника с таким email
                     if (!$this->registry->getDbHelper('MembersHelper')->findByEmailAndProjectId($_POST['email'], $context['project']['projectID'])) {
                         $memberID = $this->registry->getDbHelper('MembersHelper')->addMember(trim($_POST["name"]), trim($_POST["surname"]), trim($_POST["position"]), trim($_POST["email"]), $context['project']['projectID'], $this->registry->getModel('Auth')->generateUid('prep_projects_members', 'private_lk_access_key'), intval($_POST["language"]), 1, 'new', trim($_POST['department']));
                         $eventListener = new EventListener($this->registry, $context['project'], $_SERVER["DOCUMENT_ROOT"] . '/');
                         $eventListener->executeEvent('MemberAdded', array('memberID' => $memberID), true);
                         $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'member', $memberID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                         // добавляем респондента
                         $respondentID = $this->registry->getDbHelper('MembersHelper')->addRespondent(array('project_memberID' => $memberID, 'active' => 1, 'projectID' => $context['project']['projectID'], 'sessionID' => intval($_POST['session_id']), 'stat1_assessID' => 0, 'status' => \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_NEW, 'private_access_key' => $this->registry->getModel('Auth')->generateUid('prep_respondents', 'private_access_key'), 'stat1_roleID' => 0, 'last_email' => '0000-00-00 00:00:00', 'langID' => 0, 'last_entrance' => '0000-00-00 00:00:00', 'deny_deletion' => 0, 'addedd_by_assess' => 0, 'need_remind' => 0));
                         $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondentID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                     } else {
                         $this->component->arResult['statusError'] = 'Участник с таким email (' . $_POST['email'] . ') уже существует';
                     }
                 }
             }
         }
         if ($_FILES["filepath"] && !$_FILES['filepath']['error']) {
             $sessionID = (int) $_POST["fgroup"];
             if ($sessionID) {
                 $session = $this->registry->getDbHelper('TestsHelper')->findSessionByID($sessionID);
             }
             // обрабатываем загруженный файл
             $csvImporter = new \Ecoplay\Import\Csv($_FILES["filepath"]["tmp_name"], $_SERVER["DOCUMENT_ROOT"] . "/temp/csv/");
             $data = $csvImporter->parse();
             $sessionIndex = $csvImporter->getColumnIndex('Группа');
             if (!((!$sessionIndex || !$data[0][$sessionIndex]) && (!$sessionID || !$session))) {
                 // определяем группу
                 if ($sessionIndex && $data[0][$sessionIndex]) {
                     // ищем группу
                     $session = $this->registry->getDbHelper('TestsHelper')->findSessionByProjectIDAndName($context['project']['projectID'], $data[0][$sessionIndex]);
                     if ($session) {
                         $sessionID = $session['sessionID'];
                     } else {
                         /*$session = array(
                             'name'  => $data[0][$sessionIndex],
                             'active'  => 1,
                             'status'  => 'active',
                             'projectID'  => $context['project']['projectID'],
                           );
                           $sessionID = $this->registry->getDbHelper('TestsHelper')->addSession($session);
                           $session['sessionID'] = $sessionID;*/
                         $sessionID = 0;
                     }
                 }
                 $inserted = $skipped = 0;
                 $validations = array(0 => 'anything', 1 => 'anything', 2 => 'email', 3 => 'anything', 4 => 'anything');
                 $required = array(2);
                 $validator = new \Ecoplay\Form\Validator($validations, $required, array());
                 $projectLangID = $this->registry->getModel('Projects')->getDefaultLangID($context['project']);
                 $languageIndex = $csvImporter->getColumnIndex('Язык');
                 $languagesIDs = array();
                 $availableLanguages = $this->registry->getDbHelper('TranslationHelper')->getLanguagesByIDs(json_decode($context['project']['~languages']));
                 foreach ($availableLanguages as $language) {
                     $languagesIDs[$language['abbr']] = $language['langID'];
                 }
                 $rowIndex = 0;
                 $skippedRows = array();
                 foreach ($data as $row) {
                     $rowIndex++;
                     if ($sessionIndex && $row[$sessionIndex] && (!$sessionID || $row[$sessionIndex] != $session['name'])) {
                         // ищем группу
                         $session = $this->registry->getDbHelper('TestsHelper')->findSessionByProjectIDAndName($context['project']['projectID'], $row[$sessionIndex]);
                         if ($session) {
                             $sessionID = $session['sessionID'];
                         } else {
                             /*$session = array(
                                 'name'  => $row[$sessionIndex],
                                 'active'  => 1,
                                 'status'  => 'active',
                                 'projectID'  => $context['project']['projectID'],
                               );
                               $sessionID = $this->registry->getDbHelper('TestsHelper')->addSession($session);
                               $session['sessionID'] = $sessionID;*/
                             $sessionID = 0;
                         }
                     }
                     if (!$sessionID) {
                         $skipped++;
                         $skippedRows[] = $rowIndex;
                         continue;
                     }
                     // валидируем исходные данные
                     if (!$validator->validate($row)) {
                         $skipped++;
                         $skippedRows[] = $rowIndex;
                     } elseif (!$row[0] && !$row[1]) {
                         // должно быть хотябы или имя, или фамилия
                         $skipped++;
                         $skippedRows[] = $rowIndex;
                     } else {
                         // ищем такого участника уже в базе
                         $member = $this->registry->getDbHelper('MembersHelper')->findByEmailAndProjectId($row[2], $context['project']['projectID']);
                         if (!$member) {
                             // добавляем участника
                             // определяем язык по структуре
                             $staff = $this->registry->getDbHelper('MembersHelper')->findStaffByProjectIDAndEmail($context['project']['projectID'], $row[2]);
                             $langID = $languageIndex && $row[$languageIndex] && array_key_exists($row[$languageIndex], $languagesIDs) ? $languagesIDs[$row[$languageIndex]] : $projectLangID;
                             $memberID = $this->registry->getDbHelper('MembersHelper')->addMember($row[1], $row[0], $row[3], $row[2], $context['project']['projectID'], $this->registry->getModel('Auth')->generateUid('prep_projects_members', 'private_lk_access_key', false), $langID, 1, 'new', $row[4]);
                             $eventListener = new EventListener($this->registry, $context['project'], $_SERVER["DOCUMENT_ROOT"] . '/');
                             $eventListener->executeEvent('MemberAdded', array('memberID' => $memberID), true);
                             $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'member', $memberID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                         } else {
                             $memberID = $member['projects_memberID'];
                         }
                         if ($this->registry->getDbHelper('MembersHelper')->findRespondentByProjectIDAndSessionIDAndMemberID($context['project']['projectID'], $sessionID, $memberID)) {
                             // такой оцениваемый уже есть
                             $skipped++;
                             $skippedRows[] = $rowIndex;
                         } else {
                             $respondentID = $this->registry->getDbHelper('MembersHelper')->addRespondent(array('projectID' => $context['project']['projectID'], 'sessionID' => $sessionID, 'project_memberID' => $memberID, 'active' => 1, 'status' => 'new', 'stat1_assessID' => 0, 'private_access_key' => $this->registry->getModel('Auth')->generateUid('prep_respondents', 'private_access_key', false), 'stat1_roleID' => 0));
                             $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondentID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                             $inserted++;
                         }
                     }
                 }
                 $this->component->arResult['statusSuccess'] = 'Импортировано: ' . $inserted . ', проигнорировано: ' . $skipped . ($skipped ? ' (строки ' . implode(', ', $skippedRows) . ')' : '');
             }
         }
         $statuses = $this->registry->getDbHelper('MembersHelper')->getTestingRespondentsStatusesNames();
         $this->component->arResult['statuses'] = $statuses;
         $sorts = array('respondentID' => 'respondentID', 'name' => 'name', 'surname' => 'surname', 'email' => 'email', 'position' => 'position', 'session' => 'sessionID', 'status' => 'status', 'private_lk_access_key' => 'private_lk_access_key', 'last_email' => 'last_email', 'last_action' => 'last_entrance');
         if (isset($_GET['sort']) && array_key_exists($_GET['sort'], $sorts)) {
             $sort = $_GET['sort'];
         } else {
             $sort = 'respondentID';
         }
         $order = isset($_GET['order']) && in_array($_GET['order'], array('asc', 'desc')) ? $_GET['order'] : 'asc';
         $filterQueryString = DataFilter::getFilterQueryString($_GET);
         $this->component->arResult['filterQueryString'] = $filterQueryString;
         $sessions = $this->registry->getDbHelper('TestsHelper')->getSessionsByProjectID($context['project']['projectID']);
         $userSessions = array();
         foreach ($sessions as $session) {
             if (in_array($session['sessionID'], $availableSessionsIDs)) {
                 $userSessions[$session['sessionID']] = $session['name'];
             }
         }
         $this->component->arResult['userSessions'] = $userSessions;
         // настройки фильтров для данных
         $filters = array(0 => array('title' => 'Имя', 'name' => 'name', 'type' => 'text', 'data_type' => 'string', 'field' => 'm.`name`'), 1 => array('title' => 'Фамилия', 'name' => 'surname', 'type' => 'text', 'data_type' => 'string', 'field' => 'm.`surname`'), 2 => array('title' => 'ID', 'name' => 'id', 'type' => 'text', 'data_type' => 'number', 'field' => 'r.`respondentID`'), 3 => array('title' => 'Текст', 'name' => 'text', 'type' => 'text', 'data_type' => 'string', 'field' => array('m.`search_text`')), 4 => array('title' => 'Статус ', 'name' => 'status', 'type' => 'select', 'data_type' => 'string', 'field' => 'r.`status`', 'values' => array(0 => 'Любой') + $statuses), 5 => array('title' => 'Группа ', 'name' => 'session_id', 'type' => 'select', 'data_type' => 'number', 'field' => 'r.`sessionID`', 'values' => array(0 => 'Любая') + $userSessions), 6 => array('title' => 'В архиве ', 'name' => 'is_archive', 'type' => 'select', 'data_type' => 'number', 'field' => 'r.`is_archive`', 'values' => array(-1 => '-', 0 => 'Нет', 1 => 'Да'), 'explicit' => 1));
         $filterData = array('FILTERS' => $filters, 'BASE_URL' => '/projects/' . $context['project']['projectID'] . '/groups/respondents/', 'SORT' => $sort, 'ORDER' => $order);
         // проверяем, введен ли фильтр
         $filterValue = DataFilter::getFilterValue($filters, $_GET, $this->registry->getDbConnect());
         if ($filterValue['valid']) {
             $filterData = array_merge($filterData, $filterValue);
         }
         // компонент отображения фильтра
         $context['APPLICATION']->IncludeComponent('ecoplay:data.filter', '', $filterData);
         // выполняем с респондентами действия
         if (isset($_POST['respondents_ids'])) {
             if (isset($_POST['all']) && $_POST['all']) {
                 $selectedIDs = $this->registry->getDbHelper('TestsSeancesHelper')->getRespondentsIDsByProjectIDAndSessionsIDs($context['project']['projectID'], $availableSessionsIDs, $filterValue['filter_strings']);
             } else {
                 $selectedIDs = $_POST['respondents_ids'];
             }
             if (isset($_POST['mode'])) {
                 if ($_POST['mode'] == 'delete') {
                     $deletedRespondents = $this->registry->getDbHelper('TestsSeancesHelper')->getRespondentsByIDs($selectedIDs);
                     $this->registry->getDbHelper('MembersHelper')->deleteRespondentsByIDs($selectedIDs);
                     foreach ($deletedRespondents as $respondent) {
                         $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondent['respondentID'], \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_DELETE, $respondent);
                     }
                 } elseif ($_POST['mode'] == 'zip') {
                     $editedRespondents = $this->registry->getDbHelper('TestsSeancesHelper')->getRespondentsByIDs($selectedIDs);
                     $this->registry->getDbHelper('MembersHelper')->editRespondents($selectedIDs, array('is_archive' => 1));
                     foreach ($editedRespondents as $respondent) {
                         $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondent['respondentID'], \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_CHANGE, $respondent);
                     }
                 } elseif ($_POST['mode'] == 'unzip') {
                     $editedRespondents = $this->registry->getDbHelper('TestsSeancesHelper')->getRespondentsByIDs($selectedIDs);
                     $this->registry->getDbHelper('MembersHelper')->editRespondents($selectedIDs, array('is_archive' => 0));
                     foreach ($editedRespondents as $respondent) {
                         $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondent['respondentID'], \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_CHANGE, $respondent);
                     }
                 } elseif ($_POST['mode'] == 'mail_resend') {
                     $editedRespondents = $this->registry->getDbHelper('TestsSeancesHelper')->getRespondentsByIDs($selectedIDs);
                     $membersIds = array(0);
                     foreach ($editedRespondents as $respondent) {
                         $membersIds[intval($respondent["project_memberID"])] = intval($respondent["project_memberID"]);
                     }
                     $selectedMemebers = $this->registry->getDbHelper('MembersHelper')->getMembersByIDs($membersIds);
                     $languagesIDs = json_decode($context['project']['~languages']);
                     foreach ($selectedMemebers as $selectedMemeber) {
                         if ($selectedMemeber["email"] != "") {
                             $smtpMail = \Ecoplay\Model\SmtpMail::getInstance($this->registry->getDbConnect(), SMTP_HOST, SMTP_PORT, SMTP_USERNAME, SMTP_PASSWORD);
                             $smtpMail->sendFromTemplate($context['project']['projectID'], 'MailEvent_Testing_MailResend', $languagesIDs[0], array("RESPONDENT" => $selectedMemeber["name"] . " " . $selectedMemeber["surname"], "RESPONDENT_LK_LINK" => 'http://' . SITE_HOST . '/enter/' . $selectedMemeber['private_lk_access_key'] . "/", 'EMAIL_TO' => $selectedMemeber["email"], 'EMAIL_FROM' => EMAIL_FROM), 'member', $selectedMemeber['projects_memberID']);
                         }
                     }
                 } elseif ($_POST['mode'] == 'reports') {
                     $valid = false;
                     $params = array();
                     if ($haveValuation) {
                         if ($_POST['valuation_group']) {
                             // валидируем выбранную нормогруппу
                             $valuationGroup = $this->registry->getDbHelper('TestsHelper')->findValuationGroupByID(intval($_POST['valuation_group']));
                             if ($valuationGroup) {
                                 $params['valuationGroupID'] = $valuationGroup['vgroupID'];
                                 $valid = true;
                             }
                         }
                     } else {
                         $valid = true;
                     }
                     if ($valid) {
                         // Создаем задачу на генерацию отчетов
                         $taskID = $this->registry->getDbHelper('TasksHelper')->addTask(array('name' => '', 'type' => \Ecoplay\Helper\Db\TasksHelper::TASK_TYPE_REPORT, 'params' => json_encode(array_merge($params, array('projectID' => $context['project']['projectID'], 'respondentsIDs' => $selectedIDs))), 'userID' => $context['USER']->GetID(), 'status' => \Ecoplay\Helper\Db\TasksHelper::TASK_STATUS_NEW, 'dt_created' => date('d-m-Y H:i:s')));
                         $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'task', $taskID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                     }
                 } else {
                     $newStatus = false;
                     switch ($_POST['mode']) {
                         case 'to_new':
                             $newStatus = \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_NEW;
                             break;
                         case 'to_waiting':
                             $newStatus = \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_WAITING;
                             break;
                         case 'to_active':
                             $newStatus = \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_ACTIVE;
                             break;
                         case 'to_complete':
                             $newStatus = \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_COMPLETE;
                             break;
                             /*case 'to_report':
                                 $newStatus = \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_REPORT;
                                 break;
                               case 'to_archive':
                                 $newStatus = \Ecoplay\Helper\Db\MembersHelper::RESPONDENT_STATUS_ARCHIVE;
                                 break;*/
                     }
                     if ($newStatus) {
                         $editedRespondents = $this->registry->getDbHelper('TestsSeancesHelper')->getRespondentsByIDs($selectedIDs);
                         $this->registry->getDbHelper('MembersHelper')->editRespondents($selectedIDs, array('status' => $newStatus));
                         foreach ($editedRespondents as $respondent) {
                             $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'respondent', $respondent['respondentID'], \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_CHANGE, $respondent);
                         }
                     }
                 }
             }
         }
         $arResult['selectedIDs'] = $selectedIDs;
         // получаем респондентов проекта
         $cnt = $this->registry->getDbHelper('TestsSeancesHelper')->getRespondentsCountByProjectIDAndSessionsIDs($context['project']['projectID'], $availableSessionsIDs, $filterValue['filter_strings']);
         $onPage = 100;
         $pagesCnt = ceil($cnt / $onPage);
         $page = $_GET['PAGE'] && $_GET['PAGE'] <= $pagesCnt ? intval($_GET['PAGE']) : 1;
         $respondents = $this->registry->getDbHelper('TestsSeancesHelper')->getRespondentsByProjectIDAndSessionsIDsPaged($context['project']['projectID'], $availableSessionsIDs, $page, $onPage, $sorts[$sort], $order, $filterValue['filter_strings']);
         $this->component->arResult['respondents'] = $respondents;
         $this->component->arResult['sort'] = $sort;
         $this->component->arResult['order'] = $order;
         $this->component->arResult['cntInfo'] = $pagesCnt == 1 ? $cnt : 0;
         // инфа для редактирования
         $respondentsJson = array();
         $respondentsIDs = array();
         foreach ($respondents as $respondent) {
             $respondentsJson[$respondent['respondentID']] = array('name' => $respondent['name'], 'surname' => $respondent['surname'], 'email' => $respondent['email'], 'position' => $respondent['position'], 'department' => $respondent['department'], 'langID' => $respondent['langID'], 'sessionID' => $respondent['sessionID']);
             $respondentsIDs[] = $respondent['respondentID'];
         }
         $jsonRespondents = json_encode($respondentsJson);
         $jsonRespondents = str_replace("'", "\\'", $jsonRespondents);
         $jsonRespondents = str_replace("\\", "\\\\", $jsonRespondents);
         $this->component->arResult['json_respondents'] = $jsonRespondents;
         // отчеты респондентов
         $reports = array();
         if (count($respondentsIDs)) {
             $reportsSrc = $this->registry->getDbHelper('ReportsHelper')->getReportsByProjectIDAndRespondentsIDs($context['project']['projectID'], $respondentsIDs);
             foreach ($reportsSrc as $report) {
                 if (!array_key_exists($report['stat1_respondentID'], $reports)) {
                     $reports[$report['stat1_respondentID']] = array('reportID' => $report['generated_reportID'], 'cnt' => 1);
                 } else {
                     $reports[$report['stat1_respondentID']]['cnt']++;
                     if ($report['generated_reportID'] > $reports[$report['stat1_respondentID']]['reportID']) {
                         $reports[$report['stat1_respondentID']]['reportID'] = $report['generated_reportID'];
                     }
                 }
             }
         }
         $this->component->arResult['reports'] = $reports;
         // инфа для построения прогресса
         $this->component->arResult['progress_settings'] = $this->registry->getModel('Tests')->getProjectProgressSettings($context['project']['projectID']);
         // статистика по статусам
         $get = $_GET;
         if (array_key_exists('status_fvalue', $get)) {
             unset($get['status_fvalue']);
         }
         $filterValue = DataFilter::getFilterValue($filters, $get, $this->registry->getDbConnect());
         $statusesStatSrc = $this->registry->getDbHelper('TestsSeancesHelper')->getRespondentsStatusesStat($context['project']['projectID'], $availableSessionsIDs, $filterValue['filter_strings']);
         $statusesStat = array();
         $allStatusesCnt = 0;
         foreach ($statuses as $status => $name) {
             $statusesStat[$status] = 0;
         }
         foreach ($statusesStatSrc as $stat) {
             //foreach ($respondents as $respondent) {
             $statusesStat[$stat['status']] += $stat['cnt'];
             $allStatusesCnt += $stat['cnt'];
         }
         $this->component->arResult['statuses_stat'] = $statusesStat;
         $this->component->arResult['all_statuses_cnt'] = $allStatusesCnt;
         $this->component->IncludeComponentTemplate("testing_statuses_filter");
         $navResult = new \CDBResult();
         $navResult->NavPageCount = ceil($cnt / $onPage);
         $navResult->NavPageNomer = $page;
         $navResult->NavNum = 1;
         $navResult->NavPageSize = $onPage;
         $navResult->NavRecordCount = $cnt;
         $navResult->nPageWindow = 11;
         $context['APPLICATION']->IncludeComponent('ecoplay:system.pagenavigation', '', array('NAV_RESULT' => $navResult, 'NAV_URL' => '/projects/' . $context['project']['projectID'] . '/groups/respondents/', 'NAV_QUERY_STRING' => 'sort=' . $sort . '&order=' . $order . ($filterQueryString ? '&' . $filterQueryString : '') . (isset($_GET['checkAll']) ? '&checkAll=1' : '')));
         $this->component->arResult['sessions'] = $sessions;
         $packagesIDs = array();
         foreach ($sessions as $session) {
             if (!in_array($session['packageID'], $packagesIDs)) {
                 $packagesIDs[] = $session['packageID'];
             }
         }
         $this->component->arResult['packages'] = $this->registry->getDbHelper('TestsHelper')->getPackagesByIDs($packagesIDs);
         $languagesIDs = json_decode($context['project']['~languages']);
         $languagesSrc = $this->registry->getDbHelper('TranslationHelper')->getLanguagesByIDs($languagesIDs);
         $languages = array();
         foreach ($languagesSrc as $language) {
             $languages[$language['langID']] = $language['name'];
         }
         $this->component->arResult['languages'] = $languages;
     } else {
         $this->component->arResult['respondents'] = null;
     }
     $context['APPLICATION']->SetPageProperty('pageMainTitle', 'Тестируемые');
     $context['APPLICATION']->SetPageProperty('navigation', $viewHelper->generateNavigation(array(0 => array('link' => '/', 'title' => 'Главная'), 1 => array('link' => '/projects/', 'title' => 'Проекты'), 2 => array('link' => '/projects/' . $context['project']['projectID'] . '/continuing/stat/', 'title' => $context['project']['project_name']), 3 => array('title' => 'Тестируемые'))));
     $this->component->arResult['canReports'] = $this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'reports', $context['project']['projectID']);
     $this->component->IncludeComponentTemplate("template_testing");
 }
예제 #6
0
 public function execute($context)
 {
     $context['APPLICATION']->AddHeadScript('/js/forms.js');
     $context['APPLICATION']->AddHeadScript('/js/icheck/icheck.min.js');
     $context['APPLICATION']->SetAdditionalCSS('/js/icheck/skins/minimal/eco.css');
     $this->component->arResult['canSelectRespondents'] = $context['project']['allow_assess_to_select_respondents'];
     $this->component->arResult['canSelectAssess'] = $context['project']['allow_respondent_to_select_assess'];
     // проверка прав доступа к разделу
     if (!$this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'members', $context['project']['projectID'])) {
         $this->registry->getModel('Auth')->restrict();
     }
     $this->component->arResult['canImport'] = $this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'imports', $context['project']['projectID']);
     $availableSessionsIDs = $this->registry->getModel('Auth')->getAvailableSessions($_SESSION['accesses'], $context['project']['projectID']);
     $viewHelper = new \Ecoplay\View\Helper();
     if (count($availableSessionsIDs)) {
         $userSessions = $this->registry->getDbHelper('ProjectsHelper')->getUserAvailableSessionsByProjectID($context['project']['projectID'], $availableSessionsIDs);
         $this->component->arResult['jsessions'] = json_encode($userSessions);
         $this->component->arResult['sessions'] = $userSessions;
         $selectedIDs = array();
         $statuses = $this->registry->getDbHelper('MembersHelper')->getAssessStatusesNames();
         $sorts = array('assessID' => 'assessID', 'name' => 'name', 'surname' => 'surname', 'email' => 'email', 'position' => 'position', 'private_lk_access_key' => 'private_lk_access_key', 'respondents' => 'respondents', 'report' => 'report', 'sessionID' => 'sessionID', 'status' => 'status');
         if (isset($_GET['sort']) && array_key_exists($_GET['sort'], $sorts)) {
             $sort = $_GET['sort'];
         } else {
             $sort = 'assessID';
         }
         $order = isset($_GET['order']) && in_array($_GET['order'], array('asc', 'desc')) ? $_GET['order'] : 'asc';
         $filterQueryString = DataFilter::getFilterQueryString($_GET);
         $this->component->arResult['filterQueryString'] = $filterQueryString;
         $reportsStates = array(\Ecoplay\Helper\Db\MembersHelper::ASSESS_REPORT_STATE_EMPTY => 'Нет данных', \Ecoplay\Helper\Db\MembersHelper::ASSESS_REPORT_STATE_NOT_READY => 'Отчёт строить нельзя', \Ecoplay\Helper\Db\MembersHelper::ASSESS_REPORT_STATE_MINIMAL => 'Не полностью заполнено, но можно строить отчёт', \Ecoplay\Helper\Db\MembersHelper::ASSESS_REPORT_STATE_FULL => 'Заполнено на 100%');
         $this->component->arResult['reportsStates'] = $reportsStates;
         // настройки фильтров для данных
         $filters = array(0 => array('title' => 'Имя', 'name' => 'name', 'type' => 'text', 'data_type' => 'string', 'field' => 'pm.`name`'), 1 => array('title' => 'Фамилия', 'name' => 'surname', 'type' => 'text', 'data_type' => 'string', 'field' => 'pm.`surname`'), 2 => array('title' => 'ID', 'name' => 'id', 'type' => 'text', 'data_type' => 'number', 'field' => 'a.`assessID`'), 3 => array('title' => 'Текст', 'name' => 'text', 'type' => 'text', 'data_type' => 'string', 'field' => array('pm.`search_text`')), 4 => array('title' => 'Группа ', 'name' => 'session_id', 'type' => 'select', 'data_type' => 'number', 'field' => 'a.`sessionID`', 'values' => array(0 => 'Любая') + $userSessions), 5 => array('title' => 'Респондентов', 'name' => 'respondents', 'type' => 'range', 'data_type' => 'number', 'field' => '`respondents`'), 6 => array('title' => 'Статус ', 'name' => 'status', 'type' => 'select', 'data_type' => 'string', 'field' => 'a.`status`', 'values' => array(0 => 'Любой') + $statuses), 7 => array('title' => 'Утверждено ', 'name' => 'direct_viewed', 'type' => 'select', 'data_type' => 'number', 'field' => 'a.`viewed_by_direct_head`', 'values' => array(-1 => '-', 0 => 'Нет', 1 => 'Да'), 'explicit' => 1), 8 => array('title' => 'Отчеты ', 'name' => 'report_state', 'type' => 'select', 'data_type' => 'string', 'field' => 'a.`report_state`', 'values' => array(0 => 'Не учитывать') + $reportsStates));
         $filterData = array('FILTERS' => $filters, 'BASE_URL' => '/projects/' . $context['project']['projectID'] . '/groups/assess/', 'SORT' => $sort, 'ORDER' => $order);
         // проверяем, введен ли фильтр
         $filterValue = DataFilter::getFilterValue($filters, $_GET, $this->registry->getDbConnect());
         if ($filterValue['valid']) {
             $filterData = array_merge($filterData, $filterValue);
         }
         // компонент отображения фильтра
         $context['APPLICATION']->IncludeComponent('ecoplay:data.filter', '', $filterData);
         $cnt = $this->registry->getDbHelper('MembersHelper')->getAssessCountByProjectIDAndSessionsIds($context['project']['projectID'], $availableSessionsIDs, $filterValue['filter_strings']);
         $onPage = 100;
         $pagesCnt = ceil($cnt / $onPage);
         $page = $_GET['PAGE'] && $_GET['PAGE'] <= $pagesCnt ? intval($_GET['PAGE']) : 1;
         // обрабатываем статусы опрашиваемых
         if (isset($_POST['assess_ids'])) {
             if (isset($_POST['all']) && $_POST['all']) {
                 $selectedIDs = $this->registry->getDbHelper('MembersHelper')->getAssessIdsByProjectIDAndSessionsIds($context['project']['projectID'], $availableSessionsIDs, $filterValue['filter_strings']);
             } else {
                 $selectedIDs = $_POST['assess_ids'];
             }
             $assesses = $this->registry->getDbHelper('MembersHelper')->getAssessByIDs($selectedIDs);
             $newStatus = '';
             $needLog = true;
             if (isset($_POST['mode']) && $_POST['mode'] == 'report') {
                 // переводим в отчеты
                 $assessData = array('status' => \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_COMPLETE);
                 if ($context['project']['auto_send_report_email']) {
                     $assessData['last_report_email'] = '0000-00-00 00:00:00';
                 } else {
                     $assessData['last_report_email'] = date('d-m-Y H:i:s');
                 }
                 $this->registry->getDbHelper('MembersHelper')->editSeveralAssess($selectedIDs, $assessData);
                 //$this->registry->getDbHelper('MembersHelper')->changeAssessesStatus($selectedIDs, Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_COMPLETE);
                 $newStatus = \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_COMPLETE;
                 $this->component->arResult['statusSuccess'] = 'Оцениваемые переведены в статус отчета';
             } elseif (isset($_POST['mode']) && $_POST['mode'] == 'activate') {
                 // проверяем, чтобы у сессий оцениваемых был задан бланк!
                 $sessions = $this->registry->getDbHelper('MembersHelper')->getAssessSessions($selectedIDs);
                 $emptySession = false;
                 foreach ($sessions as $session) {
                     if (!$session['blankID']) {
                         $emptySession = $session['name'];
                         break;
                     }
                 }
                 if (!$emptySession) {
                     $this->registry->getDbHelper('MembersHelper')->changeAssessesStatus($selectedIDs, \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_ASSESS);
                     $this->component->arResult['statusSuccess'] = 'Оцениваемые переведены в статус опроса';
                     $newStatus = \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_ASSESS;
                 } else {
                     $this->component->arResult['statusError'] = 'Для группы "' . $emptySession . '" не задан бланк!';
                 }
             } elseif (isset($_POST['mode']) && $_POST['mode'] == 'select_respondents' && $context['project']['allow_assess_to_select_respondents']) {
                 $this->registry->getDbHelper('MembersHelper')->changeAssessesStatus($selectedIDs, \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_SELECT_RESPONDENTS);
                 $newStatus = \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_SELECT_RESPONDENTS;
                 $this->component->arResult['statusSuccess'] = 'Оцениваемые переведены в статус выбора респондента';
             } elseif (isset($_POST['mode']) && $_POST['mode'] == 'select_assess' && $context['project']['allow_respondent_to_select_assess']) {
                 $this->registry->getDbHelper('MembersHelper')->changeAssessesStatus($selectedIDs, \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_SELECT_ASSESS);
                 $newStatus = \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_SELECT_ASSESS;
                 $this->component->arResult['statusSuccess'] = 'Оцениваемые переведены в статус выбора оцениваемых';
             } elseif (isset($_POST['mode']) && $_POST['mode'] == 'new') {
                 $this->registry->getDbHelper('MembersHelper')->changeAssessesStatus($selectedIDs, \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_NEW);
                 $newStatus = \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_NEW;
                 $this->component->arResult['statusSuccess'] = 'Оцениваемые переведены в статус "Новый"';
             } elseif (isset($_POST['mode']) && $_POST['mode'] == 'email') {
                 // рассылка напоминалок респондентам
                 if ($context['project']['freeze_email']) {
                     $this->component->arResult['statusError'] = 'Невозможно отправить напоминания, так как проект заблокирован на рассылку почты';
                 } else {
                     $emailedAssessIDs = array();
                     $fillingEmailedAssessIDs = array();
                     foreach ($assesses as $assess) {
                         if ($assess['status'] == \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_ASSESS) {
                             $fillingEmailedAssessIDs[] = $assess['assessID'];
                         } elseif ($assess['status'] == \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_SELECT_RESPONDENTS) {
                             if ($assess['last_select_respondents_email'] != '0000-00-00 00:00:00') {
                                 $emailedAssessIDs[] = $assess['assessID'];
                             }
                         } elseif ($assess['status'] == \Ecoplay\Helper\Db\MembersHelper::ASSESS_STATUS_SELECT_ASSESS) {
                             if ($assess['last_select_assess_email'] != '0000-00-00 00:00:00') {
                                 $emailedAssessIDs[] = $assess['assessID'];
                             }
                         }
                     }
                     if (count($emailedAssessIDs)) {
                         $this->registry->getDbHelper('MembersHelper')->editSeveralAssess($emailedAssessIDs, array('need_remind' => 1));
                         $this->registry->getModel('ActionsLogger')->logMultiSimple($context['USER']->GetID(), 'assess', $emailedAssessIDs, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_NOTIFY);
                     }
                     if (count($fillingEmailedAssessIDs)) {
                         $emailedRespondents = $this->registry->getDbHelper('MembersHelper')->getRespondentsForAssessNotification($context['project']['projectID'], $fillingEmailedAssessIDs);
                         if ($emailedRespondents) {
                             $emailedRespondentsIDs = array();
                             foreach ($emailedRespondents as $respondent) {
                                 $emailedRespondentsIDs[] = $respondent['respondentID'];
                             }
                             $this->registry->getDbHelper('MembersHelper')->editRespondents($emailedRespondentsIDs, array('need_remind' => 1));
                             $this->registry->getModel('ActionsLogger')->logMultiSimple($context['USER']->GetID(), 'respondent', $emailedRespondentsIDs, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_NOTIFY);
                         }
                     }
                     $this->component->arResult['statusSuccess'] = 'Оцениваемые поставлены в очередь для email - напоминания';
                 }
             } elseif (isset($_POST['mode']) && $_POST['mode'] == 'report_email') {
                 // выслать уведомления о получении отчетов
                 $this->registry->getDbHelper('MembersHelper')->editSeveralAssess($selectedIDs, array('last_report_email' => '0000-00-00 00:00:00'));
                 $this->component->arResult['statusSuccess'] = 'Оцениваемым будут высланы уведомления о получении отчета';
             } elseif (isset($_POST['mode']) && $_POST['mode'] == 'report_zip') {
                 // задача на архив отчетов
                 // Создаем задачу
                 $taskID = $this->registry->getDbHelper('TasksHelper')->addTask(array('name' => '', 'type' => \Ecoplay\Helper\Db\TasksHelper::TASK_TYPE_REPORT_ZIP, 'params' => json_encode(array('projectID' => $context['project']['projectID'], 'assessIDs' => $selectedIDs)), 'userID' => $context['USER']->GetID(), 'status' => \Ecoplay\Helper\Db\TasksHelper::TASK_STATUS_NEW, 'dt_created' => date('d-m-Y H:i:s')));
                 $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'task', $taskID, \Ecoplay\Helper\Db\LogsHelper::ACTION_TYPE_ADD, null);
                 $this->component->arResult['statusSuccess'] = 'Генерация архива отчетов поставлена в очередь. Он будет доступен <a href="/projects/' . $context['project']['projectID'] . '/reportsArchives/">тут</a>';
             }
             $eventListener = new EventListener($this->registry, $context['project'], $_SERVER["DOCUMENT_ROOT"] . '/');
             if (isset($this->component->arResult['statusSuccess']) && $this->component->arResult['statusSuccess']) {
                 foreach ($assesses as $assess) {
                     if ($newStatus) {
                         $eventListener->executeEvent('Poll360_AssessStatusChanged', array('assessID' => $assess['assessID'], 'status_old' => $assess['status'], 'status_new' => $newStatus));
                     }
                     if ($needLog) {
                         $this->registry->getModel('ActionsLogger')->log($context['USER']->GetID(), 'assess', $assess['assessID'], LogsHelper::ACTION_TYPE_CHANGE, $assess);
                     }
                 }
             }
         }
         $this->component->arResult['selectedIDs'] = $selectedIDs;
         $assess = $this->registry->getDbHelper('MembersHelper')->getAssessByProjectIDAndSessionsIdsPaged($context['project']['projectID'], $availableSessionsIDs, $page, $onPage, $sorts[$sort], $order, $filterValue['filter_strings']);
         $this->component->arResult['assess'] = $assess;
         $this->component->arResult['statuses'] = $statuses;
         // кол-во email нотификаций для оцениваемого
         $emailsCnt = array();
         $editsAbility = array();
         if (count($assess)) {
             $assessIDs = array();
             foreach ($assess as $oneAssess) {
                 $assessIDs[] = $oneAssess['assessID'];
             }
             $emailsCnt = $this->registry->getDbHelper('MembersHelper')->getRespondentsForAssessNotificationCnt($context['project']['projectID'], $assessIDs);
             // чек, можно ли оцениваемому сменить группу
             $editsAbility = $this->registry->getDbHelper('MembersHelper')->getAssessEditsAbiliy($context['project']['projectID'], $assessIDs);
         }
         $this->component->arResult['emailsCnt'] = $emailsCnt;
         $this->component->arResult['editsAbility'] = $editsAbility;
         if (isset($_GET['checkAll'])) {
             $selectedIDs = array();
             foreach ($assess as $oneAssess) {
                 $selectedIDs[] = $oneAssess['assessID'];
             }
             $this->component->arResult['selectedIDs'] = $selectedIDs;
         }
         $this->component->arResult['sort'] = $sort;
         $this->component->arResult['order'] = $order;
         $this->component->arResult['cntInfo'] = $pagesCnt == 1 ? $cnt : 0;
         $roles = $this->registry->getDbHelper('ProjectsHelper')->getProjectRoles($context['project']['projectID']);
         $this->component->arResult['roles'] = $roles;
         // выводим таблицу с данными
         $this->component->IncludeComponentTemplate('table');
         $navResult = new \CDBResult();
         $navResult->NavPageCount = ceil($cnt / $onPage);
         $navResult->NavPageNomer = $page;
         $navResult->NavNum = 1;
         $navResult->NavPageSize = $onPage;
         $navResult->NavRecordCount = $cnt;
         $navResult->nPageWindow = 11;
         $context['APPLICATION']->IncludeComponent('ecoplay:system.pagenavigation', '', array('NAV_RESULT' => $navResult, 'NAV_URL' => '/projects/' . $context['project']['projectID'] . '/groups/assess/', 'NAV_QUERY_STRING' => 'sort=' . $sort . '&order=' . $order . ($filterQueryString ? '&' . $filterQueryString : '') . (isset($_GET['checkAll']) ? '&checkAll=1' : '')));
         $sessions = $this->registry->getDbHelper('ProjectsHelper')->getSessionsByIDs(array_keys($userSessions));
         $sessionRoles = array();
         foreach ($sessions as $session) {
             if ($session['param_roles']) {
                 $sessionParams = (array) json_decode($session['~param_roles']);
                 foreach ($sessionParams as $roleID => $param) {
                     if (!array_key_exists($roleID, $sessionRoles)) {
                         $sessionRoles[$roleID] = $param;
                     } else {
                         if ($param->min < $sessionRoles[$roleID]->min) {
                             $sessionRoles[$roleID]->min = $param->min;
                         }
                         if ($param->max > $sessionRoles[$roleID]->max) {
                             $sessionRoles[$roleID]->max = $param->max;
                         }
                     }
                 }
             }
         }
         $this->component->arResult['sessionsRoles'] = $sessionRoles;
     } else {
         $this->component->arResult['assess'] = null;
     }
     $context['APPLICATION']->SetPageProperty('pageMainTitle', 'Оцениваемые');
     $context['APPLICATION']->SetPageProperty('navigation', $viewHelper->generateNavigation(array(0 => array('link' => '/', 'title' => 'Главная'), 1 => array('link' => '/projects/', 'title' => 'Проекты'), 2 => array('link' => '/projects/' . $context['project']['projectID'] . '/continuing/stat/', 'title' => $context['project']['project_name']), 3 => array('link' => '/projects/' . $context['project']['projectID'] . '/settings/groups/', 'title' => 'Группы оцениваемых'), 4 => array('title' => 'Оцениваемые'))));
     $this->component->arResult['canReports'] = $this->registry->getModel('Auth')->checkAccess($_SESSION['accesses'], 'reports', $context['project']['projectID']);
     $this->component->IncludeComponentTemplate();
 }