Newer
Older
<?php
/*********************************************************************
class.lock.php
Ticket lock handle.
Peter Rotich <peter@osticket.com>
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
78
79
80
81
82
83
84
85
86
87
88
89
90
http://www.osticket.com
Released under the GNU General Public License WITHOUT ANY WARRANTY.
See LICENSE.TXT for details.
vim: expandtab sw=4 ts=4 sts=4:
**********************************************************************/
/*
* Mainly used as a helper...
*/
class TicketLock {
var $id;
var $ht;
function TicketLock($id, $tid=0) {
$this->id=0;
$this->load($id, $tid);
}
function load($id=0, $tid=0) {
if(!$id && $this->ht['id'])
$id=$this->ht['id'];
$sql='SELECT l.*, TIME_TO_SEC(TIMEDIFF(expire,NOW())) as timeleft '
.' ,IF(s.staff_id IS NULL,"staff",CONCAT_WS(" ", s.lastname, s.firstname)) as staff '
.' FROM '.TICKET_LOCK_TABLE. ' l '
.' LEFT JOIN '.STAFF_TABLE.' s ON(s.staff_id=l.staff_id) '
.' WHERE lock_id='.db_input($id);
if($tid)
$sql.=' AND ticket_id='.db_input($tid);
if(!($res=db_query($sql)) || !db_num_rows($res))
return false;
$this->ht=db_fetch_array($res);
$this->id=$this->ht['id']=$this->ht['lock_id'];
$this->ht['expiretime']=time()+$this->ht['timeleft'];
return true;
}
function reload() {
return $this->load();
}
function getId() {
return $this->id;
}
function getStaffId() {
return $this->ht['staff_id'];
}
function getStaffName() {
return $this->ht['staff'];
}
function getCreateTime() {
return $this->ht['created'];
}
function getExpireTime() {
return $this->ht['expire'];
}
//Get remaiming time before the lock expires
function getTime() {
return $this->isExpired()?0:($this->ht['expiretime']-time());
}
//Should we be doing realtime check here? (Ans: not really....expiretime is local & based on loadtime)
function isExpired() {
return (time()>$this->ht['expiretime']);
}
//Renew existing lock.
function renew($lockTime=0) {
if(!$lockTime || !is_numeric($lockTime)) //XXX: test to make it works.
$lockTime = '(TIME_TO_SEC(TIMEDIFF(expire,created))/60)';
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
$sql='UPDATE '.TICKET_LOCK_TABLE
.' SET expire=DATE_ADD(NOW(),INTERVAL '.$lockTime.' MINUTE) '
.' WHERE lock_id='.db_input($this->getId());
//echo $sql;
if(!db_query($sql) || !db_affected_rows())
return false;
$this->reload();
return true;
}
//release aka delete a lock.
function release() {
//FORCED release - we don't give a ....
$sql='DELETE FROM '.TICKET_LOCK_TABLE.' WHERE lock_id='.db_input($this->getId()).' LIMIT 1';
return (db_query($sql) && db_affected_rows());
}
/* ----------------------- Static functions ---------------------------*/
function lookup($id, $tid) {
return ($id && ($lock = new TicketLock($id,$tid)) && $lock->getId()==$id)?$lock:null;
}
//Create a ticket lock...this function assumes the caller checked for access & validity of ticket & staff x-ship.
function acquire($ticketId, $staffId, $lockTime) {
if(!$ticketId or !$staffId or !$lockTime)
return 0;
//Cleanup any expired locks on the ticket.
db_query('DELETE FROM '.TICKET_LOCK_TABLE.' WHERE ticket_id='.db_input($ticketId).' AND expire<NOW()');
//create the new lock.
$sql='INSERT IGNORE INTO '.TICKET_LOCK_TABLE.' SET created=NOW() '
.',ticket_id='.db_input($ticketId)
.',staff_id='.db_input($staffId)
.',expire=DATE_ADD(NOW(),INTERVAL '.$lockTime.' MINUTE) ';
return db_query($sql)?db_insert_id():0;
}
function create($ticketId, $staffId, $lockTime) {
if(($id=self::acquire($ticketId, $staffId, $lockTime)))
return self::lookup($id);
}
//Simply remove ALL locks a user (staff) holds on a ticket(s).
function removeStaffLocks($staffId, $ticketId=0) {
$sql='DELETE FROM '.TICKET_LOCK_TABLE.' WHERE staff_id='.db_input($staffId);
if($ticketId)
$sql.=' AND ticket_id='.db_input($ticketId);
return db_query($sql);
}
function cleanup() {
//Cleanup any expired locks.
db_query('DELETE FROM '.TICKET_LOCK_TABLE.' WHERE expire<NOW()');
}
}
?>