ecommun / owncloud_ynh

Blame view

sources/apps/documents/lib/db/member.php 2.73 KB
edit raw normal view history
d1bafeea1   Kload   [fix] Upgrade to ... 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
  <?php
  
  /**
   * ownCloud - Documents App
   *
   * @author Victor Dubiniuk
   * @copyright 2013 Victor Dubiniuk victor.dubiniuk@gmail.com
   *
   * This file is licensed under the Affero General Public License version 3 or
   * later.
   */
  
  namespace OCA\Documents;
6d9380f96   Cédric Dupont   Update sources OC... 
14
15
16
17
18
19
 
  /**
   * @method boolean getIsGuest()
   * @method string getEsId()
   * @method string getToken()
   * @method int getStatus()
   */
d1bafeea1   Kload   [fix] Upgrade to ... 
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
91
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
 
  class Db_Member extends Db{
  
  	const DB_TABLE = '`*PREFIX*documents_member`';
  
  	const ACTIVITY_THRESHOLD = 90; // 1.5 Minutes
  	
  	const MEMBER_STATUS_ACTIVE = 1;
  	const MEMBER_STATUS_INACTIVE = 2;
  	
  	protected $tableName  = '`*PREFIX*documents_member`';
  
  	protected $insertStatement  = 'INSERT INTO `*PREFIX*documents_member` (`es_id`, `uid`, `color`, `last_activity`, `is_guest`, `token`)
  			VALUES (?, ?, ?, ?, ?, ?)';
  	
  	protected $loadStatement = 'SELECT * FROM `*PREFIX*documents_member` WHERE `member_id`= ?';
  
  	public static function getGuestPostfix(){
  		return '(' . Config::getL10n()->t('guest') . ')';
  	}
  
  
  	public function updateActivity($memberId){
  		return $this->execute(
  				'UPDATE ' . $this->tableName . ' SET `last_activity`=?, `status`=? WHERE `member_id`=?',
  				array(
  					time(),
  					self::MEMBER_STATUS_ACTIVE,
  					$memberId
  				)
  		);
  	}
  	
  	
  	public function getActiveCollection($esId){
  		$result = $this->execute('
  			SELECT `es_id`, `member_id`
  			FROM ' . self::DB_TABLE . '
  			WHERE `es_id`= ?
  				AND `status`=?
  			',
  			array(
  				$esId,
  				self::MEMBER_STATUS_ACTIVE
  			)
  		);
  		$members = $result->fetchAll();
  		if (!is_array($members)){
  			$members = array();
  		}
  		return $members;
  		
  	}
  	
  	/**
  	 * Mark members as inactive
  	 * @param string $esId - session Id
  	 * @return array - list of memberId that were marked as inactive
  	 */
  	public function updateByTimeout($esId){
  		$time = $this->getInactivityPeriod();
  
  		$result = $this->execute('
  			SELECT `member_id`
  			FROM ' . self::DB_TABLE . '
  			WHERE `es_id`= ?
  				AND `last_activity`<?
  				AND `status`=?
  			',
  			array(
  				$esId,
  				$time,
  				self::MEMBER_STATUS_ACTIVE
  			)
  		);
  		
  		$deactivated = $result->fetchAll();
  		if (is_array($deactivated) && count($deactivated)){
  			$deactivated = array_map(
  				function($x){
  					return ($x['member_id']);
  				}, $deactivated
  			);
  			$this->deactivate($deactivated);
  		} else {
  			$deactivated = array();
  		}
  
  		return $deactivated;
  	}
  
  	/**
  	 * Update members to inactive state
  	 * @param array $memberIds
  	 */
  	public function deactivate($memberIds){
  		$stmt = $this->buildInQuery('member_id', $memberIds);
  		array_unshift($memberIds, self::MEMBER_STATUS_INACTIVE);
  		$this->execute('
  			UPDATE ' . $this->tableName . '
  			SET `status`=?
  			WHERE ' . $stmt,
  			$memberIds
  		);
  	}
  	
  	protected function getInactivityPeriod(){
  		return time() - self::ACTIVITY_THRESHOLD;
  	}
  }