src/Entity/HousingCertificate.php line 17

  1. <?php
  3. namespace App\Entity;
  4. 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;
  12. use EasyCorp\Bundle\EasyAdminBundle\Context\BatchContext;
  13. use Doctrine\ORM\EntityManagerInterface;
  15. #[ORM\Entity(repositoryClass: HousingCertificateRepository::class)]
  16. #[Vich\Uploadable]
  17. class HousingCertificate
  18. {
  19.     private EntityManagerInterface $entityManager;
  21.     #[ORM\Id]
  22.     #[ORM\GeneratedValue]
  23.     #[ORM\Column]
  24.     private ?int $id = null;
  26.     #[ORM\ManyToOne(inversedBy: 'housingCertificates')]
  27.     private ?User $user = null;
  29.     #[ORM\Column(length: 255, nullable: true)]
  30.     private ?string $city = null;
  32.     #[ORM\Column(length: 255, nullable: true)]
  33.     private ?string $nationality = null;
  35.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  36.     private ?\DateTimeInterface $refusedAt = null;
  38.     #[ORM\Column(length: 255, nullable: true)]
  39.     private ?string $countryDelivery = null;
  41.     #[ORM\Column(length: 255, nullable: true)]
  42.     private ?string $issuingConsulate = null;
  44.     #[ORM\Column(length: 255, nullable: true)]
  45.     private ?string $type = null;
  47.     #[Vich\UploadableField(mapping: "departureCertificate_housing_file", fileNameProperty: "departureCertificateName")]
  48.     private ?File $pictureCertificate = null;
  50.     #[ORM\Column(length: 255, nullable: true)]
  51.     private ?string $departureCertificateName = null;
  53.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  54.     private ?\DateTimeInterface $uploadedAt = null;
  56.     #[ORM\Column(nullable: true)]
  57.     private ?bool $isBlock = null;
  59.     #[ORM\Column(length: 255, nullable: true)]
  60.     private ?string $civility = null;
  62.         /**
  63.      * @ORM\Column(type="boolean")
  64.      */
  65.     private $approved = false;
  67.     #[ORM\Column(length: 255, nullable: true)]
  68.     private ?string $lastName = null;
  70.     #[ORM\Column(length: 255, nullable: true)]
  71.     private ?string $firstName = null;
  73.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  74.     private ?\DateTimeInterface $birthDate = null;
  76.     #[ORM\Column(length: 255, nullable: true)]
  77.     private ?string $passportNumber = null;
  79.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  80.     private ?\DateTimeInterface $startDate = null;
  82.     #[ORM\Column(nullable: true)]
  83.     private ?bool $isPaid = null;
  85.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  86.     private ?\DateTimeInterface $createdAt = null;
  88.     #[ORM\ManyToMany(targetEntity: Residence::class, inversedBy: 'housingCertificates')]
  89.     private Collection $residence;
  91.     #[ORM\ManyToMany(targetEntity: Building::class, inversedBy: 'housingCertificates')]
  92.     private Collection $building;
  94.     #[ORM\Column(length: 255)]
  95.     private ?string $identifierString = null;
  97.     #[ORM\Column(length: 255, nullable: true)]
  98.     private ?string $school = null;
  100.     #[ORM\Column(length: 255, nullable: true)]
  101.     private ?string $numberId = null;
  103.     #[ORM\Column(type: Types::DATETIME_MUTABLE, nullable: true)]
  104.     private ?\DateTimeInterface $passportExpiryAt = null;
  106.     #[ORM\Column(length: 255, nullable: true)]
  107.     private ?string $email = null;
  109.     #[ORM\Column(nullable: true)]
  110.     private ?int $idFirstBuilding = null;
  112.     #[ORM\Column]
  113.     private ?bool $notCB = null;
  115.     #[ORM\Column(nullable: true)]
  116.     private ?bool $asPaymentArrival = null;
  118.     #[ORM\Column(nullable: false)]
  119.     private ?bool $isSendToConsulat =false;
  121.     #[ORM\Column(length: 255, nullable: true)]
  122.     private ?string $linkId = null;
  124.     public function __construct()
  125.     {
  126.         $this->createdAt = new \DateTime();
  127.         $this->residence = new ArrayCollection();
  128.         $this->building = new ArrayCollection();
  129.     }
  131.     public function getExportData(): array
  132.     {
  133.         return [
  134.             [
  135.                 'ID' => $this->id,
  136.                 'User' => $this->user ? $this->user->getFullName() : '',
  137.                 'City' => $this->city,
  138.                 'Nationality' => $this->nationality,
  139.                 'Refused At' => $this->refusedAt ? $this->refusedAt->format('d/m/Y') : '',
  140.                 'Country Delivery' => $this->countryDelivery,
  141.                 'Issuing Consulate' => $this->issuingConsulate,
  142.                 'Type' => $this->type,
  143.                 'Is Block' => $this->isBlock ? 'Yes' : 'No',
  144.                 'Civility' => $this->civility,
  145.                 'Last Name' => $this->lastName,
  146.                 'First Name' => $this->firstName,
  147.                 'Birth Date' => $this->birthDate ? $this->birthDate->format('d/m/Y') : '',
  148.                 'Passport Number' => $this->passportNumber,
  149.                 'Start Date' => $this->startDate ? $this->startDate->format('d/m/Y') : '',
  150.                 'Is Paid' => $this->isPaid ? 'Yes' : 'No',
  151.                 'Created At' => $this->createdAt ? $this->createdAt->format('d/m/Y') : '',
  152.                 'Residence' => implode(', ', $this->residence->map(fn ($res) => $res->getName())->toArray()),
  153.                 'Building' => implode(', ', $this->building->map(fn ($build) => $build->getName())->toArray()),
  154.                 'Identifier String' => $this->identifierString,
  155.                 'School' => $this->school,
  156.                 'Number ID' => $this->numberId,
  157.                 'Passport Expiry At' => $this->passportExpiryAt ? $this->passportExpiryAt->format('d/m/Y') : '',
  158.                 'Email' => $this->email,
  159.                 'ID First Building' => $this->idFirstBuilding,
  160.                 'Not CB' => $this->notCB ? 'Yes' : 'No',
  161.                 'As Payment Arrival' => $this->asPaymentArrival ? 'Yes' : 'No',
  162.             ]
  163.         ];
  164.     }
  165.     
  166.     public function getDatePaidAt(): ?\DateTimeImmutable
  167.     {
  168.         
  169.         $qb = $this->entityManager->createQueryBuilder();
  170.         $qb->select('c.datePaidAt')
  171.         ->from(CertificateTransaction::class, 'c')
  172.         ->where('c.idCertificate = :id')
  173.         ->setParameter('id', $this->getId());
  174.         
  175.         $results = $qb->getQuery()->getResult();
  176.         dd($results);
  177.         return new \DateTimeImmutable();
  178.     }
  179.     // Add the exportToCSV method
  180.     public function exportToCSV($filename): void
  181.     {
  182.         $exportData = $this->getExportData();
  183.     
  184.         $file = fopen($filename, 'w');
  185.         fputcsv($file, array_keys($exportData[0])); // Write the CSV header
  186.     
  187.         foreach ($exportData as $data) {
  188.             fputcsv($file, $data); // Write each row of data
  189.         }
  190.     
  191.         fclose($file);
  192.     }
  193.     public function getLinkId(): ?string
  194.     {
  195.         return $this->linkId;
  196.     }
  197.     public function setLinkId(?string $linkId): self
  198.     {
  199.         $this->linkId = $linkId;
  200.         return $this;
  201.     }
  203.     public function getId(): ?int
  204.     {
  205.         return $this->id;
  206.     }
  208.     public function getUser(): ?User
  209.     {
  210.         return $this->user;
  211.     }
  213.     public function setUser(?User $user): self
  214.     {
  215.         $this->user = $user;
  217.         return $this;
  218.     }
  220.     public function getCity(): ?string
  221.     {
  222.         return $this->city;
  223.     }
  225.     public function setCity(?string $city): self
  226.     {
  227.         $this->city = $city;
  229.         return $this;
  230.     }
  232.     public function getNationality(): ?string
  233.     {
  234.         return $this->nationality;
  235.     }
  237.     public function setNationality(?string $nationality): self
  238.     {
  239.         $this->nationality = $nationality;
  241.         return $this;
  242.     }
  244.     public function getRefusedAt(): ?\DateTimeInterface
  245.     {
  246.         return $this->refusedAt;
  247.     }
  249.     public function setRefusedAt(?\DateTimeInterface $refusedAt): self
  250.     {
  251.         $this->refusedAt = $refusedAt;
  253.         return $this;
  254.     }
  256.     public function getCountryDelivery(): ?string
  257.     {
  258.         return $this->countryDelivery;
  259.     }
  261.     public function setCountryDelivery(?string $countryDelivery): self
  262.     {
  263.         $this->countryDelivery = $countryDelivery;
  265.         return $this;
  266.     }
  268.     public function getIssuingConsulate(): ?string
  269.     {
  270.         return $this->issuingConsulate;
  271.     }
  273.     public function setIssuingConsulate(?string $issuingConsulate): self
  274.     {
  275.         $this->issuingConsulate = $issuingConsulate;
  277.         return $this;
  278.     }
  280.     public function getType(): ?string
  281.     {
  282.         return $this->type;
  283.     }
  285.     public function setType(?string $type): self
  286.     {
  287.         $this->type = $type;
  289.         return $this;
  290.     }
  292.     public function getDepartureCertificateName(): ?string
  293.     {
  294.         return $this->departureCertificateName;
  295.     }
  297.     public function setDepartureCertificateName(?string $departureCertificateName): self
  298.     {
  299.         $this->departureCertificateName = $departureCertificateName;
  301.         return $this;
  302.     }
  304.     /**
  305.      * @return File|null
  306.      */
  307.     public function getPictureCertificate(): ?File
  308.     {
  309.         return $this->pictureCertificate;
  310.     }
  312.     /**
  313.      * @param File|null $pictureCertificate
  314.      */
  315.     public function setPictureCertificate(?File $pictureCertificate): void
  316.     {
  317.         $this->pictureCertificate = $pictureCertificate;
  318.         if ($pictureCertificate) {
  319.             $this->uploadedAt = new \DateTime('now');
  320.         }
  321.     }
  323.     public function isApproved(): bool
  324.     {
  325.         return $this->approved;
  326.     }
  328.     public function approve(): void
  329.     {
  330.         $this->approved = true;
  331.     }
  333.     public function getUploadedAt(): ?\DateTimeInterface
  334.     {
  335.         return $this->uploadedAt;
  336.     }
  338.     public function setUploadedAt(?\DateTimeInterface $uploadedAt): self
  339.     {
  340.         $this->uploadedAt = $uploadedAt;
  342.         return $this;
  343.     }
  345.     public function isIsBlock(): ?bool
  346.     {
  347.         return $this->isBlock;
  348.     }
  350.     public function setIsBlock(?bool $isBlock): self
  351.     {
  352.         $this->isBlock = $isBlock;
  354.         return $this;
  355.     }
  357.     public function getCivility(): ?string
  358.     {
  359.         return $this->civility;
  360.     }
  362.     public function setCivility(?string $civility): self
  363.     {
  364.         $this->civility = $civility;
  366.         return $this;
  367.     }
  369.     public function getLastName(): ?string
  370.     {
  371.         return $this->lastName;
  372.     }
  374.     public function setLastName(?string $lastName): self
  375.     {
  376.         $this->lastName = $lastName;
  378.         return $this;
  379.     }
  381.     public function getFirstName(): ?string
  382.     {
  383.         return $this->firstName;
  384.     }
  386.     public function setFirstName(?string $firstName): self
  387.     {
  388.         $this->firstName = $firstName;
  390.         return $this;
  391.     }
  393.     public function getBirthDate(): ?\DateTimeInterface
  394.     {
  395.         return $this->birthDate;
  396.     }
  398.     public function setBirthDate(?\DateTimeInterface $birthDate): self
  399.     {
  400.         $this->birthDate = $birthDate;
  402.         return $this;
  403.     }
  405.     public function getPassportNumber(): ?string
  406.     {
  407.         return $this->passportNumber;
  408.     }
  410.     public function setPassportNumber(?string $passportNumber): self
  411.     {
  412.         $this->passportNumber = $passportNumber;
  414.         return $this;
  415.     }
  417.     public function getStartDate(): ?\DateTimeInterface
  418.     {
  419.         return $this->startDate;
  420.     }
  422.     public function setStartDate(?\DateTimeInterface $startDate): self
  423.     {
  424.         $this->startDate = $startDate;
  426.         return $this;
  427.     }
  429.     public function isIsPaid(): ?bool
  430.     {
  431.         return $this->isPaid;
  432.     }
  434.     public function setIsPaid(?bool $isPaid): self
  435.     {
  436.         $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;
  450.         return $this;
  451.     }
  453.     /**
  454.      * @return Collection<int, Residence>
  455.      */
  456.     public function getResidence(): Collection
  457.     {
  458.         return $this->residence;
  459.     }
  461.     public function addResidence(Residence $residence): self
  462.     {
  463.         if (!$this->residence->contains($residence)) {
  464.             $this->residence->add($residence);
  465.         }
  467.         return $this;
  468.     }
  470.     public function removeResidence(Residence $residence): self
  471.     {
  472.         $this->residence->removeElement($residence);
  474.         return $this;
  475.     }
  477.     /**
  478.      * @return Collection<int, Building>
  479.      */
  480.     public function getBuilding(): Collection
  481.     {
  482.         return $this->building;
  483.     }
  485.     public function addBuilding(Building $building): self
  486.     {
  487.         if (!$this->building->contains($building)) {
  488.             $this->building->add($building);
  489.         }
  491.         return $this;
  492.     }
  494.     public function removeBuilding(Building $building): self
  495.     {
  496.         $this->building->removeElement($building);
  498.         return $this;
  499.     }
  501.     public function getIdentifierString(): ?string
  502.     {
  503.         return $this->identifierString;
  504.     }
  506.     public function setIdentifierString(string $identifierString): self
  507.     {
  508.         $this->identifierString = $identifierString;
  510.         return $this;
  511.     }
  513.     public function getSchool(): ?string
  514.     {
  515.         return $this->school;
  516.     }
  518.     public function setSchool(?string $school): self
  519.     {
  520.         $this->school = strtoupper($school);
  522.         return $this;
  523.     }
  525.     public function getNumberId(): ?string
  526.     {
  527.         return $this->numberId;
  528.     }
  530.     public function setNumberId(?string $numberId): self
  531.     {
  532.         $this->numberId = $numberId;
  534.         return $this;
  535.     }
  537.     public function getPassportExpiryAt(): ?\DateTimeInterface
  538.     {
  539.         return $this->passportExpiryAt;
  540.     }
  542.     public function setPassportExpiryAt(?\DateTimeInterface $passportExpiryAt): self
  543.     {
  544.         $this->passportExpiryAt = $passportExpiryAt;
  546.         return $this;
  547.     }
  549.     public function getEmail(): ?string
  550.     {
  551.         return $this->email;
  552.     }
  554.     public function setEmail(?string $email): self
  555.     {
  556.         $this->email = $email;
  558.         return $this;
  559.     }
  561.     public function getIdFirstBuilding(): ?int
  562.     {
  563.         return $this->idFirstBuilding;
  564.     }
  566.     public function setIdFirstBuilding(?int $idFirstBuilding): self
  567.     {
  568.         $this->idFirstBuilding = $idFirstBuilding;
  570.         return $this;
  571.     }
  573.     public function isNotCB(): ?bool
  574.     {
  575.         return $this->notCB;
  576.     }
  578.     public function setNotCB(bool $notCB): self
  579.     {
  580.         $this->notCB = $notCB;
  582.         return $this;
  583.     }
  585.     public function isAsPaymentArrival(): ?bool
  586.     {
  587.         return $this->asPaymentArrival;
  588.     }
  590.     public function setAsPaymentArrival(?bool $asPaymentArrival): self
  591.     {
  592.         $this->asPaymentArrival = $asPaymentArrival;
  594.         return $this;
  595.     }
  596.     public function isIsSendToConsulat(): ?bool
  597.     {
  598.         return $this->isSendToConsulat;
  599.     }
  600.     public function setIsSendToConsulat(?bool $isSendToConsulat): self
  601.     {
  602.         $this->isSendToConsulat = $isSendToConsulat;
  604.         return $this;
  605.     }
  606. }