Skip to content

UPDATE agreement.wait_fee_per_minute

Stable TMS_fleet Helsingin Matkapalvelukeskus car agreements are missing wait price (https://app.clickup.com/t/86bycxren) Stable TMS_Fleet Update Helsinki's car agreements' unset wait fee to a correct value (https://app.clickup.com/t/86byqrbpy)

UPDATE
    agreement
SET
    wait_fee_per_minute =
        price_per_second
            || CASE WHEN price_per_second->>'display_float' IS NOT NULL THEN jsonb_build_object('display_float', round(coalesce(price_per_second->>'display_float', '0')::numeric * 60, 9)::numeric) ELSE '{}'::jsonb END
            || jsonb_build_object('serialized', round(coalesce(price_per_second->>'display_float', '0')::numeric * 60, 2)::text)
            || jsonb_build_object('serialized_currency', round(coalesce(price_per_second->>'display_float', '0')::numeric * 60, 2)::text || ' €')
            || jsonb_build_object('units', split_part(round(coalesce(price_per_second->>'display_float', '0')::numeric * 60, 9)::text, '.', 1)::numeric)
            || jsonb_build_object('nanos', split_part(substring(round(coalesce(price_per_second->>'display_float', '0')::numeric * 60, 9)::text FROM position('.' IN round(coalesce(price_per_second->>'display_float', '0')::numeric * 60, 9)::text) + 1), '.', 1)::numeric) 
WHERE
     org_uuid = '1dfccc44-09c1-4e69-8554-3000cd2743f3' 
     AND coalesce(price_per_second->>'serialized', '0.00')::numeric > 0
     AND coalesce(wait_fee_per_minute->>'serialized', '0.00')::numeric = 0