Skip to content

Instantly share code, notes, and snippets.

@bulentsakarya

bulentsakarya/fonksyion

Created January 19, 2018 17:05
Show Gist options
  • Save bulentsakarya/b0972a5492ad9781731c10a0261940f9 to your computer and use it in GitHub Desktop.
Save bulentsakarya/b0972a5492ad9781731c10a0261940f9 to your computer and use it in GitHub Desktop.
Download ZIP
pdf
Raw
fonksyion
public function cariyazdir($id)
{
$cari = Cari::where('musteriler_id', '=', $id)->orderBy('id', 'DESC')->get();
$borc = Cari::where('musteriler_id', '=', $id)->sum('borc');
$alacak = Cari::where('musteriler_id', '=', $id)->sum('alacak');
$durum = $borc - $alacak;
$durum = number_format($durum,2,",",".");
$musteri = Musteriler::find($id);
$html = '<html lang="tr-TR"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>';
$html .= '<style type="text/css">';
$html .= '@font-face {font-family: OpenSans-Regular;src: url(fonts/OpenSans-Regular.ttf);}';
$html .= 'div.ClJ{font-family: OpenSans-Regular;}';
$html .= 'body{line-height:1.0em}';
$html .= '.clear {clear:both;}';
$html .= '.baslik {margin-bottom: 20px;width:708px;}';
$html .= '.islembaslik {float:left;color:red;width:552px;border-top:1px solid #dddddd;border-bottom:1px solid #dddddd;border-left:1px solid #dddddd;border-right:1px solid #dddddd;}';
$html .= '.fiyatbaslik {text-align:center;float:right;color:red;width:149px;border-top:1px solid #dddddd;border-bottom:1px solid #dddddd;border-right:1px solid #dddddd;}';
$html .= '</style>';
$html .= '</head><body>';
$html .= '<div class="printlogo">';
$html .= '<img src="images/logo.png">';
$html .= '</div>';
$html .= '<hr style="border-color:#0088cc;margin-bottom:4px;margin-top:8px;"><hr style="border-color:#0088cc;margin-top: 4px;">';
$html .= 'Sayın ';
$html .= $musteri->name;
$html .= ';<br><p style="margin-bottom:40px;">';
$html .= ' Cari hesap ekstreniz aşağıdaki gibidir.';
$html .= '<span style="float:left;margin-top: 20px;clear:both;">SAYGILARIMIZLA...</span>';
$html .= '</p><br><br>';
$html .= '<div class="baslik">';
$html .= '<table style="width:650px;">';
$html .= '<tr>';
$html .= '<td style="width:100px;border-top:1px solid #dddddd;border-bottom:1px solid #dddddd;border-left:1px solid #dddddd;border-right:1px solid #dddddd;color:red;">TARİH</td>';
$html .= '<td style="width:350px;border-top:1px solid #dddddd;border-bottom:1px solid #dddddd;border-left:1px solid #dddddd;color:red;">AÇIKLAMA</td>';
$html .= '<td style="width:100px;border-top:1px solid #dddddd;border-bottom:1px solid #dddddd;border-left:1px solid #dddddd;color:red;">BORÇ</td>';
$html .= '<td style="width:100px;border-top:1px solid #dddddd;border-bottom:1px solid #dddddd;border-left:1px solid #dddddd;border-right:1px solid #dddddd;color:red;">ALACAK</td>';
$html .= '</tr>';
foreach($cari as $c) {;
$html .= '<tr>';
$html .= '<td style="text-align:right;border-top:1px solid #dddddd;border-bottom:1px solid #dddddd;border-left:1px solid #dddddd;">';
$html .= date("d.m.Y",strtotime($c->tarih));
$html .= '</td><td style="border-top:1px solid #dddddd;border-bottom:1px solid #dddddd;border-left:1px solid #dddddd;border-right:1px solid #dddddd;">&nbsp;';
$html .= $c->aciklama;
$html .= '</td><td style="text-align:right;border-top:1px solid #dddddd;border-bottom:1px solid #dddddd;border-right:1px solid #dddddd;">';
$html .= number_format($c->borc,2,",",".");
$html .= '</td><td style="text-align:right;border-top:1px solid #dddddd;border-bottom:1px solid #dddddd;border-right:1px solid #dddddd;">';
$html .= number_format($c->alacak,2,",",".");
$html .= '</td></tr>';
};
$html .= '<tr>';
$html .= '<td colspan="3" style="color:red;">&nbsp;';
$html .= '<b>TOPLAM TUTAR</b>';
$html .= '</td><td style="color:red;text-align:right;width:140px;font-size:18px;border-top:1px solid #dddddd;border-left:1px solid #dddddd;border-bottom:1px solid #dddddd;border-right:1px solid #dddddd;"><b>';
$html .= $durum;
$html .= ' TL</b>&nbsp;&nbsp;</td>';
$html .= '<td></td><td></td>';
$html .= '</tr>';
$html .= '</table>';
$html .= '</body></html>';
$pdf = App::make('dompdf');
$pdf->loadHTML($html);
return $pdf->stream();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment