package com.fgkj.services;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;


import com.fgkj.actions.ActionUtil;
import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.BaseDAOFactory;
import com.fgkj.dao.DAOHelper;
import com.fgkj.dao.impl.BattInfImpl;
import com.fgkj.dao.impl.User_battmaint_checkImpl;
import com.fgkj.dao.impl.User_battmaint_check_processImpl;
import com.fgkj.dao.impl.User_infImpl;
import com.fgkj.db.DBUtil;
import com.fgkj.db.IDatabaseName;
import com.fgkj.dto.BattInf;
import com.fgkj.dto.Page;
import com.fgkj.dto.ServiceModel;
import com.fgkj.dto.Task_Batt_Test;
import com.fgkj.dto.User_battmaint_check_process;
import com.fgkj.dto.User_inf;

import com.fgkj.dto.User_battmaint_check;

public class User_battmaint_checkService {
	private ServiceModel model;
	private BaseDAO dao;
	public User_battmaint_checkService() {
		model=new ServiceModel();
		dao=BaseDAOFactory.getBaseDAO(BaseDAO.USER_BATTMAINT_CHECK);
	}
	
	//4.10作业抽查管理(新建)
    public ServiceModel add(Object obj) {
		Boolean bl=dao.add(obj);
		if(bl){
			model.setCode(1);
			model.setMsg("添加成功!");
		}
		else{
			model.setMsg("添加失败!");
		}
		return model;
		
	}
    //4.10作业抽查管理(编辑记录)
    public ServiceModel update(Object obj) {
		Boolean bl=dao.update(obj);
		if(bl){
			model.setCode(1);
			model.setMsg("修改成功!");
		}
		else{
			model.setMsg("修改失败!");
		}
		return model;	
	}	
   //4.10作业抽查管理(编辑记录)(user_battmaint_check表修改时User_battmaint_check_process表就新增一条记录)
    public ServiceModel updatePro(Object obj1,Object obj2) {
    	User_battmaint_check ucheck=(User_battmaint_check) obj1;
    	List<User_battmaint_check_process> list=(List<User_battmaint_check_process>) obj2;
    	ArrayList<String> str_sql=new ArrayList<String>();//存放所有的sql语句
    	//修改User_battmaint_check表
    	String sqlCheck=(new User_battmaint_checkImpl()).updatePro(ucheck);
    	str_sql.add(sqlCheck);
    	if(list!=null && list.size()>0){
    		for (int i = 0; i < list.size(); i++) {
				//Date caption_time=new Date();
				//System.out.println("caption_time:"+caption_time);
				//list.get(i).setWork_caption_time(caption_time);
				//新增User_battmaint_check_process表
		    	String sqlProcess=(new User_battmaint_check_processImpl()).addPro(list.get(i));
		    	str_sql.add(sqlProcess);
			}
    	}
    	//System.out.println(str_sql);
    	Boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), str_sql);
    	if(bl){
			model.setCode(1);
			model.setMsg("修改成功!");
		}
		else{
			model.setMsg("修改失败!");
		}
    	return model;
    }
    //4.10作业抽查管理(删除记录)
    public ServiceModel delete(Object obj) {
		Boolean bl=dao.del(obj);
		if(bl){
			model.setCode(1);
			model.setMsg("删除成功!");
		}
		else{
			model.setMsg("删除失败!");
		}
		return model;	
	}
    //4.10作业抽查管理(删除记录)
    public ServiceModel deletePro(Object obj) {
    	User_battmaint_check ucheck=(User_battmaint_check) obj;
    	//删除对应的User_battmaint_check_process
    	User_battmaint_check_process uprocess=new User_battmaint_check_process();
    	uprocess.setTask_rec_id(ucheck.getNum());
    	ArrayList<String> str_sql=new ArrayList<String>();//存放所有的sql语句
    	//删除User_battmaint_check表
    	String sqlCheck=(new User_battmaint_checkImpl()).delPro(ucheck);
    	str_sql.add(sqlCheck);
    	//删除User_battmaint_check_process表中task_rec_id对应的记录
    	String sqlProcess=(new User_battmaint_check_processImpl()).delPro(uprocess);
    	str_sql.add(sqlProcess);
    	Boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), str_sql);
    	if(bl){
			model.setCode(1);
			model.setMsg("修改成功!");
		}
		else{
			model.setMsg("修改失败!");
		}
    	return model;
	}

    //4.10作业抽查管理
    public ServiceModel serchByCondition(Object obj){
		List<Task_Batt_Test> list=dao.serchByCondition(obj);
		
		User_inf uinf=new User_inf();
		int usr_id=0;//责任人
		String usr_name="";
		int master_id=0;//创建人
		String master_name="";
		int appoint_uid=0;//指派人
		String appoint_name="";
		String copy_ids="";//抄送人
		int copy_id=0;
		String copy_name="";
		String[] copy_names;
		for(int i=0;i<list.size();i++){
			BattInf binf=new BattInf();
			//电池组组数
			binf.setStationName(list.get(i).getMcheck().getRemark());
			binf.setStationName1("");
			List listbinf=(new BattInfImpl()).serchByBattGroupName(binf);
			list.get(i).getMcheck().setStationId(listbinf.size());
			//责任人/创建人/指派人/抄送人
			usr_id=list.get(i).getMcheck().getUsr_id();
			uinf.setUId(usr_id);
			usr_name=((User_inf)(new User_infImpl()).serchUname(uinf).get(0)).getUName();
			binf.setStationName6(usr_name);
			
			master_id=list.get(i).getMcheck().getMaster_id();
			uinf.setUId(master_id);
			master_name=((User_inf)(new User_infImpl()).serchUname(uinf).get(0)).getUName();
			binf.setStationName7(master_name);
			
			appoint_uid=list.get(i).getMcheck().getAppoint_uid();
			uinf.setUId(appoint_uid);
			appoint_name=((User_inf)(new User_infImpl()).serchUname(uinf).get(0)).getUName();
			binf.setStationName8(appoint_name);
			//System.out.println(usr_name+"  "+master_name+"  "+appoint_name);
			copy_ids=list.get(i).getMcheck().getCopy_uids();
			copy_names=copy_ids.split(",");
			for(int j=0;j<copy_names.length;j++){
				copy_id=Integer.parseInt(copy_names[j]);
				uinf.setUId(copy_id);
				copy_name+=",";
				copy_name+=((User_inf)(new User_infImpl()).serchUname(uinf).get(0)).getUName();
			}
			binf.setStationName9(copy_name.substring(1, copy_name.length()));
			//System.out.println(binf.getStationName9());
			list.get(i).setBinf(binf);
			copy_name="";
		}
		if(list!=null && list.size()>0){
			model.setCode(1);
			model.setData(list);
		}
	    List<Task_Batt_Test> listt=(List<Task_Batt_Test>)model.getData();	
	//    for (Task_Batt_Test t : listt) {
	//		System.out.println(t.getBinf().getStationName9()+"  "+t.getMcheck().getCopy_uids());
	//	}
		return model;
	}


	public ServiceModel searchAll() {
		List<User_battmaint_check> list = dao.searchAll();
		//System.out.println(list.size());

		if (list != null && list.size() > 0) {
			model.setCode(1);
			model.setData(list);
		}
		return model;
	} 
	public static void main(String[] args) throws ParseException {
		User_battmaint_checkService us=new User_battmaint_checkService();
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		Date date1 = sdf.parse("2000-01-01");
		Date date2 = sdf.parse("2020-01-01");
		
        BattInf binf = new BattInf();
	    binf.setStationName("");
		binf.setStationName1("");
		binf.setBattGroupId(0);
		
		User_battmaint_check mcheck=new User_battmaint_check();
		mcheck.setUsr_id(0);
		mcheck.setOrigin_usr_work_mark(0);
		mcheck.setOrigin_usr_work_mark1(100);
		mcheck.setTask_done(100);
		mcheck.setTask_done_confirm(100);
		mcheck.setTask_time_start(ActionUtil.getSimpDate(date1));
		mcheck.setTask_time_end(ActionUtil.getSimpDate(date2));
		Page p = new Page();
		p.setPageCurr(1);
		p.setPageSize(10);
		Task_Batt_Test tbt=new Task_Batt_Test();
		tbt.setBinf(binf);
		tbt.setMcheck(mcheck);
		tbt.setPage(p);
		us.serchByCondition(tbt);
		//us.searchAll();
	}

}