Advertisement
jamboljack

Print Piagam (PHP Native)

Feb 29th, 2016
351
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.40 KB | None | 0 0
  1. $sqla = "select * from c39_apotek_pemohon where no_register = '".$nr."' and no_agenda = '".$na."'";
  2. $rsa = mysql_query($sqla, $konekdb) or die(mysql_error()); 
  3. $rowrsa = mysql_fetch_assoc($rsa);
  4. $totrsa = mysql_num_rows($rsa);
  5. if ($totrsa==0) {
  6.     echo "<script>alert('Data APT belum ada...!')</script>";
  7.  } else {
  8.     $xnama = strtoupper(trim($rowrsa['nama_pemohon']));
  9.     $xalamat = trim($rowrsa['alamat_pemohon']);
  10.     $xdesa = trim($rowrsa['kelurahan_pemohon']);
  11.     $xkec = trim($rowrsa['kecamatan_pemohon']);
  12.     $xkab = trim($rowrsa['kabupaten_pemohon']);
  13.    
  14.     $sqlb = "select * from c39_apotek_dataapotek where no_register = '".$nr."' and no_agenda = '".$na."'";
  15.     $rsb = mysql_query($sqlb, $konekdb) or die(mysql_error()); 
  16.     $rowrsb = mysql_fetch_assoc($rsb);
  17.     $totrsb = mysql_num_rows($rsb);
  18.     if ($totrsb==0) {
  19.     } else {
  20.  
  21.         $xnmapoteker = trim($rowrsb['nama_apoteker']);
  22.         $xaltapoteker = trim($rowrsb['alamat_apoteker']);
  23.         $xkotapoteker = trim($rowrsb['kota_apoteker']);
  24.         $xnoapoteker = trim($rowrsb['nomor_apoteker']);
  25.        
  26.         $xnmapotik = strtoupper(trim($rowrsb['nama_apotik']));
  27.         $xaltapotik = trim($rowrsb['alamat_apotik']);
  28.         $xkelapotik = trim($rowrsb['kelurahan_apotik']);
  29.         $xkecapotik = trim($rowrsb['kecamatan_apotik']);
  30.         $xkabapotik = trim($rowrsb['kabupaten_apotik']);
  31.         $xpropapotik = trim($rowrsb['propinsi_apotik']);
  32.            
  33.         $xsts = trim($rowrsb['status_sarana']);
  34.         if ($xsts=="") {
  35.             $xstssarana = "";
  36.         } elseif ($xsts=="1") {
  37.             $xstssarana = "Milik Sendiri";
  38.         } elseif ($xsts=="2") {
  39.             $xstssarana = "Milik Pihak Lain";
  40.         }
  41.  
  42.         $xnmpemilik = trim($rowrsb['nama_pemilik_sarana']);
  43.         $xalmtpmlksarana = trim($rowrsb['alamat_pemilik_sarana']); 
  44.         $xktpmlksarana = trim($rowrsb['kota_pemilik_sarana']);     
  45.         $xnoperjanjian = trim($rowrsb['no_perjanjian']);   
  46.         $tpjj = trim($rowrsb['tgl_perjanjian']);
  47.         if ($tpjj<>"") {
  48.             $xtpjj = explode("-",$tpjj);
  49.             $xtglperjanjian = $xtpjj[2]." ".bulan($xtpjj[1])." ".$xtpjj[0];    
  50.         }
  51.         $xnmnotaris = trim($rowrsb['nama_notaris']);           
  52.         $xktnotaris = trim($rowrsb['kota_notaris']);           
  53.                
  54.     }
  55.  
  56.     $sqld = "select * from c39_apotek_cetak where no_register = '".$nr."' and no_agenda = '".$na."'";
  57.     $rsd = mysql_query($sqld, $konekdb) or die(mysql_error()); 
  58.     $rowrsd = mysql_fetch_assoc($rsd);
  59.     $totrsd = mysql_num_rows($rsd);
  60.     if ($totrsd==0) {
  61.     } else {
  62.         $xnomor = trim($rowrsd['no_sk']);
  63.         $tct = trim($rowrsd['tgl_sk']);
  64.         if ($tct<>"") {
  65.             $xtct = explode("-",$tct);
  66.             $xtgllaku = $xtct[2]." ".bulan($xtct[1])." ".$xtct[0];
  67.         }
  68.     }
  69.  
  70.     $sqlc = "select * from c39_nama_pejabat";
  71.     $rsc = mysql_query($sqlc, $konekdb) or die(mysql_error()); 
  72.     $rowrsc = mysql_fetch_assoc($rsc);
  73.     $totrsc = mysql_num_rows($rsc);
  74.     if ($totrsc==0) {
  75.     } else {
  76.         $xpejabat = trim($rowrsc['nama_pejabat']);
  77.         $xjabatan = trim($rowrsc['jabatan']);
  78.         $xnip = trim($rowrsc['nip']);
  79.     }
  80.  
  81. $xalamat1 = $xaltapoteker." ".$xkotapoteker;
  82. $xlokasi1 = $xaltapotik." ".$xkelapotik;
  83.  
  84. $document = file_get_contents("tpl/piagam_apotek.rtf");
  85. $document = preg_replace('[nomor1]',$xnomor,$document);
  86. $document = preg_replace('[nmapotik1]',$xnmapotik,$document);
  87. $document = preg_replace('[Nama1]',$xnmapoteker,$document);
  88. $document = preg_replace('[Alamat1]',$xalamat1,$document);
  89. $document = preg_replace('[nosipa1]',$xnoapoteker,$document);
  90. $document = preg_replace('[lokasi1]',$xlokasi1,$document);
  91. $document = preg_replace('[kec1]',$xkecapotik,$document);
  92. $document = preg_replace('[kab1]',$xkabapotik,$document);
  93. $document = preg_replace('[prop1]',$xpropapotik,$document);
  94. $document = preg_replace('[stssarana1]',$xstssarana,$document);
  95. $document = preg_replace('[nmpemilik1]',$xnmpemilik,$document);
  96. $document = preg_replace('[nojanji1]',$xnoperjanjian,$document);
  97. $document = preg_replace('[tgljanji1]',$xtglperjanjian,$document);
  98. $document = preg_replace('[notaris1]',$xnmnotaris,$document);
  99. $document = preg_replace('[kota1]',$xktnotaris,$document);
  100. $document = preg_replace('[tgllaku]',$xtgllaku,$document);
  101.  
  102. $document = preg_replace('[pejabat1]',$xpejabat,$document);
  103. $document = preg_replace('[jabatan1]',$xjabatan,$document);
  104. $document = preg_replace('[nip1]',$xnip,$document);
  105.  
  106. $file = "piagamapotek_".$nr.".rtf";
  107. header("Content-type: application/msword");
  108. header("Expires: 0");
  109. header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
  110. header("Content-disposition: inline; filename=".$file);
  111. header("Content-length: " . strlen($document));
  112. echo $document;
  113. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement