说明 / 示例
https://blog.csdn.net/qq_33157666/article/details/86735906
https://blog.csdn.net/qq_37372007/article/details/81586751
https://blog.csdn.net/hongtaolong/article/details/83451507
https://blog.51cto.com/13760351/2382103
http://www.manongjc.com/article/27510.html
https://www.cnblogs.com/YatHo/p/6647561.html?utm_source=itdadao&utm_medium=referral
https://blog.csdn.net/Try_harder_every_day/article/details/79170065
b73b5caf42e711e98d74c7de3a573203
b73b5caf42e711e98d74c7de3a573203
申请台账信息查询：
SELECT MA.BILL_MAIN_ID, MA.BILL_CODE, MA.BILL_TYPE_MAJOR, MA.BILL_STATUS, MA.APPLICANT_ID, SU.ID AS APPLICANT_NAME, MA.APPLICANT_DEPARTMENT_ID, MA.APPLICANT_POST_ID, MA.APPLICANT_RANK_ID, MA.APPLICANT_ORG_ID, MA.APPLICANT_DATE, MA.SUM_AMOUNT_CURRENCY_ID AS BILL_CURRENCY_ID, DC.SIGN AS BILL_CURRENCY_SIGN, BAF.DATA_TYPE AS DATA_TYPE, CASE WHEN BAF.DATA_TYPE = 'MONEY' THEN DC.ACCURACY ELSE BAF.DECIMALS END AS ACCURACY, DC.HASTHOUSANDDIVIDE as HAS_THOUSAND_DIVIDE, CASE WHEN BAF.DATA_TYPE = 'MONEY' THEN MA.SUM_AMOUNT ELSE MA.SUM_VALUE END AS BILL_AMOUNT, CASE WHEN ((D.SUM_AMOUNT_FIELD_ID IS NULL) OR (LENGTH(TRIM(D.SUM_AMOUNT_FIELD_ID))=0)) AND ((D.SUM_AMOUNT_AREA_ID IS NULL) OR (LENGTH(TRIM(D.SUM_AMOUNT_AREA_ID))=0)) THEN 'FALSE' ELSE 'TRUE' END AS AMOUNT_DISPLAYED, MA.USERS_ID, MA.DESCRIPTION, MA.BILL_DEFINE_ID, MA.BILL_DEFINE_HISTORY_ID, MA.BILL_DEFINE_ID AS BILL_DEFINE_NAME
FROM T_BILL_MAIN_AREA MA
LEFT JOIN T_BILL_DEFINE D
ON MA.BILL_DEFINE_ID = D.BILL_DEFINE_ID
LEFT JOIN T_BILL_TYPE T
ON T.BILL_TYPE_ID = D.BILL_TYPE_ID
LEFT JOIN T_SYS_USER SU
ON MA.APPLICANT_ID = SU.ID
LEFT JOIN T_DIM_CURRENCY DC
ON MA.SUM_AMOUNT_CURRENCY_ID = DC.ID
LEFT JOIN T_BILL_AREA_FIELD BAF
ON BAF.BILL_AREA_FIELD_ID = D.SUM_AMOUNT_FIELD_ID
WHERE T.BILL_TYPE_MAJOR = 'MAJOR_TYPE_SQ' AND MA.APP_ID = 'b73b5caf42e711e98d74c7de3a573203' AND MA.BILL_STATUS !='DELETE' AND (MA.CREATOR_ID = '0a3303addeab11e984f43b4f08c62ac0' OR MA.APPLICANT_ID = '0a3303addeab11e984f43b4f08c62ac0') ORDER BY MA.APPLICANT_DATE DESC, MA.CREATE_DATE DESC
LIMIT 20;
端口查询
[root@localhost application]# lsof -i:8083
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
java 19291 root 14u IPv6 1078614 0t0 TCP *:us-srv (LISTEN)
[root@localhost application]# lsof -i:8087
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
java 19374 root 14u IPv6 1079704 0t0 TCP *:simplifymedia (LISTEN)
https://github.com/Tencent/vConsole
http://127.0.0.1:8089/#/api?appId=e3d5e4787ff911e88b1997bee3518b4d&TOKEN=846abaf849a511eaade31d40de77539e&lang=zh_CN&menuId=null
https://blog.csdn.net/lhq186/article/details/87894440
## vue tree.
https://blog.csdn.net/joyvonlee/article/details/94739426
https://www.jianshu.com/p/bac19def4e7f
add137944a7511eaa73ab12d26068182
付款失败，修正凭证展示状态。