src/JanusHercules/RecurrentJobsCheapSearch/Domain/Entity/CheapSearchRecurrentJob.php line 19

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace JanusHercules\RecurrentJobsCheapSearch\Domain\Entity;
  7. use DateTime;
  8. use Doctrine\ORM\Mapping as ORM;
  10. /**
  11. * Denormalized, pre-computed data structure for cheap/fast MariaDB-based job search.
  12. * This table is populated via sync command and swapped atomically for zero-downtime updates.
  13. */
  14. #[ORM\Entity]
  15. #[ORM\Table(name: 'cheap_search_recurrent_jobs')]
  16. #[ORM\Index(name: 'csrj_status_locked_paused_idx', columns: ['status', 'is_locked', 'profile_paused_since'])]
  17. #[ORM\Index(name: 'csrj_effective_zipcode_idx', columns: ['effective_zipcode'])]
  18. #[ORM\Index(name: 'csrj_freshness_date_idx', columns: ['freshness_date'])]
  19. class CheapSearchRecurrentJob
  20. {
  21. #[ORM\Id]
  22. #[ORM\Column(name: 'recurrent_job_id', type: 'string', length: 36)]
  23. private string $recurrentJobId;
  25. /**
  26. * Cleaned searchterm for FULLTEXT matching (gender suffixes, prices, years removed).
  27. */
  28. #[ORM\Column(name: 'occupational_field_searchterm', type: 'string', length: 1024)]
  29. private string $occupationalFieldSearchterm;
  31. #[ORM\Column(name: 'title', type: 'string', length: 512)]
  32. private string $title;
  34. #[ORM\Column(name: 'company_name', type: 'string', length: 255)]
  35. private string $companyName;
  37. /**
  38. * COALESCE(recurrent_jobs.zipcode, jobofferer_profiles.zipcode).
  39. */
  40. #[ORM\Column(name: 'effective_zipcode', type: 'string', length: 8)]
  41. private string $effectiveZipcode;
  43. /**
  44. * Pre-computed zipcodes within 1km (comma-separated).
  45. */
  46. #[ORM\Column(name: 'zipcode_radius_1', type: 'text')]
  47. private string $zipcodeRadius1;
  49. /**
  50. * Pre-computed zipcodes within 2km (comma-separated).
  51. */
  52. #[ORM\Column(name: 'zipcode_radius_2', type: 'text')]
  53. private string $zipcodeRadius2;
  55. /**
  56. * Pre-computed zipcodes within 5km (comma-separated).
  57. */
  58. #[ORM\Column(name: 'zipcode_radius_5', type: 'text')]
  59. private string $zipcodeRadius5;
  61. /**
  62. * Pre-computed zipcodes within 10km (comma-separated).
  63. */
  64. #[ORM\Column(name: 'zipcode_radius_10', type: 'text')]
  65. private string $zipcodeRadius10;
  67. /**
  68. * Pre-computed zipcodes within 15km (comma-separated).
  69. */
  70. #[ORM\Column(name: 'zipcode_radius_15', type: 'text')]
  71. private string $zipcodeRadius15;
  73. /**
  74. * Pre-computed zipcodes within 20km (comma-separated).
  75. */
  76. #[ORM\Column(name: 'zipcode_radius_20', type: 'text')]
  77. private string $zipcodeRadius20;
  79. /**
  80. * Pre-computed zipcodes within 30km (comma-separated).
  81. */
  82. #[ORM\Column(name: 'zipcode_radius_30', type: 'text')]
  83. private string $zipcodeRadius30;
  85. /**
  86. * Pre-computed zipcodes within 50km (comma-separated).
  87. */
  88. #[ORM\Column(name: 'zipcode_radius_50', type: 'text')]
  89. private string $zipcodeRadius50;
  91. /**
  92. * Pre-computed zipcodes within 100km (comma-separated).
  93. */
  94. #[ORM\Column(name: 'zipcode_radius_100', type: 'text')]
  95. private string $zipcodeRadius100;
  97. /**
  98. * Pre-computed zipcodes within 200km (comma-separated).
  99. */
  100. #[ORM\Column(name: 'zipcode_radius_200', type: 'text')]
  101. private string $zipcodeRadius200;
  103. /**
  104. * Comma-separated integers (e.g., "1,2").
  105. */
  106. #[ORM\Column(name: 'career_levels', type: 'string', length: 32)]
  107. private string $careerLevels;
  109. /**
  110. * Comma-separated integers (e.g., "0,1,2,3").
  111. */
  112. #[ORM\Column(name: 'employment_types', type: 'string', length: 32)]
  113. private string $employmentTypes;
  115. /**
  116. * RecurrentJob status (1 = active).
  117. */
  118. #[ORM\Column(name: 'status', type: 'smallint')]
  119. private int $status;
  121. /**
  122. * Denormalized from users.is_locked_by_admin.
  123. */
  124. #[ORM\Column(name: 'is_locked', type: 'boolean')]
  125. private bool $isLocked;
  127. #[ORM\Column(name: 'profile_paused_since', type: 'datetime', nullable: true)]
  128. private ?DateTime $profilePausedSince;
  130. #[ORM\Column(name: 'freshness_date', type: 'datetime', nullable: true)]
  131. private ?DateTime $freshnessDate;
  133. #[ORM\Column(name: 'profile_lastseen_at', type: 'datetime', nullable: true)]
  134. private ?DateTime $profileLastseenAt;
  136. public function getRecurrentJobId(): string
  137. {
  138. return $this->recurrentJobId;
  139. }
  141. public function setRecurrentJobId(string $recurrentJobId): self
  142. {
  143. $this->recurrentJobId = $recurrentJobId;
  145. return $this;
  146. }
  148. public function getOccupationalFieldSearchterm(): string
  149. {
  150. return $this->occupationalFieldSearchterm;
  151. }
  153. public function setOccupationalFieldSearchterm(string $occupationalFieldSearchterm): self
  154. {
  155. $this->occupationalFieldSearchterm = $occupationalFieldSearchterm;
  157. return $this;
  158. }
  160. public function getTitle(): string
  161. {
  162. return $this->title;
  163. }
  165. public function setTitle(string $title): self
  166. {
  167. $this->title = $title;
  169. return $this;
  170. }
  172. public function getCompanyName(): string
  173. {
  174. return $this->companyName;
  175. }
  177. public function setCompanyName(string $companyName): self
  178. {
  179. $this->companyName = $companyName;
  181. return $this;
  182. }
  184. public function getEffectiveZipcode(): string
  185. {
  186. return $this->effectiveZipcode;
  187. }
  189. public function setEffectiveZipcode(string $effectiveZipcode): self
  190. {
  191. $this->effectiveZipcode = $effectiveZipcode;
  193. return $this;
  194. }
  196. public function getZipcodeRadius1(): string
  197. {
  198. return $this->zipcodeRadius1;
  199. }
  201. public function setZipcodeRadius1(string $zipcodeRadius1): self
  202. {
  203. $this->zipcodeRadius1 = $zipcodeRadius1;
  205. return $this;
  206. }
  208. public function getZipcodeRadius2(): string
  209. {
  210. return $this->zipcodeRadius2;
  211. }
  213. public function setZipcodeRadius2(string $zipcodeRadius2): self
  214. {
  215. $this->zipcodeRadius2 = $zipcodeRadius2;
  217. return $this;
  218. }
  220. public function getZipcodeRadius5(): string
  221. {
  222. return $this->zipcodeRadius5;
  223. }
  225. public function setZipcodeRadius5(string $zipcodeRadius5): self
  226. {
  227. $this->zipcodeRadius5 = $zipcodeRadius5;
  229. return $this;
  230. }
  232. public function getZipcodeRadius10(): string
  233. {
  234. return $this->zipcodeRadius10;
  235. }
  237. public function setZipcodeRadius10(string $zipcodeRadius10): self
  238. {
  239. $this->zipcodeRadius10 = $zipcodeRadius10;
  241. return $this;
  242. }
  244. public function getZipcodeRadius15(): string
  245. {
  246. return $this->zipcodeRadius15;
  247. }
  249. public function setZipcodeRadius15(string $zipcodeRadius15): self
  250. {
  251. $this->zipcodeRadius15 = $zipcodeRadius15;
  253. return $this;
  254. }
  256. public function getZipcodeRadius20(): string
  257. {
  258. return $this->zipcodeRadius20;
  259. }
  261. public function setZipcodeRadius20(string $zipcodeRadius20): self
  262. {
  263. $this->zipcodeRadius20 = $zipcodeRadius20;
  265. return $this;
  266. }
  268. public function getZipcodeRadius30(): string
  269. {
  270. return $this->zipcodeRadius30;
  271. }
  273. public function setZipcodeRadius30(string $zipcodeRadius30): self
  274. {
  275. $this->zipcodeRadius30 = $zipcodeRadius30;
  277. return $this;
  278. }
  280. public function getZipcodeRadius50(): string
  281. {
  282. return $this->zipcodeRadius50;
  283. }
  285. public function setZipcodeRadius50(string $zipcodeRadius50): self
  286. {
  287. $this->zipcodeRadius50 = $zipcodeRadius50;
  289. return $this;
  290. }
  292. public function getZipcodeRadius100(): string
  293. {
  294. return $this->zipcodeRadius100;
  295. }
  297. public function setZipcodeRadius100(string $zipcodeRadius100): self
  298. {
  299. $this->zipcodeRadius100 = $zipcodeRadius100;
  301. return $this;
  302. }
  304. public function getZipcodeRadius200(): string
  305. {
  306. return $this->zipcodeRadius200;
  307. }
  309. public function setZipcodeRadius200(string $zipcodeRadius200): self
  310. {
  311. $this->zipcodeRadius200 = $zipcodeRadius200;
  313. return $this;
  314. }
  316. public function getCareerLevels(): string
  317. {
  318. return $this->careerLevels;
  319. }
  321. public function setCareerLevels(string $careerLevels): self
  322. {
  323. $this->careerLevels = $careerLevels;
  325. return $this;
  326. }
  328. public function getEmploymentTypes(): string
  329. {
  330. return $this->employmentTypes;
  331. }
  333. public function setEmploymentTypes(string $employmentTypes): self
  334. {
  335. $this->employmentTypes = $employmentTypes;
  337. return $this;
  338. }
  340. public function getStatus(): int
  341. {
  342. return $this->status;
  343. }
  345. public function setStatus(int $status): self
  346. {
  347. $this->status = $status;
  349. return $this;
  350. }
  352. public function isLocked(): bool
  353. {
  354. return $this->isLocked;
  355. }
  357. public function setIsLocked(bool $isLocked): self
  358. {
  359. $this->isLocked = $isLocked;
  361. return $this;
  362. }
  364. public function getProfilePausedSince(): ?DateTime
  365. {
  366. return $this->profilePausedSince;
  367. }
  369. public function setProfilePausedSince(?DateTime $profilePausedSince): self
  370. {
  371. $this->profilePausedSince = $profilePausedSince;
  373. return $this;
  374. }
  376. public function getFreshnessDate(): ?DateTime
  377. {
  378. return $this->freshnessDate;
  379. }
  381. public function setFreshnessDate(?DateTime $freshnessDate): self
  382. {
  383. $this->freshnessDate = $freshnessDate;
  385. return $this;
  386. }
  388. public function getProfileLastseenAt(): ?DateTime
  389. {
  390. return $this->profileLastseenAt;
  391. }
  393. public function setProfileLastseenAt(?DateTime $profileLastseenAt): self
  394. {
  395. $this->profileLastseenAt = $profileLastseenAt;
  397. return $this;
  398. }
  399. }