Skip to content

Instantly share code, notes, and snippets.

@4EverBuilder
Created April 21, 2016 20:31
Show Gist options
  • Save 4EverBuilder/bc36de7e456c0542fe1deaa43d33855b to your computer and use it in GitHub Desktop.
Save 4EverBuilder/bc36de7e456c0542fe1deaa43d33855b to your computer and use it in GitHub Desktop.
#Save it as Reccord After Save
empAgreement = db_record({system:"EmployeeAgreement" , id:CurrentRecord.EmployeeAgreement})
return 1 if !empAgreement
# is there a balance?
`<db_fetch system="LeaveAccrual" fetch="first_row" assign="lacc">
<db_condition>
<db_compare column="Employee" function="ge">
<atom var="empAgreement" index="EmployeeId"/>
</db_compare>
<db_compare column="LeaveRule" function="eq">
<atom var="CurrentRecord" index="LeaveRule" />
</db_compare>
</db_condition>
</db_fetch>`
return 1 if !lacc
data["Hours"] = lacc.Hours - CurrentRecord.Hours
data["Comment"] = "Balance adjustment due to leave approval-#{CurrentRecord.LeaveId}"
rest = deputy_rest({url:"resource/LeaveAccrual/#{lacc.Id}",post:data,method:"POST"})
return rest
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment