src/Validator/ColumnValidator.php line 30

Open in your IDE?
  1. <?php
  3. /*
  4.  * Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
  5.  * Click nbfs://nbhost/SystemFileSystem/Templates/Scripting/PHPClass.php to edit this template
  6.  */
  8. namespace App\Validator;
  10. use App\Repository\DocumentUploadValueRepository;
  11. use PhpOffice\PhpSpreadsheet\IOFactory;
  12. use Symfony\Component\Form\FormEvent;
  13. use Symfony\Component\Form\FormError;
  14. use App\Entity\DocumentUpload;
  16. /**
  17.  * Description of ColumnValidator
  18.  *
  19.  * @author programmer
  20.  */
  21. class ColumnValidator extends AbstractExcelValidator 
  22. {   
  23.     private DocumentUploadValueRepository $documentUploadValueRepository;
  24.     
  25.     public function __construct(DocumentUploadValueRepository $documentUploadValueRepository) 
  26.     {
  27.         $this->documentUploadValueRepository = $documentUploadValueRepository;
  28.     }
  29.     
  30.     public function validate(FormEvent $evt): void 
  31.     {
  32.         $entity = $evt->getData();
  33.         if (!$entity instanceof DocumentUpload) {
  34.             return;
  35.         }
  36.         
  37.         $headers = $entity->getDocument()->getDocumentHeaders();
  38.         $excel = IOFactory::load($entity->getAttachment());
  39.         $sheet = $excel->getActiveSheet();
  40.         $typeValidate = function (string $type, $value, int $row):bool {
  41.             $validate = "is_" . $type;
  42.             if (false === call_user_func($validate, $value)) {
  43.                 throw new \Exception(
  44.                     sprintf("invalid type: %s, %s expected at row %s", $value, $type, $row)
  45.                 );
  46.             }
  47.             
  48.             return true;
  49.         };
  50.         
  51.         for ($i = $entity->getDocument()->getDataStartAt(); $i < $sheet->getHighestDataRow(); $i++) {
  52.             foreach ($headers as $header) {
  53.                 $cell = $header->getColumnName() . $i;
  54.                 $value = $sheet->getCell($cell)->getValue();
  55.                 
  56.                 if (null === $value) {
  57.                     continue;
  58.                 }
  59.                 try {
  60.                     $typeValidate($header->getTypeData(), $value, $i);
  61.                     $entity->addDocumentUploadValue(
  62.                         $this->documentUploadValueRepository->findOrCreate(
  63.                             $value, 
  64.                             $i,
  65.                             $header, 
  66.                             $entity
  67.                         )
  68.                     );
  69.                 } catch (\Exception $ex) {
  70.                     $evt->getForm()->get("attachment")
  71.                             ->addError(
  72.                                 new FormError($ex->getMessage())
  73.                             );
  74.                     return;
  75.                 }
  76.             }
  77.         }
  78.     }
  79. }