<%@page import="dk.au.hum.imv.persistence.db.*,
java.util.*, classes.*, daos.*"%>

    <%@ include file="header.jsp"%>


    <% User user = UserDao.getUserById(sModel.getUser_id());

    int foreignKeyUser = (int) user.getUser_id();




 %>
            <!-- OPRET FEEDBACK FORM START -->

    <form action="feedback.jsp" method="post">

                        Skriv din tekst her: <br/>
                        <div class="form-group">
                            <input type="text" value="" name="text" class="inputField"></input>
                        </div>
                        <br>
                        <input type="submit" value="create" name="create"></input>
                        </form>
                        <!-- OPRET FEEDBACK FORM SLUT -->
                            <%
                //OPRET FEEDBACK START
            JDBCConnectionFactory.initManualConnectionHandling("jdbc:mysql://student.hum.au.dk:3306/u201709137",
                    "u201709137", "4W5Vn55y", "com.mysql.jdbc.Driver");
            String createButton = request.getParameter("create");

            if (createButton != null) {
                int feedback_user_id = foreignKeyUser;
                String feedback_text = request.getParameter("text");




                Feedback feedback = new Feedback(foreignKeyUser, feedback_text, new java.sql.Date(System.currentTimeMillis()));
                FeedbackDao.createFeedback(feedback);
            }
                //OPRET FEEDBACK SLUT
             %>



            <!-- UDSKRIV FEEDBACK TIL SIDEN START -->

    <% ArrayList<Feedback> feedbacks = null;
    feedbacks = FeedbackDao.getAllFeedback();

    %>


    <table id="feedback">
            <tr>
                <th>Navn</th>
                <th>Feedback</th>
                <th>Dato</th>
            </tr>


            <%
                int counter = 0;

            for (Feedback feedback : feedbacks) {
            counter++;
            %>

            <tr id=<%=counter%>>

    <% int foreignUserId = feedback.getFeedback_user_id();

        String idToName = UserDao.getUsersNameById(foreignUserId);
        String feedbackText = feedback.getFeedback_text();
        Date date = feedback.getFeedback_date();
    %>

            <tr>
                <td class="tableData"><%=idToName%></td>
                <td class="tableData"><%=feedbackText%></td>
                <td class="tableData"><%=date%></td>
            </tr>

            <%
                }
            %>

        </table>


            <!-- UDSKRIV FEEDBACK TIL SIDEN SLUT -->


        <%@ include file="footer.jsp"%>