[01/28/2022 10:23:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],update  `psa_users` set  `consultant_acc_id` ='008', `lname`='jain', `mname`='', `fname`='rinshi', `email`='rinshi.jain@qtechsoftware.com', `time_zone_offset`='5.5', `phone`='8770967336', `messenger_type`='', `messenger_id`='', `user_description`='this is from dalpatpur', `connection`='', `modify_by`='tfg', `user_type`='admin', `allow_book_under_cancellation`='1', `allow_cancellation_after_voucher`='1', `is_booking_email_received`='1', `all_bookings`='branch_booking', `designation`='', `updated`='2022-01-28 10:23:15', `modify_date`='2022-01-28 10:23:15'  where `site_id`='' and `id` ='rinshi' ;
[01/28/2022 10:23:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2022-01-28 10:23:15',`log_type`= 'User',`sql_query`= 'update  `psa_users` set  `consultant_acc_id` =:accounting_id, `lname`=:last_name, `mname`=:middle_name, `fname`=:first_name, `email`=:email, `time_zone_offset`=:time_zone_offset, `phone`=:phone, `messenger_type`=:messenger_type, `messenger_id`=:messenger_id, `user_description`=:user_description, `connection`=:connection, `modify_by`=:modify_by, `user_type`=:user_type, `allow_book_under_cancellation`=:allow_book_under_cancellation, `allow_cancellation_after_voucher`=:allow_cancellation_after_voucher, `is_booking_email_received`=:is_booking_email_received, `all_bookings`=:all_bookings, `designation`=:designation, `updated`=:updated, `modify_date`=:modify_date  where `site_id`=:site_id and `id` =:user_id ',`log_description`= 'User rinshi updated For  - updated=2022-01-28+09%3A26%3A17&allow_book_under_cancellation=&allow_cancellation_after_voucher= changed to - updated=2022-01-28+10%3A23%3A15&allow_book_under_cancellation=1&allow_cancellation_after_voucher=1&modify_by=tfg&modify_date=2022-01-28+10%3A23%3A15',`ip`= '43.239.53.130';
[01/28/2022 10:23:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],delete from `psa_users`  where id = 'rinshi';
[01/28/2022 10:23:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2022-01-28 10:23:54',`log_type`= 'User',`sql_query`= 'delete from `psa_users`  where id = :user_id',`log_description`= 'User rinshi has been deleted.',`ip`= '43.239.53.130';
[01/28/2022 10:27:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],insert into `psa_users` set  `id`='rinshi', `lname`='jain', `mname`='', `fname`='rinshi', `email`='rinshi.jain@qtechsoftware.com', `time_zone_offset`='5.5', `phone`='8770967336', `connection`='', `pass`='9483a8b20033db6ce69cf21ba46c70b6', `hash`='d112d997b275ac1e4ba49231be30f477', `user_type`='admin', `active`='Y', `can_debug`='', `allow_book_under_cancellation`='1', `allow_cancellation_after_voucher`='1', `all_bookings`='branch_booking', `is_booking_email_received`='1', `updated`='2022-01-28 10:27:05', `created_by`='tfg', `create_date`='2022-01-28 10:27:05', `site_id`='',`consultant_acc_id`='008',`consultant_image`='',`messenger_type`='',`messenger_id`='',`user_description`='from dalpatpur',`cal_hashcode`='da637ce0d5febfef273084e4af6baccf0371247aa83cb8e14f6ecba98c433be2',`designation`='';
[01/28/2022 10:27:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],insert into psa_pass_recover set  id = 'd112d997b275ac1e4ba49231be30f477' ;
[01/28/2022 10:27:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],DELETE FROM consultant_branches WHERE consultant_id ='rinshi';
[01/28/2022 10:27:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],INSERT INTO consultant_branches(consultant_id,branch_id,create_time,modified_time) SELECT 'rinshi','2','2022-01-28 10:27:05','2022-01-28 10:27:05';
[01/28/2022 10:27:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],INSERT INTO consultant_branches(consultant_id,branch_id,create_time,modified_time) SELECT 'rinshi','4','2022-01-28 10:27:05','2022-01-28 10:27:05';
[01/28/2022 10:27:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],INSERT INTO consultant_branches(consultant_id,branch_id,create_time,modified_time) SELECT 'rinshi','7','2022-01-28 10:27:05','2022-01-28 10:27:05';
[01/28/2022 10:27:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],update psa_users set groups='1' where id='rinshi';
[01/28/2022 10:27:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/user.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2022-01-28 10:27:05',`log_type`= 'User',`sql_query`= 'INSERT INTO consultant_branches(consultant_id,branch_id,create_time,modified_time) SELECT \&#039;rinshi\&#039;,\&#039;7\&#039;,\&#039;2022-01-28 10:27:05\&#039;,\&#039;2022-01-28 10:27:05\&#039;',`log_description`= 'User added For  -id=rinshi&groups=1&lname=jain&fname=rinshi&mname=&email=rinshi.jain%40qtechsoftware.com&time_zone_offset=5.5&enable_dst=0&phone=8770967336&pass=&hash=d112d997b275ac1e4ba49231be30f477&active=Y&connection=&lockcount=0&expiration=&updated=2022-01-28+10%3A27%3A05&branch_id=0&department_id=0&messenger_type=&allow_book_under_cancellation=1&allow_cancellation_after_voucher=1&all_bookings=branch_booking&site_id=0&user_type=admin&created_by=tfg&create_date=2022-01-28+10%3A27%3A05&consultant_acc_id=008&consultant_image=&cal_hashcode=da637ce0d5febfef273084e4af6baccf0371247aa83cb8e14f6ecba98c433be2&is_booking_email_received=1&messenger_id=&user_description=from+dalpatpur&can_debug=&designation=',`ip`= '43.239.53.130';
[01/28/2022 10:41:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logout.php],INSERT INTO psa_login_log set username = 'tfg' , user_type = 'tfg'_type , branch_id = '' , login_datetime = '2022-01-28 10:41:47' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/28/2022 10:59:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logout.php],INSERT INTO psa_login_log set username = 'rinshi' , user_type = 'rinshi'_type , branch_id = '2,4,7' , login_datetime = '2022-01-28 10:59:44' , ip = '43.239.53.130' , action = 'Logout'  ;
