src/Entity/Cvs/Enterprises.php line 36

Open in your IDE?
  1. <?php
  3. namespace App\Entity\Cvs;
  5. use App\Entity\Core\Users;
  6. use App\Entity\Core\Agencies;
  7. use Doctrine\DBAL\Types\Types;
  8. use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
  9. use Symfony\Component\Validator\Constraints as Assert;
  10. use Doctrine\ORM\Mapping as ORM;
  11. use Vich\UploaderBundle\Mapping\Annotation as Vich;
  12. use Symfony\Component\HttpFoundation\File\File;
  13. use Symfony\Component\HttpFoundation\File\UploadedFile;
  14. use Vich\UploaderBundle\Entity\File as EmbeddedFile;
  15. use Vich\UploaderBundle\Templating\Helper\UploaderHelper;
  17. /**
  18. * Enterprises
  19. *
  20. * Les index servent les mêmes requêtes que pour les offres : liste triée par
  21. * date, filtres de rattachement, et le `GROUP BY city, country` de l'export.
  22. * Voir `Jobs` pour le détail — et pour la façon de les APPLIQUER, qui n'est
  23. * pas automatique.
  24. *
  25. * @ORM\Table(name="cvs_enterprises", indexes={
  26. * @ORM\Index(name="idx_ent_online_updated", columns={"online", "updated_at"}),
  27. * @ORM\Index(name="idx_ent_city_ref", columns={"city_ref"}),
  28. * @ORM\Index(name="idx_ent_city_slug", columns={"city_slug"}),
  29. * @ORM\Index(name="idx_ent_area", columns={"area_code"}),
  30. * @ORM\Index(name="idx_ent_city_country", columns={"city", "country"})
  31. * })
  32. * @ORM\Entity(repositoryClass="App\Repository\Cvs\EnterprisesRepository")
  33. * @ORM\HasLifecycleCallbacks()
  34. * @Vich\Uploadable
  35. */
  36. class Enterprises
  37. {
  39. /**
  40. * @var integer
  41. *
  42. * @ORM\Column(name="id", type="integer")
  43. * @ORM\Id
  44. * @ORM\GeneratedValue(strategy="AUTO")
  45. */
  46. protected $id;
  48. /**
  49. * @var string
  50. *
  51. * @ORM\Column(name="created_at", type="datetime", nullable=true, options={"comment":"Date de création"})
  52. */
  53. private $createdAt;
  55. /**
  56. * @var string
  57. *
  58. * @ORM\Column(name="updated_at", type="datetime", nullable=true, options={"comment":"Date de mise à jour"})
  59. */
  60. private $updatedAt;
  62. /**
  63. * @var string
  64. *
  65. * @ORM\Column(name="category", type="string", length=255, nullable=true)
  66. */
  67. private $category;
  69. /**
  70. * @var string
  71. *
  72. * @ORM\Column(name="short_title", type="text", nullable=true)
  73. */
  74. private $shortTitle;
  76. /**
  77. * @var string
  78. *
  79. * @ORM\Column(name="short_description", type="text", nullable=true)
  80. */
  81. private $shortDescription;
  83. /**
  84. * @var string
  85. *
  86. * @ORM\Column(name="company_name", type="string", length=255, nullable=true)
  87. */
  88. private $companyName;
  90. /**
  91. * @var string
  92. *
  93. * @ORM\Column(name="address", type="string", length=255, nullable=true)
  94. */
  95. private $address;
  97. /**
  98. * @var string
  99. *
  100. * @ORM\Column(name="city", type="string", length=255, nullable=true)
  101. */
  102. private $city;
  104. /**
  105. * @var string
  106. *
  107. * @ORM\Column(name="zipcode", type="string", length=255, nullable=true)
  108. */
  109. private $zipcode;
  111. /**
  112. * ⚠️ MÊME BESOIN QUE LES OFFRES, MÊME SOLUTION.
  113. *
  114. * `city` est du texte libre. L'annuaire filtre dessus en `LIKE`,
  115. * avec les mêmes défauts : « Paris 15 » ne rejoint pas « Paris ».
  116. *
  117. * La RÉFÉRENCE identifie et survit à un renommage ; le SLUG adresse
  118. * et reste lisible ; `areaCode` se déduit de la ville, ou se choisit
  119. * quand il n'y en a pas.
  120. *
  121. * @var string|null
  122. *
  123. * @ORM\Column(name="city_ref", type="string", length=24, nullable=true)
  124. */
  125. private $cityRef;
  127. /**
  128. * @var string|null
  129. *
  130. * @ORM\Column(name="city_slug", type="string", length=190, nullable=true)
  131. */
  132. private $citySlug;
  134. /**
  135. * @var string|null
  136. *
  137. * @ORM\Column(name="area_code", type="string", length=8, nullable=true)
  138. */
  139. private $areaCode;
  141. /**
  142. * Le secteur d'activité, rattaché au référentiel des métiers.
  143. *
  144. * @var string|null
  145. *
  146. * @ORM\Column(name="trade_ref", type="string", length=24, nullable=true)
  147. */
  148. private $tradeRef;
  150. /**
  151. * @var string
  152. *
  153. * @ORM\Column(name="country", type="string", length=255, nullable=true)
  154. */
  155. private $country;
  157. /**
  158. * @var string
  159. *
  160. * @ORM\Column(name="website", type="string", length=255, nullable=true)
  161. */
  162. private $website;
  164. /**
  165. * @var string
  166. *
  167. * @ORM\Column(name="email", type="string", length=255, nullable=true)
  168. */
  169. private $email;
  171. /**
  172. * Le nombre de candidats intéressés que le recruteur n'a pas encore vus.
  173. *
  174. * ⚠️ UN COMPTEUR, PAS UNE DATE DE DERNIÈRE VISITE.
  175. *
  176. * Comparer `createdAt > lastSeenAt` obligerait à parcourir tous les
  177. * likes à chaque affichage de la coquille — donc sur CHAQUE page.
  178. * Un entier qu'on incrémente à l'écriture et qu'on remet à zéro à
  179. * la lecture coûte une colonne et zéro requête supplémentaire.
  180. *
  181. * @var int|null
  182. *
  183. * @ORM\Column(name="new_interests_count", type="integer", nullable=true, options={"default":0,"comment":"Candidats intéressés non encore consultés"})
  184. */
  185. private $newInterestsCount;
  187. /**
  188. * @var string
  189. *
  190. * @ORM\Column(name="phone", type="string", length=255, nullable=true)
  191. */
  192. private $phone;
  194. /**
  195. * @var string
  196. *
  197. * @ORM\Column(name="company_description", type="text", nullable=true)
  198. */
  199. private $companyDescription;
  201. /**
  202. * @var string
  203. *
  204. * @ORM\Column(name="contact_name", type="string", length=255, nullable=true)
  205. */
  206. private $contactName;
  208. /**
  209. * @var string
  210. *
  211. * @ORM\Column(name="contact_email", type="string", length=255, nullable=true)
  212. */
  213. private $contactEmail;
  215. /**
  216. * @var string
  217. *
  218. * @ORM\Column(name="contact_url", type="string", length=255, nullable=true)
  219. */
  220. private $contactURL;
  222. /**
  223. * NOTE: This is not a mapped field of entity metadata, just a simple property.
  224. *
  225. * @Vich\UploadableField(mapping="enterprises_logo", fileNameProperty="image.name", size="image.size", mimeType="image.mimeType", originalName="image.originalName", dimensions="image.dimensions")
  226. *
  227. * @var File|null
  228. */
  229. private $imageFile;
  231. /**
  232. * @ORM\Embedded(class="Vich\UploaderBundle\Entity\File")
  233. *
  234. * @var EmbeddedFile
  235. */
  236. private $image;
  238. /**
  239. * @var string
  240. *
  241. * @ORM\Column(name="online", type="boolean", nullable=true)
  242. */
  243. private $online;
  245. /**
  246. * @var string
  247. *
  248. * @ORM\Column(name="validation", type="boolean", nullable=true)
  249. */
  250. private $validation;
  252. /**
  253. * @var string
  254. *
  255. * @ORM\Column(name="verification", type="boolean", nullable=true)
  256. */
  257. private $verification;
  259. /**
  260. * @var \Users
  261. *
  262. * @ORM\ManyToOne(targetEntity="App\Entity\Core\Users")
  263. * @ORM\JoinColumns({
  264. * @ORM\JoinColumn(name="user_id", referencedColumnName="id", nullable=true)
  265. * })
  266. */
  267. protected $user;
  269. /**
  270. * @var string
  271. *
  272. * @ORM\Column(name="slug", type="string", length=255, nullable=true)
  273. */
  274. private $slug;
  276. /**
  277. * @var string
  278. *
  279. * @ORM\Column(name="locale", type="string", length=255, nullable=true)
  280. */
  281. private $locale;
  283. /**
  284. * @var string
  285. *
  286. * @ORM\Column(name="views", type="integer", length=11, nullable=true)
  287. */
  288. private $views;
  290. /**
  291. * @var string
  292. *
  293. * @ORM\Column(name="pointx", type="string", length=255, nullable=true)
  294. */
  295. private $pointx;
  297. /**
  298. * @var string
  299. *
  300. * @ORM\Column(name="pointy", type="string", length=255, nullable=true)
  301. */
  302. private $pointy;
  304. /**
  305. * @var \Agencies
  306. *
  307. * @ORM\ManyToOne(targetEntity="App\Entity\Core\Agencies")
  308. * @ORM\JoinColumns({
  309. * @ORM\JoinColumn(name="agency_id", referencedColumnName="id", nullable=true)
  310. * })
  311. */
  312. protected $agency;
  314. public function __construct()
  315. {
  316. $this->image = new \Vich\UploaderBundle\Entity\File();
  317. }
  319. /**
  320. * @ORM\PrePersist
  321. */
  322. public function setCreatedAtValue(): void
  323. {
  324. $this->setCreatedAt(new \DateTime("now"));
  325. $this->setUpdatedAt(new \DateTime("now"));
  326. }
  328. /**
  329. * @ORM\PreUpdate
  330. */
  331. public function setUpdatedAtValue(): void
  332. {
  333. $this->setUpdatedAt(new \DateTime("now"));
  334. }
  336. public function __toString()
  337. {
  338. return (string)$this->id;
  339. }
  341. /**
  342. * If manually uploading a file (i.e. not using Symfony Form) ensure an instance
  343. * of 'UploadedFile' is injected into this setter to trigger the update. If this
  344. * bundle's configuration parameter 'inject_on_load' is set to 'true' this setter
  345. * must be able to accept an instance of 'File' as the bundle will inject one here
  346. * during Doctrine hydration.
  347. *
  348. * @param File|UploadedFile|null $imageFile
  349. */
  350. public function setImageFile(?File $imageFile = null)
  351. {
  352. $this->imageFile = $imageFile;
  354. if (null !== $imageFile) {
  355. // It is required that at least one field changes if you are using doctrine
  356. // otherwise the event listeners won't be called and the file is lost
  357. $this->setUpdatedAt(new \DateTime("now"));
  358. }
  359. }
  361. public function getImageFile(): ?File
  362. {
  363. return $this->imageFile;
  364. }
  366. public function setImage(EmbeddedFile $image): void
  367. {
  368. $this->image = $image;
  369. }
  371. public function getImage(): ?EmbeddedFile
  372. {
  373. return $this->image;
  374. }
  376. public function getImageBase64(?string $projectDir = null): ?string
  377. {
  378. if (!$this->image || !$this->image->getName()) {
  379. return null;
  380. }
  382. if (!$projectDir) {
  383. return null; // ou throw new \Exception('Project dir required');
  384. }
  386. $filePath = $projectDir . '/files/cvs/' . $this->image->getName();
  388. if (!file_exists($filePath)) {
  389. return null;
  390. }
  392. $imageData = file_get_contents($filePath);
  393. $mimeType = $this->image->getMimeType() ?? mime_content_type($filePath);
  395. return 'data:' . $mimeType . ';base64,' . base64_encode($imageData);
  396. }
  398. public function getId(): ?int
  399. {
  400. return $this->id;
  401. }
  403. public function getCreatedAt(): ?\DateTimeInterface
  404. {
  405. return $this->createdAt;
  406. }
  408. public function setCreatedAt(?\DateTimeInterface $createdAt): static
  409. {
  410. $this->createdAt = $createdAt;
  412. return $this;
  413. }
  415. public function getUpdatedAt(): ?\DateTimeInterface
  416. {
  417. return $this->updatedAt;
  418. }
  420. public function setUpdatedAt(?\DateTimeInterface $updatedAt): static
  421. {
  422. $this->updatedAt = $updatedAt;
  424. return $this;
  425. }
  427. public function getCategory(): ?string
  428. {
  429. return $this->category;
  430. }
  432. public function setCategory(?string $category): static
  433. {
  434. $this->category = $category;
  436. return $this;
  437. }
  439. public function getCompanyName(): ?string
  440. {
  441. return $this->companyName;
  442. }
  444. public function setCompanyName(?string $companyName): static
  445. {
  446. $this->companyName = $companyName;
  448. return $this;
  449. }
  451. public function getAddress(): ?string
  452. {
  453. return $this->address;
  454. }
  456. public function setAddress(?string $address): static
  457. {
  458. $this->address = $address;
  460. return $this;
  461. }
  463. public function getCity(): ?string
  464. {
  465. return $this->city;
  466. }
  468. public function setCity(?string $city): static
  469. {
  470. $this->city = $city;
  472. return $this;
  473. }
  475. public function getZipcode(): ?string
  476. {
  477. return $this->zipcode;
  478. }
  480. public function setZipcode(?string $zipcode): static
  481. {
  482. $this->zipcode = $zipcode;
  484. return $this;
  485. }
  487. public function getCountry(): ?string
  488. {
  489. return $this->country;
  490. }
  492. public function setCountry(?string $country): static
  493. {
  494. $this->country = $country;
  496. return $this;
  497. }
  499. public function getWebsite(): ?string
  500. {
  501. return $this->website;
  502. }
  504. public function setWebsite(?string $website): static
  505. {
  506. $this->website = $website;
  508. return $this;
  509. }
  511. public function getEmail(): ?string
  512. {
  513. return $this->email;
  514. }
  516. public function setEmail(?string $email): static
  517. {
  518. $this->email = $email;
  520. return $this;
  521. }
  523. public function getPhone(): ?string
  524. {
  525. return $this->phone;
  526. }
  528. public function setPhone(?string $phone): static
  529. {
  530. $this->phone = $phone;
  532. return $this;
  533. }
  535. public function getCompanyDescription(): ?string
  536. {
  537. return $this->companyDescription;
  538. }
  540. public function setCompanyDescription(?string $companyDescription): static
  541. {
  542. $this->companyDescription = $companyDescription;
  544. return $this;
  545. }
  547. public function getContactName(): ?string
  548. {
  549. return $this->contactName;
  550. }
  552. public function setContactName(?string $contactName): static
  553. {
  554. $this->contactName = $contactName;
  556. return $this;
  557. }
  559. public function getContactEmail(): ?string
  560. {
  561. return $this->contactEmail;
  562. }
  564. public function setContactEmail(?string $contactEmail): static
  565. {
  566. $this->contactEmail = $contactEmail;
  568. return $this;
  569. }
  571. public function getContactURL(): ?string
  572. {
  573. return $this->contactURL;
  574. }
  576. public function setContactURL(?string $contactURL): static
  577. {
  578. $this->contactURL = $contactURL;
  580. return $this;
  581. }
  583. public function isOnline(): ?bool
  584. {
  585. return $this->online;
  586. }
  588. public function setOnline(?bool $online): static
  589. {
  590. $this->online = $online;
  592. return $this;
  593. }
  595. public function getSlug(): ?string
  596. {
  597. return $this->slug;
  598. }
  600. public function setSlug(?string $slug): static
  601. {
  602. $this->slug = $slug;
  604. return $this;
  605. }
  607. public function getLocale(): ?string
  608. {
  609. return $this->locale;
  610. }
  612. public function setLocale(?string $locale): static
  613. {
  614. $this->locale = $locale;
  616. return $this;
  617. }
  619. public function getNewInterestsCount(): int
  620. {
  621. return (int) $this->newInterestsCount;
  622. }
  624. public function setNewInterestsCount(?int $newInterestsCount): self
  625. {
  626. $this->newInterestsCount = max(0, (int) $newInterestsCount);
  628. return $this;
  629. }
  631. public function getUser(): ?Users
  632. {
  633. return $this->user;
  634. }
  636. public function setUser(?Users $user): static
  637. {
  638. $this->user = $user;
  640. return $this;
  641. }
  643. public function getShortTitle(): ?string
  644. {
  645. return $this->shortTitle;
  646. }
  648. public function setShortTitle(?string $shortTitle): static
  649. {
  650. $this->shortTitle = $shortTitle;
  652. return $this;
  653. }
  655. public function getShortDescription(): ?string
  656. {
  657. return $this->shortDescription;
  658. }
  660. public function setShortDescription(?string $shortDescription): static
  661. {
  662. $this->shortDescription = $shortDescription;
  664. return $this;
  665. }
  667. public function getViews(): ?int
  668. {
  669. return $this->views;
  670. }
  672. public function setViews(?int $views): static
  673. {
  674. $this->views = $views;
  676. return $this;
  677. }
  679. public function isValidation(): ?bool
  680. {
  681. return $this->validation;
  682. }
  684. public function setValidation(?bool $validation): static
  685. {
  686. $this->validation = $validation;
  688. return $this;
  689. }
  691. public function isVerification(): ?bool
  692. {
  693. return $this->verification;
  694. }
  696. public function setVerification(?bool $verification): static
  697. {
  698. $this->verification = $verification;
  700. return $this;
  701. }
  703. public function getPointx(): ?string
  704. {
  705. return $this->pointx;
  706. }
  708. public function setPointx(?string $pointx): static
  709. {
  710. $this->pointx = $pointx;
  712. return $this;
  713. }
  715. public function getPointy(): ?string
  716. {
  717. return $this->pointy;
  718. }
  720. public function setPointy(?string $pointy): static
  721. {
  722. $this->pointy = $pointy;
  724. return $this;
  725. }
  727. public function getAgency(): ?Agencies
  728. {
  729. return $this->agency;
  730. }
  732. public function setAgency(?Agencies $agency): static
  733. {
  734. $this->agency = $agency;
  736. return $this;
  737. }
  740. public function getCityRef(): ?string
  741. {
  742. return $this->cityRef;
  743. }
  745. public function setCityRef(?string $v): self
  746. {
  747. $this->cityRef = $v;
  749. return $this;
  750. }
  752. public function getCitySlug(): ?string
  753. {
  754. return $this->citySlug;
  755. }
  757. public function setCitySlug(?string $v): self
  758. {
  759. $this->citySlug = $v;
  761. return $this;
  762. }
  764. public function getAreaCode(): ?string
  765. {
  766. return $this->areaCode;
  767. }
  769. public function setAreaCode(?string $v): self
  770. {
  771. $this->areaCode = $v;
  773. return $this;
  774. }
  776. public function getTradeRef(): ?string
  777. {
  778. return $this->tradeRef;
  779. }
  781. public function setTradeRef(?string $v): self
  782. {
  783. $this->tradeRef = $v;
  785. return $this;
  786. }
  787. }