/**
* Save changes in database
*/
public function save()
{
$this->_content->title = $this->title;
$this->_content->text = $this->text;
$this->_content->path = $this->path;
$this->_content->category_id = $this->categoryId;
$this->_content->author_id = $this->authorId;
$this->_content->display = $this->display;
$this->_content->meta_title = $this->metaTitle;
$this->_content->meta_keywords = $this->metaKeywords;
$this->_content->meta_description = $this->metaDescription;
$this->_content->source = $this->source;
// check if rating is changed
if ((int) $this->addRating !== 0) {
$this->_content->rating += (int) $this->addRating;
}
// check if special comment hash is exist
if ($this->_new || Str::length($this->_content->comment_hash) < 32) {
$this->_content->comment_hash = $this->generateCommentHash();
}
// check if date is updated
if (!Str::likeEmpty($this->createdAt) && !Str::startsWith('0000', Date::convertToDatetime($this->createdAt, Date::FORMAT_SQL_TIMESTAMP))) {
$this->_content->created_at = Date::convertToDatetime($this->createdAt, Date::FORMAT_SQL_TIMESTAMP);
}
// save poster data
$posterPath = '/upload/gallery/' . $this->galleryFreeId . '/orig/' . $this->poster;
if (File::exist($posterPath)) {
$this->_content->poster = $this->poster;
}
// get temporary gallery id
$tmpGalleryId = $this->galleryFreeId;
// save row
$this->_content->save();
// update tags data in special table (relation: content->content_tags = oneToMany)
ContentTag::where('content_id', '=', $this->_content->id)->delete();
$insertData = [];
foreach ($this->metaKeywords as $lang => $keys) {
// split keywords to tag array
$tags = explode(',', $keys);
foreach ($tags as $tag) {
// cleanup tag from white spaces
$tag = trim($tag);
// prepare data to insert
if (Str::length($tag) > 0) {
$insertData[] = ['content_id' => $this->_content->id, 'lang' => $lang, 'tag' => $tag];
}
}
}
// insert tags
ContentTag::insert($insertData);
// move files
if ($tmpGalleryId !== $this->_content->id) {
Directory::rename('/upload/gallery/' . $tmpGalleryId, $this->_content->id);
}
}
/**
* Make query to database via active record
* @return object
*/
private function makeQuery()
{
return TagRecord::select([App::$Database->getConnection()->raw('SQL_CALC_FOUND_ROWS tag'), App::$Database->getConnection()->raw('COUNT(*) AS count')])->where('lang', '=', $this->_lang)->groupBy('tag')->orderBy('count', 'DESC')->take($this->count)->get();
}
