예제 #1
0
파일: AppText.php 프로젝트: zyxist/cantiga
 /**
  * @param Connection $conn
  * @param string $place
  * @param string $locale
  * @param Project $project
  * @return AppText
  */
 public static function fetchByLocation(Connection $conn, $place, $locale, Project $project = null)
 {
     if (null === $project) {
         $data = $conn->fetchAssoc('SELECT * FROM `' . CoreTables::APP_TEXT_TBL . '` WHERE `place` = :place AND `locale` = :locale AND `projectId` IS NULL', [':place' => $place, ':locale' => $locale]);
     } else {
         $items = $conn->fetchAll('SELECT * FROM `' . CoreTables::APP_TEXT_TBL . '` ' . 'WHERE `place` = :place AND `locale` = :locale AND (`projectId` = :projectId OR `projectId` IS NULL)', [':place' => $place, ':locale' => $locale, ':projectId' => $project->getId()]);
         $data = false;
         foreach ($items as $item) {
             if ($item['projectId'] == $project->getId()) {
                 $data = $item;
                 break;
             }
         }
         if (false === $data) {
             foreach ($items as $item) {
                 if (empty($item['projectId'])) {
                     $data = $item;
                     break;
                 }
             }
         }
     }
     if (false === $data) {
         return false;
     }
     $item = self::fromArray($data);
     if (null !== $project) {
         $item->setProject($project);
     }
     return $item;
 }
 public function listData(DataTable $dataTable)
 {
     $qb = QueryBuilder::select()->field('i.id', 'id')->field('i.name', 'name')->field('i.label', 'label')->field('i.isDefault', 'isDefault')->field('i.areaNum', 'areaNum')->from(CoreTables::AREA_STATUS_TBL, 'i');
     $where = QueryClause::clause('i.`projectId` = :projectId', ':projectId', $this->project->getId());
     $recordsTotal = QueryBuilder::copyWithoutFields($qb)->field('COUNT(id)', 'cnt')->where($dataTable->buildCountingCondition($where))->fetchCell($this->conn);
     $recordsFiltered = QueryBuilder::copyWithoutFields($qb)->field('COUNT(id)', 'cnt')->where($dataTable->buildFetchingCondition($where))->fetchCell($this->conn);
     $dataTable->processQuery($qb);
     return $dataTable->createAnswer($recordsTotal, $recordsFiltered, $qb->where($dataTable->buildFetchingCondition($where))->fetchAll($this->conn));
 }
예제 #3
0
 public function findMilestoneProgressForGroupsInProject(Project $project)
 {
     $totalMilestones = $this->conn->fetchColumn('SELECT COUNT(`id`) FROM `' . MilestoneTables::MILESTONE_TBL . '` WHERE `projectId` = :projectId AND `entityType` = \'Group\'', [':projectId' => $project->getId()]);
     $results = $this->conn->fetchAll('SELECT g.`id`, g.`name`, g.`entityId`, p.`completedNum` ' . 'FROM `' . CoreTables::GROUP_TBL . '` g ' . 'INNER JOIN `' . MilestoneTables::MILESTONE_PROGRESS_TBL . '` p ON p.`entityId` = g.`entityId` ' . 'WHERE g.`projectId` = :projectId ' . 'ORDER BY p.`completedNum` DESC, g.`name`', [':projectId' => $project->getId()]);
     foreach ($results as &$result) {
         $this->processResult($totalMilestones, $result);
     }
     return $results;
 }
예제 #4
0
 public function listData(DataTable $dataTable)
 {
     $qb = QueryBuilder::select()->field('i.id', 'id')->field('i.place', 'place')->field('i.title', 'title')->field('i.locale', 'locale')->from(CoreTables::APP_TEXT_TBL, 'i');
     if (null === $this->project) {
         $where = QueryClause::clause('i.`projectId` IS NULL');
     } else {
         $where = QueryClause::clause('i.`projectId` = :projectId', ':projectId', $this->project->getId());
     }
     $qb->where($where);
     $recordsTotal = QueryBuilder::copyWithoutFields($qb)->field('COUNT(id)', 'cnt')->where($dataTable->buildCountingCondition($qb->getWhere()))->fetchCell($this->conn);
     $recordsFiltered = QueryBuilder::copyWithoutFields($qb)->field('COUNT(id)', 'cnt')->where($dataTable->buildFetchingCondition($qb->getWhere()))->fetchCell($this->conn);
     $dataTable->processQuery($qb);
     return $dataTable->createAnswer($recordsTotal, $recordsFiltered, $qb->where($dataTable->buildFetchingCondition($qb->getWhere()))->fetchAll($this->conn));
 }
예제 #5
0
 public static function fromProject(Project $project)
 {
     $root = new ForumRoot();
     $root->id = $project->getId();
     $root->name = $project->getName();
     return $root;
 }
예제 #6
0
 public function listData(DataTable $dataTable, TranslatorInterface $translator)
 {
     $qb = QueryBuilder::select()->field('i.id', 'id');
     if (!$this->root instanceof Area) {
         $qb->field('a.id', 'areaId');
         $qb->field('a.name', 'areaName');
         $qb->join(CoreTables::AREA_TBL, 'a', QueryClause::clause('a.id = i.areaId'));
     }
     $qb->field('i.subject', 'subject')->field('i.createdAt', 'createdAt')->field('i.status', 'status')->field('u.id', 'responderId')->field('u.name', 'responder')->field('i.duplicate', 'duplicate')->from(EdkTables::MESSAGE_TBL, 'i')->leftJoin(CoreTables::USER_TBL, 'u', QueryClause::clause('u.id = i.responderId'))->orderBy('i.status', 'ASC')->orderBy('i.createdAt', 'ASC');
     if ($this->root instanceof Area) {
         $qb->where(QueryClause::clause('i.`areaId` = :areaId', ':areaId', $this->root->getId()));
     } elseif ($this->root instanceof Group) {
         $qb->where(QueryClause::clause('a.`groupId` = :groupId', ':groupId', $this->root->getId()));
     } elseif ($this->root instanceof Project) {
         $qb->where(QueryClause::clause('a.`projectId` = :projectId', ':projectId', $this->root->getId()));
     }
     $qb->postprocess(function ($row) use($translator) {
         $row['statusText'] = $translator->trans(EdkMessage::statusText($row['status']), [], 'edk');
         $row['statusLabel'] = EdkMessage::statusLabel($row['status']);
         $row['createdAt'] = $this->timeFormatter->ago($row['createdAt']);
         return $row;
     });
     $recordsTotal = QueryBuilder::copyWithoutFields($qb)->field('COUNT(i.id)', 'cnt')->where($dataTable->buildCountingCondition($qb->getWhere()))->fetchCell($this->conn);
     $recordsFiltered = QueryBuilder::copyWithoutFields($qb)->field('COUNT(i.id)', 'cnt')->where($dataTable->buildFetchingCondition($qb->getWhere()))->fetchCell($this->conn);
     $dataTable->processQuery($qb);
     return $dataTable->createAnswer($recordsTotal, $recordsFiltered, $qb->where($dataTable->buildFetchingCondition($qb->getWhere()))->fetchAll($this->conn));
 }
예제 #7
0
 /**
  * Fetches the list of links to present on the dashboard.
  * 
  * @param int $presentationPlace
  */
 public function findLinks($presentationPlace)
 {
     if (null !== $this->project) {
         return $this->conn->fetchAll('SELECT `name`, `url` FROM `' . LinksTables::LINK_TBL . '` WHERE `presentedTo` = :place AND `projectId` = :projectId ORDER BY `listOrder`', [':place' => $presentationPlace, ':projectId' => $this->project->getId()]);
     } else {
         return $this->conn->fetchAll('SELECT `name`, `url` FROM `' . LinksTables::LINK_TBL . '` WHERE `presentedTo` = :place AND `projectId` IS NULL ORDER BY `listOrder`', [':place' => $presentationPlace]);
     }
 }
예제 #8
0
 public static function fetchDefault(Connection $conn, Project $project)
 {
     $data = $conn->fetchAssoc('SELECT * FROM `' . CoreTables::AREA_STATUS_TBL . '` WHERE `isDefault` = 1 AND `projectId` = :projectId', [':projectId' => $project->getId()]);
     if (empty($data)) {
         return false;
     }
     $item = self::fromArray($data);
     $item->project = $project;
     return $item;
 }
예제 #9
0
 public static function fetchByProject(Connection $conn, $id, Project $project)
 {
     $data = $conn->fetchAssoc('SELECT * FROM `' . CoreTables::GROUP_CATEGORY_TBL . '` WHERE `id` = :id AND `projectId` = :projectId', [':id' => $id, ':projectId' => $project->getId()]);
     if (empty($data)) {
         return false;
     }
     $item = self::fromArray($data);
     $item->project = $project;
     return $item;
 }
 public function countParticipants()
 {
     $this->transaction->requestTransaction();
     try {
         return $this->conn->fetchColumn('SELECT SUM(s.`participantNum`) + SUM(s.`externalParticipantNum`) ' . 'FROM `' . EdkTables::REGISTRATION_SETTINGS_TBL . '` s ' . 'INNER JOIN `' . EdkTables::ROUTE_TBL . '` r ON r.`id` = s.`routeId` ' . 'INNER JOIN `' . CoreTables::AREA_TBL . '` a ON r.`areaId` = a.`id` ' . $this->createWhereClause(), [':itemId' => $this->root->getId()]);
     } catch (Exception $ex) {
         $this->transaction->requestRollback();
         throw $ex;
     }
 }
예제 #11
0
 public static function fetchByActivator(Connection $conn, Project $project, $activator, Entity $entity)
 {
     $data = $conn->fetchAssoc('SELECT r.*, m.`id` AS `milestone_id`, m.`name` AS `milestone_name`, m.`description` AS `milestone_description`, m.`displayOrder` AS `milestone_displayOrder`, ' . 'm.`type` AS `milestone_type`, m.`entityType` AS `milestone_entityType`, m.`deadline` AS `milestone_deadline` ' . 'FROM `' . MilestoneTables::MILESTONE_RULE_TBL . '` r ' . 'INNER JOIN `' . MilestoneTables::MILESTONE_TBL . '` m ON m.`id` = r.`milestoneId` ' . 'WHERE r.`activator` = :activator AND r.`projectId` = :projectId AND m.`entityType` = :entityType', [':activator' => $activator, ':projectId' => $project->getId(), ':entityType' => $entity->getType()]);
     if (empty($data)) {
         return false;
     }
     $item = self::fromArray($data);
     $item->project = $project;
     $item->milestone = Milestone::fromArray($data, 'milestone');
     $item->milestone->setProject($project);
     return $item;
 }
 public function listData(DataTable $dataTable)
 {
     $qb = QueryBuilder::select()->field('i.id', 'id')->field('i.name', 'name')->field('r.mandatoryCourseNum', 'mandatoryCourseNum')->field('r.passedCourseNum', 'passedCourseNum')->field('r.failedCourseNum', 'failedCourseNum')->from(CoreTables::AREA_TBL, 'i')->join(CourseTables::COURSE_PROGRESS_TBL, 'r', QueryClause::clause('r.areaId = i.id'))->leftJoin(CoreTables::GROUP_TBL, 'g', QueryClause::clause('g.id = i.groupId'));
     if (null !== $this->group) {
         $qb->where(QueryClause::clause('i.`groupId` = :groupId', ':groupId', $this->group->getId()));
     } else {
         $qb->where(QueryClause::clause('i.`projectId` = :projectId', ':projectId', $this->project->getId()));
     }
     $recordsTotal = QueryBuilder::copyWithoutFields($qb)->field('COUNT(i.id)', 'cnt')->where($dataTable->buildCountingCondition($qb->getWhere()))->fetchCell($this->conn);
     $recordsFiltered = QueryBuilder::copyWithoutFields($qb)->field('COUNT(i.id)', 'cnt')->where($dataTable->buildFetchingCondition($qb->getWhere()))->fetchCell($this->conn);
     $qb->postprocess(function ($row) {
         if ($row['mandatoryCourseNum'] == 0) {
             $row['progress'] = 0;
         } else {
             $row['progress'] = $row['passedCourseNum'] / $row['mandatoryCourseNum'] * 100;
         }
         return $row;
     });
     $dataTable->processQuery($qb);
     return $dataTable->createAnswer($recordsTotal, $recordsFiltered, $qb->where($dataTable->buildFetchingCondition($qb->getWhere()))->fetchAll($this->conn));
 }
예제 #13
0
 public static function populateEntities(Connection $conn, Entity $newEntity, Project $project)
 {
     $conn->insert(MilestoneTables::MILESTONE_PROGRESS_TBL, ['entityId' => $newEntity->getId(), 'completedNum' => 0]);
     $milestones = $conn->fetchAll('SELECT `id` FROM `' . MilestoneTables::MILESTONE_TBL . '` WHERE `projectId` = :projectId AND `entityType` = :entityType', [':projectId' => $project->getId(), ':entityType' => $newEntity->getType()]);
     if (sizeof($milestones) > 0) {
         $stmt = $conn->prepare('INSERT INTO `' . MilestoneTables::MILESTONE_STATUS_TBL . '` (`entityId`, `milestoneId`, `progress`) VALUES(:entityId, :milestoneId, 0)');
         foreach ($milestones as $milestone) {
             $stmt->bindValue(':entityId', $newEntity->getId());
             $stmt->bindValue(':milestoneId', $milestone['id']);
             $stmt->execute();
         }
     }
 }
 public function getFormChoices()
 {
     $this->transaction->requestTransaction();
     $stmt = $this->conn->prepare('SELECT `id`, `name` FROM `' . CoreTables::GROUP_CATEGORY_TBL . '` WHERE `projectId` = :projectId ORDER BY `name`');
     $stmt->bindValue(':projectId', $this->project->getId());
     $stmt->execute();
     $result = array();
     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
         $result[$row['name']] = $row['id'];
     }
     $stmt->closeCursor();
     return $result;
 }
예제 #15
0
파일: Course.php 프로젝트: zyxist/cantiga
 public static function fetchPublished(Connection $conn, $id, Project $project)
 {
     $data = $conn->fetchAssoc('SELECT * FROM `' . CourseTables::COURSE_TBL . '` WHERE `id` = :id AND `projectId` = :projectId AND `isPublished` = 1', [':id' => $id, ':projectId' => $project->getId()]);
     if (empty($data)) {
         return false;
     }
     $item = self::fromArray($data);
     $item->project = $project;
     $test = $conn->fetchAssoc('SELECT * FROM `' . CourseTables::COURSE_TEST_TBL . '` WHERE `courseId` = :id', [':id' => $id]);
     if (false !== $test) {
         $item->test = new CourseTest($item, $test['testStructure']);
     }
     return $item;
 }
예제 #16
0
 public static function fetchByProject(Connection $conn, $id, Project $project)
 {
     $data = $conn->fetchAssoc('SELECT r.*, ' . ' s1.`id` AS `s1_id`, s1.`name` AS `s1_name`, s1.`label` AS `s1_label`, s1.`isDefault` AS `s1_isDefault`, s1.`areaNum` AS `s1_areaNum`, ' . ' s2.`id` AS `s2_id`, s2.`name` AS `s2_name`, s2.`label` AS `s2_label`, s2.`isDefault` AS `s2_isDefault`, s2.`areaNum` AS `s2_areaNum` ' . 'FROM `' . MilestoneTables::MILESTONE_STATUS_RULE_TBL . '` r ' . 'INNER JOIN `' . CoreTables::AREA_STATUS_TBL . '` s1 ON r.`newStatusId` = s1.`id` ' . 'INNER JOIN `' . CoreTables::AREA_STATUS_TBL . '` s2 ON r.`prevStatusId` = s2.`id` ' . 'WHERE r.`id` = :id AND r.`projectId` = :projectId', [':id' => $id, ':projectId' => $project->getId()]);
     if (empty($data)) {
         return false;
     }
     $item = self::fromArray($data);
     $item->project = $project;
     $item->newStatus = AreaStatus::fromArray($data, 's1');
     $item->prevStatus = AreaStatus::fromArray($data, 's2');
     $item->newStatus->setProject($project);
     $item->prevStatus->setProject($project);
     return $item;
 }
예제 #17
0
 public function getFormChoices($entityType)
 {
     $this->transaction->requestTransaction();
     $stmt = $this->conn->prepare('SELECT `id`, `name` FROM `' . MilestoneTables::MILESTONE_TBL . '` WHERE `projectId` = :projectId AND `entityType` = :entityType ORDER BY `displayOrder`');
     $stmt->bindValue(':projectId', $this->project->getId());
     $stmt->bindValue(':entityType', $entityType);
     $stmt->execute();
     $result = array();
     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
         $result[$row['name']] = $row['id'];
     }
     $stmt->closeCursor();
     return $result;
 }
예제 #18
0
파일: Group.php 프로젝트: zyxist/cantiga
 public static function fetchByProject(Connection $conn, $id, Project $project)
 {
     $data = $conn->fetchAssoc('SELECT g.*, ' . self::createEntityFieldList() . 'FROM `' . CoreTables::GROUP_TBL . '` g ' . self::createEntityJoin('g') . 'WHERE g.`id` = :id AND g.`projectId` = :projectId', [':id' => $id, ':projectId' => $project->getId()]);
     if (null === $data) {
         return false;
     }
     $item = Group::fromArray($data);
     $item->project = $project;
     if (!empty($data['categoryId'])) {
         $item->category = GroupCategory::fetchByProject($conn, $data['categoryId'], $project);
     }
     $item->entity = Entity::fromArray($data, 'entity');
     return $item;
 }
 public function getRecentRequests($count)
 {
     $this->transaction->requestTransaction();
     try {
         $items = $this->conn->fetchAll('SELECT r.`id`, r.`name`, u.`name` AS `username`, u.`avatar`, r.`status`, r.`createdAt` ' . 'FROM `' . CoreTables::AREA_REQUEST_TBL . '` r ' . 'INNER JOIN `' . CoreTables::USER_TBL . '` u ON u.`id` = r.`requestorId` ' . 'WHERE r.`projectId` = :projectId ' . 'ORDER BY r.`createdAt` DESC LIMIT ' . $count, [':projectId' => $this->project->getId()]);
         foreach ($items as &$item) {
             $item['statusText'] = AreaRequest::statusText($item['status']);
             $item['statusLabel'] = AreaRequest::statusLabel($item['status']);
         }
         return $items;
     } catch (Exception $ex) {
         $this->transaction->requestRollback();
         throw $ex;
     }
 }
예제 #20
0
 public static function fetchByProject(Connection $conn, $id, Project $project)
 {
     $data = $conn->fetchAssoc('SELECT r.*, v.id AS `verifier_id`, v.`name` AS `verifier_name`, ' . 't.`id` AS `territory_id`, t.`name` AS `territory_name`, t.`areaNum` AS `territory_areaNum`, t.`requestNum` as `territory_requestNum` ' . 'FROM `' . CoreTables::AREA_REQUEST_TBL . '` r ' . 'INNER JOIN `' . CoreTables::TERRITORY_TBL . '` t ON t.`id` = r.`territoryId` ' . 'LEFT JOIN `' . CoreTables::USER_TBL . '` v ON v.`id` = r.`verifierId` ' . 'WHERE r.`id` = :id AND r.`projectId` = :projectId', [':id' => $id, ':projectId' => $project->getId()]);
     if (null === $data) {
         return false;
     }
     $user = User::fetchByCriteria($conn, QueryClause::clause('u.`id` = :id', ':id', $data['requestorId']));
     $item = self::fromArray($data);
     $item->setProject($project);
     $item->setRequestor($user);
     if (!empty($data['verifier_id'])) {
         $item->verifier = new Verifier($data['verifier_id'], $data['verifier_name']);
     }
     $item->setTerritory($item->oldTerritory = Territory::fromArray($data, 'territory'));
     return $item;
 }
예제 #21
0
 public function fetchProjectSummary(Project $project)
 {
     return ['areaRequestNum' => $this->conn->fetchColumn('SELECT COUNT(`id`) FROM `' . CoreTables::AREA_REQUEST_TBL . '` WHERE `projectId` = :projectId', [':projectId' => $project->getId()]), 'areaNum' => $this->conn->fetchColumn('SELECT COUNT(`id`) FROM `' . CoreTables::AREA_TBL . '` WHERE `projectId` = :projectId', [':projectId' => $project->getId()]), 'groupNum' => $this->conn->fetchColumn('SELECT COUNT(`id`) FROM `' . CoreTables::GROUP_TBL . '` WHERE `projectId` = :projectId', [':projectId' => $project->getId()])];
 }
예제 #22
0
 public function saveSettings()
 {
     $this->storage->saveSettings($this->project->getId(), $this->settings);
 }
예제 #23
0
 public function fetchBiggestAreasByParticipants(Project $project, $max)
 {
     $values = $this->conn->fetchAll('SELECT (SUM(s.`participantNum`) + s.`externalParticipantNum`) AS `sum`, a.`id`, a.`name` ' . 'FROM `' . EdkTables::REGISTRATION_SETTINGS_TBL . '` s ' . 'INNER JOIN `' . EdkTables::ROUTE_TBL . '` r ON r.id = s.routeId ' . 'INNER JOIN `' . CoreTables::AREA_TBL . '` a ON a.id = r.areaId ' . 'WHERE a.projectId = :rootId ' . 'GROUP BY a.`id`, a.`name`', [':rootId' => $project->getId()]);
     usort($values, function ($a, $b) {
         return $b['sum'] - $a['sum'];
     });
     $result = [];
     $i = 1;
     foreach ($values as $area) {
         $result[] = $area;
         if (++$i >= $max) {
             break;
         }
     }
     return $result;
 }
예제 #24
0
 public function findAllMilestones(Entity $entity, Project $project, $editable)
 {
     $this->transaction->requestTransaction();
     try {
         $stmt = $this->conn->prepare('SELECT m.`id`, m.`name`, m.`type`, m.`description`, m.`deadline`, s.`progress`, s.`completedAt` ' . 'FROM `' . MilestoneTables::MILESTONE_TBL . '` m ' . 'INNER JOIN `' . MilestoneTables::MILESTONE_STATUS_TBL . '` s ON m.`id` = s.`milestoneId` ' . 'WHERE s.`entityId` = :entityId AND m.`projectId` = :projectId  ' . 'ORDER BY m.`displayOrder`');
         $stmt->bindValue(':entityId', $entity->getId());
         $stmt->bindValue(':projectId', $project->getId());
         $stmt->execute();
         $results = [];
         while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
             $results[] = Milestone::processStatus($row, $this->timeFormatter, $editable);
         }
         return $results;
     } catch (Exception $exception) {
         $this->transaction->requestRollback();
         throw $exception;
     }
 }
예제 #25
0
파일: Area.php 프로젝트: zyxist/cantiga
 /**
  * @param Connection $conn
  * @param int $id
  * @param \Cantiga\CoreBundle\Entity\Project $project
  * @return Area
  */
 public static function fetchByProject(Connection $conn, $id, Project $project)
 {
     $data = $conn->fetchAssoc('SELECT a.*, ' . 't.`id` AS `territory_id`, t.`name` AS `territory_name`, t.`areaNum` AS `territory_areaNum`, t.`requestNum` as `territory_requestNum`, ' . self::createEntityFieldList() . 'FROM `' . CoreTables::AREA_TBL . '` a ' . self::createEntityJoin('a') . 'INNER JOIN `' . CoreTables::TERRITORY_TBL . '` t ON t.`id` = a.`territoryId` ' . 'WHERE a.`id` = :id AND a.`projectId` = :projectId', [':id' => $id, ':projectId' => $project->getId()]);
     if (false === $data) {
         return false;
     }
     $item = Area::fromArray($data);
     $item->project = Project::fetchActive($conn, $data['projectId']);
     if (false == $item->project) {
         return false;
     }
     $item->status = $item->oldStatus = AreaStatus::fetchByProject($conn, $data['statusId'], $item->project);
     $item->setTerritory($item->oldTerritory = Territory::fromArray($data, 'territory'));
     if (!empty($data['groupId'])) {
         $item->group = $item->oldGroup = Group::fetchByProject($conn, $data['groupId'], $item->project);
     }
     $item->entity = Entity::fromArray($data, 'entity');
     return $item;
 }
예제 #26
0
 public function countRouteFiles(Project $project)
 {
     $data = $this->conn->fetchAll('SELECT r.`descriptionFile`, r.`mapFile` ' . 'FROM `' . EdkTables::ROUTE_TBL . '` r ' . 'INNER JOIN `' . CoreTables::AREA_TBL . '` a ON a.`id` = r.`areaId` ' . 'WHERE a.projectId = :rootId AND r.`approved` = 1', [':rootId' => $project->getId()]);
     $types = [0 => ['name' => 'FileStatOnlyGPS', 'value' => 0], 1 => ['name' => 'FileStatMapPresent', 'value' => 0], 2 => ['name' => 'FileStatGuidePresent', 'value' => 0], 3 => ['name' => 'FileStatMapGuidePresent', 'value' => 0]];
     foreach ($data as $route) {
         if (!empty($route['mapFile']) && !empty($route['descriptionFile'])) {
             $types[3]['value']++;
         } elseif (!empty($route['mapFile'])) {
             $types[1]['value']++;
         } elseif (!empty($route['descriptionFile'])) {
             $types[2]['value']++;
         } else {
             $types[0]['value']++;
         }
     }
     return $types;
 }