
#超时未持证保安员天数设置
delete from `config` where `key` = 'person_outtime';
INSERT INTO `config` (`key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
VALUES ('person_outtime', '20', '超时未持证保安员天数设置', '', now(), now(), 'system');

#入职时间没有值。设为创建时间
update security_person p,`user` u
set entrydate=CONCAT(LEFT(create_time,10),' 00:00:00')
where entrydate is null and p.user_id=u.id;

