/
UserProgress.php
80 lines (62 loc) · 2.39 KB
/
UserProgress.php
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
<?php
namespace Concrete\Core\Workflow\Progress;
use Concrete\Core\Workflow\Request\UserRequest;
use Loader;
use \Concrete\Core\Workflow\Workflow;
class UserProgress extends Progress
{
// Notice: here uID is requested user id, NOT requester user id
protected $uID;
public function loadDetails()
{
$db = Loader::db();
$row = $db->GetRow('select uID from UserWorkflowProgress where wpID = ?', array($this->wpID));
$this->setPropertiesFromArray($row);
}
public function delete()
{
parent::delete();
$db = Loader::db();
$db->Execute('delete from UserWorkflowProgress where wpID = ?', array($this->wpID));
}
public static function add(Workflow $wf, UserRequest $wr)
{
$wp = parent::add('user', $wf, $wr);
$db = Loader::db();
$db->Replace('UserWorkflowProgress',
array('uID' => $wr->getRequestedUserID(), 'wpID' => $wp->getWorkflowProgressID()), array('uID', 'wpID'),
true);
$wp->uID = $wr->getRequestedUserID();
return $wp;
}
public function getWorkflowProgressFormAction()
{
return REL_DIR_FILES_TOOLS_REQUIRED . '/' . DIRNAME_WORKFLOW . '/categories/user?task=save_user_workflow_progress&uID=' . $this->uID . '&wpID=' . $this->getWorkflowProgressID() . '&' . Loader::helper('validation/token')->getParameter('save_user_workflow_progress');
}
public function getPendingWorkflowProgressList()
{
$list = new \Concrete\Core\User\Workflow\Progress\ProgressList();
$list->filter('wpApproved', 0);
$list->sortBy('wpDateLastAction', 'desc');
return $list;
}
public static function getList($requestedUID, $filters = array('wpIsCompleted' => 0), $sortBy = 'wpDateAdded asc')
{
$db = Loader::db();
$filter = '';
foreach ($filters as $key => $value) {
$filter .= ' and ' . $key . ' = ' . $value . ' ';
}
$filter .= ' order by ' . $sortBy;
$r = $db->Execute('SELECT wp.wpID FROM UserWorkflowProgress uwp INNER JOIN WorkflowProgress wp ON wp.wpID = uwp.wpID WHERE uwp.uID = ? ' . $filter,
$requestedUID);
$list = array();
while ($row = $r->FetchRow()) {
$wp = UserProgress::getByID($row['wpID']);
if (is_object($wp)) {
$list[] = $wp;
}
}
return $list;
}
}