package com.home.xining.service;

import com.home.xining.config.CmnConst;
import com.home.xining.service.idel.IAdvanceNoticeService;
import com.home.xining.service.idel.IOfficeExpensesService;
import com.product.common.lang.StringUtils;
import com.product.core.dao.BaseDao;
import com.product.core.entity.DataTableEntity;
import com.product.core.entity.FieldSetEntity;
import com.product.core.exception.BaseException;
import com.product.core.permission.PermissionService;
import com.product.core.service.support.AbstractBaseService;
import com.product.core.service.support.QueryFilterService;
import com.product.core.transfer.Transactional;
import com.product.util.BaseUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Service;

import java.text.ParseException;

/**
 * @ClassName: AdvanceNoticeService
 * @Author:
 * @Date: 2022/1/11 17:16
 * @Description: 行政处罚事先告知书Service
 */
@Service
public class AdvanceNoticeService extends AbstractBaseService implements IAdvanceNoticeService {

    @Autowired
    public BaseDao baseDao;
    @Autowired
    PermissionService permissionService;
    @Autowired
    QueryFilterService queryFilterService;

    @Override
    public DataTableEntity listAdvanceNoticeg(FieldSetEntity fs) throws BaseException{
        String filter=fs.getString("filter");
        String dataFilter = permissionService.getDataFilter(fs.getTableName(),CmnConst.NO18);

        if(!StringUtils.isEmpty(dataFilter)){
            if(!StringUtils.isEmpty(filter)){
                filter += " and "+dataFilter;
            }else {
                filter = dataFilter;
            }
        }
        if(!BaseUtil.dataTableIsEmpty(fs.getSubDataTable("systemSeniorQueryString"))){
            filter	= filter + " and " + queryFilterService.getQueryFilter(fs);
        }
//        fs.getInteger(CmnConst.PAGESIZE),fs.getInteger(CmnConst.CPAGE)
        DataTableEntity dt = baseDao.listTable(CmnConst.APP_NOTICE_PUNISHMENT,filter, null,null," no00 desc",fs.getInteger(CmnConst.PAGESIZE),fs.getInteger(CmnConst.CPAGE));
        baseDao.loadPromptData(dt);
        return dt;
    }

    @Override
    public FieldSetEntity getAdvanceNotice(FieldSetEntity fs) {
        return baseDao.getFieldSet(CmnConst.APP_NOTICE_PUNISHMENT, fs.getUUID(), false);
    }

    @Override
    @Transactional
    public String saveAdvanceNotice(FieldSetEntity fs)throws BaseException {
        String fsUUID = fs.getUUID();
        if(BaseUtil.strIsNull(fsUUID)){
          fsUUID = baseDao.add(fs);
        }else{
            baseDao.update(fs);
        }
        return fsUUID;
    }

    @Override
    @Transactional
    public String deleteAdvanceNotice(FieldSetEntity fs)throws BaseException  {
        String uuids = fs.getString(CmnConst.UUID);
        String[] uuid = uuids.split(",");
        baseDao.delete(CmnConst.APP_NOTICE_PUNISHMENT, uuid);
        return uuids;
    }

    @Override
    @Transactional
    public void addTypeSize(FieldSetEntity fs) throws BaseException {
        String tableName = fs.getTableName();
        DataTableEntity dataTableEntity = baseDao.listTable("SELECT IFNULL(MAX(no02),0) no02 FROM "+tableName, new String[]{});
        String no02 = String.valueOf(Integer.parseInt(dataTableEntity.getFieldSetEntity(0).getString("no02")) + 1);
        while (no02.length() < 3){
            no02 = "0" + no02;
        }
        fs.setValue("no02",no02);
        baseDao.update(fs);
    }
}