-- -------------------------调度员账号密码过期时间更新---------------------------------------

UPDATE sd_user u,sd_org_info o SET u.update_pwd_time='2021-10-02 00:00:00' WHERE u.TAORGID=o.ID
AND o.ORGCODE in(
'0013',
'0008',
'0012',
'0007',
'0009',
'0002',
'0010',
'0011',
'0004'
);


UPDATE sd_user u,sd_org_info o SET u.update_pwd_time='2021-10-06 00:00:00' WHERE u.TAORGID=o.ID
AND o.ORGCODE ='0005';

UPDATE sd_user u,sd_org_info o SET u.update_pwd_time='2021-10-07 00:00:00' WHERE u.TAORGID=o.ID
AND o.ORGCODE ='0003';

UPDATE sd_user u,sd_org_info o SET u.update_pwd_time='2021-10-08 00:00:00' WHERE u.TAORGID=o.ID
AND o.ORGCODE ='0006';

UPDATE sd_user u,sd_org_info o SET u.update_pwd_time='2021-10-09 00:00:00' WHERE u.TAORGID=o.ID
AND o.ORGCODE ='0001';

UPDATE sd_user u,sd_org_info o SET u.update_pwd_time='2021-10-12 00:00:00' WHERE u.TAORGID=o.ID
AND o.ORGCODE ='00';


-- -------------------------查勘员账号密码过期时间更新---------------------------------------
UPDATE sd_survey s SET s.update_pwd_time='2021-10-02 00:00:00' WHERE s.ORG_CODE in(
'000103',
'0013',
'0008',
'0012'

);

UPDATE sd_survey s SET s.update_pwd_time='2021-10-06 00:00:00' WHERE s.ORG_CODE in(
'0007',
'0019'
);

UPDATE sd_survey s SET s.update_pwd_time='2021-10-07 00:00:00' WHERE s.ORG_CODE in(
'0002',
'0010'
);

UPDATE sd_survey s SET s.update_pwd_time='2021-10-08 00:00:00' WHERE s.ORG_CODE in(
'0005',
'0011'
);

UPDATE sd_survey s SET s.update_pwd_time='2021-10-09 00:00:00' WHERE s.ORG_CODE ='0006';

UPDATE sd_survey s SET s.update_pwd_time='2021-10-12 00:00:00' WHERE s.ORG_CODE ='0004';

UPDATE sd_survey s SET s.update_pwd_time='2021-10-13 00:00:00' WHERE s.ORG_CODE ='00';

UPDATE sd_survey s SET s.update_pwd_time='2021-10-14 00:00:00' WHERE s.ORG_CODE ='0003';

UPDATE sd_survey s SET s.update_pwd_time='2021-10-15 00:00:00' WHERE s.ORG_CODE ='0001' AND `SURVEY_ROLL` = '0';

UPDATE sd_survey s SET s.update_pwd_time='2021-10-16 00:00:00' WHERE s.ORG_CODE ='0001' AND `SURVEY_ROLL` != '0';