Difference between revisions of "ETK"
From SPGC Document Wiki
| Line 13: | Line 13: | ||
# UPDATE myleave.myuser SET emppccd=2,myuseraccess="VIP" WHERE empnumb="123456" | # UPDATE myleave.myuser SET emppccd=2,myuseraccess="VIP" WHERE empnumb="123456" | ||
| + | |||
| + | == PAYROLL == | ||
Revision as of 15:47, 14 June 2016
Reset ETK password
- Open SQL Yog connect to 52 server
- Get the employee number
- Run this query
- UPDATE myleave.myuser SET password=md5("init1234") WHERE myusername="123456"
Transfer Employee from RNF to VIP
- Open SQL Yog connect to 52 server
- Get the employee number
- Run this query
- UPDATE myleave.olvemp SET emppccd=2 WHERE empnumb="123456"
- UPDATE myleave.myuser SET emppccd=2,myuseraccess="VIP" WHERE empnumb="123456"
