Project/Contract Duration

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
maramk
Veteran Member
Posts: 38
Joined: 2013-08-13 11:19

Project/Contract Duration

Post by maramk » 2013-08-13 13:30

Dear All,

I do have 2 questions:

Question1:

I create a contract management system and part of the fields are in the contract table:

contract_start (date) - which is the date when the contract start
contract_expire (date) - which is the date when the contract expire

Now I also add: contract_duration (date) - which will calculate the date how long the contract exist (3, 6, 12 or 24 months based on the date)

which or how will the code look like to do the contract_duration function? - will it appear before, after insert etc?

Will the code be displayed in the contract hook table?

Question12:

I want to send an e-mail reminder/notification to the contract manager/project manager that the specific contract will expire in a months time , 2 weeks and a week - in other words how will the code then be written ?

I am new to appgini with regard to create additional php code snippets.

Thank you.

Kind regards,

maramk

Post Reply