<?php

class ApiErrors extends \Phalcon\Mvc\Model
{
    public function initialize()
    {
        $this->setSchema("jaga");
        $this->setSource("api_errors");
    }
    
    public function search($api_name, $log, $start_date, $end_date, $limit, $offset)
    {
        $queryBuilder = $this->modelsManager->createBuilder()
        ->columns('*')
        ->from('ApiErrors');
     
        $queryBuilder
        ->where(
            'lower(api_name) like :api_name: and lower(log) like :log: and date(created_at) between :start_date: and :end_date:',
            array(
                'api_name' => '%'.strtolower($api_name).'%',
                'log' => '%'.strtolower($log).'%',
                'start_date' => $start_date,
                'end_date' => $end_date,
            )
        );
        
        return $queryBuilder->limit($limit)->offset($offset)
        ->getQuery()
        ->execute();
    }
}