public static function save(\Rebond\Core\ModelInterface $model) { $db = new Util\Data(); if ($model->getId() === 0) { $query = 'INSERT INTO cms_user_settings (user_id, `media_view`, `media_paging`, `content_paging`, `paging`) VALUES (?,?,?,?,?)'; $params = [$model->getUserId(), $model->getMediaView(), $model->getMediaPaging(), $model->getContentPaging(), $model->getPaging()]; $id = $db->execute($query, $params); $model->setId($id); return $id; } else { $query = 'UPDATE cms_user_settings SET '; $params = []; if ($model->getUserId() !== null) { $query .= 'user_id = ?, '; $params[] = $model->getUserId(); } if ($model->getMediaView() !== null) { $query .= '`media_view` = ?, '; $params[] = $model->getMediaView(); } if ($model->getMediaPaging() !== null) { $query .= '`media_paging` = ?, '; $params[] = $model->getMediaPaging(); } if ($model->getContentPaging() !== null) { $query .= '`content_paging` = ?, '; $params[] = $model->getContentPaging(); } if ($model->getPaging() !== null) { $query .= '`paging` = ?, '; $params[] = $model->getPaging(); } $query = rtrim(trim($query), ','); $query .= ' WHERE id = ?'; $params[] = $model->getId(); return $db->execute($query, $params); } }