public static function save(\Rebond\Core\ModelInterface $model)
{
$db = new Util\Data();
if ($model->getId() === 0) {
$query = 'INSERT INTO core_log (`code`, user_id, `ip`, `request_uri`, `referer`, `message`, `trace`, `file`, `line`, `status`, `created_date`, `modified_date`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)';
$params = [$model->getCode(), $model->getUserId(), $model->getIp(), $model->getRequestUri(), $model->getReferer(), $model->getMessage(), $model->getTrace(), $model->getFile(), $model->getLine(), $model->getStatus(), $model->getCreatedDate('sqlDatetime'), Util\Format::date(time(), 'sqlDatetime')];
$id = $db->execute($query, $params);
$model->setId($id);
return $id;
} else {
$query = 'UPDATE core_log SET ';
$params = [];
if ($model->getCode() !== null) {
$query .= '`code` = ?, ';
$params[] = $model->getCode();
}
if ($model->getUserId() !== null) {
$query .= 'user_id = ?, ';
$params[] = $model->getUserId();
}
if ($model->getIp() !== null) {
$query .= '`ip` = ?, ';
$params[] = $model->getIp();
}
if ($model->getRequestUri() !== null) {
$query .= '`request_uri` = ?, ';
$params[] = $model->getRequestUri();
}
if ($model->getReferer() !== null) {
$query .= '`referer` = ?, ';
$params[] = $model->getReferer();
}
if ($model->getMessage() !== null) {
$query .= '`message` = ?, ';
$params[] = $model->getMessage();
}
if ($model->getTrace() !== null) {
$query .= '`trace` = ?, ';
$params[] = $model->getTrace();
}
if ($model->getFile() !== null) {
$query .= '`file` = ?, ';
$params[] = $model->getFile();
}
if ($model->getLine() !== null) {
$query .= '`line` = ?, ';
$params[] = $model->getLine();
}
if ($model->getStatus() !== null) {
$query .= '`status` = ?, ';
$params[] = $model->getStatus();
}
$query .= '`modified_date` = ?, ';
$params[] = Util\Format::date(time(), 'sqlDatetime');
$query = rtrim(trim($query), ',');
$query .= ' WHERE id = ?';
$params[] = $model->getId();
return $db->execute($query, $params);
}
}
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);
}
}
public static function save(\Rebond\Core\ModelInterface $model)
{
$db = new Util\Data();
if ($model->getId() === 0) {
$query = 'INSERT INTO core_feedback (user_id, `title`, `type`, `description`, `status`, `created_date`, `modified_date`) VALUES (?,?,?,?,?,?,?)';
$params = [$model->getUserId(), $model->getTitle(), $model->getType(), $model->getDescription(), $model->getStatus(), $model->getCreatedDate('sqlDatetime'), Util\Format::date(time(), 'sqlDatetime')];
$id = $db->execute($query, $params);
$model->setId($id);
return $id;
} else {
$query = 'UPDATE core_feedback SET ';
$params = [];
if ($model->getUserId() !== null) {
$query .= 'user_id = ?, ';
$params[] = $model->getUserId();
}
if ($model->getTitle() !== null) {
$query .= '`title` = ?, ';
$params[] = $model->getTitle();
}
if ($model->getType() !== null) {
$query .= '`type` = ?, ';
$params[] = $model->getType();
}
if ($model->getDescription() !== null) {
$query .= '`description` = ?, ';
$params[] = $model->getDescription();
}
if ($model->getStatus() !== null) {
$query .= '`status` = ?, ';
$params[] = $model->getStatus();
}
$query .= '`modified_date` = ?, ';
$params[] = Util\Format::date(time(), 'sqlDatetime');
$query = rtrim(trim($query), ',');
$query .= ' WHERE id = ?';
$params[] = $model->getId();
return $db->execute($query, $params);
}
}
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);
}
}
