src/Controller/HomeController.php line 34

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Service\HubspotWebClientService;
  6. use App\Utils\HubspotTool;
  7. use HubSpot\Client\Crm\Companies\ApiException;
  8. use Symfony\Component\HttpFoundation\JsonResponse;
  9. use Twig\Environment;
  10. use App\Service\HubspotService;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use Symfony\Component\HttpFoundation\Response;
  13. use Symfony\Component\Routing\Annotation\Route;
  14. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  17. class HomeController extends AbstractController
  18. {
  20.     private HubspotService $hubspotService;
  21.     private \Twig\Loader\LoaderInterface $loader;
  22.     private HubspotWebClientService $hubspotWebClientService;
  23.     private string $current_env;
  26.     public function __construct(Environment $twig, HubspotService $hubspotService, HubspotWebClientService $hubspotWebClientService)
  27.     {
  28.         $this->loader = $twig->getLoader();
  29.         $this->hubspotService = $hubspotService;
  30.         $this->hubspotWebClientService = $hubspotWebClientService;
  31.     }
  33.     #[Route('/', name: 'home')]
  34.     public function index(): Response
  35.     {
  36.         $this->denyAccessUnlessGranted('ROLE_USER');
  37.         return $this->render('index.html.twig');
  38.     }
  40.     #[Route(
  41.         '/ajax-search-companies',
  42.         name: 'ajax_search_companies',
  43.         options: [
  44.             'expose' => true
  45.         ]
  46.     )]
  47.     public function ajaxSearchCompanies(Request $request): JsonResponse
  48.     {
  49.         $this->denyAccessUnlessGranted('ROLE_USER');
  50.         $searchTerm = $request->request->get('q');
  51.         $res = $this->hubspotService->searchCompanies($searchTerm, $request->request->get('page') ?? 1);
  53.         $response = new JsonResponse();
  54.         $response->setData($res);
  55.         return $response;
  56.     }
  58.     #[Route(
  59.         '/ajax-create-dashboard',
  60.         name: 'ajax_create_dashboard',
  61.         options: [
  62.             'expose' => true
  63.         ]
  64.     )]
  65.     public function ajaxCreateDashboard(Request $request): JsonResponse
  66.     {
  67.         $this->denyAccessUnlessGranted('ROLE_USER');
  68.         $res['success'] = false;
  69.         $dashboard = [];
  71.         $companies_id = json_decode($request->request->get('companies_id'));
  72.         if (empty($companies_id)) {
  73.             $res['success'] = false;
  74.             $res['error_msg'] = 'Please select at least one company';
  75.         } else {
  76.             $res['selected_compagnies'] = $companies_id;
  77.             $response = $this->hubspotWebClientService->getDashboard();
  78.             if ($response['success'] == false) {
  79.                 $res['success'] = false;
  80.                 $res['error_msg'] = is_array($response['error']) ? implode(', ', $response['error']) : $response['error'];
  81.             } elseif (empty($response['data'])) {
  82.                 $res['success'] = false;
  83.                 $res['error_msg'] = 'Empty result';
  84.             } else {
  85.                 $res['success'] = true;
  86.                 $dashboard = $response['data'];
  87.             }
  88.         }
  90.         if (!$res['success'] || empty($dashboard)) {
  91.             return $this->returnAjaxResponse($res);
  92.         }
  93.         // echo dashboard modele
  94. //        echo (json_encode($dashboard));
  95. //        die;
  96. //        dd($dashboard);
  97.         //dump($dashboard);
  99.         // Retrieve all owners
  100.         //$owners = $this->hubspotService->getHsClient()->crm()->owners()->getAll();
  101.         $owners = [];
  102.         $tmp_owners = $this->hubspotService->getHsClientV1()->owners()->all()->getData();
  103.         foreach ($tmp_owners as $owner) {
  104.             $owners[$owner->ownerId] = $owner;
  105.         }
  106.         unset($tmp_owners);
  108.         // Create a new dashboard
  109.         $new_dashboard = new \stdClass();
  110.         $new_dashboard->type = $dashboard->type;
  112.         $widgets = $dashboard->widgets;
  113.         $new_widgets = [];
  115.         $companies = [];
  116.         $company_names = [];
  117.         $main_company = null;
  118.         foreach($companies_id as $key => $company_id) {
  119.             try {
  120.                 $companies[] = $company = $this->hubspotService->getHsClientV1()->companies()->getById((int)$company_id);
  121.                 //echo json_encode($company);die; // display company properties
  122.                 $company_names[] = $company->getData()->properties->name->value;
  124.                 if ($key == 0) {
  125.                     $main_company = $company;
  126.                 }
  127. //                $company = $this->hubspotService->getHsClient()->crm()->companies()->basicApi()->getById((int)$company_id);
  128. //                $company_names[] = $company->getProperties()['name'];
  129.             } catch (ApiException $e) {
  130.                 $res['success'] = false;
  131.                 $res['error_msg'] = 'Exception when trying to get company data using => ' .
  132.                 ' hubspotService->getHsClient()->crm()->companies()->basicApi()->getById()';
  134.                 return $this->returnAjaxResponse($res);
  135.             }
  137.         }
  139.         $new_dashboard->name = join(', ', $company_names) . ' - ' . $dashboard->name;
  140.         $new_dashboard->description = "This dashboard has been created by our internal software here (futur link). <br><br>Compagnies that have been selected : " . join(', ', $company_names);
  141.         $new_dashboard->showDescription = true;
  143.         $this->current_env = $this->getParameter('kernel.environment');
  145.         foreach($widgets as $widget_id => $widget) {
  146.             $new_widget = new \stdClass();
  147.             $new_widget->report = new \stdClass();
  148.             //$new_widget->report = $widget->report;
  149.             //unset($new_widget->report->id);
  151.             $new_widget->report->name = $widget->report->name;
  152.             $new_widget->report->chartType = $widget->report->chartType;
  153.             $new_widget->report->permissionLevel = $widget->report->permissionLevel;
  154.             $new_widget->report->legacyReport = $widget->report->legacyReport;
  156.             if (isset($widget->report->config)) {
  157.                 $new_widget->report->config = $widget->report->config;
  159.                 if (isset($widget->report->config->crossObject->reportId)) {
  160.                     //unset($new_widget->report->config->crossObject->reportId);
  161.                 }
  163.                 if (isset($widget->report->config->crossObject->dashboardReportId)) {
  164.                     //unset($new_widget->report->config->crossObject->dashboardReportId);
  165.                 }
  168.                 // Account management team
  169.                 //85598279 Overall Strategy
  170.                 //Text to generate
  171.                 //if ($widget->reportId == '85598279') {
  172.                 // 88476282 sandbox
  173.                 // 83467923 prod
  174.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('account_management_team', $this->current_env)) {
  175.                     $fields = [
  176.                         'widget_name' => '',
  177.                         'Account Existing Segment' => ['type' => 'text', 'field' => 'account_existing_segment'],
  178.                         'Account Target Segment' => ['type' => 'text', 'field' => 'account_target_segment'],
  179.                         'Account status' => ['type' => 'text', 'field' => 'account_status'],
  180.                         'Account size' => ['type' => 'text', 'field' => 'account_size'],
  181.                         'Account Priority Level' => ['type' => 'text', 'field' => 'account_priority_level'],
  182.                         'Sector' => ['type' => 'text', 'field' => 'sector'],
  183.                         'Master Account Owner' => ['type' => 'owner', 'field' => 'master_account_owner'],
  184.                         'Master Account Owner 2' => ['type' => 'owner', 'field' => 'master_account_owner_2'],
  185.                         'Master Account Owner 3' => ['type' => 'owner', 'field' => 'master_account_owner_3'],
  186.                         'Delegate 1' => ['type' => 'owner', 'field' => 'delegate_owner'],
  187.                         'Delegate 1 perimeter' => ['type' => 'text', 'field' => 'delegate_1___perimeter'],
  188.                         'Delegate 2' => ['type' => 'owner', 'field' => 'delegate_2'],
  189.                         'Delegate 2 perimeter' => ['type' => 'text', 'field' => 'delegate_2___perimeter'],
  190.                         'Delegate 3' => ['type' => 'owner', 'field' => 'delegate_3'],
  191.                         'Delegate 3 perimeter' => ['type' => 'text', 'field' => 'delegate_3___perimeter'],
  192.                         'Delegate 4' => ['type' => 'owner', 'field' => 'delegate_4'],
  193.                         'Delegate 4 perimeter' => ['type' => 'text', 'field' => 'delegate_4___perimeter'],
  194.                         'Delegate 5' => ['type' => 'owner', 'field' => 'delegate_5'],
  195.                         'Delegate 5 perimeter' => ['type' => 'text', 'field' => 'delegate_5___perimeter'],
  196.                         'Delegate 6' => ['type' => 'owner', 'field' => 'delegate_6'],
  197.                         'Delegate 6 perimeter' => ['type' => 'text', 'field' => 'delegate_6___perimeter'],
  198.                         'Delegate 7' => ['type' => 'owner', 'field' => 'delegate_7'],
  199.                         'Delegate 7 perimeter' => ['type' => 'text', 'field' => 'delegate_7___perimeter'],
  200.                         'Delegate 8' => ['type' => 'owner', 'field' => 'delegate_8'],
  201.                         'Delegate 8 perimeter' => ['type' => 'text', 'field' => 'delegate_8___perimeter'],
  202.                         'Delegate 9' => ['type' => 'owner', 'field' => 'delegate_9'],
  203.                         'Delegate 9 perimeter' => ['type' => 'text', 'field' => 'delegate_9___perimeter'],
  204.                         'Delegate 10' => ['type' => 'owner', 'field' => 'delegate_10'],
  205.                         'Delegate 10 perimeter' => ['type' => 'text', 'field' => 'delegate_10___perimeter'],
  206.                     ];
  207.                     $new_widget->report->config->noteText = $this->setTextWidget($fields, $main_company, $owners);
  208.                 }
  210.                 // Sectorand account context widget
  211.                 // 88476283 sandbox
  212.                 // 83737402 prod
  213.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('sectorand_account_context', $this->current_env)) {
  214.                     $fields = [
  215.                         'widget_name' => 'Sectorand account context',
  216.                         'Sector / industry context and trends' => ['type' => 'text', 'field' => 'sector___industry_context_and_trends_'],
  217.                         'Account\'s context, vision, objective, projects' => ['type' => 'text', 'field' => 'account_s_context__vision__objectives__projects_'],
  218.                     ];
  219.                     $new_widget->report->config->noteText = $this->setTextWidget($fields, $main_company, $owners);
  220.                 }
  222.                 // AccountManagement Team approach
  223.                 // 88476284 sandbox
  224.                 // 83737466 prod
  225.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('account_management_team_approach', $this->current_env)) {
  226.                     $fields = [
  227.                         'widget_name' => 'AccountManagement Team approach based on account\'s context',
  228.                         'Sia Partners inbound strategy' => ['type' => 'text', 'field' => 'sia_partners__inbound_strategy'],
  229.                         'Sia Partners outbound strategy' => ['type' => 'text', 'field' => 'sia_partners__outbound_strategy'],
  230.                     ];
  231.                     $new_widget->report->config->noteText = $this->setTextWidget($fields, $main_company, $owners);
  232.                 }
  234.                 //85599214 Deals won this year (VS previous year)
  235.                 //if ($widget->reportId == '85599214') {
  236.                 // 88476285 sandbox
  237.                 // 83467924 prod
  238.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('deal_won_this_year_vs_previous_year', $this->current_env)) {
  239.                     $new_widget->report->config->filters->custom[1] = [
  240.                         'operator' => 'IN',
  241.                         'property' => 'associations.company',
  242.                         'values' => $companies_id
  243.                     ];
  244.                 }
  246.                 // Deals won this year by company / subsidiary
  247.                 // 88476286 sandbox
  248.                 // 85751594 prod
  249.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('deals_won_this_year_by_company_subsidiary', $this->current_env)) {
  250.                     $new_widget->report->config->filters->custom[1] = [
  251.                         'operator' => 'IN',
  252.                         'property' => 'associations.company',
  253.                         'values' => $companies_id
  254.                     ];
  255.                 }
  257.                 // Amount in each company / subsidiary by type of opportunity (in €) V2
  258.                 // 88476287 sandbox
  259.                 // 85752156 prod
  260.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('amount_in_each_company_subsidiary_by_type_of_opportunity', $this->current_env)) {
  261.                     $new_widget->report->config->filters->custom[1] = [
  262.                         'operator' => 'IN',
  263.                         'property' => 'associations.company',
  264.                         'values' => $companies_id
  265.                     ];
  266.                 }
  268.                 // Amount in each company / subsidiary by extension
  269.                 // 88476288 sandbox
  270.                 // 85752222 prod
  271.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('amount_in_each_company_subsidiary_by_extension', $this->current_env)) {
  272.                     $new_widget->report->config->filters->custom[1] = [
  273.                         'operator' => 'IN',
  274.                         'property' => 'associations.company',
  275.                         'values' => $companies_id
  276.                     ];
  277.                 }
  279.                 // Last semester retrospective - Financials - Texte
  280.                 // 88476293 sandbox
  281.                 // 83741117 prod
  282.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('financials_last_semester_retrospective', $this->current_env)) {
  283.                     $fields = [
  284.                         'widget_name' => 'Last semester retrospective - Financials',
  285.                         'Last semester produced' => ['type' => 'text', 'field' => 'financials___last_semester_produced_'],
  286.                         'Cross-sell by bu' => ['type' => 'text', 'field' => 'financials___cross_sell_by_bu_'],
  287.                         'Breakdown by geography' => ['type' => 'text', 'field' => 'financials___breakdown_by_geography_'],
  288.                         'AverageSow / work order value' => ['type' => 'text', 'field' => 'financials___average_sow___work_order_value_'],
  289.                         'Average daily rates' => ['type' => 'text', 'field' => 'financials___average_daily_rates_'],
  290.                     ];
  291.                     $new_widget->report->config->noteText = $this->setTextWidget($fields, $main_company, $owners);
  292.                 }
  294.                 // Last semester retrospective - People - texte
  295.                 // 88476294 sandbox
  296.                 // 83741258 prod
  297.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('people_last_semester_retrospective', $this->current_env)) {
  298.                     $fields = [
  299.                         'widget_name' => 'Last semester retrospective - People',
  300.                         'Total # of resources' => ['type' => 'text', 'field' => 'people___total___of_ressources'],
  301.                         'New adds or roll-offs' => ['type' => 'text', 'field' => 'people___new_adds_or_roll_offs'],
  302.                         'Notable highlights / lowlights' => ['type' => 'text', 'field' => 'people___notable_highlights___lowlights'],
  303.                         'Managing index' => ['type' => 'text', 'field' => 'people___managing_index'],
  304.                         'Specific talents needs' => ['type' => 'text', 'field' => 'people___specific_talents_needs'],
  305.                     ];
  306.                     $new_widget->report->config->noteText = $this->setTextWidget($fields, $main_company, $owners);
  307.                 }
  309.                 // Last semester retrospective - Key Wins and Updates
  310.                 // 88476296 sandbox
  311.                 // 83741454 prod
  312.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('last_semester_retrospective_key_wins_and_pdates', $this->current_env)) {
  313.                     $new_widget->report->config->filters->custom[0] = [
  314.                         'operator' => 'IN',
  315.                         'property' => 'associations.company',
  316.                         'values' => $companies_id
  317.                     ];
  318.                 }
  320.                 // Last semester retrospective - Key Losses and Key Learnings
  321.                 // 88476297 sandbox
  322.                 // 83741523 prod
  323.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('last_semester_retrospective_key_losses_and_key_learnings', $this->current_env)) {
  324.                     $new_widget->report->config->filters->custom[0] = [
  325.                         'operator' => 'IN',
  326.                         'property' => 'associations.company',
  327.                         'values' => $companies_id
  328.                     ];
  329.                 }
  331.                 // Next semester targets - Financial Goals
  332.                 // 88476298 sandbox
  333.                 // 83741641 prod
  334.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('financials_goals_next_semester_targets', $this->current_env)) {
  335.                     $fields = [
  336.                         'widget_name' => 'Next semester targets - Financial Goals',
  337.                         'Next semester forecast' => ['type' => 'text', 'field' => 'financial_goals___next_semester_forecast_'],
  338.                         'Existing assigments / extension' => ['type' => 'text', 'field' => 'financial_goals___existing_assigments_extension_'],
  339.                         'New opportunities' => ['type' => 'text', 'field' => 'financial_goals___new_opportunities_'],
  340.                         'Next semester growth target' => ['type' => 'text', 'field' => 'financial_goals___next_semester_growth_target_'],
  341.                         'Corrective actions' => ['type' => 'text', 'field' => 'financial_goals___corrective_actions_'],
  342.                     ];
  343.                     $new_widget->report->config->noteText = $this->setTextWidget($fields, $main_company, $owners);
  344.                 }
  346.                 // Next semester targets - Cross-sell Objectives
  347.                 // 88476299 sandbox
  348.                 // 83741659 prod
  349.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('cross_sell_objectives_next_semester_targets', $this->current_env)) {
  350.                     $fields = [
  351.                         'widget_name' => 'Next semester targets - Financial Goals',
  352.                         'Cross-BU' => ['type' => 'text', 'field' => 'cross_sell_objectives___cross_bu'],
  353.                         'Cross-location' => ['type' => 'text', 'field' => 'cross_sell_objectives___cross_location_']
  354.                     ];
  355.                     $new_widget->report->config->noteText = $this->setTextWidget($fields, $main_company, $owners);
  356.                 }
  358.                 // New opportunities - Deals in the pipe by company / subsidiary
  359.                 // 88476300 sandbox
  360.                 // 85752894 prod
  361.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('new_opportunities_deals_in_the_pipe_by_company_subsidiary', $this->current_env)) {
  362.                     $new_widget->report->config->filters->custom[1] = [
  363.                         'operator' => 'IN',
  364.                         'property' => 'associations.company',
  365.                         'values' => $companies_id
  366.                     ];
  367.                 }
  369.                 // Numbers of deals by company / subsidiary
  370.                 // 88476303 sandbox
  371.                 // 86486711 prod
  372.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('numbers_of_deals_by_company_subsidiary', $this->current_env)) {
  373.                     $new_widget->report->config->filters->custom[0] = [
  374.                         'operator' => 'IN',
  375.                         'property' => 'associations.company',
  376.                         'values' => $companies_id
  377.                     ];
  378.                 }
  380.                 // Deal amount / count of deals by team member
  381.                 // 88476304 sandbox
  382.                 // 83467930 prod
  383.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('deal_amount_count_of_deals_by_team_member', $this->current_env)) {
  384.                     $new_widget->report->config->filters->custom[0] = [
  385.                         'operator' => 'IN',
  386.                         'property' => 'associations.company',
  387.                         'values' => $companies_id
  388.                     ];
  389.                 }
  391.             }
  393.             if (isset($widget->report->reportDefinition)) {
  394.                 $new_widget->report->reportDefinition = $widget->report->reportDefinition;
  396.                 // Account Relationship Level
  397.                 // 88476309 sandbox
  398.                 // 85755923 prod
  399.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('account_relationship_level', $this->current_env)) {
  400.                     $new_widget->report->reportDefinition->filtering->groups[0]->filters[0]->filter->operation->values = $companies_id;
  401.                 }
  403.                 // Monthly Activity Board - By company
  404.                 // 88476305 sandbox
  405.                 // 83467935 prod
  406.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('monthly_activity_board_by_company', $this->current_env)) {
  407.                     $new_widget->report->reportDefinition->filtering->groups[1]->filters[0]->filter->operation->values = $companies_id;
  408.                 }
  410.                 // Email Activities this year - By company
  411.                 // 88476306 sandbox
  412.                 // 83467936 prod
  413.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('email_activities_this_year_by_company', $this->current_env)) {
  414.                     $new_widget->report->reportDefinition->filtering->groups[1]->filters[0]->filter->operation->values = $companies_id;
  415.                 }
  417.                 // Call Activities this year
  418.                 // 88476308 sandbox
  419.                 // 83467937 prod
  420.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('call_activities_this_year', $this->current_env)) {
  421.                     $new_widget->report->reportDefinition->filtering->groups[1]->filters[0]->filter->operation->values = $companies_id;
  422.                 }
  424.                 // Meeting Activities this year
  425.                 // 88476308 sandbox
  426.                 // 83467938 prod
  427.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('meeting_activities_this_year', $this->current_env)) {
  428.                     $new_widget->report->reportDefinition->filtering->groups[1]->filters[0]->filter->operation->values = $companies_id;
  429.                 }
  431.                 // Financials - BU Revenue Composition
  432.                 // 88476289 sandbox
  433.                 // 85303044 prod
  434.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('financials_bu_revenue_composition', $this->current_env)) {
  435.                     $new_widget->report->reportDefinition->filtering->groups[1]->filters[0]->filter->operation->values = $companies_id;
  436.                 }
  438.                 // Financials - BU Cross-sell revenue Composition
  439.                 // 88476290 sandbox
  440.                 // 85344683 prod
  441.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('financials_bu_cross_sell_revenue_composition', $this->current_env)) {
  442.                     $new_widget->report->reportDefinition->filtering->groups[1]->filters[0]->filter->operation->values = $companies_id;
  443.                 }
  445.                 // Financials - Hub/BL revenue Composition
  446.                 // 88476291 sandbox
  447.                 // 85345707 prod
  448.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('financials_hub_bl_revenue_composition', $this->current_env)) {
  449.                     $new_widget->report->reportDefinition->filtering->groups[1]->filters[0]->filter->operation->values = $companies_id;
  450.                 }
  452.                 // Financials - Market Cross-sell revenue Composition
  453.                 // 88476292 sandbox
  454.                 // 85345038 prod
  455.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('financials_market_cross_sell_revenue_composition', $this->current_env)) {
  456.                     $new_widget->report->reportDefinition->filtering->groups[1]->filters[0]->filter->operation->values = $companies_id;
  457.                 }
  459.                 // Last semester retrospective - Financials - Graph
  460.                 // 88476295 sandbox
  461.                 // 85302032 prod
  462.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('financials_last_semester_retrospective_graph', $this->current_env)) {
  463.                     $new_widget->report->reportDefinition->filtering->groups[0]->filters[0]->filter->operation->values = $companies_id;
  464.                 }
  466.                 // Approach for farmed department / subsidiary 1 & 2
  467.                 // 88476301 sandbox
  468.                 // 83492168 prod
  469.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('approach_for_farmed_department_subsidiary_1_&_2', $this->current_env)) {
  470.                     $new_widget->report->reportDefinition->filtering->groups[0]->filters[0]->filter->operation->values = $companies_id;
  471.                 }
  473.                 // Approach for hunted department / subsidiary 1&2
  474.                 // 88476302 sandbox
  475.                 // 83742763 prod
  476.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('approach_for_hunted_department_subsidiary_1_&_2', $this->current_env)) {
  477.                     $new_widget->report->reportDefinition->filtering->groups[0]->filters[0]->filter->operation->values = $companies_id;
  478.                 }
  480.                 // Numbers of contacts by company / subsidiary
  481.                 // 88476310 sandbox
  482.                 // 86486896 prod
  483.                 if ((int)$widget->reportId === HubspotTool::getReportIdByNameAndEnv('numbers_of_contacts_by_company_subsidiary', $this->current_env)) {
  484.                     $new_widget->report->reportDefinition->filtering->groups[0]->filters[0]->filter->operation->values = $companies_id;
  485.                 }
  487.                 //85699234 Opened or won deals with no attachment
  488. //                if ($widget->reportId == '85699234') {
  489. //                    $filters = [];
  490. //                    $id = 1000002;
  491. //                    foreach($companies_id as $company) {
  492. //                        $filters[] = [
  493. //                            'id' => $id++,
  494. //                            'field' => [
  495. //                                'name' => 'hs_object_id',
  496. //                                'table' => 'COMPANY',
  497. //                                'type' => 'number'
  498. //                            ],
  499. //                            'filter' => [
  500. //                                'filterId' => null,
  501. //                                'filterType' => 'PROPERTY',
  502. //                                'property' => 'hs_object_id',
  503. //                                'operation' => [
  504. //                                    "defaultValue" => null,
  505. //                                    "includeObjectsWithNoValueSet" => false,
  506. //                                    "operationType" => "number",
  507. //                                    "operator" => "IS_EQUAL_TO",
  508. //                                    "operatorName" => "IS_EQUAL_TO",
  509. //                                    "propertyType" => "number",
  510. //                                    "value" => $company
  511. //                                ]
  512. //                            ]
  513. //                        ];
  514. //                    }
  515. //                    $new_widget->report->reportDefinition->filtering->groups[2]->condition = 'OR';
  516. //                    $new_widget->report->reportDefinition->filtering->groups[2]->filters = $filters;
  517. //                    $new_widget->report->reportDefinition->filtering->groups[3]->filters[0]->id = $id;
  518. //                }
  519.             }
  521.             $new_widget->report->displayParams = $widget->report->displayParams;
  522.             $new_widget->report->active = $widget->report->active;
  523.             $new_widget->report->customized = $widget->report->customized;
  524.             $new_widget->layout = $widget->layout;
  525.             //unset($new_widget->report->displayParams->origin);
  526.             $new_widgets[] = $new_widget;
  527.         }
  529.         $new_dashboard->widgets = $new_widgets;
  530.         $new_dashboard->ownerId = $this->getParameter('app.hubspot.hs_dashboard_owner_id');
  532.         $new_dashboard->dashboardPermissionConfig = new \stdClass();
  533.         $new_dashboard->dashboardPermissionConfig->accessClassification = "EVERYONE";
  534.         $new_dashboard->dashboardPermissionConfig->permissionLevel = "EDIT";
  535.         $new_dashboard->dashboardPermissionConfig->permissionGrants = [["userSetType" => "API_ACCESS"]];
  536.         //echo(json_encode($new_dashboard));die;
  537.         $created_dashboard = $this->hubspotWebClientService->createNewDashboard(json_encode($new_dashboard));
  538.         //dd($created_dashboard);
  539.         if (!isset($created_dashboard['success']) || $created_dashboard['success'] != true) {
  540.             $res['success'] = false;
  541.             $res['error_msg'] = !empty($created_dashboard['error']) ? $created_dashboard['error'] : 'Insert new dashboard to hubspot failed';
  543.             return $this->returnAjaxResponse($res);
  544.         }
  546.         // MANAGE THE CASE IF IF WE REACHED THE MAXIMUM COUNT OF DASHBOARD
  547. //        do {
  548. //            $retry = false;
  549. //            $tooMany = false;
  550. //
  551. //            try {
  552. //                $response = $this->hubspotWebClientService->createNewDashboard($new_dashboard);
  553. //
  554. //
  555. //                // Keep new dashboard id in case we run out of available dashboard
  556. //                $fp = fopen(Storage::disk('local')->path('data/dashboards.json'), "c+");
  557. //                if (flock($fp, LOCK_EX)) {
  558. //                    $dashboardList = json_decode(stream_get_contents($fp), true);
  559. //                    if (!$dashboardList) {
  560. //                        $dashboardList = [];
  561. //                    }
  562. //                    array_push($dashboardList, $createdDashboard->id);
  563. //
  564. //                    rewind($fp);
  565. //                    ftruncate($fp, 0);
  566. //                    fwrite($fp, json_encode($dashboardList));
  567. //                    flock($fp, LOCK_UN);
  568. //                }
  569. //                fclose($fp);
  570. //            } catch(BadRequest $e) {
  571. //                $response = $e->getResponse();
  572. //
  573. //                // If status code is 402, we hit the maximum number of dashboard allowed in the account
  574. //                if ($response->getStatusCode() == '402') {
  575. //                    $tooMany = true;
  576. //                } else {
  577. //                    // Send an email to admin on creation error
  578. //                    mail(config('hubspot.admin_email'), 'Sia Partners - Error creating dashboard', \GuzzleHttp\Psr7\Message::toString($e->getResponse()));
  579. //                    return json_encode(['success' => '0', 'error' => 'Error creating dashboard - err: 2 - ' . $newDashboard->name]);
  580. //                }
  581. //            }
  582. //
  583. //            // If we hit the too much dashboard error, we must delete some dashboards
  584. ////            if ($tooMany) {
  585. ////
  586. ////                // Retrieve list of previously created dashboard
  587. ////                $fp = fopen(Storage::disk('local')->path('data/dashboards.json'), "c+");
  588. ////                if (flock($fp, LOCK_EX)) {
  589. ////                    $dashboardList = json_decode(stream_get_contents($fp), true);
  590. ////
  591. ////                    // Delete oldest dashboard in list
  592. ////                    if ($dashboardList && count($dashboardList) > 0) {
  593. ////                        $dashboardId = array_shift($dashboardList);
  594. ////
  595. ////                        rewind($fp);
  596. ////                        ftruncate($fp, 0);
  597. ////                        fwrite($fp, json_encode($dashboardList));
  598. ////
  599. ////                        if (!empty($dashboardId)) {
  600. ////                            try {
  601. ////                                HubspotWebClient::request('DELETE', 'https://api.hubspot.com/dashboard/v2/dashboard/' . $dashboardId, [
  602. ////                                    'query' => [
  603. ////                                        'portalId' => config('hubspot.portal_id'),
  604. ////                                        'keepReport' => false
  605. ////                                    ]
  606. ////                                ]);
  607. ////                                $retry = true;
  608. ////                            } catch(BadRequest $e) {
  609. ////                                if ($e->getResponse()->getStatusCode() == '404') {
  610. ////                                    $retry = true;
  611. ////                                } else {
  612. ////                                    // Send an email to admin if we get an error deleting the dashboard
  613. ////                                    mail(config('hubspot.admin_email'), 'Sia Partners - Error delete dashboard ', \GuzzleHttp\Psr7\Message::toString($e->getResponse()));
  614. ////                                    return json_encode(['success' => '0', 'error' => 'Error creating dashboard - err: 3']);
  615. ////                                }
  616. ////                            } catch(\GuzzleHttp\Exception\RequestException $e) {
  617. ////                                mail(config('hubspot.admin_email'), 'Sia Partners - Error delete dashboard', \GuzzleHttp\Psr7\Message::toString($e->getResponse()));
  618. ////                                return json_encode(['success' => '0', 'error' => 'Error creating dashboard - err: 4']);
  619. ////                            }
  620. ////
  621. ////                        }
  622. ////                    }
  623. ////
  624. ////                    flock($fp, LOCK_UN);
  625. ////
  626. ////                    if (!$retry) {
  627. ////                        fclose($fp);
  628. ////                        mail(config('hubspot.admin_email'), 'Sia Partners - Error delete dashboard', 'No more dashboard to delete' );
  629. ////                        return json_encode(['success' => '0', 'error' => 'Error creating dashboard - err: 5']);
  630. ////                    }
  631. ////                }
  632. ////                fclose($fp);
  633. ////            }
  634. //            // We try to create the new dashboard after each delete
  635. //        } while($retry);
  637.         $res['success'] = true;
  638.         $res['msg'] = 'Dashboard created with success. Below the dashboard link =>';
  639.         $res['dashboard_url'] = 'https://app.hubspot.com/reports-dashboard/' . $this->getParameter('app.hubspot.hs_portal_id') . '/view/' . $created_dashboard['data']->id;
  640.         $res['data'] = $created_dashboard;
  642.         return $this->returnAjaxResponse($res);
  644.     }
  646.     private function returnAjaxResponse($data): JsonResponse
  647.     {
  648.         $response = new JsonResponse();
  649.         $response->setData($data);
  650.         return $response;
  651.     }
  653.     /**
  654.      * @param $fields
  655.      * @param $company
  656.      * @param $owners
  657.      * @return string
  658.      */
  659.     private function setTextWidget($fields, $company, $owners): string
  660.     {
  661.         $text = '';
  662.         if (empty($fields) || empty($company) || empty($owners)) {
  663.             return $text;
  664.         }
  665.         //foreach ($company as $company) {
  666. // echo company properties
  667. //            echo(json_encode($company));
  668. //            die;
  669.             $text = HubspotTool::setTextWidget($fields, $company, $owners);
  670.         //}
  671.         return $text;
  672.     }
  674. //    #[Route('/{path}')]
  675. //    public function root($path): Response
  676. //    {
  677. //        if ($this->loader->exists($path . '.html.twig')) {
  678. //             if ($path == '/' || $path == 'home') {
  679. //                 return $this->render('index.html.twig');
  680. //             }
  681. //            return $this->render($path . '.html.twig');
  682. //        }
  683. //        throw $this->createNotFoundException();
  684. //    }
  685. }