spyEvent.php
1.37 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
use Phalcon\Mvc\Model;
class SpyEvent extends \Phalcon\Mvc\Model
{
public function getSource()
{
return "spy_event";
}
public function spyTimeAfter($project,$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)
{
$now = date("Y-m-d H:i:s");
$date1 = new DateTime($now);
$date1->modify('-3 hours');
$date1 = $date1->format('Y-m-d H:i:s');
$date2 = new DateTime($now);
$date2->modify('-11 hours');
$date2 = $date2->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}' OR date <= '{$date2}'";
//äîáàâèòü êîä íèæå äëÿ ïðîâåðêè âðåìåíè
// AND action = 'order_add' AND date <= '{$date}'
return $modelsManager->executeQuery($phql)->toArray();
}
}