src/Flexy/ShopBundle/EventSubscriber/EasyAdminSubscriber.php line 43

  1. <?php 
  2. # src/EventSubscriber/EasyAdminSubscriber.php
  3. namespace App\Flexy\ShopBundle\EventSubscriber;
  5. use App\Entity\BlogPost;
  6. use App\Flexy\ShopBundle\Entity\Brand;
  7. use App\Flexy\ShopBundle\Entity\Order\DemandeFund;
  8. use App\Flexy\ShopBundle\Entity\Order\Order;
  9. use App\Flexy\ShopBundle\Entity\Product\CategoryProduct;
  10. use App\Flexy\ShopBundle\Entity\Product\ImportExcel;
  11. use App\Flexy\ShopBundle\Entity\Product\Product;
  12. use App\Flexy\ShopBundle\Entity\Product\ProductShop;
  13. use App\Flexy\ShopBundle\Entity\Resource\Agent;
  14. use App\Flexy\ShopBundle\Entity\Store\Store;
  15. use App\Flexy\ShopBundle\Entity\Vendor\Vendor;
  16. use EasyCorp\Bundle\EasyAdminBundle\Event\BeforeEntityPersistedEvent;
  17. use EasyCorp\Bundle\EasyAdminBundle\Event\BeforeEntityUpdatedEvent;
  18. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  19. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  20. use Symfony\Component\Security\Core\Security;
  21. use Doctrine\ORM\EntityManagerInterface;
  22. use EasyCorp\Bundle\EasyAdminBundle\Event\AfterCrudActionEvent;
  23. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  24. use PhpOffice\PhpSpreadsheet\Reader\Csv;
  25. use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
  27. class EasyAdminSubscriber implements EventSubscriberInterface
  28. {
  29.     public function __construct(private readonly Security $security, private readonly UserPasswordHasherInterface $passwordEncoder, private readonly EntityManagerInterface $em)
  30.     {
  31.     }
  33.     public static function getSubscribedEvents()
  34.     {
  35.         return [
  36.             BeforeEntityPersistedEvent::class => ['beforePersist'],
  37.             BeforeEntityUpdatedEvent::class => ['beforeUpdated'],
  38.             AfterCrudActionEvent::class => ['afterAction']
  39.         ];
  40.     }
  43.     public function afterAction(AfterCrudActionEvent $event){
  44.         
  45.         
  46.         
  47.             
  48.             if($event->getResponseParameters()->get("pageName") == "detail"){
  49.                 $entity = $event->getResponseParameters()->get("entity")->getInstance();
  50.                 
  51.                 if ($entity instanceof Order) {
  52.                     $entity->setIsChecked(true);
  53.                     $this->em->persist($entity);
  54.                     $this->em->flush();
  56.                 }
  57.             }
  58.     }
  60.     public function beforePersist(BeforeEntityPersistedEvent $event)
  61.     {
  62.         $entity = $event->getEntityInstance();
  64.         
  65.         if ($entity instanceof ImportExcel) {
  68.             
  70.            
  71.            $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
  72.         
  73.         
  74.             
  75.            $spreadsheet = $reader->load("uploads/".$entity->getFile());
  77.            
  78.            
  79.            $spreadsheetToArray = $spreadsheet->getActiveSheet()->toArray();
  80.            
  81.            $headers=$spreadsheetToArray[0];
  82.            $dataFiltred=[];
  83.            $allData=[];
  85.            foreach($spreadsheetToArray as $singleRow){
  86.             if($headers == $singleRow){
  87.                 continue;
  88.             }
  89.             foreach($headers as $key=>$value){
  90.                 if($value===null or $value===""){
  91.                     continue;
  92.                 }
  93.                 $dataFiltred[str_replace(" ","",(string) $value)]=$singleRow[$key];
  94.             }
  95.             $allData[]= $dataFiltred;
  96.         }
  98.         dd($allData);
  100.        
  102.        $vendor = $this->em->getRepository(Vendor::class)->findOneBy(["user"=>$this->security->getUser()]);
  103.        if($vendor){
  104.            $counterImported=0;
  105.            $counterIgnored = 0;
  106.         foreach($allData as $singleData){
  108.            
  109.             $product = new Product();
  110.             
  111.             //BySamir : ToModify
  112.             $product->setName((string)$singleData["NOM_PRODUIT"]);
  113.             $product->setSkuCode((string)$singleData["CODE_EAN"]);
  114.             $product->setName((string)$singleData["NOM_PRODUIT"]);
  117.             $cat1 =  $this->em->getRepository(CategoryProduct::class)->findOneBy(["name"=>$singleData["CAT1"]]);
  118.             $cat2 =  $this->em->getRepository(CategoryProduct::class)->findOneBy(["name"=>$singleData["CAT2"]]);
  119.             $cat3 =  $this->em->getRepository(CategoryProduct::class)->findOneBy(["name"=>$singleData["CAT3"]]);
  120.             $cat4 =  $this->em->getRepository(CategoryProduct::class)->findOneBy(["name"=>$singleData["CAT4"]]);
  121.             $cat5 =  $this->em->getRepository(CategoryProduct::class)->findOneBy(["name"=>$singleData["CAT5"]]);
  123.             $brand =  $this->em->getRepository(Brand::class)->findOneBy(["name"=>$singleData["MARQUE"]]);
  125.             if($cat1){
  126.                 $product->addCategoryProduct($cat1);
  127.             }
  128.             if($cat2){
  129.                 $product->addCategoryProduct($cat2);
  130.             }
  131.             if($cat3){
  132.                 $product->addCategoryProduct($cat3);
  133.             }
  134.             if($cat4){
  135.                 $product->addCategoryProduct($cat4);
  136.             }
  137.             if($cat5){
  138.                 $product->addCategoryProduct($cat5);
  139.             }
  140.             
  141.             if($brand){
  142.                 $product->setBrand($brand);
  143.             }else{
  144.                 $brand = new Brand();
  145.                 $brand->setName((string)$singleData["MARQUE"]);
  146.                 $product->setBrand($brand);
  147.             }
  148.             
  150.             $product->setPrice((float)$singleData["PRIX_VENTE"] * 100 );
  151.             $product->setOldPrice((float)$singleData["ANCIEN_PRIX"] * 100 );
  152.             $product->setQuantity((int)$singleData["STOCK"]);
  154.             if($singleData["IMAGE"]){
  156.                 $newImagePath = static::slugify($singleData["NOM_PRODUIT"]);
  157.                 copy($singleData["IMAGE"], "uploads/".$newImagePath);
  158.                 $product->setImage($newImagePath);
  159.             }
  160.             
  161.             $product->setShortDescription((string)$singleData["DESCRIPTION_COURTE"]);
  162.             $product->setDescription((string)$singleData["DESCRIPTION_COMPLETE"]);
  164.             $product->setVendor($vendor);
  165.             
  168.             $this->em->persist($product);
  169.             
  170.             $counterImported = $counterImported + 1;
  171.         }
  173.         
  175.         $entity->setTotalLinesImported($counterImported);
  176.         $entity->setTotalLinesIgnored($counterIgnored);
  177.        }
  178.      
  181.            
  182.            
  183.         }
  185.         if ($entity instanceof DemandeFund) {
  187.             foreach($entity->getOrders() as $singleOrder){
  188.                 $singleOrder->setDemandeFund($entity);
  189.                 $entity->addOrder($singleOrder);
  190.             }
  191.            
  192.         }
  194.         if ($entity instanceof Vendor) {
  197.             $entity->setSimulateUsername("");
  198.             $entity->getUser()->setRoles(["ROLE_VENDOR"]);
  199.             $entity->getUser()->setPassword(
  200.                 $this->passwordEncoder->hashPassword(
  201.                          $entity->getUser(),
  202.                          $entity->getUser()->getPassword()
  203.              ));
  204.              //dd($entity);
  205.         }
  208.         if ($entity instanceof Store) {
  209.             $entity->getUser()->setRoles(["ROLE_STORE"]);
  210.             $entity->getUser()->setPassword(
  211.                 $this->passwordEncoder->hashPassword(
  212.                          $entity->getUser(),
  213.                          $entity->getUser()->getPassword()
  214.              ));
  215.         }
  219.         if ($entity instanceof Agent) {
  222.             $entity->getUser()->setRoles(["ROLE_AGENT"]);
  223.             $entity->getUser()->setPassword(
  224.                 $this->passwordEncoder->hashPassword(
  225.                          $entity->getUser(),
  226.                          $entity->getUser()->getPassword()
  227.              ));
  228.              //dd($entity);
  229.         }
  230.         if ($entity instanceof Product ) {
  231.             $entity->setSkuCodeShop("OM".$entity->getCreatedAt()->format("ymdhs").$entity->getId());
  232.             $vendor = $this->em->getRepository(Vendor::class)->findOneBy(["user"=>$this->security->getUser()]);
  233.             
  234.             $entity->setVendor($vendor);
  235.            
  236.         }
  238.      
  239.     }
  242.     public function beforeUpdated(BeforeEntityUpdatedEvent $event)
  243.     {
  244.         $entity = $event->getEntityInstance();
  246.         
  248.         if ($entity instanceof Product) {
  249.             $imagePath = $entity->getImage();
  250.             $entity->setImage($imagePath);
  251.            
  252.         }
  254.         if ($entity instanceof DemandeFund) {
  256.             foreach($entity->getOrders() as $singleOrder){
  257.                 $singleOrder->setDemandeFund($entity);
  258.                 $entity->addOrder($singleOrder);
  259.             }
  260.            
  261.         }
  263.         if ($entity instanceof Vendor) {
  264.             //dd($entity->getUser()->getPassword());
  266.             /*$entity->getUser()->setRoles(["ROLE_VENDOR"]);
  267.             $entity->getUser()->setPassword(
  268.                 $this->passwordEncoder->encodePassword(
  269.                          $entity->getUser(),
  270.                          $entity->getUser()->getPassword()
  271.              ));*/
  272.         }
  274.         if ($entity instanceof Product ) {
  275.             $entity->setSkuCodeShop($entity->getSkuCodeShop().$entity->getId());
  276.             $vendor = $this->em->getRepository(Vendor::class)->findOneBy(["user"=>$this->security->getUser()]);
  277.             
  278.             
  279.            
  280.         }
  282.      
  283.     }
  286.     public static function slugify($text, string $divider = '-')
  287. {
  288.   // replace non letter or digits by divider
  289.   $text = preg_replace('~[^\pL\d]+~u', $divider, (string) $text);
  291.   // transliterate
  292.   $text = iconv('utf-8', 'us-ascii//TRANSLIT', $text);
  294.   // remove unwanted characters
  295.   $text = preg_replace('~[^\-\w]+~', '', $text);
  297.   // trim
  298.   $text = trim($text, $divider);
  300.   // remove duplicate divider
  301.   $text = preg_replace('~-+~', $divider, $text);
  303.   // lowercase
  304.   $text = strtolower($text);
  306.   if (empty($text)) {
  307.     return 'n-a';
  308.   }
  310.   return $text;
  311. }
  313. }