<?php
switch($_GET[act]){
	//tampil surat keluar
	default:
	echo "
	<h2><center>Data Surat Keluar</center></h2>
<form method='post' action=''>
<input type='text' name='search' /> <input type='submit' name='submit' value='Cari'/>";

$p		= new Paging;
$batas	= 50;
$posisi	= $p -> cariPosisi($batas);
$no=$posisi+1;
$search=$_POST['search'];
$sql="select *from suratkeluar where kepada like '%$search%'  or perihal like '%$search%'  order by id";
$hasil =mysql_query($sql);
$dt_masuk = mysql_num_rows($hasil);
echo "
<table width='100%' border='1' cellspacing='0' cellpadding='0'>
  <tr>
    <td colspan='9' class='hovereffect'><a href='?page=suratkeluar&act=suratkeluar_input'><img src='images/add.png'
	 height='15' width='15' /> Tambah </a></td>

  </tr>
  <tr>
    <td>No</td>
    <td>No. Surat</td>
    <td>Kepada</td>
    <td>Tanggal Kirim</td>
    <td>Perihal</td>
    <td>Lampiran</td>
    <td>Dokumen</td>
    <td colspan='2'>Opsi</td>
  </tr>";

  while ($record=mysql_fetch_array($hasil)){
  echo "
  <tr>
    <td>$no</td>
    <td>$record[no_surat]</td>
    <td>$record[kepada]</td>
    <td>$record[tanggal]</td>
    <td>$record[perihal]</td>
    <td>$record[lampiran]</td>
    <td><a href='filesuratkeluar/$record[dokumen]'>$record[dokumen]</a></td>
    <td><a href='?page=suratkeluar&act=suratkeluar_edit&id=".$record['id']."'><img src='images/update.png' /></a></td>
    <td><a href='?page=suratkeluar&act=hapus&id=$record[id]' onclick='return confirm('Yakin Hapus?')'><img src='images/delete.png' /></a></td>
  </tr>";
 $no++; }
echo "</table><br />";
$jmldata		= mysql_num_rows(mysql_query("SELECT * FROM suratkeluar"));
  $jmlhalaman	= $p->jumlahHalaman($jmldata, $batas);
  $linkHalaman	= $p->navHalaman($_GET[halaman], $jmlhalaman);
  echo "$linkHalaman
  <br />Jumlah data masuk : $dt_masuk data
</form>" ;
break;
//-----------------------------------------------------------------------------------------------------------------//
	//input suratkeluar
	case "suratkeluar_input";
echo "
	<h2><center>Add Data Surat Keluar</center></h2>
<form method='post' action='?page=suratkeluar&act=suratkeluar_simpan' enctype='multipart/form-data'>
<table width='100%' border='1' cellspacing='0' cellpadding='0'>
  <tr>
    <td>No. Surat</td>
    <td><input type='text' name='no_surat'  /></td>
  </tr>
  <tr>
    <td>Kepada</td>
    <td><input type='text' name='kepada' style='width:50%' /></td>
  </tr>
  <tr>
    <td>Tanggal Masuk</td>
    <td><input type='text' name='tanggal' id='tanggal' value=".date ('d-m-Y')."  /> </td>
  </tr>
  <tr>
    <td>Perihal</td>
    <td><input type='text' name='perihal' style='width:70%' /></td>
  </tr>
  <tr>
    <td>Lampiran</td>
    <td><input type='text' name='lampiran' /></td>
  </tr>
  <tr>
    <td>Dokumen</td>
    <td><input type='file' name='dokumen' /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><input type='submit' name='submit' value='Simpan' /><input type='button' value='Kembali' onclick='history.back()' /></td>
  </tr>

</table>
</form>	";
break;

//--------------------------------------------------------//
//simpan surat keluar
case "suratkeluar_simpan";
$no_surat =$_POST['no_surat'];
$kepada = $_POST['kepada'];
$tanggal = $_POST['tanggal'];
$perihal=$_POST['perihal'];
$lampiran = $_POST ['lampiran'];
$submit=$_POST['submit'];

$lokasi_file=$_FILES['dokumen']['tmp_name'];
$nama_file=$_FILES['dokumen'] ['name'];
$ukuran_file=$_FILES['dokumen']['size'];
$direktori="filesuratkeluar/$nama_file";
move_uploaded_file($lokasi_file,"$direktori");
$sql="Insert into suratkeluar values ('','$no_surat','$kepada','$tanggal','$perihal','$lampiran','$nama_file')";

//Peringatan Form yang kosong
if(isset($submit)){
 if(empty($no_surat)){
  echo"<script>window.alert('No Surat kosong!');history.go(-1)</script>";
 }elseif(empty($kepada)){
  echo"<script>window.alert('Form Kepada kosong!');history.go(-1)</script>";
 }elseif(empty($tanggal)){
  echo"<script>window.alert('Tanggal kosong!');history.go(-1)</script>";
 }elseif(empty($perihal)){
  echo"<script>window.alert('Perihal kosong!');history.go(-1)</script>";
 }elseif(empty($lampiran)){
  echo"<script>window.alert('Lampiran kosong!');history.go(-1)</script>";
 }elseif(empty($lokasi_file)){
  echo"<script>window.alert('Dokumen kosong!');history.go(-1)</script>";
 }

elseif (mysql_query($sql)){
	echo "<script>alert('Berhasil Disimpan');
	location='?page=suratkeluar'</script>";
	}
else {
	echo "<script>alert ('Gagal');
	history.go(-1)</script>";
	}
}
break;
//---------------------------------------------------------------------------------------------------------------//
//edit surat keluar
case 'suratkeluar_edit';

$id=$_GET['id'];
$sql="select *from suratkeluar where id=$id";
$hasil=mysql_query($sql);
$record=mysql_fetch_array($hasil);
echo "
<body>
<h2><center>Edit Data Surat Keluar</center></h2>
<form method='post' action='?page=suratkeluar&act=update' enctype='multipart/form-data'>
<table width='100%' border='1' cellspacing='0' cellpadding='0'>
  <tr>
    <td>No. Surat</td>
    <td><input type='text' name='no_surat' value='$record[no_surat]'/> <input type='hidden' name='id' value='$record[id]' /></td>
  </tr>
  <tr>
    <td>Pengirim</td>
    <td><input type='text' name='kepada' value='$record[kepada]' style='width:50%'/></td>
  </tr>
  <tr>
    <td>Tanggal Masuk</td>
    <td><input type='text' name='tanggal' id='tanggal' value='$record[tanggal]' /></td>
  </tr>
  <tr>
    <td>Perihal</td>
    <td><input type='text' name='perihal' value ='$record[perihal]' style='width:70%'/></td>
  </tr>
  <tr>
    <td>Lampiran</td>
    <td><input type='text' name='lampiran' value='$record[lampiran]'/></td>
  </tr>
  <tr>
    <td>Dokumen</td>
    <td><b>$record[dokumen]</b> <i>*) jika file tidak diubah kosongkan saja</i> <br /> <br /> <input type='file' name='dokumen' /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><input type='submit' name='submit' value='Simpan' /><input type='button' value='Kembali' onclick='history.back()' /></td>
  </tr>

</table>
</form> ";
break;
//---------------------------------------------------------------------------------------------------------------------//
//update
case 'update';
$id=$_POST['id'];
$no_surat =$_POST['no_surat'];
$kepada = $_POST['kepada'];
$tanggal = $_POST['tanggal'];
$perihal=$_POST['perihal'];
$lampiran = $_POST ['lampiran'];

$lokasi_file=$_FILES['dokumen']['tmp_name'];
$nama_file=$_FILES['dokumen'] ['name'];
$ukuran_file=$_FILES['dokumen']['size'];
$direktori="filesuratkeluar/$nama_file";
move_uploaded_file($lokasi_file,"$direktori");

if (empty($lokasi_file)){
$sql="update suratkeluar set no_surat='$no_surat',kepada='$kepada', tanggal='$tanggal', perihal='$perihal', lampiran='$lampiran' where id=$id";
}

else{
$sql="update suratkeluar set no_surat='$no_surat',kepada='$kepada',  tanggal='$tanggal', perihal='$perihal', lampiran='$lampiran', dokumen='$nama_file'  where id=$id";}

$hasil =mysql_query($sql);
if ($hasil){
	echo "<script>alert('Berhasil Diupdate');
	location='?page=suratkeluar'</script>";
	}
else {
	echo "<script>alert('Gagal');
	history.go(-1)</script>";
	}
break;
//-------------------------------------------------------------------------------------------------------------------------------//
case 'hapus';
$id=$_GET['id'];
$sql="delete from suratkeluar where id='$id'";
$hasil=mysql_query($sql);
if ($hasil){
	echo "<script>alert ('Terhapus');
	location='?page=suratkeluar'</script>";
	}
else {
	echo "<script>alert ('Gagal');
	history.go(-1);";
	}

break;

}
?>