Active
";
} else{
$status = "
";
}
$data.="
| $i |
$row[name] |
$row[area] sq.ft. |
Adult: $row[adult]
Children: $row[children]
|
$$row[price] |
$row[quantity] |
$status |
|
";
$i++;
}
echo $data;
}
//edit
if(isset($_POST['get_room'])){
$frm_data = filteration($_POST);
$res1 = select("SELECT * FROM `rooms` WHERE `id`=?", [$frm_data['get_room']], 'i');
$res2 = select("SELECT * FROM `room_accommodation` WHERE `room_id`=?", [$frm_data['get_room']], 'i');
$res3 = select("SELECT * FROM `room_additionalAccom` WHERE `room_id`=?", [$frm_data['get_room']], 'i');
$roomdata = mysqli_fetch_assoc($res1);
$accommodation = [];
$additional_accomm = [];
if(mysqli_num_rows($res2)>0){
while($row = mysqli_fetch_assoc($res2)){
array_push($accommodation, $row['accommodation_id']);
}
}
if(mysqli_num_rows($res3)>0){
while($row = mysqli_fetch_assoc($res3)){
array_push($additional_accomm, $row['additionalAccom_id']);
}
}
$data = ["roomdata" => $roomdata, "accommodation" => $accommodation, "additional_accomm" => $additional_accomm];
$data = json_encode($data);
echo $data;
}
if(isset($_POST['edit_room'])){
$accommodation = filteration(json_decode($_POST['accommodation']));
$additional_accomm = filteration(json_decode($_POST['additional_accomm']));
$frm_data = filteration($_POST);
$flag = 0;
$q1 = "UPDATE `rooms` SET `name`=?,`area`=?,`price`=?,`quantity`=?,`adult`=?,`children`=?,`detail`=? WHERE `id`=?";
$values = [$frm_data['name'], $frm_data['area'], $frm_data['price'], $frm_data['quantity'], $frm_data['adult'], $frm_data['children'], $frm_data['detail'], $frm_data['room_id']];
if(update($q1, $values, 'siiiiisi')){
$flag = 1;
}
$delete_accommodation = delete("DELETE FROM `room_accommodation` WHERE `room_id`=?", [$frm_data['room_id']], 'i');
$delete_additionalAccomm = delete("DELETE FROM `room_additionalAccom` WHERE `room_id`=?", [$frm_data['room_id']], 'i');
if(!($delete_accommodation && $delete_additionalAccomm)){
$flag = 0;
}
$q2 = "INSERT INTO `room_accommodation`(`room_id`, `accommodation_id`) VALUES (?, ?)";
if($stmt = mysqli_prepare($con, $q2)){
foreach($accommodation as $a){
mysqli_stmt_bind_param($stmt, 'ii', $frm_data['room_id'], $a);
mysqli_stmt_execute($stmt);
}
$flag = 1;
mysqli_stmt_close($stmt);
} else{
$flag = 0;
die('Query cannot be prepared - insert');
}
//room additional accommodation
$q3 = "INSERT INTO `room_additionalAccom`(`room_id`, `additionalAccom_id`) VALUES (?, ?)";
if($stmt = mysqli_prepare($con, $q3)){
foreach($additional_accomm as $a){
mysqli_stmt_bind_param($stmt, 'ii', $frm_data['room_id'], $a);
mysqli_stmt_execute($stmt);
}
$flag = 1;
mysqli_stmt_close($stmt);
} else{
$flag = 0;
die('Query cannot be prepared - insert');
}
if($flag){
echo 1;
} else{
echo 0;
}
}
if(isset($_POST['toggleStatus'])){
$frm_data = filteration($_POST);
$q = "UPDATE `rooms` SET `status`=? WHERE `id`=?";
$values = [$frm_data['value'], $frm_data['toggleStatus']];
if(update($q, $values, 'ii')){
echo 1;
} else{
echo 0;
}
}
//upload image
if(isset($_POST['add_image'])){
$frm_data = filteration($_POST);
$img_r = uploadImage($_FILES['image'], ROOMS_FOLDER);
if($img_r == 'inv_img'){
echo $img_r;
}
else if($img_r == 'inv_size'){
echo $img_r;
}
else if($img_r == 'upd_failed'){
echo $img_r;
}
else{
$q = "INSERT INTO `room_images`(`room_id`, `image`) VALUES (?, ?)";
$values = [$frm_data['room_id'], $img_r];
$res = insert($q, $values, 'is');
echo $res;
}
}
if(isset($_POST['get_room_images'])){
$frm_data = filteration($_POST);
$res = select("SELECT * FROM `room_images` WHERE `room_id`=?", [$frm_data['get_room_images']], 'i');
$path = ROOM_IMG_PATH;
while($row = mysqli_fetch_assoc($res)){
if($row['upload']==1){
$upload_btn = "";
} else{
$upload_btn = "";
}
echo <<< data
 |
$upload_btn |
|
data;
}
}
if(isset($_POST['remove_image'])){
$frm_data = filteration($_POST);
$values = [$frm_data['image_id'], $frm_data['room_id']];
$pre_q = "SELECT * FROM `room_images` WHERE `sr_no`=? AND `room_id`=?";
$res = select($pre_q, $values, 'ii');
$img = mysqli_fetch_assoc($res);
if(deleteImage($img['image'], ROOMS_FOLDER)){
$q = "DELETE FROM `room_images` WHERE `sr_no`=? AND `room_id`=?";
$res = delete($q, $values, 'ii');
echo $res;
} else{
echo 0;
}
}
if(isset($_POST['upload_image'])){
$frm_data = filteration($_POST);
$pre_q = "UPDATE `room_images` SET `upload`=? WHERE `room_id`=?";
$pre_values = [0, $frm_data['room_id']];
$pre_res = update($pre_q, $pre_values, 'ii');
$q = "UPDATE `room_images` SET `upload`=? WHERE `sr_no`=? AND `room_id`=?";
$values = [1, $frm_data['image_id'], $frm_data['room_id']];
$res = update($q, $values, 'iii');
echo $res;
}
//remove rooms
if(isset($_POST['remove_room'])){
$frm_data = filteration($_POST);
$res1 = select("SELECT * FROM `room_images` WHERE `room_id`=?", [$frm_data['room_id']], 'i');
while($row = mysqli_fetch_assoc($res1)){
deleteImage($row['image'], ROOMS_FOLDER);
}
$res2 = delete("DELETE FROM `room_images` WHERE `room_id`=?", [$frm_data['room_id']], 'i');
$res3 = delete("DELETE FROM `room_accommodation` WHERE `room_id`=?", [$frm_data['room_id']], 'i');
$res4 = delete("DELETE FROM `room_additionalAccom` WHERE `room_id`=?", [$frm_data['room_id']], 'i');
$res5 = update("UPDATE `rooms` SET `removed`=? WHERE `id`=?", [1, $frm_data['room_id']], 'ii');
if($res2 || $res3 || $res4 || $res5){
echo 1;
} else{
echo 0;
}
}
?>