package hall;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.Date;

public class opOrder {

	private Vector orderItemList;

	private Vector orderList;
	
	private Vector products;

	private int page = 1; //顯示的頁碼

	private int pageSize = 15; //每頁顯示的留言數

	private int pageCount = 0; //頁面總數

	private long recordCount = 0; //查詢的記錄總數	
	
	private double account = 0.0;

	private DBWrapper myConnection = null;

	private String sqlStr = "";

	public opOrder() throws Exception {

		myConnection = DBWrapper.Instance();

	}
	
	public Vector getOrderList(){
		return orderList;
	}
	
	public Vector getProducts(){
		return products;
	}
	
	public Vector getOrderItemList(){
		return orderItemList;
	}
	public int getPage() { //顯示的頁碼
		return page;
	}

	public void setPage(int newpage) {
		page = newpage;
	}

	public int getPageSize() { //每頁顯示的圖書數
		return pageSize;
	}

	public void setPageSize(int newpsize) {
		pageSize = newpsize;
	}

	public int getPageCount() { //頁面總數
		return pageCount;
	}

	public void setPageCount(int newpcount) {
		pageCount = newpcount;
	}

	public long getRecordCount() {
		return recordCount;
	}

	public void setRecordCount(long newrcount) {
		recordCount = newrcount;
	}

	//管理員確認發貨
	public boolean modifedOrder(long inItem, String inOrderWay, String inSender) {
		boolean flag = false;
		try {
			sqlStr = "update orders set ";
			sqlStr += "orderWay = '" + inOrderWay + "',";
			sqlStr += "sender = '" + inSender + "',";
			sqlStr += "state = " + 2 + " ";
			sqlStr += "where orders = " + inItem;

			System.out.println(sqlStr);
			myConnection.runUpdate(sqlStr);
			flag = true;
		} catch (Exception e) {
			flag = false;
			System.out.println(e);
		}
		return flag;
	}

	//管理員確定已發貨
	public boolean check(long inItem) throws Exception {
		Date tempDate = new Date();
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd hh:mm:ss");
		String sdate = sdf.format(tempDate);
		try {
			sqlStr = "update orders set ";
			sqlStr += "receiveTime = '" + sdate + "',";
			sqlStr += "state = " + 3 + " ";
			sqlStr += "where OrderItem = " + inItem;

			System.out.println(sqlStr);
			myConnection.runUpdate(sqlStr);
			return true;
		} catch (Exception e) {
			System.out.println(sqlStr);
			return false;
		}
	}

	public boolean query(int inYear, int inMonth, int inDay, String inArea) {
		boolean flag = true;

		if (inArea == null)
			inArea = "";

		int year = inYear;
		int month = inMonth;
		int day = inDay;
		String date;
		if (year == 0) {
			date = "";
		} else {
			if (month == 0) {
				date = year + "";
			} else {
				if (day == 0)
					date = year + "/" + month;
				else
					date = year + "/" + month + "/" + day;
			}
		}
		sqlStr = "select sum(amount) from orders where orderTime like '%"
				+ date + "%'" + " and address like '%" + inArea + "%'";
		try {
			System.out.println(sqlStr);
			ResultSet rs1 = myConnection.runQuery(sqlStr);
			rs1.next();
			account = rs1.getInt(1);
			flag = true;
		} catch (Exception e) {
			flag = false;
			System.out.println(e);
		}
		return flag;
	}

	//用戶查看帳單
	public boolean getOrder(String userName,int state) throws Exception {
		String sqlStr1 = "";
		if(state == 0){
			sqlStr1 = "select count(*) from orders where customerName = '" + userName + "'"; 
		}
		else if(state == 1 || state == 2 || state ==3){
			sqlStr1 = "select count(*) from orders where state = " + state
					+ "and customerName = '" + userName + "'";;
		}
		else
			return false;
		try {
			ResultSet rs1 = myConnection.runQuery(sqlStr1);
			if (rs1.next())
				recordCount = rs1.getInt(1);
			rs1.close();
	
		} catch (SQLException e) {
			System.out.println(e.getMessage());
			return false;
		}

		sqlStr = "select * from orders where customerName = '" + userName
				+ "' order by orderTime desc";
		try {

			ResultSet rs = myConnection.runQuery(sqlStr);
			orderList = new Vector();
			while (rs.next()) {
				order tempOrder = new order();
				tempOrder.setOrderItem(Long.parseLong(rs.getString("orderID")));
				tempOrder.setCustomerName(rs.getString("customerName"));
				tempOrder.setOrderTime(rs.getString("orderTime"));
				tempOrder.setAddress(rs.getString("address"));
				tempOrder.setCode(rs.getString("code"));
				tempOrder.setOrderWay(rs.getString("orderWay"));
				tempOrder.setReceiveTime(rs.getString("receiveTime"));
				tempOrder.setSender(rs.getString("sender"));
				tempOrder.setAccount(rs.getDouble("amount"));
				System.out.println("123");
				orderList.addElement(tempOrder);
			}
			rs.close();
			return true;
		} catch (SQLException e) {
			System.out.println(e);
			return false;
		}
	}

	public boolean showItemDetail(long inOrderID) throws Exception{
		sqlStr = "select * from orderItem where orderID = '" + inOrderID + "'";
		try{
			ResultSet rs = myConnection.runQuery(sqlStr);
			orderItemList = new Vector();
			products = new Vector();
			while (rs.next()) {
				orderItem tempOrderItem = new orderItem();
				tempOrderItem.setOrderID(Long.parseLong(rs.getString("orderID")));
				tempOrderItem.setProducItem(rs.getInt("producItem"));
				tempOrderItem.setQuantity(rs.getInt("quantity"));
				orderItemList.addElement(tempOrderItem);
				
				sqlStr = "select * from products where producItem = " + tempOrderItem.getProItem(); 
				ResultSet rs1 = myConnection.runQuery(sqlStr);
				rs1.next();
				products tempPro = new products();
				tempPro.setProductorItem(tempOrderItem.getProItem());
				tempPro.setProductorName(rs1.getString("producName"));
				tempPro.setType(rs1.getString("type"));
				tempPro.setQuantity(rs1.getInt("quantity"));

				products.addElement(tempPro);
				rs1.close();
			}
			rs.close();
			return true;
		}catch(Exception e){
			System.out.println(e);
			return false;
		}
	}
	//管理員查看所有帳單
	public boolean getAllorder(int inState) throws Exception {

		String sqlStr1 = "",sqlStr2 = "";
		if(inState == 0){
			sqlStr1 = "select count(*) from orders";
			sqlStr2 = "select * from orders"; 
		}
		else if(inState == 1 || inState == 2 || inState ==3){
			sqlStr1 = "select count(*) from orders where state = " + inState;
			sqlStr2 = "select * from orders where state = " + inState;
		}
		else
			return false;
		
		try {
			ResultSet rs1 = myConnection.runQuery(sqlStr1);
			if (rs1.next())
				recordCount = rs1.getInt(1);
			rs1.close();
			System.out.println(recordCount);
		} catch (SQLException e) {
			System.out.println(e.getMessage());
			return false;
		}

		if (recordCount < 1)
			pageCount = 0;
		else
			pageCount = (int) (recordCount - 1) / pageSize + 1;
		if (page < 1)
			page = 1;
		else if (page > pageCount)
			page = pageCount;
		try {
			ResultSet rs2 = myConnection.runQuery(sqlStr2);
			if (page == 1) {

			} else {
				for (int i = 0; i < pageSize * (page - 1); i++) {
					rs2.next();
				}
			}
			orderList = new Vector();
			while (rs2.next()) {
				order tempOrder = new order();
				tempOrder.setOrderItem(Long.parseLong(rs2.getString("orderID")));
				tempOrder.setCustomerName(rs2.getString("customerName"));
				tempOrder.setOrderTime(rs2.getString("orderItem"));
				tempOrder.setAddress(rs2.getString("address"));
				tempOrder.setCode(rs2.getString("code"));
				tempOrder.setOrderWay(rs2.getString("orderWay"));
				tempOrder.setReceiveTime(rs2.getString("receiveTime"));
				tempOrder.setSender(rs2.getString("sender"));
				tempOrder.setAccount(rs2.getDouble("amount"));

				orderList.addElement(tempOrder);
			}
			rs2.close();
			return true;
		} catch (SQLException e) {
			System.out.println(e);
			return false;
		}
	}
/////////////////////////////////////////////////////////////////////////////////	
	/*public static void main(String[] args){
		  
		  try{
			  opOrder op1 = new opOrder(); 
			  op1.query(0, 0, 0, "456");
			  System.out.println(op1.account);
			 if(op1.getOrder("456",0))
				  System.out.println("456");
			  Vector testV = op1.getOrderList();
			  for(int i = 0; i < testV.size(); i++){
				  order tempP = (order)(testV.elementAt(i));
				  System.out.println(tempP.getOrderItem());
			  }
			  
			  if(op1.showItemDetail(35423)){
				  System.out.println("123");
			  }
			  Vector testV1 = op1.getOrderItemList();
			  for(int i = 0; i < testV1.size(); i++){
				  orderItem tempP = (orderItem)(testV1.elementAt(i));
				  System.out.println(tempP.getProItem());
			  }
			  }
		  
		  catch(Exception e){
			  System.out.println(e);
		  }
	  }*/

}