LAMPIRAN A LISTING PROGRAM

LAMPIRAN A LISTING PROGRAM


header("Location: index.php?status=$stat");

session_start();

}

$fusername=$_POST['fusername'];

?>

$fpassword=md5($_POST['fpassword']);

• Depan
• Pengolahan Data Master
  • Kriteri a Seleksi
  • Krit eria Jabatan
  
  
  $fperiode=$_POST['fperiode']; $tahun=date(Y); include"koneksi.php"; $ambil_data="SELECT * FROM pegawai WHERE username='$fusername' AND password='$fpassword'";
  
  $query_ambil_data=mysql_query($ambil_da ta) or die (mysql_error());
  
  $jml=mysql_num_rows($query_ambil_data) ;
  
  
  • Standa r Nilai
  
  
  while($data=mysql_fetch_array($query_am bil_data)){
  
  
  • User
  • Jabata n
  • Jurusa n
• Ubah Password

$level=$data['level']; $status=$data['status']; } if($jml==1 and $status=='aktif'){ $_SESSION['username']=$fusername; $_SESSION['password']=$fpassword; $_SESSION['periode']=$fperiode; $_SESSION['level']=$level; $_SESSION['login']='login'; $_SESSION['tahun']=$tahun; header("Location: index.php");


}else{

$tambah=$_POST['tambah'];

$_SESSION['login']='salah';

if($tambah=='ya'){?>

if($status=='nonaktif'){$stat="tdk";}else{$st at="ya";}

Tambah Kriteria Seleksi

A-1



$kd_seleksi=$_POST['kd_seleksi'];



$bobot_seleksi=$_POST['bobot_seleksi'];

$jenis_seleksi=$_POST['jenis_seleksi'];

if($simpan=='ya'){ $aksi=$_GET['aksi']; if($aksi=='minimum'){



$nilai=$_POST['nilai']; $masukan_minimum="insert into nilai_minimum(nilai_minimum)values('$nila i')";



$query_minimum=mysql_query($masukan_ minimum);

if($query_minimum){

?>

Data berhasil di simpan

Kode Seleksi
Jenis Seleksi

}else{
?>

values('$kd_seleksi*$periode','$periode','$je nis_seleksi','$bobot_seleksi')";

Data Kriteria Seleksi

$query_tambah_data=mysql_query($tambah _data);

$simpan=$_POST['simpan'];

A-2

if($query_tambah_data){ ?>

Kriteria Masih

">

Data berhasil di simpan

";?>

?>

Kode KriteriaNama KriteriaAksi

Kode seleksi sudah digunakan

";?>

}

}else{ while($data

=

mysql_fetch_array($res)){

?>







echo

Data Kriteria Jabatan

align="center" cellspacing="0"> $exkode=explode("*",$data['kd_sel eksi']); ?> $res style="background:#d6fdda; "> = mysql_query($sql ); $jml=mysql_num_rows($res); A-3 echo style="background:#d6fdda; padding:10px; " valign="top" align="center"> Nilai minimum   ">Ubah $ambil_minimum="select*from nilai_minimum"; if($tahun==$periode){ $query_minimum=mysql_query($a mbil_minimum); ?> $data_minimum=mysql_fetch_arra y($query_minimum); style="background:#d6fdda; "> eriode){?> type="hidden" value="ya"/> $sql = "SELECT * FROM kriteria_penempatan_jabatan"; $res = mysql_query($sql ); while($data mysql_fetch_array($res)){ = ?> $jml_minimum=mysql_num_rows( $query_minimum); if($jml_minimum==0){ ?> masukan nilai minimum Aksi Nilai Minimum :

Penempatan

cellpadding="10"

8px;" echo







A-5



}

?>

	">Ubah
Kode Kriteria	Nama Kriteria	Bobot

if($bag=='ubah'){



$kd=$_GET['kd']; $ambil_data="select*from kd_jabatan='$kd'";

jabatan

name="ubah"

name="kd"



where



$query_ambil_data=mysql_query($ambil_da ta);


$data=mysql_fetch_array($query_ambil_dat a);

if($bag=='detail'){

?>

$kd=$_GET['kd'];

Ubah Nilai Minimum

//tambah data



$tambah=$_GET['tambah']; if($tambah=='ya'){



$keahlianbaru=$_POST['jenis'];

$ambil_keahlian="select*from keahlian where kd='$kd'";



$query_ambil_keahlian=mysql_query($ambi l_keahlian) or die (mysql_error());

A-6

$jml_keahlian=mysql_num_rows($ query_ambil_keahlian);




Data berhasil di simpan



if($jml_keahlian==0){ $tambah_keahlian="insert into keahlian (kd,keahlian) values('$kd','$keahlianbaru')";


$query_keahlian=mysql_query($ta mbah_keahlian) or die(mysql_error());

}}else{

if($query_keahlian){?> $data_dep="select*from kd_jabatan='$kd'";

jabatan

where

$query_data=mysql_query($data_dep) or die (mysql_error());




Data berhasil di simpan



$data=mysql_fetch_array($query_data);

$data_keahlian="select*from where kd='$kd'";

keahlian

$query_data_keahlian=mysql_query($data_ keahlian) or die (mysql_error());


$jml=mysql_num_rows($query_data_keahli an);

}else{

$tambahdata=mysql_fetch_array($query_am bil_keahlian);

if($jml==0){$jml_data=0;}else{

$keahlianlama=$tambahdata['keahlian'];

$data2=mysql_fetch_array($query_data_kea hlian);

$databaru=$keahlianlama.",".$keah lianbaru;

$arraydata=explode(",",$data2['keahlian']);

$tambah_data="update keahlian set keahlian='$databaru' where kd='$kd'";

$jml_data=count($arraydata);}

$query_tambah_data=mysql_query ($tambah_data) or die (mysql_error());

$aksi=$_GET['aksi'];

if($query_tambah_data){?>

//hapus $hapus=$_GET['hapus'];

A-7

if($hapus=='ya'){ $dataarray=$_GET['dataarray'];

$query_updatedata=mysql_query($updateda ta) or die (mysql_error());

$keahlianbaru="";

if($query_updatedata){?>

if($jml_data==1){ $hapus_kode="delete from keahlian where kd='$kd'";




Data berhasil di hapus



$query_hapus=mysql_query($hapus_kode); if($query_hapus){?>

Data berhasil di hapus



if($aksi=='hapus'){$dataarray=$_GET['dataa rray'];echo"Anda yakin akan menghapus keahlian $dataarray dari Departemen ".$data['nama_departemen']."???

";?> &hapus=ya&dataarray=">»» Ya& nbsp;««  ">»» Tidak&nbs p;««

if($arraydata[$x]!=$dataarray){

if($keahlianbaru!=""){$keahlianbaru=$keahl ianbaru.",";}

if($aksi=='tambah'){?>

$keahlianbaru="$keahlianbaru$arraydata[$x ]";

Tambah Data Keahlian Pada Departemen

} }



$updatedata="update keahlian set keahlian='$keahlianbaru' where kd='$kd'";

A-8

Nama Departemen	:
Nilai Minimum	:

Hapus





for($i=0;$i<$jml_data;$i++){ ?>

Macam Keahlian
Jenis Keahlian	:
	&aksi=hapus&dataarray=">

&aksi=tambah">»»&nb sp;Tambah ««




?> }}}

Detail jumlah keahlian

}

}}else{



//DIVISI

echo

if($bag=='divisi'){

Nama Departemen	:
Jumlah Keahlian	:

$kd_departemen=$_GET['kd_depar

temen'];

A-9

$kd=$_GET['kd'];

$ambil_divisi="select nama_divisi from divisi where kd='$kd'";

$ambil_departemen="select*from jabatan where kd_jabatan='$kd'";

$query_ambil=mysql_query($ambil _divisi);

$query_departemen=mysql_query( $ambil_departemen);

$data=mysql_fetch_array($query_a mbil);

$data_departemen=mysql_fetch_arr ay($query_departemen);

//hapus kebutuhan tenaga kerja $hapus_kebutuhan="delete from kebutuhan where nama_divisi='".$data['nama_divisi']."'";

echo"

Divisi Departemen ".$data_departemen['nama_departemen']."
";

$query_kebutuhan=mysql_query($ hapus_kebutuhan);

$aksi=$_GET['aksi']; if($aksi=='tambah'){?>

$hapus_divisi="delete from divisi where kd='$kd'";



$query_divisi=mysql_query($hapus _divisi);



class="notif" style="background:url(images/deleteback.pn g) no-repeat;">






Data berhasil di hapus

">

Nama type="text" ?> divisi