<?php
class DashboardController extends CI_Controller
{

	function  __construct()
	{
		parent::__construct();
		$this->load->helper(array('model', 'form_helper', 'validar'));
		$this->load->library('session');
		$this->load->model('admin_model');
		//$this->load->model('contrato_model');
		valida_sesion($this->session->userdata('token_usuario'));
		define("STAFF_ID", '' . $this->session->userdata('rt_staff') . '');
	}

	function index()
	{
		redirect(base_url('dashboard'));
	}

	function dashboard()
	{
		$data['title'] = 'Dashboard';
		$query = $this->db->query("select count(id) total_preingreso, (select count(id) from movimientos_reloj) total
									from movimientos_reloj
									where diferencia_ingreso > 0");
		$data['igresos'] = $query->row();

		$query = $this->db->query("select count(id) total_salida, (select count(id) from movimientos_reloj) total
									from movimientos_reloj
									where diferencia_salida < 0");
		$data['salidas'] = $query->row();

		$query = $this->db->query("select count(id) total_salida, (select count(id) from movimientos_reloj) total
									from movimientos_reloj
									where salida = '00:00:00'");
		$data['sin_salidas'] = $query->row();

		$query = $this->db->query("SELECT 
										DATE_FORMAT(fecha, '%Y-%m') AS mes,
										rut,
										ROUND(SUM(TIME_TO_SEC(atraso) / 60) + SUM(TIME_TO_SEC(ausencia) / 60)) AS minutos_ausencias,
										ROUND(SUM(TIME_TO_SEC(total_jornada) / 60)) AS jornada_minutos
									FROM movimientos_reloj
									WHERE DATE_FORMAT(fecha, '%Y-%m') = '2023-11'
									GROUP BY rut, mes, fecha
									ORDER BY fecha DESC;
									");
		$data['cumplimiento'] = $query->result();

		//pre_die($data['igresos']);
		$data['main_content'] = 'admin/index_view';
		$data['home_btn'] = true;
		$this->load->view('shared/layout', $data);
	}
}