src/Entity/School.php line 14

1. <?php
3. namespace App\Entity;
5. use App\Repository\SchoolRepository;
6. use App\Validatior\Constraints as IFEFAssert;
7. use Doctrine\Common\Collections\ArrayCollection;
8. use Doctrine\Common\Collections\Collection;
9. use Doctrine\ORM\Mapping as ORM;
11. #[ORM\Table(name: 'school')]
12. #[ORM\Entity(repositoryClass: SchoolRepository::class)]
13. #[ORM\HasLifecycleCallbacks]
14. class School {
15.     #[ORM\Id]
16.     #[ORM\GeneratedValue]
17.     #[ORM\Column(type: 'integer')]
18.     private ?int $id = null;
20.     #[ORM\Column(name: 'created_date', type: 'datetime', nullable: true)]
21.     private ?\DateTime $createdDate = null;
23.     #[ORM\Column(name: 'updated_date', type: 'datetime', nullable: true)]
24.     private ?\DateTime $updatedDate = null;
26.     #[ORM\Column(name: 'client_updated_date', type: 'datetime', nullable: true)]
27.     private ?\DateTime $clientUpdateDate = null;
29.     #[ORM\Column(name: 'name', type: 'string', length: 255)]
30.     private ?string $name;
32.     #[ORM\Column(name: 'type', type: 'string', length: 255)]
33.     private string $type;
35.     #[ORM\Column(name: 'agree_rgpd', type: 'boolean', nullable: true)]
36.     private bool $agreeRgpd = false;
38.     #[ORM\Column(name: 'description', type: 'text', nullable: true)]
39.     private ?string $description;
41.     #[ORM\Column(name: 'address_number', type: 'integer', nullable: true)]
42.     private ?int $addressNumber;
44.     #[ORM\Column(name: 'address_locality', type: 'string', nullable: true)]
45.     private ?string $addressLocality;
47.     #[ORM\Column(name: 'address_road', type: 'string', nullable: true)]
48.     private ?string $addressRoad;
50.     #[ORM\Column(name: 'phone_standard', type: 'string')]
51.     private ?string $phoneStandard = null;
53.     #[ORM\Column(name: 'phone_other', type: 'string', nullable: true)]
54.     private ?string $phoneOther;
56.     #[ORM\Column(name: 'email', type: 'string')]
57.     private ?string $email;
59.     #[ORM\Column(name: 'latitude', type: 'string', nullable: true)]
60.     private ?string $latitude;
62.     #[ORM\Column(name: 'longitude', type: 'string', nullable: true)]
63.     private ?string $longitude;
65.     #[ORM\Column(name: 'maps_address', type: 'string', nullable: true)]
66.     private ?string $mapsAddress;
68.     #[ORM\Column(name: 'other_activity1', type: 'string', nullable: true)]
69.     private ?string $otherActivity1;
71.     #[ORM\Column(name: 'other_activity2', type: 'string', nullable: true)]
72.     private ?string $otherActivity2;
74.     #[ORM\Column(name: 'other_activity3', type: 'string', nullable: true)]
75.     private ?string $otherActivity3;
77.     #[ORM\Column(name: 'other_activity4', type: 'string', nullable: true)]
78.     private ?string $otherActivity4;
80.     #[ORM\Column(name: 'other_activity5', type: 'string', nullable: true)]
81.     private ?string $otherActivity5;
83.     #[ORM\Column(name: 'other_activity6', type: 'string', nullable: true)]
84.     private ?string $otherActivity6;
86.     #[ORM\OneToMany(mappedBy: 'school', targetEntity: PersonDegree::class)]
87.     private Collection $personDegrees;
89.     #[ORM\Column(name: 'registration', type: 'string', length: 255, unique: true, nullable: true)]
90.     #[IFEFAssert\DuplicateSchoolRegistered]
91.     private ?string $registration;
93.     #[ORM\Column(name: 'other_degree', type: 'string', nullable: true)]
94.     private ?string $otherDegree;
97.     #[ORM\ManyToOne(targetEntity: City::class)]
98.     #[ORM\JoinColumn(name: 'id_city', referencedColumnName: 'id')]
99.     private ?City $city = null;
101.     #[ORM\ManyToOne(targetEntity: Region::class, inversedBy: 'schools')]
102.     #[ORM\JoinColumn(name: 'id_region', referencedColumnName: 'id')]
103.     private ?Region $region = null;
105.     #[ORM\ManyToOne(targetEntity: Country::class)]
106.     #[ORM\JoinColumn(name: 'id_country', referencedColumnName: 'id')]
107.     private ?Country $country = null;
109.     #[ORM\ManyToOne(targetEntity: Image::class, cascade: ['persist', 'remove'])]
110.     #[ORM\JoinColumn(name: 'id_image', referencedColumnName: 'id')]
111.     private Image $image;
113.     #[ORM\ManyToMany(targetEntity: Company::class)]
114.     #[ORM\JoinTable(name: 'schools_companies')]
115.     #[ORM\JoinColumn(name: 'school_id', referencedColumnName: 'id')]
116.     #[ORM\InverseJoinColumn(name: 'company_id', referencedColumnName: 'id')]
117.     private Collection $companies;
119.     #[ORM\ManyToMany(targetEntity: SocialNetwork::class, cascade: ['persist', 'remove'])]
120.     #[ORM\JoinTable(name: 'schools_socials')]
121.     #[ORM\JoinColumn(name: 'school_id', referencedColumnName: 'id')]
122.     #[ORM\InverseJoinColumn(name: 'social_id', referencedColumnName: 'id')]
123.     private Collection $socialNetworks;
125.     #[ORM\OneToOne(targetEntity: User::class)]
126.     #[ORM\JoinColumn(name: 'user_id', referencedColumnName: 'id', nullable: true)]
127.     private User $user;
129.     #[ORM\ManyToMany(targetEntity: Degree::class)]
130.     #[ORM\JoinTable(name: 'school_degrees1')]
131.     #[ORM\JoinColumn(name: 'school_id', referencedColumnName: 'id')]
132.     #[ORM\InverseJoinColumn(name: 'degree_id', referencedColumnName: 'id')]
133.     private Collection $degrees;
135.     #[ORM\ManyToOne(targetEntity: SectorArea::class)]
136.     #[ORM\JoinColumn(name: 'id_sector_area1', referencedColumnName: 'id')]
137.     private ?SectorArea $sectorArea1 = null;
139.     #[ORM\ManyToOne(targetEntity: SectorArea::class)]
140.     #[ORM\JoinColumn(name: 'id_sector_area2', referencedColumnName: 'id', nullable: true)]
141.     private ?SectorArea $sectorArea2 = null;
143.     #[ORM\ManyToOne(targetEntity: SectorArea::class)]
144.     #[ORM\JoinColumn(name: 'id_sector_area3', referencedColumnName: 'id', nullable: true)]
145.     private ?SectorArea $sectorArea3 = null;
147.     #[ORM\ManyToOne(targetEntity: SectorArea::class)]
148.     #[ORM\JoinColumn(name: 'id_sector_area4', referencedColumnName: 'id', nullable: true)]
149.     private ?SectorArea $sectorArea4 = null;
151.     #[ORM\ManyToOne(targetEntity: SectorArea::class)]
152.     #[ORM\JoinColumn(name: 'id_sector_area5', referencedColumnName: 'id', nullable: true)]
153.     private ?SectorArea $sectorArea5 = null;
155.     #[ORM\ManyToOne(targetEntity: SectorArea::class)]
156.     #[ORM\JoinColumn(name: 'id_sector_area6', referencedColumnName: 'id', nullable: true)]
157.     private ?SectorArea $sectorArea6 = null;
159.     #[ORM\ManyToMany(targetEntity: Activity::class)]
160.     #[ORM\JoinTable(name: 'school_activities1')]
161.     #[ORM\JoinColumn(name: 'school_id', referencedColumnName: 'id')]
162.     #[ORM\InverseJoinColumn(name: 'activity_id', referencedColumnName: 'id')]
163.     private Collection $activities1;
165.     #[ORM\ManyToMany(targetEntity: Activity::class)]
166.     #[ORM\JoinTable(name: 'school_activities2')]
167.     #[ORM\JoinColumn(name: 'school_id', referencedColumnName: 'id')]
168.     #[ORM\InverseJoinColumn(name: 'activity_id', referencedColumnName: 'id')]
169.     private Collection $activities2;
171.     #[ORM\ManyToMany(targetEntity: Activity::class)]
172.     #[ORM\JoinTable(name: 'school_activities3')]
173.     #[ORM\JoinColumn(name: 'school_id', referencedColumnName: 'id')]
174.     #[ORM\InverseJoinColumn(name: 'activity_id', referencedColumnName: 'id')]
175.     private Collection $activities3;
177.     #[ORM\ManyToMany(targetEntity: Activity::class)]
178.     #[ORM\JoinTable(name: 'school_activities4')]
179.     #[ORM\JoinColumn(name: 'school_id', referencedColumnName: 'id')]
180.     #[ORM\InverseJoinColumn(name: 'activity_id', referencedColumnName: 'id')]
181.     private Collection $activities4;
183.     #[ORM\ManyToMany(targetEntity: Activity::class)]
184.     #[ORM\JoinTable(name: 'school_activities5')]
185.     #[ORM\JoinColumn(name: 'school_id', referencedColumnName: 'id')]
186.     #[ORM\InverseJoinColumn(name: 'activity_id', referencedColumnName: 'id')]
187.     private Collection $activities5;
189.     #[ORM\ManyToMany(targetEntity: Activity::class)]
190.     #[ORM\JoinTable(name: 'school_activities6')]
191.     #[ORM\JoinColumn(name: 'school_id', referencedColumnName: 'id')]
192.     #[ORM\InverseJoinColumn(name: 'activity_id', referencedColumnName: 'id')]
193.     private Collection $activities6;
195.     #[ORM\Column(name: 'location_mode', type: 'boolean', nullable: true)]
196.     private ?bool $locationMode;
198.     #[ORM\OneToMany(mappedBy: 'school', targetEntity: JobOffer::class, cascade: ['persist', 'remove'])]
199.     private Collection $jobOffers;
201.     public function __construct() {
202.         $this->socialNetworks = new ArrayCollection();
203.         $this->activities1 = new ArrayCollection();
204.         $this->activities2 = new ArrayCollection();
205.         $this->activities3 = new ArrayCollection();
206.         $this->activities4 = new ArrayCollection();
207.         $this->activities5 = new ArrayCollection();
208.         $this->activities6 = new ArrayCollection();
209.         $this->degrees = new ArrayCollection();
210.         $this->personDegrees = new ArrayCollection();
211.         $this->companies = new ArrayCollection();
212.         $this->jobOffers = new ArrayCollection();
213.     }
215.     public function getId(): ?int {
216.         return $this->id;
217.     }
219.     public function getCreatedDate(): ?\DateTime {
220.         return $this->createdDate;
221.     }
223.     public function setCreatedDate(?\DateTime $createdDate): self {
224.         $this->createdDate = $createdDate;
225.         return $this;
226.     }
228.     public function getUpdatedDate(): ?\DateTime {
229.         return $this->updatedDate;
230.     }
232.     public function setUpdatedDate(?\DateTime $updatedDate): self {
233.         $this->updatedDate = $updatedDate;
234.         return $this;
235.     }
237.     public function getClientUpdateDate(): ?\DateTime {
238.         return $this->clientUpdateDate;
239.     }
241.     public function setClientUpdateDate(?\DateTime $clientUpdateDate): self {
242.         $this->clientUpdateDate = $clientUpdateDate;
243.         return $this;
244.     }
246.     public function getName(): ?string {
247.         return $this->name;
248.     }
250.     public function setName(?string $name): self {
251.         $this->name = $name;
253.         return $this;
254.     }
256.     public function getType(): string {
257.         return $this->type;
258.     }
260.     public function setType(string $type): self {
261.         $this->type = $type;
262.         return $this;
263.     }
265.     public function isAgreeRgpd(): bool {
266.         return $this->agreeRgpd;
267.     }
269.     public function setAgreeRgpd(bool $agreeRgpd): self {
270.         $this->agreeRgpd = $agreeRgpd;
271.         return $this;
272.     }
274.     public function getDescription(): ?string {
275.         return $this->description;
276.     }
278.     public function setDescription(?string $description): void {
279.         $this->description = $description;
280.     }
282.     public function getCity(): ?City {
283.         return $this->city;
284.     }
286.     public function setCity(?City $city = null): self {
287.         $this->city = $city;
288.         return $this;
289.     }
291.     public function getRegion(): ?Region {
292.         return $this->region;
293.     }
295.     public function setRegion(?Region $region): self {
296.         $this->region = $region;
297.         return $this;
298.     }
300.     public function getCountry(): ?Country {
301.         return $this->country;
302.     }
304.     public function setCountry(?Country $country): self {
305.         $this->country = $country;
306.         return $this;
307.     }
309.     public function getAddressNumber(): ?int {
310.         return $this->addressNumber;
311.     }
313.     public function setAddressNumber(?int $addressNumber): void {
314.         $this->addressNumber = $addressNumber;
315.     }
317.     public function getAddressLocality(): ?string {
318.         return $this->addressLocality;
319.     }
321.     public function setAddressLocality(?string $addressLocality): void {
322.         $this->addressLocality = $addressLocality;
323.     }
325.     public function getAddressRoad(): ?string {
326.         return $this->addressRoad;
327.     }
329.     public function setAddressRoad(?string $addressRoad): void {
330.         $this->addressRoad = $addressRoad;
331.     }
333.     public function getPhoneStandard(): ?string {
334.         return $this->phoneStandard;
335.     }
337.     public function setPhoneStandard(?string $phoneStandard): void {
338.         $this->phoneStandard = $phoneStandard;
339.     }
341.     public function getPhoneOther(): ?string {
342.         return $this->phoneOther;
343.     }
345.     public function setPhoneOther(?string $phoneOther): self {
346.         $this->phoneOther = $phoneOther;
347.         return $this;
348.     }
350.     public function getEmail(): ?string {
351.         return $this->email;
352.     }
354.     public function setEmail(?string $email): void {
355.         $this->email = $email;
356.     }
358.     public function getImage(): Image {
359.         return $this->image;
360.     }
362.     public function setImage(Image $image): void {
363.         $this->image = $image;
364.     }
366.     public function getRegistration(): ?string {
367.         return $this->registration;
368.     }
370.     public function setRegistration(?string $registration): self {
371.         $this->registration = $registration;
372.         return $this;
373.     }
375.     public function addSocialNetwork(SocialNetwork $socialNetwork): self {
376.         $this->socialNetworks->add($socialNetwork);
378.         return $this;
379.     }
381.     public function removeSocialNetwork(SocialNetwork $socialNetwork): bool {
382.         return $this->socialNetworks->removeElement($socialNetwork);
383.     }
385.     public function getSocialNetworks(): Collection {
386.         return $this->socialNetworks;
387.     }
389.     public function getLatitude(): ?string {
390.         return $this->latitude;
391.     }
393.     public function setLatitude(?string $latitude): self {
394.         $this->latitude = $latitude;
395.         return $this;
396.     }
398.     public function getLongitude(): ?string {
399.         return $this->longitude;
400.     }
402.     public function setLongitude(?string $longitude): self {
403.         $this->longitude = $longitude;
404.         return $this;
405.     }
407.     public function getMapsAddress(): ?string {
408.         return $this->mapsAddress;
409.     }
411.     public function setMapsAddress(?string $mapsAddress): self {
412.         $this->mapsAddress = $mapsAddress;
413.         return $this;
414.     }
416.     public function __toString() {
417.         return $this->name . ', ' . $this->city->getName();
418.     }
420.     public function setUser(User $user = null): self {
421.         $this->user = $user;
423.         return $this;
424.     }
426.     public function getUser(): User {
427.         return $this->user;
428.     }
430.     public function getSectorArea1(): ?SectorArea {
431.         return $this->sectorArea1;
432.     }
434.     public function setSectorArea1(?SectorArea $sectorArea1): self {
435.         $this->sectorArea1 = $sectorArea1;
436.         return $this;
437.     }
439.     public function getSectorArea2(): ?SectorArea {
440.         return $this->sectorArea2;
441.     }
443.     public function setSectorArea2(?SectorArea $sectorArea2): self {
444.         $this->sectorArea2 = $sectorArea2;
445.         return $this;
446.     }
448.     public function getSectorArea3(): ?SectorArea {
449.         return $this->sectorArea3;
450.     }
452.     public function setSectorArea3(?SectorArea $sectorArea3): self {
453.         $this->sectorArea3 = $sectorArea3;
454.         return $this;
455.     }
457.     public function getSectorArea4(): ?SectorArea {
458.         return $this->sectorArea4;
459.     }
461.     public function setSectorArea4(?SectorArea $sectorArea4): self {
462.         $this->sectorArea4 = $sectorArea4;
463.         return $this;
464.     }
466.     public function getSectorArea5(): ?SectorArea {
467.         return $this->sectorArea5;
468.     }
470.     public function setSectorArea5(?SectorArea $sectorArea5): self {
471.         $this->sectorArea5 = $sectorArea5;
472.         return $this;
473.     }
475.     public function getSectorArea6(): ?SectorArea {
476.         return $this->sectorArea6;
477.     }
479.     public function setSectorArea6(?SectorArea $sectorArea6): self {
480.         $this->sectorArea6 = $sectorArea6;
481.         return $this;
482.     }
484.     public function addActivities1(Activity $activities1): self {
485.         $this->activities1->add($activities1);
487.         return $this;
488.     }
490.     public function removeActivities1(Activity $activities1): void {
491.         $this->activities1->removeElement($activities1);
492.     }
494.     public function getActivities1(): Collection {
495.         return $this->activities1;
496.     }
498.     public function addActivities2(Activity $activities2): self {
499.         $this->activities2->add($activities2);
501.         return $this;
502.     }
504.     public function removeActivities2(Activity $activities2): void {
505.         $this->activities2->removeElement($activities2);
506.     }
508.     public function getActivities2(): Collection {
509.         return $this->activities2;
510.     }
512.     public function addActivities3(Activity $activities3): self {
513.         $this->activities3->add($activities3);
515.         return $this;
516.     }
518.     public function removeActivities3(Activity $activities3): void {
519.         $this->activities3->removeElement($activities3);
520.     }
522.     public function getActivities3(): Collection {
523.         return $this->activities3;
524.     }
526.     public function addActivities4(Activity $activities4): self {
527.         $this->activities4->add($activities4);
529.         return $this;
530.     }
532.     public function removeActivities4(Activity $activities4): void {
533.         $this->activities4->removeElement($activities4);
534.     }
536.     public function getActivities4(): Collection {
537.         return $this->activities4;
538.     }
540.     public function addDegree(Degree $degree): self {
541.         $this->degrees->add($degree);
543.         return $this;
544.     }
546.     public function removeDegree(Degree $degree): void {
547.         $this->degrees->removeElement($degree);
548.     }
550.     public function getDegrees(): Collection {
551.         return $this->degrees;
552.     }
554.     public function getOtherDegree(): ?string {
555.         return $this->otherDegree;
556.     }
558.     public function setOtherDegree(?string $otherDegree): self {
559.         $this->otherDegree = $otherDegree;
560.         return $this;
561.     }
563.     public function setOtherActivity1(?string $otherActivity1): self {
564.         $this->otherActivity1 = $otherActivity1;
566.         return $this;
567.     }
569.     public function getOtherActivity1(): ?string {
570.         return $this->otherActivity1;
571.     }
573.     public function setOtherActivity2(?string $otherActivity2): self {
574.         $this->otherActivity2 = $otherActivity2;
576.         return $this;
577.     }
579.     public function getOtherActivity2(): ?string {
580.         return $this->otherActivity2;
581.     }
583.     public function setOtherActivity3(?string $otherActivity3): self {
584.         $this->otherActivity3 = $otherActivity3;
586.         return $this;
587.     }
589.     public function getOtherActivity3(): ?string {
590.         return $this->otherActivity3;
591.     }
593.     public function setOtherActivity4(?string $otherActivity4): self {
594.         $this->otherActivity4 = $otherActivity4;
596.         return $this;
597.     }
599.     public function getOtherActivity4(): ?string {
600.         return $this->otherActivity4;
601.     }
603.     public function getOtherActivity5(): ?string {
604.         return $this->otherActivity5;
605.     }
607.     public function setOtherActivity5(?string $otherActivity5): self {
608.         $this->otherActivity5 = $otherActivity5;
609.         return $this;
610.     }
612.     public function getOtherActivity6(): ?string {
613.         return $this->otherActivity6;
614.     }
616.     public function setOtherActivity6(?string $otherActivity6): self {
617.         $this->otherActivity6 = $otherActivity6;
618.         return $this;
619.     }
622.     public function getAgreeRgpd(): bool {
623.         return $this->agreeRgpd;
624.     }
626.     public function addPersonDegree(PersonDegree $personDegree) {
627.         $this->personDegrees->add($personDegree);
629.         return $this;
630.     }
632.     public function removePersonDegree(PersonDegree $personDegree): void {
633.         $this->personDegrees->removeElement($personDegree);
634.     }
636.     public function getPersonDegrees(): Collection {
637.         return $this->personDegrees;
638.     }
640.     public function addCompany(Company $company): self {
641.         $this->companies->add($company);
643.         return $this;
644.     }
646.     public function removeCompany(Company $company): void {
647.         $this->companies->removeElement($company);
648.     }
650.     public function getCompanies(): Collection {
651.         return $this->companies;
652.     }
654.     public function addActivities5(Activity $activities5): self {
655.         $this->activities5->add($activities5);
657.         return $this;
658.     }
660.     public function removeActivities5(Activity $activities5): bool {
661.         return $this->activities5->removeElement($activities5);
662.     }
664.     public function getActivities5(): Collection {
665.         return $this->activities5;
666.     }
668.     public function addActivities6(Activity $activities6): self {
669.         $this->activities6->add($activities6);
671.         return $this;
672.     }
674.     public function removeActivities6(Activity $activities6): bool {
675.         return $this->activities6->removeElement($activities6);
676.     }
678.     public function getActivities6(): Collection {
679.         return $this->activities6;
680.     }
682.     public function isLocationMode(): ?bool {
683.         return $this->locationMode;
684.     }
686.     public function setLocationMode(?bool $locationMode): void {
687.         $this->locationMode = $locationMode;
688.     }
691.     #[ORM\PrePersist]
692.     public function prePersist(): void {
693.         if ($this->jobOffers->count()) {
694.             /** @var JobOffer $job */
695.             foreach ($this->jobOffers as $job) {
696.                 $job->setSchool($this);
697.             }
698.         }
699.     }
701.     public function removeJob(JobOffer $job): void {
702.         $this->jobOffers->removeElement($job);
703.     }
705.     public function addJobOffer(JobOffer $jobOffer): self {
706.         $this->jobOffers->add($jobOffer);
708.         return $this;
709.     }
711.     public function removeJobOffer(JobOffer $jobOffer): void {
712.         $this->jobOffers->removeElement($jobOffer);
713.     }
715.     public function getJobOffers(): Collection {
716.         return $this->jobOffers;
717.     }
719.     /**
720.      * @return Prefecture|null
721.      */
722.     public function getPrefecture(): ?Prefecture {
723.         return $this->city?->getPrefecture();
724.     }
726.     /**
727.      * @param Prefecture|null $prefecture
728.      * @return School
729.      */
730.     public function setPrefecture(?Prefecture $prefecture): School
731.     {
732.         return $this;
733.     }
735.     public function schoolPresentation(): string {
736.         if ($this->city) {
737.             return sprintf('%s (%s)', $this->getName(), $this->city->getName());
738.         }
740.         return $this->getName();
741.     }
742. }