SOURCE CODE PERANCANGAN SISTEM PENGAJUAN CUTI BERBASIS WEB PADA PT SUMMIT OTO FINANCE

$quePegawai1_exe = mysql_query($quePegawai1);


$quePegawai1_rows = mysql_fetch_array($quePegawai1_exe);

//CEK DIVISI USER $queCekDivisiUser = "select *from divisi_ms where kdDivisi in(select kdDivisi from divisi_jabatan where kdDivisiJabatan in(select idhakakses from user_hak_akses where user_id='$kdUser'))"; $queCekDivisiUser_exe = mysql_query($queCekDivisiUser); $queCekDivisiUser_array = mysql_fetch_array($queCekDivisiUser_exe) ; $kdDivisiUser = $queCekDivisiUser_array['kdDivisi']; //CEK PENANDATANGAN DIVISI USER $quePenandatanganDivisiUser = "select *from user where confirmCuti='YA' and user_id in(select user_id from user_hak_akses where idhakakses in(select kdDivisiJabatan from divisi_jabatan where kdDivisi='$kdDivisiUser'))"; $quePenandatanganDivisiUser_exe = mysql_query($quePenandatanganDivisiUser );

kdDivisi='2fae3af091b358426e15064175a8 96df'))"; $quePenandatanganDivisiUser1_exe = mysql_query($quePenandatanganDivisiUser 1); $quePenandatanganDivisiUser1_array = mysql_fetch_array($quePenandatanganDivis iUser1_exe); //CEK JABATAN PENANDATANGAN DIVISI HR $queCekJabatanPenandatanganUser1 = "select *from divisi_jabatan where kdDivisiJabatan in(select idhakakses from user_hak_akses where user_id='$quePenandatanganDivisiUser1_ar ray[user_id]')"; $queCekJabatanPenandatanganUser1_exe = mysql_query($queCekJabatanPenandatanga nUser1); $queCekJabatanPenandatanganUser1_array = mysql_fetch_array($queCekJabatanPenandat anganUser1_exe); //CEK NAMA DIVISI HR

$quePenandatanganDivisiUser_array = mysql_fetch_array($quePenandatanganDivis iUser_exe); //CEK JABATAN PENANDATANGAN DIVISI USER $queCekJabatanPenandatanganUser = "select *from divisi_jabatan where kdDivisiJabatan in(select idhakakses from user_hak_akses where user_id='$quePenandatanganDivisiUser_arr ay[user_id]')"; $queCekJabatanPenandatanganUser_exe = mysql_query($queCekJabatanPenandatanga nUser); $queCekJabatanPenandatanganUser_array = mysql_fetch_array($queCekJabatanPenandat anganUser_exe); //CEK PENANDATANGAN DIVISI HR $quePenandatanganDivisiUser1 = "select *from user where confirmCuti='YA' and user_id in(select user_id from user_hak_akses where idhakakses in(select kdDivisiJabatan from divisi_jabatan where

$queCekDivisiUser1 = "select *from divisi_ms where kdDivisi in(select kdDivisi from divisi_jabatan where kdDivisiJabatan in(select idhakakses from user_hak_akses where user_id='$quePenandatanganDivisiUser1_ar ray[user_id]'))"; $queCekDivisiUser1_exe = mysql_query($queCekDivisiUser1); $queCekDivisiUser1_array = mysql_fetch_array($queCekDivisiUser1_ex e); ?>

:

<span style="margin-left:10px; fontsize:25px; font-weight:900;">

if($kdDivisiUser!="2fae3af091b358426e150 64175a896df") { ?> ID Cuti Menyetujui : NIP : Nama Pegawai : " width="200px">
Dari	:
	Sampai	:	< /td>
Jenis Cuti	:
Alasan	:
Pegawai Pengganti	Menyetujui

$password = md5($_POST['password']); //jalankan query $q = "SELECT *FROM user WHERE username='$username' AND password='$password'";

contentloader.php $result = mysql_query($q);

$count = mysql_num_rows($result); if($count==1) {

gridloader.php

$kdUser = $data['user_id'];

//menampilkan grid

$queJabatan = "select *from user_hak_akses where user_id='$kdUser'";

isset($_REQUEST['route'])?include 'grid/'.$_REQUEST['route'].".php":""; ?>

$queJabatan_exe = mysql_query($queJabatan);


$queJabatan_rows = mysql_num_rows($queJabatan_exe); koneksi.php if($queJabatan_rows>0)

login.php
{ $queJabatan_array = mysql_fetch_array($queJabatan_exe); $idhakakses = $queJabatan_array['idhakakses']; $queNamaHakAkses = "select *from divisi_jabatan dj, divisi_ms dm where dm.kdDivisi=dj.kdDivisi and dj.kdDivisiJabatan='$idhakakses'"; $queNamaHakAkses_exe = mysql_query($queNamaHakAkses); $queNamaHakAkses_array = mysql_fetch_array($queNamaHakAkses_ex e); $_SESSION['kdDivisiJabatan'] = $idhakakses; $_SESSION['kdKdivisi'] = $queNamaHakAkses_array['kdDivisi']; $_SESSION['namaDivisiJabatan'] = $queNamaHakAkses_array['namaDivisiJaba tan'];

$_SESSION['kdUser'] = $kdUser;