package com.connor.chint.sap2.assignfactoryno;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.lang.reflect.Array;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.swing.BorderFactory;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumnModel;

import com.connor.chint.sap2.util.KUtil;
import com.connor.chint.sap2.util.ProgressBar;
import com.teamcenter.rac.aif.AbstractAIFApplication;
import com.teamcenter.rac.aif.AbstractAIFDialog;
import com.teamcenter.rac.kernel.PreferenceObject;
import com.teamcenter.rac.kernel.TCComponent;
import com.teamcenter.rac.kernel.TCComponentContextList;
import com.teamcenter.rac.kernel.TCComponentFolder;
import com.teamcenter.rac.kernel.TCComponentForm;
import com.teamcenter.rac.kernel.TCComponentItemRevision;
import com.teamcenter.rac.kernel.TCException;
import com.teamcenter.rac.kernel.TCPreferenceService;
import com.teamcenter.rac.kernel.TCSession;
import com.teamcenter.rac.kernel.TCPreferenceService.TCPreferenceLocation;
import com.teamcenter.rac.util.MessageBox;

@SuppressWarnings("serial")
public class FactoryNoZYDialog extends AbstractAIFDialog{

	private FactoryNoZYDialogController controller;
	private TCSession session;
	private TCPreferenceService prefService=null ;
	
	private AbstractAIFApplication app;
	protected DefaultTableModel tm_bom;
	protected JTable t_bom;
	protected int createCode = 0;//·ĻǾɵ֮0½1
	private JButton b_assign;
	private JButton n_assign;
	protected JTextField jtf_zcy ;//
	protected JPanel panel ;//
	protected JPanel panel2 ;//
	protected JPanel panel3 ;//
	protected JTextField jtf_zcg ;
	protected JTextField jtf_bj ;
	protected JTextField jtf_mxq ;
	public static final String[] HEADER = new String[] { "","վ","","ϱ", "", "ǰ׺", "ˮ" };
	public static final int[] HEADERWIDTH = new int[] { 50, 150, 150, 150 ,150, 150, 150};
	public TCComponentFolder factorNoFolder;
//	String zt2_ZY = "zt2_ZY";
	public boolean fNum_flag = false;
	
	protected TCComponentForm lsmForm=null;
	private String actionInfo;
	protected String qz="";
	protected int lsmMax=0;
	protected int lsmMin = 0;
	public FactoryNoZYDialog(AbstractAIFApplication app, String actionInfo) {
		super(false);
		this.controller = new FactoryNoZYDialogController(app,this,actionInfo);
		this.app = app;
		this.session = (TCSession) app.getSession();
		prefService=session.getPreferenceService();
		KUtil.setByPass(true);
		System.out.println("actionInfo>>"+actionInfo);
//		lsmForm = getForm(actionInfo);//ZCY͵·ݺǰ׺һָform
//		getFNumber(lsmForm,"ZCY");//ÿã¼ַͣʽãҪôмʽҪôѡʽ
		resetFlowNumner();
		
		KUtil.setByPass(false);
		
	}
	public void disconnect(Connection conn,Statement stmt,	ResultSet rs_get) {
		try {
			if (rs_get != null) {
				rs_get.close();
			}

			if (stmt != null) {
				stmt.close();
			}
			if (conn != null) {
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public Connection connect(Connection conn) {
		String[] database=session.getPreferenceService().getStringValues("database_tc");
		String JdbcDriverClass = "oracle.jdbc.driver.OracleDriver";
		String strUrl = "jdbc:oracle:thin:@10.128.18.139:1521:testdb";//ϵͳ
		strUrl="jdbc:oracle:thin:@"+database[0]+":"+database[1]+":"+database[2];
		String strUserName = "infodba";
		strUserName=database[3];
		String strPassword = "infodba";
		strPassword=database[4];
		try {
			Class.forName(JdbcDriverClass);
		} catch (ClassNotFoundException e1) {
			e1.printStackTrace();
		}
		try {
			conn = DriverManager.getConnection(strUrl, strUserName, strPassword);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
		 
		
	}
	private void resetFlowNumner() {
		try {
			Connection conn=null;
			conn=connect(conn);
			String query="select * from CHINT_FLOW";
			
			Statement stmt = conn.createStatement();
			ResultSet rs_get = null;
			rs_get = stmt.executeQuery(query);
			List<String> sqlList=new ArrayList<>();
			while (rs_get.next()) {
				 String type=rs_get.getString("TYPE");
				 String time=rs_get.getString("TIME");
//				 String flow=rs_get.getString("FLOW");
				 String code=type+time+"001";
				 TCComponent[] comps= session.search("...", new String[] {" ID"}, new String[] {code});
				 if(comps.length==0) {
						System.out.println("õˮ");
						sqlList.add("update CHINT_FLOW set FLOW='001' where TYPE='"+type+"' and TIME='"+time+"'");
					}else if(comps.length==1) {
						System.out.println("õˮ");
					}
			}
			
			//
			if (rs_get != null) {
				rs_get.close();
			}
			for (int i = 0; i < sqlList.size(); i++) {
				String sql=sqlList.get(0);
				rs_get = stmt.executeQuery(sql);
				if(rs_get.next()) {
					System.out.println("update =====");
				}
				if (rs_get != null) {
					rs_get.close();
				}
			}
			
			disconnect( conn, stmt,	 rs_get);
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		
		
		
		
		
		
	}

	private TCComponentForm getForm(String prefix)
	{
		if (prefix == null) {
			prefix = "";
		}
		prefix = "TEST";
		String prefName = "ZT2_FactoryNo_" + prefix;
		TCPreferenceService prefService = session.getPreferenceService();
		try {
			prefService.refresh();
			TCPreferenceLocation loc = TCPreferenceLocation.OVERLAY_LOCATION;
			PreferenceObject pref = prefService.getPreferenceObjectAtLocation(prefName, loc);
			String uid = prefService.getStringValue(prefName);
			System.out.println("ѡֵ:"+uid);
			TCComponent comp = session.stringToComponent(uid);
			System.out.println("ѡеı:"+comp);
			if(comp!=null && comp instanceof TCComponentForm)
			{
				return (TCComponentForm) comp;
			}					
		} catch (TCException e) {
			e.printStackTrace();
		}
		
		return null;
	}
	@Override
	public void run() {
	
		initUI();
		addListeners();
		new Thread(new Runnable() {
			@Override
			public void run() {
				KUtil.setByPass(true);
				ProgressBar pb = new ProgressBar(FactoryNoZYDialog.this, new Dimension(250, 50));
				setCompEnabled(false);
				try {
					/*if(lsmForm==null)
					{
						throw new Exception("ȡˮϢ쳣ѡ");
					}*/
					controller.readData(pb);
					pb.disposeDialog();
					KUtil.setByPass(false);
				} catch (Exception e) {
					KUtil.setByPass(false);
					pb.disposeDialog();
					MessageBox.post(FactoryNoZYDialog.this, "ȡϢʱ쳣" + e.getMessage(), "", MessageBox.ERROR);
					e.printStackTrace();
				}
				setCompEnabled(true);
				
				//ˮ뷶ΧжϣŶѾڣôˮʾΧԭķΧ
				reFlow();
				
			}
		}).start();
		
		
		showDialog();
	}

	protected void reFlow() {
		int row=t_bom.getRowCount();
		Map<String, List<String>> FlowMap=new HashMap<>();
//		System.out.println("row===="+row);
		FlowMap.put("ZCY", new ArrayList<String>());
		FlowMap.put("ZCG", new ArrayList<String>());
		FlowMap.put("BJ", new ArrayList<String>());
		FlowMap.put("MXQ", new ArrayList<String>());
		for (int i = 0; i < row; i++) {
			String mapKey=(String) t_bom.getValueAt(i, 5);
			String mapValue=(String) t_bom.getValueAt(i, 6);
			if(mapKey==null||mapValue==null) {
				continue;
			}
//			System.out.println(mapKey+mapValue);
			if(mapValue.length()>0) {
				createCode=1;
			}
			for(Map.Entry<String, List<String>> me:FlowMap.entrySet()) {
				if(mapKey.startsWith(me.getKey())) {
					me.getValue().add(mapValue);
				}
			}
		}
		if(createCode==1) {
			
			for(Map.Entry<String, List<String>> me:FlowMap.entrySet()) {
				List<String> list=me.getValue();
				if(list.size()==0) {
					continue;
				}
				String[] strings=new String[list.size()];
				for (int i = 0; i < strings.length; i++) {
					strings[i]=list.get(i);
				}
				Arrays.sort(strings);
				String ss=me.getKey()+":"+strings[0]+"-"+strings[strings.length-1];
//				System.out.println(ss);
//				System.out.println(me.getKey()+":");
				if(jtf_zcy.getText().startsWith(me.getKey()+":")) {
					jtf_zcy.setText(ss);
				}
				if(jtf_zcg.getText().startsWith(me.getKey()+":")) {
					jtf_zcg.setText(ss);
				}
				if(jtf_bj.getText().startsWith(me.getKey()+":")) {
					jtf_bj.setText(ss);
				}
				if(jtf_mxq.getText().startsWith(me.getKey()+":")) {
					jtf_mxq.setText(ss);
				}
			}
			n_assign.setEnabled(false);
		}
		
	}
	protected void setCompEnabled(boolean b) {
		b_assign.setEnabled(b);
		t_bom.setEnabled(b);
	}
	
	public int flowStart(String start){
		
		int startNUm=0;
		if(start.length()==0) {
			return  startNUm;
		}else {
			startNUm=Integer.valueOf(start.split(":")[1].split("-")[0]);
			return  startNUm;
		}
	}

	private void addListeners() {
		//ˮ 
		n_assign.addActionListener(new ActionListener() {
			@Override
			public void actionPerformed(ActionEvent e) {
				try {
					if(!controller.checkXMFJ())
					{
						MessageBox.post("δ⵽Ŀ,ܷ", "", MessageBox.INFORMATION);
						return;
					}
				} catch (TCException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
				
				
				
				
				
				
				int index2=t_bom.getRowCount();
				SimpleDateFormat sdf=new SimpleDateFormat("yyMM");
				Date date=new Date();
				String dateString=sdf.format(date);
				int zcy=flowStart(jtf_zcy.getText());
				int zcg=flowStart(jtf_zcg.getText());
				int bj=flowStart(jtf_bj.getText());
				int mxq=flowStart(jtf_mxq.getText());
				String[] types=prefService.getStringValues("zt2_byq_type");
				Map<String, String> typeMap=new HashMap<>();
				for (int i = 0; i < types.length; i++) {
					typeMap.put(types[i].split(":")[0], types[i].split(":")[1]);
				}	
				
				for (int i = 0; i < index2; i++) {
					String prefix0= (String) t_bom.getValueAt(i, 4);
					String prefix="";
					for(Map.Entry<String, String> me:typeMap.entrySet()) {
						String[] names=me.getValue().split(";");
						for (int j = 0; j < names.length; j++) {
							if(prefix0.contains(names[j])) {
								prefix=me.getKey();
								break;
							}
						}
					}
					t_bom.setValueAt(prefix+dateString, i, 5);
					switch(prefix) {
					case "ZCY":
						t_bom.setValueAt(String.format("%03d", zcy), i,6);
						zcy++;
						break;
					case "ZCG":
						t_bom.setValueAt(String.format("%03d", zcg), i,6);
						zcg++;
						break;
					case "BJ":
						t_bom.setValueAt(String.format("%03d", bj), i,6);
						bj++;
						break;
					case "MXQ":
						t_bom.setValueAt(String.format("%03d", mxq), i,6);
						mxq++;
						break;
					default:
						break;
					
					}
					
				}
				
			}
		});
		b_assign.addActionListener(new ActionListener() {
			@Override
			public void actionPerformed(ActionEvent e) {
				new Thread(new Runnable() {
					@Override
					public void run() {
						ProgressBar pb = new ProgressBar(FactoryNoZYDialog.this, new Dimension(250, 50));
						KUtil.setByPass(true);
						setCompEnabled(false);
						try {
//							controller.assign(pb);
							controller.assign(pb,0,createCode);//飬½
							//Ŀ->ļ
							if(createCode==0) {
								
								sorting();
							}
							
							pb.disposeDialog();
						} catch (Exception e1) {
							KUtil.setByPass(false);
							pb.disposeDialog();
							MessageBox.post(FactoryNoZYDialog.this, "ŷ쳣" + e1.getMessage(), "", MessageBox.ERROR);
							controller.recovery();	
							setCompEnabled(true);
							e1.printStackTrace();
						}
						KUtil.setByPass(false);
						setCompEnabled(true);
					}

					
				}).start();
			}
		});
	}
	private void sorting() {
		try {
			TCComponent project=(TCComponent) app.getTargetComponent();
			TCComponent[] folders=project.getRelatedComponents("IMAN_reference");
			for (int j = 0; j < folders.length; j++) {
				if(folders[j].getProperty("object_name").equals("Ŀ")) {
					TCComponent[] folders2=folders[j].getRelatedComponents("contents");
					for (int k = 0; k < folders2.length; k++) {
						if(folders2[k].getProperty("object_name").equals("")) {
							TCComponent[] items=folders2[k].getRelatedComponents("contents");
							List<TCComponent> zcyList=new ArrayList<>();
							List<TCComponent> zcgList=new ArrayList<>();
							List<TCComponent> mxqList=new ArrayList<>();
							List<TCComponent> bjList=new ArrayList<>();
							List<TCComponent> otherList=new ArrayList<>();
							for (int i = 0; i < items.length; i++) {
								String id=items[i].getProperty("item_id");
								
								if(id.startsWith("ZCY")) {
									zcyList.add(items[i]);
								}else if(id.startsWith("ZCG")) {
									zcgList.add(items[i]);
								}else if(id.startsWith("MXQ")) {
									mxqList.add(items[i]);
								}else if(id.startsWith("BJ")) {
									bjList.add(items[i]);
								}else  {
									otherList.add(items[i]);
								}
							}
							zcyList=sortList(zcyList);
							zcgList=sortList(zcgList);
							mxqList=sortList(mxqList);
							bjList=sortList(bjList);
							otherList=sortList(otherList);
							//·ļУٲ
							KUtil.setByPass(true);
							for (int i = 0; i < items.length; i++) {
								
								folders2[k].remove("contents", items[i]);
							}
							addItem(folders2[k],zcyList);
							addItem(folders2[k],zcgList);
							addItem(folders2[k],mxqList);
							addItem(folders2[k],bjList);
							addItem(folders2[k],otherList);
							KUtil.setByPass(false);
						}
					}
				}
			}
		} catch (TCException e) {
			e.printStackTrace();
		}
		
	}
	private void addItem(TCComponent tcComponent, List<TCComponent> zcyList) {
		for (int i = 0; i < zcyList.size(); i++) {
			try {
				tcComponent.add("contents", zcyList.get(i));
			} catch (TCException e) {
				e.printStackTrace();
			}
		}
	}
	private List<TCComponent> sortList(List<TCComponent> list) {
		Map<String, TCComponent> map=new HashMap<>();
		String[] idString=new String[list.size()];
		List<TCComponent> idList=new ArrayList<>();
		for (int i = 0; i < list.size(); i++) {
			try {
				idString[i]=list.get(i).getProperty("item_id");
//				idList.add(list.get(i).getProperty("item_id"));
				map.put(list.get(i).getProperty("item_id"), list.get(i));
			} catch (TCException e) {
				e.printStackTrace();
			}
		}
		Arrays.sort(idString);
		for (int i = 0; i < idString.length; i++) {
			System.out.println(idString[i]);
			idList.add(map.get(idString[i]));
			
		}
		
		return idList;
	}
	private void initUI() {
		this.setTitle("");
		this.setPreferredSize(new Dimension(980,480));
		this.setMinimumSize(new Dimension(400,300));
		this.setLayout(new BorderLayout());
		this.add(BorderLayout.NORTH,getBtnPanel());
		this.add(BorderLayout.CENTER,getTablePanel());
	}

	private JPanel getTablePanel() {
		JPanel panel = new JPanel(new BorderLayout());
		panel.setBorder(BorderFactory.createEmptyBorder(0,5,5,5));
		tm_bom = new DefaultTableModel();
		t_bom = new JTable(tm_bom) {
			@Override
			public boolean isCellEditable(int row, int column) { // ѡУУÿɱ༭
				if(column==6)
				{
					return true;
				}
				return false;
			}
		};
		tm_bom.setDataVector(null, HEADER);
		t_bom.getTableHeader().setReorderingAllowed(false); // вƶᷢת󣨵У
		this.t_bom.setRowHeight(23);
		TableColumnModel colModel = this.t_bom.getColumnModel();
		int colCnt = HEADERWIDTH.length;
		colModel.getColumn(0).setMaxWidth(HEADERWIDTH[0]);
		for (int i = 0; i < colCnt; i++) {
			colModel.getColumn(i).setPreferredWidth(HEADERWIDTH[i]);
		}
		JScrollPane scroll = new JScrollPane(t_bom);
		panel.add(BorderLayout.CENTER, scroll);
		return panel;
	}

	private JPanel getBtnPanel() {
		 panel = new JPanel(new BorderLayout());
		 panel2 = new JPanel(new FlowLayout(FlowLayout.LEFT,10,5));
		 panel3 = new JPanel(new FlowLayout(FlowLayout.RIGHT,10,5));
		//JPanel panel3 = new JPanel(new FlowLayout(FlowLayout.RIGHT,15,5));
		JLabel label = new JLabel("ˮ뷶Χ:");
		/*JLabel label_zcy = new JLabel("ZCYˮ뷶Χ:");
		JLabel label_zcg = new JLabel("ZCGˮ뷶Χ:");
		JLabel label_bj = new JLabel("BJˮ뷶Χ:");
		JLabel label_mxq = new JLabel("MXQˮ뷶Χ:");*/
		panel2.add(label);
		jtf_zcy = new JTextField(10);
		jtf_zcy.setText("ZCY              ");
		jtf_zcy.setEditable(false);
		panel2.add(jtf_zcy);
		jtf_zcg = new JTextField(10);
		jtf_zcg.setText("ZCG");
		jtf_zcg.setEditable(false);
//		panel2.add(label_zcg);
		panel2.add(jtf_zcg);
		jtf_bj = new JTextField(10);
		jtf_bj.setText("BJ");
		jtf_bj.setEditable(false);
//		panel2.add(label_bj);
		panel2.add(jtf_bj);
		jtf_mxq = new JTextField(10);
		jtf_mxq.setText("MXQ");
		jtf_mxq.setEditable(false);
//		panel2.add(label_mxq);
		panel2.add(jtf_mxq);
		//panel.add(panel2);
		n_assign = new JButton("Զ");
		panel3.add(n_assign);
		b_assign = new JButton("");
		panel3.add(b_assign);
		//panel3.add(b_assign);
		//panel.add(panel3);
		panel.add(BorderLayout.WEST,panel2);
		panel.add(BorderLayout.EAST,panel3);
		return panel;
	}
	private String getFNumber(TCComponentForm flowForm, String prefix)  {
		  if (prefix == null) {
			  prefix = "";
		  }
		  String nameProp = "user_data_1";//¼
		  String numProp = "user_data_2";//¼ˮ
		  String flowNoStr="";
		  String str="";
		  SimpleDateFormat nsw = new SimpleDateFormat("yyMM");
		  try {
			String date = nsw.format(new Date());
			 flowForm.lock();
			//flowForm.refresh();
			flowNoStr = flowForm.getStringProperty(numProp);
			if (!date.equals(flowNoStr)) {
			    System.out.println("ˢ±ˮ" + flowNoStr + " -> " + date);			   
			    flowForm.setStringProperty(nameProp, date);			    
			   }
			str = flowForm.getStringProperty(nameProp);
			if(!fNum_flag)
			{
				Map<String, String> field = new HashMap<String, String>();
				field.put(" ID",prefix+str+"001");
				TCComponentContextList contextList = KUtil.query(session, "...", field);
				if(contextList!=null && contextList.getListCount()==1)
				{
					System.out.println("õˮ");
				}else
				{
					System.out.println("õˮ");
					 flowForm.setStringProperty(numProp, "1");				
					 fNum_flag = true;
				}
			}
			flowForm.save();
		    flowForm.unlock();
		    flowForm.refresh();	
		} catch (Exception e1) {
			e1.printStackTrace();
		}		
  
		  this.qz = prefix+str;
		  Integer flowNo = 1;
		  if(!KUtil.isEmpty(flowNoStr)) {
			  try {
			     flowNo = Integer.parseInt(flowNoStr);
			    } catch (Exception e) {
			     e.printStackTrace();
			    }
			    if (flowNo == null) {
				    flowNo = 1;
				  }
		   
		  }
		  System.out.println("flowNo:"+flowNo);
		  lsmMax = flowNo+2;
		  lsmMin = flowNo;
		  
		  
		  
		  return String.format("%03d", flowNo)+"-"+String.format("%03d", flowNo+2);
		 }
	

}
