<?
/**
* HTMLConvert
*
* @author Stefan Ruestmann <sruestmann@web.de>
* @version 1.1
*/

class HTMLConvert{
	var $filename = "temp.html";
    var $HTMLTEXTxml;
    var $HTMLTEXausgabe;
    var $HTMLTEXstatus=array();
    var $HTMLTEXstatus_name="";

    /**
     * Konvertiert HTMLText zu Text
     *
     * @param string html
     * @return string text
     */
	    function HTML2Text($HTML){
	        $HTML = strip_tags($HTML);
	        $HTML = html_entity_decode($HTML);
	        $HTML = trim(str_replace("&euro;","€",$HTML));
	        return $HTML;
	    }
	    
	/**
	 * Konvertiert einen Text zum HTML Zeichen
	 * @param string $text
	 * @return string $HTML
	 */
	    function Text2HTML($text){
			$text = str_replace("Š","&auml;",$text);
			$text = str_replace("ź","&uuml;",$text);
			$text = str_replace("š","&ouml;",$text);
			$text = str_replace("€","&Auml;",$text);
			$text = str_replace("†","&Uuml;",$text);
			$text = str_replace("…","&Ouml;",$text);
			$text = str_replace("§","&szlig;",$text);
	    	return $text;
	    }

	/**
	 * Entfernt HTML Tags
	 *
	 * @param String html
	 * @param String tag
	 * @return String bereingtes HTML
	 */
	 	function DeleteTag($html,$tag){
	 		$Status=0;
			$TempHTML="";

	 		if ($tag == "*"){
				/*
				$html = preg_replace("/\<(.*?)\>/si", "", $html);
				$html = preg_replace("/\<\/(.*?)\>/si", "", $html);
				*/
				$TempHTML=strip_tags($html);
	 		}else{
				$html = preg_replace("/<$tag(.*?)>/si", "", $html);
				$html = preg_replace("/<\/$tag(.*?)>/si", "", $html);
				$TempHTML=$html;
				/*
				for ($i=0 ; $i<=strlen($html); $i++){
					if (strtolower(substr($html,$i,strlen($tag) + 1)) == "<" . strtolower($tag)){$Status=1;$i=$i+strlen($tag) + 1;}
					if (strtolower(substr($html,$i,strlen($tag) + 2)) == "</" . strtolower($tag)){$Status=0;$i=$i+strlen($tag) + 3;}

					if ($Status != 1){
						$TempHTML.=substr($html,$i,1);
					}else{
						//if (substr($html,$i,1) == ">"){$Status=0;}
					}
				}
				*/
	 		}
			return $TempHTML;
	 	}

	 /**
	  * Liefert den Inhalt eines Tags
	  *
	  * TODO: Muss noch besser ausgebaut werden
	  */
	 	function getHTMLTag($html, $tag){
	 		$Inhalt="";
			for ($i = 0 ; $i <= strlen($html) ; $i++){
				if (strtolower(substr($html,$i,(strlen($tag)+2) )) == "<" . strtolower($tag) . ">"){$status=1;$i=$i+strlen($tag)+2;}
				if (strtolower(substr($html,$i,(strlen($tag)+3) )) == "</" . strtolower($tag) . ">"){$status=0;break;}
				if ($status==1){$Inhalt .= substr($html,$i,1);}
			}
			return $Inhalt;
		}

	/**
	* Konvertiert Text zu HTML Konformen Text
	*
	* @param String wert
	* @return String html
	**/
		function HTMLencode($wert){
			$Sonderzeichen = get_html_translation_table(HTML_ENTITIES);
			$Sonderzeichen["<"]="<";
			$Sonderzeichen[">"]=">";
			return strtr($wert,$Sonderzeichen);
		}

	/**
	* Konvertiert HTML zu Text
	*
	* @param String wert
	* @return String text
	**/
		function HTMLdecode($wert){
			$Sonderzeichen = get_html_translation_table(HTML_ENTITIES);
			$Sonderzeichen["<"]="<";
			$Sonderzeichen[">"]=">";

			foreach ($Sonderzeichen as $id => $value){
				$SonderzeichenAnders[$value]=$id;
			}
			return strtr($wert,$SonderzeichenAnders);
		}

		function FlashHTMLencode($wert){
			$Sonderzeichen["\""]="&#34;";
			$$Sonderzeichen["/"]="&#47;";
			$Sonderzeichen[";"]="&#59;";
			$Sonderzeichen["<"]="&#60;";
			$Sonderzeichen[">"]="&#62;";
			$Sonderzeichen[";"]="&#59;";
			$Sonderzeichen["="]="&#61;";
			$Sonderzeichen["#"]="&#35;";
			$Sonderzeichen["&"]="&amp;";
			$Sonderzeichen["!"]="&#33;";
			$Sonderzeichen["$"]="&#36;";
			$Sonderzeichen["%"]="&#37;";
			$Sonderzeichen["'"]="&#39;";
			$Sonderzeichen["("]="&#40;";
			$Sonderzeichen[")"]="&#41;";
			$Sonderzeichen["*"]="&#42;";
			$Sonderzeichen["+"]="&#43;";
			$Sonderzeichen[","]="&#44;";
			$Sonderzeichen["-"]="&#45;";
			$Sonderzeichen["."]="&#46;";
			$Sonderzeichen[":"]="&#58;";
			$Sonderzeichen["?"]="&#63;";
			$Sonderzeichen["@"]="&#64;";
			$Sonderzeichen["["]="&#91;";
			$Sonderzeichen["\\"]="&#92;";
			$Sonderzeichen["]"]="&#93";
			$Sonderzeichen["^"]="&#94;";
			$Sonderzeichen["_"]="&#95;";
			$Sonderzeichen["`"]="&#96;";
			$Sonderzeichen[""]="&#128;";
			$Sonderzeichen["-"]="&#173;";
			$Sonderzeichen["'"]="&#180;";
			$Sonderzeichen[","]="&#184;";

			$temp = $wert;
			foreach ($Sonderzeichen as $id => $value){
				$temp = str_replace($id,$value,$temp);
			}
			return $temp;
		}

		function FlashHTMLdecode($wert){
			$Sonderzeichen["\""]="&#34;";
			$$Sonderzeichen["/"]="&#47;";
			$Sonderzeichen[";"]="&#59;";
			$Sonderzeichen["<"]="&#60;";
			$Sonderzeichen[">"]="&#62;";
			$Sonderzeichen[";"]="&#59;";
			$Sonderzeichen["="]="&#61;";
			$Sonderzeichen["#"]="&#35;";
			$Sonderzeichen["&"]="&amp;";
			$Sonderzeichen["!"]="&#33;";
			$Sonderzeichen["$"]="&#36;";
			$Sonderzeichen["%"]="&#37;";
			$Sonderzeichen["'"]="&#39;";
			$Sonderzeichen["("]="&#40;";
			$Sonderzeichen[")"]="&#41;";
			$Sonderzeichen["*"]="&#42;";
			$Sonderzeichen["+"]="&#43;";
			$Sonderzeichen[","]="&#44;";
			$Sonderzeichen["-"]="&#45;";
			$Sonderzeichen["."]="&#46;";
			$Sonderzeichen[":"]="&#58;";
			$Sonderzeichen["?"]="&#63;";
			$Sonderzeichen["@"]="&#64;";
			$Sonderzeichen["["]="&#91;";
			$Sonderzeichen["\\"]="&#92;";
			$Sonderzeichen["]"]="&#93";
			$Sonderzeichen["^"]="&#94;";
			$Sonderzeichen["_"]="&#95;";
			$Sonderzeichen["`"]="&#96;";
			$Sonderzeichen[""]="&#128;";
			$Sonderzeichen["|"]="&#166;";
			$Sonderzeichen["-"]="&#173;";
			$Sonderzeichen["'"]="&#180;";
			$Sonderzeichen[","]="&#184;";

			$temp = $wert;
			foreach ($Sonderzeichen as $id => $value){
				$temp = str_replace($value,$id,$temp);
			}
			return $temp;
		}
}
?>
<?
/**
* HTMLObjekte
*
* @author Stefan Ruestmann <sruestmann@web.de>
* @version 1.1
*/

class HTMLObjekte{
	var $db;

	/**
	* Konstruktor
	*/
		function __construct(){$this->HTMLObjekte();}
		function HTMLObjekte(){
			$c = new Connection();
			$this->db=$c->get();
			$this->db->SetFetchMode(ADODB_FETCH_BOTH);
		}

	/**
	 * getSelectBySQL
	 */
	 	function getSelectBySQL($name,$sql,$selected,$size=1,$addData=array()){
	 		$HTML="";
			if ($sql){
	 			$rs = $this->db->Execute($sql);
				if (!$rs->EOF && $rs){
					$HTML="<select name=\"" . $name . "\" id=\"" . $name . "\" size=\"" . $size . "\">";
					while (!$rs->EOF){
						if($rs->fields(0) == $selected){
							$HTML.="<option value=\"" . $rs->fields(0) . "\"selected>" . $rs->fields(1). "</option>";
						}else{
							$HTML.="<option value=\"" . $rs->fields(0) . "\">" . $rs->fields(1). "</option>";
						}
						$rs->MoveNext();
					}

					//Weitere Daten
						if(is_array($addData) && count($addData)){
							foreach ($addData as $id => $value){
								if($id == $selected){
									$HTML.="<option value=\"" . $id . "\"selected>" . $value . "</option>";
								}else{
									$HTML.="<option value=\"" . $id . "\">" . $value . "</option>";
								}
							}
						}

					$HTML.="</select>";
				}
			}
			return $HTML;
	 	}
	 	
	 	function getSelectByArray($name,$daten=array(),$selected,$size=1){
	 		$html="<select size=\"" . $size . "\" name=\"" . $name . "\" id=\"" . $name . "\">";
	 		foreach ($daten as $id => $value){
	 			 if ($id == $selected){
	 			 	$html.="<option value=\"" . $id . "\" selected>" . $value . "</option>";
	 			 }else{
	 			 	$html.="<option value=\"" . $id . "\">" . $value . "</option>";
	 			 }
	 		}
	 		$html.="</select>";
	 		return $html;
	 	}

	 /**
	  * Liefert einen Wert aus der Datenbank zurueck
	  */
	 	function getWert($sql){
	 		$wert="";
	 		$rs = $this->db->Execute($sql);
	 		if (!$rs->EOF && $rs){
	 			$wert = $rs->fields(0);
	 		}
	 		return $wert;
	 	}

	 /**
	  * Liefert eine STab View zurueck
	  * 
	  * @param $elemente
	  * @return string $html
	  */
	 	function getSTab($elemente){
	 		
	 	}
	 	
	 /**
	  * Erzeugt eine Tabelle, die farbliche Zeilen hat
	  * @return unknown_type
	  */
	 	function getTable($header=array(),$daten=array(),$optionen=array()){
	 		// Header
		 		$HTML="<table class='XSTARTable' border='1' width='100%'><tr>";
		 		foreach ($header as $id => $value){
		 			$HTML.="<td>" . $value . "</td>";
		 		}
		 		$HTML.="</tr>";
		 		
		 	// Daten
		 		$Zaehler=0;
		 		$HTML.="</tr>";
		 		foreach ($daten as $id => $value){
		 			foreach ($value as $id1 => $value1){
		 				$HTML.="<td class='XSTARTableTD" . $Zaehler . "'>" . $value1 . "</td>";
		 				if ($Zaehler >= 1){$Zaehler=0;}
		 			}
		 		}
		 		$HTML.="</tr>";
	 		
	 		
	 	}
}
?><?
/**
* HTMLTemplate
*
* @author Stefan Ruestmann <sruestmann@web.de>
* @version 1.1
*/

class HTMLTemplate{
	/**
	* Konstruktor
	*/	
		function HTMLTemplate(){
		
		}
	
	/**
	* get - Liefert ein geparstes Template
	*/
		function get($filename,$austauschen=array()){
			$HTML="";
			if (file_exists($filename)){
				$F=new Filesystem();	
				$HTML=$F->fread($filename);
				if (is_array($austauschen)){
					foreach ($austauschen as $id => $value){
						$HTML=str_replace("{\$".$id."}",$value,$HTML);
						$HTML=str_replace($id,$value,$HTML);
					}
				}
			}
			return $HTML;
		}
}
?><?
/**
 * Erweiterung der Klassen FPDF
 *
 * @author Stefan Rďż˝stmann
 * @version 0.2
 */

class PDF_MC_Table extends FPDF{
	var $widths;
	var $aligns;
	var $Empfaenger="Stefan Ruestmann";
	var $Absender;
	var $Grafik=false;
	var $Netto=false;
	var $Leer=false;
	var $Config;
	var $StatusZeileFarbe=false;
	var $TabellenRahmen=1;

	function SetWidths($w){
    	//Set the array of column widths
    	$this->widths=$w;
	}

	function SetAligns($a){
	    //Set the array of column alignments
	    $this->aligns=$a;
	}

	function Header($line=0){
		global $MyXStarConf;

	
		// Nettorechnung??
		if ($this->Netto){
		  	$TempFilename = DIR_FS_CATALOG  . "includes/modules/XStar/images/rechnung_bg_netto.jpg";
			if (file_exists($TempFilename)){
				$this->Image($TempFilename,-5,50);
			}
		}
			
		if ($this->Leer==true){
		}else{
			// Header Logo setzten
			if ($this->Grafik){
				$TempFilename = DIR_FS_CATALOG . "templates/" . CURRENT_TEMPLATE . "/img/fpdf_head.jpg";
				if (file_exists($TempFilename)){
					$this->image($TempFilename,-5,0,220);
				}

				if ($this->page == 1){
					$this->SetFont($MyXStarConf["xstar_pdfrechnung_fontfamiliy_absender"],'U',$MyXStarConf["xstar_pdfrechnung_fontsize_absender"]);
					$this->text(25,53,$this->Absender);
					//$this->text(25,40,$this->Absender); NEU TODO: NACH ISO
					if ($MyXStarConf["xstar_pdfrechnung_anrede_in_anschriftbox"] == 1){
						$this->SetFont($MyXStarConf["xstar_pdfrechnung_fontfamiliy_absender"],'',$MyXStarConf["xstar_pdfrechnung_fontsize_absender"]);
						$this->text(25,57,"Herr / Frau / Firma");
						//$this->text(25,44,"Herr / Frau / Firma"); NEU TODO: NACH ISO
					}
				}
			}

			// Anschrift Platzieren
		   	$this->SetFont($MyXStarConf["xstar_pdfrechnung_fontfamiliy_anschrift"],'',$MyXStarConf["xstar_pdfrechnung_fontsize_anschrift"]);
			if ($line >= 1){
				$this->Ln($line);
			}else{
			    if ($this->page == 1){
			    	//$this->Ln(37); NEU TODO: NACH ISO
			    	$this->Ln(50);
				    $this->MultiCell(100,5,$this->Empfaenger);
				    //$this->Ln(10); NEU TODO: NACH ISO
				}else{
					$this->Ln(30);
				}
			}

			// Falzmarken setzten
			$this->SetDrawColor(0);
			$this->Line(3,95,0,95);
			$this->Line(5,150,0,150);
		}
	}

	function Footer($line=0){
		global $MyXStarConf;

	    // Sonstige FooterInformationen setzten
	    	if ($this->Grafik){
	    		$TempFilename = DIR_FS_CATALOG . "templates/" . CURRENT_TEMPLATE . "/img/fpdf_foot.jpg";
				if (file_exists($TempFilename)){
					$this->image($TempFilename,-5,260,220);
				}

				$Elemente=0;
				if ($MyXStarConf["xstar_pdfrechnung_fuss_1_1"]){$Elemente++;}
				if ($MyXStarConf["xstar_pdfrechnung_fuss_2_1"]){$Elemente++;}
				if ($MyXStarConf["xstar_pdfrechnung_fuss_3_1"]){$Elemente++;}
				if ($MyXStarConf["xstar_pdfrechnung_fuss_4_1"]){$Elemente++;}
				//print $Elemente;exit();

				switch ($Elemente){
					case 1:
						$Left1=10;
						break;
					case 2:
						$Left1=10;
						$Left2=$Left1+110;
						break;
					case 3:
						$Left1=10;
						$Left2=$Left1+50;
						$Left3=$Left2+50;
						break;
					case 4:
						$Left1=10;
						$Left2=$Left1+50;
						$Left3=$Left2+50;
						$Left4=$Left3+50;
						break;
				}

				$Top=278;
				if ($MyXStarConf["xstar_pdfrechnung_fuss_top"]>0){$Top=$MyXStarConf["xstar_pdfrechnung_fuss_top"];}
				if ($MyXStarConf["xstar_pdfrechnung_fuss_1_1"]){
					$this->SetFont($MyXStarConf["xstar_pdfrechnung_fontfamiliy_fusszeile"],'',$MyXStarConf["xstar_pdfrechnung_fontsize_fusszeile"]);
		    		$this->text ($Left1,$Top,$MyXStarConf["xstar_pdfrechnung_fuss_1_1"]);
		    		$this->text ($Left1,$Top+3,$MyXStarConf["xstar_pdfrechnung_fuss_1_2"]);
		    		$this->text ($Left1,$Top+3+3,$MyXStarConf["xstar_pdfrechnung_fuss_1_3"]);
		    		$this->text ($Left1,$Top+3+3+3,$MyXStarConf["xstar_pdfrechnung_fuss_1_4"]);
				}

				if ($MyXStarConf["xstar_pdfrechnung_fuss_2_1"]){
					$this->SetFont($MyXStarConf["xstar_pdfrechnung_fontfamiliy_fusszeile"],'',$MyXStarConf["xstar_pdfrechnung_fontsize_fusszeile"]);
		    		$this->text ($Left2,$Top,$MyXStarConf["xstar_pdfrechnung_fuss_2_1"]);
		    		$this->text ($Left2,$Top+3,$MyXStarConf["xstar_pdfrechnung_fuss_2_2"]);
		    		$this->text ($Left2,$Top+3+3,$MyXStarConf["xstar_pdfrechnung_fuss_2_3"]);
		    		$this->text ($Left2,$Top+3+3+3,$MyXStarConf["xstar_pdfrechnung_fuss_2_4"]);
				}

				if ($MyXStarConf["xstar_pdfrechnung_fuss_3_1"]){
					$this->SetFont($MyXStarConf["xstar_pdfrechnung_fontfamiliy_fusszeile"],'',$MyXStarConf["xstar_pdfrechnung_fontsize_fusszeile"]);
		    		$this->text ($Left3,$Top,$MyXStarConf["xstar_pdfrechnung_fuss_3_1"]);
		    		$this->text ($Left3,$Top+3,$MyXStarConf["xstar_pdfrechnung_fuss_3_2"]);
		    		$this->text ($Left3,$Top+3+3,$MyXStarConf["xstar_pdfrechnung_fuss_3_3"]);
		    		$this->text ($Left3,$Top+3+3+3,$MyXStarConf["xstar_pdfrechnung_fuss_3_4"]);
				}

				if ($MyXStarConf["xstar_pdfrechnung_fuss_4_1"]){
					$this->SetFont($MyXStarConf["xstar_pdfrechnung_fontfamiliy_fusszeile"],'',$MyXStarConf["xstar_pdfrechnung_fontsize_fusszeile"]);
		    		$this->text ($Left4,$Top,$MyXStarConf["xstar_pdfrechnung_fuss_4_1"]);
		    		$this->text ($Left4,$Top+3,$MyXStarConf["xstar_pdfrechnung_fuss_4_2"]);
		    		$this->text ($Left4,$Top+3+3,$MyXStarConf["xstar_pdfrechnung_fuss_4_3"]);
		    		$this->text ($Left4,$Top+3+3+3,$MyXStarConf["xstar_pdfrechnung_fuss_4_4"]);
				}
	    	}

	    // Seitenummer setzten
		    if ($line){
		    }else{
		    	if(!$this->footerset[$this->page]) {
		        	$this->SetY(-25);
		        	$this->Ln(7);
		        	//$this->Cell(175,5,$this->page,0,0,C);
		    	}
		    }
	}

	function Row($data){
	    //Calculate the height of the row
	    $nb=0;
	    for($i=0;$i<count($data);$i++)
	        $nb=max($nb, $this->NbLines($this->widths[$i], $data[$i]));
	    $h=(4*$nb);
	    if (isset($this->Config->Conf["descriptioninorder"])){
		    if ($this->Config->Conf["descriptioninorder"] == "true"){
				//$h=(2.5*$nb);
				$h=(4*$nb);
		    }else{
		    	$h=(5*$nb);
		    }
	    }
		$h=(5*$nb);


	    //Issue a page break first if needed
	    $this->CheckPageBreak($h);
	    //Draw the cells of the row

	    // Hintergrund
	    $this->SetFillColor(227, 227, 227);
	    for($i=0;$i<count($data);$i++){
	        $w=$this->widths[$i];
	        $a=isset($this->aligns[$i]) ? $this->aligns[$i] : 'L';
	        //Save the current position
	        $x=$this->GetX();
	        $y=$this->GetY();
	        //Draw the border
	        if($this->TabellenRahmen == 1){
	        	$this->Rect($x, $y, $w, $h);
	        }
	        //Print the text
	        
		  	$this->MultiCell($w, 5, $data[$i], 0, $a, 0);
		  	
	        //Put the position to the right of the cell
	        $this->SetXY($x+$w, $y);
	    }
		if ($this->StatusZeileFarbe==true){
			$this->StatusZeileFarbe=false;
		}else{
			$this->StatusZeileFarbe=true;
		}

	    //Go to the next line
	    $this->Ln($h);
	}

	function CheckPageBreak($h){
	    //If the height h would cause an overflow, add a new page immediately
	    if($this->GetY()+$h>$this->PageBreakTrigger)
	        $this->AddPage($this->CurOrientation);
	}

	function NbLines($w, $txt){
	    //Computes the number of lines a MultiCell of width w will take
	    $cw=&$this->CurrentFont['cw'];
	    if($w==0)
	        $w=$this->w-$this->rMargin-$this->x;
	    $wmax=($w-2*$this->cMargin)*1000/$this->FontSize;
	    $s=str_replace("\r", '', $txt);
	    $nb=strlen($s);
	    if($nb>0 and $s[$nb-1]=="\n")
	        $nb--;
	    $sep=-1;
	    $i=0;
	    $j=0;
	    $l=0;
	    $nl=1;
	    while($i<$nb)
	    {
	        $c=$s[$i];
	        if($c=="\n")
	        {
	            $i++;
	            $sep=-1;
	            $j=$i;
	            $l=0;
	            $nl++;
	            continue;
	        }
	        if($c==' ')
	            $sep=$i;
	        $l+=$cw[$c];
	        if($l>$wmax)
	        {
	            if($sep==-1)
	            {
	                if($i==$j)
	                    $i++;
	            }
	            else
	                $i=$sep+1;
	            $sep=-1;
	            $j=$i;
	            $l=0;
	            $nl++;
	        }
	        else
	            $i++;
	    }
	    return $nl;
	}

	var $B=0;
    var $I=0;
    var $U=0;
    var $HREF='';
    var $ALIGN='';

    function WriteHTML($html){

        //HTML parser
        $html=str_replace("\n", ' ', $html);
        $a=preg_split('/<(.*)>/U', $html, -1, PREG_SPLIT_DELIM_CAPTURE);
        foreach($a as $i=>$e)
        {
            if($i%2==0)
            {
                //Text
                if($this->HREF)
                    $this->PutLink($this->HREF, $e);
                elseif($this->ALIGN == 'center')
                    $this->Cell(0, 5, $e, 0, 1, 'C');
                else
                    $this->Write(5, $e);
            }
            else
            {
                //Tag
                if($e{0}=='/')
                    $this->CloseTag(strtoupper(substr($e, 1)));
                else
                {
                    //Extract properties
                    $a2=split(' ', $e);
                    $tag=strtoupper(array_shift($a2));
                    $prop=array();
                    foreach($a2 as $v)
                        if(ereg('^([^=]*)=["\']?([^"\']*)["\']?$', $v, $a3))
                            $prop[strtoupper($a3[1])]=$a3[2];
                    $this->OpenTag($tag, $prop);
                }
            }
        }
    }

    function OpenTag($tag, $prop){
        //Opening tag
        if($tag=='STRONG'){
        	$this->SetStyle('B', true);
        }
        if($tag=='B' or $tag=='I' or $tag=='U')
            $this->SetStyle($tag, true);
        if($tag=='A')
            $this->HREF=$prop['HREF'];
        if($tag=='BR')
            $this->Ln(5);
        if($tag=='P')
            $this->Ln(5);
            $this->ALIGN=$prop['ALIGN'];
        if($tag=='HR')
        {
            if( $prop['WIDTH'] != '' )
                $Width = $prop['WIDTH'];
            else
                $Width = $this->w - $this->lMargin-$this->rMargin;
            $this->Ln(2);
            $x = $this->GetX();
            $y = $this->GetY();
            $this->SetLineWidth(0.4);
            $this->Line($x, $y, $x+$Width, $y);
            $this->SetLineWidth(0.2);
            $this->Ln(2);
        }
    }

    function CloseTag($tag){
        //Closing tag
        if($tag=='STRONG'){
        	$this->SetStyle('B', false);
        }
        if($tag=='B' or $tag=='I' or $tag=='U')
            $this->SetStyle($tag, false);
        if($tag=='A')
            $this->HREF='';
        if($tag=='P')
            $this->ALIGN='';
    }

    function SetStyle($tag, $enable){
        //Modify style and select corresponding font
        $this->$tag+=($enable ? 1 : -1);
        $style='';
        foreach(array('B', 'I', 'U') as $s)
            if($this->$s>0)
                $style.=$s;
        $this->SetFont('', $style);
    }

    function PutLink($URL, $txt){
        //Put a hyperlink
        $this->SetTextColor(0, 0, 255);
        $this->SetStyle('U', true);
        $this->Write(5, $txt, $URL);
        $this->SetStyle('U', false);
        $this->SetTextColor(0);
    }
}
?><?
/**
* Synchronisiert Daten zwischen der ERP Mercator und dem XTCommerce
* 
* @author Stefan Ruestmann <info@x-star.de>
* @version 1.5
* 
* Anpassungen SQL:
* 
* Die categorie_id und parent_id muss von int auf bigint in den Tabellen (categories, categories_description und products_to_categories) angepasst werden
* 
* Version 1.4
* 	- Bilder werden auf veraenderung geprueft und nicht grundsaetzlich neu erzeugt
* 	- Nach einem Import werden restliche Bilder geloescht
* 	- loeschen.xml - ALLESLOESCHEN wird beruecksichtigt
* 
* Version 1.5
* 	- komplette Startmethode wurde angepasst (Parameter: START, TODO, INFO)
* 
* Version 1.5.1
* 	- Preismenge wird im XTC angelegt und auch befuellt. Beim Datenexport wird die Preismenge mit exportiert.
* 
* Version 1.5.2
* 	- Produktfilter im __construct angepasst, so dass nicht immer alles komplett aktualisiert wird
* 	- cleanDatabase hinzugefďż˝gt
**/

/*
error_reporting(E_ALL & ~E_NOTICE);
ini_set("display_errors", 1);
*/

class SyncMercator{
	var $Programmname="Synchronisationsmodul Mercator - XTCommerce v 1.5.3";
	var $TODID=0;
	var $Counts=array();
	var $Debug=false;
	var $db;
	var $fs;
	var $Meldungen=array();
	var $PathImport="";
	var $PathExport="";
	var $Status_PRODUCTS_TO_CATEGORIES=false;
	var $TimeFileOrder="";
	var $TimeFileCron="";
	var $ArtikelKinder=array();
	var $DeleteFiles=false;
	var $Config;
	var $SendStatusEmail=false;
	var $StdKundengruppe=0;
	var $ModulMindesbestellmenge=false;
	var $CSSFileLink;

	function __construct($leise=false, $cron=false){$this->SyncMercator($leise,$cron);}
	function __destruct(){
		if ($this->Debug){$this->setStatus(date("r",time()));}	
	}
	function SyncMercator($leise=false, $cron=false){
		if (isset($_GET["DEBUG"])){$this->Debug=true;}
		if ($this->Debug){$this->setStatus(date("r",time()));}
		
		// Datenbankverbindung
		 	$temp = new Connection();
			$this->db = $temp->get();
			//$this->db->debug=true;
			$this->createTables();
        
		// erstmal einiges definieren
			$this->fs = new Filesystem();
			$this->Config = new Config();

		// Optimierungen durchfuerhen, wenn noch nicht geschehen
			$TempSyncOpt=$this->Config->get("xstar_sync_mercator_opt");
			if ($TempSyncOpt<1){
				$sql = "CREATE INDEX syncwawi_idx USING BTREE ON syncwawi (sort , erledigt, in_bearbeitung);";
				$this->db->Execute($sql);
				
				$sql = "CREATE INDEX products_idx USING BTREE ON products (products_model);";
				$this->db->Execute($sql);
				
				$sql = "CREATE INDEX products_vpe_idx USING BTREE ON products_vpe (products_vpe_id, products_vpe_name);";
				$this->db->Execute($sql);
				
				$sql = "CREATE INDEX products_options_values_idx USING BTREE ON products_options_values (products_options_values_name);";
				$this->db->Execute($sql);
				
				$sql = "CREATE INDEX products_options_idx USING BTREE ON products_options (products_options_name);";
				$this->db->Execute($sql);
				
				$sql = "CREATE INDEX products_options_values_to_products_options_idx USING BTREE ON products_options_values_to_products_options (products_options_id, products_options_values_id);";
				$this->db->Execute($sql);
				
				$sql = "CREATE INDEX temp_xtc_warnhinweise_idx USING BTREE ON temp_xtc_warnhinweise (products_id);";
				$this->db->Execute($sql);
				
				for ($i=0; $i<=15; $i++){
					$sql = "CREATE INDEX personal_offers_by_customers_status_" . $i . "_idx USING BTREE ON personal_offers_by_customers_status_" . $i . " ( products_id , quantity);";
					$this->db->Execute($sql);
				}
				
				$sql = "CREATE INDEX products_images_idx USING BTREE ON products_images (products_id);";
				$this->db->Execute($sql);
				
				$this->Config->set("xstar_sync_mercator_opt",1);
			}
			
		// Stylen
			$this->CSSFileLink=DIR_WS_DOCUMENT_ROOT_XSTAR."/style/SyncMercator.css";
			
		// Verzeichnisse definieren
			if ($_SERVER["HTTP_HOST"] == "mobabau.de" || 
				$_SERVER["HTTP_HOST"] == "www.mobabau.de" || 
				$_SERVER["HTTP_HOST"] == "www.mobabau.com" ||
				$_SERVER["HTTP_HOST"] == "mobabau.com" || 
				$_SERVER["HTTP_HOST"] == "www.hmw-teich.de" ||
				$_SERVER["HTTP_HOST"] == "hmw-teich.de"){
			
				$this->PathImport=DIR_FS_DOCUMENT_ROOT."/mercator/import/";	    
				$this->PathExport=DIR_FS_DOCUMENT_ROOT."/mercator/export/";                  
			    $this->TimeFileOrder=DIR_FS_DOCUMENT_ROOT_XSTAR."/includes/modules/sync_mercator_ordertime.txt";
			    $this->TimeFileCron=DIR_FS_DOCUMENT_ROOT."/mercator/import/status.txt";
			}else{
				$this->PathImport=DIR_FS_DOCUMENT_ROOT."/import/mercator/";
		        $this->PathExport=DIR_FS_DOCUMENT_ROOT."/export/mercator/";                  
		        $this->TimeFileOrder=DIR_FS_DOCUMENT_ROOT_XSTAR."/includes/modules/sync_mercator_ordertime.txt";
		        $this->TimeFileCron=DIR_FS_DOCUMENT_ROOT."/import/mercator/status.txt";
			}

		// Sind alle Verzeichnisse vorhanden
			if (!is_dir($this->PathImport)){mkdir($this->PathImport,0777);}
	        if (!is_dir($this->PathImport."/daten/")){mkdir($this->PathImport."/daten/",0777);}
	        if (!is_dir($this->PathImport."/bilder/")){mkdir($this->PathImport."/bilder/",0777);}
	                
	        if (!is_dir($this->PathExport)){mkdir($this->PathExport,0777);}
	        if (!is_dir($this->PathExport."/daten/")){mkdir($this->PathExport."/daten/",0777);}
	        if (!is_dir($this->PathExport."/logs/")){mkdir($this->PathExport."/logs/",0777);}
	        	        
	    // HTML Startkopf
	    	$HTMLStartkopf=$this->getCSS();
			$HTMLStartkopf.="<p><span class=\"Header\">" . $this->Programmname . "</span><br><span class=\"Copyright\">copyright by <a href=\"http:www.webdesign-ruestmann.de\" target=\"_blank\">WEBDESIGN-R&Uuml;STMANN</a> 2009 - " . date("Y",time()) . "</span></p>";
			
		// Los geht es - Neustart?
		if (isset($_GET["START"])){
			$this->TODOID=time();

			print $HTMLStartkopf;
			$this->setStatus("Sync wurde gestartet");
						
			// Datenbank bereinigen
			$sql = "DELETE FROM syncwawi";
			$this->db->Execute($sql);
			
			$this->addTODO("ID",$this->TODOID,0);
			
			// Was ist zu tun - Dateien lesen
			$PathInhalt=$this->fs->readDir($this->PathImport."/daten/");

			if (count($PathInhalt) > 0){
				// Neu sortieren
				$CountArtikelDatei=0;
				$CountLoeschDatei=0;
				$CountHerstellerDatei=0;
				$CountKundenDatei=0;
				$CountKategorienDatei=0;
				
				$TempPathInhalt=array();
				foreach ($PathInhalt as $id => $value){
					$TempZahl=explode("_",$value["name"]);
					$TempPathInhalt[$TempZahl[0].str_pad($TempZahl[1], 10 ,'0', STR_PAD_LEFT)]=$value;
				}
				ksort ($TempPathInhalt);
				$PathInhalt=$TempPathInhalt;				
				
				// existiert eine komplett Loeschdatei und Dateien durchzĂ¤hlen
				foreach ($PathInhalt as $id => $value){
					if (substr($value["name"],0,8)=="loeschen"){
						$CountLoeschDatei++;
						$filename=$this->PathImport."daten/" . $value["name"];
						if (file_exists($filename)){
							$temp=$this->readXML($filename);
							if ($temp->ALLE_LOESCHEN == 1){
								$this->setStatus("!!! ALLE ARTIKEL WERDEN GEL&Ouml;SCHT","Fehler");
								$this->addTODO("DELETEALL",1,-1);
							}
						}
					}
					
					// Hersteller
					if (substr($value["name"],0,14) == "temphersteller" || substr($value["name"],0,10) == "hersteller"){
						$CountHerstellerDatei++;
						$this->addTODO("FILE",$value["name"],30);
					}
					
					// Lieferanten
					if (preg_match("/lieferanten/",$value["name"])){
						$CountHerstellerDatei++;
						$this->addTODO("FILE",$value["name"],30);
					}
						
					// Katgeorien
					if (preg_match("/kategorien/",$value["name"])){
						$this->addTODO("FILE",$value["name"],40);
						$CountKategorienDatei++;		
					}
				
					// Artikel
					if (preg_match("/artikel/",$value["name"])){
						$this->addTODO("FILE",$value["name"],10);
						$CountArtikelDatei++;						
					}
					
					// Auftragstati
					if (preg_match("/auftraege/",$value["name"])){
						$this->addTODO("FILE",$value["name"],10);
						$CountAuftragstatuDatei++;						
					}
					
					// Kunden
					if (preg_match("/kunden/",$value["name"])){
						$this->addTODO("FILE",$value["name"],20);
						$CountKundenDatei++;
					}
					
					// Loeschen
					if (preg_match("/loeschen/",$value["name"])){
						$this->addTODO("FILE",$value["name"],-1);
						$CountLoeschDatei++;
					}
				}
				$this->setStatus("Anzahl Herstellerdateien: " . $CountHerstellerDatei);
				$this->setStatus("Anzahl Artikeldateien: " . $CountArtikelDatei);
				$this->setStatus("Anzahl Kundendateien: " . $CountKundenDatei);
				$this->setStatus("Anzahl Kategoriendateien: " . $CountKategorienDatei);
				$this->setStatus("Anzahl Loeschdateien: " . $CountKategorienDatei);
				$this->setStatus("Anzahl Auftragstati: " . $CountAuftragstatuDatei);
			}
			
			// Weitere TODOS erstellen
			if ($this->Config->get("xstar_syncmercator_bestellexport_separat") != 1){$this->addTODO("ORDER_EXPORT", "1",1);}
			$this->addTODO("ADDON", "addVarianten",900);
			$this->addTODO("ADDON", "sortVarianten",901);
			$this->addTODO("ADDON", "checkKategorien",902);
			$this->addTODO("ADDON", "sortKategorien",903);
			$this->addTODO("ADDON", "checkKundengruppen",904);
			$this->addTODO("ADDON", "deleteBildVerzeichnisse",905);
			$this->addTODO("ADDON", "checkImages",906);
			$this->addTODO("ADDON", "checkImagesDuplikate",907);
			$this->addTODO("ADDON", "clearDatabase",908);
			
			// Statusmeldung, dass CRON uebernimmt
			print "<ul style=\"padding-left:50px\">";
			print "<li>Daten wurden gesammelt.</li>";
			print "<li>Cron &uuml;bernimmt nun die Arbeit.</li>";
			print "<li>Sie werden per Email benachrichtigt.</li>";
			print "</ul>";
			exit();
		}
		
		// Infos zeigen
		if (isset($_GET["INFO"])){
			print $HTMLStartkopf;
			
			$sql = "SELECT * 
					FROM syncwawi
					WHERE erledigt = 0 
						AND art <> 'ID' 
					ORDER BY sort, wert";
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				print "<p>&nbsp;</p>";
				print "<p>Folgende Aufgaben m&uuml;ssen noch durchgef&uuml;hrt werden.</p>";
				print "<ul>";
				while (!$rs->EOF){
					if ($rs->fields("in_bearbeitung") == 1){
						print "<li style=\"padding-bottom:10px;\">" . $rs->fields("art") . ": " . $rs->fields("wert") . " <i><span style='color:red;'>(in Bearbeitung)</span></i></li>";
					}else{
						print "<li style=\"padding-bottom:10px;\">" . $rs->fields("art") . ": " . $rs->fields("wert") . "</li>";
					}
					$rs->MoveNext();
				}
				print "</ul>";
			}else{
				print "<p>Keine Aufgaben vorhanden. Laden Sie mit Hilfe Ihrer Warenwirtschaft Dateien hoch und f&uuml;hren den Start Befehl aus.</p>";
			}
			exit();
		}
		
		// Protokoll anzeigen
		if (isset($_GET["PROTOKOLL"])){
			print $HTMLStartkopf;
			
			$sql = "SELECT sync_id 
					FROM syncwawi_log				
					ORDER BY sync_id DESC
					LIMIT 1";
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				$sql = "SELECT * 
						FROM syncwawi_log				
						WHERE sync_id = '" . $rs->fields("sync_id") . "'
						ORDER BY datumuhrzeit";
				print "<p>&nbsp;</p>";
				print "<p>Folgende Aufgaben wurden durchgef&uuml;hrt.</p>";
				print "<ul>";
				$rsspeicher = $this->db->Execute($sql);
				while (!$rsspeicher->EOF){
					print "<li style=\"padding-bottom:10px;\">" . $rsspeicher->fields("datumuhrzeit") . ": " . $rsspeicher->fields("beschreibung") . "</li>";
					$rsspeicher->MoveNext();
				}
				print "</ul>";
			}else{
				print "<p><b>Keine Aufgaben vorhanden.</b></p>";
				print "<p>Laden Sie mit Hilfe Ihrer Warenwirtschaft Dateien auf Ihren Webserver f&uuml;hren den Start Befehl aus ([domain]/admin/sync_mercatro.php?START).</p>";
			}
			exit();
		}

		// Orderexport
		if (isset($_GET["ORDEREXPORT"])){
			$this->OrderExport();	
		}
		
		// Test starten
		if (isset($_GET["TEST"])){

			$filename=$this->PathImport."daten/artikel_178.xml";
			$this->addArtikel($this->readXML($filename));$Status=true;
			
			$filename=$this->PathImport."daten/kategorien_1.xml";
			$this->addKategorien($this->readXML($filename));$Status=true;

			//$this->OrderExport(1117);
			exit();	
		}
		
		// Aufgaben abarbeiten
		if (isset($_GET["TODO"])){						
			// Limit pruefen
			if ($this->Config->get("xstar_syncmercator_limit_gleichzeitige_verbindungen")>0){$limit=$this->Config->get("xstar_syncmercator_limit_gleichzeitige_verbindungen");}else{$limit=2;}
			$sql = "SELECT COUNT(*) AS anzahl
					FROM syncwawi 
					WHERE in_bearbeitung=1";
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				if ($rs->fields("anzahl")>=$limit){exit();}
			}
			
			// Daten verarbeiten
			$sql = "SELECT id, art, wert
					FROM syncwawi 
					WHERE erledigt=0 
						AND in_bearbeitung=0
						AND art<>'ID'
					ORDER BY sort, id";
			if (!isset($_GET["NOBREAK"])){$sql.=" LIMIT 1";}
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				while (!$rs->EOF){
					$Status=false;
					
					require_once ('includes/classes/'.FILENAME_IMAGEMANIPULATOR);
					require_once (DIR_FS_INC.'xtc_get_products_mo_images.inc.php');
				
					// Bearbeitungszustand setzten
					if (strtoupper($rs->fields("art")) != "ADDON"){
						$sql = "UPDATE syncwawi SET in_bearbeitung=1 WHERE id = " . $rs->fields("id");
						$this->db->Execute($sql);
					}
						
					// Los geht es
					switch (strtoupper($rs->fields("art"))){
						case "ORDER_EXPORT":
							$this->OrderExport(); $Status=true;
							break;
						case "DELETEALL":
							$this->delArtikelAll(); $Status=true;
							break;
						case "FILE":
							$TempWert=strtolower($rs->fields("wert"));
							$filename=$this->PathImport."daten/".$rs->fields("wert");
							
							// Artikel
							if (preg_match("/artikel/",$TempWert)){
								$this->addArtikel($this->readXML($filename));$Status=true;
							}
							
							// Auftrag
							if (preg_match("/auftraege/",$TempWert)){
								$this->setAuftragStatus($this->readXML($filename));$Status=true;
							}
							
							// Kategorien
							if (preg_match("/kategorien/",$TempWert)){
								$this->addKategorien($this->readXML($filename));$Status=true;
							}
							
							// Hersteller
							if (preg_match("/hersteller/",$TempWert)){
								$this->addHersteller($this->readXML($filename));$Status=true;
							}
							
							// Lieferanten
							if (preg_match("/lieferanten/",$TempWert)){
								$this->addHersteller($this->readXML($filename));$Status=true;
							}
							
							// Kunden
							if (preg_match("/kunden/",$TempWert)){
								$this->addKunden($this->readXML($filename));$Status=true;
							}
							
							// Loeschen
							if (preg_match("/loeschen/",$TempWert)){
								$this->delArtikel($this->readXML($filename));$Status=true;
							}
							
							$this->deleteXML($filename);
							break;
						case "ADDON":
							$sql = "SELECT COUNT(*) AS anzahl
									FROM syncwawi 
									WHERE art IN ('ORDER_EXPORT','FILE') 
										AND erledigt = 0";
							$rsspeicher = $this->db->Execute($sql);
							if (!$rsspeicher->EOF && $rsspeicher){
								if ($rsspeicher->fields("anzahl")>0){exit();}
							}

							// Bearbeitungszustand setzten
							$sql = "UPDATE syncwawi SET in_bearbeitung=1 WHERE id = " . $rs->fields("id");
							$this->db->Execute($sql);
							
							// Daten verarbeiten
							if ($rs->fields("wert") == "addVarianten"){$this->addVarianten();$Status=true;}
							if ($rs->fields("wert") == "sortVarianten"){$this->sortVarianten();$Status=true;}
							if ($rs->fields("wert") == "checkKategorien"){$this->checkKategorien();$Status=true;}
							if ($rs->fields("wert") == "sortKategorien"){$this->sortKategorien();$Status=true;}
							if ($rs->fields("wert") == "checkKundengruppen"){$this->checkKundengruppen();$Status=true;}
							if ($rs->fields("wert") == "deleteBildVerzeichnisse"){$this->deleteImportImages();$Status=true;}
							if ($rs->fields("wert") == "checkImages"){$this->checkImages();$Status=true;}
							if ($rs->fields("wert") == "checkImagesDuplikate"){$this->checkImagesDuplikate();$Status=true;}
							if ($rs->fields("wert") == "clearDatabase"){$this->clearDatabase();$Status=true;}
							break;
							
					}
					if ($Status == true){
						$sql = "UPDATE syncwawi SET erledigt=1, in_bearbeitung=0 WHERE id = " . $rs->fields("id");
						$this->db->Execute($sql);
					}
					$rs->MoveNext();
				}
			}else{
				$sql = "SELECT COUNT(*) AS anzahl FROM `syncwawi` WHERE erledigt = 0 AND art <> 'ID'";
				$rs = $this->db->Execute($sql);
				if ($rs->fields("anzahl")==0){
					$sql = "SELECT COUNT(*) AS anzahl FROM syncwawi WHERE art='ID'";
					$rs = $this->db->Execute($sql);
					if ($rs->fields("anzahl")>0){
						// Nicht mehr zu tun - Email versenden
						if ($this->Config->get("xstar_syncmercator_bestaetigungsemail") == 1){$this->sendMail();}
					
						// Sync ToDo leeren
						$sql = "DELETE FROM syncwawi";
						$this->db->Execute($sql);
					}
				}
			}
		}
	}
	
	/**
	* Exportiert die benoetigten XML Dateien fuer Mercator
	**/
		function OrderExport($orderid=0){
			$this->setStatus("Bestellungen werden exportiert.","SubHeader");

			// Existiert schon abfragefeld
			$sql = "SELECT sync_date FROM orders LIMIT 1";
			$rs = $this->db->Execute($sql);
			if (!$rs){
				$sql = "ALTER TABLE `orders` ADD `sync_date` DATETIME NULL DEFAULT NULL";
				$this->db->Execute($sql);
			}
		
			// Steuersatz ermitteln
			$sql = "SELECT * FROM " . TABLE_TAX_RATES. " WHERE tax_rates_id = 1";
			$rsspeichertax = $this->db->Execute($sql);
			$TAX=1.19;
			$TAXText="19,00";
			if (!$rsspeichertax->EOF && $rsspeichertax){
				$TAX=("1.".str_replace(".0000","",$rsspeichertax->fields("tax_rate")));
				$TAXText=number_format ($rsspeichertax->fields("tax_rate"), 2 , "." , "");
			}
			
			// Letzten Export ermitteln
			$TempTime = $this->fs->fread($this->TimeFileOrder);
			$ExportDatum = time();
			
			$sql = "SELECT " . TABLE_ORDERS . ".*, 
						" . TABLE_CUSTOMERS . ".customers_gender, 
						" . TABLE_CUSTOMERS . ".customers_newsletter,
						" . TABLE_CUSTOMERS . ".customers_dob
					FROM " . TABLE_ORDERS . " 
					INNER JOIN " . TABLE_CUSTOMERS . " ON " . TABLE_CUSTOMERS . ".customers_id = " . TABLE_ORDERS . ".customers_id "; 
					
			if ($orderid > 0){
				$sql .= "WHERE orders_id = " . $orderid . "";
			}else{
				$sql .= "WHERE sync_date IS NULL";
			}

			// Zaehler ermitteln
			$temp=$this->fs->readDir($this->PathExport."/daten/");
			if (count($temp)>0){
				$TempZaehler=array();
				foreach ($temp as $id => $value){
					array_push($TempZaehler,str_replace(".xml","",str_replace("bestellungen_","",$id)));
				}
				sort($TempZaehler);
				$Zaehler=$TempZaehler[count($TempZaehler)-1]+1;
			}else{
				$Zaehler=1;
			}
			
			$rs=$this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				while (!$rs->EOF){
					$XML ="";
					$XML.="<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
					$XML.="<MERCATOR_OXID>\n";
					$XML.="\t<SHOP_ID>1</SHOP_ID>\n";
				
					$XML.="\t<ORDER>\n";
					$XML.="\t\t<KOPF>\n";
					if (trim($rs->fields("orders_cid"))){
						$XML.=$this->getXMLNode(2,"NUMMER",$rs->fields("orders_cid"));
					}else{
						$XML.=$this->getXMLNode(2,"NUMMER",$rs->fields("orders_id"));
					}
					$XML.=$this->getXMLNode(2,"DATUM",date("d.m.Y",strtotime($rs->fields("date_purchased"))));
					
					$XML.="\t\t\t<KUNDE>\n";
					$XML.=$this->getXMLNode(3,"KD_NR",$rs->fields("customers_id"));
					
					// Kundengruppen ausgeben
					$TempKundengruppe=$this->getKundengruppenNameSchnittstelle($rs->fields("customers_status")); 	
					/*
					$XML.=$this->getXMLNode(3,"PGR",$TempKundengruppe);
					$XML.=$this->getXMLNode(3,"KUNDENGRUPPE",$TempKundengruppe);
					*
					* 07.03.2011: In Schnittstelle Version 1.6 nicht mehr vorhanden
					*/
					
					switch ($rs->fields("customers_gender")){
						case "m":
							$XML.=$this->getXMLNode(3,"ANREDE","Herr");
							break;
						case "w":
							$XML.=$this->getXMLNode(3,"ANREDE","Frau");
							break;
						default:
							$XML.=$this->getXMLNode(3,"ANREDE","Herr");
							break;	
					}
					
					$XML.=$this->getXMLNode(3,"VORNAME",$rs->fields("customers_firstname"));
					$XML.=$this->getXMLNode(3,"NAME1",$rs->fields("customers_lastname"));
					$XML.=$this->getXMLNode(3,"NAME2",$rs->fields("customers_company"));
					$XML.=$this->getXMLNode(3,"STRASSE",$rs->fields("customers_street_address"));
					
					if ($rs->fields("delivery_country_iso_code_2")){
						$XML.=$this->getXMLNode(3,"LKZ",$rs->fields("delivery_country_iso_code_2"));
					}else{
						$XML.=$this->getXMLNode(3,"LKZ","DE");
					}

					$XML.=$this->getXMLNode(3,"PLZ",$rs->fields("customers_postcode"));
					$XML.=$this->getXMLNode(3,"ORT",$rs->fields("customers_city"));
					$XML.=$this->getXMLNode(3,"TEL1",$rs->fields("customers_telephone"));
					$XML.=$this->getXMLNode(3,"TEL2","");
					$XML.=$this->getXMLNode(3,"FAX","");
					$XML.=$this->getXMLNode(3,"EMAIL",$rs->fields("customers_email_address"));
					$XML.=$this->getXMLNode(3,"KTO_INHABER","");
					$XML.=$this->getXMLNode(3,"KTO_KONTO","");
					$XML.=$this->getXMLNode(3,"KTO_BLZ","");
					$XML.=$this->getXMLNode(3,"KTO_BANK","");
					$XML.=$this->getXMLNode(3,"UST_ID",$rs->fields("customers_vat_id"));
					if ($rs->fields("customers_dob")){
						$TempDatum=date("d.m.Y",strtotime($rs->fields("customers_dob")));
						$TempDatumArray=explode(".",$TempDatum);
						if (isset($TempDatumArray[2])){
							if ($TempDatumArray[2]>1900){
								$XML.=$this->getXMLNode(3,"GEB_TAG",$TempDatum);
							}else{
								$XML.=$this->getXMLNode(3,"GEB_TAG","");
							}
						}else{
							$XML.=$this->getXMLNode(3,"GEB_TAG","");
						}
					}else{
						$XML.=$this->getXMLNode(3,"GEB_TAG","");
					}
					
					// Newsletter
					if ($rs->fields("customers_newsletter") == 1){
						$XML.=$this->getXMLNode(3,"NEWSLETTER",1);
					}else{
						$XML.=$this->getXMLNode(3,"NEWSLETTER",0);
					}
					$XML.=$this->getXMLNode(3,"BONITAET","");
					$XML.="\t\t\t</KUNDE>\n";
					
					$XML.="\t\t\t<LIEFERANSCHRIFT>\n";
					
					// Lieferanschift nur ausgeben wenn unterschiedlich	
					if ($rs->fields("customers_firstname") != $rs->fields("delivery_firstname") ||
						$rs->fields("customers_lastname") != $rs->fields("delivery_lastname") ||
						$rs->fields("customers_company") != $rs->fields("delivery_company") ||
						$rs->fields("customers_street_address") != $rs->fields("delivery_street_address") ||
						$rs->fields("customers_state") != $rs->fields("delivery_state") ||
						$rs->fields("customers_postcode") != $rs->fields("delivery_postcode") ||
						$rs->fields("customers_city") != $rs->fields("delivery_city") 
					){
						switch ($rs->fields("customers_gender")){
							case "m":
								$XML.=$this->getXMLNode(3,"LI_ANREDE","Herr");
								break;
							case "w":
								$XML.=$this->getXMLNode(3,"LI_ANREDE","Frau");
								break;
							default:
								$XML.=$this->getXMLNode(3,"LI_ANREDE","Herr");
								break;	
						}
						$XML.=$this->getXMLNode(3,"LI_VORNAME",$rs->fields("delivery_firstname"));
						$XML.=$this->getXMLNode(3,"LI_NAME1",$rs->fields("delivery_lastname"));
						$XML.=$this->getXMLNode(3,"LI_NAME2",$rs->fields("delivery_company"));
						$XML.=$this->getXMLNode(3,"LI_STRASSE",$rs->fields("delivery_street_address"));
						
						// Land ermitteln
						$sql = "SELECT countries_iso_code_2 FROM " . TABLE_COUNTRIES . " WHERE countries_name = '" . $rs->fields("delivery_state") . "'";
						$rsspeicher = $this->db->Execute($sql);
						if (!$rsspeicher->EOF && $rsspeicher){
							$XML.=$this->getXMLNode(3,"LI_LKZ",$rsspeicher->fields("countries_iso_code_2"));
						}else{
							$XML.=$this->getXMLNode(3,"LI_LKZ","DE");
						}

						$XML.=$this->getXMLNode(3,"LI_PLZ",$rs->fields("delivery_postcode"));
						$XML.=$this->getXMLNode(3,"LI_ORT",$rs->fields("delivery_city"));
						$XML.="\t\t\t</LIEFERANSCHRIFT>\n";
					}else{
						$XML.=$this->getXMLNode(3,"LI_ANREDE","");
						$XML.=$this->getXMLNode(3,"LI_VORNAME","");
						$XML.=$this->getXMLNode(3,"LI_NAME1","");
						$XML.=$this->getXMLNode(3,"LI_NAME2","");
						$XML.=$this->getXMLNode(3,"LI_STRASSE","");
						$XML.=$this->getXMLNode(3,"LI_LKZ","");
						$XML.=$this->getXMLNode(3,"LI_PLZ","");
						$XML.=$this->getXMLNode(3,"LI_ORT","");
						$XML.="\t\t\t</LIEFERANSCHRIFT>\n";
					}
					
					$XML.=$this->getXMLNode(2,"MWST_KZ",1); // NETTO Preise
					$XML.=$this->getXMLNode(2,"VERSANDART",$rs->fields("shipping_method"));
					$XML.=$this->getXMLNode(2,"ZAHLART",$rs->fields("payment_method"));
					$XML.=$this->getXMLNode(2,"PGR",$TempKundengruppe); // 07.03.2011: Laut Schnittstelle 1.6 von oben verschoben
					$XML.=$this->getXMLNode(2,"MITTEILUNG",$rs->fields("comments"));
					
					$sql = "SELECT * FROM " . TABLE_ORDERS_TOTAL . " WHERE orders_id = " . $rs->fields("orders_id") . " AND class = 'ot_shipping'";
					$rsspeicher = $this->db->Execute($sql);
					if (!$rsspeicher->EOF && $rsspeicher){
						$sql = "SELECT * FROM " . TABLE_TAX_RATES. " WHERE tax_class_id	= 1";
						$rsspeichertax = $this->db->Execute($sql);
					
						$TempPreis=$rsspeicher->fields("value");
	
						if ($rs->fields("payment_method") == "cod"){ // Nachnahme
							$sql = "SELECT * FROM " . TABLE_ORDERS_TOTAL . " WHERE orders_id = " . $rs->fields("orders_id") . " AND class = 'ot_cod_fee'";
							$rsspeicher = $this->db->Execute($sql);
							if (!$rsspeicher->EOF && $rsspeicher){
								$TempPreis=$TempPreis + $rsspeicher->fields("value");
							}
						}
						
						$XML.=$this->getXMLNode(2,"VERSAND_N",number_format (($TempPreis/$TAX), 2 , "," , ""));
						$XML.=$this->getXMLNode(2,"VERSAND_B",number_format ($TempPreis, 2 , "," , ""));
					}else{
						$XML.=$this->getXMLNode(2,"VERSAND_N","0,00");
						$XML.=$this->getXMLNode(2,"VERSAND_B","0,00");
					}
					$XML.=$this->getXMLNode(2,"RABATT","0");
										
					$XML.="\t\t</KOPF>\n";
									
					$sql = "SELECT * 
							FROM " . TABLE_ORDERS_PRODUCTS . " 
							LEFT JOIN " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " ON (" . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . ".orders_products_id = " . TABLE_ORDERS_PRODUCTS . ".orders_products_id AND " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . ".orders_id = " . TABLE_ORDERS_PRODUCTS . ".orders_id)    
							WHERE " . TABLE_ORDERS_PRODUCTS . ".orders_id = " . $rs->fields("orders_id") . "";
					$rsspeicher = $this->db->Execute($sql);
					if (!$rsspeicher->EOF && $rsspeicher){
						while (!$rsspeicher->EOF){
							$XML.="\t\t<POSITION>\n";
							
							// Wurde ein Kindartikel ausgewaehlt?
							$sql = "SELECT " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . ".products_options_values_id, " . TABLE_PRODUCTS_OPTIONS . ".products_options_id " .  
									"FROM " . TABLE_PRODUCTS_OPTIONS . " " . 
									"INNER JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " ON " . TABLE_PRODUCTS_OPTIONS . ".products_options_id = products_options.products_options_id " .  
									"INNER JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " ON " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . ".products_options_values_id = products_options_values.products_options_values_id " . 
									"WHERE products_options_name = '" . $rsspeicher->fields("products_options") . "' AND products_options_values_name = '" . $rsspeicher->fields("products_options_values") . "'";
							$rsattr = $this->db->Execute($sql);
							if(!$rsattr->EOF && $rsattr){
								$sql = "SELECT * 
										FROM products_attributes 
										WHERE options_id = " . $rsattr->fields("products_options_id") . " AND options_values_id = " . $rsattr->fields("products_options_values_id") . " AND products_id = " . $rsspeicher->fields("products_id") . " ";
								$rsattr = $this->db->Execute($sql);
								if(!$rsattr->EOF && $rsattr){
									$XML.=$this->getXMLNode(2,"ARTCODE",$rsattr->fields("attributes_model"));
									
									// Kindtext holen
									$sql = "SELECT products_name FROM " . TABLE_PRODUCTS . " INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " ON " . TABLE_PRODUCTS . ".products_id = " . TABLE_PRODUCTS_DESCRIPTION . ".products_id WHERE products_model = '" . $rsattr->fields("attributes_model") . "'";
									$rsattr = $this->db->Execute($sql);
									if(!$rsattr->EOF && $rsattr){
										$XML.=$this->getXMLNode(2,"TEXT",$rsattr->fields("products_name"));
									}else{
										$XML.=$this->getXMLNode(2,"TEXT",$rsspeicher->fields("products_name"));
									}
								}else{
									$XML.=$this->getXMLNode(2,"ARTCODE",$rsspeicher->fields("products_model"));
									$XML.=$this->getXMLNode(2,"TEXT",$rsspeicher->fields("products_name"));
								}
							}else{
								$XML.=$this->getXMLNode(2,"ARTCODE",$rsspeicher->fields("products_model"));
								$XML.=$this->getXMLNode(2,"TEXT",$rsspeicher->fields("products_name"));
							}
							$XML.=$this->getXMLNode(2,"LANGTEXT","");
							$XML.=$this->getXMLNode(2,"MENGE",$rsspeicher->fields("products_quantity"));
							
							// Einheit ermitteln
							$sql = "SELECT products_vpe_name 
									FROM " . TABLE_PRODUCTS_VPE . " 
									INNER JOIN " . TABLE_PRODUCTS . " ON " . TABLE_PRODUCTS_VPE . ".products_vpe_id = " . TABLE_PRODUCTS . ".products_vpe 
									WHERE products_id = " . $rsspeicher->fields("products_id") . " AND products_vpe_name > '' ";
							$rseinheit = $this->db->Execute($sql);
							if (!$rseinheit->EOF && $rseinheit){
								$XML.=$this->getXMLNode(2,"EINHEIT",$rseinheit->fields("products_vpe_name"));
							}else{
								$XML.=$this->getXMLNode(2,"EINHEIT",utf8_decode("StĂĽck"));
							}
							
							// Preismenge ermitteln
							$sql = "SELECT * FROM " . TABLE_PRODUCTS  . " WHERE products_id = " . $rsspeicher->fields("products_id");
							$rspe = $this->db->Execute($sql);
							if (!$rspe->EOF && $rspe){
								$XML.=$this->getXMLNode(2,"PREISMENGE",$rspe->fields("products_price_quantity"));
							}else{
								$XML.=$this->getXMLNode(2,"PREISMENGE",1);
							}
							$XML.=$this->getXMLNode(2,"MWST_PROZ",str_replace(".",",",$TAXText));
							$XML.=$this->getXMLNode(2,"EP_NETTO",number_format (($rsspeicher->fields("products_price")/$TAX), 2 , "," , ""));
							$XML.=$this->getXMLNode(2,"EP_BRUTTO",number_format (($rsspeicher->fields("products_price")), 2 , "," , ""));
							$XML.=$this->getXMLNode(2,"POS_RABATT","0");
							$XML.=$this->getXMLNode(2,"GP_NETTO",number_format (($rsspeicher->fields("final_price")/$TAX), 2 , "," , ""));
							$XML.=$this->getXMLNode(2,"GP_BRUTTO",number_format (($rsspeicher->fields("final_price")), 2 , "," , ""));
							$XML.="\t\t</POSITION>\n";
							$rsspeicher->MoveNext();
						}
					}
					
					$XML.="\t</ORDER>\n";
					$XML.='</MERCATOR_OXID>';
				
					$filename=$this->PathExport."/daten/bestellungen_" . $Zaehler . ".xml";
					$this->fs->fwrite($filename,$XML);
					$Zaehler++;
					
					// Bestellung aktualisieren
					$sql = "UPDATE orders SET sync_date = now() WHERE " .  $rs->fields("orders_id");
					$this->db->Execute($sql);
					
					$rs->MoveNext();
				}
				// Exporttime schreiben
				$this->fs->fwrite($this->TimeFileOrder,$ExportDatum);
				$this->setStatus("Bestellungen koennen nun per FTP heruntergeladen werden.");
				$this->SendStatusEmail=true;
			}else{
				$this->setStatus("Keine Bestellungen zum exportieren.");
			}
		}
		
	/** 
	* Fuegt einen Artikel hinzu bzw. modifiziert diesen
	*
	* @param String xml
	**/
		function addArtikel($xml){
			$CrossID=0;
			$this->Counts["Artikel"]=0;

			if (count($xml->ARTIKEL) > 0){						
				//Crossselling Gruppe anlegen, wenn nicht schon erledigt
				$sql = "SELECT * FROM " . TABLE_PRODUCTS_XSELL_GROUPS . " WHERE groupname = 'Mercator'";
				$rs = $this->db->Execute($sql);
				if (!$rs->EOF && $rs){
					$CrossID=$rs->fields("products_xsell_grp_name_id");	
				}else{
					$Mapping=array();
					//Mapping["products_xsell_grp_name_id"]=
					$Mapping["xsell_sort_order"]=0;
					$Mapping["language_id"]=$this->getSprachenID("d");
					$Mapping["groupname"]="Mercator";
					
					$sql = $this->db->GetInsertSQL($rs,$Mapping);
					$this->db->Execute($sql);
					
					// Nummer ermitteln
					$sql = "SELECT * FROM " . TABLE_PRODUCTS_XSELL_GROUPS . " WHERE groupname = 'Mercator'";
					$rs = $this->db->Execute($sql);
					if (!$rs->EOF && $rs){
						$CrossID=$rs->fields("products_xsell_grp_name_id");	
					}
				}
								
				// Artikel anlegen
				$this->setStatus("Artikel werden angelegt bzw. modifiziert.");
				foreach ($xml->ARTIKEL as $id => $value){
					$this->Counts["Artikel"]++;
					
					// MWST
					$Temp=explode(",",$value->MWST);
					if(strlen($Temp[0]) == 1){
						$TAX = "1.0" . $Temp[0];
					}else{
						$TAX = "1." . $Temp[0];
					}
					
					// Mapping erzeugen
					$Mapping=array();
					//$Mapping["products_id"]=(string)$value->ARTCODE;  --> Wird automatisch vergeben
					$Mapping["products_ean"]=(string)$value->EAN;
					$Mapping["products_quantity"]=(string)$value->BESTAND;
					$Mapping["products_shippingtime"]="";
					$Mapping["products_model"]=(string)$value->ARTCODE;
					$Mapping["group_permission_0"]=0;
					$Mapping["group_permission_1"]=0;
					$Mapping["group_permission_2"]=0;
					$Mapping["group_permission_3"]=0;
					$Mapping["products_sort"]=0;
					//$Mapping["products_image"]=""; --> Wird unten nochmal gesetzt
					$Mapping["products_price"]=(str_replace(",",".",(string)$value->PREIS) / $TAX);
					//$Mapping["products_price"]=(str_replace(",",".",(string)$value->PREIS)); // Laut Schnittstelle wird entsprechend geliefert als Netto
					$Mapping["products_discount_allowed"]="";
					$Mapping["products_date_added"]=date("d.m.Y",time());
					$Mapping["products_last_modified"]=date("d.m.Y",time());
					$Mapping["products_date_available"]="";
					$Mapping["products_weight"]=(string)$value->GEWICHT;
					
					if ($value->AKTIV == 1){
						$Mapping["products_status"]=1; // Artikel wird angezeigt;
					}else{
						$Mapping["products_status"]=0; // Artikel wird nicht angezeigt;
					}
					
					$Mapping["products_tax_class_id"]=$this->getMWSTID((string)$value->MWST);
					$Mapping["product_template"]="default";
					$Mapping["options_template"]="product_options_dropdown.html";
					$Mapping["manufacturers_id"]=$this->getHerstellerID($value->HERSTELLER);
					$Mapping["products_ordered"]=(string)$value->BESTAND;
					$Mapping["products_fsk18"]=0;
					$Mapping["products_price_quantity"]=(string)$value->PREISMENGE;
					
					// VPE anlegen
					$sql = "SELECT products_vpe_id FROM " . TABLE_PRODUCTS_VPE . " WHERE products_vpe_name = '" . $this->ConvertText2DB((string)$value->SPRACHDATEN->EINHEIT) . "'";
					$rs = $this->db->Execute($sql);
					if (!$rs->EOF && $rs){}else{
							$sql = "SELECT MAX(products_vpe_id) anzahl FROM " . TABLE_PRODUCTS_VPE . "";
							$rs = $this->db->Execute($sql);
					
							if ($rs->fields("anzahl") > 0){$TempAnzahl=$rs->fields("anzahl")+1;}else{$TempAnzahl=1;}
							$sql = "INSERT INTO " . TABLE_PRODUCTS_VPE . " (products_vpe_id	, language_id, products_vpe_name) VALUES (" . $TempAnzahl . "," . $this->getSprachenID("d") . ",'" . $this->ConvertText2DB((string)$value->SPRACHDATEN->EINHEIT) . "')";
							$this->db->Execute($sql);
							
							$sql = "SELECT products_vpe_id	 FROM " . TABLE_PRODUCTS_VPE . " WHERE products_vpe_name = '" . $this->ConvertText2DB((string)$value->SPRACHDATEN->EINHEIT) . "'";
							$rs = $this->db->Execute($sql);
					}
					
					$Mapping["products_vpe"]=$rs->fields("products_vpe_id");
					$Mapping["products_vpe_status"]=1;
					
					// Modul Mindestbestellmengen installiert?
					if ($this->ModulMindesbestellmenge == true){
						$Mapping["products_vpe_value"]=0;
						$Mapping["products_min_quantity"]=(string)$value->SPEZIAL->VPE_MENGE;
						$Mapping["products_min_quantity_value"]=$rs->fields("products_vpe_id");
					}else{
						$Mapping["products_vpe_value"]=(string)$value->SPEZIAL->VPE_MENGE;
					}
					
					// Artikel auf Auslauf??
					if ($value->AUSLAUF == 1){
						$Mapping["products_vpe"]=-1;
					}
					
					$Mapping["products_startpage"]=0;
					$Mapping["products_startpage_sort"]=0;
					$Mapping["products_valid_from"]=NULL;
					$Mapping["products_valid_to"]=NULL;
					
					$sql = "SELECT * FROM " . TABLE_PRODUCTS . " WHERE products_model = '" . $Mapping["products_model"] . "'";
					$rs = $this->db->Execute($sql);
					if (!$rs->EOF && $rs){
						$sql = $this->db->GetUpdateSQL($rs,$Mapping);
					}else{
						$sql = $this->db->GetInsertSQL($rs,$Mapping);
					}
					if ($sql){$this->db->Execute($sql);}
					
					// Kindartikel
					if ((string)$value->VARIANTEN->VAR_VATER){
						// Normale Speicherung
						$this->ArtikelKind[(string)$value->ARTCODE]["vater"]=(string)$value->VARIANTEN->VAR_VATER;
						$this->ArtikelKind[(string)$value->ARTCODE]["text"]=(string)$value->VARIANTEN->VAR_TEXT;
						
						// Spezielle Speicherung in Session
						$_SESSION["ArtikelKind"][(string)$value->ARTCODE]["vater"]=(string)$value->VARIANTEN->VAR_VATER;
						$_SESSION["ArtikelKind"][(string)$value->ARTCODE]["text"]=(string)$value->VARIANTEN->VAR_TEXT;
					}

					// XTC Artikelnummern ermitteln
					$sql = "SELECT products_id FROM " . TABLE_PRODUCTS . " WHERE products_model = '" . $Mapping["products_model"] . "'";
					$rs = $this->db->Execute($sql);
					$Artikelnummer=0;
					if (!$rs->EOF && $rs){
						$Artikelnummer=$rs->fields("products_id");
					}
					
					// weitere Attribute
					foreach ($value->SPRACHDATEN->ATTRIBUT as $sprachkey => $sprachvalue){
						$TempBezeichnung=(string)$sprachvalue->NAME;
						$TempWert=(string)$sprachvalue->INHALT;
						$TempSort=(string)$sprachvalue->POS;
						
						// Attribut gegeben falls anlegen
						$sql = "SELECT products_options_id FROM " . TABLE_PRODUCTS_OPTIONS . " WHERE products_options_name = '" . $TempBezeichnung . "'";
						$rs = $this->db->Execute($sql);
						if ($rs->EOF){
							$sql = "SELECT max(products_options_id) as id FROM " . TABLE_PRODUCTS_OPTIONS . "";
							$rs = $this->db->Execute($sql);
							
							$sql = "INSERT INTO " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, products_options_name, language_id) 
									VALUES (" . ($rs->fields("id")+1) . ",'" . $TempBezeichnung . "',2)";
							$this->db->Execute($sql);
							
							$sql = "SELECT products_options_id FROM " . TABLE_PRODUCTS_OPTIONS . " WHERE products_options_name = '" . $TempBezeichnung . "'";
							$rs = $this->db->Execute($sql);
							$TempPO_ID=$rs->fields("products_options_id");
						}else{
							$TempPO_ID=$rs->fields("products_options_id");
						}
						
						// Wert anlegen, wenn noch nicht vorhanden
						$sql = "SELECT products_options_values_id FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . " WHERE products_options_values_name = '" . $TempWert . "'";
						$rs = $this->db->Execute($sql);
						if ($rs->EOF){
							$sql = "SELECT max(products_options_values_id) as id FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . "";
							$rs = $this->db->Execute($sql);
						
							$sql = "INSERT INTO " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, products_options_values_name, language_id) 
									VALUES (" . ($rs->fields("id")+1) . ",'" . $TempWert . "',2)";
							$this->db->Execute($sql);
							
							$sql = "SELECT products_options_values_id FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . " WHERE products_options_values_name = '" . $TempWert . "'";
							$rs = $this->db->Execute($sql);
							$TempPOV_ID=$rs->fields("products_options_values_id");
						}else{
							$TempPOV_ID=$rs->fields("products_options_values_id");
						}
						
						// Attributszuweisung durchfuehren
						$sql = "SELECT * FROM products_options_values_to_products_options 
								WHERE products_options_id = " . $TempPO_ID . " 	
									AND products_options_values_id = " . $TempPOV_ID . "";
						$rs = $this->db->Execute($sql);
						if ($rs->EOF){
							$sql = "INSERT INTO products_options_values_to_products_options (products_options_id,products_options_values_id) 
									VALUES (" . $TempPO_ID . "," . $TempPOV_ID . ")";
							$this->db->Execute($sql);
						}
						
						// Artikelzuweisung
						$sql = "INSERT INTO products_attributes (
											products_id,
											options_id,
											options_values_id,
											options_values_price,
											price_prefix,
											attributes_model,
											attributes_stock,
											options_values_weight,
											weight_prefix,
											sortorder,
											products_shippingtime)
								VALUES (" . $Artikelnummer . ",
											" . $TempPO_ID . ",
											" . $TempPOV_ID . ",
											0,
											'+',
											'',
											0,
											0,
											'+',
											" . $TempSort . ",
											0)";
						$this->db->Execute($sql);
					}
					
					// Kinderschutzinfo / Warnhinweise
					if (isset($value->SPRACHDATEN->DOKTITEL1) || isset($value->SPRACHDATEN->DOKTITEL2) || isset($value->SPRACHDATEN->DOKTITEL3)){
						// Tabelle erstellen, wenn noch nicht vorhanden
						$sql = "CREATE TABLE IF NOT EXISTS temp_xtc_warnhinweise (
								  products_id int(11) NOT NULL,
								  doktitel1 varchar(255) NOT NULL,
								  doktitel2 varchar(255) NOT NULL,
								  doktitel3 varchar(255) NOT NULL
								)";
						$this->db->Execute($sql);
						
						// Daten speichern
						$TempDaten=array();
						$TempDaten["products_id"]=$Artikelnummer;
						$TempDaten["doktitel1"]=utf8_decode($value->SPRACHDATEN->DOKTITEL1);
						$TempDaten["doktitel2"]=utf8_decode($value->SPRACHDATEN->DOKTITEL2);
						$TempDaten["doktitel3"]=utf8_decode($value->SPRACHDATEN->DOKTITEL3);
						
						$sql = "SELECT * FROM temp_xtc_warnhinweise WHERE products_id = " . $Artikelnummer;
						$rs = $this->db->Execute($sql);
						if (!$rs->EOF && $rs){
							$sql = $this->db->GetUpdateSQL($rs,$TempDaten);
						}else{
							$sql = $this->db->GetInsertSQL($rs,$TempDaten); 
						}
						if ($sql){$this->db->Execute($sql);}
					}
					
					// Cross Selling Product
					if (isset($value->CROSS_SELLER->CS)){
						foreach ($value->CROSS_SELLER->CS as $crosskey => $crossvalue){
							$sql = "SELECT products_id FROM " . TABLE_PRODUCTS . " WHERE products_model = '" . $crossvalue . "'";
							$rs = $this->db->Execute($sql);
							if (!$rs->EOF && $rs){
								$CrossArtikelnummer=$rs->fields("products_id");
								$sql = "SELECT * FROM " . TABLE_PRODUCTS_XSELL . " WHERE products_id = " .$CrossArtikelnummer . " AND xsell_id = " . $Artikelnummer . " AND products_xsell_grp_name_id = " . $CrossID . "";
								$rs = $this->db->Execute($sql);
								if (!$rs->EOF && $rs){
									// OK - schon vorhanden
								}else{
									$Mapping=array();
									$Mapping["products_id"]=$CrossArtikelnummer;
									$Mapping["products_xsell_grp_name_id"]=$CrossID;
									$Mapping["xsell_id"]=$Artikelnummer;
									$Mapping["sort_order"]=0;
									
									$sql = "SELECT * FROM " . TABLE_PRODUCTS_XSELL . " ";
									$rs = $this->db->Execute($sql);
									$sql = $this->db->GetInsertSQL($rs,$Mapping);
									if ($sql){$this->db->Execute($sql);}
								}
							}
						}
					}
					// Preisgruppen abbilden
					$PreisgruppenMapping=array();
					for ($i=0 ; $i<=8 ; $i++){$PreisgruppenMapping["VK".$i]="";}
					for ($i=0 ; $i<=8 ; $i++){
						if ($this->Config->get("xstar_syncmercator_pgr_kundengruppe_vk" . $i) > 0){
							$PreisgruppenMapping["VK".$i]=$this->Config->get("xstar_syncmercator_pgr_kundengruppe_vk" . $i);
						}
					}
										
					foreach (get_object_vars($value->SPEZIAL) as $Preisgruppe => $Preis){
						if ($Preis){
							$TempGruppenID=$PreisgruppenMapping[$Preisgruppe];
							if ($TempGruppenID > 0){
								// Preisgruppe und Staffelpreise fuer Artikel leeren
								$sql = "DELETE FROM personal_offers_by_customers_status_" . $TempGruppenID . " WHERE products_id = " . $Artikelnummer;
								$rs = $this->db->Execute($sql);
								
								// Preisgruppe anlegen
								$Mapping=array();
								$Mapping["products_id"]=$Artikelnummer;
								$Mapping["quantity"]=1;
								$Mapping["personal_offer"]=str_replace(",",".",$Preis);
								$sql = "SELECT * FROM personal_offers_by_customers_status_" . $TempGruppenID . " WHERE products_id = " . $Artikelnummer;
								$rs = $this->db->Execute($sql);
								if (!$rs->EOF && $rs){
									$sql = $this->db->GetUpdateSQL($rs,$Mapping);
								}else{
									$sql = $this->db->GetInsertSQL($rs,$Mapping);
								}
								if ($sql){$this->db->Execute($sql);}
							}
						}
					}
					
					// Staffelpreise bei Preisgruppen abbilden
					if (count($value->SPEZIAL->STAFFELPREIS)>0){
						foreach ($value->SPEZIAL->STAFFELPREIS as $staffelpreis => $feld_staffelpreis){
							$TempDaten=get_object_vars($feld_staffelpreis);
							if ($PreisgruppenMapping["VK" . $TempDaten["PGR"]]){
								$TempGruppenID=$PreisgruppenMapping["VK".$TempDaten["PGR"]];
								if ($TempGruppenID > 0){
									$Mapping=array();
									$Mapping["products_id"]=$Artikelnummer;
									$Mapping["quantity"]=$TempDaten["M_AB"];
										
									$StatusStaffelpreis=false;
									if ($TempDaten["PREIS"] > 0){
										$Mapping["personal_offer"]=str_replace(",",".",$TempDaten["PREIS"]);
										$StatusStaffelpreis=true;
									}
										
									if ($TempDaten["RABATT"] > 0){
										$sql = "SELECT * FROM personal_offers_by_customers_status_" . $TempGruppenID . " WHERE products_id = " . $Artikelnummer . " AND quantity = 1";
										$rs = $this->db->Execute($sql);
										if (!$rs->EOF && $rs){
											$TempPreis=str_replace(",",".",$rs->fields("personal_offer"));
											$TempPreis=(100-($TempDaten["RABATT"]))*$TempPreis/100;
											$Mapping["personal_offer"]=$TempPreis;
											$StatusStaffelpreis=true;		
										}
									}
										
									// Preis oder Rabatt vorhanden vorhanden, dann anlegen
									if ($StatusStaffelpreis){
										$sql = "SELECT * FROM personal_offers_by_customers_status_" . $TempGruppenID . " WHERE products_id = " . $Artikelnummer . " AND quantity = " . $Mapping["quantity"];
										$rs = $this->db->Execute($sql);
										if (!$rs->EOF && $rs){
											$sql = $this->db->GetUpdateSQL($rs,$Mapping);
										}else{
											$sql = $this->db->GetInsertSQL($rs,$Mapping);
										}
										if ($sql){$this->db->Execute($sql);}
									}
								}
							}
						}
					}
					
					// Product zur Kategorie zuordnen
					if (count($value->KATEGORIE) > 0){
						foreach ($value->KATEGORIE as $id1 => $value1){
							$Mapping=array();
							$Mapping["products_id"]=$Artikelnummer;
							if ((string)$value->VARIANTEN->VAR_VATER){
								$Mapping["categories_id"]=-1;
							}else{
								$Mapping["categories_id"]=$this->changeKategorienID((string)$value1->KAT_ID);
							}
							
							$sql = "SELECT * FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE products_id = " . $Artikelnummer . " AND categories_id = " . $Mapping["categories_id"];
							$rs = $this->db->Execute($sql);
							if (!$rs->EOF && $rs){
								$sql = "SELECT count(*) AS anzahl FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE products_id = " . $Artikelnummer . "";
								$rsspeicher = $this->db->Execute($sql);
								if ($rsspeicher->fields("anzahl") == 1){
									$sql = $this->db->GetUpdateSQL($rs,$Mapping);
								}
							}else{
								$sql = "SELECT * FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE products_id = " . $Artikelnummer . "";
								$rs = $this->db->Execute($sql);
								if (!$rs->EOF && $rs){
									$sql = "SELECT count(*) AS anzahl FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE products_id = " . $Artikelnummer . "";
									$rsspeicher = $this->db->Execute($sql);
									if ($rsspeicher->fields("anzahl") == 1){
										$sql = $this->db->GetUpdateSQL($rs,$Mapping);
									}
								}else{
									$sql = $this->db->GetInsertSQL($rs,$Mapping);
								}
							}
							if ($sql){$this->db->Execute($sql);}
						}
					}else{
						$Mapping=array();
						$Mapping["products_id"]=$Artikelnummer;
						if ((string)$value->VARIANTEN->VAR_VATER){
								$Mapping["categories_id"]=-1;
						}else{
							$Mapping["categories_id"]=1;
						}
							
						$sql = "SELECT * FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE products_id = " . $Artikelnummer . "";
						$rs = $this->db->Execute($sql);
						if (!$rs->EOF && $rs){
							$sql = $this->db->GetUpdateSQL($rs,$Mapping);
						}else{
							$sql = $this->db->GetInsertSQL($rs,$Mapping);
						}
						if ($sql){$this->db->Execute($sql);}
					}
					
					// Langtexte vorhanden?
					if (count($value->SPRACHDATEN) > 0){
						foreach ($value->SPRACHDATEN as $id1 => $value1){
							if($this->getSprachenID($value1->SPRACH_KZ)>0){
								$Mapping=array();
								$Mapping["products_id"]=$Artikelnummer;
								$Mapping["language_id"]=$this->getSprachenID($value1->SPRACH_KZ);
								$Mapping["products_name"]=$this->ConvertText2DB((string)$value1->TEXT . " (" . (string)$value->HERSTELLER->ART_NR . ")");
								$Mapping["products_description"]=$this->ConvertText2DB((string)$value1->LANGTEXT);
								if ((string)$value1->LANGTEXT_2){
									if ($this->Config->get("xstar_syncmercator_langtext2_leerzeile_langtext1") == 1){
										$Mapping["products_description"].="<br><br>".$this->ConvertText2DB((string)$value1->LANGTEXT_2);	
									}else{
										$Mapping["products_description"].="<br>".$this->ConvertText2DB((string)$value1->LANGTEXT_2);
									}
									$Mapping["products_short_description"]=$this->ConvertText2DB((string)$value1->LANGTEXT_2 . (string)$value1->ZUSATZ . (string)$value1->ZUSATZ_OPT);
								}else{
									$Mapping["products_short_description"]=$this->ConvertText2DB((string)$value1->ZUSATZ . (string)$value1->ZUSATZ_OPT);
								}
								$Mapping["products_keywords"]=(string)$value->ARTCODE . " " . (string)$value1->SUCHBEGRIFFE;
								
								//SEO vorhanden?
								if (count($value->SEO)){
									$Mapping["products_meta_title"]=(string)$value->SEO->TITLE;
									$Mapping["products_meta_description"]=(string)$value->SEO->DESCR;
									$Mapping["products_meta_keywords"]=(string)$value->SEO->KEYW;
									$Mapping["products_url"]="";
									$Mapping["products_viewed"]=0;
								}
								
								$sql = "SELECT * FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = " . $Artikelnummer . " AND language_id = " . $this->getSprachenID($value1->SPRACH_KZ);
								$rs = $this->db->Execute($sql);
								if (!$rs->EOF && $rs){
									$sql = $this->db->GetUpdateSQL($rs,$Mapping);
								}else{
									$sql = $this->db->GetInsertSQL($rs,$Mapping);
								}
								if ($sql){$this->db->Execute($sql);}
							}
						}
					}else{
						// Leeren Langtext anlegen
						$Mapping=array();
						$Mapping["products_id"]=$Artikelnummer;
						$Mapping["language_id"]=$this->getSprachenID("D");
						$Mapping["products_name"]=(string)$value->ARTCODE;
						$Mapping["products_description"]="";
						$Mapping["products_short_description"]="";
						$Mapping["products_keywords"]=(string)$value->ARTCODE;
							
						$sql = "SELECT * FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = " . $Artikelnummer;
						$rs = $this->db->Execute($sql);
						if (!$rs->EOF && $rs){
							$sql = $this->db->GetUpdateSQL($rs,$Mapping);
						}else{
							$sql = $this->db->GetInsertSQL($rs,$Mapping);
						}
						if ($sql){$this->db->Execute($sql);}
					}
					
					// Attriute vorhanden?
					if ((string)$value->SPRACHDATEN->ATTRIBUT){
						foreach ($value->SPRACHDATEN->ATTRIBUT as $attribute => $werte){
							$TempOption=trim((string)$werte->NAME);
							$TempOptionValue=trim((string)$werte->INHALT);
							$TempOptionSort=trim((string)$werte->POS);

							// existiert Option?
							$sql = "SELECT products_options_id, products_options_name
									FROM products_options 
									WHERE products_options_name = '" . $TempOption . "'
										AND language_id = 2";
							$rsspeicher = $this->db->Execute($sql);
							if ($rsspeicher->EOF){
								$sql = "SELECT MAX(products_options_id)+1 AS anzahl FROM products_options";
								$rsspeicher = $this->db->Execute($sql);
								$TempOptionsID = $rsspeicher->fields("anzahl");
								
								// Option anlegen
								if ($TempOptionsID > 0){
									$sql = "INSERT INTO products_options (products_options_id, language_id, products_options_name)
											VALUES (" . $TempOptionsID . ",2,'" . $TempOption . "')";
									$this->db->Execute($sql);
								}
							}else{
								$TempOptionsID = $rsspeicher->fields("products_options_id");
							}
							
							// existiert Options Value?
							$sql = "SELECT pv.products_options_values_id
									FROM products_options_values pv
									INNER JOIN products_options_values_to_products_options pvo ON pv.products_options_values_id = pvo.products_options_values_id
									WHERE products_options_id = " . $TempOptionsID . "
										AND products_options_values_name = '" . $TempOptionValue . "'";
							$rsspeicher = $this->db->Execute($sql);
							if ($rsspeicher->EOF){
								$sql = "SELECT MAX(products_options_values_id)+1 AS anzahl FROM products_options_values";
								$rsspeicher = $this->db->Execute($sql);
								$TempOptionsID = $rsspeicher->fields("anzahl");
								
								if ($TempOptionsID > 0){
									// Option Value anlegen
									$sql = "INSERT INTO products_options_values (products_options_values, language_id, products_options_values_name)
											VALUES (" . $TempOptionsValueID . ",2,'" . $TempOptionValue . "')";
									$this->db->Execute($sql);
									
									// Beziehung herstellen
									$sql = "INSERT INTO products_options_values_to_products_options (products_options_id, products_options_values_id)
											VALUES (" . $TempOptionsID . "," . $TempOptionValueID . ")";
									$this->db->Execute($sql);
								}
							}else{
								$TempOptionValueID=$rsspeicher->fields("products_options_values_id");
							}
							
							// Attribut anlegen
							if ($TempOptionsID > 0 && $TempOptionValueID > 0){
								$sql = "INSERT INTO products_attributes (products_id, options_id, options_values_id, sortorder)
										VALUES ('" . $Artikelnummer . "', '" . $TempOptionsID . "', '" . $TempOptionValueID . "', '" . $TempOptionSort . "')";
								$this->db->Execute($sql);
							}
						}
					}
					
					// Produktfilter erzeugen
					$PF = new ProduktFilter($Artikelnummer);
					$PF->setBezeichnungKurz($Artikelnummer);
					
					// Bilder vorhanden?
					$BildVerzeichnisse=array("original_images","info_images","popup_images","thumbnail_images");
					
					if ((string)$value->BILD_01){
						$filename=$this->PathImport."bilder/" . (string)$value->BILD_01;
						if (file_exists($filename)){							
							foreach ($BildVerzeichnisse as $id1 => $bildpath){
								$filename_neu=DIR_FS_DOCUMENT_ROOT."/images/product_images/" . $bildpath . "/" . $Artikelnummer . "_0.jpg";
								$products_image_name = $Artikelnummer . "_0.jpg";
								
								// Pruefen ob Datei unterschiedlich bzw. existiert
								if (!file_exists($filename_neu)){
									copy ($filename, $filename_neu);
								
									if ($bildpath != "original_images"){
										require (DIR_WS_INCLUDES.'product_' . $bildpath . '.php');
										$sql = "UPDATE " . TABLE_PRODUCTS . " SET products_image = '" . $products_image_name . "' WHERE products_id = " . $Artikelnummer;
										$this->db->Execute($sql);
									}									
								}else{
									$MD5_1=hash_file('md5', $filename);
									$MD5_2=hash_file('md5', $filename_neu);
									if ($MD5_1 != $MD5_2){
										copy ($filename, $filename_neu);
									
										if ($bildpath != "original_images"){
											require (DIR_WS_INCLUDES.'product_' . $bildpath . '.php');
											$sql = "UPDATE " . TABLE_PRODUCTS . " SET products_image = '" . $products_image_name . "' WHERE products_id = " . $Artikelnummer;
											$this->db->Execute($sql);
										}
									}
								}
							}
							// Bild loeschen, wenn alles erledigt
							if ($this->Config->get("xstar_syncmercator_importbilder_loeschen")!=1){
								unlink($filename);
							}
						}
					}
					
					// Weitere Bilder hinterlegt?
					foreach (get_object_vars($value) as $feld => $wert){
						if (substr($feld,0,4) == "BILD"){
							$filename=$this->PathImport."bilder/" . $wert;
							if (file_exists($filename)){
								$BildID=str_replace("BILD_","",$feld)-1;
								if ($BildID > 0){
									foreach ($BildVerzeichnisse as $id1 => $bildpath){
										$filename_neu=DIR_FS_DOCUMENT_ROOT."/images/product_images/" . $bildpath . "/" . $Artikelnummer . "_" . $BildID. ".jpg";
										$products_image_name = $Artikelnummer . "_" . $BildID . ".jpg";
	
										// Pruefen ob Datei unterschiedlich
										if (!file_exists($filename_neu)){
											copy ($filename, $filename_neu);
											
											if ($bildpath != "original_images"){
												require (DIR_WS_INCLUDES.'product_' . $bildpath . '.php');
											}
										}else{
											$MD5_1=hash_file('md5', $filename);
											$MD5_2=hash_file('md5', $filename_neu);
											if ($MD5_1 != $MD5_2){
												copy ($filename, $filename_neu);
												
												if ($bildpath != "original_images"){
													require (DIR_WS_INCLUDES.'product_' . $bildpath . '.php');
												}
											}
										}
									
										// Bild zum Artikel speichern
										$Mapping=array();
										$Mapping["products_id"]=$Artikelnummer;
										$Mapping["image_nr"]=$BildID;
										$Mapping["image_name"]=$products_image_name;
												
										$sql = "SELECT * FROM " . TABLE_PRODUCTS_IMAGES . " WHERE products_id = " . $Artikelnummer . " AND image_nr = " . $BildID;
										$rs = $this->db->Execute($sql);
										if (!$rs->EOF && $rs){
											$sql = $this->db->GetUpdateSQL($rs,$Mapping,true);
										}else{
											$sql = $this->db->GetInsertSQL($rs,$Mapping);
										}
										if ($sql){$this->db->Execute($sql);}
									}
									// Bild loeschen, wenn alles erledigt
									if ($this->Config->get("xstar_syncmercator_importbilder_loeschen")!=1){
										unlink($filename);
									}
								}
							}	
						}
					}
					
					// Bildduplikate entfernen
					$this->checkImagesDuplikate($Artikelnummer);
				}
			}else{
				$this->showMeldung(0,3);
			}
		}
		
	/**
	* Loescht einen Artikel aus dem Artikelstamm
	*
	* @param String xml
	**/		
		function delArtikel($xml){
			if (count($xml->LOESCHEN) > 0){
				$this->setStatus("Artikel werden gel&ouml;scht.");
				foreach ($xml->LOESCHEN as $id => $value){
					// Artikelnummer ermitteln
					$sql = "SELECT products_id, products_model FROM " . TABLE_PRODUCTS . " WHERE products_model = '" . $value . "'";
					$rs = $this->db->Execute($sql);
					if (!$rs->EOF && $rs){
						
						$Artikelnummer=$rs->fields("products_id");
						$sql = "DELETE FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = " . $Artikelnummer;
						$this->db->Execute($sql);
						
						$sql = "DELETE FROM " . TABLE_PRODUCTS_ATTRIBUTES . " WHERE products_id = " . $Artikelnummer;
						$this->db->Execute($sql);
						
						$sql = "DELETE FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE products_id = " . $Artikelnummer;
						$this->db->Execute($sql);
						
						$sql = "DELETE FROM products_kurzebezeichnungen WHERE products_id NOT IN (SELECT products_id FROM products)";
						$this->db->Execute($sql);
						
						$sql = "DELETE FROM " . TABLE_PRODUCTS . " WHERE products_id = " . $Artikelnummer;
						$this->db->Execute($sql);						
					}
				}
			}
		}

	/** 
	 * Loescht alle Artikel
	 */
		function delArtikelAll(){
			$sql = "DELETE FROM " . TABLE_CATEGORIES_DESCRIPTION . "";
			$this->db->Execute($sql);
			
			$sql = "DELETE FROM " . TABLE_CATEGORIES . "";
			$this->db->Execute($sql);
			
			$sql = "DELETE FROM " . TABLE_PRODUCTS_DESCRIPTION . "";
			$this->db->Execute($sql);
						
			$sql = "DELETE FROM " . TABLE_PRODUCTS_ATTRIBUTES . "";
			$this->db->Execute($sql);
				
			$sql = "DELETE FROM " . TABLE_PRODUCTS_TO_CATEGORIES . "";
			$this->db->Execute($sql);
						
			$sql = "DELETE FROM " . TABLE_PRODUCTS . "";
			$this->db->Execute($sql);			
		}
		
		
	/**
	 * Bereinigt die Datenbank
	 */
		function clearDatabase(){
			$sql = "DELETE FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id NOT IN (SELECT products_id FROM " . TABLE_PRODUCTS . ")";
			$this->db->Execute($sql);
			
			$sql = "DELETE FROM " . TABLE_PRODUCTS_ATTRIBUTES . " WHERE products_id NOT IN (SELECT products_id FROM " . TABLE_PRODUCTS . ")";
			$this->db->Execute($sql);
			
			$sql = "DELETE FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE products_id NOT IN (SELECT products_id FROM " . TABLE_PRODUCTS . ")";
			$this->db->Execute($sql);
			
			$sql = "DELETE FROM products_kurzebezeichnungen WHERE products_id NOT IN (SELECT products_id FROM products)";
			$this->db->Execute($sql);
		}
		
	/**
	 * Erzeugt basierend auf Kinderartikel Attribute
	 */
		function addVarianten(){
			$this->setStatus("Varianten werden erzeugt.");
			
			// Pruefen, ob Variante Gruppe Allgemein vorhanden ist
			$sql = "SELECT * FROM " . TABLE_PRODUCTS_OPTIONS . " WHERE products_options_name = 'Allgemein'";
			$rs = $this->db->Execute($sql);
			if ($rs->EOF){
				$sql = "INSERT INTO " . TABLE_PRODUCTS_OPTIONS . " (products_options_name, language_id 	) VALUES ('Allgemein',2)";
				$this->db->Execute($sql);
				
				$sql = "SELECT * FROM " . TABLE_PRODUCTS_OPTIONS . " WHERE products_options_name = 'Allgemein'";
				$rs = $this->db->Execute($sql);
			}
			$GruppenID=$rs->fields("products_options_id");
			
			$this->ArtikelKind=$_SESSION["ArtikelKind"];

			// Attribute anlegen
			if (count($this->ArtikelKind) > 0){
				foreach ($this->ArtikelKind as $id => $value){
					$sql = "SELECT * FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . " WHERE products_options_values_name = '" . $this->ConvertText2DB($value["text"]) . "'";
					$rs = $this->db->Execute($sql);
					if ($rs->EOF){
						$sql = "SELECT MAX(products_options_values_id) as products_options_values_id FROM " . TABLE_PRODUCTS_OPTIONS_VALUES;
						$rsspeicher = $this->db->Execute($sql);
						$products_options_values_id=$rsspeicher->fields("products_options_values_id")+1;
						
						$sql = "INSERT INTO " . TABLE_PRODUCTS_OPTIONS_VALUES  . " (products_options_values_id, language_id, products_options_values_name ) VALUES (" . $products_options_values_id . ",2,'" . $this->ConvertText2DB($value["text"]) .  "')";
						$this->db->Execute($sql);
						
						$sql = "SELECT * FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . " WHERE products_options_values_name = '" . $this->ConvertText2DB($value["text"]) . "'";
						$rs = $this->db->Execute($sql);
						$VariantenID=$rs->fields("products_options_values_id");
						
						$sql = "INSERT INTO " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " (products_options_id ,products_options_values_id) VALUES (" . $GruppenID . "," . $VariantenID . ")";
						$this->db->Execute($sql);
					}
				}
			}
			
			// Vaterartikel um Attribute erweitern und Kinder ausblenden
			if (count($this->ArtikelKind) > 0){
				$Vater=array();
				$Kind=array();
				$VariantenID=0;
				
				foreach ($this->ArtikelKind as $id => $value){
					// Daten vom Vater holen
					$sql = "SELECT * FROM " . TABLE_PRODUCTS . " WHERE products_model = '" . $value["vater"] . "'";		
					$rs = $this->db->Execute($sql);
					if (!$rs->EOF && $rs){
						$Vater=$rs->fields;
						
						// Daten vom Kind holen
						$sql = "SELECT * FROM " . TABLE_PRODUCTS . " WHERE products_model = '" . $id . "'";		
						$rs = $this->db->Execute($sql);
						$Kind=$rs->fields;
						
						// Variantennummer holen
						$sql = "SELECT products_options_values_id FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . " WHERE products_options_values_name = '" . $this->ConvertText2DB($value["text"]) . "'";
						$rs = $this->db->Execute($sql);
						$VariantenID=$rs->fields("products_options_values_id");
						
						// Attribut anlegen
						$Mapping=array();
						//$Mapping["products_attributes_id"]="";
						$Mapping["products_id"]=$Vater["products_id"];
						$Mapping["options_id"]=$GruppenID;
						$Mapping["options_values_id"]=$VariantenID;
						
						if ($Vater["products_price"] > $Kind["products_price"]){
							$Mapping["options_values_price"]=$Vater["products_price"] - $Kind["products_price"];
							$Mapping["price_prefix"]="-";
						}else{
							$Mapping["options_values_price"]=$Kind["products_price"] - $Vater["products_price"];
							$Mapping["price_prefix"]="+";
						}
						$Mapping["attributes_model"]=$Kind["products_model"];
						$Mapping["attributes_stock"]=0;
						$Mapping["options_values_weight"]=0.0000;
						$Mapping["weight_prefix"]="+";
						$Mapping["sortorder"]=0;
	
						$sql = "SELECT * FROM " . TABLE_PRODUCTS_ATTRIBUTES . " WHERE products_id = " . $Vater["products_id"] . " AND options_id = " . $GruppenID . " AND options_values_id = " . $VariantenID . "";
						$rs = $this->db->Execute($sql);
						if (!$rs->EOF && $rs){
							$sql = $this->db->GetUpdateSql($rs,$Mapping);
						}else{
							$sql = $this->db->GetInsertSql($rs,$Mapping);
						}
						if ($sql){$this->db->Execute($sql);}
						
						// Kind Artikel unsichtbar machen
						$sql = "UPDATE " . TABLE_PRODUCTS . " SET products_status = 0 WHERE products_model = '" . $Kind["products_model"] . "'";
						$this->db->Execute($sql);
					}else{
						$this->setStatus("-- Vaterartikel '" .  $value["vater"] . "' fuer Kindartikel '" . $id . "' existiert nicht.","Fehler");
					}
				}
			}
		}

	/**
	* Sortiert die Varianten der Grsuppe Allgemein
	**/		
		function sortVarianten(){
			$this->setStatus("Varianten werden sortiert.");
			$sql = "SELECT sortorder, products_options_values_name, products_id, products_attributes_id 
				FROM products_attributes 
				INNER JOIN products_options_values ON products_attributes.options_values_id = products_options_values.products_options_values_id
				WHERE products_attributes.options_id = 0
				ORDER BY products_id, products_options_values_name";
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				$i=0;
				$tempArtikelnummer=$rs->fields("products_id");
				while (!$rs->EOF){
					if ($tempArtikelnummer != $rs->fields("products_id")){$tempArtikelnummer=$rs->fields("products_id");$i=0;}
					$sql = "UPDATE products_attributes SET sortorder = " . $i . " WHERE products_id = " . $rs->fields("products_id") . " AND products_attributes_id = " . $rs->fields("products_attributes_id") . "";
					$this->db->Execute($sql);
					$i++;
					$rs->MoveNext();
				}
			}
		}
		
	/**
	* legt Kunden an anhand von einer XML Datei
	*
	* @param String xml
	**/
		function addKunden($xml){
			if (count($xml->KUNDE) > 0){
				$this->setStatus("Kunden werden angelegt bzw. modifiziert (" . time() . ").");
				
				foreach ($xml->KUNDE as $id => $value){
					if ($this->checkEmail((string)$value->EMAIL)){
						$Mapping=array();
						// Wird ausgelassen automatische hochzaehlen -- $Mapping["customers_id"]="";
						$Mapping["customers_cid"]=(string)$value->NR;
						if ( (string)$value->UST_ID ){
							$Mapping["customers_vat_id"]=(string)$value->UST_ID;
							$Mapping["customers_vat_id_status"]=1;
						}else{
							$Mapping["customers_vat_id"]=NULL;
							$Mapping["customers_vat_id_status"]=0;
						}
						$Mapping["customers_warning"]=""; 
						$Mapping["customers_status"]=$this->getKundengruppenID((string)$value->PGR);
						switch ((string)$value->ANREDE){
							case "Herr":
								$Mapping["customers_gender"]="m";
								break;
							case "Frau":
								$Mapping["customers_gender"]="w";
								break;
							default:
								break;
						}
						$Mapping["customers_firstname"]=$this->ConvertText2DB((string)$value->VORNAME);
						$Mapping["customers_lastname"]=$this->ConvertText2DB((string)$value->NAME1);
						//$Mapping["customers_dob"]="";
						$Mapping["customers_email_address"]=$this->ConvertText2DB((string)$value->EMAIL);
						$Mapping["customers_default_address_id"]=1;
						$Mapping["customers_telephone"]=$this->ConvertText2DB((string)$value->TEL1);
						$Mapping["customers_fax"]=$this->ConvertText2DB((string)$value->FAX);
						$Mapping["customers_password"]=md5("START".(string)$value->NR);
						$Mapping["customers_newsletter"]="";
						$Mapping["customers_newsletter_mode"]=0;
						$Mapping["member_flag"]=0;
						$Mapping["delete_user"]=0;
						$Mapping["account_type"]=0;
						$Mapping["password_request_key"]="";
						$Mapping["payment_unallowed"]="";
						$Mapping["shipping_unallowed"]="";
						$Mapping["refferers_id"]=0;
						$Mapping["customers_date_added"]=date("d.m.Y",time());
						$Mapping["customers_last_modified"]=date("d.m.Y",time());
					
						$sql = "SELECT * FROM " . TABLE_CUSTOMERS . " WHERE customers_cid = '" . (string)$value->NR . "'";
						$rs = $this->db->Execute($sql);
						if (!$rs->EOF && $rs){
							$sql = $this->db->GetUpdateSQL($rs,$Mapping);
						}else{
							$sql = $this->db->GetInsertSQL($rs,$Mapping);
						}
						if ($sql){$this->db->Execute($sql);}
						
						// XTC Adressen ID ermitteln
						$sql = "SELECT customers_id FROM " . TABLE_CUSTOMERS . " WHERE customers_cid = '" . (string)$value->NR . "'";
						$rs = $this->db->Execute($sql);
						if (!$rs->EOF && $rs){
							$XTCKundennummer=$rs->fields("customers_id");
						
							// Adresse
							$Mapping=array();
							//$Mapping["address_book_id"]="";
							$Mapping["customers_id"]=$XTCKundennummer;
							$Mapping["entry_gender"]="";
							$Mapping["entry_company"]=$this->ConvertText2DB((string)$value->NAME2);
							$Mapping["entry_firstname"]=$this->ConvertText2DB((string)$value->VORNAME);
							$Mapping["entry_lastname"]=$this->ConvertText2DB((string)$value->NAME1);
							$Mapping["entry_street_address"]=$this->ConvertText2DB((string)$value->STRASSE);
							$Mapping["entry_suburb"]="";
							$Mapping["entry_postcode"]=(string)$value->PLZ;
							$Mapping["entry_city"]=$this->ConvertText2DB((string)$value->ORT);
							$Mapping["entry_state"]="";

							// Land ermitteln
							$sql = "SELECT countries_id FROM " . TABLE_COUNTRIES . " WHERE 	countries_iso_code_2 = '" . $this->ConvertText2DB((string)$value->LKZ) . "'";
							$rsspeicher = $this->db->Execute($sql);
							if (!$rsspeicher->EOF && $rsspeicher){
								$Mapping["entry_country_id"]=$rsspeicher->fields("countries_id");
							}else{
								$sql = "SELECT countries_id FROM " . TABLE_COUNTRIES . " WHERE countries_iso_code_2 = 'DE'";
								$rsspeicher = $this->db->Execute($sql);
								$Mapping["entry_country_id"]=$rsspeicher->fields("countries_id");;
							}
							
							$Mapping["entry_zone_id"]=0;
							$Mapping["address_date_added"]=date("d.m.Y",time());
							$Mapping["address_last_modified"]=date("d.m.Y",time());
							
							$sql = "SELECT * FROM " . TABLE_ADDRESS_BOOK . " WHERE customers_id = " . $XTCKundennummer . "";
							$rs = $this->db->Execute($sql);
							if (!$rs->EOF && $rs){
								$sql = $this->db->GetUpdateSQL($rs,$Mapping);
							}else{
								$sql = $this->db->GetInsertSQL($rs,$Mapping);
							}
							if ($sql){$this->db->Execute($sql);}
							
							// Adressbuch Nummer ermitteln, um Kundendatensatz zu aktualisieren
							$sql = "SELECT address_book_id FROM " . TABLE_ADDRESS_BOOK . " WHERE customers_id = " . $XTCKundennummer . "";
							$rs = $this->db->Execute($sql);
							if (!$rs->EOF && $rs){
								$sql = "UPDATE ". TABLE_CUSTOMERS . " SET customers_default_address_id = " . $rs->fields("address_book_id") . " WHERE customers_id = " . $XTCKundennummer . ""; 
								$this->db->Execute($sql);
							}else{
							}
							
							// Zusatz Tabelle
							$sql = "SELECT * FROM " . TABLE_CUSTOMERS_INFO . " WHERE customers_info_id = " . $XTCKundennummer;
							$rs = $this->db->Execute($sql);
							if (!$rs->EOF && $rs){
								//
							}else{
								$sql = "INSERT INTO " . TABLE_CUSTOMERS_INFO . " (customers_info_id) VALUES (" . $XTCKundennummer . ")";
							}
							if ($sql){$this->db->Execute($sql);}
							
						}else{
						}
					}else{
						//$this->Log("Adresse (" . (string)$value->NR . ") hat keine GĂĽltige Email Adresse.");
					}
				}
			}
		}
		
	/**
	 * Liest eine Auftragsdatei und hinterlegt einen entsprechenden Status und sendet
	 * gegeben falls ein Status per Email
	 * @param String $xml
	 */
		function setAuftragStatus($xml){
			foreach ($xml as $id => $value){
				$TempOrderID=$value->SHOP_NR;
				$StatusVersendet=3;
				$StatusEmailVersendet=0;
			
				// Bestellung vorhanden?
				$sql = "SELECT customers_name, customers_email_address, orders_status, date_purchased 
						FROM ".TABLE_ORDERS." 
						WHERE orders_id = '".xtc_db_input($TempOrderID)."'";
				$rs = $this->db->Execute($sql);
				if (!$rs->EOF && $rs){
					$TempComments ="Versandatum: " . $value->VERSANDDATUM . "\n";
					$TempComments.="Zahlungsdatum: " . $value->ZAHLUNGSDATUM . "\n";
					$TempComments.="Paketnummer: " . trim($value->PAKETNUMMER) . "";
				}				
				
				// Email versenden
				if ($value->VERSANDMAIL == 1){
					require_once (DIR_FS_CATALOG.DIR_WS_CLASSES.'class.phpmailer.php');
					require_once (DIR_FS_INC.'xtc_php_mail.inc.php');

					// Text erzeugen
					$smarty = new Smarty;
					$smarty->assign('language', $_SESSION['language']);
			        $smarty->caching = false;
			        $smarty->template_dir = DIR_FS_CATALOG.'templates';
			        $smarty->compile_dir = DIR_FS_CATALOG.'templates_c';
			        $smarty->config_dir = DIR_FS_CATALOG.'lang';
			        $smarty->assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');
			        $smarty->assign('logo_path', HTTP_SERVER.DIR_WS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/img/');
			
			        $smarty->assign('NAME', $check_status['customers_name']);
			        $smarty->assign('ORDER_NR', $TempOrderID);
			        $smarty->assign('ORDER_ID', $TempOrderID);
			        $smarty->assign('ORDER_LINK', xtc_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id='.$TempOrderID, 'SSL'));
			        $smarty->assign('ORDER_DATE', xtc_date_long($check_status['date_purchased']));
			        $smarty->assign('NOTIFY_COMMENTS', nl2br($TempComments)); // Tomcraft - 2009-10-10 - Fixed wordwrap in notify_comments
			        $smarty->assign('ORDER_STATUS', $orders_status_array[$StatusVersendet]);
			
			        $html_mail = $smarty->fetch(DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/admin/mail/german/change_order_mail.html');
			        $txt_mail = $smarty->fetch(DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/admin/mail/german/change_order_mail.txt');
					
					xtc_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $rs->fields("customers_email_address"), $rs->fields("customers_name"), '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, $TempFilename, '', EMAIL_BILLING_SUBJECT, $html_mail, $txt_mail);
					$StatusEmailVersendet=1;
				}
				
				// Notiz speichern
				xtc_db_query("INSERT INTO ".TABLE_ORDERS_STATUS_HISTORY." (orders_id, orders_status_id, date_added, customer_notified, comments) values ('".xtc_db_input($TempOrderID)."', '".xtc_db_input($StatusVersendet)."', now(), '".$StatusEmailVersendet."', '".xtc_db_input($TempComments)."')");
			}
		}
		
	/** 
	* Liefert den MWST Schluessel
	* 
	* @param String mwst
	* @return Integer id
	**/
		function getMWSTID($mwst){
			$sql = "SELECT tax_class_id FROM " . TABLE_TAX_RATES . " WHERE tax_rate = " . number_format(str_replace(",",".",$mwst),4,".","") . "";
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				return $rs->fields("tax_class_id");	
			}else{
				return 1;
			}
		}
		
	/** 
	* Liefert die Sprachen ID
	* 
	* @param String sprache
	* @return Integer id
	**/
		function getSprachenID($sprache){
			if (strlen($sprache) != 2){
				switch (strtolower($sprache)){
					case "d":
						$sprache="DE";break;
					case "e":
						$sprache="EN";break;
					case "f":
						$sprache="FR";break;
					case "i":
						$sprache="IT";break;
					case "n":
						$sprache="NO";break;
					case "s":
						$sprache="SE";break;
				}
			}
			$sql = "SELECT languages_id FROM " . TABLE_LANGUAGES . " WHERE LOWER(code) = '" . strtolower($sprache) . "'";
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				return $rs->fields("languages_id");
			}else{
				return 0;
			}
		}
		
	/**
	 * Liefert die Kundengruppen ID zurueck
	 * 
	 * @param Integer id
	 * @return Integer KundengruppenID
	 */
		function getKundengruppenID($id){
			$Kundengruppe=$this->StdKundengruppe;
			if ($id > 0){
				/*
				$sql = "SELECT customers_status_id FROM " . TABLE_CUSTOMERS_STATUS  . " WHERE customers_status_name = 'VK" . $id . "'";
				$rs = $this->db->Execute($sql);
				if (!$rs->EOF && $rs){
					$Kundengruppe = $rs->fields("customers_status_id");	
				}
				*/
				if ($this->Config->get("xstar_syncmercator_pgr_kundengruppe_vk" . $id) > 0){
					$Kundengruppe=$this->Config->get("xstar_syncmercator_pgr_kundengruppe_vk" . $id);
				}			
			}
			return $Kundengruppe;
		}
	
	/**
	 * Liefert den Namen der Kundengruppe
	 * @param unknown_type $customers_status_id
	 * @return unknown_type
	 */
		function getKundengruppenNameSchnittstelle($customers_status_id){
			$Kundengruppenname="VK4";
			for ($i=0 ; $i<=8 ; $i++){
				if($this->Config->get("xstar_syncmercator_pgr_kundengruppe_vk" . $i) == $customers_status_id){
					$Kundengruppenname="VK" . $i;
				}
			}
			return $Kundengruppenname;
		}
		
	/**
	 * PrĂĽft die bestehenden Kunden 
	 */
		function checkKundengruppen(){
			$this->setStatus("Kundengruppen werden geprueft.");
			$sql = "SELECT customers_id 
					FROM `customers` 
					LEFT JOIN customers_status ON customers.customers_status = customers_status.customers_status_id
					WHERE customers_status.customers_status_id IS NULL";
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				while (!$rs->EOF){
					$sql = "UPDATE " . TABLE_CUSTOMERS . " SET customers_status = " . $this->StdKundengruppe . " WHERE customers_id = " . $rs->fields("customers_id") . "";
					$this->db->Execute(sql);
					$rs->MoveNext();
				}
			}
		}
		
	/**
	* Aktualisiert die Herstellerliste
	*
	* @param String xml
	**/
		function addHersteller($xml){
			if (count($xml->HERSTELLER) > 0){
				$this->setStatus("Hersteller werden angelegt bzw. modifiziert.");
				foreach ($xml->HERSTELLER as $id => $value){
					$Maping=array();
					if ((string)$value->NR > 0){
						$Mapping["manufacturers_id"]=(string)$value->NR;
						$Mapping["manufacturers_name"]=$this->ConvertText2DB((string)$value->NAME1);
						$Mapping["manufacturers_image"]="";
						$Mapping["date_added"]=date("d.m.Y",time());
						$Mapping["last_modified"]=date("d.m.Y",time());
			
						$sql = "SELECT * FROM " . TABLE_MANUFACTURERS . " WHERE manufacturers_id = " . $Mapping["manufacturers_id"] . "";
						$rs = $this->db->Execute($sql);
						if (!$rs->EOF && $rs){
							$sql = $this->db->GetUpdateSQL($rs,$Mapping);
							//$this->Log("Hersteller '" . $Mapping["manufacturers_name"] . "' wird modifziert.");
						}else{
							$sql = $this->db->GetInsertSQL($rs,$Mapping);
							//$this->Log("Hersteller '" . $Mapping["manufacturers_name"] . "' wird angelegt.");
						}
						if ($sql){$this->db->Execute($sql);}
					}
				}
			}
		}
		
	/**
	* Liefert die Hersteller ID zurueck
	* 
	* @param String herstellerxml
	* @return Integer herstellerid
	**/
		function getHerstellerID($herstellerxml){
			$Maping=array();
			if ((string)$herstellerxml->NR > 0){
				$Mapping["manufacturers_id"]=(string)$herstellerxml->NR;
				$Mapping["manufacturers_name"]=(string)$herstellerxml->NAME1;
				$Mapping["manufacturers_image"]="";
				$Mapping["date_added"]=date("d.m.Y",time());
				$Mapping["last_modified"]=date("d.m.Y",time());
			
				$sql = "SELECT * FROM " . TABLE_MANUFACTURERS . " WHERE manufacturers_id = " . $Mapping["manufacturers_id"] . "";
				$rs = $this->db->Execute($sql);
				if (!$rs->EOF && $rs){
					// Hersteller werden durch Herstellerliste angelegt
					//$sql = $this->db->GetUpdateSQL($rs,$Mapping);
				}else{
					$sql = $this->db->GetInsertSQL($rs,$Mapping);
				}
				if ($sql){$this->db->Execute($sql);}
				return $Mapping["manufacturers_id"];
			}else{
				return 0; 
			}
		}
		
	/**
	* Erzeugt und aktualsiert die Kategorien
	*
	* @param String xml
	**/
		function addKategorien($xml){
			if (count($xml->KATEGORIE) > 0){
				$this->setStatus("Kategorien werden angelegt (" . time() . ").");
				
				// BESTEHENDE KATEGORIEN LOESCHEN
				$sql = "DELETE FROM " . TABLE_CATEGORIES . ";";
				$this->db->Execute($sql);
				
				$sql = "DELETE FROM " . TABLE_CATEGORIES_DESCRIPTION . ";";
				$this->db->Execute($sql);
				
				// Standardkategorie anlegen
				$Mapping=array();
				$Mapping["categories_id"]=1;
				$Mapping["categories_image"]="";
				$Mapping["parent_id"]=0;
				$Mapping["categories_status"]=0;
				$Mapping["categories_template"]="default";
				$Mapping["group_permission_0"]=0;
				$Mapping["group_permission_1"]=0;
				$Mapping["group_permission_2"]=0;
				$Mapping["group_permission_3"]=0; 	
				$Mapping["listing_template"]="default";
				$Mapping["sort_order"]=0;
				$Mapping["products_sorting"]="p.products_modell";
				$Mapping["products_sorting2"]="ASC";
				$Mapping["date_added"]=date("d.m.Y",time());
				$Mapping["last_modified"]=date("d.m.Y",time());
				
				$sql = "SELECT * FROM " . TABLE_CATEGORIES . " WHERE categories_id = " . $Mapping["categories_id"] . "";
				$rs = $this->db->Execute($sql);
				$sql = $this->db->GetInsertSQL($rs,$Mapping);
				if ($sql){$this->db->Execute($sql);}
				
				// Varianten - Kategorien
				$Mapping=array();
				$Mapping["categories_id"]=-1;
				$Mapping["categories_image"]="";
				$Mapping["parent_id"]=0;
				$Mapping["categories_status"]=0;
				$Mapping["categories_template"]="default";
				$Mapping["group_permission_0"]=0;
				$Mapping["group_permission_1"]=0;
				$Mapping["group_permission_2"]=0;
				$Mapping["group_permission_3"]=0; 	
				$Mapping["listing_template"]="default";
				$Mapping["sort_order"]=0;
				$Mapping["products_sorting"]="p.products_modell";
				$Mapping["products_sorting2"]="ASC";
				$Mapping["date_added"]=date("d.m.Y",time());
				$Mapping["last_modified"]=date("d.m.Y",time());
				
				$sql = "SELECT * FROM " . TABLE_CATEGORIES . " WHERE categories_id = " . $Mapping["categories_id"] . "";
				$rs = $this->db->Execute($sql);
				$sql = $this->db->GetInsertSQL($rs,$Mapping);
				if ($sql){$this->db->Execute($sql);}

				// STD - Kategorie Beschreibung
				$Mapping=array();
				$Mapping["categories_id"]=1;
				$Mapping["language_id"]=2;
				$Mapping["categories_name"]="Nicht zuzordnen !!! (ERP Sync)";
				$Mapping["categories_heading_title"]="";
				$Mapping["categories_description"]="";
				$Mapping["categories_meta_title"]="";
				$Mapping["categories_meta_description"]="";
				$Mapping["categories_meta_keywords"]="";
				$sql = "SELECT * FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = " . $Mapping["categories_id"] . "";
				$rs = $this->db->Execute($sql);
				$sql = $this->db->GetInsertSQL($rs,$Mapping);
				if ($sql){$this->db->Execute($sql);}
				
				// Varianten - Kategorie Beschreibung
				$Mapping=array();
				$Mapping["categories_id"]=-1;
				$Mapping["language_id"]=2;
				$Mapping["categories_name"]="Varianten Artikel (ERP Sync)";
				$Mapping["categories_heading_title"]="";
				$Mapping["categories_description"]="";
				$Mapping["categories_meta_title"]="";
				$Mapping["categories_meta_description"]="";
				$Mapping["categories_meta_keywords"]="";
				$sql = "SELECT * FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = " . $Mapping["categories_id"] . "";
				$rs = $this->db->Execute($sql);
				$sql = $this->db->GetInsertSQL($rs,$Mapping);
				if ($sql){$this->db->Execute($sql);}
								
				// Kategorien anlegen
				foreach ($xml->KATEGORIE as $id => $value){
					$Mapping=array();
					$Mapping["categories_id"]=$this->changeKategorienID($value->KAT_ID);
					
					if (is_numeric($Mapping["categories_id"])){
						$Mapping["categories_image"]="";
						$Mapping["parent_id"]=$this->changeKategorienID($value->VATER_ID);
						if ((string)$value->AKTIV == 1){
							$Mapping["categories_status"]=1;
						}else{
							$Mapping["categories_status"]=0;
						}
						$Mapping["categories_template"]="default";
						$Mapping["group_permission_0"]=0;
						$Mapping["group_permission_1"]=0;
						$Mapping["group_permission_2"]=0;
						$Mapping["group_permission_3"]=0; 	
						$Mapping["listing_template"]="default";
						$Mapping["sort_order"]=0;
						
						switch (strtoupper((string)$value->SORT_FELD)){
							case"ARTIKELNUMMER":
								$Mapping["products_sorting"]="p.products_model";
								break;
							case "EAN":
								$Mapping["products_sorting"]="p.products_ean";
								break;
							case "PREIS":
								$Mapping["products_sorting"]="p.products_price";
								break;
							case "ANGELEGT AM":
								$Mapping["products_sorting"]="p.products_date_added";
								break;
							case "LETZE Ă„NDERUNG":
								$Mapping["products_sorting"]="p.products_last_modified";
								break;
							default:
								$Mapping["products_sorting"]="p.products_price";
								break;
						}
						
						switch (strtoupper((string)$value->SORT_RICHTUNG)){
							case "ASC":
								$Mapping["products_sorting2"]="ASC";
								break;
							case "DESC":
								$Mapping["products_sorting2"]="DESC";
								break;
							default:
								$Mapping["products_sorting2"]="ASC";
								break;	
						}
						
						$Mapping["date_added"]=date("d.m.Y",time());
						$Mapping["last_modified"]=date("d.m.Y",time());
						
						// Kategorien
						$sql = "SELECT * FROM " . TABLE_CATEGORIES . " WHERE categories_id = " . $Mapping["categories_id"] . "";
						$rs = $this->db->Execute($sql);
						if (!$rs->EOF && $rs){
							$sql = $this->db->GetUpdateSQL($rs,$Mapping);
						}else{
							$sql = $this->db->GetInsertSQL($rs,$Mapping);
						}
						if ($sql){$this->db->Execute($sql);}
						
						// Kategorien Sprachen
						if (count($value->SPRACHE) > 0){
							foreach ($value->SPRACHE as $id1 => $value1){
								$Mapping=array();
								$Mapping["categories_id"]=$this->changeKategorienID($value->KAT_ID);
								$Mapping["language_id"]=$this->getSprachenID($value1->SPRACH_KZ);
								$Mapping["categories_name"]=$this->ConvertText2DB((string)$value1->TEXT);
								$Mapping["categories_heading_title"]=$this->ConvertText2DB((string)$value1->KURZTEXT);
								$Mapping["categories_description"]=$this->ConvertText2DB((string)$value1->LANGTEXT);
								$Mapping["categories_meta_title"]=$this->ConvertText2DB((string)$value1->SEO->TITLE);
								$Mapping["categories_meta_description"]=$this->ConvertText2DB((string)$value1->SEO->DESCR);
								$Mapping["categories_meta_keywords"]=$this->ConvertText2DB((string)$value1->SEO->KEYW);
								
								$sql = "SELECT * FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = " . $Mapping["categories_id"] . " AND language_id = " . $Mapping["language_id"] . "";
								$rs = $this->db->Execute($sql);
								if (!$rs->EOF && $rs){
									$sql = $this->db->GetUpdateSQL($rs,$Mapping);
								}else{
									$sql = $this->db->GetInsertSQL($rs,$Mapping);
								}
								if ($sql){$this->db->Execute($sql);}
							}
						}
					}else{
						$this->setStatus("-- nicht numerische Kategorie ('" . $Mapping["categories_id"] . "') wird ignoriert.","Fehler");
					}
				}
			}
		}
		
	/**
	* Erzeugt fuer XTC einen neue ID
	*
	* @param string id
	* @return integer id
	**/
		function changeKategorienID($id){
			if (trim($id)){return "1" . $id;}else{return 0;}
		}
		
	/**
	 * Prueft alle Kategorien, ob diese auch Artikel beinhalten
	 * 
	 */
		function checkKategorien(){
			$this->setStatus("Kategorien werden auf hinterlegte Artikel geprueft.");
			
			// Alle Kategorie auf leer setzten
			$sql = "UPDATE " . TABLE_CATEGORIES . " SET categories_status = 0";
			$this->db->Execute($sql);
						
			$sql = "SELECT * FROM " . TABLE_PRODUCTS_TO_CATEGORIES . "";
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				while (!$rs->EOF){
					$sql = "UPDATE " . TABLE_CATEGORIES . " SET categories_status = 1 WHERE categories_id = " . $rs->fields("categories_id") . "";
					$this->db->Execute($sql);

					$TempCategorie=$rs->fields("categories_id");					
					do{
						$sql = "SELECT * FROM " . TABLE_CATEGORIES . " WHERE categories_id = " . $TempCategorie . "";
						$rsspeicher = $this->db->Execute($sql); 
						$TempID=$rsspeicher->fields("parent_id");
						$TempCategorie=$rsspeicher->fields("parent_id");

						if ($TempID > 0){
							$sql = "UPDATE " . TABLE_CATEGORIES . " SET categories_status = 1 WHERE categories_id = " . $TempID . "";
							$this->db->Execute($sql);
						}
					}while ($TempID>1);
					$rs->MoveNext();
				}
				
				// "Nicht Zuzuordnen" wieder verstecken
				$sql = "UPDATE " . TABLE_CATEGORIES . " SET categories_status = 0 WHERE categories_id = 1";
				$this->db->Execute($sql);
				
				// Varianten Artikel wieder verstecken
				$sql = "UPDATE " . TABLE_CATEGORIES . " SET categories_status = 0 WHERE categories_id = -1";
				$this->db->Execute($sql);
			}else{
				//$this->Log("keine Katagorien zum prĂĽfen vorhanden.");
			}
		}
	
	/** 
	 * Alle Bildangaben im XTC mit den Dateien prĂĽfen
	 * @return unknown_type
	 */
		function checkImages(){
			$this->setStatus("Bildverknuepfungen werden geprueft.");
			$sql = "SELECT * FROM " . TABLE_PRODUCTS_IMAGES . "";
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				while (!$rs->EOF){
					$Status=true;
					
					// Original Bild
					$filename=DIR_FS_DOCUMENT_ROOT."/images/product_images/original_images/" . $rs->fields("image_name") . "";
					if(!file_exists($filename)){
						$Status=false;
					}
					
					// INFO  Bild
					$filename=DIR_FS_DOCUMENT_ROOT."/images/product_images/info_images/" . $rs->fields("image_name") . "";
					if(!file_exists($filename)){
						$Status=false;
					}
					
					// POPUP  Bild
					$filename=DIR_FS_DOCUMENT_ROOT."/images/product_images/popup_images/" . $rs->fields("image_name") . "";
					if(!file_exists($filename)){
						$Status=false;
					}
					
					// Thunbnail Bild
					$filename=DIR_FS_DOCUMENT_ROOT."/images/product_images/thumbnail_images/" . $rs->fields("image_name") . "";
					if(!file_exists($filename)){
						$Status=false;
					}
					
					// Datensatz aus Datenbank loeschen - Bild existiert nicht
					if (!$Status){
						$sql = "DELETE FROM " . TABLE_PRODUCTS_IMAGES . " WHERE image_id = " . $rs->fields("image_id");
						$this->db->Execute($sql);
					}
					$rs->MoveNext();
				}
			}
		} 
		
	/**
	 * prueft alle Bilder auf Duplikate
	 */
		function checkImagesDuplikate($products_id=0){
			if (!$products_id){$this->setStatus("Bildduplikate werden entfernt.");}
			$BildVerzeichnisse=array("original_images","info_images","popup_images","thumbnail_images");
			
			$sql = "SELECT * 
					FROM " . TABLE_PRODUCTS_IMAGES . " pi
					INNER JOIN " . TABLE_PRODUCTS . " p ON p.products_id = pi.products_id ";
			if ($products_id > 0){$sql .= " WHERE p.products_id = " .$products_id;}
			
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				$Bilder=array();
				$TempProductsId=0;
				while (!$rs->EOF){
					// Erstes Bild
					if($TempProductsId != $rs->fields("products_id")){
						$TempProductsId = $rs->fields("products_id");
						$Bilder[$rs->fields("products_id")][0]["image_name"]=$rs->fields("products_image");
						$filename=DIR_FS_DOCUMENT_ROOT."/images/product_images/original_images/".$rs->fields("products_image");
						if (file_exists($filename)){
							$Bilder[$rs->fields("products_id")][0]["md5"]=hash_file('md5', $filename);
						}
					}
					
					// Weitere Bilder
					$Bilder[$rs->fields("products_id")][$rs->fields("image_id")]["image_name"]=$rs->fields("image_name");
					$filename=DIR_FS_DOCUMENT_ROOT."/images/product_images/original_images/".$rs->fields("image_name");
					if (file_exists($filename)){
						$Bilder[$rs->fields("products_id")][$rs->fields("image_id")]["md5"]=hash_file('md5', $filename);
					}
					$rs->MoveNext();	
				}
			}
			
			// doppelte Bilder entfernen
			if (count($Bilder)>0){
				foreach ($Bilder as $id => $value){
					$i=0;
					foreach ($value as $id_bild => $value_bild){
						if ($i > 0){
							if ($value_bild["md5"] == $value[0]["md5"]){
								foreach ($BildVerzeichnisse as $key => $path){
									$filename=DIR_FS_DOCUMENT_ROOT."/images/product_images/" . $path . "/".$value_bild["image_name"];
									if (file_exists($filename)){unlink($filename);}
								}
								$sql = "DELETE FROM " . TABLE_PRODUCTS_IMAGES . " WHERE image_id = " . $id_bild;
								$this->db->Execute($sql);
							}
						}
						$i++;
					}
				}
			}
		}
		
	/**
	 * Loescht die Bilder 
	 */
		function deleteImportImages(){
			if ($this->Config->get("xstar_syncmercator_importbilder_loeschen")!=1){
				$this->setStatus("Nicht benoetigte Bilder werden geloescht.");
				$PathInhaltBilder=$this->fs->readDir($this->PathImport."bilder/");
				if (count($PathInhaltBilder)>0){
					$this->setStatus("restliche Bilder, deren Zurordnung fehlt, werden geloescht");
					foreach ($PathInhaltBilder as $id => $value){
						$filename=$this->PathImport."bilder/".$value["name"];
						if (file_exists($filename)){unlink($filename);}
					}
				}
			}
		}
	/**
	 * Sortierung der Kategorien
	 */
		function sortKategorien(){
			$this->setStatus("Sortierung fuer Kategorien wird durchgefuehrt.");
			
			$sql = "SELECT LEFT(CONCAT(categories_id,'000000000000000'),15) AS categories_id_neu, categories_id  FROM " . TABLE_CATEGORIES . " ORDER BY categories_id";
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF && $rs){
				$ids=array();
				while (!$rs->EOF){
					$ids[$rs->fields("categories_id_neu")]=$rs->fields("categories_id");				
					$rs->MoveNext();		
				}
				
				$Zaehler=0;
				foreach ($ids as $id => $value){
					$sql = "UPDATE " . TABLE_CATEGORIES . " SET sort_order = " . $Zaehler . " WHERE categories_id = " . $value;
					$this->db->Execute($sql);
					$Zaehler++;
				} 
			}		
		}
		
	/**
	* Liesst eine vorgegebene XML Datei
	*
	* @param String filename
	**/
		function readXML($filename){
			if (file_exists($filename)){
				$xml=simplexml_load_file($filename);
				return $xml;
			}else{
				$this->showMeldung(0,2,array("%filename%"=>$filename));
				return false;
			}
		}
	
	/**
	 * Loescht den Dateinamen pysikalisch und aus dem Hilfsspeicher
	 * @param $filename
	 */
		function deleteXML($filename){
			if (file_exists($filename)){
				if (!$this->Config->get("xstar_syncmercator_importdateien_loeschen")){
					unlink($filename);
				}
			}
		}
		
	/**
	 * Liefert ein XML String zurueck
	 * 
	 * @param $Ebene
	 * @param $Name
	 * @param $Wert
	 * @return $String
	 */
		function getXMLNode($Ebene=0,$Name,$Wert){
			$XML="";
			for($i=0 ; $i <= $Ebene ; $i++){
				$XML.="\t";
			}
			
			$Wert=str_replace("\n"," ",$Wert);
			if ($this->is_utf8($Wert)){
				$Wert=utf8_decode($Wert);
			}
			$XML.="<" . $Name . ">" . $Wert . "</" . $Name . ">\n";
			return $XML;
		}
		
	/**
	* Gibt die Meldung aus
	*
	* @param String wert
	**/
		function showMeldung($erfolgreich=0,$meldungid=0,$austauschen=array()){
			$Ausgabe="";
			$Meldungstext=$this->getMeldungsText($meldungid);
			
			// Austausch Parameter uebergeben
			if (count($austauschen)>0){
				foreach ($austauschen as $id => $value){
					$Meldungstext = str_replace($id,$value,$Meldungstext);
				}
			}
			
			$Ausgabe=$erfolgreich."~".$meldungid."~".$Meldungstext."~".$this->LogFileLink;
			if ($this->quiet!=true){print $Ausgabe;}
		}
		
	/**
	 * Ausgabe auf dem Bildschirm
	 * @param $wert
	 */
		function setStatus($wert,$art=""){
			$wert=htmlentities(utf8_decode($wert));
			$wert=str_replace("ďż˝","&auml;",$wert);
			$wert=str_replace("ďż˝","&uuml;",$wert);
			$wert=str_replace("ďż˝","&ouml;",$wert);
			$wert=str_replace("ďż˝","&Auml;",$wert);
			$wert=str_replace("ďż˝","&Ouml;",$wert);
			$wert=str_replace("ďż˝","&Uuml;",$wert);
			$wert=str_replace("&lt;","<",$wert);
			$wert=str_replace("&gt;",">",$wert);

			$Ausgabe=$wert;
			if ($this->Debug){print $wert;}
			
			// Datenbank Speicherung
			$Daten=array();			
			$Daten["sync_id"]=$this->getTODOID();
			$Daten["datumuhrzeit"]=str_replace("'","",$this->db->DBTimeStamp(date("Y-m-d H:i:s",time())));
			$Daten["beschreibung"]=$Ausgabe;
			$sql = "SELECT * FROM syncwawi_log";
			$rs = $this->db->Execute($sql);
			$sql = $this->db->GetInsertSQL($rs,$Daten);
			$this->db->Execute($sql);
		}
		
	/**
	* Liefert einen Meldungstext zurueck
	*
	* @param Integer meldungid
	* @return String meldung
	**/
		function getMeldungsText($meldungid){
			$meldung="";
			if ($this->Meldungen[$meldungid]){
				return $this->Meldungen[$meldungid];
			}else{
				return "nicht definiert.";
			}
		}
		
	/**
	* Konvertiert Text zum Datenbankstandard
	*
	* @param String text
	* @return String text_konvertiert
	**/
		function ConvertText2DB($text){
			return utf8_decode($text);
		}
		
	/**
	* Prueft eine Email auf Guelitgkeit
	* 
	* @param String mail
	* @param Boolean Status
	**/
		function checkEmail($mail){
			if(eregi("^[a-z0-9]+([-_\.]?[a-z0-9])+@[a-z0-9]+([-_\.]?[a-z0-9])+\.[a-z]{2,4}$",$mail)){
				return true;
			}else{
				return false;
			}
		}
		
	/** 
	 * Versendet eine Bestaetigungsemail
	 */
		function sendMail(){
			$my = new MyMail();
			$my->subject="Syncmodul Mercator / XTC Status";
			$body.="<p><span class=\"Header\">" . $this->Programmname . "</span><br><span class=\"Copyright\">copyright by WEBDESIGN-R&Uuml;STMANN 2009 - " . date("Y",time()) . "</span></p>";
			$body.="<p>&nbsp;</p>";
			$body.="<p>Ihre Daten wurden erfolgreich synchronisiert.</p>";
			$body.="<p>Die einzeln Schritte k&ouml;nnen Sie im unten stehenden Log einsehen:</p>";
			$body.="<p>&nbsp;</p>";
			$body.="<p class=\"code\">--- Log Anfang ---<p>";
			
			// Log auslesen
			$sql = "SELECT * FROM syncwawi_log WHERE sync_id = " . $this->getTODOID();
			$rs = $this->db->Execute($sql);
			if (!$rs->EOF  && $rs){
				// Standard Log auslesen
				$TempTime1=strtotime($rs->fields("datumuhrzeit"));
				while (!$rs->EOF){
					$body.="<p class=\"code\">" . $rs->fields("datumuhrzeit") . ": " . $rs->fields("beschreibung") . "</p>";
					$rs->MoveNext();
				}
				$TempTime2=strtotime($rs->fields("datumuhrzeit"));
				
				// Weiteres Log auslesen - was wurde verarbeitet
				$Dateien=array("Artikel","Hersteller","Kategorien");
				$body.="<p class=\"code\">------------------------------------------------------</p>";
				$body.="<p class=\"code\">nachfolgende Anzahl von Dateien wurden verarbeitet:</p>";
				$body.="";
				foreach ($Dateien as $id => $value){
					$sql = "SELECT COUNT(*) AS anzahl 
							FROM syncwawi 
							WHERE wert LIKE '%" . strtolower($value) . "%'
								AND art = 'FILE'
								AND erledigt = 1";
					$rs = $this->db->Execute($sql);
					if (!$rs->EOF && $rs){
						if ($rs->fields("anzahl")>0){
							$body.="<p class=\"code\">Anzahl der Dateien '" . $value . "': " . $rs->fields("anzahl") . "</p>";
						}
					}
				}
				
				$body.="<p class=\"code\">--- Log Ende ---<p>";	
			}else{
				$body.="<p>Es gab nichts zu tun :-).<p>";	
			}	
			$my->body=$body;
			$my->send();
		}

	/**
	 * Liefert den Mercator CSS Style
	 */
		function getCSS(){
			$filename=DIR_FS_DOCUMENT_ROOT_XSTAR."/style/SyncMercator.css";
			$Temp="<style>".$this->fs->fread($filename) . "</style>";
			return $Temp;
		}
		
	/**
	 * Erzeugt eine Aufgabe in der Datenbank
	 * @param $art
	 * @param $wert
	 * @param $sort
	 * @param $erledigt
	 */
		function addTODO($art, $wert, $sort=0, $erledigt=0){
			$sql = "INSERT INTO syncwawi (
							art, 
							wert, 
							sort, 
							erledigt) 
					VALUES ('" . $art . "',
							'" . $wert . "',
							" . $sort . ",
							" . $erledigt . ")";
			$this->db->Execute($sql);			
		}
		
	/**
	 * Liefert die aktuelle TODO ID
	 */
		function getTODOID(){
			if ($this->TODOID > 0){
				return $this->TODOID;
			}else{
				$sql = "SELECT * FROM syncwawi WHERE art = 'ID'";
				$rs = $this->db->Execute($sql);
				if (!$rs->EOF && $rs){
					return $rs->fields("wert");
				}else{
					return 0;
				}
			}
		}

		
	/**
	 * Erzeugt alle benoetigten Tabellen
	 */
		function createTables(){
			$Daten=array();
			$Daten["SELECT * FROM syncwawi"]="CREATE TABLE syncwawi (id integer NOT NULL AUTO_INCREMENT,art varchar(100),wert varchar(255),sort integer DEFAULT 0,erledigt integer DEFAULT 0,PRIMARY KEY (`id`))";
			$Daten["SHOW INDEX FROM syncwawi WHERE Column_name IN ('id','sort','erledigt')"]="ALTER TABLE `syncwawi` ADD INDEX ( `id` , `sort` , `erledigt` );";
			$Daten["SELECT * FROM syncwawi_log"]="CREATE TABLE syncwawi_log (log_id integer NOT NULL AUTO_INCREMENT,sync_id integer,datumuhrzeit TIMESTAMP,beschreibung text,PRIMARY KEY (`log_id`))";
			$Daten["SHOW INDEX FROM syncwawi_log WHERE Column_name IN ('log_id','sync_id')"]="ALTER TABLE `syncwawi_log` ADD INDEX ( `log_id` , `sync_id` ) ;";			
			$Daten["SELECT products_price_quantity FROM " . TABLE_PRODUCTS]="ALTER TABLE `products` ADD `products_price_quantity` INT NOT NULL";
			$Daten["SELECT in_bearbeitung FROM syncwawi"]="ALTER TABLE `syncwawi` ADD `in_bearbeitung` INT NOT NULL";
			
			foreach ($Daten as $id => $value){
				$rs = $this->db->Execute($id);
				if (!$rs){$this->db->Execute($value);}
			}
		}
		
	/**
	 * Prueft, ob ein Wert UTF8 ist
	 * @param $str
	 */
		function is_utf8($str){
			$strlen = strlen($str);
		  	for($i=0; $i<$strlen; $i++){
		  		$ord = ord($str[$i]);
		    	if($ord < 0x80) continue; // 0bbbbbbb
		    	elseif(($ord&0xE0)===0xC0 && $ord>0xC1) $n = 1; // 110bbbbb (exkl C0-C1)
		    	elseif(($ord&0xF0)===0xE0) $n = 2; // 1110bbbb
		    	elseif(($ord&0xF8)===0xF0 && $ord<0xF5) $n = 3; // 11110bbb (exkl F5-FF)
		    	else return false; // ungďż˝ltiges UTF-8-Zeichen
		    	for($c=0; $c<$n; $c++) // $n Folgebytes? // 10bbbbbb
		      	if(++$i===$strlen || (ord($str[$i])&0xC0)!==0x80)
		        return false; // ungďż˝ltiges UTF-8-Zeichen
		  }
		  return true; // kein ungďż˝ltiges UTF-8-Zeichen gefunden
		}
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="de">
<head>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.5.2/jquery.min.js" type="text/javascript"></script>
 
<title>Kontakt - most-Haustechnik</title> 

<meta http-equiv="content-language" content="de" /> 
<meta http-equiv="cache-control" content="no-cache" /> 

<meta name="keywords" content="Kontakt" /> 
<meta name="description" content="Kontakt" /> 

<meta name="robots" content="index,follow" />
<meta name="language" content="de" />
<meta name="author" content="Sven Eschrich" />
<meta name="publisher" content="Sven Eschrich" />
<meta name="company" content="most-Haustechnik" />
<meta name="page-topic" content="most-Haustechnik" />
<meta name="reply-to" content="s.eschrich@most-haustechnik.de" />
<meta name="distribution" content="global" />
<meta name="revisit-after" content="5" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15" /> 
<meta http-equiv="Content-Style-Type" content="text/css" />
<link rel="shortcut icon" href="http://www.most-haustechnik.de/templates/xtc2/favicon.ico" type="image/x-icon" />

<!--
	Dieser Shop - iallashop-  basiert auf XT-Commerce, und xt-modified
	XTC is a free open source e-Commerce System
	created by Mario Zanier & Guido Winger and licensed under GNU/GPL.
	Informationen über ialla.com - e-commerce loesungen: http://www.ialla.com
-->
<meta name="generator" content="(c) by iallashop basierend auf xtcModified und xtcommerce , http://www.ialla.com" />
<base href="http://www.most-haustechnik.de/" />
<link rel="stylesheet" type="text/css" href="templates/xtc2/stylesheet.css" />
<script type="text/javascript"><!--
var selected;
var submitter = null;

function submitFunction() {
    submitter = 1;
}
function popupWindow(url) {
  window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=150')
}  

function selectRowEffect(object, buttonSelect) {
  if (!selected) {
    if (document.getElementById) {
      selected = document.getElementById('defaultSelected');
    } else {
      selected = document.all['defaultSelected'];
    }
  }

  if (selected) selected.className = 'moduleRow';
  object.className = 'moduleRowSelected';
  selected = object;

// one button is not an array
  if (document.getElementById('payment'[0])) {
    document.getElementById('payment'[buttonSelect]).checked=true;
  } else {
    //document.getElementById('payment'[selected]).checked=true;
  }
}

function rowOverEffect(object) {
  if (object.className == 'moduleRow') object.className = 'moduleRowOver';
}

function rowOutEffect(object) {
  if (object.className == 'moduleRowOver') object.className = 'moduleRow';
}

function popupImageWindow(url) {
  window.open(url,'popupImageWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=150')
}
//--></script>
</head>
<body>


 <!--htdig_noindex-->
<div align="center">


<div align="center">

<div>

<br>

<table  width=921 border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">

<tr>

<td align="right"><a href="shop_content.php?coID=4">Impressum</a> | <a href="shop_content.php?coID=1">Versand</a> | <a href="shop_content.php?coID=7">Kontakt</a>&nbsp;&nbsp;</td>

</tr>

<tr>

<td><img src="templates/xtc2/img/leiste1.jpg"></td>

</tr>

<tr>

<td>

   <table  width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">

   <tr>

   	<td align="left"><img src="templates/xtc2/img/photo.jpg"></td>

         <td valign="top"><a href="index.php"><img src="templates/xtc2/img/logo.gif" border="0"></a><br>

          <table  style="padding:8px;border:1px solid #B4E8E8" width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">

          <tr>

          	<td align="left"><table align="left">

                 <tr>

                 <td><img src="templates/xtc2/img/angebot.jpg"></td>

                 </tr>

                 </table><br>

                 <b><span style="color:#0CADAF">Im Angebot</span></b><br>

                 Whirlpoolsystem Capri 130 <br>

                 statt <strike>999,99</strike>  nur <b>736,60 EUR</b><br>

                 <a href="product_info.php?products_id=394&cPath=45_46">Zum Angebot</a>

                 </td>

                 <td width="200" style="border-left:1px solid #B4E8E8" align="left">

                <a href="shopping_cart.php"><img src="templates/xtc2/img/button.gif" align="middle" border="0"> Zu Ihrem Warenkorb</a><br>

                <a href="checkout_shipping.php"><img src="templates/xtc2/img/button.gif" align="middle" border="0"> Zur Kasse</a><br>

                <a href="login.php"><img src="templates/xtc2/img/button.gif" align="middle" border="0"> Anmelden</a><br>

          </tr>

          </table>


         </td>

   </tr>

   <table>

</td>

</tr>

</table>


<table width="921"  border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">

  <tr>

    <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">

      <tr>

        <td style="border-right:1px solid #B4E8E8;border-bottom:1px solid #B4E8E8;"><table width="100%"  border="0" cellpadding="2" cellspacing="0">

          <tr>

            <td width="400"class="main" align="left"><a href="http://www.most-haustechnik.de" class="headerNavigation">Startseite</a> &raquo; <a href="http://www.most-haustechnik.de/index.php" class="headerNavigation">Katalog</a> &raquo; <a href="http://www.most-haustechnik.de/shop_content.php?coID=7" class="headerNavigation">Kontakt</a></td>

            <td align="left">
<form id="quick_find" action="http://www.most-haustechnik.de/findologic.php" method="get"><input type="hidden" name="XTCsid" value="m6fhnp7o4jctbiiarjep12q1b2" />
<table width="100%" border="0" cellpadding="2" cellspacing="0">
  <tr>
    <td class="infoBoxHeading"><table width="100%"  border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td class="infoBoxHeading">Suche </td>
          <td></td>
        </tr>
    </table></td>
  </tr>
  <tr>
    <td class="infoBox" align="left"><table width="95%"  border="0" cellpadding="2" cellspacing="0">
        <tr>
          <td class="boxText">
            <table width="100%"  border="0" cellpadding="2" cellspacing="0">
              <tr>
                <td valign="middle"><input type="text" name="keywords" size="20" maxlength="30" /></td>
                <td valign="middle"><input type="image" src="templates/xtc2/buttons/german/button_quick_find.gif" alt="Suchen" title=" Suchen " /></td>
              </tr>
            </table>
            <br />
            <a href="http://www.most-haustechnik.de/advanced_search.php">Erweiterte Suche &raquo;</a> </td>
        </tr>
    </table></td>
  </tr>
</table>
</form></td>


            <!--<div align="right"><a href="http://www.most-haustechnik.de/account.php">Ihr Konto</a> | <a href="http://www.most-haustechnik.de/shopping_cart.php">Warenkorb</a> | <a href="http://www.most-haustechnik.de/checkout_shipping.php">Kasse</a></div>--></td>

          </tr>

        </table></td>

      </tr>

      <tr>

        <td width="921" ><table width="100%"  border="0" cellspacing="0" cellpadding="0">

          <tr>

            <td background="" class="navLeft" width="215" valign="top">

            <table width="100%"  border="0" cellpadding="0" cellspacing="0">

              <tr>

                <td valign="top"><!--/htdig_noindex-->
<table width="100%" border="0" cellpadding="2" cellspacing="0">
  <tr>
    <td class="infoBoxHeading"><table width="100%"  border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td class="infoBoxHeading">Kategorien </td>
          <td></td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td class="infoBox" align="left"><table width="95%"  border="0" cellpadding="2" cellspacing="0">
        <tr>
          <td class="boxText"><li class="level1"><a href="http://www.most-haustechnik.de/index.php?cPath=1">Dichtmittel</a></li>&nbsp;(80)<li class="level1"><a href="http://www.most-haustechnik.de/index.php?cPath=10">Reinigungsmittel</a></li>&nbsp;(10)</td>
        </tr>

    </table></td>
  </tr>
</table><!--htdig_noindex--> 

<table width="100%" border="0" cellpadding="2" cellspacing="0">
  <tr>
    <td class="infoBoxHeading"><table width="100%"  border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td class="infoBoxHeading">Mehr &uuml;ber... </td>
        <td></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td class="infoBox" align="left"><table width="95%"  border="0" cellpadding="2" cellspacing="0">
        <tr>
          <td class="boxText"><img src="templates/xtc2/img/icon_arrow.jpg" alt="" /> <a href="http://www.most-haustechnik.de/shop_content.php?coID=1">Liefer- und Versandkosten</a><br /><img src="templates/xtc2/img/icon_arrow.jpg" alt="" /> <a href="http://www.most-haustechnik.de/shop_content.php?coID=2">Privatsphaere und Datenschutz</a><br /><img src="templates/xtc2/img/icon_arrow.jpg" alt="" /> <a href="http://www.most-haustechnik.de/shop_content.php?coID=3">Unsere AGB</a><br /><img src="templates/xtc2/img/icon_arrow.jpg" alt="" /> <a href="http://www.most-haustechnik.de/shop_content.php?coID=10">Liefer- und Versandbestimmungen</a><br /><img src="templates/xtc2/img/icon_arrow.jpg" alt="" /> <a href="http://www.most-haustechnik.de/shop_content.php?coID=4">Impressum</a><br /><img src="templates/xtc2/img/icon_arrow.jpg" alt="" /> <a href="http://www.most-haustechnik.de/shop_content.php?coID=7">Kontakt</a><br /><img src="templates/xtc2/img/icon_arrow.jpg" alt="" /> <a href="http://www.most-haustechnik.de/shop_content.php?coID=9">Widerrufsrecht</a><br /><img src="templates/xtc2/img/icon_arrow.jpg" alt="" /> <a href="http://www.most-haustechnik.de/shop_content.php?coID=12">Downloads</a><br /><img src="templates/xtc2/img/icon_arrow.jpg" alt="" /> <a href="http://www.most-haustechnik.de/shop_content.php?coID=13">Verbraucherinformationen</a><br /></td>
        </tr>
    </table></td>
  </tr>
</table>   

<table width="100%" border="0" cellpadding="2" cellspacing="0">
  <tr> 
    <td class="infoBoxHeading_right"><table width="100%"  border="0" cellpadding="0" cellspacing="0">
        <tr> 
          <td class="infoBoxHeading_right">Willkommen zur&uuml;ck! </td>
          <td>&nbsp;</td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td class="infoBox_right" align="left"> <table width="95%"  border="0" cellpadding="2" cellspacing="0">
        <tr> 
          <td class="boxText"><form id="loginbox" method="post" action="http://www.most-haustechnik.de/login.php?action=process"> 
            <table width="100%"  border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td class="main">E-Mail-Adresse:</td>
              </tr>
              <tr> 
                <td><input type="text" name="email_address" size="25" maxlength="50" /></td>
              </tr>
              <tr> 
                <td class="main">Passwort:</td>
              </tr>
              <tr> 
                <td><table width="100%"  border="0" cellpadding="2" cellspacing="0">
                    <tr> 
                      <td><input type="password" name="password" size="10" maxlength="30" /> </td>
                      <td><input type="image" src="templates/xtc2/buttons/german/button_login_small.gif" alt="Anmelden" title=" Anmelden " /></td>
                    </tr>
                  </table></td>
              </tr>
            </table></form></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td class="infoBox_right" align="right"><a href="http://www.most-haustechnik.de/password_double_opt.php">Passwort vergessen?</a></td>
  </tr>
</table> </td>

              </tr>

            </table>

              <blockquote>&nbsp;</blockquote></td>

            <td valign="top" style="border-right:1px solid #B4E8E8"><table width="100%"  border="0" cellspacing="4" cellpadding="0">

              <tr>

                <td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">

                  <tr>

                    <td class="main" align="left" >

                    
                    	<!--/htdig_noindex-->

<h1>Kontakt</h1>
<form id="contact_us" action="http://www.most-haustechnik.de/shop_content.php?action=send&amp;coID=7" method="post">
<div class="highlightbox">
<table width="100%" border="0" cellspacing="0" cellpadding="4">
        <tr> 
          <td width="41%">Ihr Name:</td>
          <td width="59%"><input type="text" name="name" size="30" /></td>
        </tr>
        <tr> 
          <td>Ihre E-Mail-Adresse:</td>
          <td width="59%"><input type="text" name="email" size="30" /></td>
        </tr>
        <tr> 
          <td>Sicherheitscode</td>
          <td></td>
        </tr>
        <tr> 
          <td>Sicherheitscode</td>
          <td width="59%"></td>
        </tr>
        <tr>
          <td>Ihre Nachricht:</td>
          <td width="59%"><textarea name="message_body" id="message_body" cols="50" rows="15"></textarea></td>
        </tr>
</table>
</div>
<p><input type="image" src="templates/xtc2/buttons/german/button_continue.gif" alt="Weiter" title=" Weiter " /></p>
</form>
<!--htdig_noindex-->

                       
                    </td>

                  </tr>

                </table></td>

              </tr>

            </table></td>


          </tr>

          <tr>

            <td colspan="3" valign="top"></td>

            </tr>

        </table></td>

      </tr>

    </table></td>

  </tr>

</table>

<table width="100%"  border="0" cellspacing="4" cellpadding="0">

  <tr>

    <td height="22" bgcolor="#1B7295" class="main" style="color:#FFFFFF"; align="center">&copy; RS-Filtertechnik.de &nbsp; &nbsp; &nbsp; &nbsp;Umgesetzt von <a href="http://www.liqui.net" class="white">Liqui.net - Ideen f&uuml;r vernetzte Medien</td>

  </tr>

</table>

<table width="100%"  border="0" cellspacing="4" cellpadding="0">

  <tr>

    <td> <!--<div align="center"> -->
      <script language="JavaScript" src="http://service.bfast.com/bfast/script?bfmid=37923570&amp;siteid=41530045&amp;bfpage=dyn_schnap_468_01"></script>
                    <!-- END BE FREE TAG -->
                    <a href="http://clix.superclix.de/cgi-bin/clix.cgi?id=mostHaustechnik&amp;pp=4947&amp;linknr=20438" target="_blank">
                    <img width="468" height="60" border="0" alt="www.jobdoo.de" src="http://www.jobdoo.de/cgi-bin/banner/jobdoo_468x60_comic.gif" />
                    </a>
    </div></td>

  </tr>

</table>

</div>

</div>
<!--/htdig_noindex--><center><div class="copyright">eCommerce Lösungen &copy; 2012 <a href="http://www.ialla.com/" target="_blank">www.ialla.com</a><br><script type="text/javascript"><!--


//--></script>
</body></html>