/**
* Erweiterung GL 21.05.2013
* POST Daten aus AJAX Aufruf geliefert in $_POST['formdata']
*
*/
parse_str($_POST['formdata'], $_POST);
//Datenbankconnection
include("../../include/open.inc.php");
mysql_query("SET character_set_results='utf8'",$conn);
mysql_query("Set names 'utf8'",$conn);
$databank ="sii_pdfout";
/*
//Preise aus der sii_price_edit / Status = 1 ==aktuelle Preise
$sql =sprintf("SELECT id FROM sii_price_edit WHERE status = 1");
$query = mysql_query($sql, $conn);
$pl_status1 = mysql_fetch_array($query);
$pl_angabe = "AND id_sii_price_edit = ".$pl_status1['id'];
*/
$pl_angabe = "AND id_sii_price_edit = ".$_POST['PL_DATESTART']; //Welche Preisliste aus Tabelle sii_price_edit angezeigt wird, kommt aus Pulldown Auswahl
$seite_nr = 1; // Startseite für Produkte (Seite 1 + 2 für Cover / Legende o.ä.)
//Headparameter
if(!$_POST['DE_ITEM']){
$de_item = $_GET['DE_ITEM'];
}else{
$de_item = $_POST['DE_ITEM'];
}
//Abfrage abweichende Sprache --> z.B. RU
$sql =sprintf("SELECT pdfout_website_language FROM sii_lkz_language WHERE lkz_cms ='%s'", $_SESSION["lkz2out"]);
$resu = mysql_query($sql, $conn);
$language_pdf = mysql_fetch_array($resu); //$language_pdf['pdfout_website']
if($language_pdf['pdfout_website_language']==''){
$language = $_SESSION["lkz2out"]; //WEBSEITE
$sprachtab = $_SESSION["land"]; //WEBSEITE
}else{
$language = $language_pdf['pdfout_website_language'];
$sql =sprintf("SELECT www_content_ FROM sii_lkz_language WHERE lkz_cms ='%s'", $language_pdf['pdfout_website_language']);
$resu2 = mysql_query($sql, $conn);
$sp_neu = mysql_fetch_array($resu2); //$language_pdf['pdfout_website']
$sprachtab = "www_content_".$sp_neu['www_content_']; //WEBSEITE
}
$pl_type = 1;
$pl_typebase = 1;
$active = 1; //Konstante
$template = 51;
//vorerst nur für Sättel
$pl_pg_from = 1;
$pl_pg_to = 6;
// Textformatierung für PDF
$sql = sprintf("SELECT pdfconfig_cols FROM sii_config WHERE id = 1");
$ergX = mysql_query($sql, $conn);
$pdf_cols = mysql_fetch_array($ergX);
//alle Daten zur Preisliste: Tabelle "sii_pricelist_typebase"
$sql = sprintf("SELECT * FROM sii_pricelists_typebase WHERE id = %s",
intval($_POST['PL_TYPEBASE'])
);
$res6 = mysql_query($sql, $conn);
$sii_pricelists_typebase = mysql_fetch_array($res6);
//Daten zur Preisliste: Tabelle "sii_pricelist_type"
$sql = sprintf("SELECT * FROM sii_pricelists_type WHERE id = %s",
$pl_type
);
$res6 = mysql_query($sql, $conn);
$sii_pricelists_type = mysql_fetch_array($res6); //
//Tabelle clearen : nur die Einträge mit template = 1:
$sql = sprintf("DELETE FROM %s WHERE template = 51",
$databank
);
$query = mysql_query($sql, $conn);
#########Produkt abfragen
$sql = sprintf("SELECT sii_main.id as id, sii_main.cms_artnrde as cms_artnrde, sii_main.pgnr as pgnr,sii_main.knr as knr FROM sii_main,sii_var_comb WHERE sii_main.id = sii_var_comb.sii_main AND sii_main.cms_artnrde = %s LIMIT 0,1 ",
$de_item
);
$res = mysql_query($sql, $conn);
$treffer = mysql_num_rows($res);
$produkt = mysql_fetch_array($res);
if($treffer >= 1 ){ //wenn PGNr in sii_main vorhanden
//Headparameter Template abfragen
$sql = sprintf("SELECT * FROM sii_pg WHERE pgnr = %s",
$produkt['pgnr']
);
$res2 = mysql_query($sql, $conn);
$sii_pg = mysql_fetch_array($res2); // Template = $sii_pg['pdf_template']
//echo $sql."
";
//Headparameter Seite/Frame abfragen
$sql = sprintf("SELECT * FROM sii_pdfout_templates WHERE id = %s",
//$sii_pg['pdf_template']
$template
);
$res3 = mysql_query($sql, $conn);
$sii_pdfout_templates = mysql_fetch_array($res3); //Artikel pro Frame = $sii_pdfout_templates['prod_per_frame'] //Frame pro Seite = $sii_pdfout_templates['frame_per_page']
//echo $sql."
";
$frame = 1;
//while($produkt = mysql_fetch_array($res)){ //pro Produkt der PG Details abfragen und ausgeben
//Ausgabe nur wenn b2b_ch = 1
$sqlx = sprintf("SELECT * FROM sii_var_comb WHERE sii_main = %s AND b2b_ch = 1",
$produkt['id']
);
$resx = mysql_query($sqlx, $conn);
$trefx = mysql_num_rows($resx);
if($trefx >= 1){
//text_pageheader:
//Abfrage Text der Sprachversion
//Headline
$sql = sprintf("SELECT * FROM www_content_main,%s WHERE id= ids AND artnrde = %s AND headline !=''",
$sprachtab,
$produkt['cms_artnrde']
);
$res5 = mysql_query($sql, $conn);
$tref5 = mysql_num_rows($res5);
if($tref5 >= 1){
$content_main = mysql_fetch_array($res5);
//text_longtext:
$sql = sprintf("SELECT pdfconfig_cols FROM sii_config WHERE id = 1");
$ergX = mysql_query($sql, $conn);
$pdf_cols = mysql_fetch_array($ergX);
//$wordwraptext = wordwrap($content_main['text'],$pdf_cols['pdfconfig_cols'] ,"|||");
//$wordwraptext=str_replace(array("\r","\n","
","
","
"),array("","","",""),$wordwraptext);
$wordwraptext = $content_main['text'];
}else{
$sql = sprintf("SELECT * FROM www_content_main,www_content_german_de WHERE id= ids AND artnrde = %s",
$produkt['cms_artnrde']
);
$res5 = mysql_query($sql, $conn);
$content_main = mysql_fetch_array($res5);
//text_longtext:
$sql = sprintf("SELECT pdfconfig_cols FROM sii_config WHERE id = 1");
$ergX = mysql_query($sql, $conn);
$pdf_cols = mysql_fetch_array($ergX);
//$wordwraptext = wordwrap($content_main['text'],$pdf_cols['pdfconfig_cols'] ,"|||");
//$wordwraptext=str_replace(array("\r","\n","
","
","
"),array("","","",""),$wordwraptext);
$wordwraptext = $content_main['text'];
}
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,0,'text_pagehead','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
mysql_real_escape_string($content_main['headline'])
);
mysql_query($sql,$conn);
//text_longtext:
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,1,'text_longtext','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
mysql_real_escape_string($wordwraptext)
);
mysql_query($sql,$conn);
//text_pagefooter:
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,0,'text_pagefooter','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
mysql_real_escape_string($sii_pg_text['pdf_footer'])
);
mysql_query($sql,$conn);
//identifier:
$datum = date("Ymd");
$identifier = $datum." ".$_SESSION["isolkz"].$_SESSION["lkz2out"]; //WEBSEITE
/*
//oder
$identifier = $datum." ".$language.$language;
*/
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,0,'identifier','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$identifier
);
mysql_query($sql,$conn);
$test = $seite_nr % 2;
if ($test == 0) { // = gerade Seiten Zahl
//text_pageleft:
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,0,'text_pageleft','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$seite_nr
);
mysql_query($sql,$conn);
//text_pageright:
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,0,'text_pageright','')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr
);
mysql_query($sql,$conn);
}else{ //= ungerade Seiten zahl
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,0,'text_pageleft','')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr
);
mysql_query($sql,$conn);
//text_pageright:
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,0,'text_pageright','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$seite_nr
);
mysql_query($sql,$conn);
}
mysql_query("UNLOCK TABLES",$conn);
// ENDE Header/Footer (Frame 0)schreiben
//Produktdaten pro Frame ausgeben
//text_product1
//Headline
$sql = sprintf("SELECT * FROM www_content_main,%s WHERE id= ids AND artnrde = %s AND headline !=''",
$sprachtab,
$produkt['cms_artnrde']
);
$res5 = mysql_query($sql, $conn);
$tref5 = mysql_num_rows($res5);
if($tref5 >= 1){
$content_main = mysql_fetch_array($res5);
}else{
$sql = sprintf("SELECT * FROM www_content_main,www_content_german_de WHERE id= ids AND artnrde = %s",
$produkt['cms_artnrde']
);
$res5 = mysql_query($sql, $conn);
$content_main = mysql_fetch_array($res5);
}
$db_text_product1 = $content_main['headline']; //NEU
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,%s,'text_product1','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$frame,
mysql_real_escape_string($db_text_product1)
);
mysql_query($sql,$conn);
mysql_query("UNLOCK TABLES",$conn);
//text_product2
$sql = sprintf("SELECT * FROM sii_prod_textmoduls WHERE sii_main = %s AND type = 1",
$produkt['id']
);
$res8 = mysql_query($sql, $conn);
$sii_prod_textmoduls = mysql_fetch_array($res8);
$sql = sprintf("SELECT * FROM sii_textmodul_text WHERE id_sii_textmodul = %s AND language = '%s' AND name !=''",
$sii_prod_textmoduls['sii_textmodul'],
$language
);
$res9 = mysql_query($sql, $conn);
$tref9 = mysql_num_rows($res9);
if($tref9 >= 1 ){
$sii_textmodul_text = mysql_fetch_array($res9);
}else{ //wenn nicht vorhanden DE anzeigen
$sql = sprintf("SELECT * FROM sii_textmodul_text WHERE id_sii_textmodul = %s AND language = 'DE'",
$sii_prod_textmoduls['sii_textmodul']
);
$res9 = mysql_query($sql, $conn);
$sii_textmodul_text = mysql_fetch_array($res9);
}
$db_text_product2 = $sii_textmodul_text['name'];
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,%s,'text_product2','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$frame,
mysql_real_escape_string($db_text_product2)
);
mysql_query($sql,$conn);
mysql_query("UNLOCK TABLES",$conn);
//inclusive
//Auswahl der Inklusive Artikel: Tabelle sii_ref_pp --> oblig=1
$sql = sprintf("SELECT sii_ref_pp.id_main_sub AS id_main_sub FROM sii_ref_pp,sii_main WHERE sii_ref_pp.id_main_set = %s AND sii_ref_pp.oblig =1 AND sii_ref_pp.id_main_sub = sii_main.id ORDER BY sii_main.pgnr asc,sii_main.knr asc ",
$produkt['id']
); // ORDER BY sii_main.pgnr asc, sii_main.knr asc
$res11 = mysql_query($sql, $conn);
$tref2 = mysql_num_rows($res11);
if($tref2 >= 1){ //wenn es Inklusive Artikel gibt:
//Bezeichnung aus sii_transl
$sql = sprintf("SELECT * FROM sii_transl WHERE variable = 'sii_templ_include' AND language = '%s' AND name_language !=''",
$language
);
$res10 = mysql_query($sql, $conn);
$tref10 = mysql_num_rows($res10);
//wenn nicht vorhanden DE anzeigen
if($tref10 >= 1){
$sii_templ_include = mysql_fetch_array($res10);
}else{
$sql = sprintf("SELECT * FROM sii_transl WHERE variable = 'sii_templ_include' AND language = 'DE'");
$res10 = mysql_query($sql, $conn);
$sii_templ_include = mysql_fetch_array($res10);
}
$db_inclusive = $sii_templ_include['name_language']."|||";
while($oblig = mysql_fetch_array($res11)){
//Abfrage Text
$sql = sprintf("SELECT * FROM sii_main WHERE id = %s",
$oblig['id_main_sub']
);
$res12 = mysql_query($sql, $conn);
$sii_main_oblig = mysql_fetch_array($res12);
$sql = sprintf("SELECT * FROM www_content_main,%s WHERE id= ids AND artnrde = %s AND headline !=''",
$sprachtab,
$sii_main_oblig['cms_artnrde']
);
$res13 = mysql_query($sql, $conn);
$tref13a = mysql_num_rows($res13);
if($tref13a >= 1){
$text_oblig = mysql_fetch_array($res13);
}else{
$sql = sprintf("SELECT * FROM www_content_main,www_content_german_de WHERE id= ids AND artnrde = %s",
$sii_main_oblig['cms_artnrde']
);
$res13 = mysql_query($sql, $conn);
$text_oblig = mysql_fetch_array($res13);
}
if(!$text_oblig['headline']){
$db_inclusive .= " |||";
}else{
$db_inclusive .= "• ".$text_oblig['headline']."|||";
}
}
}else{
$db_inclusive ="";
}
$db_inclusive_final = substr($db_inclusive, 0, -3);
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,%s,'inclusive','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$frame,
mysql_real_escape_string($db_inclusive_final)
);
mysql_query($sql,$conn);
mysql_query("UNLOCK TABLES",$conn);
//specials
$tref4 = 0;
$tref15 = 0;
//Auswahl der specials: Tabelle sii_textmodul
$sql = sprintf("SELECT * FROM sii_prod_textmoduls,sii_textmodul WHERE sii_prod_textmoduls.sii_textmodul = sii_textmodul.id AND sii_prod_textmoduls.sii_main = %s AND sii_prod_textmoduls.type = 2 ORDER BY sii_textmodul.sort",
$produkt['id']
);
$res14 = mysql_query($sql, $conn);
$tref4 = mysql_num_rows($res14);
if($tref4 >= 1){ //wenn es specials gibt:
//Bezeichnung aus sii_transl
$sql = sprintf("SELECT * FROM sii_transl WHERE variable = 'sii_templ_specials' AND language = '%s' AND name_language !=''",
$language
);
$res15 = mysql_query($sql, $conn);
$tref15 = mysql_num_rows($res15);
if($tref15 <= 0){ //wenn nicht vorhanden DE anzeigen
$sql = sprintf("SELECT * FROM sii_transl WHERE variable = 'sii_templ_specials' AND language = 'DE'");
$res15 = mysql_query($sql, $conn);
$sii_templ_specials = mysql_fetch_array($res15);
}else{ //gewählte Sprachversion anzeigen
$sii_templ_specials = mysql_fetch_array($res15);
}
$db_specials = $sii_templ_specials['name_language']."|||";
//Specials
while($specials = mysql_fetch_array($res14)){
$tref16 = 0;
$sql = sprintf("SELECT * FROM sii_textmodul_text WHERE id_sii_textmodul = %s AND language = '%s' AND name !=''",
$specials['sii_textmodul'],
$language
);
$res16 = mysql_query($sql, $conn);
$tref16 = mysql_num_rows($res16);
if($tref16 <= 0){ //wenn nicht vorhanden DE anzeigen
$sql = sprintf("SELECT * FROM sii_textmodul_text WHERE id_sii_textmodul = %s AND language = 'DE'",
$specials['sii_textmodul']
);
$res16a = mysql_query($sql, $conn);
$sii_textmodul_text2 = mysql_fetch_array($res16a);
}else{ //gewählte Sprachversion anzeigen
$sii_textmodul_text2 = mysql_fetch_array($res16);
}
if(!$sii_textmodul_text2['name']){
$db_specials .= " |||";
}else{
$wordwraptext = "";
$wordwraptext = wordwrap($sii_textmodul_text2['name'],$pdf_cols['pdfconfig_cols'] ,"||| ");
$db_specials .= "• ".$wordwraptext."|||";
}
}
}else{
$db_specials ="";
}
$db_specials_final = substr($db_specials, 0, -3);
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,%s,'specials','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$frame,
mysql_real_escape_string($db_specials_final)
);
mysql_query($sql,$conn);
mysql_query("UNLOCK TABLES",$conn);
//Optionen
$tref5 = 0;
//Auswahl der Optionsartikel Artikel: Tabelle sii_ref_pp --> option = 1
$sql = sprintf("SELECT sii_ref_pp.id_main_sub AS id_main_sub FROM sii_ref_pp,sii_main WHERE sii_ref_pp.id_main_set = %s AND sii_ref_pp.option = 1 AND sii_ref_pp.id_main_sub = sii_main.id ORDER BY sii_main.pgnr asc,sii_main.knr asc",
$produkt['id']
);
$res17 = mysql_query($sql, $conn);
$tref5 = mysql_num_rows($res17);
if($tref5 >= 1){ //wenn es Inklusive Artikel gibt:
//Bezeichnung aus sii_transl
$sql = sprintf("SELECT * FROM sii_transl WHERE variable = 'sii_templ_options' AND language = '%s' AND name_language !=''",
$language
);
$res18 = mysql_query($sql, $conn);
$tref18 = mysql_num_rows($res18);
if($tref18 <= 0){ //wenn nicht vorhanden DE anzeigen
$sql = sprintf("SELECT * FROM sii_transl WHERE variable = 'sii_templ_options' AND language = 'DE'");
$res18 = mysql_query($sql, $conn);
$sii_templ_options = mysql_fetch_array($res18);
}else{ //gewählte Sprachversion anzeigen
$sii_templ_options = mysql_fetch_array($res18);
}
$db_options = $sii_templ_options['name_language']."|||";
while($options = mysql_fetch_array($res17)){
$tref20a = 0;
//Abfrage Text
$sql = sprintf("SELECT * FROM sii_main WHERE id = %s",
$options['id_main_sub']
);
$res19 = mysql_query($sql, $conn);
$sii_main_options = mysql_fetch_array($res19);
$sql = sprintf("SELECT * FROM www_content_main,%s WHERE id= ids AND artnrde = %s AND headline !=''",
$sprachtab,
$sii_main_options['cms_artnrde']
);
$res20 = mysql_query($sql, $conn);
$tref20a = mysql_num_rows($res20);
if($tref20a <= 0){
$sql = sprintf("SELECT * FROM www_content_main,www_content_german_de WHERE id= ids AND artnrde = %s",
$sii_main_options['cms_artnrde']
);
$res20b = mysql_query($sql, $conn);
$text_options = mysql_fetch_array($res20b);
}else{
$text_options = mysql_fetch_array($res20);
}
//Neu
if(!$text_options['headline']){
$db_options .= "";
}else{
$wordwraptext = "";
$wordwraptext = wordwrap($text_options['headline'],$pdf_cols['pdfconfig_cols'] ,"||| ");
$db_options .= "• ".$wordwraptext."|||";
}
}
}else{
$db_options ="";
}
$db_options_final = substr($db_options, 0, -3); //NEU
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,%s,'options','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$frame,
mysql_real_escape_string($db_options_final)
);
mysql_query($sql,$conn);
mysql_query("UNLOCK TABLES",$conn);
//Varianten anzeigen
$sql = sprintf("SELECT * FROM sii_var_ref WHERE sii_main = %s GROUP BY vartyp_cms",
$produkt['id']
);
$res22 = mysql_query($sql, $conn);
$anz = 1;
while($variantentyp = mysql_fetch_array($res22)){
if(($anz==1)OR($anz==2)){
$db_vartyp = "VarText1_".$anz; // Varianten 1 + 2 Bezeichnung der Spalte: Tabelle "sii_pdfout"
}
if($anz==3){
$db_vartyp = "VarText".$anz."_1"; //Farben: Bezeichnung der Spalte: Tabelle "sii_pdfout"
}
//Wert für Bezeichnung abfragen
$sql = sprintf("SELECT * FROM sii_vartypes WHERE vartype = %s",
$variantentyp['vartyp_cms']
);
$res23 = mysql_query($sql, $conn);
$cms_var_typ = mysql_fetch_array($res23);
$sql = sprintf("SELECT * FROM sii_vartypes_text WHERE id_vartype = %s AND language = '%s' AND name !=''",
$cms_var_typ['id'],
$language
);
$res24 = mysql_query($sql, $conn);
$tref24 = mysql_num_rows($res24);
if($tref24 <= 0){ //wenn nicht vorhanden DE anzeigen
$sql = sprintf("SELECT * FROM sii_vartypes_text WHERE id_vartype = %s AND language = 'DE'",
$cms_var_typ['id']
);
$res24 = mysql_query($sql, $conn);
$db_vartypname = mysql_fetch_array($res24);
}else{ //gewählte Sprachversion anzeigen
$db_vartypname = mysql_fetch_array($res24);
}
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,%s,'%s','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$frame,
$db_vartyp,
mysql_real_escape_string($db_vartypname['name'])
);
mysql_query($sql,$conn);
mysql_query("UNLOCK TABLES",$conn);
// Füllen der Werte Spalten
$sql = sprintf("SELECT * FROM sii_var_ref WHERE sii_main = %s AND vartyp_cms= %s Group BY varity_cms ASC ",
$produkt['id'],
$variantentyp['vartyp_cms']
);
$res25 = mysql_query($sql, $conn);
//nur Vartyp 1 + 2
if(($anz==1)OR($anz==2)){
while($varity = mysql_fetch_array($res25)){
//Wert für Bezeichnung abfragen
$sql = sprintf("SELECT * FROM sii_varities WHERE idab2var = %s",
$varity['varity_cms']
);
$res26 = mysql_query($sql, $conn);
$cms_varity = mysql_fetch_array($res26);
$sql = sprintf("SELECT * FROM sii_varities_text WHERE id_varities = %s AND language = '%s' AND name_pdfpl !=''",
$cms_varity['id'],
$language
);
$res26 = mysql_query($sql, $conn);
$tref26 = mysql_num_rows($res26);
if($tref26 <= 0){ //wenn nicht vorhanden DE anzeigen
$sql = sprintf("SELECT * FROM sii_varities_text WHERE id_varities = %s AND language = 'DE'",
$cms_varity['id']
);
$res26 = mysql_query($sql, $conn);
$db_varityname = mysql_fetch_array($res26); // = $db_varityname['name']
}else{ //gewählte Sprachversion anzeigen
$db_varityname = mysql_fetch_array($res26); // = $db_varityname['name']
}
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,%s,'%s','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$frame,
$cms_varity['PDF_variable'],
mysql_real_escape_string($db_varityname['name_pdfpl'])
);
mysql_query($sql,$conn);
mysql_query("UNLOCK TABLES",$conn);
}
}
if($anz == 3){ //nur Farben
$farben ="";
while($varity = mysql_fetch_array($res25)){
//Wert für Bezeichnung abfragen
$sql = sprintf("SELECT * FROM sii_varities WHERE idab2var = %s",
$varity['varity_cms']
);
$res26 = mysql_query($sql, $conn);
$cms_varity = mysql_fetch_array($res26);
$sql = sprintf("SELECT * FROM sii_varities_text WHERE id_varities = %s AND language = '%s' AND name_pdfpl !=''",
$cms_varity['id'],
$language
);
$res26 = mysql_query($sql, $conn);
$tref26 = mysql_num_rows($res26);
if($tref26 <= 0){ //wenn nicht vorhanden DE anzeigen
$sql = sprintf("SELECT * FROM sii_varities_text WHERE id_varities = %s AND language = 'DE'",
$cms_varity['id']
);
$res26 = mysql_query($sql, $conn);
$db_varityname = mysql_fetch_array($res26); // = $db_varityname['name']
}else{ //gewählte Sprachversion anzeigen
$db_varityname = mysql_fetch_array($res26); // = $db_varityname['name']
}
$farben .= $db_varityname['name_pdfpl'].", ";
}
$farben_final = substr($farben, 0, -2);
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,%s,'VarText3_2','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$frame,
mysql_real_escape_string($farben_final)
);
mysql_query($sql,$conn);
mysql_query("UNLOCK TABLES",$conn);
}
$anz++;
}
//product_image1
$sql = sprintf("SELECT * FROM wBDB_img_pl WHERE www_content_main_id = %s AND img_pl = 1",
$content_main['id']
);
$res27 = mysql_query($sql, $conn);
$tref27 = mysql_num_rows($res27);
$image1 = mysql_fetch_array($res27);
if($tref27 >= 1){
$image1final = $image1['img_nr'].".jpg";
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,%s,'product_image1','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$frame,
$image1final
);
mysql_query($sql,$conn);
mysql_query("UNLOCK TABLES",$conn);
}
//product_image2
$sql = sprintf("SELECT * FROM wBDB_img_pl WHERE www_content_main_id = %s AND img_pl = 2",
$content_main['id']
);
$res27 = mysql_query($sql, $conn);
$tref27b = mysql_num_rows($res27);
$image2 = mysql_fetch_array($res27);
if($tref27b >= 1){
$image1final2 = $image2['img_nr'].".jpg";
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,%s,'product_image2','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$frame,
$image1final2
);
mysql_query($sql,$conn);
mysql_query("UNLOCK TABLES",$conn);
}
//product_image3
$sql = sprintf("SELECT * FROM wBDB_img_pl WHERE www_content_main_id = %s AND img_pl = 3",
$content_main['id']
);
$res27 = mysql_query($sql, $conn);
$tref27c = mysql_num_rows($res27);
$image3 = mysql_fetch_array($res27);
if($tref27c >= 1){
$image1final3 = $image3['img_nr'].".jpg";
mysql_query("LOCK TABLES pdfout",$conn);
$sql = sprintf("INSERT INTO %s (pl_type,active,template,page,frame,variable,content) VALUES (%s,%s,%s,%s,%s,'product_image3','%s')",
$databank,
$pl_type,
$active,
$sii_pg['pdf_singlepage'],
$seite_nr,
$frame,
$image1final3
);
mysql_query($sql,$conn);
mysql_query("UNLOCK TABLES",$conn);
}
#####################################
//Daten für Seiten bzw. Frame Angaben
$frame++;
$checkframe = $frame; //wg. Problem beim "Seiten weiterzählen" wenn Frame = 3 und Ende der Produkte pro PGNR-Abfragen
if($frame > $sii_pdfout_templates['frame_per_page'] ){ //max. Frames pro Seite
$frame = 1;
$seite_nr++;
}
}//Ende Abfrage b2b_ch = 1
} //Ende while
header ("Location: ../../sii/PLpdf/createpdf.php?templateId=51&catid=1&page=1&show=1");
?>