/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.grid.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.common.cache.SysCache;
import org.springblade.common.param.CommonParamSet;
import org.springblade.common.utils.NodeTreeUtil;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
import org.springblade.modules.doorplateAddress.service.IDoorplateAddressService;
import org.springblade.modules.grid.entity.GridEntity;
import org.springblade.modules.grid.entity.GridRangeEntity;
import org.springblade.modules.grid.entity.GridmanEntity;
import org.springblade.modules.grid.excel.GridExcel;
import org.springblade.modules.grid.mapper.GridMapper;
import org.springblade.modules.grid.service.IGridRangeService;
import org.springblade.modules.grid.service.IGridService;
import org.springblade.modules.grid.vo.GridVO;
import org.springblade.modules.place.vo.PlaceVO;
import org.springblade.modules.system.entity.Dept;
import org.springblade.modules.system.entity.Region;
import org.springblade.modules.system.service.IDeptService;
import org.springblade.modules.system.service.IRegionService;
import org.springblade.modules.task.vo.TaskVO;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.*;

/**
 * 网格表 服务实现类
 *
 * @author BladeX
 * @since 2023-10-28
 */
@Service
public class GridServiceImpl extends ServiceImpl<GridMapper, GridEntity> implements IGridService {

	@Autowired
	private IRegionService regionService;

	@Autowired
	private IDoorplateAddressService doorplateAddressService;

	@Autowired
	private IGridRangeService gridRangeService;

	@Autowired
	private IDeptService deptService;

	@Override
	public IPage<GridVO> selectGridPage(IPage<GridVO> page, GridVO grid) {
//		List<String> regionChildCodesList = SysCache.getRegionChildCodesByDeptId(AuthUtil.getDeptId());
//		Integer isAdministrator = AuthUtil.isAdministrator()==true?1:2;
		CommonParamSet commonParamSet = new CommonParamSet().invoke(GridVO.class, grid);
		return page.setRecords(baseMapper.selectGridPage(page, grid,commonParamSet.getRegionChildCodesList(),commonParamSet.getIsAdministrator()));
	}

	/**
	 * 网格数导入
	 * @param data
	 * @param isCovered
	 */
	@Override
	@Transactional(rollbackFor = Exception.class)
	public void importGrid(List<GridExcel> data, Boolean isCovered) {
		List<GridEntity> list = new ArrayList<>();
		// 遍历
		for (GridExcel gridExcel : data) {
			// 取出名称分隔
			String[] split = gridExcel.getGridName().split("第");
			GridEntity gridEntity = new GridEntity();
			// 通过社区名称查询对应的社区编号
			QueryWrapper<Region> wrapper = new QueryWrapper<>();
			wrapper.like("name",split[0]);
			System.out.println("社区名称 = " + split[0]);
			Region region = regionService.getOne(wrapper);
			if (null!=region){
				gridEntity.setCommunityCode(region.getCode());
			}
			// 比对网格是否存在，如果已存在则更新，否则则新增
			QueryWrapper<GridEntity> queryWrapper = new QueryWrapper<>();
			queryWrapper.eq("is_deleted",0)
				.eq("grid_name","第" + split[1])
				.eq("community_code",region.getCode());
			GridEntity one = getOne(queryWrapper);
			if (null!=one){
				one.setGridCode(gridExcel.getGridCode());
				one.setGridName("第" + split[1]);
				one.setGeom(gridExcel.getGeom());
				one.setUpdateUser(AuthUtil.getUserId());
				one.setUpdateTime(new Date());
				// 更新
				updateById(one);
			}else {
				// 设置网格数据
				gridEntity.setGridCode(gridExcel.getGridCode());
				gridEntity.setGridName("第" + split[1]);
				gridEntity.setGeom(gridExcel.getGeom());
				gridEntity.setCreateUser(AuthUtil.getUserId());
				gridEntity.setCreateTime(new Date());
				gridEntity.setUpdateUser(AuthUtil.getUserId());
				gridEntity.setUpdateTime(new Date());
				list.add(gridEntity);
			}
		}
		// 批量导入
		saveBatch(list);
	}

	/**
	 * 根据地址编号查询网格数据
	 * @param houseCode
	 * @return
	 */
	@Override
	public GridVO getPlaceGridDetailByHouseCode(String houseCode) {
		return baseMapper.getPlaceGridDetailByHouseCode(houseCode);
	}

	/**
	 * 根据用户id(网格员)查询对应的房屋地址code
	 * @param userId
	 * @return
	 */
	@Override
	public List<String> getAddressCodeListByUserId(Long userId,String addressCode) {
		return baseMapper.getAddressCodeListByUserId(userId,addressCode);
	}

	/**
	 * 空间分析 mysql 5.7
	 */
	@Override
	@Transactional(rollbackFor = Exception.class)
	public Object spatialAnalysis(DoorplateAddressEntity addressEntity) {
		// 按社区
		String name = null;
//		String name = "茶山路社区居民委员会";
		//查询社区信息
		List<DoorplateAddressEntity> doorplateAddressEntities = doorplateAddressService.getAllDoorplateAddress(addressEntity);
		//遍历
		for (DoorplateAddressEntity doorplateAddressEntity : doorplateAddressEntities) {
			//点坐标解析
			String point = "'POINT(" + doorplateAddressEntity.getX() + " " + doorplateAddressEntity.getY() +")'";
//			String point = "'POINT(" + villageInfoExcel.getLatitude() + " " + villageInfoExcel.getLongitude() +")'";
			List<GridEntity> gridEntityList = baseMapper.spatialAnalysis(point);
			if (gridEntityList.size()>0) {
				GridEntity gridEntity = gridEntityList.get(0);
				QueryWrapper<GridRangeEntity> queryWrapper = new QueryWrapper<>();
				queryWrapper.eq("grid_id",gridEntity.getId()).eq("house_code",doorplateAddressEntity.getAddressCode());
				GridRangeEntity one = gridRangeService.getOne(queryWrapper);
				if (null==one) {
					GridRangeEntity gridRangeEntity = new GridRangeEntity();
					gridRangeEntity.setGridId(gridEntity.getId());
					gridRangeEntity.setHouseCode(doorplateAddressEntity.getAddressCode());
					gridRangeEntity.setDistrictCode(doorplateAddressEntity.getAoiCode());
					gridRangeEntity.setDistrictName(doorplateAddressEntity.getAoiName());
					// 保存
					gridRangeService.save(gridRangeEntity);
				}else {
					one.setGridId(gridEntity.getId());
					// 更新
					gridRangeService.updateById(one);
				}
			}
		}
		return null;
	}

	/**
	 * 空间分析
	 */
	@Override
	public List<GridEntity> spatialAnalysis(String point) {
		return baseMapper.spatialAnalysis(point);
	}

	/**
	 * 根据参数查询网格数据
	 * @param place
	 * @return
	 */
	@Override
	public GridVO getGridDetailByParam(PlaceVO place) {
		return baseMapper.getGridDetailByParam(place);
	}

	/**
	 * 网格表 自定义详情
	 * @param grid
	 * @return
	 */
	@Override
	public GridVO getGridDetail(GridVO grid) {
		return baseMapper.getGridDetail(grid);
	}

	/**
	 * 网格表 自定义新增或修改
	 */
	@Override
	@Transactional(rollbackFor = Exception.class)
	public boolean saveOrUpdateGrid(GridEntity grid) {
		boolean flag = false;
		if (null!=grid.getId()) {
			// 更新
			flag = updateById(grid);
		}else {
			// 先查询当前网格社区对应的机构id
			QueryWrapper<Region> regionWrapper = new QueryWrapper<>();
			regionWrapper.eq("code", grid.getCommunityCode());
			Region region = regionService.getOne(regionWrapper);
			// 查询父机构（社区机构）
			System.out.println("社区名称 = " + region.getName());
			QueryWrapper<Dept> wrapper = new QueryWrapper<>();
			wrapper.eq("dept_name", region.getName())
				.eq("dept_nature", 2)
				.eq("is_deleted", 0);
			Dept dept = deptService.getOne(wrapper);
			// 查询当前网格在机构中是否存在，存在不做操作，否则则新增
			QueryWrapper<Dept> wrapperChild = new QueryWrapper<>();
			wrapperChild.eq("dept_name", grid.getGridName())
				.eq("is_deleted", 0)
				.eq("dept_nature", 2)
				.eq("parent_id", dept.getId());
			List<Dept> deptChild = deptService.list(wrapperChild);
			if (deptChild.size() == 0) {
				Dept deptInfo = new Dept();
				deptInfo.setParentId(dept.getId());
				deptInfo.setFullName(grid.getGridName());
				deptInfo.setDeptName(grid.getGridName());
				deptInfo.setDeptCategory(1);
				// 综治
				deptInfo.setDeptNature(2);
				deptInfo.setTenantId("000000");
				deptInfo.setRegionCode(grid.getGridCode());
				deptInfo.setAncestors(dept.getAncestors() + "," + dept.getId());
				// 新增
				deptService.save(deptInfo);
				// 查询网格是否已存在（社区编号-网格名称），已存在更新，不存在插入新的
				QueryWrapper<GridEntity> queryWrapper = new QueryWrapper<>();
				queryWrapper.eq("grid_code", grid.getGridCode())
					.eq("is_deleted", 0);
				System.out.println("网格编号 = " + grid.getGridCode());
				GridEntity one = getOne(queryWrapper);
				if (null != one) {
					grid.setId(one.getId());
					grid.setDeptId(deptInfo.getId());
					if (null != grid.getGeom() && grid.getGeom().equals("")) {
						grid.setGeom(null);
					}
					// 更新
					flag = updateById(grid);
				} else {
					grid.setDeptId(deptInfo.getId());
					grid.setGeom(null);
					// 插入
					flag = save(grid);
				}
			}
		}
		return flag;
	}

	/**
	 * 网格数据同步处理
	 */
	@Override
	public Object asyncGridDept() {
		List<GridEntity> list = baseMapper.selectGridAll();
		for (GridEntity gridEntity : list) {
			saveOrUpdateGrid(gridEntity);
		}
		return null;
	}

	/**
	 * 网格树
	 *
	 * @param grid
	 * @return
	 */
	@Override
	public Object getGridTree(GridVO grid) {
		return NodeTreeUtil.getStringNodeTree(baseMapper.getGridTree());
	}


	@Override
	public Object gridInfoByHouseCode(String houseCode) {
		Map<String, Object> objectObjectHashMap = new HashMap<>();
		List<GridmanEntity> gridmanEntities = baseMapper.gridInfo(houseCode);
		Integer id = gridmanEntities.get(0).getId();
		objectObjectHashMap.put("grid", gridmanEntities);
		List<DoorplateAddressEntity> result = baseMapper.gridAoiName(id);
		objectObjectHashMap.put("doorplateAddress", result);
		return objectObjectHashMap;
	}

	/**
	 * 网格集合查询
	 * @param grid
	 * @return
	 */
	@Override
	public Object getGridList(GridVO grid) {
		return baseMapper.getGridList(grid);
	}

	/**
	 * 查询小区网格绑定
	 * @param aoiCode 小区aoiCode
	 * @return
	 */
	@Override
	public List<GridVO> getGridListByAoiCode(String aoiCode) {
		return baseMapper.getGridListByAoiCode(aoiCode);
	}

	/**
	 * 查询对应网格人对应的网格
	 * @param userId
	 * @return
	 */
	@Override
	public GridEntity getGridByUserId(Long userId) {
		return baseMapper.getGridByUserId(userId);
	}

	/**
	 * 根据网格名称，社区名称查询对应的网格
	 * @param gridName
	 * @param communityName
	 * @return
	 */
	@Override
	public GridEntity getGridByNames(String gridName, String communityName) {
		return baseMapper.getGridByNames(gridName,communityName);
	}

	/**
	 * 查询用户对应的网格
	 * @param userId
	 * @return
	 */
	@Override
	public List<String> getGridListByUserId(Long userId) {
		return baseMapper.getGridListByUserId(userId.toString());
	}
}