2 @message |
AssertionError: assert
+ Procedure: PUBLIC.PRC_EXPSUMM_8
Procedure text:
=============================================================================
DECLARE VARIABLE NDSDiv DOUBLE PRECISION;
DECLARE VARIABLE ID_ExportFieldDoc Integer;
begin
SELECT Val FROM TBL_Const_Float
WHERE Name='NDSDiv'
INTO :NDSDiv;
FOR SELECT id_exportfielddoc, accountcredit, accountdebit FROM tbl_exportentry
WHERE id_exportgroupentry=:id_group
INTO :id_exportfielddoc, :accountcredit, :accountdebit
DO BEGIN
IF ((AccountCredit<>0) or (AccountDebit<>0)) THEN BEGIN
IF (id_exportfielddoc=110) THEN BEGIN
SELECT SUM(A.PriceRub*B.Volume/A.PointMul), SUM(A.PriceDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=111) THEN BEGIN
SELECT SUM(A.PriceCalcRub*B.Volume/A.PointMul), SUM(A.PriceCalcDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=112) THEN BEGIN
SELECT SUM(A.SummDoc), SUM(A.SummDoc) FROM TBL_OUTDOC_TEMP A,
TBL_ITEMSALE B,
TBL_INDOC_TEMP C,
TBL_INDOC D
WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
d.id_indoc=c.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=113) THEN BEGIN
SELECT SUM(A.NDS*A.PriceRub*B.Volume/(A.PointMul*100)), SUM(A.NDS*A.PriceDoc*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=114) THEN BEGIN
SELECT SUM(A.NDS*A.PriceCalcRub*B.Volume/(A.PointMul*100)), SUM(A.NDS*A.PriceCalcDoc*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=115) THEN BEGIN
SELECT SUM(A.SummNDSDoc), SUM(A.SummNDSDoc) FROM TBL_OUTDOC_TEMP A,
TBL_ITEMSALE B,
TBL_INDOC_TEMP C,
TBL_INDOC D
WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
d.id_indoc=c.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=116) THEN BEGIN
SELECT SUM((A.PriceRub*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM((A.PriceDoc*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=117) THEN BEGIN
SELECT SUM((A.PriceCalcRub*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM((A.PriceCalcDoc*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=118) THEN BEGIN
SELECT SUM(A.SummWithNDSDoc), SUM(A.SummWithNDSDoc) FROM TBL_OUTDOC_TEMP A,
TBL_ITEMSALE B,
TBL_INDOC_TEMP C,
TBL_INDOC D
WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
d.id_indoc=c.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=119) THEN BEGIN
SELECT SUM((A.PriceCalcRub-A.PriceRub)*B.Volume/A.PointMul), SUM((A.PriceCalcDoc-A.PriceDoc)*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=120) THEN BEGIN
SELECT SUM(B.SummDoc-(A.PriceRub*B.Volume/A.PointMul)), SUM(B.SummDoc-(A.PriceDoc*B.Volume/A.PointMul)) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=121) THEN BEGIN
SELECT SUM(A.NDS*(A.PriceCalcRub-A.PriceRub)*B.Volume/(A.PointMul*100)), SUM(A.NDS*(A.PriceCalcDoc-A.PriceDoc)*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=122) THEN BEGIN
SELECT SUM(B.SummNDSDoc-A.NDS*A.PriceRub*B.Volume/(A.PointMul*100)), SUM(B.SummNDSDoc-A.NDS*A.PriceDoc*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=123) THEN BEGIN
SELECT SUM(((A.PriceCalcRub-A.PriceRub)*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM(((A.PriceCalcDoc-A.PriceDoc)*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=124) THEN BEGIN
SELECT SUM(B.SummWithNDSDoc-(A.PriceRub*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM(B.SummWithNDSDoc-(A.PriceDoc*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=125) THEN BEGIN
SELECT SUM(A.PriceRub*B.Volume/A.PointMul), SUM(A.PriceDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=126) THEN BEGIN
SELECT SUM(A.PriceCalcRub*B.Volume/A.PointMul), SUM(A.PriceCalcDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=127) THEN BEGIN
SELECT SUM(A.SummDoc), SUM(A.SummDoc) FROM TBL_OUTDOC_TEMP A,
TBL_ITEMSALE B,
TBL_INDOC_TEMP C,
TBL_INDOC D
WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
d.id_indoc=c.id_indoc and d.doctype = 6 and a.nds=0
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=128) THEN BEGIN
SELECT SUM((A.PriceCalcRub-A.PriceRub)*B.Volume/A.PointMul), SUM((A.PriceCalcDoc-A.PriceDoc)*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
INTO :summrus, :summdoc;
END
IF (id_exportfielddoc=129) THEN BEGIN
SELECT SUM(B.SummDoc-(A.PriceRub*B.Volume/A.PointMul)), SUM(B.SummDoc-(A.PriceDoc*B.Volume/A.PointMul)) FROM TBL_INDOC_TEMP A,
TBL_OUTDOC_TEMP B,
TBL_ITEMSALE C,
TBL_INDOC D
WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
INTO :summrus, :summdoc;
END
IF ((id_exportfielddoc>129)and(id_exportfielddoc<145)) THEN BEGIN
execute procedure prc_expsumm_8_10 ( id_exportfielddoc, id_outdoc, NDSDiv ) returning_values( summrus, summdoc );
END
IF ((id_exportfielddoc>144)and(id_exportfielddoc<160)) THEN BEGIN
execute procedure prc_expsumm_8_20 ( id_exportfielddoc, id_outdoc, NDSDiv ) returning_values( summrus, summdoc );
END
IF ((SummRus>0) or (SummDoc>0)) THEN SUSPEND;
END
END
END
=============================================================================
Parameters:
ID_INDOC INPUT INTEGER
ID_OUTDOC INPUT INTEGER
ID_GROUP INPUT INTEGER
ACCOUNTCREDIT OUTPUT INTEGER
ACCOUNTDEBIT OUTPUT INTEGER
SUMMRUS OUTPUT DOUBLE PRECISION
SUMMDOC OUTPUT DOUBLE PRECISION
LOG DETAILS:
2025-06-24 05:18:55.005
2025-06-24 05:18:55.014 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-24 05:18:55.021
2025-06-24 05:18:55.027 @pytest.mark.version('>=3')
2025-06-24 05:18:55.036 def test_1(act: Action):
2025-06-24 05:18:55.045 act.expected_stdout = expected_stdout
2025-06-24 05:18:55.053 act.isql(switches=['-q'], input = test_script % act.db.dsn, connect_db=False, charset='WIN1251', combine_output = True)
2025-06-24 05:18:55.060 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-24 05:18:55.066 E AssertionError: assert
2025-06-24 05:18:55.072 E + Procedure: PUBLIC.PRC_EXPSUMM_8
2025-06-24 05:18:55.076 E Procedure text:
2025-06-24 05:18:55.083 E =============================================================================
2025-06-24 05:18:55.088 E DECLARE VARIABLE NDSDiv DOUBLE PRECISION;
2025-06-24 05:18:55.094 E DECLARE VARIABLE ID_ExportFieldDoc Integer;
2025-06-24 05:18:55.099 E begin
2025-06-24 05:18:55.111 E SELECT Val FROM TBL_Const_Float
2025-06-24 05:18:55.121 E WHERE Name='NDSDiv'
2025-06-24 05:18:55.132 E INTO :NDSDiv;
2025-06-24 05:18:55.142 E FOR SELECT id_exportfielddoc, accountcredit, accountdebit FROM tbl_exportentry
2025-06-24 05:18:55.153 E WHERE id_exportgroupentry=:id_group
2025-06-24 05:18:55.161 E INTO :id_exportfielddoc, :accountcredit, :accountdebit
2025-06-24 05:18:55.169 E DO BEGIN
2025-06-24 05:18:55.181 E IF ((AccountCredit<>0) or (AccountDebit<>0)) THEN BEGIN
2025-06-24 05:18:55.190 E IF (id_exportfielddoc=110) THEN BEGIN
2025-06-24 05:18:55.202 E SELECT SUM(A.PriceRub*B.Volume/A.PointMul), SUM(A.PriceDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:55.210 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:55.220 E TBL_ITEMSALE C,
2025-06-24 05:18:55.231 E TBL_INDOC D
2025-06-24 05:18:55.243 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:55.254 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:55.265 E INTO :summrus, :summdoc;
2025-06-24 05:18:55.275 E END
2025-06-24 05:18:55.284 E IF (id_exportfielddoc=111) THEN BEGIN
2025-06-24 05:18:55.296 E SELECT SUM(A.PriceCalcRub*B.Volume/A.PointMul), SUM(A.PriceCalcDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:55.305 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:55.315 E TBL_ITEMSALE C,
2025-06-24 05:18:55.327 E TBL_INDOC D
2025-06-24 05:18:55.337 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:55.344 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:55.350 E INTO :summrus, :summdoc;
2025-06-24 05:18:55.356 E END
2025-06-24 05:18:55.368 E IF (id_exportfielddoc=112) THEN BEGIN
2025-06-24 05:18:55.375 E SELECT SUM(A.SummDoc), SUM(A.SummDoc) FROM TBL_OUTDOC_TEMP A,
2025-06-24 05:18:55.381 E TBL_ITEMSALE B,
2025-06-24 05:18:55.387 E TBL_INDOC_TEMP C,
2025-06-24 05:18:55.392 E TBL_INDOC D
2025-06-24 05:18:55.396 E WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
2025-06-24 05:18:55.401 E d.id_indoc=c.id_indoc and d.doctype = 6
2025-06-24 05:18:55.406 E INTO :summrus, :summdoc;
2025-06-24 05:18:55.410 E END
2025-06-24 05:18:55.415 E IF (id_exportfielddoc=113) THEN BEGIN
2025-06-24 05:18:55.420 E SELECT SUM(A.NDS*A.PriceRub*B.Volume/(A.PointMul*100)), SUM(A.NDS*A.PriceDoc*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:55.424 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:55.429 E TBL_ITEMSALE C,
2025-06-24 05:18:55.433 E TBL_INDOC D
2025-06-24 05:18:55.446 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:55.458 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:55.469 E INTO :summrus, :summdoc;
2025-06-24 05:18:55.478 E END
2025-06-24 05:18:55.486 E IF (id_exportfielddoc=114) THEN BEGIN
2025-06-24 05:18:55.494 E SELECT SUM(A.NDS*A.PriceCalcRub*B.Volume/(A.PointMul*100)), SUM(A.NDS*A.PriceCalcDoc*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:55.500 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:55.508 E TBL_ITEMSALE C,
2025-06-24 05:18:55.515 E TBL_INDOC D
2025-06-24 05:18:55.523 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:55.528 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:55.534 E INTO :summrus, :summdoc;
2025-06-24 05:18:55.540 E END
2025-06-24 05:18:55.545 E IF (id_exportfielddoc=115) THEN BEGIN
2025-06-24 05:18:55.552 E SELECT SUM(A.SummNDSDoc), SUM(A.SummNDSDoc) FROM TBL_OUTDOC_TEMP A,
2025-06-24 05:18:55.558 E TBL_ITEMSALE B,
2025-06-24 05:18:55.563 E TBL_INDOC_TEMP C,
2025-06-24 05:18:55.569 E TBL_INDOC D
2025-06-24 05:18:55.575 E WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
2025-06-24 05:18:55.583 E d.id_indoc=c.id_indoc and d.doctype = 6
2025-06-24 05:18:55.596 E INTO :summrus, :summdoc;
2025-06-24 05:18:55.606 E END
2025-06-24 05:18:55.617 E IF (id_exportfielddoc=116) THEN BEGIN
2025-06-24 05:18:55.630 E SELECT SUM((A.PriceRub*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM((A.PriceDoc*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:55.640 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:55.648 E TBL_ITEMSALE C,
2025-06-24 05:18:55.656 E TBL_INDOC D
2025-06-24 05:18:55.663 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:55.668 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:55.674 E INTO :summrus, :summdoc;
2025-06-24 05:18:55.679 E END
2025-06-24 05:18:55.684 E IF (id_exportfielddoc=117) THEN BEGIN
2025-06-24 05:18:55.691 E SELECT SUM((A.PriceCalcRub*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM((A.PriceCalcDoc*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:55.701 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:55.710 E TBL_ITEMSALE C,
2025-06-24 05:18:55.723 E TBL_INDOC D
2025-06-24 05:18:55.733 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:55.744 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:55.755 E INTO :summrus, :summdoc;
2025-06-24 05:18:55.763 E END
2025-06-24 05:18:55.771 E IF (id_exportfielddoc=118) THEN BEGIN
2025-06-24 05:18:55.778 E SELECT SUM(A.SummWithNDSDoc), SUM(A.SummWithNDSDoc) FROM TBL_OUTDOC_TEMP A,
2025-06-24 05:18:55.789 E TBL_ITEMSALE B,
2025-06-24 05:18:55.799 E TBL_INDOC_TEMP C,
2025-06-24 05:18:55.808 E TBL_INDOC D
2025-06-24 05:18:55.817 E WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
2025-06-24 05:18:55.825 E d.id_indoc=c.id_indoc and d.doctype = 6
2025-06-24 05:18:55.832 E INTO :summrus, :summdoc;
2025-06-24 05:18:55.838 E END
2025-06-24 05:18:55.844 E IF (id_exportfielddoc=119) THEN BEGIN
2025-06-24 05:18:55.856 E SELECT SUM((A.PriceCalcRub-A.PriceRub)*B.Volume/A.PointMul), SUM((A.PriceCalcDoc-A.PriceDoc)*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:55.865 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:55.872 E TBL_ITEMSALE C,
2025-06-24 05:18:55.883 E TBL_INDOC D
2025-06-24 05:18:55.892 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:55.900 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:55.907 E INTO :summrus, :summdoc;
2025-06-24 05:18:55.914 E END
2025-06-24 05:18:55.928 E IF (id_exportfielddoc=120) THEN BEGIN
2025-06-24 05:18:55.941 E SELECT SUM(B.SummDoc-(A.PriceRub*B.Volume/A.PointMul)), SUM(B.SummDoc-(A.PriceDoc*B.Volume/A.PointMul)) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:55.955 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:55.966 E TBL_ITEMSALE C,
2025-06-24 05:18:55.978 E TBL_INDOC D
2025-06-24 05:18:55.989 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:56.001 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:56.013 E INTO :summrus, :summdoc;
2025-06-24 05:18:56.022 E END
2025-06-24 05:18:56.031 E IF (id_exportfielddoc=121) THEN BEGIN
2025-06-24 05:18:56.043 E SELECT SUM(A.NDS*(A.PriceCalcRub-A.PriceRub)*B.Volume/(A.PointMul*100)), SUM(A.NDS*(A.PriceCalcDoc-A.PriceDoc)*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:56.052 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:56.060 E TBL_ITEMSALE C,
2025-06-24 05:18:56.068 E TBL_INDOC D
2025-06-24 05:18:56.075 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:56.083 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:56.089 E INTO :summrus, :summdoc;
2025-06-24 05:18:56.095 E END
2025-06-24 05:18:56.101 E IF (id_exportfielddoc=122) THEN BEGIN
2025-06-24 05:18:56.113 E SELECT SUM(B.SummNDSDoc-A.NDS*A.PriceRub*B.Volume/(A.PointMul*100)), SUM(B.SummNDSDoc-A.NDS*A.PriceDoc*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:56.126 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:56.134 E TBL_ITEMSALE C,
2025-06-24 05:18:56.143 E TBL_INDOC D
2025-06-24 05:18:56.154 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:56.162 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:56.170 E INTO :summrus, :summdoc;
2025-06-24 05:18:56.179 E END
2025-06-24 05:18:56.191 E IF (id_exportfielddoc=123) THEN BEGIN
2025-06-24 05:18:56.201 E SELECT SUM(((A.PriceCalcRub-A.PriceRub)*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM(((A.PriceCalcDoc-A.PriceDoc)*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:56.209 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:56.220 E TBL_ITEMSALE C,
2025-06-24 05:18:56.230 E TBL_INDOC D
2025-06-24 05:18:56.239 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:56.248 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:56.255 E INTO :summrus, :summdoc;
2025-06-24 05:18:56.263 E END
2025-06-24 05:18:56.272 E IF (id_exportfielddoc=124) THEN BEGIN
2025-06-24 05:18:56.282 E SELECT SUM(B.SummWithNDSDoc-(A.PriceRub*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM(B.SummWithNDSDoc-(A.PriceDoc*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:56.290 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:56.297 E TBL_ITEMSALE C,
2025-06-24 05:18:56.303 E TBL_INDOC D
2025-06-24 05:18:56.310 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:56.317 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 05:18:56.323 E INTO :summrus, :summdoc;
2025-06-24 05:18:56.330 E END
2025-06-24 05:18:56.339 E IF (id_exportfielddoc=125) THEN BEGIN
2025-06-24 05:18:56.349 E SELECT SUM(A.PriceRub*B.Volume/A.PointMul), SUM(A.PriceDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:56.355 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:56.361 E TBL_ITEMSALE C,
2025-06-24 05:18:56.371 E TBL_INDOC D
2025-06-24 05:18:56.384 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:56.393 E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
2025-06-24 05:18:56.405 E INTO :summrus, :summdoc;
2025-06-24 05:18:56.421 E END
2025-06-24 05:18:56.435 E IF (id_exportfielddoc=126) THEN BEGIN
2025-06-24 05:18:56.447 E SELECT SUM(A.PriceCalcRub*B.Volume/A.PointMul), SUM(A.PriceCalcDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:56.456 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:56.464 E TBL_ITEMSALE C,
2025-06-24 05:18:56.471 E TBL_INDOC D
2025-06-24 05:18:56.480 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:56.491 E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
2025-06-24 05:18:56.501 E INTO :summrus, :summdoc;
2025-06-24 05:18:56.509 E END
2025-06-24 05:18:56.516 E IF (id_exportfielddoc=127) THEN BEGIN
2025-06-24 05:18:56.523 E SELECT SUM(A.SummDoc), SUM(A.SummDoc) FROM TBL_OUTDOC_TEMP A,
2025-06-24 05:18:56.529 E TBL_ITEMSALE B,
2025-06-24 05:18:56.535 E TBL_INDOC_TEMP C,
2025-06-24 05:18:56.541 E TBL_INDOC D
2025-06-24 05:18:56.547 E WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
2025-06-24 05:18:56.559 E d.id_indoc=c.id_indoc and d.doctype = 6 and a.nds=0
2025-06-24 05:18:56.570 E INTO :summrus, :summdoc;
2025-06-24 05:18:56.582 E END
2025-06-24 05:18:56.593 E IF (id_exportfielddoc=128) THEN BEGIN
2025-06-24 05:18:56.604 E SELECT SUM((A.PriceCalcRub-A.PriceRub)*B.Volume/A.PointMul), SUM((A.PriceCalcDoc-A.PriceDoc)*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:56.616 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:56.628 E TBL_ITEMSALE C,
2025-06-24 05:18:56.641 E TBL_INDOC D
2025-06-24 05:18:56.651 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:56.661 E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
2025-06-24 05:18:56.673 E INTO :summrus, :summdoc;
2025-06-24 05:18:56.683 E END
2025-06-24 05:18:56.691 E IF (id_exportfielddoc=129) THEN BEGIN
2025-06-24 05:18:56.705 E SELECT SUM(B.SummDoc-(A.PriceRub*B.Volume/A.PointMul)), SUM(B.SummDoc-(A.PriceDoc*B.Volume/A.PointMul)) FROM TBL_INDOC_TEMP A,
2025-06-24 05:18:56.719 E TBL_OUTDOC_TEMP B,
2025-06-24 05:18:56.733 E TBL_ITEMSALE C,
2025-06-24 05:18:56.746 E TBL_INDOC D
2025-06-24 05:18:56.759 E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
2025-06-24 05:18:56.769 E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
2025-06-24 05:18:56.777 E INTO :summrus, :summdoc;
2025-06-24 05:18:56.784 E END
2025-06-24 05:18:56.797 E IF ((id_exportfielddoc>129)and(id_exportfielddoc<145)) THEN BEGIN
2025-06-24 05:18:56.808 E execute procedure prc_expsumm_8_10 ( id_exportfielddoc, id_outdoc, NDSDiv ) returning_values( summrus, summdoc );
2025-06-24 05:18:56.819 E END
2025-06-24 05:18:56.829 E IF ((id_exportfielddoc>144)and(id_exportfielddoc<160)) THEN BEGIN
2025-06-24 05:18:56.842 E execute procedure prc_expsumm_8_20 ( id_exportfielddoc, id_outdoc, NDSDiv ) returning_values( summrus, summdoc );
2025-06-24 05:18:56.854 E END
2025-06-24 05:18:56.867 E IF ((SummRus>0) or (SummDoc>0)) THEN SUSPEND;
2025-06-24 05:18:56.879 E END
2025-06-24 05:18:56.889 E END
2025-06-24 05:18:56.897 E END
2025-06-24 05:18:56.904 E =============================================================================
2025-06-24 05:18:56.911 E Parameters:
2025-06-24 05:18:56.918 E ID_INDOC INPUT INTEGER
2025-06-24 05:18:56.924 E ID_OUTDOC INPUT INTEGER
2025-06-24 05:18:56.931 E ID_GROUP INPUT INTEGER
2025-06-24 05:18:56.938 E ACCOUNTCREDIT OUTPUT INTEGER
2025-06-24 05:18:56.945 E ACCOUNTDEBIT OUTPUT INTEGER
2025-06-24 05:18:56.952 E SUMMRUS OUTPUT DOUBLE PRECISION
2025-06-24 05:18:56.960 E SUMMDOC OUTPUT DOUBLE PRECISION
2025-06-24 05:18:56.967
2025-06-24 05:18:56.980 tests/bugs/core_1291_test.py:885: AssertionError
|
3 #text |
act = <firebird.qa.plugin.Action pytest object at [hex]>
@pytest.mark.version('>=3')
def test_1(act: Action):
act.expected_stdout = expected_stdout
act.isql(switches=['-q'], input = test_script % act.db.dsn, connect_db=False, charset='WIN1251', combine_output = True)
> assert act.clean_stdout == act.clean_expected_stdout
E AssertionError: assert
E + Procedure: PUBLIC.PRC_EXPSUMM_8
E Procedure text:
E =============================================================================
E DECLARE VARIABLE NDSDiv DOUBLE PRECISION;
E DECLARE VARIABLE ID_ExportFieldDoc Integer;
E begin
E SELECT Val FROM TBL_Const_Float
E WHERE Name='NDSDiv'
E INTO :NDSDiv;
E FOR SELECT id_exportfielddoc, accountcredit, accountdebit FROM tbl_exportentry
E WHERE id_exportgroupentry=:id_group
E INTO :id_exportfielddoc, :accountcredit, :accountdebit
E DO BEGIN
E IF ((AccountCredit<>0) or (AccountDebit<>0)) THEN BEGIN
E IF (id_exportfielddoc=110) THEN BEGIN
E SELECT SUM(A.PriceRub*B.Volume/A.PointMul), SUM(A.PriceDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=111) THEN BEGIN
E SELECT SUM(A.PriceCalcRub*B.Volume/A.PointMul), SUM(A.PriceCalcDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=112) THEN BEGIN
E SELECT SUM(A.SummDoc), SUM(A.SummDoc) FROM TBL_OUTDOC_TEMP A,
E TBL_ITEMSALE B,
E TBL_INDOC_TEMP C,
E TBL_INDOC D
E WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
E d.id_indoc=c.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=113) THEN BEGIN
E SELECT SUM(A.NDS*A.PriceRub*B.Volume/(A.PointMul*100)), SUM(A.NDS*A.PriceDoc*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=114) THEN BEGIN
E SELECT SUM(A.NDS*A.PriceCalcRub*B.Volume/(A.PointMul*100)), SUM(A.NDS*A.PriceCalcDoc*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=115) THEN BEGIN
E SELECT SUM(A.SummNDSDoc), SUM(A.SummNDSDoc) FROM TBL_OUTDOC_TEMP A,
E TBL_ITEMSALE B,
E TBL_INDOC_TEMP C,
E TBL_INDOC D
E WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
E d.id_indoc=c.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=116) THEN BEGIN
E SELECT SUM((A.PriceRub*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM((A.PriceDoc*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=117) THEN BEGIN
E SELECT SUM((A.PriceCalcRub*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM((A.PriceCalcDoc*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=118) THEN BEGIN
E SELECT SUM(A.SummWithNDSDoc), SUM(A.SummWithNDSDoc) FROM TBL_OUTDOC_TEMP A,
E TBL_ITEMSALE B,
E TBL_INDOC_TEMP C,
E TBL_INDOC D
E WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
E d.id_indoc=c.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=119) THEN BEGIN
E SELECT SUM((A.PriceCalcRub-A.PriceRub)*B.Volume/A.PointMul), SUM((A.PriceCalcDoc-A.PriceDoc)*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=120) THEN BEGIN
E SELECT SUM(B.SummDoc-(A.PriceRub*B.Volume/A.PointMul)), SUM(B.SummDoc-(A.PriceDoc*B.Volume/A.PointMul)) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=121) THEN BEGIN
E SELECT SUM(A.NDS*(A.PriceCalcRub-A.PriceRub)*B.Volume/(A.PointMul*100)), SUM(A.NDS*(A.PriceCalcDoc-A.PriceDoc)*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=122) THEN BEGIN
E SELECT SUM(B.SummNDSDoc-A.NDS*A.PriceRub*B.Volume/(A.PointMul*100)), SUM(B.SummNDSDoc-A.NDS*A.PriceDoc*B.Volume/(A.PointMul*100)) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=123) THEN BEGIN
E SELECT SUM(((A.PriceCalcRub-A.PriceRub)*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM(((A.PriceCalcDoc-A.PriceDoc)*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=124) THEN BEGIN
E SELECT SUM(B.SummWithNDSDoc-(A.PriceRub*B.Volume/A.PointMul)*(1+A.NDS/100)), SUM(B.SummWithNDSDoc-(A.PriceDoc*B.Volume/A.PointMul)*(1+A.NDS/100)) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=125) THEN BEGIN
E SELECT SUM(A.PriceRub*B.Volume/A.PointMul), SUM(A.PriceDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=126) THEN BEGIN
E SELECT SUM(A.PriceCalcRub*B.Volume/A.PointMul), SUM(A.PriceCalcDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=127) THEN BEGIN
E SELECT SUM(A.SummDoc), SUM(A.SummDoc) FROM TBL_OUTDOC_TEMP A,
E TBL_ITEMSALE B,
E TBL_INDOC_TEMP C,
E TBL_INDOC D
E WHERE A.ID_OUTDOC=:id_outdoc and b.id_itemsale=a.id_itemsale and c.id_indoc_temp=b.id_firstindoc_temp and
E d.id_indoc=c.id_indoc and d.doctype = 6 and a.nds=0
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=128) THEN BEGIN
E SELECT SUM((A.PriceCalcRub-A.PriceRub)*B.Volume/A.PointMul), SUM((A.PriceCalcDoc-A.PriceDoc)*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
E INTO :summrus, :summdoc;
E END
E IF (id_exportfielddoc=129) THEN BEGIN
E SELECT SUM(B.SummDoc-(A.PriceRub*B.Volume/A.PointMul)), SUM(B.SummDoc-(A.PriceDoc*B.Volume/A.PointMul)) FROM TBL_INDOC_TEMP A,
E TBL_OUTDOC_TEMP B,
E TBL_ITEMSALE C,
E TBL_INDOC D
E WHERE b.id_outdoc=:id_outdoc and b.id_itemsale=c.id_itemsale and c.id_firstindoc_temp=a.id_indoc_temp and
E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
E INTO :summrus, :summdoc;
E END
E IF ((id_exportfielddoc>129)and(id_exportfielddoc<145)) THEN BEGIN
E execute procedure prc_expsumm_8_10 ( id_exportfielddoc, id_outdoc, NDSDiv ) returning_values( summrus, summdoc );
E END
E IF ((id_exportfielddoc>144)and(id_exportfielddoc<160)) THEN BEGIN
E execute procedure prc_expsumm_8_20 ( id_exportfielddoc, id_outdoc, NDSDiv ) returning_values( summrus, summdoc );
E END
E IF ((SummRus>0) or (SummDoc>0)) THEN SUSPEND;
E END
E END
E END
E =============================================================================
E Parameters:
E ID_INDOC INPUT INTEGER
E ID_OUTDOC INPUT INTEGER
E ID_GROUP INPUT INTEGER
E ACCOUNTCREDIT OUTPUT INTEGER
E ACCOUNTDEBIT OUTPUT INTEGER
E SUMMRUS OUTPUT DOUBLE PRECISION
E SUMMDOC OUTPUT DOUBLE PRECISION
tests/bugs/core_1291_test.py:885: AssertionError
|