Subversion-Projekte lars-tiefland.ci

function select_tpl($formTagName, $options, $optionValueKey, $optionLabelKey, $preSelectValue = false,

	$required = false, $onChange = null)

{

	if ($required == false)

	{

		array_unshift($options, array($optionValueKey => false, $optionLabelKey =>

				"----------- alle -----------"));

	}

	$ret = '<select name="'.$formTagName.

		'" onChange="$onChange" class="filterStatistik">';

	foreach ($options as $option)

	{

		$ret .= '<option value="'.$option[$optionValueKey].'"';

		if ($option[$optionValueKey] == $preSelectValue)

		{

			$ret .= ' selected="selected"';

		}

		$ret .= '>'.$option[$optionLabelKey].'</option>';

	}

	$ret .= '</select>';

	return $ret;

}

function select($formTagName, $options, $optionValueKey, $optionLabelKey, $preSelectValue = false,

	$required = false, $onChange = null)

{

	echo select_tpl($formTagName, $options, $optionValueKey, $optionLabelKey, $preSelectValue,

		$required, $onChange);

}

function getShops($shop_id = null, $filter = false, $start = 0, $ende = 0, $start_v =

	0, $ende_v = 0)

{

	$buffer = array();

	$where = "";

	if (isset($_SESSION["datenquellen"]["shops"]) && count($_SESSION["datenquellen"]["shops"]) >

		0)

	{

		$where = " WHERE id IN ( ".implode(",", $_SESSION["datenquellen"]["shops"]).

			" )";

	}

	$query = "

            SELECT  *

            FROM    shops

        ";

	$query .= (!empty($shop_id)) ? " WHERE ID = ".$shop_id : $where;

	$result = mysql_query($query) or die(mysql_errno().": ".mysql_error()."<hr>$query<hr>");

	while ($zeile = mysql_fetch_assoc($result))

	{

		$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)

			{

				$shops[] = $shop;

			}

		}

	}

	else

	{

		$shops = $buffer;

	}

	unset($buffer);

	return $shops;

}

function getLogistikerFilter()

{

	$logistiker[0] = "alle";

	$sql = "SELECT

			id,

			name

		FROM

			logistiker

  	";

	$result = $GLOBALS["order_db"]->query($sql);

	while ($row = $result->unbuffered_row('array'))

	{

		$logistiker[$row["id"]] = $row["name"];

	}

	return $logistiker;

}

function getBestelllaender()

{

	global $web_rechte;

	$laender[0] = "alle";

	$laender[1] = "Ausland";

	if (isset($web_rechte["Warenwirtschaft"]["bestellung"]["adressbuch"]))

	{

		$countryTable = "countries co";

		if ($web_rechte["online_shop"]["language"]["standardsprache"] == "UK")

		{

			$coFeld = "co.`name-en` AS liefer_Land";

		}

		else

		{

			$coFeld = "co.`name-ger` AS liefer_Land";

		}

		$query = "SELECT 

				".$coFeld."

    		FROM

				".$countryTable."

    	";

		$result = $GLOBALS["db_red"]->query($query);

		while ($row = $query->unbuffered_row('array'))

		{

			$laender[] = $row["liefer_Land"];

		}

	}

	else

	{

		$Laender = array(

			"Deutschland",

			"Niederlande",

			"Österreich",

			"Belgien",

			"Luxemburg",

			"Dänemark",

			"Schweiz",

			"Frankreich",

			"Großbritannien",

			"Italien",

			"Spanien",

			"Portugal",

			"Schweden",

			"Finnland",

			"Norwegen",

			"Irland",

			"Griechenland",

			"Estland",

			"Lettland",

			"Malta",

			"Litauen",

			"Polen",

			"Slowenien",

			"Slowakei",

			"Tschechien",

			"Türkei",

			"Ungarn",

			"Zypern",

			"Kanada",

			"USA",

			"Kroatien",

			"Bulgarien",

			"Rumänien",

			"Südafrika",

			"Japan",

			"China",

			"Singapur",

			"Dubai (VAE)",

			);

		$laender = array_merge($laender, $Laender);

		if (isset($web_rechte["general"]["zeichenkodierung"]["utf-8"]))

		{

			foreach ($laender as $index => $landname)

			{

				$laender[$index] = utf8_encode($landname);

			}

		}

		else

		{

			foreach ($laender as $index => $landname)

			{

				//Es muss dieses gemacht werden, nur wegen Marine-Sales, da dort sonst die Länder mit Umlauten nicht rauskommen.

				$laender[$index] = htmlentities($landname, ENT_COMPAT, "ISO-8859-15");

			}

		}

	}

	return $laender;

}

function getBestellarten()

{

	global $user_rechte;

	$bestellarten = false;

	if (isset($user_rechte["Warenwirtschaft"]["bestellung"]["bestellart"]))

	{

		if (isset($_SESSION["datenquellen"]["bestellarten"]) && count($_SESSION["datenquellen"]["bestellarten"]) >

			0)

		{

			$where = implode(",", $_SESSION["datenquellen"]["bestellarten"]);

			$sql = "SELECT * FROM bestellart WHERE id IN ( ".$where." )";

		}

		else

		{

			$sql = "SELECT * FROM bestellart";

		}

		$query = $GLOBALS["order_db"]->query($sql);

		if (!$query)

		{

			return false;

		}

		while ($db = $query->unbuffered_row('array'))

		{

			$bestellarten[$db["id"]] = $db;

		}

	}

	return $bestellarten;

}

function getZahlungsarten()

{

	global $user_rechte;

	$zahlungsarten = false;

	if (isset($user_rechte["Warenwirtschaft"]["bestellung"]["zahlungsart"]))

	{

		$sql = "SELECT * FROM zahlungsarten";

		$query = $GLOBALS["order_db"]->query($sql);

		if (!$query)

		{

			return false;

		}

		while ($r = $query->unbuffered_row('array'))

		{

			$zahlungsarten[$r['id']] = $r['name'];

		}

	}

	return $zahlungsarten;

}

function getDates()

{

	$start = strtotime(date("Y-m-01"));

	$buffer[] = array(

		"datum" => strftime("%Y-%m"),

		"datumText" => strftime("%B %G"),

		);

	for ($i = 1; $i <= 25; $i++)

	{

		$buffer[] = array(

			"datum" => strftime("%Y-%m", strtotime("-$i months", $start)),

			"datumText" => strftime("%B %Y", strtotime("-$i months", $start)),

			);

	}

	if (strftime("%w") != 1)

	{

		$start = strtotime("last monday");

	}

	else

	{

		$start = time();

	}

	$buffer[] = array(

		"datum" => strftime("%Y", $start),

		"datumText" => strftime("Jahr %Y", $start),

		);

	$buffer[] = array(

		"datum" => strftime("%Y", strtotime("-1 year", $start)),

		"datumText" => strftime("Jahr %Y", strtotime("-1 year", $start)),

		);

	$buffer[] = array(

		"datum" => strftime("%Y", strtotime("-2 year", $start)),

		"datumText" => strftime("Jahr %Y", strtotime("-2 year", $start)),

		);

	$buffer[] = array(

		"datum" => strftime("%G-%m-%dW", $start),

		"datumText" => strftime("Woche %V %G", $start),

		);

	$buffer[] = array(

		"datum" => strftime("%G-%m-%dW", strtotime("-1 week", $start)),

		"datumText" => strftime("Woche %V %G", strtotime("-1 week", $start)),

		);

	for ($i = 2; $i <= 5; $i++)

	{

		$buffer[] = array(

			"datum" => strftime("%G-%m-%dW", strtotime("-$i weeks", $start)),

			"datumText" => strftime("Woche %V %G", strtotime("-$i weeks", $start)),

			);

	}

	return $buffer;

}

function getWeeks($year = 2008, $maxReverse = 6)

{

	$paramYear = $year;

	$scalar = 0;

	$weekNow = date("W", time());

	$monthNow = date("n", time());

	$dateArray = array();

	$monthArray = array();

	$countedWeek = $weekNow;

	$countedMonth = $monthNow;

	for ($i = $weekNow; $i > ($weekNow - $maxReverse); $i--)

	{

		$dateArray[$scalar]['week'] = $countedWeek;

		$dateArray[$scalar]['year'] = $year;

		$dateArray[$scalar]['date_string'] = "kw,".$countedWeek.",".$year;

		$dateArray[$scalar]['human_string'] = "$countedWeek/$year";

		if ($countedWeek == 1)

		{

			$year -= 1;

			$countedWeek = 1;

		}

		else

		{

			$countedWeek--;

		}

		$scalar++;

	}

	$year = $paramYear;

	for ($i = $monthNow; $i > ($monthNow - $maxReverse); $i--)

	{

		$dateArray[$scalar]['month'] = $countedMonth;

		$dateArray[$scalar]['year'] = $paramYear;

		$dateArray[$scalar]['date_string'] = "mon,".$countedMonth.",".$year;

		$dateArray[$scalar]['human_string'] = date("M", mktime(0, 0, 0, $countedMonth, 1,

			$year))." $year";

		if ($countedMonth == 1)

		{

			$year -= 1;

			$countedMonth = 12;

		}

		else

		{

			$countedMonth--;

		}

		$scalar++;

	}

	return $dateArray;

}