Blame view

app/Repositories/PostRepository.php 1.52 KB
e77200db5   nologostudio.ru   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');
      }
  }