PHP Decode

?><?php

session_start();
set_time_limit(0);
ini_set('post_max_size', '128M');

$opr = $_SESSION['USERNAME'];
$type = $_SESSION['TYPE'];

require_once("connection.inc.php");
require_once("function.inc.php");

//----------------- Register Globals Off ------------
foreach ($_GET as $key => $value) ${$key} = $value;
foreach ($_POST as $key => $value) ${$key} = $value;
//----------------- Register Globals Off ------------

function Tgl_Indo2($tgl){
		$tanggal = substr($tgl,8,2);
		$bulan = substr($tgl,5,2);
		$tahun = substr($tgl,0,4);
		return $tanggal.'-'.$bulan.'-'.$tahun;
}

function BuatSPK($kode,$tgl_serah,$tgl_selesai) {
	
	define('FPDF_FONTPATH','./inc/font/');
	require_once('./inc/fpdf.php');

	$opr = $_SESSION['USERNAME'];

	if( class_exists('PDF') != true ) {

		class PDF extends FPDF
		{
		var $widths;
		var $aligns;

		function SetWidths($w)
		{
			//Set the array of column widths
			$this->widths=$w;
		}

		function SetAligns($a)
		{
			//Set the array of column alignments
			$this->aligns=$a;
		}

		function Row($data)
		{
			//Calculate the height of the row
			$nb=0;
			for($i=0;$i<count($data);$i++)
				$nb=max($nb,$this->NbLines($this->widths[$i],$data[$i]));
			$h=4*$nb;
			//Issue a page break first if needed
			$this->CheckPageBreak($h);
			$this->SetX(10);
			//Draw the cells of the row
			for($i=0;$i<count($data);$i++)
			{
				$w=$this->widths[$i];
				$a=isset($this->aligns[$i]) ? $this->aligns[$i] : 'L';
				//Save the current position
				$x=$this->GetX();
				$y=$this->GetY();
				//Draw the border
				$this->Rect($x,$y,$w,$h);
				//Print the text
				$this->MultiCell($w,4,$data[$i],0,$a,0);
				//Put the position to the right of the cell
				$this->SetXY($x+$w,$y);
			}
			//Go to the next line
			$this->Ln($h);
		}

		function RowNoBorder($data)
		{
			//Calculate the height of the row
			$nb=0;
			for($i=0;$i<count($data);$i++)
				$nb=max($nb,$this->NbLines($this->widths[$i],$data[$i]));
			$h=4*$nb;
			//Issue a page break first if needed
			$this->CheckPageBreak($h);
			$this->SetX(10);
			//Draw the cells of the row
			for($i=0;$i<count($data);$i++)
			{
				$w=$this->widths[$i];
				$a=isset($this->aligns[$i]) ? $this->aligns[$i] : 'L';
				//Save the current position
				$x=$this->GetX();
				$y=$this->GetY();
				//Draw the border
				//$this->Rect($x,$y,$w,$h);
				//Print the text
				$this->MultiCell($w,4,$data[$i],0,$a,0);
				//Put the position to the right of the cell
				$this->SetXY($x+$w,$y);
			}
			//Go to the next line
			$this->Ln($h);
		}

		function CheckPageBreak($h)
		{
			//If the height h would cause an overflow, add a new page immediately
			if($this->GetY()+$h>$this->PageBreakTrigger)
				$this->AddPage($this->CurOrientation);
		}

		function NbLines($w,$txt)
		{
			//Computes the number of lines a MultiCell of width w will take
			$cw=&$this->CurrentFont['cw'];
			if($w==0)
				$w=$this->w-$this->rMargin-$this->x;
			$wmax=($w-4*$this->cMargin)*1000/$this->FontSize;
			$s=str_replace("
",'',$txt);
			$nb=strlen($s);
			if($nb>0 and $s[$nb-1]=="
")
				$nb--;
			$sep=-1;
			$i=0;
			$j=0;
			$l=0;
			$nl=1;
			while($i<$nb)
			{
				$c=$s[$i];
				if($c=="
")
				{
					$i++;
					$sep=-1;
					$j=$i;
					$l=0;
					$nl++;
					continue;
				}
				if($c==' ')
					$sep=$i;
				$l+=$cw[$c];
				if($l>$wmax)
				{
					if($sep==-1)
					{
						if($i==$j)
							$i++;
					}
					else
						$i=$sep+1;
					$sep=-1;
					$j=$i;
					$l=0;
					$nl++;
				}
				else
					$i++;
			}
			return $nl;
		}

		function Footer()
		{
			global $API_KEY, $G_DIRUM, $G_JUDUL1, $G_JUDUL2, $G_ALAMAT1, $G_ALAMAT2, $G_LOGO_KIRI, $G_LOGO_KANAN, $G_LOGO_CETAK, $G_LOGO_LPP, $G_LOGO_PDAM;
			//Page footer
			$this->SetY(-15);
			$this->SetFont('Arial','I',6);
			$this->SetTextColor(158);
			$this->Cell(0,10,$G_JUDUL1.' - Tanggal:'.date('d-m-Y H:i:s').' / '.$_SESSION['USERNAME'].' / Hal '.$this->PageNo(),0,0,'C');
		}

		//Load data
		function LoadData($file)
		{
			//Read file lines
			$lines=file($file);
			$data=array();
			foreach($lines as $line)
				$data[]=explode(';',chop($line));
			return $data;
		}

		//Colored table
		function FancyTable($header,$kode,$tgl_serah,$tgl_selesai)
		{			
			global $API_KEY, $G_DIRUM, $G_JUDUL1, $G_JUDUL2, $G_ALAMAT1, $G_ALAMAT2, $G_LOGO_KIRI, $G_LOGO_KANAN, $G_LOGO_CETAK, $G_LOGO_LPP, $G_LOGO_PDAM, $G_LOGO_LONG;
			
			$opr = $_SESSION['USERNAME'];
			$lokasi = $_SESSION['LOKASI'];

			$no_reg=$kode;

			$tgl_daftar = substr($no_reg,2,4)."-".substr($no_reg,6,2)."-".substr($no_reg,8,2);

			$no_pelanggan = $no_reg;
			$idx=1;
			$this->AddPage();
			$y=8;

			$this->Image($G_LOGO_LONG,10,$y-5,50);
			$this->Ln(-3);
			$this->SetFont('arial','B',14);
			$this->SetWidths(array(30,165));
			$this->SetAligns(array('C','R'));
			$this->RowNoBorder(array('',$G_JUDUL1." ".$G_JUDUL2));
			$this->Ln(1);
		  $this->SetFont('arial','',8);
			$this->RowNoBorder(array('',$G_ALAMAT1));
		  $this->SetFont('arial','',7);
			$this->RowNoBorder(array('',$G_ALAMAT2));
			$this->Ln(1);

			$this->Line(10,$this->GetY()+1,204,$this->GetY()+1);
			$this->Ln(3);

			$q0="select * from bill_tr_pb_surat where no_pelanggan='".$no_reg."' limit 1";
			$res0=mysql_query($q0);
			$r0=mysql_fetch_object($res0);
			$no_spkp=$r0->spkp;
			$no_bap=$r0->bap;
			mysql_free_result($res0);

			$sql  = "select a.*,b.nama_wilayah from bill_pb_pelanggan a, bill_ms_wilayah b where a.kode_wilayah=b.kode_wilayah and a.no_pelanggan='".$no_reg."' and stat='3' order by a.last_update limit 1";
			$res = mysql_query($sql) or die(mysql_error());
			$r1 = mysql_fetch_object($res);

			if (empty($no_spkp)) {
				 $q0="select * from bill_no_surat where kode_lokasi='".$_SESSION[CABANG]."'";
				 $res0=mysql_query($q0);
				 $r0=mysql_fetch_object($res0);
				 $spkp=sprintf("%04d",$r0->spkp+1);
				 $bap=sprintf("%04d",$r0->bap+1);
				 mysql_free_result($res0);
				 //mysql_query("update bill_no_surat set spkp=".intval($spkp).",bap=".intval($bap)." where kode_lokasi='".$_SESSION[CABANG]."'");
				 
				 $no_spkp = $spkp."/SPKP/HBL/".Romawi(substr($r1->last_update,5,2))."/".left($r1->last_update,4);
				 $no_bap = $bap."/BAP/".Romawi(substr($r1->last_update,5,2))."/".left($r1->last_update,4);
				 //mysql_query("replace bill_tr_pb_surat(no_pelanggan,spkp,bap,last_update,update_by,tgl_serah,tgl_selesai) values ('".$no_reg."','".$no_spkp."','".$no_bap."',NOW(),'$opr','".$tgl_serah."','".$tgl_selesai."')");
			} 
			//else mysql_query("update bill_tr_pb_surat set tgl_serah='".$tgl_serah."',tgl_selesai='".$tgl_selesai."' where no_pelanggan='".$no_reg."'");

			$this->SetFont('arial','UB',12);
			$this->Text(75,31,"SURAT PERINTAH KERJA PEMASANGAN");
			$this->SetFont('arial','',10);
			$this->Text(92,35,"Nomor : ".$no_spkp);
			$this->SetLineWidth(.3);
			//$this->Line(62,$this->GetY()+10,168,$this->GetY()+10);

			//BIAYA TAMBAHAN
			//$q  = "select sum(sub_total) jml from bill_tr_pb_pengukuran where no_pelanggan='".$no_reg."'";
			//$res = mysql_query($q) or die(mysql_error());
			//$r = mysql_fetch_object($res);
			//$tambahan=$r->jml;
			//mysql_free_result($res);

			//ANDROID
			$qry="select kontak_mitra from bill_tr_pb_android where no_pelanggan='$no_reg' limit 1";
			$rs=mysql_query($qry);
			$r2=mysql_fetch_object($rs);
			$kontak_mitra=$r2->kontak_mitra;
			mysql_free_result($rs);

			$arr_jenis = explode(";",getJenisSambungan($no_reg));
			$arr_kec = explode(";",getKecamatan($r1->kode_kecamatan));
			$arr_kel = explode(";",getKelurahan($r1->kode_kecamatan, $r1->kode_kelurahan));
			$nama_kecamatan=$arr_kec[1];
			$nama_kelurahan=$arr_kel[1];

			$qry="select nama_rayon from bill_ms_rayon where kode_wilayah='$r1->kode_wilayah' and kode_rayon='$r1->kode_rayon'";
			$rs=mysql_query($qry);
			$r2=mysql_fetch_object($rs);

			$this->Text(12,65,"Kepada : ".$r1->nama_mitra." Telp. ".$kontak_mitra);
			$this->Text(12,69,"Alamat   : ".$r1->alamat_mitra);

			$this->Text(12,76,"Supaya segera melaksanakan Pemasangan Pipa Dinas dari Pipa Persil Sambungan Langganan PDAM INTAN BANJAR ");
			$this->Text(12,80,"(Sambungan Baru) di lokasi tersebut dibawah ini dan selanjutnya harap disampaikan Laporan Hasil Pemasangan");
			$this->Text(12,84,"dan Berita Acara Pekerjaan.");
			$this->Text(12,90,"Pemasangan	: Pemasangan Sambungan Langsung PDAM (Sambungan Baru)");
			$this->Text(15,96,"Wilayah	");
			$this->Text(42,96," : ".$r1->nama_wilayah." - ".$r2->nama_rayon);
			$this->Text(15,100,"Nama 	");
			$this->Text(42,100," : ".$r1->nama_pelanggan);
			$this->Text(15,104,"Alamat	");
			$this->Text(42,104," : ".$r1->alamat_pelanggan);
			$this->Text(15,108,"Kecamatan ");
			$this->Text(42,108," : ".$nama_kecamatan." Kelurahan/Desa : $nama_kelurahan");
			$this->Text(15,112,"No. Register ");
			$this->Text(42,112," : ".$r1->no_pelanggan. " / Telp. ". $r1->no_telepon." ".$r1->telepon_rumah);
			$this->Text(12,118,"Demikian Surat Perintah Kerja Pemasangan ini dibuat agar dapat dipergunakan dengan penuh rasa tanggung jawab.");

			switch ($_SESSION['CABANG']) {
			case 'bna':  
				if (empty($_SESSION['NAMA_LOKASI']) || $_SESSION[CABANG]=='bna') $this->Text(100,126,"Banjarbaru, ".Tgl_Indo2(left($r1->last_update,10)));
				else $this->Text(100,126,ucwords(strtolower($_SESSION['NAMA_LOKASI'])).", ".Tgl_Indo2(left($r1->last_update,10)));
				$this->Text(102,130,"Kabag Perencanaan");
				$this->SetFont('arial','U',10);
//				$this->Text(100,148,'H. SAID UMAR, ST, MS');
//				$this->SetFont('arial','',10);
//				$this->Text(105,152,'Direktur Teknik');
				$this->Text(100,148,'MACHMUD MANSYUR, ST');
				$this->SetFont('arial','',10);
				$this->Text(105,152,'NIPP. 70 94 630 059');				
				break;
			default :   
				if ($_SESSION[CABANG]=='bna') $sql_cabang = "select * from bill_ms_lokasi_bayar where kode_lokasi='Z' limit 1";
				else if ($_SESSION[CABANG]=='cabang1') $sql_cabang = "select * from bill_ms_lokasi_bayar where kode_lokasi='D' limit 1";
				else if ($_SESSION[CABANG]=='cabang2') $sql_cabang = "select * from bill_ms_lokasi_bayar where kode_lokasi='F' limit 1";
				else if ($_SESSION[CABANG]=='cabang3') $sql_cabang = "select * from bill_ms_lokasi_bayar where kode_lokasi='P' limit 1";
				$rs_cabang = mysql_query($sql_cabang);
				$row_cabang = mysql_fetch_object($rs_cabang);
				$ka_nama = $row_cabang->ka_cabang;
				$ka_nip = "NIPP. ".$row_cabang->nipp1;
				mysql_free_result($rs_cabang);

				if (empty($_SESSION['NAMA_LOKASI']) || $_SESSION[CABANG]=='bna') $this->Text(100,126,"Banjarbaru, ".Tgl_Indo2(left($r1->last_update,10)));
				else $this->Text(100,126,ucwords(strtolower($_SESSION['NAMA_LOKASI'])).", ".Tgl_Indo2(left($r1->last_update,10)));
				$this->Text(110,130,"Kepala Cabang");
				$this->SetFont('arial','U',10);
				$this->Text(106,148,strtoupper($ka_nama));
				$this->SetFont('arial','',10);
				$this->Text(105,152,$ka_nip);
				break;

			}
			$this->SetFont('arial','U',10);
			$this->Text(15,174,"Keterangan:");
			$this->SetFont('arial','',10);
			$this->Text(15,180,"- SPKP diserahkan pada tanggal                     : ".Tgl_Indo2($tgl_serah));
			$this->Text(15,184,"- Batas akhir penyelesaian pekerjaan tanggal : ".Tgl_Indo2($tgl_selesai));

		/*
			//BA PEKERJAAN
			$this->AddPage();
			$y=10;
			$this->Image('./images/intan2.jpg',10,$y-5,26);
			$this->SetFont('arial','B',12);
			$this->Text(92,$y,"PDAM INTAN BANJAR");
			$this->SetFont('arial','B',10);
			$this->Text(40,$y+4,"Jl. Pangeran Hidayatullah No. 24 Banjarbaru 70711 Kalimantan Selatan Telp. 0511-4772061");
			$this->SetFont('arial','B',12);
			$this->SetY($y+15);

			$this->Line(10,$this->GetY()+1,200,$this->GetY()+1);  	     
			$this->Ln(3);

			$this->SetFont('arial','UB',12);
			$this->Text(82,31,"BERITA ACARA PEKERJAAN");
			$this->SetFont('arial','',10);
			$this->Text(90,35,"Nomor : ".$no_bap);

			$posy=50;
			$this->Text(35,$posy,  "Saya yang bertanda tangan di bawah ini, menyatakan pemasangan pipa dinas dan pipa persil");
			$this->Text(35,$posy+4,"sambungan langsung PDAM (Sambungan Baru) :");

			$this->Text(35,$posy+10,"Nama 	");
			$this->Text(72,$posy+10," : ".$r1->nama_pelanggan);
			$this->Text(35,$posy+14,"Nomor Kontrak ");
			$this->Text(72,$posy+14," : ".$r1->no_pelanggan. " / Telp. ". $r1->no_telepon." ".$r1->telepon_rumah);
			$this->Text(35,$posy+18,"Jenis Pelanggan	");
			$this->Text(72,$posy+18," : ".$arr_jenis[1]);
			$this->Text(35,$posy+22,"Alamat	");
			$this->Text(72,$posy+22," : ".$r1->alamat_pelanggan);
			$this->Text(35,$posy+26,"Wilayah	");
			$this->Text(72,$posy+26," : ".$r1->nama_wilayah." - ".$r2->nama_rayon);
			$this->Text(35,$posy+30,"Kecamatan	");
			$this->Text(72,$posy+30," : ".$nama_kecamatan." Kel./Desa : $nama_kelurahan");

			$posy=86;
			$this->Text(35,$posy,  "Telah selesai dikerjakan dengan hasil pemeriksaan sebagaimana yang diharapkan.");
			$this->Text(35,$posy+4,"Dengan demikian semua pihak sependapat dan menyatakan bahwa pekerjaan tersebut sesuai");
			$this->Text(35,$posy+8,"dengan perencanaan dan dapat berfungsi sebagaimana mestinya.");

			$this->Text(35,$posy+14,"Demikian Berita Acara Pekerjaan ini dibuat untuk dapat dipergunakan sebagaimana mestinya.");

			if (empty($_SESSION['NAMA_LOKASI']) || $_SESSION[CABANG]=='bna') $this->Text(130,122,"Banjarbaru, ".Tgl_Indo2(left($r1->last_update,10)));
			else $this->Text(130,122,ucwords(strtolower($_SESSION['NAMA_LOKASI'])).", ".Tgl_Indo2(left($r1->last_update,10)));
			$this->Text(60,136,"Pelaksana");
			$this->SetFont('arial','',10);

			$this->Text(140,136,"Pelanggan");
			$this->SetFont('arial','',10);

			$this->SetY(170);  
			$this->Line(10,$this->GetY()+1,200,$this->GetY()+1);  	     
			$this->Ln(3);

			$posy=178;
			$this->Text(35,$posy,    "WATER METER : ");
			$this->Text(130,$posy,   "1. Segel Meter      : [  ] Ada [  ] Tidak");
			$this->Text(35,$posy+6,  "1. Stand Meter : .......................");
			$this->Text(130,$posy+4, "2. Segel PDAM     : [  ] Ada [  ] Tidak");
			$this->Text(35,$posy+12,  "2. Nomor Body : .......................");
			$this->Text(130,$posy+8, "3. Kotak Meter      : [  ] Ada [  ] Tidak");
			$this->Text(35,$posy+18,  "3. Merk             : .......................");
			$this->Text(130,$posy+12, "4. Sesuai Gambar : [  ] Ya [  ] Tidak");
			$this->Text(130,$posy+16, "5. Terpasang         : [  ] Ya [  ] Tidak");
			$this->Text(35,$posy+24,  "4. Tgl Pasang (tgl/bln/thn)  : .......................");
		*/
		
		} 

		} //Class
		$pdf=new PDF('P');
		$pdf->FancyTable($header,$kode, $tgl_serah, $tgl_selesai);
		$pdf->Output('./logs/rab/SPK_'.$kode.'.pdf');
	}

}

function fetchURL( $url ) {
    include_once "pear/Request.php";
	$req = &new HTTP_Request($url,array("http" => "1.1","allowRedirects" => false));
	$req->setMethod(HTTP_REQUEST_METHOD_GET);
	$req->clearPostData();
	$req->sendRequest();
	$res = $req->getResponseBody();
	return $res;
}

function KirimEmailSPK($kode,$tgl_serah,$tgl_selesai) {
	
	include_once('class.smtp.php');
	include_once('class.phpmailer.php');
	$mail = new PHPMailer();
	$mail->Host     = "ssl://smtp.gmail.com"; // SMTP server Gmail
	$mail->Mailer   = "smtp";
	$mail->SMTPAuth = true; // turn on SMTP authentication
	
	$mail->Username = "[email protected]"; // 
	$mail->Password = "kompuspdam"; // SMTP password
	$webmaster_email = "[email protected]"; //Reply to this email ID
	
	$q2= "select * from bill_tr_pb_android where no_pelanggan='$kode' limit 1";	  
	$res2 = mysql_query($q2);
	$row2 = mysql_fetch_object($res2);
	$nama = $row2->nama_pelanggan;
	$alamat = $row2->alamat_pelanggan;
	$email = $row2->email_pelanggan;
	$handphone = $row2->telepon_pelanggan;
	$pasang_tgl = $row2->pasang_tgl;
	$no_spkp = $row2->no_spkp;
	$no_bap = $row2->no_bap;
	$kontak_mitra = $row2->kontak_mitra;
	$nama_mitra = $row2->nama_mitra;
	$alamat_mitra = $row2->alamat_mitra;
	$tgl_serah = $row2->tgl_serah;
	$tgl_selesai = $row2->tgl_selesai;
	
	mysql_free_result($res2);
		
	$arr_rab = explode(";", getRAB($kode) );
	usleep(100);
	$nilai_rab = $arr_rab[4];
	
	//KIRIM SMS
	if ($handphone) {
		$sms = "PDAM Intan Banjar. SPK Pemasangan SL Baru pada No. Registrasi ".$kode." sedang diproses. Info Hub.0511-4772061/0511-4782004";
		fetchURL("http://192.168.2.33:8800/?PhoneNumber=".$handphone."&Text=".urlencode($sms));
	}

	BuatSPK($kode, $tgl_serah, $tgl_selesai);
	//RAB
	$file_name = "d://xampp//htdocs//billing//logs//rab//SPK_".$kode.".pdf";
	$handle = fopen($file_name,"r");		

	$content = fread($handle, filesize("./logs/rab//SPK_".$kode.".pdf"));
	fclose($handle);
	$encoded_content = chunk_split(base64_encode($content));
	
	$boundary = md5("pdamintanbanjar");
	//header
	$headers = "MIME-Version: 1.0
"; 
	$headers .= "From:".$webmaster_email."
"; 
	$headers .= "Reply-To: ".$webmaster_email."" . "
";
	$headers .= "Content-Type: multipart/mixed; boundary = $boundary

"; 
	
	$mail->addCustomHeader($headers);
	$mail->From = $webmaster_email;
	$mail->FromName = "PDAM Intan Banjar";
	
	//$email2 = "[email protected]";
	$mail->AddAddress($email);
	//$mail->addCC($email2);

	$mail->AddReplyTo($webmaster_email,"PDAM Intan Banjar");
	$mail->WordWrap = 80; // set word wrap
	$mail->IsHTML(true); // send as HTML
	$mail->Subject = "[SI-IBAN] Validasi SPK Pemasangan Sambungan Langganan Baru PDAM Intan Banjar #".$kode;
	
	$isi = "<p>SPK Pemasangan Sambungan Langganan (SL) Baru sedang diproses dengan data sebagai berikut: </p>";
	
	$isi .= "<table border='0' width='75%'>";
	$isi .= "<tr><td>No. Registrasi   </td><td>: <b>".$kode."</b> </td></tr>";
	$isi .= "<tr><td>Nama Pendaftar   </td><td>: ".$nama." </td></tr>";
	$isi .= "<tr><td>Alamat&nbsp;Pemasangan</td><td>: ".$alamat." </td></tr>";
	$isi .= "<tr><td>Email Pendaftar  </td><td>: ".$email." </td></tr>";
	$isi .= "<tr><td>HP Pendaftar     </td><td>: <b>".$handphone." </td></tr>";
	$isi .= "<tr><td>Tanggal SPKP     </td><td>: ".$pasang_tgl." </td></tr>";
	$isi .= "<tr><td>No. SPKP     </td><td>: ".$no_spkp." </td></tr>";
	//$isi .= "<tr><td>No. BAP     </td><td>: ".$no_bap." </td></tr>";
	$isi .= "<tr><td>Nama Pelaksana</td><td>: ".$nama_mitra."</b> </td></tr>";
	$isi .= "<tr><td>Alamat Pelaksana</td><td>: ".$alamat_mitra."</b> </td></tr>";
	$isi .= "<tr><td>No. Kontak</td><td>: ".$kontak_mitra."</b> </td></tr>";
	$isi .= "</table>";
	
	$isi .= "<br><p>Silakan lihat detail SPK (Surat Perintah Kerja) Pemasangan pada lampiran email berikut. Info Hub. 0511-4772061/4782004</p>";
	$isi .= "<p>Terima kasih,</p>"; 
	$isi .= "<br><br><p>PDAM Intan Banjar</p>";

	//plain text 
	$body = "--$boundary
";
	$body .= "Content-Type: text/html; charset=ISO-8859-1
";
	$body .= "Content-Transfer-Encoding: base64

"; 
	$body .= chunk_split(base64_encode($isi)); 
	
	//attachment Invoice
	$body .= "--$boundary
";
	$body .="Content-Type: text/html; name=RAB_".$kode.".pdf
";
	$body .="Content-Disposition: attachment; filename=SPK_".$kode.".pdf
";
	$body .="Content-Transfer-Encoding: base64
";
	$body .="X-Attachment-Id: ".rand(1000,99999)."

"; 
	$body .= $encoded_content;
	
	$mail->Body = $body;
			
	if(!$mail->Send())
	{
		//echo "Mailer Error: " . $mail->ErrorInfo; 
	}
	else
	{
		//echo "$mitra Message has been sent";
		//LOG NOTIF
		$isi_email = str_replace("<table border='0' width='75%'>","",$isi);
		$isi_email = str_replace("</table>","",$isi_email);
		$isi_email = str_replace("<tr>","",$isi_email);
		$isi_email = str_replace("</tr>","",$isi_email);
		$isi_email = str_replace("<td>","",$isi_email);
		$isi_email = str_replace("</td>","",$isi_email);
		$isi_email = str_replace("<b>","",$isi_email);
		$isi_email = str_replace("</b>","",$isi_email);
		$isi_email = str_replace("<p>","",$isi_email);
		$isi_email = str_replace("</p>","",$isi_email);
		$isi_email = str_replace("<br>","",$isi_email);
		$isi_email = str_replace("&nbsp;","",$isi_email);
		
		$sql_notif = "insert into bill_tr_pb_notif_log(no_pelanggan,id_sms,isi_sms,id_email,isi_email,last_update,update_by) values ";
		$sql_notif .= " ( '".$kode."','".$handphone."','".$sms."','".$email."','".urldecode($isi_email)."',NOW(),'".$_SESSION['USERNAME']."' )";
		mysql_query($sql_notif);		
		//echo $sql_notif;
	}	
}

switch ($jenis)
{
    case 'tambah':
        break;
    
    case 'edit':

  		$q="select no_pelanggan from bill_pb_pelanggan where no_pelanggan='".$no_pelanggan."' and stat='8' limit 1";
		$rs=mysql_query($q);
		if (mysql_num_rows($rs)) {
			echo "No. Register ".$no_pelanggan." sudah ada Nomor Pelanggan. Tidak bisa merubah data !";
			//echo "<script>{ window.close(); }</script>";
			mysql_free_result($rs);
			break;
		
		} else {

				if (!isPB($no_pelanggan,"3")) {
					if (substr($no_pelanggan,2,4)>'2014') {	   
						$sql  = "insert into bill_pb_pelanggan select kode_wilayah,  kode_rayon,  kode_zona,  no_pelanggan,  nama_pelanggan,  alamat_pelanggan,  rt,  rw,  jml_penghuni,  peruntukan,  kode_tarif,  kode_tarif_baru,  kode_merk_meter,  no_meter,  digit_meter,  ukuran_meter,  keadaan_meter,  letak_meter,  segel_meter,  box_meter,  kondisi_box_meter,  stand_akhir,  no_telepon,  tgl_daftar,  no_daftar,  gambar,  denah,  bea_standar,  bea_daftar,  bea_tambahan,  bea_pasang,  kode_ukuran,  '3',  status_rumah,  luas_bangunan,  jenis_bangunan,  jenis_usaha,  nama_usaha,  keterangan,  pipa_jenis,  pipa_diameter,  pipa_panjang,  pipa_kondisi,  pipa_dinas,  koordinat,  sumber_air,  jml_roda2,  jml_roda4,  keluhan,  cara_bayar,  uang_muka,  sisa_bayar,  lama_cicilan,  besar_cicilan,  mulai_cicilan,  tempat_bayar,  tgl_bayar,  jml_bayar,  pipa_letak, posisi_meter, '".$nama_mitra."','".$alamat_mitra."', kode_rab, last_update, update_by, kolektif,koordinat_boring,jenis_sambungan,kode_kecamatan,kode_kelurahan,telepon_rumah,email from bill_pb_pelanggan where no_pelanggan='".$no_pelanggan."' and stat='2'";
						//echo $sql;
						//if (!mysql_query($sql)) echo "Error : $sql ";
						//$sql  = "update bill_pb_pelanggan set cara_bayar= '".$cara_bayar."',uang_muka= '".strtonumber($_POST['uang_muka'],'.',',')."',sisa_bayar= '".strtonumber($_POST['sisa_bayar'],'.',',')."',lama_cicilan= '".$_POST['lama_cicilan']."',besar_cicilan= '".strtonumber($_POST['besar_cicilan'],'.',',')."',mulai_cicilan= '".$_POST['mulai_cicilan']."',";
						//if ($_POST['kode_jenis']=='0') $sql .=" tempat_bayar= '".$_POST['tempat_bayar']."',last_update= NOW(),update_by='$opr', tgl_bayar='".$_POST['tgl_bayar']."' ";
						////else $sql .=" bea_tambahan=bea_pasang-bea_standar+".$_POST['jml_pot']." , tempat_bayar= '".$_POST['tempat_bayar']."',last_update= NOW(),update_by='$opr', tgl_bayar='".$_POST['tgl_bayar']."' ";
						//else $sql .=" tempat_bayar= '".$_POST['tempat_bayar']."',last_update= NOW(),update_by='$opr', tgl_bayar='".$_POST['tgl_bayar']."' ";
						//$sql .= " where no_pelanggan='".$_POST['no_pelanggan']."' and kode_wilayah='".$_POST['wilayah']."' and kode_rayon='".$_POST['jalan_rayon']."' and stat='3'";       	  
						////echo $sql;
						if (!mysql_query($sql)) echo "Error : $sql ";
					} else 	echo "Nomor Register ".$no_pelanggan." GAGAL SIMPAN ! Silahkan hubungi Administrator Hublang.";
					
				} else {
					
					if (empty($kode_mitra) ) {
						// $sql  = "update bill_pb_pelanggan set cara_bayar= '".$_POST['cara_bayar']."',uang_muka= '".strtonumber($_POST['uang_muka'],'.',',')."',sisa_bayar= '".strtonumber($_POST['sisa_bayar'],'.',',')."',lama_cicilan= '".$_POST['lama_cicilan']."',besar_cicilan= '".strtonumber($_POST['besar_cicilan'],'.',',')."',mulai_cicilan= '".$_POST['mulai_cicilan']."',";
						// $sql .=" tempat_bayar= '".$_POST['tempat_bayar']."',last_update= NOW(),update_by='$opr', nama_mitra='".$_POST['nama_mitra']."', alamat_mitra='".$_POST['alamat_mitra']."', tgl_bayar='".$_POST['tgl_bayar']."' ";
						// $sql .= " where no_pelanggan='".$_POST['no_pelanggan']."' and kode_wilayah='".$_POST['wilayah']."' and stat='3'";
						// if (!mysql_query($sql)) echo "Error : $sql ";
						$sql  = "update bill_pb_pelanggan set last_update= NOW(),update_by='$opr', nama_mitra='".$nama_mitra."', alamat_mitra='".$alamat_mitra."',keluhan='".$keluhan."'  ";
						$sql .= " where no_pelanggan='".$no_pelanggan."' and stat='3'";
						if (!mysql_query($sql)) echo "Error : $sql ";
					} else 	echo "Nomor Register ".$no_pelanggan." GAGAL UPDATE ! Silahkan hubungi Administrator Hublang.";
				}
				//echo $sql;

				/* AWAL SPKP*/
				//$tgl_spk = FormatDate($tgl_spk,'Y-m-d');
				// $tgl_serah = FormatDate($tgl_serah,'Y-m-d');
				// $tgl_selesai = FormatDate($tgl_selesai,'Y-m-d');
				
				if (intval(left($tgl_spk,4))>2000) {
					$tgl_spk = $tgl_spk;
				} else {
					$arr_tgl = explode("-", $tgl_spk);
					$tgl_spk = $arr_tgl[2]."-".$arr_tgl[1]."-".$arr_tgl[0];
				}					
				if (intval(left($tgl_serah,4))>2000) {
					$tgl_serah = $tgl_serah;
				} else {
					$arr_tgl = explode("-", $tgl_serah);
					$tgl_serah = $arr_tgl[2]."-".$arr_tgl[1]."-".$arr_tgl[0];
				}					
				if (intval(left($tgl_selesai,4))>2000) {
					$tgl_selesai = $tgl_selesai;
				} else {
					$arr_tgl = explode("-", $tgl_selesai);
					$tgl_selesai = $arr_tgl[2]."-".$arr_tgl[1]."-".$arr_tgl[0];
				}					
				
				if (intval(left($revisi_tgl_serah,4))>2000) {
					$revisi_tgl_serah = $revisi_tgl_serah;
				} else {
					$arr_tgl = explode("-", $revisi_tgl_serah);
					$revisi_tgl_serah = $arr_tgl[2]."-".$arr_tgl[1]."-".$arr_tgl[0];
				}					
				if (intval(left($revisi_tgl_selesai,4))>2000) {
					$revisi_tgl_selesai = $revisi_tgl_selesai;
				} else {
					$arr_tgl = explode("-", $revisi_tgl_selesai);
					$revisi_tgl_selesai = $arr_tgl[2]."-".$arr_tgl[1]."-".$arr_tgl[0];
				}					
				
				$q0="select * from bill_tr_pb_surat where no_pelanggan='".$no_pelanggan."' limit 1";
				$res0=mysql_query($q0);
				$r0=mysql_fetch_object($res0);
				$no_spkp=$r0->spkp;
				$no_bap=$r0->bap;
				mysql_free_result($res0);
				
				$sql  = "select a.*,b.nama_wilayah from bill_pb_pelanggan a, bill_ms_wilayah b where a.kode_wilayah=b.kode_wilayah and a.no_pelanggan='".$no_pelanggan."' and stat='3' order by a.last_update limit 1";
				$res = mysql_query($sql) or die(mysql_error());
				$r1 = mysql_fetch_object($res);
				
				if (empty($no_spkp)) {
					$q0="select * from bill_no_surat where kode_lokasi='".$_SESSION[CABANG]."'";
					$res0=mysql_query($q0);
					$r0=mysql_fetch_object($res0);
					$spkp=sprintf("%04d",$r0->spkp+1);
					$bap=sprintf("%04d",$r0->bap+1);
					mysql_free_result($res0);
					mysql_query("update bill_no_surat set spkp=".intval($spkp).",bap=".intval($bap)." where kode_lokasi='".$_SESSION[CABANG]."'");
					
					$no_spkp = $spkp."/SPKP/HBL/".Romawi(substr($r1->last_update,5,2))."/".left($r1->last_update,4);
					$no_bap = $bap."/BAP/".Romawi(substr($r1->last_update,5,2))."/".left($r1->last_update,4);
					mysql_query("replace bill_tr_pb_surat(no_pelanggan,spkp,bap,last_update,update_by,tgl_serah,tgl_selesai) values ('".$no_pelanggan."','".$no_spkp."','".$no_bap."',NOW(),'$opr','".$tgl_serah."','".$tgl_selesai."')");
				} else mysql_query("update bill_tr_pb_surat set tgl_serah='".$tgl_serah."',tgl_selesai='".$tgl_selesai."' where no_pelanggan='".$no_pelanggan."' limit 1");
			
				//ANDROID
				if ($revisi_tgl_serah) $qry = "UPDATE bill_tr_pb_android SET pasang_tgl='$tgl_spk ".date('H:i:s')."',pasang_user='$opr',no_spkp='$no_spkp',no_bap='$no_bap', kode_mitra='".$kode_mitra."', nama_mitra='".$nama_mitra."', alamat_mitra='$alamat_mitra', kontak_mitra='$kontak_mitra',keluhan='".$catatan."',tgl_serah='$tgl_serah',tgl_selesai='$tgl_selesai',revisi_tgl_serah='$revisi_tgl_serah',revisi_tgl_selesai='$revisi_tgl_selesai' WHERE no_pelanggan='$no_pelanggan' LIMIT 1";
				else $qry = "UPDATE bill_tr_pb_android SET pasang_tgl='$tgl_spk ".date('H:i:s')."',pasang_user='$opr',no_spkp='$no_spkp',no_bap='$no_bap', kode_mitra='".$kode_mitra."', nama_mitra='".$nama_mitra."', alamat_mitra='$alamat_mitra', kontak_mitra='$kontak_mitra',keluhan='".$catatan."',tgl_serah='$tgl_serah',tgl_selesai='$tgl_selesai' WHERE no_pelanggan='$no_pelanggan' LIMIT 1";
				$rs = mysql_query($qry);
				if (mysql_affected_rows()>=0)	{

					//KIRIM EMAIL
					if ($email) KirimEmailSPK($no_pelanggan, $tgl_serah, $tgl_selesai);
					
					echo "Data $no_pelanggan Berhasil di Proses";

				} else {
				
					echo "Data $no_pelanggan Gagal di Proses";
				}

				mysql_free_result($rs);
		}
		        
        break;
		
	case 'tambah_kelompok':
	
		//ANDROID
		$qry  = "REPLACE bill_tr_pb_android_tmp(no_pelanggan,nama_pelanggan,alamat_pelanggan,last_update,update_by) ";
		$qry .= " VALUES ('$no_pelanggan', '$nama_pelanggan', '$alamat_pelanggan', NOW(), '$opr')";
		$rs = mysql_query($qry);
		if (mysql_affected_rows()) echo "Data $no_pelanggan Berhasil di Tambah";
		else echo "Data $no_pelanggan Gagal di Tambah";
		break;
		
	case 'edit_kelompok':
	
		//ANDROID
		$qry  = "UPDATE bill_tr_pb_android_tmp SET last_update=NOW(),update_by='$opr' WHERE no_pelanggan='$no_pelanggan' and update_by='$opr' LIMIT 1";
		$rs = mysql_query($qry);
		if (mysql_affected_rows()) echo "Data $no_pelanggan Berhasil di Ubah";
		else echo "Data $no_pelanggan Gagal di Ubah";
		break;
	
	case 'hapus_kelompok':	
		//ANDROID
		$qry  = "DELETE FROM bill_tr_pb_android_tmp WHERE no_pelanggan='$no_pelanggan' and update_by='$opr' LIMIT 1";
		$rs = mysql_query($qry);
		if (mysql_affected_rows()) echo "Data $no_pelanggan Berhasil di Hapus";
		else echo "Data $no_pelanggan Gagal di Hapus";
		break;
		
	case 'proses_kelompok':	
		$sql0 = "";
		$qry0  = "SELECT * FROM bill_tr_pb_android_tmp WHERE update_by='$opr' ORDER BY last_update";
		$rs0 = mysql_query($qry0);
		while ($r0 = mysql_fetch_object($rs0)) {

				if (!isPB($r0->no_pelanggan,"3")) {
					if (substr($r0->no_pelanggan,2,4)>'2014') {	   
						$sql  = "insert into bill_pb_pelanggan select kode_wilayah,  kode_rayon,  kode_zona,  no_pelanggan,  nama_pelanggan,  alamat_pelanggan,  rt,  rw,  jml_penghuni,  peruntukan,  kode_tarif,  kode_tarif_baru,  kode_merk_meter,  no_meter,  digit_meter,  ukuran_meter,  keadaan_meter,  letak_meter,  segel_meter,  box_meter,  kondisi_box_meter,  stand_akhir,  no_telepon,  tgl_daftar,  no_daftar,  gambar,  denah,  bea_standar,  bea_daftar,  bea_tambahan,  bea_pasang,  kode_ukuran,  '3',  status_rumah,  luas_bangunan,  jenis_bangunan,  jenis_usaha,  nama_usaha,  keterangan,  pipa_jenis,  pipa_diameter,  pipa_panjang,  pipa_kondisi,  pipa_dinas,  koordinat,  sumber_air,  jml_roda2,  jml_roda4,  keluhan,  cara_bayar,  uang_muka,  sisa_bayar,  lama_cicilan,  besar_cicilan,  mulai_cicilan,  tempat_bayar,  tgl_bayar,  jml_bayar,  pipa_letak, posisi_meter, '".$nama_mitra."','".$alamat_mitra."', kode_rab, last_update, update_by, kolektif,koordinat_boring,jenis_sambungan,kode_kecamatan,kode_kelurahan,telepon_rumah,email from bill_pb_pelanggan where no_pelanggan='".$r0->no_pelanggan."' and stat='2'";
						if (!mysql_query($sql)) echo "Error : $sql ";
					} 
					//else 	echo "Nomor Register ".$r0->no_pelanggan." GAGAL SIMPAN ! Silahkan hubungi Administrator Hublang.";
					
				} else {
					
					if (empty($kode_mitra) ) {
						$sql  = "update bill_pb_pelanggan set last_update= NOW(),update_by='$opr', nama_mitra='".$nama_mitra."', alamat_mitra='".$alamat_mitra."',keluhan='".$catatan."'  ";
						$sql .= " where no_pelanggan='".$r0->no_pelanggan."' and stat='3'";
						if (!mysql_query($sql)) echo "Error : $sql ";
					} 
					//else 	echo "Nomor Register ".$r0->no_pelanggan." GAGAL UPDATE ! Silahkan hubungi Administrator Hublang.";
				}
				//echo $sql;
				
				if (intval(left($tgl_serah,4))>2000) {
					$tgl_serah = $tgl_serah;
				} else {
					$arr_tgl = explode("-", $tgl_serah);
					$tgl_serah = $arr_tgl[2]."-".$arr_tgl[1]."-".$arr_tgl[0];
				}					
				if (intval(left($tgl_selesai,4))>2000) {
					$tgl_selesai = $tgl_selesai;
				} else {
					$arr_tgl = explode("-", $tgl_selesai);
					$tgl_selesai = $arr_tgl[2]."-".$arr_tgl[1]."-".$arr_tgl[0];
				}					
								
				$q2="select * from bill_tr_pb_surat where no_pelanggan='".$r0->no_pelanggan."' limit 1";
				$res2=mysql_query($q2);
				$r2=mysql_fetch_object($res2);
				$no_spkp=$r2->spkp;
				$no_bap=$r2->bap;
				mysql_free_result($res2);
				
				$sql  = "select a.*,b.nama_wilayah from bill_pb_pelanggan a, bill_ms_wilayah b where a.kode_wilayah=b.kode_wilayah and a.no_pelanggan='".$r0->no_pelanggan."' and stat='3' order by a.last_update limit 1";
				$res = mysql_query($sql) or die(mysql_error());
				$r1 = mysql_fetch_object($res);
				
				if (empty($no_spkp)) {
					$q2="select * from bill_no_surat where kode_lokasi='".$_SESSION[CABANG]."'";
					$res2=mysql_query($q2);
					$r2=mysql_fetch_object($res2);
					$spkp=sprintf("%04d",$r2->spkp+1);
					$bap=sprintf("%04d",$r2->bap+1);
					mysql_free_result($res2);
					mysql_query("update bill_no_surat set spkp=".intval($spkp).",bap=".intval($bap)." where kode_lokasi='".$_SESSION[CABANG]."'");
					
					$no_spkp = $spkp."/SPKP/HBL/".Romawi(substr($r1->last_update,5,2))."/".left($r1->last_update,4);
					$no_bap = $bap."/BAP/".Romawi(substr($r1->last_update,5,2))."/".left($r1->last_update,4);
					mysql_query("replace bill_tr_pb_surat(no_pelanggan,spkp,bap,last_update,update_by,tgl_serah,tgl_selesai) values ('".$r0->no_pelanggan."','".$no_spkp."','".$no_bap."',NOW(),'$opr','".$tgl_serah."','".$tgl_selesai."')");
				} 
				else mysql_query("update bill_tr_pb_surat set tgl_serah='".$tgl_serah."',tgl_selesai='".$tgl_selesai."' where no_pelanggan='".$r0->no_pelanggan."' limit 1");
			
				//ANDROID
				$qry = "UPDATE bill_tr_pb_android SET pasang_tgl=NOW(),pasang_user='$opr',no_spkp='$no_spkp',no_bap='$no_bap', kode_mitra='".$kode_mitra."', nama_mitra='".$nama_mitra."', alamat_mitra='$alamat_mitra', kontak_mitra='$kontak_mitra',keluhan='".$catatan."',tgl_serah='$tgl_serah',tgl_selesai='$tgl_selesai' WHERE no_pelanggan='$r0->no_pelanggan' LIMIT 1";
				mysql_query($qry);
				
				//HAPUS ANDROID_TMP
				$qry9  = "DELETE FROM bill_tr_pb_android_tmp WHERE no_pelanggan='$r0->no_pelanggan' and update_by='$opr' LIMIT 1";
				mysql_query($qry9);
			
		}

		echo "Data Kelompok Berhasil di Proses";
		
		break;

	case 'batal':	
		//ANDROID
		$qry  = "UPDATE bill_tr_pb_android SET revisi_tgl_serah=null, revisi_tgl_selesai=null WHERE no_pelanggan='$no_pelanggan' and ( YEAR(revisi_tgl_serah)>0 OR YEAR(revisi_tgl_selesai)>0 ) LIMIT 1";
		$rs = mysql_query($qry);
		if (mysql_affected_rows()==0) {
			//$qry  = "UPDATE bill_tr_pb_android SET pasang_tgl=null, pasang_user=null, pasang_spk=null, pasang_kontak=null, tgl_serah=null, tgl_selesai=null, revisi_tgl_serah=null, revisi_tgl_selesai=null, kode_mitra=null, nama_mitra=null, alamat_mitra=null, kontak_mitra=null WHERE no_pelanggan='$no_pelanggan' LIMIT 1";
			$qry  = "UPDATE bill_tr_pb_android SET pasang_tgl=null, pasang_user=null, pasang_spk=null, pasang_kontak=null, tgl_serah=null, tgl_selesai=null, revisi_tgl_serah=null, revisi_tgl_selesai=null WHERE no_pelanggan='$no_pelanggan' LIMIT 1";
			$rs = mysql_query($qry);
			if (mysql_affected_rows()) echo "Data $no_pelanggan Berhasil Dibatalkan";
			else echo "Data $no_pelanggan Gagal Dibatalkan";
		} echo "Data $no_pelanggan Berhasil Dibatalkan";

		 //LOG
		 $qry="replace into bill_tr_log(no_pelanggan,nama_table,proses,asal,tujuan,update_by,last_update) values ('$no_pelanggan','bill_tr_pb_android(Batal SPK)','update','','".str_replace("'","",$qry)."','$opr',NOW())";
		 mysql_query($qry);
		
		break;
		
	default:
		echo $no_pelanggan." OK";
		break;
}
    
?>