import com.groupstp.datasupplier.data.BankData
import com.groupstp.datasupplier.service.BankDataSupplierService
import com.groupstp.rtneo.entity.*
import org.apache.commons.collections4.CollectionUtils
import java.math.RoundingMode;
import java.text.DecimalFormat;
import java.text.DecimalFormatSymbols;
import com.github.declinationofnames.*
import com.haulmont.cuba.core.global.*;
import com.groupstp.rtneo.core.bean.calculation.CalculationWorkerHelper
import com.groupstp.rtneo.service.AccrualService
import com.groupstp.rtneo.data.ContainerYardSearchData
import com.groupstp.rtneo.core.bean.ContainerYardWorker
import org.apache.commons.lang.StringUtils
import com.groupstp.rtneo.service.CompanyService
import com.haulmont.cuba.core.app.*;
import com.haulmont.cuba.core.entity.EntitySnapshot;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
ViewRepository vRep = AppBeans.get(ViewRepository.NAME)
//def contract = dataManager.reload(params['contract'],'contract-print')
def r1 = "d3f1c53b-6db5-4616-cefd-77549f4b6083"
def params = [:]
def contract = dataManager.load(Contract.class).id(UUID.fromString(r1)).view('contract-print').optional().orElse(null)
DateFormat df = new SimpleDateFormat("dd.MM.yyyy");
def (String startFrom, String endBefore) = getStartEndDate(contract, df)
Contragent contragent = contract.getContragent()
LinkedHashMap<String, Object> props = getRequisites(contract, params, df, startFrom, contragent)
//позиции по договору
def units = [];
def realEstates = [];
def calculations = [];
//контейнерные площадки
def containers = [];
def containersUnique = [];
//
def accrualsGroup = new TreeMap<>();
//a.kotvinskiy /--
//Объемы арендаторов за которые оплачивает арендодатель
def rentersGroup = new TreeMap<>();
View creView = vRep.getView(ContragentRealEstate.class, "_local");
creView.addProperty("contragent", vRep.getView(Contragent.class, "_local"));
creView.addProperty("ownType");
//a.kotvinskiy --/
//заполняем позиции
def n = 0
int startCount = 1
for (ContractPosition position: contract.getPositions()){
//a.kotvinskiy /--
//Оплата арендодателем
def isPayLandlord = false;
def isOwner = false;
def isCnC = false;
def isFact = false
//////////////////////
(isFact, isCnC, isPayLandlord, isOwner) = setPositionMark(position, creView, contragent)
//a.kotvinskiy --/
if (CollectionUtils.isEmpty(position.getAccruals()) && !isFact) {
continue
}
realEstateNums = ""
realEstatePos = [:]
calculation = [:]
//бегаем по начислениям
BigDecimal totalVolumePosition = 0
//a.kotvinskiy /--
BigDecimal tariff = 0
BigDecimal amountBaseRent = 0;
//a.kotvinskiy --/
for (Accrual accrual: position.getAccruals()){
tariffNoNDS = round(getNN(accrual.getPrice())*5/6);
totalVolumePosition+=getNN(accrual.getAmountBase())
amountBaseRent += isCnC && isPayLandlord?getNN(accrual.getAmountBase()):BigDecimal.ZERO
createAccrualsGroup(accrualsGroup, accrual, isCnC, isPayLandlord)
if(isCnC && isPayLandlord){
fillRentersGroup(accrual, rentersGroup)
}
}
(n, realEstateNums) = fillRealEstatesWP(position, n, realEstateNums, isCnC, realEstates, containersUnique, isFact, containers, startFrom, endBefore)
if (!isCnC && position.getWasteProject() == null){
++n
List<ContractPositionContainerYard> cpcyHistory = getHistoryCY(contragent, position)
if(cpcyHistory.size()==0){
def pos = createContainerItem(position, startCount++, df.format(position.getContract().getFrom()), df.format(position.getContract().getBefore()))
realEstates.push(pos)
}else{
List<HashMap<String, Object>> itemsCY = getHistoryPrintItemsCY(cpcyHistory, startCount++)
for(def item : itemsCY){
realEstates.push(item)
}
}
////////////////////////////////////////////////////////////
//Добавляем в список объектов через запятую realEstates
if (realEstateNums.length()>0){
realEstateNums+=','
}
realEstateNums+=n
}
if(!isCnC){
//// getCalculation(position, calculation, df, totalVolumePosition, accrualsGroup, contract, realEstateNums, isFact)
//// calculations.push(calculation)
// def calculationHistory = getCalculationHistory(contragent, position, df, accrualsGroup, contract, realEstateNums, isFact, n)
// for(def item : calculationHistory){
// calculations.push(item)
// }
if(!isCnC){
// if(position.getContract().getIsFactCalculation() != null && position.getContract().getIsFactCalculation()){
if(true){
def calculationHistory = getCalculationHistory(contragent, position, df, accrualsGroup, contract, realEstateNums, isFact, n)
for(def item : calculationHistory){
calculations.push(item)
}
}else{
getCalculation(position, calculation, df, totalVolumePosition, accrualsGroup, contract, realEstateNums, isFact)
calculations.push(calculation)
}
}
}
}
List renters = getRenters(rentersGroup)
//рассчет итогов
BigDecimal amountBaseAll = 0
//for (ContractPosition position: contract.getPositions()){
// amountBaseAll += position.getVolumeYear()
//}
BigDecimal amountBase = 0
BigDecimal amountBaseNoRent = 0
BigDecimal amountBaseRent = 0
BigDecimal totalSumBaseNoNds = 0
BigDecimal totalSumBase = 0
BigDecimal discount = 0
BigDecimal totalSum = 0
def accruals = []
for (item in accrualsGroup){
amountBase+=item.getValue()['amountBase']
amountBaseNoRent+=item.getValue()['amountBaseNoRent']
amountBaseRent+=item.getValue()['amountBaseRent']
totalSumBaseNoNds = totalSumBaseNoNds + item.getValue()['totalSumBaseNoNds'].setScale(2, RoundingMode.HALF_UP)
totalSumBase = totalSumBase + item.getValue()['totalSumBase'].setScale(2, RoundingMode.HALF_UP)
discount = discount + item.getValue()['discount'].setScale(2, RoundingMode.HALF_UP)
totalSum = totalSum + item.getValue()['totalSum'].setScale(2, RoundingMode.HALF_UP)
LinkedHashMap<String, Object> accrual = createAccrual(item)
accruals.push(accrual)
}
//массив итогов
def totals = [
//a.kotvinskiy /--
//'amountBaseAll' : getNumber(amountBaseAll, false),
//'amountBase' : getNumber(amountBase, false),
'amountBase' : getFormatNum(amountBase, 5),
'amountBaseNoRent' : getFormatNum(amountBaseNoRent, 5),
'amountBaseRent' : getFormatNum(amountBaseRent, 5),
//a.kotvinskiy --/
'totalSumBaseNoNds' : getNumber(totalSumBaseNoNds),
'totalSumBase' : getNumber(totalSumBase),
'discount' : getNumber(discount),
'totalSum' : getNumber(totalSum)
]
return [['props':props,'realEstates': realEstates, 'calculations': calculations, 'totals':totals, 'containers': containers, 'accruals': accruals, 'renters': renters]]
private List getStartEndDate(contract, SimpleDateFormat df) {
Calendar cal = Calendar.getInstance();
cal.setTime(contract.getFrom());
cal.set(Calendar.DAY_OF_MONTH, cal.getActualMinimum(Calendar.DAY_OF_MONTH));
def startFrom = df.format(cal.getTime())
cal.setTime(contract.getBefore());
cal.set(Calendar.DAY_OF_MONTH, cal.getActualMaximum(Calendar.DAY_OF_MONTH));
def endBefore = df.format(cal.getTime())
[startFrom, endBefore]
}
private List fillRealEstatesWP(ContractPosition position, int n, String realEstateNums, boolean isCnC, List realEstates, List containersUnique, boolean isFact, List containers, String startFrom, String endBefore) {
def realEstatesWasteProject = [];
//бегаем по площадкам
if (position.getContainerYards() != null) {
//заполняем массив КП
for (ContractPositionContainerYard contractPositionContainerYard : position.getContainerYards()) {
containerYard = contractPositionContainerYard.getContainerYard()
// realEstatePos['containerYardNumber'] = containerYard.getCode();
//выдираем из проекта лимитов ОН
if (position.getWasteProject() != null) {
realEstateP = [:]
realEstateP['realEstateName'] = contractPositionContainerYard.getContragentRealEstate().getRealEstate().getName()
realEstateP['cadastralNumber'] = contractPositionContainerYard.getContragentRealEstate().getRealEstate().getCadastralNumber()
realEstateP['address'] = contractPositionContainerYard.getContragentRealEstate().getRealEstate().getAddress()
realEstateP['containerYardNumber'] = containerYard.getCode();
realEstateP['n'] = ++n
if (realEstateNums.length() > 0) {
realEstateNums += ','
}
realEstateNums += realEstateP['n']
realEstatesWasteProject.add(contractPositionContainerYard.getContragentRealEstate().getId())
if (!isCnC) realEstates.push(realEstateP)
}
if (containersUnique.indexOf(containerYard.getId()) < 0) {
containersUnique.push(containerYard.getId())
getContainers(containerYard, isFact, containers, startFrom, endBefore)
}
}
}
//добираем объекты недвижимости из ПЛООНР, для которых не найдены КП
if (position.getWasteProject() != null) {
for (ContragentRealEstate cre : position.getWasteProject().getRealEstates()) {
cre = dataManager.reload(cre, "contragentRealEstate-categorization")
if (realEstatesWasteProject.indexOf(cre.getId()) >= 0) {
continue;
}
realEstateP = [:]
realEstateP['realEstateName'] = cre.getRealEstate().getName()
realEstateP['cadastralNumber'] = cre.getRealEstate().getCadastralNumber()
realEstateP['address'] = cre.getRealEstate().getAddress()
realEstateP['n'] = ++n
if (realEstateNums.length() > 0) {
realEstateNums += ','
}
realEstateNums += realEstateP['n']
realEstates.push(realEstateP)
}
}
[n, realEstateNums]
}
private List setPositionMark(ContractPosition position, View creView, Contragent contragent) {
def isPayLandlord = false;
def isOwner = false;
def isCnC = false;
def isFact = false
//Проверяем на null
if (position.getContragentRealEstate() != null && !position.getContragentRealEstate().isDeleted()) {
def rentCre = position.getContragentRealEstate();
rentCre = dataManager.reload(rentCre, creView);
//Арендатор или собственник
if (rentCre.getOwnType().equals(TypeOwnership.RENT)) {
isOwner = true;
}
//Если за объект оплачивает арендодатель
if (isOwner & isPayLandLord(position.getContragentRealEstate())) {
isPayLandlord = true;
}
//Если позиция создалась с объектом арендодателя
if (isOwner && !contragent.getId().equals(rentCre.getContragent().getId())) {
isCnC = true;
}
}
isFact = dataManager.loadValue('select cp.isFactCalculation from rtneo$ContractPosition cp where cp.id = :id', Boolean.class).parameter("id", position.getId()).optional().orElse(false);
[isFact, isCnC, isPayLandlord, isOwner]
}
private LinkedHashMap<String, Object> createAccrual(Map.Entry<Object, Object> item) {
return [
'period' : item.getValue()['period'],
'tariff' : getNumber(item.getValue()['tariff']),
//a.kotvinskiy /--
//'amountBase': getNumber(item.getValue()['amountBase'], false),
'amountBase' : getFormatNum(item.getValue()['amountBase'], 5),
'amountBaseNoRent' : getFormatNum(item.getValue()['amountBaseNoRent'], 5),
'amountBaseRent' : getFormatNum(item.getValue()['amountBaseRent'], 5),
//a.kotvinskiy --/
'totalSumBaseNoNds': getNumber(item.getValue()['totalSumBaseNoNds']),
'totalSumBase' : getNumber(item.getValue()['totalSumBase']),
'discount' : getNumber(item.getValue()['discount']),
'totalSum' : getNumber(item.getValue()['totalSum'])
]
}
private void getCalculation(ContractPosition position, LinkedHashMap<Object, Object> calculation, SimpleDateFormat df, BigDecimal totalVolumePosition, TreeMap<Object, Object> accrualsGroup, contract, String realEstateNums, isFact) {
if (position.getCategory() != null) {
calculation['unitName'] = position.getUnit().getName()
}
if (position.getNorm() != null) {
calculation['norm'] = getFormatNum(position.getNorm(), 4)
}
if (position.getWasteProject() != null) {
calculation['unitName'] = "ПНООЛР с ${position.getWasteProject().getValidityFrom() == null ? '--' : df.format(position.getWasteProject().getValidityFrom())} по ${position.getWasteProject().getValidityTo() == null ? '--' : df.format(position.getWasteProject().getValidityTo())}"
}
calculation['amount'] = getFormatNum(totalVolumePosition, 5);
//Нужен среднее кол-во р/е по позиции, или объем деленый на норматив
//Вычисляем актуальное начисление на в зависимости от даты договора
// def nMouth = accrualsGroup.size() == 12 ? contract.getDate().getMonth()-1 : 0
def nMouth = accrualsGroup.size() - (12 - contract.getDate().getMonth())
// if(accrualsGroup.values()[nMouth]) calculation['calculationAmount'] = getFormatNum(accrualsGroup.values()[nMouth]['calculationAmount'], 5)
def calculationAmount = 0
if (position.getCalculationAmount() == null || position.getCalculationAmount() == 0) {
if (position.getContragentRealEstate() == null) {
calculationAmount = "--"
} else {
calculationAmount = getFormatNum(dataManager.reload(position.getContragentRealEstate(), "_local").getCalculationAmount(), 5)
}
} else {
calculationAmount = getFormatNum(position.getCalculationAmount(), 5)
}
calculation['calculationAmount'] = calculationAmount
if (position.getNorm() == null)
calculation['calculationAmountPay'] = getFormatNum(accrualsGroup.values()[nMouth]['calculationAmount'], 5);
else
calculation['calculationAmountPay'] = position.getNorm() == 0 ? BigDecimal.ZERO : getFormatNum(totalVolumePosition / new BigDecimal(position.getNorm()), 3);
if (position.getContragentRealEstate() == null) calculation['calculationAmountPay'] = "--"
//a.kotvinskiy --/
calculation['n'] = realEstateNums
if (isFact) {
calculation['unitName'] = 'Вывоз по факту'
calculation['norm'] = '--'
calculation['amount'] = '--'
calculation['calculationAmount'] = '--'
}
}
private def getCalculationHistory(Contragent contragent, ContractPosition cp, SimpleDateFormat df, TreeMap<Object, Object> accrualsGroup, Contract contract, String realEstateNums, isFact, num){
List<ContractPosition> cpHistoryList = getHistoryCP(contragent, cp);
def calculationList = []
def prevAmount = 0.0
def prevN = null
def prevFrom = null
for(ContractPosition position : cpHistoryList){
def calculation = [:]
BigDecimal totalVolumePosition = 0.0
if(position.getAccruals().size()>0){
for(Accrual accrual : position.getAccruals()){
totalVolumePosition=getNN(accrual.getAmountBase())
// break
}
}
if(prevFrom.equals(position.getContract().getFrom())){
if(calculationList.size()>0)num = calculationList.get(calculationList.size()-1)["n"]
calculationList.remove(calculationList.size()-1)
prevAmount = null
}
if(prevAmount.equals(totalVolumePosition)){
continue
}else{
prevAmount = totalVolumePosition
}
if (position.getCategory() != null) {
calculation['unitName'] = position.getUnit().getName()
}
if (position.getNorm() != null) {
calculation['norm'] = getFormatNum(position.getNorm(), 4)
}
if (position.getWasteProject() != null) {
calculation['unitName'] = "ПНООЛР с ${position.getWasteProject().getValidityFrom() == null ? '--' : df.format(position.getWasteProject().getValidityFrom())} по ${position.getWasteProject().getValidityTo() == null ? '--' : df.format(position.getWasteProject().getValidityTo())}"
}
calculation['amount'] = getFormatNum(totalVolumePosition, 5);//???????????????????????????????
//Нужен среднее кол-во р/е по позиции, или объем деленый на норматив
//Вычисляем актуальное начисление на в зависимости от даты договора
// def nMouth = accrualsGroup.size() == 12 ? contract.getDate().getMonth()-1 : 0
def nMouth = accrualsGroup.size() - (12 - contract.getDate().getMonth())
// if(accrualsGroup.values()[nMouth]) calculation['calculationAmount'] = getFormatNum(accrualsGroup.values()[nMouth]['calculationAmount'], 5)
def calculationAmount = 0
if (position.getCalculationAmount() == null || position.getCalculationAmount() == 0) {
if (position.getContragentRealEstate() == null) {
calculationAmount = "--"
} else {
calculationAmount = getFormatNum(dataManager.reload(position.getContragentRealEstate(), "_local").getCalculationAmount(), 5)
}
} else {
calculationAmount = getFormatNum(position.getCalculationAmount(), 5)
}
calculation['calculationAmount'] = calculationAmount
if (position.getNorm() == null)
calculation['calculationAmountPay'] = getFormatNum(accrualsGroup.values()[nMouth]['calculationAmount'], 5);
else
calculation['calculationAmountPay'] = position.getNorm() == 0 ? BigDecimal.ZERO : getFormatNum(totalVolumePosition / new BigDecimal(position.getNorm()), 3);
if (position.getContragentRealEstate() == null) calculation['calculationAmountPay'] = "--"
//a.kotvinskiy --/
calculation['n'] = num
num +=+0.1
if (position.getIsFactCalculation()) {
calculation['unitName'] = 'Вывоз по факту'
calculation['norm'] = '--'
calculation['amount'] = '--'
calculation['calculationAmount'] = '--'
}
calculationList.push(calculation);
prevN = num
prevFrom = position.getContract().getFrom()
}
return calculationList
}
private void fillRentersGroup(Accrual accrual, TreeMap<Object, Object> rentersGroup) {
def rentCategory = dataManager.load(RealEstateCategory.class)
.query('select a.category from rtneo$Accrual a where a.id=:id')
.parameter('id', accrual.getId())
.view('_local')
.optional()
.orElse(null);
if (rentersGroup[rentCategory.getName()] == null) {
rentersGroup[rentCategory.getName()] = [
'rentCategory': rentCategory.getName(),
'rentArea' : accrual.getCalculationAmount(),
'rentNorm' : rentCategory.getNorm(),
'rentAmount' : accrual.getAmountBase()];
} else {
rentersGroup[rentCategory.getName()]['rentArea'] += accrual.getCalculationAmount();
rentersGroup[rentCategory.getName()]['rentAmount'] += accrual.getAmountBase();
}
}
private LinkedHashMap<String, Object> getRequisites(Contract contract, HashMap<Object, Object> params, SimpleDateFormat df, String startFrom, Contragent contragent) {
def companyService = AppBeans.get(CompanyService.NAME)
def bankDataService = AppBeans.get(BankDataSupplierService.NAME)
//Получаем реквизиты компании, действующие на момент даты договора
def company = contract.getCompany()
def companyRequisites = companyService.getCompanyRequisites(company, contract.getDate())
def companyManagerNameR = companyRequisites.getManagerName()
try {
companyManagerNameR = new RussianName(companyManagerNameR).fullName(RussianNameProcessor.gcaseRod)
} catch (e) {
}
//заполняем шапку
//документ-основание
contragentPersonReasonText = ', действующего на основании '
if (contragent.getType() == ContragentType.PERSONAL) {
contragentPersonReasonText = ''
}
contragentPersonReasonDoc = params['personReason']
if (contragentPersonReasonDoc == null) {
contragentPersonReasonDoc = contragent.getHeadPersonReasonDoc()
}
contragentPersonReasonDocR = contragentPersonReasonDoc
try {
contragentPersonReasonDocR = new RussianName(contragentPersonReasonDoc).fullName(RussianNameProcessor.gcaseRod)
} catch (e) {
}
if (contragentPersonReasonDocR == null) {
if (getContragentType(contragent) == ContragentType.ORGANISATION) {
contragentPersonReasonDocR = "устава"
} else if (getContragentType(contragent) == ContragentType.INDIVIDUAL) {
contragentPersonReasonDocR = "свидетельства / выписки о государственной регистрации в качестве индивидуального предпринимателя"
}
}
//подписант
contragentPersonName = params['personName']
if (contragentPersonName == null) {
contragentPersonName = contragent.getHeadPersonName()
if (contragent.getType() == ContragentType.PERSONAL) {
contragentPersonName = contragent.getName()
}
}
contragentPersonNameR = contragentPersonName
try {
contragentPersonNameR = new RussianName(contragentPersonName).fullName(RussianNameProcessor.gcaseRod)
} catch (e) {
}
//должность подписанта
contragentPersonPost = params['personPost']
if (contragentPersonPost == null) {
contragentPersonPost = contragent.getHeadPersonPost()
}
contragentPersonPostR = contragentPersonPost
try {
contragentPersonPostR = new RussianName(contragentPersonPost).fullName(RussianNameProcessor.gcaseRod)
} catch (e) {
}
//массив шапочных параметров
def props = [
'number' : contract.getNumber(),
'date' : getTextDate(contract.getDate()),
//a.kotvinskiy /--
'dateFromTKO' : df.format(contract.getFrom()),
'dateBeforeTKO' : df.format(contract.getBefore()),
//a.kotvinskiy --/
'contragentName' : contragent.getName(),
'contragentNameShort' : contragent.getShortName(),
'contragentPersonName' : contragentPersonName,
'contragentPersonNameR' : contragentPersonNameR,
'contragentPersonNameShort' : getShortFio(contragentPersonName),
'contragentPersonPost' : contragentPersonPost,
'contragentPersonPostR' : contragentPersonPostR,
'contragentPersonReasonDoc' : contragentPersonReasonDoc,
'contragentPersonReasonDocR' : contragentPersonReasonDocR,
'contragentPersonReasonText' : contragentPersonReasonText,
'contragentShortName' : contragent.getShortName(),
'legalAddress' : contragent.getLegalAddress(),
'actualAddress' : contragent.getActualAddress(),
'mailingAddress' : contragent.getMailingAddress(),
'registrationAddrees' : contragent.getRegistrationAddress(),
'passportSeries' : contragent.getPassportSeries(),
'passportNumber' : contragent.getPassportNumber(),
'passportGivenDate' : contragent.getPassportGivenDate(),
'inn' : contragent.getInn(),
'kpp' : contragent.getKpp(),
'ogrn' : contragent.getOgrn(),
'checkingAccount' : contragent.getCheckingAccount(),
'bankName' : contragent.getBankName(),
'correspondentAccount' : contragent.getCorrespondentAccount(),
'bik' : contragent.getBik()
, 'companyShortName' : company.shortName
, 'companyFullName' : company.fullName
, 'companyInn' : company.inn
, 'companyEmail' : company.email
, 'companyOgrn' : company.ogrn
, 'companyPhone' : company.phone
, 'companyLegalAddress' : companyRequisites.legalAddress
, 'companyActualAddress' : companyRequisites.actualAddress
, 'companyPostalAddress' : companyRequisites.postalAddress
, 'companyKpp' : companyRequisites.kpp
, 'companyBankName' : companyRequisites.bankName
, 'companyBankAccount' : companyRequisites.bankAccount
, 'companyCorrespondentAccount': companyRequisites.correspondentAccount
, 'companyRcbic' : companyRequisites.rcbic
, 'companyManagerTitle' : companyRequisites.managerTitle
, 'companyManagerTitleR' : companyRequisites.managerTitleR
, 'companyManagerName' : companyRequisites.managerName
, 'companyManagerNameR' : companyManagerNameR
, 'companyManagerNameShort' : getShortFio(companyRequisites.managerName)
, 'companyManagerDocumentR' : getShortFio(companyRequisites.managerDocumentR),
'startFrom' : startFrom
]
if (!StringUtils.isBlank(props['bik']) && (StringUtils.isBlank(props['bankName']) || StringUtils.isBlank(props['correspondentAccount']))) {
BankData bank = bankDataService.getSuggestionBankDetails(props['bik'])
if (bank != null) {
if (StringUtils.isBlank(props['bankName'])) {
props['bankName'] = bank.getName()
}
if (StringUtils.isBlank(props['correspondentAccount'])) {
props['correspondentAccount'] = bank.getCorrespondentAccount()
}
}
}
//телефон + почта
def phone = ''
if (contragent.getHeadPersonPhone() != null) {
phone = contragent.getHeadPersonPhone()
} else if (contragent.getContactPersonPhone() != null) {
phone = contragent.getContactPersonPhone()
}
def email = ''
if (contragent.getHeadPersonEmail() != null) {
email = contragent.getHeadPersonEmail()
} else if (contragent.getContactPersonEmail() != null) {
email = contragent.getContactPersonEmail()
}
props['phone'] = phone
props['email'] = email
//a.kotvinskiy 19-07-19/--
//В пункте 3 доп соглашения, указываем начало действия доп соглашения
props['dateFrom'] = getTextDate(contract.getFrom())
//a.kotvinskiy 19-07-19--/
//получаем номер и дату головного договора
if (contract.getMainContract() != null) {
props['mainContractNumber'] = contract.getMainContract().getNumber()
props['mainContractDate'] = getTextDate(contract.getMainContract().getDate())
}
//вычисляем подписантов и юридический адрес
def defaultDate = new Date().copyWith(year: 2019, month: Calendar.JANUARY, dayOfMonth: 17, hourOfDay: 0, minute: 0, second: 0);
def addressChangeDate = new Date().copyWith(year: 2019, month: Calendar.APRIL, dayOfMonth: 26, hourOfDay: 0, minute: 0, second: 0);
def contractDate = contract.getDate()
props['ourPersonPost'] = "Заместитель генерального директора по коммерческой работе"
props['ourPersonPostR'] = "Заместителя генерального директора по коммерческой работе"
props['ourPersonName'] = "Степанова Татьяна Анатольевна"
props['ourPersonNameR'] = "Степановой Татьяны Анатольевны"
props['ourPersonReasonDoc'] = "доверенность № РТ-05 от 11.01.2019 г"
props['ourPersonReasonDocR'] = "доверенности № РТ-05 от 11.01.2019 г"
props['ourPersonNameShort'] = "Степанова Т.А."
if (contractDate < addressChangeDate) {
props['ourLegalAddress'] = '308000, Белгородская область, город Белгород, проспект Б. Хмельницкого, дом 131, помещение 15'
props['ourKpp'] = '312301001'
} else {
props['ourLegalAddress'] = '664033, Иркутская область, город Иркутск, улица Лермонтова, дом 337Б, помещение 8'
props['ourKpp'] = '381201001'
}
return props
}
private void createAccrualsGroup(TreeMap<Object, Object> accrualsGroup, Accrual accrual, boolean isCnC, boolean isPayLandlord) {
if (accrualsGroup[accrual.getPeriod()] == null) {
accrualsGroup[accrual.getPeriod()] = [
'period' : getTextPeriod(accrual.getPeriod()),
'tariff' : round(getNN(accrual.getPrice()) * 5 / 6),
'amountBase' : !isCnC && isPayLandlord ? BigDecimal.ZERO : getNN(accrual.getAmountBase()),
'amountBaseNoRent' : !isCnC ? getNN(accrual.getAmountBase()) : BigDecimal.ZERO,
'amountBaseRent' : isCnC && isPayLandlord ? getNN(accrual.getAmountBase()) : BigDecimal.ZERO,
//a.kotvinskiy /--
'totalSumBaseNoNds': (getNN(accrual.getTotalSumBase()) - getNN(accrual.getNdsSumBase())),
//'totalSumBaseNoNds': (getNN(accrual.getAmountBase())*getNN(tariffNoNDS)),
//a.kotvinskiy --/
'totalSumBase' : getNN(accrual.getTotalSumBase()),
'discount' : getNN(accrual.getTotalSumBase()) - getNN(accrual.getTotalSum()),
'totalSum' : getNN(accrual.getTotalSum()),
'calculationAmount': getNN(accrual.getCalculationAmount())]
} else {
accrualsGroup[accrual.getPeriod()]['amountBase'] += !isCnC && isPayLandlord ? BigDecimal.ZERO : getNN(accrual.getAmountBase());
accrualsGroup[accrual.getPeriod()]['amountBaseNoRent'] += !isCnC ? getNN(accrual.getAmountBase()) : BigDecimal.ZERO;
accrualsGroup[accrual.getPeriod()]['amountBaseRent'] += isCnC && isPayLandlord ? getNN(accrual.getAmountBase()) : BigDecimal.ZERO;
//a.kotvinskiy /--
accrualsGroup[accrual.getPeriod()]['totalSumBaseNoNds'] += (getNN(accrual.getTotalSumBase()) - getNN(accrual.getNdsSumBase()));
//accrualsGroup[accrual.getPeriod()]['totalSumBaseNoNds']+=(getNN(accrual.getAmountBase())*getNN(tariffNoNDS));
//a.kotvinskiy --/
accrualsGroup[accrual.getPeriod()]['totalSumBase'] += getNN(accrual.getTotalSumBase());
accrualsGroup[accrual.getPeriod()]['discount'] += (getNN(accrual.getTotalSumBase()) - getNN(accrual.getTotalSum()));
accrualsGroup[accrual.getPeriod()]['totalSum'] += getNN(accrual.getTotalSum());
accrualsGroup[accrual.getPeriod()]['calculationAmount'] = getNN(accrual.getCalculationAmount());
}
}
private void getContainers(containerYard, isFact, List containers, String startFrom, String endBefore) {
def containerWasteBuff = [:]
for (ContainerWaste container : containerYard.getContainers()) {
String type = container.getType()?.getName() == null ? '' : container.getType().getName()
String volume = container.getType()?.getVolume() == null ? '' : getNumber(container.getType().getVolume(), false)
volume = volume.replaceAll(',', '.')
Integer count = container.getCount() == null ? 0 : container.getCount();
String typeVal = type + volume
String key = containerYard.getCode()
String typeExport = isFact ? 'Исходя из количества и объема контейнеров' : 'Исходя из нормативов накопления'
def current = []
Map previous = containerWasteBuff[key]
// if (previous == null) {
current = [
'n' : containers.size() + 1,
'code' : containerYard.getCode(),
'startFrom' : startFrom,
'endBefore' : endBefore,
'address' : containerYard.getAddress(),
'longitude' : containerYard.getLongitude(),
'latitude' : containerYard.getLatitude(),
'typeExport': typeExport,
'owner' : containerYard.getOwner(),
'type' : type,
'volume' : volume,
'count' : count,
'typeWaste' : ((volume != '') && (new BigDecimal(volume) < 5.0)) ? 'ТКО' : 'КГО'
]
// log.debug(previous['code'])
if (containerWasteBuff[key] != null) {
// if(current['n'] == )
current['n'] = ''
current['code'] = ''
current['startFrom'] = ''
current['endBefore'] = ''
current['address'] = ''
current['longitude'] = ''
current['latitude'] = ''
current['owner'] = ''
}
containers.push(current)
containerWasteBuff[key] = current
}
}
private List getRenters(TreeMap<Object, Object> rentersGroup) {
def renters = []
for (item in rentersGroup) {
def renter = [
'rentCategory': item.getValue()['rentCategory'],
'rentArea' : item.getValue()['rentArea'] / 12,
'rentNorm' : item.getValue()['rentNorm'],
'rentAmount' : item.getValue()['rentAmount'],
]
renters.push(renter)
}
renters
}
//получить дату словами
def getTextDate(Date date) {
def result=''
def monthesRP = ['января','февраля','марта','апреля','мая','июня','июля','августа','сентября','октября','ноября','декабря']
Calendar cal = Calendar.getInstance()
cal.setTime(date);
result = cal.get(Calendar.DAY_OF_MONTH).toString()
result+=" "+monthesRP[cal.get(Calendar.MONTH)]
result+=" "+cal.get(Calendar.YEAR).toString()+" г."
return result
}
//получить период словами
def getTextPeriod(Date date) {
def result=''
def monthesRP = ['январь','февраль','март','апрель','май','июнь','июль','август','сентябрь','октябрь','ноябрь','декабрь']
Calendar cal = Calendar.getInstance()
cal.setTime(date);
result+=monthesRP[cal.get(Calendar.MONTH)]
result+=" "+cal.get(Calendar.YEAR).toString()+" г."
return result
}
//форматирование чисел
def getNumber(BigDecimal number, boolean money = true, boolean scale = false) {
if (number == null) {
return "-"
}
DecimalFormatSymbols symbols = DecimalFormatSymbols.getInstance()
symbols.setGroupingSeparator((char) ' ')
symbols.setDecimalSeparator((char) ',')
if (money){
DecimalFormat formatter = new DecimalFormat('###,###.00', symbols)
String result = formatter.format(number);
return result.startsWith(",") ? "0" + result : result;
} else {
//Временное решение чтобы, вывести норматив. 4 знака после запятой
if(scale){
DecimalFormat formatter = new DecimalFormat('###,###.####', symbols)
return formatter.format(number);
}else{
DecimalFormat formatter = new DecimalFormat('###,###.###', symbols)
return formatter.format(number);
}
}
}
//a.kotvinskiy /--
//Временное решение, по формату отображения нулей после запятой
def getFormatNum(BigDecimal number, int s, boolean money = false){
if (number == null) {
return "-"
}
String formatString = '';
DecimalFormatSymbols symbols = DecimalFormatSymbols.getInstance()
symbols.setGroupingSeparator((char) ' ')
symbols.setDecimalSeparator((char) ',')
switch(s){
case 1:
formatString = '###,###,###.#';
break;
case 2:
formatString = '###,###,###.##';
break;
case 3:
formatString = '###,###,###.###';
break;
case 4:
formatString = '###,###,###.####';
break;
case 5:
formatString = '###,###,###.######';
break;
}
DecimalFormat formatter = new DecimalFormat(formatString, symbols);
String result = formatter.format(number);
return result.startsWith(",") ? "0" + result : result;
}
//a.kotvinskiy --/
def getShortFio(String fio) {
if (fio == null) return ""
String pattern = '(\\S+\\s)(\\S{1})\\S+\\s(\\S{1})\\S+'
String str = fio.replaceAll(pattern, '$1$2.$3.')
return str
}
def round(BigDecimal sum){
return sum == null ? BigDecimal.ZERO : sum.setScale(2, RoundingMode.HALF_UP);
}
def getContragentType(Contragent contragent) {
String name = contragent.getName();
if (name == null){
name = contragent.getShortName();
}
String inn = contragent.getInn();
ContragentType type = contragent.getType();
if (!StringUtils.isEmpty(name)) {
name = name.toLowerCase().trim();
if (name.startsWith("ип ") || name.endsWith(" ип") ||
name.contains(" ип ") ||
name.contains("инд.предп.") ||
name.contains("индивидуальный предприниматель")) {
type = ContragentType.INDIVIDUAL;
}
}
return type;
}
def getNN(BigDecimal value) {
return value == null ? BigDecimal.ZERO : value;
}
def isPayLandLord(ContragentRealEstate cre){
List<RealEstateRenter> rr = dataManager.load(RealEstateRenter)
.query('select r from rtneo$RealEstateRenter r where r.renterRecord.id = :id and r.payOwner = true')
.parameter("id", cre.getId())
.view("_local")
.list();
if(rr.size()>0)return true else return false;
}
//**************************************************************
//Получить КП для печати
//Нужно разделить(на 3. логика выбор! создание)
//**************************************************************
List<HashMap<String, Object>> getHistoryPrintItemsCY(List<ContractPositionContainerYard> cpcyHistory, Integer startCount){
SimpleDateFormat df = new SimpleDateFormat("dd.MM.yyyy")
HashMap<String, Object> cyHash = [:]
List<HashMap<String, Object>> cyItemList = []
char nChar = 'А'
def nInt = Double.valueOf(startCount)
def n = null
def prevCode = null
def prevFrom = null
def prevBefore = null
def prevCre = null
def prevCP = null
def prevN = null
char prevNChar = nChar
def prevNInt = nInt
def prevTotalVolumePosition = 0.0
if(cpcyHistory.size()==0){
def pos = createContainerItem(cpcy, n, df.format(cpcy.getContractPosition().getContract().getFrom()), df.format(cpcy.getContractPosition().getContract().getBefore()))
cyItemList.push(pos)
}
for(ContractPositionContainerYard cpcy : cpcyHistory){
def changeCY = false
def changeCre = false
//Логика выбора
if(!prevCode.equals(cpcy.getContainerYard().getCode())){
changeCY = true
}
// log.debug("${prevCre}")
// if(prevCre != null){log.debug("--${prevCre.getCalculationAmount()} ${cpcy.getContractPosition().getContragentRealEstate().getCalculationAmount()}")}
if(prevCre != null && (prevCre.getCalculationAmount() != cpcy.getContractPosition().getContragentRealEstate().getCalculationAmount())){
changeCre = true
}
BigDecimal totalVolumePosition = null
for(Accrual accrual : cpcy.getContractPosition().getAccruals()){
// log.debug(accrual)
totalVolumePosition=getNN(accrual.getAmountBase())
}
// log.debug("${prevTotalVolumePosition} -- ${totalVolumePosition}")
if(!prevTotalVolumePosition.equals(totalVolumePosition)){
changeCre = true
}
if(!prevCre.equals(cpcy.getContractPosition().getContragentRealEstate())){
changeCre = true
}
if(!changeCre && !changeCY)continue
if(prevFrom.equals(cpcy.getContractPosition().getContract().getFrom())){
cyItemList.remove(cyItemList.size()-1)
n = prevN
}else{
//Получение номера вынести в отдельный метод
if(changeCY & !changeCre){
n = nChar++
}
if(changeCre){
nChar = 'А'
if(nInt%1 == 0.0){
n = nInt
nInt +=0.1
}else{
n = nInt
nInt +=0.1
}
// nInt +=0.1
}
//
if(cyItemList.size()>0)cyItemList.get(cyItemList.size()-1)["endBefore"] = df.format(cpcy.getContractPosition().getContract().getFrom())
}
def pos = createContainerItem(cpcy, n, df.format(cpcy.getContractPosition().getContract().getFrom()), df.format(cpcy.getContractPosition().getContract().getBefore()))
cyItemList.push(pos)
//Устанавливаем предыдущие значения
prevCode = cpcy.getContainerYard().getCode()
prevFrom = cpcy.getContractPosition().getContract().getFrom()
prevBefore = cpcy.getContractPosition().getContract().getBefore()
prevCre = cpcy.getContractPosition().getContragentRealEstate()
// if(!isPrevN)prevN = n
prevN = n
prevNChar = nChar
prevNInt = nInt
prevTotalVolumePosition = totalVolumePosition
//Конец выбора
}
//log.debug(cyItemList)
return cyItemList
}
//**************************************************************
//Получить историю КП для объекта
//**************************************************************
List<ContractPositionContainerYard> getHistoryCY(Contragent contragent, ContractPosition contractPosition){
List<ContractPosition> cpList = getHistoryCP(contragent, contractPosition)
List<ContractPositionContainerYard> cpcyList = []
for(ContractPosition cp : cpList){
for(ContractPositionContainerYard cpcy : cp.getContainerYards()){
cpcyList.push(cpcy)
}
}
return cpcyList
}
//**************************************************************
//Получить историю позиции договора
//**************************************************************
List<ContractPosition> getHistoryCP(Contragent contragent, ContractPosition cp){
DataManager dataManager = AppBeans.get(DataManager.NAME);
EntitySnapshotService entitySnapshotService = AppBeans.get(EntitySnapshotService.NAME);
List<SnapshotHistory> listSnapshotHistory = null
// if(cp.getContract().getIsFactCalculation() != null && cp.getContract().getIsFactCalculation()){
if(true){
listSnapshotHistory = dataManager.load(SnapshotHistory.class)
.query('select s from rtneo$SnapshotHistory s where s.contragent.id = :contragent and s.contract.accepted = true or s.contract.id = :contractId order by s.contract.createTs asc')
.parameter("contragent", contragent.getId())
.parameter("contractId", cp.getContract().getId())
.view("_local")
.list();
}else{
listSnapshotHistory = dataManager.load(SnapshotHistory.class)
.query('select s from rtneo$SnapshotHistory s where s.contract.id = :contractId')
.parameter("contractId", cp.getContract().getId())
.view("_local")
.list();
}
List<ContractPosition> cpList = []
for(def snapshotHistory : listSnapshotHistory){
def entitySnapshot = dataManager.load(EntitySnapshot.class).id(snapshotHistory.getSnapshot()).optional().orElse(null)
Contract entity = entitySnapshotService.extractEntity(entitySnapshot)
for(ContractPosition cpItem : entity.getPositions()){
if(cp.getWasteProject() != null && cp.getWasteProject() == cpItem.getWasteProject()){
cpList.push(cpItem)
}
if(cp.getContragentRealEstate() != null && cp.getContragentRealEstate().getId() == cpItem.getContragentRealEstate().getId())
cpList.push(cpItem)
}
}
return cpList;
}
def createContainerItem(ContractPositionContainerYard cpcy, Object n, String from, String before){
SimpleDateFormat df = new SimpleDateFormat("dd.MM.yyyy")
def pos = [
realEstateName:cpcy.getContractPosition().getContragentRealEstate().getRealEstate().getName(),
cadastralNumber:cpcy.getContractPosition().getContragentRealEstate().getRealEstate().getCadastralNumber(),
address:cpcy.getContractPosition().getContragentRealEstate().getRealEstate().getAddress(),
startFrom:from,
endBefore:before,
containerYardNumber:cpcy.getContainerYard().getCode(),
n:n
]
// log.debug(pos)
return pos
}
def createContainerItem(ContractPosition cp, Object n, String from, String before){
SimpleDateFormat df = new SimpleDateFormat("dd.MM.yyyy")
def pos = [
realEstateName:cp.getContragentRealEstate().getRealEstate().getName(),
cadastralNumber:cp.getContragentRealEstate().getRealEstate().getCadastralNumber(),
address:cp.getContragentRealEstate().getRealEstate().getAddress(),
startFrom:from,
endBefore:before,
containerYardNumber:'',
n:n
]
// log.debug(pos)
return pos
}
