lib
proc Form_Start()
call SetCaption
("Purchase Receive"
)
end
proc Lst_DblClick()
event = TGetFld
(q
,"AU_EVENT"
)
expr = strcat
(event
,"=AU_EVENT"
)
call OpenForm
("ptEdit"
,"
AU_PURCHASE_GOODRECEIPT_E.FM"
,"WORK.AU_EVENT"
,1
,expr
,pevent
)
end
proc Panels_Start()
mode = __params[4]
pevent = __params[5]
bus_id = GetActiveEtair
("AU_BUSINESS"
)
if (mode = ""
) then
mode = "ALL_MODE"
endif
if (mode = "ALL_MODE"
) then
start_sql "DATA" "KOSMOS"
SELECT AU_EVENT.AU_EVENT
, AU_EVENT.[DATE]
, AU_EVENT.EVENT_E
, AU_WAREHOUSE.DESCR
AS WDESCR
,
AU_GOOD_CODE.DESCR
AS GTITLE
, AU_KE_GOOD.QUANT
, AU_CURRENCY.CCODE
AS CCODE
,
AU_BUSINESS.TITLE
AS BTITLE
, AU_EVENT.NUMBER
, AU_EVENT.TOTAL_AMOUNT
, AU_T_EVENT.DESCR
FROM ((((((AU_EVENT INNER
JOIN AU_KE_GOOD
ON AU_EVENT.AU_EVENT = AU_KE_GOOD.AU_EVENT
)
INNER
JOIN AU_GOOD
ON AU_KE_GOOD.AU_GOOD = AU_GOOD.AU_GOOD
)
INNER
JOIN AU_WAREHOUSE
ON AU_EVENT.TO_WAREHOUSE = AU_WAREHOUSE.AU_WAREHOUSE
)
INNER
JOIN AU_CURRENCY
ON AU_EVENT.AU_CURRENCY = AU_CURRENCY.AU_CURRENCY
)
INNER
JOIN AU_T_EVENT
ON AU_EVENT.AU_T_EVENT = AU_T_EVENT.AU_T_EVENT
)
INNER
JOIN AU_BUSINESS
ON AU_EVENT.BUSINESS_
FROM = AU_BUSINESS.AU_BUSINESS
)
INNER
JOIN AU_GOOD_CODE
ON AU_KE_GOOD.AU_GOOD_CODE = AU_GOOD_CODE.AU_GOOD_CODE
WHERE (AU_T_EVENT.KEVENT1 = 2
) AND (AU_EVENT.BUSINESS_TO = :B
)
end_sql
q = QueryByName
("DATA"
)
call TSetParam
(q
,"B"
,bus_id
)
endif
if (mode = "SORDER_MODE"
) then
start_sql "DATA" "KOSMOS"
SELECT AU_EVENT.AU_EVENT
, AU_EVENT.[DATE]
, AU_EVENT.EVENT_E
, AU_WAREHOUSE.DESCR
,
AU_GOOD.TITLE
, AU_KE_GOOD.QUANT
, AU_CURRENCY.CCODE
, AU_BUSINESS.TITLE
,
AU_EVENT.NUMBER
, AU_EVENT.TOTAL_AMOUNT
, AU_T_EVENT.DESCR
FROM (((((AU_EVENT INNER
JOIN AU_KE_GOOD
ON AU_EVENT.AU_EVENT = AU_KE_GOOD.AU_EVENT
)
INNER
JOIN AU_GOOD
ON AU_KE_GOOD.AU_GOOD = AU_GOOD.AU_GOOD
)
INNER
JOIN AU_WAREHOUSE
ON AU_EVENT.TO_WAREHOUSE = AU_WAREHOUSE.AU_WAREHOUSE
)
INNER
JOIN AU_CURRENCY
ON AU_EVENT.AU_CURRENCY = AU_CURRENCY.AU_CURRENCY
)
INNER
JOIN AU_T_EVENT
ON AU_EVENT.AU_T_EVENT = AU_T_EVENT.AU_T_EVENT
)
INNER
JOIN AU_BUSINESS
ON AU_EVENT.BUSINESS_
FROM = AU_BUSINESS.AU_BUSINESS
WHERE (AU_T_EVENT.KEVENT1 = 2
) AND (AU_EVENT.BUSINESS_TO = :B
)
AND (AU_EVENT.EVENT_E = :EV
)
end_sql
q = QueryByName
("DATA"
)
call TSetParam
(q
,"EV"
,pevent
)
call TSetParam
(q
,"B"
,bus_id
)
endif
if (mode = "PORDER_MODE"
) then
start_sql "DATA" "KOSMOS"
SELECT AU_EVENT.AU_EVENT
, AU_EVENT.[DATE]
, AU_EVENT.EVENT_E
, AU_WAREHOUSE.DESCR
AS WDESCR
,
AU_GOOD_CODE.DESCR
AS GTITLE
, AU_KE_GOOD.QUANT
, AU_CURRENCY.CCODE
AS CCODE
,
AU_BUSINESS.TITLE
AS BTITLE
, AU_EVENT.NUMBER
, AU_EVENT.TOTAL_AMOUNT
, AU_T_EVENT.DESCR
FROM ((((((AU_EVENT INNER
JOIN AU_KE_GOOD
ON AU_EVENT.AU_EVENT = AU_KE_GOOD.AU_EVENT
)
INNER
JOIN AU_GOOD
ON AU_KE_GOOD.AU_GOOD = AU_GOOD.AU_GOOD
)
INNER
JOIN AU_WAREHOUSE
ON AU_EVENT.TO_WAREHOUSE = AU_WAREHOUSE.AU_WAREHOUSE
)
INNER
JOIN AU_CURRENCY
ON AU_EVENT.AU_CURRENCY = AU_CURRENCY.AU_CURRENCY
)
INNER
JOIN AU_T_EVENT
ON AU_EVENT.AU_T_EVENT = AU_T_EVENT.AU_T_EVENT
)
INNER
JOIN AU_BUSINESS
ON AU_EVENT.BUSINESS_
FROM = AU_BUSINESS.AU_BUSINESS
)
INNER
JOIN AU_GOOD_CODE
ON AU_KE_GOOD.AU_GOOD_CODE = AU_GOOD_CODE.AU_GOOD_CODE
WHERE (AU_T_EVENT.KEVENT1 = 2
)
AND (AU_EVENT.EVENT_E = :EV
)
end_sql
q = QueryByName
("DATA"
)
call TSetParam
(q
,"EV"
,pevent
)
endif
call TPrepare
(q
)
end
proc paral
()
call OpenForm
("ptApp
end"
,"
AU_EVENT_GOODSIN21_E.FM"
,"WORK.AU_EVENT"
,1
,"?=AU_EVENT"
,pevent
)
end
proc invoice
()
call OpenForm
("ptApp
end"
,"
AU_PURCHASE_GOODRECEIPT_E.FM"
,"WORK.AU_EVENT"
,1
,"?=AU_EVENT"
,pevent
)
end
