public function index(Request $request)
{
$posts = Post::query()->orderBy('created_at', 'desc')->get()->all();
foreach ($posts as $post) {
$post->author = $post->getAuthor();
}
return view('dashboard.index', ['posts' => $posts]);
}
/**
* Get All posts
* @return array
*/
public function findAll($author = null, $from = null, $to = null)
{
$query = Post::query();
if ($author) {
$query = $query->where('author', $author);
}
if ($from) {
$query = $query->whereDate('date', '>=', new DateTime($from));
}
if ($to) {
$query = $query->whereDate('date', '<=', new DateTime($to));
}
return $query->get();
}
public function search($input)
{
$query = Post::query();
$columns = Schema::getColumnListing('posts');
$attributes = array();
foreach ($columns as $attribute) {
if (isset($input[$attribute]) and !empty($input[$attribute])) {
$query->where($attribute, $input[$attribute]);
$attributes[$attribute] = $input[$attribute];
} else {
$attributes[$attribute] = null;
}
}
return [$query->get(), $attributes];
}
public function image_bg_upload(Request $request)
{
$post = Post::query()->findOrFail($request->input('post_id'));
$img = $post->id . "-bg." . $request->file('image-bg')->getClientOriginalExtension();
$post->image = "upload/{$img}";
$post->save();
$request->file('image-bg')->move(public_path('img') . '/upload', $img);
return "{ }";
}
