vendor/uvdesk/core-framework/Controller/Calendar.php line 28

Open in your IDE?
  1. <?php
  3. namespace Webkul\UVDesk\CoreFrameworkBundle\Controller;
  5. use Symfony\Component\Translation\TranslatorInterface;
  6. use Webkul\UVDesk\CoreFrameworkBundle\Form;
  7. use Webkul\UVDesk\CoreFrameworkBundle\Entity\User;
  8. use Webkul\UVDesk\CoreFrameworkBundle\Entity\SupportTeam;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Symfony\Component\HttpFoundation\Response;
  11. use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  12. use Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface;
  13. use Mysqli;
  15. class Calendar extends Controller
  16. {
  17.     /**
  18.      * @var TranslatorInterface
  19.      */
  21.     public function __construct()
  22.     {
  24.     }
  28.     public function listTeams(Request $request)
  29.     {
  31.         if ($request->isXmlHttpRequest()) {
  33.             $mysqli = $this->conectionTKT();
  34.             $consulta = "SELECT * FROM calendar_access";
  36.             $events = [];
  37.             if ($resultado = $mysqli->query($consulta)) {
  39.                 while ($fila = $resultado->fetch_assoc()) {
  40.                     $fila['eventStartDate']=$fila['start'];
  41.                     $fila['eventEndDate']=$fila['end'];
  43.                     $color = 'orange';
  44.                     switch ($fila['status']) {
  45.                         case 0:
  46.                             $color = 'orange';
  47.                             break;
  48.                         case 1:
  49.                             $color = 'green';
  50.                             break;
  51.                         case 2:
  52.                             $color = 'red';
  53.                             break;
  54.                     }
  56.                     $fila['backgroundColor']=$color;
  57.                     $events[] = $fila;
  58.                 }
  61.                 $resultado->close();
  62.             }
  65.             $mysqli->close();
  67.             return new Response(json_encode($events), 200, ['Content-Type' => 'application/json']);
  68.         } else {
  69.             return $this->render('@UVDeskCoreFramework/Calendar/calendar.html.twig');
  70.         }
  73.     }
  78.     public function create(Request $request)
  79.     {
  81.         $title = $request->request->get('title');
  82.         $description = $request->request->get('description');
  83.         $status = $request->request->get('status');
  84.         $start = $request->request->get('start');
  85.         $end = $request->request->get('end');
  89.         $mysqli = $this->conectionTKT();
  90.         $consulta = "INSERT INTO calendar_access (title,description,agent_id,status,start,end,created_at,updated_at) VALUES ('".$title."','".$description."','".$this->getUser()->getId()."','".$status."','".date('Y-m-d H:i:s', strtotime($request->request->get('start')))."','".date('Y-m-d H:i:s', strtotime($request->request->get('end')))."','".date('Y-m-d H:i:s')."','".date('Y-m-d H:i:s')."')";
  92.         if ($mysqli->query($consulta) === TRUE) {
  93.             return new Response(json_encode("ok"), 200, ['Content-Type' => 'application/json']);
  94.         } else {
  95.             return new Response(json_encode($mysqli->error), 500, ['Content-Type' => 'application/json']);
  96.         }
  98.         $mysqli->close();
  101.     }
  104.     public function update(Request $request)
  105.     {
  106.         $id = $request->request->get('id');
  107.         $title = $request->request->get('title');
  108.         $description = $request->request->get('description');
  109.         $status = $request->request->get('status');
  110.         $start = $request->request->get('start');
  111.         $end = $request->request->get('end');
  113.         $mysqli = $this->conectionTKT();
  114.         $consulta = "UPDATE calendar_access SET title = '".$title."' ,description = '".$description."',agent_id= '".$this->getUser()->getId()."',status = '".$status."',start = '".date('Y-m-d H:i:s', strtotime($start))."',end = '".date('Y-m-d H:i:s', strtotime($end))."',created_at = '".date('Y-m-d H:i:s')."',updated_at = '".date('Y-m-d H:i:s')."'  WHERE id = '".$id."'";
  116.         if ($mysqli->query($consulta) === TRUE) {
  117.             return new Response(json_encode("ok"), 200, ['Content-Type' => 'application/json']);
  118.         } else {
  119.             return new Response(json_encode($mysqli->error), 500, ['Content-Type' => 'application/json']);
  120.         }
  122.         $mysqli->close();
  125.     }
  127.     public function delete(Request $request)
  128.     {
  129.         $id = $request->request->get('id');
  132.         $mysqli = $this->conectionTKT();
  133.         $consulta = "DELETE FROM calendar_access WHERE id = '".$id."'";
  135.         if ($mysqli->query($consulta) === TRUE) {
  136.             return new Response(json_encode("ok"), 200, ['Content-Type' => 'application/json']);
  137.         } else {
  138.             return new Response(json_encode($mysqli->error), 500, ['Content-Type' => 'application/json']);
  139.         }
  141.         $mysqli->close();
  144.     }
  146.     public function conectionTKT(){
  148.     // ticketera:Qn0is837Zo102@database-plesk.cfcc6wi065dc.us-east-1.rds.amazonaws.com
  149.         $mysqli = new mysqli("database-plesk.cfcc6wi065dc.us-east-1.rds.amazonaws.com", "ticketera", "Qn0is837Zo102", "admin_tkt2");
  150.         //$mysqli = new mysqli("localhost", "root", "root", "ticketerasg");
  152.         /* comprobar la conexión */
  153.         if ($mysqli->connect_errno) {
  154.             printf("Falló la conexión: %s\n", $mysqli->connect_error);
  155.             exit();
  156.         }
  158.         return $mysqli;
  159.     }
  162. }