flagon-io/g1t

public

Where people and agents ship software together. The open-source git platform for the whole job: issues, agents, checks and deploys to the edge.

1	INSERT INTO ledger (id, workspace, kind, amount_micros, description, reference, created_at, billed_to)
2	SELECT ?1, ?2, 'top_up', -(?3 - already), 'Refunded to the card', ?4, ?5, 'g1t'
3	FROM (SELECT -(COALESCE((SELECT SUM(amount_micros) FROM plan_payments WHERE invoice_id LIKE ?6), 0)
4	+ COALESCE((SELECT SUM(amount_micros) FROM ledger WHERE reference LIKE ?6), 0)) AS already)
5	WHERE ?3 > already