<?php

/**
 * Lifestyle Webconsulting GmbH
 *
 * LICENSE: This Software is the property of Lifestyle Webconsulting GmbH (Aschaffenburg, Germany)
 * and is private by copyright law - it is NOT Freeware.
 *
 * Any unauthorized use of this software without a valid license
 * is a violation of the license agreement and will be prosecuted by
 * civil and criminal law.
 *
 * @copyright  2018 Lifestyle Webconsulting GmbH
 * @link       http://www.life-style.de
 */

namespace LifeStyle\Tools\DbLogBundle\Entity;

use Doctrine\ORM\EntityRepository;

/**
 * Class SystemLogRepository
 * @package LifeStyle\Tools\DbLogBundle\Entity
 */
class SystemLogRepository extends EntityRepository
{
    /**
     * @return array
     */
    public function findLatest()
    {
        $qb = $this->createQueryBuilder('l');
        $qb->add('orderBy', 'l.id DESC');
        $qb->setMaxResults(200);

        //Get our query
        $q = $qb->getQuery();

        //Return result
        return $q->getResult();
    }
}
