src/AppBundle/Controller/ProvaController.php line 27

Open in your IDE?
  1. <?php
  3. namespace AppBundle\Controller;
  5. use \Pimcore\Controller\FrontendController;
  6. use \Symfony\Component\HttpFoundation\Request;
  7. use \Pimcore\Model\DataObject;
  8. use \Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  10. /*
  11.     use \AppBundle\Form\LoginFormType;
  12.     use \AppBundle\Model\DataObject\User;
  13.     use \Pimcore\Controller\Configuration\TemplatePhp;
  14.     use \Symfony\Component\Routing\Annotation\Route;
  15.     use \Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  16.     use \Symfony\Component\HttpKernel\Exception\AccessDeniedHttpException;
  17.     use \Symfony\Component\Security\Http\Authentication\AuthenticationUtils;
  18.  */   
  20.     
  21. //use Symfony\Component\HttpFoundation\Response;
  22. //use Symfony\Component\Routing\Annotation\Route;
  24. //use \Pimcore\Bundle\AdminBundle\Controller\Rest\AbstractRestController;
  25. //use Pimcore\Model\Asset;
  27. class ProvaController extends FrontendController
  28. {
  29.     public function defaultAction(Request $request)
  30.     {
  31.     }
  32.     public function defaultpdfAction(Request $request)
  33.     {
  34.     }
  36.     public function devtestAction(Request $request)
  37.     {
  38.     }
  40.     public function imptestAction(Request $request)
  41.     {
  42.     }
  44.     public function sitocusAction(Request $request)
  45.     {
  46.     }
  48.     public function prodcuspdfAction(Request $request)
  49.     {
  50.     }
  52.     public function palportalAction(Request $request)
  53.     {
  54.     }    
  56.     public function prodcusAction(Request $request)
  57.     {
  58.         $this->view->req=$request->getLocale();
  59.         $this->denyAccessUnlessGranted('ROLE_USER');
  60.         //$this->denyAccessUnlessGranted('ROLE_ADMIN', null, 'User tried to access a page without having ROLE_ADMIN');
  62.     }
  64.     public function prodcleanAction(Request $request)
  65.     {
  66.     }
  68.     public function listcleanAction(Request $request)
  69.     {
  70.     }
  72.     public function listcleanpdfAction(Request $request)
  73.     {
  74.     }
  76.     public function listpagepdfAction(Request $request)
  77.     {
  78.     }
  80.     public function listpagenewpdfAction(Request $request)
  81.     {
  82.         //proprietà PROP se è pari a UL=unlimited tira fuori tutti i design che esistono!!
  83.         //usare con cautela
  84.         $PROP=$this->view->document->getProperty('PROP');
  85.         $mySelection=$this->view->document->getProperty('selezione') ?: "list_2020_it";
  86.         $elencoDesign = new \Pimcore\Model\DataObject\Design\Listing();
  87.         if ($PROP=='UL') {
  88.             $elencoDesign=$this->getAllDesignUL();
  89.         } else{
  90.             $id=$this->view->document->getProperty('cartella')->getId();
  91.             $elencoDesign=$this->getAllDesign($id);    
  92.         }
  93.         
  94.         if ($elencoDesign->count()<1) return;
  95.         $pagesToRender=array();
  96.         foreach ($elencoDesign as $design) {
  97.             $prodbaselist = new DataObject\Variante\Listing();
  98.             $prodbaselist->setObjectTypes([DataObject\AbstractObject::OBJECT_TYPE_OBJECT]);
  99.             $prodbaselist->setLimit(30);
  100.             $prodbaselist->setOrderKey("o_key");
  101.             $prodbaselist->setOrder("asc");
  102.             $prodbaselist->setCondition("o_parentId = '".$design->getId()."' and ".$mySelection."=1");
  103.             $prodbaselist->load();
  105.             if ($prodbaselist->count()>0) {
  106.                 
  107.                 //preparo array dei plus e degli optional
  108.                 $myPlusAll=array();
  109.                 $myAccAll=array();
  110.                 $currId=0;
  111.                 $tiretype='';
  112.                 foreach ($prodbaselist as $entry) {
  113.                     $currId = $entry->getId();
  114.                     $tiretype = $entry->getDatitec();
  115.                     $myPlusAll=array_merge($myPlusAll,$entry->getPlus());
  116.                     $myAccAll=array_merge($myAccAll,$entry->getAccessori());
  117.                 }
  118.                 $myPlusAll=array_unique($myPlusAll);
  119.                 $myAccAll=array_unique($myAccAll);
  121.                 //************************************* INIZIO COSTRUISCO LISTA FOCOLARI E KIT *************************************
  122.                 $compFocolari=array();
  123.                 $compFocolari2D=array();
  124.                 $compKit=array();
  125.                 foreach ($prodbaselist as $prodbase) {
  126.                     $composizioneP=$prodbase->getComposizione();
  127.                     
  128.                     //il prodotto base è virtuale (ci sono varianti)
  129.                     if ($prodbase->getVirtual()) {
  130.                         $idPB=$prodbase->getId();
  131.                         //listo le vrianti sotto il prodotto base corrente
  132.                         $prodbaseVarList = new DataObject\Variante\Listing();
  133.                         $prodbaseVarList->setObjectTypes([DataObject\AbstractObject::OBJECT_TYPE_VARIANT]);
  134.                         $prodbaseVarList->setLimit(10);
  135.                         $prodbaseVarList->setCondition("o_parentId = ".$idPB);
  136.                         $prodbaseVarList->load();
  139.                         if ($prodbaseVarList->count()>0) {
  140.                             foreach($prodbaseVarList as $final) {
  141.                                 $composizioneP = $final->getComposizione();
  142.                                 //ho la composizione della Variante "n"
  143.                                 foreach ($composizioneP as $key) {
  144.                                     $miocod = $key->getCodice();
  145.                                     $miodes = $key->getDescrizione();
  147.                                     //destino a lista Focolari o Kit in base al codice
  148.                                     if (substr($miocod,0,2)=='80') {
  149.                                         $compFocolari[]=$miocod;
  150.                                         $loc_matcol=$key->getDesc_bella();
  151.                                         if (!is_null($final->getMat_col())) $loc_matcol=$final->getMat_col()->getMat_Col();
  152.                                         $addendo=array("cod"=>$miocod,"pbase"=>$prodbase->getKey(),"matcol"=>$loc_matcol);
  153.                                         $compFocolari2D[]=$addendo;
  154.                                         //echo "aggiunto 1";
  155.                                     } else {
  156.                                         $compKit[]=$miocod;
  157.                                     }
  158.                                 }
  159.                             }
  160.                         }
  161.                     // il prodotto base non è virtuale
  162.                     } else {
  163.                         foreach ($composizioneP as $key) {
  164.                             $miocod = $key->getCodice();
  165.                             $miodes = $key->getDescrizione();
  167.                             //destino a lista Focolari o Kitin base al codice
  168.                             if (substr($miocod,0,2)=='80') {
  169.                                 $compFocolari[]=$miocod;
  170.                                 $loc_matcol=$key->getDesc_bella();
  171.                                 if (!is_null($final) and !is_null($final->getMat_col())) $loc_matcol=$final->getMat_col()->getMat_Col();
  172.                                 $addendo=array("cod"=>$miocod,"pbase"=>$prodbase->getKey(),"matcol"=>$loc_matcol);
  173.                                 $compFocolari2D[]=$addendo;
  174.                                 //echo "aggiunto 1";
  175.                             } else {
  176.                                 $compKit[]=$miocod;
  177.                             }
  178.                         }
  179.                     } //fine di if..else su is Virtual                              
  180.                 }
  181.                 $compFocolari=array_unique($compFocolari);
  182.                 
  183.                 // ----------------------------------------------
  185.                 $numfoc= count($compFocolari);
  186.                 $numpbase= count($prodbaselist);
  188.                 $raggruppa=1;
  189.                 if ($numfoc!=$numpbase) {
  190.                     //echo "raggruppa";
  191.                     //print_r($compFocolari2D);
  192.                 } else {
  193.                     //echo "non raggruppa";
  194.                     $raggruppa=0;
  195.                 }
  197.                 // ----------------------------------------------                        
  198.                 //sort($compFocolari);
  199.                 $compKit=array_unique($compKit);
  200.                 sort($compKit);
  201.                 //************************************* FINE COSTRUISCO LISTA FOCOLARI E KIT *************************************
  204.                 //************************ INIZIO TABELLA INFERIORE *************************
  205.                 $class_name = get_class($tiretype);
  206.                 $methods = get_class_methods($class_name);
  207.                 
  208.                 $focAperto=0;
  209.                 $focChiusoAria=0;
  210.                 $focChiusoIdro=0;
  211.                 $focPellAria=0;
  212.                 $focPellIdro=0;
  213.                 $stufAria=0;
  214.                 $stufIdro=0;
  215.                 $pellAria=0;
  216.                 $pellIdro=0;
  217.                 
  218.                 $data_tabella=0;
  219.                 $arrayTest=array();
  220.                 $arrayTestNew=array();
  221.                 $nomefunzione='';
  222.                 $pbase_idprod_prec=1;
  223.                 $campi=array();
  224.                 foreach($methods as $method)
  225.                 {
  226.                     $rigaDatiNewh=array();
  227.                     $rigaDatiNew=array();
  228.                     switch ($method) {
  229.                         case "getFocolarepelletaria":
  230.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  231.                                 $nomefunzione=$method;
  232.                                 $focPellAria=1; 
  234.                                 $campi=array("nome","incentivi","misure","pot_nom","rend_nom","auton","capacita_serb","consumi","u_fumi","c_nrg","certificazioni");                                       
  236.                                 //aggiungo un dato come filler
  237.                                 $arrayTestNew[]=$campi;                                        
  238.                             }
  239.                             break;
  240.                         case "getFocolarepelletidro":
  241.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  242.                                 $nomefunzione=$method;
  243.                                 $focPellIdro=1; 
  245.                                 $campi=array("nome","incentivi","misure","pot_nom","pot_acq","rend_nom","auton","capacita_serb","consumi","u_fumi","c_nrg","certificazioni");                                       
  247.                                 //aggiungo un dato come filler
  248.                                 $arrayTestNew[]=$campi;                                        
  249.                             }
  250.                             break;
  251.                         case "getStufapelletaria":
  252.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  253.                                 $nomefunzione=$method;
  254.                                 $pellAria=1; 
  256.                                 $campi=array("nome","incentivi","misure","pot_nom","rend_nom","auton","capacita_serb","consumi","u_fumi","c_nrg","certificazioni");                                       
  258.                                 //aggiungo un dato come filler
  259.                                 $arrayTestNew[]=$campi;   
  260.                                 //echo "Pellet aria<br />";                                     
  261.                             }
  262.                             break;
  263.                         case "getStufapelletidro":
  264.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  265.                                 $pellIdro=1;
  266.                                 $nomefunzione=$method;
  268.                                 $campi=array("nome","incentivi","misure","pot_nom","pot_acq","rend_nom","auton","capacita_serb","consumi","u_fumi","c_nrg","certificazioni");                                       
  270.                                 //aggiungo un dato come filler
  271.                                 $arrayTestNew[]=$campi;                                        
  272.                             }
  273.                             break;
  274.                         case "getFocolarelegnaaria":
  275.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  276.                                 $focChiusoAria=1;
  277.                                 $nomefunzione=$method;
  279.                                 $campi=array("nome","incentivi","misure","pot_bruc","pot_nom","rend_nom","carico_cons","u_fumi","c_nrg","certificazioni");                                       
  281.                                 //aggiungo un dato come filler
  282.                                 $arrayTestNew[]=$campi;                                        
  283.                             }
  284.                             break;
  285.                         case "getFocolarelegnaidro":
  286.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  287.                                 $focChiusoIdro=1;
  288.                                 $nomefunzione=$method;
  290.                                 $campi=array("nome","incentivi","misure","pot_bruc","pot_nom","pot_acq","rend_nom","carico_cons","u_fumi","c_nrg","certificazioni");                                       
  292.                                 //aggiungo un dato come filler
  293.                                 $arrayTestNew[]=$campi;                                        
  294.                             }
  295.                             break;
  296.                         case "getFocolareaperto":
  297.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  298.                                 $focAperto=1;
  299.                                 $nomefunzione=$method;
  301.                                 $campi=array("nome","incentivi","misure","pot_nom","u_fumi","c_nrg","certificazioni");                                       
  303.                                 //aggiungo un dato come filler
  304.                                 $arrayTestNew[]=$campi;                                        
  305.                             }
  306.                             break;
  307.                         case "getStufalegnaaria":
  308.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  309.                                 $stufAria=1;
  310.                                 $nomefunzione=$method;
  312.                                 $campi=array("nome","incentivi","misure","pot_bruc","pot_nom","rend_nom","carico_cons","u_fumi","c_nrg","certificazioni");                                       
  314.                                 //aggiungo un dato come filler
  315.                                 $arrayTestNew[]=$campi;                                        
  316.                             }
  317.                             break;
  318.                         case "getStufalegnaidro":
  319.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  320.                                 $stufIdro=1;
  321.                                 $nomefunzione=$method;
  323.                                 $campi=array("nome","incentivi","misure","pot_bruc","pot_nom","pot_acq","rend_nom","carico_cons","u_fumi","c_nrg","certificazioni");                                       
  325.                                 //aggiungo un dato come filler
  326.                                 $arrayTestNew[]=$campi;                                        
  327.                             }
  328.                             break;
  329.                         default :
  330.                             //echo "Prodotti senza dati tecnici";
  331.                             //return;
  332.                             break;
  333.                     }
  334.                 }
  335.                 if (strlen($nomefunzione)<5) {
  336.                     //echo "Prodotto senza dati tecnici";
  337.                     //return;
  338.                 } else {
  339.                     //echo $nomefunzione."<br/>";
  340.                     //print_r($arrayTestNew);
  341.                     foreach ($prodbaselist as $prodbase) {
  342.                         $campoTest= $prodbase->getId_prod() ?: $prodbase->getId();
  343.                         // echo $campoTest;
  344.                         if ($campoTest == $pbase_idprod_prec or is_null($prodbase->getDatitec()) or is_null(call_user_func(array($prodbase->getDatitec(),$nomefunzione)))) {
  345.                             //id_prodotto uguale a quello di prima, non faccio nulla
  346.                             //non c'è il brick, non faccio nulla
  347.                             //echo "Non c'è".$nomefunzione."<br/>";
  348.                         } else {
  350.                             //recupero il dato del brick
  351.                             $datoRiga=call_user_func(array($prodbase->getDatitec(),$nomefunzione)); 
  352.                             foreach ($campi as $campo) {
  353.                                 $dato='';
  354.                                 $datoh='';
  355.                                 //echo "CAMPO:".$campo."<br/>";
  356.                                 switch ($campo) {
  357.                                     case 'nome':
  358.                                         $datoh=$this->get("translator")->trans("list_dati_nome");
  359.                                         $dato=$prodbase->getKey();
  360.                                         break;
  361.                                     case 'misure':
  362.                                         $datoh=$this->get("translator")->trans("list_dati_misure");
  363.                                         if (!is_null($prodbase->getDatitec()->getMisure())) {
  364.                                             $dato=explode(" ",$prodbase->getDatitec()->getMisure()->getLar())[0]."x".explode(" ",$prodbase->getDatitec()->getMisure()->getProf())[0]."x".$prodbase->getDatitec()->getMisure()->getAlt();
  365.                                             if (!is_null($prodbase->getDatitec()->getMisure()->getPeso())) $dato=$dato."<br/>".$prodbase->getDatitec()->getMisure()->getPeso();
  366.                                             if (substr($dato,0,1)=='0') $dato="";
  367.                                         }
  368.                                         break;
  369.                                     case 'combustibile':
  370.                                         $datoh=$this->get("translator")->trans("list_dati_combustibile");
  371.                                         $dato=(string)$datoRiga->getCombustibile();
  372.                                         break;
  373.                                     case 'pot_nom':
  374.                                         $datoh=$this->get("translator")->trans("list_dati_pot_nom");
  375.                                         $dato=(string)$datoRiga->getPot_nom();
  376.                                         break;
  377.                                     case 'pot_acq':
  378.                                         $datoh=$this->get("translator")->trans("list_dati_pot_acq");
  379.                                         $dato=(string)$datoRiga->getPot_acq();
  380.                                         break;
  381.                                     case 'pot_bruc':
  382.                                         $datoh=$this->get("translator")->trans("list_dati_pot_bruc");
  383.                                         $dato=(string)$datoRiga->getPot_bruc();
  384.                                         break;
  385.                                     case 'rend_nom':
  386.                                         $datoh=$this->get("translator")->trans("list_dati_rend_nom");
  387.                                         $dato=(string)$datoRiga->getRend_nom();
  388.                                         break;
  389.                                     case 'auton':
  390.                                         $datoh=$this->get("translator")->trans("list_dati_auton");
  391.                                         $dato=(string)$datoRiga->getAuton();
  392.                                         break;
  393.                                     case 'capacita_serb':
  394.                                         $datoh=$this->get("translator")->trans("list_dati_capacita_serb");
  395.                                         $dato=(string)$datoRiga->getCapacita_serb();
  396.                                         break;
  397.                                     case 'consumi':
  398.                                         $datoh=$this->get("translator")->trans("list_dati_consumi");
  399.                                         $dato=explode(" ",$datoRiga->getConsumo_min())[0]." - ".$datoRiga->getConsumo_max();
  400.                                         break;
  401.                                     case 'carico_cons':
  402.                                         $datoh=$this->get("translator")->trans("list_dati_carico_cons");
  403.                                         $dato=(string)$datoRiga->getCarico_cons();
  404.                                         break;
  405.                                     case 'u_fumi':
  406.                                         $datoh=$this->get("translator")->trans("list_dati_u_fumi");
  407.                                         $dato=(string)$datoRiga->getU_fumi();
  408.                                         break;
  409.                                     case 'c_nrg':
  410.                                         $datoh=$this->get("translator")->trans("list_dati_c_nrg");
  411.                                         $dato=$datoRiga->getClasse_nrg();
  412.                                         break;
  413.                                     case 'certificazioni':
  414.                                         $datoh=$this->get("translator")->trans("list_dati_certificazioni");
  415.                                         $allinc=$prodbase->getCertificazioni();
  416.                                         if (!is_null($allinc)) {
  417.                                             $content="";
  418.                                             foreach ($allinc as $key3) {
  419.                                                 $miopic = $key3->getImg_cert();
  420.                                                 if (!is_null($miopic) && $miopic instanceof \Pimcore\Model\Asset\Image) {
  421.                                                     $dato=$dato.$miopic->getThumbnail("listmini")->getHtml(); 
  422.                                                 }
  423.                                             }
  424.                                         }
  425.                                         break;
  426.                                     case 'incentivi':
  427.                                         $datoh=$this->get("translator")->trans("list_dati_incentivi");
  428.                                         $allinc=$prodbase->getIncentivi();
  429.                                         if (!is_null($allinc)) {
  430.                                             foreach ($allinc as $key2) {
  431.                                                 $miopic = $key2->getImg_inc();
  432.                                                 if (!is_null($miopic) && $miopic instanceof \Pimcore\Model\Asset\Image) {
  433.                                                     $dato=$dato.$miopic->getThumbnail("listmini")->getHtml();
  434.                                                 }
  435.                                             }
  436.                                         }
  437.                                         break;
  438.                                     default:
  439.                                         # code...
  440.                                         break;
  441.                                 }
  442.                                 $rigaDatiNewh[$campo]=$datoh;
  443.                                 $rigaDatiNew[$campo]=$dato;
  444.                             }                           
  445.                             $arrayTestNew[]=$rigaDatiNew;
  447.                             $pbase_idprod_prec=$prodbase->getId_prod() ?: $prodbase->getId();
  448.                         } //if uguale al precedente o mancano dati
  449.                     } //foreach sui prodotti base
  450.                 } //if di nomefunzione
  451.                 
  452.                 $myArrayNew=$arrayTestNew;
  453.                 $myArrayh=$rigaDatiNewh;
  455.                 //************************ FINE TABELLA INFERIORE ***************************
  460.                 //aggiunge il design e i prodotti all'array da renderizzare
  461.                 $pagesToRender[]=array("design"=>$design,"prodottibase"=>$prodbaselist,"focolari"=>$compFocolari,"focolari2D"=>$compFocolari2D,"kit"=>$compKit,"raggruppa"=>$raggruppa,"optional"=>$myAccAll,"plus"=>$myPlusAll,"datih"=>$rigaDatiNewh,"dati"=>$arrayTestNew);
  462.             } else {
  463.             }
  464.         } //foreach design
  465.         $this->view->pages = $pagesToRender;
  466.     }
  468.     public function listinonewAction(Request $request)
  469.     {
  470.         //proprietà PROP se è pari a UL=unlimited tira fuori tutti i design che esistono!!
  471.         //usare con cautela
  472.         $PROP=$this->view->document->getProperty('PROP');
  473.         $mySelection=$this->view->document->getProperty('selezione') ?: "list_2020_it";
  474.         $elencoDesign = new \Pimcore\Model\DataObject\Design\Listing();
  475.         if ($PROP=='UL') {
  476.             $elencoDesign=$this->getAllDesignUL();
  477.         } else{
  478.             $id=$this->view->document->getProperty('cartella')->getId();
  479.             $elencoDesign=$this->getAllDesign($id);    
  480.         }
  481.         
  482.         if ($elencoDesign->count()<1) return;
  483.         $pagesToRender=array();
  484.         foreach ($elencoDesign as $design) {
  485.             $prodbaselist = new DataObject\Variante\Listing();
  486.             $prodbaselist->setObjectTypes([DataObject\AbstractObject::OBJECT_TYPE_OBJECT]);
  487.             $prodbaselist->setLimit(30);
  488.             $prodbaselist->setOrderKey("o_key");
  489.             $prodbaselist->setOrder("asc");
  490.             $prodbaselist->setCondition("o_parentId = '".$design->getId()."' and ".$mySelection."=1");
  491.             $prodbaselist->load();
  493.             if ($prodbaselist->count()>0) {
  494.                 
  495.                 //preparo array dei plus e degli optional
  496.                 $myPlusAll=array();
  497.                 $myAccAll=array();
  498.                 $currId=0;
  499.                 $tiretype='';
  500.                 foreach ($prodbaselist as $entry) {
  501.                     $currId = $entry->getId();
  502.                     $tiretype = $entry->getDatitec();
  503.                     $myPlusAll=array_merge($myPlusAll,$entry->getPlus());
  504.                     $myAccAll=array_merge($myAccAll,$entry->getAccessori());
  505.                 }
  506.                 $myPlusAll=array_unique($myPlusAll);
  507.                 $myAccAll=array_unique($myAccAll);
  509.                 //************************************* INIZIO COSTRUISCO LISTA FOCOLARI E KIT *************************************
  510.                 $compFocolari=array();
  511.                 $compFocolari2D=array();
  512.                 $compKit=array();
  513.                 foreach ($prodbaselist as $prodbase) {
  514.                     $composizioneP=$prodbase->getComposizione();
  515.                     
  516.                     //il prodotto base è virtuale (ci sono varianti)
  517.                     if ($prodbase->getVirtual()) {
  518.                         $idPB=$prodbase->getId();
  519.                         //listo le vrianti sotto il prodotto base corrente
  520.                         $prodbaseVarList = new DataObject\Variante\Listing();
  521.                         $prodbaseVarList->setObjectTypes([DataObject\AbstractObject::OBJECT_TYPE_VARIANT]);
  522.                         $prodbaseVarList->setLimit(10);
  523.                         $prodbaseVarList->setCondition("o_parentId = ".$idPB);
  524.                         $prodbaseVarList->load();
  527.                         if ($prodbaseVarList->count()>0) {
  528.                             foreach($prodbaseVarList as $final) {
  529.                                 $composizioneP = $final->getComposizione();
  530.                                 //ho la composizione della Variante "n"
  531.                                 foreach ($composizioneP as $key) {
  532.                                     $miocod = $key->getCodice();
  533.                                     $miodes = $key->getDescrizione();
  535.                                     //destino a lista Focolari o Kit in base al codice
  536.                                     if (substr($miocod,0,2)=='80') {
  537.                                         $compFocolari[]=$miocod;
  538.                                         $loc_matcol=$key->getDesc_bella();
  539.                                         if (!is_null($final->getMat_col())) $loc_matcol=$final->getMat_col()->getMat_Col();
  540.                                         $addendo=array("cod"=>$miocod,"pbase"=>$prodbase->getKey(),"matcol"=>$loc_matcol);
  541.                                         $compFocolari2D[]=$addendo;
  542.                                         //echo "aggiunto 1";
  543.                                     } else {
  544.                                         $compKit[]=$miocod;
  545.                                     }
  546.                                 }
  547.                             }
  548.                         }
  549.                     // il prodotto base non è virtuale
  550.                     } else {
  551.                         foreach ($composizioneP as $key) {
  552.                             $miocod = $key->getCodice();
  553.                             $miodes = $key->getDescrizione();
  555.                             //destino a lista Focolari o Kitin base al codice
  556.                             if (substr($miocod,0,2)=='80') {
  557.                                 $compFocolari[]=$miocod;
  558.                                 $loc_matcol=$key->getDesc_bella();
  559.                                 if (!is_null($final) and !is_null($final->getMat_col())) $loc_matcol=$final->getMat_col()->getMat_Col();
  560.                                 $addendo=array("cod"=>$miocod,"pbase"=>$prodbase->getKey(),"matcol"=>$loc_matcol);
  561.                                 $compFocolari2D[]=$addendo;
  562.                                 //echo "aggiunto 1";
  563.                             } else {
  564.                                 $compKit[]=$miocod;
  565.                             }
  566.                         }
  567.                     } //fine di if..else su is Virtual                              
  568.                 }
  569.                 $compFocolari=array_unique($compFocolari);
  570.                 
  571.                 // ----------------------------------------------
  573.                 $numfoc= count($compFocolari);
  574.                 $numpbase= count($prodbaselist);
  576.                 $raggruppa=1;
  577.                 if ($numfoc!=$numpbase) {
  578.                     //echo "raggruppa";
  579.                     //print_r($compFocolari2D);
  580.                 } else {
  581.                     //echo "non raggruppa";
  582.                     $raggruppa=0;
  583.                 }
  585.                 // ----------------------------------------------                        
  586.                 //sort($compFocolari);
  587.                 $compKit=array_unique($compKit);
  588.                 sort($compKit);
  589.                 //************************************* FINE COSTRUISCO LISTA FOCOLARI E KIT *************************************
  592.                 //************************ INIZIO TABELLA INFERIORE *************************
  593.                 $class_name = get_class($tiretype);
  594.                 $methods = get_class_methods($class_name);
  595.                 
  596.                 $focAperto=0;
  597.                 $focChiusoAria=0;
  598.                 $focChiusoIdro=0;
  599.                 $focPellAria=0;
  600.                 $focPellIdro=0;
  601.                 $stufAria=0;
  602.                 $stufIdro=0;
  603.                 $pellAria=0;
  604.                 $pellIdro=0;
  605.                 
  606.                 $data_tabella=0;
  607.                 $arrayTest=array();
  608.                 $arrayTestNew=array();
  609.                 $nomefunzione='';
  610.                 $pbase_idprod_prec=1;
  611.                 $campi=array();
  612.                 foreach($methods as $method)
  613.                 {
  614.                     $rigaDatiNewh=array();
  615.                     $rigaDatiNew=array();
  616.                     switch ($method) {
  617.                         case "getFocolarepelletaria":
  618.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  619.                                 $nomefunzione=$method;
  620.                                 $focPellAria=1; 
  622.                                 $campi=array("nome","incentivi","misure","pot_nom","rend_nom","auton","capacita_serb","consumi","u_fumi","c_nrg","certificazioni");                                       
  624.                                 //aggiungo un dato come filler
  625.                                 $arrayTestNew[]=$campi;                                        
  626.                             }
  627.                             break;
  628.                         case "getFocolarepelletidro":
  629.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  630.                                 $nomefunzione=$method;
  631.                                 $focPellIdro=1; 
  633.                                 $campi=array("nome","incentivi","misure","pot_nom","pot_acq","rend_nom","auton","capacita_serb","consumi","u_fumi","c_nrg","certificazioni");                                       
  635.                                 //aggiungo un dato come filler
  636.                                 $arrayTestNew[]=$campi;                                        
  637.                             }
  638.                             break;
  639.                         case "getStufapelletaria":
  640.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  641.                                 $nomefunzione=$method;
  642.                                 $pellAria=1; 
  644.                                 $campi=array("nome","incentivi","misure","pot_nom","rend_nom","auton","capacita_serb","consumi","u_fumi","c_nrg","certificazioni");                                       
  646.                                 //aggiungo un dato come filler
  647.                                 $arrayTestNew[]=$campi;   
  648.                                 //echo "Pellet aria<br />";                                     
  649.                             }
  650.                             break;
  651.                         case "getStufapelletidro":
  652.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  653.                                 $pellIdro=1;
  654.                                 $nomefunzione=$method;
  656.                                 $campi=array("nome","incentivi","misure","pot_nom","pot_acq","rend_nom","auton","capacita_serb","consumi","u_fumi","c_nrg","certificazioni");                                       
  658.                                 //aggiungo un dato come filler
  659.                                 $arrayTestNew[]=$campi;                                        
  660.                             }
  661.                             break;
  662.                         case "getFocolarelegnaaria":
  663.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  664.                                 $focChiusoAria=1;
  665.                                 $nomefunzione=$method;
  667.                                 $campi=array("nome","incentivi","misure","pot_bruc","pot_nom","rend_nom","carico_cons","u_fumi","c_nrg","certificazioni");                                       
  669.                                 //aggiungo un dato come filler
  670.                                 $arrayTestNew[]=$campi;                                        
  671.                             }
  672.                             break;
  673.                         case "getFocolarelegnaidro":
  674.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  675.                                 $focChiusoIdro=1;
  676.                                 $nomefunzione=$method;
  678.                                 $campi=array("nome","incentivi","misure","pot_bruc","pot_nom","pot_acq","rend_nom","carico_cons","u_fumi","c_nrg","certificazioni");                                       
  680.                                 //aggiungo un dato come filler
  681.                                 $arrayTestNew[]=$campi;                                        
  682.                             }
  683.                             break;
  684.                         case "getFocolareaperto":
  685.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  686.                                 $focAperto=1;
  687.                                 $nomefunzione=$method;
  689.                                 $campi=array("nome","incentivi","misure","pot_nom","u_fumi","c_nrg","certificazioni");                                       
  691.                                 //aggiungo un dato come filler
  692.                                 $arrayTestNew[]=$campi;                                        
  693.                             }
  694.                             break;
  695.                         case "getStufalegnaaria":
  696.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  697.                                 $stufAria=1;
  698.                                 $nomefunzione=$method;
  700.                                 $campi=array("nome","incentivi","misure","pot_bruc","pot_nom","rend_nom","carico_cons","u_fumi","c_nrg","certificazioni");                                       
  702.                                 //aggiungo un dato come filler
  703.                                 $arrayTestNew[]=$campi;                                        
  704.                             }
  705.                             break;
  706.                         case "getStufalegnaidro":
  707.                             if (!is_null(call_user_func(array($tiretype,$method))) && strlen(call_user_func(array($tiretype,$method))->getCombustibile())>0) {
  708.                                 $stufIdro=1;
  709.                                 $nomefunzione=$method;
  711.                                 $campi=array("nome","incentivi","misure","pot_bruc","pot_nom","pot_acq","rend_nom","carico_cons","u_fumi","c_nrg","certificazioni");                                       
  713.                                 //aggiungo un dato come filler
  714.                                 $arrayTestNew[]=$campi;                                        
  715.                             }
  716.                             break;
  717.                         default :
  718.                             //echo "Prodotti senza dati tecnici";
  719.                             //return;
  720.                             break;
  721.                     }
  722.                 }
  723.                 if (strlen($nomefunzione)<5) {
  724.                     //echo "Prodotto senza dati tecnici";
  725.                     //return;
  726.                 } else {
  727.                     //echo $nomefunzione."<br/>";
  728.                     //print_r($arrayTestNew);
  729.                     foreach ($prodbaselist as $prodbase) {
  730.                         $campoTest= $prodbase->getId_prod() ?: $prodbase->getId();
  731.                         // echo $campoTest;
  732.                         if ($campoTest == $pbase_idprod_prec or is_null($prodbase->getDatitec()) or is_null(call_user_func(array($prodbase->getDatitec(),$nomefunzione)))) {
  733.                             //id_prodotto uguale a quello di prima, non faccio nulla
  734.                             //non c'è il brick, non faccio nulla
  735.                             //echo "Non c'è".$nomefunzione."<br/>";
  736.                         } else {
  738.                             //recupero il dato del brick
  739.                             $datoRiga=call_user_func(array($prodbase->getDatitec(),$nomefunzione)); 
  740.                             foreach ($campi as $campo) {
  741.                                 $dato='';
  742.                                 $datoh='';
  743.                                 //echo "CAMPO:".$campo."<br/>";
  744.                                 switch ($campo) {
  745.                                     case 'nome':
  746.                                         $datoh=$this->get("translator")->trans("list_dati_nome");
  747.                                         $dato=$prodbase->getKey();
  748.                                         break;
  749.                                     case 'misure':
  750.                                         $datoh=$this->get("translator")->trans("list_dati_misure");
  751.                                         if (!is_null($prodbase->getDatitec()->getMisure())) {
  752.                                             $dato=explode(" ",$prodbase->getDatitec()->getMisure()->getLar())[0]."x".explode(" ",$prodbase->getDatitec()->getMisure()->getProf())[0]."x".$prodbase->getDatitec()->getMisure()->getAlt();
  753.                                             if (!is_null($prodbase->getDatitec()->getMisure()->getPeso())) $dato=$dato."<br/>".$prodbase->getDatitec()->getMisure()->getPeso();
  754.                                             if (substr($dato,0,1)=='0') $dato="";
  755.                                         }
  756.                                         break;
  757.                                     case 'combustibile':
  758.                                         $datoh=$this->get("translator")->trans("list_dati_combustibile");
  759.                                         $dato=(string)$datoRiga->getCombustibile();
  760.                                         break;
  761.                                     case 'pot_nom':
  762.                                         $datoh=$this->get("translator")->trans("list_dati_pot_nom");
  763.                                         $dato=(string)$datoRiga->getPot_nom();
  764.                                         break;
  765.                                     case 'pot_acq':
  766.                                         $datoh=$this->get("translator")->trans("list_dati_pot_acq");
  767.                                         $dato=(string)$datoRiga->getPot_acq();
  768.                                         break;
  769.                                     case 'pot_bruc':
  770.                                         $datoh=$this->get("translator")->trans("list_dati_pot_bruc");
  771.                                         $dato=(string)$datoRiga->getPot_bruc();
  772.                                         break;
  773.                                     case 'rend_nom':
  774.                                         $datoh=$this->get("translator")->trans("list_dati_rend_nom");
  775.                                         $dato=(string)$datoRiga->getRend_nom();
  776.                                         break;
  777.                                     case 'auton':
  778.                                         $datoh=$this->get("translator")->trans("list_dati_auton");
  779.                                         $dato=(string)$datoRiga->getAuton();
  780.                                         break;
  781.                                     case 'capacita_serb':
  782.                                         $datoh=$this->get("translator")->trans("list_dati_capacita_serb");
  783.                                         $dato=(string)$datoRiga->getCapacita_serb();
  784.                                         break;
  785.                                     case 'consumi':
  786.                                         $datoh=$this->get("translator")->trans("list_dati_consumi");
  787.                                         $dato=explode(" ",$datoRiga->getConsumo_min())[0]." - ".$datoRiga->getConsumo_max();
  788.                                         break;
  789.                                     case 'carico_cons':
  790.                                         $datoh=$this->get("translator")->trans("list_dati_carico_cons");
  791.                                         $dato=(string)$datoRiga->getCarico_cons();
  792.                                         break;
  793.                                     case 'u_fumi':
  794.                                         $datoh=$this->get("translator")->trans("list_dati_u_fumi");
  795.                                         $dato=(string)$datoRiga->getU_fumi();
  796.                                         break;
  797.                                     case 'c_nrg':
  798.                                         $datoh=$this->get("translator")->trans("list_dati_c_nrg");
  799.                                         $dato=$datoRiga->getClasse_nrg();
  800.                                         break;
  801.                                     case 'certificazioni':
  802.                                         $datoh=$this->get("translator")->trans("list_dati_certificazioni");
  803.                                         $allinc=$prodbase->getCertificazioni();
  804.                                         if (!is_null($allinc)) {
  805.                                             $content="";
  806.                                             foreach ($allinc as $key3) {
  807.                                                 $miopic = $key3->getImg_cert();
  808.                                                 if (!is_null($miopic) && $miopic instanceof \Pimcore\Model\Asset\Image) {
  809.                                                     $dato=$dato.$miopic->getThumbnail("listmini")->getHtml(); 
  810.                                                 }
  811.                                             }
  812.                                         }
  813.                                         break;
  814.                                     case 'incentivi':
  815.                                         $datoh=$this->get("translator")->trans("list_dati_incentivi");
  816.                                         $allinc=$prodbase->getIncentivi();
  817.                                         if (!is_null($allinc)) {
  818.                                             foreach ($allinc as $key2) {
  819.                                                 $miopic = $key2->getImg_inc();
  820.                                                 if (!is_null($miopic) && $miopic instanceof \Pimcore\Model\Asset\Image) {
  821.                                                     $dato=$dato.$miopic->getThumbnail("listmini")->getHtml();
  822.                                                 }
  823.                                             }
  824.                                         }
  825.                                         break;
  826.                                     default:
  827.                                         # code...
  828.                                         break;
  829.                                 }
  830.                                 $rigaDatiNewh[$campo]=$datoh;
  831.                                 $rigaDatiNew[$campo]=$dato;
  832.                             }                           
  833.                             $arrayTestNew[]=$rigaDatiNew;
  835.                             $pbase_idprod_prec=$prodbase->getId_prod() ?: $prodbase->getId();
  836.                         } //if uguale al precedente o mancano dati
  837.                     } //foreach sui prodotti base
  838.                 } //if di nomefunzione
  839.                 
  840.                 $myArrayNew=$arrayTestNew;
  841.                 $myArrayh=$rigaDatiNewh;
  843.                 //************************ FINE TABELLA INFERIORE ***************************
  848.                 //aggiunge il design e i prodotti all'array da renderizzare
  849.                 $pagesToRender[]=array("design"=>$design,"prodottibase"=>$prodbaselist,"focolari"=>$compFocolari,"focolari2D"=>$compFocolari2D,"kit"=>$compKit,"raggruppa"=>$raggruppa,"optional"=>$myAccAll,"plus"=>$myPlusAll,"datih"=>$rigaDatiNewh,"dati"=>$arrayTestNew);
  850.             } else {
  851.             }
  852.         } //foreach design
  853.         $this->view->pages = $pagesToRender;
  854.     }
  856.     public function listpagepalexpdfAction(Request $request)
  857.     {
  858.     }
  860.     public function listcleanmultiAction(Request $request)
  861.     {
  862.     }
  864.     public function deslistAction(Request $request)
  865.     {
  866.     }
  868.     public function assegnaAction(Request $request)
  869.     {
  870.     }
  872.     public function addplusAction(Request $request)
  873.     {
  874.     }
  876.     public function addcertAction(Request $request)
  877.     {
  878.     }
  880.     public function addincAction(Request $request)
  881.     {
  882.     }
  884.     public function addaccAction(Request $request)
  885.     {
  886.     }
  888.     public function addcompAction(Request $request)
  889.     {
  890.     }
  892.     //*********************  FUNZIONI COMODE PER ESTRAZIONE DATI  ********************************************
  893.     public function getAllDesign($myIDParent) {
  894.         //estrae tutti i design dal folder e poi disegna la pagina:
  895.         $entriesD = new \Pimcore\Model\DataObject\Design\Listing();
  896.         $entriesD->setObjectTypes([\Pimcore\Model\DataObject\AbstractObject::OBJECT_TYPE_OBJECT]);
  897.         $entriesD->setLimit(300);
  898.         $entriesD->setOrderKey("ordinamento");
  899.         $entriesD->setOrder("asc");
  900.         $entriesD->setCondition("o_parentId = '".$myIDParent."'");
  901.         $entriesD->load();
  902.         return $entriesD;
  903.     }
  905.     public function getAllDesignUL() {
  906.         //estrae tutti i design dal folder e poi disegna la pagina:
  907.         $entriesD = new \Pimcore\Model\DataObject\Design\Listing();
  908.         $entriesD->setObjectTypes([\Pimcore\Model\DataObject\AbstractObject::OBJECT_TYPE_OBJECT]);
  909.         $entriesD->setLimit(3000);
  910.         $entriesD->setOrderKey("o_path");
  911.         $entriesD->setOrder("asc");
  912.         $entriesD->load();
  913.         return $entriesD;
  914.     }
  916.     public function getPrezzo($mycode,$listino) {
  917.         if(!is_null($mycode->getPrz()) and !is_null($mycode->getPrz()->getPrezzi()) ) { //and !is_null($mycode->getPrz()->getPrezzi()->getLis_it_curr())) {
  918.             //echo $mycode.PHP_EOL;
  919.             $myclass=get_class($mycode);
  920.             return explode(" ",call_user_func(array($mycode->getPrz()->getPrezzi(),$listino)))[0];
  921.             //return explode(" ",$mycode->getPrz()->getPrezzi()->getLis_it_curr())[0];
  922.         }
  923.         return '';
  924.     }
  926.     public function getCosto($mycode,$listino) {
  927.         if(!is_null($mycode->getPrz()) and !is_null($mycode->getPrz()->getPrezzi())) {
  928.             //echo $mycode.PHP_EOL;
  929.             $myclass=get_class($mycode);
  930.             return explode(" ",call_user_func(array($mycode->getPrz()->getPrezzi(),"getCost_standard_curr")))[0];
  931.             //return explode(" ",$mycode->getPrz()->getPrezzi()->getLis_it_curr())[0];
  932.         }
  933.         return '';
  934.     }
  936.     public function getPrezzoCodice($mycodestring,$listino) {
  937.         $mycode = \Pimcore\Model\DataObject\Codice::getByCodice($mycodestring,1);
  938.         return \AppBundle\Controller\ProvaController::getPrezzo($mycode,$listino);
  939.     }
  941.     public function getDati($mycode,$listinoO,$listinoN) {
  942.         $prezzoO=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode,$listinoO)));
  943.         $prezzoN=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode,$listinoN)));
  944.         $costo=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getCosto($mycode,"null")));
  945.         $delta= (intval($prezzoO)==0) ? 0 : number_format(($prezzoN-$prezzoO)/$prezzoO*100,1);
  946.         $nettoNew=$prezzoN*0.6*0.9;
  947.         $marg= (intval($prezzoN)==0) ? 0 : number_format(($nettoNew-$costo)/$nettoNew*100,1);
  948.         $margAss= (intval($prezzoN)==0 || intval($costo)==0 ) ? 0 : number_format($nettoNew-$costo,0);
  949.         $dati=array("codice"=>$mycode->getCodice(),"prezzoO"=>$prezzoO,"prezzoN"=>$prezzoN,"costo"=>$costo,"deltaPp"=>$delta,"prezzoNnet"=>$nettoNew,"margNp"=>$marg,"margN"=>$margAss);
  950.         return $dati;
  951.     }
  953.     public function getDatiPrezziAll($mycode, $curr_or_new) {
  954.         $prezzo_IT = '';
  955.         $prezzo_ES = '';
  956.         $prezzo_FR = '';
  957.         $prezzo_DE = '';
  958.         $prezzo_UN = '';
  959.         if ($curr_or_new == 'curr') {
  960.             $prezzo_IT=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode, 'getLis_it_curr')));
  961.             $prezzo_ES=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode, 'getLis_es_curr')));
  962.             $prezzo_FR=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode, 'getLis_fr_curr')));
  963.             $prezzo_DE=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode, 'getLis_de_curr')));
  964.             $prezzo_UN=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode, 'getLis_row_curr')));
  965.         } else {
  966.             $prezzo_IT=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode, 'getLis_it_new')));
  967.             $prezzo_ES=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode, 'getLis_es_new')));
  968.             $prezzo_FR=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode, 'getLis_fr_new')));
  969.             $prezzo_DE=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode, 'getLis_de_new')));
  970.             $prezzo_UN=intval(str_replace(".", "", \AppBundle\Controller\ProvaController::getPrezzo($mycode, 'getLis_row_new')));
  971.         }
  973.         return array("codice"=>$mycode->getCodice(), "prezzo_IT"=>$prezzo_IT,"prezzo_ES"=>$prezzo_ES,"prezzo_FR"=>$prezzo_FR, "prezzo_DE"=>$prezzo_DE, "prezzo_UN"=>$prezzo_UN);
  974.     }
  976.     //*********************  FUNZIONI COMODE PER RENDERIZZARE  ***********************************************
  977.     public function renderHeader($title) {
  978.         return '<tr>
  979.                     <th class="prima titolo_tab" align="left" colspan="2">'.$title.'</th>
  980.                     <th class="prima titolo_tab" align="center">€_old</th>
  981.                     <th class="prima titolo_tab" align="center">€_new</th>
  982.                     <th class="prima titolo_tab" align="center">[€]</th>
  983.                     <th class="prima titolo_tab" align="center">&#916;%</th>
  984.                     <th class="prima titolo_tab" align="right">&#916;€</th>
  985.                 </tr>';
  986.     }
  988.     public function renderDati($desc,$mycode,$listinoO,$listinoN) {
  989.         $dati=\AppBundle\Controller\ProvaController::getDati($mycode,$listinoO,$listinoN);
  990.         return '<tr>
  991.                     <td class="prima descrizione_opt" width="40%">'.$desc.'</td>
  992.                     <td align="center" width="10%" class="codice"><a href="http://pim.palazzetti.it/admin/login/deeplink?object_'.$mycode->getId().'_object" target="_new">'.$dati["codice"].'</a></td>
  993.                     <td align="center" width="10%" class="prezzo">'.$dati["prezzoO"].'</td>
  994.                     <td align="center" width="10%" class="prezzo">'.$dati["prezzoN"].'</td>
  995.                     <td align="center" width="10%" class="prezzo">'.$dati["costo"].'</td>
  996.                     <td align="center" width="10%" class="prezzo">'.$dati["margNp"].'%</td>
  997.                     <td align="right"  width="10%" class="prezzo">'.$dati["margN"].'</td>
  998.                 </tr>';
  999.     }
  1001.     public function renderHeaderDatiAll($title) {
  1002.         return '<tr>
  1003.                     <th class="prima titolo_tab" align="left" colspan="2">'.$title.'</th>
  1004.                     <th class="prima titolo_tab" align="center">€ IT</th>
  1005.                     <th class="prima titolo_tab" align="center">€ ES</th>
  1006.                     <th class="prima titolo_tab" align="center">€ FR</th>
  1007.                     <th class="prima titolo_tab" align="center">€ DE</th>
  1008.                     <th class="prima titolo_tab" align="center">€ EN</th>
  1009.                 </tr>';
  1010.     }
  1012.     public function renderDatiAll($desc,$mycode,$curr_or_new) {
  1013.         $dati=\AppBundle\Controller\ProvaController::getDatiPrezziAll($mycode, $curr_or_new);
  1015.         return '<tr>
  1016.                     <td class="prima descrizione_opt" width="40%">'.$desc.'</td>
  1017.                     <td align="center" width="10%" class="codice"><a href="http://pim.palazzetti.it/admin/login/deeplink?object_'.$mycode->getId().'_object" target="_new">'.$dati["codice"].'</a></td>
  1018.                     <td align="center" width="10%" class="prezzo">'.$dati["prezzo_IT"].'</td>
  1019.                     <td align="center" width="10%" class="prezzo">'.$dati["prezzo_ES"].'</td>
  1020.                     <td align="center" width="10%" class="prezzo">'.$dati["prezzo_FR"].'</td>
  1021.                     <td align="center" width="10%" class="prezzo">'.$dati["prezzo_DE"].'</td>
  1022.                     <td align="center" width="10%" class="prezzo">'.$dati["prezzo_UN"].'</td>
  1023.                 </tr>';
  1024.     }
  1026.     public function renderTable($myArrayh2,$myArray) {
  1027.         $campi=$myArray[0];
  1028.         $corpo='';
  1029.         if (!is_null($myArrayh2) && !is_null($campi)) {
  1030.             $corpo='<!-- CLASS RENDERER -->
  1031.                 <table class="display compact" width="100%" style="font-size: 8pt;border-collapse: collapse; margin-top: 10px;">
  1032.                 <thead><tr style="background:#cfd0d1">';
  1033.             foreach ($campi as $dettS) {
  1034.                 if ($dettS=="incentivi") {
  1035.                     $corpo=$corpo.'<th width="100px" ';
  1036.                 } elseif ($dettS=="certificazioni") {
  1037.                     $corpo=$corpo.'<th width="130px" ';
  1038.                 } else  {
  1039.                     $corpo=$corpo.'<th ';
  1040.                 }
  1041.                 $corpo=$corpo.' style="border: 1px solid #878786;text-align:center;">'.$myArrayh2[$dettS].'</th>';
  1042.             }
  1043.             $corpo=$corpo.'</tr></thead><tbody>';                 
  1044.             //$myArray=$myArrayNew2;
  1045.             $tot=count($myArray);
  1046.             $newSpanner=array();
  1047.             $i=1;
  1048.             foreach ($campi as $dettS) {
  1049.                 $i=1;
  1050.                 $newSpanner[$i][$dettS]=1;
  1051.                 for ($j = $i+1; $j < count($myArray); $j++) {
  1052.                     if ($myArray[$i][$dettS]==$myArray[$j][$dettS]  ) {
  1053.                         $newSpanner[$i][$dettS]++;
  1054.                         $newSpanner[$j][$dettS]=0;
  1055.                     } else  {
  1056.                         $newSpanner[$j][$dettS]=1;
  1057.                         $i=$j;
  1058.                     }
  1059.                 }
  1060.             }
  1062.             for ($k = 1; $k < count($myArray); $k++) {
  1063.                 $corpo=$corpo.'<tr>';
  1064.                     foreach ($campi as $dettS) {
  1065.                         if($newSpanner[$k][$dettS]==0) {
  1066.                         } else if ($newSpanner[$k][$dettS]==1) {
  1067.                             $corpo=$corpo.'<td style="border: 1px solid #878786;text-align:center;">'.$myArray[$k][$dettS].'</td>';
  1068.                         } else {
  1069.                             $corpo=$corpo.'<td style="border: 1px solid #878786;text-align:center;" rowspan="'.$newSpanner[$k][$dettS].'">'.$myArray[$k][$dettS].'</td>';
  1070.                         }
  1071.                     }                                       
  1072.                 $corpo=$corpo.'</tr>';
  1073.             }
  1074.             $corpo=$corpo.'</tbody></table>';
  1075.             return $corpo;
  1076.         } else {
  1077.             return '';
  1078.         }
  1079.     }
  1081. }