404

D7net
:/ var / www / html / chatweb02 / application / controllers / api / v1 /
Filename : Enviar.php
back
<?php

require APPPATH . 'libraries/REST_Controller.php';

class Enviar extends REST_Controller {

	  /**
     * Get All Data from this method.
     *
     * @return Response
    */
    public function __construct() {
       parent::__construct();
       $this->load->database();
    }

    
    /**
     * Get All Data from this method.
     *
     * @return Response
    */
    public function index_post()
    {      
        $input = $this->input->post();
         $data['cht_men_texto'] = $input['msg'];
		 $data['cht_men_uuid'] = $input['uuid'];
		 $data['cht_men_tipo'] = $input['type'];
		 $data['cht_men_dhentrada'] = $input['dtenvio'];
		 $data['cht_con_id'] = $input['conversa'];
		 $data['cht_usu_id'] = $input['id'];

         $sql = "SELECT cgu.cht_usu_id, cu.cht_usu_online, con.cht_con_id , IFNULL(cht_cmc_qntd,0) cht_cmc_qntd
                   FROM cht_conversa con 
                 INNER JOIN cht_grupo_usuario cgu  ON cgu.cht_con_id  = con.cht_con_id 
                 INNER JOIN cht_usuarios cu  ON cu.cht_usu_id  = cgu.cht_usu_id  
                 LEFT JOIN cht_conversa_mensagem_count cmc ON cu.cht_usu_id  = cmc.cht_usu_id  AND cmc.cht_con_id  = con.cht_con_id 
                 WHERE con.cht_con_id  = {$data['cht_con_id']}";
         $query = $this->db->query($sql);
		 $results = $query->result();
         foreach($results as $result){
            $datacount['cht_usu_id']   = $result->cht_usu_id;
            $datacount['cht_con_id']   = $result->cht_con_id;
            $datacount['cht_cmc_qntd'] = ($result->cht_cmc_qntd + 1) ;
            $this->db->query("DELETE FROM cht_conversa_mensagem_count WHERE cht_usu_id  = {$result->cht_usu_id}  AND cht_con_id  = {$result->cht_con_id}");
            $this->db->insert('cht_conversa_mensagem_count', $datacount);   
         }
         
         $this->db->insert('cht_conversa_mensagem', $data);
         
		 $this->response(['Item created successfully.'], REST_Controller::HTTP_CREATED);
    }
}