<?php
class parserCompetitors extends \Phalcon\Mvc\Model
{

    public $name;
    public $h1_regexr;
    public $url;
    public $price_regexr;
    public $sections_id;

    public function getSource()
    {
        return "parser_competitors";
    }


    public function initialize()
    {
        $this->hasMany("id", "parserCompetitorsItems", "competitor_id");
    }

   /* public function getData($modelsManager, $sections_id, $id){

        $sql = "SELECT parserSections.*, parserItems.*, parserCompetitorsItems.*
                FROM parserSections, parserItems, parserCompetitorsItems
                WHERE parserSections.id IN ('$sections_id') AND parserCompetitorsItems.competitor_id = $id";
        return $modelsManager->executeQuery($sql);
    }*/

    public function getData($modelsManager, $sections_id, $id){

        $sql = "SELECT parserSections.*, parserItems.*, parserCompetitorsItems.*
                FROM parserSections
                LEFT JOIN parserItems ON parserSections.id = parserItems.section_id
                LEFT JOIN parserCompetitorsItems ON parserCompetitorsItems.item_id = parserItems.id
                WHERE parserSections.id IN ('$sections_id') AND parserCompetitorsItems.competitor_id = $id";
        return $modelsManager->executeQuery($sql);
    }

    public function getDistinct($data,$name,$modelsManager, $project_id){
        $sql = "SELECT DISTINCT id, {$data} FROM parserCompetitors WHERE {$data} ILIKE '%$name%' AND project_id = {$project_id}";
        return $modelsManager->createQuery($sql)->execute()->toArray();
    }
}