spyEvent.php
1.29 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
<?php
use Phalcon\Mvc\Model;
class SpyEvent extends \Phalcon\Mvc\Model
{
public function getSource()
{
return "spy_event";
}
public function spyTimeAfter($project_id,$customer_id){
return self::query()
->columns(['customer_id', 'st.id, st.item_id', 'st.item_name', 'st.item_image', 'st.quantity', 'st.price', 'st.item_url', 'st.item_image'])
->rightJoin('spyStore', 'st.spy_event_id = SpyEvent.id', 'st')
->where("project_id = :project_id:")
->andWhere("action ='order_add'")
->andWhere("customer_id =$customer_id")
->bind(array("project_id" => $project_id))
->execute();
}
public function getSpyUsers($modelsManager, $project, $time)
{
$now = date("Y-m-d H:i:s");
$date1 = new DateTime($now);
$date1->modify($time);
$date1 = $date1->format('Y-m-d H:i:s');
$phql = "SELECT DISTINCT (customer_id) as id FROM SpyEvent WHERE project_id = {$project->id} AND action = 'order_add' AND date <= '{$date1}'";
//�������� ��� ���� ��� �������� �������
// AND action = 'order_add' AND date <= '{$date}'
return $modelsManager->executeQuery($phql)->toArray();
}
}