package br.com.elotech.websaude.odontograma.backend.model;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import static br.com.elotech.websaude.odontograma.backend.model.dao.Conexao.CONN;

public class AgendamentoModel {

    static PreparedStatement pstmt = null;
    static String SQL = "";

    public ResultSet usuEmAberto() throws SQLException {

        return null;
    }

    public ResultSet verificaAtendimentoPerdido(Integer usrCodigo) throws SQLException {

        SQL = "SELECT a.* FROM agendamento a " +
                "INNER JOIN usuarios u ON u.usr_codigo=a.usr_cod_atendendo " +
                "INNER JOIN especialidade e ON e.esp_codigo=a.esp_codigo " +
                "INNER JOIN usuario usu ON usu.usu_codigo=a.usu_codigo " +
                "WHERE a.age_atendido IN ('E','I') AND " +
                "to_char(a.age_data, 'YYYY-MM-dd') = to_char(now(), 'YYYY-MM-dd') AND " +
                "a.med_codigo = ? AND " +
                "ORDER BY a.age_data_atend desc " +
                "LIMIT 1";
        pstmt = CONN.prepareStatement(SQL);
        pstmt.setInt(1,usrCodigo);

        return pstmt.executeQuery();
    }
}