刘琛运的技术文档

Appearance

11.7portal从0823后不能弹窗登录 ​

shiro.ini ​

usernmaepasswordrealm(GUEST):

0823:登录会走

lastest:点弹窗有，登录没有401，显示GUEST

watch com.supermap.services.security.UsernamePasswordRealm doGetAuthenticationInfo '{params,returnObj,throwExp}' -v -n 5 -x 3 '1==1'

pac4jRealm(登录会走):

watch com.supermap.online.security.pac4j.core.AdaptedPacRealm doGetAuthenticationInfo '{params,returnObj,throwExp}' -v -n 5 -x 3 '1==1'

5B05E8E80466BD846A44571014A0CBE7

casRealm(完全不走):

watch com.supermap.icloud.security.ICloudCasRealm doGetAuthenticationInfo '{params,returnObj,throwExp}' -v -n 5 -x 3 '1==1'

ldapRealm(登录有):

watch com.supermap.services.security.LdapRealm doGetAuthenticationInfo '{params,returnObj,throwExp}' -v -n 5 -x 3 '1==1'

F8D974A02F7E9696984A8E0382270D14

iServerPermissionRealm(登录有):

watch com.supermap.icloud.security.IServerPermissionRealm doGetPermissions '{params,returnObj,throwExp}' -v -n 5 -x 3 '1==1'

07DC468F3D59075A76A20B08BBF17066

iPortalPermissionRealm和iPortalManagerPermissionRealm(没有):

watch com.supermap.icloud.security.IPortalPermissionRealm doGetPermissions '{params,returnObj,throwExp}' -v -n 5 -x 3 '1==1'

登录后：

watch com.supermap.iportal.web.components.CasUserComponent parseCasAttributes '{params,returnObj,throwExp}' -v -n 5 -x 3 '1==1'

5D1D1FC181320EAC488EF39D231B4BAA

watch com.supermap.online.security.pac4j.core.PopupClosedCallbackLogic saveUserProfile '{params,returnObj,throwExp}' -v -n 5 -x 3 '1==1'

2686B4122635E7B9D63358ABA50239BA

1010302(旧)

message 3
sh_balance_integral_record 1
sh_license_trial_cart 1
sh_license_trial 2
sh_user_balance 1 20积分
_user_license_log 23
licenseapplylog 23
1010302	18476681891	1257417771@qq.com	18476681891	86	$2a$10$mHLvp2l5vR/xV7gkKcP.5OnGMLLoqnOlx5HdchY.Xf4yXtWUcYbNO	medium	拉拜膜	谭紫阳						header/main/default3.png	1	0		2022-05-23 15:46:47	2022-05-23 15:46:47	1	1

1027546（新）

sh_balance_integral_record 1
sh_user_balance 1 20积分
1027546	AAA小谭	ogc7u6eevsi2n_7to8qgiq3oxha8_icloud@isupermap.com			$2a$10$XDaymGH.JFrknQqZaxV0x.c0IY1ZWmaSHIrttiv3MoLmIjs17.Mw.	medium								header/main/default3.png	1	0		2022-10-21 09:57:51	2022-10-21 09:57:51	1	1

528396	1027546	WeChat	ogc7u6eevsi2n_7to8qgiq3oxha8	AAA小谭	2022-10-21 09:57:51

手机、邮箱

633406（旧） ​

633406	单车1	1260510277@qq.com	15912072102	86	$2a$10$tuV./M1I02rL/Eso3EtfDepTr.nKgZfWSaFS7lPIYDZotn4sRDGmW	weak	北京超图信息技术有限公司	张绍云						header/main/default3.png	1	0		2017-09-20 20:11:04	2017-09-20 20:11:04	1	1


359424	633406	QQ	28d7768f5db638bf233df8b3694fe174	单车1	2017-09-20 20:11:04
message 3
sh_license_trial 7

1007336（新）

1007336	单车2	ogc7u6qhh3gd3tpzehzcxfdcjngw_icloud@isupermap.com			$2a$10$gTi1IpDa9shCVWo4ej0pFu0Hdrxp9bUHYMglfVvtaSKOlYJdE3vNy	medium								header/main/default7.png	1	0		2022-04-29 09:17:32	2022-04-29 09:17:32	1	1


522740	1007336	WeChat	ogc7u6qhh3gd3tpzehzcxfdcjngw	单车2	2022-04-29 09:17:32

1013684(旧) ​

1013684	13140108130	13140108130_6059_phone@isupermap.com	13140108130	86	$2a$10$ttp6IBtL2KDeHAAlUCMhJ.wH33aUaQmM9nODr9KurI0lwTVaRNFbu	medium								header/main/default3.png	1	0		2022-06-21 12:19:13	2022-06-21 12:19:13	1	1
dataitems 3
directoryinfos 2
maps 3
mapvisitdetail 7 
message 3
permission 6
scene_access_record 3
tag 3
sh_balance_integral_record 1
sh_user_balance 1

1017151（新）

1017151	于涛1	ogc7u6x2ks7tc_sezxa1eqpi3jok_icloud@isupermap.com			$2a$10$36QNSrwsH10CeJrmK53AIeBI4uAh1SJvcOHE5FsPgTh5noafkmS9e	medium								header/main/default5.png	1	0		2022-07-26 17:16:02	2022-07-26 17:16:02	1	1

526295	1017151	WeChat	ogc7u6x2ks7tc_sezxa1eqpi3jok	于涛1	2022-07-26 17:16:02
dataitems 13
maps 4
mapvisitdetail 110
message 25
permission 17
tag 1

rc_picture 1
rc_res_purchase 1
sh_balance_integral_record 1
sh_user_balance 1

1022953（旧） ​

1022953	段善志	duanshanzhi@supermap.com	13730828922	86	$2a$10$AahzBHkET2KuS0vgEqTdHu39xyKsI9614W/b8PC6JumhhDnAxWq3K	medium								header/main/default8.png	1	0		2022-09-26 19:10:30	2022-09-26 19:10:30	1	1

992403（新）

992403	蘑菇进化史1	ogc7u6vlf0dro3-0mrircqqulkui_icloud@isupermap.com	13730828922	86	$2a$10$L53oOJ4CAoiABOjq3LMlj.KEE6GtYobDM0.SRRfK0sQ0rb1HnGV..	medium								header/main/default3.png	1	0		2021-11-03 14:53:00	2021-11-03 14:53:00	1	1


517611	992403	WeChat	ogc7u6vlf0dro3-0mrircqqulkui	蘑菇进化史1	2021-11-03 14:53:00

550261(旧) ​

550261	Bbig	13862169447_6503_phone@isupermap.com	13862169447	86	$2a$10$9pT5TGX2J4P1SnLA3AAL3eYine4r9K1Xz2RIdx2../UzTf0Hjjbjm	weak								header/main/default7.png	1	0		2017-06-01 09:51:59	2017-06-01 09:51:59	1	1

588961(新)

588961	我，是坏人	2849801090@qq.com	13862169447	86	$2a$10$36qSd3u1.hhK2Yl/3WlYAOgUS7Q4/AQddwpUrkPWLV93vT.snk/PS	medium								header/main/default6.png	1	0		2017-07-28 16:58:19	2017-07-28 16:58:19	1	1


330828	588961	QQ	b2dd9f6aefad70ecab18fd1123458d96	我，是坏人	2017-07-28 16:58:19
mapvisitdetail 2
message 6
rc_resource 2
sh_license_trial_cart 14
sh_user_balance 23积分

931154(旧) ​

dataitems 6
directoryinfos 2
insightsworkspaces 7
keycodes 2
maps  1
mapvisitdetail 2
permission 14
tag 7

sh_license_trial 2

204752(新)

没有

691645(旧) ​

691645	无乐不作	sunyinle@126.com	13718646153	86	$2a$10$lH2OhJtyOfZvty.MgNtXReTNNT2eSbfuWwR.qrUff2uFvUNXZPEIi	medium	超图软件	孙寅乐						header/main/default3.png	1	0		2018-01-05 09:38:38	2018-01-05 09:38:38	1	1
sh_license_trial_cart 7

25037(新)

25037	support_user23043	sunyinle@supermap.com	13718646153	86	$2a$10$YFgPrawm/55DIXu3fqMuK.F6py8KZsb1nXV3QTRgPkoTnEG8CQ/1S	medium	超图软件	孙寅乐						header/main/default6.png	1	0		2013-07-31 06:47:23	2013-07-31 06:47:23	1	1

1020050（旧） ​

1020050	yangdengxian	15911029237_7032_phone@isupermap.com	15911029237	86	$2a$10$VfIb963JIWjPZQFOvqqugeKriKZR54Y8PYqql/8BeANuxB6K6T/wy	medium								header/main/default3.png	1	0		2022-08-31 10:38:02	2022-08-31 10:38:02	1	1

81060（新）

81060	杨登贤	1053522419@qq.com	15911029237	86	$2a$10$ZjRXCRQCfo4aCTiWGhG3g.zNy20MVI.imRL3oeKulnBkLXph2bVBO	medium	云粒智慧	杨登贤						header/main/default6.png	1	0		2014-06-27 02:20:03	2014-06-27 02:21:00	1	1

1022665（旧） ​

1022665	yuchangjiu	yuchangjiu100@Hotmail.com	13880657399	86	$2a$10$rn8BhdTHbJjNjZ00uX6tJO5y5rrd7H.sx0SmWHXK/XpZPHLFK3raO	medium	成都中航智飞科技有限公司	余昌玖						header/main/default7.png	1	0		2022-09-26 10:09:37	2022-09-26 10:09:37	1	1
keycodes  1 100301
message 3(25896、33463、33780)
rc_resource 1 13347
sh_license_trial_cart 2 （6402、6476）
sh_user_balance 1（12281）

1026364（新）

1026364	胡杨树	yuchangjiu100@Hotmail.com	13880657399	86	$2a$10$JDGt9Orn4l51Wm0qqFCXwOhGlJlgFogeEqTvj4sdmEEf7fVlTNFVq	medium							1	1		2022-10-10 14:44:11	2022-10-10 14:44:11	1	0

999024(旧) ->(新号) ​

999024	miao1	316708673@qq.com	13951677791	86	$2a$10$Rn.A264T4ec2xARI.pMhn.JKqFVkEfnOj2KLb.sgpkGdyrJVFSEV.	medium	南京图叶信息科技有限公司	朱海勇						header/main/default3.png	1	0		2022-02-17 20:40:26	2022-02-17 20:40:26	1	1


519881	999024	QQ	92aeac6969d511dee8f279d5885246d9	miao1	2022-02-17 20:40:26

1029134（新） ->(旧号)

1029134	朱4	ogc7u6ayqifksbbzkucldkivazoo_icloud@isupermap.com	13951677791	86	$2a$10$Jrder21FXEqyDvoJgYaPiu2PaSE/dIqWBvO2hHCmsaRyy7xSXuXre	medium								header/main/default4.png	1	0		2022-11-07 13:48:24	2022-11-07 13:48:24	1	1

528834	1029134	WeChat	ogc7u6ayqifksbbzkucldkivazoo	朱4	2022-11-07 13:48:24
sh_license_trial_cart 1
sh_user_balance 1

1019553（旧）(没有积分表、积分消息) ​

1019553	zoutong	18601077196_1746_phone@isupermap.com	18601077196	86	$2a$10$DvHzfueWGDJUcezqSPJk0OL1GlGl8vr9G2OXr7Ku4I./ffDqBDc76	medium								header/main/default4.png	1	0		2022-08-25 14:37:49	2022-08-25 14:37:49	1	1
_user_license_log 40
licenseapplylog 40

1019551（新）

1019551	Tony带水1	fragile2001@163.com	18601077196	86	$2a$10$YBkCRyaxLLvQ59FbdZff3O4jUnSx1flESaIGx5GgEdTfpnJMOn9/6	medium		邹桐	142602197811280510	PERSONAL	2022-11-12 12:58:46			header/main/default3.png	1	0		2022-08-25 14:33:23	2022-08-25 14:33:23	1	1

527037	1019551	WeChat	ogc7u6zn-imogowcdzbu7_qbtujg	Tony带水1	2022-08-25 14:33:23

38223（旧） ->(新号) ​

38223	f1096	seasmil@163.com	18511301096	86	$2a$10$/a/wPwpSKG9iwAuXSED50.NVX56zJes/1ugd3n6/JwW/StLZX0daa	medium								header/main/default4.png	1	0		2013-12-05 06:43:09	2016-06-29 07:28:58	1	1

1017066（新） ->(旧号)

1017066	张超8	10543_icloud@isupermap.com	18511301096	86	$2a$10$wLAFTFCggjCuZp9Zmf5STuv/D7zjXZUA.YJZst3DvT/rnICQ6WVKW	medium								header/main/default4.png	1	0		2022-07-26 10:17:10	2022-07-26 10:17:10	1	1

526249	1017066	qiyeWechat	10543	张超8	2022-07-26 10:17:10
sh_license_trial_cart 2

651198（旧）->（互换） ​

651198	sun_tyz	1519122149@qq.com	13037816680	86	$2a$10$cb/CUjbLVDT7g2.B3q1YQuMIpf73nj5EPrbfFX0hE.dtAvFLk/rJ.	medium	太空	田永周						header/main/default5.png	1	0		2017-10-25 08:40:37	2017-10-25 08:40:37	1	1
mapvisitdetail 2
sh_license_trial 2

263299(新)

263299	tianyongzhou	1061447280@qq.com	13037816680	86	$2a$10$7Knyssb/XVQsithI1vvWg.DR6r3MC.QkrT5dpvTHxQbCicwFdaje.	medium								header/main/default8.png	1	0		2015-10-14 21:58:24	2015-10-14 21:58:24	1	1

1000136（旧）(没有积分) ​

1000136	可以奋斗	15285078318_7823_phone@isupermap.com	15285078318	86	$2a$10$vTa4iRw0aKXQKmCz91FatOjAIBXGbw.30umyHBlOUyNRPPRdFSsJy	medium								header/main/default4.png	1	0		2022-03-02 21:37:25	2022-03-02 21:37:25	1	1
dataitems 2
directoryinfos 1
keycodes 1
permission 2

422709 （新）(没有积分)

422709	keyifendou	875668437@qq.com	15285078318	86	$2a$10$f6mDXSTPjbFrMt5gzFsgXe3ZiswSjJti/QTwDxUqVeE/R/mhrCvBi	medium								header/main/default3.png	1	0		2016-10-25 01:06:14	2016-10-26 07:13:36	1	1
dataitems 5
directoryinfos 1
keycodes 1
mapvisitdetail 1
permission 5

1022743（旧） ​

1022743	童磊	tonglei@supermap.com	13281278867	86	$2a$10$2yduzRt3N/3vKQwDDKcYgO4sSH2AAQ/LCEYs4D.G2cgi0OUGxcroi	medium								header/main/default5.png	1	0		2022-09-26 14:16:00	2022-09-26 14:16:00	1	1

886260（新）

886260	3857	13281278867@163.com	13281278867	86	$2a$10$vplbewWuEXgMNdhTplaiU.Z/f8zEdff2NiuWOPjifuKB9aRE4mfxy	medium								header/main/default3.png	1	0		2018-09-29 15:21:46	2018-09-29 15:21:46	1	1

1022177(旧) ​

1022177	珡ing	57e7cedb8e55f92b49c30b2a3bbd7971_icloud@isupermap.com	15161602651	86	$2a$10$ttEczTxYFUHVSkCdNrJ9YuZaQMx4g5NLqzsUL2VFmsR0AS/7PjJfO	medium	四川建筑职业技术学院	杨玉琴						header/main/default3.png	1	0		2022-09-20 16:58:55	2022-09-20 16:58:55	1	1
dataitems 5
directoryinfos 1
map_dashboard 1
maps 5
mapvisitdetail 11
message 7
permission 11
tag 5

1027434（新）

1027434	琴1	ogc7u6zip-h-8clbxpsuefcqut7q_icloud@isupermap.com	15161602651	86	$2a$10$Z6AuNBpOnj2wBRxFCRDxtelw2RrloU6kwW5.M3OQ/.nvW5ULaPwfW	medium								header/main/default4.png	1	0		2022-10-19 21:36:21	2022-10-19 21:36:21	1	1

528362	1027434	WeChat	ogc7u6zip-h-8clbxpsuefcqut7q	琴1	2022-10-19 21:36:21
dataitems 2
directoryinfos 1
maps 2
mapvisitdetail 5
message 2
permission 4
 tag 2

1004435（旧） ​

1004435	robertliesc	15874257495_8035_phone@isupermap.com	15874257495	86	$2a$10$qOzhG1ohbDxFT0krHjZC4eQSyZvgmYKZXcaTtcMb2vYTm3yWtKdmm	medium								header/main/default6.png	1	0		2022-04-08 21:25:28	2022-04-08 21:25:28	1	1
_user_license_log 32
licenseapplylog 32

846908（新）

846908	roberlics	robertlics@163.com	15874257495	86	$2a$10$4Oe3sqaeeLwSH5fLjJB6zOC4OzBP8my1MHiJtrW/bMIQvDtYPrlmC	medium								header/main/default7.png	1	0		2018-08-02 13:24:50	2018-08-02 13:24:50	1	1

982901（旧） ​

982901	呱呱蛙	2508483009@qq.com	17612976726	86	$2a$10$iPNUzpwcDx5ivZtjAtMaQ.PSpcGnkHExwZN4pNn9/nrBwd1FHHT6q	medium	在校学生	张晟宇						header/main/default5.png	1	0		2021-06-20 17:21:04	2021-06-20 17:21:04	1	1

514835	982901	QQ	8e9c8e2861a48fb5114c0ae8af45cd5d	呱呱蛙	2021-06-20 17:21:04
sh_license_trial 2
_user_license_log 4
licenseapplylog 4

999658（新）

999658	ZSY4	ogc7u6buyw_d9yvdxb8tt33h22r0_icloud@isupermap.com	17612976726	86	$2a$10$L1Pcn2co82vOm53xHX2jPOXh9/TCjrOpDs9pLNq.eKrvfgJ0yUzgK	medium	集云测绘	张晟宇						header/main/default3.png	1	0		2022-02-26 20:28:30	2022-02-26 20:28:30	1	1

520088	999658	WeChat	ogc7u6buyw_d9yvdxb8tt33h22r0	ZSY4	2022-02-26 20:28:30

773797(旧) ​

773797	gaojianyan	314020190@qq.com	18501047026	86	$2a$10$SHNMTBMDDkFj6vMuEJx9pelqpBldeDYB9ZhF4Fr2vyJdpEFmEkDHm	medium	超图软件	高建燕						header/main/default8.png	1	0		2018-05-08 17:01:27	2018-05-08 17:01:27	1	1
message 2
sh_license_trial 9

965930（新）

965930	高建燕	ogc7u6syirkb7wtid75sxnojsqvg_icloud@isupermap.com	18501047026	86	$2a$10$eaeCvTQemuxlU5LVCFOXlujI.ZVhJNjREQXkr2zTXz7EnhFJz8KUC	medium	超图软件	高建燕						header/main/default8.png	1	0		2020-10-09 09:42:19	2020-10-09 09:42:19	1	1

510171	965930	WeChat	ogc7u6syirkb7wtid75sxnojsqvg	高建燕	2020-10-09 09:42:19

1011068（旧） ​

三方申请合微信，微信号没数据

1011068	三不金刚	ogc7u6wqmtwymeds1-wpagraby2g_icloud@isupermap.com			$2a$10$lqyQZZ8VB5ybpF6znuLN0OlZmFhcWG..pwiEx1ymeHingWQ8HFSBW	medium								header/main/default8.png	1	0		2022-05-29 12:21:33	2022-05-29 12:21:33	1	1

524086	1011068	WeChat	ogc7u6wqmtwymeds1-wpagraby2g	三不金刚	2022-05-29 12:21:33

942007（新）

942007	菩提大仙	wzy720301@163.com	13370892288	86	$2a$10$I023sm/GixRR7yAUG09nwuLZ75ff9UdS4x/Mc3Wh8JIUwkxKD6IeW	medium	青岛未来城管委	王智勇	420111197203015777	PERSONAL	2022-11-19 17:14:45			header/main/default3.png	1	0		2019-08-15 17:47:29	2019-08-15 17:47:29	1	0

1015233（旧） ​

1015233	相思	593862415@qq.com	13653363408	86	$2a$10$oxcrP4m4oSrDbfAydgCaOunNdvfQT0ZHId6wRoY5YXSX9oeHIQZE6	medium	国能网信科技有限公司	冯贺						header/main/default3.png	1	0		2022-07-06 11:01:03	2022-07-06 11:01:03	1	1

525654	1015233	QQ	2ae806b79d5ca9268dda633d9d3d4ece	相思	2022-07-06 11:01:03
message 5
sh_license_trial 2

1028426（新）

1028426	冯贺1	ogc7u6frtlaphbci8mwcjhcgid2q_icloud@isupermap.com	13653363408	86	$2a$10$Od9xs71ZAGk1hm2.QsWPQ.VioAb5PUVsD4dyV/SJ9Ln.FtQqmNDwm	medium								header/main/default5.png	1	0		2022-10-30 16:30:39	2022-10-30 16:30:39	1	1

528635	1028426	WeChat	ogc7u6frtlaphbci8mwcjhcgid2q	冯贺1	2022-10-30 16:30:39

650153(旧) ​

650153	fad_web	18629006835_5960_phone@isupermap.com	18629006835	86	$2a$10$5yjIWRHaUEAjhDxfn2yoveIGjjG/kIu7kQSKG.XInJYAqk2cUEyPO	medium	yuner	宁兴伟						header/main/default5.png	1	0		2017-10-23 14:39:00	2017-10-23 14:39:00	1	1
message 3
sh_license_trial 16

968669（新）

968669	祗染青春1	ogc7u6snuosx8-oucj8jr_jvinfe_icloud@isupermap.com	18629006835	86	$2a$10$S8iSWWPjOK/A/j/cNbVeaO3p3ofr/98Wmu15/Bf5Hn238FuFl4khe	medium	陕西云尔信息技术	宁兴伟						header/main/default3.png	1	0		2020-11-17 19:46:00	2020-11-17 19:46:00	1	1

510909	968669	WeChat	ogc7u6snuosx8-oucj8jr_jvinfe	祗染青春1	2020-11-17 19:46:00

244509 (旧) ​

244509	枫岚露123	249313173@qq.com	15531192963	86	$2a$10$riyWm9t71Hvb0zUNE62RFuE6oooEAWP7gIWi0fQKGd7mzVpACf8Pu	medium	河北工程大学	智烈慧						header/main/default5.png	1	0		2015-09-06 03:34:53	2015-09-06 03:34:53	1	1

712245（新）

712245	fenglanlu	zhiliehui1991@163.com	15531192963	86	$2a$10$bQkGpunpLOdesmTTjpoXkeblSen19ORHNOQuzO.G2Lw5AlLbEyKrK	medium	河北工程大学	智烈慧						header/main/default7.png	1	0		2018-02-07 15:41:28	2018-02-07 15:41:28	1	1

940815(旧) ​

940815	yxhhhh	1498795861@qq.com	18851970262	86	$2a$10$dWjRWlHojsZ52e3HRyZ52eu3d7BU3Zc227mq4eyLp9mHnqyRyd/Jq	medium	南京信息工程大学	杨轩						header/main/default5.png	1	0		2019-07-26 14:40:34	2019-07-26 14:40:34	1	1
mapvisitdetail 1
scene_access_record  5

1008286（新）

1008286	小恶魔2	ogc7u6cquz7w2uupeivn892hnoxy_icloud@isupermap.com	18851970262	86	$2a$10$gwO6lxZOYgLT1VY.MuLnXeF89RzQk5PY00MEjqTTe4KWfP03ikasy	medium								header/main/default6.png	1	0		2022-05-08 21:00:15	2022-05-08 21:00:15	1	1

523114	1008286	WeChat	ogc7u6cquz7w2uupeivn892hnoxy	小恶魔2	2022-05-08 21:00:15

986047(旧) ​

986047	李龙轩202433	18392001471_8476_phone@isupermap.com	18392001471	86	$2a$10$fmA30fsPcRQ6EnYrvwGbVOfB1khHcZluuQlfi.OohigSfaGNSZua6	medium	天元	李龙轩						header/main/default4.png	1	0		2021-08-09 09:11:17	2021-08-09 09:11:17	1	1

991102（新）

991102	李龙轩1	ogc7u6a-sjg6hmgqfd2s0rnepije_icloud@isupermap.com	18392001471	86	$2a$10$EiKXChq4K0jdQoHN9FoWGe4M24x06ZTuzT40h/aIaYBfYkKJAv9nC	medium	泽源	李龙轩						header/main/default3.png	1	0		2021-10-16 12:04:48	2021-10-16 12:04:48	1	1

517227	991102	WeChat	ogc7u6a-sjg6hmgqfd2s0rnepije	李龙轩1	2021-10-16 12:04:48

select * from users where nickname = '崔志文'; ​

select * from users where nickname = '_崔志文'; select * from users where nickname = '崔志文1';

SELECT * FROM authentications where user_id = 1015183; SELECT * FROM authentications where user_id = 1015185; SELECT * FROM authentications where user_id = 1020385;

1015183	崔志文	ogc7u6s3hjijwtnsv_6otdh1jk5y_icloud@isupermap.com			$2a$10$iyjsx93nvg0X2m//.UKTxevyuCe2s3gRzs88lbasFHI8M.6NqLs/q	medium	1234	崔志文						header/main/default6.png	1	0		2022-07-05 21:07:57	2022-07-05 21:07:57	1	0


1015185	_崔志文	18109429329_4213_phone@isupermap.com	18109429329	86	$2a$10$0aKbtEWPiaqYwOlAA9WKI.zwhvkTYZSw1QT/s9I5i2lwOUrygkOYm	medium								header/main/default5.png	1	0		2022-07-05 21:14:41	2022-07-05 21:14:41	1	0

1020385	崔志文1	f379fab952db468496eb65ac2f1b73e8_icloud@isupermap.com			$2a$10$0QM9Z/AfhFhAYkaTuLQhzO258GxfZtOoBujK3/xyf3eO0FIrPn9ge	medium								header/main/default6.png	1	0		2022-09-02 18:06:43	2022-09-02 18:06:43	1	0


525635	1020385	WeChat	ogc7u6s3hjijwtnsv_6otdh1jk5y	崔志文	2022-07-05 21:07:57
527240	1020385	QQ	f379fab952db468496eb65ac2f1b73e8	崔志文1	2022-09-02 18:06:43

1019416(旧) ​

1019416	张言哲	ogc7u6bqiglm-uo3iehtess5fng0_icloud@isupermap.com			$2a$10$lwke8PVe66fIRfB19sYJ9.CNAtNCU8yaOvt1CsnMHaABScgRyv6tu	medium								header/main/default3.png	1	0		2022-08-24 09:26:43	2022-08-24 09:26:43	1	1

527000	1019416	WeChat	ogc7u6bqiglm-uo3iehtess5fng0	张言哲	2022-08-24 09:26:43

1030499（新）

1030499	18510452020	gishpuzyz@163.com	18510452020	86	$2a$10$Op6JHFP/Ib0QMC7hjU57D.AHnbGkAVb7fufn5CWrpZlgO7K9d.psG	medium								header/main/default3.png	1	0		2022-11-21 18:38:00	2022-11-21 18:38:00	1	0

934171(旧) ​

934171	寒寒2	yubr@antu.com.cn	18623063090	86	$2a$10$ng0sNr3gHK3GYvORc0XFo.XXPWLAXKGyCDWozdBZxcsv03vne.HNu	medium	安图	余保荣						header/main/default6.png	1	0		2019-04-24 13:52:14	2019-04-24 13:52:14	1	1

498372	934171	QQ	f2960cc8b3cbc716ff73d754c5338022	寒寒2	2019-04-24 13:52:14
sh_license_trial 22  215676-409041
sh_user_balance 26

352715（新）

352715	bolon	895302288@qq.com	18623063090	86	$2a$10$hXitG4z2fDuPLFnxV8aDLeoBnJXKp.v2.sa8wSE3b8qk7SXr5HuTa	medium	安图	余保荣						header/main/default7.png	1	0		2019-04-24 13:58:37	2019-04-24 13:58:37	1	1
sh_user_balance 20积分

960491（旧） ​

960491	沉潜1	6a58f9ab7a6b61a3048b0a9937c7b1c8_icloud@isupermap.com	18855057795		$2a$10$cArZRVL21mh/BIvcslNUf.ZO1/LIkQlMba.Bqhb8BZNyyK2w5T/GG	medium	gtkl	乐乐						header/main/default8.png	1	0		2020-07-02 13:29:05	2020-07-02 13:29:05	1	1

508380	960491	QQ	6a58f9ab7a6b61a3048b0a9937c7b1c8	沉潜1	2020-07-02 13:29:05
sh_license_trial 3

987560（新）

987560	沉潜2	chenleilei@gtmap.cn	18855057795	86	$2a$10$Me2qJ01gs3S7ctE8TPioy.MVgrkGVmuWcIgBDR.ewAhG08Wzg/R4m	medium	南京国图	陈磊						header/main/default5.png	1	0		2021-08-30 09:10:07	2021-08-30 09:10:07	1	1

516219	987560	WeChat	ogc7u6fkng9rg1kt8gl7ifnnntka	沉潜2	2021-08-30 09:10:08

993805 （旧） ​

993805	yunhetj	13032270106_4560_phone@isupermap.com	13032270106	86	$2a$10$i8L.zDuB//6YGPSg.Bb36eB3LjqW4dr3yugVZ.raPVDfJeI.eEzDy	medium								header/main/default4.png	1	0		2021-11-22 22:22:00	2021-11-22 22:22:00	1	1

113447（新）

993805	yunhetj	13032270106_4560_phone@isupermap.com	13032270106	86	$2a$10$i8L.zDuB//6YGPSg.Bb36eB3LjqW4dr3yugVZ.raPVDfJeI.eEzDy	medium								header/main/default4.png	1	0		2021-11-22 22:22:00	2021-11-22 22:22:00	1	1

961056（旧） ​

961056	松鼠爱犬	6df163d58856e1bbabb3487ba55d742d_icloud@isupermap.com	15527345132		$2a$10$LHMaZV8mFRn8LYgIAE9/vOhedL6gCJxP7LHkkKFEZpQusB5Tk2hiq	medium	黑龙江基础地理信息中心	宋帅全						header/main/default3.png	1	0		2020-07-11 14:29:13	2020-07-11 14:29:13	1	1

508596	961056	QQ	6df163d58856e1bbabb3487ba55d742d	松鼠爱犬	2020-07-11 14:29:13

968890（新）

968890	宋帅全	ogc7u6ufw3r3woxvmachqjkmmuko_icloud@isupermap.com	15527345132	86	$2a$10$kIZi5dSCNdAxJwQSdipHyeueU9NLdZNFPUMc2IyQDwu1E/xtrf2DG	medium	黑龙江基础地理信息中心	宋帅全						header/main/default6.png	1	0		2020-11-21 08:18:38	2020-11-21 08:18:38	1	1

510995	968890	WeChat	ogc7u6ufw3r3woxvmachqjkmmuko	宋帅全	2020-11-21 08:18:38

999551（旧） ​

999551	是为自由故	493333052@qq.com	18142385016	86	$2a$10$5l6F4Nzamsv74rcjDs2neeAGptwkG3Zl4azzVK6uiROBa30O6sePW	medium	成都越创	董锐						header/main/default6.png	1	0		2022-02-25 10:23:35	2022-02-25 10:23:35	1	1

520047	999551	QQ	d4c42a0c846942c532e1f1726c1d0fb4	是为自由故	2022-02-25 10:23:35

1028860（新）

1028860	游客17592308	ogc7u6sf0i_wo1ymcyen5xyhou_i_icloud@isupermap.com	18142385016	86	$2a$10$vhKml9jPKUeReHNzFtwpoOabKSRYkEYelx0EI3CfgA5FIwOVMiIly	medium								header/main/default3.png	1	0		2022-11-03 16:12:25	2022-11-03 16:12:25	1	1

528751	1028860	WeChat	ogc7u6sf0i_wo1ymcyen5xyhou_i	游客17592308	2022-11-03 16:12:25

999385(旧) ​

999385	Sherry青草湖	2428827851@qq.com	17527663210	86	$2a$10$RNlHVCOfQG9Mjwms2ht8ZukvmEs04ibAqfPf8mY7jNjbTAYoLXgFu	medium	郑州师范学院	陈金娴						header/main/default3.png	1	0		2022-02-23 19:58:24	2022-02-23 19:58:24	1	1

1007513（新）

1007513	FearlessGirl	ogc7u6tse-v70k32ek91saqjqelw_icloud@isupermap.com	17527663210	86	$2a$10$w0C.1R9ZIyrFNm7Ceqbz1OJq7349DB8WBBg7mMUfqGM9KCCKpXDDG	medium	郑州师范学院	陈金娴						header/main/default6.png	1	0		2022-04-30 16:29:19	2022-04-30 16:29:19	1	1

522813	1007513	WeChat	ogc7u6tse-v70k32ek91saqjqelw	FearlessGirl	2022-04-30 16:29:19

1000182(旧)

1000182	SuperMap_ls	15988088122_6327_phone@isupermap.com	15988088122	86	$2a$10$gYhC5AdoeUWcMrRvtPD8n.anYf1koJgGFsys8byOlUAvODAVyHSeq	medium	信息中心	陈再辉						header/main/default4.png	1	0		2022-03-03 11:27:42	2022-03-03 11:27:42	1	1

1011097（新）

1011097	hui7	ogc7u6rrmus5vau2puvkhui-nsac_icloud@isupermap.com	15988088122	86	$2a$10$YnlE6CaowphDmzpTZrtRjOBB15uCPBF1JcLvz08Vrpz4lH2skqcw2	medium	信息中心	陈再辉						header/main/default8.png	1	0		2022-05-29 20:36:45	2022-05-29 20:36:45	1	1

524105	1011097	WeChat	ogc7u6rrmus5vau2puvkhui-nsac	hui7	2022-05-29 20:36:45

1007929(旧) ​

1007929	胡图图不糊涂	17693132335_9653_phone@isupermap.com	17693132335	86	$2a$10$J.0kBdWFny/RgPHYElTopOA0eURUKezCqPE7JnEuKPwbwIWgQvm0y	medium								header/main/default4.png	1	0		2022-05-05 17:54:46	2022-05-05 17:54:46	1	1
map_dashboard 1 1229052710

1028468（新）

1028468	胡图图1	ogc7u6ztam4uudx-idgp7yrwlv1k_icloud@isupermap.com	17693132335	86	$2a$10$.SyfL2ZQHCU8R2S6Vvk/Lun8A2AvoMrIP6lQS6lzfsJDT9R8j1/86	medium								header/main/default7.png	1	0		2022-10-31 09:14:27	2022-10-31 09:14:27	1	1

528644	1028468	WeChat	ogc7u6ztam4uudx-idgp7yrwlv1k	胡图图1	2022-10-31 09:14:27

934307(旧) ​

934307	hello_你好	18271897953_5267_phone@isupermap.com	18271897953	86	$2a$10$kJkm21sU5amzugR8DaYN8OuBIHqQFgLHsNhuT5yAQ3VK3gwyBgVw6	medium								header/main/default4.png	1	0		2019-04-25 18:08:31	2019-04-25 18:08:31	1	1

969031（新）

969031	超5	ogc7u6djdnaavsfbdsxdwe9gtfos_icloud@isupermap.com	18271897953	86	$2a$10$cGITdAQZ8XlTThV8hgsb2.WoQE5OqJNk4nr30NHhRksdwbgtIidmG	medium								header/main/default3.png	1	0		2020-11-24 10:01:05	2020-11-24 10:01:05	1	1

511040	969031	WeChat	ogc7u6djdnaavsfbdsxdwe9gtfos	超5	2020-11-24 10:01:05

980553（旧） ​

980553	peizhijia	520049492@qq.com	15202007520	86	$2a$10$IuI9Yt4EOEigaRO9az7I2uFXLntHhGek3IWSvMV1GzDfpzYiMReC6	medium	广州浩传网络科技有限公司	裴志加						header/main/default5.png	1	0		2021-05-18 14:04:16	2021-05-18 14:04:16	1	1

980552（新）

980552	裴	ogc7u6w-g9hhdagrfdspp-mqroqy_icloud@isupermap.com	15202007520	86	$2a$10$70iC8bhYZ/GuRozq9MhGXuNYBF8y6Qpdgg4o6RsBcKfpaboVdf.PS	medium								header/main/default4.png	1	0		2021-05-18 14:02:54	2021-05-18 14:02:54	1	1

514142	980552	WeChat	ogc7u6w-g9hhdagrfdspp-mqroqy	裴	2021-05-18 14:02:54

1029321（旧） ​

1029321	liuxiaoyi		15756789169	86	$2a$10$QnUK9DA11x1flF6TV58t9eoiwGXYYD5AsUQk54TB5B6R5UsgDeSTm	weak								header/main/default3.png	1	0		2022-11-09 10:08:33	2022-11-09 10:08:33	1	1

949941（新）

949941	刘LXY	liuxiaoyi@supermap.com	15756789169	86	$2a$10$LNg93CYGE6gVkHVFb/bhzeam042E82Kh77K.NoN2HP8K7gOwtMxgS	medium	北京超图软件	刘枭懿						header/main/default7.png	1	0		2020-01-05 15:29:37	2020-01-05 15:29:37	1	1