Subversion-Projekte lars-tiefland.ci

Revision

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

Revision 1931 Revision 2180
Zeile 11... Zeile 11...
11 
 * Liest die Bilder von Artikeln oder Kategorien aus
 11 
 * Liest die Bilder von Artikeln oder Kategorien aus
12 
 *
12 
 *
13 
 * @package WebanOS CI
 13 
 * @package WebanOS CI
14 
 * @author Lars Tiefland
 14 
 * @author Lars Tiefland
15 
 * @copyright 2016
 15 
 * @copyright 2016
16 
 * @version $Id: Medien_model.php 1931 2016-12-26 14:08:02Z lars $
 16 
 * @version $Id: Medien_model.php 2180 2017-12-23 14:16:19Z lars $
17 
 * @access public
 17 
 * @access public
18 
 */
 18 
 */
19 
class Medien_model extends CI_Model
 19 
class Medien_model extends CI_Model
20 
{
 20 
{
21 
	private $sql;
 21 
	private $sql;
Zeile 148... Zeile 148...
148 
		$aehnlich = array(
 148 
		$aehnlich = array(
149 
			"nein",
 149 
			"nein",
150 
			"ja",
 150 
			"ja",
151 
			);
 151 
			);
152 
		$this->smarty->assign("aehnlich", $aehnlich);
 152 
		$this->smarty->assign("aehnlich", $aehnlich);
- 
 
 153 
		$this->sql["medien"]["list"] = "SELECT
- 
 
 154 
                *
- 
 
 155 
            FROM
- 
 
 156 
                medien
- 
 
 157 
            WHERE
- 
 
 158 
                folder=''
- 
 
 159 
        ";
153 
	}
 160 
	}
Zeile 154... Zeile 161...
154 
 
 161 
 
155 
	/**
 162 
	/**
156 
	 * Medien_model::get_artikel_medien()
 163 
	 * Medien_model::get_artikel_medien()
Zeile 162... Zeile 169...
162 
	 * @return
 169 
	 * @return
163 
	 */
 170 
	 */
164 
	public function get_artikel_medien($artikel_id, $typ = null)
 171 
	public function get_artikel_medien($artikel_id, $typ = null)
165 
	{
 172 
	{
166 
		$medien = array();
 173 
		$medien = array();
167 
		if (is_null($typ))
 174 
		if (is_null($typ)) {
168 
		{
 - 
 
169 
			$am_res = $this->db->query($this->sql["medien"]["artikel_all"], array($artikel_id, ));
 175 
			$am_res = $this->db->query($this->sql["medien"]["artikel_all"], array($artikel_id, ));
170 
		}
 - 
 
171 
		else
 176 
		} else {
172 
		{
 - 
 
173 
			$am_res = $this->db->query($this->sql["medien"]["artikel"], array(
 177 
			$am_res = $this->db->query($this->sql["medien"]["artikel"], array(
174 
				$artikel_id,
 178 
				$artikel_id,
175 
				$typ,
 179 
				$typ,
176 
				));
 180 
				));
177 
		}
 181 
		}
178 
		$basis = $GLOBALS["webs"]["verzeichnis"]."/images/upload/";
 182 
		$basis = $GLOBALS["webs"]["verzeichnis"] . "/images/upload/";
179 
		if ($am_res->num_rows())
 183 
		if ($am_res->num_rows()) {
180 
		{
 - 
 
181 
			while ($row = $am_res->unbuffered_row('array'))
 184 
			while ($row = $am_res->unbuffered_row('array')) {
182 
			{
 - 
 
183 
				$url = '/images/upload/';
 185 
				$url = '/images/upload/';
184 
				$folder = '';
 186 
				$folder = '';
185 
				if ($row['folder'])
 187 
				if ($row['folder']) {
186 
				{
 - 
 
187 
					$folder = $row['folder'];
 188 
					$folder = $row['folder'];
188 
					$ende = substr($folder, -1);
 189 
					$ende = substr($folder, -1);
189 
					if ($ende != '/')
 190 
					if ($ende != '/') {
190 
					{
 - 
 
191 
						$folder .= '/';
 191 
						$folder .= '/';
192 
					}
 192 
					}
193 
				}
 193 
				}
194 
				$url .= $folder;
 194 
				$url .= $folder;
195 
				$b_name = $row['name'];
 195 
				$b_name = $row['name'];
196 
				foreach ($this->formate as $format => $dir)
 196 
				foreach ($this->formate as $format => $dir) {
197 
				{
 - 
 
198 
					$row['bild_url'.$format] = $url.$dir.$b_name;
 197 
					$row['bild_url' . $format] = $url . $dir . $b_name;
199 
					$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];
 198 
					$row["abs_bild_url" . $format] = $this->basis . $row["bild_url" . $format];
200 
				}
 199 
				}
201 
				$row["path"] = $basis.$row["folder"]."/".$row["name"];
 200 
				$row["path"] = $basis . $row["folder"] . "/" . $row["name"];
202 
				$row["size"] = filesize($row["path"]);
 201 
				$row["size"] = filesize($row["path"]);
203 
				$row["img_size"] = GetImageSize($row["path"]);
 202 
				$row["img_size"] = GetImageSize($row["path"]);
204 
				$medien[] = $row;
 203 
				$medien[] = $row;
205 
			}
 204 
			}
206 
		}
 - 
 
207 
		else
 205 
		} else {
208 
		{
 - 
 
209 
			$url = "/images/webelemente/";
 206 
			$url = "/images/webelemente/";
210 
			$b_name = basename($GLOBALS["INI"]["itemKorrektur"]["noImage"]);
 207 
			$b_name = basename($GLOBALS["INI"]["itemKorrektur"]["noImage"]);
211 
			$row["name"] = $b_name;
 208 
			$row["name"] = $b_name;
212 
			$row["beschreibung"] = "";
 209 
			$row["beschreibung"] = "";
213 
			$row["folder"] = "";
 210 
			$row["folder"] = "";
214 
			$row["typ"] = 1;
 211 
			$row["typ"] = 1;
215 
			$rot["typ_name"] = "Bild";
 212 
			$rot["typ_name"] = "Bild";
216 
			$row["path"] = $basis.$row["folder"]."/".$row["name"];
 213 
			$row["path"] = $basis . $row["folder"] . "/" . $row["name"];
217 
			$row["size"] = filesize($row["path"]);
 214 
			$row["size"] = filesize($row["path"]);
218 
			$row["img_size"] = GetImageSize($row["path"]);
 215 
			$row["img_size"] = GetImageSize($row["path"]);
219 
			foreach ($this->formate as $format => $dir)
 216 
			foreach ($this->formate as $format => $dir) {
220 
			{
 - 
 
221 
				$row["bild_url".$format] = $url.$b_name;
 217 
				$row["bild_url" . $format] = $url . $b_name;
222 
				$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];
 218 
				$row["abs_bild_url" . $format] = $this->basis . $row["bild_url" . $format];
223 
			}
 219 
			}
224 
			$medien[] = $row;
 220 
			$medien[] = $row;
225 
		}
 221 
		}
226 
		return $medien;
 222 
		return $medien;
227 
	}
 223 
	}
Zeile 235... Zeile 231...
235 
	 * @param integer $typ
 231 
	 * @param integer $typ
236 
	 * @return
 232 
	 * @return
237 
	 */
 233 
	 */
238 
	public function get_category_medien($category_id, $typ = null)
 234 
	public function get_category_medien($category_id, $typ = null)
239 
	{
 235 
	{
240 
		$basis = $GLOBALS["webs"]["verzeichnis"]."/images/upload/";
 236 
		$basis = $GLOBALS["webs"]["verzeichnis"] . "/images/upload/";
241 
		$medien = array();
 237 
		$medien = array();
242 
		if (is_null($typ))
 238 
		if (is_null($typ)) {
243 
		{
 - 
 
244 
			$am_res = $this->db->query($this->sql["medien"]["category_all"], array($category_id, ));
 239 
			$am_res = $this->db->query($this->sql["medien"]["category_all"], array($category_id, ));
245 
		}
 - 
 
246 
		else
 240 
		} else {
247 
		{
 - 
 
248 
			$am_res = $this->db->query($this->sql["medien"]["category"], array(
 241 
			$am_res = $this->db->query($this->sql["medien"]["category"], array(
249 
				$category_id,
 242 
				$category_id,
250 
				$typ,
 243 
				$typ,
251 
				));
 244 
				));
252 
		}
 245 
		}
253 
		if ($am_res->num_rows())
 246 
		if ($am_res->num_rows()) {
254 
		{
 - 
 
255 
			while ($row = $am_res->unbuffered_row('array'))
 247 
			while ($row = $am_res->unbuffered_row('array')) {
256 
			{
 - 
 
257 
				$url = '/images/upload/';
 248 
				$url = '/images/upload/';
258 
				$folder = '';
 249 
				$folder = '';
259 
				if ($row['folder'])
 250 
				if ($row['folder']) {
260 
				{
 - 
 
261 
					$folder = $row['folder'];
 251 
					$folder = $row['folder'];
262 
					$ende = substr($folder, -1);
 252 
					$ende = substr($folder, -1);
263 
					if ($ende != '/')
 253 
					if ($ende != '/') {
264 
					{
 - 
 
265 
						$folder .= '/';
 254 
						$folder .= '/';
266 
					}
 255 
					}
267 
				}
 256 
				}
268 
				$url .= $folder;
 257 
				$url .= $folder;
269 
				$b_name = $row['name'];
 258 
				$b_name = $row['name'];
270 
				foreach ($this->formate as $format => $dir)
 259 
				foreach ($this->formate as $format => $dir) {
271 
				{
 - 
 
272 
					$row['bild_url'.$format] = $url.$dir.$b_name;
 260 
					$row['bild_url' . $format] = $url . $dir . $b_name;
273 
					$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];
 261 
					$row["abs_bild_url" . $format] = $this->basis . $row["bild_url" . $format];
274 
				}
 262 
				}
275 
				$row["path"] = $basis.$row["folder"]."/".$row["name"];
 263 
				$row["path"] = $basis . $row["folder"] . "/" . $row["name"];
276 
				$row["size"] = filesize($row["path"]);
 264 
				$row["size"] = filesize($row["path"]);
277 
				$row["img_size"] = GetImageSize($row["path"]);
 265 
				$row["img_size"] = GetImageSize($row["path"]);
278 
				$medien[] = $row;
 266 
				$medien[] = $row;
279 
			}
 267 
			}
280 
		}
 - 
 
281 
		else
 268 
		} else {
282 
		{
 - 
 
283 
			$url = "/images/webelemente/";
 269 
			$url = "/images/webelemente/";
284 
			$b_name = basename($GLOBALS["INI"]["itemKorrektur"]["noImage"]);
 270 
			$b_name = basename($GLOBALS["INI"]["itemKorrektur"]["noImage"]);
285 
			$row["name"] = $b_name;
 271 
			$row["name"] = $b_name;
286 
			$row["beschreibung"] = "";
 272 
			$row["beschreibung"] = "";
287 
			$row["folder"] = "";
 273 
			$row["folder"] = "";
288 
			$row["typ"] = 1;
 274 
			$row["typ"] = 1;
289 
			$rot["typ_name"] = "Bild";
 275 
			$rot["typ_name"] = "Bild";
290 
			$row["path"] = $basis.$row["folder"]."/".$row["name"];
 276 
			$row["path"] = $basis . $row["folder"] . "/" . $row["name"];
291 
			$row["size"] = filesize($row["path"]);
 277 
			$row["size"] = filesize($row["path"]);
292 
			$row["img_size"] = GetImageSize($row["path"]);
 278 
			$row["img_size"] = GetImageSize($row["path"]);
293 
			foreach ($this->formate as $format => $dir)
 279 
			foreach ($this->formate as $format => $dir) {
294 
			{
 - 
 
295 
				$row["bild_url".$format] = $url.$b_name;
 280 
				$row["bild_url" . $format] = $url . $b_name;
296 
				$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];
 281 
				$row["abs_bild_url" . $format] = $this->basis . $row["bild_url" . $format];
297 
			}
 282 
			}
298 
			$medien[] = $row;
 283 
			$medien[] = $row;
299 
		}
 284 
		}
300 
		return $medien;
 285 
		return $medien;
301 
	}
 286 
	}
- 
 
 287 
 
- 
 
 288 
	public function get()
- 
 
 289 
	{
- 
 
 290 
		$res = $this->db->query($this->sql["medien"]["list"]);
- 
 
 291 
		while ($row = $res->unbufferd_row("array")) {
- 
 
 292 
			$medien[] = $row;
- 
 
 293 
		}
- 
 
 294 
		return $medien;
- 
 
 295 
	}
302 
}
 296 
}
Zeile 303... Zeile 297...
303 
 
 297 
 
304 
?>
 298 
?>