18 lines
9.0 KiB
SQL
18 lines
9.0 KiB
SQL
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1, 101, 'admin', '管理员', 'sys_user', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '192.168.31.143', '2024-11-20 20:02:42', 'admin', '2024-01-05 12:51:55', 'admin', '2024-11-20 20:02:42', '管理员', null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (2, 101, 'test', '开发测试', 'sys_user', 'ry@qq.com', '15666666666', '0', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '2', '127.0.0.1', '2024-11-04 15:45:42', 'admin', '2024-01-05 12:51:55', 'test', '2024-11-04 15:45:42', '公司董事长', null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1743194569856708610, 100, 'boss', '高伟', 'sys_user', '**@163.com', '16000000000', '0', '', '$2a$10$BUg6mgJ2BW4peUa.n4d3PuU733DniPhH1xxlY4d82PDEpLtRDa64y', '0', '0', '127.0.0.1', '2024-11-20 20:02:59', 'admin', '2024-01-05 16:55:47', 'boss', '2024-11-20 20:02:59', null, null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1743201609278746626, 101, 'cfz', '陈副总', 'sys_user', '', '13211112222', '0', '', '$2a$10$GWwJ8esyXvP6zmzlHqP3U.S6Wml0u.6/j/pTrSdYDDdNrlcwXnl5y', '0', '2', '127.0.0.1', '2024-02-23 05:27:57', 'admin', '2024-01-05 17:23:45', 'cjg', '2024-02-23 05:27:57', null, null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1743202199652200449, 104, 'zzj', '郑总监', 'sys_user', '', '13211112277', '1', '', '$2a$10$vSKL2y7z2s.4aSmD0bIKa.17nAAR.uZzOuwhjUm9X4mnFmGEQ3ijC', '0', '2', '127.0.0.1', '2024-07-07 19:13:05', 'admin', '2024-01-05 17:26:06', 'zzj', '2024-07-07 19:13:05', null, null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1743206413589737474, 106, 'zjz', '杨莹', 'sys_user', '**#@163.com', '15622222222', '1', '', '$2a$10$OB0ZjKF4LMS0n0nfkiu3/ObGVYPzVd4qCs089uvNVaEuVC0MEIz.C', '0', '0', '127.0.0.1', '2024-07-07 18:49:22', 'admin', '2024-01-05 17:42:51', 'boss', '2024-11-18 16:01:12', '财务总监', null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1743206719782318081, 105, 'hzj', '洪总监', 'sys_user', '', '15655556666', '1', '', '$2a$10$UX/cRpllPIhpRht.8AG/zuy1LNeXXSmLVRy6MjQZIfV37TIGu3oGq', '0', '2', '127.0.0.1', '2024-07-07 18:48:29', 'admin', '2024-01-05 17:44:04', 'hm', '2024-07-07 18:48:29', '工程部总监', null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1743207433959043073, 104, 'lwy', '刘文员', 'sys_user', '', '13200000000', '1', '', '$2a$10$5siyeLjSa3pnNWiT8DC0O.ttfpe1GI9fooH2KZLkqsz35aeVzqPeC', '0', '2', '127.0.0.1', '2024-10-12 13:40:36', 'admin', '2024-01-05 17:46:54', 'lwy', '2024-10-12 13:40:36', null, null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1743208566391762945, 106, 'zcn', '张出纳', 'sys_user', '', '', '1', '', '$2a$10$8NTdLDTZGNdnrh1hj6p9HO9pXnv2HAuzweJdbz0BV/0nXGaoE6NFm', '0', '2', '127.0.0.1', '2024-07-07 18:55:49', 'admin', '2024-01-05 17:51:24', 'zxj', '2024-07-07 18:55:49', null, null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1743208755420655618, 105, 'hg', '黄工', 'sys_user', '', '', '0', '', '$2a$10$b/bSUgoFpXh.qyg61NGeyO0nvdzsinsOTAeV1z/NTT4DNXtSatmhu', '0', '2', '211.101.240.96', '2024-04-09 14:50:34', 'admin', '2024-01-05 17:52:09', 'hzj', '2024-04-09 14:50:34', null, null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1743266177543761922, 103, 'pbwyh', '评标委员会', 'sys_user', '', '', '2', '', '$2a$10$.F10BzVtRAus59F9zNltFudwOGgdyEsFkHlVGi7AiKqagWQw0WF4e', '0', '2', '127.0.0.1', '2024-07-07 19:14:48', 'admin', '2024-01-05 21:40:20', 'pbwyh', '2024-07-07 19:14:48', null, null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1852979651773759489, null, 'ceshiyuangong', '测试员工1', 'sys_user', '', '', '0', '', '$2a$10$RqP1OL90d7zMNDMXMZotf.Q31VnV4vc0OFTS6AmkY1DThn3nxfwuC', '0', '2', '', null, 'admin', '2024-11-03 15:42:30', 'admin', '2024-11-03 15:42:30', null, null, null, 1000);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1852984660972314625, null, 'xxxsad', 'asd', 'sys_user', '', '', '0', '', '$2a$10$IOI1ZcA8UngRx6oRnj9drOBvfLFo/N1.sqDJCPNRxLX0B4s5RLExm', '0', '2', '', null, 'admin', '2024-11-03 16:02:25', 'admin', '2024-11-03 16:02:25', null, null, null, 2000);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1853676948782415873, null, 'liguoyu', '李国瑜', 'sys_user', '', '', '0', '', '$2a$10$gFhWvrBCjibK9bsLCS0Nb.gUybaxvAqCXDZfj4k4d0I31VjKxZVMW', '0', '2', '', null, 'admin', '2024-11-05 13:53:19', 'admin', '2024-11-05 13:53:19', null, null, null, 1450);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1858417253738815490, 1858416909042524161, 'luyongqiang', '陆永强', 'sys_user', '1*********@qq.com', '15075462410', '0', '', '$2a$10$i7e9HJp5Kj4tBzeCwGmHmOAJkr.Aj/HZifyCuxKExl5Sd8ixa8hM2', '0', '0', '218.56.42.148', '2024-11-18 15:56:01', 'boss', '2024-11-18 15:49:36', 'luyongqiang', '2024-11-18 15:56:01', null, null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1858418260145283073, 1858416909042524161, 'zhouluying', '周陆莹', 'sys_user', '1301163343@qq.com', '18531811213', '1', '', '$2a$10$GSIPuCtFsRbWIu560BotguADQY6nM4F1fRcs5RHaFFa1pcD.Hz4hS', '0', '0', '', null, 'boss', '2024-11-18 15:53:36', 'boss', '2024-11-18 15:53:36', null, null, null, null);
|
|
INSERT INTO fad_oa.sys_user (user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark, id_card, bank_card, labor_cost) VALUES (1858421566972305409, 1858416909042524161, 'wangyu', '王宇', 'sys_user', '823267011@qq.com', '15690169553', '0', '', '$2a$10$Wjab9eSwqPxUQ6BmX2FQc.6JliXVggy9bDU1daERltOkgHV37zPyu', '0', '0', '', null, 'boss', '2024-11-18 16:06:44', 'boss', '2024-11-18 16:06:44', null, null, null, null);
|