PageRenderTime 46ms CodeModel.GetById 22ms RepoModel.GetById 1ms app.codeStats 0ms

/report/reportkonsepskpp.php

https://bitbucket.org/metamorph/kppnadministration
PHP | 89 lines | 59 code | 1 blank | 29 comment | 0 complexity | 5d877a5a7bab6a506dec22bb2ff3dbbc MD5 | raw file
Possible License(s): GPL-2.0
  1. <?php
  2. // Panggil semua fungsi yang dibutuhkan (semuanya ada di folder config)
  3. require("../fpdf/fpdf.php");
  4. include("../config/koneksi.php");
  5. class PDF extends FPDF
  6. {
  7. function Header()
  8. {
  9. // Logo
  10. $this->Image('../templates/images/logodepkeu.png',10,10,20);
  11. // Times bold 13
  12. $this->SetFont('Times','B',13);
  13. // Move to the right
  14. $this->Cell(20);
  15. // Title 1
  16. $this->Cell(165,5,'KEMENTERIAN KEUANGAN REPUBLIK INDONESIA',0,1,'C');
  17. // Times bold 12
  18. $this->SetFont('Times','B',12);
  19. // Move to the right
  20. $this->Cell(20);
  21. // Title 2
  22. $this->Cell(165,5,'DIREKTORAT JENDERAL PERBENDAHARAAN',0,1,'C');
  23. // Times bold 12
  24. $this->SetFont('Times','B',11);
  25. // Move to the right
  26. $this->Cell(20);
  27. // Title 3
  28. // Query kanwil
  29. $qKanwil = mysql_query("SELECT nmkanwil FROM t_kanwil WHERE aktif='1'")or die(mysql_error);
  30. $rKanwil = mysql_fetch_array($qKanwil);
  31. $nmKanwil = $rKanwil['nmkanwil'];
  32. $this->Cell(165,5,'KANTOR WILAYAH '.$nmKanwil,0,1,'C');
  33. // Times bold 12
  34. $this->SetFont('Times','',11);
  35. // Move to the right
  36. $this->Cell(20);
  37. // Title 4
  38. // Query KPPN
  39. $qKppn = mysql_query("SELECT nmkppn FROM t_kppn WHERE kddefa='1'")or die(mysql_error);
  40. $rKppn = mysql_fetch_array($qKppn);
  41. $nmKppn = $rKppn['nmkppn'];
  42. $this->Cell(165,4,'KANTOR PELAYANAN PERBENDAHARAAN '.$nmKppn,0,1,'C');
  43. // Times 8
  44. $this->SetFont('Times','',8);
  45. // Move to the right
  46. $this->Cell(20);
  47. // Title 5
  48. $qryKppn = mysql_query("SELECT almkppn,kotakppn,telkppn,email,kodepos,faxkppn,website,smsgateway FROM t_kppn WHERE kddefa='1'")or die(mysql_error);
  49. $rsltKppn = mysql_fetch_array($qryKppn);
  50. $almKppn = $rsltKppn['almkppn']." ".$rsltKppn['kotakppn']." ".$rsltKppn['kodepos']." Telepon: ".$rsltKppn['telkppn']." Faksimile: ".$rsltKppn['faxkppn'];
  51. $this->Cell(165,4,$almKppn,0,1,'C');
  52. // Move to the right
  53. $this->Cell(20);
  54. // Title 6
  55. $queryKppn= mysql_query("SELECT email,website,smsgateway FROM t_kppn WHERE kddefa='1'")or die(mysql_error);
  56. $resultKppn= mysql_fetch_array($queryKppn);
  57. $webKppn = "Website: ".$resultKppn['website']." Email: ".$resultKppn['email']." SMS Gateway: ".$resultKppn['smsgateway'];
  58. $this->Cell(165,3,$webKppn,0,1,'C');
  59. // Draw line
  60. $this->Line(10,39.5,200,39.5);
  61. $this->Line(10,40,200,40);
  62. // Line break
  63. $this->Ln(5);
  64. }
  65. }
  66. $pdf = new PDF('P','mm','A4');
  67. $pdf->AddPage();
  68. // Konsep SKPP ==========
  69. $pdf->SetFont('Times','',11);
  70. // Today's date
  71. $months = Array (1=>"Januari", 2=>"Pebruari", 3=>"Maret", 4=>"April", 5=>"Mei", 6=>"Juni", 7=>"Juli", 8=>"Agustus", 9=>"September", 10=>"Oktober", 11=>"Nopember", 12=>"Desember");
  72. $bln = $months[date("n")];
  73. $tgl = date("d");
  74. $thn = date("Y");
  75. $pdf->Cell(190,7,$tgl." ".$bln." ".$thn,0,1,'R');
  76. // SURAT PENGANTAR
  77. $pdf->SetFont('','BUI','');
  78. $pdf->Cell(190,6,'SURAT PENGANTAR',0,1,'C');
  79. // Nomor SP
  80. $pdf->SetFont('','','');
  81. $pdf->Cell(190,6,'Nomor: SP- /WPB.14/KP.02/2011',0,1,'C');
  82. // Line break
  83. $pdf->Ln(10);
  84. // Tujuan SKPP
  85. $pdf->SetFont('','B','');
  86. $
  87. $pdf->Output();
  88. ?>