<%@ page import="java.io.*,java.sql.*"%>

<%@ page import ="java.sql.Timestamp" %>
<%@ page import ="java.time.LocalDateTime" %>
<%@ page import ="java.time.format.DateTimeFormatter" %>

<%

DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");

Timestamp current = Timestamp.valueOf(LocalDateTime.now().format(formatter));



// String filename = "SalesReport_" + current + ".csv";
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://xxxx","xxxx", "xxxx");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from auctions where status='inactive'");

String nameOfTextFile = "SalesReport_" + current + ".csv";


try
{
    PrintWriter writer = new PrintWriter(new FileOutputStream(nameOfTextFile));

    writer.append("auction_id");
    writer.append(',');
    writer.append("item_id");
    writer.append(',');
    writer.append("start_price");
    writer.append(',');
    writer.append("start_time");
    writer.append(',');
    writer.append("end_time");
    writer.append(',');
    writer.append("seller_id");
    writer.append(',');
    writer.append("buyer_id");
    writer.append(',');
    writer.append("sale_price");
    writer.append('n');

    while(rs.next())
    {
        writer.append(rs.getString("aucID"));
        writer.append(',');
        writer.append(rs.getString("itemid"));
        writer.append(',');
        writer.append(rs.getString("startprice"));
        writer.append(',');
        writer.append(rs.getString("startdatetime"));
        writer.append(',');
        writer.append(rs.getString("enddatetime"));
        writer.append(',');
        writer.append(rs.getString("seller"));
        writer.append(',');
    }

    ResultSet rs6 = st.executeQuery("select MAX(bidamount),bidder from bids where auctionref="+rs.getString("aucID"));
    while(rs6.next()){
        writer.append(rs6.getString("bidder"));
        writer.append(',');
        writer.append(rs6.getString("MAX(bidamount)"));
        writer.append('n');
    }

    con.close();
    out.println("Successfully Created Csv file.");
    writer.flush();
    writer.close();



} catch (Exception e) {
e.printStackTrace();
}
%>