///*
// * To change this license header, choose License Headers in Project Properties.
// * To change this template file, choose Tools | Templates
// * and open the template in the editor.
// */
//package br.com.ctecinf.servidor;
//
//import br.com.ctecinf.Database;
//import br.com.ctecinf.Log;
//import br.com.ctecinf.http.Handler;
//import br.com.ctecinf.text.DateFormatter;
//import br.com.ctecinf.text.NumberFormatter;
//import java.sql.Connection;
//import java.sql.ResultSet;
//import java.sql.SQLException;
//import java.sql.Statement;
//import java.util.Map;
//
///**
// *
// * @author cassio
// */
//public class ListReceitasCliente extends Handler {
//
//    public ListReceitasCliente() {
//        super("list-receitas-cliente", TYPE_HTML);
//    }
//
//    @Override
//    protected byte[] getResponse(Map requestParams) {
//
//        Object clienteId = requestParams.get("cliente_id") == null ? null : requestParams.get("cliente_id");
//
//        if (clienteId == null) {
//            return null;
//        }
//
//        String query = "SELECT * FROM receita WHERE cliente_id=" + clienteId + " ORDER BY data_encomenda DESC";
//
//        StringBuilder html = new StringBuilder();
//
//        try (Connection conn = Database.openConnection(); Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(query)) {
//
//            while (rs.next()) {
//
//                html.append("<fieldset class=\"ui-widget ui-widget-content ui-corner-all\">");
//
//                html.append("<legend><b> ").append(DateFormatter.format().format(rs.getDate("data_encomenda"))).append(" </b></legend>");
//
//                html.append("<p>");
//                html.append("<b>Armação</b>: ").append(rs.getObject("armacao") == null ? "" : rs.getObject("armacao"));
//                html.append("</p>");
//
//                html.append("<p>");
//                html.append("<b>Lente</b>: ").append(rs.getObject("lente") == null ? "" : rs.getObject("lente"));
//                html.append("</p>");
//
//                html.append("<fieldset><legend><b>LONGE</b></legend>");
//                html.append("O.D.:&nbsp;&nbsp;").append(NumberFormatter.format(2).format(rs.getDouble("longe_direito_esferico"))).append("&nbsp;&nbsp;&nbsp;").append(NumberFormatter.format(2).format(rs.getDouble("longe_direito_cilindrico"))).append("&nbsp;&nbsp;&nbsp; X &nbsp;&nbsp;&nbsp;").append(rs.getInt("longe_direito_eixo")).append("º<br />");
//                html.append("O.E.:&nbsp;&nbsp;").append(NumberFormatter.format(2).format(rs.getDouble("longe_esquerdo_esferico"))).append("&nbsp;&nbsp;&nbsp;").append(NumberFormatter.format(2).format(rs.getDouble("longe_esquerdo_cilindrico"))).append("&nbsp;&nbsp;&nbsp; X &nbsp;&nbsp;&nbsp;").append(rs.getInt("longe_esquerdo_eixo")).append("º");
//                html.append("</fieldset>");
//
//                html.append("<fieldset><legend><b>PERTO</b></legend>");
//                html.append("O.D.:&nbsp;&nbsp;").append(NumberFormatter.format(2).format(rs.getDouble("perto_direito_esferico"))).append("&nbsp;&nbsp;&nbsp;").append(NumberFormatter.format(2).format(rs.getDouble("perto_direito_cilindrico"))).append("&nbsp;&nbsp;&nbsp; X &nbsp;&nbsp;&nbsp;").append(rs.getInt("perto_direito_eixo")).append("º<br />");
//                html.append("O.E.:&nbsp;&nbsp;").append(NumberFormatter.format(2).format(rs.getDouble("perto_esquerdo_esferico"))).append("&nbsp;&nbsp;&nbsp;").append(NumberFormatter.format(2).format(rs.getDouble("perto_esquerdo_cilindrico"))).append("&nbsp;&nbsp;&nbsp; X &nbsp;&nbsp;&nbsp;").append(rs.getInt("perto_esquerdo_eixo")).append("º");
//                html.append("</fieldset>");
//
//                html.append("<p>");
//                html.append("<b>DNP</b>: ").append(rs.getObject("dnp") == null ? "" : rs.getObject("dnp")).append("&nbsp;&nbsp;&nbsp;<b>Altura</b>:").append(rs.getObject("altura") == null ? "" : rs.getObject("altura")).append("&nbsp;&nbsp;&nbsp;<b>Adição</b>:").append(rs.getObject("adicao") == null ? "" : rs.getObject("adicao"));
//                html.append("</p>");
//
//                html.append("<p>");
//                html.append("Médico: ").append(rs.getObject("medico") == null ? "" : rs.getObject("medico"));
//                html.append("</p>");
//
//                html.append("<p>");
//                html.append("Vendedor: ").append(rs.getObject("vendedor") == null ? "" : rs.getObject("vendedor"));
//                html.append("</p>");
//
//                html.append("</fieldset><br /><br /><br />");
//            }
//
//        } catch (SQLException ex) {
//            html.append("<p class=\"ui-widget ui-state-error ui-corner-all ui-widget-padding-all\">");
//            html.append(ex.getMessage());
//            html.append("</p>");
//            Log.create(ex);
//        }
//
//        return html.toString().getBytes();
//    }
//}