session_start();
$die_text = "
User error
For generate this PDF document use link from buy-auto.eu website.";
//$ad = 142;
if(empty($ad)) die("1".$die_text);
if(empty($_SESSION['lang'])) die("2".$die_text);
if(file_exists("languages/".$_SESSION['lang']."/index_".$_SESSION['lang'].".php"))
require("languages/".$_SESSION['lang']."/index_".$_SESSION['lang'].".php");
else
die("3".$die_text);
require('pdf/fpdf.php');
require("funkce/user.php");
$DBHost="c172um.forpsi.com";
$DBUser="buy_autoeu";
$DBPass="bEFrk346";
$konto=@mysql_connect("$DBHost","$DBUser","$DBPass");
if(!$konto):
die("4".$die_text);
else:
MySQL_Select_DB("buy_autoeu");
endif;
$ad = (int) $ad;
$sql = "SELECT *
FROM `inzeraty_vypis`, `inzeraty_vybava`
WHERE 1
AND (`aktivni` = 1)
AND (inzeraty_vybava.id = inzeraty_vypis.id)
AND (inzeraty_vypis.id = $ad)";
$v = MySQL_Fetch_Array(MySQL_Query($sql));
if(!$v): die("5".$die_text);
elseif($v["aktivni"] == 0): die("6".$die_text);
else:
/// --- VŠECHNO OK, DATA NAČTENA Z DB --
$pdf=new FPDF('P','mm','A4');
$pdf->AddPage();
$pdf->Image('images/biglogo.png',10,10, 60,9, "PNG","http://www.buy-auto.eu/");
$pdf->SetFont('Arial','IB',22);
$pdf->SetTextColor(200,4,28);
$pdf->Cell(10,50,SubStr($v["vypis"],0,35));
$pdf->SetTextColor(0,0,0);
$pdf->SetFont('Arial','',10);
$pdf->Write(5,"\n\n\n\n\n\n\n");
// cena
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_8: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,Number_Format($v["cena"], 0, "", ".")." EUR\n");
// cena pro export
if($v["cena_export"]):
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_106: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,Number_Format($v["cena_export"], 0, "", ".")." EUR\n");
endif;
// kategorie
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_1: ");
switch($v["kategorie"]):
case 1:
$kat = $text_ad_pu_2;
break;
case 2:
$kat = $text_ad_pu_3;
break;
case 3:
$kat = $text_ad_pu_4;
break;
case 4:
$kat = $text_ad_pu_5;
break;
endswitch;
$pdf->SetFont('Arial','',10);
$pdf->Write(5,"$kat \n");
// země prodeje
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_65a: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$v["zeme"]. "\n");
// karoserie
switch($v["karoserie"]):
case 1:
$kar = $text_ad_pu_22;
break;
case 2:
$kar = $text_ad_pu_23;
break;
case 3:
$kar = $text_ad_pu_24;
break;
case 4:
$kar = $text_ad_pu_25;
break;
case 5:
$kar = $text_ad_pu_26;
break;
case 6:
$kar = $text_ad_pu_27;
break;
case 7:
$kar = $text_ad_pu_28;
break;
case 8:
$kar = $text_ad_pu_29;
break;
case 9:
$kar = $text_ad_pu_30;
break;
endswitch;
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_21: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$kar. "\n");
// barva
if($v["barva_2"]):
switch($v["barva_2"]):
case 1:
$bar1 = $text_ad_pu_51;
break;
case 2:
$bar1 = $text_ad_pu_52;
break;
case 3:
$bar1 = $text_ad_pu_53;
break;
case 4:
$bar1 = $text_ad_pu_54;
break;
case 5:
$bar1 = $text_ad_pu_55;
break;
case 6:
$bar1 = $text_ad_pu_56;
break;
case 7:
$bar1 = $text_ad_pu_57;
break;
case 8:
$bar1 = $text_ad_pu_58;
break;
case 9:
$bar1 = $text_ad_pu_59;
break;
case 10:
$bar1 = $text_ad_pu_60;
break;
case 11:
$bar1 = $text_ad_pu_61;
break;
case 12:
$bar1 = $text_ad_pu_62;
break;
case 13:
$bar1 = $text_ad_pu_63;
break;
case 14:
$bar1 = $text_ad_pu_64;
break;
endswitch;
switch($v["barva_1"]):
case 1:
$bar2 = $text_ad_pu_47;
break;
case 2:
$bar2 = $text_ad_pu_48;
break;
case 3:
$bar2 = $text_ad_pu_49;
break;
case 4:
$bar2 = $text_ad_pu_50;
break;
endswitch;
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_46: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$bar1." ".$bar2."\n");
endif;
// rok
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_12: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$v["rok"]."\n");
// do provozu
if($v["doprovozu"]):
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_33: ");
$pdf->SetFont('Arial','',10);
if($v["doprovozu_m"]) $pdf->Write(5,$v["doprovozu_m"]."/");
$pdf->Write(5,$v["doprovozu"]."\n");
endif;
// najeto
if($v["najeto_unit"] == 1)
$mil = Number_Format($v["najeto_km"], 0, "", ".")." km";
else
$mil = Number_Format($v["najeto_mi"], 0, "", ".")." mi";
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_9: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$mil."\n");
// stav
if($v["stav"]):
switch($v["stav"]):
case 1:
$stav = $text_ad_pu_35;
break;
case 2:
$stav = $text_ad_pu_36;
break;
case 3:
$stav = $text_ad_pu_37;
break;
case 4:
$stav = $text_ad_pu_38;
break;
case 5:
$stav = $text_ad_pu_39;
break;
case 6:
$stav = $text_ad_pu_40;
break;
endswitch;
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_34: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$stav."\n");
endif;
// palivo
switch($v["palivo"]):
case 1:
$pal = $text_ad_pu_14;
break;
case 2:
$pal = $text_ad_pu_15;
break;
case 3:
$pal = $text_ad_pu_16;
break;
case 4:
$pal = $text_ad_pu_17;
break;
endswitch;
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_13: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$pal."\n");
// objem
if($v["objem"]):
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_42: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,Number_Format($v["objem"], 0, "", ".")." ccm \n");
endif;
// vykon
if($v["vykon_kw"]):
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_208: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,Number_Format($v["vykon_kw"], 0, "", ".")." kW (".Number_Format($v["vykon_ps"], 0, "", ".")." hp) \n");
endif;
// válce
if($v["valce"]):
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_43: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,"V".$v["valce"]." \n");
endif;
// prevodovka
switch($v["prevodovka"]):
case 1:
$ger = $text_ad_pu_19;
break;
case 2:
$ger = $text_ad_pu_20;
break;
endswitch;
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_18: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$ger);
if($v["prevody"]) $pdf->Write(5," ".$v["prevody"]."°");
$pdf->Write(5,"\n");
// původ
if($v["puvod"]):
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_65: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$v["puvod"]." \n");
endif;
// dveře
if($v["dvere"]):
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_44: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$v["dvere"]." \n");
endif;
// sezeni
if($v["sezeni"]):
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_45: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$v["sezeni"]."\n");
endif;
// původ
if($v["zaruka"]):
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_105: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,$v["zaruka"]." ".$text_ad_pu_105c."\n");
endif;
// výbava
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_lista_3: ");
$pdf->SetFont('Arial','',10);
if($v["b1"]) { $pdf->Write(5,$text_ad_pu_115.", "); ++$vyb; }
if($v["b2"]) { $pdf->Write(5,$text_ad_pu_116.", "); ++$vyb; }
if($v["b3"]) { $pdf->Write(5,$text_ad_pu_117.", "); ++$vyb; }
if($v["b4"]) { $pdf->Write(5,$text_ad_pu_118.", "); ++$vyb; }
if($v["b5"]) { $pdf->Write(5,$text_ad_pu_119.", "); ++$vyb; }
if($v["b6"]) { $pdf->Write(5,$text_ad_pu_120.", "); ++$vyb; }
if($v["b7"]) { $pdf->Write(5,$text_ad_pu_121.", "); ++$vyb; }
if($v["b8"]) { $pdf->Write(5,$text_ad_pu_122.", "); ++$vyb; }
if($v["b9"]) { $pdf->Write(5,$text_ad_pu_123.", "); ++$vyb; }
if($v["b10"]) { $pdf->Write(5,$text_ad_pu_124.", "); ++$vyb; }
if($v["b11"]) { $pdf->Write(5,$text_ad_pu_125.", "); ++$vyb; }
if($v["b12"]) { $pdf->Write(5,$text_ad_pu_126.", "); ++$vyb; }
if($v["b13"]) { $pdf->Write(5,$text_ad_pu_127.", "); ++$vyb; }
if($v["b14"]) { $pdf->Write(5,$text_ad_pu_128.", "); ++$vyb; }
if($v["b15"]) { $pdf->Write(5,$text_ad_pu_129.", "); ++$vyb; }
if($v["b16"]) { $pdf->Write(5,$text_ad_pu_130.", "); ++$vyb; }
if($v["b17"]) { $pdf->Write(5,$text_ad_pu_131.", "); ++$vyb; }
if($v["b18"]) { $pdf->Write(5,$text_ad_pu_132.", "); ++$vyb; }
if($v["b19"]) { $pdf->Write(5,$text_ad_pu_133.", "); ++$vyb; }
if($v["a1"]) { $pdf->Write(5,$text_ad_pu_135.", "); ++$vyb; }
if($v["a2"]) { $pdf->Write(5,$text_ad_pu_136.", "); ++$vyb; }
if($v["a3"]) { $pdf->Write(5,$text_ad_pu_137.", "); ++$vyb; }
if($v["a4"]) { $pdf->Write(5,$text_ad_pu_138.", "); ++$vyb; }
if($v["a5"]) { $pdf->Write(5,$text_ad_pu_139.", "); ++$vyb; }
if($v["a6"]) { $pdf->Write(5,$text_ad_pu_140.", "); ++$vyb; }
if($v["a7"]) { $pdf->Write(5,$text_ad_pu_141.", "); ++$vyb; }
if($v["a8"]) { $pdf->Write(5,$text_ad_pu_142.", "); ++$vyb; }
if($v["a9"]) { $pdf->Write(5,$text_ad_pu_143.", "); ++$vyb; }
if($v["a10"]) { $pdf->Write(5,$text_ad_pu_144.", "); ++$vyb; }
if($v["z1"]) { $pdf->Write(5,$text_ad_pu_146.", "); ++$vyb; }
if($v["z2"]) { $pdf->Write(5,$text_ad_pu_147.", "); ++$vyb; }
if($v["z3"]) { $pdf->Write(5,$text_ad_pu_148.", "); ++$vyb; }
if($v["z4"]) { $pdf->Write(5,$text_ad_pu_149.", "); ++$vyb; }
if($v["z5"]) { $pdf->Write(5,$text_ad_pu_150.", "); ++$vyb; }
if($v["z6"]) { $pdf->Write(5,$text_ad_pu_151.", "); ++$vyb; }
if($v["z7"]) { $pdf->Write(5,$text_ad_pu_152.", "); ++$vyb; }
if($v["z8"]) { $pdf->Write(5,$text_ad_pu_153.", "); ++$vyb; }
if($v["v1"]) { $pdf->Write(5,$text_ad_pu_155.", "); ++$vyb; }
if($v["v2"]) { $pdf->Write(5,$text_ad_pu_156.", "); ++$vyb; }
if($v["v3"]) { $pdf->Write(5,$text_ad_pu_157.", "); ++$vyb; }
if($v["v4"]) { $pdf->Write(5,$text_ad_pu_158.", "); ++$vyb; }
if($v["v5"]) { $pdf->Write(5,$text_ad_pu_159.", "); ++$vyb; }
if($v["v6"]) { $pdf->Write(5,$text_ad_pu_160.", "); ++$vyb; }
if($v["v7"]) { $pdf->Write(5,$text_ad_pu_161.", "); ++$vyb; }
if($v["v8"]) { $pdf->Write(5,$text_ad_pu_162.", "); ++$vyb; }
if($v["v9"]) { $pdf->Write(5,$text_ad_pu_163.", "); ++$vyb; }
if($v["v10"]) { $pdf->Write(5,$text_ad_pu_164.", "); ++$vyb; }
if($v["v11"]) { $pdf->Write(5,$text_ad_pu_165.", "); ++$vyb; }
if($v["v12"]) { $pdf->Write(5,$text_ad_pu_166.", "); ++$vyb; }
if($v["v13"]) { $pdf->Write(5,$text_ad_pu_167.", "); ++$vyb; }
if($v["v14"]) { $pdf->Write(5,$text_ad_pu_168.", "); ++$vyb; }
if($v["i1"]) { $pdf->Write(5,$text_ad_pu_170.", "); ++$vyb; }
if($v["i2"]) { $pdf->Write(5,$text_ad_pu_171.", "); ++$vyb; }
if($v["i3"]) { $pdf->Write(5,$text_ad_pu_172.", "); ++$vyb; }
if($v["i4"]) { $pdf->Write(5,$text_ad_pu_173.", "); ++$vyb; }
if($v["i5"]) { $pdf->Write(5,$text_ad_pu_174.", "); ++$vyb; }
if($v["i6"]) { $pdf->Write(5,$text_ad_pu_175.", "); ++$vyb; }
if($v["i7"]) { $pdf->Write(5,$text_ad_pu_176.", "); ++$vyb; }
if($v["i8"]) { $pdf->Write(5,$text_ad_pu_177.", "); ++$vyb; }
if($v["i9"]) { $pdf->Write(5,$text_ad_pu_178.", "); ++$vyb; }
if($v["i10"]) { $pdf->Write(5,$text_ad_pu_179.", "); ++$vyb; }
if($v["i11"]) { $pdf->Write(5,$text_ad_pu_180.", "); ++$vyb; }
if($v["i12"]) { $pdf->Write(5,$text_ad_pu_181.", "); ++$vyb; }
if($v["i13"]) { $pdf->Write(5,$text_ad_pu_182.", "); ++$vyb; }
if($v["i14"]) { $pdf->Write(5,$text_ad_pu_183.", "); ++$vyb; }
if($v["i15"]) { $pdf->Write(5,$text_ad_pu_184.", "); ++$vyb; }
if($v["j1"]) { $pdf->Write(5,$text_ad_pu_186.", "); ++$vyb; }
if($v["j2"]) { $pdf->Write(5,$text_ad_pu_187.", "); ++$vyb; }
if($v["j3"]) { $pdf->Write(5,$text_ad_pu_188.", "); ++$vyb; }
if($v["j4"]) { $pdf->Write(5,$text_ad_pu_189.", "); ++$vyb; }
if($v["j5"]) { $pdf->Write(5,$text_ad_pu_190.", "); ++$vyb; }
if($v["j6"]) { $pdf->Write(5,$text_ad_pu_191.", "); ++$vyb; }
if($v["j7"]) { $pdf->Write(5,$text_ad_pu_192.", "); ++$vyb; }
if($v["j8"]) { $pdf->Write(5,$text_ad_pu_193.", "); ++$vyb; }
if($v["j9"]) { $pdf->Write(5,$text_ad_pu_194.", "); ++$vyb; }
if($v["j10"]) { $pdf->Write(5,$text_ad_pu_195.", "); ++$vyb; }
if($v["j11"]) { $pdf->Write(5,$text_ad_pu_196.", "); ++$vyb; }
if($v["o1"]) { $pdf->Write(5,$text_ad_pu_198.", "); ++$vyb; }
if($v["o2"]) { $pdf->Write(5,$text_ad_pu_199.", "); ++$vyb; }
if($v["o3"]) { $pdf->Write(5,$text_ad_pu_200.", "); ++$vyb; }
if($v["o4"]) { $pdf->Write(5,$text_ad_pu_201.", "); ++$vyb; }
if($v["o5"]) { $pdf->Write(5,$text_ad_pu_202.", "); ++$vyb; }
if($v["o6"]) { $pdf->Write(5,$text_ad_pu_203.", "); ++$vyb; }
if($v["o7"]) { $pdf->Write(5,$text_ad_pu_204.", "); ++$vyb; }
if($v["o8"]) { $pdf->Write(5,$text_ad_pu_205.", "); ++$vyb; }
if($v["o9"]) { $pdf->Write(5,$text_ad_pu_206.", "); ++$vyb; }
if($v["o10"]) { $pdf->Write(5,$text_ad_pu_209.", "); ++$vyb; }
if($v["o11"]) { $pdf->Write(5,$text_ad_pu_210.", "); ++$vyb; }
if($vyb)
$pdf->Write(5,"\n");
else
$pdf->Write(5,$pdf_t1."\n");
// financování
if( $v["f_hotovost"]
or $v["f_prevod"]
or $v["f_karta"]
or $v["f_uver"]
or $v["f_leasing"]
or $v["f_operleasing"]
or $v["f_protiucet"]
or $v["f_dph"]):
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$text_ad_pu_107: ");
$pdf->SetFont('Arial','',10);
if($v["f_hotovost"]) $pdf->Write(5,$text_ad_pu_108.", ");
if($v["f_prevod"]) $pdf->Write(5,$text_ad_pu_109.", ");
if($v["f_karta"]) $pdf->Write(5,$text_ad_pu_109b.", ");
if($v["f_uver"]) $pdf->Write(5,$text_ad_pu_110.", ");
if($v["f_leasing"]) $pdf->Write(5,$text_ad_pu_111.", ");
if($v["f_operleasing"]) $pdf->Write(5,$text_ad_pu_112.", ");
if($v["f_protiucet"]) $pdf->Write(5,$text_ad_pu_113.", ");
if($v["f_dph"]) $pdf->Write(5,$text_ad_pu_113a);
$pdf->Write(5,"\n\n");
else: $pdf->Write(5,"\n");
endif;
$pocetobr = pocetobrazku($v["id"]);
if($pocetobr):
$updir = (string) ((int) ($id/1000));
$pdf->Image('photos/'.$updir.'/'.$v["id"].'/1-1.jpg',130,45, 0,48, "JPG");
endif;
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$pdf_t2: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,"http://www.buy-auto.eu/index.php?page=advertiser&user=".$v["uzivatel"]."\n","http://www.buy-auto.eu/index.php?page=advertiser&user=".$v["uzivatel"]);
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$pdf_t3: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,"http://www.buy-auto.eu/index.php?page=ad_detail&ad=".$v["id"]."\n","http://www.buy-auto.eu/index.php?page=ad_detail&ad=".$v["id"]);
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,"$pdf_t4: ");
$pdf->SetFont('Arial','',10);
$pdf->Write(5,date("m.d.y G:i:s T")."\n\n");
$pdf->SetFont('Arial','I',5);
$pdf->Write(5,"Copyright © 2006-".date("y")." Buy-auto.eu");
$pdf->Output();
endif;
?>