customerdisposedao.java.svn-base

本例使用Java + Jsp 实现选择树的过程,主要使用Struts+JDBC/hibernate架构

	 */
	public int getTotal(String userid) throws Exception 
	{
		int total = 0;
		String sql = "select count(*) as total from t_ser_tasks  where duty_user_guid='"+userid+"'";
		Object result = super.getSession().createSQLQuery(sql).uniqueResult();
		if(result != null)
		{
			total = Integer.parseInt(result.toString());
		}
		return total;
	}
	/**
	 * 获得当前用户任务分解记录（不包含已归档的\回访满意\回访不满意\问题完成\任务完成）
	 * @param info
	 * @return
	 * @throws Exception
	 */
	public List findAll(QueryInfo info,String adviseguid) throws Exception
	{
		//设置记录条数
		if (info.getRecordCount() == -1) {
			info.setRecordCount(this.getTotal(adviseguid));
		}
		List<CustomDisposeDTO> result  = new ArrayList<CustomDisposeDTO>();
		String sql =   " select " 
								 + " t.task_guid, t.task_description,"
                 + " t.org_guid,o.name as orgnization, "
                 + " t.duty_user_guid,p.name as person,"
                 + " t.tel_phone,t.date_limit, "
                 + " t.process,t.dispose_mind, "
                 + " t.advise_guid "
                 + " from t_ser_tasks t "
                 + " left join t_sys_orgnization o on t.org_guid = o.id "
                 + " left join t_sys_orgnization p on t.duty_user_guid = p.id "
                 + " where t.duty_user_guid =  '" + adviseguid +"'  and process not in( " 
                 + "'"+ServiceConstants.STATUS_END+"','"+ServiceConstants.STATUS_QEND+"','"+ServiceConstants.STATUS_NO+"','"+ServiceConstants.STATUS_YES+"','"+ServiceConstants.STATUS_AEND+"')";
		List testlist = super.buildSQLQuery(sql, info).list();
		
		Object[] obj = null;
		for(int i = 0; i < testlist.size(); i++)
		{
			obj = (Object[])testlist.get(i);
			CustomDisposeDTO dto = new CustomDisposeDTO();
			dto.setTaskGuid(obj[0] != null ? obj[0].toString() : "");
			dto.setTaskDescription(obj[1] != null ? obj[1].toString() : "");
			dto.setOrgGuid(obj[2] != null ? obj[2].toString() : "");
			dto.setOrgName(obj[3] != null ? obj[3].toString() : "");
			dto.setDutyUserGuid(obj[4] != null ? obj[4].toString() : "");
			dto.setDutyUserName(obj[5] != null ? obj[5].toString() : "");
			dto.setTelPhone(obj[6] != null ? obj[6].toString() : "");
			dto.setDateLimit(obj[7] != null ? Long.parseLong(obj[7].toString()) : 0);
			dto.setProcess(obj[8] != null ? Long.parseLong(obj[8].toString()) : 0);
			//把数据库中的处理状态值做为索引，获得常量中的状态字符串
			if(obj[8] != null)
			{
				dto.setProcessStatus(ServiceConstants.STATUS_STRING[Integer.parseInt(obj[8].toString())]);
			}
			else
			{
				dto.setProcessStatus("");
			}
			dto.setDisposeMind(obj[9] != null ? obj[9].toString() : "");
			dto.setAdviceGuid(obj[10] != null ? obj[10].toString() : "");
			result.add(dto);
		}
		return result;
	}
	
	/**
	 * 根据分解ID和用户id查询分解记录
	 * @param guid
	 * @param userid
	 * @return
	 */
	public CustomDisposeDTO findByidAndUserID(String guid,String userid) throws Exception
	{
		String sql = " select " 
								+" tser.task_guid, tser.advise_guid, "
								+" tser.task_description,"
								+" tser.org_guid,o.name,"
								+" tser.duty_user_guid,p.name,"
								+" tser.tel_phone,tser.date_limit,"
							  +" tser.process,tser.dispose_mind,"
								+" tser.parent_task_guid,tser.level_no,"
								+" tser.dispose_result,tser.dispose_date_type,"
								+" tser.dispose_date,tser.use_material,"
								+" tser.material_amount,tser.reason,"
								+" tser.customer_return "
								+" from t_ser_tasks tser "
								+" left join t_sys_orgnization o on tser.org_guid = o.id "
								+" left join t_sys_orgnization p on tser.duty_user_guid = p.id "
								+" where tser.duty_user_guid = '"+ userid +"' and tser.task_guid = '"+ guid +"'";
		Query query = super.getSession().createSQLQuery(sql);
		List tempList = query.list();
		Object[] obj = null;
		CustomDisposeDTO dto = new CustomDisposeDTO();
		for(int i = 0; i < tempList.size() ; i++)
		{
			obj = (Object[]) tempList.get(i);
			dto.setTaskGuid(obj[0] != null ? obj[0].toString() : "");
			dto.setAdviceGuid(obj[1] != null ? obj[1].toString() : "");
			dto.setTaskDescription(obj[2] != null ? obj[2].toString() : "");
			dto.setOrgGuid(obj[3] != null ? obj[3].toString() : "");
			dto.setOrgName(obj[4] != null ? obj[4].toString() : "");
			dto.setDutyUserGuid(obj[5] != null ? obj[5].toString() : "");
			dto.setDutyUserName(obj[6] != null ? obj[6].toString() : "");
			dto.setTelPhone(obj[7] != null ? obj[7].toString() : "");
			dto.setDateLimit(obj[8] != null ? Long.parseLong(obj[8].toString()) : 0);
			dto.setProcess(obj[9] != null ? Long.parseLong(obj[9].toString()) : 0);
			//设置当前问题处理状态
			if(obj[9] != null)
			{
				dto.setProcessStatus(ServiceConstants.STATUS_STRING[Integer.parseInt(obj[9].toString())]);
			}
			else
			{
				dto.setProcessStatus("");
			}
			dto.setDisposeMind(obj[10] != null ? obj[10].toString() : "");
			dto.setParentTaskGuid(obj[11] != null ? obj[11].toString() : "");
			dto.setLevelNo(obj[12] != null ? Long.parseLong(obj[12].toString()) : 0);
			dto.setDisposeResult(obj[13] != null ? obj[13].toString() : "");
			dto.setDisposeDateType(obj[14] != null ? Long.parseLong(obj[14].toString()) : 0);
			//设置处理时间分类
			if(obj[14] != null)
			{
				dto.setDisposeDateTypeString(ServiceConstants.DATE_TYPE[Integer.parseInt(obj[14].toString())]);
			}
			else
			{
				dto.setDisposeDateTypeString("");
			}
			dto.setDisposeDate(obj[15] != null ? Long.parseLong(obj[15].toString()) : 0);
			dto.setUseMaterial(obj[16] != null ? obj[16].toString() : "");
			dto.setMaterialAmount(obj[17] != null ? Double.parseDouble(obj[17].toString()) : 0);
			dto.setReason(obj[18] != null ? obj[18].toString() : "");
			dto.setCustomerReturn(obj[19]!= null ? obj[19].toString() : "");
		}
		
		return dto;
	}

	/**
	 * 根据投诉登记ID判断是否有未完成的子分解任务
	 * @param adviseGuid
	 * @return
	 */
	public boolean findChildTask(String adviseGuid) throws Exception
	{
		String sql = "select * from t_ser_tasks tst where tst.advise_guid='" +adviseGuid+ "' "
								+ "and tst.process in ('"+ServiceConstants.STATUS_NEW+"','"+ServiceConstants.STATUS_ONE+"','"+ ServiceConstants.STATUS_TWO +"',"
								+ "'"+ ServiceConstants.STATUS_ING+"')";
		List list = this.getSession().createSQLQuery(sql).list();
		if(list.size()>0)
		{
			return true;
		}
		return false;
	}
	/**
	 * 判断子任务是否完成
	 * @param taskGuid
	 * @return
	 */
	public boolean findNoDisposeTasks(String taskGuid) throws Exception
	{
		String sql = "select ttt.task_description,ttt.process from t_ser_tasks ttt where ttt.advise_guid in("
								+ "select tst.advise_guid  from t_ser_tasks tst where tst.task_guid='" + taskGuid + "')"
								+ "and ttt.process in( '"+ ServiceConstants.STATUS_NEW +"','"+ ServiceConstants.STATUS_ONE +"','"+ ServiceConstants.STATUS_TWO +"','"+ ServiceConstants.STATUS_ING +"' )";
		List list = this.getSession().createSQLQuery(sql).list();
		if(list.size() > 0)
		{
			return true;
		}
		return false;
	}
	/**
	 * 获得任务描述
	 * @param taskGuid
	 * @return
	 */
	public String findFathertaskDescription(String taskGuid) throws Exception
	{
		String sql = "select tt.task_description from t_ser_tasks tt where tt.task_guid='" +taskGuid+ "'";
		return this.getSession().createSQLQuery(sql).uniqueResult().toString();
	}
	/**
	 * 由CustomDisposeDTO转为TSerTasks
	 * @param dto CustomDisposeDTO
	 * @param pojo TSerTasks
	 */
	private void customDisposeDtoTOTSerTasks(CustomDisposeDTO dto,TSerTasks pojo)
	{
		pojo.setAdviceGuid(dto.getAdviceGuid());
		pojo.setCustomerReturn(dto.getCustomerReturn());
		pojo.setDateLimit(dto.getDateLimit());
		pojo.setDisposeDate(dto.getDisposeDate());
		pojo.setDisposeDateType(dto.getDisposeDateType());
		pojo.setDisposeMind(dto.getDisposeMind());
		pojo.setDisposeResult(dto.getDisposeResult());
		pojo.setDutyUserGuid(dto.getDutyUserGuid());
		pojo.setLevelNo(dto.getLevelNo());
		pojo.setMaterialAmount(dto.getMaterialAmount());
		pojo.setOrgGuid(dto.getOrgGuid());
		pojo.setParentTaskGuid(dto.getParentTaskGuid());
		pojo.setProcess(dto.getProcess());
		pojo.setReason(dto.getReason());
		pojo.setTaskDescription(dto.getTaskDescription());
		pojo.setTaskGuid(dto.getTaskGuid());
		pojo.setTelPhone(dto.getTelPhone());
		pojo.setUseMaterial(dto.getUseMaterial());
	}
	/**
	 * 有TSerTasks转为CustomDisposeDTO
	 * @param pojo TSerTasks
	 * @param dto CustomDisposeDTO
	 */
	private void tserTasksToCustomDisposeDto(TSerTasks pojo,CustomDisposeDTO dto)
	{
		dto.setAdviceGuid(pojo.getAdviceGuid());
		dto.setCustomerReturn(pojo.getCustomerReturn());
		dto.setDateLimit(pojo.getDateLimit());
		dto.setDisposeDate(pojo.getDisposeDate());
		dto.setDisposeDateType(pojo.getDisposeDateType());
		dto.setDisposeMind(pojo.getDisposeMind());
		dto.setDisposeResult(pojo.getDisposeResult());
		dto.setDutyUserGuid(pojo.getDutyUserGuid());
		dto.setLevelNo(pojo.getLevelNo());
		dto.setMaterialAmount(pojo.getMaterialAmount());
		dto.setOrgGuid(pojo.getOrgGuid());
		dto.setParentTaskGuid(pojo.getParentTaskGuid());
		dto.setProcess(pojo.getProcess());
		dto.setReason(pojo.getReason());
		dto.setTaskDescription(pojo.getTaskDescription());
		dto.setTaskGuid(pojo.getTaskGuid());
		dto.setTelPhone(pojo.getTelPhone());
		dto.setUseMaterial(pojo.getUseMaterial());
	}
	
}