<?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