public static function save(RoomDamage $dmg)
{
$db = PdoFactory::getPdoInstance();
$id = $dmg->getId();
if (isset($id)) {
// Update
// TODO
throw new Exception('Not yet implemented.');
$query = "";
$params = array();
} else {
// Insert
$query = "INSERT INTO hms_room_damage (id, room_persistent_id, term, damage_type, note, repaired, reported_by, reported_on, side) VALUES (nextval('hms_room_damage_seq'), :persistentId, :term, :damageType, :note, :repaired, :reportedBy, :reportedOn, :side)";
$params = array('persistentId' => $dmg->getRoomPersistentId(), 'term' => $dmg->getTerm(), 'damageType' => $dmg->getDamageType(), 'note' => $dmg->getNote(), 'repaired' => $dmg->isRepaired() ? 1 : 0, 'reportedBy' => $dmg->getReportedBy(), 'reportedOn' => $dmg->getReportedOn(), 'side' => $dmg->getSide());
}
$stmt = $db->prepare($query);
$stmt->execute($params);
// Update ID for a new object
if (!isset($id)) {
$dmg->setId($db->lastInsertId('hms_room_damage_seq'));
}
}
