src/Service/ProductService.php line 197

Open in your IDE?
  1. <?php
  3. namespace App\Service;
  5. use App\Entity\Slave\Product;
  6. use App\Entity\Slave\ProductLog;
  7. use App\Entity\Slave\ProductRegenerated;
  8. use App\Entity\Slave\ProductTransferLog;
  9. use App\Entity\Slave\JoinTableProductProductTransfer;
  11. class ProductService
  12. {  
  13.     // MAGAZZINI - PRODOTTI/MATRICOLE
  14.     static public function getStatusByCondition($em, $condition){
  15.         $status = null;
  16.         switch($condition->getSlug()){
  17.             case 'new':
  18.             case 'refurbished':
  19.             case 'repaired':
  20.             case 'free':
  21.             case 'regenerated':
  22.                 $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  23.                 break;
  24.             case 'retired':
  25.             case 'doa':
  26.             case 'lost':
  27.             case 'broken':
  28.             case 'old':
  29.                 $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available'));
  30.                 break;
  31.             default: break;
  32.         }
  33.         return $status;
  34.     }
  36.     // MAGAZZINI - PRODOTTI/MATRICOLE
  37.     static public function checkProducts($file, $separator){
  38.         $row = 0;
  39.         $result = array();
  40.         if(($handle = fopen($file, "r")) !== FALSE) {
  41.             while(($data = fgetcsv($handle, 1000, $separator)) !== FALSE) {
  42.                 $data = array_map("utf8_encode", $data);
  43.                 if(sizeof($data) < 2){
  44.                     $result['error'] = true;
  45.                     $result['msg'] = "Si è verificato un errore durante l'importazione del file; verificare di aver inserito il separatore corretto!";
  46.                     break;
  47.                 }
  48.                 else{
  49.                     if($row > 0){
  50.                         $result = ProductService::checkData($data[0], "textNull", $row, "Matricola produttore"); if($result['error']) break;
  51.                         $result = ProductService::checkData($data[1], "textNull", $row, "Matricola fornitore"); if($result['error']) break;
  52.                     }
  53.                     $row++;
  54.                 }
  55.             }
  56.             fclose($handle);
  57.         }
  58.         return $result;
  59.     }
  60.     
  61.     // CHECK DATA
  62.     static public function checkData($data, $type, $row, $columnName){
  63.         $result = array();
  65.         switch($type){
  66.             case 'text': 
  67.                 if($data == "" || $data == null || strlen($data) > 255){
  68.                     $result['error'] = true;
  69.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  70.                 }
  71.                 else
  72.                     $result['error'] = false;
  73.                 break;
  74.             case 'textNull': 
  75.                 if(strlen($data) > 255){
  76.                     $result['error'] = true;
  77.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  78.                 }
  79.                 else
  80.                     $result['error'] = false;
  81.                 break;
  82.             case 'zip': 
  83.                 if($data == "" || $data == null || strlen($data) != 5){
  84.                     $result['error'] = true;
  85.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  86.                 }
  87.                 else
  88.                     $result['error'] = false;
  89.                 break;
  90.             case 'zipNull': 
  91.                 if($data != "" && $data != null && strlen($data) != 5){
  92.                     $result['error'] = true;
  93.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  94.                 }
  95.                 else
  96.                     $result['error'] = false;
  97.                 break;
  98.             case 'value': 
  99.                 if($data == "" || $data == null || floatval(preg_replace('/,/', '.', $data)) == 0){
  100.                     $result['error'] = true;
  101.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  102.                 }
  103.                 else
  104.                     $result['error'] = false;
  105.                 break;
  106.             case 'date':
  107.                 $date = date_create_from_format("d/m/Y", $data);
  108.                 if($date !== false){
  109.                     $result['error'] = false;
  110.                     $result['date'] = $date;
  111.                 }
  112.                 else{
  113.                     $result['error'] = true;
  114.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  115.                 }
  116.                 break;
  117.             case 'dateNull':
  118.                 if($data != "" || $data != null){
  119.                     $date = date_create_from_format("d/m/Y", $data);
  120.                     if($date !== false){
  121.                         $result['error'] = false;
  122.                         $result['date'] = $date;
  123.                     }
  124.                     else{
  125.                         $result['error'] = true;
  126.                         $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  127.                     }
  128.                 }
  129.                 else{
  130.                     $result['error'] = false;
  131.                     $result['date'] = '';
  132.                 }
  133.                 break;
  134.             case 'sex':
  135.                 if($data != 'M' && $data != 'F'){
  136.                     $result['error'] = true;
  137.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  138.                 }
  139.                 else
  140.                     $result['error'] = false;
  141.                 break;
  142.             case 'fiscalcode':
  143.                 if(strlen($data) != 11 && strlen($data) != 16){
  144.                     $result['error'] = true;
  145.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  146.                 }
  147.                 else
  148.                     $result['error'] = false;
  149.                 break;
  150.             case 'bool':
  151.                 if($data != 0 && $data != 1){
  152.                     $result['error'] = true;
  153.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  154.                 }
  155.                 else
  156.                     $result['error'] = false;
  157.                 break;
  158.             case 'vat':
  159.                 if(strlen($data) != 11){
  160.                     $result['error'] = true;
  161.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  162.                 }
  163.                 else
  164.                     $result['error'] = false;
  165.                 break;
  166.             case 'num8':
  167.                 if($data != 1 && $data != 2 && $data != 3 && $data != 4 && $data != 5 && $data != 6 && $data != 7 && $data != 8){
  168.                     $result['error'] = true;
  169.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  170.                 }
  171.                 else
  172.                     $result['error'] = false;
  173.                 break;
  174.             case 'num10':
  175.                 if($data != 1 && $data != 2 && $data != 3 && $data != 4 && $data != 5 && $data != 6 && $data != 7 && $data != 8 && $data != 9 && $data != 10){
  176.                     $result['error'] = true;
  177.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  178.                 }
  179.                 else
  180.                     $result['error'] = false;
  181.                 break;
  182.             case 'num33':
  183.                 if($data != 1 && $data != 2 && $data != 3 && $data != 4 && $data != 5 && $data != 6 && $data != 7 && $data != 8 && $data != 9 && $data != 10 && $data != 11 && $data != 12 && $data != 13 && $data != 14 && $data != 15 && $data != 16 && $data != 17 && $data != 18 && $data != 19 && $data != 20 && $data != 21 && $data != 22 && $data != 23 && $data != 24 && $data != 25 && $data != 26 && $data != 27 && $data != 28 && $data != 29 && $data != 30 && $data != 31 && $data != 32 && $data != 33){
  184.                     $result['error'] = true;
  185.                     $result['msg'] = "Si è verificato un errore alla riga ".($row + 1)." nella colonna '".$columnName."'.";
  186.                 }
  187.                 else
  188.                     $result['error'] = false;
  189.                 break;
  190.             break;
  191.         }
  193.         return $result;
  194.     }
  196.     // CREO PRODOTTO
  197.     static public function createProduct($em, $model, $codeProducer, $codeSupplier, $suppliers, $status, $condition)
  198.     {
  199.         $product = new Product();
  200.         $product->setDateCreation(new \Datetime());
  201.         $product->setDateLastTransfer(new \Datetime());
  202.         $em->persist($product);
  203.         $em->flush();
  204.         $p = ProductService::updateProduct($em, $product, $model, $codeProducer, $codeSupplier, $suppliers, $status, $condition);
  205.         return $p;
  206.     }
  208.     // AGGIORNO PRODOTTO
  209.     static public function updateProduct($em, $product, $model, $codeProducer, $codeSupplier, $suppliers, $status, $condition)
  210.     {
  211.         $product->setModel($model);
  212.         if($codeProducer != '') $product->setCodeProducer($codeProducer);
  213.         if($codeSupplier != '') $product->setCodeSupplier($codeSupplier);
  214.         foreach($product->getSuppliers() as $sup) $product->removeSupplier($sup);
  215.         foreach($suppliers as $sup) $product->addSupplier($sup);
  216.         $product->setStatus($status);
  217.         $product->setActive(true);
  218.         $product->setCondition($condition);
  219.         $em->flush();
  220.         return $product;
  221.     }
  222.     
  223.     // CREO JT PRODUCT TRANSFER
  224.     static public function createJtProductTransfer($em, $product, $transfer, $datetime)
  225.     {
  226.         $jtppt = new JoinTableProductProductTransfer();
  227.         $jtppt->setProduct($product);
  228.         $jtppt->setTransfer($transfer);
  229.         $jtppt->setTransferOk(false);
  230.         $em->persist($jtppt);
  231.         $em->flush();
  232.     }
  233.     
  234.     // CREO TRANSFER LOG
  235.     static public function createProductTransferLog($em, $product, $transfer, $user, $warehouse, $datetime, $downloadType)
  236.     {
  237.         $ptLog = new ProductTransferLog();
  238.         $ptLog->setProduct($product);
  239.         $ptLog->setTransfer($transfer);
  240.         $ptLog->setUser($user);
  241.         $ptLog->setProductName($product->getModel()->getName().' ('.$product->getModel()->getSku().')');
  242.         $ptLog->setCodeSupplier($product->getCodeSupplier());
  243.         $ptLog->setCodeProducer($product->getCodeProducer());
  244.         if($transfer != null){
  245.             $ptLog->setWarehouseFrom($transfer->getWarehouseFrom()->getNickname());
  246.             $ptLog->setWarehouseTo($transfer->getWarehouseTo()->getNickname());
  247.             $ptLog->setDdt($transfer->getDdt());
  248.             $ptLog->setDdtPath($transfer->getDdtPath());
  249.         }
  250.         else{
  251.             $ptLog->setWarehouseFrom($product->getActualWarehouse()->getNickname());
  252.             $ptLog->setWarehouseTo($warehouse->getNickname());
  253.         }
  254.         $ptLog->setUserName($user->getProfile()->getName().' '.$user->getProfile()->getSurname());
  255.         $ptLog->setDownloadType($downloadType);
  256.         $ptLog->setDatetime($datetime);
  257.         $em->persist($ptLog);
  258.         $em->flush();
  259.     }
  261.     static public function createProductTransferBackLog($em, $product, $transfer, $user, $warehouse, $datetime, $downloadType)
  262.     {
  263.         $ptLog = new ProductTransferLog();
  264.         $ptLog->setProduct($product);
  265.         $ptLog->setTransfer($transfer);
  266.         $ptLog->setUser($user);
  267.         $ptLog->setProductName($product->getModel()->getName().' ('.$product->getModel()->getSku().')');
  268.         $ptLog->setCodeSupplier($product->getCodeSupplier());
  269.         $ptLog->setCodeProducer($product->getCodeProducer());
  270.         $ptLog->setWarehouseFrom($transfer->getWarehouseTo()->getNickname());
  271.         $ptLog->setWarehouseTo($transfer->getWarehouseFrom()->getNickname());
  272.         $ptLog->setDdt($transfer->getDdt());
  273.         $ptLog->setDdtPath($transfer->getDdtPath());
  274.         $ptLog->setUserName($user->getProfile()->getName().' '.$user->getProfile()->getSurname());
  275.         $ptLog->setDownloadType($downloadType);
  276.         $ptLog->setDatetime($datetime);
  277.         $em->persist($ptLog);
  278.         $em->flush();
  279.     }
  280.     
  281.     static public function createProductTransferLogClient($em, $product, $user, $warehouseFrom, $warehouseTo, $datetime, $downloadType)
  282.     {
  283.         $ptLog = new ProductTransferLog();
  284.         $ptLog->setProduct($product);
  285.         $ptLog->setTransfer(null);
  286.         $ptLog->setUser($user);
  287.         $ptLog->setProductName($product->getModel()->getName().' ('.$product->getModel()->getSku().')');
  288.         $ptLog->setCodeSupplier($product->getCodeSupplier());
  289.         $ptLog->setCodeProducer($product->getCodeProducer());
  290.         $ptLog->setWarehouseFrom($warehouseFrom->__toString());
  291.         $ptLog->setWarehouseTo($warehouseTo->__toString());
  292.         $ptLog->setUserName($user->getProfile()->getName().' '.$user->getProfile()->getSurname());
  293.         $ptLog->setDownloadType($downloadType);
  294.         $ptLog->setDatetime($datetime);
  295.         $ptLog->setDdt(null);
  296.         $ptLog->setDdtPath(null);
  297.         $em->persist($ptLog);
  298.         $em->flush();
  299.     }
  301.     // SPOSTA PRODOTTO
  302.     static public function moveProductTransfer($em, $jtppt, $user, $status)
  303.     {        
  304.         $product = $jtppt->getProduct();
  305.         ProductService::createProductLog($em, $product, $user, 'status', $status->getValue(), null, $product->getStatus()->getId());
  306.         $product->setStatus($status);
  307.         $product->setActualWarehouse($jtppt->getTransfer()->getWarehouseTo());
  308.         $product->setDateLastTransfer(new \Datetime());
  309.         $jtppt->setTransferOk(true);
  310.         $em->flush();
  311.     }
  313.     static public function moveProductClient($em, $product, $warehouse)
  314.     {
  315.         $product->setActualWarehouse($warehouse);
  316.         $product->setDateLastTransfer(new \Datetime());
  317.         $em->flush();
  318.     }
  320.     // CREO LOG
  321.     static public function createProductLog($em, $product, $user, $type, $newValue, $intervention, $oldDataId)
  322.     {
  323.         $text = '<table class="table table_no_padding b_none m_b_none"><tr><th class="td_w_70p">Utente</th><td>'.$user.'</td></tr><tr><th>Prodotto</th><td>'.$product.'</td></tr>';
  324.         switch($type){
  325.             case 'status': 
  326.                 $oldStatus = $em->getRepository("App\Entity\Slave\ProductStatus")->findOneById($oldDataId);
  327.                 $text.= '<tr><th>Modifica a</th><td>Stato</td><tr><th>Da</th><td>'.$oldStatus->getValue().'</td></tr><tr><th>A</th><td>'.$newValue.'</td></th></tr>'; break;
  328.             case 'condition': 
  329.                 $oldCondition = $em->getRepository("App\Entity\Slave\ProductCondition")->findOneById($oldDataId);
  330.                 $text.= '<tr><th>Modifica a</th><td>Condizione</td><tr><th>Da</th><td>'.$oldCondition->getValue().'</td></tr><tr><th>A</th><td>'.$newValue.'</td></th></tr>'; break;
  331.             case 'code-producer': 
  332.                 $oldCode = $product->getCodeProducer();
  333.                 $text.= '<tr><th>Modifica a</th><td>Codice produttore</td><tr><th>Da</th><td>'.$oldCode.'</td></tr><tr><th>A</th><td>'.$newValue.'</td></th></tr>'; break;
  334.             case 'code-supplier': 
  335.                 $oldCode = $product->getCodeSupplier();
  336.                 $text.= '<tr><th>Modifica a</th><td>Codice fornitore</td><tr><th>Da</th><td>'.$oldCode.'</td></tr><tr><th>A</th><td>'.$newValue.'</td></th></tr>'; break;
  337.             default: break;
  338.         }
  339.         $text.='</table>';
  341.         $productLog = new ProductLog();
  342.         $productLog->setProduct($product);
  343.         $productLog->setDatetime(new \Datetime());
  344.         $productLog->setType($type);
  345.         $productLog->setText($text);
  346.         $productLog->setIntervention($intervention);
  347.         $productLog->setOldDataId($oldDataId);
  348.         $em->persist($productLog);
  349.         $em->flush();
  350.     }
  351.     
  352.     // CAMBIA CONDIZIONE E STATO DI CONSEGUENZA
  353.     static public function productChangeCondition($em, $user, $product, $newCondition)
  354.     {
  355.         $statusAvailable = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  356.         $statusNotAvailable = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available'));
  358.         ProductService::createProductLog($em, $product, $user, 'condition', $newCondition->getValue(), null, $product->getCondition()->getId());
  359.         $product->setCondition($newCondition);
  361.         // Se STATO non "In trasferimento" e non "In uso"
  362.         if($product->getStatus()->getSlug() != 'transfer' && $product->getStatus()->getSlug() != 'in_use'){
  364.             // Se CONDIZIONE NUOVA "Disponibile" (Nuovo / Ricondizionato / Riparato / Svincolato / Rigenerato) e STATO "Non disponibile"
  365.             if($newCondition->isStatusAvailable() && $product->getStatus()->getSlug() == "not_available"){
  366.                 ProductService::createProductLog($em, $product, $user, 'status', $statusAvailable->getValue(), null, $product->getStatus()->getId());
  367.                 $product->setStatus($statusAvailable);
  368.                 if($newCondition->getSlug() == 'regenerated')
  369.                     ProductService::createProductRegenerated($em, $user, $product);
  370.             }
  371.             // Se CONDIZIONE "Non disponibile" (Guasto / Ritirato / DOA / Smarrito / Storico) e STATO "Disponibile"
  372.             elseif(!$newCondition->isStatusAvailable() && $product->getStatus()->getSlug() == "available"){
  373.                 ProductService::createProductLog($em, $product, $user, 'status', $statusNotAvailable->getValue(), null, $product->getStatus()->getId());
  374.                 $product->setStatus($statusNotAvailable);
  375.             }
  376.         }
  378.         $em->flush();
  379.     }
  381.     // CREO PRODOTTO DA RIGENERARE
  382.     static public function createProductRegenerated($em, $user, $product)
  383.     {
  384.         $productRegenerated = new ProductRegenerated();
  385.         $productRegenerated->setProduct($product);
  386.         $productRegenerated->setDatetime(new \Datetime());
  387.         $em->persist($productRegenerated);
  389.         if(sizeof($product->getSuppliers()) == 1){
  390.             $productRegenerated->setSupplier($product->getSuppliers()[0]);
  391.         }
  392.         $em->flush();
  393.     }
  394. }