Untitled

<center><h2>Pelayanan PPK 1 Puskesmas </center>
<script type="text/javascript" src="../jscripts/ckeditor/ckeditor.js"></script>
<script type="text/javascript" src="../jscripts/ckfinder/ckfinder.js"></script>

<?php
if($this->input->get('ref') == 'form'){
?>
	<?php
	//query
	$submit = $this->input->post('submit');
	if($submit != FALSE){
		$starttime = microtime();

		//initialize
		$kode_pkm = $this->input->post('kode_pkm');
		$kepala = $this->input->post('kepala');
		$nip = $this->input->post('nip');
		$id_user = $this->session->userdata('id_puskesmas');
		$publish = $this->input->post('publish');
		$nama_puskesmas = $this->input->post('nama_puskesmas');
		$id_kecamatan = $this->input->post('id_kecamatan');
		$content = $this->input->post('content');
		$username = $this->input->post('username');
		$password = $this->input->post('password');
		$password = md5($password);
		$id_puskesmas = $this->input->post('id_puskesmas');


		if($id_puskesmas  == FALSE){
			$query = $this->db->query("insert into tbl_puskesmas
										( id_kecamatan, nama_puskesmas,  kode_pkm,kepala, nip, username, password, content, user, publish)
										value
										('$id_kecamatan','$nama_puskesmas',  '$kode_pkm', '$kepala' , '$nip', '$username', '$password', '$content', '$id_user', '$publish')
										");
			//id baru
			$query = $this->db->query("select id_puskesmas as idbaru from tbl_puskesmas where user = '$id_user' order by id_puskesmas desc");
			$row = $query->row();
			$idbaru = $row->idbaru;

		}else{
			$query = $this->db->query("update tbl_puskesmas set
											id_kecamatan = '$id_kecamatan',
											nama_puskesmas = '$nama_puskesmas',
											kode_pkm = '$kode_pkm',
											kepala = '$kepala',
											nip = '$nip',
											username = '$username',
											password = '$password',
											content= '$content',
											publish = '$publish'
											where id_puskesmas = '$id_puskesmas'");
		}


		//menghitung execution time
		$endtime = microtime();
		$stime = explode(" ",$starttime);
		$qtime1 = $stime[1] + $stime[0];

		$etime = explode(" ",$endtime);
		$qtime2 = $etime[1] + $etime[0];
		$totaltime = substr($qtime2 - $qtime1,0,8);

		if($query){
		?>
			<div style="text-align:right;">
				Query selesai dalam <?php echo $totaltime; ?> detik<br>
				Proses data berhasil
			</div>
		<?php
		}else{
		?>
			<div style="text-align:right;">
				Query selesai dalam <?php echo $totaltime; ?> detik<br>
				Proses data gagal
			</div>
		<?php
		}


	}
	?>
	<?php
	//initialize
	$kode_pkm = "";
	$kepala = "";
	$nip = "";
	$id_kecamatan = "";
	$nama_puskesmas = "";
	$publish = "1";
	$content ="";
	$username ="";
	$password = "";


	if(isset($idbaru)){
		$id_puskesmas = $idbaru;
	}else{
		$id_puskesmas = $this->input->get('id_puskesmas');
	}
	if($id_puskesmas != FALSE){
		$query = $this->db->query("select * from tbl_puskesmas where id_puskesmas = '$id_puskesmas'");
		$row = $query->row();
		$kode_pkm = $row->kode_pkm;
		$kepala = $row->kepala;
		$nip = $row->nip;
		$id_kecamatan = $row->id_kecamatan;
		$nama_puskesmas = $row->nama_puskesmas;
		$publish = $row->publish;
		$content = $row->content;
		$username = $row-> username ;
		$password = $row-> password ;

	}

	?>
	<div>
		<form action="" method=post>
			<input type=hidden name=id_puskesmas value="<?php echo $id_puskesmas; ?>">
			<table>
				<tr>
					<td width=150>Nama Puskesmas</td><td><input type=text name=nama_puskesmas size=90 value="<?php echo $nama_puskesmas; ?>"></td>
				</tr>
				<tr>
					<td>Nama Kecamatan</td>
					<td>
						<select name=id_kecamatan>
							<option value="-"  > </option>
							<option value="1" <?php if($id_kecamatan ==1){ echo "selected";} ?>> Kecamatan Sawangan
							<option value="2" <?php if($id_kecamatan ==2){ echo "selected";} ?>> Kecamatan Bojong Sari</option>
							<option value="3" <?php if($id_kecamatan ==3){ echo "selected";} ?>> Kecamatan Pancoran Mas</option>
							<option value="4" <?php if($id_kecamatan ==4){ echo "selected";} ?>> Kecamatan Cipayung</option>
							<option value="5" <?php if($id_kecamatan ==5){ echo "selected";} ?>> Kecamatan Sukmajaya</option>
							<option value="6" <?php if($id_kecamatan ==6){ echo "selected";} ?>> Kecamatan Cilodong</option>
							<option value="7" <?php if($id_kecamatan ==7){ echo "selected";} ?>> Kecamatan Cimanggis</option>
							<option value="8" <?php if($id_kecamatan ==8){ echo "selected";} ?>> Kecamatan Tapos</option>
							<option value="9" <?php if($id_kecamatan ==9){ echo "selected";} ?>> Kecamatan Beji</option>
							<option value="10"<?php if($id_kecamatan ==10){ echo "selected";} ?>> Kecamatan Limo</option>
							<option value="11"<?php if($id_kecamatan ==11){ echo "selected";} ?>> Kecamatan Cinere</option>
						</select>
					</td>
				</tr>
				<tr>
					<td width=150>Kode pkm</td><td><input type=text name=kode_pkm size=90 value="<?php echo $kode_pkm; ?>"></td>
				</tr>
				<tr>
					<td width=150>Kepala Puskesmas</td><td><input type=text name=kepala size=90 value="<?php echo $kepala; ?>"></td>
				</tr>
				<tr>
					<td width=150>Nip</td><td><input type=text name=nip size=90 value="<?php echo $nip; ?>"></td>
				</tr>
				<tr>
					<td width=150>username</td><td><input type=text name=username size=90 value="<?php echo $username; ?>"></td>
				</tr>
				<tr>
					<td width=150>password</td><td><input type=password name=password size=90 value="<?php echo $password; ?>"></td>
				</tr>
				<tr>
					<td>Publish</td>
					<td>
						<select name=publish>
							<option value="1" <?php if($publish == 1){ echo"selected"; } ?>>Ya
							<option value="0" <?php if($publish == 0){ echo"selected"; } ?>>Tidak
						</select>
					</td>
				</tr>
				<tr>
					<td colspan=2><br><textarea name=content id="editor1" ><?php echo $content; ?></textarea></td>
				</tr>
				<tr>
					<td colspan=2 align=right>
					<?php if($id_puskesmas != FALSE){ ?>
					<input type=submit name=submit value=Ubah>
					<?php }else{ ?>
					<input type=submit name=submit value=Simpan>
					<?php } ?>
					&nbsp;
					<input type=button value=Batal onClick="window.location.href='?ref=list'">
					</td>
				</tr>
			</table>
		</form>
	</div>
<?php
}else{
?>
	<?php
	if($this->input->get('ref') == 'drop'){
		$starttime = microtime();

		$id_puskesmas = $this->input->get('idrop');
		$qdrop = $this->db->query("delete from tbl_puskesmas where id_puskesmas = '$id_puskesmas'");

		//menghitung execution time
		$endtime = microtime();
		$stime = explode(" ",$starttime);
		$qtime1 = $stime[1] + $stime[0];

		$etime = explode(" ",$endtime);
		$qtime2 = $etime[1] + $etime[0];
		$totaltime = substr($qtime2 - $qtime1,0,8);

		if($qdrop){
		?>
			<div style="text-align:right;">
				Query selesai dalam <?php echo $totaltime; ?> detik<br>
				Proses data berhasil
			</div>
		<?php
		}else{
		?>
			<div style="text-align:right;">
				Query selesai dalam <?php echo $totaltime; ?> detik<br>
				Proses data gagal
			</div>
		<?php
		}
	}
	?>
	<div class=datatable>
		<table width=100%>
			<tr>
				<th>No.</th><th>kode</th><th>Instansi</th><th>publish</th><th>Edit</th><th>Delete</th>
			</tr>
			<?php
			$no = 0;
			$qmenu = $this->db->query("select * from tbl_puskesmas ");
			foreach ($qmenu->result() as $rmenu){
			$no++;
			?>
				<tr>
					<td width=10><?php echo $no; ?></td>
					<td align=center><?php echo $rmenu->kode_pkm; ?></td>
					<td align=center><?php echo $rmenu->nama_puskesmas; ?></td>
					<td align=center><?php echo $rmenu->publish; ?></td>
					<td align=center width=50><a href="?ref=form&id_puskesmas=<?php echo $rmenu->id_puskesmas; ?>">Edit</a></td>
					<td align=center width=50><a href="?ref=drop&idrop=<?php echo $rmenu->id_puskesmas; ?>">Hapus</a></td>

				</tr>
			<?php
			}
			?>
		</table>
	</div>

	<div style="text-align:right;margin-top:10px;">
		<input type=button value="Buat Baru" onClick="window.location.href='?ref=form'">
	</div>
<?php
}
?>

<script language="javascript" type="text/javascript">
		var editor = CKEDITOR.replace( 'editor1' );
		CKFinder.setupCKEditor( editor, '../jscripts/ckfinder/' ) ;
</script>