src/Controller/ApiController.php line 53

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\Routing\Annotation\Route;
  8. use Webkul\UVDesk\CoreFrameworkBundle\Entity\User;
  9. use Symfony\Component\HttpFoundation\JsonResponse;
  10. use Doctrine\ORM\EntityManagerInterface;
  11. use Symfony\Component\HttpFoundation\Request;
  13. class ApiController extends AbstractController
  14. {
  15. private $entityManager;
  20. #[Route('/api', name: 'app_api')]
  21. public function common_issue(): Response
  22. {
  24. // return new Response( "daadasdd");
  25. $entityManager = $this->getDoctrine()->getManager();
  26. $customer = $entityManager->getRepository(User::class)->findAll();
  28. //
  29. $connection = $entityManager->getConnection();
  30. $sql = "SELECT * FROM uv_common_issue"; // Replace "user" with your table name
  31. $statement = $connection->prepare($sql);
  32. $statement->execute();
  33. $common_issue = $statement->fetchAll();
  34. // $common_issue = ['Common Issue 1','Common Issue 2','Common Issue 3','Common Issue 4',];
  35. if(count($common_issue)> 0){
  36. $data = ['message' =>"Common Issue Fetched", 'status' => true, 'common_issue' => $common_issue];
  37. }else{
  38. $data = ['message' =>"No Data Found !", 'status' => false, 'common_issue' => []];
  39. }
  41. return $this->json($data);
  43. // Convert the User entities to an array
  47. // return $this->render('api/index.html.twig', [
  48. // 'controller_name' => 'ApiController',
  49. // ]);
  50. }
  52. // #[Route('/api', name: 'app_api')]
  53. public function update_fcm_token(Request $request)
  54. {
  56. $requestContent = $request->request->all() ?: json_decode($request->getContent(), true);
  57. // return new Response( "daadasdd");
  58. $entityManager = $this->getDoctrine()->getManager();
  59. $customer = $entityManager->getRepository(User::class)->findAll();
  61. //
  62. $connection = $entityManager->getConnection();
  63. $sql = "SELECT * FROM uv_user where email = '".$requestContent['email']."'"; // Replace "user" with your table name
  64. $statement = $connection->prepare($sql);
  65. $statement->execute();
  66. $users = $statement->fetchAll();
  68. // $common_issue = ['Common Issue 1','Common Issue 2','Common Issue 3','Common Issue 4',];
  69. if(count($users)> 0){
  71. if(isset($requestContent['mobile']) && $requestContent['mobile'] != ""){
  73. $sql = 'UPDATE `uv_user` SET `fcm_token` = "'.$requestContent['fcm_token'].'" ,`mobile` = "'.$requestContent['mobile'].'" WHERE `uv_user`.`email` = "'.$requestContent['email'].'"';
  74. }else{
  76. $sql = 'UPDATE `uv_user` SET `fcm_token` = "'.$requestContent['fcm_token'].'" WHERE `uv_user`.`email` = "'.$requestContent['email'].'"';
  77. }
  78. // dd($sql);
  80. $connection = $entityManager->getConnection();
  81. $statement = $connection->prepare($sql);
  82. $statement->execute();
  84. // dd($users);
  85. $data = ['message' =>"FCM Token Updated Sucessfully", 'status' => true, 'token' => $requestContent['fcm_token'], 'email' => $requestContent['email']];
  86. }else{
  87. $data = ['message' =>"No Data Found !", 'status' => false];
  88. }
  90. return $this->json($data);
  92. // Convert the User entities to an array
  96. // return $this->render('api/index.html.twig', [
  97. // 'controller_name' => 'ApiController',
  98. // ]);
  99. }
  100. }