src/Entity/HousingCertificate.php line 15

  1. <?php
  3. namespace App\Entity;
  5. use App\Repository\HousingCertificateRepository;
  6. use Doctrine\Common\Collections\ArrayCollection;
  7. use Doctrine\Common\Collections\Collection;
  8. use Doctrine\DBAL\Types\Types;
  9. use Doctrine\ORM\Mapping as ORM;
  10. use Symfony\Component\HttpFoundation\File\File;
  11. use Vich\UploaderBundle\Mapping\Annotation as Vich;
  13. #[ORM\Entity(repositoryClass: HousingCertificateRepository::class)]
  14. #[Vich\Uploadable]
  15. class HousingCertificate
  16. {
  17.     #[ORM\Id]
  18.     #[ORM\GeneratedValue]
  19.     #[ORM\Column]
  20.     private ?int $id = null;
  22.     #[ORM\ManyToOne(targetEntity: User::class, inversedBy: 'housingCertificates')]
  23.     #[ORM\JoinColumn(nullable: false)]
  24.     private ?User $user = null;
  26.     #[ORM\Column(length: 255, nullable: true)]
  27.     private ?string $city = null;
  29.     #[ORM\Column(length: 255, nullable: true)]
  30.     private ?string $nationality = null;
  32.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  33.     private ?\DateTimeInterface $refusedAt = null;
  35.     #[ORM\Column(length: 255, nullable: true)]
  36.     private ?string $countryDelivery = null;
  38.     #[ORM\Column(length: 255, nullable: true)]
  39.     private ?string $issuingConsulate = null;
  41.     #[ORM\Column(length: 255, nullable: true)]
  42.     private ?string $type = null;
  44.     #[Vich\UploadableField(mapping: "departureCertificate_housing_file", fileNameProperty: "departureCertificateName")]
  45.     private ?File $pictureCertificate = null;
  47.     #[ORM\Column(length: 255, nullable: true)]
  48.     private ?string $departureCertificateName = null;
  50.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  51.     private ?\DateTimeInterface $uploadedAt = null;
  53.     #[ORM\Column(nullable: true)]
  54.     private ?bool $isBlock = null;
  56.     #[ORM\Column(length: 255, nullable: true)]
  57.     private ?string $civility = null;
  59.     #[ORM\Column(type: "boolean", nullable: true)]
  60.     private ?bool $approved = false;
  62.     #[ORM\Column(length: 255, nullable: true)]
  63.     private ?string $lastName = null;
  65.     #[ORM\Column(length: 255, nullable: true)]
  66.     private ?string $firstName = null;
  68.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  69.     private ?\DateTimeInterface $birthDate = null;
  71.     #[ORM\Column(length: 255, nullable: true)]
  72.     private ?string $passportNumber = null;
  74.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  75.     private ?\DateTimeInterface $startDate = null;
  77.     #[ORM\Column(nullable: true)]
  78.     private ?bool $isPaid = null;
  80.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  81.     private ?\DateTimeInterface $createdAt = null;
  83.     #[ORM\ManyToMany(targetEntity: Residence::class, inversedBy: 'housingCertificates')]
  84.     private Collection $residence;
  86.     #[ORM\ManyToMany(targetEntity: Building::class, inversedBy: 'housingCertificates')]
  87.     private Collection $building;
  89.     #[ORM\Column(length: 255)]
  90.     private ?string $identifierString = null;
  92.     #[ORM\Column(length: 255, nullable: true)]
  93.     private ?string $school = null;
  95.     #[ORM\Column(length: 255, nullable: true)]
  96.     private ?string $numberId = null;
  98.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  99.     private ?\DateTimeInterface $passportExpiryAt = null;
  101.     #[ORM\Column(length: 255, nullable: true)]
  102.     private ?string $email = null;
  104.     #[ORM\Column(nullable: true)]
  105.     private ?int $idFirstBuilding = null;
  107.     #[ORM\Column]
  108.     private ?bool $notCB = null;
  110.     #[ORM\Column(nullable: true)]
  111.     private ?bool $asPaymentArrival = null;
  113.     #[ORM\Column(nullable: false)]
  114.     private ?bool $isSendToConsulat = false;
  116.     #[ORM\Column(length: 255, nullable: true)]
  117.     private ?string $linkId = null;
  119.     #[ORM\Column(length: 255, nullable: true)]
  120.     private ?string $source = null;
  122.     #[ORM\OneToMany(mappedBy: 'housingCertificate', targetEntity: Document::class)]
  123.     private Collection $documents;
  125.     #[ORM\Column(type: 'boolean', nullable: true)]
  126.     private ?bool $isCredit = null;
  128.     public function getIsCredit(): ?bool
  129.     {
  130.         return $this->isCredit;
  131.     }
  133.     public function setIsCredit(?bool $isCredit): self
  134.     {
  135.         $this->isCredit = $isCredit;
  137.         return $this;
  138.     }
  140.     public function __construct()
  141.     {
  142.         $this->createdAt = new \DateTime();
  143.         $this->residence = new ArrayCollection();
  144.         $this->building = new ArrayCollection();
  145.         $this->documents = new ArrayCollection();
  146.     }
  148.     public function getExportData(): array
  149.     {
  150.         return [
  151.             [
  152.                 'ID' => $this->id,
  153.                 'User' => $this->user ? $this->user->getFullName() : '',
  154.                 'City' => $this->city,
  155.                 'Nationality' => $this->nationality,
  156.                 'Refused At' => $this->refusedAt ? $this->refusedAt->format('d/m/Y') : '',
  157.                 'Country Delivery' => $this->countryDelivery,
  158.                 'Issuing Consulate' => $this->issuingConsulate,
  159.                 'Type' => $this->type,
  160.                 'Is Block' => $this->isBlock ? 'Yes' : 'No',
  161.                 'Civility' => $this->civility,
  162.                 'Last Name' => $this->lastName,
  163.                 'First Name' => $this->firstName,
  164.                 'Birth Date' => $this->birthDate ? $this->birthDate->format('d/m/Y') : '',
  165.                 'Passport Number' => $this->passportNumber,
  166.                 'Start Date' => $this->startDate ? $this->startDate->format('d/m/Y') : '',
  167.                 'Is Paid' => $this->isPaid ? 'Yes' : 'No',
  168.                 'Created At' => $this->createdAt ? $this->createdAt->format('d/m/Y') : '',
  169.                 'Residence' => implode(', ', $this->residence->map(fn ($res) => $res->getName())->toArray()),
  170.                 'Building' => implode(', ', $this->building->map(fn ($build) => $build->getName())->toArray()),
  171.                 'Identifier String' => $this->identifierString,
  172.                 'School' => $this->school,
  173.                 'Number ID' => $this->numberId,
  174.                 'Passport Expiry At' => $this->passportExpiryAt ? $this->passportExpiryAt->format('d/m/Y') : '',
  175.                 'Email' => $this->email,
  176.                 'ID First Building' => $this->idFirstBuilding,
  177.                 'Not CB' => $this->notCB ? 'Yes' : 'No',
  178.                 'As Payment Arrival' => $this->asPaymentArrival ? 'Yes' : 'No',
  179.             ]
  180.         ];
  181.     }
  183.     // Add the exportToCSV method
  184.     public function exportToCSV($filename): void
  185.     {
  186.         $exportData = $this->getExportData();
  188.         $file = fopen($filename, 'w');
  189.         fputcsv($file, array_keys($exportData[0])); // Write the CSV header
  191.         foreach ($exportData as $data) {
  192.             fputcsv($file, $data); // Write each row of data
  193.         }
  195.         fclose($file);
  196.     }
  198.     public function getLinkId(): ?string
  199.     {
  200.         return $this->linkId;
  201.     }
  203.     public function setLinkId(?string $linkId): self
  204.     {
  205.         $this->linkId = $linkId;
  206.         return $this;
  207.     }
  209.     public function getSource(): ?string
  210.     {
  211.         return $this->source;
  212.     }
  214.     public function setSource(?string $source): self
  215.     {
  216.         $this->source = $source;
  217.         return $this;
  218.     }
  220.     public function getId(): ?int
  221.     {
  222.         return $this->id;
  223.     }
  225.     public function getUser(): ?User
  226.     {
  227.         return $this->user;
  228.     }
  230.     public function setUser(?User $user): self
  231.     {
  232.         $this->user = $user;
  233.         return $this;
  234.     }
  236.     public function getCity(): ?string
  237.     {
  238.         return $this->city;
  239.     }
  241.     public function setCity(?string $city): self
  242.     {
  243.         $this->city = $city;
  244.         return $this;
  245.     }
  247.     public function getNationality(): ?string
  248.     {
  249.         return $this->nationality;
  250.     }
  252.     public function setNationality(?string $nationality): self
  253.     {
  254.         $this->nationality = $nationality;
  255.         return $this;
  256.     }
  258.     public function getRefusedAt(): ?\DateTimeInterface
  259.     {
  260.         return $this->refusedAt;
  261.     }
  263.     public function setRefusedAt(?\DateTimeInterface $refusedAt): self
  264.     {
  265.         $this->refusedAt = $refusedAt;
  266.         return $this;
  267.     }
  269.     public function getCountryDelivery(): ?string
  270.     {
  271.         return $this->countryDelivery;
  272.     }
  274.     public function setCountryDelivery(?string $countryDelivery): self
  275.     {
  276.         $this->countryDelivery = $countryDelivery;
  277.         return $this;
  278.     }
  280.     public function getIssuingConsulate(): ?string
  281.     {
  282.         return $this->issuingConsulate;
  283.     }
  285.     public function setIssuingConsulate(?string $issuingConsulate): self
  286.     {
  287.         $this->issuingConsulate = $issuingConsulate;
  288.         return $this;
  289.     }
  291.     public function getType(): ?string
  292.     {
  293.         return $this->type;
  294.     }
  296.     public function setType(?string $type): self
  297.     {
  298.         $this->type = $type;
  299.         return $this;
  300.     }
  302.     public function getDepartureCertificateName(): ?string
  303.     {
  304.         return $this->departureCertificateName;
  305.     }
  307.     public function setDepartureCertificateName(?string $departureCertificateName): self
  308.     {
  309.         $this->departureCertificateName = $departureCertificateName;
  310.         return $this;
  311.     }
  313.     /**
  314.      * @return File|null
  315.      */
  316.     public function getPictureCertificate(): ?File
  317.     {
  318.         return $this->pictureCertificate;
  319.     }
  321.     /**
  322.      * @param File|null $pictureCertificate
  323.      */
  324.     public function setPictureCertificate(?File $pictureCertificate): void
  325.     {
  326.         $this->pictureCertificate = $pictureCertificate;
  327.         if ($pictureCertificate) {
  328.             $this->uploadedAt = new \DateTime('now');
  329.         }
  330.     }
  332.     public function isApproved(): bool
  333.     {
  334.         return $this->approved;
  335.     }
  337.     public function approve(): void
  338.     {
  339.         $this->approved = true;
  340.     }
  342.     public function getUploadedAt(): ?\DateTimeInterface
  343.     {
  344.         return $this->uploadedAt;
  345.     }
  347.     public function setUploadedAt(?\DateTimeInterface $uploadedAt): self
  348.     {
  349.         $this->uploadedAt = $uploadedAt;
  350.         return $this;
  351.     }
  353.     public function isIsBlock(): ?bool
  354.     {
  355.         return $this->isBlock;
  356.     }
  358.     public function setIsBlock(?bool $isBlock): self
  359.     {
  360.         $this->isBlock = $isBlock;
  361.         return $this;
  362.     }
  364.     public function getCivility(): ?string
  365.     {
  366.         return $this->civility;
  367.     }
  369.     public function setCivility(?string $civility): self
  370.     {
  371.         $this->civility = $civility;
  372.         return $this;
  373.     }
  375.     public function getLastName(): ?string
  376.     {
  377.         return $this->lastName;
  378.     }
  380.     public function setLastName(?string $lastName): self
  381.     {
  382.         $this->lastName = $lastName;
  383.         return $this;
  384.     }
  386.     public function getFirstName(): ?string
  387.     {
  388.         return $this->firstName;
  389.     }
  391.     public function setFirstName(?string $firstName): self
  392.     {
  393.         $this->firstName = $firstName;
  394.         return $this;
  395.     }
  397.     public function getBirthDate(): ?\DateTimeInterface
  398.     {
  399.         return $this->birthDate;
  400.     }
  402.     public function setBirthDate(?\DateTimeInterface $birthDate): self
  403.     {
  404.         $this->birthDate = $birthDate;
  405.         return $this;
  406.     }
  408.     public function getPassportNumber(): ?string
  409.     {
  410.         return $this->passportNumber;
  411.     }
  413.     public function setPassportNumber(?string $passportNumber): self
  414.     {
  415.         $this->passportNumber = $passportNumber;
  416.         return $this;
  417.     }
  419.     public function getStartDate(): ?\DateTimeInterface
  420.     {
  421.         return $this->startDate;
  422.     }
  424.     public function setStartDate(?\DateTimeInterface $startDate): self
  425.     {
  426.         $this->startDate = $startDate;
  427.         return $this;
  428.     }
  430.     public function isIsPaid(): ?bool
  431.     {
  432.         return $this->isPaid;
  433.     }
  435.     public function setIsPaid(?bool $isPaid): self
  436.     {
  437.         $this->isPaid = $isPaid;
  438.         return $this;
  439.     }
  441.     public function getCreatedAt(): ?\DateTimeInterface
  442.     {
  443.         return $this->createdAt;
  444.     }
  446.     public function setCreatedAt(?\DateTimeInterface $createdAt): self
  447.     {
  448.         $this->createdAt = $createdAt;
  449.         return $this;
  450.     }
  452.     /**
  453.      * @return Collection<int, Residence>
  454.      */
  455.     public function getResidence(): Collection
  456.     {
  457.         return $this->residence;
  458.     }
  460.     public function addResidence(Residence $residence): self
  461.     {
  462.         if (!$this->residence->contains($residence)) {
  463.             $this->residence->add($residence);
  464.         }
  466.         return $this;
  467.     }
  469.     public function removeResidence(Residence $residence): self
  470.     {
  471.         $this->residence->removeElement($residence);
  472.         return $this;
  473.     }
  475.     /**
  476.      * @return Collection<int, Building>
  477.      */
  478.     public function getBuilding(): Collection
  479.     {
  480.         return $this->building;
  481.     }
  483.     public function addBuilding(Building $building): self
  484.     {
  485.         if (!$this->building->contains($building)) {
  486.             $this->building->add($building);
  487.         }
  489.         return $this;
  490.     }
  492.     public function removeBuilding(Building $building): self
  493.     {
  494.         $this->building->removeElement($building);
  495.         return $this;
  496.     }
  498.     public function getIdentifierString(): ?string
  499.     {
  500.         return $this->identifierString;
  501.     }
  503.     public function setIdentifierString(string $identifierString): self
  504.     {
  505.         $this->identifierString = $identifierString;
  506.         return $this;
  507.     }
  509.     public function getSchool(): ?string
  510.     {
  511.         return $this->school;
  512.     }
  514.     public function setSchool(?string $school): self
  515.     {
  516.         $this->school = strtoupper($school);
  517.         return $this;
  518.     }
  520.     public function getNumberId(): ?string
  521.     {
  522.         return $this->numberId;
  523.     }
  525.     public function setNumberId(?string $numberId): self
  526.     {
  527.         $this->numberId = $numberId;
  528.         return $this;
  529.     }
  531.     public function getPassportExpiryAt(): ?\DateTimeInterface
  532.     {
  533.         return $this->passportExpiryAt;
  534.     }
  536.     public function setPassportExpiryAt(?\DateTimeInterface $passportExpiryAt): self
  537.     {
  538.         $this->passportExpiryAt = $passportExpiryAt;
  539.         return $this;
  540.     }
  542.     public function getEmail(): ?string
  543.     {
  544.         return $this->email;
  545.     }
  547.     public function setEmail(?string $email): self
  548.     {
  549.         $this->email = $email;
  550.         return $this;
  551.     }
  553.     public function getIdFirstBuilding(): ?int
  554.     {
  555.         return $this->idFirstBuilding;
  556.     }
  558.     public function setIdFirstBuilding(?int $idFirstBuilding): self
  559.     {
  560.         $this->idFirstBuilding = $idFirstBuilding;
  561.         return $this;
  562.     }
  564.     public function isNotCB(): ?bool
  565.     {
  566.         return $this->notCB;
  567.     }
  569.     public function setNotCB(bool $notCB): self
  570.     {
  571.         $this->notCB = $notCB;
  572.         return $this;
  573.     }
  575.     public function isAsPaymentArrival(): ?bool
  576.     {
  577.         return $this->asPaymentArrival;
  578.     }
  580.     public function setAsPaymentArrival(?bool $asPaymentArrival): self
  581.     {
  582.         $this->asPaymentArrival = $asPaymentArrival;
  583.         return $this;
  584.     }
  586.     public function isIsSendToConsulat(): ?bool
  587.     {
  588.         return $this->isSendToConsulat;
  589.     }
  591.     public function setIsSendToConsulat(?bool $isSendToConsulat): self
  592.     {
  593.         $this->isSendToConsulat = $isSendToConsulat;
  594.         return $this;
  595.     }
  597.     /**
  598.      * @return Collection<int, Document>
  599.      */
  600.     public function getDocuments(): Collection
  601.     {
  602.         return $this->documents;
  603.     }
  605.     public function addDocument(Document $document): self
  606.     {
  607.         if (!$this->documents->contains($document)) {
  608.             $this->documents[] = $document;
  609.             $document->setHousingCertificate($this);
  610.         }
  611.     
  612.         return $this;
  613.     }
  615.     public function removeDocument(Document $document): self
  616.     {
  617.         if ($this->documents->removeElement($document)) {
  618.             // set the owning side to null (unless already changed)
  619.             if ($document->getHousingCertificate() === $this) {
  620.                 $document->setHousingCertificate(null);
  621.             }
  622.         }
  624.         return $this;
  625.     }
  626. }