src/ApplicationBundle/Modules/HoneybeeWeb/Controller/HoneybeeWebController.php line 1017

Open in your IDE?
  1. <?php
  3. namespace ApplicationBundle\Modules\HoneybeeWeb\Controller;
  5. use ApplicationBundle\Constants\GeneralConstant;
  6. use ApplicationBundle\Constants\HumanResourceConstant;
  7. use ApplicationBundle\Controller\GenericController;
  8. use ApplicationBundle\Entity\EmpLeaveApplication;
  9. use ApplicationBundle\Entity\ReceiptCheck;
  10. use ApplicationBundle\Interfaces\SessionCheckInterface;
  11. use ApplicationBundle\Modules\Authentication\Constants\UserConstants; use ApplicationBundle\Modules\Api\Constants\ApiConstants;
  12. use ApplicationBundle\Modules\HoneybeeWeb\Service\Hb360AccessService;
  13. use ApplicationBundle\Modules\HoneybeeWeb\Service\Hb360ConversionService;
  14. use ApplicationBundle\Modules\HoneybeeWeb\Service\Hb360ExecutionService;
  15. use ApplicationBundle\Modules\HoneybeeWeb\Service\Hb360GridService;
  16. use ApplicationBundle\Modules\HoneybeeWeb\Service\Hb360HybridService;
  17. use ApplicationBundle\Modules\HoneybeeWeb\Service\Hb360ProjectService;
  18. use ApplicationBundle\Modules\HoneybeeWeb\Service\Hb360ReportService;
  19. use ApplicationBundle\Modules\HoneybeeWeb\Support\FunnelManifestCore;
  20. use CompanyGroupBundle\Entity\EntityApplicantDetails;
  21. use CompanyGroupBundle\Entity\EntityCountryConsultantRequirements;
  22. use CompanyGroupBundle\Entity\EntitySkill;
  23. use CompanyGroupBundle\Entity\EntityCreateBlog;
  24. use CompanyGroupBundle\Entity\EntityCreateTopic;
  25. use Ps\PdfBundle\Annotation\Pdf;
  26. use Symfony\Component\HttpFoundation\Request;
  27. use Symfony\Component\HttpFoundation\Response;
  28. use Symfony\Component\HttpFoundation\JsonResponse;
  29. use Symfony\Component\Routing\Generator\UrlGenerator;
  30. use CompanyGroupBundle\Entity\User;
  32. //use Symfony\Bundle\FrameworkBundle\Console\Application;
  33. //use Symfony\Component\Console\Input\ArrayInput;
  34. //use Symfony\Component\Console\Output\NullOutput;
  37. class HoneybeeWebController extends GenericController implements SessionCheckInterface
  38. {
  39.     // ═══ HB360 H1b/H1c — "your saved estimate" behind the signup wall ═══
  41.     /**
  42.      * Tier gate for a package. Returns null when allowed; otherwise a redirect
  43.      * to the estimate page with an upsell notice. SWITCHED OFF by default
  44.      * (Hb360AccessService::DEFAULT_MAP is all-free) until the owner maps tiers.
  45.      */
  46.     private function hb360TierGate(Request $request, string $package, int $projectId)
  47.     {
  48.         $check = (new Hb360AccessService($this->container))
  49.             ->check($package, (int) $this->loggedUserId($request));
  50.         if ($check['allowed']) {
  51.             return null;
  52.         }
  53.         return $this->redirectToRoute('hb360_my_estimate', [
  54.             'p' => $projectId, 'locked' => $package, 'tier' => $check['required_tier'],
  55.         ]);
  56.     }
  58.     /** The saved-estimate home: latest project + Package B report (if generated). */
  59.     public function Hb360MyEstimateAction(Request $request)
  60.     {
  61.         if ((int) $this->loggedUserType($request) !== UserConstants::USER_TYPE_APPLICANT) {
  62.             return $this->redirectToRoute('central_login');
  63.         }
  64.         $em = $this->getDoctrine()->getManager('company_group');
  65.         $svc = new Hb360ProjectService($em);
  66.         $applicantId = (int) $this->loggedUserId($request);
  68.         // Safety net for the login-time attach (e.g. the estimate was made in
  69.         // another tab AFTER logging in): claim anon rows for this cookie now.
  70.         try {
  71.             $anon = (string) $request->cookies->get('hb360_anon', '');
  72.             if ($anon !== '') {
  73.                 $svc->attachToken($anon, $applicantId, (string) $request->getSession()->get(UserConstants::USER_EMAIL));
  74.             }
  75.         } catch (\Throwable $e) { /* best-effort */ }
  77.         $projects = []; $storageReady = true;
  78.         try {
  79.             $projects = $svc->listForApplicant($applicantId);
  80.         } catch (\Throwable $e) {
  81.             $storageReady = false; // hb360_project table not migrated yet
  82.         }
  84.         $current = null;
  85.         $pid = (int) $request->query->get('p', 0);
  86.         foreach ($projects as $p) {
  87.             if ((int) $p->getId() === $pid) { $current = $p; break; }
  88.         }
  89.         if (!$current && $projects) { $current = $projects[0]; }
  91.         // FUNNEL-1: the attached studio design card for the CURRENT estimate. Best-effort.
  92.         $design = null;
  93.         try {
  94.             if ($current && $current->getDesignJson()) {
  95.                 $dj = json_decode((string) $current->getDesignJson(), true);
  96.                 if (is_array($dj) && isset($dj['payload']) && is_array($dj['payload'])) {
  97.                     $design = array(
  98.                         'summary'  => FunnelManifestCore::summary($dj['payload']),
  99.                         'hash'     => isset($dj['hash']) ? (string) $dj['hash'] : '',
  100.                         'saved_at' => isset($dj['saved_at']) ? (string) $dj['saved_at'] : null,
  101.                     );
  102.                 }
  103.             }
  104.         } catch (\Throwable $e) { $design = null; }
  106.         // ── FUNNEL-3: "My designs" — every attached row carrying a studio design, with
  107.         // summary figures + the HONEST handoff status line (read from CENTRAL only —
  108.         // sds_funnel_handoff lives where the applicant lives; no tenant DB is touched).
  109.         $myDesigns = array();
  110.         try {
  111.             $handoffByProject = array();
  112.             $tenantNames = array();
  113.             try {
  114.                 $conn = $em->getConnection();
  115.                 if ($conn->getSchemaManager()->tablesExist(array('sds_funnel_handoff'))) {
  116.                     $rows = $conn->fetchAllAssociative(
  117.                         'SELECT project_id, target_app_id, status, created_at FROM sds_funnel_handoff'
  118.                         . ' WHERE project_id IS NOT NULL ORDER BY id ASC');
  119.                     foreach ($rows as $r) { // ASC ⇒ the LATEST handoff per project wins
  120.                         $handoffByProject[(int) $r['project_id']] = $r;
  121.                     }
  122.                     foreach ($em->getRepository('CompanyGroupBundle\\Entity\\CompanyGroup')->findAll() as $g) {
  123.                         $tenantNames[(int) $g->getAppId()] = (string) $g->getName();
  124.                     }
  125.                 }
  126.             } catch (\Throwable $e) { /* status lines are an extra, never a gate */ }
  127.             foreach ($projects as $p) {
  128.                 if (!$p->getDesignJson()) { continue; }
  129.                 $dj = json_decode((string) $p->getDesignJson(), true);
  130.                 if (!is_array($dj) || !isset($dj['payload']) || !is_array($dj['payload'])) { continue; }
  131.                 $entry = array(
  132.                     'id'       => (int) $p->getId(),
  133.                     'title'    => (string) ($p->getTitle() ?: ('Design #' . $p->getId())),
  134.                     'address'  => (string) $p->getAddress(),
  135.                     'summary'  => FunnelManifestCore::summary($dj['payload']),
  136.                     'saved_at' => isset($dj['saved_at']) ? (string) $dj['saved_at'] : null,
  137.                     'updated'  => $p->getUpdatedAt() ? $p->getUpdatedAt()->format('d M Y H:i') : '',
  138.                     'offer'    => null,
  139.                 );
  140.                 if (isset($handoffByProject[(int) $p->getId()])) {
  141.                     $h = $handoffByProject[(int) $p->getId()];
  142.                     $label = \ApplicationBundle\Modules\HoneybeeWeb\Support\FunnelWireCore::applicantStatusLabel((string) $h['status']);
  143.                     if ($label !== '') {
  144.                         $entry['offer'] = array(
  145.                             'label'     => $label,
  146.                             'recipient' => isset($tenantNames[(int) $h['target_app_id']])
  147.                                 ? $tenantNames[(int) $h['target_app_id']] : null,
  148.                             'when'      => (string) $h['created_at'],
  149.                         );
  150.                     }
  151.                 }
  152.                 $myDesigns[] = $entry;
  153.             }
  154.         } catch (\Throwable $e) { $myDesigns = array(); }
  156.         return $this->render('@HoneybeeWeb/pages/tools/hb360_my_estimate.html.twig', array(
  157.             'page_title'    => 'My Solar Estimates | HoneyBee 360',
  158.             'projects'      => $projects,
  159.             'current'       => $current,
  160.             'estimate'      => $current ? json_decode($current->getEstimateJson(), true) : null,
  161.             'report'        => ($current && $current->getReportJson()) ? json_decode($current->getReportJson(), true) : null,
  162.             'design'        => $design,
  163.             'my_designs'    => $myDesigns,
  164.             'storage_ready' => $storageReady,
  165.         ));
  166.     }
  168.     /** H1c: turn the saved estimate into a Package B feasibility report. */
  169.     public function Hb360GenerateReportAction(Request $request, $id)
  170.     {
  171.         if ((int) $this->loggedUserType($request) !== UserConstants::USER_TYPE_APPLICANT) {
  172.             return $this->redirectToRoute('central_login');
  173.         }
  174.         $em = $this->getDoctrine()->getManager('company_group');
  175.         $svc = new Hb360ProjectService($em);
  176.         $project = $svc->findOwned((int) $id, (int) $this->loggedUserId($request));
  177.         if (!$project) {
  178.             return $this->redirectToRoute('hb360_my_estimate');
  179.         }
  180.         $estimate = json_decode($project->getEstimateJson(), true) ?: [];
  181.         $report = (new Hb360ReportService())->report($estimate, [
  182.             'lat' => $project->getLat() ?: 50,
  183.             // Equipment refinement: an explicit config pick from the report form.
  184.             'inverterModel' => (string) $request->request->get('inverter_model', ''),
  185.         ]);
  186.         if (!empty($report['ok'])) {
  187.             // A refresh recomputes Package B but keeps existing deeper packages.
  188.             $old = json_decode((string) $project->getReportJson(), true);
  189.             foreach (['package_c', 'package_d', 'package_e', 'package_f'] as $pk) {
  190.                 if (!empty($old[$pk])) { $report[$pk] = $old[$pk]; }
  191.             }
  192.             $svc->saveReport($project, $report);
  193.         }
  194.         return $this->redirectToRoute('hb360_my_estimate', ['p' => $project->getId()]);
  195.     }
  197.     // ═══ HB360-CONV — "Convert this estimate to an EPC project" (web wire) ═══
  198.     //
  199.     // Wraps the EXISTING Hb360ConversionService (no re-implementation). Hard
  200.     // rules: anonymous visitors hit the wall (the applicant gate below); the
  201.     // target tenant resolves ONLY from the authenticated session's app-id list
  202.     // (Hb360ConversionService::resolveTenant — a request-supplied id that is
  203.     // not in the session list resolves to null); conversion is confirm-before-
  204.     // commit, DRAFT-only (existing approval funnel), and idempotent (a stamped
  205.     // converted_ref shows the existing document, never a duplicate).
  207.     /** The session's workspace list — the ONLY source of a conversion target. */
  208.     private function hb360AllowedAppIds(Request $request): array
  209.     {
  210.         return Hb360ConversionService::allowedAppIds(
  211.             $request->getSession()->get(UserConstants::USER_APP_ID_LIST)
  212.         );
  213.     }
  215.     /** Connect a tenant DB (the application_connector reset pattern). */
  216.     private function hb360TenantConnect(int $appId): array
  217.     {
  218.         $emGoc = $this->getDoctrine()->getManager('company_group');
  219.         $goc = $emGoc->getRepository('CompanyGroupBundle\\Entity\\CompanyGroup')->findOneBy(['appId' => $appId]);
  220.         if (!$goc) {
  221.             return [null, null];
  222.         }
  223.         $this->container->get('application_connector')->resetConnection(
  224.             'default', $goc->getDbName(), $goc->getDbUser(), $goc->getDbPass(), $goc->getDbHost(), true
  225.         );
  226.         return [$this->getDoctrine()->getManager(), $goc];
  227.     }
  229.     /** Workspace labels + the best-effort ERP deep-link base, from CENTRAL data only. */
  230.     private function hb360WorkspaceMeta(array $appIds): array
  231.     {
  232.         $meta = [];
  233.         try {
  234.             $emGoc = $this->getDoctrine()->getManager('company_group');
  235.             foreach ($appIds as $appId) {
  236.                 $goc = $emGoc->getRepository('CompanyGroupBundle\\Entity\\CompanyGroup')->findOneBy(['appId' => $appId]);
  237.                 $addr = $goc ? trim((string) ($goc->getCurrentServerAddress() ?: $goc->getCompanyGroupServerAddress())) : '';
  238.                 if ($addr !== '' && strpos($addr, 'http') !== 0) { $addr = 'https://' . $addr; }
  239.                 $meta[$appId] = [
  240.                     'name' => $goc ? (string) $goc->getName() : ('Workspace #' . $appId),
  241.                     'erp_base' => $addr !== '' ? rtrim($addr, '/') : null,
  242.                 ];
  243.             }
  244.         } catch (\Throwable $e) { /* labels are cosmetic — never block the flow */ }
  245.         return $meta;
  246.     }
  248.     /** GET — the confirm step (also the "already converted" landing). */
  249.     public function Hb360ConvertConfirmAction(Request $request, $id)
  250.     {
  251.         if ((int) $this->loggedUserType($request) !== UserConstants::USER_TYPE_APPLICANT) {
  252.             return $this->redirectToRoute('central_login'); // the wall — anon never converts
  253.         }
  254.         $em = $this->getDoctrine()->getManager('company_group');
  255.         $project = (new Hb360ProjectService($em))->findOwned((int) $id, (int) $this->loggedUserId($request));
  256.         if (!$project) {
  257.             return $this->redirectToRoute('hb360_my_estimate');
  258.         }
  259.         $allowed = $this->hb360AllowedAppIds($request);
  260.         $estimate = json_decode($project->getEstimateJson(), true) ?: [];
  262.         // Idempotent landing: already converted → link the existing document.
  263.         $existing = null;
  264.         if ($project->getConvertedRef()) {
  265.             [$docHash, $proposalId] = array_pad(explode('#', (string) $project->getConvertedRef(), 2), 2, '');
  266.             $wsMeta = $this->hb360WorkspaceMeta([(int) $project->getConvertedAppId()]);
  267.             $base = $wsMeta[(int) $project->getConvertedAppId()]['erp_base'] ?? null;
  268.             $existing = [
  269.                 'doc_hash' => $docHash, 'proposal_id' => (int) $proposalId,
  270.                 'app_id' => (int) $project->getConvertedAppId(),
  271.                 'workspace' => $wsMeta[(int) $project->getConvertedAppId()]['name'] ?? ('Workspace #' . $project->getConvertedAppId()),
  272.                 'deep_link' => $base && $proposalId ? $base . '/view_sales_proposal/' . (int) $proposalId : null,
  273.                 'converted_at' => $project->getConvertedAt(),
  274.             ];
  275.         }
  277.         return $this->render('@HoneybeeWeb/pages/tools/hb360_convert.html.twig', array(
  278.             'page_title' => 'Convert to EPC project | HoneyBee 360',
  279.             'project'    => $project,
  280.             'estimate'   => $estimate,
  281.             'allowed'    => $allowed,
  282.             'workspaces' => $this->hb360WorkspaceMeta($allowed),
  283.             'existing'   => $existing,
  284.             'error'      => (string) $request->query->get('e', ''),
  285.         ));
  286.     }
  288.     /** POST — the commit: create ONE draft proposal in the session-resolved tenant. */
  289.     public function Hb360ConvertCommitAction(Request $request, $id)
  290.     {
  291.         if ((int) $this->loggedUserType($request) !== UserConstants::USER_TYPE_APPLICANT) {
  292.             return $this->redirectToRoute('central_login');
  293.         }
  294.         $emGoc = $this->getDoctrine()->getManager('company_group');
  295.         $project = (new Hb360ProjectService($emGoc))->findOwned((int) $id, (int) $this->loggedUserId($request));
  296.         if (!$project) {
  297.             return $this->redirectToRoute('hb360_my_estimate');
  298.         }
  299.         // Idempotent replay: a second POST lands on the existing document.
  300.         if ($project->getConvertedRef()) {
  301.             return $this->redirectToRoute('hb360_convert_confirm', ['id' => $project->getId()]);
  302.         }
  303.         // Tenant from the SESSION list only — a foreign id resolves to null.
  304.         $appId = Hb360ConversionService::resolveTenant(
  305.             $this->hb360AllowedAppIds($request), $request->request->get('workspace')
  306.         );
  307.         if ($appId === null) {
  308.             return $this->redirectToRoute('hb360_convert_confirm', ['id' => $project->getId(), 'e' => 'workspace']);
  309.         }
  310.         [$tenantEm, $goc] = $this->hb360TenantConnect($appId);
  311.         if (!$tenantEm) {
  312.             return $this->redirectToRoute('hb360_convert_confirm', ['id' => $project->getId(), 'e' => 'workspace']);
  313.         }
  314.         $session = $request->getSession();
  315.         $res = (new Hb360ConversionService())->convert($project, $tenantEm, $emGoc, $appId, false, [
  316.             'clientName' => trim((string) ($session->get(UserConstants::USER_NAME) ?: $session->get(UserConstants::USER_EMAIL) ?: '')),
  317.         ]);
  318.         if (empty($res['ok'])) {
  319.             return $this->redirectToRoute('hb360_convert_confirm', ['id' => $project->getId(), 'e' => 'convert']);
  320.         }
  321.         return $this->redirectToRoute('hb360_convert_confirm', ['id' => $project->getId()]);
  322.     }
  324.     // ── FUNNEL-3: design management on the applicant surface. All three are POST-only,
  325.     //    applicant-gated, and OWN-SCOPED through findOwned (a foreign id is a redirect,
  326.     //    never a touch). Delete is SOFT — the retention cron purges it after 30 days. ──
  328.     /** The own-scoped project or a safe redirect (shared guard for the three actions). */
  329.     private function hb360OwnedOrNull(Request $request, $id)
  330.     {
  331.         if ((int) $this->loggedUserType($request) !== UserConstants::USER_TYPE_APPLICANT) {
  332.             return null;
  333.         }
  334.         $em = $this->getDoctrine()->getManager('company_group');
  335.         return (new Hb360ProjectService($em))->findOwned((int) $id, (int) $this->loggedUserId($request));
  336.     }
  338.     public function Hb360DesignRenameAction(Request $request, $id)
  339.     {
  340.         try {
  341.             $project = $this->hb360OwnedOrNull($request, $id);
  342.             if ($project) {
  343.                 (new Hb360ProjectService($this->getDoctrine()->getManager('company_group')))
  344.                     ->rename($project, (string) $request->request->get('title', ''));
  345.             }
  346.         } catch (\Throwable $e) { /* fall through to the list */ }
  347.         return $this->redirectToRoute('hb360_my_estimate');
  348.     }
  350.     public function Hb360DesignDuplicateAction(Request $request, $id)
  351.     {
  352.         try {
  353.             $project = $this->hb360OwnedOrNull($request, $id);
  354.             if ($project) {
  355.                 $copy = (new Hb360ProjectService($this->getDoctrine()->getManager('company_group')))
  356.                     ->duplicateForApplicant($project);
  357.                 return $this->redirectToRoute('hb360_my_estimate', array('p' => $copy->getId()));
  358.             }
  359.         } catch (\Throwable $e) { /* fall through to the list */ }
  360.         return $this->redirectToRoute('hb360_my_estimate');
  361.     }
  363.     public function Hb360DesignDeleteAction(Request $request, $id)
  364.     {
  365.         try {
  366.             $project = $this->hb360OwnedOrNull($request, $id);
  367.             if ($project) {
  368.                 (new Hb360ProjectService($this->getDoctrine()->getManager('company_group')))
  369.                     ->softDelete($project);
  370.             }
  371.         } catch (\Throwable $e) { /* fall through to the list */ }
  372.         return $this->redirectToRoute('hb360_my_estimate');
  373.     }
  375.     /** HB360-2: add/refresh the Package C hybrid design (BESS + genset + EVSE + finance). */
  376.     public function Hb360GenerateHybridAction(Request $request, $id)
  377.     {
  378.         if ((int) $this->loggedUserType($request) !== UserConstants::USER_TYPE_APPLICANT) {
  379.             return $this->redirectToRoute('central_login');
  380.         }
  381.         $em = $this->getDoctrine()->getManager('company_group');
  382.         $svc = new Hb360ProjectService($em);
  383.         $project = $svc->findOwned((int) $id, (int) $this->loggedUserId($request));
  384.         if (!$project) {
  385.             return $this->redirectToRoute('hb360_my_estimate');
  386.         }
  387.         if ($gate = $this->hb360TierGate($request, 'C', (int) $project->getId())) {
  388.             return $gate;
  389.         }
  390.         $estimate = json_decode($project->getEstimateJson(), true) ?: [];
  391.         $report   = json_decode((string) $project->getReportJson(), true) ?: [];
  392.         if (empty($report['ok'])) {
  393.             return $this->redirectToRoute('hb360_my_estimate', ['p' => $project->getId()]);
  394.         }
  395.         $packageC = (new Hb360HybridService())->design($estimate, $report, [
  396.             'dayShare'        => (float) $request->request->get('day_share', 60),
  397.             'criticalLoadPct' => (float) $request->request->get('critical_load_pct', 30),
  398.             'outageHoursYr'   => (float) $request->request->get('outage_hours_yr', 0),
  399.             'chargers'        => [
  400.                 'ac11'  => (int) $request->request->get('ev_ac11', 0),
  401.                 'ac22'  => (int) $request->request->get('ev_ac22', 0),
  402.                 'dc50'  => (int) $request->request->get('ev_dc50', 0),
  403.                 'dc150' => (int) $request->request->get('ev_dc150', 0),
  404.             ],
  405.         ]);
  406.         if (!empty($packageC['ok'])) {
  407.             $report['package_c'] = $packageC;
  408.             $svc->saveReport($project, $report);
  409.         }
  410.         return $this->redirectToRoute('hb360_my_estimate', ['p' => $project->getId()]);
  411.     }
  413.     /** HB360-3: add/refresh the Package D grid & connection concept. */
  414.     public function Hb360GenerateGridAction(Request $request, $id)
  415.     {
  416.         if ((int) $this->loggedUserType($request) !== UserConstants::USER_TYPE_APPLICANT) {
  417.             return $this->redirectToRoute('central_login');
  418.         }
  419.         $em = $this->getDoctrine()->getManager('company_group');
  420.         $svc = new Hb360ProjectService($em);
  421.         $project = $svc->findOwned((int) $id, (int) $this->loggedUserId($request));
  422.         if (!$project) {
  423.             return $this->redirectToRoute('hb360_my_estimate');
  424.         }
  425.         if ($gate = $this->hb360TierGate($request, 'D', (int) $project->getId())) {
  426.             return $gate;
  427.         }
  428.         $estimate = json_decode($project->getEstimateJson(), true) ?: [];
  429.         $report   = json_decode((string) $project->getReportJson(), true) ?: [];
  430.         if (empty($report['ok'])) {
  431.             return $this->redirectToRoute('hb360_my_estimate', ['p' => $project->getId()]);
  432.         }
  433.         $packageD = (new Hb360GridService())->design($estimate, $report, [
  434.             'exportCapPct'          => (float) $request->request->get('export_cap_pct', 100),
  435.             'existingConnectionKva' => (float) $request->request->get('existing_connection_kva', 0),
  436.         ], [
  437.             'lat' => (float) $project->getLat(), 'lng' => (float) $project->getLng(),
  438.             'address' => (string) $project->getAddress(),
  439.         ]);
  440.         if (!empty($packageD['ok'])) {
  441.             $report['package_d'] = $packageD;
  442.             $svc->saveReport($project, $report);
  443.         }
  444.         return $this->redirectToRoute('hb360_my_estimate', ['p' => $project->getId()]);
  445.     }
  447.     /** HB360-4: add/refresh Packages E (execution briefing) + F (operate plan). */
  448.     public function Hb360GenerateExecutionAction(Request $request, $id)
  449.     {
  450.         if ((int) $this->loggedUserType($request) !== UserConstants::USER_TYPE_APPLICANT) {
  451.             return $this->redirectToRoute('central_login');
  452.         }
  453.         $em = $this->getDoctrine()->getManager('company_group');
  454.         $svc = new Hb360ProjectService($em);
  455.         $project = $svc->findOwned((int) $id, (int) $this->loggedUserId($request));
  456.         if (!$project) {
  457.             return $this->redirectToRoute('hb360_my_estimate');
  458.         }
  459.         if ($gate = $this->hb360TierGate($request, 'E', (int) $project->getId())) {
  460.             return $gate;
  461.         }
  462.         $estimate = json_decode($project->getEstimateJson(), true) ?: [];
  463.         $report   = json_decode((string) $project->getReportJson(), true) ?: [];
  464.         if (empty($report['ok'])) {
  465.             return $this->redirectToRoute('hb360_my_estimate', ['p' => $project->getId()]);
  466.         }
  467.         $exec = (new Hb360ExecutionService())->design($estimate, $report);
  468.         if (!empty($exec['ok'])) {
  469.             $report['package_e'] = $exec['package_e'];
  470.             $report['package_f'] = $exec['package_f'];
  471.             $svc->saveReport($project, $report);
  472.         }
  473.         return $this->redirectToRoute('hb360_my_estimate', ['p' => $project->getId()]);
  474.     }
  476.     // My Freelancer Profile
  477.     public function CentralMyApplicantProfilePageAction(Request $request)
  478.     {
  479.         $em = $this->getDoctrine()->getManager('company_group');
  480.         $session = $request->getSession();
  482.         $details = $em->getRepository(EntityApplicantDetails::class)->find($session->get(UserConstants::USER_ID));
  484.         $employmentByCompany = [];
  485.         if ($details) {
  486.             $employmentByCompany = $this->get('app.applicant_employment_aggregator')->getForApplicant($details);
  487.         }
  489.         return $this->render('@HoneybeeWeb/pages/my_freelancer_profile.html.twig', array(
  490.             'page_title' => 'My Freelancer Profile',
  491.             'details' => $details,
  492.             'skillDetails' => $em->getRepository(EntitySkill::class)->findAll(),
  493.             'employmentByCompany' => $employmentByCompany,
  495.         ));
  496.     }
  498.     public function AccountMergePageAction(Request $request)
  499.     {
  500.         if ((int)$this->loggedUserType($request) !== UserConstants::USER_TYPE_APPLICANT) {
  501.             return $this->redirectToRoute('central_login');
  502.         }
  504.         return $this->render('@HoneybeeWeb/pages/merge_accounts.html.twig', [
  505.             'page_title' => 'Merge Accounts',
  506.         ]);
  507.     }
  509.     public function RequestAccountMergeCodeAction(Request $request): JsonResponse
  510.     {
  511.         if ((int)$this->loggedUserType($request) !== UserConstants::USER_TYPE_APPLICANT) {
  512.             return new JsonResponse(['success' => false, 'message' => 'Please sign in first.'], 403);
  513.         }
  515.         $em = $this->getDoctrine()->getManager('company_group');
  516.         $requester = $em->getRepository(EntityApplicantDetails::class)->find((int)$this->loggedUserId($request));
  517.         if (!$requester) {
  518.             return new JsonResponse(['success' => false, 'message' => 'Applicant account not found.'], 404);
  519.         }
  521.         $result = $this->get('app.account_merge_service')->requestMergeCode(
  522.             $requester,
  523.             (string)$request->request->get('email', $request->query->get('email', ''))
  524.         );
  526.         return new JsonResponse($result, $result['success'] ? 200 : 422);
  527.     }
  529.     public function ConfirmAccountMergeAction(Request $request): JsonResponse
  530.     {
  531.         if ((int)$this->loggedUserType($request) !== UserConstants::USER_TYPE_APPLICANT) {
  532.             return new JsonResponse(['success' => false, 'message' => 'Please sign in first.'], 403);
  533.         }
  535.         $em = $this->getDoctrine()->getManager('company_group');
  536.         $requester = $em->getRepository(EntityApplicantDetails::class)->find((int)$this->loggedUserId($request));
  537.         if (!$requester) {
  538.             return new JsonResponse(['success' => false, 'message' => 'Applicant account not found.'], 404);
  539.         }
  541.         $result = $this->get('app.account_merge_service')->confirmMerge(
  542.             $requester,
  543.             (string)$request->request->get('email', $request->query->get('email', '')),
  544.             (string)$request->request->get('code', $request->query->get('code', '')),
  545.             $request->getSession()
  546.         );
  548.         return new JsonResponse($result, $result['success'] ? 200 : 422);
  549.     }
  551.     public function viewAsUserAction(Request $request, $id)
  552.     {
  553.         $session = $request->getSession();
  554.         $em_goc = $this->getDoctrine()->getManager('company_group');
  555.         $userType = $session->get(UserConstants::USER_TYPE);
  557.         $actualUserId = $session->get('actualUserId', $session->get(UserConstants::USER_ID));
  558.         $actualUserName = $session->get('actualUserName', $session->get(UserConstants::USER_NAME));
  559.         $actualUserType = $session->get('actualUserType', $session->get(UserConstants::USER_TYPE));
  560.         $actualUserAdminLevel = $session->get('actualUserAdminLevel', $session->get(UserConstants::BUDDYBEE_ADMIN_LEVEL));
  561.         $actualUserIsAdmin = $session->get('actualUserIsAdmin', $session->get(UserConstants::IS_BUDDYBEE_ADMIN));
  562.         $actualUserIsModerator = $session->get('actualUserIsModerator', $session->get(UserConstants::IS_BUDDYBEE_MODERATOR));
  564.         $switchToUserId = $request->query->get('id', $request->request->get('id', $id));
  566.         if ($userType == UserConstants::USER_TYPE_APPLICANT) {
  567.             $user = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  568.                 array(
  569.                     'applicantId' => $switchToUserId
  570.                 )
  571.             );
  575.             $session->set(UserConstants::USER_ID, $user->getApplicantId());
  576.             $session->set(UserConstants::IS_CONSULTANT, $user->getIsConsultant() == 1 ? 1 : 0);
  578.             $session->set('BUDDYBEE_BALANCE', 1 * $user->getAccountBalance());
  579.             $session->set('BUDDYBEE_COIN_BALANCE', 1 * $user->getSessionCountBalance());
  582.             $session->set(UserConstants::IS_BUDDYBEE_RETAILER, $user->getIsRetailer() == 1 ? 1 : 0);
  583.             $session->set(UserConstants::BUDDYBEE_RETAILER_LEVEL, $user->getRetailerLevel() == 1 ? 1 : 0);
  584.             $session->set(UserConstants::BUDDYBEE_ADMIN_LEVEL, $user->getIsAdmin() == 1 ? (($user->getAdminLevel() != null && $user->getAdminLevel() != 0) ? $user->getAdminLevel() : 1) : ($user->getIsModerator() == 1 ? 1 : 0));
  585.             $session->set(UserConstants::IS_BUDDYBEE_MODERATOR, $user->getIsModerator() == 1 ? 1 : 0);
  586.             $session->set(UserConstants::IS_BUDDYBEE_ADMIN, $user->getIsAdmin() == 1 ? 1 : 0);
  587.             // $session->set(UserConstants::SUPPLIER_ID, $user->getSupplierId());
  588.             $session->set(UserConstants::USER_TYPE, UserConstants::USER_TYPE_APPLICANT);
  589.             $session->set(UserConstants::USER_EMAIL, $user->getOauthEmail());
  590.             $session->set(UserConstants::USER_IMAGE, $user->getImage());
  591.             $session->set(UserConstants::USER_NAME, $user->getFirstName() . ' ' . $user->getLastName());
  592.             $session->set(UserConstants::USER_DEFAULT_ROUTE, '');
  593.             $session->set(UserConstants::USER_COMPANY_ID, 1);
  594.             $session->set(UserConstants::USER_COMPANY_ID_LIST, json_encode([]));
  595.             $session->set(UserConstants::USER_COMPANY_NAME_LIST, json_encode([]));
  596.             $session->set(UserConstants::USER_COMPANY_IMAGE_LIST, json_encode([]));
  597.             $session->set('userCompanyDarkVibrantList', json_encode([]));
  598.             $session->set('userCompanyVibrantList', json_encode([]));
  599.             $session->set('userCompanyLightVibrantList', json_encode([]));
  600.             $session->set(UserConstants::USER_COMPANY_IMAGE_LIST, json_encode([]));
  601.             $session->set(UserConstants::USER_APP_ID, 0);
  602.             $session->set(UserConstants::USER_POSITION_LIST, '[]');
  603.             $session->set(UserConstants::ALL_MODULE_ACCESS_FLAG, 0);
  605.             $session->set(UserConstants::SESSION_SALT, uniqid(mt_rand()));
  606.             $session->set(UserConstants::APPLICATION_SECRET, $this->container->getParameter('secret'));
  608.             $session->set(UserConstants::USER_NOTIFICATION_ENABLED, GeneralConstant::NOTIFICATION_ENABLED == 1 ? ($this->getParameter('notification_enabled') == 1 ? 1 : 0) : 0);
  609.             $session->set(UserConstants::USER_NOTIFICATION_SERVER, $this->getParameter('notification_server'));
  610.             $session->set('oAuthToken', $request->request->get('oAuthToken', ''));
  611.             $session->set('locale', $request->request->get('locale', ''));
  612.             $session->set('firebaseToken', $request->request->get('firebaseToken', ''));
  613.             $session->set('actualUserId', $actualUserId);
  614.             $session->set('actualUserName', $actualUserName);
  615.             $session->set('actualUserType', $actualUserType);
  616.             $session->set('actualUserAdminLevel', $actualUserAdminLevel);
  617.             $session->set('actualUserIsAdmin', $actualUserIsAdmin);
  618.             $session->set('actualUserIsModerator', $actualUserIsModerator);
  621.             $route_list_array = [];
  624.             $session->set(UserConstants::USER_CURRENT_POSITION, 0);
  628. //            $userAppIds = json_decode($user->getUserAppIds(), true);
  629.             $userAppIds = [];
  630.             $userSuspendedAppIds = json_decode($user->getUserSuspendedAppIds(), true);
  631.             $userTypesByAppIds = json_decode($user->getUserTypesByAppIds(), true);
  632.             if ($userAppIds == null) $userAppIds = [];
  633.             if ($userSuspendedAppIds == null) $userSuspendedAppIds = [];
  634.             if ($userTypesByAppIds == null) $userTypesByAppIds = [];
  635.             foreach ($userTypesByAppIds as $aid => $accData)
  636.                 if (in_array($aid, $userSuspendedAppIds))
  637.                     unset($userTypesByAppIds[$aid]);
  638.                 else
  639.                     $userAppIds[]=$aid;
  640. //            $userAppIds=array_diff($userAppIds,$userSuspendedAppIds);
  643.             $gocList = $em_goc
  644.                 ->getRepository("CompanyGroupBundle\\Entity\\CompanyGroup")
  645.                 ->findBy(
  646.                     array(//                        'active' => 1
  647.                         'appId'=>$userAppIds
  648.                     )
  649.                 );
  651.             $gocDataList = [];
  652.             $gocDataListForLoginWeb = [];
  653.             $gocDataListByAppId = [];
  654.             $accessList=[];
  655.             foreach ($gocList as $entry) {
  656.                 $d = array(
  657.                     'name' => $entry->getName(),
  658.                     'image' => $entry->getImage(),
  659.                     'id' => $entry->getId(),
  660.                     'appId' => $entry->getAppId(),
  661.                     'skipInWebFlag' => $entry->getSkipInWebFlag(),
  662.                     'skipInAppFlag' => $entry->getSkipInAppFlag(),
  664.                     'dbName' => $entry->getDbName(),
  665.                     'dbUser' => $entry->getDbUser(),
  666.                     'dbPass' => $entry->getDbPass(),
  667.                     'dbHost' => $entry->getDbHost(),
  668.                     'companyGroupServerAddress' => $entry->getCompanyGroupServerAddress(),
  669.                     'companyGroupServerId' => $entry->getCompanyGroupServerId(),
  670.                     'companyGroupServerPort' => $entry->getCompanyGroupServerPort(),
  671.                     'companyRemaining' => $entry->getCompanyRemaining(),
  672.                     'companyAllowed' => $entry->getCompanyAllowed(),
  673.                 );
  674.                 $gocDataList[$entry->getId()] = $d;
  675.                 if (in_array($entry->getSkipInWebFlag(), [0, null]))
  676.                     $gocDataListForLoginWeb[$entry->getId()] = $d;
  677.                 $gocDataListByAppId[$entry->getAppId()] = $d;
  678.             }
  679.             foreach ($userTypesByAppIds as $thisUserAppId => $thisUserUserTypes) {
  680.                 foreach ($thisUserUserTypes as $thisUserUserType) {
  682.                     if (isset($gocDataListByAppId[$thisUserAppId])) {
  683.                         $userTypeName = isset(UserConstants::$userTypeName[$thisUserUserType]) ? UserConstants::$userTypeName[$thisUserUserType] : 'Unknown';
  684.                         $d = array(
  685.                             'userType' => $thisUserUserType,
  686. //                                        'userTypeName' => UserConstants::$userTypeName[$thisUserUserType],
  687.                             'userTypeName' => $userTypeName,
  688.                             'globalId' => $user->getApplicantId(),
  689.                             'serverId' => $gocDataListByAppId[$thisUserAppId]['companyGroupServerId'],
  690.                             'serverUrl' => $gocDataListByAppId[$thisUserAppId]['companyGroupServerAddress'],
  691.                             'serverPort' => $gocDataListByAppId[$thisUserAppId]['companyGroupServerPort'],
  692.                             'systemType' => '_ERP_',
  693.                             'companyId' => 1,
  694.                             'appId' => $thisUserAppId,
  695.                             'companyLogoUrl' => $gocDataListByAppId[$thisUserAppId]['image'],
  696.                             'companyName' => $gocDataListByAppId[$thisUserAppId]['name'],
  697.                             'authenticationStr' => $this->get('url_encryptor')->encrypt(json_encode(
  698.                                     array(
  699.                                         'globalId' => $user->getApplicantId(),
  700.                                         'appId' => $thisUserAppId,
  701.                                         'authenticate' => 1,
  702.                                         'userType' => $thisUserUserType,
  703.                                         'userTypeName' => $userTypeName
  704.                                     )
  705.                                 )
  708.                             ),
  709.                             'userCompanyList' => [
  710.                             ]
  711.                         );
  712.                         $accessList[] = $d;
  713.                     }
  714.                 }
  715.             }
  717.             $session_data['userAccessList'] = $accessList;
  718.             $session->set('userAccessList',$accessList);
  720.             $loginID = 0;
  721. //            $loginID = MiscActions::addEntityUserLoginLog(
  722. //                $em_goc,
  723. //                $session->get(UserConstants::USER_ID),
  724. //                $session->get(UserConstants::USER_ID),
  725. //                1,
  726. //                $request->server->get("REMOTE_ADDR"),
  727. //                0,
  728. //                $request->request->get('deviceId', ''),
  729. //                $request->request->get('oAuthToken', ''),
  730. //                $request->request->get('oAuthType', ''),
  731. //                $request->request->get('locale', ''),
  732. //                $request->request->get('firebaseToken', '')
  733. //
  734. //            );
  735. //            $session->set(UserConstants::USER_LOGIN_ID, $loginID);
  738.             if ($request->request->has('referer_path')) {
  739.                 if ($request->request->get('referer_path') != '/' && $request->request->get('referer_path') != '') {
  740.                     return $this->redirect($request->request->get('referer_path'));
  741.                 }
  742.             }
  743.             $redirectRoute = 'central_landing';
  747.             return $this->redirectToRoute($redirectRoute);
  748.         }
  749.     }
  750.     public function CentralGetHirePageAction(Request $request,$id=0)
  751.     {
  752.         $em = $this->getDoctrine()->getManager('company_group');
  753.         $session = $request->getSession();
  754.         $consultantDetails = $em->getRepository(EntityApplicantDetails::class)->find($session->get(UserConstants::USER_ID));
  755.         $consultantRequirementsQry = $em->getRepository(EntityCountryConsultantRequirements::class)->findAll();
  756.         $subscribed = false;
  758.         $consultantRequirementsByCountryId = [];
  759.         foreach ($consultantRequirementsQry as $value) {
  760.             $docList = json_decode($value->getDocumentList(), true);
  761.             $requiredFields = json_decode($value->getRequiredFields(), true);
  762.             if ($docList == null) $docList = [];
  763.             if ($requiredFields == null) $requiredFields = [];
  764.             $consultantRequirementsByCountryId[$value->getCountryId()] = array(
  765.                 'documentList' => $docList,
  766.                 'requiredFields' => $requiredFields,
  767.                 'contractLetterHtml' => $value->getContractLetterHtml(),
  769.             );
  770.         }
  771.         $documentLists = $em->getRepository('CompanyGroupBundle\\Entity\\EntityCreateDocument')->findAll();;
  772.         $docListArray = [];
  773.         foreach ($documentLists as $document) {
  774.             $docListArray [$document->getId()] = array(
  775.                 'id' => $document->getId(),
  776.                 'docName' => $document->getDocumentName(),
  777.                 'expiryDays' => $document->getExpiryDays(),
  778.                 'processingDays' => $document->getProcessingDays(),
  779.                 'emergencyProcessingDays' => $document->getEmergencyProcessingDays(),
  780.                 'checklist' => json_decode($document->getCheckList()),
  782.             );
  783.         }
  784.         $skillDetails = $em->getRepository(EntitySkill::class)->findAll();
  785.         $companyId = $this->getLoggedUserCompanyId($request);
  786.         $gender = HumanResourceConstant::$sex;
  787.         $blood = HumanResourceConstant::$BloodGroup;
  788.         $userId = $session->get(UserConstants::USER_ID);
  790.         $education = array(
  791.             'instituteName' => $request->get('instituteName'),
  792.             'courseOfStudy' => $request->get('courseOfStudy'),
  793.             'courseStartDate' => $request->get('courseStartDate'),
  794.             'courseEndDate' => $request->get('courseEndDate'),
  795.             'result' => $request->get('result'),
  796.             'grade' => $request->get('grade'),
  797.             'degree' => $request->get('degree'),
  798.         );
  799.         $workExperience = array(
  800.             'title' => $request->get('title'),
  801.             'companyName' => $request->get('companyName'),
  802.             'jobStartDate' => $request->get('jobStartDate'),
  803.             'jobEndDate' => $request->get('jobEndDate'),
  804.             'description' => $request->get('workDescription'),
  805.         );
  806.         $certificate = array(
  807.             'certificatename' => $request->get('certificatename'),
  808.             'issuedDate' => $request->get('issuedDate'),
  809.         );
  810.         $courses = array(
  811.             'courseName' => $request->get('courseName'),
  812.             'date' => $request->get('date'),
  813.             'duration' => $request->get('duration')
  814.         );
  816.         if ($request->isMethod('POST')) {
  817.             if ($consultantDetails)
  818.                 $consultant = $consultantDetails;
  819.             else
  820.                 $consultant = new EntityApplicantDetails();
  823.             $consultant->setApplicationText($request->request->get('applicationText'));
  824.             $consultant->setFirstname($request->request->get('firstname'));
  825.             $consultant->setLastname($request->request->get('lastname'));
  826.             $consultant->setIsImgLegal($request->request->get('is_img_legal'));
  827.             $consultant->setNid($request->request->get('nid'));
  828.             $consultant->setDob(new \DateTime($request->get('dob')));
  829.             $consultant->setSex($request->request->get('sex'));
  830.             $consultant->setFather($request->request->get('father'));
  831.             $consultant->setMother($request->request->get('mother'));
  832.             $consultant->setBlood($request->request->get('blood'));
  833.             $consultant->setPhone($request->request->get('phone'));
  834.             $consultant->setCountry($request->request->get('country'));
  835.             $consultant->setCurrentCountryId($request->request->get('currentCountryId'));
  836.             $consultant->setCountryId($request->request->get('currentCountryId'));
  837.             $consultant->setPostalCode($request->request->get('postalCode'));
  838.             $consultant->setDescription($request->request->get('description'));
  839.             $consultant->setCurrAddr($request->request->get('curr_addr'));
  840.             $consultant->setSkill(json_encode($request->request->get('skill')));
  841.             $consultant->setEmergencyContactNumber($request->request->get('emm_contact'));
  842.             $consultant->setEmail($request->request->get('oauth_email'));
  843.             $consultant->setCurrentEmployment($request->request->get('currentEmployment'));
  844.             $consultant->setTin($request->request->get('tin'));
  845.             $consultant->setEducationData(json_encode($education));
  846.             $consultant->setWorkExperienceData(json_encode($workExperience));
  847.             $consultant->setCertificateData(json_encode($certificate));
  848.             $consultant->setCoursesData(json_encode($courses));
  849.             $consultant->setWorkExperienceText($request->request->get('workExperience'));
  850.             $consultant->setUniversityText($request->request->get('universityText'));
  851.             $consultant->setEducationText($request->request->get('educationText'));
  852.             $consultant->setExperienceText($request->request->get('experienceText'));
  853.             $consultant->setSkillstext($request->request->get('skillText'));
  854.             $consultant->setSpeciality($request->request->get('speciality'));
  855.             $consultant->setDescription($request->request->get('aboutMe'));
  856.             $consultant->setApplyForConsultant(1);
  857.             $consultant->setApplyForConsultantDate(new \DateTime());
  859.             $em->persist($consultant);
  860.             $em->flush();
  861.             $subscribed = true;
  862.         }
  864.         return $this->render('@HoneybeeWeb/pages/get_hire.html.twig', array(
  865.             'page_title' => 'Get Hired',
  866.             'gender' => $gender,
  867.             'blood' => $blood,
  868.             'consultantDetails' => $consultantDetails,
  869.             'consultantRequirementsByCountryId' => $consultantRequirementsByCountryId,
  870.             'docListArray' => $docListArray,
  871.             'education' => json_decode($consultantDetails->getEducationData(), true),
  872.             'workExperience' => json_decode($consultantDetails->getWorkExperienceData(), true),
  873.             'certificate' => json_decode($consultantDetails->getCertificateData(), true),
  874.             'courses' => json_decode($consultantDetails->getCoursesData(), true),
  875.             'languages' => json_decode($consultantDetails->getLanguagesData(), true),
  876.             'skillDetails' => $skillDetails,
  877.             'subscribed' => $subscribed,
  879.         ));
  880.     }
  881.     public function createTopicAction(Request $request,$id =0){
  882.         $em = $this->getDoctrine()->getManager('company_group');
  884.         if ($request->isMethod('POST')) {
  886.             $entityTopic = new EntityCreateTopic();
  887.             $entityTopic->setTopicName($request->request->get('catName'));
  889.             $em->persist($entityTopic);
  890.             $em->flush();
  892.         }
  893.         $topicDetails =  $em->getRepository('CompanyGroupBundle\\Entity\\EntityCreateTopic')->findAll();
  895.         return $this->render('@HoneybeeWeb/pages/create_topic.html.twig', [
  896.             'page_title' => 'Create Category',
  897.             'topics' => $topicDetails
  898.         ]);
  899.     }
  900.     public function createBlogAction(Request $request, $id = 0)
  901.     {
  902.         $em = $this->getDoctrine()->getManager('company_group');
  904.         // ── Soft Delete ──────────────────────────────────────────────────
  905.         if ($request->isMethod('POST') && $request->request->get('_action') === 'delete') {
  906.             $blog = $em->getRepository('CompanyGroupBundle\Entity\EntityCreateBlog')->find($id);
  907.             if (!$blog) {
  908.                 throw $this->createNotFoundException('Blog not found');
  909.             }
  910.             $blog->setDeleteFlag(true);
  911.             $em->flush();
  912.             return $this->redirectToRoute('honeybee_blog', ['action' => 'create']);
  913.         }
  915.         // ── Find or new ───────────────────────────────────────────────────
  916.         if ($id > 0) {
  917.             $new = $em->getRepository('CompanyGroupBundle\Entity\EntityCreateBlog')->find($id);
  918.             if (!$new || $new->getDeleteFlag()) {
  919.                 throw $this->createNotFoundException('Blog not found');
  920.             }
  921.         } else {
  922.             $new = new \CompanyGroupBundle\Entity\EntityCreateBlog();
  923.         }
  925.         $topicDetails = $em->getRepository('CompanyGroupBundle\Entity\EntityCreateTopic')->findAll();
  927.         if ($request->isMethod('POST')) {
  928.             $new->setTopicId($request->request->get('topicId'));
  929.             $new->setTitle($request->request->get('blogTitle'));
  930.             $new->setContent($request->request->get('blogContent'));
  932.             if ($id == 0) {
  933.                 $session = $request->getSession();
  934.                 $userName = $session->get(UserConstants::USER_NAME);
  935.                 if ($userName) {
  936.                     $new->setAuthorName($userName);
  937.                 }
  938.             }
  940.             $em->persist($new);
  941.             $em->flush();
  943.             $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/BlogImages/';
  944.             $uploadedFile = $request->files->get('blogImage', null);
  946.             if ($uploadedFile != null) {
  947.                 $fileName = 'p' . $new->getId() . '.' . $uploadedFile->guessExtension();
  948.                 if (!file_exists($upl_dir)) {
  949.                     mkdir($upl_dir, 0777, true);
  950.                 }
  951.                 $uploadedFile->move($upl_dir, $fileName);
  952.                 $new->setMainImage('uploads/BlogImages/' . $fileName);
  953.                 $em->flush();
  954.             }
  956.             return $this->redirectToRoute($request->attributes->get('_route'), ['id' => $new->getId()]);
  957.         }
  959.         // ── List: exclude soft-deleted ────────────────────────────────────
  960.         $blogDetails = $em->getRepository('CompanyGroupBundle\Entity\EntityCreateBlog')
  961.             ->createQueryBuilder('b')
  962.             ->where('b.deleteFlag != :status')
  963.             ->orWhere('b.deleteFlag IS NULL')
  964.             ->setParameter('status', true)
  965.             ->getQuery()
  966.             ->getResult();
  969.         return $this->render('@HoneybeeWeb/pages/create_blog.html.twig', [
  970.             'page_title' => ($id > 0) ? 'Edit Blog' : 'Create Blog',
  971.             'blogs'  => $blogDetails,
  972.             'topics' => $topicDetails,
  973.             'blog'   => $new,
  974.         ]);
  975.     }
  977.     public function LoggedInUserAction(Request $request): JsonResponse
  978.     {
  979.         $session = $request->getSession();
  980.         $userId = $session->get(UserConstants::APPLICANT_ID);
  981.         $token = $session->get(UserConstants::USER_TOKEN);
  982. //        $providedToken = $request->headers->get('auth-token');
  983. //        return new JsonResponse([$token,$providedToken,$userId]);
  985. //        if (empty($providedToken) || $providedToken !== $token) {
  986. //            return new JsonResponse([
  987. //                'status' => 'error',
  988. //                'message' => 'Token mismatched or missing',
  989. //            ], 401);
  990. //        }
  991.         try {
  992.             $em_goc = $this->getDoctrine()->getManager('company_group');
  993.             $applicant = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  994.                 ->findOneBy(
  995.                     array(
  997.                         'applicantId' => $userId
  998.                     )
  999.                 );
  1001.             if (!$applicant->getApplicantId()) {
  1002.                 return new JsonResponse([
  1003.                     'success' => false,
  1004.                     'error' => [
  1005.                         'code' => 'USER_NOT_FOUND',
  1006.                         'message' => 'Applicant not found for the current session',
  1007.                         'statusCode' => 404,
  1008.                     ]
  1009.                 ], 404);
  1010.             }
  1013.             $educationDataRaw = json_decode($applicant->getEducationData(), true);
  1014.             $workExperienceDataRaw = json_decode($applicant->getWorkExperienceData(), true);
  1015.             $certificateDataRaw = json_decode($applicant->getCertificateData(), true);
  1016.             $absoluteUrl = $this->generateUrl('dashboard', [], UrlGenerator::ABSOLUTE_URL);
  1017.             $userImage = $session->get(UserConstants::USER_IMAGE);
  1019.             $educationData = [];
  1020.             if ($educationDataRaw && isset($educationDataRaw['instituteName'])) {
  1021.                 $count = count($educationDataRaw['instituteName']);
  1022.                 for ($i = 0; $i < $count; $i++) {
  1023.                     $educationData[] = [
  1024.                         'instituteName' => $educationDataRaw['instituteName'][$i] ?? '',
  1025.                         'courseOfStudy' => $educationDataRaw['courseOfStudy'][$i] ?? '',
  1026.                         'courseStartDate' => $educationDataRaw['courseStartDate'][$i] ?? '',
  1027.                         'courseEndDate' => $educationDataRaw['courseEndDate'][$i] ?? '',
  1028.                         'result' => $educationDataRaw['result'][$i] ?? '',
  1029.                         'grade' => $educationDataRaw['grade'][$i] ?? '',
  1030.                         'degree' => $educationDataRaw['degree'][$i] ?? '',
  1031.                     ];
  1032.                 }
  1033.             }
  1035.             $workExperienceData = [];
  1036.             if ($workExperienceDataRaw && isset($workExperienceDataRaw['title'])) {
  1037.                 $count = count($workExperienceDataRaw['title']);
  1038.                 for ($i = 0; $i < $count; $i++) {
  1039.                     $workExperienceData[] = [
  1040.                         'title' => $workExperienceDataRaw['title'][$i] ?? '',
  1041.                         'companyName' => $workExperienceDataRaw['companyName'][$i] ?? '',
  1042.                         'jobStartDate' => $workExperienceDataRaw['jobStartDate'][$i] ?? '',
  1043.                         'jobEndDate' => $workExperienceDataRaw['jobEndDate'][$i] ?? '',
  1044.                         'description' => $workExperienceDataRaw['description'][$i] ?? '',
  1045.                     ];
  1046.                 }
  1047.             }
  1049.             $certificateData = [];
  1050.             if ($certificateDataRaw && isset($certificateDataRaw['certificatename'])) {
  1051.                 $count = count($certificateDataRaw['certificatename']);
  1052.                 for ($i = 0; $i < $count; $i++) {
  1053.                     $certificateData[] = [
  1054.                         'certificatename' => $certificateDataRaw['certificatename'][$i] ?? '',
  1055.                         'issuedDate' => $certificateDataRaw['issuedDate'][$i] ?? '',
  1056.                     ];
  1057.                 }
  1058.             }
  1059.             $data = [
  1060.                 'id' => $applicant->getApplicantId(),
  1061.                 'username' => $applicant->getUsername(),
  1062.                 'email' => $applicant->getEmail(),
  1063.                 'firstname' => $applicant->getFirstname(),
  1064.                 'lastname' => $applicant->getLastname(),
  1065.                 'phone' => $applicant->getPhone(),
  1066.                 'accountStatus' => $applicant->getAccountStatus(),
  1067.                 'educationData' => $educationData,
  1068.                 'workExperienceData' => $workExperienceData,
  1069.                 'certificateData' => $certificateData,
  1070.                 'skill' => [
  1071.                     'php',
  1072.                     'java'
  1073.                 ],
  1074.                 'jobDone' => 3,
  1075.                 'pointsEarned' => 200,
  1076.                 'reviews' => 4.8,
  1077.                 'userImage' => $absoluteUrl . '' . $userImage
  1079.             ];
  1080.             $data['Contract'] = [
  1081.                 'supplierName' => 'test',
  1082.                 'Date' => '25-10-2025',
  1083.                 'Summary' => 'summary'
  1084.             ];
  1085.             return new JsonResponse([
  1086.                 'success' => true,
  1087.                 'data' => $data,
  1088.             ]);
  1090.         }
  1091.         catch (\Exception $e) {
  1092.             return new JsonResponse([
  1093.                 'success' => false,
  1094.                 'error' => [
  1095.                     'code' => 'INTERNAL_ERROR',
  1096.                     'message' => 'Something went wrong',
  1097.                     'statusCode' => 500,
  1098.                 ]
  1099.             ], 500);
  1100.         }
  1101.     }
  1102.     public function summaryPlanAction(Request $request)
  1103.     {
  1104.         $em_goc = $this->getDoctrine()->getManager('company_group');
  1105.         $session = $request->getSession();
  1106.         $userId = $session->get(UserConstants::USER_ID);
  1108.         $invoiceDetails = $em_goc->getRepository('CompanyGroupBundle\Entity\EntityInvoice')->findBy(
  1109.             [
  1110.                 'applicantId' => $userId,
  1111.             ]
  1112.         );
  1113.         return $this->render('@HoneybeeWeb/pages/summaryPlan.html.twig', [
  1114.             'page_title' => 'Invoice Summary',
  1115.             'invoiceDetails' => $invoiceDetails,
  1116.         ]);
  1117.     }
  1119. }