KDamir

<rule name="Правило1" formula="@page.field_540_00_023" condition="@formula.is_true=1" chargeType="0">
  <taxYear fullId="540.00.18.2018.01" code="540.00" version="18" year="2018" formula="@formula.get_date(31, 3, @page_540_00_01.period_year + 1)" formulaDescription="Не позднее 31 марта, следующего за налоговым периодом" dateType="Все"/>
  <taxRecordYear fullId="540.00.18.2018.02" code="540.00" version="18" year="2018" formula="@formula.get_date(@formula.cut_date(@formula.get_fil_date, d) + 10, @formula.cut_date(@formula.get_fil_date, m),  @formula.cut_date(@formula.get_fil_date, y))" formulaDescription="не позднее 10 календарных дней со дня представления в налоговый орган ликвидационной налоговой отчетности" dateType="Ликвидационный"/>
  <kbks>
    <kbk formula="105322" condition="@formula.is_syr = 1"/>
    <kbk formula="105302" condition=" @formula.is_syr = 0"/>
  </kbks>
</rule>

KDamir

<extras name="SCRIPTS">
	<extras name="CALC">
		<integer name="id">688518</integer>
		<text name="script_source">res = @formula.switch( (@page_870_01_01.field_870_01_010<>'') * (@page_870_01_01.field_870_01_004<>'')=1 , @page_870_01_01.field_870_01_010 * @page_870_01_01.field_870_01_004 , (@page_870_01_01.field_870_01_008<>'') * (@page_870_01_01.field_870_01_004<>'')=1 , @page_870_01_01.field_870_01_008 * @page_870_01_01.field_870_01_004 , (@page_870_01_01.field_870_01_006<>'') * (@page_870_01_01.field_870_01_004<>'')=1 , @page_870_01_01.field_870_01_006 * @page_870_01_01.field_870_01_004 , '' );</text>
	</extras>
	<extras name="CHECK">
		<integer name="id">688500</integer>
		<text name="script_source">if  ((@page_870_01_01.field_870_01_010<>'') + (@page_870_01_01.field_870_01_006<>'') + (@page_870_01_01.field_870_01_008<>'')>0) + (@page_870_01_01.field_870_01_004<>'') + (@page.field_870_01_012='')=3  then res = '73677' ;</text>
	</extras>
	<extras name="CHECK">

KDamir

ies.java:54)
        at com.epam.sono.desktop2.repo.ConstantEntries.access$000(ConstantEntrie
s.java:19)
        at com.epam.sono.desktop2.repo.ConstantEntries$ConstantEntriesLoader.run
(ConstantEntries.java:69)
Caused by: javax.naming.CommunicationException: A communication failure occurred
 while attempting to obtain an initial context with the provider URL: "corbaloc:
iiop:212.154.167.31:2818".  Make sure that any bootstrap address information in
the URL is correct and that the target name server is running.  A bootstrap addr
ess with no port specification defaults to port 2809.  Possible causes other tha

KDamir

ResultQuestion resultQuestion = new ResultQuestion();

            ScenarioSubject scenarioSubject = resultQuestion.questoin_id.innerQuestion().scenario_id_subject_id.innerScenarioSubject();
            resultQuestion.where(resultQuestion.event_record_id.eq(param(eventRecordId)));

            Select select = Utils.createSelect();
            select.select(resultQuestion.questoin_id);
            select.select(resultQuestion.question_text);
            select.select(PostgresFunction.lag(resultQuestion.questoin_id).as("prev"));
            select.select(PostgresFunction.lead(resultQuestion.questoin_id).as("next"));

KDamir

select questoin_id, question_text, prev, next from
(select t0.questoin_id,t0.question_text,
lag(t0.questoin_id) over (order by t0.questoin_id, t0.questoin_id rows between current row and unbounded following) as prev,
lead(t0.questoin_id) over (order by t0.questoin_id, t0.questoin_id rows between current row and unbounded following) as next
from public.result_question t0 inner join public.question t1
inner join public.scenario_subject t2 on t1.scenario_id = t2.scenario_id
and t1.subject_id = t2.subject_id
on t0.questoin_id = t1.question_id
where t0.event_record_id = 42 order by t0.questoin_id) as tbl
where questoin_id = 33

KDamir

Backup:
docker exec -t -u postgres your-db-container pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

Restore:
cat your_dump.sql | docker exec -i your-db-container psql -Upostgres

KDamir

2017-05-11 14:43:22,832 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) WFLYJCA0001: Bound data source [java:/jboss/datasources/StomagicAishaDS]
2017-05-11 14:48:00,515 INFO  [org.jboss.as.repository] (management task-1) WFLYDR0002: Content removed from location /opt/wildfly-10.0.0.Final/standalone/data/content/6e/e6d107ff16220a970331b87e9c9737a6f3e13c/content
2017-05-11 14:48:41,307 INFO  [org.jboss.as.repository] (management task-2) WFLYDR0002: Content removed from location /opt/wildfly-10.0.0.Final/standalone/data/content/ab/16a7d87416d1fd980184bcf1db8414c812788c/content
2017-05-11 14:51:19,014 INFO  [org.jboss.as.repository] (management task-10) WFLYDR0002: Content removed from location /opt/wildfly-10.0.0.Final/standalone/data/content/57/60c724217e511f41563559cb82982997fea95e/content
2017-05-11 14:51:31,143 INFO  [org.jboss.as.repository] (management task-6) WFLYDR0002: Content removed from location /opt/wildfly-10.0.0.Final/standalone/data/content/c3/bbe952f202bcc6f5ce5562

KDamir

private <W extends AbstractWorkingDay> List<WorkplaceAtTimeInterval> toTimeIntervals(List<W> workingDays, LocalDate date) {
        LocalDateTime branchStartDatetime = date.atTime(getTimetableDisplayStartTime());
        LocalDateTime branchEndDatetime = date.atTime(getTimetableDisplayEndTime());

        LocalDateTime from = getIsWorkdayEndsNextDay() ? branchStartDatetime.toLocalDate().atStartOfDay() : branchStartDatetime;
        LocalDateTime to = getIsWorkdayEndsNextDay() ? from.plusDays(1) : branchEndDatetime;

        List<WorkplaceAtTimeInterval> result = new ArrayList<>();

        while (from.isBefore(to)) {

KDamir

package kz.inessoft.stomagic.common.data.util;

import org.hibernate.dialect.PostgreSQL9Dialect;
import org.hibernate.dialect.function.StandardSQLFunction;

/**
 * Created by damir.keldibekov on 24.04.2017.
 */
public class CustomPostgreSQL9Dialect extends PostgreSQL9Dialect {

KDamir

package kz.inessoft.stomagic.common.data.repository;

import kz.inessoft.stomagic.common.data.entity.AbstractContactPerson;
import kz.inessoft.stomagic.common.data.entity.search.ContactSearchParams;
import org.jetbrains.annotations.NotNull;

import javax.persistence.NoResultException;
import java.util.List;
import java.util.Optional;