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 2210 2017-12-23 20:08:53Z lars $
+ * @version $Id: Medien_model.php 2212 2017-12-23 20:22:47Z lars $
  * @access public
  */
 class Medien_model extends CI_Model
+{
 	private $sql;
             WHERE
                 folder=?
             AND
                 typ!=3
         ";
-        $this->sql["medien"]["artikel_add"]="INSERT INTO
+		$this->sql["medien"]["artikel_add"] = "INSERT INTO
                 artikel_medien
             SET
                 medien_id=?,
                 artikel_id=?,
                 rang=?
 			$row["img_size"] = GetImageSize($row["path"]);
 			$medien[] = $row;
+		}
 		return $medien;
+	}
-    public function add()
+	public function add()
-    {
+	{
-        $l_type=$this->input->get("l_type");
+		$l_type = $this->input->get("l_type");
-        $l_id=$this->input->get("l_id");
+		$l_id = $this->input->get("l_id");
+		switch ($l_type) {
+			case "a":
+				$sql = "SELECT
+                        MAX(rang) AS rang
+                    FROM
+                        artikel_medien
+                    WHERE
+                        artikel_id=" . $l_id . "
+                ";
+				break;
+			case "d":
+				$sql = "SELECT
+                        MAX(rang) AS rang
+                    FROM
+                        directory_medien
+                    WHERE
+                        artikel_id=" . $l_id . "
+                ";
+				break;
+		}
+		$res = $this->db->query($sql);
+		$row = $res->unbuffered_row("array");
+		$rang = $row["rang"] + 10;
-        $b_id=$this->input->get("b_id");
+		$b_id = $this->input->get("b_id");
+		$this->db->query($this->sql["medien"]["artikel_add"], array(
+			$b_id,
+			$l_id,
+			$rang,
+			));
-    }
+	}
+}
 ?>

Subversion-Projekte lars-tiefland.ci

(root)/backend/models/Medien_model.php – Revision 2210 → 2212