blob: c8c62ffcdcd6075e0cbf14049adf33fcc62431ba (
plain) (
blame)
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
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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
|
<?php
/**
* Created on 12.6.2009
*
* @author: Gorazd Vesleič
*
* @desc: za uporabnikove nastavitve prikaza vmesnika,
* nastavlja globalne nastavitve za vse ankete.
* Uporablja tabelo: srv_user_setting
*
* -- usr_id # user ID
* # za izpis folderjev
* -- survey_list_order # vrstni red stolpcev v Direktoriju
* -- survey_list_order_by # sortiranje po stolpcu
* -- survey_list_rows_per_page # koliko zapisov na stran (25)
* -- survey_list_visible # kateri stolpci so vidni
* -- survey_list_widths # širine posameznih stolpcev
*
* # vizualizacija
* -- icons_always_on # ali so ikonice vedno vidne
* -- full_screen_edit # ali privzeto editira vprašanja v full screen načinu
*
*/
class UserSetting
{
static private $instance; # instanca razreda
static private $userId = null; # user ID
static private $inited = false; # ali je razred inizializiran
static private $user_setting = array(); # array z uporabniškimi nastavitvami;
static private $changed = array(); # katera polja so bila spremenjena, uporabimo pri vpisovanju v bazo
protected function __construct() {}
private function __clone() {}
/** Poskrbimo za samo eno instanco razreda
*
*/
static function getInstance()
{
if(!self::$instance)
{
self::$instance = new UserSetting();
}
return self::$instance;
}
/** napolnimo podatke
*
*/
static function Init($_userId = null)
{
global $global_user_id;
if (self::$inited) {
return true;
} else {
if ($_userId == null) { // ce slucajno ni user_id-ja
$_userId = $global_user_id;
}
if ($_userId != null) {
self::$userId = $_userId;
$selectSql = "SELECT * FROM srv_user_setting WHERE usr_id = '".self::$userId."'";
$sqlUserSetting = sisplet_query($selectSql);
if ( mysqli_num_rows( $sqlUserSetting ) > 0 ) {
self::$user_setting = mysqli_fetch_assoc($sqlUserSetting);
self::$inited=true;
return true;
} else {
// uporabnik se nima svojih nastavitev. preberemo iz sistemskih
// TODO
//zaenkrat kar direkt nastavimo privzete nastavitve
self::$user_setting['icons_always_on'] = 0;
self::$user_setting['full_screen_edit'] = 0;
self::$user_setting['autoActiveSurvey'] = 0;
self::$user_setting['lockSurvey'] = 1;
self::$user_setting['activeComments'] = 0;
self::$user_setting['showIntro'] = 1;
self::$user_setting['showConcl'] = 1;
self::$user_setting['showSurveyTitle'] = 1;
self::$inited=true;
return true;
}
}
else {
return false;
}
}
}
static function getUserId() { return self::$userId; }
static function getUserSetting($what) {
return self::$user_setting[$what] ?? null;
}
/** @desc ponastavi nastavitev in shrani v bazo
*
*/
static function setUserSetting($what, $value) {
if (isset($what) && isset($value)) {
self::$changed[$what] = $value;
self::$user_setting[$what] = $value;
}
else
return false;
}
/** @desc v bazi popravimo vse spremenjene zapise zapis
*
*/
static function saveUserSetting()
{
if (self::$inited && is_countable(self::$changed) && count(self::$changed) > 0 ) {
$str_insert_fields = 'usr_id';
$str_insert_values = "'".self::$userId."'";
$str_update_text = '';
$str_update_prefix = '';
foreach (self::$changed as $what => $value) {
if (isset(self::$user_setting[$what])) {
$str_insert_fields .= ', '.$what;
$str_insert_values .= ", '".self::$user_setting[$what]."'";
$str_update_text .= $str_update_prefix . $what."='".self::$user_setting[$what]."'";
$str_update_prefix = ', ';
}
unset(self::$changed[$what]);
}
// sestavimo mysql insert string
$insertString = 'INSERT INTO srv_user_setting ('.$str_insert_fields.') VALUES ('.$str_insert_values.') ON DUPLICATE KEY UPDATE '.$str_update_text;
self::$changed = array();
$insert = sisplet_query($insertString);
return mysqli_affected_rows($GLOBALS['connect_db']);
} else { // manjkajo podatki za vpis v bazo
return false;
}
}
}
?>
|
