WebSVN – lars-tiefland.ci – Diff – /backend/helpers/weban_helper.php

+	{
 		$buffer[] = $zeile;
+	}
 	if ($filter)
+	{
 		//Shops filtern
 		foreach ($buffer as $id => $shop)
+		{
 			/*
 			if (get_umsatz($start, $ende, $shop["ID"], 0) > 0.0 || get_umsatz($start_v, $ende_v,
-				$shop["ID"], 0) > 0.0)
+			$shop["ID"], 0) > 0.0)
 			{*/
-				$shops[] = $shop;
+			$shops[] = $shop;
 			//}
+		}
+	}
 	else
+	{
 		$scalar++;
+	}
 	return $dateArray;
+}
+function parseEnumSet($table, $col)
+{
+	$sql = "SELECT
+			DATA_TYPE,
+			COLUMN_TYPE,
+			COLUMN_DEFAULT
+		FROM
+			information_schema.COLUMNS
+		WHERE
+			TABLE_SCHEMA='".$GLOBALS["webs"]["datenbank"]."'
+		AND
+			TABLE_NAME='".$table."'
+		AND
+			COLUMN_NAME='".$col."'
+        ";
+	$res = $GLOBALS["ci"]->db->query($sql);
+	$row = $res->row_array();
+	$werte = str_replace(array(
+		$row["DATA_TYPE"]."(",
+		")",
+		"'",
+		), "", $row["COLUMN_TYPE"]);
+	$werte = explode(",", $werte);
+	$ret = array(
+		"werte" => $werte,
+		"typ" => $row["DATA_TYPE"],
+		"default" => $row["COLUMN_DEFAULT"],
+		);
+	return $ret;
+}
 ?>

Subversion-Projekte lars-tiefland.ci