public function login($username, $password)
{
$koneksi = new koneksi();
$koneksi->pilihkonekdb();
$koderole = '';
$sql = "select KD_USER, KD_ROLES from users where USERNAME='******' and PASSWORD='******'";
$search = mysql_query($sql);
$role = mysql_fetch_array($search);
// print_r($role);
while ($role) {
$kd_user = $role['KD_USER'];
$_SESSION['kduser'] = $kd_user;
$_SESSION['users'] = $username;
$_SESSION['pass'] = $password;
if ($role['KD_ROLES'] == 1) {
return $this->koderole = "admin";
}
if ($role['KD_ROLES'] == 2) {
return $this->koderole = "birojasa";
}
if ($role['KD_ROLES'] == 3) {
return $this->koderole = "majikan";
}
}
}
function tampil()
{
$dbase = new koneksi();
echo "<div class='tampil'>\n <form action='' name='TampilUser' method='get'>\n <table class='zebra-table'>\n <thead>\n <tr>\n <th><h2>No.</th>\n <th><h2>NIK</th>\n <th><h2>Nama Karyawan</th>\n <th><h2>Jenis Kelamin</th>\n <th><h2>Status</th>\n <th><h2>Jabatan</th>\n <th><h2>Email</th>\n <th><h2>Action</th>\n </tr>\n </thead>\n <tbody>";
$no = 1;
$data = $dbase->TampilUser();
foreach ($data as $r) {
echo "<tr>\n <td>{$no}</td>\n <td>{$r['nik']}</td>\n <td>{$r['name']}</td>\n <td>{$r['jenis_kelamin']}</td>\n <td>{$r['status']}</td>\n <td>{$r['jabatan']}</td>\n <td>{$r['email']}</td>\n <td><a href='hapusUser.php?id={$r['nik']}'>Hapus</a></td>\n </tr>";
$no++;
}
echo "</tbody>\n </table>\n </form>\n </div>\n </div>";
}
public function cek_login($usename, $password)
{
$koneksi = new koneksi();
$koneksi->pilihkonekdb();
$sql = mysql_query("select kd_user from auths where username='******' and password='******'");
$user_data = mysql_fetch_array($sql);
$no_rows = mysql_num_rows($result);
if ($no_rows == 1) {
$_SESSION['login'] = true;
$_SESSION['username'] = $user_data['username'];
return TRUE;
} else {
return FALSE;
}
}
<?php
session_start();
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Asia/Jakarta');
define('EOL', PHP_SAPI == 'cli' ? PHP_EOL : '<br \\>');
include "blob.php";
require_once "PHPExcel.php";
$data = new koneksi();
$objExcel = PHPExcel_IOFactory::load("../template-report/impor-add.xls");
$objWriter = new PHPExcel_Writer_Excel5($objExcel);
$objExcel->setActiveSheetIndex(1);
$startRow = 4;
if ($query = $data->runQuery("SELECT `id`,`rayon` FROM `rayon` WHERE `hapus` = '0'")) {
while ($rs = $query->fetch_array()) {
$objExcel->getActiveSheet()->SetCellValue('A' . $startRow, $rs['id']);
$objExcel->getActiveSheet()->SetCellValue('B' . $startRow, $rs['rayon']);
$startRow++;
}
}
$startRow = 4;
if ($query = $data->runQuery("SELECT `id`,`area` FROM `area` WHERE `hapus` = '0'")) {
while ($rs = $query->fetch_array()) {
$objExcel->getActiveSheet()->SetCellValue('G' . $startRow, $rs['id']);
$objExcel->getActiveSheet()->SetCellValue('H' . $startRow, $rs['area']);
$startRow++;
}
}
$objExcel->setActiveSheetIndex(0);
<script type="text/javascript" src="../jquery/load.js"></script>
<link href="../jquery/jquery-ui.css" rel="stylesheet" />
<script type="text/javascript" src="../jquery/jquery.js"></script>
<script type="text/javascript" src="../jquery/jquery-ui.js"></script>
<?php
include '../koneksi.php';
$dbase = new koneksi();
$id = $_GET['id'];
$w = $dbase->tampilUpdatePengadaan($id);
?>
<div class='menu'>
<form action='prosesPengadaan.php?action=update' method='POST' name='updateStatus'>
<table>
<tr>
<td><label>Kode Pengadaan</label></td>
<td><input type='text' name='kd_pengadaan' value='<?php
echo $w['kd_pengadaan'];
?>
'></td>
</tr>
<?php
$nik = $w['nik'];
$z = $dbase->showUser($nik);
foreach ($z as $v) {
?>
<tr>
<td><label>Nama Karyawan</label></td>
<td><input type='text' name='name' value='<?php
echo $v['name'];
?>
'></td>
<?php
$data = new koneksi();
?>
<section class="wrapper site-min-height">
<div class="row">
<div class="col-sm-12">
<section class="panel">
<header class="panel-heading">
Laporan Penjualan
<span class="tools pull-right">
<button data-toggle="modal" href="#mdl-kriteria" class="btn btn-primary btn-sm"><i class="fa fa-tint"></i> Kriteria</button>
</span>
</header>
<div class="panel-body">
<?php
if (isset($_POST['tgl-awal']) && $_POST['tgl-awal'] != "" && isset($_POST['tgl-akhir']) && $_POST['tgl-akhir'] != "" && isset($_POST['cmb-bank']) && $_POST['cmb-bank'] != "") {
?>
<div class="pull-right">
<button class="btn btn-default btn-sm" id="btn-print"><i class="fa fa-print"></i> Print</button>
</div>
<div id="print-section">
<div class="text-center"><h3>Laporan Penjualan <?php
echo $_POST['cmb-bank'] == "1" ? "PT. Energas Nusantara" : "PT. Sumber Gasindo Jaya";
?>
</h3></div><hr>
Periode : <?php
echo $_POST['tgl-awal'] . " s/d " . $_POST['tgl-akhir'];
?>
<br><br>
<table class="display table table-bordered table-striped" id="tabel-laporan">
<?php
//include 'class.kunjungan.php';
$data = new koneksi();
?>
<div class="container">
<div class="row">
<div class="col-md-3"></div>
<div class="col-md-6">
<h4 class="text-center">Laporan Timeline Pengerjaan</h4>
</div>
<div class="col-md-3">
<button data-toggle="modal" href='#modal_kriteria' class="btn btn-danger btn-sm btn-orange pull-right">Kriteria</button>
</div>
</div>
<hr>
<div class="row">
<div class="col-md-12 wadah">
<?php
if (isset($_POST['no_do']) && $_POST['no_do'] != "") {
?>
<div class="pull-right">
<button class="btn btn-default btn-sm" onclick="ngePrint();"><i class="fa fa-print"></i> print</button>
</div>
<table class="table-harian">
<tr>
<td><b>Nomor DO</b></td><td>: <?php
echo $_POST['no_do'];
?>
<?php
$data = new koneksi();
?>
<section class="wrapper site-min-height">
<div class="row">
<div class="col-sm-12">
<section class="panel">
<header class="panel-heading">
Laporan Pinjaman Tabung
<span class="tools pull-right">
<button data-toggle="modal" href="#mdl-kriteria" class="btn btn-primary btn-sm"><i class="fa fa-tint"></i> Kriteria</button>
</span>
</header>
<div class="panel-body">
<?php
if (isset($_POST['konsumen']) && $_POST['konsumen'] != "") {
?>
<div class="pull-right">
<button class="btn btn-default btn-sm" id="btn-print"><i class="fa fa-print"></i> Print</button>
</div>
<div id="print-section">
<div class="text-center"><h3>Laporan Pinjaman Tabung</h3></div><hr>
<table class="table table-hover table-striped table-mod">
<thead>
<tr>
<th class="text-center">ID</th>
<th class="text-center">Konsumen</th>
<th class="text-center">Barang</th>
<th class="text-center">Jumlah Pinjam</th>
<th class="text-center">Jenis Pinjaman</th>
<?php
session_start();
$ds = DIRECTORY_SEPARATOR;
if (!empty($_FILES)) {
include "../inc/blob.php";
$id = $_POST['id'];
$tempFile = $_FILES['file']['tmp_name'];
$targetPath = "../../assets/images/gedung/";
$temp = explode(".", $_FILES["file"]["name"]);
$newFileName = rand(1, 99999999) . '.' . end($temp);
$targetFile = $targetPath . $newFileName;
$koneksi = new koneksi();
if ($simpan = $koneksi->runQuery("UPDATE gedung SET img = '{$newFileName}' WHERE id = '{$id}'")) {
move_uploaded_file($tempFile, $targetFile);
}
}
<?php
if (isset($_POST['user']) && isset($_POST['password']) && isset($_POST['password2']) && $_POST['user'] != "" && $_POST['password'] != "" && $_POST['password2'] != "" && strlen($_POST['password']) > 3 && $_POST['password'] == $_POST['password2']) {
$data = new koneksi();
$user = e_code($_POST['user']);
$kunci = e_code($_POST['password']);
$id = d_code($_SESSION['media-data']);
if ($edit = $data->runQuery("UPDATE `pemakai` SET `user` = '{$user}' , `kunci` = '{$kunci}' WHERE `id` = '{$id}' ")) {
echo "<script> alert('data tersimpan.. silahkan login kembali !'); window.location = './login/'; </script>";
} else {
echo "<script> alert('Error..! Gagal menyimpan..'); </script>";
}
} else {
echo "<script> alert('Silahkan cek kembali..!'); </script>";
}
<script type="text/javascript" src="../jquery/load.js"></script>
<link rel="stylesheet" type="text/css" href="../desain/style.css" />
<?php
require '../koneksi.php';
$dbase = new koneksi();
/*require 'halaman.php';
$per_halaman = 20;
$new_halaman = new halaman();
$sql = "select * from tb_barang";
$jmldata = mysql_query($sql);
$jmlBaris = mysql_num_rows($jmldata);
$new_halaman->kelas_halaman($per_halaman);
$new_halaman->tentukan_total_baris($jmlBaris);
$awal_record = $new_halaman->peroleh_awal_record();
*/
echo "<font color='white'>";
$per_halaman = 15;
$halaman = isset($_GET['halaman']) ? $_GET['halaman'] : '';
if ($halaman == '') {
$awal_record = 0;
$halaman = 1;
} else {
$awal_record = ($halaman - 1) * $per_halaman;
}
echo "</font>";
?>
<?php
include '../koneksi.php';
$insert = new koneksi();
$action = $_GET['action'];
$nik = $_POST['nik'];
$tgl_pengajuan = $_POST['tgl_pengajuan'];
$nm_barang = $_POST['namaBarang'];
$jumlah = $_POST['jumlah'];
$ket = $_POST['ket'];
$kd_pengadaan = $_POST['kd_pengadaan'];
$status = $_POST['status'];
if ($action == 'insert') {
$status = 'on process';
$urut = mysql_query("SELECT * FROM tb_pengadaan");
$no_urut = mysql_num_rows($urut);
if ($no_urut <= 999) {
$no_urut++;
$digit = rand(00, 999);
$kd1 = substr($nik, 0, 3);
$kd2 = substr($tgl_pengajuan, 2, 2);
$kd_pengadaanInsert = $kd1 . $kd2 . $digit;
} else {
reset($no_urut);
}
$insert->reqBarang($nik, $kd_pengadaanInsert, $nm_barang, $jumlah, $tgl_pengajuan, $status, $ket);
header("location:mainUtama.php");
}
if ($action == 'update') {
$insert->updateStatusPengadaan($status, $kd_pengadaan);
header("location:mainUtama.php");
if ($result = $koneksi->runQuery($query)) {
$arr['status'] = TRUE;
$arr['msg'] = "Pendaftaran berhasil! Silahkan login untuk melanjutkan..";
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Pendaftaran gagal! Kesalahan pada sistem..";
}
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Harap isi data pendaftaran dengan lengkap..";
}
echo json_encode($arr);
break;
case "calendar-data":
include "../../admin/inc/blob.php";
$koneksi = new koneksi();
$events = array();
//Lihat dulu jumlah gedung yang ada
if ($result = $koneksi->runQuery("SELECT COUNT(id) FROM gedung WHERE hapus = '0'")) {
$rs = $result->fetch_array();
$jumlahGedung = $rs[0];
}
$jumlahGedung = $jumlahGedung * 2;
if ($result = $koneksi->runQuery("SELECT `booking`.`tgl`, COUNT(`booking`.`id`) FROM `booking` INNER JOIN `gedung` ON (`booking`.`id_gedung` = `gedung`.`id`) \n\t\t\t\tWHERE `booking`.`acc` <> '2' AND `gedung`.`hapus` = '0' GROUP BY `booking`.`tgl` ASC;")) {
while ($rs = $result->fetch_array()) {
$e = array();
$e['start'] = $rs['tgl'];
$e['end'] = $rs['tgl'];
$e['allDay'] = true;
if ($rs[1] == $jumlahGedung) {
$e['title'] = "Penuh";
<?php
include '../koneksi.php';
$insert = new koneksi();
$action = $_GET['action'];
$nik = $_POST['nik'];
$tgl_pinjam = $_POST['tgl_peminjaman'];
$kd_barang = $_POST['kd_barang'];
$ket = $_POST['ket'];
if ($action == 'insert') {
$urut = mysql_query("SELECT * FROM tb_peminjaman");
$no_urut = mysql_num_rows($urut);
if ($no_urut <= 999) {
$digit = rand(00, 999);
$kd1 = substr($kd_barang, 0, 3);
$kd2 = substr($tgl_pinjam, 2, 2);
$kd_pinjamInsert = $kd1 . $kd2 . $digit;
} else {
reset($no_urut);
}
$status = 'on process';
$insert->prosesPeminjaman($nik, $kd_pinjamInsert, $kd_barang, $tgl_pinjam, $status, $ket);
header("location:mainUtama.php");
}
if ($action == 'update') {
$kd_pinjam = $_POST['kd_pinjam'];
$stat = $_POST['status'];
$_SESSION['status'] = $stat;
if ($stat == 'dipinjam') {
$insert->updateStatusPeminjaman($_SESSION['status'], $kd_pinjam);
header("location:mainUtama.php");
<link href="../jquery/jquery-ui.css" rel="stylesheet" />
<script type="text/javascript" src="../jquery/jquery.js"></script>
<script type="text/javascript" src="../jquery/jquery-ui.js"></script>
<script type="text/javascript" src="../jquery/load.js"></script>
<?php
include '../koneksi.php';
$dbase = new koneksi();
$kode = $_GET['kode'];
$r = $dbase->tampilUpdatePinjam($kode);
?>
<div class="menu">
<form action='prosesPeminjaman.php?action=update' method='POST' name='updateStatus'>
<table>
<tr>
<td><label>Kode Peminjaman</label></td>
<td><input type='text' name='kd_pinjam' value='<?php
echo $r['kd_pinjam'];
?>
'></td>
</tr>
<tr>
<td><label>NIK</label></td>
<td><input type='text' name='nik' value='<?php
echo $r['nik'];
?>
'></td>
</tr>
<?php
$nik = $r['nik'];
$w = $dbase->showUser($nik);
foreach ($w as $v) {
<?php $data = new koneksi(); ?> <section class="wrapper site-min-height"> <div class="row"> <div class="col-sm-12"> <section class="panel"> <header class="panel-heading"> Data Kategori <span class="tools pull-right"> <button type="button" class="btn btn-primary btn-sm" id="btn-tambah-data" data-mode="tambah"><i class="fa fa-plus"></i> Tambah Data</button> </span> </header> <div class="panel-body"> <div class="adv-table"> <table class="display table table-bordered table-striped" id="tabel-kategori"> <thead> <tr> <th>Menu</th> <th>Nama</th> <th>Summary</th> <th></th> </tr> </thead> <tbody> </tbody> <tfoot> <tr> <th>Menu</th>
<?php
session_start();
$ds = DIRECTORY_SEPARATOR;
if (!empty($_FILES)) {
include "../../admin/inc/blob.php";
$id = $_POST['id'];
$tempFile = $_FILES['file']['tmp_name'];
$targetPath = "../images/bukti-bayar/";
$temp = explode(".", $_FILES["file"]["name"]);
$newFileName = rand(1, 99999999) . '.' . end($temp);
$targetFile = $targetPath . $newFileName;
$koneksi = new koneksi();
if ($simpan = $koneksi->runQuery("UPDATE konfirmasi SET img = '{$newFileName}' WHERE id_booking = '{$id}'")) {
move_uploaded_file($tempFile, $targetFile);
}
}
<?php
session_start();
if (isset($_POST['apa']) && $_POST['apa'] != "") {
switch ($_POST['apa']) {
case "logout":
$arr = array();
session_destroy();
$arr['status'] = TRUE;
echo json_encode($arr);
break;
case "calendar-data":
include "../inc/blob.php";
$koneksi = new koneksi();
$events = array();
$idCatering = $_SESSION['majt-admin-id-catering'];
if ($result = $koneksi->runQuery("SELECT tgl FROM jadwal_catering WHERE id_catering = '{$idCatering}'")) {
while ($rs = $result->fetch_array()) {
$e = array();
$e['start'] = $rs['tgl'];
$e['end'] = $rs['tgl'];
$e['allDay'] = true;
$qKet = "SELECT `booking`.`tgl`, `gedung`.`nama`, `booking`.`waktu` FROM `booking_catering` \n\t\t\t\t\t\t\t\tINNER JOIN `booking` ON (`booking_catering`.`id_booking` = `booking`.`id`) \n\t\t\t\t\t\t\t\tINNER JOIN `gedung` ON (`booking`.`id_gedung` = `gedung`.`id`) WHERE `booking_catering`.`id_catering` = '{$idCatering}';";
if ($resCek = $koneksi->runQuery($qKet)) {
if ($resCek->num_rows > 0) {
$rsCek = $resCek->fetch_array();
$waktu = $rsCek["waktu"] == "1" ? "Siang" : "Malam";
$e['title'] = $rsCek["nama"] . " " . $waktu;
} else {
$e['title'] = "";
}
<?php
include '../koneksi.php';
$user = new koneksi();
$action = $_GET['action'];
if ($action == 'insert') {
$nik = $_POST['nik'];
$nama_karyawan = $_POST['nama_karyawan'];
$jenis_kelamin = $_POST['jk'];
$password = md5($_POST['password']);
$status = $_POST['status'];
$jabatan = $_POST['jabatan'];
$email = $_POST['email'];
$user->insertUser($nik, $nama_karyawan, $jenis_kelamin, $password, $status, $jabatan, $email);
header("location:mainUtama.php");
}
<script type="text/javascript" src="../jquery/load.js"></script>
<?php
include '../excel/excel_reader2.php';
include '../koneksi.php';
$dbase = new koneksi();
$data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']);
$baris = $data->rowcount($sheet_index = 0);
$sukses = 0;
$gagal = 0;
for ($i = 2; $i <= $baris; $i++) {
$kd_barang = $data->val($i, 2);
$nm_barang = $data->val($i, 3);
$merk = $data->val($i, 4);
$tipe_barang = $data->val($i, 5);
$tgl_pembelian = $data->val($i, 6);
$harga_barang = $data->val($i, 7);
$status = $data->val($i, 8);
$ket = $data->val($i, 9);
$hasil = $dbase->insertBarang($kd_barang, $nm_barang, $merk, $tipe_barang, $tgl_pembelian, $harga_barang, $status, $ket);
if ($hasil) {
$sukses++;
} else {
$gagal++;
}
if ($i == $baris) {
header("location:it.php");
echo "<div id='loading'><h3> Proses Import Data Pegawai Selesai</h3>";
echo "<p>Jumlah data sukses diimport : " . $sukses . "<br>";
echo "Jumlah data gagal diimport : " . $gagal . "<p></div>";
}
}
<?php
session_start();
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Asia/Jakarta');
define('EOL', PHP_SAPI == 'cli' ? PHP_EOL : '<br \\>');
include "blob.php";
require_once "PHPExcel.php";
$data = new koneksi();
$ds = DIRECTORY_SEPARATOR;
if (!empty($_FILES)) {
$tempFile = $_FILES['file']['tmp_name'];
$targetPath = "../template-report/";
$temp = explode(".", $_FILES["file"]["name"]);
$newFileName = rand(1, 99999999) . '.' . end($temp);
$targetFile = $targetPath . $newFileName;
move_uploaded_file($tempFile, $targetFile);
$objReader = new PHPExcel_Reader_Excel5();
$objReader->setReadDataOnly(true);
$objExcel = $objReader->load("../template-report/" . $newFileName);
$objExcel->setActiveSheetIndex(0);
$highestRow = $objExcel->setActiveSheetIndex(0)->getHighestRow();
for ($row = 7; $row <= $highestRow; $row++) {
$noreg = $objExcel->getSheet(0)->getCell('A' . $row)->getValue();
$nama = $objExcel->getSheet(0)->getCell('B' . $row)->getValue();
$alamat = $objExcel->getSheet(0)->getCell('C' . $row)->getValue();
$rayon = $objExcel->getSheet(0)->getCell('D' . $row)->getValue();
$pasar = $objExcel->getSheet(0)->getCell('E' . $row)->getValue();
$subpasar = $objExcel->getSheet(0)->getCell('F' . $row)->getValue();
<?php $data = new koneksi(); ?> <!DOCTYPE html> <html lang="en-US"> <head> <!-- Basic Page Head --> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Welcome to Home Decor Furniture & Interior Design Official Site</title> <meta name="description" content="Home Decor Furniture & Interior Official Site"> <meta name="author" content="FuzzyTech IT Solution"> <meta name="keywords" content="furniture, interior, interior design, home decor, homedecor, home decor indo, homedecorindo, semarang, indonesia"> <!-- Mobile Meta --> <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no"> <!-- Favicons --> <link rel="shortcut icon" type="image/x-icon" href="assets/img/favicon.ico"> <link rel="apple-touch-icon-precomposed" href="assets/img/apple-touch-icon-precomposed.png"> <link rel="apple-touch-icon-precomposed" sizes="72x72" href="assets/img/apple-touch-icon-72x72-precomposed.png"> <link rel="apple-touch-icon-precomposed" sizes="114x114" href="assets/img/apple-touch-icon-114x114-precomposed.png"> <link rel="apple-touch-icon-precomposed" sizes="144x144" href="assets/img/apple-touch-icon-144x144-precomposed.png"> <!-- Css --> <link rel="stylesheet" type="text/css" href="assets/css/bootstrap.min.css"> <link rel="stylesheet" type="text/css" href="assets/css/font-awesome.min.css"> <link rel="stylesheet" type="text/css" href="assets/css/prettyPhoto.css"> <link rel="stylesheet" type="text/css" href="assets/css/owl.carousel.css"> <link rel="stylesheet" type="text/css" href="assets/css/owl.theme.css">
<?php
$data = new koneksi();
?>
<section class="wrapper site-min-height">
<div class="row">
<div class="col-sm-12">
<section class="panel">
<header class="panel-heading">
Laporan Penebusan Khusus
<span class="tools pull-right">
<button data-toggle="modal" href="#mdl-kriteria" class="btn btn-primary btn-sm"><i class="fa fa-tint"></i> Kriteria</button>
</span>
</header>
<div class="panel-body">
<?php
if (isset($_POST['tgl-awal']) && $_POST['tgl-awal'] != "" && isset($_POST['tgl-akhir']) && $_POST['tgl-akhir'] != "" && isset($_POST['cmb-bank']) && $_POST['cmb-bank'] != "") {
?>
<div class="pull-right">
<button class="btn btn-default btn-sm" id="btn-print"><i class="fa fa-print"></i> Print</button>
</div>
<div id="print-section">
<div class="text-center"><h3>Laporan Tebus Khusus</h3></div><hr>
Periode : <?php
echo $_POST['tgl-awal'] . " s/d " . $_POST['tgl-akhir'];
?>
<br><br>
<table class="table table-hover table-striped table-mod">
<thead>
<tr>
<th class="text-center">ID</th>
<?php
$data = new koneksi();
?>
<section class="wrapper site-min-height">
<div class="row">
<div class="col-sm-12">
<section class="panel">
<header class="panel-heading">
Laporan Penebusan
<span class="tools pull-right">
<button data-toggle="modal" href="#mdl-kriteria" class="btn btn-primary btn-sm"><i class="fa fa-tint"></i> Kriteria</button>
</span>
</header>
<div class="panel-body">
<?php
if (isset($_POST['tgl-awal']) && $_POST['tgl-awal'] != "" && isset($_POST['tgl-akhir']) && $_POST['tgl-akhir'] != "" && isset($_POST['cmb-bank']) && $_POST['cmb-bank'] != "" && isset($_POST['cmb-barang']) && $_POST['cmb-barang'] != "") {
?>
<div class="pull-right">
<button class="btn btn-default btn-sm" id="btn-print"><i class="fa fa-print"></i> Print</button>
</div>
<div id="print-section">
<div class="text-center"><h3>Laporan Tebus <?php
echo $_POST['cmb-bank'] == "1" ? "PT. Energas Nusantara" : "PT. Sumber Gasindo Jaya";
?>
</h3></div><hr>
Periode : <?php
echo $_POST['tgl-awal'] . " s/d " . $_POST['tgl-akhir'];
?>
<br><br>
<table class="display table table-bordered table-striped" id="tabel-laporan">
<?php
session_start();
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Asia/Jakarta');
define('EOL', PHP_SAPI == 'cli' ? PHP_EOL : '<br \\>');
include "../../blob/blob.php";
require_once "../../ext/PHPExcel.php";
$data = new koneksi();
$objExcel = PHPExcel_IOFactory::load("../../ext/format-impor-alokasi.xls");
$objWriter = new PHPExcel_Writer_Excel5($objExcel);
$objExcel->setActiveSheetIndex(1);
$startRow = 4;
if ($query = $data->runQuery("SELECT `id`,`nama` FROM `konsumen` WHERE `pangkalan` = '1' AND `hapus` = '0'")) {
while ($rs = $query->fetch_array()) {
$objExcel->getActiveSheet()->SetCellValue('A' . $startRow, $rs['id']);
$objExcel->getActiveSheet()->SetCellValue('B' . $startRow, $rs['nama']);
$startRow++;
}
}
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename="format-impor-alokasi.xls"');
$objWriter->save('php://output');
function cek_login($user, $pass)
{
$koneksi = new koneksi();
$user = e_code($user);
$pass = e_code($pass);
$qCek = "SELECT `pemakai`.`id`, `pemakai`.`nama`, `pemakai`.`jk` FROM `pemakai` WHERE `pemakai`.`user` = '{$user}' AND `pemakai`.`kunci` = '{$pass}' AND `pemakai`.`hapus` = '0';";
if ($resCek = $koneksi->runQuery($qCek)) {
if ($resCek->num_rows > 0) {
$rsCek = $resCek->fetch_array();
$_SESSION['en-data'] = e_code($rsCek['id']);
$_SESSION['en-nama'] = $rsCek['nama'];
$_SESSION['en-jk'] = $rsCek['jk'];
$log = $koneksi->runQuery("INSERT INTO `log_login`(`id_user`) VALUES ('" . $rsCek['id'] . "')");
return TRUE;
} else {
return FALSE;
}
} else {
return FALSE;
}
}
<?php $data = new koneksi(); ?> <section class="wrapper site-min-height"> <div class="row"> <div class="col-lg-12"> <section class="panel"> <header class="panel-heading"> Peminjaman Tabung </header> <div class="panel-body"> <div class="row"> <div class="col-lg-4"> <section class="panel"> <form class="form-horizontal tasi-form"> <div class="form-group"> <label class="col-sm-4 col-sm-4 control-label">Tgl Pinjam</label> <div class="col-sm-8"> <input type="text" class="form-control" id="dp-tgl-pinjam"> </div> </div> </form> </section> </div> <div class="col-lg-8"> <section class="panel"> <form class="form-horizontal tasi-form"> <div class="form-group"> <label class="col-sm-2 col-sm-2 control-label">Konsumen</label> <div class="col-sm-10">
<?php
session_start();
$ds = DIRECTORY_SEPARATOR;
if (!empty($_FILES)) {
include 'blob.php';
$id = $_POST['id'];
$tempFile = $_FILES['file']['tmp_name'];
$targetPath = "../img/";
$temp = explode(".", $_FILES["file"]["name"]);
$newFileName = rand(1, 99999999) . '.' . end($temp);
$targetFile = $targetPath . $newFileName;
$koneksi = new koneksi();
if ($cek = $koneksi->runQuery("SELECT ttd FROM karyawan WHERE id = '{$id}'")) {
while ($rs = $cek->fetch_array()) {
if ($rs['ttd'] != null) {
if (file_exists("../img/" . $rs['ttd'])) {
unlink("../img/" . $rs['ttd']);
}
}
}
}
if ($simpan = $koneksi->runQuery("UPDATE karyawan SET ttd = '{$newFileName}' WHERE id = '{$id}'")) {
move_uploaded_file($tempFile, $targetFile);
}
}
<?php
include '../koneksi.php';
$user = new koneksi();
$user->deleteUser($_GET['id']);
header("location:admin.php");
function cek_login($user, $pass)
{
$koneksi = new koneksi();
$user = e_code($user);
$pass = e_code($pass);
if ($hmm = $koneksi->runQuery("SELECT `pemakai`.`id`,`pemakai`.`user`,`pemakai`.`kunci`,`pemakai`.`status`, `karyawan`.`nama` , `karyawan`.`id` as `id_kar`, `karyawan`.`level`, `karyawan`.`area`, `area`.`area` AS `nama_area` FROM `pemakai` INNER JOIN `karyawan` ON `karyawan`.`id` = `pemakai`.`id_karyawan` INNER JOIN `area` ON `karyawan`.`area` = `area`.`id` WHERE `pemakai`.`user`='{$user}' && `pemakai`.`kunci`='{$pass}' ")) {
if ($hmm->num_rows > 0) {
$rs = $hmm->fetch_array();
if ($rs['status'] != e_code('99')) {
$log = $koneksi->runQuery("INSERT INTO `log_login`(`id_user`,`time`) VALUES ('" . $rs['id'] . "', '" . date("Y-m-d H:i:s") . "')");
}
$_SESSION['media-data'] = e_code($rs['id']);
$_SESSION['media-nama'] = $rs['nama'];
$_SESSION['media-status'] = $rs['status'];
if (is_null($rs['id_kar'])) {
$_SESSION['media-id'] = "%";
$_SESSION['media-level'] = "%";
$_SESSION['media-area'] = "%";
$_SESSION['media-namaarea'] = "%";
} else {
$_SESSION['media-id'] = $rs['id_kar'];
$_SESSION['media-level'] = $rs['level'];
$_SESSION['media-area'] = $rs['area'];
$_SESSION['media-namaarea'] = $rs['nama_area'];
}
return TRUE;
} else {
return FALSE;
}
} else {
return FALSE;
}
}
