src/Entity/UserSessionLog.php line 23

Open in your IDE?
  1. <?php
  3. namespace App\Entity;
  5. use DateTimeInterface;
  6. use Doctrine\ORM\Mapping as ORM;
  7. use Gedmo\Mapping\Annotation as Gedmo;
  8. use Symfony\Component\Uid\Uuid;
  10. /**
  11. * @ORM\Entity(repositoryClass="App\Repository\UserSessionLogRepository")
  12. * @ORM\Table(name="user_session_log",
  13. * indexes={
  14. * @ORM\Index(name="idx_session_user_id", columns={"user_id"}),
  15. * @ORM\Index(name="idx_session_username", columns={"username"}),
  16. * @ORM\Index(name="idx_session_login_at", columns={"login_at"}),
  17. * @ORM\Index(name="idx_session_logout_at", columns={"logout_at"}),
  18. * @ORM\Index(name="idx_session_active", columns={"logout_at", "last_activity_at"}),
  19. * @ORM\Index(name="idx_session_id", columns={"session_id"})
  20. * }
  21. * )
  22. */
  23. class UserSessionLog
  24. {
  25. /**
  26. * @ORM\Id
  27. * @ORM\Column(type="uuid", unique=true)
  28. * @ORM\GeneratedValue(strategy="CUSTOM")
  29. * @ORM\CustomIdGenerator(class="doctrine.uuid_generator")
  30. */
  31. private $id;
  33. /**
  34. * @ORM\ManyToOne(targetEntity="App\Entity\User")
  35. * @ORM\JoinColumn(name="user_id", referencedColumnName="id", nullable=true, onDelete="SET NULL")
  36. */
  37. private $user;
  39. /**
  40. * @ORM\Column(type="string", nullable=true)
  41. */
  42. private $username;
  44. /**
  45. * @ORM\Column(type="string", nullable=true)
  46. */
  47. private $email;
  49. /**
  50. * @ORM\Column(type="datetime", nullable=false, name="login_at")
  51. */
  52. private $loginAt;
  54. /**
  55. * @ORM\Column(type="datetime", nullable=true, name="logout_at")
  56. */
  57. private $logoutAt;
  59. /**
  60. * @ORM\Column(type="datetime", nullable=true, name="last_activity_at")
  61. */
  62. private $lastActivityAt;
  64. /**
  65. * @ORM\Column(type="integer", nullable=true)
  66. */
  67. private $duration;
  69. /**
  70. * @ORM\Column(type="string", nullable=true, name="ip_address")
  71. */
  72. private $ipAddress;
  74. /**
  75. * @ORM\Column(type="string", length=500, nullable=true, name="user_agent")
  76. */
  77. private $userAgent;
  79. /**
  80. * @ORM\Column(type="string", length=20, nullable=true, name="logout_type")
  81. */
  82. private $logoutType;
  84. /**
  85. * @ORM\Column(type="string", nullable=false, name="session_id")
  86. */
  87. private $sessionId;
  89. /**
  90. * @ORM\Column(type="datetime", nullable=true, name="deleted_at")
  91. */
  92. private $deletedAt;
  94. /**
  95. * @ORM\Column(type="datetime", nullable=false, name="updated_at", options={"default":"2022-01-01 00:00:00"})
  96. * @Gedmo\Timestampable(on="update")
  97. */
  98. private $updatedAt;
  100. /**
  101. * @ORM\Column(type="datetime", nullable=false, name="created_at", options={"default":"2022-01-01 00:00:00"})
  102. * @Gedmo\Timestampable(on="create")
  103. */
  104. private $createdAt;
  106. public function getId(): ?Uuid
  107. {
  108. return $this->id;
  109. }
  111. public function getUser(): ?User
  112. {
  113. return $this->user;
  114. }
  116. public function setUser(?User $user): static
  117. {
  118. $this->user = $user;
  119. return $this;
  120. }
  122. public function getUsername(): ?string
  123. {
  124. return $this->username;
  125. }
  127. public function setUsername(?string $username): static
  128. {
  129. $this->username = $username;
  130. return $this;
  131. }
  133. public function getEmail(): ?string
  134. {
  135. return $this->email;
  136. }
  138. public function setEmail(?string $email): static
  139. {
  140. $this->email = $email;
  141. return $this;
  142. }
  144. public function getLoginAt(): ?DateTimeInterface
  145. {
  146. return $this->loginAt;
  147. }
  149. public function setLoginAt(DateTimeInterface $loginAt): static
  150. {
  151. $this->loginAt = $loginAt;
  152. return $this;
  153. }
  155. public function getLogoutAt(): ?DateTimeInterface
  156. {
  157. return $this->logoutAt;
  158. }
  160. public function setLogoutAt(?DateTimeInterface $logoutAt): static
  161. {
  162. $this->logoutAt = $logoutAt;
  164. // Calculate duration if logout is set
  165. if ($logoutAt && $this->loginAt) {
  166. // Doctrine returns DateTime in UTC but DB stores in local time
  167. // Re-create DateTimes with correct timezone to fix timestamp calculation
  168. $loginLocal = new \DateTime(
  169. $this->loginAt->format('Y-m-d H:i:s'),
  170. new \DateTimeZone('Europe/Madrid')
  171. );
  172. $logoutLocal = new \DateTime(
  173. $logoutAt->format('Y-m-d H:i:s'),
  174. new \DateTimeZone('Europe/Madrid')
  175. );
  176. $this->duration = $logoutLocal->getTimestamp() - $loginLocal->getTimestamp();
  177. }
  179. return $this;
  180. }
  182. public function getLastActivityAt(): ?DateTimeInterface
  183. {
  184. return $this->lastActivityAt;
  185. }
  187. public function setLastActivityAt(?DateTimeInterface $lastActivityAt): static
  188. {
  189. $this->lastActivityAt = $lastActivityAt;
  190. return $this;
  191. }
  193. public function getDuration(): ?int
  194. {
  195. return $this->duration;
  196. }
  198. public function setDuration(?int $duration): static
  199. {
  200. $this->duration = $duration;
  201. return $this;
  202. }
  204. public function getDurationFormatted(): ?string
  205. {
  206. if (!$this->duration) {
  207. return null;
  208. }
  210. $hours = floor($this->duration / 3600);
  211. $minutes = floor(($this->duration % 3600) / 60);
  212. $seconds = $this->duration % 60;
  214. if ($hours > 0) {
  215. return sprintf('%dh %dm', $hours, $minutes);
  216. } elseif ($minutes > 0) {
  217. return sprintf('%dm %ds', $minutes, $seconds);
  218. } else {
  219. return sprintf('%ds', $seconds);
  220. }
  221. }
  223. public function getIpAddress(): ?string
  224. {
  225. return $this->ipAddress;
  226. }
  228. public function setIpAddress(?string $ipAddress): static
  229. {
  230. $this->ipAddress = $ipAddress;
  231. return $this;
  232. }
  234. public function getUserAgent(): ?string
  235. {
  236. return $this->userAgent;
  237. }
  239. public function setUserAgent(?string $userAgent): static
  240. {
  241. $this->userAgent = $userAgent;
  242. return $this;
  243. }
  245. public function getSessionId(): ?string
  246. {
  247. return $this->sessionId;
  248. }
  250. public function setSessionId(string $sessionId): static
  251. {
  252. $this->sessionId = $sessionId;
  253. return $this;
  254. }
  256. public function getLogoutType(): ?string
  257. {
  258. return $this->logoutType;
  259. }
  261. public function setLogoutType(?string $logoutType): static
  262. {
  263. $this->logoutType = $logoutType;
  264. return $this;
  265. }
  267. public function getDeletedAt(): ?DateTimeInterface
  268. {
  269. return $this->deletedAt;
  270. }
  272. public function setDeletedAt(?DateTimeInterface $deletedAt): static
  273. {
  274. $this->deletedAt = $deletedAt;
  275. return $this;
  276. }
  278. public function getUpdatedAt(): ?DateTimeInterface
  279. {
  280. return $this->updatedAt;
  281. }
  283. public function setUpdatedAt(DateTimeInterface $updatedAt): static
  284. {
  285. $this->updatedAt = $updatedAt;
  286. return $this;
  287. }
  289. public function getCreatedAt(): ?DateTimeInterface
  290. {
  291. return $this->createdAt;
  292. }
  294. public function setCreatedAt(DateTimeInterface $createdAt): static
  295. {
  296. $this->createdAt = $createdAt;
  297. return $this;
  298. }
  300. public function isActive(): bool
  301. {
  302. return $this->logoutAt === null;
  303. }
  305. public function __toString(): string
  306. {
  307. return sprintf(
  308. '%s - %s (%s)',
  309. $this->username ?? 'Unknown',
  310. $this->loginAt?->format('d/m/Y H:i:s') ?? '',
  311. $this->isActive() ? 'Activo' : 'Cerrado'
  312. );
  313. }
  314. }