MyTetra Share
Делитесь знаниями!
Backup UPD 14-01-21
Время создания: 14.01.2021 20:57
Раздел: INFO - JOB - rtneo - Работа над задачами - КорректировкаУПД
Запись: wwwlir/Tetra/master/base/1610629047k6r1zt66gy/text.html на raw.githubusercontent.com

import com.haulmont.chile.core.model.MetaClass

import com.haulmont.cuba.core.global.*;

import com.groupstp.rtneo.entity.*;

import com.haulmont.cuba.core.entity.*

import com.groupstp.rtneo.service.AccrualService

import com.groupstp.rtneo.service.CompanyService

import java.math.RoundingMode;

import java.text.DecimalFormat;

import java.text.DecimalFormatSymbols;

import java.math.MathContext;

import java.util.stream.Collectors;

//Contract qwe = dataManager.load(Contract.class).query('select e from rtneo$Contract e where e.id=:id').parameter("id",UUID.fromString('3a67362c-7103-40ea-7f0b-d0491c927268')).one()

def service = AppBeans.get(AccrualService.NAME)

def companyService = AppBeans.get(CompanyService.NAME)

//Параметры

//def params =['number':2368210]

//Результаты

def result = new LinkedHashMap()

//Переменные

def monthesRP = ['января','февраля','марта','апреля','мая','июня','июля','августа','сентября','октября','ноября','декабря']


List<Accrual> accruals = dataManager.load(Accrual)

.query('select a from rtneo$Accrual a where a.documentNumber = :documentNumber order by a.period asc')

.parameter("documentNumber", params.number)

.view('accrual-bill')

.list()

if (accruals.size() == 0) {

throw new RuntimeException(String.format("Начислений по номеру %s не найдено", params.number))

}

KeyValueEntity value = dataManager.loadValues('select a.contragent.inn, a.contragent.kpp from rtneo$Accrual a where a.documentNumber = :number')

.properties("inn", "kpp")

.parameter("number", params.number)

.optional()

.orElse(null);


String inn = value.getValue("inn");

String kpp = value.getValue("kpp");

Accrual accrual = accruals.get(0)

/**

*Заполняем шапку

*/

def head = new LinkedHashMap()

//Acts act = getActualAct(accruals, inn, kpp, accrual.getPeriod())

Acts act = null

Acts adjustmen = null

List<Acts> acts = getAllAct(inn, kpp, accrual.getPeriod())

//Нужно сделать проверку acts на пустоту

boolean isAdj = false

acts.each({if(it.getAdjustments() != null)isAdj = true})


//head['number'] = String.valueOf((int) params.number)

//str = str.replaceAll("[^0-9]+", "");


//Сумма начислений

BigDecimal accSum = BigDecimal.ZERO

accruals.each({accSum = accSum.add(it.getTotalSum())})

accSum = accSum.setScale(2, BigDecimal.ROUND_UP);

if(!isAdj){

act = acts.get(0)

actSum = act.getSum().add(act.getSum_nds());

if(!accSum.equals(actSum)){

head['number'] = act.getNumber()

head['corrNumber'] = String.valueOf((int) params.number)

}

}else{

onlyActs = acts.stream().filter({e->e.getAdjustments() == null}).collect(Collectors.toList())

adjustmens = acts.stream().filter({e->e.getAdjustments() != null}).collect(Collectors.toList())

adjustmen = adjustmens.get(adjustmens.size()-1)

act = acts.get(0)

adjustmenSum = adjustmen.getSum().add(adjustmen.getSum_nds());

// if(accSum.equals(adjustmenSum)){

if(accSum.subtract(adjustmenSum).compareTo(BigDecimal.valueOf(0.02)) <=0 || accSum.subtract(adjustmenSum).compareTo(BigDecimal.valueOf(-0.02)) >=0){

head['number'] = act.getNumber()

head['corrNumber'] = adjustmen.getNumber().replaceAll("[^0-9]+", "")

}else{

head['number'] = adjustmen.getNumber().replaceAll("[^0-9]+", "")

head['corrNumber'] = String.valueOf((int) params.number)

act = adjustmen

adjustmen = null

}

}


//if(act.getAdjustments() == null){

// //Сумма начислений

// BigDecimal accSum = BigDecimal.ZERO

// accruals.each({accSum = accSum.add(it.getTotalSum())})

// accSum = accSum.setScale(2, BigDecimal.ROUND_UP);

//

// def actSum = act.getSum().add(act.getSum_nds());

//

// if(accSum.equals(actSum)){

//

// }

// head['number'] = act.getNumber()

// head['corrNumber'] = String.valueOf((int) params.number)

//}

//if(act.getAdjustments() != null){

// Acts selling = getActualAct(accruals, inn, kpp, accrual.getPeriod(), true)

// head['number'] = act.getNumber()

// head['corrNumber'] = selling.getNumber().replaceAll("[^0-9]+", "")

//}



//if(act.getAdjustments() == null && act.getSum != accrusls.getSum)

//

//

//head['number'] = String.valueOf((int) params.number)

//head['corrNumber'] = act.getNumber().replaceAll("[^0-9]+", "")


//a.kotvinskiy /--

//head['billDate'] = getTextDate(accrual.getDocumentDate() == null ? accrual.getCreateTs() : accrual.getDocumentDate())


//Берем период счета

Date billDate = getAccDate(accrual)


//Дата корректировки

Date corrDate = getCorrDate(accrual)


Calendar cal = Calendar.getInstance()

cal.setTime(billDate);

//Устанавливаем дату на последний день предыдущего месяца

//cal.add(Calendar.MONTH, -1);

//Текущего месяца


head['billDate'] = cal.get(Calendar.DAY_OF_MONTH).toString()

head['billDate']+=" "+monthesRP[cal.get(Calendar.MONTH)]

head['billDate']+=" "+cal.get(Calendar.YEAR).toString()+" г."

def billDateNum = ''+cal.get(Calendar.DATE)+'.'+(cal.get(Calendar.MONTH)+1)+'.'+cal.get(Calendar.YEAR)

//a.kotvinskiy --/


cal.setTime(corrDate);

head['corrDate'] = cal.get(Calendar.DAY_OF_MONTH).toString()

head['corrDate']+=" "+monthesRP[cal.get(Calendar.MONTH)]

head['corrDate']+=" "+cal.get(Calendar.YEAR).toString()+" г."


Contragent contragent = accrual.getContragent()

head['name'] = contragent.getName();

head['shortName'] = contragent.getShortName();

if (head['shortName']==null){

head['shortName'] = head['name'];

}


head['inn'] = contragent.getInn();

head['kpp'] = contragent.getKpp();

head['legalAddress'] = contragent.getLegalAddress();


def contract = accrual.contractPosition.contract

if (contract.mainContract != null)

contract = contract.mainContract

def company = contract.getCompany()

//a.kotvinskiy /--

//def companyRequisites = companyService.getCompanyRequisites(company, contract.date)

//def companyRequisites = companyService.getCompanyRequisites(company, billDate)

//a.kotvinskiy --/

def companyRequisites = getCompanyRequisites(company)

//a.kotvinskiy --/

CompanyRequisites getCompanyRequisites(Company company){

return dataManager.loadValue('select e from rtneo$CompanyRequisites e where ' +

'e.company.id = :company order by e.dateStart desc', CompanyRequisites.class)

.parameter("company", company)

.list()

.stream()

.findFirst()

.orElse(null);

}

head << ['contractNumber' : contract.number

,'contractDate' : contract.date

,'companyShortName' : company.shortName

,'companyInn':company.inn

,'companyKpp':companyRequisites.kpp

,'companyLegalAddress':companyRequisites.legalAddress

,'companyPhone':company.phone

,'companyBankName':companyRequisites.bankName

,'companyRcbic':companyRequisites.rcbic

,'companyCorrespondentAccount':companyRequisites.correspondentAccount

,'companyBankAccount':companyRequisites.bankAccount

]

result['head'] = head;


/**

* Заполняем подвал

*/

String reason = getReason(accrual);

result['footer'] = [

'billDate' : billDateNum

,'number' : params.number

,'shortName' : head['shortName']

,'inn' : contragent.inn

,'kpp' : contragent.kpp

,'companyShortName' : company.shortName

,'companyInn':company.inn

,'companyKpp':companyRequisites.kpp

,'companyManager' : getShortFio(companyRequisites.getManagerName())

,'companyManagerTitle':companyRequisites.managerTitle

,'companyAccountManager' : getShortFio(companyRequisites.managerName)

,'reason': reason]


//

ViewRepository vRep = AppBeans.get(ViewRepository.NAME)

View accrualView = vRep.getView(Accrual.class, "accrual-bill");

accrualView.addProperty("contractPosition", vRep.getView(ContractPosition.class, "_minimal").addProperty("contragentRealEstate", vRep.getView(ContragentRealEstate.class, "_minimal")));


//

//Acts act = getActualAct(accruals, inn, kpp, accrual.getPeriod())

def items

if(act != null && adjustmen != null){

items = fillItems(act, adjustmen)

}else{

items = fillItems(accruals, act)

}



result['items'] = items


def р = items['totalSumDec'].toString().split(',')


result['totals'] = ['increaseTotal':items['increase'],

'ndsIncTotal':items['ndsInc'],

'totalIncSum':items['totalSumInc'],

'decreaseTotal':items['decrease'],

'ndsDecTotal':items['ndsDec'],

'totalDecSum':getRussianNumber((Double)items['totalSumDec'],2)

]


return [result]


def getRussianNumber(Double number, int precision = 2) {

DecimalFormatSymbols symbols = DecimalFormatSymbols.getInstance()

symbols.setGroupingSeparator((char) ' ')

symbols.setDecimalSeparator((char) ',')

String formatString = '';

switch(precision){

case 1:

formatString = '###,###,##0.0';

break;

case 2:

formatString = '###,###,##0.00';

break;

case 3:

formatString = '###,###,##0.000';

break;

case 4:

formatString = '###,###,##0.0000';

break;

case 5:

formatString = '###,###,##0.00000';

break;

}

DecimalFormat formatter = new DecimalFormat(formatString, symbols);

return(formatter.format(number));

}


def getTextPeriod(Date date) {

def result=''

if (date != null) {

def monthesRP = ['январь','февраль','март','апрель','май','июнь','июль','август','сентябрь','октябрь','ноябрь','декабрь']

Calendar cal = Calendar.getInstance()

cal.setTime(date);

result+=monthesRP[cal.get(Calendar.MONTH)]

result+=" "+cal.get(Calendar.YEAR).toString()+" г."

}

return result

}



def getTextDate(Date date) {

def result=''

if (date != null) {

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 getNN(BigDecimal value) {

return value == null ? BigDecimal.ZERO : value;

}


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

}

/**

*

*/


private Date getCorrDate(def accrual){

Date corrDate = new Date()

Calendar accrualPeriod = Calendar.getInstance()

accrualPeriod.setTime(accrual.getPeriod());

// accrualPeriod.set(Calendar.DAY_OF_MONTH, accrualPeriod.getActualMaximum(Calendar.DAY_OF_MONTH));

Date dateContract = dataManager.loadValue('select e.contractPosition.contract.date from rtneo$Accrual e where e.documentNumber = :documentNumber', Date.class)

.parameter("documentNumber", accrual.getDocumentNumber())

.one()

if(dateContract.after(accrualPeriod.getTime())){

// _("Выводим дату контракта")

corrDate = dateContract;

}else{

// _("Выводим дату окончания периода начисления")

Calendar cal = Calendar.getInstance()

cal.setTime(accrual.getPeriod())

cal.set(Calendar.DAY_OF_MONTH, cal.getActualMaximum(Calendar.DAY_OF_MONTH))

corrDate = cal.getTime()

}

return corrDate;

}

private Date getAccDate(def accrual){

Date accDate = new Date()

Calendar accrualPeriod = Calendar.getInstance()

accrualPeriod.setTime(accrual.getPeriod());

accrualPeriod.set(Calendar.DAY_OF_MONTH, accrualPeriod.getActualMaximum(Calendar.DAY_OF_MONTH));

accDate = accrualPeriod.getTime()

// if(accrual.getContractPosition().getContract().getMainContract() != null){

// accDate = dataManager.loadValue('select e.contractPosition.contract.acceptanceDate from rtneo$Accrual e where e.documentNumber = :documentNumber', Date.class)

// .parameter("documentNumber", accrual.getDocumentNumber())

// .one()

// }

return accDate;

}

def fillItems(Acts adjustmen, Acts act){

def items = new LinkedHashMap()

items.put('amount',0.0)

items.put('priceWoNds',0.0)

items.put('totalSumWoNds',0.0)

items.put('ndsSum',0.0)

items.put('totalSum',0.0)

items.put('amountCorr',0.0)

items.put('priceWoNdsCorr',0.0)

items.put('totalSumWoNdsCorr',0.0)

items.put('ndsSumCorr',0.0)

items.put('totalSumCorr',0.0)

items.put('decrease',0.0)

items.put('increase',0.0)

items.put('ndsInc',0.0)

items.put('ndsDec',0.0)

items.put('totalSumInc',0.0)

items.put('totalSumDec',0.0)

String period = getTextPeriod(act.getPeriod())

def tsw=act.getSum()

items['amount']= act.getCount()

items['month'] = getTextPeriod(act.getPeriod())

items['priceWoNds']=(act.getPrice())

items['totalSumWoNds']=tsw

items['ndsSum']=act.getSum_nds()

items['totalSum']=act.getSum()*1.2

items['amountCorr']= adjustmen.getCount().add(items['amountCorr'])

items['priceWoNdsCorr']=adjustmen.getPrice()

items['totalSumWoNdsCorr']=adjustmen.getSum().add(items['totalSumCorr'])

items['ndsSumCorr']=adjustmen.getSum_nds().add(items['ndsSumCorr'])

items['totalSumCorr']=items['totalSumWoNdsCorr']+items['ndsSumCorr']

items['increase']=items['totalSumWoNdsCorr']<items['totalSumWoNds']?items['totalSumWoNds']-items['totalSumWoNdsCorr']:0.00

items['decrease']=items['totalSumWoNdsCorr']>items['totalSumWoNds']?items['totalSumWoNdsCorr']-items['totalSumWoNds']:0.00

items['ndsDec']=items['ndsSumCorr']>items['ndsSum']?items['ndsSumCorr']-items['ndsSum']:0.00

items['ndsInc']=items['ndsSum']>items['ndsSumCorr']?items['ndsSum']-items['ndsSumCorr']:0.00

items['totalSumDec']=items['totalSum']<items['totalSumCorr']?items['totalSumCorr']-items['totalSum']:0.00

items['totalSumInc']=items['totalSum']>items['totalSumCorr']?items['totalSum']-items['totalSumCorr']:0.00

return items

}

def fillItems(List<Accrual> accs, Acts act){

def items = new LinkedHashMap()

items.put('amount',0.0)

items.put('priceWoNds',0.0)

items.put('totalSumWoNds',0.0)

items.put('ndsSum',0.0)

items.put('totalSum',0.0)

items.put('amountCorr',0.0)

items.put('priceWoNdsCorr',0.0)

items.put('totalSumWoNdsCorr',0.0)

items.put('ndsSumCorr',0.0)

items.put('totalSumCorr',0.0)

items.put('decrease',0.0)

items.put('increase',0.0)

items.put('ndsInc',0.0)

items.put('ndsDec',0.0)

items.put('totalSumInc',0.0)

items.put('totalSumDec',0.0)

for(Accrual a:accs){

String period = getTextPeriod(a.getPeriod())

def tsw=a.getTotalSum().add(items['totalSumWoNds']).subtract(a.getNdsSumBase())

items['amount']= a.getAmount().add(items['amount'])

items['month'] = getTextPeriod(a.getPeriod())

items['priceWoNds']=(a.getPrice()/6*5)

items['totalSumWoNds']=tsw

items['ndsSum']=a.getNdsSumBase().add(items['ndsSum'])

items['totalSum']=a.getTotalSum().add(items['totalSum'])

}

items['amountCorr']= act.getCount().add(items['amountCorr'])

items['priceWoNdsCorr']=act.getPrice()

items['totalSumWoNdsCorr']=act.getSum().add(items['totalSumCorr'])

items['ndsSumCorr']=act.getSum_nds().add(items['ndsSumCorr'])

items['totalSumCorr']=items['totalSumWoNdsCorr']+items['ndsSumCorr']

items['increase']=items['totalSumWoNdsCorr']<items['totalSumWoNds']?items['totalSumWoNds']-items['totalSumWoNdsCorr']:0.00

items['decrease']=items['totalSumWoNdsCorr']>items['totalSumWoNds']?items['totalSumWoNdsCorr']-items['totalSumWoNds']:0.00

items['ndsDec']=items['ndsSumCorr']>items['ndsSum']?items['ndsSumCorr']-items['ndsSum']:0.00

items['ndsInc']=items['ndsSum']>items['ndsSumCorr']?items['ndsSum']-items['ndsSumCorr']:0.00

items['totalSumDec']=items['totalSum']<items['totalSumCorr']?items['totalSumCorr']-items['totalSum']:0.00

items['totalSumInc']=items['totalSum']>items['totalSumCorr']?items['totalSum']-items['totalSumCorr']:0.00

return items

}


private Acts getActualAct(List<Accrual> accruals, String inn, String kpp, Date period, boolean onlyAct = false){

List<Acts> acts = getAllAct(inn, kpp, period)

//Сумма начислений

BigDecimal accSum = BigDecimal.ZERO

accruals.each({accSum = accSum.add(it.getTotalSum())})

accSum = accSum.setScale(2, BigDecimal.ROUND_UP);

boolean isAdj = false

acts.each({if(it.getAdjustments() != null)isAdj = true})

def act = null

def adjustmens = []

//getAdjustments() это ссылка на акт к которому принадлежит корректирока

if(isAdj){

adjustmens = acts.stream().filter({e->e.getAdjustments() != null}).collect(Collectors.toList())

}

onlyActs = acts.stream().filter({e->e.getAdjustments() == null}).collect(Collectors.toList())

def adjustmen

for(def item : adjustmens.reverse()){

def adjSum = item.getSum().add(item.getSum_nds());

if(!adjSum.equals(accSum)){

act = item;

break;

}

}


if(act == null || onlyAct){

act = onlyActs.get(0)

}

return act

}


private List<Acts> getAllAct(String inn, String kpp, Date period){

List<Acts> acts = dataManager.load(Acts.class)

.query('select a from rtneo$Acts a where a.inn = :inn and a.kpp = :kpp and a.period = :period')

.parameter("inn", inn)

.parameter("kpp", kpp)

.parameter("period" ,period)

.view("acts-view")

.list()

return acts;

}


private String getReason(Accrual accrual){

if(accrual.getContractPosition().getContract().getMainContract() != null){

return "Дополнительное соглашение №"+accrual.contractPosition.contract.number;

}else{

return "Договор №"+accrual.contractPosition.contract.number;

}

}

/**

* Логирование

*/

import com.haulmont.cuba.core.app.serialization.EntitySerializationAPI;

import java.text.DateFormat;

import java.text.SimpleDateFormat;

private _(Object obj, String... options){

if(options.size() == 0){log(obj)}

for(def option : options){

if(option.equals("str")){log(obj)}

if(option.equals("for")){obj.each({_(it)})}

if(option.equals("json")){

EntitySerializationAPI entitySerializationAPI = AppBeans.get(EntitySerializationAPI.NAME)

try{log(entitySerializationAPI.toJson(obj))}

catch(Exception e){log("JSON serialization failed")}

}

if(option.equals("date")){

DateFormat df = new SimpleDateFormat("dd.MM.yyyy");

try{log(df.format(obj))}

catch(Exception e){log("Failed date format")}

}

}

}

private log(Object obj){log.debug(obj)}

 
MyTetra Share v.0.58
Яндекс индекс цитирования