$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;
}
}
