Subversion-Projekte lars-tiefland.ci

Revision

Revision 1093 | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1093 Revision 2383
Zeile 3... Zeile 3...
3 
/**
 3 
/**
4 
 *
 4 
 *
5 
 * @package WebanOS CI
 5 
 * @package WebanOS CI
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
7 
 * @copyright 2016
 7 
 * @copyright 2016
8 
 * @version $Rev: 1093 $
 8 
 * @version $Rev: 2383 $
9 
 */
 9 
 */
Zeile 10... Zeile 10...
10 
 
 10 
 
11 
class User_rechte_model extends CI_Model
 11 
class User_rechte_model extends CI_Model
12 
{
 12 
{
Zeile 19... Zeile 19...
19 
	{
 19 
	{
20 
		$user_properties = array();
 20 
		$user_properties = array();
21 
		if ($ID)
 21 
		if ($ID)
22 
		{
 22 
		{
23 
			$sql = "
 23 
			$sql = "
24 
                SELECT
 24 
				SELECT
25 
                    *
 25 
					*
26 
                FROM
 26 
				FROM
27 
                    user_properties
 27 
					user_properties
28 
                WHERE
 28 
				WHERE
29 
                    Access = ".$ID."
 29 
					Access = ".$ID."
30 
            ";
 30 
			";
31 
			$result = $GLOBALS["db_red"]->query($sql);
 31 
			$result = $GLOBALS["db_red"]->query($sql);
32 
			while ($zeile = $result->unbuffered_row('array'))
 32 
			while ($zeile = $result->unbuffered_row('array'))
33 
			{
 33 
			{
34 
				$user_properties[$zeile["properties"]] = 1;
 34 
				$user_properties[$zeile["properties"]] = 1;
35 
			}
 35 
			}
Zeile 36... Zeile 36...
36 
 
 36 
 
37 
			$sql = "
 37 
			$sql = "
38 
                SELECT
 38 
				SELECT
39 
                    *
 39 
					*
40 
                FROM
 40 
				FROM
41 
                    Access
 41 
					Access
42 
                WHERE
 42 
				WHERE
43 
                    ID = ".$ID."
 43 
					ID = ".$ID."
44 
            ";
 44 
			";
45 
			$result = $GLOBALS["db_red"]->query($sql);
 45 
			$result = $GLOBALS["db_red"]->query($sql);
46 
			$user = $result->row_array();
 46 
			$user = $result->row_array();
47 
			list($user_name, $user_site) = explode("@", $user["user"]);
 47 
			list($user_name, $user_site) = explode("@", $user["user"]);
48 
			$user["site"] = $user_site;
 48 
			$user["site"] = $user_site;
Zeile 53... Zeile 53...
53 
 
 53 
 
54 
	public function get_rights()
 54 
	public function get_rights()
55 
	{
 55 
	{
56 
		$modules = array();
 56 
		$modules = array();
57 
		$sql = "
 57 
		$sql = "
58 
            SELECT
 58 
			SELECT
59 
                *
 59 
				*
60 
            FROM
 60 
			FROM
61 
                modules
 61 
				modules
62 
            ORDER by
 62 
			ORDER by
63 
                rang
 63 
				rang
64 
        ";
 64 
		";
65 
		$result = $GLOBALS["db_red"]->query($sql);
 65 
		$result = $GLOBALS["db_red"]->query($sql);
66 
		while ($module = $result->unbuffered_row('array'))
 66 
		while ($module = $result->unbuffered_row('array'))
67 
		{
 67 
		{
68 
			//$module["name"] = html_entity_decode($module["name"]);
 68 
			//$module["name"] = html_entity_decode($module["name"]);
69 
			if (isset($GLOBALS["web_rechte"][$module["interner_name"]]))
 69 
			if (isset($GLOBALS["web_rechte"][$module["interner_name"]]))
70 
			{
 70 
			{
71 
				$sql = "
 71 
				$sql = "
72 
                    SELECT
 72 
					SELECT
73 
                        tools.*
 73 
						tools.*
74 
                    FROM
 74 
					FROM
75 
                        tools
 75 
						tools
76 
                    WHERE
 76 
					WHERE
77 
                        tools.modules = ".$module["ID"]."
 77 
						tools.modules = ".$module["ID"]."
78 
                    ORDER BY
 78 
					ORDER BY
79 
                        tools.rang
 79 
						tools.rang
80 
				";
 80 
				";
81 
				$result_tools = $GLOBALS["db_red"]->query($sql);
 81 
				$result_tools = $GLOBALS["db_red"]->query($sql);
82 
				while ($tool = $result_tools->unbuffered_row('array'))
 82 
				while ($tool = $result_tools->unbuffered_row('array'))
83 
				{
 83 
				{
84 
					//$tool["name"] = ($tool["name"]);
 84 
					//$tool["name"] = ($tool["name"]);
85 
					if (isset($GLOBALS["web_rechte"][$module["interner_name"]][$tool["button_name"]]))
 85 
					if (isset($GLOBALS["web_rechte"][$module["interner_name"]][$tool["button_name"]]))
86 
					{
 86 
					{
87 
						$sql = "
 87 
						$sql = "
88 
                            SELECT
 88 
							SELECT
89 
                                properties.*
 89 
								properties.*
90 
                            FROM
 90 
							FROM
91 
                                properties
 91 
								properties
92 
                            WHERE
 92 
							WHERE
93 
                                properties.tools = ".$tool["ID"]."
 93 
								properties.tools = ".$tool["ID"]."
94 
                            AND
 94 
							AND
95 
                                hidden = 'false'
 95 
								hidden = 'false'
96 
                            ORDER BY
 96 
							ORDER BY
97 
                                properties.rang
 97 
								properties.rang
98 
                        ";
 98 
						";
99 
						$result_properties = $GLOBALS["db_red"]->query($sql);
 99 
						$result_properties = $GLOBALS["db_red"]->query($sql);
100 
						while ($property = $result_properties->unbuffered_row('array'))
 100 
						while ($property = $result_properties->unbuffered_row('array'))
101 
						{
 101 
						{
102 
							//$property["name"] = utf8_encode($property["name"]);
 102 
							//$property["name"] = utf8_encode($property["name"]);