WebSVN – lars-tiefland.ci – Diff – /backend/libraries/Weban_backend.php

 /**
+ *
  * @package WebanOS CI
  * @author Lars Tiefland <ltiefland@gmail.com>
  * @copyright 2016
- * @version $Rev: 2253 $
+ * @version $Rev: 2255 $
  */
 class Weban_backend
 {
-    public function __construct()
+	public function __construct()
-    {
+	{
-        $CI = &get_instance();
+		$CI = &get_instance();
-        $csrf_name = $CI->security->get_csrf_token_name();
+		$csrf_name = $CI->security->get_csrf_token_name();
-        $csrf_value = $CI->security->get_csrf_hash();
+		$csrf_value = $CI->security->get_csrf_hash();
-        $CI->smarty->assign('csrf_name', $csrf_name);
+		$CI->smarty->assign('csrf_name', $csrf_name);
-        $CI->smarty->assign('csrf_value', $csrf_value);
+		$CI->smarty->assign('csrf_value', $csrf_value);
-        if (!isset($_SESSION['username'])) {
+		if (!isset($_SESSION['username'])) {
-            if (!isset($_SESSION["redirected"])) {
+			if (!isset($_SESSION["redirected"])) {
-                $_SESSION["redirected"] = true;
+				$_SESSION["redirected"] = true;
-                header("Location:/backend/Login/");
+				header("Location:/backend/Login/");
-                exit;
+				exit;
-            }
+			}
-            return;
+			return;
-        }
+		}
-        $web_rechte = array();
+		$web_rechte = array();
-        $user_rechte = array();
+		$user_rechte = array();
-        $CI->load->model('termine_model', 'termine');
+		$CI->load->model('termine_model', 'termine');
-        $termine = $CI->termine->get_list();
+		$termine = $CI->termine->get_list();
-        $CI->smarty->assign('termine', $termine);
+		$CI->smarty->assign('termine', $termine);
-        $sql = "SELECT
+		$sql = "SELECT
+				*
 			FROM
 				webs
 			WHERE
 				domain='" . __SHOP__ . "'
 		";
-        $res = $GLOBALS["db_red"]->query($sql);
+		$res = $GLOBALS["db_red"]->query($sql);
-        $GLOBALS["webs"] = $res->row_array();
+		$GLOBALS["webs"] = $res->row_array();
-        $base = $_SERVER["DOCUMENT_ROOT"] . "/backend/css";
+		$base = $_SERVER["DOCUMENT_ROOT"] . "/backend/css";
-        $extra = "/" . __SHOP__ . "/";
+		$extra = "/" . __SHOP__ . "/";
-        $file = "jquery-ui.custom.css";
+		$file = "jquery-ui.custom.css";
-        $css_file = $base . $extra . $file;
+		$css_file = $base . $extra . $file;
-        if (!file_exists($css_file)) {
+		if (!file_exists($css_file)) {
-            $extra = "/start/";
+			$extra = "/start/";
-        }
+		}
-        $css_file = "/backend/css" . $extra . $file;
+		$css_file = "/backend/css" . $extra . $file;
-        $CI->smarty->assign("jquery_ui_css", $css_file);
+		$CI->smarty->assign("jquery_ui_css", $css_file);
-        $CI->smarty->assign("webs", $GLOBALS["webs"]);
+		$CI->smarty->assign("webs", $GLOBALS["webs"]);
-        $sql = "SELECT
+		$sql = "SELECT
 				modules.interner_name AS m_name,
 				tools.button_name AS t_name,
 				properties.interner_name AS p_name,
 				webs_properties.Bezeichnung,
 				filename
 			FROM
 				webs,
-		        webs_properties,
+				webs_properties,
-		        properties,
+				properties,
-		        tools,
+				tools,
-		        modules
+				modules
-		    WHERE
+			WHERE
-		        webs.domain='" . __SHOP__ . "'
+				webs.domain='" . __SHOP__ . "'
-		    AND
+			AND
-		        webs_properties.webs=webs.ID
+				webs_properties.webs=webs.ID
-		    AND
+			AND
-		        webs_properties.properties=properties.ID
+				webs_properties.properties=properties.ID
-		    AND
+			AND
-		        properties.tools = tools.ID
+				properties.tools = tools.ID
+			AND
+				tools.modules = modules.ID
-		    AND
+			AND
-		        tools.modules = modules.ID
+				tools.filename LIKE '/backend/%/'
-		    ORDER BY
+			ORDER BY
-		        properties.Rang
+				properties.Rang
 		";
-        $result = $GLOBALS["db_red"]->query($sql);
+		$result = $GLOBALS["db_red"]->query($sql);
-        while ($zeile = $result->unbuffered_row('array')) {
+		while ($zeile = $result->unbuffered_row('array')) {
-            //var_dump($zeile);
+			//var_dump($zeile);
-            //exit;
+			//exit;
-            if (!$zeile["Bezeichnung"]) {
+			if (!$zeile["Bezeichnung"]) {
-                $zeile["Bezeichnung"] = "";
+				$zeile["Bezeichnung"] = "";
-            }
+			}
-            $zeile["Bezeichnung"] = explode("|", $zeile["Bezeichnung"]);
+			$zeile["Bezeichnung"] = explode("|", $zeile["Bezeichnung"]);
-            if (count($zeile["Bezeichnung"]) == 1) {
+			if (count($zeile["Bezeichnung"]) == 1) {
-                $zeile["Bezeichnung"] = $zeile["Bezeichnung"][0];
+				$zeile["Bezeichnung"] = $zeile["Bezeichnung"][0];
-            }
+			}
-            $web_rechte[$zeile["m_name"]][$zeile["t_name"]][$zeile["p_name"]] = $zeile["Bezeichnung"];
+			$web_rechte[$zeile["m_name"]][$zeile["t_name"]][$zeile["p_name"]] = $zeile["Bezeichnung"];
-        }
+		}
-        foreach (array_keys($web_rechte) as $a) {
+		foreach (array_keys($web_rechte) as $a) {
-            foreach (array_keys($web_rechte[$a]) as $b) {
+			foreach (array_keys($web_rechte[$a]) as $b) {
-                foreach (array_keys($web_rechte[$a][$b]) as $c) {
+				foreach (array_keys($web_rechte[$a][$b]) as $c) {
-                    if (is_array($web_rechte[$a][$b][$c])) {
+					if (is_array($web_rechte[$a][$b][$c])) {
-                        //if (in_array($_SESSION[language], $web_rechte[$a][$b][$c]))
+						//if (in_array($_SESSION[language], $web_rechte[$a][$b][$c]))
-                        {
+						{
-                            $web_rechte[$a][$b][$c] = $web_rechte[$a][$b][$c][array_search($_SESSION["language"],
+							$web_rechte[$a][$b][$c] = $web_rechte[$a][$b][$c][array_search($_SESSION["language"],
-                                array_keys($web_rechte["online_shop"]["language"]))];
+								array_keys($web_rechte["online_shop"]["language"]))];
-                        }
+						}
-                        if ($web_rechte[$a][$b][$c] == "./.") {
+						if ($web_rechte[$a][$b][$c] == "./.") {
-                            unset($web_rechte[$a][$b][$c]);
+							unset($web_rechte[$a][$b][$c]);
-                        }
+						}
-                    }
+					}
-                }
+				}
-            }
+			}
-        }
+		}
-        unset($query);
+		unset($query);
-        unset($result);
+		unset($result);
-        unset($zeile);
+		unset($zeile);
-        $CI->smarty->assign("web_rechte", $web_rechte);
+		$CI->smarty->assign("web_rechte", $web_rechte);
-        if ($CI->session->user_data["user"] == "admin") {
+		if ($CI->session->user_data["user"] == "admin") {
-            $user_rechte = $web_rechte;
+			$user_rechte = $web_rechte;
-        } else {
+		} else {
-            $sql = "
+			$sql = "
 				SELECT
 					modules.interner_name AS module,
 					user_properties.properties=properties.ID
 				AND
 					properties.tools = tools.ID
 				AND
 					tools.modules = modules.ID
+				AND
+					tools.filename LIKE '/backend/%/'
 			";
-            $result = $GLOBALS["db_red"]->query($sql);
+			$result = $GLOBALS["db_red"]->query($sql);
-            while ($zeile = $result->unbuffered_row('array')) {
+			while ($zeile = $result->unbuffered_row('array')) {
-                $user_rechte[$zeile["module"]][$zeile["tool"]][$zeile["property"]] = 1;
+				$user_rechte[$zeile["module"]][$zeile["tool"]][$zeile["property"]] = 1;
-            }
+			}
-        }
+		}
-        $CI->smarty->assign("user_rechte", $user_rechte);
+		$CI->smarty->assign("user_rechte", $user_rechte);
-        $query_modules = "SELECT
+		$query_modules = "SELECT
+				*
 			FROM
 				modules
 			ORDER BY
 				rang
 		";
-        $result_modules = $GLOBALS['db_red']->query($query_modules);
+		$result_modules = $GLOBALS['db_red']->query($query_modules);
-        while ($zeile_modules = $result_modules->unbuffered_row('array')) {
+		while ($zeile_modules = $result_modules->unbuffered_row('array')) {
-            $u_tools = array();
+			$u_tools = array();
-            if (isset($user_rechte[$zeile_modules["interner_name"]])) {
+			if (isset($user_rechte[$zeile_modules["interner_name"]])) {
-                $query_tools = "SELECT
+				$query_tools = "SELECT
+						*
 					FROM
 						tools
 					WHERE
 						tools.hidden='false'
 					ORDER BY
 						tools.rang
 				";
-                $result_tools = $GLOBALS['db_red']->query($query_tools);
+				$result_tools = $GLOBALS['db_red']->query($query_tools);
-                while ($zeile_tools = $result_tools->unbuffered_row('array')) {
+				while ($zeile_tools = $result_tools->unbuffered_row('array')) {
-                    if (isset($user_rechte[$zeile_modules["interner_name"]][$zeile_tools["button_name"]])) {
+					if (isset($user_rechte[$zeile_modules["interner_name"]][$zeile_tools["button_name"]])) {
-                        if ($zeile_tools["filename"]) {
+						if ($zeile_tools["filename"]) {
-                            $images_Pfad = 'images/navigation/';
+							$images_Pfad = 'images/navigation/';
-                            $imgsrc = $images_Pfad . 'bt_' . $zeile_tools["button_name"] . '.gif';
+							$imgsrc = $images_Pfad . 'bt_' . $zeile_tools["button_name"] . '.gif';
-                            $imgsrc_f2 = $images_Pfad . 'bt_' . $zeile_tools["button_name"] . '_f2.gif';
+							$imgsrc_f2 = $images_Pfad . 'bt_' . $zeile_tools["button_name"] . '_f2.gif';
-                            $u_tools[] = array(
+							$u_tools[] = array(
-                                "ID" => $zeile_tools["ID"],
+								"ID" => $zeile_tools["ID"],
-                                "image" => $imgsrc,
+								"image" => $imgsrc,
-                                "image_f2" => $imgsrc_f2,
+								"image_f2" => $imgsrc_f2,
-                                "filename" => $zeile_tools["filename"],
+								"filename" => $zeile_tools["filename"],
-                                "name" => $zeile_tools["name"],
+								"name" => $zeile_tools["name"],
-                                "icon" => $zeile_tools["icon"],
+								"icon" => $zeile_tools["icon"],
-                                );
+								);
-                        }
+						}
-                    }
+					}
-                }
+				}
-                if ($u_tools) {
+				if ($u_tools) {
-                    $u_modules[] = array(
+					$u_modules[] = array(
-                        "name" => $zeile_modules["name"],
+						"name" => $zeile_modules["name"],
-                        "interner_name" => $zeile_modules["interner_name"],
+						"interner_name" => $zeile_modules["interner_name"],
-                        "ID" => $zeile_modules["ID"],
+						"ID" => $zeile_modules["ID"],
-                        "count" => count($user_rechte[$zeile_modules["interner_name"]]),
+						"count" => count($user_rechte[$zeile_modules["interner_name"]]),
-                        "tools" => $u_tools,
+						"tools" => $u_tools,
-                        "icon" => $zeile_modules["icon"],
+						"icon" => $zeile_modules["icon"],
-                        );
+						);
-                }
+				}
-            }
+			}
-        }
+		}
-        $CI->smarty->assign('u_modules', $u_modules);
+		$CI->smarty->assign('u_modules', $u_modules);
-        $GLOBALS["web_rechte"] = $web_rechte;
+		$GLOBALS["web_rechte"] = $web_rechte;
-        $GLOBALS["user_rechte"] = $user_rechte;
+		$GLOBALS["user_rechte"] = $user_rechte;
+	}
+}

Subversion-Projekte lars-tiefland.ci

(root)/backend/libraries/Weban_backend.php – Revision 2253 → 2255