Subversion-Projekte lars-tiefland.ci

Revision

Revision 1436 | Revision 2069 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1436 Revision 2068
Zeile 1... Zeile 1...
1
<?php
1
<?php
Zeile 2... Zeile 2...
2
 
2
 
3
// $Id: weban_helper.php 713 2016-09-29 17:39:30Z lars $
3
// $Id: weban_helper.php 713 2016-09-29 17:39:30Z lars $
4
setlocale(LC_TIME, "de_DE.UTF-8");
4
setlocale(LC_TIME, "de_DE.UTF-8");
-
 
5
$GLOBALS['ci'] = &get_instance();
-
 
6
 
-
 
7
$csrf_name = $GLOBALS["ci"]->security->get_csrf_token_name();
-
 
8
$csrf_value = $GLOBALS["ci"]->security->get_csrf_hash();
-
 
9
$GLOBALS["ci"]->smarty->assign('csrf_name', $csrf_name);
-
 
10
$GLOBALS["ci"]->smarty->assign('csrf_value', $csrf_value);
-
 
11
if (!isset($_SESSION['username']))
-
 
12
{
-
 
13
	if (!isset($_SESSION["redirected"]))
-
 
14
	{
-
 
15
		$_SESSION["redirected"] = true;
-
 
16
		header("Location:/backend/Login/");
-
 
17
		exit;
-
 
18
	}
-
 
19
	return;
-
 
20
}
-
 
21
$web_rechte = array();
-
 
22
$user_rechte = array();
-
 
23
$GLOBALS["ci"]->load->model('termine_model', 'termine');
-
 
24
$termine = $GLOBALS["ci"]->termine->get_list();
-
 
25
$GLOBALS["ci"]->smarty->assign('termine', $termine);
-
 
26
$sql = "SELECT
-
 
27
		*
-
 
28
	FROM
-
 
29
		webs
-
 
30
	WHERE
-
 
31
		domain='".__SHOP__."'
-
 
32
";
-
 
33
$res = $GLOBALS["db_red"]->query($sql);
-
 
34
$GLOBALS["webs"] = $res->row_array();
-
 
35
$base = $_SERVER["DOCUMENT_ROOT"]."/backend/css";
-
 
36
$extra = "/".__SHOP__."/";
-
 
37
$file = "jquery-ui.custom.css";
-
 
38
$css_file = $base.$extra.$file;
-
 
39
if (!file_exists($css_file))
-
 
40
{
-
 
41
	$extra = "/start/";
-
 
42
}
-
 
43
$css_file = "/backend/css".$extra.$file;
-
 
44
$GLOBALS["ci"]->smarty->assign("jquery_ui_css", $css_file);
-
 
45
$GLOBALS["ci"]->smarty->assign("webs", $GLOBALS["webs"]);
-
 
46
 
-
 
47
$sql = "SELECT
-
 
48
		modules.interner_name AS m_name,
-
 
49
		tools.button_name AS t_name,
-
 
50
		properties.interner_name AS p_name,
-
 
51
		webs_properties.Bezeichnung,
-
 
52
		filename
-
 
53
	FROM
-
 
54
		webs,
-
 
55
        webs_properties,
-
 
56
        properties,
-
 
57
        tools,
-
 
58
        modules
-
 
59
    WHERE
-
 
60
        webs.domain='".__SHOP__."'
-
 
61
    AND
-
 
62
        webs_properties.webs=webs.ID
-
 
63
    AND
-
 
64
        webs_properties.properties=properties.ID
-
 
65
    AND
-
 
66
        properties.tools = tools.ID
-
 
67
    AND
-
 
68
        tools.modules = modules.ID
-
 
69
    ORDER BY
-
 
70
        properties.Rang
-
 
71
";
-
 
72
 
-
 
73
$result = $GLOBALS["db_red"]->query($sql);
-
 
74
while ($zeile = $result->unbuffered_row('array'))
-
 
75
{
-
 
76
	//var_dump($zeile);
-
 
77
	//exit;
-
 
78
	if (!$zeile["Bezeichnung"])
-
 
79
	{
-
 
80
		$zeile["Bezeichnung"] = "";
-
 
81
	}
-
 
82
	$zeile["Bezeichnung"] = explode("|", $zeile["Bezeichnung"]);
-
 
83
 
-
 
84
	if (count($zeile["Bezeichnung"]) == 1)
-
 
85
	{
-
 
86
		$zeile["Bezeichnung"] = $zeile["Bezeichnung"][0];
-
 
87
	}
-
 
88
 
-
 
89
	$web_rechte[$zeile["m_name"]][$zeile["t_name"]][$zeile["p_name"]] = $zeile["Bezeichnung"];
-
 
90
}
-
 
91
 
-
 
92
foreach (array_keys($web_rechte) as $a)
-
 
93
{
-
 
94
	foreach (array_keys($web_rechte[$a]) as $b)
-
 
95
	{
-
 
96
		foreach (array_keys($web_rechte[$a][$b]) as $c)
-
 
97
		{
-
 
98
			if (is_array($web_rechte[$a][$b][$c]))
-
 
99
			{
-
 
100
				//if (in_array($_SESSION[language], $web_rechte[$a][$b][$c]))
-
 
101
				{
-
 
102
					$web_rechte[$a][$b][$c] = $web_rechte[$a][$b][$c][array_search($_SESSION["language"],
-
 
103
						array_keys($web_rechte["online_shop"]["language"]))];
-
 
104
				}
-
 
105
				if ($web_rechte[$a][$b][$c] == "./.")
-
 
106
				{
-
 
107
					unset($web_rechte[$a][$b][$c]);
-
 
108
				}
-
 
109
			}
-
 
110
		}
-
 
111
	}
-
 
112
}
-
 
113
 
-
 
114
unset($query);
-
 
115
unset($result);
-
 
116
unset($zeile);
-
 
117
$GLOBALS["ci"]->smarty->assign("web_rechte", $web_rechte);
-
 
118
if ($GLOBALS["ci"]->session->user_data["user"] == "admin")
-
 
119
{
-
 
120
	$user_rechte = $web_rechte;
-
 
121
}
-
 
122
else
-
 
123
{
-
 
124
	$sql = "
-
 
125
		SELECT
-
 
126
			modules.interner_name AS module,
-
 
127
			tools.button_name AS tool,
-
 
128
			properties.interner_name AS property
-
 
129
		FROM
-
 
130
			webs,
-
 
131
			Access,
-
 
132
			webs_properties,
-
 
133
			user_properties,
-
 
134
			properties,
-
 
135
			tools,
-
 
136
			modules
-
 
137
		WHERE
-
 
138
			webs.domain='".__SHOP__."'
-
 
139
		AND
-
 
140
			webs_properties.webs=webs.ID
-
 
141
		AND
-
 
142
			webs_properties.properties=properties.ID
-
 
143
		AND
-
 
144
			Access.user='".$GLOBALS["ci"]->session->user_data["user"]."'
-
 
145
		AND
-
 
146
			user_properties.Access=Access.ID
-
 
147
		AND
-
 
148
			user_properties.properties=properties.ID
-
 
149
		AND
-
 
150
			properties.tools = tools.ID
-
 
151
		AND
-
 
152
			tools.modules = modules.ID
-
 
153
	";
-
 
154
	$result = $GLOBALS["db_red"]->query($sql);
-
 
155
	while ($zeile = $result->unbuffered_row('array'))
-
 
156
	{
-
 
157
		$user_rechte[$zeile["module"]][$zeile["tool"]][$zeile["property"]] = 1;
-
 
158
	}
-
 
159
}
-
 
160
$GLOBALS["ci"]->smarty->assign("user_rechte", $user_rechte);
-
 
161
$query_modules = "SELECT
-
 
162
		*
-
 
163
	FROM
-
 
164
		modules
-
 
165
	ORDER BY
-
 
166
		rang
-
 
167
";
-
 
168
 
-
 
169
$result_modules = $GLOBALS['db_red']->query($query_modules);
-
 
170
while ($zeile_modules = $result_modules->unbuffered_row('array'))
-
 
171
{
-
 
172
	$u_tools = array();
-
 
173
	if (isset($user_rechte[$zeile_modules["interner_name"]]))
-
 
174
	{
-
 
175
		$query_tools = "SELECT
-
 
176
				*
-
 
177
			FROM
-
 
178
				tools
-
 
179
			WHERE
-
 
180
				tools.modules = ".$zeile_modules["ID"]."
-
 
181
			AND
-
 
182
				tools.hidden='false'
-
 
183
			ORDER BY
-
 
184
				tools.rang
-
 
185
		";
-
 
186
 
-
 
187
		$result_tools = $GLOBALS['db_red']->query($query_tools);
-
 
188
		while ($zeile_tools = $result_tools->unbuffered_row('array'))
-
 
189
		{
-
 
190
			if (isset($user_rechte[$zeile_modules["interner_name"]][$zeile_tools["button_name"]]))
-
 
191
			{
-
 
192
				if ($zeile_tools["filename"])
-
 
193
				{
-
 
194
					$images_Pfad = 'images/navigation/';
-
 
195
					$imgsrc = $images_Pfad.'bt_'.$zeile_tools["button_name"].'.gif';
-
 
196
					$imgsrc_f2 = $images_Pfad.'bt_'.$zeile_tools["button_name"].'_f2.gif';
-
 
197
					$u_tools[] = array(
-
 
198
						"ID" => $zeile_tools["ID"],
-
 
199
						"image" => $imgsrc,
-
 
200
						"image_f2" => $imgsrc_f2,
-
 
201
						"filename" => $zeile_tools["filename"],
-
 
202
						"name" => $zeile_tools["name"],
-
 
203
						"icon" => $zeile_tools["icon"],
-
 
204
						);
-
 
205
				}
-
 
206
			}
-
 
207
		}
-
 
208
		if ($u_tools)
-
 
209
		{
-
 
210
			$u_modules[] = array(
-
 
211
				"name" => $zeile_modules["name"],
-
 
212
				"interner_name" => $zeile_modules["interner_name"],
-
 
213
				"ID" => $zeile_modules["ID"],
-
 
214
				"count" => count($user_rechte[$zeile_modules["interner_name"]]),
-
 
215
				"tools" => $u_tools,
-
 
216
				"icon" => $zeile_modules["icon"],
-
 
217
				);
-
 
218
		}
-
 
219
	}
-
 
220
}
-
 
221
$GLOBALS["ci"]->smarty->assign('u_modules', $u_modules);
-
 
222
$GLOBALS["web_rechte"] = $web_rechte;
-
 
223
$GLOBALS["user_rechte"] = $user_rechte;
5
$GLOBALS['ci'] = &get_instance();
224
 
6
$GLOBALS['order_db'] = $GLOBALS['ci']->load->database('order_db', TRUE);
225
$GLOBALS['order_db'] = $GLOBALS['ci']->load->database('order_db', TRUE);
7
$GLOBALS['db_red'] = $GLOBALS['ci']->load->database('db_red', TRUE);
226
$GLOBALS['db_red'] = $GLOBALS['ci']->load->database('db_red', TRUE);
Zeile 8... Zeile 227...
8
//$GLOBALS['ci']->load->model('artikel_model', 'artikel');
227
//$GLOBALS['ci']->load->model('artikel_model', 'artikel');