前台后台交互实例

前台

function initVisitTable(id, period){
	$.post('/planRest/post', {path:'/visit/taskObjectByTaskId',taskId:id,period:period,userCode:userCode},function(result){
//	tcRest('post','http://ip:port/visit/taskObjectByTaskId',JSON.stringify({taskId:id}),function(result){
		var data = result.data;
		generTable('#visitCustTable',{
			data:mtbLocalData(data),
			pagination:false,
			columns:[
				{field:"custName", title:"父客户名称"},
				{field:"city", title:"地市"},
				{field:"serviceMngPeriod", title:"巡检周期",template:function(row){
					if(row.serviceMngPeriod=='month'){
						return '月';
					}else if(row.serviceMngPeriod=='quarter'){
						return '季度';
					}else if(row.serviceMngPeriod=='halfYear'){
						return '半年';
					}else if(row.serviceMngPeriod=='year'){
						return '一年';
					}else {
						return row.serviceMngPeriod;
					}
				}},
				{field:"state", title:"是否反馈",template:function(row){
                        if(row.serviceMngPeriod=='month'){
                            vhcircle='月';
                        }else if(row.serviceMngPeriod=='quarter'){
                            vhcircle='季度';
                        }else if(row.serviceMngPeriod=='halfYear'){
                            vhcircle='半年';
                        }else if(row.serviceMngPeriod=='year'){
                            vhcircle='一年';
                        }else {
                            vhcircle=row.serviceMngPeriod;
                        }
					if(row.state == 1){
						return '已反馈&nbsp&nbsp<a href="javascript:void(0);" onclick="checkFeedbackTask(' +row.id+ ');">查看</a>';
					}else{
						return '未反馈';
					}
				}},
//				{field:"uploadTime", title:"上传时间", width:100},
				{field:"operate", title:"操作", template:function(row){
					if(regionName == row.city) {
						if(row.state == 1){
							return '<a href="javascript:void(0);" onclick="feedbackTask(' +row.id+ ');">修改反馈</a>&nbsp&nbsp' +
							'<a href="/visit/visitFile?taskId=' +row.taskId+ '&id=' +row.id+ '">上传附件</a>';
						}else{
							return '<a href="javascript:void(0);" onclick="feedbackTask(' +row.id+ ');">反馈</a>&nbsp&nbsp' +
							'<a href="/visit/visitFile?taskId=' +row.taskId+ '&id=' +row.id+ '">上传附件</a>';
						}
					}else {
						return "";
					}
				}}
			]
		});
	});
}

后台

controller

@ApiOperation("修改页面--初始化拜访客户信息")
	@PostMapping("/taskObjectByTaskId")
	public Result<?> taskObjectByTaskId(String taskId, String period, String userCode) {
		try {
			return Result.successOf(visitService.taskObjectByTaskId(Integer.valueOf(taskId), period, userCode));
		} catch (Exception e) {
			e.printStackTrace();
			return Result.errorOf(1, "查询拜访客户信息失败");
		}
	}

service

public List<Map<String, Object>> taskObjectByTaskId(Integer taskId, String period, String userCode){
    	return visitDao.taskObjectByTaskId(taskId, period, userCode);
    }

dao

public List<Map<String, Object>> taskObjectByTaskId(Integer taskId, String period, String userCode){
    	String sql = "SELECT t.CUST_ID AS \"custId\", t.CUST_NAME AS \"custName\", t.CITY AS \"city\", t.FIRST_SERVICE_MNG_NAME AS \"firstServiceMngName\", "
    			+ " t.FIRST_SERVICE_MNG_PHONE AS \"firstServiceMngPhone\", t.FIRST_SERVICE_MNG_PERIOD AS \"firstServiceMngPeriod\", "
    			+ " t.SERVICE_MNG_NAME AS \"serviceMngName\", t.SERVICE_MNG_PHONE AS \"serviceMngPhone\", t.SERVICE_MNG_PERIOD AS \"serviceMngPeriod\","
    			+ " t.TASK_ID AS \"taskId\", t.ID AS \"id\", ti.STATE AS \"state\" "
    			+ " FROM "+TableSchema.RES+".PLAN_TASK_OBJECT_HB t left join "+TableSchema.RES+".plan_task_instance ti "
    			+ " on ti.OBJECT_ID = t.ID WHERE t.DEL_FLAG = '0' AND ti.period_name= ? AND t.TASK_ID = ? ";
    	/**
    	 * 权限控制放出以下代码：地市人员只能看到和自己地市相关的计划任务，省级可以看全部
    	 */
    	/*UserInfo userInfo = authorityQueryUtil.getUserInfo(userCode);
    	String regionLevel = userInfo.getRegionLevel();
    	if("2".equals(regionLevel)) {
    		sql += " and t.city = (select r.region_name from "
    				+ " "+TableSchema.ISHARE+".usi_user u, "+TableSchema.GCS_RES+".region_info r where u.del_flag = 0 and u.area_id = r.region_code "
					+ " and u.user_code = '" +userCode+ "' ) ";
    	}*/
    	System.out.println("拜访客户信息by任务id-sql------>"+sql);
    	return jdbcTemplate.queryForList(sql,period,taskId);
    }