parserCompetitors.php
1.54 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
<?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();
}
}