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
?>