Logout | "
."
Baca | "
."
Edit | "
."
Hapus | "
."";
//echo 'Anda telah login, jadi .... boleh lah di sini';
}else{
die('
sekretaris ...Maaf, Anda harus login dahulu
');
}
switch ($_GET['op']){
case "read": read_surat_masuk($_SESSION['id']); break;
case "read_detail": read_surat_masuk_detail($_GET["kd_surat_masuk"]); break;
case "update": update_surat_masuk($_GET["kd_Surat_Masuk"]); break;
case "delete": delete_surat_masuk($_GET["kd_Surat_Masuk"]);break;
default: update_surat_masuk($_SESSION['id']);
}
?>
validasi surat masuk ] ";
echo "
ANDA MEMILIKI $jumlah_surat_masuk surat masuk
";
//tampilkan tabel surat masuk
/*
SELECT m.pengirim, m.perihal FROM `surat masuk` as m , disposisi as d
WHERE d.kd_user=2 AND m.kd_surat_masuk = d.kd_surat_masuk ;
*/
$sql = "SELECT m.kd_surat_masuk, m.pengirim, m.perihal FROM `surat masuk` as m , disposisi as d
WHERE d.kd_user=".$id ." AND m.kd_surat_masuk = d.kd_surat_masuk ;";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
//printf("SITU ID: %s Nama: %s [
Edit][Hapus]
", $row[0], $row[1]);
?>
}
}
function read_surat_masuk_detail($kd_surat_masuk){
?>
Baca Lebih Detail
include_once "koneksi.php";
$sql = "SELECT * FROM `surat masuk` where kd_Surat_Masuk=$kd_surat_masuk ";
echo $sql;
$result = mysql_query($sql,$koneksi);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
/*
print_r($row);
Array
(
[kd_Surat_Masuk] => 1
[no_agenda] => 13
[no_disposisi] => 1
[tgl_surat] => 2012-09-12 13:14:40
[pengirim] => pertanahan
[perihal] => sosialisasi
[tgl_disposisi] => 2012-09-22 13:15:00
[tujuan] => ke user kasubag
[Keterangan] => telah saya kirim
[scan] =>
)
*/
?>
|
|
| kd_Surat_Masuk |
=$row['kd_Surat_Masuk'] ?> |
| no_agenda |
=$row['no_agenda'] ?> |
| no_disposisi |
=$row['no_disposisi'] ?> |
| tgl_surat |
=$row['tgl_surat'] ?> |
| pengirim |
=$row['pengirim'] ?> |
| perihal |
=$row['perihal'] ?> |
| tgl_disposisi |
=$row['tgl_disposisi'] ?> |
| tujuan |
=$row['tujuan'] ?> |
| keterangan |
=$row['keterangan'] ?> |
| hasil scan |
=$row['scan'] ?> |
| '>EDIT
| '>HAPUS
|
}
}
function update_surat_masuk($id){
?>
Ubah Surat Masuk
if($kd){
//update tabel surat_masuk
//ubah surat masuk yang id nya $kd
include_once "koneksi.php";
$kd_surat_masuk = $kd;
$no_agenda=$_POST["no_agenda"];
$no_disposisi=$_POST["no_disposisi"];
$tgl_surat=$_POST["tgl_surat"];
$pengirim=$_POST["pengirim"];
$perihal=$_POST["perihal"];
$tgl_disposisi=$_POST["tgl_disposisi"];
$tujuan=$_POST["tujuan"];
$keterangan=$_POST["keterangan"];
$scan = $_FILES['scan'];
$simpan= "UPDATE `bappeda`.`surat_masuk` SET `no_agenda` = '$no_agenda',
`no_disposisi` = '$no_disposisi',
`tgl_surat` = '$tgl_surat',
`pengirim` = '$pengirim',
`perihal` = '$perihal',
`tgl_disposisi` = '$tgl_disposisi',
`perihal` = '$tujuan',
`keterangan` = '$keterangan',
`scan` = '$scan',
WHERE `kd_Surat_Masuk`='$kd'
";
$move1 = move_uploaded_file($_FILES['scan']['tmp_name'], 'scan/'.$scan);
$ok=mysql_query($submit);
if($ok and $move1){
echo "
DATA SUDAH TERKIRIM, !" ;}
else{
echo "data telah disimpan". mysql_error();
}
echo"
Back ";
}
include_once "koneksi.php";
$sql = "SELECT * from `surat masuk` where kd_user=".$id." ";
$qry = mysql_query($sql,$koneksi)
or die ("SQL Error: ".mysql_error());
$data=mysql_fetch_array($qry)
?>