Subversion-Projekte lars-tiefland.ci

<?php

/**
 * @author Lars Tiefland
 * @copyright 2016
 */

class Medien_model extends CI_Model
{
        private $sql;
        private $formate;
        public function __construct()
        {
                parent::__construct();
                $this->formate = array(
                        "" => "",
                        "_klein" => "kl/",
                        "_mini" => "mini/",
                        "_gr" => "gr/",
                        "_br" => "br/",
                        "_ba" => "ba/",
                        "_nav" => "nav/",
                        "_sl" => "sl/",
                        "_start" => "start/",
                        "_icon" => "icon/",
                        );

                $this->sql["medien"]["artikel"] = "SELECT
                                m.name,
                                m.folder,
                                m.beschreibung,
                                am.rang,
                                am.aehnlich
                        FROM
                                medien m
                        JOIN
                                artikel_medien am
                        WHERE
                                am.medien_id=m.id
                        AND
                                artikel_id=?
                        AND
                                typ=?
                        ORDER BY
                                rang
                ";
                $this->sql["medien"]["category"] = "SELECT
                                m.name,
                                m.folder,
                                m.beschreibung,
                                dm.rang,
                                dm.aehnlich
                        FROM
                                medien m
                        JOIN
                                directory_medien dm
                        WHERE
                                dm.medien_id=m.id
                        AND
                                directory_id=?
                        AND
                                typ=?
                        ORDER BY
                                rang
                ";
        }

        public function get_artikel_medien($artikel_id, $typ = 1)
        {
                $am_res = $this->db->query($this->sql["medien"]["artikel"], array(
                        $artikel_id,
                        $typ,
                        ));
                while ($row = $am_res->unbuffered_row())
                {
                        foreach ($this->formate as $format => $dir)
                        {
                                $row["bild_url".$format] = $url.$dir.$b_name;
                        }
                        $medien[] = $row;
                        }
                return $medien;
        }

}

?>