package com.easyjf.bbs.business;

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

import com.easyjf.dbo.EasyJDB;
import com.easyjf.dbo.IObject;
import com.easyjf.util.MD5;
/**
 * BBS用戶信息-通過實現IObject接口支持EasyDBO零配置文件方式映射
 * @author 蔡世友
 *
 */
public class UserInfo implements IObject {
	private String cid;
	private String userName;
	private String password;
	private String sex;
	private String email;
	private String tel;
	private Integer loginTimes;
	private Date inputTime;	
	private String intro;
	private Integer status;	
	private Date lastLoginTime;
	private String lastLoginIP;
	private String photo;
	private String qq;
	private Integer score;
	private Date modifyTime;
	private String address;
	private String subject;
	private String school;
	private String degree;
	private String title;
	private String sign;
	private String duty;
	private String introducer;
	private Integer onlineTime;
	private String types;
	public UserInfo()
	{		
	}
	public static UserInfo read(String cid)
	{
		EasyJDB db=EasyJDB.getInstance();
		return (UserInfo)db.get(UserInfo.class,cid);
	}
	public static UserInfo readByUserName(String userName)
	{
		EasyJDB db=EasyJDB.getInstance();
		Collection paras=new ArrayList();
		paras.add(userName);
		return (UserInfo)db.read(UserInfo.class,"userName=?",paras);
	}
	public static List query(String scope)
	{
		EasyJDB db=EasyJDB.getInstance();
		return db.query(UserInfo.class,scope);	
	}
	public  Number messageNum()
	{
		EasyJDB db=EasyJDB.getInstance();
		Number num=(Number)db.uniqueResult("select count(*) from BBSDoc where status>=0  and  (parentId is null or (parentId='')) and inputUser='"+this.userName+"'");
		return num;
	}
	public  Number eliteMessageNum()
	{
		EasyJDB db=EasyJDB.getInstance();
		Number num=(Number)db.uniqueResult("select count(*) from BBSDoc where status>=0  and eliteMessage>0 and  (parentId is null or (parentId='')) and inputUser='"+this.userName+"'");
		return num;
	}
	public  Number replyNum()
	{
		EasyJDB db=EasyJDB.getInstance();
		Number num=(Number)db.uniqueResult("select count(*) from BBSDoc where status>=0  and ( not (parentId is null or (parentId=''))) and inputUser='"+this.userName+"'");
		return num;
	}
	public  String showTypes()
	{
		String ret="普通會員";
		if(this.types!=null){
		if("member".equals(this.types.trim()))ret="EasyJF開源團隊成員";
		else if("admin".equals(this.types.trim()))ret="EasyJF管理成員";
		else if("manager".equals(this.types.trim()))ret="EasyJF站長";
		}		
		//EasyJDB db=EasyJDB.getInstance();		
		//Number num=(Number)db.uniqueResult("select count(*) from BBSDoc where status>=0  and ( not (parentId is null or (parentId=''))) and inputUser='"+this.userName+"'");
		return ret;
	}
	public boolean checkUserRole(String type)
	{
	boolean ret=false;	
	if("member".equals(type))ret="member".equals(this.types.trim())||"admin".equals(this.types.trim());
	else if("admin".equals(type))ret="admin".equals(this.types.trim());
	return ret;
	}
	public boolean save()
	{		
		return EasyJDB.getInstance().saveOrUpdate(this);
	}
	public boolean update()
	{		
		return EasyJDB.getInstance().update(this);
	}
	public boolean del()
	{
		EasyJDB db=EasyJDB.getInstance();
		return db.del(this);
	}
	public String getKeyField() {
		
		return "cid";
	}
	
	public String getKeyGenerator() {
		return "com.easyjf.dbo.RandomIdGenerator";
	}

	public String getTableName() {
		return "BBSUser";
	}		
	public String getCid() {
		return cid;
	}
	public void setCid(String cid) {
		this.cid = cid;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}	
	public String getTel() {
		return tel;
	}
	public void setTel(String tel) {
		this.tel = tel;
	}	
	public Date getInputTime() {
		return inputTime;
	}
	public void setInputTime(Date inputTime) {
		this.inputTime = inputTime;
	}
	public String getLastLoginIP() {
		return lastLoginIP;
	}
	public void setLastLoginIP(String lastLoginIP) {
		this.lastLoginIP = lastLoginIP;
	}
	public Date getLastLoginTime() {
		return lastLoginTime;
	}
	public void setLastLoginTime(Date lastLoginTime) {
		this.lastLoginTime = lastLoginTime;
	}
	public Integer getLoginTimes() {
		return loginTimes;
	}
	public void setLoginTimes(Integer loginTimes) {
		this.loginTimes = loginTimes;
	}
	
	public Integer getStatus() {
		return status;
	}
	public void setStatus(Integer status) {
		this.status = status;
	}
	public String getIntro() {
		return intro;
	}
	public void setIntro(String intro) {
		this.intro = intro;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getUserName() {
		return userName!=null?userName.trim():null;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}	
	public String encodeUserName()
	{
		String ret=userName;
		if(userName!=null){
		try{
		ret=URLEncoder.encode(userName.trim(),"utf-8");
		}
		catch(Exception e)
		{
			
		}}
		return ret;
	}
	public String getPhoto() {
		return photo;
	}
	public void setPhoto(String photo) {
		this.photo = photo;
	}	
	public String getQq() {
		return qq;
	}
	public void setQq(String qq) {
		this.qq = qq;
	}	
	public Integer getScore() {
		return score;
	}
	public void setScore(Integer score) {
		this.score = score;
	}
	
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	public String getDegree() {
		return degree;
	}
	public void setDegree(String degree) {
		this.degree = degree;
	}
	public String getDuty() {
		return duty;
	}
	public void setDuty(String duty) {
		this.duty = duty;
	}
	public String getIntroducer() {
		return introducer;
	}
	public void setIntroducer(String introducer) {
		this.introducer = introducer;
	}
	public Date getModifyTime() {
		return modifyTime;
	}
	public void setModifyTime(Date modifyTime) {
		this.modifyTime = modifyTime;
	}
	public Integer getOnlineTime() {
		return onlineTime;
	}
	public void setOnlineTime(Integer onlineTime) {
		this.onlineTime = onlineTime;
	}
	public String getSchool() {
		return school;
	}
	public void setSchool(String school) {
		this.school = school;
	}
	public String getSign() {
		return sign;
	}
	public void setSign(String sign) {
		this.sign = sign;
	}
	public String getSubject() {
		return subject;
	}
	public void setSubject(String subject) {
		this.subject = subject;
	}
	public String getTitle() {
		return title;
	}
	public void setTitle(String title) {
		this.title = title;
	}	
	
	public String getTypes() {
		return types;
	}
	public void setTypes(String types) {
		this.types = types;
	}
	
	public static void main(String args[])
	    {
		  List list=UserInfo.query("1=1");
		  if(list!=null)
		  {
			  for(int i=0;i<list.size();i++)
			  {
				  UserInfo user=(UserInfo)list.get(i);
				  user.setPassword(MD5.encode(user.getPassword().trim()));
				  user.update();
			  }
		  }
	    }
}