local/modules/TracabilitePP/Hook/TracabiliteHook.php line 51

  1. <?php
  3. namespace TracabilitePP\Hook;
  5. use Propel\Runtime\ActiveQuery\Criteria;
  7. use Thelia\Core\Event\Hook\HookRenderBlockEvent;
  8. use Thelia\Core\Event\Hook\HookRenderEvent;
  9. use Thelia\Core\Event\Image\ImageEvent;
  10. use Thelia\Core\Event\TheliaEvents;
  12. use Thelia\Core\Hook\BaseHook;
  14. use Thelia\Tools\URL;
  15. use Thelia\log\Tlog;
  17. use Thelia\Model\ModuleImageQuery;
  18. use Thelia\Model\ConfigQuery;
  19. use Thelia\Model\OrderProductQuery;
  20. use Thelia\Model\Map\ProductTableMap;
  21. use Thelia\Model\Map\OrderProductTableMap;
  23. use TracabilitePP\TracabilitePP;
  24. use TracabilitePP\Model\TracabiliteQuery;
  25. use TracabilitePP\Model\Map\TracabiliteTableMap;
  28. /**
  29.  * Class TracabiliteHook
  30.  * @package TracabilitePP\Hook
  31.  * @author François Carfantan <francois.carfantan@kmel.bzh>
  32.  */
  33. class TracabiliteHook extends BaseHook
  34. {
  37.     public function onMainTopMenuTools(HookRenderBlockEvent $event)
  38.     {
  39.         $event->add(
  40.             [
  41.                 'id' => 'tools_menu_tracabilite',
  42.                 'class' => '',
  43.                 'url' =>  URL::getInstance()->absoluteUrl('/admin/module/TracabilitePP'),
  44.                 'title' => 'Tracabilite'
  45.             ]
  47.         );
  48.     }
  51.     public function OnDeliveryOrderProduct(HookRenderEvent $event)
  52.     {
  53.         $passName =  $this->translator->trans('Plant Passport', [], 'tracabilitepp.bo.default');
  54.         $orderProductId = $event->getArgument('order_product');
  55.         $hook_name = $event->getCode();
  56.     if($hook_name=="invoice.order-product"){
  57.         $nbcol = 6;
  58.     }
  59.     else{
  60.         $nbcol = 3;
  61.     }
  62.         $lotCode = $this->getLotCode($orderProductId);
  63.         $moduleId = $this->getModule()->getModuleId();
  64.         $imageUrl = $this->getImageUrl($moduleId);
  65.         $html="<tr class='table-2'>";
  66.             $html= $html."<td colspan='$nbcol'>";
  67.                 $html= $html."<table  style='border:none'>";
  68.                     $html= $html."<tr>";
  69.                         $html= $html."<td  style='border:none'>";
  70.                                  $html= $html."<img style='width:40px; padding:3px' src='$imageUrl'/>";
  71.                         $html= $html."</td>";
  72.                         $html= $html."<td style='border:none'>";
  73.                         $html= $html."<b>.$passName.</b>";
  74.                     $html= $html."</td></tr>";
  75.         $html= $html."<tr><td colspan='2'  style='border:none'>";
  76.         $html= $html.$this->getPassString($event->getArgument('order_product'), $lotCode);
  77.         $html= $html. "</td></tr></table></td></tr>";
  78.         $event->add($html);
  79.     }
  80.     public function OnOrderProductList(HookRenderEvent $event)
  81.     {
  82.         $orderProductId = $event->getArgument('order_product_id');
  83.         $title =  $this->translator->trans('Lot reference', [], 'tracabilitepp.bo.default');
  84.         $lotCode = $this->getLotCode($orderProductId);
  85.         $event->add('<dl class="dl-horizontal"><dt>' . $title . '</dt><dd>' . $lotCode . '</dd></dl>');
  86.     }
  87.     private function getImageUrl($moduleId)
  88.     {
  89.         $imageFileName = ModuleImageQuery::create()->findOneByModuleId($moduleId)->getFile();
  90.         $payboxDisplay = new Tracabilitepp();
  91.         $uploadDir = $payboxDisplay->getUploadDir();
  92.         $event = new ImageEvent();
  93.         $event->setSourceFilepath(DS . $uploadDir . DS . $imageFileName)
  94.             ->setCacheSubdirectory('tracabilitepp');
  95.         $this->dispatcher->dispatch($event,TheliaEvents::IMAGE_PROCESS);
  96.         return $event->getFileUrl();
  97.     }
  99.     private function getPassString($orderProductId, $lotCode)
  100.     {
  101.         $passStringArray = array();
  102.         $title = OrderProductQuery::create()->findPk($orderProductId)->getTitle();
  103.         $latinName  = (explode(",", $title))[0];
  104.         array_push($passStringArray, ' <b>A</b> ' . $latinName);
  105.         array_push($passStringArray, '<b>B</b> ' . ConfigQuery::read('passport_ref'));
  106.         array_push($passStringArray, '<b>C</b> ' . $lotCode);
  107.         array_push($passStringArray, '<b>D</b> ' . ConfigQuery::read('plant_origin'));
  108.         return implode(" ", $passStringArray);
  109.     }
  110.     function getLotCode($orderProductId)
  111.     {
  112.         $lot = TracabiliteQuery::create()
  113.             ->joinProduct()
  114.             ->addJoin(ProductTableMap::REF, OrderProductTableMap::PRODUCT_REF, Criteria::RIGHT_JOIN)
  115.             ->where(TracabiliteTableMap::START_DATE . '<=' . OrderProductTableMap::UPDATED_AT)
  116.             ->_and()
  117.             ->where(TracabiliteTableMap::END_DATE . '>=' . OrderProductTableMap::UPDATED_AT)
  118.             ->_or()
  119.             ->where(TracabiliteTableMap::END_DATE . ' IS NULL')
  120.             ->where(OrderProductTableMap::ID . ' = ?', intval($orderProductId))
  121.             ->select(TracabiliteTableMap::LOT_CODE)
  122.             ->findOne();
  123.         if ($lot == null) {
  124.             return "";
  125.         }
  126.         return $lot;
  127.     }
  128. }