admin function to view user logs (name,type,date and time)

Post Reply
User avatar
viddz
Sergeant Major
Sergeant Major
Posts: 45
Joined: Fri Aug 26, 2011 6:06 am
Location: Colombo

admin function to view user logs (name,type,date and time)

Post by viddz » Sat May 05, 2012 2:20 am

I want build up administrator function to view user logs. Actually my intention here is to give admin opportunity to view who (user) is responsible for particular system activity like update stock, add new item etc... I got idea that if admin can view user logs (logs must contain username,type, date and time) then he can interpret who is responsible for that. Is there any good way to do that thing ?? Appreciate ur ideas.
User avatar
Saman
Lieutenant Colonel
Lieutenant Colonel
Posts: 828
Joined: Fri Jul 31, 2009 10:32 pm
Location: Mount Lavinia

Re: admin function to view user logs (name,type,date and time)

Post by Saman » Sat May 05, 2012 12:27 pm

I want build up administrator function to view user logs. Actually my intention here is to give admin opportunity to view who (user) is responsible for particular system activity like update stock, add new item etc... I got idea that if admin can view user logs (logs must contain username,type, date and time) then he can interpret who is responsible for that. Is there any good way to do that thing ?? Appreciate ur ideas.

In general inventory systems, this is a must have feature. Normally there is a separate table created as system_log or something and whenever someone logs in, from there onwards, all activity are logged until log-out. I'll list down some valuable fields.

| Entry_Date | Username | Activity | Description |

Entry_date is a date/time field. So exact time needs to be there along with date as well.
Activity is some common definitions such as LOG_IN, LOG_OUT, NEW_ITEM_ENTRY, NEW_STOCK_ENTRY, STOCK_ITEM_NAME_ADJUST, STOCK_QTY_ADJUST, NEW_GRN_ENTRY, NEW_INOVICE_ENTRY.......

Description is to identify the exact detail. For example, if the Activity is NEW_ITEM_ENTRY, you could add item code.

Is there anything else you need to know?
User avatar
viddz
Sergeant Major
Sergeant Major
Posts: 45
Joined: Fri Aug 26, 2011 6:06 am
Location: Colombo

Re: admin function to view user logs (name,type,date and time)

Post by viddz » Sat May 05, 2012 1:34 pm

ya.I got the concept. but still iam not clear how to code these things. System log should be kept without any input of user ne. That means automatically. I wonder how the code will look like? I have googled this but couldnt find an understandable code. If u have any links on this topic or some understandable codess pls put here. Thank u very much for ur helps saman. Iam refering u more than my supervisor. Really appreciate ur help thank u again
User avatar
Saman
Lieutenant Colonel
Lieutenant Colonel
Posts: 828
Joined: Fri Jul 31, 2009 10:32 pm
Location: Mount Lavinia

Re: admin function to view user logs (name,type,date and time)

Post by Saman » Sat May 05, 2012 4:07 pm

You are welcome buddy. That's the aim of ROBOT.LK. Help people like you to get on with technology matters and join the industry with confidence.

Okay.. regarding your question... As you said, yes users are not allowed to enter anything. It should be handled automatically by the code.

I'll add pseudo code of a scenario where a user adjust quantity of an item in stock.

Code: Select all

function Change_Quantity(user, i_code, old_quantity, new_quantity){

       // first adjust the stock record
       sql = "UPDATE stock_table SET quantity = new_quantity WHERE item_code = i_code";
       // execute the sql
       db_execute (sql);

        // Now add the log record
        sql = "INSERT INTO system_log VALUES(NOW(), user, "STOCK_QTY_ADJUST", i_code + " " + old_quantity + " " + new_quantity);
       // execute the sql
       db_execute (sql);
}
So you can notice in this case, at the time we adjust the stock record, we enter the log entry as well. I hope you now have a good picture.
User avatar
viddz
Sergeant Major
Sergeant Major
Posts: 45
Joined: Fri Aug 26, 2011 6:06 am
Location: Colombo

Re: admin function to view user logs (name,type,date and time)

Post by viddz » Sat May 05, 2012 4:58 pm

Thank u. Now i got it :yahoo: :yahoo:
Post Reply

Return to “PHP & MySQL”