src/App/Entity/ExternalPartner/ExternalPartnerEventAggregation.php line 15

Open in your IDE?
  1. <?php
  3. namespace App\Entity\ExternalPartner;
  5. use DateTime;
  6. use Doctrine\ORM\Mapping as ORM;
  8. /**
  9. * @ORM\Entity
  10. *
  11. * @ORM\Table(
  12. * name="external_partner_event_aggregations"
  13. * )
  14. */
  15. class ExternalPartnerEventAggregation
  16. {
  17. public const RESOLUTION_DAILY = 1;
  18. public const RESOLUTION_WEEKLY = 2;
  19. public const RESOLUTION_MONTHLY = 3;
  20. public const RESOLUTION_ALLTIME = 4;
  21. public const AGGREGATION_TYPE_RECURRENT_JOB_CREATED = 0;
  22. public const AGGREGATION_TYPE_RECURRENT_JOB_UPDATED = 1;
  23. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL = 2;
  24. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_REGISTERED = 3;
  25. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_UNREGISTERED = 4;
  26. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_WITH_CV = 5;
  27. public const AGGREGATION_TYPE_JOBRADAR_CREATED = 6;
  28. public const AGGREGATION_TYPE_PREMIUM_JOBRADAR_CREATED = 7;
  29. public const AGGREGATION_TYPE_RECURRENT_JOB_SHARE_PAGE_REQUESTED = 8;
  30. public const AGGREGATION_TYPE_USER_CREATED = 9;
  31. public const AGGREGATION_TYPE_RECURRENT_JOB_HAS_BEEN_PROLONGED = 10;
  32. public const AGGREGATION_TYPE_RECURRENT_JOB_HAS_BEEN_REACTIVATED_BECAUSE_QUOTA_BECAME_AVAILABLE_AGAIN = 11;
  33. public const AGGREGATION_TYPE_RECURRENT_JOB_HAS_BEEN_DEACTIVATED = 12;
  34. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED = 13;
  35. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_CONTENT_DISTRIBUTION_PARTNER = 14;
  36. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_JOBLIFT = 15;
  37. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_TALENTCOM = 16;
  38. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_JOBRAPIDO = 17;
  39. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_INDEED = 18;
  40. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_EBAY = 19;
  41. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_KIMETA = 20;
  42. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_STELLENONLINE = 21;
  43. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_GOOGLE_FOR_JOBS = 22;
  44. public const AGGREGATION_TYPE_RECURRENT_JOB_HAS_BEEN_REACTIVATED_BECAUSE_RECURRENT_JOBS_LIMIT_HAS_CAPACITY_AGAIN = 23;
  45. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_AGENTUR_FUER_ARBEIT = 24;
  46. public const AGGREGRATION_TYPE_FORWARDED_ON_PLATFORM_SITE_JOBOO = 25;
  47. public const AGGREGRATION_TYPE_FORWARDED_ON_PLATFORM_SITE_JOBOO_ONLINE = 26;
  48. public const AGGREGRATION_TYPE_FORWARDED_ON_PLATFORM_SITE_RECRUIT_DL = 27;
  49. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_CONTENT_DISTRIBUTION_PARTNER = 28;
  50. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_JOBLIFT = 29;
  51. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_TALENTCOM = 30;
  52. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_JOBRAPIDO = 31;
  53. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_INDEED = 32;
  54. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_EBAY = 33;
  55. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_KIMETA = 34;
  56. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_STELLENONLINE = 35;
  57. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_GOOGLE_FOR_JOBS = 36;
  58. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_AGENTUR_FUER_ARBEIT = 37;
  59. public const AGGREGRATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_ON_PLATFORM_SITE_JOBOO = 38;
  60. public const AGGREGRATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_ON_PLATFORM_SITE_JOBOO_ONLINE = 39;
  61. public const AGGREGRATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_ON_PLATFORM_SITE_RECRUIT_DL = 40;
  62. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_FACEBOOK = 41;
  63. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_GOOGLE_ADS = 42;
  64. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_FACEBOOK = 43;
  65. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_GOOGLE_ADS = 44;
  66. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_MEINESTADT = 45;
  67. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_MEINESTADT = 46;
  68. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_JOBIJOBA = 47;
  69. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_JOBIJOBA = 48;
  70. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_WHATJOBS = 49;
  71. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_WHATJOBS = 50;
  72. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_JOOBLE = 51;
  73. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_JOOBLE = 52;
  74. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_CRITEO = 53;
  75. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_CRITEO = 54;
  76. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_PERSPECTIVE = 55;
  77. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_STEPSTONE = 56;
  78. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_STEPSTONE = 57;
  79. public const AGGREGATION_TYPE_EXTENDED_APPLICATION_HAS_BEEN_CREATED_VIA_PERSOMATCH = 58;
  80. public const AGGREGATION_TYPE_FORWARDED_TO_EXTERNAL_PARTNER_URL_VIA_PERSOMATCH = 59;
  82. /**
  83. * (Note that we use CET and CEST interchangeably here, because we mean the time in Germany, regardless of whether
  84. * it's winter or summer time.).
  85. *
  86. * We normally store all timestamps in our DB tables as UTC date-times only. However, this is not possible here.
  87. * The reason is that we need to report the aggregated values for a timezone. Because the
  88. * "resolution starting at" info is not a discrete point in time which can later be recalculated
  89. * safely to the corresponding point in time in any other timezone, we would end up with wrong data.
  90. * Instead, the timestamp refers to the first timestamp of a whole day, week, or month.
  91. *
  92. * Sadly, we cannot store both timestamps together.
  93. *
  94. * Here's why: It's 22:59 o'clock in UTC and 23:59 o'clock in CET on January 1, 2021.
  95. *
  96. * The timestamps are thus: 2021-01-01 22:59:00 in UTC and 2021-01-01 23:59:00 in CET.
  97. *
  98. * A row is inserted or updated that says that the $numberOfOccurrences for $aggregationType X on that day is 10,
  99. * like this:
  100. *
  101. * resolution=day
  102. * aggregationType=X
  103. * resolutionStartingAtUtc=2021-01-01 00:00:00
  104. * resolutionStartingAtCet=2021-01-01 00:00:00
  105. * numberOfOccurrences=10
  106. *
  107. * Here is what would happen 3 minutes later:
  108. *
  109. * It's now 23:02 o'clock on January 1, 2021 in UTC, but 00:02 o'clock in CET on January 2(!), 2021.
  110. *
  111. * The $numberOfOccurrences for UTC would need to be increased from 10 to 11, because the event occured while it
  112. * was still January 1 in UTC.
  113. *
  114. * But if we would update the above row accordingly, like this:
  115. *
  116. * resolution=day
  117. * aggregationType=X
  118. * resolutionStartingAtUtc=2021-01-01 00:00:00
  119. * resolutionStartingAtCet=2021-01-01 00:00:00
  120. * numberOfOccurrences=11
  121. *
  122. * then the information is now correct for UTC, but incorrect for CET, because the 11th occurrence happened
  123. * while it was already January 2 in CET.
  124. *
  125. * Thus, it would be correct to persist that
  126. * the numberOfOccurrences=10 where resolutionStartingAtCet=2021-01-01 00:00:00,
  127. * and numberOfOccurrences=1 where resolutionStartingAtCet=2021-01-02 00:00:00.
  128. *
  129. * If we have the UTC and CET timestamp together in one row, it is not possible to persist the data correctly.
  130. *
  131. * We therefore aggregate twice, with one row where the date-time is from UTC and one from CET.
  132. */
  134. /**
  135. * @ORM\Column(name="timezone", type="smallint", nullable=false)
  136. *
  137. * @ORM\Id
  138. */
  139. private int $timezone;
  141. /**
  142. * @ORM\Column(name="resolution", type="smallint", nullable=false)
  143. *
  144. * @ORM\Id
  145. */
  146. private int $resolution;
  148. /**
  149. * @ORM\Column(name="aggregation_type", type="smallint", nullable=false)
  150. *
  151. * @ORM\Id
  152. */
  153. private int $aggregationType;
  155. /**
  156. * @ORM\Column(name="resolution_starting_at", type="datetime", nullable=false)
  157. *
  158. * @ORM\Id
  159. */
  160. private DateTime $resolutionStartingAt;
  162. /**
  163. * @ORM\Column(name="integrated_external_partner_customer_id", type="guid", nullable=false)
  164. *
  165. * @ORM\Id
  166. */
  167. protected string $integratedExternalPartnerCustomerId;
  169. /**
  170. * @ORM\Column(name="number_of_occurrences", type="integer", nullable=false)
  171. */
  172. private int $numberOfOccurrences;
  173. }