<?php

/**
 * 
 * Copyright (C) Die Randgruppe GmbH
 * 
 * http://www.randshop.com
 * http://www.dierandgruppe.com
 * 
 * Unter der Lizenz von Die Randgruppe GmbH:
 * http://www.randshop.com/Lizenz
 *  
 * $Author$
 * $Date$
 * $Revision$
 * 
 */

function GetMwStDataArray() {

	// SQL-String f�r die MwSt zusammensetzen
	$SQLString = "SELECT ";
	$SQLString .= TABLE_MWST . ".id, ";
	$SQLString .= TABLE_MWST . ".mwst, ";
	$SQLString .= TABLE_MWST . ".standard ";
	$SQLString .= "FROM " . TABLE_MWST;
	$SQLString .= " ORDER BY " . TABLE_MWST . ".mwst ASC";
	
	// MwSt abfragen
	$MySQLQueryReference = errorlogged_mysql_query($SQLString);
	$MwStCounter = 0;
	
	while ($MwStRow = mysql_fetch_array($MySQLQueryReference)) {

		$MwStArray[$MwStCounter]["id"] = $MwStRow["id"];
		$MwStArray[$MwStCounter]["mwst"] = $MwStRow["mwst"];
		$MwStArray[$MwStCounter]["standard"] = $MwStRow["standard"];
		
		$MwStCounter++;
	}
	
	return $MwStArray;
	
}

function GetMwStDetail($MwStID = 0, $MwSTSatz = 0) {

	// SQL-String f�r die MwSt zusammensetzen
	$SQLString = "SELECT ";
	$SQLString .= TABLE_MWST . ".id, ";
	$SQLString .= TABLE_MWST . ".mwst, ";
	$SQLString .= TABLE_MWST . ".standard ";
	$SQLString .= "FROM " . TABLE_MWST . " ";
	$SQLString .= "WHERE 1 "; 
	if($MwStID){
		$SQLString .= "AND " . TABLE_MWST . ".id = '" . $MwStID . "'";
	}
	if($MwSTSatz){
		$SQLString .= "AND " . TABLE_MWST . ".mwst = '" . $MwSTSatz . "'";
	}
    if(!$MwStID && !$MwSTSatz) {
        $SQLString .= "AND " . TABLE_MWST . ".standard = '1'";
    }

	// MwSt abfragen
	$MwStObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
	
	return $MwStObject;
	
}

function AddMwSt($MwSTSatz){
	
	$SQLString = "INSERT INTO " . TABLE_MWST . " SET ";
	$SQLString .= TABLE_MWST . ".mwst = " . $MwSTSatz . ", ";
	$SQLString .= TABLE_MWST . ".standard = 0";
	
	//echo $SQLString;
	
	errorlogged_mysql_query($SQLString);
	
	return mysql_insert_id();
	
	
}