|
-- @tag: fix_datepaid
|
|
-- @description: Felder datepaid in ar und ap richtig setzen
|
|
-- @depends: release_2_6_0
|
|
|
|
UPDATE ap
|
|
SET datepaid = COALESCE((SELECT MAX(at.transdate)
|
|
FROM acc_trans at
|
|
LEFT JOIN chart c ON (at.chart_id = c.id)
|
|
WHERE (at.trans_id = ap.id)
|
|
AND (c.link LIKE '%paid%')),
|
|
COALESCE(ap.mtime::date, ap.itime::date))
|
|
WHERE paid <> 0;
|
|
|
|
UPDATE ar
|
|
SET datepaid = COALESCE((SELECT MAX(at.transdate)
|
|
FROM acc_trans at
|
|
LEFT JOIN chart c ON (at.chart_id = c.id)
|
|
WHERE (at.trans_id = ar.id)
|
|
AND (c.link LIKE '%paid%')),
|
|
COALESCE(ar.mtime::date, ar.itime::date))
|
|
WHERE paid <> 0;
|