Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sqla = "select * from c39_apotek_pemohon where no_register = '".$nr."' and no_agenda = '".$na."'";
- $rsa = mysql_query($sqla, $konekdb) or die(mysql_error());
- $rowrsa = mysql_fetch_assoc($rsa);
- $totrsa = mysql_num_rows($rsa);
- if ($totrsa==0) {
- echo "<script>alert('Data APT belum ada...!')</script>";
- } else {
- $xnama = strtoupper(trim($rowrsa['nama_pemohon']));
- $xalamat = trim($rowrsa['alamat_pemohon']);
- $xdesa = trim($rowrsa['kelurahan_pemohon']);
- $xkec = trim($rowrsa['kecamatan_pemohon']);
- $xkab = trim($rowrsa['kabupaten_pemohon']);
- $sqlb = "select * from c39_apotek_dataapotek where no_register = '".$nr."' and no_agenda = '".$na."'";
- $rsb = mysql_query($sqlb, $konekdb) or die(mysql_error());
- $rowrsb = mysql_fetch_assoc($rsb);
- $totrsb = mysql_num_rows($rsb);
- if ($totrsb==0) {
- } else {
- $xnmapoteker = trim($rowrsb['nama_apoteker']);
- $xaltapoteker = trim($rowrsb['alamat_apoteker']);
- $xkotapoteker = trim($rowrsb['kota_apoteker']);
- $xnoapoteker = trim($rowrsb['nomor_apoteker']);
- $xnmapotik = strtoupper(trim($rowrsb['nama_apotik']));
- $xaltapotik = trim($rowrsb['alamat_apotik']);
- $xkelapotik = trim($rowrsb['kelurahan_apotik']);
- $xkecapotik = trim($rowrsb['kecamatan_apotik']);
- $xkabapotik = trim($rowrsb['kabupaten_apotik']);
- $xpropapotik = trim($rowrsb['propinsi_apotik']);
- $xsts = trim($rowrsb['status_sarana']);
- if ($xsts=="") {
- $xstssarana = "";
- } elseif ($xsts=="1") {
- $xstssarana = "Milik Sendiri";
- } elseif ($xsts=="2") {
- $xstssarana = "Milik Pihak Lain";
- }
- $xnmpemilik = trim($rowrsb['nama_pemilik_sarana']);
- $xalmtpmlksarana = trim($rowrsb['alamat_pemilik_sarana']);
- $xktpmlksarana = trim($rowrsb['kota_pemilik_sarana']);
- $xnoperjanjian = trim($rowrsb['no_perjanjian']);
- $tpjj = trim($rowrsb['tgl_perjanjian']);
- if ($tpjj<>"") {
- $xtpjj = explode("-",$tpjj);
- $xtglperjanjian = $xtpjj[2]." ".bulan($xtpjj[1])." ".$xtpjj[0];
- }
- $xnmnotaris = trim($rowrsb['nama_notaris']);
- $xktnotaris = trim($rowrsb['kota_notaris']);
- }
- $sqld = "select * from c39_apotek_cetak where no_register = '".$nr."' and no_agenda = '".$na."'";
- $rsd = mysql_query($sqld, $konekdb) or die(mysql_error());
- $rowrsd = mysql_fetch_assoc($rsd);
- $totrsd = mysql_num_rows($rsd);
- if ($totrsd==0) {
- } else {
- $xnomor = trim($rowrsd['no_sk']);
- $tct = trim($rowrsd['tgl_sk']);
- if ($tct<>"") {
- $xtct = explode("-",$tct);
- $xtgllaku = $xtct[2]." ".bulan($xtct[1])." ".$xtct[0];
- }
- }
- $sqlc = "select * from c39_nama_pejabat";
- $rsc = mysql_query($sqlc, $konekdb) or die(mysql_error());
- $rowrsc = mysql_fetch_assoc($rsc);
- $totrsc = mysql_num_rows($rsc);
- if ($totrsc==0) {
- } else {
- $xpejabat = trim($rowrsc['nama_pejabat']);
- $xjabatan = trim($rowrsc['jabatan']);
- $xnip = trim($rowrsc['nip']);
- }
- $xalamat1 = $xaltapoteker." ".$xkotapoteker;
- $xlokasi1 = $xaltapotik." ".$xkelapotik;
- $document = file_get_contents("tpl/piagam_apotek.rtf");
- $document = preg_replace('[nomor1]',$xnomor,$document);
- $document = preg_replace('[nmapotik1]',$xnmapotik,$document);
- $document = preg_replace('[Nama1]',$xnmapoteker,$document);
- $document = preg_replace('[Alamat1]',$xalamat1,$document);
- $document = preg_replace('[nosipa1]',$xnoapoteker,$document);
- $document = preg_replace('[lokasi1]',$xlokasi1,$document);
- $document = preg_replace('[kec1]',$xkecapotik,$document);
- $document = preg_replace('[kab1]',$xkabapotik,$document);
- $document = preg_replace('[prop1]',$xpropapotik,$document);
- $document = preg_replace('[stssarana1]',$xstssarana,$document);
- $document = preg_replace('[nmpemilik1]',$xnmpemilik,$document);
- $document = preg_replace('[nojanji1]',$xnoperjanjian,$document);
- $document = preg_replace('[tgljanji1]',$xtglperjanjian,$document);
- $document = preg_replace('[notaris1]',$xnmnotaris,$document);
- $document = preg_replace('[kota1]',$xktnotaris,$document);
- $document = preg_replace('[tgllaku]',$xtgllaku,$document);
- $document = preg_replace('[pejabat1]',$xpejabat,$document);
- $document = preg_replace('[jabatan1]',$xjabatan,$document);
- $document = preg_replace('[nip1]',$xnip,$document);
- $file = "piagamapotek_".$nr.".rtf";
- header("Content-type: application/msword");
- header("Expires: 0");
- header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
- header("Content-disposition: inline; filename=".$file);
- header("Content-length: " . strlen($document));
- echo $document;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement