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')); } }