src/Service/ProductService.php line 200

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