Subversion-Projekte lars-tiefland.ci

Revision

Revision 1928 | Revision 2180 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1887 lars 1 
<?php
2 
 
3 
/**
4 
 * @author Lars Tiefland
5 
 * @copyright 2016
6 
 */
7 
 
8 
/**
9 
 * Medien_model
10 
 *
11 
 * Liest die Bilder von Artikeln oder Kategorien aus
12 
 *
13 
 * @package WebanOS CI
14 
 * @author Lars Tiefland
15 
 * @copyright 2016
16 
 * @version $Id: Medien_model.php 1931 2016-12-26 14:08:02Z lars $
17 
 * @access public
18 
 */
19 
class Medien_model extends CI_Model
20 
{
21 
	private $sql;
22 
	private $formate;
23 
	private $basis;
24 
	/**
25 
	 * Medien_model::__construct()
26 
	 *
27 
	 * stellt alle nötigen SQL-Abfragen und Formate für die Medien bereit
28 
	 *
29 
	 * @return
30 
	 */
31 
	public function __construct()
32 
	{
33 
		parent::__construct();
34 
		$this->basis = $this->config->item('base_url');
35 
		$this->formate = array(
36 
			"" => "",
37 
			"_klein" => "kl/",
38 
			"_mini" => "mini/",
39 
			"_gr" => "gr/",
40 
			"_br" => "br/",
41 
			"_ba" => "ba/",
42 
			"_nav" => "nav/",
43 
			"_sl" => "sl/",
44 
			"_start" => "start/",
45 
			"_icon" => "icon/",
46 
			);
47 
 
1901 lars 48 
		$this->sql["medien"]["artikel"] = "SELECT
1931 lars 49 
				m.id,
1887 lars 50 
				m.name,
51 
				m.folder,
52 
				m.beschreibung,
53 
				m.typ,
54 
				am.rang,
1892 lars 55 
				am.aehnlich,
56 
				mt.name AS typ_name
1887 lars 57 
			FROM
58 
				medien m
59 
			JOIN
60 
				artikel_medien am
1892 lars 61 
			JOIN
62 
				content_management.medien_typ mt
63 
			ON
64 
				mt.id=m.typ
1887 lars 65 
			WHERE
66 
				am.medien_id=m.id
67 
			AND
68 
				artikel_id=?
69 
			AND
70 
				typ=?
71 
			ORDER BY
72 
				rang
73 
		";
74 
		$this->sql["medien"]["category"] = "SELECT
1931 lars 75 
				m.id,
1887 lars 76 
				m.name,
77 
				m.folder,
78 
				m.beschreibung,
1894 lars 79 
				m.typ,
1887 lars 80 
				dm.rang,
1892 lars 81 
				dm.aehnlich,
1893 lars 82 
				mt.name AS typ_name
1887 lars 83 
			FROM
84 
				medien m
85 
			JOIN
86 
				directory_medien dm
1892 lars 87 
			JOIN
88 
				content_management.medien_typ mt
89 
			ON
90 
				mt.id=m.typ
1887 lars 91 
			WHERE
92 
				dm.medien_id=m.id
93 
			AND
94 
				directory_id=?
95 
			AND
96 
				typ=?
97 
			ORDER BY
98 
				rang
99 
		";
1901 lars 100 
		$this->sql["medien"]["artikel_all"] = "SELECT
1931 lars 101 
				m.id,
1900 lars 102 
				m.name,
103 
				m.folder,
104 
				m.beschreibung,
105 
				m.typ,
106 
				am.rang,
107 
				am.aehnlich,
108 
				mt.name AS typ_name
109 
			FROM
110 
				medien m
111 
			JOIN
112 
				artikel_medien am
113 
			JOIN
114 
				content_management.medien_typ mt
115 
			ON
116 
				mt.id=m.typ
117 
			WHERE
118 
				am.medien_id=m.id
119 
			AND
120 
				artikel_id=?
121 
			ORDER BY
122 
				rang
123 
		";
124 
		$this->sql["medien"]["category_all"] = "SELECT
1931 lars 125 
				m.id,
1900 lars 126 
				m.name,
127 
				m.folder,
128 
				m.beschreibung,
129 
				m.typ,
130 
				dm.rang,
131 
				dm.aehnlich,
132 
				mt.name AS typ_name
133 
			FROM
134 
				medien m
135 
			JOIN
136 
				directory_medien dm
137 
			JOIN
138 
				content_management.medien_typ mt
139 
			ON
140 
				mt.id=m.typ
141 
			WHERE
142 
				dm.medien_id=m.id
143 
			AND
144 
				directory_id=?
145 
			ORDER BY
146 
				rang
147 
		";
1925 lars 148 
		$aehnlich = array(
149 
			"nein",
150 
			"ja",
151 
			);
1928 lars 152 
		$this->smarty->assign("aehnlich", $aehnlich);
1887 lars 153 
	}
154 
 
155 
	/**
156 
	 * Medien_model::get_artikel_medien()
157 
	 *
158 
	 * Liest alle Medien für einen Artikel aus und erzeugt alle konfigurierten URLs (relativ und absolut)
159 
	 *
160 
	 * @param mixed $artikel_id
161 
	 * @param integer $typ
162 
	 * @return
163 
	 */
1900 lars 164 
	public function get_artikel_medien($artikel_id, $typ = null)
1887 lars 165 
	{
166 
		$medien = array();
1900 lars 167 
		if (is_null($typ))
168 
		{
169 
			$am_res = $this->db->query($this->sql["medien"]["artikel_all"], array($artikel_id, ));
170 
		}
171 
		else
172 
		{
173 
			$am_res = $this->db->query($this->sql["medien"]["artikel"], array(
174 
				$artikel_id,
175 
				$typ,
176 
				));
177 
		}
1897 lars 178 
		$basis = $GLOBALS["webs"]["verzeichnis"]."/images/upload/";
1887 lars 179 
		if ($am_res->num_rows())
180 
		{
181 
			while ($row = $am_res->unbuffered_row('array'))
182 
			{
183 
				$url = '/images/upload/';
184 
				$folder = '';
185 
				if ($row['folder'])
186 
				{
187 
					$folder = $row['folder'];
188 
					$ende = substr($folder, -1);
189 
					if ($ende != '/')
190 
					{
191 
						$folder .= '/';
192 
					}
193 
				}
194 
				$url .= $folder;
195 
				$b_name = $row['name'];
196 
				foreach ($this->formate as $format => $dir)
197 
				{
198 
					$row['bild_url'.$format] = $url.$dir.$b_name;
199 
					$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];
200 
				}
1897 lars 201 
				$row["path"] = $basis.$row["folder"]."/".$row["name"];
1896 lars 202 
				$row["size"] = filesize($row["path"]);
203 
				$row["img_size"] = GetImageSize($row["path"]);
1887 lars 204 
				$medien[] = $row;
205 
			}
206 
		}
207 
		else
208 
		{
209 
			$url = "/images/webelemente/";
210 
			$b_name = basename($GLOBALS["INI"]["itemKorrektur"]["noImage"]);
211 
			$row["name"] = $b_name;
212 
			$row["beschreibung"] = "";
213 
			$row["folder"] = "";
1893 lars 214 
			$row["typ"] = 1;
215 
			$rot["typ_name"] = "Bild";
1897 lars 216 
			$row["path"] = $basis.$row["folder"]."/".$row["name"];
1896 lars 217 
			$row["size"] = filesize($row["path"]);
218 
			$row["img_size"] = GetImageSize($row["path"]);
1887 lars 219 
			foreach ($this->formate as $format => $dir)
220 
			{
221 
				$row["bild_url".$format] = $url.$b_name;
222 
				$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];
223 
			}
224 
			$medien[] = $row;
225 
		}
226 
		return $medien;
227 
	}
228 
 
229 
	/**
230 
	 * Medien_model::get_category_medien()
231 
	 *
232 
	 * Liest alle Medien für eine Kategorie aus und erzeugt alle konfigurierten URLs (relativ und absolut)
233 
	 *
234 
	 * @param mixed $category_id
235 
	 * @param integer $typ
236 
	 * @return
237 
	 */
1900 lars 238 
	public function get_category_medien($category_id, $typ = null)
1887 lars 239 
	{
1897 lars 240 
		$basis = $GLOBALS["webs"]["verzeichnis"]."/images/upload/";
1887 lars 241 
		$medien = array();
1900 lars 242 
		if (is_null($typ))
243 
		{
244 
			$am_res = $this->db->query($this->sql["medien"]["category_all"], array($category_id, ));
245 
		}
246 
		else
247 
		{
248 
			$am_res = $this->db->query($this->sql["medien"]["category"], array(
249 
				$category_id,
250 
				$typ,
251 
				));
252 
		}
1887 lars 253 
		if ($am_res->num_rows())
254 
		{
255 
			while ($row = $am_res->unbuffered_row('array'))
256 
			{
257 
				$url = '/images/upload/';
258 
				$folder = '';
259 
				if ($row['folder'])
260 
				{
261 
					$folder = $row['folder'];
262 
					$ende = substr($folder, -1);
263 
					if ($ende != '/')
264 
					{
265 
						$folder .= '/';
266 
					}
267 
				}
268 
				$url .= $folder;
269 
				$b_name = $row['name'];
270 
				foreach ($this->formate as $format => $dir)
271 
				{
272 
					$row['bild_url'.$format] = $url.$dir.$b_name;
273 
					$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];
274 
				}
1897 lars 275 
				$row["path"] = $basis.$row["folder"]."/".$row["name"];
1896 lars 276 
				$row["size"] = filesize($row["path"]);
277 
				$row["img_size"] = GetImageSize($row["path"]);
1887 lars 278 
				$medien[] = $row;
279 
			}
280 
		}
281 
		else
282 
		{
283 
			$url = "/images/webelemente/";
284 
			$b_name = basename($GLOBALS["INI"]["itemKorrektur"]["noImage"]);
285 
			$row["name"] = $b_name;
286 
			$row["beschreibung"] = "";
287 
			$row["folder"] = "";
1893 lars 288 
			$row["typ"] = 1;
289 
			$rot["typ_name"] = "Bild";
1897 lars 290 
			$row["path"] = $basis.$row["folder"]."/".$row["name"];
1896 lars 291 
			$row["size"] = filesize($row["path"]);
292 
			$row["img_size"] = GetImageSize($row["path"]);
1887 lars 293 
			foreach ($this->formate as $format => $dir)
294 
			{
295 
				$row["bild_url".$format] = $url.$b_name;
296 
				$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];
297 
			}
298 
			$medien[] = $row;
299 
		}
300 
		return $medien;
301 
	}
302 
}
303 
 
304 
?>