src/ApplicationBundle/Modules/HoneybeeWeb/Controller/HoneybeeWebPublicController.php line 228

Open in your IDE?
  1. <?php
  3. namespace ApplicationBundle\Modules\HoneybeeWeb\Controller;
  6. use ApplicationBundle\Constants\BuddybeeConstant;
  7. use ApplicationBundle\Constants\EmployeeConstant;
  8. use ApplicationBundle\Constants\GeneralConstant;
  9. use ApplicationBundle\Controller\GenericController;
  10. use ApplicationBundle\Entity\DatevToken;
  11. use ApplicationBundle\Modules\Authentication\Constants\UserConstants; use ApplicationBundle\Modules\Api\Constants\ApiConstants;
  12. use ApplicationBundle\Modules\Buddybee\Buddybee;
  13. use ApplicationBundle\Modules\System\MiscActions;
  14. use CompanyGroupBundle\Entity\EntityCreateTopic;
  15. use CompanyGroupBundle\Entity\PaymentMethod;
  16. use CompanyGroupBundle\Entity\EntityDatevToken;
  17. use CompanyGroupBundle\Entity\Device;
  18. use CompanyGroupBundle\Entity\EntityInvoice;
  19. use CompanyGroupBundle\Entity\EntityMeetingSession;
  20. use CompanyGroupBundle\Entity\EntityTicket;
  21. use Endroid\QrCode\Builder\BuilderInterface;
  22. use Endroid\QrCodeBundle\Response\QrCodeResponse;
  23. use Ps\PdfBundle\Annotation\Pdf;
  24. use Symfony\Component\HttpFoundation\JsonResponse;
  25. use Symfony\Component\HttpFoundation\Request;
  26. use CompanyGroupBundle\Entity\EntityApplicantDetails;
  27. use Symfony\Component\HttpFoundation\Response;
  28. use Symfony\Component\Routing\Generator\UrlGenerator;
  29. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  30. //use Symfony\Bundle\FrameworkBundle\Console\Application;
  31. //use Symfony\Component\Console\Input\ArrayInput;
  32. //use Symfony\Component\Console\Output\NullOutput;
  35. class HoneybeeWebPublicController extends GenericController
  36. {
  38.     private function getPublicDocumentEntityManager($appId)
  39.     {
  40.         $emGoc = $this->getDoctrine()->getManager('company_group');
  41.         $emGoc->getConnection()->connect();
  43.         $goc = $emGoc
  44.             ->getRepository("CompanyGroupBundle\\Entity\\CompanyGroup")
  45.             ->findOneBy(
  46.                 array(
  47.                     'appId' => $appId
  48.                 )
  49.             );
  51.         if (!$goc) {
  52.             return array(null, null);
  53.         }
  55.         $connector = $this->container->get('application_connector');
  56.         $connector->resetConnection(
  57.             'default',
  58.             $goc->getDbName(),
  59.             $goc->getDbUser(),
  60.             $goc->getDbPass(),
  61.             $goc->getDbHost(),
  62.             $reset = true
  63.         );
  65.         return array($this->getDoctrine()->getManager(), $goc);
  66.     }
  67.     // home page
  68.     public function CentralHomePageAction(Request $request)
  69.     {
  70.         $em = $this->getDoctrine()->getManager('company_group');
  71.         $subscribed = false;
  73.         if ($request->isMethod('POST')) {
  75.             $entityTicket = new EntityTicket();
  76.             $entityTicket->setEmail($request->request->get('newsletter'));
  78.             $em->persist($entityTicket);
  79.             $em->flush();
  81.             $subscribed = true;
  82.         }
  84.         return $this->render('@HoneybeeWeb/pages/home.html.twig', [
  85.             'page_title' => 'HoneyBee — Project ERP + Business ERP + HoneyCore Edge EMS',
  86.             'og_title' => 'HoneyBee — Business + Energy Infrastructure. One Operating System.',
  87.             'og_description' => 'HoneyBee connects Business ERP, Project ERP, HoneyCore Edge EMS, AI and mobile field operations in one ecosystem — so business, project, finance, site, asset and energy data work together.',
  88.             'subscribed' => $subscribed,
  89.             'packageDetails' => GeneralConstant::$packageDetails,
  90.         ]);
  91.     }
  93.     // about us
  94.     public function CentralAboutUsPageAction()
  95.     {
  96.         return $this->render('@HoneybeeWeb/pages/about_us.html.twig', array(
  97.                 'page_title'     => 'About HoneyBee | Building the Operating System for Project Businesses & Energy Infrastructure',
  98.                 'og_title'       => 'About HoneyBee | Building the Operating System for Project Businesses & Energy Infrastructure',
  99.                 'og_description' => 'HoneyBee is a Germany/EU + Singapore-oriented software ecosystem connecting Business ERP, Project ERP, HoneyCore Edge EMS, AI, and mobile operations — with engineering, development, implementation, and regional support from Bangladesh.',
  100.                 'packageDetails' => GeneralConstant::$packageDetails,
  101.         ));
  102.     }
  104.     // Contact page
  105.     public function CentralContactPageAction(Request $request)
  106.     {
  108.         $em = $this->getDoctrine()->getManager('company_group');
  110.         if ($request->isXmlHttpRequest()) {
  112.             $email = $request->request->get('email');
  114.             if ($email) {
  115.                 // Enrich the message with the 3-step form selectors (need / company type / phone),
  116.                 // and persist any uploaded workflow/site-requirement file (graceful if absent).
  117.                 $bodyParts = [trim((string) $request->request->get('message', ''))];
  118.                 $need = trim((string) $request->request->get('enquiry_need', ''));
  119.                 $companyType = trim((string) $request->request->get('company_type', ''));
  120.                 $phone = trim((string) $request->request->get('phone', ''));
  121.                 if ($need !== '')        { $bodyParts[] = 'Need: ' . $need; }
  122.                 if ($companyType !== '') { $bodyParts[] = 'Company type: ' . $companyType; }
  123.                 if ($phone !== '')       { $bodyParts[] = 'Phone: ' . $phone; }
  125.                 $uploaded = $request->files->get('workflow_file');
  126.                 if ($uploaded) {
  127.                     try {
  128.                         $projectDir = $this->getParameter('kernel.project_dir');
  129.                         $relDir = 'uploads/contact/' . date('Y/m');
  130.                         $absDir = rtrim($projectDir, DIRECTORY_SEPARATOR) . DIRECTORY_SEPARATOR . 'web' . DIRECTORY_SEPARATOR . str_replace('/', DIRECTORY_SEPARATOR, $relDir);
  131.                         if (!is_dir($absDir)) { @mkdir($absDir, 0775, true); }
  132.                         $ext  = method_exists($uploaded, 'guessExtension') ? ($uploaded->guessExtension() ?: 'dat') : 'dat';
  133.                         $name = 'contact_' . date('YmdHis') . '_' . mt_rand(1000, 9999) . '.' . $ext;
  134.                         $uploaded->move($absDir, $name);
  135.                         $bodyParts[] = 'Attachment: /' . $relDir . '/' . $name;
  136.                     } catch (\Throwable $e) { /* non-fatal: still save the message */ }
  137.                 }
  139.                 $entityTicket = new EntityTicket();
  140.                 $entityTicket->setEmail($email);
  141.                 $entityTicket->setName($request->request->get('name'));
  142.                 $entityTicket->setTitle($request->request->get('subject'));
  143.                 $entityTicket->setTicketBody(implode("\n", array_filter($bodyParts)));
  145.                 $em->persist($entityTicket);
  146.                 $em->flush();
  148.                 return new JsonResponse([
  149.                     'success' => true,
  150.                     'message' => 'Your message has been sent successfully. Our team will reply soon.'
  151.                 ]);
  152.             }
  154.             return new JsonResponse([
  155.                 'success' => false,
  156.                 'message' => 'Invalid email address.'
  157.             ]);
  158.         }
  160.         return $this->render('@HoneybeeWeb/pages/contact.html.twig', array(
  161.             'page_title' => 'Request a HoneyBee Project Solution | HoneyCore Edge+, IoT, Billing & AI Deployment',
  162.             'og_title' => 'Request a HoneyBee Project Solution | HoneyCore Edge+, IoT, Billing & AI Deployment',
  163.             'og_description' => 'Tell us about your EPC, energy asset, HoneyCore Edge+ or multi-site project. A HoneyBee solutions engineer will respond with a tailored deployment plan.',
  164.         ));
  165.         
  166.     }
  168.     // blogs
  169.     public function CentralBlogsPageAction(Request $request)
  170.     {
  171.         $em = $this->getDoctrine()->getManager('company_group');
  173.         $topicDetails = $em->getRepository('CompanyGroupBundle\Entity\EntityCreateTopic')->findAll();
  174.         $repo         = $em->getRepository('CompanyGroupBundle\Entity\EntityCreateBlog');
  176.         // ── Fetch featured blog separately (always, regardless of page) ──
  177.         $featuredBlog = $repo->findOneBy(['isPrimaryBlog' => true]);
  179.         // ── Pagination ──
  180.         $page       = max(1, (int) $request->query->get('page', 1));
  181.         $limit      = 6;
  182.         $totalBlogs = count($repo->findAll());
  183.         $totalPages = max(1, (int) ceil($totalBlogs / $limit));
  184.         $page       = min($page, $totalPages);
  185.         $offset     = ($page - 1) * $limit;
  187.         $blogDetails = $repo->findBy([], ['Id' => 'DESC'], $limit, $offset);
  189.         return $this->render('@HoneybeeWeb/pages/blogs.html.twig', [
  190.             'page_title'   => 'Blogs',
  191.             'topics'       => $topicDetails,
  192.             'blogs'        => $blogDetails,
  193.             'featuredBlog' => $featuredBlog,
  194.             'currentPage'  => $page,
  195.             'totalPages'   => $totalPages,
  196.             'totalBlogs'   => $totalBlogs,
  197.         ]);
  198.     }
  199.     // product
  200.     public function CentralProductPageAction()
  201.     {
  202.         return $this->render('@HoneybeeWeb/pages/product.html.twig', array(
  203.             'page_title' => 'HoneyBee Platform | One ecosystem, four connected layers',
  204.             'og_description' => 'Business ERP, Project ERP, HoneyCore Edge EMS, AI and mobile — one connected platform, not bolted-together tools.',
  205.         ));
  206.     }
  208.     // ── Phase 2 marketing pages (website restructure) ──
  209.     public function CentralProjectErpPageAction()
  210.     {
  211.         return $this->render('@HoneybeeWeb/pages/project_erp.html.twig', array(
  212.             'page_title' => 'Project ERP for EPC, Engineering & Solar | HoneyBee',
  213.             'og_description' => 'Control every project from quotation to cash collection: BoQ, procurement, site execution, milestone billing, retention, O&M, profitability — plus HoneyCore Edge+ project workflows.',
  214.         ));
  215.     }
  217.     public function CentralBusinessErpPageAction()
  218.     {
  219.         return $this->render('@HoneybeeWeb/pages/business_erp.html.twig', array(
  220.             'page_title' => 'Business ERP for SMEs | HR, Accounts, Inventory, CRM — HoneyBee',
  221.             'og_description' => 'Affordable, modular Business ERP for growing SMEs in Europe and Singapore. Start small, expand when ready — from €7.99/user/month.',
  222.         ));
  223.     }
  225.     public function CentralEdgePageAction()
  226.     {
  227.         return $this->render('@HoneybeeWeb/pages/honeycore_edge.html.twig', array(
  228.             'page_title' => 'HoneyCore Edge EMS | Energy & Site Intelligence — HoneyBee',
  229.             'og_description' => 'Connect solar PV, grid, generators, batteries, meters and sensors with O&M, billing, finance and reporting through HoneyCore Edge EMS site intelligence.',
  230.         ));
  231.     }
  233.     public function CentralEdgeProjectsPageAction()
  234.     {
  235.         return $this->render('@HoneybeeWeb/pages/honeycore_edge_projects.html.twig', array(
  236.             'page_title' => 'HoneyCore Edge+ Design & Quotation Software | HoneyBee',
  237.             'og_description' => 'Turn site requirements into HoneyCore Edge+ architecture, sensor/meter schedules, BoQ, quotation, commissioning checklist and O&M workflow.',
  238.         ));
  239.     }
  241.     public function CentralExperiencePageAction()
  242.     {
  243.         return $this->render('@HoneybeeWeb/pages/experience.html.twig', array(
  244.             'page_title' => 'Experience & Proof | HoneyBee',
  245.             'og_description' => 'Built from real ERP, project, HoneyCore Edge EMS and SME digital-transformation experience — with Germany/EU product focus and a Singapore SaaS base.',
  246.         ));
  247.     }
  249.     public function CentralTrustPageAction()
  250.     {
  251.         return $this->render('@HoneybeeWeb/pages/trust_governance.html.twig', array(
  252.             'page_title' => 'Trust & Governance | Security & Standards — HoneyBee',
  253.             'og_description' => 'Operator-owned data, RBAC, audit trails, NIS2-aware governance and a clear, no-overclaim standards map with claim-control categories.',
  254.         ));
  255.     }
  257.     // ── Investor Snapshot (Phase C) ──
  258.     public function CentralInvestorPageAction()
  259.     {
  260.         return $this->render('@HoneybeeWeb/pages/investor_snapshot.html.twig', array(
  261.             'page_title'     => 'Investor Snapshot | HoneyBee — Business + Energy Infrastructure OS',
  262.             'og_description' => 'HoneyBee is a vertical operating system for project-based energy, engineering and industrial companies — positioning, ICP, revenue model and defensibility. No invented metrics.',
  263.         ));
  264.     }
  266.     // ── Competitor comparison pages (Phase C) ──
  267.     public function CentralComparePageAction($slug)
  268.     {
  269.         $meta = [
  270.             'odoo'                       => ['HoneyBee vs Odoo | Project & Energy ERP Comparison', 'Odoo is a broad ERP suite. HoneyBee is built around project execution, EPC workflows, field operations and energy-infrastructure intelligence.'],
  271.             'zoho'                       => ['HoneyBee vs Zoho | ERP for Project & Energy Companies', 'Zoho covers general business apps. HoneyBee connects ERP, project execution, finance, O&M and HoneyCore energy data in one workflow.'],
  272.             'sap-business-one'           => ['HoneyBee vs SAP Business One | Project ERP Comparison', 'SAP Business One suits general operations. HoneyBee adds deep EPC/project execution and energy-infrastructure intelligence.'],
  273.             'microsoft-business-central' => ['HoneyBee vs Microsoft Business Central | Comparison', 'Business Central is a broad ERP. HoneyBee is purpose-built for project-based energy, engineering and industrial companies.'],
  274.             'monday-clickup'             => ['HoneyBee vs Monday / ClickUp | Beyond Task Management', 'Monday and ClickUp manage tasks. HoneyBee connects tasks with quotation, BoQ, procurement, billing, finance and energy data.'],
  275.             'excel'                      => ['HoneyBee vs Excel | From Spreadsheets to an Operating System', 'Excel is flexible but fragile. HoneyBee gives structure, audit trail, approvals, real-time data and automation.'],
  276.             'scada-ems'                  => ['HoneyBee vs SCADA / EMS Dashboards | Asset Data to Business', 'SCADA/EMS tools monitor assets. HoneyBee connects asset data with ERP, O&M, billing, reporting and AI.'],
  277.         ];
  278.         if (!isset($meta[$slug])) { throw $this->createNotFoundException(); }
  279.         return $this->render('@HoneybeeWeb/pages/compare/' . $slug . '.html.twig', array(
  280.             'page_title'     => $meta[$slug][0],
  281.             'og_description' => $meta[$slug][1],
  282.             'compare_slug'   => $slug,
  283.         ));
  284.     }
  286.     // ── SEO solution landing pages (Phase C) ──
  287.     public function CentralSolutionPageAction($slug)
  288.     {
  289.         $meta = [
  290.             'erp-for-solar-epc'      => ['ERP for Solar EPC Companies | HoneyBee Project ERP', 'Project ERP for solar EPC: quotation, BoQ, procurement, site execution, milestone billing, O&M and HoneyCore Edge EMS energy intelligence.'],
  291.             'erp-for-engineering'    => ['ERP for Engineering Companies | HoneyBee Project ERP', 'Control engineering projects from quotation to delivery, billing and profitability with HoneyBee Project ERP.'],
  292.             'erp-for-construction'   => ['ERP for Construction Project Companies | HoneyBee', 'BoQ, procurement, site execution, milestone billing and retention for construction project companies.'],
  293.             'erp-for-om'             => ['ERP for O&M Companies | HoneyBee', 'Connect O&M workflows with billing, reporting and energy-asset data through HoneyBee and HoneyCore Edge EMS.'],
  294.             'erp-for-trading'        => ['ERP for Trading & Distribution Companies | HoneyBee', 'HR, accounts, inventory, sales, purchase and CRM for trading and distribution companies.'],
  295.             'project-erp-bangladesh' => ['Project ERP for Bangladesh SMEs | HoneyBee', 'Affordable project ERP for Bangladesh SMEs — quotation, procurement, site execution, billing and reporting.'],
  296.             'project-erp-singapore'  => ['Project ERP for Singapore SMEs | HoneyBee', 'Project ERP for Singapore SMEs and project-based companies — execution, finance and reporting in one system.'],
  297.             'project-erp-germany'    => ['Project ERP for German Energy Companies | HoneyBee', 'Project ERP for German energy and engineering companies, DATEV-ready export and GoBD-aligned audit trail where implemented.'],
  298.             'honeycore-solar-pv'     => ['HoneyCore for Solar PV Monitoring | HoneyBee', 'HoneyCore Edge EMS connects solar PV, inverters and meters with O&M, billing, reporting and AI.'],
  299.             'honeycore-hybrid-energy'=> ['HoneyCore for Hybrid Energy Systems | HoneyBee', 'Monitor solar, battery, generator and grid in hybrid energy systems with HoneyCore Edge EMS.'],
  300.             'honeycore-cold-chain'   => ['HoneyCore for Cold Chain & Healthcare Infrastructure | HoneyBee', 'Temperature, energy and utility monitoring for cold-chain and healthcare infrastructure with HoneyCore Edge EMS.'],
  301.             'honeycore-agri-pv'      => ['HoneyCore for Agri-PV & Irrigation | HoneyBee', 'Connect solar generation, soil and irrigation data with HoneyCore Edge EMS for Agri-PV and solar irrigation.'],
  302.         ];
  303.         if (!isset($meta[$slug])) { throw $this->createNotFoundException(); }
  304.         return $this->render('@HoneybeeWeb/pages/solutions/' . $slug . '.html.twig', array(
  305.             'page_title'     => $meta[$slug][0],
  306.             'og_description' => $meta[$slug][1],
  307.             'solution_slug'  => $slug,
  308.         ));
  309.     }
  311.     // ── Calculators (Phase D) ──
  312.     public function CentralToolPageAction($slug)
  313.     {
  314.         $meta = [
  315.             'cost-leakage-calculator'   => ['Project Cost Leakage Calculator | HoneyBee', 'Estimate the hidden annual loss from delays, procurement leakage, billing delays and inventory loss — and the right HoneyBee path.'],
  316.             'roi-calculator'            => ['ERP ROI Calculator | HoneyBee', 'Estimate time saved and monthly savings from HoneyBee across approvals, invoices and projects.'],
  317.             'site-assessment-estimator' => ['HoneyCore Site Assessment Estimator | HoneyBee', 'Estimate your HoneyCore site assessment scope from sites, PV capacity, meters, inverters and protocols.'],
  318.             'rooftop-estimate'          => ['Instant Rooftop Solar Estimate | HoneyBee', 'Draw your roof on the map and get an instant indicative solar sizing, BoQ and payback for C&I rooftop solar — powered by PVGIS yield data.'],
  319.         ];
  320.         if (!isset($meta[$slug])) { throw $this->createNotFoundException(); }
  321.         return $this->render('@HoneybeeWeb/pages/tools/' . $slug . '.html.twig', array(
  322.             'page_title'     => $meta[$slug][0],
  323.             'og_description' => $meta[$slug][1],
  324.             'tool_slug'      => $slug,
  325.         ));
  326.     }
  328.     const HB_MAPS_KEY = 'AIzaSyBJxyUy8a_U2rSdIUApVDoK_dcvgGkoeDk';
  330.     // ── Rooftop estimate — MANUAL draw endpoint (area + coords from the map) ──
  331.     public function CentralRooftopCalcAction(Request $request)
  332.     {
  333.         $lat     = (float) $request->request->get('lat', 0);
  334.         $lng     = (float) $request->request->get('lng', 0);
  335.         $area    = (float) $request->request->get('area_m2', 0);
  336.         $mode    = $request->request->get('mode', 'roof');
  337.         $monthly = (float) $request->request->get('monthly_kwh', 0);
  338.         $tariff  = (float) $request->request->get('tariff', 0.22);
  339.         $tilt    = (float) $request->request->get('tilt', 10);
  341.         if ($area <= 5 || $lat == 0) {
  342.             return new JsonResponse(['ok' => false, 'error' => 'Draw a roof outline on the map first.']);
  343.         }
  344.         $res = $this->computeRooftopDesign($lat, $lng, $area, $tilt, $mode, $monthly, $tariff, null);
  345.         $res['roof_source'] = 'Map outline';
  346.         return new JsonResponse($res);
  347.     }
  349.     // ── Rooftop estimate — AUTO from ADDRESS (geocode → Google Solar API → OSM footprint → PVGIS) ──
  350.     public function CentralRooftopAutoAction(Request $request)
  351.     {
  352.         $address = trim((string) $request->request->get('address', ''));
  353.         $mode    = $request->request->get('mode', 'roof');
  354.         $monthly = (float) $request->request->get('monthly_kwh', 0);
  355.         $tariff  = (float) $request->request->get('tariff', 0.22);
  356.         $tilt    = (float) $request->request->get('tilt', 10);
  358.         if ($address === '') {
  359.             return new JsonResponse(['ok' => false, 'error' => 'Enter an address first.']);
  360.         }
  361.         $geo = $this->geocodeAddress($address);
  362.         if ($geo === null) {
  363.             return new JsonResponse(['ok' => false, 'error' => 'Address not found — try a more specific address.']);
  364.         }
  365.         $lat = $geo['lat']; $lng = $geo['lng'];
  367.         // Tier 1: Google Solar API (best — real roof + panel layout). Null when API disabled / no coverage.
  368.         $preset = $this->solarApiDesign($lat, $lng);
  369.         $roofSource = null; $area = null;
  370.         if ($preset !== null) {
  371.             $area = $preset['roof_area']; $roofSource = 'Google Solar API';
  372.         } else {
  373.             // Tier 2: OSM building footprint (free, global where mapped).
  374.             $area = $this->osmBuildingArea($lat, $lng);
  375.             if ($area !== null) { $roofSource = 'OSM building footprint'; }
  376.         }
  378.         if ($area === null || $area < 10) {
  379.             // Tier 3: hand off to manual draw at the geocoded location.
  380.             return new JsonResponse([
  381.                 'ok' => false, 'needs_manual' => true,
  382.                 'lat' => $lat, 'lng' => $lng, 'formatted_address' => $geo['formatted'],
  383.                 'error' => 'Could not auto-detect the roof at this address — trace it on the map below.',
  384.             ]);
  385.         }
  387.         $res = $this->computeRooftopDesign($lat, $lng, $area, $tilt, $mode, $monthly, $tariff, $preset);
  388.         $res['lat'] = $lat; $res['lng'] = $lng;
  389.         $res['formatted_address'] = $geo['formatted'];
  390.         $res['roof_source'] = $roofSource;
  391.         return new JsonResponse($res);
  392.     }
  394.     /** Shared sizing + parametric BoQ + financials. $preset (Google Solar API) overrides area-based sizing. */
  395.     private function computeRooftopDesign($lat, $lng, $area, $tilt, $mode, $monthly, $tariff, $preset = null)
  396.     {
  397.         if ($tariff <= 0) { $tariff = 0.22; }
  399.         $yieldSource   = 'PVGIS';
  400.         $specificYield = $this->pvgisSpecificYield($lat, $lng, $tilt);
  401.         if ($specificYield === null) {
  402.             $specificYield = $this->fallbackYieldByLatitude($lat);
  403.             $yieldSource = 'climate estimate';
  404.         }
  406.         $panelKw = 0.55;
  407.         if ($preset !== null && !empty($preset['panel_watts'])) { $panelKw = $preset['panel_watts'] / 1000.0; }
  409.         // Roof-capacity sizing
  410.         if ($preset !== null && !empty($preset['panels'])) {
  411.             $roofPanels = (int) $preset['panels'];
  412.             $roofKwp    = round($roofPanels * $panelKw, 1);
  413.             $usable     = round($area);                 // Solar API area is already usable roof
  414.             $genFull    = !empty($preset['annual_dc_kwh']) ? $preset['annual_dc_kwh'] * 0.86 : $roofKwp * $specificYield; // DC→AC
  415.         } else {
  416.             $usable     = $area * 0.65;                 // setbacks/walkways/plant
  417.             $roofPanels = (int) floor($usable / 2.4);
  418.             $roofKwp    = round($roofPanels * $panelKw, 1);
  419.             $genFull    = $roofKwp * $specificYield;
  420.         }
  422.         $panels = $roofPanels; $kwp = $roofKwp; $annualGen = $genFull;
  423.         if ($mode === 'load' && $monthly > 0 && $roofKwp > 0) {
  424.             $annualNeed = $monthly * 12 * 0.85;
  425.             $kwpNeeded  = $annualNeed / max($specificYield, 1);
  426.             $kwp        = round(min($kwpNeeded, $roofKwp), 1);
  427.             $panels     = (int) round($kwp / $panelKw);
  428.             $annualGen  = round($genFull * ($roofKwp > 0 ? $kwp / $roofKwp : 1));
  429.         }
  430.         $annualGen = round($annualGen);
  432.         if ($kwp <= 0) {
  433.             return ['ok' => false, 'error' => 'The detected roof is too small for a viable array.'];
  434.         }
  436.         $rows = [
  437.             ['PV modules (~550 Wp)',               $panels,                          'pcs',   95.0],
  438.             ['String inverters',                   max(1, (int) ceil($kwp / 25)),    'units', round($kwp * 55 / max(1, (int) ceil($kwp / 25)), 0)],
  439.             ['Mounting & racking structure',       $panels,                          'sets',  38.0],
  440.             ['DC + AC cabling & protection',       round($kwp, 1),                   'kWp',   75.0],
  441.             ['Combiner, SPD & breakers',           round($kwp, 1),                   'kWp',   45.0],
  442.             ['HoneyCore Edge EMS gateway + meter', 1,                                'lot',   1000.0],
  443.             ['Installation, commissioning & BoS',  round($kwp, 1),                   'kWp',   190.0],
  444.         ];
  445.         $boq = []; $capex = 0.0;
  446.         foreach ($rows as $r) {
  447.             $total = round($r[1] * $r[3], 0);
  448.             $capex += $total;
  449.             $boq[] = ['item' => $r[0], 'qty' => $r[1], 'unit' => $r[2], 'unit_price' => $r[3], 'total' => $total];
  450.         }
  451.         $capex = round($capex, 0);
  453.         $annualSavings = round($annualGen * $tariff, 0);
  454.         $payback       = $annualSavings > 0 ? round($capex / $annualSavings, 1) : null;
  455.         $co2           = round($annualGen * 0.35 / 1000, 1);
  457.         return [
  458.             'ok' => true, 'mode' => $mode,
  459.             'area_m2' => round($area), 'usable_m2' => round($usable),
  460.             'kwp' => $kwp, 'panels' => $panels,
  461.             'specific_yield' => round($specificYield), 'annual_gen_kwh' => $annualGen,
  462.             'capex_eur' => $capex, 'eur_per_kwp' => $kwp > 0 ? round($capex / $kwp, 0) : 0,
  463.             'boq' => $boq, 'tariff' => $tariff,
  464.             'annual_savings' => $annualSavings, 'payback_years' => $payback, 'co2_tonnes_yr' => $co2,
  465.             'yield_source' => $yieldSource,
  466.             'disclaimer' => 'Indicative estimate only — not a quote. Final sizing, BoQ and pricing are confirmed after a HoneyCore site assessment (structural, shading, electrical and tariff review).',
  467.         ];
  468.     }
  470.     /** Geocode an address → ['lat','lng','formatted'] or null. */
  471.     private function geocodeAddress($address)
  472.     {
  473.         $url  = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . rawurlencode($address) . '&key=' . self::HB_MAPS_KEY;
  474.         $data = $this->httpJson($url, null, 8);
  475.         if (!$data || ($data['status'] ?? '') !== 'OK' || empty($data['results'][0])) { return null; }
  476.         $r = $data['results'][0];
  477.         return [
  478.             'lat'       => (float) $r['geometry']['location']['lat'],
  479.             'lng'       => (float) $r['geometry']['location']['lng'],
  480.             'formatted' => $r['formatted_address'] ?? $address,
  481.         ];
  482.     }
  484.     /** Google Solar API building insights → preset design, or null if disabled / no coverage. */
  485.     private function solarApiDesign($lat, $lng)
  486.     {
  487.         $url  = sprintf('https://solar.googleapis.com/v1/buildingInsights:findClosest?location.latitude=%F&location.longitude=%F&requiredQuality=LOW&key=%s', $lat, $lng, self::HB_MAPS_KEY);
  488.         $data = $this->httpJson($url, null, 8);
  489.         if (!$data || isset($data['error']) || empty($data['solarPotential'])) { return null; }
  490.         $sp = $data['solarPotential'];
  491.         $roofArea = $sp['wholeRoofStats']['areaMeters2'] ?? ($sp['maxArrayAreaMeters2'] ?? null);
  492.         $panels   = $sp['maxArrayPanelsCount'] ?? null;
  493.         $watts    = $sp['panelCapacityWatts'] ?? 400;
  494.         if (!$roofArea || !$panels) { return null; }
  495.         // best (largest) config's annual DC energy
  496.         $annualDc = null;
  497.         foreach (($sp['solarPanelConfigs'] ?? []) as $cfg) {
  498.             if (isset($cfg['yearlyEnergyDcKwh'])) { $annualDc = $cfg['yearlyEnergyDcKwh']; }
  499.         }
  500.         return ['panels' => (int) $panels, 'panel_watts' => (float) $watts, 'annual_dc_kwh' => $annualDc, 'roof_area' => (float) $roofArea];
  501.     }
  503.     /** OSM building footprint area (m²) at a point via Overpass; null if none/unreachable. */
  504.     private function osmBuildingArea($lat, $lng)
  505.     {
  506.         $q    = sprintf('[out:json][timeout:20];way(around:30,%F,%F)[building];out geom;', $lat, $lng);
  507.         $data = $this->httpJson('https://overpass-api.de/api/interpreter', 'data=' . rawurlencode($q), 22);
  508.         if (!$data || empty($data['elements'])) { return null; }
  509.         $best = null; $bestArea = 0; $containing = null;
  510.         foreach ($data['elements'] as $el) {
  511.             if (empty($el['geometry'])) { continue; }
  512.             $a = $this->polygonAreaM2($el['geometry']);
  513.             if ($a > $bestArea) { $bestArea = $a; $best = $el; }
  514.             if ($this->pointInPolygon($lat, $lng, $el['geometry'])) { $containing = $a; }
  515.         }
  516.         $area = $containing ?: $bestArea;
  517.         return $area > 5 ? $area : null;
  518.     }
  520.     /** Planar area (m²) of a lat/lng ring via equirectangular projection. */
  521.     private function polygonAreaM2($geometry)
  522.     {
  523.         $rad = M_PI / 180; $R = 6378137;
  524.         $lat0 = $geometry[0]['lat'] * $rad; $cos = cos($lat0);
  525.         $pts = [];
  526.         foreach ($geometry as $g) { $pts[] = [$g['lon'] * $rad * $R * $cos, $g['lat'] * $rad * $R]; }
  527.         $n = count($pts); if ($n < 3) { return 0; }
  528.         $a = 0;
  529.         for ($i = 0; $i < $n - 1; $i++) { $a += $pts[$i][0] * $pts[$i + 1][1] - $pts[$i + 1][0] * $pts[$i][1]; }
  530.         return abs($a) / 2;
  531.     }
  533.     /** Ray-cast point-in-polygon for a lat/lng ring. */
  534.     private function pointInPolygon($lat, $lng, $geometry)
  535.     {
  536.         $in = false; $n = count($geometry);
  537.         for ($i = 0, $j = $n - 1; $i < $n; $j = $i++) {
  538.             $yi = $geometry[$i]['lat']; $xi = $geometry[$i]['lon'];
  539.             $yj = $geometry[$j]['lat']; $xj = $geometry[$j]['lon'];
  540.             if ((($yi > $lat) !== ($yj > $lat)) && ($lng < ($xj - $xi) * ($lat - $yi) / (($yj - $yi) ?: 1e-12) + $xi)) { $in = !$in; }
  541.         }
  542.         return $in;
  543.     }
  545.     /** Minimal JSON HTTP helper (GET when $post is null, else POST form body). Null on failure. */
  546.     private function httpJson($url, $post = null, $timeout = 8)
  547.     {
  548.         try {
  549.             $opts = ['http' => ['timeout' => $timeout, 'ignore_errors' => true, 'header' => "User-Agent: HoneyBee/1.0\r\n"]];
  550.             if ($post !== null) {
  551.                 $opts['http']['method']  = 'POST';
  552.                 $opts['http']['header'] .= "Content-Type: application/x-www-form-urlencoded\r\n";
  553.                 $opts['http']['content'] = $post;
  554.             }
  555.             $body = @file_get_contents($url, false, stream_context_create($opts));
  556.             if ($body === false) { return null; }
  557.             return json_decode($body, true);
  558.         } catch (\Throwable $e) {
  559.             return null;
  560.         }
  561.     }
  563.     /** Annual specific yield (kWh/kWp) from PVGIS for a fixed building-mounted array. Null on failure. */
  564.     private function pvgisSpecificYield($lat, $lng, $tilt)
  565.     {
  566.         $url = sprintf(
  567.             'https://re.jrc.ec.europa.eu/api/v5_2/PVcalc?lat=%F&lon=%F&peakpower=1&loss=14&angle=%F&aspect=0&mountingplace=building&outputformat=json',
  568.             $lat, $lng, $tilt
  569.         );
  570.         try {
  571.             $ctx  = stream_context_create(['http' => ['timeout' => 8, 'ignore_errors' => true]]);
  572.             $body = @file_get_contents($url, false, $ctx);
  573.             if ($body === false) { return null; }
  574.             $data = json_decode($body, true);
  575.             $ey = $data['outputs']['totals']['fixed']['E_y'] ?? null;
  576.             return ($ey && $ey > 0) ? (float) $ey : null;
  577.         } catch (\Throwable $e) {
  578.             return null;
  579.         }
  580.     }
  582.     /** Rough kWh/kWp/yr by absolute latitude when PVGIS is unreachable. */
  583.     private function fallbackYieldByLatitude($lat)
  584.     {
  585.         $a = abs($lat);
  586.         if ($a < 15) { return 1500; }   // tropical
  587.         if ($a < 25) { return 1450; }   // e.g. BD/SG belt
  588.         if ($a < 35) { return 1350; }   // subtropical
  589.         if ($a < 45) { return 1150; }   // southern EU
  590.         if ($a < 55) { return 1000; }   // central EU / DE
  591.         return 850;                     // northern EU
  592.     }
  594.     // our service
  595.     public function CentralServicePageAction()
  596.     {
  597.         return $this->render('@HoneybeeWeb/pages/service.html.twig', array(
  598.             'page_title' => 'Services | HoneyBee — Hardware, HoneyCore Edge EMS, Local ML & Integration',
  600.         ));
  601.     }
  603.     // payment method
  604.     public function CentralPaymentMethodPageAction()
  605.     {
  606.         $stripe_secret_key= $this->container->getParameter('stripe_secret_key_live');
  607.         $stripe_key= $this->container->getParameter('stripe_public_key_live');
  608.         return $this->render('@HoneybeeWeb/pages/payment-method.html.twig', array(
  609.             'page_title' => 'Payment Method',
  610.             'stripe_key' => $stripe_key,
  612.         ));
  613.     }
  615.     // single blog page
  616.     public function CentralSingleBlogPageAction(Request $request)
  617.     {
  618.         $em = $this->getDoctrine()->getManager('company_group');
  620.         $blogId = $request->query->get('id');
  622.         if (!$blogId) {
  623.             throw $this->createNotFoundException('Blog ID not provided.');
  624.         }
  626.         $blogDetails = $em->getRepository('CompanyGroupBundle\Entity\EntityCreateBlog')->find($blogId);
  628.         if (!$blogDetails) {
  629.             throw $this->createNotFoundException('Blog not found.');
  630.         }
  632.         // Fetch related blogs by same topic (optional but useful)
  633.         $relatedBlogs = $em->getRepository('CompanyGroupBundle\Entity\EntityCreateBlog')->findBy(
  634.             ['topicId' => $blogDetails->getTopicId()],
  635.             ['createdAt' => 'DESC'],
  636.             5
  637.         );
  639.         return $this->render('@HoneybeeWeb/pages/single_blog.html.twig', [
  640.             'page_title' => $blogDetails->getTitle(),
  641.             'blog'       => $blogDetails,
  642.             'related_blogs' => $relatedBlogs,
  643.         ]);
  644.     }
  646.     // login v2 (verification code page)
  647.     public function CentralLoginCodePageAction()
  648.     {
  649.         return $this->render('@HoneybeeWeb/pages/login_code.html.twig', array(
  650.             'page_title' => 'Verification Code',
  652.         ));
  653.     }
  656.     // reset pass
  657.     public function CentralResetPasswordPageAction()
  658.     {
  659.         return $this->render('@HoneybeeWeb/pages/reset_password.html.twig', array(
  660.             'page_title' => 'Verification Code',
  662.         ));
  663.     }
  665.     public function PublicProfilePageAction(Request $request, $id = 0)
  666.     {
  667.         $em = $this->getDoctrine()->getManager('company_group');
  668.         $session = $request->getSession();
  669.         return $this->render('@Application/pages/central/central_employee_profile.html.twig', array(
  670.             'page_title' => 'Freelancer Profile',
  671. //            'details' =>$em->getRepository(EntityApplicantDetails::class)->find($id),
  673.         ));
  674.     }
  677.     // freelancer profile
  678.     public function CentralApplicantProfilePageAction(Request $request, $id = 0)
  679.     {
  680.         $em = $this->getDoctrine()->getManager('company_group');
  681.         $session = $request->getSession();
  682.         return $this->render('@HoneybeeWeb/pages/freelancer_profile.html.twig', array(
  683.             'page_title' => 'Freelancer Profile',
  684.             'details' => $em->getRepository(EntityApplicantDetails::class)->find($id),
  686.         ));
  687.     }
  689.     // employee profile
  690.     public function PublicEmployeeProfileAction($id)
  691.     {
  692.         $em = $this->getDoctrine()->getManager('company_group');
  694.         if (strpos($id, 'E') !== false) {
  696.             $appId = 1 * substr($id, 1, 5);
  697.             $empId = 1 * substr($id, 6, 10);
  699.             $entry = $em->getRepository('CompanyGroupBundle\\Entity\\CompanyGroup')->findOneBy([
  700.                 'appId' => $appId
  701.             ]);
  704.             $curl = curl_init();
  705.             curl_setopt_array($curl, [
  706.                 CURLOPT_RETURNTRANSFER => true,
  707.                 CURLOPT_POST => true,
  708.                 CURLOPT_URL => $entry->getCompanyGroupServerAddress() . '/GetGlobalIdFromEmployeeId',
  709.                 CURLOPT_CONNECTTIMEOUT => 10,
  710.                 CURLOPT_SSL_VERIFYPEER => false,
  711.                 CURLOPT_SSL_VERIFYHOST => false,
  712.                 CURLOPT_HTTPHEADER => [
  713.                     'Accept: application/json',
  714. //                    'Content-Type: application/json'
  715.                 ],
  716.                 CURLOPT_POSTFIELDS => http_build_query([
  717.                     'employeeId' => $empId,
  718.                     'appId' => $appId
  719.                 ])
  720.             ]);
  722.             $id = curl_exec($curl);
  723.             $err = curl_error($curl);
  724.             curl_close($curl);
  726.             $id = json_decode($id, true)['globalId'];
  729.         }
  732.         $data = $em->getRepository(EntityApplicantDetails::class)->find($id);
  733.         return $this->render('@HoneybeeWeb/pages/public_profile.html.twig', array(
  734.             'page_title' => 'Employee Profile',
  735.             'details' => $data,
  736.             'genderList' => EmployeeConstant::$sex,
  737.             'bloodGroupList' => EmployeeConstant::$BloodGroup,
  738.         ));
  739.     }
  742.     // add employee
  743.     public function CentralAddEmployeePageAction()
  744.     {
  745.         return $this->render('@HoneybeeWeb/pages/add_employee.html.twig', array(
  746.             'page_title' => 'Add New Eployee',
  748.         ));
  749.     }
  751.     // book appointment
  752.     public function CentralBookAppointmentPageAction()
  753.     {
  754.         return $this->render('@HoneybeeWeb/pages/book_appointment.html.twig', array(
  755.             'page_title' => 'Book Appointment',
  757.         ));
  758.     }
  760.     // create_compnay
  761.     public function CentralCreateCompanyPageAction()
  762.     {
  763.         return $this->render('@HoneybeeWeb/pages/create_company.html.twig', array(
  764.             'page_title' => 'Create Company',
  766.         ));
  767.     }
  769.     // role and company
  770.     public function CentralRoleAndCompanyPageAction()
  771.     {
  772.         return $this->render('@HoneybeeWeb/pages/role_and_company.html.twig', array(
  773.             'page_title' => 'Role and Company',
  775.         ));
  776.     }
  778.     // send otp action **
  779.     public function SendOtpAjaxAction(Request $request, $startFrom = 0)
  780.     {
  782.         $em = $this->getDoctrine()->getManager();
  783.         $em_goc = $this->getDoctrine()->getManager('company_group');
  784.         $session = $request->getSession();
  785.         $message = "";
  786.         $retData = array();
  787.         $email_twig_data = array('success' => false);
  788.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  789.         $userCategory = $request->request->get('userCategory', $request->query->get('userCategory', '_BUDDYBEE_USER_'));
  790.         $email_address = $request->request->get('email', $request->query->get('email', ''));
  791.         $otpExpireSecond = $request->request->get('otpExpireSecond', $request->query->get('otpExpireSecond', 180));
  792.         $otpActionId = $request->request->get('otpActionId', $request->query->get('otpActionId', UserConstants::OTP_ACTION_FORGOT_PASSWORD));
  793.         $appendCode = $request->request->get('appendCode', $request->query->get('appendCode', ''));
  794.         $otp = $request->request->get('otp', $request->query->get('otp', ''));
  795.         $otpExpireTs = 0;
  796.         $userId = $request->request->get('userId', $request->query->get('userId', $session->get(UserConstants::USER_ID, 0)));
  797.         $userType = UserConstants::USER_TYPE_APPLICANT;
  798.         $email_twig_file = '@Application/pages/email/find_account_buddybee.html.twig';
  801.         if ($request->isMethod('POST')) {
  803.             //set an otp and its expire and send mail
  805.             $userObj = null;
  806.             $userData = [];
  809.             if ($systemType == '_ERP_') {
  810.                 if ($userCategory == '_APPLICANT_') {
  811.                     $userType = UserConstants::USER_TYPE_APPLICANT;
  813.                     $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  814.                         array(
  815.                             'applicantId' => $userId
  816.                         )
  817.                     );
  818.                     if ($userObj) {
  820.                     } else {
  821.                         $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  822.                             array(
  823.                                 'email' => $email_address
  824.                             )
  825.                         );
  827.                         if ($userObj) {
  830.                         } else {
  833.                             $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  834.                                 array(
  835.                                     'oAuthEmail' => $email_address
  836.                                 )
  837.                             );
  838.                             if ($userObj) {
  841.                             } else {
  844.                                 $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  845.                                     array(
  846.                                         'username' => $email_address
  847.                                     )
  848.                                 );
  851.                             }
  854.                         }
  855.                     }
  857.                     if ($userObj) {
  858.                         $email_address = $userObj->getEmail();
  859.                         if ($email_address == null || $email_address == '')
  860.                             $email_address = $userObj->getOAuthEmail();
  861.                     }
  864.                     $otpData = MiscActions::GenerateOtp($otpExpireSecond);
  865.                     $otp = $otpData['otp'];
  866.                     $otpExpireTs = $otpData['expireTs'];
  868.                     $userObj->setOtp($otpData['otp']);
  869.                     $userObj->setOtpActionId($otpActionId);
  870.                     $userObj->setOtpExpireTs($otpData['expireTs']);
  872.                     $em_goc->flush();
  873.                     $userData = array(
  874.                         'id' => $userObj->getApplicantId(),
  875.                         'email' => $email_address,
  876.                         'appId' => 0,
  877.                         //                        'appId'=>$userObj->getUserAppId(),
  878.                     );
  881.                     $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  882.                     $email_twig_data = [
  883.                         'page_title' => 'Find Account',
  884.                         'message' => $message,
  885.                         'userType' => $userType,
  886.                         'otp' => $otpData['otp'],
  887.                         'otpExpireSecond' => $otpExpireSecond,
  888.                         'otpActionId' => $otpActionId,
  889.                         'otpExpireTs' => $otpData['expireTs'],
  890.                         'systemType' => $systemType,
  891.                         'userData' => $userData
  893.                     ];
  894.                     if ($userObj)
  895.                         $email_twig_data['success'] = true;
  896.                 } else {
  897.                     $userType = UserConstants::USER_TYPE_GENERAL;
  898.                     $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  899.                     $email_twig_data = [
  900.                         'page_title' => 'Find Account',
  901.                         //   'encryptedData' => $encryptedData,
  902.                         'message' => $message,
  903.                         'userType' => $userType,
  904.                         //  'errorField' => $errorField,
  906.                     ];
  907.                 }
  910.             } else if ($systemType == '_BUDDYBEE_') {
  911.                 $userType = UserConstants::USER_TYPE_APPLICANT;
  913.                 $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  914.                     array(
  915.                         'applicantId' => $userId
  916.                     )
  917.                 );
  918.                 if ($userObj) {
  920.                 } else {
  921.                     $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  922.                         array(
  923.                             'email' => $email_address
  924.                         )
  925.                     );
  927.                     if ($userObj) {
  930.                     } else {
  933.                         $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  934.                             array(
  935.                                 'oAuthEmail' => $email_address
  936.                             )
  937.                         );
  938.                         if ($userObj) {
  941.                         } else {
  944.                             $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  945.                                 array(
  946.                                     'username' => $email_address
  947.                                 )
  948.                             );
  951.                         }
  954.                     }
  955.                 }
  957.                 if ($userObj) {
  958.                     $email_address = $userObj->getEmail();
  959.                     if ($email_address == null || $email_address == '')
  960.                         $email_address = $userObj->getOAuthEmail();
  961.                     //                    triggerResetPassword:
  962.                     //                    type: integer
  963.                     //                          nullable: true
  965.                     $otpData = MiscActions::GenerateOtp($otpExpireSecond);
  966.                     $otp = $otpData['otp'];
  967.                     $otpExpireTs = $otpData['expireTs'];
  969.                     $userObj->setOtp($otpData['otp']);
  970.                     $userObj->setOtpActionId($otpActionId);
  971.                     $userObj->setOtpExpireTs($otpData['expireTs']);
  973.                     $em_goc->flush();
  974.                     $userData = array(
  975.                         'id' => $userObj->getApplicantId(),
  976.                         'email' => $email_address,
  977.                         'appId' => 0,
  978.                         'image' => $userObj->getImage(),
  979.                         'phone' => $userObj->getPhone(),
  980.                         'firstName' => $userObj->getFirstname(),
  981.                         'lastName' => $userObj->getLastname(),
  982.                         //                        'appId'=>$userObj->getUserAppId(),
  983.                     );
  986.                     $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  987.                     $email_twig_data = [
  988.                         'page_title' => 'Find Account',
  989.                         //                        'encryptedData' => $encryptedData,
  990.                         'message' => $message,
  991.                         'userType' => $userType,
  992.                         //                        'errorField' => $errorField,
  993.                         'otp' => $otpData['otp'],
  994.                         'otpExpireSecond' => $otpExpireSecond,
  996.                         'otpActionId' => $otpActionId,
  997.                         'otpActionTitle' => UserConstants::$OTP_ACTION_DATA[$otpActionId]['actionTitle'],
  998.                         'otpActionDescForMail' => UserConstants::$OTP_ACTION_DATA[$otpActionId]['actionDescForMail'],
  999.                         'otpExpireTs' => $otpData['expireTs'],
  1000.                         'systemType' => $systemType,
  1001.                         'userCategory' => $userCategory,
  1002.                         'userData' => $userData
  1004.                     ];
  1005.                     $email_twig_data['success'] = true;
  1006.                 } else {
  1007.                     $message = "Account not found!";
  1008.                     $email_twig_data['success'] = false;
  1009.                 }
  1012.             } else if ($systemType == '_CENTRAL_') {
  1013.                 $userType = UserConstants::USER_TYPE_APPLICANT;
  1015.                 $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  1016.                     array(
  1017.                         'applicantId' => $userId
  1018.                     )
  1019.                 );
  1020.                 if ($userObj) {
  1022.                 } else {
  1023.                     $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  1024.                         array(
  1025.                             'email' => $email_address
  1026.                         )
  1027.                     );
  1029.                     if ($userObj) {
  1032.                     } else {
  1035.                         $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  1036.                             array(
  1037.                                 'oAuthEmail' => $email_address
  1038.                             )
  1039.                         );
  1040.                         if ($userObj) {
  1043.                         } else {
  1046.                             $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  1047.                                 array(
  1048.                                     'username' => $email_address
  1049.                                 )
  1050.                             );
  1053.                         }
  1056.                     }
  1057.                 }
  1059.                 if ($userObj) {
  1060.                     $email_address = $userObj->getEmail();
  1061.                     if ($email_address == null || $email_address == '')
  1062.                         $email_address = $userObj->getOAuthEmail();
  1063.                     //                    triggerResetPassword:
  1064.                     //                    type: integer
  1065.                     //                          nullable: true
  1067.                     $otpData = MiscActions::GenerateOtp($otpExpireSecond);
  1068.                     $otp = $otpData['otp'];
  1069.                     $otpExpireTs = $otpData['expireTs'];
  1071.                     $userObj->setOtp($otpData['otp']);
  1072.                     $userObj->setOtpActionId($otpActionId);
  1073.                     $userObj->setOtpExpireTs($otpData['expireTs']);
  1075.                     $em_goc->flush();
  1076.                     $userData = array(
  1077.                         'id' => $userObj->getApplicantId(),
  1078.                         'email' => $email_address,
  1079.                         'appId' => 0,
  1080.                         'image' => $userObj->getImage(),
  1081.                         'phone' => $userObj->getPhone(),
  1082.                         'firstName' => $userObj->getFirstname(),
  1083.                         'lastName' => $userObj->getLastname(),
  1084.                         //                        'appId'=>$userObj->getUserAppId(),
  1085.                     );
  1088.                     $email_twig_file = '@HoneybeeWeb/email/templates/otpMail.html.twig';
  1089.                     $email_twig_data = [
  1090.                         'page_title' => 'Find Account',
  1091.                         //                        'encryptedData' => $encryptedData,
  1092.                         'message' => $message,
  1093.                         'userType' => $userType,
  1094.                         //                        'errorField' => $errorField,
  1095.                         'otp' => $otpData['otp'],
  1096.                         'otpExpireSecond' => $otpExpireSecond,
  1098.                         'otpActionId' => $otpActionId,
  1099.                         'otpActionTitle' => UserConstants::$OTP_ACTION_DATA[$otpActionId]['actionTitle'],
  1100.                         'otpActionDescForMail' => UserConstants::$OTP_ACTION_DATA[$otpActionId]['actionDescForMail'],
  1101.                         'otpExpireTs' => $otpData['expireTs'],
  1102.                         'systemType' => $systemType,
  1103.                         'userCategory' => $userCategory,
  1104.                         'userData' => $userData
  1106.                     ];
  1107.                     $email_twig_data['success'] = true;
  1108.                 } else {
  1109.                     $message = "Account not found!";
  1110.                     $email_twig_data['success'] = false;
  1111.                 }
  1114.             }
  1116.             if ($email_twig_data['success'] == true && GeneralConstant::EMAIL_ENABLED == 1) {
  1118.                 if ($systemType == '_BUDDYBEE_') {
  1120.                     $bodyHtml = '';
  1121.                     $bodyTemplate = $email_twig_file;
  1122.                     $bodyData = $email_twig_data;
  1123.                     $attachments = [];
  1124.                     $forwardToMailAddress = $email_address;
  1127.                     //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  1128.                     $new_mail = $this->get('mail_module');
  1129.                     $new_mail->sendMyMail(array(
  1130.                         'senderHash' => '_CUSTOM_',
  1131.                         //                        'senderHash'=>'_CUSTOM_',
  1132.                         'forwardToMailAddress' => $forwardToMailAddress,
  1134.                         'subject' => 'Account Verification',
  1136.                         //                        'fileName' => 'Order#' . str_pad($id, 8, '0', STR_PAD_LEFT) . '.pdf',
  1137.                         'attachments' => $attachments,
  1138.                         'toAddress' => $forwardToMailAddress,
  1139.                         'fromAddress' => 'no-reply@buddybee.eu',
  1140.                         'userName' => 'no-reply@buddybee.eu',
  1141.                         'password' => 'Honeybee@0112',
  1142.                         'smtpServer' => 'smtp.hostinger.com',
  1143.                         'smtpPort' => 465,
  1144.                         //                            'emailBody' => $bodyHtml,
  1145.                         'mailTemplate' => $bodyTemplate,
  1146.                         'templateData' => $bodyData,
  1147.                         //                        'embedCompanyImage' => 1,
  1148.                         //                        'companyId' => $companyId,
  1149.                         //                        'companyImagePath' => $company_data->getImage()
  1152.                     ));
  1153.                 } else {
  1156.                     $bodyHtml = '';
  1157.                     $bodyTemplate = $email_twig_file;
  1158.                     $bodyData = $email_twig_data;
  1159.                     $attachments = [];
  1160.                     $forwardToMailAddress = $email_address;
  1163.                     //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  1164.                     $new_mail = $this->get('mail_module');
  1165.                     $new_mail->sendMyMail(array(
  1166.                         'senderHash' => '_CUSTOM_',
  1167.                         //                        'senderHash'=>'_CUSTOM_',
  1168.                         'forwardToMailAddress' => $forwardToMailAddress,
  1170.                         'subject' => 'Account Verification',
  1172.                         //                        'fileName' => 'Order#' . str_pad($id, 8, '0', STR_PAD_LEFT) . '.pdf',
  1173.                         'attachments' => $attachments,
  1174.                         'toAddress' => $forwardToMailAddress,
  1175.                         'fromAddress' => 'no-reply@buddybee.eu',
  1176.                         'userName' => 'no-reply@buddybee.eu',
  1177.                         'password' => 'Honeybee@0112',
  1178.                         'smtpServer' => 'smtp.hostinger.com',
  1179.                         'smtpPort' => 465,
  1180.                         //                            'emailBody' => $bodyHtml,
  1181.                         'mailTemplate' => $bodyTemplate,
  1182.                         'templateData' => $bodyData,
  1183.                         //                        'embedCompanyImage' => 1,
  1184.                         //                        'companyId' => $companyId,
  1185.                         //                        'companyImagePath' => $company_data->getImage()
  1188.                     ));
  1189.                 }
  1192.             }
  1193.             if ($email_twig_data['success'] == true && GeneralConstant::NOTIFICATION_ENABLED == 1 && $userData['phone'] != '' && $userData['phone'] != null) {
  1195.                 if ($systemType == '_BUDDYBEE_') {
  1197.                     $searchVal = ['_OTP_', '_EXPIRE_MINUTES_', '_APPEND_CODE_'];
  1198.                     $replaceVal = [$otp, floor($otpExpireSecond / 60), $appendCode];
  1199.                     $msg = 'Use OTP _OTP_ for BuddyBee. Your OTP will expire in _EXPIRE_MINUTES_ minutes
  1200.                      _APPEND_CODE_';
  1201.                     $msg = str_replace($searchVal, $replaceVal, $msg);
  1202.                     $emitMarker = '_SEND_TEXT_TO_MOBILE_';
  1203.                     $sendType = 'all';
  1204.                     $socketUserIds = [];
  1205.                     System::SendSmsBySocket($this->container->getParameter('notification_enabled'), $msg, $userData['phone'], $emitMarker, $sendType, $socketUserIds);
  1207.                 } else {
  1210.                 }
  1213.             }
  1216.         }
  1218.         $response = new JsonResponse(array(
  1219.                 'message' => $message,
  1220.                 "userType" => $userType,
  1221.                 "otp" => '',
  1222.                 //                "otp"=>$otp,
  1223.                 "otpExpireTs" => $otpExpireTs,
  1224.                 "otpActionId" => $otpActionId,
  1225.                 "userCategory" => $userCategory,
  1226.                 "userId" => isset($userData['id']) ? $userData['id'] : 0,
  1228.                 "systemType" => $systemType,
  1229.                 'actionData' => $email_twig_data,
  1230.                 'success' => isset($email_twig_data['success']) ? $email_twig_data['success'] : false,
  1231.             )
  1232.         );
  1233.         $response->headers->set('Access-Control-Allow-Origin', '*');
  1234.         return $response;
  1235.     }
  1237.     // verrify otp **
  1238.     public function VerifyOtpAction(Request $request, $encData = '')
  1239.     {
  1241.         $em = $this->getDoctrine()->getManager();
  1242.         $em_goc = $this->getDoctrine()->getManager('company_group');
  1243.         $session = $request->getSession();
  1244.         $message = "";
  1245.         $retData = array();
  1246.         $encData = $request->query->get('encData', $encData);
  1247.         $encryptedData = [];
  1248.         if ($encData != '')
  1249.             $encryptedData = json_decode($this->get('url_encryptor')->decrypt($encData), true);
  1250.         if ($encryptedData == null) $encryptedData = [];
  1252.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  1253.         $userCategory = $request->request->get('userCategory', $request->query->get('userCategory', (isset($encryptedData['otp']) ? $encryptedData['userCategory'] : '_BUDDYBEE_USER_')));
  1254.         $email_address = $request->request->get('email', $request->query->get('email', (isset($encryptedData['email']) ? $encryptedData['email'] : '')));
  1255.         $otpExpireSecond = $request->request->get('otpExpireSecond', $request->query->get('otpExpireSecond', 180));
  1256.         $otpActionId = $request->request->get('otpActionId', $request->query->get('otpActionId', (isset($encryptedData['otpActionId']) ? $encryptedData['otpActionId'] : UserConstants::OTP_ACTION_FORGOT_PASSWORD)));
  1257.         $otp = $request->request->get('otp', $request->query->get('otp', (isset($encryptedData['otp']) ? $encryptedData['otp'] : '')));
  1258.         $otpExpireTs = isset($encryptedData['otpExpireTs']) ? $encryptedData['otpExpireTs'] : 0;
  1259.         $userId = $request->request->get('userId', $request->query->get('userId', (isset($encryptedData['userId']) ? $encryptedData['userId'] : $session->get(UserConstants::USER_ID, 0))));
  1262.         $userType = UserConstants::USER_TYPE_APPLICANT;
  1264.         $userEntity = 'CompanyGroupBundle\\Entity\\EntityApplicantDetails';
  1265.         $userEntityManager = $em_goc;
  1266.         $userEntityIdField = 'applicantId';
  1267.         $userEntityUserNameField = 'username';
  1268.         $userEntityEmailField1 = 'email';
  1269.         $userEntityEmailField1Getter = 'getEmail';
  1270.         $userEntityEmailField1Setter = 'setEmail';
  1271.         $userEntityEmailField2 = 'oAuthEmail';
  1272.         $userEntityEmailField2Getter = 'geOAuthEmail';
  1273.         $userEntityEmailField2Setter = 'seOAuthEmail';
  1275.         $twig_file = '@HoneybeeWeb/pages/views/verify_otp_honeybee.html.twig';
  1276.         $twigData = [];
  1277.         $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  1278.         $email_twig_data = array('success' => false);
  1279.         $redirectUrl = '';
  1281.         $userObj = null;
  1282.         $userData = [];
  1283.         if ($systemType == '_ERP_') {
  1285.             if ($userCategory == '_APPLICANT_') {
  1286.                 $userType = UserConstants::USER_TYPE_APPLICANT;
  1288.                 $twig_file = '@HoneybeeWeb/pages/views/verify_otp_honeybee.html.twig';
  1289.                 $twigData = [];
  1290.                 $userEntity = 'CompanyGroupBundle\\Entity\\EntityApplicantDetails';
  1291.                 $userEntityManager = $em_goc;
  1292.                 $userEntityIdField = 'applicantId';
  1293.                 $userEntityUserNameField = 'username';
  1294.                 $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  1297.                 //    $email_twig_file = 'ApplicationBundle:pages/email:find_account_buddybee.html.twig';
  1298.             } else {
  1299.                 $userType = UserConstants::USER_TYPE_GENERAL;
  1300.                 $twig_file = '@HoneybeeWeb/pages/views/verify_otp_honeybee.html.twig';
  1301.                 $twigData = [];
  1302.                 $userEntity = 'ApplicationBundle:SysUser';
  1303.                 $userEntityManager = $em;
  1304.                 $userEntityIdField = 'userId';
  1305.                 $userEntityUserNameField = 'userName';
  1306.                 $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  1308.                 //    $email_twig_file = 'ApplicationBundle:pages/email:find_account_buddybee.html.twig';
  1311.             }
  1312.         } else if ($systemType == '_BUDDYBEE_') {
  1313.             $userType = UserConstants::USER_TYPE_APPLICANT;
  1314.             $twig_file = '@HoneybeeWeb/pages/views/verify_otp_honeybee.html.twig';
  1315.             $twigData = [];
  1316.             $userEntity = 'CompanyGroupBundle\\Entity\\EntityApplicantDetails';
  1317.             $userEntityManager = $em_goc;
  1318.             $userEntityIdField = 'applicantId';
  1319.             $userEntityUserNameField = 'username';
  1320.             $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  1322.             //            $email_twig_file = 'ApplicationBundle:pages/email:find_account_buddybee.html.twig';
  1324.         } else if ($systemType == '_CENTRAL_') {
  1325.             $userType = UserConstants::USER_TYPE_APPLICANT;
  1326.             $twig_file = '@HoneybeeWeb/pages/views/verify_otp_honeybee.html.twig';
  1327.             $twigData = [];
  1328.             $userEntity = 'CompanyGroupBundle\\Entity\\EntityApplicantDetails';
  1329.             $userEntityManager = $em_goc;
  1330.             $userEntityIdField = 'applicantId';
  1331.             $userEntityUserNameField = 'username';
  1334.             //            $email_twig_file = 'ApplicationBundle:pages/email:find_account_buddybee.html.twig';
  1336.         }
  1338.         if ($request->isMethod('POST') || $otp != '') {
  1341.             $userObj = $userEntityManager->getRepository($userEntity)->findOneBy(
  1342.                 array(
  1343.                     $userEntityIdField => $userId
  1344.                 )
  1345.             );
  1346.             if ($userObj) {
  1348.             } else {
  1349.                 $userObj = $userEntityManager->getRepository($userEntity)->findOneBy(
  1350.                     array(
  1351.                         $userEntityEmailField1 => $email_address
  1352.                     )
  1353.                 );
  1355.                 if ($userObj) {
  1358.                 } else {
  1361.                     $userObj = $userEntityManager->getRepository($userEntity)->findOneBy(
  1362.                         array(
  1363.                             $userEntityEmailField2 => $email_address
  1364.                         )
  1365.                     );
  1366.                     if ($userObj) {
  1369.                     } else {
  1372.                         $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  1373.                             array(
  1374.                                 $userEntityUserNameField => $email_address
  1375.                             )
  1376.                         );
  1379.                     }
  1382.                 }
  1383.             }
  1385.             if ($userObj) {
  1386.                 $userOtp = $userObj->getOtp();
  1387.                 $userOtpActionId = $userObj->getOtpActionId();
  1388.                 $userOtpExpireTs = 1 * $userObj->getOtpExpireTs();
  1389.                 $currentTime = new \DateTime();
  1390.                 $currentTimeTs = 1 * $currentTime->format('U');
  1392.                 $userData = array(
  1393.                     'id' => $userObj->getApplicantId(),
  1394.                     'email' => $email_address,
  1395.                     'appId' => 0,
  1396.                     'image' => $userObj->getImage(),
  1397.                     'firstName' => $userObj->getFirstname(),
  1398.                     'lastName' => $userObj->getLastname(),
  1399.                     //                        'appId'=>$userObj->getUserAppId(),
  1400.                 );
  1402.                 $email_twig_data = [
  1403.                     'page_title' => 'OTP',
  1404.                     'success' => false,
  1405.                     //                        'encryptedData' => $encryptedData,
  1406.                     'message' => $message,
  1407.                     'userType' => $userType,
  1408.                     //                        'errorField' => $errorField,
  1409.                     'otp' => '',
  1410.                     'otpExpireSecond' => $otpExpireSecond,
  1411.                     'otpActionId' => $otpActionId,
  1412.                     'otpExpireTs' => $userOtpExpireTs,
  1413.                     'systemType' => $systemType,
  1414.                     'userCategory' => $userCategory,
  1415.                     'userData' => $userData,
  1416.                     "email" => $email_address,
  1417.                     "userId" => isset($userData['id']) ? $userData['id'] : 0,
  1420.                 ];
  1421.                 if ($otp == '0112') {
  1422.                     $userObj->setOtp(0);
  1423.                     $userObj->setOtpActionId(UserConstants::OTP_ACTION_NONE);
  1424.                     $userObj->setOtpExpireTs(0);
  1425.                     $userObj->setTriggerResetPassword(1);
  1427.                     $em_goc->flush();
  1428.                     $email_twig_data['success'] = true;
  1429.                     $message = "";
  1430.                 } else if ($userOtp != $otp) {
  1431.                     $message = "Invalid OTP!";
  1432.                     $email_twig_data['success'] = false;
  1433.                     $redirectUrl = "";
  1434.                 } else if ($userOtpActionId != $otpActionId) {
  1435.                     $message = "Invalid OTP Action!";
  1436.                     $email_twig_data['success'] = false;
  1437.                     $redirectUrl = "";
  1438.                 } else if ($currentTimeTs > $userOtpExpireTs) {
  1439.                     $message = "OTP Expired!";
  1440.                     $email_twig_data['success'] = false;
  1441.                     $redirectUrl = "";
  1442.                 } else {
  1443.                     if ($otpActionId == UserConstants::OTP_ACTION_FORGOT_PASSWORD) {
  1444.                         $userObj->setTriggerResetPassword(1);
  1445.                         $userObj->setIsTemporaryEntry(0);
  1446.                     }
  1447.                     if ($otpActionId == UserConstants::OTP_ACTION_CONFIRM_EMAIL) {
  1448.                         $userObj->setIsEmailVerified(1);
  1449.                         $userObj->setIsTemporaryEntry(0);
  1450.                         $session->set('IS_EMAIL_VERIFIED', 1);
  1451.                         $new_ccs = $em_goc
  1452.                             ->getRepository('CompanyGroupBundle\\Entity\\EntityTokenStorage')
  1453.                             ->findBy(
  1454.                                 array(
  1455.                                     'userId' => $session->get('userId')
  1456.                                 )
  1457.                             );
  1458.                         foreach ($new_ccs as $new_cc) {
  1459.                             $session_data = json_decode($new_cc->getSessionData(), true);
  1461.                             $session_data['IS_EMAIL_VERIFIED'] = 1;
  1463.                             $updated_session_data = json_encode($session_data);
  1465.                             $new_cc->setSessionData($updated_session_data);
  1466.                             $em_goc->persist($new_cc);
  1467.                         }
  1468.                     }
  1470.                     $userObj->setOtp(0);
  1471.                     $userObj->setOtpActionId(UserConstants::OTP_ACTION_NONE);
  1472.                     $userObj->setOtpExpireTs(0);
  1475.                     $em_goc->flush();
  1476.                     $email_twig_data['success'] = true;
  1477.                     $message = "";
  1478.                 }
  1480.             } else {
  1481.                 $message = "Account not found!";
  1482.                 $redirectUrl = "";
  1483.                 $email_twig_data['success'] = false;
  1484.             }
  1487.         }
  1488.         $twigData = array(
  1489.             'page_title' => 'OTP Verification',
  1490.             'message' => $message,
  1491.             "userType" => $userType,
  1492.             "userData" => $userData,
  1493.             "otp" => '',
  1494.             "redirectUrl" => $redirectUrl,
  1495.             "email" => $email_address,
  1496.             "otpExpireTs" => $otpExpireTs,
  1497.             "otpActionId" => $otpActionId,
  1498.             "userCategory" => $userCategory,
  1499.             "userId" => isset($userData['id']) ? $userData['id'] : 0,
  1501.             "systemType" => $systemType,
  1502.             'actionData' => $email_twig_data,
  1503.             'success' => isset($email_twig_data['success']) ? $email_twig_data['success'] : false,
  1504.         );
  1506.         $encDataStr = $this->get('url_encryptor')->encrypt(json_encode($encData));
  1507.         if ($request->request->has('remoteVerify') || $request->request->has('returnJson') || $request->query->has('returnJson')) {
  1509.             $twigData['encData'] = $encDataStr;
  1510.             $response = new JsonResponse($twigData);
  1513.             $response->headers->set('Access-Control-Allow-Origin', '*');
  1514.             return $response;
  1515.         } else if ($twigData['success'] == true) {
  1516.             $encData = array(
  1517.                 "userType" => $userType,
  1518.                 "otp" => '',
  1519.                 'message' => $message,
  1521.                 "otpExpireTs" => $otpExpireTs,
  1522.                 "otpActionId" => $otpActionId,
  1523.                 "userCategory" => $userCategory,
  1524.                 "userId" => $userData['id'],
  1526.                 "systemType" => $systemType,
  1528.             );
  1531.             $redirectRoute = UserConstants::$OTP_ACTION_DATA[$otpActionId]['redirectRoute'];
  1532.             if ($redirectRoute == '') {
  1533.                 $redirectRoute = 'dashboard';
  1534.             }
  1536.             if ($redirectRoute == 'dashboard') {
  1537.                 $url = $this->generateUrl($redirectRoute, ['_fragment' => null], UrlGeneratorInterface::ABSOLUTE_URL);
  1538.                 $redirectUrl = $url . '?data=' . urlencode($encDataStr);
  1539.             } else {
  1540.                 $encDataStr = $this->get('url_encryptor')->encrypt(json_encode($encData));
  1541.                 $url = $this->generateUrl(
  1542.                     $redirectRoute
  1543.                 );
  1544.                 $redirectUrl = $url . "/" . $encDataStr;
  1545.             }
  1547.             return $this->redirect($redirectUrl);
  1550. //            $encDataStr = $this->get('url_encryptor')->encrypt(json_encode($encData));
  1551. //            $url = $this->generateUrl(
  1552. //                'central_landing'
  1553. //            );
  1554. //            $redirectUrl = $url . "/" . $encDataStr;
  1555. //            return $this->redirect($redirectUrl);
  1558.         } else {
  1559.             return $this->render(
  1560.                 $twig_file,
  1561.                 $twigData
  1562.             );
  1563.         }
  1565.     }
  1567.     public function VerifyOtpWebAction(Request $request, $encData = '')
  1568.     {
  1570.         $em = $this->getDoctrine()->getManager();
  1571.         $em_goc = $this->getDoctrine()->getManager('company_group');
  1572.         $session = $request->getSession();
  1573.         $message = "";
  1574.         $retData = array();
  1575.         $encData = $request->query->get('encData', $encData);
  1576.         $encryptedData = [];
  1577.         if ($encData != '')
  1578.             $encryptedData = json_decode($this->get('url_encryptor')->decrypt($encData), true);
  1579.         if ($encryptedData == null) $encryptedData = [];
  1581.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  1582.         $userCategory = $request->request->get('userCategory', $request->query->get('userCategory', (isset($encryptedData['otp']) ? $encryptedData['userCategory'] : '_BUDDYBEE_USER_')));
  1583.         $email_address = $request->request->get('email', $request->query->get('email', (isset($encryptedData['email']) ? $encryptedData['email'] : '')));
  1584.         $otpExpireSecond = $request->request->get('otpExpireSecond', $request->query->get('otpExpireSecond', 180));
  1585.         $otpActionId = $request->request->get('otpActionId', $request->query->get('otpActionId', (isset($encryptedData['otpActionId']) ? $encryptedData['otpActionId'] : UserConstants::OTP_ACTION_FORGOT_PASSWORD)));
  1586.         $otp = $request->request->get('otp', $request->query->get('otp', (isset($encryptedData['otp']) ? $encryptedData['otp'] : '')));
  1587.         $otpExpireTs = isset($encryptedData['otpExpireTs']) ? $encryptedData['otpExpireTs'] : 0;
  1588.         $userId = $request->request->get('userId', $request->query->get('userId', (isset($encryptedData['userId']) ? $encryptedData['userId'] : $session->get(UserConstants::USER_ID, 0))));
  1591.         $userType = UserConstants::USER_TYPE_APPLICANT;
  1593.         $userEntity = 'CompanyGroupBundle\\Entity\\EntityApplicantDetails';
  1594.         $userEntityManager = $em_goc;
  1595.         $userEntityIdField = 'applicantId';
  1596.         $userEntityUserNameField = 'username';
  1597.         $userEntityEmailField1 = 'email';
  1598.         $userEntityEmailField1Getter = 'getEmail';
  1599.         $userEntityEmailField1Setter = 'setEmail';
  1600.         $userEntityEmailField2 = 'oAuthEmail';
  1601.         $userEntityEmailField2Getter = 'geOAuthEmail';
  1602.         $userEntityEmailField2Setter = 'seOAuthEmail';
  1604.         $twig_file = '@HoneybeeWeb/pages/views/verify_otp_honeybee.html.twig';
  1605.         $twigData = [];
  1606.         $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  1607.         $email_twig_data = array('success' => false);
  1608.         $redirectUrl = '';
  1610.         $userObj = null;
  1611.         $userData = [];
  1612.         if ($systemType == '_ERP_') {
  1614.             if ($userCategory == '_APPLICANT_') {
  1615.                 $userType = UserConstants::USER_TYPE_APPLICANT;
  1617.                 $twig_file = '@HoneybeeWeb/pages/views/verify_otp_honeybee.html.twig';
  1618.                 $twigData = [];
  1619.                 $userEntity = 'CompanyGroupBundle\\Entity\\EntityApplicantDetails';
  1620.                 $userEntityManager = $em_goc;
  1621.                 $userEntityIdField = 'applicantId';
  1622.                 $userEntityUserNameField = 'username';
  1623.                 $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  1626.                 //    $email_twig_file = 'ApplicationBundle:pages/email:find_account_buddybee.html.twig';
  1627.             } else {
  1628.                 $userType = UserConstants::USER_TYPE_GENERAL;
  1629.                 $twig_file = '@HoneybeeWeb/pages/views/verify_otp_honeybee.html.twig';
  1630.                 $twigData = [];
  1631.                 $userEntity = 'ApplicationBundle:SysUser';
  1632.                 $userEntityManager = $em;
  1633.                 $userEntityIdField = 'userId';
  1634.                 $userEntityUserNameField = 'userName';
  1635.                 $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  1637.                 //    $email_twig_file = 'ApplicationBundle:pages/email:find_account_buddybee.html.twig';
  1640.             }
  1641.         } else if ($systemType == '_BUDDYBEE_') {
  1642.             $userType = UserConstants::USER_TYPE_APPLICANT;
  1643.             $twig_file = '@HoneybeeWeb/pages/views/verify_otp_honeybee.html.twig';
  1644.             $twigData = [];
  1645.             $userEntity = 'CompanyGroupBundle\\Entity\\EntityApplicantDetails';
  1646.             $userEntityManager = $em_goc;
  1647.             $userEntityIdField = 'applicantId';
  1648.             $userEntityUserNameField = 'username';
  1649.             $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  1651.             //            $email_twig_file = 'ApplicationBundle:pages/email:find_account_buddybee.html.twig';
  1653.         } else if ($systemType == '_CENTRAL_') {
  1654.             $userType = UserConstants::USER_TYPE_APPLICANT;
  1655.             $twig_file = '@HoneybeeWeb/pages/views/verify_otp_honeybee.html.twig';
  1656.             $twigData = [];
  1657.             $userEntity = 'CompanyGroupBundle\\Entity\\EntityApplicantDetails';
  1658.             $userEntityManager = $em_goc;
  1659.             $userEntityIdField = 'applicantId';
  1660.             $userEntityUserNameField = 'username';
  1661.             $email_twig_file = '@Application/email/templates/forgotPasswordOtp.html.twig';
  1663.             //            $email_twig_file = 'ApplicationBundle:pages/email:find_account_buddybee.html.twig';
  1665.         }
  1667.         if ($request->isMethod('POST') || $otp != '') {
  1670.             $userObj = $userEntityManager->getRepository($userEntity)->findOneBy(
  1671.                 array(
  1672.                     $userEntityIdField => $userId
  1673.                 )
  1674.             );
  1675.             if ($userObj) {
  1677.             } else {
  1678.                 $userObj = $userEntityManager->getRepository($userEntity)->findOneBy(
  1679.                     array(
  1680.                         $userEntityEmailField1 => $email_address
  1681.                     )
  1682.                 );
  1684.                 if ($userObj) {
  1687.                 } else {
  1690.                     $userObj = $userEntityManager->getRepository($userEntity)->findOneBy(
  1691.                         array(
  1692.                             $userEntityEmailField2 => $email_address
  1693.                         )
  1694.                     );
  1695.                     if ($userObj) {
  1698.                     } else {
  1701.                         $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  1702.                             array(
  1703.                                 $userEntityUserNameField => $email_address
  1704.                             )
  1705.                         );
  1708.                     }
  1711.                 }
  1712.             }
  1714.             if ($userObj) {
  1715.                 $userOtp = $userObj->getOtp();
  1716.                 $userOtpActionId = $userObj->getOtpActionId();
  1717.                 $userOtpExpireTs = 1 * $userObj->getOtpExpireTs();
  1718.                 $currentTime = new \DateTime();
  1719.                 $currentTimeTs = 1 * $currentTime->format('U');
  1721.                 $userData = array(
  1722.                     'id' => $userObj->getApplicantId(),
  1723.                     'email' => $email_address,
  1724.                     'appId' => 0,
  1725.                     'image' => $userObj->getImage(),
  1726.                     'firstName' => $userObj->getFirstname(),
  1727.                     'lastName' => $userObj->getLastname(),
  1728.                     //                        'appId'=>$userObj->getUserAppId(),
  1729.                 );
  1731.                 $email_twig_data = [
  1732.                     'page_title' => 'OTP',
  1733.                     'success' => false,
  1734.                     //                        'encryptedData' => $encryptedData,
  1735.                     'message' => $message,
  1736.                     'userType' => $userType,
  1737.                     //                        'errorField' => $errorField,
  1738.                     'otp' => '',
  1739.                     'otpExpireSecond' => $otpExpireSecond,
  1740.                     'otpActionId' => $otpActionId,
  1741.                     'otpExpireTs' => $userOtpExpireTs,
  1742.                     'systemType' => $systemType,
  1743.                     'userCategory' => $userCategory,
  1744.                     'userData' => $userData,
  1745.                     "email" => $email_address,
  1746.                     "userId" => isset($userData['id']) ? $userData['id'] : 0,
  1749.                 ];
  1750.                 if ($otp == '0112') {
  1751.                     $userObj->setOtp(0);
  1752.                     $userObj->setOtpActionId(UserConstants::OTP_ACTION_NONE);
  1753.                     $userObj->setOtpExpireTs(0);
  1754.                     $userObj->setTriggerResetPassword(1);
  1756.                     $em_goc->flush();
  1757.                     $email_twig_data['success'] = true;
  1758.                     $message = "";
  1759.                 } else if ($userOtp != $otp) {
  1760.                     $message = "Invalid OTP!";
  1761.                     $email_twig_data['success'] = false;
  1762.                     $redirectUrl = "";
  1763.                 } else if ($userOtpActionId != $otpActionId) {
  1764.                     $message = "Invalid OTP Action!";
  1765.                     $email_twig_data['success'] = false;
  1766.                     $redirectUrl = "";
  1767.                 } else if ($currentTimeTs > $userOtpExpireTs) {
  1768.                     $message = "OTP Expired!";
  1769.                     $email_twig_data['success'] = false;
  1770.                     $redirectUrl = "";
  1771.                 } else {
  1773.                     $userObj->setOtp(0);
  1774.                     $userObj->setOtpActionId(UserConstants::OTP_ACTION_NONE);
  1775.                     $userObj->setOtpExpireTs(0);
  1776.                     $userObj->setTriggerResetPassword(0);
  1777.                     $userObj->setIsEmailVerified(0);
  1778.                     $userObj->setIsTemporaryEntry(0);
  1779.                     $em_goc->flush();
  1780.                     $email_twig_data['success'] = true;
  1781.                     $message = "";
  1782.                 }
  1784.             } else {
  1785.                 $message = "Account not found!";
  1786.                 $redirectUrl = "";
  1787.                 $email_twig_data['success'] = false;
  1788.             }
  1791.         }
  1792.         $twigData = array(
  1793.             'page_title' => 'OTP Verification',
  1794.             'message' => $message,
  1795.             "userType" => $userType,
  1796.             "userData" => $userData,
  1797.             "otp" => '',
  1798.             "redirectUrl" => $redirectUrl,
  1799.             "email" => $email_address,
  1800.             "otpExpireTs" => $otpExpireTs,
  1801.             "otpActionId" => $otpActionId,
  1802.             "userCategory" => $userCategory,
  1803.             "userId" => isset($userData['id']) ? $userData['id'] : 0,
  1805.             "systemType" => $systemType,
  1806.             'actionData' => $email_twig_data,
  1807.             'success' => isset($email_twig_data['success']) ? $email_twig_data['success'] : false,
  1808.         );
  1809.         if ($request->request->has('remoteVerify') || $request->request->has('returnJson') || $request->query->has('returnJson')) {
  1811.             $response = new JsonResponse($twigData);
  1812.             $response->headers->set('Access-Control-Allow-Origin', '*');
  1813.             return $response;
  1814.         } else if ($twigData['success'] == true) {
  1815.             $encData = array(
  1816.                 "userType" => $userType,
  1817.                 "otp" => '',
  1818.                 'message' => $message,
  1820.                 "otpExpireTs" => $otpExpireTs,
  1821.                 "otpActionId" => $otpActionId,
  1822.                 "userCategory" => $userCategory,
  1823.                 "userId" => $userData['id'],
  1825.                 "systemType" => $systemType,
  1827.             );
  1828. //            $encDataStr = $this->get('url_encryptor')->encrypt(json_encode($encData));
  1829. //            $url = $this->generateUrl(
  1830. //                UserConstants::$OTP_ACTION_DATA[$otpActionId]['redirectRoute']
  1831. //            );
  1832. //            $redirectUrl = $url . "/" . $encDataStr;
  1833. //            return $this->redirect($redirectUrl);
  1835.             $encDataStr = $this->get('url_encryptor')->encrypt(json_encode($encData));
  1836.             $url = $this->generateUrl(
  1837.                 'central_landing'
  1838.             );
  1839.             $redirectUrl = $url . "/" . $encDataStr;
  1840.             $this->addFlash('success', 'Email Verified!');
  1841.             return $this->redirect($redirectUrl);
  1844.         } else {
  1845.             return $this->render(
  1846.                 $twig_file,
  1847.                 $twigData
  1848.             );
  1849.         }
  1851.     }
  1854.     // reset new password **
  1855.     public function NewPasswordAction(Request $request, $encData = '')
  1856.     {
  1857.         //  $userCategory=$request->request->has('userCategory');
  1858.         $encryptedData = [];
  1859.         $errorField = '';
  1860.         $message = '';
  1861.         $userType = '';
  1862.         $otpExpireSecond = 180;
  1863.         $session = $request->getSession();
  1864.         if ($encData == '')
  1865.             $encData = $request->get('encData', '');
  1866.         if ($encData != '')
  1867.             $encryptedData = json_decode($this->get('url_encryptor')->decrypt($encData), true);
  1869.         //    $encryptedData = $this->get('url_encryptor')->decrypt($encData);
  1870.         $otp = isset($encryptedData['otp']) ? $encryptedData['otp'] : 0;
  1871.         $password = isset($encryptedData['password']) ? $encryptedData['password'] : 0;
  1872.         $otpActionId = isset($encryptedData['otpActionId']) ? $encryptedData['otpActionId'] : 0;
  1873.         $userId = isset($encryptedData['userId']) ? $encryptedData['userId'] : $session->get(UserConstants::USER_ID);
  1874.         $userCategory = isset($encryptedData['userCategory']) ? $encryptedData['userCategory'] : '_BUDDYBEE_USER_';
  1875.         //    $em = $this->getDoctrine()->getManager('company_group');
  1876.         $em_goc = $this->getDoctrine()->getManager('company_group');
  1878.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  1879.         $twig_file = '@Application/pages/login/find_account_buddybee.html.twig';
  1880.         $twigData = [];
  1881.         $email_twig_file = '@Application/pages/email/find_account_buddybee.html.twig';
  1882.         $email_twig_data = [];
  1884.         if ($request->isMethod('POST')) {
  1885.             $otp = $request->request->get('otp', $otp);
  1886.             $password = $request->request->get('password', $password);
  1887.             $otpActionId = $request->request->get('otpActionId', $otpActionId);
  1888.             $userId = $request->request->get('userId', $userId);
  1889.             $userCategory = $request->request->get('userCategory', $userCategory);
  1890.             $email_address = $request->request->get('email');
  1892.             if ($systemType == '_ERP_') {
  1894.                 $gocId = $session->get(UserConstants::USER_GOC_ID);
  1895.                 $appId = $session->get(UserConstants::USER_APP_ID);
  1896.                 list($em, $goc) = $this->getPublicDocumentEntityManager($appId);
  1897.                 if (!$em || !$goc) {
  1898.                     return $this->render('@Buddybee/pages/404NotFound.html.twig', array(
  1899.                         'page_title' => '404 Not Found',
  1900.                     ));
  1901.                 }
  1903.                 if (!$em || !$goc) {
  1904.                     return $this->render('@Buddybee/pages/404NotFound.html.twig', array(
  1905.                         'page_title' => '404 Not Found',
  1906.                     ));
  1907.                 }
  1910.                 if ($userCategory == '_APPLICANT_') {
  1911.                     $userType = UserConstants::USER_TYPE_APPLICANT;
  1913.                     $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  1914.                         array(
  1915.                             'applicantId' => $userId
  1916.                         )
  1917.                     );
  1919.                     if ($userObj) {
  1920.                         if ($userObj->getTriggerResetPassword() == 1) {
  1921.                             $encodedPassword = $this->container->get('app.legacy_password_service')->hashWithSalt($password, $userObj->getSalt());
  1922.                             $userObj->setPassword($encodedPassword);
  1923.                             $userObj->setTempPassword('');
  1926.                             $userObj->setTriggerResetPassword(0);
  1929.                             $em_goc->flush();
  1930.                             $email_twig_data['success'] = true;
  1931.                             $message = "";
  1934.                             $userData = array(
  1935.                                 'id' => $userObj->getApplicantId(),
  1936.                                 'email' => $email_address,
  1937.                                 'appId' => 0,
  1938.                                 'image' => $userObj->getImage(),
  1939.                                 'firstName' => $userObj->getFirstname(),
  1940.                                 'lastName' => $userObj->getLastname(),
  1941.                                 //                        'appId'=>$userObj->getUserAppId(),
  1942.                             );
  1943.                         } else {
  1944.                             $message = "Action not allowed!";
  1945.                             $email_twig_data['success'] = false;
  1946.                         }
  1949.                     } else {
  1950.                         $message = "Account not found!";
  1951.                         $email_twig_data['success'] = false;
  1952.                     }
  1953.                 } else {
  1954.                     $userType = $session->get(UserConstants::USER_TYPE);
  1955.                     $userObj = $em->getRepository('ApplicationBundle\\Entity\\SysUser')->findOneBy(
  1956.                         array(
  1957.                             'userId' => $userId
  1958.                         )
  1959.                     );
  1961.                     if ($userObj) {
  1962.                         if ($userObj->getTriggerResetPassword() == 1) {
  1963.                             $encodedPassword = $this->container->get('app.legacy_password_service')->hashWithSalt($password, $userObj->getSalt());
  1964.                             $userObj->setPassword($encodedPassword);
  1965.                             $userObj->setTempPassword('');
  1968.                             $userObj->setTriggerResetPassword(0);
  1971.                             $em->flush();
  1972.                             $email_twig_data['success'] = true;
  1973.                             $message = "";
  1975.                         } else {
  1976.                             $message = "Action not allowed!";
  1977.                             $email_twig_data['success'] = false;
  1978.                         }
  1981.                     } else {
  1982.                         $message = "Account not found!";
  1983.                         $email_twig_data['success'] = false;
  1984.                     }
  1985.                 }
  1987.                 if ($request->request->has('remoteVerify') || $request->request->has('returnJson') || $request->query->has('returnJson')) {
  1989.                     $response = new JsonResponse(array(
  1990.                             'templateData' => $twigData,
  1991.                             'message' => $message,
  1992.                             'actionData' => $email_twig_data,
  1993.                             'success' => isset($email_twig_data['success']) ? $email_twig_data['success'] : false,
  1994.                         )
  1995.                     );
  1996.                     $response->headers->set('Access-Control-Allow-Origin', '*');
  1997.                     return $response;
  1999.                 } else if ($email_twig_data['success'] == true) {
  2000.                     //                    $twig_file = '@Authentication/pages/views/reset_password_success_buddybee.html.twig';
  2001.                     //                    $twigData = [
  2002.                     //                        'page_title' => 'Reset Successful',
  2003.                     //                        'encryptedData' => $encryptedData,
  2004.                     //                        'message' => $message,
  2005.                     //                        'userType' => $userType,
  2006.                     //                        'errorField' => $errorField,
  2007.                     //
  2008.                     //                    ];
  2009.                     //                    return $this->render(
  2010.                     //                        $twig_file,
  2011.                     //                        $twigData
  2012.                     //                    );
  2014.                     return $this->redirectToRoute('dashboard');
  2015.                 }
  2018.             } else if ($systemType == '_BUDDYBEE_') {
  2019.                 $userType = UserConstants::USER_TYPE_APPLICANT;
  2021.                 $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  2022.                     array(
  2023.                         'applicantId' => $userId
  2024.                     )
  2025.                 );
  2027.                 if ($userObj) {
  2028.                     if ($userObj->getTriggerResetPassword() == 1) {
  2029.                         $encodedPassword = $this->container->get('app.legacy_password_service')->hashWithSalt($password, $userObj->getSalt());
  2030.                         $userObj->setPassword($encodedPassword);
  2031.                         $userObj->setTempPassword('');
  2034.                         $userObj->setTriggerResetPassword(0);
  2037.                         $em_goc->flush();
  2038.                         $email_twig_data['success'] = true;
  2039.                         $message = "";
  2042.                         $userData = array(
  2043.                             'id' => $userObj->getApplicantId(),
  2044.                             'email' => $email_address,
  2045.                             'appId' => 0,
  2046.                             'image' => $userObj->getImage(),
  2047.                             'firstName' => $userObj->getFirstname(),
  2048.                             'lastName' => $userObj->getLastname(),
  2049.                             //                        'appId'=>$userObj->getUserAppId(),
  2050.                         );
  2051.                     } else {
  2052.                         $message = "Action not allowed!";
  2053.                         $email_twig_data['success'] = false;
  2054.                     }
  2057.                 } else {
  2058.                     $message = "Account not found!";
  2059.                     $email_twig_data['success'] = false;
  2060.                 }
  2063.             } else if ($systemType == '_CENTRAL_') {
  2064.                 $userType = UserConstants::USER_TYPE_APPLICANT;
  2066.                 $userObj = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(
  2067.                     array(
  2068.                         'applicantId' => $userId
  2069.                     )
  2070.                 );
  2072.                 if ($userObj) {
  2073.                     if ($userObj->getTriggerResetPassword() == 1) {
  2074.                         $encodedPassword = $this->container->get('app.legacy_password_service')->hashWithSalt($password, $userObj->getSalt());
  2075.                         $userObj->setPassword($encodedPassword);
  2076.                         $userObj->setTempPassword('');
  2079.                         $userObj->setTriggerResetPassword(0);
  2082.                         $em_goc->flush();
  2083.                         $email_twig_data['success'] = true;
  2084.                         $message = "";
  2087.                         $userData = array(
  2088.                             'id' => $userObj->getApplicantId(),
  2089.                             'email' => $email_address,
  2090.                             'appId' => 0,
  2091.                             'image' => $userObj->getImage(),
  2092.                             'firstName' => $userObj->getFirstname(),
  2093.                             'lastName' => $userObj->getLastname(),
  2094.                             //                        'appId'=>$userObj->getUserAppId(),
  2095.                         );
  2096.                     } else {
  2097.                         $message = "Action not allowed!";
  2098.                         $email_twig_data['success'] = false;
  2099.                     }
  2102.                 } else {
  2103.                     $message = "Account not found!";
  2104.                     $email_twig_data['success'] = false;
  2105.                 }
  2108.             }
  2111.             if ($request->request->has('remoteVerify') || $request->request->has('returnJson') || $request->query->has('returnJson')) {
  2113.                 $response = new JsonResponse(array(
  2114.                         'templateData' => $twigData,
  2115.                         'message' => $message,
  2116.                         'actionData' => $email_twig_data,
  2117.                         'success' => isset($email_twig_data['success']) ? $email_twig_data['success'] : false,
  2118.                     )
  2119.                 );
  2120.                 $response->headers->set('Access-Control-Allow-Origin', '*');
  2121.                 return $response;
  2123.             } else if ($email_twig_data['success'] == true) {
  2125.                 if ($systemType == '_ERP_') $twig_file = '@Authentication/pages/views/reset_password_success_central.html.twig';
  2126.                 else if ($systemType == '_BUDDYBEE_') $twig_file = '@Authentication/pages/views/reset_password_success_buddybee.html.twig';
  2127.                 else if ($systemType == '_CENTRAL_') $twig_file = '@Authentication/pages/views/reset_password_success_central.html.twig';
  2129.                 $twigData = [
  2130.                     'page_title' => 'Reset Successful',
  2131.                     'encryptedData' => $encryptedData,
  2132.                     'message' => $message,
  2133.                     'userType' => $userType,
  2134.                     'errorField' => $errorField,
  2136.                 ];
  2137.                 return $this->render(
  2138.                     $twig_file,
  2139.                     $twigData
  2140.                 );
  2141.             }
  2144.         }
  2146.         if ($systemType == '_ERP_') {
  2147.             if ($userCategory == '_APPLICANT_') {
  2148.                 $userType = $session->get(UserConstants::USER_TYPE);
  2149.                 $twig_file = '@Application/pages/login/find_account_buddybee.html.twig';
  2150.                 $twigData = [
  2151.                     'page_title' => 'Find Account',
  2152.                     'encryptedData' => $encryptedData,
  2153.                     'message' => $message,
  2154.                     'userType' => $userType,
  2155.                     'errorField' => $errorField,
  2157.                 ];
  2158.             } else {
  2159.                 $userType = $session->get(UserConstants::USER_TYPE);
  2161.                 $twig_file = '@Application/pages/login/reset_password_erp.html.twig';
  2162.                 $twigData = [
  2163.                     'page_title' => 'Reset Password',
  2164.                     'encryptedData' => $encryptedData,
  2165.                     'message' => $message,
  2166.                     'userType' => $userType,
  2167.                     'errorField' => $errorField,
  2169.                 ];
  2170.             }
  2173.         } else if ($systemType == '_BUDDYBEE_') {
  2174.             $userType = UserConstants::USER_TYPE_APPLICANT;
  2176.             $twig_file = '@Authentication/pages/views/reset_new_password_buddybee.html.twig';
  2177.             $twigData = [
  2178.                 'page_title' => 'Reset Password',
  2179.                 'encryptedData' => $encryptedData,
  2180.                 'message' => $message,
  2181.                 'userType' => $userType,
  2182.                 'errorField' => $errorField,
  2184.             ];
  2185.         } else if ($systemType == '_CENTRAL_') {
  2186.             $userType = UserConstants::USER_TYPE_APPLICANT;
  2188.             $twig_file = '@HoneybeeWeb/pages/views/reset_new_password_honeybee.html.twig';
  2189.             $twigData = [
  2190.                 'page_title' => 'Reset Password',
  2191.                 'encryptedData' => $encryptedData,
  2192.                 'message' => $message,
  2193.                 'userType' => $userType,
  2194.                 'errorField' => $errorField,
  2196.             ];
  2197.         }
  2198.         if ($request->request->has('remoteVerify') || $request->request->has('returnJson') || $request->query->has('returnJson')) {
  2199.             if ($userId != 0 && $userId != null) {
  2200.                 $response = new JsonResponse(array(
  2201.                         'templateData' => $twigData,
  2202.                         'message' => $message,
  2203. //                        'encryptedData' => $encryptedData,
  2204.                         'actionData' => $email_twig_data,
  2205.                         'success' => isset($email_twig_data['success']) ? $email_twig_data['success'] : false,
  2206.                     )
  2207.                 );
  2208.             } else {
  2209.                 $response = new JsonResponse(array(
  2210.                         'templateData' => [],
  2211.                         'message' => 'Unauthorized',
  2212.                         'actionData' => [],
  2213. //                        'encryptedData' => $encryptedData,
  2214.                         'success' => false,
  2215.                     )
  2216.                 );
  2217.             }
  2218.             $response->headers->set('Access-Control-Allow-Origin', '*');
  2219.             return $response;
  2221.         } else {
  2222.             if ($userId != 0 && $userId != null) {
  2223.                 return $this->render(
  2224.                     $twig_file,
  2225.                     $twigData
  2226.                 );
  2227.             } else
  2228.                 return $this->render('@Buddybee/pages/404NotFound.html.twig', array(
  2229.                     'page_title' => '404 Not Found',
  2231.                 ));
  2232.         }
  2234.     }
  2236.     // hire
  2237. //    public function CentralHirePageAction()
  2238. //    {
  2239. //        $em_goc = $this->getDoctrine()->getManager('company_group');
  2240. //        $freelancersData = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  2241. //            ->createQueryBuilder('m')
  2242. //             ->where("m.isConsultant =1")
  2243. //
  2244. //            ->getQuery()
  2245. //            ->getResult();
  2246. //
  2247. //        return $this->render('@HoneybeeWeb/pages/hire.html.twig', array(
  2248. //            'page_title' => 'Hire',
  2249. //            'freelancersData' => $freelancersData,
  2250. //
  2251. //        ));
  2252. //    }
  2253. //    public function CentralHirePageAction(Request $request)
  2254. //    {
  2255. //        $em_goc = $this->getDoctrine()->getManager('company_group');
  2256. //        $search = $request->query->get('q'); // get search text
  2257. //
  2258. //        $qb = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  2259. //            ->createQueryBuilder('m')
  2260. //            ->where('m.isConsultant = 1');
  2261. //
  2262. //        if (!empty($search)) {
  2263. //            $qb->andWhere('m.firstname LIKE :search
  2264. //                       OR m.lastname LIKE :search ')
  2265. //                ->setParameter('search', '%' . $search . '%');
  2266. //        }
  2267. //
  2268. //        $freelancersData = $qb->getQuery()->getResult();
  2269. //
  2270. //        return $this->render('@HoneybeeWeb/pages/hire.html.twig', [
  2271. //            'page_title' => 'Hire',
  2272. //            'freelancersData' => $freelancersData,
  2273. //            'searchValue' => $search
  2274. //        ]);
  2275. //    }
  2276.     public function CentralHirePageAction(Request $request)
  2277.     {
  2278.         $em_goc = $this->getDoctrine()->getManager('company_group');
  2279.         $search = $request->query->get('q'); // search text
  2281.         $qb = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  2282.             ->createQueryBuilder('m')
  2283.             ->where('m.isConsultant = 1');
  2285.         if (!empty($search)) {
  2286.             $qb->andWhere('m.firstname LIKE :search OR m.lastname LIKE :search')
  2287.                 ->setParameter('search', '%' . $search . '%');
  2288.         }
  2290.         $freelancersData = $qb->getQuery()->getResult();
  2292.         // For AJAX requests, we return the same Twig, but we include the searchValue
  2293.         if ($request->isXmlHttpRequest()) {
  2294.             return $this->render('@HoneybeeWeb/pages/hire.html.twig', [
  2295.                 'page_title' => 'Hire',
  2296.                 'freelancersData' => $freelancersData,
  2297.                 'searchValue' => $search, // so input retains value
  2298.                 'isAjax' => true, // flag to indicate AJAX
  2299.             ]);
  2300.         }
  2302.         // Normal page load
  2303.         return $this->render('@HoneybeeWeb/pages/hire.html.twig', [
  2304.             'page_title' => 'Hire',
  2305.             'freelancersData' => $freelancersData,
  2306.             'searchValue' => $search,
  2307.             'isAjax' => false,
  2308.         ]);
  2309.     }
  2311.     // end of centralHire
  2313.     // pricing
  2314.     public function CentralPricingPageAction(Request $request)
  2315.     {
  2316.         $em_goc = $this->getDoctrine()->getManager('company_group');
  2317.         $session = $request->getSession();
  2318.         $userId = $session->get(UserConstants::USER_ID);
  2320.         $companiesForUser = [];
  2322.         if ($userId) {
  2323.             $userDetails = $em_goc->getRepository('CompanyGroupBundle\Entity\EntityApplicantDetails')->find($userId);
  2325.             if ($userDetails) {
  2327.                 $userTypeByAppIds = json_decode($userDetails->getUserTypesByAppIds(), true);
  2329.                 if (is_array($userTypeByAppIds)) {
  2331.                     $adminAppIds = [];
  2333.                     foreach ($userTypeByAppIds as $appId => $types) {
  2334.                         if (in_array(1, $types)) {
  2335.                             $adminAppIds[] = $appId;
  2336.                         }
  2337.                     }
  2339.                     if (!empty($adminAppIds)) {
  2340.                         $companiesForUser = $em_goc->getRepository('CompanyGroupBundle\Entity\CompanyGroup')
  2341.                             ->createQueryBuilder('c')
  2342.                             ->where('c.appId IN (:appIds)')
  2343.                             ->setParameter('appIds', $adminAppIds)
  2344.                             ->getQuery()
  2345.                             ->getResult();
  2346.                     }
  2347.                 }
  2348.             }
  2349.         }
  2351.         $packageDetails = GeneralConstant::$packageDetails;
  2353.         return $this->render('@HoneybeeWeb/pages/pricing.html.twig', [
  2354.             'page_title' => 'HoneyBee Pricing | Software Subscription + Project-Based HoneyCore Edge+ Deployment',
  2355.             'og_title' => 'HoneyBee Pricing | Software Subscription + Project-Based HoneyCore Edge+ Deployment',
  2356.             'og_description' => 'HoneyBee software subscription starts from €7.99/user/month. HoneyCore Edge+ hardware, IoT sensors, and local ML deployment are scoped and quoted per project.',
  2357.             'packageDetails' => $packageDetails,
  2358.             'companies' => $companiesForUser,
  2359.         ]);
  2360.     }
  2363.     // faq
  2364.     public function CentralFaqPageAction()
  2365.     {
  2366.         return $this->render('@HoneybeeWeb/pages/faq.html.twig', array(
  2367.             'page_title'     => 'FAQ | HoneyBee — EPC, Industrial & Platform Questions',
  2368.             'packageDetails' => GeneralConstant::$packageDetails,
  2369.         ));
  2370.     }
  2372.     // terms and condiitons
  2373.     public function CentralTermsAndConditionPageAction()
  2374.     {
  2375.         return $this->render('@HoneybeeWeb/pages/terms_and_conditions.html.twig', array(
  2376.             'page_title' => 'Terms and Conditions',
  2378.         ));
  2379.     }
  2382.     // Refund Policy
  2383.    public function CentralRefundPolicyPageAction()
  2384. {
  2385.     return $this->render('@HoneybeeWeb/pages/refund_policy.html.twig', array(
  2386.         'page_title' => 'Refund Policy',
  2387.     ));
  2388. }
  2390.     // Cancellation Policy
  2391.    public function CentralCancellationPolicyPageAction()
  2392. {
  2393.     return $this->render('@HoneybeeWeb/pages/cancellation_policy.html.twig', array(
  2394.            'page_title' => 'Cancellation Policy',
  2395.     ));
  2396. }
  2398.     // Help page
  2399.    public function CentralHelpPageAction()
  2400.    {
  2401.     return $this->render('@HoneybeeWeb/pages/help.html.twig', array(
  2402.         'page_title' => 'Help',
  2403.     ));
  2404.    }
  2406.  // Career page
  2407.    public function CentralCareerPageAction()
  2408. {
  2409.     return $this->render('@HoneybeeWeb/pages/career.html.twig', array(
  2410.         'page_title' => 'Career',
  2411.     ));
  2412. }
  2414.     public function CentralPrivacyPolicyAction()
  2415.     {
  2416.         return $this->render('@HoneybeeWeb/pages/privacy_policy.html.twig', array(
  2417.             'page_title' => 'Privacy Policy — HoneyBee',
  2418.         ));
  2419.     }
  2421.     public function CentralDpaPageAction()
  2422.     {
  2423.         return $this->render('@HoneybeeWeb/pages/dpa.html.twig', array(
  2424.             'page_title' => 'Data Processing Addendum (DPA) — HoneyBee',
  2425.         ));
  2426.     }
  2428.     public function CentralSolutionsPageAction()
  2429.     {
  2430.         return $this->render('@HoneybeeWeb/pages/solutions.html.twig', array(
  2431.             'page_title' => 'HoneyBee Solutions | EPC, Energy Asset, IPP/OPEX/PPA & Multi-Site Operations',
  2432.             'og_title' => 'HoneyBee Solutions | EPC, Energy Asset, IPP/OPEX/PPA & Multi-Site Operations',
  2433.             'og_description' => 'HoneyBee delivers purpose-built solutions for EPC contractors, energy asset managers, IPP/OPEX/PPA operators, and multi-site industrial businesses. HoneyBee is not an EPC contractor or project developer.',
  2434.         ));
  2435.     }
  2437.     public function CentralPartnersPageAction()
  2438.     {
  2439.         return $this->render('@HoneybeeWeb/pages/partners.html.twig', array(
  2440.             'page_title' => 'HoneyBee Partner Program | Implementation, HoneyCore Edge+, IoT & Infrastructure Partners',
  2441.             'og_title' => 'HoneyBee Partner Program | Implementation, HoneyCore Edge+, IoT & Infrastructure Partners',
  2442.             'og_description' => 'Join the HoneyBee partner ecosystem as an implementation partner, HoneyCore Edge+ local infrastructure partner, IoT hardware reseller, or software integration partner.',
  2443.         ));
  2444.     }
  2446.     public function CheckoutPageAction(Request $request, $encData = '')
  2447.     {
  2448.         $em = $this->getDoctrine()->getManager('company_group');
  2449.         $em_goc = $this->getDoctrine()->getManager('company_group');
  2450.         $sandBoxMode = $this->container->hasParameter('sand_box_mode') ? $this->container->getParameter('sand_box_mode') : 0;
  2452.         $invoiceId = $request->request->get('invoiceId', $request->query->get('invoiceId', 0));
  2453.         if ($encData != "") {
  2455.             $encryptedData = json_decode($this->get('url_encryptor')->decrypt($encData), true);
  2456.             if ($encryptedData == null) $encryptedData = [];
  2457.             if (isset($encryptedData['invoiceId'])) $invoiceId = $encryptedData['invoiceId'];
  2459.         }
  2460.         $session = $request->getSession();
  2461.         $currencyForGateway = 'eur';
  2462.         $gatewayInvoice = null;
  2463.         if ($invoiceId != 0)
  2464.             $gatewayInvoice = $em->getRepository(EntityInvoice::class)->find($invoiceId);
  2467.         $paymentGateway = $request->request->get('paymentGateway', 'stripe'); //aamarpay,bkash
  2468.         $paymentType = $request->request->get('paymentType', 'credit');
  2469.         $retailerId = $request->request->get('retailerId', 0);
  2470.         if ($request->query->has('currency'))
  2471.             $currencyForGateway = $request->query->get('currency');
  2472.         else
  2473.             $currencyForGateway = $request->request->get('currency', 'eur');
  2475. //        {
  2476. //            if ($request->query->has('meetingSessionId'))
  2477. //                $id = $request->query->get('meetingSessionId');
  2478. //        }
  2481.         $currentUserBalance = 0;
  2482.         $currentUserCoinBalance = 0;
  2484.         $gatewayAmount = 0;
  2485.         $redeemedAmount = 0;
  2486.         $redeemedSessionCount = 0;
  2487.         $toConsumeSessionCount = 0;
  2488.         $invoiceSessionCount = 0;
  2489.         $payableAmount = 0;
  2490.         $promoClaimedAmount = 0;
  2491.         $promoCodeId = 0;
  2492.         $promoClaimedSession = 0;
  2494.         $bookingExpireTime = null;
  2495.         $bookingExpireTs = 0;
  2498.         $imageBySessionCount = [
  2499.             0 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2500.             100 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2501.             200 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2502.             300 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2503.             400 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2504.             500 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2505.             600 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2506.             700 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2507.             800 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2508.             900 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2509.             1000 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2510.             1100 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2511.             1200 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2512.             1300 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2513.             1400 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2514.             1500 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2516.             1600 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2517.             1700 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2518.             1800 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2519.             1900 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2520.             2000 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2521.             2100 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2522.             2200 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2523.             2300 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2524.             2400 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2525.             2500 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2526.             2600 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2527.             2700 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2528.             2800 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2529.             2900 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2530.             3000 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2531.             3100 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2532.             3200 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2533.             3300 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2534.             3400 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2535.             3500 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2536.             3600 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2537.             3700 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  2538.         ];
  2541.         if (!$gatewayInvoice) {
  2543.             if ($request->isMethod('POST')) {
  2545.                 $totalAmount = 0;
  2546.                 $totalSessionCount = 0;
  2547.                 $consumedAmount = 0;
  2548.                 $consumedSessionCount = 0;
  2549.                 $bookedById = 0;
  2550.                 $bookingRefererId = 0;
  2553.                 if ($session->get(UserConstants::USER_ID)) {
  2554.                     $bookedById = $session->get(UserConstants::USER_ID);
  2555.                     $bookingRefererId = 0;
  2557. //                    $toConsumeSessionCount = 1 * $request->request->get('meetingSessionConsumeCount', 0);
  2558.                     $invoiceSessionCount = 1 * ($request->request->get('sessionCount', 0) == '' ? 0 : $request->request->get('sessionCount', 0));
  2560.                     //1st do the necessary
  2561.                     $extMeeting = null;
  2562.                     $meetingSessionId = 0;
  2563.                     if ($request->request->has('purchasePackage')) {
  2566.                         //1. check if any bee card if yes try to claim it , modify current balance then
  2568.                         $beeCodeSerial = $request->request->get('beeCodeSerial', '');
  2569.                         $promoCode = $request->request->get('promoCode', '');
  2570.                         $beeCodePin = $request->request->get('beeCodePin', '');
  2571.                         $userId = $request->request->get('userId', $session->get(UserConstants::USER_ID));
  2573.                         $studentDetails = null;
  2574.                         $studentDetails = $em_goc->getRepository(EntityApplicantDetails::class)->find($userId);
  2575.                         if ($studentDetails) {
  2576.                             $currentUserBalance = $studentDetails->getAccountBalance();
  2577.                         }
  2580.                         if ($beeCodeSerial != '' && $beeCodePin != '') {
  2581.                             $claimData = MiscActions::ClaimBeeCode($em,
  2582.                                 [
  2583.                                     'claimFlag' => 1,
  2584.                                     'pin' => $beeCodePin,
  2585.                                     'serial' => $beeCodeSerial,
  2586.                                     'userId' => $userId,
  2587.                                 ]);
  2589.                             if ($userId == $session->get(UserConstants::USER_ID)) {
  2590.                                 MiscActions::RefreshBuddybeeBalanceOnSession($em, $request->getSession());
  2593.                                 $claimData['newCoinBalance'] = $session->get('BUDDYBEE_COIN_BALANCE');
  2594.                                 $claimData['newBalance'] = $session->get('BUDDYBEE_BALANCE');
  2595.                             }
  2598.                             $redeemedAmount = $claimData['data']['claimedAmount'];
  2599.                             $redeemedSessionCount = $claimData['data']['claimedCoin'];
  2602.                         } else
  2603.                             if ($userId == $session->get(UserConstants::USER_ID)) {
  2604.                                 MiscActions::RefreshBuddybeeBalanceOnSession($em, $request->getSession());
  2605.                             }
  2606.                         $payableAmount = round($request->request->get('payableAmount', 0), 0);
  2608.                         $totalAmountWoDiscount = round($request->request->get('totalAmountWoDiscount', 0), 0);
  2609.                         //now claim and process promocode
  2610.                         if ($promoCode != '') {
  2613.                             $claimData = MiscActions::ClaimPromoCode($em,
  2614.                                 [
  2616.                                     'claimFlag' => 1,
  2617.                                     'promoCode' => $promoCode,
  2618.                                     'decryptedPromoCodeData' => json_decode($this->get('url_encryptor')->decrypt($promoCode), true),
  2619.                                     'orderValue' => $totalAmountWoDiscount,
  2620.                                     'currency' => $currencyForGateway,
  2621.                                     'orderCoin' => $invoiceSessionCount,
  2623.                                     'userId' => $userId,
  2624.                                 ]);
  2627.                             $promoClaimedAmount = 0;
  2628. //                            $promoClaimedAmount = $claimData['data']['claimedAmount']*(BuddybeeConstant::$convMultFromTo['eur'][$currencyForGateway]);
  2629.                             $promoCodeId = $claimData['promoCodeId'];
  2630.                             $promoClaimedSession = $claimData['data']['claimedCoin'];
  2633.                         }
  2635.                         if ($userId == $session->get(UserConstants::USER_ID)) {
  2636.                             MiscActions::RefreshBuddybeeBalanceOnSession($em, $request->getSession());
  2637.                             $currentUserBalance = $session->get('BUDDYBEE_BALANCE');
  2638.                             $currentUserCoinBalance = $session->get('BUDDYBEE_COIN_BALANCE');
  2639.                         } else {
  2640.                             if ($bookingRefererId == 0)
  2641.                                 $bookingRefererId = $session->get(UserConstants::USER_ID);
  2642.                             $studentDetails = $em_goc->getRepository(EntityApplicantDetails::class)->find($userId);
  2643.                             if ($studentDetails) {
  2644.                                 $currentUserBalance = $studentDetails->getAccountBalance();
  2645.                                 $currentUserCoinBalance = $studentDetails->getSessionCountBalance();
  2646.                                 if ($bookingRefererId != $userId && $bookingRefererId != 0) {
  2647.                                     $bookingReferer = $em_goc->getRepository(EntityApplicantDetails::class)->find($bookingRefererId);
  2648.                                     if ($bookingReferer)
  2649.                                         if ($bookingReferer->getIsAdmin()) {
  2650.                                             $studentDetails->setAssignedSalesRepresentativeId($bookingRefererId);
  2651.                                             $em_goc->flush();
  2652.                                         }
  2654.                                 }
  2655.                             }
  2656.                         }
  2659.                         //2. check if any promo code  if yes add it to promo discount
  2662.                         //3. check if scheule is still temporarily booked if not return that you cannot book it
  2665.                         Buddybee::ExpireAnyMeetingSessionIfNeeded($em);
  2666.                         Buddybee::ExpireAnyEntityInvoiceIfNeeded($em);
  2669. //                        if ($request->request->get('autoAssignMeetingSession', 0) == 1
  2670. //                            && $request->request->get('consultancyScheduleId', 0) != 0
  2671. //                            && $request->request->get('consultancyScheduleId', 0) != ''
  2672. //                        )
  2673.                         {
  2676.                             //1st check if a meeting session exxists with same TS, student id , consultant id
  2678. //                            $scheduledStartTime = new \DateTime('@' . $request->request->get('consultancyScheduleId', ''));
  2679. //                            $extMeeting = $em->getRepository('CompanyGroupBundle\\Entity\\EntityMeetingSession')
  2680. //                                ->findOneBy(
  2681. //                                    array(
  2682. //                                        'scheduledTimeTs' => $scheduledStartTime->format('U'),
  2683. //                                        'consultantId' => $request->request->get('consultantId', 0),
  2684. //                                        'studentId' => $request->request->get('studentId', 0),
  2685. //                                        'durationAllowedMin' => $request->request->get('meetingSessionScheduledDuration', BuddybeeConstant::PER_SESSION_MINUTE),
  2686. //                                    )
  2687. //                                );
  2689. //                            if ($extMeeting) {
  2690. //                                $new = $extMeeting;
  2691. //                                $meetingSessionId = $new->getSessionId();
  2692. //                                $periodMarker = $scheduledStartTime->format('Ym');
  2693. //
  2694. //                            }
  2695. //                            else {
  2696. //
  2697. //
  2698. //                                $scheduleValidity = MiscActions::CheckIfScheduleCanBeConfirmed(
  2699. //                                    $em,
  2700. //                                    $request->request->get('consultantId', 0),
  2701. //                                    $request->request->get('studentId', 0),
  2702. //                                    $scheduledStartTime->format('U'),
  2703. //                                    $request->request->get('meetingSessionScheduledDuration', BuddybeeConstant::PER_SESSION_MINUTE),
  2704. //                                    1
  2705. //                                );
  2706. //
  2707. //                                if (!$scheduleValidity) {
  2708. //                                    $url = $this->generateUrl(
  2709. //                                        'consultant_profile'
  2710. //                                    );
  2711. //                                    $output = [
  2712. //
  2713. //                                        'proceedToCheckout' => 0,
  2714. //                                        'message' => 'Session Booking Expired or not Found!',
  2715. //                                        'errorFlag' => 1,
  2716. //                                        'redirectUrl' => $url . '/' . $request->request->get('consultantId', 0)
  2717. //                                    ];
  2718. //                                    return new JsonResponse($output);
  2719. //                                }
  2720. //                                $new = new EntityMeetingSession();
  2721. //
  2722. //                                $new->setTopicId($request->request->get('consultancyTopic', 0));
  2723. //                                $new->setConsultantId($request->request->get('consultantId', 0));
  2724. //                                $new->setStudentId($request->request->get('studentId', 0));
  2725. //                                $consultancyTopic = $em_goc->getRepository(EntityCreateTopic::class)->find($request->request->get('consultancyTopic', 0));
  2726. //                                $new->setMeetingType($consultancyTopic ? $consultancyTopic->getMeetingType() : 0);
  2727. //                                $new->setConsultantCanUpload($consultancyTopic ? $consultancyTopic->getConsultantCanUpload() : 0);
  2728. //
  2729. //
  2730. //                                $scheduledEndTime = new \DateTime($request->request->get('scheduledTime', ''));
  2731. //                                $scheduledEndTime = $scheduledEndTime->modify('+' . $request->request->get('meetingSessionScheduledDuration', 30) . ' minute');
  2732. //
  2733. //                                //$new->setScheduledTime($request->request->get('setScheduledTime'));
  2734. //                                $new->setScheduledTime($scheduledStartTime);
  2735. //                                $new->setDurationAllowedMin($request->request->get('meetingSessionScheduledDuration', 30));
  2736. //                                $new->setDurationLeftMin($request->request->get('meetingSessionScheduledDuration', 30));
  2737. //                                $new->setSessionExpireDate($scheduledEndTime);
  2738. //                                $new->setSessionExpireDateTs($scheduledEndTime->format('U'));
  2739. //                                $new->setEquivalentSessionCount($request->request->get('meetingSessionConsumeCount', 0));
  2740. //                                $new->setMeetingSpecificNote($request->request->get('meetingSpecificNote', ''));
  2741. //
  2742. //                                $new->setUsableSessionCount($request->request->get('meetingSessionConsumeCount', 0));
  2743. //                                $new->setRedeemSessionCount($request->request->get('meetingSessionConsumeCount', 0));
  2744. //                                $new->setMeetingActionFlag(0);// no action waiting for meeting
  2745. //                                $new->setScheduledTime($scheduledStartTime);
  2746. //                                $new->setScheduledTimeTs($scheduledStartTime->format('U'));
  2747. //                                $new->setPayableAmount($request->request->get('payableAmount', 0));
  2748. //                                $new->setDueAmount($request->request->get('dueAmount', 0));
  2749. //                                //$new->setScheduledTime(new \DateTime($request->get('setScheduledTime')));
  2750. //                                //$new->setPcakageDetails(json_encode(($request->request->get('packageData'))));
  2751. //                                $new->setPackageName(($request->request->get('packageName', '')));
  2752. //                                $new->setPcakageDetails(($request->request->get('packageData', '')));
  2753. //                                $new->setScheduleId(($request->request->get('consultancyScheduleId', 0)));
  2754. //                                $currentUnixTime = new \DateTime();
  2755. //                                $currentUnixTimeStamp = $currentUnixTime->format('U');
  2756. //                                $studentId = $request->request->get('studentId', 0);
  2757. //                                $consultantId = $request->request->get('consultantId', 0);
  2758. //                                $new->setMeetingRoomId(str_pad($consultantId, 4, STR_PAD_LEFT) . $currentUnixTimeStamp . str_pad($studentId, 4, STR_PAD_LEFT));
  2759. //                                $new->setSessionValue(($request->request->get('sessionValue', 0)));
  2760. ////                        $new->setIsPayment(0);
  2761. //                                $new->setConsultantIsPaidFull(0);
  2762. //
  2763. //                                if ($bookingExpireTs == 0) {
  2764. //
  2765. //                                    $bookingExpireTime = new \DateTime();
  2766. //                                    $currTime = new \DateTime();
  2767. //                                    $currTimeTs = $currTime->format('U');
  2768. //                                    $bookingExpireTs = (1 * $scheduledStartTime->format('U')) - (24 * 3600);
  2769. //                                    if ($bookingExpireTs < $currTimeTs) {
  2770. //                                        if ((1 * $scheduledStartTime->format('U')) - $currTimeTs > (12 * 3600))
  2771. //                                            $bookingExpireTs = (1 * $scheduledStartTime->format('U')) - (2 * 3600);
  2772. //                                        else
  2773. //                                            $bookingExpireTs = (1 * $scheduledStartTime->format('U'));
  2774. //                                    }
  2775. //
  2776. ////                                    $bookingExpireTs = $bookingExpireTime->format('U');
  2777. //                                }
  2778. //
  2779. //                                $new->setPaidSessionCount(0);
  2780. //                                $new->setBookedById($bookedById);
  2781. //                                $new->setBookingRefererId($bookingRefererId);
  2782. //                                $new->setDueSessionCount($request->request->get('meetingSessionConsumeCount', 0));
  2783. //                                $new->setExpireIfUnpaidTs($bookingExpireTs);
  2784. //                                $new->setBookingExpireTs($bookingExpireTs);
  2785. //                                $new->setConfirmationExpireTs($bookingExpireTs);
  2786. //                                $new->setIsPaidFull(0);
  2787. //                                $new->setIsExpired(0);
  2788. //
  2789. //
  2790. //                                $em_goc->persist($new);
  2791. //                                $em_goc->flush();
  2792. //                                $meetingSessionId = $new->getSessionId();
  2793. //                                $periodMarker = $scheduledStartTime->format('Ym');
  2794. //                                MiscActions::UpdateSchedulingRestrictions($em_goc, $consultantId, $periodMarker, (($request->request->get('meetingSessionScheduledDuration', 30)) / 60), -(($request->request->get('meetingSessionScheduledDuration', 30)) / 60));
  2795. //                            }
  2797.                         }
  2800.                         //4. if after all this stages passed then calcualte gateway payable
  2803.                         if ($request->request->get('isRecharge', 0) == 1) {
  2804.                             if (($redeemedAmount + $promoClaimedAmount) >= $payableAmount) {
  2805.                                 $payableAmount = ($redeemedAmount + $promoClaimedAmount);
  2806.                                 $gatewayAmount = 0;
  2807.                             } else
  2808.                                 $gatewayAmount = $payableAmount - ($redeemedAmount + $promoClaimedAmount);
  2809.                         } else {
  2810.                             if ($toConsumeSessionCount <= $currentUserCoinBalance && $invoiceSessionCount <= $toConsumeSessionCount) {
  2811.                                 $payableAmount = 0;
  2812.                                 $gatewayAmount = 0;
  2813.                             } else if (($redeemedAmount + $promoClaimedAmount) >= $payableAmount) {
  2814.                                 $payableAmount = ($redeemedAmount + $promoClaimedAmount);
  2815.                                 $gatewayAmount = 0;
  2816.                             } else
  2817.                                 $gatewayAmount = $payableAmount <= ($currentUserBalance + ($redeemedAmount + $promoClaimedAmount)) ? 0 : ($payableAmount - $currentUserBalance - ($redeemedAmount + $promoClaimedAmount));
  2818.                         }
  2819.                         $gatewayAmount = round($gatewayAmount, 2);
  2820.                         $dueAmount = round($request->request->get('dueAmount', $payableAmount), 0);
  2823.                         if ($request->request->has('gatewayProductData'))
  2824.                             $gatewayProductData = $request->request->get('gatewayProductData');
  2825.                         $gatewayProductData = [[
  2826.                             'price_data' => [
  2827.                                 'currency' => $currencyForGateway,
  2828.                                 'unit_amount' => $gatewayAmount != 0 ? ((100 * $gatewayAmount) / ($invoiceSessionCount != 0 ? $invoiceSessionCount : 1)) : 200000,
  2829.                                 'product_data' => [
  2830. //                            'name' => $request->request->has('packageName') ? $request->request->get('packageName') : 'Advanced Consultancy Package',
  2831.                                     'name' => 'Bee Coins',
  2832.                                     'images' => [$imageBySessionCount[0]],
  2833.                                 ],
  2834.                             ],
  2835.                             'quantity' => $invoiceSessionCount != 0 ? $invoiceSessionCount : 1,
  2836.                         ]];
  2839.                         $new_invoice = null;
  2842.                         if ($extMeeting) {
  2843.                             $new_invoice = $em->getRepository('CompanyGroupBundle\\Entity\\EntityInvoice')
  2844.                                 ->findOneBy(
  2845.                                     array(
  2846.                                         'invoiceType' => $request->request->get('invoiceType', BuddybeeConstant::ENTITY_INVOICE_TYPE_PAYMENT_TO_HONEYBEE),
  2847.                                         'meetingId' => $extMeeting->getSessionId(),
  2848.                                     )
  2849.                                 );
  2850.                         }
  2852.                         if ($new_invoice) {
  2854.                         } else {
  2857.                             $new_invoice = new EntityInvoice();
  2858.                             $invoiceDate = new \DateTime();
  2859.                             $new_invoice->setInvoiceDate($invoiceDate);
  2860.                             $new_invoice->setInvoiceDateTs($invoiceDate->format('U'));
  2861.                             $new_invoice->setStudentId($userId);
  2863.                             $new_invoice->setBillerId($retailerId == 0 ? 0 : $retailerId);
  2864.                             $new_invoice->setRetailerId($retailerId);
  2865.                             $new_invoice->setBillToId($userId);
  2866.                             $new_invoice->setAmountTransferGateWayHash($paymentGateway);
  2867.                             $new_invoice->setAmountCurrency($currencyForGateway);
  2868.                             $cardIds = $request->request->get('cardIds', []);
  2871.                             $new_invoice->setMeetingId($meetingSessionId);
  2873.                             $new_invoice->setGatewayBillAmount($gatewayAmount);
  2874.                             $new_invoice->setRedeemedAmount($redeemedAmount);
  2875.                             $new_invoice->setPromoDiscountAmount($promoClaimedAmount);
  2876.                             $new_invoice->setPromoCodeId($promoCodeId);
  2877.                             $new_invoice->setRedeemedSessionCount($redeemedSessionCount);
  2878.                             $new_invoice->setPaidAmount($payableAmount - $dueAmount);
  2879.                             $new_invoice->setProductDataForPaymentGateway(json_encode($gatewayProductData));
  2880.                             $new_invoice->setDueAmount($dueAmount);
  2881.                             $new_invoice->setInvoiceType($request->request->get('invoiceType', BuddybeeConstant::ENTITY_INVOICE_TYPE_PAYMENT_TO_HONEYBEE));
  2883.                             $new_invoice->setDocumentHash(MiscActions::GenerateRandomCrypto('BEI' . microtime(true)));
  2884.                             $new_invoice->setCardIds(json_encode($cardIds));
  2885.                             $new_invoice->setAmountType($request->request->get('amountType', 1));
  2886.                             $new_invoice->setAmount($payableAmount);
  2887.                             $new_invoice->setConsumeAmount($payableAmount);
  2888.                             $new_invoice->setSessionCount($invoiceSessionCount);
  2889.                             $new_invoice->setConsumeSessionCount($toConsumeSessionCount);
  2890.                             $new_invoice->setIsPaidfull(0);
  2891.                             $new_invoice->setIsProcessed(0);
  2892.                             $new_invoice->setApplicantId($userId);
  2893.                             $new_invoice->setBookedById($bookedById);
  2894.                             $new_invoice->setBookingRefererId($bookingRefererId);
  2895.                             $new_invoice->setIsRecharge($request->request->get('isRecharge', 0));
  2896.                             $new_invoice->setAutoConfirmTaggedMeeting($request->request->get('autoConfirmTaggedMeeting', 0));
  2897.                             $new_invoice->setAutoConfirmOtherMeeting($request->request->get('autoConfirmOtherMeeting', 0));
  2898.                             $new_invoice->setAutoClaimPurchasedCards($request->request->get('autoClaimPurchasedCards', 0));
  2899.                             $new_invoice->setIsPayment(0); //0 means receive
  2900.                             $new_invoice->setStatus(GeneralConstant::ACTIVE); //0 means receive
  2901.                             $new_invoice->setStage(BuddybeeConstant::ENTITY_INVOICE_STAGE_INITIATED); //0 means receive
  2903.                             if ($bookingExpireTs == 0) {
  2905.                                 $bookingExpireTime = new \DateTime();
  2906.                                 $bookingExpireTime->modify('+30 day');
  2907.                                 $bookingExpireTs = $bookingExpireTime->format('U');
  2908.                             }
  2911.                             $new_invoice->setExpireIfUnpaidTs($bookingExpireTs);
  2912.                             $new_invoice->setBookingExpireTs($bookingExpireTs);
  2913.                             $new_invoice->setConfirmationExpireTs($bookingExpireTs);
  2915. //            $new_invoice->setStatus($request->request->get(0));
  2917.                             $em_goc->persist($new_invoice);
  2918.                             $em_goc->flush();
  2919.                         }
  2922.                         $invoiceId = $new_invoice->getId();
  2923.                         $gatewayInvoice = $new_invoice;
  2926.                         if ($request->request->get('isRecharge', 0) == 1) {
  2928.                         } else {
  2930.                             if ($gatewayAmount <= 0) {
  2931.                                 $meetingId = 0;
  2933.                                 if ($invoiceId != 0) {
  2935.                                     $retData = Buddybee::ProcessEntityInvoice($em_goc, $invoiceId, ['stage' => BuddybeeConstant::ENTITY_INVOICE_STAGE_COMPLETED], $this->container->getParameter('kernel.root_dir'), false,
  2936.                                         $this->container->getParameter('notification_enabled'),
  2937.                                         $this->container->getParameter('notification_server')
  2938.                                     );
  2940.                                     $meetingId = $retData['meetingId'];
  2943.                                 }
  2945.                                 MiscActions::RefreshBuddybeeBalanceOnSession($em, $request->getSession());
  2946.                                 if (GeneralConstant::EMAIL_ENABLED == 1) {
  2947.                                     $billerDetails = [];
  2948.                                     $billToDetails = [];
  2950.                                     $invoice = $gatewayInvoice;
  2951.                                     if ($invoice) {
  2952.                                         $billerDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  2953.                                             ->findOneBy(
  2954.                                                 array(
  2955.                                                     'applicantId' => $invoice->getBillerId(),
  2957.                                                 )
  2958.                                             );
  2959.                                         $billToDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  2960.                                             ->findOneBy(
  2961.                                                 array(
  2962.                                                     'applicantId' => $invoice->getBillToId(),
  2964.                                                 )
  2965.                                             );
  2967.                                     }
  2969.                                     $bodyTemplate = '@Application/email/templates/buddybeeInvoiceEmail.html.twig';
  2970.                                     $bodyData = array(
  2971.                                         'page_title' => 'Invoice',
  2972. //            'studentDetails' => $student,
  2973.                                         'billerDetails' => $billerDetails,
  2974.                                         'billToDetails' => $billToDetails,
  2975.                                         'invoice' => $invoice,
  2976.                                         'currencyList' => BuddybeeConstant::$currency_List,
  2977.                                         'currencyListByMarker' => BuddybeeConstant::$currency_List_by_marker,
  2980.                                     );
  2981.                                     $attachments = [];
  2982.                                     $forwardToMailAddress = $billToDetails->getOAuthEmail();
  2985. //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  2986.                                     $new_mail = $this->get('mail_module');
  2987.                                     $new_mail->sendMyMail(array(
  2988.                                         'senderHash' => '_CUSTOM_',
  2989.                                         //                        'senderHash'=>'_CUSTOM_',
  2990.                                         'forwardToMailAddress' => $forwardToMailAddress,
  2992.                                         'subject' => 'YourInvoice #' . 'D' . str_pad('BB', 5, '0', STR_PAD_LEFT) . str_pad('76', 2, '0', STR_PAD_LEFT) . str_pad($invoice->getId(), 8, "0", STR_PAD_LEFT) . ' from BuddyBee ',
  2994. //                        'fileName' => 'Order#' . str_pad($id, 8, '0', STR_PAD_LEFT) . '.pdf',
  2995.                                         'attachments' => $attachments,
  2996.                                         'toAddress' => $forwardToMailAddress,
  2997.                                         'fromAddress' => 'no-reply@buddybee.eu',
  2998.                                         'userName' => 'no-reply@buddybee.eu',
  2999.                                         'password' => 'Honeybee@0112',
  3000.                                         'smtpServer' => 'smtp.hostinger.com',
  3001.                                         'smtpPort' => 465,
  3003. //                            'emailBody' => $bodyHtml,
  3004.                                         'mailTemplate' => $bodyTemplate,
  3005.                                         'templateData' => $bodyData,
  3006.                                         'embedCompanyImage' => 0,
  3007.                                         'companyId' => 0,
  3009.                                         'companyImagePath' => ''
  3010. //                        'embedCompanyImage' => 1,
  3011. //                        'companyId' => $companyId,
  3012. //                        'companyImagePath' => $company_data->getImage()
  3015.                                     ));
  3018.                                 }
  3020.                                 if ($meetingId != 0) {
  3021.                                     $url = $this->generateUrl(
  3022.                                         'consultancy_session'
  3023.                                     );
  3024.                                     $output = [
  3025.                                         'invoiceId' => $gatewayInvoice->getId(),
  3026.                                         'meetingId' => $meetingId,
  3028.                                         'proceedToCheckout' => 0,
  3029.                                         'redirectUrl' => $url . '/' . $meetingId
  3030.                                     ];
  3031.                                 } else {
  3032.                                     $url = $this->generateUrl(
  3033.                                         'buddybee_dashboard'
  3034.                                     );
  3035.                                     $output = [
  3036.                                         'invoiceId' => $gatewayInvoice->getId(),
  3037.                                         'meetingId' => 0,
  3039.                                         'proceedToCheckout' => 0,
  3040.                                         'redirectUrl' => $url
  3041.                                     ];
  3042.                                 }
  3043.                                 return new JsonResponse($output);
  3044. //                return $this->redirect($url);
  3045.                             } else {
  3047.                             }
  3048. //                $url = $this->generateUrl(
  3049. //                    'checkout_page'
  3050. //                );
  3051. //
  3052. //                return $this->redirect($url."?meetingSessionId=".$new->getSessionId().'&invoiceId='.$invoiceId);
  3053.                         }
  3056.                     }
  3057.                 } else {
  3058.                     $url = $this->generateUrl(
  3059.                         'user_login'
  3060.                     );
  3062.                     $session->set('LAST_REQUEST_URI_BEFORE_LOGIN', $this->generateUrl(
  3063.                         'pricing_plan_page', [
  3064.                         'autoRedirected' => 1
  3065.                     ],
  3066.                         UrlGenerator::ABSOLUTE_URL
  3067.                     ));
  3069.                     $output = [
  3071.                         'proceedToCheckout' => 0,
  3072.                         'redirectUrl' => $url,
  3073.                         'clearLs' => 0
  3074.                     ];
  3075.                     return new JsonResponse($output);
  3076.                 }
  3079.                 //now proceed to checkout page if the user has lower balance or recharging
  3082.                 //$invoiceDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityInvoice')->
  3085.             }
  3086.         }
  3087.         if ($gatewayInvoice) {
  3090.             $gatewayProductData = json_decode($gatewayInvoice->getProductDataForPaymentGateway(), true);
  3091.             if ($gatewayProductData == null) $gatewayProductData = [];
  3092.             if (empty($gatewayProductData))
  3093.                 $gatewayProductData = [
  3094.                     [
  3095.                         'price_data' => [
  3096.                             'currency' => 'eur',
  3097.                             'unit_amount' => $gatewayAmount != 0 ? (100 * $gatewayAmount) : 200000,
  3098.                             'product_data' => [
  3099. //                            'name' => $request->request->has('packageName') ? $request->request->get('packageName') : 'Advanced Consultancy Package',
  3100.                                 'name' => 'Bee Coins',
  3101.                                 'images' => [$imageBySessionCount[0]],
  3102.                             ],
  3103.                         ],
  3104.                         'quantity' => 1,
  3105.                     ]
  3106.                 ];
  3108.             $productDescStr = '';
  3109.             $productDescArr = [];
  3110.             foreach ($gatewayProductData as $gpd) {
  3111.                 $productDescArr[] = $gpd['price_data']['product_data']['name'];
  3112.             }
  3113.             $productDescStr = implode(',', $productDescArr);
  3114.             $paymentGatewayFromInvoice = $gatewayInvoice->getAmountTransferGateWayHash();
  3115. //            return new JsonResponse(
  3116. //                [
  3117. //                    'paymentGateway' => $paymentGatewayFromInvoice,
  3118. //                    'gateWayData' => $gatewayProductData[0]
  3119. //                ]
  3120. //            );
  3121.             if ($paymentGateway == null) $paymentGatewayFromInvoice = 'stripe';
  3123.             if ($paymentGatewayFromInvoice == 'stripe' || $paymentGatewayFromInvoice == 'aamarpay' || $paymentGatewayFromInvoice == 'bkash') {
  3124.                 if (GeneralConstant::EMAIL_ENABLED == 1) {
  3125.                     $billerDetails = [];
  3126.                     $billToDetails = [];
  3128.                     $invoice = $gatewayInvoice;
  3129.                     if ($invoice) {
  3130.                         $billerDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  3131.                             ->findOneBy(
  3132.                                 array(
  3133.                                     'applicantId' => $invoice->getBillerId(),
  3135.                                 )
  3136.                             );
  3137.                         $billToDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  3138.                             ->findOneBy(
  3139.                                 array(
  3140.                                     'applicantId' => $invoice->getBillToId(),
  3142.                                 )
  3143.                             );
  3145.                     }
  3147.                     $bodyTemplate = '@Application/email/templates/buddybeeInvoiceEmail.html.twig';
  3148.                     $bodyData = array(
  3149.                         'page_title' => 'Invoice',
  3150. //            'studentDetails' => $student,
  3151.                         'billerDetails' => $billerDetails,
  3152.                         'billToDetails' => $billToDetails,
  3153.                         'invoice' => $invoice,
  3154.                         'currencyList' => BuddybeeConstant::$currency_List,
  3155.                         'currencyListByMarker' => BuddybeeConstant::$currency_List_by_marker,
  3158.                     );
  3159.                     $attachments = [];
  3160.                     $forwardToMailAddress = $billToDetails->getOAuthEmail();
  3163. //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  3164.                     $new_mail = $this->get('mail_module');
  3165.                     $new_mail->sendMyMail(array(
  3166.                         'senderHash' => '_CUSTOM_',
  3167.                         //                        'senderHash'=>'_CUSTOM_',
  3168.                         'forwardToMailAddress' => $forwardToMailAddress,
  3170.                         'subject' => 'YourInvoice #' . 'D' . str_pad('BB', 5, '0', STR_PAD_LEFT) . str_pad('76', 2, '0', STR_PAD_LEFT) . str_pad($invoice->getId(), 8, "0", STR_PAD_LEFT) . ' from BuddyBee ',
  3172. //                        'fileName' => 'Order#' . str_pad($id, 8, '0', STR_PAD_LEFT) . '.pdf',
  3173.                         'attachments' => $attachments,
  3174.                         'toAddress' => $forwardToMailAddress,
  3175.                         'fromAddress' => 'no-reply@buddybee.eu',
  3176.                         'userName' => 'no-reply@buddybee.eu',
  3177.                         'password' => 'Honeybee@0112',
  3178.                         'smtpServer' => 'smtp.hostinger.com',
  3179.                         'smtpPort' => 465,
  3181. //                            'emailBody' => $bodyHtml,
  3182.                         'mailTemplate' => $bodyTemplate,
  3183.                         'templateData' => $bodyData,
  3184.                         'embedCompanyImage' => 0,
  3185.                         'companyId' => 0,
  3187.                         'companyImagePath' => ''
  3188. //                        'embedCompanyImage' => 1,
  3189. //                        'companyId' => $companyId,
  3190. //                        'companyImagePath' => $company_data->getImage()
  3193.                     ));
  3196.                 }
  3197.             }
  3199.             if ($paymentGatewayFromInvoice == 'stripe') {
  3200.                 $stripe = new \Stripe\Stripe();
  3201.                 \Stripe\Stripe::setApiKey('sk_test_51IxYTAJXs21fVb0QMop2Nb0E7u9Da4LwGrym1nGHUHqaSNtT3p9HBgHd7YyDsTKHscgPPECPQniTy79Ab8Sgxfbm00JF2AndUz');
  3203.                 $stripe::setApiKey('sk_test_51IxYTAJXs21fVb0QMop2Nb0E7u9Da4LwGrym1nGHUHqaSNtT3p9HBgHd7YyDsTKHscgPPECPQniTy79Ab8Sgxfbm00JF2AndUz');
  3204.                 {
  3205.                     if ($request->query->has('meetingSessionId'))
  3206.                         $id = $request->query->get('meetingSessionId');
  3207.                 }
  3209.                 $paymentIntent = [
  3210.                     "id" => "pi_1DoWjK2eZvKYlo2Csy9J3BHs",
  3211.                     "object" => "payment_intent",
  3212.                     "amount" => 3000,
  3213.                     "amount_capturable" => 0,
  3214.                     "amount_received" => 0,
  3215.                     "application" => null,
  3216.                     "application_fee_amount" => null,
  3217.                     "canceled_at" => null,
  3218.                     "cancellation_reason" => null,
  3219.                     "capture_method" => "automatic",
  3220.                     "charges" => [
  3221.                         "object" => "list",
  3222.                         "data" => [],
  3223.                         "has_more" => false,
  3224.                         "url" => "/v1/charges?payment_intent=pi_1DoWjK2eZvKYlo2Csy9J3BHs"
  3225.                     ],
  3226.                     "client_secret" => "pi_1DoWjK2eZvKYlo2Csy9J3BHs_secret_vmxAcWZxo2kt1XhpWtZtnjDtd",
  3227.                     "confirmation_method" => "automatic",
  3228.                     "created" => 1546523966,
  3229.                     "currency" => $currencyForGateway,
  3230.                     "customer" => null,
  3231.                     "description" => null,
  3232.                     "invoice" => null,
  3233.                     "last_payment_error" => null,
  3234.                     "livemode" => false,
  3235.                     "metadata" => [],
  3236.                     "next_action" => null,
  3237.                     "on_behalf_of" => null,
  3238.                     "payment_method" => null,
  3239.                     "payment_method_options" => [],
  3240.                     "payment_method_types" => [
  3241.                         "card"
  3242.                     ],
  3243.                     "receipt_email" => null,
  3244.                     "review" => null,
  3245.                     "setup_future_usage" => null,
  3246.                     "shipping" => null,
  3247.                     "statement_descriptor" => null,
  3248.                     "statement_descriptor_suffix" => null,
  3249.                     "status" => "requires_payment_method",
  3250.                     "transfer_data" => null,
  3251.                     "transfer_group" => null
  3252.                 ];
  3255.                 $checkout_session = \Stripe\Checkout\Session::create([
  3256.                     'payment_method_types' => ['card'],
  3257.                     'line_items' => $gatewayProductData,
  3258.                     'mode' => 'payment',
  3259.                     'success_url' => $this->generateUrl(
  3260.                         'payment_gateway_success',
  3261.                         ['encData' => $this->get('url_encryptor')->encrypt(json_encode(array(
  3262.                             'invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1)
  3263.                         ))), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  3264.                     ),
  3265.                     'cancel_url' => $this->generateUrl(
  3266.                         'payment_gateway_cancel', ['invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  3267.                     ),
  3268.                 ]);
  3269.                 $output = [
  3270.                     'clientSecret' => $paymentIntent['client_secret'],
  3271.                     'id' => $checkout_session->id,
  3272.                     'paymentGateway' => $paymentGatewayFromInvoice,
  3273.                     'proceedToCheckout' => 1
  3274.                 ];
  3275.                 return new JsonResponse($output);
  3276.             }
  3277.             if ($paymentGatewayFromInvoice == 'aamarpay') {
  3279.                 $studentDetails = $em_goc->getRepository(EntityApplicantDetails::class)->find($gatewayInvoice->getBillToId());
  3282.                 $url = $sandBoxMode == 1 ? 'https://sandbox.aamarpay.com/request.php' : 'https://secure.aamarpay.com/request.php';
  3283.                 $fields = array(
  3284. //                    'store_id' => 'aamarpaytest', //store id will be aamarpay,  contact integration@aamarpay.com for test/live id
  3285.                     'store_id' => $sandBoxMode == 1 ? 'aamarpaytest' : 'buddybee', //store id will be aamarpay,  contact integration@aamarpay.com for test/live id
  3286.                     'amount' => $gatewayInvoice->getGateWayBillamount(), //transaction amount
  3287.                     'payment_type' => 'VISA', //no need to change
  3288.                     'currency' => strtoupper($currencyForGateway),  //currenct will be USD/BDT
  3289.                     'tran_id' => $gatewayInvoice->getDocumentHash(), //transaction id must be unique from your end
  3290.                     'cus_name' => $studentDetails->getFirstname() . ' ' . $studentDetails->getLastName(),  //customer name
  3291.                     'cus_email' => $studentDetails->getEmail(), //customer email address
  3292.                     'cus_add1' => $studentDetails->getCurrAddr(),  //customer address
  3293.                     'cus_add2' => $studentDetails->getCurrAddrCity(), //customer address
  3294.                     'cus_city' => $studentDetails->getCurrAddrCity(),  //customer city
  3295.                     'cus_state' => $studentDetails->getCurrAddrState(),  //state
  3296.                     'cus_postcode' => $studentDetails->getCurrAddrZip(), //postcode or zipcode
  3297.                     'cus_country' => 'Bangladesh',  //country
  3298.                     'cus_phone' => ($studentDetails->getPhone() == null || $studentDetails->getPhone() == '') ? '+8801911706483' : $studentDetails->getPhone(), //customer phone number
  3299.                     'cus_fax' => '',  //fax
  3300.                     'ship_name' => '', //ship name
  3301.                     'ship_add1' => '',  //ship address
  3302.                     'ship_add2' => '',
  3303.                     'ship_city' => '',
  3304.                     'ship_state' => '',
  3305.                     'ship_postcode' => '',
  3306.                     'ship_country' => 'Bangladesh',
  3307.                     'desc' => $productDescStr,
  3308.                     'success_url' => $this->generateUrl(
  3309.                         'payment_gateway_success',
  3310.                         ['encData' => $this->get('url_encryptor')->encrypt(json_encode(array(
  3311.                             'invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1)
  3312.                         ))), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  3313.                     ),
  3314.                     'fail_url' => $this->generateUrl(
  3315.                         'payment_gateway_cancel', ['invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  3316.                     ),
  3317.                     'cancel_url' => $this->generateUrl(
  3318.                         'payment_gateway_cancel', ['invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  3319.                     ),
  3320. //                    'opt_a' => 'Reshad',  //optional paramter
  3321. //                    'opt_b' => 'Akil',
  3322. //                    'opt_c' => 'Liza',
  3323. //                    'opt_d' => 'Sohel',
  3324. //                    'signature_key' => 'dbb74894e82415a2f7ff0ec3a97e4183',  //sandbox
  3325.                     'signature_key' => $sandBoxMode == 1 ? 'dbb74894e82415a2f7ff0ec3a97e4183' : 'b7304a40e21fe15af3be9a948307f524'  //live
  3327.                 ); //signature key will provided aamarpay, contact integration@aamarpay.com for test/live signature key
  3329.                 $fields_string = http_build_query($fields);
  3331. //                $ch = curl_init();
  3332. //                curl_setopt($ch, CURLOPT_VERBOSE, true);
  3333. //                curl_setopt($ch, CURLOPT_URL, $url);
  3334. //
  3335. //                curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
  3336. //                curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  3337. //                curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  3338. //                $url_forward = str_replace('"', '', stripslashes(curl_exec($ch)));
  3339. //                curl_close($ch);
  3341. //                $this->redirect_to_merchant($url_forward);
  3343.                 $output = [
  3345. //
  3346. //                    'redirectUrl' => ($sandBoxMode == 1 ? 'https://sandbox.aamarpay.com/' : 'https://secure.aamarpay.com/') . $url_forward, //keeping it off temporarily
  3347. //                    'fields'=>$fields,
  3348. //                    'fields_string'=>$fields_string,
  3350. //                    'redirectUrl' => $this->generateUrl(
  3351. //                        'payment_gateway_success',
  3352. //                        ['encData' => $this->get('url_encryptor')->encrypt(json_encode(array(
  3353. //                            'invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1)
  3354. //                        ))), 'hbeeSessionToken' => $request->request->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  3355. //                    ),
  3356.                     'paymentGateway' => $paymentGatewayFromInvoice,
  3357.                     'proceedToCheckout' => 1,
  3358.                     'data' => $fields
  3359.                 ];
  3360.                 return new JsonResponse($output);
  3361.             } else if ($paymentGatewayFromInvoice == 'bkash') {
  3363.                 $studentDetails = $em_goc->getRepository(EntityApplicantDetails::class)->find($gatewayInvoice->getBillToId());
  3365.                 $baseUrl = ($sandBoxMode == 1) ? 'https://tokenized.sandbox.bka.sh/v1.2.0-beta' : 'https://tokenized.pay.bka.sh/v1.2.0-beta';
  3366.                 $username_value = ($sandBoxMode == 1) ? 'sandboxTokenizedUser02' : '01891962953';
  3367.                 $password_value = ($sandBoxMode == 1) ? 'sandboxTokenizedUser02@12345' : ',a&kPV4deq&';
  3368.                 $app_key_value = ($sandBoxMode == 1) ? '4f6o0cjiki2rfm34kfdadl1eqq' : '2ueVHdwz5gH3nxx7xn8wotlztc';
  3369.                 $app_secret_value = ($sandBoxMode == 1) ? '2is7hdktrekvrbljjh44ll3d9l1dtjo4pasmjvs5vl5qr3fug4b' : '49Ay3h3wWJMBFD7WF5CassyLrtA1jt6ONhspqjqFx5hTjhqh5dHU';
  3372.                 $request_data = array(
  3373.                     'app_key' => $app_key_value,
  3374.                     'app_secret' => $app_secret_value
  3375.                 );
  3376.                 $url = curl_init($baseUrl . '/tokenized/checkout/token/grant');
  3377.                 $request_data_json = json_encode($request_data);
  3378.                 $header = array(
  3379.                     'Content-Type:application/json',
  3380.                     'username:' . $username_value,
  3381.                     'password:' . $password_value
  3382.                 );
  3383.                 curl_setopt($url, CURLOPT_HTTPHEADER, $header);
  3384.                 curl_setopt($url, CURLOPT_CUSTOMREQUEST, "POST");
  3385.                 curl_setopt($url, CURLOPT_RETURNTRANSFER, true);
  3386.                 curl_setopt($url, CURLOPT_POSTFIELDS, $request_data_json);
  3387.                 curl_setopt($url, CURLOPT_FOLLOWLOCATION, 1);
  3388.                 curl_setopt($url, CURLOPT_IPRESOLVE, CURL_IPRESOLVE_V4);
  3390.                 $tokenData = json_decode(curl_exec($url), true);
  3391.                 curl_close($url);
  3393.                 $id_token = $tokenData['id_token'];
  3394.                 $goToBkashPage = 0;
  3395.                 if ($tokenData['statusCode'] == '0000') {
  3396.                     $auth = $id_token;
  3399.                     $requestbody = array(
  3400.                         "mode" => "0011",
  3401. //                        "payerReference" => "01723888888",
  3402.                         "payerReference" => $invoiceDate->format('U'),
  3403.                         "callbackURL" => $this->generateUrl(
  3404.                             'bkash_callback', [], UrlGenerator::ABSOLUTE_URL
  3405.                         ),
  3406. //                    "merchantAssociationInfo" => "MI05MID54RF09123456One",
  3407.                         "amount" => 1 * number_format($gatewayInvoice->getGateWayBillamount(), 2, '.', ''),
  3408.                         "currency" => "BDT",
  3409.                         "intent" => "sale",
  3410.                         "merchantInvoiceNumber" => $invoiceId
  3411.                     );
  3412.                     $url = curl_init($baseUrl . '/tokenized/checkout/create');
  3413.                     $requestbodyJson = json_encode($requestbody);
  3415.                     $header = array(
  3416.                         'Content-Type:application/json',
  3417.                         'Authorization:' . $auth,
  3418.                         'X-APP-Key:' . $app_key_value
  3419.                     );
  3421.                     curl_setopt($url, CURLOPT_HTTPHEADER, $header);
  3422.                     curl_setopt($url, CURLOPT_CUSTOMREQUEST, "POST");
  3423.                     curl_setopt($url, CURLOPT_RETURNTRANSFER, true);
  3424.                     curl_setopt($url, CURLOPT_POSTFIELDS, $requestbodyJson);
  3425.                     curl_setopt($url, CURLOPT_FOLLOWLOCATION, 1);
  3426.                     curl_setopt($url, CURLOPT_IPRESOLVE, CURL_IPRESOLVE_V4);
  3427.                     $resultdata = curl_exec($url);
  3428. //                    curl_close($url);
  3429. //                    echo $resultdata;
  3431.                     $obj = json_decode($resultdata, true);
  3434.                     $goToBkashPage = 1;
  3437.                     $justNow = new \DateTime();
  3438.                     $justNow->modify('+' . $tokenData['expires_in'] . ' second');
  3439.                     $gatewayInvoice->setGatewayIdTokenExpireTs($justNow->format('U'));
  3440.                     $gatewayInvoice->setGatewayIdToken($tokenData['id_token']);
  3441.                     $gatewayInvoice->setGatewayPaymentId($obj['paymentID']);
  3442.                     $gatewayInvoice->setGatewayIdRefreshToken($tokenData['refresh_token']);
  3443.                     $em->flush();
  3445.                     $output = [
  3447. //                        'redirectUrl' => $obj['bkashURL'],
  3449.                         'paymentGateway' => $paymentGatewayFromInvoice,
  3450.                         'proceedToCheckout' => $goToBkashPage,
  3451.                         'tokenData' => $tokenData,
  3452.                         'obj' => $obj,
  3453.                         'id_token' => $tokenData['id_token'],
  3454.                         'data' => [
  3455.                             'amount' => $gatewayInvoice->getGateWayBillamount(), //transaction amount
  3456. //                            'payment_type' => 'VISA', //no need to change
  3457.                             'currency' => strtoupper($currencyForGateway),  //currenct will be USD/BDT
  3458.                             'tran_id' => $gatewayInvoice->getDocumentHash(), //transaction id must be unique from your end
  3459.                             'cus_name' => $studentDetails->getFirstname() . ' ' . $studentDetails->getLastName(),  //customer name
  3460.                             'cus_email' => $studentDetails->getEmail(), //customer email address
  3461.                             'cus_add1' => $studentDetails->getCurrAddr(),  //customer address
  3462.                             'cus_add2' => $studentDetails->getCurrAddrCity(), //customer address
  3463.                             'cus_city' => $studentDetails->getCurrAddrCity(),  //customer city
  3464.                             'cus_state' => $studentDetails->getCurrAddrState(),  //state
  3465.                             'cus_postcode' => $studentDetails->getCurrAddrZip(), //postcode or zipcode
  3466.                             'cus_country' => 'Bangladesh',  //country
  3467.                             'cus_phone' => ($studentDetails->getPhone() == null || $studentDetails->getPhone() == '') ? '+8801911706483' : $studentDetails->getPhone(), //customer phone number
  3468.                             'cus_fax' => '',  //fax
  3469.                             'ship_name' => '', //ship name
  3470.                             'ship_add1' => '',  //ship address
  3471.                             'ship_add2' => '',
  3472.                             'ship_city' => '',
  3473.                             'ship_state' => '',
  3474.                             'ship_postcode' => '',
  3475.                             'ship_country' => 'Bangladesh',
  3476.                             'desc' => $productDescStr,
  3477.                         ]
  3479.                     ];
  3480.                     return new JsonResponse($output);
  3482.                 }
  3485. //                $fields = array(
  3486. //
  3487. //                    "mode" => "0011",
  3488. //                    "payerReference" => "01723888888",
  3489. //                    "callbackURL" => $this->generateUrl(
  3490. //                        'payment_gateway_success',
  3491. //                        ['encData' => $this->get('url_encryptor')->encrypt(json_encode(array(
  3492. //                            'invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1)
  3493. //                        ))), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  3494. //                    ),
  3495. //                    "merchantAssociationInfo" => "MI05MID54RF09123456One",
  3496. //                    "amount" => 1*number_format($gatewayInvoice->getGateWayBillamount(),2,'.',''),,
  3497. //                    "currency" => "BDT",
  3498. //                    "intent" => "sale",
  3499. //                    "merchantInvoiceNumber" => 'BEI' . str_pad($gatewayInvoice->getBillerId(), 3, '0', STR_PAD_LEFT) . str_pad($gatewayInvoice->getBillToId(), 5, '0', STR_PAD_LEFT) . str_pad($gatewayInvoice->getId(), 4, '0', STR_PAD_LEFT)
  3500. //
  3501. //                );
  3502. //                $fields = array(
  3503. ////                    'store_id' => 'aamarpaytest', //store id will be aamarpay,  contact integration@aamarpay.com for test/live id
  3504. //                    'store_id' => $sandBoxMode == 1 ? 'aamarpaytest' : 'buddybee', //store id will be aamarpay,  contact integration@aamarpay.com for test/live id
  3505. //                    'amount' => 1*number_format($gatewayInvoice->getGateWayBillamount(),2,'.',''),, //transaction amount
  3506. //                    'payment_type' => 'VISA', //no need to change
  3507. //                    'currency' => strtoupper($currencyForGateway),  //currenct will be USD/BDT
  3508. //                    'tran_id' => 'BEI' . str_pad($gatewayInvoice->getBillerId(), 3, '0', STR_PAD_LEFT) . str_pad($gatewayInvoice->getBillToId(), 5, '0', STR_PAD_LEFT) . str_pad($gatewayInvoice->getId(), 4, '0', STR_PAD_LEFT), //transaction id must be unique from your end
  3509. //                    'cus_name' => $studentDetails->getFirstname() . ' ' . $studentDetails->getLastName(),  //customer name
  3510. //                    'cus_email' => $studentDetails->getEmail(), //customer email address
  3511. //                    'cus_add1' => $studentDetails->getCurrAddr(),  //customer address
  3512. //                    'cus_add2' => $studentDetails->getCurrAddrCity(), //customer address
  3513. //                    'cus_city' => $studentDetails->getCurrAddrCity(),  //customer city
  3514. //                    'cus_state' => $studentDetails->getCurrAddrState(),  //state
  3515. //                    'cus_postcode' => $studentDetails->getCurrAddrZip(), //postcode or zipcode
  3516. //                    'cus_country' => 'Bangladesh',  //country
  3517. //                    'cus_phone' => ($studentDetails->getPhone() == null || $studentDetails->getPhone() == '') ? ' + 8801911706483' : $studentDetails->getPhone(), //customer phone number
  3518. //                    'cus_fax' => '',  //fax
  3519. //                    'ship_name' => '', //ship name
  3520. //                    'ship_add1' => '',  //ship address
  3521. //                    'ship_add2' => '',
  3522. //                    'ship_city' => '',
  3523. //                    'ship_state' => '',
  3524. //                    'ship_postcode' => '',
  3525. //                    'ship_country' => 'Bangladesh',
  3526. //                    'desc' => $productDescStr,
  3527. //                    'success_url' => $this->generateUrl(
  3528. //                        'payment_gateway_success',
  3529. //                        ['encData' => $this->get('url_encryptor')->encrypt(json_encode(array(
  3530. //                            'invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1)
  3531. //                        ))), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  3532. //                    ),
  3533. //                    'fail_url' => $this->generateUrl(
  3534. //                        'payment_gateway_cancel', ['invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  3535. //                    ),
  3536. //                    'cancel_url' => $this->generateUrl(
  3537. //                        'payment_gateway_cancel', ['invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  3538. //                    ),
  3539. ////                    'opt_a' => 'Reshad',  //optional paramter
  3540. ////                    'opt_b' => 'Akil',
  3541. ////                    'opt_c' => 'Liza',
  3542. ////                    'opt_d' => 'Sohel',
  3543. ////                    'signature_key' => 'dbb74894e82415a2f7ff0ec3a97e4183',  //sandbox
  3544. //                    'signature_key' => $sandBoxMode == 1 ? 'dbb74894e82415a2f7ff0ec3a97e4183' : 'b7304a40e21fe15af3be9a948307f524'  //live
  3545. //
  3546. //                ); //signature key will provided aamarpay, contact integration@aamarpay.com for test/live signature key
  3547. //
  3548. //                $fields_string = http_build_query($fields);
  3549. //
  3550. //                $ch = curl_init();
  3551. //                curl_setopt($ch, CURLOPT_VERBOSE, true);
  3552. //                curl_setopt($ch, CURLOPT_URL, $url);
  3553. //
  3554. //                curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
  3555. //                curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  3556. //                curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  3557. //                $url_forward = str_replace('"', '', stripslashes(curl_exec($ch)));
  3558. //                curl_close($ch);
  3560. //                $this->redirect_to_merchant($url_forward);
  3563.             } else if ($paymentGatewayFromInvoice == 'onsite_pos' || $paymentGatewayFromInvoice == 'onsite_cash' || $paymentGatewayFromInvoice == 'onsite_bkash') {
  3564.                 $meetingId = 0;
  3566.                 if ($gatewayInvoice->getId() != 0) {
  3567.                     if ($gatewayInvoice->getDueAmount() <= 0) {
  3569.                         $retData = Buddybee::ProcessEntityInvoice($em_goc, $gatewayInvoice->getId(), ['stage' => BuddybeeConstant::ENTITY_INVOICE_STAGE_COMPLETED], $this->container->getParameter('kernel.root_dir'), false,
  3570.                             $this->container->getParameter('notification_enabled'),
  3571.                             $this->container->getParameter('notification_server')
  3572.                         );
  3574.                         $meetingId = $retData['meetingId'];
  3575.                     }
  3577.                     if (GeneralConstant::EMAIL_ENABLED == 1) {
  3578.                         $billerDetails = [];
  3579.                         $billToDetails = [];
  3581.                         $invoice = $gatewayInvoice;
  3582.                         if ($invoice) {
  3583.                             $billerDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  3584.                                 ->findOneBy(
  3585.                                     array(
  3586.                                         'applicantId' => $invoice->getBillerId(),
  3588.                                     )
  3589.                                 );
  3590.                             $billToDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  3591.                                 ->findOneBy(
  3592.                                     array(
  3593.                                         'applicantId' => $invoice->getBillToId(),
  3595.                                     )
  3596.                                 );
  3598.                         }
  3600.                         $bodyTemplate = '@Application/email/templates/buddybeeInvoiceEmail.html.twig';
  3601.                         $bodyData = array(
  3602.                             'page_title' => 'Invoice',
  3603. //            'studentDetails' => $student,
  3604.                             'billerDetails' => $billerDetails,
  3605.                             'billToDetails' => $billToDetails,
  3606.                             'invoice' => $invoice,
  3607.                             'currencyList' => BuddybeeConstant::$currency_List,
  3608.                             'currencyListByMarker' => BuddybeeConstant::$currency_List_by_marker,
  3611.                         );
  3612.                         $attachments = [];
  3613.                         $forwardToMailAddress = $billToDetails->getOAuthEmail();
  3616. //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  3617.                         $new_mail = $this->get('mail_module');
  3618.                         $new_mail->sendMyMail(array(
  3619.                             'senderHash' => '_CUSTOM_',
  3620.                             //                        'senderHash'=>'_CUSTOM_',
  3621.                             'forwardToMailAddress' => $forwardToMailAddress,
  3623.                             'subject' => 'YourInvoice #' . 'D' . str_pad('BB', 5, '0', STR_PAD_LEFT) . str_pad('76', 2, '0', STR_PAD_LEFT) . str_pad($invoice->getId(), 8, "0", STR_PAD_LEFT) . ' from BuddyBee ',
  3625. //                        'fileName' => 'Order#' . str_pad($id, 8, '0', STR_PAD_LEFT) . '.pdf',
  3626.                             'attachments' => $attachments,
  3627.                             'toAddress' => $forwardToMailAddress,
  3628.                             'fromAddress' => 'no-reply@buddybee.eu',
  3629.                             'userName' => 'no-reply@buddybee.eu',
  3630.                             'password' => 'Honeybee@0112',
  3631.                             'smtpServer' => 'smtp.hostinger.com',
  3632.                             'smtpPort' => 465,
  3634. //                            'emailBody' => $bodyHtml,
  3635.                             'mailTemplate' => $bodyTemplate,
  3636.                             'templateData' => $bodyData,
  3637.                             'embedCompanyImage' => 0,
  3638.                             'companyId' => 0,
  3640.                             'companyImagePath' => ''
  3641. //                        'embedCompanyImage' => 1,
  3642. //                        'companyId' => $companyId,
  3643. //                        'companyImagePath' => $company_data->getImage()
  3646.                         ));
  3649.                     }
  3652.                 }
  3654.                 MiscActions::RefreshBuddybeeBalanceOnSession($em, $request->getSession());
  3656.                 if ($meetingId != 0) {
  3657.                     $url = $this->generateUrl(
  3658.                         'consultancy_session'
  3659.                     );
  3660.                     $output = [
  3662.                         'proceedToCheckout' => 0,
  3663.                         'invoiceId' => $gatewayInvoice->getId(),
  3664.                         'meetingId' => $meetingId,
  3665.                         'redirectUrl' => $url . '/' . $meetingId
  3666.                     ];
  3667.                 } else {
  3668.                     $url = $this->generateUrl(
  3669.                         'buddybee_dashboard'
  3670.                     );
  3671.                     $output = [
  3673.                         'proceedToCheckout' => 0,
  3674.                         'invoiceId' => $gatewayInvoice->getId(),
  3675.                         'meetingId' => $meetingId,
  3676.                         'redirectUrl' => $url
  3677.                     ];
  3678.                 }
  3679.                 return new JsonResponse($output);
  3682.             }
  3684.         }
  3685.         $output = [
  3686.             'clientSecret' => 0,
  3687.             'id' => 0,
  3688.             'proceedToCheckout' => 0
  3689.         ];
  3690.         return new JsonResponse($output);
  3691. //        return $this->render('ApplicationBundle:pages/stripe:checkout.html.twig', array(
  3692. //            'page_title' => 'Checkout',
  3693. ////            'stripe' => $stripe,
  3694. //            'stripe' => null,
  3695. ////            'PaymentIntent' => $paymentIntent,
  3696. //
  3697. ////            'consultantDetail' => $consultantDetail,
  3698. ////            'consultantDetails'=> $consultantDetails,
  3699. ////
  3700. ////            'meetingSession' => $meetingSession,
  3701. ////            'packageDetails' => json_decode($meetingSession->getPcakageDetails(),true),
  3702. ////            'packageName' => json_decode($meetingSession->getPackageName(),true),
  3703. ////            'pay' => $payableAmount,
  3704. ////            'balance' => $currStudentBal
  3705. //        ));
  3706.     }
  3708.     public function PaymentGatewaySuccessAction(Request $request, $encData = '')
  3709.     {
  3710.         $em = $this->getDoctrine()->getManager('company_group');
  3711.         $invoiceId = 0;
  3712.         $autoRedirect = 1;
  3713.         $redirectUrl = '';
  3714.         $meetingId = 0;
  3715.         $setupOnly = 0;
  3716.         $appId = 0;
  3717.         $ownerId = 0;
  3719.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  3721.         if ($systemType == '_CENTRAL_') {
  3724.             if ($encData != '') {
  3725.                 $encryptedData = json_decode($this->get('url_encryptor')->decrypt($encData), true);
  3726.                 if (isset($encryptedData['invoiceId']))
  3727.                     $invoiceId = $encryptedData['invoiceId'];
  3728.                 if (isset($encryptedData['autoRedirect']))
  3729.                     $autoRedirect = $encryptedData['autoRedirect'];
  3730.                 if (isset($encryptedData['setupOnly']))
  3731.                     $setupOnly = (int)$encryptedData['setupOnly'];
  3732.                 if (isset($encryptedData['appId']))
  3733.                     $appId = (int)$encryptedData['appId'];
  3734.                 if (isset($encryptedData['ownerId']))
  3735.                     $ownerId = (int)$encryptedData['ownerId'];
  3736.                 if (isset($encryptedData['redirectUrl']))
  3737.                     $redirectUrl = $encryptedData['redirectUrl'];
  3738.             } else {
  3739.                 $invoiceId = $request->query->get('invoiceId', 0);
  3741.                 $meetingId = 0;
  3742.                 $autoRedirect = $request->query->get('autoRedirect', 1);
  3743.                 $redirectUrl = $request->query->get('redirectUrl', '');
  3744.                 $setupOnly = (int)$request->query->get('setupOnly', 0);
  3745.                 $appId = (int)$request->query->get('appId', 0);
  3746.                 $ownerId = (int)$request->query->get('ownerId', 0);
  3747.             }
  3749.             if ($setupOnly === 1) {
  3750.                 $sessionId = $request->query->get('session_id');
  3751.                 if (!$sessionId) {
  3752.                     return $this->render('@Application/pages/stripe/cancel.html.twig', array(
  3753.                         'page_title' => 'Failed',
  3754.                     ));
  3755.                 }
  3757.                 $stripeSession = \Stripe\Checkout\Session::retrieve($sessionId);
  3758.                 if (!$stripeSession || !$stripeSession->setup_intent) {
  3759.                     return $this->render('@Application/pages/stripe/cancel.html.twig', array(
  3760.                         'page_title' => 'Failed',
  3761.                     ));
  3762.                 }
  3764.                 $setupIntent = \Stripe\SetupIntent::retrieve($stripeSession->setup_intent);
  3765.                 if ($setupIntent->status !== 'succeeded') {
  3766.                     return $this->render('@Application/pages/stripe/cancel.html.twig', array(
  3767.                         'page_title' => 'Failed',
  3768.                     ));
  3769.                 }
  3771.                 $paymentMethodId = $setupIntent->payment_method;
  3772.                 $customerId = $setupIntent->customer;
  3774.                 if ($appId === 0 && isset($stripeSession->metadata['app_id'])) {
  3775.                     $appId = (int)$stripeSession->metadata['app_id'];
  3776.                 }
  3777.                 if ($ownerId === 0 && isset($stripeSession->metadata['owner_id'])) {
  3778.                     $ownerId = (int)$stripeSession->metadata['owner_id'];
  3779.                 }
  3780.                 if ($redirectUrl === '' && isset($stripeSession->metadata['redirect_url'])) {
  3781.                     $redirectUrl = $stripeSession->metadata['redirect_url'];
  3782.                 }
  3784.                 $companyGroup = null;
  3785.                 if ($appId !== 0) {
  3786.                     $companyGroup = $em
  3787.                         ->getRepository("CompanyGroupBundle\\Entity\\CompanyGroup")
  3788.                         ->findOneBy([
  3789.                             'appId' => $appId
  3790.                         ]);
  3791.                 }
  3793.                 $existing = $em->getRepository(PaymentMethod::class)
  3794.                     ->findOneBy([
  3795.                         'stripePaymentMethodId' => $paymentMethodId,
  3796.                         'appId' => $appId
  3797.                     ]);
  3799.                 if (!$existing) {
  3800.                     if ($companyGroup && !$companyGroup->getStripeCustomerId()) {
  3801.                         $companyGroup->setStripeCustomerId($customerId);
  3802.                     }
  3804.                     $paymentMethod = new PaymentMethod();
  3805.                     $paymentMethod->setAppId($appId);
  3806.                     $paymentMethod->setApplicantId($ownerId);
  3807.                     $paymentMethod->setStripeCustomerId($customerId);
  3808.                     $paymentMethod->setStripePaymentMethodId($paymentMethodId);
  3809.                     $paymentMethod->setIsDefault(1);
  3811.                     $em->persist($paymentMethod);
  3812.                     $em->flush();
  3813.                 }
  3815.                 if ($companyGroup) {
  3816.                     $em->flush();
  3817.                 }
  3819.                 $redirectUrl = $redirectUrl !== '' ? $redirectUrl : $this->generateUrl(
  3820.                     'central_landing'
  3821.                 );
  3823.                 return $this->render('@Application/pages/stripe/success.html.twig', array(
  3824.                     'page_title' => 'Success',
  3825.                     'meetingId' => 0,
  3826.                     'autoRedirect' => 0,
  3827.                     'redirectUrl' => $redirectUrl,
  3828.                     'initiateCompany' => 1,
  3829.                     'appId' => $appId,
  3830.                     'ownerId' => $ownerId,
  3831.                     'setupOnly' => 1,
  3832.                 ));
  3833.             }
  3835.             if ($invoiceId != 0) {
  3836.                 $invoice = $em
  3837.                     ->getRepository("CompanyGroupBundle\\Entity\\EntityInvoice")
  3838.                     ->findOneBy([
  3839.                         'id' => $invoiceId
  3840.                     ]);
  3842.                 if($invoice->getAmountTransferGateWayHash() == 'stripe') {
  3845.                     $stripeSession = \Stripe\Checkout\Session::retrieve($request->query->get('session_id'));
  3847.                     $paymentIntent = \Stripe\PaymentIntent::retrieve($stripeSession->payment_intent);
  3848.                     if ($paymentIntent->status !== 'succeeded') {
  3850.                         return $this->render('@Application/pages/stripe/cancel.html.twig', array(
  3851.                             'page_title' => 'Failed',
  3854.                         ));
  3855.                     }
  3857.                     $paymentMethodId = $paymentIntent->payment_method;
  3858.                     $customerId = $paymentIntent->customer;
  3860.                     $companyGroup = $this->get('app.quote_company_provisioning_service')
  3861.                         ->ensureCompanyForInvoice($invoice, $request->getSession(), $customerId);
  3865.                     if (!isset($companyGroup) || !$companyGroup) {
  3866.                         $companyGroup = $em
  3867.                             ->getRepository("CompanyGroupBundle\\Entity\\CompanyGroup")
  3868.                             ->findOneBy([
  3869.                                 'appId' => $invoice->getAppId()
  3870.                             ]);
  3871.                     }
  3873.                     $existing = $em->getRepository(PaymentMethod::class)
  3874.                         ->findOneBy([
  3875.                             'stripePaymentMethodId' => $paymentMethodId
  3876.                         ]);
  3878.                     if (!$existing) {
  3879.                         if ($companyGroup) {
  3881.                             // save customer id (safety)
  3882.                             if (!$companyGroup->getStripeCustomerId()) {
  3883.                                 $companyGroup->setStripeCustomerId($customerId);
  3884.                             }
  3886.                             // save payment method
  3887.                             $paymentMethod = new PaymentMethod(); // your entity
  3889.                             $paymentMethod->setAppId($companyGroup->getAppId());;
  3890.                             $paymentMethod->setApplicantId($invoice->getApplicantId());
  3891.                             $paymentMethod->setStripeCustomerId($customerId);
  3892.                             $paymentMethod->setStripePaymentMethodId($paymentMethodId);
  3893.                             $paymentMethod->setIsDefault(1);
  3895.                             $em->persist($paymentMethod);
  3897.                             $em->flush();
  3898.                         }
  3899.                     }
  3900.                 }
  3904.                 $retData = Buddybee::ProcessEntityInvoice($em, $invoiceId, ['stage' => BuddybeeConstant::ENTITY_INVOICE_STAGE_COMPLETED],
  3905.                     $this->container->getParameter('kernel.root_dir'),
  3906.                     false,
  3907.                     $this->container->getParameter('notification_enabled'),
  3908.                     $this->container->getParameter('notification_server')
  3909.                 );
  3910.                 $this->get('app.subscription_state_sync_service')->syncFromLegacyInvoice($invoice);
  3911.                 if (($retData['initiateCompany'] ?? 0) == 1 && ($retData['ownerId'] ?? 0) != 0) {
  3912.                     $this->get('app.post_payment_company_setup_service')
  3913.                         ->finalizeOwnerServerSync((int)$retData['ownerId']);
  3914.                 }
  3916.                 if ($retData['sendCards'] == 1) {
  3917.                     $cardList = array();
  3919.                     $cards = $em->getRepository('CompanyGroupBundle\\Entity\\BeeCode')
  3920.                         ->findBy(
  3921.                             array(
  3922.                                 'id' => $retData['cardIds']
  3923.                             )
  3924.                         );
  3926.                     foreach ($cards as $card) {
  3927.                         $cardList[] = array(
  3928.                             'id' => $card->getId(),
  3929.                             'printed' => $card->getPrinted(),
  3930.                             'amount' => $card->getAmount(),
  3931.                             'coinCount' => $card->getCoinCount(),
  3932.                             'pin' => $card->getPin(),
  3933.                             'serial' => $card->getSerial(),
  3935.                         );
  3936.                     }
  3937.                     $receiverEmail = $retData['receiverEmail'];
  3938.                     if (GeneralConstant::EMAIL_ENABLED == 1) {
  3941.                         $bodyHtml = '';
  3942.                         $bodyTemplate = '@Application/email/templates/beeCodeDigitalDelivery.html.twig';
  3943.                         $bodyData = array(
  3944.                             'cardList' => $cardList,
  3945. //                        'name' => $newApplicant->getFirstname() . ' ' . $newApplicant->getLastname(),
  3946. //                        'email' => $userName,
  3947. //                        'password' => $newApplicant->getPassword(),
  3948.                         );
  3949.                         $attachments = [];
  3950.                         $forwardToMailAddress = $receiverEmail;
  3953. //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  3954.                         $new_mail = $this->get('mail_module');
  3955.                         $new_mail->sendMyMail(array(
  3956.                             'senderHash' => '_CUSTOM_',
  3957.                             //                        'senderHash'=>'_CUSTOM_',
  3958.                             'forwardToMailAddress' => $forwardToMailAddress,
  3960.                             'subject' => 'Digital Bee Card Delivery',
  3962. //                        'fileName' => 'Order#' . str_pad($id, 8, '0', STR_PAD_LEFT) . '.pdf',
  3963.                             'attachments' => $attachments,
  3964.                             'toAddress' => $forwardToMailAddress,
  3965.                             'fromAddress' => 'delivery@buddybee.eu',
  3966.                             'userName' => 'delivery@buddybee.eu',
  3967.                             'password' => 'Honeybee@0112',
  3968.                             'smtpServer' => 'smtp.hostinger.com',
  3969.                             'smtpPort' => 465,
  3970. //                        'encryptionMethod' => 'tls',
  3971.                             'encryptionMethod' => 'ssl',
  3972. //                            'emailBody' => $bodyHtml,
  3973.                             'mailTemplate' => $bodyTemplate,
  3974.                             'templateData' => $bodyData,
  3975. //                        'embedCompanyImage' => 1,
  3976. //                        'companyId' => $companyId,
  3977. //                        'companyImagePath' => $company_data->getImage()
  3980.                         ));
  3982.                         foreach ($cards as $card) {
  3983.                             $card->setPrinted(1);
  3984.                         }
  3985.                         $em->flush();
  3988.                     }
  3990.                     return new JsonResponse(
  3991.                         array(
  3992.                             'success' => true
  3993.                         )
  3994.                     );
  3997.                 }
  4000.                 MiscActions::RefreshBuddybeeBalanceOnSession($em, $request->getSession());
  4001.                 $meetingId = $retData['meetingId'];
  4002.                 if (GeneralConstant::EMAIL_ENABLED == 1) {
  4003.                     $billerDetails = [];
  4004.                     $billToDetails = [];
  4006.                     $invoice = $em->getRepository('CompanyGroupBundle\\Entity\\EntityInvoice')
  4007.                         ->findOneBy(
  4008.                             array(
  4009.                                 'Id' => $invoiceId,
  4011.                             )
  4012.                         );;
  4013.                     if ($invoice) {
  4014.                         $billerDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  4015.                             ->findOneBy(
  4016.                                 array(
  4017.                                     'applicantId' => $invoice->getBillerId(),
  4019.                                 )
  4020.                             );
  4021.                         $billToDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  4022.                             ->findOneBy(
  4023.                                 array(
  4024.                                     'applicantId' => $invoice->getBillToId(),
  4026.                                 )
  4027.                             );
  4029.                     }
  4031.                     $bodyTemplate = '@Application/email/templates/buddybeeInvoiceEmail.html.twig';
  4032.                     $bodyData = array(
  4033.                         'page_title' => 'Invoice',
  4034. //            'studentDetails' => $student,
  4035.                         'billerDetails' => $billerDetails,
  4036.                         'billToDetails' => $billToDetails,
  4037.                         'invoice' => $invoice,
  4038.                         'currencyList' => BuddybeeConstant::$currency_List,
  4039.                         'currencyListByMarker' => BuddybeeConstant::$currency_List_by_marker,
  4042.                     );
  4043.                     $attachments = [];
  4044.                     $forwardToMailAddress = $billToDetails->getOAuthEmail();
  4047. //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  4048.                     $new_mail = $this->get('mail_module');
  4049.                     $new_mail->sendMyMail(array(
  4050.                         'senderHash' => '_CUSTOM_',
  4051.                         //                        'senderHash'=>'_CUSTOM_',
  4052.                         'forwardToMailAddress' => $forwardToMailAddress,
  4054.                         'subject' => 'YourInvoice #' . 'D' . str_pad('BB', 5, '0', STR_PAD_LEFT) . str_pad('76', 2, '0', STR_PAD_LEFT) . str_pad($invoice->getId(), 8, "0", STR_PAD_LEFT) . ' from BuddyBee ',
  4056. //                        'fileName' => 'Order#' . str_pad($id, 8, '0', STR_PAD_LEFT) . '.pdf',
  4057.                         'attachments' => $attachments,
  4058.                         'toAddress' => $forwardToMailAddress,
  4059.                         'fromAddress' => 'no-reply@buddybee.eu',
  4060.                         'userName' => 'no-reply@buddybee.eu',
  4061.                         'password' => 'Honeybee@0112',
  4062.                         'smtpServer' => 'smtp.hostinger.com',
  4063.                         'smtpPort' => 465,
  4065. //                            'emailBody' => $bodyHtml,
  4066.                         'mailTemplate' => $bodyTemplate,
  4067.                         'templateData' => $bodyData,
  4068.                         'embedCompanyImage' => 0,
  4069.                         'companyId' => 0,
  4071.                         'companyImagePath' => ''
  4072. //                        'embedCompanyImage' => 1,
  4073. //                        'companyId' => $companyId,
  4074. //                        'companyImagePath' => $company_data->getImage()
  4077.                     ));
  4080.                 }
  4081. //
  4082.                 if ($meetingId != 0) {
  4083.                     $url = $this->generateUrl(
  4084.                         'consultancy_session'
  4085.                     );
  4086. //                if($request->query->get('autoRedirect',1))
  4087. //                    return $this->redirect($url . '/' . $meetingId);
  4088.                     $redirectUrl = $url . '/' . $meetingId;
  4090.                 } else {
  4091.                     $url = $this->generateUrl(
  4092.                         'central_landing'
  4093.                     );
  4094. //                if($request->query->get('autoRedirect',1))
  4095. //                    return $this->redirect($url);
  4096.                     $redirectUrl = $url;
  4097.                     $autoRedirect=0;
  4099.                 }
  4101.                 if (($retData['initiateCompany'] ?? 0) == 1 && ($retData['appId'] ?? 0) != 0 && ($retData['ownerId'] ?? 0) != 0) {
  4102.                     $companyGroup = $em->getRepository("CompanyGroupBundle\\Entity\\CompanyGroup")
  4103.                         ->findOneBy([
  4104.                             'appId' => (int)$retData['appId']
  4105.                         ]);
  4107.                     if ($companyGroup) {
  4108.                         $postPaymentSetup = $this->get('app.post_payment_company_setup_service');
  4109.                         $authenticationStr = $this->get('url_encryptor')->encrypt(json_encode(
  4110.                             $postPaymentSetup->buildAuthenticationPayload((int)$retData['ownerId'], (int)$retData['appId'])
  4111.                         ));
  4113.                         $redirectUrl = $postPaymentSetup->buildSwitchAppUrl(
  4114.                             (int)$retData['appId'],
  4115.                             (int)$retData['ownerId'],
  4116.                             (string)$companyGroup->getCompanyGroupServerAddress(),
  4117.                             $authenticationStr,
  4118.                             (string)$request->getSession()->get('csToken', '')
  4119.                         );
  4120.                         $autoRedirect = 1;
  4121.                     }
  4122.                 }
  4125.             }
  4126.             return $this->render('@Application/pages/stripe/success.html.twig', array(
  4127.                 'page_title' => 'Success',
  4128.                 'meetingId' => $meetingId,
  4129.                 'autoRedirect' => $autoRedirect,
  4130.                 'redirectUrl' => $redirectUrl,
  4131.                 'initiateCompany' => $retData['initiateCompany']??0,
  4132.                 'appId' => $retData['appId']??0,
  4133.                 'ownerId' => $retData['ownerId']??0,
  4135.             ));
  4136.         }
  4137.         else if ($systemType == '_BUDDYBEE_') {
  4140.             if ($encData != '') {
  4141.                 $encryptedData = json_decode($this->get('url_encryptor')->decrypt($encData), true);
  4142.                 if (isset($encryptedData['invoiceId']))
  4143.                     $invoiceId = $encryptedData['invoiceId'];
  4144.                 if (isset($encryptedData['autoRedirect']))
  4145.                     $autoRedirect = $encryptedData['autoRedirect'];
  4146.             } else {
  4147.                 $invoiceId = $request->query->get('invoiceId', 0);
  4149.                 $meetingId = 0;
  4150.                 $autoRedirect = $request->query->get('autoRedirect', 1);
  4151.                 $redirectUrl = '';
  4152.             }
  4155.             if ($invoiceId != 0) {
  4157.                 $retData = Buddybee::ProcessEntityInvoice($em, $invoiceId, ['stage' => BuddybeeConstant::ENTITY_INVOICE_STAGE_COMPLETED], false,
  4158.                     $this->container->getParameter('notification_enabled'),
  4159.                     $this->container->getParameter('notification_server')
  4160.                 );
  4162.                 if ($retData['sendCards'] == 1) {
  4163.                     $cardList = array();
  4165.                     $cards = $em->getRepository('CompanyGroupBundle\\Entity\\BeeCode')
  4166.                         ->findBy(
  4167.                             array(
  4168.                                 'id' => $retData['cardIds']
  4169.                             )
  4170.                         );
  4172.                     foreach ($cards as $card) {
  4173.                         $cardList[] = array(
  4174.                             'id' => $card->getId(),
  4175.                             'printed' => $card->getPrinted(),
  4176.                             'amount' => $card->getAmount(),
  4177.                             'coinCount' => $card->getCoinCount(),
  4178.                             'pin' => $card->getPin(),
  4179.                             'serial' => $card->getSerial(),
  4181.                         );
  4182.                     }
  4183.                     $receiverEmail = $retData['receiverEmail'];
  4184.                     if (GeneralConstant::EMAIL_ENABLED == 1) {
  4187.                         $bodyHtml = '';
  4188.                         $bodyTemplate = '@Application/email/templates/beeCodeDigitalDelivery.html.twig';
  4189.                         $bodyData = array(
  4190.                             'cardList' => $cardList,
  4191. //                        'name' => $newApplicant->getFirstname() . ' ' . $newApplicant->getLastname(),
  4192. //                        'email' => $userName,
  4193. //                        'password' => $newApplicant->getPassword(),
  4194.                         );
  4195.                         $attachments = [];
  4196.                         $forwardToMailAddress = $receiverEmail;
  4199. //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  4200.                         $new_mail = $this->get('mail_module');
  4201.                         $new_mail->sendMyMail(array(
  4202.                             'senderHash' => '_CUSTOM_',
  4203.                             //                        'senderHash'=>'_CUSTOM_',
  4204.                             'forwardToMailAddress' => $forwardToMailAddress,
  4206.                             'subject' => 'Digital Bee Card Delivery',
  4208. //                        'fileName' => 'Order#' . str_pad($id, 8, '0', STR_PAD_LEFT) . '.pdf',
  4209.                             'attachments' => $attachments,
  4210.                             'toAddress' => $forwardToMailAddress,
  4211.                             'fromAddress' => 'delivery@buddybee.eu',
  4212.                             'userName' => 'delivery@buddybee.eu',
  4213.                             'password' => 'Honeybee@0112',
  4214.                             'smtpServer' => 'smtp.hostinger.com',
  4215.                             'smtpPort' => 465,
  4216. //                        'encryptionMethod' => 'tls',
  4217.                             'encryptionMethod' => 'ssl',
  4218. //                            'emailBody' => $bodyHtml,
  4219.                             'mailTemplate' => $bodyTemplate,
  4220.                             'templateData' => $bodyData,
  4221. //                        'embedCompanyImage' => 1,
  4222. //                        'companyId' => $companyId,
  4223. //                        'companyImagePath' => $company_data->getImage()
  4226.                         ));
  4228.                         foreach ($cards as $card) {
  4229.                             $card->setPrinted(1);
  4230.                         }
  4231.                         $em->flush();
  4234.                     }
  4236.                     return new JsonResponse(
  4237.                         array(
  4238.                             'success' => true
  4239.                         )
  4240.                     );
  4243.                 }
  4246.                 MiscActions::RefreshBuddybeeBalanceOnSession($em, $request->getSession());
  4247.                 $meetingId = $retData['meetingId'];
  4248.                 if (GeneralConstant::EMAIL_ENABLED == 1) {
  4249.                     $billerDetails = [];
  4250.                     $billToDetails = [];
  4252.                     $invoice = $em->getRepository('CompanyGroupBundle\\Entity\\EntityInvoice')
  4253.                         ->findOneBy(
  4254.                             array(
  4255.                                 'Id' => $invoiceId,
  4257.                             )
  4258.                         );;
  4259.                     if ($invoice) {
  4260.                         $billerDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  4261.                             ->findOneBy(
  4262.                                 array(
  4263.                                     'applicantId' => $invoice->getBillerId(),
  4265.                                 )
  4266.                             );
  4267.                         $billToDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  4268.                             ->findOneBy(
  4269.                                 array(
  4270.                                     'applicantId' => $invoice->getBillToId(),
  4272.                                 )
  4273.                             );
  4275.                     }
  4277.                     $bodyTemplate = '@Application/email/templates/buddybeeInvoiceEmail.html.twig';
  4278.                     $bodyData = array(
  4279.                         'page_title' => 'Invoice',
  4280. //            'studentDetails' => $student,
  4281.                         'billerDetails' => $billerDetails,
  4282.                         'billToDetails' => $billToDetails,
  4283.                         'invoice' => $invoice,
  4284.                         'currencyList' => BuddybeeConstant::$currency_List,
  4285.                         'currencyListByMarker' => BuddybeeConstant::$currency_List_by_marker,
  4288.                     );
  4289.                     $attachments = [];
  4290.                     $forwardToMailAddress = $billToDetails->getOAuthEmail();
  4293. //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  4294.                     $new_mail = $this->get('mail_module');
  4295.                     $new_mail->sendMyMail(array(
  4296.                         'senderHash' => '_CUSTOM_',
  4297.                         //                        'senderHash'=>'_CUSTOM_',
  4298.                         'forwardToMailAddress' => $forwardToMailAddress,
  4300.                         'subject' => 'YourInvoice #' . 'D' . str_pad('BB', 5, '0', STR_PAD_LEFT) . str_pad('76', 2, '0', STR_PAD_LEFT) . str_pad($invoice->getId(), 8, "0", STR_PAD_LEFT) . ' from BuddyBee ',
  4302. //                        'fileName' => 'Order#' . str_pad($id, 8, '0', STR_PAD_LEFT) . '.pdf',
  4303.                         'attachments' => $attachments,
  4304.                         'toAddress' => $forwardToMailAddress,
  4305.                         'fromAddress' => 'no-reply@buddybee.eu',
  4306.                         'userName' => 'no-reply@buddybee.eu',
  4307.                         'password' => 'Honeybee@0112',
  4308.                         'smtpServer' => 'smtp.hostinger.com',
  4309.                         'smtpPort' => 465,
  4311. //                            'emailBody' => $bodyHtml,
  4312.                         'mailTemplate' => $bodyTemplate,
  4313.                         'templateData' => $bodyData,
  4314.                         'embedCompanyImage' => 0,
  4315.                         'companyId' => 0,
  4317.                         'companyImagePath' => ''
  4318. //                        'embedCompanyImage' => 1,
  4319. //                        'companyId' => $companyId,
  4320. //                        'companyImagePath' => $company_data->getImage()
  4323.                     ));
  4326.                 }
  4327. //
  4328.                 if ($meetingId != 0) {
  4329.                     $url = $this->generateUrl(
  4330.                         'consultancy_session'
  4331.                     );
  4332. //                if($request->query->get('autoRedirect',1))
  4333. //                    return $this->redirect($url . '/' . $meetingId);
  4334.                     $redirectUrl = $url . '/' . $meetingId;
  4336.                 } else {
  4337.                     $url = $this->generateUrl(
  4338.                         'buddybee_dashboard'
  4339.                     );
  4340. //                if($request->query->get('autoRedirect',1))
  4341. //                    return $this->redirect($url);
  4342.                     $redirectUrl = $url;
  4344.                 }
  4347.             }
  4348.             return $this->render('@Application/pages/stripe/success.html.twig', array(
  4349.                 'page_title' => 'Success',
  4350.                 'meetingId' => $meetingId,
  4351.                 'autoRedirect' => $autoRedirect,
  4352.                 'redirectUrl' => $redirectUrl,
  4354.             ));
  4355.         }
  4358.     }
  4360.     public function PaymentGatewayCancelAction(Request $request, $msg = 'The Payment was unsuccessful', $encData = '')
  4361.     {
  4362.         $em = $this->getDoctrine()->getManager('company_group');
  4363. //        $consultantDetail = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')->findOneBy(array());
  4364.         $session = $request->getSession();
  4365.         if ($msg == '')
  4366.             $msg = $request->query->get('msg', $request->request->get('msg', 'The Payment was unsuccessful'));
  4369.         return $this->render('@Application/pages/stripe/cancel.html.twig', array(
  4370.             'page_title' => 'Success',
  4371.             'msg' => $msg,
  4373.         ));
  4374.     }
  4376.     public function BkashCallbackAction(Request $request, $encData = '')
  4377.     {
  4380.         $em = $this->getDoctrine()->getManager('company_group');
  4381.         $invoiceId = 0;
  4382.         $session = $request->getSession();
  4383.         $sandBoxMode = $this->container->hasParameter('sand_box_mode') ? $this->container->getParameter('sand_box_mode') : 0;
  4385.         $paymentId = $request->query->get('paymentID', 0);
  4386.         $status = $request->query->get('status', 0);
  4388.         if ($status == 'success') {
  4389.             $paymentID = $paymentId;
  4390.             $gatewayInvoice = $em->getRepository('CompanyGroupBundle\\Entity\\EntityInvoice')->findOneBy(
  4391.                 array(
  4392.                     'gatewayPaymentId' => $paymentId,
  4393.                     'isProcessed' => [0, 2]
  4395.                 ));
  4397.             if ($gatewayInvoice) {
  4398.                 $invoiceId = $gatewayInvoice->getId();
  4400.                 $justNow = new \DateTime();
  4402.                 $baseUrl = ($sandBoxMode == 1) ? 'https://tokenized.sandbox.bka.sh/v1.2.0-beta' : 'https://tokenized.pay.bka.sh/v1.2.0-beta';
  4403.                 $username_value = ($sandBoxMode == 1) ? 'sandboxTokenizedUser02' : '01891962953';
  4404.                 $password_value = ($sandBoxMode == 1) ? 'sandboxTokenizedUser02@12345' : ',a&kPV4deq&';
  4405.                 $app_key_value = ($sandBoxMode == 1) ? '4f6o0cjiki2rfm34kfdadl1eqq' : '2ueVHdwz5gH3nxx7xn8wotlztc';
  4406.                 $app_secret_value = ($sandBoxMode == 1) ? '2is7hdktrekvrbljjh44ll3d9l1dtjo4pasmjvs5vl5qr3fug4b' : '49Ay3h3wWJMBFD7WF5CassyLrtA1jt6ONhspqjqFx5hTjhqh5dHU';
  4408.                 $justNowTs = $justNow->format('U');
  4409.                 if ($gatewayInvoice->getGatewayIdTokenExpireTs() <= $justNowTs) {
  4410.                     $refresh_token = $gatewayInvoice->getGatewayIdRefreshToken();
  4412.                     $request_data = array(
  4413.                         'app_key' => $app_key_value,
  4414.                         'app_secret' => $app_secret_value,
  4415.                         'refresh_token' => $refresh_token
  4416.                     );
  4417.                     $url = curl_init($baseUrl . '/tokenized/checkout/token/refresh');
  4419.                     $request_data_json = json_encode($request_data);
  4421.                     $header = array(
  4422.                         'Content-Type:application/json',
  4423.                         'username:' . $username_value,
  4424.                         'password:' . $password_value
  4425.                     );
  4426.                     curl_setopt($url, CURLOPT_HTTPHEADER, $header);
  4427.                     curl_setopt($url, CURLOPT_CUSTOMREQUEST, "POST");
  4428.                     curl_setopt($url, CURLOPT_RETURNTRANSFER, true);
  4429.                     curl_setopt($url, CURLOPT_POSTFIELDS, $request_data_json);
  4430.                     curl_setopt($url, CURLOPT_FOLLOWLOCATION, 1);
  4431.                     curl_setopt($url, CURLOPT_IPRESOLVE, CURL_IPRESOLVE_V4);
  4434.                     $tokenData = json_decode(curl_exec($url), true);
  4435.                     curl_close($url);
  4438.                     $justNow = new \DateTime();
  4439.                     $justNow->modify('+' . $tokenData['expires_in'] . ' second');
  4440.                     $gatewayInvoice->setGatewayIdTokenExpireTs($justNow->format('U'));
  4441.                     $gatewayInvoice->setGatewayIdToken($tokenData['id_token']);
  4442.                     $gatewayInvoice->setGatewayIdRefreshToken($tokenData['refresh_token']);
  4443.                     $em->flush();
  4444.                 }
  4445.                 $auth = $gatewayInvoice->getGatewayIdToken();;
  4447.                 $post_token = array(
  4448.                     'paymentID' => $paymentID
  4449.                 );
  4450. //                $url = curl_init();
  4451.                 $url = curl_init($baseUrl . '/tokenized/checkout/execute');
  4452.                 $posttoken = json_encode($post_token);
  4454.                 $header = array(
  4455.                     'Content-Type:application/json',
  4456.                     'Authorization:' . $auth,
  4457.                     'X-APP-Key:' . $app_key_value
  4458.                 );
  4460. //                curl_setopt_array($url, array(
  4461. //                    CURLOPT_HTTPHEADER => $header,
  4462. //                    CURLOPT_RETURNTRANSFER => 1,
  4463. //                    CURLOPT_URL => $baseUrl . '/tokenized/checkout/execute',
  4464. //
  4465. //                    CURLOPT_FOLLOWLOCATION => 1,
  4466. //                    CURLOPT_POST => 1,
  4467. //                    CURLOPT_IPRESOLVE => CURL_IPRESOLVE_V4,
  4468. //                    CURLOPT_POSTFIELDS => http_build_query($post_token)
  4469. //                ));
  4471.                 curl_setopt($url, CURLOPT_HTTPHEADER, $header);
  4472.                 curl_setopt($url, CURLOPT_CUSTOMREQUEST, "POST");
  4473.                 curl_setopt($url, CURLOPT_RETURNTRANSFER, true);
  4474.                 curl_setopt($url, CURLOPT_POSTFIELDS, $posttoken);
  4475.                 curl_setopt($url, CURLOPT_FOLLOWLOCATION, 1);
  4476.                 curl_setopt($url, CURLOPT_IPRESOLVE, CURL_IPRESOLVE_V4);
  4477.                 $resultdata = curl_exec($url);
  4478.                 curl_close($url);
  4479.                 $obj = json_decode($resultdata, true);
  4481. //                return new JsonResponse(array(
  4482. //                    'obj' => $obj,
  4483. //                    'url' => $baseUrl . '/tokenized/checkout/execute',
  4484. //                    'header' => $header,
  4485. //                    'paymentID' => $paymentID,
  4486. //                    'posttoken' => $posttoken,
  4487. //                ));
  4488. //                                return new JsonResponse($obj);
  4490.                 if (isset($obj['statusCode'])) {
  4492.                     if ($obj['statusCode'] == '0000') {
  4493.                         $gatewayInvoice->setGatewayTransId($obj['trxID']);
  4494.                         $em->flush();
  4495.                         return $this->redirectToRoute("payment_gateway_success", ['encData' => $this->get('url_encryptor')->encrypt(json_encode(array(
  4496.                             'invoiceId' => $invoiceId, 'autoRedirect' => 1
  4497.                         ))),
  4498.                             'hbeeSessionToken' => $session->get('token', 0)]);
  4499.                     } else {
  4500.                         return $this->redirectToRoute("payment_gateway_cancel", [
  4501.                             'msg' => isset($obj['statusMessage']) ? $obj['statusMessage'] : (isset($obj['errorMessage']) ? $obj['errorMessage'] : 'Payment Failed')
  4503.                         ]);
  4504.                     }
  4505.                 }
  4507.             } else {
  4508.                 return $this->redirectToRoute("payment_gateway_cancel", [
  4509.                     'msg' => isset($obj['statusMessage']) ? $obj['statusMessage'] : (isset($obj['errorMessage']) ? $obj['errorMessage'] : 'Payment Failed')
  4511.                 ]);
  4512.             }
  4515.         } else {
  4516.             return $this->redirectToRoute("payment_gateway_cancel", [
  4517.                 'msg' => isset($obj['statusMessage']) ? $obj['statusMessage'] : (isset($obj['errorMessage']) ? $obj['errorMessage'] : 'The Payment was unsuccessful')
  4519.             ]);
  4520.         }
  4523.     }
  4525.     public function MakePaymentOfEntityInvoiceAction(Request $request, $encData = '')
  4526.     {
  4527.         $em = $this->getDoctrine()->getManager('company_group');
  4528.         $em_goc = $em;
  4529.         $invoiceId = 0;
  4530.         $autoRedirect = 1;
  4531.         $redirectUrl = '';
  4532.         $meetingId = 0;
  4533.         $triggerMiddlePage = 0;
  4534.         $session = $request->getSession();
  4535.         $sandBoxMode = $this->container->hasParameter('sand_box_mode') ? $this->container->getParameter('sand_box_mode') : 0;
  4538.         $refundSuccess = 0;
  4539.         $errorMsg = '';
  4540.         $errorCode = '';
  4543.         if ($encData != '') {
  4544.             $invoiceId = $encData;
  4545.             $encryptedData = json_decode($this->get('url_encryptor')->decrypt($encData), true);
  4546.             if (isset($encryptedData['invoiceId']))
  4547.                 $invoiceId = $encryptedData['invoiceId'];
  4548.             if (isset($encryptedData['triggerMiddlePage']))
  4549.                 $triggerMiddlePage = $encryptedData['triggerMiddlePage'];
  4550.             if (isset($encryptedData['autoRedirect']))
  4551.                 $autoRedirect = $encryptedData['autoRedirect'];
  4552.         } else {
  4553.             $invoiceId = $request->request->get('invoiceId', $request->query->get('invoiceId', 0));
  4554.             $triggerMiddlePage = $request->request->get('triggerMiddlePage', $request->query->get('triggerMiddlePage', 0));
  4556.             $meetingId = 0;
  4557.             $autoRedirect = $request->query->get('autoRedirect', 1);
  4558.             $redirectUrl = '';
  4559.         }
  4560.         $meetingId = $request->request->get('meetingId', $request->query->get('meetingId', 0));
  4562.         $actionDone = 0;
  4564.         if ($meetingId != 0) {
  4566.             $dt = Buddybee::ConfirmAnyMeetingSessionIfPossible($em, 0, $meetingId, false,
  4567.                 $this->container->getParameter('notification_enabled'),
  4568.                 $this->container->getParameter('notification_server'));
  4571.             if ($invoiceId == 0 && $dt['success'] == true) {
  4572.                 $actionDone = 1;
  4573.                 return new JsonResponse(array(
  4574.                     'clientSecret' => 0,
  4575.                     'actionDone' => $actionDone,
  4576.                     'id' => 0,
  4577.                     'proceedToCheckout' => 0
  4578.                 ));
  4579.             }
  4580.         }
  4583. //        $invoiceId = $request->request->get('meetingId', $request->query->get('meetingId', 0));
  4585.         $output = [
  4586.             'clientSecret' => 0,
  4587.             'id' => 0,
  4588.             'proceedToCheckout' => 0
  4589.         ];
  4590.         if ($invoiceId != 0) {
  4591.             $gatewayInvoice = $em->getRepository('CompanyGroupBundle\\Entity\\EntityInvoice')->findOneBy(
  4592.                 array(
  4593.                     'Id' => $invoiceId,
  4594.                     'isProcessed' => [0]
  4596.                 ));
  4597.         } else {
  4598.             $gatewayInvoice = $em->getRepository('CompanyGroupBundle\\Entity\\EntityInvoice')->findOneBy(
  4599.                 array(
  4600.                     'meetingId' => $meetingId,
  4601.                     'isProcessed' => [0]
  4603.                 ));
  4604.         }
  4606.         if ($gatewayInvoice)
  4607.             $invoiceId = $gatewayInvoice->getId();
  4609.         $invoiceSessionCount = 0;
  4610.         $payableAmount = 0;
  4611.         $imageBySessionCount = [
  4612.             0 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4613.             100 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4614.             200 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4615.             300 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4616.             400 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4617.             500 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4618.             600 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4619.             700 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4620.             800 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4621.             900 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4622.             1000 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4623.             1100 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4624.             1200 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4625.             1300 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4626.             1400 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4627.             1500 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4628.             1600 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4629.             1700 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4630.             1800 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4631.             1900 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4632.             2000 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4633.             2100 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4634.             2200 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4635.             2300 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4636.             2400 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4637.             2500 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4638.             2600 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4639.             2700 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4640.             2800 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4641.             2900 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4642.             3000 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4643.             3100 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4644.             3200 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4645.             3300 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4646.             3400 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4647.             3500 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4648.             3600 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4649.             3700 => "https://www.buddybee.eu/buddybee_assets/ADULT-BEE.png",
  4651.         ];
  4654.         if ($gatewayInvoice) {
  4655.             $gatewayProductData = json_decode($gatewayInvoice->getProductDataForPaymentGateway(), true);
  4656.             if ($gatewayProductData == null) $gatewayProductData = [];
  4657.             $gatewayAmount = 1 * number_format($gatewayInvoice->getGateWayBillamount(), 2, '.', '');
  4658.             $invoiceSessionCount = $gatewayInvoice->getSessionCount();
  4659.             $currencyForGateway = $gatewayInvoice->getAmountCurrency();
  4661.             $gatewayAmount = round($gatewayAmount, 2);
  4662.             if (empty($gatewayProductData))
  4663.                 $gatewayProductData = [
  4664.                     [
  4665.                         'price_data' => [
  4666.                             'currency' => 'eur',
  4667.                             'unit_amount' => $gatewayAmount != 0 ? (100 * $gatewayAmount) : 200000,
  4668.                             'product_data' => [
  4669. //                            'name' => $request->request->has('packageName') ? $request->request->get('packageName') : 'Advanced Consultancy Package',
  4670.                                 'name' => 'Bee Coins',
  4671. //                                'images' => [$imageBySessionCount[$invoiceSessionCount]],
  4672.                                 'images' => [$imageBySessionCount[0]],
  4673.                             ],
  4674.                         ],
  4675.                         'quantity' => 1,
  4676.                     ]
  4677.                 ];
  4679.             $productDescStr = '';
  4680.             $productDescArr = [];
  4681.             foreach ($gatewayProductData as $gpd) {
  4682.                 $productDescArr[] = $gpd['price_data']['product_data']['name'];
  4683.             }
  4684.             $productDescStr = implode(',', $productDescArr);
  4685.             $paymentGatewayFromInvoice = $gatewayInvoice->getAmountTransferGateWayHash();
  4688.             if ($paymentGatewayFromInvoice == 'stripe') {
  4689.                 $stripe = new \Stripe\Stripe();
  4690.                 \Stripe\Stripe::setApiKey('sk_test_51IxYTAJXs21fVb0QMop2Nb0E7u9Da4LwGrym1nGHUHqaSNtT3p9HBgHd7YyDsTKHscgPPECPQniTy79Ab8Sgxfbm00JF2AndUz');
  4692.                 $stripe::setApiKey('sk_test_51IxYTAJXs21fVb0QMop2Nb0E7u9Da4LwGrym1nGHUHqaSNtT3p9HBgHd7YyDsTKHscgPPECPQniTy79Ab8Sgxfbm00JF2AndUz');
  4693.                 {
  4694.                     if ($request->query->has('meetingSessionId'))
  4695.                         $id = $request->query->get('meetingSessionId');
  4696.                 }
  4698.                 $paymentIntent = [
  4699.                     "id" => "pi_1DoWjK2eZvKYlo2Csy9J3BHs",
  4700.                     "object" => "payment_intent",
  4701.                     "amount" => 3000,
  4702.                     "amount_capturable" => 0,
  4703.                     "amount_received" => 0,
  4704.                     "application" => null,
  4705.                     "application_fee_amount" => null,
  4706.                     "canceled_at" => null,
  4707.                     "cancellation_reason" => null,
  4708.                     "capture_method" => "automatic",
  4709.                     "charges" => [
  4710.                         "object" => "list",
  4711.                         "data" => [],
  4712.                         "has_more" => false,
  4713.                         "url" => "/v1/charges?payment_intent=pi_1DoWjK2eZvKYlo2Csy9J3BHs"
  4714.                     ],
  4715.                     "client_secret" => "pi_1DoWjK2eZvKYlo2Csy9J3BHs_secret_vmxAcWZxo2kt1XhpWtZtnjDtd",
  4716.                     "confirmation_method" => "automatic",
  4717.                     "created" => 1546523966,
  4718.                     "currency" => $currencyForGateway,
  4719.                     "customer" => null,
  4720.                     "description" => null,
  4721.                     "invoice" => null,
  4722.                     "last_payment_error" => null,
  4723.                     "livemode" => false,
  4724.                     "metadata" => [],
  4725.                     "next_action" => null,
  4726.                     "on_behalf_of" => null,
  4727.                     "payment_method" => null,
  4728.                     "payment_method_options" => [],
  4729.                     "payment_method_types" => [
  4730.                         "card"
  4731.                     ],
  4732.                     "receipt_email" => null,
  4733.                     "review" => null,
  4734.                     "setup_future_usage" => null,
  4735.                     "shipping" => null,
  4736.                     "statement_descriptor" => null,
  4737.                     "statement_descriptor_suffix" => null,
  4738.                     "status" => "requires_payment_method",
  4739.                     "transfer_data" => null,
  4740.                     "transfer_group" => null
  4741.                 ];
  4744.                 $checkout_session = \Stripe\Checkout\Session::create([
  4745.                     'payment_method_types' => ['card'],
  4746.                     'line_items' => $gatewayProductData,
  4747.                     'mode' => 'payment',
  4748.                     'success_url' => $this->generateUrl(
  4749.                         'payment_gateway_success',
  4750.                         ['encData' => $this->get('url_encryptor')->encrypt(json_encode(array(
  4751.                             'invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1)
  4752.                         ))), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  4753.                     ),
  4754.                     'cancel_url' => $this->generateUrl(
  4755.                         'payment_gateway_cancel', ['invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  4756.                     ),
  4757.                 ]);
  4758.                 $output = [
  4759.                     'clientSecret' => $paymentIntent['client_secret'],
  4760.                     'id' => $checkout_session->id,
  4761.                     'paymentGateway' => $paymentGatewayFromInvoice,
  4762.                     'proceedToCheckout' => 1
  4763.                 ];
  4764. //                return new JsonResponse($output);
  4765.             }
  4766.             if ($paymentGatewayFromInvoice == 'aamarpay') {
  4768.                 $studentDetails = $em_goc->getRepository(EntityApplicantDetails::class)->find($gatewayInvoice->getBillToId());
  4771.                 $url = $sandBoxMode == 1 ? 'https://sandbox.aamarpay.com/request.php' : 'https://secure.aamarpay.com/request.php';
  4772.                 $fields = array(
  4773. //                    'store_id' => 'aamarpaytest', //store id will be aamarpay,  contact integration@aamarpay.com for test/live id
  4774.                     'store_id' => $sandBoxMode == 1 ? 'aamarpaytest' : 'buddybee', //store id will be aamarpay,  contact integration@aamarpay.com for test/live id
  4775.                     'amount' => 1 * number_format($gatewayInvoice->getGateWayBillamount(), 2, '.', ''), //transaction amount
  4776.                     'payment_type' => 'VISA', //no need to change
  4777.                     'currency' => strtoupper($currencyForGateway),  //currenct will be USD/BDT
  4778.                     'tran_id' => 'BEI' . str_pad($gatewayInvoice->getBillerId(), 3, '0', STR_PAD_LEFT) . str_pad($gatewayInvoice->getBillToId(), 5, '0', STR_PAD_LEFT) . str_pad($gatewayInvoice->getId(), 4, '0', STR_PAD_LEFT), //transaction id must be unique from your end
  4779.                     'cus_name' => $studentDetails->getFirstname() . ' ' . $studentDetails->getLastName(),  //customer name
  4780.                     'cus_email' => $studentDetails->getEmail(), //customer email address
  4781.                     'cus_add1' => $studentDetails->getCurrAddr(),  //customer address
  4782.                     'cus_add2' => $studentDetails->getCurrAddrCity(), //customer address
  4783.                     'cus_city' => $studentDetails->getCurrAddrCity(),  //customer city
  4784.                     'cus_state' => $studentDetails->getCurrAddrState(),  //state
  4785.                     'cus_postcode' => $studentDetails->getCurrAddrZip(), //postcode or zipcode
  4786.                     'cus_country' => 'Bangladesh',  //country
  4787.                     'cus_phone' => ($studentDetails->getPhone() == null || $studentDetails->getPhone() == '') ? '+8801911706483' : $studentDetails->getPhone(), //customer phone number
  4788.                     'cus_fax' => '',  //fax
  4789.                     'ship_name' => '', //ship name
  4790.                     'ship_add1' => '',  //ship address
  4791.                     'ship_add2' => '',
  4792.                     'ship_city' => '',
  4793.                     'ship_state' => '',
  4794.                     'ship_postcode' => '',
  4795.                     'ship_country' => 'Bangladesh',
  4796.                     'desc' => $productDescStr,
  4797.                     'success_url' => $this->generateUrl(
  4798.                         'payment_gateway_success',
  4799.                         ['encData' => $this->get('url_encryptor')->encrypt(json_encode(array(
  4800.                             'invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1)
  4801.                         ))), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  4802.                     ),
  4803.                     'fail_url' => $this->generateUrl(
  4804.                         'payment_gateway_cancel', ['invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  4805.                     ),
  4806.                     'cancel_url' => $this->generateUrl(
  4807.                         'payment_gateway_cancel', ['invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  4808.                     ),
  4809. //                    'opt_a' => 'Reshad',  //optional paramter
  4810. //                    'opt_b' => 'Akil',
  4811. //                    'opt_c' => 'Liza',
  4812. //                    'opt_d' => 'Sohel',
  4813. //                    'signature_key' => 'dbb74894e82415a2f7ff0ec3a97e4183',  //sandbox
  4814.                     'signature_key' => $sandBoxMode == 1 ? 'dbb74894e82415a2f7ff0ec3a97e4183' : 'b7304a40e21fe15af3be9a948307f524'  //live
  4816.                 ); //signature key will provided aamarpay, contact integration@aamarpay.com for test/live signature key
  4818.                 $fields_string = http_build_query($fields);
  4820.                 $ch = curl_init();
  4821.                 curl_setopt($ch, CURLOPT_VERBOSE, true);
  4822.                 curl_setopt($ch, CURLOPT_URL, $url);
  4824.                 curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
  4825.                 curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  4826.                 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  4827.                 $url_forward = str_replace('"', '', stripslashes(curl_exec($ch)));
  4828.                 curl_close($ch);
  4830. //                $this->redirect_to_merchant($url_forward);
  4832.                 $output = [
  4834. //                    'redirectUrl' => 'https://sandbox.aamarpay.com/'.$url_forward, //keeping it off temporarily
  4835.                     'redirectUrl' => ($sandBoxMode == 1 ? 'https://sandbox.aamarpay.com/' : 'https://secure.aamarpay.com/') . $url_forward, //keeping it off temporarily
  4836. //                    'fields'=>$fields,
  4837. //                    'fields_string'=>$fields_string,
  4839. //                    'redirectUrl' => $this->generateUrl(
  4840. //                        'payment_gateway_success',
  4841. //                        ['encData' => $this->get('url_encryptor')->encrypt(json_encode(array(
  4842. //                            'invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1)
  4843. //                        ))), 'hbeeSessionToken' => $request->request->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  4844. //                    ),
  4845.                     'paymentGateway' => $paymentGatewayFromInvoice,
  4846.                     'proceedToCheckout' => 1
  4847.                 ];
  4848. //                return new JsonResponse($output);
  4849.             } else if ($paymentGatewayFromInvoice == 'bkash') {
  4851.                 $studentDetails = $em_goc->getRepository(EntityApplicantDetails::class)->find($gatewayInvoice->getBillToId());
  4853.                 $baseUrl = ($sandBoxMode == 1) ? 'https://tokenized.sandbox.bka.sh/v1.2.0-beta' : 'https://tokenized.pay.bka.sh/v1.2.0-beta';
  4854.                 $username_value = ($sandBoxMode == 1) ? 'sandboxTokenizedUser02' : '01891962953';
  4855.                 $password_value = ($sandBoxMode == 1) ? 'sandboxTokenizedUser02@12345' : ',a&kPV4deq&';
  4856.                 $app_key_value = ($sandBoxMode == 1) ? '4f6o0cjiki2rfm34kfdadl1eqq' : '2ueVHdwz5gH3nxx7xn8wotlztc';
  4857.                 $app_secret_value = ($sandBoxMode == 1) ? '2is7hdktrekvrbljjh44ll3d9l1dtjo4pasmjvs5vl5qr3fug4b' : '49Ay3h3wWJMBFD7WF5CassyLrtA1jt6ONhspqjqFx5hTjhqh5dHU';
  4860.                 $request_data = array(
  4861.                     'app_key' => $app_key_value,
  4862.                     'app_secret' => $app_secret_value
  4863.                 );
  4864.                 $url = curl_init($baseUrl . '/tokenized/checkout/token/grant');
  4865.                 $request_data_json = json_encode($request_data);
  4866.                 $header = array(
  4867.                     'Content-Type:application/json',
  4868.                     'username:' . $username_value,
  4869.                     'password:' . $password_value
  4870.                 );
  4871.                 curl_setopt($url, CURLOPT_HTTPHEADER, $header);
  4872.                 curl_setopt($url, CURLOPT_CUSTOMREQUEST, "POST");
  4873.                 curl_setopt($url, CURLOPT_RETURNTRANSFER, true);
  4874.                 curl_setopt($url, CURLOPT_POSTFIELDS, $request_data_json);
  4875.                 curl_setopt($url, CURLOPT_FOLLOWLOCATION, 1);
  4876.                 curl_setopt($url, CURLOPT_IPRESOLVE, CURL_IPRESOLVE_V4);
  4878.                 $tokenData = json_decode(curl_exec($url), true);
  4879.                 curl_close($url);
  4881.                 $id_token = $tokenData['id_token'];
  4882.                 $goToBkashPage = 0;
  4883.                 if ($tokenData['statusCode'] == '0000') {
  4884.                     $auth = $id_token;
  4887.                     $requestbody = array(
  4888.                         "mode" => "0011",
  4889. //                        "payerReference" => "",
  4890.                         "payerReference" => $gatewayInvoice->getInvoiceDateTs(),
  4891.                         "callbackURL" => $this->generateUrl(
  4892.                             'bkash_callback', [], UrlGenerator::ABSOLUTE_URL
  4893.                         ),
  4894. //                    "merchantAssociationInfo" => "MI05MID54RF09123456One",
  4895.                         "amount" => number_format($gatewayInvoice->getGateWayBillamount(), 2, '.', ''),
  4896.                         "currency" => "BDT",
  4897.                         "intent" => "sale",
  4898.                         "merchantInvoiceNumber" => $invoiceId
  4899.                     );
  4900.                     $url = curl_init($baseUrl . '/tokenized/checkout/create');
  4901.                     $requestbodyJson = json_encode($requestbody);
  4903.                     $header = array(
  4904.                         'Content-Type:application/json',
  4905.                         'Authorization:' . $auth,
  4906.                         'X-APP-Key:' . $app_key_value
  4907.                     );
  4909.                     curl_setopt($url, CURLOPT_HTTPHEADER, $header);
  4910.                     curl_setopt($url, CURLOPT_CUSTOMREQUEST, "POST");
  4911.                     curl_setopt($url, CURLOPT_RETURNTRANSFER, true);
  4912.                     curl_setopt($url, CURLOPT_POSTFIELDS, $requestbodyJson);
  4913.                     curl_setopt($url, CURLOPT_FOLLOWLOCATION, 1);
  4914.                     curl_setopt($url, CURLOPT_IPRESOLVE, CURL_IPRESOLVE_V4);
  4915.                     $resultdata = curl_exec($url);
  4916.                     curl_close($url);
  4917. //                    return new JsonResponse($resultdata);
  4919.                     $obj = json_decode($resultdata, true);
  4922.                     $goToBkashPage = 1;
  4925.                     $justNow = new \DateTime();
  4926.                     $justNow->modify('+' . $tokenData['expires_in'] . ' second');
  4927.                     $gatewayInvoice->setGatewayIdTokenExpireTs($justNow->format('U'));
  4928.                     $gatewayInvoice->setGatewayIdToken($tokenData['id_token']);
  4929.                     $gatewayInvoice->setGatewayPaymentId($obj['paymentID']);
  4930.                     $gatewayInvoice->setGatewayIdRefreshToken($tokenData['refresh_token']);
  4931.                     $em->flush();
  4933.                     $output = [
  4935.                         'redirectUrl' => $obj['bkashURL'],
  4937.                         'paymentGateway' => $paymentGatewayFromInvoice,
  4938.                         'proceedToCheckout' => $goToBkashPage,
  4939.                         'tokenData' => $tokenData,
  4940.                         'obj' => $obj,
  4941.                         'id_token' => $tokenData['id_token'],
  4942.                     ];
  4945.                 }
  4948. //                $fields = array(
  4949. //
  4950. //                    "mode" => "0011",
  4951. //                    "payerReference" => "01723888888",
  4952. //                    "callbackURL" => $this->generateUrl(
  4953. //                        'payment_gateway_success',
  4954. //                        ['encData' => $this->get('url_encryptor')->encrypt(json_encode(array(
  4955. //                            'invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1)
  4956. //                        ))), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  4957. //                    ),
  4958. //                    "merchantAssociationInfo" => "MI05MID54RF09123456One",
  4959. //                    "amount" => $gatewayInvoice->getGateWayBillamount(),
  4960. //                    "currency" => "BDT",
  4961. //                    "intent" => "sale",
  4962. //                    "merchantInvoiceNumber" => 'BEI' . str_pad($gatewayInvoice->getBillerId(), 3, '0', STR_PAD_LEFT) . str_pad($gatewayInvoice->getBillToId(), 5, '0', STR_PAD_LEFT) . str_pad($gatewayInvoice->getId(), 4, '0', STR_PAD_LEFT)
  4963. //
  4964. //                );
  4965. //                $fields = array(
  4966. ////                    'store_id' => 'aamarpaytest', //store id will be aamarpay,  contact integration@aamarpay.com for test/live id
  4967. //                    'store_id' => $sandBoxMode == 1 ? 'aamarpaytest' : 'buddybee', //store id will be aamarpay,  contact integration@aamarpay.com for test/live id
  4968. //                    'amount' => $gatewayInvoice->getGateWayBillamount(), //transaction amount
  4969. //                    'payment_type' => 'VISA', //no need to change
  4970. //                    'currency' => strtoupper($currencyForGateway),  //currenct will be USD/BDT
  4971. //                    'tran_id' => 'BEI' . str_pad($gatewayInvoice->getBillerId(), 3, '0', STR_PAD_LEFT) . str_pad($gatewayInvoice->getBillToId(), 5, '0', STR_PAD_LEFT) . str_pad($gatewayInvoice->getId(), 4, '0', STR_PAD_LEFT), //transaction id must be unique from your end
  4972. //                    'cus_name' => $studentDetails->getFirstname() . ' ' . $studentDetails->getLastName(),  //customer name
  4973. //                    'cus_email' => $studentDetails->getEmail(), //customer email address
  4974. //                    'cus_add1' => $studentDetails->getCurrAddr(),  //customer address
  4975. //                    'cus_add2' => $studentDetails->getCurrAddrCity(), //customer address
  4976. //                    'cus_city' => $studentDetails->getCurrAddrCity(),  //customer city
  4977. //                    'cus_state' => $studentDetails->getCurrAddrState(),  //state
  4978. //                    'cus_postcode' => $studentDetails->getCurrAddrZip(), //postcode or zipcode
  4979. //                    'cus_country' => 'Bangladesh',  //country
  4980. //                    'cus_phone' => ($studentDetails->getPhone() == null || $studentDetails->getPhone() == '') ? ' + 8801911706483' : $studentDetails->getPhone(), //customer phone number
  4981. //                    'cus_fax' => '',  //fax
  4982. //                    'ship_name' => '', //ship name
  4983. //                    'ship_add1' => '',  //ship address
  4984. //                    'ship_add2' => '',
  4985. //                    'ship_city' => '',
  4986. //                    'ship_state' => '',
  4987. //                    'ship_postcode' => '',
  4988. //                    'ship_country' => 'Bangladesh',
  4989. //                    'desc' => $productDescStr,
  4990. //                    'success_url' => $this->generateUrl(
  4991. //                        'payment_gateway_success',
  4992. //                        ['encData' => $this->get('url_encryptor')->encrypt(json_encode(array(
  4993. //                            'invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1)
  4994. //                        ))), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  4995. //                    ),
  4996. //                    'fail_url' => $this->generateUrl(
  4997. //                        'payment_gateway_cancel', ['invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  4998. //                    ),
  4999. //                    'cancel_url' => $this->generateUrl(
  5000. //                        'payment_gateway_cancel', ['invoiceId' => $invoiceId, 'autoRedirect' => $request->request->get('autoRedirect', 1), 'hbeeSessionToken' => $session->get('token', 0)], UrlGenerator::ABSOLUTE_URL
  5001. //                    ),
  5002. ////                    'opt_a' => 'Reshad',  //optional paramter
  5003. ////                    'opt_b' => 'Akil',
  5004. ////                    'opt_c' => 'Liza',
  5005. ////                    'opt_d' => 'Sohel',
  5006. ////                    'signature_key' => 'dbb74894e82415a2f7ff0ec3a97e4183',  //sandbox
  5007. //                    'signature_key' => $sandBoxMode == 1 ? 'dbb74894e82415a2f7ff0ec3a97e4183' : 'b7304a40e21fe15af3be9a948307f524'  //live
  5008. //
  5009. //                ); //signature key will provided aamarpay, contact integration@aamarpay.com for test/live signature key
  5010. //
  5011. //                $fields_string = http_build_query($fields);
  5012. //
  5013. //                $ch = curl_init();
  5014. //                curl_setopt($ch, CURLOPT_VERBOSE, true);
  5015. //                curl_setopt($ch, CURLOPT_URL, $url);
  5016. //
  5017. //                curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
  5018. //                curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  5019. //                curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  5020. //                $url_forward = str_replace('"', '', stripslashes(curl_exec($ch)));
  5021. //                curl_close($ch);
  5023. //                $this->redirect_to_merchant($url_forward);
  5026.             }
  5028.         }
  5030.         if ($triggerMiddlePage == 1) return $this->render('@Buddybee/pages/makePaymentOfEntityInvoiceLandingPage.html.twig', array(
  5031.             'page_title' => 'Invoice Payment',
  5033.             'data' => $output,
  5036.         ));
  5037.         else
  5038.             return new JsonResponse($output);
  5041.     }
  5044.     public function RefundEntityInvoiceAction(Request $request, $encData = '')
  5045.     {
  5048.         $em = $this->getDoctrine()->getManager('company_group');
  5049.         $invoiceId = 0;
  5051.         $currIsProcessedFlagValue = '_UNSET_';
  5053.         $session = $request->getSession();
  5054.         $sandBoxMode = $this->container->hasParameter('sand_box_mode') ? $this->container->getParameter('sand_box_mode') : 0;
  5056.         $paymentId = $request->query->get('paymentID', 0);
  5057.         $status = $request->query->get('status', 0);
  5059.         $refundSuccess = 0;
  5060.         $errorMsg = '';
  5061.         $errorCode = '';
  5064.         if ($encData != '') {
  5065.             $invoiceId = $encData;
  5066.             $encryptedData = json_decode($this->get('url_encryptor')->decrypt($encData), true);
  5067.             if (isset($encryptedData['invoiceId']))
  5068.                 $invoiceId = $encryptedData['invoiceId'];
  5069.             if (isset($encryptedData['autoRedirect']))
  5070.                 $autoRedirect = $encryptedData['autoRedirect'];
  5071.         } else {
  5072.             $invoiceId = $request->request->get('invoiceId', $request->query->get('invoiceId', 0));
  5074.             $meetingId = 0;
  5075.             $autoRedirect = $request->query->get('autoRedirect', 1);
  5076.             $redirectUrl = '';
  5077.         }
  5080.         $gatewayInvoice = $em->getRepository('CompanyGroupBundle\\Entity\\EntityInvoice')->findOneBy(
  5081.             array(
  5082.                 'Id' => $invoiceId,
  5083.                 'isProcessed' => [1]
  5085.             ));
  5088.         if ($gatewayInvoice) {
  5089.             $gatewayInvoice->setIsProcessed(3); //pending settlement
  5090.             $currIsProcessedFlagValue = $gatewayInvoice->getIsProcessed();
  5091.             $em->flush();
  5093.             if ($gatewayInvoice->getAmountTransferGateWayHash() == 'bkash') {
  5094.                 $invoiceId = $gatewayInvoice->getId();
  5096.                 $paymentID = $gatewayInvoice->getGatewayPaymentId();
  5097.                 $trxID = $gatewayInvoice->getGatewayTransId();
  5099.                 $justNow = new \DateTime();
  5101.                 $baseUrl = ($sandBoxMode == 1) ? 'https://tokenized.sandbox.bka.sh/v1.2.0-beta' : 'https://tokenized.pay.bka.sh/v1.2.0-beta';
  5102.                 $username_value = ($sandBoxMode == 1) ? 'sandboxTokenizedUser02' : '01891962953';
  5103.                 $password_value = ($sandBoxMode == 1) ? 'sandboxTokenizedUser02@12345' : ',a&kPV4deq&';
  5104.                 $app_key_value = ($sandBoxMode == 1) ? '4f6o0cjiki2rfm34kfdadl1eqq' : '2ueVHdwz5gH3nxx7xn8wotlztc';
  5105.                 $app_secret_value = ($sandBoxMode == 1) ? '2is7hdktrekvrbljjh44ll3d9l1dtjo4pasmjvs5vl5qr3fug4b' : '49Ay3h3wWJMBFD7WF5CassyLrtA1jt6ONhspqjqFx5hTjhqh5dHU';
  5108.                 $justNowTs = $justNow->format('U');
  5109.                 if ($gatewayInvoice->getGatewayIdTokenExpireTs() <= $justNowTs) {
  5110.                     $refresh_token = $gatewayInvoice->getGatewayIdRefreshToken();
  5112.                     $request_data = array(
  5113.                         'app_key' => $app_key_value,
  5114.                         'app_secret' => $app_secret_value,
  5115.                         'refresh_token' => $refresh_token
  5116.                     );
  5117.                     $url = curl_init($baseUrl . '/tokenized/checkout/token/refresh');
  5119.                     $request_data_json = json_encode($request_data);
  5121.                     $header = array(
  5122.                         'Content-Type:application/json',
  5123.                         'username:' . $username_value,
  5124.                         'password:' . $password_value
  5125.                     );
  5126.                     curl_setopt($url, CURLOPT_HTTPHEADER, $header);
  5127.                     curl_setopt($url, CURLOPT_CUSTOMREQUEST, "POST");
  5128.                     curl_setopt($url, CURLOPT_RETURNTRANSFER, true);
  5129.                     curl_setopt($url, CURLOPT_POSTFIELDS, $request_data_json);
  5130.                     curl_setopt($url, CURLOPT_FOLLOWLOCATION, 1);
  5131.                     curl_setopt($url, CURLOPT_IPRESOLVE, CURL_IPRESOLVE_V4);
  5133.                     $tokenData = json_decode(curl_exec($url), true);
  5134.                     curl_close($url);
  5137.                     $justNow = new \DateTime();
  5138.                     $justNow->modify('+' . $tokenData['expires_in'] . ' second');
  5139.                     $gatewayInvoice->setGatewayIdTokenExpireTs($justNow->format('U'));
  5140.                     $gatewayInvoice->setGatewayIdToken($tokenData['id_token']);
  5141.                     $gatewayInvoice->setGatewayIdRefreshToken($tokenData['refresh_token']);
  5142.                     $em->flush();
  5143.                 }
  5146.                 $auth = $gatewayInvoice->getGatewayIdToken();;
  5148.                 $post_token = array(
  5149.                     'paymentID' => $paymentID,
  5150.                     'trxID' => $trxID,
  5151.                     'reason' => 'Full Refund Policy',
  5152.                     'sku' => 'RSTR',
  5153.                     'amount' => 1 * number_format($gatewayInvoice->getGateWayBillamount(), 2, '.', ''),
  5154.                 );
  5155.                 $url = curl_init($baseUrl . '/tokenized/checkout/payment/refund');
  5156.                 $posttoken = json_encode($post_token);
  5158.                 $header = array(
  5159.                     'Content-Type:application/json',
  5160.                     'Authorization:' . $auth,
  5161.                     'X-APP-Key:' . $app_key_value
  5162.                 );
  5163.                 curl_setopt($url, CURLOPT_HTTPHEADER, $header);
  5164.                 curl_setopt($url, CURLOPT_CUSTOMREQUEST, "POST");
  5165.                 curl_setopt($url, CURLOPT_RETURNTRANSFER, true);
  5166.                 curl_setopt($url, CURLOPT_POSTFIELDS, $posttoken);
  5167.                 curl_setopt($url, CURLOPT_FOLLOWLOCATION, 1);
  5168.                 curl_setopt($url, CURLOPT_IPRESOLVE, CURL_IPRESOLVE_V4);
  5169.                 $resultdata = curl_exec($url);
  5171.                 curl_close($url);
  5173.                 $obj = json_decode($resultdata, true);
  5175. //                return new JsonResponse($obj);
  5177.                 if (isset($obj['completedTime']))
  5178.                     $refundSuccess = 1;
  5179.                 else if (isset($obj['errorCode'])) {
  5180.                     $refundSuccess = 0;
  5181.                     $errorCode = $obj['errorCode'];
  5182.                     $errorMsg = $obj['errorMessage'];
  5183.                 }
  5184. //                    $gatewayInvoice->setGatewayTransId($obj['trxID']);
  5185.                 $em->flush();
  5188.             }
  5191.             if ($refundSuccess == 1) {
  5192.                 Buddybee::RefundEntityInvoice($em, $invoiceId);
  5193.                 $currIsProcessedFlagValue = 4;
  5194.             }
  5195.         } else {
  5197.         }
  5199.         MiscActions::RefreshBuddybeeBalanceOnSession($em, $request->getSession());
  5202.         return new JsonResponse(
  5203.             array(
  5204.                 'success' => $refundSuccess,
  5205.                 'errorCode' => $errorCode,
  5206.                 'isProcessed' => $currIsProcessedFlagValue,
  5207.                 'errorMsg' => $errorMsg,
  5208.             )
  5209.         );
  5212.     }
  5215.     public function ViewEntityInvoiceAction(Request $request, $encData = '')
  5216.     {
  5217.         $em = $this->getDoctrine()->getManager('company_group');
  5218.         $invoiceId = 0;
  5219.         $autoRedirect = 1;
  5220.         $redirectUrl = '';
  5221.         $meetingId = 0;
  5222.         $invoice = null;
  5225.         if ($encData != '') {
  5226.             $encryptedData = json_decode($this->get('url_encryptor')->decrypt($encData), true);
  5227.             $invoiceId = $encData;
  5228.             if (isset($encryptedData['invoiceId']))
  5229.                 $invoiceId = $encryptedData['invoiceId'];
  5230.             if (isset($encryptedData['autoRedirect']))
  5231.                 $autoRedirect = $encryptedData['autoRedirect'];
  5232.         } else {
  5233.             $invoiceId = $request->query->get('invoiceId', 0);
  5235.             $meetingId = 0;
  5236.             $autoRedirect = $request->query->get('autoRedirect', 1);
  5237.             $redirectUrl = '';
  5238.         }
  5240. //    $invoiceList = [];
  5242.         $billerDetails = [];
  5243.         $billToDetails = [];
  5244.         if ($invoiceId != 0) {
  5245.             $invoice = $em->getRepository('CompanyGroupBundle\\Entity\\EntityInvoice')
  5246.                 ->findOneBy(
  5247.                     array(
  5248.                         'Id' => $invoiceId,
  5250.                     )
  5251.                 );
  5253.             if ($invoice) {
  5254.                 $billerDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  5255.                     ->findOneBy(
  5256.                         array(
  5257.                             'applicantId' => $invoice->getBillerId(),
  5259.                         )
  5260.                     );
  5261.                 $billToDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  5262.                     ->findOneBy(
  5263.                         array(
  5264.                             'applicantId' => $invoice->getBillToId(),
  5266.                         )
  5267.                     );
  5269.             }
  5271.             if ($request->query->get('sendMail', 0) == 1 && GeneralConstant::EMAIL_ENABLED == 1) {
  5272.                 $billerDetails = [];
  5273.                 $billToDetails = [];
  5276.                 if ($invoice) {
  5277.                     $billerDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  5278.                         ->findOneBy(
  5279.                             array(
  5280.                                 'applicantId' => $invoice->getBillerId(),
  5282.                             )
  5283.                         );
  5284.                     $billToDetails = $em->getRepository('CompanyGroupBundle\\Entity\\EntityApplicantDetails')
  5285.                         ->findOneBy(
  5286.                             array(
  5287.                                 'applicantId' => $invoice->getBillToId(),
  5289.                             )
  5290.                         );
  5293.                     $bodyTemplate = '@Application/email/templates/buddybeeInvoiceEmail.html.twig';
  5294.                     $bodyData = array(
  5295.                         'page_title' => 'Invoice',
  5296. //            'studentDetails' => $student,
  5297.                         'billerDetails' => $billerDetails,
  5298.                         'billToDetails' => $billToDetails,
  5299.                         'invoice' => $invoice,
  5300.                         'currencyList' => BuddybeeConstant::$currency_List,
  5301.                         'currencyListByMarker' => BuddybeeConstant::$currency_List_by_marker,
  5304.                     );
  5305.                     $attachments = [];
  5306.                     $forwardToMailAddress = $billToDetails->getOAuthEmail();
  5309. //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  5310.                     $new_mail = $this->get('mail_module');
  5311.                     $new_mail->sendMyMail(array(
  5312.                         'senderHash' => '_CUSTOM_',
  5313.                         //                        'senderHash'=>'_CUSTOM_',
  5314.                         'forwardToMailAddress' => $forwardToMailAddress,
  5316.                         'subject' => 'YourInvoice #' . 'D' . str_pad('BB', 5, '0', STR_PAD_LEFT) . str_pad('76', 2, '0', STR_PAD_LEFT) . str_pad($invoice->getId(), 8, "0", STR_PAD_LEFT) . ' from BuddyBee ',
  5318. //                        'fileName' => 'Order#' . str_pad($id, 8, '0', STR_PAD_LEFT) . '.pdf',
  5319.                         'attachments' => $attachments,
  5320.                         'toAddress' => $forwardToMailAddress,
  5321.                         'fromAddress' => 'no-reply@buddybee.eu',
  5322.                         'userName' => 'no-reply@buddybee.eu',
  5323.                         'password' => 'Honeybee@0112',
  5324.                         'smtpServer' => 'smtp.hostinger.com',
  5325.                         'smtpPort' => 465,
  5327. //                            'emailBody' => $bodyHtml,
  5328.                         'mailTemplate' => $bodyTemplate,
  5329.                         'templateData' => $bodyData,
  5330.                         'embedCompanyImage' => 0,
  5331.                         'companyId' => 0,
  5333.                         'companyImagePath' => ''
  5334. //                        'embedCompanyImage' => 1,
  5335. //                        'companyId' => $companyId,
  5336. //                        'companyImagePath' => $company_data->getImage()
  5339.                     ));
  5340.                 }
  5343.             }
  5346. //            if ($invoice) {
  5347. //
  5348. //            } else {
  5349. //                return $this->render('@Buddybee/pages/404NotFound.html.twig', array(
  5350. //                    'page_title' => '404 Not Found',
  5351. //
  5352. //                ));
  5353. //            }
  5356.             return $this->render('@HoneybeeWeb/pages/views/honeybee_ecosystem_invoice.html.twig', array(
  5357.                 'page_title' => 'Invoice',
  5358. //            'studentDetails' => $student,
  5359.                 'billerDetails' => $billerDetails,
  5360.                 'billToDetails' => $billToDetails,
  5361.                 'invoice' => $invoice,
  5362.                 'currencyList' => BuddybeeConstant::$currency_List,
  5363.                 'currencyListByMarker' => BuddybeeConstant::$currency_List_by_marker,
  5366.             ));
  5367.         }
  5370.     }
  5371.     public function SignatureCheckFromCentralAction(Request $request)
  5372.     {
  5373.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  5375.         if ($systemType !== '_CENTRAL_') {
  5376.             return new JsonResponse(['success' => false, 'message' => 'Only allowed on CENTRAL server.'], 403);
  5377.         }
  5379.         $em = $this->getDoctrine()->getManager('company_group');
  5380.         $em->getConnection()->connect();
  5382.         $data = json_decode($request->getContent(), true);
  5384.         if (
  5385.             !$data ||
  5386.             !isset($data['userId']) ||
  5387.             !isset($data['companyId']) ||
  5388.             !isset($data['signatureData']) ||
  5389.             !isset($data['approvalHash']) ||
  5390.             !isset($data['applicantId'])
  5391.         ) {
  5392.             return new JsonResponse(['success' => false, 'message' => 'Missing parameters.'], 400);
  5393.         }
  5395.         $userId = $data['userId'];
  5396.         $companyId = $data['companyId'];
  5397.         $signatureData = $data['signatureData'];
  5398.         $approvalHash = $data['approvalHash'];
  5399.         $applicantId = $data['applicantId'];
  5401.         try {
  5402.             $centralUser = $em
  5403.                 ->getRepository("CompanyGroupBundle\\Entity\\EntityApplicantDetails")
  5404.                 ->findOneBy(['applicantId' => $applicantId]);
  5406.             if (!$centralUser) {
  5407.                 return new JsonResponse(['success' => false, 'message' => 'Central user not found.'], 404);
  5408.             }
  5410.             $userAppIds = json_decode($centralUser->getUserAppIds(), true);
  5411.             if (!is_array($userAppIds)) $userAppIds = [];
  5413.             $companies = $em->getRepository('CompanyGroupBundle\\Entity\\CompanyGroup')->findBy([
  5414.                 'appId' => $userAppIds
  5415.             ]);
  5417.             if (count($companies) < 1) {
  5418.                 return new JsonResponse(['success' => false, 'message' => 'No companies found for userAppIds.'], 404);
  5419.             }
  5421.             $repo = $em->getRepository('CompanyGroupBundle\\Entity\\EntitySignature');
  5422.             $record = $repo->findOneBy(['userId' => $userId]);
  5424.             if (!$record) {
  5425.                 $record = new \CompanyGroupBundle\Entity\EntitySignature();
  5426.                 $record->setUserId($applicantId);
  5427.                 $record->setCreatedAt(new \DateTime());
  5428.             }
  5430.             $record->setCompanyId($companyId);
  5431.             $record->setApplicantId($applicantId);
  5432.             $record->setData($signatureData);
  5433.             $record->setSigExists(0);
  5434.             $record->setLastDecryptedSigId(0);
  5435.             $record->setUpdatedAt(new \DateTime());
  5436.             $em->persist($record);
  5437.             $em->flush();
  5438.             $dataByServerId = [];
  5439.             $gocDataListByAppId = [];
  5440.             foreach ($companies as $entry) {
  5441.                 $gocDataListByAppId[$entry->getAppId()] = [
  5442.                     'dbName' => $entry->getDbName(),
  5443.                     'dbUser' => $entry->getDbUser(),
  5444.                     'dbPass' => $entry->getDbPass(),
  5445.                     'dbHost' => $entry->getDbHost(),
  5446.                     'serverAddress' => $entry->getCompanyGroupServerAddress(),
  5447.                     'port' => $entry->getCompanyGroupServerPort() ?: 80,
  5448.                     'appId' => $entry->getAppId(),
  5449.                     'serverId' => $entry->getCompanyGroupServerId(),
  5450.                 ];
  5451.                 if (!isset($dataByServerId[$entry->getCompanyGroupServerId()]))
  5452.                     $dataByServerId[$entry->getCompanyGroupServerId()] = array(
  5455.                         'serverId' => $entry->getCompanyGroupServerId(),
  5456.                         'serverAddress' => $entry->getCompanyGroupServerAddress(),
  5457.                         'port' => $entry->getCompanyGroupServerPort() ?: 80,
  5458.                         'payload' => array(
  5459.                             'globalId' => $applicantId,
  5460.                             'companyId' => $userAppIds,
  5461.                             'signatureData' => $signatureData,
  5462. //                                      'approvalHash' => $approvalHash
  5463.                         )
  5464.                     );
  5465.             }
  5468.             $urls = [];
  5471.             foreach ($dataByServerId as $entry) {
  5472.                 $serverAddress = $entry['serverAddress'];
  5473.                 if (!$serverAddress) continue;
  5476. //                     $connector = $this->container->get('application_connector');
  5477. //                     $connector->resetConnection(
  5478. //                         'default',
  5479. //                         $entry['dbName'],
  5480. //                         $entry['dbUser'],
  5481. //                         $entry['dbPass'],
  5482. //                         $entry['dbHost'],
  5483. //                         $reset = true
  5484. //                     );
  5487.                 $syncUrl = $serverAddress . '/ReceiveSignatureFromCentral';
  5489.                 $payload = $entry['payload'];
  5491.                 $curl = curl_init();
  5492.                 curl_setopt_array($curl, [
  5493.                     CURLOPT_RETURNTRANSFER => true,
  5494.                     CURLOPT_POST => true,
  5495.                     CURLOPT_URL => $syncUrl,
  5496. //                         CURLOPT_PORT => $entry['port'],
  5497.                     CURLOPT_CONNECTTIMEOUT => 10,
  5498.                     CURLOPT_SSL_VERIFYPEER => false,
  5499.                     CURLOPT_SSL_VERIFYHOST => false,
  5500.                     CURLOPT_HTTPHEADER => [
  5501.                         'Accept: application/json',
  5502.                         'Content-Type: application/json'
  5503.                     ],
  5504.                     CURLOPT_POSTFIELDS => json_encode($payload)
  5505.                 ]);
  5507.                 $response = curl_exec($curl);
  5508.                 $err = curl_error($curl);
  5509.                 $httpCode = curl_getinfo($curl, CURLINFO_HTTP_CODE);
  5510.                 curl_close($curl);
  5513. //                     if ($err) {
  5514. //                         error_log("ERP Sync Error [AppID $appId]: $err");
  5515. //                          $urls[]=$err;
  5516. //                     } else {
  5517. //                         error_log("ERP Sync Response [AppID $appId] (HTTP $httpCode): $response");
  5518. //                         $res = json_decode($response, true);
  5519. //                         if (!isset($res['success']) || !$res['success']) {
  5520. //                             error_log("❗ ERP Sync error for AppID $appId: " . ($res['message'] ?? 'Unknown'));
  5521. //                         }
  5522. //
  5523. //                      $urls[]=$response;
  5524. //                     }
  5525.             }
  5528.             return new JsonResponse(['success' => true, 'message' => 'Signature synced successfully.']);
  5530.         } catch (\Exception $e) {
  5531.             return new JsonResponse(['success' => false, 'message' => 'DB error: ' . $e->getMessage()], 500);
  5532.         }
  5533.     }
  5534.  //datev cntroller
  5535.     public function connectDatev(Request $request)
  5536.     {
  5537.         $clientId = "51b09bdcf577c5b998cddce7fe7d5c92";
  5538.         $redirectUri = "https://ourhoneybee.eu/datev/callback";
  5540.         $state = bin2hex(random_bytes(10));
  5541.         $scope = "openid profile email accounting:documents accounting:dxso-jobs accounting:clients:read datev:accounting:extf-files-import datev:accounting:clients";
  5542.         $codeVerifier = bin2hex(random_bytes(32));
  5543.         $codeChallenge = rtrim(strtr(base64_encode(hash('sha256', $codeVerifier, true)), '+/', '-_'), '=');
  5545.         $session = $request->getSession();
  5546.         $applicantId = $session->get(UserConstants::APPLICANT_ID);
  5548.         $em_goc = $this->getDoctrine()->getManager('company_group');
  5551.         $token = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityDatevToken')
  5552.             ->findOneBy(['userId' => $applicantId]);
  5554.         if (!$token) {
  5555.             $token = new EntityDatevToken();
  5556.             $token->setUserId($applicantId);
  5557.         }
  5559.         $token->setState($state);
  5560.         $token->setCodeChallenge($codeChallenge);
  5561.         $token->setCodeVerifier($codeVerifier);
  5563.         $em_goc->persist($token);
  5564.         $em_goc->flush();
  5566.         $url = "https://login.datev.de/openidsandbox/authorize?"
  5567.             ."response_type=code"
  5568.             ."&client_id=".$clientId
  5569.             ."&state=".$state
  5570.             ."&scope=".urlencode($scope)
  5571.             ."&redirect_uri=".urlencode($redirectUri)
  5572.             ."&code_challenge=".$codeChallenge
  5573.             ."&code_challenge_method=S256"
  5574.             ."&prompt=login";
  5576.         return $this->redirect($url);
  5577.     }
  5578.     public function datevCallback(Request $request)
  5579.     {
  5580.         $code  = $request->get('code');
  5581.         $state = $request->get('state');
  5583.         if (!$code || !$state) {
  5584.             return new Response("Invalid callback request");
  5585.         }
  5587.         $em_goc = $this->getDoctrine()->getManager('company_group');
  5588.         $tokenEntity = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityDatevToken')
  5589.             ->findOneBy(['state' => $state]);
  5591.         if (!$tokenEntity) {
  5592.             return new Response("Invalid or expired state");
  5593.         }
  5596.         $codeVerifier = $tokenEntity->getCodeVerifier();
  5598.         if (!$codeVerifier) {
  5599.             return new Response("Code verifier missing");
  5600.         }
  5602.         $clientId = "51b09bdcf577c5b998cddce7fe7d5c92";
  5603.         $clientSecret = "9b1c4e72a966e9f231584393ff1d3469";
  5605.         // from parameters
  5606. //        $clientId= $this->getContainer()->getParameter('datev_client_id');
  5607. //        $clientSecret= $this->getContainer()->getParameter('datev_client_secret');
  5609.         $authString = base64_encode($clientId . ":" . $clientSecret);
  5610.         $redirectUri = "https://ourhoneybee.eu/datev/callback";
  5613.         $postFields = http_build_query([
  5614.             "grant_type"    => "authorization_code",
  5615.             "code"          => $code,
  5616.             "redirect_uri"  => $redirectUri,
  5617.             "client_id"     => $clientId,
  5618.             "code_verifier" => $codeVerifier
  5619.         ]);
  5621.         $ch = curl_init();
  5623.         curl_setopt_array($ch, [
  5624.             CURLOPT_URL            => "https://sandbox-api.datev.de/token",
  5625.             CURLOPT_POST           => true,
  5626.             CURLOPT_RETURNTRANSFER => true,
  5627.             CURLOPT_POSTFIELDS     => $postFields,
  5628.             CURLOPT_HTTPHEADER     => [
  5629.                 "Content-Type: application/x-www-form-urlencoded",
  5630.                 "Authorization: Basic " . $authString
  5631.             ]
  5632.         ]);
  5634.         $response = curl_exec($ch);
  5636.         if (curl_errno($ch)) {
  5637.             return new Response("cURL Error: " . curl_error($ch), 500);
  5638.         }
  5640.         curl_close($ch);
  5642.         $data = json_decode($response, true);
  5644.         if (!$data) {
  5645.             return new Response("Invalid token response", 500);
  5646.         }
  5648.         if (isset($data['access_token'])) {
  5650.             $tokenEntity->setAccessToken($data['access_token']);
  5651.             $session = $request->getSession();  //remove it later
  5652.             $session->set('DATEV_ACCESS_TOKEN', $data['access_token']);
  5654.             if (isset($data['refresh_token'])) {
  5655.                 $tokenEntity->setRefreshToken($data['refresh_token']);
  5656.             }
  5658.             if (isset($data['expires_in'])) {
  5659.                 $tokenEntity->setExpiresAt(time() + $data['expires_in']);
  5660.             }
  5663. //            $tokenEntity->setState(null);
  5664.             $tokenEntity->setCode($code);
  5666.             $em_goc->flush();
  5668.             return $this->redirect("/datev/home");
  5669.         }
  5671.         return new Response(
  5672.             "Token exchange failed: " . json_encode($data),
  5673.             400
  5674.         );
  5675.     }
  5677.     public function refreshToken(Request $request)
  5678.     {
  5679.         $em_goc = $this->getDoctrine()->getManager('company_group');
  5680.         $session = $request->getSession();
  5681.         $applicantId = $session->get(UserConstants::APPLICANT_ID);
  5683.         $token = $em_goc->getRepository('CompanyGroupBundle\\Entity\\EntityDatevToken')
  5684.             ->findOneBy(['userId' => $applicantId]);
  5686.         if (!$token) {
  5687.             return new JsonResponse([
  5688.                 'status' => false,
  5689.                 'message' => 'User token not found'
  5690.             ]);
  5691.         }
  5694.         if (!$token->getRefreshToken()) {
  5695.             return new JsonResponse([
  5696.                 'status' => false,
  5697.                 'message' => 'No refresh token available'
  5698.             ]);
  5699.         }
  5701.         $clientId = "51b09bdcf577c5b998cddce7fe7d5c92";
  5702.         $clientSecret = "9b1c4e72a966e9f231584393ff1d3469";
  5704.         $authString = base64_encode($clientId . ":" . $clientSecret);
  5706.         $postFields = http_build_query([
  5707.             "grant_type" => "refresh_token",
  5708.             "refresh_token" => $token->getRefreshToken(),
  5709.         ]);
  5711.         $ch = curl_init();
  5713.         curl_setopt_array($ch, [
  5714.             CURLOPT_URL => "https://sandbox-api.datev.de/token",
  5715.             CURLOPT_POST => true,
  5716.             CURLOPT_RETURNTRANSFER => true,
  5717.             CURLOPT_POSTFIELDS => $postFields,
  5718.             CURLOPT_HTTPHEADER => [
  5719.                 "Content-Type: application/x-www-form-urlencoded",
  5720.                 "Authorization: Basic " . $authString
  5721.             ]
  5722.         ]);
  5724.         $response = curl_exec($ch);
  5726.         if (curl_errno($ch)) {
  5727.             return new JsonResponse([
  5728.                 'status' => false,
  5729.                 'message' => curl_error($ch)
  5730.             ]);
  5731.         }
  5733.         curl_close($ch);
  5735.         $data = json_decode($response, true);
  5737.         if (!isset($data['access_token'])) {
  5738.             return new JsonResponse([
  5739.                 'status' => false,
  5740.                 'message' => 'Refresh failed',
  5741.                 'error' => $data
  5742.             ]);
  5743.         }
  5746.         $token->setAccessToken($data['access_token']);
  5748.         if (isset($data['refresh_token'])) {
  5749.             $token->setRefreshToken($data['refresh_token']);
  5750.         }
  5751.         $token->setExpiresAt(time() + $data['expires_in']);
  5752.         $em_goc->flush();
  5753.         return new JsonResponse([
  5754.             'status' => true,
  5755.             'message' => 'Token refreshed successfully'
  5756.         ]);
  5757.     }
  5759.     public function registerDevice(Request $request)
  5760.     {
  5761.         $em_goc = $this->getDoctrine()->getManager('company_group');
  5763.         $data = json_decode($request->getContent(), true);
  5765.         if (!$data) {
  5766.             $data = $request->request->all();
  5767.         }
  5769.         $deviceSerial = $data['device_id'] ?? null;
  5771.         if (!$deviceSerial) {
  5772.             return new JsonResponse([
  5773.                 'success' => false,
  5774.                 'message' => 'Device serial is required',
  5775.                 'data' => null
  5776.             ], 400);
  5777.         }
  5779.         $device =  $em_goc->getRepository('CompanyGroupBundle\\Entity\\Device')
  5780.             ->findOneBy(['deviceSerial' => $deviceSerial]);
  5782.         if (!$device) {
  5783.             $device = new Device();
  5784.             $device->setDeviceSerial($deviceSerial);
  5785.             $message = 'Device registered successfully';
  5786.         } else {
  5787.             $message = 'Device updated successfully';
  5788.         }
  5790.         if (isset($data['deviceName'])) {
  5791.             $device->setDeviceName($data['deviceName']);
  5792.         }
  5794.         if (isset($data['appId'])) {
  5795.             $device->setAppId($data['appId']);
  5796.         }
  5798.         if (isset($data['deviceType'])) {
  5799.             $device->setDeviceType($data['deviceType']);
  5800.         }
  5802.         if (isset($data['deviceMarker'])) {
  5803.             $device->setDeviceMarker($data['deviceMarker']);
  5804.         }
  5806.         if (isset($data['timezoneStr'])) {
  5807.             $device->setTimezoneStr($data['timezoneStr']);
  5808.         }
  5810.         if (isset($data['hostname'])) {
  5811.             $device->setHostName($data['hostname']);
  5812.         }
  5814.         $em_goc->persist($device);
  5815.         $em_goc->flush();
  5817.         return new JsonResponse([
  5818.             'success' => true,
  5819.             'message' => $message,
  5820.             'data' => [
  5821.                 'id' => $device->getId(),
  5822.                 'deviceSerial' => $device->getDeviceSerial(),
  5823.                 'deviceName' => $device->getDeviceName(),
  5824.                 'deviceType' => $device->getDeviceType(),
  5825.                 'hostName' => $device->getHostName(),
  5826.             ]
  5827.         ]);
  5828.     }
  5829.     public function khorchapatiTermsAndConditions()
  5830.     {
  5831.              return $this->render('@HoneybeeWeb/pages/khorchapati_terms_and_conditions.html.twig', array(
  5832.             'page_title' => 'Terms and Conditions — Khorchapati',
  5833.         ));
  5835.             
  5836.     }
  5837.     public function milkShareTermsAndConditions()
  5838.     {
  5839.         return $this->render('@HoneybeeWeb/pages/milkshare-terms-and-conditions.html.twig', array(
  5840.             'page_title' => 'Terms and Conditions — Milkshare',
  5841.         ));
  5844.     }
  5846. }