src/Entity/Quotes.php line 13

Open in your IDE?
  1. <?php
  3. namespace App\Entity;
  5. use Doctrine\Common\Collections\ArrayCollection;
  6. use Doctrine\Common\Collections\Collection;
  7. use Doctrine\DBAL\Types\Types;
  8. use Doctrine\ORM\Mapping as ORM;
  9. use Doctrine\Common\Collections\Criteria;
  11. #[ORM\Table(name: 'quotes')]
  12. #[ORM\Entity]
  13. class Quotes
  14. {
  15. #[ORM\Column(name: 'id', type: 'integer', nullable: false)]
  16. #[ORM\Id]
  17. #[ORM\GeneratedValue(strategy: 'IDENTITY')]
  18. private $id;
  20. #[ORM\Column(name: 'price_sum', type: 'integer', nullable: true)]
  21. private $priceSum;
  23. #[ORM\Column(name: 'price_sum_br', type: 'integer', nullable: true)]
  24. private $priceSumBr;
  26. #[ORM\Column(name: 'note', type: 'text', length: 65535, nullable: true)]
  27. private $note;
  29. #[ORM\Column(name: 'created', type: 'datetime', nullable: false)]
  30. private $created;
  32. #[ORM\Column(name: 'sent_date', type: 'datetime', nullable: true)]
  33. private $sentDate;
  35. #[ORM\Column(name: 'updated', type: 'datetime', nullable: true)]
  36. private $updated;
  38. #[ORM\Column(name: 'price_bodyguard', type: 'integer', nullable: true)]
  39. private $priceBodyguard;
  41. #[ORM\Column(name: 'price_paint', type: 'integer', nullable: true)]
  42. private $pricePaint;
  44. #[ORM\Column(name: 'price_assembly', type: 'integer', nullable: true)]
  45. private $priceAssembly;
  47. #[ORM\Column(name: 'tax', type: 'string', nullable: true)]
  48. private $tax;
  50. #[ORM\OneToMany(targetEntity: QuoteItems::class, mappedBy: 'quote', cascade: ['persist'], orphanRemoval: true)]
  51. public $quoteItems;
  53. #[ORM\OneToMany(targetEntity: Attachment::class, mappedBy: 'quote', cascade: ['persist'], orphanRemoval: true)]
  54. public $attachments;
  56. #[ORM\Column(name: 'modified', type: 'datetime', nullable: true, options: ['comment' => 'Módosítva'])]
  57. private $modified;
  59. #[ORM\Column(length: 255, nullable: true)]
  60. private ?string $CustomerName = null;
  62. #[ORM\Column(length: 255, nullable: true)]
  63. private ?string $CustomerMail = null;
  65. #[ORM\Column(length: 255, nullable: true)]
  66. private ?string $CustomerPhone = null;
  68. #[ORM\Column(length: 255, nullable: true)]
  69. private ?string $CustomerAddress = null;
  71. #[ORM\Column(length: 255, nullable: true)]
  72. private ?string $Title = null;
  74. #[ORM\Column(type: Types::TEXT, nullable: true)]
  75. private ?string $OriginalText = null;
  77. #[ORM\Column(type: Types::TEXT, nullable: true)]
  78. private ?string $ShortDesc = null;
  80. #[ORM\Column]
  81. private ?int $status = null;
  83. public static $statuses = [
  84. 0 => 'Új',
  85. 1 => 'Piszkozat',
  86. 2 => 'Kiküldve',
  87. 3 => 'Pontosítás szükséges',
  88. 4 => 'Visszahívás szükséges',
  89. 5 => 'Email érdeklődés szükséges',
  90. 6 => 'Elfogadva',
  91. 7 => 'Elutasítva',
  92. 8 => 'Lezárva',
  93. 9 => 'Archivált',
  94. ];
  96. public static $discoveries = [
  97. 0 => 'Telefonon',
  98. 1 => 'E-mailben',
  99. 2 => 'Személyesen',
  100. ];
  102. #[ORM\Column(type: Types::INTEGER, nullable: true)]
  103. private ?int $discovery = 1;
  105. #[ORM\Column(type: Types::TEXT, nullable: true)]
  106. private ?string $sentMail = null;
  108. #[ORM\ManyToOne(targetEntity: self::class, inversedBy: 'quotes')]
  109. private ?self $parent = null;
  111. #[ORM\OneToMany(mappedBy: 'parent', targetEntity: self::class)]
  112. private Collection $quotes;
  113. public function __construct()
  114. {
  115. $this->created = new \DateTime();
  116. $this->quoteItems = new ArrayCollection();
  117. $this->attachments = new ArrayCollection();
  118. $this->status = 0;
  119. $this->quotes = new ArrayCollection();
  120. }
  122. public function getId(): ?int
  123. {
  124. return $this->id;
  125. }
  129. public function getTax(): ?string
  130. {
  131. return $this->tax;
  132. }
  134. public function setTax(?string $tax): self
  135. {
  136. $this->tax = $tax;
  138. return $this;
  139. }
  141. public function getPriceSum(): ?int
  142. {
  143. return $this->priceSum;
  144. }
  146. public function setPriceSum(?int $priceSum): self
  147. {
  148. $this->priceSum = $priceSum;
  150. return $this;
  151. }
  153. public function getPriceSumBr(): ?int
  154. {
  155. return $this->priceSumBr;
  156. }
  158. public function setPriceSumBr(?int $priceSumBr): self
  159. {
  160. $this->priceSumBr = $priceSumBr;
  162. return $this;
  163. }
  165. public function getNote(): ?string
  166. {
  167. return $this->note;
  168. }
  170. public function setNote(?string $note): self
  171. {
  172. $this->note = $note;
  174. return $this;
  175. }
  177. public function getCreated(): ?\DateTimeInterface
  178. {
  179. return $this->created;
  180. }
  182. public function setCreated(\DateTimeInterface $created): self
  183. {
  184. $this->created = $created;
  186. return $this;
  187. }
  189. /**
  190. * @return Collection|QuoteItems[]
  191. */
  192. public function getQuoteItems(): Collection
  193. {
  194. return $this->quoteItems;
  195. }
  197. /* public function addQuoteItem(QuoteItems $quoteItem): self
  198. {
  199. if (!$this->quoteItems->contains($quoteItem)) {
  200. $quoteItem->setQuote($this);
  201. $this->quoteItems[] = $quoteItem;
  202. }
  204. return $this;
  205. }
  207. public function removeQuoteItem(QuoteItems $quoteItem): self
  208. {
  209. if ($this->quoteItems->removeElement($quoteItem)) {
  210. // set the owning side to null (unless already changed)
  211. if ($quoteItem->getQuote() === $this) {
  212. $quoteItem->setQuote(null);
  213. }
  214. }
  216. return $this;
  217. }
  218. */
  220. /**
  221. * @return Collection|QuoteItems[]
  222. */
  223. public function getQuotePaintItems(): Collection
  224. {
  225. $criteria = Criteria::create();
  226. $criteria->where(Criteria::expr()->eq('type', QuoteItems::PAINT));
  227. return $this->quoteItems->matching($criteria);
  228. }
  230. public function addQuotePaintItem(QuoteItems $quoteItem): self
  231. {
  232. if (!$this->quoteItems->contains($quoteItem)) {
  233. $quoteItem->setType(QuoteItems::PAINT);
  234. if($this->getPricePaint() !== null){
  235. $quoteItem->setPriceQty($this->pricePaint);
  236. }
  237. $quoteItem->setQuote($this);
  238. $this->quoteItems[] = $quoteItem;
  239. }
  241. return $this;
  242. }
  244. public function removeQuotePaintItem(QuoteItems $quoteItem): self
  245. {
  246. if ($this->quoteItems->removeElement($quoteItem)) {
  247. // set the owning side to null (unless already changed)
  248. /*if ($quoteItem->getQuote() === $this) {
  249. $quoteItem->setQuote(null);
  250. }*/
  251. }
  253. return $this;
  254. }
  256. /**
  257. * @return Collection|QuoteItems[]
  258. */
  259. public function getQuoteAssemblyItems(): Collection
  260. {
  261. $criteria = Criteria::create();
  262. $criteria->where(Criteria::expr()->eq('type', QuoteItems::ASSEMBLY));
  263. return $this->quoteItems->matching($criteria);
  264. }
  266. public function addQuoteAssemblyItem(QuoteItems $quoteItem): self
  267. {
  268. if (!$this->quoteItems->contains($quoteItem)) {
  269. $quoteItem->setType(QuoteItems::ASSEMBLY);
  270. if($this->getPriceAssembly() !== null){
  271. $quoteItem->setPriceQty($this->priceAssembly);
  272. }
  273. $quoteItem->setQuote($this);
  274. $this->quoteItems[] = $quoteItem;
  275. }
  277. return $this;
  278. }
  280. public function removeQuoteAssemblyItem(QuoteItems $quoteItem): self
  281. {
  282. if ($this->quoteItems->removeElement($quoteItem)) {
  283. // set the owning side to null (unless already changed)
  284. if ($quoteItem->getQuote() === $this) {
  285. $quoteItem->setQuote(null);
  286. }
  287. }
  289. return $this;
  290. }
  292. /**
  293. * @return Collection|QuoteItems[]
  294. */
  295. public function getQuoteBodyguardItems(): Collection
  296. {
  297. $criteria = Criteria::create();
  298. $criteria->where(Criteria::expr()->eq('type', QuoteItems::BODYGUARD));
  299. return $this->quoteItems->matching($criteria);
  300. }
  302. public function addQuoteBodyguardItem(QuoteItems $quoteItem): self
  303. {
  304. if (!$this->quoteItems->contains($quoteItem)) {
  305. $quoteItem->setType(QuoteItems::BODYGUARD);
  306. if($this->getPriceBodyguard() !== null){
  307. $quoteItem->setPriceQty($this->priceBodyguard);
  308. }
  309. $quoteItem->setQuote($this);
  310. $this->quoteItems[] = $quoteItem;
  311. }
  313. return $this;
  314. }
  316. public function removeQuoteBodyguardItem(QuoteItems $quoteItem): self
  317. {
  318. if ($this->quoteItems->removeElement($quoteItem)) {
  319. // set the owning side to null (unless already changed)
  320. if ($quoteItem->getQuote() === $this) {
  321. $quoteItem->setQuote(null);
  322. }
  323. }
  325. return $this;
  326. }
  328. /**
  329. * @return Collection|QuoteItems[]
  330. */
  331. public function getQuoteOtherItems(): Collection
  332. {
  333. $criteria = Criteria::create();
  334. $criteria->where(Criteria::expr()->eq('type', QuoteItems::OTHER));
  335. return $this->quoteItems->matching($criteria);
  336. }
  338. public function addQuoteOtherItem(QuoteItems $quoteItem): self
  339. {
  340. if (!$this->quoteItems->contains($quoteItem)) {
  341. $quoteItem->setType(QuoteItems::OTHER);
  342. $quoteItem->setQuote($this);
  343. $this->quoteItems[] = $quoteItem;
  344. }
  346. return $this;
  347. }
  349. public function removeQuoteOtherItem(QuoteItems $quoteItem): self
  350. {
  351. if ($this->quoteItems->removeElement($quoteItem)) {
  352. // set the owning side to null (unless already changed)
  353. if ($quoteItem->getQuote() === $this) {
  354. $quoteItem->setQuote(null);
  355. }
  356. }
  358. return $this;
  359. }
  361. /**
  362. * @return Collection|Attachment[]
  363. */
  364. public function getAttachments(): Collection
  365. {
  366. return $this->attachments;
  367. }
  369. public function addAttachment(Attachment $photo): self
  370. {
  371. if (!$this->attachments->contains($photo)) {
  372. $photo->setQuote($this);
  373. $this->attachments[] = $photo;
  374. }
  376. return $this;
  377. }
  379. public function removeAttachment(Attachment $photo): self
  380. {
  381. if ($this->attachments->removeElement($photo)) {
  382. // set the owning side to null (unless already changed)
  383. if ($photo->getQuote() === $this) {
  384. $photo->setQuote(null);
  385. }
  386. }
  388. return $this;
  389. }
  391. public function getPriceBodyguard(): ?int
  392. {
  393. return $this->priceBodyguard;
  394. }
  396. public function setPriceBodyguard(?int $priceBodyguard): self
  397. {
  398. $this->priceBodyguard = $priceBodyguard;
  400. return $this;
  401. }
  403. public function getPricePaint(): ?int
  404. {
  405. return $this->pricePaint;
  406. }
  408. public function setPricePaint(?int $pricePaint): self
  409. {
  410. $this->pricePaint = $pricePaint;
  412. return $this;
  413. }
  415. public function getPriceAssembly(): ?int
  416. {
  417. return $this->priceAssembly;
  418. }
  420. public function setPriceAssembly(?int $priceAssembly): self
  421. {
  422. $this->priceAssembly = $priceAssembly;
  424. return $this;
  425. }
  427. public function __toString()
  428. {
  429. return 'Ajánlat - '. $this->getCustomerName() . " - " . $this->getTitle();
  430. }
  432. public function rowCss(){
  433. return "";
  434. }
  436. public function getModified(): ?\DateTimeInterface
  437. {
  438. return $this->modified;
  439. }
  441. public function setModified(?\DateTimeInterface $modified): self
  442. {
  443. $this->modified = $modified;
  445. return $this;
  446. }
  448. public function getSentDate(): ?\DateTimeInterface
  449. {
  450. return $this->sentDate;
  451. }
  453. public function setSentDate(?\DateTimeInterface $sentDate): self
  454. {
  455. $this->sentDate = $sentDate;
  457. return $this;
  458. }
  460. public function getUpdated(): ?\DateTimeInterface
  461. {
  462. return $this->updated;
  463. }
  465. public function setUpdated(?\DateTimeInterface $updated): self
  466. {
  467. $this->updated = $updated;
  469. return $this;
  470. }
  472. public function getCustomerName(): ?string
  473. {
  474. return $this->CustomerName;
  475. }
  477. public function setCustomerName(?string $CustomerName): static
  478. {
  479. $this->CustomerName = $CustomerName;
  481. return $this;
  482. }
  484. public function getCustomerMail(): ?string
  485. {
  486. return $this->CustomerMail;
  487. }
  489. public function setCustomerMail(string $CustomerMail): static
  490. {
  491. $this->CustomerMail = $CustomerMail;
  493. return $this;
  494. }
  496. public function getCustomerPhone(): ?string
  497. {
  498. return $this->CustomerPhone;
  499. }
  501. public function setCustomerPhone(?string $CustomerPhone): static
  502. {
  503. $this->CustomerPhone = $CustomerPhone;
  505. return $this;
  506. }
  508. public function getCustomerAddress(): ?string
  509. {
  510. return $this->CustomerAddress;
  511. }
  513. public function setCustomerAddress(?string $CustomerAddress): static
  514. {
  515. $this->CustomerAddress = $CustomerAddress;
  517. return $this;
  518. }
  520. public function getTitle(): ?string
  521. {
  522. return $this->Title;
  523. }
  525. public function setTitle(string $Title): static
  526. {
  527. $this->Title = $Title;
  529. return $this;
  530. }
  532. public function getOriginalText(): ?string
  533. {
  534. if ($this->OriginalText === null || $this->OriginalText === '') {
  535. return $this->OriginalText;
  536. }
  538. $lines = preg_split('/\R/', $this->OriginalText);
  539. $lines = array_values(array_filter(array_map('trim', $lines), static fn ($line): bool => $line !== ''));
  541. return implode("\n", $lines);
  542. }
  544. public function setOriginalText(?string $OriginalText): static
  545. {
  546. $this->OriginalText = $OriginalText;
  548. return $this;
  549. }
  551. public function getShortDesc(): ?string
  552. {
  553. return $this->ShortDesc;
  554. }
  556. public function setShortDesc(?string $ShortDesc): static
  557. {
  558. $this->ShortDesc = $ShortDesc;
  560. return $this;
  561. }
  563. public function getStatus(): ?int
  564. {
  565. return $this->status;
  566. }
  568. public function setStatus(int $status): static
  569. {
  570. $this->status = $status;
  572. return $this;
  573. }
  575. public function getStatusName(): ?string
  576. {
  577. return self::$statuses[$this->status];
  578. }
  580. public function getDiscovery(): ?int
  581. {
  582. return $this->discovery;
  583. }
  585. public function setDiscovery(?int $discovery): static
  586. {
  587. $this->discovery = $discovery;
  589. return $this;
  590. }
  592. public function getSentMail(): ?string
  593. {
  594. return $this->sentMail;
  595. }
  596. public function getSentMailHtml(): ?string
  597. {
  598. return nl2br($this->sentMail);
  599. }
  600. public function setSentMail(?string $sentMail): static
  601. {
  602. $this->sentMail = $sentMail;
  604. return $this;
  605. }
  607. public function getParent(): ?self
  608. {
  609. return $this->parent;
  610. }
  612. public function setParent(?self $parent): static
  613. {
  614. $this->parent = $parent;
  616. return $this;
  617. }
  619. /**
  620. * @return Collection<int, self>
  621. */
  622. public function getQuotes(): Collection
  623. {
  624. return $this->quotes;
  625. }
  627. public function addQuote(self $quote): static
  628. {
  629. if (!$this->quotes->contains($quote)) {
  630. $this->quotes->add($quote);
  631. $quote->setParent($this);
  632. }
  634. return $this;
  635. }
  637. public function removeQuote(self $quote): static
  638. {
  639. if ($this->quotes->removeElement($quote)) {
  640. // set the owning side to null (unless already changed)
  641. if ($quote->getParent() === $this) {
  642. $quote->setParent(null);
  643. }
  644. }
  646. return $this;
  647. }
  648. }