package com.newvideo.service.imp;

import java.util.List;

import javax.annotation.Resource;
import javax.persistence.Entity;

import org.springframework.stereotype.Service;

import com.newvideo.dao.AdviceDao;
import com.newvideo.dao.ContactDao;
import com.newvideo.domain.Advice;
import com.newvideo.domain.Contact;
import com.newvideo.domain.UserInfo;
import com.newvideo.util.Constant;

@Service
public class OtherService {
	@Resource
	private AdviceDao adviceDao;
	@Resource
	private ContactDao contactDao;

	public ContactDao getContactDao() {
		return contactDao;
	}

	public void setContactDao(ContactDao contactDao) {
		this.contactDao = contactDao;
	}

	public AdviceDao getAdviceDao() {
		return adviceDao;
	}

	public void setAdviceDao(AdviceDao adviceDao) {
		this.adviceDao = adviceDao;
	}

	// 提交建议
	public void advice(String uid, String content) {
		Advice advice = new Advice();
		advice.setContent(content);
		advice.setCreatetime(System.currentTimeMillis() + "");
		UserInfo user = new UserInfo();
		user.setId(uid);
		advice.setUser(user);
		adviceDao.create(advice);
	}

	// 获取建议列表
	public List<Advice> getAdviceList(int page) {
		return adviceDao.list("from Advice", (page - 1) * Constant.pageCount, Constant.pageCount, new String[] {});
	}

	public long getAdviceCount() {
		return adviceDao.getCount("select count(*)  from Config");
	}

	// 获取建议的页数
	public long getAdvicePage() {
		long count = getAdviceCount();
		return count % Constant.pageCount == 0 ? count / Constant.pageCount : count / Constant.pageCount + 1;
	}

	// 删除建议
	public void deleteAdvice(String id) {
		adviceDao.delete(new Advice(id));
	}

	public void addContact(String name, String mobile) {
		Contact ct = new Contact();
		ct.setCreatetime(System.currentTimeMillis() + "");
		ct.setMobile(mobile);
		ct.setName(name);
		contactDao.create(ct);
	}

}