parserSections.php
1.67 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
45
46
47
48
49
50
51
52
53
54
55
<?php
class parserSections extends \Phalcon\Mvc\Model
{
public $project_id;
public $section_name;
public $section_user_id;
public function getSource()
{
return "parser_sections";
}
public function initialize()
{
$this->hasMany("id", "parserItems", "section_id");
$this->hasMany("id", "brandManagers", "brand_id");
}
static function checkSection($project_id, $row_id){
return self::findFirst("section_user_id = ".$row_id." AND project_id = ".$project_id);
}
public function getData($modelsManager, $project_id){
$sql = "SELECT parserSections.*, parserItems.*
FROM parserSections, parserItems
WHERE parserSections.id = parserItems.section_id AND parserSections.project_id = :project_id:";
return $modelsManager->executeQuery($sql,
array(
'project_id' => $project_id
));
}
public function updateStatus($project_id, $modelsManager ){
$sql = "UPDATE parserSections SET delete_row = 1 WHERE project_id = {$project_id} ";
return $modelsManager->executeQuery($sql);
}
public function DeleteNonActive($modelsManager){
self::find("delete_row = 1")->delete();
}
function isActive($id_list) {
$list = explode(',',$id_list );
if(in_array($this->id, $list)){
return true;
}
}
public function getDistinct($data,$name,$modelsManager, $project_id){
$sql = "SELECT DISTINCT id, {$data} FROM parserSections WHERE {$data} ILIKE '%$name%' AND project_id = {$project_id}";
return $modelsManager->createQuery($sql)->execute()->toArray();
}
}