break; case "selectEdit": $id_gallery = $_POST['id']; $idWhere = array('id_gallery' => $id_gallery); $dataBalik = $con->selectFrom('m_gallery', '*', $idWhere); echo json_encode($dataBalik); break; case "hapus": $id_gallery = $_POST['id']; $idWhere = array('id_gallery' => $id_gallery); $query = "select * from m_gallery where id_gallery = '{$id_gallery}'"; $data = $con->execQuery($query); $gambar = $data[0]['gambar']; unlink("../../../uploads/fotoGallery/{$gambar}"); unlink("../../../uploads/fotoGallery/kecil_{$gambar}"); $con->delete('m_gallery', $idWhere); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; case "commit": if (isset($_FILES["FileInput"]) && $_FILES["FileInput"]["error"] == UPLOAD_ERR_OK) { $UploadDirectory = '../../../uploads/fotoGallery/'; //check if this is an ajax request if (!isset($_SERVER['HTTP_X_REQUESTED_WITH'])) { echo json_encode(""); } $File_Name = strtolower($_FILES['FileInput']['name']);
$dataBalik = $con->selectFrom('m_slide', '*', $idWhere); echo json_encode($dataBalik); break; case "hapusSlide": $idSlide = $_POST['id']; $query = "select * from m_slide where id_slide = '{$idSlide}'"; $data = $con->execQuery($query); $gambar = $data[0]['gambar']; unlink("../../../uploads/fotoSlide/{$gambar}"); unlink("../../../uploads/fotoSlide/kecil_{$gambar}"); /*$fieldValue = array( 'row_status' => '0', );*/ $idWhere = array('id_slide' => $idSlide); //$con->update('m_slide',$fieldValue,$idWhere); $con->delete('m_slide', $idWhere); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; case "commit": if (isset($_FILES["FileInput"]) && $_FILES["FileInput"]["error"] == UPLOAD_ERR_OK) { $UploadDirectory = 'uploads/fotoSlide/'; //check if this is an ajax request if (!isset($_SERVER['HTTP_X_REQUESTED_WITH'])) { echo json_encode(""); } $File_Name = strtolower($_FILES['FileInput']['name']);
switch ($ACTION) { case "select": $idWhere = array('row_status' => 1); $dataBalik = $con->selectFrom('m_kat_product', '*', $idWhere); echo json_encode($dataBalik); break; case "selectEdit": $id = $_POST['id']; $idWhere = array('id_kat_product' => $id); $dataBalik = $con->selectFrom('m_kat_product', '*', $idWhere); echo json_encode($dataBalik); break; case "hapus": $id = $_POST['id']; $idWhere = array('id_kat_product' => $id); $con->delete('m_kat_product', $idWhere); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; case "commit": $id = $_POST['id']; $fieldValue = array('nama_kat_product' => $_POST['nama_kat'], 'row_status' => 1); if ($id == '') { $con->insert('m_kat_product', $fieldValue); } else { $idWhere = array('id_kat_product' => $id); $con->update('m_kat_product', $fieldValue, $idWhere);
echo json_encode($dataBalik); break; case "selectEdit": $idPeng = $_POST['id']; $idWhere = array('id_pengumuman' => $idPeng); $dataBalik = $con->selectFrom('m_pengumuman', '*', $idWhere); echo json_encode($dataBalik); break; case "hapusPengumuman": $idPeng = $_POST['id']; /*$fieldValue = array( 'row_status' => '0', );*/ $idWhere = array('id_pengumuman' => $idPeng); //$con->update('m_pengumuman',$fieldValue,$idWhere); $con->delete('m_pengumuman', $idWhere); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; case "commit": $idPeng = $_POST['idPengumuman']; $fieldValue = array('judul' => $_POST['judulPeng'], 'isi' => $_POST['isi'], 'jam' => $jam_sekarang, 'hari' => $hari_ini, 'tgl_posting' => $tgl_sekarang, 'row_status' => 1); if ($idPeng == '') { $con->insert('m_pengumuman', $fieldValue); } else { $idWhere = array('id_pengumuman' => $idPeng); $con->update('m_pengumuman', $fieldValue, $idWhere);
$dataBalik = $con->selectFrom('m_video', '*', $idWhere); echo json_encode($dataBalik); break; case "hapusVideo": $idVD = $_POST['id']; /*$fieldValue = array( 'row_status' => '0', );*/ $idWhere = array('id_video' => $idVD); $query = "select * from m_video where id_video = '{$idVD}'"; $data = $con->execQuery($query); $file = $data[0]['file']; unlink("../../../uploads/fileVideo/{$file}"); unlink("../../../uploads/fileVideo/kecil_{$file}"); //$con->update('m_video',$fieldValue,$idWhere); $con->delete('m_video', $idWhere); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; case "commit": $name = $_FILES['FileInputVideo']['name']; $type = $_FILES['FileInputVideo']['type']; $size = $_FILES['FileInputVideo']['size']; //replace tanda spasi pada nama file dengan _ $nama_file = str_replace(" ", "_", $name); $tmp_name = $_FILES['FileInputVideo']['tmp_name']; $nama_folder = "../../../uploads/fileVideo/";
$dataBalik = $con->selectFrom('m_informasi', '*', $idWhere); echo json_encode($dataBalik); break; case "hapusInformasi": $idIn = $_POST['id']; /*$fieldValue = array( 'row_status' => '0', );*/ $idWhere = array('id_informasi' => $idIn); $query = "select * from m_informasi where id_informasi = '{$idIn}'"; $data = $con->execQuery($query); $gambar = $data[0]['gambar']; unlink("../../../uploads/fotoInformasi/{$gambar}"); unlink("../../../uploads/fotoInformasi/kecil_{$gambar}"); //$con->update('m_informasi',$fieldValue,$idWhere); $con->delete('m_informasi', $idWhere); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; case "commit": if (isset($_FILES["FileInput"]) && $_FILES["FileInput"]["error"] == UPLOAD_ERR_OK) { $UploadDirectory = 'uploads/fotoInformasi/'; //check if this is an ajax request if (!isset($_SERVER['HTTP_X_REQUESTED_WITH'])) { echo json_encode(""); } $File_Name = strtolower($_FILES['FileInput']['name']);
$dataBalik = $con->selectFrom('m_berita', '*', $idWhere); echo json_encode($dataBalik); break; case "hapusBerita": $idberita = $_POST['id']; $query = "select * from m_berita where id_berita = '{$idberita}'"; $data = $con->execQuery($query); $gambar = $data[0]['gambar']; unlink("../../../uploads/fotoBerita/{$gambar}"); unlink("../../../uploads/fotoBerita/kecil_{$gambar}"); /*$fieldValue = array( 'row_status' => '0', );*/ $idWhere = array('id_berita' => $idberita); //$con->update('m_berita',$fieldValue,$idWhere); // Untuk Delete Tapi Update ke status 0 $con->delete('m_berita', $idWhere); if ($con->commitQuery()) { $pesan = "Query Berhasil"; } else { $pesan = "Query Gagal"; } echo json_encode($pesan); break; case "commit": if (isset($_FILES["FileInput"]) && $_FILES["FileInput"]["error"] == UPLOAD_ERR_OK) { $UploadDirectory = 'uploads/fotoBerita/'; //check if this is an ajax request if (!isset($_SERVER['HTTP_X_REQUESTED_WITH'])) { echo json_encode(""); } $File_Name = strtolower($_FILES['FileInput']['name']);