src/Entity/Slave/Ticket.php line 15

Open in your IDE?
  1. <?php
  3. namespace App\Entity\Slave;
  5. use App\Twig\Extension\AppExtension;
  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;
  11. /**
  12.  * @ORM\Table(name="eposm_s_ticket")
  13.  * @ORM\Entity(repositoryClass="App\Repository\Slave\TicketRepository")
  14.  */
  15. class Ticket
  16. {    
  17.     public function canDelete($type){
  18.         switch($type){
  19.             case 'all':
  20.                 if(sizeof($this->getSuspensions()) > 0) return false;
  21.                 if(sizeof($this->getInterventions()) > 0) return false;
  22.                 break;
  23.             case 'activities':
  24.                 foreach($this->getInterventions() as $intervention){
  25.                     if($intervention->getOutcomeType()->getSlug() == 'comleted')
  26.                         return false;
  27.                 }
  28.                 break;
  29.         }
  30.         return true;
  31.     }
  32.     
  33.     public function canMakeActionByStatus($statusesSlug){
  34.         $array = array();
  35.         if(str_contains($statusesSlug, ','))
  36.             $array = explode(',', $statusesSlug);
  37.         else
  38.             array_push($array, $statusesSlug);
  40.         if(in_array($this->getStatus()->getSlug(), $array))
  41.             return true;
  42.         return false;
  43.     }
  45.     public function displayStatus($type)
  46.     {
  47.         if($this->isSystemError()){
  48.             $color = 'color_r';
  49.             $title = 'Con errori';
  50.         }
  51.         else{
  52.             switch($this->getStatus()->getSlug()){
  53.                 case 'to_assign': $color = 'color_lb'; break;
  54.                 case 'assigned': $color = 'color_am'; break;
  55.                 case 'taken_charge': $color = 'color_gr'; break;
  56.                 case 'suspension_request': $color = 'color_am'; break;
  57.                 case 'suspended': $color = 'color_r'; break;
  58.                 case 'closed': $color = 'color_gr'; break;
  59.                 case 'closed_portal': $color = 'color_gr_dark'; break;
  60.                 case 'canceled': $color = 'color_r'; break;
  61.                 case 'wrong': $color = 'color_r'; break;
  62.                 case 'temp': $color = 'color_r'; break;
  63.                 default: break;
  64.             }
  65.             $title = $this->getStatus()->getValue();
  66.         }
  68.         switch($type){
  69.             case 'icon': return '<i class="icon-circle cursor_p '.$color.'" data-bs-toggle="tooltip" title="'.$title.'"></i>'; break;
  70.             case 'string': return '<i class="icon-circle cursor_p '.$color.'"></i> '.$title; break;
  71.         }
  72.     }
  74.     public function displayJsonReport()
  75.     {
  76.         $html = '';
  77.         if($this->jsonReport != '[]'){
  78.             $matrix = json_decode($this->jsonReport, true);
  79.             foreach($matrix as $array)
  80.                 foreach($array as $a)
  81.                     $html.= '<tr><th>'.array_keys($array)[0].'</th><td colspan="2">'.$a.'</td></tr>';
  82.         }
  83.         return $html;
  84.     }
  86.     public function displayTableJson()
  87.     {
  88.         $html = '';
  89.         $first = true;
  90.         $matrix = json_decode($this->json, true);
  91.         $html.= '<table class="table table_no_padding m_b_none b_none font_12">';
  92.         foreach($matrix as $array)
  93.             foreach($array as $a)
  94.                 $html.= '<tr><th>'.array_keys($array)[0].'</th><td>'.$a.'</td></tr>';
  95.         
  96.         $html.= '</table>';
  97.         return $html;
  98.     }
  100.     public function displayJsonValueByColumn($column){
  101.         $matrix = json_decode($this->json, true);
  102.         foreach($matrix as $array)
  103.             foreach($array as $a)
  104.                 if(strtolower(array_keys($array)[0]) == strtolower($column))
  105.                     return $a;
  106.         return '';
  107.     }
  108.     
  109.     public function displayJsonReportValueByColumn($column){
  110.         $matrix = json_decode($this->jsonReport, true);
  111.         foreach($matrix as $array)
  112.             foreach($array as $a)
  113.                 if(strtolower(array_keys($array)[0]) == strtolower($column))
  114.                     return $a;
  115.         return '';
  116.     }
  117.     
  118.     public function displayNumberAndOperation()
  119.     {
  120.         return 'Numero: '.$this->getNumber().' --- Cliente: '.$this->getClient().' --- Operazione: '.$this->getOperation()->getValue();
  121.     }
  123.     public function getActualSuspension()
  124.     {
  125.         $now = new \Datetime();
  126.         foreach($this->getSuspensions() as $suspension){
  127.             if($suspension->getDatetimeFrom()->format('YmdHis') <= $now->format('YmdHis') && !$suspension->isUnlocked()){
  128.                 return $suspension;
  129.             }
  130.         }
  131.         return null;
  132.     }
  134.     public function getLastSuspension()
  135.     {
  136.         $returnSus = null;
  137.         $array = array();
  138.         foreach($this->getSuspensions() as $suspension){
  139.             if($suspension->isManaged() && $suspension->isApproved()){
  140.                 // SE LA DATA E' INDETERMINATA E' PER FORZA L'ULTIMA SOSPENSIONE, ALTRIMENTI AVREBBE UNA DATA DI SCADENZA
  141.                 if($suspension->getDatetimeTo() == null)
  142.                     return $suspension;
  143.                 array_push($array, $suspension);
  144.             }
  145.         }
  146.         $first = true;
  147.         foreach($array as $sus){
  148.             if($first || $returnSus->getDatetimeTo()->format('YmdHis') <= $sus->getDatetimeTo()->format('YmdHis')){
  149.                 $returnSus = $sus;
  150.                 $first = false;
  151.             }
  152.         }
  153.         return $returnSus;
  154.     }
  155.     
  156.     public function getInterventionCompleted()
  157.     {
  158.         foreach($this->getInterventions() as $intervention){
  159.             if($intervention->getOutcomeType()->getSlug() == 'completed'){
  160.                 return $intervention;
  161.             }
  162.         }
  163.         return null;
  164.     }
  166.     public function getOpenSuspension()
  167.     {
  168.         foreach($this->getSuspensions() as $sus){
  169.             if($sus->getDatetimeTo() == null && $sus->getRefuseMotivation() == 'Sospeso dal fornitore')
  170.                 return $sus;
  171.         }
  172.     }
  174.     /**
  175.      * @ORM\Column(name="id", type="bigint")
  176.      * @ORM\Id
  177.      * @ORM\GeneratedValue(strategy="AUTO")
  178.      */
  179.     protected $id;
  180.     
  181.     /**
  182.      * @ORM\Column(name="number", type="string", length=191, nullable=true)
  183.      */
  184.     protected $number;
  186.     /**
  187.      * @ORM\Column(name="datetime_import", type="datetime", nullable=true)
  188.      */
  189.     protected $datetimeImport;
  191.     /**
  192.      * @ORM\Column(name="datetime_start", type="datetime", nullable=true)
  193.      */
  194.     protected $datetimeStart;
  196.     /**
  197.      * @ORM\Column(name="datetime_expiration", type="datetime", nullable=true)
  198.      */
  199.     protected $datetimeExpiration;
  201.     /**
  202.      * @ORM\Column(name="datetime_end", type="datetime", nullable=true)
  203.      */
  204.     protected $datetimeEnd;
  206.     /**
  207.      * @ORM\Column(name="address", type="string", length=191, nullable=true)
  208.      */
  209.     protected $address;
  211.     /**
  212.      * @ORM\Column(name="locality", type="string", length=191, nullable=true)
  213.      */
  214.     protected $locality;
  216.     /**
  217.      * @ORM\Column(name="zip", type="string", length=191, nullable=true)
  218.      */
  219.     protected $zip;
  221.     /**
  222.      * @ORM\Column(name="id_city", type="bigint", nullable=true)
  223.      */
  224.     protected $idCity;
  226.     /**
  227.      * @ORM\Column(name="id_province", type="bigint", nullable=true)
  228.      */
  229.     protected $idProvince;
  230.     
  231.     /**
  232.      * @ORM\Column(name="other_city", type="string", length=191, nullable=true)
  233.      */
  234.     protected $otherCity;
  236.     /**
  237.      * @ORM\Column(name="system_error", type="boolean")
  238.      */
  239.     protected $systemError = false;
  240.     
  241.     /**
  242.      * @ORM\Column(name="system_error_slug", type="string", length=191, nullable=true)
  243.      */
  244.     protected $systemErrorSlug;
  246.     /**
  247.      * @ORM\Column(name="system_error_details", type="text", nullable=true)
  248.      */
  249.     protected $systemErrorDetails;
  250.     
  251.     /**
  252.      * @ORM\Column(name="json", type="text", nullable=true)
  253.      */
  254.     protected $json;
  255.     
  256.     /**
  257.      * @ORM\Column(name="directory_path", type="string", length=191)
  258.      */
  259.     protected $directoryPath;
  261.     /**
  262.      * @ORM\Column(name="waybill", type="string", length=191, nullable=true)
  263.      */
  264.     protected $waybill;
  265.     
  266.     /**
  267.      * @ORM\Column(name="json_report", type="text", nullable=true)
  268.      */
  269.     protected $jsonReport = '[]';
  270.     
  271.     /**
  272.      * @ORM\Column(name="billable", type="boolean")
  273.      */
  274.     protected $billable = true;
  276.     /**
  277.      * @ORM\Column(name="closed_on_portal", type="boolean")
  278.      */
  279.     protected $closedOnPortal = false;
  281.     // ManyToOne
  282.         /**
  283.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\Supplier", inversedBy="tickets")
  284.          * @ORM\JoinColumn(name="supplier_id", referencedColumnName="id")
  285.          */
  286.         private $supplier;
  288.         /**
  289.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\Client", inversedBy="tickets")
  290.          * @ORM\JoinColumn(name="client_id", referencedColumnName="id")
  291.          */
  292.         private $client;
  294.         /**
  295.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\Operation", inversedBy="tickets")
  296.          * @ORM\JoinColumn(name="operation_id", referencedColumnName="id")
  297.          */
  298.         private $operation;
  300.         /**
  301.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\User", inversedBy="tickets")
  302.          * @ORM\JoinColumn(name="technician_id", referencedColumnName="id")
  303.          */
  304.         private $technician;
  306.         /**
  307.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\TicketStatus", inversedBy="tickets")
  308.          * @ORM\JoinColumn(name="status_id", referencedColumnName="id")
  309.          */
  310.         private $status;
  311.         
  312.         /**
  313.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\Termid", inversedBy="tickets")
  314.          * @ORM\JoinColumn(name="termid_id", referencedColumnName="id")
  315.          */
  316.         private $termid;
  317.         
  318.         /**
  319.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\OperationTariffAmount", inversedBy="tickets")
  320.          * @ORM\JoinColumn(name="operation_tariff_amount_id", referencedColumnName="id")
  321.          */
  322.         private $operationTariffAmount;
  323.                 
  324.         /**
  325.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\OperationTariffAmount", inversedBy="uavTickets")
  326.          * @ORM\JoinColumn(name="uav_operation_tariff_amount_id", referencedColumnName="id")
  327.          */
  328.         private $uavOperationTariffAmount;
  329.     //
  331.     // OneToMany
  332.         /**
  333.          * @ORM\OneToMany(targetEntity="App\Entity\Slave\TicketSuspension", mappedBy="ticket")
  334.          */
  335.         private $suspensions;
  337.         /**
  338.          * @ORM\OneToMany(targetEntity="App\Entity\Slave\Intervention", mappedBy="ticket")
  339.          */
  340.         private $interventions;
  341.         
  342.         /**
  343.          * @ORM\OneToMany(targetEntity="App\Entity\Slave\TicketReminder", mappedBy="ticket")
  344.          */
  345.         private $reminders;
  347.         public function __construct()
  348.         {
  349.             $this->suspensions = new ArrayCollection();
  350.             $this->interventions = new ArrayCollection();
  351.             $this->reminders = new ArrayCollection();
  352.         }
  353.     //
  355.     public function getId(): ?string
  356.     {
  357.         return $this->id;
  358.     }
  360.     public function getNumber(): ?string
  361.     {
  362.         return $this->number;
  363.     }
  365.     public function setNumber(?string $number): static
  366.     {
  367.         $this->number = $number;
  369.         return $this;
  370.     }
  372.     public function getDatetimeImport(): ?\DateTimeInterface
  373.     {
  374.         return $this->datetimeImport;
  375.     }
  377.     public function setDatetimeImport(?\DateTimeInterface $datetimeImport): static
  378.     {
  379.         $this->datetimeImport = $datetimeImport;
  381.         return $this;
  382.     }
  384.     public function getDatetimeStart(): ?\DateTimeInterface
  385.     {
  386.         return $this->datetimeStart;
  387.     }
  389.     public function setDatetimeStart(?\DateTimeInterface $datetimeStart): static
  390.     {
  391.         $this->datetimeStart = $datetimeStart;
  393.         return $this;
  394.     }
  396.     public function getDatetimeExpiration(): ?\DateTimeInterface
  397.     {
  398.         return $this->datetimeExpiration;
  399.     }
  401.     public function setDatetimeExpiration(?\DateTimeInterface $datetimeExpiration): static
  402.     {
  403.         $this->datetimeExpiration = $datetimeExpiration;
  405.         return $this;
  406.     }
  408.     public function getDatetimeEnd(): ?\DateTimeInterface
  409.     {
  410.         return $this->datetimeEnd;
  411.     }
  413.     public function setDatetimeEnd(?\DateTimeInterface $datetimeEnd): static
  414.     {
  415.         $this->datetimeEnd = $datetimeEnd;
  417.         return $this;
  418.     }
  420.     public function getAddress(): ?string
  421.     {
  422.         return $this->address;
  423.     }
  425.     public function setAddress(?string $address): static
  426.     {
  427.         $this->address = $address;
  429.         return $this;
  430.     }
  432.     public function getLocality(): ?string
  433.     {
  434.         return $this->locality;
  435.     }
  437.     public function setLocality(?string $locality): static
  438.     {
  439.         $this->locality = $locality;
  441.         return $this;
  442.     }
  444.     public function getZip(): ?string
  445.     {
  446.         return $this->zip;
  447.     }
  449.     public function setZip(?string $zip): static
  450.     {
  451.         $this->zip = $zip;
  453.         return $this;
  454.     }
  456.     public function getIdCity(): ?string
  457.     {
  458.         return $this->idCity;
  459.     }
  461.     public function setIdCity(?string $idCity): static
  462.     {
  463.         $this->idCity = $idCity;
  465.         return $this;
  466.     }
  468.     public function getIdProvince(): ?string
  469.     {
  470.         return $this->idProvince;
  471.     }
  473.     public function setIdProvince(?string $idProvince): static
  474.     {
  475.         $this->idProvince = $idProvince;
  477.         return $this;
  478.     }
  480.     public function getOtherCity(): ?string
  481.     {
  482.         return $this->otherCity;
  483.     }
  485.     public function setOtherCity(?string $otherCity): static
  486.     {
  487.         $this->otherCity = $otherCity;
  489.         return $this;
  490.     }
  492.     public function isSystemError(): ?bool
  493.     {
  494.         return $this->systemError;
  495.     }
  497.     public function setSystemError(bool $systemError): static
  498.     {
  499.         $this->systemError = $systemError;
  501.         return $this;
  502.     }
  504.     public function getSystemErrorSlug(): ?string
  505.     {
  506.         return $this->systemErrorSlug;
  507.     }
  509.     public function setSystemErrorSlug(?string $systemErrorSlug): static
  510.     {
  511.         $this->systemErrorSlug = $systemErrorSlug;
  513.         return $this;
  514.     }
  516.     public function getSystemErrorDetails(): ?string
  517.     {
  518.         return $this->systemErrorDetails;
  519.     }
  521.     public function setSystemErrorDetails(?string $systemErrorDetails): static
  522.     {
  523.         $this->systemErrorDetails = $systemErrorDetails;
  525.         return $this;
  526.     }
  528.     public function getJson(): ?string
  529.     {
  530.         return $this->json;
  531.     }
  533.     public function setJson(?string $json): static
  534.     {
  535.         $this->json = $json;
  537.         return $this;
  538.     }
  540.     public function getDirectoryPath(): ?string
  541.     {
  542.         return $this->directoryPath;
  543.     }
  545.     public function setDirectoryPath(string $directoryPath): static
  546.     {
  547.         $this->directoryPath = $directoryPath;
  549.         return $this;
  550.     }
  552.     public function getJsonReport(): ?string
  553.     {
  554.         return $this->jsonReport;
  555.     }
  557.     public function setJsonReport(?string $jsonReport): static
  558.     {
  559.         $this->jsonReport = $jsonReport;
  561.         return $this;
  562.     }
  564.     public function isBillable(): ?bool
  565.     {
  566.         return $this->billable;
  567.     }
  569.     public function setBillable(bool $billable): static
  570.     {
  571.         $this->billable = $billable;
  573.         return $this;
  574.     }
  576.     public function isClosedOnPortal(): ?bool
  577.     {
  578.         return $this->closedOnPortal;
  579.     }
  581.     public function setClosedOnPortal(bool $closedOnPortal): static
  582.     {
  583.         $this->closedOnPortal = $closedOnPortal;
  585.         return $this;
  586.     }
  588.     public function getSupplier(): ?Supplier
  589.     {
  590.         return $this->supplier;
  591.     }
  593.     public function setSupplier(?Supplier $supplier): static
  594.     {
  595.         $this->supplier = $supplier;
  597.         return $this;
  598.     }
  600.     public function getClient(): ?Client
  601.     {
  602.         return $this->client;
  603.     }
  605.     public function setClient(?Client $client): static
  606.     {
  607.         $this->client = $client;
  609.         return $this;
  610.     }
  612.     public function getOperation(): ?Operation
  613.     {
  614.         return $this->operation;
  615.     }
  617.     public function setOperation(?Operation $operation): static
  618.     {
  619.         $this->operation = $operation;
  621.         return $this;
  622.     }
  624.     public function getTechnician(): ?User
  625.     {
  626.         return $this->technician;
  627.     }
  629.     public function setTechnician(?User $technician): static
  630.     {
  631.         $this->technician = $technician;
  633.         return $this;
  634.     }
  636.     public function getStatus(): ?TicketStatus
  637.     {
  638.         return $this->status;
  639.     }
  641.     public function setStatus(?TicketStatus $status): static
  642.     {
  643.         $this->status = $status;
  645.         return $this;
  646.     }
  648.     public function getTermid(): ?Termid
  649.     {
  650.         return $this->termid;
  651.     }
  653.     public function setTermid(?Termid $termid): static
  654.     {
  655.         $this->termid = $termid;
  657.         return $this;
  658.     }
  660.     public function getOperationTariffAmount(): ?OperationTariffAmount
  661.     {
  662.         return $this->operationTariffAmount;
  663.     }
  665.     public function setOperationTariffAmount(?OperationTariffAmount $operationTariffAmount): static
  666.     {
  667.         $this->operationTariffAmount = $operationTariffAmount;
  669.         return $this;
  670.     }
  672.     public function getUavOperationTariffAmount(): ?OperationTariffAmount
  673.     {
  674.         return $this->uavOperationTariffAmount;
  675.     }
  677.     public function setUavOperationTariffAmount(?OperationTariffAmount $uavOperationTariffAmount): static
  678.     {
  679.         $this->uavOperationTariffAmount = $uavOperationTariffAmount;
  681.         return $this;
  682.     }
  684.     /**
  685.      * @return Collection<int, TicketSuspension>
  686.      */
  687.     public function getSuspensions(): Collection
  688.     {
  689.         return $this->suspensions;
  690.     }
  692.     public function addSuspension(TicketSuspension $suspension): static
  693.     {
  694.         if (!$this->suspensions->contains($suspension)) {
  695.             $this->suspensions->add($suspension);
  696.             $suspension->setTicket($this);
  697.         }
  699.         return $this;
  700.     }
  702.     public function removeSuspension(TicketSuspension $suspension): static
  703.     {
  704.         if ($this->suspensions->removeElement($suspension)) {
  705.             // set the owning side to null (unless already changed)
  706.             if ($suspension->getTicket() === $this) {
  707.                 $suspension->setTicket(null);
  708.             }
  709.         }
  711.         return $this;
  712.     }
  714.     /**
  715.      * @return Collection<int, Intervention>
  716.      */
  717.     public function getInterventions(): Collection
  718.     {
  719.         return $this->interventions;
  720.     }
  722.     public function addIntervention(Intervention $intervention): static
  723.     {
  724.         if (!$this->interventions->contains($intervention)) {
  725.             $this->interventions->add($intervention);
  726.             $intervention->setTicket($this);
  727.         }
  729.         return $this;
  730.     }
  732.     public function removeIntervention(Intervention $intervention): static
  733.     {
  734.         if ($this->interventions->removeElement($intervention)) {
  735.             // set the owning side to null (unless already changed)
  736.             if ($intervention->getTicket() === $this) {
  737.                 $intervention->setTicket(null);
  738.             }
  739.         }
  741.         return $this;
  742.     }
  744.     /**
  745.      * @return Collection<int, TicketReminder>
  746.      */
  747.     public function getReminders(): Collection
  748.     {
  749.         return $this->reminders;
  750.     }
  752.     public function addReminder(TicketReminder $reminder): static
  753.     {
  754.         if (!$this->reminders->contains($reminder)) {
  755.             $this->reminders->add($reminder);
  756.             $reminder->setTicket($this);
  757.         }
  759.         return $this;
  760.     }
  762.     public function removeReminder(TicketReminder $reminder): static
  763.     {
  764.         if ($this->reminders->removeElement($reminder)) {
  765.             // set the owning side to null (unless already changed)
  766.             if ($reminder->getTicket() === $this) {
  767.                 $reminder->setTicket(null);
  768.             }
  769.         }
  771.         return $this;
  772.     }
  774.     public function getWaybill(): ?string
  775.     {
  776.         return $this->waybill;
  777.     }
  779.     public function setWaybill(?string $waybill): static
  780.     {
  781.         $this->waybill = $waybill;
  783.         return $this;
  784.     }
  785. }