\n";
$roomInfoTags .= "\t\t\t\t| " . $i . " | \n";
$roomInfoTags .= "\t\t\t\t" . htmlspecialchars($row['floor']) . " | \n";
$roomInfoTags .= "\t\t\t\t" . htmlspecialchars($row['size']) . " | \n";
$roomInfoTags .= "\t\t\t\t" . htmlspecialchars($row['rent']) . " | \n";
$roomInfoTags .= "\t\t\t\t" . htmlspecialchars($row['name']) . " | \n";
$roomInfoTags .= "\t\t\t\t" . htmlspecialchars($row['sex']) . " | \n";
$roomInfoTags .= "\t\t\t\t" . htmlspecialchars($row['caretaker']) . " | \n";
$roomInfoTags .= "\t\t\t\t" . htmlspecialchars($row['in_month']) . " | \n";
$roomInfoTags .= "\t\t\t\t表示 | \n";
$roomInfoTags .= "\t\t\t\n";
$i++;
}
// DBとの接続をクローズ
$db = null;
/**
* 基本情報取得SQL
*/
function getBasicSql() {
$sql = "SELECT\n";
$sql .= " h.id\n";
$sql .= " ,h.name\n";
$sql .= " ,h.zip\n";
$sql .= " ,h.address\n";
$sql .= " ,(SELECT COUNT(*) FROM room i WHERE i.house_id = h.id) AS rooms\n";
$sql .= " ,(SELECT COUNT(*) FROM inhabitant i WHERE i.house_id = h.id) AS inhabitants\n";
$sql .= "FROM\n";
$sql .= " house h\n";
$sql .= "WHERE\n";
$sql .= " h.id = ?\n";
$sql .= ";\n";
return $sql;
}
/**
* 部屋情報取得SQL
*/
function getRoomSql() {
$sql = "SELECT\n";
$sql .= " r.floor || '階' AS floor\n";
$sql .= " ,CASE r.size\n";
$sql .= " WHEN 0 THEN '-'\n";
$sql .= " ELSE r.size || '畳'\n";
$sql .= " END AS size\n";
$sql .= " ,CASE r.rent\n";
$sql .= " WHEN 0 THEN '-'\n";
$sql .= " ELSE r.rent || '円'\n";
$sql .= " END AS rent\n";
$sql .= " ,u.id\n";
$sql .= " ,u.name\n";
$sql .= " ,CASE u.sex\n";
$sql .= " WHEN 'm' THEN '男性'\n";
$sql .= " WHEN 'f' THEN '女性'\n";
$sql .= " ELSE '-'\n";
$sql .= " END AS sex\n";
$sql .= " ,CASE i.caretaker\n";
$sql .= " WHEN 1 THEN '○'\n";
$sql .= " ELSE ''\n";
$sql .= " END AS caretaker\n";
$sql .= " ,CASE i.in_month\n";
$sql .= " WHEN '1900-01' THEN '-'\n";
$sql .= " ELSE i.in_month\n";
$sql .= " END AS in_month\n";
$sql .= "FROM\n";
$sql .= " room r\n";
$sql .= " LEFT JOIN inhabitant i\n";
$sql .= " ON i.room_id = r.id\n";
$sql .= " LEFT JOIN user u\n";
$sql .= " ON u.id = i.user_id\n";
$sql .= "WHERE\n";
$sql .= " r.house_id = ?\n";
$sql .= "ORDER BY\n";
$sql .= " r.id\n";
$sql .= ";\n";
return $sql;
}
?>