codebang
Posts: 74
|
| Posted: 05/17/2010, 10:42 AM |
|
Dear all,
here is what i want to do.
I am opening a recruiting company and i am working on this small recruiting software. Now, i need to know how much work is getting done from each employee.
eg:
x person is data entry employee.he/she is supposed to input 50 CV's a day and only 20 were inputted to the database. how can i know exactly how much was inserted from my software.
I have the idea that i am supposed to get the user login details pass it to a control. the control then takes whatever value was given and then stores it in the database- to the related table.
Please feedback asap.
Regards.
|
 |
 |
datadoit
|
| Posted: 05/17/2010, 12:35 PM |
|
For all of the important tables in my database, I like to have the
following fields at the bottom of the table definition:
inserted_by (INT, 11, Default in CCS/PHP: CCGetUserID())
inserted_date (DATETIME, Default in Db definition: CURRENT_DATETIME)
updated_by (INT, 11, Default in CCS/PHP: CCGetUserID())
updated_date (DATETIME, Default in Db definition: CURRENT_DATETIME)
Then drop these fields on your record forms as hidden fields. With this
data, you can always run reports/queries from it to see who's doing
what, when and where.
If you feel real adventurous, create a log table for tracking beginning
and ending values, the field, the user, and the table. Something like:
session_id (VARCHAR, 50)
table (VARCHAR, 50)
field (VARCHAR, 50)
user_id (INT, 11)
begin (TEXT)
end (TEXT)
date (DATETIME)
but you'll have to write info to that log table everywhere you have an
add/edit/delete form. Good idea to build your own function, and call
the function with associative array values to populate the data in your
AfterExecuteInsert or AfterExecuteUpdate events in CCS.
Build the table as InnoDB so that complex indexing and searches can be
done later, and even rollback transactions. Since you're building from
scratch, I highly recommend building in this or similar logging feature.
|
|
|
|
JimmyCrackedCorn
Posts: 583
|
| Posted: 05/17/2010, 1:13 PM |
|
this is a really good suggestion. I have been thinking about adding something like this for awhile but your example gives me such a nice start that I'm adding it today!
you should write this up as a tip and post it! :) Thanks.
_________________
Walter Kempees...you are dearly missed. |
|
|
|
codebang
Posts: 74
|
| Posted: 05/18/2010, 12:50 AM |
|
Thanks a lot......... datadoit... miss u loads..... been some time
|
|
|
|
|
