WebSVN – lars-tiefland.ci – Diff – /backend/models/Medien_model.php



 * Liest die Bilder von Artikeln oder Kategorien aus
 * 
 * @package WebanOS CI
 * @author Lars Tiefland
 * @copyright 2016
 * @version $Id: Medien_model.php 1897 2016-12-24 23:35:19Z lars $
 * @access public
 */
class Medien_model extends CI_Model
{
	private $sql;

		$medien = array();
		$am_res = $this->db->query($this->sql["medien"]["artikel"], array(
			$artikel_id,
			$typ,
			));
		$basis = $GLOBALS["webs"]["verzeichnis"]."/images/upload/";
		if ($am_res->num_rows())
		{
			while ($row = $am_res->unbuffered_row('array'))
			{
				$url = '/images/upload/';

				foreach ($this->formate as $format => $dir)
				{
					$row['bild_url'.$format] = $url.$dir.$b_name;
					$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];
				}
				$row["path"] = $basis.$row["folder"]."/".$row["name"];
				$row["size"] = filesize($row["path"]);
				$row["img_size"] = GetImageSize($row["path"]);
				$medien[] = $row;
			}
		}

			$row["name"] = $b_name;
			$row["beschreibung"] = "";
			$row["folder"] = "";
			$row["typ"] = 1;
			$rot["typ_name"] = "Bild";
			$row["path"] = $basis.$row["folder"]."/".$row["name"];
			$row["size"] = filesize($row["path"]);
			$row["img_size"] = GetImageSize($row["path"]);
			foreach ($this->formate as $format => $dir)
			{
				$row["bild_url".$format] = $url.$b_name;

	 * @param integer $typ
	 * @return
	 */
	public function get_category_medien($category_id, $typ = 1)
	{
		$basis = $GLOBALS["webs"]["verzeichnis"]."/images/upload/";
		$medien = array();
		$am_res = $this->db->query($this->sql["medien"]["category"], array(
			$category_id,
			$typ,
			));

				foreach ($this->formate as $format => $dir)
				{
					$row['bild_url'.$format] = $url.$dir.$b_name;
					$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];
				}
				$row["path"] = $basis.$row["folder"]."/".$row["name"];
				$row["size"] = filesize($row["path"]);
				$row["img_size"] = GetImageSize($row["path"]);
				$medien[] = $row;
			}
		}

			$row["name"] = $b_name;
			$row["beschreibung"] = "";
			$row["folder"] = "";
			$row["typ"] = 1;
			$rot["typ_name"] = "Bild";
			$row["path"] = $basis.$row["folder"]."/".$row["name"];
			$row["size"] = filesize($row["path"]);
			$row["img_size"] = GetImageSize($row["path"]);
			foreach ($this->formate as $format => $dir)
			{
				$row["bild_url".$format] = $url.$b_name;

Revision 1896	Revision 1897
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 1896 2016-12-24 23:32:00Z lars $`	16	`* @version $Id: Medien_model.php 1897 2016-12-24 23:35: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 111...	Zeile 111...
111	`$medien = array();`	111	`$medien = array();`
112	`$am_res = $this->db->query($this->sql["medien"]["artikel"], array(`	112	`$am_res = $this->db->query($this->sql["medien"]["artikel"], array(`
113	`$artikel_id,`	113	`$artikel_id,`
114	`$typ,`	114	`$typ,`
115	`));`	115	`));`
-		116	`$basis = $GLOBALS["webs"]["verzeichnis"]."/images/upload/";`
116	`if ($am_res->num_rows())`	117	`if ($am_res->num_rows())`
117	`{`	118	`{`
118	`while ($row = $am_res->unbuffered_row('array'))`	119	`while ($row = $am_res->unbuffered_row('array'))`
119	`{`	120	`{`
120	`$url = '/images/upload/';`	121	`$url = '/images/upload/';`
Zeile 133...	Zeile 134...
133	`foreach ($this->formate as $format => $dir)`	134	`foreach ($this->formate as $format => $dir)`
134	`{`	135	`{`
135	`$row['bild_url'.$format] = $url.$dir.$b_name;`	136	`$row['bild_url'.$format] = $url.$dir.$b_name;`
136	`$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];`	137	`$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];`
137	`}`	138	`}`
-		139	`$row["path"] = $basis.$row["folder"]."/".$row["name"];`
138	`$row["size"] = filesize($row["path"]);`	140	`$row["size"] = filesize($row["path"]);`
139	`$row["img_size"] = GetImageSize($row["path"]);`	141	`$row["img_size"] = GetImageSize($row["path"]);`
140	`$medien[] = $row;`	142	`$medien[] = $row;`
141	`}`	143	`}`
142	`}`	144	`}`
Zeile 147...	Zeile 149...
147	`$row["name"] = $b_name;`	149	`$row["name"] = $b_name;`
148	`$row["beschreibung"] = "";`	150	`$row["beschreibung"] = "";`
149	`$row["folder"] = "";`	151	`$row["folder"] = "";`
150	`$row["typ"] = 1;`	152	`$row["typ"] = 1;`
151	`$rot["typ_name"] = "Bild";`	153	`$rot["typ_name"] = "Bild";`
-		154	`$row["path"] = $basis.$row["folder"]."/".$row["name"];`
152	`$row["size"] = filesize($row["path"]);`	155	`$row["size"] = filesize($row["path"]);`
153	`$row["img_size"] = GetImageSize($row["path"]);`	156	`$row["img_size"] = GetImageSize($row["path"]);`
154	`foreach ($this->formate as $format => $dir)`	157	`foreach ($this->formate as $format => $dir)`
155	`{`	158	`{`
156	`$row["bild_url".$format] = $url.$b_name;`	159	`$row["bild_url".$format] = $url.$b_name;`
Zeile 170...	Zeile 173...
170	`* @param integer $typ`	173	`* @param integer $typ`
171	`* @return`	174	`* @return`
172	`*/`	175	`*/`
173	`public function get_category_medien($category_id, $typ = 1)`	176	`public function get_category_medien($category_id, $typ = 1)`
174	`{`	177	`{`
-		178	`$basis = $GLOBALS["webs"]["verzeichnis"]."/images/upload/";`
175	`$medien = array();`	179	`$medien = array();`
176	`$am_res = $this->db->query($this->sql["medien"]["category"], array(`	180	`$am_res = $this->db->query($this->sql["medien"]["category"], array(`
177	`$category_id,`	181	`$category_id,`
178	`$typ,`	182	`$typ,`
179	`));`	183	`));`
Zeile 197...	Zeile 201...
197	`foreach ($this->formate as $format => $dir)`	201	`foreach ($this->formate as $format => $dir)`
198	`{`	202	`{`
199	`$row['bild_url'.$format] = $url.$dir.$b_name;`	203	`$row['bild_url'.$format] = $url.$dir.$b_name;`
200	`$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];`	204	`$row["abs_bild_url".$format] = $this->basis.$row["bild_url".$format];`
201	`}`	205	`}`
-		206	`$row["path"] = $basis.$row["folder"]."/".$row["name"];`
202	`$row["size"] = filesize($row["path"]);`	207	`$row["size"] = filesize($row["path"]);`
203	`$row["img_size"] = GetImageSize($row["path"]);`	208	`$row["img_size"] = GetImageSize($row["path"]);`
204	`$medien[] = $row;`	209	`$medien[] = $row;`
205	`}`	210	`}`
206	`}`	211	`}`
Zeile 211...	Zeile 216...
211	`$row["name"] = $b_name;`	216	`$row["name"] = $b_name;`
212	`$row["beschreibung"] = "";`	217	`$row["beschreibung"] = "";`
213	`$row["folder"] = "";`	218	`$row["folder"] = "";`
214	`$row["typ"] = 1;`	219	`$row["typ"] = 1;`
215	`$rot["typ_name"] = "Bild";`	220	`$rot["typ_name"] = "Bild";`
-		221	`$row["path"] = $basis.$row["folder"]."/".$row["name"];`
216	`$row["size"] = filesize($row["path"]);`	222	`$row["size"] = filesize($row["path"]);`
217	`$row["img_size"] = GetImageSize($row["path"]);`	223	`$row["img_size"] = GetImageSize($row["path"]);`
218	`foreach ($this->formate as $format => $dir)`	224	`foreach ($this->formate as $format => $dir)`
219	`{`	225	`{`
220	`$row["bild_url".$format] = $url.$b_name;`	226	`$row["bild_url".$format] = $url.$b_name;`

Subversion-Projekte lars-tiefland.ci

(root)/backend/models/Medien_model.php – Revision 1896 → 1897