<?php

/**
 * Created by PhpStorm.
 * User: Ulises Morales
 * Date: 27/02/2018
 * Time: 11:06 AM
 */
Class Users_model extends CI_Model
{
    function __construct()
    {
        parent::__construct();
        $this->load->database();
    }

/*/  MOSTRAR UBICACION
    public function listUsers()
    {
        $query = $this->db->query("SELECT p.name, p.paternal_lastName, p.maternal_lastName, u.email_institutional, g.group_name FROM auth_user u,auth_group g, auth_user_groups ug, employee p WHERE u.id_employee_fk = p.id_employee AND ug.id_auth_user_fk = u.id_auth_user AND ug.id_auth_group_fk = g.id_auth_group AND status = 1");
        return $query->result();
    }*/
//  MOSTRAR UBICACION
    public function listUsers()
    {
        $query = $this->db->query("SELECT e.name,e.paternal_lastName,e.maternal_lastName,u.email_institutional,GROUP_CONCAT(g.group_name SEPARATOR ', ') AS group_name FROM employee e,auth_user_groups ug, auth_user u, auth_group g WHERE ug.id_auth_user_fk = u.id_auth_user AND ug.id_auth_group_fk = g.id_auth_group AND u.id_employee_fk = e.id_employee GROUP BY e.name");
        return $query->result();
    }

    public function insertUser($user_name, $email_institutional, $password, $id_role_fk, $id_employee, $is_employee, $id_student)
    {
        $arrayDatos = array(
            'user_name' => $user_name,
            'email_institutional' => $email_institutional,
            'password' => md5($password),
            'id_role_fk' => $id_role_fk,
            'is_employee' => $is_employee,
            'id_employee_fk' => $id_employee
        );
        $this->db->insert('auth_user', $arrayDatos);
    }

    public function insertUserStudent($user_name, $email_institutional, $password, $id_role_fk, $id_employee)
    {
        $arrayDatos = array(
            'user_name' => $user_name,
            'email_institutional' => $email_institutional,
            'password' => md5($password),
            'id_role_fk' => $id_role_fk,
            'is_student' => 1,
            'id_employee_fk' => $id_employee
        );
        $this->db->insert('auth_user', $arrayDatos);
    }
}