/**
*
* @param unknown $id
* @return string
*/
function delHouse($id)
{
$where = "id={$id}";
$res = delete("homarget_house", $where);
$houseImgs = getAllImgsByHouseId($id);
if ($houseImgs && is_array($houseImgs)) {
foreach ($houseImgs as $houseImg) {
if (file_exists("uploads/" . $houseImg['img_path'])) {
unlink("uploads/" . $proImg['img_path']);
}
if (file_exists("../image_50/" . $houseImg['img_path'])) {
unlink("../image_50/" . $proImg['img_path']);
}
// if(file_exists("../image_220/".$houseImg['img_path'])){
// unlink("../image_220/".$proImg['img_path']);
// }
// if(file_exists("../image_350/".$houseImg['img_path'])){
// unlink("../image_350/".$proImg['img_path']);
// }
// if(file_exists("../image_800/".$houseImg['img_path'])){
// unlink("../image_800/".$houseImg['img_path']);
// }
}
}
$where1 = "album_id={$id}";
$res1 = delete("tigris_album", $where1);
if ($res && $res1) {
$mes = "Delete success!<br/><a href='listHouse.php' target='mainFrame'>View house list</a>";
} else {
$mes = "Failed!<br/><a href='listHouse.php' target='mainFrame'>Delete</a>";
}
return $mes;
}
?>
<div class="tab-pane fade in active" id="photos-tab">
<div class="col-md-12">
<table class="table table-condensed table-hover">
<caption style="padding:10px 0 10px 20px;border:1px solid #ccc;margin-top:20px;background:#ccc;color:white;">Photo Management</caption>
<tbody>
<tr>
<td>
<h3>1. Click the image that you want to delete;</h3>
<h3>2. Click "Yes" on the pop up window to delete the image.</h3>
</td>
</tr>
<tr>
<td>
<?php
$houseImgs = getAllImgsByHouseId($id);
foreach ($houseImgs as $img) {
if (!empty($img['img_path'])) {
?>
<img style="cursor:pointer;width:150px;height:150px;margin-bottom:10px;" src="uploads/House_Album/user_id_<?php
echo $id . "/" . $img['img_path'];
?>
" onclick="delImg('<?php
echo $img['album_id'];
?>
','<?php
echo $img['img_path'];
?>
')" />
<?php
}
$row_email = fetchOne($sql_email);
$sql_user = "******";
$row_user = fetchOne($sql_user);
$sql_house = "select * from tg_host_house where house_id={$id}";
$row_house = fetchOne($sql_house);
//print_r($row_house);
$sql_services = "select * from tg_host_services where services_id={$id}";
$row_services = fetchOne($sql_services);
//print_r($row_services);
$sql_location = "select * from tg_house_location where location_id={$id}";
$row_location = fetchOne($sql_location);
//print_r($row_location);
$sql_calendar = "select * from tg_host_calendar where calendar_id={$id}";
$row_calendar = fetchOne($sql_calendar);
//取锟斤拷同一锟斤拷album_id 锟斤拷锟斤拷锟斤拷图 Get all imgs with identity album_id using in images_ablum display
$rows = getAllImgsByHouseId($id);
//Get data from tg_house_img
$sql_img = "select * from tg_house_img where album_id={$id}";
$rows = fetchAll($sql_img);
?>
<!-- Page Content -->
<div class="container">
<!-- Page Heading/Breadcrumbs -->
<div class="row">
<?php
if ($row_calendar['is_avail'] == 0) {
?>
<div class="breadcrumb text-center" style="padding:10px 0;color:rgb(217,83,79);background:#fff;">
?>
" class="check" value=<?php
echo $row['house_id'];
?>
><label for="c1" class="label"><?php
echo $row['house_id'];
?>
</label></td>
<td><?php
echo $row['house_title'];
?>
</td>
<td>
<?php
$houseImgs = getAllImgsByHouseId($row['house_id']);
foreach ($houseImgs as $img) {
?>
<img width="100" height="100" src="../uploads/House_Album/user_id_<?php
echo $img['album_id'] . "/" . $img['img_path'];
?>
" onclick="delImg('<?php
echo $img['album_id'];
?>
','<?php
echo $img['img_path'];
?>
')" />
<?php
}
?>
