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

import br.com.elotech.websaude.odontograma.ui.Application;

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 AtendimentoModel {

    static String SQL = "";
    static PreparedStatement pstmt;

    public ResultSet buscaRetornoOrigem(Integer ageCodigo) throws SQLException {

        if(ageCodigo==null){
            ResultSet rs = new AgendamentoModel().usuEmAberto();
            if(rs!=null){
                ageCodigo = rs.getInt("age_codigo");
            }
        }

        if(ageCodigo==null) {
            SQL = "SELECT age_codigo FROM atendimento WHERE ate_codigo=?";
            pstmt = CONN.prepareStatement(SQL);
            pstmt.setLong(1,Long.valueOf(Application.args[7]));
            ResultSet rs = pstmt.executeQuery();
            if(rs.next())
                ageCodigo = rs.getInt("age_codigo");

        }

        SQL = "SELECT ate.ate_codigo,ate.gd_codigo,ate.ate_encaminhamento,age.age_atendido FROM atendimento ate " +
                "INNER JOIN agendamento age ON age.age_codigo=ate.age_codigo " +
                "WHERE ate.age_codigo=? " +
                "ORDER BY ate.ate_codigo";
        pstmt = CONN.prepareStatement(SQL);
        pstmt.setInt(1, ageCodigo);

        return pstmt.executeQuery();
    }
}