package proxy;

import java.sql.*;

import connector.Executor;
import connector.Searcher;

public class FulfilledOrderManager {
	
	private static Searcher s = new Searcher();
	private static ExecutorProxy e = new ExecutorProxy();


	public static int[] insertFulfilledOrders(Statement stmt) throws SQLException,
			BatchUpdateException {
/*		for(int i=0;i<20;i++){
			insert("TN"+i, "Ono"+i%10,"2004-5-"+i, "2004-6-"+i);
		}*/
		
		insert("Tno00001","Ono00001","2007-01-16","2007-01-18");
		insert("Tno00002","Ono00002","2007-04-10","2007-04-16");
		insert("Tno00003","Ono00003","2007-05-10","2007-05-17");
		insert("Tno00004","Ono00004","2007-02-23","2007-03-01");
		insert("Tno00005","Ono00005","2007-03-26","2007-03-28");
		
		return null;
	}

	public static int insert(String[] args) {

		if (args.length != 4) {
			System.err.print("FulfilledOrderManeger arguments input error.");
			return -1;
		}
		String query = "insert into fulfilledOrder values(";
		return e.execute(Checker.argsInsert(query, args));
	}

	public static int insert(String TrackNum, String Ono,
			String shipmentDate, String ExpectedDeliveryDate) {
		String query = "insert into FulfilledOrder values("
				+ Checker.checkNull(TrackNum) + "," + Checker.checkNull(Ono) + ","
				+ Checker.isDate(shipmentDate) + ","
				+ Checker.isDate(ExpectedDeliveryDate) + ");";
		return e.execute(query);
	}

	public static int deleteByTrackNum(String TrackNum) {
		String query = "delete from fulfilledOrder where TrackNum = "
				+ Checker.checkNull(TrackNum) + ";";
		return e.execute(query);
	}

	public static String getNewFulfilledOrderID(){
			String ID = pre;
			String last = s.getLastID(TablesManager.fulfilledOrder);
			if(last == null) return "Tno00000";
	 		int num = Integer.parseInt(last.substring(3));
			num++;
			last = String.valueOf(num);
			for(int i = last.length() ;i< 5;i++)
				ID = ID.concat("0");
			ID = ID.concat(last);
			return ID;
		}

	private static final String pre = "Tno";

	

}