package com.hxzkoa.services;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
import javax.persistence.EntityManager;
|
import javax.persistence.PersistenceContext;
|
import javax.persistence.Query;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import com.hxzkoa.json.tb_map;
|
import com.hxzkoa.json.tb_person;
|
import com.hxzkoa.util.Config;
|
import com.hxzkoa.util.ModifyConfig;
|
|
@Service
|
public class MapService {
|
@PersistenceContext
|
private EntityManager em;
|
@Autowired
|
private CaozuoService cs;
|
|
public List<tb_map> getMapManagement() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,floor,mapname,x_Truelength,y_Truewidth,x0_length,y0_width,x_Pixel,y_Pixel,addTime FROM tb_map order by addtime desc";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_map> tb_mapList = new ArrayList<tb_map>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_map map = new tb_map();
|
Object[] obj = (Object[]) resultList.get(i);
|
map.setId((int) obj[0]);
|
map.setFloor(obj[1] == null ? "" : obj[1].toString());
|
map.setMapname(obj[2] == null ? "" : obj[2].toString());
|
map.setX_Truelength(obj[3] == null ? "" : obj[3].toString());
|
map.setY_Truewidth(obj[4] == null ? "" : obj[4].toString());
|
map.setX0_length(obj[5] == null ? "" : obj[5].toString());
|
map.setY0_width(obj[6] == null ? "" : obj[6].toString());
|
map.setX_Pixel(obj[7] == null ? "" : obj[7].toString());
|
map.setY_Pixel(obj[8] == null ? "" : obj[8].toString());
|
map.setAddTime(obj[9] == null ? "" : obj[9].toString());
|
tb_mapList.add(map);
|
}
|
}
|
return tb_mapList;
|
}
|
|
public List<tb_map> getMapManagement(int page) {
|
int perPage = Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage"));
|
int start = (page - 1) * perPage;
|
int end = perPage;
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,floor,mapname,x_Truelength,y_Truewidth,x0_length,y0_width,x_Pixel,y_Pixel,addTime,baoliu3,baoliu4 FROM tb_map LIMIT :start,:end";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("start", start);
|
query.setParameter("end", end);
|
List resultList = query.getResultList();
|
List<tb_map> tb_mapList = new ArrayList<tb_map>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_map map = new tb_map();
|
Object[] obj = (Object[]) resultList.get(i);
|
map.setId((int) obj[0]);
|
map.setFloor(obj[1] == null ? "" : obj[1].toString());
|
map.setMapname(obj[2] == null ? "" : obj[2].toString());
|
map.setX_Truelength(obj[3] == null ? "" : obj[3].toString());
|
map.setY_Truewidth(obj[4] == null ? "" : obj[4].toString());
|
map.setX0_length(obj[5] == null ? "" : obj[5].toString());
|
map.setY0_width(obj[6] == null ? "" : obj[6].toString());
|
map.setX_Pixel(obj[7] == null ? "" : obj[7].toString());
|
map.setY_Pixel(obj[8] == null ? "" : obj[8].toString());
|
map.setAddTime(obj[9] == null ? "" : obj[9].toString());
|
map.setBaoliu3(obj[10] == null ? "" : obj[10].toString());
|
map.setBaoliu4(obj[11] == null ? "" : obj[11].toString());
|
tb_mapList.add(map);
|
}
|
}
|
return tb_mapList;
|
}
|
|
public List<tb_map> getMapManagementa() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,floor,mapname,x_Truelength,y_Truewidth,x0_length,y0_width,x_Pixel,y_Pixel,addTime,baoliu3,baoliu4 FROM tb_map";
|
query = this.em.createNativeQuery(sql);
|
List resultList = query.getResultList();
|
List<tb_map> tb_mapList = new ArrayList<tb_map>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_map map = new tb_map();
|
Object[] obj = (Object[]) resultList.get(i);
|
map.setId((int) obj[0]);
|
map.setFloor(obj[1] == null ? "" : obj[1].toString());
|
map.setMapname(obj[2] == null ? "" : obj[2].toString());
|
map.setX_Truelength(obj[3] == null ? "" : obj[3].toString());
|
map.setY_Truewidth(obj[4] == null ? "" : obj[4].toString());
|
map.setX0_length(obj[5] == null ? "" : obj[5].toString());
|
map.setY0_width(obj[6] == null ? "" : obj[6].toString());
|
map.setX_Pixel(obj[7] == null ? "" : obj[7].toString());
|
map.setY_Pixel(obj[8] == null ? "" : obj[8].toString());
|
map.setAddTime(obj[9] == null ? "" : obj[9].toString());
|
map.setBaoliu3(obj[10] == null ? "" : obj[10].toString());
|
map.setBaoliu4(obj[11] == null ? "" : obj[11].toString());
|
tb_mapList.add(map);
|
}
|
}
|
return tb_mapList;
|
}
|
|
public int getMapManagementCount() {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT count(1) FROM tb_map";
|
query = this.em.createNativeQuery(sql);
|
return Integer.parseInt(query.getSingleResult().toString());
|
}
|
|
public List<tb_map> searchMapService(String input) {
|
String mapname = input;
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,floor,mapname,x_Truelength,y_Truewidth,x0_length,y0_width,x_Pixel,y_Pixel,addTime,baoliu3,baoliu4 FROM tb_map WHERE mapname = :mapname";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("mapname", mapname);
|
List resultList = query.getResultList();
|
List<tb_map> tb_mapList = new ArrayList<tb_map>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_map map = new tb_map();
|
Object[] obj = (Object[]) resultList.get(i);
|
map.setId((int) obj[0]);
|
map.setFloor(obj[1] == null ? "" : obj[1].toString());
|
map.setMapname(obj[2] == null ? "" : obj[2].toString());
|
map.setX_Truelength(obj[3] == null ? "" : obj[3].toString());
|
map.setY_Truewidth(obj[4] == null ? "" : obj[4].toString());
|
map.setX0_length(obj[5] == null ? "" : obj[5].toString());
|
map.setY0_width(obj[6] == null ? "" : obj[6].toString());
|
map.setX_Pixel(obj[7] == null ? "" : obj[7].toString());
|
map.setY_Pixel(obj[8] == null ? "" : obj[8].toString());
|
map.setAddTime(obj[9] == null ? "" : obj[9].toString());
|
map.setBaoliu3(obj[10] == null ? "" : obj[10].toString());
|
map.setBaoliu4(obj[11] == null ? "" : obj[11].toString());
|
tb_mapList.add(map);
|
}
|
}
|
return tb_mapList;
|
}
|
|
@Transactional
|
public void mapManagement_delete(String[] checkVal) {
|
String sql = null;
|
Query query = null;
|
for (int i = 0; i < checkVal.length; i++) {
|
String floor = checkVal[i];
|
sql = "DELETE FROM tb_map WHERE floor=:floor";
|
cs.tb_caozuo("tb_map", 2);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("floor", floor);
|
query.executeUpdate();
|
}
|
}
|
|
@Transactional
|
public void mapManagement_deleteAll() {
|
String sql = null;
|
Query query = null;
|
sql = "DELETE FROM tb_map";
|
cs.tb_caozuo("tb_map", 2);
|
query = this.em.createNativeQuery(sql);
|
query.executeUpdate();
|
}
|
|
@Transactional
|
public int mapManagement_add(tb_map map) {
|
String sql = null;
|
Query query = null;
|
sql = "INSERT INTO tb_map(floor,mapname,x_Truelength,y_Truewidth,x0_length,y0_width,x_Pixel,y_Pixel,addTime,baoliu3,baoliu4) VALUES(:floor,:mapname,:x_Truelength,:y_Truewidth,:x0_length,:y0_width,:x_Pixel,:y_Pixel,now(),:baoliu3,:baoliu4)";
|
cs.tb_caozuo("tb_map", 1);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("floor", map.getFloor());
|
query.setParameter("mapname", map.getMapname());
|
query.setParameter("x_Truelength", map.getX_Truelength());
|
query.setParameter("y_Truewidth", map.getY_Truewidth());
|
query.setParameter("x0_length", map.getX0_length());
|
query.setParameter("y0_width", map.getY0_width());
|
query.setParameter("x_Pixel", map.getX_Pixel());
|
query.setParameter("y_Pixel", map.getY_Pixel());
|
query.setParameter("baoliu3", map.getBaoliu3());
|
query.setParameter("baoliu4", map.getBaoliu4());
|
int executeUpdate = query.executeUpdate();
|
return executeUpdate;
|
}
|
|
@Transactional
|
public int mapManagement_modify(tb_map map) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_map SET floor = :floor,mapname = :mapname,x_Truelength = :x_Truelength,y_Truewidth = :y_Truewidth,x0_length = :x0_length,y0_width = :y0_width,x_Pixel = :x_Pixel,y_Pixel = :y_Pixel,addTime = now(),baoliu3 = :baoliu3,baoliu4 = :baoliu4 WHERE id= :id";
|
cs.tb_caozuo("tb_map", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("id", map.getId());
|
query.setParameter("floor", map.getFloor());
|
query.setParameter("mapname", map.getMapname());
|
query.setParameter("x_Truelength", map.getX_Truelength());
|
query.setParameter("y_Truewidth", map.getY_Truewidth());
|
query.setParameter("x0_length", map.getX0_length());
|
query.setParameter("y0_width", map.getY0_width());
|
query.setParameter("x_Pixel", map.getX_Pixel());
|
query.setParameter("y_Pixel", map.getY_Pixel());
|
query.setParameter("baoliu3", map.getBaoliu3());
|
query.setParameter("baoliu4", map.getBaoliu4());
|
int executeUpdate = query.executeUpdate();
|
return executeUpdate;
|
}
|
|
@Transactional
|
public int mapManagement_modify2(tb_map map) {
|
String sql = null;
|
Query query = null;
|
sql = "UPDATE tb_map SET floor = :floor,x_Truelength = :x_Truelength,y_Truewidth = :y_Truewidth,x0_length = :x0_length,y0_width = :y0_width,x_Pixel = :x_Pixel,y_Pixel = :y_Pixel,addTime = now(),baoliu3 = :baoliu3,baoliu4 = :baoliu4 WHERE id= :id";
|
cs.tb_caozuo("tb_map", 3);
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("id", map.getId());
|
query.setParameter("floor", map.getFloor());
|
query.setParameter("x_Truelength", map.getX_Truelength());
|
query.setParameter("y_Truewidth", map.getY_Truewidth());
|
query.setParameter("x0_length", map.getX0_length());
|
query.setParameter("y0_width", map.getY0_width());
|
query.setParameter("x_Pixel", map.getX_Pixel());
|
query.setParameter("y_Pixel", map.getY_Pixel());
|
query.setParameter("baoliu3", map.getBaoliu3());
|
query.setParameter("baoliu4", map.getBaoliu4());
|
int executeUpdate = query.executeUpdate();
|
return executeUpdate;
|
}
|
|
public List<tb_map> getMap_floor(String input) {
|
String floor = input;
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,floor,mapname,x_Truelength,y_Truewidth,x0_length,y0_width,x_Pixel,y_Pixel,addTime FROM tb_map WHERE floor = :floor";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("floor", floor);
|
List resultList = query.getResultList();
|
List<tb_map> tb_mapList = new ArrayList<tb_map>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_map map = new tb_map();
|
Object[] obj = (Object[]) resultList.get(i);
|
map.setId((int) obj[0]);
|
map.setFloor(obj[1] == null ? "" : obj[1].toString());
|
map.setMapname(obj[2] == null ? "" : obj[2].toString());
|
map.setX_Truelength(obj[3] == null ? "" : obj[3].toString());
|
map.setY_Truewidth(obj[4] == null ? "" : obj[4].toString());
|
map.setX0_length(obj[5] == null ? "" : obj[5].toString());
|
map.setY0_width(obj[6] == null ? "" : obj[6].toString());
|
map.setX_Pixel(obj[7] == null ? "" : obj[7].toString());
|
map.setY_Pixel(obj[8] == null ? "" : obj[8].toString());
|
map.setAddTime(obj[9] == null ? "" : obj[9].toString());
|
tb_mapList.add(map);
|
}
|
}
|
return tb_mapList;
|
}
|
|
public List<tb_map> searchMapfloorService(String floor) {
|
String sql = null;
|
Query query = null;
|
sql = "SELECT id,floor,mapname,x_Truelength,y_Truewidth,x0_length,y0_width,x_Pixel,y_Pixel,addTime FROM tb_map WHERE floor = :floor";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("floor", floor);
|
List resultList = query.getResultList();
|
List<tb_map> tb_mapList = new ArrayList<tb_map>();
|
if (resultList.size() > 0) {
|
for (int i = 0; i < resultList.size(); i++) {
|
tb_map map = new tb_map();
|
Object[] obj = (Object[]) resultList.get(i);
|
map.setId((int) obj[0]);
|
map.setFloor(obj[1] == null ? "" : obj[1].toString());
|
map.setMapname(obj[2] == null ? "" : obj[2].toString());
|
map.setX_Truelength(obj[3] == null ? "" : obj[3].toString());
|
map.setY_Truewidth(obj[4] == null ? "" : obj[4].toString());
|
map.setX0_length(obj[5] == null ? "" : obj[5].toString());
|
map.setY0_width(obj[6] == null ? "" : obj[6].toString());
|
map.setX_Pixel(obj[7] == null ? "" : obj[7].toString());
|
map.setY_Pixel(obj[8] == null ? "" : obj[8].toString());
|
map.setAddTime(obj[9] == null ? "" : obj[9].toString());
|
tb_mapList.add(map);
|
}
|
}
|
return tb_mapList;
|
}
|
|
}
|
