Synchronize Kontostand and Geldtransaktionen

[abruckmeier]

Synchronisation of both entities from time to time (regularly, weekly?) -> Slack-Message to the administrator.

• Count the Bargeld and set the correct status.
• Create job to synchronise/compare the entities.

Code for comparison

select
	k.id,
	k.username,
	ks.stand,
	coalesce(z.zu,0) - coalesce(v.von,0) as std_transaktionen,
	ks.stand - (coalesce(z.zu,0) - coalesce(v.von,0)) as diff,
	-ks.stand - (coalesce(z.zu,0) - coalesce(v.von,0)) as diff2,
	v.von,
	z.zu
from profil_kioskuser as k
left join kiosk_kontostand ks
	on k.id = ks.nutzer_id
left join (
	select 
		vonnutzer_id as id,
		sum(betrag) as von
	from kiosk_geldtransaktionen
	group by vonnutzer_id
) as v
	using(id)
left join (
	select 
		zunutzer_id as id,
		sum(betrag) as zu
	from kiosk_geldtransaktionen
	group by zunutzer_id
) as z
	using(id)