src/Entity/LignePlanAchat.php line 18

Open in your IDE?
  1. <?php
  3. namespace App\Entity;
  5. use App\Repository\LignePlanAchatRepository;
  6. use Doctrine\DBAL\Types\Types;
  7. use Doctrine\ORM\Mapping as ORM;
  8. use DateTimeInterface;
  9. use Doctrine\Common\Collections\ArrayCollection;
  10. use Doctrine\Common\Collections\Collection;
  11. /**
  12. * Ligne du plan d'achats.
  13. * La procédure applicable est détectée automatiquement depuis la matrice des seuils.
  14. */
  15. #[ORM\Entity(repositoryClass: LignePlanAchatRepository::class)]
  16. #[ORM\Table(name: 'ligne_plan_achat')]
  17. #[ORM\HasLifecycleCallbacks]
  18. class LignePlanAchat
  19. {
  20. const STATUT_PLANIFIE = 'planifie';
  21. const STATUT_EN_COURS = 'en_cours';
  22. const STATUT_DA_CREEE = 'da_creee';
  23. const STATUT_REALISE = 'realise';
  24. const STATUT_ANNULE = 'annule';
  25. const STATUT_REPORTE = 'reporte';
  27. const TRIMESTRE_T1 = 'T1';
  28. const TRIMESTRE_T2 = 'T2';
  29. const TRIMESTRE_T3 = 'T3';
  30. const TRIMESTRE_T4 = 'T4';
  32. public static function getStatuts(): array
  33. {
  34. return [
  35. self::STATUT_PLANIFIE => 'Planifié',
  36. self::STATUT_EN_COURS => 'En cours',
  37. self::STATUT_DA_CREEE => 'DA créée',
  38. self::STATUT_REALISE => 'Réalisé',
  39. self::STATUT_ANNULE => 'Annulé',
  40. self::STATUT_REPORTE => 'Reporté',
  41. ];
  42. }
  44. public static function getTrimestres(): array
  45. {
  46. return [
  47. self::TRIMESTRE_T1 => '1er trimestre (Jan-Mar)',
  48. self::TRIMESTRE_T2 => '2ème trimestre (Avr-Jun)',
  49. self::TRIMESTRE_T3 => '3ème trimestre (Jul-Sep)',
  50. self::TRIMESTRE_T4 => '4ème trimestre (Oct-Déc)',
  51. ];
  52. }
  54. #[ORM\Id]
  55. #[ORM\GeneratedValue]
  56. #[ORM\Column]
  57. private ?int $id = null;
  59. #[ORM\ManyToOne(targetEntity: PlanAchatAnnuel::class, inversedBy: 'lignes')]
  60. #[ORM\JoinColumn(name: 'plan_achat_id', nullable: false, onDelete: 'CASCADE')]
  61. private ?PlanAchatAnnuel $planAchat = null;
  64. #[ORM\Column(name: 'montant_reserve', type: Types::DECIMAL, precision: 15, scale: 2, nullable: true)]
  65. private ?string $montantReserve = '0';
  67. // Numéro de ligne dans le plan
  68. #[ORM\Column(name: 'num_ligne', nullable: true)]
  69. private ?int $numLigne = null;
  71. // Désignation de l'article/service à acheter
  72. #[ORM\Column(name: 'designation', length: 255)]
  73. private ?string $designation = null;
  75. #[ORM\Column(name: 'description', type: Types::TEXT, nullable: true)]
  76. private ?string $description = null;
  78. // Quantité prévue
  79. #[ORM\Column(name: 'quantite', type: Types::DECIMAL, precision: 10, scale: 2, nullable: true)]
  80. private ?string $quantite = null;
  82. #[ORM\Column(name: 'unite', length: 50, nullable: true)]
  83. private ?string $unite = null;
  85. // Budget estimé — CLEF pour la détection automatique du seuil
  86. #[ORM\Column(name: 'budget_estime', type: Types::DECIMAL, precision: 15, scale: 2, nullable: true)]
  87. private ?string $budgetEstime = null;
  89. // Montant réalisé (après exécution)
  90. #[ORM\Column(name: 'montant_realise', type: Types::DECIMAL, precision: 15, scale: 2, nullable: true)]
  91. private ?string $montantRealise = null;
  93. // Catégorie de marché (lien vers CategorieMarche)
  94. #[ORM\ManyToOne(targetEntity: CategorieMarche::class)]
  95. #[ORM\JoinColumn(name: 'categorie_marche_id', nullable: true)]
  96. private ?CategorieMarche $categorieMarche = null;
  98. // Seuil détecté automatiquement
  99. #[ORM\ManyToOne(targetEntity: SeuilPassation::class)]
  100. #[ORM\JoinColumn(name: 'seuil_passation_id', nullable: true)]
  101. private ?SeuilPassation $seuilPassation = null;
  103. // Trimestre prévu
  104. #[ORM\Column(name: 'trimestre_prevu', length: 5, nullable: true)]
  105. private ?string $trimestrePrevu = null;
  107. // Mois prévu (1-12)
  108. #[ORM\Column(name: 'mois_prevu', nullable: true)]
  109. private ?int $moisPrevu = null;
  111. #[ORM\Column(name: 'statut', length: 20)]
  112. private string $statut = self::STATUT_PLANIFIE;
  114. // Observation / justification
  115. #[ORM\Column(name: 'observation', type: Types::TEXT, nullable: true)]
  116. private ?string $observation = null;
  118. // Lien vers la DA créée depuis cette ligne
  120. #[ORM\OneToMany(mappedBy: 'lignePlanAchat', targetEntity: demAchat::class)]
  121. private Collection $demandesAchat;
  123. // Priorité (1 = haute, 2 = moyenne, 3 = faible)
  124. #[ORM\Column(name: 'priorite', nullable: true)]
  125. private ?int $priorite = null;
  127. #[ORM\Column(name: 'created_at', type: Types::DATETIME_MUTABLE)]
  128. private ?\DateTimeInterface $createdAt = null;
  130. #[ORM\Column(name: 'updated_at', type: Types::DATETIME_MUTABLE, nullable: true)]
  131. private ?\DateTimeInterface $updatedAt = null;
  133. public function __construct()
  134. {
  136. $this->createdAt = new \DateTime();
  137. $this->statut = self::STATUT_PLANIFIE;
  138. $this->demandesAchat = new ArrayCollection(); // Indispensable
  140. }
  142. #[ORM\PreUpdate]
  143. public function onPreUpdate(): void
  144. {
  145. $this->updatedAt = new \DateTime();
  146. }
  148. // ---------------------------------------------------------------
  149. // Méthodes métier
  150. // ---------------------------------------------------------------
  152. /**
  153. * Retourne l'écart entre budget estimé et montant réalisé.
  154. */
  155. public function getEcartBudget(): ?float
  156. {
  157. if ($this->budgetEstime === null || $this->montantRealise === null) return null;
  158. return floatval($this->montantRealise) - floatval($this->budgetEstime);
  159. }
  163. /**
  164. * Libellé de priorité.
  165. */
  166. public function getPrioriteLabel(): string
  167. {
  168. return match($this->priorite) {
  169. 1 => 'Haute',
  170. 2 => 'Moyenne',
  171. 3 => 'Faible',
  172. default => '—',
  173. };
  174. }
  176. // ---------------------------------------------------------------
  177. // Getters / Setters
  178. // ---------------------------------------------------------------
  180. public function getId(): ?int { return $this->id; }
  182. public function getPlanAchat(): ?PlanAchatAnnuel { return $this->planAchat; }
  183. public function setPlanAchat(?PlanAchatAnnuel $p): static { $this->planAchat = $p; return $this; }
  185. public function getNumLigne(): ?int { return $this->numLigne; }
  186. public function setNumLigne(?int $n): static { $this->numLigne = $n; return $this; }
  188. public function getDesignation(): ?string { return $this->designation; }
  189. public function setDesignation(string $d): static { $this->designation = $d; return $this; }
  191. public function getDescription(): ?string { return $this->description; }
  192. public function setDescription(?string $d): static { $this->description = $d; return $this; }
  194. public function getQuantite(): ?string { return $this->quantite; }
  195. public function setQuantite(?string $q): static { $this->quantite = $q; return $this; }
  197. public function getUnite(): ?string { return $this->unite; }
  198. public function setUnite(?string $u): static { $this->unite = $u; return $this; }
  200. public function getBudgetEstime(): ?string { return $this->budgetEstime; }
  201. public function setBudgetEstime(?string $b): static { $this->budgetEstime = $b; return $this; }
  203. public function getMontantRealise(): ?string { return $this->montantRealise; }
  204. public function setMontantRealise(?string $m): static { $this->montantRealise = $m; return $this; }
  206. public function getCategorieMarche(): ?CategorieMarche { return $this->categorieMarche; }
  207. public function setCategorieMarche(?CategorieMarche $c): static { $this->categorieMarche = $c; return $this; }
  209. public function getSeuilPassation(): ?SeuilPassation { return $this->seuilPassation; }
  210. public function setSeuilPassation(?SeuilPassation $s): static { $this->seuilPassation = $s; return $this; }
  212. public function getTrimestrePrevu(): ?string { return $this->trimestrePrevu; }
  213. public function setTrimestrePrevu(?string $t): static { $this->trimestrePrevu = $t; return $this; }
  215. public function getMoisPrevu(): ?int { return $this->moisPrevu; }
  216. public function setMoisPrevu(?int $m): static { $this->moisPrevu = $m; return $this; }
  218. public function getStatut(): string { return $this->statut; }
  219. public function setStatut(string $s): static { $this->statut = $s; return $this; }
  221. public function getObservation(): ?string { return $this->observation; }
  222. public function setObservation(?string $o): static { $this->observation = $o; return $this; }
  225. public function getPriorite(): ?int { return $this->priorite; }
  226. public function setPriorite(?int $p): static { $this->priorite = $p; return $this; }
  228. public function getCreatedAt(): ?\DateTimeInterface { return $this->createdAt; }
  229. public function getUpdatedAt(): ?\DateTimeInterface { return $this->updatedAt; }
  232. public function getMontantConsomme(): float
  233. {
  234. $total = 0;
  235. foreach ($this->demandesAchat as $da) {
  236. // On suppose que votre entité demAchat a une méthode getMontant()
  237. $total += (float) $da->getMontant();
  238. }
  239. return $total;
  240. }
  242. /**
  243. * @return Collection<int, demAchat>
  244. */
  245. public function getDemandesAchat(): Collection
  246. {
  247. return $this->demandesAchat;
  248. }
  250. public function getMontantReserve(): ?string { return $this->montantReserve; }
  251. public function setMontantReserve(?string $m): static {
  252. $this->montantReserve = $m;
  253. return $this;
  254. }
  257. /**
  258. * Budget réellement disponible =
  259. * budgetEstime - montantRealise - montantReserve
  260. */
  261. public function getResteDisponible(): float
  262. {
  263. return (float)$this->getBudgetEstime()
  264. - (float)($this->getMontantRealise() ?? 0)
  265. - (float)($this->getMontantReserve() ?? 0);
  266. }
  268. /**
  269. * Récapitulatif complet du budget
  270. */
  271. public function getBudgetRecap(): array
  272. {
  273. $estime = (float)$this->getBudgetEstime();
  274. $realise = (float)($this->getMontantRealise() ?? 0);
  275. $reserve = (float)($this->getMontantReserve() ?? 0);
  276. $disponible = $estime - $realise - $reserve;
  278. return [
  279. 'estime' => $estime,
  280. 'realise' => $realise,
  281. 'reserve' => $reserve,
  282. 'disponible' => $disponible,
  283. 'taux' => $estime > 0
  284. ? round((($realise + $reserve) / $estime) * 100, 1)
  285. : 0,
  286. ];
  287. }
  289. }