src/Entity/Slave/Ticket.php line 20

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(
  13.  *     name="eposm_s_ticket",
  14.  *     uniqueConstraints={
  15.  *         @ORM\UniqueConstraint(columns={"number", "termid_id"})
  16.  *     }
  17.  * )
  18.  * @ORM\Entity(repositoryClass="App\Repository\Slave\TicketRepository")
  19.  */
  20. class Ticket
  21. {    
  22.     public function canDelete($type){
  23.         switch($type){
  24.             case 'all':
  25.                 if(sizeof($this->getSuspensions()) > 0) return false;
  26.                 if(sizeof($this->getInterventions()) > 0) return false;
  27.                 break;
  28.             case 'activities':
  29.                 foreach($this->getInterventions() as $intervention){
  30.                     if($intervention->getOutcomeType()->getSlug() == 'comleted')
  31.                         return false;
  32.                 }
  33.                 break;
  34.         }
  35.         return true;
  36.     }
  37.     
  38.     public function canMakeActionByStatus($statusesSlug){
  39.         $array = array();
  40.         if(str_contains($statusesSlug, ','))
  41.             $array = explode(',', $statusesSlug);
  42.         else
  43.             array_push($array, $statusesSlug);
  45.         if(in_array($this->getStatus()->getSlug(), $array))
  46.             return true;
  47.         return false;
  48.     }
  50.     public function displayStatus($type)
  51.     {
  52.         if($this->isSystemError()){
  53.             $color = 'color_r';
  54.             $title = 'Con errori';
  55.         }
  56.         else{
  57.             switch($this->getStatus()->getSlug()){
  58.                 case 'to_assign': $color = 'color_lb'; break;
  59.                 case 'assigned': $color = 'color_am'; break;
  60.                 case 'taken_charge': $color = 'color_gr'; break;
  61.                 case 'suspension_request': $color = 'color_am'; break;
  62.                 case 'suspended': $color = 'color_r'; break;
  63.                 case 'closed': $color = 'color_gr'; break;
  64.                 case 'closed_portal': $color = 'color_gr_dark'; break;
  65.                 case 'canceled': $color = 'color_r'; break;
  66.                 case 'wrong': $color = 'color_r'; break;
  67.                 case 'temp': $color = 'color_r'; break;
  68.                 default: break;
  69.             }
  70.             $title = $this->getStatus()->getValue();
  71.             if($this->getStatus()->getSlug() == 'taken_charge' && $this->isProcessed()){
  72.                 $color = 'color_gr_dark';
  73.                 $title = $this->getStatus()->getValue().' - Processato';
  74.             }
  75.         }
  77.         switch($type){
  78.             case 'icon': return '<i class="icon-circle cursor_p '.$color.'" data-bs-toggle="tooltip" title="'.$title.'"></i>'; break;
  79.             case 'string': return '<i class="icon-circle cursor_p '.$color.'"></i> '.$title; break;
  80.         }
  81.     }
  83.     public function displayJsonReport()
  84.     {
  85.         $html = '';
  86.         if($this->jsonReport != '[]'){
  87.             $matrix = json_decode($this->jsonReport, true);
  88.             foreach($matrix as $array)
  89.                 foreach($array as $a)
  90.                     $html.= '<tr><th>'.array_keys($array)[0].'</th><td colspan="2">'.$a.'</td></tr>';
  91.         }
  92.         return $html;
  93.     }
  95.     public function displayTableJson()
  96.     {
  97.         $html = '';
  98.         $first = true;
  99.         $matrix = json_decode($this->json, true);
  100.         $html.= '<table class="table table_no_padding m_b_none b_none font_12">';
  101.         foreach($matrix as $array)
  102.             foreach($array as $a)
  103.                 $html.= '<tr><th>'.array_keys($array)[0].'</th><td>'.$a.'</td></tr>';
  104.         
  105.         $html.= '</table>';
  106.         return $html;
  107.     }
  109.     public function displayJsonValueByColumn($column){
  110.         $matrix = json_decode($this->json, 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 displayJsonReportValueByColumn($column){
  119.         $matrix = json_decode($this->jsonReport, true);
  120.         foreach($matrix as $array)
  121.             foreach($array as $a)
  122.                 if(strtolower(array_keys($array)[0]) == strtolower($column))
  123.                     return $a;
  124.         return '';
  125.     }
  126.     
  127.     public function displayNumberAndOperation()
  128.     {
  129.         return 'Numero: '.$this->getNumber().' --- Cliente: '.$this->getClient().' --- Operazione: '.$this->getOperation()->getValue();
  130.     }
  132.     public function getActualSuspension()
  133.     {
  134.         $now = new \Datetime();
  135.         foreach($this->getSuspensions() as $suspension){
  136.             if($suspension->getDatetimeFrom()->format('YmdHis') <= $now->format('YmdHis') && !$suspension->isUnlocked()){
  137.                 return $suspension;
  138.             }
  139.         }
  140.         return null;
  141.     }
  143.     public function getLastSuspension()
  144.     {
  145.         $returnSus = null;
  146.         $array = array();
  147.         foreach($this->getSuspensions() as $suspension){
  148.             if($suspension->isManaged() && $suspension->isApproved()){
  149.                 // SE LA DATA E' INDETERMINATA E' PER FORZA L'ULTIMA SOSPENSIONE, ALTRIMENTI AVREBBE UNA DATA DI SCADENZA
  150.                 if($suspension->getDatetimeTo() == null)
  151.                     return $suspension;
  152.                 array_push($array, $suspension);
  153.             }
  154.         }
  155.         $first = true;
  156.         foreach($array as $sus){
  157.             if($first || $returnSus->getDatetimeTo()->format('YmdHis') <= $sus->getDatetimeTo()->format('YmdHis')){
  158.                 $returnSus = $sus;
  159.                 $first = false;
  160.             }
  161.         }
  162.         return $returnSus;
  163.     }
  164.     
  165.     public function getInterventionCompleted()
  166.     {
  167.         foreach($this->getInterventions() as $intervention){
  168.             if($intervention->getOutcomeType()->getSlug() == 'completed'){
  169.                 return $intervention;
  170.             }
  171.         }
  172.         return null;
  173.     }
  175.     public function getOpenSuspension()
  176.     {
  177.         foreach($this->getSuspensions() as $sus){
  178.             if($sus->getDatetimeTo() == null && $sus->getRefuseMotivation() == 'Sospeso dal fornitore')
  179.                 return $sus;
  180.         }
  181.     }
  183.     /**
  184.      * @ORM\Column(name="id", type="bigint")
  185.      * @ORM\Id
  186.      * @ORM\GeneratedValue(strategy="AUTO")
  187.      */
  188.     protected $id;
  189.     
  190.     /**
  191.      * @ORM\Column(name="number", type="string", length=191, nullable=true)
  192.      */
  193.     protected $number;
  195.     /**
  196.      * @ORM\Column(name="datetime_import", type="datetime", nullable=true)
  197.      */
  198.     protected $datetimeImport;
  200.     /**
  201.      * @ORM\Column(name="datetime_start", type="datetime", nullable=true)
  202.      */
  203.     protected $datetimeStart;
  205.     /**
  206.      * @ORM\Column(name="datetime_expiration", type="datetime", nullable=true)
  207.      */
  208.     protected $datetimeExpiration;
  210.     /**
  211.      * @ORM\Column(name="datetime_end", type="datetime", nullable=true)
  212.      */
  213.     protected $datetimeEnd;
  215.     /**
  216.      * @ORM\Column(name="address", type="string", length=191, nullable=true)
  217.      */
  218.     protected $address;
  220.     /**
  221.      * @ORM\Column(name="locality", type="string", length=191, nullable=true)
  222.      */
  223.     protected $locality;
  225.     /**
  226.      * @ORM\Column(name="zip", type="string", length=191, nullable=true)
  227.      */
  228.     protected $zip;
  230.     /**
  231.      * @ORM\Column(name="id_city", type="bigint", nullable=true)
  232.      */
  233.     protected $idCity;
  235.     /**
  236.      * @ORM\Column(name="id_province", type="bigint", nullable=true)
  237.      */
  238.     protected $idProvince;
  239.     
  240.     /**
  241.      * @ORM\Column(name="other_city", type="string", length=191, nullable=true)
  242.      */
  243.     protected $otherCity;
  245.     /**
  246.      * @ORM\Column(name="system_error", type="boolean")
  247.      */
  248.     protected $systemError = false;
  249.     
  250.     /**
  251.      * @ORM\Column(name="system_error_slug", type="string", length=191, nullable=true)
  252.      */
  253.     protected $systemErrorSlug;
  255.     /**
  256.      * @ORM\Column(name="system_error_details", type="text", nullable=true)
  257.      */
  258.     protected $systemErrorDetails;
  259.     
  260.     /**
  261.      * @ORM\Column(name="json", type="text", nullable=true)
  262.      */
  263.     protected $json;
  264.     
  265.     /**
  266.      * @ORM\Column(name="directory_path", type="string", length=191)
  267.      */
  268.     protected $directoryPath;
  270.     /**
  271.      * @ORM\Column(name="waybill", type="string", length=191, nullable=true)
  272.      */
  273.     protected $waybill;
  274.     
  275.     /**
  276.      * @ORM\Column(name="billable", type="boolean")
  277.      */
  278.     protected $billable = true;
  279.     
  280.     /**
  281.      * @ORM\Column(name="json_report", type="text", nullable=true)
  282.      */
  283.     protected $jsonReport = '[]';
  284.     
  285.     /**
  286.      * @ORM\Column(name="report_printed", type="boolean")
  287.      */
  288.     protected $reportPrinted = false;
  289.     
  290.     /**
  291.      * @ORM\Column(name="processed", type="boolean")
  292.      */
  293.     protected $processed = false;
  295.     /**
  296.      * @ORM\Column(name="closed_on_portal", type="boolean")
  297.      */
  298.     protected $closedOnPortal = false;
  300.     // ManyToOne
  301.         /**
  302.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\Supplier", inversedBy="tickets")
  303.          * @ORM\JoinColumn(name="supplier_id", referencedColumnName="id")
  304.          */
  305.         private $supplier;
  307.         /**
  308.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\Client", inversedBy="tickets")
  309.          * @ORM\JoinColumn(name="client_id", referencedColumnName="id")
  310.          */
  311.         private $client;
  313.         /**
  314.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\Operation", inversedBy="tickets")
  315.          * @ORM\JoinColumn(name="operation_id", referencedColumnName="id")
  316.          */
  317.         private $operation;
  319.         /**
  320.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\User", inversedBy="tickets")
  321.          * @ORM\JoinColumn(name="technician_id", referencedColumnName="id")
  322.          */
  323.         private $technician;
  325.         /**
  326.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\TicketStatus", inversedBy="tickets")
  327.          * @ORM\JoinColumn(name="status_id", referencedColumnName="id")
  328.          */
  329.         private $status;
  330.         
  331.         /**
  332.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\Termid", inversedBy="tickets")
  333.          * @ORM\JoinColumn(name="termid_id", referencedColumnName="id")
  334.          */
  335.         private $termid;
  336.         
  337.         /**
  338.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\OperationTariffAmount", inversedBy="tickets")
  339.          * @ORM\JoinColumn(name="operation_tariff_amount_id", referencedColumnName="id")
  340.          */
  341.         private $operationTariffAmount;
  342.                 
  343.         /**
  344.          * @ORM\ManyToOne(targetEntity="App\Entity\Slave\OperationTariffAmount", inversedBy="uavTickets")
  345.          * @ORM\JoinColumn(name="uav_operation_tariff_amount_id", referencedColumnName="id")
  346.          */
  347.         private $uavOperationTariffAmount;
  348.     //
  350.     // OneToMany
  351.         /**
  352.          * @ORM\OneToMany(targetEntity="App\Entity\Slave\TicketSuspension", mappedBy="ticket")
  353.          */
  354.         private $suspensions;
  356.         /**
  357.          * @ORM\OneToMany(targetEntity="App\Entity\Slave\Intervention", mappedBy="ticket")
  358.          */
  359.         private $interventions;
  360.         
  361.         /**
  362.          * @ORM\OneToMany(targetEntity="App\Entity\Slave\TicketReminder", mappedBy="ticket")
  363.          */
  364.         private $reminders;
  366.         public function __construct()
  367.         {
  368.             $this->suspensions = new ArrayCollection();
  369.             $this->interventions = new ArrayCollection();
  370.             $this->reminders = new ArrayCollection();
  371.         }
  372.     //
  374.     public function getId(): ?string
  375.     {
  376.         return $this->id;
  377.     }
  379.     public function getNumber(): ?string
  380.     {
  381.         return $this->number;
  382.     }
  384.     public function setNumber(?string $number): static
  385.     {
  386.         $this->number = $number;
  388.         return $this;
  389.     }
  391.     public function getDatetimeImport(): ?\DateTimeInterface
  392.     {
  393.         return $this->datetimeImport;
  394.     }
  396.     public function setDatetimeImport(?\DateTimeInterface $datetimeImport): static
  397.     {
  398.         $this->datetimeImport = $datetimeImport;
  400.         return $this;
  401.     }
  403.     public function getDatetimeStart(): ?\DateTimeInterface
  404.     {
  405.         return $this->datetimeStart;
  406.     }
  408.     public function setDatetimeStart(?\DateTimeInterface $datetimeStart): static
  409.     {
  410.         $this->datetimeStart = $datetimeStart;
  412.         return $this;
  413.     }
  415.     public function getDatetimeExpiration(): ?\DateTimeInterface
  416.     {
  417.         return $this->datetimeExpiration;
  418.     }
  420.     public function setDatetimeExpiration(?\DateTimeInterface $datetimeExpiration): static
  421.     {
  422.         $this->datetimeExpiration = $datetimeExpiration;
  424.         return $this;
  425.     }
  427.     public function getDatetimeEnd(): ?\DateTimeInterface
  428.     {
  429.         return $this->datetimeEnd;
  430.     }
  432.     public function setDatetimeEnd(?\DateTimeInterface $datetimeEnd): static
  433.     {
  434.         $this->datetimeEnd = $datetimeEnd;
  436.         return $this;
  437.     }
  439.     public function getAddress(): ?string
  440.     {
  441.         return $this->address;
  442.     }
  444.     public function setAddress(?string $address): static
  445.     {
  446.         $this->address = $address;
  448.         return $this;
  449.     }
  451.     public function getLocality(): ?string
  452.     {
  453.         return $this->locality;
  454.     }
  456.     public function setLocality(?string $locality): static
  457.     {
  458.         $this->locality = $locality;
  460.         return $this;
  461.     }
  463.     public function getZip(): ?string
  464.     {
  465.         return $this->zip;
  466.     }
  468.     public function setZip(?string $zip): static
  469.     {
  470.         $this->zip = $zip;
  472.         return $this;
  473.     }
  475.     public function getIdCity(): ?string
  476.     {
  477.         return $this->idCity;
  478.     }
  480.     public function setIdCity(?string $idCity): static
  481.     {
  482.         $this->idCity = $idCity;
  484.         return $this;
  485.     }
  487.     public function getIdProvince(): ?string
  488.     {
  489.         return $this->idProvince;
  490.     }
  492.     public function setIdProvince(?string $idProvince): static
  493.     {
  494.         $this->idProvince = $idProvince;
  496.         return $this;
  497.     }
  499.     public function getOtherCity(): ?string
  500.     {
  501.         return $this->otherCity;
  502.     }
  504.     public function setOtherCity(?string $otherCity): static
  505.     {
  506.         $this->otherCity = $otherCity;
  508.         return $this;
  509.     }
  511.     public function isSystemError(): ?bool
  512.     {
  513.         return $this->systemError;
  514.     }
  516.     public function setSystemError(bool $systemError): static
  517.     {
  518.         $this->systemError = $systemError;
  520.         return $this;
  521.     }
  523.     public function getSystemErrorSlug(): ?string
  524.     {
  525.         return $this->systemErrorSlug;
  526.     }
  528.     public function setSystemErrorSlug(?string $systemErrorSlug): static
  529.     {
  530.         $this->systemErrorSlug = $systemErrorSlug;
  532.         return $this;
  533.     }
  535.     public function getSystemErrorDetails(): ?string
  536.     {
  537.         return $this->systemErrorDetails;
  538.     }
  540.     public function setSystemErrorDetails(?string $systemErrorDetails): static
  541.     {
  542.         $this->systemErrorDetails = $systemErrorDetails;
  544.         return $this;
  545.     }
  547.     public function getJson(): ?string
  548.     {
  549.         return $this->json;
  550.     }
  552.     public function setJson(?string $json): static
  553.     {
  554.         $this->json = $json;
  556.         return $this;
  557.     }
  559.     public function getDirectoryPath(): ?string
  560.     {
  561.         return $this->directoryPath;
  562.     }
  564.     public function setDirectoryPath(string $directoryPath): static
  565.     {
  566.         $this->directoryPath = $directoryPath;
  568.         return $this;
  569.     }
  571.     public function getWaybill(): ?string
  572.     {
  573.         return $this->waybill;
  574.     }
  576.     public function setWaybill(?string $waybill): static
  577.     {
  578.         $this->waybill = $waybill;
  580.         return $this;
  581.     }
  583.     public function isBillable(): ?bool
  584.     {
  585.         return $this->billable;
  586.     }
  588.     public function setBillable(bool $billable): static
  589.     {
  590.         $this->billable = $billable;
  592.         return $this;
  593.     }
  595.     public function getJsonReport(): ?string
  596.     {
  597.         return $this->jsonReport;
  598.     }
  600.     public function setJsonReport(?string $jsonReport): static
  601.     {
  602.         $this->jsonReport = $jsonReport;
  604.         return $this;
  605.     }
  607.     public function isReportPrinted(): ?bool
  608.     {
  609.         return $this->reportPrinted;
  610.     }
  612.     public function setReportPrinted(bool $reportPrinted): static
  613.     {
  614.         $this->reportPrinted = $reportPrinted;
  616.         return $this;
  617.     }
  619.     public function isProcessed(): ?bool
  620.     {
  621.         return $this->processed;
  622.     }
  624.     public function setProcessed(bool $processed): static
  625.     {
  626.         $this->processed = $processed;
  628.         return $this;
  629.     }
  631.     public function isClosedOnPortal(): ?bool
  632.     {
  633.         return $this->closedOnPortal;
  634.     }
  636.     public function setClosedOnPortal(bool $closedOnPortal): static
  637.     {
  638.         $this->closedOnPortal = $closedOnPortal;
  640.         return $this;
  641.     }
  643.     public function getSupplier(): ?Supplier
  644.     {
  645.         return $this->supplier;
  646.     }
  648.     public function setSupplier(?Supplier $supplier): static
  649.     {
  650.         $this->supplier = $supplier;
  652.         return $this;
  653.     }
  655.     public function getClient(): ?Client
  656.     {
  657.         return $this->client;
  658.     }
  660.     public function setClient(?Client $client): static
  661.     {
  662.         $this->client = $client;
  664.         return $this;
  665.     }
  667.     public function getOperation(): ?Operation
  668.     {
  669.         return $this->operation;
  670.     }
  672.     public function setOperation(?Operation $operation): static
  673.     {
  674.         $this->operation = $operation;
  676.         return $this;
  677.     }
  679.     public function getTechnician(): ?User
  680.     {
  681.         return $this->technician;
  682.     }
  684.     public function setTechnician(?User $technician): static
  685.     {
  686.         $this->technician = $technician;
  688.         return $this;
  689.     }
  691.     public function getStatus(): ?TicketStatus
  692.     {
  693.         return $this->status;
  694.     }
  696.     public function setStatus(?TicketStatus $status): static
  697.     {
  698.         $this->status = $status;
  700.         return $this;
  701.     }
  703.     public function getTermid(): ?Termid
  704.     {
  705.         return $this->termid;
  706.     }
  708.     public function setTermid(?Termid $termid): static
  709.     {
  710.         $this->termid = $termid;
  712.         return $this;
  713.     }
  715.     public function getOperationTariffAmount(): ?OperationTariffAmount
  716.     {
  717.         return $this->operationTariffAmount;
  718.     }
  720.     public function setOperationTariffAmount(?OperationTariffAmount $operationTariffAmount): static
  721.     {
  722.         $this->operationTariffAmount = $operationTariffAmount;
  724.         return $this;
  725.     }
  727.     public function getUavOperationTariffAmount(): ?OperationTariffAmount
  728.     {
  729.         return $this->uavOperationTariffAmount;
  730.     }
  732.     public function setUavOperationTariffAmount(?OperationTariffAmount $uavOperationTariffAmount): static
  733.     {
  734.         $this->uavOperationTariffAmount = $uavOperationTariffAmount;
  736.         return $this;
  737.     }
  739.     /**
  740.      * @return Collection<int, TicketSuspension>
  741.      */
  742.     public function getSuspensions(): Collection
  743.     {
  744.         return $this->suspensions;
  745.     }
  747.     public function addSuspension(TicketSuspension $suspension): static
  748.     {
  749.         if (!$this->suspensions->contains($suspension)) {
  750.             $this->suspensions->add($suspension);
  751.             $suspension->setTicket($this);
  752.         }
  754.         return $this;
  755.     }
  757.     public function removeSuspension(TicketSuspension $suspension): static
  758.     {
  759.         if ($this->suspensions->removeElement($suspension)) {
  760.             // set the owning side to null (unless already changed)
  761.             if ($suspension->getTicket() === $this) {
  762.                 $suspension->setTicket(null);
  763.             }
  764.         }
  766.         return $this;
  767.     }
  769.     /**
  770.      * @return Collection<int, Intervention>
  771.      */
  772.     public function getInterventions(): Collection
  773.     {
  774.         return $this->interventions;
  775.     }
  777.     public function addIntervention(Intervention $intervention): static
  778.     {
  779.         if (!$this->interventions->contains($intervention)) {
  780.             $this->interventions->add($intervention);
  781.             $intervention->setTicket($this);
  782.         }
  784.         return $this;
  785.     }
  787.     public function removeIntervention(Intervention $intervention): static
  788.     {
  789.         if ($this->interventions->removeElement($intervention)) {
  790.             // set the owning side to null (unless already changed)
  791.             if ($intervention->getTicket() === $this) {
  792.                 $intervention->setTicket(null);
  793.             }
  794.         }
  796.         return $this;
  797.     }
  799.     /**
  800.      * @return Collection<int, TicketReminder>
  801.      */
  802.     public function getReminders(): Collection
  803.     {
  804.         return $this->reminders;
  805.     }
  807.     public function addReminder(TicketReminder $reminder): static
  808.     {
  809.         if (!$this->reminders->contains($reminder)) {
  810.             $this->reminders->add($reminder);
  811.             $reminder->setTicket($this);
  812.         }
  814.         return $this;
  815.     }
  817.     public function removeReminder(TicketReminder $reminder): static
  818.     {
  819.         if ($this->reminders->removeElement($reminder)) {
  820.             // set the owning side to null (unless already changed)
  821.             if ($reminder->getTicket() === $this) {
  822.                 $reminder->setTicket(null);
  823.             }
  824.         }
  826.         return $this;
  827.     }
  829. }