package cn.ksource.web.service.impl;

import java.util.Random;

import org.apache.commons.lang.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.util.DateUtil;
import cn.ksource.web.service.BillReportCodeService;

@Service
public class BillReportCodeServiceImpl implements BillReportCodeService {

	@Autowired
	private BaseDao baseDao;
	
	/**
	 * 获取统一code，XXX-20150127-001
	 * @param type
	 * @param serial
	 * @return
	 */
	private String getUnityCode(String type, int serial) {
		return type + "-" + DateUtil.getCurrentDate8() + "-" + StringUtils.leftPad(String.valueOf(serial + 1), 3, '0');
	}
	
	@Override
	public String getDailyOperationCode(String customerId) {
		String sql = "select count(1) as NUM from sc_daily_operation_record where CUSTOMER_ID=:customer_id and RECORD_DATE=:report_date";
		
		SqlParameter param = new SqlParameter();
		param.addValue("report_date", DateUtil.getCurrentDate8());
		param.addValue("customer_id", customerId);
		
		int num = baseDao.queryForInteger(sql, param);
		
		return getUnityCode("RCYW", num);
	}

	@Override
	public String getDailyPatrolCode(String customerId) {
        String sql = "select count(1) as NUM from sc_daily_patrol_report where CUSTOMER_ID=:customer_id and REPORT_DATE=:report_date";
		
		SqlParameter param = new SqlParameter();
		param.addValue("report_date", DateUtil.getCurrentDate8());
		param.addValue("customer_id", customerId);
		
		int num = baseDao.queryForInteger(sql, param);
		return getUnityCode("RCXJ", num);
	}

	@Override
	public String getDailyOperationWeeklyCode(String customerId) {
        String sql = "select count(1) as NUM from sc_daily_operation_weekly where CUSTOMER_ID=:customer_id ";
		
		SqlParameter param = new SqlParameter();
		param.addValue("customer_id", customerId);
		
		int num = baseDao.queryForInteger(sql, param);
		
		return getUnityCode("YWZB", num);
	}

	@Override
	public String getCustomerSatisCode(String partnerId) {
        String sql = "select count(1) from customer_satis_info where PARTNER_ID=:partner_id ";
		
		SqlParameter param = new SqlParameter();
		param.addValue("partner_id", partnerId);
		
		int num = baseDao.queryForInteger(sql, param);
		
		return getUnityCode("MYDDC", num);
	}

}