<srs label="API FORM" acl="public" id="501">
<def>
<itm model="param" name="form_xmldata" opts="json-xml-root" />
<itm model="param" name="form_uuid" />
<itm model="param" name="form_created_by">anonymous</itm>
<itm model="param" name="form_name">form</itm>
<itm model="param" name="form_type" />
<itm model="param" name="form_status" />
<itm model="column" name="form_xmldata" opts="tjson" lg="False" />
<itm model="column" name="form_uuid" lg="False" />
<itm model="column" name="form_id" label="NR ankiety" />
<itm model="column" name="form_type" label="Typ ankiety" />
<itm model="column" name="form_created_by" label="Wypełniona przez" />
<itm model="column" name="form_status" lg="False" />
<itm model="column" name="form_created_at" label="Wypełniona o" />
<itm model="command" name="get" opts="dtsingle get"><![CDATA[
-- [form_uuid],[form_name],[form_type],[form_xmldata],[form_status],[form_created_at],[form_created_by],[form_remote_id],[form_remote_source]
SELECT * from [app].[forms] where form_status > -1 and form_uuid = @form_uuid
]]></itm>
<itm model="command" name="post" opts="post"><![CDATA[
if @form_uuid is null
set @form_uuid = newid()
IF exists (select 1 from [app].[forms] where form_uuid = @form_uuid and form_status > -1)
BEGIN --Update
UPDATE [app].[forms] SET form_xmldata = @form_xmldata, form_status = @form_status, form_created_by = @form_created_by where form_uuid = @form_uuid
END
ELSE --Insert
BEGIN
INSERT INTO [app].[forms] (form_uuid, form_name, form_type, form_xmldata, form_created_by)
values (@form_uuid, @form_name, @form_type, @form_xmldata, @form_created_by)
print 'Thank you for your message; we will get back to you as soon as possible.'
END
]]></itm>
</def>
</srs>