Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
.htaccess	237 B	-r-xr-xr-x	2026-08-17 03:12
BatchJobsRepository.php	1.44 KB	-rwxrwxr-x	2026-04-02 12:06
ErrorLogRepository.php	3.3 KB	-rwxrwxr-x	2026-05-25 12:28
KeyValueRepository.php	1.78 KB	-rwxrwxr-x	2026-04-02 12:06
PickListRepository.php	1.43 KB	-rwxrwxr-x	2026-04-02 12:06
SystemSettingGroupRepository.php	1.54 KB	-rwxrwxr-x	2026-04-02 12:06
SystemSettingRepository.php	1.48 KB	-rwxrwxr-x	2026-04-02 12:06
TempValueRepository.php	1.44 KB	-rwxrwxr-x	2026-04-02 12:06
php_errors.log	2.13 KB	-rwxrwxr-x	2026-04-02 12:06

Rename

<?php

namespace App\CoreBundle\Repository;

use App\CoreBundle\Entity\ErrorLog;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\Persistence\ManagerRegistry;

/**
 * ErrorLog Repository
 *
 * @author Otto Saayman <otto@igotafrica.com>
 * @package CoreBundle
 * @subpackage Repository
 * @version 0.0.1
 */
class ErrorLogRepository extends ServiceEntityRepository
{
    public function __construct(ManagerRegistry $registry)
    {
        parent::__construct($registry, ErrorLog::class);
    }

/**
     * Find error logs by type
     *
     * @param bool $isInfo
     * @return array
     */
    public function findByType(bool $isInfo): array
    {
        return $this->createQueryBuilder('e')
            ->where('e.is_info = :isInfo')
            ->setParameter('isInfo', $isInfo)
            ->orderBy('e.created_at', 'DESC')
            ->getQuery()
            ->getResult();
    }

/**
     * Find error logs by date range
     *
     * @param \DateTime $startDate
     * @param \DateTime $endDate
     * @return array
     */
    public function findByDateRange(\DateTime $startDate, \DateTime $endDate): array
    {
        return $this->createQueryBuilder('e')
            ->where('e.created_at >= :startDate')
            ->andWhere('e.created_at <= :endDate')
            ->setParameter('startDate', $startDate)
            ->setParameter('endDate', $endDate)
            ->orderBy('e.created_at', 'DESC')
            ->getQuery()
            ->getResult();
    }

/**
     * Find error logs by session ID
     *
     * @param string $sessionId
     * @return array
     */
    public function findBySessionId(string $sessionId): array
    {
        return $this->createQueryBuilder('e')
            ->where('e.session_id = :sessionId')
            ->setParameter('sessionId', $sessionId)
            ->orderBy('e.created_at', 'DESC')
            ->getQuery()
            ->getResult();
    }

/**
     * Find error logs by created by
     *
     * @param string $createdBy
     * @return array
     */
    public function findByCreatedBy(string $createdBy): array
    {
        return $this->createQueryBuilder('e')
            ->where('e.created_by = :createdBy')
            ->setParameter('createdBy', $createdBy)
            ->orderBy('e.created_at', 'DESC')
            ->getQuery()
            ->getResult();
    }

/**
     * Get recent error logs
     *
     * @param int $limit
     * @return array
     */
    public function getRecent(int $limit = 100): array
    {
        return $this->createQueryBuilder('e')
            ->orderBy('e.created_at', 'DESC')
            ->setMaxResults($limit)
            ->getQuery()
            ->getResult();
    }

/**
     * Get error logs count by type
     *
     * @return array
     */
    public function getCountByType(): array
    {
        $qb = $this->createQueryBuilder('e')
            ->select('e.is_info, COUNT(e.id) as count')
            ->groupBy('e.is_info');

$result = $qb->getQuery()->getResult();

$counts = [
            'errors' => 0,
            'info' => 0
        ];

foreach ($result as $row) {
            if ($row['is_info']) {
                $counts['info'] = $row['count'];
            } else {
                $counts['errors'] = $row['count'];
            }
        }

return $counts;
    }
}