$targetPath = "../../ext/"; $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("../../ext/" . $newFileName); $objExcel->setActiveSheetIndex(0); $highestRow = $objExcel->setActiveSheetIndex(0)->getHighestRow(); for ($row = 9; $row <= $highestRow; $row++) { $idPangkalan = $objExcel->getSheet(0)->getCell('A' . $row)->getValue(); $hari = $objExcel->getSheet(0)->getCell('B' . $row)->getValue(); $bulan = $objExcel->getSheet(0)->getCell('C' . $row)->getValue(); $tahun = $objExcel->getSheet(0)->getCell('D' . $row)->getValue(); $alokasi = $objExcel->getSheet(0)->getCell('E' . $row)->getValue(); if (strlen($hari) == 1) { $hari = "0" . $hari; } if (strlen($bulan) == 1) { $bulan = "0" . $bulan; } $tanggal = $tahun . "-" . $bulan . "-" . $hari; $qAlokasi = "DELETE FROM `kuota_penjualan` WHERE `id_konsumen` = '{$idPangkalan}' AND `tgl` = '{$tanggal}';"; $qAlokasi .= "INSERT INTO `kuota_penjualan`(`id_konsumen`, `tgl`, `jml_alokasi`, `jml_terambil`) \n\t\t\t\t\tVALUES('{$idPangkalan}', '{$tanggal}', '{$alokasi}', '0');"; $query = $data->runMultipleQueries($qAlokasi); } $objExcel->disconnectWorksheets(); unset($objExcel); unlink($targetFile); }
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; } }
echo "</div></div></div>"; if ($i % 2 == 0) { echo "</div>"; } $i++; } } } break; case "simpan-catering": include "../../admin/inc/blob.php"; $arr = array(); if (isset($_POST['idbooking']) && $_POST['idbooking'] != "" && isset($_POST['tgl']) && $_POST['tgl'] != "" && isset($_POST['idcatering']) && $_POST['idcatering'] != "") { $idbooking = $_POST['idbooking']; $tgl = $_POST['tgl']; $idcatering = $_POST['idcatering']; $koneksi = new koneksi(); $query = "INSERT INTO booking_catering(id_booking, id_catering) VALUES('{$idbooking}', '{$idcatering}');"; $query .= "INSERT INTO jadwal_catering VALUES('{$idcatering}', '{$tgl}');"; if ($result = $koneksi->runMultipleQueries($query)) { $arr['status'] = TRUE; $arr['msg'] = "Simpan catering berhasil.."; } else { $arr['status'] = FALSE; $arr['msg'] = "Simpan catering gagal.. Ada kesalahan dengan sistem.."; } } echo json_encode($arr); break; } }