Need to upload bulk circular. The very same user need to pick them and enter details.

We have to add a good audit trail.

Log server time
IP address/ MAC address (need to get from client side by ? Java script?)
User

for all ADD, EDIT, DELETE functions !

For EDIT and DELETE we have to archive the old.

Since most of the code is written and database is designed;

My suggestion is,

1. Add a 'audit' table with five fields : audtoID, Time, IP Addr.............
2. Generate a record for each activity / button press
3. Add a required field for each other table and save the relevant autoID of the audit table record.

One circular can has one or more additional circulars.

Up to 10 key words.
Check English Spellings.
Only in Enlgish

Circulations marked each other as a translation

Need to add circular to be replace by another circular.

Have t differentiate circular letter from circular.

Circular need a circular number

in add circular page circular letter is in inputbox.

Wen entering a newcircular, after selecting data and signing authority, list a set of circulers already entered and ask whether not duplicates.

We can use the audit record and add one to each on the view events.

This way we can check number of such events per user.

To prevent bulk downloads;

???? before a download/view event check if x number of similar events per y time interval
x and y in a property file perhaps!

This to prevent more that x downloads/views per user per IP per y time interval.

hope i am clear enough.

Language Buttons

If possible search statistics.

All non internal circulars listed. Mark as only public circulars.

Latest 20 circulars

Popular circulars not needed

One circular can replace one or more circulars.
One circular can only be replaced by another one circular.

Need to keep a dictionary

Time
Signing Authority
Division
Keywords
Similarity Search