prepare($sql0); $stmt->execute(); $f = $stmt->fetch(PDO::FETCH_ASSOC); $vs= $f['vs']; $k= $f['klient_id']; $fa= $f['firma']; //firma ktera mu to poskytuje $sl= $f['sluzba_id']; $sql1="SELECT * FROM `firmy` WHERE `prefix` = $fa"; $stmt = $dbconn->prepare($sql1); $stmt->execute(); $ff = $stmt->fetch(PDO::FETCH_ASSOC); $spolecnost= $ff['spolecnost']; $s_mesto= $ff['mesto']; $s_ulice= $ff['ulice']; $s_psc= $ff['psc']; $s_telefon= $ff['telefon']; $s_email= $ff['email']; $s_ic= $ff['ic']; $s_dic= $ff['dic']; $s_ucet_cz= $ff['ucet_cz']; $s_bic_cz= $ff['bic_cz']; $sql3="SELECT * FROM `klient` WHERE `id` = $k"; $stmt = $dbconn->prepare($sql3); $stmt->execute(); $fff = $stmt->fetch(PDO::FETCH_ASSOC); $o1= $fff['firma']; $ojmeno= $fff['jmeno']; $oprijmeni= $fff['prijmeni']; if (strlen($o1)<3) $o1=$ojmeno." ".$oprijmeni; $o2= $fff['ulice']; $o4= $fff['psc']; $o3= $fff['mesto']; $o7= $fff['telefon']; $oIC= $fff['ic']; $oDIC= $fff['dic']; $sql4="SELECT * FROM `sluzba` WHERE id=$sl"; $stmt = $dbconn->prepare($sql4); $stmt->execute(); $ffff = $stmt->fetch(PDO::FETCH_ASSOC); $html_sluzba_vse = " ".$ffff["nazev"]." ".$s["domena"]." ".$s["zacatek"]." ".$ffff["delka"]." ".round($ffff["cena"]/$ffff["delka"])." ".$ffff["cena"]." Kc "; $zaplaceno_castka_DPH= $f['cena']; unset($stmt); #$sql9="SELECT * FROM `priplatky` where sluzba_klient_id=".$f['id']; #$r=mysql_query($sql9); $stmt= false; if ($stmt) { while ($f9 = $stmt->fetch(PDO::FETCH_ASSOC)) { $zaplaceno_castka_DPH +=$f9["cena_s_dph"]; $html_sluzba_vse .= " ".$f9['nazev']." 1ks ".$f9["cena_s_dph"]." Kc ".$f9["cena_s_dph"]." Kc "; } } $DPH= round($f['cena']*0.1736); $zaplaceno_castka_bez_DPH=$zaplaceno_castka_DPH-$DPH; ///////////// QR /////////////////// // include('qr/qrlib.php'); // include('qr/qrconfig.php'); $fileName=$vs.".png"; $pngAbsoluteFilePath = $tempDir.$fileName; $urlRelativeFilePath = $urlDir.$fileName; //echo "
".$pngAbsoluteFilePath; if(empty($s_bic_cz)) $s_bic_cz = "CZ0720100000002200721995"; $qrtext="SPD*1.0*ACC:".$s_bic_cz."*AM:".$zaplaceno_castka_DPH."*CC:CZK*MSG:qr platba, virt. sidlo*X-KS:0308*X-VS:".$vs."*X-SS:".$klient; if (file_exists($pngAbsoluteFilePath)) unlink($pngAbsoluteFilePath); if (!file_exists($pngAbsoluteFilePath)) { QRcode::png($qrtext, $pngAbsoluteFilePath, 'H', 4, 0); } $qr="
  

QR kod pro platbu v CZK


"; ///////////////////////// $kod2=substr(md5("fajnetoposolim".$vs), 3, 15); if ($superkod == "ab45cd46") $kod1 = $kod2; $kod_kratky =substr(md5("kratky".$vs), 3, 5); //i tak milion moznosti $soubor=$tempDir.''.$vs.'-'.$co.'-'.$kod_kratky.'.pdf'; if ($kod1 <> $kod2) { echo "kody nesedi";exit; } //////////////////////////////////////// if ($co=="vyzva") { $splatnost = date("Ymd", time() + 4*86400); $cislo_faktury=''; $info_pod_cenou=(($fa != 3)?"
Toto neni danovy doklad. Vycisleni­ DPH je informativni­
.":""); $cotoje="Objednavka - vyzva k platbe "; } $tabulka_cena = '
Celkem bez DPH'.$zaplaceno_castka_bez_DPH. ' Kc
DPH : '.$DPH.' Kc
Celkem k uhrade '.$zaplaceno_castka_DPH. ' Kc
'; if($fa == "3"){ $tabulka_cena = '
Celkem k uhrade '.$zaplaceno_castka_DPH. ' Kc
'; } ////////////// PDF VYSTUP /////////////////// ////////////// PDF VYSTUP /////////////////// $html = '

Dodavatel: '.$spolecnost .'

'.$s_ulice.' '.$s_mesto.' '.$s_stat.'

'.$s_email.', '.$s_telefon.'

IC '.$s_ic.' DIC '.$s_dic.'

'.$cotoje. ' '.$cislo_faktury.'

'.$uhradatext.' '.$kdyzaplatiltext.' '.$duzptext.'

Cislo uctu: '.$s_ucet_cz .'

Variabilni­ symbol: '.$vs.'

Konstantni­ symbol: 308

'.$splatnosttext.'

Odberatel '.$vs.'

'.$o1.'

'.$o2.'

'.$o3.' '.$o4.'

'.$o5.'

'.$oIC.'

'.$oDIC.'

'.$html_sluzba_vse.'
VEC MNOZSTVI­ Cena/jedn. Celkem
'.$tabulka_cena.'
'.$br.$br.$br.$br.'

'. $info_pod_cenou. ' '. $br ." ". $qr. ' '.$celyspodek. '

'.$s_rejstrik.'

'; //echo $html; //============================================================== //============================================================== //============================================================== require_once __DIR__ . '/vendor/autoload.php'; $mpdf = new \Mpdf\Mpdf([ "mode" => "utf-8", "margin_left" => 0, "margin_right" => 0, "margin_top" => 0, "margin_bottom" => 0, "margin_header" => 0, "margin_footer" => 0, ]); //$mpdf=new mPDF('utf-8', 'A4', 0, '', 0, 0, 0, 0, 0, 0); $mpdf->SetDisplayMode('fullpage'); $stylesheet = file_get_contents('f/banan/faktura.css'); //echo $html; exit; $mpdf->WriteHTML($stylesheet,1); // The parameter 1 tells that this is css/style only and no body/html/text $mpdf->setFooter('
strana {PAGENO} / {nbpg}
'); $mpdf->WriteHTML($html); // https://mpdf.github.io/reference/mpdf-functions/output.html //unlink($soubor); //echo $soubor;exit; //echo $soubor;exit; $mpdf->Output($soubor,"F","$vs-$co.pdf"); //$mpdf->Output($soubor,'F'); //$mpdf->Output(); //exit; //============================================================== //============================================================== //============================================================== ?>