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($agent->getEmail())
  954. //                        ->setPassword($agent->getPassGmail());
  955.                         ->setUsername('desarrollo@develup.solutions')
  956.                         ->setPassword('MeDITeRRANeAN_Develup30102023#');
  957.                     $mailer = new Swift_Mailer($transporter);
  959.                     $message = new Swift_Message();
  960.                     $message->setSubject('P#' . $proposal->getId() . ', Alta de servicio')
  961. //                        ->setSender($agentMail)
  962. //                        ->setFrom($mailAgentFrom)
  963.                         ->setFrom(array("desarrollo@develup.solutions" => "System Mante 3.0"))
  964.                         ->setReplyTo($zagentReplyTo)
  965.                         ->setTo($mailAgentSent)
  966.                         ->setBody(
  967.                             $this->renderView(
  968.                                 'mail/structure-mail.html.twig',
  969.                                 array('data' => $data)
  970.                             ),
  971.                             'text/html'
  972.                         );
  974.                     $mailer->send($message);
  975.                 }
  976.                 // FIN: Envio de Correo a AV EXPRESS o DEVELUP SOLUTIONS
  979.                 $event = 'The Supplier Destination Proposal has been created.';
  980.                 $successMessage = $this->translator->trans($event);
  981.                 $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  983.                 return $this->redirectToRoute('proposal_destination_supplier_especial_list', array(
  984.                     'idcontrol' => $control->getId()
  985.                 ));
  987.             }else{
  988.                 $errorMessage = $this->translator->trans('Error, some fields are empty');
  989.                 $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  990.             }
  991.         }else{
  992. //            $errorMessage = $this->translator->trans('The proposal already has this provider included');
  993. //            $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  995.             return $this->redirectToRoute('proposal_destination_supplier_especial_list', array(
  996.                 'idcontrol' => $control_verifico->getId()
  997.             ));
  998.         }
  1000.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  1001.             'id' => $cdid,
  1002.             '_fragment' => 's'.$control_verifico->getId()
  1003.         ));
  1005.     }
  1008.     /* CREAR DESDE UN SUPPLIER */
  1009.     private function createDestinationProposalSupplierCreateForm(ProposalSupplierControl $entity)
  1010.     {
  1011.         $form = $this->createForm(ProposalSupplierControlType::class, $entity, array(
  1012.             'action' => $this->generateUrl('proposal_destination_supplier_create'),
  1013.             'method' => 'POST'
  1014.         ));
  1015.         return $form;
  1016.     }
  1019.     /* CREAR DESDE UN SUPPLIER */
  1020.     /**
  1021.      * @Route("/proposal/destination/services/create", name="proposal_destination_supplier_create")
  1022.      */
  1023.     public function createProposalDestinationAction(Request $request)
  1024.     {
  1026.         $control = new ProposalSupplierControl();
  1027.         $form = $this->createDestinationProposalSupplierCreateForm($control);
  1028.         $form->handleRequest($request);
  1030.         $supplier_proposal = $form->get('supplierId')->getData();
  1031.         if(!is_null($supplier_proposal)){
  1032.             $control->setSupplierId($supplier_proposal->getId());
  1033.         }
  1034.         $em = $this->getDoctrine()->getManager();
  1035.         $control_verifico = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1036.             array(
  1037.                 'controlDestinationId' => $form->get('controlDestinationId')->getData(),
  1038.                 'proposalId' => $form->get('proposalId')->getData(),
  1039.                 'destinoId' => $form->get('destinoId')->getData(),
  1040.                 'supplierId' => $supplier_proposal->getId(),
  1041.             )
  1042.         );
  1043.         $proposal = $em->getRepository(Proposal::class)->findOneById($form->get('proposalId')->getData());
  1046.         if(empty($control_verifico)){
  1048.             if($form->isValid())
  1049.             {
  1050.                 $control->setStatus('Pending');
  1051.                 $em->persist($control);
  1052.                 $em->flush();
  1053.                 $event = 'The Supplier Destination Proposal has been created.';
  1054.                 $successMessage = $this->translator->trans($event);
  1055.                 $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  1058.             }else{
  1059.                 $errorMessage = $this->translator->trans('Error, some fields are empty');
  1060.                 $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  1061.             }
  1062.         }else{
  1063.             $errorMessage = $this->translator->trans('The proposal already has this provider included');
  1064.             $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  1065.         }
  1067.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  1068.             'id' => $control->getControlDestinationId(),
  1069.             '_fragment' => 's'.$control->getId()
  1070.         ));
  1072.     }
  1074.     /* CREAR DESDE UNA Activity */
  1075.     private function createDestinationProposalActivitiesCreateForm(ProposalSupplierControl $entity)
  1076.     {
  1077.         $form = $this->createForm(ProposalActivitiesControlType::class, $entity, array(
  1078.             'action' => $this->generateUrl('proposal_destination_activities_create'),
  1079.             'method' => 'POST'
  1080.         ));
  1081.         return $form;
  1082.     }
  1084.     /* CREAR DESDE UNA Activity  */
  1085.     /**
  1086.      * @Route("/proposal/destination/services/createActivity", name="proposal_destination_activities_create")
  1087.      */
  1088.     public function createProposalActivityDestinationAction(Request $request)
  1089.     {
  1090.         $control = new ProposalSupplierControl();
  1091.         $form = $this->createDestinationProposalActivitiesCreateForm($control);
  1092.         $form->handleRequest($request);
  1094.         $supplier_proposal = $form->get('activityId')->getData();
  1095.         if(!is_null($supplier_proposal)){
  1096.             $control->setActivityId($supplier_proposal->getId());
  1097.         }
  1098.         $em = $this->getDoctrine()->getManager();
  1099.         $control_verifico = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1100.             array(
  1101.                 'controlDestinationId' => $form->get('controlDestinationId')->getData(),
  1102.                 'proposalId' => $form->get('proposalId')->getData(),
  1103.                 'destinoId' => $form->get('destinoId')->getData(),
  1104.                 'activityId' => $supplier_proposal->getId(),
  1105.             )
  1106.         );
  1107. //        $proposal = $em->getRepository(Proposal::class)->findOneById($form->get('proposalId')->getData());
  1109.         if(empty($control_verifico)){
  1111.             if($form->isValid())
  1112.             {
  1113.                 $control->setStatus('Pending');
  1114.                 $em->persist($control);
  1115.                 $em->flush();
  1117.                 /* METEMOS EL CONTENIDO DE LA IDEA */
  1118.                 $idcontrol = $control->getId();
  1119.                 $idactivity = $control->getActivityId();
  1121.                 /*CONTROL GENERAL*/
  1122.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByActivityId($idactivity);
  1123.                 $id = $controlgeneral->getId();
  1125.                 $supplierservices= new ProposalSupplierServices();
  1126.                 $supplierservices->setControlId($idcontrol);
  1128.                 $supplierCrtl = $em->getRepository(ProposalSupplierControl::class)->findOneById($idcontrol);
  1129.                 $supplierservices->setProposalId($supplierCrtl->getProposalId());
  1130.                 $supplierservices->setDestinationId($supplierCrtl->getDestinoId());
  1132.                 $supplierservices->setServiceIdFather('0');
  1133.                 $supplierservices->setSupplierId(null);
  1134.                 $supplierservices->setActivityId($idactivity);
  1135.                 $supplierservices->setIsFather('0');
  1139.                 /* NAMEJO DE ADICIONALES EN EL DIA DEL EVENTO O DESPUES EL DIA DEL EVENTO */
  1140.                 $proposal_data = $em->getRepository(Proposal::class)->findOneById($supplierCrtl->getProposalId());
  1141.                 $dayEvent = $proposal_data->getDateEventStarAt()->format('Y-m-d');
  1142.                 $today = date('Y-m-d');
  1144.                 if( $today >= $dayEvent){
  1145.                     $additional = "Additional";
  1146.                 }else{
  1147.                     $additional = "Normal";
  1148.                 }
  1150.                 /* Obtengo usuario logueado */
  1151.                 $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1152.                 $user_id = $user_logueado->getId();
  1153.                 $supplierservices->setCreatedId($user_id);
  1154.                 $supplierservices->setUpdatedId($user_id);
  1156.                 $supplierservices->setDateInAt($proposal_data->getDateEventStarAt());
  1157.                 $supplierservices->setDateOutAt($proposal_data->getDateEventEndAt());
  1159.                 ///////colsulta de servicio
  1162.                 /* metemos accommodation *////////////////////////////////////////////////////////////////
  1163.                 $accommodations = $em->getRepository(SupplierAccommodation::class)->findBySupplierId($id);
  1164.                 //la consulta es al SupplierId porque lo estamos usando como id controlador para SupplierIdeaServicesControl
  1165.                 if(!empty($accommodations)){
  1166.                     foreach($accommodations as $accommodation){
  1167.                         $supplierservices->setServiceId($accommodation->getId());
  1168.                         $supplierservices->setServiceCatId('1');
  1169.                         $supplierservices->setServiceCatName('Accommodation');
  1171.                         $supplierservices->setName($accommodation->getName());
  1172.                         $supplierservices->setPrice($accommodation->getPrice());
  1173.                         //$supplierservices->setCurrency('Euro');
  1174.                         $supplierservices->setUnits('1');
  1175.                         $supplierservices->setCommission('0');
  1176.                         //$supplierservices->setOver('Accommodation');
  1177.                         $supplierservices->setIva('10');
  1178.                         $supplierservices->setPax('0');
  1179.                         //$supplierservices->setHour('');//null
  1180.                         //$supplierservices->setDateInAt('');
  1181.                         //$supplierservices->setDateOutAt('');
  1182.                         $supplierservices->setDirectPayment('0');
  1183.                         $supplierservices->setStatus('Pending');
  1184.                         $supplierservices->setStatusinternal($additional);
  1187.                         $em->persist($supplierservices);
  1188.                         $em->flush();
  1189.                         $em->clear();
  1191.                         //para pruebas
  1192.                         //$data_prueba[] = array(
  1193.                         //    'data' => $supplierservices
  1194.                         //);
  1195.                     }
  1196.                     //para pruebas
  1197.                     //d($data_prueba);
  1198.                     //exit();
  1199.                 }
  1202.                 /* metemos menu *////////////////////////////////////////////////////////////////
  1203.                 $menus = $em->getRepository(SupplierMenu::class)->findBySupplierId($id);
  1204.                 if(!empty($menus)){
  1205.                     foreach($menus as $menu){
  1206.                         $supplierservices->setServiceId($menu->getId());
  1207.                         $supplierservices->setServiceCatId('11');
  1208.                         $supplierservices->setServiceCatName('Menu');
  1210.                         $supplierservices->setName($menu->getTitle());
  1211.                         $supplierservices->setPrice($menu->getPrice());
  1212.                         //$supplierservices->setCurrency('Euro');
  1213.                         $supplierservices->setUnits('1');
  1214.                         $supplierservices->setCommission($menu->getCommission());
  1215.                         //$supplierservices->setOver('Accommodation');
  1216.                         $supplierservices->setIva($menu->getIva());
  1217.                         $supplierservices->setPax('0');
  1218.                         //$supplierservices->setHour('');//null
  1219.                         //$supplierservices->setDateInAt('');
  1220.                         //$supplierservices->setDateOutAt('');
  1221.                         $supplierservices->setDirectPayment('0');
  1222.                         $supplierservices->setStatus('Pending');
  1223.                         $supplierservices->setStatusinternal($additional);
  1226.                         $em->persist($supplierservices);
  1227.                         $em->flush();
  1228.                         $em->clear();
  1230.                         //para pruebas
  1231.                         //$data_prueba[] = array(
  1232.                         //    'data' => $supplierservices
  1233.                         //);
  1234.                     }
  1235.                     //para pruebas
  1236.                     //d($data_prueba);
  1237.                     //exit();
  1238.                 }
  1240.                 /* metemos lounge *////////////////////////////////////////////////////////////////
  1241.                 $lounges = $em->getRepository(SupplierLounge::class)->findBySupplierId($id);
  1242.                 if(!empty($lounges)){
  1243.                     foreach($lounges as $lounge){
  1244.                         $supplierservices->setServiceId($lounge->getId());
  1245.                         $supplierservices->setServiceCatId('10');
  1246.                         $supplierservices->setServiceCatName('Lounge');
  1248.                         $supplierservices->setName($lounge->getName());
  1249.                         $supplierservices->setPrice($lounge->getPrice());
  1250.                         //$supplierservices->setCurrency('Euro');
  1251.                         $supplierservices->setUnits('1');
  1252.                         $supplierservices->setCommission($lounge->getCommission());
  1253.                         //$supplierservices->setOver('Accommodation');
  1254.                         $supplierservices->setIva($lounge->getIva());
  1255.                         $supplierservices->setPax('0');
  1256.                         //$supplierservices->setHour('');//null
  1257.                         //$supplierservices->setDateInAt('');
  1258.                         //$supplierservices->setDateOutAt('');
  1259.                         $supplierservices->setDirectPayment('0');
  1260.                         $supplierservices->setStatus('Pending');
  1261.                         $supplierservices->setStatusinternal($additional);
  1264.                         $em->persist($supplierservices);
  1265.                         $em->flush();
  1266.                         $em->clear();
  1268.                         //para pruebas
  1269.                         //$data_prueba[] = array(
  1270.                         //    'data' => $supplierservices
  1271.                         //);
  1272.                     }
  1273.                     //para pruebas
  1274.                     //d($data_prueba);
  1275.                     //exit();
  1276.                 }
  1279.                 /* metemos activities *////////////////////////////////////////////////////////////////
  1280.                 $activitiess = $em->getRepository(SupplierActivities::class)->findBySupplierId($id);
  1281.                 if(!empty($activitiess)){
  1282.                     foreach($activitiess as $activities){
  1283.                         $supplierservices->setServiceId($activities->getId());
  1284.                         $supplierservices->setServiceCatId('2');
  1285.                         $supplierservices->setServiceCatName('Activities');
  1287.                         $supplierservices->setName($activities->getTitle());
  1288.                         $supplierservices->setPrice($activities->getPrice());
  1289.                         //$supplierservices->setCurrency('Euro');
  1290.                         $supplierservices->setUnits('1');
  1291.                         $supplierservices->setCommission($activities->getCommission());
  1292.                         //$supplierservices->setOver('Accommodation');
  1293.                         $supplierservices->setIva($activities->getIva());
  1294.                         $supplierservices->setPax('0');
  1295.                         //$supplierservices->setHour('');//null
  1296.                         //$supplierservices->setDateInAt('');
  1297.                         //$supplierservices->setDateOutAt('');
  1298.                         $supplierservices->setDirectPayment('0');
  1299.                         $supplierservices->setStatus('Pending');
  1300.                         $supplierservices->setStatusinternal($additional);
  1303.                         $em->persist($supplierservices);
  1304.                         $em->flush();
  1305.                         $em->clear();
  1307.                         //para pruebas
  1308.                         //$data_prueba[] = array(
  1309.                         //    'data' => $supplierservices
  1310.                         //);
  1311.                     }
  1312.                     //para pruebas
  1313.                     //d($data_prueba);
  1314.                     //exit();
  1315.                 }
  1318.                 /* metemos itineraries *////////////////////////////////////////////////////////////////
  1319.                 $itinerariess = $em->getRepository(SupplierItineraries::class)->findBySupplierId($id);
  1320.                 if(!empty($itinerariess)){
  1321.                     foreach($itinerariess as $itineraries){
  1322.                         $supplierservices->setServiceId($itineraries->getId());
  1323.                         $supplierservices->setServiceCatId('9');
  1324.                         $supplierservices->setServiceCatName('Itineraries');
  1326.                         $supplierservices->setName($itineraries->getTitle());
  1327.                         $supplierservices->setPrice('0');
  1328.                         //$supplierservices->setCurrency('Euro');
  1329.                         $supplierservices->setUnits('1');
  1330.                         $supplierservices->setCommission('0');
  1331.                         //$supplierservices->setOver('Accommodation');
  1332.                         $supplierservices->setIva('10');
  1333.                         $supplierservices->setPax('0');
  1334.                         //$supplierservices->setHour('');//null
  1335.                         //$supplierservices->setDateInAt('');
  1336.                         //$supplierservices->setDateOutAt('');
  1337.                         $supplierservices->setDirectPayment('0');
  1338.                         $supplierservices->setStatus('Pending');
  1339.                         $supplierservices->setStatusinternal($additional);
  1342.                         $em->persist($supplierservices);
  1343.                         $em->flush();
  1344.                         $em->clear();
  1346.                         //para pruebas
  1347.                         //$data_prueba[] = array(
  1348.                         //    'data' => $supplierservices
  1349.                         //);
  1350.                     }
  1351.                     //para pruebas
  1352.                     //d($data_prueba);
  1353.                     //exit();
  1354.                 }
  1357.                 /* metemos cruise *////////////////////////////////////////////////////////////////
  1358.                 $cruises = $em->getRepository(SupplierCruise::class)->findBySupplierId($id);
  1359.                 if(!empty($cruises)){
  1360.                     foreach($cruises as $cruise){
  1361.                         $supplierservices->setServiceId($cruise->getId());
  1362.                         $supplierservices->setServiceCatId('5');
  1363.                         $supplierservices->setServiceCatName('Cruise');
  1365.                         $supplierservices->setName($cruise->getTitle());
  1366.                         $supplierservices->setPrice($cruise->getPrice());
  1367.                         //$supplierservices->setCurrency('Euro');
  1368.                         $supplierservices->setUnits('1');
  1369.                         $supplierservices->setCommission($cruise->getCommission());
  1370.                         //$supplierservices->setOver('Accommodation');
  1371.                         $supplierservices->setIva($cruise->getIva());
  1372.                         $supplierservices->setPax('0');
  1373.                         //$supplierservices->setHour('');//null
  1374.                         //$supplierservices->setDateInAt('');
  1375.                         //$supplierservices->setDateOutAt('');
  1376.                         $supplierservices->setDirectPayment('0');
  1377.                         $supplierservices->setStatus('Pending');
  1378.                         $supplierservices->setStatusinternal($additional);
  1381.                         $em->persist($supplierservices);
  1382.                         $em->flush();
  1383.                         $em->clear();
  1385.                         //para pruebas
  1386.                         //$data_prueba[] = array(
  1387.                         //    'data' => $supplierservices
  1388.                         //);
  1389.                     }
  1390.                     //para pruebas
  1391.                     //d($data_prueba);
  1392.                     //exit();
  1393.                 }
  1396.                 /* metemos transport *////////////////////////////////////////////////////////////////
  1397.                 $transports = $em->getRepository(SupplierTransport::class)->findBySupplierId($id);
  1398.                 if(!empty($transports)){
  1399.                     foreach($transports as $transport){
  1400.                         $supplierservices->setServiceId($transport->getId());
  1401.                         $supplierservices->setServiceCatId('13');
  1402.                         $supplierservices->setServiceCatName('Transport');
  1404.                         $supplierservices->setName($transport->getName());
  1405.                         $supplierservices->setPrice($transport->getPrice());
  1406.                         //$supplierservices->setCurrency('Euro');
  1407.                         $supplierservices->setUnits('1');
  1408.                         $supplierservices->setCommission($transport->getCommission());
  1409.                         //$supplierservices->setOver('Accommodation');
  1410.                         $supplierservices->setIva($transport->getIva());
  1411.                         $supplierservices->setPax('0');
  1412.                         //$supplierservices->setHour('');//null
  1413.                         //$supplierservices->setDateInAt('');
  1414.                         //$supplierservices->setDateOutAt('');
  1415.                         $supplierservices->setDirectPayment('0');
  1416.                         $supplierservices->setStatus('Pending');
  1417.                         $supplierservices->setStatusinternal($additional);
  1420.                         $em->persist($supplierservices);
  1421.                         $em->flush();
  1422.                         $em->clear();
  1424.                         //para pruebas
  1425.                         //$data_prueba[] = array(
  1426.                         //    'data' => $supplierservices
  1427.                         //);
  1428.                     }
  1429.                     //para pruebas
  1430.                     //d($data_prueba);
  1431.                     //exit();
  1432.                 }
  1436.                 /* metemos av *////////////////////////////////////////////////////////////////
  1437.                 $avs = $em->getRepository(SupplierAv::class)->findBySupplierId($id);
  1438.                 if(!empty($avs)){
  1439.                     foreach($avs as $av){
  1440.                         $supplierservices->setServiceId($av->getId());
  1441.                         $supplierservices->setServiceCatId('3');
  1442.                         $supplierservices->setServiceCatName('Av');
  1444.                         $supplierservices->setName($av->getName());
  1445.                         $supplierservices->setPrice($av->getPrice());
  1446.                         //$supplierservices->setCurrency('Euro');
  1447.                         $supplierservices->setUnits('1');
  1448.                         $supplierservices->setCommission($av->getCommission());
  1449.                         //$supplierservices->setOver('Accommodation');
  1450.                         $supplierservices->setIva($av->getIva());
  1451.                         $supplierservices->setPax('0');
  1452.                         //$supplierservices->setHour('');//null
  1453.                         //$supplierservices->setDateInAt('');
  1454.                         //$supplierservices->setDateOutAt('');
  1455.                         $supplierservices->setDirectPayment('0');
  1456.                         $supplierservices->setStatus('Pending');
  1457.                         $supplierservices->setStatusinternal($additional);
  1460.                         $em->persist($supplierservices);
  1461.                         $em->flush();
  1462.                         $em->clear();
  1464.                         //para pruebas
  1465.                         //$data_prueba[] = array(
  1466.                         //    'data' => $supplierservices
  1467.                         //);
  1468.                     }
  1469.                     //para pruebas
  1470.                     //d($data_prueba);
  1471.                     //exit();
  1472.                 }
  1476.                 /* metemos creative *////////////////////////////////////////////////////////////////
  1477.                 $creatives = $em->getRepository(SupplierCreative::class)->findBySupplierId($id);
  1478.                 if(!empty($creatives)){
  1479.                     foreach($creatives as $creative){
  1480.                         $supplierservices->setServiceId($creative->getId());
  1481.                         $supplierservices->setServiceCatId('4');
  1482.                         $supplierservices->setServiceCatName('Creative');
  1484.                         $supplierservices->setName($creative->getTitle());
  1485.                         $supplierservices->setPrice('0');
  1486.                         //$supplierservices->setCurrency('Euro');
  1487.                         $supplierservices->setUnits('1');
  1488.                         $supplierservices->setCommission('0');
  1489.                         //$supplierservices->setOver('Accommodation');
  1490.                         $supplierservices->setIva('21');
  1491.                         $supplierservices->setPax('0');
  1492.                         //$supplierservices->setHour('');//null
  1493.                         //$supplierservices->setDateInAt('');
  1494.                         //$supplierservices->setDateOutAt('');
  1495.                         $supplierservices->setDirectPayment('0');
  1496.                         $supplierservices->setStatus('Pending');
  1497.                         $supplierservices->setStatusinternal($additional);
  1500.                         $em->persist($supplierservices);
  1501.                         $em->flush();
  1502.                         $em->clear();
  1504.                         //para pruebas
  1505.                         //$data_prueba[] = array(
  1506.                         //    'data' => $supplierservices
  1507.                         //);
  1508.                     }
  1509.                     //para pruebas
  1510.                     //d($data_prueba);
  1511.                     //exit();
  1512.                 }
  1515.                 /* metemos gift *////////////////////////////////////////////////////////////////
  1516.                 $gifts = $em->getRepository(SupplierGifts::class)->findBySupplierId($id);
  1517.                 if(!empty($gifts)){
  1518.                     foreach($gifts as $gift){
  1519.                         $supplierservices->setServiceId($gift->getId());
  1520.                         $supplierservices->setServiceCatId('7');
  1521.                         $supplierservices->setServiceCatName('Gifts');
  1523.                         $supplierservices->setName($gift->getName());
  1524.                         $supplierservices->setPrice($gift->getPrice());
  1525.                         //$supplierservices->setCurrency('Euro');
  1526.                         $supplierservices->setUnits('1');
  1527.                         $supplierservices->setCommission($gift->getCommission());
  1528.                         //$supplierservices->setOver('Accommodation');
  1529.                         $supplierservices->setIva($gift->getIva());
  1530.                         $supplierservices->setPax('0');
  1531.                         //$supplierservices->setHour('');//null
  1532.                         //$supplierservices->setDateInAt('');
  1533.                         //$supplierservices->setDateOutAt('');
  1534.                         $supplierservices->setDirectPayment('0');
  1535.                         $supplierservices->setStatus('Pending');
  1536.                         $supplierservices->setStatusinternal($additional);
  1539.                         $em->persist($supplierservices);
  1540.                         $em->flush();
  1541.                         $em->clear();
  1543.                         //para pruebas
  1544.                         //$data_prueba[] = array(
  1545.                         //    'data' => $supplierservices
  1546.                         //);
  1547.                     }
  1548.                     //para pruebas
  1549.                     //d($data_prueba);
  1550.                     //exit();
  1551.                 }
  1554.                 /* metemos entertainment *////////////////////////////////////////////////////////////////
  1555.                 $entertainments = $em->getRepository(SupplierEntertainment::class)->findBySupplierId($id);
  1556.                 if(!empty($entertainments)){
  1557.                     foreach($entertainments as $entertainment){
  1558.                         $supplierservices->setServiceId($entertainment->getId());
  1559.                         $supplierservices->setServiceCatId('6');
  1560.                         $supplierservices->setServiceCatName('Entertainment');
  1562.                         $supplierservices->setName($entertainment->getName());
  1563.                         $supplierservices->setPrice($entertainment->getPrice());
  1564.                         //$supplierservices->setCurrency('Euro');
  1565.                         $supplierservices->setUnits('1');
  1566.                         $supplierservices->setCommission($entertainment->getCommission());
  1567.                         //$supplierservices->setOver('Accommodation');
  1568.                         $supplierservices->setIva($entertainment->getIva());
  1569.                         $supplierservices->setPax('0');
  1570.                         //$supplierservices->setHour('');//null
  1571.                         //$supplierservices->setDateInAt('');
  1572.                         //$supplierservices->setDateOutAt('');
  1573.                         $supplierservices->setDirectPayment('0');
  1574.                         $supplierservices->setStatus('Pending');
  1575.                         $supplierservices->setStatusinternal($additional);
  1578.                         $em->persist($supplierservices);
  1579.                         $em->flush();
  1580.                         $em->clear();
  1582.                         //para pruebas
  1583.                         //$data_prueba[] = array(
  1584.                         //    'data' => $supplierservices
  1585.                         //);
  1586.                     }
  1587.                     //para pruebas
  1588.                     //d($data_prueba);
  1589.                     //exit();
  1590.                 }
  1593.                 /* metemos guide *////////////////////////////////////////////////////////////////
  1594.                 $guides = $em->getRepository(SupplierGuide::class)->findBySupplierId($id);
  1595.                 if(!empty($guides)){
  1596.                     foreach($guides as $guide){
  1597.                         $supplierservices->setServiceId($guide->getId());
  1598.                         $supplierservices->setServiceCatId('8');
  1599.                         $supplierservices->setServiceCatName('Guide');
  1601.                         $supplierservices->setName($guide->getName());
  1602.                         $supplierservices->setPrice($guide->getPrice());
  1603.                         //$supplierservices->setCurrency('Euro');
  1604.                         $supplierservices->setUnits('1');
  1605.                         $supplierservices->setCommission($guide->getCommission());
  1606.                         //$supplierservices->setOver('Accommodation');
  1607.                         $supplierservices->setIva($guide->getIva());
  1608.                         $supplierservices->setPax('0');
  1609.                         //$supplierservices->setHour('');//null
  1610.                         //$supplierservices->setDateInAt('');
  1611.                         //$supplierservices->setDateOutAt('');
  1612.                         $supplierservices->setDirectPayment('0');
  1613.                         $supplierservices->setStatus('Pending');
  1614.                         $supplierservices->setStatusinternal($additional);
  1617.                         $em->persist($supplierservices);
  1618.                         $em->flush();
  1619.                         $em->clear();
  1621.                         //para pruebas
  1622.                         //$data_prueba[] = array(
  1623.                         //    'data' => $supplierservices
  1624.                         //);
  1625.                     }
  1626.                     //para pruebas
  1627.                     //d($data_prueba);
  1628.                     //exit();
  1629.                 }
  1633.                 /* metemos others *////////////////////////////////////////////////////////////////
  1634.                 $otherss = $em->getRepository(SupplierOthers::class)->findBySupplierId($id);
  1635.                 if(!empty($otherss)){
  1636.                     foreach($otherss as $others){
  1637.                         $supplierservices->setServiceId($others->getId());
  1638.                         $supplierservices->setServiceCatId('12');
  1639.                         $supplierservices->setServiceCatName('Others');
  1641.                         $supplierservices->setName($others->getName());
  1642.                         $supplierservices->setPrice($others->getPrice());
  1643.                         //$supplierservices->setCurrency('Euro');
  1644.                         $supplierservices->setUnits('1');
  1645.                         $supplierservices->setCommission($others->getCommission());
  1646.                         //$supplierservices->setOver('Accommodation');
  1647.                         $supplierservices->setIva($others->getIva());
  1648.                         $supplierservices->setPax('0');
  1649.                         //$supplierservices->setHour('');//null
  1650.                         //$supplierservices->setDateInAt('');
  1651.                         //$supplierservices->setDateOutAt('');
  1652.                         $supplierservices->setDirectPayment('0');
  1653.                         $supplierservices->setStatus('Pending');
  1654.                         $supplierservices->setStatusinternal($additional);
  1657.                         $em->persist($supplierservices);
  1658.                         $em->flush();
  1659.                         $em->clear();
  1661.                         //para pruebas
  1662.                         //$data_prueba[] = array(
  1663.                         //    'data' => $supplierservices
  1664.                         //);
  1665.                     }
  1666.                     //para pruebas
  1667.                     //d($data_prueba);
  1668.                     //exit();
  1669.                 }
  1670.                 /* metemos technology *////////////////////////////////////////////////////////////////
  1671.                 $technologys = $em->getRepository(SupplierTechnology::class)->findBySupplierId($id);
  1672.                 if(!empty($technologys)){
  1673.                     foreach($technologys as $technology){
  1674.                         $supplierservices->setServiceId($technology->getId());
  1675.                         $supplierservices->setServiceCatId('14');
  1676.                         $supplierservices->setServiceCatName('Technology');
  1678.                         $supplierservices->setName($technology->getTitle());
  1679.                         $supplierservices->setPrice($technology->getPrice());
  1680.                         //$supplierservices->setCurrency('Euro');
  1681.                         $supplierservices->setUnits('1');
  1682.                         $supplierservices->setCommission($technology->getCommission());
  1683.                         //$supplierservices->setOver('Accommodation');
  1684.                         $supplierservices->setIva($technology->getIva());
  1685.                         $supplierservices->setPax('0');
  1686.                         //$supplierservices->setHour('');//null
  1687.                         //$supplierservices->setDateInAt('');
  1688.                         //$supplierservices->setDateOutAt('');
  1689.                         $supplierservices->setDirectPayment('0');
  1690.                         $supplierservices->setStatus('Pending');
  1691.                         $supplierservices->setStatusinternal($additional);
  1694.                         $em->persist($supplierservices);
  1695.                         $em->flush();
  1696.                         $em->clear();
  1698.                         //para pruebas
  1699.                         //$data_prueba[] = array(
  1700.                         //    'data' => $supplierservices
  1701.                         //);
  1702.                     }
  1703.                     //para pruebas
  1704.                     //d($data_prueba);
  1705.                     //exit();
  1706.                 }
  1708.                 /* metemos Assistant *////////////////////////////////////////////////////////////////
  1709.                 $assistants = $em->getRepository(SupplierServicesAssistant::class)->findBySupplierId($id);
  1710.                 if(!empty($assistants)){
  1711.                     foreach($assistants as $assistant){
  1712.                         $supplierservices->setServiceId($assistant->getId());
  1713.                         $supplierservices->setServiceCatId('15');
  1714.                         $supplierservices->setServiceCatName('Assistant');
  1716.                         $supplierservices->setName($assistant->getName());
  1717.                         $supplierservices->setPrice($assistant->getPrice());
  1718.                         //$supplierservices->setCurrency('Euro');
  1719.                         $supplierservices->setUnits('1');
  1720.                         $supplierservices->setCommission($assistant->getCommission());
  1721.                         //$supplierservices->setOver('Accommodation');
  1722.                         $supplierservices->setIva($assistant->getIva());
  1723.                         $supplierservices->setPax('0');
  1724.                         //$supplierservices->setHour('');//null
  1725.                         //$supplierservices->setDateInAt('');
  1726.                         //$supplierservices->setDateOutAt('');
  1727.                         $supplierservices->setDirectPayment('0');
  1728.                         $supplierservices->setStatus('Pending');
  1729.                         $supplierservices->setStatusinternal($additional);
  1732.                         $em->persist($supplierservices);
  1733.                         $em->flush();
  1734.                         $em->clear();
  1736.                         //para pruebas
  1737.                         //$data_prueba[] = array(
  1738.                         //    'data' => $supplierservices
  1739.                         //);
  1740.                     }
  1741.                     //para pruebas
  1742.                     //d($data_prueba);
  1743.                     //exit();
  1744.                 }
  1747.                 /* FIN METEMOS EL CONTENIDO DE LA IDEA */
  1750.                 // Control para el sistema de revision
  1752.                 $actId = $request->request->get('proposalsuppliercontrol')['activityId'];
  1753.                 $prpId = $request->request->get('proposalsuppliercontrol')['proposalId'];
  1754.                 $activities = $em->getRepository(Activities::class)->findOneById($actId);
  1756.                 $revision1 = new RevisionCarga();
  1757.                 $revision2 = new RevisionCarga();
  1758.                 $revision3 = new RevisionCarga();
  1759.                 $revision1->setIdType($activities->getId());
  1760.                 $revision2->setIdType($activities->getId());
  1761.                 $revision3->setIdType($activities->getId());
  1762.                 $revision1->setName($activities->getName());
  1763.                 $revision2->setName($activities->getName());
  1764.                 $revision3->setName($activities->getName());
  1766.                 // Titulo, Destino y observacion
  1767.                 $revision1->setType('ACTIVIDAD (Título) - Agregada al Proposal:'.$prpId);
  1768.                 $revision1->setLink('activities/edit/'.$activities->getId());
  1769.                 $revision1->setStatus(false);
  1770.                 $em->persist($revision1);
  1771.                 $em->flush();
  1773.                 // Descripcion
  1774.                 $revision2->setType('ACTIVIDAD (Descripción) - Agregada al Proposal:'.$prpId);
  1776.                 // Buscamos el ID de la descripcion
  1777.                 $idact = $activities->getId();
  1778.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByActivityId($idact);
  1779.                 $idctrl = $controlgeneral->getId();
  1780.                 $supdesc = $em->getRepository(SupplierDescription::class)->findOneBySupplierId($idctrl);
  1781.                 $id = $supdesc->getId();
  1783.                 // FIN Buscamos el ID de la descripcion
  1785.                 $revision2->setLink('activities/description/edit/'.$id);
  1786.                 $revision2->setStatus(false);
  1787.                 $em->persist($revision2);
  1788.                 $em->flush();
  1790.                 // Galería
  1791.                 $revision3->setType('ACTIVIDAD (Galería) - Agregada al Proposal:'.$prpId);
  1792.                 $revision3->setLink('activities/gallery/list/'.$activities->getId());
  1793.                 $revision3->setStatus(false);
  1794.                 $em->persist($revision3);
  1795.                 $em->flush();
  1796.                 // FIN Control para el sistema de revision
  1798.                 $event = 'The Idea Destination Proposal has been created.';
  1799.                 $successMessage = $this->translator->trans($event);
  1800.                 $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  1803.             }else{
  1804.                 $errorMessage = $this->translator->trans('Error, some fields are empty');
  1805.                 $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  1806.             }
  1807.         }else{
  1808.             $errorMessage = $this->translator->trans('The proposal already has this Idea included');
  1809.             $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  1810.         }
  1812.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  1813.             'id' => $control->getControlDestinationId(),
  1814.             '_fragment' => 's'.$control->getId()
  1815.         ));
  1817.     }
  1820.     /* CREAR DESDE UNA IDEA */
  1821.     private function createDestinationProposalIdeasCreateForm(ProposalSupplierControl $entity)
  1822.     {
  1823.         $form = $this->createForm(ProposalIdeasControlType::class, $entity, array(
  1824.             'action' => $this->generateUrl('proposal_destination_ideas_create'),
  1825.             'method' => 'POST'
  1826.         ));
  1827.         return $form;
  1828.     }
  1830.     /* CREAR DESDE UNA IDEA */
  1831.     /**
  1832.      * @Route("/proposal/destination/services/createIdea", name="proposal_destination_ideas_create")
  1833.      */
  1834.     public function createProposalIdeaDestinationAction(Request $request)
  1835.     {
  1836.         $control = new ProposalSupplierControl();
  1837.         $form = $this->createDestinationProposalIdeasCreateForm($control);
  1838.         $form->handleRequest($request);
  1840.         $supplier_proposal = $form->get('ideaId')->getData();
  1841.         if(!is_null($supplier_proposal)){
  1842.             $control->setIdeaId($supplier_proposal->getId());
  1843.         }
  1844.         $em = $this->getDoctrine()->getManager();
  1845.         $control_verifico = $em->getRepository(ProposalSupplierControl::class)->findOneBy(
  1846.             array(
  1847.                 'controlDestinationId' => $form->get('controlDestinationId')->getData(),
  1848.                 'proposalId' => $form->get('proposalId')->getData(),
  1849.                 'destinoId' => $form->get('destinoId')->getData(),
  1850.                 'ideaId' => $supplier_proposal->getId(),
  1851.             )
  1852.         );
  1853. //        $proposal = $em->getRepository(Proposal::class)->findOneById($form->get('proposalId')->getData());
  1855.         if(empty($control_verifico)){
  1857.             if($form->isValid())
  1858.             {
  1859.                 $control->setStatus('Pending');
  1860.                 $em->persist($control);
  1861.                 $em->flush();
  1863.                 /* METEMOS EL CONTENIDO DE LA IDEA */
  1864.                 $idcontrol = $control->getId();
  1865.                 $ididea = $control->getIdeaId();
  1867.                 /*CONTROL GENERAL*/
  1868.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByIdeaId($ididea);
  1869.                 $id = $controlgeneral->getId();
  1871.                 $supplierservices= new ProposalSupplierServices();
  1872.                 $supplierservices->setControlId($idcontrol);
  1874.                 $supplierCrtl = $em->getRepository(ProposalSupplierControl::class)->findOneById($idcontrol);
  1875.                 $supplierservices->setProposalId($supplierCrtl->getProposalId());
  1876.                 $supplierservices->setDestinationId($supplierCrtl->getDestinoId());
  1878.                 $supplierservices->setServiceIdFather('0');
  1879.                 $supplierservices->setSupplierId(null);
  1880.                 $supplierservices->setIdeaId($ididea);
  1881.                 $supplierservices->setIsFather('0');
  1885.                 /* NAMEJO DE ADICIONALES EN EL DIA DEL EVENTO O DESPUES EL DIA DEL EVENTO */
  1886.                 $proposal_data = $em->getRepository(Proposal::class)->findOneById($supplierCrtl->getProposalId());
  1887.                 $dayEvent = $proposal_data->getDateEventStarAt()->format('Y-m-d');
  1888.                 $today = date('Y-m-d');
  1890.                 if( $today >= $dayEvent){
  1891.                     $additional = "Additional";
  1892.                 }else{
  1893.                     $additional = "Normal";
  1894.                 }
  1896.                 /* Obtengo usuario logueado */
  1897.                 $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1898.                 $user_id = $user_logueado->getId();
  1899.                 $supplierservices->setCreatedId($user_id);
  1900.                 $supplierservices->setUpdatedId($user_id);
  1902.                 $supplierservices->setDateInAt($proposal_data->getDateEventStarAt());
  1903.                 $supplierservices->setDateOutAt($proposal_data->getDateEventEndAt());
  1905.                 ///////colsulta de servicio
  1908.                 /* metemos accommodation *////////////////////////////////////////////////////////////////
  1909.                 $accommodations = $em->getRepository(SupplierAccommodation::class)->findBySupplierId($id);
  1910.                 //la consulta es al SupplierId porque lo estamos usando como id controlador para SupplierIdeaServicesControl
  1911.                 if(!empty($accommodations)){
  1912.                     foreach($accommodations as $accommodation){
  1913.                         $supplierservices->setServiceId($accommodation->getId());
  1914.                         $supplierservices->setServiceCatId('1');
  1915.                         $supplierservices->setServiceCatName('Accommodation');
  1917.                         $supplierservices->setName($accommodation->getName());
  1918.                         $supplierservices->setPrice($accommodation->getPrice());
  1919.                         //$supplierservices->setCurrency('Euro');
  1920.                         $supplierservices->setUnits('1');
  1921.                         $supplierservices->setCommission('0');
  1922.                         //$supplierservices->setOver('Accommodation');
  1923.                         $supplierservices->setIva('10');
  1924.                         $supplierservices->setPax('0');
  1925.                         //$supplierservices->setHour('');//null
  1926.                         //$supplierservices->setDateInAt('');
  1927.                         //$supplierservices->setDateOutAt('');
  1928.                         $supplierservices->setDirectPayment('0');
  1929.                         $supplierservices->setStatus('Pending');
  1930.                         $supplierservices->setStatusinternal($additional);
  1933.                         $em->persist($supplierservices);
  1934.                         $em->flush();
  1935.                         $em->clear();
  1937.                         //para pruebas
  1938.                         //$data_prueba[] = array(
  1939.                         //    'data' => $supplierservices
  1940.                         //);
  1941.                     }
  1942.                     //para pruebas
  1943.                     //d($data_prueba);
  1944.                     //exit();
  1945.                 }
  1948.                 /* metemos menu *////////////////////////////////////////////////////////////////
  1949.                 $menus = $em->getRepository(SupplierMenu::class)->findBySupplierId($id);
  1950.                 if(!empty($menus)){
  1951.                     foreach($menus as $menu){
  1952.                         $supplierservices->setServiceId($menu->getId());
  1953.                         $supplierservices->setServiceCatId('11');
  1954.                         $supplierservices->setServiceCatName('Menu');
  1956.                         $supplierservices->setName($menu->getTitle());
  1957.                         $supplierservices->setPrice($menu->getPrice());
  1958.                         //$supplierservices->setCurrency('Euro');
  1959.                         $supplierservices->setUnits('1');
  1960.                         $supplierservices->setCommission($menu->getCommission());
  1961.                         //$supplierservices->setOver('Accommodation');
  1962.                         $supplierservices->setIva($menu->getIva());
  1963.                         $supplierservices->setPax('0');
  1964.                         //$supplierservices->setHour('');//null
  1965.                         //$supplierservices->setDateInAt('');
  1966.                         //$supplierservices->setDateOutAt('');
  1967.                         $supplierservices->setDirectPayment('0');
  1968.                         $supplierservices->setStatus('Pending');
  1969.                         $supplierservices->setStatusinternal($additional);
  1972.                         $em->persist($supplierservices);
  1973.                         $em->flush();
  1974.                         $em->clear();
  1976.                         //para pruebas
  1977.                         //$data_prueba[] = array(
  1978.                         //    'data' => $supplierservices
  1979.                         //);
  1980.                     }
  1981.                     //para pruebas
  1982.                     //d($data_prueba);
  1983.                     //exit();
  1984.                 }
  1986.                 /* metemos lounge *////////////////////////////////////////////////////////////////
  1987.                 $lounges = $em->getRepository(SupplierLounge::class)->findBySupplierId($id);
  1988.                 if(!empty($lounges)){
  1989.                     foreach($lounges as $lounge){
  1990.                         $supplierservices->setServiceId($lounge->getId());
  1991.                         $supplierservices->setServiceCatId('10');
  1992.                         $supplierservices->setServiceCatName('Lounge');
  1994.                         $supplierservices->setName($lounge->getName());
  1995.                         $supplierservices->setPrice($lounge->getPrice());
  1996.                         //$supplierservices->setCurrency('Euro');
  1997.                         $supplierservices->setUnits('1');
  1998.                         $supplierservices->setCommission($lounge->getCommission());
  1999.                         //$supplierservices->setOver('Accommodation');
  2000.                         $supplierservices->setIva($lounge->getIva());
  2001.                         $supplierservices->setPax('0');
  2002.                         //$supplierservices->setHour('');//null
  2003.                         //$supplierservices->setDateInAt('');
  2004.                         //$supplierservices->setDateOutAt('');
  2005.                         $supplierservices->setDirectPayment('0');
  2006.                         $supplierservices->setStatus('Pending');
  2007.                         $supplierservices->setStatusinternal($additional);
  2010.                         $em->persist($supplierservices);
  2011.                         $em->flush();
  2012.                         $em->clear();
  2014.                         //para pruebas
  2015.                         //$data_prueba[] = array(
  2016.                         //    'data' => $supplierservices
  2017.                         //);
  2018.                     }
  2019.                     //para pruebas
  2020.                     //d($data_prueba);
  2021.                     //exit();
  2022.                 }
  2025.                 /* metemos activities *////////////////////////////////////////////////////////////////
  2026.                 $activitiess = $em->getRepository(SupplierActivities::class)->findBySupplierId($id);
  2027.                 if(!empty($activitiess)){
  2028.                     foreach($activitiess as $activities){
  2029.                         $supplierservices->setServiceId($activities->getId());
  2030.                         $supplierservices->setServiceCatId('2');
  2031.                         $supplierservices->setServiceCatName('Activities');
  2033.                         $supplierservices->setName($activities->getTitle());
  2034.                         $supplierservices->setPrice($activities->getPrice());
  2035.                         //$supplierservices->setCurrency('Euro');
  2036.                         $supplierservices->setUnits('1');
  2037.                         $supplierservices->setCommission($activities->getCommission());
  2038.                         //$supplierservices->setOver('Accommodation');
  2039.                         $supplierservices->setIva($activities->getIva());
  2040.                         $supplierservices->setPax('0');
  2041.                         //$supplierservices->setHour('');//null
  2042.                         //$supplierservices->setDateInAt('');
  2043.                         //$supplierservices->setDateOutAt('');
  2044.                         $supplierservices->setDirectPayment('0');
  2045.                         $supplierservices->setStatus('Pending');
  2046.                         $supplierservices->setStatusinternal($additional);
  2049.                         $em->persist($supplierservices);
  2050.                         $em->flush();
  2051.                         $em->clear();
  2053.                         //para pruebas
  2054.                         //$data_prueba[] = array(
  2055.                         //    'data' => $supplierservices
  2056.                         //);
  2057.                     }
  2058.                     //para pruebas
  2059.                     //d($data_prueba);
  2060.                     //exit();
  2061.                 }
  2064.                 /* metemos itineraries *////////////////////////////////////////////////////////////////
  2065.                 $itinerariess = $em->getRepository(SupplierItineraries::class)->findBySupplierId($id);
  2066.                 if(!empty($itinerariess)){
  2067.                     foreach($itinerariess as $itineraries){
  2068.                         $supplierservices->setServiceId($itineraries->getId());
  2069.                         $supplierservices->setServiceCatId('9');
  2070.                         $supplierservices->setServiceCatName('Itineraries');
  2072.                         $supplierservices->setName($itineraries->getTitle());
  2073.                         $supplierservices->setPrice('0');
  2074.                         //$supplierservices->setCurrency('Euro');
  2075.                         $supplierservices->setUnits('1');
  2076.                         $supplierservices->setCommission('0');
  2077.                         //$supplierservices->setOver('Accommodation');
  2078.                         $supplierservices->setIva('10');
  2079.                         $supplierservices->setPax('0');
  2080.                         //$supplierservices->setHour('');//null
  2081.                         //$supplierservices->setDateInAt('');
  2082.                         //$supplierservices->setDateOutAt('');
  2083.                         $supplierservices->setDirectPayment('0');
  2084.                         $supplierservices->setStatus('Pending');
  2085.                         $supplierservices->setStatusinternal($additional);
  2088.                         $em->persist($supplierservices);
  2089.                         $em->flush();
  2090.                         $em->clear();
  2092.                         //para pruebas
  2093.                         //$data_prueba[] = array(
  2094.                         //    'data' => $supplierservices
  2095.                         //);
  2096.                     }
  2097.                     //para pruebas
  2098.                     //d($data_prueba);
  2099.                     //exit();
  2100.                 }
  2103.                 /* metemos cruise *////////////////////////////////////////////////////////////////
  2104.                 $cruises = $em->getRepository(SupplierCruise::class)->findBySupplierId($id);
  2105.                 if(!empty($cruises)){
  2106.                     foreach($cruises as $cruise){
  2107.                         $supplierservices->setServiceId($cruise->getId());
  2108.                         $supplierservices->setServiceCatId('5');
  2109.                         $supplierservices->setServiceCatName('Cruise');
  2111.                         $supplierservices->setName($cruise->getTitle());
  2112.                         $supplierservices->setPrice($cruise->getPrice());
  2113.                         //$supplierservices->setCurrency('Euro');
  2114.                         $supplierservices->setUnits('1');
  2115.                         $supplierservices->setCommission($cruise->getCommission());
  2116.                         //$supplierservices->setOver('Accommodation');
  2117.                         $supplierservices->setIva($cruise->getIva());
  2118.                         $supplierservices->setPax('0');
  2119.                         //$supplierservices->setHour('');//null
  2120.                         //$supplierservices->setDateInAt('');
  2121.                         //$supplierservices->setDateOutAt('');
  2122.                         $supplierservices->setDirectPayment('0');
  2123.                         $supplierservices->setStatus('Pending');
  2124.                         $supplierservices->setStatusinternal($additional);
  2127.                         $em->persist($supplierservices);
  2128.                         $em->flush();
  2129.                         $em->clear();
  2131.                         //para pruebas
  2132.                         //$data_prueba[] = array(
  2133.                         //    'data' => $supplierservices
  2134.                         //);
  2135.                     }
  2136.                     //para pruebas
  2137.                     //d($data_prueba);
  2138.                     //exit();
  2139.                 }
  2142.                 /* metemos transport *////////////////////////////////////////////////////////////////
  2143.                 $transports = $em->getRepository(SupplierTransport::class)->findBySupplierId($id);
  2144.                 if(!empty($transports)){
  2145.                     foreach($transports as $transport){
  2146.                         $supplierservices->setServiceId($transport->getId());
  2147.                         $supplierservices->setServiceCatId('13');
  2148.                         $supplierservices->setServiceCatName('Transport');
  2150.                         $supplierservices->setName($transport->getName());
  2151.                         $supplierservices->setPrice($transport->getPrice());
  2152.                         //$supplierservices->setCurrency('Euro');
  2153.                         $supplierservices->setUnits('1');
  2154.                         $supplierservices->setCommission($transport->getCommission());
  2155.                         //$supplierservices->setOver('Accommodation');
  2156.                         $supplierservices->setIva($transport->getIva());
  2157.                         $supplierservices->setPax('0');
  2158.                         //$supplierservices->setHour('');//null
  2159.                         //$supplierservices->setDateInAt('');
  2160.                         //$supplierservices->setDateOutAt('');
  2161.                         $supplierservices->setDirectPayment('0');
  2162.                         $supplierservices->setStatus('Pending');
  2163.                         $supplierservices->setStatusinternal($additional);
  2166.                         $em->persist($supplierservices);
  2167.                         $em->flush();
  2168.                         $em->clear();
  2170.                         //para pruebas
  2171.                         //$data_prueba[] = array(
  2172.                         //    'data' => $supplierservices
  2173.                         //);
  2174.                     }
  2175.                     //para pruebas
  2176.                     //d($data_prueba);
  2177.                     //exit();
  2178.                 }
  2182.                 /* metemos av *////////////////////////////////////////////////////////////////
  2183.                 $avs = $em->getRepository(SupplierAv::class)->findBySupplierId($id);
  2184.                 if(!empty($avs)){
  2185.                     foreach($avs as $av){
  2186.                         $supplierservices->setServiceId($av->getId());
  2187.                         $supplierservices->setServiceCatId('3');
  2188.                         $supplierservices->setServiceCatName('Av');
  2190.                         $supplierservices->setName($av->getName());
  2191.                         $supplierservices->setPrice($av->getPrice());
  2192.                         //$supplierservices->setCurrency('Euro');
  2193.                         $supplierservices->setUnits('1');
  2194.                         $supplierservices->setCommission($av->getCommission());
  2195.                         //$supplierservices->setOver('Accommodation');
  2196.                         $supplierservices->setIva($av->getIva());
  2197.                         $supplierservices->setPax('0');
  2198.                         //$supplierservices->setHour('');//null
  2199.                         //$supplierservices->setDateInAt('');
  2200.                         //$supplierservices->setDateOutAt('');
  2201.                         $supplierservices->setDirectPayment('0');
  2202.                         $supplierservices->setStatus('Pending');
  2203.                         $supplierservices->setStatusinternal($additional);
  2206.                         $em->persist($supplierservices);
  2207.                         $em->flush();
  2208.                         $em->clear();
  2210.                         //para pruebas
  2211.                         //$data_prueba[] = array(
  2212.                         //    'data' => $supplierservices
  2213.                         //);
  2214.                     }
  2215.                     //para pruebas
  2216.                     //d($data_prueba);
  2217.                     //exit();
  2218.                 }
  2222.                 /* metemos creative *////////////////////////////////////////////////////////////////
  2223.                 $creatives = $em->getRepository(SupplierCreative::class)->findBySupplierId($id);
  2224.                 if(!empty($creatives)){
  2225.                     foreach($creatives as $creative){
  2226.                         $supplierservices->setServiceId($creative->getId());
  2227.                         $supplierservices->setServiceCatId('4');
  2228.                         $supplierservices->setServiceCatName('Creative');
  2230.                         $supplierservices->setName($creative->getTitle());
  2231.                         $supplierservices->setPrice('0');
  2232.                         //$supplierservices->setCurrency('Euro');
  2233.                         $supplierservices->setUnits('1');
  2234.                         $supplierservices->setCommission('0');
  2235.                         //$supplierservices->setOver('Accommodation');
  2236.                         $supplierservices->setIva('21');
  2237.                         $supplierservices->setPax('0');
  2238.                         //$supplierservices->setHour('');//null
  2239.                         //$supplierservices->setDateInAt('');
  2240.                         //$supplierservices->setDateOutAt('');
  2241.                         $supplierservices->setDirectPayment('0');
  2242.                         $supplierservices->setStatus('Pending');
  2243.                         $supplierservices->setStatusinternal($additional);
  2246.                         $em->persist($supplierservices);
  2247.                         $em->flush();
  2248.                         $em->clear();
  2250.                         //para pruebas
  2251.                         //$data_prueba[] = array(
  2252.                         //    'data' => $supplierservices
  2253.                         //);
  2254.                     }
  2255.                     //para pruebas
  2256.                     //d($data_prueba);
  2257.                     //exit();
  2258.                 }
  2261.                 /* metemos gift *////////////////////////////////////////////////////////////////
  2262.                 $gifts = $em->getRepository(SupplierGifts::class)->findBySupplierId($id);
  2263.                 if(!empty($gifts)){
  2264.                     foreach($gifts as $gift){
  2265.                         $supplierservices->setServiceId($gift->getId());
  2266.                         $supplierservices->setServiceCatId('7');
  2267.                         $supplierservices->setServiceCatName('Gifts');
  2269.                         $supplierservices->setName($gift->getName());
  2270.                         $supplierservices->setPrice($gift->getPrice());
  2271.                         //$supplierservices->setCurrency('Euro');
  2272.                         $supplierservices->setUnits('1');
  2273.                         $supplierservices->setCommission($gift->getCommission());
  2274.                         //$supplierservices->setOver('Accommodation');
  2275.                         $supplierservices->setIva($gift->getIva());
  2276.                         $supplierservices->setPax('0');
  2277.                         //$supplierservices->setHour('');//null
  2278.                         //$supplierservices->setDateInAt('');
  2279.                         //$supplierservices->setDateOutAt('');
  2280.                         $supplierservices->setDirectPayment('0');
  2281.                         $supplierservices->setStatus('Pending');
  2282.                         $supplierservices->setStatusinternal($additional);
  2285.                         $em->persist($supplierservices);
  2286.                         $em->flush();
  2287.                         $em->clear();
  2289.                         //para pruebas
  2290.                         //$data_prueba[] = array(
  2291.                         //    'data' => $supplierservices
  2292.                         //);
  2293.                     }
  2294.                     //para pruebas
  2295.                     //d($data_prueba);
  2296.                     //exit();
  2297.                 }
  2300.                 /* metemos entertainment *////////////////////////////////////////////////////////////////
  2301.                 $entertainments = $em->getRepository(SupplierEntertainment::class)->findBySupplierId($id);
  2302.                 if(!empty($entertainments)){
  2303.                     foreach($entertainments as $entertainment){
  2304.                         $supplierservices->setServiceId($entertainment->getId());
  2305.                         $supplierservices->setServiceCatId('6');
  2306.                         $supplierservices->setServiceCatName('Entertainment');
  2308.                         $supplierservices->setName($entertainment->getName());
  2309.                         $supplierservices->setPrice($entertainment->getPrice());
  2310.                         //$supplierservices->setCurrency('Euro');
  2311.                         $supplierservices->setUnits('1');
  2312.                         $supplierservices->setCommission($entertainment->getCommission());
  2313.                         //$supplierservices->setOver('Accommodation');
  2314.                         $supplierservices->setIva($entertainment->getIva());
  2315.                         $supplierservices->setPax('0');
  2316.                         //$supplierservices->setHour('');//null
  2317.                         //$supplierservices->setDateInAt('');
  2318.                         //$supplierservices->setDateOutAt('');
  2319.                         $supplierservices->setDirectPayment('0');
  2320.                         $supplierservices->setStatus('Pending');
  2321.                         $supplierservices->setStatusinternal($additional);
  2324.                         $em->persist($supplierservices);
  2325.                         $em->flush();
  2326.                         $em->clear();
  2328.                         //para pruebas
  2329.                         //$data_prueba[] = array(
  2330.                         //    'data' => $supplierservices
  2331.                         //);
  2332.                     }
  2333.                     //para pruebas
  2334.                     //d($data_prueba);
  2335.                     //exit();
  2336.                 }
  2339.                 /* metemos guide *////////////////////////////////////////////////////////////////
  2340.                 $guides = $em->getRepository(SupplierGuide::class)->findBySupplierId($id);
  2341.                 if(!empty($guides)){
  2342.                     foreach($guides as $guide){
  2343.                         $supplierservices->setServiceId($guide->getId());
  2344.                         $supplierservices->setServiceCatId('8');
  2345.                         $supplierservices->setServiceCatName('Guide');
  2347.                         $supplierservices->setName($guide->getName());
  2348.                         $supplierservices->setPrice($guide->getPrice());
  2349.                         //$supplierservices->setCurrency('Euro');
  2350.                         $supplierservices->setUnits('1');
  2351.                         $supplierservices->setCommission($guide->getCommission());
  2352.                         //$supplierservices->setOver('Accommodation');
  2353.                         $supplierservices->setIva($guide->getIva());
  2354.                         $supplierservices->setPax('0');
  2355.                         //$supplierservices->setHour('');//null
  2356.                         //$supplierservices->setDateInAt('');
  2357.                         //$supplierservices->setDateOutAt('');
  2358.                         $supplierservices->setDirectPayment('0');
  2359.                         $supplierservices->setStatus('Pending');
  2360.                         $supplierservices->setStatusinternal($additional);
  2363.                         $em->persist($supplierservices);
  2364.                         $em->flush();
  2365.                         $em->clear();
  2367.                         //para pruebas
  2368.                         //$data_prueba[] = array(
  2369.                         //    'data' => $supplierservices
  2370.                         //);
  2371.                     }
  2372.                     //para pruebas
  2373.                     //d($data_prueba);
  2374.                     //exit();
  2375.                 }
  2379.                 /* metemos others *////////////////////////////////////////////////////////////////
  2380.                 $otherss = $em->getRepository(SupplierOthers::class)->findBySupplierId($id);
  2381.                 if(!empty($otherss)){
  2382.                     foreach($otherss as $others){
  2383.                         $supplierservices->setServiceId($others->getId());
  2384.                         $supplierservices->setServiceCatId('12');
  2385.                         $supplierservices->setServiceCatName('Others');
  2387.                         $supplierservices->setName($others->getName());
  2388.                         $supplierservices->setPrice($others->getPrice());
  2389.                         //$supplierservices->setCurrency('Euro');
  2390.                         $supplierservices->setUnits('1');
  2391.                         $supplierservices->setCommission($others->getCommission());
  2392.                         //$supplierservices->setOver('Accommodation');
  2393.                         $supplierservices->setIva($others->getIva());
  2394.                         $supplierservices->setPax('0');
  2395.                         //$supplierservices->setHour('');//null
  2396.                         //$supplierservices->setDateInAt('');
  2397.                         //$supplierservices->setDateOutAt('');
  2398.                         $supplierservices->setDirectPayment('0');
  2399.                         $supplierservices->setStatus('Pending');
  2400.                         $supplierservices->setStatusinternal($additional);
  2403.                         $em->persist($supplierservices);
  2404.                         $em->flush();
  2405.                         $em->clear();
  2407.                         //para pruebas
  2408.                         //$data_prueba[] = array(
  2409.                         //    'data' => $supplierservices
  2410.                         //);
  2411.                     }
  2412.                     //para pruebas
  2413.                     //d($data_prueba);
  2414.                     //exit();
  2415.                 }
  2416.                 /* metemos technology *////////////////////////////////////////////////////////////////
  2417.                 $technologys = $em->getRepository(SupplierTechnology::class)->findBySupplierId($id);
  2418.                 if(!empty($technologys)){
  2419.                     foreach($technologys as $technology){
  2420.                         $supplierservices->setServiceId($technology->getId());
  2421.                         $supplierservices->setServiceCatId('14');
  2422.                         $supplierservices->setServiceCatName('Technology');
  2424.                         $supplierservices->setName($technology->getTitle());
  2425.                         $supplierservices->setPrice($technology->getPrice());
  2426.                         //$supplierservices->setCurrency('Euro');
  2427.                         $supplierservices->setUnits('1');
  2428.                         $supplierservices->setCommission($technology->getCommission());
  2429.                         //$supplierservices->setOver('Accommodation');
  2430.                         $supplierservices->setIva($technology->getIva());
  2431.                         $supplierservices->setPax('0');
  2432.                         //$supplierservices->setHour('');//null
  2433.                         //$supplierservices->setDateInAt('');
  2434.                         //$supplierservices->setDateOutAt('');
  2435.                         $supplierservices->setDirectPayment('0');
  2436.                         $supplierservices->setStatus('Pending');
  2437.                         $supplierservices->setStatusinternal($additional);
  2440.                         $em->persist($supplierservices);
  2441.                         $em->flush();
  2442.                         $em->clear();
  2444.                         //para pruebas
  2445.                         //$data_prueba[] = array(
  2446.                         //    'data' => $supplierservices
  2447.                         //);
  2448.                     }
  2449.                     //para pruebas
  2450.                     //d($data_prueba);
  2451.                     //exit();
  2452.                 }
  2454.                 /* metemos Assistant *////////////////////////////////////////////////////////////////
  2455.                 $assistants = $em->getRepository(SupplierServicesAssistant::class)->findBySupplierId($id);
  2456.                 if(!empty($assistants)){
  2457.                     foreach($assistants as $assistant){
  2458.                         $supplierservices->setServiceId($assistant->getId());
  2459.                         $supplierservices->setServiceCatId('15');
  2460.                         $supplierservices->setServiceCatName('Assistant');
  2462.                         $supplierservices->setName($assistant->getName());
  2463.                         $supplierservices->setPrice($assistant->getPrice());
  2464.                         //$supplierservices->setCurrency('Euro');
  2465.                         $supplierservices->setUnits('1');
  2466.                         $supplierservices->setCommission($assistant->getCommission());
  2467.                         //$supplierservices->setOver('Accommodation');
  2468.                         $supplierservices->setIva($assistant->getIva());
  2469.                         $supplierservices->setPax('0');
  2470.                         //$supplierservices->setHour('');//null
  2471.                         //$supplierservices->setDateInAt('');
  2472.                         //$supplierservices->setDateOutAt('');
  2473.                         $supplierservices->setDirectPayment('0');
  2474.                         $supplierservices->setStatus('Pending');
  2475.                         $supplierservices->setStatusinternal($additional);
  2478.                         $em->persist($supplierservices);
  2479.                         $em->flush();
  2480.                         $em->clear();
  2482.                         //para pruebas
  2483.                         //$data_prueba[] = array(
  2484.                         //    'data' => $supplierservices
  2485.                         //);
  2486.                     }
  2487.                     //para pruebas
  2488.                     //d($data_prueba);
  2489.                     //exit();
  2490.                 }
  2493.                 /* FIN METEMOS EL CONTENIDO DE LA IDEA */
  2495.                 // Control para el sistema de revision
  2497.                 $ideas = $em->getRepository(Ideas::class)->findOneById($supplier_proposal->getId());
  2498.                 $prpId = $request->request->get('proposalsuppliercontrol')['proposalId'];
  2499.                 $revision1 = new RevisionCarga();
  2500.                 $revision2 = new RevisionCarga();
  2501.                 $revision3 = new RevisionCarga();
  2502.                 $revision1->setIdType($ideas->getId());
  2503.                 $revision2->setIdType($ideas->getId());
  2504.                 $revision3->setIdType($ideas->getId());
  2505.                 $revision1->setName($ideas->getName());
  2506.                 $revision2->setName($ideas->getName());
  2507.                 $revision3->setName($ideas->getName());
  2509.                 // Titulo, Destino y observacion
  2510.                 $revision1->setType('IDEA (Título) - Agregada al Proposal: '.$prpId);
  2511.                 $revision1->setLink('ideas/edit/'.$ideas->getId());
  2512.                 $revision1->setStatus(false);
  2513.                 $em->persist($revision1);
  2514.                 $em->flush();
  2516.                 // Descripcion
  2517.                 $revision2->setType('IDEA (Descripción) - Agregada al Proposal: '.$prpId);
  2519.                 // Buscamos el ID de la descripcion
  2520.                 $idact = $ideas->getId();
  2521.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByIdeaId($idact);
  2522.                 $idctrl = $controlgeneral->getId();
  2523.                 $supdesc = $em->getRepository(SupplierDescription::class)->findOneBySupplierId($idctrl);
  2524.                 $id = $supdesc->getId();
  2526.                 // FIN Buscamos el ID de la descripcion
  2528.                 $revision2->setLink('ideas/description/edit/'.$id);
  2529.                 $revision2->setStatus(false);
  2530.                 $em->persist($revision2);
  2531.                 $em->flush();
  2533.                 // Galería
  2534.                 $revision3->setType('IDEA (Galería) - Agregada al Proposal: '.$prpId);
  2535.                 $revision3->setLink('ideas/gallery/list/'.$ideas->getId());
  2536.                 $revision3->setStatus(false);
  2537.                 $em->persist($revision3);
  2538.                 $em->flush();
  2539.                 // FIN Control para el sistema de revision
  2541.                 $event = 'The Idea Destination Proposal has been created.';
  2542.                 $successMessage = $this->translator->trans($event);
  2543.                 $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  2546.             }else{
  2547.                 $errorMessage = $this->translator->trans('Error, some fields are empty');
  2548.                 $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  2549.             }
  2550.         }else{
  2551.             $errorMessage = $this->translator->trans('The proposal already has this Idea included');
  2552.             $this->addFlash('mensajeproposaldestinationserviceserror', $errorMessage);
  2553.         }
  2555.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  2556.             'id' => $control->getControlDestinationId(),
  2557.             '_fragment' => 's'.$control->getId()
  2558.         ));
  2559.     }
  2562.     /**
  2563.      * @Route("proposal/destination/services/disabled/{id}", name="proposal_destination_supplier_disabled")
  2564.      *
  2565.      */
  2566.     public function disabledAction($id, Request $request)
  2567.     {
  2568.         $em = $this->getDoctrine()->getManager();
  2569.         $disabled = $em->getRepository(ProposalSupplierControl::class)->findOneById($id);
  2570.         $proposal= $em->getRepository(Proposal::class)->findOneById($disabled->getProposalId());
  2572.         $actual = $disabled->getDisabled();
  2574.         $var_mensaje="";
  2575.         if($actual == "0"){
  2576.             $disabled->setDisabled('1');
  2577.             $var_mensaje = "Disabled";
  2578.         }
  2579.         if($actual == "1"){
  2580.             $disabled->setDisabled('0');
  2581.             $var_mensaje = "Activated";
  2582.         }
  2583.         $em->persist($disabled);
  2584.         $em->flush();
  2586.         $event = 'The supplier has been. '.$var_mensaje;
  2587.         $successMessage = $this->translator->trans($event);
  2588.         $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  2590.         return $this->redirectToRoute('proposal_destination_supplier_view',
  2591.             array(
  2592.                 'id' => $disabled->getControlDestinationId(),
  2593.                 '_fragment' => 's'.$disabled->getId()
  2594.             )
  2595.         );
  2596.     }
  2598.     /**
  2599.      * @Route("proposal/destination/services/deleted/{id}", name="proposal_destination_supplier_deleted")
  2600.      *
  2601.      */
  2602. //    public function deleteAction($id, Request $request, LoggerInterface $logger)
  2603.     public function deleteAction($id, Request $request)
  2604.     {
  2605.         $em = $this->getDoctrine()->getManager();
  2606.         $delete = $em->getRepository(ProposalSupplierControl::class)->findOneById($id);
  2607.         $proposal = $em->getRepository(Proposal::class)->findOneById($delete->getProposalId());
  2609.         $delete_services = $em->getRepository(ProposalSupplierServices::class)->findByControlId($id);
  2610.         foreach ($delete_services as $delete_service) {
  2611.             $em->remove($delete_service);
  2612.         }
  2613.         $em->remove($delete);
  2614.         $em->flush();
  2616.         $event = 'The supplier has been Deleted.';
  2617.         $successMessage = $this->translator->trans($event);
  2618.         $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  2620.         return $this->redirectToRoute('proposal_destination_supplier_view',
  2621.             array(
  2622.                 'id' => $delete->getControlDestinationId()
  2623.             )
  2624.         );
  2625.     }
  2627.     /**
  2628.      * @Route("proposal/destination/services/list/{idcontrol}", name="proposal_destination_supplier_list")
  2629.      */
  2630.     public function listAction($idcontrol, Request $request) {
  2632.         $em = $this->getDoctrine()->getManager();
  2633.         $control = $em->getRepository(ProposalSupplierControl::class)->findOneById($idcontrol);
  2634.         $idsupplier = $control->getSupplierId();
  2635.         $ididea = $control->getIdeaId();
  2636.         $idactivity = $control->getActivityId();
  2638.         if($idsupplier == '0'){
  2639.             $id = '0';
  2640.         }else{
  2641.             if(!is_null($idsupplier)){
  2642.                 /*CONTROL GENERAL*/
  2643.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneBySupplierId($idsupplier);
  2644.                 $id = $controlgeneral->getId();
  2645.             }
  2646.             if(!is_null($idactivity)){
  2647.                 /*CONTROL GENERAL*/
  2648.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByActivityId($idactivity);
  2649.                 $id = $controlgeneral->getId();
  2650.             }
  2651.             if(!is_null($ididea)){
  2652.                 /*CONTROL GENERAL*/
  2653.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByIdeaId($ididea);
  2654.                 $id = $controlgeneral->getId();
  2655.             }
  2656.         }
  2658.         /* accommodations */
  2659.         $accommodations = $em->getRepository(SupplierAccommodation::class)->findBySupplierId($id);
  2660.         $data_accommodation = array();
  2661.         foreach ($accommodations as $accommodation) {
  2663.             /* Consulta en Control Services */
  2664.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2665.                 'servicesId' => $accommodation->getId(),
  2666.                 'servicesCat' => $accommodation->getControlCat()
  2667.             ));
  2669.             //class="label label-flat label-rounded label-icon border-grey text-grey"
  2670.             if ($accommodation->getMinibar()){
  2671.                 $accommodation->setMinibar('<span class="label quitar-margin-15"><img src="/assets/images/icons/mi-20.png"></span>');
  2672.             }
  2673.             if ($accommodation->getWifi()){
  2674.                 $accommodation->setWifi('<span class="label quitar-margin-15"><img src="/assets/images/icons/wi-20.png"></span>');
  2675.             }
  2676.             if ($accommodation->getAirconditioner()){
  2677.                 $accommodation->setAirconditioner('<span class="label quitar-margin-15"><img src="/assets/images/icons/ac-20.png"></span>');
  2678.             }
  2679.             if ($accommodation->getCalefaction()){
  2680.                 $accommodation->setCalefaction('<span class="label quitar-margin-15"><img src="/assets/images/icons/ca-20.png"></span>');
  2681.             }
  2682.             if ($accommodation->getPool()){
  2683.                 $accommodation->setPool('<span class="label quitar-margin-15"><img src="/assets/images/icons/po-20.png"></span>');
  2684.             }
  2685.             if ($accommodation->getBath()){
  2686.                 $accommodation->setBath('<span class="label quitar-margin-15"><img src="/assets/images/icons/ba-20.png"></span>');
  2687.             }
  2688.             if ($accommodation->getCoffeemaker()){
  2689.                 $accommodation->setCoffeemaker('<span class="label quitar-margin-15"><img src="/assets/images/icons/cm-20.png"></span>');
  2690.             }
  2691.             if ($accommodation->getKitchen()){
  2692.                 $accommodation->setKitchen('<span class="label quitar-margin-15"><img src="/assets/images/icons/ki-20.png"></span>');
  2693.             }
  2694.             if ($accommodation->getWasher()){
  2695.                 $accommodation->setWasher('<span class="label quitar-margin-15"><img src="/assets/images/icons/wa-20.png"></span>');
  2696.             }
  2697.             if ($accommodation->getFlattv()){
  2698.                 $accommodation->setFlattv('<span class="label quitar-margin-15"><img src="/assets/images/icons/tv-20.png"></span>');
  2699.             }
  2700.             if ($accommodation->getElectrickettle()){
  2701.                 $accommodation->setElectrickettle('<span class="label quitar-margin-15"><img src="/assets/images/icons/ke-20.png"></span>');
  2702.             }
  2703.             if ($accommodation->getViews()){
  2704.                 $accommodation->setViews('<span class="label quitar-margin-15"><img src="/assets/images/icons/vi-20.png"></span>');
  2705.             }
  2706.             if ($accommodation->getPets()){
  2707.                 $accommodation->setPets('<span class="label quitar-margin-15"><img src="/assets/images/icons/pe-20.png"></span>');
  2708.             }
  2710. //                $data_accommodation[]=$accommodation;
  2711.             $data_accommodation[] = array(
  2712.                 'id' => $accommodation->getId(),
  2713.                 'name' => $accommodation->getName(),
  2714.                 'size' => $accommodation->getSize(),
  2715.                 'quantity' => $accommodation->getQuantity(),
  2716.                 'price' => $accommodation->getPrice(),
  2717.                 'controlId' => $controlctrlDes->getId(),
  2719.                 'minibar' => $accommodation->getMinibar(),
  2720.                 'wifi' => $accommodation->getWifi(),
  2721.                 'airconditioner' => $accommodation->getAirconditioner(),
  2722.                 'calefaction' => $accommodation->getCalefaction(),
  2723.                 'pool' => $accommodation->getPool(),
  2724.                 'bath' => $accommodation->getBath(),
  2725.                 'coffeemaker' => $accommodation->getCoffeemaker(),
  2726.                 'kitchen' => $accommodation->getKitchen(),
  2727.                 'washer' => $accommodation->getWasher(),
  2728.                 'flattv' => $accommodation->getFlattv(),
  2729.                 'electrickettle' => $accommodation->getElectrickettle(),
  2730.                 'views' => $accommodation->getViews(),
  2731.                 'pets' => $accommodation->getPets()
  2732.             );
  2733.         }
  2734.         /* accommodations */
  2736.         /* menu */
  2737.         $menus = $em->getRepository(SupplierMenu::class)->findBySupplierId($id);
  2738.         /* menu Description*/
  2739.         $data_menu = array();
  2740.         foreach($menus as $menu){
  2742.             /* Consulta en Control Description */
  2743.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2744.                 'servicesId' => $menu->getId(),
  2745.                 'servicesCat' => $menu->getControlCat()
  2746.             ));
  2747. //            $controlctrlDes->getId();
  2748. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2750.             $data_menu[] = array(
  2751.                 'id' => $menu->getId(),
  2752.                 'title' => $menu->getTitle(),
  2753.                 'description' => $menu->getDescription(),
  2754.                 'currency' => $menu->getCurrency(),
  2755.                 'price' => $menu->getPrice(),
  2756.                 'commission' => $menu->getCommission(),
  2757.                 'iva' => $menu->getIva(),
  2758.                 'controlId' => $controlctrlDes->getId()
  2759.             );
  2760.         }
  2762.         /* lounge */
  2763.         $lounges = $em->getRepository(SupplierLounge::class)->findBySupplierId($id);
  2764.         /* lounge Description*/
  2765.         $data_lounge = array();
  2766.         foreach($lounges as $lounge){
  2768.             /* Consulta en Control Description */
  2769.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2770.                 'servicesId' => $lounge->getId(),
  2771.                 'servicesCat' => $lounge->getControlCat()
  2772.             ));
  2773. //            $controlctrlDes->getId();
  2774. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2776.             $data_lounge[] = array(
  2777.                 'id' => $lounge->getId(),
  2778.                 'name' => $lounge->getName(),
  2779.                 'currency' => $lounge->getCurrency(),
  2780.                 'price' => $lounge->getPrice(),
  2781.                 'commission' => $lounge->getCommission(),
  2782.                 'iva' => $lounge->getIva(),
  2783.                 'controlId' => $controlctrlDes->getId()
  2784.             );
  2785.         }
  2787.         /* Transport */
  2788.         $transports = $em->getRepository(SupplierTransport::class)->findBySupplierId($id);
  2789.         /* Transport Description*/
  2790.         $data_transport = array();
  2791.         foreach($transports as $transport){
  2793.             /* Consulta en Control Description */
  2794.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2795.                 'servicesId' => $transport->getId(),
  2796.                 'servicesCat' => $transport->getControlCat()
  2797.             ));
  2798. //            $controlctrlDes->getId();
  2799. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2801.             $data_transport[] = array(
  2802.                 'id' => $transport->getId(),
  2803.                 'name' => $transport->getName(),
  2804.                 'driver' => $transport->getDriver(),
  2805.                 'currency' => $transport->getCurrency(),
  2806.                 'price' => $transport->getPrice(),
  2807.                 'commission' => $transport->getCommission(),
  2808.                 'iva' => $transport->getIva(),
  2809.                 'controlId' => $controlctrlDes->getId()
  2810.             );
  2811.         }
  2813.         /* Guide */
  2814.         $guides = $em->getRepository(SupplierGuide::class)->findBySupplierId($id);
  2815.         /* Guide Description*/
  2816.         $data_guide = array();
  2817.         foreach($guides as $guide){
  2819.             /* Consulta en Control Description */
  2820.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2821.                 'servicesId' => $guide->getId(),
  2822.                 'servicesCat' => $guide->getControlCat()
  2823.             ));
  2824. //            $controlctrlDes->getId();
  2825. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2827.             $data_guide[] = array(
  2828.                 'id' => $guide->getId(),
  2829.                 'name' => $guide->getName(),
  2830.                 'guide' => $guide->getGuide(),
  2831.                 'currency' => $guide->getCurrency(),
  2832.                 'price' => $guide->getPrice(),
  2833.                 'commission' => $guide->getCommission(),
  2834.                 'iva' => $guide->getIva(),
  2835.                 'controlId' => $controlctrlDes->getId()
  2836.             );
  2837.         }
  2839.         /* Itineraries */
  2840.         $itinerariess = $em->getRepository(SupplierItineraries::class)->findBySupplierId($id);
  2841.         /* Itineraries Description*/
  2842.         $data_itineraries = array();
  2843.         foreach($itinerariess as $itineraries){
  2845.             /* Consulta en Control Description */
  2846.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2847.                 'servicesId' => $itineraries->getId(),
  2848.                 'servicesCat' => $itineraries->getControlCat()
  2849.             ));
  2850.             //$controlctrlDes->getId();
  2851.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2853.             $data_itineraries[] = array(
  2854.                 'id' => $itineraries->getId(),
  2855.                 'title' => $itineraries->getTitle(),
  2856.                 'controlId' => $controlctrlDes->getId(),
  2857.                 'description' => $description
  2858.             );
  2859.         }
  2861.         /* activities */
  2862.         $activitiess = $em->getRepository(SupplierActivities::class)->findBySupplierId($id);
  2863.         /* activities Description*/
  2864.         $data_activities = array();
  2865.         foreach($activitiess as $activities){
  2867.             /* Consulta en Control Description */
  2868.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2869.                 'servicesId' => $activities->getId(),
  2870.                 'servicesCat' => $activities->getControlCat()
  2871.             ));
  2872.             //$controlctrlDes->getId();
  2873.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2875.             $data_activities[] = array(
  2876.                 'id' => $activities->getId(),
  2877.                 'title' => $activities->getTitle(),
  2878.                 'capacity' => $activities->getCapacity(),
  2879.                 'currency' => $activities->getCurrency(),
  2880.                 'price' => $activities->getPrice(),
  2881.                 'commission' => $activities->getCommission(),
  2882.                 'iva' => $activities->getIva(),
  2883.                 'controlId' => $controlctrlDes->getId(),
  2884.                 'description' => $description
  2885.             );
  2886.         }
  2888.         /* cruise */
  2889.         $cruises = $em->getRepository(SupplierCruise::class)->findBySupplierId($id);
  2890.         /* cruise Description*/
  2891.         $data_cruise = array();
  2892.         foreach($cruises as $cruise){
  2894.             /* Consulta en Control Description */
  2895.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2896.                 'servicesId' => $cruise->getId(),
  2897.                 'servicesCat' => $cruise->getControlCat()
  2898.             ));
  2899.             //$controlctrlDes->getId();
  2900.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2902.             $data_cruise[] = array(
  2903.                 'id' => $cruise->getId(),
  2904.                 'title' => $cruise->getTitle(),
  2905.                 'currency' => $cruise->getCurrency(),
  2906.                 'price' => $cruise->getPrice(),
  2907.                 'commission' => $cruise->getCommission(),
  2908.                 'iva' => $cruise->getIva(),
  2909.                 'controlId' => $controlctrlDes->getId(),
  2910.                 'description' => $description
  2911.             );
  2912.         }
  2914.         /* Av */
  2915.         $avs = $em->getRepository(SupplierAv::class)->findBySupplierId($id);
  2916.         /* Av Description*/
  2917.         $data_av = array();
  2918.         foreach($avs as $av){
  2920.             /* Consulta en Control Description */
  2921.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2922.                 'servicesId' => $av->getId(),
  2923.                 'servicesCat' => $av->getControlCat()
  2924.             ));
  2925.             //$controlctrlDes->getId();
  2926.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2928.             $data_av[] = array(
  2929.                 'id' => $av->getId(),
  2930.                 'name' => $av->getName(),
  2931.                 'responsible' => $av->getResponsible(),
  2932.                 'currency' => $av->getCurrency(),
  2933.                 'price' => $av->getPrice(),
  2934.                 'commission' => $av->getCommission(),
  2935.                 'iva' => $av->getIva(),
  2936.                 'controlId' => $controlctrlDes->getId(),
  2937.                 'description' => $description
  2938.             );
  2939.         }
  2941.         /* Creative */
  2942.         $creatives = $em->getRepository(SupplierCreative::class)->findBySupplierId($id);
  2943.         /* Creative Description*/
  2944.         $data_creative = array();
  2945.         foreach($creatives as $creative){
  2947.             /* Consulta en Control Description */
  2948.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2949.                 'servicesId' => $creative->getId(),
  2950.                 'servicesCat' => $creative->getControlCat()
  2951.             ));
  2952.             //$controlctrlDes->getId();
  2953.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2955.             $data_creative[] = array(
  2956.                 'id' => $creative->getId(),
  2957.                 'title' => $creative->getTitle(),
  2958.                 'controlId' => $controlctrlDes->getId(),
  2959.                 'description' => $description
  2960.             );
  2961.         }
  2963.         /* Gifts */
  2964.         $gifts = $em->getRepository(SupplierGifts::class)->findBySupplierId($id);
  2965.         /* Gifts Description*/
  2966.         $data_gifts = array();
  2967.         foreach($gifts as $gift){
  2969.             /* Consulta en Control Description */
  2970.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2971.                 'servicesId' => $gift->getId(),
  2972.                 'servicesCat' => $gift->getControlCat()
  2973.             ));
  2974.             //$controlctrlDes->getId();
  2975.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  2977.             $data_gifts[] = array(
  2978.                 'id' => $gift->getId(),
  2979.                 'name' => $gift->getName(),
  2980.                 'responsible' => $gift->getResponsible(),
  2981.                 'currency' => $gift->getCurrency(),
  2982.                 'price' => $gift->getPrice(),
  2983.                 'commission' => $gift->getCommission(),
  2984.                 'iva' => $gift->getIva(),
  2985.                 'controlId' => $controlctrlDes->getId(),
  2986.                 'description' => $description
  2987.             );
  2988.         }
  2990.         /* Entertainment */
  2991.         $entertainments = $em->getRepository(SupplierEntertainment::class)->findBySupplierId($id);
  2992.         /* Entertainment Description*/
  2993.         $data_entertainment = array();
  2994.         foreach($entertainments as $entertainment){
  2996.             /* Consulta en Control Description */
  2997.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  2998.                 'servicesId' => $entertainment->getId(),
  2999.                 'servicesCat' => $entertainment->getControlCat()
  3000.             ));
  3001.             //$controlctrlDes->getId();
  3002.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3004.             $data_entertainment[] = array(
  3005.                 'id' => $entertainment->getId(),
  3006.                 'name' => $entertainment->getName(),
  3007.                 'responsible' => $entertainment->getResponsible(),
  3008.                 'currency' => $entertainment->getCurrency(),
  3009.                 'price' => $entertainment->getPrice(),
  3010.                 'commission' => $entertainment->getCommission(),
  3011.                 'iva' => $entertainment->getIva(),
  3012.                 'controlId' => $controlctrlDes->getId(),
  3013.                 'description' => $description
  3014.             );
  3015.         }
  3017.         /* Others */
  3018.         $otherss = $em->getRepository(SupplierOthers::class)->findBySupplierId($id);
  3019.         /* Others Description*/
  3020.         $data_others = array();
  3021.         foreach($otherss as $others){
  3023.             /* Consulta en Control Description */
  3024.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3025.                 'servicesId' => $others->getId(),
  3026.                 'servicesCat' => $others->getControlCat()
  3027.             ));
  3028.             //$controlctrlDes->getId();
  3029.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3031.             $data_others[] = array(
  3032.                 'id' => $others->getId(),
  3033.                 'name' => $others->getName(),
  3034.                 'responsible' => $others->getResponsible(),
  3035.                 'currency' => $others->getCurrency(),
  3036.                 'price' => $others->getPrice(),
  3037.                 'commission' => $others->getCommission(),
  3038.                 'iva' => $others->getIva(),
  3039.                 'controlId' => $controlctrlDes->getId(),
  3040.                 'description' => $description
  3041.             );
  3042.         }
  3044.         /* technology */
  3046.         if ($idsupplier == 2){          // Es una tecnologia de Develup
  3047.             $technologys = $em->getRepository(MdvProduct::class)->findAll();
  3049.             $data_technology = array();
  3050.             foreach($technologys as $technology){
  3052.                 $data_technology[] = array(
  3053.                     'id' => $technology->getId(),
  3054.                     'title' => $technology->getName(),
  3055.                     'modules' => null,
  3056.                     'type' => $technology->getType(),
  3057.                     'currency' => 'Euro',
  3058.                     'price' => $technology->getPrice(),
  3059.                     'commission' => $technology->getCommission(),
  3060.                     'iva' => $technology->getIva(),
  3061.                     'controlId' => null,
  3062.                     'description' => $technology->getDescription(),
  3063.                     'supplier' => 'Develup',
  3064.                 );
  3065.             }
  3067.         } else {
  3069.             $technologys = $em->getRepository(SupplierTechnology::class)->findBySupplierId($id);
  3070.             /* technology Description*/
  3071.             $data_technology = array();
  3072.             foreach($technologys as $technology){
  3074.                 /* Consulta en Control Description */
  3075.                 $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3076.                     'servicesId' => $technology->getId(),
  3077.                     'servicesCat' => $technology->getControlCat()
  3078.                 ));
  3079.                 //$controlctrlDes->getId();
  3080.                 $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3082.                 $data_technology[] = array(
  3083.                     'id' => $technology->getId(),
  3084.                     'title' => $technology->getTitle(),
  3085.                     'modules' => $technology->getModules(),
  3086.                     'type' => $technology->getType(),
  3087.                     'currency' => $technology->getCurrency(),
  3088.                     'price' => $technology->getPrice(),
  3089.                     'commission' => $technology->getCommission(),
  3090.                     'iva' => $technology->getIva(),
  3091.                     'controlId' => $controlctrlDes->getId(),
  3092.                     'description' => $description
  3093.                 );
  3094.             }
  3095.             /////////////////////////////////////////////////////////////////////
  3096.             $technologys = $em->getRepository(SupplierTechnology::class)->findBySupplierId($id);
  3098.             /* technology Description*/
  3099.             $data_technology = array();
  3100.             foreach($technologys as $technology){
  3102.                 /* Consulta en Control Description */
  3103.                 $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3104.                     'servicesId' => $technology->getId(),
  3105.                     'servicesCat' => $technology->getControlCat()
  3106.                 ));
  3107.                 //$controlctrlDes->getId();
  3108.                 $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3110.                 $data_technology[] = array(
  3111.                     'id' => $technology->getId(),
  3112.                     'title' => $technology->getTitle(),
  3113.                     'modules' => $technology->getModules(),
  3114.                     'type' => $technology->getType(),
  3115.                     'currency' => $technology->getCurrency(),
  3116.                     'price' => $technology->getPrice(),
  3117.                     'commission' => $technology->getCommission(),
  3118.                     'iva' => $technology->getIva(),
  3119.                     'controlId' => $controlctrlDes->getId(),
  3120.                     'description' => $description
  3121.                 );
  3122.             }
  3123.         }
  3126.         /* Assistant  */
  3127.         $assistants = $em->getRepository(SupplierServicesAssistant::class)->findBySupplierId($id);
  3128.         /* Assistant  Description*/
  3129.         $data_assistant = array();
  3130.         foreach($assistants as $assistant){
  3132.             /* Consulta en Control Description */
  3133.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3134.                 'servicesId' => $assistant->getId(),
  3135.                 'servicesCat' => $assistant->getControlCat()
  3136.             ));
  3137.             //$controlctrlDes->getId();
  3138.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3140.             $data_assistant[] = array(
  3141.                 'id' => $assistant->getId(),
  3142.                 'name' => $assistant->getName(),
  3143.                 'quantity' => $assistant->getQuantity(),
  3144.                 'currency' => $assistant->getCurrency(),
  3145.                 'price' => $assistant->getPrice(),
  3146.                 'commission' => $assistant->getCommission(),
  3147.                 'iva' => $assistant->getIva(),
  3148.                 'controlId' => $controlctrlDes->getId(),
  3149.                 'description' => $description
  3150.             );
  3151.         }
  3155.         /* salida de data */
  3156.         return $this->render('MDS/EventsBundle/services/services-modal-proposal.html.twig', array(
  3157.             'idcontrol' => $idcontrol,
  3158.             'accommodations' => $data_accommodation,
  3159.             'menus' => $data_menu,
  3160.             'lounges' => $data_lounge,
  3161.             'transports' => $data_transport,
  3162.             'guides' => $data_guide,
  3163.             'itineraries' => $data_itineraries,
  3164.             'activities' => $data_activities,
  3165.             'cruises' => $data_cruise,
  3166.             'avs' => $data_av,
  3167.             'creatives' => $data_creative,
  3168.             'gifts' => $data_gifts,
  3169.             'entertainments' => $data_entertainment,
  3170.             'technology' => $data_technology,
  3171.             'assistants' => $data_assistant,
  3172.             'otherss' => $data_others
  3173.         ));
  3174.     }
  3176.     /**
  3177.      * @Route("proposal/destination/servicesesp/list/{idcontrol}", name="proposal_destination_supplier_especial_list")
  3178.      */
  3179.     public function listEspecialSupplierAction($idcontrol, Request $request) {
  3181.         $em = $this->getDoctrine()->getManager();
  3182.         $control = $em->getRepository(ProposalSupplierControl::class)->findOneById($idcontrol);
  3183.         $idsupplier = $control->getSupplierId();
  3184.         $cdid = $control->getControlDestinationId();
  3185.         $ididea = $control->getIdeaId();
  3186.         $idactivity = $control->getActivityId();
  3188.         $proposal = $em->getRepository(Proposal::class)->findOneById($control->getProposalId());
  3190.         if($idsupplier == '0'){
  3191.             $id = '0';
  3192.         }else{
  3193.             if(!is_null($idsupplier)){
  3194.                 /*CONTROL GENERAL*/
  3195.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneBySupplierId($idsupplier);
  3196.                 $id = $controlgeneral->getId();
  3197.             }
  3198.             if(!is_null($idactivity)){
  3199.                 /*CONTROL GENERAL*/
  3200.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByActivityId($idactivity);
  3201.                 $id = $controlgeneral->getId();
  3202.             }
  3203.             if(!is_null($ididea)){
  3204.                 /*CONTROL GENERAL*/
  3205.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByIdeaId($ididea);
  3206.                 $id = $controlgeneral->getId();
  3207.             }
  3208.         }
  3210.         /* accommodations */
  3211.         $accommodations = $em->getRepository(SupplierAccommodation::class)->findBySupplierId($id);
  3212.         $data_accommodation = array();
  3213.         foreach ($accommodations as $accommodation) {
  3215.             /* Consulta en Control Services */
  3216.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3217.                 'servicesId' => $accommodation->getId(),
  3218.                 'servicesCat' => $accommodation->getControlCat()
  3219.             ));
  3221.             //class="label label-flat label-rounded label-icon border-grey text-grey"
  3222.             if ($accommodation->getMinibar()){
  3223.                 $accommodation->setMinibar('<span class="label quitar-margin-15"><img src="/assets/images/icons/mi-20.png"></span>');
  3224.             }
  3225.             if ($accommodation->getWifi()){
  3226.                 $accommodation->setWifi('<span class="label quitar-margin-15"><img src="/assets/images/icons/wi-20.png"></span>');
  3227.             }
  3228.             if ($accommodation->getAirconditioner()){
  3229.                 $accommodation->setAirconditioner('<span class="label quitar-margin-15"><img src="/assets/images/icons/ac-20.png"></span>');
  3230.             }
  3231.             if ($accommodation->getCalefaction()){
  3232.                 $accommodation->setCalefaction('<span class="label quitar-margin-15"><img src="/assets/images/icons/ca-20.png"></span>');
  3233.             }
  3234.             if ($accommodation->getPool()){
  3235.                 $accommodation->setPool('<span class="label quitar-margin-15"><img src="/assets/images/icons/po-20.png"></span>');
  3236.             }
  3237.             if ($accommodation->getBath()){
  3238.                 $accommodation->setBath('<span class="label quitar-margin-15"><img src="/assets/images/icons/ba-20.png"></span>');
  3239.             }
  3240.             if ($accommodation->getCoffeemaker()){
  3241.                 $accommodation->setCoffeemaker('<span class="label quitar-margin-15"><img src="/assets/images/icons/cm-20.png"></span>');
  3242.             }
  3243.             if ($accommodation->getKitchen()){
  3244.                 $accommodation->setKitchen('<span class="label quitar-margin-15"><img src="/assets/images/icons/ki-20.png"></span>');
  3245.             }
  3246.             if ($accommodation->getWasher()){
  3247.                 $accommodation->setWasher('<span class="label quitar-margin-15"><img src="/assets/images/icons/wa-20.png"></span>');
  3248.             }
  3249.             if ($accommodation->getFlattv()){
  3250.                 $accommodation->setFlattv('<span class="label quitar-margin-15"><img src="/assets/images/icons/tv-20.png"></span>');
  3251.             }
  3252.             if ($accommodation->getElectrickettle()){
  3253.                 $accommodation->setElectrickettle('<span class="label quitar-margin-15"><img src="/assets/images/icons/ke-20.png"></span>');
  3254.             }
  3255.             if ($accommodation->getViews()){
  3256.                 $accommodation->setViews('<span class="label quitar-margin-15"><img src="/assets/images/icons/vi-20.png"></span>');
  3257.             }
  3258.             if ($accommodation->getPets()){
  3259.                 $accommodation->setPets('<span class="label quitar-margin-15"><img src="/assets/images/icons/pe-20.png"></span>');
  3260.             }
  3262. //                $data_accommodation[]=$accommodation;
  3263.             $data_accommodation[] = array(
  3264.                 'id' => $accommodation->getId(),
  3265.                 'name' => $accommodation->getName(),
  3266.                 'size' => $accommodation->getSize(),
  3267.                 'quantity' => $accommodation->getQuantity(),
  3268.                 'price' => $accommodation->getPrice(),
  3269.                 'controlId' => $controlctrlDes->getId(),
  3271.                 'minibar' => $accommodation->getMinibar(),
  3272.                 'wifi' => $accommodation->getWifi(),
  3273.                 'airconditioner' => $accommodation->getAirconditioner(),
  3274.                 'calefaction' => $accommodation->getCalefaction(),
  3275.                 'pool' => $accommodation->getPool(),
  3276.                 'bath' => $accommodation->getBath(),
  3277.                 'coffeemaker' => $accommodation->getCoffeemaker(),
  3278.                 'kitchen' => $accommodation->getKitchen(),
  3279.                 'washer' => $accommodation->getWasher(),
  3280.                 'flattv' => $accommodation->getFlattv(),
  3281.                 'electrickettle' => $accommodation->getElectrickettle(),
  3282.                 'views' => $accommodation->getViews(),
  3283.                 'pets' => $accommodation->getPets()
  3284.             );
  3285.         }
  3286.         /* accommodations */
  3288.         /* menu */
  3289.         $menus = $em->getRepository(SupplierMenu::class)->findBySupplierId($id);
  3290.         /* menu Description*/
  3291.         $data_menu = array();
  3292.         foreach($menus as $menu){
  3294.             /* Consulta en Control Description */
  3295.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3296.                 'servicesId' => $menu->getId(),
  3297.                 'servicesCat' => $menu->getControlCat()
  3298.             ));
  3299. //            $controlctrlDes->getId();
  3300. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3302.             $data_menu[] = array(
  3303.                 'id' => $menu->getId(),
  3304.                 'title' => $menu->getTitle(),
  3305.                 'description' => $menu->getDescription(),
  3306.                 'currency' => $menu->getCurrency(),
  3307.                 'price' => $menu->getPrice(),
  3308.                 'commission' => $menu->getCommission(),
  3309.                 'iva' => $menu->getIva(),
  3310.                 'controlId' => $controlctrlDes->getId()
  3311.             );
  3312.         }
  3314.         /* lounge */
  3315.         $lounges = $em->getRepository(SupplierLounge::class)->findBySupplierId($id);
  3316.         /* lounge Description*/
  3317.         $data_lounge = array();
  3318.         foreach($lounges as $lounge){
  3320.             /* Consulta en Control Description */
  3321.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3322.                 'servicesId' => $lounge->getId(),
  3323.                 'servicesCat' => $lounge->getControlCat()
  3324.             ));
  3325. //            $controlctrlDes->getId();
  3326. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3328.             $data_lounge[] = array(
  3329.                 'id' => $lounge->getId(),
  3330.                 'name' => $lounge->getName(),
  3331.                 'currency' => $lounge->getCurrency(),
  3332.                 'price' => $lounge->getPrice(),
  3333.                 'commission' => $lounge->getCommission(),
  3334.                 'iva' => $lounge->getIva(),
  3335.                 'controlId' => $controlctrlDes->getId()
  3336.             );
  3337.         }
  3339.         /* Transport */
  3340.         $transports = $em->getRepository(SupplierTransport::class)->findBySupplierId($id);
  3341.         /* Transport Description*/
  3342.         $data_transport = array();
  3343.         foreach($transports as $transport){
  3345.             /* Consulta en Control Description */
  3346.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3347.                 'servicesId' => $transport->getId(),
  3348.                 'servicesCat' => $transport->getControlCat()
  3349.             ));
  3350. //            $controlctrlDes->getId();
  3351. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3353.             $data_transport[] = array(
  3354.                 'id' => $transport->getId(),
  3355.                 'name' => $transport->getName(),
  3356.                 'driver' => $transport->getDriver(),
  3357.                 'currency' => $transport->getCurrency(),
  3358.                 'price' => $transport->getPrice(),
  3359.                 'commission' => $transport->getCommission(),
  3360.                 'iva' => $transport->getIva(),
  3361.                 'controlId' => $controlctrlDes->getId()
  3362.             );
  3363.         }
  3365.         /* Guide */
  3366.         $guides = $em->getRepository(SupplierGuide::class)->findBySupplierId($id);
  3367.         /* Guide Description*/
  3368.         $data_guide = array();
  3369.         foreach($guides as $guide){
  3371.             /* Consulta en Control Description */
  3372.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3373.                 'servicesId' => $guide->getId(),
  3374.                 'servicesCat' => $guide->getControlCat()
  3375.             ));
  3376. //            $controlctrlDes->getId();
  3377. //            $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3379.             $data_guide[] = array(
  3380.                 'id' => $guide->getId(),
  3381.                 'name' => $guide->getName(),
  3382.                 'guide' => $guide->getGuide(),
  3383.                 'currency' => $guide->getCurrency(),
  3384.                 'price' => $guide->getPrice(),
  3385.                 'commission' => $guide->getCommission(),
  3386.                 'iva' => $guide->getIva(),
  3387.                 'controlId' => $controlctrlDes->getId()
  3388.             );
  3389.         }
  3391.         /* Itineraries */
  3392.         $itinerariess = $em->getRepository(SupplierItineraries::class)->findBySupplierId($id);
  3393.         /* Itineraries Description*/
  3394.         $data_itineraries = array();
  3395.         foreach($itinerariess as $itineraries){
  3397.             /* Consulta en Control Description */
  3398.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3399.                 'servicesId' => $itineraries->getId(),
  3400.                 'servicesCat' => $itineraries->getControlCat()
  3401.             ));
  3402.             //$controlctrlDes->getId();
  3403.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3405.             $data_itineraries[] = array(
  3406.                 'id' => $itineraries->getId(),
  3407.                 'title' => $itineraries->getTitle(),
  3408.                 'controlId' => $controlctrlDes->getId(),
  3409.                 'description' => $description
  3410.             );
  3411.         }
  3413.         /* activities */
  3414.         $activitiess = $em->getRepository(SupplierActivities::class)->findBySupplierId($id);
  3415.         /* activities Description*/
  3416.         $data_activities = array();
  3417.         foreach($activitiess as $activities){
  3419.             /* Consulta en Control Description */
  3420.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3421.                 'servicesId' => $activities->getId(),
  3422.                 'servicesCat' => $activities->getControlCat()
  3423.             ));
  3424.             //$controlctrlDes->getId();
  3425.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3427.             $data_activities[] = array(
  3428.                 'id' => $activities->getId(),
  3429.                 'title' => $activities->getTitle(),
  3430.                 'capacity' => $activities->getCapacity(),
  3431.                 'currency' => $activities->getCurrency(),
  3432.                 'price' => $activities->getPrice(),
  3433.                 'commission' => $activities->getCommission(),
  3434.                 'iva' => $activities->getIva(),
  3435.                 'controlId' => $controlctrlDes->getId(),
  3436.                 'description' => $description
  3437.             );
  3438.         }
  3440.         /* cruise */
  3441.         $cruises = $em->getRepository(SupplierCruise::class)->findBySupplierId($id);
  3442.         /* cruise Description*/
  3443.         $data_cruise = array();
  3444.         foreach($cruises as $cruise){
  3446.             /* Consulta en Control Description */
  3447.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3448.                 'servicesId' => $cruise->getId(),
  3449.                 'servicesCat' => $cruise->getControlCat()
  3450.             ));
  3451.             //$controlctrlDes->getId();
  3452.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3454.             $data_cruise[] = array(
  3455.                 'id' => $cruise->getId(),
  3456.                 'title' => $cruise->getTitle(),
  3457.                 'currency' => $cruise->getCurrency(),
  3458.                 'price' => $cruise->getPrice(),
  3459.                 'commission' => $cruise->getCommission(),
  3460.                 'iva' => $cruise->getIva(),
  3461.                 'controlId' => $controlctrlDes->getId(),
  3462.                 'description' => $description
  3463.             );
  3464.         }
  3466.         /* Av */
  3467.         if ($idsupplier == 80){
  3468.             // El proveedor del AV es AvExpress
  3470.             // Listamos por orden alfabetico y se deja de primero a "Otro servicio"
  3471.             $parameters = array();
  3472.             $dql = 'SELECT i
  3473.                         FROM AvexpressBundle:AveProduct i
  3474.                         ORDER BY i.name ASC';
  3475.             $query = $em->createQuery($dql)->setParameters($parameters);
  3476.             $avs = $query->getResult();
  3477.             $newAvs = array();
  3479.             foreach ($avs as $key => $item) {
  3480.                 if ($item->getName() == 'Otro servicio'){
  3481.                     $item->setName('0 - Otro servicio');
  3482.                     $newAvs = array($item);
  3483.                     unset($avs[$key]);
  3484.                     foreach ($avs as $keyTwo => $elem){
  3485.                         $ind = $keyTwo + 1;
  3486.                         $elem->setName($ind.' - '.$elem->getName());
  3487.                         array_push($newAvs,$elem);
  3488.                     }
  3489.                 }
  3490.             }
  3492.             $avs = $newAvs;
  3494.             /* av Description*/
  3495.             $data_av = array();
  3496.             foreach($avs as $av){
  3498.                 $data_av[] = array(
  3499.                     'id' => $av->getId(),
  3500.                     'name' => $av->getName(),
  3501. //                    'modules' => $technology->getModules(),
  3502.                     'modules' => null,
  3503.                     'type' => $av->getType(),
  3504.                     'currency' => 'Euro',
  3505.                     'price' => $av->getPrice(),
  3506.                     'commission' => 0,
  3507.                     'iva' => 21,
  3508.                     'controlId' => null,
  3509.                     'description' => $av->getDescription(),
  3510.                     'supplier' => 'AvExpress',
  3511.                 );
  3512.             }
  3514.             //   ***************************************** METEMOS AV TEMPLATES (Tipo: AVExpress Template)
  3515.             $parameters = array();
  3516.             $dql = 'SELECT i
  3517.                         FROM AvexpressBundle:AveTemplate i
  3518.                         ORDER BY i.name ASC';
  3519.             $query = $em->createQuery($dql)->setParameters($parameters);
  3520.             $avsTemplate = $query->getResult();
  3522.             foreach($avsTemplate as $av){
  3524.                 $data_av[] = array(
  3525.                     'id' => $av->getId(),
  3526.                     'name' => $av->getName(),
  3527.                     'modules' => null,
  3528.                     'type' => 'AVExpress Template',
  3529.                     'currency' => null,
  3530.                     'price' => null,
  3531.                     'commission' => null,
  3532.                     'iva' => null,
  3533.                     'controlId' => null,
  3534.                     'description' => null,
  3535.                     'supplier' => 'AvExpress',
  3536.                 );
  3537.             }
  3539.         } else {
  3540.             $newAvs = array();
  3541.             $avs = $em->getRepository(SupplierAv::class)->findBySupplierId($id);
  3542.             /* Av Description*/
  3543.             $data_av = array();
  3544.             foreach($avs as $av){
  3546.                 /* Consulta en Control Description */
  3547.                 $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3548.                     'servicesId' => $av->getId(),
  3549.                     'servicesCat' => $av->getControlCat()
  3550.                 ));
  3551.                 //$controlctrlDes->getId();
  3552.                 $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3554.                 $data_av[] = array(
  3555.                     'id' => $av->getId(),
  3556.                     'name' => $av->getName(),
  3557.                     'responsible' => $av->getResponsible(),
  3558.                     'currency' => $av->getCurrency(),
  3559.                     'price' => $av->getPrice(),
  3560.                     'commission' => $av->getCommission(),
  3561.                     'iva' => $av->getIva(),
  3562.                     'controlId' => $controlctrlDes->getId(),
  3563.                     'description' => $description
  3564.                 );
  3565.             }
  3566.         }
  3569.         /* Creative */
  3570.         $creatives = $em->getRepository(SupplierCreative::class)->findBySupplierId($id);
  3571.         /* Creative Description*/
  3572.         $data_creative = array();
  3573.         foreach($creatives as $creative){
  3575.             /* Consulta en Control Description */
  3576.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3577.                 'servicesId' => $creative->getId(),
  3578.                 'servicesCat' => $creative->getControlCat()
  3579.             ));
  3580.             //$controlctrlDes->getId();
  3581.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3583.             $data_creative[] = array(
  3584.                 'id' => $creative->getId(),
  3585.                 'title' => $creative->getTitle(),
  3586.                 'controlId' => $controlctrlDes->getId(),
  3587.                 'description' => $description
  3588.             );
  3589.         }
  3591.         /* Gifts */
  3592.         $gifts = $em->getRepository(SupplierGifts::class)->findBySupplierId($id);
  3593.         /* Gifts Description*/
  3594.         $data_gifts = array();
  3595.         foreach($gifts as $gift){
  3597.             /* Consulta en Control Description */
  3598.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3599.                 'servicesId' => $gift->getId(),
  3600.                 'servicesCat' => $gift->getControlCat()
  3601.             ));
  3602.             //$controlctrlDes->getId();
  3603.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3605.             $data_gifts[] = array(
  3606.                 'id' => $gift->getId(),
  3607.                 'name' => $gift->getName(),
  3608.                 'responsible' => $gift->getResponsible(),
  3609.                 'currency' => $gift->getCurrency(),
  3610.                 'price' => $gift->getPrice(),
  3611.                 'commission' => $gift->getCommission(),
  3612.                 'iva' => $gift->getIva(),
  3613.                 'controlId' => $controlctrlDes->getId(),
  3614.                 'description' => $description
  3615.             );
  3616.         }
  3618.         /* Entertainment */
  3619.         $entertainments = $em->getRepository(SupplierEntertainment::class)->findBySupplierId($id);
  3620.         /* Entertainment Description*/
  3621.         $data_entertainment = array();
  3622.         foreach($entertainments as $entertainment){
  3624.             /* Consulta en Control Description */
  3625.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3626.                 'servicesId' => $entertainment->getId(),
  3627.                 'servicesCat' => $entertainment->getControlCat()
  3628.             ));
  3629.             //$controlctrlDes->getId();
  3630.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3632.             $data_entertainment[] = array(
  3633.                 'id' => $entertainment->getId(),
  3634.                 'name' => $entertainment->getName(),
  3635.                 'responsible' => $entertainment->getResponsible(),
  3636.                 'currency' => $entertainment->getCurrency(),
  3637.                 'price' => $entertainment->getPrice(),
  3638.                 'commission' => $entertainment->getCommission(),
  3639.                 'iva' => $entertainment->getIva(),
  3640.                 'controlId' => $controlctrlDes->getId(),
  3641.                 'description' => $description
  3642.             );
  3643.         }
  3645.         /* Others */
  3646.         $otherss = $em->getRepository(SupplierOthers::class)->findBySupplierId($id);
  3647.         /* Others Description*/
  3648.         $data_others = array();
  3649.         foreach($otherss as $others){
  3651.             /* Consulta en Control Description */
  3652.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3653.                 'servicesId' => $others->getId(),
  3654.                 'servicesCat' => $others->getControlCat()
  3655.             ));
  3656.             //$controlctrlDes->getId();
  3657.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3659.             $data_others[] = array(
  3660.                 'id' => $others->getId(),
  3661.                 'name' => $others->getName(),
  3662.                 'responsible' => $others->getResponsible(),
  3663.                 'currency' => $others->getCurrency(),
  3664.                 'price' => $others->getPrice(),
  3665.                 'commission' => $others->getCommission(),
  3666.                 'iva' => $others->getIva(),
  3667.                 'controlId' => $controlctrlDes->getId(),
  3668.                 'description' => $description
  3669.             );
  3670.         }
  3672.         /* technology */
  3673.         if ($idsupplier == 2){          // Es una tecnologia de Develup
  3674. //            $technologys = $em->getRepository(MdvProduct::class)->findAll();
  3676.             // Listamos por orden alfabetico y se deja de primero a "Otro servicio"
  3677.             $parameters = array();
  3678.             $dql = 'SELECT i
  3679.                         FROM DevelupBundle:MdvProduct i
  3680.                         ORDER BY i.name ASC';
  3681.             $query = $em->createQuery($dql)->setParameters($parameters);
  3682.             $technologys = $query->getResult();
  3683.             $newTechnologys = array();
  3685.             foreach ($technologys as $key => $item) {
  3686.                 if ($item->getName() == 'Otro servicio'){
  3687.                     $item->setName('0 - Otro servicio');
  3688.                     $newTechnologys = array($item);
  3689.                     unset($technologys[$key]);
  3690.                     foreach ($technologys as $keyTwo => $elem){
  3691.                         $ind = $keyTwo + 1;
  3692.                         $elem->setName($ind.' - '.$elem->getName());
  3693.                         array_push($newTechnologys,$elem);
  3694.                     }
  3695.                 }
  3696.             }
  3698.             $technologys = $newTechnologys;
  3700.             /* technology Description*/
  3701.             $data_technology = array();
  3702.             foreach($technologys as $technology){
  3704.                 $data_technology[] = array(
  3705.                     'id' => $technology->getId(),
  3706.                     'title' => $technology->getName(),
  3707. //                    'modules' => $technology->getModules(),
  3708.                     'modules' => null,
  3709.                     'type' => $technology->getType(),
  3710.                     'currency' => 'Euro',
  3711.                     'price' => $technology->getPrice(),
  3712.                     'commission' => 0,
  3713.                     'iva' => 21,
  3714.                     'controlId' => null,
  3715.                     'description' => $technology->getDescription(),
  3716.                     'supplier' => 'Develup',
  3717.                 );
  3718.             }
  3720.         } else {
  3721.             $technologys = $em->getRepository(SupplierTechnology::class)->findBySupplierId($id);
  3722.             $newTechnologys = array();
  3724.             /* technology Description*/
  3725.             $data_technology = array();
  3726.             foreach($technologys as $technology){
  3728.                 /* Consulta en Control Description */
  3729.                 $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3730.                     'servicesId' => $technology->getId(),
  3731.                     'servicesCat' => $technology->getControlCat()
  3732.                 ));
  3733.                 //$controlctrlDes->getId();
  3734.                 $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3736.                 $data_technology[] = array(
  3737.                     'id' => $technology->getId(),
  3738.                     'title' => $technology->getTitle(),
  3739.                     'modules' => $technology->getModules(),
  3740.                     'type' => $technology->getType(),
  3741.                     'currency' => $technology->getCurrency(),
  3742.                     'price' => $technology->getPrice(),
  3743.                     'commission' => $technology->getCommission(),
  3744.                     'iva' => $technology->getIva(),
  3745.                     'controlId' => $controlctrlDes->getId(),
  3746.                     'description' => $description
  3747.                 );
  3748.             }
  3749.         }
  3754.         /* Assistant  */
  3755.         $assistants = $em->getRepository(SupplierServicesAssistant::class)->findBySupplierId($id);
  3756.         /* Assistant  Description*/
  3757.         $data_assistant = array();
  3758.         foreach($assistants as $assistant){
  3760.             /* Consulta en Control Description */
  3761.             $controlctrlDes = $em->getRepository(SupplierServicesControl::class)->findOneBy( array(
  3762.                 'servicesId' => $assistant->getId(),
  3763.                 'servicesCat' => $assistant->getControlCat()
  3764.             ));
  3765.             //$controlctrlDes->getId();
  3766.             $description = $em->getRepository(SupplierServicesDescription::class)->findByControlId($controlctrlDes->getId());
  3768.             $data_assistant[] = array(
  3769.                 'id' => $assistant->getId(),
  3770.                 'name' => $assistant->getName(),
  3771.                 'quantity' => $assistant->getQuantity(),
  3772.                 'currency' => $assistant->getCurrency(),
  3773.                 'price' => $assistant->getPrice(),
  3774.                 'commission' => $assistant->getCommission(),
  3775.                 'iva' => $assistant->getIva(),
  3776.                 'controlId' => $controlctrlDes->getId(),
  3777.                 'description' => $description
  3778.             );
  3779.         }
  3783.         /* salida de data */
  3784.         return $this->render('MDS/EventsBundle/services/services-supplier-esp-proposal.html.twig', array(
  3785.             'cdid' => $cdid,
  3786.             'id' => $proposal->getId(),
  3787.             'proname' => $proposal->getName(),
  3788.             'token' => $proposal->getAccessKey(),
  3789.             'mcp' => $proposal->getMcp(),
  3790.             'proposal' => $proposal,
  3791.             'idcontrol' => $idcontrol,
  3792.             'accommodations' => $data_accommodation,
  3793.             'menus' => $data_menu,
  3794.             'lounges' => $data_lounge,
  3795.             'transports' => $data_transport,
  3796.             'guides' => $data_guide,
  3797.             'itineraries' => $data_itineraries,
  3798.             'activities' => $data_activities,
  3799.             'cruises' => $data_cruise,
  3800.             'avs' => $data_av,
  3801.             'creatives' => $data_creative,
  3802.             'gifts' => $data_gifts,
  3803.             'entertainments' => $data_entertainment,
  3804.             'technology' => $data_technology,
  3805.             'newTechnologys' => $newTechnologys,
  3806.             'newAvs' => $newAvs,
  3807.             'assistants' => $data_assistant,
  3808.             'otherss' => $data_others
  3809.         ));
  3810.     }
  3813.     /* CREAR DESDE Discount */
  3814.     private function createDiscountCreateForm(ProposalDiscount $entity)
  3815.     {
  3816.         $form = $this->createForm(ProposalDiscountType::class, $entity, array(
  3817.             'action' => $this->generateUrl('proposal_discount_create'),
  3818.             'method' => 'POST'
  3819.         ));
  3820.         return $form;
  3821.     }
  3823.     /**
  3824.      * @Route("/proposal/discount/create",  name="proposal_discount_create")
  3825.      */
  3826.     public function createDiscountAction(Request $request)
  3827.     {
  3829.         $controlid = $request->request->get('control')['id'];
  3831.         $em = $this->getDoctrine()->getManager();
  3832.         $discount = new ProposalDiscount();
  3833.         $form = $this->createDiscountCreateForm($discount);
  3834.         $form->handleRequest($request);
  3836.         $serviceId = $form->get('serviceId')->getData();
  3837.         if(!is_null($serviceId)){
  3838.             $discount->setServiceId($serviceId->getId());
  3839.         }else{
  3840.             $discount->setServiceId(null);
  3841.         }
  3843.         if($form->isValid())
  3844.         {
  3845.             /* Obtengo usuario logueado */
  3846.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  3847.             $user_id = $user_logueado->getId();
  3849.             $discount->setCreatedId($user_id);
  3850.             $discount->setUpdatedId($user_id);
  3852.             $em->persist($discount);
  3853.             $em->flush();
  3854.         }
  3855.         return $this->redirectToRoute('proposal_destination_supplier_view',
  3856.             array(
  3857.                 'id' => $controlid,
  3858.                 '_fragment' => 'd1'
  3859.             )
  3860.         );
  3861.     }
  3863.     /**
  3864.      * @Route("/proposal/discount/delete/{controlid}/{id}",  name="proposal_discount_delete")
  3865.      */
  3866.     public function deleteDiscountAction($controlid, $id, Request $request)
  3867.     {
  3868.         $em = $this->getDoctrine()->getManager();
  3869.         $delete= $em->getRepository(ProposalDiscount::class)->findOneById($id);
  3871.         $em->remove($delete);
  3872.         $em->flush();
  3874.         return $this->redirectToRoute('proposal_destination_supplier_view',
  3875.             array(
  3876.                 'id' => $controlid
  3877.             )
  3878.         );
  3880.     }
  3882.     /**
  3883.      * @Route("/proposal/fee/create",  name="proposal_fee_create")
  3884.      */
  3885.     public function createFeeAction(Request $request){
  3886.         $controlid = $request->request->get('control')['id'];
  3888.         /* Obtengo usuario logueado */
  3889.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  3890.         $user_id = $user_logueado->getId();
  3892.         $em = $this->getDoctrine()->getManager();
  3893.         $proposalId = $request->request->get('proposal_id');
  3894.         $proposal = $em->getRepository(Proposal::class)->findOneById($proposalId);
  3895.         $oldFee = $em->getRepository(ProposalFee::class)->findOneByProposalId($proposalId);
  3897.         if (!empty($oldFee)){
  3898.             if ($oldFee->getToInvoice() == 0){
  3899.                 // Habia un Fee que se cargo en los servicios
  3900.                 $this->eliminarFeeOculto($oldFee->getId());
  3901.             }
  3903.             $oldFee->setName($request->request->get('nameFee'));
  3904.             $oldFee->setType($request->request->get('typeFee'));
  3905.             $oldFee->setAmount($request->request->get('amountFee'));
  3906.             $oldFee->setToInvoice($request->request->get('toInvoiceFee'));
  3907.             $oldFee->setUpdatedId($user_id);
  3908.             $oldFee->setUpdatedAt(new \DateTime("now"));
  3910.             if ($proposal->getStatus() != 'Invoiced') {
  3911.                 $em->persist($oldFee);
  3912.                 $em->flush();
  3914.                 if(!$oldFee->getToInvoice()){
  3915.                     // Es un Fee oculto se deben modificar los servicios
  3916.                     $this->agregarFeeOculto($oldFee->getId());
  3917.                 }
  3918.             }
  3920.         } else {
  3921.             $newFee = new ProposalFee();
  3922.             $newFee->setProposalId($proposalId);
  3923.             $newFee->setName($request->request->get('nameFee'));
  3924.             $newFee->setType($request->request->get('typeFee'));
  3925.             $newFee->setAmount($request->request->get('amountFee'));
  3926.             $newFee->setToInvoice($request->request->get('toInvoiceFee'));
  3927.             $newFee->setOpIva('1');
  3928.             $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
  3929.             if ($request->request->get('typeFee') == 0){ $newFee->setFeeTotal(0); } else { $newFee->setFeeTotal($request->request->get('amountFee') * 1.21); }
  3930.             $newFee->setCreatedId($user_id);
  3931.             $newFee->setUpdatedId($user_id);
  3932.             $newFee->setCreatedAt(new \DateTime("now"));
  3933.             $newFee->setUpdatedAt(new \DateTime("now"));
  3935.             // Solo se creará el Fee si no se ha facturado
  3936.             if ($proposal->getStatus() != 'Invoiced') {
  3937.                 $em->persist($newFee);
  3938.                 $em->flush();
  3940.                 if(!$newFee->getToInvoice()){
  3941.                     // Es un Fee oculto se deben modificar los servicios
  3942.                     $this->agregarFeeOculto($newFee->getId());
  3943.                 }
  3944.             }
  3945.         }
  3947.         return $this->redirectToRoute('proposal_destination_supplier_view',
  3948.             array(
  3949.                 'id' => $controlid,
  3950.                 '_fragment' => 'f1'
  3951.             )
  3952.         );
  3953.     }
  3956.     /**
  3957.      * @Route("/proposal/fee/delete/{controlid}/{id}",  name="proposal_fee_delete")
  3958.      */
  3959.     public function deleteFeeAction($controlid, $id, Request $request)
  3960.     {
  3961.         $em = $this->getDoctrine()->getManager();
  3962.         $fee = $em->getRepository(ProposalFee::class)->findOneById($id);
  3964.         if (!empty($fee)){
  3965.             $proposal = $em->getRepository(Proposal::class)->findOneById($fee->getProposalId());
  3967.             if ($fee->getToInvoice() == 0){
  3968.                 // Habia un Fee que se cargo en los servicios
  3969.                 $this->eliminarFeeOculto($fee->getId());
  3970.             }
  3972.             if ($proposal->getStatus() != 'Invoiced') {
  3973.                 $em->remove($fee);
  3974.                 $em->flush();
  3975.             }
  3976.         }
  3978.         return $this->redirectToRoute('proposal_destination_supplier_view',
  3979.             array(
  3980.                 'id' => $controlid,
  3981.                 '_fragment' => 'f1'
  3982.             )
  3983.         );
  3984.     }
  3987.     private function agregarFeeOculto( $idFee )
  3988.     {
  3989.         // Se agregara un fee en los servicios
  3990.         $em = $this->getDoctrine()->getManager();
  3991.         $fee = $em->getRepository(ProposalFee::class)->findOneById($idFee);
  3992.         $prpSupServices = $em->getRepository(ProposalSupplierServices::class)->findByProposalId($fee->getProposalId());
  3994.         foreach ($prpSupServices as $service){
  3996.             if ($fee->getType() == 0){
  3997.                 // Fee de %
  3999.                 if ($service->getOpCommission() == 1){
  4000.                     // La Comision es positiva
  4001.                     $comision = $fee->getAmount() + $service->getCommission();
  4002.                     $service->setCommission($comision);
  4003.                 } else {
  4004.                     // La Comision es negativa, no se puede alterar la comision por ende el porcentaje se calculará y añadirá en el over
  4005.                     $comision = $service->getPrice() * ( $fee->getAmount() / 100 );
  4006.                     $comision = $comision + $service->getOver();
  4007.                     $service->setOver($comision);
  4008.                 }
  4010.                 $em->persist($service);
  4011.                 $em->flush();
  4013.                 // Si es un servicio ya confirmado debemos modificar tambien ProposalSupplierServicesCost y en ProposalSupplierServicesCostClient
  4014.                 $prpSupSrvCosts = $em->getRepository(ProposalSupplierServicesCosts::class)->findOneByServicesId($service->getId());
  4015.                 if (!empty($prpSupSrvCosts)){
  4016.                     $prpSupSrvCosts->setCommission($service->getCommission());
  4018.                     $em->persist($prpSupSrvCosts);
  4019.                     $em->flush();
  4020.                 }
  4022.                 $prpSupSrvCostsClient = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($service->getId());
  4023.                 if (!empty($prpSupSrvCostsClient)){
  4024.                     $prpSupSrvCostsClient->setCommission($service->getCommission());
  4025.                     $prpSupSrvCostsClient->setOver($service->getOver());
  4027.                     $em->persist($prpSupSrvCostsClient);
  4028.                     $em->flush();
  4029.                 }
  4031.             } else {
  4032.                 // Fee de €
  4034.                 if ($service->getOpOver() == 1){
  4035.                     // El Over es positivo
  4036.                     $over = $fee->getAmount() + $service->getOver();
  4037.                     $service->setOver($over);
  4038.                 } else {
  4039.                     // El Over es negativo,
  4040.                     if ($service->getOver() > $fee->getAmount()){
  4041.                         // Se mantendra el signo negativo del over. La cantidad de over negativo es superior al fee que agregamos
  4042.                         $service->setOver($service->getOver() - $fee->getAmount());
  4043.                     } else {
  4044.                         // Se cambiara el signo del over. La cantidad de over negativo es inferior o igual all fee que agregamos
  4045.                         $service->setOver($fee->getAmount() - $service->getOver());
  4046.                         $service->setOpOver(1);
  4047.                     }
  4048.                 }
  4050.                 $em->persist($service);
  4051.                 $em->flush();
  4053.                 // Si es un servicio ya confirmado debemos modificar tambien ProposalSupplierServicesCostClient (NO APLICA EN ProposalSupplierServicesCost)
  4054.                 $prpSupSrvCostsClient = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($service->getId());
  4055.                 if (!empty($prpSupSrvCostsClient)){
  4056.                     $prpSupSrvCostsClient->setOver($service->getOver());
  4058.                     $em->persist($prpSupSrvCostsClient);
  4059.                     $em->flush();
  4060.                 }
  4061.             }
  4063.         }
  4065.         return true;
  4066.     }
  4069.     private function eliminarFeeOculto( $idFee )
  4070.     {
  4071.         // No se eliminara el Fee, solo se quitara el monto de los servicios
  4072.         $em = $this->getDoctrine()->getManager();
  4073.         $fee = $em->getRepository(ProposalFee::class)->findOneById($idFee);
  4074.         $prpSupServices = $em->getRepository(ProposalSupplierServices::class)->findByProposalId($fee->getProposalId());
  4076.         foreach ($prpSupServices as $service){
  4078.             if ($fee->getType() == 0){
  4079.                 // Fee de %
  4081.                 if ($service->getOpCommission() == 1){
  4082.                     // La Comision es positiva
  4083.                     $comision = abs($service->getCommission() - $fee->getAmount());
  4084.                     $service->setCommission($comision);
  4085.                 } else {
  4086.                     // La Comision es negativa, no se puede alterar la comision
  4088.                 }
  4090.                 $em->persist($service);
  4091.                 $em->flush();
  4093.                 // Si es un servicio ya confirmado debemos modificar tambien ProposalSupplierServicesCost y en ProposalSupplierServicesCostClient
  4094.                 $prpSupSrvCosts = $em->getRepository(ProposalSupplierServicesCosts::class)->findOneByServicesId($service->getId());
  4095.                 if (!empty($prpSupSrvCosts)){
  4096.                     $prpSupSrvCosts->setCommission($service->getCommission());
  4098.                     $em->persist($prpSupSrvCosts);
  4099.                     $em->flush();
  4100.                 }
  4102.                 $prpSupSrvCostsClient = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($service->getId());
  4103.                 if (!empty($prpSupSrvCostsClient)){
  4104.                     $prpSupSrvCostsClient->setCommission($service->getCommission());
  4105.                     $prpSupSrvCostsClient->setOver($service->getOver());
  4107.                     $em->persist($prpSupSrvCostsClient);
  4108.                     $em->flush();
  4109.                 }
  4111.             } else {
  4112.                 // Fee de €
  4114.                 if ($service->getOpOver() == 1){
  4115.                     // El Over es positivo
  4116.                     $over = abs($service->getOver() - $fee->getAmount());
  4117.                     $service->setOver($over);
  4118.                 } else {
  4119.                     // El Over es negativo,
  4120.                     if ($service->getOver() > $fee->getAmount()){
  4122.                     } else {
  4124.                     }
  4125.                 }
  4127.                 $em->persist($service);
  4128.                 $em->flush();
  4130.                 // Si es un servicio ya confirmado debemos modificar tambien ProposalSupplierServicesCostClient (NO APLICA EN ProposalSupplierServicesCost)
  4131.                 $prpSupSrvCostsClient = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($service->getId());
  4132.                 if (!empty($prpSupSrvCostsClient)){
  4133.                     $prpSupSrvCostsClient->setOver($service->getOver());
  4135.                     $em->persist($prpSupSrvCostsClient);
  4136.                     $em->flush();
  4137.                 }
  4138.             }
  4140.         }
  4142.         return true;
  4143.     }
  4146.     /**
  4147.      * @Route("/proposal/summary/create",  name="proposal_summary_create")
  4148.      */
  4149.     public function createSummaryAction(Request $request){
  4150.         $controlid = $request->request->get('control')['id'];
  4152.         $em = $this->getDoctrine()->getManager();
  4153.         $proposalId = $request->request->get('proposal_id');
  4154.         $proposal = $em->getRepository(Proposal::class)->findOneById($proposalId);
  4155.         $oldSummary = $em->getRepository(ProposalsInvoiceSummary::class)->findOneByProposalId($proposalId);
  4156.         $newSummary = $request->request->get('descriptionSummary');
  4158.         if (!empty($oldSummary)){
  4159.             if (!empty($newSummary) and ($proposal->getStatus() != 'Invoiced')){
  4160.                 $oldSummary->setDescription($newSummary);
  4161.                 $em->persist($oldSummary);
  4162.                 $em->flush();
  4163.             } else {
  4164.                 if (empty($newSummary) and ($proposal->getStatus() != 'Invoiced')){
  4165.                     // Si viene vacío se elimina el resumen para obetener una factura completa
  4166.                     $em->remove($oldSummary);
  4167.                     $em->flush();
  4168.                 }
  4169.             }
  4170.         } else {
  4171.             $newSumm = new ProposalsInvoiceSummary();
  4172.             $newSumm->setDescription($newSummary);
  4173.             $newSumm->setProposalId($proposalId);
  4174.             $newSumm->setNet(null);
  4175.             $newSumm->setCurrency(null);
  4176.             $newSumm->setVatTen(null);
  4177.             $newSumm->setVatTwentyOne(null);
  4178.             $newSumm->setPayments(null);
  4180.             // Solo se creará el Summary si no se ha facturado
  4181.             if (($proposal->getStatus() != 'Invoiced') and !empty($newSummary)) {
  4182.                 $em->persist($newSumm);
  4183.                 $em->flush();
  4184.             }
  4185.         }
  4187.         return $this->redirectToRoute('proposal_destination_supplier_view',
  4188.             array(
  4189.                 'id' => $controlid,
  4190.                 '_fragment' => 'summary1'
  4191.             )
  4192.         );
  4193.     }
  4196.     /**
  4197.      * @Route("proposal/destination/services/block/{id}", name="proposal_destination_supplier_services_block")
  4198.      */
  4199.     public function udatedBlockAction($id, Request $request)
  4200.     {
  4202.         $block = $request->request->get('block');
  4203.         $em = $this->getDoctrine()->getManager();
  4204.         $services_control = $em->getRepository(ProposalSupplierControl::class)->findOneById($id);
  4206.         if (!empty($block['dateBlockLimit']) and !empty($block['timeBlockLimit'])){
  4207.             $services_control->setDateBlockLimit(new \DateTime($block['dateBlockLimit'].' '.$block['timeBlockLimit'] ));
  4209.             $services_supplier_proposal = $em->getRepository(ProposalSupplierServices::class)->findByControlId($services_control->getId());
  4210.             foreach($services_supplier_proposal as $servicessupplierproposal) {
  4211.                 $servicessupplierproposal->setDateBlockLimit(new \DateTime($block['dateBlockLimit'] . ' ' . $block['timeBlockLimit']));
  4212.                 $servicessupplierproposal->setStatus('Block');
  4213.                 $em->persist($servicessupplierproposal);
  4214.                 $em->flush();
  4215.             }
  4217.             $em->persist($services_control);
  4218.             $em->flush();
  4220.             $event = 'The Block supplier updated in Destination Proposal.';
  4221.             $successMessage = $this->translator->trans($event);
  4222.             $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  4224.         }else{
  4225.             $errorMessage = $this->translator->trans('Error');
  4226.             $this->addFlash('mensajeproposaldestinationservicesrror', $errorMessage);
  4227.         }
  4229.         return $this->redirectToRoute('proposal_destination_supplier_view',
  4230.             array(
  4231.                 'id' => $services_control->getControlDestinationId(),
  4232.                 '_fragment' => 's'.$id
  4233.             )
  4234.         );
  4237.     }
  4239.     /**
  4240.      * @Route("/multichckservices", name="multichckservices")
  4241.      */
  4242.     public function multiChckServicesAction(Request $request) {
  4244.         $idSupplier = $_POST['idSupplier'];
  4245.         $idService = $_POST['idService'];
  4247.         /* Obtengo usuario logueado */
  4248.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  4249.         $user_id = $user_logueado->getId();
  4250.         $user_role = $user_logueado->getRole();
  4252.         $em = $this->getDoctrine()->getManager();
  4253.         $services = $em->getRepository(ProposalSupplierServices::class)->findOneById($idService);
  4255.         // INICIO: Buscamos el proposal para verificar que no este bloqueado o facturado
  4256.         $propId = $services->getProposalId();
  4257.         $proposal = $em->getRepository(Proposal::class)->findOneById($propId);
  4259.         // FIN :Buscamos el proposal para verificar que no este bloqueado o facturado
  4261.         if (!empty($services)){
  4262.             if ($services->getStatus()== 'Pending') {
  4263.                 $services->setStatus('Confirmed');
  4264.                 $services->setUpdatedId($user_id);
  4265.             } else {
  4266.                 $services->setStatus('Pending');
  4267.                 $services->setUpdatedId($user_id);
  4268.             }
  4270.             try{
  4271.                 if (!empty($proposal)){
  4272.                     if (($proposal->getStatus() == 'Invoiced') or ($proposal->getStatus() == 'Blocked')) {
  4273.                         // De ser un expediente Facturado o bloqueado no se hace modificacion
  4274.                     } else {
  4275.                         if (empty($services->getSupplierId())){
  4276.                             $services->setSupplierId(4);
  4277.                         }
  4279.                         $em->persist($services);
  4280.                         $em->flush();
  4282.                         /* Para dentro de ProposalSupplierControl */
  4283.                         if (!empty($services->getSupplierId())){
  4284.                             $controlctrlDes = $em->getRepository(ProposalSupplierControl::class)->findOneBy( array(
  4285.                                 'supplierId' => $services->getSupplierId(),
  4286.                                 'proposalId' => $services->getProposalId()
  4287.                             ));
  4288.                         } else {
  4289.                             $controlctrlDes = $em->getRepository(ProposalSupplierControl::class)->findOneBy( array(
  4290.                                 'supplierId' => 4,
  4291.                                 'proposalId' => $services->getProposalId()
  4292.                             ));
  4293.                         }
  4295. //                         Si el control se encuentra vacio, se debe crear uno nuevo
  4296.                         if (empty($controlctrlDes)){
  4297.                             $controlctrlDes = new ProposalSupplierControl();
  4298.                             $controlctrlDes->setControlDestinationId($services->getDestinationId());  // Falta corregir el ControlDestinationId ahora tiene el Id del destino
  4299.                             $controlctrlDes->setProposalId($services->getProposalId());
  4300.                             $controlctrlDes->setDestinoId($services->getDestinationId());
  4301.                             $controlctrlDes->setSupplierId(4);
  4302.                             $controlctrlDes->setStatus('Pending');
  4304.                             $em->persist($controlctrlDes);
  4305.                             $em->flush();
  4306.                         }
  4308.                         //COLOR POR SERVICIO
  4309.                         $contcolor ="";
  4310.                         switch ($services->getServiceCatName()) {
  4311.                             case "Accommodation":
  4312.                                 $contcolor = 'teal';
  4313.                                 break;
  4314.                             case "Menu" :
  4315.                                 $contcolor = 'purple';
  4316.                                 break;
  4317.                             case "Lounge":
  4318.                                 $contcolor = 'warning';
  4319.                                 break;
  4320.                             case "Activities":
  4321.                                 $contcolor = 'blue';
  4322.                                 break;
  4323.                             case "Itineraries":
  4324.                                 $contcolor = 'indigo';
  4325.                                 break;
  4326.                             case "Cruise":
  4327.                                 $contcolor = 'brown';
  4328.                                 break;
  4329.                             case "Transport":
  4330.                                 $contcolor = 'grey';
  4331.                                 break;
  4332.                             case "Av":
  4333.                                 $contcolor = 'slate';
  4334.                                 break;
  4335.                             case "Creative":
  4336.                                 $contcolor = 'orange';
  4337.                                 break;
  4338.                             case "Gifts":
  4339.                                 $contcolor = 'pink';
  4340.                                 break;
  4341.                             case "Entertainment":
  4342.                                 $contcolor = 'green';
  4343.                                 break;
  4344.                             case "Guide":
  4345.                                 $contcolor = 'orange';
  4346.                                 break;
  4347.                             case "Others":
  4348.                                 $contcolor = 'danger';
  4349.                                 break;
  4350.                             case "Technology":
  4351.                                 $contcolor = 'slate-800';
  4352.                                 break;
  4353.                             case "Assistant":
  4354.                                 $contcolor = 'indigo-800';
  4355.                                 break;
  4356.                             case "DDR":
  4357.                                 $contcolor = 'green-300';
  4358.                                 break;
  4359.                         }
  4361.                         /* Para dentro de ProposalSupplierServicesCostsClient */
  4362.                         $costsClient = new ProposalSupplierServicesCostsClient();
  4363.                         $costsClient->setServiceIdProposal($services->getId());
  4364.                         $costsClient->setServiceIdFather($services->getServiceIdFather());
  4366.                         $costsClient->setControlId($controlctrlDes->getId());
  4367. //                        if (empty($services->getSupplierId())){$costsClient->setControlId(14244);} else {$costsClient->setControlId($services->getControlId());}
  4369.                         $costsClient->setProposalId($services->getProposalId());
  4370.                         $costsClient->setDestinationId($services->getDestinationId());
  4371.                         if (empty($services->getSupplierId())){$costsClient->setSupplierId('4');} else {$costsClient->setSupplierId($services->getSupplierId());}
  4372.                         $costsClient->setAssistantId($services->getAssistantId());
  4373.                         $costsClient->setIdeaId($services->getIdeaId());
  4374.                         $costsClient->setActivityId($services->getActivityId());
  4375.                         $costsClient->setServiceId($services->getServiceId());
  4376.                         $costsClient->setServiceCatId($services->getServiceCatId());
  4377.                         $costsClient->setServiceCatName($services->getServiceCatName());
  4378.                         $costsClient->setName($services->getName());
  4379.                         $costsClient->setPrice($services->getPrice());
  4380.                         $costsClient->setCurrency($services->getCurrency());
  4381.                         $costsClient->setUnits($services->getUnits());
  4382.                         $costsClient->setOpCommission($services->getOpCommission());
  4383.                         $costsClient->setCommission($services->getCommission());
  4384.                         $costsClient->setOpOver($services->getOpOver());
  4385.                         $costsClient->setOver($services->getOver());
  4386.                         $costsClient->setOpIva($services->getOpIva());
  4387.                         $costsClient->setIva($services->getIva());
  4388.                         $costsClient->setPax($services->getPax());
  4389.                         $costsClient->setHour($services->getHour());
  4390.                         $costsClient->setDateInAt($services->getDateInAt());
  4391.                         $costsClient->setDateOutAt($services->getDateOutAt());
  4392.                         $costsClient->setRank($services->getRank());
  4393.                         $costsClient->setCreatedId($user_id);
  4394.                         $costsClient->setUpdatedId($user_id);
  4395.                         $costsClient->setContcolor($contcolor);
  4396.                         $costsClient->setRenovate('0');
  4397.                         $em->persist($costsClient);
  4398.                         $em->flush();
  4399.                     }
  4400.                 }
  4401.             } catch (\Exception $e){
  4403.             }
  4404.         }
  4406.         $return = array(
  4407.             'services' => $services,
  4408.         );
  4410.         $response = new JsonResponse($return);
  4411.         return $response;
  4412.     }
  4415.     /**
  4416.      * @Route("proposal/destination/services/listmultiple/{idcontrol}", name="proposal_destination_supplier_list_multiple")
  4417.      */
  4418.     public function listMultipleAction($idcontrol, Request $request) {
  4419.         $em = $this->getDoctrine()->getManager();
  4420.         $control = $em->getRepository(ProposalSupplierControl::class)->findOneById($idcontrol);
  4421.         $idsupplier = $control->getSupplierId();
  4422.         $idMemorySupplier = $idsupplier;
  4423.         $ididea = $control->getIdeaId();
  4424.         $idactivity = $control->getActivityId();
  4426.         if($idsupplier == '0'){
  4427.             $id = '0';
  4428.         }else{
  4429.             if(!empty($idsupplier)){
  4430.                 /*CONTROL GENERAL*/
  4431.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneBySupplierId($idsupplier);
  4432.                 $id = $controlgeneral->getId();
  4433.             }
  4434.             if(!empty($idactivity)){
  4435.                 /*CONTROL GENERAL*/
  4436.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByActivityId($idactivity);
  4437.                 $id = $controlgeneral->getId();
  4438.             }
  4439.             if(!empty($ididea)){
  4440.                 /*CONTROL GENERAL*/
  4441.                 $controlgeneral = $em->getRepository(SupplierIdeaServicesControl::class)->findOneByIdeaId($ididea);
  4442.                 $id = $controlgeneral->getId();
  4443.             }
  4444.         }
  4446.         if (!empty($control)){
  4447.             $idProposal = $control->getProposalId();
  4448.             $proposal = $em->getRepository(Proposal::class)->findOneById($idProposal);
  4450.             // Buscamos a partir del IDCONTROL los elementos principales (Proveedores, Actividades, Ideas) agregados al destino para la carga multiple
  4451.             $destinoId = $control->getDestinoId();
  4453.             $servicesControllers = $em->getRepository(ProposalSupplierControl::class)->findBy(
  4454.                 array(
  4455.                     'proposalId' => $proposal,
  4456.                     'destinoId' => $destinoId
  4457.                 )
  4458.             );
  4460.             //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
  4461.             $tempKey = null;
  4462.             $logicKey = false;
  4463.             foreach ($servicesControllers as $key => $item) {
  4464.                 if(($item->getSupplierId() == 0) and (empty($item->getActivityId())) and (empty($item->getIdeaId()))){
  4465.                     // Es un white service, se guarda el indice para luego procesar
  4466.                     $tempKey = $key;
  4467.                     $logicKey = true;
  4468.                 }
  4470.                 if(!empty($item->getSupplierId()) and ($item->getSupplierId() != 0)){
  4471.                     // Es un proveedor ordinario
  4472.                     $tempSup = $em->getRepository(Supplier::class)->findOneById($item->getSupplierId());
  4473.                     $servicesControllers[$key]->setStatus($tempSup->getName());
  4474.                 }
  4476.                 if (!empty($item->getActivityId())){
  4477.                     // Es Actividad
  4478.                     $tempAct = $em->getRepository(Activities::class)->findOneById($item->getActivityId());
  4479.                     $servicesControllers[$key]->setStatus($tempAct->getName());
  4480.                 }
  4482.                 if (!empty($item->getIdeaId())) {
  4483.                     // Es Idea
  4484.                     $tempIdea = $em->getRepository(Ideas::class)->findOneById($item->getIdeaId());
  4485.                     $servicesControllers[$key]->setStatus($tempIdea->getName());
  4486.                 }
  4487.             }
  4489.             if($logicKey){
  4490.                 $servicesControllers[$tempKey]->setStatus('SERVICIO SIN PROVEEDOR');
  4491.                 array_push($servicesControllers,$servicesControllers[$tempKey]);
  4492.                 unset($servicesControllers[$tempKey]);
  4493.             }
  4494.             //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
  4495.         }
  4497. //        LIMPIEZA DE DATOS PARA LA VISTA
  4498.         if (!($idMemorySupplier === 0)){// el === evalua correctamente el caso de nulo
  4500.             $newServicesControllers = array();
  4501.             foreach ($servicesControllers as $item){
  4502.                 if (intval($idcontrol) === $item->getId()){
  4503.                     $newServicesControllers[] = $item;
  4504.                 }
  4505.             }
  4506.             $servicesControllers = $newServicesControllers;
  4507.         }
  4509.         if (sizeof($servicesControllers) == 1){
  4510.             $numElementos = 10;
  4511.         } else {
  4512.             $numElementos = 5;
  4513.         }
  4515.         /* salida de data */
  4516.         return $this->render('MDS/EventsBundle/services/services-multiple-modal-proposal.html.twig', array(
  4517. //        return $this->render('MDS/EventsBundle/services/services-multiple-add-destination-proposal.html.twig', array(
  4518.             'idcontrol' => $idcontrol,
  4519.             'servicesControllers' => $servicesControllers,
  4520.             'id' => $idProposal,
  4521.             'proposal' => $proposal,
  4522.             'numElementos' => $numElementos,
  4523.             'token' => $proposal->getAccessKey(),
  4524.             'mcp' => null,
  4525.             'datasupplier' => null,
  4526.             'discounts' => null,
  4527.             'status' => null,
  4528.             'global_calculos' => null,
  4529.             'accommodations' => '',
  4530.             'menus' => '',
  4531.             'lounges' => '',
  4532.             'transports' => '',
  4533.             'guides' => '',
  4534.             'itineraries' => '',
  4535.             'activities' => '',
  4536.             'cruises' => '',
  4537.             'avs' => '',
  4538.             'creatives' => '',
  4539.             'gifts' => '',
  4540.             'entertainments' => '',
  4541.             'technology' => '',
  4542.             'assistants' => '',
  4543.             'otherss' => ''
  4544.         ));
  4545.     }
  4548.     /**
  4549.      * @Route("proposal/destination/services/createmultiple", name="proposal_destination_supplier_create_multiple")
  4550.      */
  4551.     public function createMultipleAction(Request $request) {
  4553.         $add_services_multiple_type = $request->request->get('add_services_multiple_type');
  4554.         $add_services_multiple_name = $request->request->get('add_services_multiple_name');
  4555.         $add_services_multiple_price = $request->request->get('add_services_multiple_price');
  4556.         $add_services_multiple_commission = $request->request->get('add_services_multiple_commission');
  4557.         $add_services_multiple_over = $request->request->get('add_services_multiple_over');
  4558.         $add_services_multiple_iva = $request->request->get('add_services_multiple_iva');
  4560.         $em = $this->getDoctrine()->getManager();
  4562.         /* Obtengo usuario logueado */
  4563.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  4564.         $user_id = $user_logueado->getId();
  4567.         // INICIO: Generamos un arreglo con todos los servicios a agregar
  4568.         $newServices = array();
  4570.         foreach ($add_services_multiple_type as $key1 => $item) {
  4572.             foreach ($item as $key2 => $elem){
  4574.                 $newServ = new ProposalSupplierServices();
  4575.                 $newServ->setControlId($key1);
  4576.                 $controlTemp = $em->getRepository(ProposalSupplierControl::class)->findOneById($key1);
  4577.                 $proposal_data = $em->getRepository(Proposal::class)->findOneById($controlTemp->getProposalId());
  4579.                 switch ($elem['type']) {
  4580.                     case 1:
  4581.                         $newServ->setServiceCatId('1');
  4582.                         $newServ->setServiceCatName('Accommodation');
  4583.                         break;
  4584.                     case 2:
  4585.                         $newServ->setServiceCatId('2');
  4586.                         $newServ->setServiceCatName('Activities');
  4587.                         break;
  4588.                     case 3:
  4589.                         $newServ->setServiceCatId('3');
  4590.                         $newServ->setServiceCatName('Av');
  4591.                         break;
  4592.                     case 4:
  4593.                         $newServ->setServiceCatId('4');
  4594.                         $newServ->setServiceCatName('Creative');
  4595.                         break;
  4596.                     case 5:
  4597.                         $newServ->setServiceCatId('5');
  4598.                         $newServ->setServiceCatName('Cruise');
  4599.                         break;
  4600.                     case 6:
  4601.                         $newServ->setServiceCatId('6');
  4602.                         $newServ->setServiceCatName('Entertainment');
  4603.                         break;
  4604.                     case 7:
  4605.                         $newServ->setServiceCatId('7');
  4606.                         $newServ->setServiceCatName('Gifts');
  4607.                         break;
  4608.                     case 8:
  4609.                         $newServ->setServiceCatId('8');
  4610.                         $newServ->setServiceCatName('Guide');
  4611.                         break;
  4612.                     case 9:
  4613.                         $newServ->setServiceCatId('9');
  4614.                         $newServ->setServiceCatName('Itineraries');
  4615.                         break;
  4616.                     case 10:
  4617.                         $newServ->setServiceCatId('10');
  4618.                         $newServ->setServiceCatName('Lounge');
  4619.                         break;
  4620.                     case 11:
  4621.                         $newServ->setServiceCatId('11');
  4622.                         $newServ->setServiceCatName('Menu');
  4623.                         break;
  4624.                     case 12:
  4625.                         $newServ->setServiceCatId('12');
  4626.                         $newServ->setServiceCatName('Others');
  4627.                         break;
  4628.                     case 13:
  4629.                         $newServ->setServiceCatId('13');
  4630.                         $newServ->setServiceCatName('Transport');
  4631.                         break;
  4632.                     case 14:
  4633.                         $newServ->setServiceCatId('14');
  4634.                         $newServ->setServiceCatName('Technology');
  4635.                         break;
  4636.                     case 15:
  4637.                         $newServ->setServiceCatId('15');
  4638.                         $newServ->setServiceCatName('Assistant');
  4639.                         break;
  4640.                     case 16:
  4641.                         $newServ->setServiceCatId('16');
  4642.                         $newServ->setServiceCatName('DDR');
  4643.                         break;
  4644.                     case 17:
  4645. //                        $newServ->setServiceCatId('17');
  4646. //                        $newServ->setServiceCatName('AV - EXPRESS');
  4647. //                        $newServ->setSupplierId('80');
  4648. //
  4649. //                        $control = new ProposalSupplierControl();
  4650. //                        $control->setSupplierId('80');
  4651. //                        $control->setStatus('Pending');
  4652. //                        $control->setControlDestinationId($cid);
  4653. //                        $control->setProposalId($pid);
  4654. //                        $control->setDestinoId($did);
  4655. //                        $em->persist($control);
  4656. //                        $em->flush();
  4657. //                        $event = 'The Supplier Destination Proposal has been created.';
  4658. //                        $successMessage = $this->translator->trans($event);
  4659. //                        $this->addFlash('mensajeproposaldestinationservices', $successMessage);
  4660. //
  4661. //                        return $this->redirectToRoute('proposal_destination_supplier_list', array(
  4662. //                            'idcontrol' => $cid
  4663. //                        ));
  4665.                         $newServ->setServiceCatId('');
  4666.                         $newServ->setServiceCatName('');
  4667.                         break;
  4668.                     default:
  4669.                         $newServ->setServiceCatId('');
  4670.                         $newServ->setServiceCatName('');
  4671.                         break;
  4672.                 }
  4674.                 $newServ->setName($add_services_multiple_name[$key1][$key2]['name']);
  4675. //                $newServ->setPrice($add_services_multiple_price[$key1][$key2]['price']);
  4677.                 if (empty($add_services_multiple_price[$key1][$key2]['price'])){
  4678.                     // Se pone el precio a 0 si viene vacio
  4679.                     $newServ->setPrice('0');
  4680.                 } else {
  4681.                     $newServ->setPrice($add_services_multiple_price[$key1][$key2]['price']);
  4682.                 }
  4684.                 if (empty($add_services_multiple_commission[$key1][$key2]['commission'])){
  4685.                     // Se pone la commission en 0 si viene vacio
  4686.                     $newServ->setCommission('0');
  4687.                 } else {
  4688.                     $newServ->setCommission($add_services_multiple_commission[$key1][$key2]['commission']);
  4689.                 }
  4691.                 if (empty($add_services_multiple_over[$key1][$key2]['over'])){
  4692.                     // Se pone el over en 0 si viene vacio
  4693.                     $newServ->setOver('0');
  4694.                 } else {
  4695.                     $newServ->setOver($add_services_multiple_over[$key1][$key2]['over']);
  4696.                 }
  4698.                 if (empty($add_services_multiple_iva[$key1][$key2]['iva'])){
  4699.                     // Se pone el iva a 21% si viene vacio
  4700.                     $newServ->setIva('21');
  4701.                 } else {
  4702.                     $newServ->setIva($add_services_multiple_iva[$key1][$key2]['iva']);
  4703.                 }
  4704.                 $newServ->setProposalId($controlTemp->getProposalId());
  4705.                 $newServ->setDestinationId($controlTemp->getDestinoId());
  4706.                 $newServ->setSupplierId($controlTemp->getSupplierId());
  4707.                 $newServ->setIdeaId($controlTemp->getIdeaId());
  4708.                 $newServ->setActivityId($controlTemp->getActivityId());
  4710.                 /* NAMEJO DE ADICIONALES EN EL DIA DEL EVENTO O DESPUES EL DIA DEL EVENTO */
  4711.                 $dayEvent = $proposal_data->getDateEventStarAt()->format('Y-m-d');
  4712.                 $today = date('Y-m-d');
  4713.                 if( $today >= $dayEvent){
  4714.                     $additional = "Additional";
  4715.                 }else{
  4716.                     $additional = "Normal";
  4717.                 }
  4719.                 $newServ->setCurrency('Euro');
  4720.                 $newServ->setUnits('1');
  4721.                 $newServ->setPax('0');
  4722.                 $newServ->setServiceId(0);
  4723.                 //$newServ->setHour('');//null
  4724.                 //$newServ->setDateInAt('');
  4725.                 //$newServ->setDateOutAt('');
  4726.                 $newServ->setDirectPayment('0');
  4727.                 $newServ->setStatus('Pending');
  4728.                 $newServ->setStatusinternal($additional);
  4729.                 $newServ->setDateInAt($proposal_data->getDateEventStarAt());
  4730.                 $newServ->setDateOutAt($proposal_data->getDateEventEndAt());
  4731.                 $newServ->setCreatedId($user_id);
  4732.                 $newServ->setUpdatedId($user_id);
  4734.                 $newServices[] = $newServ;
  4735.             }
  4736.         }
  4737.         // Eliminamos servicios sin tipo
  4738.         $arrayNewServ = array();
  4739.         foreach ($newServices as $item) {
  4740.             if (!empty($item->getServiceCatName())){   //setServiceCatName
  4741.                 $arrayNewServ[] = $item;
  4742.             }
  4743.         }
  4744.         // FIN: Generamos un arreglo con todos los servicios a agregar
  4746.         foreach ($arrayNewServ as $item){
  4747.             $em->persist($item);
  4748.             $em->flush();
  4750.             //INICIO: Replicacion en Develup
  4751.             if ($item->getSupplierId()==2){
  4752.                 // Nombre del agente
  4753.                 $agenteFullName = $em->getRepository(User::class)->findOneById($user_id);
  4754.                 $agenteFullName = $agenteFullName->getName() . ' ' . $agenteFullName->getLastName();
  4755.                 $proposalTitle = $em->getRepository(Proposal::class)->findOneById($item->getProposalId());
  4757.                 if ($item->getSupplierId()==2){
  4758.                     $originalServiceName = $em->getRepository(MdvProduct::class)->findOneById(1); // Id de "Otro Servicio"
  4760.                     $budget = new MdvBudgetPending();
  4761.                     $budget->setActivityId($item->getActivityId());
  4762.                     $budget->setAssistantId($item->getAssistantId());
  4763.                     $budget->setBreakdown($item->getBreakdown());
  4764.                     $budget->setCommission($item->getCommission());
  4765.                     $budget->setControlId($item->getControlId());
  4766.                     $budget->setOriginId($item->getId());
  4767.                     $budget->setCurrency($item->getCurrency());
  4768.                     $budget->setDateBlockLimit($item->getDateBlockLimit());
  4769.                     $budget->setDateInAt($item->getDateInAt());
  4770.                     $budget->setDateOutAt($item->getDateOutAt());
  4771.                     $budget->setDestinationId($item->getDestinationId());
  4772.                     $budget->setDirectPayment($item->getDirectPayment());
  4773.                     $budget->setHour($item->getHour());
  4774.                     $budget->setIdeaId($item->getIdeaId());
  4775.                     $budget->setIsFather($item->getIsFather());
  4776.                     $budget->setIva($item->getIva());
  4778.                     if(!($originalServiceName->getName() == $item->getName())){
  4779.                         $budget->setName($originalServiceName->getName().' (:'. $item->getName().':)');
  4780.                     } else {
  4781.                         $budget->setName($originalServiceName->getName());
  4782.                     }
  4784.                     $budget->setOpCommission($item->getOpCommission());
  4785.                     $budget->setOpIva($item->getOpIva());
  4786.                     $budget->setOpOver($item->getOpOver());
  4787.                     $budget->setOriginalIva($item->getOriginalIva());
  4788.                     $budget->setOriginalopIva($item->getOriginalopIva());
  4789.                     $budget->setOriginalPrice($item->getOriginalPrice());
  4790.                     $budget->setOver($item->getOver());
  4791.                     $budget->setPax($item->getPax());
  4792.                     $budget->setPreCommission($item->getPreCommission());
  4793.                     $budget->setPreIva($item->getPreIva());
  4794.                     $budget->setPrice($item->getPrice());
  4795.                     $budget->setProposalId($item->getProposalId());
  4796.                     $budget->setRank($item->getRank());
  4797.                     $budget->setServiceCatId($item->getServiceCatId());
  4798.                     $budget->setServiceCatName($item->getServiceCatName());
  4799. //                    $budget->setServiceId($item->getServiceId());
  4800.                     $budget->setServiceId(1);       // ID de "Otro Servicio"
  4801.                     $budget->setServiceIdFather($item->getServiceIdFather());
  4802.                     $budget->setStatus($item->getStatus());
  4803.                     $budget->setStatusinternal($item->getStatusinternal());
  4804.                     $budget->setStatusRec($item->getStatusRec());
  4805.                     $budget->setSupplierId($item->getSupplierId());
  4806.                     $budget->setUnits($item->getUnits());
  4808.                     $budget->setUserConfirmedFullName($agenteFullName);
  4809.                     $budget->setUserConfirmedId($user_id);
  4810.                     $budget->setProposalTitle($proposalTitle->getTitle());
  4812.                     $budget->setCreatedAt(new \DateTime("now"));
  4813.                     $budget->setCreatedId($user_id);
  4814.                     $budget->setUpdatedId($user_id);
  4815.                     $budget->setUpdatedAt(new \DateTime("now"));
  4817.                     // INIICO: Llenamos el tooltip con la info del proposal
  4818.                     $texto = null;
  4819.                     if (!empty($budget->getProposalId())){
  4820.                         $prop = $em->getRepository(Proposal::class)->findOneById($budget->getProposalId());
  4821.                         if (!empty($prop)){
  4822.                             $client = $em->getRepository(Client::class)->findOneById($prop->getClientId());
  4823.                             $clientContact = $em->getRepository(ClientContact::class)->findOneById($prop->getContactId());
  4825.                             $contacto = null;
  4826.                             if (!empty($clientContact->getName())){$contacto = $contacto. $clientContact->getName(). ' ';}
  4827.                             if (!empty($clientContact->getLastName())){$contacto = $contacto. $clientContact->getLastName(). ' ';}
  4828.                             if (!empty($clientContact->getEmail())){$contacto = $contacto. '('.$clientContact->getEmail().')'. ' ';}
  4829.                             if (!empty($clientContact->getPhone())){$contacto = $contacto. ' - '.$clientContact->getPhone(). ' ';}
  4830.                             if (!empty($clientContact->getMobile())){$contacto = $contacto. ' - '.$clientContact->getMobile();}
  4832.                             $city = $em->getRepository(Destination::class)->findOneById($budget->getDestinationId());
  4833.                             $texto = $texto .'Petición: '.$budget->getCreatedAt()->format('d/m/Y'). ' -- ';
  4834.                             if (!empty($client)){$texto = $texto .'Cliente: '.$client->getName(). ' -- ';}
  4835.                             if (!empty($prop->getPax())){$texto = $texto .'Personas: '.$prop->getPax(). ' -- ';}
  4836.                             $texto = $texto .'Desde: '.$prop->getDateEventStarAt()->format('d/m/Y').' Hasta: '.$prop->getDateEventEndAt()->format('d/m/Y'). ' -- ';
  4837.                             $texto = $texto .'Horario: '.$item->getDateInAt()->format('H:i'). ' a '.$item->getDateOutAt()->format('H:i'). ' -- ';
  4838.                             $texto = $texto .'Ciudad: '.$city->getTitle(). ' -- ';
  4839.                             $texto = $texto .'Contacto: '. $contacto;
  4840.                             $budget->setTextTooltip($texto);
  4841.                         }
  4842.                     }
  4843.                     // FIN: Llenamos el tooltip con la info del proposal
  4845.                     $em->persist($budget);
  4846.                     $em->flush();
  4848.                     //INICIO: Enviamos Telegram
  4849.                     //INICIO: Buscamos el creador del expediente asociado al proposal, si no hay se le envia al jefe de grupo (Jorge)
  4850.                     $file = $em->getRepository(MdvFiles::class)->findOneByIdProposal($prop->getId());
  4851.                     if(!empty($file)){
  4852.                         //Se envia el mensaje al creador del expediente
  4853.                         $userTelegramId = $file->getCreatedId();
  4854.                     } else {
  4855.                         // Solicitud sin expediente, se le notificara la jefe de departamento
  4856.                         $userTelegramId = 5; // Id de Jorge
  4857.                     }
  4859.                     //FIN: Buscamos el creador del expediente asociado al proposal, si no hay se le envia al jefe de grupo (Jorge)
  4861.                     //Buscamos el nombre del destino
  4862.                     $nombreDestino = $em->getRepository(Destination::class)->findOneById($budget->getDestinationId());
  4863.                     $nombreDestino = $nombreDestino->getTitle();
  4865.                     //Mensaje:
  4866.                     //SOLICITUD DE PRESUPUESTO __ ID: '.$budget->getProposalId().' __ DESTINO: '.$nombreDestino.' __ PROVEEDOR: In Out Travel __ CONTACTO: '.$budget->getUserConfirmedFullName()
  4867.                     $this->sendTelegram($userTelegramId,'SOLICITUD DE PRESUPUESTO (MultiService) __ ID: '.$budget->getProposalId().' __ DESTINO: '.$nombreDestino.' __ PROVEEDOR: In Out Travel __ CONTACTO: '.$budget->getUserConfirmedFullName());
  4868. //                            d($userTelegramId,'SOLICITUD DE PRESUPUESTO __ ID: '.$budget->getProposalId().' __ DESTINO: '.$nombreDestino.' __ PROVEEDOR: In Out Travel __ CONTACTO: '.$budget->getUserConfirmedFullName());exit();
  4869.                     //FIN: Enviamos Telegram
  4870.                 }
  4871.             }
  4872.             //FIN: Replicacion en Develup
  4874.         }
  4876.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  4877.             'id' => $controlTemp->getControlDestinationId(),
  4878.         ));
  4879.     }
  4882.     /**
  4883.      * @Route("proposal/destination/services/saveallservices/{id}", name="proposal_destination_supplier_saveallservices")
  4884.      */
  4885.     public function saveAllServicesAction($id, Request $request) {
  4887.         $save_services_multiple_name = $request->request->get('services_hidden_name');
  4888.         $save_services_multiple_rank = $request->request->get('services_hidden_rank');
  4889.         $save_services_multiple_price = $request->request->get('services_hidden_price');
  4890.         $save_services_multiple_units = $request->request->get('services_hidden_units');
  4891.         $save_services_multiple_pax = $request->request->get('services_hidden_pax');
  4892.         $save_services_multiple_commission = $request->request->get('services_hidden_commission');
  4893.         $save_services_multiple_over = $request->request->get('services_hidden_over');
  4894.         $save_services_multiple_iva = $request->request->get('services_hidden_iva');
  4895.         $save_services_multiple_originalPrice = $request->request->get('services_hidden_originalPrice');
  4896.         $save_services_multiple_originalIva = $request->request->get('services_hidden_originalIva');
  4897.         $save_services_multiple_supplier = $request->request->get('services_hidden_supplier');
  4898.         $save_services_multiple_opcommission = $request->request->get('services_hidden_opcommission');
  4899.         $save_services_multiple_opover = $request->request->get('services_hidden_opover');
  4900.         $save_services_multiple_opiva = $request->request->get('services_hidden_opiva');
  4901.         $save_services_multiple_dateBlockLimit = $request->request->get('services_hidden_dateBlockLimit');
  4902.         $save_services_multiple_timeBlockLimit = $request->request->get('services_hidden_timeBlockLimit');
  4903.         $save_services_multiple_dateInAt = $request->request->get('services_hidden_dateInAt');
  4904.         $save_services_multiple_dateOutAt = $request->request->get('services_hidden_dateOutAt');
  4905.         $save_services_multiple_hour_start = $request->request->get('services_hidden_hour_start_');
  4906.         $save_services_multiple_hour_end = $request->request->get('services_hidden_hour_end_');
  4907.         $save_services_multiple_currency = $request->request->get('services_hidden_currency_');
  4908.         $save_services_multiple_originalopIva = $request->request->get('services_hidden_originalopIva_');
  4909.         $save_multiple_supplier_activity_idea_rank = $request->request->get('supplier_activity_idea_hidden_rank');
  4911.         $arrayServices = array();
  4912.         foreach ($save_services_multiple_name as $key => $name){
  4913.             $service = new ProposalSupplierServices();
  4914.             $service->setName($name);
  4915.             $service->setRank($save_services_multiple_rank[$key]);
  4916.             $service->setPrice($save_services_multiple_price[$key]);
  4917.             $service->setUnits($save_services_multiple_units[$key]);
  4918.             $service->setPax($save_services_multiple_pax[$key]);
  4919.             $service->setCommission($save_services_multiple_commission[$key]);
  4920.             $service->setOver($save_services_multiple_over[$key]);
  4921.             $service->setIva($save_services_multiple_iva[$key]);
  4922.             $service->setOriginalPrice($save_services_multiple_originalPrice[$key]);
  4923.             $service->setOriginalIva($save_services_multiple_originalIva[$key]);
  4924.             $service->setSupplierId($save_services_multiple_supplier[$key]);
  4925.             $service->setOpCommission($save_services_multiple_opcommission[$key]);
  4926.             $service->setOpOver($save_services_multiple_opover[$key]);
  4927.             $service->setOpIva($save_services_multiple_opiva[$key]);
  4928.             if (!empty($save_services_multiple_dateBlockLimit[$key]) or !empty($save_services_multiple_timeBlockLimit[$key])){
  4929.                 $service->setDateBlockLimit(new \DateTime($save_services_multiple_dateBlockLimit[$key].' '.$save_services_multiple_timeBlockLimit[$key]));
  4930.             }
  4931.             //$service->set ($save_services_multiple_timeBlockLimit[$key]);
  4932.             if (!empty($save_services_multiple_dateInAt[$key]) or !empty($save_services_multiple_hour_start[$key])) {
  4933.                 $service->setDateInAt(new \DateTime($save_services_multiple_dateInAt[$key] . ' ' . $save_services_multiple_hour_start[$key]));
  4934.             }
  4935.             if (!empty($save_services_multiple_dateOutAt[$key]) or !empty($save_services_multiple_hour_end[$key]) ) {
  4936.                 $service->setDateOutAt(new \DateTime($save_services_multiple_dateOutAt[$key] . ' ' . $save_services_multiple_hour_end[$key]));
  4937.             }
  4938.             $service->setHour($save_services_multiple_hour_start[$key]);
  4939.             //$service->set ($save_services_multiple_hour_end[$key]);
  4940.             $service->setCurrency($save_services_multiple_currency[$key]);
  4941.             $service->setOriginalopIva($save_services_multiple_originalopIva[$key]);
  4943.             $arrayServices[] = array($key, $service);
  4944.         }
  4946.         $em = $this->getDoctrine()->getManager();
  4948.         foreach ($save_multiple_supplier_activity_idea_rank as $key => $item){
  4949.             if(!empty($item)){
  4950.                 $prpSupActIdeaControl = $em->getRepository(ProposalSupplierControl::class)->findOneById($key);
  4951.                 if (!empty($prpSupActIdeaControl)){
  4952.                     $prpSupActIdeaControl->setRank($item);
  4953.                     $em->persist($prpSupActIdeaControl);
  4954.                     $em->flush();
  4955.                 }
  4956.             }
  4957.         }
  4959.         /* Obtengo usuario logueado */
  4960.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  4961.         $user_id = $user_logueado->getId();
  4963.         foreach ($arrayServices as $item){
  4964.             $prpSupService = $em->getRepository(ProposalSupplierServices::class)->findOneById($item[0]);
  4965.             $srvToSave = false;  //Indicador para determinar si se debe guardar el servicio
  4967.             // INICIO: Analizamos si se debe modificar el servicio, el $item[1] se encuentra el servicio
  4968.             if (!empty($item[1]->getName())){ // Hay nombre
  4969.                 $srvToSave = true;
  4970.                 $prpSupService->setName($item[1]->getName());
  4971.             }
  4973.             if (!empty($item[1]->getRank())){ // Hay ranking
  4974.                 $srvToSave = true;
  4975.                 $prpSupService->setRank($item[1]->getRank());
  4976.             }
  4978.             if (!empty($item[1]->getPrice())){ // Hay Precio
  4979.                 $srvToSave = true;
  4980.                 $prpSupService->setPrice($item[1]->getPrice());
  4981.             }
  4983.             if (!empty($item[1]->getUnits())){ // Hay Unidades
  4984.                 $srvToSave = true;
  4985.                 $prpSupService->setUnits($item[1]->getUnits());
  4986.             }
  4988.             if (!empty($item[1]->getPax())){ // Hay Personas
  4989.                 $srvToSave = true;
  4990.                 $prpSupService->setPax($item[1]->getPax());
  4991.             }
  4993.             if (!empty($item[1]->getCommission())){ // Hay Comision
  4994.                 $srvToSave = true;
  4995.                 $prpSupService->setCommission($item[1]->getCommission());
  4996.             }
  4998.             if (!empty($item[1]->getOver())){ // Hay Over
  4999.                 $srvToSave = true;
  5000.                 $prpSupService->setOver($item[1]->getOver());
  5001.             }
  5003.             if (!empty($item[1]->getIva()) or ($item[1]->getIva() == '0')){ // Hay Iva
  5004.                 $srvToSave = true;
  5005.                 $prpSupService->setIva($item[1]->getIva());
  5006.             }
  5008.             if (!empty($item[1]->getOriginalPrice())){ // Hay Original Price
  5009.                 $srvToSave = true;
  5010.                 $prpSupService->setOriginalPrice($item[1]->getOriginalPrice());
  5011.             }
  5013.             if (!empty($item[1]->getOriginalIva())){ // Hay Original Iva
  5014.                 $srvToSave = true;
  5015.                 $prpSupService->setOriginalIva($item[1]->getOriginalIva());
  5016.             }
  5018.             if (!empty($item[1]->getSupplierId())){ // Hay Supplier
  5019.                 $srvToSave = true;
  5020.                 $prpSupService->setSupplierId($item[1]->getSupplierId());
  5021.             }
  5023.             if (($item[1]->getOpCommission() === '0') or ($item[1]->getOpCommission() === '1')){ // Hay OpCommission
  5024.                 $srvToSave = true;
  5025.                 $prpSupService->setOpCommission($item[1]->getOpCommission());
  5026.             }
  5028.             if (($item[1]->getOpOver() === '0') or ($item[1]->getOpOver() === '1')){ // Hay OpOver
  5029.                 $srvToSave = true;
  5030.                 $prpSupService->setOpOver($item[1]->getOpOver());
  5031.             }
  5033.             if (($item[1]->getOpIva() === '0') or ($item[1]->getOpIva() === '1')){ // Hay OpIva
  5034.                 $srvToSave = true;
  5035.                 $prpSupService->setOpIva($item[1]->getOpIva());
  5036.             }
  5038.             if (!empty($item[1]->getHour())){ // Hay Hora de inicio
  5039.                 $srvToSave = true;
  5040.                 $prpSupService->setHour($item[1]->getHour());
  5041.             }
  5043.             if (!empty($item[1]->getCurrency())){ // Hay Moneda
  5044.                 $srvToSave = true;
  5045.                 $prpSupService->setCurrency($item[1]->getCurrency());
  5046.             }
  5048.             if (($item[1]->getOriginalopIva() === '0') or ($item[1]->getOriginalopIva() === '1')){ // Hay Original OP Iva
  5049.                 $srvToSave = true;
  5050.                 $prpSupService->setOriginalopIva($item[1]->getOriginalopIva());
  5051.             }
  5053.             if (!empty($item[1]->getDateBlockLimit())){ // Hay Fecha de Block Limit
  5054.                 $srvToSave = true;
  5055.                 $prpSupService->setDateBlockLimit($item[1]->getDateBlockLimit());
  5056.             }
  5058.             if (!empty($item[1]->getDateInAt())){ // Hay DateInAt
  5059.                 $srvToSave = true;
  5060.                 $prpSupService->setDateInAt($item[1]->getDateInAt());
  5061.             }
  5063.             if (!empty($item[1]->getDateOutAt())){ // Hay DateInAt
  5064.                 $srvToSave = true;
  5065.                 $prpSupService->setDateOutAt($item[1]->getDateOutAt());
  5066.             }
  5067.             // FIN: Analizamos si se debe modificar el servicio, el $item[1] se encuentra el servicio
  5069.             if ($srvToSave){
  5070.                 $em->persist($prpSupService);
  5071.                 $em->flush();
  5072.             }
  5074.             //Actualizar confirmado
  5075.             if ($prpSupService->getStatus() =='Confirmed'){
  5076.                 $costsClient = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($prpSupService->getId());
  5077.                 if (!empty($costsClient)){
  5078. //                $costsClient->setSupplierId($services_supplier_proposal->getSupplierId());
  5079.                     $costsClient->setAssistantId($prpSupService->getAssistantId());
  5080.                     $costsClient->setName($prpSupService->getName());
  5081.                     $costsClient->setPrice($prpSupService->getPrice());
  5082.                     $costsClient->setCurrency($prpSupService->getCurrency());
  5083.                     $costsClient->setUnits($prpSupService->getUnits());
  5084.                     $costsClient->setOpCommission($prpSupService->getOpCommission());
  5085.                     $costsClient->setCommission($prpSupService->getCommission());
  5086.                     $costsClient->setOpOver($prpSupService->getOpOver());
  5087.                     $costsClient->setOver($prpSupService->getOver());
  5088.                     $costsClient->setOpIva($prpSupService->getOpIva());
  5089.                     $costsClient->setIva($prpSupService->getIva());
  5090.                     $costsClient->setPax($prpSupService->getPax());
  5091.                     $costsClient->setHour($prpSupService->getHour());
  5092.                     $costsClient->setDateInAt($prpSupService->getDateInAt());
  5093.                     $costsClient->setDateOutAt($prpSupService->getDateOutAt());
  5094.                     $costsClient->setRank($prpSupService->getRank());
  5095.                     $costsClient->setCreatedId($user_id);
  5096.                     $costsClient->setUpdatedId($user_id);
  5097.                     $em->persist($costsClient);
  5098.                     $em->flush();
  5099.                 }
  5100.             }
  5101.         }
  5103.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  5104.             'id' => $id,
  5105.         ));
  5107.     }
  5109.     /**
  5110.      * @Route("proposal/destination/services/duplicateservice/{id}", name="proposal_destination_duplicate_service")
  5111.      */
  5112.     public function duplicateServiceAction($id, Request $request) {
  5114.         $em = $this->getDoctrine()->getManager();
  5115.         $prpSupService = $em->getRepository(ProposalSupplierServices::class)->findOneById($id);
  5117.         /* Obtengo usuario logueado */
  5118.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  5119.         $user_id = $user_logueado->getId();
  5121.         $service = new ProposalSupplierServices();
  5122.         $service->setName('DUPLICADO - '.$prpSupService->getName());
  5123.         $service->setRank($prpSupService->getRank());
  5124.         $service->setPrice($prpSupService->getPrice());
  5125.         $service->setUnits($prpSupService->getUnits());
  5126.         $service->setPax($prpSupService->getPax());
  5127.         $service->setCommission($prpSupService->getCommission());
  5128.         $service->setOver($prpSupService->getOver());
  5129.         $service->setIva($prpSupService->getIva());
  5130.         $service->setOriginalPrice($prpSupService->getOriginalPrice());
  5131.         $service->setOriginalIva($prpSupService->getOriginalIva());
  5132.         $service->setSupplierId($prpSupService->getSupplierId());
  5133.         $service->setOpCommission($prpSupService->getOpCommission());
  5134.         $service->setOpOver($prpSupService->getOpOver());
  5135.         $service->setOpIva($prpSupService->getOpIva());
  5136.         $service->setDateBlockLimit($prpSupService->getDateBlockLimit());
  5137.         $service->setDateInAt($prpSupService->getDateInAt());
  5138.         $service->setDateOutAt($prpSupService->getDateOutAt());
  5139.         $service->setHour($prpSupService->getHour());
  5140.         $service->setCurrency($prpSupService->getCurrency());
  5141.         $service->setOriginalopIva($prpSupService->getOriginalopIva());
  5142.         $service->setCreatedId($user_id);
  5143.         $service->setCreatedAt(new \DateTime());
  5144.         $service->setUpdatedId($user_id);
  5145.         $service->setUpdatedAt(new \DateTime());
  5146.         $service->setControlId($prpSupService->getControlId());
  5147.         $service->setActivityId($prpSupService->getActivityId());
  5148.         $service->setAssistantId($prpSupService->getAssistantId());
  5149.         $service->setBreakdown($prpSupService->getBreakdown());
  5150.         $service->setDestinationId($prpSupService->getDestinationId());
  5151.         $service->setDirectPayment($prpSupService->getDirectPayment());
  5152.         $service->setIdeaId($prpSupService->getIdeaId());
  5153.         $service->setPreCommission($prpSupService->getPreCommission());
  5154.         $service->setPreIva($prpSupService->getPreIva());
  5155.         $service->setProposalId($prpSupService->getProposalId());
  5156.         $service->setServiceCatId($prpSupService->getServiceCatId());
  5157.         $service->setServiceCatName($prpSupService->getServiceCatName());
  5158.         $service->setServiceId($prpSupService->getServiceId());
  5159.         $service->setServiceIdFather($prpSupService->getServiceIdFather());
  5160.         $service->setStatus('Pending');
  5161.         $service->setStatusinternal($prpSupService->getStatusinternal());
  5163.         $em->persist($service);
  5164.         $em->flush();
  5166.         $prpSupCtrl = $em->getRepository(ProposalSupplierControl::class)->findOneById($prpSupService->getControlId());
  5168.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  5169.             'id' => $prpSupCtrl->getControlDestinationId(),
  5170.             '_fragment' => $id
  5171.         ));
  5172.     }
  5174.     /**
  5175.      * @Route("proposal/destination/services/duplicatesupplier/{id}", name="proposal_destination_duplicate_supplier")
  5176.      */
  5177.     public function duplicateSupplierAction($id, Request $request) {
  5179.         $newSup = $request->request->get('dupliSupplierId');
  5180.         $em = $this->getDoctrine()->getManager();
  5182.         /* Obtengo usuario logueado */
  5183.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  5184.         $user_id = $user_logueado->getId();
  5186.         $prpSupServices = $em->getRepository(ProposalSupplierServices::class)->findByControlId($id);
  5187.         $prpSupControl = $em->getRepository(ProposalSupplierControl::class)->findOneById($id);
  5188.         $origenSup = $prpSupControl->getSupplierId();
  5190.         //Verificamos si Proveedor origen y destino son el mismo
  5191.         if ($newSup != $origenSup){
  5192.             //Verificamos si ya existe el control del Proveedor destino
  5193.             $prevPrpSupControl = $em->getRepository(ProposalSupplierControl::class)->findBy(
  5194.                 array('proposalId'=>$prpSupControl->getProposalId(),
  5195.                       'destinoId'=>$prpSupControl->getDestinoId(),
  5196.                       'supplierId'=>$newSup));
  5198.             if (empty($prevPrpSupControl)){
  5199.                 // Proveedor origen y destino son distintos, se crea una nueva entidad de control
  5200.                 $newSupControl = new ProposalSupplierControl();
  5201.             } else {
  5202.                 // El Proveedor destino ya tiene un controlador
  5203.                 $newSupControl = $prevPrpSupControl[0];
  5204.             }
  5206.             $newSupControl->setActivityId($prpSupControl->getActivityId());
  5207.             $newSupControl->setControlDestinationId($prpSupControl->getControlDestinationId());
  5208.             $newSupControl->setDateBlockLimit($prpSupControl->getDateBlockLimit());
  5209.             $newSupControl->setDestinoId($prpSupControl->getDestinoId());
  5210.             $newSupControl->setDisabled($prpSupControl->getDisabled());
  5211.             $newSupControl->setIdeaId($prpSupControl->getIdeaId());
  5212.             $newSupControl->setProposalId($prpSupControl->getProposalId());
  5213.             $newSupControl->setRank($prpSupControl->getRank());
  5214.             $newSupControl->setStatus($prpSupControl->getStatus());
  5215.             $newSupControl->setSupplierId($newSup);
  5217.             $em->persist($newSupControl);
  5218.             $em->flush();
  5219.         } else {
  5220.             $newSupControl = $prpSupControl;
  5221.         }
  5223.         // Duplicamos los servicios
  5224.         foreach ($prpSupServices as $item){
  5225.             $service = new ProposalSupplierServices();
  5226.             $service->setName($item->getName());
  5227.             $service->setRank($item->getRank());
  5228.             $service->setPrice($item->getPrice());
  5229.             $service->setUnits($item->getUnits());
  5230.             $service->setPax($item->getPax());
  5231.             $service->setCommission($item->getCommission());
  5232.             $service->setOver($item->getOver());
  5233.             $service->setIva($item->getIva());
  5234.             $service->setOriginalPrice($item->getOriginalPrice());
  5235.             $service->setOriginalIva($item->getOriginalIva());
  5236.             $service->setSupplierId($newSup);
  5237.             $service->setOpCommission($item->getOpCommission());
  5238.             $service->setOpOver($item->getOpOver());
  5239.             $service->setOpIva($item->getOpIva());
  5240.             $service->setDateBlockLimit($item->getDateBlockLimit());
  5241.             $service->setDateInAt($item->getDateInAt());
  5242.             $service->setDateOutAt($item->getDateOutAt());
  5243.             $service->setHour($item->getHour());
  5244.             $service->setCurrency($item->getCurrency());
  5245.             $service->setOriginalopIva($item->getOriginalopIva());
  5246.             $service->setCreatedId($user_id);
  5247.             $service->setCreatedAt(new \DateTime());
  5248.             $service->setUpdatedId($user_id);
  5249.             $service->setUpdatedAt(new \DateTime());
  5250.             $service->setControlId($newSupControl->getId());
  5251.             $service->setActivityId($item->getActivityId());
  5252.             $service->setAssistantId($item->getAssistantId());
  5253.             $service->setBreakdown($item->getBreakdown());
  5254.             $service->setDestinationId($item->getDestinationId());
  5255.             $service->setDirectPayment($item->getDirectPayment());
  5256.             $service->setIdeaId($item->getIdeaId());
  5257.             $service->setPreCommission($item->getPreCommission());
  5258.             $service->setPreIva($item->getPreIva());
  5259.             $service->setProposalId($item->getProposalId());
  5260.             $service->setServiceCatId($item->getServiceCatId());
  5261.             $service->setServiceCatName($item->getServiceCatName());
  5262.             $service->setServiceId($item->getServiceId());
  5263.             $service->setServiceIdFather($item->getServiceIdFather());
  5264.             $service->setStatus('Pending');
  5265.             $service->setStatusinternal($item->getStatusinternal());
  5267.             $em->persist($service);
  5268.             $em->flush();
  5269.         }
  5271.         $prpSupCtrl = $em->getRepository(ProposalSupplierControl::class)->findOneById($id);
  5273.         return $this->redirectToRoute('proposal_destination_supplier_view', array(
  5274.             'id' => $prpSupCtrl->getControlDestinationId(),
  5275.         ));
  5276.     }
  5279.     /**
  5280.      * @Route("proposal/destination/services/comissionall", name="proposal_destination_comission_all")
  5281.      */
  5282.     public function comissionAllAction(Request $request){
  5284.         $proposalSupplierControlId = $request->request->get('proposalSupplierControlId');
  5285.         $opCommissionAll = $request->request->get('opCommissionAll');
  5286.         $commissionAll = $request->request->get('commissionAll');
  5288.         $em = $this->getDoctrine()->getManager();
  5289.         $prpSupControl = $em->getRepository(ProposalSupplierControl::class)->findOneById($proposalSupplierControlId);
  5290.         $prpSupServices = $em->getRepository(ProposalSupplierServices::class)->findByControlId($proposalSupplierControlId);
  5291.         $idPrpSupServices = null;
  5293.         foreach ($prpSupServices as $item){
  5294.             $item->setOpCommission($opCommissionAll);
  5295.             $item->setCommission($commissionAll);
  5296.             $idPrpSupServices = $item->getId();
  5298.             $em->persist($item);
  5299.             $em->flush();
  5301.             $prpSupServicesCosts = $em->getRepository(ProposalSupplierServicesCostsClient::class)->findOneByServiceIdProposal($item->getId());
  5302.             if (!empty($prpSupServicesCosts)){
  5303.                 $em->remove($prpSupServicesCosts);
  5304.                 $em->flush();
  5305.             }
  5307.             if (!empty($idPrpSupServices)){
  5308.                 $parameters = array(
  5309.                     'idPrpSupServices' => '%'.$idPrpSupServices.'%',
  5310.                 );
  5311.                 $dql = 'SELECT i
  5312.                     FROM EventsBundle:ProposalSupplierServicesCosts i
  5313.                     WHERE i.servicesId LIKE :idPrpSupServices
  5314.                     ORDER BY i.id ASC';
  5315.                 $query = $em->createQuery($dql)->setParameters($parameters);
  5316.                 $proposalSupplierServicesCosts = $query->getResult();
  5318.                 // Si el servicio se encontraba dentro de $proposalSupplierServicesCosts es porque el servicio se encontraba
  5319.                 // confirmado y dentro de una proforma, se deben sacar para evitar error en el apartado de proveedores
  5320.                 foreach($proposalSupplierServicesCosts as $prpSupSrvCst){
  5321.                     $prpSupSrvCst->setServicesId('0');
  5323.                     $em->persist($prpSupSrvCst);
  5324.                     $em->flush();
  5325.                 }
  5326.             }
  5327.         }
  5329.         $fragmento = empty($prpSupServices) ? null : $prpSupServices[0]->getId();
  5331.         return $this->redirectToRoute('proposal_destination_supplier_view',
  5332.             array(
  5333.                 'id' => $prpSupControl->getControlDestinationId(),
  5334.                 '_fragment' => $fragmento
  5335.             ));
  5336.     }
  5338.     private function sendTelegram ( $id, $text )
  5339.     {
  5340.         $em = $this->getDoctrine()->getManager();
  5341.         $telegUser = $em->getRepository(MdvTelegramUser::class)->findOneByUserId($id);
  5343.         if (empty($telegUser)){return true;}
  5345.         $parameters = array(
  5346.             'chat_id' => $telegUser->getChatId(),
  5347.             'text' => $text,
  5348.         );
  5350.         $bot_token = $telegUser->getBotToken();
  5351.         $url = "https://api.telegram.org/bot$bot_token/sendMessage";
  5353.         if (!$curl = curl_init()){
  5354.             exit();
  5355.         }
  5357.         curl_setopt($curl,CURLOPT_POST,true);
  5358.         curl_setopt($curl,CURLOPT_POSTFIELDS,$parameters);
  5359.         curl_setopt($curl,CURLOPT_URL,$url);
  5360.         curl_setopt($curl,CURLOPT_RETURNTRANSFER,true);
  5361.         $output = curl_exec($curl);
  5362.         curl_close($curl);
  5364.         return true;
  5365.     }
  5366. }