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 21:09:07.827
2025-06-24 21:09:07.828 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-24 21:09:07.828
2025-06-24 21:09:07.828 @pytest.mark.version('>=3')
2025-06-24 21:09:07.828 def test_1(act: Action):
2025-06-24 21:09:07.828 act.expected_stdout = expected_stdout
2025-06-24 21:09:07.828 act.isql(switches=['-q'], input = test_script % act.db.dsn, connect_db=False, charset='WIN1251', combine_output = True)
2025-06-24 21:09:07.828 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-24 21:09:07.828 E AssertionError: assert
2025-06-24 21:09:07.828 E + Procedure: PUBLIC.PRC_EXPSUMM_8
2025-06-24 21:09:07.828 E Procedure text:
2025-06-24 21:09:07.828 E =============================================================================
2025-06-24 21:09:07.828 E DECLARE VARIABLE NDSDiv DOUBLE PRECISION;
2025-06-24 21:09:07.828 E DECLARE VARIABLE ID_ExportFieldDoc Integer;
2025-06-24 21:09:07.828 E begin
2025-06-24 21:09:07.828 E SELECT Val FROM TBL_Const_Float
2025-06-24 21:09:07.828 E WHERE Name='NDSDiv'
2025-06-24 21:09:07.828 E INTO :NDSDiv;
2025-06-24 21:09:07.828 E FOR SELECT id_exportfielddoc, accountcredit, accountdebit FROM tbl_exportentry
2025-06-24 21:09:07.828 E WHERE id_exportgroupentry=:id_group
2025-06-24 21:09:07.829 E INTO :id_exportfielddoc, :accountcredit, :accountdebit
2025-06-24 21:09:07.829 E DO BEGIN
2025-06-24 21:09:07.829 E IF ((AccountCredit<>0) or (AccountDebit<>0)) THEN BEGIN
2025-06-24 21:09:07.829 E IF (id_exportfielddoc=110) THEN BEGIN
2025-06-24 21:09:07.829 E SELECT SUM(A.PriceRub*B.Volume/A.PointMul), SUM(A.PriceDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
2025-06-24 21:09:07.829 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.829 E TBL_ITEMSALE C,
2025-06-24 21:09:07.829 E TBL_INDOC D
2025-06-24 21:09:07.829 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 21:09:07.829 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.829 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.829 E END
2025-06-24 21:09:07.829 E IF (id_exportfielddoc=111) THEN BEGIN
2025-06-24 21:09:07.829 E SELECT SUM(A.PriceCalcRub*B.Volume/A.PointMul), SUM(A.PriceCalcDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
2025-06-24 21:09:07.829 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.829 E TBL_ITEMSALE C,
2025-06-24 21:09:07.829 E TBL_INDOC D
2025-06-24 21:09:07.829 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 21:09:07.829 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.829 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.830 E END
2025-06-24 21:09:07.830 E IF (id_exportfielddoc=112) THEN BEGIN
2025-06-24 21:09:07.830 E SELECT SUM(A.SummDoc), SUM(A.SummDoc) FROM TBL_OUTDOC_TEMP A,
2025-06-24 21:09:07.830 E TBL_ITEMSALE B,
2025-06-24 21:09:07.830 E TBL_INDOC_TEMP C,
2025-06-24 21:09:07.830 E TBL_INDOC D
2025-06-24 21:09:07.830 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 21:09:07.830 E d.id_indoc=c.id_indoc and d.doctype = 6
2025-06-24 21:09:07.830 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.830 E END
2025-06-24 21:09:07.830 E IF (id_exportfielddoc=113) THEN BEGIN
2025-06-24 21:09:07.830 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 21:09:07.830 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.830 E TBL_ITEMSALE C,
2025-06-24 21:09:07.830 E TBL_INDOC D
2025-06-24 21:09:07.830 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 21:09:07.830 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.830 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.830 E END
2025-06-24 21:09:07.831 E IF (id_exportfielddoc=114) THEN BEGIN
2025-06-24 21:09:07.833 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 21:09:07.835 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.835 E TBL_ITEMSALE C,
2025-06-24 21:09:07.835 E TBL_INDOC D
2025-06-24 21:09:07.835 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 21:09:07.835 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.835 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.835 E END
2025-06-24 21:09:07.835 E IF (id_exportfielddoc=115) THEN BEGIN
2025-06-24 21:09:07.835 E SELECT SUM(A.SummNDSDoc), SUM(A.SummNDSDoc) FROM TBL_OUTDOC_TEMP A,
2025-06-24 21:09:07.835 E TBL_ITEMSALE B,
2025-06-24 21:09:07.835 E TBL_INDOC_TEMP C,
2025-06-24 21:09:07.835 E TBL_INDOC D
2025-06-24 21:09:07.835 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 21:09:07.835 E d.id_indoc=c.id_indoc and d.doctype = 6
2025-06-24 21:09:07.836 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.836 E END
2025-06-24 21:09:07.836 E IF (id_exportfielddoc=116) THEN BEGIN
2025-06-24 21:09:07.836 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 21:09:07.836 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.836 E TBL_ITEMSALE C,
2025-06-24 21:09:07.836 E TBL_INDOC D
2025-06-24 21:09:07.836 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 21:09:07.836 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.836 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.836 E END
2025-06-24 21:09:07.836 E IF (id_exportfielddoc=117) THEN BEGIN
2025-06-24 21:09:07.836 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 21:09:07.836 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.836 E TBL_ITEMSALE C,
2025-06-24 21:09:07.836 E TBL_INDOC D
2025-06-24 21:09:07.836 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 21:09:07.837 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.837 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.837 E END
2025-06-24 21:09:07.837 E IF (id_exportfielddoc=118) THEN BEGIN
2025-06-24 21:09:07.837 E SELECT SUM(A.SummWithNDSDoc), SUM(A.SummWithNDSDoc) FROM TBL_OUTDOC_TEMP A,
2025-06-24 21:09:07.837 E TBL_ITEMSALE B,
2025-06-24 21:09:07.837 E TBL_INDOC_TEMP C,
2025-06-24 21:09:07.837 E TBL_INDOC D
2025-06-24 21:09:07.837 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 21:09:07.837 E d.id_indoc=c.id_indoc and d.doctype = 6
2025-06-24 21:09:07.837 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.837 E END
2025-06-24 21:09:07.837 E IF (id_exportfielddoc=119) THEN BEGIN
2025-06-24 21:09:07.837 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 21:09:07.837 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.837 E TBL_ITEMSALE C,
2025-06-24 21:09:07.837 E TBL_INDOC D
2025-06-24 21:09:07.837 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 21:09:07.837 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.838 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.838 E END
2025-06-24 21:09:07.838 E IF (id_exportfielddoc=120) THEN BEGIN
2025-06-24 21:09:07.838 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 21:09:07.838 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.838 E TBL_ITEMSALE C,
2025-06-24 21:09:07.838 E TBL_INDOC D
2025-06-24 21:09:07.838 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 21:09:07.838 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.838 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.838 E END
2025-06-24 21:09:07.838 E IF (id_exportfielddoc=121) THEN BEGIN
2025-06-24 21:09:07.838 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 21:09:07.838 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.838 E TBL_ITEMSALE C,
2025-06-24 21:09:07.838 E TBL_INDOC D
2025-06-24 21:09:07.838 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 21:09:07.838 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.839 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.839 E END
2025-06-24 21:09:07.839 E IF (id_exportfielddoc=122) THEN BEGIN
2025-06-24 21:09:07.839 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 21:09:07.839 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.839 E TBL_ITEMSALE C,
2025-06-24 21:09:07.839 E TBL_INDOC D
2025-06-24 21:09:07.839 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 21:09:07.839 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.839 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.839 E END
2025-06-24 21:09:07.839 E IF (id_exportfielddoc=123) THEN BEGIN
2025-06-24 21:09:07.839 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 21:09:07.839 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.839 E TBL_ITEMSALE C,
2025-06-24 21:09:07.839 E TBL_INDOC D
2025-06-24 21:09:07.839 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 21:09:07.839 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.839 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.840 E END
2025-06-24 21:09:07.840 E IF (id_exportfielddoc=124) THEN BEGIN
2025-06-24 21:09:07.840 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 21:09:07.840 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.840 E TBL_ITEMSALE C,
2025-06-24 21:09:07.840 E TBL_INDOC D
2025-06-24 21:09:07.840 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 21:09:07.840 E d.id_indoc=a.id_indoc and d.doctype = 6
2025-06-24 21:09:07.840 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.840 E END
2025-06-24 21:09:07.840 E IF (id_exportfielddoc=125) THEN BEGIN
2025-06-24 21:09:07.840 E SELECT SUM(A.PriceRub*B.Volume/A.PointMul), SUM(A.PriceDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
2025-06-24 21:09:07.840 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.840 E TBL_ITEMSALE C,
2025-06-24 21:09:07.840 E TBL_INDOC D
2025-06-24 21:09:07.840 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 21:09:07.840 E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
2025-06-24 21:09:07.840 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.840 E END
2025-06-24 21:09:07.840 E IF (id_exportfielddoc=126) THEN BEGIN
2025-06-24 21:09:07.841 E SELECT SUM(A.PriceCalcRub*B.Volume/A.PointMul), SUM(A.PriceCalcDoc*B.Volume/A.PointMul) FROM TBL_INDOC_TEMP A,
2025-06-24 21:09:07.841 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.841 E TBL_ITEMSALE C,
2025-06-24 21:09:07.841 E TBL_INDOC D
2025-06-24 21:09:07.841 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 21:09:07.841 E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
2025-06-24 21:09:07.841 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.841 E END
2025-06-24 21:09:07.841 E IF (id_exportfielddoc=127) THEN BEGIN
2025-06-24 21:09:07.841 E SELECT SUM(A.SummDoc), SUM(A.SummDoc) FROM TBL_OUTDOC_TEMP A,
2025-06-24 21:09:07.841 E TBL_ITEMSALE B,
2025-06-24 21:09:07.841 E TBL_INDOC_TEMP C,
2025-06-24 21:09:07.841 E TBL_INDOC D
2025-06-24 21:09:07.841 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 21:09:07.841 E d.id_indoc=c.id_indoc and d.doctype = 6 and a.nds=0
2025-06-24 21:09:07.841 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.841 E END
2025-06-24 21:09:07.841 E IF (id_exportfielddoc=128) THEN BEGIN
2025-06-24 21:09:07.841 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 21:09:07.841 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.842 E TBL_ITEMSALE C,
2025-06-24 21:09:07.842 E TBL_INDOC D
2025-06-24 21:09:07.842 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 21:09:07.842 E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
2025-06-24 21:09:07.842 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.842 E END
2025-06-24 21:09:07.842 E IF (id_exportfielddoc=129) THEN BEGIN
2025-06-24 21:09:07.842 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 21:09:07.842 E TBL_OUTDOC_TEMP B,
2025-06-24 21:09:07.842 E TBL_ITEMSALE C,
2025-06-24 21:09:07.842 E TBL_INDOC D
2025-06-24 21:09:07.842 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 21:09:07.842 E d.id_indoc=a.id_indoc and d.doctype = 6 and b.nds=0
2025-06-24 21:09:07.842 E INTO :summrus, :summdoc;
2025-06-24 21:09:07.842 E END
2025-06-24 21:09:07.842 E IF ((id_exportfielddoc>129)and(id_exportfielddoc<145)) THEN BEGIN
2025-06-24 21:09:07.842 E execute procedure prc_expsumm_8_10 ( id_exportfielddoc, id_outdoc, NDSDiv ) returning_values( summrus, summdoc );
2025-06-24 21:09:07.842 E END
2025-06-24 21:09:07.842 E IF ((id_exportfielddoc>144)and(id_exportfielddoc<160)) THEN BEGIN
2025-06-24 21:09:07.843 E execute procedure prc_expsumm_8_20 ( id_exportfielddoc, id_outdoc, NDSDiv ) returning_values( summrus, summdoc );
2025-06-24 21:09:07.843 E END
2025-06-24 21:09:07.843 E IF ((SummRus>0) or (SummDoc>0)) THEN SUSPEND;
2025-06-24 21:09:07.843 E END
2025-06-24 21:09:07.843 E END
2025-06-24 21:09:07.843 E END
2025-06-24 21:09:07.843 E =============================================================================
2025-06-24 21:09:07.843 E Parameters:
2025-06-24 21:09:07.843 E ID_INDOC INPUT INTEGER
2025-06-24 21:09:07.843 E ID_OUTDOC INPUT INTEGER
2025-06-24 21:09:07.843 E ID_GROUP INPUT INTEGER
2025-06-24 21:09:07.843 E ACCOUNTCREDIT OUTPUT INTEGER
2025-06-24 21:09:07.843 E ACCOUNTDEBIT OUTPUT INTEGER
2025-06-24 21:09:07.843 E SUMMRUS OUTPUT DOUBLE PRECISION
2025-06-24 21:09:07.843 E SUMMDOC OUTPUT DOUBLE PRECISION
2025-06-24 21:09:07.843
2025-06-24 21:09:07.843 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
|