巡逻点位 - 获取巡逻路线的点位列表 __qmtw40pukMZGOuCte1x __qmtw40pukMZGOuCte1x published UTF-8 post /duty/task/path/point/list json 0)as typeName," + " concat(t.ITEM_ATTENDANCESITEADDRESS,ITEM_ATTENDANCESITEFULLADDRESS) as address, " + " t.ITEM_ATTENDANCESITELONGITUDE as longitude," + " t.ITEM_ATTENDANCESITELATITUDE as latitude " + " from tlk_patrol_path_point_relations r" + " join tlk_patrol_points t on r.ITEM_POINTID = t.id " + " where r.item_pathid = '" + pathId + "'" sql += " limit " + limitFrom + "," + pageSize; var data = queryByDSName("duty",sql); //result.put("sql", sql); result.put("data", data); return result; })()]]>