<?php
include "modules/blob/blob.php";
$koneksi = new koneksi();
$simpan = $koneksi->runQuery("UPDATE `kuota_penjualan` SET `jml_alokasi` = '0' WHERE `tgl` < NOW();");
<th class="text-center">Hrg Stn</th>
<th class="text-center">Total Bayar</th>
<th class="text-center">Jenis</th>
<th class="text-center">Bukti</th>
</tr>
</thead>
<tbody>
<?php
if ($_POST['cmb-bank'] == "1") {
//energas
$query = "SELECT `penjualan`.*, `barang`.`nama` AS `nama_barang`, `konsumen`.`nama` AS `nama_konsumen`, \n\t\t\t\t\t\t\t\t\t\t`penjualan`.`id` \n\t\t\t\t\t\t\t\t\t\tFROM `penjualan` \n\t\t\t\t\t\t\t\t\t\tINNER JOIN `barang` ON (`penjualan`.`id_barang` = `barang`.`id`) \n\t\t\t\t\t\t\t\t\t\tINNER JOIN `konsumen` ON (`penjualan`.`id_konsumen` = `konsumen`.`id`) \n\t\t\t\t\t\t\t\t\t\tWHERE `penjualan`.`id_bank` = '1' \n\t\t\t\t\t\t\t\t\t\tAND `penjualan`.`id_konsumen` LIKE '" . $_POST['cmb-konsumen'] . "' \n\t\t\t\t\t\t\t\t\t\tAND `penjualan`.`jenis` LIKE '" . $_POST['cmb-jenis'] . "' \n\t\t\t\t\t\t\t\t\t\tAND `penjualan`.`tgl` BETWEEN '" . $_POST['tgl-awal'] . "' AND '" . $_POST['tgl-akhir'] . "';";
} else {
//gasindo
$query = "SELECT `penjualan`.*, `barang`.`nama` AS `nama_barang`, `konsumen`.`nama` AS `nama_konsumen`, \n\t\t\t\t\t\t\t\t\t\t`penjualan`.`id` \n\t\t\t\t\t\t\t\t\t\tFROM `penjualan` \n\t\t\t\t\t\t\t\t\t\tINNER JOIN `barang` ON (`penjualan`.`id_barang` = `barang`.`id`) \n\t\t\t\t\t\t\t\t\t\tINNER JOIN `konsumen` ON (`penjualan`.`id_konsumen` = `konsumen`.`id`) \n\t\t\t\t\t\t\t\t\t\tWHERE (`penjualan`.`id_bank` = '2' OR `penjualan`.`id_bank` = '0') \n\t\t\t\t\t\t\t\t\t\tAND `penjualan`.`id_konsumen` LIKE '" . $_POST['cmb-konsumen'] . "' \n\t\t\t\t\t\t\t\t\t\tAND `penjualan`.`jenis` LIKE '" . $_POST['cmb-jenis'] . "' \n\t\t\t\t\t\t\t\t\t\tAND `penjualan`.`tgl` BETWEEN '" . $_POST['tgl-awal'] . "' AND '" . $_POST['tgl-akhir'] . "';";
}
if ($daftar = $data->runQuery($query)) {
while ($rs = $daftar->fetch_assoc()) {
if ($rs['jenis'] == "1") {
$jenis = "Cash";
$tglTempo = "-";
$tglLunas = $rs['tgl'];
} elseif ($rs['jenis'] == "2") {
$jenis = "Debet";
$tglTempo = "-";
$tglLunas = $rs['tgl'];
} elseif ($rs['jenis'] == "3") {
$jenis = "Transfer";
$tglTempo = "-";
$tglLunas = $rs['tgl'];
} else {
$jenis = "Tempo";
<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">
<select class="form-control" id="cmb-konsumen" name="cmb-konsumen">
<?php
if ($query = $data->runQuery("SELECT `id`, `nama` FROM `konsumen` WHERE hapus = '0'")) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . "</option>";
}
}
?>
</select>
</div>
</div>
</form>
</section>
</div>
</div>
<div class="row">
<div class="col-lg-4">
<section class="panel">
<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>
<th class="text-center">Tgl Pinjam</th>
<th class="text-center">Tgl Kembali</th>
</tr>
</thead>
<tbody>
<?php
$query = "SELECT `pinjaman_tabung`.*, `konsumen`.`nama` AS `nama_konsumen`, `barang`.`nama` AS `nama_barang` \n\t\t\t\t\t\t\t\t\tFROM `pinjaman_tabung` \n\t\t\t\t\t\t\t\t\tINNER JOIN `konsumen` ON (`pinjaman_tabung`.`id_konsumen` = `konsumen`.`id`) \n\t\t\t\t\t\t\t\t\tINNER JOIN `barang` ON (`pinjaman_tabung`.`id_barang` = `barang`.`id`) \n\t\t\t\t\t\t\t\t\tWHERE `pinjaman_tabung`.`id_konsumen` LIKE '" . $_POST['konsumen'] . "';";
$totalPinjam = 0;
if ($daftar = $data->runQuery($query)) {
while ($rs = $daftar->fetch_assoc()) {
$totalPinjam += $rs['jml_pinjam'];
$jenis = $rs['jenis_pinjaman'] == "1" ? "Permanen" : "Sementara";
echo "<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['id'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['nama_konsumen'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['nama_barang'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . number_format($rs['jml_pinjam'], 0, ",", ".") . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $jenis . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['tgl_pinjam'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['tgl_kembali'] . "</td>";
echo "</tr>";
}
}
?>
<tr>
<td colspan="3"><strong>Total Pinjaman</strong></td>
<td class="text-center"><?php
echo number_format($totalPinjam, 0, ",", ".");
?>
</td>
<td></td>
<th class="text-center">Input DO</th>
<th class="text-center">Acc DO</th>
<th class="text-center">No PO</th>
<th class="text-center">Input PO</th>
<th class="text-center">Acc PO</th>
<th class="text-center">Kirim</th>
<th class="text-center">Realisasi</th>
<th class="text-center">Distribusi</th>
<th class="text-center">Terima</th>
<th class="text-center">Durasi</th>
</tr>
</thead>
<tbody>
<?php
$query = "SELECT `po_detail`.`id` AS `id_detail_po`, `do_detail`.`deskripsi`, `ukuran`.`panjang`, `ukuran`.`lebar`, `ukuran`.`pre`, `do_detail`.`jml`, \n\t\t\t\t\t\t\t`do`.`tgl_do`, `do`.`tgl_acc` AS `tgl_acc_do` , `po`.`no_po`, `po`.`tgl_po` AS `tgl_po`, `po`.`tgl_acc` AS `tgl_acc_po`, `po`.`tgl_kirim_ke_supplier`, \n\t\t\t\t\t\t\t`po_detail`.`tgl_kirim`, `po_detail`.`tgl_kirim_ke_sales` FROM `do_detail` INNER JOIN `do` ON (`do_detail`.`id_do` = `do`.`id`) INNER JOIN `po_detail` \n\t\t\t\t\t\t\tON (`po_detail`.`id_do_detail` = `do_detail`.`id`) INNER JOIN `tema_layar` ON (`do_detail`.`id_tema_layar` = `tema_layar`.`id`) \n\t\t\t\t\t\t\tINNER JOIN `ukuran` ON (`do_detail`.`id_ukuran` = `ukuran`.`id`) INNER JOIN `po` ON (`po_detail`.`id_po` = `po`.`id`) WHERE \n\t\t\t\t\t\t\t`do`.`no` = '" . $_POST['no_do'] . "';";
if ($daftar = $data->runQuery($query)) {
while ($rs = $daftar->fetch_assoc()) {
$qRealisasi = "SELECT MAX(`tgl`) FROM `realisasi_po` WHERE `id_detail_po` = '" . $rs['id_detail_po'] . "';";
if ($resultRealisasi = $data->runQuery($qRealisasi)) {
$rsRealisasi = $resultRealisasi->fetch_array();
if ($rsRealisasi[0] == null) {
$tglRealisasi = "00-00-00";
} else {
$tglRealisasi = date("d-m-y", strtotime($rsRealisasi[0]));
}
}
$tgldo = $rs['tgl_do'] != "0000-00-00" ? date("d-m-y", strtotime($rs['tgl_do'])) : "00-00-00";
$tglaccdo = $rs['tgl_acc_do'] != "0000-00-00" ? date("d-m-y", strtotime($rs['tgl_acc_do'])) : "00-00-00";
$tglpo = $rs['tgl_po'] != "0000-00-00" ? date("d-m-y", strtotime($rs['tgl_po'])) : "00-00-00";
$tglaccpo = $rs['tgl_acc_po'] != "0000-00-00" ? date("d-m-y", strtotime($rs['tgl_acc_po'])) : "00-00-00";
$tglkesup = $rs['tgl_kirim_ke_supplier'] != "0000-00-00" ? date("d-m-y", strtotime($rs['tgl_kirim_ke_supplier'])) : "00-00-00";
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;
}
}
<?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);
}
}
<div class="mail-box">
<aside class="sm-side">
<div class="user-head">
<a href="javascript:;" class="inbox-avatar"></a>
<div class="user-name">
<h5><?php
echo $_SESSION['en-nama'];
?>
</h5>
</div>
</div>
<ul class="nav nav-pills nav-stacked labels-info inbox-divider" id="daftar-berita">
<li> <h4>Berita Acara Terbaru</h4> </li>
<?php
$query = "SELECT `berita_acara`.*, `karyawan`.`nama` FROM `berita_acara` \n\t\t\t\t\tINNER JOIN `karyawan` ON (`berita_acara`.`id_karyawan` = `karyawan`.`id`) WHERE `berita_acara`.`hapus` = '0'\n\t\t\t\t\tORDER BY `tgl`,`jam` DESC LIMIT 20;";
if ($result = $data->runQuery($query)) {
if ($result->num_rows > 0) {
while ($rs = $result->fetch_array()) {
echo "<li id='item-berita' data-id='" . $rs['id'] . "' data-tgl='" . $rs['tgl'] . "' data-jam='" . $rs['jam'] . "' \n\t\t\t\t\t\t\t\tdata-judul='" . $rs['judul'] . "' data-isi='" . $rs['isi'] . "' data-nama='" . $rs['nama'] . "'>\n\t\t\t\t\t\t\t\t<a href='#'><i class='fa fa-sign-blank text-danger'></i> " . $rs['nama'] . "</a></li>";
}
} else {
echo "<li><a href='#'><i class='fa fa-sign-blank text-danger'></i> Tidak ada item baru</a></li>";
}
}
?>
</ul>
</aside>
<aside class="lg-side">
<div class="inbox-head">
<h3>View Berita Acara</h3>
</div>
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 = 2; $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();
$pasar = $objExcel->getSheet(0)->getCell('D' . $row)->getValue();
$subpasar = $objExcel->getSheet(0)->getCell('E' . $row)->getValue();
$query = $data->runQuery("UPDATE `pelanggan` SET `nama` = '{$nama}', `alamat` = '{$alamat}', `pasar` = '{$pasar}', \n\t\t\t\t`sub_pasar` = '{$subpasar}' WHERE `noreg` = '{$noreg}';");
}
$objExcel->disconnectWorksheets();
unset($objExcel);
unlink($targetFile);
}
<?php
include '../inc/blob.php';
header("Content-Type: application/json; charset=UTF-8");
header("Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept");
header("Access-Control-Allow-Origin: * ");
header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS");
$postdata = json_decode(file_get_contents("php://input"), TRUE);
$data = new koneksi();
$text = "";
$arr = array();
if ($cek_token = $data->runQuery("SELECT `karyawan`.`id`,`karyawan`.`nama` FROM `karyawan` INNER JOIN `pin` ON `pin`.`id_karyawan`=`karyawan`.`id` WHERE `pin`.`id_karyawan`='" . $postdata['token'] . "' ")) {
if ($cek_token->num_rows > 0) {
$rs_spv = $cek_token->fetch_assoc();
$text .= "Spv: " . $rs_spv['nama'];
$arr['id_karyawan'] = $rs_spv['id'];
if ($cek_barcode = $data->runQuery("SELECT `id`,`nama` FROM `pelanggan` WHERE `barcode`='" . $postdata['barcode'] . "' ")) {
$rs_pelanggan = $cek_barcode->fetch_assoc();
$text .= " | Pelanggan : " . $rs_pelanggan['nama'];
$arr['id_pelanggan'] = $rs_pelanggan['id'];
if ($rec = $data->runQuery("INSERT INTO `visit` (`barcode`,`latitude`,`longitude`,`id_pelanggan`,`id_karyawan`) \n\t\t\t\tVALUES ('" . $postdata['barcode'] . "', '" . $postdata['latitude'] . "', '" . $postdata['longitude'] . "', '" . $arr['id_pelanggan'] . "', '" . $arr['id_karyawan'] . "') ")) {
//$text .=" [ ";
$id_visit = $data->lastInsertID();
$qry = "INSERT INTO `visit_detail`(`id_visit`,`id_jenis_pekerjaan`) VALUES ";
if ($postdata['tagih']) {
$qry .= " ('{$id_visit}','1') ,";
//$text.=" Tagih ,";
}
if ($postdata['kirim']) {
$qry .= " ('{$id_visit}','2') ,";
//$text.=" Kirim Barang ,";
<div class="modal fade " id="mdl-data-spbe" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title">Data Barang SPBE</h4>
</div>
<div class="modal-body">
<form id="frm-spbe" action="#" method="POST" role="form">
<input type="hidden" class="form-control" id="apa" name="apa">
<input type="hidden" class="form-control" id="txt-id" name="txt-id">
<div class="form-group">
<select class="form-control" id="cmb-spbe" name="cmb-spbe">
<?php
if ($query = $data->runQuery("SELECT `id`, `nama` FROM `spbe` WHERE `hapus` = '0';")) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . "</option>";
}
}
?>
</select>
</div>
<div class="form-group">
<select class="form-control" id="cmb-barang" name="cmb-barang">
<?php
if ($query = $data->runQuery("SELECT `id`, `nama` FROM `barang`;")) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . "</option>";
}
}
function cek_login($user, $pass)
{
$koneksi = new koneksi();
$user = e_code($user);
$pass = e_code($pass);
$qCek = "SELECT `pemakai`.`id`, `pemakai`.`id_karyawan`, `karyawan`.`nama`, `karyawan`.`id_level`, `karyawan`.`jk` FROM `pemakai` INNER JOIN `karyawan` \n\t\t\tON (`pemakai`.`id_karyawan` = `karyawan`.`id`) 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_karyawan']);
$_SESSION['en-nama'] = $rsCek['nama'];
$_SESSION['en-level'] = $rsCek['id_level'];
$_SESSION['en-jk'] = $rsCek['jk'];
$qLog = "INSERT INTO `log_login`(`id_user`) VALUES ('" . $rsCek['id'] . "');";
$qLog .= "UPDATE `kuota_penjualan` SET `jml_alokasi` = 0 WHERE `tgl` < '" . date("Y-m-d") . "';";
$log = $koneksi->runMultipleQueries($qLog);
return TRUE;
} else {
return FALSE;
}
} else {
return FALSE;
}
}
?>
<section class="wrapper site-min-height">
<div class="row">
<div class="col-lg-12">
<section class="panel">
<header class="panel-heading">
Pelunasan Khusus
</header>
<div class="panel-body">
<div class="row">
<div class="col-lg-2">
<section class="panel">
<div class="input-group input-large">
<select class="form-control" id="cmb-konsumen">
<?php
if ($result = $data->runQuery("SELECT id, nama FROM konsumen WHERE hapus = '0'")) {
while ($rs = $result->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . "</option>";
}
}
?>
</select>
</div>
</section>
</div>
<div class="col-lg-4">
<section class="panel">
<button type="button" class="btn btn-primary" id="btn-cari"><i class="fa fa-search"></i> Cari</button>
</section>
</div>
</div>
<input type="text" class="form-control rupiah-bulat" name="txt-total"
id="txt-total">
</div>
</div>
</div>
</form>
</section>
</div>
</div>
<hr>
<div class="row">
<div class="col-lg-4">
<section class="panel">
<select class="form-control" id="cmb-bank" name="cmb-bank">
<?php
if ($result = $data->runQuery("SELECT * FROM khusus_bank WHERE hapus = '0';")) {
while ($rs = $result->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . " " . $rs['nomor_rekening'] . "</option>";
}
}
?>
</select>
</section>
</div>
<div class="col-lg-4">
<section class="panel">
<select class="form-control" id="cmb-jenis" name="cmb-jenis">
<option value="1">Tarikan Tunai</option>
<option value="2">KlikBCA</option>
</select>
</section>
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;
}
}
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title">Loading Keluar</h4>
</div>
<div class="modal-body">
<form id="frm-loading-out" action="#" method="POST" role="form">
<input type="hidden" class="form-control" name="apa" id="apa" value="simpan-loading-out">
<div class="form-group">
<input type="text" class="form-control" id="dp-tgl-loading" name="dp-tgl-loading" placeholder="Tanggal Loading">
</div>
<div class="form-group">
<select class="form-control" id="cmb-kendaraan" name="cmb-kendaraan">
<?php
if ($result = $data->runQuery("SELECT * FROM kendaraan WHERE hapus = '0';")) {
while ($rs = $result->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nopol'] . " " . $rs['keterangan'] . "</option>";
}
}
?>
</select>
</div>
<div class="form-group">
<select class="form-control" id="cmb-driver" name="cmb-driver">
<?php
if ($result = $data->runQuery("SELECT `karyawan`.`id`, `karyawan`.`nama`, `level`.`jabatan`, `karyawan`.`jk` \n\t\t\t\t\t\t\tFROM `karyawan` INNER JOIN `level` ON (`karyawan`.`id_level` = `level`.`id`) WHERE `karyawan`.`id_level` = '3' \n\t\t\t\t\t\t\tAND `karyawan`.`hapus` = '0';")) {
while ($rs = $result->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . "</option>";
}
}
<?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
session_start();
if (isset($_POST['apa']) && $_POST['apa'] != "") {
switch ($_POST['apa']) {
case "cek-login":
include "../inc/blob.php";
$arr = array();
if (isset($_POST['user']) && $_POST['user'] != "" && isset($_POST['pass']) && $_POST['pass'] != "" && isset($_POST['hak']) && $_POST['hak'] != "") {
$user = $_POST['user'];
$pass = $_POST['pass'];
$hak = $_POST['hak'];
$koneksi = new koneksi();
if ($result = $koneksi->runQuery("SELECT * FROM user WHERE username = '******' AND password = '******' AND privilege = '{$hak}'")) {
if ($result->num_rows > 0) {
$rs = $result->fetch_array();
$_SESSION['majt-admin-id'] = $rs['id'];
$_SESSION['majt-admin-nama'] = $rs['nama'];
$_SESSION['majt-admin-id-catering'] = $rs['id_catering'];
$arr['status'] = TRUE;
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Login gagal! Silahkan periksa kembali username dan password anda..";
}
}
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Harap isi username dan password dengan lengkap..";
}
echo json_encode($arr);
break;
</div>
<div class="modal-body">
<form id="frm-kategori" action="#" method="POST" role="form">
<input type="hidden" class="form-control" id="apa" name="apa">
<input type="hidden" class="form-control" id="txt-id" name="txt-id">
<div class="form-group">
<input type="text" class="form-control" id="txt-nama" name="txt-nama" placeholder="Nama Kategori">
</div>
<div class="form-group">
<textarea class="form-control" id="txt-summary" name="txt-summary"></textarea>
</div>
<div class="form-group">
<select class="form-control" id="cmb-menu" name="cmb-menu">
<?php
$qMenu = "SELECT `id`, `nama` FROM `menu_public` WHERE `hapus` = '0';";
if ($resMenu = $data->runQuery($qMenu)) {
while ($rsMenu = $resMenu->fetch_array()) {
echo "<option value='" . $rsMenu['id'] . "'>" . $rsMenu['nama'] . "</option>";
}
}
?>
</select>
</div>
</form>
</div>
<div class="modal-footer">
<button data-dismiss="modal" class="btn btn-default btn-close-modal" type="button">Close</button>
<button class="btn btn-primary" type="button" id="btn-simpan-data">Simpan Data</button>
</div>
</div>
</div>
} 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";
$e['color'] = "red";
} else {
if ($rs[1] < $jumlahGedung) {
<?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>";
}
$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();
$type = $objExcel->getSheet(0)->getCell('G' . $row)->getValue();
$area = $objExcel->getSheet(0)->getCell('H' . $row)->getValue();
$kodepos = $objExcel->getSheet(0)->getCell('I' . $row)->getValue();
$barcode = $objExcel->getSheet(0)->getCell('J' . $row)->getValue();
$query = $data->runQuery("INSERT INTO `pelanggan`(`noreg`, `nama`, `alamat`, `rayon`, `pasar`, `sub_pasar`, \n\t\t\t\t\t\t\t\t`type`, `area`, `kode_pos`, `barcode`, `hapus`) VALUES('{$noreg}', '{$nama}', '{$alamat}', '{$rayon}', '{$pasar}', \n\t\t\t\t\t\t\t\t'{$subpasar}', '{$type}', '{$area}', '{$kodepos}', '{$barcode}', '0');");
}
$objExcel->disconnectWorksheets();
unset($objExcel);
unlink($targetFile);
}
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'] = "";
}
}
<th class="text-center">Tgl Tebus</th>
<th class="text-center">Bea Admin</th>
<th class="text-center">Total</th>
<th class="text-center">Jenis</th>
<th class="text-center">Bukti</th>
</tr>
</thead>
<tbody>
<?php
$query = "SELECT `khusus_pembelian`.* FROM `khusus_pembelian` \n\t\t\t\t\t\t\t\t\tWHERE `khusus_pembelian`.`id_bank` = '" . $_POST['cmb-bank'] . "' \n\t\t\t\t\t\t\t\t\tAND `khusus_pembelian`.`tgl_tebus` BETWEEN '" . $_POST['tgl-awal'] . "' AND '" . $_POST['tgl-akhir'] . "';";
$totalJml = 0;
$totalPajak = 0;
$totalDiskon = 0;
$totalAdmin = 0;
$totalGT = 0;
if ($daftar = $data->runQuery($query)) {
while ($rs = $daftar->fetch_assoc()) {
$totalAdmin += $rs['bea_admin'];
$totalGT += $rs['grand_total'];
$jenis = $rs['jenis_tarikan'] == "1" ? "Tunai" : "Transfer";
echo "<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['id'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['tgl_tebus'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . number_format($rs['bea_admin'], 0, ",", ".") . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . number_format($rs['grand_total'], 0, ",", ".") . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $jenis . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['no_bukti'] . "</td>";
echo "</tr>";
}
}
?>
<tr>
<td colspan="2"><strong>Total</strong></td>
<td class="text-center"><?php
echo number_format($totalAdmin, 0, ",", ".");
?>
</td>
<div class="header-logo">
<a href="./" class="block"><img src="assets/img/logohd.png" alt="Leore"></a>
</div>
<nav class="header-menu">
<ul>
<li><a href="./?no_spa=<?php
echo e_url("about.php");
?>
">ABOUT</a></li>
<li><a href="./?no_spa=<?php
echo e_url("contact.php");
?>
">CONTACT</a></li>
<?php
$qMenu = "SELECT id, nama FROM menu_public WHERE hapus = '0';";
if ($resMenu = $data->runQuery($qMenu)) {
while ($rsMenu = $resMenu->fetch_array()) {
echo "<li class='sub'><a href='#'>" . $rsMenu['nama'] . "</a><ul>";
$qKat = "SELECT id, nama FROM kategori WHERE id_menu = '" . $rsMenu['id'] . "' AND hapus = '0';";
if ($resKat = $data->runQuery($qKat)) {
while ($rsKat = $resKat->fetch_array()) {
echo "<li><a href='./?no_spa=" . e_url('product.php') . "&kat=" . e_url($rsKat['nama']) . "&id=" . e_url($rsKat['id']) . "'>" . $rsKat['nama'] . "</a></li>";
}
}
echo "</ul></li>";
}
}
?>
</ul>
</nav>
</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/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');
<th class="text-center">Diskon</th>
<th class="text-center">Bea Admin</th>-->
<th class="text-center">Total</th>
<th class="text-center">Jenis</th>
<th class="text-center">Bukti</th>
</tr>
</thead>
<tbody>
<?php
$query = "SELECT `pembelian`.*, `barang`.`nama`, `loading_pembelian`.`tgl_loading`, \n\t\t\t\t\t\t\t\t\t`spbe`.`nama` AS nama_spbe, `spbe_barang`.`ship_to`, `spbe_barang`.`sold_to` FROM `pembelian` \n\t\t\t\t\t\t\t\t\tINNER JOIN `barang` ON (`pembelian`.`id_barang` = `barang`.`id`) \n\t\t\t\t\t\t\t\t\tINNER JOIN `loading_pembelian` ON (`loading_pembelian`.`id_pembelian` = `pembelian`.`id`) \n\t\t\t\t\t\t\t\t\tINNER JOIN `spbe_barang` ON (`pembelian`.`id_spbe_barang` = `spbe_barang`.`id`) \n\t\t\t\t\t\t\t\t\tINNER JOIN `spbe` ON (`spbe_barang`.`id_spbe` = `spbe`.`id`) \n\t\t\t\t\t\t\t\t\tWHERE `pembelian`.`id_bank` = '" . $_POST['cmb-bank'] . "' AND `pembelian`.`id_barang` LIKE '" . $_POST['cmb-barang'] . "' \n\t\t\t\t\t\t\t\t\tAND `pembelian`.`tgl_tebus` BETWEEN '" . $_POST['tgl-awal'] . "' AND '" . $_POST['tgl-akhir'] . "' \n\t\t\t\t\t\t\t\t\tORDER BY `pembelian`.`tgl_tebus` ASC;";
$totalJml = 0;
$totalPajak = 0;
$totalDiskon = 0;
$totalAdmin = 0;
$totalGT = 0;
if ($daftar = $data->runQuery($query)) {
while ($rs = $daftar->fetch_assoc()) {
$totalJml += $rs['jml_tabung'];
$totalGT += $rs['grand_total'];
$jenis = $rs['jenis_tarikan'] == "1" ? "Tunai" : "Transfer";
echo "<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['id'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['tgl_tebus'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['tgl_loading'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['no_lo'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['no_sa'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['nama_spbe'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['ship_to'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['sold_to'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['nama'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . number_format($rs['jml_tabung'], 0, ",", ".") . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . number_format($rs['grand_total'], 0, ",", ".") . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $jenis . "</td>\n\t\t\t\t\t\t\t\t\t\t\t\t<td class='text-center'>" . $rs['no_bukti'] . "</td>";
echo "</tr>";
}
}
?>
</tbody>
<tfoot>
<tr>
<th style="text-align:right" colspan="9">Total:</th>
<th style="text-align:center"></th>
<th style="text-align:center"></th>
<?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);
</h1>
<!-- Section Heading End -->
<!-- Work Gallery -->
<div class="work-gallery type-one masonry-list row">
<!-- Grid Sizer -->
<div class="grid-sizer col-md-4"></div>
<!-- Grid Sizer End -->
<!-- Work Header -->
<div class="item col-md-4">
<div class="work-header type-one">
<h2 class="text-border">SUMMARY</h2>
<?php
$qSummary = "SELECT summary FROM kategori WHERE id = '" . d_url($_GET['id']) . "'";
if ($resSummary = $data->runQuery($qSummary)) {
$rsSummary = $resSummary->fetch_array();
echo "<p>" . stripslashes($rsSummary['summary']) . "</p>";
}
?>
</div>
</div>
<!-- Work Header End -->
<?php
$qImg = "SELECT nama, deskripsi FROM img WHERE id_kategori = '" . d_url($_GET['id']) . "';";
if ($resImg = $data->runQuery($qImg)) {
while ($rsImg = $resImg->fetch_array()) {
?>
<div class="item col-md-4">
<a href="assets/img/<?php
