UploadSlide($NewFileName);
//move_uploaded_file($_FILES['FileInput']['tmp_name'], "../../../uploads/fotoSlide/".$NewFileName); //Mengupload langsung tanpa di re-Size
$foto = $NewFileName;
}
$idSlide = $_POST['idSlide'];
$fieldValue = array('judul' => $_POST['judulSlide'], 'keterangan' => $_POST['ket'], 'gambar' => $foto, 'status' => $_POST['statusSlide'], 'row_status' => 1);
if ($idSlide == '') {
$con->insert('m_slide', $fieldValue);
} else {
$idWhere = array('id_slide' => $idSlide);
//Jika FIle Foto Diganti Maka File Foto Yang lama Harus Di Unlink
if ($foto != "") {
$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}");
}
$con->update('m_slide', $fieldValue, $idWhere);
}
$hasil = $con->logQuery();
if ($con->commitQuery()) {
$pesan = "Query Berhasil";
} else {
$pesan = "Query Gagal";
}
echo json_encode($pesan);
break;
default:
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);
}
$hasil = $con->logQuery();
if ($con->commitQuery()) {
$pesan = "Query Berhasil";
} else {
$pesan = "Query Gagal";
}
echo json_encode($pesan);
break;
default:
break;
}
UploadGallery($NewFileName);
//move_uploaded_file($_FILES['FileInput']['tmp_name'], "../../uploads/fotoGallery/".$NewFileName); //Mengupload langsung tanpa di re-Size
$foto = $NewFileName;
}
$idGallery = $_POST['idGallery'];
$fieldValue = array('id_kat_gallery' => $_POST['kat_galeri'], 'nama_gallery' => $_POST['nama_gallery'], 'ket_gallery' => $_POST['ket'], 'gambar_gallery' => $foto, 'row_status' => 1);
if ($idGallery == '') {
$con->insert('m_gallery', $fieldValue);
} else {
$idWhere = array('id_gallery' => $idGallery);
//Jika FIle Foto Diganti Maka File Foto Yang lama Harus Di Unlink
if ($foto != "") {
$query = "select * from m_gallery where id_gallery = '{$idGallery}'";
$data = $con->execQuery($query);
$gambar = $data[0]['gambar_gallery'];
unlink("../../../uploads/fotoGallery/{$gambar}");
unlink("../../../uploads/fotoGallery/kecil_{$gambar}");
}
$con->update('m_gallery', $fieldValue, $idWhere);
}
$hasil = $con->logQuery();
if ($con->commitQuery()) {
$pesan = "Query Berhasil";
} else {
$pesan = "Query Gagal";
}
echo json_encode($pesan);
break;
default:
break;
}
);*/
$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);
}
$hasil = $con->logQuery();
if ($con->commitQuery()) {
$pesan = "Query Berhasil";
} else {
$pesan = "Query Gagal";
}
echo json_encode($pesan);
break;
default:
break;
}
}
} else {
$msg = "Jenis file tidak sesuai atau ukuran file terlalu besar!";
}
echo "<p align=\"center\">{$msg}</p>";
$idVD = $_POST['idVideo'];
$fieldValue = array('nama' => $_POST['nama'], 'file' => $nama_file, 'tgl_posting' => $tgl_sekarang, 'row_status' => 1);
if ($idVD == '') {
$con->insert('m_video', $fieldValue);
} else {
$idWhere = array('id_video' => $idVD);
if ($foto != "") {
$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);
}
$hasil = $con->logQuery();
if ($con->commitQuery()) {
$pesan = "Query Berhasil";
} else {
$pesan = "Query Gagal";
}
echo json_encode($pesan);
break;
default:
break;
}
UploadInformasi($NewFileName);
//move_uploaded_file($_FILES['FileInput']['tmp_name'], "../../../uploads/fotoInformasi/".$NewFileName); //Mengupload langsung tanpa di re-Size
$foto = $NewFileName;
}
$idIn = $_POST['idInformasi'];
$fieldValue = array('judul' => $_POST['judulIn'], 'posisi_foto' => $_POST['pf'], 'isi' => $_POST['isi'], 'gambar' => $foto, 'jam' => $jam_sekarang, 'hari' => $hari_ini, 'tgl_posting' => $tgl_sekarang, 'row_status' => 1);
if ($idIn == '') {
$con->insert('m_informasi', $fieldValue);
} else {
$idWhere = array('id_informasi' => $idIn);
//Jika FIle Foto Diganti Maka File Foto Yang lama Harus Di Unlink
if ($foto != "") {
$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);
}
$hasil = $con->logQuery();
if ($con->commitQuery()) {
$pesan = "Query Berhasil";
} else {
$pesan = "Query Gagal";
}
echo json_encode($pesan);
break;
default:
break;
}
case "selectBerita":
$idWhere = array('row_status' => 1);
$dataBalik = $con->selectFrom('m_berita', '*', $idWhere);
echo json_encode($dataBalik);
break;
case "selectEdit":
$idberita = $_POST['id'];
$idWhere = array('id_berita' => $idberita);
$dataBalik = $con->selectFrom('m_berita', '*', $idWhere);
echo json_encode($dataBalik);
break;
case "hapusFak":
$idFak = $_POST['id'];
$fieldValue = array('row_status' => '0');
$idWhere = array('id_fakultas' => $idFak);
$con->update('m_fakultas', $fieldValue, $idWhere);
if ($con->commitQuery()) {
$pesan = "Query Berhasil";
} else {
$pesan = "Query Gagal";
}
echo json_encode($pesan);
break;
case "commit":
$idBerita = $_POST['idBerita'];
$fieldValue = array('judul' => $_POST['judulBerita'], 'isi' => $_POST['isi'], 'gambar' => $_POST['gambar'], 'row_status' => 1);
if ($idBerita == '') {
$con->insert('m_berita', $fieldValue);
} else {
$idWhere = array('id_berita' => $idBerita);
$con->update('m_berita', $fieldValue, $idWhere);
UploadBerita($NewFileName);
//move_uploaded_file($_FILES['FileInput']['tmp_name'], "../../../uploads/fotoBerita/".$NewFileName); //Mengupload langsung tanpa di re-Size
$foto = $NewFileName;
}
$idBerita = $_POST['idBerita'];
$fieldValue = array('judul' => $_POST['judulBerita'], 'isi' => $_POST['isi'], 'gambar' => $foto, 'jam' => $jam_sekarang, 'hari' => $hari_ini, 'tgl_posting' => $tgl_sekarang, 'row_status' => 1);
if ($idBerita == '') {
$con->insert('m_berita', $fieldValue);
} else {
$idWhere = array('id_berita' => $idBerita);
//Jika FIle Foto Diganti Maka File Foto Yang lama Harus Di Unlink
if ($foto != "") {
$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}");
}
$con->update('m_berita', $fieldValue, $idWhere);
}
$hasil = $con->logQuery();
if ($con->commitQuery()) {
$pesan = "Query Berhasil";
} else {
$pesan = "Query Gagal";
}
echo json_encode($pesan);
break;
default:
break;
}
