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']);
