package com.axisj.axboot.admin.controllers;

import com.axisj.axboot.admin.parameter.CommonListResponseParams;
import com.axisj.axboot.admin.parameter.PageableResponseParams;
import com.axisj.axboot.core.api.response.ApiResponse;
import com.axisj.axboot.core.controllers.BaseController;
import com.axisj.axboot.core.domain.order.Order;
import com.axisj.axboot.core.domain.order.OrderService;
import com.axisj.axboot.core.domain.order.OrderVO;
import com.axisj.axboot.core.domain.sample.parent.ParentSample;
import com.axisj.axboot.core.domain.sample.parent.ParentSampleService;
import com.axisj.axboot.core.domain.sample.parent.ParentSampleVO;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.web.bind.annotation.*;
import org.springframework.stereotype.Controller;
import org.springframework.data.domain.Pageable;

import javax.inject.Inject;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;


@Controller
@RequestMapping(value = "/api/v1/orders")
public class OrderController extends BaseController {

    @Inject
    private OrderService orderService;

    @Inject
    private ParentSampleService parentService;


    @RequestMapping(value = "/order", method = RequestMethod.GET, produces = APPLICATION_JSON)
    public PageableResponseParams.PageResponse list(Pageable pageable) {
        Page<Order> orderPage = orderService.findAll(pageable);
        return PageableResponseParams.PageResponse.of(OrderVO.of(orderPage.getContent()), orderPage);
    }

    /*
        @RequestMapping(value = "/test", method = RequestMethod.GET, produces = APPLICATION_JSON)
        public OrderVO orderVO(String orderUserNm){
            OrderVO orderVO = new OrderVO();

            String url = "jdbc:mysql://14.63.169.27:3306/test";
            String id = "jhma";
            String pass = "jhma";
            Connection con = null;
            String SQL = "SELECT * FROM TB_ORDER WHERE ORDER_CD = '" + 1 + "'";
            PreparedStatement pstmt = null;
            ResultSet rs = null;

            try {
                Class.forName("com.mysql.jdbc.Driver");
                con = DriverManager.getConnection(url, id, pass);


            pstmt = con.prepareStatement(SQL);
            rs = pstmt.executeQuery();

            while(rs.next()){
                orderVO.setOrderCd(rs.getInt(1));
                orderVO.setOrderUserNm(rs.getString(2));
                orderVO.setAcceptedOrnot(rs.getInt(3));
                orderVO.setManagedOrnot(rs.getInt(4));
                orderVO.setTicketCd(rs.getInt(5));
                orderVO.setOrderCnt(rs.getInt(6));
            }
            }catch(Exception e){
                e.printStackTrace();
            }
            return orderVO;
        }
    */
    @RequestMapping(value = "/tests", method = RequestMethod.GET, produces = APPLICATION_JSON)
    public ArrayList<OrderVO> orderVOs(String orderUserNm) {
        ArrayList<OrderVO> orderVOs = new ArrayList<OrderVO>();

        String url = "jdbc:mysql://14.63.169.27:3306/test";
        String id = "jhma";
        String pass = "jhma";
        Connection con = null;
        String SQL = "SELECT * FROM TB_ORDER";
        PreparedStatement pstmt = null;
        ResultSet rs = null;

        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection(url, id, pass);


            pstmt = con.prepareStatement(SQL);
            rs = pstmt.executeQuery();

            while (rs.next()) {
                OrderVO orderVO = new OrderVO();

                orderVO.setOrderCd(rs.getInt(1));
                orderVO.setOrderUserNm(rs.getString(2));
                orderVO.setAcceptedOrnot(rs.getInt(3));
                orderVO.setManagedOrnot(rs.getInt(4));
                orderVO.setTicketCd(rs.getInt(5));
                orderVO.setOrderCnt(rs.getInt(6));

                orderVOs.add(orderVO);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return orderVOs;
    }

    @RequestMapping(method = {RequestMethod.PUT}, produces = APPLICATION_JSON)
    public Order save(@RequestBody Order request) {
        orderService.save(request);
        return request;
    }


    @RequestMapping(value = "/parent", method = RequestMethod.GET, produces = APPLICATION_JSON)
    public PageableResponseParams.PageResponse parentList(Pageable pageable) {
        Page<ParentSample> pages = parentService.findAll(pageable);
        return PageableResponseParams.PageResponse.of(ParentSampleVO.of(pages.getContent()), pages);
    }

}