src/Entity/Customer.php line 15

Open in your IDE?
  1. <?php
  3. namespace App\Entity;
  5. use Doctrine\ORM\Mapping as ORM;
  6. use Doctrine\Common\Persistence\Event\LifecycleEventArgs;
  8. /**
  9. * Customers
  10. *
  11. * @ORM\Table(name="customers", indexes={@ORM\Index(name="purchased_without_account", columns={"purchased_without_account"})})
  12. * @ORM\Entity(repositoryClass="App\Repository\CustomerRepository")
  13. * @ORM\HasLifecycleCallbacks()
  14. */
  15. class Customer
  16. {
  18. const INVOICE_TYPE_PAPER = 0;
  19. const INVOICE_TYPE_NUMERIC = 1;
  21. public const STATUS_WAITING = 'en attente';
  22. public const STATUS_VALIDATED = 'valide';
  23. public const STATUS_BLOCKED = 'invalide';
  25. /**
  26. * @var int
  27. *
  28. * @ORM\Column(name="customers_id", type="integer", nullable=false)
  29. * @ORM\Id
  30. * @ORM\GeneratedValue(strategy="IDENTITY")
  31. */
  32. private $id;
  34. /**
  35. * @var bool
  36. *
  37. * @ORM\Column(name="purchased_without_account", type="boolean", nullable=false)
  38. */
  39. private $purchasedWithoutAccount = '0';
  41. /**
  42. * @var string
  43. *
  44. * @ORM\Column(name="customers_gender", type="string", length=1, nullable=false, options={"fixed"=true})
  45. */
  46. private $gender = '';
  48. /**
  49. * @var string
  50. *
  51. * @ORM\Column(name="customers_firstname", type="string", length=32, nullable=false)
  52. */
  53. private $firstname = '';
  55. /**
  56. * @var string
  57. *
  58. * @ORM\Column(name="customers_lastname", type="string", length=32, nullable=false)
  59. */
  60. private $lastname = '';
  62. /**
  63. * @var ?\DateTime
  64. *
  65. * @ORM\Column(name="customers_dob", type="datetime", nullable=true)
  66. */
  67. private $dateOfBirth;
  69. /**
  70. * @var string
  71. *
  72. * @ORM\Column(name="customers_email_address", type="string", length=96, nullable=false)
  73. */
  74. private $email = '';
  76. /**
  77. * @var ?\App\Entity\Address
  78. *
  79. * @ORM\ManyToOne(targetEntity="App\Entity\Address")
  80. * @ORM\JoinColumn(name="customers_default_address_id", referencedColumnName="address_book_id", nullable=true)
  81. */
  82. private $defaultAddress;
  84. /**
  85. * @var \App\Entity\Language
  86. *
  87. * @ORM\ManyToOne(targetEntity="App\Entity\Language")
  88. * @ORM\JoinColumn(name="languages_id", referencedColumnName="languages_id")
  89. */
  90. private $language;
  92. /**
  93. * @var string
  94. *
  95. * @ORM\Column(name="customers_telephone", type="string", length=32, nullable=false)
  96. */
  97. private $telephone = '';
  99. /**
  100. * @var string|null
  101. *
  102. * @ORM\Column(name="customers_fax", type="string", length=32, nullable=true)
  103. */
  104. private $fax;
  106. /**
  107. * @var string|null
  108. *
  109. * @ORM\Column(name="customers_tva", type="string", length=32, nullable=true)
  110. */
  111. private $tva;
  113. /**
  114. * @var string|null
  115. *
  116. * @ORM\Column(name="customers_siret", type="string", length=32, nullable=true)
  117. */
  118. private $siret;
  120. /**
  121. * @var string|null
  122. *
  123. * @ORM\Column(name="customers_elevage", type="string", length=20, nullable=true)
  124. */
  125. private $elevage;
  127. /**
  128. * @var string|null
  129. *
  130. * @ORM\Column(name="customers_affixe", type="string", length=100, nullable=true)
  131. */
  132. private $affixe;
  134. /**
  135. * @var string
  136. *
  137. * @ORM\Column(name="customers_password", type="string", length=40, nullable=false)
  138. */
  139. private $password = '';
  141. /**
  142. * @var string|null
  143. *
  144. * @ORM\Column(name="customers_newsletter", type="string", length=1, nullable=true, options={"fixed"=true})
  145. */
  146. private $newsletter;
  148. /**
  149. * @var string|null
  150. *
  151. * @ORM\Column(name="customers_selected_template", type="string", length=20, nullable=true)
  152. */
  153. private $selectedTemplate;
  155. /**
  156. * @var \App\Entity\CustomerGroup
  157. *
  158. * @ORM\ManyToOne(targetEntity="App\Entity\CustomerGroup")
  159. * @ORM\JoinColumn(name="customers_group_id", referencedColumnName="customers_group_id", nullable=true)
  160. */
  161. private $group;
  163. /**
  164. * @var string
  165. *
  166. * @ORM\Column(name="customers_group_ra", type="string", length=0, nullable=false)
  167. */
  168. private $groupRa = '0';
  170. /**
  171. * @var string
  172. *
  173. * @ORM\Column(name="customers_payment_allowed", type="string", length=255, nullable=false)
  174. */
  175. private $paymentAllowed = '';
  177. /**
  178. * @var string
  179. *
  180. * @ORM\Column(name="customers_shipment_allowed", type="string", length=255, nullable=false)
  181. */
  182. private $shipmentAllowed = '';
  184. /**
  185. * @var string
  186. *
  187. * @ORM\Column(name="customers_validation_code", type="string", length=48, nullable=false)
  188. */
  189. private $validationCode = '';
  191. /**
  192. * @var string
  193. *
  194. * @ORM\Column(name="customers_validation", type="string", length=1, nullable=false, options={"fixed"=true})
  195. */
  196. private $validation = '0';
  198. /**
  199. * @var string
  200. *
  201. * @ORM\Column(name="customers_email_registered", type="string", length=32, nullable=false)
  202. */
  203. private $emailRegistered = '';
  205. /**
  206. * @var string|null
  207. *
  208. * @ORM\Column(name="customers_sage", type="text", length=65535, nullable=true, options={"comment"="Code client de SAGE"})
  209. */
  210. private $sage;
  212. /**
  213. * @var string|null
  214. *
  215. * @ORM\Column(name="customers_sap_id", type="string", length=50, nullable=true, options={"comment"="Code client de SAP"})
  216. */
  217. private $sapId;
  219. /**
  220. * @var string|null
  221. *
  222. * @ORM\Column(name="customers_company", type="string", length=64, nullable=true)
  223. */
  224. private $company;
  226. /**
  227. * @var string|null
  228. *
  229. * @ORM\Column(name="customers_referent", type="string", length=32, nullable=true)
  230. */
  231. private $referent;
  233. /**
  234. * @var string|null
  235. *
  236. * @ORM\Column(name="customers_metier", type="string", length=32, nullable=true)
  237. */
  238. private $metier;
  240. /**
  241. * @var string|null
  242. *
  243. * @ORM\Column(name="customers_metier_sap", type="string", length=32, nullable=true)
  244. */
  245. private $metierSAP;
  247. /**
  248. * @var string|null
  249. *
  250. * @ORM\Column(name="customers_autreprecisez", type="string", length=32, nullable=true)
  251. */
  252. private $autreprecisez;
  254. /**
  255. * @var int
  256. *
  257. * @ORM\Column(name="customers_pai_differe", type="integer", nullable=true)
  258. */
  259. private $paiDiffere;
  261. /**
  262. * @var int
  263. *
  264. * @ORM\Column(name="customers_exclu_TVA", type="integer", nullable=true)
  265. */
  266. private $excluTva;
  268. /**
  269. * @var int
  270. *
  271. * @ORM\Column(name="customers_invoice_type", type="integer", nullable=true)
  272. */
  273. private $invoiceType = null;
  275. /**
  276. * @var ?\DateTime
  277. *
  278. * @ORM\Column(name="customers_last_login", type="datetime", nullable=true)
  279. */
  280. private $lastLogin;
  282. /**
  283. * @var ?\DateTime
  284. *
  285. * @ORM\Column(name="customers_creation", type="datetime", nullable=true)
  286. */
  287. private $creation;
  289. /**
  290. * @var ?int
  291. *
  292. * @ORM\Column(name="customers_nblogin", type="integer", nullable=true)
  293. */
  294. private $nbLogin = 0;
  296. /**
  297. * @var ?\DateTime
  298. *
  299. * @ORM\Column(name="customers_account_update", type="datetime", nullable=true)
  300. */
  301. private $accountUpdate;
  303. /**
  304. * @var string
  305. *
  306. * @ORM\Column(name="customers_status", type="string", length="20", nullable=true)
  307. */
  308. private $status;
  310. /**
  311. * @ORM\Column(name="customers_expert", type="integer", nullable=true)
  312. */
  313. private $expert = 0;
  315. /**
  316. * @ORM\Column(name="customers_expert_id", type="string", length="20", nullable=true)
  317. */
  318. private $expertId;
  320. /**
  321. * @var array
  322. *
  323. * @ORM\OneToMany(targetEntity="App\Entity\CustomerPriceGroup", mappedBy="customer", cascade={"persist", "remove"}, orphanRemoval=true)
  324. */
  325. private $priceGroups;
  327. /**
  328. * @ORM\Column(name="customers_consent_ad_products", type="integer", nullable=true)
  329. */
  330. private $consentAdProducts;
  332. /**
  333. * @ORM\Column(name="customers_consent_ad_others", type="integer", nullable=true)
  334. */
  335. private $consentAdOthers;
  337. /**
  338. * @ORM\Column(name="customers_consent_group", type="integer", nullable=true)
  339. */
  340. private $consentGroup;
  342. public function __construct()
  343. {
  344. $this->priceGroups = new \Doctrine\Common\Collections\ArrayCollection();
  345. }
  347. public function getId() {
  348. return $this->id;
  349. }
  351. public function getPurchasedWithoutAccount() {
  352. return $this->purchasedWithoutAccount;
  353. }
  355. public function getGender() {
  356. return $this->gender;
  357. }
  359. public function getFirstname() {
  360. return $this->firstname;
  361. }
  363. public function getLastname() {
  364. return $this->lastname;
  365. }
  367. public function getDateOfBirth(): ?\DateTime {
  368. return $this->dateOfBirth;
  369. }
  371. public function getEmailAddress() {
  372. return $this->email;
  373. }
  375. public function getEmail() {
  376. return $this->getEmailAddress();
  377. }
  379. public function getDefaultAddressId() {
  380. return $this->getDefaultAddress()->getId();
  381. }
  383. public function getDefaultAddress() {
  384. return $this->defaultAddress;
  385. }
  387. public function getTelephone() {
  388. return $this->telephone;
  389. }
  391. public function getFax() {
  392. return $this->fax;
  393. }
  395. public function getTva(): ?string {
  396. return strtoupper($this->tva);
  397. }
  399. public function getSiret(): ?string {
  400. return $this->siret;
  401. }
  403. public function getElevage(): ?string {
  404. return $this->elevage;
  405. }
  407. public function getVatNumber() {
  408. return $this->getTva();
  409. }
  411. public function getAffixe(): ?string {
  412. return $this->affixe;
  413. }
  415. public function getPassword() {
  416. return $this->password;
  417. }
  419. public function getNewsletter() {
  420. return $this->newsletter;
  421. }
  423. public function getSelectedTemplate() {
  424. return $this->selectedTemplate;
  425. }
  427. public function getGroup() {
  428. return $this->group;
  429. }
  431. public function getGroupRa() {
  432. return $this->groupRa;
  433. }
  435. public function getPaymentAllowed() {
  436. return $this->paymentAllowed;
  437. }
  439. public function getShipmentAllowed() {
  440. return $this->shipmentAllowed;
  441. }
  443. public function getValidationCode() {
  444. return $this->validationCode;
  445. }
  447. public function getValidation() {
  448. return $this->validation;
  449. }
  451. public function getEmailRegistered() {
  452. return $this->emailRegistered;
  453. }
  455. public function getSage() {
  456. return $this->sage;
  457. }
  459. public function getSynopticId() {
  460. $value = $this->sage;
  461. $value = str_replace('SYNOPTIC','',$value);
  462. $value = trim(str_replace(':','',$value));
  463. $value = intval($value);
  464. if(!empty($value)){
  465. return $value;
  466. }
  467. return 'new';
  468. }
  470. public function getCompany() {
  471. return $this->company;
  472. }
  474. public function getReferent() {
  475. return $this->referent;
  476. }
  478. public function getMetier() {
  479. return $this->metier;
  480. }
  482. public function getAutreprecisez() {
  483. return $this->autreprecisez;
  484. }
  486. public function getPaiDiffere() {
  487. return $this->paiDiffere;
  488. }
  490. public function getExcluTva() {
  491. return $this->excluTva;
  492. }
  494. public function getInvoiceType() {
  495. return $this->invoiceType;
  496. }
  498. public function getFullname() {
  499. $firstname = $this->getFirstname();
  500. $lastname = $this->getLastname();
  501. if(empty($lastname)||empty($firstname))
  502. return $this->getCompany ();
  503. return $firstname.' '.$lastname;
  504. }
  506. public function getLanguage(): \App\Entity\Language {
  507. return $this->language;
  508. }
  510. public function getLastLogin(): ?\DateTime {
  511. return $this->lastLogin;
  512. }
  514. public function getCreation(): ?\DateTime {
  515. return $this->creation;
  516. }
  518. public function getNbLogin(): ?int {
  519. return is_null($this->nbLogin)?0:$this->nbLogin;
  520. }
  522. public function getAccountUpdate(): ?\DateTime {
  523. return $this->accountUpdate;
  524. }
  526. public function getSapId(): ?string {
  527. return empty($this->sapId) ? 'new' : $this->sapId;
  528. $value = $this->sage;
  529. if(!empty($value)){
  530. return $value;
  531. }
  532. return 'new';
  533. }
  535. public function getSapIdByPriceGroup(PriceGroup $priceGroup): ?string {
  536. $sapId = $this->sapId;
  537. foreach($this->priceGroups as $pGroup) {
  538. if($pGroup->getGroup() == $priceGroup)
  539. $sapId = $pGroup->getSapId();
  540. }
  541. return empty($sapId) ? 'new' : $sapId;
  542. }
  544. public function getMetierSAP(): ?string {
  545. return $this->metierSAP;
  546. }
  548. public function getStatus(): ?string {
  549. return $this->status;
  550. }
  552. public function getConsentAdProducts() {
  553. return $this->consentAdProducts;
  554. }
  556. public function getConsentAdOthers() {
  557. return $this->consentAdOthers;
  558. }
  560. public function getConsentGroup() {
  561. return $this->consentGroup;
  562. }
  564. public function setStatus($status): void {
  565. $this->status = $status;
  566. }
  568. public function getPriceGroups() {
  569. return $this->priceGroups;
  570. }
  572. public function getExpert() {
  573. return $this->expert;
  574. }
  576. public function getExpertId() {
  577. return $this->expertId;
  578. }
  580. public function setId($id) {
  581. $this->id = $id;
  582. }
  584. public function setPurchasedWithoutAccount($purchasedWithoutAccount) {
  585. $this->purchasedWithoutAccount = $purchasedWithoutAccount;
  586. }
  588. public function setGender($gender) {
  589. $this->gender = $gender;
  590. }
  592. public function setFirstname($firstname) {
  593. $this->firstname = $firstname;
  594. }
  596. public function setLastname($lastname) {
  597. $this->lastname = $lastname;
  598. }
  600. public function setDateOfBirth(?\DateTime $dateOfBirth) {
  601. $this->dateOfBirth = $dateOfBirth;
  602. }
  604. public function setEmailAddress($email) {
  605. $this->email = $email;
  606. }
  608. public function setDefaultAddressId($defaultAddressId) {
  609. $this->defaultAddressId = $defaultAddressId;
  610. }
  612. public function setDefaultAddress($defaultAddress) {
  613. $this->defaultAddress = $defaultAddress;
  614. }
  616. public function setTelephone($telephone) {
  617. $this->telephone = $telephone;
  618. }
  620. public function setFax($fax) {
  621. $this->fax = $fax;
  622. }
  624. public function setTva(?string $tva): void {
  625. $this->tva = strtoupper($tva);
  626. }
  628. public function setSiret(?string $siret): void {
  629. $this->siret = $siret;
  630. }
  632. public function setElevage(?string $elevage): void {
  633. $this->elevage = $elevage;
  634. }
  636. public function setAffixe(?string $affixe): void {
  637. $this->affixe = $affixe;
  638. }
  640. public function setPassword($password) {
  641. $this->password = $password;
  642. }
  644. public function setNewsletter($newsletter) {
  645. $this->newsletter = $newsletter;
  646. }
  648. public function setSelectedTemplate($selectedTemplate) {
  649. $this->selectedTemplate = $selectedTemplate;
  650. }
  652. public function setGroup(\App\Entity\CustomerGroup $group) {
  653. $this->group = $group;
  654. }
  656. public function setGroupRa($groupRa) {
  657. $this->groupRa = $groupRa;
  658. }
  660. public function setPaymentAllowed($paymentAllowed) {
  661. $this->paymentAllowed = $paymentAllowed;
  662. }
  664. public function setShipmentAllowed($shipmentAllowed) {
  665. $this->shipmentAllowed = $shipmentAllowed;
  666. }
  668. public function setValidationCode($validationCode) {
  669. $this->validationCode = $validationCode;
  670. }
  672. public function setValidation($validation) {
  673. $this->validation = $validation;
  674. }
  676. public function setEmailRegistered($emailRegistered) {
  677. $this->emailRegistered = $emailRegistered;
  678. }
  680. public function setSage($sage) {
  681. $this->sage = $sage;
  682. }
  684. public function setCompany($company) {
  685. $this->company = $company;
  686. }
  688. public function setReferent($referent) {
  689. $this->referent = $referent;
  690. }
  692. public function setMetier($metier) {
  693. $this->metier = $metier;
  694. }
  696. public function setAutreprecisez($autreprecisez) {
  697. $this->autreprecisez = $autreprecisez;
  698. }
  700. public function setPaiDiffere($paiDiffere) {
  701. $this->paiDiffere = $paiDiffere;
  702. }
  704. public function setExcluTva($excluTva) {
  705. $this->excluTva = $excluTva;
  706. }
  708. public function setInvoiceType($invoiceType) {
  709. $this->invoiceType = $invoiceType;
  710. }
  712. public function setLanguage(\App\Entity\Language $language): void {
  713. $this->language = $language;
  714. }
  716. public function setLastLogin(?\DateTime $lastLogin): void {
  717. $this->lastLogin = $lastLogin;
  718. }
  720. public function setCreation(?\DateTime $creation): void {
  721. $this->creation = $creation;
  722. }
  724. public function setNbLogin(?int $nbLogin): void {
  725. $this->nbLogin = $nbLogin;
  726. }
  728. public function setAccountUpdate(?\DateTime $accountUpdate): void {
  729. $this->accountUpdate = $accountUpdate;
  730. }
  732. public function setSapId(?string $sapId): void {
  733. $this->sapId = $sapId;
  734. }
  736. public function setMetierSAP(?string $metierSAP): void {
  737. $this->metierSAP = $metierSAP;
  738. }
  740. public function setPriceGroups($priceGroups): void {
  741. $this->priceGroups = $priceGroups;
  742. }
  744. public function setExpert($expert): void {
  745. $this->expert = $expert;
  746. }
  748. public function setExpertId($expertId): void {
  749. $this->expertId = $expertId;
  750. }
  752. public function setConsentAdProducts($consentAdProducts): void {
  753. $this->consentAdProducts = $consentAdProducts;
  754. }
  756. public function setConsentAdOthers($consentAdOthers): void {
  757. $this->consentAdOthers = $consentAdOthers;
  758. }
  760. public function setConsentGroup($consentGroup): void {
  761. $this->consentGroup = $consentGroup;
  762. }
  764. public function hasSoleil() {
  765. $address = $this->getDefaultAddress();
  766. if($address){
  767. return $address->getCountry()->getSoleil() == 1;
  768. }
  769. return false;
  770. }
  772. public function hasBienvenue() {
  773. $address = $this->getDefaultAddress();
  774. if($address){
  775. return $address->getCountry()->getBienvenue() == 1;
  776. }
  777. return false;
  778. }
  780. public function hasPlatiniumDiscount() {
  781. $group = $this->getGroup();
  782. return $group && $group->getId() == 2;
  783. }
  785. public function hasEliteDiscount() {
  786. $group = $this->getGroup();
  787. return $group && $group->getId() == 3;
  788. }
  790. public function hasNoTva() {
  791. return $this->getExcluTva() == 1;
  792. }
  794. public function isValidated() {
  795. return is_null($this->status) || ($this->getStatus() == self::STATUS_VALIDATED);
  796. }
  798. public function hasPriceGroup(PriceGroup $priceGroup): self
  799. {
  800. return $this->priceGroups->contains($priceGroup);
  801. }
  803. public function addPriceGroup(CustomerPriceGroup $priceGroup): self
  804. {
  805. if (!$this->priceGroups->contains($priceGroup)) {
  806. $this->priceGroups->add($priceGroup);
  807. $priceGroup->setCustomer($this);
  808. }
  809. return $this;
  810. }
  812. public function removePriceGroup(CustomerPriceGroup $priceGroup): self
  813. {
  814. if ($this->priceGroups->removeElement($priceGroup)) {
  815. if ($priceGroup->getCustomer() === $this) {
  816. $priceGroup->setCustomer(null);
  817. }
  818. }
  819. return $this;
  820. }
  822. public function toArray() : array{
  824. $output = [
  825. 'id' => $this->getId(),
  826. 'purchasedWithoutAccount' => $this->getPurchasedWithoutAccount(),
  827. 'gender' => $this->getGender(),
  828. 'firstname' => $this->getFirstname(),
  829. 'lastname' => $this->getLastname(),
  830. 'dateOfBirth' => $this->getDateOfBirth(),
  831. 'email' => $this->getEmailAddress(),
  832. //'defaultAddressId' => $this->getDefaultAddress()?$this->getDefaultAddress()->getId():0,
  833. 'telephone' => $this->getTelephone(),
  834. 'fax' => $this->getFax(),
  835. 'newsletter' => $this->getNewsletter(),
  836. 'selectedTemplate' => $this->getSelectedTemplate(),
  837. 'group' => empty($this->group)?null:$this->getGroup()->toArray(),
  838. 'groupRa' => $this->getGroupRa(),
  839. 'paymentAllowed' => $this->getPaymentAllowed(),
  840. 'shipmentAllowed' => $this->getShipmentAllowed(),
  841. 'validationCode' => $this->getValidationCode(),
  842. 'validation' => $this->getValidation(),
  843. 'status' => $this->getStatus(),
  844. 'emailRegistered' => $this->getEmailRegistered(),
  845. 'sage' => $this->getSage(),
  846. 'company' => $this->getCompany(),
  847. 'referent' => $this->getReferent(),
  848. 'metier' => $this->getMetier(),
  849. 'autreprecisez' => $this->getId(),
  850. 'paiDiffere' => $this->getPaiDiffere(),
  851. 'excluTva' => $this->getExcluTva(),
  852. 'expert' => $this->getExpert(),
  853. 'expertId' => $this->getExpertId(),
  854. 'priceGroups' => []
  855. ];
  856. foreach($this->getPriceGroups() as $priceGroup) {
  857. $output['priceGroups'][] = $priceGroup->getGroup()->toArray();
  858. }
  859. return $output;
  861. }
  863. /**
  864. * @ORM\PrePersist
  865. */
  866. public function prePersist(\Doctrine\ORM\Event\LifecycleEventArgs $arg)
  867. {
  868. if(is_null($this->telephone)){
  869. $this->setTelephone('');
  870. }
  871. }
  873. /**
  874. * @ORM\PostLoad
  875. */
  876. public function postLoad(\Doctrine\ORM\Event\LifecycleEventArgs $arg)
  877. {
  878. if ($this->getGroup() && $this->getGroup()->getId() == 0) {
  879. $this->group = null;
  880. }
  881. // if($this->defaultAddressId) {
  882. // $address = $arg->getObjectManager()->getRepository('App:Address')->find($this->defaultAddressId);
  883. // if($address)
  884. // $this->setDefaultAddress($address);
  885. // }
  886. }
  889. }