GroupInbox.php 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
  1. <?php
  2. declare(strict_types = 1);
  3. // {{{ License
  4. // This file is part of GNU social - https://www.gnu.org/software/social
  5. //
  6. // GNU social is free software: you can redistribute it and/or modify
  7. // it under the terms of the GNU Affero General Public License as published by
  8. // the Free Software Foundation, either version 3 of the License, or
  9. // (at your option) any later version.
  10. //
  11. // GNU social is distributed in the hope that it will be useful,
  12. // but WITHOUT ANY WARRANTY; without even the implied warranty of
  13. // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  14. // GNU Affero General Public License for more details.
  15. //
  16. // You should have received a copy of the GNU Affero General Public License
  17. // along with GNU social. If not, see <http://www.gnu.org/licenses/>.
  18. // }}}
  19. namespace Component\Group\Entity;
  20. use App\Core\Entity;
  21. use DateTimeInterface;
  22. /**
  23. * Entity for Group's inbox
  24. *
  25. * @category DB
  26. * @package GNUsocial
  27. *
  28. * @author Zach Copley <zach@status.net>
  29. * @copyright 2010 StatusNet Inc.
  30. * @author Mikael Nordfeldth <mmn@hethane.se>
  31. * @copyright 2009-2014 Free Software Foundation, Inc http://www.fsf.org
  32. * @author Hugo Sales <hugo@hsal.es>
  33. * @copyright 2020-2021 Free Software Foundation, Inc http://www.fsf.org
  34. * @license https://www.gnu.org/licenses/agpl.html GNU AGPL v3 or later
  35. */
  36. class GroupInbox extends Entity
  37. {
  38. // {{{ Autocode
  39. // @codeCoverageIgnoreStart
  40. private int $group_id;
  41. private int $activity_id;
  42. private DateTimeInterface $created;
  43. public function setGroupId(int $group_id): self
  44. {
  45. $this->group_id = $group_id;
  46. return $this;
  47. }
  48. public function getGroupId(): int
  49. {
  50. return $this->group_id;
  51. }
  52. public function setActivityId(int $activity_id): self
  53. {
  54. $this->activity_id = $activity_id;
  55. return $this;
  56. }
  57. public function getActivityId(): int
  58. {
  59. return $this->activity_id;
  60. }
  61. public function setCreated(DateTimeInterface $created): self
  62. {
  63. $this->created = $created;
  64. return $this;
  65. }
  66. public function getCreated(): DateTimeInterface
  67. {
  68. return $this->created;
  69. }
  70. // @codeCoverageIgnoreEnd
  71. // }}} Autocode
  72. public static function schemaDef(): array
  73. {
  74. return [
  75. 'name' => 'group_inbox',
  76. 'description' => 'Many-many table listing activities posted to a given group, or which groups a given activity was posted to',
  77. 'fields' => [
  78. 'group_id' => ['type' => 'int', 'foreign key' => true, 'target' => 'Group.id', 'multiplicity' => 'one to one', 'name' => 'group_inbox_group_id_fkey', 'not null' => true, 'description' => 'group receiving the activity'],
  79. 'activity_id' => ['type' => 'int', 'foreign key' => true, 'target' => 'Activity.id', 'multiplicity' => 'many to one', 'name' => 'group_inbox_activity_id_fkey', 'not null' => true, 'description' => 'activity received'],
  80. 'created' => ['type' => 'datetime', 'not null' => true, 'default' => 'CURRENT_TIMESTAMP', 'description' => 'date this record was created'],
  81. ],
  82. 'primary key' => ['group_id', 'activity_id'],
  83. 'indexes' => [
  84. 'group_inbox_activity_id_idx' => ['activity_id'],
  85. 'group_inbox_group_id_created_activity_id_idx' => ['group_id', 'created', 'activity_id'],
  86. 'group_inbox_created_idx' => ['created'],
  87. ],
  88. ];
  89. }
  90. }