src/Controller/HomeController.php line 84

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\User;
  6. use App\Entity\Categorie;
  7. use App\Entity\Subcategorie;
  8. use App\Entity\Products;
  9. use App\Entity\PvDetails;
  10. use App\Entity\Complaint;
  11. use App\Entity\ExpDays;
  12. use App\Entity\FraudComplaint;
  13. use App\Entity\FraudComplaintProducts;
  14. use App\Entity\Campaign;
  15. use App\Entity\AgentGroup;
  16. use App\Entity\Notifications;
  17. use App\Form\RegistrationFormType;
  18. use File;
  20. use App\Util\Mailer;
  21. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  22. use Doctrine\ORM\EntityManagerInterface;
  23. use Symfony\Component\EventDispatcher\EventDispatcherInterface;
  25. use Validator;
  26. use Symfony\Component\Validator\Constraints\IsTrue;
  27. use Symfony\Component\Validator\Constraints\Length;
  28. use Symfony\Component\Validator\Constraints\NotBlank;
  30. use App\Service\FileUploader;
  31. use Doctrine\ORM\EntityManager;
  32. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  33. use Symfony\Component\HttpFoundation\Response;
  34. use Symfony\Component\HttpFoundation\Request;
  35. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  36. use Symfony\Component\Routing\Annotation\Route;
  37. use Symfony\Component\Security\Http\Authentication\UserAuthenticatorInterface;
  38. use Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface;
  39. use PhpOffice\PhpSpreadsheet\IOFactory;
  40. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  41. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  44. class HomeController extends AbstractController
  45. {
  46.     private $dispatcher;
  47.     private $mailer;
  48.     private $entityManager;
  50.     public function __construct(
  51.         EventDispatcherInterface $dispatcher,
  52.         Mailer $mailer,
  53.         UrlGeneratorInterface $urlGenerator,
  54.         EntityManagerInterface $entityManager
  55.     ) {
  56.         $this->entityManager = $entityManager;
  57.         $this->dispatcher = $dispatcher;
  58.         $this->mailer = $mailer;
  59.         $this->urlGenerator = $urlGenerator;
  60.     }
  62.      /**
  63.      * @Route("/switch_language/{id}/{lang}", name="app_switch_language")
  64.      */
  65.      public function switch_language(User $request,$lang)
  66.      {    
  67.           if($lang == 1){
  68.                $lang='en';
  69.           }else{
  70.                $lang='fr';
  71.           }
  72.           // $user = $this->getUser();
  73.           $em = $this->getDoctrine()->getManager();
  74.           $request->setLang($lang);
  75.           $em->persist($request);
  76.           $em->flush();
  77.           if($lang == 'en'){
  78.                $this->addFlash('green', 'You have successfully change the language.');
  79.           }elseif($lang == 'fr'){
  80.                $this->addFlash('green', 'Vous avez réussi à changer la langue.');
  81.           }else{
  82.                $this->addFlash('green', 'You have successfully change the language.');
  83.           }
  84.           return $this->redirect($_SERVER['HTTP_REFERER']); 
  85.      }
  87.      /**
  88.      * @Route("/home", name="app_home")
  89.      */
  90.      public function index(): Response
  91.      {
  92.         
  93.           if ($this->getUser()) {
  94.              $client = $this->getUser();
  95.           } else {
  96.               return $this->redirectToRoute('user_login');
  97.           }
  98.           
  99.           $user = $this->getUser();
  100.           $type_user=$user->getType();
  101.           $allid=explode(",", $user->getRolebyadmin());
  102.           $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  103.           if($type_user == "SuperAdmin" || $type_user == "Client Admin"){
  104.                  $all_user= $this->getDoctrine()->getRepository('App\Entity\User')->findAllFieldUserCount();
  105.                  $all_user_count=count($all_user);
  107.                  $all_agent= $this->getDoctrine()->getRepository('App\Entity\User')->findAllFieldAgentCount();
  108.                  $all_agent_count=count($all_agent);
  110.                  $all_agent_group= $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findBy(array('status'=>true));
  111.                  $all_agent_group_count=count($all_agent_group);
  113.                  $all_product= $this->getDoctrine()->getRepository('App\Entity\Products')->findBy(array('status'=>true));
  114.                  $all_product_count=count($all_product);
  116.                  $all_pv_unpaid= $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(array('status'=>0));
  117.                  $all_pv_unpaid_count=count($all_pv_unpaid);
  118.                  
  119.                  $all_pv_paid= $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(array('status'=>1));
  120.                  $all_pv_paid_count=count($all_pv_paid);
  122.                 $paidamount = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(
  123.                     array('status'=>1),
  124.                     array('id'=>'desc'),
  125.                     );
  126.                 $paidamount_sum = 0;
  127.                 foreach ($paidamount as $key => $value) {
  128.                     $pv = $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id' => $value->getFine()));
  129.                     if ($pv) {
  130.                     $paidamount_sum += $pv->amount;
  131.                     } else {
  132.                     $paidamount_sum += 0;
  133.                     }
  134.                 }
  136.                 $unpaidamount = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(
  137.                     array('status'=>0),
  138.                     array('id'=>'desc'),
  139.                     );
  140.                 $unpaidamount_sum = 0;
  141.                 foreach ($unpaidamount as $key => $value) {
  142.                     $pv = $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id' => $value->getFine()));
  143.                     if ($pv) {
  144.                     $unpaidamount_sum += $pv->amount;
  145.                     } else {
  146.                     $unpaidamount_sum += 0;
  147.                     }
  148.                 }
  150.                  /*January start*/
  151.                  $Pending_jan = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  152.                      "0","1",date('Y')
  153.                  );
  154.                  $Pending_jan_count=count($Pending_jan);
  156.                  $assigned_jan = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  157.                       "1","1",date('Y')
  158.                  );
  159.                  $assigned_jan_count=count($assigned_jan); 
  161.                  $Resolved_jan = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  162.                       "2","1",date('Y')
  163.                  );
  164.                  $Resolved_jan_count=count($Resolved_jan); 
  165.                  /*January end*/
  166.                  /*February start*/
  167.                  $Pending_feb = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  168.                      "0","2",date('Y')
  169.                  );
  170.                  $Pending_feb_count=count($Pending_feb);
  172.                  $assigned_feb = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  173.                       "1","2",date('Y')
  174.                  );
  175.                  $assigned_feb_count=count($assigned_feb); 
  177.                  $Resolved_feb = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  178.                       "2","2",date('Y')
  179.                  );
  180.                  $Resolved_feb_count=count($Resolved_feb);
  181.                  /*February end*/
  182.                  /*March start*/
  183.                  $Pending_march = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  184.                      "0","3",date('Y')
  185.                  );
  186.                  $Pending_march_count=count($Pending_march);
  188.                  $assigned_march = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  189.                       "1","3",date('Y')
  190.                  );
  191.                  $assigned_march_count=count($assigned_march); 
  193.                  $Resolved_march = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  194.                       "2","3",date('Y')
  195.                  );
  196.                  $Resolved_march_count=count($Resolved_march);
  197.                  /*March end*/
  198.                  /*April start*/
  199.                  $Pending_april = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  200.                      "0","4",date('Y')
  201.                  );
  202.                  $Pending_april_count=count($Pending_april);
  204.                  $assigned_april = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  205.                       "1","4",date('Y')
  206.                  );
  207.                  $assigned_april_count=count($assigned_april); 
  209.                  $Resolved_april = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  210.                       "2","4",date('Y')
  211.                  );
  212.                  $Resolved_april_count=count($Resolved_april);
  213.                  /*April end*/
  214.                  /*May start*/
  215.                  $Pending_may = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  216.                      "0","5",date('Y')
  217.                  );
  218.                  $Pending_may_count=count($Pending_may);
  220.                  $assigned_may = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  221.                       "1","5",date('Y')
  222.                  );
  223.                  $assigned_may_count=count($assigned_may); 
  225.                  $Resolved_may = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  226.                       "2","5",date('Y')
  227.                  );
  228.                  $Resolved_may_count=count($Resolved_may);
  229.                  /*May end*/
  230.                  /*June start*/
  231.                  $Pending_june = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  232.                      "0","6",date('Y')
  233.                  );
  234.                  $Pending_june_count=count($Pending_june);
  236.                  $assigned_june = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  237.                       "1","6",date('Y')
  238.                  );
  239.                  $assigned_june_count=count($assigned_june); 
  241.                  $Resolved_june = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  242.                       "2","6",date('Y')
  243.                  );
  244.                  $Resolved_june_count=count($Resolved_june);
  245.                  /*June end*/
  246.                  /*July start*/
  247.                  $Pending_july = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  248.                      "0","7",date('Y')
  249.                  );
  250.                  $Pending_july_count=count($Pending_july);
  252.                  $assigned_july = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  253.                       "1","7",date('Y')
  254.                  );
  255.                  $assigned_july_count=count($assigned_july); 
  257.                  $Resolved_july = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  258.                       "2","7",date('Y')
  259.                  );
  260.                  $Resolved_july_count=count($Resolved_july);
  261.                  /*July end*/
  262.                  /*August start*/
  263.                  $Pending_aug = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  264.                      "0","8",date('Y')
  265.                  );
  266.                  $Pending_aug_count=count($Pending_aug);
  268.                  $assigned_aug = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  269.                       "1","8",date('Y')
  270.                  );
  271.                  $assigned_aug_count=count($assigned_aug); 
  273.                  $Resolved_aug = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  274.                       "2","8",date('Y')
  275.                  );
  276.                  $Resolved_aug_count=count($Resolved_aug);
  277.                  /*August end*/
  278.                  /*September start*/
  279.                  $Pending_sep = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  280.                      "0","9",date('Y')
  281.                  );
  282.                  $Pending_sep_count=count($Pending_sep);
  284.                  $assigned_sep = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  285.                       "1","9",date('Y')
  286.                  );
  287.                  $assigned_sep_count=count($assigned_sep); 
  289.                  $Resolved_sep = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  290.                       "2","9",date('Y')
  291.                  );
  292.                  $Resolved_sep_count=count($Resolved_sep);
  293.                  /*September end*/
  294.                  /*October start*/
  295.                  $Pending_oct = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  296.                      "0","10",date('Y')
  297.                  );
  298.                  $Pending_oct_count=count($Pending_oct);
  300.                  $assigned_oct = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  301.                       "1","10",date('Y')
  302.                  );
  303.                  $assigned_oct_count=count($assigned_oct); 
  305.                  $Resolved_oct = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  306.                       "2","10",date('Y')
  307.                  );
  308.                  $Resolved_oct_count=count($Resolved_oct);
  309.                  /*October end*/
  310.                  /*November start*/
  311.                  $Pending_nov = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  312.                      "0","11",date('Y')
  313.                  );
  314.                  $Pending_nov_count=count($Pending_nov);
  316.                  $assigned_nov = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  317.                       "1","11",date('Y')
  318.                  );
  319.                  $assigned_nov_count=count($assigned_nov); 
  321.                  $Resolved_nov = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  322.                       "2","11",date('Y')
  323.                  );
  324.                  $Resolved_nov_count=count($Resolved_nov);
  325.                  /*November end*/
  326.                  /*December start*/
  327.                  $Pending_dec = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  328.                      "0","12",date('Y')
  329.                  );
  330.                  $Pending_dec_count=count($Pending_dec);
  332.                  $assigned_dec = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  333.                       "1","12",date('Y')
  334.                  );
  335.                  $assigned_dec_count=count($assigned_dec); 
  337.                  $Resolved_dec = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYearDashboard(
  338.                       "2","12",date('Y')
  339.                  );
  340.                  $Resolved_dec_count=count($Resolved_dec);
  341.                  /*December end*/
  342.                  $all_pending=[$Pending_jan_count,$Pending_feb_count,$Pending_march_count,$Pending_april_count,$Pending_may_count,$Pending_june_count,$Pending_july_count,$Pending_aug_count,$Pending_sep_count,$Pending_oct_count,$Pending_nov_count,$Pending_dec_count];
  343.                  $allnew_complaint_count=implode(',', $all_pending);
  345.                  $all_assigned=[$assigned_jan_count,$assigned_feb_count,$assigned_march_count,$assigned_april_count,$assigned_may_count,$assigned_june_count,$assigned_july_count,$assigned_aug_count,$assigned_sep_count,$assigned_oct_count,$assigned_nov_count,$assigned_dec_count];
  346.                  $all_process_complaint_count=implode(',', $all_assigned);
  348.                  $all_resolved=[$Resolved_jan_count,$Resolved_feb_count,$Resolved_march_count,$Resolved_april_count,$Resolved_may_count,$Resolved_june_count,$Resolved_july_count,$Resolved_aug_count,$Resolved_sep_count,$Resolved_oct_count,$Resolved_nov_count,$Resolved_dec_count];
  349.                  $all_resolved_complaint_count=implode(',', $all_resolved);
  350.                  
  352.           }elseif($type_user == "Supervisor" || $type_user == "Hypervisor" || $type_user =="Operational Manager" || $type_user =="Financial Manager"){
  353.                  $all_user= $this->getDoctrine()->getRepository('App\Entity\User')->findAllFieldUserCount();
  354.                  $all_user_count=count($all_user);
  356.                  $all_agent= $this->getDoctrine()->getRepository('App\Entity\User')->findAllFieldAgentCount();
  357.                  $all_agent_count=count($all_agent);
  359.                  $all_agent_group= $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findBy(array('status'=>true,'city_id'=>$user->getCityId()));
  360.                  $all_agent_group_count=count($all_agent_group);
  362.                  $all_product= $this->getDoctrine()->getRepository('App\Entity\Products')->findBy(array('status'=>true));
  363.                  $all_product_count=count($all_product);
  365.                  $all_pv_unpaid= $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(array('status'=>0,'city'=>$user->getCityId()));
  366.                  $all_pv_unpaid_count=count($all_pv_unpaid);
  367.                  
  368.                  $all_pv_paid= $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(array('status'=>1,'city'=>$user->getCityId()));
  369.                  $all_pv_paid_count=count($all_pv_paid);
  371.                  $paidamount = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(
  372.                     array('status'=>1,'city'=>$user->getCityId()),
  373.                     array('id'=>'desc'),
  374.                     );
  375.                 $paidamount_sum = 0;
  376.                 foreach ($paidamount as $key => $value) {
  377.                     $pv = $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id' => $value->getFine()));
  378.                     if ($pv) {
  379.                     $paidamount_sum += $pv->amount;
  380.                     } else {
  381.                     $paidamount_sum += 0;
  382.                     }
  383.                 }
  385.                 $unpaidamount = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(
  386.                     array('status'=>0,'city'=>$user->getCityId()),
  387.                     array('id'=>'desc'),
  388.                     );
  389.                 $unpaidamount_sum = 0;
  390.                 foreach ($unpaidamount as $key => $value) {
  391.                     $pv = $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id' => $value->getFine()));
  392.                     if ($pv) {
  393.                     $unpaidamount_sum += $pv->amount;
  394.                     } else {
  395.                     $unpaidamount_sum += 0;
  396.                     }
  397.                 }
  399.                  /*January start*/
  400.                  $Pending_jan = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  401.                      "0",$user->getCityId(),"1",date('Y')
  402.                  );
  403.                  $Pending_jan_count=count($Pending_jan);
  405.                  $assigned_jan = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  406.                       "1",$user->getCityId(),"1",date('Y')
  407.                  );
  408.                  $assigned_jan_count=count($assigned_jan); 
  410.                  $Resolved_jan = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  411.                       "2",$user->getCityId(),"1",date('Y')
  412.                  );
  413.                  $Resolved_jan_count=count($Resolved_jan); 
  414.                  /*January end*/
  415.                  /*February start*/
  416.                  $Pending_feb = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  417.                      "0",$user->getCityId(),"2",date('Y')
  418.                  );
  419.                  $Pending_feb_count=count($Pending_feb);
  421.                  $assigned_feb = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  422.                       "1",$user->getCityId(),"2",date('Y')
  423.                  );
  424.                  $assigned_feb_count=count($assigned_feb); 
  426.                  $Resolved_feb = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  427.                       "2",$user->getCityId(),"2",date('Y')
  428.                  );
  429.                  $Resolved_feb_count=count($Resolved_feb);
  430.                  /*February end*/
  431.                  /*March start*/
  432.                  $Pending_march = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  433.                      "0",$user->getCityId(),"3",date('Y')
  434.                  );
  435.                  $Pending_march_count=count($Pending_march);
  437.                  $assigned_march = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  438.                       "1",$user->getCityId(),"3",date('Y')
  439.                  );
  440.                  $assigned_march_count=count($assigned_march); 
  442.                  $Resolved_march = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  443.                       "2",$user->getCityId(),"3",date('Y')
  444.                  );
  445.                  $Resolved_march_count=count($Resolved_march);
  446.                  /*March end*/
  447.                  /*April start*/
  448.                  $Pending_april = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  449.                      "0",$user->getCityId(),"4",date('Y')
  450.                  );
  451.                  $Pending_april_count=count($Pending_april);
  453.                  $assigned_april = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  454.                       "1",$user->getCityId(),"4",date('Y')
  455.                  );
  456.                  $assigned_april_count=count($assigned_april); 
  458.                  $Resolved_april = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  459.                       "2",$user->getCityId(),"4",date('Y')
  460.                  );
  461.                  $Resolved_april_count=count($Resolved_april);
  462.                  /*April end*/
  463.                  /*May start*/
  464.                  $Pending_may = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  465.                      "0",$user->getCityId(),"5",date('Y')
  466.                  );
  467.                  $Pending_may_count=count($Pending_may);
  469.                  $assigned_may = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  470.                       "1",$user->getCityId(),"5",date('Y')
  471.                  );
  472.                  $assigned_may_count=count($assigned_may); 
  474.                  $Resolved_may = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  475.                       "2",$user->getCityId(),"5",date('Y')
  476.                  );
  477.                  $Resolved_may_count=count($Resolved_may);
  478.                  /*May end*/
  479.                  /*June start*/
  480.                  $Pending_june = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  481.                      "0",$user->getCityId(),"6",date('Y')
  482.                  );
  483.                  $Pending_june_count=count($Pending_june);
  485.                  $assigned_june = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  486.                       "1",$user->getCityId(),"6",date('Y')
  487.                  );
  488.                  $assigned_june_count=count($assigned_june); 
  490.                  $Resolved_june = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  491.                       "2",$user->getCityId(),"6",date('Y')
  492.                  );
  493.                  $Resolved_june_count=count($Resolved_june);
  494.                  /*June end*/
  495.                  /*July start*/
  496.                  $Pending_july = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  497.                      "0",$user->getCityId(),"7",date('Y')
  498.                  );
  499.                  $Pending_july_count=count($Pending_july);
  501.                  $assigned_july = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  502.                       "1",$user->getCityId(),"7",date('Y')
  503.                  );
  504.                  $assigned_july_count=count($assigned_july); 
  506.                  $Resolved_july = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  507.                       "2",$user->getCityId(),"7",date('Y')
  508.                  );
  509.                  $Resolved_july_count=count($Resolved_july);
  510.                  /*July end*/
  511.                  /*August start*/
  512.                  $Pending_aug = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  513.                      "0",$user->getCityId(),"8",date('Y')
  514.                  );
  515.                  $Pending_aug_count=count($Pending_aug);
  517.                  $assigned_aug = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  518.                       "1",$user->getCityId(),"8",date('Y')
  519.                  );
  520.                  $assigned_aug_count=count($assigned_aug); 
  522.                  $Resolved_aug = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  523.                       "2",$user->getCityId(),"8",date('Y')
  524.                  );
  525.                  $Resolved_aug_count=count($Resolved_aug);
  526.                  /*August end*/
  527.                  /*September start*/
  528.                  $Pending_sep = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  529.                      "0",$user->getCityId(),"9",date('Y')
  530.                  );
  531.                  $Pending_sep_count=count($Pending_sep);
  533.                  $assigned_sep = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  534.                       "1",$user->getCityId(),"9",date('Y')
  535.                  );
  536.                  $assigned_sep_count=count($assigned_sep); 
  538.                  $Resolved_sep = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  539.                       "2",$user->getCityId(),"9",date('Y')
  540.                  );
  541.                  $Resolved_sep_count=count($Resolved_sep);
  542.                  /*September end*/
  543.                  /*October start*/
  544.                  $Pending_oct = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  545.                      "0",$user->getCityId(),"10",date('Y')
  546.                  );
  547.                  $Pending_oct_count=count($Pending_oct);
  549.                  $assigned_oct = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  550.                       "1",$user->getCityId(),"10",date('Y')
  551.                  );
  552.                  $assigned_oct_count=count($assigned_oct); 
  554.                  $Resolved_oct = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  555.                       "2",$user->getCityId(),"10",date('Y')
  556.                  );
  557.                  $Resolved_oct_count=count($Resolved_oct);
  558.                  /*October end*/
  559.                  /*November start*/
  560.                  $Pending_nov = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  561.                      "0",$user->getCityId(),"11",date('Y')
  562.                  );
  563.                  $Pending_nov_count=count($Pending_nov);
  565.                  $assigned_nov = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  566.                       "1",$user->getCityId(),"11",date('Y')
  567.                  );
  568.                  $assigned_nov_count=count($assigned_nov); 
  570.                  $Resolved_nov = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  571.                       "2",$user->getCityId(),"11",date('Y')
  572.                  );
  573.                  $Resolved_nov_count=count($Resolved_nov);
  574.                  /*November end*/
  575.                  /*December start*/
  576.                  $Pending_dec = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  577.                      "0",$user->getCityId(),"12",date('Y')
  578.                  );
  579.                  $Pending_dec_count=count($Pending_dec);
  581.                  $assigned_dec = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  582.                       "1",$user->getCityId(),"12",date('Y')
  583.                  );
  584.                  $assigned_dec_count=count($assigned_dec); 
  586.                  $Resolved_dec = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  587.                       "2",$user->getCityId(),"12",date('Y')
  588.                  );
  589.                  $Resolved_dec_count=count($Resolved_dec);
  590.                  /*December end*/
  591.                  $all_pending=[$Pending_jan_count,$Pending_feb_count,$Pending_march_count,$Pending_april_count,$Pending_may_count,$Pending_june_count,$Pending_july_count,$Pending_aug_count,$Pending_sep_count,$Pending_oct_count,$Pending_nov_count,$Pending_dec_count];
  592.                  $allnew_complaint_count=implode(',', $all_pending);
  593.                  // $allnew_complaint_count="1000, 2000, 3000, 2500, 2700, 2500, 3000,1000, 2000, 3000, 2500,130";
  595.                  $all_assigned=[$assigned_jan_count,$assigned_feb_count,$assigned_march_count,$assigned_april_count,$assigned_may_count,$assigned_june_count,$assigned_july_count,$assigned_aug_count,$assigned_sep_count,$assigned_oct_count,$assigned_nov_count,$assigned_dec_count];
  596.                  $all_process_complaint_count=implode(',', $all_assigned);
  597.                  // $all_process_complaint_count="600, 3000, 1000, 500, 700, 5500, 3000,1000, 2000, 3000, 2500,130";
  599.                  $all_resolved=[$Resolved_jan_count,$Resolved_feb_count,$Resolved_march_count,$Resolved_april_count,$Resolved_may_count,$Resolved_june_count,$Resolved_july_count,$Resolved_aug_count,$Resolved_sep_count,$Resolved_oct_count,$Resolved_nov_count,$Resolved_dec_count];
  600.                  $all_resolved_complaint_count=implode(',', $all_resolved);
  601.                  // $all_resolved_complaint_count="100, 200, 4000, 250, 270, 250, 300,100, 200, 300, 250,1300";
  602.           }else{
  603.             $all_user_count='0';
  604.             $all_agent_count='0';
  605.             $all_agent_group_count='0';
  606.             $all_product_count='0';
  607.             $all_pv_unpaid_count='0';
  608.             $all_pv_paid_count='0';
  609.             $allnew_complaint_count='0';
  610.             $all_process_complaint_count='0';
  611.             $all_resolved_complaint_count='0';
  612.             $unpaidamount_sum = '0';
  613.             $paidamount_sum = '0';
  615.           }
  617.           return $this->render('home/index.html.twig', [
  618.             'controller_name' => 'HomeController',
  619.             'user'=>$user,
  620.             'type_user'=>$type_user,
  621.             'roles_client'=>$roles_client,
  622.             'all_user_count'=>$all_user_count,
  623.             'all_agent_count'=>$all_agent_count,
  624.             'all_agent_group_count'=>$all_agent_group_count,
  625.             'all_product_count'=>$all_product_count,
  626.             'all_pv_paid_count'=>$all_pv_paid_count,
  627.             'all_pv_unpaid_count'=>$all_pv_unpaid_count,
  628.             'allnew_complaint_count'=>$allnew_complaint_count,
  629.             'all_process_complaint_count'=>$all_process_complaint_count,
  630.             'all_resolved_complaint_count'=>$all_resolved_complaint_count, 
  631.             'unpaidamount_sum' =>$unpaidamount_sum,
  632.             'paidamount_sum'=>$paidamount_sum
  633.           ]);
  634.      }
  636.      /**
  637.      * @Route("/profile", name="app_profile")
  638.      */
  639.      public function profile(Request $request, UserPasswordEncoderInterface $passwordEncoder)
  640.      {
  641.         
  642.           if ($this->getUser()) {
  643.                $client = $this->getUser();
  644.           } else {
  645.                return $this->redirectToRoute('user_login');
  646.           }
  648.           $em = $this->getDoctrine()->getManager();
  649.         
  650.              if ($request->getMethod() === "POST") {
  651.                  
  652.                  // Change password 
  653.                  if ($request->request->get('newpassword')) {
  654.                      $user = $this->getUser();
  655.                      // print_r($request->request->all());die;
  656.                      $old_pwd = $request->request->get('oldpassword');
  657.                      $newPassword = $request->get('newpassword');
  658.                      $new_pwd_confirm = $request->get('pass_confirm');
  659.                      
  660.                      
  661.                      $checkPass = $passwordEncoder->isPasswordValid($user, $old_pwd);
  663.                      if ($checkPass === true) {
  664.                          
  665.                          if($newPassword === $new_pwd_confirm){
  666.                              $newEncodedPassword = $passwordEncoder->encodePassword($user, $newPassword);
  667.                              
  668.                              $user->setPassword($newEncodedPassword);
  669.                              $em->persist($user);
  670.                              $em->flush();
  671.                              if($client->getLang() == 'en'){
  672.                                 $this->addFlash('green', 'Password change successfully..!!');
  673.                              }else{
  674.                                 $this->addFlash('green', 'Changement de mot de passe réussi..!');
  675.                              }
  676.                          }else{
  677.                               if($client->getLang() == 'en'){
  678.                                  $this->addFlash('red', 'Password not matching..!!');
  679.                               }else{
  680.                                  $this->addFlash('red', 'Le mot de passe ne correspond pas..!!');
  681.                               }
  682.                          }
  683.                      } else {
  684.                          if($client->getLang() == 'en'){
  685.                             $this->addFlash('red', 'Old password is incorrect..!!');
  686.                          }else{
  687.                             $this->addFlash('red', "L'ancien mot de passe est incorrect..!!");
  688.                          }
  689.                      }
  690.                  }
  692.                  
  693.              }
  694.         $user = $this->getUser();
  695.         $type_user=$user->getType();
  696.         $allid=explode(",", $user->getRolebyadmin());
  697.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  698.         return $this->render('home/profile.html.twig', 
  699.             array(
  700.                 // 'form'=>$form->createView(),
  701.                 'client' => $client,
  702.                 'type_user'=>$type_user,
  703.                 'roles_client'=>$roles_client,
  704.                 'implode_pending'=>'',
  705.                 'implode_assigned'=>'',
  706.                 'implode_resolved'=>'',  
  707.                 )
  708.         );
  710.     }
  712.     /**
  713.      * @Route("/update-profile", name="app_update_profile")
  714.      */
  715.     public function update_profile(Request $request )
  716.     {
  717.           if($this->getUser()){
  718.                $client = $this->getUser();
  719.           }else{
  720.                return $this->redirectToRoute('user_login');
  721.           }
  722.              $user = $this->getUser();
  723.              $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBySomeField(array('value'=>$user->getId()),array('email'=>$request->request->get('email')));
  724.           if (empty($result)) {
  726.             $em = $this->getDoctrine()->getManager();
  727.             
  728.             if ($request->getMethod() === "POST") {
  729.                 
  730.                 $user = $this->getUser();
  731.                 $name = $request->request->get('name');
  732.                 $email = $request->get('email');
  733.                 $mobile = $request->get('mobile');
  734.                 $user->setName($name);
  735.                 $user->setEmail($email);
  736.                 $user->setMobile($mobile);
  737.                 $em->persist($user);
  738.                 $em->flush();
  740.                if($client->getLang() == 'en'){
  741.                   $this->addFlash('green', 'Profile updated successfully..!!');
  742.                }else{
  743.                   $this->addFlash('green', 'Profil mis à jour avec succès..!!');
  744.                }
  745.                 
  746.             }
  747.           }else{
  748.                if($client->getLang() == 'en'){
  749.                   $this->addFlash('red', 'There is already an account with this email');
  750.                }else{
  751.                   $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  752.                }
  753.           }
  755.         return $this->redirectToRoute('app_profile');
  757.     }
  759.     
  760.      /**
  761.      * @Route("/manage-pv-detail", name="app_pv_detail")
  762.      */
  763.     public function manage_pv_detail()
  764.     {
  765.         if ($this->getUser()) {
  766.             $client = $this->getUser();
  767.         } else {
  768.             return $this->redirectToRoute('user_login');
  769.         }
  770.         
  771.         $user = $this->getUser();
  772.         $type_user=$user->getType();
  773.         $allid=explode(",", $user->getRolebyadmin());
  774.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  775.         if($type_user == "SuperAdmin" || $type_user == "Client Admin"){
  776.             $datas = $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findBy(array(),array('id'=>'desc'));
  777.             $page='home/manage_pv_detail.html.twig';
  778.         }else{
  779.             $page='security/pagenotfound.html.twig';
  780.             $datas = "";
  781.         }
  782.         return $this->render($page, 
  783.             array(
  784.                 'client' => $client,
  785.                 'datas'=>$datas,
  786.                 'type_user'=>$type_user,
  787.                 'roles_client'=>$roles_client,
  788.                 'implode_pending'=>'',
  789.                 'implode_assigned'=>'',
  790.                 'implode_resolved'=>'',  
  791.             )
  792.         );
  793.     }
  796.     /**
  797.      * @Route("/request-pv-detail", name="app_create_pv_detail")
  798.      */
  799.     public function create_pv_detail(Request $request)
  800.     {
  802.         if ($this->getUser()) {
  803.             $client = $this->getUser();
  804.         } else {
  805.             return $this->redirectToRoute('user_login');
  806.         }
  808.         $user = $this->getUser();
  809.         $user_id=$user->getId();
  810.        
  811.         $em = $this->getDoctrine()->getManager();
  812.         if ($request->getMethod() === "POST") {
  814.             if($request->request->get('table_id') !=""){
  815.                 $updateRequest = $this->getDoctrine()->getRepository('App\Entity\PvDetails')
  816.                 ->find($request->request->get('table_id'));
  817.                 $updateRequest->setAmount($request->request->get('amount'));
  818.                 $updateRequest->setFineFor($request->request->get('finefor'));
  819.                 $em = $this->getDoctrine()->getManager();
  820.                 $em->persist($updateRequest);
  821.                 $em->flush();
  822.                 if($client->getLang() == 'en'){
  823.                   $this->addFlash('green', 'Pv detail update successfully..!!');
  824.                }else{
  825.                   $this->addFlash('green', 'Mise à jour des détails du Pv avec succès..!!');
  826.                }
  827.                  
  828.             }else{
  829.                 // print_r($request->request->all());die;
  830.                 $addRequest = new PvDetails;
  831.                 $addRequest->setAmount($request->request->get('amount'));
  832.                 $addRequest->setFineFor($request->request->get('finefor'));
  833.                 $addRequest->setStatus('1');
  834.                 $em = $this->getDoctrine()->getManager();
  835.                 $em->persist($addRequest);
  836.                 $em->flush();
  837.                 if($client->getLang() == 'en'){
  838.                   $this->addFlash('green', 'Pv detail added successfully..!!');
  839.                }else{
  840.                   $this->addFlash('green', 'Détail Pv ajouté avec succès..!!');
  841.                }
  842.                  
  843.             }
  844.         }
  845.         return $this->redirectToRoute('app_pv_detail');
  846.     }
  848.     /**
  849.      * @Route("/request-pv-detail-delete/{id}", name="app_pv_detail_delete")
  850.      */
  851.     public function pv_detail_delete(PvDetails $request,$id)
  852.     {
  853.         $em = $this->getDoctrine()->getManager();
  854.         $request->getId($id);
  855.         $em->remove($request);
  856.         $em->flush();
  857.           if($client->getLang() == 'en'){
  858.              $this->addFlash('green','Pv detail deleted successfully..!!');
  859.           }else{
  860.              $this->addFlash('green','Pv detail deleted successfully..!!');
  861.           }
  863.         return $this->redirectToRoute('app_pv_detail');
  864.     }
  866.     /**
  867.      * @Route("/update-pv-detail-status/{id}/{status}", name="update_pv_detail_status")
  868.      */
  869.     public function updatepvdetailstatus(PvDetails $request,$status)
  870.     {
  871.           if ($this->getUser()) {
  872.             $client = $this->getUser();
  873.           } else {
  874.             return $this->redirectToRoute('user_login');
  875.           }
  876.         $em = $this->getDoctrine()->getManager();
  877.         $request->setStatus($status);
  878.         $em->persist($request);
  879.         $em->flush();
  880.         if($status == 1){
  881.           if($client->getLang() == 'en'){
  882.              $this->addFlash('green', 'You have enable the pv detail');
  883.           }else{
  884.              $this->addFlash('green', 'Vous avez activé le détail pv');
  885.           }     
  886.             
  887.         }else{
  888.           if($client->getLang() == 'en'){
  889.              $this->addFlash('red', 'You have disable the pv detail');
  890.           }else{
  891.              $this->addFlash('red', 'Vous avez désactivé les détails de la P.V.');
  892.           }
  893.             
  894.         }
  895.         return $this->redirectToRoute('app_pv_detail');
  896.     }
  897.     
  898.      /**
  899.      * @Route("/manage-products", name="app_manage_product")
  900.      */
  901.     public function manage_product()
  902.     {
  903.         if ($this->getUser()) {
  904.             $client = $this->getUser();
  905.         } else {
  906.             return $this->redirectToRoute('user_login');
  907.         }
  908.         
  909.         $user = $this->getUser();
  910.         $type_user=$user->getType();
  911.         $allid=explode(",", $user->getRolebyadmin());
  912.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  913.         if($type_user == "SuperAdmin" || $type_user == "Client Admin"){
  914.             $datas = $this->getDoctrine()->getRepository('App\Entity\Products')->findBy(array(),array('id'=>'desc'));
  915.             $categorie = $this->getDoctrine()->getRepository(Categorie::class)->findBy(array(),array('id'=>'desc'));
  916.             $subcategorie = $this->getDoctrine()->getRepository(Subcategorie::class)->findBy(array('status'=>'1'));
  917.             $page='home/manage_product.html.twig';
  918.         }else{
  919.             $page='security/pagenotfound.html.twig';
  920.             $datas = "";
  921.             $categorie ="";
  922.             $subcategorie ="";
  923.         }
  924.         return $this->render($page, 
  925.             array(
  926.                 'client' => $client,
  927.                 'datas'=>$datas,
  928.                 'category'=>$categorie,
  929.                 'subcategory'=>$subcategorie,
  930.                 'type_user'=>$type_user,
  931.                 'roles_client'=>$roles_client,
  932.                 'implode_pending'=>'',
  933.                 'implode_assigned'=>'',
  934.                 'implode_resolved'=>'',  
  935.             )
  936.         );
  937.     }
  938.     
  939.     
  940.     /**
  941.      * @Route("/create_product", name="app_create_product")
  942.      */
  943.     public function create_manage_product(Request $request,string $uploadDir,FileUploader $uploader)
  944.     {
  945.         if ($this->getUser()) {
  946.             $client = $this->getUser();
  947.         } else {
  948.             return $this->redirectToRoute('user_login');
  949.         }
  951.         $user = $this->getUser();
  952.         $user_id=$user->getId();
  953.        
  954.         $em = $this->getDoctrine()->getManager();
  955.         if ($request->getMethod() === "POST") {
  957.             $categorie = $this->getDoctrine()->getRepository(Categorie::class)->findOneBy(array('id' => $request->request->get('categoryid')));
  958.             $subcategorie = $this->getDoctrine()->getRepository(Subcategorie::class)->findOneBy(array('id' => $request->request->get('subcategoryid')));
  960.             if($request->request->get('table_id') !=""){
  961.                 $file = $request->files->get('image');
  962.                 if (!empty($file))
  963.                 {
  964.                     $filename = $file->getClientOriginalName();
  965.                     $uploader->upload($uploadDir, $file, $filename);
  966.                 }else{
  967.                     $filename = $request->request->get('oldimage');
  968.                 } 
  969.                 $d=$request->request->get('description');
  970.                 if (!empty($d))
  971.                 {
  972.                     $description=$request->request->get('description');
  973.                 }else{
  974.                     $description=$request->request->get('olddescription');
  975.                 }
  977.                 $updateRequest =  $this->getDoctrine()->getRepository('App\Entity\Products')
  978.                 ->find($request->request->get('table_id'));
  979.                 $updateRequest->setProductname($request->request->get('name'));
  980.                 $updateRequest->setCategory($categorie);
  981.                 $updateRequest->setSubcategory($subcategorie);
  982.                 $updateRequest->setDescription($description);
  983.                 $updateRequest->setRetailprice($request->request->get('retailprice'));
  984.                 $updateRequest->setWholesaleprice($request->request->get('wholesaleprice'));
  985.                 $updateRequest->setSemiretailprice($request->request->get('semiretailprice'));
  986.                 $updateRequest->setImage($filename);
  987.                 $updateRequest->setStatus('1');
  988.                 $em = $this->getDoctrine()->getManager();
  989.                 $em->persist($updateRequest);
  990.                 $em->flush();
  991.                 if($client->getLang() == 'en'){
  992.                   $this->addFlash('green', 'Product update successfully..!!'); 
  993.                }else{
  994.                   $this->addFlash('green', 'Mise à jour du produit réussie..!!'); 
  995.                }
  996.             }else{
  997.                 $file = $request->files->get('image');
  998.                 if (!empty($file))
  999.                 {
  1000.                     $filename = $file->getClientOriginalName();
  1001.                     $uploader->upload($uploadDir, $file, $filename);
  1002.                 }else{
  1003.                     $filename=null;
  1004.                 }
  1006.                 $addRequest = new Products;
  1007.                 $addRequest->setProductname($request->request->get('name'));
  1008.                 $addRequest->setCategory($categorie);
  1009.                 $addRequest->setSubcategory($subcategorie);
  1010.                 $addRequest->setDescription($request->request->get('description'));
  1011.                 $addRequest->setRetailprice($request->request->get('retailprice'));
  1012.                 $addRequest->setWholesaleprice($request->request->get('wholesaleprice'));
  1013.                 $addRequest->setSemiretailprice($request->request->get('semiretailprice'));
  1014.                 $addRequest->setImage($filename);
  1015.                 $addRequest->setStatus('1');
  1016.                 $em = $this->getDoctrine()->getManager();
  1017.                 $em->persist($addRequest);
  1018.                 $em->flush();
  1019.                 if($client->getLang() == 'en'){
  1020.                   $this->addFlash('green', 'Product added successfully..!!');  
  1021.                }else{
  1022.                   $this->addFlash('green', 'Produit ajouté avec succès..!!'); 
  1023.                }
  1024.             }
  1025.         }
  1026.         return $this->redirectToRoute('app_manage_product');
  1027.     }
  1029.     /**
  1030.      * @Route("/upload-excel", name="xlsx")
  1031.      * @param Request $request
  1032.      */
  1033.     public function xslx(Request $request)
  1034.     {
  1035.         if ($this->getUser()) {
  1036.             $client = $this->getUser();
  1037.         } else {
  1038.             return $this->redirectToRoute('user_login');
  1039.         }
  1040.        $file = $request->files->get('file'); // get the file from the sent request
  1041.        $categorie = $this->getDoctrine()->getRepository(Categorie::class)->findOneBy(array('id' => $request->request->get('categoryid')));
  1042.         $subcategorie = $this->getDoctrine()->getRepository(Subcategorie::class)->findOneBy(array('id' => $request->request->get('subcategoryid')));
  1044.        $fileFolder = __DIR__ . '/../../public/images/';  //choose the folder in which the uploaded file will be stored
  1045.       
  1046.        $filePathName = md5(uniqid()) . $file->getClientOriginalName();
  1047.           // apply md5 function to generate an unique identifier for the file and concat it with the file extension  
  1048.                 try {
  1049.                     $file->move($fileFolder, $filePathName);
  1050.                 } catch (FileException $e) {
  1051.                     dd($e);
  1052.                 }
  1053.          // Open the file
  1054.         if (($handle = fopen($fileFolder.$filePathName, "r")) !== false) {
  1055.             // dd($handle);
  1056.             $num = 1;
  1057.             while (($data = fgetcsv($handle)) !== false) {
  1058.                 // Do the processing: Map line to entity, validate if needed
  1059.                 $entityManager = $this->getDoctrine()->getManager(); 
  1060.                 if( $num > 1 ){
  1061.                     if(count($data) == 6){
  1062.                 // dd($data['1']);
  1063.                         if(!empty($data['1'])){
  1064.                             if(!empty($data['2'])){
  1065.                                 if(is_numeric($data['3']) !== false){
  1066.                                     if(is_numeric($data['4']) !== false){
  1067.                                         if(is_numeric($data['5']) !== false){
  1068.                                             if(!empty($data['6'])){
  1069.                                                 $name = $data['1']; // store the first_name on each iteration 
  1070.                                                 $description = $data['2'];   // store the phone on each iteration
  1071.                                                 $retailprice = $data['3'];
  1072.                                                 $wholesaleprice = $data['4'];
  1073.                                                 $semiretailprice = $data['5'];
  1074.                                                 $image = $data['6'];
  1075.                                                 // dd($retailprice);
  1076.                                                 $addRequest = new Products;
  1077.                                                 $addRequest->setProductname($name);
  1078.                                                 $addRequest->setCategory($categorie);
  1079.                                                 $addRequest->setSubcategory($subcategorie);
  1080.                                                 $addRequest->setDescription($description);
  1081.                                                 $addRequest->setRetailprice($retailprice);
  1082.                                                 $addRequest->setWholesaleprice($wholesaleprice);
  1083.                                                 $addRequest->setSemiretailprice($semiretailprice);
  1084.                                                 $addRequest->setImage($image);
  1085.                                                 $addRequest->setStatus('1');
  1086.                                                 $em = $this->getDoctrine()->getManager();
  1087.                                                 $em->persist($addRequest);
  1088.                                                 $em->flush();
  1089.                                                 
  1090.                                              
  1091.                                             }else{
  1092.                                                 if($client->getLang() == 'en'){
  1093.                                                      $this->addFlash('red', 'Something went wrong.Please download the sample file and try again.'); 
  1094.                                                 }else{
  1095.                                                      $this->addFlash('red', "Quelque chose s'est mal passé. Veuillez télécharger le fichier d'exemple et réessayer."); 
  1096.                                                 }  
  1097.                                                 return $this->redirectToRoute('app_manage_product');
  1098.                                             }
  1099.                                         }else{
  1100.                                             if($client->getLang() == 'en'){
  1101.                                                 $this->addFlash('red', 'Something went wrong.Please download the sample file and try again.'); 
  1102.                                              }else{
  1103.                                                 $this->addFlash('red', "Quelque chose s'est mal passé. Veuillez télécharger le fichier d'exemple et réessayer."); 
  1104.                                              } 
  1105.                                             return $this->redirectToRoute('app_manage_product');    
  1106.                                         }   
  1107.                                     }else{
  1108.                                         if($client->getLang() == 'en'){
  1109.                                            $this->addFlash('red', 'Something went wrong.Please download the sample file and try again.'); 
  1110.                                         }else{
  1111.                                            $this->addFlash('red', "Quelque chose s'est mal passé. Veuillez télécharger le fichier d'exemple et réessayer."); 
  1112.                                         }  
  1113.                                         return $this->redirectToRoute('app_manage_product');
  1114.                                     }
  1115.                                 }else{
  1116.                                     if($client->getLang() == 'en'){
  1117.                                            $this->addFlash('red', 'Something went wrong.Please download the sample file and try again.'); 
  1118.                                         }else{
  1119.                                            $this->addFlash('red', "Quelque chose s'est mal passé. Veuillez télécharger le fichier d'exemple et réessayer."); 
  1120.                                         } 
  1121.                                     return $this->redirectToRoute('app_manage_product');        
  1122.                                 }   
  1123.                             }else{
  1124.                                 if($client->getLang() == 'en'){
  1125.                                       $this->addFlash('red', 'Something went wrong.Please download the sample file and try again.'); 
  1126.                                    }else{
  1127.                                       $this->addFlash('red', "Quelque chose s'est mal passé. Veuillez télécharger le fichier d'exemple et réessayer."); 
  1128.                                    }
  1129.                                 return $this->redirectToRoute('app_manage_product');             
  1130.                             }
  1131.                         }else{
  1132.                             if($client->getLang() == 'en'){
  1133.                                  $this->addFlash('red', 'Something went wrong.Please download the sample file and try again.'); 
  1134.                               }else{
  1135.                                  $this->addFlash('red', "Quelque chose s'est mal passé. Veuillez télécharger le fichier d'exemple et réessayer."); 
  1136.                               } 
  1137.                             return $this->redirectToRoute('app_manage_product');                    
  1138.                         }
  1139.                     }else{
  1140.                        if($client->getLang() == 'en'){
  1141.                           $this->addFlash('red', 'Something went wrong.Please download the sample file and try again.'); 
  1142.                        }else{
  1143.                           $this->addFlash('red', "Quelque chose s'est mal passé. Veuillez télécharger le fichier d'exemple et réessayer."); 
  1144.                       }
  1145.                        return $this->redirectToRoute('app_manage_product');                    
  1146.                     }
  1147.                 }
  1148.                 $num++;
  1149.             }
  1150.             fclose($handle);
  1151.             if($client->getLang() == 'en'){
  1152.                 $this->addFlash('green', 'Product uploaded successfully.');
  1153.              }else{
  1154.                 $this->addFlash('green', 'Produit téléchargé avec succès.'); 
  1155.             }
  1156.             
  1157.         }else{
  1158.             if($client->getLang() == 'en'){
  1159.                 $this->addFlash('red', 'Something went wrong.Please download the sample file and try again.'); 
  1160.              }else{
  1161.                 $this->addFlash('red', "Quelque chose s'est mal passé. Veuillez télécharger le fichier d'exemple et réessayer."); 
  1162.             }
  1163.             return $this->redirectToRoute('app_manage_product');                    
  1164.         }
  1165.         return $this->redirectToRoute('app_manage_product');
  1166.     }
  1168.     /**
  1169.      * @Route("/upload-all-product-image", name="app_product_image_upload")
  1170.      */
  1171.     public function product_image_upload(Request $request,string $uploadDir,FileUploader $uploader)
  1172.     {
  1173.         if ($this->getUser()) {
  1174.             $client = $this->getUser();
  1175.         } else {
  1176.             return $this->redirectToRoute('user_login');
  1177.         }
  1178.         $files = $request->files->get('image');
  1179.         if(!empty($files)){
  1180.             $imgs=array();
  1181.             $i=1;
  1182.             foreach ($files as $key => $file) {
  1183.                 // code...
  1184.                 if (!empty($file))
  1185.                 {   
  1186.                     $dirimg = $this->getDoctrine()->getRepository('App\Entity\Products')->findOneBy(array('image'=>$file->getClientOriginalName()));
  1187.                     if(!empty($dirimg))
  1188.                     {
  1189.                         // unlink($uploadDir."/".($file->getClientOriginalName()));
  1190.                         // dd($dirimg);
  1191.                         // exit;
  1192.                     }
  1193.                     $filename = $file->getClientOriginalName();
  1194.                     $uploader->upload($uploadDir, $file, $filename);
  1195.                 }else{
  1196.                     $filename = null;
  1197.                 } 
  1198.             }
  1199.             if($client->getLang() == 'en'){
  1200.                 $this->addFlash('green','Product image uploaded successfully..!!');
  1201.              }else{
  1202.                 $this->addFlash('green',"L'image du produit a été téléchargée avec succès..!!");
  1203.             }
  1204.         }
  1205.         return $this->redirectToRoute('app_manage_product');
  1206.     }
  1208.     /**
  1209.      * @Route("/request-product-delete/{id}", name="app_product_delete")
  1210.      */
  1211.     public function product_delete(Products $request,$id)
  1212.     {
  1213.         $em = $this->getDoctrine()->getManager();
  1214.         $request->getId($id);
  1215.         $em->remove($request);
  1216.         $em->flush();
  1218.         $this->addFlash('green','Category deleted successfully..!!');
  1220.         return $this->redirectToRoute('app_manage_product');
  1221.     }
  1223.     /**
  1224.      * @Route("/update-product-status/{id}/{status}", name="update_product_status")
  1225.      */
  1226.     public function updateRequestproductstatus(Products $request,$status)
  1227.     {
  1228.         if ($this->getUser()) {
  1229.             $client = $this->getUser();
  1230.         } else {
  1231.             return $this->redirectToRoute('user_login');
  1232.         }
  1233.         $em = $this->getDoctrine()->getManager();
  1234.         $request->setStatus($status);
  1235.         $em->persist($request);
  1236.         $em->flush();
  1237.         if($status == 1){
  1238.           if($client->getLang() == 'en'){
  1239.              $this->addFlash('green', 'You have enable the product');
  1240.           }else{
  1241.              $this->addFlash('green', 'Vous avez activé le produit');
  1242.           }
  1243.         }else{
  1244.           if($client->getLang() == 'en'){
  1245.              $this->addFlash('red', 'You have disable the product');
  1246.           }else{
  1247.              $this->addFlash('red', 'Vous avez désactivé le produit');
  1248.           }
  1249.         }
  1250.         return $this->redirectToRoute('app_manage_product');
  1251.     }
  1253.      /**
  1254.      * @Route("/manage-category", name="app_manage_categories")
  1255.      */
  1256.     public function manage_categories()
  1257.     {
  1258.         if ($this->getUser()) {
  1259.             $client = $this->getUser();
  1260.         } else {
  1261.             return $this->redirectToRoute('user_login');
  1262.         }
  1264.         $user = $this->getUser();
  1265.         $type_user=$user->getType();
  1266.         $allid=explode(",", $user->getRolebyadmin());
  1267.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  1268.         if($type_user == "SuperAdmin" || $type_user == "Client Admin"){
  1270.             $datas = $this->getDoctrine()->getRepository('App\Entity\Subcategorie')->findBy(array(),array('id'=>'desc'));
  1271.             $categorie = $this->getDoctrine()->getRepository(Categorie::class)->findBy(array(),array('id'=>'desc'));
  1272.             $page='home/manage_categorie.html.twig';
  1273.         }else{
  1274.             $page='security/pagenotfound.html.twig';
  1275.             $datas = "";
  1276.             $categorie ="";
  1277.         }
  1278.         return $this->render($page, 
  1279.             array(
  1280.                 // 'form'=>$form->createView(),
  1281.                 'client' => $client,
  1282.                 'datas'=>$datas,
  1283.                 'category'=>$categorie,
  1284.                 'type_user'=>$type_user,
  1285.                 'roles_client'=>$roles_client,
  1286.                 'implode_pending'=>'',
  1287.                 'implode_assigned'=>'',
  1288.                 'implode_resolved'=>'',  
  1289.             )
  1290.         );
  1291.     }
  1293.     /**
  1294.      * @Route("/manage-days", name="app_manage_days")
  1295.      */
  1296.     public function manage_days()
  1297.     {
  1298.         if ($this->getUser()) {
  1299.             $client = $this->getUser();
  1300.         } else {
  1301.             return $this->redirectToRoute('user_login');
  1302.         }
  1304.         $user = $this->getUser();
  1305.         $type_user=$user->getType();
  1306.         $allid=explode(",", $user->getRolebyadmin());
  1307.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  1308.         if($type_user == "SuperAdmin" || $type_user == "Client Admin"){
  1310.             $datas = $this->getDoctrine()->getRepository('App\Entity\ExpDays')->findBy(array(),array('id'=>'desc'));
  1311.             $page='home/manage_days.html.twig';
  1312.         }else{
  1313.             $page='security/pagenotfound.html.twig';
  1314.             $datas = "";
  1315.             $categorie ="";
  1316.         }
  1317.         return $this->render($page, 
  1318.             array(
  1319.                 // 'form'=>$form->createView(),
  1320.                 'client' => $client,
  1321.                 'datas'=>$datas,
  1322.                 'type_user'=>$type_user,
  1323.                 'roles_client'=>$roles_client,
  1324.                 'implode_pending'=>'',
  1325.                 'implode_assigned'=>'',
  1326.                 'implode_resolved'=>'',  
  1327.             )
  1328.         );
  1329.     }
  1331.      /**
  1332.      * @Route("/request-days", name="app_create_days")
  1333.      */
  1334.     public function create_days(Request $request)
  1335.     {
  1337.         if ($this->getUser()) {
  1338.             $client = $this->getUser();
  1339.         } else {
  1340.             return $this->redirectToRoute('user_login');
  1341.         }
  1343.         $user = $this->getUser();
  1344.         $user_id=$user->getId();
  1345.        
  1346.         $em = $this->getDoctrine()->getManager();
  1347.         if ($request->getMethod() === "POST") {
  1349.             if($request->request->get('table_id') !=""){
  1350.                 $updateRequest = $this->getDoctrine()->getRepository('App\Entity\ExpDays')
  1351.                 ->find($request->request->get('table_id'));
  1352.                 $updateRequest->setDays($request->request->get('exp_days'));
  1353.                 $em = $this->getDoctrine()->getManager();
  1354.                 $em->persist($updateRequest);
  1355.                 $em->flush();
  1356.                 if($client->getLang() == 'en'){
  1357.                   $this->addFlash('green', 'Days update successfully..!!');
  1358.                }else{
  1359.                   $this->addFlash('green', 'Jours mis à jour avec succès');
  1360.                }
  1361.                  
  1362.             }else{
  1363.                 // print_r($request->request->all());die;
  1364.                 $addRequest = new ExpDays;
  1365.                 $addRequest->setDays($request->request->get('exp_days'));
  1366.                 $addRequest->setStatus('1');
  1367.                 $em = $this->getDoctrine()->getManager();
  1368.                 $em->persist($addRequest);
  1369.                 $em->flush();
  1370.                 if($client->getLang() == 'en'){
  1371.                   $this->addFlash('green', 'Days added successfully..!!');
  1372.                }else{
  1373.                   $this->addFlash('green', 'Jours ajouté avec succès..!!');
  1374.                }
  1375.                  
  1376.             }
  1377.         }
  1378.         return $this->redirectToRoute('app_manage_days');
  1379.     }
  1381.      /**
  1382.      * @Route("/update-days-status/{id}/{status}", name="update_days_status")
  1383.      */
  1384.     public function updatedaystatus(ExpDays $request,$status)
  1385.     {
  1386.           if ($this->getUser()) {
  1387.             $client = $this->getUser();
  1388.           } else {
  1389.             return $this->redirectToRoute('user_login');
  1390.           }
  1391.         $em = $this->getDoctrine()->getManager();
  1392.         $request->setStatus($status);
  1393.         $em->persist($request);
  1394.         $em->flush();
  1395.         if($status == 1){
  1396.           if($client->getLang() == 'en'){
  1397.              $this->addFlash('green', 'You have enable the days');
  1398.           }else{
  1399.              $this->addFlash('green', 'Vous avez activé les jours');
  1400.           }     
  1401.             
  1402.         }else{
  1403.           if($client->getLang() == 'en'){
  1404.              $this->addFlash('red', 'You have disable the days');
  1405.           }else{
  1406.              $this->addFlash('red', 'Vous avez désactivé les jours');
  1407.           }
  1408.             
  1409.         }
  1410.         return $this->redirectToRoute('app_manage_days');
  1411.     }
  1413.     /**
  1414.      * @Route("/create_category", name="app_create_category")
  1415.      */
  1416.     public function create_manage_category(Request $request)
  1417.     {  
  1418.         // $result= 'Category added successfully..!!'; 
  1419.         $em = $this->getDoctrine()->getManager();
  1420.         if ($request->getMethod() === "POST") {
  1421.             $addRequest = new Categorie;
  1422.             $addRequest->setName($request->request->get('name') );
  1423.             $em = $this->getDoctrine()->getManager();
  1424.             $em->persist($addRequest);
  1425.             $em->flush();
  1426.             $result= 'Category added successfully!!';  
  1427.         }
  1428.         
  1429.         return $this->json($result);
  1430.     }
  1432.     
  1433.     /**
  1434.      * @Route("/create_subcategory", name="app_create_subcategory")
  1435.      */
  1436.     public function create_manage_subcategory(Request $request)
  1437.     {
  1439.         if ($this->getUser()) {
  1440.             $client = $this->getUser();
  1441.         } else {
  1442.             return $this->redirectToRoute('user_login');
  1443.         }
  1445.         $user = $this->getUser();
  1446.         $user_id=$user->getId();
  1447.        
  1448.         $em = $this->getDoctrine()->getManager();
  1449.         if ($request->getMethod() === "POST") {
  1451.             $categorie = $this->getDoctrine()->getRepository(Categorie::class)->findOneBy(array('id' => $request->request->get('category')));
  1454.             if($request->request->get('table_id') !=""){
  1455.                 $updateRequest = $this->getDoctrine()->getRepository('App\Entity\Subcategorie')
  1456.                 ->find($request->request->get('table_id'));
  1457.                 $updateRequest->setCategory($categorie);
  1458.                 $updateRequest->setName($request->request->get('name'));
  1459.                 $em = $this->getDoctrine()->getManager();
  1460.                 $em->persist($updateRequest);
  1461.                 $em->flush();
  1462.                 if($client->getLang() == 'en'){
  1463.                   $this->addFlash('green', 'Subcategory update successfully..!!');
  1464.                }else{
  1465.                   $this->addFlash('green', 'Mise à jour de la sous-catégorie avec succès..!!');
  1466.                }
  1467.                  
  1468.             }else{
  1469.                 // print_r($request->request->all());die;
  1470.                 $addRequest = new Subcategorie;
  1471.                 $addRequest->setCategory($categorie);
  1472.                 $addRequest->setName($request->request->get('name'));
  1473.                 $addRequest->setStatus('1');
  1474.                 $em = $this->getDoctrine()->getManager();
  1475.                 $em->persist($addRequest);
  1476.                 $em->flush();
  1477.                 if($client->getLang() == 'en'){
  1478.                   $this->addFlash('green', 'Subcategory added successfully..!!'); 
  1479.                }else{
  1480.                   $this->addFlash('green', 'Sous-catégorie ajoutée avec succès..!!'); 
  1481.                }
  1482.                 
  1483.             }
  1484.         }
  1485.         return $this->redirectToRoute('app_manage_categories');
  1486.     }
  1488.     /**
  1489.      * @Route("/update-request-category-status/{id}/{status}", name="update_category_status")
  1490.      */
  1491.     public function updateRequestcategorystatus(Subcategorie $request,$status)
  1492.     {
  1493.           if ($this->getUser()) {
  1494.             $client = $this->getUser();
  1495.           } else {
  1496.             return $this->redirectToRoute('user_login');
  1497.           }
  1499.         $em = $this->getDoctrine()->getManager();
  1500.         $request->setStatus($status);
  1501.         $em->persist($request);
  1502.         $em->flush();
  1503.         if($status == 1){
  1504.           if($client->getLang() == 'en'){
  1505.              $this->addFlash('green', 'You have enable the category');
  1506.           }else{
  1507.              $this->addFlash('green', 'Vous avez activé la catégorie');
  1508.           }
  1509.             
  1510.         }else{
  1511.           if($client->getLang() == 'en'){
  1512.              $this->addFlash('red', 'You have disable the category');
  1513.           }else{
  1514.              $this->addFlash('red', 'Vous avez désactivé la catégorie');
  1515.           }
  1516.             
  1517.         }
  1518.         return $this->redirectToRoute('app_manage_categories');
  1519.     }
  1521.     /**
  1522.      * @Route("/request-subcategory-delete/{id}", name="app_subcategory_delete")
  1523.      */
  1525.     public function subcategory_delete(Subcategorie $request,$id)
  1526.     {
  1527.         $em = $this->getDoctrine()->getManager();
  1528.         $request->getId($id);
  1529.         $em->remove($request);
  1530.         $em->flush();
  1532.         $this->addFlash('green','Category deleted successfully..!!');
  1534.         return $this->redirectToRoute('app_manage_categories');
  1535.     }
  1537.     /**
  1538.      * @Route("/manage_agent", name="app_manage_agent")
  1539.      */
  1540.     public function manage_agent()
  1541.     {
  1542.         if ($this->getUser()) {
  1543.             $client = $this->getUser();
  1544.         } else {
  1545.             return $this->redirectToRoute('user_login');
  1546.         }
  1548.         $user = $this->getUser();
  1549.         $type_user=$user->getType();
  1550.         $allid=explode(",", $user->getRolebyadmin());
  1551.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  1552.         $complaint="";
  1553.         if($type_user=='SuperAdmin'){
  1554.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  1555.                 array('type'=>'Agent'),
  1556.                 array('id'=>'desc'),
  1557.             );
  1558.         }elseif($type_user=='Client Admin'){
  1559.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  1560.                 array('type'=>'Agent'),
  1561.                 array('id'=>'desc'),
  1562.             );
  1563.         }elseif($type_user=='Hypervisor'){
  1564.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  1565.                 array('type'=>'Agent','city_id'=>$user->getCityId()),
  1566.                 array('id'=>'desc'),
  1567.             );
  1568.             if(!empty($datas)){
  1569.                 foreach($datas as $key=>$dataid){
  1570.                     $complaint = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(
  1571.                     array('agentid'=>$dataid->getId(),'compstatus'=>'Resolved'),
  1572.                     array('id'=>'desc'),);
  1573.                     $result=count($complaint);
  1574.                     $datas[$key]->complaint_count=$result;
  1575.                 }
  1577.             }else{
  1578.                 $datas ="";
  1579.             }
  1580.         }elseif($type_user=='Supervisor'){
  1581.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  1582.                 array('type'=>'Agent','city_id'=>$user->getCityId()),
  1583.                 array('id'=>'desc'),
  1584.             );
  1585.             if(!empty($datas)){
  1586.                 foreach($datas as $key=>$dataid){
  1587.                     $complaint = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(
  1588.                     array('agentid'=>$dataid->getId(),'compstatus'=>'Resolved'),
  1589.                     array('id'=>'desc'),);
  1590.                     $result=count($complaint);
  1591.                     $datas[$key]->complaint_count=$result;
  1592.                 }
  1594.             }else{
  1595.                 $datas ="";
  1596.             }
  1597.         }elseif($type_user=='Operational Manager'){
  1598.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  1599.                 array('type'=>'Agent','city_id'=>$user->getCityId()),
  1600.                 array('id'=>'desc'),
  1601.             );
  1603.             $complaint = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(
  1604.             array('city_id'=>$user->getCityId(),'agentid'=>'0'),
  1605.             array('id'=>'desc'),);
  1606.         }else{
  1607.             $datas="";
  1608.         }
  1610.         $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findBy(
  1611.             array('code'=>'FR'),
  1612.             array('name'=>'asc'),
  1613.         );
  1614.         $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findBy(array(),
  1615.             array('name'=>'asc'),
  1616.         );
  1617.     
  1619.         if($type_user=='SuperAdmin'){
  1620.             $page='home/manage_agent.html.twig';
  1621.         }elseif($type_user=='Client Admin'){
  1622.             $page='home/manage_agent.html.twig';
  1623.         }elseif($type_user=='Hypervisor'){
  1624.             $page='hypervisor/manage_agent.html.twig';
  1625.         }elseif($type_user=='Supervisor'){
  1626.             $page='supervisor/manage_agent.html.twig';
  1627.         }elseif($type_user=='Operational Manager'){
  1628.             $page='operational/manage_agent.html.twig';
  1629.         }else{
  1630.             $page='security/pagenotfound.html.twig';
  1631.         }
  1633.         return $this->render($page, 
  1634.             array(
  1635.                 // 'form'=>$form->createView(),
  1636.                 'client' => $client,
  1637.                 'datas'=>$datas,
  1638.                 'countrys'=>$countrys,
  1639.                 'citys'=>$citys,
  1640.                 'type_user'=>$type_user,
  1641.                 'roles_client'=>$roles_client,
  1642.                 'implode_pending'=>'',
  1643.                 'implode_assigned'=>'',
  1644.                 'implode_resolved'=>'',  
  1645.                 'complaint'=>$complaint,
  1646.             )
  1647.         );
  1648.     }
  1650.     /**
  1651.      * @Route("/create_manage_agent", name="app_create_manage_agent")
  1652.      */
  1653.     public function create_manage_agent(Request $request, UserPasswordEncoderInterface $passwordEncoder, \Swift_Mailer $mailer)
  1654.     {
  1655.         if ($this->getUser()) {
  1656.             $client = $this->getUser();
  1657.         } else {
  1658.             return $this->redirectToRoute('user_login');
  1659.         }
  1661.         $user = $this->getUser();
  1662.         $user_id=$user->getId();
  1663.         
  1664.             $em = $this->getDoctrine()->getManager();
  1665.             if ($request->getMethod() === "POST") {
  1666.                 $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findOneBy(
  1667.                 array('id'=>$request->request->get('country')),
  1668.                 );
  1669.                 $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  1670.                     array('id'=>$request->request->get('city')),
  1671.                 );  
  1672.                 if($request->request->get('table_id') !=""){
  1673.                     $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBySomeField(array('value'=>$request->request->get('table_id')),array('email'=>$request->request->get('email')));
  1674.                     if (empty($result)) {
  1675.                         $ipadress=$request->getClientIp();
  1676.                         $updateRequest = $this->getDoctrine()->getRepository('App\Entity\User')
  1677.                         ->find($request->request->get('table_id') );
  1678.                         $updateRequest->setName($request->request->get('name') );
  1679.                         $updateRequest->setEmail($request->request->get('email'));
  1680.                         $updateRequest->setMobile($request->request->get('mobile'));
  1681.                         $updateRequest->setAgentgroupId('0');
  1682.                         $updateRequest->setCountry($countrys);
  1683.                         $updateRequest->setCity($citys);
  1684.                         $updateRequest->setProvinceId('0');
  1685.                         $updateRequest->setIpaddress($ipadress);
  1686.                         $em = $this->getDoctrine()->getManager();
  1687.                         $em->persist($updateRequest);
  1688.                         $em->flush();
  1689.                         if($client->getLang() == 'en'){
  1690.                             $this->addFlash('green', 'Agent update successfully..!!'); 
  1691.                          }else{
  1692.                             $this->addFlash('green', "Mise à jour de l'agent avec succès..!!"); 
  1693.                          }
  1694.                         
  1695.                     }else{
  1696.                         if($client->getLang() == 'en'){
  1697.                             $this->addFlash('red', 'There is already an account with this email');
  1698.                          }else{
  1699.                             $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  1700.                          }
  1701.                     }
  1702.                 }else{
  1703.                     $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('email'=>$request->request->get('email')),array('id'=>'desc'));
  1704.                     if(empty($result)){
  1705.                         $agid= $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('type'=>'Agent'),array('id'=>'desc'),);
  1706.                         if(!empty($agid)){
  1707.                             $idno=explode("AG", $agid->getUserId());
  1708.                             $n=$idno[1];
  1709.                             $n2 = str_pad($n + 1, 5, 0, STR_PAD_LEFT);
  1710.                         }else{
  1711.                             $n2="00001";
  1712.                         }
  1713.                         // dd($n2);
  1715.                         $random_password = substr(md5(random_bytes(20)),1,25);
  1716.                         $newPassword ='123456';
  1717.                         $userid ='AG'.$n2;
  1718.                         $ipadress=$request->getClientIp();
  1719.                         $addRequest = new User;
  1720.                         $addRequest->setAddedBy($user_id);
  1721.                         $addRequest->setUserId($userid);
  1722.                         $addRequest->setName($request->request->get('name') );
  1723.                         $addRequest->setEmail($request->request->get('email'));
  1724.                         $addRequest->setMobile($request->request->get('mobile'));
  1725.                         $addRequest->setPassword($passwordEncoder->encodePassword(
  1726.                             $addRequest,
  1727.                             $newPassword
  1728.                         ));
  1729.                         $addRequest->setPasswordResetToken($random_password);
  1730.                         $addRequest->setCountry($countrys);
  1731.                         $addRequest->setCity($citys);
  1732.                         $addRequest->setProvinceId('0');
  1733.                         $addRequest->setStatus('1');
  1734.                         $addRequest->setAgentgroupId('0');
  1735.                         $addRequest->setType('Agent');
  1736.                         $addRequest->setLang('fr');
  1737.                         $addRequest->setRoles(["ROLE_AGENT"]);
  1738.                         $addRequest->setIpaddress($ipadress);
  1739.                         $em = $this->getDoctrine()->getManager();
  1740.                         $em->persist($addRequest);
  1741.                         $em->flush();
  1743.                         $url = $this->urlGenerator->generate('reset_password', array('code'=>$random_password), UrlGeneratorInterface::ABSOLUTE_URL);
  1744.                         $sendTo = $request->request->get('email');
  1745.                         $sendCc = 'santosh.jaiswal.espl@gmail.com';
  1746.                         $mailArray = array(
  1747.                             'email' => 'infos-compte@konsoplus.com',
  1748.                             'emailid' => $request->request->get('email'),
  1749.                             'mobile' => $request->request->get('mobile'),
  1750.                             'name' => $request->request->get('name'),
  1751.                             'city' => $citys->getName(),
  1752.                             'url' => $url,
  1753.                             'password' => $random_password
  1754.                         );
  1756.                         $mail = $this->mailer->sendEmailMessage(
  1757.                             'Renouveler votre mot de passe',
  1758.                             "Konso+",
  1759.                             $sendTo,
  1760.                             $sendCc,
  1761.                             null,
  1762.                             'security/welcomemail.html.twig',
  1763.                             $mailArray
  1764.                         );
  1765.                         if($client->getLang() == 'en'){
  1766.                             $this->addFlash('green', 'Agent added successfully..!!'); 
  1767.                          }else{
  1768.                             $this->addFlash('green', 'Agent ajouté avec succès..!!');  
  1769.                          }
  1770.                         
  1771.                     }else{
  1772.                         if($client->getLang() == 'en'){
  1773.                             $this->addFlash('red', 'There is already an account with this email');
  1774.                          }else{
  1775.                             $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  1776.                          }
  1777.                     }
  1778.                 }    
  1779.             }
  1780.         return $this->redirectToRoute('app_manage_agent');
  1781.     }
  1782.     
  1783.     /**
  1784.      * @Route("/update-request-status-agent/{id}/{status}", name="update_user_status_agent")
  1785.      */
  1786.     public function update_status_agent(User $request,$status)
  1787.     {
  1788.         if ($this->getUser()) {
  1789.             $client = $this->getUser();
  1790.         } else {
  1791.             return $this->redirectToRoute('user_login');
  1792.         }
  1793.         $em = $this->getDoctrine()->getManager();
  1794.         $request->setStatus($status);
  1795.         $em->persist($request);
  1796.         $em->flush();
  1797.         if($status == 1){
  1798.           if($client->getLang() == 'en'){
  1799.              $this->addFlash('green', 'You have enable the agent');
  1800.           }else{
  1801.              $this->addFlash('green', "Vous avez activé l'agent"); 
  1802.           }
  1803.         }else{
  1804.           if($client->getLang() == 'en'){
  1805.              $this->addFlash('red', 'You have disable the agent'); 
  1806.           }else{
  1807.              $this->addFlash('red', "Vous avez désactivé l'agent");  
  1808.           }
  1809.         }
  1810.         return $this->redirectToRoute('app_manage_agent');
  1811.     }
  1813.     /**
  1814.      * @Route("/request-agentuser-delete/{id}", name="app_user_delete_agent")
  1815.      */
  1817.     public function user_agent_delete(User $request,$id)
  1818.     {
  1819.         $em = $this->getDoctrine()->getManager();
  1820.         $request->getId($id);
  1821.         $em->remove($request);
  1822.         $em->flush();
  1824.         $this->addFlash('green','Agent deleted successfully..!!');
  1826.         return $this->redirectToRoute('app_manage_agent');
  1827.     }
  1828.     
  1830.     /**
  1831.      * @Route("/manage_agent_group", name="app_manage_agent_group")
  1832.      */
  1833.     public function manage_agent_group()
  1834.     {
  1835.         if ($this->getUser()) {
  1836.             $client = $this->getUser();
  1837.         } else {
  1838.             return $this->redirectToRoute('user_login');
  1839.         }
  1841.         $user = $this->getUser();
  1842.         $type_user=$user->getType();
  1843.         $allid=explode(",", $user->getRolebyadmin());
  1844.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  1846.         if($type_user=='SuperAdmin'){
  1847.             $datas = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findBy(
  1848.                 array(),
  1849.                 array('id'=>'desc'),
  1850.             );
  1851.         }elseif($type_user=='Client Admin'){
  1852.             $datas = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findBy(
  1853.                 array(),
  1854.                 array('id'=>'desc'),
  1855.             );
  1856.         }elseif($type_user=='Supervisor'){
  1857.             $datas = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findBy(
  1858.                 array('city_id'=>$user->getCityId()),
  1859.                 array('id'=>'desc'),
  1860.             );
  1861.             if(!empty($datas)){
  1862.                 foreach ($datas as $key => $value) {
  1863.                     $explode_agent=explode(",", $value->getAgentid());
  1864.                     $agents=$agt=$this->getDoctrine()->getRepository('App\Entity\User')->findAllIdField($explode_agent);
  1865.                     $operational=$this->getDoctrine()->getRepository('App\Entity\User')->findBy( array('agentgroup_id'=>$value->getId(),'type'=>'Operational Manager'),array('id'=>'desc'));
  1867.                     $datas[$key]->agent_detail=$agents;
  1868.                     $datas[$key]->operational_detail=$operational;
  1869.                 }
  1870.                 
  1871.             }else{
  1872.                 $datas = "";
  1873.             }
  1874.         }elseif($type_user=='Hypervisor'){
  1875.             $datas = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findBy(
  1876.                 array('city_id'=>$user->getCityId()),
  1877.                 array('id'=>'desc'),
  1878.             );
  1880.             if(!empty($datas)){
  1881.                 foreach ($datas as $key => $value) {
  1882.                     $explode_agent=explode(",", $value->getAgentid());
  1883.                     $agents=$agt=$this->getDoctrine()->getRepository('App\Entity\User')->findAllIdField($explode_agent);
  1884.                     $operational=$this->getDoctrine()->getRepository('App\Entity\User')->findBy( array('agentgroup_id'=>$value->getId(),'type'=>'Operational Manager'),array('id'=>'desc'));
  1886.                     $datas[$key]->agent_detail=$agents;
  1887.                     $datas[$key]->operational_detail=$operational;
  1888.                 }
  1889.                 
  1890.             }else{
  1891.                 $datas = "";
  1892.             }
  1893.             // dd($datas);
  1894.         }elseif($type_user=='Operational Manager'){
  1895.             $datas = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findBy(
  1896.                 array('city_id'=>$user->getCityId()),
  1897.                 array('id'=>'desc'),
  1898.             );
  1899.         }else{
  1900.             $datas ="";
  1901.         }
  1903.         if(!empty($datas)){
  1904.             foreach($datas as $key=>$dataid){
  1905.                if($dataid->getagentId() == null){
  1906.                     $datas[$key]->agentcount=0;
  1907.                }else{
  1908.                     $res = explode(",", $dataid->getagentId());
  1909.                     $result=count($res);
  1910.                     $datas[$key]->agentcount=$result;
  1911.                }
  1912.             }
  1914.         }else{
  1915.             $datas ="";
  1916.         }
  1918.         $agents = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  1919.             array('type'=>'Agent','status' => true),
  1920.             array('id'=>'desc'),
  1921.         );
  1923.         $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findBy(
  1924.             array('code'=>'FR'),
  1925.             array('name'=>'asc'),
  1926.         );
  1927.         $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findBy(array(),
  1928.             array('name'=>'asc'),
  1929.         );
  1931.         if($type_user=='SuperAdmin'){
  1932.             $page='home/agent_group.html.twig';
  1933.         }elseif($type_user=='Client Admin'){
  1934.             $page='home/agent_group.html.twig';
  1935.         }elseif($type_user=='Supervisor'){
  1936.             $page='supervisor/agent_group.html.twig';
  1937.         }elseif($type_user=='Hypervisor'){
  1938.             $page='hypervisor/agent_group.html.twig';
  1939.         }elseif($type_user=='Operational Manager'){
  1940.             $page='operational/agent_group.html.twig';
  1941.         }else{
  1942.             $page='security/pagenotfound.html.twig';
  1943.         }
  1945.         return $this->render($page, 
  1946.             array(
  1947.                 // 'form'=>$form->createView(),
  1948.                 'client' => $client,
  1949.                 'datas'=>$datas,
  1950.                 'agents'=>$agents,
  1951.                 'countrys'=>$countrys,
  1952.                 'citys'=>$citys,
  1953.                 'type_user'=>$type_user,
  1954.                 'roles_client'=>$roles_client,
  1955.                 'implode_pending'=>'',
  1956.                 'implode_assigned'=>'',
  1957.                 'implode_resolved'=>'',  
  1958.             )
  1959.         );
  1960.     }
  1962.     /**
  1963.      * @Route("/manage_agent_group_id/{id}", name="app_manage_agent_group_id")
  1964.      */
  1965.     public function manage_agent_group_id($id)
  1966.     {
  1967.         if ($this->getUser()) {
  1968.             $client = $this->getUser();
  1969.         } else {
  1970.             return $this->redirectToRoute('user_login');
  1971.         }
  1973.         $user = $this->getUser();
  1974.         $type_user=$user->getType();
  1975.         $allid=explode(",", $user->getRolebyadmin());
  1976.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  1977.         if($type_user == "Operational Manager"){
  1978.             $agent_grp = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->find($id);
  1979.             $agid=explode(",", $agent_grp->getAgentid());
  1980.             if(!empty($agid)){
  1981.                 $datas=array();
  1982.                 foreach($agid as $key => $value){
  1983.                     // code...
  1984.                     $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(
  1985.                         array('id'=>$value,'type'=>'Agent'),
  1986.                         array('id'=>'desc'),
  1987.                     );
  1988.                 }
  1989.                 $datas[]=$result;
  1990.             }else{
  1991.                 $datas ="";
  1992.             }
  1993.         
  1994.             $complaint = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('city_id'=>$agent_grp->getCityId()),
  1995.             array('id'=>'desc'),);
  1996.           $page='operational/agent_group_detail.html.twig';
  1997.         }else{
  1998.             $page='security/pagenotfound.html.twig';
  1999.             $datas = "";
  2000.             $agent_grp ="";
  2001.             $complaint ="";
  2002.         }
  2003.         return $this->render($page, 
  2004.             array(
  2005.                 // 'form'=>$form->createView(),
  2006.                 'client' => $client,
  2007.                 'datas'=>$datas,
  2008.                 'agent_grp'=>$agent_grp,
  2009.                 'type_user'=>$type_user,
  2010.                 'roles_client'=>$roles_client,
  2011.                 'implode_pending'=>'',
  2012.                 'implode_assigned'=>'',
  2013.                 'implode_resolved'=>'',  
  2014.                 'complaint'=>$complaint,
  2015.             )
  2016.         );
  2017.     }
  2019.     /**
  2020.      * @Route("/create_manage_agent_group", name="app_create_manage_agent_group")
  2021.      */
  2022.     public function create_manage_agent_group(Request $request)
  2023.     {
  2024.         if ($this->getUser()) {
  2025.             $client = $this->getUser();
  2026.         } else {
  2027.             return $this->redirectToRoute('user_login');
  2028.         }
  2030.         $user = $this->getUser();
  2031.         $user_id=$user->getId();
  2032.         $em = $this->getDoctrine()->getManager();
  2033.         if ($request->getMethod() === "POST") {
  2034.             $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findOneBy(
  2035.             array('id'=>$request->request->get('country')),
  2036.             );
  2037.             $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  2038.                 array('id'=>$request->request->get('city')),
  2039.             );      
  2040.             if($request->request->get('table_id') !=""){
  2041.                if(!empty($request->request->get('agentid'))){
  2042.                     $agid=implode(",",$request->request->get('agentid'));
  2043.                 }else{
  2044.                     $agid=null;
  2045.                 }
  2046.                 
  2047.                 $updateRequest = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')
  2048.                 ->find($request->request->get('table_id') );
  2049.                 $updateRequest->setName($request->request->get('name') );
  2050.                 $updateRequest->setAgentid($agid);
  2051.                 $updateRequest->setCountry($countrys);
  2052.                 $updateRequest->setCity($citys);
  2054.                 $em = $this->getDoctrine()->getManager();
  2055.                 $em->persist($updateRequest);
  2056.                 $em->flush();
  2057.                 if($client->getLang() == 'en'){
  2058.                   $this->addFlash('green', 'Agent group update successfully..!!'); 
  2059.                }else{
  2060.                   $this->addFlash('green', "Mise à jour du groupe d'agents avec succès..!!");  
  2061.                }
  2062.             }else{
  2063.                 $gpid= $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findOneBy(array(),array('id'=>'desc'),);
  2064.                 if(!empty($gpid)){
  2065.                     $idno=explode("GP", $gpid->getGpid());
  2066.                     $n=$idno[1];
  2067.                     $n2 = str_pad($n + 1, 5, 0, STR_PAD_LEFT);
  2068.                 }else{
  2069.                     $n2="00001";
  2070.                 }
  2071.                 $gp='GP'.$n2;
  2073.                 if(!empty($request->request->get('agentid'))){
  2074.                     $agid=implode(",",$request->request->get('agentid'));
  2075.                 }else{
  2076.                     $agid=null;
  2077.                 }
  2078.                 $addRequest = new AgentGroup;
  2079.                 $addRequest->setName($request->request->get('name') );
  2080.                 $addRequest->setAgentid($agid);
  2081.                 $addRequest->setCountry($countrys);
  2082.                 $addRequest->setCity($citys);
  2083.                 $addRequest->setGpid($gp);
  2084.                 $addRequest->setAddedby($user_id);
  2085.                 $addRequest->setStatus('1');
  2087.                 $em = $this->getDoctrine()->getManager();
  2088.                 $em->persist($addRequest);
  2089.                 $em->flush();
  2090.                 if($client->getLang() == 'en'){
  2091.                   $this->addFlash('green', 'Agent group added successfully..!!'); 
  2092.                }else{
  2093.                   $this->addFlash('green', "Groupe d'agents ajouté avec succès..!!");  
  2094.                }
  2095.             }    
  2096.         }
  2097.         return $this->redirectToRoute('app_manage_agent_group');
  2098.     }
  2099.     
  2100.     /**
  2101.      * @Route("/update-request-status-agent-group/{id}/{status}", name="update_status_agent_group")
  2102.      */
  2103.     public function update_status_agent_group(AgentGroup $request,$status)
  2104.     {
  2105.         if ($this->getUser()) {
  2106.             $client = $this->getUser();
  2107.         } else {
  2108.             return $this->redirectToRoute('user_login');
  2109.         }
  2110.         $em = $this->getDoctrine()->getManager();
  2111.         $request->setStatus($status);
  2112.         $em->persist($request);
  2113.         $em->flush();
  2114.         if($status == 1){
  2115.                if($client->getLang() == 'en'){
  2116.                   $this->addFlash('green', 'You have enable the agent group');
  2117.                }else{
  2118.                   $this->addFlash('green', "Vous avez activé le groupe d'agents");  
  2119.                }
  2120.         }else{
  2121.           if($client->getLang() == 'en'){
  2122.              $this->addFlash('red', 'You have disable the agent group');
  2123.           }else{
  2124.              $this->addFlash('red', "Vous avez désactivé le groupe d'agents");  
  2125.           }
  2126.             
  2127.         }
  2128.         return $this->redirectToRoute('app_manage_agent_group');
  2129.     }
  2131.     /**
  2132.      * @Route("/request-agentgroup-delete/{id}", name="app_delete_agent_group")
  2133.      */
  2134.     public function agent_group_delete(AgentGroup $request,$id)
  2135.     {
  2136.         $em = $this->getDoctrine()->getManager();
  2137.         $request->getId($id);
  2138.         $em->remove($request);
  2139.         $em->flush();
  2141.         $this->addFlash('green','Agent group deleted successfully..!!');
  2143.         return $this->redirectToRoute('app_manage_agent_group');
  2144.     }
  2145.     
  2146.     /**
  2147.      * @Route("/manage_complaints", name="app_manage_complaints")
  2148.      */
  2149.     public function manage_complaints()
  2150.     {
  2151.         if ($this->getUser()) {
  2152.             $client = $this->getUser();
  2153.         } else {
  2154.             return $this->redirectToRoute('user_login');
  2155.         }
  2156.         $user = $this->getUser();
  2157.         $type_user=$user->getType();
  2158.         $allid=explode(",", $user->getRolebyadmin());
  2159.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  2161.         if($type_user=='SuperAdmin'){
  2162.             $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array(),array('id'=>'desc'));
  2163.             foreach ($datas as $key => $value) {
  2164.                 $agentgrpname = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findOneBy(array('id'=>$value->getGrpid()),
  2165.                 array('id'=>'desc'),);
  2166.                 $datas[$key]->agent_grp_name=$agentgrpname;
  2168.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2169.                     array('id'=>$value->getProvinceId()),
  2170.                 );
  2171.                 if(!empty($province)){
  2172.                     $datas[$key]->provinces=$province;
  2173.                 }else{
  2174.                     $datas[$key]->provinces="";
  2175.                 }
  2176.                 if($value->getFraud() == 1){
  2178.                     $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2179.                         array('complaint_id'=>$value->getId()),
  2180.                     );
  2181.                     if(!empty($FraudComplaint)){
  2182.                         $datas[$key]->fraudcomplaint=$FraudComplaint;
  2183.                     }else{
  2184.                         $datas[$key]->fraudcomplaint="";
  2185.                     }
  2187.                     $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2188.                     
  2189.                     if ($pv) {
  2190.                         $datas[$key]->fines =$pv;
  2191.                     } else {
  2192.                          $datas[$key]->fines ="";
  2193.                     }
  2195.                     $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2196.                         if ($fcp) {
  2197.                             $datas[$key]->fc_product =$fcp;
  2198.                         } else {
  2199.                              $datas[$key]->fc_product ="";
  2200.                         }
  2201.                 }
  2202.             }
  2203.         }elseif($type_user=='Client Admin'){
  2204.             $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array(),array('id'=>'desc'));
  2205.             foreach ($datas as $key => $value) {
  2206.                 $agentgrpname = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findOneBy(array('id'=>$value->getGrpid()),
  2207.                 array('id'=>'desc'),);
  2208.                 $datas[$key]->agent_grp_name=$agentgrpname;
  2209.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2210.                     array('id'=>$value->getProvinceId()),
  2211.                 );
  2212.                 if(!empty($province)){
  2213.                     $datas[$key]->provinces=$province;
  2214.                 }else{
  2215.                     $datas[$key]->provinces="";
  2216.                 }
  2217.                 if($value->getFraud() == 1){
  2219.                     $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2220.                         array('complaint_id'=>$value->getId()),
  2221.                     );
  2222.                     if(!empty($FraudComplaint)){
  2223.                         $datas[$key]->fraudcomplaint=$FraudComplaint;
  2224.                     }else{
  2225.                         $datas[$key]->fraudcomplaint="";
  2226.                     }
  2227.                     $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2228.                     if ($pv) {
  2229.                         $datas[$key]->fines =$pv;
  2230.                     } else {
  2231.                          $datas[$key]->fines ="";
  2232.                     }
  2234.                     $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2235.                         if ($fcp) {
  2236.                             $datas[$key]->fc_product =$fcp;
  2237.                         } else {
  2238.                              $datas[$key]->fc_product ="";
  2239.                         }
  2240.                 }
  2241.             }
  2242.         }elseif($type_user=='Hypervisor'){
  2243.             $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('city_id'=>$user->getCityId()),array('id'=>'desc'));
  2244.             foreach ($datas as $key => $value) {
  2245.                 $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  2246.                 array('id'=>'desc'),);
  2247.                 $datas[$key]->agent_name=$agentname;
  2248.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2249.                     array('id'=>$value->getProvinceId()),
  2250.                 );
  2251.                 if(!empty($province)){
  2252.                     $datas[$key]->provinces=$province;
  2253.                 }else{
  2254.                     $datas[$key]->provinces="";
  2255.                 }
  2256.                 if($value->getFraud() == 1){
  2258.                     $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2259.                         array('complaint_id'=>$value->getId()),
  2260.                     );
  2261.                     if(!empty($FraudComplaint)){
  2262.                         $datas[$key]->fraudcomplaint=$FraudComplaint;
  2263.                     }else{
  2264.                         $datas[$key]->fraudcomplaint="";
  2265.                     }
  2266.                     $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2267.                     if ($pv) {
  2268.                         $datas[$key]->fines =$pv;
  2269.                     } else {
  2270.                          $datas[$key]->fines ="";
  2271.                     }
  2273.                     $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2274.                         if ($fcp) {
  2275.                             $datas[$key]->fc_product =$fcp;
  2276.                         } else {
  2277.                              $datas[$key]->fc_product ="";
  2278.                         }
  2279.                 }
  2280.             }
  2281.         }elseif($type_user=='Supervisor'){
  2282.             $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('city_id'=>$user->getCityId()),array('id'=>'desc'));
  2283.             foreach ($datas as $key => $value) {
  2284.                 $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  2285.                 array('id'=>'desc'),);
  2286.                 $datas[$key]->agent_name=$agentname;
  2287.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2288.                     array('id'=>$value->getProvinceId()),
  2289.                 );
  2290.                 if(!empty($province)){
  2291.                     $datas[$key]->provinces=$province;
  2292.                 }else{
  2293.                     $datas[$key]->provinces="";
  2294.                 }
  2295.                 if($value->getFraud() == 1){
  2297.                     $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2298.                         array('complaint_id'=>$value->getId()),
  2299.                     );
  2300.                     if(!empty($FraudComplaint)){
  2301.                         $datas[$key]->fraudcomplaint=$FraudComplaint;
  2302.                     }else{
  2303.                         $datas[$key]->fraudcomplaint="";
  2304.                     }
  2305.                     $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2306.                     if ($pv) {
  2307.                         $datas[$key]->fines =$pv;
  2308.                     } else {
  2309.                          $datas[$key]->fines ="";
  2310.                     }
  2312.                     $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2313.                         if ($fcp) {
  2314.                             $datas[$key]->fc_product =$fcp;
  2315.                         } else {
  2316.                              $datas[$key]->fc_product ="";
  2317.                         }
  2318.                 }
  2319.             }
  2320.         }elseif($type_user=='Operational Manager'){
  2321.             $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('city_id'=>$user->getCityId()),array('id'=>'desc'));
  2322.             foreach ($datas as $key => $value) {
  2323.                 $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  2324.                 array('id'=>'desc'),);
  2325.                 if(!empty($agentname)){
  2326.                     $datas[$key]->agent_name=$agentname;
  2327.                 }else{
  2328.                     $datas[$key]->agent_name="";
  2329.                 }
  2330.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2331.                     array('id'=>$value->getProvinceId()),
  2332.                 );
  2333.                 if(!empty($province)){
  2334.                     $datas[$key]->provinces=$province;
  2335.                 }else{
  2336.                     $datas[$key]->provinces="";
  2337.                 }
  2339.                 if($value->getFraud() == 1){
  2341.                     $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2342.                         array('complaint_id'=>$value->getId()),
  2343.                     );
  2344.                     if(!empty($FraudComplaint)){
  2345.                         $datas[$key]->fraudcomplaint=$FraudComplaint;
  2346.                     }else{
  2347.                         $datas[$key]->fraudcomplaint="";
  2348.                     }
  2349.                     $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2350.                     if ($pv) {
  2351.                         $datas[$key]->fines =$pv;
  2352.                     } else {
  2353.                          $datas[$key]->fines ="";
  2354.                     }
  2356.                     $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2357.                         if ($fcp) {
  2358.                             $datas[$key]->fc_product =$fcp;
  2359.                         } else {
  2360.                              $datas[$key]->fc_product ="";
  2361.                         }
  2362.                 }
  2363.             }
  2364.         }
  2366.         if(!empty($datas)){
  2367.             foreach ($datas as $key => $value) {
  2368.                 // code...
  2370.                 $agent_grp = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findBy(array('city_id'=>$value->getCityId(),'status' => true),
  2371.                 array('id'=>'desc'),);
  2372.                 $agents=$this->getDoctrine()->getRepository('App\Entity\User')->findBy( array('city_id'=>$value->getCityId(),'type'=>'Agent','status' => true),array('id'=>'desc'));
  2373.                 $operational=$this->getDoctrine()->getRepository('App\Entity\User')->findBy( array('city_id'=>$value->getCityId(),'type'=>'Operational Manager','status' => true),array('id'=>'desc'));
  2374.                 
  2375.                 $datas[$key]->grp_agent_detail=$agent_grp;
  2376.                 $datas[$key]->agent_detail=$agents;
  2377.                 $datas[$key]->operational_detail=$operational;
  2378.             }
  2379.         }else{
  2380.             $datas = "";
  2381.         }
  2382.         
  2384.         if($type_user=='SuperAdmin'){
  2385.             $page='home/manage_complaint.html.twig';
  2386.         }elseif($type_user=='Client Admin'){
  2387.             $page='home/manage_complaint.html.twig';
  2388.         }elseif($type_user=='Hypervisor'){
  2389.             $page='hypervisor/manage_complaint.html.twig';
  2390.         }elseif($type_user=='Supervisor'){
  2391.             $page='supervisor/manage_complaint.html.twig';
  2392.         }elseif($type_user=='Operational Manager'){
  2393.             $page='operational/manage_complaint.html.twig';
  2394.         }else{
  2395.             $page='security/pagenotfound.html.twig';
  2396.         }
  2398.         return $this->render($page, 
  2399.             array(
  2400.                 // 'form'=>$form->createView(),
  2401.                 'client' => $client,
  2402.                 'datas'=>$datas,
  2403.                 'type_user'=>$type_user,
  2404.                 'roles_client'=>$roles_client,
  2405.                 'implode_pending'=>'',
  2406.                 'implode_assigned'=>'',
  2407.                 'implode_resolved'=>'',  
  2408.             )
  2409.         );
  2410.     }
  2413.      /**
  2414.      * @Route("/manage_pending complaints", name="app_manage_pending_complaints")
  2415.      */
  2416.     public function manage_pending_complaints()
  2417.     {
  2418.         if ($this->getUser()) {
  2419.             $client = $this->getUser();
  2420.         } else {
  2421.             return $this->redirectToRoute('user_login');
  2422.         }
  2423.         $user = $this->getUser();
  2424.         $type_user=$user->getType();
  2425.         $allid=explode(",", $user->getRolebyadmin());
  2426.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  2428.         if($type_user=='SuperAdmin'){
  2429.             $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('compstatus'=>'Pending'),array('id'=>'desc'));
  2430.             foreach ($datas as $key => $value) {
  2431.                 $agentgrpname = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findOneBy(array('id'=>$value->getGrpid()),
  2432.                 array('id'=>'desc'),);
  2433.                 $datas[$key]->agent_grp_name=$agentgrpname;
  2435.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2436.                     array('id'=>$value->getProvinceId()),
  2437.                 );
  2438.                 if(!empty($province)){
  2439.                     $datas[$key]->provinces=$province;
  2440.                 }else{
  2441.                     $datas[$key]->provinces="";
  2442.                 }
  2443.                 if($value->getFraud() == 1){
  2445.                     $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2446.                         array('complaint_id'=>$value->getId()),
  2447.                     );
  2448.                     if(!empty($FraudComplaint)){
  2449.                         $datas[$key]->fraudcomplaint=$FraudComplaint;
  2450.                     }else{
  2451.                         $datas[$key]->fraudcomplaint="";
  2452.                     }
  2454.                     $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2455.                     
  2456.                     if ($pv) {
  2457.                         $datas[$key]->fines =$pv;
  2458.                     } else {
  2459.                          $datas[$key]->fines ="";
  2460.                     }
  2462.                     $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2463.                         if ($fcp) {
  2464.                             $datas[$key]->fc_product =$fcp;
  2465.                         } else {
  2466.                              $datas[$key]->fc_product ="";
  2467.                         }
  2468.                 }
  2469.             }
  2470.         }elseif($type_user=='Client Admin'){
  2471.             $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('compstatus'=>'Pending'),array('id'=>'desc'));
  2472.             foreach ($datas as $key => $value) {
  2473.                 $agentgrpname = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findOneBy(array('id'=>$value->getGrpid()),
  2474.                 array('id'=>'desc'),);
  2475.                 $datas[$key]->agent_grp_name=$agentgrpname;
  2476.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2477.                     array('id'=>$value->getProvinceId()),
  2478.                 );
  2479.                 if(!empty($province)){
  2480.                     $datas[$key]->provinces=$province;
  2481.                 }else{
  2482.                     $datas[$key]->provinces="";
  2483.                 }
  2484.                 if($value->getFraud() == 1){
  2486.                     $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2487.                         array('complaint_id'=>$value->getId()),
  2488.                     );
  2489.                     if(!empty($FraudComplaint)){
  2490.                         $datas[$key]->fraudcomplaint=$FraudComplaint;
  2491.                     }else{
  2492.                         $datas[$key]->fraudcomplaint="";
  2493.                     }
  2494.                     $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2495.                     if ($pv) {
  2496.                         $datas[$key]->fines =$pv;
  2497.                     } else {
  2498.                          $datas[$key]->fines ="";
  2499.                     }
  2501.                     $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2502.                         if ($fcp) {
  2503.                             $datas[$key]->fc_product =$fcp;
  2504.                         } else {
  2505.                              $datas[$key]->fc_product ="";
  2506.                         }
  2507.                 }
  2508.             }
  2509.         }elseif($type_user=='Hypervisor'){
  2510.             $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('compstatus'=>'Pending','city_id'=>$user->getCityId()),array('id'=>'desc'));
  2511.             foreach ($datas as $key => $value) {
  2512.                 $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  2513.                 array('id'=>'desc'),);
  2514.                 $datas[$key]->agent_name=$agentname;
  2515.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2516.                     array('id'=>$value->getProvinceId()),
  2517.                 );
  2518.                 if(!empty($province)){
  2519.                     $datas[$key]->provinces=$province;
  2520.                 }else{
  2521.                     $datas[$key]->provinces="";
  2522.                 }
  2523.                 if($value->getFraud() == 1){
  2525.                     $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2526.                         array('complaint_id'=>$value->getId()),
  2527.                     );
  2528.                     if(!empty($FraudComplaint)){
  2529.                         $datas[$key]->fraudcomplaint=$FraudComplaint;
  2530.                     }else{
  2531.                         $datas[$key]->fraudcomplaint="";
  2532.                     }
  2533.                     $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2534.                     if ($pv) {
  2535.                         $datas[$key]->fines =$pv;
  2536.                     } else {
  2537.                          $datas[$key]->fines ="";
  2538.                     }
  2540.                     $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2541.                         if ($fcp) {
  2542.                             $datas[$key]->fc_product =$fcp;
  2543.                         } else {
  2544.                              $datas[$key]->fc_product ="";
  2545.                         }
  2546.                 }
  2547.             }
  2548.         }elseif($type_user=='Supervisor'){
  2549.             $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('compstatus'=>'Pending','city_id'=>$user->getCityId()),array('id'=>'desc'));
  2550.             foreach ($datas as $key => $value) {
  2551.                 $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  2552.                 array('id'=>'desc'),);
  2553.                 $datas[$key]->agent_name=$agentname;
  2554.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2555.                     array('id'=>$value->getProvinceId()),
  2556.                 );
  2557.                 if(!empty($province)){
  2558.                     $datas[$key]->provinces=$province;
  2559.                 }else{
  2560.                     $datas[$key]->provinces="";
  2561.                 }
  2562.                 if($value->getFraud() == 1){
  2564.                     $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2565.                         array('complaint_id'=>$value->getId()),
  2566.                     );
  2567.                     if(!empty($FraudComplaint)){
  2568.                         $datas[$key]->fraudcomplaint=$FraudComplaint;
  2569.                     }else{
  2570.                         $datas[$key]->fraudcomplaint="";
  2571.                     }
  2572.                     $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2573.                     if ($pv) {
  2574.                         $datas[$key]->fines =$pv;
  2575.                     } else {
  2576.                          $datas[$key]->fines ="";
  2577.                     }
  2579.                     $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2580.                         if ($fcp) {
  2581.                             $datas[$key]->fc_product =$fcp;
  2582.                         } else {
  2583.                              $datas[$key]->fc_product ="";
  2584.                         }
  2585.                 }
  2586.             }
  2587.         }elseif($type_user=='Operational Manager'){
  2588.             $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('compstatus'=>'Pending','city_id'=>$user->getCityId()),array('id'=>'desc'));
  2589.             foreach ($datas as $key => $value) {
  2590.                 $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  2591.                 array('id'=>'desc'),);
  2592.                 if(!empty($agentname)){
  2593.                     $datas[$key]->agent_name=$agentname;
  2594.                 }else{
  2595.                     $datas[$key]->agent_name="";
  2596.                 }
  2597.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2598.                     array('id'=>$value->getProvinceId()),
  2599.                 );
  2600.                 if(!empty($province)){
  2601.                     $datas[$key]->provinces=$province;
  2602.                 }else{
  2603.                     $datas[$key]->provinces="";
  2604.                 }
  2606.                 if($value->getFraud() == 1){
  2608.                     $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2609.                         array('complaint_id'=>$value->getId()),
  2610.                     );
  2611.                     if(!empty($FraudComplaint)){
  2612.                         $datas[$key]->fraudcomplaint=$FraudComplaint;
  2613.                     }else{
  2614.                         $datas[$key]->fraudcomplaint="";
  2615.                     }
  2616.                     $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2617.                     if ($pv) {
  2618.                         $datas[$key]->fines =$pv;
  2619.                     } else {
  2620.                          $datas[$key]->fines ="";
  2621.                     }
  2623.                     $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2624.                         if ($fcp) {
  2625.                             $datas[$key]->fc_product =$fcp;
  2626.                         } else {
  2627.                              $datas[$key]->fc_product ="";
  2628.                         }
  2629.                 }
  2630.             }
  2631.         }
  2633.         if(!empty($datas)){
  2634.             foreach ($datas as $key => $value) {
  2635.                 // code...
  2637.                 $agent_grp = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findBy(array('city_id'=>$value->getCityId(),'status' => true),
  2638.                 array('id'=>'desc'),);
  2639.                 $agents=$this->getDoctrine()->getRepository('App\Entity\User')->findBy( array('city_id'=>$value->getCityId(),'type'=>'Agent','status' => true),array('id'=>'desc'));
  2640.                 $operational=$this->getDoctrine()->getRepository('App\Entity\User')->findBy( array('city_id'=>$value->getCityId(),'type'=>'Operational Manager','status' => true),array('id'=>'desc'));
  2641.                 
  2642.                 $datas[$key]->grp_agent_detail=$agent_grp;
  2643.                 $datas[$key]->agent_detail=$agents;
  2644.                 $datas[$key]->operational_detail=$operational;
  2645.             }
  2646.         }else{
  2647.             $datas = "";
  2648.         }
  2649.         
  2651.         if($type_user=='SuperAdmin'){
  2652.             $page='home/manage_pending_complaint.html.twig';
  2653.         }elseif($type_user=='Client Admin'){
  2654.             $page='home/manage_pending_complaint.html.twig';
  2655.         }elseif($type_user=='Hypervisor'){
  2656.             $page='home/manage_pending_complaint.html.twig';
  2657.         }elseif($type_user=='Supervisor'){
  2658.             $page='supervisor/manage_pending_complaint.html.twig';
  2659.         }elseif($type_user=='Operational Manager'){
  2660.             $page='operational/manage_pending_complaint.html.twig';
  2661.         }else{
  2662.             $page='security/pagenotfound.html.twig';
  2663.         }
  2665.         return $this->render($page, 
  2666.             array(
  2667.                 // 'form'=>$form->createView(),
  2668.                 'client' => $client,
  2669.                 'datas'=>$datas,
  2670.                 'type_user'=>$type_user,
  2671.                 'roles_client'=>$roles_client,
  2672.                 'implode_pending'=>'',
  2673.                 'implode_assigned'=>'',
  2674.                 'implode_resolved'=>'',  
  2675.             )
  2676.         );
  2677.     }
  2679.      /**
  2680.      * @Route("/complaint_list/{type}/{id}", name="app_complaint_list")
  2681.      */
  2682.      public function complaint_list($type,$id)
  2683.      {
  2684.         if ($this->getUser()) {
  2685.             $client = $this->getUser();
  2686.         } else {
  2687.             return $this->redirectToRoute('user_login');
  2688.         }
  2689.         $user = $this->getUser();
  2690.         $type_user=$user->getType();
  2691.         $allid=explode(",", $user->getRolebyadmin());
  2692.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  2694.         if($type== 1){
  2695.           $agentid=$id;
  2696.           $detail=$this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$id,'type'=>"Agent",'status'=>true));
  2697.           $grpid=0;
  2698.           $operational_id=0;
  2699.           if(!empty($detail)){
  2700.                if($type_user=='SuperAdmin' || $type_user=='Client Admin'){
  2701.                  $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('city_id'=>$detail->getCityId(),'agentid'=>0,'show_status'=>1),array('id'=>'desc'));
  2702.                  foreach ($datas as $key => $value) {
  2703.                      $agentgrpname = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findOneBy(array('id'=>$value->getGrpid()),
  2704.                      array('id'=>'desc'),);
  2705.                      $datas[$key]->agent_grp_name=$agentgrpname;
  2707.                      $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2708.                          array('id'=>$value->getProvinceId()),
  2709.                      );
  2710.                      if(!empty($province)){
  2711.                          $datas[$key]->provinces=$province;
  2712.                      }else{
  2713.                          $datas[$key]->provinces="";
  2714.                      }
  2715.                      if($value->getFraud() == 1){
  2717.                          $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2718.                              array('complaint_id'=>$value->getId()),
  2719.                          );
  2720.                          if(!empty($FraudComplaint)){
  2721.                              $datas[$key]->fraudcomplaint=$FraudComplaint;
  2722.                          }else{
  2723.                              $datas[$key]->fraudcomplaint="";
  2724.                          }
  2726.                          $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2727.                          
  2728.                          if ($pv) {
  2729.                              $datas[$key]->fines =$pv;
  2730.                          } else {
  2731.                               $datas[$key]->fines ="";
  2732.                          }
  2734.                          $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2735.                              if ($fcp) {
  2736.                                  $datas[$key]->fc_product =$fcp;
  2737.                              } else {
  2738.                                   $datas[$key]->fc_product ="";
  2739.                              }
  2740.                      }
  2741.                  }
  2742.                }else{
  2743.                     $datas="";
  2744.                }
  2745.           }else{
  2746.                return $this->redirectToRoute('app_manage_oprational_manager');
  2747.           }
  2748.           
  2749.         }elseif($type== 2){
  2750.           $agentid=0;
  2751.           $grpid=$id;
  2752.           $detail = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findOneBy(array('id'=>$id,'status'=>true));
  2753.           $operational_id=0;
  2754.           if(!empty($detail)){
  2755.                if($type_user=='SuperAdmin' || $type_user=='Client Admin'){
  2756.                       $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('city_id'=>$detail->getCityId(),'grpid'=>0,'show_status'=>1),array('id'=>'desc'));
  2757.                       foreach ($datas as $key => $value) {
  2758.                           $agentgrpname = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findOneBy(array('id'=>$value->getGrpid()),
  2759.                           array('id'=>'desc'),);
  2760.                           $datas[$key]->agent_grp_name=$agentgrpname;
  2762.                           $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2763.                               array('id'=>$value->getProvinceId()),
  2764.                           );
  2765.                           if(!empty($province)){
  2766.                               $datas[$key]->provinces=$province;
  2767.                           }else{
  2768.                               $datas[$key]->provinces="";
  2769.                           }
  2770.                           if($value->getFraud() == 1){
  2772.                               $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2773.                                   array('complaint_id'=>$value->getId()),
  2774.                               );
  2775.                               if(!empty($FraudComplaint)){
  2776.                                   $datas[$key]->fraudcomplaint=$FraudComplaint;
  2777.                               }else{
  2778.                                   $datas[$key]->fraudcomplaint="";
  2779.                               }
  2781.                               $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2782.                               
  2783.                               if ($pv) {
  2784.                                   $datas[$key]->fines =$pv;
  2785.                               } else {
  2786.                                    $datas[$key]->fines ="";
  2787.                               }
  2789.                               $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2790.                                   if ($fcp) {
  2791.                                       $datas[$key]->fc_product =$fcp;
  2792.                                   } else {
  2793.                                        $datas[$key]->fc_product ="";
  2794.                                   }
  2795.                           }
  2796.                       }
  2797.                }else{
  2798.                     $datas="";
  2799.                }
  2800.           }else{
  2801.                return $this->redirectToRoute('app_manage_oprational_manager');
  2802.           }
  2803.         }elseif($type== 3){
  2804.           $agentid=0;
  2805.           $grpid=0;
  2806.           $detail=$this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$id,'type'=>"Operational Manager",'status'=>true));
  2807.           $operational_id=$id;
  2808.           if(!empty($detail)){
  2809.                if($type_user=='SuperAdmin' || $type_user=='Client Admin'){
  2810.                       $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('city_id'=>$detail->getCityId(),'operational_id'=>0,'show_status'=>1),array('id'=>'desc'));
  2811.                       foreach ($datas as $key => $value) {
  2812.                           $agentgrpname = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findOneBy(array('id'=>$value->getGrpid()),
  2813.                           array('id'=>'desc'),);
  2814.                           $datas[$key]->agent_grp_name=$agentgrpname;
  2816.                           $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  2817.                               array('id'=>$value->getProvinceId()),
  2818.                           );
  2819.                           if(!empty($province)){
  2820.                               $datas[$key]->provinces=$province;
  2821.                           }else{
  2822.                               $datas[$key]->provinces="";
  2823.                           }
  2824.                           if($value->getFraud() == 1){
  2826.                               $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  2827.                                   array('complaint_id'=>$value->getId()),
  2828.                               );
  2829.                               if(!empty($FraudComplaint)){
  2830.                                   $datas[$key]->fraudcomplaint=$FraudComplaint;
  2831.                               }else{
  2832.                                   $datas[$key]->fraudcomplaint="";
  2833.                               }
  2835.                               $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  2836.                               
  2837.                               if ($pv) {
  2838.                                   $datas[$key]->fines =$pv;
  2839.                               } else {
  2840.                                    $datas[$key]->fines ="";
  2841.                               }
  2843.                               $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  2844.                                   if ($fcp) {
  2845.                                       $datas[$key]->fc_product =$fcp;
  2846.                                   } else {
  2847.                                        $datas[$key]->fc_product ="";
  2848.                                   }
  2849.                           }
  2850.                       }
  2851.                }else{
  2852.                     $datas="";
  2853.                }
  2854.           }else{
  2855.                return $this->redirectToRoute('app_manage_oprational_manager');
  2856.           }
  2857.         }else{
  2858.           $agentid=0;
  2859.           $detail="";
  2860.           $grpid=0;
  2861.           $operational_id=0;
  2862.           $datas="";
  2863.         }
  2865.         if($type_user=='SuperAdmin'){
  2866.             $page='home/complaint_list.html.twig';
  2867.         }elseif($type_user=='Client Admin'){
  2868.             $page='home/complaint_list.html.twig';
  2869.         }else{
  2870.             $page='security/pagenotfound.html.twig';
  2871.         }
  2873.         return $this->render($page, 
  2874.             array(
  2875.                 // 'form'=>$form->createView(),
  2876.                 'client' => $client,
  2877.                 'datas'=>$datas,
  2878.                 'type_user'=>$type_user,
  2879.                 'roles_client'=>$roles_client, 
  2880.                 'agentid'=>$agentid, 
  2881.                 'grpid'=>$grpid, 
  2882.                 'operational_id'=>$operational_id, 
  2883.                 'type'=>$type, 
  2884.                 'id'=>$id, 
  2885.             )
  2886.         );
  2887.      }
  2890.      /**
  2891.      * @Route("/assing_complaint_user_grp", name="app_assing_complaint_user_grp")
  2892.      */
  2893.      public function manage_assing_complaint_user_grp(Request $request)
  2894.      {
  2895.           // dd($request->request->all());
  2896.         if ($this->getUser()) {
  2897.             $client = $this->getUser();
  2898.         } else {
  2899.             return $this->redirectToRoute('user_login');
  2900.         }
  2902.         $user = $this->getUser();
  2903.         $user_id=$user->getId();
  2904.        
  2905.         $em = $this->getDoctrine()->getManager();
  2906.         if ($request->getMethod() === "POST") {
  2907.                 
  2908.             if($request->request->get('grpid') !=0){
  2909.                 // code...
  2910.                $complaint_ids=$request->request->get('table_id');
  2911.                if(is_array($complaint_ids) == true){
  2912.                     foreach($complaint_ids as $key =>$complaint_id ){
  2913.                           $compstatus="Assign to agent group";
  2914.                           $updateRequest = $this->getDoctrine()->getRepository('App\Entity\Complaint')
  2915.                           ->find($complaint_id );
  2916.                           $updateRequest->setGrpid($request->request->get('grpid'));
  2917.                           $updateRequest->setCompstatus($compstatus);
  2918.                           $updateRequest->setAssignDate(date( "Y-m-d", strtotime(date('Y-m-d'))));
  2919.                           $updateRequest->setStatus('1');
  2920.                           $em = $this->getDoctrine()->getManager();
  2921.                           $em->persist($updateRequest);
  2922.                           $em->flush();
  2923.                     }
  2924.                }else{
  2925.                     if($client->getLang() == 'en'){
  2926.                        $this->addFlash('red', 'Please select at least one complaint ..!!'); 
  2927.                     }else{
  2928.                        $this->addFlash('red', 'Veuillez sélectionner au moins une plainte ..!!');  
  2929.                     }
  2930.                     return $this->redirectToRoute('app_manage_agent_group');
  2931.                }
  2932.                if($client->getLang() == 'en'){
  2933.                   $this->addFlash('green', 'Complaint assign successfully..!!'); 
  2934.                }else{
  2935.                   $this->addFlash('green', 'Plainte assignée avec succès..!!');  
  2936.                }
  2937.                
  2938.                return $this->redirectToRoute('app_manage_agent_group');
  2939.             }elseif($request->request->get('agentid') !=0){
  2940.                 // code...
  2941.                $complaint_ids=$request->request->get('table_id');
  2942.                if(is_array($complaint_ids) == true){
  2943.                     foreach($complaint_ids as $key =>$complaint_id ){
  2944.                           $compstatus="Assign to agent";
  2945.                           $updateRequest = $this->getDoctrine()->getRepository('App\Entity\Complaint')
  2946.                           ->find($complaint_id);
  2947.                           $updateRequest->setAgentid($request->request->get('agentid'));
  2948.                           $updateRequest->setCompstatus($compstatus);
  2949.                           $updateRequest->setAssignDate(date( "Y-m-d", strtotime(date('Y-m-d'))));
  2950.                           $updateRequest->setStatus('1');
  2951.                           $em = $this->getDoctrine()->getManager();
  2952.                           $em->persist($updateRequest);
  2953.                           $em->flush();
  2954.                     }
  2955.                }else{
  2956.                     if($client->getLang() == 'en'){
  2957.                        $this->addFlash('red', 'Please select at least one complaint ..!!'); 
  2958.                     }else{
  2959.                        $this->addFlash('red', 'Veuillez sélectionner au moins une plainte ..!!');  
  2960.                     }
  2961.                     return $this->redirectToRoute('app_manage_agent');
  2962.                }
  2963.                 if($client->getLang() == 'en'){
  2964.                   $this->addFlash('green', 'Complaint assign successfully..!!'); 
  2965.                }else{
  2966.                   $this->addFlash('green', 'Plainte assignée avec succès..!!');  
  2967.                }
  2968.                 return $this->redirectToRoute('app_manage_agent');
  2969.             }elseif($request->request->get('operational_id') !=0){
  2970.                 // code...
  2971.                $complaint_ids=$request->request->get('table_id');
  2972.                if(is_array($complaint_ids) == true){
  2973.                     foreach($complaint_ids as $key =>$complaint_id ){
  2974.                           $compstatus="Assign to operational manager";
  2975.                           $updateRequest = $this->getDoctrine()->getRepository('App\Entity\Complaint')
  2976.                           ->find($complaint_id);
  2977.                           $updateRequest->setOperationalId($request->request->get('operational_id'));
  2978.                           $updateRequest->setCompstatus($compstatus);
  2979.                           $updateRequest->setAssignDate(date( "Y-m-d", strtotime(date('Y-m-d'))));
  2980.                           $updateRequest->setStatus('1');
  2981.                           $em = $this->getDoctrine()->getManager();
  2982.                           $em->persist($updateRequest);
  2983.                           $em->flush();
  2984.                     }
  2985.                }else{
  2986.                     if($client->getLang() == 'en'){
  2987.                        $this->addFlash('red', 'Please select at least one complaint ..!!'); 
  2988.                     }else{
  2989.                        $this->addFlash('red', 'Veuillez sélectionner au moins une plainte ..!!');  
  2990.                     }
  2991.                     return $this->redirectToRoute('app_manage_oprational_manager');
  2992.                }
  2993.                
  2994.                if($client->getLang() == 'en'){
  2995.                   $this->addFlash('green', 'Complaint assign successfully..!!'); 
  2996.                }else{
  2997.                   $this->addFlash('green', 'Plainte assignée avec succès..!!');  
  2998.                }
  2999.                return $this->redirectToRoute('app_manage_oprational_manager');
  3000.             } 
  3002.         }
  3003.         return $this->redirectToRoute('app_manage_complaints');
  3004.      }
  3006.     /**
  3007.      * @Route("/previous_complaint", name="app_previous_complaint")
  3008.      */
  3009.     public function manage_previous_complaint(Request $request)
  3010.     {
  3011.         $input=$request->request->all();
  3012.         if ($this->getUser()) {
  3013.             $client = $this->getUser();
  3014.         } else {
  3015.             return $this->redirectToRoute('user_login');
  3016.         }
  3017.         $user = $this->getUser();
  3018.         $type_user=$user->getType();
  3019.         $allid=explode(",", $user->getRolebyadmin());
  3020.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  3021.         if($type_user=='Operational Manager'){
  3022.             $page='operational/manage_previous_complaint.html.twig';
  3023.             if(!empty($input)){
  3024.                 $dates=$request->request->get('reportrange_field');
  3025.                 $date=explode (" - ", $dates); 
  3026.                 // dd($dates);
  3027.                 if($dates !=""){
  3029.                     $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findDateRange($date[0],$date[1],$user->getCityId());
  3030.                          foreach ($datas as $key => $value) {
  3031.                          $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  3032.                          array('id'=>'desc'),);
  3033.                          $datas[$key]->agent_name=$agentname;
  3035.                          if($value->getFraud() == 1){
  3037.                              $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  3038.                                  array('complaint_id'=>$value->getId()),
  3039.                              );
  3040.                              if(!empty($FraudComplaint)){
  3041.                                  $datas[$key]->fraudcomplaint=$FraudComplaint;
  3042.                              }else{
  3043.                                  $datas[$key]->fraudcomplaint="";
  3044.                              }
  3045.                              $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  3046.                              if ($pv) {
  3047.                                  $datas[$key]->fines =$pv;
  3048.                              } else {
  3049.                                   $datas[$key]->fines ="";
  3050.                              }
  3052.                              $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  3053.                                  if ($fcp) {
  3054.                                      $datas[$key]->fc_product =$fcp;
  3055.                                  } else {
  3056.                                       $datas[$key]->fc_product ="";
  3057.                                  }
  3058.                          }
  3059.                      }
  3060.                 }else{
  3061.                     $datas ="";
  3062.                 }
  3063.                 
  3064.             }else{
  3065.                 $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(array('compstatus'=>'Resolved','city_id'=>$user->getCityId()),array('id'=>'desc'));
  3066.                 foreach ($datas as $key => $value) {
  3067.                     $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  3068.                     array('id'=>'desc'),);
  3069.                     $datas[$key]->agent_name=$agentname;
  3071.                     if($value->getFraud() == 1){
  3073.                         $FraudComplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findOneBy(
  3074.                             array('complaint_id'=>$value->getId()),
  3075.                         );
  3076.                         if(!empty($FraudComplaint)){
  3077.                             $datas[$key]->fraudcomplaint=$FraudComplaint;
  3078.                         }else{
  3079.                             $datas[$key]->fraudcomplaint="";
  3080.                         }
  3081.                         $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$FraudComplaint->getFine()));
  3082.                         if ($pv) {
  3083.                             $datas[$key]->fines =$pv;
  3084.                         } else {
  3085.                              $datas[$key]->fines ="";
  3086.                         }
  3088.                         $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$FraudComplaint->getId()));
  3089.                             if ($fcp) {
  3090.                                 $datas[$key]->fc_product =$fcp;
  3091.                             } else {
  3092.                                  $datas[$key]->fc_product ="";
  3093.                             }
  3094.                     }
  3095.                 }
  3096.             }
  3097.         }else{
  3098.             $datas="";
  3099.             $page='security/pagenotfound.html.twig';
  3100.         }
  3102.         return $this->render($page, 
  3103.             array(
  3104.                 // 'form'=>$form->createView(),
  3105.                 'client' => $client,
  3106.                 'datas'=>$datas,
  3107.                 'type_user'=>$type_user,
  3108.                 'roles_client'=>$roles_client,
  3109.                 'implode_pending'=>'',
  3110.                 'implode_assigned'=>'',
  3111.                 'implode_resolved'=>'',  
  3112.             )
  3113.         );
  3114.     }
  3117.     /**
  3118.      * @Route("/assing_complaint", name="app_assing_complaint")
  3119.      */
  3120.     public function manage_assing_complaint(Request $request)
  3121.     {
  3122.         if ($this->getUser()) {
  3123.             $client = $this->getUser();
  3124.         } else {
  3125.             return $this->redirectToRoute('user_login');
  3126.         }
  3128.         $user = $this->getUser();
  3129.         $user_id=$user->getId();
  3130.        
  3131.         $em = $this->getDoctrine()->getManager();
  3132.         if ($request->getMethod() === "POST") {
  3133.                 
  3134.             if(!empty($request->request->get('grpid'))){
  3135.                 // code...
  3136.                 $compstatus="Assign to agent group";
  3137.                 $updateRequest = $this->getDoctrine()->getRepository('App\Entity\Complaint')
  3138.                 ->find($request->request->get('table_id') );
  3139.                 $updateRequest->setGrpid($request->request->get('grpid'));
  3140.                 $updateRequest->setCompstatus($compstatus);
  3141.                 $updateRequest->setAssignDate(date( "Y-m-d", strtotime(date('Y-m-d'))));
  3142.                 $updateRequest->setStatus('1');
  3143.                 $em = $this->getDoctrine()->getManager();
  3144.                 $em->persist($updateRequest);
  3145.                 $em->flush();
  3146.                 if($client->getLang() == 'en'){
  3147.                   $this->addFlash('green', 'Complaint assign successfully..!!'); 
  3148.                }else{
  3149.                   $this->addFlash('green', 'Plainte assignée avec succès..!!');  
  3150.                }
  3151.             }elseif(!empty($request->request->get('agentid'))){
  3152.                 // code...
  3153.                 $compstatus="Assign to agent";
  3154.                 $updateRequest = $this->getDoctrine()->getRepository('App\Entity\Complaint')
  3155.                 ->find($request->request->get('table_id') );
  3156.                 $updateRequest->setAgentid($request->request->get('agentid'));
  3157.                 $updateRequest->setCompstatus($compstatus);
  3158.                 $updateRequest->setAssignDate(date( "Y-m-d", strtotime(date('Y-m-d'))));
  3159.                 $updateRequest->setStatus('1');
  3160.                 $em = $this->getDoctrine()->getManager();
  3161.                 $em->persist($updateRequest);
  3162.                 $em->flush();
  3163.                 if($client->getLang() == 'en'){
  3164.                   $this->addFlash('green', 'Complaint assign successfully..!!'); 
  3165.                }else{
  3166.                   $this->addFlash('green', 'Plainte assignée avec succès..!!');  
  3167.                }
  3168.             }elseif(!empty($request->request->get('operational_id'))){
  3169.                 // code...
  3170.                 $compstatus="Assign to operational manager";
  3171.                 $updateRequest = $this->getDoctrine()->getRepository('App\Entity\Complaint')
  3172.                 ->find($request->request->get('table_id') );
  3173.                 $updateRequest->setOperationalId($request->request->get('operational_id'));
  3174.                 $updateRequest->setCompstatus($compstatus);
  3175.                 $updateRequest->setAssignDate(date( "Y-m-d", strtotime(date('Y-m-d'))));
  3176.                 $updateRequest->setStatus('1');
  3177.                 $em = $this->getDoctrine()->getManager();
  3178.                 $em->persist($updateRequest);
  3179.                 $em->flush();
  3180.                 if($client->getLang() == 'en'){
  3181.                   $this->addFlash('green', 'Complaint assign successfully..!!'); 
  3182.                }else{
  3183.                   $this->addFlash('green', 'Plainte assignée avec succès..!!');  
  3184.                } 
  3185.             } 
  3187.         }
  3188.         return $this->redirectToRoute('app_manage_complaints');
  3189.     }
  3190.     
  3192.      /**
  3193.      * @Route("/assing_complaint_agent", name="app_assing_complaint_agent")
  3194.      */
  3195.      public function manage_assing_complaint_agent(Request $request)
  3196.      {
  3197.           if ($this->getUser()) {
  3198.                  $client = $this->getUser();
  3199.           } else {
  3200.                  return $this->redirectToRoute('user_login');
  3201.           }
  3203.         $user = $this->getUser();
  3204.         $user_id=$user->getId();
  3205.        
  3206.         $em = $this->getDoctrine()->getManager();
  3207.         if ($request->getMethod() === "POST") {
  3208.           $complaint_ids=$request->request->get('complaint_id');
  3209.      
  3210.           foreach($complaint_ids as $key =>$complaint_id ){
  3212.                 $compstatus="Assign to agent";
  3213.                 $ipadress=$request->getClientIp();
  3214.                 $updateRequest = $this->getDoctrine()->getRepository('App\Entity\Complaint')
  3215.                 ->find($complaint_id);
  3216.                 $updateRequest->setAgentid($request->request->get('agentid') );
  3217.                 $updateRequest->setCompstatus($compstatus);
  3218.                 $updateRequest->setAssignDate(date( "Y-m-d", strtotime(date('Y-m-d'))));
  3219.                 $updateRequest->setStatus('1');
  3220.                 $em = $this->getDoctrine()->getManager();
  3221.                 $em->persist($updateRequest);
  3222.                 $em->flush();
  3223.           }
  3224.           
  3225.           if($client->getLang() == 'en'){
  3226.              $this->addFlash('green', 'Complaint assign successfully..!!'); 
  3227.           }else{
  3228.              $this->addFlash('green', 'Plainte assignée avec succès..!!');  
  3229.           }
  3230.         }
  3231.         return $this->redirectToRoute('app_manage_agent');
  3232.      }
  3233.     
  3234.     /**
  3235.      * @Route("/update-request-status-complaint/{id}/{status}", name="update_status_complaint")
  3236.      */
  3237.     public function update_status_complaint(Complaint $request,$status)
  3238.     {
  3240.         $em = $this->getDoctrine()->getManager();
  3241.         $request->setStatus($status);
  3242.         $em->persist($request);
  3243.         $em->flush();
  3244.         if($status == 1){
  3245.             $this->addFlash('green', 'You have enable the complaint');
  3246.         }else{
  3247.             $this->addFlash('red', 'You have disable the complaint');
  3248.         }
  3249.         return $this->redirectToRoute('app_manage_complaints');
  3250.     }
  3252.     /**
  3253.      * @Route("/manage_oprational_manager", name="app_manage_oprational_manager")
  3254.      */
  3255.     public function manage_oprational_manager()
  3256.     {
  3257.         if ($this->getUser()) {
  3258.             $client = $this->getUser();
  3259.         } else {
  3260.             return $this->redirectToRoute('user_login');
  3261.         }
  3263.         $user = $this->getUser();
  3264.         $type_user=$user->getType();
  3265.         $allid=explode(",", $user->getRolebyadmin());
  3266.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  3268.         if($type_user=='SuperAdmin'){
  3269.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  3270.                 array('type'=>'Operational Manager'),
  3271.                 array('id'=>'desc'),
  3272.             );
  3273.         }elseif($type_user=='Client Admin'){
  3274.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  3275.                 array('type'=>'Operational Manager'),
  3276.                 array('id'=>'desc'),
  3277.             );
  3278.         }elseif($type_user=='Hypervisor'){
  3279.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  3280.                 array('city_id'=>$user->getCityId(),'type'=>'Operational Manager'),
  3281.                 array('id'=>'desc'),
  3282.             );
  3283.             if(!empty($datas)){
  3284.                 foreach ($datas as $key => $value) {
  3285.                     $agent_grp=$this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findOneBy( array('id'=>$value->getAgentgroupId()),array('id'=>'desc'));
  3287.                     $explode_agent=explode(",", $agent_grp->getAgentid());
  3288.                     $agents=$agt=$this->getDoctrine()->getRepository('App\Entity\User')->findAllIdField($explode_agent);
  3289.                     $datas[$key]->agent_detail=$agents;
  3290.                 }
  3291.                 
  3292.             }else{
  3293.                 $datas = "";
  3294.             }
  3295.         }elseif($type_user=='Supervisor'){
  3296.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  3297.                 array('city_id'=>$user->getCityId(),'type'=>'Operational Manager'),
  3298.                 array('id'=>'desc'),
  3299.             );
  3300.             if(!empty($datas)){
  3301.                 foreach ($datas as $key => $value) {
  3302.                     $agent_grp=$this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findOneBy( array('id'=>$value->getAgentgroupId()),array('id'=>'desc'));
  3303.                     if(!empty($agent_grp)){
  3304.                         $explode_agent=explode(",", $agent_grp->getAgentid());
  3305.                     }else{
  3306.                         $explode_agent="";
  3307.                     }
  3308.                     
  3309.                     $agents=$agt=$this->getDoctrine()->getRepository('App\Entity\User')->findAllIdField($explode_agent);
  3310.                     $datas[$key]->agent_detail=$agents;
  3311.                 }
  3312.                 
  3313.             }else{
  3314.                 $datas = "";
  3315.             }
  3316.         }else{
  3317.              $datas = "";
  3318.         }
  3320.         
  3322.         $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findBy(
  3323.             array('code'=>'FR'),
  3324.             array('name'=>'asc'),
  3325.         );
  3326.         $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findBy(array(),
  3327.             array('name'=>'asc'),
  3328.         );
  3330.         $agentgroups = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findBy(array('status' => true),array('id'=>'desc'));
  3332.         if($type_user=='SuperAdmin'){
  3333.             $page='home/manage_oprational_manager.html.twig';
  3334.         }elseif($type_user=='Client Admin'){
  3335.             $page='home/manage_oprational_manager.html.twig';
  3336.         }elseif($type_user=='Hypervisor'){
  3337.             $page='hypervisor/manage_oprational_manager.html.twig';
  3338.         }elseif($type_user=='Supervisor'){
  3339.             $page='supervisor/manage_oprational_manager.html.twig';
  3340.         }else{
  3341.             $page='security/pagenotfound.html.twig';
  3342.         }
  3344.         return $this->render($page, 
  3345.             array(
  3346.                 // 'form'=>$form->createView(),
  3347.                 'client' => $client,
  3348.                 'datas'=>$datas,
  3349.                 'countrys'=>$countrys,
  3350.                 'citys'=>$citys,
  3351.                 'agentgroups'=>$agentgroups,
  3352.                 'type_user'=>$type_user,
  3353.                 'roles_client'=>$roles_client,
  3354.                 'implode_pending'=>'',
  3355.                 'implode_assigned'=>'',
  3356.                 'implode_resolved'=>'',  
  3357.             )
  3358.         );
  3359.     }
  3361.     /**
  3362.      * @Route("/create_manage_oprational_manager", name="app_create_manage_oprational_manager")
  3363.      */
  3364.     public function create_manage_oprational_manager(Request $request, UserPasswordEncoderInterface $passwordEncoder, \Swift_Mailer $mailer)
  3365.     {
  3366.         if ($this->getUser()) {
  3367.             $client = $this->getUser();
  3368.         } else {
  3369.             return $this->redirectToRoute('user_login');
  3370.         }
  3372.         $user = $this->getUser();
  3373.         $user_id=$user->getId();        
  3375.         $em = $this->getDoctrine()->getManager();
  3376.         if ($request->getMethod() === "POST") {
  3377.             $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findOneBy(
  3378.             array('id'=>$request->request->get('country')),
  3379.             );
  3380.             $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  3381.                 array('id'=>$request->request->get('city')),
  3382.             );    
  3383.             if($request->request->get('table_id') !=""){
  3384.                 $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBySomeField(array('value'=>$request->request->get('table_id')),array('email'=>$request->request->get('email')));
  3385.                 if (empty($result)) {   
  3386.                     $ipadress=$request->getClientIp();
  3387.                     $updateRequest = $this->getDoctrine()->getRepository('App\Entity\User')
  3388.                     ->find($request->request->get('table_id') );
  3389.                     $updateRequest->setName($request->request->get('name') );
  3390.                     $updateRequest->setEmail($request->request->get('email'));
  3391.                     $updateRequest->setMobile($request->request->get('mobile'));
  3392.                     $updateRequest->setAgentgroupId($request->request->get('agentgroup_id'));
  3393.                     $updateRequest->setCountry($countrys);
  3394.                     $updateRequest->setCity($citys);
  3395.                     $updateRequest->setProvinceId('0');
  3396.                     $updateRequest->setLang('fr');
  3397.                     $updateRequest->setIpaddress($ipadress);
  3399.                     $em = $this->getDoctrine()->getManager();
  3400.                     $em->persist($updateRequest);
  3401.                     $em->flush();
  3403.                     if($client->getLang() == 'en'){
  3404.                        $this->addFlash('green', 'Operational manager update successfully..!!');  
  3405.                     }else{
  3406.                        $this->addFlash('green', 'Mise à jour réussie du gestionnaire opérationnel..!!');  
  3407.                     }
  3408.                 }else{
  3409.                     if($client->getLang() == 'en'){
  3410.                        $this->addFlash('red', 'There is already an account with this email');
  3411.                     }else{
  3412.                        $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  3413.                     }
  3414.                 }
  3415.             }else{
  3416.                 $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('email'=>$request->request->get('email')),array('id'=>'desc'));
  3417.                 if (empty($result)) {
  3418.                     
  3419.                     $omid= $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('type'=>'Operational Manager'),array('id'=>'desc'),);
  3420.                     if(!empty($omid)){
  3421.                         $idno=explode("OM", $omid->getUserId());
  3422.                         $n=$idno[1];
  3423.                         $n2 = str_pad($n + 1, 5, 0, STR_PAD_LEFT);
  3424.                     }else{
  3425.                         $n2="00001";
  3426.                     }
  3428.                     $random_password = substr(md5(random_bytes(20)),1,25);
  3429.                     $newPassword ='123456';
  3430.                     $userid ='OM'.$n2;
  3431.                     $ipadress=$request->getClientIp();
  3432.                     $addRequest = new User;
  3433.                     $addRequest->setAddedBy($user_id);
  3434.                     $addRequest->setUserId($userid);
  3435.                     $addRequest->setName($request->request->get('name') );
  3436.                     $addRequest->setEmail($request->request->get('email'));
  3437.                     $addRequest->setLang('fr');
  3438.                     $addRequest->setMobile($request->request->get('mobile'));
  3439.                     $addRequest->setProvinceId('0');
  3440.                     
  3441.                     $addRequest->setAgentgroupId($request->request->get('agentgroup_id'));
  3442.                     $addRequest->setPassword($passwordEncoder->encodePassword(
  3443.                         $addRequest,
  3444.                         $newPassword
  3445.                     ));
  3446.                     $addRequest->setPasswordResetToken($random_password);
  3447.                     $addRequest->setCountry($countrys);
  3448.                     $addRequest->setCity($citys);
  3449.                     $addRequest->setStatus('1');
  3450.                     $addRequest->setType('Operational Manager');
  3451.                     $addRequest->setRoles(["ROLE_OPERATIONALMANAGER"]);
  3452.                     $addRequest->setIpaddress($ipadress);
  3453.                     $em = $this->getDoctrine()->getManager();
  3454.                     $em->persist($addRequest);
  3455.                     $em->flush();
  3457.                     $url = $this->urlGenerator->generate('reset_password', array('code'=>$random_password), UrlGeneratorInterface::ABSOLUTE_URL);
  3458.                     $sendTo = $request->request->get('email');
  3459.                     $sendCc = 'santosh.jaiswal.espl@gmail.com';
  3460.                     $mailArray = array(
  3461.                         'email' => 'infos-compte@konsoplus.com',
  3462.                         'emailid' => $request->request->get('email'),
  3463.                         'mobile' => $request->request->get('mobile'),
  3464.                         'name' => $request->request->get('name'),
  3465.                         'city' => $citys->getName(),
  3466.                         'url' => $url,
  3467.                         'password' => $random_password
  3468.                     );
  3470.                     $mail = $this->mailer->sendEmailMessage(
  3471.                         'Renouveler votre mot de passe',
  3472.                         "Konso+",
  3473.                         $sendTo,
  3474.                         $sendCc,
  3475.                         null,
  3476.                         'security/welcomemail.html.twig',
  3477.                         $mailArray
  3478.                     );
  3480.                     if($client->getLang() == 'en'){
  3481.                        $this->addFlash('green', 'Operational manager added successfully..!!');  
  3482.                     }else{
  3483.                        $this->addFlash('green', "Ajout d'un gestionnaire opérationnel avec succès..!!");  
  3484.                     }
  3485.                      
  3486.                 }else{
  3487.                     if($client->getLang() == 'en'){
  3488.                        $this->addFlash('red', 'There is already an account with this email');
  3489.                     }else{
  3490.                        $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  3491.                     }
  3492.                 }
  3493.             }    
  3494.         }
  3496.         return $this->redirectToRoute('app_manage_oprational_manager');
  3497.     }
  3498.         
  3499.     /**
  3500.      * @Route("/update-request-status-oprational/{id}/{status}", name="update_user_status_oprational_manager")
  3501.      */
  3502.     public function update_status_oprational_manager(User $request,$status)
  3503.     {
  3504.           if ($this->getUser()) {
  3505.               $client = $this->getUser();
  3506.           } else {
  3507.               return $this->redirectToRoute('user_login');
  3508.           }
  3509.         $em = $this->getDoctrine()->getManager();
  3510.         $request->setStatus($status);
  3511.         $em->persist($request);
  3512.         $em->flush();
  3513.         if($status == 1){
  3514.           if($client->getLang() == 'en'){
  3515.              $this->addFlash('green', 'You have enable the operational manager');  
  3516.           }else{
  3517.              $this->addFlash('green', 'Vous avez activé le responsable opérationnel'); 
  3518.           }
  3519.             
  3520.         }else{
  3521.           if($client->getLang() == 'en'){
  3522.              $this->addFlash('red', 'You have disable the operational manager'); 
  3523.           }else{
  3524.              $this->addFlash('red', 'Vous avez désactivé le gestionnaire opérationnel'); 
  3525.           }
  3526.             
  3527.         }
  3528.         return $this->redirectToRoute('app_manage_oprational_manager');
  3529.     }
  3531.      /**
  3532.      * @Route("/request-oprational-delete/{id}", name="app_user_delete_oprational_manager")
  3533.      */
  3534.      public function oprational_manager_delete(User $request,$id)
  3535.      {
  3536.         $em = $this->getDoctrine()->getManager();
  3537.         $request->getId($id);
  3538.         $em->remove($request);
  3539.         $em->flush();
  3541.         $this->addFlash('green','Operational manager deleted successfully..!!');
  3543.         return $this->redirectToRoute('app_manage_oprational_manager');
  3544.      }
  3545.     
  3546.     /**
  3547.      * @Route("/manage_financial_manager", name="app_manage_financial_manager")
  3548.      */
  3549.     public function manage_financial_manager()
  3550.     {
  3551.         if ($this->getUser()) {
  3552.             $client = $this->getUser();
  3553.         } else {
  3554.             return $this->redirectToRoute('user_login');
  3555.         }
  3557.         $user = $this->getUser();
  3558.         $type_user=$user->getType();
  3559.         $allid=explode(",", $user->getRolebyadmin());
  3560.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  3561.         if($type_user == "SuperAdmin" || $type_user == "Client Admin"){
  3563.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  3564.                 array('type'=>'Financial Manager'),
  3565.                 array('id'=>'desc'),
  3566.             );
  3567.             $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findBy(
  3568.                 array('code'=>'FR'),
  3569.                 array('name'=>'asc'),
  3570.             );
  3571.             $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findBy(array(),
  3572.                 array('name'=>'asc'),
  3573.             );
  3574.           $page='home/manage_financial_manager.html.twig';
  3575.         }else{
  3576.             $page='security/pagenotfound.html.twig';
  3577.             $datas = "";
  3578.             $citys ="";
  3579.             $countrys ="";
  3580.         }
  3581.         return $this->render($page, 
  3582.             array(
  3583.                 'client' => $client,
  3584.                 'datas'=>$datas,
  3585.                 'countrys'=>$countrys,
  3586.                 'citys'=>$citys,
  3587.                 'type_user'=>$type_user,
  3588.                 'roles_client'=>$roles_client,
  3589.                 'implode_pending'=>'',
  3590.                 'implode_assigned'=>'',
  3591.                 'implode_resolved'=>'',  
  3592.             )
  3593.         );
  3594.     }
  3596.     /**
  3597.      * @Route("/create_manage_financial_manager", name="app_create_manage_financial_manager")
  3598.      */
  3599.     public function create_manage_financial_manager(Request $request, UserPasswordEncoderInterface $passwordEncoder)
  3600.     {
  3601.         if ($this->getUser()) {
  3602.             $client = $this->getUser();
  3603.         } else {
  3604.             return $this->redirectToRoute('user_login');
  3605.         }
  3607.         $user = $this->getUser();
  3608.         $user_id=$user->getId();
  3609.    
  3610.         $em = $this->getDoctrine()->getManager();
  3611.         if ($request->getMethod() === "POST") {
  3612.             $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findOneBy(
  3613.             array('id'=>$request->request->get('country')),
  3614.             );
  3615.             $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  3616.                 array('id'=>$request->request->get('city')),
  3617.             );
  3618.             if($request->request->get('table_id') !=""){
  3619.                 $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBySomeField(array('value'=>$request->request->get('table_id')),array('email'=>$request->request->get('email')));
  3620.                 if (empty($result)) {   
  3621.                     $ipadress=$request->getClientIp();
  3622.                     $updateRequest = $this->getDoctrine()->getRepository('App\Entity\User')
  3623.                     ->find($request->request->get('table_id') );
  3624.                     $updateRequest->setName($request->request->get('name') );
  3625.                     $updateRequest->setEmail($request->request->get('email'));
  3626.                     $updateRequest->setMobile($request->request->get('mobile'));
  3627.                     $updateRequest->setAgentgroupId('0');
  3628.                     $updateRequest->setCountry($countrys);
  3629.                     $updateRequest->setCity($citys);
  3630.                     $updateRequest->setProvinceId('0');
  3631.                     $updateRequest->setIpaddress($ipadress);
  3633.                     $em = $this->getDoctrine()->getManager();
  3634.                     $em->persist($updateRequest);
  3635.                     $em->flush();
  3636.                     if($client->getLang() == 'en'){
  3637.                        $this->addFlash('green', 'Financial manager update successfully..!!'); 
  3638.                     }else{
  3639.                        $this->addFlash('green', 'Mise à jour réussie du gestionnaire financier..!!'); 
  3640.                     }
  3641.                     
  3642.                 } else {
  3643.                     if($client->getLang() == 'en'){
  3644.                        $this->addFlash('red', 'There is already an account with this email');
  3645.                     }else{
  3646.                        $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  3647.                     }
  3648.                 }
  3649.             }else{
  3650.                 $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('email'=>$request->request->get('email')),array('id'=>'desc'));
  3651.                 if (empty($result)) {
  3652.                     $fmid= $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('type'=>'Financial Manager'),array('id'=>'desc'),);
  3653.                     if(!empty($fmid)){
  3654.                         $idno=explode("FM", $fmid->getUserId());
  3655.                         $n=$idno[1];
  3656.                         $n2 = str_pad($n + 1, 5, 0, STR_PAD_LEFT);
  3657.                     }else{
  3658.                         $n2="00001";
  3659.                     }
  3661.                     $random_password = substr(md5(random_bytes(20)),1,25);
  3662.                     $newPassword ='123456';
  3663.                     $userid ='FM'.$n2;
  3664.                     $ipadress=$request->getClientIp();
  3665.                     $addRequest = new User;
  3666.                     $addRequest->setAddedBy($user_id);
  3667.                     $addRequest->setUserId($userid);
  3668.                     $addRequest->setName($request->request->get('name') );
  3669.                     $addRequest->setEmail($request->request->get('email'));
  3670.                     $addRequest->setMobile($request->request->get('mobile'));
  3671.                     $addRequest->setPassword($passwordEncoder->encodePassword(
  3672.                         $addRequest,
  3673.                         $newPassword
  3674.                     ));
  3675.                     $addRequest->setPasswordResetToken($random_password);
  3676.                     $addRequest->setCountry($countrys);
  3677.                     $addRequest->setCity($citys);
  3678.                     $addRequest->setProvinceId('0');
  3679.                     $addRequest->setStatus('1');
  3680.                     $addRequest->setAgentgroupId('0');
  3681.                     $addRequest->setLang('fr');
  3682.                     $addRequest->setType('Financial Manager');
  3683.                     $addRequest->setRoles(["ROLE_FINANCIALMANAGER"]);
  3684.                     $addRequest->setIpaddress($ipadress);
  3685.                     $em = $this->getDoctrine()->getManager();
  3686.                     $em->persist($addRequest);
  3687.                     $em->flush();
  3690.                     $url = $this->urlGenerator->generate('reset_password', array('code'=>$random_password), UrlGeneratorInterface::ABSOLUTE_URL);
  3691.                     $sendTo = $request->request->get('email');
  3692.                     $sendCc = 'santosh.jaiswal.espl@gmail.com';
  3693.                     $mailArray = array(
  3694.                         'email' => 'infos-compte@konsoplus.com',
  3695.                         'emailid' => $request->request->get('email'),
  3696.                         'mobile' => $request->request->get('mobile'),
  3697.                         'name' => $request->request->get('name'),
  3698.                         'city' => $citys->getName(),
  3699.                         'url' => $url,
  3700.                         'password' => $random_password
  3701.                     );
  3703.                     $mail = $this->mailer->sendEmailMessage(
  3704.                         'Renouveler votre mot de passe',
  3705.                         "Konso+",
  3706.                         $sendTo,
  3707.                         $sendCc,
  3708.                         null,
  3709.                         'security/welcomemail.html.twig',
  3710.                         $mailArray
  3711.                     );
  3713.                     if($client->getLang() == 'en'){
  3714.                        $this->addFlash('green', 'Financial manager added successfully..!!');
  3715.                     }else{
  3716.                        $this->addFlash('green', "Ajout d'un directeur financier avec succès..!!"); 
  3717.                     }
  3718.                      
  3719.                 } else {
  3720.                     if($client->getLang() == 'en'){
  3721.                        $this->addFlash('red', 'There is already an account with this email');
  3722.                     }else{
  3723.                        $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  3724.                     }
  3725.                 }    
  3726.             }    
  3727.         }
  3728.         return $this->redirectToRoute('app_manage_financial_manager');
  3729.     }
  3730.         
  3731.      /**
  3732.      * @Route("/update-request-status-financial/{id}/{status}", name="update_user_status_financial_manager")
  3733.      */
  3734.      public function update_status_financial_manager(User $request,$status)
  3735.      {
  3736.           if ($this->getUser()) {
  3737.               $client = $this->getUser();
  3738.           } else {
  3739.               return $this->redirectToRoute('user_login');
  3740.           }
  3741.           $em = $this->getDoctrine()->getManager();
  3742.           $request->setStatus($status);
  3743.           $em->persist($request);
  3744.           $em->flush();
  3745.           if($status == 1){
  3746.                if($client->getLang() == 'en'){
  3747.                    $this->addFlash('green', 'You have enable the financial manager');
  3748.                }else{
  3749.                    $this->addFlash('green', 'Vous avez permis au directeur financier');
  3750.                }
  3751.            
  3752.           }else{
  3753.                if($client->getLang() == 'en'){
  3754.                   $this->addFlash('red', 'You have disable the financial manager');
  3755.                }else{
  3756.                   $this->addFlash('red', "Vous avez mis hors d'état de nuire le directeur financier");
  3757.                }  
  3758.           }
  3759.           return $this->redirectToRoute('app_manage_financial_manager');
  3760.      }
  3762.      /**
  3763.      * @Route("/request-financial-delete/{id}", name="app_user_delete_financial_manager")
  3764.      */
  3765.      public function financial_manager_delete(User $request,$id)
  3766.      {     
  3767.           if ($this->getUser()) {
  3768.               $client = $this->getUser();
  3769.           } else {
  3770.               return $this->redirectToRoute('user_login');
  3771.           }
  3772.         $em = $this->getDoctrine()->getManager();
  3773.         $request->getId($id);
  3774.         $em->remove($request);
  3775.         $em->flush();
  3777.         $this->addFlash('green','Financial manager deleted successfully..!!');
  3779.         return $this->redirectToRoute('app_manage_financial_manager');
  3780.     }
  3782.     /**
  3783.      * @Route("/manage_hypervisor", name="app_manage_hypervisor")
  3784.      */
  3785.     public function manage_hypervisor()
  3786.     {
  3787.         if ($this->getUser()) {
  3788.             $client = $this->getUser();
  3789.         } else {
  3790.             return $this->redirectToRoute('user_login');
  3791.         }
  3792.         $user = $this->getUser();
  3793.         $type_user=$user->getType();
  3794.         $allid=explode(",", $user->getRolebyadmin());
  3795.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  3796.         if($type_user == "SuperAdmin" || $type_user == "Client Admin"){
  3798.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  3799.                 array('type'=>'Hypervisor'),
  3800.                 array('id'=>'desc'),
  3801.             );
  3802.             foreach($datas as $key => $value){
  3803.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  3804.                     array('id'=>$value->getProvinceId()),
  3805.                 );
  3806.                 if(!empty($province)){
  3807.                     $datas[$key]->province=$province;
  3808.                 }else{
  3809.                     $datas[$key]->province="";
  3810.                 }
  3811.             }
  3812.             $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findBy(
  3813.                 array('code'=>'FR'),
  3814.                 array('name'=>'asc'),
  3815.             );
  3816.             $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findBy(array(),
  3817.                 array('name'=>'asc'),
  3818.             );
  3819.             $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findBy(
  3820.                 array(),
  3821.                 array('name'=>'asc'),
  3822.             );
  3823.           $page='home/hypervisor.html.twig';
  3824.         }else{
  3825.             $page='security/pagenotfound.html.twig';
  3826.             $datas = "";
  3827.             $citys ="";
  3828.             $province ="";
  3829.             $countrys ="";
  3830.         }
  3831.         return $this->render($page, 
  3832.             array(
  3833.                 'client' => $client,
  3834.                 'datas'=>$datas,
  3835.                 'countrys'=>$countrys,
  3836.                 'citys'=>$citys,
  3837.                 'type_user'=>$type_user,
  3838.                 'roles_client'=>$roles_client,
  3839.                 'implode_pending'=>'',
  3840.                 'implode_assigned'=>'',
  3841.                 'implode_resolved'=>'',  
  3842.                 'province'=>$province,
  3843.             )
  3844.         );
  3845.     }
  3847.     /**
  3848.      * @Route("/create_manage_hypervisor", name="app_create_manage_hypervisor")
  3849.      */
  3850.     public function create_manage_hypervisor(Request $request, UserPasswordEncoderInterface $passwordEncoder, \Swift_Mailer $mailer)
  3851.     {
  3852.         if ($this->getUser()) {
  3853.             $client = $this->getUser();
  3854.         } else {
  3855.             return $this->redirectToRoute('user_login');
  3856.         }
  3858.         $user = $this->getUser();
  3859.         $user_id=$user->getId();
  3860.             
  3861.         $em = $this->getDoctrine()->getManager();
  3862.         if ($request->getMethod() === "POST") {
  3863.             $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findOneBy(
  3864.             array('id'=>$request->request->get('country')),
  3865.             );
  3866.             $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  3867.                 array('id'=>$request->request->get('city')),
  3868.             );
  3869.             $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  3870.                 array('id'=>$request->request->get('province')),
  3871.             );
  3872.             if($request->request->get('table_id') !=""){
  3873.                 $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBySomeField(array('value'=>$request->request->get('table_id')),array('email'=>$request->request->get('email')));
  3874.                 if(empty($result)){  
  3875.                     $ipadress=$request->getClientIp();
  3876.                     $updateRequest = $this->getDoctrine()->getRepository('App\Entity\User')
  3877.                     ->find($request->request->get('table_id') );
  3878.                     $updateRequest->setName($request->request->get('name') );
  3879.                     $updateRequest->setEmail($request->request->get('email'));
  3880.                     $updateRequest->setMobile($request->request->get('mobile'));
  3881.                     $updateRequest->setCountry($countrys);
  3882.                     $updateRequest->setCity($citys);
  3883.                     $updateRequest->setProvinceId($request->request->get('province'));
  3884.                     $updateRequest->setAgentgroupId('0');
  3885.                     $updateRequest->setIpaddress($ipadress);
  3887.                     $em = $this->getDoctrine()->getManager();
  3888.                     $em->persist($updateRequest);
  3889.                     $em->flush();
  3891.                     if($client->getLang() == 'en'){
  3892.                        $this->addFlash('green', 'Hypervisor Update successfully..!!'); 
  3893.                     }else{
  3894.                        $this->addFlash('green', "Mise à jour de l'hyperviseur réussie..!!"); 
  3895.                     } 
  3896.                 }else{
  3897.                     if($client->getLang() == 'en'){
  3898.                        $this->addFlash('red', 'There is already an account with this email');
  3899.                     }else{
  3900.                        $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  3901.                     }
  3902.                 }
  3903.             }else{
  3904.                 $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('email'=>$request->request->get('email')),array('id'=>'desc'));
  3905.                 if (empty($result)) {
  3906.                     $hyid= $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('type'=>'Hypervisor'),array('id'=>'desc'),);
  3907.                     if(!empty($hyid)){
  3908.                         $idno=explode("HY", $hyid->getUserId());
  3909.                         $n=$idno[1];
  3910.                         $n2 = str_pad($n + 1, 5, 0, STR_PAD_LEFT);
  3911.                     }else{
  3912.                         $n2="00001";
  3913.                     }
  3915.                     $random_password = substr(md5(random_bytes(20)),1,25);
  3916.                     $newPassword ='123456';
  3917.                     $userid ='HY'.$n2;
  3918.                     $ipadress=$request->getClientIp();
  3919.                     $addRequest = new User;
  3920.                     $addRequest->setAddedBy($user_id);
  3921.                     $addRequest->setUserId($userid);
  3922.                     $addRequest->setName($request->request->get('name') );
  3923.                     $addRequest->setEmail($request->request->get('email'));
  3924.                     $addRequest->setMobile($request->request->get('mobile'));
  3925.                     $addRequest->setPassword($passwordEncoder->encodePassword(
  3926.                         $addRequest,
  3927.                         $newPassword
  3928.                     ));
  3929.                     $addRequest->setPasswordResetToken($random_password);
  3930.                     $addRequest->setCountry($countrys);
  3931.                     $addRequest->setCity($citys);
  3932.                     $addRequest->setProvinceId($request->request->get('province'));
  3933.                     $addRequest->setStatus('1');
  3934.                     $addRequest->setAgentgroupId('0');
  3935.                     $addRequest->setLang('fr');
  3936.                     $addRequest->setType('Hypervisor');
  3937.                     $addRequest->setRoles(["ROLE_HYPERVISOR"]);
  3938.                     $addRequest->setIpaddress($ipadress);
  3939.                     $em = $this->getDoctrine()->getManager();
  3940.                     $em->persist($addRequest);
  3941.                     $em->flush();
  3944.                     $url = $this->urlGenerator->generate('reset_password', array('code'=>$random_password), UrlGeneratorInterface::ABSOLUTE_URL);
  3945.                     $sendTo = $request->request->get('email');
  3946.                     $sendCc = 'santosh.jaiswal.espl@gmail.com';
  3947.                     $mailArray = array(
  3948.                         'email' => 'infos-compte@konsoplus.com',
  3949.                         'emailid' => $request->request->get('email'),
  3950.                         'mobile' => $request->request->get('mobile'),
  3951.                         'name' => $request->request->get('name'),
  3952.                         'city' => $citys->getName(),
  3953.                         'url' => $url,
  3954.                         'password' => $random_password
  3955.                     );
  3957.                     $mail = $this->mailer->sendEmailMessage(
  3958.                         'Renouveler votre mot de passe',
  3959.                         "Konso+",
  3960.                         $sendTo,
  3961.                         $sendCc,
  3962.                         null,
  3963.                         'security/welcomemail.html.twig',
  3964.                         $mailArray
  3965.                     );
  3967.                     if($client->getLang() == 'en'){
  3968.                        $this->addFlash('green', 'Hypervisor added successfully..!!'); 
  3969.                     }else{
  3970.                        $this->addFlash('green', 'Hyperviseur ajouté avec succès..!!'); 
  3971.                     } 
  3972.                 } else {
  3973.                     if($client->getLang() == 'en'){
  3974.                        $this->addFlash('red', 'There is already an account with this email');
  3975.                     }else{
  3976.                        $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  3977.                     }
  3978.                 }
  3979.             }    
  3980.         }
  3981.         
  3983.         return $this->redirectToRoute('app_manage_hypervisor');
  3984.     }
  3985.         
  3986.      /**
  3987.      * @Route("/update-request-status-hypervisor/{id}/{status}", name="update_user_status_hypervisor")
  3988.      */
  3989.      public function update_status_hypervisor(User $request,$status)
  3990.      {
  3991.           if ($this->getUser()) {
  3992.                $client = $this->getUser();
  3993.           } else {
  3994.                return $this->redirectToRoute('user_login');
  3995.           }
  3996.           $em = $this->getDoctrine()->getManager();
  3997.           $request->setStatus($status);
  3998.           $em->persist($request);
  3999.           $em->flush();
  4000.           if($status == 1){
  4001.                if($client->getLang() == 'en'){
  4002.                   $this->addFlash('green', 'You have enable the hypervisor'); 
  4003.                }else{
  4004.                   $this->addFlash('green', "Vous avez activé l'hyperviseur"); 
  4005.                } 
  4006.           }else{
  4007.                if($client->getLang() == 'en'){
  4008.                   $this->addFlash('red', 'You have disable the hypervisor');
  4009.                }else{
  4010.                   $this->addFlash('red', "Vous avez désactivé l'hyperviseur");
  4011.                } 
  4012.           }
  4013.           return $this->redirectToRoute('app_manage_hypervisor');
  4014.      }
  4016.     /**
  4017.      * @Route("/request-hypervisor-delete/{id}", name="app_user_delete_hypervisor")
  4018.      */
  4020.     public function hypervisor_delete(User $request,$id)
  4021.     {
  4022.         $em = $this->getDoctrine()->getManager();
  4023.         $request->getId($id);
  4024.         $em->remove($request);
  4025.         $em->flush();
  4027.         $this->addFlash('green','Hypervisor deleted successfully..!!');
  4029.         return $this->redirectToRoute('app_manage_hypervisor');
  4030.     }
  4032.     /**
  4033.      * @Route("/manage_supervisor", name="app_manage_supervisor")
  4034.      */
  4035.     public function manage_supervisor()
  4036.     {
  4037.         if ($this->getUser()) {
  4038.             $client = $this->getUser();
  4039.         } else {
  4040.             return $this->redirectToRoute('user_login');
  4041.         }
  4042.         $user = $this->getUser();
  4043.         $type_user=$user->getType();
  4044.         $allid=explode(",", $user->getRolebyadmin());
  4045.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  4047.         if($type_user=='SuperAdmin'){
  4048.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  4049.                 array('type'=>'Supervisor'),
  4050.                 array('id'=>'desc'),
  4051.             );
  4052.             foreach($datas as $key => $value){
  4053.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  4054.                     array('id'=>$value->getProvinceId()),
  4055.                 );
  4056.                 if(!empty($province)){
  4057.                     $datas[$key]->province=$province;
  4058.                 }else{
  4059.                     $datas[$key]->province="";
  4060.                 }
  4061.             }
  4062.         }elseif($type_user=='Client Admin'){
  4063.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  4064.                 array('type'=>'Supervisor'),
  4065.                 array('id'=>'desc'),
  4066.             );
  4067.             foreach($datas as $key => $value){
  4068.                 $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  4069.                     array('id'=>$value->getProvinceId()),
  4070.                 );
  4071.                 if(!empty($province)){
  4072.                     $datas[$key]->province=$province;
  4073.                 }else{
  4074.                     $datas[$key]->province="";
  4075.                 }
  4076.             }
  4077.         }elseif($type_user=='Hypervisor'){
  4078.             $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  4079.                 array('city_id'=>$user->getCityId(),'type'=>'Supervisor'),
  4080.                 array('id'=>'desc'),
  4081.             );
  4083.             foreach($datas as $key => $value){
  4084.                 $agents = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  4085.                     array('type'=>'Agent','city_id'=>$value->getCityId()),
  4086.                     array('id'=>'desc'),
  4087.                 );
  4088.                 $datas[$key]->agent_detail=$agents;
  4089.             }
  4090.             
  4091.         }else{
  4092.            $datas=""; 
  4093.         }
  4095.         $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findBy(
  4096.             array('code'=>'FR'),
  4097.             array('name'=>'asc'),
  4098.         );
  4099.         $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findBy(array(),
  4100.             array('name'=>'asc'),
  4101.         );
  4102.         $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findBy(
  4103.                 array(),
  4104.                 array('name'=>'asc'),
  4105.             );
  4107.         if($type_user=='SuperAdmin'){
  4108.             $page='home/supervisor.html.twig';
  4109.         }elseif($type_user=='Client Admin'){
  4110.             $page='home/supervisor.html.twig';
  4111.         }elseif($type_user=='Hypervisor'){
  4112.             $page='hypervisor/supervisor.html.twig';
  4113.         }else{
  4114.             $page='security/pagenotfound.html.twig';
  4115.         }
  4117.         return $this->render($page, 
  4118.             array(
  4119.                 // 'form'=>$form->createView(),
  4120.                 'client' => $client,
  4121.                 'datas'=>$datas,
  4122.                 'countrys'=>$countrys,
  4123.                 'citys'=>$citys,
  4124.                 'type_user'=>$type_user,
  4125.                 'roles_client'=>$roles_client,
  4126.                 'implode_pending'=>'',
  4127.                 'implode_assigned'=>'',
  4128.                 'implode_resolved'=>'',  
  4129.                 'province'=>$province,
  4130.             )
  4131.         );
  4132.     }
  4134.     /**
  4135.      * @Route("/create_manage_supervisor", name="app_create_manage_supervisor")
  4136.      */
  4137.     public function create_manage_supervisor(Request $request, UserPasswordEncoderInterface $passwordEncoder, \Swift_Mailer $mailer)
  4138.     {
  4139.         if ($this->getUser()) {
  4140.             $client = $this->getUser();
  4141.         } else {
  4142.             return $this->redirectToRoute('user_login');
  4143.         }
  4145.         $user = $this->getUser();
  4146.         $user_id=$user->getId();
  4147.         
  4148.         $em = $this->getDoctrine()->getManager();
  4149.         if ($request->getMethod() === "POST") {
  4151.             $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findOneBy(
  4152.             array('id'=>$request->request->get('country')),
  4153.             );
  4154.             $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  4155.                 array('id'=>$request->request->get('city')),
  4156.             );
  4157.             $province = $this->getDoctrine()->getRepository('App\Entity\Province')->findOneBy(
  4158.                 array('id'=>$request->request->get('province')),
  4159.             );
  4160.             if($request->request->get('table_id') !=""){
  4161.                 $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBySomeField(array('value'=>$request->request->get('table_id')),array('email'=>$request->request->get('email')));
  4162.                 if(empty($result)){  
  4164.                     $ipadress=$request->getClientIp();
  4165.                     $updateRequest = $this->getDoctrine()->getRepository('App\Entity\User')
  4166.                     ->find($request->request->get('table_id') );
  4167.                     $updateRequest->setName($request->request->get('name') );
  4168.                     $updateRequest->setEmail($request->request->get('email'));
  4169.                     $updateRequest->setMobile($request->request->get('mobile'));
  4170.                     $updateRequest->setCountry($countrys);
  4171.                     $updateRequest->setCity($citys);
  4172.                     $updateRequest->setProvinceId($request->request->get('province'));
  4173.                     $updateRequest->setAgentgroupId('0');
  4174.                     $updateRequest->setIpaddress($ipadress);
  4176.                     $em = $this->getDoctrine()->getManager();
  4177.                     $em->persist($updateRequest);
  4178.                     $em->flush();
  4179.                     if($client->getLang() == 'en'){
  4180.                        $this->addFlash('green', 'Supervisor update successfully..!!');  
  4181.                     }else{
  4182.                        $this->addFlash('green', 'Mise à jour du superviseur réussie..!!'); 
  4183.                     } 
  4184.                 }else{
  4185.                     if($client->getLang() == 'en'){
  4186.                        $this->addFlash('red', 'There is already an account with this email');
  4187.                     }else{
  4188.                        $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  4189.                     }
  4190.                 }
  4191.             }else{
  4192.                 $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('email'=>$request->request->get('email')),array('id'=>'desc'));
  4193.                 if (empty($result)){
  4194.                     $spid= $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('type'=>'Supervisor'),array('id'=>'desc'),);
  4195.                     if(!empty($spid)){
  4196.                         $idno=explode("SP", $spid->getUserId());
  4197.                         $n=$idno[1];
  4198.                         $n2 = str_pad($n + 1, 5, 0, STR_PAD_LEFT);
  4199.                     }else{
  4200.                         $n2="00001";
  4201.                     }
  4202.                     
  4203.                     $random_password = substr(md5(random_bytes(20)),1,25);
  4204.                     $newPassword ='123456';
  4205.                     $userid ='SP'.$n2;
  4206.                     $ipadress=$request->getClientIp();
  4207.                     $addRequest = new User;
  4208.                     $addRequest->setAddedBy($user_id);
  4209.                     $addRequest->setUserId($userid);
  4210.                     $addRequest->setName($request->request->get('name') );
  4211.                     $addRequest->setEmail($request->request->get('email'));
  4212.                     $addRequest->setMobile($request->request->get('mobile'));
  4213.                     $addRequest->setPassword($passwordEncoder->encodePassword(
  4214.                         $addRequest,
  4215.                         $newPassword
  4216.                     ));
  4217.                     $addRequest->setPasswordResetToken($random_password);
  4218.                     $addRequest->setCountry($countrys);
  4219.                     $addRequest->setCity($citys);
  4220.                     $addRequest->setProvinceId($request->request->get('province'));
  4221.                     $addRequest->setStatus('1');
  4222.                     $addRequest->setAgentgroupId('0');
  4223.                     $addRequest->setLang('fr');
  4224.                     $addRequest->setType('Supervisor');
  4225.                     $addRequest->setRoles(["ROLE_SUPERVISOR"]);
  4226.                     $addRequest->setIpaddress($ipadress);
  4227.                     // $addRequest->setCountry($data['role']);
  4229.                     $em = $this->getDoctrine()->getManager();
  4230.                     $em->persist($addRequest);
  4231.                     $em->flush();
  4234.                     $url = $this->urlGenerator->generate('reset_password', array('code'=>$random_password), UrlGeneratorInterface::ABSOLUTE_URL);
  4235.                     $sendTo = $request->request->get('email');
  4236.                     $sendCc = 'santosh.jaiswal.espl@gmail.com';
  4237.                     $mailArray = array(
  4238.                         'email' => 'infos-compte@konsoplus.com',
  4239.                         'emailid' => $request->request->get('email'),
  4240.                         'mobile' => $request->request->get('mobile'),
  4241.                         'name' => $request->request->get('name'),
  4242.                         'city' => $citys->getName(),
  4243.                         'url' => $url,
  4244.                         'password' => $random_password
  4245.                     );
  4247.                     $mail = $this->mailer->sendEmailMessage(
  4248.                         'Renouveler votre mot de passe',
  4249.                         "Konso+",
  4250.                         $sendTo,
  4251.                         $sendCc,
  4252.                         null,
  4253.                         'security/welcomemail.html.twig',
  4254.                         $mailArray
  4255.                     );
  4257.                     if($client->getLang() == 'en'){
  4258.                        $this->addFlash('green', 'Supervisor added successfully..!!');  
  4259.                     }else{
  4260.                        $this->addFlash('green', 'Le superviseur a été ajouté avec succès..!!'); 
  4261.                     } 
  4262.                 }else{
  4263.                     if($client->getLang() == 'en'){
  4264.                        $this->addFlash('red', 'There is already an account with this email');
  4265.                     }else{
  4266.                        $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  4267.                     }
  4268.                 }
  4269.             }    
  4270.         }  
  4271.         return $this->redirectToRoute('app_manage_supervisor');
  4272.     }
  4273.         
  4274.      /**
  4275.      * @Route("/update-request-status-supervisor/{id}/{status}", name="update_user_status_supervisor")
  4276.      */
  4277.      public function update_status_supervisor(User $request,$status)
  4278.      {
  4279.           if ($this->getUser()) {
  4280.               $client = $this->getUser();
  4281.           } else {
  4282.               return $this->redirectToRoute('user_login');
  4283.           }
  4284.           $em = $this->getDoctrine()->getManager();
  4285.           $request->setStatus($status);
  4286.           $em->persist($request);
  4287.           $em->flush();
  4288.           if($status == 1){
  4289.                if($client->getLang() == 'en'){
  4290.                   $this->addFlash('green', 'You have enable the supervisor');  
  4291.                }else{
  4292.                   $this->addFlash('green', 'Vous avez activé le superviseur'); 
  4293.                } 
  4294.           }else{
  4295.                if($client->getLang() == 'en'){
  4296.                   $this->addFlash('red', 'You have disable the supervisor');  
  4297.                }else{
  4298.                   $this->addFlash('red', 'Vous avez désactivé le superviseur');
  4299.                } 
  4300.           }
  4301.           return $this->redirectToRoute('app_manage_supervisor');
  4302.      }
  4304.     /**
  4305.      * @Route("/request-supervisor-delete/{id}", name="app_user_delete_supervisor")
  4306.      */
  4308.     public function supervisor_delete(User $request,$id)
  4309.     {
  4310.         $em = $this->getDoctrine()->getManager();
  4311.         $request->getId($id);
  4312.         $em->remove($request);
  4313.         $em->flush();
  4315.         $this->addFlash('green','Supervisor deleted successfully..!!');
  4317.         return $this->redirectToRoute('app_manage_supervisor');
  4318.     }
  4320.     /**
  4321.      * @Route("/manage_client_admin", name="app_manage_client_admin")
  4322.      */
  4323.     public function manage_client_admin()
  4324.     {
  4325.         if ($this->getUser()) {
  4326.             $client = $this->getUser();
  4327.         } else {
  4328.             return $this->redirectToRoute('user_login');
  4329.         }
  4330.         $user = $this->getUser();
  4331.         $type_user=$user->getType();
  4332.         $allid=explode(",", $user->getRolebyadmin());
  4333.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  4334.         if($type_user == "SuperAdmin"){
  4335.                 $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  4336.                     array('type'=>'Client Admin'),
  4337.                     array('id'=>'desc'),
  4338.                 );
  4339.             if(!empty($datas)){
  4340.                 foreach($datas as $key=>$dataid){
  4342.                     $allid=explode(",", $dataid->getRolebyadmin());
  4343.                     $result = $this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  4344.                     $datas[$key]->role_detail=$result;
  4345.                 }
  4347.             }else{
  4348.                 $datas = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(
  4349.                 array('type'=>'Client Admin'),
  4350.                 array('id'=>'desc'),
  4351.                 );
  4352.             }
  4355.             $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findBy(
  4356.                 array('code'=>'FR'),
  4357.                 array('name'=>'asc'),
  4358.             );
  4359.             $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findBy(array(),
  4360.                 array('name'=>'asc'),
  4361.             );
  4362.             $rolebyadmin = $this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findBy(
  4363.                 array(),
  4364.                 array('id'=>'asc'),
  4365.             );
  4367.             $page='home/manage_client_admin.html.twig';
  4368.         }else{
  4369.             $page='security/pagenotfound.html.twig';
  4370.             $datas="";
  4371.             $countrys="";
  4372.             $citys="";
  4373.             $rolebyadmin="";
  4374.         }
  4375.         
  4377.         return $this->render($page, 
  4378.             array(
  4379.                 // 'form'=>$form->createView(),
  4380.                 'client' => $client,
  4381.                 'datas'=>$datas,
  4382.                 'countrys'=>$countrys,
  4383.                 'citys'=>$citys,
  4384.                 'type_user'=>$type_user,
  4385.                 'roles_client'=>$roles_client,
  4386.                 'implode_pending'=>'',
  4387.                 'implode_assigned'=>'',
  4388.                 'implode_resolved'=>'',  
  4389.                 'rolebyadmin'=>$rolebyadmin,
  4390.             )
  4391.         );
  4392.     }
  4394.     /**
  4395.      * @Route("/create_manage_client_admin", name="app_create_manage_client_admin")
  4396.      */
  4397.     public function create_manage_client_admin(Request $request, UserPasswordEncoderInterface $passwordEncoder, \Swift_Mailer $mailer)
  4398.     {
  4399.         if ($this->getUser()) {
  4400.             $client = $this->getUser();
  4401.         } else {
  4402.             return $this->redirectToRoute('user_login');
  4403.         }
  4405.         $user = $this->getUser();
  4406.         $user_id=$user->getId();
  4407.         
  4408.             
  4409.             $em = $this->getDoctrine()->getManager();
  4410.             if ($request->getMethod() === "POST") {
  4411.                 $countrys = $this->getDoctrine()->getRepository('App\Entity\Dsccountries')->findOneBy(
  4412.                 array('id'=>$request->request->get('country')),
  4413.                 );
  4414.                 $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  4415.                     array('id'=>$request->request->get('city')),
  4416.                 );
  4417.                 if($request->request->get('table_id') !=""){
  4418.                     $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBySomeField(array('value'=>$request->request->get('table_id')),array('email'=>$request->request->get('email')));
  4419.                     if (empty($result)) {
  4421.                         $ipadress=$request->getClientIp();
  4422.                         $updateRequest = $this->getDoctrine()->getRepository('App\Entity\User')
  4423.                         ->find($request->request->get('table_id') );
  4424.                         $updateRequest->setName($request->request->get('name') );
  4425.                         $updateRequest->setEmail($request->request->get('email'));
  4426.                         $updateRequest->setMobile($request->request->get('mobile'));
  4427.                         $updateRequest->setCountry($countrys);
  4428.                         $updateRequest->setCity($citys);
  4429.                         $updateRequest->setProvinceId('0');
  4430.                         $updateRequest->setAgentgroupId('0');
  4431.                         if(!empty($request->request->get('rolebyadmin'))){
  4432.                             $updateRequest->setRolebyadmin(implode(",",$request->request->get('rolebyadmin')));
  4433.                         }else{
  4434.                             $updateRequest->setRolebyadmin($request->request->get('rolebyadmin'));
  4435.                         }
  4436.                         $updateRequest->setIpaddress($ipadress);
  4438.                         $em = $this->getDoctrine()->getManager();
  4439.                         $em->persist($updateRequest);
  4440.                         $em->flush();
  4442.                          if($client->getLang() == 'en'){
  4443.                             $this->addFlash('green', 'Admin/client update successfully..!!');   
  4444.                          }else{
  4445.                             $this->addFlash('green', 'Mise à jour Admin/client réussie..!!'); 
  4446.                          } 
  4447.                     }else{
  4448.                         if($client->getLang() == 'en'){
  4449.                             $this->addFlash('red', 'There is already an account with this email');
  4450.                          }else{
  4451.                             $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  4452.                          }
  4453.                     } 
  4454.                 }else{
  4455.                     $result = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('email'=>$request->request->get('email')),array('id'=>'desc'));
  4456.                     if (empty($result)) {
  4457.                         $caid= $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('type'=>'Client Admin'),array('id'=>'desc'),);
  4458.                         if(!empty($caid)){
  4459.                             $idno=explode("CA", $caid->getUserId());
  4460.                             $n=$idno[1];
  4461.                             $n2 = str_pad($n + 1, 5, 0, STR_PAD_LEFT);
  4462.                         }else{
  4463.                             $n2="00001";
  4464.                         }
  4465.                         $newPassword ='123456';
  4466.                         $random_password = substr(md5(random_bytes(20)),1,25);
  4467.                         $userid ='CA'.$n2;
  4468.                         $ipadress=$request->getClientIp();
  4469.                         $addRequest = new User;
  4470.                         $addRequest->setAddedBy($user_id);
  4471.                         $addRequest->setUserId($userid);
  4472.                         $addRequest->setName($request->request->get('name') );
  4473.                         $addRequest->setEmail($request->request->get('email'));
  4474.                         $addRequest->setMobile($request->request->get('mobile'));
  4475.                         $addRequest->setPassword($passwordEncoder->encodePassword(
  4476.                             $addRequest,
  4477.                             $newPassword
  4478.                         ));
  4479.                         $addRequest->setPasswordResetToken($random_password);
  4480.                         $addRequest->setCountry($countrys);
  4481.                         $addRequest->setCity($citys);
  4482.                         $addRequest->setProvinceId('0');
  4483.                         $addRequest->setRolebyadmin(implode(",",$request->request->get('rolebyadmin')));
  4484.                         $addRequest->setStatus('1');
  4485.                         $addRequest->setAgentgroupId('0');
  4486.                         $addRequest->setLang('fr');
  4487.                         $addRequest->setType('Client Admin');
  4488.                         $addRequest->setRoles(["ROLE_CLIENTADMIN"]);
  4489.                         $addRequest->setIpaddress($ipadress);
  4490.                         $em = $this->getDoctrine()->getManager();
  4491.                         $em->persist($addRequest);
  4492.                         $em->flush();
  4494.                         $url = $this->urlGenerator->generate('reset_password', array('code'=>$random_password), UrlGeneratorInterface::ABSOLUTE_URL);
  4495.                         $sendTo = $request->request->get('email');
  4496.                         $sendCc = 'santosh.jaiswal.espl@gmail.com';
  4497.                         $mailArray = array(
  4498.                             'email' => 'infos-compte@konsoplus.com',
  4499.                             'emailid' => $request->request->get('email'),
  4500.                             'mobile' => $request->request->get('mobile'),
  4501.                             'name' => $request->request->get('name'),
  4502.                             'city' => $citys->getName(),
  4503.                             'url' => $url,
  4504.                             'password' => $random_password
  4505.                         );
  4507.                         $mail = $this->mailer->sendEmailMessage(
  4508.                             'Renouveler votre mot de passe',
  4509.                             "Konso+",
  4510.                             $sendTo,
  4511.                             $sendCc,
  4512.                             null,
  4513.                             'security/welcomemail.html.twig',
  4514.                             $mailArray
  4515.                         );
  4517.                          if($client->getLang() == 'en'){
  4518.                             $this->addFlash('green', 'Admin/client added successfully..!!');   
  4519.                          }else{
  4520.                             $this->addFlash('green', 'Admin/client ajouté avec succès..!!');
  4521.                          } 
  4522.                     }else{
  4523.                         if($client->getLang() == 'en'){
  4524.                             $this->addFlash('red', 'There is already an account with this email');
  4525.                          }else{
  4526.                             $this->addFlash('red', 'Il existe déjà un compte avec cette adresse e-mail');
  4527.                          }
  4528.                     } 
  4529.                 }    
  4530.             }
  4531.         return $this->redirectToRoute('app_manage_client_admin');
  4532.     }
  4534.      /**
  4535.      * @Route("/update-request-status/{id}/{status}", name="update_user_status")
  4536.      */
  4537.      public function updateRequestuserstatus(User $request,$status)
  4538.      {
  4539.           if ($this->getUser()) {
  4540.               $client = $this->getUser();
  4541.           } else {
  4542.               return $this->redirectToRoute('user_login');
  4543.           }
  4544.           $em = $this->getDoctrine()->getManager();
  4545.           $request->setStatus($status);
  4546.           $em->persist($request);
  4547.           $em->flush();
  4548.           if($status == 1){
  4549.                if($client->getLang() == 'en'){
  4550.                   $this->addFlash('green', 'You have enable the admin/client'); 
  4551.                }else{
  4552.                   $this->addFlash('green', 'Vous avez activé la fonction admin/client');
  4553.                }
  4554.           }else{
  4555.                if($client->getLang() == 'en'){
  4556.                   $this->addFlash('red', 'You have disable the admin/client'); 
  4557.                }else{
  4558.                   $this->addFlash('red', "Vous avez désactivé l'admin/client");
  4559.                }
  4560.           }
  4561.           return $this->redirectToRoute('app_manage_client_admin');
  4562.      }
  4564.     /**
  4565.      * @Route("/request-user-delete/{id}", name="app_user_delete")
  4566.      */
  4568.     public function user_delete(User $request,$id)
  4569.     {
  4570.         $em = $this->getDoctrine()->getManager();
  4571.         $request->getId($id);
  4572.         $em->remove($request);
  4573.         $em->flush();
  4575.         $this->addFlash('green','Admin/client deleted successfully..!!');
  4577.         return $this->redirectToRoute('app_manage_client_admin');
  4578.     }
  4580.      /**
  4581.      * @Route("/send-mail-to-user/{id}/{type}", name="send_mail_to_user")
  4582.      */
  4583.      public function sendmailtouser($id,$type, \Swift_Mailer $mailer)
  4584.      {
  4585.           if ($this->getUser()) {
  4586.               $client = $this->getUser();
  4587.           } else {
  4588.               return $this->redirectToRoute('user_login');
  4589.           }
  4590.           $user=$this->getDoctrine()->getManager()->getRepository("App\Entity\User")->findOneBy(['id' => $id]);
  4592.           if(!empty($user)){
  4593.               $random_password = substr(md5(random_bytes(20)),1,25);
  4594.               $url = $this->urlGenerator->generate('reset_password', array('code'=>$random_password), UrlGeneratorInterface::ABSOLUTE_URL);
  4595.               $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  4596.                 array('id'=>$user->getCityId()),
  4597.               );
  4599.                $user->setPasswordResetToken($random_password);
  4600.                $this->getDoctrine()->getManager()->persist($user);
  4601.                $this->getDoctrine()->getManager()->flush();
  4603.                 $sendTo = $user->getEmail();
  4604.                 $sendCc = 'santosh.jaiswal.espl@gmail.com';
  4605.                 $mailArray = array(
  4606.                     'email' => 'infos-compte@konsoplus.com',
  4607.                     'emailid' => $user->getEmail(),
  4608.                     'mobile' => $user->getMobile(),
  4609.                     'name' => $user->getName(),
  4610.                     'url' => $url,
  4611.                     'city' => $citys->getName(),
  4612.                     'password' => $random_password
  4613.                 );
  4616.                 $mail = $this->mailer->sendEmailMessage(
  4617.                     'Renouveler votre mot de passe',
  4618.                     "Konso+",
  4619.                     $sendTo,
  4620.                     $sendCc,
  4621.                     null,
  4622.                     'security/welcomemail.html.twig',
  4623.                     $mailArray
  4624.                 );
  4626.                if($client->getLang() == 'en'){
  4627.                   $this->addFlash('green', 'Detail mail send successfully..!!');
  4628.                }else{
  4629.                   $this->addFlash('green', 'Détail du courrier envoyé avec succès..!!');
  4630.                }   
  4631.           }else{
  4632.                if($client->getLang() == 'en'){
  4633.                   $this->addFlash('red', 'User not found..!!'); 
  4634.                }else{
  4635.                   $this->addFlash('red', 'Utilisateur non trouvé..!!'); 
  4636.                }  
  4637.           } 
  4638.           if($type == "1"){
  4639.               return $this->redirectToRoute('app_manage_client_admin');    
  4640.           }elseif($type == "2"){
  4641.               return $this->redirectToRoute('app_manage_oprational_manager'); 
  4642.           }elseif($type == "3"){
  4643.               return $this->redirectToRoute('app_manage_hypervisor'); 
  4644.           }elseif($type == "4"){
  4645.               return $this->redirectToRoute('app_manage_supervisor'); 
  4646.           }elseif($type == "5"){
  4647.               return $this->redirectToRoute('app_manage_financial_manager'); 
  4648.           }elseif($type == "6"){
  4649.               return $this->redirectToRoute('app_manage_agent'); 
  4650.           }else{
  4651.               return $this->redirectToRoute('app_home');    
  4652.           }
  4653.      }
  4656.     /**
  4657.      * @Route("/manage_campaign", name="app_manage_campaign")
  4658.      */
  4659.     public function manage_campaign()
  4660.     {
  4661.         if ($this->getUser()) {
  4662.             $client = $this->getUser();
  4663.         } else {
  4664.             return $this->redirectToRoute('user_login');
  4665.         }
  4666.         $user = $this->getUser();
  4667.         $type_user=$user->getType();
  4668.         $allid=explode(",", $user->getRolebyadmin());
  4669.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  4670.         if($type_user == "SuperAdmin" || $type_user == "Client Admin"){
  4671.             $datas = $this->getDoctrine()->getRepository('App\Entity\Campaign')->findBy(
  4672.                 array(),
  4673.                 array('id'=>'desc'),
  4674.             );
  4675.             if(!empty($datas)){
  4676.                 foreach($datas as $key=>$dataid){
  4677.                     $allcatid=explode(",", $dataid->getcategoryId());
  4678.                     $result = $this->getDoctrine()->getRepository('App\Entity\Products')->findOneBySomeField($allcatid);
  4679.                     $datas[$key]->product_detail=$result;
  4680.                     
  4681.                     $category_id=explode(",", $dataid->getcategoryId());
  4682.                     $resultcat = $this->getDoctrine()->getRepository('App\Entity\Categorie')->findOneBySomeField($category_id);
  4683.                     $datas[$key]->category_detail=$resultcat;
  4684.                 }
  4686.             }else{
  4687.                 $datas = $this->getDoctrine()->getRepository('App\Entity\Campaign')->findBy(
  4688.                     array(),
  4689.                     array('id'=>'desc'),
  4690.                 );
  4691.             }
  4693.             $product = $this->getDoctrine()->getRepository('App\Entity\Products')->findBy(array('status'=>'1'));
  4694.             $category = $this->getDoctrine()->getRepository(Categorie::class)->findBy(array(),array('id'=>'desc'));
  4695.             $page='home/manage_product_campaigns_list.html.twig';
  4696.         }else{
  4697.             $page='security/pagenotfound.html.twig';
  4698.             $datas = "";
  4699.             $categorie ="";
  4700.             $subcategorie ="";
  4701.         }
  4702.         
  4704.         return $this->render($page, 
  4705.             array(
  4706.                 'client' => $client,
  4707.                 'datas'=>$datas,
  4708.                 'type_user'=>$type_user,
  4709.                 'roles_client'=>$roles_client,
  4710.                 'implode_pending'=>'',
  4711.                 'implode_assigned'=>'',
  4712.                 'implode_resolved'=>'',  
  4713.                 'product'=>$product,
  4714.                 'category'=>$category,
  4715.             )
  4716.         );
  4717.     }
  4718.     
  4719.     /**
  4720.      * @Route("/manage_campaign_details/{id}", name="app_manage_campaign_details")
  4721.      */
  4722.     public function manage_campaign_details($id)
  4723.     {
  4724.         if ($this->getUser()) {
  4725.             $client = $this->getUser();
  4726.         } else {
  4727.             return $this->redirectToRoute('user_login');
  4728.         }
  4729.         $user = $this->getUser();
  4730.         $type_user=$user->getType();
  4731.         $allid=explode(",", $user->getRolebyadmin());
  4732.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  4733.         if($type_user == "SuperAdmin" || $type_user == "Client Admin"){
  4734.             $datas = $this->getDoctrine()->getRepository('App\Entity\Campaign')->findBy(
  4735.                 array('id'=>$id),
  4736.                 array('id'=>'desc'),
  4737.             );
  4738.             if(!empty($datas)){
  4739.                 foreach($datas as $key=>$dataid){
  4740.                     $allcatid=explode(",", $dataid->getcategoryId());
  4741.                     $result = $this->getDoctrine()->getRepository('App\Entity\Products')->findOneBySomeField($allcatid);
  4742.                     $datas[$key]->product_detail=$result;
  4744.                     $category_id=explode(",", $dataid->getcategoryId());
  4745.                     $resultcat = $this->getDoctrine()->getRepository('App\Entity\Categorie')->findOneBySomeField($category_id);
  4746.                     $datas[$key]->category_detail=$resultcat;
  4747.                 }
  4749.             }else{
  4750.                 $datas = $this->getDoctrine()->getRepository('App\Entity\Campaign')->findBy(
  4751.                     array('id'=>$id),
  4752.                     array('id'=>'desc'),
  4753.                 );
  4754.             }
  4756.             $product = $this->getDoctrine()->getRepository('App\Entity\Products')->findBy(array('status'=>'1'));
  4757.             $category = $this->getDoctrine()->getRepository(Categorie::class)->findBy(array(),array('id'=>'desc'));
  4758.             $page='home/manage_product_campaigns.html.twig';
  4759.         }else{
  4760.             $page='security/pagenotfound.html.twig';
  4761.             $datas = "";
  4762.             $category ="";
  4763.             $product ="";
  4764.             $id ="";
  4765.         }
  4766.         return $this->render($page, 
  4767.             array(
  4768.                 // 'form'=>$form->createView(),
  4769.                 'client' => $client,
  4770.                 'datas'=>$datas,
  4771.                 'type_user'=>$type_user,
  4772.                 'roles_client'=>$roles_client,
  4773.                 'implode_pending'=>'',
  4774.                 'implode_assigned'=>'',
  4775.                 'implode_resolved'=>'',  
  4776.                 'product'=>$product,
  4777.                 'category'=>$category,
  4778.                 'id'=>$id,
  4779.             )
  4780.         );
  4781.     }
  4783.     /**
  4784.      * @Route("/manage_campaign_result/{id}", name="app_manage_campaign_result")
  4785.      */
  4786.     public function manage_campaign_result($id)
  4787.     {
  4788.         if ($this->getUser()) {
  4789.             $client = $this->getUser();
  4790.         } else {
  4791.             return $this->redirectToRoute('user_login');
  4792.         }
  4793.         $user = $this->getUser();
  4794.         $type_user=$user->getType();
  4795.         $allid=explode(",", $user->getRolebyadmin());
  4796.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  4797.         if($type_user == "SuperAdmin" || $type_user == "Client Admin"){
  4798.             $campaign = $this->getDoctrine()->getRepository('App\Entity\Campaign')->findOneBy(
  4799.                 array('id'=>$id)
  4800.             );
  4802.             $allcatid=explode(",", $campaign->getcategoryId());
  4803.             $datas = $this->getDoctrine()->getRepository('App\Entity\Products')->findOneBySomeField($allcatid);
  4805.             if(!empty($datas)){
  4806.                 foreach($datas as $key=>$value){
  4807.                     
  4808.                     $CustomerVotes= $this->getDoctrine()->getRepository('App\Entity\CustomerVotes')->findBy(
  4809.                         array('product_id'=>$value->getId(),'campaign_id'=>$id),
  4810.                         array('id'=>'desc'),
  4811.                     );
  4812.                     $vote_count =count($CustomerVotes);
  4813.                     $datas[$key]->vote_counts=$vote_count; 
  4814.                 }
  4816.             }
  4817.             $page='home/manage_product_campaign_result.html.twig';
  4818.         }else{
  4819.             $page='security/pagenotfound.html.twig';
  4820.             $datas = "";
  4821.         }
  4822.         return $this->render($page, 
  4823.             array(
  4824.                 // 'form'=>$form->createView(),
  4825.                 'client' => $client,
  4826.                 'datas'=>$datas,
  4827.                 'type_user'=>$type_user,
  4828.                 'roles_client'=>$roles_client,
  4829.                 'implode_pending'=>'',
  4830.                 'implode_assigned'=>'',
  4831.                 'implode_resolved'=>'',  
  4832.                 'campaign'=>$campaign,
  4833.                 'id'=>$id,
  4834.             )
  4835.         );
  4836.     }
  4839.     /**
  4840.      * @Route("/create_manage_campaign", name="app_create_manage_campaign")
  4841.      */
  4842.     public function create_manage_campaign(Request $request,string $uploadDirtow,FileUploader $uploader)
  4843.     {
  4844.         if ($this->getUser()) {
  4845.             $client = $this->getUser();
  4846.         } else {
  4847.             return $this->redirectToRoute('user_login');
  4848.         }
  4850.         $user = $this->getUser();
  4851.         $user_id=$user->getId();
  4852.        
  4853.         $em = $this->getDoctrine()->getManager();
  4854.         if ($request->getMethod() === "POST") {
  4856.             if($request->request->get('table_id') !=""){
  4857.                 
  4858.                 $files = $request->files->get('image');
  4859.                 if(count($files) <= 6){
  4860.                     if(!empty($files)){
  4861.                         $imgs=array();
  4862.                         $i=1;
  4863.                         foreach ($files as $key => $file) {
  4864.                             // code...
  4865.                             if (!empty($file))
  4866.                             {   
  4867.                                 $filename = $file->getClientOriginalName();
  4868.                                 $extensions=$file->getClientOriginalExtension();
  4869.                                 $imagename='images/campaign/product_campaingn_'.$i++.rand(1111,9999).time().'.'.$extensions;
  4870.                                 $imgs[]=$imagename;
  4871.                                 $uploader->upload($uploadDirtow, $file, $imagename);
  4872.                             }else{
  4873.                                 $filename = null;
  4874.                             } 
  4875.                         }
  4876.                         $product_image=implode(",", $imgs);
  4877.                     }else{
  4878.                         $product_image=$request->request->get('oldimage');
  4879.                     }
  4881.                     $dates=$request->request->get('dates');
  4882.                     $date=explode ("-", $dates); 
  4884.                     $updateRequest = $this->getDoctrine()->getRepository('App\Entity\Campaign')
  4885.                     ->find($request->request->get('table_id') );
  4886.                     $updateRequest->setTitle($request->request->get('title') );
  4887.                     $updateRequest->setGoal($request->request->get('goal'));
  4888.                     $updateRequest->setDetails($request->request->get('details'));
  4889.                     $updateRequest->setDescription($request->request->get('description'));
  4890.                     $updateRequest->setCategoryId(implode(",",$request->request->get('category_id')));
  4891.                     $updateRequest->setStartDate(date( "Y-m-d", strtotime($date[0])));
  4892.                     $updateRequest->setEndDate(date( "Y-m-d", strtotime($date[1])));
  4893.                     $updateRequest->setImage($product_image);
  4894.                     $updateRequest->setTotalVotes('0');
  4895.                     $updateRequest->setStatus('1');
  4897.                     $em = $this->getDoctrine()->getManager();
  4898.                     $em->persist($updateRequest);
  4899.                     $em->flush();
  4901.                     if($client->getLang() == 'en'){
  4902.                        $this->addFlash('green', 'Product campaign update successfully..!!');
  4903.                     }else{
  4904.                        $this->addFlash('green', 'Mise à jour réussie de la campagne de produits..!!');
  4905.                     }  
  4906.                 }else{
  4907.                     if($client->getLang() == 'en'){
  4908.                        $this->addFlash('red', 'You are only allowed to upload a maximum of 6 image..!!');  
  4909.                     }else{
  4910.                        $this->addFlash('red', 'Vous êtes autorisé à télécharger un maximum de 6 images...!!');  
  4911.                     } 
  4912.                 }
  4913.                 
  4914.             }else{
  4916.                 $files = $request->files->get('image');
  4917.                 $imgs=array();
  4918.                 $i=1;
  4919.                 foreach ($files as $key => $file) {
  4920.                     // code...
  4921.                     if (!empty($file))
  4922.                     {   
  4923.                         $filename = $file->getClientOriginalName();
  4924.                         $extensions=$file->getClientOriginalExtension();
  4925.                         $imagename='images/campaign/product_campaingn_'.$i++.rand(1111,9999).time().'.'.$extensions;
  4926.                         $imgs[]=$imagename;
  4927.                         $uploader->upload($uploadDirtow, $file, $imagename);
  4928.                     }else{
  4929.                         $filename = null;
  4930.                     } 
  4931.                 }
  4933.                 // dd($imgs);
  4934.                 $product_image=implode(",", $imgs);      
  4935.                 $dates=$request->request->get('dates');
  4936.                 $date=explode ("-", $dates); 
  4937.                 $date=explode ("-", $dates); 
  4938.                 if (!empty($date)) {
  4939.                     $d1=$date[0];
  4940.                     $d2=$date[1];
  4941.                 } else {
  4942.                     $d1=date('Y-m-d');
  4943.                     $d2=date('Y-m-d');
  4944.                 }
  4945.                 $addRequest = new Campaign;
  4946.                 $addRequest->setTitle($request->request->get('title') );
  4947.                 $addRequest->setGoal($request->request->get('goal'));
  4948.                 $addRequest->setDetails($request->request->get('details'));
  4949.                 $addRequest->setDescription($request->request->get('description'));
  4950.                 $addRequest->setCategoryId(implode(",",$request->request->get('category_id')));
  4951.                 $addRequest->setStartDate(date( "Y-m-d", strtotime($d1)));
  4952.                 $addRequest->setEndDate(date( "Y-m-d", strtotime($d2)));
  4953.                 $addRequest->setImage($product_image);
  4954.                 $addRequest->setTotalVotes('0');
  4955.                 $addRequest->setStatus('1');
  4956.                 $em = $this->getDoctrine()->getManager();
  4957.                 $em->persist($addRequest);
  4958.                 $em->flush();
  4959.                 if($client->getLang() == 'en'){
  4960.                   $this->addFlash('green', 'Product campaign added successfully..!!');
  4961.                }else{
  4962.                   $this->addFlash('green', 'Campagne produit ajoutée avec succès..!!');
  4963.                } 
  4964.             }    
  4965.         }
  4966.         return $this->redirectToRoute('app_manage_campaign');
  4967.     }
  4969.      /**
  4970.      * @Route("/status-campaign/{id}/{status}", name="update_campaign_status")
  4971.      */
  4972.      public function updateRequestcampaignstatus(Campaign $request,$status)
  4973.      {
  4974.           if ($this->getUser()) {
  4975.               $client = $this->getUser();
  4976.           } else {
  4977.               return $this->redirectToRoute('user_login');
  4978.           }
  4979.           $em = $this->getDoctrine()->getManager();
  4980.           $request->setStatus($status);
  4981.           $em->persist($request);
  4982.           $em->flush();
  4983.           if($status == 1){
  4984.                if($client->getLang() == 'en'){
  4985.                   $this->addFlash('green', 'You have enable the product campaign');
  4986.                }else{
  4987.                   $this->addFlash('green', 'Vous avez activé la campagne du produit');
  4988.                } 
  4989.           }else{
  4990.                if($client->getLang() == 'en'){
  4991.                   $this->addFlash('red', 'You have disable the product campaign');
  4992.                }else{
  4993.                   $this->addFlash('red', 'Vous avez désactivé la campagne du produit');
  4994.                } 
  4995.           }
  4996.           return $this->redirectToRoute('app_manage_campaign');
  4997.      }
  4999.     /**
  5000.      * @Route("/request-campaign-delete/{id}", name="app_campaign_delete")
  5001.      */
  5003.     public function campaign_delete(Campaign $request,$id)
  5004.     {
  5005.         $em = $this->getDoctrine()->getManager();
  5006.         $request->getId($id);
  5007.         $em->remove($request);
  5008.         $em->flush();
  5010.         $this->addFlash('green','Product campaign deleted successfully..!!');
  5012.         return $this->redirectToRoute('app_manage_campaign');
  5013.     }
  5015.     /**
  5016.      * @Route("/fraud-complaint", name="app_manage_fraud_complaint")
  5017.      */
  5018.     public function manage_fraud_complaint()
  5019.     {
  5020.         if ($this->getUser()) {
  5021.             $client = $this->getUser();
  5022.         } else {
  5023.             return $this->redirectToRoute('user_login');
  5024.         }
  5025.         $user = $this->getUser();
  5026.         $type_user=$user->getType();
  5027.         $allid=explode(",", $user->getRolebyadmin());
  5028.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  5029.         if($type_user == "SuperAdmin" || $type_user == "Client Admin"){
  5031.             $datas = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(
  5032.                 array(),
  5033.                 array('id'=>'desc'),
  5034.             );
  5035.             foreach ($datas as $key => $value) {
  5036.                 $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$value->getFine()));
  5037.                 if ($pv) {
  5038.                     $datas[$key]->fines =$pv;
  5039.                 } else {
  5040.                      $datas[$key]->fines ="";
  5041.                 }
  5042.                 $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  5043.                     array('id'=>$value->getCity()),
  5044.                 );
  5045.                 if ($citys) {
  5046.                     $datas[$key]->citys =$citys;
  5047.                 } else {
  5048.                      $datas[$key]->citys ="";
  5049.                 }
  5050.                 $fcp= $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(array('fraud_com_id'=>$value->getId()));
  5051.                 if ($fcp) {
  5052.                     $datas[$key]->fc_product =$fcp;
  5053.                 } else {
  5054.                      $datas[$key]->fc_product ="";
  5055.                 }
  5057.             }
  5058.             $page='home/fraud_complaint.html.twig';
  5059.         }else{
  5060.             $page='security/pagenotfound.html.twig';
  5061.             $datas = "";
  5062.         }
  5063.         return $this->render($page, 
  5064.             array(
  5065.                 // 'form'=>$form->createView(),
  5066.                 'client' => $client,
  5067.                 'datas'=>$datas,
  5068.                 'type_user'=>$type_user,
  5069.                 'roles_client'=>$roles_client,
  5070.                 'implode_pending'=>'',
  5071.                 'implode_assigned'=>'',
  5072.                 'implode_resolved'=>'',  
  5073.             )
  5074.         );
  5075.     }
  5078.      /**
  5079.      * @Route("/team-productivityold/{status}", name="app_team_productivityold")
  5080.      */
  5081.     public function team_productivity_old($status="")
  5082.     {
  5083.         if ($this->getUser()) {
  5084.             $client = $this->getUser();
  5085.         } else {
  5086.             return $this->redirectToRoute('user_login');
  5087.         }
  5088.         
  5089.         $user = $this->getUser();
  5090.         $type_user=$user->getType();
  5091.         $allid=explode(",", $user->getRolebyadmin());
  5092.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  5093.         if($type_user == "Hypervisor" || $type_user == "Supervisor"){
  5095.             if($status == "0"){
  5096.                 $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(
  5097.                     array('city_id'=>$user->getCityId(),'compstatus'=>'Pending'),
  5098.                     array('id'=>'desc'),
  5099.                 );
  5100.                 foreach ($datas as $key => $value) {
  5101.                     $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  5102.                     array('id'=>'desc'),);
  5103.                     $datas[$key]->agent_name=$agentname;
  5104.                 }
  5105.                 $status="0";
  5106.             }elseif($status == "1"){
  5107.                 $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(
  5108.                     array('city_id'=>$user->getCityId(),'status'=>'1'),
  5109.                     array('id'=>'desc'),
  5110.                 );
  5111.                 foreach ($datas as $key => $value) {
  5112.                     $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  5113.                     array('id'=>'desc'),);
  5114.                     $datas[$key]->agent_name=$agentname;
  5115.                 }
  5116.                 $status="1";
  5117.             }elseif($status == "2"){
  5118.                 $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(
  5119.                     array('city_id'=>$user->getCityId(),'compstatus'=>'Resolved'),
  5120.                     array('id'=>'desc'),
  5121.                 );
  5122.                 foreach ($datas as $key => $value) {
  5123.                     $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  5124.                     array('id'=>'desc'),);
  5125.                     $datas[$key]->agent_name=$agentname;
  5126.                 }
  5127.                 $status="2";
  5128.             }else{
  5129.                 $datas = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findBy(
  5130.                     array('city_id'=>$user->getCityId()),
  5131.                     array('id'=>'desc'),
  5132.                 );
  5133.                 foreach ($datas as $key => $value) {
  5134.                     $agentname = $this->getDoctrine()->getRepository('App\Entity\User')->findOneBy(array('id'=>$value->getAgentid(),'type'=>'Agent'),
  5135.                     array('id'=>'desc'),);
  5136.                     $datas[$key]->agent_name=$agentname;
  5137.                 }
  5138.                 $status="";
  5139.             }
  5140.             
  5141.             $page='hypervisor/team_productivity.html.twig';
  5142.         }else{
  5143.             $page='security/pagenotfound.html.twig';
  5144.             $datas = "";
  5145.             $status="";
  5146.         }
  5147.         return $this->render($page, 
  5148.             array(
  5149.                 'client' => $client,
  5150.                 'datas'=>$datas,
  5151.                 'type_user'=>$type_user,
  5152.                 'roles_client'=>$roles_client,
  5153.                 'implode_pending'=>'',
  5154.                 'implode_assigned'=>'',
  5155.                 'implode_resolved'=>'',  
  5156.                 'status'=>$status,
  5157.             )
  5158.         );
  5159.     }
  5161.      /**
  5162.      * @Route("/team-productivity", name="app_team_productivity")
  5163.      */
  5164.     public function team_productivity()
  5165.     {
  5166.         if ($this->getUser()) {
  5167.             $client = $this->getUser();
  5168.         } else {
  5169.             return $this->redirectToRoute('user_login');
  5170.         }
  5171.         
  5172.         $user = $this->getUser();
  5173.         $type_user=$user->getType();
  5174.         $allid=explode(",", $user->getRolebyadmin());
  5175.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  5176.         if($type_user == "Hypervisor" || $type_user == "Supervisor"){
  5178.                 /*January start*/
  5179.                 $Pending_jan = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5180.                     "0",$user->getCityId(),"1",date('Y')
  5181.                 );
  5182.                 $Pending_jan_count=count($Pending_jan);
  5184.                 $assigned_jan = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5185.                      "1",$user->getCityId(),"1",date('Y')
  5186.                 );
  5187.                 $assigned_jan_count=count($assigned_jan); 
  5189.                 $Resolved_jan = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5190.                      "2",$user->getCityId(),"1",date('Y')
  5191.                 );
  5192.                 $Resolved_jan_count=count($Resolved_jan); 
  5193.                 /*January end*/
  5194.                 /*February start*/
  5195.                 $Pending_feb = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5196.                     "0",$user->getCityId(),"2",date('Y')
  5197.                 );
  5198.                 $Pending_feb_count=count($Pending_feb);
  5200.                 $assigned_feb = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5201.                      "1",$user->getCityId(),"2",date('Y')
  5202.                 );
  5203.                 $assigned_feb_count=count($assigned_feb); 
  5205.                 $Resolved_feb = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5206.                      "2",$user->getCityId(),"2",date('Y')
  5207.                 );
  5208.                 $Resolved_feb_count=count($Resolved_feb);
  5209.                 /*February end*/
  5210.                 /*March start*/
  5211.                 $Pending_march = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5212.                     "0",$user->getCityId(),"3",date('Y')
  5213.                 );
  5214.                 $Pending_march_count=count($Pending_march);
  5216.                 $assigned_march = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5217.                      "1",$user->getCityId(),"3",date('Y')
  5218.                 );
  5219.                 $assigned_march_count=count($assigned_march); 
  5221.                 $Resolved_march = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5222.                      "2",$user->getCityId(),"3",date('Y')
  5223.                 );
  5224.                 $Resolved_march_count=count($Resolved_march);
  5225.                 /*March end*/
  5226.                 /*April start*/
  5227.                 $Pending_april = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5228.                     "0",$user->getCityId(),"4",date('Y')
  5229.                 );
  5230.                 $Pending_april_count=count($Pending_april);
  5232.                 $assigned_april = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5233.                      "1",$user->getCityId(),"4",date('Y')
  5234.                 );
  5235.                 $assigned_april_count=count($assigned_april); 
  5237.                 $Resolved_april = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5238.                      "2",$user->getCityId(),"4",date('Y')
  5239.                 );
  5240.                 $Resolved_april_count=count($Resolved_april);
  5241.                 /*April end*/
  5242.                 /*May start*/
  5243.                 $Pending_may = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5244.                     "0",$user->getCityId(),"5",date('Y')
  5245.                 );
  5246.                 $Pending_may_count=count($Pending_may);
  5248.                 $assigned_may = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5249.                      "1",$user->getCityId(),"5",date('Y')
  5250.                 );
  5251.                 $assigned_may_count=count($assigned_may); 
  5253.                 $Resolved_may = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5254.                      "2",$user->getCityId(),"5",date('Y')
  5255.                 );
  5256.                 $Resolved_may_count=count($Resolved_may);
  5257.                 /*May end*/
  5258.                 /*June start*/
  5259.                 $Pending_june = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5260.                     "0",$user->getCityId(),"6",date('Y')
  5261.                 );
  5262.                 $Pending_june_count=count($Pending_june);
  5264.                 $assigned_june = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5265.                      "1",$user->getCityId(),"6",date('Y')
  5266.                 );
  5267.                 $assigned_june_count=count($assigned_june); 
  5269.                 $Resolved_june = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5270.                      "2",$user->getCityId(),"6",date('Y')
  5271.                 );
  5272.                 $Resolved_june_count=count($Resolved_june);
  5273.                 /*June end*/
  5274.                 /*July start*/
  5275.                 $Pending_july = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5276.                     "0",$user->getCityId(),"7",date('Y')
  5277.                 );
  5278.                 $Pending_july_count=count($Pending_july);
  5280.                 $assigned_july = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5281.                      "1",$user->getCityId(),"7",date('Y')
  5282.                 );
  5283.                 $assigned_july_count=count($assigned_july); 
  5285.                 $Resolved_july = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5286.                      "2",$user->getCityId(),"7",date('Y')
  5287.                 );
  5288.                 $Resolved_july_count=count($Resolved_july);
  5289.                 /*July end*/
  5290.                 /*August start*/
  5291.                 $Pending_aug = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5292.                     "0",$user->getCityId(),"8",date('Y')
  5293.                 );
  5294.                 $Pending_aug_count=count($Pending_aug);
  5296.                 $assigned_aug = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5297.                      "1",$user->getCityId(),"8",date('Y')
  5298.                 );
  5299.                 $assigned_aug_count=count($assigned_aug); 
  5301.                 $Resolved_aug = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5302.                      "2",$user->getCityId(),"8",date('Y')
  5303.                 );
  5304.                 $Resolved_aug_count=count($Resolved_aug);
  5305.                 /*August end*/
  5306.                 /*September start*/
  5307.                 $Pending_sep = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5308.                     "0",$user->getCityId(),"9",date('Y')
  5309.                 );
  5310.                 $Pending_sep_count=count($Pending_sep);
  5312.                 $assigned_sep = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5313.                      "1",$user->getCityId(),"9",date('Y')
  5314.                 );
  5315.                 $assigned_sep_count=count($assigned_sep); 
  5317.                 $Resolved_sep = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5318.                      "2",$user->getCityId(),"9",date('Y')
  5319.                 );
  5320.                 $Resolved_sep_count=count($Resolved_sep);
  5321.                 /*September end*/
  5322.                 /*October start*/
  5323.                 $Pending_oct = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5324.                     "0",$user->getCityId(),"10",date('Y')
  5325.                 );
  5326.                 $Pending_oct_count=count($Pending_oct);
  5328.                 $assigned_oct = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5329.                      "1",$user->getCityId(),"10",date('Y')
  5330.                 );
  5331.                 $assigned_oct_count=count($assigned_oct); 
  5333.                 $Resolved_oct = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5334.                      "2",$user->getCityId(),"10",date('Y')
  5335.                 );
  5336.                 $Resolved_oct_count=count($Resolved_oct);
  5337.                 /*October end*/
  5338.                 /*November start*/
  5339.                 $Pending_nov = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5340.                     "0",$user->getCityId(),"11",date('Y')
  5341.                 );
  5342.                 $Pending_nov_count=count($Pending_nov);
  5344.                 $assigned_nov = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5345.                      "1",$user->getCityId(),"11",date('Y')
  5346.                 );
  5347.                 $assigned_nov_count=count($assigned_nov); 
  5349.                 $Resolved_nov = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5350.                      "2",$user->getCityId(),"11",date('Y')
  5351.                 );
  5352.                 $Resolved_nov_count=count($Resolved_nov);
  5353.                 /*November end*/
  5354.                 /*December start*/
  5355.                 $Pending_dec = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5356.                     "0",$user->getCityId(),"12",date('Y')
  5357.                 );
  5358.                 $Pending_dec_count=count($Pending_dec);
  5360.                 $assigned_dec = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5361.                      "1",$user->getCityId(),"12",date('Y')
  5362.                 );
  5363.                 $assigned_dec_count=count($assigned_dec); 
  5365.                 $Resolved_dec = $this->getDoctrine()->getRepository('App\Entity\Complaint')->findByMonthYear(
  5366.                      "2",$user->getCityId(),"12",date('Y')
  5367.                 );
  5368.                 $Resolved_dec_count=count($Resolved_dec);
  5369.                 /*December end*/
  5370.                 $all_pending=[$Pending_jan_count,$Pending_feb_count,$Pending_march_count,$Pending_april_count,$Pending_may_count,$Pending_june_count,$Pending_july_count,$Pending_aug_count,$Pending_sep_count,$Pending_oct_count,$Pending_nov_count,$Pending_dec_count];
  5371.                 $implode_pending=implode(',', $all_pending);
  5373.                 $all_assigned=[$assigned_jan_count,$assigned_feb_count,$assigned_march_count,$assigned_april_count,$assigned_may_count,$assigned_june_count,$assigned_july_count,$assigned_aug_count,$assigned_sep_count,$assigned_oct_count,$assigned_nov_count,$assigned_dec_count];
  5374.                 $implode_assigned=implode(',', $all_assigned);
  5376.                 $all_resolved=[$Resolved_jan_count,$Resolved_feb_count,$Resolved_march_count,$Resolved_april_count,$Resolved_may_count,$Resolved_june_count,$Resolved_july_count,$Resolved_aug_count,$Resolved_sep_count,$Resolved_oct_count,$Resolved_nov_count,$Resolved_dec_count];
  5377.                 $implode_resolved=implode(',', $all_resolved);
  5378.             
  5379.             $page='hypervisor/team_productivity.html.twig';
  5380.         }else{
  5381.             $page='security/pagenotfound.html.twig';
  5382.         }
  5383.         return $this->render($page, 
  5384.             array(
  5385.                 'client' => $client,
  5386.                 'type_user'=>$type_user,
  5387.                 'roles_client'=>$roles_client,
  5388.                 'implode_pending'=>$implode_pending,
  5389.                 'implode_assigned'=>$implode_assigned,
  5390.                 'implode_resolved'=>$implode_resolved,
  5391.             )
  5392.         );
  5393.     }
  5397.     /**
  5398.      * @Route("/purchase-voucher", name="app_manage_purchase_voucher")
  5399.      */
  5400.     public function manage_purchase_voucher()
  5401.     {
  5402.         if ($this->getUser()) {
  5403.             $client = $this->getUser();
  5404.         } else {
  5405.             return $this->redirectToRoute('user_login');
  5406.         }
  5407.         $user = $this->getUser();
  5408.         $type_user=$user->getType();
  5409.         $allid=explode(",", $user->getRolebyadmin());
  5410.         $roles_client=$this->getDoctrine()->getRepository('App\Entity\Rolebyadmin')->findOneBySomeField($allid);
  5412.         if($type_user == "Financial Manager"){
  5414.             $page='financial/purchase_voucher.html.twig';
  5415.             $datas = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(
  5416.                 array('city'=>$user->getCityId()),
  5417.                 array('id'=>'desc'),
  5418.             );
  5419.             foreach ($datas as $key => $value) {
  5420.                 $fines = $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$value->getFine()));
  5421.                 if(!empty($fines)){
  5422.                     $datas[$key]->fines=$fines;
  5423.                 }else{
  5424.                     $datas[$key]->fines="";
  5425.                 }
  5426.                 
  5427.                 $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  5428.                     array('id'=>$value->getCity()),
  5429.                 );  
  5430.                 if(!empty($fines)){
  5431.                     $datas[$key]->citys=$citys;
  5432.                 }else{
  5433.                     $datas[$key]->citys="";
  5434.                 }
  5435.                 
  5436.                 $fc_product = $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(
  5437.                     array('fraud_com_id'=>$value->getId()),
  5438.                 );
  5439.                 if(!empty($fines)){
  5440.                     $datas[$key]->fc_product=$fc_product;
  5441.                 }else{
  5442.                     $datas[$key]->fc_product="";
  5443.                 }     
  5444.             }   
  5445.         }elseif($type_user == "Hypervisor"){
  5447.             $page='hypervisor/purchase_voucher.html.twig';
  5448.             $datas = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(
  5449.                 array('city'=>$user->getCityId()),
  5450.                 array('id'=>'desc'),
  5451.             );
  5452.             foreach ($datas as $key => $value) {
  5453.                 $fines = $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$value->getFine()));
  5454.                 if(!empty($fines)){
  5455.                     $datas[$key]->fines=$fines;
  5456.                 }else{
  5457.                     $datas[$key]->fines="";
  5458.                 }
  5459.                 
  5460.                 $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  5461.                     array('id'=>$value->getCity()),
  5462.                 );  
  5463.                 if(!empty($fines)){
  5464.                     $datas[$key]->citys=$citys;
  5465.                 }else{
  5466.                     $datas[$key]->citys="";
  5467.                 }
  5468.                 
  5469.                 $fc_product = $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(
  5470.                     array('fraud_com_id'=>$value->getId()),
  5471.                 );
  5472.                 if(!empty($fines)){
  5473.                     $datas[$key]->fc_product=$fc_product;
  5474.                 }else{
  5475.                     $datas[$key]->fc_product="";
  5476.                 }     
  5477.             }   
  5478.         }elseif($type_user == "Supervisor"){
  5480.             $page='supervisor/purchase_voucher.html.twig';
  5481.             $datas = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->findBy(
  5482.                 array('city'=>$user->getCityId()),
  5483.                 array('id'=>'desc'),
  5484.             );
  5485.             foreach ($datas as $key => $value) {
  5486.                 $fines = $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$value->getFine()));
  5487.                 if(!empty($fines)){
  5488.                     $datas[$key]->fines=$fines;
  5489.                 }else{
  5490.                     $datas[$key]->fines="";
  5491.                 }
  5492.                 
  5493.                 $citys = $this->getDoctrine()->getRepository('App\Entity\City')->findOneBy(
  5494.                     array('id'=>$value->getCity()),
  5495.                 );  
  5496.                 if(!empty($fines)){
  5497.                     $datas[$key]->citys=$citys;
  5498.                 }else{
  5499.                     $datas[$key]->citys="";
  5500.                 }
  5501.                 
  5502.                 $fc_product = $this->getDoctrine()->getRepository('App\Entity\FraudComplaintProducts')->findBy(
  5503.                     array('fraud_com_id'=>$value->getId()),
  5504.                 );
  5505.                 if(!empty($fines)){
  5506.                     $datas[$key]->fc_product=$fc_product;
  5507.                 }else{
  5508.                     $datas[$key]->fc_product="";
  5509.                 }     
  5510.             }   
  5511.         }else{
  5512.             $page='security/pagenotfound.html.twig';
  5513.             $datas="";
  5514.         }
  5515.         
  5516.         return $this->render($page, 
  5517.             array(
  5518.                 // 'form'=>$form->createView(),
  5519.                 'client' => $client,
  5520.                 'datas'=>$datas,
  5521.                 'type_user'=>$type_user,
  5522.                 'roles_client'=>$roles_client,
  5523.                 'implode_pending'=>'',
  5524.                 'implode_assigned'=>'',
  5525.                 'implode_resolved'=>'',  
  5526.             )
  5527.         );
  5528.     }
  5530.      /**
  5531.      * @Route("/update-paid-unpaid-status/{id}/{status}", name="update_paid_unpaid")
  5532.      */
  5533.      public function update_paid_unpaid($id,$status, \Swift_Mailer $mailer)
  5534.      {
  5535.           if ($this->getUser()) {
  5536.               $client = $this->getUser();
  5537.           } else {
  5538.               return $this->redirectToRoute('user_login');
  5539.           }
  5540.           $em = $this->getDoctrine()->getManager();
  5541.           $updateRequest = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->find($id);
  5542.           $updateRequest->setStatus($status);
  5543.           $updateRequest->setFinePaidDate(date( "Y-m-d", strtotime(date('Y-m-d'))));
  5544.           $em->persist($updateRequest);
  5545.           $em->flush();
  5546.        
  5547.           if($status == 1){
  5548.                if($client->getLang() == 'en'){
  5549.                   $this->addFlash('green', 'You have change to paid status of this purchase voucher');
  5550.                }else{
  5551.                   $this->addFlash('green', "Vous avez changé le statut de ce bon d'achat en statut payé.");
  5552.                }
  5553.           }else{
  5554.                if($client->getLang() == 'en'){
  5555.                   $this->addFlash('red', 'You have change to unpaid status of this purchase voucher');
  5556.                }else{
  5557.                   $this->addFlash('red', "Vous avez changé le statut de ce bon d'achat en statut non payé.");
  5558.                }
  5559.                
  5560.                $fraudcomplaint = $this->getDoctrine()->getRepository('App\Entity\FraudComplaint')->find($id);
  5561.                $pv= $this->getDoctrine()->getRepository('App\Entity\PvDetails')->findOneBy(array('id'=>$fraudcomplaint->getFine()));
  5562.                if ($pv) {
  5563.                 $fines =$pv->getAmount();
  5564.                } else {
  5565.                  $fines ="0";
  5566.                }
  5567.                 $sendTo = $fraudcomplaint->getEmail();
  5568.                 $sendCc = 'santosh.jaiswal.espl@gmail.com';
  5569.                 $mailArray = array(
  5570.                     'email' => 'infos-compte@konsoplus.com',
  5571.                     'name' => $fraudcomplaint->getShopkeeperName(),
  5572.                     'receipt_no' => $fraudcomplaint->getReceiptNo(),
  5573.                     'amount' => $fines,
  5574.                     'date' => $fraudcomplaint->getFcdate()
  5575.                 );
  5576.             if ($sendTo != "") {
  5577.                 $mail = $this->mailer->sendEmailMessage(
  5578.                     'Renouveler votre mot de passe',
  5579.                     "Konso+",
  5580.                     $sendTo,
  5581.                     $sendCc,
  5582.                     null,
  5583.                     'security/payment_remind.html.twig',
  5584.                     $mailArray
  5585.                 );
  5586.             }
  5587.           }
  5588.           return $this->redirectToRoute('app_manage_purchase_voucher');
  5589.      }
  5591.      /**
  5592.      * @Route("/request-city/", name="app_get_city")
  5593.      */
  5594.      public function get_citys(Request $request)
  5595.      {
  5596.           if($request->request->get('province'))
  5597.           {
  5598.             $result = $this->getDoctrine()->getRepository('App\Entity\City')->findBy(array('province_id'=>$request->request->get('province')),array('name'=>'asc'));
  5599.           }
  5600.           return $this->json($result);
  5601.      }
  5603.     /**
  5604.      * @Route("/request-category-list/", name="app_get_dropdown_category")
  5605.      */
  5606.     public function get_dropdown_category()
  5607.     {
  5609.         $result = $this->getDoctrine()->getRepository('App\Entity\Categorie')->findAll(array(),array('id'=>'desc'));
  5610.         return $this->json($result);
  5611.     }
  5613.     /**
  5614.      * @Route("/request-subcategory/", name="app_get_subcategory")
  5615.      */
  5616.     public function get_subcategory(Request $request)
  5617.     {
  5618.         if($request->request->get('category'))
  5619.         {
  5621.             $result = $this->getDoctrine()->getRepository('App\Entity\Subcategorie')->findBy(array('category_id'=>$request->request->get('category'),'status' => true),array('id'=>'desc'));
  5622.         }
  5623.         return $this->json($result);
  5624.     }
  5626.     /**
  5627.      * @Route("/request-validate-email/", name="app_validate_email")
  5628.      */
  5629.     public function validate_email(Request $request)
  5630.     {
  5631.         if($request->request->get('email'))
  5632.         {
  5634.             $result = $this->getDoctrine()->getRepository('App\Entity\User')->findBy(array('email'=>$request->request->get('email')),array('id'=>'desc'));
  5635.         }
  5636.         return $this->json($result);
  5637.     }
  5639.     /**
  5640.      * @Route("/request-agentgroup/", name="app_get_agentgroup")
  5641.      */
  5642.     public function get_agentgroup(Request $request)
  5643.     {
  5644.         if($request->request->get('city'))
  5645.         {
  5647.             $result = $this->getDoctrine()->getRepository('App\Entity\AgentGroup')->findBy(array('city_id'=>$request->request->get('city'),'status' => true),array('id'=>'desc'));
  5648.         }
  5649.         return $this->json($result);
  5650.     }
  5652.     /**
  5653.      * @Route("/request-get-products/", name="app_get_products")
  5654.      */
  5655.     public function get_products(Request $request)
  5656.     {
  5657.         if($request->request->get('category'))
  5658.         {
  5659.             $result = $this->getDoctrine()->getRepository('App\Entity\Products')->findBy(array('category_id'=>$request->request->get('category')));
  5660.         }
  5661.         return $this->json($result);
  5662.     }
  5663. }