src/ApplicationBundle/Controller/ApplicationManagementController.php line 1145

Open in your IDE?
  1. <?php
  3. namespace ApplicationBundle\Controller;
  5. use ApplicationBundle\ApplicationBundle;
  6. use ApplicationBundle\Constants\GeneralConstant;
  7. use ApplicationBundle\Constants\ModuleConstant;
  8. use ApplicationBundle\Entity\Approval;
  9. use ApplicationBundle\Entity\Company;
  10. use ApplicationBundle\Entity\DocumentData;
  11. use ApplicationBundle\Entity\SysModule;
  12. use ApplicationBundle\Entity\SysUser;
  13. use ApplicationBundle\Interfaces\LoginInterface;
  14. use ApplicationBundle\Modules\Authentication\Constants\UserConstants;
  15. use ApplicationBundle\Modules\Inventory\Inventory;
  16. use ApplicationBundle\Modules\System\MiscActions;
  17. use ApplicationBundle\Modules\System\System;
  18. use ApplicationBundle\Modules\User\Users;
  19. use CompanyGroupBundle\Entity\CompanyGroup;
  20. use CompanyGroupBundle\Entity\DeviceSensorData;
  21. use CompanyGroupBundle\Entity\DeviceSensorDataDay;
  22. use CompanyGroupBundle\Entity\DeviceSensorDataHour;
  23. use CompanyGroupBundle\Entity\DeviceSensorDataMonth;
  24. use CompanyGroupBundle\Entity\DeviceSensorDataWeek;
  25. use CompanyGroupBundle\Entity\EntityApplicantDetails;
  26. use Doctrine\ORM\Tools\SchemaTool;
  27. use Symfony\Component\HttpFoundation\JsonResponse;
  28. use Symfony\Component\HttpFoundation\Request;
  29. use Symfony\Component\HttpFoundation\Response;
  30. use Symfony\Component\Routing\Generator\UrlGenerator;
  32. class ApplicationManagementController extends GenericController implements LoginInterface
  33. {
  36.     public function DeviceDataEmsIngestAction(Request $request, $id = 0)
  37.     {
  38.         $em_goc = $this->getDoctrine()->getManager('company_group');
  40.         $content = $request->getContent(); // raw body string
  41.         $data = json_decode($content, true); // decode JSON if needed
  43.         // Example: access fields
  44.         if ($data == null) $data = [];
  45.         $emsDataSegregation = GeneralConstant::$emsDataSegregation;
  46.         $segregatedData = [];
  47.         $segregatedDataByDeviceId = [];
  49.         $siteId = (isset($data['siteId'])) ? $data['siteId'] : 0;
  51.         //first create a new array or records which will then be modified and or created
  54.         $modifiedData = array();
  55.         $firstTs = 0;
  56.         $lastTs = 0;
  57.         $siteIds = [$siteId];
  58. //        $defaultData = [
  59. //            'marker' => '',
  60. //            'ts' => '',
  61. //            'data' => []
  62. //        ];
  63.         $defaultValues = [0, 0, 0, 0];
  65.         if (isset($data['records']))
  66.             foreach ($data['records'] as $key => $value) {
  67.                 $timeStampDt = new \DateTime($value['timestamp']);
  68.                 $timeStampDt->setTimezone(new \DateTimeZone('+0000'));
  69.                 $timeStampTs = 1 * $timeStampDt->format('U');
  70.                 if ($timeStampTs > $lastTs) $lastTs = $timeStampTs;
  71.                 if ($timeStampTs < $firstTs || $firstTs = 0) $firstTs = $timeStampTs;
  72.                 if (!in_array($data['siteId'], $siteIds)) $siteIds[] = $data['siteId'];
  74.                 foreach ($emsDataSegregation as $key2 => $dataSegregation) {
  75.                     if (!isset($segregatedDataByDeviceId[$value['device_id']]))
  76.                         $segregatedDataByDeviceId[$value['device_id']] = [];
  77.                     if (!isset($segregatedDataByDeviceId[$value['device_id']][$key2]))
  78.                         $segregatedDataByDeviceId[$value['device_id']][$key2] = [];
  79.                     $segregatedData = $segregatedDataByDeviceId[$value['device_id']];
  81. //                    $segregatedData[$key2] = [
  82. ////                             '20250406':   [
  83. ////                                    'marker' => '',
  84. ////                                    'ts' => '',
  85. ////                                    'data' => ['Battery_power' => [0, 2, 1, 4]]
  86. ////                                ]
  88. //                        ];
  89. //                    [{'_identifier_':{min,max,avg,count}}]
  90.                     $markerForThis = 1 * $timeStampDt->format($dataSegregation['markerStr']);
  91.                     if (isset($dataSegregation['isWeek'])) {
  92.                         $startDtForThis = new \DateTime();
  93.                         $startDtForThis->setISODate($timeStampDt->format('Y'), $timeStampDt->format('W'));
  95.                     } else {
  96.                         $startDtForThis = new \DateTime($timeStampDt->format($dataSegregation['startTsFormat']));
  98.                     }
  99.                     $startDtForThis->setTimezone(new \DateTimeZone('+0000'));
  100.                     $startTsForThis = $startDtForThis->format('U');
  102.                     if (!isset($segregatedData[$key2][$markerForThis]))
  103.                         $segregatedData[$key2][$markerForThis] = [
  104.                             'marker' => $markerForThis,
  105.                             'ts' => $startTsForThis,
  106.                             'data' => []
  107.                         ];
  109.                     if (!isset($segregatedData[$key2][$markerForThis]['data'][$value['identifier']]))
  110.                         $segregatedData[$key2][$markerForThis]['data'][$value['identifier']] = $defaultValues;
  112.                     $newValues = $segregatedData[$key2][$markerForThis]['data'][$value['identifier']];
  114.                     //indexes 0:min, 1:max, 2:avg, 3:count
  115.                     $min = $newValues[0];
  116.                     $max = $newValues[1];
  117.                     $avg = $newValues[2];
  118.                     $count = $newValues[3];
  120.                     //now modify
  122.                     if ($value['value'] > $max) $max = $value['value'];
  123.                     if ($value['value'] < $min) $min = $value['value'];
  124.                     $avg = ($count * $avg + $value['value']) / ($count + 1);
  125.                     $count++;
  128.                     $newValues = [$min, $max, $avg, $count];
  129.                     $segregatedData[$key2][$markerForThis]['data'][$value['identifier']] = $newValues;
  131.                     $segregatedDataByDeviceId[$value['device_id']] = $segregatedData;
  134.                 }
  136.             }
  139.         //nnow data are segregated now add them
  141.         foreach ($emsDataSegregation as $key2 => $dataSegregation) {
  142.             foreach ($segregatedDataByDeviceId as $deviceId => $segregatedData) {
  145.                 if (!isset($segregatedData[$key2]))
  146.                     $segregatedData[$key2] = [];
  148.                 foreach ($segregatedData[$key2] as $key3 => $dt) {
  149.                     $timeStampDt = new \DateTime('@' . $dt['ts']);
  150.                     $timeStampDt->setTimezone(new \DateTimeZone('+0000'));
  151.                     $markerForThis = $dt['marker'];
  152.                     $entry = $this->getDoctrine()->getManager('company_group')
  153.                         ->getRepository('CompanyGroupBundle:' . $dataSegregation['repository'])
  154.                         ->findOneBy(array(
  155.                             'marker' => $markerForThis,
  156.                             'siteId' => $siteId,
  157.                             'deviceId' => $deviceId
  158.                         ));
  160.                     $repoClassName = "CompanyGroupBundle\\Entity\\" . $dataSegregation['repository'];
  161.                     $hasEntry = 1;
  163.                     if (!$entry) {
  164.                         $hasEntry = 0;
  166.                         $entry = new $repoClassName();
  167.                         $entry->setTimeStamp($timeStampDt);
  168.                         $entry->setTimeStampTs($dt['ts']);
  169.                         $entry->setSiteId($siteId);
  170.                         $entry->setMarker($markerForThis);
  171.                         $entry->setDeviceId($deviceId);
  172.                     }
  174.                     $existingData = json_decode($entry->getData(), true);
  175.                     if ($existingData == null) $existingData = [];
  177. //                    $existingData=$segregatedDataByDeviceId; //temp
  179.                     foreach ($dt['data'] as $identifier => $newValues) {
  180.                         if (!isset($existingData[$identifier]))
  181.                             $existingData[$identifier] = $newValues;
  182.                         else {
  184.                             //indexes 0:min, 1:max, 2:avg, 3:count
  185.                             $min = $existingData[$identifier][0];
  186.                             $max = $existingData[$identifier][1];
  187.                             $avg = $existingData[$identifier][2];
  188.                             $count = $existingData[$identifier][3];
  190.                             //now modify
  192.                             if ($newValues[1] > $max) $max = $newValues[1];
  193.                             if ($newValues[0] < $min) $min = $newValues[0];
  194.                             $avg = ($count * $avg + $newValues[2] * $newValues[3]) / ($count + $newValues[3]);
  195.                             $count = $count + $newValues[3];
  198.                             $existingData[$identifier] = [$min, $max, $avg, $count];
  201.                         }
  204.                     }
  205.                     $entry->setData(json_encode($existingData));
  208.                     if ($hasEntry == 0)
  209.                         $em_goc->persist($entry);
  211.                     $em_goc->flush();
  214.                 }
  215.             }
  216.         }
  219.         return new JsonResponse(array(
  220.             'success' => true,
  221.         ));
  222.     }
  224.     public function DeviceDataEmsIngestActionLater(Request $request, $id = 0)
  225.     {
  226.         $em_goc = $this->getDoctrine()->getManager('company_group');
  228.         $content = $request->getContent(); // raw body string
  229.         $data = json_decode($content, true); // decode JSON if needed
  231.         // Example: access fields
  232.         if ($data == null) $data = [];
  234.         $siteId = (isset($data['siteId'])) ? $data['siteId'] : 0;
  237.         if (isset($data['records']))
  238.             foreach ($data['records'] as $key => $value) {
  239. //                $entry = $this->getDoctrine()->getManager('company_group')
  240. //                    ->getRepository("CompanyGroupBundle:DeviceSensorData")
  241. //                    ->findOneBy(array(
  242. //                        'recordId' => $value['record_id']
  243. //                    ));
  244.                 $entry = null;
  245.                 $hasEntry = 1;
  247.                 if (!$entry) {
  248.                     $hasEntry = 0;
  249.                     $entry = new DeviceSensorData();
  250.                 }
  251.                 $timeStampDt = new \DateTime($value['timestamp']);
  252.                 $entry->setDeviceId($value['device_id']);
  253.                 $entry->setRecordId($value['record_id']);
  254.                 $entry->setSiteId($siteId);
  255.                 $entry->setAlias($value['alias']);
  256.                 $entry->setValue($value['value']);
  257.                 $entry->setIdentifier($value['identifier']);
  258.                 $entry->setTimeStamp($timeStampDt);
  259.                 $entry->setTimeStampTs($timeStampDt->format('U'));
  260.                 if ($hasEntry == 0)
  261.                     $em_goc->persist($entry);
  263.                 $em_goc->flush();
  266.             }
  268.         return new JsonResponse(array(
  269.             'success' => true,
  270.         ));
  271.     }
  273.     public function DeviceDataEmsGetAction(Request $request, $id = 0)
  274.     {
  275.         $em_goc = $this->getDoctrine()->getManager('company_group');
  277.         $returnData = array(
  278.             'success' => false,
  279.             'dataList' => []
  280.         );
  281.         $getDatakeys = ['_BY_DAY_', '_BY_HOUR_'];
  282.         $emsDataSegregation = GeneralConstant::$emsDataSegregation;
  284.         foreach ($getDatakeys as $key2) {
  285.             $dataSegregation = $emsDataSegregation[$key2];
  286.             if (!isset($returnData['dataList'][$key2]))
  287.                 $returnData['dataList'][$key2] = [];
  290.             $repoClassName = $dataSegregation['repository'];
  293.             $dataQry = $this->getDoctrine()->getManager('company_group')
  294.                 ->getRepository('CompanyGroupBundle:' . $dataSegregation['repository'])
  295.                 ->createQueryBuilder('a')
  296.                 ->where('1=1');
  299.             if ($request->get('start_ts', 0) != 0) $dataQry->andWhere('a.timeStampTs >= ' . $request->get('start_ts', 0));
  300.             if ($request->get('end_ts', 0) != 0) $dataQry->andWhere('a.timeStampTs <= ' . $request->get('end_ts', 0));
  301.             if (!empty($request->get('device_ids', [])))
  302.                 $dataQry->andWhere('a.deviceId  in ( ' . implode(',', $request->get('device_ids', [])) . ' ) ');
  303.             if (!empty($request->get('identifiers', [])))
  304.                 $dataQry->andWhere('a.identifier  in ( ' . implode(',', $request->get('identifiers', [])) . ' ) ');
  305.             if (!empty($request->get('site_ids', [])))
  306.                 $dataQry->andWhere('a.siteId  in ( ' . implode(',', $request->get('site_ids', [])) . ' ) ');
  309.             $data = $dataQry
  310.                 ->setMaxResults(1000)
  311.                 ->getQuery()
  312.                 ->getResult();
  314.             if (!empty($data))
  315.                 $returnData['success'] = true;
  318.             foreach ($data as $key => $entry) {
  320.                 $value = array();
  322.                 $timeStampDt = $entry->getTimeStamp();
  323.                 $timeStampDt->setTimezone(new \DateTimeZone('+0000'));
  325.                 $existingData = json_decode($entry->getData(), true);
  326.                 if ($existingData == null) $existingData = [];
  328.                 foreach ($existingData as $identifier => $newValues) {
  329.                     $value['device_id'] = $entry->getDeviceId();
  331.                     $value['value'] = $newValues[2];
  332.                     $value['identifier'] = $identifier;
  333.                     $value['timestamp'] = $timeStampDt;
  334.                     $value['timestamp_ts'] = $entry->getTimeStampTs();;
  336.                     $returnData['dataList'][$key2][] = $value;
  338.                 }
  341.             }
  342.         }
  344.         return new JsonResponse($returnData);
  345.     }
  347.     public function UpdateCompanyGroupAction(Request $request, $id = 0)
  348.     {
  350.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  352.         $appId = $request->get('app_id', 0);
  353.         $post = $request;
  354.         $session = $request->getSession();
  355.         $d = array();
  357.         if ($systemType == '_CENTRAL_') {
  358.             $em_goc = $this->getDoctrine()->getManager('company_group');
  359.             $em_goc->getConnection()->connect();
  360.             $connected = $em_goc->getConnection()->isConnected();
  363.             $gocDataList = [];
  364.             if ($connected) {
  366.                 $goc = null;
  367.                 $serverList = GeneralConstant::$serverListById;
  369.                 $companyGroupHash = $post->get('company_short_code', '');
  371.                 $defaultUsageDate = new \DateTime();
  372.                 $defaultUsageDate->modify('+1 year');
  373.                 $usageValidUpto = new \DateTime($post->get('usage_valid_upto_dt_str', $defaultUsageDate->format('Y-m-d')));
  376.                 $companyGroupServerId = $post->get('server_id', 1);
  377.                 $companyGroupServerAddress = $serverList[$companyGroupServerId]['absoluteUrl'];
  378.                 $companyGroupServerPort = $serverList[$companyGroupServerId]['port'];
  379.                 $companyGroupServerHash = $serverList[$companyGroupServerId]['serverMarker'];
  381. //                $dbUser=
  384.                 if ($appId != 0)
  385.                     $goc = $this->getDoctrine()->getManager('company_group')
  386.                         ->getRepository("CompanyGroupBundle:CompanyGroup")
  387.                         ->findOneBy(array(
  388.                             'appId' => $appId
  389.                         ));
  391.                 if (!$goc)
  392.                     $goc = new CompanyGroup();
  394.                 if ($appId == 0) {
  395.                     $biggestAppIdCg = $this->getDoctrine()->getManager('company_group')
  396.                         ->getRepository("CompanyGroupBundle:CompanyGroup")
  397.                         ->findOneBy(array(//                            'appId' => $appId
  398.                         ), array(
  399.                             'appId' => 'desc'
  400.                         ));
  401.                     if ($biggestAppIdCg)
  402.                         $appId = 1 + $biggestAppIdCg->getAppId();
  403.                 }
  405.                 if ($post->get('company_name', '') != '') {
  407.                     $goc->setName($post->get('company_name'));
  408.                     $goc->setCompanyGroupHash($companyGroupHash);
  409.                     $goc->setAppId($appId);
  410.                     $goc->setActive(1);
  411.                     $goc->setAddress($post->get('address'));
  412.                     $goc->setShippingAddress($post->get('s_address'));
  413.                     $goc->setBillingAddress($post->get('b_address'));
  414.                     $goc->setMotto($post->get('motto'));
  415.                     $goc->setInitiateFlag($post->get('initiate_flag', 2));
  416.                     $goc->setInvoiceFooter($post->get('i_footer'));
  417.                     $goc->setGeneralFooter($post->get('g_footer'));
  418.                     $goc->setCompanyReg($post->get('company_reg', ''));
  419.                     $goc->setCompanyTin($post->get('company_tin', ''));
  420.                     $goc->setCompanyBin($post->get('company_bin', ''));
  421.                     $goc->setCompanyTl($post->get('company_tl', ''));
  422.                     $goc->setCompanyType($post->get('company_type', ''));
  423.                     $goc->setCurrentSubscriptionPackageId($post->get('package', ''));
  424.                     $goc->setUsageValidUptoDate($usageValidUpto);
  425.                     $goc->setUsageValidUptoDateTs($usageValidUpto->format('U'));
  426. //                $goc->setCu($post->get('package', ''));
  427.                     $goc->setAdminUserAllowed($post->get('number_of_admin_user', ''));
  428.                     $goc->setUserAllowed($post->get('number_of_user', ''));
  429.                     $goc->setSubscriptionMonth($post->get('subscription_month', ''));
  430.                     $goc->setCompanyDescription($post->get('company_description', ''));
  431.                     $goc->setDbUser($post->get('db_user'));
  432.                     $goc->setDbPass($post->get('db_pass'));
  433.                     $goc->setDbHost($post->get('db_host'));
  434.                     $goc->setCompanyGroupServerId($companyGroupServerId);
  435.                     $goc->setCompanyGroupServerAddress($companyGroupServerAddress);
  436.                     $goc->setCompanyGroupServerPort($companyGroupServerPort);
  437.                     $goc->setCompanyGroupServerHash($companyGroupServerHash);
  440.                     foreach ($request->files as $uploadedFile) {
  443.                         if ($uploadedFile != null) {
  445.                             $fileName = 'company_image' . $appId . '.' . $uploadedFile->guessExtension();
  446.                             $path = $fileName;
  447.                             $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/CompanyImage/';
  449.                             if ($goc->getImage() != null && $goc->getImage() != '' && file_exists($this->container->getParameter('kernel.root_dir') . '/../web' . $goc->getImage())) {
  451.                                 unlink($this->container->getParameter('kernel.root_dir') . '/../web' . $goc->getImage());
  454.                             }
  456.                             if (!file_exists($upl_dir)) {
  457.                                 mkdir($upl_dir, 0777, true);
  458.                             }
  459.                             $file = $uploadedFile->move($upl_dir, $path);
  460.                             if ($path != "")
  461.                                 $goc->setImage('/uploads/CompanyImage/' . $path);
  462.                         }
  464.                     }
  467.                     $em_goc->persist($goc);
  468.                     $em_goc->flush();
  470.                     $goc->setDbName('cg_' . $appId . '_' . $companyGroupHash);
  471.                     $goc->setDbUser($serverList[$companyGroupServerId]['dbUser']);
  472.                     $goc->setDbPass($serverList[$companyGroupServerId]['dbPass']);
  473.                     $goc->setDbHost('localhost');
  474.                     $em_goc->flush();
  477.                     $centralUser = $this->getDoctrine()->getManager('company_group')
  478.                         ->getRepository("CompanyGroupBundle:EntityApplicantDetails")
  479.                         ->findOneBy(array(
  480.                             'applicantId' => $session->get(UserConstants::USER_ID, 0)
  481.                         ));
  482.                     if ($centralUser) {
  484.                         $userAppIds = json_decode($centralUser->getUserAppIds(), true);
  485.                         $userTypesByAppIds = json_decode($centralUser->getUserTypesByAppIds(), true);
  486.                         if ($userAppIds == null) $userAppIds = [];
  487.                         if ($userTypesByAppIds == null) $userTypesByAppIds = [];
  489.                         $userAppIds = array_merge($userAppIds, array_diff([$appId], $userAppIds));
  492.                         if (!isset($userTypesByAppIds[$appId])) {
  493.                             $userTypesByAppIds[$appId] = [];
  494.                         }
  495.                         $userTypesByAppIds[$appId] = array_merge($userTypesByAppIds[$appId], array_diff([UserConstants::USER_TYPE_SYSTEM], $userTypesByAppIds[$appId]));
  498.                         $centralUser->setUserAppIds(json_encode($userAppIds));
  500.                         $centralUser->setUserTypesByAppIds(json_encode($userTypesByAppIds));
  501.                         $em_goc->flush();
  504.                     }
  506.                     $accessList = $session->get('userAccessList', []);
  509.                     $d = array(
  510.                         'userType' => UserConstants::USER_TYPE_SYSTEM,
  511.                         'globalId' => $session->get(UserConstants::USER_ID, 0),
  512.                         'serverId' => $companyGroupServerId,
  513.                         'serverUrl' => $companyGroupServerAddress,
  514.                         'serverPort' => $companyGroupServerPort,
  515.                         'systemType' => '_ERP_',
  516.                         'companyId' => 1,
  517.                         'appId' => $appId,
  518.                         'companyLogoUrl' => $goc->getImage(),
  519.                         'companyName' => $goc->getName(),
  520.                         'authenticationStr' => $this->get('url_encryptor')->encrypt(json_encode(
  521.                                 array(
  522.                                     'globalId' => $session->get(UserConstants::USER_ID, 0),
  523.                                     'appId' => $appId,
  524.                                     'authenticate' => 1,
  525.                                     'userType' => UserConstants::USER_TYPE_SYSTEM
  526.                                 )
  527.                             )
  530.                         ),
  531.                         'userCompanyList' => [
  532.                         ]
  533.                     );
  534.                     $accessList[] = $d;
  536.                     $session->set('userAccessList', $accessList);
  537.                 }
  540.                 ///now update Server
  541.                 ///
  542.                 if ($goc->getInitiateFlag() == 2 || $goc->getInitiateFlag() == 1) //pending Initiation and paid
  543.                 {
  544.                     ///NOw pushing to server
  545.                     $output = '';
  547.                     $file = $this->container->getParameter('kernel.root_dir') . '/../web' . $goc->getImage(); //<-- Path could be relative
  549.                     if (file_exists($file)) {
  550. //                        $file = new \CURLFile($this->container->getParameter('kernel.root_dir') . '/../web/uploads/CompanyImage/' . $company->getImage()); //<-- Path could be relative
  551.                         $mime = mime_content_type($file);
  552.                         $info = pathinfo($file);
  553.                         $name = $info['basename'];
  554.                         if (strpos($mime, 'image') !== false) {
  555.                             $output = new \CURLFile($file, $mime, $name);
  556.                         }
  558.                     }
  561.                     $post_fields = array(
  564.                         'company_id' => 1,
  565.                         'goc_id' => $goc->getId(),
  566.                         'app_id' => $goc->getAppId(),
  567.                         'dark_vibrant' => '',
  568.                         'light_vibrant' => '',
  569.                         'vibrant' => '',
  570.                         'company_type' => $goc->getCompanyType(),
  571.                         'company_name' => $goc->getName(),
  572.                         'company_address' => $goc->getAddress(),
  573.                         'company_s_address' => $goc->getShippingAddress(),
  574.                         'company_b_address' => $goc->getBillingAddress(),
  575.                         'company_image' => $goc->getImage(),
  576.                         'company_motto' => $goc->getMotto(),
  577.                         'company_i_footer' => $goc->getInvoiceFooter(),
  578.                         'company_g_footer' => $goc->getGeneralFooter(),
  579.                         'company_tin' => $goc->getCompanyTin(),
  580.                         'company_bin' => $goc->getCompanyBin(),
  581.                         'company_reg' => $goc->getCompanyReg(),
  582.                         'company_tl' => $goc->getCompanyTl(),
  583.                         'usage_valid_upto_dt_str' => '@' . $usageValidUpto->format('U'),
  584. //                    'sms_enabled' => $goc->getSmsNotificationEnabled(),
  585. //                    'sms_settings' => $goc->getSmsSettings(),
  586.                         'companyGroupHash' => $goc->getCompanyGroupHash(),
  587.                         'number_of_admin_user' => $goc->getAdminUserAllowed(),
  588.                         'number_of_user' => $goc->getUserAllowed(),
  589.                         'db_name' => $goc->getDbName(),
  590.                         'db_user' => $goc->getDbUser(),
  591.                         'db_pass' => $goc->getDbPass(),
  592.                         'db_host' => $goc->getDbHost(),
  594.                         'companyGroupServerId' => $goc->getCompanyGroupServerId(),
  595.                         'companyGroupServerAddress' => $goc->getCompanyGroupServerAddress(),
  596.                         'companyGroupServerHash' => $goc->getCompanyGroupServerHash(),
  597.                         'companyGroupServerPort' => $goc->getCompanyGroupServerPort(),
  598.                         'file' => $output
  599.                     );
  602.                     $urlToCall = $goc->getCompanyGroupServerAddress() . '/UpdateCompanyGroupDataToRelevantServer';
  604.                     $curl = curl_init();
  605.                     curl_setopt_array($curl, array(
  606.                         CURLOPT_RETURNTRANSFER => 1,
  607.                         CURLOPT_POST => 1,
  608.                         CURLOPT_URL => $urlToCall,
  609.                         CURLOPT_CONNECTTIMEOUT => 10,
  610.                         CURLOPT_SSL_VERIFYPEER => false,
  611.                         CURLOPT_SSL_VERIFYHOST => false,
  612.                         CURLOPT_HTTPHEADER => array(),
  613.                         CURLOPT_POSTFIELDS => $post_fields
  614.                     ));
  616.                     $retData = curl_exec($curl);
  617.                     $errData = curl_error($curl);
  618.                     curl_close($curl);
  620.                     $goc->setInitiateFlag(1);// initiated
  622.                 }
  624.             }
  626.             return new JsonResponse(array(
  627.                 'user_access_data' => $d,
  628.                 'initiated' => 1
  629.             ));
  631.         } else {
  633.             $em_goc = $this->getDoctrine()->getManager('company_group');
  635.             $findByQuery = array(
  636. //                'active' => 1
  637.                 'appId' => $post->get('app_id')
  638.             );
  640.             $goc = $em_goc->getRepository("CompanyGroupBundle:CompanyGroup")
  641.                 ->findOneBy($findByQuery);
  643.             if (!$goc)
  644.                 $goc = new CompanyGroup();
  646.             $goc->setName($post->get('company_name'));
  647.             $goc->setCompanyGroupHash($post->get('companyGroupHash'));
  648.             $goc->setAppId($post->get('app_id'));
  649. //            $goc->setCompanyType($post->get('company_type'));
  650.             $goc->setAddress($post->get('address'));
  651. //            $goc->setDarkVibrant($post->get('dark_vibrant'));
  652. //            $goc->setLightVibrant($post->get('light_vibrant'));
  653. //            $goc->setVibrant($post->get('vibrant'));
  655.             $goc->setDbName($post->get('db_name'));
  656.             $goc->setDbUser($post->get('db_user'));
  657.             $goc->setDbPass($post->get('db_pass'));
  658.             $goc->setDbHost($post->get('db_host'));
  659.             $goc->setActive(1);
  660.             $goc->setShippingAddress($post->get('s_address'));
  661.             $goc->setBillingAddress($post->get('b_address'));
  662.             $goc->setMotto($post->get('motto'));
  663.             $goc->setInvoiceFooter($post->get('i_footer'));
  664.             $goc->setGeneralFooter($post->get('g_footer'));
  665.             $goc->setCompanyReg($post->get('company_reg', ''));
  666.             $goc->setCompanyTin($post->get('company_tin', ''));
  667.             $goc->setCompanyBin($post->get('company_bin', ''));
  668.             $goc->setCompanyTl($post->get('company_tl', ''));
  669.             $goc->setCompanyType($post->get('company_type', ''));
  671.             $goc->setCurrentSubscriptionPackageId($post->get('package', ''));
  672. //                $goc->setCu($post->get('package', ''));
  673.             $goc->setAdminUserAllowed($post->get('number_of_admin_user', ''));
  674.             $goc->setUserAllowed($post->get('number_of_user', ''));
  675.             $goc->setSubscriptionMonth($post->get('subscription_month', ''));
  676.             $goc->setCompanyDescription($post->get('company_description', ''));
  677.             $goc->setCompanyGroupServerId($post->get('companyGroupServerId', ''));
  678.             $goc->setCompanyGroupServerAddress($post->get('companyGroupServerAddress', ''));
  679.             $goc->setCompanyGroupServerPort($post->get('companyGroupServerPort', ''));
  680.             $goc->setCompanyGroupServerHash($post->get('companyGroupServerHash', ''));
  681. //            $goc->setSmsNotificationEnabled($post->get('sms_enabled'));
  682. //            $goc->setSmsSettings($post->get('sms_settings'));
  685.             foreach ($request->files as $uploadedFile) {
  686. //            if($uploadedFile->getImage())
  687. //                var_dump($uploadedFile->getFile());
  688. //                var_dump($uploadedFile);
  690.                 if ($uploadedFile != null) {
  692.                     $fileName = 'company_image' . $post->get('app_id') . '.' . $uploadedFile->guessExtension();
  693.                     $path = $fileName;
  694.                     $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/CompanyImage/';
  696.                     if ($goc->getImage() != null && $goc->getImage() != '' && file_exists($this->container->getParameter('kernel.root_dir') . '/../web' . $goc->getImage())) {
  698.                         unlink($this->container->getParameter('kernel.root_dir') . '/../web' . $goc->getImage());
  701.                     }
  703.                     if (!file_exists($upl_dir)) {
  704.                         mkdir($upl_dir, 0777, true);
  705.                     }
  706.                     $file = $uploadedFile->move($upl_dir, $path);
  707.                     if ($path != "")
  708.                         $goc->setImage('/uploads/CompanyImage/' . $path);
  709.                 }
  711.             }
  714.             $em_goc->persist($goc);
  715.             $em_goc->flush();
  718.             $connector = $this->container->get('application_connector');
  719.             $connector->resetConnection(
  720.                 'default',
  721.                 $goc->getDbName(),
  722.                 $goc->getDbUser(),
  723.                 $goc->getDbPass(),
  724.                 $goc->getDbHost(),
  725.                 $reset = true);
  726.             $em = $this->getDoctrine()->getManager();
  728.             $prePopulateFlag = 0;
  730.             if ($em->getConnection()->isConnected()) {
  732.             } else {
  733.                 $servername = $goc->getDbHost();
  734.                 $username = $goc->getDbUser();
  735.                 $password = $goc->getDbPass();
  737.                 // Create connection
  738.                 $conn = new \mysqli($servername, $username, $password);
  739.                 // Check connection
  740.                 if ($conn->connect_error) {
  741.                     die("Connection failed: " . $conn->connect_error);
  742.                 }
  744.                 // Create database
  745.                 $sql = "CREATE DATABASE " . $goc->getDbName();
  746.                 if ($conn->query($sql) === TRUE) {
  747.                     $prePopulateFlag = 1;
  748.                     //                                echo "Database created successfully";
  750.                 } else {
  751.                     //                                echo "Error creating database: " . $conn->error;
  752.                 }
  754.                 $conn->close();
  755.             }
  756.             $connector->resetConnection(
  757.                 'default',
  758.                 $goc->getDbName(),
  759.                 $goc->getDbUser(),
  760.                 $goc->getDbPass(),
  761.                 $goc->getDbHost(),
  762.                 $reset = true);
  763.             $em = $this->getDoctrine()->getManager();
  766.             $tool = new SchemaTool($em);
  768.             $classes = $em->getMetadataFactory()->getAllMetadata();
  769. //                    $tool->createSchema($classes);
  770.             $tool->updateSchema($classes);
  773.             if ($prePopulateFlag == 1) {
  774.                 System::prePopulateDatabase($em);
  775.             }
  778.             //now modify the company
  781.             $company = $em
  782.                 ->getRepository('ApplicationBundle:Company')
  783.                 ->findOneBy(
  784.                     array()
  785.                 );
  787.             if (!$company)
  788.                 $company = new Company();
  790.             $company->setImage($goc->getImage());
  791.             $company->setName($post->get('company_name'));
  792.             $company->setCompanyHash($post->get('company_short_code'));
  793.             $company->setAppId($post->get('app_id'));
  794.             $company->setActive(1);
  795.             $company->setAddress($post->get('address'));
  796.             $company->setShippingAddress($post->get('s_address'));
  797.             $company->setBillingAddress($post->get('b_address'));
  798.             $company->setMotto($post->get('motto'));
  799.             $company->setInvoiceFooter($post->get('i_footer'));
  800.             $company->setGeneralFooter($post->get('g_footer'));
  801.             $company->setCompanyReg($post->get('company_reg', ''));
  802.             $company->setCompanyTin($post->get('company_tin', ''));
  803.             $company->setCompanyBin($post->get('company_bin', ''));
  804.             $company->setCompanyTl($post->get('company_tl', ''));
  806.             $company->setCompanyType($post->get('company_type', ''));
  807.             $company->setAdminUserAllowed($post->get('number_of_admin_user', ''));
  808.             $company->setUserAllowed($post->get('number_of_user', ''));
  810. //            $company->setCompanyGroupServerId($post->get('companyGroupServerId', ''));
  811. //            $company->setCompanyGroupServerAddress($post->get('companyGroupServerAddress', ''));
  812. //            $company->setCompanyGroupServerPort($post->get('companyGroupServerPort', ''));
  813.             $company->setCompanyHash($post->get('companyGroupHash', ''));
  814. //            $company->setCompanyGroupServerHash($post->get('companyGroupServerHash', ''));
  817.             //new fields
  818.             if ($post->get('usage_valid_upto_dt_str', null) != null) {
  819.                 $usageValidUpto = new \DateTime($post->get('usage_valid_upto_dt_str', null));
  820.                 $company->setUsageValidUptoDate($usageValidUpto);
  821.                 $company->setUsageValidUptoDateTs($usageValidUpto->format('U'));
  822.             } else {
  823.                 $company->setUsageValidUptoDate(null);
  824.                 $company->setUsageValidUptoDateTs(0);
  825.             }
  827.             $em->persist($company);
  828.             $em->flush();
  830.             //initiate Admin
  831.             $userName = $request->request->get('username', $request->query->get('username', 'admin'));
  832.             $name = $request->request->get('name', $request->query->get('name', 'System Admin'));
  833.             $password = $request->request->get('password', $request->query->get('password', 'admin'));
  834.             $email = $request->request->get('email', $request->query->get('email', 'admin'));
  835.             $encodedPassword = $this->container->get('sha256salted_encoder')->encodePassword($password, $userName);
  836.             $companyIds = $request->request->get('companyIds', $request->query->get('companyIds', [1]));
  837.             $branchIds = $request->request->get('branchIds', $request->query->get('branchIds', []));
  838.             $appIds = $request->request->get('appIds', $request->query->get('appIds', [$post->get('app_id', 0)]));
  839.             $freshFlag = $request->request->get('fresh', $request->query->get('fresh', 0));
  842.             $message = $this->get('user_module')->addNewUser(
  843.                 $name,
  844.                 $email,
  845.                 $userName,
  846.                 $password,
  847.                 '',
  848.                 0,
  849.                 1,
  850.                 UserConstants::USER_TYPE_SYSTEM,
  851.                 $companyIds,
  852.                 $branchIds,
  853.                 '',
  854.                 "",
  855.                 1
  857.             );
  859.             $post_fields = array(
  861.                 'app_id' => $company->getAppId(),
  863.             );
  865.             return new JsonResponse($post_fields);
  868.         }
  871.     }
  874.     //update database schema
  875.     public function RunScheduledNotificationAction(Request $request)
  876.     {
  877.         $message = "";
  879.         $gocList = [];
  880.         $outputList = [];
  883.         $scheduler = $this->get('scheduler_service');
  884.         $connector = $this->get('application_connector');
  885.         $mail_module = $this->get('mail_module');
  887.         $gocEnabled = 1;
  888. //        if($this->getContainer()->hasParameter('entity_group_enabled'))
  889. //            $gocEnabled= $this->getContainer()->getParameter('entity_group_enabled');
  890. //        $to_print=$app_data->UpdatePostDatedTransaction();
  891. //        $output->writeln($to_print);
  893.         $to_print = $scheduler->checkAndSendScheduledNotification($connector, $gocEnabled, 0, $mail_module);
  894.         return new JsonResponse(array(
  895.             'to_print' => $to_print
  896.         ));
  897.     }
  899.     public function UpdateDatabaseSchemaAction(Request $request)
  900.     {
  901.         $dtHere = array(
  902.             'autoStartUpdateHit' => $request->query->get('autoStartUpdateHit', 0),
  903.             'page_title' => 'Server Actions',
  905.         );
  906.         if ($request->query->get('returnJson', 0) == 1) {
  907.             $message = "";
  909.             $gocList = [];
  910.             $outputList = [];
  911.             $configJson = array();
  913.             $configJson['appVersion'] = GeneralConstant::ENTITY_APP_VERSION;
  914.             $configJson['success'] = false;
  915.             $configJson['debugData'] = [];
  916.             $configJson['pending_doc_count'] = 0;
  918.             $configJson['initiateDataBaseFlagByGoc'] = array();
  919.             $configJson['motherLode'] = "http://erp.ourhoneybee.eu";
  920.             $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  921.             $thisMomentNow = new \DateTime();
  922.             $currTimeTs = $thisMomentNow->format('U');
  925.             $em = $this->getDoctrine()->getManager('company_group');
  926.             $em_goc = $this->getDoctrine()->getManager('company_group');
  927.             $em->getConnection()->connect();
  928.             $connected = $em->getConnection()->isConnected();
  930.             $serverId = $this->container->hasParameter('server_id') ? $this->container->getParameter('server_id') : '_ALL_';
  931.             if ($connected) {
  933.                 if ($request->query->get('prepareEntityGroup', 0) == 1) {
  934.                     $tool = new SchemaTool($em);
  936.                     $classes = $em->getMetadataFactory()->getAllMetadata();
  937. //                    $tool->createSchema($classes);
  938.                     $tool->updateSchema($classes);
  941.                     if ($request->query->get('fixEmptyPassword', 0) == 1) {
  943.                         $query = "SELECT * from  entity_applicant_details   where password not like '##UNLOCKED##'";
  945.                         $stmt = $em_goc->getConnection()->prepare($query);
  946.                         $stmt->execute();
  947.                         $results = $stmt->fetchAll();
  949.                         foreach ($results as $qpo) {
  951.                             if ($this->container->get('sha256salted_encoder')->isPasswordValid($qpo['password'], '', $qpo['salt'])
  952.                                 || $this->container->get('sha256salted_encoder')->isPasswordValid($qpo['password'], null, $qpo['salt'])
  953.                             ) {
  954.                                 $queryGG = "update entity_applicant_details set password ='##UNLOCKED##' and trigger_reset_password=1 where applicant_id=" . $qpo['applicant_id'];
  957.                                 $stmt = $em_goc->getConnection()->prepare($queryGG);
  958.                                 $stmt->execute();
  959.                                 $stmt->closeCursor();
  960.                             }
  962.                         }
  964.                     }
  966.                     if ($request->query->get('triggerReferScore', 0) == 1) {
  968.                         $query = "SELECT * from  entity_meeting_session   where booked_by_id !=0 and booked_by_id is not NULL and booked_by_id !=student_id";
  970.                         $stmt = $em_goc->getConnection()->prepare($query);
  971.                         $stmt->execute();
  972.                         $results = $stmt->fetchAll();
  974.                         foreach ($results as $qpo) {
  975.                             MiscActions::updateEntityPerformanceIndex($em_goc, [
  976.                                 'targetId' => $qpo['booked_by_id'],
  977.                                 'conversionData' => [
  978.                                     'count' => 1,
  979.                                     'score' => 10,
  980.                                 ]
  982.                             ],
  983.                                 new \DateTime($qpo['created_at']));
  985.                         }
  986.                         $query = "SELECT * from  entity_meeting_session   where booking_referer_id !=0 and booking_referer_id is not NULL and booking_referer_id !=student_id";
  988.                         $stmt = $em_goc->getConnection()->prepare($query);
  989.                         $stmt->execute();
  990.                         $results = $stmt->fetchAll();
  992.                         foreach ($results as $qpo) {
  993.                             MiscActions::updateEntityPerformanceIndex($em_goc, [
  994.                                 'targetId' => $qpo['booking_referer_id'],
  995.                                 'referData' => [
  996.                                     'count' => 1,
  997.                                     'score' => 10,
  998.                                 ]
  1000.                             ],
  1001.                                 new \DateTime($qpo['created_at'])
  1002.                             );
  1004.                         }
  1005.                     }
  1006.                     if ($request->query->get('refreshBuddyBeeSalt', 0) == 1) {
  1008.                         $query = "
  1009.                         UPDATE entity_applicant_details set temp_password=''  where 1;
  1010.                         UPDATE entity_applicant_details set salt=username  where username != '' and username is not NULL and (salt ='' or salt is  NULL);
  1011.                         UPDATE entity_applicant_details set salt='beesalt'  where (salt ='' or salt is  NULL) and (username ='' or username is  NULL);
  1012.                       ";
  1014.                         $stmt = $em_goc->getConnection()->prepare($query);
  1015.                         $stmt->execute();
  1016.                         $stmt->closeCursor();
  1018.                     }
  1019.                     if ($request->query->get('refreshLastSettingsUpdatedTs', 0) == 1) {
  1022.                         $query = "
  1023.               
  1024.                         UPDATE entity_user set last_settings_updated_ts=$currTimeTs  where 1;
  1025.                         UPDATE entity_applicant_details set last_settings_updated_ts=$currTimeTs  where 1;
  1027.                      
  1028.                       ";
  1030.                         $stmt = $em_goc->getConnection()->prepare($query);
  1031.                         $stmt->execute();
  1032.                         $stmt->closeCursor();
  1034.                     }
  1037.                     $get_kids_sql = "update `company_group` set `schema_update_pending_flag` =1 where 1;";
  1040.                     $stmt = $em_goc->getConnection()->prepare($get_kids_sql);
  1041.                     $stmt->execute();
  1042.                     $stmt->closeCursor();
  1045.                     $stmt = $em_goc->getConnection()->prepare("select count(id) id_count from company_group where active=1 and schema_update_pending_flag=1;");
  1046.                     $stmt->execute();
  1047.                     $check_here = $stmt->fetchAll();
  1049.                     $pending_id_count = 0;
  1051.                     if (isset($check_here[0]))
  1052.                         $pending_id_count = $check_here[0]['id_count'];
  1053.                     return new JsonResponse(array(
  1054.                         'pending_doc_count' => $pending_id_count,
  1055.                         'success' => true
  1057.                     ));
  1059.                 } else
  1060.                     if ($systemType != '_CENTRAL_') {
  1063.                         $stmt = $em_goc->getConnection()->prepare("select count(id) id_count from company_group where active=1 and schema_update_pending_flag=1;");
  1064.                         $stmt->execute();
  1065.                         $check_here = $stmt->fetchAll();
  1067.                         if (isset($check_here[0]))
  1068.                             $configJson['pending_doc_count'] = $check_here[0]['id_count'];
  1071. //                        if($serverId!='_ALL_')
  1072.                         $gocList = $this->getDoctrine()->getManager('company_group')
  1073.                             ->getRepository("CompanyGroupBundle:CompanyGroup")
  1074.                             ->findBy(
  1075.                                 array(
  1076.                                     'active' => 1,
  1077. //                                    'serverId' => 1,
  1078.                                     'schemaUpdatePendingFlag' => 1
  1079.                                 ), array(), 1
  1080.                             );
  1082.                     }
  1083.             }
  1086.             $gocDataList = [];
  1087.             $gocEntryObjectList = [];
  1088.             foreach ($gocList as $entry) {
  1089.                 $d = array(
  1090.                     'name' => $entry->getName(),
  1091.                     'image' => $entry->getImage(),
  1092.                     'shippingAddress' => $entry->getShippingAddress(),
  1093.                     'billingAddress' => $entry->getBillingAddress(),
  1094.                     'id' => $entry->getId(),
  1095.                     'dbName' => $entry->getDbName(),
  1096.                     'dbUser' => $entry->getDbUser(),
  1097.                     'dbPass' => $entry->getDbPass(),
  1098.                     'dbHost' => $entry->getDbHost(),
  1099.                     'appId' => $entry->getAppId(),
  1100.                     'companyRemaining' => $entry->getCompanyRemaining(),
  1101.                     'companyAllowed' => $entry->getCompanyAllowed(),
  1103.                 );
  1104.                 $gocDataList[$entry->getId()] = $d;
  1105.                 $gocEntryObjectList[$entry->getId()] = $entry;
  1106.             }
  1107.             $gocDbName = '';
  1108.             $gocDbUser = '';
  1109.             $gocDbPass = '';
  1110.             $gocDbHost = '';
  1111.             $gocId = 0;
  1114.             foreach ($gocDataList as $gocId => $entry) {
  1116.                 if (1) {
  1118.                     $connector = $this->container->get('application_connector');
  1119.                     $connector->resetConnection(
  1120.                         'default',
  1121.                         $gocDataList[$gocId]['dbName'],
  1122.                         $gocDataList[$gocId]['dbUser'],
  1123.                         $gocDataList[$gocId]['dbPass'],
  1124.                         $gocDataList[$gocId]['dbHost'],
  1125.                         $reset = true);
  1126.                     $em = $this->getDoctrine()->getManager();
  1128.                     $configJson['name'] = $entry['name'];
  1129.                     $configJson['image'] = $entry['image'];
  1130.                     $configJson['appId'] = $entry['appId'];
  1133.                     if ($request->query->get('delTable', '') != '') {
  1134.                         $get_kids_sql = "DROP TABLE " . $request->query->get('delTable') . "  ;";
  1135.                         $stmt = $em->getConnection()->prepare($get_kids_sql);
  1136.                         $stmt->execute();
  1137.                         $stmt->closeCursor();
  1138.                     }
  1141.                     $tool = new SchemaTool($em);
  1143.                     $classes = $em->getMetadataFactory()->getAllMetadata();
  1144. //                    $tool->createSchema($classes);
  1145.                     $tool->updateSchema($classes);
  1147.                     //temp
  1150.                     //temp end
  1153.                     if ($request->query->get('refreshLastSettingsUpdatedTs', 0) == 1) {
  1156.                         $query = "
  1157.                                     UPDATE sys_user set last_settings_updated_ts=$currTimeTs  where 1;
  1158.                                     UPDATE acc_clients set last_settings_updated_ts=$currTimeTs  where 1;
  1159.                                     UPDATE acc_suppliers set last_settings_updated_ts=$currTimeTs  where 1;
  1160.                      
  1161.                       ";
  1163.                         $stmt = $em->getConnection()->prepare($query);
  1164.                         $stmt->execute();
  1165.                         $stmt->closeCursor();
  1167.                     }
  1168.                     if ($request->query->get('encryptTrans', 0) == 1) {
  1169.                         MiscActions::encryptTrans($em, '_ALL_', 0);
  1172.                     }
  1173.                     if ($request->query->get('decryptTrans', 0) == 1) {
  1174.                         MiscActions::decryptTrans($em, '_ALL_', 0);
  1175.                     }
  1176.                     if ($request->query->get('createdByRefresh', 0) == 1) {
  1178.                         foreach (GeneralConstant::$Entity_list as $entity => $entityName) {
  1181.                             if (in_array($entity, [54]))
  1182.                                 continue;
  1183.                             if (!$em->getMetadataFactory()->isTransient('ApplicationBundle:' . $entityName)) {
  1185. //                                $className = ('\\ApplicationBundle\\Entity\\') . $entityName;
  1186. //                                $theEntity = new $className();
  1187. //                                $test_now=$theEntity->getCreatedUserId();
  1189.                                 //if its approval decode signature and add it to dbase and pass the id
  1190.                                 $sigId = null;
  1193.                                 $doc = null;
  1195.                                 $docList = $em->getRepository('ApplicationBundle:' . $entityName)
  1196.                                     ->findBy(
  1197.                                         array(//                                        GeneralConstant::$Entity_id_field_list[$entity] => $entity_id,
  1198.                                         )
  1199.                                     );
  1200.                                 foreach ($docList as $doc) {
  1202.                                     $notYetAdded = 1;
  1205.                                     foreach ([1, 2] as $approveRole) {
  1207.                                         $getIdfunc = GeneralConstant::$Entity_id_get_method_list[$entity];
  1208.                                         $entity_id = $doc->$getIdfunc();
  1209.                                         $loginId = null;
  1210.                                         $sigId = null;
  1211.                                         $user_data = [];
  1214.                                         if ($approveRole == 1) //created
  1215.                                         {
  1216.                                             $loginId = $doc->getCreatedLoginId();
  1217.                                             $notYetAdded = $doc->getCreatedUserId() == null ? 1 : 0;
  1218.                                             $sigId = $doc->getCreatedSigId();
  1219.                                             $user_data = Users::getUserInfoByLoginId($em, $loginId);
  1222.                                             if (isset($user_data['id'])) {
  1224.                                                 $doc->setCreatedUserId($user_data['id']);
  1225.                                                 $doc->setCreatedSigId(null);
  1226.                                             }
  1227.                                             $em->flush();
  1229.                                         }
  1230.                                         if ($approveRole == 2) //edited
  1231.                                         {
  1232.                                             $loginId = $doc->getEditedLoginId();
  1233.                                             $sigId = $doc->getEditedSigId();
  1234.                                             $notYetAdded = $doc->getEditedUserId() == null ? 1 : 0;
  1235.                                             $user_data = Users::getUserInfoByLoginId($em, $loginId);
  1237.                                             $doc->setEditedSigId($sigId);
  1238.                                             if (isset($user_data['id'])) {
  1239.                                                 $doc->setEditedUserId($user_data['id']);
  1240.                                                 $doc->setEditedSigId(null);
  1242.                                                 $doc->setLastModifiedDate(new \DateTime());
  1244.                                             }
  1245.                                             $em->flush();
  1247.                                         }
  1250.                                         if (isset($user_data['id']) && $notYetAdded == 1) {
  1253.                                             $new = new Approval();
  1254.                                             $new->setEntity($entity);
  1255.                                             $new->setEntityId($entity_id);
  1256.                                             $new->setPositionId(null);
  1257.                                             $new->setSequence(0);
  1258.                                             $new->setSkipPrintFlag(0);
  1259.                                             $new->setUserAssignType(1);
  1260.                                             $new->setDocumentHash($doc->getDocumentHash());
  1261.                                             //            $new->setUserIds($value->getUserId()); //<-----
  1262.                                             $new->setRoleType($approveRole);
  1263.                                             $new->setRequired(0);
  1264.                                             $new->setSuccession(0);
  1265.                                             $new->setAction(1); //pending status
  1266.                                             $new->setLoginId($loginId); //pending status
  1267.                                             $new->setCurrent(GeneralConstant::CURRENTLY_NON_PENDING_APPROVAL);
  1268.                                             $new->setSuccessionTimeout(0);
  1269.                                             $new->setSigId($sigId);
  1271.                                             $new->setNote('');
  1274.                                             $new->setUserIds(json_encode([$user_data['id']])); //<-----
  1277.                                             $em->persist($new);
  1278.                                             $em->flush();
  1279.                                         }
  1280.                                     }
  1281.                                 }
  1282.                             }
  1283.                         }
  1286.                     }
  1288.                     if ($request->query->get('rectifyOldBoq', 0) == 1) {
  1290.                         $boqs = $em
  1291.                             ->getRepository('ApplicationBundle:ProjectBoq')
  1292.                             ->findby(array(//                                    'projectId'=>$projectId
  1293.                             ));
  1294.                         foreach ($boqs as $boq) {
  1296. //
  1297. //                            //now the data
  1298. //                            $data = [];
  1299. //                            $newData = [];
  1300. //                            if ($boq)
  1301. //                                $data = json_decode($boq->getData(), true);
  1302. //                            if ($data == null)
  1303. //                                $data = [];
  1304. //                            $defValuesProduct = array(
  1305. //                                'product_note' => '',
  1306. //                                'product_alias' => '',
  1307. //                                'is_foreign_item' => 0,
  1308. //                                'product_segmentIndex' => 0,
  1309. //                                'product_currency_id' => 0,
  1310. //                                'product_currency_text' => '',
  1311. //                                'product_currency_multiply_rate' => 1,
  1312. //                                'product_scope' => 1,
  1313. //                                'product_scopeHolderId' => 0,
  1314. //                                'product_scopeHolderName' => '',
  1315. //                                'product_scopeDescription' => '',
  1316. //                            );
  1317. //                            $defValuesService = array(
  1318. //                                'service_note' => '',
  1319. //                                'service_alias' => '',
  1320. //                                'is_foreign_service' => 0,
  1321. //                                'service_segmentIndex' => 0,
  1322. //                                'service_currency_id' => 0,
  1323. //                                'service_currency_text' => '',
  1324. //                                'service_currency_multiply_rate' => 1,
  1325. //                                'service_scope' => 1,
  1326. //                                'service_scopeHolderId' => 0,
  1327. //                                'service_scopeHolderName' => '',
  1328. //                                'service_scopeDescription' => '',
  1329. //                            );
  1330. //
  1331. //
  1332. //                            if (!empty($data)) {
  1333. //                                $last_key = array_key_last($data);
  1334. ////                                if (isset($data[$last_key]['Products']['product_scope']))
  1335. ////                                    continue;
  1336. ////                                    if (count($data[$last_key]['Products']['products'])==count($data[$last_key]['Products']['is_foreign_item']) )
  1337. //
  1338. //
  1339. //                                $kho = 0;
  1340. //                                $dt_poka = $data[0];
  1341. //                                foreach ($data as $kho => $dt_poka) {
  1342. //
  1343. //
  1344. //                                    if (isset($dt_poka['Products']['products']))
  1345. //                                        foreach ($defValuesProduct as $gopaa => $boka) {
  1346. //                                            if (!isset($dt_poka['Products'][$gopaa]))
  1347. //                                                $dt_poka['Products'][$gopaa] = array_fill(0, count($dt_poka['Products']['products']), $boka);
  1348. //                                            else if ($dt_poka['Products'][$gopaa] == null)
  1349. //                                                $dt_poka['Products'][$gopaa] = array_fill(0, count($dt_poka['Products']['products']), $boka);
  1350. //
  1351. //
  1352. //                                        }
  1353. //                                    if (isset($dt_poka['Services']['services']))
  1354. //                                        foreach ($defValuesService as $gopaa => $boka) {
  1355. //                                            if (!isset($dt_poka['Services'][$gopaa]))
  1356. //                                                $dt_poka['Services'][$gopaa] = array_fill(0, count($dt_poka['Services']['services']), $boka);
  1357. //                                            else if ($dt_poka['Services'][$gopaa] == null)
  1358. //                                                $dt_poka['Services'][$gopaa] = array_fill(0, count($dt_poka['Services']['services']), $boka);
  1359. //
  1360. //                                        }
  1361. //
  1362. //                                    if (!isset($dt_poka['serviceSegmentData']))
  1363. //                                        $dt_poka['serviceSegmentData'] = [
  1364. //                                            array(
  1365. //                                                "title" => "General Services",
  1366. //                                                "index" => 0,
  1367. //                                            )
  1368. //                                        ];
  1369. //                                    else if ($dt_poka['serviceSegmentData'] == null || empty($dt_poka['serviceSegmentData']))
  1370. //                                        $dt_poka['serviceSegmentData'] = [
  1371. //                                            array(
  1372. //                                                "title" => "General Services",
  1373. //                                                "index" => 0,
  1374. //                                            )
  1375. //                                        ];
  1376. //
  1377. //                                    if (!isset($dt_poka['productSegmentData']))
  1378. //                                        $dt_poka['productSegmentData'] = [
  1379. //                                            array(
  1380. //                                                "title" => "General Items",
  1381. //                                                "index" => 0,
  1382. //                                            )
  1383. //                                        ];
  1384. //                                    else if ($dt_poka['productSegmentData'] == null || empty($dt_poka['productSegmentData']))
  1385. //                                        $dt_poka['productSegmentData'] = [
  1386. //                                            array(
  1387. //                                                "title" => "General Items",
  1388. //                                                "index" => 0,
  1389. //                                            )
  1390. //                                        ];
  1391. //
  1392. //
  1393. //                                    $newData[$kho] = $dt_poka;
  1394. //                                }
  1395. //
  1396. //
  1397. //                                $boq->setData(json_encode($newData));
  1398. //                                $em->flush();
  1399. //
  1400. //
  1401. //                            }
  1403.                             $theProj = $em->getRepository('ApplicationBundle:Project')
  1404.                                 ->findOneBy(
  1405.                                     array(
  1406.                                         'projectId' => $boq->getProjectId()
  1407.                                     )
  1408.                                 );
  1409.                             if ($theProj)
  1410.                                 $theProj->setDocumentDataId($boq->getDocumentDataId());
  1411.                             $em->flush();
  1412.                         }
  1415.                     }
  1416.                     if ($request->query->get('oldBoqToNewSystem', 0) == 1) {
  1418.                         $entitiesGG = [
  1419.                             array_flip(GeneralConstant::$Entity_list)['ProjectBoq'],
  1420.                             array_flip(GeneralConstant::$Entity_list)['ProjectMaterial'],
  1421.                             array_flip(GeneralConstant::$Entity_list)['SalesProposal'],
  1422.                             array_flip(GeneralConstant::$Entity_list)['SalesLead'],
  1423.                             array_flip(GeneralConstant::$Entity_list)['ProjectOffer'],
  1424.                             array_flip(GeneralConstant::$Entity_list)['ProjectProposal'],
  1426.                         ];
  1428.                         foreach ($entitiesGG as $ent) {
  1429.                             $entityNameHere = GeneralConstant::$Entity_list[$ent];
  1430.                             $the_actual_docs = $em->getRepository('ApplicationBundle:' . GeneralConstant::$Entity_list[$ent])
  1431.                                 ->findBy(
  1432.                                     array(//                                        GeneralConstant::$Entity_id_field_list[$ent] => $entity_id,
  1433.                                     )
  1434.                                 );
  1435.                             foreach ($the_actual_docs as $the_actual_doc) {
  1438.                                 //now the data
  1439.                                 //first find the docData if available
  1441.                                 $theDocData = null;
  1442.                                 if ($entityNameHere == 'SalesProposal' || $entityNameHere == 'SalesLead') {
  1443.                                     $theDocData = $em->getRepository('ApplicationBundle:DocumentData')
  1444.                                         ->findOneBy(
  1445.                                             array(
  1446.                                                 'id' => $the_actual_doc->getDocumentDataId()
  1447.                                             )
  1448.                                         );
  1450.                                     if (!$theDocData)
  1451.                                         if ($the_actual_doc->getSalesProposalId() != null && $the_actual_doc->getSalesProposalId() != 0)
  1452.                                             $theDocData = $em->getRepository('ApplicationBundle:DocumentData')
  1453.                                                 ->findOneBy(
  1454.                                                     array(
  1455.                                                         'proposalId' => $the_actual_doc->getSalesProposalId()
  1456.                                                     )
  1457.                                                 );
  1459.                                     if (!$theDocData)
  1460.                                         if ($the_actual_doc->getLeadId() != null && $the_actual_doc->getLeadId() != 0)
  1461.                                             $theDocData = $em->getRepository('ApplicationBundle:DocumentData')
  1462.                                                 ->findOneBy(
  1463.                                                     array(
  1464.                                                         'leadId' => $the_actual_doc->getLeadId()
  1465.                                                     )
  1466.                                                 );
  1468.                                     if (!$theDocData)
  1469.                                         if ($the_actual_doc->getProjectId() != null && $the_actual_doc->getProjectId() != 0)
  1470.                                             $theDocData = $em->getRepository('ApplicationBundle:DocumentData')
  1471.                                                 ->findOneBy(
  1472.                                                     array(
  1473.                                                         'projectId' => $the_actual_doc->getProjectId()
  1474.                                                     )
  1475.                                                 );
  1477.                                     if (!$theDocData) {
  1478.                                         $theDocData = new DocumentData();
  1480.                                         if ($entityNameHere == 'SalesProposal')
  1481.                                             $theDocData->setProposalId($the_actual_doc->getSalesProposalId());
  1483.                                         if ($entityNameHere == 'SalesLead')
  1484.                                             $theDocData->setLeadId($the_actual_doc->getLeadId());
  1485.                                     }
  1487.                                 } else {
  1488.                                     $theDocData = $em->getRepository('ApplicationBundle:DocumentData')
  1489.                                         ->findOneBy(
  1490.                                             array(
  1491.                                                 'id' => $the_actual_doc->getDocumentDataId()
  1492.                                             )
  1493.                                         );
  1495.                                     if (!$theDocData)
  1496.                                         $theDocData = $em->getRepository('ApplicationBundle:DocumentData')
  1497.                                             ->findOneBy(
  1498.                                                 array(
  1499.                                                     'projectId' => $the_actual_doc->getProjectId()
  1500.                                                 )
  1501.                                             );
  1503.                                     if (!$theDocData) {
  1504.                                         $theDocData = new DocumentData();
  1506.                                         $theDocData->setProjectId($the_actual_doc->getProjectId());
  1507.                                     }
  1510.                                 }
  1513.                                 if ($entityNameHere == 'ProjectBoq' || $entityNameHere == 'SalesLead' || $entityNameHere == 'SalesProposal') {
  1515.                                     $data = [];
  1516.                                     $newData = [];
  1518.                                     $data = json_decode($the_actual_doc->getData(), true);
  1520.                                     if ($data == null)
  1521.                                         $data = [];
  1524.                                     if (!empty($data)) {
  1525.                                         $last_key = array_key_last($data);
  1527.                                         $lastIndex = 0;
  1529.                                         foreach ($data as $kho => $dt_poka) {
  1530.                                             $cur_date = new \DateTime();
  1531.                                             $lead_date = new \DateTime(isset($dt_poka['lead_date']) ? $dt_poka['lead_date'] : '');
  1532.                                             $newSingleSet = array(
  1533.                                                 'refPoNumber' => isset($dt_poka['refPoNumber']) ? $dt_poka['refPoNumber'] : '',
  1534.                                                 'segmentData' => isset($dt_poka['segmentData']) ? $dt_poka['segmentData'] : [],
  1535.                                                 'proposal_title' => isset($dt_poka['proposal_title']) ? $dt_poka['proposal_title'] : '',
  1536.                                                 'to_position' => isset($dt_poka['to_position']) ? $dt_poka['to_position'] : '',
  1537.                                                 'system_subCategory' => isset($dt_poka['system_subCategory']) ? $dt_poka['system_subCategory'] : '',
  1538.                                                 'system_size' => isset($dt_poka['system_size']) ? $dt_poka['system_size'] : '',
  1539.                                                 'system_unit' => isset($dt_poka['system_unit']) ? $dt_poka['system_unit'] : '',
  1540.                                                 'system_price' => isset($dt_poka['system_price']) ? $dt_poka['system_price'] : '',
  1541.                                                 'msaTotal' => isset($dt_poka['msaTotal']) ? $dt_poka['msaTotal'] : 0,
  1542.                                                 'totalProjectValue' => isset($dt_poka['totalProjectValue']) ? $dt_poka['totalProjectValue'] : 0,
  1544.                                                 'cl_subject' => isset($dt_poka['cl_subject']) ? $dt_poka['cl_subject'] : '',
  1545.                                                 'cl_body' => isset($dt_poka['cl_body']) ? $dt_poka['cl_body'] : '',
  1547.                                                 'vatPercentage' => isset($dt_poka['vatPercentage']) ? $dt_poka['vatPercentage'] : '',
  1548.                                                 'aitPercentage' => isset($dt_poka['aitPercentage']) ? $dt_poka['aitPercentage'] : '',
  1550.                                                 'proposalSalesValue' => isset($dt_poka['proposalSalesValue']) ? $dt_poka['proposalSalesValue'] : '',
  1551.                                                 'combined_proposal_item_name' => isset($dt_poka['combined_proposal_item_name']) ? $dt_poka['combined_proposal_item_name'] : '',
  1552.                                                 'combined_proposal_details_price' => isset($dt_poka['combined_proposal_details_price']) ? $dt_poka['combined_proposal_details_price'] : '',
  1554.                                                 'check_boq' => isset($dt_poka['check_boq']) ? $dt_poka['check_boq'] : 0,
  1555.                                                 'check_boq_individual_price' => isset($dt_poka['check_boq_individual_price']) ? $dt_poka['check_boq_individual_price'] : 0,
  1556.                                                 'check_show_combined_only' => isset($dt_poka['check_show_combined_only']) ? $dt_poka['check_show_combined_only'] : 0,
  1557.                                                 'check_override_markup' => isset($dt_poka['check_show_combined_only']) ? $dt_poka['check_show_combined_only'] : 0,
  1559.                                                 'clientId' => isset($dt_poka['client_id']) ? $dt_poka['client_id'] : 0,
  1560.                                                 'salesPersonId' => isset($dt_poka['salesPersonID']) ? $dt_poka['salesPersonID'] : 0,
  1561.                                                 'clientName' => isset($dt_poka['clientName']) ? $dt_poka['clientName'] : '',
  1562.                                                 'ClientContactPerson' => isset($dt_poka['ClientContactPerson']) ? $dt_poka['ClientContactPerson'] : '',
  1563.                                                 'ClientContactNumber' => isset($dt_poka['ClientContactNumber']) ? $dt_poka['ClientContactNumber'] : '',
  1564.                                                 'ClientDeliveryAddress' => isset($dt_poka['ClientDeliveryAddress']) ? $dt_poka['ClientDeliveryAddress'] : '',
  1565.                                                 'ClientBillingAddress' => isset($dt_poka['ClientBillingAddress']) ? $dt_poka['ClientBillingAddress'] : '',
  1566.                                                 'leadDate' => $lead_date->format('Y-m-d'),
  1567.                                                 'date' => $cur_date->format('Y-m-d'),
  1570.                                             );
  1573.                                             $newSegmentData = array();
  1574.                                             $oldSegmentSystem = 0;
  1575.                                             if (isset($dt_poka['productSegmentData']) || isset($dt_poka['serviceSegmentData']))
  1576.                                                 $oldSegmentSystem = 1;
  1578.                                             if ($oldSegmentSystem == 1) {
  1579.                                                 //unify the ids of segmnent. services will start from 1000+service segmentId for unification
  1580.                                                 if (isset($dt_poka['productSegmentData']))
  1582.                                                     foreach ($dt_poka['productSegmentData'] as $supu => $gupu) {
  1583.                                                         $newModSeg = $gupu;
  1585.                                                         $newModSeg['index'] = $gupu['index'];
  1586.                                                         $newModSeg['title'] = isset($gupu['title']) ? $gupu['title'] : 'Items';
  1587.                                                         $newModSeg['scfc'] = isset($gupu['scfc']) ? $gupu['scfc'] : 0;
  1588.                                                         $newModSeg['uomCust'] = isset($gupu['uomCust']) ? $gupu['uomCust'] : '';
  1589.                                                         $newModSeg['unitCust'] = isset($gupu['unitCust']) ? $gupu['unitCust'] : '';
  1590.                                                         $newModSeg['priceCust'] = isset($gupu['priceCust']) ? $gupu['priceCust'] : '';
  1591.                                                         $newModSeg['currCust'] = isset($gupu['currCust']) ? $gupu['currCust'] : '';
  1592.                                                         $newModSeg['descCust'] = isset($gupu['descCust']) ? $gupu['descCust'] : '';
  1593.                                                         $newModSeg['scope'] = isset($gupu['scope']) ? $gupu['scope'] : 0;
  1594.                                                         $newModSeg['scopeId'] = isset($gupu['scopeId']) ? $gupu['scopeId'] : 0;
  1595.                                                         $newModSeg['scopeName'] = isset($gupu['scopeName']) ? $gupu['scopeName'] : '';
  1596.                                                         $newModSeg['scopeDescription'] = isset($gupu['scopeDescription']) ? $gupu['scopeDescription'] : '';
  1599.                                                         $newSegmentData[] = $newModSeg;
  1600.                                                     }
  1603.                                                 if (isset($dt_poka['serviceSegmentData']))
  1604.                                                     if ($dt_poka['serviceSegmentData'] == null || empty($dt_poka['serviceSegmentData']))
  1605.                                                         foreach ($dt_poka['serviceSegmentData'] as $supu => $gupu) {
  1607.                                                             if ($gupu['index'] == 'undefined') $gupu['index'] = 0;
  1608.                                                             if (!is_numeric($gupu['index'])) $gupu['index'] = 0;
  1609.                                                             $newModSeg = $gupu;
  1610.                                                             $newModSeg['index'] = 1000 + 1 * $gupu['index'];
  1611.                                                             $newModSeg['title'] = isset($gupu['title']) ? $gupu['title'] : 'Services';
  1612.                                                             $newModSeg['scfc'] = isset($gupu['scfc']) ? $gupu['scfc'] : 0;
  1613.                                                             $newModSeg['uomCust'] = isset($gupu['uomCust']) ? $gupu['uomCust'] : '';
  1614.                                                             $newModSeg['unitCust'] = isset($gupu['unitCust']) ? $gupu['unitCust'] : '';
  1615.                                                             $newModSeg['priceCust'] = isset($gupu['priceCust']) ? $gupu['priceCust'] : '';
  1616.                                                             $newModSeg['currCust'] = isset($gupu['currCust']) ? $gupu['currCust'] : '';
  1617.                                                             $newModSeg['descCust'] = isset($gupu['descCust']) ? $gupu['descCust'] : '';
  1618.                                                             $newModSeg['scope'] = isset($gupu['scope']) ? $gupu['scope'] : 0;
  1619.                                                             $newModSeg['scopeId'] = isset($gupu['scopeId']) ? $gupu['scopeId'] : 0;
  1620.                                                             $newModSeg['scopeName'] = isset($gupu['scopeName']) ? $gupu['scopeName'] : '';
  1621.                                                             $newModSeg['scopeDescription'] = isset($gupu['scopeDescription']) ? $gupu['scopeDescription'] : '';
  1622.                                                             $newSegmentData[] = $newModSeg;
  1623.                                                         }
  1626.                                                 $newSingleSet['itemSegmentData'] = $newSegmentData;
  1629.                                             }
  1631.                                             $lastSequenceBySegment = array();
  1634.                                             //now modify Services or products
  1635.                                             $oldProductSystem = 0;
  1636.                                             if (!isset($dt_poka['rowData']))
  1637.                                                 $dt_poka['rowData'] = array();
  1640.                                             if (isset($dt_poka['Products']) || isset($dt_poka['Services']) || isset($dt_poka['ArCosts'])) {
  1642.                                                 $oldProductSystem = 1;
  1643.                                             }
  1645.                                             if ($oldProductSystem == 1) {
  1646.                                                 $theDt = array(
  1647.                                                     'products' => [],
  1648.                                                     'services' => [],
  1649.                                                     'ar_heads' => [],
  1650.                                                 );
  1651.                                                 if (isset($dt_poka['Products']))
  1652.                                                     $theDt = $dt_poka['Products'];
  1653.                                                 if (isset($theDt['products']))
  1654.                                                     foreach ($theDt['products'] as $f => $pid) {
  1655.                                                         $unit = isset($theDt['product_units'][$f]) ? $theDt['product_units'][$f] : 0;
  1656.                                                         $indexForThis = isset($theDt['index'][$f]) ? $theDt['index'][$f] : -1;
  1657.                                                         if ($indexForThis == -1) {
  1658.                                                             $indexForThis = $lastIndex;
  1659.                                                             $lastIndex++;
  1660.                                                         }
  1663.                                                         $unitPrice = isset($theDt['product_unit_price'][$f]) ? $theDt['product_unit_price'][$f] : 0;
  1664.                                                         if ($unit == '') $unit = 0;
  1665.                                                         if ($unitPrice == '') $unitPrice = 0;
  1666.                                                         $totalPrice = $unit * $unitPrice;
  1667.                                                         $segmentIndex = isset($theDt['product_segmentIndex'][$f]) ? $theDt['product_segmentIndex'][$f] : 0;
  1668.                                                         $sequence = isset($theDt['product_segmentIndex'][$f]) ? $theDt['product_segmentIndex'][$f] : '_UNSET_';
  1670.                                                         if (!isset($lastSequenceBySegment[$segmentIndex]))
  1671.                                                             $lastSequenceBySegment[$segmentIndex] = -1;
  1673.                                                         if ($sequence == '_UNSET_')
  1674.                                                             $sequence = $lastSequenceBySegment[$segmentIndex] + 1;
  1675.                                                         else if ($sequence == $lastSequenceBySegment[$segmentIndex])
  1676.                                                             $sequence = $lastSequenceBySegment[$segmentIndex] + 1;
  1678.                                                         $lastSequenceBySegment[$segmentIndex] = $sequence;
  1680.                                                         $unitSalesPrice = isset($theDt['product_unit_sales_price'][$f]) ? $theDt['product_unit_sales_price'][$f] : $unitPrice;
  1682.                                                         if ($unitSalesPrice == '') $unitSalesPrice = 0;
  1683.                                                         $totalSalesPrice = $unit * $unitSalesPrice;
  1684.                                                         $marginAmount = isset($theDt['product_ma'][$f]) ? $theDt['product_ma'][$f] : ($unitSalesPrice - $unitPrice);
  1685.                                                         $marginRate = isset($theDt['product_ma'][$f]) ? $theDt['product_ma'][$f] : ($unitPrice == 0 ? 0 : (100 * $marginAmount / $unitPrice));
  1687.                                                         $discountAmount = isset($theDt['product_dr'][$f]) ? $theDt['product_dr'][$f] : 0;
  1688.                                                         $discountRate = isset($theDt['product_da'][$f]) ? $theDt['product_da'][$f] : ($totalSalesPrice == 0 ? 0 : (100 * $discountAmount / $totalSalesPrice));
  1689.                                                         $discountedAmount = $totalSalesPrice - $discountAmount;
  1692.                                                         $taxRate = isset($theDt['product_tax_percentage'][$f]) ? $theDt['product_tax_percentage'][$f] : ($unitPrice == 0 ? 0 : (100 * $discountAmount / $unitPrice));
  1693.                                                         $taxAmount = isset($theDt['product_tax_amount'][$f]) ? $theDt['product_tax_amount'][$f] : 0;
  1695.                                                         $finalAmount = $discountedAmount + $taxAmount;
  1698.                                                         $row = array(
  1699.                                                             'type' => 1,//1:product 2=service 4=tools 5:text 6: expense against head
  1700.                                                             'id' => $pid,
  1701.                                                             'index' => $indexForThis,
  1702.                                                             'isForeign' => isset($theDt['is_foreign_item'][$f]) ? $theDt['is_foreign_item'][$f] : 0,
  1703.                                                             'sequence' => $sequence,
  1704.                                                             'segmentIndex' => $segmentIndex,
  1705.                                                             'soItemId' => isset($theDt['product_soItemId'][$f]) ? $theDt['product_soItemId'][$f] : 0,
  1706.                                                             'soItemDelivered' => isset($theDt['product_soItemDelivered'][$f]) ? $theDt['product_soItemDelivered'][$f] : 0,
  1707.                                                             'soItemFound' => isset($theDt['product_soItemFound'][$f]) ? $theDt['product_soItemFound'][$f] : 0,
  1709.                                                             'alias' => isset($theDt['product_alias'][$f]) ? $theDt['product_alias'][$f] : '',
  1710.                                                             'name' => isset($theDt['product_name'][$f]) ? $theDt['product_name'][$f] : '',
  1711.                                                             'note' => isset($theDt['product_note'][$f]) ? $theDt['product_note'][$f] : '',
  1713.                                                             'fdm' => isset($theDt['product_fdm'][$f]) ? $theDt['product_fdm'][$f] : null,
  1714.                                                             'unit' => isset($theDt['product_units'][$f]) ? $theDt['product_units'][$f] : 0,
  1715.                                                             'unitTypeId' => isset($theDt['product_unit_type'][$f]) ? $theDt['product_unit_type'][$f] : 0,
  1717.                                                             'unitPrice' => $unitPrice,
  1718.                                                             'totalPrice' => $totalPrice,
  1719.                                                             'unitSalesPrice' => $unitSalesPrice,
  1720.                                                             'totalSalesPrice' => $totalSalesPrice,
  1722.                                                             'marginRate' => $marginRate,
  1723.                                                             'marginAmount' => $marginAmount,
  1725.                                                             'discountRate' => $discountRate,
  1726.                                                             'discountAmount' => $discountAmount,
  1727.                                                             'discountedAmount' => $discountedAmount,
  1728.                                                             'taxRate' => $taxRate,
  1729.                                                             'taxAmount' => $taxAmount,
  1730.                                                             'finalAmount' => $finalAmount,
  1732.                                                             'recurring' => isset($theDt['product_recurring'][$f]) ? $theDt['product_recurring'][$f] : 0,
  1734.                                                             'currency' => isset($theDt['product_currency_id'][$f]) ? $theDt['product_currency_id'][$f] : 0,
  1735.                                                             'currencyText' => isset($theDt['product_currency_text'][$f]) ? $theDt['product_currency_text'][$f] : '',
  1736.                                                             'currencyMultiplyRate' => isset($theDt['product_currency_multiply_rate'][$f]) ? $theDt['product_currency_multiply_rate'][$f] : 1,
  1738.                                                             'incoterm' => isset($theDt['incoterm'][$f]) ? $theDt['incoterm'][$f] : '',
  1740.                                                             'taxId' => isset($theDt['product_tax_config_id'][$f]) ? $theDt['product_tax_config_id'][$f] : 0,
  1741.                                                             'taxName' => isset($theDt['product_tax_config_text'][$f]) ? $theDt['product_tax_config_text'][$f] : '',
  1744.                                                             'dependencyOnIndex' => isset($theDt['product_dependency_of_index'][$f]) ? $theDt['product_dependency_of_index'][$f] : 0,
  1745.                                                             'dependencyOnPid' => isset($theDt['product_dependency_of_product_id'][$f]) ? $theDt['product_dependency_of_product_id'][$f] : 0,
  1746.                                                             'dependencyOnSid' => isset($theDt['product_dependency_of_service_id'][$f]) ? $theDt['product_dependency_of_service_id'][$f] : 0,
  1747.                                                             'dependencyOnSegment' => isset($theDt['product_dependency_of_product_index'][$f]) ? $theDt['product_dependency_of_product_index'][$f] : 0,
  1749.                                                             'warranty' => isset($theDt['product_delivery_schedule'][$f]) ? $theDt['product_delivery_schedule'][$f] : 0,
  1750.                                                             'origin' => isset($theDt['product_origin'][$f]) ? $theDt['product_origin'][$f] : 0,
  1751.                                                             'origins' => isset($theDt['product_origin'][$f]) ? [$theDt['product_origin'][$f]] : [],
  1753.                                                             'scope' => isset($theDt['product_scope'][$f]) ? $theDt['product_scope'][$f] : 0,
  1754.                                                             'scopeId' => isset($theDt['product_scopeHolderId'][$f]) ? [$theDt['product_scopeHolderId'][$f]] : 0,
  1755.                                                             'scopeName' => isset($theDt['product_scopeHolderName'][$f]) ? [$theDt['product_scopeHolderName'][$f]] : '',
  1756.                                                             'scopeDescription' => isset($theDt['product_scopeDescription'][$f]) ? [$theDt['product_scopeDescription'][$f]] : '',
  1758.                                                             'deliverySchedule' => isset($theDt['product_delivery_schedule'][$f]) ? $theDt['product_delivery_schedule'][$f] : [],
  1759.                                                             'deliveryPorts' => isset($theDt['product_delivery_ports'][$f]) ? $theDt['product_delivery_ports'][$f] : [],
  1760.                                                             'billingSchedule' => isset($theDt['product_billing_schedule'][$f]) ? $theDt['product_billing_schedule'][$f] : [],
  1762.                                                             'referenceNo' => isset($theDt['product_reference_price'][$f]) ? $theDt['product_reference_price'][$f] : '',
  1763.                                                             'referenceFiles' => isset($theDt['product_reference_price_file'][$f]) ? $theDt['product_reference_price_file'][$f] : '',
  1766.                                                         );
  1768.                                                         $dt_poka['rowData'][] = $row;
  1770.                                                     }
  1772.                                                 //now the services
  1773.                                                 $theDt = array(
  1774.                                                     'products' => [],
  1775.                                                     'services' => [],
  1776.                                                     'ar_heads' => [],
  1777.                                                 );
  1778.                                                 if (isset($dt_poka['Services']))
  1779.                                                     $theDt = $dt_poka['Services'];
  1781.                                                 if (isset($theDt['services']))
  1782.                                                     foreach ($theDt['services'] as $f => $pid) {
  1783.                                                         $unit = isset($theDt['service_units'][$f]) ? $theDt['service_units'][$f] : 0;
  1784.                                                         $indexForThis = isset($theDt['index'][$f]) ? $theDt['index'][$f] : -1;
  1785.                                                         if ($indexForThis == -1) {
  1786.                                                             $indexForThis = $lastIndex;
  1787.                                                             $lastIndex++;
  1788.                                                         }
  1789.                                                         $unitPrice = isset($theDt['service_unit_price'][$f]) ? $theDt['service_unit_price'][$f] : 0;
  1790.                                                         $totalPrice = $unit * $unitPrice;
  1791.                                                         $segmentIndex = isset($theDt['service_segmentIndex'][$f]) ? $theDt['service_segmentIndex'][$f] : 0;
  1793.                                                         if ($segmentIndex == 'undefined') $segmentIndex = 0;
  1794.                                                         if (!is_numeric($segmentIndex)) $segmentIndex = 0;
  1795.                                                         if ($oldSegmentSystem == 1)
  1796.                                                             $segmentIndex = 1000 + $segmentIndex;
  1797.                                                         $sequence = isset($theDt['service_segmentIndex'][$f]) ? $theDt['service_segmentIndex'][$f] : '_UNSET_';
  1799.                                                         if (!isset($lastSequenceBySegment[$segmentIndex]))
  1800.                                                             $lastSequenceBySegment[$segmentIndex] = -1;
  1802.                                                         if ($sequence == '_UNSET_')
  1803.                                                             $sequence = $lastSequenceBySegment[$segmentIndex] + 1;
  1804.                                                         else if ($sequence == $lastSequenceBySegment[$segmentIndex])
  1805.                                                             $sequence = $lastSequenceBySegment[$segmentIndex] + 1;
  1807.                                                         $lastSequenceBySegment[$segmentIndex] = $sequence;
  1809.                                                         $unitSalesPrice = isset($theDt['service_unit_sales_price'][$f]) ? $theDt['service_unit_sales_price'][$f] : $unitPrice;
  1810.                                                         $totalSalesPrice = $unit * $unitSalesPrice;
  1811.                                                         $marginAmount = isset($theDt['service_ma'][$f]) ? $theDt['service_ma'][$f] : ($unitSalesPrice - $unitPrice);
  1812.                                                         $marginRate = isset($theDt['service_ma'][$f]) ? $theDt['service_ma'][$f] : ($unitPrice == 0 ? 0 : (100 * $marginAmount / $unitPrice));
  1814.                                                         $discountAmount = isset($theDt['service_dr'][$f]) ? $theDt['service_dr'][$f] : 0;
  1815.                                                         $discountRate = isset($theDt['service_da'][$f]) ? $theDt['service_da'][$f] : ($totalSalesPrice == 0 ? 0 : (100 * $discountAmount / $totalSalesPrice));
  1816.                                                         $discountedAmount = $totalSalesPrice - $discountAmount;
  1819.                                                         $taxRate = isset($theDt['service_tax_percentage'][$f]) ? $theDt['service_tax_percentage'][$f] : ($unitPrice == 0 ? 0 : (100 * $discountAmount / $unitPrice));
  1820.                                                         $taxAmount = isset($theDt['service_tax_amount'][$f]) ? $theDt['service_tax_amount'][$f] : 0;
  1822.                                                         $finalAmount = $discountedAmount + $taxAmount;
  1825.                                                         $row = array(
  1826.                                                             'type' => 2,//1:product 2=service 4=tools 5:text 6: expense against head
  1827.                                                             'id' => $pid,
  1828.                                                             'index' => $indexForThis,
  1829.                                                             'isForeign' => isset($theDt['is_foreign_service'][$f]) ? $theDt['is_foreign_service'][$f] : 0,
  1830.                                                             'sequence' => $sequence,
  1831.                                                             'segmentIndex' => $segmentIndex,
  1832.                                                             'soItemId' => isset($theDt['service_soItemId'][$f]) ? $theDt['service_soItemId'][$f] : 0,
  1833.                                                             'soItemDelivered' => isset($theDt['service_soItemDelivered'][$f]) ? $theDt['service_soItemDelivered'][$f] : 0,
  1834.                                                             'soItemFound' => isset($theDt['service_soItemFound'][$f]) ? $theDt['service_soItemFound'][$f] : 0,
  1836.                                                             'alias' => isset($theDt['service_alias'][$f]) ? $theDt['service_alias'][$f] : '',
  1837.                                                             'name' => isset($theDt['service_name'][$f]) ? $theDt['service_name'][$f] : '',
  1838.                                                             'note' => isset($theDt['service_note'][$f]) ? $theDt['service_note'][$f] : '',
  1840.                                                             'fdm' => isset($theDt['service_fdm'][$f]) ? $theDt['service_fdm'][$f] : null,
  1841.                                                             'unit' => isset($theDt['service_units'][$f]) ? $theDt['service_units'][$f] : 0,
  1842.                                                             'unitTypeId' => isset($theDt['service_unit_type'][$f]) ? $theDt['service_unit_type'][$f] : 0,
  1844.                                                             'unitPrice' => $unitPrice,
  1845.                                                             'totalPrice' => $totalPrice,
  1846.                                                             'unitSalesPrice' => $unitSalesPrice,
  1847.                                                             'totalSalesPrice' => $totalSalesPrice,
  1849.                                                             'marginRate' => $marginRate,
  1850.                                                             'marginAmount' => $marginAmount,
  1852.                                                             'discountRate' => $discountRate,
  1853.                                                             'discountAmount' => $discountAmount,
  1854.                                                             'discountedAmount' => $discountedAmount,
  1855.                                                             'taxRate' => $taxRate,
  1856.                                                             'taxAmount' => $taxAmount,
  1857.                                                             'finalAmount' => $finalAmount,
  1859.                                                             'recurring' => isset($theDt['service_recurring'][$f]) ? $theDt['service_recurring'][$f] : 0,
  1861.                                                             'currency' => isset($theDt['service_currency_id'][$f]) ? $theDt['service_currency_id'][$f] : 0,
  1862.                                                             'currencyText' => isset($theDt['service_currency_text'][$f]) ? $theDt['service_currency_text'][$f] : '',
  1863.                                                             'currencyMultiplyRate' => isset($theDt['service_currency_multiply_rate'][$f]) ? $theDt['service_currency_multiply_rate'][$f] : 1,
  1865.                                                             'incoterm' => isset($theDt['incoterm'][$f]) ? $theDt['incoterm'][$f] : '',
  1867.                                                             'taxId' => isset($theDt['service_tax_config_id'][$f]) ? $theDt['service_tax_config_id'][$f] : 0,
  1868.                                                             'taxName' => isset($theDt['service_tax_config_text'][$f]) ? $theDt['service_tax_config_text'][$f] : '',
  1870.                                                             'dependencyOnIndex' => isset($theDt['service_dependency_of_index'][$f]) ? $theDt['service_dependency_of_index'][$f] : 0,
  1871.                                                             'dependencyOnPid' => isset($theDt['service_dependency_of_service_id'][$f]) ? $theDt['service_dependency_of_service_id'][$f] : 0,
  1872.                                                             'dependencyOnSid' => isset($theDt['service_dependency_of_service_id'][$f]) ? $theDt['service_dependency_of_service_id'][$f] : 0,
  1873.                                                             'dependencyOnSegment' => isset($theDt['service_dependency_of_service_index'][$f]) ? $theDt['service_dependency_of_service_index'][$f] : 0,
  1875.                                                             'warranty' => isset($theDt['service_delivery_schedule'][$f]) ? $theDt['service_delivery_schedule'][$f] : 0,
  1876.                                                             'origin' => isset($theDt['service_origin'][$f]) ? $theDt['service_origin'][$f] : 0,
  1877.                                                             'origins' => isset($theDt['service_origin'][$f]) ? [$theDt['service_origin'][$f]] : [],
  1879.                                                             'scope' => isset($theDt['service_scope'][$f]) ? $theDt['service_scope'][$f] : 0,
  1880.                                                             'scopeId' => isset($theDt['service_scopeHolderId'][$f]) ? [$theDt['service_scopeHolderId'][$f]] : 0,
  1881.                                                             'scopeName' => isset($theDt['service_scopeHolderName'][$f]) ? [$theDt['service_scopeHolderName'][$f]] : '',
  1882.                                                             'scopeDescription' => isset($theDt['service_scopeDescription'][$f]) ? [$theDt['service_scopeDescription'][$f]] : '',
  1884.                                                             'deliverySchedule' => isset($theDt['service_delivery_schedule'][$f]) ? $theDt['service_delivery_schedule'][$f] : [],
  1885.                                                             'deliveryPorts' => isset($theDt['service_delivery_ports'][$f]) ? $theDt['service_delivery_ports'][$f] : [],
  1886.                                                             'billingSchedule' => isset($theDt['service_billing_schedule'][$f]) ? $theDt['service_billing_schedule'][$f] : [],
  1888.                                                             'referenceNo' => isset($theDt['service_reference_price'][$f]) ? $theDt['service_reference_price'][$f] : '',
  1889.                                                             'referenceFiles' => isset($theDt['service_reference_price_file'][$f]) ? $theDt['service_reference_price_file'][$f] : '',
  1892.                                                         );
  1894.                                                         $dt_poka['rowData'][] = $row;
  1896.                                                     }
  1898.                                                 //now accounts /Cost
  1899.                                                 $theDt = array(
  1900.                                                     'products' => [],
  1901.                                                     'services' => [],
  1902.                                                     'ar_heads' => [],
  1903.                                                 );
  1904.                                                 if (isset($dt_poka['ArCosts']))
  1905.                                                     $theDt = $dt_poka['ArCosts'];
  1906.                                                 if (isset($theDt['ar_heads']))
  1907.                                                     foreach ($theDt['ar_heads'] as $f => $pid) {
  1908.                                                         $unit = isset($theDt['ar_units'][$f]) ? $theDt['ar_units'][$f] : 0;
  1909.                                                         if (!is_numeric($unit)) $unit = 0;
  1910.                                                         $indexForThis = isset($theDt['index'][$f]) ? $theDt['index'][$f] : -1;
  1911.                                                         if ($indexForThis == -1) {
  1912.                                                             $indexForThis = $lastIndex;
  1913.                                                             $lastIndex++;
  1914.                                                         }
  1915.                                                         $unitPrice = isset($theDt['ar_unit_price'][$f]) ? $theDt['ar_unit_price'][$f] : 0;
  1916.                                                         if (!is_numeric($unitPrice)) $unitPrice = 0;
  1917.                                                         $totalPrice = $unit * $unitPrice;
  1918.                                                         $segmentIndex = isset($theDt['ar_segmentIndex'][$f]) ? $theDt['ar_segmentIndex'][$f] : 0;
  1919.                                                         if ($oldSegmentSystem == 1)
  1920.                                                             $segmentIndex = 1000 + $segmentIndex;
  1921.                                                         $sequence = isset($theDt['ar_segmentIndex'][$f]) ? $theDt['ar_segmentIndex'][$f] : '_UNSET_';
  1923.                                                         if (!isset($lastSequenceBySegment[$segmentIndex]))
  1924.                                                             $lastSequenceBySegment[$segmentIndex] = -1;
  1926.                                                         if ($sequence == '_UNSET_')
  1927.                                                             $sequence = $lastSequenceBySegment[$segmentIndex] + 1;
  1928.                                                         else if ($sequence == $lastSequenceBySegment[$segmentIndex])
  1929.                                                             $sequence = $lastSequenceBySegment[$segmentIndex] + 1;
  1931.                                                         $lastSequenceBySegment[$segmentIndex] = $sequence;
  1933.                                                         $unitSalesPrice = isset($theDt['ar_unit_sales_price'][$f]) ? $theDt['ar_unit_sales_price'][$f] : $unitPrice;
  1934.                                                         $totalSalesPrice = $unit * $unitSalesPrice;
  1935.                                                         $marginAmount = isset($theDt['ar_ma'][$f]) ? $theDt['ar_ma'][$f] : ($unitSalesPrice - $unitPrice);
  1936.                                                         $marginRate = isset($theDt['ar_ma'][$f]) ? $theDt['ar_ma'][$f] : ($unitPrice == 0 ? 0 : (100 * $marginAmount / $unitPrice));
  1938.                                                         $discountAmount = isset($theDt['ar_dr'][$f]) ? $theDt['ar_dr'][$f] : 0;
  1939.                                                         $discountRate = isset($theDt['ar_da'][$f]) ? $theDt['ar_da'][$f] : ($totalSalesPrice == 0 ? 0 : (100 * $discountAmount / $totalSalesPrice));
  1940.                                                         $discountedAmount = $totalSalesPrice - $discountAmount;
  1943.                                                         $taxRate = isset($theDt['ar_tax_percentage'][$f]) ? $theDt['ar_tax_percentage'][$f] : ($unitPrice == 0 ? 0 : (100 * $discountAmount / $unitPrice));
  1944.                                                         $taxAmount = isset($theDt['ar_tax_amount'][$f]) ? $theDt['ar_tax_amount'][$f] : 0;
  1946.                                                         $finalAmount = $discountedAmount + $taxAmount;
  1949.                                                         $row = array(
  1950.                                                             'type' => 6,//1:product 2=service 4=tools 5:text 6: expense against head
  1951.                                                             'id' => $pid,
  1952.                                                             'index' => $indexForThis,
  1953.                                                             'isForeign' => isset($theDt['is_foreign_cost'][$f]) ? $theDt['is_foreign_cost'][$f] : 0,
  1954.                                                             'sequence' => $sequence,
  1955.                                                             'segmentIndex' => $segmentIndex,
  1956.                                                             'soItemId' => isset($theDt['ar_soItemId'][$f]) ? $theDt['ar_soItemId'][$f] : 0,
  1957.                                                             'soItemDelivered' => isset($theDt['ar_soItemDelivered'][$f]) ? $theDt['ar_soItemDelivered'][$f] : 0,
  1958.                                                             'soItemFound' => isset($theDt['ar_soItemFound'][$f]) ? $theDt['ar_soItemFound'][$f] : 0,
  1960.                                                             'alias' => isset($theDt['ar_alias'][$f]) ? $theDt['ar_alias'][$f] : '',
  1961.                                                             'name' => isset($theDt['ar_name'][$f]) ? $theDt['ar_name'][$f] : '',
  1962.                                                             'note' => isset($theDt['ar_note'][$f]) ? $theDt['ar_note'][$f] : '',
  1964.                                                             'fdm' => isset($theDt['ar_fdm'][$f]) ? $theDt['ar_fdm'][$f] : null,
  1965.                                                             'unit' => isset($theDt['ar_units'][$f]) ? $theDt['ar_units'][$f] : 0,
  1966.                                                             'unitTypeId' => isset($theDt['ar_unit_type'][$f]) ? $theDt['ar_unit_type'][$f] : 0,
  1968.                                                             'unitPrice' => $unitPrice,
  1969.                                                             'totalPrice' => $totalPrice,
  1970.                                                             'unitSalesPrice' => $unitSalesPrice,
  1971.                                                             'totalSalesPrice' => $totalSalesPrice,
  1973.                                                             'marginRate' => $marginRate,
  1974.                                                             'marginAmount' => $marginAmount,
  1976.                                                             'discountRate' => $discountRate,
  1977.                                                             'discountAmount' => $discountAmount,
  1978.                                                             'discountedAmount' => $discountedAmount,
  1979.                                                             'taxRate' => $taxRate,
  1980.                                                             'taxAmount' => $taxAmount,
  1981.                                                             'finalAmount' => $finalAmount,
  1983.                                                             'recurring' => isset($theDt['ar_recurring'][$f]) ? $theDt['ar_recurring'][$f] : 0,
  1985.                                                             'currency' => isset($theDt['ar_currency_id'][$f]) ? $theDt['ar_currency_id'][$f] : 0,
  1986.                                                             'currencyText' => isset($theDt['ar_currency_text'][$f]) ? $theDt['ar_currency_text'][$f] : '',
  1987.                                                             'currencyMultiplyRate' => isset($theDt['ar_currency_multiply_rate'][$f]) ? $theDt['ar_currency_multiply_rate'][$f] : 1,
  1989.                                                             'incoterm' => isset($theDt['incoterm'][$f]) ? $theDt['incoterm'][$f] : '',
  1991.                                                             'taxId' => isset($theDt['ar_tax_config_id'][$f]) ? $theDt['ar_tax_config_id'][$f] : 0,
  1992.                                                             'taxName' => isset($theDt['ar_tax_config_text'][$f]) ? $theDt['ar_tax_config_text'][$f] : '',
  1994.                                                             'dependencyOnIndex' => isset($theDt['ar_dependency_of_index'][$f]) ? $theDt['ar_dependency_of_index'][$f] : 0,
  1995.                                                             'dependencyOnPid' => isset($theDt['ar_dependency_of_ar_id'][$f]) ? $theDt['ar_dependency_of_ar_id'][$f] : 0,
  1996.                                                             'dependencyOnSid' => isset($theDt['ar_dependency_of_ar_id'][$f]) ? $theDt['ar_dependency_of_ar_id'][$f] : 0,
  1997.                                                             'dependencyOnSegment' => isset($theDt['ar_dependency_of_ar_index'][$f]) ? $theDt['ar_dependency_of_ar_index'][$f] : 0,
  1999.                                                             'warranty' => isset($theDt['ar_delivery_schedule'][$f]) ? $theDt['ar_delivery_schedule'][$f] : 0,
  2000.                                                             'origin' => isset($theDt['ar_origin'][$f]) ? $theDt['ar_origin'][$f] : 0,
  2001.                                                             'origins' => isset($theDt['ar_origin'][$f]) ? [$theDt['ar_origin'][$f]] : [],
  2003.                                                             'scope' => isset($theDt['ar_scope'][$f]) ? $theDt['ar_scope'][$f] : 0,
  2004.                                                             'scopeId' => isset($theDt['ar_scopeHolderId'][$f]) ? [$theDt['ar_scopeHolderId'][$f]] : 0,
  2005.                                                             'scopeName' => isset($theDt['ar_scopeHolderName'][$f]) ? [$theDt['ar_scopeHolderName'][$f]] : '',
  2006.                                                             'scopeDescription' => isset($theDt['ar_scopeDescription'][$f]) ? [$theDt['ar_scopeDescription'][$f]] : '',
  2008.                                                             'deliverySchedule' => isset($theDt['ar_delivery_schedule'][$f]) ? $theDt['ar_delivery_schedule'][$f] : [],
  2009.                                                             'deliveryPorts' => isset($theDt['ar_delivery_ports'][$f]) ? $theDt['ar_delivery_ports'][$f] : [],
  2010.                                                             'billingSchedule' => isset($theDt['ar_billing_schedule'][$f]) ? $theDt['ar_billing_schedule'][$f] : [],
  2012.                                                             'referenceNo' => isset($theDt['ar_reference_price'][$f]) ? $theDt['ar_reference_price'][$f] : '',
  2013.                                                             'referenceFiles' => isset($theDt['ar_reference_price_file'][$f]) ? $theDt['ar_reference_price_file'][$f] : '',
  2016.                                                         );
  2018.                                                         $dt_poka['rowData'][] = $row;
  2020.                                                     }
  2022. //                                                $configJson['debugData'][]=$dt_poka;
  2025.                                             }
  2027.                                             $newSingleSet['rowData'] = $dt_poka['rowData'];
  2030.                                             unset($dt_poka['productSegmentData']);
  2031.                                             unset($dt_poka['serviceSegmentData']);
  2032.                                             unset($dt_poka['Products']);
  2033.                                             unset($dt_poka['Services']);
  2036.                                             $newData[$kho] = $newSingleSet;
  2038.                                         }
  2040.                                         $theDocData->setData(json_encode($newData));
  2041.                                         $em->persist($theDocData);
  2042.                                         $em->flush();
  2044.                                     }
  2046.                                     $tempId = 0;
  2047.                                     if ($entityNameHere == 'SalesProposal') $tempId = $the_actual_doc->getSalesProposalId();
  2048.                                     if ($entityNameHere == 'ProjectBoq') $tempId = $the_actual_doc->getProjectId();
  2049.                                     if ($entityNameHere == 'SalesLead') $tempId = $the_actual_doc->getLeadId();
  2051.                                     $configJson['debugData'][] = array(
  2052.                                         'entityNameHere' => $entityNameHere,
  2053.                                         'entityId' => $tempId,
  2054.                                         'dt' => $newData,
  2055.                                     );
  2058.                                 }
  2061.                                 $the_actual_doc->setData(null);
  2062.                                 $the_actual_doc->setDocumentDataId($theDocData->getId());
  2063.                                 $em->flush();
  2065.                                 if ($entityNameHere == 'ProjectBoq') {
  2067.                                     $theProj = $em->getRepository('ApplicationBundle:Project')
  2068.                                         ->findOneBy(
  2069.                                             array(
  2070.                                                 'projectId' => $the_actual_doc->getProjectId()
  2071.                                             )
  2072.                                         );
  2073.                                     if ($theProj)
  2074.                                         $theProj->setDocumentDataId($the_actual_doc->getDocumentDataId());
  2075.                                     $em->flush();
  2078.                                 }
  2080.                             }
  2081.                         }
  2084.                     }
  2085.                     if ($request->query->get('convertMarginToMarkupOldDocumentData', 0) == 1) {
  2088.                         $the_actual_docs = $em->getRepository('ApplicationBundle:DocumentData')
  2089.                             ->findBy(
  2090.                                 array(//                                        GeneralConstant::$Entity_id_field_list[$ent] => $entity_id,
  2091.                                 )
  2092.                             );
  2093.                         foreach ($the_actual_docs as $the_actual_doc) {
  2096.                             //now the data
  2097.                             //first find the docData if available
  2099.                             $theDocData = [];
  2101.                             $theDocData = json_decode($the_actual_doc->getData(), true);
  2102.                             if ($theDocData == null)
  2103.                                 $theDocData = [];
  2105.                             $entries = $theDocData;
  2107.                             foreach ($entries as $jojo => $mod) {
  2110.                                 if (isset($mod['rowData'])) {
  2111.                                     $rows = $mod['rowData'];
  2113.                                     if (is_string($rows))
  2114.                                         $rows = json_decode($rows, true);
  2115.                                     if ($rows == null)
  2116.                                         $rows = [];
  2118.                                     foreach ($rows as $indu => $row) {
  2120.                                         if (!is_numeric($row['unitSalesPrice'])) $row['unitSalesPrice'] = 0;
  2121.                                         if (!is_numeric($row['unitPrice'])) $row['unitPrice'] = 0;
  2122.                                         if (!is_numeric($row['marginAmount'])) $row['marginAmount'] = 0;
  2125.                                         if (!isset($row['markupRate'])) {
  2126.                                             $rows[$indu]['markupRate'] = $row['marginRate'];
  2127.                                         }
  2128.                                         $rows[$indu]['marginRate'] = $row['unitSalesPrice'] != 0 ? 100 * $row['marginAmount'] / $row['unitSalesPrice'] : 0;
  2131.                                     }
  2133.                                     $entries[$jojo]['rowData'] = $rows;
  2136.                                 }
  2139.                             }
  2142.                             $the_actual_doc->setData(json_encode($entries));
  2143. //                                $the_actual_doc->setDocumentDataId($theDocData->getId());
  2144.                             $em->flush();
  2147.                         }
  2150.                     }
  2153.                     if ($request->query->get('rectifyTransCurr', 0) == 1) {
  2156.                         $query = "
  2157.                                     UPDATE `acc_transaction_details` SET currency_multiply_rate=1 WHERE currency_multiply_rate is NULL or currency_multiply_rate=0 ;
  2158.                                     UPDATE `acc_transaction_details` SET currency_multiply=1 WHERE currency_multiply is NULL or currency_multiply=0 ;
  2159.                                     UPDATE `acc_transactions` SET currency_multiply_rate=1 WHERE currency_multiply_rate is NULL or currency_multiply_rate=0 ;
  2160.                                     UPDATE `acc_transactions` SET currency_multiply=1 WHERE currency_multiply is NULL or currency_multiply=0 ;
  2161.                                     UPDATE `expense_invoice` SET currency_multiply_rate=1 WHERE currency_multiply_rate is NULL or currency_multiply_rate=0 ;
  2162.                                     UPDATE `expense_invoice` SET currency_multiply=1 WHERE currency_multiply is NULL or currency_multiply=0 ;
  2163.   
  2164.                      
  2165.                       ";
  2167.                         $stmt = $em->getConnection()->prepare($query);
  2168.                         $stmt->execute();
  2169.                         $stmt->closeCursor();
  2172.                     }
  2173.                     if ($request->query->get('deepRefresh', 0) == 1) {
  2176.                         //new for updating app id
  2177.                         $get_kids_sql = "UPDATE `company` set app_id=" . $entry['appId'] . " ;
  2178.                         UPDATE `sys_user` set app_id=" . $entry['appId'] . " ;";
  2179.                         $get_kids_sql .= "
  2180.                                       UPDATE `inv_products` set default_color_id=0  where default_color_id ='' or default_color_id is null ;
  2181.                                       UPDATE `inv_products` set default_size=0  where default_size ='' or default_size is null ;
  2182.                                         UPDATE `inventory_storage` set color= (select default_color_id from inv_products where inv_products.id=inventory_storage.product_id)
  2183.                                          where inventory_storage.color =0 or inventory_storage.color is null or inventory_storage.color ='' ;
  2184.                                          UPDATE `inventory_storage` set owner_type= 0 where inventory_storage.owner_type is null or inventory_storage.owner_type ='' ;
  2185.                                          UPDATE `inventory_storage` set owner_id= 0 where inventory_storage.owner_id is null or inventory_storage.owner_id ='' ;
  2186.                                          UPDATE `acc_clients` set client_level= 1 where client_level is null or client_level ='' or client_level=0 ;
  2187.                                          UPDATE `acc_clients` set parent_id= 0 where parent_id is null or parent_id ='' ;
  2188.                                          UPDATE `sales_order` set sales_level= 0 where sales_level is null or sales_level ='' ;
  2190.                                          ";
  2191.                         $get_kids_sql .= "                UPDATE `inventory_storage` set color=0 where color='' or color is null;
  2192.                                         UPDATE `inventory_storage` set `size`=0 where `size`='' or size is null;
  2193.                                         UPDATE `inv_item_transaction` set color=0 where color='' or color is null;
  2194.                                         UPDATE `inv_item_transaction` set `size`=0 where `size`='' or size is null;
  2195.                                         UPDATE `inv_closing_balance` set color=0 where color='' or color is null;
  2196.                                         UPDATE `inv_closing_balance` set `size`=0 where `size`='' or size is null;
  2197.                                         UPDATE `sales_order_item` set `size_id`=(select default_size from inv_products where inv_products.id=sales_order_item.product_id ) where sales_order_item.product_id!=0 and (`size_id`='' or size_id is null);
  2198.                                         UPDATE `sales_order_item` set `color_id`=(select default_color_id from inv_products where inv_products.id=sales_order_item.product_id ) where sales_order_item.product_id!=0 and (`color_id`='' or color_id is null);
  2199.                                         UPDATE `delivery_receipt_item` set `size_id`=(select default_size from inv_products where inv_products.id=delivery_receipt_item.product_id ) where delivery_receipt_item.product_id!=0 and (`size_id`='' or size_id is null);
  2200.                                         UPDATE `delivery_receipt_item` set `color_id`=(select default_color_id from inv_products where inv_products.id=delivery_receipt_item.product_id ) where delivery_receipt_item.product_id!=0 and (`color_id`='' or color_id is null);
  2201.                                         UPDATE `delivery_order_item` set `size_id`=(select default_size from inv_products where inv_products.id=delivery_order_item.product_id ) where delivery_order_item.product_id!=0 and (`size_id`='' or size_id is null);
  2202.                                         UPDATE `delivery_order_item` set `color_id`=(select default_color_id from inv_products where inv_products.id=delivery_order_item.product_id ) where delivery_order_item.product_id!=0 and (`color_id`='' or color_id is null);
  2203.                                         UPDATE `sales_invoice_item` set `size_id`=(select default_size from inv_products where inv_products.id=sales_invoice_item.product_id ) where sales_invoice_item.product_id!=0 and (`size_id`='' or size_id is null);
  2204.                                         UPDATE `sales_invoice_item` set `color_id`=(select default_color_id from inv_products where inv_products.id=sales_invoice_item.product_id ) where sales_invoice_item.product_id!=0 and (`color_id`='' or color_id is null);
  2206.                                         UPDATE `inventory_storage` set curr_purchase_price= (select curr_purchase_price from inv_products where inv_products.id=inventory_storage.product_id)
  2207.                                          where inventory_storage.curr_purchase_price=0 or inventory_storage.curr_purchase_price is null;
  2208.                                        delete TABLE service_opearation;
  2209.                                        delete TABLE assesment_and_confirmation;
  2211.                                        ";
  2212.                         $stmt = $em->getConnection()->prepare($get_kids_sql);
  2213.                         $stmt->execute();
  2214.                         $stmt->closeCursor();
  2216.                         $query = "SELECT * from  company   where 1";
  2218.                         $stmt = $em->getConnection()->prepare($query);
  2219.                         $stmt->execute();
  2220.                         $results = $stmt->fetchAll();
  2221.                         if (empty($results)) {
  2222.                             //insert client level query here
  2223.                             $createdDate = new \DateTime();
  2224.                             $cgEntry = $gocEntryObjectList[$gocId];
  2225.                             $get_kids_sql = "INSERT INTO `company` (`id`, `name`, `image`, `app_id`,  `created_at`,   `company_hash`, `company_unique_code`, `enabled_module_id_list`, `usage_valid_upto_date`,`active`) VALUES
  2226. (1, '" . $cgEntry->getName() . "', '" . $cgEntry->getImage() . "'," . $cgEntry->getAppId() . ",'" . $createdDate->format('Y-m-d H:i:s') . "', '" . $cgEntry->getCompanyGroupHash() . "','" . $cgEntry->getCompanyGroupUniqueCode() . "',NULL, NULL,1);";
  2227.                             $stmt = $em->getConnection()->prepare($get_kids_sql);
  2228.                             $stmt->execute();
  2229.                             $stmt->closeCursor();
  2231.                         }
  2233.                         $query = "SELECT * from  client_level   where 1";
  2235.                         $stmt = $em->getConnection()->prepare($query);
  2236.                         $stmt->execute();
  2237.                         $results = $stmt->fetchAll();
  2238.                         if (empty($results)) {
  2239.                             //insert client level query here
  2240.                             $get_kids_sql = "INSERT INTO `client_level` (`id`, `name`, `level_value`,`company_id`, `parent_level_id`, `status`, `created_at`, `updated_at`, `doc_booked_flag`, `time_stamp_of_form`) VALUES
  2241. (1, 'Primary',1, 1, 0, 1, '2022-02-22 20:58:51', NULL, NULL, NULL),
  2242. (2, 'Secondary',2, 1, 1, 1, '2022-02-22 20:58:51', NULL, NULL, NULL),
  2243. (3, 'Tertiary',3, 1, 2, 1, '2022-02-22 20:58:51', NULL, NULL, NULL)
  2244. ;";
  2245.                             $stmt = $em->getConnection()->prepare($get_kids_sql);
  2246.                             $stmt->execute();
  2247.                             $stmt->closeCursor();
  2249.                         }
  2250.                         $query = "SELECT * from  sales_level   where 1";
  2252.                         $stmt = $em->getConnection()->prepare($query);
  2253.                         $stmt->execute();
  2254.                         $results = $stmt->fetchAll();
  2255.                         if (empty($results)) {
  2256.                             //insert client level query here
  2257.                             $get_kids_sql = "INSERT INTO `sales_level` (`id`, `name`, `level_value`,`company_id`, `parent_level_id`, `status`, `created_at`, `updated_at`, `doc_booked_flag`, `time_stamp_of_form`) VALUES
  2258. (1, 'Primary',0, 1, 0, 1, '2022-02-22 20:58:51', NULL, NULL, NULL),
  2259. (2, 'Secondary',1, 1, 1, 1, '2022-02-22 20:58:51', NULL, NULL, NULL),
  2260. (3, 'Tertiary',2, 1, 2, 1, '2022-02-22 20:58:51', NULL, NULL, NULL);";
  2261.                             $stmt = $em->getConnection()->prepare($get_kids_sql);
  2262.                             $stmt->execute();
  2263.                             $stmt->closeCursor();
  2265.                         }
  2268.                         $services = $em->getRepository('ApplicationBundle:AccService')->findBy(array(
  2269. //                            'serviceId' => $ex_id//for now for stock of goods
  2270. //                    'opening_locked'=>0
  2271.                         ));
  2273.                         foreach ($services as $service) {
  2274.                             $productFdm = $service->getProductFdm();
  2275.                             if (strpos($productFdm, 'P_') !== false)
  2276.                                 $productFdm = str_replace('P_', 'P' . $service->getServiceId() . '_', $productFdm);
  2279.                             $service->setProductFdm($productFdm);
  2280.                             $em->flush();
  2282.                         }
  2285.                         $query = "SELECT * from  warehouse_action   where 1";
  2287.                         $stmt = $em->getConnection()->prepare($query);
  2288.                         $stmt->execute();
  2289.                         $results = $stmt->fetchAll();
  2290.                         if (!empty($results)) {
  2291.                             //insert client level query here
  2292.                             foreach ($results as $qryResult) {
  2293.                                 $get_kids_sql = "update `warehouse_action` set `accounts_head_id` =(select `data` from acc_setting where acc_setting.`name` like 'warehouse_action_" . $qryResult['id'] . "') where id=" . $qryResult['id'];
  2296.                                 $stmt = $em->getConnection()->prepare($get_kids_sql);
  2297.                                 $stmt->execute();
  2298.                                 $stmt->closeCursor();
  2299.                             }
  2301.                         } else {
  2303.                             foreach (GeneralConstant::$warehouse_action_list as $dt_pika) {
  2304.                                 $get_kids_sql = "INSERT INTO `warehouse_action` (`id`, `name`,`company_id`,  `status`, `created_at`, `updated_at`, `doc_booked_flag`, `time_stamp_of_form`)
  2305. VALUES(" . $dt_pika['id'] . ", '" . $dt_pika['name'] . "', 1, 1, '2022-02-22 20:58:51', NULL, NULL, NULL)";
  2308.                                 $stmt = $em->getConnection()->prepare($get_kids_sql);
  2309.                                 $stmt->execute();
  2310.                                 $stmt->closeCursor();
  2311.                             }
  2312. //
  2315.                             $query = "SELECT * from  warehouse_action   where 1";
  2317.                             $stmt = $em->getConnection()->prepare($query);
  2318.                             $stmt->execute();
  2319.                             $newresults = $stmt->fetchAll();
  2320.                             foreach ($newresults as $qryResult) {
  2321.                                 $get_kids_sql = "update `warehouse_action` set `accounts_head_id` =(select `data` from acc_setting where acc_setting.`name` like 'warehouse_action_" . $qryResult['id'] . "') where id=" . $qryResult['id'];
  2324.                                 $stmt = $em->getConnection()->prepare($get_kids_sql);
  2325.                                 $stmt->execute();
  2326.                                 $stmt->closeCursor();
  2327.                             }
  2328.                         }
  2331.                         $modify_product_by_code_ids_table_list = [
  2333.                             'stock_transfer_item',
  2336.                         ];
  2337.                         $modify_product_by_code_ids_field_list = [
  2338.                             'product_by_code_ids'
  2340.                         ];
  2341.                         $modify_product_by_code_sales_code_field_list = [
  2342.                             'sales_code_range'
  2344.                         ];
  2345.                         $modify_product_by_code_item_id_field_list = [
  2346.                             'id'
  2348.                         ];
  2349.                         foreach ($modify_product_by_code_ids_table_list as $mindex => $dt_table_name) {
  2350.                             $get_kids_sql = "select * from " . $dt_table_name . " where " .
  2351.                                 $modify_product_by_code_ids_field_list[$mindex] . " is null  or " .
  2352.                                 $modify_product_by_code_ids_field_list[$mindex] . " =''  or " .
  2353.                                 $modify_product_by_code_ids_field_list[$mindex] . " ='[]' ;";
  2355.                             $stmt = $em->getConnection()->prepare($get_kids_sql);
  2356.                             $stmt->execute();
  2357.                             $dataList = $stmt->fetchAll();
  2358.                             foreach ($dataList as $mdt) {
  2360.                                 $sales_code_range_str = $mdt[$modify_product_by_code_sales_code_field_list[$mindex]];
  2361.                                 $sales_code_range = [];
  2363.                                 if (version_compare(PHP_VERSION, '5.4.0', '>=') && !(defined('JSON_C_VERSION') && PHP_INT_SIZE > 4)) {
  2365.                                     $sales_code_range = json_decode($sales_code_range_str, true, 512, JSON_BIGINT_AS_STRING);
  2366.                                 } else {
  2368.                                     $max_int_length = strlen((string)PHP_INT_MAX) - 1;
  2369.                                     $json_without_bigints = preg_replace('/:\s*(-?\d{' . $max_int_length . ',})/', ': "$1"', $sales_code_range_str);
  2370.                                     $sales_code_range = json_decode($json_without_bigints, true);
  2371.                                 }
  2372. //                    $sales_code_range= json_decode($entry->getSalesCodeRange(),true,512,JSON_BIGINT_AS_STRING);
  2375.                                 $pbcIds = [];
  2377.                                 if ($sales_code_range == null)
  2378.                                     $sales_code_range = [];
  2381.                                 if (empty($sales_code_range)) {
  2383.                                 } else {
  2384.                                     $get_kids_sql_2 = "select * from  product_by_code  where sales_code in ('" . implode("','", $sales_code_range) . "');";
  2386.                                     $stmt = $em->getConnection()->prepare($get_kids_sql_2);
  2387.                                     $stmt->execute();
  2388.                                     $dataList = $stmt->fetchAll();
  2389.                                     foreach ($dataList as $pbc) {
  2390.                                         $pbcIds[] = 1 * $pbc['product_by_code_id'];
  2391.                                     }
  2392.                                 }
  2394.                                 $get_kids_sql_3 = "update " . $dt_table_name .
  2395.                                     " set  " . $modify_product_by_code_ids_field_list[$mindex] . "='" . json_encode($pbcIds) . "'" .
  2396.                                     " where " . $modify_product_by_code_item_id_field_list[$mindex] . "=" . $mdt[$modify_product_by_code_item_id_field_list[$mindex]] . ";";
  2398.                                 $stmt = $em->getConnection()->prepare($get_kids_sql_3);
  2399.                                 $stmt->execute();
  2400.                                 $stmt->closeCursor();
  2403.                             }
  2404.                         }
  2407.                         $modify_voucher_date_table_list = [
  2408. //                            'stock_received_note',
  2409. //                            'stock_transfer',
  2410. //                            'stock_consumption_note',
  2411. //                            'fixed_asset_conversion_note',
  2412. //                            'fixed_asset_product'
  2414.                         ];
  2415.                         $modify_date_field_list = [
  2416. //                            'stock_received_note_date',
  2417. //                            'stock_transfer_date',
  2418. //                            'stock_consumption_note_date',
  2419. //                            'fixed_asset_conversion_note_date',
  2420. //                            'fixed_asset_product'
  2422.                         ];
  2424.                         foreach ($modify_voucher_date_table_list as $mindex => $dt_table_name) {
  2425.                             $get_kids_sql = "select * from " . $dt_table_name . " where 1;";
  2427.                             $stmt = $em->getConnection()->prepare($get_kids_sql);
  2428.                             $stmt->execute();
  2429.                             $dataList = $stmt->fetchAll();
  2430.                             foreach ($dataList as $mdt) {
  2431.                                 $curr_v_ids = json_decode($mdt['voucher_ids'], true);
  2432.                                 if ($curr_v_ids == null)
  2433.                                     $curr_v_ids = [];
  2435.                                 $date_for_this = $mdt[$modify_date_field_list[$mindex]];
  2437.                                 foreach ($curr_v_ids as $vid) {
  2438.                                     //new for updating app id
  2439.                                     $get_kids_sql = "UPDATE `acc_transactions`
  2440.                                                           set transaction_date='" . $date_for_this . "',
  2441.                                                               ledger_hit_date='" . $date_for_this . "'
  2442.                                                           where transaction_id=" . $vid . ";
  2443.                                         UPDATE `acc_transactions_details`
  2444.                                                           set transaction_date='" . $date_for_this . "',
  2445.                                                               ledger_hit_date='" . $date_for_this . "'
  2446.                                                           where transaction_id=" . $vid . ";";
  2447.                                     $stmt = $em->getConnection()->prepare($get_kids_sql);
  2448.                                     $stmt->execute();
  2449.                                     $stmt->closeCursor();
  2452.                                 }
  2455.                             }
  2456.                         }
  2459.                         $modify_voucher_narration_table_list = [
  2460. //                            'expense_invoice',
  2461. //                            'stock_transfer',
  2462. //                            'stock_consumption_note',
  2463. //                            'fixed_asset_conversion_note',
  2464. //                            'fixed_asset_product'
  2466.                         ];
  2467.                         $modify_narr_field_list = [
  2468. //                            'description',
  2469. //                            'stock_transfer_date',
  2470. //                            'stock_consumption_note_date',
  2471. //                            'fixed_asset_conversion_note_date',
  2472. //                            'fixed_asset_product'
  2474.                         ];
  2476.                         foreach ($modify_voucher_narration_table_list as $mindex => $dt_table_name) {
  2477.                             $get_kids_sql = "select * from " . $dt_table_name . " where 1;";
  2479.                             $stmt = $em->getConnection()->prepare($get_kids_sql);
  2480.                             $stmt->execute();
  2481.                             $dataList = $stmt->fetchAll();
  2482.                             foreach ($dataList as $mdt) {
  2483.                                 $curr_v_ids = json_decode($mdt['voucher_ids'], true);
  2484.                                 if ($curr_v_ids == null)
  2485.                                     $curr_v_ids = [];
  2487.                                 $narr_for_this = $mdt[$modify_narr_field_list[$mindex]];
  2489.                                 foreach ($curr_v_ids as $vid) {
  2490.                                     //new for updating app id
  2491.                                     $get_kids_sql = "UPDATE `acc_transactions`
  2492.                                                           set description='" . $narr_for_this . "'
  2494.                                                           where transaction_id=" . $vid . "; ";
  2495.                                     $stmt = $em->getConnection()->prepare($get_kids_sql);
  2496.                                     $stmt->execute();
  2497.                                     $stmt->closeCursor();
  2500.                                 }
  2503.                             }
  2504.                         }
  2505.                     }
  2508.                     $get_kids_sql = "update `company_group` set `schema_update_pending_flag` =0 where `id`=$gocId;";
  2511.                     $stmt = $em_goc->getConnection()->prepare($get_kids_sql);
  2512.                     $stmt->execute();
  2513.                     $stmt->closeCursor();
  2515.                     $configJson['success'] = true;
  2518.                     //this is for large amount of goc we will see  later
  2519. //                        file_put_contents($path, json_encode($configJson));//overwrite
  2520. //                        return $this->redirectToRoute('update_database_schema');
  2522.                 }
  2525.             }
  2528.             return new JsonResponse($configJson);
  2529.         } else {
  2530.             return $this->render(
  2531.                 '@System/pages/server_actions.html.twig',
  2533.                 $dtHere
  2535.             );
  2536.         }
  2537.     }
  2539.     public function UpdateRoutesAction(Request $request)
  2540.     {
  2541.         $message = "";
  2543.         $gocList = [];
  2544.         $outputList = [];
  2545.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  2547.         $em = $this->getDoctrine()->getManager('company_group');
  2548.         $em->getConnection()->connect();
  2549.         $connected = $em->getConnection()->isConnected();
  2550.         if ($connected)
  2551.             if ($systemType != '_CENTRAL_') {
  2552.                 $gocList = $this->getDoctrine()->getManager('company_group')
  2553.                     ->getRepository("CompanyGroupBundle:CompanyGroup")
  2554.                     ->findBy(
  2555.                         array(
  2556.                             'active' => 1
  2557.                         )
  2558.                     );
  2559.             }
  2561.         $gocDataList = [];
  2562.         foreach ($gocList as $entry) {
  2563.             $d = array(
  2564.                 'name' => $entry->getName(),
  2565.                 'id' => $entry->getId(),
  2566.                 'dbName' => $entry->getDbName(),
  2567.                 'dbUser' => $entry->getDbUser(),
  2568.                 'dbPass' => $entry->getDbPass(),
  2569.                 'dbHost' => $entry->getDbHost(),
  2570.                 'appId' => $entry->getAppId(),
  2571.                 'companyRemaining' => $entry->getCompanyRemaining(),
  2572.                 'companyAllowed' => $entry->getCompanyAllowed(),
  2573.             );
  2574.             $gocDataList[$entry->getId()] = $d;
  2575.         }
  2576.         $gocDbName = '';
  2577.         $gocDbUser = '';
  2578.         $gocDbPass = '';
  2579.         $gocDbHost = '';
  2580.         $gocId = 0;
  2583. //        $path = $this->container->get('templating.helper.assets')->getUrl('bundles/tlfront/js/channels.json');
  2584.         $config_dir = $this->container->getParameter('kernel.root_dir') . '/gifnoc/';
  2585.         if (!file_exists($config_dir)) {
  2586.             mkdir($config_dir, 0777, true);
  2587.         }
  2588. //        $path = $this->container->getParameter('kernel.root_dir') . '/gifnoc/givnocppa.json';
  2589. //        $content = file_exists($path) ? file_get_contents($path) : null;
  2590.         $content = [];
  2591.         $configJson = array();
  2592.         if ($content)
  2593.             $configJson = json_decode($content, true);
  2595.         $configJsonOld = $configJson;
  2596. //        if($configJson)
  2597. //        {
  2598. //
  2599. //        }
  2600. //        else
  2601.         {
  2602.             $configJson['appVersion'] = GeneralConstant::ENTITY_APP_VERSION;
  2603.             $configJson['dataBaseSchemaUpdateFlag'] = GeneralConstant::ENTITY_APP_FLAG_TRUE;
  2604.             $configJson['initiateDataBaseFlag'] = GeneralConstant::ENTITY_APP_FLAG_FALSE;
  2605.             $configJson['initiateDataBaseFlagByGoc'] = array();
  2606.             $configJson['motherLode'] = "http://innobd.com";
  2607.             foreach ($gocDataList as $gocId => $entry) {
  2608.                 $configJson['initiateDataBaseFlagByGoc'][$gocId . "_" . $entry['appId']] = GeneralConstant::ENTITY_APP_FLAG_TRUE;
  2609.             }
  2610.         }
  2612.         //now check if database shcema update is true
  2613. //        if($configJson['dataBaseSchemaUpdateFlag']==GeneralConstant::ENTITY_APP_FLAG_TRUE)
  2614.         if (1) //temporary overwrite all
  2615.         {
  2617.             //if goclist is not empty switch to each company dbase and schema update
  2618. //            if(!empty($gocDataList))
  2619.             if (1) {
  2620.                 foreach ($gocDataList as $gocId => $entry) {
  2622.                     if ($configJson['initiateDataBaseFlagByGoc'][$gocId . "_" . $entry['appId']] == GeneralConstant::ENTITY_APP_FLAG_TRUE) {
  2624.                         $connector = $this->container->get('application_connector');
  2625.                         $connector->resetConnection(
  2626.                             'default',
  2627.                             $gocDataList[$gocId]['dbName'],
  2628.                             $gocDataList[$gocId]['dbUser'],
  2629.                             $gocDataList[$gocId]['dbPass'],
  2630.                             $gocDataList[$gocId]['dbHost'],
  2631.                             $reset = true);
  2632.                         $em = $this->getDoctrine()->getManager();
  2634. //                        $iv = '1234567812345678';
  2635. //                        $pass = $hash;
  2636. //
  2637. //                        $str = $str . 'YmLRocksLikeABoss';
  2638. //                        $data = openssl_encrypt($str, "AES-128-CBC", $pass, OPENSSL_RAW_DATA, $iv);
  2639. //
  2640. //                        $decrypted = openssl_decrypt(base64_decode(base64_encode($data)), "AES-128-CBC", $hash, OPENSSL_RAW_DATA, $iv);
  2641. //
  2644.                         //now 1st of all lets get the Existing routes
  2645.                         $extRoutesById = [];
  2646.                         $extRoutesByRoute = [];
  2647.                         $modules = $em->getRepository("ApplicationBundle:SysModule")
  2648.                             ->findBy(
  2649.                                 array()
  2650.                             );
  2651.                         $module_data = [];
  2652.                         foreach ($modules as $mod) {
  2653.                             $dt = array(
  2654.                                 'id' => $mod->getModuleId(),
  2655.                                 'route' => $mod->getModuleRoute(),
  2656.                                 'name' => $mod->getModuleName(),
  2657.                                 'parentId' => $mod->getParentId(),
  2658.                                 'level' => $mod->getLevel(),
  2659.                                 'eFA' => $mod->getEnabledForAll(),
  2660.                             );
  2661.                             $extRoutesById[$mod->getModuleId()] = $dt;
  2662.                             $extRoutesByRoute[$mod->getModuleRoute()] = $dt;
  2664.                         }
  2665.                         //now clear the module table
  2666.                         $get_kids_sql = "truncate `sys_module` ; ";
  2667.                         $stmt = $em->getConnection()->prepare($get_kids_sql);
  2668.                         $stmt->execute();
  2669.                         $stmt->closeCursor();
  2671.                         $newRoutes = ModuleConstant::$moduleList;
  2672.                         $newRoutesByRoute = [];
  2673.                         foreach ($newRoutes as $mod) {
  2675.                             $new = new SysModule();
  2676.                             $new->setModuleId($mod['id']);
  2677.                             $new->setModuleRoute($mod['route']);
  2678.                             $new->setModuleName($mod['name']);
  2679.                             $new->setParentId($mod['parentId']);
  2680.                             $new->setlevel($mod['level']);
  2681.                             $new->setEnabledForAll($mod['eFA']);
  2682.                             $new->setStatus(isset($mod['status']) ? $mod['status'] : GeneralConstant::ACTIVE);
  2684. //                $new->set(GeneralConstant::ACTIVE);
  2685.                             $em->persist($new);
  2687.                             $newRoutesByRoute[$mod['route']] = $mod;
  2690.                         }
  2691.                         $em->flush();
  2694.                         //now lets get the ext modules for positions
  2695.                         $depPosDefModules = $em->getRepository("ApplicationBundle:SysDeptPositionDefaultModule")
  2696.                             ->findBy(
  2697.                                 array()
  2698.                             );
  2699.                         foreach ($depPosDefModules as $defmod) {
  2700.                             $moduleList = json_decode($defmod->getModuleIds());
  2701.                             $newModuleList = [];
  2702.                             foreach ($moduleList as $oldId) {
  2703.                                 $newId = 0;
  2704.                                 if (isset($extRoutesById[$oldId])) {
  2705.                                     if (isset($newRoutesByRoute[$extRoutesById[$oldId]['route']])) {
  2706.                                         $newModuleList[] = 1 * $newRoutesByRoute[$extRoutesById[$oldId]['route']]['id'];
  2707.                                     }
  2708.                                 }
  2709.                             }
  2710.                             $defmod->setModuleIds(json_encode($newModuleList));
  2711.                             $em->flush();
  2714.                         }
  2715.                         //now users
  2717.                         $users = $em->getRepository("ApplicationBundle:SysUser")
  2718.                             ->findBy(
  2719.                                 array()
  2720.                             );
  2721.                         foreach ($users as $defmod) {
  2722.                             $moduleList = json_decode($defmod->getModuleIds());
  2723.                             if ($moduleList == null)
  2724.                                 continue;
  2725.                             $newModuleList = [];
  2726.                             foreach ($moduleList as $oldId) {
  2727.                                 $newId = 0;
  2728.                                 if (isset($extRoutesById[$oldId])) {
  2729.                                     if (isset($newRoutesByRoute[$extRoutesById[$oldId]['route']])) {
  2730.                                         $newModuleList[] = 1 * $newRoutesByRoute[$extRoutesById[$oldId]['route']]['id'];
  2731.                                     }
  2732.                                 }
  2733.                             }
  2734.                             $defmod->setModuleIds(json_encode($newModuleList));
  2735.                             $em->flush();
  2738.                         }
  2741.                         $module_data = [];
  2744. //                        $tool = new SchemaTool($em);
  2745. //
  2746. //                        $classes = $em->getMetadataFactory()->getAllMetadata();
  2747. ////                    $tool->createSchema($classes);
  2748. //                        $tool->updateSchema($classes);
  2749. //
  2750. //                        //new for updating app id
  2751. //                        $get_kids_sql = "UPDATE `company` set app_id=".$entry['appId']." ;
  2752. //                                        UPDATE `sys_user` set app_id=".$entry['appId']." ;";
  2753. //                        $stmt = $em->getConnection()->prepare($get_kids_sql);
  2754. //                        $stmt->execute();
  2755. //                        $stmt->closeCursor();
  2756. //
  2757. //                        $configJson['initiateDataBaseFlagByGoc'][$gocId."_".$entry['appId']]=GeneralConstant::ENTITY_APP_FLAG_FALSE;
  2759.                         //this is for large amount of goc we will see  later
  2760. //                        file_put_contents($path, json_encode($configJson));//overwrite
  2761. //                        return $this->redirectToRoute('update_database_schema');
  2763.                     }
  2766.                 }
  2767.             } else {
  2768.                 $em = $this->getDoctrine()->getManager();
  2770.                 $tool = new SchemaTool($em);
  2771. //                    $classes = array(
  2772. //                        $em->getClassMetadata('Entities\User'),
  2773. //                        $em->getClassMetadata('Entities\Profile')
  2774. //                    );
  2775.                 $classes = $em->getMetadataFactory()->getAllMetadata();
  2776. //                    $tool->createSchema($classes);
  2777.                 $tool->updateSchema($classes);
  2778.             }
  2781.         }
  2782.         $allSchemaUpdateDone = 1;
  2784.         foreach ($configJson['initiateDataBaseFlagByGoc'] as $flag) {
  2785.             if ($flag == GeneralConstant::ENTITY_APP_FLAG_TRUE)
  2786.                 $allSchemaUpdateDone = 0;
  2787.         }
  2788.         if ($allSchemaUpdateDone == 1)
  2789.             $configJson['dataBaseSchemaUpdateFlag'] = GeneralConstant::ENTITY_APP_FLAG_FALSE;
  2792.         ///last
  2793. //        file_put_contents($path, json_encode($configJson));//overwrite
  2796.         return new Response(json_encode($configJsonOld));
  2797.     }
  2799.     public function CheckTimeStampAction(Request $request)
  2800.     {
  2801.         $message = "";
  2803.         $gocList = [];
  2804.         $outputList = [];
  2805.         $toConvertDateStrFromQry = $request->query->get('convDate', '');
  2806.         $currentRegionalDateStrFromQry = $request->query->get('currDate', '');
  2807.         $convertedTime = MiscActions::ConvertRegionalTimeToServerTime($currentRegionalDateStrFromQry, $toConvertDateStrFromQry);
  2809.         $currentServerTime = new \DateTime();
  2811.         $em = $this->getDoctrine()->getManager('company_group');
  2812.         $em->getConnection()->connect();
  2815.         ///last
  2816. //        file_put_contents($path, json_encode($configJson));//overwrite
  2819.         return new Response(json_encode(array(
  2820.             'convertedTime' => $convertedTime->format('Y-m-d h:i:s'),
  2821.             'convertedTimeUnix' => $convertedTime->format('U'),
  2822.             'convertedTimeRFC' => $convertedTime->format(DATE_RFC822),
  2823.             'currentServerTime' => $currentServerTime->format('Y-m-d h:i:s'),
  2824.             'currentServerTimeRFC' => $currentServerTime->format(DATE_RFC822),
  2825.             'currentServerTimeUnix' => $currentServerTime->format('U'),
  2828.         )));
  2829.     }
  2831.     public function GetUsersFromCentralServerAction(Request $request, $id = 0)
  2832.     {
  2834.     }
  2836.     public function UpdateCompanyDataToCentralServerAction(Request $request, $id = 0)
  2837.     {
  2838.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  2841.         $post = $request;
  2842.         $serverList = GeneralConstant::$serverListById;
  2843.         if ($systemType == '_CENTRAL_') {
  2845.             $em_goc = $this->getDoctrine()->getManager('company_group');
  2848.             //            'company_id' => $company->getId(),
  2849.             //                            'app_id' => $entry['appId'],
  2850.             //                            'dark_vibrant' => $company->getDarkVibrant(),
  2851.             //                            'light_vibrant' => $company->getLightVibrant(),
  2852.             //                            'vibrant' => $company->getVibrant(),
  2853.             //                            'company_type' => $company->getCompanyType(),
  2854.             //                            'company_name' => $company->getName(),
  2855.             //                            'company_address' => $company->getAddress(),
  2856.             //                            'company_s_address' => $company->getShippingAddress(),
  2857.             //                            'company_b_address' => $company->getBillingAddress(),
  2858.             //                            'company_image' => $company->getImage(),
  2859.             //                            'company_motto' => $company->getMotto(),
  2860.             //                            'company_i_footer' => $company->getInvoiceFooter(),
  2861.             //                            'company_g_footer' => $company->getGeneralFooter(),
  2862.             //                            'company_tin' => $company->getCompanyTin(),
  2863.             //                            'company_bin' => $company->getCompanyBin(),
  2864.             //                            'company_reg' => $company->getCompanyReg(),
  2865.             //                            'company_tl' => $company->getCompanyTl(),
  2866.             //                            'sms_enabled' => $company->getSmsNotificationEnabled(),
  2867.             //                            'sms_settings' => $company->getSmsSettings(),
  2868.             //                            'file'=>$output
  2869.             $findByQuery = array(
  2870. //                'active' => 1
  2871.                 'appId' => $post->get('app_id')
  2872.             );
  2874.             $goc = $em_goc->getRepository("CompanyGroupBundle:CompanyGroup")
  2875.                 ->findOneBy($findByQuery);
  2877.             if (!$goc)
  2878.                 $goc = new CompanyGroup();
  2880.             $goc->setName($post->get('company_name'));
  2881.             $goc->setAppId($post->get('app_id'));
  2882. //            $goc->setCompanyType($post->get('company_type'));
  2883.             $goc->setAddress($post->get('address'));
  2884. //            $goc->setDarkVibrant($post->get('dark_vibrant'));
  2885. //            $goc->setLightVibrant($post->get('light_vibrant'));
  2886. //            $goc->setVibrant($post->get('vibrant'));
  2887.             $goc->setShippingAddress($post->get('s_address'));
  2888.             $goc->setBillingAddress($post->get('b_address'));
  2889.             $goc->setMotto($post->get('motto'));
  2890.             $goc->setInvoiceFooter($post->get('i_footer'));
  2891.             $goc->setGeneralFooter($post->get('g_footer'));
  2892.             $goc->setCompanyReg($post->get('company_reg', ''));
  2893.             $goc->setCompanyTin($post->get('company_tin', ''));
  2894.             $goc->setCompanyBin($post->get('company_bin', ''));
  2895.             $goc->setCompanyTl($post->get('company_tl', ''));
  2896.             $goc->setCompanyGroupServerId($post->get('companyGroupServerId', ''));
  2897.             $goc->setCompanyGroupServerAddress($post->get('companyGroupServerAddress', ''));
  2898.             $goc->setCompanyGroupServerPort($post->get('companyGroupServerPort', ''));
  2899.             $goc->setCompanyGroupServerHash($post->get('companyGroupServerHash', ''));
  2900. //            $goc->setSmsNotificationEnabled($post->get('sms_enabled'));
  2901. //            $goc->setSmsSettings($post->get('sms_settings'));
  2904.             foreach ($request->files as $uploadedFile) {
  2905. //            if($uploadedFile->getImage())
  2906. //                var_dump($uploadedFile->getFile());
  2907. //                var_dump($uploadedFile);
  2909.                 if ($uploadedFile != null) {
  2911.                     $fileName = 'company_image' . $post->get('app_id') . '.' . $uploadedFile->guessExtension();
  2912.                     $path = $fileName;
  2913.                     $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/CompanyImage/';
  2915.                     if ($goc->getImage() != null && $goc->getImage() != '' && file_exists($this->container->getParameter('kernel.root_dir') . '/../web' . $goc->getImage())) {
  2917.                         unlink($this->container->getParameter('kernel.root_dir') . '/../web' . $goc->getImage());
  2920.                     }
  2922.                     if (!file_exists($upl_dir)) {
  2923.                         mkdir($upl_dir, 0777, true);
  2924.                     }
  2925.                     $file = $uploadedFile->move($upl_dir, $path);
  2926.                     if ($path != "")
  2927.                         $goc->setImage('/uploads/CompanyImage/' . $path);
  2928.                 }
  2930.             }
  2933.             $em_goc->persist($goc);
  2934.             $em_goc->flush();
  2937.             return new JsonResponse([]);
  2939.         } else {
  2940.             $em = $this->getDoctrine()->getManager('company_group');
  2941.             $em->getConnection()->connect();
  2942.             $connected = $em->getConnection()->isConnected();
  2945.             $gocDataList = [];
  2946.             if ($connected) {
  2947.                 $findByQuery = array(
  2948.                     'active' => 1
  2949.                 );
  2952.                 $gocList = $this->getDoctrine()->getManager('company_group')
  2953.                     ->getRepository("CompanyGroupBundle:CompanyGroup")
  2954.                     ->findBy($findByQuery);
  2957.                 foreach ($gocList as $entry) {
  2958.                     $d = array(
  2959.                         'name' => $entry->getName(),
  2960.                         'id' => $entry->getId(),
  2961.                         'image' => $entry->getImage(),
  2962.                         'companyGroupHash' => $entry->getCompanyGroupHash(),
  2963.                         'companyGroupServerId' => $entry->getCompanyGroupServerId(),
  2964.                         'dbName' => $entry->getDbName(),
  2965.                         'dbUser' => $entry->getDbUser(),
  2966.                         'dbPass' => $entry->getDbPass(),
  2967.                         'dbHost' => $entry->getDbHost(),
  2968.                         'appId' => $entry->getAppId(),
  2969.                         'companyRemaining' => $entry->getCompanyRemaining(),
  2970.                         'companyAllowed' => $entry->getCompanyAllowed(),
  2971.                     );
  2972.                     $gocDataList[$entry->getId()] = $d;
  2973.                 }
  2976.                 foreach ($gocDataList as $gocId => $entry) {
  2979.                     $connector = $this->container->get('application_connector');
  2980.                     $connector->resetConnection(
  2981.                         'default',
  2982.                         $gocDataList[$gocId]['dbName'],
  2983.                         $gocDataList[$gocId]['dbUser'],
  2984.                         $gocDataList[$gocId]['dbPass'],
  2985.                         $gocDataList[$gocId]['dbHost'],
  2986.                         $reset = true);
  2987.                     $em = $this->getDoctrine()->getManager();
  2988.                     $company = $this->getDoctrine()
  2989.                         ->getRepository('ApplicationBundle:Company')
  2990.                         ->findOneBy(
  2991.                             array()
  2992.                         );
  2995.                     $output = '';
  2997.                     $file = $this->container->getParameter('kernel.root_dir') . '/../web' . $company->getImage(); //<-- Path could be relative
  2999.                     if (file_exists($file)) {
  3000. //                        $file = new \CURLFile($this->container->getParameter('kernel.root_dir') . '/../web/uploads/CompanyImage/' . $company->getImage()); //<-- Path could be relative
  3001.                         $mime = mime_content_type($file);
  3002.                         $info = pathinfo($file);
  3003.                         $name = $info['basename'];
  3004.                         if (strpos($mime, 'image') !== false) {
  3005.                             $output = new \CURLFile($file, $mime, $name);
  3006.                         }
  3008.                     }
  3010.                     $post_fields = array(
  3013.                         'company_id' => $company->getId(),
  3014.                         'app_id' => $entry['appId'],
  3015.                         'dark_vibrant' => $company->getDarkVibrant(),
  3016.                         'light_vibrant' => $company->getLightVibrant(),
  3017.                         'vibrant' => $company->getVibrant(),
  3018.                         'company_type' => $company->getCompanyType(),
  3019.                         'company_name' => $company->getName(),
  3020.                         'company_address' => $company->getAddress(),
  3021.                         'company_s_address' => $company->getShippingAddress(),
  3022.                         'company_b_address' => $company->getBillingAddress(),
  3023.                         'company_image' => $company->getImage(),
  3024.                         'company_motto' => $company->getMotto(),
  3025.                         'company_i_footer' => $company->getInvoiceFooter(),
  3026.                         'company_g_footer' => $company->getGeneralFooter(),
  3027.                         'company_tin' => $company->getCompanyTin(),
  3028.                         'company_bin' => $company->getCompanyBin(),
  3029.                         'company_reg' => $company->getCompanyReg(),
  3030.                         'company_tl' => $company->getCompanyTl(),
  3031.                         'sms_enabled' => $company->getSmsNotificationEnabled(),
  3032.                         'sms_settings' => $company->getSmsSettings(),
  3033.                         'companyGroupHash' => $company->getCompanyHash(),
  3034.                         'companyGroupServerId' => $entry['companyGroupServerId'],
  3035.                         'companyGroupServerAddress' => $serverList[$entry['companyGroupServerId']]['absoluteUrl'],
  3036.                         'companyGroupServerHash' => $serverList[$entry['companyGroupServerId']]['serverMarker'],
  3037.                         'companyGroupServerPort' => $request->server->get("SERVER_PORT"),
  3038.                         'file' => $output
  3039.                     );
  3042.                     $urlToCall = GeneralConstant::HONEYBEE_CENTRAL_SERVER . '/UpdateCompanyDataToCentralServer';
  3044.                     $curl = curl_init();
  3045.                     curl_setopt_array($curl, array(
  3046.                         CURLOPT_RETURNTRANSFER => 1,
  3047.                         CURLOPT_POST => 1,
  3048.                         CURLOPT_URL => $urlToCall,
  3049.                         CURLOPT_CONNECTTIMEOUT => 10,
  3050.                         CURLOPT_SSL_VERIFYPEER => false,
  3051.                         CURLOPT_SSL_VERIFYHOST => false,
  3052.                         CURLOPT_HTTPHEADER => array(),
  3053.                         CURLOPT_POSTFIELDS => $post_fields
  3054.                     ));
  3056.                     $retData = curl_exec($curl);
  3057.                     $errData = curl_error($curl);
  3058.                     curl_close($curl);
  3061.                 }
  3062.             }
  3065.             return new JsonResponse([]);
  3066.         }
  3069.     }
  3071.     public function GetAppListFromCentralServerAction(Request $request, $id = 0)
  3072.     {
  3074.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  3075.         $appIds = $request->get('appIds', []);
  3076.         $appId = $request->get('appId', 0);
  3077.         if (is_string($appIds)) $appIds = json_decode($appIds, true);
  3078.         if ($appIds == null) $appIds = [];
  3079.         if ($appId != 0)
  3080.             $appIds[] = $appId;
  3083.         if ($systemType == '_CENTRAL_') {
  3084.             $em = $this->getDoctrine()->getManager('company_group');
  3085.             $em->getConnection()->connect();
  3086.             $connected = $em->getConnection()->isConnected();
  3088.             $gocDataList = [];
  3089.             if ($connected) {
  3090.                 $findByQuery = array(
  3091.                     'active' => 1
  3092.                 );
  3093.                 if ($appIds != '_ALL_' && $appIds != [])
  3094.                     $findByQuery['appId'] = $appIds;
  3095.                 $gocList = $this->getDoctrine()->getManager('company_group')
  3096.                     ->getRepository("CompanyGroupBundle:CompanyGroup")
  3097.                     ->findBy($findByQuery);
  3100.                 foreach ($gocList as $entry) {
  3101.                     $d = array(
  3102.                         'name' => $entry->getName(),
  3103.                         'id' => $entry->getId(),
  3104.                         'image' => $entry->getImage(),
  3105.                         'companyGroupHash' => $entry->getCompanyGroupHash(),
  3106.                         'dbName' => $entry->getDbName(),
  3107.                         'dbUser' => $entry->getDbUser(),
  3108.                         'dbPass' => $entry->getDbPass(),
  3109.                         'dbHost' => $entry->getDbHost(),
  3110.                         'appId' => $entry->getAppId(),
  3111.                         'companyRemaining' => $entry->getCompanyRemaining(),
  3112.                         'companyAllowed' => $entry->getCompanyAllowed(),
  3113.                     );
  3114.                     $gocDataList[$entry->getId()] = $d;
  3115.                 }
  3116.             }
  3118.             return new JsonResponse($gocDataList);
  3120.         } else {
  3123.             $urlToCall = GeneralConstant::HONEYBEE_CENTRAL_SERVER . '/GetAppListFromCentralServer';
  3125.             $curl = curl_init();
  3126.             curl_setopt_array($curl, array(
  3127.                 CURLOPT_RETURNTRANSFER => 1,
  3128.                 CURLOPT_URL => $urlToCall,
  3129.                 CURLOPT_CONNECTTIMEOUT => 10,
  3130.                 CURLOPT_SSL_VERIFYPEER => false,
  3131.                 CURLOPT_SSL_VERIFYHOST => false,
  3132.                 CURLOPT_HTTPHEADER => array(
  3133.                     "Accept: application/json",
  3134.                 ),
  3135.                 //                        CURLOPT_USERAGENT => 'InnoPM',
  3137.                 CURLOPT_POSTFIELDS => http_build_query([
  3138.                     'appIds' => $appIds
  3139.                 ])
  3140.             ));
  3142. //        $headers = array(
  3143. //            "Accept: application/json",
  3144. //        );
  3145. //        curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
  3146. ////for debug only!
  3147. //        curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
  3148. //        curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
  3150.             $retData = curl_exec($curl);
  3151.             $errData = curl_error($curl);
  3152.             curl_close($curl);
  3153.             return new JsonResponse(json_decode($retData, true));
  3154.         }
  3157.     }
  3159.     public function GetTaskListForMenuAction(Request $request, $id = 0)
  3160.     {
  3162.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  3164.         $session = $request->getSession();
  3165.         $appIds = $request->get('appIds', []);
  3166.         $appId = $request->get('appId', 0);
  3167.         if (is_string($appIds)) $appIds = json_decode($appIds, true);
  3168.         if ($appIds == null) $appIds = [];
  3169.         if ($appId != 0)
  3170.             $appIds[] = $appId;
  3173.         if ($systemType == '_CENTRAL_') {
  3174.             $em = $this->getDoctrine()->getManager('company_group');
  3175.             $em->getConnection()->connect();
  3176.             $connected = $em->getConnection()->isConnected();
  3178.             $gocDataList = [];
  3179.             if ($connected) {
  3180.                 $findByQuery = array(
  3181.                     'active' => 1
  3182.                 );
  3183.                 if ($appIds != '_ALL_' && $appIds != [])
  3184.                     $findByQuery['appId'] = $appIds;
  3185.                 $gocList = $this->getDoctrine()->getManager('company_group')
  3186.                     ->getRepository("CompanyGroupBundle:CompanyGroup")
  3187.                     ->findBy($findByQuery);
  3190.                 foreach ($gocList as $entry) {
  3191.                     $d = array(
  3192.                         'name' => $entry->getName(),
  3193.                         'id' => $entry->getId(),
  3194.                         'image' => $entry->getImage(),
  3195.                         'companyGroupHash' => $entry->getCompanyGroupHash(),
  3196.                         'dbName' => $entry->getDbName(),
  3197.                         'dbUser' => $entry->getDbUser(),
  3198.                         'dbPass' => $entry->getDbPass(),
  3199.                         'dbHost' => $entry->getDbHost(),
  3200.                         'appId' => $entry->getAppId(),
  3201.                         'companyRemaining' => $entry->getCompanyRemaining(),
  3202.                         'companyAllowed' => $entry->getCompanyAllowed(),
  3203.                     );
  3204.                     $gocDataList[$entry->getId()] = $d;
  3205.                 }
  3206.             }
  3208.             return new JsonResponse($gocDataList);
  3210.         } else {
  3212.             $findByQuery = array(
  3213.                 'userId' => $session->get(UserConstants::USER_ID, 0)
  3214.             );
  3216.             $employee = $this->getDoctrine()->getManager()
  3217.                 ->getRepository("ApplicationBundle:Employee")
  3218.                 ->findOneBy($findByQuery);
  3220.             $assignedTaskList = array();
  3221.             $currentlyWorkingTaskList = array();
  3224.             if ($employee) {
  3226.                 $findByQuery = array(
  3227.                     'assignedTo' => $employee->getEmployeeId(),
  3228.                     'hasChild' => [0, null]
  3229.                 );
  3231.                 $assignedTaskListData = $this->getDoctrine()->getManager()
  3232.                     ->getRepository("ApplicationBundle:PlanningItem")
  3233.                     ->findBy($findByQuery);
  3235.                 $findByQuery = array(
  3236.                     'employeeId' => $employee->getEmployeeId(),
  3238.                 );
  3239.                 $currentlyWorkingTaskListData = $this->getDoctrine()->getManager()
  3240.                     ->getRepository("ApplicationBundle:TaskLog")
  3241.                     ->findBy($findByQuery);
  3243.                 foreach ($assignedTaskListData as $entry) {
  3244.                     $dt = array(
  3245.                         'description' => $entry->getDescription(),
  3246.                         'urgency' => $entry->getUrgency()
  3248.                     );
  3250.                     $assignedTaskList[] = $dt;
  3252.                 }
  3253.                 foreach ($currentlyWorkingTaskListData as $entry) {
  3254.                     $dt = array();
  3256.                     $currentlyWorkingTaskList[] = $dt;
  3258.                 }
  3261.             }
  3264.             return new JsonResponse(array(
  3265.                 'assignedTaskList' => $assignedTaskList,
  3266.                 'currentlyWorkingTaskList' => $currentlyWorkingTaskList,
  3267.             ));
  3268.         }
  3271.     }
  3273.     public function SyncUserToCentralUserAction(Request $request)
  3274.     {
  3277.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  3280.         $post = $request;
  3281.         $globalIdsByAppIdAndUser = [];
  3282.         if ($systemType == '_CENTRAL_') {
  3284.             $userDataList = $request->get('userData', []);
  3286.             if (is_string($userDataList)) $userDataList = json_decode($userDataList, true);
  3287.             if ($userDataList == null) $userDataList = [];
  3289.             $em_goc = $this->getDoctrine()->getManager('company_group');
  3292.             //1st step get all company item ids and then check for global id null if its null then the
  3293. //            return new JsonResponse(
  3294. //                array(
  3295. //                    'userDataList' => $userDataList
  3296. //                )
  3297. //            );
  3299.             ////ITEMGROUPS
  3300.             foreach ($userDataList as $k => $cwa) {
  3302.                 $centralUser = $em_goc
  3303.                     ->getRepository("CompanyGroupBundle:EntityApplicantDetails")
  3304.                     ->findOneBy(
  3305.                         array(
  3306.                             'applicantId' => $cwa['getGlobalId']
  3307.                         )
  3308.                     );
  3310.                 if ($centralUser) {
  3311.                     $centralUser->setFirstname($cwa['getFirstname'] ?? null);
  3312.                     $centralUser->setLastname($cwa['getLastname'] ?? null);
  3313.                     $centralUser->setEmail($cwa['getEmail'] ?? null);
  3314.                     $centralUser->setOAuthEmail($cwa['getOAuthEmail'] ?? null);
  3315.                     $centralUser->setPhone($cwa['getPhone'] ?? null);
  3316.                     $centralUser->setNid($cwa['getNid'] ?? null);
  3317.                     $centralUser->setSex($cwa['getSex'] ?? null);
  3318.                     $centralUser->setBlood($cwa['getBlood'] ?? null);
  3319.                     $centralUser->setFather($cwa['getFather'] ?? null);
  3320.                     $centralUser->setMother($cwa['getMother'] ?? null);
  3321.                     $centralUser->setSpouse($cwa['getSpouse'] ?? null);
  3322.                     $centralUser->setCurrAddr($cwa['getCurrAddr'] ?? null);
  3323.                     $centralUser->setPermAddr($cwa['getPermAddr'] ?? null);
  3324.                     $centralUser->setPhoneCountryCode($cwa['getPhoneCountryCode'] ?? null);
  3325.                     $centralUser->setEmpType($cwa['getEmpType'] ?? null);
  3326.                     $centralUser->setTin($cwa['getTin'] ?? null);
  3327.                     $centralUser->setDept($cwa['getDept'] ?? null);
  3328.                     $centralUser->setDesg($cwa['getDesg'] ?? null);
  3329.                     $centralUser->setBranch($cwa['getBranch'] ?? null);
  3330.                     $centralUser->setWeeklyHoliday($cwa['getWeeklyHoliday'] ?? null);
  3331.                     $centralUser->setSupervisor($cwa['getSupervisor'] ?? null);
  3333.                     $centralUser->setDob(!empty($cwa['getDob']) ? new \DateTime($cwa['getDob']) : null);
  3334.                     $centralUser->setJoiningDate(!empty($cwa['getJoiningDate']) ? new \DateTime($cwa['getJoiningDate']) : null);
  3335.                     $centralUser->setEmpValidTill(!empty($cwa['getEmpValidTill']) ? new \DateTime($cwa['getEmpValidTill']) : null);
  3336.                     $centralUser->setTinValidTill(!empty($cwa['getTinValidTill']) ? new \DateTime($cwa['getTinValidTill']) : null);
  3337.                     $centralUser->setMedInsValidTill(!empty($cwa['getMedInsValidTill']) ? new \DateTime($cwa['getMedInsValidTill']) : null);
  3338.                 } else {
  3339.                     $qry = $em_goc->getRepository('CompanyGroupBundle:EntityApplicantDetails')
  3340.                         ->createQueryBuilder('m')
  3341.                         ->where("m.email like '" . $cwa['getEmail'] . "'");
  3342.                     if ($cwa['getOAuthEmail'] != '' && $cwa['getOAuthEmail'] != null)
  3343.                         $qry->orWhere("m.oAuthEmail like '" . $cwa['getOAuthEmail'] . "'");
  3344.                     if ($cwa['getPhoneNumber'] != '' && $cwa['getPhoneNumber'] != null)
  3345.                         $qry->orWhere("m.phone like '" . $cwa['getPhoneNumber'] . "'");
  3347.                     $targets = $qry->getQuery()
  3348.                         ->setMaxResults(1)
  3349.                         ->getResult();
  3352.                     if (!empty($targets))
  3353.                         $centralUser = $targets[0];
  3354.                 }
  3357.                 if ($centralUser) {
  3358.                     $centralUser->setFirstname($cwa['getFirstname'] ?? null);
  3359.                     $centralUser->setLastname($cwa['getLastname'] ?? null);
  3360.                     $centralUser->setEmail($cwa['getEmail'] ?? null);
  3361.                     $centralUser->setOAuthEmail($cwa['getOAuthEmail'] ?? null);
  3362.                     $centralUser->setPhone($cwa['getPhone'] ?? null);
  3363.                     $centralUser->setNid($cwa['getNid'] ?? null);
  3364.                     $centralUser->setSex($cwa['getSex'] ?? null);
  3365.                     $centralUser->setBlood($cwa['getBlood'] ?? null);
  3366.                     $centralUser->setFather($cwa['getFather'] ?? null);
  3367.                     $centralUser->setMother($cwa['getMother'] ?? null);
  3368.                     $centralUser->setSpouse($cwa['getSpouse'] ?? null);
  3369.                     $centralUser->setCurrAddr($cwa['getCurrAddr'] ?? null);
  3370.                     $centralUser->setPermAddr($cwa['getPermAddr'] ?? null);
  3371.                     $centralUser->setPhoneCountryCode($cwa['getPhoneCountryCode'] ?? null);
  3372.                     $centralUser->setEmpType($cwa['getEmpType'] ?? null);
  3373.                     $centralUser->setTin($cwa['getTin'] ?? null);
  3374.                     $centralUser->setDept($cwa['getDept'] ?? null);
  3375.                     $centralUser->setDesg($cwa['getDesg'] ?? null);
  3376.                     $centralUser->setBranch($cwa['getBranch'] ?? null);
  3377.                     $centralUser->setWeeklyHoliday($cwa['getWeeklyHoliday'] ?? null);
  3378.                     $centralUser->setSupervisor($cwa['getSupervisor'] ?? null);
  3380.                     $centralUser->setDob(!empty($cwa['getDob']) ? new \DateTime($cwa['getDob']) : null);
  3381.                     $centralUser->setJoiningDate(!empty($cwa['getJoiningDate']) ? new \DateTime($cwa['getJoiningDate']) : null);
  3382.                     $centralUser->setEmpValidTill(!empty($cwa['getEmpValidTill']) ? new \DateTime($cwa['getEmpValidTill']) : null);
  3383.                     $centralUser->setTinValidTill(!empty($cwa['getTinValidTill']) ? new \DateTime($cwa['getTinValidTill']) : null);
  3384.                     $centralUser->setMedInsValidTill(!empty($cwa['getMedInsValidTill']) ? new \DateTime($cwa['getMedInsValidTill']) : null);
  3385.                 } else
  3386.                     $centralUser = new EntityApplicantDetails();
  3389. //
  3390. //                $getters = array_filter(get_class_methods($data), function ($method) {
  3391. //                    return 'get' === substr($method, 0, 3);
  3392. //                });
  3395.                 // Manual mapping starts here
  3396.                 $centralUser->setFirstname($cwa['getFirstname'] ?? null);
  3397.                 $centralUser->setLastname($cwa['getLastname'] ?? null);
  3398.                 $centralUser->setEmail($cwa['getEmail'] ?? null);
  3399.                 $centralUser->setOAuthEmail($cwa['getOAuthEmail'] ?? null);
  3400.                 $centralUser->setPhone($cwa['getPhone'] ?? null);
  3401.                 $centralUser->setNid($cwa['getNid'] ?? null);
  3402.                 $centralUser->setSex($cwa['getSex'] ?? null);
  3403.                 $centralUser->setBlood($cwa['getBlood'] ?? null);
  3404.                 $centralUser->setFather($cwa['getFather'] ?? null);
  3405.                 $centralUser->setMother($cwa['getMother'] ?? null);
  3406.                 $centralUser->setSpouse($cwa['getSpouse'] ?? null);
  3407.                 $centralUser->setCurrAddr($cwa['getCurrAddr'] ?? null);
  3408.                 $centralUser->setPermAddr($cwa['getPermAddr'] ?? null);
  3409.                 $centralUser->setPhoneCountryCode($cwa['getPhoneCountryCode'] ?? null);
  3410.                 $centralUser->setEmpType($cwa['getEmpType'] ?? null);
  3411.                 $centralUser->setTin($cwa['getTin'] ?? null);
  3412.                 $centralUser->setDept($cwa['getDept'] ?? null);
  3413.                 $centralUser->setDesg($cwa['getDesg'] ?? null);
  3414.                 $centralUser->setBranch($cwa['getBranch'] ?? null);
  3415.                 $centralUser->setWeeklyHoliday($cwa['getWeeklyHoliday'] ?? null);
  3416.                 $centralUser->setSupervisor($cwa['getSupervisor'] ?? null);
  3418. // Date fields
  3419.                 $centralUser->setDob(!empty($cwa['getDob']) ? new \DateTime($cwa['getDob']) : null);
  3420.                 $centralUser->setJoiningDate(!empty($cwa['getJoiningDate']) ? new \DateTime($cwa['getJoiningDate']) : null);
  3421.                 $centralUser->setEmpValidTill(!empty($cwa['getEmpValidTill']) ? new \DateTime($cwa['getEmpValidTill']) : null);
  3422.                 $centralUser->setTinValidTill(!empty($cwa['getTinValidTill']) ? new \DateTime($cwa['getTinValidTill']) : null);
  3423.                 $centralUser->setMedInsValidTill(!empty($cwa['getMedInsValidTill']) ? new \DateTime($cwa['getMedInsValidTill']) : null);
  3425. // Continue mapping more fields as needed...
  3428.                 $userAppIds = json_decode($centralUser->getUserAppIds(), true);
  3429.                 $userTypesByAppIds = json_decode($centralUser->getUserTypesByAppIds(), true);
  3430.                 if ($userAppIds == null) $userAppIds = [];
  3431.                 if ($userTypesByAppIds == null) $userTypesByAppIds = [];
  3433.                 $userAppIds = array_merge($userAppIds, array_diff([$cwa['getUserAppId']], $userAppIds));
  3435.                 if (!isset($userTypesByAppIds[$cwa['getUserAppId']])) {
  3436.                     $userTypesByAppIds[$cwa['getUserAppId']] = [];
  3437.                 }
  3438.                 $userTypesByAppIds[$cwa['getUserAppId']] = array_merge($userTypesByAppIds[$cwa['getUserAppId']], array_diff([$cwa['getUserType']], $userTypesByAppIds[$cwa['getUserAppId']]));
  3441.                 $userFullName = $cwa['getName'];
  3442.                 $userFullNameArr = explode(' ', $cwa['getName']);
  3443.                 $userFirstName = isset($userFullNameArr[0]) ? $userFullNameArr[0] : '';
  3445.                 $userLastName = '';
  3447.                 if (isset($userFullNameArr[1])) {
  3449.                     foreach ($userFullNameArr as $kunky => $chunky) {
  3450.                         if ($kunky != 0) {
  3451.                             $userLastName .= $chunky;
  3453.                         }
  3454.                         if ($kunky < count($userFullNameArr) - 1) {
  3455.                             $userLastName .= ' ';
  3457.                         }
  3460.                     }
  3461.                 }
  3464.                 $centralUser->setUserAppIds(json_encode($userAppIds));
  3465.                 $centralUser->setFirstname($userFirstName);
  3466.                 $centralUser->setLastname($userLastName);
  3467.                 $centralUser->setUserTypesByAppIds(json_encode($userTypesByAppIds));
  3469.                 $em_goc->persist($centralUser);
  3470.                 $em_goc->flush();
  3472.                 $uploadedFile = $request->files->get('file_' . $cwa['getUserAppId'] . '_' . $cwa['getUserId'], null);
  3473.                 {
  3474.                     //            if($uploadedFile->getImage())
  3475.                     //                var_dump($uploadedFile->getFile());
  3476.                     //                var_dump($uploadedFile);
  3478.                     if ($uploadedFile != null) {
  3480.                         $fileName = 'user_image' . $centralUser->getApplicantId() . '.' . $uploadedFile->guessExtension();
  3481.                         $path = $fileName;
  3482.                         $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/UserImage/';
  3484.                         if ($centralUser->getImage() != '' && $centralUser->getImage() != null && file_exists($this->container->getParameter('kernel.root_dir') . '/../web/' . $centralUser->getImage())) {
  3486.                             unlink($this->container->getParameter('kernel.root_dir') . '/../web/' . $centralUser->getImage());
  3489.                         }
  3491.                         if (!file_exists($upl_dir)) {
  3492.                             mkdir($upl_dir, 0777, true);
  3493.                         }
  3494.                         $file = $uploadedFile->move($upl_dir, $path);
  3495.                         if ($path != "")
  3496.                             $centralUser->setImage('uploads/UserImage/' . $path);
  3497.                     }
  3499.                 }
  3502.                 $em_goc->flush();
  3504.                 if (!isset($globalIdsByAppIdAndUser[$cwa['getUserAppId']]))
  3505.                     $globalIdsByAppIdAndUser[$cwa['getUserAppId']] = array();
  3507.                 $globalIdsByAppIdAndUser[$cwa['getUserAppId']][$cwa['getUserId']] =
  3508.                     array(
  3509.                         'gid' => $centralUser->getApplicantId()
  3510.                     );
  3512.                 $companies = $em_goc->getRepository('CompanyGroupBundle:CompanyGroup')->findBy([
  3513.                     'appId' => $userAppIds
  3514.                 ]);
  3516.                 $globalId = $cwa['getGlobalId'];
  3517.                 $userData = $userDataList;
  3519.                 $dataByServerId = [];
  3520.                 $gocDataListByAppId = [];
  3521.                 foreach ($companies as $entry) {
  3522.                     $gocDataListByAppId[$entry->getAppId()] = [
  3523.                         'dbName' => $entry->getDbName(),
  3524.                         'dbUser' => $entry->getDbUser(),
  3525.                         'dbPass' => $entry->getDbPass(),
  3526.                         'dbHost' => $entry->getDbHost(),
  3527.                         'serverAddress' => $entry->getCompanyGroupServerAddress(),
  3528.                         'port' => $entry->getCompanyGroupServerPort() ?: 80,
  3529.                         'appId' => $entry->getAppId(),
  3530.                         'serverId' => $entry->getCompanyGroupServerId(),
  3531.                     ];
  3532.                     if (!isset($dataByServerId[$entry->getCompanyGroupServerId()]))
  3533.                         $dataByServerId[$entry->getCompanyGroupServerId()] = array(
  3536.                             'serverId' => $entry->getCompanyGroupServerId(),
  3537.                             'serverAddress' => $entry->getCompanyGroupServerAddress(),
  3538.                             'port' => $entry->getCompanyGroupServerPort() ?: 80,
  3539.                             'appId' => $userAppIds,
  3541.                             'payload' => array(
  3542.                                 'globalId' => $globalId,
  3543.                                 'appId' => $userAppIds,
  3544.                                 'userData' => $userData,
  3545. //                                      'approvalHash' => $approvalHash
  3546.                             )
  3547.                         );
  3550.                 }
  3553.                 $urls = [];
  3556.                 foreach ($dataByServerId as $entry) {
  3557.                     $serverAddress = $entry['serverAddress'];
  3558.                     if (!$serverAddress) continue;
  3560.                     $syncUrl = $serverAddress . '/ReceiveUserFromCentral';
  3562.                     $payload = $entry['payload'];
  3564.                     $curl = curl_init();
  3565.                     curl_setopt_array($curl, [
  3566.                         CURLOPT_RETURNTRANSFER => true,
  3567.                         CURLOPT_POST => true,
  3568.                         CURLOPT_URL => $syncUrl,
  3569.                         CURLOPT_CONNECTTIMEOUT => 10,
  3570.                         CURLOPT_SSL_VERIFYPEER => false,
  3571.                         CURLOPT_SSL_VERIFYHOST => false,
  3572.                         CURLOPT_HTTPHEADER => [
  3573.                             'Accept: application/json',
  3574.                             'Content-Type: application/json'
  3575.                         ],
  3576.                         CURLOPT_POSTFIELDS => json_encode($payload)
  3577.                     ]);
  3579.                     $response = curl_exec($curl);
  3580.                     $err = curl_error($curl);
  3581.                     $httpCode = curl_getinfo($curl, CURLINFO_HTTP_CODE);
  3582.                     curl_close($curl);
  3584.                     if ($err) {
  3585.                         error_log("ERP Sync Error [Server: {$entry['serverAddress']}]: $err");
  3586.                     } else {
  3587.                         error_log("ERP Sync Success [HTTP $httpCode]: $response");
  3588.                     }
  3589.                 }
  3592.             }
  3593.             return new JsonResponse(
  3594.                 array(
  3595.                     'globalIdsData' => $globalIdsByAppIdAndUser
  3596.                 )
  3597.             );
  3598.         } else {
  3599.             $em = $this->getDoctrine()->getManager('company_group');
  3600.             $em->getConnection()->connect();
  3601.             $connected = $em->getConnection()->isConnected();
  3603.             $gocDataList = [];
  3604.             $gocDataListByAppId = [];
  3605.             $retDataDebug = array();
  3607.             $appIds = $request->get('appIds', '_UNSET_');
  3608.             $userIds = $request->get('userIds', '_UNSET_');
  3611.             if ($connected) {
  3612.                 $findByQuery = array(
  3613.                     'active' => 1
  3614.                 );
  3615.                 if ($appIds !== '_UNSET_')
  3616.                     $findByQuery['appId'] = $appIds;
  3619.                 $gocList = $this->getDoctrine()->getManager('company_group')
  3620.                     ->getRepository("CompanyGroupBundle:CompanyGroup")
  3621.                     ->findBy($findByQuery);
  3624.                 foreach ($gocList as $entry) {
  3625.                     $d = array(
  3626.                         'name' => $entry->getName(),
  3627.                         'id' => $entry->getId(),
  3628.                         'image' => $entry->getImage(),
  3629.                         'companyGroupHash' => $entry->getCompanyGroupHash(),
  3630.                         'dbName' => $entry->getDbName(),
  3631.                         'dbUser' => $entry->getDbUser(),
  3632.                         'dbPass' => $entry->getDbPass(),
  3633.                         'dbHost' => $entry->getDbHost(),
  3634.                         'appId' => $entry->getAppId(),
  3635.                         'companyRemaining' => $entry->getCompanyRemaining(),
  3636.                         'companyAllowed' => $entry->getCompanyAllowed(),
  3637.                     );
  3638.                     $gocDataList[$entry->getId()] = $d;
  3639.                     $gocDataListByAppId[$entry->getAppId()] = $d;
  3640.                 }
  3642.                 $debugCount = 0;
  3645.                 foreach ($gocDataList as $gocId => $entry) {
  3647. //                    if($debugCount>0)
  3648. //                        continue;
  3650.                     $skipSend = 1;
  3653.                     $connector = $this->container->get('application_connector');
  3654.                     $connector->resetConnection(
  3655.                         'default',
  3656.                         $gocDataList[$gocId]['dbName'],
  3657.                         $gocDataList[$gocId]['dbUser'],
  3658.                         $gocDataList[$gocId]['dbPass'],
  3659.                         $gocDataList[$gocId]['dbHost'],
  3660.                         $reset = true);
  3661.                     $em = $this->getDoctrine()->getManager();
  3663.                     if ($userIds !== '_UNSET_')
  3664.                         $users = $this->getDoctrine()
  3665.                             ->getRepository('ApplicationBundle:SysUser')
  3666.                             ->findBy(
  3667.                                 array(
  3668.                                     'userId' => $userIds
  3669.                                 )
  3670.                             );
  3671.                     else
  3672.                         $users = $this->getDoctrine()
  3673.                             ->getRepository('ApplicationBundle:SysUser')
  3674.                             ->findBy(
  3675.                                 array()
  3676.                             );
  3679.                     $output = '';
  3681.                     $userData = array();
  3682.                     $userFiles = array();
  3684.                     foreach ($users as $user) {
  3686.                         $file = $this->container->getParameter('kernel.root_dir') . '/../web/' . $user->getImage(); //<-- Path could be relative
  3687. //                            $output=$file;
  3689.                         if ($user->getImage() != '' && $user->getImage() != null && file_exists($file)) {
  3690. //                        $file = new \CURLFile($this->container->getParameter('kernel.root_dir') . '/../web/uploads/CompanyImage/' . $company->getImage()); //<-- Path could be relative
  3691.                             $mime = mime_content_type($file);
  3692.                             $info = pathinfo($file);
  3693.                             $name = $info['basename'];
  3694.                             if (strpos($mime, 'image') !== false) {
  3695.                                 $output = new \CURLFile($file, $mime, $name);
  3696.                             }
  3698.                             $skipSend = 0;
  3699.                             $userFiles['file_' . $user->getUserAppId() . '_' . $user->getUserId()] = $output;
  3701.                         } else {
  3703. //                                    unlink($this->container->getParameter('kernel.root_dir') . '/../web'. $centralUser->getImage());
  3704.                             $user->setImage(null);
  3705.                             $userFiles['file_' . $user->getUserAppId() . '_' . $user->getUserId()] = 'pika';
  3706.                             $em->flush();
  3709.                         }
  3711.                         $getters = array_filter(get_class_methods($user), function ($method) {
  3712.                             return 'get' === substr($method, 0, 3);
  3715.                         });
  3716.                         $userDataSingle = array(//                                'file'=>$output
  3717.                         );
  3720.                         foreach ($getters as $getter) {
  3722.                             if ($getter == 'getCreatedAt' || $getter == 'getUpdatedAt' || $getter == 'getImage')
  3723.                                 continue;
  3724. //                                if(is_string($user->{$getter}())|| is_numeric($user->{$getter}()))
  3725. //                                {
  3726. //                                    $userDataSingle[$getter]= $user->{$getter}();
  3727. //                                }
  3728.                             if ($user->{$getter}() instanceof \DateTime) {
  3729.                                 $ggtd = $user->{$getter}();
  3730.                                 $userDataSingle[$getter] = $ggtd->format('Y-m-d');
  3731.                             } else
  3732.                                 $userDataSingle[$getter] = $user->{$getter}();
  3734.                         }
  3736.                         $userData[] = $userDataSingle;
  3738.                     }
  3739.                     $retDataDebug[$debugCount] = array(
  3740.                         'skipSend' => $skipSend
  3741.                     );
  3743.                     //now customers
  3745.                     $emailFieldName = 'email';
  3746.                     $phoneFieldName = 'contact_number';
  3747.                     $query = "SELECT * from  acc_clients   where 1=1 ";
  3749.                     $stmt = $em->getConnection()->prepare($query);
  3750.                     $stmt->execute();
  3751.                     $results = $stmt->fetchAll();
  3754.                     if (!empty($results)) {
  3755.                         foreach ($results as $dt) {
  3756.                             $dt['company_id'] = "1";
  3759.                             $companyData = isset($companyList[$dt['company_id']]) ? $companyList[$dt['company_id']] : [];
  3760.                             $userDataSingle = array(
  3761.                                 'getUserAppId' => strval(UserConstants::USER_TYPE_CLIENT),
  3762.                                 'getUserName' => 'CID-' . str_pad($dt['client_id'], 8, '0', STR_PAD_LEFT),
  3763.                                 'getUserId' => $dt['client_id']
  3766.                             );
  3768. //                            $userData[] = $userDataSingle;
  3771.                         }
  3774.                     }
  3777.                     //now suppliers
  3779.                     $emailFieldName = 'email';
  3780.                     $phoneFieldName = 'contact_number';
  3781.                     $query = "SELECT * from  acc_suppliers   where 1=1 ";
  3783.                     $stmt = $em->getConnection()->prepare($query);
  3784.                     $stmt->execute();
  3785.                     $results = $stmt->fetchAll();
  3788.                     if (!empty($results)) {
  3789.                         foreach ($results as $dt) {
  3790.                             $dt['company_id'] = "1";
  3793.                             $companyData = isset($companyList[$dt['company_id']]) ? $companyList[$dt['company_id']] : [];
  3794.                             $userDataSingle = array(
  3795.                                 'userType' => strval(UserConstants::USER_TYPE_SUPPLIER),
  3796.                                 'userName' => 'SID-' . str_pad($dt['supplier_id'], 8, '0', STR_PAD_LEFT),
  3797.                                 'userId' => $dt['supplier_id'],
  3799.                             );
  3801. //                            $userData[] = $userDataSingle;
  3804.                         }
  3807.                     }
  3810. //                    if ($skipSend == 0)
  3811.                     {
  3814.                         $urlToCall = GeneralConstant::HONEYBEE_CENTRAL_SERVER . '/SyncUserToCentralUser';
  3815.                         $userFiles['userData'] = json_encode($userData);
  3817.                         $curl = curl_init();
  3818.                         curl_setopt_array($curl, array(
  3819.                             CURLOPT_RETURNTRANSFER => 1,
  3820.                             CURLOPT_POST => 1,
  3821.                             CURLOPT_URL => $urlToCall,
  3822.                             CURLOPT_CONNECTTIMEOUT => 10,
  3823.                             CURLOPT_SSL_VERIFYPEER => false,
  3824.                             CURLOPT_SSL_VERIFYHOST => false,
  3825. //                            CURLOPT_SAFE_UPLOAD => false,
  3826.                             CURLOPT_HTTPHEADER => array(//                                "Accept: multipart/form-data",
  3827.                             ),
  3828.                             //                        CURLOPT_USERAGENT => 'InnoPM',
  3830. //                            CURLOPT_POSTFIELDS => array(
  3831. //                                'userData'=>json_encode($userData),
  3832. //                                'userFiles'=>$userFiles
  3833. //                            ),
  3834.                             CURLOPT_POSTFIELDS => $userFiles
  3836.                         ));
  3838.                         $retData = curl_exec($curl);
  3839.                         $errData = curl_error($curl);
  3840.                         curl_close($curl);
  3841.                         $retDataObj = json_decode($retData, true);
  3843.                         $retDataDebug[$debugCount] = $retDataObj;
  3846.                         if (isset($retDataObj['globalIdsData']))
  3847.                             foreach ($retDataObj['globalIdsData'] as $app_id => $usrList) {
  3848.                                 $connector = $this->container->get('application_connector');
  3849.                                 $connector->resetConnection(
  3850.                                     'default',
  3851.                                     $gocDataListByAppId[$app_id]['dbName'],
  3852.                                     $gocDataListByAppId[$app_id]['dbUser'],
  3853.                                     $gocDataListByAppId[$app_id]['dbPass'],
  3854.                                     $gocDataListByAppId[$app_id]['dbHost'],
  3855.                                     $reset = true);
  3856.                                 $em = $this->getDoctrine()->getManager();
  3858.                                 foreach ($usrList as $sys_id => $globaldata) {
  3859.                                     $user = $this->getDoctrine()
  3860.                                         ->getRepository('ApplicationBundle:SysUser')
  3861.                                         ->findOneBy(
  3862.                                             array(
  3863.                                                 'userId' => $sys_id
  3864.                                             )
  3865.                                         );
  3867.                                     if ($user) {
  3868.                                         $user->setGlobalId($globaldata['gid']);
  3870.                                         $em->flush();
  3871.                                     }
  3873.                                 }
  3875.                             }
  3876.                     }
  3879.                     $debugCount++;
  3882.                 }
  3884.             }
  3886.             return new JsonResponse($retDataDebug);
  3888.         }
  3891.     }
  3893.     public function ReceiveUserFromCentralAction(Request $request)
  3894.     {
  3895.         $data = json_decode($request->getContent(), true);
  3897.         if (
  3898.             !$data ||
  3899.             !isset($data['globalId']) ||
  3900.             !isset($data['appId']) ||
  3901.             !isset($data['userData'])
  3902.         ) {
  3903.             return new JsonResponse(['success' => false, 'message' => 'Missing required fields'], 400);
  3904.         }
  3906.         $globalId = $data['globalId'];
  3907.         $userDataRaw = $data['userData'];
  3908.         if (is_string($userDataRaw)) {
  3909.             $userDataRaw = json_decode($userDataRaw, true);
  3910.         }
  3912.         if (!is_array($userDataRaw)) {
  3913.             return new JsonResponse(['success' => false, 'message' => 'Invalid userData format'], 400);
  3914.         }
  3916.         $userData = is_array($userDataRaw[0] ?? null) ? $userDataRaw[0] : $userDataRaw;
  3918.         if (is_string($userData)) {
  3919.             $userData = json_decode($userData, true);
  3920.         }
  3921.         if (!is_array($userData)) {
  3922.             return new JsonResponse(['success' => false, 'message' => 'Invalid userData format'], 400);
  3923.         }
  3925.         $companyIds = is_array($data['appId']) ? $data['appId'] : [$data['appId']];
  3927.         $em_goc = $this->getDoctrine()->getManager('company_group');
  3928.         $companies = $em_goc->getRepository('CompanyGroupBundle:CompanyGroup')->findBy([
  3929.             'appId' => $companyIds
  3930.         ]);
  3932.         foreach ($companies as $entry) {
  3933.             $goc = [
  3934.                 'dbName' => $entry->getDbName(),
  3935.                 'dbUser' => $entry->getDbUser(),
  3936.                 'dbPass' => $entry->getDbPass(),
  3937.                 'dbHost' => $entry->getDbHost(),
  3938.                 'serverAddress' => $entry->getCompanyGroupServerAddress(),
  3939.                 'port' => $entry->getCompanyGroupServerPort() ?: 80,
  3940.                 'appId' => $entry->getAppId(),
  3941. //                                 'serverId' => $entry->getServerId(),
  3942.             ];
  3945.             $connector = $this->container->get('application_connector');
  3946.             $connector->resetConnection(
  3947.                 'default',
  3948.                 $goc['dbName'],
  3949.                 $goc['dbUser'],
  3950.                 $goc['dbPass'],
  3951.                 $goc['dbHost'],
  3952.                 $reset = true
  3953.             );
  3955.             $em = $this->getDoctrine()->getManager();
  3957.             $user = $em->getRepository('ApplicationBundle:SysUser')->findOneBy(['globalId' => $globalId]);
  3959.             if (!$user) {
  3960.                 return new JsonResponse(['success' => false, 'message' => 'User not found'], 404);
  3961.             }
  3963. //            $user = $em->getRepository('ApplicationBundle:SysUser')->findOneBy(['userId' => $user->getUserId()]);
  3965. //            if (!$user) {
  3966. //                $user = new \ApplicationBundle\Entity\EncryptedSignature();
  3967. //                $user->setUserId($user->getUserId());
  3968. //                $user->setCreatedAt(new \DateTime());
  3969. //            }
  3970.             $user->setUserName($userData['getFirstname'] . ' ' . $userData['getLastname']);
  3971.             $user->setUserCompanyId(1);
  3972.             $user->setGlobalId($globalId);
  3973.             $user->setUserName($userData['getName'] ?? null);
  3974.             $user->setUpdatedAt(new \DateTime());
  3976.             $em->persist($user);
  3977.             $em->flush();
  3979.             $employee = $em->getRepository('ApplicationBundle:Employee')->findOneBy(['userId' => $user->getUserId()]);
  3980.             if ($employee) {
  3981.                 $employee->setFirstName($userData['getFirstname']);
  3982.                 $employee->setLastName($userData['getLastname']);
  3983.                 $em->persist($employee);
  3984.             }
  3986.             if ($employee)
  3987.                 $employeeDetails = $em->getRepository('ApplicationBundle:EmployeeDetails')
  3988.                     ->findOneBy(['id' => $employee->getEmployeeId()]);
  3989.             else
  3990.                 $employeeDetails = $em->getRepository('ApplicationBundle:EmployeeDetails')
  3991.                     ->findOneBy(['userId' => $user->getUserId()]);
  3992.             if ($employeeDetails) {
  3993.                 $employeeDetails->setFirstname($userData['getFirstname']);
  3994.                 $employeeDetails->setLastname($userData['getLastname']);
  3995.                 $employeeDetails->setEmail($userData['getEmail']);
  3996.                 $employeeDetails->setPhone($userData['getPhone'] ?? null);
  3997.                 $employeeDetails->setNid($userData['getNid'] ?? null);
  3998.                 $employeeDetails->setSex($userData['getSex'] ?? null);
  3999.                 $employeeDetails->setBlood($userData['getBlood'] ?? null);
  4000.                 $employeeDetails->setFather($userData['getFather'] ?? null);
  4001.                 $employeeDetails->setMother($userData['getMother'] ?? null);
  4002.                 $employeeDetails->setSpouse($userData['getSpouse'] ?? null);
  4003.                 $employeeDetails->setCurrAddr($userData['getCurrAddr'] ?? null);
  4004.                 $employeeDetails->setPermAddr($userData['getPermAddr'] ?? null);
  4006.                 $em->persist($employeeDetails);
  4007.             }
  4009.             $em->flush();
  4012.         }
  4015.         return new JsonResponse(['success' => true, 'message' => 'User, Employee, and EmployeeDetails updated in all ERP servers']);
  4016.     }
  4019.     public function SyncCentralUserToServerAction(Request $request)
  4020.     {
  4023.         $systemType = $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_';
  4026.         $post = $request;
  4027.         $serverList = GeneralConstant::$serverListById;
  4028.         $globalIdsByAppIdAndUser = [];
  4029.         if ($systemType == '_CENTRAL_') {
  4031.             $userDataList = [];
  4032.             $retAppIds = [];
  4033.             $appIdList = [];
  4034.             $userIdList = [];
  4035.             $retDataDebug = [];
  4036.             $appIds = $request->get('appIds', '_UNSET_');
  4038.             if ($appIds != '_UNSET_') {
  4039.                 $appIdList = $userIdList = explode(',', $appIds);;
  4040.                 if ($appIdList == null) $appIdList = [];
  4041.             }
  4042.             $userIds = $request->get('userIds', '_UNSET_');
  4043.             if ($userIds != '_UNSET_') {
  4044.                 $userIdList = explode(',', $userIds);
  4045.                 if ($userIdList == null) $userIdList = [];
  4046.             }
  4048.             if (is_string($userDataList)) $userDataList = json_decode($userDataList, true);
  4049.             if ($userDataList == null) $userDataList = [];
  4051.             $em_goc = $this->getDoctrine()->getManager('company_group');
  4054.             $centralUserQry = $em_goc->getRepository('CompanyGroupBundle:EntityApplicantDetails')
  4055.                 ->createQueryBuilder('m')
  4056.                 ->where("1=1");
  4058.             if (!empty($userIdList))
  4059.                 $centralUserQry->andWhere("m.applicantId in (" . implode(',', $userIdList) . " )");
  4062.             $centralUsers = $centralUserQry->getQuery()
  4063.                 ->setMaxResults(1)
  4064.                 ->getResult();
  4066.             ////ITEMGROUPS
  4067.             foreach ($centralUsers as $centralUser) {
  4070.                 if ($centralUser) {
  4071.                 } else {
  4073.                 }
  4075.                 $toSetUserData = [];
  4077.                 $userData = array();
  4078.                 $userFiles = array();
  4081.                 $file = $this->container->getParameter('kernel.root_dir') . '/../web/' . $centralUser->getImage(); //<-- Path could be relative
  4082. //                            $output=$file;
  4084.                 if ($centralUser->getImage() != '' && $centralUser->getImage() != null && file_exists($file)) {
  4085. //                        $file = new \CURLFile($this->container->getParameter('kernel.root_dir') . '/../web/uploads/CompanyImage/' . $company->getImage()); //<-- Path could be relative
  4086.                     $mime = mime_content_type($file);
  4087.                     $info = pathinfo($file);
  4088.                     $name = $info['basename'];
  4089.                     if (strpos($mime, 'image') !== false) {
  4090.                         $output = new \CURLFile($file, $mime, $name);
  4091.                     }
  4093.                     $skipSend = 0;
  4094.                     $userFiles['file_' . $centralUser->getApplicantId()] = $output;
  4096.                 } else {
  4098.                     $centralUser->setImage(null);
  4099.                     $userFiles['file_' . $centralUser->getApplicantId()] = 'pika';
  4100.                     $em_goc->flush();
  4103.                 }
  4106. //
  4107.                 $getters = array_filter(get_class_methods($centralUser), function ($method) {
  4108.                     return 'get' === substr($method, 0, 3);
  4109.                 });
  4111.                 $userDataSingle = array();
  4114.                 foreach ($getters as $getter) {
  4116.                     if ($getter == 'getCreatedAt' || $getter == 'getUpdatedAt' || $getter == 'getImage')
  4117.                         continue;
  4118. //                                if(is_string($user->{$getter}())|| is_numeric($user->{$getter}()))
  4119. //                                {
  4120. //                                    $userDataSingle[$getter]= $user->{$getter}();
  4121. //                                }
  4122.                     if ($centralUser->{$getter}() instanceof \DateTime) {
  4123.                         $ggtd = $centralUser->{$getter}();
  4124.                         $userDataSingle[$getter] = $ggtd->format('Y-m-d');
  4125.                     } else
  4126.                         $userDataSingle[$getter] = $centralUser->{$getter}();
  4128.                 }
  4131.                 $userAppIds = json_decode($centralUser->getUserAppIds(), true);
  4132.                 if ($userAppIds == null) $userAppIds = [];
  4135.                 $appIdList = array_merge($appIdList, array_diff($userAppIds, $appIdList));
  4137.                 $userTypesByAppIds = json_decode($centralUser->getUserTypesByAppIds(), true);
  4138.                 if ($userTypesByAppIds == null) $userTypesByAppIds = [];
  4140.                 $userDataSingle['userTypesByAppIds'] = $userTypesByAppIds;
  4143.                 $userDataList[] = $userDataSingle;
  4146.                 $em_goc->persist($centralUser);
  4149.                 $em_goc->flush();
  4150.             }
  4153.             $em_goc->flush();
  4155.             $serverIdsCalledAlready = [];
  4157.             $appList = $this->getDoctrine()->getManager('company_group')
  4158.                 ->getRepository("CompanyGroupBundle:CompanyGroup")
  4159.                 ->findBy(array(
  4160.                         'appId' => $appIdList
  4161.                     )
  4163.                 );
  4165.             $userFiles['userData'] = json_encode($userDataList);
  4166.             foreach ($appList as $app) {
  4167.                 if (!in_array($app->getCompanyGroupServerId(), $serverIdsCalledAlready)) {
  4168.                     if (isset($serverList[$app->getCompanyGroupServerId()])) {
  4169.                         //                    if ($skipSend == 0)
  4170.                         {
  4173.                             $urlToCall = $serverList[$app->getCompanyGroupServerId()]['absoluteUrl'] . '/SyncCentralUserToServer';
  4176.                             $curl = curl_init();
  4177.                             curl_setopt_array($curl, array(
  4178.                                 CURLOPT_RETURNTRANSFER => 1,
  4179.                                 CURLOPT_POST => 1,
  4180.                                 CURLOPT_URL => $urlToCall,
  4181.                                 CURLOPT_CONNECTTIMEOUT => 10,
  4182.                                 CURLOPT_SSL_VERIFYPEER => false,
  4183.                                 CURLOPT_SSL_VERIFYHOST => false,
  4185.                                 CURLOPT_HTTPHEADER => array(),
  4187.                                 CURLOPT_POSTFIELDS => $userFiles
  4189.                             ));
  4192.                             $retData = curl_exec($curl);
  4193.                             $errData = curl_error($curl);
  4194.                             curl_close($curl);
  4195.                             $retDataObj = json_decode($retData, true);
  4197.                             $retDataDebug[] = $retDataObj;
  4200.                         }
  4201.                     }
  4202.                     $serverIdsCalledAlready[] = $app->getCompanyGroupServerId();
  4203.                 }
  4204.             }
  4207. //                if (!isset($globalIdsByAppIdAndUser[$cwa['getUserAppId']]))
  4208. //                    $globalIdsByAppIdAndUser[$cwa['getUserAppId']] = array();
  4209. //
  4210. //                $globalIdsByAppIdAndUser[$cwa['getUserAppId']][$cwa['getUserId']] =
  4211. //                    array(
  4212. //                        'gid' => $centralUser->getApplicantId()
  4213. //                    );
  4216.             return new JsonResponse(
  4217.                 array(
  4218.                     "success" => true,
  4219.                     "retDataDebug" => $retDataDebug,
  4220.                     "serverIdsCalledAlready" => $serverIdsCalledAlready,
  4221.                     "appIdList" => $appIdList,
  4222.                     "userFiles" => $userFiles,
  4223.                     "retAppIds" => $retAppIds,
  4224.                 )
  4225.             );
  4226.         } else {
  4228.             $userDataList = $request->get('userData', []);
  4230.             if (is_string($userDataList)) $userDataList = json_decode($userDataList, true);
  4231.             if ($userDataList == null) $userDataList = [];
  4234.             foreach ($userDataList as $userData) {
  4235.                 $em_goc = $this->getDoctrine()->getManager('company_group');
  4236.                 $em = $this->getDoctrine()->getManager('company_group');
  4237.                 $em->getConnection()->connect();
  4238.                 $connected = $em->getConnection()->isConnected();
  4240.                 $gocDataList = [];
  4241.                 $gocDataListByAppId = [];
  4242.                 $retDataDebug = array();
  4244.                 $appIds = json_decode($userData['getUserAppIds'], true);
  4245.                 if ($appIds == null) $appIds = [];
  4246.                 $userTypesByAppIds = json_decode($userData['getUserTypesByAppIds'], true);
  4247.                 if ($userTypesByAppIds == null) $userTypesByAppIds = [];
  4249.                 $userIds = $request->get('userIds', '_UNSET_');
  4252.                 if ($connected && !empty($appIds)) {
  4253.                     $findByQuery = array(
  4254.                         'active' => 1
  4255.                     );
  4257.                     $findByQuery['appId'] = $appIds;
  4260.                     $gocList = $this->getDoctrine()->getManager('company_group')
  4261.                         ->getRepository("CompanyGroupBundle:CompanyGroup")
  4262.                         ->findBy($findByQuery);
  4264.                     $imagePathToSet = '';
  4266.                     $uploadedFile = $request->files->get('file_' . $userData['getApplicantId'], null);
  4267.                     {
  4269.                         if ($uploadedFile != null) {
  4271.                             $fileName = 'user_image' . $userData['getApplicantId'] . '.' . $uploadedFile->guessExtension();
  4272.                             $path = $fileName;
  4273.                             $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/UserImage/';
  4276.                             if (!file_exists($upl_dir)) {
  4277.                                 mkdir($upl_dir, 0777, true);
  4278.                             }
  4279.                             $file = $uploadedFile->move($upl_dir, $path);
  4281.                             $imagePathToSet = 'uploads/UserImage/' . $path;
  4283.                         }
  4285.                     }
  4288.                     foreach ($gocList as $entry) {
  4289.                         $d = array(
  4290.                             'name' => $entry->getName(),
  4291.                             'id' => $entry->getId(),
  4292.                             'image' => $entry->getImage(),
  4293.                             'companyGroupHash' => $entry->getCompanyGroupHash(),
  4294.                             'dbName' => $entry->getDbName(),
  4295.                             'dbUser' => $entry->getDbUser(),
  4296.                             'dbPass' => $entry->getDbPass(),
  4297.                             'dbHost' => $entry->getDbHost(),
  4298.                             'appId' => $entry->getAppId(),
  4299.                             'companyRemaining' => $entry->getCompanyRemaining(),
  4300.                             'companyAllowed' => $entry->getCompanyAllowed(),
  4301.                         );
  4302.                         $gocDataList[$entry->getId()] = $d;
  4303.                         $gocDataListByAppId[$entry->getAppId()] = $d;
  4304.                     }
  4306.                     $debugCount = 0;
  4309.                     foreach ($gocDataList as $gocId => $entry) {
  4311. //                    if($debugCount>0)
  4312. //                        continue;
  4314.                         $skipSend = 1;
  4317.                         $connector = $this->container->get('application_connector');
  4318.                         $connector->resetConnection(
  4319.                             'default',
  4320.                             $gocDataList[$gocId]['dbName'],
  4321.                             $gocDataList[$gocId]['dbUser'],
  4322.                             $gocDataList[$gocId]['dbPass'],
  4323.                             $gocDataList[$gocId]['dbHost'],
  4324.                             $reset = true);
  4325.                         $em = $this->getDoctrine()->getManager();
  4328.                         $user = $this->getDoctrine()
  4329.                             ->getRepository('ApplicationBundle:SysUser')
  4330.                             ->findOneBy(
  4331.                                 array(
  4332.                                     'globalId' => $userData['getApplicantId']
  4333.                                 )
  4334.                             );
  4337.                         $output = '';
  4340.                         if (!$user)
  4341.                             $user = new SysUser();
  4343.                         $user->setGlobalId($userData['getApplicantId']);
  4344.                         $user->setUserAppId($entry['appId']);
  4346.                         $user_type = 1;
  4347.                         if (isset($userData['userTypesByAppIds'][$entry['appId']])) {
  4348.                             $user_type = $userData['userTypesByAppIds'][$entry['appId']];
  4349.                         }
  4350.                         $user->setUserType($user_type);
  4351.                         $user->setUserAppIdList(json_encode($appIds));
  4352.                         $user->setName($userData['getFirstname'] . ' ' . $userData['getLastname']);
  4353.                         $user->setStatus(UserConstants::ACTIVE_USER);
  4356.                         foreach ($userData as $getter => $value) {
  4358.                             if ($getter == 'getApplicantId')
  4359.                                 continue;
  4360.                             $setMethod = str_replace('get', 'set', $getter);
  4361.                             if (method_exists($user, $setMethod)) {
  4363.                                 if ($user->{$getter}() instanceof \DateTime)
  4364.                                     $user->{$setMethod}(new \DateTime($value)); // `foo!`
  4365.                                 else if ($setMethod == 'setUserAppIds') {
  4367.                                 } else
  4368.                                     $user->{$setMethod}($value); // `foo!`
  4369.                             }
  4370.                         }
  4372.                         if ($imagePathToSet != "") {
  4373.                             if ($user->getImage() != $imagePathToSet && $user->getImage() != '' && $user->getImage() != null && file_exists($this->container->getParameter('kernel.root_dir') . '/../web/' . $user->getImage())) {
  4375.                                 unlink($this->container->getParameter('kernel.root_dir') . '/../web/' . $user->getImage());
  4378.                             }
  4380.                             $user->setImage($imagePathToSet);
  4381.                         }
  4383.                         $em->persist($user);
  4384.                         $em->flush();
  4386.                         $debugCount++;
  4389.                         $retDataDebug[$debugCount] = array(
  4390.                             'skipSend' => $skipSend,
  4391.                             'userId' => $user->getUserId(),
  4392.                             'appId' => $user->getUserAppId(),
  4394.                         );
  4397.                     }
  4399.                 }
  4402.             }
  4404.             return new JsonResponse($retDataDebug);
  4406.         }
  4409.     }
  4412.     public function GetUsersByQueryAction(Request $request, $id = 0)
  4413.     {
  4414.         $message = "";
  4416.         $gocList = [];
  4417.         $outputList = [];
  4418.         $queryType = '_ANY_';
  4419. //        if ($request->has('queryType'))
  4420.         $queryType = $request->get('queryType', '_ANY_');
  4422.         $returnData = [];
  4423.         $debugData = [];
  4424.         $returnDataArray = [];
  4425.         $returnDataByServerId = [];
  4426.         $serverId = $request->get('serverId', 4);
  4427.         $serverUrl = $request->get('serverUrl', 'http://194.195.244.141');
  4428.         $serverPort = $request->get('serverPort', '');
  4429.         $queryStr = $request->get('queryStr', '');
  4430.         $queryStrEmail = $request->get('quryStrEmail', '');
  4431.         $queryStrPhone = $request->get('quryStrPhone', '');
  4432.         if ($queryStrEmail == '' && $queryStrPhone == '') {
  4433.             $queryStrEmail = $queryStr;
  4434.         }
  4437. //        sample
  4438. //        data will be by company id
  4439.         $d = array(
  4440.             'userType' => 2,
  4441.             'userId' => 4,
  4442.             'userName' => 'abc',
  4443.             'loginUserName' => 'CID-abc',
  4444.             'serverId' => $serverId,
  4445.             'serverUrl' => $serverUrl,
  4446.             'systemType' => $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_',
  4447.             'gocId' => 2,
  4448.             'companyId' => 1,
  4449.             'appId' => 45,
  4450.             'companyLogoUrl' => '/uploads/CompanyImage/4c48d9d0f26918c8bd866a197e50e15e.png',
  4451.             'companyName' => 'HoneyBee Iot Ltd.',
  4452.             'userCompanyIds' => [1, 4],
  4453.             'userAppIds' => [1, 40],
  4454.             'userCompanyList' => [
  4455.                 1 => [
  4456.                     'companyLogoUrl' => '/uploads/CompanyImage/4c48d9d0f26918c8bd866a197e50e15e.png',
  4457.                     'companyName' => 'HoneyBee IoT Ltd.',
  4458.                 ],
  4459.                 4 => [
  4460.                     'companyLogoUrl' => '/uploads/CompanyImage/4c48d9d0f26918c8bd866a197e50e15e.png',
  4461.                     'companyName' => 'Nastec Srl',
  4462.                 ]
  4464.             ]
  4465.         );
  4466. //        return new JsonResponse(array(
  4467. //            $d, $d
  4468. //        ));
  4470.         $em = $this->getDoctrine()->getManager('company_group');
  4471.         $em->getConnection()->connect();
  4472.         $connected = $em->getConnection()->isConnected();
  4473.         if ($connected)
  4474.             $gocList = $this->getDoctrine()->getManager('company_group')
  4475.                 ->getRepository("CompanyGroupBundle:CompanyGroup")
  4476.                 ->findBy(
  4477.                     array(
  4478.                         'active' => 1
  4479.                     )
  4480.                 );
  4482.         $gocDataList = [];
  4483.         foreach ($gocList as $entry) {
  4484.             $d = array(
  4485.                 'name' => $entry->getName(),
  4486.                 'id' => $entry->getId(),
  4487.                 'dbName' => $entry->getDbName(),
  4488.                 'dbUser' => $entry->getDbUser(),
  4489.                 'dbPass' => $entry->getDbPass(),
  4490.                 'dbHost' => $entry->getDbHost(),
  4491.                 'appId' => $entry->getAppId(),
  4492.                 'companyRemaining' => $entry->getCompanyRemaining(),
  4493.                 'companyAllowed' => $entry->getCompanyAllowed(),
  4494.             );
  4495.             $gocDataList[$entry->getId()] = $d;
  4496.         }
  4497.         $gocDbName = '';
  4498.         $gocDbUser = '';
  4499.         $gocDbPass = '';
  4500.         $gocDbHost = '';
  4501.         $gocId = 0;
  4502. //        $web_root_dir = $this->container->getParameter('kernel.root_dir'). '/../web' ;
  4503.         $web_root_dir = $url = $this->generateUrl('dashboard', [], UrlGenerator::ABSOLUTE_URL);
  4504. //        $root_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf';
  4507.         foreach ($gocDataList as $gocId => $entry) {
  4510.             $connector = $this->container->get('application_connector');
  4511.             $connector->resetConnection(
  4512.                 'default',
  4513.                 $gocDataList[$gocId]['dbName'],
  4514.                 $gocDataList[$gocId]['dbUser'],
  4515.                 $gocDataList[$gocId]['dbPass'],
  4516.                 $gocDataList[$gocId]['dbHost'],
  4517.                 $reset = true);
  4518.             $em = $this->getDoctrine()->getManager();
  4520.             $companyList = [];
  4521.             $query = "SELECT * from  company   where 1";
  4522.             $stmt = $em->getConnection()->prepare($query);
  4523.             $stmt->execute();
  4524.             $results = $stmt->fetchAll();
  4526.             if (!empty($results))
  4527.                 foreach ($results as $dt) {
  4528.                     $companyList[$dt['id']] = $dt;
  4529.                 }
  4530.             else
  4531.                 $companyList = array(
  4532.                     1 => [
  4533.                         'image' => '',
  4534.                         'name' => 'Company',
  4536.                     ]
  4537.                 );
  4540.             ///SysUSER
  4541.             $fieldName = ($queryType == '_EMAIL_' || $queryType == '_ANY_') ? 'email' : 'phone_number';
  4543.             if ($queryStrEmail == '' && $queryStrPhone == '') {
  4545.             } else {
  4547.                 $emailFieldName = 'email';
  4548.                 $phoneFieldName = 'phone_number';
  4549.                 $userNameFieldName = 'user_name';
  4550.                 $query = "SELECT * from  sys_user   where 1=1 ";
  4551.                 $query .= ($queryStrEmail != '') ? "and $emailFieldName like '$queryStrEmail' " : '';
  4552.                 $query .= ($queryStrPhone != '') ? "and $phoneFieldName like '%$queryStrPhone%' " : '';
  4553.                 $query .= ($queryStr != '') ? " or $userNameFieldName like '$queryStr' " : '';
  4554.                 $stmt = $em->getConnection()->prepare($query);
  4555.                 $stmt->execute();
  4556.                 $results = $stmt->fetchAll();
  4559.                 if (!empty($results)) {
  4560.                     foreach ($results as $dt) {
  4562. //                        if($dt['company_id']==0 || $dt['company_id'] ==null)
  4563.                         $dt['company_id'] = "1";
  4564.                         $user_app_ids = json_decode($dt['user_app_id_list'], true);
  4565.                         if ($user_app_ids == null) $user_app_ids = [$dt['app_id']];
  4566.                         $user_company_ids = json_decode($dt['user_company_id_list'], true);
  4567.                         if ($user_company_ids == null) $user_company_ids = [$dt['company_id']];
  4570.                         $companyData = isset($companyList[$dt['company_id']]) ? $companyList[$dt['company_id']] : [];
  4571.                         $d = array(
  4572.                             'userType' => $dt['user_type'],
  4573.                             'userName' => $dt['user_name'],
  4574.                             'userId' => $dt['user_id'],
  4575.                             'loginUserName' => $dt['user_name'],
  4576.                             'email' => $dt['email'],
  4577.                             'phone' => $dt['phone_number'],
  4578.                             'serverId' => $serverId,
  4579.                             'serverUrl' => $serverUrl,
  4580.                             'systemType' => $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_',
  4581.                             'gocId' => $gocId,
  4582.                             'companyId' => $dt['company_id'],
  4583.                             'appId' => $dt['app_id'],
  4584.                             'companyLogoUrl' => $web_root_dir . $companyData['image'],
  4585.                             'companyName' => $companyData['name'],
  4586.                             'userCompanyIds' => $user_company_ids,
  4587.                             'userAppIds' => $user_app_ids,
  4588.                             'userCompanyList' => [
  4591.                             ]
  4592.                         );
  4593.                         foreach ($user_company_ids as $cid) {
  4594.                             $d['userCompanyList'][$cid] = [
  4595.                                 'companyLogoUrl' => $web_root_dir . $companyList[$cid]['image'],
  4596.                                 'companyName' => $companyList[$cid]['name'],
  4598.                             ];
  4600.                         }
  4601.                         $returnData[] = $d;
  4602.                         $returnDataByServerId[$serverId][] = $d;
  4604.                     }
  4607.                 }
  4609.                 //now customers
  4611.                 $emailFieldName = 'email';
  4612.                 $phoneFieldName = 'contact_number';
  4613.                 $query = "SELECT * from  acc_clients   where 1=1 ";
  4614.                 $query .= ($queryStrEmail != '') ? "and $emailFieldName like '$queryStrEmail'" : '';
  4615.                 $query .= ($queryStrPhone != '') ? "and $phoneFieldName like '%$queryStrPhone%'" : '';
  4616.                 $stmt = $em->getConnection()->prepare($query);
  4617.                 $stmt->execute();
  4618.                 $results = $stmt->fetchAll();
  4621.                 if (!empty($results)) {
  4622.                     foreach ($results as $dt) {
  4623.                         $dt['company_id'] = "1";
  4626.                         $companyData = isset($companyList[$dt['company_id']]) ? $companyList[$dt['company_id']] : [];
  4627.                         $d = array(
  4628.                             'userType' => strval(UserConstants::USER_TYPE_CLIENT),
  4629.                             'userName' => 'CID-' . str_pad($dt['client_id'], 8, '0', STR_PAD_LEFT),
  4630.                             'userId' => $dt['client_id'],
  4631.                             'loginUserName' => $dt['username'],
  4632.                             'email' => $dt['email'],
  4633.                             'phone' => $dt['contact_number'],
  4634.                             'serverId' => $serverId,
  4635.                             'serverUrl' => $serverUrl,
  4636.                             'systemType' => $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_',
  4637.                             'gocId' => $gocId,
  4638.                             'companyId' => $dt['company_id'],
  4639.                             'appId' => $dt['app_id'],
  4640.                             'companyLogoUrl' => $web_root_dir . $companyData['image'],
  4641.                             'companyName' => $companyData['name'],
  4642.                             'userCompanyIds' => [],
  4643.                             'userAppIds' => [],
  4644.                             'userCompanyList' => [
  4647.                             ]
  4648.                         );
  4650.                         $returnData[] = $d;
  4651.                         $returnDataByServerId[$serverId][] = $d;
  4653.                     }
  4656.                 }
  4659.                 //now suppliers
  4661.                 $emailFieldName = 'email';
  4662.                 $phoneFieldName = 'contact_number';
  4663.                 $query = "SELECT * from  acc_suppliers   where 1=1 ";
  4664.                 $query .= ($queryStrEmail != '') ? "and $emailFieldName like '$queryStrEmail'" : '';
  4665.                 $query .= ($queryStrPhone != '') ? "and $phoneFieldName like '%$queryStrPhone%'" : '';
  4666.                 $stmt = $em->getConnection()->prepare($query);
  4667.                 $stmt->execute();
  4668.                 $results = $stmt->fetchAll();
  4671.                 if (!empty($results)) {
  4672.                     foreach ($results as $dt) {
  4673.                         $dt['company_id'] = "1";
  4676.                         $companyData = isset($companyList[$dt['company_id']]) ? $companyList[$dt['company_id']] : [];
  4677.                         $d = array(
  4678.                             'userType' => strval(UserConstants::USER_TYPE_SUPPLIER),
  4679.                             'userName' => 'SID-' . str_pad($dt['supplier_id'], 8, '0', STR_PAD_LEFT),
  4680.                             'userId' => $dt['supplier_id'],
  4681.                             'loginUserName' => $dt['username'],
  4682.                             'email' => $dt['email'],
  4683.                             'phone' => $dt['contact_number'],
  4684.                             'serverId' => $serverId,
  4686.                             'serverUrl' => $serverUrl,
  4687.                             'systemType' => $this->container->hasParameter('system_type') ? $this->container->getParameter('system_type') : '_ERP_',
  4688.                             'gocId' => $gocId,
  4689.                             'companyId' => $dt['company_id'],
  4690.                             'appId' => $dt['app_id'],
  4691.                             'companyLogoUrl' => $web_root_dir . $companyData['image'],
  4692.                             'companyName' => $companyData['name'],
  4693.                             'userCompanyIds' => [],
  4694.                             'userAppIds' => [],
  4695.                             'userCompanyList' => [
  4698.                             ]
  4699.                         );
  4701.                         $returnData[] = $d;
  4702.                         $returnDataByServerId[$serverId][] = $d;
  4704.                     }
  4707.                 }
  4709.             }
  4712.         }
  4715.         return new JsonResponse(array(
  4716.             'success' => true,
  4717.             'data' => $returnData,
  4718.             'debugData' => $debugData,
  4719.             'dataByServerId' => $returnDataByServerId,
  4720.             'queryType' => $queryType
  4721.         ));
  4722.     }
  4724.     public function GetHoneybeeServerListAction(Request $request, $id = 0)
  4725.     {
  4726.         $serverList = GeneralConstant::$serverList;
  4729.         return new JsonResponse(array(
  4730.             'success' => true,
  4731.             'data' => $serverList,
  4733.         ));
  4734.     }
  4736.     public function ServerListAction()
  4737.     {
  4738.         $serverList = GeneralConstant::$serverList;
  4741.         return new JsonResponse(
  4742.             $serverList
  4744.         );
  4745.     }
  4747.     public function widgetModuleListAction()
  4748.     {
  4749.         $widgetsModuleList = [
  4750.             [
  4751.                 'name' => 'Accounts',
  4752.                 'id' => 1,
  4753.                 'hash' => '_ACC_',
  4754.                 'enabled' => true,
  4755.                 'hidden' => true,
  4756.             ],
  4757.             [
  4758.                 'name' => 'Sales',
  4759.                 'id' => 2,
  4760.                 'hash' => '_SL_',
  4761.                 'enabled' => true,
  4762.                 'hidden' => true,
  4763.             ],
  4764.             [
  4765.                 'name' => 'Human Resource',
  4766.                 'id' => 3,
  4767.                 'hash' => '_HRM_',
  4768.                 'enabled' => true,
  4769.                 'hidden' => true,
  4770.             ],
  4771.             [
  4772.                 'name' => 'Admin',
  4773.                 'id' => 4,
  4774.                 'hash' => '_ADM_',
  4775.                 'enabled' => true,
  4776.                 'hidden' => true,
  4777.             ],
  4780.         ];
  4781.         return new JsonResponse(
  4782.             array(
  4783.                 'success' => true,
  4784.                 'widgetModuleList' => $widgetsModuleList
  4785.             )
  4786.         );
  4787.     }
  4789.     public function widgetListAction()
  4790.     {
  4791.         $widgetsList = [
  4792.             [
  4793.                 'id' => 1,
  4794.                 'name' => 'Expense',
  4795.                 'hash' => '_EXP_',
  4796.                 'widgetModuleId' => 1,
  4797.                 'widgetName' => 'Accounts',
  4798.                 'screenName' => '',
  4799.                 'hidden' => true,
  4800.                 'enabled' => true,
  4801.                 'image' => 'https://e7.pngegg.com/pngimages/640/646/png-clipart-expense-management-computer-icons-finance-others-miscellaneous-text.png',
  4802.                 'showOnHome' => true,
  4803.                 'routeList' => [
  4805.                 ]
  4806.             ],
  4807.             [
  4808.                 'id' => 2,
  4809.                 'name' => 'Attendance',
  4810.                 'hash' => '_ATD_',
  4811.                 'widgetModuleId' => 3,
  4812.                 'widgetName' => 'Human Resource',
  4813.                 'screenName' => '',
  4814.                 'hidden' => true,
  4815.                 'enabled' => true,
  4816.                 'image' => 'https://cdn.iconscout.com/icon/premium/png-256-thumb/biometric-attendance-1-1106795.png',
  4817.                 'showOnHome' => true,
  4818.                 'routeList' => [
  4820.                 ]
  4821.             ],
  4822.             [
  4823.                 'id' => 3,
  4824.                 'name' => 'Payment',
  4825.                 'hash' => '_PMT_',
  4826.                 'widgetModuleId' => 1,
  4827.                 'widgetName' => 'Accounts',
  4828.                 'screenName' => '',
  4829.                 'hidden' => true,
  4830.                 'enabled' => true,
  4831.                 'image' => 'https://banner2.cleanpng.com/20180628/gbi/kisspng-management-accounting-accountant-gestin-kontabil-contador-5b356a344f40d2.2788485015302272523246.jpg',
  4832.                 'showOnHome' => true,
  4833.                 'routeList' => [
  4834.                     ["id" => 3, "route" => "create_payment_voucher", "name" => "Make Payment", "parentId" => 3,],
  4835.                     ["id" => 4, "route" => "create_receipt_voucher", "name" => "Make Receipt", "parentId" => 3,],
  4836.                 ]
  4837.             ],
  4838.             [
  4839.                 'id' => 4,
  4840.                 'name' => 'Report',
  4841.                 'hash' => '_RPRT_',
  4842.                 'widgetModuleId' => 1,
  4843.                 'widgetName' => 'Accounts',
  4844.                 'screenName' => '',
  4845.                 'hidden' => true,
  4846.                 'enabled' => true,
  4847.                 'image' => 'https://cdn-icons-png.flaticon.com/512/3093/3093748.png',
  4848.                 'showOnHome' => true,
  4849.                 'routeList' => [
  4851.                 ]
  4852.             ],
  4853.             [
  4854.                 'id' => 5,
  4855.                 'name' => 'Leave Application',
  4856.                 'hash' => '_LEVAPP_',
  4857.                 'widgetModuleId' => 3,
  4858.                 'widgetName' => 'Human Resource',
  4859.                 'screenName' => '',
  4860.                 'hidden' => true,
  4861.                 'enabled' => true,
  4862.                 'image' => 'https://icons.veryicon.com/png/o/transport/easy-office-system-icon-library/leave-request.png',
  4863.                 'showOnHome' => true,
  4864.                 'routeList' => [
  4866.                 ]
  4867.             ],
  4868.             [
  4869.                 'id' => 6,
  4870.                 'name' => 'Fund Requisition',
  4871.                 'hash' => '_FR_',
  4872.                 'widgetModuleId' => 1,
  4873.                 'widgetName' => 'Accounts',
  4874.                 'screenName' => '',
  4875.                 'hidden' => true,
  4876.                 'enabled' => true,
  4877.                 'image' => 'https://www.pngall.com/wp-content/uploads/13/Fund-PNG-Image.png',
  4878.                 'showOnHome' => true,
  4879.                 'routeList' => [
  4881.                 ]
  4882.             ],
  4883.             [
  4884.                 'id' => 7,
  4885.                 'name' => 'My Task',
  4886.                 'hash' => '_MT_',
  4887.                 'widgetModuleId' => 3,
  4888.                 'widgetName' => 'Human Resource',
  4889.                 'screenName' => '',
  4890.                 'hidden' => true,
  4891.                 'enabled' => true,
  4892.                 'image' => 'https://st.depositphotos.com/44273736/54272/v/450/depositphotos_542726218-stock-illustration-premium-download-icon-task-management.jpg',
  4893.                 'showOnHome' => true,
  4894.                 'routeList' => [
  4896.                 ]
  4897.             ],
  4898.             [
  4899.                 'id' => 8,
  4900.                 'name' => 'Fund Transfer',
  4901.                 'hash' => '_FT_',
  4902.                 'widgetModuleId' => 3,
  4903.                 'widgetName' => 'Accounts',
  4904.                 'screenName' => '',
  4905.                 'hidden' => true,
  4906.                 'enabled' => true,
  4907.                 'image' => 'https://l450v.alamy.com/450v/r1r4rx/money-transfer-vector-icon-isolated-on-transparent-background-money-transfer-transparency-logo-concept-r1r4rx.jpg',
  4908.                 'showOnHome' => true,
  4909.                 'routeList' => [
  4911.                 ]
  4912.             ],
  4913.             [
  4914.                 'id' => 9,
  4915.                 'name' => 'Stock Management',
  4916.                 'hash' => '_SM_',
  4917.                 'widgetModuleId' => 3,
  4918.                 'widgetName' => 'Inventory',
  4919.                 'screenName' => '',
  4920.                 'hidden' => true,
  4921.                 'enabled' => true,
  4922.                 'image' => 'https://l450v.alamy.com/450v/r1r4rx/money-transfer-vector-icon-isolated-on-transparent-background-money-transfer-transparency-logo-concept-r1r4rx.jpg',
  4923.                 'showOnHome' => true,
  4924.                 'routeList' => [
  4926.                 ]
  4927.             ],
  4928.             [
  4929.                 'id' => 10,
  4930.                 'name' => 'Approval',
  4931.                 'hash' => '_ADM_',
  4932.                 'widgetModuleId' => 4,
  4933.                 'widgetName' => 'Inventory',
  4934.                 'screenName' => '',
  4935.                 'hidden' => true,
  4936.                 'enabled' => true,
  4937.                 'image' => 'https://cdn.icon-icons.com/icons2/907/PNG/512/approve-sign-in-a-black-rounded-square-shape_icon-icons.com_70558.png',
  4938.                 'showOnHome' => true,
  4939.                 'routeList' => [
  4941.                 ]
  4942.             ],
  4944.         ];
  4945.         return new JsonResponse(
  4946.             array(
  4947.                 'success' => true,
  4948.                 'widgetList' => $widgetsList
  4949.             )
  4950.         );
  4951.     }
  4953.     public function addRemoveWidgetAction(Request $request, $id = 0)
  4954.     {
  4955.         $em = $this->getDoctrine()->getManager();
  4956. //        $user = $em->getRepository("ApplicationBundle:SysUser")
  4957. //            ->findBy();
  4958.         return new  JsonResponse(
  4959. //            $user
  4960.         );
  4961.     }
  4963.     public function EncryptParentModulesAction(Request $request, $appId = 0, $companyId = 0)
  4964.     {
  4965.         $message = "";
  4967.         $gocList = [];
  4968.         $outputList = [];
  4969.         $pmodules = [];
  4970.         if ($request->query->has('modulesByComma'))
  4971.             $pmodules = explode(',', $request->query->get('modulesByComma'));
  4974.         $iv = '1234567812345678';
  4975.         $pass = $appId . '_' . $companyId;
  4976.         //        $method = 'aes-256-cbc';
  4977.         $str = json_encode($pmodules);
  4978. //                        $str=$request->query->get('modulesByComma');
  4979.         $str = $str . 'YmLRocksLikeABoss';
  4980.         $data = $str;
  4981.         $data = openssl_encrypt($str, "AES-128-CBC", $pass, 0, $iv);
  4983.         //        $data=$str;
  4984. //                        $data = openssl_decrypt($data, "AES-128-CBC", $pass, 0, $iv);
  4985. //                        $data = openssl_decrypt(base64_decode(base64_encode($data)), "AES-128-CBC", $pass, 0, $iv);
  4988.         return new Response($data);
  4989. //        return new JsonResponse(array(
  4990. //            'encData'=>$data
  4991. //        ));
  4992.     }
  4994.     public function PrepareDatabaseAction(Request $request)
  4995.     {
  4996.         $message = "";
  4998.         $gocList = [];
  4999.         $outputList = [];
  5001.         $em = $this->getDoctrine()->getManager('company_group');
  5002.         $em->getConnection()->connect();
  5003.         $connected = $em->getConnection()->isConnected();
  5004.         if ($connected)
  5005.             $gocList = $this->getDoctrine()->getManager('company_group')
  5006.                 ->getRepository("CompanyGroupBundle:CompanyGroup")
  5007.                 ->findBy(
  5008.                     array(
  5009.                         'active' => 1
  5010.                     )
  5011.                 );
  5013.         $gocDataList = [];
  5014.         foreach ($gocList as $entry) {
  5015.             $d = array(
  5016.                 'name' => $entry->getName(),
  5017.                 'id' => $entry->getId(),
  5018.                 'dbName' => $entry->getDbName(),
  5019.                 'dbUser' => $entry->getDbUser(),
  5020.                 'dbPass' => $entry->getDbPass(),
  5021.                 'dbHost' => $entry->getDbHost(),
  5022.                 'appId' => $entry->getAppId(),
  5023.                 'companyRemaining' => $entry->getCompanyRemaining(),
  5024.                 'companyAllowed' => $entry->getCompanyAllowed(),
  5025.             );
  5026.             $gocDataList[$entry->getId()] = $d;
  5027.         }
  5028.         $gocDbName = '';
  5029.         $gocDbUser = '';
  5030.         $gocDbPass = '';
  5031.         $gocDbHost = '';
  5032.         $gocId = 0;
  5035. //        $path = $this->container->get('templating.helper.assets')->getUrl('bundles/tlfront/js/channels.json');
  5036.         $config_dir = $this->container->getParameter('kernel.root_dir') . '/gifnoc/';
  5037.         if (!file_exists($config_dir)) {
  5038.             mkdir($config_dir, 0777, true);
  5039.         }
  5040. //        $path = $this->container->getParameter('kernel.root_dir') . '/gifnoc/givnocppa.json';
  5041. //        $content = file_exists($path) ? file_get_contents($path) : null;
  5042.         $content = [];
  5043.         $configJson = array();
  5044.         if ($content)
  5045.             $configJson = json_decode($content, true);
  5047.         $configJsonOld = $configJson;
  5048. //        if($configJson)
  5049. //        {
  5050. //
  5051. //        }
  5052. //        else
  5053.         {
  5054.             $configJson['appVersion'] = GeneralConstant::ENTITY_APP_VERSION;
  5055.             $configJson['dataBaseSchemaUpdateFlag'] = GeneralConstant::ENTITY_APP_FLAG_TRUE;
  5056.             $configJson['initiateDataBaseFlag'] = GeneralConstant::ENTITY_APP_FLAG_FALSE;
  5057.             $configJson['initiateDataBaseFlagByGoc'] = array();
  5058.             $configJson['motherLode'] = "http://innobd.com";
  5059.             foreach ($gocDataList as $gocId => $entry) {
  5060.                 $configJson['initiateDataBaseFlagByGoc'][$gocId . "_" . $entry['appId']] = GeneralConstant::ENTITY_APP_FLAG_TRUE;
  5061.             }
  5062.         }
  5064.         //now check if database shcema update is true
  5065. //        if($configJson['dataBaseSchemaUpdateFlag']==GeneralConstant::ENTITY_APP_FLAG_TRUE)
  5066.         if (1) //temporary overwrite all
  5067.         {
  5069.             //if goclist is not empty switch to each company dbase and schema update
  5070. //            if(!empty($gocDataList))
  5071.             if (1) {
  5072.                 foreach ($gocDataList as $gocId => $entry) {
  5074.                     if ($configJson['initiateDataBaseFlagByGoc'][$gocId . "_" . $entry['appId']] == GeneralConstant::ENTITY_APP_FLAG_TRUE) {
  5076.                         $connector = $this->container->get('application_connector');
  5077.                         $connector->resetConnection(
  5078.                             'default',
  5079.                             $gocDataList[$gocId]['dbName'],
  5080.                             $gocDataList[$gocId]['dbUser'],
  5081.                             $gocDataList[$gocId]['dbPass'],
  5082.                             $gocDataList[$gocId]['dbHost'],
  5083.                             true);
  5084.                         $em = $this->getDoctrine()->getManager();
  5086.                         if ($em->getConnection()->isConnected()) {
  5088.                         } else {
  5089.                             $servername = $gocDataList[$gocId]['dbHost'];
  5090.                             $username = $gocDataList[$gocId]['dbUser'];
  5091.                             $password = $gocDataList[$gocId]['dbPass'];
  5093. // Create connection
  5094.                             $conn = new \mysqli($servername, $username, $password);
  5095. // Check connection
  5096.                             if ($conn->connect_error) {
  5097.                                 die("Connection failed: " . $conn->connect_error);
  5098.                             }
  5100. // Create database
  5101.                             $sql = "CREATE DATABASE " . $gocDataList[$gocId]['dbName'];
  5102.                             if ($conn->query($sql) === TRUE) {
  5103. //                                echo "Database created successfully";
  5104.                             } else {
  5105. //                                echo "Error creating database: " . $conn->error;
  5106.                             }
  5108.                             $conn->close();
  5109.                         }
  5110.                         $connector->resetConnection(
  5111.                             'default',
  5112.                             $gocDataList[$gocId]['dbName'],
  5113.                             $gocDataList[$gocId]['dbUser'],
  5114.                             $gocDataList[$gocId]['dbPass'],
  5115.                             $gocDataList[$gocId]['dbHost'],
  5116.                             true);
  5117.                         $em = $this->getDoctrine()->getManager();
  5120.                         $tool = new SchemaTool($em);
  5122.                         $classes = $em->getMetadataFactory()->getAllMetadata();
  5123. //                    $tool->createSchema($classes);
  5124.                         $tool->updateSchema($classes);
  5126.                         //new for updating app id
  5127.                         $get_kids_sql = "UPDATE `company` set app_id=" . $entry['appId'] . " ;
  5128.                                         UPDATE `sys_user` set app_id=" . $entry['appId'] . " ;";
  5129.                         $stmt = $em->getConnection()->prepare($get_kids_sql);
  5130.                         $stmt->execute();
  5131.                         $stmt->closeCursor();
  5133.                         $configJson['initiateDataBaseFlagByGoc'][$gocId . "_" . $entry['appId']] = GeneralConstant::ENTITY_APP_FLAG_FALSE;
  5135.                         //this is for large amount of goc we will see  later
  5136. //                        file_put_contents($path, json_encode($configJson));//overwrite
  5137. //                        return $this->redirectToRoute('update_database_schema');
  5139.                     }
  5142.                 }
  5143.             } else {
  5144.                 $em = $this->getDoctrine()->getManager();
  5146.                 $tool = new SchemaTool($em);
  5147. //                    $classes = array(
  5148. //                        $em->getClassMetadata('Entities\User'),
  5149. //                        $em->getClassMetadata('Entities\Profile')
  5150. //                    );
  5151.                 $classes = $em->getMetadataFactory()->getAllMetadata();
  5152. //                    $tool->createSchema($classes);
  5153.                 $tool->updateSchema($classes);
  5154.             }
  5157.         }
  5158.         $allSchemaUpdateDone = 1;
  5160.         foreach ($configJson['initiateDataBaseFlagByGoc'] as $flag) {
  5161.             if ($flag == GeneralConstant::ENTITY_APP_FLAG_TRUE)
  5162.                 $allSchemaUpdateDone = 0;
  5163.         }
  5164.         if ($allSchemaUpdateDone == 1)
  5165.             $configJson['dataBaseSchemaUpdateFlag'] = GeneralConstant::ENTITY_APP_FLAG_FALSE;
  5168.         ///last
  5169. //        file_put_contents($path, json_encode($configJson));//overwrite
  5172.         return new Response(json_encode($configJsonOld));
  5173.     }
  5175.     public function ConvertSpecificationToSubCategoryAction(Request $request)
  5176.     {
  5177.         $message = "";
  5179.         $gocList = [];
  5180.         $outputList = [];
  5182.         $em = $this->getDoctrine()->getManager('company_group');
  5183.         $em->getConnection()->connect();
  5184.         $connected = $em->getConnection()->isConnected();
  5185.         if ($connected)
  5186.             $gocList = $this->getDoctrine()->getManager('company_group')
  5187.                 ->getRepository("CompanyGroupBundle:CompanyGroup")
  5188.                 ->findBy(
  5189.                     array(
  5190.                         'active' => 1
  5191.                     )
  5192.                 );
  5194.         $gocDataList = [];
  5195.         foreach ($gocList as $entry) {
  5196.             $d = array(
  5197.                 'name' => $entry->getName(),
  5198.                 'id' => $entry->getId(),
  5199.                 'dbName' => $entry->getDbName(),
  5200.                 'dbUser' => $entry->getDbUser(),
  5201.                 'dbPass' => $entry->getDbPass(),
  5202.                 'dbHost' => $entry->getDbHost(),
  5203.                 'appId' => $entry->getAppId(),
  5204.                 'companyRemaining' => $entry->getCompanyRemaining(),
  5205.                 'companyAllowed' => $entry->getCompanyAllowed(),
  5206.             );
  5207.             $gocDataList[$entry->getId()] = $d;
  5208.         }
  5209.         $gocDbName = '';
  5210.         $gocDbUser = '';
  5211.         $gocDbPass = '';
  5212.         $gocDbHost = '';
  5213.         $gocId = 0;
  5216. //        $path = $this->container->get('templating.helper.assets')->getUrl('bundles/tlfront/js/channels.json');
  5217.         $config_dir = $this->container->getParameter('kernel.root_dir') . '/gifnoc/';
  5218.         if (!file_exists($config_dir)) {
  5219.             mkdir($config_dir, 0777, true);
  5220.         }
  5221. //        $path = $this->container->getParameter('kernel.root_dir') . '/gifnoc/givnocppa.json';
  5222. //        $content = file_exists($path) ? file_get_contents($path) : null;
  5223.         $content = [];
  5224.         $configJson = array();
  5225.         if ($content)
  5226.             $configJson = json_decode($content, true);
  5228.         $configJsonOld = $configJson;
  5229. //        if($configJson)
  5230. //        {
  5231. //
  5232. //        }
  5233. //        else
  5234.         {
  5235.             $configJson['appVersion'] = GeneralConstant::ENTITY_APP_VERSION;
  5236.             $configJson['dataBaseSchemaUpdateFlag'] = GeneralConstant::ENTITY_APP_FLAG_TRUE;
  5237.             $configJson['initiateDataBaseFlag'] = GeneralConstant::ENTITY_APP_FLAG_FALSE;
  5238.             $configJson['initiateDataBaseFlagByGoc'] = array();
  5239.             $configJson['motherLode'] = "http://innobd.com";
  5240.             foreach ($gocDataList as $gocId => $entry) {
  5241.                 $configJson['initiateDataBaseFlagByGoc'][$gocId . "_" . $entry['appId']] = GeneralConstant::ENTITY_APP_FLAG_TRUE;
  5242.             }
  5243.         }
  5245.         $foundClasses = [];
  5248.         if (1) {
  5249.             foreach ($gocDataList as $gocId => $entry) {
  5252.                 $connector = $this->container->get('application_connector');
  5253.                 $connector->resetConnection(
  5254.                     'default',
  5255.                     $gocDataList[$gocId]['dbName'],
  5256.                     $gocDataList[$gocId]['dbUser'],
  5257.                     $gocDataList[$gocId]['dbPass'],
  5258.                     $gocDataList[$gocId]['dbHost'],
  5259.                     $reset = true);
  5260.                 $em = $this->getDoctrine()->getManager();
  5262. /////////////////////////////Now get all entity and if entity has specificationId (and subcatid) the asssign
  5263.                 $query = "show tables;";
  5264.                 $query = "SELECT DISTINCT TABLE_NAME
  5265.     FROM INFORMATION_SCHEMA.COLUMNS
  5266.     WHERE COLUMN_NAME IN ('specification_id','sub_category_id')
  5267.         AND TABLE_SCHEMA='" . $gocDataList[$gocId]['dbName'] . "' ;";
  5269.                 $stmt = $em->getConnection()->prepare($query);
  5270.                 $stmt->execute();
  5271.                 $tables = $stmt->fetchAll();
  5273.                 foreach ($tables as $tablename) {
  5275. //                        $theClass=new $entity;
  5276.                     $foundClasses[] = $tablename['TABLE_NAME'];
  5277.                     $query = "UPDATE " . $tablename['TABLE_NAME'] . " set sub_category_id=specification_id where 1;";
  5279.                     $stmt = $em->getConnection()->prepare($query);
  5280.                     $stmt->execute();
  5283.                     $query = "UPDATE " . $tablename['TABLE_NAME'] . " set specification_id=null;";
  5285.                     $stmt = $em->getConnection()->prepare($query);
  5286.                     $stmt->execute();
  5288.                 }
  5290.                 //now add all spec to cat table
  5291.                 $query = "TRUNCATE  inv_product_sub_categories";
  5293.                 $stmt = $em->getConnection()->prepare($query);
  5294.                 $stmt->execute();
  5296.                 $query = "SELECT * FROM inv_product_specifications WHERE 1;";
  5298.                 $stmt = $em->getConnection()->prepare($query);
  5299.                 $stmt->execute();
  5300.                 $results = $stmt->fetchAll();
  5302.                 foreach ($results as $result) {
  5303.                     foreach ($result as $k => $res) {
  5304.                         if ($res == '')
  5305.                             $result[$k] = 'NULL';
  5307.                     }
  5310.                     $query = "INSERT INTO `inv_product_sub_categories`(`id`,  `name`, `status`, `ig_id`, `category_id`, `company_id`,  `created_login_id`, `edited_login_id`, `created_at`, `updated_at`)
  5312. VALUES (" . $result['id'] . ",'" . str_replace("'", "''", $result['name']) . "'," . $result['status'] . "," . $result['ig_id'] . "," . $result['category_id'] . "," . $result['company_id'] . "," . $result['created_login_id'] . "," . $result['edited_login_id'] . ",'" . $result['created_at'] . "','" . $result['updated_at'] . "')";
  5314.                     $stmt = $em->getConnection()->prepare($query);
  5315.                     $stmt->execute();
  5317.                 }
  5318.                 $query = "TRUNCATE  inv_product_specifications";
  5320.                 $stmt = $em->getConnection()->prepare($query);
  5321.                 $stmt->execute();
  5324.             }
  5325.         }
  5328.         return new Response(json_encode($foundClasses));
  5329.     }
  5331.     public function initiateAdminAction(Request $request)
  5332.     {
  5333.         $em = $this->getDoctrine()->getManager();
  5335.         $em_goc = $this->getDoctrine()->getManager('company_group');
  5336.         $em_goc->getConnection()->connect();
  5337.         $gocId = 0;
  5338.         $appId = 0;
  5339.         $gocEnabled = 0;
  5340.         if ($this->container->hasParameter('entity_group_enabled'))
  5341.             $gocEnabled = $this->container->getParameter('entity_group_enabled');
  5342.         if ($gocEnabled == 1)
  5343.             $connected = $em_goc->getConnection()->isConnected();
  5344.         else
  5345.             $connected = false;
  5347.         if ($connected)
  5348.             $gocList = $em_goc
  5349.                 ->getRepository("CompanyGroupBundle:CompanyGroup")
  5350.                 ->findBy(
  5351.                     array(
  5352.                         'active' => 1
  5353.                     )
  5354.                 );
  5356.         $gocDataList = [];
  5357.         $gocDataListForLoginWeb = [];
  5358.         $gocDataListByAppId = [];
  5359.         foreach ($gocList as $entry) {
  5360.             $d = array(
  5361.                 'name' => $entry->getName(),
  5362.                 'id' => $entry->getId(),
  5363.                 'appId' => $entry->getAppId(),
  5364.                 'skipInWebFlag' => $entry->getSkipInWebFlag(),
  5365.                 'skipInAppFlag' => $entry->getSkipInAppFlag(),
  5367.                 'dbName' => $entry->getDbName(),
  5368.                 'dbUser' => $entry->getDbUser(),
  5369.                 'dbPass' => $entry->getDbPass(),
  5370.                 'dbHost' => $entry->getDbHost(),
  5371.                 'companyRemaining' => $entry->getCompanyRemaining(),
  5372.                 'companyAllowed' => $entry->getCompanyAllowed(),
  5373.             );
  5374.             $gocDataList[$entry->getId()] = $d;
  5375.             if (in_array($entry->getSkipInWebFlag(), [0, null]))
  5376.                 $gocDataListForLoginWeb[$entry->getId()] = $d;
  5377.             $gocDataListByAppId[$entry->getAppId()] = $d;
  5378.         }
  5379.         if ($request->request->has('gocId') || $request->query->has('gocId')) {
  5380.             $hasGoc = 1;
  5381.             $gocId = $request->request->get('gocId');
  5382.         }
  5383.         if ($request->request->has('appId') || $request->query->has('appId')) {
  5384.             $hasGoc = 1;
  5385.             $appId = $request->request->get('appId');
  5386.         }
  5388.         $refRoute = $request->request->get('refRoute', $request->query->get('refRoute', ''));
  5391.         if ($hasGoc == 1) {
  5393.             if ($gocId != 0 && $gocId != "") {
  5394.                 $appId = $gocDataList[$gocId]['appId'];
  5396.                 $connector = $this->container->get('application_connector');
  5397.                 $connector->resetConnection(
  5398.                     'default',
  5399.                     $gocDataList[$gocId]['dbName'],
  5400.                     $gocDataList[$gocId]['dbUser'],
  5401.                     $gocDataList[$gocId]['dbPass'],
  5402.                     $gocDataList[$gocId]['dbHost'],
  5403.                     $reset = true
  5404.                 );
  5405.             } else if ($appId != 0 && $appId != "") {
  5407.                 $gocDbName = $gocDataListByAppId[$appId]['dbName'];
  5408.                 $gocDbUser = $gocDataListByAppId[$appId]['dbUser'];
  5409.                 $gocDbPass = $gocDataListByAppId[$appId]['dbPass'];
  5410.                 $gocDbHost = $gocDataListByAppId[$appId]['dbHost'];
  5411.                 $gocId = $gocDataListByAppId[$appId]['id'];
  5414.                 $connector = $this->container->get('application_connector');
  5415.                 $connector->resetConnection(
  5416.                     'default',
  5417.                     $gocDbName,
  5418.                     $gocDbUser,
  5419.                     $gocDbPass,
  5420.                     $gocDbHost,
  5421.                     $reset = true
  5422.                 );
  5423.             }
  5424.         }
  5427.         $userName = $request->request->get('username', $request->query->get('username', 'admin'));
  5428.         $name = $request->request->get('name', $request->query->get('name', 'System Admin'));
  5429.         $password = $request->request->get('password', $request->query->get('password', 'admin'));
  5430.         $email = $request->request->get('email', $request->query->get('email', 'admin'));
  5431.         $encodedPassword = $this->container->get('sha256salted_encoder')->encodePassword($password, $userName);
  5432.         $companyIds = $request->request->get('companyIds', $request->query->get('companyIds', [1]));
  5433.         $branchIds = $request->request->get('branchIds', $request->query->get('branchIds', [1]));
  5434.         $appIds = $request->request->get('appIds', $request->query->get('appIds', [$appId]));
  5435.         $freshFlag = $request->request->get('fresh', $request->query->get('fresh', 1));
  5438.         if ($freshFlag == 1) {
  5439.             $query = "DELETE FROM sys_user WHERE user_type=1";
  5441.             $stmt = $em->getConnection()->prepare($query);
  5442.             $stmt->execute();
  5443.         }
  5444.         $message = $this->get('user_module')->addNewUser(
  5445.             $name,
  5446.             $email,
  5447.             $userName,
  5448.             $password,
  5449.             '',
  5450.             0,
  5451.             1,
  5452.             UserConstants::USER_TYPE_SYSTEM,
  5453.             $companyIds,
  5454.             $branchIds,
  5455.             '',
  5456.             "",
  5457.             1
  5459.         );
  5460.         $companyData = $message[2];
  5461.         if ($message[0] == 'success') {
  5462.             $oAuthData = [
  5463.                 'email' => $email,
  5464.                 'uniqueId' => '',
  5465.                 'image' => '',
  5466.                 'emailVerified' => '',
  5467.                 'name' => $name,
  5468.                 'type' => '0',
  5469.                 'token' => '',
  5470.             ];
  5472.             if (GeneralConstant::EMAIL_ENABLED == 1) {
  5475.                 $bodyHtml = '';
  5476.                 $bodyTemplate = 'ApplicationBundle:email/templates:userRegistrationCompleteHoneybee.html.twig';
  5477.                 $bodyData = array(
  5478.                     'name' => $name,
  5479.                     'email' => $email,
  5480.                     'password' => $password,
  5481.                 );
  5482.                 $attachments = [];
  5483.                 $forwardToMailAddress = $email;
  5484.                 if (filter_var($forwardToMailAddress, FILTER_VALIDATE_EMAIL)) {
  5486. //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  5487.                     $new_mail = $this->get('mail_module');
  5488.                     $new_mail->sendMyMail(array(
  5489.                         'senderHash' => '_CUSTOM_',
  5490.                         //                        'senderHash'=>'_CUSTOM_',
  5491.                         'forwardToMailAddress' => $forwardToMailAddress,
  5493.                         'subject' => 'Welcome to Honeybee Ecosystem ',
  5495. //                        'fileName' => 'Order#' . str_pad($id, 8, '0', STR_PAD_LEFT) . '.pdf',
  5496.                         'attachments' => $attachments,
  5497.                         'toAddress' => $forwardToMailAddress,
  5498.                         'fromAddress' => 'no-reply@ourhoneybee.eu',
  5499.                         'userName' => 'no-reply@ourhoneybee.eu',
  5500.                         'password' => 'Honeybee@0112',
  5501.                         'smtpServer' => 'smtp.hostinger.com',
  5502.                         'smtpPort' => 465,
  5503. //                            'emailBody' => $bodyHtml,
  5504.                         'mailTemplate' => $bodyTemplate,
  5505.                         'templateData' => $bodyData,
  5506. //                        'embedCompanyImage' => 1,
  5507. //                        'companyId' => $companyId,
  5508. //                        'companyImagePath' => $company_data->getImage()
  5511.                     ));
  5512.                 }
  5515.             }
  5517. //            if ($request->request->get('remoteVerify', 0) == 1)
  5518. ////                if(1)
  5519. //                return new JsonResponse(array(
  5520. //                    'success' => true,
  5521. //                    'successStr' => 'Account Created Successfully',
  5522. //                    'id' => $newApplicant->getApplicantId(),
  5523. //                    'oAuthData' => $oAuthData,
  5524. //                    'refRoute' => $refRoute,
  5525. //                    'remoteVerify' => 1,
  5526. //                ));
  5527. //            else
  5528. //                return $this->redirectToRoute("user_login", [
  5529. //                    'id' => $newApplicant->getApplicantId(),
  5530. //                    'oAuthData' => $oAuthData,
  5531. //                    'refRoute' => $refRoute,
  5532. //
  5533. //                ]);
  5534.             $bodyHtml = '';
  5535.             $bodyTemplate = 'ApplicationBundle:email/user:registration.html.twig';
  5536.             $bodyData = array(
  5537.                 'name' => $request->request->get('name'),
  5538.                 'companyData' => $companyData,
  5539.                 'userName' => $request->request->get('username'),
  5540.                 'password' => $request->request->get('password'),
  5541.             );
  5542.             $attachments = [];
  5545. //                    $upl_dir = $this->container->getParameter('kernel.root_dir') . '/../web/uploads/temp/' . 'ledger' . '.pdf'
  5546.             $new_mail = $this->get('mail_module');
  5547.             $new_mail->sendMyMail(array(
  5548.                 'senderHash' => '_USER_MANAGEMENT_',
  5549.                 //                        'senderHash'=>'_CUSTOM_',
  5550.                 'forwardToMailAddress' => $request->request->get('email'),
  5552.                 'subject' => 'User Registration on HoneyBee Ecosystem under Company ' . $companyData->getName(),
  5554.                 'fileName' => '',
  5555.                 'attachments' => $attachments,
  5556.                 'toAddress' => $request->request->get('email'),
  5557. //                        'fromAddress'=>'sales@entity.innobd.com',
  5558. //                        'userName'=>'sales@entity.innobd.com',
  5559. //                        'password'=>'Y41dh8g0112',
  5560. //                        'smtpServer'=>'smtp.hostinger.com',
  5561. //                        'smtpPort'=>587,
  5562. //                        'emailBody'=>$bodyHtml,
  5563.                 'mailTemplate' => $bodyTemplate,
  5564.                 'templateData' => $bodyData,
  5565.                 'embedCompanyImage' => 1,
  5566.                 'companyId' => $request->request->get('company'),
  5567.                 'companyImagePath' => $companyData->getImage()
  5570.             ));
  5572. //                $emailmessage = (new \Swift_Message('Registration to Entity'))
  5573. //                    ->setFrom('registration@entity.innobd.com')
  5574. //                    ->setTo($request->request->get('email'))
  5575. //                    ->setBody(
  5576. //                        $this->renderView(
  5577. //                            'ApplicationBundle:email/user:registration.html.twig',
  5578. //                            array('name' => $request->request->get('name'),
  5579. //                                'companyData' => $companyData,
  5580. //                                'userName' => $request->request->get('email'),
  5581. //                                'password' => $request->request->get('password'),
  5582. //                            )
  5583. //                        ),
  5584. //                        'text/html'
  5585. //                    );
  5586. //                /*
  5587. //                 * If you also want to include a plaintext version of the message
  5588. //                ->addPart(
  5589. //                    $this->renderView(
  5590. //                        'Emails/registration.txt.twig',
  5591. //                        array('name' => $name)
  5592. //                    ),
  5593. //                    'text/plain'
  5594. //                )
  5595. //                */
  5596. ////            ;
  5597. //                $this->get('mailer')->send($emailmessage);
  5598.         }
  5601.         $this->addFlash(
  5602.             $message[0],
  5603.             $message[1]
  5604.         );
  5607. //        MiscActions::initiateAdminUser($em,$freshFlag,$userName,$name,$email,$encodedPassword,$appIds,$companyIds);
  5609.         $this->addFlash(
  5610.             'success',
  5611.             'The Action was Successful.'
  5612.         );
  5615.         return $this->redirectToRoute('user_login');
  5616.     }
  5618.     public function DumpCurrModulesAction(Request $request)
  5619.     {
  5620.         $em = $this->getDoctrine()->getManager();
  5621.         $modules = $em->getRepository("ApplicationBundle:SysModule")
  5622.             ->findBy(
  5623.                 array(//                    'active'=>1
  5624.                 )
  5625.             );
  5626.         $module_data = [];
  5627.         foreach ($modules as $entry) {
  5628.             $dt = array(
  5629.                 'id' => $entry->getModuleId(),
  5630.                 'route' => $entry->getModuleRoute(),
  5631.                 'name' => $entry->getModuleName(),
  5632.                 'parentId' => $entry->getParentId(),
  5633.                 'level' => $entry->getLevel(),
  5634.                 'eFA' => $entry->getEnabledForAll(),
  5635.             );
  5636.             $module_data[$entry->getModuleId()] = $dt;
  5638.         }
  5641.         return new JsonResponse(
  5642.             $module_data
  5643.         );
  5644.     }
  5647. }