src/MDS/EventsBundle/Controller/ProposalSupplierController.php line 91

Open in your IDE?
  1. <?php
  2. /**
  3.  * Created by Mediterranean Develup Solutions
  4.  * User: jorge.defreitas@develup.solutions
  5.  * Date: 14/08/2017
  6.  * Time: 12:15
  7.  */
  9. namespace App\MDS\EventsBundle\Controller;
  11. use App\Entity\Activities;
  12. use App\Entity\Cities;
  13. use App\Entity\Client;
  14. use App\Entity\ClientContact;
  15. use App\Entity\Country;
  16. use App\Entity\Destination;
  17. use App\Entity\DestinationGallery;
  18. use App\Entity\Ideas;
  19. use App\Entity\ProposalsInvoiceSummary;
  20. use App\Entity\Provinces;
  21. use App\Entity\Regions;
  22. use App\Entity\RevisionCarga;
  23. use App\Entity\Supplier;
  24. use App\Entity\SupplierAccommodation;
  25. use App\Entity\SupplierActivities;
  26. use App\Entity\SupplierAv;
  27. use App\Entity\SupplierCreative;
  28. use App\Entity\SupplierCruise;
  29. use App\Entity\SupplierDescription;
  30. use App\Entity\SupplierEntertainment;
  31. use App\Entity\SupplierGallery;
  32. use App\Entity\SupplierGifts;
  33. use App\Entity\SupplierGuide;
  34. use App\Entity\SupplierIdeaServicesControl;
  35. use App\Entity\SupplierIdServices;
  36. use App\Entity\SupplierItineraries;
  37. use App\Entity\SupplierLounge;
  38. use App\Entity\SupplierMenu;
  39. use App\Entity\SupplierOthers;
  40. use App\Entity\SupplierServicesAssistant;
  41. use App\Entity\SupplierServicesControl;
  42. use App\Entity\SupplierServicesDescription;
  43. use App\Entity\SupplierTechnology;
  44. use App\Entity\SupplierTransport;
  45. use App\Entity\User;
  46. use App\MDS\AvexpressBundle\Entity\AveBriefings;
  47. use App\MDS\DevelupBundle\Entity\MdvBriefings;
  48. use App\MDS\EventsBundle\Entity\ProposalDiscount;
  49. use App\MDS\EventsBundle\Entity\ProposalFee;
  50. use App\MDS\EventsBundle\Entity\ProposalSupplierControl;
  51. use App\MDS\EventsBundle\Entity\ProposalSupplierServices;
  52. use App\MDS\EventsBundle\Form\ProposalActivitiesControlType;
  53. use App\MDS\EventsBundle\Form\ProposalDiscountType;
  54. use App\MDS\EventsBundle\Form\ProposalIdeasControlType;
  55. use App\MDS\EventsBundle\Form\ProposalSupplierControlType;
  56. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  57. use Symfony\Component\Routing\Annotation\Route;
  58. use Symfony\Component\HttpFoundation\JsonResponse;
  59. use Symfony\Component\HttpFoundation\Request;
  60. use App\MDS\EventsBundle\Entity\ProposalSupplierServicesCostsClient;
  61. use App\MDS\DevelupBundle\Entity\MdvBudgetPending;
  62. use App\MDS\DevelupBundle\Entity\MdvFiles;
  63. use App\MDS\DevelupBundle\Entity\MdvProduct;
  64. use App\MDS\DevelupBundle\Entity\MdvTelegramUser;
  65. use App\MDS\EventsBundle\Entity\Proposal;
  66. use App\MDS\EventsBundle\Entity\ProposalControl;
  67. use App\MDS\EventsBundle\Entity\ProposalsSupplierServicesAssistantName;
  68. use App\MDS\EventsBundle\Entity\ProposalSupplierServicesBudget;
  69. use App\MDS\EventsBundle\Entity\ProposalSupplierServicesCosts;
  70. use Swift_Mailer;
  71. use Swift_Message;
  72. use Swift_SmtpTransport;
  73. use Symfony\Contracts\Translation\TranslatorInterface;
  75. class ProposalSupplierController extends AbstractController
  76. {
  77.     private $translator;
  79.     public function __construct(TranslatorInterface $translator) {
  80.         $this->translator = $translator;
  81.     }
  83. //    /*
  84. //    * ATENCION LAS RAIZ DE @Route POR DEFECTO DEL BUNDLE: EventsBundle ES  /events/, NO PONERLO EN LA @Route("")
  85. //    *
  86. //    * */
  88.     /**
  89.      * @Route("/proposal/destination/services/add/{id}/{status}", defaults={"status" = "All"},  name="proposal_destination_supplier_view")
  90.      */
  91.     public function viewSupplierAction($id, $status, Request $request)
  92.     {
  93.         $em = $this->getDoctrine()->getManager();
  94.         $destinationCrtl = $em->getRepository(ProposalControl::class)->findOneById($id);
  95.         $adicionales_destination = $em->getRepository(ProposalControl::class)->findByProposalId($destinationCrtl->getProposalId());
  97.         $mostrar_destino_adicionales = array();
  98.         foreach($adicionales_destination as $adicionaldestination){
  99.             $destination = $em->getRepository(Destination::class)->findOneById($adicionaldestination->getDestinationId());
  100.             $mostrar_destino_adicionales = array(
  101.                 'idcontrol' => $adicionaldestination->getId(),
  102.                 'title' => $destination->getTitle()
  103.             );
  104.         }
  106.         $destination = $em->getRepository(Destination::class)->findOneById($destinationCrtl->getDestinationId());
  108.         /* Formulario Supplier*/
  109.         $controlsupplier= new ProposalSupplierControl();
  110.         $controlsupplier->setControlDestinationId($id);
  111.         $controlsupplier->setProposalId($destinationCrtl->getProposalId());
  112.         $controlsupplier->setDestinoId($destinationCrtl->getDestinationId());
  114. //        $supplier_data = $em->getRepository(Supplier::class)->findBy(
  115. //            array(
  116. //                'country' => $destination->getCountry(),
  117. //                'province' => $destination->getProvince(),
  118. //                'population' => $destination->getPopulation()
  119. //            )
  120. //        );
  121. //
  122. //        foreach($supplier_data as $supplier_pais){
  123. //            $choices_data = array(
  124. //                'choices' => array(
  125. //                    'id' => $supplier_pais->getId(),
  126. //                    'Company' => $supplier_pais->getCompany()
  127. //                )
  128. //            );
  129. //        };
  130. //        $controlsupplier->setSupplierId($choices_data);
  132.         $form = $this->createDestinationProposalSupplierCreateForm($controlsupplier);
  133.         $form2 = $this->createDestinationProposalIdeasCreateForm($controlsupplier);
  134.         $form4 = $this->createDestinationProposalActivitiesCreateForm($controlsupplier);
  137.         $consultadiscount = $em->getRepository(ProposalDiscount::class)->findByProposalId($destinationCrtl->getProposalId());
  138.         if(!empty($consultadiscount)){
  139.             foreach($consultadiscount as $consultadiscountfor){
  140.                 if(is_null($consultadiscountfor->getServiceId())){
  141.                     $consultadiscountfor->setServiceId('All');
  142.                 }else{
  143.                     $servicesName = $em->getRepository(SupplierIdServices::class)->findOneById($consultadiscountfor->getServiceId());
  144.                     $consultadiscountfor->setServiceId($servicesName->getName());
  145.                 }
  146.             }
  147.         }
  148.         /* Formulario Discount*/
  149.         $discount = new ProposalDiscount();
  150.         $discount->setProposalId($destinationCrtl->getProposalId());
  151.         $form3 = $this->createDiscountCreateForm($discount);
  152. //        }else{
  153. //            $consultadiscount ->setProposalId($destinationCrtl->getProposalId());
  154. //            $form3 = $this->editDiscountCreateForm($consultadiscount, $consultadiscount->getId());
  155. //        }
  157.         /* Data Proposal */
  158.         $idproposal = $destinationCrtl->getProposalId();
  159.         $proposal = $em->getRepository(Proposal::class)->findOneById($idproposal);
  160. //
  161. //            $commercial = $em->getRepository(User::class)->findOneById($proposal->getAgencommercialId());
  162. //            $proposal->setAgencommercialId($commercial->getName().' '.$commercial->getLastname());
  163. //
  164. //            $client = $em->getRepository(Client::class)->findOneById($proposal->getClientId());
  165. //            $proposal->setClientId($client->getName());
  166. //
  167. //            $contact = $em->getRepository(ClientContact::class)->findOneById($proposal->getContactId());
  168. //            $proposal->setContactId($contact->getName().' '.$contact->getLastname());
  169. //            $datos_contacto = array(
  170. //                'contacttelefono' => $contact->getPhone(),
  171. //                'contactemail' => $contact->getEmail(),
  172. //            );
  173. //
  174. //            if (!is_null($proposal->getTeamId())){
  175. //            $teams = $em->getRepository(SettingsTeam::class)->findOneById($proposal->getTeamId());
  176. //            $proposal->setTeamId($teams->getTeam());
  177. //            }
  178. //
  179. //            $office = $em->getRepository(SettingsOffice::class)->findOneById($proposal->getOfficeId());
  180. //            $proposal->setOfficeId($office->getOffice());
  181. //
  182. //            $agent = $em->getRepository(User::class)->findOneById($proposal->getAgentId());
  183. //            $proposal->setAgentId($agent->getName().' '.$agent->getLastname());
  184. //
  185. //                $iconstatus = "";
  186. //                switch ($proposal->getStatus()) {
  187. //                    case "Pending":
  188. //                        $iconstatus ='<i class="icon-bell3 text-danger parpadea"></i>';
  189. //                        break;
  190. //                    case "Sent":
  191. //                        $iconstatus ='<i class="icon-paperplane text-orange parpadea"></i>';
  192. //                        break;
  193. //                    case "Confirmed":
  194. //                        $iconstatus ='<i class="icon-unlocked text-success"></i>';
  195. //                        break;
  196. //                    case "Invoiced":
  197. //                        $iconstatus ='<i class="icon-lock2 text-green"></i>';
  198. //                        break;
  199. //                }
  200. //
  201. //            $proposal->SetStatus($this->translator->trans($proposal->getStatus()));
  205.         /* Data destino */
  206. //        $destination = $em->getRepository(Destination::class)->findOneById($destinationCrtl->getDestinationId());
  207.         //$destinationGallery = $em->getRepository(DestinationGallery::class)->findOneByDestinationId($destinationCrtl->getDestinationId());
  209.         $country = $em->getRepository(Country::class)->findOneById($destination->getCountry());
  210.         $destination->setCountry($country->getCountry());
  212.         $regions = $em->getRepository(Regions::class)->findOneById($destination->getRegion());
  213.         $destination->setRegion($regions->getRegion());
  215.         $province = $em->getRepository(Provinces::class)->findOneById($destination->getProvince());
  216.         $destination->setProvince($province->getName());
  219.         $cities = $em->getRepository(Cities::class)->findOneById($destination->getPopulation());
  220.         $destination->setPopulation($cities->getCity());
  222.         $mostrar_destino = array(
  223.             'idcontrol' => $destinationCrtl->getId(),
  224.             'destinoId' => $destination->getId(),
  225.             'title' => $destination->getTitle(),
  226.             //'image' => $destinationGallery->getImageSmall(),
  227.             'country' => $destination->getCountry(),
  228.             'region' => $destination->getRegion(),
  229.             'province' => $destination->getProvince(),
  230.             'population' =>$destination->getPopulation()
  231.         );
  233.         /* Data Supplier agregados */
  234. //        if($status == "All") {
  235. //            $array_ProposalSupplierControl =
  236. //                array(
  237. //                'proposalId' => $destinationCrtl->getProposalId(),
  238. //                'destinoId' => $destinationCrtl->getDestinationId()
  239. //                );
  240. //        }else{
  241. //                $array_ProposalSupplierControl = array(
  242. //                    'proposalId' => $destinationCrtl->getProposalId(),
  243. //                    'destinoId' => $destinationCrtl->getDestinationId()
  244. //                );
  245. //        }
  246. //        $service_supplier = $em->getRepository(ProposalSupplierControl::class)->findBy();
  248.         $service_supplier = $em->getRepository(ProposalSupplierControl::class)->findBy(
  249.             array(
  250.                 'proposalId' => $destinationCrtl->getProposalId(),
  251.                 'destinoId' => $destinationCrtl->getDestinationId(),
  252.             ),
  253.             array(
  254.                 'rank' => 'ASC'
  255.             )
  256.         );
  257.         $totales_global_neto = 0;
  258.         $totales_global_direct = 0;
  259.         $totales_global_iva = 0;
  260.         $totales_global_con_iva = 0;
  261.         $totales_global_paying = 0;
  262.         $totales_global_pago = 0;
  263.         $totales_global_benefit_moneda = 0;
  264.         $totales_global_benefit_porsentaje = 0;
  265.         $calculos_globales = array();
  267.         $data_supplier = array();
  268.         $controlgeneral = array();
  269.         foreach($service_supplier as $suppliercontrol){
  271.             //cambiar el estatus de colores
  272.             $colorlabel = "";
  273.             switch ($suppliercontrol->getStatus()) {
  274.                 case 'Pending':
  275.                     $colorlabel= "bg-danger";
  276.                     break;
  277.                 case 'Confirmed':
  278.                     $colorlabel= "bg-success-300";
  279.                     break;
  280.             }
  281.             $suppliercontrol->SetStatus($this->translator->trans($suppliercontrol->getStatus()));
  283.             $sqlactivities = "";
  284.             if(!is_null($suppliercontrol->getActivityId())){
  285.                 $master = "activity";
  286.                 $sqlactivities = $em->getRepository(Activities::class)->findOneById($suppliercontrol->getActivityId());
  287.                 /*CONTROL GENERAL*/
  288.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByActivityId($suppliercontrol->getActivityId());
  290.             }
  292.             $sqlideas = "";
  293.             if(!is_null($suppliercontrol->getIdeaId())){
  294.                 $master = "idea";
  295.                 $sqlideas = $em->getRepository(Ideas::class)->findOneById($suppliercontrol->getIdeaId());
  296.                 /*CONTROL GENERAL*/
  297.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByIdeaId($suppliercontrol->getIdeaId());
  299.             }
  301.             $sqlsuppliers ="";
  302.             if(!is_null($suppliercontrol->getSupplierId())){
  303.                 $master = "supplier";
  304.                 $sqlsuppliers = $em->getRepository(Supplier::class)->findOneById($suppliercontrol->getSupplierId());
  305.                 if(!is_null($sqlsuppliers)){
  306.                     switch ($sqlsuppliers->getStar()) {
  307.                         case 1:
  308.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i>');
  309.                             break;
  310.                         case 2:
  311.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i>');
  312.                             break;
  313.                         case 3:
  314.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i>');
  315.                             break;
  316.                         case 4:
  317.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i>');
  318.                             break;
  319.                         case 5:
  320.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i> SUP');
  321.                             break;
  322.                         case 6:
  323.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i>');
  324.                             break;
  325.                         case 7:
  326.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i> GL');
  327.                             break;
  328.                         case 8:
  329.                             $sqlsuppliers->setStar('<i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i><i class="icon-star-full2"></i> GL');
  330.                             break;
  331.                     }
  332.                 }
  333.                 /*CONTROL GENERAL*/
  334.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneBySupplierId($suppliercontrol->getSupplierId());
  336.             }
  337.             if (empty($controlgeneral)){
  338.                 $master = "White";
  339.                 $idsu = '0';
  340.             }else{
  341.                 $idsu = $controlgeneral->getId();
  342.             }
  344.             $sqlsuppliers_gallery = $em->getRepository(SupplierGallery::class)->findOneBy(
  345.                 array(
  346.                     'supplierId' => $idsu,
  347.                     'servicesCatId' => '0',
  348.                     'servicesCategory' => 'General',
  349.                     'servicesId' => '0',
  350.                     'controlId' => '0'
  351.                 )
  352.             );
  353.             if (!is_null($sqlsuppliers_gallery)){
  354.                 $imagenSmall = $sqlsuppliers_gallery->getimageSmall();
  355.             }else{
  356.                 //Imagen no disponible (poner una generica)
  357.                 $imagenSmall = null;
  358.             }
  360.             // SIN ORDEN
  361.             // $data_service_supplier = $em->getRepository(ProposalSupplierServices::class)->findByControlId($suppliercontrol->getId());
  363.             // CON ORDEN DESCENDENTE
  364. //                $data_service_supplier = $em->getRepository(ProposalSupplierServices::class)->findByControlId(
  365. //                    array( 'controlId' => $suppliercontrol->getId() ),
  366. //                    array( 'id' => 'DESC' )
  367. //                    );
  369.             // ORDEN DESCENDENTE Y POR SERVICES
  370.             if($status == "All"){
  371.                 $parameters = array(
  372.                     'controlId' => $suppliercontrol->getId(),
  373.                     'serviceIdFather' => '0'
  374.                 );
  375.                 $dql = 'SELECT p
  376.                         FROM EventsBundle:ProposalSupplierServices p
  377.                         WHERE p.controlId = :controlId AND p.serviceIdFather = :serviceIdFather 
  378.                         ORDER BY p.rank, p.serviceCatId ASC ';
  379. //                        ORDER BY p.serviceCatId, p.rank ASC ';
  380.             }else{
  382.                 $parameters = array(
  383.                     'controlId' => $suppliercontrol->getId(),
  384.                     'serviceIdFather' => '0',
  385.                     'status' => $status
  386.                 );
  388.                 $dql = 'SELECT p
  389.                         FROM EventsBundle:ProposalSupplierServices p
  390.                         WHERE p.controlId = :controlId AND p.serviceIdFather = :serviceIdFather AND p.status = :status
  391.                         ORDER BY p.rank, p.serviceCatId ASC ';
  392. //                        ORDER BY p.serviceCatId, p.rank ASC ';
  393.             }
  396. //                $dql = 'SELECT p
  397. //                        FROM EventsBundle:ProposalSupplierServices p
  398. //                        WHERE p.controlId = :controlId AND p.serviceIdFather = :serviceIdFather AND p.status in (:status)
  399. //                        ORDER BY p.serviceCatId, p.id ASC ';
  401.             $query = $em->createQuery($dql)->setParameters($parameters);
  402.             $data_service_supplier = $query->getResult();
  404.             $service_supplier_data = array();
  405.             $calculos_totatales = array();
  406.             $totales_neto ='0';
  407.             $total_direct ='0';
  408.             $totales_iva ='0';
  409.             $totales_con_iva ='0';
  410.             $totales_paying ='0';
  411.             $totales_pago ='0';
  412.             $totales_benefit_moneda ='0';
  413.             $totales_benefit_porsentaje ='0';
  415.             foreach($data_service_supplier as $data_service){
  417.                 $service_supplier_data_sub = array();
  418.                 $zNameSrvOrNameUsrBool = false;
  420.                 //COLOR POR SERVICIO
  421.                 $contcolor ="";
  422.                 switch ($data_service->getServiceCatName()) {
  423.                     case "Accommodation":
  424.                         $contcolor = 'teal';
  425.                         break;
  426.                     case "Menu" :
  427.                         $contcolor = 'purple';
  428.                         break;
  429.                     case "Lounge":
  430.                         $contcolor = 'warning';
  431.                         break;
  432.                     case "Activities":
  433.                         $contcolor = 'blue';
  434.                         break;
  435.                     case "Itineraries":
  436.                         $contcolor = 'indigo';
  437.                         break;
  438.                     case "Cruise":
  439.                         $contcolor = 'brown';
  440.                         break;
  441.                     case "Transport":
  442.                         $contcolor = 'grey';
  443.                         break;
  444.                     case "Av":
  445.                         $contcolor = 'slate';
  446.                         break;
  447.                     case "Creative":
  448.                         $contcolor = 'orange';
  449.                         break;
  450.                     case "Gifts":
  451.                         $contcolor = 'pink';
  452.                         break;
  453.                     case "Entertainment":
  454.                         $contcolor = 'green';
  455.                         break;
  456.                     case "Guide":
  457.                         $contcolor = 'orange';
  458.                         break;
  459.                     case "Others":
  460.                         $contcolor = 'danger';
  461.                         break;
  462.                     case "Technology":
  463.                         $contcolor = 'slate-800';
  464.                         break;
  465.                     case "Assistant":
  466.                         $contcolor = 'indigo-800';
  467.                         $prpSupSrv = $em->getRepository(ProposalsSupplierServicesAssistantName::class)->findOneByPrpSupSrvId($data_service->getId());
  468.                         $zNameSrvOrNameUsrBool = !empty($prpSupSrv);
  469.                         break;
  470.                     case "DDR":
  471.                         $contcolor = 'green-300';
  472.                         break;
  473.                 }
  475.                 $servicesbudgetconfirm = $em->getRepository(ProposalSupplierServicesBudget::class)->findOneBy(
  476.                     array(
  477.                         'itemsServiceId' => $data_service->getId(),
  478.                         'proposalId' => $data_service->getProposalId(),
  479.                         'status' => 'Confirmed',
  480.                     ),
  481.                     array(
  482.                         'updatedAt' => 'DESC'
  483.                     )
  484.                 );
  486.                 if (is_null($servicesbudgetconfirm)){
  487.                     $servicesbudgetconfirm = array();
  488.                 }
  491.                 $idcat = $data_service->getServiceCatId();
  492.                 $price = empty($data_service->getPrice())? 0 : $data_service->getPrice();
  493.                 $precommission = $data_service->getPreCommission();
  494.                 $preiva = $data_service->getPreIva();
  495.                 $units = $data_service->getUnits();
  496.                 $pax = $data_service->getPax();
  497.                 $opcommission = $data_service->getOpCommission();
  498.                 $commission = $data_service->getCommission();
  499.                 $opover = $data_service->getOpOver();
  500.                 $over = $data_service->getOver();
  501.                 $opiva = $data_service->getOpIva();
  502.                 $iva = empty($data_service->getIva())? 0 : $data_service->getIva();
  503.                 $dateInAt = $data_service->getDateInAt();
  504.                 $dateOutAt = $data_service->getDateOutAt();
  505.                 if (!is_null($dateInAt) and !is_null($dateOutAt)){
  506.                     $days = $dateInAt->diff($dateOutAt);
  507.                     $day = $days->days;
  508.                 }else{
  509.                     $day = "0";
  510.                 }
  512.                 $directPayment = $data_service->getDirectPayment();
  514.                 if(!is_null($data_service->getSupplierId())){
  515.                     $name_supplier = $em->getRepository(Supplier::class)->findOneById($data_service->getSupplierId());
  516.                     if (empty($name_supplier)){
  517.                         $namesupplier = '';
  518.                     }else{
  519.                         $namesupplier = $name_supplier->getName();
  520.                     }
  522.                 }
  523.                 if(!is_null($data_service->getActivityId())){
  524.                     $name_supplier = $em->getRepository(Activities::class)->findOneById($data_service->getActivityId());
  525.                     if (empty($name_supplier)){
  526.                         $namesupplier = '';
  527.                     }else{
  528.                         $namesupplier = $name_supplier->getName();
  529.                     }
  530.                 }
  531.                 if(!is_null($data_service->getIdeaId())){
  532.                     $name_supplier = $em->getRepository(Ideas::class)->findOneById($data_service->getIdeaId());
  533.                     if (empty($name_supplier)){
  534.                         $namesupplier = '';
  535.                     }else{
  536.                         $namesupplier = $name_supplier->getName();
  537.                     }
  538.                 }
  540.                 $calculos = $this->CalculoTotalesservices($price, $precommission, $preiva, $units, $pax, $day, $opcommission, $commission, $opover, $over, $opiva, $iva, $directPayment, $idcat);
  542. //                /*CONTROL GENERAL*/
  543. //                $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneBySupplierId($data_service->getSupplierId());
  544.                 if (empty($controlgeneral)){
  545.                     $control_general = '0';
  546.                 }else{
  547.                     $control_general = $controlgeneral->getId();
  548.                 }
  550.                 $service_supplier_data[] = array(
  551.                     'calculos' => $calculos,
  552.                     'services_data' => $data_service,
  553.                     'controlBoolNameSrvOrNameUsrBool' => $zNameSrvOrNameUsrBool,
  554.                     'controlGeneralId' => $control_general,
  555.                     'inBudget' => $servicesbudgetconfirm,
  556.                     'namesupplier' => $namesupplier,
  557.                     'contcolor' => $contcolor,
  558.                     'servicesSub' =>$service_supplier_data_sub
  559.                 );
  560.                 if($data_service->getBreakdown() == false){
  561.                     $totales_neto += $calculos['total_neto'];
  562.                     $total_direct += $calculos['total_direct'];
  563.                     $totales_iva += $calculos['sub_total_iva'];
  564.                     $totales_con_iva += $calculos['total'];
  565.                     $totales_paying += $calculos['total_paying'];
  566.                     $totales_pago += $calculos['total_pago'];
  567.                     $totales_benefit_moneda += $calculos['benefit_moneda'];
  568.                 }else{
  569. //                    $totales_neto += $totales_neto_sub ;
  570. //                    $totales_iva += $totales_iva_sub ;
  571. //                    $totales_con_iva += $totales_con_iva_sub;
  572. //                    $totales_paying += $totales_paying_sub;
  573. //                    $totales_pago += $totales_pago_sub;
  574. //                    $totales_benefit_moneda += $totales_benefit_moneda_sub;
  575.                 }
  577.                 $totales_global_neto += $calculos['total_neto'];
  578.                 $totales_global_direct += $calculos['total_direct'];
  579.                 $totales_global_iva += $calculos['sub_total_iva'];
  580.                 $totales_global_con_iva += $calculos['total'];
  581.                 $totales_global_paying += $calculos['total_paying'];
  582.                 $totales_global_pago += $calculos['total_pago'];
  583.                 $totales_global_benefit_moneda += $calculos['benefit_moneda'];
  585.                 if ($totales_benefit_moneda == '0'){
  586.                     $totales_benefit_porsentaje =  '0';
  587.                 }else{
  589.                     $totales_benefit_porsentaje =  $totales_benefit_moneda / $total_direct * 100; // arreglado or estevan
  590.                 }
  592.                 if ($totales_global_benefit_moneda == '0'){
  593.                     $totales_global_benefit_porsentaje =  '0';
  594.                 }else{
  595.                     $totales_global_benefit_porsentaje =  $totales_global_benefit_moneda / $totales_global_direct * 100; // arreglado or estevan
  596.                 }
  597.             }
  599.             $calculos_totatales = array(
  600.                 'totales_neto' => $totales_neto,
  601.                 'totales_iva' => $totales_iva,
  602.                 'totales_con_iva' => $totales_con_iva,
  603.                 'totales_paying' => $totales_paying,
  604.                 'totales_benefit_moneda' => $totales_benefit_moneda,
  605.                 'totales_benefit_porsentaje' => $totales_benefit_porsentaje
  606.             );
  608.             if (!empty($sqlsuppliers)){
  609.                 $briefings = null;
  611.                 if ($sqlsuppliers->getId() == 2){
  612.                     // Buscamos los briefings de Develup
  613.                     $briefings = $em->getRepository(MdvBriefings::class)->findByProposalId($idproposal);
  614.                 }
  616.                 if ($sqlsuppliers->getId() == 80){
  617.                     // Buscamos los briefings de Av Express
  618.                     $briefings = $em->getRepository(AveBriefings::class)->findByProposalId($idproposal);
  619.                 }
  621.             } else { $briefings = null; }
  623.             $data_supplier[] = array(
  624.                 'colorlabel' => $colorlabel,
  625.                 'control' => $suppliercontrol,
  626.                 'master' => $master,
  627.                 'supplier' => $sqlsuppliers,
  628.                 'briefings' => $briefings,
  629.                 'idea' => $sqlideas,
  630.                 'activity' => $sqlactivities,
  631.                 'image' => $imagenSmall,
  632.                 'services' => $service_supplier_data,
  633.                 'totales_services' => $calculos_totatales
  634.             );
  635.         }
  637.         $calculos_globales = array(
  638.             'totales_global_neto' => $totales_global_neto,
  639.             'totales_global_iva' => $totales_global_iva,
  640.             'totales_global_con_iva' => $totales_global_con_iva,
  641.             'totales_global_paying' => $totales_global_paying,
  642.             'totales_global_benefit_moneda' => $totales_global_benefit_moneda,
  643.             'totales_global_benefit_porsentaje' => $totales_global_benefit_porsentaje,
  644.         );
  646.         /*Supplier list*/
  647.         $list_Supplier = $em->getRepository(Supplier::class)->findAll();
  648.         $arraySupplier =array();
  649.         foreach($list_Supplier as $listSupplier) {
  650.             $arraySupplier[] = array(
  651.                 'id' => $listSupplier->getId(),
  652.                 'company' => $listSupplier->getCompany(),
  653.                 'name' => $listSupplier->getName(),
  654.             );
  655.         }
  657.         /*User list*/
  658.         $list_User = $em->getRepository(User::class)->findAll();
  659.         $arrayUser =array();
  660.         foreach($list_User as $listUser) {
  661.             $arrayUser[] = array(
  662.                 'id' => $listUser->getId(),
  663.                 'name' => $listUser->getName().' '.$listUser->getLastname()
  664.             );
  665.         }
  667.         $fee = $em->getRepository(ProposalFee::class)->findByProposalId($idproposal);
  669.         $summaryInvoice = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($idproposal);
  671.         return $this->render('MDS/EventsBundle/services/services-destination-proposal.html.twig',
  672.             array(
  673.                 'id' => $idproposal,
  674.                 'proname' => $proposal->getName(),
  675.                 'token' => $proposal->getAccessKey(),
  676.                 'mcp' => $proposal->getMcp(),
  677.                 'proposal' => $proposal,
  678. //                'proposal_icostatus' => $iconstatus,
  679. //                'datacontact' => $datos_contacto,
  680.                 'destination' => $mostrar_destino,
  681.                 'adicionaldestination' => $mostrar_destino_adicionales,
  682.                 'form' => $form->createView(),
  683.                 'form2' => $form2->createView(),
  684.                 'form3' => $form3->createView(),
  685.                 'form4' => $form4->createView(),
  686.                 'discounts' => $consultadiscount,
  687.                 'fees' => $fee,
  688.                 'summaryInvoice' => $summaryInvoice,
  689.                 'datasupplier' => $data_supplier,
  690.                 'listSupplier' => $arraySupplier,
  691.                 'listUser' => $arrayUser,
  692.                 'status' => $status,
  693.                 'global_calculos' => $calculos_globales
  694.             )
  695.         );
  696.     }
  699.     public function CalculoTotalesservices($price, $precommission, $preiva, $units, $pax, $days, $opcommission, $commission, $opover, $over, $opiva, $iva, $directPayment, $idcat)
  700.     {
  701.         $price = trim($price);
  702.         $over = trim($over);
  703.         $price = str_replace(",", ".", $price);
  704.         $over = str_replace(",", ".", $over);
  705.         
  706.         if (empty($iva)){$iva=0;}
  707.         $iva = $iva / 100;
  708.         if($opiva =='0'){
  709.             $price = $price / ($iva + 1);
  710.         }
  711. //        if($opiva =='1'){
  712. //            $price = $price * ($iva + 1);
  713. //        }
  715.         if(!empty($commission)){
  716.             if($opcommission=='1'){
  717.                 $commission = ($commission / 100) + 1;
  719.             }
  720.             if($opcommission=='0'){
  721.     //            $price = $price * 0.9;
  722.                 $commission = (100 - $commission) / 100;
  723.                 $price = $price * $commission;
  724.             }
  725.         }
  726.         //Units
  727.         if(empty($units) or $units =="0"){
  728.             $units = "1";
  729.         }
  731.         // Calculo Especial por categoria
  732.         //Alojamientos
  733.         if($idcat =="1"){
  734.             $informativo_days = "si";
  735.             $pax = "1";
  736.         }
  737.         //Transporte
  738.         elseif($idcat =="13"){
  739.             $informativo_days = "no";
  740.             $pax = "1";
  741.         }
  742.         //Guia
  743.         elseif($idcat =="8") {
  744.             $informativo_days = "no";
  745.             $pax = "1";
  746.         }
  747.         //Lounge
  748.         elseif($idcat =="10"){
  749.             $informativo_days = "no";
  750.             $pax = "1";
  751.         }else{
  752.             $informativo_days = "no";
  753.         }
  754.         //Pax
  755.         if(empty($pax) or $pax =="0"){
  756.             $pax = "1";
  757.         }
  759.         //Over
  760.         if(empty($over)){
  761.             $over = "0";
  762.         }
  764.         if($informativo_days =="no"){
  765.             //Days
  766.             if(empty($days) or $days =="0"){
  767.                 $days = "1";
  768.             }else{
  769.                 $days = $days + 1 ;
  770.             }
  771.         }
  773.         $total_items = $price * $units * $pax * $days;
  775.         $total_pdirect = $price * $units * $pax * $days;
  779.         $total_over = $over * $units * $pax * $days;
  781. //        if($opover=='0' and !empty($over)){
  782. ////            $total_neto = $total_items * ($commission + 1) - $total_over ;
  783. ////            $total_neto = $total_items / 0.9 - $total_over ;
  784. //            $total_neto = $total_items / $commission - $total_over ;
  785. //        }
  786. //        if($opover=='1' or (empty($over) or $over == "0")){
  787. ////            $total_neto = $total_items * ($commission + 1) + $total_over;
  788. ////            $total_neto = $total_items / 0.9 + $total_over;
  789. //            $total_neto = $total_items * $commission + $total_over;
  790. //        }
  792.         if(!empty($commission)){
  793.             if($opcommission=='0'){
  794.                 $total_neto = $total_items / $commission;
  795.             }
  796.             if($opcommission=='1'){
  797.                 $total_neto = $total_items * $commission;
  798.             }
  799.         }else{
  800.             $total_neto = $total_items;
  801.         }
  803.         if($opover=='0'){
  804.             $total_neto = $total_neto - $total_over ;
  805.         }
  806.         if($opover=='1'){
  807.             $total_neto = $total_neto +  $total_over;
  808.         }
  810. //        $total_neto = $total_items * ($commission + 1);
  812.         $total_paying = $total_items * ($iva + 1);
  816.         $total_comision ="0";
  817. //        $total_pago = $total_items + $total_comision;
  818.         $total_pago = $total_items;
  819.         $total_iva = $total_items * $iva;
  820.         $sub_total_iva = $total_neto * $iva;
  822.         $total = $total_neto + $sub_total_iva;
  824.         $benefit_moneda = $total_neto - $total_items;
  826. //        if ($directPayment == true){
  827. //            $benefit_moneda = $total_neto;
  828. //            $total_paying = "0";
  829. //        }else{
  830. //            $benefit_moneda = $total_neto - $total_items;
  831. //        }
  833.         $total_direct = $total_neto;
  834.         if ($directPayment == true){
  835.             $total_neto = "0";
  836.             $total = "0";
  837.             $total_paying = "0";
  838.             $total_pago = "0";
  839.             $sub_total_iva = "0";
  840.         }
  843.         $data_calculos = array(
  844.             'total_days' => $days,
  845.             'sub_total' => $total_items,
  846.             'sub_total_iva' => $sub_total_iva,
  847.             'total_neto' => $total_neto,
  848.             'total_direct' => $total_direct,
  849.             'total_iva' => $total_iva,
  850.             'total_paying' => $total_paying,
  851.             'total_pago' => $total_pago,
  852.             'total_comision' => $total_comision,
  853.             'total' => $total,
  854.             'benefit_moneda' => $benefit_moneda
  855.         );
  857. //        d($data_calculos);
  858.         return $data_calculos;
  860.     }
  863.     /* CREAR DESDE UN SUPPLIER ESPECIAL*/
  864.     /**
  865.      * @Route("/proposal/destination/servicesesp/create/{cdid}/{pid}/{did}/{sid}", name="proposal_destination_supplier_create_especial")
  866.      */
  867.     public function createProposalDestinationEspecialAction($cdid, $pid, $did, $sid, Request $request)
  868.     {
  869.         $em = $this->getDoctrine()->getManager();
  870.         $control_verifico = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  871.             array(
  872.                 'controlDestinationId' => $cdid,
  873.                 'proposalId' => $pid,
  874.                 'destinoId' => $did,
  875.                 'supplierId' => $sid,
  876.             )
  877.         );
  878. //        $proposal = $em->getRepository(Proposal::class)->findOneById($pid);
  881.         if(empty($control_verifico)){
  883.             if(!empty($cdid) and !empty($pid) and !empty($did) and !empty($sid))
  884.             {
  885.                 $control = new ProposalSupplierControl();
  886.                 $control->setControlDestinationId($cdid);
  887.                 $control->setProposalId($pid);
  888.                 $control->setDestinoId($did);
  889.                 $control->setSupplierId($sid);
  890.                 $control->setStatus('Pending');
  891.                 $em->persist($control);
  892.                 $em->flush();
  895.                 // INICIO: Envio de Correo a AV EXPRESS o DEVELUP SOLUTIONS
  897.                 if ($sid == 80 or $sid == 2) {
  898.                     // Es un servicio de proveedor AV EXPRESS o DEVELUP
  900.                     $proposal = $em->getRepository(Proposal::class)->findOneById($pid);
  901.                     $zclient = $em->getRepository(Client::class)->findOneById($proposal->getClientId());
  903.                     $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  904.                     $user_id = $user_logueado->getId();
  907.                     $agentUser = $em->getRepository(User::class)->findOneById($user_id);
  909.                     $agent = $em->getRepository(User::class)->findOneById('20');
  911.                     $mailAgent[] = $agent->getEmail();
  912.                     $agentMail = $agent->getEmail();
  913.                     $zagentReplyTo = array(
  914.                         $agent->getEmail() => $agent->getName() . ' ' . $agent->getLastName()
  915.                     );
  916.                     $firmGmail = $agent->getFirmGmail();
  918.                     if ($sid == 80 ) {
  919.                         // AV Express
  920.                         $mailAgentSent = array(
  921. //                            $zclient->getEmail() => $zclient->getName()
  922. //                            'gustavo.ayala@develup.solutions' => $zclient->getName()
  923.                               'salvador@avexpress.tv' => $zclient->getName()
  924.                         );
  925.                         $empresa = $em->getRepository(Supplier::class)->findOneById('80');
  926.                     } else {
  927.                         // Develup
  928.                         $mailAgentSent = array(
  929.                             'jorge.defreitas@develup.solutions' => $zclient->getName()
  930. //                            'gustavo.ayala@develup.solutions' => $zclient->getName()
  931.                         );
  932.                         $empresa = $em->getRepository(Supplier::class)->findOneById('2');
  933.                     }
  935.                     $mailAgentFrom = array(
  936.                         $agent->getEmail() => $agent->getName() . ' ' . $agent->getLastName()
  937.                     );
  939.                     $data = array(
  940.                         'body' => '' . '<p>Estimado proveedor,</p><p>'. $empresa->getName() .' ha sido dada de alta como uno de los proveedores para la propuesta: &nbsp;</p>                        
  941.                         <p><a href="inout.mante.solutions/events/proposal/edit/' . $proposal->getId() .'">' . $proposal->getTitle() . '</a></p>
  942.                         <p>El usuario que hizo esta incorporación fue: ' . $agentUser->getName() .' '. $agentUser->getLastName() . '</p>'
  943.                     ,
  944. //                        'firm' => '' . '<div dir="ltr" style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 12.8px;"><table border="0" cellpadding="0" style="font-size: 13.3333px; font-family: Verdana, Arial, Helvetica, sans-serif;"><tbody><tr><td width="35%" style="font-family: arial, sans-serif; margin: 0px;"><img src="https://ci4.googleusercontent.com/proxy/xTPcHPPSpFqSf8EjRTvJIv21y6LHuzwbsDqBA4oxRzrrUZQWNYERW7oMbgXjw6CzSDsE9QqPHEk9PiNylx5UaAuSJykk6eA3WiyMGmZmQYc=s0-d-e1-ft#http://www.inout-travel.com/inout-travel/img/logo/logo.jpg" alt="Logo InOut Travel" class="CToWUd"></td><td width="65%" style="font-family: arial, sans-serif; margin: 0px;"><p style="margin-bottom: 0px;"></p><span style="font-size: small; color: rgb(0, 121, 186);"><b>M.I.C.E Dept.</b>&nbsp;<br></span><span style="font-size: x-small; color: rgb(0, 121, 186);">Phone :&nbsp;<a href="tel:+34%20911%2087%2083%2093" value="+34911878393" target="_blank" style="color: rgb(17, 85, 204);">+34 91 187 83 93</a>&nbsp;/&nbsp;<a href="tel:+34%20917%2058%2007%2020" value="+34917580720" target="_blank" style="color: rgb(17, 85, 204);">+34 91 758 07 20</a>&nbsp;</span><span style="font-size: x-small; color: rgb(0, 121, 186);">Fax :&nbsp;<a href="tel:+34%20911%2087%2083%2090" value="+34911878390" target="_blank" style="color: rgb(17, 85, 204);">+34 91 187 83&nbsp;90</a>&nbsp;<br></span><span style="font-size: x-small; color: rgb(0, 121, 186);"><u></u><a href="mailto:eventos@inout-travel.com" target="_blank" style="color: rgb(17, 85, 204);">eventos@inout-travel.com&nbsp;</a><br></span><span style="font-size: small; color: rgb(0, 128, 128);"><a href="http://s.wisestamp.com/links?url=http%3A%2F%2Fs.wisestamp.com%2Flinks%3Furl%3Dhttps%253A%252F%252Furldefense.proofpoint.com%252Fv1%252Furl%253Fu%253Dhttp%253A%252F%252Fs.wisestamp.com%252Flinks%253Furl%25253Dhttp%2525253A%2525252F%2525252Fs.wisestamp.com%2525252Flinks%2525253Furl%2525253Dhttp%252525253A%252525252F%252525252Fwww.inout-travel.com%25252526amp%2525253Bsn%2525253D%252526sn%25253D%2526amp%253Bk%253D2BjihEEf49EEnl2c9cXhDQ%25253D%25253D%25250A%2526amp%253Br%253DoVBgYJTSgqKobIhrxHXwWFa1hslDOFZMhTZjQm3slhE%25253D%25250A%2526amp%253Bm%253DiRaDYfk0sXIZzunVdLJPLTs52u8wk7HMfjdCh290Q5I%25253D%25250A%2526amp%253Bs%253D1a9ff7d8f4f1fb953d74200f6537f77ca64418a966d39f4786e9aed71833d44c%26amp%3Bsn%3D&amp;sn=" target="_blank" data-saferedirecturl="https://www.google.com/url?hl=es&amp;q=http://s.wisestamp.com/links?url%3Dhttp%253A%252F%252Fs.wisestamp.com%252Flinks%253Furl%253Dhttps%25253A%25252F%25252Furldefense.proofpoint.com%25252Fv1%25252Furl%25253Fu%25253Dhttp%25253A%25252F%25252Fs.wisestamp.com%25252Flinks%25253Furl%2525253Dhttp%252525253A%252525252F%252525252Fs.wisestamp.com%252525252Flinks%252525253Furl%252525253Dhttp%25252525253A%25252525252F%25252525252Fwww.inout-travel.com%2525252526amp%252525253Bsn%252525253D%25252526sn%2525253D%252526amp%25253Bk%25253D2BjihEEf49EEnl2c9cXhDQ%2525253D%2525253D%2525250A%252526amp%25253Br%25253DoVBgYJTSgqKobIhrxHXwWFa1hslDOFZMhTZjQm3slhE%2525253D%2525250A%252526amp%25253Bm%25253DiRaDYfk0sXIZzunVdLJPLTs52u8wk7HMfjdCh290Q5I%2525253D%2525250A%252526amp%25253Bs%25253D1a9ff7d8f4f1fb953d74200f6537f77ca64418a966d39f4786e9aed71833d44c%2526amp%253Bsn%253D%26sn%3D&amp;source=gmail&amp;ust=1516881697636000&amp;usg=AFQjCNGFDs4JRUVibUfVQaFSuQ0u9PVwzQ" style="color: rgb(17, 85, 204); font-size: x-small;">http://www.inout-travel.com</a></span><p></p><span style="font-size: small; color: rgb(51, 102, 255);"><a href="https://www.facebook.com/InOutTravel/" target="_blank" data-saferedirecturl="https://www.google.com/url?hl=es&amp;q=https://www.facebook.com/InOutTravel/&amp;source=gmail&amp;ust=1516881697636000&amp;usg=AFQjCNH3zSTpYN6Jn0ibd4io116DlxPPNg" style="color: rgb(17, 85, 204);"><span style="color: rgb(51, 102, 255);"><img src="https://ci5.googleusercontent.com/proxy/8luozs3Ef6tofaP9YvpFMJfUFEqz1QLUJ4pmjmbiZBmIbtfxbFDGS7mVrEd2y32b_P4vDTb14QmA1gowrSAKvtWxet9R3_02VVFOV4S3mKU=s0-d-e1-ft#https://s3.amazonaws.com/images.wisestamp.com/facebook.png" alt="Facebook" width="16" height="16" border="0" class="CToWUd"></span></a><span lang="ES">&nbsp;</span><a href="https://twitter.com/inout_travel?lang=es" target="_blank" data-saferedirecturl="https://www.google.com/url?hl=es&amp;q=https://twitter.com/inout_travel?lang%3Des&amp;source=gmail&amp;ust=1516881697636000&amp;usg=AFQjCNEe-ltzYrhEmNPcORkqhPnlInLutw" style="color: rgb(17, 85, 204);"><span style="color: rgb(51, 102, 255);"><img src="https://ci5.googleusercontent.com/proxy/6sqL0BxRRr4QwfAOhK_hNNAXIpUHZNg-gl3CPQKITbX2dpT2jMTzf3zlwMmhB9BgxZehJzFQT_AJzsskN1uQR-SqppTRLIbJIILDeDNjlA=s0-d-e1-ft#https://s3.amazonaws.com/images.wisestamp.com/twitter.png" alt="Twitter" width="16" height="16" border="0" class="CToWUd"></span></a><span lang="ES">&nbsp; &nbsp;</span><span style="color: rgb(255, 102, 0);"><strong><span lang="ES">Visítanos en las redes sociales!!</span></strong></span></span></td></tr></tbody></table><img src="https://ci4.googleusercontent.com/proxy/rDdypMfZKWPkRRuCB3bp8PSQXo0k5aswGQRjFzy71EB2XEQkr4_rbaroShG2FEJbnrmwoEfE3-Z6r_hNFlfRMNPC1X8yjwJ2eOmZ1DagWHkl8sh7Y60=s0-d-e1-ft#http://www.inout-travel.com/inout-travel/img/logo/firma_MICE.png" class="CToWUd"><br><div></div></div><div dir="ltr" style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: 12.8px;"><p style="text-align: justify; text-indent: 7.1pt; line-height: 14.72px;"><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">De conformidad con lo dispuesto en la Ley Orgánica 15/1999 de Protección de Datos de carácter Personal VIAJES IN OUT TRAVEL, S.L., domiciliado en&nbsp;</span><a href="https://maps.google.com/?q=C/+CRISTOBAL+BORDIU,+53+-+28003+MADRID&amp;entry=gmail&amp;source=g" target="_blank" data-saferedirecturl="https://www.google.com/url?hl=es&amp;q=https://maps.google.com/?q%3DC/%2BCRISTOBAL%2BBORDIU,%2B53%2B-%2B28003%2BMADRID%26entry%3Dgmail%26source%3Dg&amp;source=gmail&amp;ust=1516881697636000&amp;usg=AFQjCNFHPMBadB0TD0U63EsqPiOZ7TPldg" style="color: rgb(17, 85, 204);"><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">C/ CRISTOBAL BORDIU, 53 - 28003 MADRID</span></a><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">, le informa que los datos que nos ha proporcionado formarán parte de un fichero de datos de carácter personal, responsabilidad de dicha entidad, con la finalidad de gestionar las comunicaciones que pudiera mantener con el personal de la misma.</span></p><p style="text-align: justify; text-indent: 7.1pt; line-height: 14.72px;"><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">En el supuesto de que desee ejercitar los derechos que le asisten de acceso, rectificación, cancelación y oposición dirija una comunicación por escrito a VIAJES IN OUT TRAVEL, S.L. a la dirección&nbsp;</span><a href="https://maps.google.com/?q=C/+CRISTOBAL+BORDIU,+53+-+28003+MADRID&amp;entry=gmail&amp;source=g" target="_blank" data-saferedirecturl="https://www.google.com/url?hl=es&amp;q=https://maps.google.com/?q%3DC/%2BCRISTOBAL%2BBORDIU,%2B53%2B-%2B28003%2BMADRID%26entry%3Dgmail%26source%3Dg&amp;source=gmail&amp;ust=1516881697636000&amp;usg=AFQjCNFHPMBadB0TD0U63EsqPiOZ7TPldg" style="color: rgb(17, 85, 204);"><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">C/ CRISTOBAL BORDIU, 53 - 28003 MADRID</span></a><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">&nbsp;&nbsp;incluyendo copia de su Documento Nacional de Identidad o documento identificativo equivalente, ó a través de un mensaje de correo electrónico a la dirección&nbsp;</span><a href="mailto:info@inout-travel.com" target="_blank" style="color: rgb(17, 85, 204);"><b><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">info@inout-travel.com</span></b></a><b><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">.</span></b></p><p style="text-align: justify; text-indent: 7.1pt; line-height: 14.72px;"><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">La información contenida en el presente mensaje de correo electrónico es confidencial y su acceso únicamente está autorizado al destinatario original del mismo, quedando prohibida cualquier comunicación, divulgación, o reenvío, tanto del mensaje como de su contenido. En el supuesto de que usted no sea el destinatario autorizado, le rogamos borre el contenido del mensaje y nos comunique dicha circunstancia a través de un mensaje de correo electrónico a la dirección&nbsp;</span><a href="mailto:info@inout-travel.com" target="_blank" style="color: rgb(17, 85, 204);"><b><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">info@inout-travel.com</span></b></a><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">&nbsp;o al teléfono<b>&nbsp;</b></span><a href="tel:911%2087%2083%2091" target="_blank" style="color: rgb(17, 85, 204);"><b><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">+34&nbsp;</span></b></a><b><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">&nbsp;</span></b><a href="tel:917%2058%2007%2085" target="_blank" style="color: rgb(17, 85, 204);"><b><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">917580785</span></b></a><span style="font-size: 10pt; line-height: 15.3333px; font-family: Arial, sans-serif;">.</span></p></div>',
  945.                         'firm' => '',
  946.                     );
  948.                     // EJECUTAR ENVIO DE ALERTA PARA EL AGENTE
  949.                     $transporter = new Swift_SmtpTransport();
  950.                     $transporter->setHost('smtp.gmail.com')
  951.                         ->setEncryption('ssl')//ssl / tls
  952.                         ->setPort(465)// 465 / 587
  953.                         ->setUsername('desarrollo@develup.solutions')
  954.                         ->setPassword('utvh hzoi wfdo ztjs');
  955.                     $mailer = new Swift_Mailer($transporter);
  957.                     $message = new Swift_Message();
  958.                     $message->setSubject('P#' . $proposal->getId() . ', Alta de servicio')
  959.                         ->setFrom(array("desarrollo@develup.solutions" => "System Mante 3.0"))
  960.                         ->setReplyTo($zagentReplyTo)
  961.                         ->setTo($mailAgentSent)
  962.                         ->setBody(
  963.                             $this->renderView(
  964.                                 'mail/structure-mail.html.twig',
  965.                                 array('data' => $data)
  966.                             ),
  967.                             'text/html'
  968.                         );
  970.                     $mailer->send($message);
  971.                 }
  972.                 // FIN: Envio de Correo a AV EXPRESS o DEVELUP SOLUTIONS
  975.                 $event = 'The Supplier Destination Proposal has been created.';
  976.                 $successMessage = $this->translator->trans($event);
  977.                 $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  979.                 return $this->redirectToRoute('proposal_destination_supplier_especial_list', array(
  980.                     'idcontrol' => $control->getId()
  981.                 ));
  983.             }else{
  984.                 $errorMessage = $this->translator->trans('Error, some fields are empty');
  985.                 $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  986.             }
  987.         }else{
  988. //            $errorMessage = $this->translator->trans('The proposal already has this provider included');
  989. //            $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  991.             return $this->redirectToRoute('proposal_destination_supplier_especial_list', array(
  992.                 'idcontrol' => $control_verifico->getId()
  993.             ));
  994.         }
  996.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  997.             'id' => $cdid,
  998.             '_fragment' => 's'.$control_verifico->getId()
  999.         ));
  1001.     }
  1004.     /* CREAR DESDE UN SUPPLIER */
  1005.     private function createDestinationProposalSupplierCreateForm(ProposalSupplierControl $entity)
  1006.     {
  1007.         $form = $this->createForm(ProposalSupplierControlType::class, $entity, array(
  1008.             'action' => $this->generateUrl('proposal_destination_supplier_create'),
  1009.             'method' => 'POST'
  1010.         ));
  1011.         return $form;
  1012.     }
  1015.     /* CREAR DESDE UN SUPPLIER */
  1016.     /**
  1017.      * @Route("/proposal/destination/services/create", name="proposal_destination_supplier_create")
  1018.      */
  1019.     public function createProposalDestinationAction(Request $request)
  1020.     {
  1022.         $control = new ProposalSupplierControl();
  1023.         $form = $this->createDestinationProposalSupplierCreateForm($control);
  1024.         $form->handleRequest($request);
  1026.         $supplier_proposal = $form->get('supplierId')->getData();
  1027.         if(!is_null($supplier_proposal)){
  1028.             $control->setSupplierId($supplier_proposal->getId());
  1029.         }
  1030.         $em = $this->getDoctrine()->getManager();
  1031.         $control_verifico = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1032.             array(
  1033.                 'controlDestinationId' => $form->get('controlDestinationId')->getData(),
  1034.                 'proposalId' => $form->get('proposalId')->getData(),
  1035.                 'destinoId' => $form->get('destinoId')->getData(),
  1036.                 'supplierId' => $supplier_proposal->getId(),
  1037.             )
  1038.         );
  1039.         $proposal = $em->getRepository(Proposal::class)->findOneById($form->get('proposalId')->getData());
  1042.         if(empty($control_verifico)){
  1044.             if($form->isValid())
  1045.             {
  1046.                 $control->setStatus('Pending');
  1047.                 $em->persist($control);
  1048.                 $em->flush();
  1049.                 $event = 'The Supplier Destination Proposal has been created.';
  1050.                 $successMessage = $this->translator->trans($event);
  1051.                 $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  1054.             }else{
  1055.                 $errorMessage = $this->translator->trans('Error, some fields are empty');
  1056.                 $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  1057.             }
  1058.         }else{
  1059.             $errorMessage = $this->translator->trans('The proposal already has this provider included');
  1060.             $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  1061.         }
  1063.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  1064.             'id' => $control->getControlDestinationId(),
  1065.             '_fragment' => 's'.$control->getId()
  1066.         ));
  1068.     }
  1070.     /* CREAR DESDE UNA Activity */
  1071.     private function createDestinationProposalActivitiesCreateForm(ProposalSupplierControl $entity)
  1072.     {
  1073.         $form = $this->createForm(ProposalActivitiesControlType::class, $entity, array(
  1074.             'action' => $this->generateUrl('proposal_destination_activities_create'),
  1075.             'method' => 'POST'
  1076.         ));
  1077.         return $form;
  1078.     }
  1080.     /* CREAR DESDE UNA Activity  */
  1081.     /**
  1082.      * @Route("/proposal/destination/services/createActivity", name="proposal_destination_activities_create")
  1083.      */
  1084.     public function createProposalActivityDestinationAction(Request $request)
  1085.     {
  1086.         $control = new ProposalSupplierControl();
  1087.         $form = $this->createDestinationProposalActivitiesCreateForm($control);
  1088.         $form->handleRequest($request);
  1090.         $supplier_proposal = $form->get('activityId')->getData();
  1091.         if(!is_null($supplier_proposal)){
  1092.             $control->setActivityId($supplier_proposal->getId());
  1093.         }
  1094.         $em = $this->getDoctrine()->getManager();
  1095.         $control_verifico = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1096.             array(
  1097.                 'controlDestinationId' => $form->get('controlDestinationId')->getData(),
  1098.                 'proposalId' => $form->get('proposalId')->getData(),
  1099.                 'destinoId' => $form->get('destinoId')->getData(),
  1100.                 'activityId' => $supplier_proposal->getId(),
  1101.             )
  1102.         );
  1103. //        $proposal = $em->getRepository(Proposal::class)->findOneById($form->get('proposalId')->getData());
  1105.         if(empty($control_verifico)){
  1107.             if($form->isValid())
  1108.             {
  1109.                 $control->setStatus('Pending');
  1110.                 $em->persist($control);
  1111.                 $em->flush();
  1113.                 /* METEMOS EL CONTENIDO DE LA IDEA */
  1114.                 $idcontrol = $control->getId();
  1115.                 $idactivity = $control->getActivityId();
  1117.                 /*CONTROL GENERAL*/
  1118.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByActivityId($idactivity);
  1119.                 $id = $controlgeneral->getId();
  1121.                 $supplierservices= new ProposalSupplierServices();
  1122.                 $supplierservices->setControlId($idcontrol);
  1124.                 $supplierCrtl = $em->getRepository(ProposalSupplierControl::class)->findOneById($idcontrol);
  1125.                 $supplierservices->setProposalId($supplierCrtl->getProposalId());
  1126.                 $supplierservices->setDestinationId($supplierCrtl->getDestinoId());
  1128.                 $supplierservices->setServiceIdFather('0');
  1129.                 $supplierservices->setSupplierId(null);
  1130.                 $supplierservices->setActivityId($idactivity);
  1131.                 $supplierservices->setIsFather('0');
  1135.                 /* NAMEJO DE ADICIONALES EN EL DIA DEL EVENTO O DESPUES EL DIA DEL EVENTO */
  1136.                 $proposal_data = $em->getRepository(Proposal::class)->findOneById($supplierCrtl->getProposalId());
  1137.                 $dayEvent = $proposal_data->getDateEventStarAt()->format('Y-m-d');
  1138.                 $today = date('Y-m-d');
  1140.                 if( $today >= $dayEvent){
  1141.                     $additional = "Additional";
  1142.                 }else{
  1143.                     $additional = "Normal";
  1144.                 }
  1146.                 /* Obtengo usuario logueado */
  1147.                 $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1148.                 $user_id = $user_logueado->getId();
  1149.                 $supplierservices->setCreatedId($user_id);
  1150.                 $supplierservices->setUpdatedId($user_id);
  1152.                 $supplierservices->setDateInAt($proposal_data->getDateEventStarAt());
  1153.                 $supplierservices->setDateOutAt($proposal_data->getDateEventEndAt());
  1155.                 ///////colsulta de servicio
  1158.                 /* metemos accommodation *////////////////////////////////////////////////////////////////
  1159.                 $accommodations = $em->getRepository(SupplierAccommodation::class)->findBySupplierId($id);
  1160.                 //la consulta es al SupplierId porque lo estamos usando como id controlador para SupplierIdeaServicesControl
  1161.                 if(!empty($accommodations)){
  1162.                     foreach($accommodations as $accommodation){
  1163.                         $supplierservices->setServiceId($accommodation->getId());
  1164.                         $supplierservices->setServiceCatId('1');
  1165.                         $supplierservices->setServiceCatName('Accommodation');
  1167.                         $supplierservices->setName($accommodation->getName());
  1168.                         $supplierservices->setPrice($accommodation->getPrice());
  1169.                         //$supplierservices->setCurrency('Euro');
  1170.                         $supplierservices->setUnits('1');
  1171.                         $supplierservices->setCommission('0');
  1172.                         //$supplierservices->setOver('Accommodation');
  1173.                         $supplierservices->setIva('10');
  1174.                         $supplierservices->setPax('0');
  1175.                         //$supplierservices->setHour('');//null
  1176.                         //$supplierservices->setDateInAt('');
  1177.                         //$supplierservices->setDateOutAt('');
  1178.                         $supplierservices->setDirectPayment('0');
  1179.                         $supplierservices->setStatus('Pending');
  1180.                         $supplierservices->setStatusinternal($additional);
  1183.                         $em->persist($supplierservices);
  1184.                         $em->flush();
  1185.                         $em->clear();
  1187.                         //para pruebas
  1188.                         //$data_prueba[] = array(
  1189.                         //    'data' => $supplierservices
  1190.                         //);
  1191.                     }
  1192.                     //para pruebas
  1193.                     //d($data_prueba);
  1194.                     //exit();
  1195.                 }
  1198.                 /* metemos menu *////////////////////////////////////////////////////////////////
  1199.                 $menus = $em->getRepository(SupplierMenu::class)->findBySupplierId($id);
  1200.                 if(!empty($menus)){
  1201.                     foreach($menus as $menu){
  1202.                         $supplierservices->setServiceId($menu->getId());
  1203.                         $supplierservices->setServiceCatId('11');
  1204.                         $supplierservices->setServiceCatName('Menu');
  1206.                         $supplierservices->setName($menu->getTitle());
  1207.                         $supplierservices->setPrice($menu->getPrice());
  1208.                         //$supplierservices->setCurrency('Euro');
  1209.                         $supplierservices->setUnits('1');
  1210.                         $supplierservices->setCommission($menu->getCommission());
  1211.                         //$supplierservices->setOver('Accommodation');
  1212.                         $supplierservices->setIva($menu->getIva());
  1213.                         $supplierservices->setPax('0');
  1214.                         //$supplierservices->setHour('');//null
  1215.                         //$supplierservices->setDateInAt('');
  1216.                         //$supplierservices->setDateOutAt('');
  1217.                         $supplierservices->setDirectPayment('0');
  1218.                         $supplierservices->setStatus('Pending');
  1219.                         $supplierservices->setStatusinternal($additional);
  1222.                         $em->persist($supplierservices);
  1223.                         $em->flush();
  1224.                         $em->clear();
  1226.                         //para pruebas
  1227.                         //$data_prueba[] = array(
  1228.                         //    'data' => $supplierservices
  1229.                         //);
  1230.                     }
  1231.                     //para pruebas
  1232.                     //d($data_prueba);
  1233.                     //exit();
  1234.                 }
  1236.                 /* metemos lounge *////////////////////////////////////////////////////////////////
  1237.                 $lounges = $em->getRepository(SupplierLounge::class)->findBySupplierId($id);
  1238.                 if(!empty($lounges)){
  1239.                     foreach($lounges as $lounge){
  1240.                         $supplierservices->setServiceId($lounge->getId());
  1241.                         $supplierservices->setServiceCatId('10');
  1242.                         $supplierservices->setServiceCatName('Lounge');
  1244.                         $supplierservices->setName($lounge->getName());
  1245.                         $supplierservices->setPrice($lounge->getPrice());
  1246.                         //$supplierservices->setCurrency('Euro');
  1247.                         $supplierservices->setUnits('1');
  1248.                         $supplierservices->setCommission($lounge->getCommission());
  1249.                         //$supplierservices->setOver('Accommodation');
  1250.                         $supplierservices->setIva($lounge->getIva());
  1251.                         $supplierservices->setPax('0');
  1252.                         //$supplierservices->setHour('');//null
  1253.                         //$supplierservices->setDateInAt('');
  1254.                         //$supplierservices->setDateOutAt('');
  1255.                         $supplierservices->setDirectPayment('0');
  1256.                         $supplierservices->setStatus('Pending');
  1257.                         $supplierservices->setStatusinternal($additional);
  1260.                         $em->persist($supplierservices);
  1261.                         $em->flush();
  1262.                         $em->clear();
  1264.                         //para pruebas
  1265.                         //$data_prueba[] = array(
  1266.                         //    'data' => $supplierservices
  1267.                         //);
  1268.                     }
  1269.                     //para pruebas
  1270.                     //d($data_prueba);
  1271.                     //exit();
  1272.                 }
  1275.                 /* metemos activities *////////////////////////////////////////////////////////////////
  1276.                 $activitiess = $em->getRepository(SupplierActivities::class)->findBySupplierId($id);
  1277.                 if(!empty($activitiess)){
  1278.                     foreach($activitiess as $activities){
  1279.                         $supplierservices->setServiceId($activities->getId());
  1280.                         $supplierservices->setServiceCatId('2');
  1281.                         $supplierservices->setServiceCatName('Activities');
  1283.                         $supplierservices->setName($activities->getTitle());
  1284.                         $supplierservices->setPrice($activities->getPrice());
  1285.                         //$supplierservices->setCurrency('Euro');
  1286.                         $supplierservices->setUnits('1');
  1287.                         $supplierservices->setCommission($activities->getCommission());
  1288.                         //$supplierservices->setOver('Accommodation');
  1289.                         $supplierservices->setIva($activities->getIva());
  1290.                         $supplierservices->setPax('0');
  1291.                         //$supplierservices->setHour('');//null
  1292.                         //$supplierservices->setDateInAt('');
  1293.                         //$supplierservices->setDateOutAt('');
  1294.                         $supplierservices->setDirectPayment('0');
  1295.                         $supplierservices->setStatus('Pending');
  1296.                         $supplierservices->setStatusinternal($additional);
  1299.                         $em->persist($supplierservices);
  1300.                         $em->flush();
  1301.                         $em->clear();
  1303.                         //para pruebas
  1304.                         //$data_prueba[] = array(
  1305.                         //    'data' => $supplierservices
  1306.                         //);
  1307.                     }
  1308.                     //para pruebas
  1309.                     //d($data_prueba);
  1310.                     //exit();
  1311.                 }
  1314.                 /* metemos itineraries *////////////////////////////////////////////////////////////////
  1315.                 $itinerariess = $em->getRepository(SupplierItineraries::class)->findBySupplierId($id);
  1316.                 if(!empty($itinerariess)){
  1317.                     foreach($itinerariess as $itineraries){
  1318.                         $supplierservices->setServiceId($itineraries->getId());
  1319.                         $supplierservices->setServiceCatId('9');
  1320.                         $supplierservices->setServiceCatName('Itineraries');
  1322.                         $supplierservices->setName($itineraries->getTitle());
  1323.                         $supplierservices->setPrice('0');
  1324.                         //$supplierservices->setCurrency('Euro');
  1325.                         $supplierservices->setUnits('1');
  1326.                         $supplierservices->setCommission('0');
  1327.                         //$supplierservices->setOver('Accommodation');
  1328.                         $supplierservices->setIva('10');
  1329.                         $supplierservices->setPax('0');
  1330.                         //$supplierservices->setHour('');//null
  1331.                         //$supplierservices->setDateInAt('');
  1332.                         //$supplierservices->setDateOutAt('');
  1333.                         $supplierservices->setDirectPayment('0');
  1334.                         $supplierservices->setStatus('Pending');
  1335.                         $supplierservices->setStatusinternal($additional);
  1338.                         $em->persist($supplierservices);
  1339.                         $em->flush();
  1340.                         $em->clear();
  1342.                         //para pruebas
  1343.                         //$data_prueba[] = array(
  1344.                         //    'data' => $supplierservices
  1345.                         //);
  1346.                     }
  1347.                     //para pruebas
  1348.                     //d($data_prueba);
  1349.                     //exit();
  1350.                 }
  1353.                 /* metemos cruise *////////////////////////////////////////////////////////////////
  1354.                 $cruises = $em->getRepository(SupplierCruise::class)->findBySupplierId($id);
  1355.                 if(!empty($cruises)){
  1356.                     foreach($cruises as $cruise){
  1357.                         $supplierservices->setServiceId($cruise->getId());
  1358.                         $supplierservices->setServiceCatId('5');
  1359.                         $supplierservices->setServiceCatName('Cruise');
  1361.                         $supplierservices->setName($cruise->getTitle());
  1362.                         $supplierservices->setPrice($cruise->getPrice());
  1363.                         //$supplierservices->setCurrency('Euro');
  1364.                         $supplierservices->setUnits('1');
  1365.                         $supplierservices->setCommission($cruise->getCommission());
  1366.                         //$supplierservices->setOver('Accommodation');
  1367.                         $supplierservices->setIva($cruise->getIva());
  1368.                         $supplierservices->setPax('0');
  1369.                         //$supplierservices->setHour('');//null
  1370.                         //$supplierservices->setDateInAt('');
  1371.                         //$supplierservices->setDateOutAt('');
  1372.                         $supplierservices->setDirectPayment('0');
  1373.                         $supplierservices->setStatus('Pending');
  1374.                         $supplierservices->setStatusinternal($additional);
  1377.                         $em->persist($supplierservices);
  1378.                         $em->flush();
  1379.                         $em->clear();
  1381.                         //para pruebas
  1382.                         //$data_prueba[] = array(
  1383.                         //    'data' => $supplierservices
  1384.                         //);
  1385.                     }
  1386.                     //para pruebas
  1387.                     //d($data_prueba);
  1388.                     //exit();
  1389.                 }
  1392.                 /* metemos transport *////////////////////////////////////////////////////////////////
  1393.                 $transports = $em->getRepository(SupplierTransport::class)->findBySupplierId($id);
  1394.                 if(!empty($transports)){
  1395.                     foreach($transports as $transport){
  1396.                         $supplierservices->setServiceId($transport->getId());
  1397.                         $supplierservices->setServiceCatId('13');
  1398.                         $supplierservices->setServiceCatName('Transport');
  1400.                         $supplierservices->setName($transport->getName());
  1401.                         $supplierservices->setPrice($transport->getPrice());
  1402.                         //$supplierservices->setCurrency('Euro');
  1403.                         $supplierservices->setUnits('1');
  1404.                         $supplierservices->setCommission($transport->getCommission());
  1405.                         //$supplierservices->setOver('Accommodation');
  1406.                         $supplierservices->setIva($transport->getIva());
  1407.                         $supplierservices->setPax('0');
  1408.                         //$supplierservices->setHour('');//null
  1409.                         //$supplierservices->setDateInAt('');
  1410.                         //$supplierservices->setDateOutAt('');
  1411.                         $supplierservices->setDirectPayment('0');
  1412.                         $supplierservices->setStatus('Pending');
  1413.                         $supplierservices->setStatusinternal($additional);
  1416.                         $em->persist($supplierservices);
  1417.                         $em->flush();
  1418.                         $em->clear();
  1420.                         //para pruebas
  1421.                         //$data_prueba[] = array(
  1422.                         //    'data' => $supplierservices
  1423.                         //);
  1424.                     }
  1425.                     //para pruebas
  1426.                     //d($data_prueba);
  1427.                     //exit();
  1428.                 }
  1432.                 /* metemos av *////////////////////////////////////////////////////////////////
  1433.                 $avs = $em->getRepository(SupplierAv::class)->findBySupplierId($id);
  1434.                 if(!empty($avs)){
  1435.                     foreach($avs as $av){
  1436.                         $supplierservices->setServiceId($av->getId());
  1437.                         $supplierservices->setServiceCatId('3');
  1438.                         $supplierservices->setServiceCatName('Av');
  1440.                         $supplierservices->setName($av->getName());
  1441.                         $supplierservices->setPrice($av->getPrice());
  1442.                         //$supplierservices->setCurrency('Euro');
  1443.                         $supplierservices->setUnits('1');
  1444.                         $supplierservices->setCommission($av->getCommission());
  1445.                         //$supplierservices->setOver('Accommodation');
  1446.                         $supplierservices->setIva($av->getIva());
  1447.                         $supplierservices->setPax('0');
  1448.                         //$supplierservices->setHour('');//null
  1449.                         //$supplierservices->setDateInAt('');
  1450.                         //$supplierservices->setDateOutAt('');
  1451.                         $supplierservices->setDirectPayment('0');
  1452.                         $supplierservices->setStatus('Pending');
  1453.                         $supplierservices->setStatusinternal($additional);
  1456.                         $em->persist($supplierservices);
  1457.                         $em->flush();
  1458.                         $em->clear();
  1460.                         //para pruebas
  1461.                         //$data_prueba[] = array(
  1462.                         //    'data' => $supplierservices
  1463.                         //);
  1464.                     }
  1465.                     //para pruebas
  1466.                     //d($data_prueba);
  1467.                     //exit();
  1468.                 }
  1472.                 /* metemos creative *////////////////////////////////////////////////////////////////
  1473.                 $creatives = $em->getRepository(SupplierCreative::class)->findBySupplierId($id);
  1474.                 if(!empty($creatives)){
  1475.                     foreach($creatives as $creative){
  1476.                         $supplierservices->setServiceId($creative->getId());
  1477.                         $supplierservices->setServiceCatId('4');
  1478.                         $supplierservices->setServiceCatName('Creative');
  1480.                         $supplierservices->setName($creative->getTitle());
  1481.                         $supplierservices->setPrice('0');
  1482.                         //$supplierservices->setCurrency('Euro');
  1483.                         $supplierservices->setUnits('1');
  1484.                         $supplierservices->setCommission('0');
  1485.                         //$supplierservices->setOver('Accommodation');
  1486.                         $supplierservices->setIva('21');
  1487.                         $supplierservices->setPax('0');
  1488.                         //$supplierservices->setHour('');//null
  1489.                         //$supplierservices->setDateInAt('');
  1490.                         //$supplierservices->setDateOutAt('');
  1491.                         $supplierservices->setDirectPayment('0');
  1492.                         $supplierservices->setStatus('Pending');
  1493.                         $supplierservices->setStatusinternal($additional);
  1496.                         $em->persist($supplierservices);
  1497.                         $em->flush();
  1498.                         $em->clear();
  1500.                         //para pruebas
  1501.                         //$data_prueba[] = array(
  1502.                         //    'data' => $supplierservices
  1503.                         //);
  1504.                     }
  1505.                     //para pruebas
  1506.                     //d($data_prueba);
  1507.                     //exit();
  1508.                 }
  1511.                 /* metemos gift *////////////////////////////////////////////////////////////////
  1512.                 $gifts = $em->getRepository(SupplierGifts::class)->findBySupplierId($id);
  1513.                 if(!empty($gifts)){
  1514.                     foreach($gifts as $gift){
  1515.                         $supplierservices->setServiceId($gift->getId());
  1516.                         $supplierservices->setServiceCatId('7');
  1517.                         $supplierservices->setServiceCatName('Gifts');
  1519.                         $supplierservices->setName($gift->getName());
  1520.                         $supplierservices->setPrice($gift->getPrice());
  1521.                         //$supplierservices->setCurrency('Euro');
  1522.                         $supplierservices->setUnits('1');
  1523.                         $supplierservices->setCommission($gift->getCommission());
  1524.                         //$supplierservices->setOver('Accommodation');
  1525.                         $supplierservices->setIva($gift->getIva());
  1526.                         $supplierservices->setPax('0');
  1527.                         //$supplierservices->setHour('');//null
  1528.                         //$supplierservices->setDateInAt('');
  1529.                         //$supplierservices->setDateOutAt('');
  1530.                         $supplierservices->setDirectPayment('0');
  1531.                         $supplierservices->setStatus('Pending');
  1532.                         $supplierservices->setStatusinternal($additional);
  1535.                         $em->persist($supplierservices);
  1536.                         $em->flush();
  1537.                         $em->clear();
  1539.                         //para pruebas
  1540.                         //$data_prueba[] = array(
  1541.                         //    'data' => $supplierservices
  1542.                         //);
  1543.                     }
  1544.                     //para pruebas
  1545.                     //d($data_prueba);
  1546.                     //exit();
  1547.                 }
  1550.                 /* metemos entertainment *////////////////////////////////////////////////////////////////
  1551.                 $entertainments = $em->getRepository(SupplierEntertainment::class)->findBySupplierId($id);
  1552.                 if(!empty($entertainments)){
  1553.                     foreach($entertainments as $entertainment){
  1554.                         $supplierservices->setServiceId($entertainment->getId());
  1555.                         $supplierservices->setServiceCatId('6');
  1556.                         $supplierservices->setServiceCatName('Entertainment');
  1558.                         $supplierservices->setName($entertainment->getName());
  1559.                         $supplierservices->setPrice($entertainment->getPrice());
  1560.                         //$supplierservices->setCurrency('Euro');
  1561.                         $supplierservices->setUnits('1');
  1562.                         $supplierservices->setCommission($entertainment->getCommission());
  1563.                         //$supplierservices->setOver('Accommodation');
  1564.                         $supplierservices->setIva($entertainment->getIva());
  1565.                         $supplierservices->setPax('0');
  1566.                         //$supplierservices->setHour('');//null
  1567.                         //$supplierservices->setDateInAt('');
  1568.                         //$supplierservices->setDateOutAt('');
  1569.                         $supplierservices->setDirectPayment('0');
  1570.                         $supplierservices->setStatus('Pending');
  1571.                         $supplierservices->setStatusinternal($additional);
  1574.                         $em->persist($supplierservices);
  1575.                         $em->flush();
  1576.                         $em->clear();
  1578.                         //para pruebas
  1579.                         //$data_prueba[] = array(
  1580.                         //    'data' => $supplierservices
  1581.                         //);
  1582.                     }
  1583.                     //para pruebas
  1584.                     //d($data_prueba);
  1585.                     //exit();
  1586.                 }
  1589.                 /* metemos guide *////////////////////////////////////////////////////////////////
  1590.                 $guides = $em->getRepository(SupplierGuide::class)->findBySupplierId($id);
  1591.                 if(!empty($guides)){
  1592.                     foreach($guides as $guide){
  1593.                         $supplierservices->setServiceId($guide->getId());
  1594.                         $supplierservices->setServiceCatId('8');
  1595.                         $supplierservices->setServiceCatName('Guide');
  1597.                         $supplierservices->setName($guide->getName());
  1598.                         $supplierservices->setPrice($guide->getPrice());
  1599.                         //$supplierservices->setCurrency('Euro');
  1600.                         $supplierservices->setUnits('1');
  1601.                         $supplierservices->setCommission($guide->getCommission());
  1602.                         //$supplierservices->setOver('Accommodation');
  1603.                         $supplierservices->setIva($guide->getIva());
  1604.                         $supplierservices->setPax('0');
  1605.                         //$supplierservices->setHour('');//null
  1606.                         //$supplierservices->setDateInAt('');
  1607.                         //$supplierservices->setDateOutAt('');
  1608.                         $supplierservices->setDirectPayment('0');
  1609.                         $supplierservices->setStatus('Pending');
  1610.                         $supplierservices->setStatusinternal($additional);
  1613.                         $em->persist($supplierservices);
  1614.                         $em->flush();
  1615.                         $em->clear();
  1617.                         //para pruebas
  1618.                         //$data_prueba[] = array(
  1619.                         //    'data' => $supplierservices
  1620.                         //);
  1621.                     }
  1622.                     //para pruebas
  1623.                     //d($data_prueba);
  1624.                     //exit();
  1625.                 }
  1629.                 /* metemos others *////////////////////////////////////////////////////////////////
  1630.                 $otherss = $em->getRepository(SupplierOthers::class)->findBySupplierId($id);
  1631.                 if(!empty($otherss)){
  1632.                     foreach($otherss as $others){
  1633.                         $supplierservices->setServiceId($others->getId());
  1634.                         $supplierservices->setServiceCatId('12');
  1635.                         $supplierservices->setServiceCatName('Others');
  1637.                         $supplierservices->setName($others->getName());
  1638.                         $supplierservices->setPrice($others->getPrice());
  1639.                         //$supplierservices->setCurrency('Euro');
  1640.                         $supplierservices->setUnits('1');
  1641.                         $supplierservices->setCommission($others->getCommission());
  1642.                         //$supplierservices->setOver('Accommodation');
  1643.                         $supplierservices->setIva($others->getIva());
  1644.                         $supplierservices->setPax('0');
  1645.                         //$supplierservices->setHour('');//null
  1646.                         //$supplierservices->setDateInAt('');
  1647.                         //$supplierservices->setDateOutAt('');
  1648.                         $supplierservices->setDirectPayment('0');
  1649.                         $supplierservices->setStatus('Pending');
  1650.                         $supplierservices->setStatusinternal($additional);
  1653.                         $em->persist($supplierservices);
  1654.                         $em->flush();
  1655.                         $em->clear();
  1657.                         //para pruebas
  1658.                         //$data_prueba[] = array(
  1659.                         //    'data' => $supplierservices
  1660.                         //);
  1661.                     }
  1662.                     //para pruebas
  1663.                     //d($data_prueba);
  1664.                     //exit();
  1665.                 }
  1666.                 /* metemos technology *////////////////////////////////////////////////////////////////
  1667.                 $technologys = $em->getRepository(SupplierTechnology::class)->findBySupplierId($id);
  1668.                 if(!empty($technologys)){
  1669.                     foreach($technologys as $technology){
  1670.                         $supplierservices->setServiceId($technology->getId());
  1671.                         $supplierservices->setServiceCatId('14');
  1672.                         $supplierservices->setServiceCatName('Technology');
  1674.                         $supplierservices->setName($technology->getTitle());
  1675.                         $supplierservices->setPrice($technology->getPrice());
  1676.                         //$supplierservices->setCurrency('Euro');
  1677.                         $supplierservices->setUnits('1');
  1678.                         $supplierservices->setCommission($technology->getCommission());
  1679.                         //$supplierservices->setOver('Accommodation');
  1680.                         $supplierservices->setIva($technology->getIva());
  1681.                         $supplierservices->setPax('0');
  1682.                         //$supplierservices->setHour('');//null
  1683.                         //$supplierservices->setDateInAt('');
  1684.                         //$supplierservices->setDateOutAt('');
  1685.                         $supplierservices->setDirectPayment('0');
  1686.                         $supplierservices->setStatus('Pending');
  1687.                         $supplierservices->setStatusinternal($additional);
  1690.                         $em->persist($supplierservices);
  1691.                         $em->flush();
  1692.                         $em->clear();
  1694.                         //para pruebas
  1695.                         //$data_prueba[] = array(
  1696.                         //    'data' => $supplierservices
  1697.                         //);
  1698.                     }
  1699.                     //para pruebas
  1700.                     //d($data_prueba);
  1701.                     //exit();
  1702.                 }
  1704.                 /* metemos Assistant *////////////////////////////////////////////////////////////////
  1705.                 $assistants = $em->getRepository(SupplierServicesAssistant::class)->findBySupplierId($id);
  1706.                 if(!empty($assistants)){
  1707.                     foreach($assistants as $assistant){
  1708.                         $supplierservices->setServiceId($assistant->getId());
  1709.                         $supplierservices->setServiceCatId('15');
  1710.                         $supplierservices->setServiceCatName('Assistant');
  1712.                         $supplierservices->setName($assistant->getName());
  1713.                         $supplierservices->setPrice($assistant->getPrice());
  1714.                         //$supplierservices->setCurrency('Euro');
  1715.                         $supplierservices->setUnits('1');
  1716.                         $supplierservices->setCommission($assistant->getCommission());
  1717.                         //$supplierservices->setOver('Accommodation');
  1718.                         $supplierservices->setIva($assistant->getIva());
  1719.                         $supplierservices->setPax('0');
  1720.                         //$supplierservices->setHour('');//null
  1721.                         //$supplierservices->setDateInAt('');
  1722.                         //$supplierservices->setDateOutAt('');
  1723.                         $supplierservices->setDirectPayment('0');
  1724.                         $supplierservices->setStatus('Pending');
  1725.                         $supplierservices->setStatusinternal($additional);
  1728.                         $em->persist($supplierservices);
  1729.                         $em->flush();
  1730.                         $em->clear();
  1732.                         //para pruebas
  1733.                         //$data_prueba[] = array(
  1734.                         //    'data' => $supplierservices
  1735.                         //);
  1736.                     }
  1737.                     //para pruebas
  1738.                     //d($data_prueba);
  1739.                     //exit();
  1740.                 }
  1743.                 /* FIN METEMOS EL CONTENIDO DE LA IDEA */
  1746.                 // Control para el sistema de revision
  1748.                 $actId = $request->request->get('proposalsuppliercontrol')['activityId'];
  1749.                 $prpId = $request->request->get('proposalsuppliercontrol')['proposalId'];
  1750.                 $activities = $em->getRepository(Activities::class)->findOneById($actId);
  1752.                 $revision1 = new RevisionCarga();
  1753.                 $revision2 = new RevisionCarga();
  1754.                 $revision3 = new RevisionCarga();
  1755.                 $revision1->setIdType($activities->getId());
  1756.                 $revision2->setIdType($activities->getId());
  1757.                 $revision3->setIdType($activities->getId());
  1758.                 $revision1->setName($activities->getName());
  1759.                 $revision2->setName($activities->getName());
  1760.                 $revision3->setName($activities->getName());
  1762.                 // Titulo, Destino y observacion
  1763.                 $revision1->setType('ACTIVIDAD (Título) - Agregada al Proposal:'.$prpId);
  1764.                 $revision1->setLink('activities/edit/'.$activities->getId());
  1765.                 $revision1->setStatus(false);
  1766.                 $em->persist($revision1);
  1767.                 $em->flush();
  1769.                 // Descripcion
  1770.                 $revision2->setType('ACTIVIDAD (Descripción) - Agregada al Proposal:'.$prpId);
  1772.                 // Buscamos el ID de la descripcion
  1773.                 $idact = $activities->getId();
  1774.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByActivityId($idact);
  1775.                 $idctrl = $controlgeneral->getId();
  1776.                 $supdesc = $em->getRepository(SupplierDescription::class)->findOneBySupplierId($idctrl);
  1777.                 $id = $supdesc->getId();
  1779.                 // FIN Buscamos el ID de la descripcion
  1781.                 $revision2->setLink('activities/description/edit/'.$id);
  1782.                 $revision2->setStatus(false);
  1783.                 $em->persist($revision2);
  1784.                 $em->flush();
  1786.                 // Galería
  1787.                 $revision3->setType('ACTIVIDAD (Galería) - Agregada al Proposal:'.$prpId);
  1788.                 $revision3->setLink('activities/gallery/list/'.$activities->getId());
  1789.                 $revision3->setStatus(false);
  1790.                 $em->persist($revision3);
  1791.                 $em->flush();
  1792.                 // FIN Control para el sistema de revision
  1794.                 $event = 'The Idea Destination Proposal has been created.';
  1795.                 $successMessage = $this->translator->trans($event);
  1796.                 $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  1799.             }else{
  1800.                 $errorMessage = $this->translator->trans('Error, some fields are empty');
  1801.                 $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  1802.             }
  1803.         }else{
  1804.             $errorMessage = $this->translator->trans('The proposal already has this Idea included');
  1805.             $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  1806.         }
  1808.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  1809.             'id' => $control->getControlDestinationId(),
  1810.             '_fragment' => 's'.$control->getId()
  1811.         ));
  1813.     }
  1816.     /* CREAR DESDE UNA IDEA */
  1817.     private function createDestinationProposalIdeasCreateForm(ProposalSupplierControl $entity)
  1818.     {
  1819.         $form = $this->createForm(ProposalIdeasControlType::class, $entity, array(
  1820.             'action' => $this->generateUrl('proposal_destination_ideas_create'),
  1821.             'method' => 'POST'
  1822.         ));
  1823.         return $form;
  1824.     }
  1826.     /* CREAR DESDE UNA IDEA */
  1827.     /**
  1828.      * @Route("/proposal/destination/services/createIdea", name="proposal_destination_ideas_create")
  1829.      */
  1830.     public function createProposalIdeaDestinationAction(Request $request)
  1831.     {
  1832.         $control = new ProposalSupplierControl();
  1833.         $form = $this->createDestinationProposalIdeasCreateForm($control);
  1834.         $form->handleRequest($request);
  1836.         $supplier_proposal = $form->get('ideaId')->getData();
  1837.         if(!is_null($supplier_proposal)){
  1838.             $control->setIdeaId($supplier_proposal->getId());
  1839.         }
  1840.         $em = $this->getDoctrine()->getManager();
  1841.         $control_verifico = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1842.             array(
  1843.                 'controlDestinationId' => $form->get('controlDestinationId')->getData(),
  1844.                 'proposalId' => $form->get('proposalId')->getData(),
  1845.                 'destinoId' => $form->get('destinoId')->getData(),
  1846.                 'ideaId' => $supplier_proposal->getId(),
  1847.             )
  1848.         );
  1849. //        $proposal = $em->getRepository(Proposal::class)->findOneById($form->get('proposalId')->getData());
  1851.         if(empty($control_verifico)){
  1853.             if($form->isValid())
  1854.             {
  1855.                 $control->setStatus('Pending');
  1856.                 $em->persist($control);
  1857.                 $em->flush();
  1859.                 /* METEMOS EL CONTENIDO DE LA IDEA */
  1860.                 $idcontrol = $control->getId();
  1861.                 $ididea = $control->getIdeaId();
  1863.                 /*CONTROL GENERAL*/
  1864.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByIdeaId($ididea);
  1865.                 $id = $controlgeneral->getId();
  1867.                 $supplierservices= new ProposalSupplierServices();
  1868.                 $supplierservices->setControlId($idcontrol);
  1870.                 $supplierCrtl = $em->getRepository(ProposalSupplierControl::class)->findOneById($idcontrol);
  1871.                 $supplierservices->setProposalId($supplierCrtl->getProposalId());
  1872.                 $supplierservices->setDestinationId($supplierCrtl->getDestinoId());
  1874.                 $supplierservices->setServiceIdFather('0');
  1875.                 $supplierservices->setSupplierId(null);
  1876.                 $supplierservices->setIdeaId($ididea);
  1877.                 $supplierservices->setIsFather('0');
  1881.                 /* NAMEJO DE ADICIONALES EN EL DIA DEL EVENTO O DESPUES EL DIA DEL EVENTO */
  1882.                 $proposal_data = $em->getRepository(Proposal::class)->findOneById($supplierCrtl->getProposalId());
  1883.                 $dayEvent = $proposal_data->getDateEventStarAt()->format('Y-m-d');
  1884.                 $today = date('Y-m-d');
  1886.                 if( $today >= $dayEvent){
  1887.                     $additional = "Additional";
  1888.                 }else{
  1889.                     $additional = "Normal";
  1890.                 }
  1892.                 /* Obtengo usuario logueado */
  1893.                 $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1894.                 $user_id = $user_logueado->getId();
  1895.                 $supplierservices->setCreatedId($user_id);
  1896.                 $supplierservices->setUpdatedId($user_id);
  1898.                 $supplierservices->setDateInAt($proposal_data->getDateEventStarAt());
  1899.                 $supplierservices->setDateOutAt($proposal_data->getDateEventEndAt());
  1901.                 ///////colsulta de servicio
  1904.                 /* metemos accommodation *////////////////////////////////////////////////////////////////
  1905.                 $accommodations = $em->getRepository(SupplierAccommodation::class)->findBySupplierId($id);
  1906.                 //la consulta es al SupplierId porque lo estamos usando como id controlador para SupplierIdeaServicesControl
  1907.                 if(!empty($accommodations)){
  1908.                     foreach($accommodations as $accommodation){
  1909.                         $supplierservices->setServiceId($accommodation->getId());
  1910.                         $supplierservices->setServiceCatId('1');
  1911.                         $supplierservices->setServiceCatName('Accommodation');
  1913.                         $supplierservices->setName($accommodation->getName());
  1914.                         $supplierservices->setPrice($accommodation->getPrice());
  1915.                         //$supplierservices->setCurrency('Euro');
  1916.                         $supplierservices->setUnits('1');
  1917.                         $supplierservices->setCommission('0');
  1918.                         //$supplierservices->setOver('Accommodation');
  1919.                         $supplierservices->setIva('10');
  1920.                         $supplierservices->setPax('0');
  1921.                         //$supplierservices->setHour('');//null
  1922.                         //$supplierservices->setDateInAt('');
  1923.                         //$supplierservices->setDateOutAt('');
  1924.                         $supplierservices->setDirectPayment('0');
  1925.                         $supplierservices->setStatus('Pending');
  1926.                         $supplierservices->setStatusinternal($additional);
  1929.                         $em->persist($supplierservices);
  1930.                         $em->flush();
  1931.                         $em->clear();
  1933.                         //para pruebas
  1934.                         //$data_prueba[] = array(
  1935.                         //    'data' => $supplierservices
  1936.                         //);
  1937.                     }
  1938.                     //para pruebas
  1939.                     //d($data_prueba);
  1940.                     //exit();
  1941.                 }
  1944.                 /* metemos menu *////////////////////////////////////////////////////////////////
  1945.                 $menus = $em->getRepository(SupplierMenu::class)->findBySupplierId($id);
  1946.                 if(!empty($menus)){
  1947.                     foreach($menus as $menu){
  1948.                         $supplierservices->setServiceId($menu->getId());
  1949.                         $supplierservices->setServiceCatId('11');
  1950.                         $supplierservices->setServiceCatName('Menu');
  1952.                         $supplierservices->setName($menu->getTitle());
  1953.                         $supplierservices->setPrice($menu->getPrice());
  1954.                         //$supplierservices->setCurrency('Euro');
  1955.                         $supplierservices->setUnits('1');
  1956.                         $supplierservices->setCommission($menu->getCommission());
  1957.                         //$supplierservices->setOver('Accommodation');
  1958.                         $supplierservices->setIva($menu->getIva());
  1959.                         $supplierservices->setPax('0');
  1960.                         //$supplierservices->setHour('');//null
  1961.                         //$supplierservices->setDateInAt('');
  1962.                         //$supplierservices->setDateOutAt('');
  1963.                         $supplierservices->setDirectPayment('0');
  1964.                         $supplierservices->setStatus('Pending');
  1965.                         $supplierservices->setStatusinternal($additional);
  1968.                         $em->persist($supplierservices);
  1969.                         $em->flush();
  1970.                         $em->clear();
  1972.                         //para pruebas
  1973.                         //$data_prueba[] = array(
  1974.                         //    'data' => $supplierservices
  1975.                         //);
  1976.                     }
  1977.                     //para pruebas
  1978.                     //d($data_prueba);
  1979.                     //exit();
  1980.                 }
  1982.                 /* metemos lounge *////////////////////////////////////////////////////////////////
  1983.                 $lounges = $em->getRepository(SupplierLounge::class)->findBySupplierId($id);
  1984.                 if(!empty($lounges)){
  1985.                     foreach($lounges as $lounge){
  1986.                         $supplierservices->setServiceId($lounge->getId());
  1987.                         $supplierservices->setServiceCatId('10');
  1988.                         $supplierservices->setServiceCatName('Lounge');
  1990.                         $supplierservices->setName($lounge->getName());
  1991.                         $supplierservices->setPrice($lounge->getPrice());
  1992.                         //$supplierservices->setCurrency('Euro');
  1993.                         $supplierservices->setUnits('1');
  1994.                         $supplierservices->setCommission($lounge->getCommission());
  1995.                         //$supplierservices->setOver('Accommodation');
  1996.                         $supplierservices->setIva($lounge->getIva());
  1997.                         $supplierservices->setPax('0');
  1998.                         //$supplierservices->setHour('');//null
  1999.                         //$supplierservices->setDateInAt('');
  2000.                         //$supplierservices->setDateOutAt('');
  2001.                         $supplierservices->setDirectPayment('0');
  2002.                         $supplierservices->setStatus('Pending');
  2003.                         $supplierservices->setStatusinternal($additional);
  2006.                         $em->persist($supplierservices);
  2007.                         $em->flush();
  2008.                         $em->clear();
  2010.                         //para pruebas
  2011.                         //$data_prueba[] = array(
  2012.                         //    'data' => $supplierservices
  2013.                         //);
  2014.                     }
  2015.                     //para pruebas
  2016.                     //d($data_prueba);
  2017.                     //exit();
  2018.                 }
  2021.                 /* metemos activities *////////////////////////////////////////////////////////////////
  2022.                 $activitiess = $em->getRepository(SupplierActivities::class)->findBySupplierId($id);
  2023.                 if(!empty($activitiess)){
  2024.                     foreach($activitiess as $activities){
  2025.                         $supplierservices->setServiceId($activities->getId());
  2026.                         $supplierservices->setServiceCatId('2');
  2027.                         $supplierservices->setServiceCatName('Activities');
  2029.                         $supplierservices->setName($activities->getTitle());
  2030.                         $supplierservices->setPrice($activities->getPrice());
  2031.                         //$supplierservices->setCurrency('Euro');
  2032.                         $supplierservices->setUnits('1');
  2033.                         $supplierservices->setCommission($activities->getCommission());
  2034.                         //$supplierservices->setOver('Accommodation');
  2035.                         $supplierservices->setIva($activities->getIva());
  2036.                         $supplierservices->setPax('0');
  2037.                         //$supplierservices->setHour('');//null
  2038.                         //$supplierservices->setDateInAt('');
  2039.                         //$supplierservices->setDateOutAt('');
  2040.                         $supplierservices->setDirectPayment('0');
  2041.                         $supplierservices->setStatus('Pending');
  2042.                         $supplierservices->setStatusinternal($additional);
  2045.                         $em->persist($supplierservices);
  2046.                         $em->flush();
  2047.                         $em->clear();
  2049.                         //para pruebas
  2050.                         //$data_prueba[] = array(
  2051.                         //    'data' => $supplierservices
  2052.                         //);
  2053.                     }
  2054.                     //para pruebas
  2055.                     //d($data_prueba);
  2056.                     //exit();
  2057.                 }
  2060.                 /* metemos itineraries *////////////////////////////////////////////////////////////////
  2061.                 $itinerariess = $em->getRepository(SupplierItineraries::class)->findBySupplierId($id);
  2062.                 if(!empty($itinerariess)){
  2063.                     foreach($itinerariess as $itineraries){
  2064.                         $supplierservices->setServiceId($itineraries->getId());
  2065.                         $supplierservices->setServiceCatId('9');
  2066.                         $supplierservices->setServiceCatName('Itineraries');
  2068.                         $supplierservices->setName($itineraries->getTitle());
  2069.                         $supplierservices->setPrice('0');
  2070.                         //$supplierservices->setCurrency('Euro');
  2071.                         $supplierservices->setUnits('1');
  2072.                         $supplierservices->setCommission('0');
  2073.                         //$supplierservices->setOver('Accommodation');
  2074.                         $supplierservices->setIva('10');
  2075.                         $supplierservices->setPax('0');
  2076.                         //$supplierservices->setHour('');//null
  2077.                         //$supplierservices->setDateInAt('');
  2078.                         //$supplierservices->setDateOutAt('');
  2079.                         $supplierservices->setDirectPayment('0');
  2080.                         $supplierservices->setStatus('Pending');
  2081.                         $supplierservices->setStatusinternal($additional);
  2084.                         $em->persist($supplierservices);
  2085.                         $em->flush();
  2086.                         $em->clear();
  2088.                         //para pruebas
  2089.                         //$data_prueba[] = array(
  2090.                         //    'data' => $supplierservices
  2091.                         //);
  2092.                     }
  2093.                     //para pruebas
  2094.                     //d($data_prueba);
  2095.                     //exit();
  2096.                 }
  2099.                 /* metemos cruise *////////////////////////////////////////////////////////////////
  2100.                 $cruises = $em->getRepository(SupplierCruise::class)->findBySupplierId($id);
  2101.                 if(!empty($cruises)){
  2102.                     foreach($cruises as $cruise){
  2103.                         $supplierservices->setServiceId($cruise->getId());
  2104.                         $supplierservices->setServiceCatId('5');
  2105.                         $supplierservices->setServiceCatName('Cruise');
  2107.                         $supplierservices->setName($cruise->getTitle());
  2108.                         $supplierservices->setPrice($cruise->getPrice());
  2109.                         //$supplierservices->setCurrency('Euro');
  2110.                         $supplierservices->setUnits('1');
  2111.                         $supplierservices->setCommission($cruise->getCommission());
  2112.                         //$supplierservices->setOver('Accommodation');
  2113.                         $supplierservices->setIva($cruise->getIva());
  2114.                         $supplierservices->setPax('0');
  2115.                         //$supplierservices->setHour('');//null
  2116.                         //$supplierservices->setDateInAt('');
  2117.                         //$supplierservices->setDateOutAt('');
  2118.                         $supplierservices->setDirectPayment('0');
  2119.                         $supplierservices->setStatus('Pending');
  2120.                         $supplierservices->setStatusinternal($additional);
  2123.                         $em->persist($supplierservices);
  2124.                         $em->flush();
  2125.                         $em->clear();
  2127.                         //para pruebas
  2128.                         //$data_prueba[] = array(
  2129.                         //    'data' => $supplierservices
  2130.                         //);
  2131.                     }
  2132.                     //para pruebas
  2133.                     //d($data_prueba);
  2134.                     //exit();
  2135.                 }
  2138.                 /* metemos transport *////////////////////////////////////////////////////////////////
  2139.                 $transports = $em->getRepository(SupplierTransport::class)->findBySupplierId($id);
  2140.                 if(!empty($transports)){
  2141.                     foreach($transports as $transport){
  2142.                         $supplierservices->setServiceId($transport->getId());
  2143.                         $supplierservices->setServiceCatId('13');
  2144.                         $supplierservices->setServiceCatName('Transport');
  2146.                         $supplierservices->setName($transport->getName());
  2147.                         $supplierservices->setPrice($transport->getPrice());
  2148.                         //$supplierservices->setCurrency('Euro');
  2149.                         $supplierservices->setUnits('1');
  2150.                         $supplierservices->setCommission($transport->getCommission());
  2151.                         //$supplierservices->setOver('Accommodation');
  2152.                         $supplierservices->setIva($transport->getIva());
  2153.                         $supplierservices->setPax('0');
  2154.                         //$supplierservices->setHour('');//null
  2155.                         //$supplierservices->setDateInAt('');
  2156.                         //$supplierservices->setDateOutAt('');
  2157.                         $supplierservices->setDirectPayment('0');
  2158.                         $supplierservices->setStatus('Pending');
  2159.                         $supplierservices->setStatusinternal($additional);
  2162.                         $em->persist($supplierservices);
  2163.                         $em->flush();
  2164.                         $em->clear();
  2166.                         //para pruebas
  2167.                         //$data_prueba[] = array(
  2168.                         //    'data' => $supplierservices
  2169.                         //);
  2170.                     }
  2171.                     //para pruebas
  2172.                     //d($data_prueba);
  2173.                     //exit();
  2174.                 }
  2178.                 /* metemos av *////////////////////////////////////////////////////////////////
  2179.                 $avs = $em->getRepository(SupplierAv::class)->findBySupplierId($id);
  2180.                 if(!empty($avs)){
  2181.                     foreach($avs as $av){
  2182.                         $supplierservices->setServiceId($av->getId());
  2183.                         $supplierservices->setServiceCatId('3');
  2184.                         $supplierservices->setServiceCatName('Av');
  2186.                         $supplierservices->setName($av->getName());
  2187.                         $supplierservices->setPrice($av->getPrice());
  2188.                         //$supplierservices->setCurrency('Euro');
  2189.                         $supplierservices->setUnits('1');
  2190.                         $supplierservices->setCommission($av->getCommission());
  2191.                         //$supplierservices->setOver('Accommodation');
  2192.                         $supplierservices->setIva($av->getIva());
  2193.                         $supplierservices->setPax('0');
  2194.                         //$supplierservices->setHour('');//null
  2195.                         //$supplierservices->setDateInAt('');
  2196.                         //$supplierservices->setDateOutAt('');
  2197.                         $supplierservices->setDirectPayment('0');
  2198.                         $supplierservices->setStatus('Pending');
  2199.                         $supplierservices->setStatusinternal($additional);
  2202.                         $em->persist($supplierservices);
  2203.                         $em->flush();
  2204.                         $em->clear();
  2206.                         //para pruebas
  2207.                         //$data_prueba[] = array(
  2208.                         //    'data' => $supplierservices
  2209.                         //);
  2210.                     }
  2211.                     //para pruebas
  2212.                     //d($data_prueba);
  2213.                     //exit();
  2214.                 }
  2218.                 /* metemos creative *////////////////////////////////////////////////////////////////
  2219.                 $creatives = $em->getRepository(SupplierCreative::class)->findBySupplierId($id);
  2220.                 if(!empty($creatives)){
  2221.                     foreach($creatives as $creative){
  2222.                         $supplierservices->setServiceId($creative->getId());
  2223.                         $supplierservices->setServiceCatId('4');
  2224.                         $supplierservices->setServiceCatName('Creative');
  2226.                         $supplierservices->setName($creative->getTitle());
  2227.                         $supplierservices->setPrice('0');
  2228.                         //$supplierservices->setCurrency('Euro');
  2229.                         $supplierservices->setUnits('1');
  2230.                         $supplierservices->setCommission('0');
  2231.                         //$supplierservices->setOver('Accommodation');
  2232.                         $supplierservices->setIva('21');
  2233.                         $supplierservices->setPax('0');
  2234.                         //$supplierservices->setHour('');//null
  2235.                         //$supplierservices->setDateInAt('');
  2236.                         //$supplierservices->setDateOutAt('');
  2237.                         $supplierservices->setDirectPayment('0');
  2238.                         $supplierservices->setStatus('Pending');
  2239.                         $supplierservices->setStatusinternal($additional);
  2242.                         $em->persist($supplierservices);
  2243.                         $em->flush();
  2244.                         $em->clear();
  2246.                         //para pruebas
  2247.                         //$data_prueba[] = array(
  2248.                         //    'data' => $supplierservices
  2249.                         //);
  2250.                     }
  2251.                     //para pruebas
  2252.                     //d($data_prueba);
  2253.                     //exit();
  2254.                 }
  2257.                 /* metemos gift *////////////////////////////////////////////////////////////////
  2258.                 $gifts = $em->getRepository(SupplierGifts::class)->findBySupplierId($id);
  2259.                 if(!empty($gifts)){
  2260.                     foreach($gifts as $gift){
  2261.                         $supplierservices->setServiceId($gift->getId());
  2262.                         $supplierservices->setServiceCatId('7');
  2263.                         $supplierservices->setServiceCatName('Gifts');
  2265.                         $supplierservices->setName($gift->getName());
  2266.                         $supplierservices->setPrice($gift->getPrice());
  2267.                         //$supplierservices->setCurrency('Euro');
  2268.                         $supplierservices->setUnits('1');
  2269.                         $supplierservices->setCommission($gift->getCommission());
  2270.                         //$supplierservices->setOver('Accommodation');
  2271.                         $supplierservices->setIva($gift->getIva());
  2272.                         $supplierservices->setPax('0');
  2273.                         //$supplierservices->setHour('');//null
  2274.                         //$supplierservices->setDateInAt('');
  2275.                         //$supplierservices->setDateOutAt('');
  2276.                         $supplierservices->setDirectPayment('0');
  2277.                         $supplierservices->setStatus('Pending');
  2278.                         $supplierservices->setStatusinternal($additional);
  2281.                         $em->persist($supplierservices);
  2282.                         $em->flush();
  2283.                         $em->clear();
  2285.                         //para pruebas
  2286.                         //$data_prueba[] = array(
  2287.                         //    'data' => $supplierservices
  2288.                         //);
  2289.                     }
  2290.                     //para pruebas
  2291.                     //d($data_prueba);
  2292.                     //exit();
  2293.                 }
  2296.                 /* metemos entertainment *////////////////////////////////////////////////////////////////
  2297.                 $entertainments = $em->getRepository(SupplierEntertainment::class)->findBySupplierId($id);
  2298.                 if(!empty($entertainments)){
  2299.                     foreach($entertainments as $entertainment){
  2300.                         $supplierservices->setServiceId($entertainment->getId());
  2301.                         $supplierservices->setServiceCatId('6');
  2302.                         $supplierservices->setServiceCatName('Entertainment');
  2304.                         $supplierservices->setName($entertainment->getName());
  2305.                         $supplierservices->setPrice($entertainment->getPrice());
  2306.                         //$supplierservices->setCurrency('Euro');
  2307.                         $supplierservices->setUnits('1');
  2308.                         $supplierservices->setCommission($entertainment->getCommission());
  2309.                         //$supplierservices->setOver('Accommodation');
  2310.                         $supplierservices->setIva($entertainment->getIva());
  2311.                         $supplierservices->setPax('0');
  2312.                         //$supplierservices->setHour('');//null
  2313.                         //$supplierservices->setDateInAt('');
  2314.                         //$supplierservices->setDateOutAt('');
  2315.                         $supplierservices->setDirectPayment('0');
  2316.                         $supplierservices->setStatus('Pending');
  2317.                         $supplierservices->setStatusinternal($additional);
  2320.                         $em->persist($supplierservices);
  2321.                         $em->flush();
  2322.                         $em->clear();
  2324.                         //para pruebas
  2325.                         //$data_prueba[] = array(
  2326.                         //    'data' => $supplierservices
  2327.                         //);
  2328.                     }
  2329.                     //para pruebas
  2330.                     //d($data_prueba);
  2331.                     //exit();
  2332.                 }
  2335.                 /* metemos guide *////////////////////////////////////////////////////////////////
  2336.                 $guides = $em->getRepository(SupplierGuide::class)->findBySupplierId($id);
  2337.                 if(!empty($guides)){
  2338.                     foreach($guides as $guide){
  2339.                         $supplierservices->setServiceId($guide->getId());
  2340.                         $supplierservices->setServiceCatId('8');
  2341.                         $supplierservices->setServiceCatName('Guide');
  2343.                         $supplierservices->setName($guide->getName());
  2344.                         $supplierservices->setPrice($guide->getPrice());
  2345.                         //$supplierservices->setCurrency('Euro');
  2346.                         $supplierservices->setUnits('1');
  2347.                         $supplierservices->setCommission($guide->getCommission());
  2348.                         //$supplierservices->setOver('Accommodation');
  2349.                         $supplierservices->setIva($guide->getIva());
  2350.                         $supplierservices->setPax('0');
  2351.                         //$supplierservices->setHour('');//null
  2352.                         //$supplierservices->setDateInAt('');
  2353.                         //$supplierservices->setDateOutAt('');
  2354.                         $supplierservices->setDirectPayment('0');
  2355.                         $supplierservices->setStatus('Pending');
  2356.                         $supplierservices->setStatusinternal($additional);
  2359.                         $em->persist($supplierservices);
  2360.                         $em->flush();
  2361.                         $em->clear();
  2363.                         //para pruebas
  2364.                         //$data_prueba[] = array(
  2365.                         //    'data' => $supplierservices
  2366.                         //);
  2367.                     }
  2368.                     //para pruebas
  2369.                     //d($data_prueba);
  2370.                     //exit();
  2371.                 }
  2375.                 /* metemos others *////////////////////////////////////////////////////////////////
  2376.                 $otherss = $em->getRepository(SupplierOthers::class)->findBySupplierId($id);
  2377.                 if(!empty($otherss)){
  2378.                     foreach($otherss as $others){
  2379.                         $supplierservices->setServiceId($others->getId());
  2380.                         $supplierservices->setServiceCatId('12');
  2381.                         $supplierservices->setServiceCatName('Others');
  2383.                         $supplierservices->setName($others->getName());
  2384.                         $supplierservices->setPrice($others->getPrice());
  2385.                         //$supplierservices->setCurrency('Euro');
  2386.                         $supplierservices->setUnits('1');
  2387.                         $supplierservices->setCommission($others->getCommission());
  2388.                         //$supplierservices->setOver('Accommodation');
  2389.                         $supplierservices->setIva($others->getIva());
  2390.                         $supplierservices->setPax('0');
  2391.                         //$supplierservices->setHour('');//null
  2392.                         //$supplierservices->setDateInAt('');
  2393.                         //$supplierservices->setDateOutAt('');
  2394.                         $supplierservices->setDirectPayment('0');
  2395.                         $supplierservices->setStatus('Pending');
  2396.                         $supplierservices->setStatusinternal($additional);
  2399.                         $em->persist($supplierservices);
  2400.                         $em->flush();
  2401.                         $em->clear();
  2403.                         //para pruebas
  2404.                         //$data_prueba[] = array(
  2405.                         //    'data' => $supplierservices
  2406.                         //);
  2407.                     }
  2408.                     //para pruebas
  2409.                     //d($data_prueba);
  2410.                     //exit();
  2411.                 }
  2412.                 /* metemos technology *////////////////////////////////////////////////////////////////
  2413.                 $technologys = $em->getRepository(SupplierTechnology::class)->findBySupplierId($id);
  2414.                 if(!empty($technologys)){
  2415.                     foreach($technologys as $technology){
  2416.                         $supplierservices->setServiceId($technology->getId());
  2417.                         $supplierservices->setServiceCatId('14');
  2418.                         $supplierservices->setServiceCatName('Technology');
  2420.                         $supplierservices->setName($technology->getTitle());
  2421.                         $supplierservices->setPrice($technology->getPrice());
  2422.                         //$supplierservices->setCurrency('Euro');
  2423.                         $supplierservices->setUnits('1');
  2424.                         $supplierservices->setCommission($technology->getCommission());
  2425.                         //$supplierservices->setOver('Accommodation');
  2426.                         $supplierservices->setIva($technology->getIva());
  2427.                         $supplierservices->setPax('0');
  2428.                         //$supplierservices->setHour('');//null
  2429.                         //$supplierservices->setDateInAt('');
  2430.                         //$supplierservices->setDateOutAt('');
  2431.                         $supplierservices->setDirectPayment('0');
  2432.                         $supplierservices->setStatus('Pending');
  2433.                         $supplierservices->setStatusinternal($additional);
  2436.                         $em->persist($supplierservices);
  2437.                         $em->flush();
  2438.                         $em->clear();
  2440.                         //para pruebas
  2441.                         //$data_prueba[] = array(
  2442.                         //    'data' => $supplierservices
  2443.                         //);
  2444.                     }
  2445.                     //para pruebas
  2446.                     //d($data_prueba);
  2447.                     //exit();
  2448.                 }
  2450.                 /* metemos Assistant *////////////////////////////////////////////////////////////////
  2451.                 $assistants = $em->getRepository(SupplierServicesAssistant::class)->findBySupplierId($id);
  2452.                 if(!empty($assistants)){
  2453.                     foreach($assistants as $assistant){
  2454.                         $supplierservices->setServiceId($assistant->getId());
  2455.                         $supplierservices->setServiceCatId('15');
  2456.                         $supplierservices->setServiceCatName('Assistant');
  2458.                         $supplierservices->setName($assistant->getName());
  2459.                         $supplierservices->setPrice($assistant->getPrice());
  2460.                         //$supplierservices->setCurrency('Euro');
  2461.                         $supplierservices->setUnits('1');
  2462.                         $supplierservices->setCommission($assistant->getCommission());
  2463.                         //$supplierservices->setOver('Accommodation');
  2464.                         $supplierservices->setIva($assistant->getIva());
  2465.                         $supplierservices->setPax('0');
  2466.                         //$supplierservices->setHour('');//null
  2467.                         //$supplierservices->setDateInAt('');
  2468.                         //$supplierservices->setDateOutAt('');
  2469.                         $supplierservices->setDirectPayment('0');
  2470.                         $supplierservices->setStatus('Pending');
  2471.                         $supplierservices->setStatusinternal($additional);
  2474.                         $em->persist($supplierservices);
  2475.                         $em->flush();
  2476.                         $em->clear();
  2478.                         //para pruebas
  2479.                         //$data_prueba[] = array(
  2480.                         //    'data' => $supplierservices
  2481.                         //);
  2482.                     }
  2483.                     //para pruebas
  2484.                     //d($data_prueba);
  2485.                     //exit();
  2486.                 }
  2489.                 /* FIN METEMOS EL CONTENIDO DE LA IDEA */
  2491.                 // Control para el sistema de revision
  2493.                 $ideas = $em->getRepository(Ideas::class)->findOneById($supplier_proposal->getId());
  2494.                 $prpId = $request->request->get('proposalsuppliercontrol')['proposalId'];
  2495.                 $revision1 = new RevisionCarga();
  2496.                 $revision2 = new RevisionCarga();
  2497.                 $revision3 = new RevisionCarga();
  2498.                 $revision1->setIdType($ideas->getId());
  2499.                 $revision2->setIdType($ideas->getId());
  2500.                 $revision3->setIdType($ideas->getId());
  2501.                 $revision1->setName($ideas->getName());
  2502.                 $revision2->setName($ideas->getName());
  2503.                 $revision3->setName($ideas->getName());
  2505.                 // Titulo, Destino y observacion
  2506.                 $revision1->setType('IDEA (Título) - Agregada al Proposal: '.$prpId);
  2507.                 $revision1->setLink('ideas/edit/'.$ideas->getId());
  2508.                 $revision1->setStatus(false);
  2509.                 $em->persist($revision1);
  2510.                 $em->flush();
  2512.                 // Descripcion
  2513.                 $revision2->setType('IDEA (Descripción) - Agregada al Proposal: '.$prpId);
  2515.                 // Buscamos el ID de la descripcion
  2516.                 $idact = $ideas->getId();
  2517.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByIdeaId($idact);
  2518.                 $idctrl = $controlgeneral->getId();
  2519.                 $supdesc = $em->getRepository(SupplierDescription::class)->findOneBySupplierId($idctrl);
  2520.                 $id = $supdesc->getId();
  2522.                 // FIN Buscamos el ID de la descripcion
  2524.                 $revision2->setLink('ideas/description/edit/'.$id);
  2525.                 $revision2->setStatus(false);
  2526.                 $em->persist($revision2);
  2527.                 $em->flush();
  2529.                 // Galería
  2530.                 $revision3->setType('IDEA (Galería) - Agregada al Proposal: '.$prpId);
  2531.                 $revision3->setLink('ideas/gallery/list/'.$ideas->getId());
  2532.                 $revision3->setStatus(false);
  2533.                 $em->persist($revision3);
  2534.                 $em->flush();
  2535.                 // FIN Control para el sistema de revision
  2537.                 $event = 'The Idea Destination Proposal has been created.';
  2538.                 $successMessage = $this->translator->trans($event);
  2539.                 $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  2542.             }else{
  2543.                 $errorMessage = $this->translator->trans('Error, some fields are empty');
  2544.                 $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  2545.             }
  2546.         }else{
  2547.             $errorMessage = $this->translator->trans('The proposal already has this Idea included');
  2548.             $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  2549.         }
  2551.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  2552.             'id' => $control->getControlDestinationId(),
  2553.             '_fragment' => 's'.$control->getId()
  2554.         ));
  2555.     }
  2558.     /**
  2559.      * @Route("proposal/destination/services/disabled/{id}", name="proposal_destination_supplier_disabled")
  2560.      *
  2561.      */
  2562.     public function disabledAction($id, Request $request)
  2563.     {
  2564.         $em = $this->getDoctrine()->getManager();
  2565.         $disabled = $em->getRepository(ProposalSupplierControl::class)->findOneById($id);
  2566.         $proposal= $em->getRepository(Proposal::class)->findOneById($disabled->getProposalId());
  2568.         $actual = $disabled->getDisabled();
  2570.         $var_mensaje="";
  2571.         if($actual == "0"){
  2572.             $disabled->setDisabled('1');
  2573.             $var_mensaje = "Disabled";
  2574.         }
  2575.         if($actual == "1"){
  2576.             $disabled->setDisabled('0');
  2577.             $var_mensaje = "Activated";
  2578.         }
  2579.         $em->persist($disabled);
  2580.         $em->flush();
  2582.         $event = 'The supplier has been. '.$var_mensaje;
  2583.         $successMessage = $this->translator->trans($event);
  2584.         $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  2586.         return $this->redirectToRoute('proposal_destination_supplier_view',
  2587.             array(
  2588.                 'id' => $disabled->getControlDestinationId(),
  2589.                 '_fragment' => 's'.$disabled->getId()
  2590.             )
  2591.         );
  2592.     }
  2594.     /**
  2595.      * @Route("proposal/destination/services/deleted/{id}", name="proposal_destination_supplier_deleted")
  2596.      *
  2597.      */
  2598. //    public function deleteAction($id, Request $request, LoggerInterface $logger)
  2599.     public function deleteAction($id, Request $request)
  2600.     {
  2601.         $em = $this->getDoctrine()->getManager();
  2602.         $delete = $em->getRepository(ProposalSupplierControl::class)->findOneById($id);
  2603.         $proposal = $em->getRepository(Proposal::class)->findOneById($delete->getProposalId());
  2605.         $delete_services = $em->getRepository(ProposalSupplierServices::class)->findByControlId($id);
  2606.         foreach ($delete_services as $delete_service) {
  2607.             $em->remove($delete_service);
  2608.         }
  2609.         $em->remove($delete);
  2610.         $em->flush();
  2612.         $event = 'The supplier has been Deleted.';
  2613.         $successMessage = $this->translator->trans($event);
  2614.         $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  2616.         return $this->redirectToRoute('proposal_destination_supplier_view',
  2617.             array(
  2618.                 'id' => $delete->getControlDestinationId()
  2619.             )
  2620.         );
  2621.     }
  2623.     /**
  2624.      * @Route("proposal/destination/services/list/{idcontrol}", name="proposal_destination_supplier_list")
  2625.      */
  2626.     public function listAction($idcontrol, Request $request) {
  2628.         $em = $this->getDoctrine()->getManager();
  2629.         $control = $em->getRepository(ProposalSupplierControl::class)->findOneById($idcontrol);
  2630.         $idsupplier = $control->getSupplierId();
  2631.         $ididea = $control->getIdeaId();
  2632.         $idactivity = $control->getActivityId();
  2634.         if($idsupplier == '0'){
  2635.             $id = '0';
  2636.         }else{
  2637.             if(!is_null($idsupplier)){
  2638.                 /*CONTROL GENERAL*/
  2639.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneBySupplierId($idsupplier);
  2640.                 $id = $controlgeneral->getId();
  2641.             }
  2642.             if(!is_null($idactivity)){
  2643.                 /*CONTROL GENERAL*/
  2644.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByActivityId($idactivity);
  2645.                 $id = $controlgeneral->getId();
  2646.             }
  2647.             if(!is_null($ididea)){
  2648.                 /*CONTROL GENERAL*/
  2649.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByIdeaId($ididea);
  2650.                 $id = $controlgeneral->getId();
  2651.             }
  2652.         }
  2654.         /* accommodations */
  2655.         $accommodations = $em->getRepository(SupplierAccommodation::class)->findBySupplierId($id);
  2656.         $data_accommodation = array();
  2657.         foreach ($accommodations as $accommodation) {
  2659.             /* Consulta en Control Services */
  2660.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2661.                 'servicesId' => $accommodation->getId(),
  2662.                 'servicesCat' => $accommodation->getControlCat()
  2663.             ));
  2665.             //class="label label-flat label-rounded label-icon border-grey text-grey"
  2666.             if ($accommodation->getMinibar()){
  2667.                 $accommodation->setMinibar('<span class="label quitar-margin-15"><img src="/assets/images/icons/mi-20.png"></span>');
  2668.             }
  2669.             if ($accommodation->getWifi()){
  2670.                 $accommodation->setWifi('<span class="label quitar-margin-15"><img src="/assets/images/icons/wi-20.png"></span>');
  2671.             }
  2672.             if ($accommodation->getAirconditioner()){
  2673.                 $accommodation->setAirconditioner('<span class="label quitar-margin-15"><img src="/assets/images/icons/ac-20.png"></span>');
  2674.             }
  2675.             if ($accommodation->getCalefaction()){
  2676.                 $accommodation->setCalefaction('<span class="label quitar-margin-15"><img src="/assets/images/icons/ca-20.png"></span>');
  2677.             }
  2678.             if ($accommodation->getPool()){
  2679.                 $accommodation->setPool('<span class="label quitar-margin-15"><img src="/assets/images/icons/po-20.png"></span>');
  2680.             }
  2681.             if ($accommodation->getBath()){
  2682.                 $accommodation->setBath('<span class="label quitar-margin-15"><img src="/assets/images/icons/ba-20.png"></span>');
  2683.             }
  2684.             if ($accommodation->getCoffeemaker()){
  2685.                 $accommodation->setCoffeemaker('<span class="label quitar-margin-15"><img src="/assets/images/icons/cm-20.png"></span>');
  2686.             }
  2687.             if ($accommodation->getKitchen()){
  2688.                 $accommodation->setKitchen('<span class="label quitar-margin-15"><img src="/assets/images/icons/ki-20.png"></span>');
  2689.             }
  2690.             if ($accommodation->getWasher()){
  2691.                 $accommodation->setWasher('<span class="label quitar-margin-15"><img src="/assets/images/icons/wa-20.png"></span>');
  2692.             }
  2693.             if ($accommodation->getFlattv()){
  2694.                 $accommodation->setFlattv('<span class="label quitar-margin-15"><img src="/assets/images/icons/tv-20.png"></span>');
  2695.             }
  2696.             if ($accommodation->getElectrickettle()){
  2697.                 $accommodation->setElectrickettle('<span class="label quitar-margin-15"><img src="/assets/images/icons/ke-20.png"></span>');
  2698.             }
  2699.             if ($accommodation->getViews()){
  2700.                 $accommodation->setViews('<span class="label quitar-margin-15"><img src="/assets/images/icons/vi-20.png"></span>');
  2701.             }
  2702.             if ($accommodation->getPets()){
  2703.                 $accommodation->setPets('<span class="label quitar-margin-15"><img src="/assets/images/icons/pe-20.png"></span>');
  2704.             }
  2706. //                $data_accommodation[]=$accommodation;
  2707.             $data_accommodation[] = array(
  2708.                 'id' => $accommodation->getId(),
  2709.                 'name' => $accommodation->getName(),
  2710.                 'size' => $accommodation->getSize(),
  2711.                 'quantity' => $accommodation->getQuantity(),
  2712.                 'price' => $accommodation->getPrice(),
  2713.                 'controlId' => $controlctrlDes->getId(),
  2715.                 'minibar' => $accommodation->getMinibar(),
  2716.                 'wifi' => $accommodation->getWifi(),
  2717.                 'airconditioner' => $accommodation->getAirconditioner(),
  2718.                 'calefaction' => $accommodation->getCalefaction(),
  2719.                 'pool' => $accommodation->getPool(),
  2720.                 'bath' => $accommodation->getBath(),
  2721.                 'coffeemaker' => $accommodation->getCoffeemaker(),
  2722.                 'kitchen' => $accommodation->getKitchen(),
  2723.                 'washer' => $accommodation->getWasher(),
  2724.                 'flattv' => $accommodation->getFlattv(),
  2725.                 'electrickettle' => $accommodation->getElectrickettle(),
  2726.                 'views' => $accommodation->getViews(),
  2727.                 'pets' => $accommodation->getPets()
  2728.             );
  2729.         }
  2730.         /* accommodations */
  2732.         /* menu */
  2733.         $menus = $em->getRepository(SupplierMenu::class)->findBySupplierId($id);
  2734.         /* menu Description*/
  2735.         $data_menu = array();
  2736.         foreach($menus as $menu){
  2738.             /* Consulta en Control Description */
  2739.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2740.                 'servicesId' => $menu->getId(),
  2741.                 'servicesCat' => $menu->getControlCat()
  2742.             ));
  2743. //            $controlctrlDes->getId();
  2744. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2746.             $data_menu[] = array(
  2747.                 'id' => $menu->getId(),
  2748.                 'title' => $menu->getTitle(),
  2749.                 'description' => $menu->getDescription(),
  2750.                 'currency' => $menu->getCurrency(),
  2751.                 'price' => $menu->getPrice(),
  2752.                 'commission' => $menu->getCommission(),
  2753.                 'iva' => $menu->getIva(),
  2754.                 'controlId' => $controlctrlDes->getId()
  2755.             );
  2756.         }
  2758.         /* lounge */
  2759.         $lounges = $em->getRepository(SupplierLounge::class)->findBySupplierId($id);
  2760.         /* lounge Description*/
  2761.         $data_lounge = array();
  2762.         foreach($lounges as $lounge){
  2764.             /* Consulta en Control Description */
  2765.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2766.                 'servicesId' => $lounge->getId(),
  2767.                 'servicesCat' => $lounge->getControlCat()
  2768.             ));
  2769. //            $controlctrlDes->getId();
  2770. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2772.             $data_lounge[] = array(
  2773.                 'id' => $lounge->getId(),
  2774.                 'name' => $lounge->getName(),
  2775.                 'currency' => $lounge->getCurrency(),
  2776.                 'price' => $lounge->getPrice(),
  2777.                 'commission' => $lounge->getCommission(),
  2778.                 'iva' => $lounge->getIva(),
  2779.                 'controlId' => $controlctrlDes->getId()
  2780.             );
  2781.         }
  2783.         /* Transport */
  2784.         $transports = $em->getRepository(SupplierTransport::class)->findBySupplierId($id);
  2785.         /* Transport Description*/
  2786.         $data_transport = array();
  2787.         foreach($transports as $transport){
  2789.             /* Consulta en Control Description */
  2790.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2791.                 'servicesId' => $transport->getId(),
  2792.                 'servicesCat' => $transport->getControlCat()
  2793.             ));
  2794. //            $controlctrlDes->getId();
  2795. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2797.             $data_transport[] = array(
  2798.                 'id' => $transport->getId(),
  2799.                 'name' => $transport->getName(),
  2800.                 'driver' => $transport->getDriver(),
  2801.                 'currency' => $transport->getCurrency(),
  2802.                 'price' => $transport->getPrice(),
  2803.                 'commission' => $transport->getCommission(),
  2804.                 'iva' => $transport->getIva(),
  2805.                 'controlId' => $controlctrlDes->getId()
  2806.             );
  2807.         }
  2809.         /* Guide */
  2810.         $guides = $em->getRepository(SupplierGuide::class)->findBySupplierId($id);
  2811.         /* Guide Description*/
  2812.         $data_guide = array();
  2813.         foreach($guides as $guide){
  2815.             /* Consulta en Control Description */
  2816.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2817.                 'servicesId' => $guide->getId(),
  2818.                 'servicesCat' => $guide->getControlCat()
  2819.             ));
  2820. //            $controlctrlDes->getId();
  2821. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2823.             $data_guide[] = array(
  2824.                 'id' => $guide->getId(),
  2825.                 'name' => $guide->getName(),
  2826.                 'guide' => $guide->getGuide(),
  2827.                 'currency' => $guide->getCurrency(),
  2828.                 'price' => $guide->getPrice(),
  2829.                 'commission' => $guide->getCommission(),
  2830.                 'iva' => $guide->getIva(),
  2831.                 'controlId' => $controlctrlDes->getId()
  2832.             );
  2833.         }
  2835.         /* Itineraries */
  2836.         $itinerariess = $em->getRepository(SupplierItineraries::class)->findBySupplierId($id);
  2837.         /* Itineraries Description*/
  2838.         $data_itineraries = array();
  2839.         foreach($itinerariess as $itineraries){
  2841.             /* Consulta en Control Description */
  2842.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2843.                 'servicesId' => $itineraries->getId(),
  2844.                 'servicesCat' => $itineraries->getControlCat()
  2845.             ));
  2846.             //$controlctrlDes->getId();
  2847.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2849.             $data_itineraries[] = array(
  2850.                 'id' => $itineraries->getId(),
  2851.                 'title' => $itineraries->getTitle(),
  2852.                 'controlId' => $controlctrlDes->getId(),
  2853.                 'description' => $description
  2854.             );
  2855.         }
  2857.         /* activities */
  2858.         $activitiess = $em->getRepository(SupplierActivities::class)->findBySupplierId($id);
  2859.         /* activities Description*/
  2860.         $data_activities = array();
  2861.         foreach($activitiess as $activities){
  2863.             /* Consulta en Control Description */
  2864.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2865.                 'servicesId' => $activities->getId(),
  2866.                 'servicesCat' => $activities->getControlCat()
  2867.             ));
  2868.             //$controlctrlDes->getId();
  2869.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2871.             $data_activities[] = array(
  2872.                 'id' => $activities->getId(),
  2873.                 'title' => $activities->getTitle(),
  2874.                 'capacity' => $activities->getCapacity(),
  2875.                 'currency' => $activities->getCurrency(),
  2876.                 'price' => $activities->getPrice(),
  2877.                 'commission' => $activities->getCommission(),
  2878.                 'iva' => $activities->getIva(),
  2879.                 'controlId' => $controlctrlDes->getId(),
  2880.                 'description' => $description
  2881.             );
  2882.         }
  2884.         /* cruise */
  2885.         $cruises = $em->getRepository(SupplierCruise::class)->findBySupplierId($id);
  2886.         /* cruise Description*/
  2887.         $data_cruise = array();
  2888.         foreach($cruises as $cruise){
  2890.             /* Consulta en Control Description */
  2891.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2892.                 'servicesId' => $cruise->getId(),
  2893.                 'servicesCat' => $cruise->getControlCat()
  2894.             ));
  2895.             //$controlctrlDes->getId();
  2896.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2898.             $data_cruise[] = array(
  2899.                 'id' => $cruise->getId(),
  2900.                 'title' => $cruise->getTitle(),
  2901.                 'currency' => $cruise->getCurrency(),
  2902.                 'price' => $cruise->getPrice(),
  2903.                 'commission' => $cruise->getCommission(),
  2904.                 'iva' => $cruise->getIva(),
  2905.                 'controlId' => $controlctrlDes->getId(),
  2906.                 'description' => $description
  2907.             );
  2908.         }
  2910.         /* Av */
  2911.         $avs = $em->getRepository(SupplierAv::class)->findBySupplierId($id);
  2912.         /* Av Description*/
  2913.         $data_av = array();
  2914.         foreach($avs as $av){
  2916.             /* Consulta en Control Description */
  2917.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2918.                 'servicesId' => $av->getId(),
  2919.                 'servicesCat' => $av->getControlCat()
  2920.             ));
  2921.             //$controlctrlDes->getId();
  2922.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2924.             $data_av[] = array(
  2925.                 'id' => $av->getId(),
  2926.                 'name' => $av->getName(),
  2927.                 'responsible' => $av->getResponsible(),
  2928.                 'currency' => $av->getCurrency(),
  2929.                 'price' => $av->getPrice(),
  2930.                 'commission' => $av->getCommission(),
  2931.                 'iva' => $av->getIva(),
  2932.                 'controlId' => $controlctrlDes->getId(),
  2933.                 'description' => $description
  2934.             );
  2935.         }
  2937.         /* Creative */
  2938.         $creatives = $em->getRepository(SupplierCreative::class)->findBySupplierId($id);
  2939.         /* Creative Description*/
  2940.         $data_creative = array();
  2941.         foreach($creatives as $creative){
  2943.             /* Consulta en Control Description */
  2944.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2945.                 'servicesId' => $creative->getId(),
  2946.                 'servicesCat' => $creative->getControlCat()
  2947.             ));
  2948.             //$controlctrlDes->getId();
  2949.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2951.             $data_creative[] = array(
  2952.                 'id' => $creative->getId(),
  2953.                 'title' => $creative->getTitle(),
  2954.                 'controlId' => $controlctrlDes->getId(),
  2955.                 'description' => $description
  2956.             );
  2957.         }
  2959.         /* Gifts */
  2960.         $gifts = $em->getRepository(SupplierGifts::class)->findBySupplierId($id);
  2961.         /* Gifts Description*/
  2962.         $data_gifts = array();
  2963.         foreach($gifts as $gift){
  2965.             /* Consulta en Control Description */
  2966.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2967.                 'servicesId' => $gift->getId(),
  2968.                 'servicesCat' => $gift->getControlCat()
  2969.             ));
  2970.             //$controlctrlDes->getId();
  2971.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2973.             $data_gifts[] = array(
  2974.                 'id' => $gift->getId(),
  2975.                 'name' => $gift->getName(),
  2976.                 'responsible' => $gift->getResponsible(),
  2977.                 'currency' => $gift->getCurrency(),
  2978.                 'price' => $gift->getPrice(),
  2979.                 'commission' => $gift->getCommission(),
  2980.                 'iva' => $gift->getIva(),
  2981.                 'controlId' => $controlctrlDes->getId(),
  2982.                 'description' => $description
  2983.             );
  2984.         }
  2986.         /* Entertainment */
  2987.         $entertainments = $em->getRepository(SupplierEntertainment::class)->findBySupplierId($id);
  2988.         /* Entertainment Description*/
  2989.         $data_entertainment = array();
  2990.         foreach($entertainments as $entertainment){
  2992.             /* Consulta en Control Description */
  2993.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2994.                 'servicesId' => $entertainment->getId(),
  2995.                 'servicesCat' => $entertainment->getControlCat()
  2996.             ));
  2997.             //$controlctrlDes->getId();
  2998.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3000.             $data_entertainment[] = array(
  3001.                 'id' => $entertainment->getId(),
  3002.                 'name' => $entertainment->getName(),
  3003.                 'responsible' => $entertainment->getResponsible(),
  3004.                 'currency' => $entertainment->getCurrency(),
  3005.                 'price' => $entertainment->getPrice(),
  3006.                 'commission' => $entertainment->getCommission(),
  3007.                 'iva' => $entertainment->getIva(),
  3008.                 'controlId' => $controlctrlDes->getId(),
  3009.                 'description' => $description
  3010.             );
  3011.         }
  3013.         /* Others */
  3014.         $otherss = $em->getRepository(SupplierOthers::class)->findBySupplierId($id);
  3015.         /* Others Description*/
  3016.         $data_others = array();
  3017.         foreach($otherss as $others){
  3019.             /* Consulta en Control Description */
  3020.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3021.                 'servicesId' => $others->getId(),
  3022.                 'servicesCat' => $others->getControlCat()
  3023.             ));
  3024.             //$controlctrlDes->getId();
  3025.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3027.             $data_others[] = array(
  3028.                 'id' => $others->getId(),
  3029.                 'name' => $others->getName(),
  3030.                 'responsible' => $others->getResponsible(),
  3031.                 'currency' => $others->getCurrency(),
  3032.                 'price' => $others->getPrice(),
  3033.                 'commission' => $others->getCommission(),
  3034.                 'iva' => $others->getIva(),
  3035.                 'controlId' => $controlctrlDes->getId(),
  3036.                 'description' => $description
  3037.             );
  3038.         }
  3040.         /* technology */
  3042.         if ($idsupplier == 2){          // Es una tecnologia de Develup
  3043.             $technologys = $em->getRepository(MdvProduct::class)->findAll();
  3045.             $data_technology = array();
  3046.             foreach($technologys as $technology){
  3048.                 $data_technology[] = array(
  3049.                     'id' => $technology->getId(),
  3050.                     'title' => $technology->getName(),
  3051.                     'modules' => null,
  3052.                     'type' => $technology->getType(),
  3053.                     'currency' => 'Euro',
  3054.                     'price' => $technology->getPrice(),
  3055.                     'commission' => $technology->getCommission(),
  3056.                     'iva' => $technology->getIva(),
  3057.                     'controlId' => null,
  3058.                     'description' => $technology->getDescription(),
  3059.                     'supplier' => 'Develup',
  3060.                 );
  3061.             }
  3063.         } else {
  3065.             $technologys = $em->getRepository(SupplierTechnology::class)->findBySupplierId($id);
  3066.             /* technology Description*/
  3067.             $data_technology = array();
  3068.             foreach($technologys as $technology){
  3070.                 /* Consulta en Control Description */
  3071.                 $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3072.                     'servicesId' => $technology->getId(),
  3073.                     'servicesCat' => $technology->getControlCat()
  3074.                 ));
  3075.                 //$controlctrlDes->getId();
  3076.                 $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3078.                 $data_technology[] = array(
  3079.                     'id' => $technology->getId(),
  3080.                     'title' => $technology->getTitle(),
  3081.                     'modules' => $technology->getModules(),
  3082.                     'type' => $technology->getType(),
  3083.                     'currency' => $technology->getCurrency(),
  3084.                     'price' => $technology->getPrice(),
  3085.                     'commission' => $technology->getCommission(),
  3086.                     'iva' => $technology->getIva(),
  3087.                     'controlId' => $controlctrlDes->getId(),
  3088.                     'description' => $description
  3089.                 );
  3090.             }
  3091.             /////////////////////////////////////////////////////////////////////
  3092.             $technologys = $em->getRepository(SupplierTechnology::class)->findBySupplierId($id);
  3094.             /* technology Description*/
  3095.             $data_technology = array();
  3096.             foreach($technologys as $technology){
  3098.                 /* Consulta en Control Description */
  3099.                 $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3100.                     'servicesId' => $technology->getId(),
  3101.                     'servicesCat' => $technology->getControlCat()
  3102.                 ));
  3103.                 //$controlctrlDes->getId();
  3104.                 $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3106.                 $data_technology[] = array(
  3107.                     'id' => $technology->getId(),
  3108.                     'title' => $technology->getTitle(),
  3109.                     'modules' => $technology->getModules(),
  3110.                     'type' => $technology->getType(),
  3111.                     'currency' => $technology->getCurrency(),
  3112.                     'price' => $technology->getPrice(),
  3113.                     'commission' => $technology->getCommission(),
  3114.                     'iva' => $technology->getIva(),
  3115.                     'controlId' => $controlctrlDes->getId(),
  3116.                     'description' => $description
  3117.                 );
  3118.             }
  3119.         }
  3122.         /* Assistant  */
  3123.         $assistants = $em->getRepository(SupplierServicesAssistant::class)->findBySupplierId($id);
  3124.         /* Assistant  Description*/
  3125.         $data_assistant = array();
  3126.         foreach($assistants as $assistant){
  3128.             /* Consulta en Control Description */
  3129.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3130.                 'servicesId' => $assistant->getId(),
  3131.                 'servicesCat' => $assistant->getControlCat()
  3132.             ));
  3133.             //$controlctrlDes->getId();
  3134.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3136.             $data_assistant[] = array(
  3137.                 'id' => $assistant->getId(),
  3138.                 'name' => $assistant->getName(),
  3139.                 'quantity' => $assistant->getQuantity(),
  3140.                 'currency' => $assistant->getCurrency(),
  3141.                 'price' => $assistant->getPrice(),
  3142.                 'commission' => $assistant->getCommission(),
  3143.                 'iva' => $assistant->getIva(),
  3144.                 'controlId' => $controlctrlDes->getId(),
  3145.                 'description' => $description
  3146.             );
  3147.         }
  3151.         /* salida de data */
  3152.         return $this->render('MDS/EventsBundle/services/services-modal-proposal.html.twig', array(
  3153.             'idcontrol' => $idcontrol,
  3154.             'accommodations' => $data_accommodation,
  3155.             'menus' => $data_menu,
  3156.             'lounges' => $data_lounge,
  3157.             'transports' => $data_transport,
  3158.             'guides' => $data_guide,
  3159.             'itineraries' => $data_itineraries,
  3160.             'activities' => $data_activities,
  3161.             'cruises' => $data_cruise,
  3162.             'avs' => $data_av,
  3163.             'creatives' => $data_creative,
  3164.             'gifts' => $data_gifts,
  3165.             'entertainments' => $data_entertainment,
  3166.             'technology' => $data_technology,
  3167.             'assistants' => $data_assistant,
  3168.             'otherss' => $data_others
  3169.         ));
  3170.     }
  3172.     /**
  3173.      * @Route("proposal/destination/servicesesp/list/{idcontrol}", name="proposal_destination_supplier_especial_list")
  3174.      */
  3175.     public function listEspecialSupplierAction($idcontrol, Request $request) {
  3177.         $em = $this->getDoctrine()->getManager();
  3178.         $control = $em->getRepository(ProposalSupplierControl::class)->findOneById($idcontrol);
  3179.         $idsupplier = $control->getSupplierId();
  3180.         $cdid = $control->getControlDestinationId();
  3181.         $ididea = $control->getIdeaId();
  3182.         $idactivity = $control->getActivityId();
  3184.         $proposal = $em->getRepository(Proposal::class)->findOneById($control->getProposalId());
  3186.         if($idsupplier == '0'){
  3187.             $id = '0';
  3188.         }else{
  3189.             if(!is_null($idsupplier)){
  3190.                 /*CONTROL GENERAL*/
  3191.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneBySupplierId($idsupplier);
  3192.                 $id = $controlgeneral->getId();
  3193.             }
  3194.             if(!is_null($idactivity)){
  3195.                 /*CONTROL GENERAL*/
  3196.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByActivityId($idactivity);
  3197.                 $id = $controlgeneral->getId();
  3198.             }
  3199.             if(!is_null($ididea)){
  3200.                 /*CONTROL GENERAL*/
  3201.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByIdeaId($ididea);
  3202.                 $id = $controlgeneral->getId();
  3203.             }
  3204.         }
  3206.         /* accommodations */
  3207.         $accommodations = $em->getRepository(SupplierAccommodation::class)->findBySupplierId($id);
  3208.         $data_accommodation = array();
  3209.         foreach ($accommodations as $accommodation) {
  3211.             /* Consulta en Control Services */
  3212.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3213.                 'servicesId' => $accommodation->getId(),
  3214.                 'servicesCat' => $accommodation->getControlCat()
  3215.             ));
  3217.             //class="label label-flat label-rounded label-icon border-grey text-grey"
  3218.             if ($accommodation->getMinibar()){
  3219.                 $accommodation->setMinibar('<span class="label quitar-margin-15"><img src="/assets/images/icons/mi-20.png"></span>');
  3220.             }
  3221.             if ($accommodation->getWifi()){
  3222.                 $accommodation->setWifi('<span class="label quitar-margin-15"><img src="/assets/images/icons/wi-20.png"></span>');
  3223.             }
  3224.             if ($accommodation->getAirconditioner()){
  3225.                 $accommodation->setAirconditioner('<span class="label quitar-margin-15"><img src="/assets/images/icons/ac-20.png"></span>');
  3226.             }
  3227.             if ($accommodation->getCalefaction()){
  3228.                 $accommodation->setCalefaction('<span class="label quitar-margin-15"><img src="/assets/images/icons/ca-20.png"></span>');
  3229.             }
  3230.             if ($accommodation->getPool()){
  3231.                 $accommodation->setPool('<span class="label quitar-margin-15"><img src="/assets/images/icons/po-20.png"></span>');
  3232.             }
  3233.             if ($accommodation->getBath()){
  3234.                 $accommodation->setBath('<span class="label quitar-margin-15"><img src="/assets/images/icons/ba-20.png"></span>');
  3235.             }
  3236.             if ($accommodation->getCoffeemaker()){
  3237.                 $accommodation->setCoffeemaker('<span class="label quitar-margin-15"><img src="/assets/images/icons/cm-20.png"></span>');
  3238.             }
  3239.             if ($accommodation->getKitchen()){
  3240.                 $accommodation->setKitchen('<span class="label quitar-margin-15"><img src="/assets/images/icons/ki-20.png"></span>');
  3241.             }
  3242.             if ($accommodation->getWasher()){
  3243.                 $accommodation->setWasher('<span class="label quitar-margin-15"><img src="/assets/images/icons/wa-20.png"></span>');
  3244.             }
  3245.             if ($accommodation->getFlattv()){
  3246.                 $accommodation->setFlattv('<span class="label quitar-margin-15"><img src="/assets/images/icons/tv-20.png"></span>');
  3247.             }
  3248.             if ($accommodation->getElectrickettle()){
  3249.                 $accommodation->setElectrickettle('<span class="label quitar-margin-15"><img src="/assets/images/icons/ke-20.png"></span>');
  3250.             }
  3251.             if ($accommodation->getViews()){
  3252.                 $accommodation->setViews('<span class="label quitar-margin-15"><img src="/assets/images/icons/vi-20.png"></span>');
  3253.             }
  3254.             if ($accommodation->getPets()){
  3255.                 $accommodation->setPets('<span class="label quitar-margin-15"><img src="/assets/images/icons/pe-20.png"></span>');
  3256.             }
  3258. //                $data_accommodation[]=$accommodation;
  3259.             $data_accommodation[] = array(
  3260.                 'id' => $accommodation->getId(),
  3261.                 'name' => $accommodation->getName(),
  3262.                 'size' => $accommodation->getSize(),
  3263.                 'quantity' => $accommodation->getQuantity(),
  3264.                 'price' => $accommodation->getPrice(),
  3265.                 'controlId' => $controlctrlDes->getId(),
  3267.                 'minibar' => $accommodation->getMinibar(),
  3268.                 'wifi' => $accommodation->getWifi(),
  3269.                 'airconditioner' => $accommodation->getAirconditioner(),
  3270.                 'calefaction' => $accommodation->getCalefaction(),
  3271.                 'pool' => $accommodation->getPool(),
  3272.                 'bath' => $accommodation->getBath(),
  3273.                 'coffeemaker' => $accommodation->getCoffeemaker(),
  3274.                 'kitchen' => $accommodation->getKitchen(),
  3275.                 'washer' => $accommodation->getWasher(),
  3276.                 'flattv' => $accommodation->getFlattv(),
  3277.                 'electrickettle' => $accommodation->getElectrickettle(),
  3278.                 'views' => $accommodation->getViews(),
  3279.                 'pets' => $accommodation->getPets()
  3280.             );
  3281.         }
  3282.         /* accommodations */
  3284.         /* menu */
  3285.         $menus = $em->getRepository(SupplierMenu::class)->findBySupplierId($id);
  3286.         /* menu Description*/
  3287.         $data_menu = array();
  3288.         foreach($menus as $menu){
  3290.             /* Consulta en Control Description */
  3291.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3292.                 'servicesId' => $menu->getId(),
  3293.                 'servicesCat' => $menu->getControlCat()
  3294.             ));
  3295. //            $controlctrlDes->getId();
  3296. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3298.             $data_menu[] = array(
  3299.                 'id' => $menu->getId(),
  3300.                 'title' => $menu->getTitle(),
  3301.                 'description' => $menu->getDescription(),
  3302.                 'currency' => $menu->getCurrency(),
  3303.                 'price' => $menu->getPrice(),
  3304.                 'commission' => $menu->getCommission(),
  3305.                 'iva' => $menu->getIva(),
  3306.                 'controlId' => $controlctrlDes->getId()
  3307.             );
  3308.         }
  3310.         /* lounge */
  3311.         $lounges = $em->getRepository(SupplierLounge::class)->findBySupplierId($id);
  3312.         /* lounge Description*/
  3313.         $data_lounge = array();
  3314.         foreach($lounges as $lounge){
  3316.             /* Consulta en Control Description */
  3317.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3318.                 'servicesId' => $lounge->getId(),
  3319.                 'servicesCat' => $lounge->getControlCat()
  3320.             ));
  3321. //            $controlctrlDes->getId();
  3322. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3324.             $data_lounge[] = array(
  3325.                 'id' => $lounge->getId(),
  3326.                 'name' => $lounge->getName(),
  3327.                 'currency' => $lounge->getCurrency(),
  3328.                 'price' => $lounge->getPrice(),
  3329.                 'commission' => $lounge->getCommission(),
  3330.                 'iva' => $lounge->getIva(),
  3331.                 'controlId' => $controlctrlDes->getId()
  3332.             );
  3333.         }
  3335.         /* Transport */
  3336.         $transports = $em->getRepository(SupplierTransport::class)->findBySupplierId($id);
  3337.         /* Transport Description*/
  3338.         $data_transport = array();
  3339.         foreach($transports as $transport){
  3341.             /* Consulta en Control Description */
  3342.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3343.                 'servicesId' => $transport->getId(),
  3344.                 'servicesCat' => $transport->getControlCat()
  3345.             ));
  3346. //            $controlctrlDes->getId();
  3347. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3349.             $data_transport[] = array(
  3350.                 'id' => $transport->getId(),
  3351.                 'name' => $transport->getName(),
  3352.                 'driver' => $transport->getDriver(),
  3353.                 'currency' => $transport->getCurrency(),
  3354.                 'price' => $transport->getPrice(),
  3355.                 'commission' => $transport->getCommission(),
  3356.                 'iva' => $transport->getIva(),
  3357.                 'controlId' => $controlctrlDes->getId()
  3358.             );
  3359.         }
  3361.         /* Guide */
  3362.         $guides = $em->getRepository(SupplierGuide::class)->findBySupplierId($id);
  3363.         /* Guide Description*/
  3364.         $data_guide = array();
  3365.         foreach($guides as $guide){
  3367.             /* Consulta en Control Description */
  3368.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3369.                 'servicesId' => $guide->getId(),
  3370.                 'servicesCat' => $guide->getControlCat()
  3371.             ));
  3372. //            $controlctrlDes->getId();
  3373. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3375.             $data_guide[] = array(
  3376.                 'id' => $guide->getId(),
  3377.                 'name' => $guide->getName(),
  3378.                 'guide' => $guide->getGuide(),
  3379.                 'currency' => $guide->getCurrency(),
  3380.                 'price' => $guide->getPrice(),
  3381.                 'commission' => $guide->getCommission(),
  3382.                 'iva' => $guide->getIva(),
  3383.                 'controlId' => $controlctrlDes->getId()
  3384.             );
  3385.         }
  3387.         /* Itineraries */
  3388.         $itinerariess = $em->getRepository(SupplierItineraries::class)->findBySupplierId($id);
  3389.         /* Itineraries Description*/
  3390.         $data_itineraries = array();
  3391.         foreach($itinerariess as $itineraries){
  3393.             /* Consulta en Control Description */
  3394.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3395.                 'servicesId' => $itineraries->getId(),
  3396.                 'servicesCat' => $itineraries->getControlCat()
  3397.             ));
  3398.             //$controlctrlDes->getId();
  3399.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3401.             $data_itineraries[] = array(
  3402.                 'id' => $itineraries->getId(),
  3403.                 'title' => $itineraries->getTitle(),
  3404.                 'controlId' => $controlctrlDes->getId(),
  3405.                 'description' => $description
  3406.             );
  3407.         }
  3409.         /* activities */
  3410.         $activitiess = $em->getRepository(SupplierActivities::class)->findBySupplierId($id);
  3411.         /* activities Description*/
  3412.         $data_activities = array();
  3413.         foreach($activitiess as $activities){
  3415.             /* Consulta en Control Description */
  3416.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3417.                 'servicesId' => $activities->getId(),
  3418.                 'servicesCat' => $activities->getControlCat()
  3419.             ));
  3420.             //$controlctrlDes->getId();
  3421.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3423.             $data_activities[] = array(
  3424.                 'id' => $activities->getId(),
  3425.                 'title' => $activities->getTitle(),
  3426.                 'capacity' => $activities->getCapacity(),
  3427.                 'currency' => $activities->getCurrency(),
  3428.                 'price' => $activities->getPrice(),
  3429.                 'commission' => $activities->getCommission(),
  3430.                 'iva' => $activities->getIva(),
  3431.                 'controlId' => $controlctrlDes->getId(),
  3432.                 'description' => $description
  3433.             );
  3434.         }
  3436.         /* cruise */
  3437.         $cruises = $em->getRepository(SupplierCruise::class)->findBySupplierId($id);
  3438.         /* cruise Description*/
  3439.         $data_cruise = array();
  3440.         foreach($cruises as $cruise){
  3442.             /* Consulta en Control Description */
  3443.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3444.                 'servicesId' => $cruise->getId(),
  3445.                 'servicesCat' => $cruise->getControlCat()
  3446.             ));
  3447.             //$controlctrlDes->getId();
  3448.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3450.             $data_cruise[] = array(
  3451.                 'id' => $cruise->getId(),
  3452.                 'title' => $cruise->getTitle(),
  3453.                 'currency' => $cruise->getCurrency(),
  3454.                 'price' => $cruise->getPrice(),
  3455.                 'commission' => $cruise->getCommission(),
  3456.                 'iva' => $cruise->getIva(),
  3457.                 'controlId' => $controlctrlDes->getId(),
  3458.                 'description' => $description
  3459.             );
  3460.         }
  3462.         /* Av */
  3463.         if ($idsupplier == 80){
  3464.             // El proveedor del AV es AvExpress
  3466.             // Listamos por orden alfabetico y se deja de primero a "Otro servicio"
  3467.             $parameters = array();
  3468.             $dql = 'SELECT i
  3469.                         FROM AvexpressBundle:AveProduct i
  3470.                         ORDER BY i.name ASC';
  3471.             $query = $em->createQuery($dql)->setParameters($parameters);
  3472.             $avs = $query->getResult();
  3473.             $newAvs = array();
  3475.             foreach ($avs as $key => $item) {
  3476.                 if ($item->getName() == 'Otro servicio'){
  3477.                     $item->setName('0 - Otro servicio');
  3478.                     $newAvs = array($item);
  3479.                     unset($avs[$key]);
  3480.                     foreach ($avs as $keyTwo => $elem){
  3481.                         $ind = $keyTwo + 1;
  3482.                         $elem->setName($ind.' - '.$elem->getName());
  3483.                         array_push($newAvs,$elem);
  3484.                     }
  3485.                 }
  3486.             }
  3488.             $avs = $newAvs;
  3490.             /* av Description*/
  3491.             $data_av = array();
  3492.             foreach($avs as $av){
  3494.                 $data_av[] = array(
  3495.                     'id' => $av->getId(),
  3496.                     'name' => $av->getName(),
  3497. //                    'modules' => $technology->getModules(),
  3498.                     'modules' => null,
  3499.                     'type' => $av->getType(),
  3500.                     'currency' => 'Euro',
  3501.                     'price' => $av->getPrice(),
  3502.                     'commission' => 0,
  3503.                     'iva' => 21,
  3504.                     'controlId' => null,
  3505.                     'description' => $av->getDescription(),
  3506.                     'supplier' => 'AvExpress',
  3507.                 );
  3508.             }
  3510.             //   ***************************************** METEMOS AV TEMPLATES (Tipo: AVExpress Template)
  3511.             $parameters = array();
  3512.             $dql = 'SELECT i
  3513.                         FROM AvexpressBundle:AveTemplate i
  3514.                         ORDER BY i.name ASC';
  3515.             $query = $em->createQuery($dql)->setParameters($parameters);
  3516.             $avsTemplate = $query->getResult();
  3518.             foreach($avsTemplate as $av){
  3520.                 $data_av[] = array(
  3521.                     'id' => $av->getId(),
  3522.                     'name' => $av->getName(),
  3523.                     'modules' => null,
  3524.                     'type' => 'AVExpress Template',
  3525.                     'currency' => null,
  3526.                     'price' => null,
  3527.                     'commission' => null,
  3528.                     'iva' => null,
  3529.                     'controlId' => null,
  3530.                     'description' => null,
  3531.                     'supplier' => 'AvExpress',
  3532.                 );
  3533.             }
  3535.         } else {
  3536.             $newAvs = array();
  3537.             $avs = $em->getRepository(SupplierAv::class)->findBySupplierId($id);
  3538.             /* Av Description*/
  3539.             $data_av = array();
  3540.             foreach($avs as $av){
  3542.                 /* Consulta en Control Description */
  3543.                 $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3544.                     'servicesId' => $av->getId(),
  3545.                     'servicesCat' => $av->getControlCat()
  3546.                 ));
  3547.                 //$controlctrlDes->getId();
  3548.                 $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3550.                 $data_av[] = array(
  3551.                     'id' => $av->getId(),
  3552.                     'name' => $av->getName(),
  3553.                     'responsible' => $av->getResponsible(),
  3554.                     'currency' => $av->getCurrency(),
  3555.                     'price' => $av->getPrice(),
  3556.                     'commission' => $av->getCommission(),
  3557.                     'iva' => $av->getIva(),
  3558.                     'controlId' => $controlctrlDes->getId(),
  3559.                     'description' => $description
  3560.                 );
  3561.             }
  3562.         }
  3565.         /* Creative */
  3566.         $creatives = $em->getRepository(SupplierCreative::class)->findBySupplierId($id);
  3567.         /* Creative Description*/
  3568.         $data_creative = array();
  3569.         foreach($creatives as $creative){
  3571.             /* Consulta en Control Description */
  3572.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3573.                 'servicesId' => $creative->getId(),
  3574.                 'servicesCat' => $creative->getControlCat()
  3575.             ));
  3576.             //$controlctrlDes->getId();
  3577.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3579.             $data_creative[] = array(
  3580.                 'id' => $creative->getId(),
  3581.                 'title' => $creative->getTitle(),
  3582.                 'controlId' => $controlctrlDes->getId(),
  3583.                 'description' => $description
  3584.             );
  3585.         }
  3587.         /* Gifts */
  3588.         $gifts = $em->getRepository(SupplierGifts::class)->findBySupplierId($id);
  3589.         /* Gifts Description*/
  3590.         $data_gifts = array();
  3591.         foreach($gifts as $gift){
  3593.             /* Consulta en Control Description */
  3594.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3595.                 'servicesId' => $gift->getId(),
  3596.                 'servicesCat' => $gift->getControlCat()
  3597.             ));
  3598.             //$controlctrlDes->getId();
  3599.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3601.             $data_gifts[] = array(
  3602.                 'id' => $gift->getId(),
  3603.                 'name' => $gift->getName(),
  3604.                 'responsible' => $gift->getResponsible(),
  3605.                 'currency' => $gift->getCurrency(),
  3606.                 'price' => $gift->getPrice(),
  3607.                 'commission' => $gift->getCommission(),
  3608.                 'iva' => $gift->getIva(),
  3609.                 'controlId' => $controlctrlDes->getId(),
  3610.                 'description' => $description
  3611.             );
  3612.         }
  3614.         /* Entertainment */
  3615.         $entertainments = $em->getRepository(SupplierEntertainment::class)->findBySupplierId($id);
  3616.         /* Entertainment Description*/
  3617.         $data_entertainment = array();
  3618.         foreach($entertainments as $entertainment){
  3620.             /* Consulta en Control Description */
  3621.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3622.                 'servicesId' => $entertainment->getId(),
  3623.                 'servicesCat' => $entertainment->getControlCat()
  3624.             ));
  3625.             //$controlctrlDes->getId();
  3626.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3628.             $data_entertainment[] = array(
  3629.                 'id' => $entertainment->getId(),
  3630.                 'name' => $entertainment->getName(),
  3631.                 'responsible' => $entertainment->getResponsible(),
  3632.                 'currency' => $entertainment->getCurrency(),
  3633.                 'price' => $entertainment->getPrice(),
  3634.                 'commission' => $entertainment->getCommission(),
  3635.                 'iva' => $entertainment->getIva(),
  3636.                 'controlId' => $controlctrlDes->getId(),
  3637.                 'description' => $description
  3638.             );
  3639.         }
  3641.         /* Others */
  3642.         $otherss = $em->getRepository(SupplierOthers::class)->findBySupplierId($id);
  3643.         /* Others Description*/
  3644.         $data_others = array();
  3645.         foreach($otherss as $others){
  3647.             /* Consulta en Control Description */
  3648.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3649.                 'servicesId' => $others->getId(),
  3650.                 'servicesCat' => $others->getControlCat()
  3651.             ));
  3652.             //$controlctrlDes->getId();
  3653.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3655.             $data_others[] = array(
  3656.                 'id' => $others->getId(),
  3657.                 'name' => $others->getName(),
  3658.                 'responsible' => $others->getResponsible(),
  3659.                 'currency' => $others->getCurrency(),
  3660.                 'price' => $others->getPrice(),
  3661.                 'commission' => $others->getCommission(),
  3662.                 'iva' => $others->getIva(),
  3663.                 'controlId' => $controlctrlDes->getId(),
  3664.                 'description' => $description
  3665.             );
  3666.         }
  3668.         /* technology */
  3669.         if ($idsupplier == 2){          // Es una tecnologia de Develup
  3670. //            $technologys = $em->getRepository(MdvProduct::class)->findAll();
  3672.             // Listamos por orden alfabetico y se deja de primero a "Otro servicio"
  3673.             $parameters = array();
  3674.             $dql = 'SELECT i
  3675.                         FROM DevelupBundle:MdvProduct i
  3676.                         ORDER BY i.name ASC';
  3677.             $query = $em->createQuery($dql)->setParameters($parameters);
  3678.             $technologys = $query->getResult();
  3679.             $newTechnologys = array();
  3681.             foreach ($technologys as $key => $item) {
  3682.                 if ($item->getName() == 'Otro servicio'){
  3683.                     $item->setName('0 - Otro servicio');
  3684.                     $newTechnologys = array($item);
  3685.                     unset($technologys[$key]);
  3686.                     foreach ($technologys as $keyTwo => $elem){
  3687.                         $ind = $keyTwo + 1;
  3688.                         $elem->setName($ind.' - '.$elem->getName());
  3689.                         array_push($newTechnologys,$elem);
  3690.                     }
  3691.                 }
  3692.             }
  3694.             $technologys = $newTechnologys;
  3696.             /* technology Description*/
  3697.             $data_technology = array();
  3698.             foreach($technologys as $technology){
  3700.                 $data_technology[] = array(
  3701.                     'id' => $technology->getId(),
  3702.                     'title' => $technology->getName(),
  3703. //                    'modules' => $technology->getModules(),
  3704.                     'modules' => null,
  3705.                     'type' => $technology->getType(),
  3706.                     'currency' => 'Euro',
  3707.                     'price' => $technology->getPrice(),
  3708.                     'commission' => 0,
  3709.                     'iva' => 21,
  3710.                     'controlId' => null,
  3711.                     'description' => $technology->getDescription(),
  3712.                     'supplier' => 'Develup',
  3713.                 );
  3714.             }
  3716.         } else {
  3717.             $technologys = $em->getRepository(SupplierTechnology::class)->findBySupplierId($id);
  3718.             $newTechnologys = array();
  3720.             /* technology Description*/
  3721.             $data_technology = array();
  3722.             foreach($technologys as $technology){
  3724.                 /* Consulta en Control Description */
  3725.                 $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3726.                     'servicesId' => $technology->getId(),
  3727.                     'servicesCat' => $technology->getControlCat()
  3728.                 ));
  3729.                 //$controlctrlDes->getId();
  3730.                 $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3732.                 $data_technology[] = array(
  3733.                     'id' => $technology->getId(),
  3734.                     'title' => $technology->getTitle(),
  3735.                     'modules' => $technology->getModules(),
  3736.                     'type' => $technology->getType(),
  3737.                     'currency' => $technology->getCurrency(),
  3738.                     'price' => $technology->getPrice(),
  3739.                     'commission' => $technology->getCommission(),
  3740.                     'iva' => $technology->getIva(),
  3741.                     'controlId' => $controlctrlDes->getId(),
  3742.                     'description' => $description
  3743.                 );
  3744.             }
  3745.         }
  3750.         /* Assistant  */
  3751.         $assistants = $em->getRepository(SupplierServicesAssistant::class)->findBySupplierId($id);
  3752.         /* Assistant  Description*/
  3753.         $data_assistant = array();
  3754.         foreach($assistants as $assistant){
  3756.             /* Consulta en Control Description */
  3757.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3758.                 'servicesId' => $assistant->getId(),
  3759.                 'servicesCat' => $assistant->getControlCat()
  3760.             ));
  3761.             //$controlctrlDes->getId();
  3762.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3764.             $data_assistant[] = array(
  3765.                 'id' => $assistant->getId(),
  3766.                 'name' => $assistant->getName(),
  3767.                 'quantity' => $assistant->getQuantity(),
  3768.                 'currency' => $assistant->getCurrency(),
  3769.                 'price' => $assistant->getPrice(),
  3770.                 'commission' => $assistant->getCommission(),
  3771.                 'iva' => $assistant->getIva(),
  3772.                 'controlId' => $controlctrlDes->getId(),
  3773.                 'description' => $description
  3774.             );
  3775.         }
  3779.         /* salida de data */
  3780.         return $this->render('MDS/EventsBundle/services/services-supplier-esp-proposal.html.twig', array(
  3781.             'cdid' => $cdid,
  3782.             'id' => $proposal->getId(),
  3783.             'proname' => $proposal->getName(),
  3784.             'token' => $proposal->getAccessKey(),
  3785.             'mcp' => $proposal->getMcp(),
  3786.             'proposal' => $proposal,
  3787.             'idcontrol' => $idcontrol,
  3788.             'accommodations' => $data_accommodation,
  3789.             'menus' => $data_menu,
  3790.             'lounges' => $data_lounge,
  3791.             'transports' => $data_transport,
  3792.             'guides' => $data_guide,
  3793.             'itineraries' => $data_itineraries,
  3794.             'activities' => $data_activities,
  3795.             'cruises' => $data_cruise,
  3796.             'avs' => $data_av,
  3797.             'creatives' => $data_creative,
  3798.             'gifts' => $data_gifts,
  3799.             'entertainments' => $data_entertainment,
  3800.             'technology' => $data_technology,
  3801.             'newTechnologys' => $newTechnologys,
  3802.             'newAvs' => $newAvs,
  3803.             'assistants' => $data_assistant,
  3804.             'otherss' => $data_others
  3805.         ));
  3806.     }
  3809.     /* CREAR DESDE Discount */
  3810.     private function createDiscountCreateForm(ProposalDiscount $entity)
  3811.     {
  3812.         $form = $this->createForm(ProposalDiscountType::class, $entity, array(
  3813.             'action' => $this->generateUrl('proposal_discount_create'),
  3814.             'method' => 'POST'
  3815.         ));
  3816.         return $form;
  3817.     }
  3819.     /**
  3820.      * @Route("/proposal/discount/create",  name="proposal_discount_create")
  3821.      */
  3822.     public function createDiscountAction(Request $request)
  3823.     {
  3825.         $controlid = $request->request->get('control')['id'];
  3827.         $em = $this->getDoctrine()->getManager();
  3828.         $discount = new ProposalDiscount();
  3829.         $form = $this->createDiscountCreateForm($discount);
  3830.         $form->handleRequest($request);
  3832.         $serviceId = $form->get('serviceId')->getData();
  3833.         if(!is_null($serviceId)){
  3834.             $discount->setServiceId($serviceId->getId());
  3835.         }else{
  3836.             $discount->setServiceId(null);
  3837.         }
  3839.         if($form->isValid())
  3840.         {
  3841.             /* Obtengo usuario logueado */
  3842.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  3843.             $user_id = $user_logueado->getId();
  3845.             $discount->setCreatedId($user_id);
  3846.             $discount->setUpdatedId($user_id);
  3848.             $em->persist($discount);
  3849.             $em->flush();
  3850.         }
  3851.         return $this->redirectToRoute('proposal_destination_supplier_view',
  3852.             array(
  3853.                 'id' => $controlid,
  3854.                 '_fragment' => 'd1'
  3855.             )
  3856.         );
  3857.     }
  3859.     /**
  3860.      * @Route("/proposal/discount/delete/{controlid}/{id}",  name="proposal_discount_delete")
  3861.      */
  3862.     public function deleteDiscountAction($controlid, $id, Request $request)
  3863.     {
  3864.         $em = $this->getDoctrine()->getManager();
  3865.         $delete= $em->getRepository(ProposalDiscount::class)->findOneById($id);
  3867.         $em->remove($delete);
  3868.         $em->flush();
  3870.         return $this->redirectToRoute('proposal_destination_supplier_view',
  3871.             array(
  3872.                 'id' => $controlid
  3873.             )
  3874.         );
  3876.     }
  3878.     /**
  3879.      * @Route("/proposal/fee/create",  name="proposal_fee_create")
  3880.      */
  3881.     public function createFeeAction(Request $request){
  3882.         $controlid = $request->request->get('control')['id'];
  3884.         /* Obtengo usuario logueado */
  3885.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  3886.         $user_id = $user_logueado->getId();
  3888.         $em = $this->getDoctrine()->getManager();
  3889.         $proposalId = $request->request->get('proposal_id');
  3890.         $proposal = $em->getRepository(Proposal::class)->findOneById($proposalId);
  3891.         $oldFee = $em->getRepository(ProposalFee::class)->findOneByProposalId($proposalId);
  3893.         if (!empty($oldFee)){
  3894.             if ($oldFee->getToInvoice() == 0){
  3895.                 // Habia un Fee que se cargo en los servicios
  3896.                 $this->eliminarFeeOculto($oldFee->getId());
  3897.             }
  3899.             $oldFee->setName($request->request->get('nameFee'));
  3900.             $oldFee->setType($request->request->get('typeFee'));
  3901.             $oldFee->setAmount($request->request->get('amountFee'));
  3902.             $oldFee->setToInvoice($request->request->get('toInvoiceFee'));
  3903.             $oldFee->setUpdatedId($user_id);
  3904.             $oldFee->setUpdatedAt(new \DateTime("now"));
  3906.             if ($proposal->getStatus() != 'Invoiced') {
  3907.                 $em->persist($oldFee);
  3908.                 $em->flush();
  3910.                 if(!$oldFee->getToInvoice()){
  3911.                     // Es un Fee oculto se deben modificar los servicios
  3912.                     $this->agregarFeeOculto($oldFee->getId());
  3913.                 }
  3914.             }
  3916.         } else {
  3917.             $newFee = new ProposalFee();
  3918.             $newFee->setProposalId($proposalId);
  3919.             $newFee->setName($request->request->get('nameFee'));
  3920.             $newFee->setType($request->request->get('typeFee'));
  3921.             $newFee->setAmount($request->request->get('amountFee'));
  3922.             $newFee->setToInvoice($request->request->get('toInvoiceFee'));
  3923.             $newFee->setOpIva('1');
  3924.             $newFee->setIva('21');      // Por indicaciones de Esteban siempre sera al 21% el iva del Fee, si se da una excepcion (por ejemplo SUCOE) se modificacara manualmente
  3925.             if ($request->request->get('typeFee') == 0){ $newFee->setFeeTotal(0); } else { $newFee->setFeeTotal($request->request->get('amountFee') * 1.21); }
  3926.             $newFee->setCreatedId($user_id);
  3927.             $newFee->setUpdatedId($user_id);
  3928.             $newFee->setCreatedAt(new \DateTime("now"));
  3929.             $newFee->setUpdatedAt(new \DateTime("now"));
  3931.             // Solo se creará el Fee si no se ha facturado
  3932.             if ($proposal->getStatus() != 'Invoiced') {
  3933.                 $em->persist($newFee);
  3934.                 $em->flush();
  3936.                 if(!$newFee->getToInvoice()){
  3937.                     // Es un Fee oculto se deben modificar los servicios
  3938.                     $this->agregarFeeOculto($newFee->getId());
  3939.                 }
  3940.             }
  3941.         }
  3943.         return $this->redirectToRoute('proposal_destination_supplier_view',
  3944.             array(
  3945.                 'id' => $controlid,
  3946.                 '_fragment' => 'f1'
  3947.             )
  3948.         );
  3949.     }
  3952.     /**
  3953.      * @Route("/proposal/fee/delete/{controlid}/{id}",  name="proposal_fee_delete")
  3954.      */
  3955.     public function deleteFeeAction($controlid, $id, Request $request)
  3956.     {
  3957.         $em = $this->getDoctrine()->getManager();
  3958.         $fee = $em->getRepository(ProposalFee::class)->findOneById($id);
  3960.         if (!empty($fee)){
  3961.             $proposal = $em->getRepository(Proposal::class)->findOneById($fee->getProposalId());
  3963.             if ($fee->getToInvoice() == 0){
  3964.                 // Habia un Fee que se cargo en los servicios
  3965.                 $this->eliminarFeeOculto($fee->getId());
  3966.             }
  3968.             if ($proposal->getStatus() != 'Invoiced') {
  3969.                 $em->remove($fee);
  3970.                 $em->flush();
  3971.             }
  3972.         }
  3974.         return $this->redirectToRoute('proposal_destination_supplier_view',
  3975.             array(
  3976.                 'id' => $controlid,
  3977.                 '_fragment' => 'f1'
  3978.             )
  3979.         );
  3980.     }
  3983.     private function agregarFeeOculto( $idFee )
  3984.     {
  3985.         // Se agregara un fee en los servicios
  3986.         $em = $this->getDoctrine()->getManager();
  3987.         $fee = $em->getRepository(ProposalFee::class)->findOneById($idFee);
  3988.         $prpSupServices = $em->getRepository(ProposalSupplierServices::class)->findByProposalId($fee->getProposalId());
  3990.         foreach ($prpSupServices as $service){
  3992.             if ($fee->getType() == 0){
  3993.                 // Fee de %
  3995.                 if ($service->getOpCommission() == 1){
  3996.                     // La Comision es positiva
  3997.                     $comision = $fee->getAmount() + $service->getCommission();
  3998.                     $service->setCommission($comision);
  3999.                 } else {
  4000.                     // La Comision es negativa, no se puede alterar la comision por ende el porcentaje se calculará y añadirá en el over
  4001.                     $comision = $service->getPrice() * ( $fee->getAmount() / 100 );
  4002.                     $comision = $comision + $service->getOver();
  4003.                     $service->setOver($comision);
  4004.                 }
  4006.                 $em->persist($service);
  4007.                 $em->flush();
  4009.                 // Si es un servicio ya confirmado debemos modificar tambien ProposalSupplierServicesCost y en ProposalSupplierServicesCostClient
  4010.                 $prpSupSrvCosts = $em->getRepository(ProposalSupplierServicesCosts::class)->findOneByServicesId($service->getId());
  4011.                 if (!empty($prpSupSrvCosts)){
  4012.                     $prpSupSrvCosts->setCommission($service->getCommission());
  4014.                     $em->persist($prpSupSrvCosts);
  4015.                     $em->flush();
  4016.                 }
  4018.                 $prpSupSrvCostsClient = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($service->getId());
  4019.                 if (!empty($prpSupSrvCostsClient)){
  4020.                     $prpSupSrvCostsClient->setCommission($service->getCommission());
  4021.                     $prpSupSrvCostsClient->setOver($service->getOver());
  4023.                     $em->persist($prpSupSrvCostsClient);
  4024.                     $em->flush();
  4025.                 }
  4027.             } else {
  4028.                 // Fee de €
  4030.                 if ($service->getOpOver() == 1){
  4031.                     // El Over es positivo
  4032.                     $over = $fee->getAmount() + $service->getOver();
  4033.                     $service->setOver($over);
  4034.                 } else {
  4035.                     // El Over es negativo,
  4036.                     if ($service->getOver() > $fee->getAmount()){
  4037.                         // Se mantendra el signo negativo del over. La cantidad de over negativo es superior al fee que agregamos
  4038.                         $service->setOver($service->getOver() - $fee->getAmount());
  4039.                     } else {
  4040.                         // Se cambiara el signo del over. La cantidad de over negativo es inferior o igual all fee que agregamos
  4041.                         $service->setOver($fee->getAmount() - $service->getOver());
  4042.                         $service->setOpOver(1);
  4043.                     }
  4044.                 }
  4046.                 $em->persist($service);
  4047.                 $em->flush();
  4049.                 // Si es un servicio ya confirmado debemos modificar tambien ProposalSupplierServicesCostClient (NO APLICA EN ProposalSupplierServicesCost)
  4050.                 $prpSupSrvCostsClient = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($service->getId());
  4051.                 if (!empty($prpSupSrvCostsClient)){
  4052.                     $prpSupSrvCostsClient->setOver($service->getOver());
  4054.                     $em->persist($prpSupSrvCostsClient);
  4055.                     $em->flush();
  4056.                 }
  4057.             }
  4059.         }
  4061.         return true;
  4062.     }
  4065.     private function eliminarFeeOculto( $idFee )
  4066.     {
  4067.         // No se eliminara el Fee, solo se quitara el monto de los servicios
  4068.         $em = $this->getDoctrine()->getManager();
  4069.         $fee = $em->getRepository(ProposalFee::class)->findOneById($idFee);
  4070.         $prpSupServices = $em->getRepository(ProposalSupplierServices::class)->findByProposalId($fee->getProposalId());
  4072.         foreach ($prpSupServices as $service){
  4074.             if ($fee->getType() == 0){
  4075.                 // Fee de %
  4077.                 if ($service->getOpCommission() == 1){
  4078.                     // La Comision es positiva
  4079.                     $comision = abs($service->getCommission() - $fee->getAmount());
  4080.                     $service->setCommission($comision);
  4081.                 } else {
  4082.                     // La Comision es negativa, no se puede alterar la comision
  4084.                 }
  4086.                 $em->persist($service);
  4087.                 $em->flush();
  4089.                 // Si es un servicio ya confirmado debemos modificar tambien ProposalSupplierServicesCost y en ProposalSupplierServicesCostClient
  4090.                 $prpSupSrvCosts = $em->getRepository(ProposalSupplierServicesCosts::class)->findOneByServicesId($service->getId());
  4091.                 if (!empty($prpSupSrvCosts)){
  4092.                     $prpSupSrvCosts->setCommission($service->getCommission());
  4094.                     $em->persist($prpSupSrvCosts);
  4095.                     $em->flush();
  4096.                 }
  4098.                 $prpSupSrvCostsClient = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($service->getId());
  4099.                 if (!empty($prpSupSrvCostsClient)){
  4100.                     $prpSupSrvCostsClient->setCommission($service->getCommission());
  4101.                     $prpSupSrvCostsClient->setOver($service->getOver());
  4103.                     $em->persist($prpSupSrvCostsClient);
  4104.                     $em->flush();
  4105.                 }
  4107.             } else {
  4108.                 // Fee de €
  4110.                 if ($service->getOpOver() == 1){
  4111.                     // El Over es positivo
  4112.                     $over = abs($service->getOver() - $fee->getAmount());
  4113.                     $service->setOver($over);
  4114.                 } else {
  4115.                     // El Over es negativo,
  4116.                     if ($service->getOver() > $fee->getAmount()){
  4118.                     } else {
  4120.                     }
  4121.                 }
  4123.                 $em->persist($service);
  4124.                 $em->flush();
  4126.                 // Si es un servicio ya confirmado debemos modificar tambien ProposalSupplierServicesCostClient (NO APLICA EN ProposalSupplierServicesCost)
  4127.                 $prpSupSrvCostsClient = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($service->getId());
  4128.                 if (!empty($prpSupSrvCostsClient)){
  4129.                     $prpSupSrvCostsClient->setOver($service->getOver());
  4131.                     $em->persist($prpSupSrvCostsClient);
  4132.                     $em->flush();
  4133.                 }
  4134.             }
  4136.         }
  4138.         return true;
  4139.     }
  4142.     /**
  4143.      * @Route("/proposal/summary/create",  name="proposal_summary_create")
  4144.      */
  4145.     public function createSummaryAction(Request $request){
  4146.         $controlid = $request->request->get('control')['id'];
  4148.         $em = $this->getDoctrine()->getManager();
  4149.         $proposalId = $request->request->get('proposal_id');
  4150.         $proposal = $em->getRepository(Proposal::class)->findOneById($proposalId);
  4151.         $oldSummary = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($proposalId);
  4152.         $newSummary = $request->request->get('descriptionSummary');
  4154.         if (!empty($oldSummary)){
  4155.             if (!empty($newSummary) and ($proposal->getStatus() != 'Invoiced')){
  4156.                 $oldSummary->setDescription($newSummary);
  4157.                 $em->persist($oldSummary);
  4158.                 $em->flush();
  4159.             } else {
  4160.                 if (empty($newSummary) and ($proposal->getStatus() != 'Invoiced')){
  4161.                     // Si viene vacío se elimina el resumen para obetener una factura completa
  4162.                     $em->remove($oldSummary);
  4163.                     $em->flush();
  4164.                 }
  4165.             }
  4166.         } else {
  4167.             $newSumm = new ProposalsInvoiceSummary();
  4168.             $newSumm->setDescription($newSummary);
  4169.             $newSumm->setProposalId($proposalId);
  4170.             $newSumm->setNet(null);
  4171.             $newSumm->setCurrency(null);
  4172.             $newSumm->setVatTen(null);
  4173.             $newSumm->setVatTwentyOne(null);
  4174.             $newSumm->setPayments(null);
  4176.             // Solo se creará el Summary si no se ha facturado
  4177.             if (($proposal->getStatus() != 'Invoiced') and !empty($newSummary)) {
  4178.                 $em->persist($newSumm);
  4179.                 $em->flush();
  4180.             }
  4181.         }
  4183.         return $this->redirectToRoute('proposal_destination_supplier_view',
  4184.             array(
  4185.                 'id' => $controlid,
  4186.                 '_fragment' => 'summary1'
  4187.             )
  4188.         );
  4189.     }
  4192.     /**
  4193.      * @Route("proposal/destination/services/block/{id}", name="proposal_destination_supplier_services_block")
  4194.      */
  4195.     public function udatedBlockAction($id, Request $request)
  4196.     {
  4198.         $block = $request->request->get('block');
  4199.         $em = $this->getDoctrine()->getManager();
  4200.         $services_control = $em->getRepository(ProposalSupplierControl::class)->findOneById($id);
  4202.         if (!empty($block['dateBlockLimit']) and !empty($block['timeBlockLimit'])){
  4203.             $services_control->setDateBlockLimit(new \DateTime($block['dateBlockLimit'].' '.$block['timeBlockLimit'] ));
  4205.             $services_supplier_proposal = $em->getRepository(ProposalSupplierServices::class)->findByControlId($services_control->getId());
  4206.             foreach($services_supplier_proposal as $servicessupplierproposal) {
  4207.                 $servicessupplierproposal->setDateBlockLimit(new \DateTime($block['dateBlockLimit'] . ' ' . $block['timeBlockLimit']));
  4208.                 $servicessupplierproposal->setStatus('Block');
  4209.                 $em->persist($servicessupplierproposal);
  4210.                 $em->flush();
  4211.             }
  4213.             $em->persist($services_control);
  4214.             $em->flush();
  4216.             $event = 'The Block supplier updated in Destination Proposal.';
  4217.             $successMessage = $this->translator->trans($event);
  4218.             $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  4220.         }else{
  4221.             $errorMessage = $this->translator->trans('Error');
  4222.             $this->addFlash('mensajeproposaldestinationservicesrror', $errorMessage);
  4223.         }
  4225.         return $this->redirectToRoute('proposal_destination_supplier_view',
  4226.             array(
  4227.                 'id' => $services_control->getControlDestinationId(),
  4228.                 '_fragment' => 's'.$id
  4229.             )
  4230.         );
  4233.     }
  4235.     /**
  4236.      * @Route("/multichckservices", name="multichckservices")
  4237.      */
  4238.     public function multiChckServicesAction(Request $request) {
  4240.         $idSupplier = $_POST['idSupplier'];
  4241.         $idService = $_POST['idService'];
  4243.         /* Obtengo usuario logueado */
  4244.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  4245.         $user_id = $user_logueado->getId();
  4246.         $user_role = $user_logueado->getRole();
  4248.         $em = $this->getDoctrine()->getManager();
  4249.         $services = $em->getRepository(ProposalSupplierServices::class)->findOneById($idService);
  4251.         // INICIO: Buscamos el proposal para verificar que no este bloqueado o facturado
  4252.         $propId = $services->getProposalId();
  4253.         $proposal = $em->getRepository(Proposal::class)->findOneById($propId);
  4255.         // FIN :Buscamos el proposal para verificar que no este bloqueado o facturado
  4257.         if (!empty($services)){
  4258.             if ($services->getStatus()== 'Pending') {
  4259.                 $services->setStatus('Confirmed');
  4260.                 $services->setUpdatedId($user_id);
  4261.             } else {
  4262.                 $services->setStatus('Pending');
  4263.                 $services->setUpdatedId($user_id);
  4264.             }
  4266.             try{
  4267.                 if (!empty($proposal)){
  4268.                     if (($proposal->getStatus() == 'Invoiced') or ($proposal->getStatus() == 'Blocked')) {
  4269.                         // De ser un expediente Facturado o bloqueado no se hace modificacion
  4270.                     } else {
  4271.                         if (empty($services->getSupplierId())){
  4272.                             $services->setSupplierId(4);
  4273.                         }
  4275.                         $em->persist($services);
  4276.                         $em->flush();
  4278.                         /* Para dentro de ProposalSupplierControl */
  4279.                         if (!empty($services->getSupplierId())){
  4280.                             $controlctrlDes = $em->getRepository(ProposalSupplierControl::class)->findOneBy( array(
  4281.                                 'supplierId' => $services->getSupplierId(),
  4282.                                 'proposalId' => $services->getProposalId()
  4283.                             ));
  4284.                         } else {
  4285.                             $controlctrlDes = $em->getRepository(ProposalSupplierControl::class)->findOneBy( array(
  4286.                                 'supplierId' => 4,
  4287.                                 'proposalId' => $services->getProposalId()
  4288.                             ));
  4289.                         }
  4291. //                         Si el control se encuentra vacio, se debe crear uno nuevo
  4292.                         if (empty($controlctrlDes)){
  4293.                             $controlctrlDes = new ProposalSupplierControl();
  4294.                             $controlctrlDes->setControlDestinationId($services->getDestinationId());  // Falta corregir el ControlDestinationId ahora tiene el Id del destino
  4295.                             $controlctrlDes->setProposalId($services->getProposalId());
  4296.                             $controlctrlDes->setDestinoId($services->getDestinationId());
  4297.                             $controlctrlDes->setSupplierId(4);
  4298.                             $controlctrlDes->setStatus('Pending');
  4300.                             $em->persist($controlctrlDes);
  4301.                             $em->flush();
  4302.                         }
  4304.                         //COLOR POR SERVICIO
  4305.                         $contcolor ="";
  4306.                         switch ($services->getServiceCatName()) {
  4307.                             case "Accommodation":
  4308.                                 $contcolor = 'teal';
  4309.                                 break;
  4310.                             case "Menu" :
  4311.                                 $contcolor = 'purple';
  4312.                                 break;
  4313.                             case "Lounge":
  4314.                                 $contcolor = 'warning';
  4315.                                 break;
  4316.                             case "Activities":
  4317.                                 $contcolor = 'blue';
  4318.                                 break;
  4319.                             case "Itineraries":
  4320.                                 $contcolor = 'indigo';
  4321.                                 break;
  4322.                             case "Cruise":
  4323.                                 $contcolor = 'brown';
  4324.                                 break;
  4325.                             case "Transport":
  4326.                                 $contcolor = 'grey';
  4327.                                 break;
  4328.                             case "Av":
  4329.                                 $contcolor = 'slate';
  4330.                                 break;
  4331.                             case "Creative":
  4332.                                 $contcolor = 'orange';
  4333.                                 break;
  4334.                             case "Gifts":
  4335.                                 $contcolor = 'pink';
  4336.                                 break;
  4337.                             case "Entertainment":
  4338.                                 $contcolor = 'green';
  4339.                                 break;
  4340.                             case "Guide":
  4341.                                 $contcolor = 'orange';
  4342.                                 break;
  4343.                             case "Others":
  4344.                                 $contcolor = 'danger';
  4345.                                 break;
  4346.                             case "Technology":
  4347.                                 $contcolor = 'slate-800';
  4348.                                 break;
  4349.                             case "Assistant":
  4350.                                 $contcolor = 'indigo-800';
  4351.                                 break;
  4352.                             case "DDR":
  4353.                                 $contcolor = 'green-300';
  4354.                                 break;
  4355.                         }
  4357.                         /* Para dentro de ProposalSupplierServicesCostsClient */
  4358.                         $costsClient = new ProposalSupplierServicesCostsClient();
  4359.                         $costsClient->setServiceIdProposal($services->getId());
  4360.                         $costsClient->setServiceIdFather($services->getServiceIdFather());
  4362.                         $costsClient->setControlId($controlctrlDes->getId());
  4363. //                        if (empty($services->getSupplierId())){$costsClient->setControlId(14244);} else {$costsClient->setControlId($services->getControlId());}
  4365.                         $costsClient->setProposalId($services->getProposalId());
  4366.                         $costsClient->setDestinationId($services->getDestinationId());
  4367.                         if (empty($services->getSupplierId())){$costsClient->setSupplierId('4');} else {$costsClient->setSupplierId($services->getSupplierId());}
  4368.                         $costsClient->setAssistantId($services->getAssistantId());
  4369.                         $costsClient->setIdeaId($services->getIdeaId());
  4370.                         $costsClient->setActivityId($services->getActivityId());
  4371.                         $costsClient->setServiceId($services->getServiceId());
  4372.                         $costsClient->setServiceCatId($services->getServiceCatId());
  4373.                         $costsClient->setServiceCatName($services->getServiceCatName());
  4374.                         $costsClient->setName($services->getName());
  4375.                         $costsClient->setPrice($services->getPrice());
  4376.                         $costsClient->setCurrency($services->getCurrency());
  4377.                         $costsClient->setUnits($services->getUnits());
  4378.                         $costsClient->setOpCommission($services->getOpCommission());
  4379.                         $costsClient->setCommission($services->getCommission());
  4380.                         $costsClient->setOpOver($services->getOpOver());
  4381.                         $costsClient->setOver($services->getOver());
  4382.                         $costsClient->setOpIva($services->getOpIva());
  4383.                         $costsClient->setIva($services->getIva());
  4384.                         $costsClient->setPax($services->getPax());
  4385.                         $costsClient->setHour($services->getHour());
  4386.                         $costsClient->setDateInAt($services->getDateInAt());
  4387.                         $costsClient->setDateOutAt($services->getDateOutAt());
  4388.                         $costsClient->setRank($services->getRank());
  4389.                         $costsClient->setCreatedId($user_id);
  4390.                         $costsClient->setUpdatedId($user_id);
  4391.                         $costsClient->setContcolor($contcolor);
  4392.                         $costsClient->setRenovate('0');
  4393.                         $em->persist($costsClient);
  4394.                         $em->flush();
  4395.                     }
  4396.                 }
  4397.             } catch (\Exception $e){
  4399.             }
  4400.         }
  4402.         $return = array(
  4403.             'services' => $services,
  4404.         );
  4406.         $response = new JsonResponse($return);
  4407.         return $response;
  4408.     }
  4411.     /**
  4412.      * @Route("proposal/destination/services/listmultiple/{idcontrol}", name="proposal_destination_supplier_list_multiple")
  4413.      */
  4414.     public function listMultipleAction($idcontrol, Request $request) {
  4415.         $em = $this->getDoctrine()->getManager();
  4416.         $control = $em->getRepository(ProposalSupplierControl::class)->findOneById($idcontrol);
  4417.         $idsupplier = $control->getSupplierId();
  4418.         $idMemorySupplier = $idsupplier;
  4419.         $ididea = $control->getIdeaId();
  4420.         $idactivity = $control->getActivityId();
  4422.         if($idsupplier == '0'){
  4423.             $id = '0';
  4424.         }else{
  4425.             if(!empty($idsupplier)){
  4426.                 /*CONTROL GENERAL*/
  4427.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneBySupplierId($idsupplier);
  4428.                 $id = $controlgeneral->getId();
  4429.             }
  4430.             if(!empty($idactivity)){
  4431.                 /*CONTROL GENERAL*/
  4432.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByActivityId($idactivity);
  4433.                 $id = $controlgeneral->getId();
  4434.             }
  4435.             if(!empty($ididea)){
  4436.                 /*CONTROL GENERAL*/
  4437.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByIdeaId($ididea);
  4438.                 $id = $controlgeneral->getId();
  4439.             }
  4440.         }
  4442.         if (!empty($control)){
  4443.             $idProposal = $control->getProposalId();
  4444.             $proposal = $em->getRepository(Proposal::class)->findOneById($idProposal);
  4446.             // Buscamos a partir del IDCONTROL los elementos principales (Proveedores, Actividades, Ideas) agregados al destino para la carga multiple
  4447.             $destinoId = $control->getDestinoId();
  4449.             $servicesControllers = $em->getRepository(ProposalSupplierControl::class)->findBy(
  4450.                 array(
  4451.                     'proposalId' => $proposal,
  4452.                     'destinoId' => $destinoId
  4453.                 )
  4454.             );
  4456.             //INICIO: Asignamos al campo Status (ya que no se usa) el Nombre del proveedor, tambien buscamos el control que apunta a los white services para ponerlo de ultimo
  4457.             $tempKey = null;
  4458.             $logicKey = false;
  4459.             foreach ($servicesControllers as $key => $item) {
  4460.                 if(($item->getSupplierId() == 0) and (empty($item->getActivityId())) and (empty($item->getIdeaId()))){
  4461.                     // Es un white service, se guarda el indice para luego procesar
  4462.                     $tempKey = $key;
  4463.                     $logicKey = true;
  4464.                 }
  4466.                 if(!empty($item->getSupplierId()) and ($item->getSupplierId() != 0)){
  4467.                     // Es un proveedor ordinario
  4468.                     $tempSup = $em->getRepository(Supplier::class)->findOneById($item->getSupplierId());
  4469.                     $servicesControllers[$key]->setStatus($tempSup->getName());
  4470.                 }
  4472.                 if (!empty($item->getActivityId())){
  4473.                     // Es Actividad
  4474.                     $tempAct = $em->getRepository(Activities::class)->findOneById($item->getActivityId());
  4475.                     $servicesControllers[$key]->setStatus($tempAct->getName());
  4476.                 }
  4478.                 if (!empty($item->getIdeaId())) {
  4479.                     // Es Idea
  4480.                     $tempIdea = $em->getRepository(Ideas::class)->findOneById($item->getIdeaId());
  4481.                     $servicesControllers[$key]->setStatus($tempIdea->getName());
  4482.                 }
  4483.             }
  4485.             if($logicKey){
  4486.                 $servicesControllers[$tempKey]->setStatus('SERVICIO SIN PROVEEDOR');
  4487.                 array_push($servicesControllers,$servicesControllers[$tempKey]);
  4488.                 unset($servicesControllers[$tempKey]);
  4489.             }
  4490.             //FIN: Asignamos al campo Status (ya que no se usa) el Nombre dle proveedor, tambien buscamos el control que apunta a los white services para ponerlo de ultimo
  4491.         }
  4493. //        LIMPIEZA DE DATOS PARA LA VISTA
  4494.         if (!($idMemorySupplier === 0)){// el === evalua correctamente el caso de nulo
  4496.             $newServicesControllers = array();
  4497.             foreach ($servicesControllers as $item){
  4498.                 if (intval($idcontrol) === $item->getId()){
  4499.                     $newServicesControllers[] = $item;
  4500.                 }
  4501.             }
  4502.             $servicesControllers = $newServicesControllers;
  4503.         }
  4505.         if (sizeof($servicesControllers) == 1){
  4506.             $numElementos = 10;
  4507.         } else {
  4508.             $numElementos = 5;
  4509.         }
  4511.         /* salida de data */
  4512.         return $this->render('MDS/EventsBundle/services/services-multiple-modal-proposal.html.twig', array(
  4513. //        return $this->render('MDS/EventsBundle/services/services-multiple-add-destination-proposal.html.twig', array(
  4514.             'idcontrol' => $idcontrol,
  4515.             'servicesControllers' => $servicesControllers,
  4516.             'id' => $idProposal,
  4517.             'proposal' => $proposal,
  4518.             'numElementos' => $numElementos,
  4519.             'token' => $proposal->getAccessKey(),
  4520.             'mcp' => null,
  4521.             'datasupplier' => null,
  4522.             'discounts' => null,
  4523.             'status' => null,
  4524.             'global_calculos' => null,
  4525.             'accommodations' => '',
  4526.             'menus' => '',
  4527.             'lounges' => '',
  4528.             'transports' => '',
  4529.             'guides' => '',
  4530.             'itineraries' => '',
  4531.             'activities' => '',
  4532.             'cruises' => '',
  4533.             'avs' => '',
  4534.             'creatives' => '',
  4535.             'gifts' => '',
  4536.             'entertainments' => '',
  4537.             'technology' => '',
  4538.             'assistants' => '',
  4539.             'otherss' => ''
  4540.         ));
  4541.     }
  4544.     /**
  4545.      * @Route("proposal/destination/services/createmultiple", name="proposal_destination_supplier_create_multiple")
  4546.      */
  4547.     public function createMultipleAction(Request $request) {
  4549.         $add_services_multiple_type = $request->request->get('add_services_multiple_type');
  4550.         $add_services_multiple_name = $request->request->get('add_services_multiple_name');
  4551.         $add_services_multiple_price = $request->request->get('add_services_multiple_price');
  4552.         $add_services_multiple_commission = $request->request->get('add_services_multiple_commission');
  4553.         $add_services_multiple_over = $request->request->get('add_services_multiple_over');
  4554.         $add_services_multiple_iva = $request->request->get('add_services_multiple_iva');
  4556.         $em = $this->getDoctrine()->getManager();
  4558.         /* Obtengo usuario logueado */
  4559.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  4560.         $user_id = $user_logueado->getId();
  4563.         // INICIO: Generamos un arreglo con todos los servicios a agregar
  4564.         $newServices = array();
  4566.         foreach ($add_services_multiple_type as $key1 => $item) {
  4568.             foreach ($item as $key2 => $elem){
  4570.                 $newServ = new ProposalSupplierServices();
  4571.                 $newServ->setControlId($key1);
  4572.                 $controlTemp = $em->getRepository(ProposalSupplierControl::class)->findOneById($key1);
  4573.                 $proposal_data = $em->getRepository(Proposal::class)->findOneById($controlTemp->getProposalId());
  4575.                 switch ($elem['type']) {
  4576.                     case 1:
  4577.                         $newServ->setServiceCatId('1');
  4578.                         $newServ->setServiceCatName('Accommodation');
  4579.                         break;
  4580.                     case 2:
  4581.                         $newServ->setServiceCatId('2');
  4582.                         $newServ->setServiceCatName('Activities');
  4583.                         break;
  4584.                     case 3:
  4585.                         $newServ->setServiceCatId('3');
  4586.                         $newServ->setServiceCatName('Av');
  4587.                         break;
  4588.                     case 4:
  4589.                         $newServ->setServiceCatId('4');
  4590.                         $newServ->setServiceCatName('Creative');
  4591.                         break;
  4592.                     case 5:
  4593.                         $newServ->setServiceCatId('5');
  4594.                         $newServ->setServiceCatName('Cruise');
  4595.                         break;
  4596.                     case 6:
  4597.                         $newServ->setServiceCatId('6');
  4598.                         $newServ->setServiceCatName('Entertainment');
  4599.                         break;
  4600.                     case 7:
  4601.                         $newServ->setServiceCatId('7');
  4602.                         $newServ->setServiceCatName('Gifts');
  4603.                         break;
  4604.                     case 8:
  4605.                         $newServ->setServiceCatId('8');
  4606.                         $newServ->setServiceCatName('Guide');
  4607.                         break;
  4608.                     case 9:
  4609.                         $newServ->setServiceCatId('9');
  4610.                         $newServ->setServiceCatName('Itineraries');
  4611.                         break;
  4612.                     case 10:
  4613.                         $newServ->setServiceCatId('10');
  4614.                         $newServ->setServiceCatName('Lounge');
  4615.                         break;
  4616.                     case 11:
  4617.                         $newServ->setServiceCatId('11');
  4618.                         $newServ->setServiceCatName('Menu');
  4619.                         break;
  4620.                     case 12:
  4621.                         $newServ->setServiceCatId('12');
  4622.                         $newServ->setServiceCatName('Others');
  4623.                         break;
  4624.                     case 13:
  4625.                         $newServ->setServiceCatId('13');
  4626.                         $newServ->setServiceCatName('Transport');
  4627.                         break;
  4628.                     case 14:
  4629.                         $newServ->setServiceCatId('14');
  4630.                         $newServ->setServiceCatName('Technology');
  4631.                         break;
  4632.                     case 15:
  4633.                         $newServ->setServiceCatId('15');
  4634.                         $newServ->setServiceCatName('Assistant');
  4635.                         break;
  4636.                     case 16:
  4637.                         $newServ->setServiceCatId('16');
  4638.                         $newServ->setServiceCatName('DDR');
  4639.                         break;
  4640.                     case 17:
  4641. //                        $newServ->setServiceCatId('17');
  4642. //                        $newServ->setServiceCatName('AV - EXPRESS');
  4643. //                        $newServ->setSupplierId('80');
  4644. //
  4645. //                        $control = new ProposalSupplierControl();
  4646. //                        $control->setSupplierId('80');
  4647. //                        $control->setStatus('Pending');
  4648. //                        $control->setControlDestinationId($cid);
  4649. //                        $control->setProposalId($pid);
  4650. //                        $control->setDestinoId($did);
  4651. //                        $em->persist($control);
  4652. //                        $em->flush();
  4653. //                        $event = 'The Supplier Destination Proposal has been created.';
  4654. //                        $successMessage = $this->translator->trans($event);
  4655. //                        $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  4656. //
  4657. //                        return $this->redirectToRoute('proposal_destination_supplier_list', array(
  4658. //                            'idcontrol' => $cid
  4659. //                        ));
  4661.                         $newServ->setServiceCatId('');
  4662.                         $newServ->setServiceCatName('');
  4663.                         break;
  4664.                     default:
  4665.                         $newServ->setServiceCatId('');
  4666.                         $newServ->setServiceCatName('');
  4667.                         break;
  4668.                 }
  4670.                 $newServ->setName($add_services_multiple_name[$key1][$key2]['name']);
  4671. //                $newServ->setPrice($add_services_multiple_price[$key1][$key2]['price']);
  4673.                 if (empty($add_services_multiple_price[$key1][$key2]['price'])){
  4674.                     // Se pone el precio a 0 si viene vacio
  4675.                     $newServ->setPrice('0');
  4676.                 } else {
  4677.                     $newServ->setPrice($add_services_multiple_price[$key1][$key2]['price']);
  4678.                 }
  4680.                 if (empty($add_services_multiple_commission[$key1][$key2]['commission'])){
  4681.                     // Se pone la commission en 0 si viene vacio
  4682.                     $newServ->setCommission('0');
  4683.                 } else {
  4684.                     $newServ->setCommission($add_services_multiple_commission[$key1][$key2]['commission']);
  4685.                 }
  4687.                 if (empty($add_services_multiple_over[$key1][$key2]['over'])){
  4688.                     // Se pone el over en 0 si viene vacio
  4689.                     $newServ->setOver('0');
  4690.                 } else {
  4691.                     $newServ->setOver($add_services_multiple_over[$key1][$key2]['over']);
  4692.                 }
  4694.                 if (empty($add_services_multiple_iva[$key1][$key2]['iva'])){
  4695.                     // Se pone el iva a 21% si viene vacio
  4696.                     $newServ->setIva('21');
  4697.                 } else {
  4698.                     $newServ->setIva($add_services_multiple_iva[$key1][$key2]['iva']);
  4699.                 }
  4700.                 $newServ->setProposalId($controlTemp->getProposalId());
  4701.                 $newServ->setDestinationId($controlTemp->getDestinoId());
  4702.                 $newServ->setSupplierId($controlTemp->getSupplierId());
  4703.                 $newServ->setIdeaId($controlTemp->getIdeaId());
  4704.                 $newServ->setActivityId($controlTemp->getActivityId());
  4706.                 /* NAMEJO DE ADICIONALES EN EL DIA DEL EVENTO O DESPUES EL DIA DEL EVENTO */
  4707.                 $dayEvent = $proposal_data->getDateEventStarAt()->format('Y-m-d');
  4708.                 $today = date('Y-m-d');
  4709.                 if( $today >= $dayEvent){
  4710.                     $additional = "Additional";
  4711.                 }else{
  4712.                     $additional = "Normal";
  4713.                 }
  4715.                 $newServ->setCurrency('Euro');
  4716.                 $newServ->setUnits('1');
  4717.                 $newServ->setPax('0');
  4718.                 $newServ->setServiceId(0);
  4719.                 //$newServ->setHour('');//null
  4720.                 //$newServ->setDateInAt('');
  4721.                 //$newServ->setDateOutAt('');
  4722.                 $newServ->setDirectPayment('0');
  4723.                 $newServ->setStatus('Pending');
  4724.                 $newServ->setStatusinternal($additional);
  4725.                 $newServ->setDateInAt($proposal_data->getDateEventStarAt());
  4726.                 $newServ->setDateOutAt($proposal_data->getDateEventEndAt());
  4727.                 $newServ->setCreatedId($user_id);
  4728.                 $newServ->setUpdatedId($user_id);
  4730.                 $newServices[] = $newServ;
  4731.             }
  4732.         }
  4733.         // Eliminamos servicios sin tipo
  4734.         $arrayNewServ = array();
  4735.         foreach ($newServices as $item) {
  4736.             if (!empty($item->getServiceCatName())){   //setServiceCatName
  4737.                 $arrayNewServ[] = $item;
  4738.             }
  4739.         }
  4740.         // FIN: Generamos un arreglo con todos los servicios a agregar
  4742.         foreach ($arrayNewServ as $item){
  4743.             $em->persist($item);
  4744.             $em->flush();
  4746.             //INICIO: Replicacion en Develup
  4747.             if ($item->getSupplierId()==2){
  4748.                 // Nombre del agente
  4749.                 $agenteFullName = $em->getRepository(User::class)->findOneById($user_id);
  4750.                 $agenteFullName = $agenteFullName->getName() . ' ' . $agenteFullName->getLastName();
  4751.                 $proposalTitle = $em->getRepository(Proposal::class)->findOneById($item->getProposalId());
  4753.                 if ($item->getSupplierId()==2){
  4754.                     $originalServiceName = $em->getRepository(MdvProduct::class)->findOneById(1); // Id de "Otro Servicio"
  4756.                     $budget = new MdvBudgetPending();
  4757.                     $budget->setActivityId($item->getActivityId());
  4758.                     $budget->setAssistantId($item->getAssistantId());
  4759.                     $budget->setBreakdown($item->getBreakdown());
  4760.                     $budget->setCommission($item->getCommission());
  4761.                     $budget->setControlId($item->getControlId());
  4762.                     $budget->setOriginId($item->getId());
  4763.                     $budget->setCurrency($item->getCurrency());
  4764.                     $budget->setDateBlockLimit($item->getDateBlockLimit());
  4765.                     $budget->setDateInAt($item->getDateInAt());
  4766.                     $budget->setDateOutAt($item->getDateOutAt());
  4767.                     $budget->setDestinationId($item->getDestinationId());
  4768.                     $budget->setDirectPayment($item->getDirectPayment());
  4769.                     $budget->setHour($item->getHour());
  4770.                     $budget->setIdeaId($item->getIdeaId());
  4771.                     $budget->setIsFather($item->getIsFather());
  4772.                     $budget->setIva($item->getIva());
  4774.                     if(!($originalServiceName->getName() == $item->getName())){
  4775.                         $budget->setName($originalServiceName->getName().' (:'. $item->getName().':)');
  4776.                     } else {
  4777.                         $budget->setName($originalServiceName->getName());
  4778.                     }
  4780.                     $budget->setOpCommission($item->getOpCommission());
  4781.                     $budget->setOpIva($item->getOpIva());
  4782.                     $budget->setOpOver($item->getOpOver());
  4783.                     $budget->setOriginalIva($item->getOriginalIva());
  4784.                     $budget->setOriginalopIva($item->getOriginalopIva());
  4785.                     $budget->setOriginalPrice($item->getOriginalPrice());
  4786.                     $budget->setOver($item->getOver());
  4787.                     $budget->setPax($item->getPax());
  4788.                     $budget->setPreCommission($item->getPreCommission());
  4789.                     $budget->setPreIva($item->getPreIva());
  4790.                     $budget->setPrice($item->getPrice());
  4791.                     $budget->setProposalId($item->getProposalId());
  4792.                     $budget->setRank($item->getRank());
  4793.                     $budget->setServiceCatId($item->getServiceCatId());
  4794.                     $budget->setServiceCatName($item->getServiceCatName());
  4795. //                    $budget->setServiceId($item->getServiceId());
  4796.                     $budget->setServiceId(1);       // ID de "Otro Servicio"
  4797.                     $budget->setServiceIdFather($item->getServiceIdFather());
  4798.                     $budget->setStatus($item->getStatus());
  4799.                     $budget->setStatusinternal($item->getStatusinternal());
  4800.                     $budget->setStatusRec($item->getStatusRec());
  4801.                     $budget->setSupplierId($item->getSupplierId());
  4802.                     $budget->setUnits($item->getUnits());
  4804.                     $budget->setUserConfirmedFullName($agenteFullName);
  4805.                     $budget->setUserConfirmedId($user_id);
  4806.                     $budget->setProposalTitle($proposalTitle->getTitle());
  4808.                     $budget->setCreatedAt(new \DateTime("now"));
  4809.                     $budget->setCreatedId($user_id);
  4810.                     $budget->setUpdatedId($user_id);
  4811.                     $budget->setUpdatedAt(new \DateTime("now"));
  4813.                     // INIICO: Llenamos el tooltip con la info del proposal
  4814.                     $texto = null;
  4815.                     if (!empty($budget->getProposalId())){
  4816.                         $prop = $em->getRepository(Proposal::class)->findOneById($budget->getProposalId());
  4817.                         if (!empty($prop)){
  4818.                             $client = $em->getRepository(Client::class)->findOneById($prop->getClientId());
  4819.                             $clientContact = $em->getRepository(ClientContact::class)->findOneById($prop->getContactId());
  4821.                             $contacto = null;
  4822.                             if (!empty($clientContact->getName())){$contacto = $contacto. $clientContact->getName(). ' ';}
  4823.                             if (!empty($clientContact->getLastName())){$contacto = $contacto. $clientContact->getLastName(). ' ';}
  4824.                             if (!empty($clientContact->getEmail())){$contacto = $contacto. '('.$clientContact->getEmail().')'. ' ';}
  4825.                             if (!empty($clientContact->getPhone())){$contacto = $contacto. ' - '.$clientContact->getPhone(). ' ';}
  4826.                             if (!empty($clientContact->getMobile())){$contacto = $contacto. ' - '.$clientContact->getMobile();}
  4828.                             $city = $em->getRepository(Destination::class)->findOneById($budget->getDestinationId());
  4829.                             $texto = $texto .'Petición: '.$budget->getCreatedAt()->format('d/m/Y'). ' -- ';
  4830.                             if (!empty($client)){$texto = $texto .'Cliente: '.$client->getName(). ' -- ';}
  4831.                             if (!empty($prop->getPax())){$texto = $texto .'Personas: '.$prop->getPax(). ' -- ';}
  4832.                             $texto = $texto .'Desde: '.$prop->getDateEventStarAt()->format('d/m/Y').' Hasta: '.$prop->getDateEventEndAt()->format('d/m/Y'). ' -- ';
  4833.                             $texto = $texto .'Horario: '.$item->getDateInAt()->format('H:i'). ' a '.$item->getDateOutAt()->format('H:i'). ' -- ';
  4834.                             $texto = $texto .'Ciudad: '.$city->getTitle(). ' -- ';
  4835.                             $texto = $texto .'Contacto: '. $contacto;
  4836.                             $budget->setTextTooltip($texto);
  4837.                         }
  4838.                     }
  4839.                     // FIN: Llenamos el tooltip con la info del proposal
  4841.                     $em->persist($budget);
  4842.                     $em->flush();
  4844.                     //INICIO: Enviamos Telegram
  4845.                     //INICIO: Buscamos el creador del expediente asociado al proposal, si no hay se le envia al jefe de grupo (Jorge)
  4846.                     $file = $em->getRepository(MdvFiles::class)->findOneByIdProposal($prop->getId());
  4847.                     if(!empty($file)){
  4848.                         //Se envia el mensaje al creador del expediente
  4849.                         $userTelegramId = $file->getCreatedId();
  4850.                     } else {
  4851.                         // Solicitud sin expediente, se le notificara la jefe de departamento
  4852.                         $userTelegramId = 5; // Id de Jorge
  4853.                     }
  4855.                     //FIN: Buscamos el creador del expediente asociado al proposal, si no hay se le envia al jefe de grupo (Jorge)
  4857.                     //Buscamos el nombre del destino
  4858.                     $nombreDestino = $em->getRepository(Destination::class)->findOneById($budget->getDestinationId());
  4859.                     $nombreDestino = $nombreDestino->getTitle();
  4861.                     //Mensaje:
  4862.                     //SOLICITUD DE PRESUPUESTO __ ID: '.$budget->getProposalId().' __ DESTINO: '.$nombreDestino.' __ PROVEEDOR: In Out Travel __ CONTACTO: '.$budget->getUserConfirmedFullName()
  4863.                     $this->sendTelegram($userTelegramId,'SOLICITUD DE PRESUPUESTO (MultiService) __ ID: '.$budget->getProposalId().' __ DESTINO: '.$nombreDestino.' __ PROVEEDOR: In Out Travel __ CONTACTO: '.$budget->getUserConfirmedFullName());
  4864. //                            d($userTelegramId,'SOLICITUD DE PRESUPUESTO __ ID: '.$budget->getProposalId().' __ DESTINO: '.$nombreDestino.' __ PROVEEDOR: In Out Travel __ CONTACTO: '.$budget->getUserConfirmedFullName());exit();
  4865.                     //FIN: Enviamos Telegram
  4866.                 }
  4867.             }
  4868.             //FIN: Replicacion en Develup
  4870.         }
  4872.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  4873.             'id' => $controlTemp->getControlDestinationId(),
  4874.         ));
  4875.     }
  4878.     /**
  4879.      * @Route("proposal/destination/services/saveallservices/{id}", name="proposal_destination_supplier_saveallservices")
  4880.      */
  4881.     public function saveAllServicesAction($id, Request $request) {
  4883.         $save_services_multiple_name = $request->request->get('services_hidden_name');
  4884.         $save_services_multiple_rank = $request->request->get('services_hidden_rank');
  4885.         $save_services_multiple_price = $request->request->get('services_hidden_price');
  4886.         $save_services_multiple_units = $request->request->get('services_hidden_units');
  4887.         $save_services_multiple_pax = $request->request->get('services_hidden_pax');
  4888.         $save_services_multiple_commission = $request->request->get('services_hidden_commission');
  4889.         $save_services_multiple_over = $request->request->get('services_hidden_over');
  4890.         $save_services_multiple_iva = $request->request->get('services_hidden_iva');
  4891.         $save_services_multiple_originalPrice = $request->request->get('services_hidden_originalPrice');
  4892.         $save_services_multiple_originalIva = $request->request->get('services_hidden_originalIva');
  4893.         $save_services_multiple_supplier = $request->request->get('services_hidden_supplier');
  4894.         $save_services_multiple_opcommission = $request->request->get('services_hidden_opcommission');
  4895.         $save_services_multiple_opover = $request->request->get('services_hidden_opover');
  4896.         $save_services_multiple_opiva = $request->request->get('services_hidden_opiva');
  4897.         $save_services_multiple_dateBlockLimit = $request->request->get('services_hidden_dateBlockLimit');
  4898.         $save_services_multiple_timeBlockLimit = $request->request->get('services_hidden_timeBlockLimit');
  4899.         $save_services_multiple_dateInAt = $request->request->get('services_hidden_dateInAt');
  4900.         $save_services_multiple_dateOutAt = $request->request->get('services_hidden_dateOutAt');
  4901.         $save_services_multiple_hour_start = $request->request->get('services_hidden_hour_start_');
  4902.         $save_services_multiple_hour_end = $request->request->get('services_hidden_hour_end_');
  4903.         $save_services_multiple_currency = $request->request->get('services_hidden_currency_');
  4904.         $save_services_multiple_originalopIva = $request->request->get('services_hidden_originalopIva_');
  4905.         $save_multiple_supplier_activity_idea_rank = $request->request->get('supplier_activity_idea_hidden_rank');
  4907.         $arrayServices = array();
  4908.         foreach ($save_services_multiple_name as $key => $name){
  4909.             $service = new ProposalSupplierServices();
  4910.             $service->setName($name);
  4911.             $service->setRank($save_services_multiple_rank[$key]);
  4912.             $service->setPrice($save_services_multiple_price[$key]);
  4913.             $service->setUnits($save_services_multiple_units[$key]);
  4914.             $service->setPax($save_services_multiple_pax[$key]);
  4915.             $service->setCommission($save_services_multiple_commission[$key]);
  4916.             $service->setOver($save_services_multiple_over[$key]);
  4917.             $service->setIva($save_services_multiple_iva[$key]);
  4918.             $service->setOriginalPrice($save_services_multiple_originalPrice[$key]);
  4919.             $service->setOriginalIva($save_services_multiple_originalIva[$key]);
  4920.             $service->setSupplierId($save_services_multiple_supplier[$key]);
  4921.             $service->setOpCommission($save_services_multiple_opcommission[$key]);
  4922.             $service->setOpOver($save_services_multiple_opover[$key]);
  4923.             $service->setOpIva($save_services_multiple_opiva[$key]);
  4924.             if (!empty($save_services_multiple_dateBlockLimit[$key]) or !empty($save_services_multiple_timeBlockLimit[$key])){
  4925.                 $service->setDateBlockLimit(new \DateTime($save_services_multiple_dateBlockLimit[$key].' '.$save_services_multiple_timeBlockLimit[$key]));
  4926.             }
  4927.             //$service->set ($save_services_multiple_timeBlockLimit[$key]);
  4928.             if (!empty($save_services_multiple_dateInAt[$key]) or !empty($save_services_multiple_hour_start[$key])) {
  4929.                 $service->setDateInAt(new \DateTime($save_services_multiple_dateInAt[$key] . ' ' . $save_services_multiple_hour_start[$key]));
  4930.             }
  4931.             if (!empty($save_services_multiple_dateOutAt[$key]) or !empty($save_services_multiple_hour_end[$key]) ) {
  4932.                 $service->setDateOutAt(new \DateTime($save_services_multiple_dateOutAt[$key] . ' ' . $save_services_multiple_hour_end[$key]));
  4933.             }
  4934.             $service->setHour($save_services_multiple_hour_start[$key]);
  4935.             //$service->set ($save_services_multiple_hour_end[$key]);
  4936.             $service->setCurrency($save_services_multiple_currency[$key]);
  4937.             $service->setOriginalopIva($save_services_multiple_originalopIva[$key]);
  4939.             $arrayServices[] = array($key, $service);
  4940.         }
  4942.         $em = $this->getDoctrine()->getManager();
  4944.         foreach ($save_multiple_supplier_activity_idea_rank as $key => $item){
  4945.             if(!empty($item)){
  4946.                 $prpSupActIdeaControl = $em->getRepository(ProposalSupplierControl::class)->findOneById($key);
  4947.                 if (!empty($prpSupActIdeaControl)){
  4948.                     $prpSupActIdeaControl->setRank($item);
  4949.                     $em->persist($prpSupActIdeaControl);
  4950.                     $em->flush();
  4951.                 }
  4952.             }
  4953.         }
  4955.         /* Obtengo usuario logueado */
  4956.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  4957.         $user_id = $user_logueado->getId();
  4959.         foreach ($arrayServices as $item){
  4960.             $prpSupService = $em->getRepository(ProposalSupplierServices::class)->findOneById($item[0]);
  4961.             $srvToSave = false;  //Indicador para determinar si se debe guardar el servicio
  4963.             // INICIO: Analizamos si se debe modificar el servicio, el $item[1] se encuentra el servicio
  4964.             if (!empty($item[1]->getName())){ // Hay nombre
  4965.                 $srvToSave = true;
  4966.                 $prpSupService->setName($item[1]->getName());
  4967.             }
  4969.             if (!empty($item[1]->getRank())){ // Hay ranking
  4970.                 $srvToSave = true;
  4971.                 $prpSupService->setRank($item[1]->getRank());
  4972.             }
  4974.             if (!empty($item[1]->getPrice())){ // Hay Precio
  4975.                 $srvToSave = true;
  4976.                 $prpSupService->setPrice($item[1]->getPrice());
  4977.             }
  4979.             if (!empty($item[1]->getUnits())){ // Hay Unidades
  4980.                 $srvToSave = true;
  4981.                 $prpSupService->setUnits($item[1]->getUnits());
  4982.             }
  4984.             if (!empty($item[1]->getPax())){ // Hay Personas
  4985.                 $srvToSave = true;
  4986.                 $prpSupService->setPax($item[1]->getPax());
  4987.             }
  4989.             if (!empty($item[1]->getCommission())){ // Hay Comision
  4990.                 $srvToSave = true;
  4991.                 $prpSupService->setCommission($item[1]->getCommission());
  4992.             }
  4994.             if (!empty($item[1]->getOver())){ // Hay Over
  4995.                 $srvToSave = true;
  4996.                 $prpSupService->setOver($item[1]->getOver());
  4997.             }
  4999.             if (!empty($item[1]->getIva()) or ($item[1]->getIva() == '0')){ // Hay Iva
  5000.                 $srvToSave = true;
  5001.                 $prpSupService->setIva($item[1]->getIva());
  5002.             }
  5004.             if (!empty($item[1]->getOriginalPrice())){ // Hay Original Price
  5005.                 $srvToSave = true;
  5006.                 $prpSupService->setOriginalPrice($item[1]->getOriginalPrice());
  5007.             }
  5009.             if (!empty($item[1]->getOriginalIva())){ // Hay Original Iva
  5010.                 $srvToSave = true;
  5011.                 $prpSupService->setOriginalIva($item[1]->getOriginalIva());
  5012.             }
  5014.             if (!empty($item[1]->getSupplierId())){ // Hay Supplier
  5015.                 $srvToSave = true;
  5016.                 $prpSupService->setSupplierId($item[1]->getSupplierId());
  5017.             }
  5019.             if (($item[1]->getOpCommission() === '0') or ($item[1]->getOpCommission() === '1')){ // Hay OpCommission
  5020.                 $srvToSave = true;
  5021.                 $prpSupService->setOpCommission($item[1]->getOpCommission());
  5022.             }
  5024.             if (($item[1]->getOpOver() === '0') or ($item[1]->getOpOver() === '1')){ // Hay OpOver
  5025.                 $srvToSave = true;
  5026.                 $prpSupService->setOpOver($item[1]->getOpOver());
  5027.             }
  5029.             if (($item[1]->getOpIva() === '0') or ($item[1]->getOpIva() === '1')){ // Hay OpIva
  5030.                 $srvToSave = true;
  5031.                 $prpSupService->setOpIva($item[1]->getOpIva());
  5032.             }
  5034.             if (!empty($item[1]->getHour())){ // Hay Hora de inicio
  5035.                 $srvToSave = true;
  5036.                 $prpSupService->setHour($item[1]->getHour());
  5037.             }
  5039.             if (!empty($item[1]->getCurrency())){ // Hay Moneda
  5040.                 $srvToSave = true;
  5041.                 $prpSupService->setCurrency($item[1]->getCurrency());
  5042.             }
  5044.             if (($item[1]->getOriginalopIva() === '0') or ($item[1]->getOriginalopIva() === '1')){ // Hay Original OP Iva
  5045.                 $srvToSave = true;
  5046.                 $prpSupService->setOriginalopIva($item[1]->getOriginalopIva());
  5047.             }
  5049.             if (!empty($item[1]->getDateBlockLimit())){ // Hay Fecha de Block Limit
  5050.                 $srvToSave = true;
  5051.                 $prpSupService->setDateBlockLimit($item[1]->getDateBlockLimit());
  5052.             }
  5054.             if (!empty($item[1]->getDateInAt())){ // Hay DateInAt
  5055.                 $srvToSave = true;
  5056.                 $prpSupService->setDateInAt($item[1]->getDateInAt());
  5057.             }
  5059.             if (!empty($item[1]->getDateOutAt())){ // Hay DateInAt
  5060.                 $srvToSave = true;
  5061.                 $prpSupService->setDateOutAt($item[1]->getDateOutAt());
  5062.             }
  5063.             // FIN: Analizamos si se debe modificar el servicio, el $item[1] se encuentra el servicio
  5065.             if ($srvToSave){
  5066.                 $em->persist($prpSupService);
  5067.                 $em->flush();
  5068.             }
  5070.             //Actualizar confirmado
  5071.             if ($prpSupService->getStatus() =='Confirmed'){
  5072.                 $costsClient = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($prpSupService->getId());
  5073.                 if (!empty($costsClient)){
  5074. //                $costsClient->setSupplierId($services_supplier_proposal->getSupplierId());
  5075.                     $costsClient->setAssistantId($prpSupService->getAssistantId());
  5076.                     $costsClient->setName($prpSupService->getName());
  5077.                     $costsClient->setPrice($prpSupService->getPrice());
  5078.                     $costsClient->setCurrency($prpSupService->getCurrency());
  5079.                     $costsClient->setUnits($prpSupService->getUnits());
  5080.                     $costsClient->setOpCommission($prpSupService->getOpCommission());
  5081.                     $costsClient->setCommission($prpSupService->getCommission());
  5082.                     $costsClient->setOpOver($prpSupService->getOpOver());
  5083.                     $costsClient->setOver($prpSupService->getOver());
  5084.                     $costsClient->setOpIva($prpSupService->getOpIva());
  5085.                     $costsClient->setIva($prpSupService->getIva());
  5086.                     $costsClient->setPax($prpSupService->getPax());
  5087.                     $costsClient->setHour($prpSupService->getHour());
  5088.                     $costsClient->setDateInAt($prpSupService->getDateInAt());
  5089.                     $costsClient->setDateOutAt($prpSupService->getDateOutAt());
  5090.                     $costsClient->setRank($prpSupService->getRank());
  5091.                     $costsClient->setCreatedId($user_id);
  5092.                     $costsClient->setUpdatedId($user_id);
  5093.                     $em->persist($costsClient);
  5094.                     $em->flush();
  5095.                 }
  5096.             }
  5097.         }
  5099.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  5100.             'id' => $id,
  5101.         ));
  5103.     }
  5105.     /**
  5106.      * @Route("proposal/destination/services/duplicateservice/{id}", name="proposal_destination_duplicate_service")
  5107.      */
  5108.     public function duplicateServiceAction($id, Request $request) {
  5110.         $em = $this->getDoctrine()->getManager();
  5111.         $prpSupService = $em->getRepository(ProposalSupplierServices::class)->findOneById($id);
  5113.         /* Obtengo usuario logueado */
  5114.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  5115.         $user_id = $user_logueado->getId();
  5117.         $service = new ProposalSupplierServices();
  5118.         $service->setName('DUPLICADO - '.$prpSupService->getName());
  5119.         $service->setRank($prpSupService->getRank());
  5120.         $service->setPrice($prpSupService->getPrice());
  5121.         $service->setUnits($prpSupService->getUnits());
  5122.         $service->setPax($prpSupService->getPax());
  5123.         $service->setCommission($prpSupService->getCommission());
  5124.         $service->setOver($prpSupService->getOver());
  5125.         $service->setIva($prpSupService->getIva());
  5126.         $service->setOriginalPrice($prpSupService->getOriginalPrice());
  5127.         $service->setOriginalIva($prpSupService->getOriginalIva());
  5128.         $service->setSupplierId($prpSupService->getSupplierId());
  5129.         $service->setOpCommission($prpSupService->getOpCommission());
  5130.         $service->setOpOver($prpSupService->getOpOver());
  5131.         $service->setOpIva($prpSupService->getOpIva());
  5132.         $service->setDateBlockLimit($prpSupService->getDateBlockLimit());
  5133.         $service->setDateInAt($prpSupService->getDateInAt());
  5134.         $service->setDateOutAt($prpSupService->getDateOutAt());
  5135.         $service->setHour($prpSupService->getHour());
  5136.         $service->setCurrency($prpSupService->getCurrency());
  5137.         $service->setOriginalopIva($prpSupService->getOriginalopIva());
  5138.         $service->setCreatedId($user_id);
  5139.         $service->setCreatedAt(new \DateTime());
  5140.         $service->setUpdatedId($user_id);
  5141.         $service->setUpdatedAt(new \DateTime());
  5142.         $service->setControlId($prpSupService->getControlId());
  5143.         $service->setActivityId($prpSupService->getActivityId());
  5144.         $service->setAssistantId($prpSupService->getAssistantId());
  5145.         $service->setBreakdown($prpSupService->getBreakdown());
  5146.         $service->setDestinationId($prpSupService->getDestinationId());
  5147.         $service->setDirectPayment($prpSupService->getDirectPayment());
  5148.         $service->setIdeaId($prpSupService->getIdeaId());
  5149.         $service->setPreCommission($prpSupService->getPreCommission());
  5150.         $service->setPreIva($prpSupService->getPreIva());
  5151.         $service->setProposalId($prpSupService->getProposalId());
  5152.         $service->setServiceCatId($prpSupService->getServiceCatId());
  5153.         $service->setServiceCatName($prpSupService->getServiceCatName());
  5154.         $service->setServiceId($prpSupService->getServiceId());
  5155.         $service->setServiceIdFather($prpSupService->getServiceIdFather());
  5156.         $service->setStatus('Pending');
  5157.         $service->setStatusinternal($prpSupService->getStatusinternal());
  5159.         $em->persist($service);
  5160.         $em->flush();
  5162.         $prpSupCtrl = $em->getRepository(ProposalSupplierControl::class)->findOneById($prpSupService->getControlId());
  5164.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  5165.             'id' => $prpSupCtrl->getControlDestinationId(),
  5166.             '_fragment' => $id
  5167.         ));
  5168.     }
  5170.     /**
  5171.      * @Route("proposal/destination/services/duplicatesupplier/{id}", name="proposal_destination_duplicate_supplier")
  5172.      */
  5173.     public function duplicateSupplierAction($id, Request $request) {
  5175.         $newSup = $request->request->get('dupliSupplierId');
  5176.         $em = $this->getDoctrine()->getManager();
  5178.         /* Obtengo usuario logueado */
  5179.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  5180.         $user_id = $user_logueado->getId();
  5182.         $prpSupServices = $em->getRepository(ProposalSupplierServices::class)->findByControlId($id);
  5183.         $prpSupControl = $em->getRepository(ProposalSupplierControl::class)->findOneById($id);
  5184.         $origenSup = $prpSupControl->getSupplierId();
  5186.         //Verificamos si Proveedor origen y destino son el mismo
  5187.         if ($newSup != $origenSup){
  5188.             //Verificamos si ya existe el control del Proveedor destino
  5189.             $prevPrpSupControl = $em->getRepository(ProposalSupplierControl::class)->findBy(
  5190.                 array('proposalId'=>$prpSupControl->getProposalId(),
  5191.                       'destinoId'=>$prpSupControl->getDestinoId(),
  5192.                       'supplierId'=>$newSup));
  5194.             if (empty($prevPrpSupControl)){
  5195.                 // Proveedor origen y destino son distintos, se crea una nueva entidad de control
  5196.                 $newSupControl = new ProposalSupplierControl();
  5197.             } else {
  5198.                 // El Proveedor destino ya tiene un controlador
  5199.                 $newSupControl = $prevPrpSupControl[0];
  5200.             }
  5202.             $newSupControl->setActivityId($prpSupControl->getActivityId());
  5203.             $newSupControl->setControlDestinationId($prpSupControl->getControlDestinationId());
  5204.             $newSupControl->setDateBlockLimit($prpSupControl->getDateBlockLimit());
  5205.             $newSupControl->setDestinoId($prpSupControl->getDestinoId());
  5206.             $newSupControl->setDisabled($prpSupControl->getDisabled());
  5207.             $newSupControl->setIdeaId($prpSupControl->getIdeaId());
  5208.             $newSupControl->setProposalId($prpSupControl->getProposalId());
  5209.             $newSupControl->setRank($prpSupControl->getRank());
  5210.             $newSupControl->setStatus($prpSupControl->getStatus());
  5211.             $newSupControl->setSupplierId($newSup);
  5213.             $em->persist($newSupControl);
  5214.             $em->flush();
  5215.         } else {
  5216.             $newSupControl = $prpSupControl;
  5217.         }
  5219.         // Duplicamos los servicios
  5220.         foreach ($prpSupServices as $item){
  5221.             $service = new ProposalSupplierServices();
  5222.             $service->setName($item->getName());
  5223.             $service->setRank($item->getRank());
  5224.             $service->setPrice($item->getPrice());
  5225.             $service->setUnits($item->getUnits());
  5226.             $service->setPax($item->getPax());
  5227.             $service->setCommission($item->getCommission());
  5228.             $service->setOver($item->getOver());
  5229.             $service->setIva($item->getIva());
  5230.             $service->setOriginalPrice($item->getOriginalPrice());
  5231.             $service->setOriginalIva($item->getOriginalIva());
  5232.             $service->setSupplierId($newSup);
  5233.             $service->setOpCommission($item->getOpCommission());
  5234.             $service->setOpOver($item->getOpOver());
  5235.             $service->setOpIva($item->getOpIva());
  5236.             $service->setDateBlockLimit($item->getDateBlockLimit());
  5237.             $service->setDateInAt($item->getDateInAt());
  5238.             $service->setDateOutAt($item->getDateOutAt());
  5239.             $service->setHour($item->getHour());
  5240.             $service->setCurrency($item->getCurrency());
  5241.             $service->setOriginalopIva($item->getOriginalopIva());
  5242.             $service->setCreatedId($user_id);
  5243.             $service->setCreatedAt(new \DateTime());
  5244.             $service->setUpdatedId($user_id);
  5245.             $service->setUpdatedAt(new \DateTime());
  5246.             $service->setControlId($newSupControl->getId());
  5247.             $service->setActivityId($item->getActivityId());
  5248.             $service->setAssistantId($item->getAssistantId());
  5249.             $service->setBreakdown($item->getBreakdown());
  5250.             $service->setDestinationId($item->getDestinationId());
  5251.             $service->setDirectPayment($item->getDirectPayment());
  5252.             $service->setIdeaId($item->getIdeaId());
  5253.             $service->setPreCommission($item->getPreCommission());
  5254.             $service->setPreIva($item->getPreIva());
  5255.             $service->setProposalId($item->getProposalId());
  5256.             $service->setServiceCatId($item->getServiceCatId());
  5257.             $service->setServiceCatName($item->getServiceCatName());
  5258.             $service->setServiceId($item->getServiceId());
  5259.             $service->setServiceIdFather($item->getServiceIdFather());
  5260.             $service->setStatus('Pending');
  5261.             $service->setStatusinternal($item->getStatusinternal());
  5263.             $em->persist($service);
  5264.             $em->flush();
  5265.         }
  5267.         $prpSupCtrl = $em->getRepository(ProposalSupplierControl::class)->findOneById($id);
  5269.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  5270.             'id' => $prpSupCtrl->getControlDestinationId(),
  5271.         ));
  5272.     }
  5275.     /**
  5276.      * @Route("proposal/destination/services/comissionall", name="proposal_destination_comission_all")
  5277.      */
  5278.     public function comissionAllAction(Request $request){
  5280.         $proposalSupplierControlId = $request->request->get('proposalSupplierControlId');
  5281.         $opCommissionAll = $request->request->get('opCommissionAll');
  5282.         $commissionAll = $request->request->get('commissionAll');
  5284.         $em = $this->getDoctrine()->getManager();
  5285.         $prpSupControl = $em->getRepository(ProposalSupplierControl::class)->findOneById($proposalSupplierControlId);
  5286.         $prpSupServices = $em->getRepository(ProposalSupplierServices::class)->findByControlId($proposalSupplierControlId);
  5287.         $idPrpSupServices = null;
  5289.         foreach ($prpSupServices as $item){
  5290.             $item->setOpCommission($opCommissionAll);
  5291.             $item->setCommission($commissionAll);
  5292.             $idPrpSupServices = $item->getId();
  5294.             $em->persist($item);
  5295.             $em->flush();
  5297.             $prpSupServicesCosts = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($item->getId());
  5298.             if (!empty($prpSupServicesCosts)){
  5299.                 $em->remove($prpSupServicesCosts);
  5300.                 $em->flush();
  5301.             }
  5303.             if (!empty($idPrpSupServices)){
  5304.                 $parameters = array(
  5305.                     'idPrpSupServices' => '%'.$idPrpSupServices.'%',
  5306.                 );
  5307.                 $dql = 'SELECT i
  5308.                     FROM EventsBundle:ProposalSupplierServicesCosts i
  5309.                     WHERE i.servicesId LIKE :idPrpSupServices
  5310.                     ORDER BY i.id ASC';
  5311.                 $query = $em->createQuery($dql)->setParameters($parameters);
  5312.                 $proposalSupplierServicesCosts = $query->getResult();
  5314.                 // Si el servicio se encontraba dentro de $proposalSupplierServicesCosts es porque el servicio se encontraba
  5315.                 // confirmado y dentro de una proforma, se deben sacar para evitar error en el apartado de proveedores
  5316.                 foreach($proposalSupplierServicesCosts as $prpSupSrvCst){
  5317.                     $prpSupSrvCst->setServicesId('0');
  5319.                     $em->persist($prpSupSrvCst);
  5320.                     $em->flush();
  5321.                 }
  5322.             }
  5323.         }
  5325.         $fragmento = empty($prpSupServices) ? null : $prpSupServices[0]->getId();
  5327.         return $this->redirectToRoute('proposal_destination_supplier_view',
  5328.             array(
  5329.                 'id' => $prpSupControl->getControlDestinationId(),
  5330.                 '_fragment' => $fragmento
  5331.             ));
  5332.     }
  5334.     private function sendTelegram ( $id, $text )
  5335.     {
  5336.         $em = $this->getDoctrine()->getManager();
  5337.         $telegUser = $em->getRepository(MdvTelegramUser::class)->findOneByUserId($id);
  5339.         if (empty($telegUser)){return true;}
  5341.         $parameters = array(
  5342.             'chat_id' => $telegUser->getChatId(),
  5343.             'text' => $text,
  5344.         );
  5346.         $bot_token = $telegUser->getBotToken();
  5347.         $url = "https://api.telegram.org/bot$bot_token/sendMessage";
  5349.         if (!$curl = curl_init()){
  5350.             exit();
  5351.         }
  5353.         curl_setopt($curl,CURLOPT_POST,true);
  5354.         curl_setopt($curl,CURLOPT_POSTFIELDS,$parameters);
  5355.         curl_setopt($curl,CURLOPT_URL,$url);
  5356.         curl_setopt($curl,CURLOPT_RETURNTRANSFER,true);
  5357.         $output = curl_exec($curl);
  5358.         curl_close($curl);
  5360.         return true;
  5361.     }
  5362. }