PENGEMBANGAN SISTEM INFORMASI PENGGAJIAN (STUDI KASUS: SMK AL-FIRDAUS JAKARTA)

1 PENGEMBANGAN SISTEM INFORMASI PENGGAJIAN (STUDI KASUS: SMK AL-FIRDAUS JAKARTA) Oleh: SIGIT PRASETIYO PROGRAM STUDI SISTEM INFORMASI FAKULTAS SAINS D...
Author:  Verawati Kusumo

65 downloads 1460 Views 5MB Size

Recommend Documents



inc_header_popup.php <?php echo TITLE; ?> <script type="text/javascript" src="jquery/jquery-1.4.2.min.js"> <script type="text/javascript" src="jquery/jquery.ui.all.js">

<meta http-equiv="Content-Type" content="text/html; charset=iso8859-1"/> <meta http-equiv="Pragma" content="no-cache"/> <meta http-equiv="Cache-Control" content="no-store"/> <meta http-equiv="Expires" content="0"/>
config.inc.php
define('TITLE','Penggajian Apps | Sigit Prasetiyo ver 1.0'); define('THEMES_NAME', 'default'); define('PAGE_DISPLAY', '10'); define('MAILADDRESS_FROM', '[email protected]');

# # Derivative CONSTANTS. # doesn't necessary need to change if using standard deployment. # define ("HOME_DIR", dirname(__FILE__) . '/../');

define ("PUBLIC_DIR", define ("ADMIN_DIR", define ("CONFIG_DIR", define ("INCLUDES_DIR", define ("COMPONENTS_DIR", define ("LANGUAGES_DIR", define ("LIBRARIES_DIR", define ("THEMES_DIR", THEMES_NAME . '/'); define ("WEBINF_DIR", define ("PHOTO_DIR",

HOME_DIR . 'public/'); HOME_DIR . 'pages/'); HOME_DIR . 'config/'); HOME_DIR . 'includes/'); HOME_DIR . 'components/'); HOME_DIR . 'language/'); HOME_DIR . 'libs/'); HOME_DIR . 'themes/' . HOME_DIR . 'WEB-INF/'); HOME_DIR . 'images/photos/');

if (!defined("PUBLIC_URL")) define ("PUBLIC_URL", HOME_URL . "public/"); if (!defined("ADMIN_URL")) define ("ADMIN_URL", HOME_URL . "pages/"); if (!defined("CONFIG_URL")) define ("CONFIG_URL", HOME_URL . "config/"); if (!defined("LIBRARIES_URL")) define ("LIBRARIES_URL",HOME_URL . "libs/"); if (!defined("THEMES_URL")) define ("THEMES_URL", HOME_URL . "themes/" . THEMES_NAME . "/"); if (!defined("CSS_URL")) define ("CSS_URL", THEMES_URL . "css/"); if (!defined("IMAGES_URL")) define ("IMAGES_URL", THEMES_URL . "images/"); if (!defined("SCRIPT_URL")) define ("SCRIPT_URL", THEMES_URL . "js/"); if (!defined("PHOTO_URL")) define ("PHOTO_URL", HOME_URL . "images/photos/");

define ("LOG4PHP_DIR", LIBRARIES_DIR . "Log4Php"); define ("LOG4PHP_CONF", WEBINF_DIR. "log4php.properties"); // /log4php.xml //require_once (LOG4PHP_DIR . '/LoggerManager.php');

$GLOBALS['MAX_SIZE'] = 5242880; //5MB $GLOBALS['FILE_MIMES'] = array('image/jpeg','image/jpg','image/gif','image/png'); $GLOBALS['FILE_EXTS'] = array('.jpg', '.png', '.gif', '.jpeg'); $GLOBALS['DELETABLE'] = true;

define('DB_SERVER' define('DB_PORT' define('DB_USERNAME' define('DB_PASSWORD' define('DB_DATABASE'

, 'localhost'); , '3306'); , 'root'); , 'root'); , 'db_penggajian');

/* * User Level Declaration */ define('LEVEL_PUBLIC' , ''); define('LEVEL_PIKET' , 'PIKET'); define('LEVEL_BENDAHARA' , 'BENDAHARA'); define('LEVEL_KEPALATATAUSAHA' , 'KEPALATATAUSAHA'); define('LEVEL_KETUAYAYASAN' , 'KETUAYAYASAN'); /* * Table Desclaration */ define('TBL_ABSENSI' , 'tbl_absensi'); define('TBL_HONOR' , 'tbl_honor'); define('TBL_JABATAN' , 'tbl_jabatan'); define('TBL_JURUSAN' , 'tbl_jurusan'); define('TBL_PEGAWAI' , 'tbl_pegawai'); define('TBL_PIKET' , 'tbl_piket'); define('TBL_TAHUNPELAJARAN' , 'tbl_tahunpelajaran'); define('TBL_USER' , 'tbl_user'); define('TBL_WAKTUMENGAJAR' , 'tbl_waktumengajar'); ?>

} function show_header_popup() { include_once (THEMES_DIR . "inc_header_popup.php"); } function show_header_public() { include_once (THEMES_DIR . "inc_header_public.php"); } function show_footer() { include_once (THEMES_DIR . "inc_footer.php"); } function show_footer_popup() { include_once (THEMES_DIR . "inc_footer_popup.php"); } function show_conf( $conf_name ) { echo site_conf_get( $conf_name ); } function site_conf_get( $conf_name ) { return $GLOBALS[$conf_name]; } function show_component( $com_type = '') { require_once COMPONENTS_DIR . $com_type . ".php"; }

public static function hasParameter($parameterName) { return self::hasGetParameter($parameterName) || self::hasPostParameter($parameterName); } public static function hasGetParameter($parameterName) { return isset($_GET[$parameterName]) && strlen($_GET[$parameterName]) > 0; } public static function hasPostParameter($parameterName) { return isset($_POST[$parameterName]) && strlen($_POST[$parameterName]) > 0; } public static function toIndonesianDate( $t ) { $d = date("d ", $t) . Config::getIndonesianMonth(date("n", $t)) . date(" Y", $t); return $d; } public static function toIndonesianFullDate( $t ) { $d = Config::getIndonesianDay(date("N", $t)) . ', ' . date("d ", $t) . // Config::getIndonesianMonth(date("n", $t)) . date(" Y H:i", $t) . ' WIB'; Config::getIndonesianMonth(date("n", $t)) . date(" Y", $t); return $d; } public static function toIndonesianTime( $t ) { $d = date("H:i", $t) . ''; return $d; }

config.class.php
public static function toEnglishDate( $t ) { $d = date("d ", $t) . Config::getEnglishMonth(date("n", $t)) . date(" Y", $t); return $d; }

public static function toEnglishFullDate( $t ) { $d = Config::getEnglishDay(date("N", $t)) . ', ' . date("d ", $t) . Config::getEnglishMonth(date("n", $t)) . date(" Y H:i", $t) . ' WIB'; return $d; } public static function toEnglishTime( $t ) { $d = date("H:i", $t) . ''; return $d; } public static function getIndonesianMonth($month) { switch( $month ) { case 1: return "Januari"; case 2: return "Februari"; case 3: return "Maret"; case 4: return "April"; case 5: return "Mei"; case 6: return "Juni"; case 7: return "Juli"; case 8: return "Agustus"; case 9: return "September"; case 10: return "Oktober"; case 11: return "November"; case 12: return "Desember"; } } public static function getEnglishMonth($month) { switch( $month ) { case 1: return "January"; case 2: return "February"; case 3: return "March"; case 4: return "April"; case 5: return "May"; case 6: return "June"; case 7: return "July"; case 8: return "August"; case 9: return "September"; case 10: return "October"; case 11: return "November"; case 12: return "December"; } } public static function getIndonesianDay($day) { switch( $day ) { case 1: return "Senin"; case 2: return "Selasa"; case 3: return "Rabu"; case 4: return "Kamis"; case 5: return "Jumat"; case 6: return "Sabtu"; case 7: return "Minggu"; } } public static function getEnglishDay($day) { switch( $day ) { case 1: return "Monday"; case 2: return "Tuesday"; case 3: return "Wednesday"; case 4: return "Thursday"; case 5: return "Friday"; case 6: return "Saturday"; case 7: return "Sunday"; } } /** * @desc Get server current date as valid SQL date format. * @return server current date in SQL format */ function getCurrentDate()

{ return date("Y-m-d") . 'T' . date("H:i:s"); } /** * @desc getListMonth * @return array */ function getListMonth() { $month_array = array( "1" => "Januari", "2" => "Februari", "3" => "Maret", "4" => "April", "5" => "Mei", "6" => "Juni", "7" => "Juli", "8" => "Agustus", "9" => "September", "10" => "Oktober", "11" => "November", "12" => "Desember"); return $month_array; } /** * @desc getListMonthTA * @return array */ function getListMonthTA() { $month_array = array( "7" => "Juli", "8" => "Agustus", "9" => "September", "10" => "Oktober", "11" => "November", "12" => "Desember", "1" => "Januari", "2" => "Februari", "3" => "Maret", "4" => "April", "5" => "Mei", "6" => "Juni"); return $month_array; } /** * @desc Get User Religion * @return array */ function getReligion() { $religion_array = array( "0" => " ", "1" => "Islam", "2" => "Kristen katolik", "3" => "Kristen Protestan", "4" => "Hindu", "5" => "Buddha", "6" => "Lainnya"); return $religion_array; } /** * @desc Get User Sex * @return array */ function getSex() { $sex_array = array( "" => " ", "1" => "Laki-laki", "2" => "Perempuan"); return $sex_array; } /** * @desc getHariKerja * @return array */ function getHariKerja() { $hariKerja_array = array( "0" => "SENIN",

"1" => "SELASA", "2" => "RABU", "3" => "KAMIS", "4" => "JUMAT", "5" => "SABTU"); return $hariKerja_array; } /** * @desc getLanguage * @return array */ function getLanguage() { $language_array = array( "id" => "Bahasa Indonesia", "en" => "Bahasa Inggris"); return $language_array; } /** * @desc getLevel * @return array */ function getLevel() { $level_array = array( "1" => "PIMPINAN", "2" => "ADMINISTRATOR"); return $level_array; }

} function selfURL(){ if(!isset($_SERVER['REQUEST_URI'])){ $serverrequri = $_SERVER['PHP_SELF']; } else { $serverrequri = $_SERVER['REQUEST_URI']; } $s = empty($_SERVER["HTTPS"]) ? '' : ($_SERVER["HTTPS"] == "on") ? "s" : ""; $protocol = $this>strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/").$s; $port = ($_SERVER["SERVER_PORT"] == "80") ? "" : (":".$_SERVER["SERVER_PORT"]); return $protocol."://".$_SERVER['SERVER_NAME'].$port.$serverrequri; } function strleft($s1, $s2) { return substr($s1, 0, strpos($s1, $s2)); } } ?> MySql.php
/** * @desc getKelas * @return array */ function getKelas() { $kelas_array = array( "0" => "-Pilih Kelas-", "1" => "X", "2" => "XI", "3" => "XII"); return $kelas_array; } /* Simple function to get current page URL using comman PHP variables Function inputs: $base if set to true will add the basename to the URL $www if set to true will add www. to host if not found $query if set to true will add the query string to the URL $echo if set to true will echo the URL instead of just returning it */ function get_url($base = true, $www = false, $query = true, $echo = false){ $URL = ''; //open return variable $URL .= (($_SERVER['HTTPS'] != '') ? "https://" : "http://"); //get protocol $URL .= (($www == true && !preg_match("/^www\./", $_SERVER['HTTP_HOST'])) ? 'www.'.$_SERVER['HTTP_HOST'] : $_SERVER['HTTP_HOST']); //get host $path = (($_SERVER['REQUEST_URI'] != '') ? $_SERVER['REQUEST_URI'] : $_SERVER['PHP_SELF']); //tell the function what path variable to use $URL .= ((pathinfo($path, PATHINFO_DIRNAME) != '/') ? pathinfo($path, PATHINFO_DIRNAME).'/' : pathinfo($path, PATHINFO_DIRNAME)); //set up directory $URL .= (($base == true) ? pathinfo($path, PATHINFO_BASENAME) : ""); //add basename $URL = preg_replace("/\?".preg_quote($_SERVER['QUERY_STRING'])."/", "", $URL); //remove query string if found in url $URL .= (($query == true && $_SERVER['QUERY_STRING'] != '') ? "?".$_SERVER['QUERY_STRING'] : ""); //add query string if($echo == true) { echo $URL; } else { return $URL; }

if (eregi("Mysql.php",$_SERVER['PHP_SELF'])) { Header("Location: ../index.php"); } if(!defined("SQL_LAYER")) { define("SQL_LAYER","mysql"); class sql_db_mysql { var $db_connect_id; var $query_result; var $row = array(); var $rowset = array(); var $num_queries = 0; // // Constructor // function sql_db_mysql($sqlserver, $sqluser, $sqlpassword, $database, $persistency = false) { $this->persistency = $persistency; $this->user = $sqluser; $this->password = $sqlpassword; $this->server = $sqlserver; $this->dbname = $database; if($this->persistency) { $this->db_connect_id = @mysql_pconnect($this->server, $this->user, $this->password); } else { $this->db_connect_id = @mysql_connect($this->server, $this->user, $this->password); } if($this->db_connect_id) { if($database != "") { $this->dbname = $database; $dbselect = mysql_select_db($this->dbname); if(!$dbselect) { mysql_close($this>db_connect_id);

$this-

{

>db_connect_id = $dbselect;

return false; } } return $this->db_connect_id;

} else { return false; } } // // Other base methods // function sql_close() { if($this->db_connect_id) { if($this->query_result) { @mysql_free_result($this>query_result); } $result = @mysql_close($this>db_connect_id); return $result; } else { return false; } } // // Base query method // function sql_query($query = "", $transaction = FALSE) { // Remove any pre-existing queries unset($this->query_result); if($query != "") { $this->query_result = @mysql_query($query,$this->db_connect_id); if (!$this->query_result) { //echo $query; //die($query." Query failed"); echo "
SQL Error Report : ".mysql_errno() . ": " . mysql_error() . "\n"; } //echo $query; //echo "
SQL Error Report : ".mysql_errno() . ": " . mysql_error() . "\n"; } if($this->query_result) { unset($this->row[$this->query_result]); unset($this->rowset[$this>query_result]); return $this->query_result; } else { return ( $transaction == END_TRANSACTION ) ? true : false; } } function sql_fetchrow($query_id = 0) { if(!$query_id) { $query_id = $this->query_result; } if($query_id) { $this->row[$query_id] = @mysql_fetch_array($query_id); return $this->row[$query_id]; } else

} } function sql_createArray() { $result = array(); while(($row = $this->sql_fetchrow()) != false) { array_push($result,$row); } return $result; } function query($query) { $this->sql_query($query); //echo $query; $array = $this->sql_createArray(); //print "<pre>"; //print_r($array); //exit; return $array; } // // Other query methods // function sql_numrows($query_id = 0) { if(!$query_id) { $query_id = $this->query_result; } if($query_id) { $result = @mysql_num_rows($query_id); return $result; } else { return false; } } function sql_affectedrows() { if($this->db_connect_id) { $result = @mysql_affected_rows($this>db_connect_id); return $result; } else { return false; } } function sql_numfields($query_id = 0) { if(!$query_id) { $query_id = $this->query_result; } if($query_id) { $result = @mysql_num_fields($query_id); return $result; } else { return false; } } function sql_fieldname($offset, $query_id = 0) { if(!$query_id) { $query_id = $this->query_result; } if($query_id) { $result = @mysql_field_name($query_id, $offset);

return $result; } else {

$result = $this->row[$query_id][$field]; } }

return false;

} return $result;

} } function sql_fieldtype($offset, $query_id = 0) { if(!$query_id) { $query_id = $this->query_result; } if($query_id) { $result = @mysql_field_type($query_id,

} else { return false; } } function sql_rowseek($rownum, $query_id = 0){ if(!$query_id) { $query_id = $this->query_result; } if($query_id) { $result = @mysql_data_seek($query_id,

$offset); return $result; } else {

$rownum); return false;

return $result;

}

} else {

} function sql_fetchrowset($query_id = 0) { if(!$query_id) { $query_id = $this->query_result; } if($query_id) { unset($this->rowset[$query_id]); unset($this->row[$query_id]); while($this->rowset[$query_id] = @mysql_fetch_array($query_id)) { $result[] = $this>rowset[$query_id]; } return $result; } else { return false; } } function sql_fetchfield($field, $rownum = -1, $query_id = 0) { if(!$query_id) { $query_id = $this->query_result; } if($query_id) { if($rownum > -1) { $result = @mysql_result($query_id, $rownum, $field); } else { if(empty($this>row[$query_id]) && empty($this->rowset[$query_id])) { if($this>sql_fetchrow()) { $result = $this->row[$query_id][$field]; } } else { if($this>rowset[$query_id]) { $result = $this->rowset[$query_id][$field]; } else if($this>row[$query_id]) {

return false; } } function sql_nextid(){ if($this->db_connect_id) { $result = @mysql_insert_id($this>db_connect_id); return $result; } else { return false; } } function sql_freeresult($query_id = 0){ if(!$query_id) { $query_id = $this->query_result; } if ( $query_id ) { unset($this->row[$query_id]); unset($this->rowset[$query_id]); @mysql_free_result($query_id); return true; } else { return false; } } function sql_error($query_id = 0) { $result["message"] = @mysql_error($this>db_connect_id); $result["code"] = @mysql_errno($this>db_connect_id); return $result; } } // class sql_db } // if ... define ?> tlAbsensi.class.php db = $db_object;

$this->piket = new tlPiket($db_object); } /** * @desc getAllAbsensiDataList in TBL_ABSENSI * @var * @param $count, $page, $_GET * @return Array **/ function getAllAbsensiDataList($count = 0, $page = 0, $_GET) { if ($this->db) { $namaPegawai = $_GET['namaPegawai']; $namaMataPelajaran = $_GET['namaMataPelajaran']; $tanggalAbsensi = $_GET['tanggalAbsensi']; $result = 0; $query = "SELECT * FROM " . TBL_ABSENSI . " a LEFT JOIN (" . TBL_TAHUNPELAJARAN . " b, " . TBL_PEGAWAI . " c, " . TBL_MATAPELAJARAN . " d, " . TBL_JURUSAN . " e, " . TBL_PIKET . " f) ON(a.IDTahunPelajaran=b.IDTahunPelajaran AND a.IDPegawai=c.IDPegawai AND a.IDMataPelajaran=d.IDMataPelajaran AND a.IDJurusan=e.IDJurusan AND a.IDPiket=f.IDPiket) WHERE 1=1 AND e.IDJurusan='" . $_SESSION['IDJURUSAN'] . "' "; if (!empty($_GET)) { if(!empty($namaPegawai) && $namaPegawai != "") { $query .= " AND c.namaPegawai LIKE '%" . trim($namaPegawai) . "%'"; } if(!empty($namaMataPelajaran) && $namaMataPelajaran != "") { $query .= " AND d.namaMataPelajaran LIKE '%" . trim($namaMataPelajaran) . "%'"; } if(!empty($tanggalAbsensi) && $tanggalAbsensi != "") { $query .= " AND a.tanggalAbsensi = '" . trim($tanggalAbsensi) . "'"; } } $query .= " ORDER BY c.namaPegawai ASC "; if (strlen($page) > 0) { $query .= " LIMIT " . ($page * $count) . ", " . $count; } $result = $this->db->query($query); print "<pre>"; print $query . "
"; print_r($result); exit; return $result;

// // // //

} else { echo "Error line 43 tlAbsensi.class.php"; return; } } /** * @desc Gets a total of Absensi available in database. * * @param active the active flag * @return array or null */ function getAbsensiCount( $_GET ) { if ($this->db) { $namaAbsensi = $_GET['namaAbsensi']; $result = 0; $query = "SELECT COUNT(a.IDAbsensi) AS total FROM " . TBL_ABSENSI . " a WHERE 1=1"; if (!empty($_GET))

{ if(!empty($namaAbsensi) && $namaAbsensi != "") { $query .= " AND a.namaAbsensi LIKE '%" . trim($namaAbsensi) . "%'"; } } $result = $this->db->query($query); return $result[0]; } else { echo "Error line 85 tlAbsensi.class.php"; return; } } /** * @desc getAbsensiById in TBL_ABSENSI at specific IDAbsensi * @param IDAbsensi from $_GET * @var IDAbsensi * @return Array **/ function getAbsensiById( $IDAbsensi ) { if ($this->db) { $query = "SELECT * FROM " . TBL_ABSENSI . " a WHERE a.IDAbsensi='" . $IDAbsensi . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit; return $result; } else { echo "Error line 115 tlAbsensi.class.php"; return; } } /** * @desc countAbsensiByIDPegawai in TBL_ABSENSI at specific IDPegawai * @param IDPegawai * @var IDPegawai * @return Array **/ function countAbsensiByIDPegawai( $d, $m, $y, $IDPegawai ) { if ($this->db) { $query = "SELECT COUNT(a.IDAbsensi) as jumlahJam FROM " . TBL_ABSENSI . " a WHERE 1=1 AND a.IDPegawai='" . $IDPegawai . "' "; if(!empty($d) && $d != "") { $query .= " AND DAY(a.tanggalAbsensi)='" . $d . "'"; } if(!empty($m) && $m != "") { $query .= " AND MONTH(a.tanggalAbsensi)='" . $m . "'"; } if(!empty($y) && $y != "") { $query .= " AND YEAR(a.tanggalAbsensi)='" . $y . "'"; } $result = $this->db->query($query); // print "<pre>"; // print $query; // print_r($result); // exit; return $result; } else { echo "Error line 115 tlAbsensi.class.php"; return; } } /** * @desc Save an instance of $_POST to database. * @param $_POST

*/ function save( $_POST ) { if ($this->db) { // print "<pre>"; // print_r($_POST); // exit; $this->piket->save($_POST); $pegawaiPiket = $this->piket>getPiketByParameter($_POST['IDJurusan'],$_POST['IDTahunPelajaran'] ,$_POST['tanggalPiket']);

for($ii=0; $iiremove($_POST['IDJurusan'], $_POST['IDTahunPelajaran'], $_POST['tanggalAbsensi'], $_POST['IDPegawai'][$ii]); for($jj=0; $jj<8; $jj++) { if($_POST['sesi'][$ii][$jj] == "") { continue; } if ( $this->isExist($_POST['IDJurusan'], $_POST['IDTahunPelajaran'], $_POST['tanggalAbsensi'], $_POST['IDPegawai'][$ii], $_POST['sesi'][$ii][$jj]) ) { continue; } else { $query = "INSERT INTO " . TBL_ABSENSI . " "; $query .= "(IDAbsensi, IDJurusan, IDTahunPelajaran, tanggalAbsensi, IDPegawai, sesi, kelas, IDPiket, tanggalInput, terakhirUpdate, terakhirUpdateOleh) "; $query .= "VALUES ("; $query .= "'', "; $query .= "'" . $this->escape( $_POST['IDJurusan'] ) . "', "; $query .= "'" . $this->escape( $_POST['IDTahunPelajaran'] ) . "', "; $query .= "'" . $this->escape( $_POST['tanggalAbsensi'] ) . "', "; $query .= "'" . $this->escape( $_POST['IDPegawai'][$ii] ) . "', "; $query .= "'" . $this->escape( $_POST['sesi'][$ii][$jj] ) . "', "; $query .= "'', "; $query .= "'" . $pegawaiPiket[0]['IDPegawaiPiket'] . "', "; $query .= "NOW(), "; $query .= "NOW(), "; $query .= "'" . $this->escape( $_POST['terakhirUpdateOleh'] ) . "' "; $query .= "); "; print "<pre>"; print $query."
"; $result = $this->db->query($query); } } } } // exit; return $result; } /** * @desc Check whether a Absensi with specific parameter exist in database * * @param $tanggalAbsensi, $IDPegawai, $sesi * @return */ function getKelas( $IDJurusan, $IDTahunPelajaran, $tanggalAbsensi, $IDPegawai, $sesi ) { $result = 0; $query = "SELECT a.kelas FROM " . TBL_ABSENSI . " a WHERE 1=1"; if(!empty($IDJurusan) && $IDJurusan != "") { $query .= " AND a.IDJurusan = '" . trim($IDJurusan) . "'"; } if(!empty($IDTahunPelajaran) && $IDTahunPelajaran != "") { $query .= " AND a.IDTahunPelajaran = '" . trim($IDTahunPelajaran) . "'";

} if(!empty($tanggalAbsensi) && $tanggalAbsensi != "") { $query .= " AND a.tanggalAbsensi = '" . trim($tanggalAbsensi) . "'"; } if(!empty($IDPegawai) && $IDPegawai != "") { $query .= " AND a.IDPegawai = '" . trim($IDPegawai) . "'"; } if(!empty($sesi) && $sesi != "") { $query .= " AND a.sesi = '" . trim($sesi) . "'"; } if ($this->db) { $result = $this->db->query($query); return $result; } else { echo "Error line 223 tlAbsensi.class.php"; return false; } } /** * @desc Check whether a Absensi with specific parameter exist in database * * @param $tanggalAbsensi, $IDPegawai, $sesi * @return true if exist false otherwise */ function isExist( $IDJurusan, $IDTahunPelajaran, $tanggalAbsensi, $IDPegawai, $sesi ) { $result = 0; $query = "SELECT COUNT(a.IDAbsensi) AS total FROM " . TBL_ABSENSI . " a WHERE 1=1"; if(!empty($IDJurusan) && $IDJurusan != "") { $query .= " AND a.IDJurusan = '" . trim($IDJurusan) . "'"; } if(!empty($IDTahunPelajaran) && $IDTahunPelajaran != "") { $query .= " AND a.IDTahunPelajaran = '" . trim($IDTahunPelajaran) . "'"; } if(!empty($tanggalAbsensi) && $tanggalAbsensi != "") { $query .= " AND a.tanggalAbsensi = '" . trim($tanggalAbsensi) . "'"; } if(!empty($IDPegawai) && $IDPegawai != "") { $query .= " AND a.IDPegawai = '" . trim($IDPegawai) . "'"; } if(!empty($sesi) && $sesi != "") { $query .= " AND a.sesi = '" . trim($sesi) . "'"; } if ($this->db) { $result = $this->db->query($query); } if ($result) { $count = 0; if (is_array($result)) { $count = $result[0][0]; } return $count > 0; } return false; } /** * Remove Absensi from database. * * @param * @return the number of object removed from database */

function remove( $IDJurusan, $IDTahunPelajaran, $tanggalAbsensi, $IDPegawai ) { $result = 0; if ((strlen($IDPegawai) > 0) && $this->db) { $query = "DELETE FROM " . TBL_ABSENSI . " WHERE IDJurusan='" . $IDJurusan . "' AND IDTahunPelajaran='" . $IDTahunPelajaran . "' AND tanggalAbsensi='" . $tanggalAbsensi . "' AND IDPegawai='" . $IDPegawai . "'"; // print "<pre>"; // print $query."
"; // exit; $result = $this->db->query($query); } return $result; } /** * Escape a form data before adding to database. * * @param value the String to be escaped * @return safe string */ function escape( $value ) { if (get_magic_quotes_gpc()) { return $value; } else { return addslashes($value); } } } ?> tlHonor.class.php db = $db_object; } /** * @desc getAllHonor in TBL_HONOR * @var * @param * @return Array **/ function getAllHonor() { if ($this->db) { $query = "SELECT * FROM " . TBL_HONOR . " a WHERE 1=1"; $result = $this->db->query($query); // print "<pre>"; // print $query . "
"; // print_r($result); // exit; return $result; } else { echo "Error line 40 tlHonor.class.php"; return; } } /** * @desc getAllHonorDataList in TBL_HONOR * @var * @param $count, $page, $_GET * @return Array **/ function getAllHonorDataList($count = 0, $page = 0, $_GET)

{ if ($this->db) { $result = 0; $query = "SELECT * FROM " . TBL_HONOR . " a WHERE 1=1 ORDER BY a.IDHonor ASC "; if (strlen($page) > 0) { $query .= " LIMIT " . ($page * $count) . ", " . $count; } $result = $this->db->query($query); print "<pre>"; print $query . "
"; print_r($result); exit; return $result;

// // // //

} else { echo "Error line 66 tlHonor.class.php"; return; } } /** * @desc Gets a total of Honor available in database. * * @param * @return array or null */ function getHonorCount( $_GET ) { if ($this->db) { $result = 0; $query = "SELECT COUNT(a.IDHonor) AS total FROM " . TBL_HONOR . " a WHERE 1=1"; $result = $this->db->query($query); return $result[0]; } else { echo "Error line 97 tlHonor.class.php"; return; } } /** * @desc getHonorById in TBL_HONOR at specific IDHonor * @param IDHonor from $_GET * @var IDHonor * @return Array **/ function getHonorById( $IDHonor ) { if ($this->db) { $query = "SELECT * FROM " . TBL_HONOR . " a WHERE a.IDHonor='" . $IDHonor . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit; return $result; } else { echo "Error line 119 tlHonor.class.php"; return; } } /** * @desc Save an instance of $_POST to database. * @param $_POST */ function save( $_POST ) { if ($this->db) { if ( $this->isExist($_POST['IDHonor']) ) { // print "<pre>";

// //

print_r($_POST); exit; //UPDATE TABLE PERSON DATA $query = "UPDATE " . TBL_HONOR . " SET ";

$query .= "honorPerJam='" . $this->escape( $_POST['honorPerJam'] ) . "', "; $query .= "transportPerJam='" . $this->escape( $_POST['transportPerJam'] ) . "', "; $query .= "piketPerHari='" . $this->escape( $_POST['piketPerHari'] ) . "' "; $query .= "WHERE IDHonor='" . $_POST['IDHonor'] . "'"; } else { // print "<pre>"; // print_r($_POST); // exit; /* * INSERT INTO TBL_HONOR */ $query = "INSERT INTO " . TBL_HONOR . " "; $query .= "(IDHonor, honorPerJam, transportPerJam, piketPerHari) "; $query .= "VALUES ("; $query .= "'', "; $query .= "'" . $this->escape( $_POST['honorPerJam'] ) . "', "; $query .= "'" . $this->escape( $_POST['transportPerJam'] ) . "', "; $query .= "'" . $this->escape( $_POST['piketPerHari'] ) . "' "; $query .= ") "; } } // print "<pre>"; // print $query."
"; // exit; $result = $this->db->query($query); return $result; } /** * @desc Check whether a Honor with specific IDHonor exist in database * * @param IDHonor * @return true if exist false otherwise */ function isExist( $IDHonor = '' ) { if (strlen($IDHonor) <= 0) { return false; } $result = 0; $query = "SELECT COUNT(a.IDHonor) AS total FROM " . TBL_HONOR . " a WHERE a.IDHonor='" . $IDHonor . "'"; if ($this->db) { $result = $this->db->query($query); } if ($result) { $count = 0; if (is_array($result)) { $count = $result[0][0]; } return $count > 0; } return false; } /** * Remove a single Honor from database. * * @param IDHonor to remove * @return the number of object removed from database */ function remove($IDHonor = "") { $result = 0; if ((strlen($IDHonor) > 0) && $this->db)

{ $query = "DELETE FROM " . TBL_HONOR . " WHERE IDHonor = '" . $IDHonor . "'"; $result = $this->db->query($query); } return $result; } /** * Escape a form data before adding to database. * * @param value the String to be escaped * @return safe string */ function escape( $value ) { if (get_magic_quotes_gpc()) { return $value; } else { return addslashes($value); } } } ?> tlJabatan.class.php db = $db_object; } /** * @desc getAllJabatan in TBL_JABATAN * @var * @param * @return Array **/ function getAllJabatan() { if ($this->db) { $query = "SELECT * FROM " . TBL_JABATAN . " a WHERE 1=1"; $result = $this->db->query($query); // print "<pre>"; // print $query . "
"; // print_r($result); // exit; return $result; } else { echo "Error line 40 tlJabatan.class.php"; return; } } /** * @desc getAllJabatanDataList in TBL_JABATAN * @var * @param $count, $page, $_GET * @return Array **/ function getAllJabatanDataList($count = 0, $page = 0, $_GET) { if ($this->db) { $namaJabatan = $_GET['namaJabatan']; $result = 0; $query = "SELECT * FROM " . TBL_JABATAN . " a WHERE 1=1"; if (!empty($_GET)) {

if(!empty($namaJabatan) && $namaJabatan != "") { $query .= " AND a.namaJabatan LIKE '%" . trim($namaJabatan) . "%'"; } } $query .= " ORDER BY a.IDJabatan ASC "; if (strlen($page) > 0) { $query .= " LIMIT " . ($page * $count) . ", " . $count; } $result = $this->db->query($query); print "<pre>"; print $query . "
"; print_r($result); exit; return $result;

// // // //

} else { echo "Error line 43 tlJabatan.class.php"; return; }

/** * @desc Save an instance of $_POST to database. * @param $_POST */ function save( $_POST ) { if ($this->db) { if ( $this->isExist($_POST['IDJabatan']) ) { // print "<pre>"; // print_r($_POST); // exit; //UPDATE TABLE PERSON DATA $query = "UPDATE " . TBL_JABATAN . " SET "; $query .= "namaJabatan='" . $this->escape( $_POST['namaJabatan'] ) . "', "; $query .= "jumlahTunjangan='" . $this->escape( $_POST['jumlahTunjangan'] ) . "', "; $query .= "keteranganJabatan='" . $this->escape( $_POST['keteranganJabatan'] ) . "' ";

} /** * @desc Gets a total of Jabatan available in database. * * @param * @return array or null */ function getJabatanCount( $_GET ) { if ($this->db) { $namaJabatan = $_GET['namaJabatan']; $result = 0; $query = "SELECT COUNT(a.IDJabatan) AS total FROM " . TBL_JABATAN . " a WHERE 1=1"; if (!empty($_GET)) { if(!empty($namaJabatan) && $namaJabatan != "") { $query .= " AND a.namaJabatan LIKE '%" . trim($namaJabatan) . "%'"; } } $result = $this->db->query($query); return $result[0]; } else { echo "Error line 85 tlJabatan.class.php"; return; } } /** * @desc getJabatanById in TBL_JABATAN at specific IDJabatan * @param IDJabatan from $_GET * @var IDJabatan * @return Array **/ function getJabatanById( $IDJabatan ) { if ($this->db) { $query = "SELECT * FROM " . TBL_JABATAN . " a WHERE a.IDJabatan='" . $IDJabatan . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit; return $result; } else { echo "Error line 115 tlJabatan.class.php"; return; } }

$query .= "WHERE IDJabatan='" . $_POST['IDJabatan'] . "'"; } else { // print "<pre>"; // print_r($_POST); // exit; /* * INSERT INTO TBL_JABATAN */ $query = "INSERT INTO " . TBL_JABATAN . " "; $query .= "(IDJabatan, namaJabatan, jumlahTunjangan, keteranganJabatan) "; $query .= "VALUES ("; $query .= "'', "; $query .= "'" . $this->escape( $_POST['namaJabatan'] ) . "', "; $query .= "'" . $this->escape( $_POST['jumlahTunjangan'] ) . "', "; $query .= "'" . $this->escape( $_POST['keteranganJabatan'] ) . "' "; $query .= ") "; } } // print "<pre>"; // print $query."
"; // exit; $result = $this->db->query($query); return $result; } /** * @desc Check whether a Jabatan with specific IDJabatan exist in database * * @param IDJabatan * @return true if exist false otherwise */ function isExist( $IDJabatan = '' ) { if (strlen($IDJabatan) <= 0) { return false; } $result = 0; $query = "SELECT COUNT(a.IDJabatan) AS total FROM " . TBL_JABATAN . " a WHERE a.IDJabatan='" . $IDJabatan . "'"; if ($this->db) { $result = $this->db->query($query); } if ($result) { $count = 0; if (is_array($result)) { $count = $result[0][0]; }

return $count > 0; } return false;

* @return Array **/ function getAllJurusanDataList($count = 0, $page = 0, $_GET) { if ($this->db) { $namaJurusan = $_GET['namaJurusan'];

} /** * Remove a single Jabatan from database. * * @param IDJabatan to remove * @return the number of object removed from database */ function remove($IDJabatan = "") { $result = 0; if ((strlen($IDJabatan) > 0) && $this->db) { $query = "DELETE FROM " . TBL_JABATAN . " WHERE IDJabatan = '" . $IDJabatan . "'"; $result = $this->db->query($query); } return $result; } /** * Escape a form data before adding to database. * * @param value the String to be escaped * @return safe string */ function escape( $value ) { if (get_magic_quotes_gpc()) { return $value; } else { return addslashes($value); } } } ?> tlJurusan.class.php db = $db_object; } /** * @desc getAllJurusan * @param * @var * @return Array **/ function getAllJurusan( ) { if ($this->db) { $query = "SELECT * FROM " . TBL_JURUSAN . " a WHERE 1=1 ORDER BY a.namaJurusan"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit; return $result; } else { echo "Error line 40 tlJurusan.class.php"; return; } } /** * @desc getAllJurusanDataList in TBL_JURUSAN * @var * @param $count, $page, $_GET

$result = 0; $query = "SELECT * FROM " . TBL_JURUSAN . " a WHERE 1=1"; if (!empty($_GET)) { if(!empty($namaJurusan) && $namaJurusan != "") { $query .= " AND a.namaJurusan LIKE '%" . trim($namaJurusan) . "%'"; } } $query .= " ORDER BY a.namaJurusan ASC "; if (strlen($page) > 0) { $query .= " LIMIT " . ($page * $count) . ", " . $count; } $result = $this->db->query($query); print "<pre>"; print $query . "
"; print_r($result); exit; return $result;

// // // //

} else { echo "Error line 43 tlJurusan.class.php"; return; } } /** * @desc Gets a total of Jurusan available in database. * * @param active the active flag * @return array or null */ function getJurusanCount( $_GET ) { if ($this->db) { $namaJurusan = $_GET['namaJurusan']; $result = 0; $query = "SELECT COUNT(a.IDJurusan) AS total FROM " . TBL_JURUSAN . " a WHERE 1=1"; if (!empty($_GET)) { if(!empty($namaJurusan) && $namaJurusan != "") { $query .= " AND a.namaJurusan LIKE '%" . trim($namaJurusan) . "%'"; } } $result = $this->db->query($query); return $result[0]; } else { echo "Error line 85 tlJurusan.class.php"; return; } } /** * @desc getJurusanById in TBL_JURUSAN at specific IDJurusan * @param IDJurusan from $_GET * @var IDJurusan * @return Array **/ function getJurusanById( $IDJurusan ) { if ($this->db) {

$query = "SELECT * FROM " . TBL_JURUSAN . " a WHERE a.IDJurusan='" . $IDJurusan . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit; return $result; } else { echo "Error line 115 tlJurusan.class.php"; return; } } /** * @desc Save an instance of $_POST to database. * @param $_POST */ function save( $_POST ) { if ($this->db) { if ( $this->isExist($_POST['IDJurusan']) ) { // print "<pre>"; // print_r($_POST); // exit; //UPDATE TABLE PERSON DATA $query = "UPDATE " . TBL_JURUSAN . " SET ";

$result = $this->db->query($query); } if ($result) { $count = 0; if (is_array($result)) { $count = $result[0][0]; } return $count > 0; } return false; } /** * Remove a single Jurusan from database. * * @param IDJurusan to remove * @return the number of object removed from database */ function remove($IDJurusan = "") { $result = 0; if ((strlen($IDJurusan) > 0) && $this->db) { $query = "DELETE FROM " . TBL_JURUSAN . " WHERE IDJurusan = '" . $IDJurusan . "'"; $result = $this->db->query($query); } return $result; }

$query .= "namaJurusan='" . $this->escape( $_POST['namaJurusan'] ) . "', "; $query .= "keteranganJurusan='" . $this->escape( $_POST['keteranganJurusan'] ) . "' "; $query .= "WHERE IDJurusan='" . $_POST['IDJurusan'] . "'"; } else { print "<pre>"; print_r($_POST); exit; /* * INSERT INTO TBL_JURUSAN */ $query = "INSERT INTO " . TBL_JURUSAN . " "; $query .= "(IDJurusan, namaJurusan, keteranganJurusan) "; $query .= "VALUES ("; $query .= "'', "; $query .= "'" . $this->escape( $_POST['namaJurusan'] ) . "', "; $query .= "'" . $this->escape( $_POST['keteranganJurusan'] ) . "'

// // //

";

/** * Escape a form data before adding to database. * * @param value the String to be escaped * @return safe string */ function escape( $value ) { if (get_magic_quotes_gpc()) { return $value; } else { return addslashes($value); } } } ?> tlPegawai.class.php

$query .= ") "; }


} // // //

print "<pre>"; print $query."
"; exit; $result = $this->db->query($query); return $result; }

/** * @desc Check whether a Jurusan with specific IDJurusan exist in database * * @param IDJurusan * @return true if exist false otherwise */ function isExist( $IDJurusan = '' ) { if (strlen($IDJurusan) <= 0) { return false; } $result = 0; $query = "SELECT COUNT(a.IDJurusan) AS total FROM " . TBL_JURUSAN . " a WHERE a.IDJurusan='" . $IDJurusan . "'"; if ($this->db) {

class tlPegawai { var $db; //var $config; function tlPegawai($db_object) { $this->db = $db_object; $this->config = new Config($db_object); $this->mail = new tlMail($db_object); $this->tahunPelajaran = new tlTahunPelajaran($db_object); } /** * @desc getAllPegawaiDataList in TBL_ADMIN, TBL_ADMIN and TBL_ROLE * @var * @param $count, $page, $_GET, $order, $active * @return Array **/ function getAllPegawaiDataList($count = 0, $page = 0, $_GET, $active = -1) { if ($this->db) { $IDJurusan = $_GET['IDJurusan']; $IDPegawai = $_GET['IDPegawai']; $namaPegawai = $_GET['namaPegawai'];

} $result = $this->db->query($query); return $result[0];

$result = 0; $query = "SELECT * FROM " . TBL_PEGAWAI . " a LEFT JOIN(" . TBL_JABATAN . " b, " . TBL_USER . " c) ON(a.IDJabatan=b.IDJabatan AND a.IDUser=c.IDUser) WHERE 1=1"; if ((0 + $active) > -1) { $query .= " AND a.statusPegawai = " . ( 0 + $active) . ""; } if (!empty($_GET)) { if(!empty($IDJurusan) && $IDJurusan != "") { $query .= " AND a.IDJurusan = '" . trim($IDJurusan) . "'"; } if(!empty($IDPegawai) && $IDPegawai != "") { $query .= " AND a.IDPegawai = '" . trim($IDPegawai) . "'"; } if(!empty($namaPegawai) && $namaPegawai != "") { $query .= " AND a.namaPegawai LIKE '%".trim($namaPegawai)."%'"; } } $query .= " ORDER BY a.namaPegawai ASC "; if (strlen($page) > 0) { $query .= " LIMIT " . ($page * $count) . ", " . $count; } $result = $this->db->query($query); print "<pre>"; print $query . "
"; print_r($result); exit; return $result;

// // // //

} else { echo "Error line 48 tlPegawai.class.php"; return; } } /** * @desc Get a total of Pegawai available in database. * * @param active the active flag * @return array or null */ function getPegawaiCount( $_GET, $active = -1 ) { if ($this->db) { $IDPegawai = $_GET['IDPegawai']; $namaPegawai = $_GET['namaPegawai']; $result = 0; $query = "SELECT COUNT(a.IDPegawai) AS total FROM " . TBL_PEGAWAI . " a LEFT JOIN( " . TBL_JABATAN . " b, " . TBL_USER . " c) ON(a.IDJabatan=b.IDJabatan AND a.IDUser=c.IDUser) WHERE 1=1"; if ((0 + $active) > -1) { $query .= " AND a.statusPegawai='" . ( 0 + $active) . "'"; } if (!empty($_GET)) { if(!empty($IDPegawai) && $IDPegawai != "") { $query .= " AND a.IDPegawai LIKE '%" . trim($IDPegawai) . "%'"; } if(!empty($namaPegawai) && $namaPegawai != "") { $query .= " AND a.namaPegawai LIKE '%".trim($namaPegawai)."%'"; }

} else { echo "Error line 100 tlPegawai.class.php"; return; } } /** * @desc Gets total of Pegawai Active available in database. * * @param * @return array or null */ function getActivePegawaiCount() { return $this->getPegawaiCount( $_GET, 1 ); } /** * @desc Get total of Pegawai Inactive available in database. * * @param * @return array or null */ function getInactivePegawaiCount() { return $this->getPegawaiCount( $_GET, 0 ); } /** * @desc Gets All Pegawai Active available in database. * * @param * @return array or null */ function getActivePegawaiList($count = 0, $page = 0, $_GET) { return $this->getAllPegawaiDataList($count, $page, $_GET, 1); } /** * @desc Get All Pegawai Inactive available in database. * * @param * @return array or null */ function getInactivePegawaiList($count = 0, $page = 0, $_GET) { return $this->getAllPegawaiDataList($count, $page, $_GET, 0); } /** * @desc getPegawaiById in TBL_PEGAWAI at specific IDPegawai * @param IDPegawai from $_GET * @var IDPegawai * @return Array **/ function getPegawaiById( $IDPegawai ) { if ($this->db) { $query = "SELECT * FROM " . TBL_PEGAWAI . " a LEFT JOIN( " . TBL_JABATAN . " b, " . TBL_USER . " c) ON(a.IDJabatan=b.IDJabatan AND a.IDUser=c.IDUser) WHERE a.IDPegawai='" . $IDPegawai . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // print_r($result); // exit; return $result; } else { echo "Error line 1852 tlPegawai.class.php"; return; } } /** * @desc getPegawaiByEmail in TBL_PEGAWAI at specific email * @param email from $_POST

* @var email * @return Array **/ function getPegawaiByEmail( $email ) { if ($this->db) { $query = "SELECT * FROM " . TBL_PEGAWAI . " a LEFT JOIN( " . TBL_JABATAN . " b, " . TBL_USER . " c) ON(a.IDJabatan=b.IDJabatan AND a.IDUser=c.IDUser) WHERE a.email LIKE '" . $email . "'"; $result = $this->db->query($query); return $result; } else { echo "Error line 210 tlPegawai.class.php"; return; } } /** * @desc getPegawaiByLevel in TBL_PEGAWAI at specific level * @param level from $_POST * @var level * @return Array **/ function getPegawaiByLevel( $IDLevel ) { if ($this->db) { $query = "SELECT * FROM " . TBL_PEGAWAI . " a LEFT JOIN( " . TBL_JABATAN . " b, " . TBL_USER . " c) ON(a.IDJabatan=b.IDJabatan AND a.IDUser=c.IDUser) WHERE a.IDUser = '" . $IDLevel . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // print_r($result); // exit; return $result; } else { echo "Error line 234 tlPegawai.class.php"; return; } } /** * @desc getPengurus in TBL_PEGAWAI * @param * @var * @return Array **/ function getPengurus() { if ($this->db) { $query = "SELECT * FROM " . TBL_PEGAWAI . " a LEFT JOIN( " . TBL_JABATAN . " b, " . TBL_USER . " c) ON(a.IDJabatan=b.IDJabatan AND a.IDUser=c.IDUser) WHERE a.IDJabatan<=5"; $result = $this->db->query($query); // print "<pre>"; // print $query; // print_r($result); // exit; return $result; } else { echo "Error line 265 tlPegawai.class.php"; return; } }

// // // //

/** * @desc Pegawai authentication, logged in TBL_PEGAWAI * @var PegawaiName, password from $_POST * @return Session Array **/ function authenticate($username, $password, $IDUser) { print "<pre>"; echo "username: ".$username."
"; echo "Password: ".$password."

"; exit;

$pass = md5($password); $query = "SELECT * FROM " . TBL_PEGAWAI . " a LEFT JOIN( " . TBL_JABATAN . " b, " . TBL_USER . " c) ON(a.IDJabatan=b.IDJabatan AND a.IDUser=c.IDUser) WHERE a.username='" . $username . "' AND a.password='" . $pass . "' AND a.IDUser='" . $IDUser . "' ";

// // // // //

$result = $this->db->query($query); print "<pre>"; print $query . "
"; print count($result) . "
"; print_r($result); exit;

$tahunPelajaran = $this->tahunPelajaran>getTahunPelajaranActive(); if ( ! $result || $result[0]['statusPegawai'] == 0) { return false; } else { if ($result[0]['username']) { session_start(); session_register( 'IDPEGAWAI' ); session_register( 'NAMAPEGAWAI' ); session_register( 'LEVEL' ); session_register( 'JABATAN' ); session_register( 'IDTAHUNPELAJARAN' ); session_register( 'TAHUNPELAJARAN' ); session_register( 'STATUS' ); $_SESSION['IDPEGAWAI'] = $result[0]['IDPegawai']; $_SESSION['NAMAPEGAWAI'] = $result[0]['namaPegawai']; $_SESSION['LEVEL'] = $result[0]['namaUser']; $_SESSION['JABATAN'] = $result[0]['namaJabatan']; $_SESSION['IDTAHUNPELAJARAN'] = $tahunPelajaran[0]['IDTahunPelajaran']; $_SESSION['TAHUNPELAJARAN'] = $tahunPelajaran[0]['namaTahunPelajaran']; $_SESSION['STATUS'] = $result[0]['statusPegawai']; session_write_close(); $lastIP = $_SERVER['REMOTE_ADDR']; $lastLogin = date("Y-m-d H:i:s",time()); $qrUpdate = "UPDATE " . TBL_PEGAWAI . " a SET a.IP='" . $lastIP . "', a.loginTerakhir='" . $lastLogin . "' WHERE a.IDPegawai='" . $_SESSION['IDPEGAWAI'] . "'"; $resultUpdate = $this->db->query($qrUpdate); // // //

print "<pre>"; print_r($_SESSION); exit;

if (! $resultUpdate) { //echo 'Error line 237 tlPegawai.class.php on '.$qrUpdate.'
'; return true; } else { //$this->db = $_SESSION; return true; } } else { return true; } } } /** * @desc Pegawai logout, nothing to update just lastLogout * @param none * @return bool **/ function logout()

{ //check the session if (session_is_registered("IDPEGAWAI")) { //Close MySQL $this->db->sql_close(); //just destroy session_destroy(); return true; } else { //throw error, if no session was registered $msg = "NO SESSION WAS REGISTERD"; session_start(); session_destroy(); $url = $this->config->get_url(); header("location:".ADMIN_URL."login/index.php?action=flogin&referer =".urlencode( $url )); //print $msg; return false; } } /** * @desc kick out if reach this file without SESSION * @param none * @return bool **/ function checkSession() { if (!isset($_SESSION['NAMAPEGAWAI']) AND ($_SESSION['NAMAPEGAWAI'] == null)) { //if sesion registered IDPegawai not found, destroy all session and return false session_destroy(); return false; } return true; } /** * @desc Save an instance of $_POST to database. * @param $_POST */ function save( $_POST ) { if ($this->db) { if ( $this->isExist($_POST['IDPegawai']) ) { // print "<pre>"; // print_r($_POST); // exit; $pegawai = $this->getPegawaiById($_POST['IDPegawai']); $query = "UPDATE " . TBL_PEGAWAI . " SET "; $query .= "namaPegawai='" . $this->escape( $_POST['namaPegawai'] ) . "', "; $query .= "jenisKelamin='" . $this->escape( $_POST['jenisKelamin'] ) . "', "; $query .= "tempatLahir='" . $this->escape( $_POST['tempatLahir'] ) . "', "; $query .= "tanggalLahir='" . $this->escape( $_POST['tanggalLahir'] ) . "', "; $query .= "alamatPegawai='" . $this->escape( $_POST['alamatPegawai'] ) . "', "; $query .= "teleponPegawai='" . $this->escape( $_POST['teleponPegawai'] ) . "', "; $query .= "pendidikanTerakhir='" . $this->escape( $_POST['pendidikanTerakhir'] ) . "', "; $query .= "email='" . $this->escape( $_POST['email'] ) . "', "; $query .= "mulaiTugas='" . $this->escape( $_POST['mulaiTugas'] ) . "', "; $query .= "IDJabatan='" . $this->escape( $_POST['IDJabatan'] ) . "', "; $query .= "IDUser='" . $this->escape( $_POST['IDUser'] ) . "', "; $query .= "IDJurusan='" . $this->escape( $_POST['IDJurusan'] ) . "', "; $query .= "statusPegawai='" . $this->escape( $_POST['statusPegawai'] ) . "' ";

$query .= "WHERE IDPegawai='" . $_POST['IDPegawai'] . "'"; } else { // print "<pre>"; // print_r($_POST); // exit; /* * INSERT INTO TBL_PEGAWAI */ $query = "INSERT INTO " . TBL_PEGAWAI . " "; $query .= "(IDPegawai, namaPegawai, jenisKelamin, tempatLahir, tanggalLahir, alamatPegawai, teleponPegawai, pendidikanTerakhir, email, mulaiTugas, IDJabatan, IDUser, IDJurusan, username, password, loginTerakhir, IP, statusPegawai) "; $query .= "VALUES ("; $query .= "'', "; $query .= "'" . $this->escape( $_POST['namaPegawai'] ) . "', "; $query .= "'" . $this->escape( $_POST['jenisKelamin'] ) . "', "; $query .= "'" . $this->escape( $_POST['tempatLahir'] ) . "', "; $query .= "'" . $this->escape( $_POST['tanggalLahir'] ) . "', "; $query .= "'" . $this->escape( $_POST['alamatPegawai'] ) . "', "; $query .= "'" . $this->escape( $_POST['teleponPegawai'] ) . "', "; $query .= "'" . $this->escape( $_POST['pendidikanTerakhir'] ) . "', "; $query .= "'" . $this->escape( $_POST['email'] ) . "', "; $query .= "'" . $this->escape( $_POST['mulaiTugas'] ) . "', "; $query .= "'" . $this->escape( $_POST['IDJabatan'] ) . "', "; $query .= "'" . $this->escape( $_POST['IDUser'] ) . "', "; $query .= "'" . $this->escape( $_POST['IDJurusan'] ) . "', "; $query .= "'" . $this->escape( $_POST['username'] ) . "', "; $password = $this->escape( $_POST['password'] ); $query .= "'" . md5($password) . "', "; $query .= "'', "; $query .= "'', "; $query .= "'" . $this->escape( $_POST['statusPegawai'] ) . "'"; $query .= ") "; } } // print "<pre>"; // print $query."
"; // exit; $result = $this->db->query($query); return $result; } /** * @desc Change Pegawai passsword * * @param $_POST */ function changePassword( $_POST ) { if ($this->db) { if ( $this->isExist($_POST['IDPegawai']) ) { $admin = $this->getPegawaiById( $_POST['IDPegawai'] ); if($admin[0]['password'] == md5($_POST['passwordLama']) AND $_POST['passwordBaru'] == $_POST['passwordBaruConfirm']) { //UPDATE TABLE SYSTEM admin DATA $query = "UPDATE " . TBL_PEGAWAI . " SET password = '" . $this->escape( md5($_POST['passwordBaru']) ) . "' WHERE IDPegawai='" . $_POST['IDPegawai'] . "'"; } } else { return false; } } $result = $this->db->query($query); $sendMail = $this->mail>sendPasswordResetMail($admin[0]['email'], $admin[0]['username'], $_POST['passwordBaru']); // print "<pre>"; // print $query . "
"; // print_r($admin) . "
"; // exit; return true; } /** * @desc Reset Pegawai passsword

* * @param $_POST */ function forgotPassword( $email ) { if ($this->db) { $admin = $this->getPegawaiByEmail( $email ); if(is_array($admin) AND $admin[0]['statusPegawai'] == 1) { $confirmation = md5($admin[0]['email'] . $admin[0]['username']); $sendMail = $this->mail>sendPasswordChangeConfirmation($admin[0]['email'], $admin[0]['username'], $admin[0]['IDPegawai'], $confirmation); return true; } else { return false; } } } /** * @desc Reset Pegawai passsword * * @param $_POST */ function resetPassword( $email ) { if ($this->db) { $admin = $this->getPegawaiByEmail( $email ); if(is_array($admin) AND $admin[0]['statusPegawai'] == 1) { $passwordBaru = $this->generateRandomString(); $sendMail = $this->mail>sendForgotPassword($admin[0]['email'], $admin[0]['username'], $passwordBaru); /* * Update Password */ $query = "UPDATE " . TBL_PEGAWAI . " SET password = '" . md5($passwordBaru) . "' WHERE IDPegawai='" . $admin[0]['IDPegawai'] . "'"; $result = $this->db->query($query); // print "<pre>"; // print_r($admin) . "
"; // print $passwordBaru . "
"; // print $query . "
"; // exit; return true; } else { return $result['message'] = "Account anda sudah tidak aktif"; } } } /** * @desc generateRandomString for Pegawai passsword * * @param * @return String */ function generateRandomString($length = 6, $letters = '1234567890qwertyuiopasdfghjklzxcvbnm') { $s = ''; $lettersLength = strlen($letters)-1; for($i = 0 ; $i < $length ; $i++) { $s .= $letters[rand(0,$lettersLength)]; } return $s; } /** * @desc Check whether a Pegawai with specific IDPegawai exist in database * * @param IDPegawai

* @return true if exist false otherwise */ function isExist( $IDPegawai = '' ) { if (strlen($IDPegawai) <= 0) { return false; } $result = 0; $query = "SELECT COUNT(a.IDPegawai) AS total FROM " . TBL_PEGAWAI . " a WHERE a.IDPegawai='" . $IDPegawai . "'"; if ($this->db) { $result = $this->db->query($query); } if ($result) { $count = 0; if (is_array($result)) { $count = $result[0][0]; } return $count > 0; } return false; } /** * Remove a single Pegawai from database. * * @param IDPegawai to remove * @return the number of object removed from database */ function remove($IDPegawai = "") { $result = 0; if ((strlen($IDPegawai) > 0) && $this->db) { //DELETE FROM TABLE SYSTEM Pegawai $query = "DELETE FROM " . TBL_PEGAWAI . " WHERE IDPegawai = '" . $IDPegawai . "'"; $result = $this->db->query($query); } return $result; } /** * Escape a form data before adding to database. * * @param value the String to be escaped * @return safe string */ function escape( $value ) { if (get_magic_quotes_gpc()) { return $value; } else { return addslashes($value); } } function updatePassword($username) { //UPDATE TABLE SYSTEM PEGAWAI DATA $query = "UPDATE " . TBL_PEGAWAI . " SET password = '" . $this->escape( md5($username) ) . "' WHERE username='" . $username . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query . "
"; // exit; return true; } } ?>

if (strlen($page) > 0) { $query .= " LIMIT " . ($page * $count) . ", " . $count; } $result = $this->db->query($query); return $result[0];

tlPiket.class.php
} else { echo "Error line 85 tlPiket.class.php"; return; }

function tlPiket($db_object) { $this->db = $db_object; } } /** * @desc getAllPiketDataList in TBL_PIKET * @var * @param $count, $page, $_GET * @return Array **/ function getAllPiketDataList($count = 0, $page = 0, $_GET) { if ($this->db) { $namaPegawai = $_GET['namaPegawai']; $result = 0; $query = "SELECT * FROM " . TBL_PIKET . " a LEFT JOIN( " . TBL_PEGAWAI . " b) ON(a.IDPegawai=b.IDPegawaiPiket) WHERE 1=1"; if (!empty($_GET)) { if(!empty($namaPegawai) && $namaPegawai != "") { $query .= " AND a.namaPegawai LIKE '%" . trim($namaPegawai) . "%'"; } } $query .= " ORDER BY a.namaPegawai ASC "; if (strlen($page) > 0) { $query .= " LIMIT " . ($page * $count) . ", " . $count; } $result = $this->db->query($query); print "<pre>"; print $query . "
"; print_r($result); exit; return $result;

// // // //

} else { echo "Error line 43 tlPiket.class.php"; return; } } /** * @desc Gets a total of Piket available in database. * * @param active the active flag * @return array or null */ function getPiketCount( $_GET ) { if ($this->db) { $namaPiket = $_GET['namaPiket']; $result = 0; $query = "SELECT * FROM " . TBL_PIKET . " a LEFT JOIN( " . TBL_PEGAWAI . " b) ON(a.IDPegawai=b.IDPegawaiPiket) WHERE 1=1"; if (!empty($_GET)) { if(!empty($namaPegawai) && $namaPegawai != "") { $query .= " AND a.namaPegawai LIKE '%" . trim($namaPegawai) . "%'"; } } $query .= " ORDER BY a.namaPegawai ASC ";

/** * @desc getPiketById in TBL_PIKET at specific IDPiket * @param IDPiket from $_GET * @var IDPiket * @return Array **/ function getPiketById( $IDPiket ) { if ($this->db) { $query = "SELECT * FROM " . TBL_PIKET . " a WHERE a.IDPiket='" . $IDPiket . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit; return $result; } else { echo "Error line 115 tlPiket.class.php"; return; } } /** * @desc getPiketByParameter in TBL_PIKET at specific Parameter * @param Parameter * @var Parameter * @return Array **/ function getPiketByParameter( $IDJurusan, $IDTahunPelajaran, $tanggalPiket ) { if ($this->db) { $query = "SELECT * FROM " . TBL_PIKET . " a LEFT JOIN (" . TBL_PEGAWAI . " b) ON(a.IDPegawaiPiket = b.IDPegawai) WHERE "; if($IDJurusan != "") { $query .= "a.IDJurusan='" . $IDJurusan . "' AND "; } $query .= "a.IDTahunPelajaran='" . $IDTahunPelajaran . "' AND a.tanggalPiket='" . $tanggalPiket . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit; return $result; } else { echo "Error line 146 tlPiket.class.php"; return; } } /** * @desc getPiketByParameter2 in TBL_PIKET at specific Parameter2 * @param Parameter 2 * @var Parameter * @return Array **/ function getPiketByParameter2( $IDJurusan, $IDTahunPelajaran, $tanggalPiket, $IDPegawaiPiket ) { if ($this->db) {

$query = "SELECT * FROM " . TBL_PIKET . " a LEFT JOIN (" . TBL_PEGAWAI . " b) ON(a.IDPegawaiPiket = b.IDPegawai) WHERE a.IDJurusan='" . $IDJurusan . "' AND a.IDTahunPelajaran='" . $IDTahunPelajaran . "' AND a.tanggalPiket='" . $tanggalPiket . "' AND a.IDPegawaiPiket='" . $IDPegawaiPiket . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit; return $result; } else { echo "Error line 146 tlPiket.class.php"; return; } } /** * @desc countPiketByIDPegawai in TBL_PIKET at specific IDPegawai * @param IDPegawai * @var IDPegawai * @return Array **/ function countPiketByIDPegawai( $m, $y, $IDPegawai ) { if ($this->db) { $query = "SELECT COUNT(a.IDPiket) as jumlahPiket FROM " . TBL_PIKET . " a WHERE 1=1 AND a.IDPegawaiPiket='" . $IDPegawai . "' AND MONTH(a.tanggalPiket)='" . $m . "' AND YEAR(a.tanggalPiket)='" . $y . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // print_r($result); // exit; return $result; } else { echo "Error line 199 tlAbsensi.class.php"; return; } } /** * @desc Save an instance of $_POST to database. * @param $_POST */ function save( $_POST ) { if ($this->db) { if ( $this->isExist($_POST['IDJurusan'], $_POST['IDTahunPelajaran'], $_POST['tanggalPiket']) ) { // print "<pre>"; // print_r($_POST); // exit; $query = "UPDATE " . TBL_PIKET . " SET "; $query .= "IDJurusan='" . $this->escape( $_POST['IDJurusan'] ) . "', "; $query .= "IDTahunPelajaran='" . $this->escape( $_POST['IDTahunPelajaran'] ) . "', "; $query .= "tanggalPiket='" . $this->escape( $_POST['tanggalPiket'] ) . "', "; $query .= "IDPegawaiPiket='" . $this->escape( $_POST['IDPegawaiPiket'] ) . "', "; $query .= "keteranganPiket='" . $this->escape( $_POST['keteranganPiket'] ) . "' "; $query .= "WHERE IDJurusan='" . $_POST['IDJurusan'] . "' AND IDTahunPelajaran='" . $_POST['IDTahunPelajaran'] . "' AND tanggalPiket='" . $_POST['tanggalPiket'] . "'"; } else { // print "<pre>"; // print_r($_POST); // exit;

$query = "INSERT INTO " . TBL_PIKET . " "; $query .= "(IDPiket, IDJurusan, IDTahunPelajaran, tanggalPiket, IDPegawaiPiket, keteranganPiket) "; $query .= "VALUES ("; $query .= "'', "; $query .= "'" . $this->escape( $_POST['IDJurusan'] ) . "', "; $query .= "'" . $this->escape( $_POST['IDTahunPelajaran'] ) . "', "; $query .= "'" . $this->escape( $_POST['tanggalPiket'] ) . "', "; $query .= "'" . $this->escape( $_POST['IDPegawaiPiket'] ) . "', "; $query .= "'" . $this->escape( $_POST['keteranganPiket'] ) . "' "; $query .= ") "; } } // print "<pre>"; // print $query."
"; // exit; $result = $this->db->query($query); return $result; } /** * @desc Check whether a Piket with specific parameter exist in database * * @param * @return true if exist false otherwise */ function isExist( $IDJurusan, $IDTahunPelajaran, $tanggalPiket ) { $result = 0; $query = "SELECT COUNT(a.IDPiket) AS total FROM " . TBL_PIKET . " a WHERE a.IDJurusan='" . $IDJurusan . "' AND a.IDTahunPelajaran='" . $IDTahunPelajaran . "' AND a.tanggalPiket='" . $tanggalPiket . "'"; if ($this->db) { $result = $this->db->query($query); } if ($result) { $count = 0; if (is_array($result)) { $count = $result[0][0]; } return $count > 0; } return false; } /** * Remove a single Piket from database. * * @param IDPiket to remove * @return the number of object removed from database */ function remove($IDPiket = "") { $result = 0; if ((strlen($IDPiket) > 0) && $this->db) { $query = "DELETE FROM " . TBL_PIKET . " WHERE IDPiket = '" . $IDPiket . "'"; $result = $this->db->query($query); } return $result; } /** * Escape a form data before adding to database. * * @param value the String to be escaped * @return safe string */ function escape( $value ) { if (get_magic_quotes_gpc()) { return $value; } else {

return addslashes($value);

//

exit; return $result;

} }

} else { echo "Error line 43 tlTahunPelajaran.class.php"; return; }

} ?> tlTahunPelajaran.class.php } db = $db_object; } /** * @desc getAllTahunPelajaran in TBL_TAHUNPELAJARAN * @var * @param * @return Array **/ function getAllTahunPelajaran() { if ($this->db) { $query = "SELECT * FROM " . TBL_TAHUNPELAJARAN . " a WHERE 1=1 ORDER BY IDTahunPelajaran ASC"; $result = $this->db->query($query); // print "<pre>"; // print $query . "
"; // print_r($result); // exit; return $result; } else { echo "Error line 40 tlTahunPelajaran.class.php"; return; } } /** * @desc getAllTahunPelajaranDataList in TBL_JABATAN * @var * @param $count, $page, $_GET * @return Array **/ function getAllTahunPelajaranDataList($count = 0, $page = 0, $_GET, $status) { if ($this->db) { $namaTahunPelajaran = $_GET['namaTahunPelajaran']; $result = 0; $query = "SELECT * FROM " . TBL_TAHUNPELAJARAN . " a WHERE 1=1"; if (!empty($_GET)) { if(!empty($namaTahunPelajaran) && $namaTahunPelajaran != "") { $query .= " AND a.namaTahunPelajaran LIKE '%" . trim($namaTahunPelajaran) . "%'"; } } if(!empty($status) && $status > 0) { $query .= " AND a.statusTahunPelajaran = '1'"; } $query .= " ORDER BY a.IDTahunPelajaran ASC ";

// // //

if (strlen($page) > 0) { $query .= " LIMIT " . ($page * $count) . ", " . $count; } $result = $this->db->query($query); print "<pre>"; print $query . "
"; print_r($result);

/** * @desc Gets a total of TahunPelajaran available in database. * * @param * @return array or null */ function getTahunPelajaranCount( $_GET ) { if ($this->db) { $namaTahunPelajaran = $_GET['namaTahunPelajaran']; $result = 0; $query = "SELECT COUNT(a.IDTahunPelajaran) AS total FROM " . TBL_TAHUNPELAJARAN . " a WHERE 1=1"; if (!empty($_GET)) { if(!empty($namaTahunPelajaran) && $namaTahunPelajaran != "") { $query .= " AND a.namaTahunPelajaran LIKE '%" . trim($namaTahunPelajaran) . "%'"; } } $result = $this->db->query($query); return $result[0]; } else { echo "Error line 85 tlTahunPelajaran.class.php"; return; } } /** * @desc getTahunPelajaranById in TBL_TAHUNPELAJARAN at specific IDTahunPelajaran * @param IDTahunPelajaran from $_GET * @var IDTahunPelajaran * @return Array **/ function getTahunPelajaranById( $IDTahunPelajaran ) { if ($this->db) { $query = "SELECT * FROM " . TBL_TAHUNPELAJARAN . " a WHERE a.IDTahunPelajaran='" . $IDTahunPelajaran . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit; return $result; } else { echo "Error line 115 tlTahunPelajaran.class.php"; return; } } /** * @desc getTahunPelajaranActive in TBL_TAHUNPELAJARAN at specific Jurusan * @param $IDJurusan * @var $IDJurusan * @return Array **/ function getTahunPelajaranActiveByJurusan( $IDJurusan ) { if ($this->db) { $query = "SELECT * FROM " . TBL_TAHUNPELAJARAN . " a WHERE a.statusTahunPelajaran='1'

AND a.IDJurusan='" . $IDJurusan . "'"; $result = $this->db->query($query); print "<pre>"; print $query; print_r($result); exit; return $result;

// // // //

} else { echo "Error line 164 tlTahunPelajaran.class.php"; return; } } /** * @desc getTahunPelajaranActive in TBL_TAHUNPELAJARAN * @param * @var * @return Array **/ function getTahunPelajaranActive( ) { if ($this->db) { $query = "SELECT * FROM " . TBL_TAHUNPELAJARAN . " a WHERE a.statusTahunPelajaran='1'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // print_r($result); // exit; return $result; } else { echo "Error line 190 tlTahunPelajaran.class.php"; return; } } /** * @desc Save an instance of $_POST to database. * @param $_POST */ function save( $_POST ) { if ($this->db) { if ( $this->isExist($_POST['IDTahunPelajaran']) ) { // print "<pre>"; // print_r($_POST); // exit; //UPDATE TBL_TAHUNPELAJARAN $query = "UPDATE " . TBL_TAHUNPELAJARAN . " SET "; $query .= "namaTahunPelajaran='" . $this->escape( $_POST['namaTahunPelajaran'] ) . "', "; $query .= "keteranganTahunPelajaran='" . $this->escape( $_POST['keteranganTahunPelajaran'] ) . "', "; $query .= "statusTahunPelajaran='" . $this->escape( $_POST['statusTahunPelajaran'] ) . "' "; $query .= "WHERE IDTahunPelajaran='" . $_POST['IDTahunPelajaran'] . "'"; } else { // print "<pre>"; // print_r($_POST); // exit; /* * INSERT INTO TBL_TAHUNPELAJARAN */ $query = "INSERT INTO " . TBL_TAHUNPELAJARAN . " "; $query .= "(IDTahunPelajaran, namaTahunPelajaran, keteranganTahunPelajaran, statusTahunPelajaran) "; $query .= "VALUES ("; $query .= "'', "; $query .= "'" . $this->escape( $_POST['namaTahunPelajaran'] ) . "', "; $query .= "'" . $this->escape( $_POST['keteranganTahunPelajaran'] ) . "', ";

$query .= "'" . $this->escape( $_POST['statusTahunPelajaran'] ) . "' "; $query .= ") "; } } // // //

print "<pre>"; print $query."
"; exit; $result = $this->db->query($query); return $result; }

/** * @desc Check whether a TahunPelajaran with specific IDTahunPelajaran exist in database * * @param IDTahunPelajaran * @return true if exist false otherwise */ function isExist( $IDTahunPelajaran = '' ) { if (strlen($IDTahunPelajaran) <= 0) { return false; } $result = 0; $query = "SELECT COUNT(a.IDTahunPelajaran) AS total FROM " . TBL_TAHUNPELAJARAN . " a WHERE a.IDTahunPelajaran='" . $IDTahunPelajaran . "'"; if ($this->db) { $result = $this->db->query($query); } if ($result) { $count = 0; if (is_array($result)) { $count = $result[0][0]; } return $count > 0; } return false; } /** * Remove a single TahunPelajaran from database. * * @param IDTahunPelajaran to remove * @return the number of object removed from database */ function remove($IDTahunPelajaran = "") { $result = 0; if ((strlen($IDTahunPelajaran) > 0) && $this->db) { $query = "DELETE FROM " . TBL_TAHUNPELAJARAN . " WHERE IDTahunPelajaran = '" . $IDTahunPelajaran . "'"; $result = $this->db->query($query); } return $result; } /** * Escape a form data before adding to database. * * @param value the String to be escaped * @return safe string */ function escape( $value ) { if (get_magic_quotes_gpc()) { return $value; } else { return addslashes($value); } } } ?>

* @param active the active flag * @return array or null */ function getUserCount( $_GET ) { if ($this->db) { $namaUser = $_GET['namaUser'];

tlUser.class.php
class tlUser { var $db; function tlUser($db_object) { $this->db = $db_object; }

// // // //

/** * @desc getAllUser in TBL_USER * @var * @param * @return Array **/ function getAllUser() { if ($this->db) { $query = "SELECT * FROM " . TBL_USER . " a WHERE 1=1"; $result = $this->db->query($query); print "<pre>"; print $query . "
"; print_r($result); exit; return $result; } else { echo "Error line 40 tlUser.class.php"; return; } } /** * @desc getAllUserDataList in TBL_USER * @var * @param $count, $page, $_GET * @return Array **/ function getAllUserDataList($count = 0, $page = 0, $_GET) { if ($this->db) { $namaUser = $_GET['namaUser']; $result = 0; $query = "SELECT * FROM " . TBL_USER . " a WHERE 1=1"; if (!empty($_GET)) { if(!empty($namaUser) && $namaUser != "") { $query .= " AND a.namaUser LIKE '%" . trim($namaUser) .

"%'"; } } $query .= " ORDER BY a.IDUser ASC "; if (strlen($page) > 0) { $query .= " LIMIT " . ($page * $count) . ", " . $count; } $result = $this->db->query($query); print "<pre>"; print $query . "
"; print_r($result); exit; return $result;

// // // //

} else { echo "Error line 43 tlUser.class.php"; return; }

$result = 0; $query = "SELECT COUNT(a.IDUser) AS total FROM " . TBL_USER . " a WHERE 1=1"; if (!empty($_GET)) { if(!empty($namaUser) && $namaUser != "") { $query .= " AND a.namaUser LIKE '%" . trim($namaUser) . "%'"; } } $result = $this->db->query($query); return $result[0]; } else { echo "Error line 85 tlUser.class.php"; return; } } /** * @desc getUserById in TBL_USER at specific IDUser * @param IDUser from $_GET * @var IDUser * @return Array **/ function getUserById( $IDUser ) { if ($this->db) { $query = "SELECT * FROM " . TBL_USER . " a WHERE a.IDUser='" . $IDUser . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit; return $result; } else { echo "Error line 115 tlUser.class.php"; return; } } /** * @desc Save an instance of $_POST to database. * @param $_POST */ function save( $_POST ) { if ($this->db) { if ( $this->isExist($_POST['IDUser']) ) { // print "<pre>"; // print_r($_POST); // exit; //UPDATE TABLE PERSON DATA $query = "UPDATE " . TBL_USER . " SET "; $query .= "namaUser='" . $this->escape( $_POST['namaUser'] ) . "', "; $query .= "keteranganUser='" . $this->escape( $_POST['keteranganUser'] ) . "' ";

} /** * @desc Gets a total of User available in database. *

// //

$query .= "WHERE IDUser='" . $_POST['IDUser'] . "'"; } else { print "<pre>"; print_r($_POST);

//

exit; /* * INSERT INTO TBL_USER */ $query = "INSERT INTO " . TBL_USER . " "; $query .= "(IDUser, namaUser, keteranganUser) "; $query .= "VALUES ("; $query .= "'', "; $query .= "'" . $this->escape( $_POST['namaUser'] ) . "', "; $query .= "'" . $this->escape( $_POST['keteranganUser'] ) . "' "; $query .= ") ";

{ return addslashes($value); } } } ?> tlWaktuMengajar.class.php
} } // // //

print "<pre>"; print $query."
"; exit; $result = $this->db->query($query); return $result; } /** * @desc Check whether a User with specific IDUser exist in database * * @param IDUser * @return true if exist false otherwise */ function isExist( $IDUser = '' ) { if (strlen($IDUser) <= 0) { return false; }

$result = 0; $query = "SELECT COUNT(a.IDUser) AS total FROM " . TBL_USER . " a WHERE a.IDUser='" . $IDUser . "'"; if ($this->db) { $result = $this->db->query($query); } if ($result) { $count = 0; if (is_array($result)) { $count = $result[0][0]; } return $count > 0; } return false; } /** * Remove a single User from database. * * @param IDUser to remove * @return the number of object removed from database */ function remove($IDUser = "") { $result = 0; if ((strlen($IDUser) > 0) && $this->db) { $query = "DELETE FROM " . TBL_USER . " WHERE IDUser = '" . $IDUser . "'"; $result = $this->db->query($query); } return $result; }

class tlWaktuMengajar { var $db; function tlWaktuMengajar($db_object) { $this->db = $db_object; } /** * @desc getAllWaktuMengajar in TBL_WAKTUMENGAJAR * @var * @param * @return Array **/ function getAllWaktuMengajar() { if ($this->db) { $query = "SELECT * FROM " . TBL_WAKTUMENGAJAR . " a WHERE 1=1"; $result = $this->db->query($query); // print "<pre>"; // print $query . "
"; // print_r($result); // exit; return $result; } else { echo "Error line 40 tlWaktuMengajar.class.php"; return; } } /** * @desc getAllWaktuMengajarDataList in TBL_WAKTUMENGAJAR * @var * @param $count, $page, $_GET * @return Array **/ function getAllWaktuMengajarDataList($count = 0, $page = 0, $_GET) { if ($this->db) { $namaTahunPelajaran = $_GET['namaTahunPelajaran']; $namaPegawai = $_GET['namaPegawai']; $result = 0; $query = "SELECT * FROM " . TBL_WAKTUMENGAJAR . " a LEFT JOIN (" . TBL_TAHUNPELAJARAN . " b, " . TBL_PEGAWAI . " c) ON(a.IDTahunPelajaran=b.IDTahunPelajaran AND a.IDPegawai=c.IDPegawai) WHERE 1=1 AND b.statusTahunPelajaran=1"; if (!empty($_GET)) { if(!empty($namaTahunPelajaran) && $namaTahunPelajaran != "") {

/** * Escape a form data before adding to database. * * @param value the String to be escaped * @return safe string */ function escape( $value ) { if (get_magic_quotes_gpc()) { return $value; } else

$query .= " AND b.namaTahunPelajaran = '" . trim($namaTahunPelajaran) . "'"; } if(!empty($namaPegawai) && $namaPegawai != "") { $query .= " AND c.namaPegawai LIKE '%" . trim($namaPegawai) . "%'"; } } $query .= " ORDER BY a.IDTahunPelajaran DESC, c.namaPegawai ASC"; if (strlen($page) > 0)

{

return $result; } else { echo "Error line 115 tlWaktuMengajar.class.php"; return; }

$query .= " LIMIT " . ($page * $count) . ", " . $count; } $result = $this->db->query($query); print "<pre>"; print $query . "
"; print_r($result); exit; return $result;

// // // //

} else { echo "Error line 43 tlWaktuMengajar.class.php"; return; } } /** * @desc Gets a total of WaktuMengajar available in database. * * @param active the active flag * @return array or null */ function getWaktuMengajarCount( $_GET ) { if ($this->db) { $namaTahunPelajaran = $_GET['namaTahunPelajaran']; $namaPegawai = $_GET['namaPegawai']; $result = 0; $query = "SELECT COUNT(a.IDWaktuMengajar) AS total FROM " . TBL_WAKTUMENGAJAR . " a LEFT JOIN (" . TBL_TAHUNPELAJARAN . " b, " . TBL_PEGAWAI . " c) ON(a.IDTahunPelajaran=b.IDTahunPelajaran AND a.IDPegawai=c.IDPegawai) WHERE 1=1 AND b.statusTahunPelajaran=1"; if (!empty($_GET)) { if(!empty($namaTahunPelajaran) && $namaTahunPelajaran != "") { $query .= " AND b.namaTahunPelajaran = '" . trim($namaTahunPelajaran) . "'"; } if(!empty($namaPegawai) && $namaPegawai != "") { $query .= " AND c.namaPegawai LIKE '%" . trim($namaPegawai) . "%'"; } } $query .= " ORDER BY a.IDTahunPelajaran DESC, c.namaPegawai ASC"; $result = $this->db->query($query); return $result[0]; } else { echo "Error line 85 tlWaktuMengajar.class.php"; return; } } /** * @desc getWaktuMengajarById in TBL_WAKTUMENGAJAR at specific IDWaktuMengajar * @param IDWaktuMengajar from $_GET * @var IDWaktuMengajar * @return Array **/ function getWaktuMengajarById( $IDWaktuMengajar ) { if ($this->db) { $query = "SELECT * FROM " . TBL_WAKTUMENGAJAR . " a LEFT JOIN (" . TBL_TAHUNPELAJARAN . " b, " . TBL_PEGAWAI . " c) ON(a.IDTahunPelajaran=b.IDTahunPelajaran AND a.IDPegawai=c.IDPegawai) WHERE a.IDWaktuMengajar='" . $IDWaktuMengajar . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit;

} /** * @desc getWaktuMengajarByIdPegawai in TBL_WAKTUMENGAJAR at specific IDPegawai * @param IDPegawai from $_GET * @var IDPegawai * @return Array **/ function getWaktuMengajarByIdPegawai( $IDTahunPelajaran, $IDPegawai ) { if ($this->db) { $query = "SELECT * FROM " . TBL_WAKTUMENGAJAR . " a LEFT JOIN (" . TBL_TAHUNPELAJARAN . " b, " . TBL_PEGAWAI . " c) ON(a.IDTahunPelajaran=b.IDTahunPelajaran AND a.IDPegawai=c.IDPegawai) WHERE a.IDTahunPelajaran='" . $IDTahunPelajaran . "' AND a.IDPegawai='" . $IDPegawai . "'"; $result = $this->db->query($query); // print "<pre>"; // print $query; // exit; return $result; } else { echo "Error line 178 tlWaktuMengajar.class.php"; return; } } /** * @desc Save an instance of $_POST to database. * @param $_POST */ function save( $_POST ) { if ($this->db) { if ( $this->isExist($_POST['IDWaktuMengajar']) ) { // print "<pre>"; // print_r($_POST); // exit; //UPDATE TABLE PERSON DATA $query = "UPDATE " . TBL_WAKTUMENGAJAR . " SET "; $query .= "IDTahunPelajaran='" . $this->escape( $_POST['IDTahunPelajaran'] ) . "', "; $query .= "IDPegawai='" . $this->escape( $_POST['IDPegawai'] ) . "', "; $query .= "jumlahWaktuMengajar='" . $this->escape( $_POST['jumlahWaktuMengajar'] ) . "' "; $query .= "WHERE IDWaktuMengajar='" . $_POST['IDWaktuMengajar'] . "'"; } else { // print "<pre>"; // print_r($_POST); // exit; /* * INSERT INTO TBL_WAKTUMENGAJAR */ $query = "INSERT INTO " . TBL_WAKTUMENGAJAR . " "; $query .= "(IDWaktuMengajar, IDTahunPelajaran, IDPegawai, jumlahWaktuMengajar) "; $query .= "VALUES ("; $query .= "'', "; $query .= "'" . $this->escape( $_POST['IDTahunPelajaran'] ) . "', "; $query .= "'" . $this->escape( $_POST['IDPegawai'] ) . "', ";

$query .= "'" . $this->escape( $_POST['jumlahWaktuMengajar']

index.php

$query .= ") ";


) . "' "; } } // // //

print "<pre>"; print $query."
"; exit; $result = $this->db->query($query); return $result; }

/** * @desc Check whether a WaktuMengajar with specific IDWaktuMengajar exist in database * * @param IDWaktuMengajar * @return true if exist false otherwise */ function isExist( $IDWaktuMengajar = '' ) { if (strlen($IDWaktuMengajar) <= 0) { return false; } $result = 0; $query = "SELECT COUNT(a.IDWaktuMengajar) AS total FROM " . TBL_WAKTUMENGAJAR . " a WHERE a.IDWaktuMengajar='" . $IDWaktuMengajar . "'"; if ($this->db) { $result = $this->db->query($query); } if ($result) { $count = 0; if (is_array($result)) { $count = $result[0][0]; } return $count > 0; } return false;

if (!isset($_GET['action'])){ header('location: '.ADMIN_URL.'home.php'); exit; } switch ($_GET['action']){ case 'login' : $status = $tlPegawai->authenticate( $_POST['username'], $_POST['password'], $_POST['level']); /* * Result Action */ if ( $tlPegawai->checkSession() === true ){ header('location: '.ADMIN_URL.'home.php?info=success'); exit; } else{ header('location: '.ADMIN_URL.'login/index.php?action='.$status.'&err=invalid'); exit; } break; case 'logout' : $logoutResult = $tlPegawai->logout(); if($logoutResult == TRUE){ header('location: '.ADMIN_URL.'login/index.php?action=logout'); } break; } //ob_end_flush(); ?> home.php
} /** * Remove a single WaktuMengajar from database. * * @param IDWaktuMengajar to remove * @return the number of object removed from database */ function remove($IDWaktuMengajar = "") { $result = 0; if ((strlen($IDWaktuMengajar) > 0) && $this->db) { $query = "DELETE FROM " . TBL_WAKTUMENGAJAR . " WHERE IDWaktuMengajar = '" . $IDWaktuMengajar . "'"; $result = $this->db->query($query); } return $result; } /** * Escape a form data before adding to database. * * @param value the String to be escaped * @return safe string */ function escape( $value ) { if (get_magic_quotes_gpc()) { return $value; } else { return addslashes($value); } } } ?>

$pegawaiData = $tlPegawai->getPegawaiById( $_SESSION['IDPEGAWAI'] ); $config->show_header(); ?>
,

 
:
: toIndonesianFullDate(strtotime($pegawaiData[0]['loginTerakhir']))?>
:
show_footer(); ?>