404

D7net
:/ var / www / html / chatweb02 / application / models /
Filename : Usuario_model.php
back
<?php

defined('BASEPATH') OR exit('No direct script access allowed');

Class Usuario_model extends CI_Model
{
	function __construct()
	{
		parent::__construct();
		@$this->load->database();
	}

	function gets($data)
	{
		$sql = "SELECT *
				FROM cht_usuarios
				WHERE 1=1
				";
		if(!empty($data['cht_usu_id'])) {
			$sql .=" AND cht_usu_id = '{$data['cht_usu_id']}'";
		}
		if(!empty($data['cht_usu_login'])) {
			$sql .=" AND cht_usu_login = '{$data['cht_usu_login']}'";
		}
		$sql .=" ORDER BY cht_usu_id";
		if(!empty($data['pagina'])){
			$data['pagina'] = $data['pagina'] - 1;
			$sql.=" limit {$data['pagina']}, 5";
		}
		$query = $this->db->query($sql);
		return $query->result();

	}

	function set($data)
	{
		if(empty($data['cht_usu_id'])) {
			if($this->db->insert('cht_usuarios', $data)){
				return $this->db->insert_id();
			}
		}else {
			$this->db->where('cht_usu_id', $data['cht_usu_id']);
			if($this->db->update('cht_usuarios', $data)){
				$this->db->last_query();
				return $data['cht_usu_id'];
			}
		}

	}

	function getlogin($datas)
	{

		$sql = "SELECT
				usu.*
				FROM cht_usuarios usu
				WHERE usu.cht_usu_login = '{$datas['cht_usu_login']}'
				AND usu.cht_usu_senha = '{$datas['cht_usu_senha']}'
				AND ( usu.cht_usu_status = 'A' OR usu.cht_usu_status IS NULL )";
		$query = $this->db->query($sql);
		return $query->result();
    }

	function status($filtro )
	{
		$sql = "UPDATE cht_usuarios SET cht_usu_online = '{$filtro['cht_usu_online']}'
				WHERE cht_usu_id = '{$filtro['cht_usu_id']}'";
		$query = $this->db->query($sql);
	}

	function setperfil($data)
	{
		$this->db->where('cht_usu_id', $data['cht_usu_id']);
		$this->db->update('cht_usuarios', $data);
		return $data['cht_usu_id'];
	}
}