Subversion-Projekte lars-tiefland.ci

Revision

Revision 1555 | Revision 1557 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

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