BookRepo.php
2.67 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
<?php namespace Oxbow\Repos;
use Illuminate\Support\Str;
use Oxbow\Book;
class BookRepo
{
protected $book;
protected $pageRepo;
/**
* BookRepo constructor.
* @param Book $book
* @param PageRepo $pageRepo
*/
public function __construct(Book $book, PageRepo $pageRepo)
{
$this->book = $book;
$this->pageRepo = $pageRepo;
}
public function getById($id)
{
return $this->book->findOrFail($id);
}
public function getAll()
{
return $this->book->all();
}
public function getBySlug($slug)
{
return $this->book->where('slug', '=', $slug)->first();
}
/**
* Checks if a book exists.
* @param $id
* @return bool
*/
public function exists($id)
{
return $this->book->where('id', '=', $id)->exists();
}
/**
* Get a new book instance from request input.
* @param $input
* @return Book
*/
public function newFromInput($input)
{
return $this->book->fill($input);
}
public function countBySlug($slug)
{
return $this->book->where('slug', '=', $slug)->count();
}
public function destroyBySlug($bookSlug)
{
$book = $this->getBySlug($bookSlug);
foreach($book->pages as $page) {
\Activity::removeEntity($page);
$page->delete();
}
foreach($book->chapters as $chapter) {
\Activity::removeEntity($chapter);
$chapter->delete();
}
$book->delete();
}
public function getNewPriority($book)
{
$lastElem = $book->children()->pop();
return $lastElem ? $lastElem->priority + 1 : 0;
}
public function doesSlugExist($slug, $currentId = false)
{
$query = $this->book->where('slug', '=', $slug);
if($currentId) {
$query = $query->where('id', '!=', $currentId);
}
return $query->count() > 0;
}
public function findSuitableSlug($name, $currentId = false)
{
$slug = Str::slug($name);
while($this->doesSlugExist($slug, $currentId)) {
$slug .= '-' . substr(md5(rand(1, 500)), 0, 3);
}
return $slug;
}
public function getBySearch($term)
{
$terms = explode(' ', preg_quote(trim($term)));
$books = $this->book->fullTextSearch(['name', 'description'], $terms);
$words = join('|', $terms);
foreach ($books as $book) {
//highlight
$result = preg_replace('#' . $words . '#iu', "<span class=\"highlight\">\$0</span>", $book->getExcerpt(100));
$book->searchSnippet = $result;
}
return $books;
}
}