public static function save(\Rebond\Core\ModelInterface $model)
{
$db = new Util\Data();
if ($model->getId() === 0) {
$query = 'INSERT INTO core_user_security (user_id, `sign_in`, `secure`, `type`, `created_date`) VALUES (?,?,?,?,?)';
$params = [$model->getUserId(), $model->getSignIn(), $model->getSecure(), $model->getType(), $model->getCreatedDate('sqlDatetime')];
$id = $db->execute($query, $params);
$model->setId($id);
return $id;
} else {
$query = 'UPDATE core_user_security SET ';
$params = [];
if ($model->getUserId() !== null) {
$query .= 'user_id = ?, ';
$params[] = $model->getUserId();
}
if ($model->getSignIn() !== null) {
$query .= '`sign_in` = ?, ';
$params[] = $model->getSignIn();
}
if ($model->getSecure() !== null) {
$query .= '`secure` = ?, ';
$params[] = $model->getSecure();
}
if ($model->getType() !== null) {
$query .= '`type` = ?, ';
$params[] = $model->getType();
}
$query = rtrim(trim($query), ',');
$query .= ' WHERE id = ?';
$params[] = $model->getId();
return $db->execute($query, $params);
}
}
