require "libraries/database.php";
$database = new database();
require "libraries/number.php";
$number = new number();
require "libraries/form.php";
$form = new form();
$addr_root = "http://" . $_SERVER['SERVER_NAME'];
if (isset($_POST['action']) && $_POST['action'] == "absen") {
$pegawai_id = $form->input('pegawai_id');
$keterangan = $form->input('keterangan');
$jam = date('H:i:s');
$datetime = date('Y-m-d H:i:s');
$today = date('Y-m-d');
if (isset($_POST['absen_datang'])) {
$id = $number->id('absensi', 10, '');
$sql = "INSERT INTO absensi VALUES('{$id}','{$pegawai_id}','{$today}','{$jam}','','1','0','{$keterangan}',''," . "'{$pegawai_id}','{$datetime}','','')";
if (!$database->query($sql)) {
//die($sql);
$_SESSION['info'] = "Error: SQL Command";
header("Location: " . $addr_root . "/index.php");
exit;
} else {
$_SESSION['info'] = "Absensi Sudah Ditambahkan";
header("Location: " . $addr_root . "/index.php");
exit;
}
}
if (isset($_POST['absen_pulang'])) {
$sql = "UPDATE absensi SET jam_pulang='{$jam}', status_pulang='1', keterangan_pulang='{$keterangan}', upd='{$pegawai_id}', upd_date='{$datetime}' WHERE pegawai_id='{$pegawai_id}'";
if (!$database->query($sql)) {
$propinsi_id = $form->input('propinsi_id');
$kota_id = $form->input('kota_id');
$kecamatan_id = $form->input('kecamatan_id');
$desa_id = $form->input('desa_id');
$hp = $form->input('hp');
$telp_rumah = $form->input('telp_rumah');
$telp_kantor = $form->input('telp_kantor');
$faksimil = $form->input('faksimil');
$email = $form->input('email');
$action = $form->input('action');
$user = $_SESSION['nama'];
$date = date('Y-m-d H:i:s');
// START INSERT DATA ==============================>
if ($action == "insert") {
$foto = $_FILES['foto']['name'];
$id = $number->id('anggota', 5);
$kta_baru = $number->kta($desa_id, $tgl_lahir, $id);
if (empty($foto)) {
$foto = "user.png";
} else {
$source = $_FILES['foto']['tmp_name'];
$image->upload($foto, $source);
$image->thumbnail($foto);
}
$sql = "INSERT INTO anggota\n (id,nama, id_tipe, id_no, jabatan, tempat, tgl_lahir, jns_kelamin, agama,\n pernikahan, pekerjaan_id, pendidikan, alamat, rt, rw, propinsi_id, kota_id, kecamatan_id,\n desa_id, hp, telp_rumah, telp_kantor, faksimil, email, foto, kta_baru, aktif, crt, crt_date) \n VALUES \n ('{$id}','{$nama}','{$id_tipe}','{$id_no}','{$jabatan}','{$tempat}','{$tgl_lahir}','{$jns_kelamin}','{$agama}',\n '{$pernikahan}','{$pekerjaan_id}','{$pendidikan}','{$alamat}','{$rt}','{$rw}','{$propinsi_id}','{$kota_id}','{$kecamatan_id}',\n '{$desa_id}','{$hp}','{$telp_rumah}','{$telp_kantor}','{$faksimil}','{$email}','{$foto}','{$kta_baru}','{$aktif}','{$user}','{$date}')";
if (!$database->query($sql)) {
die($sql);
} else {
$_SESSION['success'] = "<b>Berhasil!</b> Anda telah menambahkan data baru";
header("Location: create.php");
exit;
$rt = $form->input('rt');
$rw = $form->input('rw');
$kota = $form->input('kota');
$kecamatan = $form->input('kecamatan');
$desa = $form->input('desa');
$hp = $form->input('hp');
$telp_rumah = $form->input('telp_rumah');
$email = $form->input('email');
$jml_pengurus = $form->input('jml_pengurus');
$no_pemilih = $form->input('no_pemilih');
$action = $form->input('action');
$user = $_SESSION['nama'];
$date = date('Y-m-d H:i:s');
// START INSERT DATA ==============================>
if ($action == "insert") {
$id = $number->id('pengurus', 5);
$sql = "INSERT INTO pengurus\n (id, nama, no_ktp, no_kta, jabatan, tempat, tgl_lahir, jenis, alamat, rt, rw, kota, kecamatan,\n desa, hp, telp_rumah, email, jml_pengurus, no_pemilih, crt, crt_date) \n VALUES \n ('{$id}','{$nama}','{$no_ktp}','{$no_kta}','{$jabatan}','{$tempat}','{$tgl_lahir}','{$jenis}','{$alamat}','{$rt}','{$rw}',\n '{$kota}','{$kecamatan}','{$desa}','{$hp}','{$telp_rumah}','{$email}','{$jml_pengurus}','{$no_pemilih}','{$user}','{$date}')";
if (!$database->query($sql)) {
die($sql);
} else {
$_SESSION['success'] = "<b>Berhasil!</b> Anda telah menambahkan data baru";
header("Location: create.php");
exit;
}
}
// END INSERT DATA ==============================>
// START UPDATE DATA ==============================>
if ($action == "update") {
$sql = "UPDATE pengurus SET\n nama='{$nama}',no_ktp='{$no_ktp}',no_kta='{$no_kta}',jabatan='{$jabatan}',tempat='{$tempat}',\n tgl_lahir='{$tgl_lahir}',jenis='{$jenis}',alamat='{$alamat}',rt='{$rt}',rw='{$rw}',\n kota='{$kota}',kecamatan='{$kecamatan}',desa='{$desa}',hp='{$hp}',telp_rumah='{$telp_rumah}',\n email='{$email}',upd='{$user}',upd_date='{$date}',jml_pengurus='{$jml_pengurus}',no_pemilih='{$no_pemilih}'\n WHERE\n id='{$id}'";
if (!$database->query($sql)) {
die($sql);
<?php
include "../../libraries/start.php";
require $dir_libraries . "form.php";
$form = new form();
require $dir_libraries . "date.php";
$date = new date();
require $dir_libraries . "number.php";
$number = new number();
require $dir_libraries . "dropdown.php";
$dropdown = new dropdown();
$id = $number->id('absensi', '10', '');
$jam = date('H:i:s');
$jam_dtg1 = substr($jam, 0, 2);
$jam_dtg2 = substr($jam, 3, 2);
$jam_dtg3 = substr($jam, 6, 2);
$jam_plg1 = substr($jam, 0, 2);
$jam_plg2 = substr($jam, 3, 2);
$jam_plg3 = substr($jam, 6, 2);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php
include $dir_subviews . "bs_meta.php";
?>
<?php
include $dir_subviews . "bs_css.php";
?>
$form = new form();
require $dir_libraries . "number.php";
$number = new number();
if (isset($_POST['save'])) {
$nama = $form->input('nama');
$user_level_id = $form->input('user_level_id');
$aktif = $form->input('aktif');
$username = $form->input('username');
$tgl1 = $date->dateEnglishMinus($form->input('tgl1'));
$tgl2 = $date->dateEnglishMinus($form->input('tgl2'));
$action = $form->input('action');
$user = $_SESSION['nama'];
$datetime = date('Y-m-d H:i:s');
// START INSERT DATA ==============================>
if ($action == "insert") {
$id = $number->id('user_login', 5);
$sql = "INSERT INTO user_login\n (id, nama, user_level_id, aktif, username, password, tgl1, tgl2, crt, crt_date) \n VALUES \n ('{$id}','{$nama}','{$user_level_id}','{$aktif}','{$username}',PASSWORD('{$username}'),'{$tgl1}','{$tgl2}','{$user}','{$datetime}')";
if (!$database->query($sql)) {
die($sql);
} else {
$_SESSION['success'] = "<b>Berhasil!</b> Anda telah menambah data baru";
header("Location: create.php");
exit;
}
}
// END INSERT DATA ==============================>
// START UPDATE DATA ==============================>
if ($action == "update") {
$id = $form->input('id');
$password = $form->input('password');
$sql = "UPDATE user_login SET\n nama='{$nama}',user_level_id='{$user_level_id}',aktif='{$aktif}',username='******',password=PASSWORD('{$password}'),\n tgl1='{$tgl1}',tgl2='{$tgl2}',upd='{$user}',upd_date='{$datetime}'\n WHERE\n id='{$id}'";
<?php
include "../../libraries/start.php";
require $dir_libraries . "form.php";
$form = new form();
require $dir_libraries . "dropdown.php";
$dropdown = new dropdown();
require $dir_libraries . "number.php";
$number = new number();
$id = $number->id('pegawai', '3', '');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php
include $dir_subviews . "bs_meta.php";
?>
<?php
include $dir_subviews . "bs_css.php";
?>
</head>
<body>
<?php
include $dir_subviews . "menu.php";
?>
<?php
//include $dir_subviews."header.php";
?>
<?php
include "../../libraries/start.php";
require $dir_libraries . "form.php";
$form = new form();
require $dir_libraries . "number.php";
$number = new number();
require $dir_libraries . "dropdown.php";
$dropdown = new dropdown();
$id = $number->id('user_login', '3', '');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php
include $dir_subviews . "bs_meta.php";
?>
<?php
include $dir_subviews . "bs_css.php";
?>
</head>
<body>
<?php
include $dir_subviews . "menu.php";
?>
<?php
//include $dir_subviews."header.php";
?>
