package com.easyjf.item.business;

import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.List;

import com.easyjf.bbs.business.UserInfo;
import com.easyjf.dbo.EasyJDB;
import com.easyjf.dbo.IObject;

public class ItemGroup implements IObject {
private String cid;
private String title;
private String intro;
private String workPlan;
private String task;
private Integer num;
private String manager;
private String inputUser;
private Date inputTime;
private Date approveTime;
private String approveUser;
private Integer status;
public static ItemGroup read(String cid)
{
	EasyJDB db=EasyJDB.getInstance();		
	return (ItemGroup)db.get(ItemGroup.class,cid);
}
public static List query(String scope)
{
	EasyJDB db=EasyJDB.getInstance();
	return db.query(ItemGroup.class,scope);	
}	
public List groupMembers()
{
	EasyJDB db=EasyJDB.getInstance();
	Collection paras=new ArrayList();
	paras.add(this.cid);	
	//System.out.println(this.cid);
	return db.query(ItemMember.class,"itemGroupId=?",paras);
}
public boolean addMember(UserInfo user)
{	
	ItemMember member=new ItemMember();
	member.setUserName(user.getUserName());
	member.setVdate(new Date());
	member.setStatus(new Integer(0));
	member.setItemGroupId(this.cid);	
	return member.save();	
}
public boolean delMember(UserInfo user)
{
	boolean ret=false;
	return ret;
}
public String showStatus()
{
	if(this.status==null || this.status.intValue()==-1)
		return "<font color=red>審批中</font>";
	else if(this.status.intValue()==2) return "<font color=blue>已通過</font>";
	else return "未通過";
}
public boolean save()
{
	EasyJDB db=EasyJDB.getInstance();
	return db.add(this);
}
public boolean update()
{
	EasyJDB db=EasyJDB.getInstance();
	return db.update(this);
}
public boolean del()
{
	EasyJDB db=EasyJDB.getInstance();
	return db.del(this);
}
	public String getTableName() {
		// TODO Auto-generated method stub
		return "ItemGroup";
	}

	public String getKeyField() {
		// TODO Auto-generated method stub
		return "cid";
	}

	public String getKeyGenerator() {
		// TODO Auto-generated method stub
		return "com.easyjf.dbo.RandomIdGenerator";
	}

	public Date getApproveTime() {
		return approveTime;
	}

	public void setApproveTime(Date approveTime) {
		this.approveTime = approveTime;
	}

	public String getCid() {
		return cid;
	}

	public void setCid(String cid) {
		this.cid = cid;
	}

	public Date getInputTime() {
		return inputTime;
	}

	public void setInputTime(Date inputTime) {
		this.inputTime = inputTime;
	}

	public String getInputUser() {
		return inputUser;
	}

	public void setInputUser(String inputUser) {
		this.inputUser = inputUser;
	}

	public String getIntro() {
		return intro;
	}

	public void setIntro(String intro) {
		this.intro = intro;
	}

	public String getManager() {
		return manager;
	}

	public void setManager(String manager) {
		this.manager = manager;
	}

	public Integer getNum() {
		return num;
	}

	public void setNum(Integer num) {
		this.num = num;
	}

	public String getWorkPlan() {
		return workPlan;
	}
	public void setWorkPlan(String workPlan) {
		this.workPlan = workPlan;
	}
	public Integer getStatus() {
		return status;
	}

	public void setStatus(Integer status) {
		this.status = status;
	}

	public String getTitle() {
		return title;
	}

	public void setTitle(String title) {
		this.title = title;
	}

	public String getApproveUser() {
		return approveUser;
	}
	public void setApproveUser(String approveUser) {
		this.approveUser = approveUser;
	}
	
	public String getTask() {
		return task;
	}
	public void setTask(String task) {
		this.task = task;
	}
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
	}
}