src/Globals/ResourceManagementBundle/Controller/ResourceController.php line 434

Open in your IDE?
  1. <?php
  2. /**
  3.  * Created by PhpStorm.
  4.  * User: AHawley
  5.  * Date: 3/13/2017
  6.  * Time: 10:58 AM
  7.  */
  9. namespace Globals\ResourceManagementBundle\Controller;
  11. use Globals\CoreBundle\Entity\SystemControlMetadata;
  12. use Globals\CoreBundle\Helpers\MailHelper;
  13. use Globals\ResourceManagementBundle\DependencyInjection\ExportFileUtils;
  14. use Globals\ResourceManagementBundle\Entity\UserNote;
  15. use Globals\ResourceManagementBundle\Form\ResourceType;
  16. use Doctrine\ORM\EntityManager;
  17. use Globals\ResourceManagementBundle\DependencyInjection\FormHelpers\ResourceFormHelper;
  18. use Globals\ResourceManagementBundle\Entity\Resource;
  19. use Globals\ResourceManagementBundle\Entity\TeamsNotUsed;
  20. use Globals\ResourceManagementBundle\Entity\ResourceWingspanGroupMap;
  21. use Globals\ResourceManagementBundle\Entity\UserToken;
  22. use Globals\ResourceManagementBundle\Enum\ResourceRoleEnum;
  23. use Globals\ResourceManagementBundle\Service\PaginatorSQL;
  24. use Globals\ResourceManagementBundle\Service\SLogger;
  25. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  26. use Symfony\Component\HttpFoundation\JsonResponse;
  27. use Symfony\Component\HttpFoundation\Request;
  28. use Symfony\Component\HttpFoundation\Response;
  29. use Symfony\Component\HttpFoundation\Session\Session;
  30. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  31. use Symfony\Component\Routing\Annotation\Route;
  32. use Globals\ResourceManagementBundle\Event\ResourceCreatedEvent;
  33. use Globals\ResourceManagementBundle\Event\ResourceUpdatedEvent;
  34. use Globals\MailManagementBundle\Entity\Mail;
  35. use Globals\MailManagementBundle\Entity\MailRecipient;
  36. use Globals\ResourceManagementBundle\Entity\AdjusterComment;
  37. use Globals\ResourceManagementBundle\Service\WingSpanService;
  38. use Globals\ResourceManagementBundle\Entity\Contract;
  40. class ResourceController extends AbstractController
  41. {
  43.     /**
  44.      * Base Route (Vaughn's style)
  45.      *
  46.      * @Route("/administration/resource")
  47.      */
  48.     public function resources2Action()
  49.     {
  50.         return $this->render("ResourceManagementBundle:resources:index2.html.twig", []);
  51.     }
  53.     /**
  54.      * @Route("/administration/resource/check_blob")
  55.      */
  56.     public function checkBlobLineItem()
  57.     {
  58.         $em = $this->getDoctrine()->getManager();
  60.         $sql = "SELECT * FROM commission_report cr WHERE cr.invoice_id = :invoice_id AND invoice_type_id <> 4 ";
  61.         $stmt = $em->getConnection()->prepare($sql);
  63.         echo "<pre>";
  64.         $stmt->execute([
  65.             "invoice_id" => 201749,
  66.         ]);
  67.         $results = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  68.         if (count($results) > 0) {
  70.             $Item = $results[0];
  72.             print_r(json_decode($Item['report_data']));
  73.         }
  74.         dump("script completed"); die;
  75.     }
  78.     /**
  79.      * @Route("/administration/resource/undo_cm/{invoiceId}")
  80.      */
  81.     public function undoCreditMemo($invoiceId)
  82.     {
  83.         $em = $this->getDoctrine()->getManager();
  85.         $sql = "DELETE FROM commission_report 
  86.                 WHERE invoice_id = :id AND invoice_type_id = 4 ";
  87.         $stmt_delete_commission_report = $em->getConnection()->prepare($sql);
  89.         $sql = "DELETE FROM invoice_cm 
  90.                 WHERE invoice_id = :invoice_id  ";
  91.         $stmt_delete_invoice_cm = $em->getConnection()->prepare($sql);
  93.         $sql = "SELECT id 
  94.                 FROM invoice_cm
  95.                 WHERE invoice_id = :invoice_id ";
  97.         $stmt = $em->getConnection()->prepare($sql);
  98.         $stmt->execute([
  99.             "invoice_id" => $invoiceId
  100.         ]);
  101.         $results = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  103.         foreach ($results as $getEach) {
  105.             $sql = "DELETE FROM commission_report WHERE invoice_id = :id AND invoice_type_id = 4 ";
  106.             echo "<pre>";
  107.             echo "sql: $sql \n";
  108.             print_r([
  109.                 "id" => $getEach['id']
  110.             ]);
  111.             //*/
  112.             $stmt_delete_commission_report->execute([
  113.                 "id" => $getEach['id']
  114.             ]);
  115.             //*/
  117.             $sql = "DELETE FROM invoice_cm 
  118.                     WHERE invoice_id = :invoice_id;";
  119.             //*/
  120.             $stmt_delete_invoice_cm->execute([
  121.                 "invoice_id" => $invoiceId,
  122.             ]);
  123.             //*/
  125.             echo "<pre>";
  126.             echo "sql: $sql \n";
  127.             print_r([
  128.                 "invoice_id" => $invoiceId,
  129.             ]);
  130.         }
  131.         dump("script completed"); die;
  132.     }
  135.     /**
  136.      * @Route("/administration/resource/regrind_cm/{invoiceId}")
  137.      */
  138.     public function regrindCreditMemo($invoiceId)
  139.     {
  140.         $em = $this->getDoctrine()->getManager();
  142.         $sql = "SELECT * 
  143.                 FROM commission_report 
  144.                 WHERE invoice_id = :invoice_id 
  145.                 AND invoice_type_id <> 4 ";
  146.         $stmt = $em->getConnection()->prepare($sql);
  147.         $stmt->execute([
  148.             "invoice_id" => $invoiceId
  149.         ]);
  150.         $CommReports = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  151.         if (count($CommReports) > 0) {
  153.             $GetCommReport = $CommReports[0];
  154.             $report_data = json_decode($GetCommReport['report_data']);
  156.             $report_data = $this->negateCreditMemoBlob($report_data, $invoiceId);
  158.             $sql = "SELECT id FROM invoice_cm WHERE invoice_id = :invoice_id ";
  159.             $stmt = $em->getConnection()->prepare($sql);
  160.             $stmt->execute([
  161.                 "invoice_id" => $invoiceId
  162.             ]);
  163.             $InvoiceCMs = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  164.             if (count($InvoiceCMs) > 0) {
  166.                 $InvoiceCM = $InvoiceCMs[0];
  168.                 $sql = "UPDATE commission_report  
  169.                         SET report_data = :report_data,
  170.                         updated_at = :updated_at
  171.                         WHERE invoice_id = :invoice_id 
  172.                         AND invoice_type_id = 4 ";
  173.                 $stmt = $em->getConnection()->prepare($sql);
  174.                 $stmt->execute([
  175.                     "report_data" => json_encode($report_data),
  176.                     "invoice_id" => $InvoiceCM['id'],
  177.                     "updated_at" => date("Y-m-d H:i:s")
  178.                 ]);
  179.             }
  180.         }
  181.         dump("Script Completed"); die();
  182.     }
  184.     private function negateCreditMemoBlob($report_data, $originalInvId)
  185.     {
  186.         $em = $this->getDoctrine()->getManager();
  188.         $sql = "SELECT id
  189.                     FROM invoice_cm  
  190.                     WHERE invoice_id = :invoice_id LIMIT 1 ";
  192.         $stmt = $em->getConnection()->prepare($sql);
  193.         $stmt->execute([
  194.             "invoice_id" => $originalInvId
  195.         ]);
  196.         $InvoiceCMs = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  197.         if (count($InvoiceCMs) > 0) {
  199.             $invoiceCMId = $InvoiceCMs[0]['id'];
  201.             $report_data->claimData->dateCreated = date("Y-m-d H:i:s");
  202.             $report_data->claimData->TypeCode = "CM";
  203.             $report_data->claimData->inv_id = $invoiceCMId;
  204.             $report_data->claimData->invoice_type_id = 4;
  206.             $report_data->claimData->netTotal = -1 * floatval($report_data->claimData->netTotal);
  207.             $report_data->claimData->subTotal = -1 * floatval($report_data->claimData->subTotal);
  208.             $report_data->claimData->taxTotal = -1 * floatval($report_data->claimData->taxTotal);
  209.             $report_data->claimData->te_total = -1 * floatval($report_data->claimData->te_total);
  210.             $report_data->claimData->serviceExpense = -1 * floatval($report_data->claimData->serviceExpense);
  211.             $report_data->claimData->disbursementTotal = -1 * floatval($report_data->claimData->disbursementTotal);
  212.             if (property_exists($report_data, "invoice_resource_commission")) {
  213.                 foreach ($report_data->invoice_resource_commission as $index => $getCommission) {
  214.                     $report_data->invoice_resource_commission[$index]->amount = -1 * floatval($report_data->invoice_resource_commission[$index]->amount);
  215.                 }
  216.             }
  217.             if (property_exists($report_data->claimData, "discount_max_summary")) {
  218.                 foreach ($report_data->claimData->discount_max_summary as $expenseIndex => $getDiscount) {
  220.                     if (is_array($report_data->claimData->discount_max_summary)) {
  221.                         if (isset($report_data->claimData->discount_max_summary[$expenseIndex])
  222.                             && count($report_data->claimData->discount_max_summary[$expenseIndex]) > 0
  223.                             && property_exists($report_data->claimData->discount_max_summary[$expenseIndex], "subtotal")) {
  224.                             $report_data->claimData->discount_max_summary[$expenseIndex]->subtotal = floatval($report_data->claimData->discount_max_summary[$expenseIndex]->subtotal) * -1;
  225.                         }
  226.                     } else {
  227.                         if (is_array(($report_data->claimData->discount_max_summary->$expenseIndex))) {
  228.                             if (isset($report_data->claimData->discount_max_summary->$expenseIndex["subtotal"])) {
  229.                                 $report_data->claimData->discount_max_summary->{$expenseIndex}["subtotal"] = floatval($report_data->claimData->discount_max_summary->{$expenseIndex}["subtotal"]) * -1;
  230.                             }
  231.                         } else {
  232.                             if (property_exists($report_data->claimData->discount_max_summary, $expenseIndex)) {
  233.                                 if (property_exists($report_data->claimData->discount_max_summary->$expenseIndex, "subtotal")) {
  234.                                     $report_data->claimData->discount_max_summary->$expenseIndex->subtotal = floatval($report_data->claimData->discount_max_summary->$expenseIndex->subtotal) * -1;
  235.                                 }
  236.                             }
  237.                         }
  238.                     }
  239.                     if (is_array($report_data->claimData->discount_max_summary)) {
  240.                         if (isset($report_data->claimData->discount_max_summary[$expenseIndex])
  241.                             && count($report_data->claimData->discount_max_summary[$expenseIndex]) > 0
  242.                             && property_exists($report_data->claimData->discount_max_summary[$expenseIndex], "net_subtotal")) {
  243.                             $report_data->claimData->discount_max_summary[$expenseIndex]->net_subtotal = floatval($report_data->claimData->discount_max_summary[$expenseIndex]->net_subtotal) * -1;
  244.                         }
  245.                     } else {
  247.                         if (is_array($report_data->claimData->discount_max_summary->$expenseIndex)) {
  249.                             if (count($report_data->claimData->discount_max_summary->$expenseIndex) > 0
  250.                                 && property_exists($report_data->claimData->discount_max_summary->$expenseIndex, "net_subtotal")) {
  251.                                 $report_data->claimData->discount_max_summary->$expenseIndex->net_subtotal = floatval($report_data->claimData->discount_max_summary->$expenseIndex->net_subtotal) * -1;
  252.                             }
  254.                         } else if (property_exists($report_data->claimData->discount_max_summary, $expenseIndex)) {
  256.                             if (property_exists($report_data->claimData->discount_max_summary->{$expenseIndex}, "net_subtotal")) {
  257.                                 $report_data->claimData->discount_max_summary->{$expenseIndex}->net_subtotal = floatval($report_data->claimData->discount_max_summary->{$expenseIndex}->net_subtotal) * -1;
  258.                             }
  259.                         }
  260.                     }
  261.                 }
  262.             }
  263.             foreach ($report_data->invoice_data as $expenseIndex => $getLineItem) {
  265.                 if (is_array($report_data->invoice_data)) {
  267.                     if (isset($report_data->invoice_data[$expenseIndex]) && property_exists($report_data->invoice_data[$expenseIndex], "subtotal")) {
  268.                         $report_data->invoice_data[$expenseIndex]->subtotal = (float)($report_data->invoice_data[$expenseIndex]->subtotal) * -1;
  269.                     }
  271.                     if (isset($report_data->invoice_data[$expenseIndex]) && property_exists($report_data->invoice_data[$expenseIndex], "net_subtotal")) {
  272.                         $report_data->invoice_data[$expenseIndex]->net_subtotal = (float)($report_data->invoice_data[$expenseIndex]->net_subtotal) * -1;
  273.                     }
  274.                 } else {
  276.                     if (property_exists($report_data->invoice_data->{$expenseIndex}, "subtotal")) {
  277.                         $report_data->invoice_data->{$expenseIndex}->subtotal = (float)($report_data->invoice_data->$expenseIndex->subtotal) * -1;
  278.                     }
  279.                     if (property_exists($report_data->invoice_data->{$expenseIndex}, "net_subtotal")) {
  280.                         $report_data->invoice_data->{$expenseIndex}->net_subtotal = (float)($report_data->invoice_data->$expenseIndex->net_subtotal) * -1;
  281.                     }
  282.                 }
  284.             }
  285.         }
  286.         return $report_data;
  287.     }
  291.     /**
  292.      * Show Datalist Page (Old DataBuilders style)
  293.      *
  294.      * @Route("/administration/resource/index")
  295.      */
  296.     public function showResources2Action()
  297.     {
  298.         return $this->render("ResourceManagementBundle:resources:show2.html.twig");
  299.     }
  302.     /**
  303.      * @Route("/administration/resource/check_negate_blob")
  304.      */
  305.     public function checkNegateBlob()
  306.     {
  307.         $em = $this->getDoctrine()->getManager();
  309.         $originalInvId = 202004;
  311.         $sql = "SELECT id, report_data, has_admin_fee_change 
  312.                 FROM commission_report 
  313.                 WHERE invoice_id = :invoice_id 
  314.                 AND invoice_type_id <> 4 ";
  316.         $stmt = $em->getConnection()->prepare($sql);
  317.         $stmt->execute([
  318.             "invoice_id" => $originalInvId
  319.         ]);
  320.         $CommissionReports = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  321.         if (count($CommissionReports) > 0) {
  322.             $CommReport = $CommissionReports[0];
  323.             $report_data = json_decode($CommReport['report_data']);
  325.             $sql = "SELECT id
  326.                     FROM invoice_cm  
  327.                     WHERE invoice_id = :invoice_id LIMIT 1 ";
  329.             $stmt = $em->getConnection()->prepare($sql);
  330.             $stmt->execute([
  331.                 "invoice_id" => $originalInvId
  332.             ]);
  333.             $InvoiceCMs = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  334.             if (count($InvoiceCMs) > 0) {
  336.                 $invoiceCMId = $InvoiceCMs[0]['id'];
  338.                 $report_data->claimData->dateCreated = date("Y-m-d H:i:s");
  339.                 $report_data->claimData->TypeCode = "CM";
  340.                 $report_data->claimData->inv_id = $invoiceCMId;
  341.                 $report_data->claimData->invoice_type_id = 4;
  343.                 $report_data->claimData->netTotal = -1 * floatval($report_data->claimData->netTotal);
  344.                 $report_data->claimData->subTotal = -1 * floatval($report_data->claimData->subTotal);
  345.                 $report_data->claimData->taxTotal = -1 * floatval($report_data->claimData->taxTotal);
  346.                 $report_data->claimData->te_total = -1 * floatval($report_data->claimData->te_total);
  347.                 $report_data->claimData->serviceExpense = -1 * floatval($report_data->claimData->serviceExpense);
  348.                 $report_data->claimData->disbursementTotal = -1 * floatval($report_data->claimData->disbursementTotal);
  349.                 if (property_exists($report_data, "invoice_resource_commission")) {
  350.                     foreach ($report_data->invoice_resource_commission as $index => $getCommission) {
  351.                         $report_data->invoice_resource_commission[$index]->amount = -1 * floatval($report_data->invoice_resource_commission[$index]->amount);
  352.                     }
  353.                 }
  354.                 if (property_exists($report_data->claimData, "discount_max_summary")) {
  355.                     foreach ($report_data->claimData->discount_max_summary as $expenseIndex => $getDiscount) {
  357.                         if (is_array($report_data->claimData->discount_max_summary)) {
  358.                             if (isset($report_data->claimData->discount_max_summary[$expenseIndex])
  359.                                 && count($report_data->claimData->discount_max_summary[$expenseIndex]) > 0
  360.                                 && property_exists($report_data->claimData->discount_max_summary[$expenseIndex], "subtotal")) {
  361.                                 $report_data->claimData->discount_max_summary[$expenseIndex]->subtotal = floatval($report_data->claimData->discount_max_summary[$expenseIndex]->subtotal) * -1;
  362.                             }
  363.                         } else {
  364.                             if (is_array(($report_data->claimData->discount_max_summary->$expenseIndex))) {
  365.                                 if (isset($report_data->claimData->discount_max_summary->$expenseIndex["subtotal"])) {
  366.                                     $report_data->claimData->discount_max_summary->{$expenseIndex}["subtotal"] = floatval($report_data->claimData->discount_max_summary->{$expenseIndex}["subtotal"]) * -1;
  367.                                 }
  368.                             } else {
  369.                                 if (property_exists($report_data->claimData->discount_max_summary, $expenseIndex)) {
  370.                                     if (property_exists($report_data->claimData->discount_max_summary->$expenseIndex, "subtotal")) {
  371.                                         $report_data->claimData->discount_max_summary->$expenseIndex->subtotal = floatval($report_data->claimData->discount_max_summary->$expenseIndex->subtotal) * -1;
  372.                                     }
  373.                                 }
  374.                             }
  375.                         }
  376.                         if (is_array($report_data->claimData->discount_max_summary)) {
  377.                             if (isset($report_data->claimData->discount_max_summary[$expenseIndex])
  378.                                 && count($report_data->claimData->discount_max_summary[$expenseIndex]) > 0
  379.                                 && property_exists($report_data->claimData->discount_max_summary[$expenseIndex], "net_subtotal")) {
  380.                                 $report_data->claimData->discount_max_summary[$expenseIndex]->net_subtotal = floatval($report_data->claimData->discount_max_summary[$expenseIndex]->net_subtotal) * -1;
  381.                             }
  382.                         } else {
  384.                             if (is_array($report_data->claimData->discount_max_summary->$expenseIndex)) {
  386.                                 if (count($report_data->claimData->discount_max_summary->$expenseIndex) > 0
  387.                                     && property_exists($report_data->claimData->discount_max_summary->$expenseIndex, "net_subtotal")) {
  388.                                     $report_data->claimData->discount_max_summary->$expenseIndex->net_subtotal = floatval($report_data->claimData->discount_max_summary->$expenseIndex->net_subtotal) * -1;
  389.                                 }
  391.                             } else if (property_exists($report_data->claimData->discount_max_summary, $expenseIndex)) {
  393.                                 if (property_exists($report_data->claimData->discount_max_summary->{$expenseIndex}, "net_subtotal")) {
  394.                                     $report_data->claimData->discount_max_summary->{$expenseIndex}->net_subtotal = floatval($report_data->claimData->discount_max_summary->{$expenseIndex}->net_subtotal) * -1;
  395.                                 }
  396.                             }
  397.                         }
  398.                     }
  399.                 }
  400.                 foreach ($report_data->invoice_data as $expenseIndex => $getLineItem) {
  402.                     if (is_array($report_data->invoice_data)) {
  404.                         if (isset($report_data->invoice_data[$expenseIndex]) && property_exists($report_data->invoice_data[$expenseIndex], "subtotal")) {
  405.                             $report_data->invoice_data[$expenseIndex]->subtotal = (float)($report_data->invoice_data[$expenseIndex]->subtotal) * -1;
  406.                         }
  408.                         if (isset($report_data->invoice_data[$expenseIndex]) && property_exists($report_data->invoice_data[$expenseIndex], "net_subtotal")) {
  409.                             $report_data->invoice_data[$expenseIndex]->net_subtotal = (float)($report_data->invoice_data[$expenseIndex]->net_subtotal) * -1;
  410.                         }
  411.                     } else {
  413.                         if (property_exists($report_data->invoice_data->{$expenseIndex}, "subtotal")) {
  414.                             $report_data->invoice_data->{$expenseIndex}->subtotal = (float)($report_data->invoice_data->$expenseIndex->subtotal) * -1;
  415.                         }
  416.                         if (property_exists($report_data->invoice_data->{$expenseIndex}, "net_subtotal")) {
  417.                             $report_data->invoice_data->{$expenseIndex}->net_subtotal = (float)($report_data->invoice_data->$expenseIndex->net_subtotal) * -1;
  418.                         }
  419.                     }
  421.                 }
  422.             }
  424.         }
  425.         return $report_data;
  427.         //dump("script completed"); die;
  429.     }
  431.     /**
  432.      * @Route("/administration/resource/edit/{id}", defaults={"id" = null})
  433.      */
  434.     public function editResourceAjaxAction(Request $request, Resource $resource)
  435.     {
  436.         # lets make sure user has access to this page (stronger than super admin rights)
  437.         $user = $this->get('security.token_storage')->getToken()->getUser();
  438.         $systemParamService = $this->get('core.system_parameter_control');
  439.         $access = $systemParamService->getAccessArray('access_resource');
  440.         $specialAccess = false;
  441.         if (in_array($user->getId(), $access)) {
  442.             $specialAccess = true;
  443.         }
  444.         $em = $this->container->get("doctrine.orm.entity_manager");
  445.         $wingSpanCollavoratorId = $resource->getWingSpanCollaboratorId();
  446.         if(empty($wingSpanCollavoratorId)) {
  447.             $wingSpanService = $this->container->get('resource.wingSpan');
  448.             $dataArray = array();
  449.             $dataArray['email'] = $resource->getEmail();
  450.             $dataArray['firstName'] = $resource->getFirstName();
  451.             $dataArray['lastName'] = $resource->getLastName();
  452.             $dataArray['memberCompany'] = 'CQ Digital';
  453.             $dataArray['memberId'] = (string)$resource->getId();
  454.             if (!empty($resource->getWingSpanCollaboratorGroupId())) {
  455.                // $response = $wingSpanService->CreateCollaborator($dataArray);
  456.                 // dd($response);
  457.                // $resource->setWingSpanCollaboratorId($response['collaboratorId']);
  458.                // $em->persist($resource);
  459.               //  $em->flush();
  460.                 // $wingSpanCollaboratorId = $response['collaboratorId'];
  461.                 //$wingSpanService->pushCollaboratorGroup($response['collaboratorId'], $resource->getWingSpanCollaboratorGroupId());
  462.             }
  463.         }
  464.         ini_set('display_errors', 1);
  465.         ini_set('display_startup_errors', 1);
  466.         error_reporting(E_ALL);
  467.         $i=0;
  468.         $envService = $this->container->get("core.get_environment");
  470.        
  472. //die;
  473.        // dd($responseDocIdsArray);
  474.         # Variable that turns off client side validation on entire action
  475.         $onlyServerSideVal = false;
  477.         # Clear Upload Image Session
  478.         $session = new Session();
  479.         $session->remove("resource_upload_image");
  481.         # Create Form Builder Object for "Edit Resource"
  482.         /** @var EntityManager $em */
  485.         $ClaimTeams = $em->getRepository("ClaimManagementBundle:ClaimTeam")->findBy(['enabled' => true], ['name' => 'ASC']);
  486.         $WingSpanGroups = $em->getRepository("CompanyManagementBundle:WingspanGroups")->findBy(['isActive' => 'Y'], ['wingspanGroup' => 'ASC']);
  488.         $alreadyNotUsedTeam = $this->getDoctrine()->getRepository('ResourceManagementBundle:TeamsNotUsed')->findBy(array('resourceId' => $resource->getId(),'isActive'=>'Y'));
  489.         $alreadyNotUsedTeamArray = array();
  490.         if(!empty($alreadyNotUsedTeam)) {
  491.             foreach ($alreadyNotUsedTeam as $alreadyNotUsedTeam) {
  492.                 $alreadyNotUsedTeamArray[$alreadyNotUsedTeam->getTeamId()] = $alreadyNotUsedTeam->getTeamId();
  494.             }
  495.         }
  496.         $mappedWingspanGroups = $this->getDoctrine()->getRepository('ResourceManagementBundle:ResourceWingspanGroupMap')->findBy(array('resourceId' => $resource->getId(),'isActive'=>'Y'));
  497.         $alreadyMappedWingspanArray = array();
  498.         if(!empty($mappedWingspanGroups)) {
  499.             foreach ($mappedWingspanGroups as $mappedWingspanGroups) {
  500.                 $alreadyMappedWingspanArray[$mappedWingspanGroups->getWingspanGroupId()] = $mappedWingspanGroups->getWingspanGroupId();
  502.             }
  503.         }
  504.       //  dd($alreadyMappedWingspanArray);
  505.         $niprTracking =  $resource->getNiprTracking();
  506.         if($niprTracking==1){
  507.             $niprNo =  $resource->getNiprNumber();
  508.             $agentSyncService = $this->container->get('resource.agentSync');
  509.             $accessTokenArray = $agentSyncService->getAccessToken();
  510.             if (!empty($accessTokenArray['access_token'])){
  511.                 //$agentSyncDataApi = $agentSyncService->createContactAgentSync($accessTokenArray,   $niprNo,$firstName,$LastName,$phone);
  512.                 $agentSyncContactDataApi = $agentSyncService->getAgentSyncNiprContactData($accessTokenArray,   $niprNo);
  514.                 if($agentSyncContactDataApi['totalSize']>0){
  515.                     $resource->setAgentSyncResponse($agentSyncContactDataApi['records'][0]['agentsync__AgentSync_Status__c']);
  516.                     if($agentSyncContactDataApi['records'][0]['agentsync__AgentSync_Status__c']=='nipr_error'){
  517.                         $is_nipr_tracking = 0;
  518.                         $resource->setNiprTracking($is_nipr_tracking);
  519.                     }
  521.                     $em->persist($resource);
  522.                     $em->flush();
  523.                 }else{
  525.                     $resource->setAgentSyncResponse('NpnNotFoundError');
  526.                     $em->persist($resource);
  527.                     $em->flush();
  529.                 }
  530.             }
  531.         }
  532.         $formFactory = $this->container->get("form.factory");
  533.         $kernel = $this->container->get("kernel");
  534.         $authChecker = $this->container->get("security.authorization_checker");
  535.         $form_helper = new ResourceFormHelper($em, $formFactory, $kernel, $onlyServerSideVal, $authChecker);
  536.         $resourceForm = $form_helper->getEditForm($resource);
  539.         # Variable that sets active tab
  540.         $active = 'resource';
  542.         $image_id = "";
  543.         $FileManager = $em->getRepository("ResourceManagementBundle:FileManager")->loadByFileIDEntity($resource->getId(), "ResourceSignature");
  544.         if ($FileManager) {  // if signature file exists for this Resource
  546.             # fill variable used to validate is signature file was ever uploaded
  547.             $image_id = $FileManager->getId();
  548.         }
  550.         $currentRole = "ROLE_REGISTERED";
  551.         if ($resource->getRoles()) {
  552.             $getRole = $resource->getRoles();
  553.             if (is_array($getRole) && count($getRole) > 0) {
  554.                 $currentRole = $getRole[0];
  555.             }
  556.         }
  558.         $Roles = [
  559.             "ROLE_SUPER_ADMIN",
  560.             "ROLE_ADMIN",
  561.             "ROLE_EXAMINER",
  562.             "ROLE_TEAM_LEADER",
  563.             "ROLE_ADJUSTER",
  564.             "ROLE_REGISTERED"
  565.         ];
  568.         // user stats for ICM
  569.         $isCarrier = $envService->getIsCarrier();
  571.         // check if resource has ever been deployed
  572.         $sql = "SELECT count(c.id) as claim_count
  573.                 FROM claim as c, assignments as cr, resource as r
  574.                 WHERE c.id = cr.claim_id
  575.                 AND cr.resource_id = r.id
  576.                 AND r.id = :resource_id
  577.                 AND c.loss_state_id != r.state_id
  578.                 AND IFNULL(cr.next_assignment_id,0) = 0
  579.                 AND IFNULL(cr.is_current_assignment,0) = 1";
  581.         $stmt = $em->getConnection()->prepare($sql);
  582.         $stmt->execute([
  583.             "resource_id" => $resource->getId()
  584.         ]);
  585.         $claim_count = $stmt->fetchAll( \PDO::FETCH_ASSOC );
  587.         if( $claim_count[0]['claim_count'] > 0 )
  588.             $hasBeenDeployed = true;
  589.         else
  590.             $hasBeenDeployed = false;
  592.         // count of all claims
  593.         // check if resource has ever been deployed
  594.         $sql = "SELECT COUNT(*) as claim_count
  595.                 FROM claim c, assignments cr
  596.                 WHERE c.id = cr.claim_id
  597.                 AND cr.resource_id = :resource_id
  598.                 AND IFNULL(cr.next_assignment_id,0) = 0
  599.                 AND IFNULL(cr.is_current_assignment,0) = 1";
  601.         $stmt = $em->getConnection()->prepare($sql);
  602.         $stmt->execute([
  603.             "resource_id" => $resource->getId()
  604.         ]);
  605.         $claim_count = $stmt->fetchAll( \PDO::FETCH_ASSOC );
  607.         $resourceClaimCount = $claim_count[0]['claim_count'];
  609.         $states = $em->getRepository("ResourceManagementBundle:State")->findBy([],['stateName'=>'ASC']);
  610.         $activeForLastYear = 'No';
  611.         $strCurrentDate = date('Y-m-d');
  612.         $strPreviouYearDate = date('Y-m-d', strtotime("-1 years"));
  614.         $dateLastAct = $resource->getLastActivityAt();
  615.         if (!empty($dateLastAct)) {
  616.             $strResourceLastActDate = $resource->getLastActivityAt()->format('Y-m-d');
  618.             if (($strResourceLastActDate >= $strPreviouYearDate) && ($strResourceLastActDate <= $strCurrentDate)){
  619.                $activeForLastYear = 'yes';
  620.             }else{
  621.                $activeForLastYear = 'no';
  622.             }
  623.         }
  624.         # get password change date
  625.         if(!empty($resource->getPasswordChangeDate())){
  626.             $passChangeDate=$resource->getPasswordChangeDate()->format('m/d/Y H:i:s');
  627.             $currentDate = date('Y-m-d H:i:s');
  628.             $passwordChangeDate=$resource->getPasswordChangeDate()->format('Y-m-d H:i:s');
  629.             $dayDiff = (strtotime($currentDate) - strtotime($passwordChangeDate)) / (60 * 60 * 24);
  630.         }else{
  631.             $passChangeDate='';
  632.             $dayDiff =0;
  633.         }
  634.         $agentSyncResponse = '';
  635.         $agentSyncResponse =$resource->getAgentSyncResponse();
  636.         #collect the Adjuster Comment
  637.         $sql = "SELECT ac.comment, ac.commentDate, CONCAT(r.first_name, ' ', r.last_name) AS author_name
  638.               FROM adjuster_comments ac
  639.               LEFT JOIN resource r
  640.               ON ac.logged_in_user_id = r.id
  641.               WHERE ac.resource_id = :rid
  642.               ORDER BY ac.commentDate desc LIMIT 3";
  644.         $AdjusterComments = array();
  645.         $dataParams['rid'] = $resource->getId();
  646.         $stmt = $em->getConnection()->prepare($sql);
  647.         //dd($stmt);
  648.         $stmt->execute($dataParams);
  649.         $AdjusterComments = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  650.         if (count($AdjusterComments) < 0) {
  651.             $AdjusterComments = array();
  652.         }
  653.        // dd($AdjusterComments);
  655.         return $this->render("ResourceManagementBundle:resources:edit.html.twig", [
  656.             "specialAccess" => $specialAccess,
  657.             "isTlg" => $resource->GetisTlg(),
  658.             "id" => $resource->getId(),
  659.             "resource" => $resource,
  660.             "useResource" => $resource,
  661.             "resourceForm" => $resourceForm->createView(),
  662.             "signature" => $resource->getSignature(),
  663.             "onlyServerSideVal" => $onlyServerSideVal,
  664.             "activeClass" => $active,
  665.             "image_id" => $image_id,
  666.             "Roles" => $Roles,
  667.             "CurrentRole" => $currentRole,
  668.             "isCarrier" => $isCarrier,
  669.             "hasBeenDeployed" => $hasBeenDeployed,
  670.             "resourceClaimCount" => $resourceClaimCount,
  671.             "States" => $states,
  672.             "activeForLastYear" => $activeForLastYear,
  673.             "passChangeDate" => $passChangeDate,
  674.             "dayDiff" => round($dayDiff),
  675.             "comments" => $AdjusterComments,
  676.             'agentSyncResponse' =>$agentSyncResponse,'ClaimTeams'=>$ClaimTeams,'alreadyNotUsedTeamArray'=>$alreadyNotUsedTeamArray,'WingSpanGroups'=>$WingSpanGroups,'alreadyMappedWingspanArray'=>$alreadyMappedWingspanArray
  677.         ]);
  678.     }
  680.     /**
  681.      * @Route("/administration/resource/make_tmp")
  682.      */
  683.     public function createTmpFolder()
  684.     {
  685.         $kernel = $this->container->get("kernel");
  687.         $file_path = $kernel->getRootDir() . "/../../tmp/licenses";
  688.         mkdir($file_path, 0775);
  690.         die("script completed");
  691.     }
  693.     /**
  694.      * method that checks if Resource has a signature
  695.      *
  696.      * @Route("/resource/has_signature_view/{id}")
  697.      */
  698.     public function hasSignatureImage(Resource $resource)
  699.     {
  700.         $retVal = true;
  701.         if ($resource == null) {
  702.             $retVal = false;
  703.         }
  705.         $file_manager = $this->container->get("app.file_manager");
  707.         $retVal = $file_manager->retrieveFilePathByEntity($resource->getId(), "ResourceSignature");
  708.         if (!$retVal) {
  709.             $retVal = false;
  710.         }
  712.         if ($retVal == true) {
  713.             $json = array(
  714.                 "error" => false,
  715.                 "data" => []
  716.             );
  717.             return new JsonResponse($json);
  718.         } else {
  719.             $json = array(
  720.                 "error" => true,
  721.                 "data" => [],
  722.                 "messages" => ["This resource does not have a signature"]
  723.             );
  724.             return new JsonResponse($json);
  725.         }
  726.     }
  730.     /**
  731.      * Fetch the blob by invoice id
  732.      *
  733.      * @Route("/administration/resource/get_blob/item/{invoiceId}")
  734.      */
  735.     public function getBlob($invoiceId)
  736.     {
  737.         $em = $this->container->get("doctrine.orm.entity_manager");
  739.         # Push Shreya's Changes
  741.         $sql = "SELECT * FROM commission_report WHERE invoice_id = :invoice_id ";
  742.         $dataParams['invoice_id'] = $invoiceId;
  743.         $stmt = $em->getConnection()->prepare($sql);
  744.         $stmt->execute($dataParams);
  745.         $resultset = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  746.         foreach ($resultset as $getItem) {
  747.             dump($getItem['report_data']);
  748.         }
  749.         die;
  750.         return new JsonResponse(array());
  752.     }
  754.     /**
  755.      * @Route("/administration/resource/signature_view/{id}/{randomNum}")
  756.      */
  757.     public function displaySignatureImage(Resource $resource, $randomNum)
  758.     {
  759.         if ($resource === null) {
  760.             throw new NotFoundHttpException('Could not find this Resource!');
  761.         }
  763.         $file_manager = $this->container->get("app.file_manager");
  764.         $retVal = $file_manager->retrieveFilePathByEntity($resource->getId(), "ResourceSignature", 1);
  765.         //return new NonCachableBinaryFileResponse($retVal);
  766.         if(isset($retVal) && !empty($retVal))
  767.             return new Response($retVal[0], $retVal[1], $retVal[2]);
  768.         else
  769.             return new Response(1);
  770.     }
  772.     /**
  773.      * @Route("/administration/resource/profile_view/{id}", defaults={"id"=null})
  774.      */
  775.     public function displayProfileImage(Resource $resource)
  776.     {
  777.         if ($resource === null) {
  778.             throw new NotFoundHttpException('Could not find this Resource!');
  779.         }
  781.         $file_manager = $this->container->get("app.file_manager");
  782.         $file = $file_manager->retrieveFilePathByEntity($resource->getId(), "ProfilePicture", 1);
  783.         if($file){
  784.             //return new NonCachableBinaryFileResponse($file);
  785.             return new Response($file);
  786.         }else{
  787.             return "";
  788.         }
  789.     }
  790.     /**
  791.      * @Route("/administration/resource/add")
  792.      */
  793.     public function addResourceAjaxAction(Request $request)
  794.     {
  795. //        $this->denyAccessUnlessGranted('add');
  797.         # lets make sure user has access to this page (stronger than super admin rights)
  798.         $user = $this->get('security.token_storage')->getToken()->getUser();
  799.         $systemParamService = $this->get('core.system_parameter_control');
  800.         $access = $systemParamService->getAccessArray('access_resource');
  802.         $specialAccess = false;
  803.         if (in_array($user->getId(), $access)) {
  804.             $specialAccess = true;
  805.         }
  807.         # Variable that turns off client side validation on entire action
  808.         $onlyServerSideVal = true;
  810.         # Create Form Builder Object for "Add Resource"
  811.         $em = $this->container->get("doctrine.orm.entity_manager");
  813.         $resource = new Resource();
  814.         $resourceForm = $this->createForm(ResourceType::class, $resource, [
  815.             'isCarrier' => $this->get('core.get_environment')->getIsCarrier()
  816.         ]);
  818.         # Clear Upload Image Session
  819.         $session = new Session();
  820.         $session->remove("resource_upload_image");
  822.         $Roles = [
  823.             "ROLE_SUPER_ADMIN",
  824.             "ROLE_ADMIN",
  825.             "ROLE_EXAMINER",
  826.             "ROLE_TEAM_LEADER",
  827.             "ROLE_ADJUSTER",
  828.             "ROLE_REGISTERED"
  829.         ];
  831.         $states = $em->getRepository("ResourceManagementBundle:State")->findBy([],['stateName'=>'ASC']);
  833.         return $this->render("ResourceManagementBundle:resources:addnew.html.twig", [
  834.             "specialAccess" => $specialAccess,
  835.             "resourceForm" => $resourceForm->createView(),
  836.             "onlyServerSideVal" => $onlyServerSideVal,
  837.             "Roles" => $Roles,
  838.             "resource" => $user,
  839.             "States" => $states
  840.         ]);
  841.     }
  843.     /**
  844.      * Save Add Resource Action
  845.      *
  846.      * @Route("/administration/resource/save_add")
  847.      */
  848.     public function saveAddResourceAjaxAction(Request $request)
  849.     {
  850.         $this->denyAccessUnlessGranted('add');
  852.         $dispatch = $this->get('event_dispatcher');
  854.         # use "Add Resource" Form Object to get submitted form object
  855.         $em = $this->container->get("doctrine.orm.entity_manager");
  856.         $envService = $this->container->get("core.get_environment");
  858.         $resource = new Resource();
  859.         $resourceForm = $this->createForm(ResourceType::class, $resource, [
  860.             'isCarrier' => $this->get('core.get_environment')->getIsCarrier()
  861.         ]);
  863.         $submittedForm = $request->request->get("resource");
  864.         $roles = $request->request->get("roles");
  866.        $ssn_ein = isset($submittedForm['ssn_ein']) ? $submittedForm['ssn_ein'] : "";
  867.        if(!empty($ssn_ein)){
  868.            $ssn_ein1 = str_replace(' ', '', $ssn_ein);
  869.            $ssn_ein1 = str_replace('-', '', $ssn_ein1);
  870.        }else{
  871.            $ssn_ein1 = '';
  872.        }
  875.         $form_supervisor = isset($submittedForm['supervisor']) ? $submittedForm['supervisor'] : "";
  876.         $form_npn_number = isset($submittedForm['niprNumber']) ? trim($submittedForm['niprNumber']) : "";
  877.         $is_nipr_tracking = ($request->get('is_nipr_tracking') == 'Yes') ? 1 : 0;
  878.         # isW2 isHourly conditions
  879.         if(isset($submittedForm['isW2'])){
  880.             $formIsW2 = $submittedForm['isW2'];
  881.             if($formIsW2 == 1) {
  882.                 $formIsW2 = true;
  883.                 $formIsHourly = false;
  884.             }
  885.             elseif ($formIsW2 == -1) {
  886.                 $formIsW2 = true;
  887.                 $formIsHourly = true;
  888.             }
  889.             elseif ($formIsW2 == 0) {
  890.                 $formIsW2 = false;
  891.                 $formIsHourly = false;
  892.             }
  893.             $resource->setIsW2($formIsW2);
  894.             $resource->setIsHourly($formIsHourly);
  895.         }
  897.         # Set Supervisor
  898.         $Supervisor = $em->getRepository("ResourceManagementBundle:Resource")->find($form_supervisor);
  899.         $resource->setSupervisor($Supervisor);
  901.         # Set NPN Number
  902.         if(!empty($form_npn_number)) {
  903.             $resource->setNiprNumber($form_npn_number);
  904.         }
  906.         # Manually submit form
  907.         $resourceForm->submit(
  908.             $submittedForm
  909.         );
  911.         $userNoteLog = $this->container->get("app.resource_note_logger");
  912.         $user = $this->container->get("security.token_storage")->getToken()->getUser();
  913.         if ($resource->getResourceType() instanceof \Globals\ResourceManagementBundle\Entity\ResourceType) {
  914.             $resourceTypeText = $resource->getResourceType()->getResourceType();
  915.         } else {
  916.             /**
  917.              * Resource Type id 2 should be field adjuster
  918.              * better to search by int rather than string.
  919.              */
  920.             $resourceType = $em->getRepository("ResourceManagementBundle:ResourceType")->find(2);
  921.             $resourceTypeText = $resourceType->getResourceType();
  922.             $resource->setResourceType($resourceType);
  923.         }
  924.         if ($resource->getId() == $user->getId()) {
  925.             $comment = $resource->getFullName() . " added the Resource Type $resourceTypeText.";
  926.         } else {
  927.             $comment = "The Resource Type $resourceTypeText was added to the user " . $resource->getFullName() . ", by " . $user->getFullName() . ".";
  928.         }
  930.         # added 11/2018
  931.         # This will add the address information (validation will only occur if NON carrier)
  932.         $addr_form = $request->request->get('addr_form');
  934.         if(!$addr_form['phone'] && !$envService->getIsCarrier())
  935.         {
  936.             $response = [];
  937.             $response['error'] = true;
  938.             $response['data']['errors'][] = [
  939.                 'id' => "form_phone",
  940.                 'text' => "This field needs a value, it cannot be blank!"
  941.             ];
  943.             return new JsonResponse($response);
  944.         }
  946.         if(!$addr_form['city'] && !$envService->getIsCarrier())
  947.         {
  948.             $response = [];
  949.             $response['error'] = true;
  950.             $response['data']['errors'][] = [
  951.                 'id' => "form_city",
  952.                 'text' => "This field needs a value, it cannot be blank!"
  953.             ];
  955.             return new JsonResponse($response);
  957.         }
  959.         if(!$addr_form['state'] && !$envService->getIsCarrier())
  960.         {
  961.             $response = [];
  962.             $response['error'] = true;
  963.             $response['data']['errors'][] = [
  964.                 'id' => "form_state",
  965.                 'text' => "This field needs a value, it cannot be blank!"
  966.             ];
  968.             return new JsonResponse($response);
  969.         }
  971.         if(!$addr_form['zip'] && !$envService->getIsCarrier())
  972.         {
  973.             $response = [];
  974.             $response['error'] = true;
  975.             $response['data']['errors'][] = [
  976.                 'id' => "form_zip",
  977.                 'text' => "This field needs a value, it cannot be blank!"
  978.             ];
  980.             return new JsonResponse($response);
  981.         }
  983.         if(!$addr_form['address'] && !$envService->getIsCarrier())
  984.         {
  985.             $response = [];
  986.             $response['error'] = true;
  987.             $response['data']['errors'][] = [
  988.                 'id' => "form_address",
  989.                 'text' => "This field needs a value, it cannot be blank!"
  990.             ];
  992.             return new JsonResponse($response);
  993.         }
  995.         if ($resourceForm->isValid()) {
  997.             # Validate Password not blank
  998.             if ($resource->getPassword() == "") {
  1000.                 $response = [];
  1001.                 $response['error'] = true;
  1002.                 $response['data']['errors'][] = [
  1003.                     'id' => "resource_password",
  1004.                     'text' => "Please enter a password."
  1005.                 ];
  1007.                 return new JsonResponse($response);
  1008.             }
  1010.             # Validate for duplicate email
  1011.             $HasEmail = $em->getRepository("ResourceManagementBundle:Resource")->findBy(array("email" => $resource->getEmail()));
  1012.             if ($HasEmail) {  // if duplicate
  1014.                 $response = [];
  1015.                 $response['error'] = true;
  1016.                 $response['data']['errors'][] = [
  1017.                     'id' => "resource_email",
  1018.                     'text' => "This email already exists with a different account."
  1019.                 ];
  1021.                 return new JsonResponse($response);
  1022.             }
  1024.             # Validate for duplicate username
  1025.             $HasUser = $em->getRepository("ResourceManagementBundle:Resource")->findBy(array("username" => $resource->getUsername()));
  1026.             if ($HasUser) {  // if duplicate
  1028.                 $response = [];
  1029.                 $response['error'] = true;
  1030.                 $response['data']['errors'][] = [
  1031.                     'id' => "resource_username",
  1032.                     'text' => "This username already exists with a different account."
  1033.                 ];
  1035.                 return new JsonResponse($response);
  1036.             }
  1038.             if ($resource->getPassword() != "") {  // if set password
  1039.                 # encrypt password with md5
  1040.                 $resource->setPassword(md5($resource->getPassword()));
  1041.             } else {
  1043.                 $response = [];
  1044.                 $response['error'] = true;
  1045.                 $response['data']['errors'][] = [
  1046.                     'id' => "resource_password",
  1047.                     'text' => "Please enter a password."
  1048.                 ];
  1050.                 return new JsonResponse($response);
  1051.             }
  1053.             if (!$envService->getIsCarrier()) {
  1054.                 if ($resource->getSsnEin()) {
  1055.                     $resource->setSsnEin(md5($resource->getSsnEin()));
  1056.                 } else {
  1057.                     $response = [];
  1058.                     $response['error'] = true;
  1059.                     $response['data']['errors'][] = [
  1060.                         'id' => "resource_ssn_ein",
  1061.                         'text' => "This field is required."
  1062.                     ];
  1064.                     return new JsonResponse($response);
  1065.                 }
  1066.             }
  1068.             # CUSTOM ADDRESS SAVING
  1069.             $resource->setCity("");
  1070.             if ($addr_form['city']) {
  1071.                 $resource->setCity($addr_form['city']);
  1072.             }
  1073.             $State = $em->getRepository("ResourceManagementBundle:State")->find(1);
  1074.             $resource->setState($State);
  1075.             if (intval($addr_form['state']) > 0) {
  1076.                 $State = $em->getRepository("ResourceManagementBundle:State")->find(intval($addr_form['state']));
  1077.                 $resource->setState($State);
  1078.             }
  1079.             $resource->setAddress("");
  1080.             if ($addr_form['address']) {
  1081.                 $resource->setAddress($addr_form['address']);
  1082.             }
  1083.             $resource->setZip("");
  1084.             if ($addr_form['zip']) {
  1085.                 $resource->setZip($addr_form['zip']);
  1086.             }
  1087.             $resource->setPhone("");
  1088.             if ($addr_form['phone']) {
  1089.                 $resource->setPhone($addr_form['phone']);
  1090.             }
  1092.             if ($roles === "0") {
  1093.                 $roles  = "ROLE_ADJUSTER";
  1094.                 $resource->setRoles('["ROLE_ADJUSTER"]');
  1095.             } else {
  1096.                 $resource->setRoles("[" . '"' . $roles . '"' . "]");
  1097.             }
  1098.             // For updating payroll id while creating new adjuster start
  1099.             if($roles=='ROLE_ADJUSTER' || $roles=='ROLE_REGISTERED'){
  1100.                 $payrollService = $this->get('resource.payroll_service');
  1102.                     $length = 4;
  1103.                     $payrollId = $payrollService->randomStr($length);
  1104.                     $resourceWithPayroll = $this->getDoctrine()->getRepository('ResourceManagementBundle:Resource')->findBy(array('payrollId' => $payrollId));
  1105.                     if (!empty($resourceWithPayroll)) {
  1106.                         $payrollId = $payrollService->randomStr($length);
  1107.                     }
  1109.                 $resource->setPayrollId($payrollId);
  1110.             }
  1111.             // For updating payroll id while creating new adjuster end
  1112.             $em->flush();
  1114.             # Persist to DB using Resource Profile Service method - saveAddResource()
  1115.             $resource_profile = $this->container->get("app.resource_profile");
  1116.             $resource_profile->saveAddResource($resource);
  1118.             $resource->setPasswordChangeDate(new \DateTime());
  1120.             $resource->setNiprTracking($is_nipr_tracking);
  1121.             # Persist once more
  1122.             $em->persist($resource);
  1124.             # Flush it all down
  1125.             try {
  1126.                 $em->flush();
  1127.             } catch (\Exception $e) {
  1128.             }
  1129.             // to log the resource type changes
  1130.             $userNoteLog->logNote($comment, $resource);
  1132.             $dispatcher = $this->get('event_dispatcher');
  1133.             $dispatcher->dispatch(new ResourceCreatedEvent($resource), ResourceCreatedEvent::RENAME );
  1134.             $firstName = $resource->getFirstName();
  1135.             $LastName = $resource->getLastName();
  1136.             $niprNo =  $resource->getNiprNumber();
  1137.             $phone =  $resource->getPhone();
  1140.             $wingSpanService = $this->container->get('resource.wingSpan');
  1141.             $dataArray = array();
  1142.             $dataArray['email'] = $resource->getEmail();
  1143.             $dataArray['firstName'] = $resource->getFirstName();
  1144.             $dataArray['lastName'] =  $resource->getLastName();;
  1145.             $dataArray['memberCompany'] =  'CQ Digital';
  1146.             $dataArray['memberId'] = $resource->getId();
  1147.             if (!empty($resource->getWingSpanCollaboratorGroupId())) {
  1148.                 //$response = $wingSpanService->CreateCollaborator($dataArray);
  1150.                // $resource->setWingSpanCollaboratorId($response['collaboratorId']);
  1151.                // $wingSpanService->pushCollaboratorGroup($response['collaboratorId'], $resource->getWingSpanCollaboratorGroupId());
  1152.             }
  1153.             $ssn_ein =  $ssn_ein1;
  1154.             $niprTracking =  $resource->getNiprTracking();
  1155.             if($niprTracking==1){
  1156.                 $agentSyncService = $this->container->get('resource.agentSync');
  1157.                 $accessTokenArray = $agentSyncService->getAccessToken();
  1158.                 if (!empty($accessTokenArray['access_token'])){
  1160.                     $agentSyncContactDataApi = $agentSyncService->getAgentSyncNiprContactData($accessTokenArray,   $niprNo,$firstName,$LastName);
  1162.                     if($agentSyncContactDataApi['totalSize']>0){
  1164.                     }else{
  1165.                         $agentSyncService->createContactAgentSync($accessTokenArray,   $niprNo,$firstName,$LastName,$phone,$ssn_ein,$resource->getId());
  1167.                     }
  1169.                 }
  1170.             }
  1171.             # Return success JSON
  1172.             $retVal = array(
  1173.                 "result" => "success",
  1174.                 "error_msgs" => [],
  1175.                 "roles" => $resource->getRoles(),
  1176.                 "resource_id" => $resource->getId(),
  1177.             );
  1178.             $session = new Session();
  1179.             $session->remove("resource_upload_image");
  1180.             return new JsonResponse($retVal);
  1181.         } else {
  1182.             $response = [];
  1183.             $response['error'] = true;
  1184.             $response['formError'] = (string)$resourceForm->getErrors(true);
  1185.             foreach($resourceForm as $formField){
  1186.                 $errorString = (string)$formField->getErrors();
  1187.                 if($errorString != ""){
  1188.                     $response['data']['errors'][] = [
  1189.                         'id' => $resourceForm->getName()."_".$formField->getName(),
  1190.                         'text' => $errorString
  1191.                     ];
  1192.                 }
  1193.             }
  1194.             return new JsonResponse($response);
  1195.         }
  1196.     }
  1198.     /**
  1199.      * @Route("/administration/fix/claim_report_duplicates")
  1200.      */
  1201.     public function deleteDupClaimReport() {
  1203.         $em = $this->getDoctrine();
  1205.         $sql = "SELECT * FROM claim_report cr 
  1206.                 WHERE claim_id = :claim_id 
  1207.                 AND invoice_id = :invoice_id 
  1208.                 AND document_type_id = :document_type_id AND cr.file_title = :file_title 
  1209.                 AND document_type_id = 9
  1210.                 AND invoice_id <> 0 ";
  1211.         $stmt_select_like_reports = $em->getConnection()->prepare($sql);
  1213.         $sql = "SELECT cr.* 
  1214.                 FROM claim_report cr 
  1215.                 INNER JOIN claim_report cr2 
  1216.                   ON cr.claim_id = cr2.claim_id
  1217.                 AND cr.invoice_id = cr.invoice_id
  1218.                 AND cr.document_type_id = cr2.document_type_id
  1219.                 AND cr.file_title = cr2.file_title 
  1220.                   AND cr.id != cr2.id
  1221.                 WHERE cr.document_type_id = 9
  1222.                   AND cr.invoice_id != 0
  1223.                 ORDER BY cr.invoice_id ";
  1224.         $stmt = $em->getConnection()->prepare($sql);
  1225.         $stmt->execute();
  1226.         $results = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  1227.         foreach ($results as $getEach) {
  1229.             $sql = "SELECT id, claim FROM claim_report cr 
  1230.                 WHERE claim_id = :claim_id 
  1231.                 AND invoice_id = :invoice_id 
  1232.                 AND document_type_id = :document_type_id AND cr.file_title = :file_title 
  1233.                 AND document_type_id = 9
  1234.                 AND invoice_id <> 0 ";
  1235.             $stmt_select_like_reports->execute([
  1236.                 "claim_id" => $getEach['claim_id'],
  1237.                 "invoice_id" => $getEach['invoice_id'],
  1238.                 "document_type_id" => $getEach['document_type_id'],
  1239.                 "file_title" => $getEach['file_title']
  1240.             ]);
  1241.             $i = 0;
  1242.             $LikeResults = $stmt_select_like_reports->fetchAll(\PDO::FETCH_ASSOC);
  1243.             foreach ($LikeResults as $getLike) {
  1245.                 if ($i < count($LikeResults) - 1) {
  1246.                     // delete
  1247.                     /*/
  1248.                     DELETE FROM claim_report where id = :id
  1249.                     $getLike['id']
  1250.                     //*/
  1251.                 }
  1252.                 $i++;
  1253.             }
  1254.         }
  1255.         dump("Script completed"); die;
  1256.     }
  1259.     /**
  1260.      * @Route("/datatables/save/numperpage", methods={"POST"})
  1261.      */
  1262.     public function saveNumberPerPage(Request $request)
  1263.     {
  1264.         $numPerPage = $request->request->has("num_per_page") ? $request->request->get("num_per_page") : 10;
  1266.         $session = new Session();
  1267.         $session->set("NumPerPage", $numPerPage);
  1269.         /*$user = $this->container->get("security.token_storage")->getToken()->getUser();
  1270.         if (!is_scalar($user)) {
  1272.             $user->setNumPerPage($numPerPage);
  1273.         }*/
  1275.         return new JsonResponse([
  1276.            "error" => false
  1277.         ]);
  1278.     }
  1280.     /**
  1281.      * Save Update Resource Action
  1282.      *
  1283.      * @Route("/administration/resource/sendwingspanlink/{id}")
  1284.      */
  1285.     public function sendwingspanlink(Request $request, Resource $resource)
  1286.     {
  1287.         $em = $this->container->get("doctrine.orm.entity_manager");
  1288.         $tokenStorage = $this->container->get('security.token_storage');
  1289.         $user = $tokenStorage->getToken()->getUser();
  1290.         $mailer = $this->container->get('mail_management.mailer');
  1291.         $email_from = $user->getEmail();
  1292.         //$mailer->replaceParam = array('strImagePath' => "", 'imageUrl' => "");
  1293.         $mailer->setSendingConfig();
  1295.         $wingspanlinkObj = $em->getRepository('CoreBundle:SystemControlMetadata')->findOneBy(['cmetaKey' => 'wing_span_link']);
  1297.         $email_body = "<p><strong>Hello ".$resource->getFirstName()." ".$resource->getLastName().",</strong></p>";
  1298.         $email_body .="<p></p><p>The second step in onboarding with Davies is for you to create a profile in the Wingspan system. Once complete, you will be able to log in and sign our 1099 contract.</p>";
  1299.         $email_body .= "<p>Please click below link for registration on wingspan</p>";
  1300.         $email_body .= "<p><a href='".$wingspanlinkObj->getCmetaValue()."'>Register</a></p>";
  1301.         $email_body .= "<p></p><p>You can reach out to recruiting if you have any questions.</p>";
  1307.             $email_body .= "<br/> Thanks </br/> The Recruiting Department ";
  1308.             $Mail = new Mail();
  1310.                 # SETTING THE SUBJECT
  1311.                 # ######################################################
  1312.                 $email_to = $resource->getEmail();
  1313.                 # Recipient
  1314.                 $Recipient = new MailRecipient();
  1315.                 $Recipient->setEmail($email_to);
  1316.                 $Recipient->setMail($Mail);
  1317.                 $Recipient->setRecipientId($user->getId());
  1318.                 $entityName = $em->getMetadataFactory()->getMetadataFor(get_class($user))->getName();
  1319.                 $Recipient->setRecipientType($entityName);
  1320.                 # Adds the single recipient (resource);
  1321.                 $Mail->addRecipient($Recipient);
  1322.                 $Mail->setSubject("Wing Span Registration - Notification");
  1325.             # Finalize the MAIL object
  1326.             $Mail->setBody($email_body);
  1327.             $Mail->setSenderName(MailHelper::getMailSenderName($tokenStorage));
  1328.             $mailer->sendEmail($Mail, $email_from, "");
  1329.         # Return JSON with Error Messages
  1330.         $retVal = array(
  1331.             "result" => "success",
  1332.             "error_msgs" => 'send',
  1333.             "error" => false
  1335.         );
  1336.         return new JsonResponse($retVal);
  1337.     }
  1338.     /**
  1339.      * Save Update Resource Action
  1340.      *
  1341.      * @Route("/administration/resource/save_edit/{id}")
  1342.      */
  1343.     public function saveEditResourceAjaxAction(Request $request, Resource $resource)
  1344.     {
  1345.         $this->denyAccessUnlessGranted('edit', $resource);
  1347.         # "Edit Resource" Form Object, get submitted form object
  1348.         $em = $this->container->get("doctrine.orm.entity_manager");
  1349.         $formFactory = $this->container->get("form.factory");
  1350.         $AddressInfo='';
  1351.         $OldAddressInfo='';
  1352.         $workType='';
  1353.         $oldworkType='';
  1354.         $session = new Session();
  1355.         $session->remove("ResourceChanged");
  1356.         $session->remove("ResourceChanges");
  1358.         $envService = $this->container->get("core.get_environment");
  1360.         $kernel = $this->container->get("kernel");
  1361.         $authChecker = $this->container->get("security.authorization_checker");
  1362.         $onlyServerSideVal = false;
  1363.         $form_helper = new ResourceFormHelper($em, $formFactory, $kernel, $onlyServerSideVal, $authChecker);
  1364.         $oldSsnEin = $resource->getSsnEin();
  1366.         $form = $request->request->get("form");
  1369.        // if(!empty($wingSpanCollaboratorId)){
  1370.            // $wingSpanService = $this->container->get('resource.wingSpan');
  1371.             //$responseDocIdsArray = $wingSpanService->fetchCollaboratorDocumentIDs($wingSpanCollavoratorId);
  1372.            
  1373.             //foreach($responseDocIdsArray as $keyDocId=>$valueDocId){
  1374.                /// $clientIdData =  $wingSpanService->fetchDocumentDetails($valueDocId);
  1375.                // $fieldId = $clientIdData['client'];
  1376.                // $title = $clientIdData['docName'];
  1377.                // $filecontent =  $wingSpanService->downloadFile($fieldId);
  1379.                // $kernel = $this->container->get("kernel");
  1380.                // $env = $kernel->getEnvironment();
  1381.                // $env = str_replace("_dev", "", $env);
  1382.                // $env = 1000;
  1383.                // $new_file_path = $kernel->getRootDir() . "/../web/" . $env . "/wingSpanData/".$resource->getId();
  1384.                // if (!file_exists($new_file_path)) {
  1386.                //     mkdir($new_file_path, 0775);
  1387.               //  }else{
  1389.               //  }
  1391. // Then just save it like this
  1392.               //  file_put_contents( $new_file_path.'/'.$title, $filecontent );
  1393.           //  }
  1394.        // }
  1395.         //$wingSpanService = $this->container->get('resource.wingSpan');
  1396.         // $dataArray = array();
  1397.         //$response =  $wingSpanService->CreateCollaborator($dataArray);
  1399.         $employement_form = $request->request->get("employment_form");
  1400.         $form_ssn_ein = isset($form['ssn_ein']) ? $form['ssn_ein'] : "";
  1402.         $xactAddress = ($request->request->has("xactAddress")) ? $request->request->get("xactAddress") : "";
  1403.         $symbilityAddress = ($request->request->has("symbilityAddress")) ? $request->request->get("symbilityAddress") : "";
  1406.         $form_supervisor = isset($form['supervisor']) ? $form['supervisor'] : "";
  1407.         $enabled = isset($form['isActive']) ? $form['isActive'] : "";
  1408.         $oldSupervisor = $resource->getSupervisor();
  1409.         if(!empty($form['resource_type']))
  1410.             $resourceType = $em->getRepository("ResourceManagementBundle:ResourceType")->find($form['resource_type']);
  1412.         /**
  1413.          * When disabling a vendor we need to remove all of their percentages so they dont get claims
  1414.          */
  1415.         if ($enabled == 0 && $resource->getResourceType() && $resource->getResourceType()->getId() == 3) {
  1416.             # only use resource service here so just call the function directly
  1417.             $this->container->get("resource.service")->removeVendorPercentages($resource);
  1418.         }
  1420.         if(isset($form['supervisor'])){
  1421.             $newSupervisor = $em->getRepository("ResourceManagementBundle:Resource")->find($form['supervisor']);
  1422.         }else{
  1423.             $newSupervisor = "";
  1424.         }
  1427.         $didSupervisorChange = false;
  1428.         if($oldSupervisor != $newSupervisor && ($oldSupervisor=="" || $newSupervisor=="")){
  1429.             $didSupervisorChange = true;
  1430.         }
  1432.         # isW2 isHourly conditions
  1433.         if(isset($employement_form['isW2'])){
  1434.             $formIsW2 = $employement_form['isW2'];
  1435.             if($formIsW2 == 1) {
  1436.                 $formIsW2 = true;
  1437.                 $formIsHourly = false;
  1438.             }
  1439.             elseif ($formIsW2 == -1) {
  1440.                 $formIsW2 = true;
  1441.                 $formIsHourly = true;
  1442.             }
  1443.             elseif ($formIsW2 == 0) {
  1444.                 $formIsW2 = false;
  1445.                 $formIsHourly = false;
  1446.             }
  1447.             ##
  1448.             $DbIsW2=intval($resource->getIsW2());
  1449.             $DbIsHourly=intval($resource->getIsHourly());
  1450.             $DbRadioValue=0;
  1451.             if($DbIsW2===1 && $DbIsHourly===0){ $DbRadioValue=1;}
  1452.             if($DbIsW2===1 && $DbIsHourly===1){ $DbRadioValue= -1;}
  1453.             if($DbIsW2===0 && $DbIsHourly===0){ $DbRadioValue=0;}
  1455.             if($DbRadioValue !==intval($employement_form['isW2']) ){
  1456.                 $oldworkType= ($DbRadioValue == 1) ? "Salary" : (($DbRadioValue == -1)  ? "Hourly" : "1099");
  1457.                 $workType = (intval($employement_form['isW2']) == 1) ? "Salary" : ((intval($employement_form['isW2']) == -1)  ? "Hourly" : "1099");
  1458.             }
  1459.             ##
  1460.             $resource->setIsW2($formIsW2);
  1461.             $resource->setIsHourly($formIsHourly);
  1462.             if ($xactAddress) {
  1463.                 $resource->setXactAddress($xactAddress);
  1464.             }
  1465.             if ($symbilityAddress) {
  1466.                 $resource->setSymbilityAddress($symbilityAddress);
  1467.             }
  1468.         }
  1471.         # Request security role
  1472.         $role = $request->request->get("role");
  1474.         $resourceForm = $form_helper->getEditForm($resource);
  1476.         # this function must be called before $resourceForm->getData()
  1477.         $password = $request->request->get("changepass");
  1479.         # Get Days Available Info from Request
  1480.         $weekDays = array();
  1482.         # Get Submitted Form Resource Object
  1483.         $resourceForm->handleRequest($request);
  1486.         $resource = $resourceForm->getData();
  1488.         # Check if new Ssn EIn was entered
  1489.         if ($form_ssn_ein) {  // if yes
  1490.             # md5 the value
  1491.             $resource->setSsnEin(md5($form_ssn_ein));
  1492.         } else {  // if not
  1494.         }
  1496.         // save auth code
  1497.         $sms_authetication = $request->request->get('sms_authetication');
  1498.         if ($sms_authetication) {
  1499.             $resource->setSmsAuthetication($sms_authetication);
  1500.         }
  1502.         // save SMS ADJUSTER ACCEPT code
  1503.         $sms_accept_message = $request->request->get('sms_accept_message');
  1504.         if ($sms_accept_message) {
  1505.             $resource->setSmsAcceptMessage($sms_accept_message);
  1506.         }else{
  1507.             $resource->setSmsAcceptMessage(0);
  1508.         }
  1509.         $alreadyNotUsedTeam = $this->getDoctrine()->getRepository('ResourceManagementBundle:TeamsNotUsed')->findBy(array('resourceId' => $resource->getId()));
  1510.         if(!empty($alreadyNotUsedTeam)){
  1511.             foreach($alreadyNotUsedTeam as $alreadyNotUsedTeam){
  1512.                 $alreadyNotUsedTeam->setIsActive('N');
  1513.                 $em->persist($alreadyNotUsedTeam);
  1514.             }
  1516.         }
  1517.         $team_not_used = $request->request->get('team_not_used');
  1518.         if(!empty($team_not_used)){
  1520.             foreach($team_not_used as $key=>$value){
  1521.                 $teamNotUsed = new TeamsNotUsed();
  1522.                 $teamNotUsed->setResourceId($resource->getId());
  1523.                 $teamNotUsed->setTeamId($value);
  1524.                 $teamNotUsed->setIsActive('Y');
  1525.                 $teamNotUsed->setCreatedDate(new \DateTime());
  1526.                 $teamNotUsed->setUpdatedDate(new \DateTime());
  1529.                 $em->persist($teamNotUsed);
  1530.             }
  1531.         }
  1532.         # added 11/2018
  1533.         # This will add the address information (validation will only occur if NON carrier)
  1535.         # for saving wingspan groups starts
  1536.        // $alreadymappedWingspanGroups = $this->getDoctrine()->getRepository('ResourceManagementBundle:ResourceWingspanGroupMap')->findBy(array('resourceId' => $resource->getId()));
  1537.       //  if(!empty($alreadymappedWingspanGroups)){
  1538.            // foreach($alreadymappedWingspanGroups as $alreadymappedWingspanGroups){
  1539.                // $alreadymappedWingspanGroups->setIsActive('N');
  1540.               //  $em->persist($alreadymappedWingspanGroups);
  1541.            // }
  1543.        // }
  1544.         $wingspan_group_id = $request->request->get('wingspan_group_id');
  1545.         if(!empty($wingspan_group_id)){
  1546.             $sent_id = '';
  1547.             $wingSpanCollavoratorId = $resource->getWingSpanCollaboratorId();
  1548.             $wingSpanService = $this->container->get('resource.wingSpan');
  1549.             if(empty($wingSpanCollavoratorId)) {
  1551.                 $dataArray = array();
  1552.                 $dataArray['email'] = $resource->getEmail();
  1553.                 $dataArray['firstName'] = $resource->getFirstName();
  1554.                 $dataArray['lastName'] = $resource->getLastName();
  1555.                 $dataArray['memberCompany'] = 'CQ Digital';
  1556.                 $dataArray['memberId'] = $resource->getId();
  1557.                // if (!empty($resource->getWingSpanCollaboratorGroupId())) {
  1560.                     $response = $wingSpanService->CreateCollaborator($dataArray);
  1562.                     $resource->setWingSpanCollaboratorId($response['collaboratorId']);
  1563.                     $wingSpanCollaboratorId = $response['collaboratorId'];
  1564.                     // $wingSpanService->pushCollaboratorGroup($response['collaboratorId'], $resource->getWingSpanCollaboratorGroupId());
  1566.                 //}
  1567.             }
  1568.             foreach($wingspan_group_id as $key=>$value){
  1569.                 $alreadymappedWingspanGroups = $this->getDoctrine()->getRepository('ResourceManagementBundle:ResourceWingspanGroupMap')->findBy(array('resourceId'=>$resource->getId(),'wingspanGroupId'=>$value));
  1571.                 if(!empty($alreadymappedWingspanGroups)){
  1573.                 }else {
  1575.                     $ResourceWingspanGroupMap = new ResourceWingspanGroupMap();
  1576.                     $ResourceWingspanGroupMap->setResourceId($resource->getId());
  1577.                     $ResourceWingspanGroupMap->setWingspanGroupId($value);
  1578.                     $ResourceWingspanGroupMap->setIsActive('Y');
  1579.                     $ResourceWingspanGroupMap->setPushedWingspan('Y');
  1580.                     $ResourceWingspanGroupMap->setCreatedDate(new \DateTime());
  1581.                     $ResourceWingspanGroupMap->setUpdatedDate(new \DateTime());
  1584.                     $em->persist($ResourceWingspanGroupMap);
  1586.                    $wingSpanService->pushCollaboratorGroup($resource->getWingSpanCollaboratorId(), $value);
  1588.                     if(!empty($sent_id))
  1589.                         $sent_id .= ', '.$value;
  1590.                     else
  1591.                         $sent_id = $value;
  1592.                 }
  1593.                 // tag wingspan group to collaborator
  1595.                 // tag wingspan group to collaborator
  1596.             }
  1598.             if(!empty($sent_id)) {
  1599.                 $user = $this->get('security.token_storage')->getToken()->getUser();
  1600.                 $comment = "The resource, " . $resource->getFirstName() . " " . $resource->getLastName() . ", was updated by " . $user . ", with the following changes: added wingspan group $sent_id.";
  1601.                 $UserNote = new UserNote();
  1602.                 $UserNote->setComment($comment);
  1603.                 $UserNote->setCommentDate(new \DateTime());
  1604.                 $UserNote->setCommentByResource($user);
  1605.                 $UserNote->setResource($resource);
  1606.                 $UserNote->setUserNotesTypeId(9);
  1607.                 $UserNote->setEntryDate(new \DateTime());
  1609.                 $em->persist($UserNote);
  1610.             }
  1611.         }
  1613.         # for saving wingspan groups ends
  1614.         $addr_form = $request->request->get('addr_form');
  1616.         if(!$addr_form['phone'] && !$envService->getIsCarrier())
  1617.         {
  1618.             $nextError['id'] = "phone";
  1619.             $nextError['text'] = "This field needs a value, it cannot be blank!";
  1620.             $data['errors'][] = $nextError;
  1622.             $retVal = array(
  1623.                 "result" => "fail",
  1624.                 "error_msgs" => $data['errors'],
  1625.                 "error" => true,
  1626.                 "data" => $data
  1627.             );
  1628.             return new JsonResponse($retVal);
  1629.         }
  1631.         if(!$addr_form['city'] && !$envService->getIsCarrier())
  1632.         {
  1633.             $nextError['id'] = "city";
  1634.             $nextError['text'] = "This field needs a value, it cannot be blank!";
  1635.             $data['errors'][] = $nextError;
  1637.             $retVal = array(
  1638.                 "result" => "fail",
  1639.                 "error_msgs" => $data['errors'],
  1640.                 "error" => true,
  1641.                 "data" => $data
  1642.             );
  1643.             return new JsonResponse($retVal);
  1644.         }
  1646.         if(!$addr_form['state'] && !$envService->getIsCarrier())
  1647.         {
  1648.             $nextError['id'] = "state";
  1649.             $nextError['text'] = "This field needs a value, it cannot be blank!";
  1650.             $data['errors'][] = $nextError;
  1652.             $retVal = array(
  1653.                 "result" => "fail",
  1654.                 "error_msgs" => $data['errors'],
  1655.                 "error" => true,
  1656.                 "data" => $data
  1657.             );
  1658.             return new JsonResponse($retVal);
  1659.         }
  1661.         if(!$addr_form['zip'] && !$envService->getIsCarrier())
  1662.         {
  1663.             $nextError['id'] = "zip";
  1664.             $nextError['text'] = "This field needs a value, it cannot be blank!";
  1665.             $data['errors'][] = $nextError;
  1667.             $retVal = array(
  1668.                 "result" => "fail",
  1669.                 "error_msgs" => $data['errors'],
  1670.                 "error" => true,
  1671.                 "data" => $data
  1672.             );
  1673.             return new JsonResponse($retVal);
  1674.         }
  1676.         if(!$addr_form['address'] && !$envService->getIsCarrier())
  1677.         {
  1678.             $nextError['id'] = "address";
  1679.             $nextError['text'] = "This field needs a value, it cannot be blank!";
  1680.             $data['errors'][] = $nextError;
  1682.             $retVal = array(
  1683.                 "result" => "fail",
  1684.                 "error_msgs" => $data['errors'],
  1685.                 "error" => true,
  1686.                 "data" => $data
  1687.             );
  1688.             return new JsonResponse($retVal);
  1689.         }
  1691.         $resID = null;
  1692.         if(!empty($resource))
  1693.             $resID = $resource->getId();
  1696.         if ($resourceType instanceof \Globals\ResourceManagementBundle\Entity\ResourceType) {
  1697.             $resource->setResourceType($resourceType);
  1698.         } else {
  1699.             /**
  1700.              * Resource Type id 2 should be field adjuster
  1701.              * better to search by int rather than string.
  1702.              */
  1703.             $resourceType = $em->getRepository("ResourceManagementBundle:ResourceType")->find(2);
  1704.             $resource->setResourceType($resourceType);
  1705.         }
  1707.         # Compare 2 objects to see if there were any changes made
  1709.         if ($resourceForm->isValid()) {  // if form is valid
  1711.             # Validate for duplicate email
  1712.             $HasEmail = $em->getRepository("ResourceManagementBundle:Resource")->checkEmailExists($resource->getEmail(), $resource->getId());
  1713.             if ($HasEmail) {
  1715.                 $errors2 = array();
  1716.                 $data = [
  1717.                     "errors" => array()
  1718.                 ];
  1720.                 $nextError = array();
  1721.                 $nextError['id'] = "email";
  1722.                 $nextError['text'] = "This email already exists with a different account.";
  1723.                 $data['errors'][] = $nextError;
  1725.                 $retVal = array(
  1726.                     "result" => "fail",
  1727.                     "error_msgs" => $errors2,
  1728.                     "error" => true,
  1729.                     "data" => $data
  1730.                 );
  1731.                 return new JsonResponse($retVal);
  1732.             }
  1734.             # Validate for duplicate username
  1735.             $HasUser = $em->getRepository("ResourceManagementBundle:Resource")->checkUsernameExists($resource->getUsername(), $resource->getId());
  1736.             if ($HasUser) {
  1737.                 $errors2 = array();
  1738.                 $data = [
  1739.                     "errors" => array()
  1740.                 ];
  1741.                 $nextError = array();
  1742.                 $nextError['id'] = "username";
  1743.                 $nextError['text'] = "This username already exists with a different account.";
  1744.                 $data['errors'][] = $nextError;
  1746.                 $retVal = array(
  1747.                     "result" => "fail",
  1748.                     "error_msgs" => $errors2,
  1749.                     "error" => true,
  1750.                     "data" => $data
  1751.                 );
  1752.                 return new JsonResponse($retVal);
  1753.             }
  1755.             # If password field was updated
  1756.             if ($password) {
  1757.                 # encrypt submitted password
  1759.                 $resource->setPassword(md5($password));
  1760.                 $resource->setPasswordChangeDate(new \DateTime());
  1761.             }
  1763.             # If is being changed to Adjuster and does not have PayCom ID
  1764.             if ($resource->getResourceType() == "Adjuster") {
  1765.                 if (!$resource->getPayrollId()) {
  1766.                     # Add Paycom ID
  1767.                     $payrollService = $this->get('resource.payroll_service');
  1768.                     $payrollIdExists = true;
  1769.                     do {
  1770.                         $length = 4;
  1771.                         $payrollId = $payrollService->randomStr($length);
  1772.                         $resourceWithPayroll = $this->getDoctrine()->getRepository('ResourceManagementBundle:Resource')->findBy(array('payrollId' => $payrollId));
  1773.                         if (empty($resourceWithPayroll)) {
  1774.                             $payrollIdExists = false;
  1775.                         }
  1776.                     } while ($payrollIdExists === true);
  1777.                     $resource->setPayrollId($payrollId);
  1778.                 }
  1779.             }
  1781.             if ($role) {  // if role passed
  1782.                 # Set Security Role as Json
  1783.                 $roleArr[] = $role;
  1784.                 $resource->setRoles(json_encode($roleArr));
  1785.             }
  1787.             if($didSupervisorChange){
  1788.                 /** @var Resource $user */
  1789.                 $user = $this->get('security.token_storage')->getToken()->getUser();
  1791.                 $oldSupervisor = is_null($oldSupervisor)?"NULL":$oldSupervisor;
  1792.                 $newSupervisor = is_null($newSupervisor)?"NULL":$newSupervisor;
  1794.                 $comment = "The resource, ". $resource->getFirstName()." ".$resource->getLastName().", was updated by " . $user . ", with the following changes: Supervisor was changed from $oldSupervisor to $newSupervisor.";
  1795.                 $UserNote = new UserNote();
  1796.                 $UserNote->setComment($comment);
  1797.                 $UserNote->setCommentDate(new \DateTime());
  1798.                 $UserNote->setCommentByResource($user);
  1799.                 $UserNote->setResource($resource);
  1800.                 $UserNote->setUserNotesTypeId(9);
  1801.                 $UserNote->setEntryDate(new \DateTime());
  1803.                 $em->persist($UserNote);
  1804.             }
  1805.             # compare the Db value with post value data
  1806.             $DbAddress=$resource->getAddress();
  1807.             $checkAddress = strcmp(trim($addr_form['address']),trim($DbAddress));
  1809.             if ($checkAddress !=0){
  1810.                 $OldAddressInfo .=$DbAddress.', ';
  1811.                 $AddressInfo .=$addr_form['address'].', ';
  1812.             }
  1814.             $DbCity=$resource->getCity();
  1815.             $checkCity = strcmp(trim($addr_form['city']),trim($DbCity));
  1817.             if ($checkCity !=0){
  1818.                 $OldAddressInfo .=$DbCity.', ';
  1819.                 $AddressInfo .=$addr_form['city'].', ';
  1820.             }
  1822.             $DbState=$resource->getState()->getId();
  1823.             if (intval($addr_form['state']) != $DbState){
  1824.                 $NewStateName = $em->getRepository("ResourceManagementBundle:State")->find(intval($addr_form['state']));
  1825.                 $OldAddressInfo .=$resource->getState()->getStateName().', ';
  1826.                 $AddressInfo .=$NewStateName->getStateName();
  1827.             }
  1829.             $DbZip=$resource->getZip();
  1830.             $checkZip = strcmp(trim($addr_form['zip']),trim($DbZip));
  1832.             if ($checkZip !=0){
  1833.                 $OldAddressInfo .=$DbZip.', ';
  1834.                 $AddressInfo .=$addr_form['zip'].', ';
  1835.             }
  1837.             $DbPhone=$resource->getPhone();
  1839.             if ($addr_form['phone'] != $DbPhone){
  1840.                 $OldAddressInfo .=" Phone No: ".$DbPhone;
  1841.                 $AddressInfo .=" Phone No: ". $addr_form['phone'];
  1842.             }
  1844.             # compare the Db value with post value data
  1845.             # 11/2018
  1846.             # CUSTOM ADDRESS SAVING
  1847.             $resource->setAddress("");
  1848.             if($addr_form['address'])
  1849.             {
  1850.                 $resource->setAddress($addr_form['address']);
  1851.             }
  1852.             $resource->setCity("");
  1853.             if($addr_form['city'])
  1854.             {
  1855.                 $resource->setCity($addr_form['city']);
  1856.             }
  1857.             $State = $em->getRepository("ResourceManagementBundle:State")->find(1);
  1858.             $resource->setState($State);
  1859.             if(intval($addr_form['state']) > 0)
  1860.             {
  1861.                 $State = $em->getRepository("ResourceManagementBundle:State")->find(intval($addr_form['state']));
  1862.                 $resource->setState($State);
  1863.             }
  1865.             $resource->setZip("");
  1866.             if($addr_form['zip'])
  1867.             {
  1868.                 $resource->setZip($addr_form['zip']);
  1869.             }
  1870.             $resource->setPhone("");
  1871.             if($addr_form['phone'])
  1872.             {
  1873.                 $resource->setPhone($addr_form['phone']);
  1874.             }
  1876.             # Check if Resource Entity Changed (from Resource Event Listener)
  1877.             $session->remove("ResourceChanged");
  1878.             $session->remove("ResourceChanges");
  1880.             # Persist to DB using Resource Profile Service method - saveUpdateResouce()
  1881.             $resource_profile = $this->container->get("app.resource_profile");
  1883.             $resource_profile->saveUpdateResource($resource, false);
  1885.             $dispatcher = $this->get('event_dispatcher');
  1886.            $dispatcher->dispatch(new ResourceUpdatedEvent($resource), ResourceUpdatedEvent::RENAME );
  1888.             # send mail to Finance  team if Profile of resource updated
  1889.             $FinanceTeamEmail = $em->getRepository('CoreBundle:SystemControlMetadata')->findOneBy(['cmetaKey' => 'fin_team_emails_to_send']);
  1891.             $tokenStorage = $this->container->get('security.token_storage');
  1892.             $user  = $tokenStorage->getToken()->getUser();
  1893.             $mailer = $this->container->get('mail_management.mailer');
  1894.             $email_from = $user->getEmail();
  1895.             //$mailer->replaceParam = array('strImagePath' => "", 'imageUrl' => "");
  1896.             $mailer->setSendingConfig();
  1897.             $addresses = explode(',', $FinanceTeamEmail instanceof SystemControlMetadata ? $FinanceTeamEmail->getCmetaValue() : "");
  1898.             $email_body ="<p><strong>Hi Team,</strong></p>";
  1899.             $email_body .="<p>User Profile: ".$resource->getFullName()." has been updated</p>";
  1900.             if(!empty($AddressInfo) ){
  1901.                 $email_body .="<p><strong>Old Address: </strong>".$OldAddressInfo."</p>";
  1902.                 $email_body .="<p><strong>New Address: </strong>".$AddressInfo."</p><br/>";
  1903.             }
  1904.             if(!empty($workType) ){
  1905.                 $email_body .="<p><strong>Old Employee Type: </strong>".$oldworkType."</p>";
  1906.                 $email_body .="<p><strong>New Employee Type: </strong>".$workType."</p><br/>";
  1907.             }
  1909.             if(!empty($AddressInfo) ||  !empty($workType)){
  1910.                 $email_body .="<br/> Thanks </br/> system Admin";
  1911.                 $Mail = new Mail();
  1912.                 foreach ($addresses as $address) {
  1913.                     # SETTING THE SUBJECT
  1914.                     # ######################################################
  1915.                     $email_to = $address;
  1916.                     # Recipient
  1917.                     $Recipient = new MailRecipient();
  1918.                     $Recipient->setEmail($email_to);
  1919.                     $Recipient->setMail($Mail);
  1920.                     $Recipient->setRecipientId($user->getId());
  1921.                     $entityName = $em->getMetadataFactory()->getMetadataFor(get_class($user))->getName();
  1922.                     $Recipient->setRecipientType($entityName);
  1923.                     # Adds the single recipient (resource);
  1924.                     $Mail->addRecipient($Recipient);
  1925.                     $Mail->setSubject("User Profile updated - Notification");
  1927.                 }
  1928.                 # Finalize the MAIL object
  1929.                 $Mail->setBody($email_body);
  1930.                 $Mail->setSenderName(MailHelper::getMailSenderName($tokenStorage));
  1931.                 $mailer->sendEmail($Mail, $email_from, "");
  1932.             }
  1934.             # Return JSON Success Object
  1935.             $retVal = array(
  1936.                 "result" => "success",
  1937.                 "error_msgs" => []
  1938.             );
  1939.             return new JsonResponse($retVal);
  1941.         } else {
  1943.             $data = [];
  1945.             # Get Form Errors using Validator Service
  1946.             $errors = $this->get("validator")->validate($resource);dd($errors);
  1947.             $errors2 = array();
  1948.             if (count($errors) > 0) {
  1949.                 $data = [
  1950.                     "errors" => array()
  1951.                 ];
  1952.                 foreach ($errors as $error) {
  1953.                     $nextError = array();
  1954.                     $nextError['id'] = $error->getPropertyPath();
  1955.                     $nextError['text'] = $error->getMessage();
  1956.                     $data['errors'][] = $nextError;
  1957.                 }
  1958.             }
  1960.             # Return JSON with Error Messages
  1961.             $retVal = array(
  1962.                 "result" => "fail",
  1963.                 "error_msgs" => $errors2,
  1964.                 "error" => true,
  1965.                 "data" => $data
  1966.             );
  1967.             return new JsonResponse($retVal);
  1968.         }
  1969.     }
  1971.     /**
  1972.      * Handle Upload Signature File Action
  1973.      * recieves file object and saves to session for later use
  1974.      *
  1975.      * @Route("/administration/resource/upload_image")
  1976.      */
  1977.     public function saveUploadImageResourceAjaxAction(Request $request)
  1978.     {
  1979.         if (isset($_FILES['files']) && count($_FILES['files']['name']) > 0) {  // if file uploaded
  1981.             $session = new Session();
  1982.             # Extract File Object from $_FILES object
  1983.             $useFile = array();
  1984.             foreach ($_FILES['files'] as $key => $value) {
  1985.                 $useFile[$key] = $value[0];
  1986.             }
  1987.             $pathArr = pathinfo(strtolower($useFile['name']));
  1988.             # Add File Extension to File Object Array
  1989.             $useFile['file_ext'] = $pathArr['extension'];
  1991.             # Validate file type
  1992.             $allowed_file_types = ["jpg", "jpeg", "png", "gif"];
  1993.             if (!in_array($useFile['file_ext'], $allowed_file_types)) {  // if uploaded invalid file type
  1995.                 # pass back validation message of bad file type, instead of file name
  1996.                 $retVal = [
  1997.                     "files" => [
  1998.                         [
  1999.                             "name" => "File type not allowed"
  2000.                         ]
  2001.                     ]
  2002.                 ];
  2003.                 return new JsonResponse($retVal);
  2004.             }
  2006.             # create unique hash for filename, without extension
  2007.             $path = $useFile['tmp_name'];
  2008.             $get_num = md5(uniqid());
  2010.             $new_file_name = is_numeric($get_num) ? $this->getRandomLargeNumber() : $get_num;
  2012.             $new_file_path = "/tmp/" . $new_file_name;
  2013.             $useFile['new_file_name'] = $new_file_name;
  2015.             $Log = new SLogger();
  2016.             $Log->log("new_file_name: " . $new_file_name);
  2018.             # make note where file came from
  2019.             $useFile['used_by_module'] = "EditResource";
  2020.             $orig_file_name = $useFile['name'];
  2022.             # save to session
  2023.             $session->set("resource_upload_image", $useFile);
  2025.             # copy as new file with unique id filename in /tmp folder, since original tmp file will be deleted after page runs
  2026.             move_uploaded_file($path, $new_file_path);
  2027.         }
  2029.         # Return file name back to upload plugin
  2030.         $retVal = [
  2031.             "files" => [
  2032.                 [
  2033.                     "name" => $orig_file_name
  2034.                 ]
  2035.             ]
  2036.         ];
  2037.         return new JsonResponse($retVal);
  2038.     }
  2040.     /**
  2041.      * Modify Adjuster Positions Action
  2042.      *
  2043.      * @Route("/administration/resource/adjuster_position/edit/{id}")
  2044.      */
  2045.     public function editResourceAdjusterPositionAjaxAction(Resource $resource)
  2046.     {
  2047.         # lets make sure user has access to this page (stronger than super admin rights)
  2049.         $em = $this->container->get("doctrine.orm.entity_manager");
  2051.         $user = $this->get('security.token_storage')->getToken()->getUser();
  2052.         $systemParamService = $this->get('core.system_parameter_control');
  2053.         $access = $systemParamService->getAccessArray('access_resource');
  2055.         if (in_array($user->getId(), $access)) {
  2056.             $specialAccess = true;
  2057.         }
  2059.         # Create Form Builder Object for "Edit Adjuster Positions"
  2061.         $formFactory = $this->container->get("form.factory");
  2062.         $kernel = $this->container->get("kernel");
  2063.         $authChecker = $this->container->get("security.authorization_checker");
  2064.         $onlyServerSideVal=false;
  2065.         $form_helper = new ResourceFormHelper($em, $formFactory, $kernel, $onlyServerSideVal, $authChecker);
  2066.         $resourcePositionForm = $form_helper->getAdjusterPositionEditForm($resource);
  2068.         # Get Current Adjuster Positions for this Resource
  2069.         $adjusterPositions = array();
  2070.         $adjusterPosIDs = array();
  2071.         foreach ($resource->getAdjusterPositions() as $adjusterPosition) {
  2072.             $adjusterPositions[] = $adjusterPosition;
  2073.             $adjusterPosIDs[] = $adjusterPosition->getId();
  2074.         }
  2076.         # Create array that contians whether or not each Adjuster Position exists on db for this Resource
  2077.         $SelAdjustersLoop = [];
  2078.         $AllAdjusterPositions = $em->getRepository("ResourceManagementBundle:AdjusterPosition")->findBy(array(),array('positionName' => 'ASC') );
  2079.         foreach ($AllAdjusterPositions as $getPosition) {
  2080.             if (in_array($getPosition->getId(), $adjusterPosIDs)) {
  2081.                 $SelAdjustersLoop[] = 1;
  2082.             } else {
  2083.                 $SelAdjustersLoop[] = 0;
  2084.             }
  2085.         }
  2087.         # Variable that sets active tab
  2088.         $active = 'adjusterPositions';
  2090.         $apiEndPointUsers = $systemParamService->getAccessArray('PushNotificaton_tab');
  2091.         $bShowAPIEndPointTab = false;
  2092.         if (!empty($apiEndPointUsers) && in_array($user->getId(),$apiEndPointUsers)) {
  2093.             $bShowAPIEndPointTab = true;
  2094.         }
  2095.         return $this->render("ResourceManagementBundle:resources/adjuster_position:edit.html.twig", [
  2096.             "specialAccess" => isset($specialAccess),
  2097.             "resourcePositionForm" => $resourcePositionForm->createView(),
  2098.             "id" => $resource->getId(),
  2099.             "resource" => $resource,
  2100.             "useResource" => $resource,
  2101.             "SelAdjustersLoop" => $SelAdjustersLoop,
  2102.             "AllAdjusterPositions" => $AllAdjusterPositions,
  2103.             "activeClass" => $active,
  2104.             "bShowAPIEndPointTab" => $bShowAPIEndPointTab
  2105.         ]);
  2106.     }
  2108.     /**
  2109.      * Save Adjuster Positions Action
  2110.      *
  2111.      * @Route("/administration/resource/adjuster_position/save_edit/{id}")
  2112.      */
  2113.     public function saveEditResourceAdjusterPositionAjaxAction(Request $request, Resource $resource)
  2114.     {
  2115.         # use "Edit Adjuster Positsions" Form Object to get submitted form object
  2116.         $em = $this->container->get("doctrine.orm.entity_manager");
  2117.         $formFactory = $this->container->get("form.factory");
  2118.         $kernel = $this->container->get("kernel");
  2119.         $authChecker = $this->container->get("security.authorization_checker");
  2120.         $onlyServerSideVal = false;
  2121.         $form_helper = new ResourceFormHelper($em, $formFactory, $kernel, $onlyServerSideVal,$authChecker);
  2122.         $form = $form_helper->getAdjusterPositionEditForm($resource);
  2124.         # Log Changes to User Note
  2125.         $user = $this->container->get("security.token_storage")->getToken()->getUser();
  2126.         $userNoteLog = $this->container->get("app.resource_note_logger");
  2129.         # Handle Request
  2130.         $form->handleRequest($request);
  2131.         $resource = $form->getData();
  2133.         #Check the adjuster positions that a user alreday has
  2134.         $sql = "SELECT adjuster_position_id 
  2135.                 FROM resource_adjuster_position 
  2136.                 WHERE resource_id = :resource_id ";
  2138.         $stmt = $em->getConnection()->prepare($sql);
  2139.         $stmt->execute(array("resource_id" => $resource->getId()));
  2140.         $resourcePositions = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  2142.         $slog = new SLogger();
  2143.         $slog->log('$resourcePositions');
  2144.         $slog->log($resourcePositions);
  2146.         $existingPositions  = array();
  2147.         foreach ($resourcePositions as $resourcePosition){
  2148.             $existingPositions[] = $resourcePosition['adjuster_position_id'];
  2149.         }
  2151.         $slog->log('$existingPositions');
  2152.         $slog->log($existingPositions);
  2154.         ## Handle updating of adjuster position checkboxes
  2155.         # First, Delete all relations between resource and adjuster positions
  2156.         $sql = "DELETE FROM resource_adjuster_position WHERE resource_id = :resource_id ";
  2157.         $stmh = $em->getConnection()->prepare($sql);
  2158.         $stmh->execute(array("resource_id" => $resource->getId()));
  2160.         # Will then add back adjuster positions that were checked on form
  2161.         $sql = "INSERT INTO resource_adjuster_position
  2162.                 ( resource_id,  adjuster_position_id) VALUES
  2163.                 (:resource_id, :adjuster_position_id) ";
  2165.         $stmh_insert_resource_aduster = $em->getConnection()->prepare($sql);
  2166.         $positions = $request->request->get("chkPosition");
  2168.         $slog->log('$positions');
  2169.         $slog->log($positions);
  2171.         if ($positions) {
  2172.             foreach ($positions as $getPosition) {
  2173.                 $positionAdded = true;
  2175.                 $sql = "INSERT INTO resource_adjuster_position
  2176.                     ( resource_id,  adjuster_position_id) VALUES
  2177.                     (:resource_id, :adjuster_position_id) ";
  2179.                 # add back adjuster positions that were checked on form
  2180.                 $stmh_insert_resource_aduster->execute(array(
  2181.                     "resource_id" => $resource->getId(),
  2182.                     "adjuster_position_id" => $getPosition
  2183.                 ));
  2185.                 if($existingPositions) {
  2186.                     if (in_array($getPosition, $existingPositions)) {
  2187.                         $positionAdded = false;
  2188.                     }
  2189.                 }
  2191.                 $AdjusterPosition = $em->getRepository("ResourceManagementBundle:AdjusterPosition")->find($getPosition);
  2193.                 if($positionAdded){
  2194.                     #log the user note
  2195.                     if ($resource->getId() == $user->getId()) {
  2196.                         $comment = $resource->getFullName() . " added the position" . $AdjusterPosition->getPositionName() . " to his profile.";
  2197.                     } else {
  2198.                         $comment = "The position "  . $AdjusterPosition->getPositionName() . ", was added to the user " . $resource->getFullName() . ", by " . $user->getFullName() . ".";
  2199.                     }
  2201.                     $userNoteLog->logNote($comment, $resource);
  2202.                 }
  2203.             }
  2204.         }
  2207.         if($existingPositions){
  2208.             foreach ($existingPositions as $existingPosition){
  2209.                 $positionRemoved = true;
  2211.                 if($positions) {
  2212.                     if (in_array($existingPosition, $positions)) {
  2213.                         $positionRemoved = false;
  2214.                     }
  2215.                 }
  2216.                 $AdjusterPosition = $em->getRepository("ResourceManagementBundle:AdjusterPosition")->find($existingPosition);
  2218.                 if($positionRemoved){
  2219.                     #log the user note
  2220.                     if ($resource->getId() == $user->getId()) {
  2221.                         $comment = $resource->getFullName() . " removed the position" . $AdjusterPosition->getPositionName() . " from his profile.";
  2222.                     } else {
  2223.                         $comment = "The position "  . $AdjusterPosition->getPositionName() . ", was removed from the user " . $resource->getFullName() . ", by " . $user->getFullName() . ".";
  2224.                     }
  2226.                     $userNoteLog->logNote($comment, $resource);
  2227.                 }
  2228.             }
  2229.         }
  2231.         # Save Other Resource Fields on Adjuster Positions Form
  2232.         $em->persist($resource);
  2233.         $em->flush();
  2234.         // for saving data of adjuster position tab update start
  2235.         $dispatcher = $this->get('event_dispatcher');
  2236.         $dispatcher->dispatch(new ResourceUpdatedEvent($resource), ResourceUpdatedEvent::RENAME );
  2237.         // for saving data of adjuster position tab update end
  2238.         # Return Success JSON
  2239.         $retVal = array(
  2240.             "error" => false,
  2241.             "error_msgs" => []
  2242.         );
  2243.         return new JsonResponse($retVal);
  2244.     }
  2246.     /**
  2247.      * Show Datatable Ajax Data Action (for Old DataBuilders Style)
  2248.      *
  2249.      * @Route("/administration/resources2/search")
  2250.      */
  2251.     public function showResources2DataTablesAction(Request $request)
  2252.     {
  2253.         $User = $this->container->get("security.token_storage")->getToken()->getUser();
  2255.         # Array of columns that will be sorted
  2256.         $columnsArr = array(
  2257.             "id",
  2258.             "username",
  2259.             "first_name",
  2260.             "last_name",
  2261.             "city",
  2262.             "state",
  2263.             "zip",
  2264.             "payroll_id",
  2265.             "show_active"
  2266.         );
  2267.         $active = intval($request->query->get("active"));
  2271.         $dataParams = array();
  2272.         $sql = "SELECT sr.*, S.stateName state, CASE WHEN ifnull(sr.is_active, 0) = 1 THEN 'Yes' ELSE 'No' END as show_active
  2273.                 FROM resource sr
  2274.                 LEFT JOIN state S
  2275.                   ON sr.state_id = S.id
  2276.                 WHERE roles NOT LIKE '%REGISTERED%' AND roles NOT LIKE '%BRANCH%' AND roles IS NOT NULL ";
  2277.         if ($active == 1) {
  2278.             $sql .= "AND sr.is_active = 1 ";
  2279.         } else if ($active == 0) {
  2280.             $sql .= "AND sr.is_active = 0 ";
  2281.         }
  2282.         $systemParamService             = $this->container->get('core.system_parameter_control');
  2284.         if(in_array('ROLE_TEAM_LEADER',$User->getRoles()) ) {
  2286.             $sql_recur = "SELECT sr.*, S.stateName state, CASE WHEN ifnull(sr.is_active, 0) = 1 THEN 'Yes' ELSE 'No' END as show_active
  2287.                 FROM resource sr
  2288.                 LEFT JOIN state S
  2289.                   ON sr.state_id = S.id
  2290.                 WHERE isSupervisees(:supervisor_id,sr.id) = 1 OR sr.ID = :supervisor_id_2
  2291.                 AND sr.roles NOT LIKE '%REGISTERED%' AND sr.roles NOT LIKE '%BRANCH%' AND sr.roles IS NOT NULL ";
  2293.             if ($active == 1) {
  2294.                 $sql_recur .= "AND sr.is_active = 1 ";
  2295.             } else if ($active == 0) {
  2296.                 $sql_recur .= "AND sr.is_active = 0 ";
  2297.             }
  2299.             //$sql .=" AND sr.supervisor_id = :supervisor_id";
  2300.             $dataParams['supervisor_id'] = $User->getId();
  2301.             $dataParams['supervisor_id_2'] = $User->getId();
  2304.             $slog = new SLogger();
  2305.             $slog->log("$sql_recur");
  2306.             $slog->log($sql_recur);
  2308.             $sql = $sql_recur;
  2309.         }
  2311.         # if search keyword input was typed
  2312.         $keyword_filter = "AND ( concat_ws(' ',first_name,last_name) like :keyword or sr.id like :keyword or first_name like :keyword or last_name like :keyword or username like :keyword or city like :keyword or zip like :keyword or payroll_id like :keyword) ";
  2315.         $paginator = $this->container->get("resource.paginator_service");
  2316.         $retVal = $paginator->getPaginationResults($request, $sql, $dataParams, "sr.first_name ASC", $columnsArr, "", $keyword_filter, "keyword", "", "POST");
  2318.         # Manipulate the resultset to be recieved by datatable
  2319.         $Results2 = $retVal['data'];
  2321.         $Results = array();
  2322.         foreach ($Results2 as $index => $getResult) {
  2323.             $getResult2 = $getResult;
  2325.             $getResult2['is_active'] = $getResult['is_active'] == 1 ? "Yes" : "No";
  2326.             $rolesArr2 = array();
  2327.             $rolesArr = json_decode($getResult['roles']);
  2329.             if (is_array($rolesArr)) {
  2330.                 foreach ($rolesArr as $getRole) {
  2331.                     $rolesArr2[] = ResourceRoleEnum::getTypeName($getRole);
  2332.                 }
  2334.             } else {
  2335.                 $rolesArr2[] = ResourceRoleEnum::getTypeName($rolesArr);
  2336.             }
  2338.             $getResult2['roles'] = implode(", ", $rolesArr2);
  2340.             unset($getResult2['entryDate']);
  2341.             $Results[$index] = $getResult2;
  2342.         }
  2343.         $retVal['data'] = $Results;
  2345.         return new JsonResponse($retVal);
  2346.     }
  2348.     /**
  2349.      * @param $sql
  2350.      * @return array
  2351.      *
  2352.      * This creates a paginator from raw sql
  2353.      */
  2354.     public function paginateSQL($sql, $params)
  2355.     {
  2356.         $em = $this->container->get("doctrine.orm.entity_manager");
  2357.         $paginator = new PaginatorSQL($em, $sql, $params);
  2358.         return $paginator;
  2359.     }
  2361.     /**
  2362.      * @Route("/administration/resource/delete", methods={"POST"})
  2363.      */
  2364.     public function deleteResourceAction(Request $request)
  2365.     {
  2366.         if ($this->get('security.authorization_checker')->isGranted('delete') === false) {
  2367.             $retVal = [
  2368.                 'error' => false,
  2369.                 'error_msgs' => ['You Do Not Have Access To Delete']
  2370.             ];
  2372.             return new JsonResponse($retVal);
  2373.         }
  2374.         $em = $this->getDoctrine()->getManager();
  2376.         # Request ID to delete
  2377.         $id = intval($request->request->get("id"));
  2378.         # Delete Resource
  2379.         $Resource = $em->getRepository("ResourceManagementBundle:Resource")->find($id);
  2380.         if (empty($Resource)) {
  2381.             $retVal = [
  2382.                 'error' => true,
  2383.                 'error_msgs' => ['The resource does not exists']
  2384.             ];
  2385.         }
  2386.         $retVal = $this->container->get("resource.service")->isResourceAvailableForDeletion($Resource);
  2387.         if (!empty($retVal) && isset($retVal['error']) && $retVal['error'] === false ) {
  2388.             $strResFullName = $Resource->getFullName();
  2389.             $em->getConnection()->query('SET FOREIGN_KEY_CHECKS=0');
  2390.             $em->remove($Resource);
  2391.             $em->flush();
  2392.             $em->getConnection()->query('SET FOREIGN_KEY_CHECKS=1');
  2393.             $LoggedInUser = (string)$this->get("security.token_storage")->getToken()->getUser();
  2394.             $companyNoteService = $this->get('company.note_logger');
  2395.             $notes = "$strResFullName was deleted by $LoggedInUser.";
  2396.             $companyNoteService->addCompanyNote($notes);
  2397.             $retVal = [
  2398.                 'error' => false,
  2399.                 'error_msgs' => [],
  2400.                 'status' => 'success'
  2401.             ];
  2402.         }
  2404.         return new JsonResponse($retVal);
  2405.     }
  2408.     /**
  2409.      * @Route("/error/show500")
  2410.      */
  2411.     public function showError()
  2412.     {
  2414.         return $this->render("@ResourceManagement/error.html.twig");
  2415.     }
  2417.     /**
  2418.      * @Route("/administration/get_notifications/{resource_id}")
  2419.      */
  2420.     public function getNotifications($resource_id)
  2421.     {
  2422.         $notificationFinder = $this->container->get('resource.notification_service');
  2425.         return new JsonResponse($notificationFinder->getNotificationData($resource_id));
  2426.     }
  2429.     /**
  2430.      * @Route("/administration/test_slog")
  2431.      */
  2432.     public function testSLog()
  2433.     {
  2434.         $slog = new SLogger();
  2435.         $slog->log("did slogger work?");
  2437.         dump("completed"); die;
  2441.     }
  2444.     private function getRandomLargeNumber()
  2445.     {
  2446.         return (string)rand(1000000, 2000000) . (string)rand(1000000, 2000000);
  2447.     }
  2449.     /**
  2450.      * @param Request $request
  2451.      * @param $hash
  2452.      * @return Response
  2453.      * @throws \Exception
  2454.      * Reset Password Action
  2455.      * shown when user comes from forgot password email
  2456.      *
  2457.      * @Route("/administration/user/password/forgot/{hash}")
  2458.      */
  2459.     public function showForgotPasswordAction(Request $request, $hash)
  2460.     {
  2461.         # Remove old forgot password sessions
  2462.         $session = new Session();
  2463.         $session->remove("hash_user_token");
  2464.         $session->remove("hash_user_id");
  2466.         $em = $this->container->get("doctrine.orm.entity_manager");
  2468.         # Find user token record by hash
  2469.         $user_tokens = $em->getRepository('ResourceManagementBundle:UserToken')
  2470.             ->createQueryBuilder("u")
  2471.             ->where("u.hash = :hash")
  2472.             ->setParameter("hash", $hash)
  2473.             ->orderBy("u.entryDate", "DESC")
  2474.             ->getQuery()
  2475.             ->getResult();
  2477.         $user_token = new UserToken();
  2478.         if (count($user_tokens) > 0) {
  2479.             $user_token = $user_tokens[0];
  2480.         } else {  // if can't find token
  2481.             return $this->render("@ResourceManagement/emails/invalid.html.twig");
  2482.         }
  2484.         if ($user_token->getAction() != "ForgotPassword") {  // if token is not for "Forgot Password"
  2485.             return $this->render("@ResourceManagement/emails/invalid.html.twig");
  2486.         }
  2488.         # Make sure token is still valid (expires after 3 days)
  2489.         $entryDate = $user_token->getEntryDate();
  2490.         $curDate = new \DateTime(date("Y-m-d H:i:s"));
  2491.         $interval = $entryDate->diff($curDate);
  2492.         $daysDiff = $interval->format('%a');
  2494.         $resource_profile = $this->container->get("app.resource_profile");
  2496.         if ($daysDiff >= $resource_profile->daysValid) {
  2497.             return $this->render("@ResourceManagement/emails/invalid.html.twig");
  2498.         }
  2500.         # Get User from token record
  2501.         $resource = $em->getRepository("ResourceManagementBundle:Resource")->find($user_token->getUserId());
  2503.         # Save sessions to be used by "Save Reset Password Action"
  2504.         $session->set("hash_user_token", $hash);
  2505.         $session->set("hash_user_id", $resource->getId());
  2507.         # Create Reset Password Form Object
  2508.         $onlyServerSideVal = false;
  2509.         $em = $this->container->get("doctrine.orm.entity_manager");
  2510.         $formFactory = $this->container->get("form.factory");
  2511.         $kernel = $this->container->get("kernel");
  2512.         $form_helper = new ResourceFormHelper($em, $formFactory, $kernel, $onlyServerSideVal);
  2513.         $resourceForm = $form_helper->getUpdatePasswordForm();
  2515.         # Create Custom CSRF Token
  2516.         $UserToken = new  UserToken();
  2517.         $js_hash = md5($request->getClientIp() . $UserToken->salt_keyword2 . substr($request->headers->get('User-Agent'), 0, 17));
  2519.         return $this->render("ResourceManagementBundle:resources/templates:reset_password.html.twig", [
  2520.             "id" => $resource->getId(),
  2521.             "resource" => $resource,
  2522.             "hash" => $js_hash,
  2523.             "resourceForm" => $resourceForm->createView(),
  2524.             "onlyServerSideVal" => $onlyServerSideVal
  2525.         ]);
  2526.     }
  2529.     /**
  2530.      * Save Reset Password Action
  2531.      *
  2532.      * @Route("/administration/user/password/save_forgot")
  2533.      */
  2534.     public function saveForgotPasswordAction(Request $request)
  2535.     {
  2536.         $session = new Session();
  2538.         $em = $this->container->get("doctrine.orm.entity_manager");
  2540.         # check if session contains user token information
  2541.         if (!$session->has("hash_user_token")) {  // if session not exists
  2543.             # send error message
  2544.             $errors2 = array();
  2545.             $data = [
  2546.                 "errors" => array()
  2547.             ];
  2548.             $nextError = array();
  2549.             $nextError['id'] = "password";
  2550.             $nextError['text'] = "This link has expired.";
  2551.             $data['errors'][] = $nextError;
  2553.             $retVal = array(
  2554.                 "result" => "fail",
  2555.                 "error_msgs" => $errors2,
  2556.                 "error" => true,
  2557.                 "data" => $data
  2558.             );
  2559.             return new JsonResponse($retVal);
  2560.         }
  2562.         # load user by session from token
  2563.         $resource = $em->getRepository("ResourceManagementBundle:Resource")->find($session->get("hash_user_id"));
  2565.         # Validate Custom CSRF Token
  2566.         $UserToken = new  UserToken();
  2567.         $js_hash = md5($request->getClientIp() . $UserToken->salt_keyword2 . substr($request->headers->get('User-Agent'), 0, 17));
  2568.         $form_hash = $request->request->get("globals_hash_key");
  2569.         if ($js_hash != $form_hash) {  // if Custom CSRF token is invalid
  2571.             # send error message
  2572.             $errors2 = array();
  2573.             $data = [
  2574.                 "errors" => array()
  2575.             ];
  2576.             $nextError = array();
  2577.             $nextError['id'] = "password";
  2578.             $nextError['text'] = "This link has expired.";
  2579.             $data['errors'][] = $nextError;
  2581.             $retVal = array(
  2582.                 "result" => "fail",
  2583.                 "error_msgs" => $errors2,
  2584.                 "error" => true,
  2585.                 "data" => $data
  2586.             );
  2587.             return new JsonResponse($retVal);
  2588.         }
  2590.         $form = $request->request->get("form");
  2591.         $password = $form['password'];
  2593.         if ($password != "") {  // if password entered
  2595.             # Update password
  2596.             $resource->setPassword(md5($password));
  2598.             $em->persist($resource);
  2599.             $em->flush();
  2601.             $retVal = array(
  2602.                 "result" => "success",
  2603.                 "error_msgs" => []
  2604.             );
  2606.             # Remove token used for forgot password
  2607.             $sql = "DELETE FROM user_token WHERE hash = :hash";
  2608.             $stmt = $em->getConnection()->prepare($sql);
  2609.             $stmt->execute(array(
  2610.                 "hash" => $session->get("hash_user_token")
  2611.             ));
  2613.             # remove token session info
  2614.             $session->remove("hash_user_token");
  2615.             $session->remove("hash_user_id");
  2616.             return new JsonResponse($retVal);
  2618.         } else {  // if password is blank
  2620.             # send error message
  2621.             $errors2 = array();
  2622.             $data = [
  2623.                 "errors" => array()
  2624.             ];
  2625.             $nextError = array();
  2626.             $nextError['id'] = "password";
  2627.             $nextError['text'] = "You did not enter a password to update.";
  2628.             $data['errors'][] = $nextError;
  2630.             $retVal = array(
  2631.                 "result" => "fail",
  2632.                 "error_msgs" => $errors2,
  2633.                 "error" => true,
  2634.                 "data" => $data
  2635.             );
  2636.             return new JsonResponse($retVal);
  2637.         }
  2638.     }
  2639.     /**
  2640.      * @Route("/resource/adjuster-comment/{id}")
  2641.      */
  2642.     public function adjusterCommentAction(Request $request)
  2643.     {
  2644.         # logged in user
  2645.         $user = $this->get('security.token_storage')->getToken()->getUser();
  2646.         //dd($user->getId());
  2647.         $em = $this->container->get("doctrine.orm.entity_manager");
  2648.         $response = ['error'=>false, 'data'=>[]];
  2649.         $comment = $request->request->get('adjustercomment');
  2650.         $ResourceId = $request->get('id');
  2651.         # Check for post #
  2652.         if ($comment) {
  2653.             $ResourceEdited = $em->getRepository("ResourceManagementBundle:Resource")->find($ResourceId);
  2654.             $AdjComment = new AdjusterComment();
  2655.             $AdjComment->setComment($comment);
  2656.             $AdjComment->setCommentDate(new \DateTime());
  2657.             $AdjComment->setLoggedInUserId($user->getId());
  2658.             $AdjComment->setResourceId($ResourceEdited->getId());
  2659.             $em->persist($AdjComment);
  2660.             //dd($AdjComment);
  2661.             $em->flush();
  2662.             #collect the Adjuster Comment
  2663.             $sql = "SELECT ac.comment, ac.commentDate, CONCAT(r.first_name, ' ', r.last_name) AS author_name
  2664.               FROM adjuster_comments ac
  2665.               LEFT JOIN resource r
  2666.               ON ac.logged_in_user_id = r.id
  2667.               WHERE ac.resource_id = :rid
  2668.               ORDER BY ac.commentDate desc LIMIT 3";
  2670.             $AdjusterComments = array();
  2671.             $dataParams['rid'] = $ResourceEdited->getId();
  2672.             $stmt = $em->getConnection()->prepare($sql);
  2673.             //dd($stmt);
  2674.             $stmt->execute($dataParams);
  2675.             $AdjusterComments = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  2676.             if (count($AdjusterComments) < 0) {
  2677.                 $AdjusterComments = array();
  2678.             }else{
  2679.                 $response=['error'=>false, 'data'=>$AdjusterComments];
  2680.             }
  2681.             //dd($response);
  2683.             return new JsonResponse($response);
  2685.         }else{
  2686.             return new JsonResponse(['error' => 'Adjuster Comment\'s Cannot Be Blank']);
  2687.         }
  2688.     }
  2689.     /**
  2690.      * @Route("/resource/all-adjuster-comment/")
  2691.      */
  2692.     public function allAdjusterCommentAction(Request $request)
  2693.     {
  2694.         # logged in user
  2695.         $user = $this->get('security.token_storage')->getToken()->getUser();
  2696.         //dd($user->getId());
  2697.         $em = $this->container->get("doctrine.orm.entity_manager");
  2698.         $response = ['error'=>false, 'data'=>[]];
  2699.         $ResourceId = $request->request->get('resId');
  2700.         # Check for post #
  2701.         if ($ResourceId) {
  2703.             #collect the Adjuster Comment
  2704.             $sql = "SELECT ac.comment, ac.commentDate, CONCAT(r.first_name, ' ', r.last_name) AS author_name
  2705.               FROM adjuster_comments ac
  2706.               LEFT JOIN resource r
  2707.               ON ac.logged_in_user_id = r.id
  2708.               WHERE ac.resource_id = :rid
  2709.               ORDER BY ac.commentDate desc";
  2711.             $AdjusterComments = array();
  2712.             $dataParams['rid'] = $ResourceId;
  2713.             $stmt = $em->getConnection()->prepare($sql);
  2714.             //dd($stmt);
  2715.             $stmt->execute($dataParams);
  2716.             $AdjusterComments = $stmt->fetchAll(\PDO::FETCH_ASSOC);
  2717.             if (count($AdjusterComments) < 0) {
  2718.                 $AdjusterComments = array();
  2719.             }
  2721.             return $this->render('@ResourceManagement/resources/popup-adj-comments.html.twig', [
  2722.                 "AllComments" => $AdjusterComments
  2723.             ]);
  2725.         }else{
  2726.             return new JsonResponse(['error' => 'Adjuster Comment\'s Cannot Be Blank']);
  2727.         }
  2728.     }
  2729. }