Subversion-Projekte lars-tiefland.content-management

<?

	function getShopInfo($shopID)

	{

		static $buffer = array();

		if ($buffer == array())

		{

			$result = mysql_query("select * from shops");

			while ($r = mysql_fetch_assoc($result))

			{

				$buffer[$r["ID"]] = $r;

			}

		}

		return $buffer[$shopID];

	}

	function gibVersandartAuswahl()

	{

		$self = basename($_SERVER[PHP_SELF]);

		$settings = &$_SESSION[$self];

		$shopData = getShopInfo($settings["shop2"]);

		$lstatus=1; // default Lieferstatus

		//pre($shopData);

		// VERSANDARTEN HOLEN

		$tabelle = "artikel";

		if ($shopData["database"]) $tabelle = $shopData["database"] . "." . $tabelle;

		$query = array();

		//Lieferstatus & ".$settings["Kundendaten"]["Land"]." = ".$settings["Kundendaten"]["Land"]."

		if($settings["Kundendaten"]["Land"]) $lstatus = $settings["Kundendaten"]["Land"];

		$query[0] = "

			SELECT

				ID,

				kurzbezeichnung as kurz,

				langbezeichnung	as lang,

				beschreibung as beschr,

				Rang,

				preis1 as preis

			FROM

				$tabelle

			WHERE

				Father = -3

			AND

				Language = '".$shopData["Language"]."'

			AND

				Lieferstatus & ".$lstatus." = ".$lstatus."

			";

		if ($shopData["database"] == "") $query[1] = " AND status = '" . $settings["shop2"] . "'";

		$query[2] = " order by Rang";

		if ($result = mysql_query (implode(" ",$query))){

			if (mysql_num_rows($result) == 0){

				$query[1] = " AND status = '0'";

			}

		}

		//pre(implode(" ",$query));

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

?><table>

	<tr>

		<td>

			<form name="form_versandart" action="<?=$self;?>" method="POST">

				<input type="hidden" name="submit_versandart" value="1" />

				<select name="Versandart" onChange="javascript:kundendaten_sichern('form_versandart');form_versandart.submit()">

					<option value="1">--- Bitte wählen ---</option>

					<? while($zeile=mysql_fetch_assoc($result)) {

					?>

					<option value="<?=$zeile[ID];?>"<? if ($settings['versandart'] == $zeile[ID]) {echo " selected"; $settings['versandpreis'] = $zeile["preis"]; } ?> /><?=$zeile[kurz];?></option>

					<? } ?>

				</select>

			</form>

		</td>

		<td>

			<form name="form_versandpreis" action="<?=$self;?>" method="POST">

				<input

					type="text"

					name="versandpreis"

					value="<?=$settings['versandpreis'];?>"

					size="4"

					onChange="javascript:kundendaten_sichern('form_versandpreis');form_versandpreis.submit()"

				/> €

				<input

					type="hidden"

					name="submit_versandpreis"

					value="1"

				/>

			</form>

		</table>

<? } ?>