Blame view
app/Repositories/PostRepository.php
1.52 KB
e77200db5 Initial commit |
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 |
<?php namespace FootyRoom\Repositories; use FootyRoom\Core\Post\Post; use FootyRoom\Support\AutoMapper; use Illuminate\Database\Connection; class PostRepository { /** * @var \Illuminate\Database\Connection */ protected $mysql; /** * Constructor. * * @param \Illuminate\Database\Connection $mysql */ public function __construct(Connection $mysql) { $this->mysql = $mysql; } /** * Finds post by id. * * @param int $id * * @return \FootyRoom\Core\Post\Post */ public function findById($id) { $postDto = $this->mysql ->table('wp_posts') ->select([ 'id', 'post_title as title', 'comment_status as discussionStatus', 'post_status as status', ]) ->where('ID', '=', $id) ->first(); if (!$postDto) { return null; } return AutoMapper::map($postDto, Post::class); } /** * Increment posts comment count. * * @param int $postId */ public function incrementCommentCount($postId) { $this->mysql ->table('wp_posts') ->where('ID', '=', $postId) ->increment('comment_count'); } /** * Decrement posts comment count. * * @param int $postId */ public function decrementCommentCount($postId) { $this->mysql ->table('wp_posts') ->where('ID', '=', $postId) ->decrement('comment_count'); } } |